Files
houston-be/db/migration/000004_add_jira_links_column.up.sql

9 lines
190 B
SQL

-- Add the new column
ALTER TABLE incident
ADD COLUMN IF NOT EXISTS jira_links text[] DEFAULT '{}'::text[];
-- Drop the old column
ALTER TABLE incident
DROP
COLUMN jira_id;