text: -- phpMyAdmin SQL Dump
  -- version 4.9.2
  -- https://www.phpmyadmin.net/
  --
  -- Hôte : 127.0.0.1:3306
  -- Généré le :  lun. 18 mai 2020 à 08:33
  -- Version du serveur :  10.4.10-MariaDB
  -- Version de PHP :  7.3.12
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Base de données :  `crash_true_db`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `cartes`
  --
  
  DROP TABLE IF EXISTS `cartes`;
  CREATE TABLE IF NOT EXISTS `cartes` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `etat` tinyint(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    UNIQUE KEY `cartes_nom_unique` (`nom`) USING HASH
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Déchargement des données de la table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2020_05_18_031338_create_utilisateurs_table', 1),
  (2, '2020_05_18_053228_create_tournois_table', 1),
  (3, '2020_05_18_054440_create_cartes_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `tournois`
  --
  
  DROP TABLE IF EXISTS `tournois`;
  CREATE TABLE IF NOT EXISTS `tournois` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `date_tournoi` date NOT NULL,
    `utilisateurs_id` int(11) NOT NULL,
    `cartes_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `tournois_nom_unique` (`nom`) USING HASH,
    KEY `tournois_utilisateurs_id_foreign` (`utilisateurs_id`),
    KEY `tournois_cartes_id_foreign` (`cartes_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `utilisateurs`
  --
  
  DROP TABLE IF EXISTS `utilisateurs`;
  CREATE TABLE IF NOT EXISTS `utilisateurs` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `pseudo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `utilisateurs_email_unique` (`email`) USING HASH,
    UNIQUE KEY `utilisateurs_pseudo_unique` (`pseudo`) USING HASH
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  