@@ -, +, @@ Bug 5549 backing out of decision to change the name of the colums 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(-) --- a/installer/data/mysql/kohastructure.sql +++ a/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`), --- a/installer/data/mysql/updatedatabase.pl +++ a/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) --