kcvYyPgn

1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `books`;
11CREATE TABLE `books` (
12  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
13  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
14  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
15  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
16  `now` text COLLATE utf8mb4_unicode_ci NOT NULL,
17  `linkedin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
18  `validated` tinyint(1) NOT NULL,
19  `created_at` timestamp NULL DEFAULT NULL,
20  `updated_at` timestamp NULL DEFAULT NULL,
21  PRIMARY KEY (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
23
24
25DROP TABLE IF EXISTS `events`;
26CREATE TABLE `events` (
27  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
28  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
29  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
30  `date` datetime NOT NULL,
31  `user_id` int(11) NOT NULL,
32  `created_at` timestamp NULL DEFAULT NULL,
33  `updated_at` timestamp NULL DEFAULT NULL,
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
36
37INSERT INTO `events` (`id`, `title`, `description`, `date`, `user_id`, `created_at`, `updated_at`) VALUES
38(1,	'GALA GEA',	'Le GALA des GEA de l\'IUT Charlemagne se déroulera le 29 mars 2019 à la mairie de Nancy.',	'2019-03-29 00:00:00',	2,	'2019-03-10 08:58:09',	'2019-03-11 09:46:48');
39
40DROP TABLE IF EXISTS `jpos`;
41CREATE TABLE `jpos` (
42  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
43  `moment` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
44  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
45  `active` tinyint(1) NOT NULL,
46  `created_at` timestamp NULL DEFAULT NULL,
47  `updated_at` timestamp NULL DEFAULT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
50
51INSERT INTO `jpos` (`id`, `moment`, `address`, `active`, `created_at`, `updated_at`) VALUES
52(1,	'02 février 2019',	'2Ter Boulevard Charlemagne - 54000 Nancy',	1,	NULL,	'2019-03-11 09:42:15');
53
54DROP TABLE IF EXISTS `migrations`;
55CREATE TABLE `migrations` (
56  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
57  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
58  `batch` int(11) NOT NULL,
59  PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
61
62INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
63(1,	'2014_10_12_000000_create_users_table',	1),
64(2,	'2014_10_12_100000_create_password_resets_table',	1),
65(4,	'2019_03_10_085205_create_event_table',	2),
66(6,	'2019_03_10_100811_create_jpo_table',	3),
67(7,	'2019_03_10_103410_create_book_table',	4),
68(8,	'2019_03_16_100854_create_forum_table',	4);
69
70DROP TABLE IF EXISTS `password_resets`;
71CREATE TABLE `password_resets` (
72  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
73  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
74  `created_at` timestamp NULL DEFAULT NULL,
75  KEY `password_resets_email_index` (`email`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
77
78
79DROP TABLE IF EXISTS `questions`;
80CREATE TABLE `questions` (
81  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
82  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
83  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
84  `answered` tinyint(1) NOT NULL,
85  `asked_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
86  `ip` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
87  `created_at` timestamp NULL DEFAULT NULL,
88  `updated_at` timestamp NULL DEFAULT NULL,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
91
92
93DROP TABLE IF EXISTS `users`;
94CREATE TABLE `users` (
95  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
96  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
97  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
98  `email_verified_at` timestamp NULL DEFAULT NULL,
99  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
100  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
101  `created_at` timestamp NULL DEFAULT NULL,
102  `updated_at` timestamp NULL DEFAULT NULL,
103  PRIMARY KEY (`id`),
104  UNIQUE KEY `users_email_unique` (`email`)
105) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
106
107INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
108(1,	'Albrecht Jérémy',	'ajeremyalbrecht@gmail.com',	NULL,	'$2y$10$BeUwrVe0RwO8Mj2JZW5Ug.LMm0BChuwz5lAVuqPy9MY2As1Zbkoym',	NULL,	'2019-03-10 09:24:54',	'2019-03-10 09:24:54'),
109(2,	'Laetitia Tousch',	'ltousch@gmail.com',	NULL,	'$2y$10$G.dHh6LRLwdl5iPdagt94eNWwtWbi4j.HIjrEyGkJhDwsfkYZFgke',	NULL,	'2019-03-11 09:39:15',	'2019-03-11 09:39:15');
110
111-- 2019-03-16 10:50:34