From f4185f3c8cf71d613eb1a15928f2d8cf60027d68 Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期二, 21 十一月 2023 20:32:55 +0800
Subject: [PATCH] ABC评分签审
---
lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16(lnl)/sys_dict_update.sql | 445 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 445 insertions(+), 0 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 c7c6eea..3decf87 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"
@@ -5,3 +5,448 @@
UPDATE [dbo].[sys_dict_item] SET [dict_id] = N'1681127343392382977', [item_text] = N'瀹屾垚', [item_value] = N'4', [description] = '', [sort_order] = 4, [status] = 1, [create_by] = N'admin', [create_time] = '2023-07-18 10:23:48.0000000', [update_by] = N'admin', [update_time] = '2023-11-16 11:22:33.5730000' WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1681127599911821314';
UPDATE [dbo].[sys_dict_item] SET [dict_id] = N'1681127343392382977', [item_text] = N'楠屾敹', [item_value] = N'5', [description] = '', [sort_order] = 5, [status] = 1, [create_by] = N'admin', [create_time] = '2023-10-24 18:56:56.0000000', [update_by] = N'admin', [update_time] = '2023-11-16 14:21:48.9800000' WHERE CONVERT(NVARCHAR(MAX), [id]) = N'1716770747655516161';
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1725087877949898753', N'缁翠慨鐘舵��', N'repair_status', '', 0, N'admin', '2023-11-16 17:46:15.3370000', 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'1725087989132509185', N'1725087877949898753', N'姝ｅ父缁翠慨', N'normal', '', 1, 1, N'admin', '2023-11-16 17:46:41.8490000', 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'1725088326862061570', N'1725087877949898753', N'绛夊緟澶囦欢', N'needSpare', '', 2, 1, N'admin', '2023-11-16 17:48:02.3790000', 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'1725089103869460481', N'1725087877949898753', N'绛夊緟鍔犲伐浠�', N'needPart', '', 3, 1, N'admin', '2023-11-16 17:51:07.0000000', N'admin', '2023-11-16 17:51:13.7290000');
+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'1725089375681331201', N'1725087877949898753', N'甯︽晠闅滆繍琛�', N'working', '', 4, 1, N'admin', '2023-11-16 17:52:12.0000000', N'admin', '2023-11-16 17:52:18.4560000');
+
+ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ADD [accept_time] datetime2 NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ADD [finish_time] datetime2 NULL
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'楠屾敹鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment_report_repair',
+ 'COLUMN', N'accept_time'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'瀹屾垚鏃堕棿',
+ 'SCHEMA', N'dbo',
+ '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_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'
+ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [actual_hour] decimal(10,3) NULL
+ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [spare_time] decimal(18,3) NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_repair_order] ALTER COLUMN [part_time] decimal(18,3) NULL
+
+ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ALTER COLUMN [fault_hour] decimal(18,3) NULL
+
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1726425666842873858', N'1638420030147723265', N'鐢熶骇绾�', N'/eam/equipmentOfLine', N'eam/equipmentOfLine', NULL, NULL, 1, NULL, N'1', 11, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-11-20 10:22:09.0670000', NULL, NULL, 0, NULL, N'1', 0);
+
+ALTER TABLE [dbo].[mom_eam_equipment] ADD [line_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_meta] nvarchar(32) NULL
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇绾縄D',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment',
+ 'COLUMN', N'line_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鏄惁涓昏澶�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment',
+ 'COLUMN', N'is_meta'
+
+CREATE TABLE [dbo].[mom_eam_stream] (
+ [id] nvarchar NOT NULL,
+ [num] nvarchar NULL,
+ [status] nvarchar NULL,
+ [create_time] datetime2 NULL,
+ [create_by] nvarchar NULL,
+ [update_time] datetime2 NULL,
+ [update_by] nvarchar NULL,
+ [type] nvarchar NULL,
+ PRIMARY KEY CLUSTERED ([id])
+ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+ )
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'涓婚敭ID',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍗曟嵁鍙�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'num'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鐘舵��',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'status'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'create_time'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'create_by'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'淇敼鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'update_time'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'淇敼浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'update_by'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍗曟嵁绫诲瀷',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'type'
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [num] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [status] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [create_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [update_by] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_stream] ALTER COLUMN [type] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL
+ GO
+
+ IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'type')) > 0)
+ EXEC sp_updateextendedproperty
+ 'MS_Description', N'鍗曟嵁绫诲瀷',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'type'
+ ELSE
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍗曟嵁绫诲瀷',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream',
+ 'COLUMN', N'type'
+
+CREATE TABLE [dbo].[mom_eam_ABC_assessment] (
+ [id] nvarchar(32) NOT NULL,
+ [equipment_id] nvarchar(32) NULL,
+ [standard_a] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [standard_b] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [standard_c] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [standard_d] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [standard_e] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [standard_f] nvarchar(16) COLLATE Chinese_PRC_CI_AS NULL,
+ [stream_id] nvarchar(32) NULL,
+ [final] nvarchar(16) NULL,
+ PRIMARY KEY CLUSTERED ([id])
+ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+ )
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'璁惧ID',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'equipment_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'骞冲潎浣跨敤鐜囷紙鏁版嵁瀛楀吀锛欰BC-standardA锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_a'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙浛鎹㈡�э紙鏁版嵁瀛楀吀锛欰BC-standardB锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_b'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鏁呴殰褰卞搷搴︼紙鏁版嵁瀛楀吀锛欰BC-standardC锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_c'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇瓒呭樊搴︼紙鏁版嵁瀛楀吀锛欰BC-standardD锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_d'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鏁呴殰棰戠巼锛堟暟鎹瓧鍏革細ABC-standardE锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_e'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'璁惧浠峰�硷紙鏁版嵁瀛楀吀锛欰BC-standardF锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'standard_f'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'娴両D',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'stream_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'缁撴灉',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_ABC_assessment',
+ 'COLUMN', N'final'
+
+
+CREATE TABLE [dbo].[mom_eam_stream_operation] (
+ [id] nvarchar(32) NOT NULL,
+ [sort] int NULL,
+ [operation] nvarchar(16) NULL,
+ [source_id] nvarchar(32) NULL,
+ [user_id] nvarchar(32) NULL,
+ [stream_id] nvarchar(32) NULL,
+ [create_time] datetime2 NULL,
+ PRIMARY KEY CLUSTERED ([id])
+ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+ )
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鎺掑簭',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'sort'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鎿嶄綔',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'operation'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'涓婁竴姝ユ搷浣淚D',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'source_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鎿嶄綔浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'user_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'娴両D',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'stream_id'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鎿嶄綔鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'create_time'
+
+ EXEC sp_rename '[dbo].[mom_eam_ABC_assessment].[final]', 'final_standard', 'COLUMN'
+
+ ALTER TABLE [dbo].[mom_eam_stream_operation] ADD [remark] text NULL
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鎿嶄綔浜烘剰瑙�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_stream_operation',
+ 'COLUMN', N'remark'
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1726851458752135169', N'绛惧娴佽妭鐐�', N'stream_node', N'绛惧杩囩▼涓殑姣忎釜鑺傜偣', 0, N'admin', '2023-11-21 14:34:05.7720000', NULL, NULL, NULL);
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1726853242417659906', N'绛惧娴佹搷浣�', N'stream_operation', N'绛惧娴佽繃绋嬩腑鐨勬瘡涓�椤规搷浣�', 0, N'admin', '2023-11-21 14:41:11.0310000', NULL, NULL, NULL);
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1726858393618563073', N'ABC鏍囪瘑绛惧娴佽鑹茶妭鐐瑰搴旇〃', N'abc_stream_node_role', N'ABC鏍囪瘑绛惧娴侊紝瑙掕壊鑺傜偣瀵瑰簲琛�', 0, N'admin', '2023-11-21 15:01:39.1730000', NULL, NULL, NULL);
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1726861018934099969', N'绛惧娴佽妭鐐规搷浣滃搴旇〃', N'stream_node_operation', N'绛惧娴佽妭鐐规搷浣滃搴旇〃', 0, N'admin', '2023-11-21 15:12:05.1000000', NULL, NULL, NULL);
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1726937733580554241', N'绛惧鍗曠被鍒�', N'stream_type', '', 0, N'admin', '2023-11-21 20:16:55.2870000', 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'1726851540641726465', N'1726851458752135169', N'缂栧埗', N'create', '', 1, 1, N'admin', '2023-11-21 14:34:25.2960000', 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'1726852459756339202', N'1726851458752135169', N'瀹℃牳', N'audit', '', 2, 1, N'admin', '2023-11-21 14:38:04.0000000', N'admin', '2023-11-21 14:39:10.2050000');
+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'1726852939219812353', N'1726851458752135169', N'瀹℃壒', N'approve', '', 3, 1, N'admin', '2023-11-21 14:39:58.7430000', 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'1726853297715363842', N'1726853242417659906', N'鎻愪氦', N'submit', '', 1, 1, N'admin', '2023-11-21 14:41:24.2150000', 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'1726853426505662466', N'1726853242417659906', N'鎾ゅ洖', N'withdraw', '', 2, 1, N'admin', '2023-11-21 14:41:54.9210000', 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'1726853508193927170', N'1726853242417659906', N'閫氳繃', N'pass', '', 3, 1, N'admin', '2023-11-21 14:42:14.3970000', 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'1726853578452713474', N'1726853242417659906', N'椹冲洖', N'reject', '', 4, 1, N'admin', '2023-11-21 14:42:31.1480000', 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'1726858727195754498', N'1726858393618563073', N'ABCCREATEBY', N'create', '', 1, 1, N'admin', '2023-11-21 15:02:58.0000000', N'admin', '2023-11-21 15:03:37.6520000');
+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'1726858861585448961', N'1726858393618563073', N'ABCAUDITBY', N'audit', '', 2, 1, N'admin', '2023-11-21 15:03:30.0000000', N'admin', '2023-11-21 15:03:44.7730000');
+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'1726859777231372290', N'1726858393618563073', N'ABCAPPROVEBY', N'approve', '', 3, 1, N'admin', '2023-11-21 15:07:09.0000000', N'admin', '2023-11-21 15:07:18.2570000');
+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'1726861920705265665', N'1726861018934099969', N'submit,withdraw', N'create', N'缂栧埗锛堟彁浜わ紝鎾ゅ洖锛�', 1, 1, N'admin', '2023-11-21 15:15:40.0960000', 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'1726862430661328898', N'1726861018934099969', N'pass,reject', N'audit', N'瀹℃牳锛堥�氳繃锛岄┏鍥烇級', 2, 1, N'admin', '2023-11-21 15:17:41.6790000', 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'1726862706931744770', N'1726861018934099969', N'pass,reject', N'approve', N'瀹℃壒锛堥�氳繃锛岄┏鍥烇級', 2, 1, N'admin', '2023-11-21 15:18:47.5510000', 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'1726937880649629698', N'1726937733580554241', N'ABC璇勫垎绛惧', N'ABC', '', 1, 1, N'admin', '2023-11-21 20:17:30.3550000', NULL, NULL);
--
Gitblit v1.9.3