Attachment #160244 for bug #31297

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




use Modern::Perl;

return {
    bug_number  => "31297",
    description => "Allow subscription number pattern description to be NULL",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        $dbh->do(q{
            ALTER TABLE subscription_numberpatterns MODIFY description mediumtext DEFAULT NULL
        });

        say $out "Added new table 'XXX'";
        say $out "Modified column 'subscription_numberpatterns.description' to allow and default to NULL";

    },
};

Lines 6018-6024 CREATE TABLE `subscription_numberpatterns` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
6018	`id` int(11) NOT NULL AUTO_INCREMENT,	6018	`id` int(11) NOT NULL AUTO_INCREMENT,
6019	`label` varchar(255) NOT NULL,	6019	`label` varchar(255) NOT NULL,
6020	`displayorder` int(11) DEFAULT NULL,	6020	`displayorder` int(11) DEFAULT NULL,
6021	`description` mediumtext NOT NULL,	6021	`description` mediumtext DEFAULT NULL,
6022	`numberingmethod` varchar(255) NOT NULL,	6022	`numberingmethod` varchar(255) NOT NULL,
6023	`label1` varchar(255) DEFAULT NULL,	6023	`label1` varchar(255) DEFAULT NULL,
6024	`add1` int(11) DEFAULT NULL,	6024	`add1` int(11) DEFAULT NULL,
6025	-

Return to bug 31297

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31297_allow_NULL_description_in_serial_numberpatterns.pl (+18 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "31297",
	5	description => "Allow subscription number pattern description to be NULL",
	6	up => sub {
	7	my ($args) = @_;
	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
	9
	10	$dbh->do(q{
	11	ALTER TABLE subscription_numberpatterns MODIFY description mediumtext DEFAULT NULL
	12	});
	13
	14	say $out "Added new table 'XXX'";
	15	say $out "Modified column 'subscription_numberpatterns.description' to allow and default to NULL";
	16
	17	},
	18	};