schema.sql

CREATE TABLE IF NOT EXISTS chatbot (
    channel_id BIGINT PRIMARY KEY
);

CREATE TABLE IF NOT EXISTS levels_config (
    guild_id BIGINT PRIMARY KEY,
    channel_id BIGINT,
    ping TEXT
);

CREATE TABLE IF NOT EXISTS prefix (
    user_id BIGINT PRIMARY KEY,
    prefixes TEXT
);

CREATE TABLE IF NOT EXISTS users (
    user_id BIGINT PRIMARY KEY,
    guild_id BIGINT,
    xp INT,
    level INT,
    name TEXT
);

CREATE TABLE IF NOT EXISTS channels_config (
    channel_id BIGINT PRIMARY KEY,
    channel_types TEXT
);

CREATE TABLE IF NOT EXISTS snipe (
    id BIGINT PRIMARY KEY,
    channel_id BIGINT,
    user_id BIGINT,
    message_content TEXT,
    create_epoch DATE
);

CREATE TABLE IF NOT EXISTS edit_snipe (
    id BIGINT PRIMARY KEY,
    channel_id BIGINT,
    user_id BIGINT,
    before_content TEXT,
    after_content TEXT,
    create_epoch DATE
);

CREATE TABLE IF NOT EXISTS overall_score (
    score INT
);

CREATE TABLE IF NOT EXISTS general_data (
    create_epoch DATE,
    ping INT,
    users INT,
    guilds INT,
    channels INT,
    disnake_version INT
);