diff options
| author | Mark Haines <mjark@negativecurvature.net> | 2016-09-09 11:24:27 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-09-09 11:24:27 +0100 |
| commit | 303b6f29f0392f14f1707a6f95d95f23dcf34692 (patch) | |
| tree | 1ab552d614e3629df40a3b7364eff103657418fd /synapse/storage/schema | |
| parent | Merge branch 'release-v0.17.3' of github.com:matrix-org/synapse into develop (diff) | |
| parent | Just move the schema and add some DROPs (diff) | |
| download | synapse-303b6f29f0392f14f1707a6f95d95f23dcf34692.tar.xz | |
Merge pull request #1087 from matrix-org/markjh/reapply_delta
Reapply 34/device_outbox in 35/device_outbox_again.py since the schem…
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/35/device_outbox.sql (renamed from synapse/storage/schema/delta/34/device_outbox.sql) | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/34/device_outbox.sql b/synapse/storage/schema/delta/35/device_outbox.sql index e87066d9a1..17e6c43105 100644 --- a/synapse/storage/schema/delta/34/device_outbox.sql +++ b/synapse/storage/schema/delta/35/device_outbox.sql @@ -13,6 +13,7 @@ * limitations under the License. */ +DROP TABLE IF EXISTS device_federation_outbox; CREATE TABLE device_federation_outbox ( destination TEXT NOT NULL, stream_id BIGINT NOT NULL, @@ -21,16 +22,18 @@ CREATE TABLE device_federation_outbox ( ); +DROP INDEX IF EXISTS device_federation_outbox_destination_id; CREATE INDEX device_federation_outbox_destination_id ON device_federation_outbox(destination, stream_id); +DROP TABLE IF EXISTS device_federation_inbox; CREATE TABLE device_federation_inbox ( origin TEXT NOT NULL, message_id TEXT NOT NULL, received_ts BIGINT NOT NULL ); - +DROP INDEX IF EXISTS device_federation_inbox_sender_id; CREATE INDEX device_federation_inbox_sender_id ON device_federation_inbox(origin, message_id); |