diff options
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, |