importer: Do not try to initialise a column that cannot be NULL with NULL

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

diff --git a/src/python/location-importer.in b/src/python/location-importer.in
index ff90d915b33cd3b76c55549a8866e0a93cc82762..d4b0ca26997a82dce780658b2cf29b8f404dfeda 100644 (file)
--- a/src/python/location-importer.in
+++ b/src/python/location-importer.in
@@ -157,7 +157,7 @@ class CLI(object):
 
                                -- autnums
                                CREATE TABLE IF NOT EXISTS autnums(number bigint, name text NOT NULL);
-                               ALTER TABLE autnums ADD COLUMN IF NOT EXISTS source text NOT NULL;
+                               ALTER TABLE autnums ADD COLUMN IF NOT EXISTS source text;
                                CREATE UNIQUE INDEX IF NOT EXISTS autnums_number ON autnums(number);
 
                                -- countries
@@ -168,7 +168,7 @@ class CLI(object):
                                -- networks
                                CREATE TABLE IF NOT EXISTS networks(network inet, country text);
                                ALTER TABLE networks ADD COLUMN IF NOT EXISTS original_countries text[];
-                               ALTER TABLE networks ADD COLUMN IF NOT EXISTS source text NOT NULL;
+                               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 GIST(network inet_ops);