photum/backend/internal/db/migrations/018_add_professional_address_fields.up.sql

5 lines
219 B
SQL

ALTER TABLE cadastro_profissionais
ADD COLUMN IF NOT EXISTS cep VARCHAR(10),
ADD COLUMN IF NOT EXISTS numero VARCHAR(20),
ADD COLUMN IF NOT EXISTS complemento VARCHAR(100),
ADD COLUMN IF NOT EXISTS bairro VARCHAR(100);