IF NOT EXISTS(SELECT Name FROM Sysobjects WHERE Name = 'ClubCreditSetting')
BEGIN
	CREATE TABLE [dbo].[ClubCreditSetting](
		[Id] [SMALLINT] IDENTITY(1,1) NOT NULL,
		[StartDate] [SMALLDATETIME] NULL,
		[EndDate] [SMALLDATETIME] NULL,
		[DefinePrice] [MONEY] NULL,
		[Score] [SMALLINT] NULL,
		[ScoreType] [TINYINT] NULL DEFAULT(1),
		[IsDecimal] [BIT] NULL DEFAULT(1),
		[IsActive] [BIT] NULL DEFAULT(1),
	 CONSTRAINT [PK_ClubCreditSetting] PRIMARY KEY CLUSTERED 
	(
		[Id] ASC
	)
	) ON [PRIMARY]
END

