CREATE TABLE SecList_MutualFunds(

                                SMF_Symbol Varchar(15)  NOT NULL,

                                SMF_Description Varchar(40) Null,
                                SMF_Category  Varchar(20) Null,
                                SMF_PriceDate  datetime Null,
                                SMF_LatestPrice real Null,

                                SMF_MinInitInvest Real Null,
                                SMF_MinInitIRAInvest Real Null,

                                SMF_MinIncrInvest Real Null,
                                SMF_MinIncrIRAInvest Real Null,

                                SMF_HoldingsTurnOver real Null,
                                SMF_ExpenseRatioPct real Null,
                                SMF_12B1FeePct real Null,
                                SMF_FrontLoadPct real Null,
                                SMF_DeferredLoadPct real Null,
                                SMF_MinHoldPeriod integer Null,

                                SMF_LastDivDate datetime Null,
                                SMF_LastDivRate real Null,
                                SMF_LastCGDistDate datetime Null,
                                SMF_LastCGDist real Null,

                                SMF_LastStatDate  datetime Null,
                                SMF_EquityPct real Null,
                                SMF_FixedPct real Null,
                                SMF_PreferredPct real Null,
                                SMF_ConvertiblesPct real Null,
                                SMF_CashPct real Null,

                                SMF_AvgPriceEarnings real Null,
                                SMF_AvgPriceBook real Null,
                                SMF_AvgPriceSales real Null,
                                SMF_AvgPriceCF real Null,

                                SMF_RiskRating VarChar(20) Null,
                                SMF_YearsExp integer Null,
                                SMF_PctDownYears real Null,
                                SMF_WorstYear VarChar(16) Null,
                                SMF_Worst3Years VarChar(16) Null,
                                SMF_YTDReturn real Null,

                                SMF_3moReturn real Null,
                                SMF_1YrReturn real Null,
                                SMF_3YrReturn real Null,
                                SMF_5YrReturn real Null,

                                SMF_3moRankPct real Null,
                                SMF_1YrRankPct real Null,
                                SMF_3YrRankPct real Null,
                                SMF_5YrRankPct real Null,

                                SMF_3YrAlpha real Null,
                                SMF_5YrAlpha real Null,
                                SMF_10YrAlpha real Null,
                                SMF_3YrBeta real Null,
                                SMF_5YrBeta real Null,
                                SMF_10YrBeta real Null,
                                SMF_3YrStdDev real Null,
                                SMF_5YrStdDev real Null,
                                SMF_10YrStdDev real Null,
                                SMF_3YrSharpe real Null,
                                SMF_5YrSharpe real Null,
                                SMF_10YrSharpe real Null,
                                SMF_3YrTreynor real Null,
                                SMF_5YrTreynor real Null,
                                SMF_10YrTreynor real Null,
                                SMF_3YrRSqrd real Null,
                                SMF_5YrRSqrd real Null,
                                SMF_10YrRSqrd real Null,

                                SMF_Holding1 VarChar(15) Null,
                                SMF_HoldingPct1 real Null,
                                SMF_HoldingYTDPct1 real Null,
                                SMF_Holding2 VarChar(15) Null,
                                SMF_HoldingPct2 real Null,
                                SMF_HoldingYTDPct2 real Null,
                                SMF_Holding3 VarChar(15) Null,
                                SMF_HoldingPct3 real Null,
                                SMF_HoldingYTDPct3 real Null,
                                SMF_Holding4 VarChar(15) Null,
                                SMF_HoldingPct4 real Null,
                                SMF_HoldingYTDPct4 real Null,
                                SMF_Holding5 VarChar(15) Null,
                                SMF_HoldingPct5 real Null,
                                SMF_HoldingYTDPct5 real Null,
                                SMF_Holding6 VarChar(15) Null,
                                SMF_HoldingPct6 real Null,
                                SMF_HoldingYTDPct6 real Null,
                                SMF_Holding7 VarChar(15) Null,
                                SMF_HoldingPct7 real Null,
                                SMF_HoldingYTDPct7 real Null,
                                SMF_Holding8 VarChar(15) Null,
                                SMF_HoldingPct8 real Null,
                                SMF_HoldingYTDPct8 real Null,
                                SMF_Holding9 VarChar(15) Null,
                                SMF_HoldingPct9 real Null,
                                SMF_HoldingYTDPct9 real Null,
                                SMF_HoldingA VarChar(15) Null,
                                SMF_HoldingPctA real Null,
                                SMF_HoldingYTDPctA real Null,

                                SMF_UtilsSectorPct real Null,
                                SMF_BusSvcSectorPct real Null,
                                SMF_FinSectorPct real Null,
                                SMF_TelecomSectorPct real Null,
                                SMF_MediaSectorPct real Null,
                                SMF_ConsumerSectorPct real Null,
                                SMF_EnergySectorPct real Null,
                                SMF_HardwareSectorPct real Null,
                                SMF_HealthSectorPct real Null,
                                SMF_SoftwareSectorPct real Null,
                                SMF_ConsumerSrvsSectorPct real Null,
                                SMF_IndustMatlsSectorPct real Null,
                                SMF_OtherSectorPct real Null,

                                SMF_Fixed_USGovtPct real Null,
                                SMF_Fixed_AAAPct real Null,
                                SMF_Fixed_AAPct real Null,
                                SMF_Fixed_APct real Null,
                                SMF_Fixed_BBBPct real Null,
                                SMF_Fixed_BBPct real Null,
                                SMF_Fixed_BPct real Null,
                                SMF_Fixed_BelowBPct real Null,
                                SMF_Fixed_OtherPct real Null,

                                SMF_DataSource Varchar(4) Null,
                                SMF_TempRecord bit Null default 0,
                                SMF_IsFrozen bit Null default 0,

				SMF_GrossDlrConcessPct real null,
				SMF_HousePct real null,
				SMF_RepPct real null,
				SMF_TwelveBOneSched varchar(30) null
                                                           );

ALTER TABLE [dbo].[SecList_MutualFunds] ADD
	CONSTRAINT [FK_SecList_MutualFunds_SecList_FixedData] FOREIGN KEY
	(
		[SMF_Symbol]
	) REFERENCES [dbo].[SecList_FixedData] (
		[SLF_Symbol]
	) ON DELETE CASCADE  ON UPDATE CASCADE
