1
2
3
4
5
6
7
8
9
10
| CREATE TABLE IF NOT EXISTS tasks (
| id INTEGER PRIMARY KEY AUTOINCREMENT,
| user_id TEXT,
| platform TEXT,
| scheduled_time DATETIME,
| created_time DATETIME DEFAULT CURRENT_TIMESTAMP,
| task_done_time DATETIME,
| task_status TEXT DEFAULT 'pending', /* done failed*/
| note TEXT
| );
|
|
