0004_task_logs.up.sql

1CREATE TABLE task_logs (
2    id INTEGER PRIMARY KEY AUTOINCREMENT,
3    task_id TEXT NOT NULL,
4    timestamp TEXT NOT NULL,
5    body TEXT NOT NULL,
6    FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
7);