From: ivan Date: Sat, 9 Jan 2010 08:21:45 +0000 (+0000) Subject: undo damage from DBIx::DBSchema 0.37_03 X-Git-Tag: root_of_svc_elec_features~554 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d65f34f3bebfce5f6110bf6179ed1180509cd947 undo damage from DBIx::DBSchema 0.37_03 --- diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index 49f1df846..97c704c91 100755 --- a/FS/bin/freeside-upgrade +++ b/FS/bin/freeside-upgrade @@ -60,9 +60,14 @@ if (dbdef->table('cust_main')->column('agent_custid') && ! $opt_s) { #from 1.3 to 1.4... if not, it needs to be hooked into -upgrade here or #you'll lose all the part_svc settings it migrates to part_svc_column -my @statements = +my @statements = dbdef->sql_update_schema( dbdef_dist(datasrc), + $dbh, + { 'nullify_default' => 1, }, + ); + +@statements = grep { $_ !~ /^CREATE +INDEX +h_queue/i } #useless, holds up queue insertion - dbdef->sql_update_schema( dbdef_dist(datasrc), $dbh ); + @statements; unless ( driver_name =~ /^mysql/i ) { #not necessary under non-mysql, takes forever on big db