From f22a5688bec05a24db4d630658e3cda7d33e6fbe Mon Sep 17 00:00:00 2001
From: "sangwan.kwon" <sangwan.kwon@samsung.com>
Date: Tue, 30 Aug 2016 13:20:49 +0900
Subject: [PATCH] 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>
---
 etc/cert_svc_store_db.sql | 4 +---
 1 file changed, 1 insertion(+), 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;
-
-- 
2.7.4