|
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`; |