· 9 years ago · Sep 05, 2017, 08:28 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: Aug 29, 2017 at 11:23 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: `bitcoin1`
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=364 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(334, 0, 'PO12@gmail.com', 'PO@gmail.com', 'cXdlUVdFMTIz', '', '', '', '', '', 1, 0, 2, ' ', '', '334', '', '', '', '', '', '', '2017-08-16 10:16:22', ' 29-08-2017 10:29:42 ', '', '', '', '', '', '', '', 0, '', 1, ''),
73(335, 0, 'a1@gmail.com', 'a1@gmail.com', 'YTFAZ21haWwuY29tQQ==', '', '', '', '', '', 1, 0, 2, '334 ', '', '', '', '', '', '', '', '', '2017-08-17 06:27:07', '', '', '', '', '', '', '', '', 0, '', 1, ''),
74(336, 0, 'b1@gmail.com', 'b1@gmail.com', 'YjFAZ21haWwuY29tQg==', '', '', '', '', '', 1, 0, 2, '334 ', '', '', '', '', '', '', '', '', '2017-08-17 06:28:12', '', '', '', '', '', '', '', '', 0, '', 1, ''),
75(337, 0, 'c1@gmail.com', 'c1@gmail.com', 'YzFAZ21haWwuY29tQw==', '', '', '', '', '', 1, 0, 2, '334 ', '', '', '', '', '', '', '', '', '2017-08-17 06:33:14', '', '', '', '', '', '', '', '', 0, '', 1, ''),
76(338, 0, 'd1@gmail.com', 'd1@gmail.com', 'ZDFAZ21haWwuY29tRA==', '', '', '', '', '', 1, 0, 2, '334 ', '', '', '', '', '', '', '', '', '2017-08-17 06:32:48', '', '', '', '', '', '', '', '', 0, '', 1, ''),
77(339, 0, 'e1@gmail.com', 'e1@gmail.com', 'ZTFAZ21haWwuY29tRQ==', '', '', '', '', '', 1, 0, 2, ' ', '334', '', '', '', '', '', '', '', '2017-08-28 07:49:41', '', '', '', '', '', '', '', '', 0, '', 1, ''),
78(351, 0, 'de12@gmail.com', 'de12@gmail.com', 'MQ==', '', '', '', '', '', 1, 0, 2, '334 ', '', '', '', '', '', '', '', '', '2017-08-25 05:39:59', '', '', '', '', '', '', '', '', 0, '', 1, ''),
79(357, 0, 'gurwinderkannu123@gmail.com', 'gurwinderkannu123@gmail.com', '', '', '', '', '', '', 0, 0, 2, '', '334', '', '', '', '', '', '', '', '2017-08-23 10:32:57', '', '', '', '', '', '', '', '', 0, '', 0, ''),
80(360, 0, 'srf12@gmail.com', 'srf12@gmail.com', 'MQ==', '', '', '', '', '', 1, 0, 2, ' ', '335', '', '', '', '', '', '', '', '2017-08-28 07:50:34', '', '', '', '', '', '', '', '', 0, '', 1, ''),
81(363, 0, 'gyh12@gmail.com', 'gyh12@gmail.com', 'MQ==', '', '', '', '', '', 0, 0, 2, '', '334', '', '', '', '', '', '', '', '2017-08-29 06:50:19', '', '', '', '', '', '', '', '', 0, '', 0, '');
82
83--
84-- Indexes for dumped tables
85--
86
87--
88-- Indexes for table `user`
89--
90ALTER TABLE `user`
91 ADD PRIMARY KEY (`user_id`);
92
93--
94-- AUTO_INCREMENT for dumped tables
95--
96
97--
98-- AUTO_INCREMENT for table `user`
99--
100ALTER TABLE `user`
101MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=364;
102/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
103/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
104/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;