0_20090115.sql

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

DROP TABLE WM_GROUP
DROP TABLE WM_UNIONBBS
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_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)