kWSLYYkT

1-- Leaked by kcnewbie | Zero-Security
2-- phpMyAdmin SQL Dump
3-- version 4.1.12
4-- http://www.phpmyadmin.net
5--
6-- Host: 127.0.0.1
7-- Generation Time: Feb 10, 2016 at 09:23 AM
8-- Server version: 5.6.16
9-- PHP Version: 5.5.11
10
11SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8 */;
19
20--
21-- Database: `jkt48`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `user`
28--
29
30CREATE TABLE IF NOT EXISTS `user` (
31  `id` int(15) NOT NULL AUTO_INCREMENT,
32  `name` varchar(150) CHARACTER SET utf8 NOT NULL,
33  `username` varchar(10) CHARACTER SET utf8 NOT NULL,
34  `email` varchar(50) CHARACTER SET utf8 NOT NULL,
35  `password` varchar(150) CHARACTER SET utf8 NOT NULL,
36  `gender` enum('male','female') NOT NULL,
37  `dob` date NOT NULL,
38  `phone` int(15) NOT NULL,
39  `address` varchar(250) CHARACTER SET utf8 NOT NULL,
40  `city` varchar(15) CHARACTER SET utf8 NOT NULL,
41  PRIMARY KEY (`id`)
42) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
43
44--
45-- Dumping data for table `user`
46--
47
48INSERT INTO `user` (`id`, `name`, `username`, `email`, `password`, `gender`, `dob`, `phone`, `address`, `city`) VALUES
49(1, 'junet', 'junetaja', 'junedjeremiah@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'male', '0000-00-00', 123456, 'test', 'Jakarta'),
50(2, 'aspire', 'aspire4741', 'getarealjobnigga@mail.com', 'e10adc3949ba59abbe56e057f20f883e', 'male', '0000-00-00', 123456, 'asdfsadfas', 'Surabaya'),
51(5, 'icho', 'icho', 'icho@mail.com', '28d876cc43bc305f7848d3aab4c73a53', 'male', '0000-00-00', 12345, 'sadfsa', 'Bandung'),
52(6, 'root', 'root', 'root@mail.com', '63a9f0ea7bb98050796b649e85481845', 'male', '0000-00-00', 0, 'sdf', 'Jakarta'),
53(8, 'juned', 'juned', 'juned@mail.com', '4769ad580a03eae7501b5852ea17b82a', 'male', '0000-00-00', 0, 'asdf', 'Jakarta');
54
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;