IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'confs'
               AND Column_Name = 'permitirmaisdeumainstanciadaaplicacao')
  ALTER TABLE DBO.confs ADD
    permitirmaisdeumainstanciadaaplicacao varchar(10) NULL
GO

IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'confs'
               AND Column_Name = 'md5')
  ALTER TABLE DBO.confs ADD
    md5 varchar(50) NULL
GO

IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'confs'
               AND Column_Name = 'addrstorage')
  ALTER TABLE DBO.confs ADD
    addrstorage varchar(200) NULL
GO

IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'notas'
               AND Column_Name = 'storage')
  ALTER TABLE DBO.notas ADD
    storage int not null default -1 
GO

IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'confs'
               AND Column_Name = 'usaloginunicoenvioemails')
  ALTER TABLE DBO.confs ADD
    usaloginunicoenvioemails varchar(10) null 
GO

IF NOT EXISTS (SELECT Column_Name FROM Information_Schema.columns
               WHERE Table_Name = 'confs'
               AND Column_Name = 'minutosenvioemails')
  ALTER TABLE DBO.confs ADD
    minutosenvioemails int not null default 15
GO

if not Exists (Select Column_Name from Information_Schema.columns
               Where Table_Name = 'cnpj'
               And Column_Name = 'idcsc')
  ALTER TABLE dbo.cnpj ADD
  idcsc VARCHAR(10) NULL

GO

if not Exists (Select Column_Name from Information_Schema.columns
               Where Table_Name = 'cnpj'
               And Column_Name = 'csc')
  ALTER TABLE dbo.cnpj ADD
  csc VARCHAR(50) NULL