From 8f6d3dad328e9848997c1fd0f6238b9b350585cb Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Tue, 8 Apr 2008 21:43:41 +0000
Subject: Cleanup

svn path=/docs/rpki-db-schema.pdf; revision=1633
---
 docs/sample-irdb.sql | 42 +++++++++++++++++++++---------------------
 1 file changed, 21 insertions(+), 21 deletions(-)

(limited to 'docs/sample-irdb.sql')

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:
-- 
cgit v1.2.3

