diff options
Diffstat (limited to 'FS/bin/freeside-upgrade')
-rwxr-xr-x | FS/bin/freeside-upgrade | 9 |
1 files 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 |