From 5ef3c21dc5fe1535b605c1788fb635b188041a12 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Oct 2015 09:42:36 +0100 Subject: [PATCH] [PASSED QA] Bug 10363: (follow-up) DB update - change in kohastructure.sql Signed-off-by: Katrin Fischer --- 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 c36a792..9f12618 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; -- 1.9.1