-- ======================================== -- 员工状态字典类型和数据 -- ======================================== -- 插入字典类型 INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, remark) VALUES (109, '员工状态', 'ccdi_employee_status', '0', 'admin', NOW(), '员工状态列表'); -- 插入字典数据 - 在职 INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark) VALUES (143, 1, '在职', '1', 'ccdi_employee_status', '', 'primary', 'N', '0', 'admin', NOW(), '在职状态'); -- 插入字典数据 - 离职 INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark) VALUES (144, 2, '离职', '0', 'ccdi_employee_status', '', 'danger', 'N', '0', 'admin', NOW(), '离职状态');