1 CREATE OR REPLACE VIEW current_development_scans AS
2 SELECT DISTINCT ON (pid) ds.*
3 FROM development_scans ds
4 ORDER BY pid, tick DESC, id DESC;
6 CREATE OR REPLACE VIEW current_planet_scans AS
7 SELECT DISTINCT ON (planet) ps.*
9 ORDER BY planet, tick DESC, id DESC;
11 CREATE OR REPLACE VIEW current_structure_scans AS
12 SELECT DISTINCT ON (planet) ss.*
13 FROM structure_scans ss
14 ORDER BY planet, tick DESC, id DESC;
16 CREATE OR REPLACE VIEW current_tech_scans AS
17 SELECT DISTINCT ON (planet) ts.*
19 ORDER BY planet, tick DESC, id DESC;