Samuele E. Locatelli
25 lines
953 B
SQL
25 lines
953 B
SQL
CREATE TABLE [tmp].[ProductionLogRaw_old] (
|
|
[EventStart] NVARCHAR (50) NOT NULL,
|
|
[EventEnd] NVARCHAR (50) NOT NULL,
|
|
[CodPlant] NVARCHAR (50) NOT NULL,
|
|
[ProcessNum] NVARCHAR (50) NOT NULL,
|
|
[NrPos] NVARCHAR (50) NOT NULL,
|
|
[CodDies] NVARCHAR (50) NOT NULL,
|
|
[CodClient] NVARCHAR (50) NOT NULL,
|
|
[OrderNum] NVARCHAR (50) NOT NULL,
|
|
[BatchNum] NVARCHAR (50) NOT NULL,
|
|
[ProcessType] NVARCHAR (50) NOT NULL,
|
|
[EventType] NVARCHAR (50) NOT NULL,
|
|
[RawMat] NVARCHAR (50) NOT NULL,
|
|
[CodPackag] NVARCHAR (50) NOT NULL,
|
|
[QtyIN] NVARCHAR (50) NOT NULL,
|
|
[QtyOUT] NVARCHAR (50) NOT NULL,
|
|
[QtyEXT] NVARCHAR (50) NOT NULL,
|
|
[NumIN] NVARCHAR (50) NOT NULL,
|
|
[NumOUT] NVARCHAR (50) NOT NULL,
|
|
[QuotaPlant] NVARCHAR (50) NOT NULL,
|
|
[QuotaMan] NVARCHAR (50) NOT NULL,
|
|
[Tags] NVARCHAR (250) NOT NULL
|
|
);
|
|
|