15 lines
550 B
SQL
15 lines
550 B
SQL
-- 项目状态字典 process_status 增加：9=工艺审核拒绝（钉钉工艺卡片拒绝回调）
|
||
-- 可重复执行（幂等）
|
||
|
||
INSERT INTO sys_dict_data (
|
||
dict_sort, dict_label, dict_value, dict_type, css_class, list_class,
|
||
is_default, status, create_by, create_time, remark
|
||
)
|
||
SELECT 9, '工艺审核拒绝', '9', 'process_status', '', 'danger',
|
||
'N', '0', 'admin', sysdate(), '钉钉工艺审核拒绝'
|
||
FROM DUAL
|
||
WHERE NOT EXISTS (
|
||
SELECT 1 FROM sys_dict_data
|
||
WHERE dict_type = 'process_status' AND dict_value = '9'
|
||
);
|