Guest User

Untitled

a guest
Nov 14th, 2011
610
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ?QLite format 3@ ?<?-??"??#
  2. k
  3.  
  4. ?
  5. ? `^;?F???*+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_flags INTEGER, madrid_attachmentInfo BLOB, madrid_url TEXT, madrid_error INTEGER, is_madrid INTEGER, madrid_date_read INTEGER, madrid_date_delivered INTEGER)?!
  6. triggerdelete_piecesmessageCREATE TRIGGER delete_pieces AFTER DELETE ON message BEGIN DELETE from msg_pieces where old.ROWID == msg_pieces.message_id; ENDf5!?indexpieces_message_indexmsg_pieces
  7. CREATE INDEX pieces_message_index ON msg_pieces(message_id)?
  8. Mtriggerdelete_newest_messagemessageCREATE TRIGGER delete_newest_message AFTER DELETE ON message WHEN old.ROWID = (SELECT newest_message FROM msg_group WHERE ROWID = old.group_id) BEGIN UPDATE msg_group SET newest_message = (SELECT ROWID FROM message WHERE group_id = old.group_id AND ROWID = (SELECT max(ROWID) FROM message WHERE group_id = old.group_id)) WHERE ROWID = old.group_id; END?ytriggerinsert_newest_messagemessageCREATE TRIGGER insert_newest_message AFTER INSERT Etriggerdelete_messagemessageCREATE TRIGGER delete_message AFTER DELETE ON message WHEN NOT read(old.flags) BEGIN UPDATE msg_group SET unread_count = (SELECT unread_count FROM msg_group WHERE ROWID = old.group_id) - 1 WHERE ROWID = old.group_id; END?
  9. striggermark_message_readmessageCREATE TRIGGER mark_message_read AFTER UPDATE ON message WHEN NOT read(old.flags) AND read(new.flags) BEGIN UPDATE msg_group SET unread_count = (SELECT unread_count FROM msg_group WHERE ROWID = new.group_id) - 1 WHERE ROWID = new.group_id; END?
  10. wtriggermark_message_unreadmessageCREATE TRIGGER mark_message_unread AFTER UPDATE ON message WHEN read(old.flags) AND NOT read(new.flags) BEGIN UPDATE msg_group SET unread_count = (SELECT unread_count FROM msg_group WHERE ROWID = new.group_id) + 1 WHERE ROWID = new.group_id; END?
  11. Striggerinsert_unread_messagemessageCREATE TRIGGER insert_unread_message AFTER INSERT ON message WHEN NOT read(new.flags) BEGIN UPDATE msg_group SET unread_count = (SELECT unread_count FROM msg_group WHERE ROWID = new.group_id) + 1 WHERE ROWID = new.group_id; ENDX 3indexmessage_flags_indexmessage
  12. CREATE INDEX message_flags_index ON message(flags)3indexmessage_group_indexmessage
  13. CREATE INDEX message_group_index ON message(group_id, ROWID)?!!?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)?%%?otablegroup_membergroup_membeCREATE 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)Qe?indexsqlite_autoindex__SqliteDatabaseProperties_1_SqliteDatabaseProperties? ???!table_SqliteDatabaseProperties_SqliteDatabasePropertiesCREATE TABLE _SqliteDatabaseProperties (key TEXT, value TEXT, UNIQUE(!
  14. ?????
  15.  
  16.  
RAW Paste Data