-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:8889
-- Generation Time: Apr 14, 2016 at 02:18 AM
-- Server version: 5.5.42
-- PHP Version: 5.6.10

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

--
-- Database: `bookmates`
--

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) NOT NULL,
  `event_datetime` datetime NOT NULL,
  `listener_count` int(11) DEFAULT NULL,
  `event_review` varchar(255) DEFAULT NULL,
  `book_ISBN` varchar(15) NOT NULL,
  `venue_address` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `book_title` varchar(100) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`event_id`, `event_datetime`, `listener_count`, `event_review`, `book_ISBN`, `venue_address`, `name`, `email`, `book_title`) VALUES
(23, '2016-04-12 20:38:00', 0, NULL, 'jr833X3tj78C', '3 Carrington Grove, Saint Kilda East, Victoria, Australia', 'Boomkmates', 'potato@gmail.com', 'Follow the Story'),
(24, '2016-04-12 22:02:00', 0, NULL, 'dunqt1rt4sAC', '23 Chapel Street, Saint Kilda, Victoria, Australia', 'Quiin', 'q@gmail.com', 'Op Amp Applications Handbook'),
(25, '2016-04-28 22:20:00', 0, NULL, '53koAJAxVIAC', 'Alma Park East, Dandenong Road, Saint Kilda East, Victoria, Australia', 'Potato', 'ted@gmail.com', 'Once a Week'),
(26, '2016-04-12 22:26:00', 0, NULL, 'TeXygEgvIesC', '34 Wellington Road, Clayton, Victoria, Australia', 'Boomkmates', 'ted@gmail.com', 'Men''s Health Huge in a Hurry'),
(27, '2016-04-12 22:36:00', 0, NULL, 'gN0NAAAAQAAJ', 'Caulfield North, Victoria, Australia', 'hanchen', 'hanchenxie@gmail.com', 'Tom Brown''s School Days'),
(28, '2016-04-12 22:37:00', 0, NULL, 'VeBjAwAAQBAJ', 'Caulfield South, Victoria, Australia', 'hanchen', 'reading.carlton@gmail.com', 'Follow Your Gut'),
(29, '2016-04-12 23:14:00', 0, NULL, 'ONi72cW_n68C', 'Police Road, Mulgrave, Victoria, Australia', 'ted', 'potato@gmail.com', 'Jan Ken Po'),
(30, '2016-04-12 23:54:00', 0, NULL, 'p8L4ngEACAAJ', '67 Chapel Street, Saint Kilda, Victoria, Australia', 'Polish', 'pol@gmail.com', 'Intuitive Listening'),
(31, '2016-04-12 23:58:00', 0, NULL, '6LW2CAAAQBAJ', 'ASD Engineering, Beverage Drive, Tullamarine, Victoria, Australia', 'Ddd', 'dd@gmail.com', 'Beyond Measure'),
(32, '2016-04-16 14:46:00', 0, NULL, 'Ji0pfaXdEK8C', 'Ferntree Gully, Victoria, Australia', 'Reader', 'reader@gnau.coi', 'JQuery UI 1. 8');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`event_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;