summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorNeil Johnson <neil@matrix.org>2018-08-02 10:59:58 +0100
committerNeil Johnson <neil@matrix.org>2018-08-02 10:59:58 +0100
commit165e06703340667dd88eb73dfe299a4d3298b94b (patch)
treec8043934dfa079b3af4de4c942917c10df1237e0 /synapse/storage/schema/delta
parentchange monthly_active_users table to be a single column (diff)
downloadsynapse-165e06703340667dd88eb73dfe299a4d3298b94b.tar.xz
Revert "change monthly_active_users table to be a single column"
This reverts commit ec716a35b219d147dee51733b55573952799a549.
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/51/monthly_active_users.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/51/monthly_active_users.sql b/synapse/storage/schema/delta/51/monthly_active_users.sql
index 590b1abab2..f2b6d3e31e 100644
--- a/synapse/storage/schema/delta/51/monthly_active_users.sql
+++ b/synapse/storage/schema/delta/51/monthly_active_users.sql
@@ -15,7 +15,9 @@
 
 -- a table of monthly active users, for use where blocking based on mau limits
 CREATE TABLE monthly_active_users (
-    user_id TEXT NOT NULL
+    user_id TEXT NOT NULL,
+    timestamp BIGINT NOT NULL
 );
 
 CREATE UNIQUE INDEX monthly_active_users_users ON monthly_active_users(user_id);
+CREATE INDEX monthly_active_users_time_stamp ON monthly_active_users(timestamp);