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