
/*------ ATD 280464 ------*/
-- Alterar estrutura tabela COMPLEMENTONFENTRA
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'COD_INF_COMPL' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='COMPLEMENTONFENTRA')) 
ALTER TABLE COMPLEMENTONFENTRA ADD COD_INF_COMPL CHAR(06) NULL DEFAULT ''
go

-- Alterar estrutura tabela COMPLEMENTONFSAIDA
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'COD_INF_COMPL' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='COMPLEMENTONFSAIDA')) 
ALTER TABLE COMPLEMENTONFSAIDA ADD COD_INF_COMPL CHAR(06) NULL DEFAULT ''
go

-- Alterar estrutura tabela COMPLEMENTONFENTRA
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'DES_INF_COMPL' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='COMPLEMENTONFENTRA')) 
ALTER TABLE COMPLEMENTONFENTRA ADD DES_INF_COMPL VARCHAR(254) NULL DEFAULT ''
go

-- Alterar estrutura tabela COMPLEMENTONFSAIDA
IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE name = 'DES_INF_COMPL' and syscolumns.id IN (SELECT ID FROM SYSOBJECTS WHERE xtype='U' AND name='COMPLEMENTONFSAIDA')) 
ALTER TABLE COMPLEMENTONFSAIDA ADD DES_INF_COMPL VARCHAR(254) NULL DEFAULT ''
go
