agepoly-events/db/migrations/20260730020605_add_plan_to_events.sql
Antoine Pelletier 52363d59ac first commit
2026-07-30 06:26:31 +02:00

8 lines
269 B
SQL

-- migrate:up
-- Freeform site plan for the event, drawn on a map: a GeoJSON FeatureCollection.
ALTER TABLE events
ADD COLUMN plan JSONB NOT NULL DEFAULT '{"type": "FeatureCollection", "features": []}'::jsonb;
-- migrate:down
ALTER TABLE events DROP COLUMN plan;