· 9 years ago · Sep 15, 2017, 05:02 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 15, 2017 at 06:54 AM
7-- Server version: 5.6.21
8-- PHP Version: 5.5.19
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 utf8 */;
18
19--
20-- Database: `userr`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `user`
27--
28
29CREATE TABLE IF NOT EXISTS `user` (
30`user_id` int(11) NOT NULL,
31 `age` int(5) NOT NULL,
32 `user_name` varchar(100) NOT NULL,
33 `user_email` varchar(50) NOT NULL,
34 `user_password` varchar(50) NOT NULL,
35 `user_birthdate` varchar(50) NOT NULL,
36 `user_gender` varchar(50) NOT NULL,
37 `user_country` varchar(100) NOT NULL,
38 `user_ethnicity` varchar(50) NOT NULL,
39 `user_image` varchar(150) NOT NULL,
40 `launch` int(1) NOT NULL DEFAULT '0',
41 `pcktaken` int(10) NOT NULL,
42 `level` int(1) NOT NULL DEFAULT '2',
43 `refered` varchar(15) NOT NULL,
44 `global` varchar(15) NOT NULL,
45 `class1` varchar(15) CHARACTER SET utf32 COLLATE utf32_swedish_ci NOT NULL,
46 `class2` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci NOT NULL,
47 `class3` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci NOT NULL,
48 `class4` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci NOT NULL,
49 `class5` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci NOT NULL,
50 `class6` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci NOT NULL,
51 `reg_date` varchar(50) NOT NULL,
52 `mod_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
53 `moddate1` varchar(50) NOT NULL,
54 `moddate2` varchar(50) NOT NULL,
55 `moddate3` varchar(50) NOT NULL,
56 `moddate4` varchar(50) NOT NULL,
57 `moddate5` varchar(50) NOT NULL,
58 `moddate6` varchar(50) NOT NULL,
59 `bitad` varchar(250) NOT NULL,
60 `last_logout` varchar(255) NOT NULL,
61 `memtype` int(1) NOT NULL,
62 `location` varchar(10) NOT NULL,
63 `status` int(11) NOT NULL,
64 `token` varchar(100) NOT NULL
65) ENGINE=InnoDB AUTO_INCREMENT=534 DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `user`
69--
70
71INSERT INTO `user` (`user_id`, `age`, `user_name`, `user_email`, `user_password`, `user_birthdate`, `user_gender`, `user_country`, `user_ethnicity`, `user_image`, `launch`, `pcktaken`, `level`, `refered`, `global`, `class1`, `class2`, `class3`, `class4`, `class5`, `class6`, `reg_date`, `mod_date`, `moddate1`, `moddate2`, `moddate3`, `moddate4`, `moddate5`, `moddate6`, `bitad`, `last_logout`, `memtype`, `location`, `status`, `token`) VALUES
72(388, 0, 'main1@gmail.com', 'main1@gmail.com', 'bWFpbjFAZ21haWwuY29tTQ==', '', '', '', '', '', 1, 0, 2, ' ', '516', '388', '388', '388', '', '', '', '', '2017-09-04 11:43:58', ' 12-09-2017 09:51:25 ', ' 08-09-2017 12:50:02 ', ' 08-09-2017 12:55:44 ', '', '', '', '', '', 0, '', 1, ''),
73(515, 0, 'gygh12@gmail.com', 'gygh12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '515', '388', '388', '388', '', '', '', '', '2017-09-08 09:44:57', ' 08-09-2017 12:25:15 ', '', '', '', '', '', '', '', 0, '', 1, ''),
74(516, 0, 'gttghh12@gmail.com', 'gttghh12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '388', '516', '', '', '', '', '', '', '', '2017-09-08 09:45:22', '', '', '', '', '', '', '', '', 0, '', 1, ''),
75(517, 0, 'gg1@gmail.com', 'gg1@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '388', '388', '', '', '', '', '', '', '', '2017-09-08 09:45:45', '', '', '', '', '', '', '', '', 0, '', 1, ''),
76(518, 0, 'ghhh122@gmail.com', 'ghhh122@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '388', '388', '', '', '', '', '', '', '', '2017-09-08 09:46:03', '', '', '', '', '', '', '', '', 0, '', 0, ''),
77(519, 0, 'hhh12@gmail.com', 'hhh12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '388', '', '', '', '', '', '', '', '2017-09-08 09:46:18', '', '', '', '', '', '', '', '', 0, '', 0, ''),
78(520, 0, 'hfff122@gmail.com', 'hfff122@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '388', '', '', '', '', '', '', '', '2017-09-08 09:46:55', '', '', '', '', '', '', '', '', 0, '', 1, ''),
79(522, 0, 'vv12@gmail.com', 'vv12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 0, 0, 2, '1', '515', '', '', '', '', '', '', '', '2017-09-08 09:48:02', '', '', '', '', '', '', '', '', 0, '', 0, ''),
80(523, 0, 'ss12@gmail.com', 'ss12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '515', '', '', '', '', '', '', '', '2017-09-08 09:51:41', '', '', '', '', '', '', '', '', 0, '', 1, ''),
81(524, 0, 'vvgb12@gmail.com', 'vvgb12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '515', '', '', '', '', '', '', '', '2017-09-08 09:52:18', '', '', '', '', '', '', '', '', 0, '', 0, ''),
82(525, 0, 'lp12@gmail.com', 'lp12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '515', '516', '', '', '', '', '', '', '', '2017-09-08 09:53:06', '', '', '', '', '', '', '', '', 0, '', 1, ''),
83(526, 0, 'gtffg12@gmail.com', 'gtffg12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '1', '515', '', '', '', '', '', '', '', '2017-09-08 09:56:37', '', '', '', '', '', '', '', '', 0, '', 0, ''),
84(527, 0, 'huijhj12@gmail.com', 'huijhj12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '515', '515', '', '', '', '', '', '', '', '2017-09-08 09:57:44', '', '', '', '', '', '', '', '', 0, '', 1, ''),
85(528, 0, 'gggyhh12@gmail.com', 'gggyhh12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '388', '388', '', '', '', '', '', '', '', '2017-09-13 06:50:02', '', '', '', '', '', '', '', '', 0, '', 1, ''),
86(529, 0, 'gghhj12@gmail.com', 'gghhj12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 0, 0, 2, '515', '515', '', '', '', '', '', '', '', '2017-09-13 07:38:15', '', '', '', '', '', '', '', '', 0, '', 1, ''),
87(530, 0, 'ghjgg12@gmail.com', 'ghjgg12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '388', '516', '', '', '', '', '', '', '', '2017-09-13 08:16:15', '', '', '', '', '', '', '', '', 0, '', 1, ''),
88(531, 0, 'ggf122@gmail.com', 'ggf122@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '529', '516', '', '', '', '', '', '', '', '2017-09-13 11:11:38', '', '', '', '', '', '', '', '', 0, '', 1, ''),
89(532, 0, 'bbb12@gmail.com', 'bbb12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 0, 0, 2, '1', '516', '', '', '', '', '', '', '', '2017-09-14 10:42:26', '', '', '', '', '', '', '', '', 0, '', 1, ''),
90(533, 0, 'asda12@gmail.com', 'asda12@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, '515', '515', '', '', '', '', '', '', '', '2017-09-14 11:02:48', '', '', '', '', '', '', '', '', 0, '', 1, '');
91
92--
93-- Indexes for dumped tables
94--
95
96--
97-- Indexes for table `user`
98--
99ALTER TABLE `user`
100 ADD PRIMARY KEY (`user_id`);
101
102--
103-- AUTO_INCREMENT for dumped tables
104--
105
106--
107-- AUTO_INCREMENT for table `user`
108--
109ALTER TABLE `user`
110MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=534;
111/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
112/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
113/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;