Lines 3698-3703
$DBversion = "3.01.00.145";
Link Here
|
3698 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
3698 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
3699 |
$dbh->do("ALTER TABLE borrowers ADD KEY `guarantorid` (guarantorid);"); |
3699 |
$dbh->do("ALTER TABLE borrowers ADD KEY `guarantorid` (guarantorid);"); |
3700 |
print "Upgrade to $DBversion done (Add index on guarantorid)\n"; |
3700 |
print "Upgrade to $DBversion done (Add index on guarantorid)\n"; |
|
|
3701 |
} |
3702 |
$DBversion = '3.01.00.146'; |
3703 |
if (C4::Context->preference("Version") < TransformToNum($DBversion)) { |
3704 |
$dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('ShowAuctionSearchOptions', '0', 'If ON, includes specialized auction catalog/house/date searches in advanced search (staff and OPAC)', '', 'YesNo')"); |
3705 |
$dbh->do("INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES |
3706 |
('591', 'AUCTION HOUSE', 'AUCTION HOUSE', 1, 0, NULL, ''), |
3707 |
('592', 'DATE OF AUCTION SALE', 'DATE OF AUCTION SALE', 1, 0, NULL, ''), |
3708 |
('593', 'AUCTION SALES CODE', 'AUCTION SALES CODE', 1, 0, NULL, '')"); |
3709 |
$dbh->do("INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value` , `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES |
3710 |
('591', 'a', 'AUCTION HOUSE', 'AUCTION HOUSE', 0, 0, NULL, 5, NULL, NULL, '', NULL, 0, '', '', '', NULL), |
3711 |
('592', 'a', 'DATE OF AUCTION SALE', 'DATE OF AUCTION SALE', 0, 0, NULL, 5, NULL, NULL, '', NULL, 0, '', '', '', NULL), |
3712 |
('593', 'a', 'AUCTION SALES CODE', 'AUCTION SALES CODE', 0, 0, NULL, 5, NULL, NULL, '', NULL, 0, '', '', '', NULL)"); |
3713 |
print "Upgrade to $DBversion done ( Added 591, 592, 593 fields into default framework for use with auction house/date/sales code indexes )\n"; |
3701 |
SetVersion ($DBversion); |
3714 |
SetVersion ($DBversion); |
3702 |
} |
3715 |
} |
3703 |
|
3716 |
|