INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1723954113436852225', N'故障报修生产状态', N'is_product', '', 0, N'admin', '2023-11-13 14:41:04.8270000', 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'1723954158332682241', N'1723954113436852225', N'是', N'yes', '', 1, 1, N'admin', '2023-11-13 14:41:15.5280000', 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'1723954211180912641', N'1723954113436852225', N'否', N'no', '', 2, 1, N'admin', '2023-11-13 14:41:28.1250000', NULL, NULL);

INSERT INTO [dbo].[mom_serial_number_map] ([id], [function_name], [begin_symbol], [enterprise_code], [year_format], [month_format], [day_format], [type], [identity_id], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1724247078361333761', N'质量隐患确认编码', N'ZLYH', NULL, N'yyyy', N'MM', N'dd', N'QuanlityConfirm', NULL, N'admin', '2023-11-14 10:05:13', NULL, NULL);

INSERT INTO [dbo].[mom_serial_number_map] ([id], [function_name], [begin_symbol], [enterprise_code], [year_format], [month_format], [day_format], [type], [identity_id], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1724247645238296578', N'故障单编码', N'GZD', NULL, N'yyyy', N'MM', N'dd', N'FaultInfo', NULL, N'admin', '2023-11-14 10:07:28', NULL, NULL);

ALTER TABLE [dbo].[mom_eam_fault_info] ALTER COLUMN [q_id] nvarchar(32) NULL


EXEC sp_rename '[dbo].[mom_eam_fault_info].[q_id]', 'quanlity_id', 'COLUMN'
GO

EXEC sp_rename '[dbo].[mom_eam_fault_info].[e_name]', 'equip_name', 'COLUMN'
GO

EXEC sp_rename '[dbo].[mom_eam_fault_info].[e_model]', 'equip_model', 'COLUMN'
GO

EXEC sp_rename '[dbo].[mom_eam_fault_info].[e_num]', 'equip_num', 'COLUMN'



ALTER TABLE [dbo].[mom_eam_fault_info] ADD [area2] nvarchar NULL
GO

EXEC sp_addextendedproperty
'MS_Description', N'工区工段',
'SCHEMA', N'dbo',
'TABLE', N'mom_eam_fault_info',
'COLUMN', N'area2'

ALTER TABLE [dbo].[mom_eam_fault_info] ADD [is_confirm] nvarchar(32) NULL
GO

ALTER TABLE [dbo].[mom_eam_fault_info] ALTER COLUMN [area2] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否确认结果',
'SCHEMA', N'dbo',
'TABLE', N'mom_eam_fault_info',
'COLUMN', N'is_confirm'

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1724336453128425473', N'变动因素', N'fault_change_factor', '', 0, N'admin', '2023-11-14 16:00:21.7040000', 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'1724336644833284098', N'1724336453128425473', N'刀具更换', N'knife', '', 1, 1, N'admin', '2023-11-14 16:01:07.4100000', 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'1724336717839339521', N'1724336453128425473', N'工艺更改', N'route', '', 2, 1, N'admin', '2023-11-14 16:01:24.0000000', N'admin', '2023-11-14 16:04:32.8520000');
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'1724336939080486914', N'1724336453128425473', N'加工程序更改', N'working', '', 3, 1, N'admin', '2023-11-14 16:02:17.0000000', N'admin', '2023-11-14 16:04:42.7430000');
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'1724337178042568705', N'1724336453128425473', N'刀具补偿更改', N'compensate', '', 4, 1, N'admin', '2023-11-14 16:03:14.0000000', N'admin', '2023-11-14 16:04:58.1120000');
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'1724337287635537922', N'1724336453128425473', N'零点偏值更改', N'zero', '', 5, 1, N'admin', '2023-11-14 16:03:40.0000000', N'admin', '2023-11-14 16:05:50.2990000');
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'1724337353716797441', N'1724336453128425473', N'参数修改', N'num', '', 6, 1, N'admin', '2023-11-14 16:03:56.0000000', N'admin', '2023-11-14 16:06:06.9790000');
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'1724337433375019009', N'1724336453128425473', N'其他因素', N'other', '', 7, 1, N'admin', '2023-11-14 16:04:15.0000000', N'admin', '2023-11-14 16:06:02.7960000');

INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1724340707398389762', N'事故发生原因分析的核对', N'opinion', '', 0, N'admin', '2023-11-14 16:17:16.0000000', N'admin', '2023-11-14 16:48:53.6570000', 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'1724340762796756993', N'1724340707398389762', N'同意', N'yes', '', 1, 1, N'admin', '2023-11-14 16:17:29.2180000', 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'1724340811664592897', N'1724340707398389762', N'不同意', N'no', '', 2, 1, N'admin', '2023-11-14 16:17:40.8600000', NULL, 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'1723878256194232322', N'1647845086853693442', N'故障确认单', N'/eam/FaultInfoList', N'eam/FaultInfoList', NULL, NULL, 1, NULL, N'1', 2.1, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-11-13 09:39:39.0470000', NULL, NULL, 0, NULL, N'1', 0);

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'1723876722224013314', N'1647845086853693442', N'产品质量隐患确认', N'/eam/QuanlityConfirmList', N'eam/QuanlityConfirmList', NULL, NULL, 1, NULL, N'1', 2, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2023-11-13 09:33:33.0000000', N'admin', '2023-11-13 09:35:44.5750000', 0, NULL, N'1', 0);

