X-Git-Url: http://dxcluster.net/gitweb/gitweb.cgi?a=blobdiff_plain;f=perl%2FDXSql%2FSQLite.pm;h=36bcc46da72554ae53721a85b147f8f6868b0e6b;hb=c83b1ca22765fc07e5adcdc8dac24cbd066c9b95;hp=2330837f41cd4b2192dc2821f926ff917c00653b;hpb=cc9bd946788545ef87a7a6d0541fa1c47b9b034a;p=spider.git

diff --git a/perl/DXSql/SQLite.pm b/perl/DXSql/SQLite.pm
index 2330837f..36bcc46d 100644
--- a/perl/DXSql/SQLite.pm
+++ b/perl/DXSql/SQLite.pm
@@ -80,9 +80,13 @@ sub spot_add_indexes
 {
 	my $self = shift;
 	dbg('adding spot index ix1');
-	$self->do('create index spot_ix1 on spot(time desc)');
+	$self->do('create index spot_ix1 on spot(time asc)');
 	dbg('adding spot index ix2');
 	$self->do('create index spot_ix2 on spot(spotcall asc)');
+	dbg('adding spot index ix3');
+	$self->do('create index spot_ix3 on spot(freq asc)');
+	dbg('adding spot index ix4');
+	$self->do('create index spot_ix4 on spot(spotter asc)');
 }