projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
8688433
)
automatically create an index on the new radacct.FreesideStatus column
author
ivan
<ivan>
Tue, 20 May 2008 03:52:05 +0000
(
03:52
+0000)
committer
ivan
<ivan>
Tue, 20 May 2008 03:52:05 +0000
(
03:52
+0000)
FS/FS/Upgrade.pm
patch
|
blob
|
history
diff --git
a/FS/FS/Upgrade.pm
b/FS/FS/Upgrade.pm
index
ae9c763
..
5c873bf
100644
(file)
--- a/
FS/FS/Upgrade.pm
+++ b/
FS/FS/Upgrade.pm
@@
-132,6
+132,13
@@
sub upgrade_sqlradius {
$sth_update->execute or die $sth_update->errstr;
}
+ my $sth_index = $dbh->prepare(
+ "CREATE INDEX FreesideStatus ON radacct ( FreesideStatus )"
+ );
+ if ( $sth_index ) {
+ $sth_index->execute;
+ }
+
my $sth = $dbh->prepare("SELECT UserName,
Realm,
$str2time max(AcctStartTime)),