Lines 3174-3181
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3174 |
`sort1_authcat` varchar(10) default NULL, |
3174 |
`sort1_authcat` varchar(10) default NULL, |
3175 |
`sort2_authcat` varchar(10) default NULL, |
3175 |
`sort2_authcat` varchar(10) default NULL, |
3176 |
`uncertainprice` tinyint(1), -- was this price uncertain (1 for yes, 0 for no) |
3176 |
`uncertainprice` tinyint(1), -- was this price uncertain (1 for yes, 0 for no) |
3177 |
`claims_count` int(11) default 0, -- count of claim letters generated |
|
|
3178 |
`claimed_date` date default NULL, -- last date a claim was generated |
3179 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
3177 |
`subscriptionid` int(11) default NULL, -- links this order line to a subscription (subscription.subscriptionid) |
3180 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
3178 |
parent_ordernumber int(11) default NULL, -- ordernumber of parent order line, or same as ordernumber if no parent |
3181 |
`orderstatus` varchar(16) default 'new', -- the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' |
3179 |
`orderstatus` varchar(16) default 'new', -- the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' |
Lines 3240-3245
CREATE TABLE aqorders_transfers (
Link Here
|
3240 |
CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE |
3238 |
CONSTRAINT aqorders_transfers_ordernumber_to FOREIGN KEY (ordernumber_to) REFERENCES aqorders (ordernumber) ON DELETE SET NULL ON UPDATE CASCADE |
3241 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3239 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3242 |
|
3240 |
|
|
|
3241 |
-- |
3242 |
-- Table structure for table aqorders_claims |
3243 |
-- |
3244 |
|
3245 |
DROP TABLE IF EXISTS aqorders_claims; |
3246 |
CREATE TABLE aqorders_claims ( |
3247 |
id int(11) AUTO_INCREMENT, |
3248 |
ordernumber INT(11) NOT NULL, |
3249 |
claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, |
3250 |
PRIMARY KEY (id), |
3251 |
CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3252 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
3243 |
|
3253 |
|
3244 |
-- |
3254 |
-- |
3245 |
-- Table structure for table `transport_cost` |
3255 |
-- Table structure for table `transport_cost` |
3246 |
- |
|
|