summary refs log tree commit diff
path: root/synapse/storage/schema/delta/14/v14.sql
blob: f1208c731d86fd7ab1f8e1762e8fb953f732000e (plain) (blame)
1
2
3
4
5
6
7
8
9
CREATE TABLE IF NOT EXISTS push_rules_enable (
  id BIGINT PRIMARY KEY,
  user_name VARCHAR(150) NOT NULL,
  rule_id VARCHAR(150) 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);