diff options
| author | David Baker <dave@matrix.org> | 2015-03-06 14:11:49 +0000 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2015-03-06 14:11:49 +0000 |
| commit | cf66ddc1b4eb95fc08d8d3f9292c5c7aa899ccd0 (patch) | |
| tree | 9b040ef8bfaee1e5f8cf4aaecc01af7a5520ca24 /synapse/storage/schema/delta/14 | |
| parent | Add more server default rules so we have default rules for whether you get no... (diff) | |
| download | synapse-cf66ddc1b4eb95fc08d8d3f9292c5c7aa899ccd0.tar.xz | |
Schema change as delta in v14
Diffstat (limited to 'synapse/storage/schema/delta/14')
| -rw-r--r-- | synapse/storage/schema/delta/14/v14.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/14/v14.sql b/synapse/storage/schema/delta/14/v14.sql new file mode 100644 index 0000000000..0212726448 --- /dev/null +++ b/synapse/storage/schema/delta/14/v14.sql @@ -0,0 +1,9 @@ +CREATE TABLE IF NOT EXISTS push_rules_enable ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + user_name TEXT NOT NULL, + rule_id TEXT NOT NULL, + enabled TINYINT, + UNIQUE(user_name, rule_id) +); + +CREATE INDEX IF NOT EXISTS push_rules_enable_user_name on push_rules_enable (user_name); |