add inidexes based on usage

1 files changed, 2 insertions, 6 deletions

diff --git a/synapse/storage/schema/delta/49/add_user_daily_visits.sql b/synapse/storage/schema/delta/49/add_user_daily_visits.sql

index 11356a97fc..3dd478196f 100644
--- a/synapse/storage/schema/delta/49/add_user_daily_visits.sql
+++ b/synapse/storage/schema/delta/49/add_user_daily_visits.sql
@@ -16,10 +16,6 @@
 
 CREATE TABLE user_daily_visits ( user_id TEXT NOT NULL,
                                  device_id TEXT,
-                                 user_agent TEXT NOT NULL,
                                  timestamp BIGINT NOT NULL );
-
-/* What indexes should I include?
- * Reads are offline so should optimise for writes
- * Need to check if already an entry so user,day
- */
+CREATE INDEX user_daily_visits_uts_idx ON user_daily_visits(user_id, timestamp);
+CREATE INDEX user_daily_visits_ts_idx ON user_daily_visits(timestamp);