setup-database.js

const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('./botDatabase.db', (err) => {
    if (err) {
        console.error(err.message);
    }
});

db.serialize(() => {
    db.run(`CREATE TABLE IF NOT EXISTS servers (
        server_id TEXT PRIMARY KEY,
        welcome_channel NUMBER,
        goodbye_channel NUMBER,
        welcome_message TEXT,
        goodbye_message TEXT,
        welcome_enabled BOOLEAN DEFAULT FALSE,
        goodbye_enabled BOOLEAN DEFAULT FALSE,

        xp_gain_chance INTEGER DEFAULT 50,
        xp_increment_per_level INTEGER DEFAULT 10,
        initial_xp_for_level_up INTEGER DEFAULT 10,
        leveling_enabled BOOLEAN DEFAULT TRUE
    )`, (err) => {
        if (err) {
            console.error("Failed to ensure 'servers' table exists:", err.message);
        } else {
            console.log("'servers' table is ready.");
        }
    });

    db.run(`CREATE TABLE IF NOT EXISTS users (
        user_id TEXT PRIMARY KEY,
        birthday DATE,
        gender TEXT
    )`, (err) => {
        if (err) {
            console.error("Failed to ensure 'users' table exists:", err.message);
        } else {
            console.log("'users' table is ready.");
        }
    });

    db.run(`CREATE TABLE IF NOT EXISTS user_xp (
        user_id TEXT NOT NULL,
        server_id TEXT NOT NULL,
        xp INTEGER DEFAULT 0,
        level INTEGER DEFAULT 1,
        PRIMARY KEY (user_id, server_id),
        FOREIGN KEY (user_id) REFERENCES users(user_id)
    )`, (err) => {
        if (err) {
            console.error("Failed to ensure 'user_xp' table exists:", err.message);
        } else {
            console.log("'user_xp' table is ready.");
        }
    });

    db.run(`CREATE TABLE IF NOT EXISTS command_usage (
        command TEXT PRIMARY KEY,
        count INTEGER DEFAULT 0 NOT NULL
    )`, (err) => {
        if (err) {
            console.error("Failed to ensure 'command_usage' table exists:", err.message);
        } else {
            console.log("'command_usage' table is ready.");
        }
    });
});

db.close();