View | Details | Raw Unified | Return to bug 13539
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-15 lines)
Lines 1715-1735 CREATE TABLE `overduerules` ( -- overdue notice status and triggers Link Here
1715
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1715
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1716
1716
1717
--
1717
--
1718
-- Table structure for table `patroncards`
1719
--
1720
1721
DROP TABLE IF EXISTS `patroncards`;
1722
CREATE TABLE `patroncards` (
1723
  `cardid` int(11) NOT NULL auto_increment,
1724
  `batch_id` varchar(10) NOT NULL default '1',
1725
  `borrowernumber` int(11) NOT NULL,
1726
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1727
   PRIMARY KEY  (`cardid`),
1728
   KEY `patroncards_ibfk_1` (`borrowernumber`),
1729
   CONSTRAINT `patroncards_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
1730
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1731
1732
--
1733
-- Table structure for table `patronimage`
1718
-- Table structure for table `patronimage`
1734
--
1719
--
1735
1720
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 9779-9784 if ( CheckVersion($DBversion) ) { Link Here
9779
    SetVersion ($DBversion);
9779
    SetVersion ($DBversion);
9780
}
9780
}
9781
9781
9782
$DBversion = "3.19.00.XXX";
9783
if ( CheckVersion($DBversion) ) {
9784
    $dbh->do(qq|DROP table patroncards;|);
9785
    print "Upgrade to $DBversion done (Bug 13539 - Remove table patroncards from database as it's no longer in use)\n";
9786
    SetVersion ($DBversion);
9787
}
9788
9782
=head1 FUNCTIONS
9789
=head1 FUNCTIONS
9783
9790
9784
=head2 TableExists($table)
9791
=head2 TableExists($table)
9785
- 

Return to bug 13539