-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO \
- "CREATE TABLE IF NOT EXISTS package_cert_index_info( " \
- " cert_info TEXT UNIQUE, " \
- " cert_id INTEGER PRIMARY KEY, " \
- " cert_ref_count INTEGER NOT NULL)"
-
-#define QUERY_CREATE_TABLE_PACKAGE_CERT_INFO \
- "CREATE TABLE IF NOT EXISTS package_cert_info( " \
- " package TEXT PRIMARY KEY, " \
- " package_count INTEGER, " \
- " author_root_cert INTEGER, " \
- " author_im_cert INTEGER, " \
- " author_signer_cert INTEGER, " \
- " dist_root_cert INTEGER, " \
- " dist_im_cert INTEGER, " \
- " dist_signer_cert INTEGER, " \
- " dist2_root_cert INTEGER, " \
- " dist2_im_cert INTEGER, " \
- " dist2_signer_cert INTEGER)"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO \
- "CREATE TRIGGER IF NOT EXISTS update_cert_info " \
- "AFTER UPDATE ON package_cert_info " \
- "WHEN (NEW.package_count = 0) " \
- "BEGIN" \
- " DELETE FROM package_cert_info WHERE package=OLD.package;" \
- "END;"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INFO2 \
- "CREATE TRIGGER IF NOT EXISTS update_cert_info2 " \
- "AFTER UPDATE ON package_cert_info " \
- "WHEN (NEW.package_count = OLD.package_count + 1) " \
- "BEGIN" \
- " UPDATE package_cert_index_info SET" \
- " cert_ref_count = cert_ref_count - 1" \
- " WHERE cert_id = OLD.author_root_cert" \
- " OR cert_id = OLD.author_im_cert" \
- " OR cert_id = OLD.author_signer_cert" \
- " OR cert_id = OLD.dist_root_cert" \
- " OR cert_id = OLD.dist_im_cert" \
- " OR cert_id = OLD.dist_signer_cert" \
- " OR cert_id = OLD.dist2_root_cert" \
- " OR cert_id = OLD.dist2_im_cert" \
- " OR cert_id = OLD.dist2_signer_cert;" \
- "END;"
-
-#define QUERY_CREATE_TRIGGER_DELETE_CERT_INFO \
- "CREATE TRIGGER IF NOT EXISTS delete_cert_info " \
- "AFTER DELETE ON package_cert_info " \
- "BEGIN" \
- " UPDATE package_cert_index_info SET" \
- " cert_ref_count = cert_ref_count - 1" \
- " WHERE cert_id = OLD.author_root_cert" \
- " OR cert_id = OLD.author_im_cert" \
- " OR cert_id = OLD.author_signer_cert" \
- " OR cert_id = OLD.dist_root_cert" \
- " OR cert_id = OLD.dist_im_cert" \
- " OR cert_id = OLD.dist_signer_cert" \
- " OR cert_id = OLD.dist2_root_cert" \
- " OR cert_id = OLD.dist2_im_cert" \
- " OR cert_id = OLD.dist2_signer_cert;" \
- "END;"
-
-#define QUERY_CREATE_TRIGGER_UPDATE_CERT_INDEX_INFO \
- "CREATE TRIGGER IF NOT EXISTS update_cert_index_info " \
- "AFTER UPDATE ON package_cert_index_info " \
- "WHEN ((SELECT cert_ref_count FROM package_cert_index_info " \
- " WHERE cert_id = OLD.cert_id) = 0) "\
- "BEGIN" \
- " DELETE FROM package_cert_index_info WHERE cert_id = OLD.cert_id;" \
- "END;"