-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 12, 2015 at 12:38 PM
-- Server version: 5.0.67-community-nt
-- PHP Version: 5.5.12

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 utf8 */;

--
-- Database: `thecut7_mannovation`
--

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

--
-- Table structure for table `authors`
--

CREATE TABLE IF NOT EXISTS `authors` (
  `author_last_name` varchar(25) NOT NULL,
  `author_first_name` varchar(25) NOT NULL,
  `author_bio` varchar(400) NOT NULL,
  `author_photo` varchar(50) NOT NULL,
  PRIMARY KEY  (`author_last_name`),
  UNIQUE KEY `author_last_name` (`author_last_name`),
  KEY `author_last_name_2` (`author_last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`author_last_name`, `author_first_name`, `author_bio`, `author_photo`) VALUES
('Eklund', 'Christopher', 'Christopher Eklund graduated from Minot State University with a Bachelors of Science in Management Information Systems and Business Management.  He is an outdoor enthusiast who loves to fish, hunt, kayak, and everything in between.  ', './img/eklund_bio.jpg');

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

--
-- Table structure for table `blogposts`
--

CREATE TABLE IF NOT EXISTS `blogposts` (
  `ID` int(4) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `short_title` varchar(10) NOT NULL,
  `blog_category` enum('Outdoors','Fitness','Food','Projects') NOT NULL,
  `author_last_name` varchar(25) NOT NULL,
  `post_date` date NOT NULL,
  `blog_text` varchar(750) NOT NULL,
  `blog_description` varchar(150) NOT NULL,
  `background_img` varchar(50) NOT NULL,
  `opt_img1` varchar(50) default NULL,
  `opt_img2` varchar(50) default NULL,
  `opt_img3` varchar(50) default NULL,
  `opt_img4` varchar(50) default NULL,
  `opt_img5` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `author_last_name` (`author_last_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `blogposts`
--

INSERT INTO `blogposts` (`ID`, `title`, `short_title`, `blog_category`, `author_last_name`, `post_date`, `blog_text`, `blog_description`, `background_img`, `opt_img1`, `opt_img2`, `opt_img3`, `opt_img4`, `opt_img5`) VALUES
(1, 'This is Outdoor Test post 1', 'Test 1', 'Outdoors', 'Eklund', '2015-04-28', 'This is test post 1 for the outdoor blog.', 'This is test post 1 for the outdoor blog.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(2, 'This is Fitness Test Post 1', 'Test 1', 'Fitness', 'Eklund', '2015-04-28', 'This is Fitness test post 1.  This is the long text box for the post.', 'This is fitness test post 1.  This is just a post description', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(3, 'This is Food Test Post 1', 'Test 1', 'Food', 'Eklund', '2015-04-28', 'This is blog post Test 1. This is the actual blog text section.', 'This is test post 1. This is the blog post description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(4, 'This is Project Test post 1', 'Test 1', 'Projects', 'Eklund', '2015-04-28', 'This is test post 1 for Projects. This is the actual blog text.', 'This is test post 1 or Projects. This is the description section.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(5, 'This is Outdoor Test post 2', 'Test 2', 'Outdoors', 'Eklund', '2015-04-28', 'Test post 2. Blog Text.', 'Test post 2. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(6, 'This is Fitness Test Post 2', 'Test 2', 'Fitness', 'Eklund', '2015-04-28', 'Test post 2. Blog Text.', 'Test post 2. Description', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(7, 'This is Food Test Post 2', 'Test 2', 'Food', 'Eklund', '2015-04-28', 'Test post 2. Blog Text.', 'Test post 2. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(8, 'This is Project Test post 2', 'Test 2', 'Projects', 'Eklund', '2015-04-28', 'Test post 2. Blog Text.', 'Test post 2. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(9, 'This is Outdoor Test post 3', 'Test 3', 'Outdoors', 'Eklund', '2015-04-28', 'Test post 3. Blog Text', 'Test post 3. Description', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(10, 'This is Fitness Test Post 3', 'Test 3', 'Fitness', 'Eklund', '2015-04-28', 'Test post 3. Blog Text.', 'Test post 3. description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(11, 'This is Food Test Post 3', 'Test 3', 'Food', 'Eklund', '2015-04-28', 'Test post 3. Blog Text.', 'Test post 3. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(12, 'This is Project Test post 3', 'Test 3', 'Projects', 'Eklund', '2015-04-28', 'Test post 3. Blog Text.', 'Test post 3.Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(13, 'This is Outdoor Test post 4', 'Test 4', 'Outdoors', 'Eklund', '2015-04-28', 'Test post 4. Blog Text.', 'Test post 4. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(14, 'This is Fitness Test Post 4', 'Test 4', 'Fitness', 'Eklund', '2015-04-28', 'Test post 4. Blog Text.', 'Test post 4. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(15, 'This is Food Test Post 4', 'Test 4', 'Food', 'Eklund', '2015-04-28', 'Test post 4. Blog Text.', 'Test post 4. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL),
(16, 'This is Project Test post 4', 'Test 4', 'Projects', 'Eklund', '2015-04-28', 'Test post 4. Blog Text.', 'Test post 4. Description.', './img/boating_rearview.jpg', './img/test_img.png', NULL, NULL, NULL, NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogposts`
--
ALTER TABLE `blogposts`
  ADD CONSTRAINT `FK_users_role_map1` FOREIGN KEY (`author_last_name`) REFERENCES `authors` (`author_last_name`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!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 */;