BEGIN;
/* ---------- 1. 確保歸檔表與索引存在 ---------- */ CREATE SCHEMA IF NOT EXISTS archive;
CREATE TABLE IF NOT EXISTS archive."QcOrder_archive" (LIKE public."QcOrder" INCLUDING ALL); -- 不包含分割設定
CREATE INDEX IF NOT EXISTS "QcOrder_archive_id_idx" ON archive."QcOrder_archive"(id);