Add database upgrade script v0.2.0

1 files changed, 10 insertions, 0 deletions

diff --git a/database-prepare-for-0.2.0.sh b/database-prepare-for-0.2.0.sh
new file mode 100755

index 0000000000..e90171010b
--- /dev/null
+++ b/database-prepare-for-0.2.0.sh
@@ -0,0 +1,10 @@
+#!/bin/bash
+
+# This is will prepare a synapse database for running with v0.2.0 of synapse. 
+
+set -e
+
+cp "$1" "$1.bak"
+
+sqlite3 "$1" < "synapse/storage/schema/im.sql" 
+sqlite3 "$1" <<< "PRAGMA user_version = 2;"