From 9eb928c88a27b669974c6ee7b21eab83a3ecfbc3 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Wed, 9 Jan 2008 23:06:10 +0100 Subject: [PATCH] Minor fixes --- database/scans.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/database/scans.sql b/database/scans.sql index bd7d3f3..f68b4b6 100644 --- a/database/scans.sql +++ b/database/scans.sql @@ -1,3 +1,4 @@ +DELETE FROM fleets; ALTER TABLE fleets ADD COLUMN sender INTEGER NOT NULL REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE fleets DROP COLUMN fleet; @@ -36,6 +37,8 @@ ALTER TABLE scans ADD COLUMN groupscan BOOLEAN NOT NULL DEFAULT False; ALTER TABLE scans ADD COLUMN parsed BOOLEAN NOT NULL DEFAULT False; +ALTER TABLE scans DROP CONSTRAINT scans_pkey; + ALTER TABLE scans ADD COLUMN id SERIAL PRIMARY KEY; ALTER TABLE scans ADD UNIQUE (scan_id, tick, groupscan); @@ -125,7 +128,7 @@ FROM scans s WHERE rid = 18) AS d USING (id) JOIN (SELECT scan AS id,amount AS seccents FROM planet_data WHERE rid = 24) AS sc USING (id) -ORDER BY planet,tick DESC, id DESC +ORDER BY planet,tick DESC, id DESC; CREATE INDEX planet_data_id_index ON planet_data (id); -- 2.39.2