mUXc9Ldv

1-- Host: localhost
2-- Base de données :  `my_meetic`
3--
4
5-- --------------------------------------------------------
6
7DROP DATABASE IF EXISTS my_meetic;
8CREATE DATABASE my_meetic;
9
10USE my_meetic;
11
12-- --------------------------------------------------------
13--
14-- Table structure for table `member`
15--
16
17DROP TABLE IF EXISTS `member`;
18
19CREATE TABLE `member` (
20	`id_user` int(11) NOT NULL AUTO_INCREMENT,
21	`pseudonyme` varchar(16) NOT NULL,
22	`password` varchar(128) NOT NULL,
23	`mail`  varchar(255) NOT NULL,
24	`surname` varchar(30) NOT NULL,
25	`name` varchar(30) NOT NULL,
26	`gender` varchar(25) NOT NULL,
27	`ville` text NOT NULL,
28	`birthday` date NOT NULL,
29--  `avatar` varchar(255),
30	`grade` int(11) NOT NULL DEFAULT '1',
31	`confirm_mail` int(11) NOT NULL DEFAULT '0',
32	`status` int(11) NOT NULL DEFAULT '0',
33	PRIMARY KEY(`id_user`)
34) ENGINE=MyISAM DEFAULT CHARSET=latin1;
35
36-- --------------------------------------------------------
37--
38-- Table structure for table `grade`
39--
40
41DROP TABLE IF EXISTS `grade`;
42
43CREATE TABLE `grade` (
44	`id_grade` int(11) NOT NULL AUTO_INCREMENT,
45	`role` varchar(50) NOT NULL,
46	PRIMARY KEY(`id_grade`)
47) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48
49-- --------------------------------------------------------
50
51TRUNCATE TABLE member;
52INSERT INTO member (`pseudonyme`, `password`, `mail`, `surname`, `name`, `gender`, `ville`, `birthday`, `grade`, `confirm_mail`, `status`)
53VALUES
54('ADMIN', 'TEST', 'rayane.slimani@epitech.eu', 'Famille', 'Prenom', 'Homme', 'Paris', '1998-06-09', '3', '1', '1');
55
56TRUNCATE TABLE grade;
57INSERT INTO grade (`id_grade`, `role`)
58VALUES
59('3', 'Admins'),
60('1', 'Users');