Lines 2532-2538
CREATE TABLE `alert` (
Link Here
|
2532 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2532 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2533 |
|
2533 |
|
2534 |
-- |
2534 |
-- |
2535 |
-- Table structure for table `aqbasketgroups` |
2535 |
-- Table structure for table `basketgroups` |
2536 |
-- |
2536 |
-- |
2537 |
|
2537 |
|
2538 |
DROP TABLE IF EXISTS `aqbasketgroups`; |
2538 |
DROP TABLE IF EXISTS `aqbasketgroups`; |
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 |
- |
|
|