Lines 1703-1715
DROP TABLE IF EXISTS `checkout_renewals`;
Link Here
|
1703 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1703 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
1704 |
/*!40101 SET character_set_client = utf8 */; |
1704 |
/*!40101 SET character_set_client = utf8 */; |
1705 |
CREATE TABLE `checkout_renewals` ( |
1705 |
CREATE TABLE `checkout_renewals` ( |
1706 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1706 |
`renewal_id` int(11) NOT NULL AUTO_INCREMENT, |
1707 |
`issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to', |
1707 |
`checkout_id` int(11) DEFAULT NULL COMMENT 'the id of the checkout this renewal pertains to', |
1708 |
`renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal', |
1708 |
`renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal', |
1709 |
`seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', |
1709 |
`seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', |
1710 |
`interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on', |
1710 |
`interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on', |
1711 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', |
1711 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', |
1712 |
PRIMARY KEY (`id`), |
1712 |
PRIMARY KEY (`renewal_id`), |
1713 |
KEY `renewer_id` (`renewer_id`), |
1713 |
KEY `renewer_id` (`renewer_id`), |
1714 |
CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
1714 |
CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
1715 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1715 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1716 |
- |
|
|