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;
132
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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 / +15 lines)
Lines 9656-9661 if(CheckVersion($DBversion)) { Link Here
9656
    SetVersion($DBversion);
9656
    SetVersion($DBversion);
9657
}
9657
}
9658
9658
9659
9660
$DBversion = "3.19.00.XXX";
9661
if ( CheckVersion($DBversion) ) {
9662
    $dbh->do(qq|
9663
        CREATE TABLE biblio_force_item_holds
9664
        (biblionumber int NOT NULL PRIMARY KEY);
9665
    |);
9666
    $dbh->do(qq|
9667
        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.'
9668
        WHERE variable = 'OPACItemHolds';
9669
    |);
9670
    print "Upgrade to $DBversion done (Update OPACItemHolds description)\n";
9671
    SetVersion ($DBversion);
9672
}
9673
9659
=head1 FUNCTIONS
9674
=head1 FUNCTIONS
9660
9675
9661
=head2 TableExists($table)
9676
=head2 TableExists($table)
9662
- 

Return to bug 13478