aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--rpkid/rpkid.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql
index ad02f278..8192aaa7 100644
--- a/rpkid/rpkid.sql
+++ b/rpkid/rpkid.sql
@@ -190,8 +190,8 @@ CREATE TABLE revoked_cert (
CREATE TABLE roa (
roa_id SERIAL NOT NULL,
asn BIGINT UNSIGNED,
- cert LONGBLOB,
- roa LONGBLOB,
+ cert LONGBLOB NOT NULL,
+ roa LONGBLOB NOT NULL,
published DATETIME,
self_id BIGINT UNSIGNED NOT NULL,
ca_detail_id BIGINT UNSIGNED NOT NULL,