SQLite format 3 @ + -? ?X
??w?^??S?n?d???C X3qindexmessage_flags_indexmessageCREATE INDEX message_flags_index ON message(flags)c3?indexmessage_group_indexmessageCREATE INDEX message_group_index ON message(group_id, ROWID)?K#?indexmadrid_chat_account_login_indexmadrid_chatCREATE INDEX madrid_chat_account_login_index ON madrid_chat(account_login)uC#?indexmadrid_chat_room_name_indexmadrid_chatCREATE INDEX madrid_chat_room_name_index ON madrid_chat(room_name)e9#}indexmadrid_chat_guid_indexmadrid_chatCREATE INDEX madrid_chat_guid_index ON madrid_chat(guid)~I#?indexmadrid_chat_service_name_indexmadrid_chatCREATE INDEX madrid_chat_service_name_index ON madrid_chat(service_name)?O#?indexmadrid_chat_chat_identifier_indexmadrid_chatCREATE INDEX madrid_chat_chat_identifier_index ON madrid_chat(chat_identifier)xE#?indexmadrid_chat_account_id_indexmadrid_chatCREATE INDEX madrid_chat_account_id_index ON madrid_chat(account_id)i;#?indexmadrid_chat_state_indexmadrid_chatCREATE INDEX madrid_chat_state_index ON madrid_chat(state)i
;#?indexmadrid_chat_style_indexmadrid_chatCREATE INDEX madrid_chat_style_index ON madrid_chat(style)?##僩tablemadrid_chatmadrid_chatCREATE TABLE madrid_chat (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, style INTEGER, state INTEGER, account_id TEXT, properties BLOB, chat_identifier TEXT, service_name TEXT, guid TEXT, room_name TEXT, account_login TEXT, participants BLOB)?M/?indexmadrid_attachment_filename_indexmadrid_attachment
CREATE INDEX madrid_attachment_filename_index ON madrid_attachment(filename)?
E/?indexmadrid_attachment_guid_indexmadrid_attachmentCREATE INDEX madrid_attachment_guid_index ON madrid_attachment(attachment_guid)? K/?indexmadrid_attachment_message_indexmadrid_attachmentCREATE INDEX madrid_attachment_message_index ON madrid_attachment(message_id)?//儃tablemadrid_attachmentmadrid_attachment
CREATE TABLE madrid_attachment (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, attachment_guid TEXT, created_date INTEGER, start_date INTEGER, filename TEXT, uti_type TEXT, mime_type TEXT, transfer_state INTEGER, is_incoming INTEGER, message_id INTEGER)?!!?tablemsg_piecesmsg_pieces CREATE TABLE msg_pieces (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, message_id INTEGER, data BLOB, part_id INTEGER, preview_part INTEGER, content_type TEXT, height INTEGER, version INTEGER, flags INTEGER, content_id TEXT, content_loc TEXT, headers BLOB)?%%乷tablegroup_membergroup_memberCREATE TABLE group_member (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER, address TEXT, country TEXT)??tablemsg_groupmsg_groupCREATE TABLE msg_group (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, type INTEGER, newest_message INTEGER, unread_count INTEGER, hash INTEGER)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)匘奯tablemessagemessageCREATE TABLE message (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, address TEXT, date INTEGER, text TEXT, flags INTEGER, replace INTEGER, svc_center TEXT, group_id INTEGER, association_id INTEGER, height INTEGER, UIFlags INTEGER, version INTEGER, subject TEXT, country TEXT, headers BLOB, recipients BLOB, read INTEGER, madrid_attributedBody BLOB, madrid_handle TEXT, madrid_version INTEGER, madrid_guid TEXT, madrid_type INTEGER, madrid_roomname TEXT, madrid_service TEXT, madrid_account TEXT, madrid_account_guid TEXT, madrid_flags INTEGER, madrid_attachmentInfo BLOB, madrid_url TEXT, madrid_error INTEGER, is_madrid INTEGER, madrid_date_read INTEGER, madrid_date_delivered INTEGER)????table_SqliteDatabaseProperties_SqliteDatabasePropertiesCREATE TABLE _SqliteDatabaseProperties (key TEXT, value TEXT, UNIQUE(key))Qe? indexsqlite_autoindex__SqliteDatabaseProperties_1_SqliteDatabaseProperties