diff options
Diffstat (limited to 'docs/sample-irdb.sql')
| -rw-r--r-- | docs/sample-irdb.sql | 42 |
1 files changed, 21 insertions, 21 deletions
diff --git a/docs/sample-irdb.sql b/docs/sample-irdb.sql index d70f128d..f5c8c970 100644 --- a/docs/sample-irdb.sql +++ b/docs/sample-irdb.sql @@ -17,38 +17,38 @@ 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) + 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 + 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 + 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 +-- indent-tabs-mode: nil -- End: |