Lines 3977-3984
CREATE TABLE `article_requests` (
Link Here
|
3977 |
`patron_notes` MEDIUMTEXT, |
3977 |
`patron_notes` MEDIUMTEXT, |
3978 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3978 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3979 |
`notes` MEDIUMTEXT, |
3979 |
`notes` MEDIUMTEXT, |
3980 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3980 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
3981 |
`updated_on` timestamp NULL DEFAULT NULL, |
3981 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3982 |
PRIMARY KEY (`id`), |
3982 |
PRIMARY KEY (`id`), |
3983 |
KEY `borrowernumber` (`borrowernumber`), |
3983 |
KEY `borrowernumber` (`borrowernumber`), |
3984 |
KEY `biblionumber` (`biblionumber`), |
3984 |
KEY `biblionumber` (`biblionumber`), |
3985 |
- |
|
|