-- phpMyAdmin SQL Dump

-- version 4.4.11

-- http://www.phpmyadmin.net

--

-- Host: 127.0.0.1

-- Generation Time: May 04, 2017 at 11:59 PM

-- Server version: 5.6.25

-- PHP Version: 5.5.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

--

-- Database: `blog-basic`

--

-- --------------------------------------------------------

--

-- Table structure for table `categories`

--

CREATE TABLE IF NOT EXISTS `categories` (

`id` int(11) NOT NULL,

`name` varchar(255) NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--

-- Dumping data for table `categories`

--

INSERT INTO `categories` (`id`, `name`) VALUES

(1, 'New News'),

(2, 'Events'),

(4, 'Coffee');

-- --------------------------------------------------------

--

-- Table structure for table `posts`

--

CREATE TABLE IF NOT EXISTS `posts` (

`id` int(11) NOT NULL,

`category` int(11) NOT NULL,

`title` varchar(255) NOT NULL,

`body` text NOT NULL,

`author` varchar(255) NOT NULL,

`tags` varchar(255) NOT NULL,

`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--

-- Dumping data for table `posts`

--

INSERT INTO `posts` (`id`, `category`, `title`, `body`, `author`, `tags`, `date`) VALUES

(4, 1, 'Sample dsfffds', ' fsdlkjdfskjds dfskljfds dsfkj dfskjfdskl ', 'dsfkljds', 'dfsklj', '2017-05-04 10:06:52');

--

-- Indexes for dumped tables

--

--

-- Indexes for table `categories`

--

ALTER TABLE `categories`

ADD PRIMARY KEY (`id`);

--

-- Indexes for table `posts`

--

ALTER TABLE `posts`

ADD PRIMARY KEY (`id`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `categories`

--

ALTER TABLE `categories`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;

--

-- AUTO_INCREMENT for table `posts`

--

ALTER TABLE `posts`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;