@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_25152.perl | 6 ++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_25152.perl --- a/installer/data/mysql/atomicupdate/bug_25152.perl +++ a/installer/data/mysql/atomicupdate/bug_25152.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE subscription MODIFY COLUMN closed tinyint(1) not null default 0" ); + + NewVersion( $DBversion, 25152, "Description"); +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -1994,7 +1994,7 @@ CREATE TABLE `subscription` ( -- information related to the subscription `opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public `graceperiod` int(11) NOT NULL default '0', -- grace period in days `enddate` date default NULL, -- subscription end date - `closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed + `closed` TINYINT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed `reneweddate` date default NULL, -- date of last renewal for the subscription `itemtype` VARCHAR( 10 ) NULL, `previousitemtype` VARCHAR( 10 ) NULL, --