Lines 659-664
DROP TABLE IF EXISTS `aqorders`;
Link Here
|
659 |
CREATE TABLE `aqorders` ( |
659 |
CREATE TABLE `aqorders` ( |
660 |
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha to each line', |
660 |
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha to each line', |
661 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio being ordered (biblio.biblionumber)', |
661 |
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio being ordered (biblio.biblionumber)', |
|
|
662 |
`deleted_biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the deleted bibliographic record (deletedbiblio.biblionumber)', |
662 |
`entrydate` date DEFAULT NULL COMMENT 'the date the bib was added to the basket', |
663 |
`entrydate` date DEFAULT NULL COMMENT 'the date the bib was added to the basket', |
663 |
`quantity` smallint(6) DEFAULT NULL COMMENT 'the quantity ordered', |
664 |
`quantity` smallint(6) DEFAULT NULL COMMENT 'the quantity ordered', |
664 |
`currency` varchar(10) DEFAULT NULL COMMENT 'the currency used for the purchase', |
665 |
`currency` varchar(10) DEFAULT NULL COMMENT 'the currency used for the purchase', |
665 |
- |
|
|