WtypAiGQ

1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mer. 28 nov. 2018 à 21:26
7-- Version du serveur :  5.7.21
8-- Version de PHP :  5.6.35
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `syscloud`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `users`
29--
30
31DROP TABLE IF EXISTS `users`;
32CREATE TABLE IF NOT EXISTS `users` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `name` varchar(255) NOT NULL,
35  `password` varchar(255) NOT NULL,
36  `email` varchar(255) NOT NULL,
37  `role` int(1) NOT NULL DEFAULT '0',
38  `valid` int(1) NOT NULL DEFAULT '0',
39  `avatar` varchar(255) NOT NULL DEFAULT 'default.png',
40  PRIMARY KEY (`id`)
41) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
42
43--
44-- Déchargement des données de la table `users`
45--
46
47INSERT INTO `users` (`id`, `name`, `password`, `email`, `role`, `valid`, `avatar`) VALUES
48(1, 'EnObliO', 'e1b98a5fa5d9f917c0bd31531d03c2146eb3a8da', 'mattmar33@gmail.com', 0, 0, 'default.png'),
49(7, 'tmpUser', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'test@mail.com', 0, 0, 'default.png'),
50(5, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'test@mail.com', 0, 0, 'default.png'),
51(12, 'paulin', '2cb00b6713236256533d04f4b6fa9d34d3c3fa18', 'paulin.dasse@ynov.com', 0, 0, 'default.png');
52COMMIT;
53
54/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
55/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
56/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;