db_dump.sql

-- phpMyAdmin SQL Dump
-- version 4.7.1
-- https://www.phpmyadmin.net/
--
-- Host: sql7.freemysqlhosting.net
-- Generation Time: Aug 15, 2020 at 03:54 PM
-- Server version: 5.5.62-0ubuntu0.14.04.1
-- PHP Version: 7.0.33-0ubuntu0.16.04.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `sql7360508`
--

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

--
-- Table structure for table `contests`
--

CREATE TABLE `contests` (
  `id` int(11) NOT NULL,
  `contest_typeid` int(11) NOT NULL,
  `label` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contests`
--

INSERT INTO `contests` (`id`, `contest_typeid`, `label`) VALUES
(101, 1, '2015'),
(102, 1, '2016'),
(103, 1, '2017'),
(104, 1, '2018'),
(105, 1, '2019'),
(106, 2, '2019'),
(107, 2, '2018'),
(108, 3, '2019/1'),
(109, 3, '2019/2'),
(110, 3, '2019/3'),
(111, 3, '2019/4'),
(112, 3, '2019/5'),
(113, 3, '2019/6'),
(114, 3, '2019/7'),
(115, 3, '2019/8'),
(116, 4, '2019/1'),
(117, 4, '2019/2'),
(118, 4, '2019/3'),
(119, 4, '2019/4'),
(120, 4, '2019/5');

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

--
-- Table structure for table `contest_types`
--

CREATE TABLE `contest_types` (
  `id` int(11) NOT NULL,
  `name` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contest_types`
--

INSERT INTO `contest_types` (`id`, `name`) VALUES
(1, 'World Puzzle Championship'),
(2, 'World Sudoku Championship'),
(3, 'Puzzle Grand Prix Round'),
(4, 'Sudoku Grand Prix Round'),
(5, 'Russian Puzzle Championship'),
(6, 'Russian Sudoku Championship'),
(7, 'Moscow Cup');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `country` text CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `country`) VALUES
(10, 'Australia'),
(11, 'Austria'),
(12, 'Bangladesh'),
(13, 'Belarus'),
(14, 'Belgium'),
(15, 'Bulgaria'),
(16, 'Canada'),
(17, 'China'),
(18, 'Croatia'),
(19, 'Czech Republic'),
(20, 'Denmark'),
(21, 'Estonia'),
(22, 'Finland'),
(23, 'France'),
(24, 'Germany'),
(25, 'Greece'),
(26, 'Hungary'),
(27, 'India'),
(28, 'Iran'),
(29, 'Italy'),
(30, 'Japan'),
(31, 'Korea'),
(32, 'Latvia'),
(33, 'Luxembourg'),
(34, 'Netherlands'),
(35, 'New Zealand'),
(36, 'Philippines'),
(37, 'Poland'),
(38, 'Romania'),
(39, 'Russia'),
(40, 'Serbia'),
(41, 'Slovakia'),
(42, 'Slovenia'),
(43, 'Spain'),
(44, 'Switzerland'),
(45, 'Taiwan'),
(46, 'Thailand'),
(47, 'Turkey'),
(48, 'United Kingdom'),
(49, 'USA');

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

--
-- Table structure for table `participants`
--

CREATE TABLE `participants` (
  `id` int(11) NOT NULL,
  `name` text CHARACTER SET utf8 NOT NULL,
  `countryid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `participants`
--

INSERT INTO `participants` (`id`, `name`, `countryid`) VALUES
(10001, 'Helen Arnold', 10),
(10002, 'Anthea McMillan', 10),
(10003, 'Anthony (Tony) Brightling', 10),
(11001, 'Eva-Maria Schuckert', 11),
(11002, 'Michael Moßhammer', 11),
(11003, 'Matthias Reichmayr', 11),
(11004, 'Stefan Leopoldseder', 11),
(11005, 'Manuela Hawel', 11),
(11006, 'Angelika Schobesberger', 11),
(11007, 'Thomas Ballik', 11),
(11008, 'Stefan Ratheyser', 11),
(11009, 'Katrin Mailer', 11),
(12001, 'Orchita Barua', 12),
(12002, 'Tahmid Hameem Chowdhury', 12),
(12003, 'Senjuti Paul', 12),
(12004, 'MD Yamin Islam', 12),
(13001, 'Vladimir Portugalov', 13),
(13002, 'Olga Shut', 13),
(13003, 'Alesia Andreyuk', 13),
(13004, 'Kanstantsin Mikhalev', 13),
(14001, 'Vincent Bertrand', 14),
(15001, 'Deyan Razsadov ', 15),
(15002, 'Alexander Angelov', 15),
(15003, 'Radoslav Bochev ', 15),
(15004, 'Ivan Georgiev', 15),
(15005, 'Svetlozar Stefanov', 15),
(15006, 'Svilen Dyakovski', 15),
(15007, 'Galya Titova', 15),
(15008, 'Borislav Ilevski ', 15),
(15009, 'Anton Titov', 15),
(15010, 'Alexander Vasilev', 15),
(15011, 'Margarita Tsvetkova', 15),
(15012, 'Martin Stefanov', 15),
(15013, 'Lyuben Stoychev', 15),
(16001, 'David Tyler Jones', 16),
(16002, 'Byron Calver', 16),
(16003, 'Carolyn Duke', 16),
(16004, 'Aaron Chan', 16),
(16005, 'David Baines', 16),
(16006, 'Elyot Grant', 16),
(16007, 'Julian West', 16),
(16008, 'Craig Kasper', 16),
(16009, 'Martin Pei', 16),
(16010, 'Jerry Weir', 16),
(17001, 'Tantan Dai', 17),
(17002, 'Weifan Wang', 17),
(17003, 'Yanzhe Qiu', 17),
(17004, 'Xiaowei Huang', 17),
(17005, 'Shiyu Chen', 17),
(17006, 'Cheran Sun', 17),
(17007, 'Mingrui Huang', 17),
(17008, 'Qiu Yanzhe', 17),
(17009, 'Letian Ming', 17),
(17010, 'Yuxuan Hu', 17),
(17011, 'Enyang Li', 17),
(17012, 'Yiting Li', 17),
(17013, 'Suzhe Qiu', 17),
(17014, 'Jinbo Xie', 17),
(17015, 'Hu Yuxuan', 17),
(17016, 'Ming Letian', 17),
(17017, 'Darong Fang', 17),
(17018, 'Zhonghua Huang', 17),
(17019, 'Yang Pei', 17),
(17020, 'Siyu Yao', 17),
(17021, 'Menglei Ma', 17),
(17022, 'Qianyu Hu', 17),
(17023, 'Cen Chen', 17),
(17024, 'Shiyao Wang', 17),
(17025, 'Yao Yue', 17),
(17026, 'Xintong Ji', 17),
(17027, 'Xin Zheng', 17),
(17028, 'Yinchen Qian', 17),
(17029, 'Shichen Jing', 17),
(17030, 'Minghao Wei', 17),
(17031, 'Yue Yao', 17),
(17032, 'Zhaofeng Sun', 17),
(17033, 'Yucheng Tang', 17),
(17034, 'Jiyun Ma', 17),
(17035, 'Yishan Liang', 17),
(17036, 'Yan Xu', 17),
(18001, 'Sanda Reić Tomaš', 18),
(18002, 'Petar Stambuk', 18),
(18003, 'Luka Pavicic', 18),
(18004, 'Sinisa Hrga', 18),
(18005, 'Davor Mestrovic', 18),
(18006, 'Mladen Mestrovic', 18),
(18007, 'Marina Stambuk', 18),
(18008, 'Helena Kelava', 18),
(18009, 'Tina Bratim', 18),
(18010, 'Manuel Ukota', 18),
(18011, 'Zrinka Kokot', 18),
(18012, 'Katarina Cvenic', 18),
(18013, 'Ana Buljan', 18),
(18014, 'Monika Stracenski', 18),
(18015, 'Stipe Bratim', 18),
(19001, 'Jakub Ondrousek', 19),
(19002, 'Jan Novotny', 19),
(19003, 'Jana Vodickova', 19),
(19004, 'Jakub Hrazdira', 19),
(19005, 'Jan Zverina', 19),
(19006, 'Jana Novotna', 19),
(19007, 'Pavel Kadlecik', 19),
(19008, 'Klara Vytiskova', 19),
(19009, 'Pavel Kalhous', 19),
(19010, 'Karel Sterba', 19),
(19011, 'Jana Hanzelkova', 19),
(19012, 'Zdenek Vodicka', 19),
(19013, 'Raul Kacirek', 19),
(19014, 'Veronika Macku', 19),
(19015, 'Robert Babilon', 19),
(19016, 'Michal Matyska', 19),
(19017, 'Jan Ceska', 19),
(19018, 'Petra Cicova', 19),
(19019, 'Petr Vejchoda', 19),
(19020, 'Ondrej Motlicek', 19),
(19021, 'Nelly Pelc-Vostra', 19),
(19022, 'Lucie Klimesova', 19),
(19023, 'Adam Suran', 19),
(19024, 'Jan Vondruska', 19),
(19025, 'Lenka Chaloupkova', 19),
(19026, 'Tomas Krejci', 19),
(19027, 'Martin Kubik', 19),
(20001, 'Henning Kalsgaard Poulsen', 20),
(21001, 'Tiit Vunk', 21),
(21002, 'Jaan Laks', 21),
(21003, 'Marek Oja', 21),
(21004, 'Margit Scheler', 21),
(21005, 'Allar Padari', 21),
(21006, 'Kristi Lehto', 21),
(21007, 'Kertu Luht', 21),
(21008, 'Tauri Purk', 21),
(21009, 'Anna-Brigita Topkin', 21),
(21010, 'Joonas Jurgen Kisel', 21),
(21011, 'Villem Mesila', 21),
(21012, 'Regina Vunk', 21),
(21013, 'Taavi Piller', 21),
(21014, 'Kaja Sostra', 21),
(21015, 'Ragnar Kruberg', 21),
(21016, 'Ethel Maasing', 21),
(21017, 'Virgi Puusepp', 21),
(21018, 'Raido Uibos', 21),
(21019, 'Kulli Laks-Vahemae', 21),
(22001, 'Jaakko Kangasharju', 22),
(22002, 'Ulla Elsila', 22),
(22003, 'Jouni Sarkijarvi', 22),
(22004, 'Henna Perala', 22),
(22005, 'Kangasharju Jaakko', 22),
(22006, 'Maarit Ryynanen', 22),
(22007, 'Markku Lahti', 22),
(23001, 'Bastien Vial-Jaime', 23),
(23002, 'Anne Limoges', 23),
(23003, 'Olivier Rubio', 23),
(23004, 'Timothy Doyle', 23),
(23005, 'Loraine Mignot', 23),
(23006, 'Yannick Meyapin', 23),
(23007, 'Olivier Garconnet', 23),
(23008, 'Jean-Christophe Novelli', 23),
(23009, 'Philippe Meyer', 23),
(23010, 'Louis Nebout', 23),
(23011, 'Denis Auroux', 23),
(23012, 'Francois Blecon', 23),
(23013, 'Magali Monod-Cotte', 23),
(23014, 'Aline Koch', 23),
(23015, 'Christian Romon', 23),
(23016, 'Jerome Lacoste', 23),
(23017, 'Nathalie Catinot', 23),
(23018, 'Theophane Garconnet', 23),
(23019, 'Clement Bossut', 23),
(23020, 'Mathis Saillot', 23),
(23021, 'Edouard Lebeau', 23),
(23022, 'Valerie Garcia', 23),
(23023, 'Geoffroy Hermelin', 23),
(23024, 'Olivier Lignon', 23),
(23025, 'Jean-Baptiste Ridouard', 23),
(23026, 'Sebastien Tainon', 23),
(23027, 'Isabelle Hermelin', 23),
(23028, 'Nadine Brioual', 23),
(24001, 'Michael Ley', 24),
(24002, 'Robert Vollmert', 24),
(24003, 'Philipp Wei?', 24),
(24004, 'Martin Merker', 24),
(24005, 'Ulrich Voigt', 24),
(24006, 'Sebastian Matschke', 24),
(24007, 'Nils Miehe', 24),
(24008, 'Michael Smit', 24),
(24009, 'Silke Berendes', 24),
(24010, 'Jorg Zentgraf', 24),
(24011, 'Christoph Seeliger', 24),
(24012, 'Jonas Gleim', 24),
(24013, 'Bernhard Seckinger', 24),
(24014, 'Maria Graber', 24),
(24015, 'Isabelle Gall', 24),
(24016, 'Michael Niermann-Rossi', 24),
(24017, 'Veronika Lengauer', 24),
(24018, 'Torsten Rogoll', 24),
(24019, 'Kerstin Woge', 24),
(24020, 'Jorg Schneider', 24),
(24021, 'Charlotte Kroll', 24),
(24022, 'Thomas Muller', 24),
(24023, 'Markus Schindler', 24),
(24024, 'Nicole Schadel', 24),
(24025, 'Danielle Hoja', 24),
(24026, 'Imke Herold', 24),
(24027, 'Ute Spreckles', 24),
(24028, 'Hartmut Seeber', 24),
(24029, 'Carmen Gunther', 24),
(24030, 'Carsten Ruhnke', 24),
(24031, 'Florian Habermann', 24),
(24032, 'Larissa Rudolph', 24),
(24033, 'Katharina Bauernschmitt', 24),
(24034, 'Markus Penner', 24),
(24035, 'Jorg Reitze', 24),
(24036, 'Thomas Zimmermann', 24),
(24037, 'Christian Halberstadt', 24),
(24038, 'Franziska Thiele', 24),
(24039, 'Natalie Grabowsky', 24),
(25001, 'Thomas Dimopoulos', 25),
(25002, 'Antonis Lalatsas', 25),
(25003, 'Vasso Kalaitzidou', 25),
(25004, 'Elena Aivazopoulou', 25),
(25005, 'Parisis Ovelidis', 25),
(25006, 'Antony Fandakis', 25),
(25007, 'Iliana-Eleftheria Gounalaki', 25),
(25008, 'Pavlos Zacharopoulos', 25),
(25009, 'Maria Angeloudi', 25),
(25010, 'Spyridon Sofos', 25),
(25011, 'Christos Apostolidis', 25),
(26001, 'Zoltan Gyimesi', 26),
(26002, 'Pal Madarassy ', 26),
(26003, 'Zoltan Horvath', 26),
(26004, 'Viktor Samu', 26),
(26005, 'Peter Gyimesi', 26),
(26006, 'Boglar Major', 26),
(26007, 'Katalin Stolmar ', 26),
(26008, 'Anita Ludanyi', 26),
(26009, 'Tamas Csizmazia ', 26),
(26010, 'Gyorgy Herke', 26),
(26011, 'Kartal Nagy', 26),
(26012, 'Annamaria Jakab', 26),
(26013, 'Gyorgy Istvan', 26),
(26014, 'Zoltan Nemeth ', 26),
(26015, 'Tamas Antal ', 26),
(26016, 'Gerda Nador ', 26),
(26017, 'Miklos Mocsy ', 26),
(26018, 'Fanni Pipo', 26),
(26019, 'Aniko Kozics ', 26),
(26020, 'Erik Kalman', 26),
(26021, 'Szilvia Nagy ', 26),
(26022, 'Kristof Szabo ', 26),
(26023, 'Pipo Fanni', 26),
(26024, 'Imola Kalman', 26),
(26025, 'Robert Steiner', 26),
(26026, 'Agoston Nemeth', 26),
(26027, 'Timea Pipo', 26),
(27001, 'Prasanna Venkatesh Seshadri', 27),
(27002, 'Rohan Rao', 27),
(27003, 'Kishore Kumar Sridharan', 27),
(27004, 'Amit Sowani', 27),
(27005, 'Jaipal Reddy Mogiligundla', 27),
(27006, 'Pranav Kamesh Sivakumar', 27),
(27007, 'Ashish Kumar', 27),
(27008, 'Swaroop Srinivasrao Guggilam', 27),
(27009, 'Gaurav Kumar Jain', 27),
(27010, 'Harmeet Singh', 27),
(27011, 'Rakesh Rai', 27),
(27012, 'Rajesh Kumar', 27),
(27013, 'Rishi Puri', 27),
(27014, 'Rajib Ranjan Borah', 27),
(27015, 'Lenson Mithun Savio Andrade', 27),
(27016, 'Vishal Jain', 27),
(27017, 'Varun Ramachandran', 27),
(27018, 'Hemant Kumar Malani', 27),
(27019, 'Aashay Patil', 27),
(27020, 'Kartik Reddy Mogiligundla', 27),
(27021, 'Akash Doulani', 27),
(27022, 'Shaheer Rahman', 27),
(27023, 'Shambo Debnath', 27),
(27024, 'Poonam Gandhi', 27),
(27025, 'Ezhilasari Mathavan', 27),
(27026, 'Doraisamy Devarajan', 27),
(28001, 'Omid Ostadnorouzi', 28),
(29001, 'Stefano Forcolin', 29),
(29002, 'Giulia Franceschini', 29),
(29003, 'Daniele Filippone', 29),
(29004, 'Laura Tarchetti', 29),
(29005, 'Pierdante Lanzavecchia', 29),
(29006, 'Chiara Nuzio', 29),
(29007, 'Matteo Testa', 29),
(29008, 'Gabriele Carelli', 29),
(29009, 'Giulia Cossutti', 29),
(29010, 'Valerio Stancanelli', 29),
(29011, 'Paolo Tivano', 29),
(29012, 'Valeria Losasso', 29),
(29013, 'Vittorio Schiavone', 29),
(29014, 'Theophane Garconnet', 29),
(29015, 'Giuliano Montelucci', 29),
(29016, 'Michele Bongiorno', 29),
(29017, 'Giorgia Benassi', 29),
(29018, 'Gianluca Mancuso', 29),
(29019, 'Arianna Domenichelli', 29),
(29020, 'Alberto Filippini', 29),
(29021, 'Claudio Toffon', 29),
(29022, 'Luca Marenchino', 29),
(29023, 'Cecilia Soffietto', 29),
(29024, 'Daniele Colnaghi', 29),
(29025, 'Giulio Alberti', 29),
(29026, 'Elena Pertusi', 29),
(30001, 'Ken Endo', 30),
(30002, 'Kota Morinishi', 30),
(30003, 'Takuya Sugimoto', 30),
(30004, 'Hideaki Jo', 30),
(30005, 'Taro Arimatsu', 30),
(30006, 'Yuki Kawabe', 30),
(30007, 'Tomoya Kimura', 30),
(30008, 'Keisui Okuma', 30),
(30009, 'Takeshi Kawasaki', 30),
(30010, 'Kazuya Yamamoto', 30),
(30011, 'Kosei Yoshimori', 30),
(30012, 'Ryusuke Nishiyama', 30),
(30013, 'Ko Okamoto', 30),
(30014, 'Takeya Saikachi', 30),
(30015, 'Takuma Kitamura', 30),
(30016, 'Ryotaro Chiba', 30),
(30017, 'Soji Kubota', 30),
(30018, 'Kento Nikaido', 30),
(30019, 'Yuhei Kusui', 30),
(30020, 'Yuki Kajihara', 30),
(30021, 'Yuki Yamamoto', 30),
(30022, 'Satoshi Ando', 30),
(31001, 'Seungjae Kwak', 31),
(31002, 'Minyoung Joo', 31),
(31003, 'Hwangrae Lee', 31),
(31004, 'Hyunmo Kang', 31),
(31005, 'Jiwon Seo', 31),
(31006, 'Heungchul Park', 31),
(31007, 'Sunghwa Hong', 31),
(31008, 'Hanur Kim', 31),
(31009, 'Hanjun Kang', 31),
(31010, 'Hyuksun Kwon', 31),
(31011, 'Juyoung Lee', 31),
(31012, 'Yoo Dajin', 31),
(31013, 'Sein Kim', 31),
(31014, 'Ha Junseo', 31),
(31015, 'Seo Jiwon', 31),
(31016, 'Hyunkyu Kim', 31),
(31017, 'Sungeon Kwon', 31),
(31018, 'Dajin Yoo', 31),
(31019, 'Jungjoon Lee', 31),
(31020, 'Sunghyun Kwak', 31),
(31021, 'Sunseong Kwon', 31),
(31022, 'Sunghwan Kim', 31),
(31023, 'Seungro Joo', 31),
(31024, 'Seo Yoonjae', 31),
(31025, 'Yunha Jang', 31),
(31026, 'Jiyun Kim', 31),
(31027, 'Seungmin Lee', 31),
(31028, 'Park Jubong', 31),
(31029, 'Junhyuk Ko', 31),
(31030, 'Sungyun Lee', 31),
(31031, 'Jiyun Lim', 31),
(31032, 'Park Kyungsoo', 31),
(31033, 'Seungrok Kim', 31),
(31034, 'You Jinkyo', 31),
(31035, 'Jaemin Lee', 31),
(31036, 'Miyeong Park', 31),
(31037, 'Junghoon Oh', 31),
(31038, 'Seonyu Park', 31),
(31039, 'Hyunggeon Kim', 31),
(31040, 'Hyerin Hwang', 31),
(31041, 'Geonwoo Kang', 31),
(31042, 'Jihye Lee', 31),
(31043, 'Bunran Kim', 31),
(31044, 'Seungjae Choi', 31),
(31045, 'Hansae Lee', 31),
(31046, 'Jiyong Yoon', 31),
(31047, 'Jeongmo Seo', 31),
(31048, 'Misu Kim', 31),
(31049, 'Hyun Eunsoo', 31),
(31050, 'Junghyun Oh', 31),
(31051, 'Eunhee Lee', 31),
(31052, 'Saejoon Jang', 31),
(32001, 'Jelena Balanova', 32),
(32002, 'Liga Vaska', 32),
(32003, 'Marta Sondare', 32),
(32004, 'Juris Jansons', 32),
(33001, 'Claudine Thiry', 33),
(34001, 'Bram de Laat', 34),
(34002, 'Annick Weyzig', 34),
(34003, 'Niels Roest', 34),
(34004, 'Karin Griffioen', 34),
(34005, 'Rick Uppelschoten', 34),
(34006, 'Tom Groot Kormelink', 34),
(34007, 'Delia Keetman', 34),
(34008, 'Richard Stolk', 34),
(34009, 'Dennis Keetman', 34),
(34010, 'Alexander Christiaan Samsom', 34),
(34011, 'Rene Gilhuijs', 34),
(34012, 'Theo Jurrius', 34),
(34013, 'Marcel Van Asperen', 34),
(34014, 'Yuk Yee Lee-Au', 34),
(34015, 'Saskia Benedictus', 34),
(34016, 'Arvid Jurgen Baars', 34),
(34017, 'Siebe Verheijen', 34),
(34018, 'Timon van Dijk', 34),
(34019, 'Robert Bearda', 34),
(34020, 'Lars Slofstra', 34),
(34021, 'Martijn van Brink', 34),
(34022, 'Eline Werkman', 34),
(34023, 'Adriaan Tas', 34),
(35001, 'Matthew Oliver Russell', 35),
(35002, 'George Brian Meale', 35),
(35003, 'Jordan David Hamel', 35),
(35004, 'Samuel Jacob Shillson', 35),
(35005, 'Henry Kenneth Taylor', 35),
(35006, 'Simon Alex O\'Donnell', 35),
(35007, 'Finbarr Pierre Noble', 35),
(36001, 'Ralph Joshua P. Sarrosa', 36),
(36002, 'Jonathan Conrad G. Yu', 36),
(36003, 'Alec Pius D. Machacon', 36),
(36004, 'John Joseph DJ Gabata', 36),
(36005, 'Kirsten Dominique S. Chan', 36),
(36006, 'Enzo Rafael S. Chan', 36),
(37001, 'Tomasz Strozak', 37),
(37002, 'Krystian Swiderski', 37),
(37003, 'Jan Mrozowski', 37),
(37004, 'Piotr Gdowski', 37),
(37005, 'Tomasz Skalski', 37),
(37006, 'Przemyslaw Debiak', 37),
(37007, 'Tomasz Stanczak', 37),
(37008, 'Agnieszka Buczma', 37),
(37009, 'Pawel Kepczynski', 37),
(37010, 'Anna Szymanska', 37),
(37011, 'Wojciech Nadara', 37),
(37012, 'Lukasz Bozykowski', 37),
(37013, 'Lukasz Kalinowski', 37),
(37014, 'Magdalena Bernacik', 37),
(37015, 'Zbigniew Laskowski', 37),
(37016, 'Jakub Majewski', 37),
(38001, 'Alexandru-Denisse Panait', 38),
(38002, 'Stelian-Radu Cacuci', 38),
(39001, 'Dmitry Grishchenko', 39),
(39002, 'Diana Grigoreva', 39),
(39003, 'Ivan Laptiev', 39),
(39004, 'Evgenii Bekishev', 39),
(39005, 'Vladislav Klyachin', 39),
(39006, 'Andrey Bogdanov', 39),
(39007, 'Aleksei Oleshov', 39),
(39008, 'Ivan Grishchenko', 39),
(39009, 'Sergei Biriukov', 39),
(39010, 'Andrey Lemesh', 39),
(39011, 'Diana Paskhina', 39),
(39012, 'Aleksey Laptiev', 39),
(39013, 'Ekaterina Nuzhdina', 39),
(39014, 'Alena Klyachina', 39),
(39015, 'Artemiy Klyachin', 39),
(39016, 'Alexander Stepin', 39),
(40001, 'Nikola Zivanovic', 40),
(40002, 'Zoran Tanasic', 40),
(40003, 'Cedomir Milanovic', 40),
(40004, 'Marko Tanasic', 40),
(40005, 'Marko Obradovic', 40),
(40006, 'Vesna Jovanovic', 40),
(41001, 'Stefan Gaspar', 41),
(41002, 'Matus Demiger', 41),
(41003, 'Natalia Chanova', 41),
(41004, 'Matej Uher', 41),
(41005, 'Peter Hudak', 41),
(41006, 'Pavol Kollar', 41),
(41007, 'Pavel Jaselsky', 41),
(41008, 'Miroslav Salaga', 41),
(41009, 'Marek Papay', 41),
(41010, 'Andrej Plastiak', 41),
(41011, 'Veronika Kolvekova', 41),
(41012, 'Blanka Lehotska', 41),
(41013, 'Igor Hudak', 41),
(41014, 'Martin Fundarek', 41),
(41015, 'Peter Hornak', 41),
(41016, 'Jan Farkas', 41),
(41017, 'Ivana Ondrejkova', 41),
(41018, 'Lubos Hyzak', 41),
(41019, 'Diana Skrhova', 41),
(41020, 'Martina Prinerova', 41),
(41021, 'Jaroslav Grajciar', 41),
(41022, 'Marek Kasar', 41),
(41023, 'Veronika Hrubjakova', 41),
(41024, 'Viliam Balko', 41),
(41025, 'Peter Gaspar', 41),
(41026, 'Miroslav Sunavec', 41),
(41027, 'Lucia Ondovcikova', 41),
(41028, 'Gabriela Jaselska', 41),
(41029, 'Miroslav Ondrejka', 41),
(41030, 'Anna Fundarkova', 41),
(42001, 'Ales Zaloznik', 42),
(43001, 'Olga Diaz', 43),
(44001, 'Roger Kohler', 44),
(44002, 'Michael Genier', 44),
(44003, 'Markus Roth', 44),
(44004, 'Esther Naef', 44),
(44005, 'Christof Bruetsch', 44),
(44006, 'Christoph Bieler', 44),
(44007, 'Jolanda Reusser', 44),
(44008, 'Jeannette Fries', 44),
(44009, 'Marco Togn', 44),
(44010, 'Marco Hauser', 44),
(45001, 'Pang-Yen Hsu', 45),
(46001, 'Tawan Sunathvanichkul', 46),
(46002, 'Sinchai Rungsangrattanakul', 46),
(46003, 'Pitchaya Apichetyota', 46),
(46004, 'Thananon Boonkrong', 46),
(46005, 'Sirawit Pulketkij', 46),
(47001, 'Salih Alan', 47),
(47002, 'Hatice Esra Aydemir', 47),
(47003, 'Taner Karabulut', 47),
(47004, 'Mehmet Durmus', 47),
(47005, 'Fatih Kamer Anda', 47),
(47006, 'Yunus Emre Buyukkale', 47),
(47007, 'Murat Can Tonta', 47),
(47008, 'Serkan Yurekli ', 47),
(47009, 'Serdar Sungun', 47),
(47010, 'Efe Alan', 47),
(47011, 'Beri Kohen', 47),
(47012, 'Mustafa Koyuncu', 47),
(47013, 'Sude Temiz', 47),
(47014, 'Tunahan Turgut', 47),
(47015, 'Zeynep Sengul', 47),
(47016, 'Bahar Acilan', 47),
(47017, 'Bersu Berker', 47),
(47018, 'Aypars Ates Hazantekin', 47),
(47019, 'Muhammed Enes Erol', 47),
(47020, 'Hacer Yesim Ozkaya', 47),
(47021, 'P?nar Ertok', 47),
(47022, 'Fatma Yudum Ozer Akuuz', 47),
(47023, 'Kubilay Berkant Simsek', 47),
(48001, 'Neil Zussman', 48),
(48002, 'Tom Collyer', 48),
(48003, 'James McGowan', 48),
(48004, 'Heather Golding', 48),
(48005, 'David McNeill', 48),
(48006, 'Liane Robinson', 48),
(48007, 'Emma McCaughan', 48),
(48008, 'Mark Goodliffe', 48),
(48009, 'Gareth Moore', 48),
(48010, 'Adam Bissett', 48),
(48011, 'Alan O\'Donnell', 48),
(48012, 'Sam Cappleman-Lynes', 48),
(48013, 'Thomas Powell', 48),
(48014, 'Freddie Hand', 48),
(48015, 'Angus Walker', 48),
(48016, 'Zoe Walker', 48),
(49001, 'Thomas Snyder', 49),
(49002, 'Walker Anderson', 49),
(49003, 'Wei-Hwa Huang', 49),
(49004, 'Palmer Mebane', 49),
(49005, 'Anderson Wang', 49),
(49006, 'Will Blatt', 49),
(49007, 'Jason Zuffranieri', 49),
(49008, 'Asher Walkover ', 49),
(49009, 'Nick Baxter', 49),
(49010, 'Jenna Rivet', 49),
(49011, 'Chris Narrikkattu', 49),
(49012, 'Jim Schneider', 49),
(49013, 'Joshua Zucker', 49);

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

--
-- Table structure for table `results`
--

CREATE TABLE `results` (
  `contest_id` int(11) NOT NULL,
  `participant_id` int(11) NOT NULL,
  `official_rank` int(11) NOT NULL,
  `unofficial_rank` int(11) NOT NULL,
  `points` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `results`
--

INSERT INTO `results` (`contest_id`, `participant_id`, `official_rank`, `unofficial_rank`, `points`) VALUES
(101, 10001, 1, 1, '1000.00'),
(101, 14001, 2, 3, '500.00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `contests`
--
ALTER TABLE `contests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contest_types`
--
ALTER TABLE `contest_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `participants`
--
ALTER TABLE `participants`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `results`
--
ALTER TABLE `results`
  ADD PRIMARY KEY (`contest_id`,`participant_id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;