diff options
| author | Rob Austein <sra@hactrn.net> | 2009-06-04 18:30:40 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2009-06-04 18:30:40 +0000 |
| commit | 467e7a98fea439040bd7451d67f188d334427103 (patch) | |
| tree | df9f247cb543a6e390ec38989b70ab864cc0748d /rpkid/pubd.sql | |
| parent | b0bdcca2ed05b0b0e5657623150b59cf5df305be (diff) | |
Rototill left-right and publication protocol to replace SQL-assigned
numeric identifiers with IRBE-assigned "handles". Daemons and test
harness have been converted and seem to work; some tools like irbe_cli
haven't been updated yet.
svn path=/rpkid/doc/Installation; revision=2493
Diffstat (limited to 'rpkid/pubd.sql')
| -rw-r--r-- | rpkid/pubd.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/rpkid/pubd.sql b/rpkid/pubd.sql index 2e9e235d..6a8b4012 100644 --- a/rpkid/pubd.sql +++ b/rpkid/pubd.sql @@ -32,10 +32,12 @@ DROP TABLE IF EXISTS client; CREATE TABLE client ( client_id SERIAL NOT NULL, + client_handle VARCHAR(255) NOT NULL, base_uri TEXT, bpki_cert LONGBLOB, bpki_glue LONGBLOB, - PRIMARY KEY (client_id) + PRIMARY KEY (client_id), + UNIQUE (client_handle) ); -- Local Variables: |