X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fscans.sql;fp=database%2Fscans.sql;h=5f789697aa235809afef93a2dfb5240f5d2f4a0c;hb=c92ebd9fe99a4c1b64a46289c03424980ead0778;hp=9682223cbe04ddcf7805ce3a5c91df6c040b57f1;hpb=b38002a1035bbdf3da505db7eccb2d706138da68;p=ndwebbie.git

diff --git a/database/scans.sql b/database/scans.sql
index 9682223..5f78969 100644
--- a/database/scans.sql
+++ b/database/scans.sql
@@ -95,3 +95,9 @@ CREATE TABLE data_scans (
 ) WITHOUT OIDS;
 
 DROP TABLE intel;
+
+CREATE INDEX fleets_tick_index ON fleets (tick);
+CREATE INDEX fleets_target_index ON fleets (target);
+CREATE INDEX fleets_sender_index ON fleets (sender);
+CREATE INDEX fleets_mission_index ON fleets (mission);
+CREATE INDEX fleets_ingal_index ON fleets (ingal);