Lines 4063-4068
CREATE TABLE `article_requests` (
Link Here
|
4063 |
`patron_notes` MEDIUMTEXT, |
4063 |
`patron_notes` MEDIUMTEXT, |
4064 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
4064 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
4065 |
`notes` MEDIUMTEXT, |
4065 |
`notes` MEDIUMTEXT, |
|
|
4066 |
`format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', |
4067 |
`urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons |
4066 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
4068 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
4067 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
4069 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
4068 |
PRIMARY KEY (`id`), |
4070 |
PRIMARY KEY (`id`), |
4069 |
- |
|
|