From: Michael Andreen <harv@ruin.nu>
Date: Fri, 28 Dec 2007 23:10:22 +0000 (+0100)
Subject: readd some indexes from the intel table
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=c92ebd9fe99a4c1b64a46289c03424980ead0778

readd some indexes from the intel table
---

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);