|
Lines 938-952
DROP TABLE IF EXISTS `issues`;
Link Here
|
| 938 |
CREATE TABLE `issues` ( |
938 |
CREATE TABLE `issues` ( |
| 939 |
`borrowernumber` int(11) default NULL, |
939 |
`borrowernumber` int(11) default NULL, |
| 940 |
`itemnumber` int(11) default NULL, |
940 |
`itemnumber` int(11) default NULL, |
| 941 |
`date_due` date default NULL, |
941 |
`date_due` datetime 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, |
| 944 |
`returndate` date default NULL, |
944 |
`returndate` datetime default NULL, |
| 945 |
`lastreneweddate` date default NULL, |
945 |
`lastreneweddate` datetime default NULL, |
| 946 |
`return` varchar(4) default NULL, |
946 |
`return` varchar(4) default NULL, |
| 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` datetime default NULL, |
| 950 |
KEY `issuesborridx` (`borrowernumber`), |
950 |
KEY `issuesborridx` (`borrowernumber`), |
| 951 |
KEY `issuesitemidx` (`itemnumber`), |
951 |
KEY `issuesitemidx` (`itemnumber`), |
| 952 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
952 |
KEY `bordate` (`borrowernumber`,`timestamp`), |
|
Lines 1339-1353
DROP TABLE IF EXISTS `old_issues`;
Link Here
|
| 1339 |
CREATE TABLE `old_issues` ( |
1339 |
CREATE TABLE `old_issues` ( |
| 1340 |
`borrowernumber` int(11) default NULL, |
1340 |
`borrowernumber` int(11) default NULL, |
| 1341 |
`itemnumber` int(11) default NULL, |
1341 |
`itemnumber` int(11) default NULL, |
| 1342 |
`date_due` date default NULL, |
1342 |
`date_due` datetime default NULL, |
| 1343 |
`branchcode` varchar(10) default NULL, |
1343 |
`branchcode` varchar(10) default NULL, |
| 1344 |
`issuingbranch` varchar(18) default NULL, |
1344 |
`issuingbranch` varchar(18) default NULL, |
| 1345 |
`returndate` date default NULL, |
1345 |
`returndate` datetime default NULL, |
| 1346 |
`lastreneweddate` date default NULL, |
1346 |
`lastreneweddate` datetime default NULL, |
| 1347 |
`return` varchar(4) default NULL, |
1347 |
`return` varchar(4) default NULL, |
| 1348 |
`renewals` tinyint(4) default NULL, |
1348 |
`renewals` tinyint(4) default NULL, |
| 1349 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
1349 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 1350 |
`issuedate` date default NULL, |
1350 |
`issuedate` datetime default NULL, |
| 1351 |
KEY `old_issuesborridx` (`borrowernumber`), |
1351 |
KEY `old_issuesborridx` (`borrowernumber`), |
| 1352 |
KEY `old_issuesitemidx` (`itemnumber`), |
1352 |
KEY `old_issuesitemidx` (`itemnumber`), |
| 1353 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |
1353 |
KEY `old_bordate` (`borrowernumber`,`timestamp`), |