CREATE TABLE SecList_PriceHistory(
                              SPH_Sequence integer Identity(1,1) NOT NULL,
                              SPH_Symbol  Varchar(15)  NOT NULL,
                              SPH_Date datetime NOT NULL,
                              SPH_Time  datetime NULL,
                              SPH_DataSource varchar(4) Null,
                              SPH_Open  real Null,
                              SPH_High  real Null,
                              SPH_Low   real Null,
                              SPH_Close  float Null,
                              SPH_Volume  real Null,
                              SPH_OpenInt  real Null,
                              SPH_TempRecord bit null default 0,
                              SPH_IsFrozen bit null default 0,
			      SPH_Close8 float null,
                              CONSTRAINT PK_SecList_PriceHistory PRIMARY KEY CLUSTERED
                              (SPH_Sequence)
                               );

ALTER TABLE [dbo].[SecList_PriceHistory] ADD
	CONSTRAINT [FK_SecList_PriceHistory_SecList_FixedData] FOREIGN KEY
	(
		[SPH_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE ON UPDATE CASCADE
