Files
seminarhof-e2e-mrfyfnqt/db/sqlite/0007-booking-status-dates.sql
2026-07-11 07:59:25 +02:00

7 lines
354 B
SQL

-- Status transition timestamps. Set by applyBookingTransition when each
-- bucket is entered for the first time. No backfill — existing rows get NULL.
ALTER TABLE booking ADD COLUMN reserved_at TEXT;
ALTER TABLE booking ADD COLUMN confirmed_at TEXT;
ALTER TABLE booking ADD COLUMN ended_at TEXT;
ALTER TABLE booking ADD COLUMN cancelled_at TEXT;