From 9e3b5f50a167daa23b3e52c6075644f74ade282c Mon Sep 17 00:00:00 2001 From: Somin Kim Date: Thu, 24 Aug 2017 18:18:15 +0900 Subject: [PATCH] RW script updated(drop unnecessary tables) Change-Id: I4626d3001166234115976f4e79779d839876c29d Signed-off-by: Somin Kim (cherry picked from commit 35625fd230c98662504d622ba46a7dd8fb350f82) --- scripts/500.context-service.sh | 16 +++++++++++++--- 1 file changed, 13 insertions(+), 3 deletions(-) diff --git a/scripts/500.context-service.sh b/scripts/500.context-service.sh index fe11dfc..3dcdfe0 100644 --- a/scripts/500.context-service.sh +++ b/scripts/500.context-service.sh @@ -31,8 +31,18 @@ chsmack -a User::Home $DB_CONTEXT_40_SENSOR_RECORDER-shm chsmack -a User::Home $DB_CONTEXT_40_SENSOR_RECORDER-wal # Drop tables not related to sensor recorder -sqlite3 $DB_CONTEXT_40_SENSOR_RECORDER "DROP TABLE ContextTriggerRule;" -sqlite3 $DB_CONTEXT_40_SENSOR_RECORDER "DROP TABLE ContextTriggerTemplate;" -sqlite3 $DB_CONTEXT_40_SENSOR_RECORDER "DROP TABLE ContextTriggerCustomTemplate;" +sqlite3 $DB_CONTEXT_40_SENSOR_RECORDER << EOF + +DROP TABLE IF EXISTS ContextTriggerRule; +DROP TABLE IF EXISTS ContextTriggerTemplate; +DROP TABLE IF EXISTS ContextTriggerCustomTemplate; + +DROP TABLE IF EXISTS Battery_LastInfo; +DROP TABLE IF EXISTS Log_AppLaunch; +DROP TABLE IF EXISTS Log_RemovableApp; +DROP TABLE IF EXISTS Temp_AppLaunchFreq ; +DROP TABLE IF EXISTS Temp_LastCpuUsagePerApp; +DROP TABLE IF EXISTS Log_BatteryUsagePerApp; +EOF fi -- 2.34.1