biz_schema.sql
2.08 KB
CREATE TABLE bizMsg(localId INTEGER PRIMARY KEY, userName TEXT, svrId INTEGER, svrTime INTEGER, content BLOB, msgStatus INTEGER, type INTEGER, isExpand INTEGER, isBigPic INTEGER, hasReadDot INTEGER, adInfo TEXT, xml TEXT, dataType INTEGER, msgSource TEXT, exposedDuration INTEGER, exposedAreaMaxRadio INTEGER, reddotReportInfo TEXT);
CREATE INDEX bizMsgbiz_hasReadDot_index ON bizMsg(hasReadDot);
CREATE INDEX bizMsgbiz_svrTime_index ON bizMsg(svrTime);
CREATE INDEX bizMsgbiz_userName_svrID_index ON bizMsg(userName, svrId);
CREATE TABLE bizMsgExt(localId INTEGER PRIMARY KEY, userName TEXT, svrId INTEGER, svrTime INTEGER, content BLOB, msgStatus INTEGER, type INTEGER, isExpand INTEGER, isBigPic INTEGER, hasReadDot INTEGER, adInfo TEXT, xml TEXT, dataType INTEGER, msgSource TEXT, exposedDuration INTEGER, exposedAreaMaxRadio INTEGER, reddotReportInfo TEXT);
CREATE INDEX bizMsgExtbiz_hasReadDot_index ON bizMsgExt(hasReadDot);
CREATE INDEX bizMsgExtbiz_svrTime_index ON bizMsgExt(svrTime);
CREATE INDEX bizMsgExtbiz_userName_svrID_index ON bizMsgExt(userName, svrId);
CREATE TABLE bizMsgTemp(localId INTEGER PRIMARY KEY, userName TEXT, svrId INTEGER, svrTime INTEGER, content BLOB, msgStatus INTEGER, type INTEGER, isExpand INTEGER, isBigPic INTEGER, hasReadDot INTEGER, adInfo TEXT, xml TEXT, dataType INTEGER, msgSource TEXT, exposedDuration INTEGER, exposedAreaMaxRadio INTEGER, reddotReportInfo TEXT);
CREATE INDEX bizMsgTempbiz_hasReadDot_index ON bizMsgTemp(hasReadDot);
CREATE INDEX bizMsgTempbiz_svrTime_index ON bizMsgTemp(svrTime);
CREATE INDEX bizMsgTempbiz_userName_svrID_index ON bizMsgTemp(userName, svrId);
CREATE TABLE bizRecExposeInfo(exposeId TEXT PRIMARY KEY, msgId INTEGER, exposeTime INTEGER, exposeType INTEGER);
CREATE INDEX bizRecExposeInfobiz_rec_exposeTime_index ON bizRecExposeInfo(exposeTime);
CREATE TABLE bizNotifyMsg(localId INTEGER PRIMARY KEY, msgId INTEGER, userName TEXT, svrId INTEGER, createTime INTEGER, content BLOB, msgStatus INTEGER, type INTEGER, msgSource BLOB, dataType INTEGER, localMsgType INTEGER, notifyMsgBlockFlag INTEGER, silentFoldMsgReadStatus INTEGER, mpArticleKey TEXT);