From c65eeb318a24c4ba0adfa4787429a0ff9a047403 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 Signed-off-by: Marcel de Rooy Signed-off-by: Kyle M Hall Signed-off-by: Jonathan Druart --- .../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 13b6a6a..e919349 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1652,7 +1652,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 @@ -1817,19 +1816,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` -- @@ -1839,7 +1825,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 -- 2.1.0