From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期四, 25 七月 2024 10:11:52 +0800 Subject: [PATCH] 调整sql --- 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