From 6c85448ee73a84b55eac6b77136c61b510c12557 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期四, 10 七月 2025 20:56:57 +0800 Subject: [PATCH] art: 数据库脚本整理 --- db/ZHR/dict_zhr.sql | 62 +++++++++++++++++++++++++++++++ 1 files changed, 62 insertions(+), 0 deletions(-) diff --git a/db/ZHR/dict_zhr.sql b/db/ZHR/dict_zhr.sql index e69de29..6a8b19b 100644 --- a/db/ZHR/dict_zhr.sql +++ b/db/ZHR/dict_zhr.sql @@ -0,0 +1,62 @@ +--鎶�鏈姸鎬侀壌瀹氬伐鍗曠姸鎬� +delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status'; +delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status'); + +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943282255763828737', N'鎶�鏈姸鎬侀壌瀹氬伐鍗曠姸鎬�', N'technical_status_evaluation_order_status', N'璁惧绠＄悊浣跨敤', 0, N'admin', '2025-07-10 20:12:48.8660000', NULL, NULL, NULL); + +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282353361088513', N'1943282255763828737', N'寰呴壌瀹�', N'WAIT_EVALUATION', '', 1, 1, N'admin', '2025-07-10 20:13:12.1370000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282402136649730', N'1943282255763828737', N'閴村畾涓�', N'UNDER_EVALUATION', '', 2, 1, N'admin', '2025-07-10 20:13:23.7750000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282529404416002', N'1943282255763828737', N'缁翠慨浜虹瀛椾腑', N'REPAIRER_SIGNING', '', 3, 1, N'admin', '2025-07-10 20:13:54.1090000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282588527325186', N'1943282255763828737', N'缁翠慨瀹や富浠荤瀛椾腑', N'REPAIR_MANAGER_SIGNING', '', 4, 1, N'admin', '2025-07-10 20:14:08.2040000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282688888631297', N'1943282255763828737', N'宸ヨ壓鍛樼瀛椾腑', N'PROCESS_TECHNICIAN_SIGNING', '', 5, 1, N'admin', '2025-07-10 20:14:32.1330000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282764902002689', N'1943282255763828737', N'浣跨敤鍗曚綅鎶�鏈富绠＄瀛椾腑', N'DEPART_TECHNICAL_LEADER_SIGNING', '', 6, 1, N'admin', '2025-07-10 20:14:50.2570000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282836200976386', N'1943282255763828737', N'INSPECTOR_SIGNING', N'璁惧妫�楠屽憳绛惧瓧涓�', '', 7, 1, N'admin', '2025-07-10 20:15:07.2550000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282897358123009', N'1943282255763828737', N'宸插畬鎴�', N'COMPLETED', '', 8, 1, N'admin', '2025-07-10 20:15:21.8360000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282982930313218', N'1943282255763828737', N'宸查攣瀹�', N'LOCKED', '', 9, 1, N'admin', '2025-07-10 20:15:42.2430000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283076018696194', N'1943282255763828737', N'鍙樻洿涓�', N'CHANGING', '', 10, 1, N'admin', '2025-07-10 20:16:04.4340000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283135447789569', N'1943282255763828737', N'EXPIRED', N'宸茶繃鏈�', '', 11, 1, N'admin', '2025-07-10 20:16:18.6020000', NULL, NULL); + +--鎶�鏈姸鎬佹鏌ラ」鍒嗙被 +delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category'; +delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category'); + +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942406054790733826', N'鎶�鏈姸鎬佹鏌ラ」鍒嗙被', N'technical_status_evaluation_check_category', N'璁惧绠＄悊浣跨敤', 0, N'admin', '2025-07-08 10:11:06.2770000', NULL, NULL, NULL); + +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406262689800193', N'1942406054790733826', N'瀹夊叏瑁呯疆妫�鏌�', N'SAFETY_EQUIPMENT_CHECK', '', 1, 1, N'admin', '2025-07-08 10:11:55.8440000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406374128263170', N'1942406054790733826', N'绮惧害妫�鏌�', N'PRECISION_CHECK', '', 2, 1, N'admin', '2025-07-08 10:12:22.4130000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406681549774850', N'1942406054790733826', N'鍏朵粬妫�鏌�', N'OTHER_CHECK', '', 3, 1, N'admin', '2025-07-08 10:13:35.7220000', NULL, NULL); + +--鎶�鏈姸鎬侀壌瀹氳鑼冪姸鎬� +delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status'; +delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status'); + +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942405419550810113', N'鎶�鏈姸鎬侀壌瀹氳鑼冪姸鎬�', N'technical_status_evaluation_standard_status', N'璁惧绠＄悊浣跨敤', 0, N'admin', '2025-07-08 10:08:34.8250000', NULL, NULL, NULL); + +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405572965867522', N'1942405419550810113', N'寰呮彁浜�', N'WAIT_SUBMIT', '', 1, 1, N'admin', '2025-07-08 10:09:11.4020000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405638514450434', N'1942405419550810113', N'鍚敤', N'ENABLE', '', 2, 1, N'admin', '2025-07-08 10:09:27.0300000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405710740365313', N'1942405419550810113', N'绂佺敤', N'DISABLE', '', 3, 1, N'admin', '2025-07-08 10:09:44.2500000', NULL, NULL); + +--HF妯℃澘鍒嗙被 +delete from [dbo].[sys_dict] where dict_code='hf_template_category'; +delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='hf_template_category'); + +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941372067586695170', N'HF妯℃澘鍒嗙被', N'hf_template_category', N'璁惧绠＄悊浣跨敤', 0, N'admin', '2025-07-05 13:42:24.5310000', NULL, NULL, NULL); + +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372224336224258', N'1941372067586695170', N'鐐规', N'INSPECTION', '', 1, 1, N'admin', '2025-07-05 13:43:01.9000000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372326169731074', N'1941372067586695170', N'浜屼繚', N'SECOND_MAINTENANCE', '', 2, 1, N'admin', '2025-07-05 13:43:26.1820000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372412710805506', N'1941372067586695170', N'涓変繚绉讳氦鍗�', N'THIRD_MAINTENANCE_HANDOVER', '', 3, 1, N'admin', '2025-07-05 13:43:46.0000000', N'admin', '2025-07-10 15:26:39.3940000'); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210356597813250', N'1941372067586695170', N'涓変繚楠屾敹鍗�', N'THIRD_MAINTENANCE_ACCEPTANCE', '', 4, 1, N'admin', '2025-07-10 15:27:06.7660000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210616086818818', N'1941372067586695170', N'鎶�鏈姸鎬侀壌瀹氳〃', N'TECHNICAL_STATUS_EVALUATION', '', 5, 1, N'admin', '2025-07-10 15:28:08.0000000', N'admin', '2025-07-10 15:31:13.3650000'); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210729806983169', N'1941372067586695170', N'瀹夊叏瑁呯疆妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_SAFETY_CHECK', '', 6, 1, N'admin', '2025-07-10 15:28:35.0000000', N'admin', '2025-07-10 15:29:46.5590000'); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211129419296770', N'1941372067586695170', N'鍏朵粬妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_OTHER_CHECK', '', 7, 1, N'admin', '2025-07-10 15:30:11.0000000', N'admin', '2025-07-10 15:31:23.8110000'); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211241587568641', N'1941372067586695170', N'璁惧绮惧害妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_PRECISION_CHECK', '', 8, 1, N'admin', '2025-07-10 15:30:37.0000000', N'admin', '2025-07-10 15:31:29.2060000'); + +--鍚敤绂佺敤 +delete from [dbo].[sys_dict] where dict_code='enable_disable'; +delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='enable_disable'); + +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941370835371483137', N'鍚敤绂佺敤', N'enable_disable', N'閫氱敤鏁版嵁瀛楀吀', 0, N'admin', '2025-07-05 13:37:30.7420000', NULL, NULL, NULL); + +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941370959137005570', N'1941370835371483137', N'鍚敤', N'ENABLE', '', 1, 1, N'admin', '2025-07-05 13:38:00.2500000', NULL, NULL); +INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941371030628917250', N'1941370835371483137', N'绂佺敤', N'DISABLE', '', 2, 1, N'admin', '2025-07-05 13:38:17.2920000', NULL, NULL); + -- Gitblit v1.9.3