From c92ebd9fe99a4c1b64a46289c03424980ead0778 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sat, 29 Dec 2007 00:10:22 +0100 Subject: [PATCH] readd some indexes from the intel table --- database/scans.sql | 6 ++++++ 1 file changed, 6 insertions(+) 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); -- 2.39.2