mirror of
https://github.com/mautrix/whatsapp.git
synced 2026-11-11 00:29:17 -05:00
10 lines
441 B
SQL
10 lines
441 B
SQL
-- v11 (compatible with v3+): Re-arm backfill for chats with leftover history sync messages
|
|
UPDATE backfill_task
|
|
SET is_done=false, queue_done=false, dispatched_at=NULL, completed_at=NULL
|
|
WHERE (is_done OR queue_done) AND EXISTS (
|
|
SELECT 1
|
|
FROM whatsapp_history_sync_message msg
|
|
WHERE msg.bridge_id=backfill_task.bridge_id
|
|
AND msg.user_login_id=backfill_task.user_login_id
|
|
AND msg.chat_jid=backfill_task.portal_id
|
|
);
|