mysql_2.1_to_2.2.sql

EasyJForum 是一个基于 Java 技术的免费社区论坛软件系统

CREATE TABLE ejf_archive_topic ENGINE=InnoDB AS SELECT * FROM ejf_topic WHERE state='R' and createTime > NOW();
CREATE TABLE ejf_archive_reply ENGINE=InnoDB AS SELECT * FROM ejf_reply WHERE state='R' and createTime > NOW();

ALTER TABLE ejf_board ADD ruleCode TEXT;