ALTER TABLE pet_animal ADD COLUMN numero_pedigree CHARACTER VARYING (50) NULL;
UPDATE pet_animal SET numero_pedigree = ' ' WHERE numero_pedigree IS NULL;
ALTER TABLE pet_animal ALTER COLUMN numero_pedigree SET NOT NULL;