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

(-)a/installer/data/mysql/kohastructure.sql (+3 lines)
Lines 1123-1128 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1123
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1123
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1124
  `return` varchar(4) default NULL,
1124
  `return` varchar(4) default NULL,
1125
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1125
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1126
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1126
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1127
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1127
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1128
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1128
  KEY `issuesborridx` (`borrowernumber`),
1129
  KEY `issuesborridx` (`borrowernumber`),
Lines 1160-1165 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1160
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
1161
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
1161
  `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
1162
  `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
1162
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
1163
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
1164
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1163
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1165
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1164
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1166
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1165
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1167
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
Lines 1594-1599 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1594
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1596
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1595
  `return` varchar(4) default NULL,
1597
  `return` varchar(4) default NULL,
1596
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1598
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1599
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1597
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1600
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1598
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1601
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1599
  KEY `old_issuesborridx` (`borrowernumber`),
1602
  KEY `old_issuesborridx` (`borrowernumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 8577-8582 if ( CheckVersion($DBversion) ) { Link Here
8577
    SetVersion ($DBversion);
8577
    SetVersion ($DBversion);
8578
}
8578
}
8579
8579
8580
$DBversion = "3.17.00.XXX";
8581
if(CheckVersion($DBversion)) {
8582
    $dbh->do(q{
8583
        ALTER TABLE issues ADD auto_renew BOOLEAN default FALSE AFTER renewals
8584
    });
8585
    $dbh->do(q{
8586
        ALTER TABLE old_issues ADD auto_renew BOOLEAN default FALSE AFTER renewals
8587
    });
8588
    $dbh->do(q{
8589
        ALTER TABLE issuingrules ADD auto_renew BOOLEAN default FALSE AFTER norenewalbefore
8590
    });
8591
    print "Upgrade to $DBversion done (Bug 11577: [ENH] Automatic renewal feature)\n";
8592
    SetVersion($DBversion);
8593
}
8594
8580
=head1 FUNCTIONS
8595
=head1 FUNCTIONS
8581
8596
8582
=head2 TableExists($table)
8597
=head2 TableExists($table)
8583
- 

Return to bug 11577