ins_sqlserver.sql

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

CREATE INDEX PK_WAPMO_STAPLE_LOG_INDEX ON WAPMO_STAPLE_LOG(STAPLEID,HIT,INTIME)
CREATE INDEX PK_WAPMO_TRACK_LOG_INDEX ON WAPMO_TRACK_LOG(USERID,CATEGORY,TRACKID,INTIME)
CREATE INDEX PK_WAPMO_TRADE_INDEX ON WAPMO_TRADE(MOBILE,STAPLEID,CONTENTID,USERID,INTIME)
CREATE INDEX PK_WAPMO_USER_INDEX ON WAPMO_USER(MOBILE,USERNAME,STATUS,REGTIME,LASTVISITTIME)
CREATE INDEX PK_WAPMO_USER_AGENT_INDEX ON WAPMO_USER_AGENT(MOBILEFACE)
CREATE INDEX PK_WAPMO_USER_LOG_INDEX ON WAPMO_USER_LOG(USERID,SHIT,CHIT,VHIT,DHIT,INTIME)
CREATE INDEX PK_WAPMO_WAP_LOG_INDEX ON WAPMO_WAP_LOG(USERID,HIT,INTIME)
CREATE INDEX PK_WAPMO_UA_INDEX ON WAPMO_UA(NAME,MARK)

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_FORUM' AND XTYPE='U') DROP TABLE WM_FORUM
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_TOPIC' AND XTYPE='U') DROP TABLE WM_TOPIC
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_UNIONBBS' AND XTYPE='U') DROP TABLE WM_UNIONBBS
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_ONLINE' AND XTYPE='U') DROP TABLE WM_ONLINE
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_INBOX' AND XTYPE='U') DROP TABLE WM_INBOX
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_OUTBOX' AND XTYPE='U') DROP TABLE WM_OUTBOX
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_GROUP' AND XTYPE='U') DROP TABLE WM_GROUP
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_BULLETIN' AND XTYPE='U') DROP TABLE WM_BULLETIN
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_UPLOAD' AND XTYPE='U') DROP TABLE WM_UPLOAD
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_DOWNLOAD' AND XTYPE='U') DROP TABLE WM_DOWNLOAD
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_FAV' AND XTYPE='U') DROP TABLE WM_FAV
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_RETAKE' AND XTYPE='U') DROP TABLE WM_RETAKE
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='WM_LOG' AND XTYPE='U') DROP TABLE WM_LOG
CREATE TABLE WM_FORUM (SEQID INT IDENTITY(1,1) NOT NULL,NAME NVARCHAR(50) NOT NULL,INTRO NVARCHAR(255) NULL,FOLLOW INT NOT NULL,INTIME INT NOT NULL,SERIAL INT NULL,ARTTOTAL INT NULL,LASTPOSTID INT NULL,LASTPOSTTITLE NVARCHAR(255) NULL,LASTPOSTUSERID INT NULL,LASTPOSTUSERNAME NVARCHAR(20) NULL,LASTPOSTTIME INT NULL,MASTER NVARCHAR(255) NULL,TOPICS INT NOT NULL DEFAULT 0,REPLIES INT NOT NULL DEFAULT 0,TODAYPOSTS INT NOT NULL DEFAULT 0,ALLOW NVARCHAR (255) NULL,MARK NVARCHAR (255) NULL,PRIMARY KEY(SEQID))
CREATE TABLE WM_TOPIC (SEQID INT IDENTITY(1,1) NOT NULL,USERNAME NVARCHAR(32) NOT NULL,USERID INT NOT NULL,TITLE NVARCHAR(255) NOT NULL,CONTENT TEXT NULL,FORUMID INT NOT NULL,FORUMNAME NVARCHAR(50),HITS INT NOT NULL DEFAULT 0,FOLLOW INT NOT NULL,REPLIES INT NOT NULL DEFAULT 0,POSTTIME INT NOT NULL,POSTIP NVARCHAR(15) NULL,LASTPOSTTIME INT NULL,FACE INT NULL,TOPICTYPE INT NULL,TOPTYPE INT NULL,STATE INT NULL,REASON NVARCHAR(255) NULL,LASTPOSTID INT NULL,LASTPOSTTITLE NVARCHAR(255) NULL,LASTPOSTUSERID INT NULL,LASTPOSTUSERNAME NVARCHAR(20) NULL,EDITTIME INT NULL,EDITUSERID INT NULL,EDITUSERNAME NVARCHAR(20) NULL,SERIAL INT NULL,MARK NVARCHAR(255) NULL,SOURCE INT NULL,LOCKED INT NULL,OMITED INT NULL,SOULED INT NULL,SHIELD INT NULL,ASSESS NVARCHAR(255) NULL,PRIMARY KEY(SEQID))
CREATE TABLE WM_UNIONBBS (SEQID INT IDENTITY(1,1) NOT NULL, ID INT NOT NULL, NAME NVARCHAR(50) NOT NULL, ADDR NVARCHAR(255) NOT NULL, LOGO NVARCHAR(255) NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_ONLINE (SEQID INT IDENTITY(1,1) NOT NULL, USERNAME NVARCHAR(20) NULL, FORUMID INT NOT NULL DEFAULT 0, STATE NVARCHAR(255) NOT NULL, IPADDR NVARCHAR(15) NOT NULL, ONLINE INT NOT NULL, STARTTIME INT NOT NULL, LASTTIME INT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_INBOX (SEQID INT IDENTITY(1,1) NOT NULL, SENDER NVARCHAR(20) NOT NULL, SENDTO NVARCHAR(20) NOT NULL, TITLE NVARCHAR(255) NOT NULL, CONTENT TEXT NOT NULL, FLAG INT NOT NULL DEFAULT 0, SENDTIME INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_OUTBOX (SEQID INT IDENTITY(1,1) NOT NULL, SENDER NVARCHAR(20) NOT NULL, SENDTO NVARCHAR(20) NOT NULL, TITLE NVARCHAR(255) NOT NULL, CONTENT TEXT NOT NULL, SENDTIME INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_GROUP (SEQID INT IDENTITY(1,1) NOT NULL, NAME NVARCHAR(20) NOT NULL, PERMIT TEXT NOT NULL, MINPOSTS INT NOT NULL, GROUPIMG NVARCHAR(20) NOT NULL, USERCOUNT INT NOT NULL, FLAG INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_BULLETIN (SEQID INT IDENTITY(1,1) NOT NULL, TITLE NVARCHAR(255) NOT NULL, CONTENT TEXT NOT NULL, FORUMID INT NOT NULL, FORUMNAME NVARCHAR(50) NOT NULL, POSTUSERNAME NVARCHAR(20) NOT NULL, POSTTIME INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_UPLOAD(SEQID INT IDENTITY(1,1) NOT NULL, USERID INT NOT NULL, USERNAME NVARCHAR(20) NOT NULL, FORUMID INT NOT NULL, FORUMNAME NVARCHAR(50) NOT NULL, TOPICID INT NOT NULL, TOPICTITLE NVARCHAR(255) NOT NULL, UPNAME NVARCHAR(255) NOT NULL, UPPATH NVARCHAR(255) NOT NULL, UPSIZE INT NOT NULL, UPEXT NVARCHAR(10) NOT NULL, UPTYPE INT NOT NULL, WIDTH INT NULL, HEIGHT INT NULL, CENT INT NOT NULL, COIN INT NOT NULL, INTRO VARCHAR(255) NULL, DOWNLOADS INT NOT NULL DEFAULT 0, UPTIME INT NOT NULL, SOURCE INT NULL, PRIMARY KEY (SEQID))
CREATE TABLE WM_DOWNLOAD (SEQID INT IDENTITY(1,1) NOT NULL, FILEID INT NOT NULL, USERID INT NOT NULL, BUYTIME INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_FAV (SEQID INT IDENTITY(1,1) NOT NULL, USERID INT NOT NULL, USERNAME NVARCHAR(20) NOT NULL, FORUMID INT NOT NULL, TOPICID INT NOT NULL, TOPICTITLE NVARCHAR(255) NOT NULL, ADDTIME INT NOT NULL, PRIMARY KEY(SEQID))
CREATE TABLE WM_RETAKE (INIP NVARCHAR(15) NOT NULL,FAILED INT NOT NULL,TOTAL INT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY(INIP))
CREATE TABLE WM_LOG (SEQID INT IDENTITY(1,1) NOT NULL, USERNAME NVARCHAR(20) NOT NULL, LOG NTEXT NOT NULL, CENT INT NOT NULL, COIN INT NOT NULL, WITCHERY INT NOT NULL, INTIME INT NOT NULL, INIP NVARCHAR(15) NOT NULL, PRIMARY KEY(SEQID))
CREATE INDEX PK_WM_FORUM_INDEX ON WM_FORUM(FOLLOW)
CREATE INDEX PK_WM_TOPIC_INDEX ON WM_TOPIC(FORUMID,FOLLOW,POSTTIME,LASTPOSTTIME)
CREATE INDEX PK_WM_ONLINE_INDEX ON WM_ONLINE (USERNAME,IPADDR,FORUMID,ONLINE,LASTTIME)
CREATE INDEX PK_WM_INBOX_INDEX ON WM_INBOX (SENDTO)
CREATE INDEX PK_WM_OUTBOX_INDEX ON WM_OUTBOX (SENDER)
CREATE INDEX PK_WM_FAV_INDEX ON WM_FAV (USERID)
CREATE INDEX PK_WM_UPLOAD_INDEX ON WM_UPLOAD (USERID, UPTYPE)
CREATE INDEX PK_WM_DOWNLOAD_INDEX ON WM_DOWNLOAD (FILEID, USERID)
CREATE INDEX PK_WM_LOG_INDEX ON WM_LOG (USERNAME, INIP)

INSERT INTO WM_UNIONBBS (ID,NAME,ADDR,LOGO) VALUES (0, 'WAPmo', 'http://wapmo.cn', '')
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('管理员','1|1|1|1|1|1|1|0|1|1|1|1|10|100|1024|1|1|1|1|1|1|1|1|1|1|0|1|1|1|1|1|1|1|1|1|1|1|5|1024|100|100|20|1|1|1|1|1',-1,'20.gif',0,1)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('超级版主','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|1|1|1|1|1|0|1|1|1|0|1|1|1|1|1|1|0|1|1|1|1|5|1024|100|100|20|1|1|1|1|0',-1,'19.gif',0,1)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('版主','1|1|1|1|1|1|0|100|1|1|1|1|5|10|500|1|1|1|1|1|0|0|1|1|1|0|1|1|1|0|0|0|0|1|1|0|1|5|1024|100|100|20|1|1|1|1|0',-1,'18.gif',0,1)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('等待验证','1|1|0|1|0|0|0|100|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0',-1,'0.gif',0,1)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('游客','1|1|1|1|0|0|0|100|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|1|0|1|0',-1,'0.gif',0,1)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('新手上路','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',0,'0.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('论坛游民','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',100,'1.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('论坛游侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',200,'2.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('业余侠客','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',300,'3.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('职业侠客','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',400,'4.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('侠之大者','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',500,'5.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('黑侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',600,'6.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('蝙蝠侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',800,'7.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('蜘蛛侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',1000,'8.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('青蜂侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',1200,'9.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('小飞侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',1500,'10.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('火箭侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',1800,'11.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('蒙面侠','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',2100,'12.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('城市猎人','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',2500,'13.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('罗宾汉','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',3000,'14.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('阿诺','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|5|1024|100|100|20|1|1|1|1|0',3500,'15.gif',0,0)
INSERT INTO WM_GROUP (NAME,PERMIT,MINPOSTS,GROUPIMG,USERCOUNT,FLAG) VALUES ('侠圣','1|1|1|1|1|1|0|100|1|1|0|1|5|10|500|1|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|1|10|1024|100|100|50|1|1|1|1|0',4000,'16.gif',0,0)