-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 20, 2016 at 01:07 PM
-- Server version: 5.6.26-log
-- PHP Version: 5.5.28

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 utf8mb4 */;

--
-- Database: `TestIssue`
--

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

--
-- Table structure for table `User`
--

CREATE TABLE IF NOT EXISTS `User` (
  `id` bigint(20) NOT NULL,
  `address1` text COLLATE utf8_unicode_ci,
  `mobile` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `firstName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1 - female, 2-male, 0 - unknown',
  `zip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `countryCode` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `joinedDate` datetime DEFAULT NULL,
  `dateOfBirth` date DEFAULT NULL COMMENT 'User date of birth'
) ENGINE=MyISAM AUTO_INCREMENT=63561 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `User`
--

INSERT INTO `User` (`id`, `address1`, `mobile`, `name`, `firstName`, `lastName`, `username`, `password`, `email`, `gender`, `zip`, `countryCode`, `joinedDate`, `dateOfBirth`) VALUES
(32631, '', '', NULL, 'Roland', 'Le Franc', NULL, NULL, 'rodansager@outlook.com', 2, '', 'US', '2016-05-23 18:00:26', '0000-00-00'),
(35573, NULL, '33174532773', NULL, 'blumab', 'noosfr', NULL, NULL, 'bluasmab@noos.fr', 2, '92200', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35574, '31 rue Trébois', '1274126453', NULL, 'Alexandra', 'Lupin', NULL, NULL, 'lupinaszalex2000@yahoo.fr', 1, '92300', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35575, '1 rue de Marnes', '627328595', NULL, 'Alexandre', 'Allemand', NULL, NULL, 'allemanasd.alexandre@gmail.com', 2, '92410', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35576, '33 rue Felicien David', '677996624', NULL, 'Alexandre', 'Maidanatz', NULL, NULL, 'a.gitsaakos@gmail.com', 2, '75016', 'FR', '2016-05-25 03:00:15', '1905-06-10'),
(35577, '66 rue Nicolo', '12503122650', NULL, 'Alexandre', 'Maidanatz', NULL, NULL, 'amaiasdan@laposaste.net', 2, '75116', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35578, '16 rue du Parc Royal', '6031279629812', NULL, 'Andre', 'Zagouri', NULL, NULL, 'andrea.zagouri@orangase.fr', 2, '75003', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35579, '66 rue de Chatou', '62541272785', NULL, 'Anne', 'Bourdu', NULL, NULL, 'anneas.bourdu@gmailas.com', 1, '92700', 'FR', '2016-05-25 03:00:15', '1973-09-08'),
(35580, 'Esat Kent - Crumps Lane', '612712', NULL, 'Anne', 'Bourdu', NULL, NULL, 'arnaudasdassier@gmail.com', 2, 'ME171EX', 'FR', '2016-05-25 03:00:15', '1969-02-18'),
(35581, '56 rue de la Pompe', '12444937', NULL, 'Arnaud', 'Nana Mvogo', NULL, NULL, 'leliberal@hoastmail.fr', 2, '75116', 'FR', '2016-05-25 03:00:15', '1905-05-30'),
(35582, '100 avenue du General Leclerc', '61501612617', NULL, 'Arthur', 'Klein', NULL, NULL, 'Klein.Arthuasr@gmail.com', 2, '75014', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35583, '25 rue Dieutre', '68961270307', NULL, 'Aurélien', 'Biteau', NULL, NULL, 'aurelienbiteau@lasaposte.net', 2, '76000', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35584, '86 rue Montorgueuil', '', NULL, 'Aurelien', 'Condomines', NULL, NULL, 'condoasmines@aramis-law.com', 2, '75002', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
(35586, '16 avenue Pierre Brossolette', '67996512148', NULL, 'Bastien', 'Moyet', NULL, NULL, 'bastien.masaoyet@gmail.com', 2, '92240', 'FR', '2016-05-25 03:00:15', '0000-00-00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `User`
--
ALTER TABLE `User`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `User`
--
ALTER TABLE `User`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63561;
/*!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 */;