Lines 4824-4829
CREATE TABLE `subscription` (
Link Here
|
4824 |
`itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4824 |
`itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4825 |
`previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4825 |
`previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4826 |
`mana_id` int(11) DEFAULT NULL, |
4826 |
`mana_id` int(11) DEFAULT NULL, |
|
|
4827 |
`ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items', |
4827 |
PRIMARY KEY (`subscriptionid`), |
4828 |
PRIMARY KEY (`subscriptionid`), |
4828 |
KEY `subscription_ibfk_1` (`periodicity`), |
4829 |
KEY `subscription_ibfk_1` (`periodicity`), |
4829 |
KEY `subscription_ibfk_2` (`numberpattern`), |
4830 |
KEY `subscription_ibfk_2` (`numberpattern`), |
4830 |
- |
|
|