create_schema.sql

-- Schema for the BEGBot configuration.

-- Keeps track of the users and their privileges.
create table user (
    id          integer primary key autoincrement not null,
    username    text,
    firstname   text,
    lastname    text,
    telegram_id integer,
    added       date,
    beg         integer,
    admin       integer,
    bday        date
);

-- Keeps track of the sessions the bot is active/connected.
create table session (
    id          integer primary key autoincrement not null,
    start       date,
    end         date
);

-- Persists messages in an archive
create table message (
    id          integer primary key autoincrement not null,
    session_id  integer,
    message_id  integer,
    update_id   integer,
    telegram_id integer,
    group_id    integer,
    received    date,
    content     text
);