From 8bf34cc104add68d614c3bc5398c856632d47c7e Mon Sep 17 00:00:00 2001 From: bob_lyon Date: Tue, 11 Apr 2006 22:08:06 +0000 Subject: [PATCH] Altered the subscription table changed issues length column from tinyint as it only allows numbers up to 127 - needs to allow bigger numbers if the sub you're making is for a daily subscription like a newspaper where the number of issues in a year will be greater than 127 --- misc/koha.mysql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/koha.mysql b/misc/koha.mysql index bd64390e83..a656b24d33 100644 --- a/misc/koha.mysql +++ b/misc/koha.mysql @@ -1160,7 +1160,7 @@ CREATE TABLE subscription ( aqbudgetid int(11) default '0', weeklength tinyint(4) default '0', monthlength tinyint(4) default '0', - numberlength tinyint(4) default '0', + numberlength smallint(4) default '0', periodicity tinyint(4) default '0', dow varchar(100) default '', numberingmethod varchar(100) default '', -- 2.39.2