L21J8dYU

1-- phpMyAdmin SQL Dump
2-- version 4.4.12
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 30, 2016 at 11:41 AM
7-- Server version: 5.6.25
8-- PHP Version: 5.6.11
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: `dbcrud`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `crud`
27--
28
29CREATE TABLE IF NOT EXISTS `crud` (
30  `id` int(11) NOT NULL,
31  `nama` varchar(35) NOT NULL,
32  `username` varchar(35) NOT NULL,
33  `password` varchar(30) NOT NULL,
34  `email` varchar(40) NOT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `crud`
39--
40
41INSERT INTO `crud` (`id`, `nama`, `username`, `password`, `email`) VALUES
42(20, 'rizki', 'rizal', '17April1996', 'rizalalexander48@rocketmail.com'),
43(21, 'rojikin', 'jikin', '1234', 'rizki.rizal17@gmail.com'),
44(22, 'udin', 'udine', '1234', 'udin@gmail.com');
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `user`
50--
51
52CREATE TABLE IF NOT EXISTS `user` (
53  `id` int(11) NOT NULL,
54  `nama` varchar(35) NOT NULL,
55  `username` varchar(35) NOT NULL,
56  `password` varchar(30) NOT NULL,
57  `email` varchar(50) NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60--
61-- Indexes for dumped tables
62--
63
64--
65-- Indexes for table `crud`
66--
67ALTER TABLE `crud`
68  ADD PRIMARY KEY (`id`);
69
70--
71-- Indexes for table `user`
72--
73ALTER TABLE `user`
74  ADD PRIMARY KEY (`id`);
75
76--
77-- AUTO_INCREMENT for dumped tables
78--
79
80--
81-- AUTO_INCREMENT for table `crud`
82--
83ALTER TABLE `crud`
84  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
85--
86-- AUTO_INCREMENT for table `user`
87--
88ALTER TABLE `user`
89  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
90/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
91/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
92/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;