readd some indexes from the intel table

[ndwebbie.git] / database / scans.sql

diff --git a/database/scans.sql b/database/scans.sql
index 9682223cbe04ddcf7805ce3a5c91df6c040b57f1..5f789697aa235809afef93a2dfb5240f5d2f4a0c 100644 (file)
--- 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);