Created
April 8, 2011 04:45
-
-
Save knowtheory/909306 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| require 'dm-core' | |
| require 'dm-sqlite-adapter' | |
| db_path = 'sqlite:///Users/knowtheory/data/chat/skype_main.db' | |
| DataMapper.setup(:default, db_path) | |
| # CREATE TABLE Accounts (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # status, Integer | |
| # pwdchangestatus, Integer | |
| # logoutreason, Integer | |
| # commitstatus, Integer | |
| # suggested_skypename, Text | |
| # skypeout_balance_currency, Text | |
| # skypeout_balance, Integer | |
| # skypeout_precision, Integer | |
| # skypein_numbers, Text | |
| # subscriptions, Text | |
| # cblsyncstatus, Integer | |
| # offline_callforward, Text | |
| # chat_policy, Integer | |
| # skype_call_policy, Integer | |
| # pstn_call_policy, Integer | |
| # avatar_policy, Integer | |
| # buddycount_policy, Integer | |
| # timezone_policy, Integer | |
| # webpresence_policy, Integer | |
| # phonenumbers_policy, Integer | |
| # voicemail_policy, Integer | |
| # authrequest_policy, Integer | |
| # ad_policy, Integer | |
| # partner_optedout, Text | |
| # service_provider_info, Text | |
| # registration_timestamp, Integer | |
| # nr_of_other_instances, Integer | |
| # owner_under_legal_age, Integer | |
| # type, Integer | |
| # skypename, Text | |
| # pstnnumber, Text | |
| # fullname, Text | |
| # birthday, Integer | |
| # gender, Integer | |
| # languages, Text | |
| # country, Text | |
| # province, Text | |
| # city, Text | |
| # phone_home, Text | |
| # phone_office, Text | |
| # phone_mobile, Text | |
| # emails, Text | |
| # homepage, Text | |
| # about, Text | |
| # profile_timestamp, Integer | |
| # received_authrequest, Text | |
| # displayname, Text | |
| # refreshing, Integer | |
| # given_authlevel, Integer | |
| # aliases, Text | |
| # authreq_timestamp, Integer | |
| # mood_text, Text | |
| # timezone, Integer | |
| # nrof_authed_buddies, Integer | |
| # ipcountry, Text | |
| # given_displayname, Text | |
| # availability, Integer | |
| # lastonline_timestamp, Integer | |
| # capabilities BLOB, | |
| # avatar_image BLOB, | |
| # assigned_speeddial, Text | |
| # lastused_timestamp, Integer | |
| # authrequest_count, Integer | |
| # assigned_comment, Text | |
| # alertstring, Text | |
| # avatar_timestamp, Integer | |
| # mood_timestamp, Integer | |
| # rich_mood_text, Text | |
| # synced_email BLOB, | |
| # set_availability, Integer | |
| # options_change_future BLOB, | |
| # authorized_time, Integer | |
| # sent_authrequest, Text | |
| # sent_authrequest_time, Integer | |
| # sent_authrequest_serial, Integer | |
| # buddyblob BLOB, | |
| # cbl_future BLOB, | |
| # node_capabilities, Integer | |
| # node_capabilities_and, Integer | |
| # revoked_auth, Integer | |
| # added_in_shared_group, Integer | |
| # in_shared_group, Integer | |
| # authreq_history BLOB, | |
| # profile_attachments BLOB, | |
| # stack_version, Integer | |
| # offline_authreq_id, Integer | |
| # verified_email BLOB, | |
| # verified_company BLOB, | |
| # cbl_profile_blob BLOB); | |
| # CREATE TABLE Alerts (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # timestamp, Integer | |
| # partner_name, Text | |
| # is_unseen, Integer | |
| # partner_id, Integer | |
| # partner_event, Text | |
| # partner_history, Text | |
| # partner_header, Text | |
| # partner_logo, Text | |
| # meta_expiry, Integer | |
| # message_header_caption, Text | |
| # message_header_title, Text | |
| # message_header_subject, Text | |
| # message_header_cancel, Text | |
| # message_header_later, Text | |
| # message_content, Text | |
| # message_footer, Text | |
| # message_button_caption, Text | |
| # message_button_uri, Text | |
| # message_type, Integer | |
| # window_size, Integer | |
| # chatmsg_guid BLOB, | |
| # notification_id, Integer | |
| # event_flags INTEGER); | |
| # CREATE TABLE CallMembers (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # identity, Text | |
| # dispname, Text | |
| # languages, Text | |
| # call_duration, Integer | |
| # price_per_minute, Integer | |
| # price_precision, Integer | |
| # price_currency, Text | |
| # payment_category, Text | |
| # type, Integer | |
| # status, Integer | |
| # failurereason, Integer | |
| # sounderror_code, Integer | |
| # soundlevel, Integer | |
| # pstn_statustext, Text | |
| # pstn_feedback, Text | |
| # forward_targets, Text | |
| # forwarded_by, Text | |
| # debuginfo, Text | |
| # videostatus, Integer | |
| # target_identity, Text | |
| # mike_status, Integer | |
| # is_read_only, Integer | |
| # quality_status, Integer | |
| # call_name, Text | |
| # transfer_status, Integer | |
| # transfer_active, Integer | |
| # transferred_by, Text | |
| # transferred_to, Text | |
| # guid, Text | |
| # next_redial_time, Integer | |
| # nrof_redials_done, Integer | |
| # nrof_redials_left, Integer | |
| # transfer_topic, Text | |
| # real_identity, Text | |
| # start_timestamp, Integer | |
| # is_conference, Integer | |
| # quality_problems, Text | |
| # identity_type, Integer | |
| # country, Text | |
| # creation_timestamp, Integer | |
| # stats_xml, Text | |
| # is_premium_video_sponsor, Integer | |
| # is_multiparty_video_capable, Integer | |
| # recovery_in_progress, Integer | |
| # pk_status, Integer | |
| # call_db_id, Integer | |
| # prime_status, Integer | |
| # nonse_word TEXT); | |
| # CREATE TABLE Calls (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # begin_timestamp, Integer | |
| # topic, Text | |
| # is_muted, Integer | |
| # is_unseen_missed, Integer | |
| # host_identity, Text | |
| # mike_status, Integer | |
| # duration, Integer | |
| # soundlevel, Integer | |
| # access_token, Text | |
| # active_members, Integer | |
| # is_active, Integer | |
| # name, Text | |
| # video_disabled, Integer | |
| # joined_existing, Integer | |
| # server_identity, Text | |
| # vaa_input_status, Integer | |
| # is_incoming, Integer | |
| # is_conference, Integer | |
| # is_on_hold, Integer | |
| # start_timestamp, Integer | |
| # quality_problems, Text | |
| # current_video_audience, Text | |
| # premium_video_status, Integer | |
| # premium_video_is_grace_period, Integer | |
| # is_premium_video_sponsor, Integer | |
| # premium_video_sponsor_list, Text | |
| # old_members BLOB, | |
| # partner_handle, Text | |
| # partner_dispname, Text | |
| # type, Integer | |
| # status, Integer | |
| # failurereason, Integer | |
| # failurecode, Integer | |
| # pstn_number, Text | |
| # old_duration, Integer | |
| # conf_participants BLOB, | |
| # pstn_status, Text | |
| # members BLOB, | |
| # conv_dbid INTEGER); | |
| # CREATE TABLE ChatMembers (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # chatname, Text | |
| # identity, Text | |
| # role, Integer | |
| # is_active, Integer | |
| # cur_activities, Integer | |
| # adder TEXT); | |
| class Chat | |
| include DataMapper::Resource | |
| # CREATE TABLE Chats ( | |
| property :id, Serial # id INTEGER NOT NULL PRIMARY KEY, | |
| property :is_permanent, Integer # is_permanent, Integer | |
| property :name, Text # name, Text | |
| property :options, Integer # options, Integer | |
| property :friendlyname, Text # friendlyname, Text | |
| property :description, Text # description, Text | |
| property :timestamp, Integer # timestamp, Integer | |
| property :activity_timestamp, Integer # activity_timestamp, Integer | |
| property :dialog_partner, Text # dialog_partner, Text | |
| property :adder, Text # adder, Text | |
| property :type, Integer # type, Integer | |
| property :mystatus, Integer # mystatus, Integer | |
| property :myrole, Integer # myrole, Integer | |
| property :posters, Text # posters, Text | |
| property :participants, Text # participants, Text | |
| property :applicants, Text # applicants, Text | |
| property :banned_users, Text # banned_users, Text | |
| property :name_text, Text # name_text, Text | |
| property :topic, Text # topic, Text | |
| property :topic_xml, Text # topic_xml, Text | |
| property :guidelines, Text # guidelines, Text | |
| # property :picture BLOB, # picture BLOB, | |
| property :alertstring, Text # alertstring, Text | |
| property :is_bookmarked, Integer # is_bookmarked, Integer | |
| property :passwordhint, Text # passwordhint, Text | |
| property :unconsumed_suppressed_msg, Integer # unconsumed_suppressed_msg, Integer | |
| property :unconsumed_normal_msg, Integer # unconsumed_normal_msg, Integer | |
| property :unconsumed_elevated_msg, Integer # unconsumed_elevated_msg, Integer | |
| property :unconsumed_msg_voice, Integer # unconsumed_msg_voice, Integer | |
| property :activemembers, Text # activemembers, Text | |
| # property :state_data BLOB, # state_data BLOB, | |
| property :lifesigns, Integer # lifesigns, Integer | |
| property :last_change, Integer # last_change, Integer | |
| property :first_unread_message, Integer # first_unread_message, Integer | |
| property :pk_type, Integer # pk_type, Integer | |
| property :dbpath, Text # dbpath, Text | |
| property :split_friendlyname, Text # split_friendlyname, Text | |
| property :conv_dbid, Integer # conv_dbid, Integer | |
| property :extprop_hide_from_history, Integer # extprop_hide_from_history, Integer | |
| property :extprop_chat_aux_type, Integer # extprop_chat_aux_type, Integer | |
| property :extprop_chat_sort_order, Integer # extprop_chat_sort_order, Integer | |
| property :extprop_mark_read_immediately, Integer # extprop_mark_read_immediately Integer); | |
| end | |
| # CREATE TABLE ContactGroups (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # type, Integer | |
| # custom_group_id, Integer | |
| # given_displayname, Text | |
| # nrofcontacts, Integer | |
| # nrofcontacts_online, Integer | |
| # type_old, Integer | |
| # proposer, Text | |
| # description, Text | |
| # associated_chat, Text | |
| # members, Text | |
| # cbl_id, Integer | |
| # cbl_blob BLOB, | |
| # fixed, Integer | |
| # keep_sharedgroup_contacts, Integer | |
| # chats, Text | |
| # extprop_cgroup_is_hidden, Integer | |
| # extprop_cgroup_sortorder_value, Integer | |
| # extprop_cgroup_is_expanded, Integer); | |
| class Contact # CREATE TABLE Contacts ( | |
| include DataMapper::Resource | |
| property :id, Serial # id INTEGER NOT NULL PRIMARY KEY, | |
| property :is_permanent, Integer # is_permanent, Integer | |
| property :type, Integer # type, Integer | |
| property :skypename, Text # skypename, Text | |
| property :pstnnumber, Text # pstnnumber, Text | |
| property :aliases, Text # aliases, Text | |
| property :fullname, Text # fullname, Text | |
| property :birthday, Integer # birthday, Integer | |
| property :gender, Integer # gender, Integer | |
| property :languages, Text # languages, Text | |
| property :country, Text # country, Text | |
| property :province, Text # province, Text | |
| property :city, Text # city, Text | |
| property :phone_home, Text # phone_home, Text | |
| property :phone_office, Text # phone_office, Text | |
| property :phone_mobile, Text # phone_mobile, Text | |
| property :emails, Text # emails, Text | |
| property :homepage, Text # homepage, Text | |
| property :about, Text # about, Text | |
| #property :avatar_image BLOB, # avatar_image BLOB, | |
| property :mood_text, Text # mood_text, Text | |
| property :rich_mood_text, Text # rich_mood_text, Text | |
| property :timezone, Integer # timezone, Integer | |
| #property :capabilities BLOB, # capabilities BLOB, | |
| property :profile_timestamp, Integer # profile_timestamp, Integer | |
| property :nrof_authed_buddies, Integer # nrof_authed_buddies, Integer | |
| property :ipcountry, Text # ipcountry, Text | |
| property :avatar_timestamp, Integer # avatar_timestamp, Integer | |
| property :mood_timestamp, Integer # mood_timestamp, Integer | |
| property :received_authrequest, Text # received_authrequest, Text | |
| property :authreq_timestamp, Integer # authreq_timestamp, Integer | |
| property :lastonline_timestamp, Integer # lastonline_timestamp, Integer | |
| property :availability, Integer # availability, Integer | |
| property :displayname, Text # displayname, Text | |
| property :refreshing, Integer # refreshing, Integer | |
| property :given_authlevel, Integer # given_authlevel, Integer | |
| property :given_displayname, Text # given_displayname, Text | |
| property :assigned_speeddial, Text # assigned_speeddial, Text | |
| property :assigned_comment, Text # assigned_comment, Text | |
| property :alertstring, Text # alertstring, Text | |
| property :lastused_timestamp, Integer # lastused_timestamp, Integer | |
| property :authrequest_count, Integer # authrequest_count, Integer | |
| property :assigned_phone1, Text # assigned_phone1, Text | |
| property :assigned_phone1_label, Text # assigned_phone1_label, Text | |
| property :assigned_phone2, Text # assigned_phone2, Text | |
| property :assigned_phone2_label, Text # assigned_phone2_label, Text | |
| property :assigned_phone3, Text # assigned_phone3, Text | |
| property :assigned_phone3_label, Text # assigned_phone3_label, Text | |
| property :buddystatus, Integer # buddystatus, Integer | |
| property :isauthorized, Integer # isauthorized, Integer | |
| property :popularity_ord, Integer # popularity_ord, Integer | |
| property :isblocked, Integer # isblocked, Integer | |
| #property :authorization_certificate BLOB, # authorization_certificate BLOB, | |
| property :certificate_send_count, Integer # certificate_send_count, Integer | |
| property :account_modification_serial_nr, Integer # account_modification_serial_nr, Integer | |
| #property :saved_directory_blob BLOB, # saved_directory_blob BLOB, | |
| property :nr_of_buddies, Integer # nr_of_buddies, Integer | |
| property :server_synced, Integer # server_synced, Integer | |
| property :contactlist_track, Integer # contactlist_track, Integer | |
| property :last_used_networktime, Integer # last_used_networktime, Integer | |
| property :authorized_time, Integer # authorized_time, Integer | |
| property :sent_authrequest, Text # sent_authrequest, Text | |
| property :sent_authrequest_time, Integer # sent_authrequest_time, Integer | |
| property :sent_authrequest_serial, Integer # sent_authrequest_serial, Integer | |
| #property :buddyblob BLOB, # buddyblob BLOB, | |
| #property :cbl_future BLOB, # cbl_future BLOB, | |
| property :node_capabilities, Integer # node_capabilities, Integer | |
| property :revoked_auth, Integer # revoked_auth, Integer | |
| property :added_in_shared_group, Integer # added_in_shared_group, Integer | |
| property :in_shared_group, Integer # in_shared_group, Integer | |
| #property :authreq_history BLOB, # authreq_history BLOB, | |
| #property :profile_attachments BLOB, # profile_attachments BLOB, | |
| property :stack_version, Integer # stack_version, Integer | |
| property :offline_authreq_id, Integer # offline_authreq_id, Integer | |
| property :node_capabilities_and, Integer # node_capabilities_and, Integer | |
| property :authreq_crc, Integer # authreq_crc, Integer | |
| property :authreq_src, Integer # authreq_src, Integer | |
| property :pop_score, Integer # pop_score, Integer | |
| #property :authreq_nodeinfo BLOB, # authreq_nodeinfo BLOB, | |
| property :main_phone, Text # main_phone, Text | |
| property :unified_servants, Text # unified_servants, Text | |
| property :phone_home_normalized, Text # phone_home_normalized, Text | |
| property :phone_office_normalized, Text # phone_office_normalized, Text | |
| property :phone_mobile_normalized, Text # phone_mobile_normalized, Text | |
| property :sent_authrequest_initmethod, Integer # sent_authrequest_initmethod, Integer | |
| property :authreq_initmethod, Integer # authreq_initmethod, Integer | |
| #property :verified_email BLOB, # verified_email BLOB, | |
| #property :verified_company BLOB, # verified_company BLOB, | |
| property :sent_authrequest_extrasbitmask, Integer # sent_authrequest_extrasbitmask, Integer | |
| property :extprop_mark_read_immediately, Integer # extprop_mark_read_immediately, Integer | |
| property :extprop_contact_mood_status, Integer # extprop_contact_mood_status, Integer | |
| property :extprop_contact_ab_uuid, Text # extprop_contact_ab_uuid, Text | |
| property :extprop_contact_previous_mood_text, Text # extprop_contact_previous_mood_text, Text | |
| property :extprop_contact_latest_mood_msg_dbid, Text # extprop_contact_latest_mood_msg_dbid, Text | |
| property :extprop_contact_is_bookmarked, Integer # extprop_contact_is_bookmarked INTEGER); | |
| end | |
| class Conversation # CREATE TABLE "Conversations" ( | |
| include DataMapper::Resource | |
| property :id, Serial # id INTEGER NOT NULL PRIMARY KEY, | |
| property :is_permanent, Integer # is_permanent, Integer | |
| property :identity, Text # identity, Text | |
| property :type, Integer # type, Integer | |
| property :live_host, Text # live_host, Text | |
| property :live_start_timestamp, Integer # live_start_timestamp, Integer | |
| property :live_is_muted, Integer # live_is_muted, Integer | |
| property :alert_string, Text # alert_string, Text | |
| property :is_bookmarked, Integer # is_bookmarked, Integer | |
| property :given_displayname, Text # given_displayname, Text | |
| property :displayname, Text # displayname, Text | |
| property :local_livestatus, Integer # local_livestatus, Integer | |
| property :inbox_timestamp, Integer # inbox_timestamp, Integer | |
| property :inbox_message_id, Integer # inbox_message_id, Integer | |
| property :unconsumed_suppressed_messages, Integer # unconsumed_suppressed_messages, Integer | |
| property :unconsumed_normal_messages, Integer # unconsumed_normal_messages, Integer | |
| property :unconsumed_elevated_messages, Integer # unconsumed_elevated_messages, Integer | |
| property :unconsumed_messages_voice, Integer # unconsumed_messages_voice, Integer | |
| property :active_vm_id, Integer # active_vm_id, Integer | |
| property :context_horizon, Integer # context_horizon, Integer | |
| property :consumption_horizon, Integer # consumption_horizon, Integer | |
| property :last_activity_timestamp, Integer # last_activity_timestamp, Integer | |
| property :active_invoice_message, Integer # active_invoice_message, Integer | |
| property :spawned_from_convo_id, Integer # spawned_from_convo_id, Integer | |
| property :pinned_order, Integer # pinned_order, Integer | |
| property :creator, Text # creator, Text | |
| property :creation_timestamp, Integer # creation_timestamp, Integer | |
| property :my_status, Integer # my_status, Integer | |
| property :opt_joining_enabled, Integer # opt_joining_enabled, Integer | |
| property :opt_access_token, Text # opt_access_token, Text | |
| property :opt_entry_level_rank, Integer # opt_entry_level_rank, Integer | |
| property :opt_disclose_history, Integer # opt_disclose_history, Integer | |
| property :opt_history_limit_in_days, Integer # opt_history_limit_in_days, Integer | |
| property :opt_admin_only_activities, Integer # opt_admin_only_activities, Integer | |
| property :passwordhint, Text # passwordhint, Text | |
| property :meta_name, Text # meta_name, Text | |
| property :meta_topic, Text # meta_topic, Text | |
| property :meta_guidelines, Text # meta_guidelines, Text | |
| #property :meta_picture BLOB, # meta_picture BLOB, | |
| property :premium_video_status, Integer # premium_video_status, Integer | |
| property :premium_video_is_grace_period, Integer # premium_video_is_grace_period, Integer | |
| property :guid, Text # guid, Text | |
| property :dialog_partner, Text # dialog_partner, Text | |
| property :meta_description, Text # meta_description, Text | |
| property :premium_video_sponsor_list, Text # premium_video_sponsor_list, Text | |
| property :chat_dbid, Integer # chat_dbid, Integer | |
| property :history_horizon, Integer # history_horizon, Integer | |
| property :extprop_hide_from_history, Integer # extprop_hide_from_history, Integer | |
| property :extprop_aux_type, Integer # extprop_aux_type, Integer | |
| property :extprop_sort_other, Integer # extprop_sort_other, Integer | |
| property :extprop_dialog_contact_is_bookmarked, Integer # extprop_dialog_contact_is_bookmarked, Integer | |
| property :extprop_current_sms_dbid, Integer # extprop_current_sms_dbid, Integer | |
| property :extprop_mark_read_immediately, Integer # extprop_mark_read_immediately, Integer | |
| property :extprop_chat_mode, Integer # extprop_chat_mode Integer); | |
| end | |
| =begin | |
| {:id=>285381, | |
| :is_permanent=>1, | |
| :identity=>"#poplifegirl/$cb06cb9b63af13d2", | |
| :type=>2, | |
| :displayname=> | |
| "Japan Quake Crisis Commons Chat - This chat is CLOSED. We are currently working on an after action review of events. If you wish to volunteer email heather@crisiscommons.org ", | |
| :inbox_timestamp=>1302193502, | |
| :inbox_message_id=>326380, | |
| :unconsumed_suppressed_messages=>0, | |
| :unconsumed_normal_messages=>0, | |
| :unconsumed_elevated_messages=>0, | |
| :consumption_horizon=>1302228796, | |
| :last_activity_timestamp=>1302196115, | |
| :spawned_from_convo_id=>0, | |
| :creator=>"poplifegirl", | |
| :creation_timestamp=>1299852090, | |
| :my_status=>8, | |
| :opt_joining_enabled=>1, | |
| :opt_entry_level_rank=>3, | |
| :opt_admin_only_activities=>1, | |
| :passwordhint=>"", | |
| :meta_topic=> | |
| "Japan Quake Crisis Commons Chat - This chat is CLOSED. We are currently working on an after action review of events. If you wish to volunteer email <a href=\"mailto:heather@crisiscommons.org\">heather@crisiscommons.org</a> ", | |
| :meta_guidelines=> | |
| "Posted when new people join. Access again with /get guidelines \r\nand remember only you can see.\r\n\r\n~~~ Welcome to the Japan Quake Crisis Commons Skype Chat! ~~~\r\n\r\nHere is the wiki for your review:\r\nhttp://wiki.crisiscommons.org/wiki/Honshu_Quake\r\nHere are the Guidelines for this Skype chat and How to Help :\r\nhttp://wiki.crisiscommons.org/wiki/Skype_Guidelines#", | |
| :chat_dbid=>285335, | |
| :history_horizon=>1302228796, | |
| :extprop_mark_read_immediately=>0} | |
| =end | |
| # CREATE TABLE DbMeta (key TEXT NOT NULL PRIMARY KEY, | |
| # value TEXT); | |
| # CREATE TABLE LegacyMessages (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent INTEGER); | |
| class Message # CREATE TABLE Messages ( | |
| include DataMapper::Resource | |
| property :id, Serial # id INTEGER NOT NULL PRIMARY KEY, | |
| property :is_permanent, Integer # is_permanent, Integer | |
| property :convo_id, Integer # convo_id, Integer | |
| property :chatname, Text # chatname, Text | |
| property :author, Text # author, Text | |
| property :from_dispname, Text # from_dispname, Text | |
| property :author_was_live, Integer # author_was_live, Integer | |
| #property :guid BLOB, # guid BLOB, | |
| property :dialog_partner, Text # dialog_partner, Text | |
| property :timestamp, Integer # timestamp, Integer | |
| property :type, Integer # type, Integer | |
| property :sending_status, Integer # sending_status, Integer | |
| property :consumption_status, Integer # consumption_status, Integer | |
| property :edited_by, Text # edited_by, Text | |
| property :edited_timestamp, Integer # edited_timestamp, Integer | |
| property :param_key, Integer # param_key, Integer | |
| property :param_value, Integer # param_value, Integer | |
| property :body_xml, Text # body_xml, Text | |
| property :identities, Text # identities, Text | |
| property :reason, Text # reason, Text | |
| property :leavereason, Integer # leavereason, Integer | |
| property :participant_count, Integer # participant_count, Integer | |
| property :error_code, Integer # error_code, Integer | |
| property :chatmsg_type, Integer # chatmsg_type, Integer | |
| property :chatmsg_status, Integer # chatmsg_status, Integer | |
| property :body_is_rawxml, Integer # body_is_rawxml, Integer | |
| property :oldoptions, Integer # oldoptions, Integer | |
| property :newoptions, Integer # newoptions, Integer | |
| property :newrole, Integer # newrole, Integer | |
| property :pk_id, Integer # pk_id, Integer | |
| property :crc, Integer # crc, Integer | |
| property :remote_id, Integer # remote_id, Integer | |
| property :call_guid, Text # call_guid, Text | |
| property :extprop_chatmsg_ft_index_timestamp, Integer# extprop_chatmsg_ft_index_timestamp, Integer | |
| property :extprop_chatmsg_is_pending, Integer # extprop_chatmsg_is_pending, Integer | |
| property :extprop_chatmsg_rendered_body, Text # extprop_chatmsg_rendered_body, Text | |
| property :extprop_chatmsg_render_version, Integer # extprop_chatmsg_render_version, Integer | |
| property :extprop_chatmsg_aux_type, Integer # extprop_chatmsg_aux_type, Integer | |
| property :extprop_chatmsg_aux_from_handle, Text # extprop_chatmsg_aux_from_handle TEXT); | |
| end | |
| # CREATE TABLE "Participants" (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # convo_id, Integer | |
| # identity, Text | |
| # rank, Integer | |
| # requested_rank, Integer | |
| # text_status, Integer | |
| # voice_status, Integer | |
| # video_status, Integer | |
| # live_identity, Text | |
| # live_price_for_me, Text | |
| # live_fwd_identities, Text | |
| # live_start_timestamp, Integer | |
| # sound_level, Integer | |
| # debuginfo, Text | |
| # next_redial_time, Integer | |
| # nrof_redials_left, Integer | |
| # last_voice_error, Text | |
| # quality_problems, Text | |
| # live_type, Integer | |
| # live_country, Text | |
| # transferred_by, Text | |
| # transferred_to, Text | |
| # adder, Text | |
| # is_premium_video_sponsor, Integer | |
| # is_multiparty_video_capable, Integer | |
| # live_identity_to_use, Text | |
| # livesession_recovery_in_progress INTEGER); | |
| # CREATE TABLE SMSes (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # type, Integer | |
| # status, Integer | |
| # failurereason, Integer | |
| # is_failed_unseen, Integer | |
| # timestamp, Integer | |
| # price, Integer | |
| # price_precision, Integer | |
| # price_currency, Text | |
| # reply_to_number, Text | |
| # target_numbers, Text | |
| # target_statuses BLOB, | |
| # body, Text | |
| # chatmsg_id, Integer | |
| # extprop_sms_guid BLOB, | |
| # extprop_sms_rendered_body, Text | |
| # extprop_sms_render_version, Integer | |
| # extprop_sms_aux_type, Integer | |
| # extprop_sms_aux_timestamp, Integer | |
| # extprop_sms_aux_status INTEGER); | |
| # CREATE TABLE Transfers (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # type, Integer | |
| # partner_handle, Text | |
| # partner_dispname, Text | |
| # status, Integer | |
| # failurereason, Integer | |
| # starttime, Integer | |
| # finishtime, Integer | |
| # filepath, Text | |
| # filename, Text | |
| # filesize, Text | |
| # bytestransferred, Text | |
| # bytespersecond, Integer | |
| # chatmsg_guid BLOB, | |
| # chatmsg_index, Integer | |
| # convo_id, Integer | |
| # pk_id, Integer | |
| # nodeid BLOB, | |
| # last_activity, Integer | |
| # flags, Integer | |
| # old_status, Integer | |
| # old_filepath, Integer | |
| # accepttime, Integer | |
| # extprop_transfer_alias BLOB); | |
| # CREATE TABLE Videos (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # status, Integer | |
| # error, Text | |
| # debuginfo, Text | |
| # dimensions, Text | |
| # media_type, Integer | |
| # duration_1080, Integer | |
| # duration_720, Integer | |
| # duration_hqv, Integer | |
| # duration_vgad2, Integer | |
| # duration_ltvgad2, Integer | |
| # timestamp, Integer | |
| # hq_present, Integer | |
| # duration_ss, Integer | |
| # ss_timestamp, Integer | |
| # convo_id, Integer | |
| # device_path TEXT); | |
| # CREATE TABLE Voicemails (id INTEGER NOT NULL PRIMARY KEY, | |
| # is_permanent, Integer | |
| # type, Integer | |
| # partner_handle, Text | |
| # partner_dispname, Text | |
| # status, Integer | |
| # failurereason, Integer | |
| # subject, Text | |
| # timestamp, Integer | |
| # duration, Integer | |
| # allowed_duration, Integer | |
| # playback_progress, Integer | |
| # convo_id, Integer | |
| # chatmsg_guid BLOB, | |
| # notification_id, Integer | |
| # flags, Integer | |
| # size, Integer | |
| # path, Text | |
| # failures, Integer | |
| # vflags, Integer | |
| # xmsg TEXT); | |
| # CREATE INDEX IX_Accounts_skypename ON Accounts (skypename); | |
| # CREATE INDEX IX_Alerts_chatmsg_guid ON Alerts (chatmsg_guid); | |
| # CREATE INDEX IX_Alerts_notification_id ON Alerts (notification_id); | |
| # CREATE INDEX IX_Alerts_timestamp ON Alerts (timestamp); | |
| # CREATE INDEX IX_CallMembers_call_name ON CallMembers (call_name); | |
| # CREATE INDEX IX_CallMembers_identity ON CallMembers (identity); | |
| # CREATE INDEX IX_Calls_begin_timestamp ON Calls (begin_timestamp); | |
| # CREATE INDEX IX_Calls_is_unseen_missed ON Calls (is_unseen_missed); | |
| # CREATE INDEX IX_Calls_name ON Calls (name); | |
| # CREATE INDEX IX_ChatMembers_chatname ON ChatMembers (chatname); | |
| # CREATE INDEX IX_ChatMembers_identity ON ChatMembers (identity); | |
| # CREATE INDEX IX_Chats_activity_timestamp ON Chats (activity_timestamp); | |
| # CREATE INDEX IX_Chats_first_unread_message ON Chats (first_unread_message); | |
| # CREATE INDEX IX_Chats_is_bookmarked ON Chats (is_bookmarked); | |
| # CREATE INDEX IX_Chats_lifesigns ON Chats (lifesigns); | |
| # CREATE INDEX IX_Chats_mystatus ON Chats (mystatus); | |
| # CREATE INDEX IX_Chats_name ON Chats (name); | |
| # CREATE INDEX IX_Chats_participants ON Chats (participants); | |
| # CREATE INDEX IX_Chats_type ON Chats (type); | |
| # CREATE INDEX IX_ContactGroups_given_displayname ON ContactGroups (given_displayname); | |
| # CREATE INDEX IX_Contacts_buddystatus ON Contacts (buddystatus); | |
| # CREATE INDEX IX_Contacts_skypename ON Contacts (skypename); | |
| # CREATE INDEX IX_Conversations_identity ON Conversations (identity); | |
| # CREATE INDEX IX_Conversations_type ON Conversations (type); | |
| # CREATE INDEX IX_Messages_call_guid ON Messages (call_guid); | |
| # CREATE INDEX IX_Messages_chatname_timestamp_consumption_status_sending_status ON Messages (chatname, | |
| # timestamp, | |
| # consumption_status, | |
| # sending_status); | |
| # CREATE INDEX IX_Messages_convo_id_timestamp_consumption_status_sending_status ON Messages (convo_id, | |
| # timestamp, | |
| # consumption_status, | |
| # sending_status); | |
| # CREATE INDEX IX_Messages_remote_id ON Messages (remote_id); | |
| # CREATE INDEX IX_Messages_timestamp_chatname ON Messages (timestamp, | |
| # chatname); | |
| # CREATE INDEX IX_Messages_timestamp_convo_id_type ON Messages (timestamp, | |
| # convo_id, | |
| # type); | |
| # CREATE INDEX IX_Participants_convo_id ON Participants (convo_id); | |
| # CREATE INDEX IX_Participants_identity ON Participants (identity); | |
| # CREATE INDEX IX_SMSes_status ON SMSes (status); | |
| # CREATE INDEX IX_SMSes_target_numbers ON SMSes (target_numbers); | |
| # CREATE INDEX IX_SMSes_type ON SMSes (type); | |
| # CREATE INDEX IX_Transfers_chatmsg_guid ON Transfers (chatmsg_guid); | |
| # CREATE INDEX IX_Transfers_partner_handle ON Transfers (partner_handle); | |
| # CREATE INDEX IX_Transfers_status ON Transfers (status); | |
| # CREATE INDEX IX_Transfers_type ON Transfers (type); | |
| # CREATE INDEX IX_Voicemails_chatmsg_guid ON Voicemails (chatmsg_guid); | |
| # CREATE INDEX IX_Voicemails_flags ON Voicemails (flags); | |
| # CREATE INDEX IX_Voicemails_notification_id ON Voicemails (notification_id); | |
| # CREATE INDEX IX_Voicemails_partner_handle ON Voicemails (partner_handle); | |
| # CREATE INDEX IX_Voicemails_status ON Voicemails (status); | |
| # CREATE INDEX IX_Voicemails_type ON Voicemails (type); | |
| # | |
| DataMapper.finalize |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment