From e7ccb7bf1e215cd8e7b523a2e40a67ca420353c1 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Sat, 26 Jan 2008 02:13:38 +0000
Subject: Sigh, need revoked state for ca_detail after all, so put it back.

svn path=/docs/rpki-db-schema.sql; revision=1507
---
 docs/rpki-db-schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'docs/rpki-db-schema.sql')

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index 0bebfe8b..a36d7618 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -116,7 +116,7 @@ CREATE TABLE ca_detail (
        manifest_public_key      LONGBLOB,
        latest_manifest_cert     LONGBLOB,
        latest_manifest          LONGBLOB,
-       state                    ENUM ('pending', 'active', 'deprecated') NOT NULL,
+       state                    ENUM ('pending', 'active', 'deprecated', 'revoked') NOT NULL,
        state_timer              DATETIME,
        ca_cert_uri              TEXT,
        ca_id                    BIGINT unsigned NOT NULL,
-- 
cgit v1.2.3

