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

(-)a/installer/data/mysql/atomicupdate/bug_36396.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "36396",
5
    description => "Link elastic facets with authorized value categories",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{
11
            ALTER TABLE search_field
12
            ADD COLUMN `authorised_value_category` varchar(32) DEFAULT NULL
13
            AFTER mandatory
14
        });
15
    },
16
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5611-5616 CREATE TABLE `search_field` ( Link Here
5611
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
5611
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
5612
  `opac` tinyint(1) NOT NULL DEFAULT 1,
5612
  `opac` tinyint(1) NOT NULL DEFAULT 1,
5613
  `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
5613
  `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
5614
  `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'link to authorised value category',
5614
  PRIMARY KEY (`id`),
5615
  PRIMARY KEY (`id`),
5615
  UNIQUE KEY `name` (`name`(191))
5616
  UNIQUE KEY `name` (`name`(191))
5616
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5617
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5617
- 

Return to bug 36396