diff options
| author | Erik Johnston <erik@matrix.org> | 2015-02-06 14:38:04 +0000 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-02-06 14:38:04 +0000 |
| commit | 0cd66885e3ff7828282cc03dd8189763fdb7b927 (patch) | |
| tree | cb74f4a479abae1659ee71e4b15d9fa2b9157903 /synapse/storage/schema/delta/v12.sql | |
| parent | Don't query auth if the only difference is events that were rejected due to a... (diff) | |
| download | synapse-0cd66885e3ff7828282cc03dd8189763fdb7b927.tar.xz | |
Move delta/v13.sql to delta/v12.sql
Diffstat (limited to 'synapse/storage/schema/delta/v12.sql')
| -rw-r--r-- | synapse/storage/schema/delta/v12.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/v12.sql b/synapse/storage/schema/delta/v12.sql index 16c2258ca4..302d958dbf 100644 --- a/synapse/storage/schema/delta/v12.sql +++ b/synapse/storage/schema/delta/v12.sql @@ -52,3 +52,14 @@ CREATE TABLE IF NOT EXISTS push_rules ( ); CREATE INDEX IF NOT EXISTS push_rules_user_name on push_rules (user_name); + +CREATE TABLE IF NOT EXISTS user_filters( + user_id TEXT, + filter_id INTEGER, + filter_json TEXT, + FOREIGN KEY(user_id) REFERENCES users(id) +); + +CREATE INDEX IF NOT EXISTS user_filters_by_user_id_filter_id ON user_filters( + user_id, filter_id +); |