0_20081220.sql

来自「WAPmo手机网站管理平台是一款创建与管理维护WAP网站的的软件产品」· SQL 代码 · 共 15 行

CREATE TABLE WM_MEMORY (MEMID CHAR(32) NOT NULL,MEMORY TEXT NULL,EXPIRES INT NOT NULL,TIMEOUT INT NOT NULL,INIP NVARCHAR(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 NVARCHAR(255) NULL
ALTER TABLE WAPMO_USER ADD CONTENTTOTAL INT NULL
UPDATE WAPMO_USER SET CONTENTTOTAL=DCOUNT('SEQID', 'WAPMO_CONTENT', 'USERID=' & WAPMO_USER.USERID)
ALTER TABLE WAPMO_FORUM ADD ARTTOTAL INT NULL
UPDATE WAPMO_FORUM SET ARTTOTAL=DCOUNT('SEQID', 'WAPMO_ARTICLE', 'FORUMID=' & WAPMO_FORUM.SEQID)