| | |
|---|
| | | alter table WorkPieceInfo ADD OutTime datetime, -- 出库时间 |
|---|
| | | OutPerson nvarchar(255), -- 出库人 |
|---|
| | | OutRemark nvarchar(255), -- 出库备注 |
|---|
| | | IsOut bit -- 是否出库 |
|---|
| | | 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) |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceOutbound Add CarNo nvarchar(255) -- 小车码 |
|---|
| | | alter table WorkPieceOutbound Add UnLineStage int |
|---|
| | | alter table WorkPieceOutbound Add UnLineStageName nvarchar(255) |
|---|
| | | alter table WorkPieceOutbound Add WorkPieceUnLineTime datetime |
|---|
| | | alter table WorkPieceOutbound Add WorkPieceUnLineUserId bigint |
|---|
| | | alter table WorkPieceOutbound Add WorkPieceUnLineUserName nvarchar(255) |
|---|
| | | |
|---|
| | | |
|---|
| | | -- 添加唯一索引 [Editby liuwq,2024-07-20] |
|---|
| | | IF EXISTS(select 1 from sysindexes where id=object_id('WorkPieceOutbound ') and name='idx_WorkPieceOutbound') |
|---|
| | | DROP INDEX idx_WorkPieceOutbound ON WorkPieceOutbound |
|---|
| | | CREATE UNIQUE INDEX |
|---|
| | | idx_WorkPieceOutbound ON WorkPieceOutbound (OP80NewCode) |
|---|
| | | GO |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceInfo Add UnLineStage int |
|---|
| | | alter table WorkPieceInfo Add UnLineStageName nvarchar(255) |
|---|
| | | alter table WorkPieceInfo Add WorkPieceUnLineTime datetime |
|---|
| | | alter table WorkPieceInfo Add WorkPieceUnLineUserId bigint |
|---|
| | | alter table WorkPieceInfo Add WorkPieceUnLineUserName nvarchar(255) |
|---|
