From a37675ac7ecaf2ae64b8602f80af997c18c06d77 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 18 Jan 2015 22:41:23 +0100 Subject: [PATCH] Bug 13539 - Remove unused table patroncards It appears that the table patroncards hasn't been used since the database updates for the rewritten label modules ('3.01.00.107'). It's time to remove them from the database. As the patron card batches were needed for printing and the data has not been accessible in a long time, it seems safe to delete it. Signed-off-by: Brendan Gallagher Signed-off-by: Jonathan Druart --- installer/data/mysql/kohastructure.sql | 15 --------------- installer/data/mysql/updatedatabase.pl | 7 +++++++ 2 files changed, 7 insertions(+), 15 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 08ef9ee..6611775 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1715,21 +1715,6 @@ CREATE TABLE `overduerules` ( -- overdue notice status and triggers ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --- Table structure for table `patroncards` --- - -DROP TABLE IF EXISTS `patroncards`; -CREATE TABLE `patroncards` ( - `cardid` int(11) NOT NULL auto_increment, - `batch_id` varchar(10) NOT NULL default '1', - `borrowernumber` int(11) NOT NULL, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - PRIMARY KEY (`cardid`), - KEY `patroncards_ibfk_1` (`borrowernumber`), - CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -- Table structure for table `patronimage` -- diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 0ed56c6..a475a6d 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9793,6 +9793,13 @@ if(CheckVersion($DBversion)) { SetVersion($DBversion); } +$DBversion = "3.19.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(qq|DROP table patroncards;|); + print "Upgrade to $DBversion done (Bug 13539 - Remove table patroncards from database as it's no longer in use)\n"; + SetVersion ($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 2.1.0