Fix 'frequency' statistics for the trigger to emit proper results

[platform/core/context/statistics-context-provider.git] / src / social / social_stats_types.h

diff --git a/src/social/social_stats_types.h b/src/social/social_stats_types.h
index 8f93273..18d2a2b 100644 (file)
--- a/src/social/social_stats_types.h
+++ b/src/social/social_stats_types.h
@@ -28,10 +28,10 @@
        "Duration INTEGER NOT NULL DEFAULT 0, " \
        "UTC TIMESTAMP DEFAULT (strftime('%s', 'now'))"
 
-#define SOCIAL_VIEW_CONTACT_FREQ       "View_ContactFreq"
-#define SOCIAL_VIEW_CONTACT_FREQ_SQL \
-       "CREATE VIEW IF NOT EXISTS " SOCIAL_VIEW_CONTACT_FREQ " AS " \
-       "SELECT Address, COUNT(*) AS TotalCount FROM " SOCIAL_TABLE_CONTACT_LOG " GROUP BY Address"
+#define SOCIAL_TEMP_CONTACT_FREQ       "Temp_ContactFreq"
+#define SOCIAL_TEMP_CONTACT_FREQ_SQL \
+       "CREATE TABLE IF NOT EXISTS " SOCIAL_TEMP_CONTACT_FREQ \
+       " (Address TEXT NOT NULL UNIQUE, TotalCount INTEGER DEFAULT 0);"
 
 #define SOCIAL_COMMUNICATION_TYPE      "CommunicationType"
 #define SOCIAL_ADDRESS                         "Address"