summary refs log tree commit diff
path: root/synapse/storage/schema/delta/14/v14.sql
blob: 021272644888621b8c1240f3b3dad439cbd33bae (plain) (blame)
1
2
3
4
5
6
7
8
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);