Samuele Locatelli
104 lines
4.5 KiB
Transact-SQL
104 lines
4.5 KiB
Transact-SQL
CREATE TABLE [dbo].[Odette_storico] (
|
|
[DataOraDelete] DATETIME NOT NULL,
|
|
[CampoUDC] NVARCHAR (50) NOT NULL,
|
|
[Campo1_1] NVARCHAR (50) NOT NULL,
|
|
[Campo1_2] NVARCHAR (50) NOT NULL,
|
|
[Campo1_3] NVARCHAR (50) NOT NULL,
|
|
[Campo1_4] NVARCHAR (50) NOT NULL,
|
|
[Campo1_5] NVARCHAR (50) NOT NULL,
|
|
[Campo2_1] NVARCHAR (50) NOT NULL,
|
|
[Campo2_2] NVARCHAR (50) NOT NULL,
|
|
[Campo2_3] NVARCHAR (50) NOT NULL,
|
|
[Campo2_4] NVARCHAR (50) NOT NULL,
|
|
[Campo2_5] NVARCHAR (50) NOT NULL,
|
|
[Campo3_1] NVARCHAR (50) NOT NULL,
|
|
[Campo3_2] NVARCHAR (50) NOT NULL,
|
|
[Campo3_3] NVARCHAR (50) NOT NULL,
|
|
[Campo3_4] NVARCHAR (50) NOT NULL,
|
|
[Campo3_5] NVARCHAR (50) NOT NULL,
|
|
[Campo4_1] NVARCHAR (50) NOT NULL,
|
|
[Campo4_2] NVARCHAR (50) NOT NULL,
|
|
[Campo4_3] NVARCHAR (50) NOT NULL,
|
|
[Campo4_4] NVARCHAR (50) NOT NULL,
|
|
[Campo4_5] NVARCHAR (50) NOT NULL,
|
|
[Campo5_1] NVARCHAR (50) NOT NULL,
|
|
[Campo5_2] NVARCHAR (50) NOT NULL,
|
|
[Campo5_3] NVARCHAR (50) NOT NULL,
|
|
[Campo5_4] NVARCHAR (50) NOT NULL,
|
|
[Campo5_5] NVARCHAR (50) NOT NULL,
|
|
[Campo6_1] NVARCHAR (50) NOT NULL,
|
|
[Campo6_2] NVARCHAR (50) NOT NULL,
|
|
[Campo6_3] NVARCHAR (50) NOT NULL,
|
|
[Campo6_4] NVARCHAR (50) NOT NULL,
|
|
[Campo6_5] NVARCHAR (50) NOT NULL,
|
|
[Campo7_1] NVARCHAR (50) NOT NULL,
|
|
[Campo7_2] NVARCHAR (50) NOT NULL,
|
|
[Campo7_3] NVARCHAR (50) NOT NULL,
|
|
[Campo7_4] NVARCHAR (50) NOT NULL,
|
|
[Campo7_5] NVARCHAR (50) NOT NULL,
|
|
[Campo8_1] NVARCHAR (50) NOT NULL,
|
|
[Campo8_2] NVARCHAR (50) NOT NULL,
|
|
[Campo8_3] NVARCHAR (50) NOT NULL,
|
|
[Campo8_4] NVARCHAR (50) NOT NULL,
|
|
[Campo8_5] NVARCHAR (50) NOT NULL,
|
|
[Campo9_1] NVARCHAR (50) NOT NULL,
|
|
[Campo9_2] NVARCHAR (50) NOT NULL,
|
|
[Campo9_3] NVARCHAR (50) NOT NULL,
|
|
[Campo9_4] NVARCHAR (50) NOT NULL,
|
|
[Campo9_5] NVARCHAR (50) NOT NULL,
|
|
[Campo10_1] NVARCHAR (50) NOT NULL,
|
|
[Campo10_2] NVARCHAR (50) NOT NULL,
|
|
[Campo10_3] NVARCHAR (50) NOT NULL,
|
|
[Campo10_4] NVARCHAR (50) NOT NULL,
|
|
[Campo10_5] NVARCHAR (50) NOT NULL,
|
|
[Campo11_1_1] NVARCHAR (50) NOT NULL,
|
|
[Campo11_1_2] NVARCHAR (50) NOT NULL,
|
|
[Campo11_1_3] NVARCHAR (50) NOT NULL,
|
|
[Campo11_1_4] NVARCHAR (50) NOT NULL,
|
|
[Campo11_1_5] NVARCHAR (50) NOT NULL,
|
|
[Campo11_2_1] NVARCHAR (50) NOT NULL,
|
|
[Campo11_2_2] NVARCHAR (50) NOT NULL,
|
|
[Campo11_2_3] NVARCHAR (50) NOT NULL,
|
|
[Campo11_2_4] NVARCHAR (50) NOT NULL,
|
|
[Campo11_2_5] NVARCHAR (50) NOT NULL,
|
|
[Campo12_1] NVARCHAR (50) NOT NULL,
|
|
[Campo12_2] NVARCHAR (50) NOT NULL,
|
|
[Campo12_3] NVARCHAR (50) NOT NULL,
|
|
[Campo12_4] NVARCHAR (50) NOT NULL,
|
|
[Campo12_5] NVARCHAR (50) NOT NULL,
|
|
[Campo13_1] NVARCHAR (50) NOT NULL,
|
|
[Campo13_2] NVARCHAR (50) NOT NULL,
|
|
[Campo13_3] NVARCHAR (50) NOT NULL,
|
|
[Campo13_4] NVARCHAR (50) NOT NULL,
|
|
[Campo13_5] NVARCHAR (50) NOT NULL,
|
|
[Campo14_1] NVARCHAR (50) NOT NULL,
|
|
[Campo14_2] NVARCHAR (50) NOT NULL,
|
|
[Campo14_3] NVARCHAR (50) NOT NULL,
|
|
[Campo14_4] NVARCHAR (50) NOT NULL,
|
|
[Campo14_5] NVARCHAR (50) NOT NULL,
|
|
[Campo15_1] NVARCHAR (50) NOT NULL,
|
|
[Campo15_2] NVARCHAR (50) NOT NULL,
|
|
[Campo15_3] NVARCHAR (50) NOT NULL,
|
|
[Campo15_4] NVARCHAR (50) NOT NULL,
|
|
[Campo15_5] NVARCHAR (50) NOT NULL,
|
|
[Campo16_1] NVARCHAR (50) NOT NULL,
|
|
[Campo16_2] NVARCHAR (50) NOT NULL,
|
|
[Campo16_3] NVARCHAR (50) NOT NULL,
|
|
[Campo16_4] NVARCHAR (50) NOT NULL,
|
|
[Campo16_5] NVARCHAR (50) NOT NULL,
|
|
[StatoOk] BIT NOT NULL,
|
|
[CodCS] NCHAR (2) NOT NULL,
|
|
[CodMag] NVARCHAR (2) CONSTRAINT [DF_Odette_storico_CodMag] DEFAULT ('') NOT NULL,
|
|
[GrpBolla] NVARCHAR (1) CONSTRAINT [DF_Odette_storico_GrpBolla] DEFAULT ('') NOT NULL,
|
|
[DataBolla] NUMERIC (8) CONSTRAINT [DF_Odette_storico_DataBolla] DEFAULT ((0)) NOT NULL,
|
|
[NumBolla] NUMERIC (6) CONSTRAINT [DF_Odette_storico_NumBolla] DEFAULT ((0)) NOT NULL,
|
|
[Particolare] NVARCHAR (15) CONSTRAINT [DF_Odette_storico_Particolare] DEFAULT ('') NOT NULL,
|
|
[CodLista] NVARCHAR (12) CONSTRAINT [DF_Odette_storico_CodLista] DEFAULT ('') NOT NULL
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [i_UDC]
|
|
ON [dbo].[Odette_storico]([CampoUDC] ASC);
|
|
|