all-project/backend/sql/fix_jcbt_scholarship_application_create_dept.sql

-- 修复奖学金申请表缺失的create_dept字段
-- 问题: MyBatis-Plus插入数据时报错 Unknown column 'create_dept' in 'field list'
-- 原因: 数据库表缺少BaseEntity中的create_dept字段
-- 解决方案: 为jcbt_scholarship_application表添加create_dept字段

-- 检查字段是否存在，不存在则添加
SET @sql = '';
SELECT COUNT(*) INTO @col_exists
FROM information_schema.columns
WHERE table_schema = 'hzdyjs_xg'
  AND table_name = 'jcbt_scholarship_application'
  AND column_name = 'create_dept';

-- 如果字段不存在，则添加
SET @sql = IF(@col_exists = 0,
    'ALTER TABLE jcbt_scholarship_application ADD COLUMN create_dept bigint(20) DEFAULT NULL COMMENT ''创建部门'' AFTER submit_time;',
    'SELECT ''字段 create_dept 已存在，跳过添加'' AS message;');

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

-- 验证字段是否添加成功
SELECT
    COLUMN_NAME as '字段名',
    DATA_TYPE as '数据类型',
    IS_NULLABLE as '允许空值',
    COLUMN_DEFAULT as '默认值',
    COLUMN_COMMENT as '注释'
FROM information_schema.columns
WHERE table_schema = 'hzdyjs_xg'
  AND table_name = 'jcbt_scholarship_application'
  AND column_name = 'create_dept';