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