v14.sql 280 B

123456789
  1. CREATE TABLE IF NOT EXISTS push_rules_enable (
  2. id INTEGER PRIMARY KEY AUTOINCREMENT,
  3. user_name TEXT NOT NULL,
  4. rule_id TEXT NOT NULL,
  5. enabled TINYINT,
  6. UNIQUE(user_name, rule_id)
  7. );
  8. CREATE INDEX IF NOT EXISTS push_rules_enable_user_name on push_rules_enable (user_name);