From 555a230316e96f53a77b33ad25275983482e514e Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Sat, 2 May 2020 15:28:23 +0200
Subject: [PATCH] Bug 24161: (follow-up) DB changes

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 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 7bf3657851..c7ce7be09d 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -3273,9 +3273,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.11.0