Fix setting certinfo

[platform/core/appfw/pkgmgr-info.git] / parser / include / pkgmgr_parser_db_queries.h

diff --git a/parser/include/pkgmgr_parser_db_queries.h b/parser/include/pkgmgr_parser_db_queries.h
index 649bd64..6b7762f 100644 (file)
--- a/parser/include/pkgmgr_parser_db_queries.h
+++ b/parser/include/pkgmgr_parser_db_queries.h
@@ -319,32 +319,6 @@
        "  dist2_im_cert INTEGER,\n" \
        "  dist2_signer_cert INTEGER)"
 
-#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"
-
 #define QUERY_CREATE_TRIGGER_DELETE_CERT_INFO \
        "CREATE TRIGGER IF NOT EXISTS delete_cert_info\n" \
        "AFTER DELETE ON package_cert_info\n" \
@@ -436,8 +410,6 @@ const char *PARSER_INIT_QUERIES[] = {
 const char *CERT_INIT_QUERIES[] = {
        QUERY_CREATE_TABLE_PACKAGE_CERT_INFO,
        QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO,
-       QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO,
-       QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO2,
        QUERY_CREATE_TRIGGER_DELETE_CERT_INFO,
        QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO,
        NULL