Attachment 36153 Details for Bug 13539 – Bug 13539 - Remove unused table patroncards

[patch] Bug 13539 - Remove unused table patroncards

Bug-13539---Remove-unused-table-patroncards.patch (text/plain), 2.39 KB, created by Brendan Gallagher on 2015-02-25 05:24:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Brendan Gallagher

Created: 2015-02-25 05:24:31 UTC

Size: 2.39 KB

patch

obsolete

>From 1a7aafbde36dcaef8bf38dd9d710a6456d7073bc Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <Katrin.Fischer.83@web.de>
>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 <brendan@bywatersolutions.com>
>---
> 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 cd83f99..0461c68 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 47930ab..fbb3904 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/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)
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 13539: 35351 | 36153 | 36158 | 37769