summary refs log tree commit diff
path: root/synapse/storage/schema/delta/14
diff options
context:
space:
mode:
authorDavid Baker <dave@matrix.org>2015-03-06 14:11:49 +0000
committerDavid Baker <dave@matrix.org>2015-03-06 14:11:49 +0000
commitcf66ddc1b4eb95fc08d8d3f9292c5c7aa899ccd0 (patch)
tree9b040ef8bfaee1e5f8cf4aaecc01af7a5520ca24 /synapse/storage/schema/delta/14
parentAdd more server default rules so we have default rules for whether you get no... (diff)
downloadsynapse-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.sql9
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);