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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 990-995 CREATE TABLE `issuingrules` ( Link Here
990
  `chargename` varchar(100) default NULL,
990
  `chargename` varchar(100) default NULL,
991
  `maxissueqty` int(4) default NULL,
991
  `maxissueqty` int(4) default NULL,
992
  `issuelength` int(4) default NULL,
992
  `issuelength` int(4) default NULL,
993
  `lengthunit` varchar(10) default 'days',
993
  `hardduedate` date default NULL,
994
  `hardduedate` date default NULL,
994
  `hardduedatecompare` tinyint NOT NULL default "0",
995
  `hardduedatecompare` tinyint NOT NULL default "0",
995
  `renewalsallowed` smallint(6) NOT NULL default "0",
996
  `renewalsallowed` smallint(6) NOT NULL default "0",
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +10 lines)
Lines 5019-5025 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5019
    $dbh->do("ALTER TABLE old_issues CHANGE returndate returndate datetime");
5019
    $dbh->do("ALTER TABLE old_issues CHANGE returndate returndate datetime");
5020
    $dbh->do("ALTER TABLE old_issues CHANGE lastreneweddate lastreneweddate datetime");
5020
    $dbh->do("ALTER TABLE old_issues CHANGE lastreneweddate lastreneweddate datetime");
5021
    $dbh->do("ALTER TABLE old_issues CHANGE issuedate issuedate datetime");
5021
    $dbh->do("ALTER TABLE old_issues CHANGE issuedate issuedate datetime");
5022
    $dbh->do("alter table issuingrules add column lengthunit varchar(10) default 'days' after issuelength");
5023
    print "Upgrade to $DBversion done (Setting up issues tables for hourly loans)\n";
5022
    print "Upgrade to $DBversion done (Setting up issues tables for hourly loans)\n";
5024
    SetVersion($DBversion);
5023
    SetVersion($DBversion);
5025
}
5024
}
Lines 5146-5151 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5146
    SetVersion($DBversion);
5145
    SetVersion($DBversion);
5147
}
5146
}
5148
5147
5148
5149
5150
$DBversion = "3.07.00.XXX";
5151
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
5152
    $dbh->do("alter table issuingrules add column lengthunit varchar(10) default 'days' after issuelength");
5153
    print "Upgrade to $DBversion done (Setting up issues tables for hourly loans (lengthunit fix))\n";
5154
    SetVersion($DBversion);
5155
}
5156
5157
5149
=head1 FUNCTIONS
5158
=head1 FUNCTIONS
5150
5159
5151
=head2 DropAllForeignKeys($table)
5160
=head2 DropAllForeignKeys($table)
5152
- 

Return to bug 5549