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

(-)a/installer/data/mysql/atomicupdate/bug_36396.pl (+18 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(
11
            q{
12
            ALTER TABLE search_field
13
            ADD COLUMN `authorised_value_category` varchar(32) DEFAULT NULL
14
            AFTER mandatory
15
        }
16
        );
17
    },
18
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5653-5658 CREATE TABLE `search_field` ( Link Here
5653
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
5653
  `staff_client` tinyint(1) NOT NULL DEFAULT 1,
5654
  `opac` tinyint(1) NOT NULL DEFAULT 1,
5654
  `opac` tinyint(1) NOT NULL DEFAULT 1,
5655
  `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
5655
  `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable',
5656
  `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'link to authorised value category',
5656
  PRIMARY KEY (`id`),
5657
  PRIMARY KEY (`id`),
5657
  UNIQUE KEY `name` (`name`(191))
5658
  UNIQUE KEY `name` (`name`(191))
5658
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5659
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5659
- 

Return to bug 36396