summary refs log tree commit diff
path: root/synapse/storage/schema/deletions.sql
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2014-09-24 11:06:41 +0100
committerErik Johnston <erik@matrix.org>2014-09-24 11:06:41 +0100
commit4354590a69d2a9b8cfb0dd1e1bc677c118e68be4 (patch)
tree801c48d126ddb97c24a32ea30877e76fff844830 /synapse/storage/schema/deletions.sql
parentRename 'pruned' to 'pruned_because' (diff)
downloadsynapse-4354590a69d2a9b8cfb0dd1e1bc677c118e68be4.tar.xz
Add v4 deltas to current sql.
Diffstat (limited to 'synapse/storage/schema/deletions.sql')
-rw-r--r--synapse/storage/schema/deletions.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/synapse/storage/schema/deletions.sql b/synapse/storage/schema/deletions.sql
new file mode 100644
index 0000000000..2e2635317a
--- /dev/null
+++ b/synapse/storage/schema/deletions.sql
@@ -0,0 +1,7 @@
+CREATE TABLE IF NOT EXISTS deletions (
+    event_id TEXT NOT NULL,
+    deletes TEXT NOT NULL
+);
+
+CREATE INDEX IF NOT EXISTS deletions_event_id ON deletions (event_id);
+CREATE INDEX IF NOT EXISTS deletions_deletes ON deletions (deletes);