From 8aa4ffc8a81a0a8d98bc89b969707c90a5c1fc53 Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期三, 31 一月 2024 14:37:53 +0800 Subject: [PATCH] 设备管理按照车间筛选和导出 --- lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16(lnl)/2023_11_24.sql | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql" "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql" index afe9f47..612d22f 100644 --- "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql" +++ "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql" @@ -19,3 +19,11 @@ 'SCHEMA', N'dbo', 'TABLE', N'mom_eam_equipment_report_repair', 'COLUMN', N'err_uda5' +ALTER TABLE [dbo].[sys_user] ADD [area_id] nvarchar(32) NULL + GO + + EXEC sp_addextendedproperty + 'MS_Description', N'涓績ID', + 'SCHEMA', N'dbo', + 'TABLE', N'sys_user', + 'COLUMN', N'area_id' -- Gitblit v1.9.3