Lines 3944-3951
CREATE TABLE `article_requests` (
Link Here
|
3944 |
`patron_notes` MEDIUMTEXT, |
3944 |
`patron_notes` MEDIUMTEXT, |
3945 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3945 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
3946 |
`notes` MEDIUMTEXT, |
3946 |
`notes` MEDIUMTEXT, |
3947 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3947 |
`created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL |
3948 |
`updated_on` timestamp NULL DEFAULT NULL, |
3948 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3949 |
PRIMARY KEY (`id`), |
3949 |
PRIMARY KEY (`id`), |
3950 |
KEY `borrowernumber` (`borrowernumber`), |
3950 |
KEY `borrowernumber` (`borrowernumber`), |
3951 |
KEY `biblionumber` (`biblionumber`), |
3951 |
KEY `biblionumber` (`biblionumber`), |
3952 |
- |
|
|