View | Details | Raw Unified | Return to bug 24161
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
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
- 

Return to bug 24161