39 lines
1.9 KiB
Transact-SQL
39 lines
1.9 KiB
Transact-SQL
CREATE TABLE [dbo].[CRT_Data_1Minute] (
|
|
[CRTD_ID] INT IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
|
|
[CRTD_Period] DATETIME NOT NULL,
|
|
[CRTD_FirstQuote] DATETIME NOT NULL,
|
|
[CRTD_LastQuote] DATETIME NOT NULL,
|
|
[CRTD_PairSymbol] VARCHAR (50) NOT NULL,
|
|
[CRTD_BidOpeningValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidClosingValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidLowValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidHighValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidOpeningValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidClosingValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidLowValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidHighValue] FLOAT (53) NOT NULL,
|
|
[CRTD_DateIn] DATETIME CONSTRAINT [DF_CRT_Data_1Minute_CRTD_DateIn] DEFAULT (getdate()) NOT NULL,
|
|
[CRTD_Rows] INT NULL,
|
|
[ExchangeId] INT NOT NULL,
|
|
CONSTRAINT [PK_NC_dbo_CRT_Data_1Minute_#CRTD_ID] PRIMARY KEY NONCLUSTERED ([CRTD_ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [ix_CRTD_Period_INC]
|
|
ON [dbo].[CRT_Data_1Minute]([CRTD_Period] ASC)
|
|
INCLUDE([CRTD_LastQuote], [CRTD_PairSymbol]);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [IX_CRTD_PairSymbol_CRTD_Period_INC]
|
|
ON [dbo].[CRT_Data_1Minute]([CRTD_PairSymbol] ASC, [CRTD_Period] ASC)
|
|
INCLUDE([CRTD_FirstQuote], [CRTD_LastQuote], [CRTD_BidOpeningValue], [CRTD_BidClosingValue], [CRTD_BidLowValue], [CRTD_BidHighValue], [CRTD_MidOpeningValue], [CRTD_MidClosingValue], [CRTD_MidLowValue], [CRTD_MidHighValue]);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [IX_CRT_Data_1Minute_CRTD_PairSymbol_Period_INC]
|
|
ON [dbo].[CRT_Data_1Minute]([CRTD_PairSymbol] ASC, [CRTD_Period] DESC)
|
|
INCLUDE([CRTD_ID], [CRTD_BidOpeningValue], [CRTD_BidLowValue], [CRTD_BidHighValue], [CRTD_MidOpeningValue], [CRTD_MidLowValue], [CRTD_MidHighValue], [CRTD_BidClosingValue], [CRTD_MidClosingValue]);
|
|
|