Lines 2147-2154
CREATE TABLE `subscriptionhistory` (
Link Here
|
2147 |
`histenddate` date default NULL, |
2147 |
`histenddate` date default NULL, |
2148 |
`missinglist` LONGTEXT NOT NULL, |
2148 |
`missinglist` LONGTEXT NOT NULL, |
2149 |
`recievedlist` LONGTEXT NOT NULL, |
2149 |
`recievedlist` LONGTEXT NOT NULL, |
2150 |
`opacnote` varchar(150) NOT NULL default '', |
2150 |
`opacnote` LONGTEXT NOT NULL default '', |
2151 |
`librariannote` varchar(150) NOT NULL default '', |
2151 |
`librariannote` LONGTEXT NOT NULL default '', |
2152 |
PRIMARY KEY (`subscriptionid`), |
2152 |
PRIMARY KEY (`subscriptionid`), |
2153 |
KEY `biblionumber` (`biblionumber`) |
2153 |
KEY `biblionumber` (`biblionumber`) |
2154 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2154 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2155 |
- |
|
|