From d65f34f3bebfce5f6110bf6179ed1180509cd947 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 9 Jan 2010 08:21:45 +0000 Subject: [PATCH] undo damage from DBIx::DBSchema 0.37_03 --- FS/bin/freeside-upgrade | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) 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 -- 2.11.0