Attachment #114492 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 1068-1073 CREATE TABLE `marc_subfield_structure` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
1068	`link` varchar(80) default NULL,	1068	`link` varchar(80) default NULL,
1069	`defaultvalue` MEDIUMTEXT default NULL,	1069	`defaultvalue` MEDIUMTEXT default NULL,
1070	`maxlength` int(4) NOT NULL DEFAULT '9999',	1070	`maxlength` int(4) NOT NULL DEFAULT '9999',
		1071	`display_order` int(2) NOT NULL DEFAULT 0,
1071	PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),	1072	PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
1072	KEY `kohafield_2` (`kohafield`),	1073	KEY `kohafield_2` (`kohafield`),
1073	KEY `tab` (`frameworkcode`,`tab`),	1074	KEY `tab` (`frameworkcode`,`tab`),
1074	-

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	}