Lines 3211-3218
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3211 |
`sort1_authcat` varchar(10) default NULL, |
3211 |
`sort1_authcat` varchar(10) default NULL, |
3212 |
`sort2_authcat` varchar(10) default NULL, |
3212 |
`sort2_authcat` varchar(10) default NULL, |
3213 |
`uncertainprice` tinyint(1), -- was this price uncertain (1 for yes, 0 for no) |
3213 |
`uncertainprice` tinyint(1), -- was this price uncertain (1 for yes, 0 for no) |
3214 |
`claims_count` int(11) default 0, -- count of claim letters generated |
|
|
3215 |
`claimed_date` date default NULL, -- last date a claim was generated |
3216 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
3214 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
3217 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
3215 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
3218 |
`orderstatus` varchar(16) default 'new', -- the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' |
3216 |
`orderstatus` varchar(16) default 'new', -- the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' |
Lines 3277-3282
CREATE TABLE aqorders_transfers (
Link Here
|
3277 |
CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE |
3275 |
CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE |
3278 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3276 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3279 |
|
3277 |
|
|
|
3278 |
-- |
3279 |
-- Table structure for table aqorders_claims |
3280 |
-- |
3281 |
|
3282 |
DROP TABLE IF EXISTS aqorders_claims; |
3283 |
CREATE TABLE aqorders_claims ( |
3284 |
id int(11) AUTO_INCREMENT, |
3285 |
ordernumber INT(11) NOT NULL, |
3286 |
claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, |
3287 |
PRIMARY KEY (id), |
3288 |
CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3289 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
3280 |
|
3290 |
|
3281 |
-- |
3291 |
-- |
3282 |
-- Table structure for table `transport_cost` |
3292 |
-- Table structure for table `transport_cost` |
3283 |
- |
|
|