From 36677da9db92362b91a1320c0dd37baae26776a7 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Tue, 25 Sep 2007 20:11:56 +0000
Subject: Shorten a few tediously long identifiers

svn path=/docs/rpki-db-schema.pdf; revision=1031
---
 docs/rpki-db-schema.sql | 26 +++++++++++++-------------
 1 file changed, 13 insertions(+), 13 deletions(-)

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

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index aef7608c..d9af186d 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -86,19 +86,19 @@ CREATE TABLE ca (
 DROP TABLE IF EXISTS ca_detail;
 
 CREATE TABLE ca_detail (
-       ca_detail_id                     SERIAL NOT NULL,
-       public_key                       LONGBLOB,
-       private_key_handle               LONGBLOB,
-       latest_crl                       LONGBLOB,
-       latest_ca_cert_over_public_key   LONGBLOB,
-       manifest_ee_private_key_handle   LONGBLOB,
-       manifest_ee_public_key           LONGBLOB,
-       latest_manifest_ee_cert          LONGBLOB,
-       latest_manifest                  LONGBLOB,
-       state				ENUM ('active', 'deprecated', 'pending') NOT NULL,
-       ca_id                            BIGINT unsigned NOT NULL,
-       PRIMARY KEY                      (ca_detail_id),
-       FOREIGN KEY                      (ca_id) REFERENCES ca
+       ca_detail_id             SERIAL NOT NULL,
+       public_key               LONGBLOB,
+       private_key_id           LONGBLOB,
+       latest_crl               LONGBLOB,
+       latest_ca_cert           LONGBLOB,
+       manifest_private_key_id  LONGBLOB,
+       manifest_public_key      LONGBLOB,
+       latest_manifest_cert     LONGBLOB,
+       latest_manifest          LONGBLOB,
+       state                    ENUM ('active', 'deprecated', 'pending') NOT NULL,
+       ca_id                    BIGINT unsigned NOT NULL,
+       PRIMARY KEY              (ca_detail_id),
+       FOREIGN KEY              (ca_id) REFERENCES ca
 );
 
 DROP TABLE IF EXISTS child;
-- 
cgit v1.2.3

