all-project/backend/sql/add_family_economy_summary_field.sql

-- ============================================================================
-- 贫困生认定申请表 - 添加缺失的family_economy_summary字段
-- 创建时间: 2025-01-27
-- 描述: 修复 jcbt_poverty_application 表缺失的 family_economy_summary 字段
-- ============================================================================

-- 检查并添加 family_economy_summary 字段（如果不存在）
SET @sql = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
           WHERE TABLE_SCHEMA = DATABASE()
           AND TABLE_NAME = 'jcbt_poverty_application'
           AND COLUMN_NAME = 'family_economy_summary');

SET @sql = IF(@sql = 0,
    'ALTER TABLE jcbt_poverty_application ADD COLUMN family_economy_summary text COMMENT ''家庭经济情况摘要'' AFTER assistance_type_names',
    'SELECT ''family_economy_summary字段已存在'' as result');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

-- 验证字段是否添加成功
SELECT
    CASE
        WHEN (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
              WHERE TABLE_SCHEMA = DATABASE()
              AND TABLE_NAME = 'jcbt_poverty_application'
              AND COLUMN_NAME = 'family_economy_summary') > 0
        THEN 'SUCCESS: family_economy_summary字段已成功添加到数据库表中'
        ELSE 'ERROR: family_economy_summary字段添加失败'
    END as verification_result;

-- 显示表结构确认
DESCRIBE jcbt_poverty_application;

-- ============================================================================
-- 使用说明:
-- 1. 连接到对应的数据库
-- 2. 执行本脚本: source /path/to/add_family_economy_summary_field.sql
-- 3. 检查输出结果，确认字段已正确添加
-- 4. 重新启动后端服务
-- ============================================================================