From 5d473aa8e781d8d7fd18131a5fc9111499eb695e Mon Sep 17 00:00:00 2001 From: Sangyoon Jang Date: Thu, 18 Jan 2024 18:26:00 +0900 Subject: [PATCH] Fix upgrade script for cert db Change-Id: Iabdb70313f77c0cc74b2fa0dca527c3c22fe853a Signed-off-by: Sangyoon Jang --- data/updates/upgrade_to_30010.sh.in | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/data/updates/upgrade_to_30010.sh.in b/data/updates/upgrade_to_30010.sh.in index 4184fe1..008254a 100644 --- a/data/updates/upgrade_to_30010.sh.in +++ b/data/updates/upgrade_to_30010.sh.in @@ -10,12 +10,16 @@ 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 "ALTER TABLE package_res_info add lib TEXT NOT NULL DEFAULT 'false';" | sqlite3 $db_path + echo "ALTER TABLE package_res_info ADD lib TEXT NOT NULL DEFAULT 'false';" | sqlite3 $db_path echo "PRAGMA user_version=30010;" | sqlite3 $db_path } -- 2.34.1