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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 127-132 CREATE TABLE `biblio` ( -- table that stores bibliographic information Link Here
127
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
127
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
128
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
128
  `datecreated` DATE NOT NULL, -- the date this record was added to Koha
129
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
129
  `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21)
130
  `force_item_holds` tinyint, -- works if pref OPACItemHolds is set to 'Selectively force'
130
  PRIMARY KEY  (`biblionumber`),
131
  PRIMARY KEY  (`biblionumber`),
131
  KEY `blbnoidx` (`biblionumber`)
132
  KEY `blbnoidx` (`biblionumber`)
132
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
133
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +13 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
        ALTER TABLE biblio ADD COLUMN force_item_holds tinyint;
9800
    |);
9801
    $dbh->do(qq|
9802
        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.'
9803
        WHERE variable = 'OPACItemHolds';
9804
    |);
9805
    print "Upgrade to $DBversion done (Bug 13478 - Update OPACItemHolds description)\n";
9806
    SetVersion ($DBversion);
9807
}
9808
9796
=head1 FUNCTIONS
9809
=head1 FUNCTIONS
9797
9810
9798
=head2 TableExists($table)
9811
=head2 TableExists($table)
9799
- 

Return to bug 13478