projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
75d538e
)
don't change h_queue.job type under non-mysql, takes forever on large dbs, RT#6946
author
ivan
<ivan>
Tue, 29 Dec 2009 04:24:03 +0000
(
04:24
+0000)
committer
ivan
<ivan>
Tue, 29 Dec 2009 04:24:03 +0000
(
04:24
+0000)
FS/bin/freeside-upgrade
patch
|
blob
|
history
diff --git
a/FS/bin/freeside-upgrade
b/FS/bin/freeside-upgrade
index
6ced372
..
3882ffb
100755
(executable)
--- a/
FS/bin/freeside-upgrade
+++ b/
FS/bin/freeside-upgrade
@@
-5,7
+5,7
@@
use vars qw($opt_d $opt_s $opt_q $opt_v $opt_r);
use vars qw($DEBUG $DRY_RUN);
use Getopt::Std;
use DBIx::DBSchema 0.31;
use vars qw($DEBUG $DRY_RUN);
use Getopt::Std;
use DBIx::DBSchema 0.31;
-use FS::UID qw(adminsuidsetup checkeuid datasrc ); #getsecrets);
+use FS::UID qw(adminsuidsetup checkeuid datasrc
driver_name
); #getsecrets);
use FS::CurrentUser;
use FS::Schema qw( dbdef dbdef_dist reload_dbdef );
use FS::Misc::prune qw(prune_applications);
use FS::CurrentUser;
use FS::Schema qw( dbdef dbdef_dist reload_dbdef );
use FS::Misc::prune qw(prune_applications);
@@
-61,9
+61,16
@@
if (dbdef->table('cust_main')->column('agent_custid') && ! $opt_s) {
#you'll lose all the part_svc settings it migrates to part_svc_column
my @statements =
#you'll lose all the part_svc settings it migrates to part_svc_column
my @statements =
- grep { $_ !~ /^CREATE +INDEX +h_queue/ } #useless, holds up queue insertion
+ grep { $_ !~ /^CREATE +INDEX +h_queue/
i
} #useless, holds up queue insertion
dbdef->sql_update_schema( dbdef_dist(datasrc), $dbh );
dbdef->sql_update_schema( dbdef_dist(datasrc), $dbh );
+unless ( driver_name =~ /^mysql/i ) {
+ #not necessary under non-mysql, takes forever on big db
+ @statements =
+ grep { $_ !~ /^ *ALTER +TABLE +h_queue +ALTER +COLUMN +job +TYPE +varchar\(512\) *$/ }
+ @statements;
+}
+
if ( $DRY_RUN ) {
print
join(";\n", @bugfix, @statements ). ";\n";
if ( $DRY_RUN ) {
print
join(";\n", @bugfix, @statements ). ";\n";