From 3beca3f93a39b4795cb910f5dd58785afdcec45b Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 8 Nov 2018 16:22:32 -0300 Subject: [PATCH] Bug 15836: Fix update DB entry --- installer/data/mysql/atomicupdate/bug_15836.perl | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_15836.perl b/installer/data/mysql/atomicupdate/bug_15836.perl index edfe012709..0cb485b90f 100644 --- a/installer/data/mysql/atomicupdate/bug_15836.perl +++ b/installer/data/mysql/atomicupdate/bug_15836.perl @@ -13,6 +13,11 @@ if( CheckVersion( $DBversion ) ) { |); $dbh->do(q| + ALTER TABLE class_sort_rules + ADD COLUMN split_routine varchar(30) NOT NULL default '' AFTER sort_routine, + ADD COLUMN split_regex varchar(255) NOT NULL default '' AFTER split_routine + |); + $dbh->do(q| ALTER TABLE class_sources ADD COLUMN class_split_rule varchar(10) NOT NULL default '' AFTER class_sort_rule @@ -38,5 +43,5 @@ if( CheckVersion( $DBversion ) ) { } SetVersion( $DBversion ); - print "Upgrade to $DBversion done (Bug 15836 - Add class_sort_rules.split_routine and split_regex)\n"; + print "Upgrade to $DBversion done (Bug 15836 - Add new table class_split_rules and 2 columns 'split_routine' and 'split_regex' to class_sort_rules)\n"; } -- 2.11.0