1-- Defines the Tasks table that is used to handle doxygen builds
2CREATE TABLE Tasks (
3    TaskID TEXT PRIMARY KEY,
4    State INTEGER NOT NULL,
5    Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
6    Configuration TEXT -- This column will store the JSON-encoded settings
7);
8
9-- Defines the Jobs that hold individual code snippets
10CREATE TABLE Jobs (
11    JobID TEXT PRIMARY KEY,
12    TaskID TEXT NOT NULL,
13    Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
14    -- Additional fields...
15    Configuration TEXT, -- This column will store the JSON-encoded settings
16    FOREIGN KEY (TaskID) REFERENCES Tasks(TaskID) ON DELETE CASCADE
17);