index.js

// Configuration
const config = require('./config');
// Driver SQL
const Sequelize = require('sequelize');
const { Op } = require("sequelize");
// Couleurs de la console
var colors = require('colors');

// API discord
const { REST } = require('@discordjs/rest');
const { Routes } = require('discord-api-types/v9');

// Moment JS
var moment = require('moment');

// Schedule
const schedule = require('node-schedule');

////////////////////////////////////////////////////////////////
// MODELES DES TABLES
////////////////////////////////////////////////////////////////

// Connexion à la base de données
const sequelize = new Sequelize(config.get("BDD_NAME"), config.get("BDD_USER"), config.get("BDD_PASSWORD"), {
    host: config.get("BDD_HOST"),
    dialect: 'mariadb',
    logging: false,
});

// Paramètres du bot
const botSettings = sequelize.define('discord_settings', {
    name: { type: Sequelize.STRING(128), primaryKey: true },
    value: Sequelize.STRING(512),
}, {
    timestamps: false
});

// Paramètres des membres
const memberSettings = sequelize.define('discord_memberSettings', {
    memberId: { type: Sequelize.BIGINT(255), primaryKey: true },
    name: { type: Sequelize.STRING(128), primaryKey: true },
    value: Sequelize.STRING(512),
}, {
    timestamps: false
});

////////////////////////////////////////////////////////////////

const commands = [{
    name: 'ping',
    description: 'Répond avec pong!'
},
{
    name: 'setanniv',
    description: 'Permet de définir ta date d\'anniversaire (usage unique).',
    options: [{
        name: "date", // no uppercase as well
        description: "Date au format MM/DD/YYYY - 12/31/2001 - c'est relou je sais",
        type: 3,
        required: true
    }]
},
{
    name: 'delanniv',
    description: '[Admin] Supprime la date d\'anniversaire d\'un membre.',
    options: [{
        name: "membre", // no uppercase as well
        description: "Membre à supprimer la date d'anniversaire.",
        type: 6,
        required: true