summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRob Stradling <rob@comodo.com>2017-06-19 12:23:58 +0100
committerRob Stradling <rob@comodo.com>2017-06-19 12:23:58 +0100
commita7c6d471cd871cb1f72623943ee4ceb8f1a20ee6 (patch)
tree6e20779b2ee0b8a46c7c9291820e6c78b0f8ed68
parentffadd3988fc0505183520c82e7a3d4192969d86e (diff)
downloadcertwatch_db-a7c6d471cd871cb1f72623943ee4ceb8f1a20ee6.zip
certwatch_db-a7c6d471cd871cb1f72623943ee4ceb8f1a20ee6.tar.gz
certwatch_db-a7c6d471cd871cb1f72623943ee4ceb8f1a20ee6.tar.bz2
Don't evaluate technical constraints for root certs.
-rw-r--r--update_mozilla_disclosures.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/update_mozilla_disclosures.sql b/update_mozilla_disclosures.sql
index 9b21da7..e573574 100644
--- a/update_mozilla_disclosures.sql
+++ b/update_mozilla_disclosures.sql
@@ -541,6 +541,7 @@ UPDATE mozilla_disclosure_temp mdt
SET DISCLOSURE_STATUS = 'DisclosedButConstrained'
FROM certificate c
WHERE mdt.DISCLOSURE_STATUS = 'Disclosed'
+ AND mdt.RECORD_TYPE != 'Root'
AND mdt.CERTIFICATE_ID = c.ID
AND is_technically_constrained(c.CERTIFICATE);