CREATE TABLE SecList_DividendHistory(
                                SDH_Sequence integer Identity(1,1) NOT NULL,
                                SDH_Symbol  Varchar(15)  NOT NULL,
                                SDH_Date datetime NOT NULL,
                                SDH_DividendCode  Varchar(3) NOT NULL,
                                SDH_ExDate  datetime Null,
                                SDH_AmountPerShare  Float Null,
                                SDH_QuantityPerShare  Float Null,
                                SDH_ReinvestPrice  Float Null,
                                SDH_XRate float Null default 1,
		    					SDH_DataSource VarChar(4) Null,
    							SDH_NoFracShares bit null default 0,
                                SDH_TempRecord bit null default 0,
                                SDH_IsFrozen bit null default 0,
                                SDH_Scheduled bit null default 0, 
                                CONSTRAINT PK_SecList_DividendHistory PRIMARY KEY CLUSTERED 
                                (SDH_Sequence)
                               );

ALTER TABLE [dbo].[SecList_DividendHistory] ADD
	CONSTRAINT [FK_SecList_DividendHistory_SecList_FixedData] FOREIGN KEY
	(
		[SDH_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE ON UPDATE CASCADE
