create table category
(
    id   INTEGER not null
        constraint category_pk
            primary key autoincrement,
    name TEXT    not null
);

create table users
(
    id         INTEGER
        constraint users_pk
            primary key autoincrement,
    user_id    TEXT not null,
    start_time TEXT,
    username   TEXT default null,
    lang       TEXT default null
);

create table programs
(
    id       INTEGER not null
        constraint programs_pk
            primary key autoincrement,
    name     TEXT    not null,
    category TEXT,
    picture  TEXT,
    caption  TEXT default NULL
);