From 1a3102ce910eeef26884d4519d813f92677baeea Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Wed, 11 Jul 2012 23:13:27 -0400 Subject: [PATCH] Bug 6716: Document aqorders_items table --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f71142394a..57e3dcffd7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2784,10 +2784,10 @@ CREATE TABLE `aqorders` ( --information related to the basket line items -- DROP TABLE IF EXISTS `aqorders_items`; -CREATE TABLE `aqorders_items` ( - `ordernumber` int(11) NOT NULL, - `itemnumber` int(11) NOT NULL, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, +CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisitions process + `ordernumber` int(11) NOT NULL, -- the order this item is attached to (aqorders.ordernumber) + `itemnumber` int(11) NOT NULL, -- the item number for this item (items.itemnumber) + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched PRIMARY KEY (`itemnumber`), KEY `ordernumber` (`ordernumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.5