USE `tour_guide`;

SELECT `version`, `description`, `applied_at`
FROM `sys_schema_migration`
ORDER BY `applied_at`, `version`;

SELECT '当前结构基线' AS `检查项`,
       IF(EXISTS(
           SELECT 1 FROM `sys_schema_migration`
           WHERE `version` = '20260728_150000_CURRENT_SCHEMA_BASELINE'
       ), '已登记', '未登记') AS `状态`
UNION ALL
SELECT '景区管理表', IF(COUNT(*) = 3, '完整', '缺失')
FROM `information_schema`.`tables`
WHERE `table_schema` = DATABASE()
  AND `table_name` IN ('operation_scenic_spot', 'operation_scenic_pricing', 'operation_scenic_meeting_point')
UNION ALL
SELECT '平台设置参数', IF(COUNT(*) >= 7, '完整', '缺失')
FROM `sys_config`
WHERE `config_key` LIKE 'platform.%'
UNION ALL
SELECT '平台协议数据', IF(COUNT(*) >= 6, '完整', '缺失')
FROM `agreement_setting`;