--
-- Host: localhost    Database: cyclones
-- ------------------------------------------------------


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `email` varchar(100) NOT NULL,
  `event` int(11) NOT NULL,
  `comment` text NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` VALUES ('javi@backroompr.com',33,'Test',9);

--
-- Table structure for table `evenement`
--

CREATE TABLE `evenement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_bin NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_bin NOT NULL,
  `allDay` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'false',
  `backgroundColor` varchar(20) COLLATE utf8_bin NOT NULL,
  `info` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `evenement`
--

INSERT INTO `evenement` VALUES (25,'Test','2014-11-14 19:00:00','2014-11-13 19:00:00','','false','','Test'),(26,'Test','2014-11-11 19:00:00','2014-11-11 19:00:00','','false','','<p>TTest test</p>'),(28,'Test','2014-12-16 19:00:00','2014-12-17 19:00:00','','false','','zdfvdfvsdf sdf gsdf gsdf gsd'),(29,'Pre-Thanksgiving Party','2014-11-25 19:00:00','2014-11-25 19:00:00','','false','','<p>Please gentlemen join us for the fun and festivities.</p>'),(30,'Test','2015-01-13 00:00:00','2015-01-14 00:00:00','','false','','<p>Test</p>'),(31,'Other','2015-01-13 00:00:00','2015-01-14 00:00:00','','false','',''),(32,'Today\'s','2015-01-12 00:00:00','2015-01-13 00:00:00','','false','',''),(33,'FIRST GRADE PARENTS HAPPY HOUR','2015-01-22 00:00:00','2015-01-23 00:00:00','','false','','<p>TestTEs vFIRST GRADE PARENTS HAPPY HOUR</p>'),(35,'Test','2015-12-04 00:00:00','2015-12-05 00:00:00','','false','','<p>Test</p>'),(36,'Test','2015-12-07 00:00:00','2015-12-08 00:00:00','','false','','<p>Test</p>'),(37,'Test','2015-12-08 00:00:00','2015-12-09 00:00:00','','false','','<p>Test</p>'),(38,'Test Event','2016-03-12 00:00:00','2016-03-13 00:00:00','','false','','<p>Test</p>'),(39,'Another Event','2016-03-24 00:00:00','2016-03-25 00:00:00','','false','','<p>This is only a test</p>'),(40,'Test Event','2016-03-31 00:00:00','2016-03-31 00:00:00','','false','','<p>Test Event</p>');

--
-- Dumping events for database 'cyclones'
--

--
-- Dumping routines for database 'cyclones'
--


