| | |
|---|
| | | |
|---|
| | | 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) |
|---|
| | | |
|---|
| | | |
|---|
| | | -- 增加 对创建人、修改人的解释 [Editby shaocx,2024-08-31] |
|---|
| | | alter table WorkPieceLog Add DataCapturePointCname nvarchar(255) |
|---|
| | | alter table WorkPieceLog Add UpdateDataCapturePointCname nvarchar(255) |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceInfo Add DataCapturePointCname nvarchar(255) |
|---|
| | | alter table WorkPieceInfo Add UpdateDataCapturePointCname nvarchar(255) |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceProcess Add DataCapturePointCname nvarchar(255) |
|---|
| | | alter table WorkPieceProcess Add UpdateDataCapturePointCname nvarchar(255) |
|---|
| | | |
|---|
| | | alter table WorkPieceProcess Add MyRemarks nvarchar(255) -- 自我描述的备注 |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table AccessInterfaceLog Add WorkPieceID nvarchar(255) |
|---|
| | | alter table AccessInterfaceLog Add WorkingProcedureCurrent nvarchar(255) |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceLog Add MyRemarks nvarchar(255) -- 自我描述的备注 |
|---|
| | | |
|---|
| | | alter table WorkPieceLog Add PieceLogType int |
|---|
| | | alter table WorkPieceLog Add PieceLogTypeName nvarchar(255) |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table AccessInterfaceLog Add QualityState int |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceProcess Add Update70Flag int -- 需要更新70质量数据的标记 （ 1：需要更新 2：不需要更新） |
|---|
| | | |
|---|
| | | |
|---|
| | | alter table WorkPieceProcess Add JiaJuGongWei nvarchar(50) -- 夹具工位 |
|---|
| | | |
|---|
| | | alter table WorkPieceLog Add JiaJuGongWei nvarchar(50) -- 夹具工位 |
|---|
| | | |
|---|
