Add Column
Current Schema
CREATE TABLE availability_exceptions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL,
start_date TEXT NOT NULL,
end_date TEXT NOT NULL,
type TEXT NOT NULL DEFAULT 'blocked' CHECK(type IN ('blocked','extra')),
note TEXT,
created_at TIMESTAMP NOT NULL DEFAULT (datetime('now')),
FOREIGN KEY (trainer_id) REFERENCES trainers(id) ON DELETE CASCADE
)