mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
12 lines
695 B
SQL
12 lines
695 B
SQL
-- Add banner and card image fields to rides table
|
|
ALTER TABLE public.rides
|
|
ADD COLUMN IF NOT EXISTS banner_image_url TEXT,
|
|
ADD COLUMN IF NOT EXISTS banner_image_id TEXT,
|
|
ADD COLUMN IF NOT EXISTS card_image_url TEXT,
|
|
ADD COLUMN IF NOT EXISTS card_image_id TEXT;
|
|
|
|
-- Add comment to document the fields
|
|
COMMENT ON COLUMN public.rides.banner_image_url IS 'Full Cloudflare URL for banner image displayed on ride detail page';
|
|
COMMENT ON COLUMN public.rides.banner_image_id IS 'Cloudflare image ID for banner';
|
|
COMMENT ON COLUMN public.rides.card_image_url IS 'Full Cloudflare URL for card image displayed in listings';
|
|
COMMENT ON COLUMN public.rides.card_image_id IS 'Cloudflare image ID for card'; |