|
Lines 2982-2988
CREATE TABLE `erm_agreements` (
Link Here
|
| 2982 |
`closure_reason` varchar(80) DEFAULT NULL COMMENT 'reason of the closure', |
2982 |
`closure_reason` varchar(80) DEFAULT NULL COMMENT 'reason of the closure', |
| 2983 |
`is_perpetual` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the agreement perpetual', |
2983 |
`is_perpetual` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the agreement perpetual', |
| 2984 |
`renewal_priority` varchar(80) DEFAULT NULL COMMENT 'priority of the renewal', |
2984 |
`renewal_priority` varchar(80) DEFAULT NULL COMMENT 'priority of the renewal', |
| 2985 |
`license_info` varchar(80) DEFAULT NULL COMMENT 'info about the license', |
2985 |
`license_info` mediumtext DEFAULT NULL COMMENT 'info about the license', |
| 2986 |
PRIMARY KEY (`agreement_id`), |
2986 |
PRIMARY KEY (`agreement_id`), |
| 2987 |
KEY `erm_agreements_ibfk_1` (`vendor_id`), |
2987 |
KEY `erm_agreements_ibfk_1` (`vendor_id`), |
| 2988 |
CONSTRAINT `erm_agreements_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
2988 |
CONSTRAINT `erm_agreements_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
| 2989 |
- |
|
|