From e294eb1dd7965347fcbcb4aecb81d3eb4140232c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Sat, 2 May 2020 15:28:23 +0200 Subject: [PATCH] Bug 24161: (follow-up) DB changes Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize --- installer/data/mysql/kohastructure.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c7490f2423..347b340ad1 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3274,9 +3274,9 @@ CREATE TABLE aqorders_transfers ( DROP TABLE IF EXISTS aqorders_claims; CREATE TABLE aqorders_claims ( - id int(11) AUTO_INCREMENT, - ordernumber INT(11) NOT NULL, - claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, + id int(11) AUTO_INCREMENT, -- ID of the claims + ordernumber INT(11) NOT NULL, -- order linked to this claim + claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Date of the claims PRIMARY KEY (id), CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- 2.20.1