Method createTables

src/utils/postgresDatabase.js:220–398

()

    }

    async createTables() {
        const tables = [
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.guilds} (
                id VARCHAR(20) PRIMARY KEY,
                config JSONB DEFAULT '{}',
                counters JSONB DEFAULT '[]',
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            )`,
            
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.users} (
                id VARCHAR(20) PRIMARY KEY,
                username VARCHAR(100),
                discriminator VARCHAR(10),
                avatar VARCHAR(100),
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            )`,
            
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.guild_users} (
                guild_id VARCHAR(20),
                user_id VARCHAR(20),
                joined_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                PRIMARY KEY (guild_id, user_id),
                FOREIGN KEY (guild_id) REFERENCES ${pgConfig.tables.guilds}(id) ON DELETE CASCADE,
                FOREIGN KEY (user_id) REFERENCES ${pgConfig.tables.users}(id) ON DELETE CASCADE
            )`,
            
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.birthdays} (
                guild_id VARCHAR(20),
                user_id VARCHAR(20),
                month INTEGER NOT NULL,
                day INTEGER NOT NULL,
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                PRIMARY KEY (guild_id, user_id),
                FOREIGN KEY (guild_id) REFERENCES ${pgConfig.tables.guilds}(id) ON DELETE CASCADE,
                FOREIGN KEY (user_id) REFERENCES ${pgConfig.tables.users}(id) ON DELETE CASCADE
            )`,
            
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.giveaways} (
                id SERIAL PRIMARY KEY,
                guild_id VARCHAR(20),
                message_id VARCHAR(20) NOT NULL,
                data JSONB NOT NULL,
                ends_at TIMESTAMP,
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                FOREIGN KEY (guild_id) REFERENCES ${pgConfig.tables.guilds}(id) ON DELETE CASCADE,
                UNIQUE(guild_id, message_id)
            )`,
            
            `CREATE TABLE IF NOT EXISTS ${pgConfig.tables.tickets} (
                guild_id VARCHAR(20),
                channel_id VARCHAR(20) PRIMARY KEY,
                data JSONB NOT NULL,
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,