 CREATE TABLE `locations` (
   `game_id` int(11) NOT NULL,
   `id` int(11) NOT NULL,
+  `code` char(16) COLLATE utf8_unicode_ci NOT NULL,
   `lat` float NOT NULL,
   `lng` float NOT NULL,
   `description` text COLLATE utf8_unicode_ci NOT NULL

-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`game_id`,`id`);

--
-- Indexes for table `log`

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2016 at 01:28 AM
-- Server version: 5.5.46-0+deb8u1
-- PHP Version: 5.6.17-0+deb8u1

