9yCi4Y9H

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Inang: localhost:3306
6-- Waktu pembuatan: 08 Sep 2016 pada 17.42
7-- Versi Server: 10.1.16-MariaDB
8-- Versi PHP: 5.4.31
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-- Basis data: `kokbisamedia_info`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `members`
27--
28
29CREATE TABLE IF NOT EXISTS `members` (
30  `nama` varchar(50) NOT NULL,
31  `username` varchar(25) NOT NULL,
32  `password` varchar(25) NOT NULL,
33  `kategori` varchar(255) NOT NULL,
34  `level` varchar(124) NOT NULL,
35  `lastlog` varchar(225) NOT NULL,
36  `expired` date NOT NULL,
37  PRIMARY KEY (`username`)
38) ENGINE=MyISAM DEFAULT CHARSET=latin1;
39
40--
41-- Dumping data untuk tabel `members`
42--
43
44INSERT INTO `members` (`nama`, `username`, `password`, `kategori`, `level`, `lastlog`, `expired`) VALUES
45('Cornelius Alfredo', 'admin', 'admin', '3in1', 'admin', '2016-08-27', '2017-01-31');
46
47-- --------------------------------------------------------
48
49--
50-- Struktur dari tabel `riwayat`
51--
52
53CREATE TABLE IF NOT EXISTS `riwayat` (
54  `no` int(15) NOT NULL AUTO_INCREMENT,
55  `target` varchar(255) NOT NULL,
56  `jumlah` varchar(255) NOT NULL,
57  `start` varchar(255) NOT NULL,
58  `user` varchar(255) NOT NULL,
59  `kategori` varchar(255) NOT NULL,
60  `log` varchar(255) NOT NULL,
61  `tanggal` varchar(255) NOT NULL,
62  `ip` varchar(255) NOT NULL,
63  PRIMARY KEY (`no`)
64) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
65
66-- --------------------------------------------------------
67
68--
69-- Struktur dari tabel `user`
70--
71
72CREATE TABLE IF NOT EXISTS `user` (
73  `id` int(11) NOT NULL AUTO_INCREMENT,
74  `idnya` varchar(75) NOT NULL,
75  `username` varchar(75) NOT NULL,
76  `password` varchar(75) NOT NULL,
77  `ua` text NOT NULL,
78  `cok` text NOT NULL,
79  `point` int(11) NOT NULL,
80  PRIMARY KEY (`id`)
81) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
82
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;