status-im/status-go

appdatabase/migrations/sql/1664783660_add_sync_info_to_saved_addresses.up.sql

Summary

Maintainability

Test Coverage

Issues

ALTER TABLE saved_addresses ADD COLUMN removed BOOLEAN NOT NULL DEFAULT 0;
-- Represents wall clock time as unixepoch timestamp
ALTER TABLE saved_addresses ADD COLUMN update_clock INT NOT NULL DEFAULT 0;
-- Update using the current timestamp to deconflict devices already in sync. Wins the last one to update
UPDATE saved_addresses SET update_clock = (CAST(strftime('%s', 'now') AS INT));