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 | |
| parent | 5e78ccb872e7d84982ab7060f0da1f533e8a84ae (diff) | |
Split out sample data prior to hacking.
svn path=/docs/sample-irbe.pdf; revision=1020
| -rw-r--r-- | docs/sample-irdb-data.sql (renamed from docs/sample-irbe.sql) | 86 | ||||
| -rw-r--r-- | docs/sample-irdb.pdf (renamed from docs/sample-irbe.pdf) | 0 | ||||
| -rw-r--r-- | docs/sample-irdb.sql | 85 |
3 files changed, 85 insertions, 86 deletions
diff --git a/docs/sample-irbe.sql b/docs/sample-irdb-data.sql index 1a57860f..767d7436 100644 --- a/docs/sample-irbe.sql +++ b/docs/sample-irdb-data.sql @@ -1,90 +1,4 @@ -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;
-
-
INSERT INTO registrant (IRBE_mapped_id) VALUES ('ARIN');
INSERT INTO registrant (IRBE_mapped_id) VALUES ('TIER1_ISP1');
INSERT INTO registrant (IRBE_mapped_id) VALUES ('TIER1_ISP2');
diff --git a/docs/sample-irbe.pdf b/docs/sample-irdb.pdf index ab86a43a..ab86a43a 100644 --- a/docs/sample-irbe.pdf +++ b/docs/sample-irdb.pdf 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;
|