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