Name	Name	Last commit message	Last commit date
parent directory ..
001_add_event_images.sql	001_add_event_images.sql
001_add_geofence_data.sql	001_add_geofence_data.sql
002_add_org_name_and_expiration.sql	002_add_org_name_and_expiration.sql
003_add_geofence_data.sql	003_add_geofence_data.sql
004_add_waypoints.sql	004_add_waypoints.sql
005_add_view_keycode.sql	005_add_view_keycode.sql
README.md	README.md

Name

Last commit message

Last commit date

Database Migrations

This folder contains database migration scripts for schema updates.

Running Migrations

Migrations need to be run manually on your PostgreSQL database. You can run them using:

psql -h <host> -U <user> -d <database> -f migrations/001_add_event_images.sql

Or using a PostgreSQL client of your choice.

Adds image_data column to events table (stores base64 encoded image)
Adds image_mime_type column to events table (stores MIME type like image/png)
Adds logo_data column to events table (stores base64 encoded logo)
Adds logo_mime_type column to events table (stores MIME type)
Removes old image_url and logo_url columns if they exist
All fields are optional (nullable)

Important: Images are now stored in the database as base64 data rather than external URLs

The API's _init.js automatically creates tables with the latest schema for new deployments
These migration files are for existing databases that were created with earlier schemas
Always backup your database before running migrations
Migrations use IF NOT EXISTS where possible to be safe to run multiple times