redactions.sql « 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/redactions.sql

blob: 4c2829d05d39741ea234342a4031edec251c81f9 (plain) (blame)

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