Signed-off-by: Michael Tremer michael.tremer@ipfire.org --- src/scripts/location-importer.in | 4 ++++ 1 file changed, 4 insertions(+)
diff --git a/src/scripts/location-importer.in b/src/scripts/location-importer.in index 5759e0c..7e2136e 100644 --- a/src/scripts/location-importer.in +++ b/src/scripts/location-importer.in @@ -211,6 +211,10 @@ class CLI(object): CREATE TABLE IF NOT EXISTS network_geofeeds(network inet, url text); CREATE UNIQUE INDEX IF NOT EXISTS network_geofeeds_unique ON network_geofeeds(network); + CREATE INDEX IF NOT EXISTS network_geofeeds_search + ON network_geofeeds USING GIST(network inet_ops); + CREATE INDEX IF NOT EXISTS network_geofeeds_url + ON network_geofeeds(url);
-- overrides CREATE TABLE IF NOT EXISTS autnum_overrides(