CREATE TABLE IF NOT EXISTS posts (
    id integer primary key autoincrement not null,
    created_at datetime default CURRENT_TIMESTAMP,
    creator_id integer not null references users,

    title text not null,
    description text,
    content text,
    tags text
    -- public boolean
);

CREATE TABLE IF NOT EXISTS users (
    id  integer primary key autoincrement not null,
    created_at datetime default CURRENT_TIMESTAMP,
    name text,
    username text not null unique,
    password text
);