Fix #43 – Planning INTERNAL SERVER ERROR for existing installations
Problem: Users who upgraded from an earlier version were missing the location and specific_date columns on the schedule_entries table, causing an Internal Server Error on the planning page. The CHECK(end_time > start_time) constraint also blocked cross-midnight schedules.
Fix: The server now automatically runs idempotent migrations at startup:
ALTER TABLE schedule_entries DROP CONSTRAINT IF EXISTS schedule_entries_checkALTER TABLE schedule_entries ADD COLUMN IF NOT EXISTS specific_date DATEALTER TABLE schedule_entries ADD COLUMN IF NOT EXISTS location TEXT
Upgrade: Simply pull the latest image and restart - no manual SQL needed.