From dad110e047c0216f380bb1f1c974b4db5233443c Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Fri, 18 Sep 2009 04:42:29 +0000
Subject: Missing constraint

svn path=/rpkid/rpkid.sql; revision=2766
---
 rpkid/rpkid.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'rpkid')

diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql
index cf5aaee2..5671a9c7 100644
--- a/rpkid/rpkid.sql
+++ b/rpkid/rpkid.sql
@@ -165,7 +165,7 @@ CREATE TABLE roa (
         cert                    LONGBLOB,
         roa                     LONGBLOB,
         self_id                 BIGINT UNSIGNED NOT NULL,
-        ca_detail_id            BIGINT UNSIGNED,
+        ca_detail_id            BIGINT UNSIGNED NOT NULL,
         PRIMARY KEY             (roa_id),
         FOREIGN KEY             (self_id) REFERENCES self (self_id),
         FOREIGN KEY             (ca_detail_id) REFERENCES ca_detail (ca_detail_id)
-- 
cgit v1.2.3