2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created table if needed ok: deleted_messages
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created table if needed ok: chat_handle_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created table if needed ok: chat_message_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created table if needed ok: message_attachment_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created table if needed ok: handle
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_handle_join_idx_handle_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_is_read
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_message_join_idx_chat_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_idx_is_archived
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_idx_chat_room_name_service_name
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_handle_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_message_join_idx_message_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_idx_chat_identifier
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_message_join_idx_message_id_only
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_failed
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: chat_idx_chat_identifier_service_name
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_handle
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_attachment_join_idx_attachment_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_date
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_expire_state
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_other_handle
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_attachment_join_idx_message_id
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created index ok: message_idx_was_downgraded
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_insert_on_message_attachment_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_chat_message_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_attachment
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_message_attachment_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: add_to_deleted_messages
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_chat
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: before_delete_on_attachment
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_chat_handle_join
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_delete_on_message
2017-05-28 16:56:44 -0700 IMDPersistenceAgent[420]: Created trigger ok: after_insert_on_chat_message_join 
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: The current SMS database is v9005.  The current schema version is v10013. Can be migrated: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Beginning migration.  The SMS db is currently at v9005, upgrading to v10013.
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Integrity checked success
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Initial Integrity checked success
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_insert_on_message_attachment_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_chat_message_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_attachment
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_message_attachment_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: add_to_deleted_messages
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_chat
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: before_delete_on_attachment
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_chat_handle_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_delete_on_message
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped trigger: after_insert_on_chat_message_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 9005 to 9006 ok in 0.001777 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column associated_message_guid to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 9006 to 10000 ok in 0.000931 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column balloon_bundle_id to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column payload_data to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10000 to 10001 ok in 0.000943 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column is_sticker to attachment succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column sticker_user_info to attachment succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10001 to 10002 ok in 0.000672 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10002 to 10003 ok in 0.000179 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column associated_message_type to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10003 to 10004 ok in 0.000773 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column expressive_send_style_id to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10004 to 10005 ok in 0.000576 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10005 to 10006 ok in 0.000167 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column associated_message_range_location to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column associated_message_range_length to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10006 to 10007 ok in 0.000916 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column time_expressive_send_played to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10007 to 10008 ok in 0.000562 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10008 to 10009 ok in 0.000166 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column message_summary_info to message succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10009 to 10010 ok in 0.000592 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column attribution_info to attachment succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10010 to 10011 ok in 0.000388 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Adding column hide_attachment to attachment succeeded: YES
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10011 to 10012 ok in 0.000386 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Dropped table (if needed) ok: sqlite_stat1
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Migrated from 10012 to 10013 ok in 0.000231 seconds
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created table (if needed) ok: deleted_messages
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created table (if needed) ok: chat_handle_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created table (if needed) ok: chat_message_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created table (if needed) ok: message_attachment_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created table (if needed) ok: handle
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_handle_join_idx_handle_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_is_read
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_message_join_idx_chat_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_idx_is_archived
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_idx_chat_room_name_service_name
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_handle_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_message_join_idx_message_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_idx_chat_identifier
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_message_join_idx_message_id_only
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_failed
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_associated_message
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_handle
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_attachment_join_idx_attachment_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_date
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_expire_state
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: chat_idx_chat_identifier_service_name
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_other_handle
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_attachment_join_idx_message_id
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created index ok: message_idx_was_downgraded
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_insert_on_message_attachment_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_chat_message_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_attachment
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_message_attachment_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: add_to_deleted_messages
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_chat
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: before_delete_on_attachment
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_chat_handle_join
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: delete_associated_messages_after_delete_on_message
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_delete_on_message
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Created trigger ok: after_insert_on_chat_message_join 
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Integrity checked success
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Message database migration passed post migrate integrity check
2017-08-14 15:42:17 -0700 IMDPersistenceAgent[323]: Message's DB migration took 0.018302 seconds.
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: The current SMS database is v10013.  The current schema version is v11018. Can be migrated: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Beginning migration.  The SMS db is currently at v10013, upgrading to v11018.
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Integrity checked success
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Initial Integrity checked success
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_insert_on_message_attachment_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_chat_message_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_attachment
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_message_attachment_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: add_to_deleted_messages
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_chat
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: before_delete_on_attachment
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_chat_handle_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: delete_associated_messages_after_delete_on_message
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_delete_on_message
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped trigger: after_insert_on_chat_message_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped unknown index: chat_message_join_idx_message_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column engram_id to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 10013 to 11000 ok in 0.002566 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column server_change_token to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_sync_state to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11000 to 11001 ok in 0.000839 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column last_read_message_timestamp to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11001 to 11002 ok in 0.000492 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_record_system_property_blob to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11002 to 11003 ok in 0.000486 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11003 to 11004 ok in 0.000187 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_sync_state to message succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_record_id to message succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_record_change_tag to message succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11004 to 11005 ok in 0.001574 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_sync_state to attachment succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_server_change_token_blob to attachment succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11005 to 11006 ok in 0.000735 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11006 to 11007 ok in 0.000212 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11007 to 11008 ok in 0.000223 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column original_group_id to chat succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11008 to 11009 ok in 0.000580 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column ck_record_id to attachment succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11009 to 11010 ok in 0.000478 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column message_date to chat_message_join succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11010 to 11011 ok in 0.000512 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column original_guid to attachment succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11011 to 11012 ok in 0.001968 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Adding column destination_caller_id to message succeeded: YES
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11012 to 11013 ok in 0.004460 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11013 to 11014 ok in 0.000447 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11014 to 11015 ok in 0.000321 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11015 to 11016 ok in 0.000632 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11016 to 11017 ok in 0.000213 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Dropped table (if needed) ok: sqlite_stat1
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Migrated from 11017 to 11018 ok in 0.000368 seconds
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: deleted_messages
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: chat_handle_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: sync_deleted_messages
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: message_processing_task
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: handle
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: sync_deleted_chats
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: message_attachment_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: sync_deleted_attachments
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: kvtable
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created table (if needed) ok: chat_message_join
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_handle_join_idx_handle_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_attachment_join_idx_attachment_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_date
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_handle
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_handle_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_message_join_idx_message_id_only
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_associated_message
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_idx_chat_identifier
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_processing_task_idx_guid_task_flags
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_message_join_idx_chat_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_idx_chat_room_name_service_name
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_other_handle
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_message_join_idx_message_id_date_chat_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_was_downgraded
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_idx_is_archived
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_expire_state
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: chat_idx_chat_identifier_service_name
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_is_read
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_idx_failed
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Created index ok: message_attachment_join_idx_message_id
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: 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
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Integrity checked success
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Message database migration passed post migrate integrity check
2017-09-29 15:43:25 -0700 IMDPersistenceAgent[599]: Message's DB migration took 0.042011 seconds.
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: The current SMS database is v11018.  The current schema version is v11026. Can be migrated: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Beginning migration.  The SMS db is currently at v11018, upgrading to v11026.
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Integrity checked success
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Initial Integrity checked success
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_chat_message_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_attachment
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_insert_on_message_attachment_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: update_message_date_after_update_on_message
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_chat_handle_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_message
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_insert_on_chat_message_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_chat
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: delete_associated_messages_after_delete_on_message
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: before_delete_on_attachment
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: add_to_deleted_messages
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped trigger: after_delete_on_message_attachment_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11018 to 11019 ok in 0.001999 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_server_change_token to chat succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_sync_state to chat succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11019 to 11020 ok in 0.000869 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_sync_state to message succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_record_id to message succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_record_change_tag to message succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11020 to 11021 ok in 0.001500 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_record_id to attachment succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_sync_state to attachment succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_ck_server_change_token_blob to attachment succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11021 to 11022 ok in 0.001926 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11022 to 11023 ok in 0.000248 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column cloudkit_record_id to chat succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Adding column sr_cloudkit_record_id to chat succeeded: YES
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11023 to 11024 ok in 0.000971 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11024 to 11025 ok in 0.000194 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Dropped table (if needed) ok: sqlite_stat1
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Migrated from 11025 to 11026 ok in 0.000177 seconds
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: deleted_messages
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: chat_handle_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: sync_deleted_messages
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: message_processing_task
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: handle
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: sync_deleted_chats
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: message_attachment_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: sync_deleted_attachments
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: kvtable
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created table (if needed) ok: chat_message_join
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_attachment_join_idx_message_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_handle_join_idx_handle_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_attachment_join_idx_attachment_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_date
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_handle
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_handle_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_message_join_idx_message_id_only
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_associated_message
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_idx_chat_identifier
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_processing_task_idx_guid_task_flags
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_message_join_idx_chat_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_idx_chat_room_name_service_name
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_other_handle
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_message_join_idx_message_id_date_chat_id
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_was_downgraded
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_idx_is_archived
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: chat_idx_chat_identifier_service_name
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_expire_state
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_is_read
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_failed
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Created index ok: message_idx_isRead_isFromMe_itemType
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: 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
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Integrity checked success
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Message database migration passed post migrate integrity check
2018-04-07 16:21:38 -0700 IMDPersistenceAgent[490]: Message's DB migration took 0.023835 seconds.