-- Ticket12：人工结束关闭全部开放接收区间，并为顺序接入保留稳定的来源时间索引。
ALTER TABLE t_test_reception_interval
    ADD CONSTRAINT chk_reception_interval_boundary_order
        CHECK (end_boundary_at_utc IS NULL OR end_boundary_at_utc >= start_boundary_at_utc),
    ADD KEY idx_reception_interval_source_order
        (source_type, source_id, source_channel_code, start_boundary_at_utc, interval_id);

-- 停止测试权限由 V16 提供；这里仅保留迁移可重复启动所需的幂等保护。
SET @stop_menu_id := (SELECT COALESCE(MAX(menu_id), 0) + 1 FROM sys_menu);
INSERT INTO sys_menu
    (menu_id, menu_name, parent_id, order_num, path, component, query, route_name,
     is_frame, is_cache, menu_type, visible, status, perms, icon,
     create_by, create_time, update_by, update_time, remark)
SELECT @stop_menu_id, '停止测试', menu_id, 9, '', NULL, NULL, '', 1, 0, 'F', '0', '0',
       'system:test:stop', '#', 'admin', NOW(), '', NULL, '测试人工结束权限'
FROM sys_menu
WHERE perms = 'system:test:list'
  AND NOT EXISTS (SELECT 1 FROM sys_menu existing WHERE existing.perms = 'system:test:stop')
LIMIT 1;