Bugzilla – Attachment 10667 Details for
Bug 7167
updatedatabase improvements
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7167: Delete 3.9 versions in the old updatedatabase.sql
0002-Bug-7167-Delete-3.9-versions-in-the-old-updatedataba.patch (text/plain), 42.47 KB, created by
Jonathan Druart
on 2012-07-06 10:55:44 UTC
(
hide
)
Description:
Bug 7167: Delete 3.9 versions in the old updatedatabase.sql
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2012-07-06 10:55:44 UTC
Size:
42.47 KB
patch
obsolete
>From a8e5fddd1fa27769c852b871c11febeed70db562 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >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 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7167
:
6377
|
6378
|
6379
|
6381
|
6414
|
6415
|
6416
|
6476
|
6477
|
6478
|
6479
|
6722
|
6832
|
7903
|
8178
|
9859
|
9860
|
9861
|
9862
|
10033
|
10034
|
10549
|
10666
|
10667
|
10668
|
10825
|
11129
|
11222
|
11223
|
11224
|
11225
|
11226
|
11227
|
11228
|
11229
|
11230
|
11231
|
11232
|
11235
|
11236
|
11237
|
11238
|
11239
|
11240
|
11241
|
11242
|
11243
|
11244
|
11245
|
11246
|
11571
|
13423
|
13424
|
13425
|
13426
|
13427
|
13428
|
13429
|
13430
|
13431
|
13432
|
13433
|
13434
|
13435
|
13436
|
13437
|
13456
|
13457
|
13509
|
13516
|
13517
|
13518
|
13519
|
13520
|
13521
|
13522
|
13523
|
13524
|
13525
|
13526
|
13527
|
13528
|
13529
|
13733
|
13734
|
13842
|
13845
|
13848
|
13851
|
13852
|
13853
|
13854
|
14310
|
16113
|
16114
|
16115
|
16116
|
16117
|
16596