|
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 |
|