jWTdb5Uj

1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 26 Feb 2018 pada 10.17
7-- Versi Server: 5.6.20
8-- PHP Version: 5.5.15
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-- Database: `blog_tutorial`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `blog_post`
27--
28
29CREATE TABLE IF NOT EXISTS `blog_post` (
30`id_blog_post` int(11) NOT NULL,
31  `title` varchar(100) NOT NULL,
32  `description` text NOT NULL,
33  `file` varchar(100) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
35
36--
37-- Indexes for dumped tables
38--
39
40--
41-- Indexes for table `blog_post`
42--
43ALTER TABLE `blog_post`
44 ADD PRIMARY KEY (`id_blog_post`);
45
46--
47-- AUTO_INCREMENT for dumped tables
48--
49
50--
51-- AUTO_INCREMENT for table `blog_post`
52--
53ALTER TABLE `blog_post`
54MODIFY `id_blog_post` int(11) NOT NULL AUTO_INCREMENT;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;