-- Ticket28：撤销已废弃的接收区间、历史补采、完整性和采集器断线恢复模型。
-- 原始 t_test_sample 仍保留，成功接收数据继续通过该表追加保存。
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE t_test_integrity_issue;
DROP TABLE t_test_backfill_cursor;
DROP TABLE t_data_gap;
DROP TABLE t_history_sync_cursor;
DROP TABLE t_test_collector_exception_interval;
DROP TABLE t_test_reception_interval;
DROP TABLE t_collector_channel_lease;
DROP TABLE t_channel_lease;

ALTER TABLE t_test_sample
    DROP FOREIGN KEY fk_sample_reception_interval,
    DROP KEY idx_sample_interval,
    DROP COLUMN reception_interval_id;

ALTER TABLE t_test_collector_sample
    DROP FOREIGN KEY fk_collector_sample_reception_interval,
    DROP KEY idx_collector_sample_interval,
    DROP COLUMN reception_interval_id;

ALTER TABLE t_test
    DROP COLUMN backfill_status,
    DROP COLUMN backfill_started_at_utc,
    DROP COLUMN backfill_completed_at_utc;

SET FOREIGN_KEY_CHECKS = 1;