jrXgy4kz

1
2CREATE TABLE IF NOT EXISTS name (
3    id      BIGINT      NOT NULL PRIMARY KEY,
4    name    VARCHAR(255) NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS counter (
8    user_id     BIGINT  NOT NULL,
9    chat_id     BIGINT  NOT NULL,
10    commands    INT     DEFAULT 0,
11    gifs        INT     DEFAULT 0,
12    kiitos      INT     DEFAULT 0,
13    messages    INT     DEFAULT 0,
14    photos      INT     DEFAULT 0,
15    stickers    INT     DEFAULT 0,
16    year        INT     DEFAULT 0,
17    PRIMARY KEY (user_id, chat_id, year)
18);
19
20CREATE TABLE IF NOT EXISTS word (
21    user_id     BIGINT  NOT NULL,
22    chat_id     BIGINT  NOT NULL,
23    word        VARCHAR(30) NOT NULL,
24    count       INT DEFAULT 0,
25    PRIMARY KEY (user_id, chat_id, word)
26);
27
28CREATE TABLE IF NOT EXISTS blacklist (
29    user_id     BIGINT  NOT NULL
30);