diff options
| author | Erik Johnston <erik@matrix.org> | 2015-07-09 11:39:30 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-07-09 11:39:30 +0100 |
| commit | 1af188209a03567dc4b5300b9a0fc8613ad176df (patch) | |
| tree | ecd87d77cadfbe5792d733bd408a12dbc6c77162 /synapse/storage/schema | |
| parent | Add blist to dependencies (diff) | |
| download | synapse-1af188209a03567dc4b5300b9a0fc8613ad176df.tar.xz | |
Change format of receipts to allow inclusion of data
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/21/receipts.sql | 16 |
1 files changed, 6 insertions, 10 deletions
diff --git a/synapse/storage/schema/delta/21/receipts.sql b/synapse/storage/schema/delta/21/receipts.sql index ac7738e371..2f64d609fc 100644 --- a/synapse/storage/schema/delta/21/receipts.sql +++ b/synapse/storage/schema/delta/21/receipts.sql @@ -18,11 +18,9 @@ CREATE TABLE IF NOT EXISTS receipts_graph( room_id TEXT NOT NULL, receipt_type TEXT NOT NULL, user_id TEXT NOT NULL, - event_id TEXT NOT NULL -); - -CREATE INDEX receipts_graph_room_tuple ON receipts_graph( - room_id, receipt_type, user_id + event_ids TEXT NOT NULL, + data TEXT NOT NULL, + CONSTRAINT receipts_graph_uniqueness UNIQUE (room_id, receipt_type, user_id) ); CREATE TABLE IF NOT EXISTS receipts_linearized ( @@ -30,11 +28,9 @@ CREATE TABLE IF NOT EXISTS receipts_linearized ( room_id TEXT NOT NULL, receipt_type TEXT NOT NULL, user_id TEXT NOT NULL, - event_id TEXT NOT NULL -); - -CREATE INDEX receipts_linearized_room_tuple ON receipts_linearized( - room_id, receipt_type, user_id + event_id TEXT NOT NULL, + data TEXT NOT NULL, + CONSTRAINT receipts_linearized_uniqueness UNIQUE (room_id, receipt_type, user_id) ); CREATE INDEX receipts_linearized_id ON receipts_linearized( |