From ef20577491a69792f1692a135c79926b4cad551c Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Wed, 3 Jun 2009 05:07:04 +0000
Subject: Checkpoint: first step towards cleanup of SQL and left-right
 protocol.

svn path=/rpkid/doc/Installation; revision=2491
---
 rpkid/irdbd.sql | 16 +++++++++-------
 1 file changed, 9 insertions(+), 7 deletions(-)

(limited to 'rpkid/irdbd.sql')

diff --git a/rpkid/irdbd.sql b/rpkid/irdbd.sql
index 07320dd0..548f5b72 100644
--- a/rpkid/irdbd.sql
+++ b/rpkid/irdbd.sql
@@ -22,13 +22,15 @@
 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,
+        registrant_handle       VARCHAR(255) NOT NULL,
+        registrant_name         TEXT,
+        rpki_self_handle        VARCHAR(255),
+        rpki_self_id            BIGINT unsigned,
+        rpki_child_id           BIGINT unsigned,
+        valid_until             DATETIME NOT NULL,
+        PRIMARY KEY             (registrant_id),
+        UNIQUE                  (rpki_self_handle, registrant_handle)
 );
 
 DROP TABLE IF EXISTS asn;
-- 
cgit v1.2.3

