H97gY16L

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mar. 23 avr. 2019 à 10:29
7-- Version du serveur :  5.7.19
8-- Version de PHP :  5.6.31
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 :  `rdelaporte_projet`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `user`
29--
30
31DROP TABLE IF EXISTS `user`;
32CREATE TABLE IF NOT EXISTS `user` (
33  `usr_id` int(11) NOT NULL AUTO_INCREMENT,
34  `usr_login` varchar(255) NOT NULL,
35  `usr_pwd` varchar(255) NOT NULL,
36  `usr_email` varchar(255) NOT NULL,
37  `usr_email_valide` tinyint(4) NOT NULL DEFAULT '0',
38  `usr_date_inscription` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
39  `usr_ip_inscription` varchar(255) NOT NULL,
40  `usr_nom` varchar(255) NOT NULL DEFAULT '',
41  `usr_prenom` varchar(255) NOT NULL DEFAULT '',
42  `usr_telephone` varchar(255) NOT NULL DEFAULT '',
43  `usr_droit` int(11) NOT NULL DEFAULT '0',
44  `usr_ville` int(11) DEFAULT NULL,
45  `usr_avatar` varchar(255) DEFAULT NULL,
46  PRIMARY KEY (`usr_id`)
47) ENGINE=MyISAM AUTO_INCREMENT=465566653 DEFAULT CHARSET=latin1;
48
49--
50-- Déchargement des données de la table `user`
51--
52
53INSERT INTO `user` (`usr_id`, `usr_login`, `usr_pwd`, `usr_email`, `usr_email_valide`, `usr_date_inscription`, `usr_ip_inscription`, `usr_nom`, `usr_prenom`, `usr_telephone`, `usr_droit`, `usr_ville`, `usr_avatar`) VALUES
54(43, 'Hugo', '5a75fd230be3592db9b2038694dea764adc3cccb', 'Lulu843001@gmail.com', 1, '2019-03-27 12:01:11', '78.123.3.16', '', '', '', 0, NULL, NULL),
55(1, 'soufiane', 'd93e4fc6fd9862ccd2148e1291e924d25df6054b', 'soufiane_dri130@hotmail.fr', 1, '2019-03-25 09:46:01', '127.0.0.1', 'Dribel', 'Soufiane', '0782422041', 1, 4437, '1.jpg'),
56(41, 'test', '489e775c4efbd4ecb791e4a02aad311129f0a12b', 'soufiane_dri130@hotmail.fr', 1, '2019-03-26 15:18:35', '127.0.0.1', '', '', '', 0, 0, '41.jpg'),
57(42, 'hamza', '229a32b974cbd4d823e3002029b6f569223139c0', 'alexisprats@hotmail.fr', 1, '2019-03-27 11:48:49', '78.123.3.16', '', '', '', 0, NULL, NULL),
58(443, 'Hdzqdqzugo', '5a75fd230be3592db9b2038694dea764adc3cccb', 'Lulu843001@gmail.com', 0, '2019-03-27 12:01:11', '78.123.3.16', '', '', '', 0, NULL, NULL),
59(551, 'souffsfsfiane', 'd93e4fc6fd9862ccd2148e1291e924d25df6054b', 'soufiane_dri130@hotmail.fr', 0, '2019-03-25 09:46:01', '127.0.0.1', 'Dribel', 'Soufiane', '0782422041', 1, 4437, '1.jpg'),
60(451, 'tesest', '489e775c4efbd4ecb791e4a02aad311129f0a12b', 'soufiane_dri130@hotmail.fr', 0, '2019-03-26 15:18:35', '127.0.0.1', '', '', '', 0, 0, '41.jpg'),
61(462, 'hamfffza', '229a32b974cbd4d823e3002029b6f569223139c0', 'alexisprats@hotmail.fr', 1, '2019-03-27 11:48:49', '78.123.3.16', '', '', '', 0, NULL, NULL),
62(4643, 'Hdddzqdqzugo', '5a75fd230be3592db9b2038694dea764adc3cccb', 'Lulu843001@gmail.com', 0, '2019-03-27 12:01:11', '78.123.3.16', '', '', '', 0, NULL, NULL),
63(5651, 'souffsfsddfiane', 'd93e4fc6fd9862ccd2148e1291e924d25df6054b', 'soufiane_dri130@hotmail.fr', 0, '2019-03-25 09:46:01', '127.0.0.1', 'Dribel', 'Soufiane', '0782422041', 1, 44637, '1.jpg'),
64(46643, 'Hdddzqddzqqzugo', '5a75fd230be3592db9b2038694dea764adc3cccb', 'Lulu843001@gmail.com', 0, '2019-03-27 12:01:11', '78.123.3.16', '', '', '', 0, NULL, NULL),
65(56665551, 'souffsfsddfiane', 'd93e4fc6fd9862ccd2148e1291e924d25df6054b', 'soufiane_dri130@hotmail.fr', 0, '2019-03-25 09:46:01', '127.0.0.1', 'Dribel', 'Soufiane', '0782422041', 1, 4466637, '1.jpg'),
66(546651, 'tdqzesest', '489e775c4efbd4ecb791e4a02aad311129f0a12b', 'soufiane_dri130@hotmail.fr', 0, '2019-03-26 15:18:35', '127.0.0.1', '', '', '', 0, 0, '41.jpg'),
67(465566652, 'hamfdqzffza', '229a32b974cbd4d823e3002029b6f569223139c0', 'alexisprats@hotmail.fr', 1, '2019-03-27 11:48:49', '78.123.3.16', '', '', '', 0, NULL, NULL);
68COMMIT;
69
70/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
71/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
72/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;