X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-upgrade;h=97c704c91e30e848551c5b2a7f518b2bd38771d4;hb=d65f34f3bebfce5f6110bf6179ed1180509cd947;hp=49f1df8462b77bd62aae19c1e43685edae5a0c1b;hpb=c27c62c2fe1c79811f389cc0d17c330157888d01;p=freeside.git 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