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