From 7eef12f6ffa0a76abb3a6dfecda9460144655e3a Mon Sep 17 00:00:00 2001 From: “linengliang” <vanSuperEnergy@163.com> Date: 星期六, 18 十一月 2023 12:32:32 +0800 Subject: [PATCH] 维修工单 --- lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16(lnl)/sys_dict_update.sql | 126 +++++++++++++++++++++++++++++++++++++++++ 1 files changed, 125 insertions(+), 1 deletions(-) diff --git "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/sys_dict_update.sql" "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/sys_dict_update.sql" index 0116575..b75abe2 100644 --- "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/sys_dict_update.sql" +++ "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/sys_dict_update.sql" @@ -30,5 +30,129 @@ 'TABLE', N'mom_eam_equipment_report_repair', 'COLUMN', N'finish_time' -INSERT INTO [dbo].[sys_quartz_job] ([id], [create_by], [create_time], [del_flag], [update_by], [update_time], [job_class_name], [cron_expression], [parameter], [description], [status], [job_name]) VALUES (N'1301802672317695720', N'admin', '2023-11-16 18:38:01.0000000', 0, N'admin', '2023-11-16 18:38:11.0000000', N'org.jeecg.modules.eam.job/EquipmentWarrantyEndDateAlertJob', N'0 0 1 * * ? *', NULL, N'鏁呴殰鎶ヤ慨楠屾敹', 0, N'缁翠慨瀹屾垚12灏忔椂鍚庨獙鏀�'); +INSERT INTO [dbo].[sys_quartz_job] ([id], [create_by], [create_time], [del_flag], [update_by], [update_time], [job_class_name], [cron_expression], [parameter], [description], [status], [job_name]) VALUES (N'1301802672317695720', N'admin', '2023-11-16 18:38:01.0000000', 0, N'admin', '2023-11-16 18:38:11.0000000', N'org.jeecg.modules.eam.job.EquipmentWarrantyEndDateAlertJob', N'0 0 1 * * ? *', NULL, N'鏁呴殰鎶ヤ慨楠屾敹', 0, N'缁翠慨瀹屾垚12灏忔椂鍚庨獙鏀�'); +INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1725333574041309186', N'缁翠慨宸ュ崟鐘舵��', N'true_repair_status', '', 0, N'admin', '2023-11-17 10:02:33.8500000', 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'1725334295704866818', N'1725333574041309186', N'鏈淳宸�', N'2', '', 1, 1, N'admin', '2023-11-17 10:05:25.9110000', 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'1725334447886798850', N'1725333574041309186', N'缁翠慨', N'3', '', 2, 1, N'admin', '2023-11-17 10:06:02.1960000', 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'1725334568024248321', N'1725333574041309186', N'瀹屾垚', N'4', '', 4, 1, N'admin', '2023-11-17 10:06:30.8390000', NULL, NULL); + +ALTER TABLE [dbo].[mom_eam_repair_order] DROP CONSTRAINT [DF__mom_eam_r__repai__7822EBA0] + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] DROP CONSTRAINT [DF__mom_eam_r__repai__79170FD9] + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] DROP CONSTRAINT [DF__mom_eam_r__repai__7A0B3412] + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] DROP CONSTRAINT [DF__mom_eam_r__repai__7AFF584B] + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [repair_order_uda2] datetime2 NULL + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [repair_order_uda3] datetime2 NULL + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [repair_order_uda4] datetime2 NULL + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [repair_order_uda5] datetime2 NULL + GO + + IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda2')) > 0) + EXEC sp_updateextendedproperty + 'MS_Description', N'绛夊緟澶囦欢寮�濮嬫椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda2' + ELSE + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟澶囦欢寮�濮嬫椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda2' + GO + + IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda3')) > 0) + EXEC sp_updateextendedproperty + 'MS_Description', N'绛夊緟澶囦欢缁撴潫鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda3' + ELSE + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟澶囦欢缁撴潫鏃堕棿', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda3' + GO + + IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda4')) > 0) + EXEC sp_updateextendedproperty + 'MS_Description', N'绛夊緟鍔犲伐浠跺紑濮嬫椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda4' + ELSE + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟鍔犲伐浠跺紑濮嬫椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda4' + GO + + IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda5')) > 0) + EXEC sp_updateextendedproperty + 'MS_Description', N'绛夊緟鍔犲伐浠剁粨鏉熸椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda5' + ELSE + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟鍔犲伐浠剁粨鏉熸椂闂�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'repair_order_uda5' + +ALTER TABLE [dbo].[mom_eam_repair_order] ADD [spare_time] decimal NULL + GO + +ALTER TABLE [dbo].[mom_eam_repair_order] ADD [part_time] decimal NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟澶囦欢鎬绘椂闀�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'spare_time' + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'绛夊緟鍔犲伐浠舵�绘椂闀�', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_repair_order', + 'COLUMN', N'part_time' + +ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ADD [fault_hour] decimal NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'鍋滄満鏃堕暱', + 'SCHEMA', N'dbo', + 'TABLE', N'mom_eam_equipment_report_repair', + 'COLUMN', N'fault_hour' -- Gitblit v1.9.3