View | Details | Raw Unified | Return to bug 25152
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_25152.perl (+6 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "ALTER TABLE subscription MODIFY COLUMN closed tinyint(1) not null default 0" );
4
5
    NewVersion( $DBversion, 25152, "Description");
6
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1994-2000 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
1994
  `opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public
1994
  `opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public
1995
  `graceperiod` int(11) NOT NULL default '0', -- grace period in days
1995
  `graceperiod` int(11) NOT NULL default '0', -- grace period in days
1996
  `enddate` date default NULL, -- subscription end date
1996
  `enddate` date default NULL, -- subscription end date
1997
  `closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed
1997
  `closed` TINYINT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed
1998
  `reneweddate` date default NULL, -- date of last renewal for the subscription
1998
  `reneweddate` date default NULL, -- date of last renewal for the subscription
1999
  `itemtype` VARCHAR( 10 ) NULL,
1999
  `itemtype` VARCHAR( 10 ) NULL,
2000
  `previousitemtype` VARCHAR( 10 ) NULL,
2000
  `previousitemtype` VARCHAR( 10 ) NULL,
2001
- 

Return to bug 25152