-- TAREFA 188896
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS C 
INNER JOIN SYS.TABLES T ON T.OBJECT_ID = C.OBJECT_ID 
WHERE T.NAME = 'TB_PROCESSO'
 AND C.NAME = 'PRC_EMAL_RELUSER') 
ALTER TABLE TB_PROCESSO ADD PRC_EMAL_RELUSER VARCHAR (255)  NULL 
GO

 -- TAREFA 188896
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS C 
INNER JOIN SYS.TABLES T ON T.OBJECT_ID = C.OBJECT_ID 
WHERE T.NAME = 'TB_PROCESSO'
 AND C.NAME = 'PRC_UNIDADE_EMALREL') 
ALTER TABLE TB_PROCESSO ADD PRC_UNIDADE_EMALREL VARCHAR (255)  NULL 
GO

 -- TAREFA 188896
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS C 
INNER JOIN SYS.TABLES T ON T.OBJECT_ID = C.OBJECT_ID 
WHERE T.NAME = 'TB_PROCESSO'
 AND C.NAME = 'PRC_MODULOEMAIL_REL') 
ALTER TABLE TB_PROCESSO ADD PRC_MODULOEMAIL_REL INTEGER NULL 
GO

 -- TAREFA 188896
IF NOT EXISTS (SELECT 1 FROM SYS.COLUMNS C 
INNER JOIN SYS.TABLES T ON T.OBJECT_ID = C.OBJECT_ID 
WHERE T.NAME = 'TB_PROCESSO'
 AND C.NAME = 'PRC_SUBNIVEL_ENSINO') 
ALTER TABLE TB_PROCESSO ADD PRC_SUBNIVEL_ENSINO VARCHAR (255)  NULL 
GO