SnsMicroMsg_schema.sql
4.62 KB
CREATE TABLE AdCanvasCacheInfo ( cacheKey TEXT PRIMARY KEY , canvasId LONG, canvasXml TEXT, createTime LONG, source INTEGER, uxInfo TEXT, dynamicInfo TEXT);
CREATE TABLE CanvasInfo ( canvasId LONG PRIMARY KEY , canvasXml TEXT, createTime LONG);
CREATE TABLE SnsWsFoldGroup ( top LONG, bottom LONG PRIMARY KEY , size INTEGER, state INTEGER);
CREATE TABLE snsTagInfo2 ( tagId LONG default '0' , tagName TEXT default '' , count INTEGER default '0' , memberList TEXT default '' );
CREATE TABLE SnsComment ( snsID LONG, parentID LONG, isRead SHORT default '0' , createTime INTEGER, talker TEXT, type INTEGER, isSend INTEGER default 'false' , curActionBuf BLOB, refActionBuf BLOB, commentSvrID LONG, clientId TEXT, commentflag INTEGER, isSilence INTEGER default '0' , springWishFlag INTEGER default '0' , msgRelevanceType INTEGER default '0' , isReminding INTEGER default '0' );
CREATE TABLE SnsMedia ( local_id INTEGER PRIMARY KEY, seqId LONG, type INT, createTime LONG, userName VARCHAR(40), totallen INT, offset INT, local_flag INT, tmp_path TEXT, nums INT, try_times INT, StrId VARCHAR(40), upload_buf TEXT, reserved1 INT, reserved2 TEXT, reserved3 TEXT, reserved4 TEXT, reserved5 TEXT );
CREATE INDEX serverSnsMediaTimeIndex ON SnsMedia ( createTime );
CREATE TABLE snsExtInfo3 ( userName TEXT default '' PRIMARY KEY , md5 TEXT, newerIds TEXT, bgId TEXT, bgUrl TEXT, older_bgId TEXT, local_flag INTEGER, istyle INTEGER, iFlag INTEGER, icount INTEGER, faultS BLOB, snsBgId LONG, snsuser BLOB, adsession BLOB, lastFirstPageRequestErrCode INTEGER, lastFirstPageRequestErrType INTEGER, snsYearMonthInfo BLOB, albumMd5 TEXT, imBGaeskey TEXT, imBGauthkey TEXT, imBGmd5sum TEXT, imBGfileid TEXT);
CREATE TABLE SnsReportKv ( logtime LONG, offset INTEGER default '0' , logsize INTEGER, errorcount INTEGER, value BLOB);
CREATE TABLE SnsInfo ( snsId LONG, userName TEXT, localFlag INTEGER, createTime INTEGER, head INTEGER, localPrivate INTEGER, type INTEGER, sourceType INTEGER, likeFlag INTEGER, pravited INTEGER, stringSeq TEXT, withTa TEXT, withTaHasOther INTEGER, content BLOB, attrBuf BLOB, postBuf BLOB, subType INTEGER, serverExtFlag INTEGER);
CREATE TABLE AdPullRecordsInfo ( traceid TEXT, aid TEXT, snsid TEXT, storeTime LONG, isAsync INTEGER default '0' , isSelected INTEGER default '1' , sessionKey TEXT, ext TEXT);
CREATE TABLE snsDraft ( key TEXT default '' PRIMARY KEY , timestamp LONG default '0' , extFlag INTEGER default '0' , draft BLOB);
CREATE TABLE SnsWsFoldGroupDetail ( groupId LONG PRIMARY KEY , groupTime INTEGER, groupStrcut BLOB);
CREATE TABLE adsnsinfo ( snsId LONG, userName TEXT, localFlag INTEGER, createTime INTEGER, head INTEGER, localPrivate INTEGER, type INTEGER, sourceType INTEGER, likeFlag INTEGER, pravited INTEGER, stringSeq TEXT, content BLOB, attrBuf BLOB, postBuf BLOB, adinfo TEXT, adxml TEXT, createAdTime INTEGER, exposureTime INTEGER, firstControlTime INTEGER, recxml TEXT, subType INTEGER, exposureCount INTEGER, atAdinfo TEXT, remindInfoGroup BLOB);
CREATE TABLE SnsCover ( userName TEXT default '' PRIMARY KEY , type INTEGER, snsBgId LONG, thumbUrl TEXT, imageBgUrl TEXT, videoBgUrl TEXT, localThumb TEXT, localImage TEXT, localVideo TEXT, cacheVideo TEXT, finderObject BLOB, finderCheckTime LONG, success INTEGER default 'false' , isLike INTEGER default 'false' , size LONG, snsCoverOffset INTEGER);
CREATE TABLE UxCanvasInfo ( canvasId TEXT PRIMARY KEY , canvasXml TEXT, createTime LONG, canvasExt TEXT);
CREATE TABLE AdDynamicCanvasInfo ( key TEXT PRIMARY KEY , pageId TEXT, createdTime LONG, dynamicInfo TEXT, dynamicCanvas TEXT, onetimeCanvas TEXT, extra TEXT, extra1 TEXT, extra2 TEXT);
CREATE INDEX serverSnsNameIndex ON SnsInfo ( snsId );
CREATE INDEX serverSnsTimeHeadIndex ON SnsInfo ( head );
CREATE INDEX snsMultiIndex1 ON SnsInfo ( createTime,snsId,sourceType,type);
CREATE INDEX snsMultiIndex2 ON SnsInfo ( sourceType,type,userName);
CREATE INDEX snsMultiIndex3 ON SnsInfo ( userName,sourceType);
CREATE INDEX snsLocalflagIndex ON SnsInfo ( localFlag );
CREATE INDEX SnsComment_snsID_index ON SnsComment(snsID);
CREATE INDEX SnsComment_parentID_index ON SnsComment(parentID);
CREATE INDEX SnsComment_isRead_index ON SnsComment(isRead);
CREATE INDEX SnsComment_isSend_index ON SnsComment(isSend);
CREATE INDEX serverAdSnsNameIndex ON AdSnsInfo ( snsId );
CREATE INDEX serverAdSnsTimeHeadIndex ON AdSnsInfo ( head );
CREATE INDEX adsnsMultiIndex1 ON AdSnsInfo ( createTime,snsId,sourceType,type);
CREATE INDEX adsnsMultiIndex2 ON AdSnsInfo ( sourceType,type,userName);
CREATE INDEX snsreport_kv_logtime ON SnsReportKv(logtime);