   `leader_telegram_id` int(11) NOT NULL,
   `leader_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
   `registration` datetime NOT NULL,
-  `participants_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
+  `participants_count` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
+  `photo_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 -- --------------------------------------------------------

CREATE TABLE `status` (
  `game_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `state` enum('registered','location_assigned','location_reached','selfie_taken','last_riddle_assigned') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'registered',
  `assigned_riddle_id` int(11) NOT NULL,
  `track_id` int(11) NOT NULL,
  `track_index` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 19, 2016 at 05:51 PM
-- Server version: 5.5.46-0+deb8u1
-- PHP Version: 5.6.17-0+deb8u1

