Show planet_data on check page

[ndwebbie.git] / database / scans.sql

diff --git a/database/scans.sql b/database/scans.sql
index cbd44fe7cad130709c5f463aad5d8bd009dd96d2..bd7d3f3b621fe7311a1b57f67d7bf0b878fd5108 100644 (file)
--- a/database/scans.sql
+++ b/database/scans.sql
@@ -126,3 +126,6 @@ FROM scans s
        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
+
+
+CREATE INDEX planet_data_id_index ON planet_data (id);