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