-- example#Task
CREATE TABLE tasks (
    id TEXT NOT NULL DEFAULT (lower(hex(randomblob(4))) || '-' || lower(hex(randomblob(2))) || '-4' || substr(lower(hex(randomblob(2))),2) || '-' || substr('89ab',abs(random()) % 4 + 1, 1) || substr(lower(hex(randomblob(2))),2) || '-' || lower(hex(randomblob(6)))),
    label TEXT,
    status TEXT CHECK(status IN ('closed', 'open')),
    priority INTEGER CHECK(priority IN (2, 1)),

    PRIMARY KEY (id)
);