Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'Drugh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'InternetVerificationUser')
  Alter Table Drugh Add InternetVerificationUser SMALLINT 
  
Select @Id = Id From sysobjects Where Name = 'Drugh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'PrescriptionUser')
  Alter Table Drugh Add PrescriptionUser SMALLINT 

SELECT @Id = Id From sysobjects Where Name = 'TmpDrugh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'InternetVerificationUser')
  Alter Table TmpDrugh Add InternetVerificationUser SMALLINT

Select @Id = Id From sysobjects Where Name = 'TmpDrugh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'PrescriptionUser')
  Alter Table TmpDrugh Add PrescriptionUser SMALLINT 
