From: Michael Andreen <harv@ruin.nu>
Date: Wed, 9 Jan 2008 22:06:10 +0000 (+0100)
Subject: Minor fixes
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=9eb928c88a27b669974c6ee7b21eab83a3ecfbc3

Minor fixes
---

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