From c8217e9db43fd1f5ed6f288b6ab2e6fc79a9cde7 Mon Sep 17 00:00:00 2001
From: Ilho Kim <ilho159.kim@samsung.com>
Date: Tue, 5 Mar 2024 16:04:47 +0900
Subject: [PATCH] Revert "Add upgrade script for cert db"

This reverts commit 4bb21871c3aa51980588162e0674486fe13f6088.

Change-Id: Ie1c4cfd0983adbbdc50ad5e4598631a99c6d4ff1
Signed-off-by: Ilho Kim <ilho159.kim@samsung.com>
---
 CMakeLists.txt                      |  2 --
 data/updates/upgrade_to_30010.sh.in | 45 -----------------------------
 packaging/pkgmgr-tool.spec          |  1 -
 3 files changed, 48 deletions(-)
 delete mode 100644 data/updates/upgrade_to_30010.sh.in

diff --git a/CMakeLists.txt b/CMakeLists.txt
index b1311bc..af1e541 100644
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -95,5 +95,3 @@ CONFIGURE_FILE(${CMAKE_CURRENT_SOURCE_DIR}/data/updates/upgrade_to_30008.sh.in u
 INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/upgrade_to_30008.sh DESTINATION /etc/package-manager/updates/)
 CONFIGURE_FILE(${CMAKE_CURRENT_SOURCE_DIR}/data/updates/upgrade_to_30009.sh.in upgrade_to_30009.sh @ONLY)
 INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/upgrade_to_30009.sh DESTINATION /etc/package-manager/updates/)
-CONFIGURE_FILE(${CMAKE_CURRENT_SOURCE_DIR}/data/updates/upgrade_to_30010.sh.in upgrade_to_30010.sh @ONLY)
-INSTALL(FILES ${CMAKE_CURRENT_SOURCE_DIR}/upgrade_to_30010.sh DESTINATION /etc/package-manager/updates/)
diff --git a/data/updates/upgrade_to_30010.sh.in b/data/updates/upgrade_to_30010.sh.in
deleted file mode 100644
index 5e1ae0c..0000000
--- a/data/updates/upgrade_to_30010.sh.in
+++ /dev/null
@@ -1,45 +0,0 @@
-#!/bin/sh
-PATH=/bin:/usr/bin:/sbin:/usr/sbin
-
-source /etc/tizen-platform.conf
-
-PARSER_DB_NAME=.pkgmgr_parser.db
-CERT_DB_NAME=.pkgmgr_cert.db
-GLOBAL_PARSER_DB_PATH=$TZ_SYS_DB/$PARSER_DB_NAME
-GLOBAL_CERT_DB_PATH=$TZ_SYS_DB/$CERT_DB_NAME
-
-function migrate_global_certdb() {
-  echo "PRAGMA user_version=30010;" | sqlite3 $GLOBAL_CERT_DB_PATH
-
-  echo "DROP TRIGGER IF EXISTS update_cert_info;" | sqlite3 $GLOBAL_CERT_DB_PATH
-  echo "DROP TRIGGER IF EXISTS update_cert_info2;" | sqlite3 $GLOBAL_CERT_DB_PATH
-  echo "ALTER TABLE package_cert_info DROP COLUMN package_count;" | sqlite3 $GLOBAL_CERT_DB_PATH
-}
-
-function migrate_parserdb() {
-  local db_path=$1
-
-  echo "PRAGMA user_version=30010;" | sqlite3 $db_path
-}
-
-function migrate_global_parserdb() {
-  echo "#migrate global parserdb"
-  migrate_parserdb $GLOBAL_PARSER_DB_PATH
-}
-
-function migrate_user_parserdb() {
-  echo "#migrate user parserdb"
-  ls $TZ_SYS_DB/user | while read USERID
-  do
-    migrate_parserdb $TZ_SYS_DB/user/$USERID/$PARSER_DB_NAME
-  done
-}
-
-#migrate global parser db and version
-migrate_global_parserdb
-
-#migrate user parser db and version
-migrate_user_parserdb
-
-#migrade cert db and version
-migrate_global_certdb
diff --git a/packaging/pkgmgr-tool.spec b/packaging/pkgmgr-tool.spec
index 5c2c24f..0287524 100644
--- a/packaging/pkgmgr-tool.spec
+++ b/packaging/pkgmgr-tool.spec
@@ -164,7 +164,6 @@ update-mime-database %{_datadir}/mime
 %attr(0700,root,root) /etc/package-manager/updates/upgrade_to_30007.sh
 %attr(0700,root,root) /etc/package-manager/updates/upgrade_to_30008.sh
 %attr(0700,root,root) /etc/package-manager/updates/upgrade_to_30009.sh
-%attr(0700,root,root) /etc/package-manager/updates/upgrade_to_30010.sh
 %attr(0700,root,root) %{_sysconfdir}/package-manager/pkgmgr-label-initial-image.sh
 
 %files unittests
-- 
2.34.1