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】