Lines 936-943
CREATE TABLE `import_items` (
Link Here
|
936 |
|
936 |
|
937 |
DROP TABLE IF EXISTS `issues`; |
937 |
DROP TABLE IF EXISTS `issues`; |
938 |
CREATE TABLE `issues` ( |
938 |
CREATE TABLE `issues` ( |
939 |
`borrowernumber` int(11) default NULL, |
939 |
`borrowernumber` int(11), |
940 |
`itemnumber` int(11) default NULL, |
940 |
`itemnumber` int(11), |
941 |
`date_due` date default NULL, |
941 |
`date_due` date default NULL, |
942 |
`branchcode` varchar(10) default NULL, |
942 |
`branchcode` varchar(10) default NULL, |
943 |
`issuingbranch` varchar(18) default NULL, |
943 |
`issuingbranch` varchar(18) default NULL, |
Lines 947-957
CREATE TABLE `issues` (
Link Here
|
947 |
`renewals` tinyint(4) default NULL, |
947 |
`renewals` tinyint(4) default NULL, |
948 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
948 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
949 |
`issuedate` date default NULL, |
949 |
`issuedate` date default NULL, |
|
|
950 |
PRIMARY KEY (`itemnumber`), |
950 |
KEY `issuesborridx` (`borrowernumber`), |
951 |
KEY `issuesborridx` (`borrowernumber`), |
951 |
KEY `issuesitemidx` (`itemnumber`), |
|
|
952 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
952 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
953 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL, |
953 |
CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`), |
954 |
CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL |
954 |
CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
955 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
955 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
956 |
|
956 |
|
957 |
-- |
957 |
-- |
Lines 2098-2104
CREATE TABLE `serialitems` (
Link Here
|
2098 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2098 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2099 |
KEY `serialitems_sfk_1` (`serialid`), |
2099 |
KEY `serialitems_sfk_1` (`serialid`), |
2100 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2100 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2101 |
CONSTRAINT serialitems_sfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE |
2101 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2102 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2102 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2103 |
|
2103 |
|
2104 |
DROP TABLE IF EXISTS `user_permissions`; |
2104 |
DROP TABLE IF EXISTS `user_permissions`; |