Files
lc_backend/SQL/202509/20250928/risk_source_dic.sql
2025-10-17 10:11:04 +08:00

11 lines
1.1 KiB
SQL

delete
from "LOWCODE_MASTER"."SYSTEM_DICT_TYPE" where type in ('risk_source_dic');
insert into "LOWCODE_MASTER"."SYSTEM_DICT_TYPE"("NAME", "TYPE", "STATUS", "REMARK", "CREATOR", "CREATE_TIME", "UPDATER", "UPDATE_TIME", "DELETED", "DELETED_TIME") values('隐患来源', 'risk_source_dic', 0, '', '1', '2025-09-28 11:05:38', '1', '2025-09-28 11:05:38', 0, '1970-01-01 00:00:00');
delete
from "LOWCODE_MASTER"."SYSTEM_DICT_DATA" where DICT_TYPE in ('risk_source_dic');
insert into "LOWCODE_MASTER"."SYSTEM_DICT_DATA"("SORT", "LABEL", "VALUE", "DICT_TYPE", "STATUS", "COLOR_TYPE", "CSS_CLASS", "REMARK", "CREATOR", "CREATE_TIME", "UPDATER", "UPDATE_TIME", "DELETED") values(0, '线下', '1', 'risk_source_dic', 0, '', '', '', '1', '2025-09-28 11:05:57', '1', '2025-09-28 11:05:57', 0);
insert into "LOWCODE_MASTER"."SYSTEM_DICT_DATA"("SORT", "LABEL", "VALUE", "DICT_TYPE", "STATUS", "COLOR_TYPE", "CSS_CLASS", "REMARK", "CREATOR", "CREATE_TIME", "UPDATER", "UPDATE_TIME", "DELETED") values(0, '线上', '2', 'risk_source_dic', 0, '', '', '', '1', '2025-09-28 11:06:08', '1', '2025-09-28 11:06:08', 0);