summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorJanusz Kozerski <j.kozerski@samsung.com>2015-08-04 11:59:59 +0200
committerJanusz Kozerski <j.kozerski@samsung.com>2015-09-08 09:40:51 +0200
commitae4a130374e96d383e09571f2e098ef237e28418 (patch)
treebe1aec96429587bebab0b8395326c4dde558c56d /db
parent4373c73514186ce90d71a0486447fa66dcf0a6c1 (diff)
downloadcert-checker-ae4a130374e96d383e09571f2e098ef237e28418.tar.gz
cert-checker-ae4a130374e96d383e09571f2e098ef237e28418.tar.bz2
cert-checker-ae4a130374e96d383e09571f2e098ef237e28418.zip
Use new cert-svc-vcore API: makeChainBySignature()
This change includes adding cert_order in DB. Chain of certificates should be created while reading/parsing signature. Certificates should be put into DB in right order - first should go end entity certificate. DB ensures that certificates will be loaded into the buffer in exactly same order (end entity will be the first element on the list). Verification: Run tests, all should pass. Change-Id: I09571bab7862bdb539dd3a957330fe23d687b48f
Diffstat (limited to 'db')
-rw-r--r--db/cert-checker.sql3
-rw-r--r--db/cert-checker.xml3
2 files changed, 6 insertions, 0 deletions
diff --git a/db/cert-checker.sql b/db/cert-checker.sql
index 2503e7c..9ef86f4 100644
--- a/db/cert-checker.sql
+++ b/db/cert-checker.sql
@@ -33,6 +33,9 @@ CREATE TABLE IF NOT EXISTS chains_to_check (
CREATE TABLE IF NOT EXISTS certs_to_check (
chain_id INTEGER NOT NULL,
certificate TEXT NOT NULL,
+ cert_order INTEGER NOT NULL,
+
+ UNIQUE (chain_id, cert_order),
PRIMARY KEY (chain_id, certificate),
FOREIGN KEY (chain_id) REFERENCES chains_to_check(chain_id) ON DELETE CASCADE
diff --git a/db/cert-checker.xml b/db/cert-checker.xml
index e72b044..f3ee60f 100644
--- a/db/cert-checker.xml
+++ b/db/cert-checker.xml
@@ -92,6 +92,9 @@
<row name="certificates" null="0" autoincrement="0">
<datatype>MEDIUMTEXT</datatype>
<default>'NULL'</default></row>
+<row name="cert_order" null="0" autoincrement="0">
+<datatype>INTEGER</datatype>
+<default>NULL</default></row>
<key type="PRIMARY" name="">
<part>certificates</part>
<part>chain_id</part>