11 lines
668 B
SQL
11 lines
668 B
SQL
-- Migration: Add banner_url column to listings and service_listings
|
|
-- Run against fuelprices database:
|
|
-- docker run --rm postgres:15 psql "postgres://postgres:password@192.168.1.204:5432/fuelprices" -f /path/to/this/file
|
|
-- Or inline:
|
|
-- docker run --rm postgres:15 psql "postgres://postgres:password@192.168.1.204:5432/fuelprices" \
|
|
-- -c "ALTER TABLE listings ADD COLUMN IF NOT EXISTS banner_url VARCHAR(255);" \
|
|
-- -c "ALTER TABLE service_listings ADD COLUMN IF NOT EXISTS banner_url VARCHAR(255);"
|
|
|
|
ALTER TABLE listings ADD COLUMN IF NOT EXISTS banner_url VARCHAR(255);
|
|
ALTER TABLE service_listings ADD COLUMN IF NOT EXISTS banner_url VARCHAR(255);
|