|
Lines 4078-4083
CREATE TABLE `article_requests` (
Link Here
|
| 4078 |
`patron_notes` MEDIUMTEXT, |
4078 |
`patron_notes` MEDIUMTEXT, |
| 4079 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
4079 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
| 4080 |
`notes` MEDIUMTEXT, |
4080 |
`notes` MEDIUMTEXT, |
|
|
4081 |
`format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', |
| 4082 |
`urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons |
| 4081 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
4083 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
| 4082 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
4084 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 4083 |
PRIMARY KEY (`id`), |
4085 |
PRIMARY KEY (`id`), |
| 4084 |
- |
|
|