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

(-)a/installer/data/mysql/atomicupdate/bug_30498.pl (+11 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => 30498,
5
    description => "Correct enum search_field.type",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do( q|ALTER TABLE search_field MODIFY COLUMN `type` enum('','string','date','number','boolean','sum','isbn','stdno','year') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine'| );
10
    },
11
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4512-4518 CREATE TABLE `search_field` ( Link Here
4512
  `id` int(11) NOT NULL AUTO_INCREMENT,
4512
  `id` int(11) NOT NULL AUTO_INCREMENT,
4513
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
4513
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
4514
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the human readable name of the field, for display',
4514
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the human readable name of the field, for display',
4515
  `type` enum('','string','date','number','boolean','sum','isbn','stdno') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
4515
  `type` enum('','string','date','number','boolean','sum','isbn','stdno','year') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
4516
  `weight` decimal(5,2) DEFAULT NULL,
4516
  `weight` decimal(5,2) DEFAULT NULL,
4517
  `facet_order` tinyint(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
4517
  `facet_order` tinyint(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
4518
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
4518
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
4519
- 

Return to bug 30498