diff options
| author | Neil Johnson <neil@matrix.org> | 2019-04-08 15:37:26 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-04-08 15:37:26 +0100 |
| commit | 2d951686a71fd0c8b927d96fa183747ff2982bf9 (patch) | |
| tree | 126fa291fe4baed6a91f1a7816d068edb7f4b00d /synapse/storage/schema/delta/16 | |
| parent | Merge pull request #5001 from matrix-org/rav/keyring_cleanups (diff) | |
| download | synapse-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/16')
| -rw-r--r-- | synapse/storage/schema/delta/16/unique_constraints.sql | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/synapse/storage/schema/delta/16/unique_constraints.sql b/synapse/storage/schema/delta/16/unique_constraints.sql index fecf11118c..5b8de52c33 100644 --- a/synapse/storage/schema/delta/16/unique_constraints.sql +++ b/synapse/storage/schema/delta/16/unique_constraints.sql @@ -18,14 +18,6 @@ DROP INDEX IF EXISTS room_memberships_event_id; CREATE UNIQUE INDEX room_memberships_event_id ON room_memberships(event_id); -- -DELETE FROM feedback WHERE rowid not in ( - SELECT MIN(rowid) FROM feedback GROUP BY event_id -); - -DROP INDEX IF EXISTS feedback_event_id; -CREATE UNIQUE INDEX feedback_event_id ON feedback(event_id); - --- DELETE FROM topics WHERE rowid not in ( SELECT MIN(rowid) FROM topics GROUP BY event_id ); |