aT3a2nW4

1-- phpMyAdmin SQL Dump
2-- version 4.4.15
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Sep 25, 2016 at 07:11 AM
7-- Server version: 5.5.47
8-- PHP Version: 5.5.27
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 utf8mb4 */;
18
19--
20-- Database: `UPLOAD`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `tab_user`
27--
28
29CREATE TABLE IF NOT EXISTS `tab_user` (
30  `user_id` int(11) NOT NULL,
31  `username` varchar(50) COLLATE latin1_general_ci NOT NULL,
32  `password` varchar(50) COLLATE latin1_general_ci NOT NULL,
33  `user_nama` varchar(50) COLLATE latin1_general_ci NOT NULL,
34  `user_akses` enum('gratis','premium','admin') COLLATE latin1_general_ci NOT NULL DEFAULT 'gratis'
35) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
36
37--
38-- Dumping data for table `tab_user`
39--
40
41INSERT INTO `tab_user` (`user_id`, `username`, `password`, `user_nama`, `user_akses`) VALUES
42(1, 'andi', '1234', 'Andi Doang', 'gratis'),
43(2, 'toto', '1234', 'Toto Kuncoro', 'premium'),
44(3, 'calim', '1234', 'Calim Weh', 'admin'),
45(4, 'widia', '1234', 'Widia Yatin', 'gratis');
46
47--
48-- Indexes for dumped tables
49--
50
51--
52-- Indexes for table `tab_user`
53--
54ALTER TABLE `tab_user`
55  ADD PRIMARY KEY (`user_id`);
56
57--
58-- AUTO_INCREMENT for dumped tables
59--
60
61--
62-- AUTO_INCREMENT for table `tab_user`
63--
64ALTER TABLE `tab_user`
65  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
66/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
67/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
68/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;