View | Details | Raw Unified | Return to bug 26535
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-4 lines)
Lines 1635-1642 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1635
  `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
1635
  `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
1636
  PRIMARY KEY (`issue_id`),
1636
  PRIMARY KEY (`issue_id`),
1637
  UNIQUE KEY `itemnumber` (`itemnumber`),
1637
  UNIQUE KEY `itemnumber` (`itemnumber`),
1638
  KEY `issuesborridx` (`borrowernumber`),
1639
  KEY `itemnumber_idx` (`itemnumber`),
1640
  KEY `branchcode_idx` (`branchcode`),
1638
  KEY `branchcode_idx` (`branchcode`),
1641
  KEY `bordate` (`borrowernumber`,`timestamp`),
1639
  KEY `bordate` (`borrowernumber`,`timestamp`),
1642
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,
1640
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,
Lines 1666-1672 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1666
  `notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss)
1664
  `notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss)
1667
  `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
1665
  `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null
1668
  PRIMARY KEY (`issue_id`),
1666
  PRIMARY KEY (`issue_id`),
1669
  KEY `old_issuesborridx` (`borrowernumber`),
1670
  KEY `old_issuesitemidx` (`itemnumber`),
1667
  KEY `old_issuesitemidx` (`itemnumber`),
1671
  KEY `branchcode_idx` (`branchcode`),
1668
  KEY `branchcode_idx` (`branchcode`),
1672
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
1669
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
1673
- 

Return to bug 26535