-- phpMyAdmin SQL Dump
-- version 4.7.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Nov 18, 2017 at 11:52 PM
-- Server version: 5.6.35
-- PHP Version: 7.1.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `project`
--

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

--
-- Table structure for table `Books`
--

CREATE TABLE `Books` (
  `postID` int(5) NOT NULL,
  `bookTitle` varchar(30) NOT NULL,
  `bookAuthor` varchar(50) NOT NULL,
  `bookPages` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Posts`
--

CREATE TABLE `Posts` (
  `postID` int(5) NOT NULL,
  `postUsername` varchar(30) NOT NULL,
  `postTitle` varchar(100) NOT NULL,
  `postDescription` varchar(280) DEFAULT NULL,
  `postImage` varchar(100) DEFAULT NULL,
  `postDateCreated` date NOT NULL,
  `postPrice` int(7) NOT NULL,
  `postDateModified` date NOT NULL,
  `postIssaBook` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Users`
--

CREATE TABLE `Users` (
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `fname` varchar(30) DEFAULT NULL,
  `lname` varchar(30) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Users`
--

INSERT INTO `Users` (`username`, `password`, `email`, `fname`, `lname`, `address`, `admin`) VALUES
('firstuser', 'test', 'firstuser@gmail.com', '', '', NULL, 1),
('michelle', 'salmon', 'sanjay.16@live.com', 'NULL', 'NULL', 'NULL', 0),
('poopoo', 'pupu', 'pupu@gmail.com', 'NULL', 'NULL', 'NULL', 0);

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

--
-- Table structure for table `Videos`
--

CREATE TABLE `Videos` (
  `postID` int(5) NOT NULL,
  `videoTitle` varchar(30) NOT NULL,
  `videoDuration` int(5) NOT NULL,
  `videoGenre` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Books`
--
ALTER TABLE `Books`
  ADD PRIMARY KEY (`postID`);

--
-- Indexes for table `Posts`
--
ALTER TABLE `Posts`
  ADD PRIMARY KEY (`postID`);

--
-- Indexes for table `Users`
--
ALTER TABLE `Users`
  ADD PRIMARY KEY (`username`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `Videos`
--
ALTER TABLE `Videos`
  ADD PRIMARY KEY (`postID`);