summary refs log tree commit diff
path: root/synapse/storage/schema/delta/32
diff options
context:
space:
mode:
authorNeil Johnson <neil@matrix.org>2019-04-08 15:37:26 +0100
committerGitHub <noreply@github.com>2019-04-08 15:37:26 +0100
commit2d951686a71fd0c8b927d96fa183747ff2982bf9 (patch)
tree126fa291fe4baed6a91f1a7816d068edb7f4b00d /synapse/storage/schema/delta/32
parentMerge pull request #5001 from matrix-org/rav/keyring_cleanups (diff)
downloadsynapse-2d951686a71fd0c8b927d96fa183747ff2982bf9.tar.xz
drop tables listed in #1830 (#4992)
Tables dropped: 
 * application_services, 
 * application_services_regex, 
 * transaction_id_to_pdu, 
 * stats_reporting
 * current_state_resets
 * event_content_hashes
 * event_destinations
 * event_edge_hashes
 * event_signatures
 * feedback
 * room_hosts
 * state_forward_extremities
Diffstat (limited to 'synapse/storage/schema/delta/32')
-rw-r--r--synapse/storage/schema/delta/32/remove_indices.sql4
1 files changed, 0 insertions, 4 deletions
diff --git a/synapse/storage/schema/delta/32/remove_indices.sql b/synapse/storage/schema/delta/32/remove_indices.sql

index f859be46a6..4219cdd06a 100644 --- a/synapse/storage/schema/delta/32/remove_indices.sql +++ b/synapse/storage/schema/delta/32/remove_indices.sql
@@ -24,13 +24,9 @@ DROP INDEX IF EXISTS state_groups_id; -- Duplicate of PRIMARY KEY DROP INDEX IF EXISTS event_to_state_groups_id; -- Duplicate of PRIMARY KEY DROP INDEX IF EXISTS event_push_actions_room_id_event_id_user_id_profile_tag; -- Duplicate of UNIQUE CONSTRAINT -DROP INDEX IF EXISTS event_destinations_id; -- Prefix of UNIQUE CONSTRAINT DROP INDEX IF EXISTS st_extrem_id; -- Prefix of UNIQUE CONSTRAINT -DROP INDEX IF EXISTS event_content_hashes_id; -- Prefix of UNIQUE CONSTRAINT DROP INDEX IF EXISTS event_signatures_id; -- Prefix of UNIQUE CONSTRAINT -DROP INDEX IF EXISTS event_edge_hashes_id; -- Prefix of UNIQUE CONSTRAINT DROP INDEX IF EXISTS redactions_event_id; -- Duplicate of UNIQUE CONSTRAINT -DROP INDEX IF EXISTS room_hosts_room_id; -- Prefix of UNIQUE CONSTRAINT -- The following indices were unused DROP INDEX IF EXISTS remote_media_cache_thumbnails_media_id;