oracle_2.1_to_2.2.sql

来自「EasyJForum 是一个基于 Java 技术的免费社区论坛软件系统」· SQL 代码 · 共 4 行

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;