ins_mysql.sql

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

DROP TABLE IF EXISTS WAPMO_ADMIN_LOG;
DROP TABLE IF EXISTS WAPMO_IPDB;
DROP TABLE IF EXISTS WAPMO_ADMIN;
DROP TABLE IF EXISTS WAPMO_ADMIN_GROUP;
DROP TABLE IF EXISTS WAPMO_ADMIN_TEAM;
DROP TABLE IF EXISTS WAPMO_ADS;
DROP TABLE IF EXISTS WAPMO_CONTENT;
DROP TABLE IF EXISTS WAPMO_CONTENT_LOG;
DROP TABLE IF EXISTS WAPMO_COOP;
DROP TABLE IF EXISTS WAPMO_COOP_ELEMENT;
DROP TABLE IF EXISTS WAPMO_GUESTBOOK;
DROP TABLE IF EXISTS WAPMO_MARKER;
DROP TABLE IF EXISTS WAPMO_MATTER;
DROP TABLE IF EXISTS WAPMO_MATTER_LOG;
DROP TABLE IF EXISTS WAPMO_MISC_LOG;
DROP TABLE IF EXISTS WAPMO_MSGBOX;
DROP TABLE IF EXISTS WAPMO_REMARK;
DROP TABLE IF EXISTS WAPMO_STAPLE;
DROP TABLE IF EXISTS WAPMO_STAPLE_LOG;
DROP TABLE IF EXISTS WAPMO_TRACK_LOG;
DROP TABLE IF EXISTS WAPMO_TRADE;
DROP TABLE IF EXISTS WAPMO_USER;
DROP TABLE IF EXISTS WAPMO_USER_AGENT;
DROP TABLE IF EXISTS WAPMO_USER_LOG;
DROP TABLE IF EXISTS WAPMO_WAP_LOG;
DROP TABLE IF EXISTS WAPMO_UA;
DROP TABLE IF EXISTS WM_CATEGORY;
DROP TABLE IF EXISTS WM_MEMORY;
CREATE TABLE WAPMO_ADMIN_LOG (SEQID INT AUTO_INCREMENT NOT NULL,ADMINID INT NOT NULL,ADMINNAME VARCHAR(20) NOT NULL,CONTENT TEXT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_IPDB (SEQID INT AUTO_INCREMENT NOT NULL,IPADDR VARCHAR(15) NOT NULL,HIT INT NOT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_ADMIN (SEQID INT AUTO_INCREMENT NOT NULL,NAME VARCHAR(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 AUTO_INCREMENT NOT NULL,NAME VARCHAR(50) NOT NULL,INTRO VARCHAR(255) NULL,POWER VARCHAR(255) NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_ADMIN_TEAM (SEQID INT AUTO_INCREMENT NOT NULL,GROUPID INT NOT NULL,NAME VARCHAR(50) NOT NULL,INTRO VARCHAR(255) NULL,PRIMARY KEY(SEQID));
CREATE TABLE WAPMO_ADS (SEQID INT AUTO_INCREMENT NOT NULL,CATEGORY INT NOT NULL,TITLE VARCHAR(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 AUTO_INCREMENT NOT NULL,STAPLEID INT NOT NULL,STAPLETITLE VARCHAR(50) NOT NULL,TITLE VARCHAR(255) NOT NULL,PRICE VARCHAR(50) NULL,CONTENT LONGTEXT 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 VARCHAR(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 VARCHAR(32) NULL,MARK VARCHAR(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 AUTO_INCREMENT NOT NULL,STAPLEID INT NOT NULL,STAPLETITLE VARCHAR(50) NOT NULL,CONTENTID INT NOT NULL,CONTENTTITLE VARCHAR(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 AUTO_INCREMENT NOT NULL,USERID VARCHAR(32) NOT NULL,PASSWD CHAR (32) NOT NULL,HOST VARCHAR(32) NOT NULL,STAPLE TEXT NULL,STAPLEHIT INT DEFAULT 0 NOT NULL,CONTENTHIT INT DEFAULT 0 NOT NULL,IP VARCHAR(16) NULL,EMAIL VARCHAR(255) NULL,PHONE VARCHAR(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 AUTO_INCREMENT NOT NULL,COOPID INT NOT NULL,STAPLEID INT NOT NULL,CATEGORY INT NOT NULL,TITLE VARCHAR(50) NULL,CONTENT VARCHAR(255) NULL,INTIME INT NOT NULL,SERIAL INT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_GUESTBOOK (SEQID INT AUTO_INCREMENT NOT NULL,USERID INT NOT NULL,USERNAME VARCHAR(20) NOT NULL,CONTENT TEXT NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,IPADDR VARCHAR(16) NULL,FOLLOW INT NULL,REPLY INT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_MARKER (SEQID INT AUTO_INCREMENT NOT NULL,USERID INT NOT NULL,USERNAME VARCHAR(32) NOT NULL,TITLE VARCHAR(255) NOT NULL,CONTENT VARCHAR(255) NOT NULL,INTIME INT NOT NULL,OUTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_MATTER (SEQID INT AUTO_INCREMENT NOT NULL,CATEGORY INT NOT NULL,EXT VARCHAR(10) NOT NULL,TITLE VARCHAR(50) NOT NULL,CONTENT VARCHAR(255) NULL,SOURCE VARCHAR(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 VARCHAR(10) NULL,WIDTH INT NULL,HEIGHT INT NULL,USERID INT NULL,USERNAME VARCHAR(32) NULL,GROUPID INT NOT NULL,TEAMID INT NOT NULL,ADMINID INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_MATTER_LOG (SEQID INT AUTO_INCREMENT NOT NULL,MATTERID INT NOT NULL,TITLE VARCHAR(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 AUTO_INCREMENT NOT NULL,USERID INT NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,MATTERID INT NOT NULL,TITLE VARCHAR(255) NOT NULL,SERVICEID CHAR (8) NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_MSGBOX (SEQID INT AUTO_INCREMENT NOT NULL,SENDER INT NOT NULL,SENDERNAME VARCHAR(32) NULL,SENDTO INT NOT NULL,SENDTONAME VARCHAR(32) NULL,TITLE VARCHAR(100) NOT NULL,CONTENT TEXT NOT NULL,STATUS INT NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_REMARK (SEQID INT AUTO_INCREMENT NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,TITLE VARCHAR(255) NOT NULL,CONTENT VARCHAR(255) NOT NULL,USERID INT NOT NULL,USERNAME VARCHAR(32) NOT NULL,IPADDR VARCHAR(16) NOT NULL,INTIME INT NOT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_STAPLE (SEQID INT AUTO_INCREMENT NOT NULL,TITLE VARCHAR(50) NOT NULL,CONTENT VARCHAR(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 VARCHAR(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 VARCHAR(10) NULL,SERIAL INT DEFAULT 0 NOT NULL,ICON VARCHAR(10) NULL,TEMPLET VARCHAR(50) NULL,HIDDEN INT NULL,REMARKTYPE INT NULL,COOP INT NULL,BACKCOLOR VARCHAR(20) NULL,BACKIMAGE VARCHAR(10) NULL,BACKSOUND VARCHAR(10) NULL,STAPLECOUNT INT NULL,ISMISC INT NULL,MISC_VISIT VARCHAR(255) NULL,MISC_FEE VARCHAR(255) NULL,MISC_DEAL VARCHAR(255) NULL,MISC_TEST VARCHAR(255) NULL,MISC_TYPE INT NULL,MISC_CODE CHAR (8) NULL,MISC_BACKNAME VARCHAR(50) NULL,MISC_BACKADDR VARCHAR(255) NULL,MISC_CONFIRM INT NULL,USERCENT INT NULL,PUBLISH INT NULL,EXAMINE INT NULL,TODAYTOTAL INT NULL,TODAYTIME INT NULL,MARK VARCHAR(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 AUTO_INCREMENT NOT NULL,STAPLEID INT NOT NULL,TITLE VARCHAR(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 AUTO_INCREMENT 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 AUTO_INCREMENT NOT NULL,STAPLEID INT NOT NULL,CONTENTID INT NOT NULL,TITLE VARCHAR(255) NOT NULL,USERID INT NOT NULL,NAME VARCHAR(50) NOT NULL,PHONE VARCHAR(50) NOT NULL,MOBILE VARCHAR(32) NOT NULL,ADDRESS VARCHAR(255) NULL,ZIPCODE VARCHAR(10) NULL,TOTAL INT NULL,REMARK VARCHAR(255) NULL,STATUS INT NOT NULL,INTIME INT NOT NULL,OUTIME INT NULL,PRIMARY KEY (SEQID));
CREATE TABLE WAPMO_USER (SEQID INT AUTO_INCREMENT NOT NULL,USERNAME VARCHAR(20) NULL,PASSWD CHAR(32) NULL,REGTIME INT NULL,REGIP VARCHAR(16) NULL,LASTVISITTIME INT NULL,LASTVISITIP VARCHAR(16) NULL,VISITCOUNT INT NOT NULL DEFAULT 0,PAGECOUNT INT NOT NULL DEFAULT 0,LASTPAGE VARCHAR(255) NULL,FIRSTSEARCHTIME INT NULL,FIRSTSEARCHWORD VARCHAR(255) NULL,LASTSEARCHTIME INT NULL,LASTSEARCHWORD VARCHAR(255) NULL,SEARCHCOUNT INT NOT NULL DEFAULT 0,FIRSTUSERAGENT VARCHAR(255) NULL,LASTUSERAGENT VARCHAR(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 VARCHAR(255) NULL,ANSWER VARCHAR(255) NULL,EMAIL VARCHAR(255) NULL,QQ VARCHAR(32) NULL,MSN VARCHAR(255) NULL,PHONE VARCHAR(32) NULL,ADDRESS VARCHAR(255) NULL,PROVINCE VARCHAR(50) NULL,CITY VARCHAR(50) NULL,BIRTHDAY VARCHAR(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 VARCHAR(255) NULL,LOCATION VARCHAR(255) NULL,SIGNATURE VARCHAR(255) NULL,REPLYHINT char (1) NULL,GROUPID INT NULL,GROUPNAME VARCHAR(50) NULL,GROUPIMG VARCHAR(10) NULL,LASTLOGINTIME INT NULL,LASTLOGINIP VARCHAR(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 VARCHAR(20) NULL,MOBILE VARCHAR(21) NULL,STATUS INT NOT NULL DEFAULT 9999,PRIMARY KEY(SEQID));
CREATE TABLE WAPMO_USER_AGENT (SEQID INT AUTO_INCREMENT NOT NULL,MOBILETYPE VARCHAR(50) NOT NULL,MOBILEFACE VARCHAR(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 AUTO_INCREMENT 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 AUTO_INCREMENT 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 AUTO_INCREMENT 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 AUTO_INCREMENT 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 VARCHAR(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);