MT 2050, Follow-up, Fast Cataloging

[koha.git] / installer / data / mysql / updatedatabase.pl

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index f40e3dd..ea7f84a 100755 (executable)
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2771,31 +2771,8 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        print "Upgrade done (Adding finedays renewalsallowed, and reservesallowed fields in issuingrules table)\n";
 }
 
-$DBversion = "3.01.00.069";
-if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
-       $dbh->do(<<SUGGESTIONS);
-       ALTER table suggestions 
-               ADD budgetid INT(11),
-               ADD branchcode VARCHAR(10) default NULL,
-               ADD acceptedby INT(11) default NULL,
-               ADD acceptedon date default NULL,
-               ADD suggestedby INT(11) default NULL,
-               ADD suggestedon date default NULL,
-               ADD managedby INT(11) default NULL,
-               ADD managedon date default NULL,
-               ADD rejectedby INT(11) default NULL,
-               ADD rejectedon date default NULL,
-               ADD collectiontitle text default NULL,
-               ADD itemtype VARCHAR(30) default NULL,
-               ADD biblionumber INT(11) default NULL,
-               ADD sort1 VARCHAR(80) default NULL,
-               ADD sort2 VARCHAR(80) default NULL
-               ;
-SUGGESTIONS
-       print "Add some fields to suggestions";
-}
 
-$DBversion = "3.01.00.070";
+$DBversion = "3.01.00.069";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        $dbh->do("INSERT INTO `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) VALUES ('EnableOpacSearchHistory', '1', '', 'Enable or disable opac search history', 'YesNo')");
 
@@ -2822,7 +2799,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        print "Upgrade done (Added a lib_opac field in authorised_values table)\n";
 }
 
-$DBversion = "3.01.00.072";
+$DBversion = "3.01.00.071";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        $dbh->do("ALTER TABLE `subscription` ADD `enddate` date default NULL");
        $dbh->do("ALTER TABLE subscriptionhistory CHANGE enddate histenddate DATE default NULL");
@@ -3140,24 +3117,18 @@ $DBversion = "3.01.00.114";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
     $dbh->do(<<SUGGESTIONS);
 ALTER table suggestions 
-       ADD budgetid INT(11),
-       ADD branchcode VARCHAR(10) default NULL,
-       ADD acceptedby INT(11) default NULL,
-       ADD acceptedon date default NULL,
-       ADD suggestedby INT(11) default NULL,
-       ADD suggestedon date default NULL,
-       ADD managedby INT(11) default NULL,
-       ADD managedon date default NULL,
-       ADD rejectedby INT(11) default NULL,
-       ADD rejectedon date default NULL,
-       ADD collectiontitle text default NULL,
-       ADD itemtype VARCHAR(30) default NULL,
-       ADD biblionumber INT(11) default NULL,
-       ADD sort1 VARCHAR(80) default NULL,
-       ADD sort2 VARCHAR(80) default NULL
-       ;
+    ADD budgetid INT(11),
+    ADD branchcode VARCHAR(10) default NULL,
+    ADD acceptedby INT(11) default NULL,
+    ADD accepteddate date default NULL,
+    ADD suggesteddate date default NULL,
+    ADD manageddate date default NULL,
+    ADD rejectedby INT(11) default NULL,
+    ADD rejecteddate date default NULL,
+    ADD collectiontitle text default NULL,
+    ADD itemtype VARCHAR(30) default NULL,
+    ;
 SUGGESTIONS
-
     print "Upgrade to $DBversion done Suggestions";
     SetVersion ($DBversion);
 }
@@ -3257,7 +3228,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        ALTER TABLE aqbasketgroups ADD deliveryplace VARCHAR(10) default NULL, ADD deliverycomment VARCHAR(255) default NULL;
        });
        
-    print "Upgrade to $DBversion done (isbd updated)\n";
+    print "Upgrade to $DBversion done (adding deliveryplace deliverycomment to basketgroups)\n";
     SetVersion ($DBversion);
 }
 
@@ -3294,7 +3265,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
 
 $DBversion = "3.01.00.125";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
-    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('OrderPdfTemplate','','Uploads a PDF template','NULL','Upload')");
+    $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('OrderPdfTemplate','','Uploads a PDF template to use for printing baskets','NULL','Upload')");
     $dbh->do("UPDATE systempreferences SET variable='OrderPdfFormat' WHERE variable='pdfformat'");
     print "Upgrade to $DBversion done (PDF orders system preferences added and updated)\n";
     SetVersion ($DBversion);
@@ -3306,7 +3277,29 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
        ALTER TABLE aqbasketgroups ADD billingplace VARCHAR(10) NOT NULL AFTER deliverycomment;
        });
        
-    print "Upgrade to $DBversion done (isbd updated)\n";
+    print "Upgrade to $DBversion done (Adding billingplace to aqbasketgroups)\n";
+    SetVersion ($DBversion);
+}
+
+$DBversion = "3.01.00.128";
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+       $dbh->do(qq{
+       ALTER TABLE auth_subfield_structure MODIFY frameworkcode VARCHAR(10) NULL;
+       });
+       
+    print "Upgrade to $DBversion done (changing frameworkcode length in auth_subfield_structure)\n";
+    SetVersion ($DBversion);
+}
+
+$DBversion = "3.01.00.128";
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+       $dbh->do(qq{
+               INSERT INTO `permissions` (`module_bit`, `code`, `description`) VALUES
+                (9, 'edit_catalogue', 'Edit catalogue'),
+               (9, 'fast_cataloging', 'Fast cataloging')
+       });
+       
+    print "Upgrade to $DBversion done (granular permissions for cataloging added)\n";
     SetVersion ($DBversion);
 }