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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
| "ChatMsg.db",
{
"name": "ChatMsg",
"sql": "CREATE TABLE ChatMsg(localId INTEGER PRIMARY KEY AUTOINCREMENT,talkerId INT DEFAULT 0,MsgSvrID INT,type INT,IsSender INT,Status INT,CreateTime INT,strTalker TEXT,strContent TEXT,Reserved0 INT DEFAULT 0,Reserved1 TEXT,bytesTrans BLOB,bytesExtra BLOB,translatedContent TEXT,translatedBrand TEXT,Reserved2 INT DEFAULT 0,Reserved3 TEXT,Reserved4 TEXT)"
},
{
"name": "sqlite_sequence",
"sql": "CREATE TABLE sqlite_sequence(name,seq)"
},
{
"name": "TransTable",
"sql": "CREATE TABLE TransTable(msgLocalId INTEGER PRIMARY KEY,talkerId INT)"
},
{
"name": "ChatCRMsg",
"sql": "CREATE TABLE ChatCRMsg(localId INTEGER PRIMARY KEY AUTOINCREMENT,talkerId INT DEFAULT 0,MsgSvrID INT,type INT,sequence INT DEFAULT 0,statusEx INT DEFAULT 0,FlagEx INT,IsSender INT,Status INT,CreateTime INT,strTalker TEXT,strContent TEXT,Reserved0 INT DEFAULT 0,Reserved1 TEXT,bytesTrans BLOB,bytesExtra BLOB,translatedContent TEXT,translatedBrand TEXT,Reserved2 INT DEFAULT 0,Reserved3 TEXT,Reserved4 TEXT)"
},
{
"name": "TransCRTable",
"sql": "CREATE TABLE TransCRTable(msgLocalId INTEGER PRIMARY KEY,talkerId INT)"
},
{
"name": "Name2ID_v1",
"sql": "CREATE TABLE Name2ID_v1(UsrName TEXT PRIMARY KEY)"
},
{
"name": "DelSessionInfo",
"sql": "CREATE TABLE DelSessionInfo(talkerId INTEGER PRIMARY KEY,dbType INT DEFAULT 0,LocalId INT DEFAULT 0,svrID INT DEFAULT 0,seq INT DEFAULT 0,usrName TEXT,Reserved0 INT DEFAULT 0,Reserved1 TEXT,Reserved2 INT DEFAULT 0,Reserved3 TEXT)"
},
{
"name": "ChatRecordCompatXml",
"sql": "CREATE TABLE ChatRecordCompatXml(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)"
},
{
"name": "TeenagerModeAuthStorage",
"sql": "CREATE TABLE TeenagerModeAuthStorage (CreateTime INTEGER PRIMARY KEY,MsgSvrID INTERGER,RevokeSvrID INTERGER)"
},
{
"name": "ChatConfig",
"sql": "CREATE TABLE ChatConfig (Key INTEGER UNIQUE, IValue INTEGER, StrValue TEXT, BufValue BLOB, Reserved1 INTEGER, Reserved2 TEXT, Reserved3 BLOB)"
}
"Emotion.db",
{
"name": "EmotionPackageItem",
"sql": "CREATE TABLE EmotionPackageItem(ProductId TEXT PRIMARY KEY,nOrder INTEGER,Reserved0 INTEGER,Name TEXT,IconUrl TEXT,PannelUrl TEXT,PayStatus INTEGER,DownloadStatus INTEGER,InstallTime INTEGER,Reserved1 INTEGER,Reserved2 TEXT,Reserved3 INTEGER)"
},
{
"name": "EmotionItem",
"sql": "CREATE TABLE EmotionItem(localId INTEGER PRIMARY KEY AUTOINCREMENT,ProductId INTEGER,MD5 TEXT NOT NULL,Reserved0 INTEGER,Reserved1 TEXT,Type INTEGER,AppId TEXT,FromUrl TEXT,Thumb BLOB,Data BLOB,Reserved2 INTEGER,Reserved3 TEXT,Reserved4 INTEGER, UNIQUE(ProductId,MD5))"
},
{
"name": "sqlite_sequence",
"sql": "CREATE TABLE sqlite_sequence(name,seq)"
},
{
"name": "EmotionDes1",
"sql": "CREATE TABLE EmotionDes1(localId INTEGER PRIMARY KEY AUTOINCREMENT,ProductId TEXT,MD5 TEXT NOT NULL UNIQUE,Des BLOB,Reserved0 INTEGER,Reserved1 TEXT,Reserved2 BLOB)"
},
{
"name": "EmotionOrderInfo",
"sql": "CREATE TABLE EmotionOrderInfo(MD5 TEXT PRIMARY KEY,ProductId INTEGER,lastUseTime INTEGER,Reserved0 INTEGER,Reserved1 TEXT)"
},
{
"name": "Name2ID",
"sql": "CREATE TABLE Name2ID(UsrName TEXT PRIMARY KEY)"
},
{
"name": "CustomEmotion",
"sql": "CREATE TABLE CustomEmotion(MD5 TEXT PRIMARY KEY,ProductId INTEGER,CDNUrl TEXT,designerid TEXT,thumburl TEXT,encrypturl TEXT,aeskey TEXT,Reserved0 INTEGER,Reserved1 TEXT,Reserved2 INTEGER,Data BLOB,Reserved3 TEXT,Reserved4 INTEGER)"
}
"FunctionMsg.db",
{
"name": "FunctionMsg",
"sql": "CREATE TABLE FunctionMsg(nCreateTime INTEGER,nHashId INTEGER, strFunctionMsgId TEXT, nCmdId INT DEFAULT 0,nOpCode INTEGER DEFAULT 0,nRetryInterval INTEGER DEFAULT 0,nReportId INTEGER DEFAULT 0,nVersion INTEGER DEFAULT 0,nFunctionMsgVersion INTEGER DEFAULT0,strSuccessKey TEXT,strFailKey TEXT,strFinalFailKey TEXT,strCustomBuff TEXT,nMsgSvrIdINTEGER,nRetryCount INTEGER,nBusinessId INTEGER,strBusinessBuff TEXT,nActionTime INTEGER,nDelayTime INTEGER,strCGI TEXT,strAddMsg TEXT,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT,blobOriginalAddMsg BLOB,blobNotShowAddMsg BLOB)"
},
{
"name": "FunctionMsgTask",
"sql": "CREATE TABLE FunctionMsgTask(nCreateTime INTEGER DEFAULT 0, strFunctionMsgId TEXT, nOpCode INTEGER DEFAULT 0,nActionTime INTEGER,blobAddMsgBuffer BLOB,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT)"
}
"MSG0.db",
{
"name": "MSG",
"sql": "CREATE TABLE MSG (localId INTEGER PRIMARY KEY AUTOINCREMENT,TalkerId INT DEFAULT 0,MsgSvrID INT,Type INT,SubType INT,IsSender INT,CreateTime INT,Sequence INT DEFAULT 0,StatusEx INT DEFAULT 0,FlagEx INT,Status INT,MsgServerSeq INT,MsgSequence INT,StrTalker TEXT,StrContent TEXT,DisplayContent TEXT,Reserved0 INT DEFAULT 0,Reserved1 INT DEFAULT 0,Reserved2 INT DEFAULT 0,Reserved3 INT DEFAULT 0,Reserved4 TEXT,Reserved5 TEXT,Reserved6 TEXT,CompressContent BLOB,BytesExtra BLOB,BytesTrans BLOB)"
},
{
"name": "sqlite_sequence",
"sql": "CREATE TABLE sqlite_sequence(name,seq)"
},
{
"name": "MSGTrans",
"sql": "CREATE TABLE MSGTrans(msgLocalId INTEGER PRIMARY KEY, talkerId INT)"
},
{
"name": "Name2ID",
"sql": "CREATE TABLE Name2ID(UsrName TEXT PRIMARY KEY)"
},
{
"name": "DBInfo",
"sql": "CREATE TABLE DBInfo (tableIndex INTEGER PRIMARY KEY,tableVersion INTERGER,tableDesc TEXT)"
}
"Media.db",
{
"name": "MediaInfo",
"sql": "CREATE TABLE MediaInfo(MsgLocalId INTEGER PRIMARY KEY,TalkerId INTEGER DEFAULT 0,MsgType INTEGER DEFAULT 0,Reserved0 INTEGER DEFAULT 0,Reserved1 TEXT,Thumbnail BLOB,Detail BLOB,Reserved2 INTEGER DEFAULT 0,Reserved3 TEXT)"
},
{
"name": "ChatCRVoice",
"sql": "CREATE TABLE ChatCRVoice(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)"
}
"MediaMSG0.db",
{
"name": "Media",
"sql": "CREATE TABLE Media(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)"
}
"MicroMsg.db",
{
"name": "Contact",
"sql": "CREATE TABLE Contact(UserName TEXT PRIMARY KEY ,Alias TEXT,EncryptUserName TEXT,DelFlag INTEGER DEFAULT 0,Type INTEGER DEFAULT 0,VerifyFlag INTEGER DEFAULT 0,Reserved1 INTEGER DEFAULT 0,Reserved2 INTEGER DEFAULT 0,Reserved3 TEXT,Reserved4 TEXT,Remark TEXT,NickName TEXT,LabelIDList TEXT,DomainList TEXT,ChatRoomType int,PYInitial TEXT,QuanPin TEXT,RemarkPYInitial TEXT,RemarkQuanPin TEXT,BigHeadImgUrl TEXT,SmallHeadImgUrl TEXT,HeadImgMd5 TEXT,ChatRoomNotify INTEGER DEFAULT 0,Reserved5 INTEGER DEFAULT 0,Reserved6 TEXT,Reserved7 TEXT,ExtraBuf BLOB,Reserved8 INTEGER DEFAULT 0,Reserved9 INTEGER DEFAULT 0,Reserved10 TEXT,Reserved11 TEXT)"
},
{
"name": "OpLog",
"sql": "CREATE TABLE OpLog(ID INTEGER PRIMARY KEY,CMDItemBuffer BLOB)"
},
{
"name": "Session",
"sql": "CREATE TABLE Session(strUsrName TEXT PRIMARY KEY,nOrder INT DEFAULT 0,nUnReadCount INTEGER DEFAULT 0,parentRef TEXT,Reserved0 INTEGER DEFAULT 0,Reserved1 TEXT,strNickName TEXT,nStatus INTEGER,nIsSend INTEGER,strContent TEXT,nMsgTypeINTEGER,nMsgLocalID INTEGER,nMsgStatus INTEGER,nTime INTEGER,editContent TEXT,othersAtMe INT,Reserved2 INTEGER DEFAULT 0,Reserved3 TEXT,Reserved4 INTEGER DEFAULT 0,Reserved5 TEXT,bytesXml BLOB)"
},
{
"name": "AppInfo",
"sql": "CREATE TABLE AppInfo(InfoKey TEXT PRIMARY KEY,AppId TEXT,Version INT,IconUrl TEXT,StoreUrl TEXT,WatermarkUrl TEXT,HeadImgBuf BLOB,Name TEXT,Description TEXT,Name4EnUS TEXT,Description4EnUS TEXT,Name4ZhTW TEXT,Description4ZhTW TEXT)"
},
{
"name": "ContactHeadImgUrl",
"sql": "CREATE TABLE ContactHeadImgUrl(usrName TEXT PRIMARY KEY,smallHeadImgUrl TEXT,bigHeadImgUrl TEXT,headImgMd5 TEXT,reverse0 INT,reverse1 TEXT)"
},
{
"name": "BizInfo",
"sql": "CREATE TABLE BizInfo(UserName TEXT PRIMARY KEY,Type INTEGER DEFAULT 0,Belong TEXT,AcceptType INTEGER DEFAULT 0,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,BrandList TEXT,BrandFlag INTEGER DEFAULT 0,BrandInfo TEXT,BrandIconURL TEXT,UpdateTime INTEGER DEFAULT 0,ExtInfo TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT,Reserved5 INTEGER DEFAULT 0,Reserved6 TEXT,Reserved7 INTEGER DEFAULT 0,Reserved8 TEXT,Reserved9 BLOB)"
},
{
"name": "TicketInfo",
"sql": "CREATE TABLE TicketInfo(UserName TEXT PRIMARY KEY,Ticket TEXT,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT)"
},
{
"name": "ChatRoom",
"sql": "CREATE TABLE ChatRoom(ChatRoomName TEXT PRIMARY KEY,UserNameList TEXT,DisplayNameList TEXT,ChatRoomFlag int Default 0,Owner INTEGER DEFAULT 0,IsShowName INTEGER DEFAULT 0,SelfDisplayName TEXT,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT,Reserved5 INTEGER DEFAULT 0,Reserved6 TEXT,RoomData BLOB,Reserved7 INTEGER DEFAULT 0,Reserved8 TEXT)"
},
{
"name": "ChatRoomInfo",
"sql": "CREATE TABLE ChatRoomInfo(ChatRoomName TEXT PRIMARY KEY,Announcement TEXT,InfoVersion INTEGER DEFAULT 0,AnnouncementEditor TEXT,AnnouncementPublishTime INTEGER DEFAULT 0,ChatRoomStatus INTEGER DEFAULT 0,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT,Reserved5 INTEGER DEFAULT 0,Reserved6 TEXT,Reserved7 INTEGER DEFAULT 0,Reserved8 TEXT)"
},
{
"name": "MainConfig",
"sql": "CREATE TABLE MainConfig(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)"
},
{
"name": "RevokeMsgStorage",
"sql": "CREATE TABLE RevokeMsgStorage (CreateTime INTEGER PRIMARY KEY,MsgSvrID INTERGER,RevokeSvrID INTERGER)"
},
{
"name": "BizProfileV2",
"sql": "CREATE TABLE BizProfileV2 (TalkerId INTEGER PRIMARY KEY, UserName TEXT, ServiceType INTEGER, ArticleCount INTEGER, FriendSubscribedCount INTEGER, IsSubscribed INTEGER, Offset TEXT, IsEnd INTEGER, TimeStamp INTEGER, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, RespData BLOB, Reserved5 BLOB)"
},
{
"name": "BizName2ID",
"sql": "CREATE TABLE BizName2ID(UsrName TEXT PRIMARY KEY)"
},
{
"name": "BizProfileInfo",
"sql": "CREATE TABLE BizProfileInfo (tableIndex INTEGER PRIMARY KEY,tableVersion INTERGER,tableDesc TEXT)"
},
{
"name": "BizSessionNewFeeds",
"sql": "CREATE TABLE BizSessionNewFeeds (TalkerId INTEGER PRIMARY KEY, BizName TEXT, Title TEXT, Desc TEXT, Type INTEGER, UnreadCount INTEGER, UpdateTime INTEGER, CreateTime INTEGER, BizAttrVersion INTEGER, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 BLOB)"
},
{
"name": "ChatInfo",
"sql": "CREATE TABLE ChatInfo (Username TEXT, LastReadedSvrId INTEGER, LastReadedCreateTime INTEGER, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 INTEGER, Reserved6 TEXT, Reserved7 BLOB)"
},
{
"name": "ChatLiveInfo",
"sql": "CREATE TABLE ChatLiveInfo (RoomName TEXT, LiveId INTEGER, LiveName TEXT, AnchorName TEXT, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 BLOB, UNIQUE (RoomName , LiveId ))"
},
{
"name": "TopStoryReddotInfo",
"sql": "CREATE TABLE TopStoryReddotInfo (MsgId TEXT PRIMARY KEY, Discovery INTEGER, Entry INTEGER, IosCliVersion INTEGER, AndroidCliVersion INTEGER, H5Version INTEGER, ExpireTime INTEGER, ReddotType INTEGER, TimeStamp INTEGER, ExtInfo TEXT, Seq INTEGER, ReddotText TEXT, ReddotIcon TEXT, Clear INTEGER, Priority INTEGER, HasRead INTEGER, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 INTEGER, Reserved6 TEXT, Reserved7 BLOB)"
},
{
"name": "PatInfo",
"sql": "CREATE TABLE PatInfo (username TEXT UNIQUE PRIMARY KEY , suffix TEXT, reserved1 INTEGER DEFAULT 0, reserved2 INTEGER DEFAULT 0, reserved3 INTEGER DEFAULT 0, reserved4 INTEGER DEFAULT 0, reserved5 TEXT, reserved6 TEXT, reserved7 TEXT, reserved8 TEXT, reserved9 TEXT)"
},
{
"name": "FTSContactTrans",
"sql": "CREATE TABLE FTSContactTrans (username TEXT,reserve1 INTEGER, reserve2 TEXT)"
},
{
"name": "FTSChatroomTrans",
"sql": "CREATE TABLE FTSChatroomTrans (username TEXT,groupUsername TEXT,displayName TEXT,nickname TEXT,operation INTEGER,reserve1 INTEGER, reserve2 TEXT)"
},
{
"name": "ChatroomTool",
"sql": "CREATE TABLE ChatroomTool (ChatroomUsername TEXT, RoomToolsBuffer BLOB, Reserved1 INTEGER, Reserved2 TEXT, Reserved3 INTEGER, Reserved4 TEXT, Reserved5 BLOB, UNIQUE (ChatroomUsername ))"
}
"Misc.db"
{
"name": "ContactHeadImg1",
"sql": "CREATE TABLE ContactHeadImg1(usrName TEXT PRIMARY KEY,createTime INT,smallHeadBuf BLOB,m_headImgMD5 TEXT)"
},
{
"name": "BizContactHeadImg",
"sql": "CREATE TABLE BizContactHeadImg(usrName TEXT PRIMARY KEY,createTime INT,smallHeadBuf BLOB,m_headImgMD5 TEXT)"
}
|