Attachment #155656 for bug #31503

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




use Modern::Perl;

return {
    bug_number  => 31503,
    description => "Change patron_consent.type",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        $dbh->do(
            q{ALTER TABLE `patron_consent` MODIFY `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type'}
        );

        say $out "Changed column 'patron_consent.type'";
    },
};

Lines 4636-4642 DROP TABLE IF EXISTS `patron_consent`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
4636	CREATE TABLE `patron_consent` (	4636	CREATE TABLE `patron_consent` (
4637	`id` int(11) NOT NULL AUTO_INCREMENT,	4637	`id` int(11) NOT NULL AUTO_INCREMENT,
4638	`borrowernumber` int(11) NOT NULL,	4638	`borrowernumber` int(11) NOT NULL,
4639	`type` enum('GDPR_PROCESSING') DEFAULT NULL COMMENT 'allows for future extension',	4639	`type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type',
4640	`given_on` datetime DEFAULT NULL,	4640	`given_on` datetime DEFAULT NULL,
4641	`refused_on` datetime DEFAULT NULL,	4641	`refused_on` datetime DEFAULT NULL,
4642	PRIMARY KEY (`id`),	4642	PRIMARY KEY (`id`),
4643	-

Return to bug 31503

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug31503.pl (+16 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => 31503,
	5	description => "Change patron_consent.type",
	6	up => sub {
	7	my ($args) = @_;
	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
	9
	10	$dbh->do(
	11	q{ALTER TABLE `patron_consent` MODIFY `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type'}
	12	);
	13
	14	say $out "Changed column 'patron_consent.type'";
	15	},
	16	};