-- phpMyAdmin SQL Dump
-- version 4.4.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:8889
-- Generation Time: Apr 19, 2016 at 02:27 PM
-- 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,
  `user_id` varchar(30) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=59 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`, `user_id`) VALUES
(25, '2015-08-09 10:11:20', 0, NULL, '7MDTBwAAQBAJ', 'Caulfield, Victoria, Australia', 'hansen', 'hansen.srini@qq.com', 'Danny Best: Full On', NULL),
(26, '2016-10-10 14:40:00', 0, NULL, '7MDTBwAAQBAJ', 'Caulfield, Victoria, Australia', 'adsf', 'asdf@qq.com', 'Danny Best: Full On', NULL),
(27, '2016-04-20 21:59:00', 0, NULL, 'HpHcGAkFEjkC', 'Caufleld & Flood: Caufield Charles F CPA, Huntley, IL, United States', 'abc', 'cde@qq.com', 'Big Data', NULL),
(28, '2016-04-12 02:00:00', 0, NULL, '7MDTBwAAQBAJ', 'Clayton Station, Clayton Road, Clayton, Victoria, Australia', 'asdf', 'asdfsdf@qac.com', 'Danny Best: Full On', NULL),
(29, '2016-04-13 13:00:00', 0, NULL, 'nbrhnQEACAAJ', 'here', 'Liv Here', 'sillyliv@gmail.com', 'The Very Hungry Caterpillar', NULL),
(30, '2016-04-11 16:12:00', 0, NULL, 'oSsIfoDQHhgC', 'Armadale Primary School, Densham Road, Armadale, Victoria, Australia', 'Thomas', 'thomas.bell@yahoo.com', 'The World Is Flat 3.0', NULL),
(31, '2016-04-11 16:19:00', 0, NULL, 'QagG_KI7Ll8C', 'Tooronga, Malvern, Victoria, Australia', 'Hardy', 'hardy.Thomas@abc.com', 'The Large Scale Structure of Space-Time', NULL),
(32, '2016-04-11 16:24:00', 0, NULL, '6-XFBQAAQBAJ', '3800 Wellington Road, Rowville, Victoria, Australia', 'Shakespeare', 'shaky.global@gmail.com', 'The Taming of the Shrew', NULL),
(33, '2016-04-11 16:32:00', 0, NULL, '2pQFAQAAIAAJ', 'Glen Waverley, Victoria, Australia', 'Birdman', 'Senior@gmail.com', 'Birdman', NULL),
(34, '2016-04-11 16:32:00', 0, NULL, '2pQFAQAAIAAJ', 'Glen Waverley, Victoria, Australia', 'Birdman', 'Senior@gmail.com', 'Birdman', NULL),
(35, '2016-04-11 16:32:00', 0, NULL, '2pQFAQAAIAAJ', 'Glen Waverley, Victoria, Australia', 'Birdman', 'Senior@gmail.com', 'Birdman', NULL),
(36, '2016-04-11 16:38:00', 0, NULL, 'DqbxRp37-DgC', 'Almazett Lebanese Restaurant, Caulfield North, Victoria, Australia', 'anthony', 'anthony@qq.com', 'Another Country', NULL),
(37, '2016-04-11 16:41:00', 0, NULL, '8qLgAAAAMAAJ', 'Dingley Village, Victoria, Australia', 'adsf', 'asdfa@ll.com', 'DA', NULL),
(38, '2016-04-11 16:41:00', 0, NULL, '8qLgAAAAMAAJ', 'Dingley Village, Victoria, Australia', 'adsf', 'asdfa@ll.com', 'DA', NULL),
(39, '2016-04-11 16:49:00', 0, NULL, 'vwMPT-caKNkC', 'Box Hill South, Victoria, Australia', 'Tom', 'abc@qq.com', 'The Meaning of Things', NULL),
(46, '2016-04-11 17:39:00', 0, NULL, '95qY0qz93ZUC', 'Abbotsford Convent, Abbotsford, Victoria, Australia', 'Jack', 'jack.london@qq.com', 'Conquest and Empire', NULL),
(47, '2016-04-11 17:40:00', 0, NULL, 'CZkVBAAAQBAJ', 'Caulfield, Victoria, Australia', 'asdf', 'asdfa@alb.com', 'On these Promising Shores of the Pacific', NULL),
(48, '2016-04-11 17:42:00', 0, NULL, '4eh_iGj2bzsC', 'Caulfield, Victoria, Australia', 'af', 'asdf@qq.com', 'I''ve Got the Light of Freedom', NULL),
(49, '2016-04-11 17:48:00', 0, NULL, 'wKAQoBNR8RcC', 'Caulfield, Victoria, Australia', 'asdf', 'asdf@qq.com', 'Defining Women', NULL),
(50, '2016-04-11 17:50:00', 0, NULL, '-4ngT05gmAQC', 'Adfuzion Pty Ltd, Commercial Road, Melbourne, Victoria, Australia', 'Tab', 'tabber.ammber@qq.com', 'Computer Graphics', NULL),
(51, '2016-04-14 12:57:00', 0, NULL, 'iZeDCgAAQBAJ', 'Caulfield, Victoria, Australia', 'asdb', 'asd@qq.com', 'Art is Dead', NULL),
(52, '2016-04-14 14:18:00', 0, NULL, 'hzv4Kg9gpDYC', 'ASDF, King Street, Newcastle, New South Wales, Australia', 'They', 'them@they.com', 'Beach Beneath the Streets, The', NULL),
(53, '2016-04-17 09:30:00', 0, NULL, 'N01zAwAAQBAJ', 'Clayton South VIC 3169, Australia', 'Tom', 'tom.aa@qq.com', 'Prince Harry', NULL),
(54, '2016-04-27 00:00:00', 0, NULL, 'VwKMDV-Gv1MC', 'Murrumbeena Rd, Murrumbeena VIC, Australia', 'Michael', 'michael.scott@qq.com', 'Human-Machine Reconfigurations', NULL),
(55, '2016-04-21 00:00:00', 0, NULL, 'quQ1AAAAMAAJ', 'Malvern East VIC 3145, Australia', 'Tom', 'Tom@qq.com', ' The continuation of Mr. Rapin''s History of England', NULL),
(56, '2016-04-22 00:00:00', 0, NULL, '0Qz2xcDW7fUC', 'Malvern Rd, Toorak VIC 3142, Australia', 'Tom', 'Tom@qq.com', ' Joseph Christiano''s Bloodtype Diet, Type AB', NULL),
(57, '2016-04-29 00:00:00', 0, NULL, '5-SisV1sLm0C', 'Glenferrie Rd & Wattletree Road, Armadale VIC 3143, Australia', 'Tom', 'Tom@qq.com', ' Cracking the AP Calculus AB & BC Exams', NULL),
(58, '2016-05-27 00:00:00', 0, NULL, 'RFgmAQAAMAAJ', 'Malvern VIC 3144, Australia', 'Tom', 'Tom@qq.com', ' A.B.', NULL);

--
-- 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=59;