From c964d3043846a0459b8d2aacdf2f76bf5be2ad79 Mon Sep 17 00:00:00 2001 From: lyh <925863403@qq.com> Date: 星期二, 02 九月 2025 18:03:13 +0800 Subject: [PATCH] 三级保养工作计划单 --- db/LYH/2025.09.02.sql | 34 ++++++++++++++++++++++++++++++++++ 1 files changed, 34 insertions(+), 0 deletions(-) diff --git a/db/LYH/2025.09.02.sql b/db/LYH/2025.09.02.sql new file mode 100644 index 0000000..bdb0e67 --- /dev/null +++ b/db/LYH/2025.09.02.sql @@ -0,0 +1,34 @@ +IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_third_maintenance_work_plan_sheet]') AND type in (N'U')) DROP TABLE [dbo].[eam_third_maintenance_work_plan_sheet]; +CREATE TABLE [dbo].[eam_third_maintenance_work_plan_sheet]( + id NVARCHAR(32) NOT NULL, + create_by NVARCHAR(50), + create_time DATETIME2, + update_by NVARCHAR(50), + update_time DATETIME2, + del_flag INT, + equipment_code NVARCHAR(255), + equipment_name NVARCHAR(255), + factory_org_code NVARCHAR(255), + equipment_model NVARCHAR(255), + maintenance_date DATETIME2, + hf_code NVARCHAR(255), + PRIMARY KEY (id) +); + +EXEC sp_addextendedproperty 'MS_Description', '涓夌骇淇濆吇宸ヤ綔璁″垝鍗�', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, null, null; +EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', id; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', create_by; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', create_time; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', update_by; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', update_time; +EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', del_flag; +EXEC sp_addextendedproperty 'MS_Description', '璁惧缁熶竴缂栧彿', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_code; +EXEC sp_addextendedproperty 'MS_Description', '璁惧鍚嶇О', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_name; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤閮ㄩ棬', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', factory_org_code; +EXEC sp_addextendedproperty 'MS_Description', '璁惧鍨嬪彿', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_model; +EXEC sp_addextendedproperty 'MS_Description', '淇濆吇鏃ユ湡', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', maintenance_date; +EXEC sp_addextendedproperty 'MS_Description', 'hf缂栫爜', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', hf_code; + + + +INSERT INTO [sys_dict_item]([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1962764933997375489', N'1941372067586695170', N'涓夌骇淇濆吇宸ヤ綔璁″垝鍗�', N'THIRD_MAINTENANCE_WORK_PLAN_SHEET', N'', 18, 1, N'admin', '2025-09-02 14:30:01.0000000', N'admin', '2025-09-02 14:36:28.3440000'); GO -- Gitblit v1.9.3