-- Ticket25：控制台三类数据的一次用户行为修订、覆盖状态和物理删除支持。
CREATE TABLE t_test_data_revision_action (
    action_id BIGINT NOT NULL AUTO_INCREMENT,
    test_id BIGINT NOT NULL,
    data_type VARCHAR(16) NOT NULL,
    operation_type VARCHAR(16) NOT NULL,
    scope_summary VARCHAR(1000) NOT NULL,
    identity_summary JSON NOT NULL,
    changes_summary JSON NULL,
    reason VARCHAR(500) NOT NULL,
    operator_id BIGINT NULL,
    operator_name VARCHAR(64) NOT NULL,
    created_at_utc DATETIME(3) NOT NULL,
    PRIMARY KEY (action_id),
    KEY idx_data_revision_test_time (test_id, data_type, created_at_utc),
    CONSTRAINT fk_data_revision_test FOREIGN KEY (test_id) REFERENCES t_test (test_id),
    CONSTRAINT chk_data_revision_type CHECK (data_type IN ('REALTIME', 'STEP', 'CYCLE')),
    CONSTRAINT chk_data_revision_operation CHECK (operation_type IN ('EDIT', 'IMPORT', 'DELETE')),
    CONSTRAINT chk_data_revision_reason CHECK (CHAR_LENGTH(TRIM(reason)) > 0)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试控制台一次数据修订行为';

CREATE TABLE t_test_data_override (
    override_id BIGINT NOT NULL AUTO_INCREMENT,
    test_id BIGINT NOT NULL,
    data_type VARCHAR(16) NOT NULL,
    stable_identity VARCHAR(512) NOT NULL,
    field_values JSON NULL,
    deleted TINYINT(1) NOT NULL DEFAULT 0,
    action_id BIGINT NOT NULL,
    created_at_utc DATETIME(3) NOT NULL,
    PRIMARY KEY (override_id),
    UNIQUE KEY uk_data_override_identity (test_id, data_type, stable_identity),
    KEY idx_data_override_action (action_id),
    CONSTRAINT fk_data_override_test FOREIGN KEY (test_id) REFERENCES t_test (test_id),
    CONSTRAINT fk_data_override_action FOREIGN KEY (action_id) REFERENCES t_test_data_revision_action (action_id),
    CONSTRAINT chk_data_override_type CHECK (data_type IN ('REALTIME', 'STEP', 'CYCLE'))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='控制台数据最新人工覆盖或删除状态';