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
});

// Entrées et sorties des membres
const entries = sequelize.define('discord_entries', {
	id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true },
	memberId: Sequelize.BIGINT(255),
	isJoin: Sequelize.BOOLEAN,
	date: Sequelize.DATE,
}, {
	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 DD/MM/YYYY - 31/12/2001",
        type: 3,
        required: true