@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 15 --------------- installer/data/mysql/updatedatabase.pl | 7 +++++++ 2 files changed, 7 insertions(+), 15 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/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` -- --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -9779,6 +9779,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) --