|
|
|
|
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);
|
|
|
|
|
|
|
|
|
|
