Paddy
fa34a6c9fb
Concert posters already live on the public website, so events store a URL to an existing image rather than hosting an uploaded file.
10 lines
545 B
SQL
10 lines
545 B
SQL
-- Nachklang e.V. Feedback module — adds a per-event poster image URL.
|
|
-- Apply manually against the FEEDBACK_DB database, after 001_init.sql:
|
|
-- mysql -h <DB_HOST> -u <DB_USER> -p <FEEDBACK_DB> < 002_add_poster_image_url.sql
|
|
--
|
|
-- Stores a URL only (e.g. an existing nachklang.art poster image) rather
|
|
-- than an uploaded file — the concert posters already live on the public
|
|
-- website, so there is no need for the feedback app to host its own copy.
|
|
ALTER TABLE events
|
|
ADD COLUMN poster_image_url VARCHAR(500) NULL AFTER intro_text;
|