Attachment 40733 Details for Bug 9809 – Bug 9809 - DB Updates

[patch] Bug 9809 - DB Updates

Bug-9809---DB-Updates.patch (text/plain), 3.23 KB, created by Kyle M Hall (khall) on 2015-06-30 12:56:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2015-06-30 12:56:31 UTC

Size: 3.23 KB

patch

obsolete

>From 07efb727c70f8bc9fb9058664b14cf16abb92ce9 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 9809: 37638 | 40733 | 40734 | 40735 | 40736 | 40737 | 40738 | 41754 | 41755 | 41756 | 41757 | 41758 | 41759 | 41760 | 41761 | 41767 | 41768 | 41769 | 41770 | 41771 | 41772 | 41773 | 41774 | 41809 | 41810 | 41811 | 41812 | 41813 | 41814 | 41815 | 41816 | 41817 | 41845 | 41848 | 41849 | 41850 | 41851 | 41852 | 41892 | 41893 | 41894 | 41895 | 41896 | 41897 | 41898 | 41899 | 41900 | 41901 | 41902 | 41903