From 8c0dd3fa390cf480f4dd585aa075db1affd1b5d2 Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Tue, 11 Jun 2019 08:06:17 +0900 Subject: [PATCH] Modify to work only on server Change-Id: If84b91fb82230b78f77fc34116ef43d3bfd38be3 Signed-off-by: Minje Ahn --- svc/media_controller_db_util.c | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/svc/media_controller_db_util.c b/svc/media_controller_db_util.c index ca4d8d1..d67c68d 100644 --- a/svc/media_controller_db_util.c +++ b/svc/media_controller_db_util.c @@ -175,20 +175,16 @@ static int __mc_create_playlist_table(sqlite3 *handle) int ret = MEDIA_CONTROLLER_ERROR_NONE; char *sql_str = NULL; - sql_str = sqlite3_mprintf("CREATE TABLE IF NOT EXISTS %s (\ - server_name TEXT NOT NULL, \ - playlist_name TEXT NOT NULL, \ - item_index TEXT, \ - %s \ - unique(server_name, playlist_name, item_index));", + sql_str = sqlite3_mprintf("CREATE TABLE IF NOT EXISTS %s(server_name TEXT NOT NULL, playlist_name TEXT NOT NULL, item_index TEXT, \ + %s unique(server_name, playlist_name, item_index))", MC_DB_TABLE_PLAYLIST, META_FIELD); ret = mc_db_util_update_db(handle, sql_str); SQLITE3_SAFE_FREE(sql_str); mc_retvm_if(ret != MEDIA_CONTROLLER_ERROR_NONE, ret, "fail to create playlist table"); - sql_str = sqlite3_mprintf("CREATE TRIGGER IF NOT EXISTS %s DELETE ON %s BEGIN DELETE FROM %s WHERE server_name=old.name;END", - MC_DB_TRIGGER_PLAYLIST, MC_DB_TABLE_APP_LIST, MC_DB_TABLE_PLAYLIST); + sql_str = sqlite3_mprintf("CREATE TRIGGER IF NOT EXISTS %s AFTER DELETE ON %s WHEN old.type=%d BEGIN DELETE FROM %s WHERE server_name=old.name;END", + MC_DB_TRIGGER_PLAYLIST, MC_DB_TABLE_APP_LIST, MC_PRIV_TYPE_SERVER, MC_DB_TABLE_PLAYLIST); ret = mc_db_util_update_db(handle, sql_str); SQLITE3_SAFE_FREE(sql_str); -- 2.7.4