Lines 4866-4871
CREATE TABLE `subscription` (
Link Here
|
4866 |
`itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4866 |
`itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4867 |
`previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4867 |
`previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4868 |
`mana_id` int(11) DEFAULT NULL, |
4868 |
`mana_id` int(11) DEFAULT NULL, |
|
|
4869 |
`ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items', |
4869 |
PRIMARY KEY (`subscriptionid`), |
4870 |
PRIMARY KEY (`subscriptionid`), |
4870 |
KEY `subscription_ibfk_1` (`periodicity`), |
4871 |
KEY `subscription_ibfk_1` (`periodicity`), |
4871 |
KEY `subscription_ibfk_2` (`numberpattern`), |
4872 |
KEY `subscription_ibfk_2` (`numberpattern`), |
4872 |
- |
|
|