Hermes/schema.txt at main · Jckwind/Hermes · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
Schema for chat_message_join:
(0, 'chat_id', 'INTEGER', 0, None, 1)
(1, 'message_id', 'INTEGER', 0, None, 2)
(2, 'message_date', 'INTEGER', 0, '0', 0)
Schema for chat_handle_join:
(0, 'chat_id', 'INTEGER', 0, None, 0)
(1, 'handle_id', 'INTEGER', 0, None, 0)
Schema for message:
(0, 'ROWID', 'INTEGER', 0, None, 1)
(1, 'guid', 'TEXT', 1, None, 0)
(2, 'text', 'TEXT', 0, None, 0)
(3, 'replace', 'INTEGER', 0, '0', 0)
(4, 'service_center', 'TEXT', 0, None, 0)
(5, 'handle_id', 'INTEGER', 0, '0', 0)
(6, 'subject', 'TEXT', 0, None, 0)
(7, 'country', 'TEXT', 0, None, 0)
(8, 'attributedBody', 'BLOB', 0, None, 0)
(9, 'version', 'INTEGER', 0, '0', 0)
(10, 'type', 'INTEGER', 0, '0', 0)
(11, 'service', 'TEXT', 0, None, 0)
(12, 'account', 'TEXT', 0, None, 0)
(13, 'account_guid', 'TEXT', 0, None, 0)
(14, 'error', 'INTEGER', 0, '0', 0)
(15, 'date', 'INTEGER', 0, None, 0)
(16, 'date_read', 'INTEGER', 0, None, 0)
(17, 'date_delivered', 'INTEGER', 0, None, 0)
(18, 'is_delivered', 'INTEGER', 0, '0', 0)
(19, 'is_finished', 'INTEGER', 0, '0', 0)
(20, 'is_emote', 'INTEGER', 0, '0', 0)
(21, 'is_from_me', 'INTEGER', 0, '0', 0)
(22, 'is_empty', 'INTEGER', 0, '0', 0)
(23, 'is_delayed', 'INTEGER', 0, '0', 0)
(24, 'is_auto_reply', 'INTEGER', 0, '0', 0)
(25, 'is_prepared', 'INTEGER', 0, '0', 0)
(26, 'is_read', 'INTEGER', 0, '0', 0)
(27, 'is_system_message', 'INTEGER', 0, '0', 0)
(28, 'is_sent', 'INTEGER', 0, '0', 0)
(29, 'has_dd_results', 'INTEGER', 0, '0', 0)
(30, 'is_service_message', 'INTEGER', 0, '0', 0)
(31, 'is_forward', 'INTEGER', 0, '0', 0)
(32, 'was_downgraded', 'INTEGER', 0, '0', 0)
(33, 'is_archive', 'INTEGER', 0, '0', 0)
(34, 'cache_has_attachments', 'INTEGER', 0, '0', 0)
(35, 'cache_roomnames', 'TEXT', 0, None, 0)
(36, 'was_data_detected', 'INTEGER', 0, '0', 0)
(37, 'was_deduplicated', 'INTEGER', 0, '0', 0)
(38, 'is_audio_message', 'INTEGER', 0, '0', 0)
(39, 'is_played', 'INTEGER', 0, '0', 0)
(40, 'date_played', 'INTEGER', 0, None, 0)
(41, 'item_type', 'INTEGER', 0, '0', 0)
(42, 'other_handle', 'INTEGER', 0, '0', 0)
(43, 'group_title', 'TEXT', 0, None, 0)
(44, 'group_action_type', 'INTEGER', 0, '0', 0)
(45, 'share_status', 'INTEGER', 0, '0', 0)
(46, 'share_direction', 'INTEGER', 0, '0', 0)
(47, 'is_expirable', 'INTEGER', 0, '0', 0)
(48, 'expire_state', 'INTEGER', 0, '0', 0)
(49, 'message_action_type', 'INTEGER', 0, '0', 0)
(50, 'message_source', 'INTEGER', 0, '0', 0)
(51, 'associated_message_guid', 'TEXT', 0, None, 0)
(52, 'associated_message_type', 'INTEGER', 0, '0', 0)
(53, 'balloon_bundle_id', 'TEXT', 0, None, 0)
(54, 'payload_data', 'BLOB', 0, None, 0)
(55, 'expressive_send_style_id', 'TEXT', 0, None, 0)
(56, 'associated_message_range_location', 'INTEGER', 0, '0', 0)
(57, 'associated_message_range_length', 'INTEGER', 0, '0', 0)
(58, 'time_expressive_send_played', 'INTEGER', 0, None, 0)
(59, 'message_summary_info', 'BLOB', 0, None, 0)
(60, 'ck_sync_state', 'INTEGER', 0, '0', 0)
(61, 'ck_record_id', 'TEXT', 0, None, 0)
(62, 'ck_record_change_tag', 'TEXT', 0, None, 0)
(63, 'destination_caller_id', 'TEXT', 0, None, 0)
(64, 'is_corrupt', 'INTEGER', 0, '0', 0)
(65, 'reply_to_guid', 'TEXT', 0, None, 0)
(66, 'sort_id', 'INTEGER', 0, None, 0)
(67, 'is_spam', 'INTEGER', 0, '0', 0)
(68, 'has_unseen_mention', 'INTEGER', 0, '0', 0)
(69, 'thread_originator_guid', 'TEXT', 0, None, 0)
(70, 'thread_originator_part', 'TEXT', 0, None, 0)
(71, 'syndication_ranges', 'TEXT', 0, None, 0)
(72, 'synced_syndication_ranges', 'TEXT', 0, None, 0)
(73, 'was_delivered_quietly', 'INTEGER', 0, '0', 0)
(74, 'did_notify_recipient', 'INTEGER', 0, '0', 0)
(75, 'date_retracted', 'INTEGER', 0, None, 0)
(76, 'date_edited', 'INTEGER', 0, None, 0)
(77, 'was_detonated', 'INTEGER', 0, '0', 0)
(78, 'part_count', 'INTEGER', 0, None, 0)
(79, 'is_stewie', 'INTEGER', 0, '0', 0)
(80, 'is_kt_verified', 'INTEGER', 0, '0', 0)
(81, 'is_sos', 'INTEGER', 0, '0', 0)
(82, 'is_critical', 'INTEGER', 0, '0', 0)
(83, 'bia_reference_id', 'TEXT', 0, 'NULL', 0)
(84, 'fallback_hash', 'TEXT', 0, 'NULL', 0)
Schema for chat:
(0, 'ROWID', 'INTEGER', 0, None, 1)
(1, 'guid', 'TEXT', 1, None, 0)
(2, 'style', 'INTEGER', 0, None, 0)
(3, 'state', 'INTEGER', 0, None, 0)
(4, 'account_id', 'TEXT', 0, None, 0)
(5, 'properties', 'BLOB', 0, None, 0)
(6, 'chat_identifier', 'TEXT', 0, None, 0)
(7, 'service_name', 'TEXT', 0, None, 0)
(8, 'room_name', 'TEXT', 0, None, 0)
(9, 'account_login', 'TEXT', 0, None, 0)
(10, 'is_archived', 'INTEGER', 0, '0', 0)
(11, 'last_addressed_handle', 'TEXT', 0, None, 0)
(12, 'display_name', 'TEXT', 0, None, 0)
(13, 'group_id', 'TEXT', 0, None, 0)
(14, 'is_filtered', 'INTEGER', 0, '0', 0)
(15, 'successful_query', 'INTEGER', 0, None, 0)
(16, 'engram_id', 'TEXT', 0, None, 0)
(17, 'server_change_token', 'TEXT', 0, None, 0)
(18, 'ck_sync_state', 'INTEGER', 0, '0', 0)
(19, 'original_group_id', 'TEXT', 0, None, 0)
(20, 'last_read_message_timestamp', 'INTEGER', 0, '0', 0)
(21, 'cloudkit_record_id', 'TEXT', 0, None, 0)
(22, 'last_addressed_sim_id', 'TEXT', 0, None, 0)
(23, 'is_blackholed', 'INTEGER', 0, '0', 0)
(24, 'syndication_date', 'INTEGER', 0, '0', 0)
(25, 'syndication_type', 'INTEGER', 0, '0', 0)
(26, 'is_recovered', 'INTEGER', 0, '0', 0)
(27, 'is_deleting_incoming_messages', 'INTEGER', 0, '0', 0)
Schema for handle:
(0, 'ROWID', 'INTEGER', 0, None, 1)
(1, 'id', 'TEXT', 1, None, 0)
(2, 'country', 'TEXT', 0, None, 0)
(3, 'service', 'TEXT', 1, None, 0)
(4, 'uncanonicalized_id', 'TEXT', 0, None, 0)
(5, 'person_centric_id', 'TEXT', 0, None, 0)