ALTER TABLE par_replicacao
 ADD COLUMN replica_insert_update_fornecedor character varying(1);
 
UPDATE par_replicacao SET replica_insert_update_fornecedor = 'N' WHERE replica_insert_update_fornecedor IS NULL;

ALTER TABLE par_replicacao
 ALTER COLUMN replica_insert_update_fornecedor SET NOT NULL;
 
 
 INSERT INTO par_replicacao (
	
	 SELECT usufilial, '', usufilial, 'N', 'N', 'N', 'N'
	   FROM ctl_usuario
	  WHERE usufilial NOT IN(SELECT filial_par FROM par_replicacao WHERE filial_par = ctl_usuario.usufilial)
	GROUP BY usufilial
	
);