From ab9c880096d9c14729cd375bf3255617ec33ed43 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Wed, 7 Nov 2007 07:08:37 +0000 Subject: crl_interval svn path=/docs/left-right-xml; revision=1267 --- docs/rpki-db-schema.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'docs/rpki-db-schema.sql') diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql index f5651dd3..8cdf5ff8 100644 --- a/docs/rpki-db-schema.sql +++ b/docs/rpki-db-schema.sql @@ -76,11 +76,11 @@ DROP TABLE IF EXISTS ca; CREATE TABLE ca ( ca_id SERIAL NOT NULL, - last_crl_sn BIGINT unsigned, - last_manifest_sn BIGINT unsigned, + last_crl_sn BIGINT unsigned NOT NULL, + last_manifest_sn BIGINT unsigned NOT NULL, next_manifest_update DATETIME, next_crl_update DATETIME, - last_issued_sn BIGINT unsigned, + last_issued_sn BIGINT unsigned NOT NULL, sia_uri TEXT, parent_resource_class TEXT, parent_id BIGINT unsigned, -- cgit v1.2.3