]> git.ipfire.org Git - location/libloc.git/commitdiff
importer: Add search index to network_overrides table
authorMichael Tremer <michael.tremer@ipfire.org>
Wed, 21 Oct 2020 13:54:45 +0000 (13:54 +0000)
committerMichael Tremer <michael.tremer@ipfire.org>
Wed, 21 Oct 2020 13:54:45 +0000 (13:54 +0000)
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
src/python/location-importer.in

index d0fe5a69592ae57cf38fd1118a1fd774e6130ed5..fe21d731631e5dd484dd079157b42e23d3a461a4 100644 (file)
@@ -189,6 +189,8 @@ class CLI(object):
                                );
                                CREATE UNIQUE INDEX IF NOT EXISTS network_overrides_network
                                        ON network_overrides(network);
+                               CREATE INDEX IF NOT EXISTS network_overrides_search
+                                       ON network_overrides USING GIST(network inet_ops);
                        """)
 
                return db