Attachment #117147 for bug #8976

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {

    unless ( column_exists( 'marc_subfield_structure', 'display_order' ) ) {
        $dbh->do(q{
            ALTER TABLE marc_subfield_structure
            ADD COLUMN display_order INT(2) NOT NULL DEFAULT 0 AFTER maxlength
        });
    }

    # Always end with this (adjust the bug info)
    NewVersion( $DBversion, XXXXX, "Description");
}

Lines 3454-3459 CREATE TABLE `marc_subfield_structure` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
3454	`link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3454	`link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3455	`defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3455	`defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3456	`maxlength` int(4) NOT NULL DEFAULT 9999,	3456	`maxlength` int(4) NOT NULL DEFAULT 9999,
		3457	`display_order` int(2) NOT NULL DEFAULT 0,
3457	PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),	3458	PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
3458	KEY `kohafield_2` (`kohafield`),	3459	KEY `kohafield_2` (`kohafield`),
3459	KEY `tab` (`frameworkcode`,`tab`),	3460	KEY `tab` (`frameworkcode`,`tab`),
3460	-

Return to bug 8976

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_8976.perl (+13 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	unless ( column_exists( 'marc_subfield_structure', 'display_order' ) ) {
	5	$dbh->do(q{
	6	ALTER TABLE marc_subfield_structure
	7	ADD COLUMN display_order INT(2) NOT NULL DEFAULT 0 AFTER maxlength
	8	});
	9	}
	10
	11	# Always end with this (adjust the bug info)
	12	NewVersion( $DBversion, XXXXX, "Description");
	13	}