1 files changed, 13 insertions, 42 deletions
diff --git a/docs/sample-irdb.sql b/docs/sample-irdb.sql
index a039918a..abfba9e5 100644
--- a/docs/sample-irdb.sql
+++ b/docs/sample-irdb.sql
@@ -1,19 +1,24 @@
 -- $Id$
 
+DROP TABLE IF EXISTS registrant;
+
+CREATE TABLE registrant (
+       registrant_id        SERIAL NOT NULL,
+       IRBE_mapped_id       TEXT,
+       subject_name         TEXT,
+       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,
-       resource_class_id    BIGINT unsigned NOT NULL,
+       registrant_id        BIGINT unsigned NOT NULL,
        PRIMARY KEY	    (asn_id),
-       FOREIGN KEY	    (resource_class_id) REFERENCES resource_class ON DELETE SET NULL ON UPDATE SET NULL
-);
-
-CREATE UNIQUE INDEX XPKasn ON asn
-(
-       asn_id
+       FOREIGN KEY          (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
 );
 
 DROP TABLE IF EXISTS net;
@@ -23,41 +28,7 @@ CREATE TABLE net (
        start_ip             VARCHAR(40) NOT NULL,
        end_ip               VARCHAR(40) NOT NULL,
        version              TINYINT unsigned NOT NULL,
-       resource_class_id    BIGINT unsigned NOT NULL,
-       PRIMARY KEY          (net_id),
-       FOREIGN KEY          (resource_class_id) REFERENCES resource_class ON DELETE SET NULL ON UPDATE SET NULL
-);
-
-CREATE UNIQUE INDEX XPKnet ON net
-(
-       net_id
-);
-
-DROP TABLE IF EXISTS registrant;
-
-CREATE TABLE registrant (
-       registrant_id        SERIAL NOT NULL,
-       IRBE_mapped_id       TEXT,
-       PRIMARY KEY	    (registrant_id)
-);
-
-CREATE UNIQUE INDEX XPKregistrant ON registrant
-(
-       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,
-       PRIMARY KEY          (resource_class_id),
+       PRIMARY KEY          (net_id),
        FOREIGN KEY          (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL
 );
-
-CREATE UNIQUE INDEX XPKresource_class ON resource_class
-(
-       resource_class_id
-);