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

(-)a/installer/data/mysql/kohastructure.sql (-13 / +12 lines)
Lines 2555-2572 CREATE TABLE `aqbasketgroups` ( Link Here
2555
--
2555
--
2556
2556
2557
DROP TABLE IF EXISTS `aqbasket`;
2557
DROP TABLE IF EXISTS `aqbasket`;
2558
CREATE TABLE `aqbasket` (
2558
CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
2559
  `basketno` int(11) NOT NULL auto_increment,
2559
  `basketno` int(11) NOT NULL auto_increment, -- primary key, Koha defined number
2560
  `basketname` varchar(50) default NULL,
2560
  `basketname` varchar(50) default NULL, -- name given to the basket at creation
2561
  `note` mediumtext,
2561
  `note` mediumtext, -- the internal note added at basket creation
2562
  `booksellernote` mediumtext,
2562
  `booksellernote` mediumtext, -- the vendor note added at basket creation
2563
  `contractnumber` int(11),
2563
  `contractnumber` int(11), -- links this basket to the aqcontract table (aqcontract.contractnumber)
2564
  `creationdate` date default NULL,
2564
  `creationdate` date default NULL, -- the date the basket was created
2565
  `closedate` date default NULL,
2565
  `closedate` date default NULL, -- the date the basket was closed
2566
  `booksellerid` int(11) NOT NULL default 1,
2566
  `booksellerid` int(11) NOT NULL default 1, -- the Koha assigned ID for the vendor (aqbooksellers.id)
2567
  `authorisedby` varchar(10) default NULL,
2567
  `authorisedby` varchar(10) default NULL, -- the borrowernumber of the person who created the basket
2568
  `booksellerinvoicenumber` mediumtext,
2568
  `booksellerinvoicenumber` mediumtext, -- appears to always be NULL
2569
  `basketgroupid` int(11),
2569
  `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id)
2570
  PRIMARY KEY  (`basketno`),
2570
  PRIMARY KEY  (`basketno`),
2571
  KEY `booksellerid` (`booksellerid`),
2571
  KEY `booksellerid` (`booksellerid`),
2572
  KEY `basketgroupid` (`basketgroupid`),
2572
  KEY `basketgroupid` (`basketgroupid`),
2573
- 

Return to bug 6716