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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 2784-2793 CREATE TABLE `aqorders` ( Link Here
2784
--
2784
--
2785
2785
2786
DROP TABLE IF EXISTS `aqorders_items`;
2786
DROP TABLE IF EXISTS `aqorders_items`;
2787
CREATE TABLE `aqorders_items` (
2787
CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisitions process
2788
  `ordernumber` int(11) NOT NULL,
2788
  `ordernumber` int(11) NOT NULL, -- the order this item is attached to (aqorders.ordernumber)
2789
  `itemnumber` int(11) NOT NULL,
2789
  `itemnumber` int(11) NOT NULL, -- the item number for this item (items.itemnumber)
2790
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2790
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched
2791
  PRIMARY KEY  (`itemnumber`),
2791
  PRIMARY KEY  (`itemnumber`),
2792
  KEY `ordernumber` (`ordernumber`)
2792
  KEY `ordernumber` (`ordernumber`)
2793
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2793
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2794
- 

Return to bug 6716