From 7a5519088e7f9870817bfb1cb21091fee08e9f1c Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Tue, 31 May 2011 13:35:14 +1200 Subject: [PATCH] Bug 6430 - DB changes needed to support hourly circ Changing columns to datetime instead of date Squashed commit of the following: commit ccf37880eaf660685d439b000298dcc025e78b6e Author: Chris Cormack Date: Thu May 26 12:06:24 2011 +1200 Bug 5549 backing out of decision to change the name of the colums commit 2e326fdec7d768fe93d41e93abf3ca665a363791 Author: Chris Cormack Date: Tue May 24 14:31:26 2011 +1200 Bug 5549 : Starting work on hourly loans, changing issues table --- installer/data/mysql/kohastructure.sql | 16 ++++++++-------- installer/data/mysql/updatedatabase.pl | 16 ++++++++++++++++ 2 files changed, 24 insertions(+), 8 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e3c6f42..a39fcfc 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -938,15 +938,15 @@ DROP TABLE IF EXISTS `issues`; CREATE TABLE `issues` ( `borrowernumber` int(11) default NULL, `itemnumber` int(11) default NULL, - `date_due` date default NULL, + `date_due` datetime default NULL, `branchcode` varchar(10) default NULL, `issuingbranch` varchar(18) default NULL, - `returndate` date default NULL, - `lastreneweddate` date default NULL, + `returndate` datetime default NULL, + `lastreneweddate` datetime default NULL, `return` varchar(4) default NULL, `renewals` tinyint(4) default NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `issuedate` date default NULL, + `issuedate` datetime default NULL, KEY `issuesborridx` (`borrowernumber`), KEY `issuesitemidx` (`itemnumber`), KEY `bordate` (`borrowernumber`,`timestamp`), @@ -1339,15 +1339,15 @@ DROP TABLE IF EXISTS `old_issues`; CREATE TABLE `old_issues` ( `borrowernumber` int(11) default NULL, `itemnumber` int(11) default NULL, - `date_due` date default NULL, + `date_due` datetime default NULL, `branchcode` varchar(10) default NULL, `issuingbranch` varchar(18) default NULL, - `returndate` date default NULL, - `lastreneweddate` date default NULL, + `returndate` datetime default NULL, + `lastreneweddate` datetime default NULL, `return` varchar(4) default NULL, `renewals` tinyint(4) default NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `issuedate` date default NULL, + `issuedate` datetime default NULL, KEY `old_issuesborridx` (`borrowernumber`), KEY `old_issuesitemidx` (`itemnumber`), KEY `old_bordate` (`borrowernumber`,`timestamp`), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 52951e7..8906892 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4332,6 +4332,22 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.05.00.XXX"; +if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { + $dbh->do("ALTER TABLE issues CHANGE date_due date_due datetime"); + $dbh->do("ALTER TABLE issues CHANGE returndate returndate datetime"); + $dbh->do("ALTER TABLE issues CHANGE lastreneweddate lastreneweddate datetime"); + $dbh->do("ALTER TABLE issues CHANGE issuedate issuedate datetime"); + $dbh->do("ALTER TABLE old_issues CHANGE date_due date_due datetime"); + $dbh->do("ALTER TABLE old_issues CHANGE returndate returndate datetime"); + $dbh->do("ALTER TABLE old_issues CHANGE lastreneweddate lastreneweddate datetime"); + $dbh->do("ALTER TABLE old_issues CHANGE issuedate issuedate datetime"); + print "Upgrade to $DBversion done (Setting up issues tables for hourly loans)\n"; + SetVersion($DBversion); +} + + + =head1 FUNCTIONS =head2 DropAllForeignKeys($table) -- 1.7.4.1