From ea47286cd235c93eb326c709efb4ff6247de9968 Mon Sep 17 00:00:00 2001 From: Hwankyu Jhun Date: Tue, 12 Mar 2019 14:21:39 +0900 Subject: [PATCH] Add db schema to version 30004 Added: - package_app_component_info table Change-Id: I863b8a0ace0ba93969b8475049c4561e1f1c1c2c Signed-off-by: Hwankyu Jhun --- data/updates/upgrade_to_30004.sh.in | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/data/updates/upgrade_to_30004.sh.in b/data/updates/upgrade_to_30004.sh.in index d1214e2..a66c406 100644 --- a/data/updates/upgrade_to_30004.sh.in +++ b/data/updates/upgrade_to_30004.sh.in @@ -24,6 +24,15 @@ function migrate_parser_db() { " plugin_type TEXT NOT NULL,\n" \ " plugin_name TEXT NOT NULL);" | sqlite3 $dbpath + echo -e "CREATE TABLE IF NOT EXISTS package_app_component_info (\n" \ + " app_id TEXT NOT NULL,\n" \ + " component_id TEXT NOT NULL,\n" \ + " type TEXT NOT NULL,\n" \ + " launch_mode TEXT NOT NULL,\n" \ + " PRIMARY KEY(app_id, component_id)\n" \ + " FOREIGN KEY(app_id)\n" \ + " REFERENCES package_app_info(app_id) ON DELETE CASCADE);" | sqlite3 $dbpath + echo "PRAGMA user_version=30004;" | sqlite3 $dbpath } -- 2.34.1