   `lat` decimal(10,5) NOT NULL,
   `lng` decimal(10,5) NOT NULL,
   `place_category_id` int(11) NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8;
 
 DROP TABLE IF EXISTS `place_categories`;
 CREATE TABLE IF NOT EXISTS `place_categories` (
 `id` int(11) NOT NULL,
   `title` varchar(40) NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
 
 DROP TABLE IF EXISTS `place_facts`;
 CREATE TABLE IF NOT EXISTS `place_facts` (
+`place_fact_id` int(11) NOT NULL,
   `place_id` int(11) NOT NULL,
   `fact_id` int(11) NOT NULL,
   `detail_text` varchar(1000) DEFAULT NULL,
-  `detail_value` decimal(10,2) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  `detail_value` decimal(10,2) DEFAULT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=944 DEFAULT CHARSET=utf8;
 
 DROP TABLE IF EXISTS `regions`;
 CREATE TABLE IF NOT EXISTS `regions` (
 `id` int(11) NOT NULL,
   `title` varchar(20) NOT NULL,
   `colour` varchar(7) NOT NULL DEFAULT '#00ff00'
-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
 
 
 ALTER TABLE `areas`
- ADD PRIMARY KEY (`id`);
+ ADD PRIMARY KEY (`id`), ADD KEY `region_id` (`region_id`);
 
 ALTER TABLE `area_facts`
- ADD UNIQUE KEY `area_id` (`area_id`,`fact_id`);
+ ADD PRIMARY KEY (`area_fact_id`), ADD UNIQUE KEY `area_id` (`area_id`,`fact_id`), ADD KEY `fact_id` (`fact_id`);
 
 ALTER TABLE `facts`
- ADD PRIMARY KEY (`id`);
+ ADD PRIMARY KEY (`id`), ADD KEY `fact_category_id` (`fact_category_id`);
 
 ALTER TABLE `fact_categories`
  ADD PRIMARY KEY (`id`);

 ADD PRIMARY KEY (`id`);

ALTER TABLE `place_facts`
 ADD UNIQUE KEY `place_id` (`place_id`,`fact_id`), ADD KEY `fact_id` (`fact_id`);

ALTER TABLE `regions`
 ADD PRIMARY KEY (`id`);

ALTER TABLE `places`
ADD CONSTRAINT `places_ibfk_1` FOREIGN KEY (`place_category_id`) REFERENCES `place_categories` (`id`);


DROP TABLE IF EXISTS `area_facts`;
CREATE TABLE IF NOT EXISTS `area_facts` (
`area_fact_id` int(11) NOT NULL,
  `area_id` int(11) NOT NULL,
  `fact_id` int(11) NOT NULL,
  `detail_text` varchar(1000) DEFAULT NULL,
  `detail_value` decimal(10,2) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `facts`;
CREATE TABLE IF NOT EXISTS `facts` (
`id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `fact_category_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `fact_categories`;
CREATE TABLE IF NOT EXISTS `fact_categories` (
`id` int(11) NOT NULL,
  `title` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `places`;
CREATE TABLE IF NOT EXISTS `places` (
