Lines 1401-1430
CREATE TABLE `search_marc_to_field` (
Link Here
|
1401 |
FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE |
1401 |
FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE |
1402 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1402 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1403 |
|
1403 |
|
1404 |
-- |
|
|
1405 |
-- Table structure for table `serial` |
1406 |
-- |
1407 |
|
1408 |
DROP TABLE IF EXISTS `serial`; |
1409 |
CREATE TABLE `serial` ( -- issues related to subscriptions |
1410 |
`serialid` int(11) NOT NULL auto_increment, -- unique key for the issue |
1411 |
`biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to |
1412 |
`subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of |
1413 |
`serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) |
1414 |
`serialseq_x` varchar( 100 ) NULL DEFAULT NULL, -- first part of issue information |
1415 |
`serialseq_y` varchar( 100 ) NULL DEFAULT NULL, -- second part of issue information |
1416 |
`serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information |
1417 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1418 |
`planneddate` date default NULL, -- date expected |
1419 |
`notes` MEDIUMTEXT, -- notes |
1420 |
`publisheddate` date default NULL, -- date published |
1421 |
publisheddatetext varchar(100) default NULL, -- date published (descriptive) |
1422 |
`claimdate` date default NULL, -- date claimed |
1423 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1424 |
`routingnotes` MEDIUMTEXT, -- notes from the routing list |
1425 |
PRIMARY KEY (`serialid`) |
1426 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1427 |
|
1428 |
-- |
1404 |
-- |
1429 |
-- Table structure for table `sessions` |
1405 |
-- Table structure for table `sessions` |
1430 |
-- |
1406 |
-- |
Lines 1937-1943
CREATE TABLE subscription_numberpatterns (
Link Here
|
1937 |
|
1913 |
|
1938 |
DROP TABLE IF EXISTS `subscription`; |
1914 |
DROP TABLE IF EXISTS `subscription`; |
1939 |
CREATE TABLE `subscription` ( -- information related to the subscription |
1915 |
CREATE TABLE `subscription` ( -- information related to the subscription |
1940 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key for biblio.biblionumber that this subscription is attached to |
1916 |
`biblionumber` int(11) NOT NULL, -- foreign key for biblio.biblionumber that this subscription is attached to |
1941 |
`subscriptionid` int(11) NOT NULL auto_increment, -- unique key for this subscription |
1917 |
`subscriptionid` int(11) NOT NULL auto_increment, -- unique key for this subscription |
1942 |
`librarian` varchar(100) default '', -- the librarian's username from borrowers.userid |
1918 |
`librarian` varchar(100) default '', -- the librarian's username from borrowers.userid |
1943 |
`startdate` date default NULL, -- start date for this subscription |
1919 |
`startdate` date default NULL, -- start date for this subscription |
Lines 1981-1989
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
1981 |
`previousitemtype` VARCHAR( 10 ) NULL, |
1957 |
`previousitemtype` VARCHAR( 10 ) NULL, |
1982 |
`mana_id` int(11) NULL DEFAULT NULL, |
1958 |
`mana_id` int(11) NULL DEFAULT NULL, |
1983 |
PRIMARY KEY (`subscriptionid`), |
1959 |
PRIMARY KEY (`subscriptionid`), |
1984 |
KEY `by_biblionumber` (`biblionumber`), |
|
|
1985 |
CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, |
1960 |
CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, |
1986 |
CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE |
1961 |
CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
1962 |
CONSTRAINT subscription_ibfk_3 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
1963 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1964 |
|
1965 |
-- |
1966 |
-- Table structure for table `serial` |
1967 |
-- |
1968 |
|
1969 |
DROP TABLE IF EXISTS `serial`; |
1970 |
CREATE TABLE `serial` ( -- issues related to subscriptions |
1971 |
`serialid` int(11) NOT NULL auto_increment, -- unique key for the issue |
1972 |
`biblionumber` int(11) NOT NULL, -- foreign key for the biblio.biblionumber that this issue is attached to |
1973 |
`subscriptionid` int(11) NOT NULL, -- foreign key to the subscription.subscriptionid that this issue is part of |
1974 |
`serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) |
1975 |
`serialseq_x` varchar( 100 ) NULL DEFAULT NULL, -- first part of issue information |
1976 |
`serialseq_y` varchar( 100 ) NULL DEFAULT NULL, -- second part of issue information |
1977 |
`serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information |
1978 |
`status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) |
1979 |
`planneddate` date default NULL, -- date expected |
1980 |
`notes` MEDIUMTEXT, -- notes |
1981 |
`publisheddate` date default NULL, -- date published |
1982 |
publisheddatetext varchar(100) default NULL, -- date published (descriptive) |
1983 |
`claimdate` date default NULL, -- date claimed |
1984 |
claims_count int(11) default 0, -- number of claims made related to this issue |
1985 |
`routingnotes` MEDIUMTEXT, -- notes from the routing list |
1986 |
PRIMARY KEY (`serialid`), |
1987 |
CONSTRAINT serial_ibfk_1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE, |
1988 |
CONSTRAINT serial_ibfk_2 FOREIGN KEY (subscriptionid) REFERENCES subscription (subscriptionid) ON DELETE CASCADE ON UPDATE CASCADE |
1987 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1989 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1988 |
|
1990 |
|
1989 |
-- |
1991 |
-- |
Lines 1992-1999
CREATE TABLE `subscription` ( -- information related to the subscription
Link Here
|
1992 |
|
1994 |
|
1993 |
DROP TABLE IF EXISTS `subscriptionhistory`; |
1995 |
DROP TABLE IF EXISTS `subscriptionhistory`; |
1994 |
CREATE TABLE `subscriptionhistory` ( |
1996 |
CREATE TABLE `subscriptionhistory` ( |
1995 |
`biblionumber` int(11) NOT NULL default 0, |
1997 |
`biblionumber` int(11) NOT NULL, |
1996 |
`subscriptionid` int(11) NOT NULL default 0, |
1998 |
`subscriptionid` int(11) NOT NULL, |
1997 |
`histstartdate` date default NULL, |
1999 |
`histstartdate` date default NULL, |
1998 |
`histenddate` date default NULL, |
2000 |
`histenddate` date default NULL, |
1999 |
`missinglist` LONGTEXT NOT NULL, |
2001 |
`missinglist` LONGTEXT NOT NULL, |
Lines 2001-2007
CREATE TABLE `subscriptionhistory` (
Link Here
|
2001 |
`opacnote` LONGTEXT NULL, |
2003 |
`opacnote` LONGTEXT NULL, |
2002 |
`librariannote` LONGTEXT NULL, |
2004 |
`librariannote` LONGTEXT NULL, |
2003 |
PRIMARY KEY (`subscriptionid`), |
2005 |
PRIMARY KEY (`subscriptionid`), |
2004 |
KEY `biblionumber` (`biblionumber`) |
2006 |
CONSTRAINT subscription_history_ibfk_1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
2007 |
CONSTRAINT subscription_history_ibfk_2 FOREIGN KEY (subscriptionid) REFERENCES subscription (subscriptionid) ON DELETE CASCADE ON UPDATE CASCADE |
2005 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2008 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2006 |
|
2009 |
|
2007 |
-- |
2010 |
-- |