DECLARE @Id Int                               

Select @Id = Id From sysobjects Where Name = 'ClubCreditSetting'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Service1')
  Alter Table ClubCreditSetting Add Service1 real Default(1) NULL
  
  Select @Id = Id From sysobjects Where Name = 'ClubCreditSetting'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Service2')
  Alter Table ClubCreditSetting Add Service2 real Default(1) NULL
  
    Select @Id = Id From sysobjects Where Name = 'ClubCreditSetting'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Service3')
  Alter Table ClubCreditSetting Add Service3 real Default(1) NULL
  
    
    Select @Id = Id From sysobjects Where Name = 'ClubCreditSetting'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Service4')
  Alter Table ClubCreditSetting Add Service4 real Default(1) Null