From 07efb727c70f8bc9fb9058664b14cf16abb92ce9 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 30 Jun 2015 07:34:35 -0400 Subject: [PATCH] Bug 9809 - DB Updates --- .../bug_9809-drop_table_reserveconstraints.sql | 5 +++++ installer/data/mysql/kohastructure.sql | 15 --------------- 2 files changed, 5 insertions(+), 15 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_9809-drop_table_reserveconstraints.sql diff --git a/installer/data/mysql/atomicupdate/bug_9809-drop_table_reserveconstraints.sql b/installer/data/mysql/atomicupdate/bug_9809-drop_table_reserveconstraints.sql new file mode 100644 index 0000000..7d00f0d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_9809-drop_table_reserveconstraints.sql @@ -0,0 +1,5 @@ +DROP TABLE IF EXISTS reserveconstraints; + +ALTER TABLE reserves DROP constrainttype; + +ALTER TABLE old_reserves DROP constrainttype; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 66895d1..c953405 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1653,7 +1653,6 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron this hold is for `reservedate` date default NULL, -- the date the hold was places `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bib record this hold is on - `constrainttype` varchar(1) default NULL, `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at `notificationdate` date default NULL, -- currently unused `reminderdate` date default NULL, -- currently unused @@ -1818,19 +1817,6 @@ CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --- Table structure for table `reserveconstraints` --- - -DROP TABLE IF EXISTS `reserveconstraints`; -CREATE TABLE `reserveconstraints` ( - `borrowernumber` int(11) NOT NULL default 0, - `reservedate` date default NULL, - `biblionumber` int(11) NOT NULL default 0, - `biblioitemnumber` int(11) default NULL, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -- Table structure for table `reserves` -- @@ -1840,7 +1826,6 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for `reservedate` date default NULL, -- the date the hold was places `biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on - `constrainttype` varchar(1) default NULL, `branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at `notificationdate` date default NULL, -- currently unused `reminderdate` date default NULL, -- currently unused -- 1.7.2.5