DECLARE @Id INT                               
SELECT @Id = Id FROM sysobjects Where Name = 'TmpDrugH'
IF NOT EXISTS(SELECT * FROM syscolumns WHERE id = @Id and Name = 'IsClub')
  ALTER TABLE dbo.TmpDrugH ADD IsClub BIT DEFAULT(0)

Select @Id = Id From sysobjects Where Name = 'Tbl_ClubH'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'IsMale')
  Alter Table dbo.Tbl_ClubH Add IsMale BIT DEFAULT(1) 

Select @Id = Id From sysobjects Where Name = 'Tbl_ClubH'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'BirthDate')
  Alter Table dbo.Tbl_ClubH Add BirthDate SMALLDATETIME


Select @Id = Id From sysobjects Where Name = 'Tbl_ScoreClub'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Score')
  Alter Table dbo.Tbl_ScoreClub Add Score Float


SELECT @Id = Id From sysobjects Where Name = 'Tbl_ScoreClub'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id_Havaleh')
  Alter Table dbo.Tbl_ScoreClub Add Id_Havaleh BIGINT
