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 9832-9837 if ( CheckVersion($DBversion) ) { Link Here
9832
    SetVersion($DBversion);
9832
    SetVersion($DBversion);
9833
}
9833
}
9834
9834
9835
$DBversion = "3.19.00.XXX";
9836
if ( CheckVersion($DBversion) ) {
9837
    $dbh->do(qq|
9838
        ALTER TABLE biblio ADD COLUMN force_item_holds tinyint;
9839
    |);
9840
    $dbh->do(qq|
9841
        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.'
9842
        WHERE variable = 'OPACItemHolds';
9843
    |);
9844
    print "Upgrade to $DBversion done (Bug 13478 - Update OPACItemHolds description)\n";
9845
    SetVersion ($DBversion);
9846
}
9847
9835
=head1 FUNCTIONS
9848
=head1 FUNCTIONS
9836
9849
9837
=head2 TableExists($table)
9850
=head2 TableExists($table)
9838
- 

Return to bug 13478