1
0
Fork 0
mirror of https://github.com/mautrix/whatsapp.git synced 2026-05-16 02:26:53 -04:00
mautrix-whatsapp/pkg/connector/wadb/upgrades/06-conversation-bridged-ts.sql

4 lines
330 B
SQL

-- v6 (compatible with v3+): Store timestamp for which login a conversation was synced with
ALTER TABLE whatsapp_history_sync_conversation ADD COLUMN synced_login_ts BIGINT;
UPDATE whatsapp_history_sync_conversation SET synced_login_ts = 0 WHERE bridged = true;
ALTER TABLE whatsapp_history_sync_conversation DROP COLUMN bridged;