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