diff options
| author | David Baker <dave@matrix.org> | 2015-02-25 19:17:07 +0000 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2015-02-25 19:17:07 +0000 |
| commit | 94fa334b01d232bed96fd4ee05fc44d00330c2b9 (patch) | |
| tree | f680ff0fb9a16a54a083d63e44fd2d6b04093a2a /synapse/storage/schema | |
| parent | SYWEB-278 Don't allow rules with no rule_id. (diff) | |
| download | synapse-94fa334b01d232bed96fd4ee05fc44d00330c2b9.tar.xz | |
Add enable/disable overlay for push rules (REST API not yet hooked up)
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/next_pushrules2.sql | 9 | ||||
| -rw-r--r-- | synapse/storage/schema/pusher.sql | 10 |
2 files changed, 19 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/next_pushrules2.sql b/synapse/storage/schema/delta/next_pushrules2.sql new file mode 100644 index 0000000000..0212726448 --- /dev/null +++ b/synapse/storage/schema/delta/next_pushrules2.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); diff --git a/synapse/storage/schema/pusher.sql b/synapse/storage/schema/pusher.sql index 3735b11547..31bf1cb685 100644 --- a/synapse/storage/schema/pusher.sql +++ b/synapse/storage/schema/pusher.sql @@ -44,3 +44,13 @@ 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 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); |