summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2019-09-23 15:59:43 +0100
committerErik Johnston <erik@matrix.org>2019-09-23 16:59:45 +0100
commited80231ade20ce7881bb2026692fe3a6252f1c02 (patch)
tree0192a94f91331327f0234fa7de438cd49adfe6cf /synapse/storage/schema/delta
parentAdd last seen info to devices table. (diff)
downloadsynapse-ed80231ade20ce7881bb2026692fe3a6252f1c02.tar.xz
Add BG update to populate devices last seen info
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/56/devices_last_seen.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/56/devices_last_seen.sql b/synapse/storage/schema/delta/56/devices_last_seen.sql
index 8818eeeb7e..dfa902d0ba 100644
--- a/synapse/storage/schema/delta/56/devices_last_seen.sql
+++ b/synapse/storage/schema/delta/56/devices_last_seen.sql
@@ -19,3 +19,6 @@
 ALTER TABLE devices ADD COLUMN last_seen BIGINT;
 ALTER TABLE devices ADD COLUMN ip TEXT;
 ALTER TABLE devices ADD COLUMN user_agent TEXT;
+
+INSERT INTO background_updates (update_name, progress_json) VALUES
+  ('devices_last_seen', '{}');