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