From 66a3c1057b1f3a29d37132d755a9df3f4f683e40 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Oct 2015 09:42:36 +0100 Subject: [PATCH] Bug 10363: (follow-up) DB update - change in kohastructure.sql Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c36a7920dc..9f12618a9b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3239,8 +3239,8 @@ CREATE TABLE categories_branches( -- association table between categories and br DROP TABLE IF EXISTS authorised_values_branches; CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches - av_id INTEGER, - branchcode VARCHAR(10), + av_id INT(11) NOT NULL, + branchcode VARCHAR(10) NOT NULL, FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE, FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 2.39.5