Bugzilla – Attachment 4311 Details for
Bug 6430
DB changes needed for Hourly Circulation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 6430 - DB changes needed to support hourly circ
Bug-6430---DB-changes-needed-to-support-hourly-cir.patch (text/plain), 3.98 KB, created by
Chris Cormack
on 2011-05-31 01:37:58 UTC
(
hide
)
Description:
Bug 6430 - DB changes needed to support hourly circ
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2011-05-31 01:37:58 UTC
Size:
3.98 KB
patch
obsolete
>From 7a5519088e7f9870817bfb1cb21091fee08e9f1c Mon Sep 17 00:00:00 2001 >From: Chris Cormack <chrisc@catalyst.net.nz> >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 <chrisc@catalyst.net.nz> >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 <chrisc@catalyst.net.nz> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6430
: 4311