summary refs log tree commit diff
path: root/nuke-room-from-db.sh
diff options
context:
space:
mode:
authorMark Haines <mark.haines@matrix.org>2015-01-15 16:57:00 +0000
committerMark Haines <mark.haines@matrix.org>2015-01-22 11:14:14 +0000
commitf4ce61ed36e7b639550953882b6ea14171108784 (patch)
treefe6e5567f13388d81f02db7a540b44fdda74d99d /nuke-room-from-db.sh
parentAbstract out the room ID from presence tests, so it's stored in self (diff)
downloadsynapse-f4ce61ed36e7b639550953882b6ea14171108784.tar.xz
Move scripts into scripts
Diffstat (limited to 'nuke-room-from-db.sh')
-rwxr-xr-xnuke-room-from-db.sh24
1 files changed, 0 insertions, 24 deletions
diff --git a/nuke-room-from-db.sh b/nuke-room-from-db.sh
deleted file mode 100755
index 58c036c896..0000000000
--- a/nuke-room-from-db.sh
+++ /dev/null
@@ -1,24 +0,0 @@
-#!/bin/bash
-
-## CAUTION:
-## This script will remove (hopefully) all trace of the given room ID from
-## your homeserver.db
-
-## Do not run it lightly.
-
-ROOMID="$1"
-
-sqlite3 homeserver.db <<EOF
-DELETE FROM context_depth WHERE context = '$ROOMID';
-DELETE FROM current_state WHERE context = '$ROOMID';
-DELETE FROM feedback WHERE room_id = '$ROOMID';
-DELETE FROM messages WHERE room_id = '$ROOMID';
-DELETE FROM pdu_backward_extremities WHERE context = '$ROOMID';
-DELETE FROM pdu_edges WHERE context = '$ROOMID';
-DELETE FROM pdu_forward_extremities WHERE context = '$ROOMID';
-DELETE FROM pdus WHERE context = '$ROOMID';
-DELETE FROM room_data WHERE room_id = '$ROOMID';
-DELETE FROM room_memberships WHERE room_id = '$ROOMID';
-DELETE FROM rooms WHERE room_id = '$ROOMID';
-DELETE FROM state_pdus WHERE context = '$ROOMID';
-EOF