Lines 2098-2103
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
2098 |
`itemtype` VARCHAR( 10 ) NULL, |
2098 |
`itemtype` VARCHAR( 10 ) NULL, |
2099 |
`previousitemtype` VARCHAR( 10 ) NULL, |
2099 |
`previousitemtype` VARCHAR( 10 ) NULL, |
2100 |
PRIMARY KEY (`subscriptionid`), |
2100 |
PRIMARY KEY (`subscriptionid`), |
|
|
2101 |
KEY `by_biblionumber` (`biblionumber`), |
2101 |
CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, |
2102 |
CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, |
2102 |
CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE |
2103 |
CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE |
2103 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2104 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2104 |
- |
|
|