diff options
| author | Rob Austein <sra@hactrn.net> | 2007-09-25 15:42:20 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-09-25 15:42:20 +0000 |
| commit | 71701d88132327d6595890f9505e998c6716bf82 (patch) | |
| tree | 2c394ffca4d63fddac63d47f280c2a7e84074460 /docs/sample-irdb.sql | |
| parent | 5e78ccb872e7d84982ab7060f0da1f533e8a84ae (diff) | |
Split out sample data prior to hacking.
svn path=/docs/sample-irbe.pdf; revision=1020
Diffstat (limited to 'docs/sample-irdb.sql')
| -rw-r--r-- | docs/sample-irdb.sql | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/docs/sample-irdb.sql b/docs/sample-irdb.sql new file mode 100644 index 00000000..c6a5d9f9 --- /dev/null +++ b/docs/sample-irdb.sql @@ -0,0 +1,85 @@ +
+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,
+ resource_class_id BIGINT unsigned NOT NULL
+);
+
+CREATE UNIQUE INDEX XPKasn ON asn
+(
+ asn_id
+);
+
+ALTER TABLE asn
+ ADD PRIMARY KEY (asn_id);
+
+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,
+ resource_class_id BIGINT unsigned NOT NULL
+);
+
+CREATE UNIQUE INDEX XPKnet ON net
+(
+ net_id
+);
+
+ALTER TABLE net
+ ADD PRIMARY KEY (net_id);
+
+
+DROP TABLE IF EXISTS registrant;
+
+CREATE TABLE registrant (
+ registrant_id SERIAL NOT NULL,
+ IRBE_mapped_id TEXT
+);
+
+CREATE UNIQUE INDEX XPKregistrant ON registrant
+(
+ registrant_id
+);
+
+ALTER TABLE registrant
+ ADD PRIMARY KEY (registrant_id);
+
+DROP TABLE IF EXISTS resource_class;
+
+CREATE TABLE resource_class (
+ resource_class_id SERIAL NOT NULL,
+ subject_name TEXT,
+ valid_until DATETIME NOT NULL,
+ registrant_id BIGINT unsigned NOT NULL
+);
+
+CREATE UNIQUE INDEX XPKresource_class ON resource_class
+(
+ resource_class_id
+);
+
+ALTER TABLE resource_class
+ ADD PRIMARY KEY (resource_class_id);
+
+ALTER TABLE asn
+ ADD FOREIGN KEY (resource_class_id)
+ REFERENCES resource_class
+ ON DELETE SET NULL
+ ON UPDATE SET NULL;
+
+ALTER TABLE net
+ ADD FOREIGN KEY (resource_class_id)
+ REFERENCES resource_class
+ ON DELETE SET NULL
+ ON UPDATE SET NULL;
+
+ALTER TABLE resource_class
+ ADD FOREIGN KEY (registrant_id)
+ REFERENCES registrant
+ ON DELETE SET NULL
+ ON UPDATE SET NULL;
|