
/*------ ATD 390191 ------*/
DECLARE v_count NUMBER:=0;
BEGIN
    SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE UPPER(table_name) = 'PRODUTO_ECOMMERCE' and UPPER(column_name) = 'BUSCARATUALIZACAOINTEGRADOR';
    IF v_count = 0 THEN
    EXECUTE IMMEDIATE 'ALTER TABLE PRODUTO_ECOMMERCE ADD BUSCARATUALIZACAOINTEGRADOR NUMBER(1) DEFAULT 0 NOT NULL';
    END IF;
END;