all-project/backend/script/sql/fix_education_level_dict.sql

-- ==================================================
-- 修复学历层次字典数据 - 下拉框为空问题解决
-- 创建日期: 2025-01-26
-- 说明: 重新创建学历层次字典数据，使用正常范围的dict_code值
-- ==================================================

-- 1. 查看修复前的数据
SELECT '=== 修复前的学历层次字典 ===' as info;
SELECT dict_code, dict_label, dict_value, dict_sort
FROM sys_dict_data
WHERE dict_type = 'zsjy_education_level'
ORDER BY dict_sort;

-- 2. 删除现有的有问题的字典数据
DELETE FROM sys_dict_data WHERE dict_type = 'zsjy_education_level';

-- 3. 重新插入学历层次字典数据，使用正常的dict_code值
INSERT INTO sys_dict_data (
    dict_code, tenant_id, dict_sort, dict_label, dict_value,
    dict_type, css_class, list_class, is_default,
    create_dept, create_by, create_time, update_by, update_time, remark
) VALUES
(214, '000000', 1, '专科', '1', 'zsjy_education_level', NULL, 'primary', 'N', NULL, 103, NOW(), 103, NOW(), '专科学历'),
(215, '000000', 2, '本科', '2', 'zsjy_education_level', NULL, 'success', 'N', NULL, 103, NOW(), 103, NOW(), '本科学历'),
(216, '000000', 3, '硕士', '3', 'zsjy_education_level', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '硕士研究生学历'),
(217, '000000', 4, '博士', '4', 'zsjy_education_level', NULL, 'warning', 'N', NULL, 103, NOW(), 103, NOW(), '博士研究生学历');

-- 4. 验证修复后的数据
SELECT '=== 修复后的学历层次字典 ===' as info;
SELECT dict_code, dict_label, dict_value, dict_sort
FROM sys_dict_data
WHERE dict_type = 'zsjy_education_level'
ORDER BY dict_sort;

-- 5. 验证字典类型是否存在
SELECT '=== 验证字典类型配置 ===' as info;
SELECT dict_type, dict_name
FROM sys_dict_type
WHERE dict_type = 'zsjy_education_level';