aboutsummaryrefslogtreecommitdiff
path: root/docs/sample-irdb.sql
diff options
context:
space:
mode:
authorRob Austein <sra@hactrn.net>2008-04-08 21:43:41 +0000
committerRob Austein <sra@hactrn.net>2008-04-08 21:43:41 +0000
commit8f6d3dad328e9848997c1fd0f6238b9b350585cb (patch)
tree207f4d71d34a370e4a6d5df93984aeae30e6433e /docs/sample-irdb.sql
parent4460000e8286e481ce449efd501dd3fdeb9340a3 (diff)
Cleanup
svn path=/docs/rpki-db-schema.pdf; revision=1633
Diffstat (limited to 'docs/sample-irdb.sql')
-rw-r--r--docs/sample-irdb.sql42
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: