[Koha-patches] [PATCH] Bug 6716: Document the aqbasket table
Nicole C. Engard
nengard at bywatersolutions.com
Thu Jul 12 03:48:21 CEST 2012
---
installer/data/mysql/kohastructure.sql | 26 +++++++++++++-------------
1 files changed, 13 insertions(+), 13 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 3b9827a..e0b3792 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -2532,7 +2532,7 @@ CREATE TABLE `alert` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--- Table structure for table `aqbasketgroups`
+-- Table structure for table `basketgroups`
--
DROP TABLE IF EXISTS `aqbasketgroups`;
@@ -2555,18 +2555,18 @@ CREATE TABLE `aqbasketgroups` (
--
DROP TABLE IF EXISTS `aqbasket`;
-CREATE TABLE `aqbasket` (
- `basketno` int(11) NOT NULL auto_increment,
- `basketname` varchar(50) default NULL,
- `note` mediumtext,
- `booksellernote` mediumtext,
- `contractnumber` int(11),
- `creationdate` date default NULL,
- `closedate` date default NULL,
- `booksellerid` int(11) NOT NULL default 1,
- `authorisedby` varchar(10) default NULL,
- `booksellerinvoicenumber` mediumtext,
- `basketgroupid` int(11),
+CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
+ `basketno` int(11) NOT NULL auto_increment, -- primary key, Koha defined number
+ `basketname` varchar(50) default NULL, -- name given to the basket at creation
+ `note` mediumtext, -- the internal note added at basket creation
+ `booksellernote` mediumtext, -- the vendor note added at basket creation
+ `contractnumber` int(11), -- links this basket to the aqcontract table (aqcontract.contractnumber)
+ `creationdate` date default NULL, -- the date the basket was created
+ `closedate` date default NULL, -- the date the basket was closed
+ `booksellerid` int(11) NOT NULL default 1, -- the Koha assigned ID for the vendor (aqbooksellers.id)
+ `authorisedby` varchar(10) default NULL, -- the borrowernumber of the person who created the basket
+ `booksellerinvoicenumber` mediumtext, -- appears to always be NULL
+ `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id)
PRIMARY KEY (`basketno`),
KEY `booksellerid` (`booksellerid`),
KEY `basketgroupid` (`basketgroupid`),
--
1.7.2.3
More information about the Koha-patches
mailing list