From d2d980cd75b54d06d867bf9ac03ab6fb74a59717 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 --- 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 d6732a3..7d81d1f 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3249,8 +3249,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.1.0