ALTER TABLE pet_animal_historico ADD COLUMN agenda integer; UPDATE pet_animal_historico SET agenda = 0 WHERE agenda IS NULL; ALTER TABLE pet_animal_historico ALTER COLUMN agenda SET NOT NULL; ALTER TABLE pet_aux_animal_historico ADD COLUMN agenda integer; UPDATE pet_aux_animal_historico SET agenda = 0 WHERE agenda IS NULL; ALTER TABLE pet_aux_animal_historico ALTER COLUMN agenda SET NOT NULL; ALTER TABLE pet_animal ADD COLUMN hora_ult_alteracao time without time zone ; UPDATE pet_animal SET hora_ult_alteracao = '00:00:00' WHERE hora_ult_alteracao IS NULL; ALTER TABLE pet_animal ALTER COLUMN hora_ult_alteracao SET NOT NULL;