-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO \
- "CREATE TRIGGER IF NOT EXISTS update_cert_info\n" \
- "AFTER UPDATE ON package_cert_info\n" \
- "WHEN (NEW.package_count = 0)\n" \
- "BEGIN\n" \
- " DELETE FROM package_cert_info WHERE package=OLD.package;\n" \
- "END"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO2 \
- "CREATE TRIGGER IF NOT EXISTS update_cert_info2\n" \
- "AFTER UPDATE ON package_cert_info\n" \
- "WHEN (NEW.package_count = OLD.package_count + 1)\n" \
- "BEGIN\n" \
- " UPDATE package_cert_index_info SET\n" \
- " cert_ref_count = cert_ref_count - 1\n" \
- " WHERE cert_id = OLD.author_root_cert\n" \
- " OR cert_id = OLD.author_im_cert\n" \
- " OR cert_id = OLD.author_signer_cert\n" \
- " OR cert_id = OLD.dist_root_cert\n" \
- " OR cert_id = OLD.dist_im_cert\n" \
- " OR cert_id = OLD.dist_signer_cert\n" \
- " OR cert_id = OLD.dist2_root_cert\n" \
- " OR cert_id = OLD.dist2_im_cert\n" \
- " OR cert_id = OLD.dist2_signer_cert;\n" \
- "END"
-