index.js

// Configuration
const config = require('./config');
// Driver SQL
const Sequelize = require('sequelize');
const { Op } = require("sequelize");
// API externe
const express = require('express')
const app = express()
var XMLHttpRequest = require('xhr2');
// 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
});

// Paramètres des joueurs MC
const minecraftPlayerSetting = sequelize.define('site_userSetting', {
    uuid: { type: Sequelize.STRING(36), primaryKey: true },
    name: { type: Sequelize.STRING(128), primaryKey: true },
    value: Sequelize.TEXT,
}, {
    timestamps: false,
    freezeTableName: true
});