Files
aggios.app/postgres/migrations/003_add_tenant_address_team_fields.sql

7 lines
259 B
SQL

-- Add structured address and team size fields to tenants
ALTER TABLE tenants
ADD COLUMN IF NOT EXISTS neighborhood TEXT,
ADD COLUMN IF NOT EXISTS number TEXT,
ADD COLUMN IF NOT EXISTS complement TEXT,
ADD COLUMN IF NOT EXISTS team_size TEXT;