2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: deleted_messages
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: chat_handle_join
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: sync_deleted_messages
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: message_processing_task
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: handle
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: sync_deleted_chats
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: message_attachment_join
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: sync_deleted_attachments
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: kvtable
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created table (if needed) ok: chat_message_join
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_expire_state
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_attachment_join_idx_message_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_handle_join_idx_handle_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_attachment_join_idx_attachment_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_date
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_handle
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_handle_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_is_sent_is_from_me_error
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_message_join_idx_message_id_only
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_associated_message
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_idx_chat_identifier
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_processing_task_idx_guid_task_flags
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_message_join_idx_chat_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_cache_has_attachments
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_idx_chat_room_name_service_name
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_other_handle
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_was_downgraded
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_idx_is_archived
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_idx_chat_identifier_service_name
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: chat_message_join_idx_message_date_id_chat_id
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_is_read
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_isRead_isFromMe_itemType
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created index ok: message_idx_failed
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_chat_message_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat_message_join AFTER DELETE ON chat_message_join BEGIN     UPDATE message       SET cache_roomnames = (         SELECT group_concat(c.room_name)         FROM chat c         INNER JOIN chat_message_join j ON c.ROWID = j.chat_id         WHERE           j.message_id = OLD.message_id       )       WHERE         message.ROWID = OLD.message_id;  DELETE FROM message WHERE message.ROWID = OLD.message_id AND OLD.message_id NOT IN (SELECT chat_message_join.message_id from chat_message_join WHERE chat_message_join.message_id = OLD.message_id LIMIT 1); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_attachment, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_attachment AFTER DELETE ON attachment BEGIN   SELECT delete_attachment_path(OLD.filename); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_insert_on_message_attachment_join, trigger: CREATE TRIGGER IF NOT EXISTS after_insert_on_message_attachment_join AFTER INSERT ON message_attachment_join BEGIN     UPDATE message       SET cache_has_attachments = 1     WHERE       message.ROWID = NEW.message_id; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_chat_handle_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat_handle_join AFTER DELETE ON chat_handle_join BEGIN     DELETE FROM handle         WHERE handle.ROWID = OLD.handle_id     AND         (SELECT 1 from chat_handle_join WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE other_handle = OLD.handle_id LIMIT 1) IS NULL; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_insert_on_chat_message_join , trigger: CREATE TRIGGER IF NOT EXISTS after_insert_on_chat_message_join  AFTER INSERT ON chat_message_join BEGIN     UPDATE message       SET cache_roomnames = (         SELECT group_concat(c.room_name)         FROM chat c         INNER JOIN chat_message_join j ON c.ROWID = j.chat_id         WHERE           j.message_id = NEW.message_id       )       WHERE         message.ROWID = NEW.message_id; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_message, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_message AFTER DELETE ON message BEGIN     DELETE FROM handle         WHERE handle.ROWID = OLD.handle_id     AND         (SELECT 1 from chat_handle_join WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE other_handle = OLD.handle_id LIMIT 1) IS NULL; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: update_message_date_after_update_on_message, trigger: CREATE TRIGGER IF NOT EXISTS update_message_date_after_update_on_message AFTER UPDATE OF date ON message BEGIN UPDATE chat_message_join SET message_date = NEW.date WHERE message_id = NEW.ROWID AND message_date != NEW.date; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: add_to_sync_deleted_messages, trigger: CREATE TRIGGER IF NOT EXISTS add_to_sync_deleted_messages AFTER DELETE ON message BEGIN     INSERT INTO sync_deleted_messages (guid, recordID) VALUES (OLD.guid, OLD.ck_record_id); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_chat, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat AFTER DELETE ON chat BEGIN DELETE FROM chat_message_join WHERE chat_id = OLD.ROWID; END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: delete_associated_messages_after_delete_on_message, trigger: CREATE TRIGGER IF NOT EXISTS delete_associated_messages_after_delete_on_message AFTER DELETE ON message BEGIN DELETE FROM message WHERE (OLD.associated_message_guid IS NULL AND associated_message_guid IS NOT NULL AND guid = OLD.associated_message_guid); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: before_delete_on_attachment, trigger: CREATE TRIGGER IF NOT EXISTS before_delete_on_attachment BEFORE DELETE ON attachment BEGIN   SELECT before_delete_attachment_path(OLD.ROWID, OLD.guid); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: add_to_sync_deleted_attachments, trigger: CREATE TRIGGER IF NOT EXISTS add_to_sync_deleted_attachments AFTER DELETE ON attachment BEGIN     INSERT INTO sync_deleted_attachments (guid, recordID) VALUES (OLD.guid, OLD.ck_record_id); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: add_to_deleted_messages, trigger: CREATE TRIGGER IF NOT EXISTS add_to_deleted_messages AFTER DELETE ON message BEGIN     INSERT INTO deleted_messages (guid) VALUES (OLD.guid); END
2022-06-07 15:31:43 -0700 IMDPersistenceAgent[614]: Created trigger ok: after_delete_on_message_attachment_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_message_attachment_join AFTER DELETE ON message_attachment_join BEGIN     DELETE FROM attachment         WHERE attachment.ROWID = OLD.attachment_id     AND         (SELECT 1 from message_attachment_join WHERE attachment_id = OLD.attachment_id LIMIT 1) IS NULL; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: The current SMS database is v12005.  The current schema version is v15009. Can be migrated: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Beginning migration.  The SMS db is currently at v12005, upgrading to v15009.
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Integrity checked success
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Initial Integrity checked success
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_attachment
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_insert_on_message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_insert_on_chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_message
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: update_message_date_after_update_on_message
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: add_to_sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_chat
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: delete_associated_messages_after_delete_on_message
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: before_delete_on_attachment
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: add_to_sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: add_to_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped trigger: after_delete_on_message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column reply_to_guid to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column sort_id to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 12005 to 13000 ok in 0.006167 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column is_spam to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13000 to 13001 ok in 0.001603 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13001 to 13002 ok in 0.000644 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13002 to 13003 ok in 0.000479 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13003 to 13004 ok in 0.000571 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column is_blackholed to chat succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13004 to 13500 ok in 0.001334 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column has_unseen_mention to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 13500 to 14000 ok in 0.001924 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column thread_originator_guid to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14000 to 14001 ok in 0.001652 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14001 to 14002 ok in 0.000712 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column thread_originator_part to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14002 to 14003 ok in 0.001547 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14003 to 14004 ok in 0.000765 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14004 to 14005 ok in 0.000630 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14005 to 14006 ok in 0.000678 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column syndication_ranges to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 14006 to 15000 ok in 0.001564 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15000 to 15001 ok in 0.000698 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column is_commsafety_sensitive to attachment succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15001 to 15002 ok in 0.001409 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column was_delivered_quietly to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column did_notify_recipient to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15002 to 15003 ok in 0.002783 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column synced_syndication_ranges to message succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15003 to 15004 ok in 0.001621 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column syndication_date to chat succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Adding column syndication_type to chat succeeded: YES
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15004 to 15005 ok in 0.002188 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15005 to 15007 ok in 0.000698 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15007 to 15008 ok in 0.000552 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Dropped table (if needed) ok: sqlite_stat1
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Migrated from 15008 to 15009 ok in 0.000748 seconds
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_handle_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_messages
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_processing_task
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_chats
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: message_attachment_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: sync_deleted_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: kvtable
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created table (if needed) ok: chat_message_join
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_attachment_join_idx_message_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_idx_chat_identifier_service_name
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_handle_join_idx_handle_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_attachment_join_idx_attachment_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_date
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: attachment_idx_purged_attachments_v2
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_thread_originator_guid
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_handle_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_is_sent_is_from_me_error
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_message_join_idx_message_id_only
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_associated_message
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_idx_chat_identifier
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_processing_task_idx_guid_task_flags
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_undelivered_one_to_one_imessage
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_message_join_idx_chat_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_cache_has_attachments
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_idx_chat_room_name_service_name
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_other_handle
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_was_downgraded
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_idx_is_archived
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_idx_group_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_expire_state
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: chat_message_join_idx_message_date_id_chat_id
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_is_read
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_isRead_isFromMe_itemType
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created index ok: message_idx_failed
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_chat_message_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat_message_join AFTER DELETE ON chat_message_join BEGIN     UPDATE message       SET cache_roomnames = (         SELECT group_concat(c.room_name)         FROM chat c         INNER JOIN chat_message_join j ON c.ROWID = j.chat_id         WHERE           j.message_id = OLD.message_id       )       WHERE         message.ROWID = OLD.message_id;  DELETE FROM message WHERE message.ROWID = OLD.message_id AND OLD.message_id NOT IN (SELECT chat_message_join.message_id from chat_message_join WHERE chat_message_join.message_id = OLD.message_id LIMIT 1); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_attachment, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_attachment AFTER DELETE ON attachment BEGIN   SELECT delete_attachment_path(OLD.filename); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_insert_on_message_attachment_join, trigger: CREATE TRIGGER IF NOT EXISTS after_insert_on_message_attachment_join AFTER INSERT ON message_attachment_join BEGIN     UPDATE message       SET cache_has_attachments = 1     WHERE       message.ROWID = NEW.message_id; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_chat_handle_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat_handle_join AFTER DELETE ON chat_handle_join BEGIN     DELETE FROM handle         WHERE handle.ROWID = OLD.handle_id     AND         (SELECT 1 from chat_handle_join WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE other_handle = OLD.handle_id LIMIT 1) IS NULL; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_insert_on_chat_message_join , trigger: CREATE TRIGGER IF NOT EXISTS after_insert_on_chat_message_join  AFTER INSERT ON chat_message_join BEGIN     UPDATE message       SET cache_roomnames = (         SELECT group_concat(c.room_name)         FROM chat c         INNER JOIN chat_message_join j ON c.ROWID = j.chat_id         WHERE           j.message_id = NEW.message_id       )       WHERE         message.ROWID = NEW.message_id; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_message, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_message AFTER DELETE ON message BEGIN     DELETE FROM handle         WHERE handle.ROWID = OLD.handle_id     AND         (SELECT 1 from chat_handle_join WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE handle_id = OLD.handle_id LIMIT 1) IS NULL     AND         (SELECT 1 from message WHERE other_handle = OLD.handle_id LIMIT 1) IS NULL; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: update_message_date_after_update_on_message, trigger: CREATE TRIGGER IF NOT EXISTS update_message_date_after_update_on_message AFTER UPDATE OF date ON message BEGIN UPDATE chat_message_join SET message_date = NEW.date WHERE message_id = NEW.ROWID AND message_date != NEW.date; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_message_plugin, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_message_plugin AFTER DELETE ON message WHEN OLD.balloon_bundle_id IS NOT NULL BEGIN   SELECT after_delete_message_plugin(OLD.ROWID, OLD.guid); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: add_to_sync_deleted_messages, trigger: CREATE TRIGGER IF NOT EXISTS add_to_sync_deleted_messages AFTER DELETE ON message BEGIN     INSERT INTO sync_deleted_messages (guid, recordID) VALUES (OLD.guid, OLD.ck_record_id); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_chat, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_chat AFTER DELETE ON chat BEGIN DELETE FROM chat_message_join WHERE chat_id = OLD.ROWID; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: delete_associated_messages_after_delete_on_message, trigger: CREATE TRIGGER IF NOT EXISTS delete_associated_messages_after_delete_on_message AFTER DELETE ON message BEGIN DELETE FROM message WHERE (OLD.associated_message_guid IS NULL AND associated_message_guid IS NOT NULL AND guid = OLD.associated_message_guid); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: before_delete_on_attachment, trigger: CREATE TRIGGER IF NOT EXISTS before_delete_on_attachment BEFORE DELETE ON attachment BEGIN   SELECT before_delete_attachment_path(OLD.ROWID, OLD.guid); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: add_to_sync_deleted_attachments, trigger: CREATE TRIGGER IF NOT EXISTS add_to_sync_deleted_attachments AFTER DELETE ON attachment BEGIN     INSERT INTO sync_deleted_attachments (guid, recordID) VALUES (OLD.guid, OLD.ck_record_id); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: add_to_deleted_messages, trigger: CREATE TRIGGER IF NOT EXISTS add_to_deleted_messages AFTER DELETE ON message BEGIN     INSERT INTO deleted_messages (guid) VALUES (OLD.guid); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: after_delete_on_message_attachment_join, trigger: CREATE TRIGGER IF NOT EXISTS after_delete_on_message_attachment_join AFTER DELETE ON message_attachment_join BEGIN     DELETE FROM attachment         WHERE attachment.ROWID = OLD.attachment_id     AND         (SELECT 1 from message_attachment_join WHERE attachment_id = OLD.attachment_id LIMIT 1) IS NULL; END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Created trigger ok: update_last_failed_message_date, trigger: CREATE TRIGGER IF NOT EXISTS update_last_failed_message_date AFTER UPDATE OF error ON message WHEN   NEW.error != 0 AND NEW.date > COALESCE((SELECT value FROM kvtable WHERE key = 'lastFailedMessageDate'), 0) BEGIN   INSERT OR REPLACE INTO kvtable (key, value) VALUES ('lastFailedMessageDate', NEW.date);   INSERT OR REPLACE INTO kvtable (key, value) VALUES ('lastFailedMessageRowID', NEW.rowID); END
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Integrity checked success
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Message database migration passed post migrate integrity check
2022-06-08 10:03:30 -0300 IMDPersistenceAgent[565]: Message's DB migration took 0.043764 seconds.