From ef20577491a69792f1692a135c79926b4cad551c Mon Sep 17 00:00:00 2001 From: Rob Austein 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