diff options
| author | Rob Austein <sra@hactrn.net> | 2007-10-17 22:27:49 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-10-17 22:27:49 +0000 |
| commit | 58055d39a4a57e937aa761f06faee79e3ceeb0c0 (patch) | |
| tree | b9d4cb4ae2bb35bcdb0b0442f3d349a6643a75a2 /docs/rpki-db-schema.sql | |
| parent | ee157f82d325b575c359da7e135d1ccc0cad44da (diff) | |
More missing SQL fields
svn path=/docs/rpki-db-schema.pdf; revision=1169
Diffstat (limited to 'docs/rpki-db-schema.sql')
| -rw-r--r-- | docs/rpki-db-schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index 5ed0fe66..a9e08eb9 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -26,6 +26,7 @@ CREATE TABLE bsc ( private_key_id LONGBLOB, self_id BIGINT unsigned NOT NULL, public_key LONGBLOB, + hash_alg TEXT, PRIMARY KEY (bsc_id), FOREIGN KEY (self_id) REFERENCES self ); @@ -123,8 +124,9 @@ DROP TABLE IF EXISTS child_cert; CREATE TABLE child_cert ( child_cert_id SERIAL NOT NULL, cert LONGBLOB NOT NULL, - child_id BIGINT unsigned NOT NULL, ski TINYBLOB NOT NULL, + revoked BOOLEAN, + child_id BIGINT unsigned NOT NULL, ca_detail_id BIGINT unsigned NOT NULL, PRIMARY KEY (child_cert_id), FOREIGN KEY (ca_detail_id) REFERENCES ca_detail, |