diff options
| author | Erik Johnston <erik@matrix.org> | 2019-09-23 15:59:43 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2019-09-23 16:59:45 +0100 |
| commit | ed80231ade20ce7881bb2026692fe3a6252f1c02 (patch) | |
| tree | 0192a94f91331327f0234fa7de438cd49adfe6cf /synapse/storage/schema | |
| parent | Add last seen info to devices table. (diff) | |
| download | synapse-ed80231ade20ce7881bb2026692fe3a6252f1c02.tar.xz | |
Add BG update to populate devices last seen info
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/56/devices_last_seen.sql | 3 |
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', '{}'); |