UdC8ktXm

1-- phpMyAdmin SQL Dump
2-- version 4.4.12
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 22 Des 2016 pada 10.30
7-- Versi Server: 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: `db_web2_1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `db_crud_lat1`
27--
28
29CREATE TABLE IF NOT EXISTS `db_crud_lat1` (
30  `id` int(10) NOT NULL,
31  `nama` text NOT NULL,
32  `username` varchar(100) NOT NULL,
33  `password` varchar(100) NOT NULL,
34  `email` varchar(100) NOT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data untuk tabel `db_crud_lat1`
39--
40
41INSERT INTO `db_crud_lat1` (`id`, `nama`, `username`, `password`, `email`) VALUES
42(1, 'Bakti nur Wahyudin', 'Bakti', 'hjhjvjh', 'b4kti.97@gmail.com'),
43(3, 'Banana', 'banana', 'weewgwege', 'banana9797@gmail.comm');
44
45--
46-- Indexes for dumped tables
47--
48
49--
50-- Indexes for table `db_crud_lat1`
51--
52ALTER TABLE `db_crud_lat1`
53  ADD PRIMARY KEY (`id`);
54
55--
56-- AUTO_INCREMENT for dumped tables
57--
58
59--
60-- AUTO_INCREMENT for table `db_crud_lat1`
61--
62ALTER TABLE `db_crud_lat1`
63  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
64/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
65/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
66/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;