Lines 3273-3281
CREATE TABLE aqorders_transfers (
Link Here
|
3273 |
|
3273 |
|
3274 |
DROP TABLE IF EXISTS aqorders_claims; |
3274 |
DROP TABLE IF EXISTS aqorders_claims; |
3275 |
CREATE TABLE aqorders_claims ( |
3275 |
CREATE TABLE aqorders_claims ( |
3276 |
id int(11) AUTO_INCREMENT, |
3276 |
id int(11) AUTO_INCREMENT, -- ID of the claims |
3277 |
ordernumber INT(11) NOT NULL, |
3277 |
ordernumber INT(11) NOT NULL, -- order linked to this claim |
3278 |
claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, |
3278 |
claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Date of the claims |
3279 |
PRIMARY KEY (id), |
3279 |
PRIMARY KEY (id), |
3280 |
CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3280 |
CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3281 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
3281 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
3282 |
- |
|
|