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);