diff options
| -rw-r--r-- | docs/rpki-db-schema.sql | 21 |
1 files changed, 11 insertions, 10 deletions
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index e4967fcc..21812d25 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -71,16 +71,17 @@ CREATE TABLE parent ( DROP TABLE IF EXISTS ca; CREATE TABLE ca ( - ca_id SERIAL NOT NULL, - last_crl_sn BIGINT unsigned, - last_manifest_sn BIGINT unsigned, - next_manifest_update DATETIME, - next_crl_update DATETIME, - last_issued_sn BIGINT unsigned, - sia_uri TEXT, - parent_id BIGINT unsigned, - PRIMARY KEY (ca_id), - FOREIGN KEY (parent_id) REFERENCES parent + ca_id SERIAL NOT NULL, + last_crl_sn BIGINT unsigned, + last_manifest_sn BIGINT unsigned, + next_manifest_update DATETIME, + next_crl_update DATETIME, + last_issued_sn BIGINT unsigned, + sia_uri TEXT, + parent_resource_class TEXT, + parent_id BIGINT unsigned, + PRIMARY KEY (ca_id), + FOREIGN KEY (parent_id) REFERENCES parent ); DROP TABLE IF EXISTS ca_detail; |