查询数据库
<p><strong>简要描述：</strong></p>
<ul>
<li>查询数据库，注意，返字段取决于你的查询语句，查询结果较多可能会导致崩溃，建议运用好sql语句中的limit</li>
</ul>
<p><strong>请求URL：</strong></p>
<ul>
<li><code>http://127.0.0.1:8989/api</code></li>
</ul>
<p><strong>请求方式：</strong></p>
<ul>
<li>POST</li>
</ul>
<p><strong>JSON参数：</strong></p>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">是否必选</th>
<th style="text-align: left;">类型</th>
<th style="text-align: left;">说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">type</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">int</td>
<td style="text-align: left;">消息类型</td>
</tr>
<tr>
<td style="text-align: left;">sql</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td style="text-align: left;">sql语句</td>
</tr>
<tr>
<td style="text-align: left;">db_name</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td style="text-align: left;">数据库名称</td>
</tr>
</tbody>
</table>
<p><strong>发送示例：</strong></p>
<pre><code class="language-json">{
&quot;type&quot;: 43,
&quot;sql&quot;: &quot;select * from sqlite_master&quot;,
&quot;db_name&quot;: &quot;MicroMsg.db&quot;
}</code></pre>
<p><strong>返回示例：</strong></p>
<pre><code class="language-json">{
&quot;data&quot;: {
&quot;list&quot;: [
{
&quot;name&quot;: &quot;Contact&quot;,
&quot;rootpage&quot;: &quot;2&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;Contact&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_Contact_1&quot;,
&quot;rootpage&quot;: &quot;3&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;Contact&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;Contact_Idx0&quot;,
&quot;rootpage&quot;: &quot;4&quot;,
&quot;sql&quot;: &quot;CREATE INDEX Contact_Idx0 ON Contact(Reserved2)&quot;,
&quot;tbl_name&quot;: &quot;Contact&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;OpLog&quot;,
&quot;rootpage&quot;: &quot;5&quot;,
&quot;sql&quot;: &quot;CREATE TABLE OpLog(ID INTEGER PRIMARY KEY,CMDItemBuffer BLOB)&quot;,
&quot;tbl_name&quot;: &quot;OpLog&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;Session&quot;,
&quot;rootpage&quot;: &quot;6&quot;,
&quot;sql&quot;: &quot;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,nMsgType\tINTEGER,nMsgLocalID INTEGER,nMsgStatus INTEGER,nTime INTEGER,editContent TEXT,othersAtMe INT,Reserved2 INTEGER DEFAULT 0,Reserved3 TEXT,Reserved4 INTEGER DEFAULT 0,Reserved5 TEXT,bytesXml BLOB)&quot;,
&quot;tbl_name&quot;: &quot;Session&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_Session_1&quot;,
&quot;rootpage&quot;: &quot;7&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;Session&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;nOrderIndex&quot;,
&quot;rootpage&quot;: &quot;8&quot;,
&quot;sql&quot;: &quot;CREATE INDEX nOrderIndex ON Session(nOrder)&quot;,
&quot;tbl_name&quot;: &quot;Session&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;AppInfo&quot;,
&quot;rootpage&quot;: &quot;9&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;AppInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_AppInfo_1&quot;,
&quot;rootpage&quot;: &quot;10&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;AppInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ContactHeadImgUrl&quot;,
&quot;rootpage&quot;: &quot;11&quot;,
&quot;sql&quot;: &quot;CREATE TABLE ContactHeadImgUrl(\t\t\t\t\t\t\tusrName TEXT PRIMARY KEY,\t\t\t\t\t\t\tsmallHeadImgUrl TEXT,\t\t\t\t\t\t\tbigHeadImgUrl TEXT,\t\t\t\t\t\t\theadImgMd5 TEXT,\t\t\t\t\t\t\treverse0 INT,\t\t\t\t\t\t\treverse1 TEXT)&quot;,
&quot;tbl_name&quot;: &quot;ContactHeadImgUrl&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_ContactHeadImgUrl_1&quot;,
&quot;rootpage&quot;: &quot;12&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;ContactHeadImgUrl&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;reverse0Index&quot;,
&quot;rootpage&quot;: &quot;13&quot;,
&quot;sql&quot;: &quot;CREATE INDEX reverse0Index ON ContactHeadImgUrl(reverse0)&quot;,
&quot;tbl_name&quot;: &quot;ContactHeadImgUrl&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizInfo&quot;,
&quot;rootpage&quot;: &quot;14&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;BizInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_BizInfo_1&quot;,
&quot;rootpage&quot;: &quot;15&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;BizInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;TicketInfo&quot;,
&quot;rootpage&quot;: &quot;16&quot;,
&quot;sql&quot;: &quot;CREATE TABLE TicketInfo(UserName TEXT PRIMARY KEY,Ticket TEXT,Reserved1 INTEGER DEFAULT 0,Reserved2 TEXT,Reserved3 INTEGER DEFAULT 0,Reserved4 TEXT)&quot;,
&quot;tbl_name&quot;: &quot;TicketInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_TicketInfo_1&quot;,
&quot;rootpage&quot;: &quot;17&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;TicketInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatRoom&quot;,
&quot;rootpage&quot;: &quot;18&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;ChatRoom&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_ChatRoom_1&quot;,
&quot;rootpage&quot;: &quot;19&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;ChatRoom&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatRoomInfo&quot;,
&quot;rootpage&quot;: &quot;20&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;ChatRoomInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_ChatRoomInfo_1&quot;,
&quot;rootpage&quot;: &quot;21&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;ChatRoomInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;MainConfig&quot;,
&quot;rootpage&quot;: &quot;22&quot;,
&quot;sql&quot;: &quot;CREATE TABLE MainConfig(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)&quot;,
&quot;tbl_name&quot;: &quot;MainConfig&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_MainConfig_1&quot;,
&quot;rootpage&quot;: &quot;23&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;MainConfig&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;RevokeMsgStorage&quot;,
&quot;rootpage&quot;: &quot;26&quot;,
&quot;sql&quot;: &quot;CREATE TABLE RevokeMsgStorage (\t\t\t\t\t\t\tCreateTime INTEGER PRIMARY KEY,\t\t\t\t\t\t\tMsgSvrID INTERGER,\t\t\t\t\t\t\tRevokeSvrID INTERGER)&quot;,
&quot;tbl_name&quot;: &quot;RevokeMsgStorage&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;MsgSvrId_Idx&quot;,
&quot;rootpage&quot;: &quot;27&quot;,
&quot;sql&quot;: &quot;CREATE INDEX MsgSvrId_Idx ON RevokeMsgStorage(MsgSvrID)&quot;,
&quot;tbl_name&quot;: &quot;RevokeMsgStorage&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;RevokeSvrID_Idx&quot;,
&quot;rootpage&quot;: &quot;28&quot;,
&quot;sql&quot;: &quot;CREATE INDEX RevokeSvrID_Idx ON RevokeMsgStorage(RevokeSvrID)&quot;,
&quot;tbl_name&quot;: &quot;RevokeMsgStorage&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizProfileV2&quot;,
&quot;rootpage&quot;: &quot;29&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;BizProfileV2&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;BizProfileV2TimeIdx&quot;,
&quot;rootpage&quot;: &quot;30&quot;,
&quot;sql&quot;: &quot;CREATE INDEX BizProfileV2TimeIdx ON BizProfileV2(TimeStamp)&quot;,
&quot;tbl_name&quot;: &quot;BizProfileV2&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizName2ID&quot;,
&quot;rootpage&quot;: &quot;31&quot;,
&quot;sql&quot;: &quot;CREATE TABLE BizName2ID(UsrName TEXT PRIMARY KEY)&quot;,
&quot;tbl_name&quot;: &quot;BizName2ID&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_BizName2ID_1&quot;,
&quot;rootpage&quot;: &quot;32&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;BizName2ID&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizProfileInfo&quot;,
&quot;rootpage&quot;: &quot;33&quot;,
&quot;sql&quot;: &quot;CREATE TABLE BizProfileInfo (\t\t\t\t\t\t\ttableIndex INTEGER PRIMARY KEY,\t\t\t\t\t\t\ttableVersion INTERGER,\t\t\t\t\t\t\ttableDesc TEXT)&quot;,
&quot;tbl_name&quot;: &quot;BizProfileInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;versionIdx&quot;,
&quot;rootpage&quot;: &quot;34&quot;,
&quot;sql&quot;: &quot;CREATE INDEX versionIdx ON BizProfileInfo(tableIndex)&quot;,
&quot;tbl_name&quot;: &quot;BizProfileInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizSessionNewFeeds&quot;,
&quot;rootpage&quot;: &quot;35&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;BizSessionNewFeeds&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;BizSessionNewFeedsUpdateTimeIdx&quot;,
&quot;rootpage&quot;: &quot;36&quot;,
&quot;sql&quot;: &quot;CREATE INDEX BizSessionNewFeedsUpdateTimeIdx ON BizSessionNewFeeds(UpdateTime)&quot;,
&quot;tbl_name&quot;: &quot;BizSessionNewFeeds&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;BizSessionNewFeedsCreateTimeIdx&quot;,
&quot;rootpage&quot;: &quot;37&quot;,
&quot;sql&quot;: &quot;CREATE INDEX BizSessionNewFeedsCreateTimeIdx ON BizSessionNewFeeds(CreateTime)&quot;,
&quot;tbl_name&quot;: &quot;BizSessionNewFeeds&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;DelayDownLoad&quot;,
&quot;rootpage&quot;: &quot;38&quot;,
&quot;sql&quot;: &quot;CREATE TABLE DelayDownLoad (MessageServId INTEGER UNIQUE )&quot;,
&quot;tbl_name&quot;: &quot;DelayDownLoad&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_DelayDownLoad_1&quot;,
&quot;rootpage&quot;: &quot;39&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;DelayDownLoad&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatLiveInfo&quot;,
&quot;rootpage&quot;: &quot;40&quot;,
&quot;sql&quot;: &quot;CREATE TABLE ChatLiveInfo (RoomName TEXT, LiveId INTEGER, LiveName TEXT, AnchorName TEXT, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 BLOB, UNIQUE (RoomName , LiveId ))&quot;,
&quot;tbl_name&quot;: &quot;ChatLiveInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_ChatLiveInfo_1&quot;,
&quot;rootpage&quot;: &quot;41&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;ChatLiveInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatLiveInfoRoomNamex&quot;,
&quot;rootpage&quot;: &quot;42&quot;,
&quot;sql&quot;: &quot;CREATE INDEX ChatLiveInfoRoomNamex ON ChatLiveInfo(RoomName)&quot;,
&quot;tbl_name&quot;: &quot;ChatLiveInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatLiveInfoLiveIdIdx&quot;,
&quot;rootpage&quot;: &quot;43&quot;,
&quot;sql&quot;: &quot;CREATE INDEX ChatLiveInfoLiveIdIdx ON ChatLiveInfo(LiveId)&quot;,
&quot;tbl_name&quot;: &quot;ChatLiveInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;PatInfo&quot;,
&quot;rootpage&quot;: &quot;44&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;PatInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_PatInfo_1&quot;,
&quot;rootpage&quot;: &quot;45&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;PatInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;FTSContactTrans&quot;,
&quot;rootpage&quot;: &quot;46&quot;,
&quot;sql&quot;: &quot;CREATE TABLE FTSContactTrans (\t\t\t\t\t\t\t\tusername TEXT,\t\t\t\t\t\t\t\treserve1 INTEGER, \t\t\t\t\t\t\t\treserve2 TEXT)&quot;,
&quot;tbl_name&quot;: &quot;FTSContactTrans&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;FTSChatroomTrans&quot;,
&quot;rootpage&quot;: &quot;47&quot;,
&quot;sql&quot;: &quot;CREATE TABLE FTSChatroomTrans (\t\t\t\t\t\t\t\tusername TEXT,\t\t\t\t\t\t\t\tgroupUsername TEXT,\t\t\t\t\t\t\t\tdisplayName TEXT,\t\t\t\t\t\t\t\tnickname TEXT,\t\t\t\t\t\t\t\toperation INTEGER,\t\t\t\t\t\t\t\treserve1 INTEGER, \t\t\t\t\t\t\t\treserve2 TEXT)&quot;,
&quot;tbl_name&quot;: &quot;FTSChatroomTrans&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;ContactLabel&quot;,
&quot;rootpage&quot;: &quot;1430&quot;,
&quot;sql&quot;: &quot;CREATE TABLE ContactLabel (LabelId INTEGER PRIMARY KEY, LabelName TEXT, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, RespData BLOB, Reserved5 BLOB)&quot;,
&quot;tbl_name&quot;: &quot;ContactLabel&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;ChatInfo&quot;,
&quot;rootpage&quot;: &quot;2863&quot;,
&quot;sql&quot;: &quot;CREATE TABLE ChatInfo (Username TEXT, LastReadedSvrId INTEGER, LastReadedCreateTime INTEGER, Reserved1 INTEGER, Reserved2 INTEGER, Reserved3 TEXT, Reserved4 TEXT, Reserved5 INTEGER, Reserved6 TEXT, Reserved7 BLOB)&quot;,
&quot;tbl_name&quot;: &quot;ChatInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;ChatInfoUserNameIndex&quot;,
&quot;rootpage&quot;: &quot;2864&quot;,
&quot;sql&quot;: &quot;CREATE INDEX ChatInfoUserNameIndex ON ChatInfo(Username)&quot;,
&quot;tbl_name&quot;: &quot;ChatInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;TopStoryReddotInfo&quot;,
&quot;rootpage&quot;: &quot;3099&quot;,
&quot;sql&quot;: &quot;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)&quot;,
&quot;tbl_name&quot;: &quot;TopStoryReddotInfo&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_TopStoryReddotInfo_1&quot;,
&quot;rootpage&quot;: &quot;3125&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;TopStoryReddotInfo&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;MainConfigReserved0Idx&quot;,
&quot;rootpage&quot;: &quot;3887&quot;,
&quot;sql&quot;: &quot;CREATE INDEX MainConfigReserved0Idx ON MainConfig(Reserved0)&quot;,
&quot;tbl_name&quot;: &quot;MainConfig&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;MainConfigReserved1Idx&quot;,
&quot;rootpage&quot;: &quot;3889&quot;,
&quot;sql&quot;: &quot;CREATE INDEX MainConfigReserved1Idx ON MainConfig(Reserved1)&quot;,
&quot;tbl_name&quot;: &quot;MainConfig&quot;,
&quot;type&quot;: &quot;index&quot;
},
{
&quot;name&quot;: &quot;ChatroomTool&quot;,
&quot;rootpage&quot;: &quot;2425&quot;,
&quot;sql&quot;: &quot;CREATE TABLE ChatroomTool (ChatroomUsername TEXT, RoomToolsBuffer BLOB, Reserved1 INTEGER, Reserved2 TEXT, Reserved3 INTEGER, Reserved4 TEXT, Reserved5 BLOB, UNIQUE (ChatroomUsername ))&quot;,
&quot;tbl_name&quot;: &quot;ChatroomTool&quot;,
&quot;type&quot;: &quot;table&quot;
},
{
&quot;name&quot;: &quot;sqlite_autoindex_ChatroomTool_1&quot;,
&quot;rootpage&quot;: &quot;2619&quot;,
&quot;sql&quot;: &quot;&quot;,
&quot;tbl_name&quot;: &quot;ChatroomTool&quot;,
&quot;type&quot;: &quot;index&quot;
}
]
},
&quot;errmsg&quot;: &quot;OK&quot;,
&quot;errno&quot;: 0
}</code></pre>