3_20081220.sql

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

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))
ALTER TABLE WAPMO_STAPLE ADD CATE INT NULL
UPDATE WAPMO_STAPLE SET GROUPID=0 WHERE GROUPID IS NULL
UPDATE WAPMO_STAPLE SET TEAMID=0 WHERE TEAMID IS NULL
UPDATE WAPMO_STAPLE SET ADMINID=0 WHERE ADMINID IS NULL
UPDATE WAPMO_STAPLE SET CATE=0 WHERE CATE IS NULL
ALTER TABLE WAPMO_CONTENT ADD CATE INT NULL
UPDATE WAPMO_CONTENT SET CATE=0 WHERE CATE IS NULL
ALTER TABLE WAPMO_TRADE ADD TOTAL INT NULL
ALTER TABLE WAPMO_TRADE ADD REMARK VARCHAR(255) NULL
ALTER TABLE WAPMO_USER ADD CONTENTTOTAL INT NULL
UPDATE A SET A.CONTENTTOTAL=(SELECT COUNT(SEQID) FROM WAPMO_CONTENT WHERE USERID=A.USERID) FROM WAPMO_USER A
ALTER TABLE WAPMO_FORUM ADD ARTTOTAL INT NULL
UPDATE A SET A.ARTTOTAL=(SELECT COUNT(SEQID) FROM WAPMO_ARTICLE WHERE FORUMID=A.SEQID) FROM WAPMO_FORUM A
ALTER TABLE WAPMO_COOP CHANGE COLUMN [DOMAIN] HOST VARCHAR(255) NULL