-- 
-- Table structure for table `information`
-- 

DROP TABLE IF EXISTS `information`;
CREATE TABLE IF NOT EXISTS `information` (
  `id` int(11) NOT NULL auto_increment,
  `place_id` int(11) NOT NULL default '0',
  `type` varchar(255) NOT NULL default '',
  `name` text NOT NULL,
  `address` text NOT NULL,
  `open` text NOT NULL,
  `close` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `information`
-- 

INSERT INTO `information` VALUES (1, 1, 'Cinema', 'Jesters Cinema', '101 Lets Bee Avenue', '9pm', '2am');
INSERT INTO `information` VALUES (2, 1, 'Bar', 'Fowlers bar', 'mysql road', '7pm', '11pm');
INSERT INTO `information` VALUES (3, 2, 'Nightclub', '', '', '', '');
INSERT INTO `information` VALUES (4, 2, 'Bar', '', '', '', '');

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

-- 
-- Table structure for table `location`
-- 

DROP TABLE IF EXISTS `location`;
CREATE TABLE IF NOT EXISTS `location` (
  `id` int(11) NOT NULL auto_increment,
  `city` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `location`
-- 

INSERT INTO `location` VALUES (1, 'London');
INSERT INTO `location` VALUES (2, 'Manchester');