Attachment #93352 for bug #20589

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

Lines 87-92 __PACKAGE__->add_columns( Link Here

(-)a/Koha/Schema/Result/SearchField.pm (+4 lines)
87	{ data_type => "decimal", is_nullable => 1, size => [5, 2] },	87	{ data_type => "decimal", is_nullable => 1, size => [5, 2] },
88	"facet_order",	88	"facet_order",
89	{ data_type => "tinyint", is_nullable => 1 },	89	{ data_type => "tinyint", is_nullable => 1 },
		90	"staff_client",
		91	{ data_type => "tinyint", size => 1, is_nullable => 0, default => 1 },
		92	"opac",
		93	{ data_type => "tinyint", size => 1, is_nullable => 0, default => 1 },
90	);	94	);
91		95
92	=head1 PRIMARY KEY	96	=head1 PRIMARY KEY

Lines 71-76 __PACKAGE__->add_columns( Link Here

(-)a/Koha/Schema/Result/SearchMarcToField.pm (+2 lines)
71	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },	71	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },
72	"sort",	72	"sort",
73	{ data_type => "tinyint", is_nullable => 1 },	73	{ data_type => "tinyint", is_nullable => 1 },
		74	"search",
		75	{ data_type => "tinyint", size => 1, is_nullable => 0, default => 1 },
74	);	76	);
75		77
76	=head1 PRIMARY KEY	78	=head1 PRIMARY KEY




$DBversion = 'XXX';
if (CheckVersion($DBversion)) {
  if (!column_exists('search_marc_to_field', 'search')) {
    $dbh->do("ALTER TABLE `search_marc_to_field` ADD COLUMN `search` tinyint(1) NOT NULL DEFAULT 1");
  }
  if (!column_exists('search_field', 'staff_client')) {
    $dbh->do("ALTER TABLE `search_field` ADD COLUMN `staff_client` tinyint(1) NOT NULL DEFAULT 1");
  }
  if (!column_exists('search_field', 'opac')) {
    $dbh->do("ALTER TABLE `search_field` ADD COLUMN `opac` tinyint(1) NOT NULL DEFAULT 1");
  }
  SetVersion($DBversion)
}
print "Upgrade to $DBversion done (Bug 20589 - Add field boosting and use elastic query fields parameter instead of depricated _all)\n";

Return to bug 20589

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_20589_add_columns.perl (-1 / +14 lines)
0	-	1	$DBversion = 'XXX';
		2	if (CheckVersion($DBversion)) {
		3	if (!column_exists('search_marc_to_field', 'search')) {
		4	$dbh->do("ALTER TABLE `search_marc_to_field` ADD COLUMN `search` tinyint(1) NOT NULL DEFAULT 1");
		5	}
		6	if (!column_exists('search_field', 'staff_client')) {
		7	$dbh->do("ALTER TABLE `search_field` ADD COLUMN `staff_client` tinyint(1) NOT NULL DEFAULT 1");
		8	}
		9	if (!column_exists('search_field', 'opac')) {
		10	$dbh->do("ALTER TABLE `search_field` ADD COLUMN `opac` tinyint(1) NOT NULL DEFAULT 1");
		11	}
		12	SetVersion($DBversion)
		13	}
		14	print "Upgrade to $DBversion done (Bug 20589 - Add field boosting and use elastic query fields parameter instead of depricated _all)\n";