Attachment #163685 for bug #36396

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




use Modern::Perl;

return {
    bug_number  => "36396",
    description => "Link elastic facets with authorized value categories",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        $dbh->do(q{
            ALTER TABLE search_field
            ADD COLUMN `authorised_value_category` varchar(32) DEFAULT NULL
            AFTER mandatory
        });
    },
};

Lines 5611-5616 CREATE TABLE `search_field` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_36396.pl (+16 lines)
	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	};