v14.sql « 14 « delta « schema « storage « synapse - matrix/thirdparty/synapse.git - Unnamed repository; edit this file 'description' to name the repository.

index : matrix/thirdparty/synapse.git

Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/synapse/storage/schema/delta/14/v14.sql

blob: 8c47d4b0f4fd4f4f8b31f4a35b29a8a3f73f7a22 (plain) (blame)

CREATE TABLE IF NOT EXISTS push_rules_enable (
  id INTEGER 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);