· 4 years ago · Aug 22, 2021, 10:12 PM
100 IMDPersistenceAgent[1121]: Created table (if needed) ok: chat_handle_join
22021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: sync_deleted_messages
32021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: message_processing_task
42021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: handle
52021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: sync_deleted_chats
62021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: message_attachment_join
72021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: sync_deleted_attachments
82021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: kvtable
92021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created table (if needed) ok: chat_message_join
102021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_attachment_join_idx_message_id
112021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_idx_chat_identifier_service_name
122021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_handle_join_idx_handle_id
132021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_attachment_join_idx_attachment_id
142021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_date
152021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: attachment_idx_purged_attachments_v2
162021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_thread_originator_guid
172021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_handle
182021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_handle_id
192021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_is_sent_is_from_me_error
202021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_message_join_idx_message_id_only
212021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_associated_message
222021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_idx_chat_identifier
232021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_processing_task_idx_guid_task_flags
242021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_undelivered_one_to_one_imessage
252021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_message_join_idx_chat_id
262021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_cache_has_attachments
272021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_idx_chat_room_name_service_name
282021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_other_handle
292021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_was_downgraded
302021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_idx_is_archived
312021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_expire_state
322021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: chat_message_join_idx_message_date_id_chat_id
332021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_is_read
342021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_isRead_isFromMe_itemType
352021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: Created index ok: message_idx_failed
362021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
372021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
382021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
392021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
402021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
412021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
422021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
432021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
442021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
452021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
462021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
472021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
482021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
492021-08-16 06:14:58 -0500 IMDPersistenceAgent[1121]: 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
50