From a6430ffc4448d79a95fb28f1ac464f0f35f2a10c Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期三, 02 七月 2025 11:00:03 +0800 Subject: [PATCH] art:点检工单、点检标准数据库设计修改 --- lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11(lnl)/lnl.sql | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 60 insertions(+), 0 deletions(-) diff --git "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql" "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql" index 3661494..3c17df8 100644 --- "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql" +++ "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql" @@ -2,4 +2,64 @@ UPDATE [dbo].[sys_permission] SET [parent_id] = N'1647845086853693442', [name] = N'缁翠慨灞ュ巻', [url] = N'/eam/RepairOrder', [component] = N'eam/RepairOrderList', [component_name] = NULL, [redirect] = NULL, [menu_type] = 1, [perms] = NULL, [perms_type] = N'1', [sort_no] = 1.2, [always_show] = 0, [icon] = NULL, [is_route] = 1, [is_leaf] = 1, [keep_alive] = 0, [hidden] = 0, [hide_tab] = 0, [description] = NULL, [create_by] = N'admin', [create_time] = '2023-04-24 16:56:44.0000000', [update_by] = N'admin', [update_time] = '2023-12-11 11:32:06.0090000', [del_flag] = 0, [rule_flag] = 0, [status] = N'1', [internal_or_external] = 0 WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1650423515662295042'; -- 鑿滃崟璁惧浜嬫晠鐧昏琛ㄤ慨鏀� UPDATE [dbo].[sys_permission] SET [parent_id] = N'1647845086853693442', [name] = N'璁惧浜嬫晠鐧昏琛�', [url] = N'/eam/FaultInfoList', [component] = N'eam/FaultInfoList', [component_name] = NULL, [redirect] = NULL, [menu_type] = 1, [perms] = NULL, [perms_type] = N'1', [sort_no] = 2.1, [always_show] = 0, [icon] = NULL, [is_route] = 1, [is_leaf] = 1, [keep_alive] = 0, [hidden] = 0, [hide_tab] = 0, [description] = NULL, [create_by] = N'admin', [create_time] = '2023-11-13 09:39:39.0000000', [update_by] = N'admin', [update_time] = '2023-12-11 11:38:21.9880000', [del_flag] = 0, [rule_flag] = NULL, [status] = N'1', [internal_or_external] = 0 WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1723878256194232322'; +--ABC鏍囪瘑鍙樻洿鍗曞崟鎹彿 +INSERT INTO [dbo].[mom_sys_identity] ([id], [num], [month_value], [year_value], [type], [remark], [create_by], [create_time], [update_by], [update_time], [prifix], [encode_rule_id]) VALUES (N'1726910264274141186', 10, N'12', N'2023', N'ABCAssement', NULL, N'admin', '2023-11-21 18:27:46', N'admin', '2023-12-12 15:52:18', NULL, NULL); +-- 淇濆吇璁″垝鐢熸垚鍘熷洜瀛楁娣诲姞 +ALTER TABLE [dbo].[mom_eam_equipment_maintenance_plan] ADD [create_reason] varchar(255) NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'鐢熶骇鍘熷洜', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_equipment_maintenance_plan', + 'COLUMN', N'create_reason' +-- 璁惧鍙拌处澧炲姞涓や釜瀛楁 +ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_line_equip] nvarchar(32) NULL + GO + +ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_judging] nvarchar(32) NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'鏄惁鐢熶骇绾胯澶囷紙鏄細yes锛屽惁锛歯o锛�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_equipment', + 'COLUMN', N'is_line_equip' + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'鏄惁鍦ㄨ瘎鍒嗗綋涓紙鏄細yes锛屽惁锛歯o锛�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_equipment', + 'COLUMN', N'is_judging' +-- 鏄惁鐢熶骇绾� +ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_line] nvarchar NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'鏄惁鐢熶骇绾匡紙鏄細yes锛屽惁锛歯o锛�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_equipment', + 'COLUMN', N'is_line' +-- 淇敼瀛楁闀垮害 +ALTER TABLE [dbo].[mom_eam_equipment] ALTER COLUMN [is_line] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL +-- 鐢熶骇绾挎柊澧炵紪杈戝垹闄ゆ寜閽潈闄� +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734844168171163649', N'1726425666842873858', N'鐢熶骇绾挎柊澧炵紪杈戝垹闄�', NULL, NULL, NULL, NULL, 2, N'line:add&edit&delete', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 15:54:16.2070000', NULL, NULL, 0, NULL, N'1', 0); +-- 鏁呴殰鎶ヤ慨鎸夐挳鏉冮檺 +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734845810551558146', N'1647845301102936065', N'鏁呴殰鎶ヤ慨鏂板缂栬緫鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'report:add&edit', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:00:47.7700000', NULL, NULL, 0, NULL, N'1', 0); +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734846510299877378', N'1647845301102936065', N'鏁呴殰鎶ヤ慨楠屾敹鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'report:accept', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:03:34.6030000', NULL, NULL, 0, NULL, N'1', 0); +-- 缁翠慨灞ュ巻鎸夐挳鏉冮檺 +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734847324137459714', N'1650423515662295042', N'缁翠慨灞ュ巻棰嗗彇鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'repair:accept', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:06:48.6370000', NULL, NULL, 0, NULL, N'1', 0); +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734847789482905601', N'1650423515662295042', N'缁翠慨灞ュ巻鎵ц鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'repair:excute', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:08:39.5970000', NULL, NULL, 0, NULL, N'1', 0); +-- 浜嬫晠鐧昏鎸夐挳鏉冮檺 +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734851460430041089', N'1723876722224013314', N'纭鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'quanlity:confirm', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:23:14.8040000', NULL, NULL, 0, NULL, N'1', 0); +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734851932285046785', N'1723878256194232322', N'纭鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'fault:confirm', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:25:07.3090000', NULL, NULL, 0, NULL, N'1', 0); +INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1734852409726865409', N'1723878256194232322', N'褰曞叆鎸夐挳鏉冮檺', NULL, NULL, NULL, NULL, 2, N'fault:update', N'1', NULL, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-12-13 16:27:01.1330000', NULL, NULL, 0, NULL, N'1', 0); +-- 鏁版嵁瀛楀吀 +UPDATE [dbo].[sys_dict_item] SET [dict_id] = N'1726851458752135169', [item_text] = N'鍙戝竷', [item_value] = N'publish', [description] = '', [sort_order] = 4, [status] = 1, [create_by] = N'admin', [create_time] = '2023-11-22 15:35:05.0000000', [update_by] = N'admin', [update_time] = '2023-12-12 16:25:57.0490000' WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1727229198391099393'; +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'1734489911165300738', N'1726851458752135169', N'瀹屾垚', N'finish', '', 5, 1, N'admin', '2023-12-12 16:26:34.7370000', 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'1734491187554922497', N'1726853242417659906', N'鍙戝竷', N'change', '', 5, 1, N'admin', '2023-12-12 16:31:39.0670000', NULL, NULL); +UPDATE [dbo].[sys_dict_item] SET [dict_id] = N'1726858393618563073', [item_text] = N'ABCPUBLISH', [item_value] = N'publish', [description] = '', [sort_order] = 4, [status] = 1, [create_by] = N'admin', [create_time] = '2023-11-22 19:03:49.0000000', [update_by] = N'admin', [update_time] = '2023-12-12 16:32:51.2560000' WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1727281726986178561'; +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'1734491585221079042', N'1726858393618563073', N'ABCFINISH', N'finish', '', 5, 1, N'admin', '2023-12-12 16:33:13.0000000', N'admin', '2023-12-12 16:33:26.0350000'); +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'1734492105969086466', N'1726861018934099969', N'change', N'publish', N'鍙戝竷锛堝彂甯冿級', 4, 1, N'admin', '2023-12-12 16:35:18.0000000', N'admin', '2023-12-12 16:55:09.9310000'); -- Gitblit v1.9.3