@@ -, +, @@ class_sources.class_split_rule FK creation ALTER TABLE class_sources ADD CONSTRAINT class_source_ibfk_2 FOREIGN KEY (class_split_rule) REFERENCES class_split_rules (class_split_rule) "] at installer/data/mysql/updatedatabase.pl line 17104. --- installer/data/mysql/updatedatabase.pl | 7 +++++++ 1 file changed, 7 insertions(+) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -17081,12 +17081,19 @@ if( CheckVersion( $DBversion ) ) { 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'), --