hsqldb_2.1_to_2.2.sql

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

SELECT * INTO CACHED ejf_archive_topic FROM ejf_topic WHERE state='R' and createTime > NOW();
SELECT * INTO CACHED ejf_archive_reply FROM ejf_reply WHERE state='R' and createTime > NOW();

ALTER TABLE ejf_board ADD ruleCode LONGVARCHAR;