-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Client :  localhost
-- Généré le :  Lun 01 Décembre 2014 à 13:15
-- Version du serveur :  5.6.20-log
-- Version de PHP :  5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données :  `jonkotrade`
--

-- --------------------------------------------------------

--
-- Structure de la table `jktrade_users`
--

CREATE TABLE IF NOT EXISTS `jktrade_users` (
`id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `birth` datetime NOT NULL,
  `address` text NOT NULL,
  `pic` varchar(255) NOT NULL,
  `active` varchar(255) NOT NULL,
  `acctype` varchar(255) NOT NULL,
  `regdate` datetime NOT NULL,
  `last_ip` varchar(255) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Contenu de la table `jktrade_users`
--

INSERT INTO `jktrade_users` (`id`, `email`, `pwd`, `gender`, `firstname`, `surname`, `phone`, `birth`, `address`, `pic`, `active`, `acctype`, `regdate`, `last_ip`) VALUES
(1, 'mail.azot3@gmail.com', '7ad4fe9533ca040097b2456d5ab34bed8ea63823', 'male', 'Jalil', 'Benayachi', '0622144031', '1993-07-25 00:00:00', '35-37 Rue Rouget de Lisle\r\nRésidence Studea Issy 2\r\nISSY LES MOULINEAUX\r\nFRANCE                  ', '', 'notyet', 'member', '2014-10-16 05:26:59', '::1'),
(2, 'johndoe@test.com', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'male', 'John', 'Doe', '0612345678', '1983-09-29 00:00:00', 'Random Street,\r\nUnknown City,\r\nNOWHERE', '', 'notyet', 'member', '2014-10-16 05:28:13', '::1'),
(3, 'janedoe@test.com', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'female', 'Jane', 'Doe', '0612345678', '1983-04-22 00:00:00', '55b Main Street,\r\nNew York,\r\nUnited States of America', '', 'notyet', 'member', '2014-10-16 05:29:51', '127.0.0.1'),
(4, 'obama@whitehouse.ovh', '7ad4fe9533ca040097b2456d5ab34bed8ea63823', 'male', 'Barack', 'Obama', '0612345667', '1974-12-02 00:00:00', 'White House,\r\nWashington DC', '', 'notyet', 'member', '2014-10-16 05:31:44', '::1'),
(5, 'putin@kremlin.ovh', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'male', 'Vladimir', 'Putin', '0938132712', '1974-04-13 00:00:00', 'Kremlin,\r\nMoscow City,\r\nRussia', '', 'notyet', 'member', '2014-10-16 05:32:47', '127.0.0.1'),
(21, 'contact@thejals.com', '7ad4fe9533ca040097b2456d5ab34bed8ea63823', 'male', 'Jalil', 'Benayachi', '0622144031', '1993-07-25 00:00:00', 'Rue le royer\r\nLYON', '', 'yes', 'member', '2014-11-28 13:03:51', '127.0.0.1');

--
-- Index pour les tables exportées
--

--
-- Index pour la table `jktrade_users`
--
ALTER TABLE `jktrade_users`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `jktrade_users`
--
ALTER TABLE `jktrade_users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;