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