diff --git a/synapse/storage/schema/delta/12/v12.sql b/synapse/storage/schema/delta/12/v12.sql
index 90ac474859..717d289f78 100644
--- a/synapse/storage/schema/delta/12/v12.sql
+++ b/synapse/storage/schema/delta/12/v12.sql
@@ -14,16 +14,16 @@
*/
CREATE TABLE IF NOT EXISTS rejections(
- event_id VARCHAR(255) NOT NULL,
- reason VARCHAR(255) NOT NULL,
- last_check VARCHAR(255) NOT NULL,
+ event_id VARCHAR(150) NOT NULL,
+ reason VARCHAR(150) NOT NULL,
+ last_check VARCHAR(150) NOT NULL,
UNIQUE (event_id)
) ;
-- Push notification endpoints that users have configured
CREATE TABLE IF NOT EXISTS pushers (
id BIGINT PRIMARY KEY,
- user_name VARCHAR(255) NOT NULL,
+ user_name VARCHAR(150) NOT NULL,
profile_tag VARCHAR(32) NOT NULL,
kind VARCHAR(8) NOT NULL,
app_id VARCHAR(64) NOT NULL,
@@ -41,19 +41,19 @@ CREATE TABLE IF NOT EXISTS pushers (
CREATE TABLE IF NOT EXISTS push_rules (
id BIGINT PRIMARY KEY,
- user_name VARCHAR(255) NOT NULL,
- rule_id VARCHAR(255) NOT NULL,
+ user_name VARCHAR(150) NOT NULL,
+ rule_id VARCHAR(150) NOT NULL,
priority_class TINYINT NOT NULL,
priority INTEGER NOT NULL DEFAULT 0,
- conditions VARCHAR(255) NOT NULL,
- actions VARCHAR(255) NOT NULL,
+ conditions VARCHAR(150) NOT NULL,
+ actions VARCHAR(150) NOT NULL,
UNIQUE(user_name, rule_id)
) ;
CREATE INDEX IF NOT EXISTS push_rules_user_name on push_rules (user_name);
CREATE TABLE IF NOT EXISTS user_filters(
- user_id VARCHAR(255),
+ user_id VARCHAR(150),
filter_id BIGINT,
filter_json BLOB
) ;
|