diff options
| author | Neil Johnson <neil@matrix.org> | 2018-08-02 10:59:58 +0100 |
|---|---|---|
| committer | Neil Johnson <neil@matrix.org> | 2018-08-02 10:59:58 +0100 |
| commit | 165e06703340667dd88eb73dfe299a4d3298b94b (patch) | |
| tree | c8043934dfa079b3af4de4c942917c10df1237e0 /synapse/storage/schema | |
| parent | change monthly_active_users table to be a single column (diff) | |
| download | synapse-165e06703340667dd88eb73dfe299a4d3298b94b.tar.xz | |
Revert "change monthly_active_users table to be a single column"
This reverts commit ec716a35b219d147dee51733b55573952799a549.
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/51/monthly_active_users.sql | 4 |
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); |