From 6c49142c2e19002c8678ae1c1f5157432ab38af7 Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Thu, 29 Mar 2018 09:39:34 +0900 Subject: [PATCH] Modified the query target Change media table to media view for MMC separation Change-Id: Idb3091471c396765ab850089f5e2271022ecaf7b Signed-off-by: Minje Ahn --- src/dcm_svc_db.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/dcm_svc_db.c b/src/dcm_svc_db.c index 020ab19..1f69468 100755 --- a/src/dcm_svc_db.c +++ b/src/dcm_svc_db.c @@ -25,10 +25,10 @@ #define DB_TABLE_FACE "face" #define DB_TABLE_FACE_SCAN_LIST "face_scan_list" -#define DB_TABLE_MEDIA "media" +#define DB_VIEW_MEDIA "media_view" #define FACE_ITEM "media_uuid, face_rect_x , face_rect_y, face_rect_w , face_rect_h, orientation" -#define SELECT_MEDIA_INFO_BY_FILE_PATH_FROM_DB "SELECT media_uuid, width, height, orientation, mime_type, modified_time FROM "DB_TABLE_MEDIA" WHERE path = '%q';" +#define SELECT_MEDIA_INFO_BY_FILE_PATH_FROM_DB "SELECT media_uuid, width, height, orientation, mime_type, modified_time FROM "DB_VIEW_MEDIA" WHERE path = '%q';" #define SELECT_SCAN_INFO_BY_MEDIA_ID "SELECT modified_time FROM "DB_TABLE_FACE_SCAN_LIST" WHERE media_uuid = '%q';" #define INSERT_FACE_ITEM_TO_DB "INSERT OR IGNORE INTO " DB_TABLE_FACE" (" FACE_ITEM") VALUES ('%q', %d, %d, %d, %d, %d);" #define SELECT_FACE_COUNT_BY_MEDIA_ID "SELECT COUNT(*) FROM " DB_TABLE_FACE" WHERE media_uuid = '%q';" -- 2.34.1