Download Bata Base As-King

ne gan ane ksik Data Base script as-king yang sebelumnya cma scriptnya doang .

 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
-- Inang: localhost
-- Waktu pembuatan: 18 Jan 2014 pada 15.54
-- Versi Server: 5.5.34-cll
-- Versi PHP: 5.3.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Basis data: `teliteus_user`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fbid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `lvl` enum('Member','Reseller','Broker','Admin','Developers') COLLATE utf8_unicode_ci NOT NULL,
  `tiket` smallint(255) NOT NULL,
  `saldo` varchar(99) COLLATE utf8_unicode_ci NOT NULL,
  `uplink` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `lvluplink` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `expired` date NOT NULL,
  `ipuplink` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `kode` varchar(5000) COLLATE utf8_unicode_ci NOT NULL,
  `hasilvoucher` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `namafb` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `hasilsaldo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`fbid`),
  KEY `nama` (`password`),
  KEY `fbid` (`fbid`),
  FULLTEXT KEY `fbid_2` (`fbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`password`, `fbid`, `level`, `lvl`, `tiket`, `saldo`, `uplink`, `lvluplink`, `expired`, `ipuplink`, `kode`, `hasilvoucher`, `namafb`, `email`, `hasilsaldo`) VALUES
('0877ari1st', '100007527819189', '5', 'Developers', 29988, '-602501', 'Ari Sulistio', 'Developers', '1999-01-01', '36.70.118.184', '08771903', '100000', 'Ari Sulistio', 'ari.sulistio1st@yahoo.co.id', '10000000'),
('A0813205194', '100007488642074', '4', 'Reseller', 20, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '180.253.3.179', '', '', 'Fauzan Akbar', 'fauzanakbar27@yahoo.com', ''),
('kemas123', '100006844210415', '4', 'Member', 0, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '180.248.39.139', '', '', 'Kemas Iqbal', 'kemas.iqbal@yahoo.com', ''),
('ari', '100007057868574', '2', 'Broker', 50, '100000', 'Ari Sulistio', 'Developers', '1970-01-01', '36.70.118.184', '1289379123', '5000', 'Ari', 'ari.hacker1st@yahoo.com', '5000'),
('wholes', '100006671253359', '4', 'Member', 0, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '114.79.16.7', '', '', 'Tiyo Andhika', 'anasnsx@yahoo.com', ''),
('siliwangi', '100003260074027', '5', 'Developers', 30000, '9831499', 'Ari Sulistio', 'Developers', '1999-01-01', '180.253.139.112', '08771903', '100000', 'Agung Hufadz', 'ahufadz@gmail.com', '10000000'),
('batalion', '100007345323363', '3', 'Reseller', 18, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '36.80.208.15', '', '', 'Kecep Pro', 'kecepp@yahoo.com', ''),
('@1234', '100007407152037', '3', 'Reseller', 20, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '118.96.174.241', '', '', 'Moch Ngeak', 'mochngeak@gmail.com', ''),
('MAUDIAPAIN', '100000912714722', '3', 'Reseller', 20, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '110.138.41.188', '', '', 'Erik Hardiansyah Sukanda', '', ''),
('ANF', '100001874072288', '4', 'Admin', 40, '7500', 'Ari Sulistio', '', '1990-01-11', '180.253.251.122', '', '', 'Archa Ndra Fil', 'hendrasaputra16@rocketmail.com', ''),
('dede170901', '100002028049572', '4', 'Member', 0, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '', '', '', '', '', ''),
('rahmansamba1', '100002350564613', '2', 'Broker', 50, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '110.139.131.212', '08771903', '', 'Rahman', '', '100000'),
('makosaga1', '100000241562286', '4', 'Member', 0, '0', 'Kecep Pro', 'Reseller', '1970-01-01', '', '', '', '', '', ''),
('samarinda21', '100004023554395', '4', 'Member', 0, '0', 'Ari Sulistio', 'Developers', '1970-01-01', '36.83.33.39', '', '', 'Rehan NurXz', '', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Posted in: Script