all-project/backend/sql/fix_audit_field_names.sql

-- 修复 jcbt_poverty_application 表中审核字段名称不一致问题
-- 问题: 数据库字段为 auditor_time/auditor_opinion，但实体类期望 audit_time/audit_opinion
-- 解决方案: 重命名数据库字段，保持与实体类一致

USE hzdyjs_xg;

-- 检查当前字段状态
SELECT '=== 修复前字段检查 ===' as message;
SELECT
    COLUMN_NAME as '字段名',
    DATA_TYPE as '数据类型',
    IS_NULLABLE as '允许NULL',
    COLUMN_DEFAULT as '默认值',
    COLUMN_COMMENT as '注释'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'hzdyjs_xg'
AND TABLE_NAME = 'jcbt_poverty_application'
AND COLUMN_NAME IN ('auditor_time', 'auditor_opinion', 'audit_time', 'audit_opinion');

-- 方案1: 重命名字段（推荐）
SELECT '=== 开始重命名字段 ===' as message;

-- 重命名 auditor_time 为 audit_time
ALTER TABLE jcbt_poverty_application
CHANGE COLUMN auditor_time audit_time datetime DEFAULT NULL COMMENT '审核时间';

-- 重命名 auditor_opinion 为 audit_opinion
ALTER TABLE jcbt_poverty_application
CHANGE COLUMN auditor_opinion audit_opinion text COMMENT '审核意见';

-- 验证修复结果
SELECT '=== 修复后字段检查 ===' as message;
SELECT
    COLUMN_NAME as '字段名',
    DATA_TYPE as '数据类型',
    IS_NULLABLE as '允许NULL',
    COLUMN_DEFAULT as '默认值',
    COLUMN_COMMENT as '注释'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'hzdyjs_xg'
AND TABLE_NAME = 'jcbt_poverty_application'
AND COLUMN_NAME IN ('auditor_time', 'auditor_opinion', 'audit_time', 'audit_opinion')
ORDER BY COLUMN_NAME;

SELECT '✅ 字段重命名完成！现在数据库字段与实体类保持一致！' as result;