From ab9c880096d9c14729cd375bf3255617ec33ed43 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
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

