Lines 766-771
CREATE TABLE `article_requests` (
Link Here
|
766 |
`patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
766 |
`patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
767 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', |
767 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', |
768 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
768 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
769 |
`format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', |
770 |
`urls` MEDIUMTEXT, |
769 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
771 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
770 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
772 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
771 |
PRIMARY KEY (`id`), |
773 |
PRIMARY KEY (`id`), |
772 |
- |
|
|