text: -- phpMyAdmin SQL Dump
  -- version 4.8.4
  -- https://www.phpmyadmin.net/
  --
  -- Hôte : 127.0.0.1:3306
  -- Généré le :  Dim 03 fév. 2019 à 22:28
  -- Version du serveur :  5.7.24
  -- Version de PHP :  7.2.14
  
  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 :  `laravel`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `messages`
  --
  
  DROP TABLE IF EXISTS `messages`;
  CREATE TABLE IF NOT EXISTS `messages` (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `recipient_id` int(10) UNSIGNED NOT NULL,
    `sender_id` int(10) UNSIGNED NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Déchargement des données de la table `messages`
  --
  
  INSERT INTO `messages` (`id`, `content`, `recipient_id`, `sender_id`, `status`, `created_at`, `updated_at`) VALUES
  (1, 'Bonjour cv', 1, 2, 0, '2019-02-03 19:26:08', '2019-02-03 19:26:08'),
  (2, 'oui cv merci', 2, 1, 0, '2019-02-03 19:56:59', '2019-02-03 19:56:59'),
  (3, 'tout va bien?', 1, 2, 0, '2019-02-03 20:02:00', '2019-02-03 20:02:00'),
  (4, 'oui oui pour samedi', 2, 1, 0, '2019-02-03 21:00:30', '2019-02-03 21:00:30');
  
  -- --------------------------------------------------------
  
  --
  -- 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Déchargement des données de la table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2014_10_12_000000_create_users_table', 1),
  (2, '2014_10_12_100000_create_password_resets_table', 1),
  (3, '2019_02_03_170750_create_pictures_table', 1),
  (4, '2019_02_03_184119_create_messages_table', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `password_resets`
  --
  
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    UNIQUE KEY `password_resets_email_unique` (`email`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `pictures`
  --
  
  DROP TABLE IF EXISTS `pictures`;
  CREATE TABLE IF NOT EXISTS `pictures` (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `pictures_user_id_foreign` (`user_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Déchargement des données de la table `pictures`
  --
  
  INSERT INTO `pictures` (`id`, `source`, `user_id`, `created_at`, `updated_at`) VALUES
  (1, 'CmMLEhP7St.jpg', 1, '2019-02-03 16:45:20', '2019-02-03 16:45:20'),
  (5, 'FrY3NIKFPA.png', 1, '2019-02-03 17:37:41', '2019-02-03 17:37:41'),
  (4, 'Vxkx6E2Qnx.jpg', 1, '2019-02-03 17:37:31', '2019-02-03 17:37:31');
  
  -- --------------------------------------------------------
  
  --
  -- Structure de la table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `firstName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lastName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `birthdate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Déchargement des données de la table `users`
  --
  
  INSERT INTO `users` (`id`, `firstName`, `lastName`, `birthdate`, `address`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Nouraa', 'Nahed', '2019-02-05', 'Your address', 'nouioui_noura@yahoo.fr', NULL, '$2y$10$l5eRcmI.PP1kv3EicPMvNu93tzOsMa5MgRJ.bcHcRQrSqlRNozHMK', 'Bn2wK5NoQzkm0vdRjfcLEqf998rQrZy5WY0m4bZohC03mimYJT0dhvLaK4Gj', '2019-02-03 16:44:57', '2019-02-03 20:59:41'),
  (2, 'Nada', 'Nadou', '2019-02-04', 'Your address', 'noura-nahed1@live.fr', NULL, '$2y$10$IY6spXesMSJCdsHLgb8v5el18ddXpXrEfv5DQbFA/jbkjDYkjW1bO', 'iwkNEbCPSfKs8xi9Ybg8Y7j5OsOXkPWdBXmbrcHZWwHGMa56FVp07K4TjN2t', '2019-02-03 19:20:51', '2019-02-03 21:11:10'),
  (3, 'Nourane', 'Nounou', '2019-02-08', 'Your address', 'noor_e2f@live.fr', NULL, '$2y$10$Csxhj9FJcrrhROLEhVP9UuVjmUEgu5Eso85CHU01KjfYvaNLIwkkS', NULL, '2019-02-03 21:23:43', '2019-02-03 21:23:43');
  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 */;
  