· 11 years ago · May 13, 2015, 09:06 PM
1-- phpMyAdmin SQL Dump
2-- version 4.3.8
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: 13 Mei 2015 pada 16.04
7-- Versi Server: 5.5.42-37.1
8-- PHP Version: 5.4.23
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: `lanhut88_togel`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `tb_member`
27--
28
29CREATE TABLE IF NOT EXISTS `tb_member` (
30 `member_id` int(11) NOT NULL,
31 `username` varchar(200) DEFAULT '',
32 `password` varchar(100) DEFAULT '',
33 `fulname` varchar(200) DEFAULT '',
34 `address` varchar(300) DEFAULT '',
35 `country` varchar(100) DEFAULT '',
36 `contact_number` varchar(20) DEFAULT '',
37 `phone_number` varchar(20) DEFAULT '',
38 `email` varchar(200) DEFAULT '',
39 `birth` varchar(20) DEFAULT '',
40 `refferal` varchar(500) DEFAULT '',
41 `bank_name` varchar(100) DEFAULT '',
42 `account_name` varchar(200) DEFAULT '',
43 `account_number` varchar(200) DEFAULT '',
44 `personal_question` text,
45 `answer` text,
46 `register_date` datetime DEFAULT NULL,
47 `last_login` datetime DEFAULT NULL,
48 `last_update` datetime DEFAULT NULL,
49 `level_diskon` int(5) DEFAULT NULL,
50 `saldo` varchar(111) DEFAULT NULL,
51 `login` enum('on','off') DEFAULT NULL,
52 `klik_reff` int(20) DEFAULT '0',
53 `status_member` enum('new','active','blacklist') DEFAULT NULL,
54 `ses_id` varchar(255) NOT NULL,
55 `last_ip` varchar(50) NOT NULL,
56 `refstat` varchar(50) NOT NULL,
57 `status_login` varchar(100) NOT NULL,
58 `memo` enum('yes','no') NOT NULL,
59 `ref` enum('yes','no') NOT NULL
60) ENGINE=MyISAM AUTO_INCREMENT=382 DEFAULT CHARSET=latin1;
61
62--
63-- Dumping data untuk tabel `tb_member`
64--
65
66INSERT INTO `tb_member` (`member_id`, `username`, `password`, `fulname`, `address`, `country`, `contact_number`, `phone_number`, `email`, `birth`, `refferal`, `bank_name`, `account_name`, `account_number`, `personal_question`, `answer`, `register_date`, `last_login`, `last_update`, `level_diskon`, `saldo`, `login`, `klik_reff`, `status_member`, `ses_id`, `last_ip`, `refstat`, `status_login`, `memo`, `ref`) VALUES
67(18, 'ultraman', 'ahuiagus88', '', '', 'Indonesia', '0123456789', '0123456789', 'test@gmail.com', '1-1-', '', 'BCA', 'molor', '00000000', '', '', '2015-02-09 12:52:01', '2015-05-01 06:27:02', '2015-05-01 06:05:54', 0, '43000', 'off', 0, 'active', '', '203.177.235.250', 'Open Refferal', '', 'yes', 'yes'),
68(19, 'johan', 'budi123', '', '', 'Indonesia', '0812650355021', '0812650355021', 'johanjohan@gmail.com', '1-1-', '', 'BCA', 'johan', '5454545814', '', '', '2015-02-09 13:41:14', '2015-05-13 12:57:27', '2015-05-13 00:23:42', 1, '151980', 'off', 0, 'active', '', '203.177.235.250', 'Open Refferal', '', 'yes', 'yes'),
69(20, 'camelo', 'camelo88', '', '', 'INDONESIA', '+639354554466', '+639354554466', 'test@yahoo.com', '--', '', 'BCA', 'Camel', '830000001234', '', '', '2015-02-10 01:06:30', '2015-05-07 16:38:37', '2015-04-13 04:15:48', 1, '156019.78', 'off', 0, 'active', '', '49.144.9.29', 'Open refferal', '', 'yes', 'yes'),
70(21, 'epn', 'dey4n4r4', '', '', 'INDONESIA', '081243382130', '081243382130', 'engelinasofi@gmail.com', '--', '', 'BCA', 'Fentje Tuapattinaya', '0440567355', '', '', '2015-02-10 14:30:14', '2015-05-12 08:05:58', '2015-04-23 02:40:01', 3, '504616', 'on', 0, 'active', '', '180.249.153.16', 'Open Refferal', '', 'yes', 'yes'),
71(22, 'haryo189', 'keisya301008', '', '', 'INDONESIA', '085264800889', '085264800889', 'haryo889@gmail.com', '--', '', 'BCA', 'Iszaharyo Nasriza', '8890480056', '', '', '2015-02-10 15:26:56', '2015-05-13 07:59:17', '2015-04-16 20:22:04', 0, '90', 'off', 0, 'active', '', '168.235.196.45', 'Open Refferal', '', 'yes', 'yes'),
72(23, 'mifta19', 'meta19', '', '', 'Indonesia', '087702583563', '087702583563', 'mifta@ymail.com', '1-1-', '', 'BCA', 'beni junaidi', '0183461360', '', '', '2015-02-10 15:30:09', '2015-05-12 14:52:31', '2015-05-01 09:32:56', 0, '400', 'on', 0, 'active', '', '39.215.122.185', 'Open Refferal', '', 'yes', 'yes'),
73(24, 'untung212', 'jack1234', '', '', 'INDONESIA', '097839481871', '097839481871', 'minem2002@gmail.com', '--', '', 'BRI', 'tantriyati', '697301005715530', '', '', '2015-02-11 09:40:43', '2015-03-21 12:18:14', '2015-03-21 12:11:45', 0, '0', 'off', 0, 'active', '', '120.185.101.156', 'Open Refferal', '', 'yes', 'yes'),
74(25, 'udin123', 'udin123', '', '', 'Indonesia', '081804145778', '081804145778', 'udin.joss@yahoo.com', '1-1-', '', 'BRI', 'fahrudin', '698201009504532', '', '', '2015-02-11 14:57:30', '2015-04-07 01:52:55', '2015-03-17 00:31:30', 0, '0', 'off', 0, 'active', '', '202.67.41.51', 'Open Refferal', '', 'yes', 'yes'),
75(26, 'Aril01', 'muliadi04', '', '', 'INDONESIA', '082180239471', '082180239471', 'harahap594@gmail.com', '--', '', 'MANDIRI', 'Gindo harahap', '9000003623114', '', '', '2015-02-11 23:25:56', '2015-02-12 22:00:16', '2015-02-11 23:28:10', 0, '0', 'off', 4, 'active', '', '185.26.180.44', 'Open Refferal', '', 'yes', 'yes'),
76(27, 'meong18', 'kucing18', 'NULL', 'tenggulunan..candi..sidoarjo', '', '082232172900', '082232172900', 'meong@ymail.com', '2-6-4-1984', 'mifta19', 'BCA', 'fery april lianto', '0183879232', 'Tempat kelahiran anda ?', 'sidoarjo', '2015-02-11 23:44:17', '2015-04-26 11:41:04', '2015-02-11 23:44:17', 0, '850', 'off', 0, 'active', '', '103.10.62.126', '', '', 'yes', 'yes'),
77(28, 'kenar123', 'diego123', 'NULL', 'perumnas-sampit-kalimantan tengah', '', '081359254799', '081359254799', 'kenar@ymail.com', '10-1-1982', 'mifta19', 'BNI', 'diantoro', '0234505777', 'Tempat kelahiran anda ?', 'perumnas', '2015-02-11 23:50:48', '2015-02-12 12:06:13', '2015-02-11 23:50:48', 0, '0', 'off', 0, 'active', '', '36.85.133.103', '', '', 'yes', 'yes'),
78(29, 'kisam02', 'rigo28930', '', '', 'INDONESIA', '081368964567', '081368964567', 'kisamoku@gmail.com', '--', '', 'BCA', 'hansoni', '0580764355', '', '', '2015-02-11 23:58:15', '2015-05-09 21:42:56', '2015-04-19 14:21:47', 1, '81120.57', 'off', 0, 'active', '', '180.242.11.111', 'Open Refferal', '', 'yes', 'yes'),
79(30, 'marunggi2011', 'imkicv85', '', '', 'INDONESIA', '081363902234', '081363902234', 'akbarmoraldy@gmail.com', '--', '', 'BRI', 'HERMAWATI', '776601001177536', '', '', '2015-02-12 02:39:21', '2015-03-06 15:07:40', '0000-00-00 00:00:00', 0, '0', 'off', 0, 'active', '', '', 'Open Refferal', '', 'yes', 'yes'),
80(31, 'sunan99', 'pagiyanten', '', '', 'INDONESIA', '087770111916', '087770111916', 'putrasunan99@ymail.com', '--', '', 'BRI', 'sunandar', '480101008685539', '', '', '2015-02-12 06:40:55', '2015-02-12 22:44:34', '2015-02-12 06:43:15', 0, '0', 'off', 0, 'active', '', '8.37.227.115', 'Open Refferal', '', 'yes', 'yes'),
81(32, 'kapolres', '289300ferdi', 'NULL', 'jakarta', '', '081377996665', '081377996665', 'rafaeladmaja@yahoo.co.id', '17-10-1980', 'kisam02', 'BCA', 'rodi', '0580610463', 'Tempat kelahiran anda ?', 'jakarta', '2015-02-12 07:48:00', '2015-05-13 11:14:48', '2015-04-15 03:15:25', 3, '8793583', 'off', 0, 'active', '', '36.76.234.100', '', '', 'yes', 'yes'),
82(33, 'ades1980', '000000', '', '', 'INDONESIA', '082280398003', '082280398003', 'adeskiryanto@gmail.com', '--', '', 'BRI', 'ADES KIRYANTO', '005901074031501', '', '', '2015-02-12 09:43:53', '2015-02-12 09:45:51', '0000-00-00 00:00:00', 0, '0', 'off', 0, 'active', '', '82.145.218.246', 'Open Refferal', '', 'yes', 'yes'),
83(34, 'habibi69', 'riziq69', '', '', 'INDONESIA', '05116226350', '05116226350', 'ampunku35@yahoo.co.id', '--', 'kisam02', 'MANDIRI', 's sofyan tasaury', '9000020541455', '', '', '2015-02-12 11:51:35', '2015-02-12 12:35:54', '2015-02-12 12:33:58', 0, '0', 'off', 0, 'active', '', '82.145.209.181', 'Open Refferal', '', 'yes', 'yes'),
84(35, 'togel', 'rej3kit0g3lA99', '', '', 'INDONESIA', '082221540994', '082221540994', 'sinar4d@yahoo.com', '--', '', 'BCA', 'ginandra kukuh', '2380592145', '', '', '2015-02-12 14:30:47', '2015-05-11 04:30:15', '2015-04-26 07:34:26', 0, '1862.17', 'on', 0, 'active', '', '36.80.130.102', 'Open Refferal', '', 'yes', 'yes'),
85(36, 'Cekyan77', 'papa77', '', '', 'INDONESIA', '082371215725', '082371215725', 'Yance@yahoo.co.id', '--', '', 'BCA', 'Yance bremeus hilman', '3000528284', '', '', '2015-02-12 14:49:58', '2015-02-12 14:51:05', '0000-00-00 00:00:00', 0, '0', 'off', 0, 'active', '', '8.37.225.8', 'Open Refferal', '', 'yes', 'yes'),
86(37, 'rezky71', 'suci11', '', '', 'INDONESIA', '082370477793', '082370477793', 'lantos71@yahoo.co.id', '--', '', 'MANDIRI', 'dulah hajad', '1580002424927', '', '', '2015-02-12 14:50:59', '2015-02-13 18:57:15', '2015-02-12 15:02:24', 0, '0', 'off', 0, 'active', '', '114.125.50.217', 'Open Refferal', '', 'yes', 'yes'),
87(38, 'andrew999', 's3m4r99', '', '', 'INDONESIA', '081945900003', '081945900003', 'kalshao@ovi.com', '--', 'kisam02', 'BCA', 'DIDIK PRASETYO', '3170352113', '', '', '2015-02-12 21:25:43', '2015-02-12 21:26:06', '2015-02-12 21:26:40', 0, '0', 'off', 0, 'active', '', '141.0.9.62', 'Open Refferal', '', 'yes', 'yes'),
88(39, 'ebikecycle81', 'parnoc', '', '', 'INDONESIA', '082132539022', '082132539022', 'edywijaya65@gmail.com', '--', '', 'BRI', 'edywijaya', '764701002209530', '', '', '2015-02-12 22:13:17', '2015-02-14 02:03:57', '2015-02-12 22:15:20', 0, '360', 'off', 0, 'active', '', '202.67.40.50', 'Open Refferal', '', 'yes', 'yes'),
89(40, '0603 - 0100 - 8614508', '12071984', '', '', 'INDONESIA', '081271926739', '081271926739', 'Rico_yudhistira@yahoo.com', '--', '', 'BRI', 'Erico yudhistira', '060301008614508', '', '', '2015-02-13 13:59:15', '2015-02-13 14:03:47', '2015-02-13 14:00:57', 0, '0', 'off', 0, 'active', '', '114.121.132.79', 'Open Refferal', '', 'yes', 'yes'),
90(41, 'ghufron01', 'adek02', '', '', 'INDONESIA', '07118040202', '07118040202', 'bbelelok@yahoo.com', '--', '', 'MANDIRI', 'tolibin', '1120010477474', '', '', '2015-02-14 00:09:09', '2015-02-14 00:43:52', '2015-02-14 00:11:55', 0, '0', 'off', 0, 'active', '', '114.79.37.113', 'Open Refferal', '', 'yes', 'yes'),
91(42, 'matgur25', 'adakah23', '', '', 'INDONESIA', '081953332053', '081953332053', 'el_gur@yahoo.com', '--', '', 'BRI', 'RAHMAD MAULIDY', '455901015490538', '', '', '2015-02-14 01:49:23', '2015-02-16 17:27:29', '0000-00-00 00:00:00', 0, '0', 'off', 0, 'active', '', '141.0.10.46', 'Open Refferal', '', 'yes', 'yes');
92
93--
94-- Indexes for dumped tables
95--
96
97--
98-- Indexes for table `tb_member`
99--
100ALTER TABLE `tb_member`
101 ADD PRIMARY KEY (`member_id`);
102
103--
104-- AUTO_INCREMENT for dumped tables
105--
106
107--
108-- AUTO_INCREMENT for table `tb_member`
109--
110ALTER TABLE `tb_member`
111 MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=382;
112/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
113/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
114/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;