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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `information` VALUES (1, 1, 'Cinema');
INSERT INTO `information` VALUES (2, 1, 'Bar');
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;

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

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