diff options
| author | Erik Johnston <erik@matrix.org> | 2014-09-25 17:02:53 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-09-25 17:02:53 +0100 |
| commit | 37bfe44046d46effba5f86b65ab37fa0d0c505b0 (patch) | |
| tree | 9524fd5e5ac1637982549030a2759aaf538e8ac2 /synapse/storage/schema/delta/v4.sql | |
| parent | fix rst warnings (diff) | |
| parent | Don't strip out null's in serialized events, as that is not need anymore and ... (diff) | |
| download | synapse-37bfe44046d46effba5f86b65ab37fa0d0c505b0.tar.xz | |
Merge branch 'deletions' of github.com:matrix-org/synapse into develop
Diffstat (limited to 'synapse/storage/schema/delta/v4.sql')
| -rw-r--r-- | synapse/storage/schema/delta/v4.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/v4.sql b/synapse/storage/schema/delta/v4.sql new file mode 100644 index 0000000000..25d2ead450 --- /dev/null +++ b/synapse/storage/schema/delta/v4.sql @@ -0,0 +1,12 @@ +CREATE TABLE IF NOT EXISTS redactions ( + event_id TEXT NOT NULL, + redacts TEXT NOT NULL, + CONSTRAINT ev_uniq UNIQUE (event_id) +); + +CREATE INDEX IF NOT EXISTS redactions_event_id ON redactions (event_id); +CREATE INDEX IF NOT EXISTS redactions_redacts ON redactions (redacts); + +ALTER TABLE room_ops_levels ADD COLUMN redact_level INTEGER; + +PRAGMA user_version = 4; |