Lines 1711-1717
CREATE TABLE `checkout_renewals` (
Link Here
|
1711 |
`seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', |
1711 |
`seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', |
1712 |
`interface` varchar(16) NOT NULL COMMENT 'the interface this renewal took place on', |
1712 |
`interface` varchar(16) NOT NULL COMMENT 'the interface this renewal took place on', |
1713 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', |
1713 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', |
1714 |
`renewal_type` varchar(9) NOT NULL COMMENT 'whether the renewal was an automatic or manual renewal', |
1714 |
`renewal_type` enum('Automatic', 'Manual') NOT NULL DEFAULT 'Manual' COMMENT 'whether the renewal was an automatic or manual renewal', |
1715 |
PRIMARY KEY (`renewal_id`), |
1715 |
PRIMARY KEY (`renewal_id`), |
1716 |
KEY `renewer_id` (`renewer_id`), |
1716 |
KEY `renewer_id` (`renewer_id`), |
1717 |
CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
1717 |
CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |