From f13a554f4e1e9961261521639a4c29c24047600b Mon Sep 17 00:00:00 2001 From: Jeesun Kim Date: Fri, 8 Jan 2016 15:01:51 +0900 Subject: [PATCH] remove alias because alias is not applied in table Change-Id: I922c72a6de954fd42bcfb7e447772bfb6df6c52b --- server/db/ctsvc_db_init.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/server/db/ctsvc_db_init.c b/server/db/ctsvc_db_init.c index 29466ca..c5dd03b 100644 --- a/server/db/ctsvc_db_init.c +++ b/server/db/ctsvc_db_init.c @@ -910,9 +910,9 @@ static int __ctsvc_db_create_views() "CREATE VIEW IF NOT EXISTS "CTSVC_DB_VIEW_SIP" AS " "SELECT id, " "data.contact_id, " - "data1 address, " - "data2 type, " - "data3 label " + "data1, " + "data2, " + "data3 " "FROM "CTS_TABLE_DATA", "CTSVC_DB_VIEW_CONTACT" " "ON "CTS_TABLE_DATA".contact_id = "CTSVC_DB_VIEW_CONTACT".contact_id " "WHERE datatype = %d AND is_my_profile = 0 ", -- 2.7.4