complaint-system/sql/check_dict_data.sql

-- 检查字典数据是否存在
SELECT COUNT(*) as complaint_category_count 
FROM sys_dict_data 
WHERE dict_type = 'complaint_category';

SELECT COUNT(*) as school_type_count 
FROM sys_dict_data 
WHERE dict_type = 'school_type';

-- 如果不存在，则插入字典数据
-- 先检查 dict_type 是否存在
SELECT COUNT(*) as dict_type_exists 
FROM sys_dict_type 
WHERE dict_type = 'complaint_category';