From a8e5fddd1fa27769c852b871c11febeed70db562 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 6 Jul 2012 11:30:48 +0200 Subject: [PATCH 2/3] Bug 7167: Delete 3.9 versions in the old updatedatabase.sql + Move the 3.09.00.XXX.(sql|pl) files into a 3.09 dir --- installer/data/mysql/updatedatabase.pl | 246 -------------------- installer/data/mysql/versions/3.09.00.001.sql | 3 - installer/data/mysql/versions/3.09.00.002.sql | 7 - installer/data/mysql/versions/3.09.00.003.sql | 3 - installer/data/mysql/versions/3.09.00.004.sql | 3 - installer/data/mysql/versions/3.09.00.005.pl | 28 --- installer/data/mysql/versions/3.09.00.006.sql | 9 - installer/data/mysql/versions/3.09.00.007.sql | 3 - installer/data/mysql/versions/3.09.00.008.sql | 4 - installer/data/mysql/versions/3.09.00.009.sql | 4 - installer/data/mysql/versions/3.09.00.010.sql | 3 - installer/data/mysql/versions/3.09.00.012.sql | 4 - installer/data/mysql/versions/3.09.00.013.sql | 3 - installer/data/mysql/versions/3.09.00.014.sql | 12 - installer/data/mysql/versions/3.09.00.015.sql | 3 - installer/data/mysql/versions/3.09.00.016.sql | 3 - installer/data/mysql/versions/3.09.00.017.sql | 3 - installer/data/mysql/versions/3.09.00.018.sql | 16 -- installer/data/mysql/versions/3.09/3.09.00.001.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.002.sql | 7 + installer/data/mysql/versions/3.09/3.09.00.003.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.004.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.005.pl | 28 +++ installer/data/mysql/versions/3.09/3.09.00.006.sql | 9 + installer/data/mysql/versions/3.09/3.09.00.007.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.008.sql | 4 + installer/data/mysql/versions/3.09/3.09.00.009.sql | 4 + installer/data/mysql/versions/3.09/3.09.00.010.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.012.sql | 4 + installer/data/mysql/versions/3.09/3.09.00.013.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.014.sql | 12 + installer/data/mysql/versions/3.09/3.09.00.015.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.016.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.017.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.018.sql | 16 ++ installer/data/mysql/versions/3.09/3.09.00.019.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.020.sql | 15 ++ installer/data/mysql/versions/3.09/3.09.00.021.sql | 3 + installer/data/mysql/versions/3.09/3.09.00.022.sql | 3 + 39 files changed, 135 insertions(+), 357 deletions(-) delete mode 100644 installer/data/mysql/versions/3.09.00.001.sql delete mode 100644 installer/data/mysql/versions/3.09.00.002.sql delete mode 100644 installer/data/mysql/versions/3.09.00.003.sql delete mode 100644 installer/data/mysql/versions/3.09.00.004.sql delete mode 100644 installer/data/mysql/versions/3.09.00.005.pl delete mode 100644 installer/data/mysql/versions/3.09.00.006.sql delete mode 100644 installer/data/mysql/versions/3.09.00.007.sql delete mode 100644 installer/data/mysql/versions/3.09.00.008.sql delete mode 100644 installer/data/mysql/versions/3.09.00.009.sql delete mode 100644 installer/data/mysql/versions/3.09.00.010.sql delete mode 100644 installer/data/mysql/versions/3.09.00.012.sql delete mode 100644 installer/data/mysql/versions/3.09.00.013.sql delete mode 100644 installer/data/mysql/versions/3.09.00.014.sql delete mode 100644 installer/data/mysql/versions/3.09.00.015.sql delete mode 100644 installer/data/mysql/versions/3.09.00.016.sql delete mode 100644 installer/data/mysql/versions/3.09.00.017.sql delete mode 100644 installer/data/mysql/versions/3.09.00.018.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.001.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.002.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.003.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.004.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.005.pl create mode 100644 installer/data/mysql/versions/3.09/3.09.00.006.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.007.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.008.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.009.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.010.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.012.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.013.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.014.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.015.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.016.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.017.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.018.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.019.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.020.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.021.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.022.sql create mode 100644 installer/data/mysql/versions/3.09/3.09.00.043.sql diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 97a722e..2717a0b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5213,252 +5213,6 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } -$DBversion = "3.09.00.001"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("ALTER TABLE borrower_attribute_types MODIFY category_code VARCHAR( 1 ) NULL DEFAULT NULL"); - print "Upgrade to $DBversion done. (Bug 8002: Update patron attribute types table to allow NULL category_code)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.002"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("ALTER TABLE saved_sql - ADD ( - cache_expiry INT NOT NULL DEFAULT 300, - public BOOLEAN NOT NULL DEFAULT FALSE - ); - "); - print "Upgrade to $DBversion done (Added cache_expiry and public fields in -saved_reports table.)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.003"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SvcMaxReportRows','10','Maximum number of rows to return via the report web service.',NULL,'Integer');"); - print "Upgrade to $DBversion done (Added SvcMaxReportRows syspref)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.004"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT IGNORE INTO permissions (module_bit, code, description) VALUES('13', 'edit_patrons', 'Perform batch modifivation of patrons')"); - print "Upgrade to $DBversion done (Adds permissions flag for access to the patron modifications tool)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.005"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - unless (TableExists('quotes')) { - $dbh->do( qq{ - CREATE TABLE `quotes` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `source` text DEFAULT NULL, - `text` mediumtext NOT NULL, - `timestamp` datetime NOT NULL, - PRIMARY KEY (`id`) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8 - }); - } - $dbh->do( qq{ - INSERT IGNORE INTO permissions VALUES (13, "edit_quotes","Edit quotes for quote-of-the-day feature"); - }); - $dbh->do( qq{ - INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES('QuoteOfTheDay',0,'Enable or disable display of Quote of the Day on the OPAC home page',NULL,'YesNo'); - }); - print "Upgrade to $DBversion done (Adding Quote of the Day Option.)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.006"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("UPDATE systempreferences SET - variable = 'OPACShowHoldQueueDetails', - value = CASE value WHEN '1' THEN 'priority' ELSE 'none' END, - options = 'none|priority|holds|holds_priority', - explanation = 'Show holds details in OPAC', - type = 'Choice' - WHERE variable = 'OPACDisplayRequestPriority'"); - print "Upgrade to $DBversion done (Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.007"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - unless(C4::Context->preference('ReservesControlBranch')){ - $dbh->do("INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights.','Choice')"); - } - print "Upgrade to $DBversion done (Insert ReservesControlBranch systempreference into systempreferences table )\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.008"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE sessions ADD PRIMARY KEY (id);"); - $dbh->do("ALTER TABLE sessions DROP INDEX `id`;"); - print "Upgrade to $DBversion done (redefine the field id as PRIMARY KEY of sessions)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.009"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE branches ADD PRIMARY KEY (branchcode);"); - $dbh->do("ALTER TABLE branches DROP INDEX branchcode;"); - print "Upgrade to $DBversion done (redefine the field branchcode as PRIMARY KEY of branches)\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.09.00.010"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('IssueLostItem', 'alert', 'alert|confirm|nothing', 'Defines what should be done when an attempt is made to issue an item that has been marked as lost.', 'Choice')"); - print "Upgrade to $DBversion done (Add system preference issuelostitem ))\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.011"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("ALTER TABLE `biblioitems` ADD `ean` VARCHAR( 13 ) NULL AFTER issn"); - $dbh->do("CREATE INDEX `ean` ON biblioitems (`ean`) "); - $dbh->do("ALTER TABLE `deletedbiblioitems` ADD `ean` VARCHAR( 13 ) NULL AFTER issn"); - if (C4::Context->preference("marcflavour") eq 'UNIMARC') { - $dbh->do("UPDATE marc_subfield_structure SET kohafield='biblioitems.ean' WHERE tagfield='073' and tagsubfield='a'"); - } - print "Upgrade to $DBversion done (Adding ean in biblioitems and deletedbiblioitems)\n"; - print "If you have records with ean, please run misc/batchRebuildBiblioTables.pl to populate bibliotems.ean\n" if (C4::Context->preference("marcflavour") eq 'UNIMARC'); - SetVersion($DBversion); -} - -$DBversion = "3.09.00.012"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsIntranet', '1', NULL , 'Allow holds to be suspended from the intranet.', 'YesNo')"); - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsOpac', '1', NULL , 'Allow holds to be suspended from the OPAC.', 'YesNo')"); - print "Upgrade to $DBversion done (Add system preference OpacBrowseResults ))\n"; - SetVersion($DBversion); -} - -$DBversion ="3.09.00.013"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('DefaultLanguageField008','','Fill in the default language for field 008 Range 35-37 (e.g. eng, nor, ger, see www.loc.gov/marc/languages/language_code.html)','','Free');"); - print "Upgrade to $DBversion done (Add system preference DefaultLanguageField008))\n"; - SetVersion($DBversion); -} - -$DBversion ="3.09.00.014"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - # add phone message transport type - $dbh->do("INSERT INTO message_transport_types (message_transport_type) VALUES ('phone')"); - - # adds HOLD_PHONE and PREDUE_PHONE letters (as placeholders) - $dbh->do("INSERT INTO letter (module, code, name, title, content) VALUES - ('reserves', 'HOLD_PHONE', 'Item Available for Pick-up (phone notice)', 'Item Available for Pick-up (phone notice)', 'Your item is available for pickup'), - ('circulation', 'PREDUE_PHONE', 'Advance Notice of Item Due (phone notice)', 'Advance Notice of Item Due (phone notice)', 'Your item is due soon'), - ('circulation', 'OVERDUE_PHONE', 'Overdue Notice (phone notice)', 'Overdue Notice (phone notice)', 'Your item is overdue') - "); - - # add phone notifications to patron message preferences options - $dbh->do("INSERT INTO message_transports - (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code) VALUES - (4, 'phone', 0, 'reserves', 'HOLD_PHONE'), - (2, 'phone', 0, 'circulation', 'PREDUE_PHONE') - "); - - # add TalkingTechItivaPhoneNotification syspref - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('TalkingTechItivaPhoneNotification',0,'If ON, enables Talking Tech I-tiva phone notifications',NULL,'YesNo');"); - - print "Upgrade done (Support for Talking Tech i-tiva phone notification system)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.015"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do(qq{ - INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('StatisticsFields','location|itype|ccode','Define Fields (from the items table) used for statistics members','location|itype|ccode','free') - }); - print "Upgrade to $DBversion done (Add System preference StatisticsFields)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.016"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACShowBarcode','0','Show items barcode in holding tab','','YesNo')"); - print "Upgrade to $DBversion done (Add syspref OPACShowBarcode)\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.09.00.017"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OpacNavRight', '', '70|10', 'Show the following HTML in the right hand column of the main page under the main login form', 'Textarea');"); - print "Upgrade to $DBversion done (Add customizable OpacNavRight region to the OPAC main page)\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.09.00.018"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("DROP TABLE IF EXISTS aqbudgetborrowers"); - $dbh->do(" - CREATE TABLE aqbudgetborrowers ( - budget_id int(11) NOT NULL, - borrowernumber int(11) NOT NULL, - PRIMARY KEY (budget_id, borrowernumber), - CONSTRAINT aqbudgetborrowers_ibfk_1 FOREIGN KEY (budget_id) - REFERENCES aqbudgets (budget_id) - ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT aqbudgetborrowers_ibfk_2 FOREIGN KEY (borrowernumber) - REFERENCES borrowers (borrowernumber) - ON DELETE CASCADE ON UPDATE CASCADE - ) ENGINE=InnoDB DEFAULT CHARSET=utf8; - "); - $dbh->do(" - INSERT INTO permissions (module_bit, code, description) - VALUES (11, 'budget_manage_all', 'Manage all budgets') - "); - print "Upgrade to $DBversion done (Add aqbudgetborrowers table)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.019"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OPACShowUnusedAuthorities','1','','Show authorities that are not being used in the OPAC.','YesNo')"); - print "Upgrade to $DBversion done (Add OPACShowUnusedAuthorities system preference)\n"; - SetVersion ($DBversion); -} - -$DBversion = "3.09.00.020"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,type) VALUES('EnableBorrowerFiles','0','If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo')"); - $dbh->do(" -CREATE TABLE IF NOT EXISTS borrower_files ( - file_id int(11) NOT NULL AUTO_INCREMENT, - borrowernumber int(11) NOT NULL, - file_name varchar(255) NOT NULL, - file_type varchar(255) NOT NULL, - file_description varchar(255) DEFAULT NULL, - file_content longblob NOT NULL, - date_uploaded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (file_id), - KEY borrowernumber (borrowernumber) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - "); - $dbh->do("ALTER TABLE borrower_files ADD CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE"); - - print "Upgrade to $DBversion done (Added borrow_files table, EnableBorrowerFiles syspref)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.021"; -if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UpdateTotalIssuesOnCirc','0','Whether to update the totalissues field in the biblio on each circ.',NULL,'YesNo');"); - print "Upgrade to $DBversion done (Add syspref UpdateTotalIssuesOnCirc)\n"; - SetVersion($DBversion); -} - -$DBversion = "3.09.00.022"; -if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL"); - print "Upgrade to $DBversion done (Change search_history.query_cgi type to text. bug 5981)\n"; - SetVersion($DBversion); -} - =head1 FUNCTIONS =head2 TableExists($table) diff --git a/installer/data/mysql/versions/3.09.00.001.sql b/installer/data/mysql/versions/3.09.00.001.sql deleted file mode 100644 index 0229580..0000000 --- a/installer/data/mysql/versions/3.09.00.001.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Bug 8002: Update patron attribute types table to allow NULL category_code -DELIMITER // -ALTER TABLE borrower_attribute_types MODIFY category_code VARCHAR( 1 ) NULL DEFAULT NULL// diff --git a/installer/data/mysql/versions/3.09.00.002.sql b/installer/data/mysql/versions/3.09.00.002.sql deleted file mode 100644 index 1ff975e..0000000 --- a/installer/data/mysql/versions/3.09.00.002.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Added cache_expiry and public fields in saved_reports table -DELIMITER // -ALTER TABLE saved_sql - ADD ( - cache_expiry INT NOT NULL DEFAULT 300, - public BOOLEAN NOT NULL DEFAULT FALSE - )// diff --git a/installer/data/mysql/versions/3.09.00.003.sql b/installer/data/mysql/versions/3.09.00.003.sql deleted file mode 100644 index 7907a80..0000000 --- a/installer/data/mysql/versions/3.09.00.003.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Added SvcMaxReportRows syspref -DELIMITER // -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SvcMaxReportRows','10','Maximum number of rows to return via the report web service.',NULL,'Integer')// diff --git a/installer/data/mysql/versions/3.09.00.004.sql b/installer/data/mysql/versions/3.09.00.004.sql deleted file mode 100644 index 722379f..0000000 --- a/installer/data/mysql/versions/3.09.00.004.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Adds permissions flag for access to the patron modifications tool -DELIMITER // -INSERT IGNORE INTO permissions (module_bit, code, description) VALUES('13', 'edit_patrons', 'Perform batch modifivation of patrons')// diff --git a/installer/data/mysql/versions/3.09.00.005.pl b/installer/data/mysql/versions/3.09.00.005.pl deleted file mode 100644 index 9e9b7ce..0000000 --- a/installer/data/mysql/versions/3.09.00.005.pl +++ /dev/null @@ -1,28 +0,0 @@ -#!/usr/bin/perl - -use Modern::Perl; -use C4::Context; -use C4::Update::Database; - -sub _get_queries { - my @queries; - unless ( C4::Update::Database::TableExists('quotes') ) { - push @queries, qq{ - CREATE TABLE `quotes` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `source` text DEFAULT NULL, - `text` mediumtext NOT NULL, - `timestamp` datetime NOT NULL, - PRIMARY KEY (`id`) - ) ENGINE=InnoDB DEFAULT CHARSET=utf8 - }; - } - push @queries, qq{INSERT IGNORE INTO permissions VALUES (13, "edit_quotes","Edit quotes for quote-of-the-day feature")}; - push @queries, qq{INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES('QuoteOfTheDay',0,'Enable or disable display of Quote of the Day on the OPAC home page',NULL,'YesNo')}; - - my @comments = ( - qq{Adding Quote of the Day Option} - ); - return { queries => \@queries, comments => \@comments }; -} -1; diff --git a/installer/data/mysql/versions/3.09.00.006.sql b/installer/data/mysql/versions/3.09.00.006.sql deleted file mode 100644 index c7fb610..0000000 --- a/installer/data/mysql/versions/3.09.00.006.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails -DELIMITER // -UPDATE systempreferences SET - variable = 'OPACShowHoldQueueDetails', - value = CASE value WHEN '1' THEN 'priority' ELSE 'none' END, - options = 'none|priority|holds|holds_priority', - explanation = 'Show holds details in OPAC', - type = 'Choice' - WHERE variable = 'OPACDisplayRequestPriority' diff --git a/installer/data/mysql/versions/3.09.00.007.sql b/installer/data/mysql/versions/3.09.00.007.sql deleted file mode 100644 index 7b7840d..0000000 --- a/installer/data/mysql/versions/3.09.00.007.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Insert ReservesControlBranch systempreference into systempreferences table -DELIMITER // -INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights.','Choice')// diff --git a/installer/data/mysql/versions/3.09.00.008.sql b/installer/data/mysql/versions/3.09.00.008.sql deleted file mode 100644 index 48fb5ab..0000000 --- a/installer/data/mysql/versions/3.09.00.008.sql +++ /dev/null @@ -1,4 +0,0 @@ --- redefine the field id as PRIMARY KEY of sessions -DELIMITER // -ALTER TABLE sessions ADD PRIMARY KEY (id)// -ALTER TABLE sessions DROP INDEX `id`// diff --git a/installer/data/mysql/versions/3.09.00.009.sql b/installer/data/mysql/versions/3.09.00.009.sql deleted file mode 100644 index a916049..0000000 --- a/installer/data/mysql/versions/3.09.00.009.sql +++ /dev/null @@ -1,4 +0,0 @@ --- redefine the field branchcode as PRIMARY KEY of branches -DELIMITER // -ALTER TABLE branches ADD PRIMARY KEY (branchcode)// -ALTER TABLE branches DROP INDEX branchcode// diff --git a/installer/data/mysql/versions/3.09.00.010.sql b/installer/data/mysql/versions/3.09.00.010.sql deleted file mode 100644 index 64fe04e..0000000 --- a/installer/data/mysql/versions/3.09.00.010.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Add system preference issuelostitem -DELIMITER // -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('IssueLostItem', 'alert', 'alert|confirm|nothing', 'Defines what should be done when an attempt is made to issue an item that has been marked as lost.', 'Choice')// diff --git a/installer/data/mysql/versions/3.09.00.012.sql b/installer/data/mysql/versions/3.09.00.012.sql deleted file mode 100644 index 6a69fce..0000000 --- a/installer/data/mysql/versions/3.09.00.012.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Add system preference OpacBrowseResults -DELIMITER // -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsIntranet', '1', NULL , 'Allow holds to be suspended from the intranet.', 'YesNo')// -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsOpac', '1', NULL , 'Allow holds to be suspended from the OPAC.', 'YesNo')// diff --git a/installer/data/mysql/versions/3.09.00.013.sql b/installer/data/mysql/versions/3.09.00.013.sql deleted file mode 100644 index f490aee..0000000 --- a/installer/data/mysql/versions/3.09.00.013.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Add system preference DefaultLanguageField008 -DELIMITER // -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('DefaultLanguageField008','','Fill in the default language for field 008 Range 35-37 (e.g. eng, nor, ger, see www.loc.gov/marc/languages/language_code.html)','','Free')// diff --git a/installer/data/mysql/versions/3.09.00.014.sql b/installer/data/mysql/versions/3.09.00.014.sql deleted file mode 100644 index 1a6a5d4..0000000 --- a/installer/data/mysql/versions/3.09.00.014.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Support for Talking Tech i-tiva phone notification system -DELIMITER // -INSERT INTO message_transport_types (message_transport_type) VALUES ('phone')// -INSERT INTO letter (module, code, name, title, content) VALUES - ('reserves', 'HOLD_PHONE', 'Item Available for Pick-up (phone notice)', 'Item Available for Pick-up (phone notice)', 'Your item is available for pickup'), - ('circulation', 'PREDUE_PHONE', 'Advance Notice of Item Due (phone notice)', 'Advance Notice of Item Due (phone notice)', 'Your item is due soon'), - ('circulation', 'OVERDUE_PHONE', 'Overdue Notice (phone notice)', 'Overdue Notice (phone notice)', 'Your item is overdue')// -INSERT INTO message_transports - (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code) VALUES - (4, 'phone', 0, 'reserves', 'HOLD_PHONE'), - (2, 'phone', 0, 'circulation', 'PREDUE_PHONE')// -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('TalkingTechItivaPhoneNotification',0,'If ON, enables Talking Tech I-tiva phone notifications',NULL,'YesNo')// diff --git a/installer/data/mysql/versions/3.09.00.015.sql b/installer/data/mysql/versions/3.09.00.015.sql deleted file mode 100644 index 2abfab3..0000000 --- a/installer/data/mysql/versions/3.09.00.015.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Add System preference StatisticsFields -DELIMITER // -INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('StatisticsFields','location|itype|ccode','Define Fields (from the items table) used for statistics members','location|itype|ccode','free')// diff --git a/installer/data/mysql/versions/3.09.00.016.sql b/installer/data/mysql/versions/3.09.00.016.sql deleted file mode 100644 index 4fbbc85..0000000 --- a/installer/data/mysql/versions/3.09.00.016.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Add syspref OPACShowBarcode -DELIMITER // -INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACShowBarcode','0','Show items barcode in holding tab','','YesNo')// diff --git a/installer/data/mysql/versions/3.09.00.017.sql b/installer/data/mysql/versions/3.09.00.017.sql deleted file mode 100644 index 9861086..0000000 --- a/installer/data/mysql/versions/3.09.00.017.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Add customizable OpacNavRight region to the OPAC main page -DELIMITER // -INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OpacNavRight', '', '70|10', 'Show the following HTML in the right hand column of the main page under the main login form', 'Textarea')// diff --git a/installer/data/mysql/versions/3.09.00.018.sql b/installer/data/mysql/versions/3.09.00.018.sql deleted file mode 100644 index e44662c..0000000 --- a/installer/data/mysql/versions/3.09.00.018.sql +++ /dev/null @@ -1,16 +0,0 @@ --- Add aqbudgetborrowers table -DELIMITER // -DROP TABLE IF EXISTS aqbudgetborrowers// -CREATE TABLE aqbudgetborrowers ( - budget_id int(11) NOT NULL, - borrowernumber int(11) NOT NULL, - PRIMARY KEY (budget_id, borrowernumber), - CONSTRAINT aqbudgetborrowers_ibfk_1 FOREIGN KEY (budget_id) - REFERENCES aqbudgets (budget_id) - ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT aqbudgetborrowers_ibfk_2 FOREIGN KEY (borrowernumber) - REFERENCES borrowers (borrowernumber) - ON DELETE CASCADE ON UPDATE CASCADE - ) ENGINE=InnoDB DEFAULT CHARSET=utf8// -INSERT INTO permissions (module_bit, code, description) - VALUES (11, 'budget_manage_all', 'Manage all budgets')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.001.sql b/installer/data/mysql/versions/3.09/3.09.00.001.sql new file mode 100644 index 0000000..0229580 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.001.sql @@ -0,0 +1,3 @@ +-- Bug 8002: Update patron attribute types table to allow NULL category_code +DELIMITER // +ALTER TABLE borrower_attribute_types MODIFY category_code VARCHAR( 1 ) NULL DEFAULT NULL// diff --git a/installer/data/mysql/versions/3.09/3.09.00.002.sql b/installer/data/mysql/versions/3.09/3.09.00.002.sql new file mode 100644 index 0000000..1ff975e --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.002.sql @@ -0,0 +1,7 @@ +-- Added cache_expiry and public fields in saved_reports table +DELIMITER // +ALTER TABLE saved_sql + ADD ( + cache_expiry INT NOT NULL DEFAULT 300, + public BOOLEAN NOT NULL DEFAULT FALSE + )// diff --git a/installer/data/mysql/versions/3.09/3.09.00.003.sql b/installer/data/mysql/versions/3.09/3.09.00.003.sql new file mode 100644 index 0000000..7907a80 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.003.sql @@ -0,0 +1,3 @@ +-- Added SvcMaxReportRows syspref +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SvcMaxReportRows','10','Maximum number of rows to return via the report web service.',NULL,'Integer')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.004.sql b/installer/data/mysql/versions/3.09/3.09.00.004.sql new file mode 100644 index 0000000..722379f --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.004.sql @@ -0,0 +1,3 @@ +-- Adds permissions flag for access to the patron modifications tool +DELIMITER // +INSERT IGNORE INTO permissions (module_bit, code, description) VALUES('13', 'edit_patrons', 'Perform batch modifivation of patrons')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.005.pl b/installer/data/mysql/versions/3.09/3.09.00.005.pl new file mode 100644 index 0000000..9e9b7ce --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.005.pl @@ -0,0 +1,28 @@ +#!/usr/bin/perl + +use Modern::Perl; +use C4::Context; +use C4::Update::Database; + +sub _get_queries { + my @queries; + unless ( C4::Update::Database::TableExists('quotes') ) { + push @queries, qq{ + CREATE TABLE `quotes` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `source` text DEFAULT NULL, + `text` mediumtext NOT NULL, + `timestamp` datetime NOT NULL, + PRIMARY KEY (`id`) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8 + }; + } + push @queries, qq{INSERT IGNORE INTO permissions VALUES (13, "edit_quotes","Edit quotes for quote-of-the-day feature")}; + push @queries, qq{INSERT IGNORE INTO `systempreferences` (variable,value,explanation,options,type) VALUES('QuoteOfTheDay',0,'Enable or disable display of Quote of the Day on the OPAC home page',NULL,'YesNo')}; + + my @comments = ( + qq{Adding Quote of the Day Option} + ); + return { queries => \@queries, comments => \@comments }; +} +1; diff --git a/installer/data/mysql/versions/3.09/3.09.00.006.sql b/installer/data/mysql/versions/3.09/3.09.00.006.sql new file mode 100644 index 0000000..c7fb610 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.006.sql @@ -0,0 +1,9 @@ +-- Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails +DELIMITER // +UPDATE systempreferences SET + variable = 'OPACShowHoldQueueDetails', + value = CASE value WHEN '1' THEN 'priority' ELSE 'none' END, + options = 'none|priority|holds|holds_priority', + explanation = 'Show holds details in OPAC', + type = 'Choice' + WHERE variable = 'OPACDisplayRequestPriority' diff --git a/installer/data/mysql/versions/3.09/3.09.00.007.sql b/installer/data/mysql/versions/3.09/3.09.00.007.sql new file mode 100644 index 0000000..7b7840d --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.007.sql @@ -0,0 +1,3 @@ +-- Insert ReservesControlBranch systempreference into systempreferences table +DELIMITER // +INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','PatronLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights.','Choice')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.008.sql b/installer/data/mysql/versions/3.09/3.09.00.008.sql new file mode 100644 index 0000000..48fb5ab --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.008.sql @@ -0,0 +1,4 @@ +-- redefine the field id as PRIMARY KEY of sessions +DELIMITER // +ALTER TABLE sessions ADD PRIMARY KEY (id)// +ALTER TABLE sessions DROP INDEX `id`// diff --git a/installer/data/mysql/versions/3.09/3.09.00.009.sql b/installer/data/mysql/versions/3.09/3.09.00.009.sql new file mode 100644 index 0000000..a916049 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.009.sql @@ -0,0 +1,4 @@ +-- redefine the field branchcode as PRIMARY KEY of branches +DELIMITER // +ALTER TABLE branches ADD PRIMARY KEY (branchcode)// +ALTER TABLE branches DROP INDEX branchcode// diff --git a/installer/data/mysql/versions/3.09/3.09.00.010.sql b/installer/data/mysql/versions/3.09/3.09.00.010.sql new file mode 100644 index 0000000..64fe04e --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.010.sql @@ -0,0 +1,3 @@ +-- Add system preference issuelostitem +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('IssueLostItem', 'alert', 'alert|confirm|nothing', 'Defines what should be done when an attempt is made to issue an item that has been marked as lost.', 'Choice')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.012.sql b/installer/data/mysql/versions/3.09/3.09.00.012.sql new file mode 100644 index 0000000..6a69fce --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.012.sql @@ -0,0 +1,4 @@ +-- Add system preference OpacBrowseResults +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsIntranet', '1', NULL , 'Allow holds to be suspended from the intranet.', 'YesNo')// +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('SuspendHoldsOpac', '1', NULL , 'Allow holds to be suspended from the OPAC.', 'YesNo')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.013.sql b/installer/data/mysql/versions/3.09/3.09.00.013.sql new file mode 100644 index 0000000..f490aee --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.013.sql @@ -0,0 +1,3 @@ +-- Add system preference DefaultLanguageField008 +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('DefaultLanguageField008','','Fill in the default language for field 008 Range 35-37 (e.g. eng, nor, ger, see www.loc.gov/marc/languages/language_code.html)','','Free')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.014.sql b/installer/data/mysql/versions/3.09/3.09.00.014.sql new file mode 100644 index 0000000..1a6a5d4 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.014.sql @@ -0,0 +1,12 @@ +-- Support for Talking Tech i-tiva phone notification system +DELIMITER // +INSERT INTO message_transport_types (message_transport_type) VALUES ('phone')// +INSERT INTO letter (module, code, name, title, content) VALUES + ('reserves', 'HOLD_PHONE', 'Item Available for Pick-up (phone notice)', 'Item Available for Pick-up (phone notice)', 'Your item is available for pickup'), + ('circulation', 'PREDUE_PHONE', 'Advance Notice of Item Due (phone notice)', 'Advance Notice of Item Due (phone notice)', 'Your item is due soon'), + ('circulation', 'OVERDUE_PHONE', 'Overdue Notice (phone notice)', 'Overdue Notice (phone notice)', 'Your item is overdue')// +INSERT INTO message_transports + (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code) VALUES + (4, 'phone', 0, 'reserves', 'HOLD_PHONE'), + (2, 'phone', 0, 'circulation', 'PREDUE_PHONE')// +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('TalkingTechItivaPhoneNotification',0,'If ON, enables Talking Tech I-tiva phone notifications',NULL,'YesNo')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.015.sql b/installer/data/mysql/versions/3.09/3.09.00.015.sql new file mode 100644 index 0000000..2abfab3 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.015.sql @@ -0,0 +1,3 @@ +-- Add System preference StatisticsFields +DELIMITER // +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('StatisticsFields','location|itype|ccode','Define Fields (from the items table) used for statistics members','location|itype|ccode','free')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.016.sql b/installer/data/mysql/versions/3.09/3.09.00.016.sql new file mode 100644 index 0000000..4fbbc85 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.016.sql @@ -0,0 +1,3 @@ +-- Add syspref OPACShowBarcode +DELIMITER // +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACShowBarcode','0','Show items barcode in holding tab','','YesNo')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.017.sql b/installer/data/mysql/versions/3.09/3.09.00.017.sql new file mode 100644 index 0000000..9861086 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.017.sql @@ -0,0 +1,3 @@ +-- Add customizable OpacNavRight region to the OPAC main page +DELIMITER // +INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OpacNavRight', '', '70|10', 'Show the following HTML in the right hand column of the main page under the main login form', 'Textarea')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.018.sql b/installer/data/mysql/versions/3.09/3.09.00.018.sql new file mode 100644 index 0000000..e44662c --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.018.sql @@ -0,0 +1,16 @@ +-- Add aqbudgetborrowers table +DELIMITER // +DROP TABLE IF EXISTS aqbudgetborrowers// +CREATE TABLE aqbudgetborrowers ( + budget_id int(11) NOT NULL, + borrowernumber int(11) NOT NULL, + PRIMARY KEY (budget_id, borrowernumber), + CONSTRAINT aqbudgetborrowers_ibfk_1 FOREIGN KEY (budget_id) + REFERENCES aqbudgets (budget_id) + ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT aqbudgetborrowers_ibfk_2 FOREIGN KEY (borrowernumber) + REFERENCES borrowers (borrowernumber) + ON DELETE CASCADE ON UPDATE CASCADE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8// +INSERT INTO permissions (module_bit, code, description) + VALUES (11, 'budget_manage_all', 'Manage all budgets')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.019.sql b/installer/data/mysql/versions/3.09/3.09.00.019.sql new file mode 100644 index 0000000..5d87d61 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.019.sql @@ -0,0 +1,3 @@ +-- Add OPACShowUnusedAuthorities system preference +DELIMITER // +INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OPACShowUnusedAuthorities','1','','Show authorities that are not being used in the OPAC.','YesNo')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.020.sql b/installer/data/mysql/versions/3.09/3.09.00.020.sql new file mode 100644 index 0000000..d5a1e39 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.020.sql @@ -0,0 +1,15 @@ +-- Added borrow_files table, EnableBorrowerFiles syspref +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,type) VALUES('EnableBorrowerFiles','0','If enabled, allows librarians to upload and attach arbitrary files to a borrower record.','YesNo')// +CREATE TABLE IF NOT EXISTS borrower_files ( + file_id int(11) NOT NULL AUTO_INCREMENT, + borrowernumber int(11) NOT NULL, + file_name varchar(255) NOT NULL, + file_type varchar(255) NOT NULL, + file_description varchar(255) DEFAULT NULL, + file_content longblob NOT NULL, + date_uploaded timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (file_id), + KEY borrowernumber (borrowernumber) +) ENGINE=InnoDB DEFAULT CHARSET=utf8// +ALTER TABLE borrower_files ADD CONSTRAINT borrower_files_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE// diff --git a/installer/data/mysql/versions/3.09/3.09.00.021.sql b/installer/data/mysql/versions/3.09/3.09.00.021.sql new file mode 100644 index 0000000..ba3f06b --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.021.sql @@ -0,0 +1,3 @@ +-- Add syspref UpdateTotalIssuesOnCirc +DELIMITER // +INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UpdateTotalIssuesOnCirc','0','Whether to update the totalissues field in the biblio on each circ.',NULL,'YesNo')// diff --git a/installer/data/mysql/versions/3.09/3.09.00.022.sql b/installer/data/mysql/versions/3.09/3.09.00.022.sql new file mode 100644 index 0000000..f0b1046 --- /dev/null +++ b/installer/data/mysql/versions/3.09/3.09.00.022.sql @@ -0,0 +1,3 @@ +-- Change search_history.query_cgi type to text. bug 5981 +DELIMITER // +ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL// diff --git a/installer/data/mysql/versions/3.09/3.09.00.043.sql b/installer/data/mysql/versions/3.09/3.09.00.043.sql new file mode 100644 index 0000000..e69de29 -- 1.7.7.3