Implement database handlers

[CrescentKohana]

Use PSQL?

Goose should be good for the migrations regardless of the DB.
https://github.com/pressly/goose

• DB connection
• Migrations
• User handlers
• Reminder handlers
• Trigger handlers

[CrescentKohana]

TohsakaBot's SQL for reference.

create table tohsaka.highlights
(
    id               bigint auto_increment
        primary key,
    content          text        null,
    attachments      text        null,
    author_id        bigint      not null,
    timestamp        datetime    not null,
    deleted          tinyint(1)  not null,
    msg_id           bigint      not null,
    channel_id       bigint      not null,
    server_id        bigint      not null,
    highlight_msg_id bigint      not null,
    created_at       datetime(6) not null,
    updated_at       datetime(6) not null
)
    collate = utf8mb4_unicode_ci;

create table tohsaka.issues
(
    id         bigint auto_increment
        primary key,
    content    text               not null,
    category   int  default 0     not null,
    status     text default 'new' not null,
    user_id    bigint             not null,
    server_id  bigint             not null,
    created_at datetime(6)        not null,
    updated_at datetime(6)        not null
)
    collate = utf8mb4_unicode_ci;

create table tohsaka.linkeds
(
    id         bigint auto_increment
        primary key,
    category   text        null,
    url        text        null,
    timestamp  datetime    null,
    file_hash  text        null,
    idhash     text        null,
    author_id  bigint      null,
    server_id  bigint      null,
    channel_id bigint      null,
    msg_id     bigint      null,
    created_at datetime(6) not null,
    updated_at datetime(6) not null
)
    collate = utf8mb4_unicode_ci;

create table tohsaka.reminders
(
    id         bigint auto_increment
        primary key,
    datetime   datetime         not null,
    message    text             null,
    user_id    bigint           not null,
    channel_id bigint           null,
    `repeat`   bigint default 0 null,
    parent     bigint           null,
    created_at datetime(6)      not null,
    updated_at datetime(6)      not null,
    timezone   varchar(255)     null
);

create table tohsaka.schema_migrations
(
    version varchar(255) not null
        primary key
);

create table tohsaka.triggers
(
    id             bigint auto_increment
        primary key,
    phrase         text             not null,
    reply          text             null,
    file           text             null,
    user_id        bigint           not null,
    server_id      bigint           not null,
    chance         int    default 0 null,
    mode           int    default 0 null,
    occurrences    bigint default 0 not null,
    calls          bigint default 0 not null,
    last_triggered datetime         null,
    created_at     datetime(6)      not null,
    updated_at     datetime(6)      not null
);

create table tohsaka.trophies
(
    id          bigint auto_increment
        primary key,
    reason      text                 not null,
    duration    int                  not null,
    category    int        default 0 not null,
    discord_uid bigint               not null,
    server_id   bigint               not null,
    role_id     bigint               not null,
    expired     tinyint(1) default 0 not null,
    created_at  datetime(6)          not null,
    updated_at  datetime(6)          not null
)
    collate = utf8mb4_unicode_ci;

create table tohsaka.users
(
    id                  bigint auto_increment
        primary key,
    name                varchar(255)  not null,
    discriminator       int           null,
    avatar              varchar(255)  null,
    locale              varchar(255)  null,
    birthday            text          null,
    permissions         int           null,
    created_at          datetime(6)   not null,
    updated_at          datetime(6)   not null,
    last_congratulation int default 0 not null,
    timezone            varchar(255)  null
);

create index index_users_on_name
    on tohsaka.users (name);