From d5bd77f78ac51618a70352ff49d362b111f85871 Mon Sep 17 00:00:00 2001
From: zenglf <18502938215@163.com>
Date: 星期六, 26 八月 2023 18:26:07 +0800
Subject: [PATCH] 设备分类表引用源头更新为mom_eam_equipment_category
---
db/eam/eam_permission.sql | 25 -------------------------
1 files changed, 0 insertions(+), 25 deletions(-)
diff --git a/db/eam/eam_permission.sql b/db/eam/eam_permission.sql
index 34b4d36..665b156 100644
--- a/db/eam/eam_permission.sql
+++ b/db/eam/eam_permission.sql
@@ -304,31 +304,6 @@
ALTER TABLE [dbo].[mom_base_enterprise_administrator] SET (LOCK_ESCALATION = TABLE)
GO
-CREATE TABLE [dbo].[mom_base_equipment_category] (
- [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL,
- [code] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [name] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [parent_id] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [equipment_category_uda1] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [equipment_category_uda2] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [equipment_category_uda3] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [equipment_category_uda4] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [equipment_category_uda5] nvarchar(64) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [create_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [create_time] datetime2(0) DEFAULT NULL NULL,
- [update_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [update_time] datetime2(0) DEFAULT NULL NULL,
- [del_flag] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- [enterprise_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS DEFAULT NULL NULL,
- CONSTRAINT [PK_mom_base_equipment_category_id] PRIMARY KEY CLUSTERED ([id])
- WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
- ON [PRIMARY]
- )
- GO
-
-ALTER TABLE [dbo].[mom_base_equipment_category] SET (LOCK_ESCALATION = TABLE)
- GO
CREATE TABLE [dbo].[mom_base_equipment_supplier] (
[id] nvarchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL,
--
Gitblit v1.9.3