ChatMsg.db
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)
CREATE TABLE sqlite_sequence(name,seq)
CREATE INDEX talkerIDIdx ON ChatMsg(talkerId)
CREATE INDEX SvrIdIdx ON ChatMsg(MsgSvrID DESC)
CREATE INDEX TalkerIdTypeIndex ON ChatMsg(talkerId,type)
CREATE TABLE TransTable(msgLocalId INTEGER PRIMARY KEY,talkerId INT)
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)
CREATE INDEX ChatCRMsgStorageIdx_1 ON ChatCRMsg(talkerId,sequence DESC)
CREATE INDEX ChatCRMsgStorageIdx_2 ON ChatCRMsg(talkerId,type,sequence DESC)
CREATE INDEX ChatCRMsgStorageIdx_3 ON ChatCRMsg(MsgSvrID)
CREATE TABLE TransCRTable(msgLocalId INTEGER PRIMARY KEY,talkerId INT)
CREATE TABLE Name2ID_v1(UsrName TEXT PRIMARY KEY)
(null)
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)
CREATE TABLE ChatRecordCompatXml(Key TEXT PRIMARY KEY,Reserved0 INT,Buf BLOB,Reserved1 INT,Reserved2 TEXT)
(null)
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)
CREATE TABLE sqlite_sequence(name,seq)
CREATE INDEX talkerIDIdx ON ChatMsg(talkerId)
CREATE INDEX SvrIdIdx ON ChatMsg(MsgSvrID DESC)
CREATE INDEX TalkerIdTypeIndex ON ChatMsg(talkerId,type)
CREATE TABLE TransTable(msgLocalId INTEGER PRIMARY KEY,talkerId INT)
CREATE TABLE NameToId (								userName TEXT PRIMARY KEY)
(null)
CREATE TABLE MsgSearchInfo18 (entityId INTEGER,fromEntityId INTEGER,		msgType INTEGER,msgSubType INTEGER,		createTime INTEGER,	prefixLocalId INTEGER,		sortSequence INTEGER, 		fileExt INTEGER,		fileSize INTEGER,		innerId INTEGER,		lastOpTime INTEGER,		fileStatus INTEGER,		docId INTEGER,		title TEXT)
CREATE VIRTUAL TABLE FTSMsgSearch18 USING fts4(content,tokenize=mmTokenizer "porter")
CREATE TABLE 'FTSMsgSearch18_content'(docid INTEGER PRIMARY KEY, 'c0content')
CREATE TABLE 'FTSMsgSearch18_segments'(blockid INTEGER PRIMARY KEY, block BLOB)
CREATE TABLE 'FTSMsgSearch18_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
(null)
CREATE TABLE 'FTSMsgSearch18_docsize'(docid INTEGER PRIMARY KEY, size BLOB)
CREATE TABLE 'FTSMsgSearch18_stat'(id INTEGER PRIMARY KEY, value BLOB)
CREATE INDEX MsgSearchInfo18_idTypeIdx ON MsgSearchInfo18(entityId, msgType, sortSequence)
CREATE INDEX MsgSearchInfo18_idSubTypeIdx ON MsgSearchInfo18(entityId, msgSubType, sortSequence)
CREATE INDEX MsgSearchInfo18_idTalkerIdx ON MsgSearchInfo18(entityId, fromEntityId, sortSequence)
CREATE INDEX MsgSearchInfo18_idTimeIdx ON MsgSearchInfo18(entityId, createTime)
CREATE INDEX MsgSearchInfo18FileEntityIdFileExtIndex ON MsgSearchInfo18(msgSubType,entityId,sortSequence,fileExt)
CREATE INDEX MsgSearchInfo18FileEntityIdFileSizeIndex ON MsgSearchInfo18(msgSubType,entityId,sortSequence,fileSize)
CREATE INDEX MsgSearchInfo18FileEntityIdFileStatusIndex ON MsgSearchInfo18(msgSubType,entityId,sortSequence,fileStatus)
CREATE INDEX MsgSearchInfo18FileFromEntityIdFileExtIndex ON MsgSearchInfo18(msgSubType,fromEntityId,sortSequence,fileExt)
CREATE INDEX MsgSearchInfo18FileFromEntityIdFileSizeIndex ON MsgSearchInfo18(msgSubType,fromEntityId,sortSequence,fileSize)
CREATE INDEX MsgSearchInfo18FileFromEntityIdFileStatusIndex ON MsgSearchInfo18(msgSubType,fromEntityId,sortSequence,fileStatus)
CREATE INDEX MsgSearchInfo18FileLastOpTimeIndex ON MsgSearchInfo18(msgSubType,sortSequence,lastOpTime)
CREATE INDEX MsgSearchInfo18FileExtTimeIndex ON MsgSearchInfo18(msgSubType,fileExt,sortSequence)
CREATE INDEX MsgSearchInfo18FileExtSizeIndex ON MsgSearchInfo18(msgSubType,fileExt,fileSize)
CREATE INDEX MsgSearchInfo18FileExtStatusIndex ON MsgSearchInfo18(msgSubType,fileExt,fileStatus)
CREATE INDEX MsgSearchInfo18FileTimeSizeIndex ON MsgSearchInfo18(msgSubType,sortSequence,fileSize)
CREATE INDEX MsgSearchInfo18FileTimeStatusIndex ON MsgSearchInfo18(msgSubType,sortSequence,fileStatus)
CREATE INDEX MsgSearchInfo18FileTimeExtIndex ON MsgSearchInfo18(msgSubType,sortSequence,fileExt)
CREATE INDEX MsgSearchInfo18PrefixLocalIdIndex ON MsgSearchInfo18(prefixLocalId)
CREATE TABLE FileExt18 (								userName TEXT PRIMARY KEY)
(null)
CREATE TABLE DBTableInfo18 (							tableIndex INTEGER PRIMARY KEY,							tableVersion INTERGER,							tableDesc TEXT)
CREATE INDEX versionIdx ON DBTableInfo18(tableIndex)