-- $Id$
DROP TABLE IF EXISTS registrant;
CREATE TABLE registrant (
registrant_id SERIAL NOT NULL,
IRBE_mapped_id TEXT,
subject_name TEXT,
rpki_self_id BIGINT unsigned,
rpki_child_id BIGINT unsigned,
valid_until DATETIME NOT NULL,
PRIMARY KEY (registrant_id)
);
DROP TABLE IF EXISTS asn;
CREATE TABLE asn (
asn_id SERIAL NOT NULL,
start_as BIGINT unsigned NOT NULL,
end_as BIGINT unsigned NOT NULL,
registrant_id BIGINT unsigned NOT NULL,
PRIMARY KEY (asn_id),
FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
);
DROP TABLE IF EXISTS net;
CREATE TABLE net (
net_id SERIAL NOT NULL,
start_ip VARCHAR(40) NOT NULL,
end_ip VARCHAR(40) NOT NULL,
version TINYINT unsigned NOT NULL,
registrant_id BIGINT unsigned NOT NULL,
PRIMARY KEY (net_id),
FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
);
-- Local Variables:
-- indent-tab-mode: nil
-- End:
i.net/refs/?id=c42e9044b98c180879dcd4b74b383e74f67c6fdb'>refslogtreecommitdiff