slaj/doc/sys_dict_eme.sql

-- ============================================================================
-- 应急信息管理模块 — 字典数据
-- 先删再插，可重复执行
-- ============================================================================
DELETE FROM sys_dict_data WHERE dict_type IN ('eme_plan_type','eme_plan_status','eme_revi_resu','eme_revi_type','eme_filing_status','eme_public_status','eme_eval_status','eme_train_type','eme_drill_type','eme_date_type','eme_supp_type','eme_supp_status','eme_team_type');
DELETE FROM sys_dict_type WHERE dict_type IN ('eme_plan_type','eme_plan_status','eme_revi_resu','eme_revi_type','eme_filing_status','eme_public_status','eme_eval_status','eme_train_type','eme_drill_type','eme_date_type','eme_supp_type','eme_supp_status','eme_team_type');

-- 字典类型
INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time) VALUES
('预案类型',    'eme_plan_type',    '0', 'admin', now()),
('预案状态',    'eme_plan_status',  '0', 'admin', now()),
('评审结果',    'eme_revi_resu',    '0', 'admin', now()),
('评审类型',    'eme_revi_type',    '0', 'admin', now()),
('备案状态',    'eme_filing_status','0', 'admin', now()),
('公开状态',    'eme_public_status','0', 'admin', now()),
('评估状态',    'eme_eval_status',  '0', 'admin', now()),
('培训类型',    'eme_train_type',   '0', 'admin', now()),
('演练类型',    'eme_drill_type',   '0', 'admin', now()),
('统计类型',    'eme_date_type',    '0', 'admin', now()),
('物资类型',    'eme_supp_type',    '0', 'admin', now()),
('物资状态',    'eme_supp_status',  '0', 'admin', now()),
('队伍类型',    'eme_team_type',    '0', 'admin', now());

-- 字典数据
INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time) VALUES
-- 预案类型
(1,'综合应急预案', '1','eme_plan_type',NULL,NULL,'N','0','admin',now()),
(2,'专项应急预案', '2','eme_plan_type',NULL,NULL,'N','0','admin',now()),
(3,'现场处置方案', '3','eme_plan_type',NULL,NULL,'N','0','admin',now()),
-- 预案状态
(1,'正常',  '1','eme_plan_status',NULL,NULL,'N','0','admin',now()),
(2,'过期',  '2','eme_plan_status',NULL,NULL,'N','0','admin',now()),
(3,'修订中','3','eme_plan_status',NULL,NULL,'N','0','admin',now()),
-- 评审结果
(1,'未评审',  '0','eme_revi_resu',NULL,NULL,'N','0','admin',now()),
(2,'评审通过','1','eme_revi_resu',NULL,NULL,'N','0','admin',now()),
-- 评审类型
(1,'初次评审','1','eme_revi_type',NULL,NULL,'N','0','admin',now()),
(2,'修订评审','2','eme_revi_type',NULL,NULL,'N','0','admin',now()),
-- 备案状态
(1,'未备案','1','eme_filing_status',NULL,NULL,'N','0','admin',now()),
(2,'备案中','2','eme_filing_status',NULL,NULL,'N','0','admin',now()),
(3,'备案完成','3','eme_filing_status',NULL,NULL,'N','0','admin',now()),
-- 公开状态
(1,'未公开','1','eme_public_status',NULL,NULL,'N','0','admin',now()),
(2,'已公开','2','eme_public_status',NULL,NULL,'N','0','admin',now()),
-- 评估状态
(1,'未评估','1','eme_eval_status',NULL,NULL,'N','0','admin',now()),
(2,'已评估','2','eme_eval_status',NULL,NULL,'N','0','admin',now()),
-- 培训类型
(1,'理论培训','1','eme_train_type',NULL,NULL,'N','0','admin',now()),
(2,'桌面推演','2','eme_train_type',NULL,NULL,'N','0','admin',now()),
(3,'实操演练','3','eme_train_type',NULL,NULL,'N','0','admin',now()),
-- 演练类型
(1,'实战演练','1','eme_drill_type',NULL,NULL,'N','0','admin',now()),
(2,'桌面推演','2','eme_drill_type',NULL,NULL,'N','0','admin',now()),
(3,'专项演练','3','eme_drill_type',NULL,NULL,'N','0','admin',now()),
-- 统计类型
(1,'月度', '1','eme_date_type',NULL,NULL,'N','0','admin',now()),
(3,'季度', '3','eme_date_type',NULL,NULL,'N','0','admin',now()),
-- 物资类型
(1,'防汛物资','1','eme_supp_type',NULL,NULL,'N','0','admin',now()),
(2,'救援设备','2','eme_supp_type',NULL,NULL,'N','0','admin',now()),
(3,'通讯设备','3','eme_supp_type',NULL,NULL,'N','0','admin',now()),
-- 物资状态
(1,'充足','1','eme_supp_status',NULL,NULL,'N','0','admin',now()),
(2,'不足','2','eme_supp_status',NULL,NULL,'N','0','admin',now()),
-- 队伍类型
(1,'专业抢险','1','eme_team_type',NULL,NULL,'N','0','admin',now()),
(2,'医疗救援','2','eme_team_type',NULL,NULL,'N','0','admin',now()),
(3,'综合应急','3','eme_team_type',NULL,NULL,'N','0','admin',now());