oracle_2.1_to_2.2.sql

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

CREATE TABLE ejf_archive_topic AS SELECT * FROM ejf_topic WHERE state='R' and createTime > SYSDATE;
CREATE TABLE ejf_archive_reply AS SELECT * FROM ejf_reply WHERE state='R' and createTime > SYSDATE;

ALTER TABLE ejf_board ADD ruleCode CLOB;