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 9793-9798 if(CheckVersion($DBversion)) { Link Here
9793
    SetVersion($DBversion);
9793
    SetVersion($DBversion);
9794
}
9794
}
9795
9795
9796
$DBversion = "3.19.00.XXX";
9797
if ( CheckVersion($DBversion) ) {
9798
    $dbh->do(qq|
9799
        CREATE TABLE biblio_force_item_holds
9800
        (biblionumber int NOT NULL PRIMARY KEY);
9801
    |);
9802
    $dbh->do(qq|
9803
        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.'
9804
        WHERE variable = 'OPACItemHolds';
9805
    |);
9806
    print "Upgrade to $DBversion done (Bug 13478 - Update OPACItemHolds description)\n";
9807
    SetVersion ($DBversion);
9808
}
9809
9796
=head1 FUNCTIONS
9810
=head1 FUNCTIONS
9797
9811
9798
=head2 TableExists($table)
9812
=head2 TableExists($table)
9799
- 

Return to bug 13478