Skip to content

Instantly share code, notes, and snippets.

@sash13
Created May 25, 2018 09:28
Show Gist options
  • Save sash13/1f141705b56fcc0e4b4fe743585fbf47 to your computer and use it in GitHub Desktop.
Save sash13/1f141705b56fcc0e4b4fe743585fbf47 to your computer and use it in GitHub Desktop.
Remove t2bot chat
DELETE FROM event_edges WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_depth WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM state_forward_extremities WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM events WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM event_json WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM state_events WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM current_state_events WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_memberships WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM feedback WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM topics WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_names WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM rooms WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_hosts WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_aliases WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM state_groups WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM state_groups_state WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM receipts_graph WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM receipts_linearized WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM event_search_content WHERE c1room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM guest_access WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM history_visibility WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_tags WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_tags_revisions WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM room_account_data WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM event_push_actions WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM local_invites WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM pusher_throttle WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM event_reports WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM public_room_list_stream WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM stream_ordering_to_exterm WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM event_auth WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
DELETE FROM appservice_room_list WHERE room_id = '!PVNuPWbpXKukMcpzUY:t2bot.io';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment