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

(-)a/Koha/Schema/Result/SearchField.pm (+4 lines)
Lines 87-92 __PACKAGE__->add_columns( Link Here
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
(-)a/Koha/Schema/Result/SearchMarcToField.pm (+2 lines)
Lines 71-76 __PACKAGE__->add_columns( Link Here
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
(-)a/installer/data/mysql/atomicupdate/bug_20589_add_columns.perl (-1 / +14 lines)
Line 0 Link Here
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";

Return to bug 20589