13 lines
845 B
PL/PgSQL
13 lines
845 B
PL/PgSQL
BEGIN;
|
|
CREATE TABLE IF NOT EXISTS asn_import (range_start INTEGER, range_end INTEGER, id INTEGER, country STRING, description TEXT);
|
|
CREATE TABLE IF NOT EXISTS asns (range_start INTEGER, range_end INTEGER, id INTEGER, country STRING, owner_id INTEGER);
|
|
CREATE UNIQUE INDEX IF NOT EXISTS asn_import_range_id ON asn_import (range_start, range_end);
|
|
CREATE UNIQUE INDEX IF NOT EXISTS asns_range_id ON asns (range_start, range_end);
|
|
CREATE INDEX IF NOT EXISTS asns_id_idx ON asns (id);
|
|
CREATE INDEX IF NOT EXISTS asns_owner_id_idx ON asns (owner_id);
|
|
CREATE TABLE IF NOT EXISTS owners (id INTEGER PRIMARY KEY, description TEXT);
|
|
CREATE TABLE IF NOT EXISTS status (id INTEGER PRIMARY KEY, blocked BOOLEAN DEFAULT FALSE);
|
|
CREATE TABLE IF NOT EXISTS owner_status (id INTEGER PRIMARY KEY, blocked BOOLEAN DEFAULT FALSE);
|
|
DELETE FROM asn_import;
|
|
COMMIT;
|