update for missing subscriptions.lastbranch col in serials

[koha_fer] / updater / updatedatabase

diff --git a/updater/updatedatabase b/updater/updatedatabase
index 00f138d..f8f7c59 100755 (executable)
--- a/updater/updatedatabase
+++ b/updater/updatedatabase
@@ -425,6 +425,14 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
               ) ENGINE=InnoDB DEFAULT CHARSET=utf8");
     SetVersion ($DBversion);
 }
+
+$DBversion = "3.00.00.014";
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+       $dbh->do("ALTER TABLE subscription ADD lastbranch VARCHAR(4)");
+    print "Upgrade to $DBversion done (userid index added)\n";
+    SetVersion ($DBversion);
+}
+
 =item DropAllForeignKeys($table)
 
   Drop all foreign keys of the table $table