ALTER TABLE t_test_collector_sample
    ADD COLUMN adapter_code VARCHAR(64) NOT NULL DEFAULT 'unknown' AFTER collector_id,
    ADD KEY idx_collector_sample_source (adapter_code, collector_id, collector_channel_code, sequence_id);