text: -- MySQL dump 10.15  Distrib 10.0.36-MariaDB, for debian-linux-gnu (x86_64)
  --
  -- Host: localhost    Database: mydbname
  -- ------------------------------------------------------
  -- Server version	10.0.36-MariaDB-0ubuntu0.16.04.1
  
  /*!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 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `bof_archive`
  --
  
  DROP TABLE IF EXISTS `bof_archive`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bof_archive` (
    `archive_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    `year` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `iccm_edition` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`archive_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bof_archive`
  --
  
  LOCK TABLES `bof_archive` WRITE;
  /*!40000 ALTER TABLE `bof_archive` DISABLE KEYS */;
  /*!40000 ALTER TABLE `bof_archive` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bof_archive_leader`
  --
  
  DROP TABLE IF EXISTS `bof_archive_leader`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bof_archive_leader` (
    `leader_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `bof_id` int(10) unsigned DEFAULT NULL,
    `leader` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`leader_id`),
    KEY `bof_id` (`bof_id`),
    CONSTRAINT `bof_archive_leader_ibfk_1` FOREIGN KEY (`bof_id`) REFERENCES `bof_archive_session` (`bof_id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bof_archive_leader`
  --
  
  LOCK TABLES `bof_archive_leader` WRITE;
  /*!40000 ALTER TABLE `bof_archive_leader` DISABLE KEYS */;
  /*!40000 ALTER TABLE `bof_archive_leader` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bof_archive_session`
  --
  
  DROP TABLE IF EXISTS `bof_archive_session`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bof_archive_session` (
    `bof_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `archive_id` int(10) unsigned DEFAULT NULL,
    `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
    `description` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
    `votes` float DEFAULT NULL,
    PRIMARY KEY (`bof_id`),
    KEY `archive_id` (`archive_id`),
    CONSTRAINT `bof_archive_session_ibfk_1` FOREIGN KEY (`archive_id`) REFERENCES `bof_archive` (`archive_id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bof_archive_session`
  --
  
  LOCK TABLES `bof_archive_session` WRITE;
  /*!40000 ALTER TABLE `bof_archive_session` DISABLE KEYS */;
  /*!40000 ALTER TABLE `bof_archive_session` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `bof_metadata`
  --
  
  DROP TABLE IF EXISTS `bof_metadata`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `bof_metadata` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    `iccm_edition` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
    `year` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `maxvotes` int(10) NOT NULL,
    `force_bof` tinyint(1) NOT NULL DEFAULT '0',
    `location` int(10) unsigned NOT NULL,
    `round` int(10) unsigned NOT NULL,
    `bof_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `bof_metadata`
  --
  
  LOCK TABLES `bof_metadata` WRITE;
  /*!40000 ALTER TABLE `bof_metadata` DISABLE KEYS */;
  /*!40000 ALTER TABLE `bof_metadata` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `config`
  --
  
  DROP TABLE IF EXISTS `config`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `config` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `item` varchar(30) COLLATE latin1_general_ci NOT NULL,
    `value` varchar(30) COLLATE latin1_general_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `config`
  --
  
  LOCK TABLES `config` WRITE;
  /*!40000 ALTER TABLE `config` DISABLE KEYS */;
  INSERT INTO `config` VALUES (29,'nomination_begins','2019-01-03 13:04:42'),(30,'nomination_ends','2019-01-04 13:04:42'),(31,'voting_begins','2019-01-04 13:04:42'),(32,'voting_ends','2019-01-06 13:04:42');
  /*!40000 ALTER TABLE `config` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `config_old`
  --
  
  DROP TABLE IF EXISTS `config_old`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `config_old` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `voting_begins` datetime NOT NULL,
    `voting_ends` datetime NOT NULL,
    `nomination_begins` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `nomination_ends` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `config_old`
  --
  
  LOCK TABLES `config_old` WRITE;
  /*!40000 ALTER TABLE `config_old` DISABLE KEYS */;
  INSERT INTO `config_old` VALUES (1,'2018-01-28 13:00:00','2018-01-28 18:00:00','2018-01-25 13:00:00','2018-01-28 13:00:00');
  /*!40000 ALTER TABLE `config_old` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `location`
  --
  
  DROP TABLE IF EXISTS `location`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `location` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `location`
  --
  
  LOCK TABLES `location` WRITE;
  /*!40000 ALTER TABLE `location` DISABLE KEYS */;
  INSERT INTO `location` VALUES (9,'Room A'),(10,'Room B'),(11,'Room C');
  /*!40000 ALTER TABLE `location` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `participant`
  --
  
  DROP TABLE IF EXISTS `participant`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `participant` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
    `password` varchar(255) COLLATE latin1_general_ci NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=MyISAM AUTO_INCREMENT=483 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `participant`
  --
  
  LOCK TABLES `participant` WRITE;
  /*!40000 ALTER TABLE `participant` DISABLE KEYS */;
  INSERT INTO `participant` VALUES (403,'admin','*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29'),(404,'timo','*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29'),(405,'test1','*06C0BF5B64ECE2F648B5F048A71903906BA08E5C'),(406,'test2','*7CEB3FDE5F7A9C4CE5FBE610D7D8EDA62EBE5F4E'),(407,'test3','*F357E78CABAD76FD3F1018EF85D78499B6ACC431'),(408,'test4','*D159BBDA31273BE3F4F00715B4A439925C6A0F2D'),(409,'test5','*30B3620A8C3D75549E8B7F077424EF88B6C798E6'),(410,'test6','*CFB0272DC9E549723E685BB74CBC3D05E4C2AF54'),(411,'test7','*DBB670647A544F1A6C7715B6CEB0B386518E30B8'),(412,'test8','*F88810FD53132CA89291BA2AE8FD63D5A9F031FA'),(413,'test9','*34521800E7C207ED39F616B4132496F98D6C2A9F'),(414,'test10','*A112739E5B6A174DC9A8C9D20657467B3A64A5A7'),(415,'test11','*5B1F769123D770C1E1AF8F9E1D81E54AEC1F65BE'),(416,'test12','*BD3401F3878F4B675C0D55B686EB340AE8D79CDA'),(417,'test13','*E4C752AFD0C137797612D2596AA5634B9C074889'),(418,'test14','*40A9E2A1A842BBCECDED58B44D0D737F5C63D648'),(419,'test15','*D0CAAB800EF9C494FF1205DBA248837FCEC32A4E'),(420,'test16','*6CA7C01E1040ED456521CB2025320785B7180FC6'),(421,'test17','*977B9F29519D32509275ACCAD11895DCCDCCA05E'),(422,'test18','*3BB0C93C43BCC2F79E91F3DCF7962E09492F5619'),(423,'test19','*A5A9BC1295C097D843E3B4C828B66BF6929B17B3'),(424,'user1','*44B12B1BDDF86F44053DCE4518183FA802AC3B8A'),(425,'user2','*38366FDA01695B6A5A9DD4E428D9FB8F7EB75512'),(426,'user3','*A21F1460C5CCDB575E0A7A3B35600BF918CAEA38'),(427,'user4','*4E832DC6A6F24719A68C1242068114AA77CA60D0'),(428,'user5','*DD1C34CA72B473341A6C0EAB6878F07BC45D7854'),(429,'user6','*E910F0D3DC558D1115C9B4BD45C2F44088F66C96'),(430,'user7','*FD0F8AD20F0EB9F9A0B6FC53DC7673D26996C3EA'),(431,'user8','*42FADAA2E05943A4323EFFFC874E9F163242C9C6'),(432,'user9','*DAC8BA74183A661DFFC0E1944C5820D3EBD6B3C2'),(433,'user10','*CE0A63F5EA889D8C8D72E58ED9FEA2332B4D307F'),(434,'user11','*7934597A1AD071FA4B214CAE1C4D7A64DE09B6ED'),(435,'user12','*EADCD2B7B33EF52874137B89730CF8B4F4078603'),(436,'user13','*7117496641C600793D33A887CD563CBF83AD29D3'),(437,'user14','*5FA32D49A387DC30A52BB1F9AD3FBCD8D3703898'),(438,'user15','*D9FDC506A48230E0087F61B1578199A196333EA8'),(439,'user16','*E194CF10D12074C4EF5F552084708BCCECCBC836'),(440,'user17','*C1CC54FDC05E66666AC04A2374D178446C536DB6'),(441,'user18','*7ED8E9B6E2F294FC89FF72915E635022D266A6F2'),(442,'user19','*B1794037FD6CFB11825F2B4E2EF4FE9CD1A3B169'),(443,'user20','*9AD0814019EA37123B2EF368F234DFD84852D192'),(444,'user21','*21072693D5D0223757AB74F4656BEC894A4694F6'),(445,'user22','*EE186682D9A89D80CEF633EAC940C1AB08AA37EE'),(446,'user23','*3484AD6FBB9254AA0C1365BCF65ED1D81AE64D17'),(447,'user24','*9445D437B753DF717C0DD6A9EA76D9D878FA5649'),(448,'user25','*9E007541A7C1B11EF1D8892B9F3037EDEFA7BA5B'),(449,'user26','*A5FDB650B165260B0AA5A4CFB36019C3B2464C58'),(450,'user27','*2BF2D675C4E2567EBA3E131CD907A3E635C1F88A'),(451,'user28','*242589121B19289DB327548954442C46ECFCDBE2'),(452,'user29','*556D58EFA1A1CE9D5B6AD8DC20700CA90069DD6E'),(453,'user30','*87BC5DBAAE1CB9CF22CEA4D9AE5F22559333EB60'),(454,'user31','*938E59A0D702AD8DB63E67F974D50016066B3D37'),(455,'user32','*FBEA3E5CA555B16CC9531CDE2B5F45A6CD7B6A2E'),(456,'user33','*7173DA85DF2516A1FD7C95EF5D2E932296380BCD'),(457,'user34','*A0841EC8D0F5B4726999F51DD9C0BCFDB73CD30B'),(458,'user35','*043BC39E237E172E8A4D891A5B7808FBB36344E7'),(459,'user36','*0C32EBD1AE316E3772C801761F9BDDDE8D4C5BC5'),(460,'user37','*90F469B35EB8CFDF3044ACE6FFCD75A5F17999B4'),(461,'user38','*5A217317332E3ACDF175A29811A341ECA69C1467'),(462,'user39','*B98DEA9696BA2CCA1F5A64C8D4E8875037747276'),(463,'user40','*9DE0B6D04267B2C19B3BD2F9F56BDEA3189D6D74'),(464,'user41','*C80C0CBB7A0F5EC7EC21B5122CAE38DDDDC4E5FB'),(465,'user42','*B4836F3CCFBF6142147121E3142DF796441A25DD'),(466,'user43','*A1035A7B0013E167386321184E1798EC0ADF7003'),(467,'user44','*9A267D355CC6067101EEEF1BDF3FA8CED9176602'),(468,'user45','*5F503ED32873D37A7FC932786C76E6F8258DDCC7'),(469,'user46','*02A00519D2F36A59AEA4F17A762CF8EC7366BC86'),(470,'user47','*1B10EAC76D0DD416A960B72057CD6C35BAA4B20F'),(471,'user48','*AB787E48FFEE2E672C70E567EF6EE1D8C683163B'),(472,'user49','*D0E46F408D6F79BB307FF29FB90548A140C3CE60'),(473,'user50','*C23C80E9347AD5D9F1FA23E5A7833B4FF07828A1'),(474,'user51','*89A3485751FF5483C26102E2BD8C8E6DCBAB9480'),(475,'user52','*0900C08D8D8866E6FE933347AD6496EBC0F844F0'),(476,'user53','*0F0B61F30639372BC44BF7C82F1F64E16412F2C2'),(477,'user54','*9DAEEF473A1225F30791FBE361B75E915C2E232E'),(478,'user55','*C4C709BD11323232E67A19AD327B56C2FE4D2297'),(479,'user56','*2F2099B7B1E16E3E02FF17818AA8F9B61987752C'),(480,'user57','*D87C976D5DA7B8AC0516045EA53AE807D3DF7D56'),(481,'user58','*90423DC31B77FEDB8746844032F3455A3257C390'),(482,'user59','*5D0BF2D1A5CC52B559E4AB77D71CDABC630E405D');
  /*!40000 ALTER TABLE `participant` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `round`
  --
  
  DROP TABLE IF EXISTS `round`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `round` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `time_period` varchar(50) COLLATE latin1_general_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `round`
  --
  
  LOCK TABLES `round` WRITE;
  /*!40000 ALTER TABLE `round` DISABLE KEYS */;
  INSERT INTO `round` VALUES (5,'first'),(6,'second'),(7,'third');
  /*!40000 ALTER TABLE `round` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `workshop`
  --
  
  DROP TABLE IF EXISTS `workshop`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `workshop` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `round_id` int(10) unsigned DEFAULT NULL,
    `location_id` int(10) unsigned DEFAULT NULL,
    `name` varchar(255) COLLATE latin1_general_ci NOT NULL,
    `description` text COLLATE latin1_general_ci NOT NULL,
    `published` tinyint(1) NOT NULL,
    `votes` float DEFAULT NULL,
    `available` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=MyISAM AUTO_INCREMENT=110 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `workshop`
  --
  
  LOCK TABLES `workshop` WRITE;
  /*!40000 ALTER TABLE `workshop` DISABLE KEYS */;
  INSERT INTO `workshop` VALUES (96,NULL,NULL,'topic1','description for topic1',0,NULL,NULL),(97,NULL,NULL,'topic2','description for topic2',0,NULL,NULL),(98,NULL,NULL,'topic3','description for topic3',0,NULL,NULL),(99,NULL,NULL,'topic4','description for topic4',0,NULL,NULL),(100,NULL,NULL,'topic5','description for topic5',0,NULL,NULL),(101,NULL,NULL,'topic6','description for topic6',0,NULL,NULL),(102,NULL,NULL,'topic7','description for topic7',0,NULL,NULL),(103,NULL,NULL,'topic8','description for topic8',0,NULL,NULL),(104,NULL,NULL,'topic9','description for topic9',0,NULL,NULL),(105,NULL,NULL,'topic10','description for topic10',0,NULL,NULL),(106,NULL,NULL,'topic11','description for topic11',0,NULL,NULL),(107,NULL,NULL,'topic12','description for topic12',0,NULL,NULL),(108,NULL,NULL,'topic13','description for topic13',0,NULL,NULL),(109,NULL,NULL,'topic14','description for topic14',0,NULL,NULL);
  /*!40000 ALTER TABLE `workshop` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `workshop_participant`
  --
  
  DROP TABLE IF EXISTS `workshop_participant`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `workshop_participant` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `workshop_id` int(10) unsigned NOT NULL,
    `participant_id` int(10) unsigned NOT NULL,
    `leader` tinyint(1) NOT NULL DEFAULT '0',
    `participant` float NOT NULL DEFAULT '0.25',
    PRIMARY KEY (`id`),
    UNIQUE KEY `workshop_participant are unique` (`workshop_id`,`participant_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2006 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `workshop_participant`
  --
  
  LOCK TABLES `workshop_participant` WRITE;
  /*!40000 ALTER TABLE `workshop_participant` DISABLE KEYS */;
  INSERT INTO `workshop_participant` VALUES (1567,97,424,0,0.25),(1568,98,424,0,0.25),(1569,99,424,0,0.25),(1570,102,424,1,1),(1571,103,424,1,1),(1572,104,424,1,1),(1573,106,424,0,0.25),(1574,96,425,0,0.25),(1575,97,425,1,1),(1576,100,425,0,0.25),(1577,101,425,1,1),(1578,104,425,0,0.25),(1579,105,425,1,1),(1580,107,425,0,0.25),(1581,108,425,0,0.25),(1582,96,426,1,1),(1583,100,426,0,0.25),(1584,101,426,0,0.25),(1585,103,426,0,1),(1586,106,426,0,0.25),(1587,108,426,0,0.25),(1588,109,426,0,0.25),(1589,97,427,0,0.25),(1590,100,427,0,0.25),(1591,101,427,0,1),(1592,102,427,0,1),(1593,103,427,0,1),(1594,104,427,0,0.25),(1595,105,427,0,0.25),(1596,101,428,0,1),(1597,102,428,0,0.25),(1598,104,428,0,0.25),(1599,105,428,0,0.25),(1600,106,428,0,0.25),(1601,107,428,0,0.25),(1602,109,428,1,1),(1603,99,429,0,0.25),(1604,100,429,0,0.25),(1605,101,429,0,0.25),(1606,103,429,0,0.25),(1607,104,429,0,1),(1608,105,429,0,1),(1609,107,429,0,0.25),(1610,101,430,0,1),(1611,102,430,0,0.25),(1612,103,430,0,0.25),(1613,104,430,0,0.25),(1614,107,430,0,0.25),(1615,108,430,0,0.25),(1616,109,430,0,1),(1617,96,431,0,0.25),(1618,98,431,1,1),(1619,99,431,1,1),(1620,102,431,0,1),(1621,103,431,0,0.25),(1622,105,431,0,0.25),(1623,109,431,0,0.25),(1624,96,432,0,0.25),(1625,98,432,0,1),(1626,103,432,0,0.25),(1627,104,432,0,0.25),(1628,106,432,1,1),(1629,107,432,0,0.25),(1630,109,432,0,1),(1631,96,433,0,0.25),(1632,97,433,1,1),(1633,98,433,0,1),(1634,99,433,0,0.25),(1635,101,433,0,0.25),(1636,102,433,0,0.25),(1637,103,433,0,1),(1638,96,434,0,0.25),(1639,98,434,0,1),(1640,100,434,1,1),(1641,102,434,0,0.25),(1642,104,434,0,0.25),(1643,105,434,0,1),(1644,106,434,0,0.25),(1645,96,435,1,1),(1646,99,435,1,1),(1647,100,435,0,0.25),(1648,103,435,0,0.25),(1649,104,435,0,0.25),(1650,105,435,0,0.25),(1651,106,435,0,0.25),(1652,107,435,1,1),(1653,96,436,0,0.25),(1654,99,436,0,0.25),(1655,101,436,0,1),(1656,104,436,0,1),(1657,106,436,0,1),(1658,108,436,0,0.25),(1659,109,436,0,0.25),(1660,98,437,0,0.25),(1661,99,437,0,1),(1662,101,437,0,1),(1663,102,437,0,0.25),(1664,103,437,0,0.25),(1665,104,437,0,1),(1666,106,437,0,0.25),(1667,96,438,0,1),(1668,97,438,0,0.25),(1669,100,438,0,0.25),(1670,101,438,0,1),(1671,102,438,0,0.25),(1672,103,438,0,0.25),(1673,104,438,0,1),(1674,98,439,0,0.25),(1675,99,439,0,0.25),(1676,101,439,0,0.25),(1677,102,439,0,1),(1678,103,439,0,1),(1679,107,439,0,0.25),(1680,108,439,0,0.25),(1681,109,439,0,1),(1682,96,440,0,1),(1683,97,440,0,0.25),(1684,100,440,0,0.25),(1685,103,440,0,0.25),(1686,106,440,0,1),(1687,107,440,0,0.25),(1688,108,440,1,1),(1689,109,440,0,0.25),(1690,97,441,0,1),(1691,101,441,0,0.25),(1692,102,441,0,0.25),(1693,103,441,0,0.25),(1694,107,441,0,1),(1695,108,441,0,0.25),(1696,109,441,0,1),(1697,96,442,0,0.25),(1698,97,442,0,0.25),(1699,98,442,0,0.25),(1700,99,442,0,0.25),(1701,100,442,0,1),(1702,108,442,0,1),(1703,109,442,0,0.25),(1704,96,443,0,0.25),(1705,100,443,0,1),(1706,103,443,0,0.25),(1707,104,443,0,0.25),(1708,105,443,0,1),(1709,106,443,0,1),(1710,107,443,0,0.25),(1711,108,443,0,0.25),(1712,97,444,0,0.25),(1713,98,444,0,0.25),(1714,100,444,0,1),(1715,101,444,0,0.25),(1716,103,444,0,0.25),(1717,104,444,0,1),(1718,106,444,0,1),(1719,109,444,0,0.25),(1720,97,445,0,0.25),(1721,100,445,0,0.25),(1722,101,445,0,0.25),(1723,102,445,0,1),(1724,106,445,0,0.25),(1725,107,445,0,0.25),(1726,109,445,0,1),(1727,98,446,0,0.25),(1728,99,446,0,0.25),(1729,100,446,0,1),(1730,104,446,0,0.25),(1731,105,446,0,0.25),(1732,106,446,0,1),(1733,107,446,0,0.25),(1734,96,447,0,1),(1735,97,447,0,1),(1736,100,447,0,0.25),(1737,101,447,0,0.25),(1738,102,447,0,1),(1739,104,447,0,0.25),(1740,108,447,0,0.25),(1741,109,447,0,0.25),(1742,96,448,0,1),(1743,98,448,0,0.25),(1744,100,448,0,0.25),(1745,101,448,0,1),(1746,106,448,0,0.25),(1747,107,448,0,1),(1748,108,448,0,0.25),(1749,96,449,0,0.25),(1750,98,449,0,1),(1751,99,449,0,0.25),(1752,102,449,0,0.25),(1753,103,449,0,1),(1754,104,449,0,1),(1755,106,449,0,0.25),(1756,108,449,0,0.25),(1757,96,450,0,0.25),(1758,97,450,0,1),(1759,100,450,0,0.25),(1760,102,450,0,1),(1761,105,450,0,1),(1762,106,450,0,0.25),(1763,107,450,0,0.25),(1764,108,450,0,0.25),(1765,96,451,0,1),(1766,97,451,0,1),(1767,100,451,0,0.25),(1768,103,451,0,0.25),(1769,104,451,0,0.25),(1770,106,451,0,1),(1771,107,451,0,0.25),(1772,108,451,0,0.25),(1773,98,452,0,0.25),(1774,99,452,0,0.25),(1775,102,452,0,0.25),(1776,104,452,0,1),(1777,105,452,0,1),(1778,106,452,0,1),(1779,107,452,0,0.25),(1780,96,453,0,1),(1781,97,453,0,1),(1782,102,453,0,1),(1783,103,453,0,0.25),(1784,105,453,0,0.25),(1785,106,453,0,0.25),(1786,107,453,0,0.25),(1787,108,453,0,0.25),(1788,98,454,0,1),(1789,99,454,0,0.25),(1790,100,454,0,0.25),(1791,102,454,0,1),(1792,105,454,0,1),(1793,106,454,0,0.25),(1794,108,454,0,0.25),(1795,109,454,0,0.25),(1796,96,455,0,1),(1797,97,455,0,0.25),(1798,98,455,0,0.25),(1799,99,455,0,0.25),(1800,100,455,0,0.25),(1801,106,455,0,0.25),(1802,108,455,0,1),(1803,96,456,0,1),(1804,99,456,0,0.25),(1805,101,456,0,0.25),(1806,102,456,0,0.25),(1807,103,456,0,0.25),(1808,104,456,0,1),(1809,106,456,0,1),(1810,109,456,0,0.25),(1811,96,457,0,0.25),(1812,97,457,0,1),(1813,98,457,0,0.25),(1814,99,457,0,0.25),(1815,101,457,0,1),(1816,108,457,0,1),(1817,109,457,0,0.25),(1818,98,458,0,1),(1819,99,458,0,0.25),(1820,101,458,0,0.25),(1821,102,458,0,1),(1822,106,458,0,0.25),(1823,107,458,0,0.25),(1824,108,458,0,0.25),(1825,96,459,0,1),(1826,97,459,0,0.25),(1827,98,459,0,1),(1828,100,459,0,1),(1829,101,459,0,0.25),(1830,102,459,0,0.25),(1831,103,459,0,0.25),(1832,104,459,0,0.25),(1833,96,460,0,0.25),(1834,103,460,0,0.25),(1835,104,460,0,0.25),(1836,105,460,0,1),(1837,106,460,0,1),(1838,107,460,0,0.25),(1839,108,460,0,1),(1840,109,460,0,0.25),(1841,97,461,0,1),(1842,99,461,0,1),(1843,100,461,0,0.25),(1844,102,461,0,0.25),(1845,103,461,0,0.25),(1846,104,461,0,1),(1847,106,461,0,0.25),(1848,109,461,0,0.25),(1849,97,462,0,0.25),(1850,98,462,0,0.25),(1851,102,462,0,1),(1852,103,462,0,0.25),(1853,105,462,0,1),(1854,107,462,0,1),(1855,108,462,0,0.25),(1856,96,463,0,0.25),(1857,99,463,0,1),(1858,101,463,0,0.25),(1859,103,463,0,0.25),(1860,106,463,0,1),(1861,108,463,0,1),(1862,109,463,0,0.25),(1863,96,464,0,1),(1864,99,464,0,1),(1865,103,464,0,0.25),(1866,104,464,0,1),(1867,106,464,0,0.25),(1868,107,464,0,0.25),(1869,109,464,0,0.25),(1870,96,465,0,0.25),(1871,98,465,0,1),(1872,99,465,0,0.25),(1873,100,465,0,1),(1874,101,465,0,1),(1875,108,465,0,0.25),(1876,109,465,0,0.25),(1877,98,466,0,0.25),(1878,99,466,0,1),(1879,102,466,0,0.25),(1880,103,466,0,1),(1881,105,466,0,1),(1882,106,466,0,0.25),(1883,108,466,0,0.25),(1884,97,467,0,1),(1885,98,467,0,1),(1886,99,467,0,0.25),(1887,102,467,0,0.25),(1888,105,467,0,0.25),(1889,106,467,0,1),(1890,108,467,0,0.25),(1891,109,467,0,0.25),(1892,96,468,0,0.25),(1893,97,468,0,0.25),(1894,98,468,0,0.25),(1895,99,468,0,1),(1896,100,468,0,1),(1897,102,468,0,0.25),(1898,108,468,0,1),(1899,109,468,0,0.25),(1900,96,469,0,0.25),(1901,97,469,0,0.25),(1902,98,469,0,0.25),(1903,100,469,0,1),(1904,105,469,0,0.25),(1905,106,469,0,1),(1906,108,469,0,1),(1907,96,470,0,0.25),(1908,99,470,0,1),(1909,100,470,0,0.25),(1910,102,470,0,0.25),(1911,103,470,0,0.25),(1912,106,470,0,1),(1913,108,470,0,1),(1914,109,470,0,0.25),(1915,97,471,0,0.25),(1916,98,471,0,0.25),(1917,101,471,0,0.25),(1918,103,471,0,1),(1919,106,471,0,0.25),(1920,107,471,0,1),(1921,108,471,0,0.25),(1922,109,471,0,1),(1923,96,472,0,0.25),(1924,99,472,0,1),(1925,101,472,0,0.25),(1926,103,472,0,0.25),(1927,104,472,0,0.25),(1928,106,472,0,1),(1929,108,472,0,1),(1930,109,472,0,0.25),(1931,96,473,0,0.25),(1932,97,473,0,0.25),(1933,103,473,0,1),(1934,104,473,0,1),(1935,105,473,0,0.25),(1936,106,473,0,0.25),(1937,107,473,0,1),(1938,109,473,0,0.25),(1939,96,474,0,1),(1940,98,474,0,0.25),(1941,100,474,0,1),(1942,101,474,0,0.25),(1943,102,474,0,0.25),(1944,103,474,0,0.25),(1945,105,474,0,1),(1946,106,474,0,0.25),(1947,97,475,0,0.25),(1948,98,475,0,0.25),(1949,99,475,0,1),(1950,102,475,0,0.25),(1951,104,475,0,1),(1952,105,475,0,0.25),(1953,106,475,0,0.25),(1954,108,475,0,1),(1955,97,476,0,0.25),(1956,99,476,0,0.25),(1957,100,476,0,1),(1958,102,476,0,0.25),(1959,103,476,0,1),(1960,106,476,0,0.25),(1961,108,476,0,0.25),(1962,109,476,0,1),(1963,96,477,0,0.25),(1964,97,477,0,0.25),(1965,99,477,0,1),(1966,101,477,0,0.25),(1967,105,477,0,1),(1968,107,477,0,1),(1969,109,477,0,0.25),(1970,97,478,0,0.25),(1971,100,478,0,0.25),(1972,101,478,0,0.25),(1973,102,478,0,1),(1974,103,478,0,1),(1975,106,478,0,1),(1976,108,478,0,0.25),(1977,97,479,0,1),(1978,98,479,0,0.25),(1979,101,479,0,0.25),(1980,103,479,0,0.25),(1981,104,479,0,1),(1982,107,479,0,0.25),(1983,109,479,0,1),(1984,96,480,0,0.25),(1985,97,480,0,0.25),(1986,98,480,0,0.25),(1987,100,480,0,0.25),(1988,104,480,0,1),(1989,106,480,0,0.25),(1990,108,480,0,1),(1991,109,480,0,1),(1992,96,481,0,1),(1993,98,481,0,0.25),(1994,101,481,0,1),(1995,102,481,0,0.25),(1996,103,481,0,0.25),(1997,104,481,0,1),(1998,105,481,0,0.25),(1999,96,482,0,1),(2000,97,482,0,0.25),(2001,101,482,0,0.25),(2002,103,482,0,1),(2003,104,482,0,0.25),(2004,105,482,0,1),(2005,109,482,0,0.25);
  /*!40000 ALTER TABLE `workshop_participant` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!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 */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2019-01-05 19:38:55
  