Lines 1927-1934
CREATE TABLE `subscriptionhistory` (
Link Here
|
1927 |
`histenddate` date default NULL, |
1927 |
`histenddate` date default NULL, |
1928 |
`missinglist` longtext NOT NULL, |
1928 |
`missinglist` longtext NOT NULL, |
1929 |
`recievedlist` longtext NOT NULL, |
1929 |
`recievedlist` longtext NOT NULL, |
1930 |
`opacnote` varchar(150) NOT NULL default '', |
1930 |
`opacnote` text NOT NULL default '', |
1931 |
`librariannote` varchar(150) NOT NULL default '', |
1931 |
`librariannote` text NOT NULL default '', |
1932 |
PRIMARY KEY (`subscriptionid`), |
1932 |
PRIMARY KEY (`subscriptionid`), |
1933 |
KEY `biblionumber` (`biblionumber`) |
1933 |
KEY `biblionumber` (`biblionumber`) |
1934 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1934 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |