summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorsangwan.kwon <sangwan.kwon@samsung.com>2016-08-30 13:20:49 +0900
committersangwan.kwon <sangwan.kwon@samsung.com>2016-08-30 15:17:41 +0900
commitf22a5688bec05a24db4d630658e3cda7d33e6fbe (patch)
treee7eb6cd6faf88b7b4605115773c1e148288e10b7
parent30f606d394367ddf4bc42eb520848d4e3486981d (diff)
downloadcert-svc-f22a5688bec05a24db4d630658e3cda7d33e6fbe.tar.gz
cert-svc-f22a5688bec05a24db4d630658e3cda7d33e6fbe.tar.bz2
cert-svc-f22a5688bec05a24db4d630658e3cda7d33e6fbe.zip
Adjust primary key constraints on certs db
* ssl's gname attribute should be unique. Change-Id: I57995417f4c3fec73ed85c791dd94b569ab43eb4 Signed-off-by: sangwan.kwon <sangwan.kwon@samsung.com>
-rw-r--r--etc/cert_svc_store_db.sql4
1 files changed, 1 insertions, 3 deletions
diff --git a/etc/cert_svc_store_db.sql b/etc/cert_svc_store_db.sql
index 1810c3c..958351d 100644
--- a/etc/cert_svc_store_db.sql
+++ b/etc/cert_svc_store_db.sql
@@ -1,10 +1,9 @@
-
PRAGMA foreign_keys = ON;
BEGIN TRANSACTION;
CREATE TABLE ssl (
- gname TEXT not null,
+ gname TEXT PRIMARY KEY not null,
certificate TEXT not null,
file_hash TEXT not null,
subject_hash TEXT not null,
@@ -44,4 +43,3 @@ CREATE TABLE disabled_certs (
certificate TEXT not null);
COMMIT;
-