
/*------ ATD 379507 ------*/
IF NOT EXISTS (SELECT 1 FROM sys.default_constraints WHERE type = 'D' AND NAME = 'DF_OPEVICMLIF_GERARREGISTRO1200')
BEGIN
ALTER TABLE OPEVICMLIF ADD CONSTRAINT [DF_OPEVICMLIF_GERARREGISTRO1200]  DEFAULT (0) FOR [GERARREGISTRO1200]
END
GO 
IF NOT EXISTS (SELECT 1 FROM sys.default_constraints WHERE type = 'D' AND NAME = 'DF_OPEVICMLIF_BLOQUEARSPED')
BEGIN
ALTER TABLE OPEVICMLIF ADD CONSTRAINT [DF_OPEVICMLIF_BLOQUEARSPED]  DEFAULT (0) FOR [BLOQUEARSPED]
END
GO
/*------ ATD 379983 ------*/
IF not EXISTS (SELECT 1 FROM PARAMETRO_ECOMMERCE WHERE ID = 123) 
INSERT INTO PARAMETRO_ECOMMERCE(ID, RPLATAFORMA, NOME, NOMEINTERNO, TIPO, RLISTADEOBJETOS, INFORMACAOMU)
VALUES(123,7,'Obrigar ter cadastro do Market Place?','OBRIGAR_CADASTRO_MARKET_PLACE','C',7,'PA 379983')
go