ins_mysql.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);

DROP TABLE IF EXISTS WM_FORUM;
DROP TABLE IF EXISTS WM_TOPIC;
DROP TABLE IF EXISTS WM_UNIONBBS;
DROP TABLE IF EXISTS WM_ONLINE;
DROP TABLE IF EXISTS WM_INBOX;
DROP TABLE IF EXISTS WM_OUTBOX;
DROP TABLE IF EXISTS WM_GROUP;
DROP TABLE IF EXISTS WM_BULLETIN;
DROP TABLE IF EXISTS WM_UPLOAD;
DROP TABLE IF EXISTS WM_DOWNLOAD;
DROP TABLE IF EXISTS WM_FAV;
DROP TABLE IF EXISTS WM_RETAKE;
DROP TABLE IF EXISTS WM_LOG;
CREATE TABLE WM_FORUM (SEQID INT AUTO_INCREMENT NOT NULL,NAME VARCHAR(50) NOT NULL,INTRO VARCHAR(255) NULL,FOLLOW INT NOT NULL,INTIME INT NOT NULL,SERIAL INT NULL,ARTTOTAL INT NULL,LASTPOSTID INT NULL,LASTPOSTTITLE VARCHAR(255) NULL,LASTPOSTUSERID INT NULL,LASTPOSTUSERNAME VARCHAR(20) NULL,LASTPOSTTIME INT NULL,MASTER VARCHAR(255) NULL,TOPICS INT NOT NULL DEFAULT 0,REPLIES INT NOT NULL DEFAULT 0,TODAYPOSTS INT NOT NULL DEFAULT 0,ALLOW VARCHAR(255) NULL,MARK VARCHAR(255) NULL,PRIMARY KEY(SEQID));
CREATE TABLE WM_TOPIC (SEQID INT AUTO_INCREMENT NOT NULL,USERNAME VARCHAR(32) NOT NULL,USERID INT NOT NULL,TITLE VARCHAR(255) NOT NULL,CONTENT LONGTEXT NULL,FORUMID INT NOT NULL,FORUMNAME VARCHAR(50),HITS INT NOT NULL DEFAULT 0,FOLLOW INT NOT NULL,REPLIES INT NOT NULL DEFAULT 0,POSTTIME INT NOT NULL,POSTIP VARCHAR(15) NULL,LASTPOSTTIME INT NULL,FACE INT NULL,TOPICTYPE INT NULL,TOPTYPE INT NULL,STATE INT NULL,REASON VARCHAR(255) NULL,LASTPOSTID INT NULL,LASTPOSTTITLE VARCHAR(255) NULL,LASTPOSTUSERID INT NULL,LASTPOSTUSERNAME VARCHAR(20) NULL,EDITTIME INT NULL,EDITUSERID INT NULL,EDITUSERNAME VARCHAR(20) NULL,SERIAL INT NULL,MARK VARCHAR(255) NULL,SOURCE INT NULL,LOCKED INT NULL,OMITED INT NULL,SOULED INT NULL,SHIELD INT NULL,ASSESS VARCHAR(255) NULL,PRIMARY KEY(SEQID));
CREATE TABLE WM_UNIONBBS (SEQID INT AUTO_INCREMENT NOT NULL, ID INT NOT NULL, NAME VARCHAR(50) NOT NULL, ADDR VARCHAR(255) NOT NULL, LOGO VARCHAR(255) NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_ONLINE (SEQID INT AUTO_INCREMENT NOT NULL, USERNAME VARCHAR(20) NULL, FORUMID INT NOT NULL DEFAULT 0, STATE VARCHAR(255) NOT NULL, IPADDR VARCHAR(15) NOT NULL, ONLINE INT NOT NULL, STARTTIME INT NOT NULL, LASTTIME INT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_INBOX (SEQID INT AUTO_INCREMENT NOT NULL, SENDER VARCHAR(20) NOT NULL, SENDTO VARCHAR(20) NOT NULL, TITLE VARCHAR(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 AUTO_INCREMENT NOT NULL, SENDER VARCHAR(20) NOT NULL, SENDTO VARCHAR(20) NOT NULL, TITLE VARCHAR(255) NOT NULL, CONTENT TEXT NOT NULL, SENDTIME INT NOT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_GROUP (SEQID INT AUTO_INCREMENT NOT NULL, NAME VARCHAR(20) NOT NULL, PERMIT TEXT NOT NULL, MINPOSTS INT NOT NULL, GROUPIMG VARCHAR(20) NOT NULL, USERCOUNT INT NOT NULL, FLAG INT NOT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_BULLETIN (SEQID INT AUTO_INCREMENT NOT NULL, TITLE VARCHAR(255) NOT NULL, CONTENT TEXT NOT NULL, FORUMID INT NOT NULL, FORUMNAME VARCHAR(50) NOT NULL, POSTUSERNAME VARCHAR(20) NOT NULL, POSTTIME INT NOT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_UPLOAD(SEQID INT AUTO_INCREMENT NOT NULL, USERID INT NOT NULL, USERNAME VARCHAR(20) NOT NULL, FORUMID INT NOT NULL, FORUMNAME VARCHAR(50) NOT NULL, TOPICID INT NOT NULL, TOPICTITLE VARCHAR(255) NOT NULL, UPNAME VARCHAR(255) NOT NULL, UPPATH VARCHAR(255) NOT NULL, UPSIZE INT NOT NULL, UPEXT VARCHAR(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 AUTO_INCREMENT NOT NULL, FILEID INT NOT NULL, USERID INT NOT NULL, BUYTIME INT NOT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_FAV (SEQID INT AUTO_INCREMENT NOT NULL, USERID INT NOT NULL, USERNAME VARCHAR(20) NOT NULL, FORUMID INT NOT NULL, TOPICID INT NOT NULL, TOPICTITLE VARCHAR(255) NOT NULL, ADDTIME INT NOT NULL, PRIMARY KEY(SEQID));
CREATE TABLE WM_RETAKE (INIP VARCHAR(15) NOT NULL,FAILED INT NOT NULL,TOTAL INT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY(INIP));
CREATE TABLE WM_LOG (SEQID INT AUTO_INCREMENT NOT NULL, USERNAME VARCHAR(20) NOT NULL, LOG TEXT NOT NULL, CENT INT NOT NULL, COIN INT NOT NULL, WITCHERY INT NOT NULL, INTIME INT NOT NULL, INIP VARCHAR(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);