From 98706270cd732c7282a6d855221ef3d9dda1182b Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 30 Oct 2013 02:40:14 +0000 Subject: [PATCH] Bug 7688: (follow-up) correct SQL to create the subscription table Columns referring to a foreign key must have matching types. Signed-off-by: Galen Charlton --- 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 56a78c1dc8..17615c5788 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2040,7 +2040,7 @@ CREATE TABLE `subscription` ( `weeklength` int(11) default 0, `monthlength` int(11) default 0, `numberlength` int(11) default 0, - `periodicity` tinyint(4) default 0, + `periodicity` integer default null, countissuesperunit INTEGER NOT NULL DEFAULT 1, `notes` mediumtext, `status` varchar(100) NOT NULL default '', @@ -2055,7 +2055,7 @@ CREATE TABLE `subscription` ( `irregularity` text, skip_serialseq BOOLEAN NOT NULL DEFAULT 0, `letter` varchar(20) default NULL, - `numberpattern` tinyint(3) default 0, + `numberpattern` integer default null, locale VARCHAR(80) DEFAULT NULL, `distributedto` text, `internalnotes` longtext, -- 2.20.1