text: -- Adminer 4.8.1 MySQL 5.5.5-10.3.32-MariaDB-0ubuntu0.20.04.1 dump
  
  SET NAMES utf8;
  SET time_zone = '+00:00';
  SET foreign_key_checks = 0;
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  SET NAMES utf8mb4;
  
  CREATE DATABASE `garage` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  USE `garage`;
  
  DROP TABLE IF EXISTS `cars`;
  CREATE TABLE `cars` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `power` int(11) NOT NULL,
    `year` int(11) NOT NULL,
    `pack` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `picture` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` double(8,2) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `cars` (`id`, `brand`, `model`, `power`, `year`, `pack`, `description`, `picture`, `price`, `created_at`, `updated_at`) VALUES
  (19,	'Nissan',	'Cube',	90,	2000,	'Tout confort',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.',	'img/ffq55QBSSv4WVtMwrxzPh1X5AKp3La1nY5RdITTr.png',	4200.00,	'2022-01-19 10:36:26',	'2022-01-19 15:17:42'),
  (21,	'Citroen',	'DS',	75,	1962,	'Cuir élégant',	'Lorem Ipsum е елементарен примерен текст, използван в печатарската и типографската индустрия. Lorem Ipsum е индустриален стандарт от около 1500 година, когато неизвестен печатар взема няколко печатарски букви и ги разбърква, за да напечата с тях книга с примерни шрифтове. Този начин не само е оцелял повече от 5 века, но е навлязъл и в публикуването на електронни издания като е запазен почти без промяна. Популяризиран е през 60те години на 20ти век със издаването на Letraset листи, съдържащи Lorem Ipsum пасажи, популярен е и в наши дни във софтуер за печатни издания като Aldus PageMaker, който включва различни версии на Lorem Ipsum.',	'img/eodnjs6svr7A2S273DPsqHxT6id3Zvspt6y25Scw.jpg',	9000.00,	'2022-01-19 10:38:34',	'2022-01-19 10:38:34'),
  (22,	'Ford',	'Bucket',	100,	1964,	'Sport',	'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام \"هنا يوجد محتوى نصي، هنا يوجد محتوى نصي\" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال \"lorem ipsum\" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.',	'img/nRI8zmkD5Mhcz8vJt1e9GKWXxGlo0RhAn1QeSlNt.jpg',	15000.00,	'2022-01-19 10:40:30',	'2022-01-19 10:40:30'),
  (23,	'Mercedes',	'Classe S',	180,	2020,	'Prestige',	'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta) desconocido usó una galería de textos y los mezcló de tal manera que logró hacer un libro de textos especimen. No sólo sobrevivió 500 años, sino que tambien ingresó como texto de relleno en documentos electrónicos, quedando esencialmente igual al original. Fue popularizado en los 60s con la creación de las hojas \"Letraset\", las cuales contenian pasajes de Lorem Ipsum, y más recientemente con software de autoedición, como por ejemplo Aldus PageMaker, el cual incluye versiones de Lorem Ipsum.',	'img/Mc5NSCJIQQwK1ntcsy1ZmnywGh2RcbNVWB7namER.jpg',	22500.00,	'2022-01-19 10:41:29',	'2022-01-19 10:41:29'),
  (24,	'Audi',	'A1',	130,	2015,	'Sport pack',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsu',	'img/A3ehpZe7UoOrsfEuCKoqGyE8KphzWF6BcKauiQxx.png',	12000.00,	'2022-01-19 10:46:22',	'2022-01-19 10:46:22'),
  (25,	'Renault',	'Goelette',	70,	1975,	'Chantier',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsu',	'img/G1SaL9LluaW803UsnvuJhwKLO01l1dPuprL815v8.jpg',	2500.00,	'2022-01-19 10:47:36',	'2022-01-19 10:47:36'),
  (26,	'Renault',	'Primaquatre',	85,	1965,	'Elysée',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsu',	'img/kgNvPUR5gjj83hUvHVbcND8HrLrjTImQETxJze3T.jpg',	14500.00,	'2022-01-19 10:48:25',	'2022-01-19 10:48:25'),
  (27,	'Toyota',	'GT 86',	240,	2015,	'Indy',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsu',	'img/UYQ04JIcWV4zWGNb6bVqcWi9EPQxFAOqqc23fjfq.jpg',	32800.00,	'2022-01-19 10:49:15',	'2022-01-19 10:49:15'),
  (28,	'Toyota',	'Yaris',	80,	2018,	'Citadine',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsu',	'img/irDGRQPz0cxImXvMwAHPp1s31U4M76XnayOYLToD.jpg',	6420.00,	'2022-01-19 10:50:03',	'2022-01-19 10:50:03');
  
  DROP TABLE IF EXISTS `failed_jobs`;
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  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_08_19_000000_create_failed_jobs_table',	1),
  (4,	'2019_12_14_000001_create_personal_access_tokens_table',	1),
  (5,	'2022_01_18_202512_create_cars_table',	1),
  (6,	'2022_01_19_000000_create_users_table',	2);
  
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `personal_access_tokens`;
  CREATE TABLE `personal_access_tokens` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tokenable_id` bigint(20) unsigned NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
    `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_used_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
    KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) 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,
    `role` enum('user','admin') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`) VALUES
  (1,	'Julien',	'julienbailly08@gmail.com',	NULL,	'$2y$10$t1Km9Ffeb4rhbC3hJbbzfeIV8xWxxvoVK9Vl5TOxhLw.INMfIzB.K',	'pqO3FjVlHUgs3C7BbnlnNGlM5lOnyWkA1FOj2cMSfXHYdnj7I1o82e7Jnh27',	'2022-01-19 12:19:44',	'2022-01-19 12:19:44',	'user'),
  (2,	'Samuel',	'samuel@6tematik.fr',	NULL,	'$2y$10$z7lESZ8EzXGhWgys2Kro7.kWvKUNPjJNS/2vgzRhmXZoymsxln31m',	NULL,	'2022-01-19 13:49:24',	'2022-01-19 13:49:24',	'admin'),
  (3,	'Julien',	'julien@6tematik.fr',	NULL,	'$2y$10$AkjxVKL.I4JL..2M0Sd7HOekHd2rmWSv1fkcxrt9EAEvKh2nn7PQa',	NULL,	'2022-01-19 13:50:43',	'2022-01-19 13:50:43',	'admin');
  
  -- 2022-01-20 08:11:46
  