14 lines
462 B
SQL
14 lines
462 B
SQL
-- Migration for Story 3.1: URL Generation and Site Assignment
|
|
-- Run this on your development database to test the changes
|
|
-- The model updates will handle production automatically
|
|
|
|
-- Make custom_hostname nullable
|
|
ALTER TABLE site_deployments
|
|
MODIFY COLUMN custom_hostname VARCHAR(255) NULL;
|
|
|
|
-- Add unique constraint to pull_zone_bcdn_hostname
|
|
ALTER TABLE site_deployments
|
|
ADD CONSTRAINT uq_pull_zone_bcdn_hostname
|
|
UNIQUE (pull_zone_bcdn_hostname);
|
|
|