importer: Drop any indexes we no longer need

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/scripts/location-importer.in b/src/scripts/location-importer.in
index 80290ffe953502657614e67a280c5cad05ff3c0a..572f42e0ae1c6616b9a6809e7e6a2be0ca28dbe7 100644 (file)
--- a/src/scripts/location-importer.in
+++ b/src/scripts/location-importer.in
@@ -197,7 +197,6 @@ class CLI(object):
                                        first_seen_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
                                        last_seen_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP);
                                CREATE UNIQUE INDEX IF NOT EXISTS announcements_networks ON announcements(network);
-                               CREATE INDEX IF NOT EXISTS announcements_family ON announcements(family(network));
                                CREATE INDEX IF NOT EXISTS announcements_search ON announcements USING SPGIST(network inet_ops);
 
                                -- autnums
@@ -215,7 +214,6 @@ class CLI(object):
                                ALTER TABLE networks ADD COLUMN IF NOT EXISTS original_countries text[];
                                ALTER TABLE networks ADD COLUMN IF NOT EXISTS source text;
                                CREATE UNIQUE INDEX IF NOT EXISTS networks_network ON networks(network);
-                               CREATE INDEX IF NOT EXISTS networks_family ON networks USING BTREE(family(network));
                                CREATE INDEX IF NOT EXISTS networks_search ON networks USING SPGIST(network inet_ops);
 
                                -- geofeeds
@@ -305,7 +303,10 @@ class CLI(object):
                                ALTER TABLE network_overrides ADD COLUMN IF NOT EXISTS is_drop boolean;
                                ALTER TABLE network_overrides DROP COLUMN IF EXISTS source;
 
+                               -- Cleanup things we no longer need
                                DROP TABLE IF EXISTS geofeed_overrides;
+                               DROP INDEX IF EXISTS announcements_family;
+                               DROP INDEX IF EXISTS networks_family;
                        """)
 
                return db