Attachment #85769 for bug #22395

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




            ADD COLUMN class_split_rule varchar(10) NOT NULL default ''
            AFTER class_sort_rule
        |);

        $dbh->do(q|
            UPDATE class_sources
            SET class_split_rule = class_sort_rule
        |);

        $dbh->do(q|
            UPDATE class_sources
            SET class_split_rule = 'generic'
            WHERE class_split_rule NOT IN('dewey', 'generic', 'lcc')
        |);

        $dbh->do(q|
            INSERT INTO class_split_rules(class_split_rule, description, split_routine)
            VALUES
            ('dewey', 'Default sorting rules for DDC', 'Dewey'),
- 

Return to bug 22395

Lines 17081-17092 if( CheckVersion( $DBversion ) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
17081	ADD COLUMN class_split_rule varchar(10) NOT NULL default ''	17081	ADD COLUMN class_split_rule varchar(10) NOT NULL default ''
17082	AFTER class_sort_rule	17082	AFTER class_sort_rule
17083	\|);	17083	\|);
		17084
17084	$dbh->do(q\|	17085	$dbh->do(q\|
17085	UPDATE class_sources	17086	UPDATE class_sources
17086	SET class_split_rule = class_sort_rule	17087	SET class_split_rule = class_sort_rule
17087	\|);	17088	\|);
17088		17089
17089	$dbh->do(q\|	17090	$dbh->do(q\|
		17091	UPDATE class_sources
		17092	SET class_split_rule = 'generic'
		17093	WHERE class_split_rule NOT IN('dewey', 'generic', 'lcc')
		17094	\|);
		17095
		17096	$dbh->do(q\|
17090	INSERT INTO class_split_rules(class_split_rule, description, split_routine)	17097	INSERT INTO class_split_rules(class_split_rule, description, split_routine)
17091	VALUES	17098	VALUES
17092	('dewey', 'Default sorting rules for DDC', 'Dewey'),	17099	('dewey', 'Default sorting rules for DDC', 'Dewey'),
17093	-