ALTER TABLE EquipmentBaseInfo ADD CuttingFluidChangeTime Datetime2 NUll --增加设备切削液更换时间【Editby baotian,2023-3-9】 ALTER TABLE EquipmentBaseInfo ADD CuttingFluidChangeAlertThreshold int NUll --增加设备切削液预警阈值【Editby baotian,2023-3-9】 ALTER TABLE EquipmentBaseInfo ADD EquipmentCurrentMonitor bit NUll --增加是否关闭设备告警【Editby baotian,2023-3-10】 ALTER TABLE WorkPieceInfo ADD WorkPieceLastOfflineTime datetime NUll --增加工件完工时间【Editby baotian,2023-3-10】 --20231024 ALTER TABLE WorkPieceProcess ADD OperationType nvarchar(50); ALTER TABLE WorkPieceProcess ADD Remarks nvarchar(255); ALTER TABLE QualityDataInfo ADD OP10QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP20QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP30QualityStateCH3 nvarchar(32); ALTER TABLE QualityDataInfo ADD OP30QualityStateCH4 nvarchar(32); ALTER TABLE QualityDataInfo ADD OP30QualityStateCH5 nvarchar(32); ALTER TABLE QualityDataInfo ADD OP30QualityStateCH6 nvarchar(32); ALTER TABLE QualityDataInfo ADD OP30QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP40QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP60QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP80QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP10QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP20QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP30QualityReceiveTimeCH3 DateTime; ALTER TABLE QualityDataInfo ADD OP30QualityReceiveTimeCH4 DateTime; ALTER TABLE QualityDataInfo ADD OP30QualityReceiveTimeCH5 DateTime; ALTER TABLE QualityDataInfo ADD OP30QualityReceiveTimeCH6 DateTime; ALTER TABLE QualityDataInfo ADD OP30QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP40QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP60QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP80QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP10QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP20QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP30QualityStateCH3 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP30QualityStateCH4 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP30QualityStateCH5 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP30QualityStateCH6 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP30QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP40QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP60QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP80QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP10QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP20QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP30QualityReceiveTimeCH3 DateTime; ALTER TABLE QualityDataInfoLog ADD OP30QualityReceiveTimeCH4 DateTime; ALTER TABLE QualityDataInfoLog ADD OP30QualityReceiveTimeCH5 DateTime; ALTER TABLE QualityDataInfoLog ADD OP30QualityReceiveTimeCH6 DateTime; ALTER TABLE QualityDataInfoLog ADD OP30QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP40QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP60QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP80QualityReceiveTime DateTime; ALTER TABLE QualityDataInfo ADD OP35QualityState nvarchar(32); ALTER TABLE QualityDataInfo ADD OP35QualityReceiveTime DateTime; ALTER TABLE QualityDataInfoLog ADD OP35QualityState nvarchar(32); ALTER TABLE QualityDataInfoLog ADD OP35QualityReceiveTime DateTime; --20231029 ALTER TABLE EquipmentCurrentMonitor ADD WarnType nvarchar(32) NUll --增加告警代码【Editby baotian,2023-10-29】 ALTER TABLE WorkPieceProcess ALTER COLUMN QualityDataInfoID bigint; ALTER TABLE WorkPieceInfoLog ADD LogAddTime DateTime; ALTER TABLE WorkPieceInfoLog ADD LogAddRemark nvarchar(255) NUll ALTER TABLE WorkPieceInfoLog ADD CompleteTime DateTime --20231101 ALTER TABLE EquipmentCurrentMonitor ADD WarnTime datetime2;--新增告警时间 message时间 ALTER TABLE EquipmentCurrentMonitor ADD Warnmsg nvarchar(max);--新增告警内容 message ALTER TABLE EquipmentWorkingLog ADD WarnType nvarchar(max);--新增告警类型 message时间 ALTER TABLE EquipmentWorkingLog ADD Warnmsg nvarchar(max);--新增告警内容 message ALTER TABLE EquipmentWorkingLog ADD UpdateDesc nvarchar(255);--新增变更描述 ALTER TABLE EquipmentWorkingLog ADD WarnStartTime datetime2;--新增告警时间 message时间 ALTER TABLE EquipmentWorkingLog ADD WarnEndTime datetime2;--新增告警时间 message时间 ALTER TABLE EquipmentWorkingLog ADD EquipmentState nvarchar(32); ALTER TABLE EquipmentWorkingLog ADD EquipmentStateStartTime datetime2;--新增状态开始时间 message时间 ALTER TABLE EquipmentWorkingLog ADD EquipmentStateEndTime datetime2;--新增状态结束时间 message时间 ALTER TABLE WorkPieceInfo ADD WorkingProcedureEndTime datetime2;--新增g工序结束时间 ALTER TABLE WorkPieceInfoLog ADD WorkingProcedureEndTime datetime2;--新增工序结束时间 --WorkPieceInfoLog表相关字段全部可空 USE [iWare.SCADA] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EquipmentFailureCode]') AND type in (N'U')) DROP TABLE [dbo].[EquipmentFailureCode]; CREATE TABLE [dbo].[EquipmentFailureCode]( [Id] [bigint] NOT NULL, EquipmentID VARCHAR(255), WorkingProcedure VARCHAR(255), Code VARCHAR(255), CodeType VARCHAR(255), CodeLevel VARCHAR(255), CodeDesc VARCHAR(255), [Remarks] [nvarchar](255) NULL, [CreatedTime] [datetimeoffset](7) NULL, [UpdatedTime] [datetimeoffset](7) NULL, [CreatedUserId] [bigint] NULL, [CreatedUserName] [nvarchar](50) NULL, [UpdatedUserId] [bigint] NULL, [UpdatedUserName] [nvarchar](50) NULL, [IsDeleted] [bit] NOT NULL ); EXEC sp_addextendedproperty 'MS_Description', '告警故障代码表;', 'SCHEMA', dbo, 'table', EquipmentFailureCode, null, null; EXEC sp_addextendedproperty 'MS_Description', '设备代号', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', EquipmentID; EXEC sp_addextendedproperty 'MS_Description', '设备所属工序', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', WorkingProcedure; EXEC sp_addextendedproperty 'MS_Description', '代号', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', Code; EXEC sp_addextendedproperty 'MS_Description', '代号类型（1：故障 2：告警）', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', CodeType; EXEC sp_addextendedproperty 'MS_Description', '代号级别（1,2,3级）', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', CodeLevel; EXEC sp_addextendedproperty 'MS_Description', '代号描述', 'SCHEMA', dbo, 'table', EquipmentFailureCode, 'column', CodeDesc; --20231109 alter table WorkPieceInfo ADD OP80NewCode nvarchar(255) --OP80重新打印二维码 alter table WorkPieceInfoLog ADD OP80NewCode nvarchar(255) --OP80重新打印二维码 --20231114 ALTER TABLE EquipmentCurrentMonitor ALTER COLUMN Alertmsg nvarchar(max); ALTER TABLE EquipmentWorkingLog ALTER COLUMN FailureMsg nvarchar(max); --20231121 ALTER TABLE QualityDataInfo ADD OP30QualityFilePathCH3 nvarchar(900); ALTER TABLE QualityDataInfo ADD OP30QualityFilePathCH4 nvarchar(900); ALTER TABLE QualityDataInfo ADD OP30QualityFilePathCH5 nvarchar(900); ALTER TABLE QualityDataInfo ADD OP30QualityFilePathCH6 nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP30QualityFilePathCH3 nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP30QualityFilePathCH4 nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP30QualityFilePathCH5 nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP30QualityFilePathCH6 nvarchar(900); --20231123 ALTER TABLE KnifeToolBaseInfo ADD KnifeToolChangeAlertThreshold int; --刀具预警阈值 --20231205 ALTER TABLE v_get_equipment_alert ADD DetergentDesc nvarchar(900); ALTER TABLE v_get_equipment_alert ADD KnifeToolDesc nvarchar(900); ALTER TABLE v_get_equipment_alert ADD CuttingFluidDesc nvarchar(900); ALTER TABLE v_get_equipment_alert ADD AlertDesc nvarchar(max); --20231206 ALTER TABLE QualityDataInfo ADD QualityOP40To1 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP40To1 nvarchar(32); --20231207 ALTER TABLE EquipmentBaseInfo ADD TactTime int; --生产节拍 --20231216 ALTER TABLE QualityDataInfo ADD QualityOP80To10 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP80To10 nvarchar(32); ALTER TABLE QualityDataInfo ADD QualityOP30To8 nvarchar(32); ALTER TABLE QualityDataInfo ADD QualityOP30To9 nvarchar(32); ALTER TABLE QualityDataInfo ADD QualityOP30To10 nvarchar(32); ALTER TABLE QualityDataInfo ADD QualityOP30To11 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP30To8 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP30To9 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP30To10 nvarchar(32); ALTER TABLE QualityDataInfoLog ADD QualityOP30To11 nvarchar(32); ALTER TABLE KnifeToolEquipmentUpdateLog ADD OperateType nvarchar(32); ALTER TABLE QualityDataInfo ADD OP80QualityFilePath nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP80QualityFilePath nvarchar(900); ALTER TABLE QualityDataInfo ADD OP60QualityFilePath nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP60QualityFilePath nvarchar(900); ALTER TABLE QualityDataInfo ADD OP20QualityFilePath nvarchar(900); ALTER TABLE QualityDataInfoLog ADD OP20QualityFilePath nvarchar(900); ALTER TABLE EquipmentBaseInfo Add DetergentAddtime datetime, -- 清洗液添加时间 【Editby shaocx,2024-06-11】 CuttingFluidAddTime datetime -- 切削液添加时间 【Editby shaocx,2024-06-11】 --新增OP80的一些质量数据 【Editby shaocx,2024-06-13】 ALTER TABLE QualityDataInfo Add QualityOP80_Houdu nvarchar(15), -- OP80 质量数据-厚度 QualityOP80_ZXJ nvarchar(15),-- OP80 质量数据-中心距 QualityOP80_DTKYZD nvarchar(15),-- OP80 质量数据-大头孔圆柱度 QualityOP80_XTSMYD nvarchar(15),-- OP80 质量数据-小头上面圆度 QualityOP80_XTXMYD nvarchar(15),-- OP80 质量数据-小头下面圆度 QualityOP80_D_TKZJ nvarchar(15),-- OP80 质量数据-大头孔直径,大头孔直径=（大头上面X方向直径+大头上面Y方向直径+大头下面X方向直径+大头下面Y方向直径）/4 QualityOP80_D_S_X nvarchar(15),-- OP80 质量数据-大头上面X方向直径 QualityOP80_D_S_Y nvarchar(15),-- OP80 质量数据-大头上面Y方向直径 QualityOP80_D_X_X nvarchar(15),-- OP80 质量数据-大头下面X方向直径 QualityOP80_D_X_Y nvarchar(15),-- OP80 质量数据-大头下面Y方向直径 QualityOP80_X_TKZJ nvarchar(15),-- OP80 质量数据-小头孔直径,小头孔直径=（小头上面X方向直径+小头上面Y方向直径+小头下面X方向直径+小头下面Y方向直径）/4 QualityOP80_X_S_X nvarchar(15),-- OP80 质量数据-小头上面X方向直径 QualityOP80_X_S_Y nvarchar(15),-- OP80 质量数据-小头上面Y方向直径 QualityOP80_X_X_X nvarchar(15),-- OP80 质量数据-小头下面X方向直径 QualityOP80_X_X_Y nvarchar(15) -- OP80 质量数据-小头下面Y方向直径 ALTER TABLE QualityDataInfoLog Add QualityOP80_Houdu nvarchar(15), -- OP80 质量数据-厚度 QualityOP80_ZXJ nvarchar(15),-- OP80 质量数据-中心距 QualityOP80_DTKYZD nvarchar(15),-- OP80 质量数据-大头孔圆柱度 QualityOP80_XTSMYD nvarchar(15),-- OP80 质量数据-小头上面圆度 QualityOP80_XTXMYD nvarchar(15),-- OP80 质量数据-小头下面圆度 QualityOP80_D_TKZJ nvarchar(15),-- OP80 质量数据-大头孔直径,大头孔直径=（大头上面X方向直径+大头上面Y方向直径+大头下面X方向直径+大头下面Y方向直径）/4 QualityOP80_D_S_X nvarchar(15),-- OP80 质量数据-大头上面X方向直径 QualityOP80_D_S_Y nvarchar(15),-- OP80 质量数据-大头上面Y方向直径 QualityOP80_D_X_X nvarchar(15),-- OP80 质量数据-大头下面X方向直径 QualityOP80_D_X_Y nvarchar(15),-- OP80 质量数据-大头下面Y方向直径 QualityOP80_X_TKZJ nvarchar(15),-- OP80 质量数据-小头孔直径,小头孔直径=（小头上面X方向直径+小头上面Y方向直径+小头下面X方向直径+小头下面Y方向直径）/4 QualityOP80_X_S_X nvarchar(15),-- OP80 质量数据-小头上面X方向直径 QualityOP80_X_S_Y nvarchar(15),-- OP80 质量数据-小头上面Y方向直径 QualityOP80_X_X_X nvarchar(15),-- OP80 质量数据-小头下面X方向直径 QualityOP80_X_X_Y nvarchar(15) -- OP80 质量数据-小头下面Y方向直径 --新增获取QC数据标记 【Editby shaocx,2024-06-13】 ALTER TABLE WorkPieceProcess Add GetQcDataFlag int, -- 获取QC数据标记,0表示待获取，1表示获取成功，2表示获取失败 【Editby shaocx,2024-06-15】 GetQcDataCount int,-- 获取QC数据标记次数 【Editby shaocx,2024-06-15】 GetQcDataFlag_Remark nvarchar(100) -- 获取QC数据标记描述 【Editby shaocx,2024-06-15】 alter table WorkPieceInfo ADD OutTime datetime, -- 出库时间 OutPerson nvarchar(255), -- 出库人 OutRemark nvarchar(255), -- 出库备注 IsOut bit -- 是否出库 alter table WorkPieceInfo ADD QualityNoOk int, -- 质量不合格原因类型 QualityNoOkReason nvarchar(255), -- 质量不合格原因 alter table WorkPieceInfoLog ADD QualityNoOk int, -- 质量不合格原因类型 QualityNoOkReason nvarchar(255), -- 质量不合格原因 alter table WorkPieceLog ADD QualityNoOk int, -- 质量不合格原因类型 QualityNoOkReason nvarchar(255), -- 质量不合格原因 alter table WorkPieceProcess ADD QualityNoOk int, -- 质量不合格原因类型 QualityNoOkReason nvarchar(255), -- 质量不合格原因 -- QualityDataInfo alter table QualityDataInfo Add QualityNoOk_OP10 int alter table QualityDataInfo Add QualityNoOkReason_OP10 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP20 int alter table QualityDataInfo Add QualityNoOkReason_OP20 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP30 int alter table QualityDataInfo Add QualityNoOkReason_OP30 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP35 int alter table QualityDataInfo Add QualityNoOkReason_OP35 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP40 int alter table QualityDataInfo Add QualityNoOkReason_OP40 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP60 int alter table QualityDataInfo Add QualityNoOkReason_OP60 nvarchar(255) alter table QualityDataInfo Add QualityNoOk_OP80 int alter table QualityDataInfo Add QualityNoOkReason_OP80 nvarchar(255) -- QualityDataInfoLog alter table QualityDataInfoLog Add QualityNoOk_OP10 int alter table QualityDataInfoLog Add QualityNoOkReason_OP10 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP20 int alter table QualityDataInfoLog Add QualityNoOkReason_OP20 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP30 int alter table QualityDataInfoLog Add QualityNoOkReason_OP30 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP35 int alter table QualityDataInfoLog Add QualityNoOkReason_OP35 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP40 int alter table QualityDataInfoLog Add QualityNoOkReason_OP40 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP60 int alter table QualityDataInfoLog Add QualityNoOkReason_OP60 nvarchar(255) alter table QualityDataInfoLog Add QualityNoOk_OP80 int alter table QualityDataInfoLog Add QualityNoOkReason_OP80 nvarchar(255)