ins_sqlserver.sql

WAPmo手机网站管理平台是一款创建与管理维护WAP网站的的软件产品

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_ADMIN_LOG' AND XTYPE='U') DROP TABLE WAPMO_ADMIN_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_IPDB' AND XTYPE='U') DROP TABLE WAPMO_IPDB
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_ADMIN' AND XTYPE='U') DROP TABLE WAPMO_ADMIN
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_ADMIN_GROUP' AND XTYPE='U') DROP TABLE WAPMO_ADMIN_GROUP
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_ADMIN_TEAM' AND XTYPE='U') DROP TABLE WAPMO_ADMIN_TEAM
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_ADS' AND XTYPE='U') DROP TABLE WAPMO_ADS
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_CONTENT' AND XTYPE='U') DROP TABLE WAPMO_CONTENT
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_CONTENT_LOG' AND XTYPE='U') DROP TABLE WAPMO_CONTENT_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_COOP' AND XTYPE='U') DROP TABLE WAPMO_COOP
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_COOP_ELEMENT' AND XTYPE='U') DROP TABLE WAPMO_COOP_ELEMENT
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_GUESTBOOK' AND XTYPE='U') DROP TABLE WAPMO_GUESTBOOK
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_MARKER' AND XTYPE='U') DROP TABLE WAPMO_MARKER
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_MATTER' AND XTYPE='U') DROP TABLE WAPMO_MATTER
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_MATTER_LOG' AND XTYPE='U') DROP TABLE WAPMO_MATTER_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_MISC_LOG' AND XTYPE='U') DROP TABLE WAPMO_MISC_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_MSGBOX' AND XTYPE='U') DROP TABLE WAPMO_MSGBOX
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_REMARK' AND XTYPE='U') DROP TABLE WAPMO_REMARK
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_STAPLE' AND XTYPE='U') DROP TABLE WAPMO_STAPLE
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_STAPLE_LOG' AND XTYPE='U') DROP TABLE WAPMO_STAPLE_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_TRACK_LOG' AND XTYPE='U') DROP TABLE WAPMO_TRACK_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_TRADE' AND XTYPE='U') DROP TABLE WAPMO_TRADE
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_USER' AND XTYPE='U') DROP TABLE WAPMO_USER
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_USER_AGENT' AND XTYPE='U') DROP TABLE WAPMO_USER_AGENT
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_USER_LOG' AND XTYPE='U') DROP TABLE WAPMO_USER_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_WAP_LOG' AND XTYPE='U') DROP TABLE WAPMO_WAP_LOG
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WAPMO_UA' AND XTYPE='U') DROP TABLE WAPMO_UA
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_CATEGORY' AND XTYPE='U') DROP TABLE WM_CATEGORY
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_MEMORY' AND XTYPE='U') DROP TABLE WM_MEMORY
CREATE TABLE WAPMO_ADMIN_LOG (SEQID INT IDENTITY(1,1) NOT NULL,ADMINID INT NOT NULL,ADMINNAME NVARCHAR (20) NOT NULL,CONTENT TEXT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_IPDB (SEQID INT IDENTITY(1,1) NOT NULL,IPADDR NVARCHAR (15) NOT NULL,HIT INT NOT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_ADMIN (SEQID INT IDENTITY(1,1) NOT NULL,NAME NVARCHAR (10) NOT NULL,PASSWD CHAR (32) NOT NULL,FORBID INT DEFAULT 0 NOT NULL,LOGINCOUNT INT DEFAULT 0 NOT NULL,GROUPID INT NOT NULL,TEAMID INT NULL,FOLLOW INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT DEFAULT 0 NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_ADMIN_GROUP (SEQID INT IDENTITY(1,1) NOT NULL,NAME VARCHAR(50) NOT NULL,INTRO VARCHAR(255) NULL,POWER NVARCHAR (255) NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_ADMIN_TEAM (SEQID INT IDENTITY(1,1) NOT NULL,GROUPID INT NOT NULL,NAME VARCHAR(50) NOT NULL,INTRO VARCHAR(255) NULL,PRIMARY KEY(SEQID))
CREATE TABLE WAPMO_ADS (SEQID INT IDENTITY(1,1) NOT NULL,CATEGORY INT NOT NULL,TITLE NVARCHAR (255) NULL,CONTENT TEXT NULL,LOOK INT NOT NULL,HIT INT NOT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_CONTENT (SEQID INT IDENTITY(1,1) NOT NULL,STAPLEID INT NOT NULL,STAPLETITLE NVARCHAR (50) NOT NULL,TITLE NVARCHAR (255) NOT NULL,PRICE NVARCHAR (50) NULL,CONTENT TEXT NULL,MATTER INT NOT NULL,PLACE INT NOT NULL,LENGTH INT NOT NULL,DOWNLOAD INT NOT NULL,HIT INT DEFAULT 0 NOT NULL,CATEGORY INT NOT NULL,COMMEND INT NOT NULL,HOT INT NOT NULL,HIDDEN INT DEFAULT 0 NOT NULL,TEMPLET NVARCHAR (50) NULL,ISWML INT DEFAULT 0 NOT NULL,REMARKTOTAL INT DEFAULT 0 NOT NULL,EXAMINE INT DEFAULT 0 NOT NULL,EXTIME INT DEFAULT 0 NOT NULL,USERID INT NULL,USERNAME NVARCHAR (32) NULL,MARK NVARCHAR (255) NOT NULL,PAGEMARK VARCHAR(255) NULL,GROUPID INT NOT NULL,TEAMID INT NOT NULL,ADMINID INT NOT NULL,CATE INT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_CONTENT_LOG (SEQID INT IDENTITY(1,1) NOT NULL,STAPLEID INT NOT NULL,STAPLETITLE VARCHAR(50) NOT NULL,CONTENTID INT NOT NULL,CONTENTTITLE NVARCHAR (255) NOT NULL,CONTENTTIME INT NOT NULL,HIT INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_COOP (COOPID INT IDENTITY(1,1) NOT NULL,USERID NVARCHAR (32) NOT NULL,PASSWD CHAR (32) NOT NULL,HOST NVARCHAR (32) NOT NULL,STAPLE TEXT NULL,STAPLEHIT INT DEFAULT 0 NOT NULL,CONTENTHIT INT DEFAULT 0 NOT NULL,IP NVARCHAR (16) NULL,EMAIL NVARCHAR (255) NULL,PHONE NVARCHAR (50) NULL,ISBBS INT NULL,ISBOOK INT NULL,ISQUERY INT NULL,QUERY VARCHAR(50) NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (COOPID))
CREATE TABLE WAPMO_COOP_ELEMENT (SEQID INT IDENTITY(1,1) NOT NULL,COOPID INT NOT NULL,STAPLEID INT NOT NULL,CATEGORY INT NOT NULL,TITLE NVARCHAR (50) NULL,CONTENT NVARCHAR (255) NULL,INTIME INT NOT NULL,SERIAL INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_GUESTBOOK (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,USERNAME NVARCHAR (20) NOT NULL,CONTENT TEXT NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,IPADDR NVARCHAR (16) NULL,FOLLOW INT NULL,REPLY INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_MARKER (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,USERNAME NVARCHAR (32) NOT NULL,TITLE NVARCHAR (255) NOT NULL,CONTENT NVARCHAR (255) NOT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_MATTER (SEQID INT IDENTITY(1,1) NOT NULL,CATEGORY INT NOT NULL,EXT NVARCHAR (10) NOT NULL,TITLE NVARCHAR (50) NOT NULL,CONTENT NVARCHAR (255) NULL,SOURCE NVARCHAR (255) NOT NULL,MARK INT NOT NULL,HIT INT NOT NULL,DOWNLOAD INT NOT NULL,MD5 CHAR (32) NULL,INTIME INT NULL,HIDDEN INT NULL,PREVIEW NVARCHAR (10) NULL,WIDTH INT NULL,HEIGHT INT NULL,USERID INT NULL,USERNAME NVARCHAR (32) NULL,GROUPID INT NOT NULL,TEAMID INT NOT NULL,ADMINID INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_MATTER_LOG (SEQID INT IDENTITY(1,1) NOT NULL,MATTERID INT NOT NULL,TITLE NVARCHAR (255) NOT NULL,HIT INT DEFAULT 0 NOT NULL,DOWNLOAD INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_MISC_LOG (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,MATTERID INT NOT NULL,TITLE NVARCHAR (255) NOT NULL,SERVICEID CHAR (8) NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_MSGBOX (SEQID INT IDENTITY(1,1) NOT NULL,SENDER INT NOT NULL,SENDERNAME NVARCHAR (32) NULL,SENDTO INT NOT NULL,SENDTONAME NVARCHAR (32) NULL,TITLE NVARCHAR (100) NOT NULL,CONTENT TEXT NOT NULL,STATUS INT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_REMARK (SEQID INT IDENTITY(1,1) NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,TITLE NVARCHAR (255) NOT NULL,CONTENT NVARCHAR (255) NOT NULL,USERID INT NOT NULL,USERNAME NVARCHAR (32) NOT NULL,IPADDR NVARCHAR (16) NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_STAPLE (SEQID INT IDENTITY(1,1) NOT NULL,TITLE NVARCHAR (50) NOT NULL,CONTENT NVARCHAR (255) NULL,LIST INT NULL,STAPLEALIGN INT NOT NULL,STAPLESORT INT NOT NULL,STAPLEPAGE INT NULL,CONTENTALIGN INT NOT NULL,CONTENTSORT INT NOT NULL,CONTENTPAGE INT NOT NULL,CONTENTCOUNT INT NOT NULL,CONTENTTOTAL INT DEFAULT 0 NOT NULL,CONTENTTEMPLET NVARCHAR (50) NULL,TRADE INT NOT NULL,REMARK INT NOT NULL,FOLLOW INT NOT NULL,FOLLOWNAME VARCHAR(50) NULL,HIT INT DEFAULT 0 NOT NULL,MAPPING INT NULL,CATEGORY INT NOT NULL,USERSTATUS INT NOT NULL,LOGO NVARCHAR (10) NULL,SERIAL INT DEFAULT 0 NOT NULL,ICON NVARCHAR (10) NULL,TEMPLET NVARCHAR (50) NULL, HIDDEN INT NULL,REMARKTYPE INT NULL,COOP INT NULL,BACKCOLOR NVARCHAR (20) NULL,BACKIMAGE NVARCHAR (10) NULL,BACKSOUND NVARCHAR (10) NULL,STAPLECOUNT INT NULL,ISMISC INT NULL,MISC_VISIT NVARCHAR (255) NULL,MISC_FEE NVARCHAR (255) NULL,MISC_DEAL NVARCHAR (255) NULL,MISC_TEST NVARCHAR (255) NULL,MISC_TYPE INT NULL,MISC_CODE CHAR (8) NULL,MISC_BACKNAME NVARCHAR (50) NULL,MISC_BACKADDR NVARCHAR (255) NULL,MISC_CONFIRM INT NULL,USERCENT INT NULL,PUBLISH INT NULL,EXAMINE INT NULL,TODAYTOTAL INT NULL,TODAYTIME INT NULL,MARK NVARCHAR (255) NULL,ISUBB INT NULL,GROUPID INT NOT NULL,TEAMID INT NOT NULL,ADMINID INT NOT NULL,CATE INT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_STAPLE_LOG (SEQID INT IDENTITY(1,1) NOT NULL,STAPLEID INT NOT NULL,TITLE NVARCHAR (255) NOT NULL,HIT INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_TRACK_LOG (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,CATEGORY INT NOT NULL,TRACKID INT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_TRADE (SEQID INT IDENTITY(1,1) NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,TITLE NVARCHAR (255) NOT NULL,USERID INT NOT NULL,NAME NVARCHAR (50) NOT NULL,PHONE NVARCHAR (50) NOT NULL,MOBILE NVARCHAR (32) NOT NULL,ADDRESS NVARCHAR (255) NULL,ZIPCODE NVARCHAR (10) NULL,TOTAL INT NULL,REMARK NVARCHAR(255) NULL,STATUS INT NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_USER (SEQID INT IDENTITY(1,1) NOT NULL,USERNAME NVARCHAR(20) NULL,PASSWD CHAR(32) NULL,REGTIME INT NULL,REGIP NVARCHAR(16) NULL,LASTVISITTIME INT NULL,LASTVISITIP NVARCHAR(16) NULL,VISITCOUNT INT NOT NULL DEFAULT 0,PAGECOUNT INT NOT NULL DEFAULT 0,LASTPAGE NVARCHAR(255) NULL,FIRSTSEARCHTIME INT NULL,FIRSTSEARCHWORD NVARCHAR(255) NULL,LASTSEARCHTIME INT NULL,LASTSEARCHWORD NVARCHAR(255) NULL,SEARCHCOUNT INT NOT NULL DEFAULT 0,FIRSTUSERAGENT NVARCHAR(255) NULL,LASTUSERAGENT NVARCHAR(255) NULL,MISC_ACTIONID INT NULL,MISC_SERVICEID CHAR(8) NULL,MISC_MID char (14) NULL,MISC_DOWNLOAD INT NULL,MISC_INTIME INT NULL,MISC_OUTIME INT NULL,SEX INT NULL,QUESTION NVARCHAR(255) NULL,ANSWER NVARCHAR(255) NULL,EMAIL NVARCHAR(255) NULL,QQ NVARCHAR(32) NULL,MSN NVARCHAR(255) NULL,PHONE NVARCHAR(32) NULL,ADDRESS NVARCHAR(255) NULL,PROVINCE NVARCHAR(50) NULL,CITY NVARCHAR(50) NULL,BIRTHDAY NVARCHAR(10) NULL,VOCATION INT NULL,MARRY INT NULL,INTRO text NULL,LASTLOGIN INT NULL,MARKERTOTAL INT NULL,LASTREMARK INT NULL,REMARKTOTAL INT NULL,LASTBOOK INT NULL,BOOKTOTAL INT NULL,LASTART INT NULL,ARTTOTAL INT NULL,LASTTRADE INT NULL,TRADETOTAL INT NULL,MSGSEND INT NULL,MSGRECV INT NULL,MSGNEW INT NULL,CONTENTTOTAL INT NULL,LOGINCOUNT INT NULL,COIN INT NULL,CENT INT NULL,WITCHERY INT NULL,TOPICS INT NULL,REPLIES INT NULL,SOULS INT NULL,DELETES INT NULL,HOMEPAGE NVARCHAR(255) NULL,LOCATION NVARCHAR(255) NULL,SIGNATURE NVARCHAR(255) NULL,REPLYHINT char (1) NULL,GROUPID INT NULL,GROUPNAME NVARCHAR(50) NULL,GROUPIMG NVARCHAR(10) NULL,LASTLOGINTIME INT NULL,LASTLOGINIP NVARCHAR(15) NULL,STATE INT NULL,ONLINE INT NULL,FACE INT NULL,LASTPOSTTIME INT NULL,TODAYPOSTS INT NULL,FAVS INT NOT NULL DEFAULT 0,IMAGES INT NOT NULL DEFAULT 0,RINGS INT NOT NULL DEFAULT 0,VIDEOS INT NOT NULL DEFAULT 0,SOFTS INT NOT NULL DEFAULT 0,UPLOADS INT NOT NULL DEFAULT 0,LASTUPLOAD INT NULL,SOURCE INT NULL,REALNAME NVARCHAR(20) NULL,MOBILE NVARCHAR(21) NULL,STATUS INT NOT NULL DEFAULT 9999,PRIMARY KEY(SEQID))
CREATE TABLE WAPMO_USER_AGENT (SEQID INT IDENTITY(1,1) NOT NULL,MOBILETYPE NVARCHAR (50) NOT NULL,MOBILEFACE NVARCHAR (50) NOT NULL,IMAGESUPPORT INT NULL,IMAGEWIDTH INT DEFAULT 0 NOT NULL,IMAGEHEIGHT INT DEFAULT 0 NOT NULL,RINGSUPPORT INT NULL,VIDEOSUPPORT INT NULL,SOFTSUPPORT INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_USER_LOG (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,SHIT INT DEFAULT 0 NOT NULL,CHIT INT DEFAULT 0 NOT NULL,VHIT INT DEFAULT 0 NOT NULL,DHIT INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_WAP_LOG (SEQID INT IDENTITY(1,1) NOT NULL,USERID INT NOT NULL,STATUS INT NOT NULL,HIT INT DEFAULT 0 NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID))
CREATE TABLE WAPMO_UA(SEQID INT IDENTITY(1,1) NOT NULL,NAME VARCHAR(255) NOT NULL,MARK VARCHAR(50) NOT NULL,WIDTH INT NOT NULL,HEIGHT INT NOT NULL,PRIMARY KEY(SEQID))
CREATE TABLE WM_CATEGORY(SEQID INT IDENTITY(1,1) NOT NULL,TITLE VARCHAR(50) NOT NULL,FOLLOW INT NOT NULL,SERIAL INT NOT NULL,C_COUNT INT NULL,C_SPACE VARCHAR(10) NULL,INTIME INT NOT NULL,PRIMARY KEY(SEQID))
CREATE TABLE WM_MEMORY (MEMID CHAR(32) NOT NULL,MEMORY TEXT NULL,EXPIRES INT NOT NULL,TIMEOUT INT NOT NULL,INIP NVARCHAR(15) NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY(MEMID))
CREATE INDEX PK_WAPMO_ADMIN_LOG_INDEX ON WAPMO_ADMIN_LOG(ADMINID,INTIME)
CREATE INDEX PK_WAPMO_IPDB_INDEX ON WAPMO_IPDB(IPADDR,HIT,INTIME,OUTIME)
CREATE INDEX PK_WAPMO_CONTENT_INDEX ON WAPMO_CONTENT(STAPLEID,TITLE,HIT,HOT,COMMEND,MARK,HIDDEN,EXAMINE,INTIME,USERID)
CREATE INDEX PK_WAPMO_CONTENT_LOG_INDEX ON WAPMO_CONTENT_LOG(STAPLEID,CONTENTID,HIT,INTIME)
CREATE INDEX PK_WAPMO_COOP_ELEMENT_INDEX ON WAPMO_COOP_ELEMENT(COOPID,STAPLEID)
CREATE INDEX PK_WAPMO_GUESTBOOK_INDEX ON WAPMO_GUESTBOOK(USERID,FOLLOW,INTIME,OUTIME)
CREATE INDEX PK_WAPMO_MARKER_INDEX ON WAPMO_MARKER(USERID)
CREATE INDEX PK_WAPMO_MATTER_INDEX ON WAPMO_MATTER(TITLE,MARK,INTIME,USERID)
CREATE INDEX PK_WAPMO_MATTER_LOG_INDEX ON WAPMO_MATTER_LOG(MATTERID,HIT,INTIME)
CREATE INDEX PK_WAPMO_MISC_LOG_INDEX ON WAPMO_MISC_LOG(USERID,STAPLEID,CONTENTID,MATTERID,SERVICEID,INTIME)
CREATE INDEX PK_WAPMO_MSGBOX_INDEX ON WAPMO_MSGBOX(SENDER,SENDTO)
CREATE INDEX PK_WAPMO_REMARK_INDEX ON WAPMO_REMARK(USERID,STAPLEID,CONTENTID,INTIME)
CREATE INDEX PK_WAPMO_STAPLE_INDEX ON WAPMO_STAPLE(HIT,FOLLOW,MARK,HIDDEN,INTIME)