· 10 years ago · Sep 20, 2016, 11:10 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 20, 2016 at 01:07 PM
7-- Server version: 5.6.26-log
8-- PHP Version: 5.5.28
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `TestIssue`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `User`
27--
28
29CREATE TABLE IF NOT EXISTS `User` (
30 `id` bigint(20) NOT NULL,
31 `address1` text COLLATE utf8_unicode_ci,
32 `mobile` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
33 `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
34 `firstName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
35 `lastName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
36 `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
37 `password` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
38 `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
39 `gender` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1 - female, 2-male, 0 - unknown',
40 `zip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
41 `countryCode` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
42 `joinedDate` datetime DEFAULT NULL,
43 `dateOfBirth` date DEFAULT NULL COMMENT 'User date of birth'
44) ENGINE=MyISAM AUTO_INCREMENT=63561 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
45
46--
47-- Dumping data for table `User`
48--
49
50INSERT INTO `User` (`id`, `address1`, `mobile`, `name`, `firstName`, `lastName`, `username`, `password`, `email`, `gender`, `zip`, `countryCode`, `joinedDate`, `dateOfBirth`) VALUES
51(32631, '', '', NULL, 'Roland', 'Le Franc', NULL, NULL, 'rodansager@outlook.com', 2, '', 'US', '2016-05-23 18:00:26', '0000-00-00'),
52(35573, NULL, '33174532773', NULL, 'blumab', 'noosfr', NULL, NULL, 'bluasmab@noos.fr', 2, '92200', 'FR', '2016-05-25 03:00:15', '0000-00-00'),
53(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'),
54(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'),
55(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'),
56(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'),
57(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'),
58(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'),
59(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'),
60(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'),
61(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'),
62(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'),
63(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'),
64(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');
65
66--
67-- Indexes for dumped tables
68--
69
70--
71-- Indexes for table `User`
72--
73ALTER TABLE `User`
74 ADD PRIMARY KEY (`id`),
75 ADD KEY `email` (`email`);
76
77--
78-- AUTO_INCREMENT for dumped tables
79--
80
81--
82-- AUTO_INCREMENT for table `User`
83--
84ALTER TABLE `User`
85 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63561;
86/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
87/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
88/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;