diff options
| -rw-r--r-- | update_mozilla_disclosures.sql | 1 |
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); |