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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +4 lines)
Lines 232-238 CREATE TABLE `borrowers` ( Link Here
232
  `dateexpiry` date default NULL,
232
  `dateexpiry` date default NULL,
233
  `gonenoaddress` tinyint(1) default NULL,
233
  `gonenoaddress` tinyint(1) default NULL,
234
  `lost` tinyint(1) default NULL,
234
  `lost` tinyint(1) default NULL,
235
  `debarred` tinyint(1) default NULL,
235
  `debarred` date default NULL,
236
  `debarredcomment` VARCHAR(255) DEFAULT NULL,
236
  `contactname` mediumtext,
237
  `contactname` mediumtext,
237
  `contactfirstname` text,
238
  `contactfirstname` text,
238
  `contacttitle` text,
239
  `contacttitle` text,
Lines 684-690 CREATE TABLE `deletedborrowers` ( Link Here
684
  `dateexpiry` date default NULL,
685
  `dateexpiry` date default NULL,
685
  `gonenoaddress` tinyint(1) default NULL,
686
  `gonenoaddress` tinyint(1) default NULL,
686
  `lost` tinyint(1) default NULL,
687
  `lost` tinyint(1) default NULL,
687
  `debarred` tinyint(1) default NULL,
688
  `debarred` date default NULL,
689
  `debarredcomment` VARCHAR(255) DEFAULT NULL,
688
  `contactname` mediumtext,
690
  `contactname` mediumtext,
689
  `contactfirstname` text,
691
  `contactfirstname` text,
690
  `contacttitle` text,
692
  `contacttitle` text,
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +3 lines)
Lines 4332-4343 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
4332
    SetVersion($DBversion);
4332
    SetVersion($DBversion);
4333
}
4333
}
4334
4334
4335
$DBversion = "3.05.00.002";
4335
$DBversion = "3.05.00.XXX";
4336
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
4336
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
4337
    my $borrowers = $dbh->selectcol_arrayref( "SELECT borrowernumber from borrowers where debarred <>0;", { Columns => [1] } );
4337
    my $borrowers = $dbh->selectcol_arrayref( "SELECT borrowernumber from borrowers where debarred <>0;", { Columns => [1] } );
4338
    $dbh->do("ALTER TABLE borrowers MODIFY debarred DATE DEFAULT NULL;");
4338
    $dbh->do("ALTER TABLE borrowers MODIFY debarred DATE DEFAULT NULL;");
4339
    $dbh->do( "UPDATE borrowers set debarred='9999-12-31' where borrowernumber IN (" . join( ",", @$borrowers ) . ");" ) if ($borrowers and scalar(@$borrowers)>0);
4339
    $dbh->do( "UPDATE borrowers set debarred='9999-12-31' where borrowernumber IN (" . join( ",", @$borrowers ) . ");" ) if ($borrowers and scalar(@$borrowers)>0);
4340
    $dbh->do("ALTER TABLE borrowers ADD COLUMN debarredcomment VARCHAR(255) DEFAULT NULL AFTER debarred;");
4340
    $dbh->do("ALTER TABLE borrowers ADD COLUMN debarredcomment VARCHAR(255) DEFAULT NULL AFTER debarred;");
4341
    $dbh->do("ALTER TABLE deletedborrowers MODIFY debarred DATE DEFAULT NULL;");
4342
    $dbh->do("ALTER TABLE deletedborrowers ADD COLUMN debarredcomment VARCHAR(255) DEFAULT NULL AFTER debarred;");
4341
    print "Upgrade done (Change borrowers.debarred into Date )\n";
4343
    print "Upgrade done (Change borrowers.debarred into Date )\n";
4342
4344
4343
    SetVersion($DBversion);
4345
    SetVersion($DBversion);
4344
- 

Return to bug 6328