· 5 years ago · Oct 21, 2020, 08:32 AM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : baptisteheraud
5Source Server Version : 50505
6Source Host : db.baptisteheraud.com:3306
7Source Database : nsapool
8
9Target Server Type : MYSQL
10Target Server Version : 50505
11File Encoding : 65001
12
13Date: 2020-10-20 20:33:54
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `user`
20-- ----------------------------
21DROP TABLE IF EXISTS `user`;
22CREATE TABLE `user` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
25 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
26 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
27 `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
28 PRIMARY KEY (`id`),
29 UNIQUE KEY `UNIQ_8D93D649F85E0677` (`username`),
30 UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`)
31) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33-- ----------------------------
34-- Records of user
35-- ----------------------------
36INSERT INTO `user` VALUES ('1', 'Marvin42', 'marvin@epitech.eu', 'toto4242', 'a:1:{i:0;s:4:\"USER\";}');
37