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

(-)a/installer/data/mysql/kohastructure.sql (+10 lines)
Lines 132-137 CREATE TABLE `biblio` ( -- table that stores bibliographic information Link Here
132
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
132
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
133
133
134
--
134
--
135
-- Table structure for table `biblio_force_item_holds`
136
--
137
138
DROP TABLE IF EXISTS `biblio_force_item_holds`;
139
CREATE TABLE `biblio_force_item_holds` ( -- biblios with forced item holds
140
  `biblionumber` int NOT NULL, -- primary key
141
  PRIMARY KEY  (`biblionumber`)
142
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
143
144
--
135
-- Table structure for table `biblio_framework`
145
-- Table structure for table `biblio_framework`
136
--
146
--
137
147
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
Lines 9732-9737 if ( CheckVersion($DBversion) ) { Link Here
9732
    SetVersion($DBversion);
9732
    SetVersion($DBversion);
9733
}
9733
}
9734
9734
9735
$DBversion = "3.19.00.XXX";
9736
if ( CheckVersion($DBversion) ) {
9737
    $dbh->do(qq|
9738
        CREATE TABLE biblio_force_item_holds
9739
        (biblionumber int NOT NULL PRIMARY KEY);
9740
    |);
9741
    $dbh->do(qq|
9742
        UPDATE systempreferences SET explanation = 'Allow OPAC users to place hold on specific items. If No, users can only request next available copy. If Yes, users can choose between next available and specific copy. If Force, users *must* choose a specific copy. Selectiveforce works on specific biblios.'
9743
        WHERE variable = 'OPACItemHolds';
9744
    |);
9745
    print "Upgrade to $DBversion done (Bug 13478 - Update OPACItemHolds description)\n";
9746
    SetVersion ($DBversion);
9747
}
9748
9735
=head1 FUNCTIONS
9749
=head1 FUNCTIONS
9736
9750
9737
=head2 TableExists($table)
9751
=head2 TableExists($table)
9738
- 

Return to bug 13478