p253591
/
stimmenfryslan
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
stimmenfryslan/data/stimmen.sql

870 lines
28 MiB
MySQL
Raw Permalink Normal View History

first commit
2018-09-28 10:35:17 +02:00
-- MySQL dump 10.16 Distrib 10.1.34-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: gospel.service.rug.nl Database: stimmenfryslan
-- ------------------------------------------------------
-- Server version 5.5.54-MariaDB-1~wheezy
/*!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 */;
--
-- Current Database: `stimmenfryslan`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `stimmenfryslan` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `stimmenfryslan`;
--
-- Table structure for table `auth_group`
--
DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group`
--
LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_group_permissions`
--
DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group_permissions`
--
LOCK TABLES `auth_group_permissions` WRITE;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_permission`
--
DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_permission`
--
LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add permission',2,'add_permission'),(5,'Can change permission',2,'change_permission'),(6,'Can delete permission',2,'delete_permission'),(7,'Can add group',3,'add_group'),(8,'Can change group',3,'change_group'),(9,'Can delete group',3,'delete_group'),(10,'Can add user',4,'add_user'),(11,'Can change user',4,'change_user'),(12,'Can delete user',4,'delete_user'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add survey result',7,'add_surveyresult'),(20,'Can change survey result',7,'change_surveyresult'),(21,'Can delete survey result',7,'delete_surveyresult'),(22,'Can add free speech theme',8,'add_freespeechtheme'),(23,'Can change free speech theme',8,'change_freespeechtheme'),(24,'Can delete free speech theme',8,'delete_freespeechtheme'),(25,'Can add picture game result',9,'add_picturegameresult'),(26,'Can change picture game result',9,'change_picturegameresult'),(27,'Can delete picture game result',9,'delete_picturegameresult'),(28,'Can add survey result question answer',10,'add_surveyresultquestionanswer'),(29,'Can change survey result question answer',10,'change_surveyresultquestionanswer'),(30,'Can delete survey result question answer',10,'delete_surveyresultquestionanswer'),(31,'Can add survey question',11,'add_surveyquestion'),(32,'Can change survey question',11,'change_surveyquestion'),(33,'Can delete survey question',11,'delete_surveyquestion'),(34,'Can add picture game item',12,'add_picturegameitem'),(35,'Can change picture game item',12,'change_picturegameitem'),(36,'Can delete picture game item',12,'delete_picturegameitem'),(37,'Can add survey question category',13,'add_surveyquestioncategory'),(38,'Can change survey question category',13,'change_surveyquestioncategory'),(39,'Can delete survey question category',13,'delete_surveyquestioncategory'),(40,'Can add language',14,'add_language'),(41,'Can change language',14,'change_language'),(42,'Can delete language',14,'delete_language'),(43,'Can add prediction quiz result question answer',15,'add_predictionquizresultquestionanswer'),(44,'Can change prediction quiz result question answer',15,'change_predictionquizresultquestionanswer'),(45,'Can delete prediction quiz result question answer',15,'delete_predictionquizresultquestionanswer'),(46,'Can add free speech result',16,'add_freespeechresult'),(47,'Can change free speech result',16,'change_freespeechresult'),(48,'Can delete free speech result',16,'delete_freespeechresult'),(49,'Can add survey answer',17,'add_surveyanswer'),(50,'Can change survey answer',17,'change_surveyanswer'),(51,'Can delete survey answer',17,'delete_surveyanswer'),(52,'Can add prediction quiz result',18,'add_predictionquizresult'),(53,'Can change prediction quiz result',18,'change_predictionquizresult'),(54,'Can delete prediction quiz result',18,'delete_predictionquizresult');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user`
--
DROP TABLE IF EXISTS `auth_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`password` varchar(128) NOT NULL,
`last_login` datetime DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(254) NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user`
--
LOCK TABLES `auth_user` WRITE;
/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$36000$0OBwFoHG9OTM$ornVKuZMkgBlw2BrKGIoJhXmHvp9EOUTd74Ee+lTZTs=','2018-02-13 12:55:59',1,'admin','','','admin@example.com',1,1,'2017-06-19 10:28:49');
/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user_groups`
--
DROP TABLE IF EXISTS `auth_user_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user_groups`
--
LOCK TABLES `auth_user_groups` WRITE;
/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user_user_permissions`
--
DROP TABLE IF EXISTS `auth_user_user_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user_user_permissions`
--
LOCK TABLES `auth_user_user_permissions` WRITE;
/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_freespeechresult`
--
DROP TABLE IF EXISTS `core_freespeechresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_freespeechresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(255) NOT NULL,
`app_locale` varchar(255) NOT NULL,
`submitted_at` datetime NOT NULL,
`theme_short_text` varchar(255) NOT NULL,
`theme_long_text` varchar(255) NOT NULL,
`recording` varchar(100) NOT NULL,
`language_id` int(11) NOT NULL,
`speech_theme_id` int(11) DEFAULT NULL,
`survey_result_id` int(11) NOT NULL,
`theme_long_text_en` varchar(255) DEFAULT NULL,
`theme_long_text_fy` varchar(255) DEFAULT NULL,
`theme_long_text_nl` varchar(255) DEFAULT NULL,
`theme_short_text_en` varchar(255) DEFAULT NULL,
`theme_short_text_fy` varchar(255) DEFAULT NULL,
`theme_short_text_nl` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `core_freespeechresult_language_id_fa27e656_fk_core_language_id` (`language_id`),
KEY `core_freespeechresul_speech_theme_id_634b3ed3_fk_core_free` (`speech_theme_id`),
KEY `core_freespeechresul_survey_result_id_7f000e9e_fk_core_surv` (`survey_result_id`),
CONSTRAINT `core_freespeechresult_language_id_fa27e656_fk_core_language_id` FOREIGN KEY (`language_id`) REFERENCES `core_language` (`id`),
CONSTRAINT `core_freespeechresul_speech_theme_id_634b3ed3_fk_core_free` FOREIGN KEY (`speech_theme_id`) REFERENCES `core_freespeechtheme` (`id`),
CONSTRAINT `core_freespeechresul_survey_result_id_7f000e9e_fk_core_surv` FOREIGN KEY (`survey_result_id`) REFERENCES `core_surveyresult` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=471 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_freespeechresult`
--
LOCK TABLES `core_freespeechresult` WRITE;
/*!40000 ALTER TABLE `core_freespeechresult` DISABLE KEYS */;
INSERT INTO `core_freespeechresult` VALUES (28,'androidSessionId757771ece59f8d2a505408662355133','fy','2017-07-05 06:47:54','What would you do with a million euros?','What would you do with a million euros?','free_speech_recordings/Frysk/2017-07-05/fs_what-would-you-do-with-a-million-euros_88_lnyzs.wav',1,4,88,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(29,'androidSessionId536c388449d6f7cb21016204031174','nl','2017-07-05 06:50:23','What would you do with a million euros?','What would you do with a million euros?','free_speech_recordings/Nederlands/2017-07-05/fs_what-would-you-do-with-a-million-euros_67_hwgru.wav',3,4,67,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(30,'androidSessionId4178f510153375472496882782070','nl','2017-07-05 07:27:26','What would you do with a million euros?','What would you do with a million euros?','free_speech_recordings/Frysk/2017-07-05/fs_what-would-you-do-with-a-million-euros_95_mvjur.wav',1,4,95,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(31,'androidSessionIdcfb383c434e1bf278704636810518','fy','2017-07-05 07:32:12','What would you do with a million euros?','What would you do with a million euros?','free_speech_recordings/Frysk/2017-07-05/fs_what-would-you-do-with-a-million-euros_111_0i5tx.wav',1,4,111,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(32,'androidSessionIdb7fa38d9ec90f7cc4612338293966','nl','2017-07-05 07:40:13','Joke','Tell us a joke!','free_speech_recordings/Frysk/2017-07-05/fs_joke_99_qt49n.wav',1,2,99,'Tell us a joke!','Fertel in mopke!','Vertel een mop!','Joke','Mopke','Mop'),(33,'androidSessionId31516a38bcd7a3a63085703193875','nl','2017-07-05 07:40:43','Joke','Tell us a joke!','free_speech_recordings/Frysk/2017-07-05/fs_joke_113_bc6pq.wav',1,2,113,'Tell us a joke!','Fertel in mopke!','Vertel een mop!','Joke','Mopke','Mop'),(34,'androidSessionIdb0cb4e748667d77493692009904452','fy','2017-07-05 07:40:44','Joke','Tell us a joke!','free_speech_recordings/Frysk/2017-07-05/fs_joke_123_rcqai.wav',1,2,123,'Tell us a joke!','Fertel in mopke!','Vertel een mop!','Joke','Mopke','Mop'),(35,'androidSessionId31516a38bcd7a3a63115219374338','nl','2017-07-05 07:41:12','Your own story','Tell us your own story here','free_speech_recordings/Frysk/2017-07-05/fs_your-own-story_113_68aqo.wav',1,3,113,'Tell us your own story here','Fertel dyn eigen ferhaal hjir','Vertel je eigen verhaal hier','Your own story','Dyn eigen ferhaal','Je eigen verhaal'),(36,'androidSessionIdb0cb4e748667d77493751185546109','fy','2017-07-05 07:41:43','Joke','Tell us a joke!','free_speech_recordings/Frysk/2017-07-05/fs_joke_123_ut0k4.wav',1,2,123,'Tell us a joke!','Fertel in mopke!','Vertel een mop!','Joke','Mopke','Mop'),(37,'androidSessionIdb7fa38d9ec90f7cc4727759403281','nl','2017-07-05 07:42:10','What would you do with a million euros?','What would you do with a million euros?','free_speech_recordings/Frysk/2017-07-05/fs_what-would-you-do-with-a-million-euros_99_sykw2.wav',1,4,99,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(38,'androidSessionIdb0cb4e748667d77493861406985155','fy','2017-07-05 07:43:33','What would you do with a million euros?','What would you do with a million euros?','free_speech_recor
/*!40000 ALTER TABLE `core_freespeechresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_freespeechtheme`
--
DROP TABLE IF EXISTS `core_freespeechtheme`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_freespeechtheme` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`short_text` varchar(255) NOT NULL,
`long_text` varchar(255) NOT NULL,
`order` int(10) unsigned NOT NULL,
`is_active` tinyint(1) NOT NULL,
`long_text_en` varchar(255) DEFAULT NULL,
`long_text_fy` varchar(255) DEFAULT NULL,
`long_text_nl` varchar(255) DEFAULT NULL,
`short_text_en` varchar(255) DEFAULT NULL,
`short_text_fy` varchar(255) DEFAULT NULL,
`short_text_nl` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_freespeechtheme`
--
LOCK TABLES `core_freespeechtheme` WRITE;
/*!40000 ALTER TABLE `core_freespeechtheme` DISABLE KEYS */;
INSERT INTO `core_freespeechtheme` VALUES (1,'Favourite recipes','Tell us your favourite recipe',2,1,'Tell us your favourite recipe','Diel dyn beste resept','Deel je lievelingsrecept','Favourite recipes','Dyn beste resept','Lievelingsrecept'),(2,'Joke','Tell us a joke!',3,1,'Tell us a joke!','Fertel in mopke!','Vertel een mop!','Joke','Mopke','Mop'),(3,'Your own story','Tell us your own story here',4,1,'Tell us your own story here','Fertel dyn eigen ferhaal hjir','Vertel je eigen verhaal hier','Your own story','Dyn eigen ferhaal','Je eigen verhaal'),(4,'What would you do with a million euros?','What would you do with a million euros?',1,1,'What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?','What would you do with a million euros?','Wat soesto dwaan mei €1.000.000?','Wat zou je doen met €1.000.000?'),(5,'Growing up','Tell us a story about where you grew up?',5,1,'Tell us a story about where you grew up?','Fertel wat oer wêrst wei komst','Vertel iets over waar je bent opgegroeid?','Growing up','Opgroeie','Opgroeien'),(6,'Read a text 1','The North Wind and the Sun were arguing about which one of them was stronger, when a traveler came by wearing a heavy coat. They agreed that whoever got the traveler to take off his coat first would be considered stronger.',6,1,'The North Wind and the Sun were arguing about which one of them was stronger, when a traveler came by wearing a heavy coat. They agreed that whoever got the traveler to take off his coat first would be considered stronger.','De noardewyn en de sinne tsierden oer wa\'t fan har de sterkste wie. Doe kaam der krekt in man foarby mei in waarme jas om him hinne. Se waarden it der oer iens dat dejinge dy\'t de foarbygonger safier krije soe dat er syn jas útlûke soe de sterkste wêze','De noordenwind en de zon waren erover aan het redetwisten wie de sterkste was van hun beiden. Juist op dat moment kwam er een reiziger aan, die gehuld was in een warme mantel.','Read a text 1','Foarlêze 1','Voorlezen 1'),(7,'Read a text 2','The North Wind blew as hard as he could, but the harder he blew, the tighter the traveler wrapped his coat around him, and finally the North Wind had to give up.',7,1,'The North Wind blew as hard as he could, but the harder he blew, the tighter the traveler wrapped his coat around him, and finally the North Wind had to give up.','De noardewyn begûn út alle macht te blazen, mar wat hurder oft er blaasde, nammerste tichter de foarbygonger de jas om him hinne loek. Op \'t lêst joech de noardewyn it mar op.','De noordenwind begon toen uit alle macht te blazen, maar hoe harder ie blies, deste dichter trok de reiziger zijn mantel om zich heen; en ten lange leste gaf de noordenwind het op.','Read a text 2','Foarlêze 2','Voorlezen 2'),(8,'Read a text 3','Then the sun began to shine, and the traveler immediately took off his coat. And so the North Wind had to admit that the Sun was stronger.',8,1,'Then the sun began to shine, and the traveler immediately took off his coat. And so the North Wind had to admit that the Sun was stronger.','Dêrnei begûn de sinne fûl te skinen en fuortendalik dêrnei luts de foarbygonger de jas út. De noardewyn koe doe allinich mar tajaan dat de sinne de sterkste wie.','Daarna begon de zon krachtig te stralen, en hierop trok de reiziger onmiddellijk zijn mantel uit. De noordenwind moest dus wel bekennen dat de zon van hun beiden de sterkste was.','Read a text 3','Foarlêze 3','Voorlezen 3'),(9,'What is your word for...','What is the word for \"potato\" in your local language?',0,1,'What is the word for \"potato\" in your local language?','Wat is it wurd foar \"ierappel\" yn dyn taal?','Wat is het woord voor \"aardappel\" in je taal?','What is your word for...','Wat is dyn wurd foar...','Wat is je woord voor...');
/*!40000 ALTER TABLE `core_freespeechtheme` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_language`
--
DROP TABLE IF EXISTS `core_language`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_language` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`order` int(10) unsigned NOT NULL,
`is_active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_language`
--
LOCK TABLES `core_language` WRITE;
/*!40000 ALTER TABLE `core_language` DISABLE KEYS */;
INSERT INTO `core_language` VALUES (1,'Frysk',0,1),(2,'English',17,1),(3,'Nederlands',1,1),(4,'Gronings',10,1),(5,'Deutsch',15,1),(6,'Norsk',22,1),(7,'Papiamentu',27,1),(8,'Putonghua',28,1),(9,'Hielpers',4,1),(10,'Stellingwarfs',8,1),(11,'Amelands',5,1),(12,'Bildts',3,1),(13,'Drents',9,1),(14,'Stadsfrys',2,1),(15,'Tarafit',32,1),(16,'Sranan',31,1),(17,'Bahasa Indonesia',12,1),(18,'al ʿarabiyya',11,1),(19,'język polski',20,1),(20,'rússkiy yazýk',26,1),(21,'Sarnami Hindustani',29,1),(22,'Français',18,1),(23,'Castellano',13,1),(24,'Català',14,1),(25,'Friisk',19,1),(26,'Seeltersk',30,1),(27,'Schylgers',6,1),(28,'Schiermonnikeigers',7,1),(29,'Galego',16,1),(30,'Niedersächsisch',21,1),(31,'Ostfriesisches Platt',24,1),(32,'Westfälisch',33,1),(33,'Ostfälisch',23,1),(34,'Ostniederdeutsch',25,1);
/*!40000 ALTER TABLE `core_language` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_picturegameitem`
--
DROP TABLE IF EXISTS `core_picturegameitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_picturegameitem` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`picture` varchar(100) NOT NULL,
`name` varchar(255) NOT NULL,
`order` int(10) unsigned NOT NULL,
`is_active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_picturegameitem`
--
LOCK TABLES `core_picturegameitem` WRITE;
/*!40000 ALTER TABLE `core_picturegameitem` DISABLE KEYS */;
INSERT INTO `core_picturegameitem` VALUES (8,'picture_game_pictures/grcat2.png','scheme',8,1),(12,'picture_game_pictures/2_kuikentje.png','Kuikentje',9,1),(13,'picture_game_pictures/3_mond_tweede_versie.png','Mond',10,1),(14,'picture_game_pictures/4_uil.png','Uil',11,1),(15,'picture_game_pictures/5_tunnel.png','Tunnel',12,1),(16,'picture_game_pictures/6_tulp.png','Tulp',13,1),(17,'picture_game_pictures/7_bot.png','Bot',14,1),(18,'picture_game_pictures/8_hoofd.png','Hoofd',15,1),(19,'picture_game_pictures/9_been.png','Been',16,1),(20,'picture_game_pictures/11_tandenborstel.png','Tandenborstel',17,1),(21,'picture_game_pictures/12_bal.png','Bal',18,1),(22,'picture_game_pictures/13_sok_tweede_versie.png','Sok',19,1),(23,'picture_game_pictures/14_vlok.png','Vlok',20,1),(24,'picture_game_pictures/15_kubus.png','Kubus',21,1),(25,'picture_game_pictures/16_kruis.png','Kruis',22,1),(26,'picture_game_pictures/17_vis.png','Vis',23,1),(27,'picture_game_pictures/18_worm.png','Worm',24,1),(28,'picture_game_pictures/19_zon_tweede_versie.png','Zon',25,1),(29,'picture_game_pictures/20_wortel.png','Wortel',26,1),(30,'picture_game_pictures/21_appel.png','Appel',27,1),(31,'picture_game_pictures/21_appel_LLVHtYo.png','Appel',28,0),(32,'picture_game_pictures/22_maan.png','Maan',29,1),(33,'picture_game_pictures/23_aarde.png','Aarde',30,1),(34,'picture_game_pictures/24_bezem.png','Bezem',31,1),(35,'picture_game_pictures/25_bijl_tweede_versie.png','Bijl',32,1),(36,'picture_game_pictures/26_boog.png','Boog',33,1),(37,'picture_game_pictures/27_muur.png','Muur',34,1),(38,'picture_game_pictures/28_molen.png','Molen',35,1),(39,'picture_game_pictures/29_zaag.png','Zaag',36,1),(40,'picture_game_pictures/30_snoepje.png','Snoepje',37,1),(41,'picture_game_pictures/31_nek_tweede_versie.png','Nek',38,1),(42,'picture_game_pictures/32_hart.png','Hart',39,1),(43,'picture_game_pictures/33_berg.png','Berg',40,1),(44,'picture_game_pictures/34_slang.png','Slang',41,1),(45,'picture_game_pictures/35_vijver_second_try.png','Vijver',42,1),(46,'picture_game_pictures/36_ijsbeer.png','Ijsbeer',43,1),(47,'picture_game_pictures/37_muis.png','Muis',44,1),(48,'picture_game_pictures/38_huis_simpel.png','Huis',45,1),(49,'picture_game_pictures/39_spons.png','Spons',46,1),(50,'picture_game_pictures/40_reus_second_try.png','Reus',47,1),(51,'picture_game_pictures/41_heuvel_second_try.png','Heuvel',48,1),(52,'picture_game_pictures/42_vleugel_pijl.png','Vleugel',49,1),(53,'picture_game_pictures/43_reuzenrad.png','Reuzenrad',50,1),(54,'picture_game_pictures/44_blad.png','Blad',51,1),(55,'picture_game_pictures/45_gras.png','Gras',52,1),(56,'picture_game_pictures/46_aap.png','Aap',53,1),(57,'picture_game_pictures/47_banaan.png','Banaan',54,1),(58,'picture_game_pictures/48_kano.png','Kano',55,1),(59,'picture_game_pictures/49_druiven.png','Druiven',56,1),(60,'picture_game_pictures/50_duivel.png','Duivel',57,1),(61,'picture_game_pictures/52_spiegel.png','Spiegel',58,1),(62,'picture_game_pictures/53_venster.png','Venster',59,1),(63,'picture_game_pictures/54_grens.png','Grens',60,1),(64,'picture_game_pictures/55_foto.png','Foto',61,1),(65,'picture_game_pictures/56_hand.png','Hand',62,1),(66,'picture_game_pictures/57_voet.png','Voet',63,1),(67,'picture_game_pictures/58_vuur.png','Vuur',64,1),(68,'picture_game_pictures/59_citroen.png','Citroen',65,1),(69,'picture_game_pictures/60_boom.png','Boom',66,1),(70,'picture_game_pictures/61_bomen.png','Bomen',67,1),(71,'picture_game_pictures/62_oor.png','Oor',68,1),(72,'picture_game_pictures/63_oog.png','Oog',69,1),(73,'picture_game_pictures/64_zeester.png','Zeester',70,1),(74,'picture_game_pictures/65_auto.png','Auto',71,1),(75,'picture_game_pictures/66_arm.png','Arm',72,1),(76,'picture_game_pictures/67_neus.png','Neus',73,1),(77,'picture_game_pictures/68_deur.png','Deur',74,1),(78,'picture_game_pictures/69_meeuw.png','Meeuw',75,1),(79,'picture_game_pictures/70_pauw.png','Pauw',76,1),(80,'picture_game_pictures/71_clown.png','Clown',77,1),(81,'picture_game_pictures/72_roeiboot.png','Roeiboot',78,1),(82,'picture_game_pictures/73_kooi.png','Kooi',79,1),
/*!40000 ALTER TABLE `core_picturegameitem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_picturegameresult`
--
DROP TABLE IF EXISTS `core_picturegameresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_picturegameresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(255) NOT NULL,
`app_locale` varchar(255) NOT NULL,
`submitted_at` datetime NOT NULL,
`picture_path` varchar(255) NOT NULL,
`picture_name` varchar(255) NOT NULL,
`recording` varchar(100) NOT NULL,
`language_id` int(11) NOT NULL,
`picture_game_item_id` int(11) DEFAULT NULL,
`survey_result_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `core_picturegameresult_language_id_c9c34072_fk_core_language_id` (`language_id`),
KEY `core_picturegameresu_picture_game_item_id_cab175aa_fk_core_pict` (`picture_game_item_id`),
KEY `core_picturegameresu_survey_result_id_18e6fbfb_fk_core_surv` (`survey_result_id`),
CONSTRAINT `core_picturegameresult_language_id_c9c34072_fk_core_language_id` FOREIGN KEY (`language_id`) REFERENCES `core_language` (`id`),
CONSTRAINT `core_picturegameresu_picture_game_item_id_cab175aa_fk_core_pict` FOREIGN KEY (`picture_game_item_id`) REFERENCES `core_picturegameitem` (`id`),
CONSTRAINT `core_picturegameresu_survey_result_id_18e6fbfb_fk_core_surv` FOREIGN KEY (`survey_result_id`) REFERENCES `core_surveyresult` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43126 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_picturegameresult`
--
LOCK TABLES `core_picturegameresult` WRITE;
/*!40000 ALTER TABLE `core_picturegameresult` DISABLE KEYS */;
INSERT INTO `core_picturegameresult` VALUES (309,'androidSessionId14b6f72d4b86cb05104494794722700','fy','2017-07-04 11:15:44','picture_game_pictures/63_oog.png','Oog','picture_game_recordings/Frysk/2017-07-04/pg_oog_57_09gxe.wav',1,72,57),(310,'androidSessionId14b6f72d4b86cb05104500814405354','fy','2017-07-04 11:15:50','picture_game_pictures/29_zaag.png','Zaag','picture_game_recordings/Frysk/2017-07-04/pg_zaag_57_eynhv.wav',1,39,57),(311,'androidSessionId14b6f72d4b86cb05104506081485665','fy','2017-07-04 11:15:55','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-07-04/pg_rozen_57_itofl.wav',1,97,57),(312,'androidSessionId14b6f72d4b86cb05104513184494360','fy','2017-07-04 11:16:02','picture_game_pictures/4_uil.png','Uil','picture_game_recordings/Frysk/2017-07-04/pg_uil_57_7at26.wav',1,14,57),(313,'androidSessionId14b6f72d4b86cb05104518807496389','fy','2017-07-04 11:16:08','picture_game_pictures/62_oor.png','Oor','picture_game_recordings/Frysk/2017-07-04/pg_oor_57_086iz.wav',1,71,57),(314,'androidSessionId14b6f72d4b86cb05104523616518210','fy','2017-07-04 11:16:13','picture_game_pictures/82_schoen.png','Schoen','picture_game_recordings/Frysk/2017-07-04/pg_schoen_57_34uk2.wav',1,91,57),(315,'androidSessionId14b6f72d4b86cb05104532057687269','fy','2017-07-04 11:16:21','picture_game_pictures/40_reus_second_try.png','Reus','picture_game_recordings/Frysk/2017-07-04/pg_reus_57_g9pj4.wav',1,50,57),(316,'androidSessionId14b6f72d4b86cb05104536702376799','fy','2017-07-04 11:16:25','picture_game_pictures/43_reuzenrad.png','Reuzenrad','picture_game_recordings/Frysk/2017-07-04/pg_reuzenrad_57_m9bgy.wav',1,53,57),(317,'androidSessionId14b6f72d4b86cb05104543195828619','fy','2017-07-04 11:16:32','picture_game_pictures/77_nagel.png','Nagel','picture_game_recordings/Frysk/2017-07-04/pg_nagel_57_2974d.wav',1,86,57),(318,'androidSessionId14b6f72d4b86cb05104547277630024','fy','2017-07-04 11:16:36','picture_game_pictures/22_maan.png','Maan','picture_game_recordings/Frysk/2017-07-04/pg_maan_57_fi1wx.wav',1,32,57),(319,'androidSessionId7021251b3c699b871494207924087','nl','2017-07-05 06:36:47','picture_game_pictures/73_kooi.png','Kooi','picture_game_recordings/Nederlands/2017-07-05/pg_kooi_65_ymdqg.wav',3,82,65),(320,'androidSessionId7021251b3c699b871512995679550','nl','2017-07-05 06:37:06','picture_game_pictures/32_hart.png','Hart','picture_game_recordings/Nederlands/2017-07-05/pg_hart_65_p4l7x.wav',3,42,65),(321,'androidSessionId6458619a89a7ad7f2394251188207','nl','2017-07-05 06:37:22','picture_game_pictures/16_kruis.png','Kruis','picture_game_recordings/Nederlands/2017-07-05/pg_kruis_63_v27he.wav',3,25,63),(322,'androidSessionIdcfb383c434e1bf277347014517206','fy','2017-07-05 06:37:24','picture_game_pictures/14_vlok.png','Vlok','picture_game_recordings/Frysk/2017-07-05/pg_vlok_66_d7l0s.wav',1,23,66),(323,'androidSessionIdcfb383c434e1bf277356507168591','fy','2017-07-05 06:37:34','picture_game_pictures/32_hart.png','Hart','picture_game_recordings/Frysk/2017-07-05/pg_hart_66_6gqyb.wav',1,42,66),(324,'androidSessionId6458619a89a7ad7f2407083211847','nl','2017-07-05 06:37:35','picture_game_pictures/41_heuvel_second_try.png','Heuvel','picture_game_recordings/Nederlands/2017-07-05/pg_heuvel_63_shek5.wav',3,51,63),(325,'androidSessionIdcfb383c434e1bf277368446518130','fy','2017-07-05 06:37:46','picture_game_pictures/53_venster.png','Venster','picture_game_recordings/Frysk/2017-07-05/pg_venster_66_kv56a.wav',1,62,66),(326,'androidSessionId536c388449d6f7cb20307362275824','nl','2017-07-05 06:38:05','picture_game_pictures/35_vijver_second_try.png','Vijver','picture_game_recordings/Frysk/2017-07-05/pg_vijver_67_hrgkv.wav',1,45,67),(327,'androidSessionIdcfb383c434e1bf277390118626978','fy','2017-07-05 06:38:07','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-07-05/pg_rozen_66_jlo23.wav',1,97,66),(328,'androidSessionId536c388449d6f7cb20313615316055','nl','2017-07-05 06:38:11','picture_game_pictures/71_clown.png','Clown','picture_game_recordings/Frysk/2017-07-05/pg_clown_67_nhcbu.wav',1,80,67),(329,'and
INSERT INTO `core_picturegameresult` VALUES (5574,'androidSessionIda1d7dce35459260b8758372908212','fy','2017-07-05 11:26:08','picture_game_pictures/81_asbak.png','Asbak','picture_game_recordings/Frysk/2017-07-05/pg_asbak_287_uflw4.wav',1,90,287),(5575,'androidSessionIdb7fa38d9ec90f7cc10086115967831','nl','2017-07-05 11:26:09','picture_game_pictures/40_reus_second_try.png','Reus','picture_game_recordings/Frysk/2017-07-05/pg_reus_313_hrmzp.wav',1,50,313),(5576,'androidSessionId73c954db9b0d53ef15137020778439','fy','2017-07-05 11:26:10','picture_game_pictures/48_kano.png','Kano','picture_game_recordings/Frysk/2017-07-05/pg_kano_277_jt7cu.wav',1,58,277),(5577,'androidSessionId6c572eb730a55f2a113503555748710','fy','2017-07-05 11:26:10','picture_game_pictures/16_kruis.png','Kruis','picture_game_recordings/Frysk/2017-07-05/pg_kruis_291_fxwlm.wav',1,25,291),(5578,'androidSessionId9b6a151f81d1f0924868135676761','fy','2017-07-05 11:26:11','picture_game_pictures/32_hart.png','Hart','picture_game_recordings/Frysk/2017-07-05/pg_hart_280_zaopy.wav',1,42,280),(5579,'androidSessionId79f11b1a5d034f6a10285294837381','fy','2017-07-05 11:26:11','picture_game_pictures/38_huis_simpel.png','Huis','picture_game_recordings/Frysk/2017-07-05/pg_huis_303_jv2f4.wav',1,48,303),(5580,'androidSessionId2915a96fa66d840111054683088249','fy','2017-07-05 11:26:12','picture_game_pictures/22_maan.png','Maan','picture_game_recordings/Frysk/2017-07-05/pg_maan_310_frx4u.wav',1,32,310),(5581,'androidSessionId79f11b1a5d034f6a10293634463535','fy','2017-07-05 11:26:19','picture_game_pictures/91_giraffe.png','Giraffe','picture_game_recordings/Frysk/2017-07-05/pg_giraffe_303_60q32.wav',1,100,303),(5582,'androidSessionId73c954db9b0d53ef15146734390132','fy','2017-07-05 11:26:19','picture_game_pictures/50_duivel.png','Duivel','picture_game_recordings/Frysk/2017-07-05/pg_duivel_277_pyzhs.wav',1,60,277),(5583,'androidSessionId3cfe66d56088dfb88208761233565','fy','2017-07-05 11:26:19','picture_game_pictures/47_banaan.png','Banaan','picture_game_recordings/Frysk/2017-07-05/pg_banaan_300_ih97k.wav',1,57,300),(5584,'androidSessionId9b6a151f81d1f0924880054450090','fy','2017-07-05 11:26:22','picture_game_pictures/29_zaag.png','Zaag','picture_game_recordings/Frysk/2017-07-05/pg_zaag_280_dv9ot.wav',1,39,280),(5585,'androidSessionId842c41e30be9c589189018166107449','fy','2017-07-05 11:26:23','picture_game_pictures/8_hoofd.png','Hoofd','picture_game_recordings/Frysk/2017-07-05/pg_hoofd_336_4wrfh.wav',1,18,336),(5586,'androidSessionId6c572eb730a55f2a113518313165163','fy','2017-07-05 11:26:25','picture_game_pictures/17_vis.png','Vis','picture_game_recordings/Frysk/2017-07-05/pg_vis_291_xuepj.wav',1,26,291),(5587,'androidSessionId73c954db9b0d53ef15152578389671','fy','2017-07-05 11:26:25','picture_game_pictures/61_bomen.png','Bomen','picture_game_recordings/Frysk/2017-07-05/pg_bomen_277_g61jh.wav',1,70,277),(5588,'androidSessionId6c572eb730a55f2a113523712364224','fy','2017-07-05 11:26:30','picture_game_pictures/19_zon_tweede_versie.png','Zon','picture_game_recordings/Frysk/2017-07-05/pg_zon_291_45ac7.wav',1,28,291),(5589,'androidSessionId79f11b1a5d034f6a10305050623151','fy','2017-07-05 11:26:30','picture_game_pictures/87_worst.png','Worst','picture_game_recordings/Frysk/2017-07-05/pg_worst_303_km68n.wav',1,96,303),(5590,'androidSessionId3cfe66d56088dfb88223824074412','fy','2017-07-05 11:26:34','picture_game_pictures/49_druiven.png','Druiven','picture_game_recordings/Frysk/2017-07-05/pg_druiven_300_vuek8.wav',1,59,300),(5591,'androidSessionIdb7fa38d9ec90f7cc10111778444371','nl','2017-07-05 11:26:34','picture_game_pictures/64_zeester.png','Zeester','picture_game_recordings/Frysk/2017-07-05/pg_zeester_313_gqfzc.wav',1,73,313),(5592,'androidSessionId9b6a151f81d1f0924892005851543','fy','2017-07-05 11:26:35','picture_game_pictures/37_muis.png','Muis','picture_game_recordings/Frysk/2017-07-05/pg_muis_280_m6cy2.wav',1,47,280),(5593,'androidSessionId6c572eb730a55f2a113529017960576','fy','2017-07-05 11:26:35','picture_game_pictures/20_wortel.png','Wortel','picture_game_recordings/Frysk/2017-07-05/p
INSERT INTO `core_picturegameresult` VALUES (10908,'4F5E220E-77D1-4877-9885-2051FAB5131E','fy','2017-09-20 20:35:47','picture_game_pictures/28_molen.png','Molen','picture_game_recordings/Frysk/2017-09-20/pg_molen_1490_oisk2.wav',1,38,1490),(10909,'androidSessionId95a4768346e1b4321738565777473','fy','2017-09-20 20:35:49','picture_game_pictures/61_bomen.png','Bomen','picture_game_recordings/Frysk/2017-09-20/pg_bomen_1479_zsp4k.wav',1,70,1479),(10910,'androidSessionId7796142f7db6bd13351296067776872','nl','2017-09-20 20:35:50','picture_game_pictures/41_heuvel_second_try.png','Heuvel','picture_game_recordings/Frysk/2017-09-20/pg_heuvel_1502_0ubpe.wav',1,51,1502),(10911,'androidSessionIde5940f09d8a20f9286725681166006','fy','2017-09-20 20:35:50','picture_game_pictures/74_bij.png','Bij','picture_game_recordings/Frysk/2017-09-20/pg_bij_1458_tqrbn.wav',1,83,1458),(10912,'4F5E220E-77D1-4877-9885-2051FAB5131E','fy','2017-09-20 20:35:54','picture_game_pictures/27_muur.png','Muur','picture_game_recordings/Frysk/2017-09-20/pg_muur_1490_nvwsg.wav',1,37,1490),(10913,'B6905E8C-E144-4202-8300-436FE9ECA6AC','fy','2017-09-20 20:35:54','picture_game_pictures/38_huis_simpel.png','Huis','picture_game_recordings/Frysk/2017-09-20/pg_huis_1505_ek4qd.wav',1,48,1505),(10914,'androidSessionIdd059f930f0e1ddc675816081871077','nl','2017-09-20 20:35:55','picture_game_pictures/14_vlok.png','Vlok','picture_game_recordings/Stadsfrys/2017-09-20/pg_vlok_1498_zrneg.wav',14,23,1498),(10915,'androidSessionId95a4768346e1b4321747404217414','fy','2017-09-20 20:35:58','picture_game_pictures/62_oor.png','Oor','picture_game_recordings/Frysk/2017-09-20/pg_oor_1479_etpha.wav',1,71,1479),(10916,'4F5E220E-77D1-4877-9885-2051FAB5131E','fy','2017-09-20 20:36:01','picture_game_pictures/26_boog.png','Boog','picture_game_recordings/Frysk/2017-09-20/pg_boog_1490_cn0s9.wav',1,36,1490),(10917,'androidSessionId95a4768346e1b4321753025799445','fy','2017-09-20 20:36:03','picture_game_pictures/63_oog.png','Oog','picture_game_recordings/Frysk/2017-09-20/pg_oog_1479_rptib.wav',1,72,1479),(10918,'androidSessionId7796142f7db6bd13351310078965670','nl','2017-09-20 20:36:04','picture_game_pictures/27_muur.png','Muur','picture_game_recordings/Frysk/2017-09-20/pg_muur_1502_ljsd2.wav',1,37,1502),(10919,'androidSessionIde5940f09d8a20f9286739256159189','fy','2017-09-20 20:36:04','picture_game_pictures/91_giraffe.png','Giraffe','picture_game_recordings/Frysk/2017-09-20/pg_giraffe_1458_r3czm.wav',1,100,1458),(10920,'androidSessionId95a4768346e1b4321759209118537','fy','2017-09-20 20:36:09','picture_game_pictures/64_zeester.png','Zeester','picture_game_recordings/Frysk/2017-09-20/pg_zeester_1479_aghsy.wav',1,73,1479),(10921,'4F5E220E-77D1-4877-9885-2051FAB5131E','fy','2017-09-20 20:36:10','picture_game_pictures/25_bijl_tweede_versie.png','Bijl','picture_game_recordings/Frysk/2017-09-20/pg_bijl_1490_s9giv.wav',1,35,1490),(10922,'B6905E8C-E144-4202-8300-436FE9ECA6AC','fy','2017-09-20 20:36:12','picture_game_pictures/54_grens.png','Grens','picture_game_recordings/Frysk/2017-09-20/pg_grens_1505_69yec.wav',1,63,1505),(10923,'androidSessionIdd059f930f0e1ddc675833677032685','nl','2017-09-20 20:36:13','picture_game_pictures/73_kooi.png','Kooi','picture_game_recordings/Stadsfrys/2017-09-20/pg_kooi_1498_jreyw.wav',14,82,1498),(10924,'androidSessionId95a4768346e1b4321764194683723','fy','2017-09-20 20:36:14','picture_game_pictures/65_auto.png','Auto','picture_game_recordings/Frysk/2017-09-20/pg_auto_1479_ixcne.wav',1,74,1479),(10925,'4F5E220E-77D1-4877-9885-2051FAB5131E','fy','2017-09-20 20:36:17','picture_game_pictures/24_bezem.png','Bezem','picture_game_recordings/Frysk/2017-09-20/pg_bezem_1490_itd5g.wav',1,34,1490),(10926,'androidSessionIde5940f09d8a20f9286753485609217','fy','2017-09-20 20:36:18','picture_game_pictures/7_bot.png','Bot','picture_game_recordings/Frysk/2017-09-20/pg_bot_1458_vs21g.wav',1,17,1458),(10927,'androidSessionId95a4768346e1b4321769592816047','fy','2017-09-20 20:36:20','picture_game_pictures/66_arm.png','Arm','picture_game_recordings/Frysk/2017-09-20/pg_arm_1479_ob52n.wav',1,75,1479),(1
INSERT INTO `core_picturegameresult` VALUES (16072,'androidSessionId369b7b3e94e47a0d3435371569823457','fy','2017-09-22 09:50:15','picture_game_pictures/72_roeiboot.png','Roeiboot','picture_game_recordings/Frysk/2017-09-22/pg_roeiboot_2355_ajcyh.wav',1,81,2355),(16073,'androidSessionId369b7b3e94e47a0d3435380752226787','fy','2017-09-22 09:50:24','picture_game_pictures/74_bij.png','Bij','picture_game_recordings/Frysk/2017-09-22/pg_bij_2355_xprag.wav',1,83,2355),(16074,'androidSessionId369b7b3e94e47a0d3435394594128240','fy','2017-09-22 09:50:38','picture_game_pictures/75_trui.png','Trui','picture_game_recordings/Frysk/2017-09-22/pg_trui_2355_o5cwg.wav',1,84,2355),(16075,'androidSessionId369b7b3e94e47a0d3435404638178236','fy','2017-09-22 09:50:49','picture_game_pictures/76_spuit.png','Spuit','picture_game_recordings/Frysk/2017-09-22/pg_spuit_2355_nqe8t.wav',1,85,2355),(16076,'androidSessionId369b7b3e94e47a0d3435414521011566','fy','2017-09-22 09:50:58','picture_game_pictures/77_nagel.png','Nagel','picture_game_recordings/Frysk/2017-09-22/pg_nagel_2355_n5dji.wav',1,86,2355),(16077,'androidSessionId369b7b3e94e47a0d3435425094611770','fy','2017-09-22 09:51:09','picture_game_pictures/78_aardbei.png','Aardbei','picture_game_recordings/Frysk/2017-09-22/pg_aardbei_2355_ye76x.wav',1,87,2355),(16078,'androidSessionId369b7b3e94e47a0d3435435112214475','fy','2017-09-22 09:51:19','picture_game_pictures/79_ei.png','Ei','picture_game_recordings/Frysk/2017-09-22/pg_ei_2355_3pbh0.wav',1,88,2355),(16079,'androidSessionId369b7b3e94e47a0d3435444239689888','fy','2017-09-22 09:51:27','picture_game_pictures/80_haai.png','Haai','picture_game_recordings/Frysk/2017-09-22/pg_haai_2355_v0wgh.wav',1,89,2355),(16080,'androidSessionId369b7b3e94e47a0d3435453847935717','fy','2017-09-22 09:51:38','picture_game_pictures/81_asbak.png','Asbak','picture_game_recordings/Frysk/2017-09-22/pg_asbak_2355_aqdri.wav',1,90,2355),(16081,'androidSessionId369b7b3e94e47a0d3435463460208214','fy','2017-09-22 09:51:47','picture_game_pictures/82_schoen.png','Schoen','picture_game_recordings/Frysk/2017-09-22/pg_schoen_2355_c2qea.wav',1,91,2355),(16082,'androidSessionId369b7b3e94e47a0d3435473169764668','fy','2017-09-22 09:51:57','picture_game_pictures/83_neuzen.png','Neuzen','picture_game_recordings/Frysk/2017-09-22/pg_neuzen_2355_52sep.wav',1,92,2355),(16083,'androidSessionId369b7b3e94e47a0d3435483392244664','fy','2017-09-22 09:52:08','picture_game_pictures/84_ogen.png','Ogen','picture_game_recordings/Frysk/2017-09-22/pg_ogen_2355_ybntp.wav',1,93,2355),(16084,'androidSessionId369b7b3e94e47a0d3435503357871740','fy','2017-09-22 09:52:27','picture_game_pictures/85_haan.png','Haan','picture_game_recordings/Frysk/2017-09-22/pg_haan_2355_5puqm.wav',1,94,2355),(16085,'androidSessionId369b7b3e94e47a0d3435512138265070','fy','2017-09-22 09:52:35','picture_game_pictures/86_ster.png','Ster','picture_game_recordings/Frysk/2017-09-22/pg_ster_2355_5mnrj.wav',1,95,2355),(16086,'androidSessionId369b7b3e94e47a0d3435521143583817','fy','2017-09-22 09:52:44','picture_game_pictures/87_worst.png','Worst','picture_game_recordings/Frysk/2017-09-22/pg_worst_2355_905dv.wav',1,96,2355),(16087,'androidSessionId369b7b3e94e47a0d3435530009134230','fy','2017-09-22 09:52:54','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-09-22/pg_rozen_2355_fzajo.wav',1,97,2355),(16088,'androidSessionId369b7b3e94e47a0d3435539108753185','fy','2017-09-22 09:53:03','picture_game_pictures/89_jurk.png','Jurk','picture_game_recordings/Frysk/2017-09-22/pg_jurk_2355_j0ouf.wav',1,98,2355),(16089,'androidSessionId369b7b3e94e47a0d3435555010753804','fy','2017-09-22 09:53:18','picture_game_pictures/90_sleutel.png','Sleutel','picture_game_recordings/Frysk/2017-09-22/pg_sleutel_2355_x8mha.wav',1,99,2355),(16090,'androidSessionId369b7b3e94e47a0d3435563959636300','fy','2017-09-22 09:53:28','picture_game_pictures/91_giraffe.png','Giraffe','picture_game_recordings/Frysk/2017-09-22/pg_giraffe_2355_xhdwr.wav',1,100,2355),(16091,'78D258AC-7EE0-4E5A-BF51-ABA80EBD9E9B','en','2017-09-22 10:01:00','picture_game_pictures/36
INSERT INTO `core_picturegameresult` VALUES (21199,'androidSessionId5c497f575e97a8f22550552128982','fy','2017-09-24 10:32:06','picture_game_pictures/53_venster.png','Venster','picture_game_recordings/Frysk/2017-09-24/pg_venster_3236_e60mf.wav',1,62,3236),(21200,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:32:11','picture_game_pictures/47_banaan.png','Banaan','picture_game_recordings/Frysk/2017-09-24/pg_banaan_3240_dxqkz.wav',1,57,3240),(21201,'2CC361F7-8F90-494C-8123-8CC7B4A70422','nl','2017-09-24 10:32:16','picture_game_pictures/8_hoofd.png','Hoofd','picture_game_recordings/Frysk/2017-09-24/pg_hoofd_3249_vjmwb.wav',1,18,3249),(21202,'androidSessionId5c497f575e97a8f22561750888705','fy','2017-09-24 10:32:17','picture_game_pictures/18_worm.png','Worm','picture_game_recordings/Frysk/2017-09-24/pg_worm_3236_16lhq.wav',1,27,3236),(21203,'androidSessionId5c497f575e97a8f22567779253201','fy','2017-09-24 10:32:23','picture_game_pictures/66_arm.png','Arm','picture_game_recordings/Frysk/2017-09-24/pg_arm_3236_pqvt9.wav',1,75,3236),(21204,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:32:26','picture_game_pictures/52_spiegel.png','Spiegel','picture_game_recordings/Frysk/2017-09-24/pg_spiegel_3240_w2xr4.wav',1,61,3240),(21205,'2CC361F7-8F90-494C-8123-8CC7B4A70422','nl','2017-09-24 10:32:28','picture_game_pictures/26_boog.png','Boog','picture_game_recordings/Frysk/2017-09-24/pg_boog_3249_w4eqy.wav',1,36,3249),(21206,'androidSessionId5c497f575e97a8f22574188165773','fy','2017-09-24 10:32:30','picture_game_pictures/61_bomen.png','Bomen','picture_game_recordings/Frysk/2017-09-24/pg_bomen_3236_tzx4h.wav',1,70,3236),(21207,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:32:35','picture_game_pictures/72_roeiboot.png','Roeiboot','picture_game_recordings/Frysk/2017-09-24/pg_roeiboot_3240_oyb19.wav',1,81,3240),(21208,'androidSessionId5c497f575e97a8f22582939591421','fy','2017-09-24 10:32:39','picture_game_pictures/39_spons.png','Spons','picture_game_recordings/Frysk/2017-09-24/pg_spons_3236_o1cub.wav',1,49,3236),(21209,'androidSessionId5c497f575e97a8f22592202075799','fy','2017-09-24 10:32:48','picture_game_pictures/59_citroen.png','Citroen','picture_game_recordings/Frysk/2017-09-24/pg_citroen_3236_ptwo7.wav',1,68,3236),(21210,'androidSessionId5c497f575e97a8f22601217724985','fy','2017-09-24 10:32:57','picture_game_pictures/28_molen.png','Molen','picture_game_recordings/Frysk/2017-09-24/pg_molen_3236_xj8rk.wav',1,38,3236),(21211,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:33:10','picture_game_pictures/79_ei.png','Ei','picture_game_recordings/Frysk/2017-09-24/pg_ei_3240_sp1jx.wav',1,88,3240),(21212,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:33:16','picture_game_pictures/82_schoen.png','Schoen','picture_game_recordings/Frysk/2017-09-24/pg_schoen_3240_psfyw.wav',1,91,3240),(21213,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:33:23','picture_game_pictures/8_hoofd.png','Hoofd','picture_game_recordings/Frysk/2017-09-24/pg_hoofd_3240_d7yrh.wav',1,18,3240),(21214,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:33:32','picture_game_pictures/33_berg.png','Berg','picture_game_recordings/Frysk/2017-09-24/pg_berg_3240_pib68.wav',1,43,3240),(21215,'androidSessionId5c497f575e97a8f22640032549572','fy','2017-09-24 10:33:36','picture_game_pictures/69_meeuw.png','Meeuw','picture_game_recordings/Frysk/2017-09-24/pg_meeuw_3236_a6qze.wav',1,78,3236),(21216,'androidSessionId5c497f575e97a8f22644917600646','fy','2017-09-24 10:33:41','picture_game_pictures/67_neus.png','Neus','picture_game_recordings/Frysk/2017-09-24/pg_neus_3236_av96z.wav',1,76,3236),(21217,'DE58F71E-783B-4997-AB36-FB378CDB5DE3','fy','2017-09-24 10:33:45','picture_game_pictures/6_tulp.png','Tulp','picture_game_recordings/Frysk/2017-09-24/pg_tulp_3240_t9v32.wav',1,16,3240),(21218,'androidSessionId5c497f575e97a8f22650532829834','fy','2017-09-24 10:33:46','picture_game_pictures/43_reuzenrad.png','Reuzenrad','picture_game_recordings/Frysk/2017-09-24/pg_reuzenrad_3236_6talv.wav',1,53,3236),(21219,'androidSessionId5c497
INSERT INTO `core_picturegameresult` VALUES (26307,'androidSessionId9e5363960f6b7a9021851427321140','fy','2017-09-27 18:57:08','picture_game_pictures/66_arm.png','Arm','picture_game_recordings/Frysk/2017-09-27/pg_arm_4620_5hvg1.wav',1,75,4620),(26308,'androidSessionId9e5363960f6b7a9021854598819368','fy','2017-09-27 18:57:11','picture_game_pictures/86_ster.png','Ster','picture_game_recordings/Frysk/2017-09-27/pg_ster_4620_j3x4p.wav',1,95,4620),(26309,'androidSessionId9e5363960f6b7a9021857775786398','fy','2017-09-27 18:57:14','picture_game_pictures/11_tandenborstel.png','Tandenborstel','picture_game_recordings/Frysk/2017-09-27/pg_tandenborstel_4620_i8yhp.wav',1,20,4620),(26310,'androidSessionId9e5363960f6b7a9021861205440772','fy','2017-09-27 18:57:18','picture_game_pictures/4_uil.png','Uil','picture_game_recordings/Frysk/2017-09-27/pg_uil_4620_wvfxy.wav',1,14,4620),(26311,'androidSessionId9e5363960f6b7a9021864612772177','fy','2017-09-27 18:57:21','picture_game_pictures/46_aap.png','Aap','picture_game_recordings/Frysk/2017-09-27/pg_aap_4620_cke16.wav',1,56,4620),(26312,'androidSessionId9e5363960f6b7a9021867903035144','fy','2017-09-27 18:57:25','picture_game_pictures/23_aarde.png','Aarde','picture_game_recordings/Frysk/2017-09-27/pg_aarde_4620_zenc1.wav',1,33,4620),(26313,'androidSessionId9e5363960f6b7a9021871348247226','fy','2017-09-27 18:57:28','picture_game_pictures/7_bot.png','Bot','picture_game_recordings/Frysk/2017-09-27/pg_bot_4620_4f6bu.wav',1,17,4620),(26314,'androidSessionId9e5363960f6b7a9021875819062589','fy','2017-09-27 18:57:32','picture_game_pictures/28_molen.png','Molen','picture_game_recordings/Frysk/2017-09-27/pg_molen_4620_um2zs.wav',1,38,4620),(26315,'androidSessionId9e5363960f6b7a9021878956788630','fy','2017-09-27 18:57:36','picture_game_pictures/13_sok_tweede_versie.png','Sok','picture_game_recordings/Frysk/2017-09-27/pg_sok_4620_wh3am.wav',1,22,4620),(26316,'androidSessionId9e5363960f6b7a9021882612148732','fy','2017-09-27 18:57:39','picture_game_pictures/79_ei.png','Ei','picture_game_recordings/Frysk/2017-09-27/pg_ei_4620_u4v73.wav',1,88,4620),(26317,'androidSessionId9e5363960f6b7a9021885869377950','fy','2017-09-27 18:57:43','picture_game_pictures/58_vuur.png','Vuur','picture_game_recordings/Frysk/2017-09-27/pg_vuur_4620_1rna9.wav',1,67,4620),(26318,'androidSessionId9e5363960f6b7a9021889223852063','fy','2017-09-27 18:57:46','picture_game_pictures/24_bezem.png','Bezem','picture_game_recordings/Frysk/2017-09-27/pg_bezem_4620_tyxho.wav',1,34,4620),(26319,'androidSessionId9e5363960f6b7a9021892366483052','fy','2017-09-27 18:57:49','picture_game_pictures/64_zeester.png','Zeester','picture_game_recordings/Frysk/2017-09-27/pg_zeester_4620_87eqd.wav',1,73,4620),(26320,'androidSessionId9e5363960f6b7a9021895765658415','fy','2017-09-27 18:57:52','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-09-27/pg_rozen_4620_lkrpb.wav',1,97,4620),(26321,'androidSessionId9e5363960f6b7a9021899750708205','fy','2017-09-27 18:57:56','picture_game_pictures/84_ogen.png','Ogen','picture_game_recordings/Frysk/2017-09-27/pg_ogen_4620_q8mw0.wav',1,93,4620),(26322,'androidSessionId9e5363960f6b7a9021902904547891','fy','2017-09-27 18:58:00','picture_game_pictures/63_oog.png','Oog','picture_game_recordings/Frysk/2017-09-27/pg_oog_4620_17rnc.wav',1,72,4620),(26323,'androidSessionId9e5363960f6b7a9021906131060390','fy','2017-09-27 18:58:03','picture_game_pictures/69_meeuw.png','Meeuw','picture_game_recordings/Frysk/2017-09-27/pg_meeuw_4620_jewo1.wav',1,78,4620),(26324,'androidSessionId9e5363960f6b7a9021910665648305','fy','2017-09-27 18:58:07','picture_game_pictures/14_vlok.png','Vlok','picture_game_recordings/Frysk/2017-09-27/pg_vlok_4620_x8krq.wav',1,23,4620),(26325,'androidSessionId9e5363960f6b7a9021914014349033','fy','2017-09-27 18:58:11','picture_game_pictures/36_ijsbeer.png','Ijsbeer','picture_game_recordings/Frysk/2017-09-27/pg_ijsbeer_4620_xdnrj.wav',1,46,4620),(26326,'androidSessionId9e5363960f6b7a9021917145096167','fy','2017-09-27 18:58:14','picture_game_pictures/48_kano.png','Kano','picture_game_record
INSERT INTO `core_picturegameresult` VALUES (31411,'androidSessionIdf025ac29bcc3cad3269188861193','fy','2017-10-11 10:23:36','picture_game_pictures/81_asbak.png','Asbak','picture_game_recordings/Frysk/2017-10-11/pg_asbak_5394_oxjcy.wav',1,90,5394),(31412,'androidSessionIdf025ac29bcc3cad3276848570270','fy','2017-10-11 10:23:44','picture_game_pictures/82_schoen.png','Schoen','picture_game_recordings/Frysk/2017-10-11/pg_schoen_5394_4zkqe.wav',1,91,5394),(31413,'androidSessionIdf025ac29bcc3cad3284967695117','fy','2017-10-11 10:23:52','picture_game_pictures/83_neuzen.png','Neuzen','picture_game_recordings/Frysk/2017-10-11/pg_neuzen_5394_6ixco.wav',1,92,5394),(31414,'androidSessionIdf025ac29bcc3cad3294733241118','fy','2017-10-11 10:24:02','picture_game_pictures/84_ogen.png','Ogen','picture_game_recordings/Frysk/2017-10-11/pg_ogen_5394_7s0pc.wav',1,93,5394),(31415,'androidSessionIdf025ac29bcc3cad3304647615503','fy','2017-10-11 10:24:12','picture_game_pictures/85_haan.png','Haan','picture_game_recordings/Frysk/2017-10-11/pg_haan_5394_0dpyo.wav',1,94,5394),(31416,'androidSessionIdf025ac29bcc3cad3315917051350','fy','2017-10-11 10:24:23','picture_game_pictures/86_ster.png','Ster','picture_game_recordings/Frysk/2017-10-11/pg_ster_5394_e0v4m.wav',1,95,5394),(31417,'androidSessionIdf025ac29bcc3cad3323753650581','fy','2017-10-11 10:24:31','picture_game_pictures/87_worst.png','Worst','picture_game_recordings/Frysk/2017-10-11/pg_worst_5394_xjuqw.wav',1,96,5394),(31418,'androidSessionIdf025ac29bcc3cad3330750466043','fy','2017-10-11 10:24:38','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-10-11/pg_rozen_5394_gez5y.wav',1,97,5394),(31419,'androidSessionIdf025ac29bcc3cad3341092334274','fy','2017-10-11 10:24:48','picture_game_pictures/89_jurk.png','Jurk','picture_game_recordings/Frysk/2017-10-11/pg_jurk_5394_f31cx.wav',1,98,5394),(31420,'androidSessionIdf025ac29bcc3cad3348200347736','fy','2017-10-11 10:24:55','picture_game_pictures/90_sleutel.png','Sleutel','picture_game_recordings/Frysk/2017-10-11/pg_sleutel_5394_lsnb1.wav',1,99,5394),(31421,'androidSessionIdf025ac29bcc3cad3355729949583','fy','2017-10-11 10:25:03','picture_game_pictures/91_giraffe.png','Giraffe','picture_game_recordings/Frysk/2017-10-11/pg_giraffe_5394_9qijk.wav',1,100,5394),(31422,'androidSessionIdf025ac29bcc3cad3365352352737','fy','2017-10-11 10:25:12','picture_game_pictures/grcat2.png','scheme','picture_game_recordings/Frysk/2017-10-11/pg_scheme_5394_hafxk.wav',1,8,5394),(31423,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:28','picture_game_pictures/43_reuzenrad.png','Reuzenrad','picture_game_recordings/Nederlands/2017-10-11/pg_reuzenrad_5395_anpeh.wav',3,53,5395),(31424,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:36','picture_game_pictures/78_aardbei.png','Aardbei','picture_game_recordings/Nederlands/2017-10-11/pg_aardbei_5395_b9a21.wav',3,87,5395),(31425,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:43','picture_game_pictures/76_spuit.png','Spuit','picture_game_recordings/Nederlands/2017-10-11/pg_spuit_5395_a8vyo.wav',3,85,5395),(31426,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:49','picture_game_pictures/7_bot.png','Bot','picture_game_recordings/Nederlands/2017-10-11/pg_bot_5395_bcu12.wav',3,17,5395),(31427,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:54','picture_game_pictures/61_bomen.png','Bomen','picture_game_recordings/Nederlands/2017-10-11/pg_bomen_5395_li9qy.wav',3,70,5395),(31428,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:30:59','picture_game_pictures/28_molen.png','Molen','picture_game_recordings/Nederlands/2017-10-11/pg_molen_5395_qmz4v.wav',3,38,5395),(31429,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:31:07','picture_game_pictures/53_venster.png','Venster','picture_game_recordings/Nederlands/2017-10-11/pg_venster_5395_e6h1y.wav',3,62,5395),(31430,'96FA9A91-9285-49CB-9602-C8682C434893','nl','2017-10-11 10:31:14','picture_game_pictures/55_foto.png','Foto','picture_game_recordings/Nederlands/2017-10-11/pg_foto_53
INSERT INTO `core_picturegameresult` VALUES (36555,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:47:26','picture_game_pictures/91_giraffe.png','Giraffe','picture_game_recordings/Frysk/2017-10-25/pg_giraffe_6126_xsjn6.wav',1,100,6126),(36556,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:47:49','picture_game_pictures/90_sleutel.png','Sleutel','picture_game_recordings/Frysk/2017-10-25/pg_sleutel_6126_80xz5.wav',1,99,6126),(36557,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:48:09','picture_game_pictures/88_rozen.png','Rozen','picture_game_recordings/Frysk/2017-10-25/pg_rozen_6126_yjob6.wav',1,97,6126),(36558,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:48:19','picture_game_pictures/87_worst.png','Worst','picture_game_recordings/Frysk/2017-10-25/pg_worst_6126_tygf5.wav',1,96,6126),(36559,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:48:32','picture_game_pictures/86_ster.png','Ster','picture_game_recordings/Frysk/2017-10-25/pg_ster_6126_o3c7n.wav',1,95,6126),(36560,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:48:53','picture_game_pictures/85_haan.png','Haan','picture_game_recordings/Frysk/2017-10-25/pg_haan_6126_hvucf.wav',1,94,6126),(36561,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:49:05','picture_game_pictures/84_ogen.png','Ogen','picture_game_recordings/Frysk/2017-10-25/pg_ogen_6126_bw0a9.wav',1,93,6126),(36562,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:49:16','picture_game_pictures/83_neuzen.png','Neuzen','picture_game_recordings/Frysk/2017-10-25/pg_neuzen_6126_6d0aq.wav',1,92,6126),(36563,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:49:28','picture_game_pictures/82_schoen.png','Schoen','picture_game_recordings/Frysk/2017-10-25/pg_schoen_6126_2c7fn.wav',1,91,6126),(36564,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:49:47','picture_game_pictures/81_asbak.png','Asbak','picture_game_recordings/Frysk/2017-10-25/pg_asbak_6126_l4r3a.wav',1,90,6126),(36565,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:49:59','picture_game_pictures/80_haai.png','Haai','picture_game_recordings/Frysk/2017-10-25/pg_haai_6126_3gjbq.wav',1,89,6126),(36566,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:50:23','picture_game_pictures/79_ei.png','Ei','picture_game_recordings/Frysk/2017-10-25/pg_ei_6126_19azp.wav',1,88,6126),(36567,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:50:34','picture_game_pictures/78_aardbei.png','Aardbei','picture_game_recordings/Frysk/2017-10-25/pg_aardbei_6126_dgsxi.wav',1,87,6126),(36568,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:50:44','picture_game_pictures/77_nagel.png','Nagel','picture_game_recordings/Frysk/2017-10-25/pg_nagel_6126_pv15g.wav',1,86,6126),(36569,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:50:54','picture_game_pictures/76_spuit.png','Spuit','picture_game_recordings/Frysk/2017-10-25/pg_spuit_6126_8xym5.wav',1,85,6126),(36570,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:03','picture_game_pictures/75_trui.png','Trui','picture_game_recordings/Frysk/2017-10-25/pg_trui_6126_nx5kd.wav',1,84,6126),(36571,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:15','picture_game_pictures/74_bij.png','Bij','picture_game_recordings/Frysk/2017-10-25/pg_bij_6126_h7pxa.wav',1,83,6126),(36572,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:28','picture_game_pictures/73_kooi.png','Kooi','picture_game_recordings/Frysk/2017-10-25/pg_kooi_6126_732zb.wav',1,82,6126),(36573,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:37','picture_game_pictures/72_roeiboot.png','Roeiboot','picture_game_recordings/Frysk/2017-10-25/pg_roeiboot_6126_zs0lo.wav',1,81,6126),(36574,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:46','picture_game_pictures/71_clown.png','Clown','picture_game_recordings/Frysk/2017-10-25/pg_clown_6126_salw4.wav',1,80,6126),(36575,'512F55FC-70ED-4A5A-AB9C-0C1C8142A1E2','fy','2017-10-25 11:51:57','picture_game_pictures/70_pauw.png','Pauw','picture_game_
INSERT INTO `core_picturegameresult` VALUES (41625,'androidSessionIdcdffd7c4d8a09ea682114548399918','fy','2017-12-08 15:09:00','picture_game_pictures/2_kuikentje.png','Kuikentje','picture_game_recordings/Frysk/2017-12-08/pg_kuikentje_6753_g9v27.wav',1,12,6753),(41626,'androidSessionIdcdffd7c4d8a09ea682119962519707','fy','2017-12-08 15:09:06','picture_game_pictures/5_tunnel.png','Tunnel','picture_game_recordings/Frysk/2017-12-08/pg_tunnel_6753_5ryn9.wav',1,15,6753),(41627,'androidSessionIdcdffd7c4d8a09ea682128079275017','fy','2017-12-08 15:09:14','picture_game_pictures/26_boog.png','Boog','picture_game_recordings/Frysk/2017-12-08/pg_boog_6753_y7zlk.wav',1,36,6753),(41628,'androidSessionIdcdffd7c4d8a09ea682134689203972','fy','2017-12-08 15:09:21','picture_game_pictures/9_been.png','Been','picture_game_recordings/Frysk/2017-12-08/pg_been_6753_4atvw.wav',1,19,6753),(41629,'androidSessionIdcdffd7c4d8a09ea682139969565168','fy','2017-12-08 15:09:26','picture_game_pictures/63_oog.png','Oog','picture_game_recordings/Frysk/2017-12-08/pg_oog_6753_o35mt.wav',1,72,6753),(41630,'androidSessionIdcdffd7c4d8a09ea682148873141623','fy','2017-12-08 15:09:35','picture_game_pictures/15_kubus.png','Kubus','picture_game_recordings/Frysk/2017-12-08/pg_kubus_6753_fqzra.wav',1,24,6753),(41631,'androidSessionIdcdffd7c4d8a09ea682161198103441','fy','2017-12-08 15:09:47','picture_game_pictures/32_hart.png','Hart','picture_game_recordings/Frysk/2017-12-08/pg_hart_6753_42vpd.wav',1,42,6753),(41632,'androidSessionIdcdffd7c4d8a09ea682166748908387','fy','2017-12-08 15:09:53','picture_game_pictures/42_vleugel_pijl.png','Vleugel','picture_game_recordings/Frysk/2017-12-08/pg_vleugel_6753_y0c7a.wav',1,52,6753),(41633,'androidSessionIdcdffd7c4d8a09ea682177110558383','fy','2017-12-08 15:10:03','picture_game_pictures/87_worst.png','Worst','picture_game_recordings/Frysk/2017-12-08/pg_worst_6753_ifch4.wav',1,96,6753),(41634,'androidSessionIdcdffd7c4d8a09ea682181788465829','fy','2017-12-08 15:10:08','picture_game_pictures/24_bezem.png','Bezem','picture_game_recordings/Frysk/2017-12-08/pg_bezem_6753_5gov6.wav',1,34,6753),(41635,'androidSessionIdcdffd7c4d8a09ea682186322097859','fy','2017-12-08 15:10:12','picture_game_pictures/4_uil.png','Uil','picture_game_recordings/Frysk/2017-12-08/pg_uil_6753_p5gyr.wav',1,14,6753),(41636,'androidSessionIdcdffd7c4d8a09ea682193659780564','fy','2017-12-08 15:10:20','picture_game_pictures/55_foto.png','Foto','picture_game_recordings/Frysk/2017-12-08/pg_foto_6753_f1587.wav',1,64,6753),(41637,'androidSessionIdcdffd7c4d8a09ea682198542058583','fy','2017-12-08 15:10:24','picture_game_pictures/16_kruis.png','Kruis','picture_game_recordings/Frysk/2017-12-08/pg_kruis_6753_cv6pq.wav',1,25,6753),(41638,'androidSessionIdcdffd7c4d8a09ea682204618980873','fy','2017-12-08 15:10:31','picture_game_pictures/64_zeester.png','Zeester','picture_game_recordings/Frysk/2017-12-08/pg_zeester_6753_8wu53.wav',1,73,6753),(41639,'androidSessionIdcdffd7c4d8a09ea682237032528360','fy','2017-12-08 15:11:03','picture_game_pictures/79_ei.png','Ei','picture_game_recordings/Frysk/2017-12-08/pg_ei_6753_itojw.wav',1,88,6753),(41640,'8801B889-FD5C-4896-BE91-AED34E2E8875','nl','2017-12-08 15:15:03','picture_game_pictures/4_uil.png','Uil','picture_game_recordings/Frysk/2017-12-08/pg_uil_6796_671z5.wav',1,14,6796),(41641,'8801B889-FD5C-4896-BE91-AED34E2E8875','nl','2017-12-08 15:15:12','picture_game_pictures/4_uil.png','Uil','picture_game_recordings/Frysk/2017-12-08/pg_uil_6796_nsuga.wav',1,14,6796),(41642,'8801B889-FD5C-4896-BE91-AED34E2E8875','nl','2017-12-08 15:15:21','picture_game_pictures/18_worm.png','Worm','picture_game_recordings/Frysk/2017-12-08/pg_worm_6796_vja5i.wav',1,27,6796),(41643,'8801B889-FD5C-4896-BE91-AED34E2E8875','nl','2017-12-08 15:15:33','picture_game_pictures/14_vlok.png','Vlok','picture_game_recordings/Frysk/2017-12-08/pg_vlok_6796_ck1wn.wav',1,23,6796),(41644,'8801B889-FD5C-4896-BE91-AED34E2E8875','nl','2017-12-08 15:15:40','picture_game_pictures/12_bal.png','Bal','picture_game_recordings/Frysk/2017-12-08/pg_bal_6796_ufd1q.wav',1,21,6796),(41645,'8801
/*!40000 ALTER TABLE `core_picturegameresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_predictionquizresult`
--
DROP TABLE IF EXISTS `core_predictionquizresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_predictionquizresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(255) NOT NULL,
`app_locale` varchar(255) NOT NULL,
`submitted_at` datetime NOT NULL,
`language` smallint(5) unsigned NOT NULL,
`area1_name` varchar(255) NOT NULL,
`area2_name` varchar(255) NOT NULL,
`area3_name` varchar(255) NOT NULL,
`rating` smallint(5) unsigned DEFAULT NULL,
`survey_result_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `core_predictionquizr_survey_result_id_fc86b531_fk_core_surv` (`survey_result_id`),
CONSTRAINT `core_predictionquizr_survey_result_id_fc86b531_fk_core_surv` FOREIGN KEY (`survey_result_id`) REFERENCES `core_surveyresult` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13413 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_predictionquizresult`
--
LOCK TABLES `core_predictionquizresult` WRITE;
/*!40000 ALTER TABLE `core_predictionquizresult` DISABLE KEYS */;
INSERT INTO `core_predictionquizresult` VALUES (10,'androidSessionId3d32791a57e2344a2327699101040','en','2017-06-20 04:04:07',0,'Appelscha Fr / Appelskea Fr','Joure Fr / De Jouwer Fr','Oudega Fr / Aldegea Fr',3,NULL),(11,'androidSessionId7b9f58b4e9f51203781503729880727','en','2017-06-25 00:19:40',0,'Appelscha Fr / Appelskea Fr','Joure Fr / De Jouwer Fr','Oudega Fr / Aldegea Fr',1,NULL),(13,'androidSessionId4aab7e2a20ea6c05274529160575284','fy','2017-06-26 08:51:58',0,'Appelscha Fr / Appelskea Fr','Joure Fr / De Jouwer Fr','Oudega Fr / Aldegea Fr',4,NULL),(16,'androidSessionId28c621c90d4e2b3371578994012614','fy','2017-06-27 04:08:55',0,'Appelscha Fr / Appelskea Fr','Bakkeveen Fr / Bakkefean Fr','Buren Fr / Bueren Fr',3,NULL),(17,'androidSessionIdc22b3a34567ba3ca285714026742478','en','2017-06-27 04:14:20',0,'Anjum Fr / Eanjum Fr','Appelscha Fr / Appelskea Fr','Beetgumermolen Fr / Bitgummole Fr',NULL,NULL),(18,'580C09CC-BE09-4795-9BCD-C309657A40EF','fy','2017-06-27 04:35:14',0,'Formerum Fr / Formearum Fr','West-Terschelling Fr / West-Skylge Fr','West-Terschelling Fr / West-Skylge Fr',NULL,NULL),(19,'androidSessionIdc22b3a34567ba3ca288361170312395','fy','2017-06-27 05:58:50',0,'Appelscha Fr / Appelskea Fr','Joure Fr / De Jouwer Fr','Oudega Fr / Aldegea Fr',3,NULL),(20,'DD7DA3CE-175E-4872-88B6-6182A82FFAA8','en','2017-06-27 08:30:21',0,'Formerum Fr / Formearum Fr','Lies Fr','Lies Fr',NULL,NULL),(22,'8125F36A-4DA7-4057-A45D-5479D3097B9D','en','2017-06-27 08:56:43',0,'Nijeholtpade Fr','Scherpenzeel Fr','Scherpenzeel Fr',NULL,NULL),(23,'32B2FC6E-8FC6-4B44-ABA6-1DDF827C5C21','en','2017-06-28 08:30:25',0,'Oosterend Fr / Aasterein Fr','Midsland Fr / Midsl','Midsland Fr / Midsl',NULL,NULL),(24,'520DF80E-C152-426F-B7A1-E41CC7AEE584','nl','2017-06-28 13:17:24',0,'Lies Fr','Formerum Fr / Formearum Fr','Formerum Fr / Formearum Fr',NULL,NULL),(25,'EDF77942-3CD7-4113-A4EF-150B16149A50','en','2017-06-29 02:36:33',0,'Formerum Fr / Formearum Fr','Oosterend Fr / Aasterein Fr','Oosterend Fr / Aasterein Fr',NULL,NULL),(26,'E18CC97A-8118-4C63-821E-7B4FD7E0F5DB','en','2017-06-29 02:39:33',0,'Ijlst Fr / Drylts Fr','Grouw Fr / Grou Fr','Grouw Fr / Grou Fr',NULL,NULL),(27,'androidSessionId22e1bcec9adc5f55000303339295','en','2017-07-03 07:32:57',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(28,'androidSessionId22e1bcec9adc5f55021264169508','fy','2017-07-03 07:33:17',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(29,'androidSessionIdc22b3a34567ba3ca13687453650480','nl','2017-07-03 07:34:09',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',3,NULL),(30,'androidSessionIdc22b3a34567ba3ca13758150613694','fy','2017-07-03 07:35:20',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(31,'androidSessionId28c621c90d4e2b33101553174748868','nl','2017-07-03 07:36:53',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',4,NULL),(32,'androidSessionIdc22b3a34567ba3ca13872741182887','nl','2017-07-03 07:37:14',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(33,'F9701371-2005-4E24-A4F8-C40BD5A51615','en','2017-07-03 07:59:19',0,'Sloten Fr / Sleat Fr','Spannum Fr','Spannum Fr',NULL,NULL),(34,'androidSessionId14b6f72d4b86cb0558936507872559','fy','2017-07-03 10:18:33',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(35,'androidSessionId14b6f72d4b86cb0562926431823646','fy','2017-07-03 11:37:21',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',1,NULL),(36,'androidSessionId14b6f72d4b86cb0563723754240113','fy','2017-07-03 11:50:38',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',1,56),(37,'androidSessionId22e1bcec9adc5f61061969386958','fy','2017-07-03 12:32:51',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(38,'androidSessionId28c621c90d4e2b33111403629851361','en','2017-07-03 12:32:52',0,'Akkrum Fr','Anjum Fr / Eanjum Fr','Arum Fr',NULL,NULL),(39,'androidSessionId28d9dfb125c9017142160840510130','en','2017-07-03 12:33:49',0,'Appelscha Fr / Appelskea Fr','Joure Fr / De Jouwer Fr','Oudega Fr / Aldegea Fr',NULL,NULL),(40,'androidSessionId22e1bcec9adc5f61122638213679','fy','2017-07-03 12:33:51',0,'Akkrum Fr','Anjum Fr / Eanjum
INSERT INTO `core_predictionquizresult` VALUES (7199,'web-1506334692938','fy','2017-09-25 10:16:00',0,'Arum Fr','Weidum Fr','Tietjerk Fr / Tytsjerk Fr',NULL,NULL),(7200,'web-1506334875045','fy','2017-09-25 10:19:15',0,'Anjum Fr / Eanjum Fr','Jubbega Fr / Jobbegea Fr','Rinsumageest Fr / Rinsumageast Fr',NULL,NULL),(7201,'web-1506334896281','fy','2017-09-25 10:19:25',0,'Wierum Fr','Hallum Fr','Rinsumageest Fr / Rinsumageast Fr',1,NULL),(7202,'web-1506334995872','fy','2017-09-25 10:21:03',0,'Westergeest Fr / Westergeast Fr','Rottevalle Fr / Rottefalle Fr','Veenwouden Fr / Feanw',3,NULL),(7203,'web-1506335143648','fy','2017-09-25 10:23:26',0,'Veenwouden Fr / Feanw','Rottevalle Fr / Rottefalle Fr','Westergeest Fr / Westergeast Fr',NULL,NULL),(7204,'androidSessionIdc98c2ecd5859022215004419790085','fy','2017-09-25 10:23:48',0,'Sexbierum Fr / Seisbierrum Fr','Arum Fr','Grouw Fr / Grou Fr',NULL,NULL),(7205,'web-1506335255460','fy','2017-09-25 10:28:06',0,'Ijlst Fr / Drylts Fr','Koudum Fr','Tjalleberd Fr / Tsjalbert Fr',NULL,NULL),(7206,'06DA5959-04FF-434F-B6B8-084D14CBFBC6','fy','2017-09-25 10:29:45',0,'Westergeest Fr / Westergeast Fr','Harkema Opeinde Fr / De Harkema Fr','Harkema Opeinde Fr / De Harkema Fr',NULL,NULL),(7207,'androidSessionIde6cc8cf92c4582b9148637308594040','fy','2017-09-25 10:33:04',0,'Anjum Fr / Eanjum Fr','Weidum Fr','Arum Fr',4,NULL),(7208,'web-1506335897722','fy','2017-09-25 10:36:05',0,'Anjum Fr / Eanjum Fr','Wierum Fr','Hallum Fr',NULL,NULL),(7209,'web-1506335936536','fy','2017-09-25 10:36:38',0,'Westergeest Fr / Westergeast Fr','Marrum Fr / Mearum Fr','Veenwouden Fr / Feanw',NULL,NULL),(7210,'web-1506335943123','fy','2017-09-25 10:36:50',0,'Holwerd Fr / Holwert Fr','Marrum Fr / Mearum Fr','Anjum Fr / Eanjum Fr',3,NULL),(7211,'web-1506336122016','fy','2017-09-25 10:39:49',0,'Veenwouden Fr / Feanw','Holwerd Fr / Holwert Fr','Hallum Fr',4,NULL),(7212,'web-1506336228130','fy','2017-09-25 10:41:35',0,'Akkrum Fr','Ijlst Fr / Drylts Fr','Holwerd Fr / Holwert Fr',NULL,NULL),(7213,'web-1506336288782','fy','2017-09-25 10:42:34',0,'Tietjerk Fr / Tytsjerk Fr','Veenwouden Fr / Feanw','Oudega Fr / Aldegea Fr',3,NULL),(7214,'web-1506336376015','fy','2017-09-25 10:42:51',0,'Holwerd Fr / Holwert Fr','Hallum Fr','Akkrum Fr',NULL,NULL),(7215,'androidSessionIda0f01b99c18fbd96251094890483165','fy','2017-09-25 10:42:58',0,'Ijlst Fr / Drylts Fr','Arum Fr','Grouw Fr / Grou Fr',5,3978),(7216,'web-1506336361714','fy','2017-09-25 10:43:50',0,'Wijnjeterp Fr / Wynjew','Oudega Fr / Aldegea Fr','Rottevalle Fr / Rottefalle Fr',NULL,NULL),(7217,'androidSessionIde0d5e09d89893c9b6148132450213','nl','2017-09-25 10:44:07',0,'Wijnjeterp Fr / Wynjew','Rottevalle Fr / Rottefalle Fr','Veenwouden Fr / Feanw',4,3983),(7218,'androidSessionId4297a405bf3fab05214705810982429','nl','2017-09-25 10:47:00',0,'Wijnjeterp Fr / Wynjew','Oudega Fr / Aldegea Fr','Harkema Opeinde Fr / De Harkema Fr',4,3985),(7219,'web-1506336564237','fy','2017-09-25 10:47:11',0,'Westergeest Fr / Westergeast Fr','Rottevalle Fr / Rottefalle Fr','Akkrum Fr',NULL,NULL),(7220,'web-1506336596176','fy','2017-09-25 10:47:43',0,'Hallum Fr','Veenwouden Fr / Feanw','Oudega Fr / Aldegea Fr',NULL,NULL),(7221,'web-1506336675440','fy','2017-09-25 10:49:04',0,'Tjalleberd Fr / Tsjalbert Fr','Nij Beets Fr','Tietjerk Fr / Tytsjerk Fr',3,NULL),(7222,'web-1506336701778','fy','2017-09-25 10:49:28',0,'Anjum Fr / Eanjum Fr','Hallum Fr','Veenwouden Fr / Feanw',NULL,NULL),(7223,'web-1506336741349','fy','2017-09-25 10:50:06',0,'Holwerd Fr / Holwert Fr','Hallum Fr','Tietjerk Fr / Tytsjerk Fr',NULL,NULL),(7224,'web-1506336900784','fy','2017-09-25 10:52:49',0,'Wijnjeterp Fr / Wynjew','Oudega Fr / Aldegea Fr','Nij Beets Fr',4,NULL),(7225,'web-1506336928154','fy','2017-09-25 10:53:16',0,'Arum Fr','Sexbierum Fr / Seisbierrum Fr','Weidum Fr',NULL,NULL),(7226,'androidSessionIdfa30d680b74631d3693875711650991','fy','2017-09-25 10:53:49',0,'Akkrum Fr','Holwerd Fr / Holwert Fr','Grouw Fr / Grou Fr',NULL,NULL),(7227,'4802C93D-E102-4A3E-9505-182841F153A9','nl','2017-09-25 10:54:40',0,'Anjum Fr / Eanjum Fr','Hallum Fr
/*!40000 ALTER TABLE `core_predictionquizresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_predictionquizresultquestionanswer`
--
DROP TABLE IF EXISTS `core_predictionquizresultquestionanswer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_predictionquizresultquestionanswer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`question_text` varchar(255) NOT NULL,
`answer_text` varchar(255) NOT NULL,
`prediction_quiz_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `core_predictionquizr_prediction_quiz_id_ddc6ec64_fk_core_pred` (`prediction_quiz_id`),
CONSTRAINT `core_predictionquizr_prediction_quiz_id_ddc6ec64_fk_core_pred` FOREIGN KEY (`prediction_quiz_id`) REFERENCES `core_predictionquizresult` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=254778 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_predictionquizresultquestionanswer`
--
LOCK TABLES `core_predictionquizresultquestionanswer` WRITE;
/*!40000 ALTER TABLE `core_predictionquizresultquestionanswer` DISABLE KEYS */;
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (121,'ik sprak','sp___ (spɾɑk)',10),(122,'kaas','____s (kɪ:əs)',10),(123,'dag','d___ (dɑx)',10),(124,'armen','_____n (ɑɾmən)',10),(125,'geel','___l (ɡeɪl)',10),(126,'ik heb gezet','___n (sɛtn)',10),(127,'borst','b__st (bost)',10),(128,'ik ben gegaan','j____ (jaɪn)',10),(129,'heel','h____ (he:l)',10),(130,'bij','h_________r (hɵnəɣowər)',10),(131,'vis','___sk (fisk)',10),(132,'blad','b___ (blɛ:t)',10),(133,'zaterdag','s_____ (snjoun)',10),(134,'avond','j____n (joun)',10),(135,'koken','k____ (koukə)',10),(136,'trein','t____ (tɾɛɪn)',10),(137,'deurtje','d_____ (dɔ:ɾkə)',10),(138,'oog','o___ (o:x)',10),(139,'tand','t____ (tɑ:n)',10),(140,'dag','d___ (dɑx)',11),(141,'bij','h_____k (hork)',11),(142,'armen','_____n (ɑɾmən)',11),(143,'ik sprak','sp___ (spɾɑk)',11),(144,'deurtje','d_____ (dɵ:ɾkə)',11),(145,'zaterdag','s_____ (sa:tədɑx)',11),(146,'vis','___s (fɪs)',11),(147,'oog','___ch (ɪ.əx)',11),(148,'avond','_____n (ɪwən)',11),(149,'heel','h____ (he:l)',11),(150,'borst','b__st (bost)',11),(151,'koken','k____ (koukə)',11),(152,'ik heb gezet','___t (sɛt)',11),(153,'tand','t____ (tɑ:n)',11),(154,'blad','b___ (blɔd)',11),(155,'geel','___l (ɣe:l)',11),(156,'kaas','____s (kɪ:əs)',11),(157,'ik ben gegaan','j____ (jaɪn)',11),(158,'trein','t____ (tɾɛɪn)',11),(178,'ik ben gegaan','g___ (ɣiən)',13),(179,'geel','___l (ɡe:l)',13),(180,'tand','t____ (tos)',13),(181,'koken','k___ (kʌtjə)',13),(182,'bij','i__________r (i:nəfandər)',13),(183,'zaterdag','s_____ (snɵən)',13),(184,'borst','b__st (bwɑst)',13),(185,'avond','_____n (ɑʋən)',13),(186,'trein','t____ (tɾeɪn)',13),(187,'dag','d___ (dɛɪ)',13),(188,'ik heb gezet','___t (sʌt)',13),(189,'heel','h____ (hewl)',13),(190,'blad','b___ (blɔd)',13),(191,'kaas','____s (si:s)',13),(192,'deurtje','‘n lid d__ (da:ɾ)',13),(193,'oog','___ch (eɪx)',13),(194,'armen','_____n (e:ɾmən)',13),(195,'vis','___s (fɪs)',13),(196,'ik sprak','sp___ (spRɑk)',13),(235,'vis','___sk (fisk)',16),(236,'armen','_____s (ɑɾms)',16),(237,'tand','k____ (ki:zə)',16),(238,'kaas','____s (tsi:s)',16),(239,'koken','k____ (kojtsə)',16),(240,'trein','k____ (kojtsə)',16),(241,'avond','t____ (tɾɑɪn)',16),(242,'blad','j____n (joun)',16),(243,'ik ben gegaan','g___ (ɣiən)',16),(244,'ik sprak','sp___ (spɾi:k)',16),(245,'heel','sp___ (spɾi:k)',16),(246,'geel','___l (ɡeɪl)',16),(247,'oog','___ch (ɪ.əx)',16),(248,'ik heb gezet','___n (sɛtn)',16),(249,'zaterdag','___n (sɛtn)',16),(250,'bij','b____ (bɛi)',16),(251,'dag','b____ (bɛi)',16),(252,'borst','d___ (dɛɪ)',16),(253,'deurtje','b__st (bɔɾst)',16),(254,'kaas','____s (keɪs)',17),(255,'bij','b____ (bɛi)',17),(256,'trein','t____ (tɾɛɪn)',17),(257,'vis','___s (fɪs)',17),(258,'ik sprak','sp___ (spɾɑktə)',17),(259,'oog','___ch (ɛ:x)',17),(260,'koken','k___ (ko:kən)',17),(261,'geel','___l (ɡe:l)',17),(262,'zaterdag','s_____ (snɪwn)',17),(263,'armen','_____n (ɑRmən)',17),(264,'dag','d___ (dɑɪ)',17),(265,'ik ben gegaan','g___ (gain)',17),(266,'blad','b___ (blɛ:t)',17),(267,'deurtje','d_____ (doətjə)',17),(268,'ik heb gezet','___t (sʌt)',17),(269,'heel','h____ (hɪəl)',17),(270,'borst','h____ (hɪəl)',17),(271,'tand','h____ (hɪəl)',17),(272,'avond','_____n (a:bən)',17),(273,'oog','___ch (ɛ:x)',18),(274,'heel','h____ (heɪl)',18),(275,'koken','k____ (kojtsə)',18),(276,'ik heb gezet','___n (sɛtn)',18),(277,'kaas','____s (tsi:s)',18),(278,'borst','b__st (bɔɾst)',18),(279,'dag','d___ (dɛɪ)',18),(280,'deurtje','d_____ (dɔ:ɾkə)',18),(281,'zaterdag','s_____ (snjoun)',18),(282,'blad','b___ (blɛ:t)',18),(283,'vis','___sk (fisk)',18),(284,'geel','___l (ɡeɪl)',18),(285,'avond','j____n (joun)',18),(286,'tand','k____ (ki:zə)',18),(287,'ik ben gegaan','g___ (ɣiən)',18),(288,'ik sprak','sp___ (spɾi:k)',18),(289,'bij','b____ (bɛi)',18),(290,'trein','t____ (tɾɑɪn)',18),(291,'armen','_____s (ɑɾms)',18),(292,'ik ben gegaan','j____ (jaɪn)',19),(293,'geel','___l (ɡeɪl)',19),(294,'armen','_____s (ɑɾms)',19),(
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (25496,'ik sprak','sp__s (spɾɵts)',1345),(25497,'tand','t__sk (tosk)',1345),(25498,'vis','___sk (fisk)',1345),(25499,'zaterdag','s____n (snɵən)',1345),(25500,'koken','s__e (sɪəɾə)',1345),(25501,'trein','t___n (tɾɑɪn)',1345),(25502,'heel','h___l (heɪl)',1345),(25503,'ik ben gegaan','g___ (gonən)',1345),(25504,'ik heb gezet','___n (sɛtn)',1345),(25505,'__armen','e____n (e:ɾmən)',1346),(25506,'avond','j____n (jun)',1346),(25507,'bij','b____ (bɛi)',1346),(25508,'blad','b___ (blɛ:t)',1346),(25509,'borst','b__st (bwɑst)',1346),(25510,'dag','d__i (dɛɪ)',1346),(25511,'deurtje','d____e (dwɑɾkə)',1346),(25512,'geel','___l (ɡɪəl)',1346),(25513,'kaas','____s (tsi:s)',1346),(25514,'oog','___ch (eɪx)',1346),(25515,'ik sprak','sp__s (spɾɵts)',1346),(25516,'tand','t__sk (tosk)',1346),(25517,'vis','___sk (fisk)',1346),(25518,'zaterdag','s____n (snɵən)',1346),(25519,'koken','s__e (sɪəɾə)',1346),(25520,'trein','t___n (tɾɑɪn)',1346),(25521,'heel','h___l (hɪəl)',1346),(25522,'ik ben gegaan','g___ (giən)',1346),(25523,'ik heb gezet','___t (sɛt)',1346),(25524,'\"vis\"','___sk (fisk)',1347),(25525,'\"koken\"','k___ (ko:kən)',1347),(25526,'\"deurtje\"','d____e (doətjə)',1347),(25527,'\"gegaan\"','g___ (xɑ:n)',1347),(25528,'\"dag\"','d___ (dɑ:x)',1347),(25529,'\"sprak (toe)\"','sp__k (spɾɑk)',1347),(25530,'\"zaterdag\"','s_____ (sa:tədɑx)',1347),(25531,'\"armen\" (*lichaamsdeel)','a____n (ɑRmən)',1347),(25532,'\"trein\"','t____n (tRɛɪn)',1347),(25533,'\"oog\"','o___ (o:x)',1347),(25534,'\"bij\" (*insect)','b___ (bɛi)',1347),(25535,'\"kaas\"','k___s (ka:s)',1347),(25536,'\"avond\"','a__nd (a:vənt)',1347),(25537,'\"heel\"','h___l (heɪl)',1347),(25538,'\"geel\"','___l (ɣe:l)',1347),(25539,'\"blad\" (aan een boom)','b___ (blɔd)',1347),(25540,'\"gezet\"','___t (xəsɛt)',1347),(25541,'\"borst\" (*lichaamsdeel)','b__st (bɔɾst)',1347),(25542,'\"tand\"','t___d (tɑnt)',1347),(25543,'\"geel\"','___l (ɡɪəl)',1348),(25544,'\"blad\" (aan een boom)','b___ (blet)',1348),(25545,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',1348),(25546,'\"gegaan\"','g___ (gɔ:n)',1348),(25547,'\"trein\"','t____n (tɾɛɪn)',1348),(25548,'\"sprak (toe)\"','sp___s (spɾɵts)',1348),(25549,'\"vis\"','___s (fɪs)',1348),(25550,'\"tand\"','t___k (tɵsk)',1348),(25551,'\"bij\" (*insect)','b___ (bɛi)',1348),(25552,'\"kaas\"','____s (si:s)',1348),(25553,'\"dag\"','d__i (dɛɪ)',1348),(25554,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',1348),(25555,'\"avond\"','j___ne (jɔ:nə)',1348),(25556,'\"zaterdag\"','s_____ (sɑ:təɾjə)',1348),(25557,'\"koken\"','s___e (sɪəɾə)',1348),(25558,'\"gezet\"','___n (sɛtn)',1348),(25559,'\"deurtje\"','d____e (dwɑɾkə)',1348),(25560,'\"heel\"','h___l (hɪəl)',1348),(25561,'\"oog\"','___ch (eɪx)',1348),(25562,'__armen','e____s (ɛ:ɾms)',1349),(25563,'avond','a____n (ɑʋən)',1349),(25564,'bij','b____ (bɛi)',1349),(25565,'blad','b___ (blɑt)',1349),(25566,'borst','b__st (bost)',1349),(25567,'dag','d___ (dɑ:x)',1349),(25568,'deurtje','d_____ (dɵ:tsi)',1349),(25569,'geel','___l (ɡeɪl)',1349),(25570,'kaas','____s (keɪs)',1349),(25571,'oog','o___ (o:x)',1349),(25572,'ik sprak','sp__k (spɾɑk)',1349),(25573,'tand','t___d (tɑnt)',1349),(25574,'vis','___s (fɪs)',1349),(25575,'zaterdag','s_____ (sa:tədex)',1349),(25576,'koken','k___e (koukə)',1349),(25577,'trein','t___n (tɾɔɪn)',1349),(25578,'heel','h___l (hø:l)',1349),(25579,'ik ben gegaan','g___ (gonən)',1349),(25580,'ik heb gezet','___n (sɛtn)',1349),(25581,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',1350),(25582,'\"kaas\"','____s (tsi:s)',1350),(25583,'\"vis\"','___sk (fisk)',1350),(25584,'\"bij\" (*insect)','b___ (be:i)',1350),(25585,'\"geel\"','___l (ɡɪəl)',1350),(25586,'\"deurtje\"','d____e (dwɑɾkə)',1350),(25587,'\"blad\" (aan een boom)','b___ (blet)',1350),(25588,'\"sprak (toe)\"','sp___s (spɾɵts)',1350),(25589,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',1350),(25590,'\"tand\"','t___k (tɵsk)',1350),(25591,'\"dag\"','d__i (dɛɪ)',1350),
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (49904,'\"deurtje\"','d____e (dɔ:ɾkə)',2630),(49905,'\"zaterdag\"','s____n (snɵən)',2630),(49906,'\"koken\"','k____e (koukə)',2630),(49907,'\"blad\" (aan een boom)','b___ (blɛ:t)',2630),(49908,'\"dag\"','d__i (dɛɪ)',2630),(49909,'\"armen\" (*lichaamsdeel)','a____n (ɑɾmən)',2630),(49910,'\"oog\"','o___ (o:x)',2630),(49911,'\"trein\"','t____n (tɾɛɪn)',2630),(49912,'\"geel\"','___l (ɡeɪl)',2630),(49913,'\"avond\"','j__n (jun)',2630),(49914,'\"gezet\"','___t (ɡəsət)',2630),(49915,'\"kaas\"','____s (tsi:s)',2630),(49916,'\"vis\"','___sk (fisk)',2630),(49917,'\"heel\"','h___l (hɪəl)',2630),(49918,'\"tand\"','t___n (tɑ:n)',2630),(49919,'\"sprak (toe)\"','sp__k (spɾɑk)',2630),(49920,'__armen','j____n (jɛɾmən)',2631),(49921,'avond','j____n (jun)',2631),(49922,'bij','b____ (bi:)',2631),(49923,'blad','b___ (blɛ:t)',2631),(49924,'borst','b__st (bwɑst)',2631),(49925,'dag','d__i (dɑɪ)',2631),(49926,'deurtje','d____e (dwɑɾkə)',2631),(49927,'geel','___l (ɡɪəl)',2631),(49928,'kaas','____s (tsi:s)',2631),(49929,'oog','___ch (ɪ.əx)',2631),(49930,'ik sprak','sp__s (spɾɵts)',2631),(49931,'tand','t___n (tɑ:n)',2631),(49932,'vis','___sk (fisk)',2631),(49933,'zaterdag','s____n (snɵən)',2631),(49934,'koken','k___ (ko:kən)',2631),(49935,'trein','t___n (tɾɑɪn)',2631),(49936,'heel','h___l (hɪəl)',2631),(49937,'ik ben gegaan','g___ (giən)',2631),(49938,'ik heb gezet','___n (sɛtn)',2631),(49939,'__armen','e____n (e:ɾmən)',2632),(49940,'avond','j____n (jun)',2632),(49941,'bij','b____ (bɛi)',2632),(49942,'blad','b___ (blɛ:t)',2632),(49943,'borst','b__st (bwɑst)',2632),(49944,'dag','d__i (dɑɪ)',2632),(49945,'deurtje','d____e (dwɑɾkə)',2632),(49946,'geel','___l (ɡɪəl)',2632),(49947,'kaas','____s (tsi:s)',2632),(49948,'oog','___ch (eɪx)',2632),(49949,'ik sprak','sp__s (spɾɵts)',2632),(49950,'tand','t__sk (tosk)',2632),(49951,'vis','___sk (fisk)',2632),(49952,'zaterdag','s____n (snɵən)',2632),(49953,'koken','k___e (kɔkjə)',2632),(49954,'trein','t___n (tɾɔɪn)',2632),(49955,'heel','h___l (he:l)',2632),(49956,'ik ben gegaan','g___ (giənt)',2632),(49957,'ik heb gezet','___n (sɛtn)',2632),(49958,'\"blad\" (aan een boom)','b___ (blet)',2633),(49959,'\"kaas\"','____s (tsi:s)',2633),(49960,'\"oog\"','___ch (eɪx)',2633),(49961,'\"deurtje\"','d____e (dɔ:ɾkə)',2633),(49962,'\"avond\"','j__n (jun)',2633),(49963,'\"heel\"','h___l (hɪəl)',2633),(49964,'\"gegaan\"','g___ (gɔ:n)',2633),(49965,'\"zaterdag\"','s____n (snɵən)',2633),(49966,'\"koken\"','s___e (sɪədə)',2633),(49967,'\"sprak (toe)\"','sp___s (spɾɵts)',2633),(49968,'\"dag\"','d__i (dɑɪ)',2633),(49969,'\"tand\"','t___sk (tosk)',2633),(49970,'\"bij\" (*insect)','b___ (bæi)',2633),(49971,'\"vis\"','___sk (fisk)',2633),(49972,'\"geel\"','___l (ɡɪəl)',2633),(49973,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',2633),(49974,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',2633),(49975,'\"gezet\"','___n (sɛdn)',2633),(49976,'\"trein\"','t____n (tɾɔɪn)',2633),(49977,'\"geel\"','___l (ɡɪəl)',2634),(49978,'\"trein\"','t____n (tɾɛɪn)',2634),(49979,'\"oog\"','___ch (eɪx)',2634),(49980,'\"dag\"','d__i (dɛɪ)',2634),(49981,'\"tand\"','t___sk (tosk)',2634),(49982,'\"blad\" (aan een boom)','b___ (blɛ:t)',2634),(49983,'\"gezet\"','___n (sɛtn)',2634),(49984,'\"vis\"','___sk (fisk)',2634),(49985,'\"zaterdag\"','s_____ (sa:tədi)',2634),(49986,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',2634),(49987,'\"sprak (toe)\"','sp__k (spɾɑk)',2634),(49988,'\"gegaan\"','g___ (giən)',2634),(49989,'\"kaas\"','____s (tsi:s)',2634),(49990,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',2634),(49991,'\"bij\" (*insect)','b___ (bɛi)',2634),(49992,'\"heel\"','h___l (hɪəl)',2634),(49993,'\"deurtje\"','d____e (dwɑɾkə)',2634),(49994,'\"koken\"','k____e (koukə)',2634),(49995,'\"avond\"','j__ne (junə)',2634),(49996,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',2635),(49997,'\"gezet\"','___n (sɛdn)',2635),(49998,'\"deurtje\"','d____e (dwɑɾkə)',2635),(49999,'\"gegaan\"','g
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (74099,'\"deurtje\"','d____e (dwɑɾkə)',3903),(74100,'\"blad\" (aan een boom)','b___ (blɛ:t)',3903),(74101,'\"dag\"','d__i (dɑɪ)',3903),(74102,'\"zaterdag\"','s____n (snɵən)',3903),(74103,'\"bij\" (*insect)','b___ (bæi)',3903),(74104,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',3903),(74105,'\"tand\"','t___sk (tosk)',3903),(74106,'\"heel\"','h___l (he:l)',3903),(74107,'__armen','e____n (e:ɾmən)',3904),(74108,'avond','j____n (joun)',3904),(74109,'bij','b____ (bɛi)',3904),(74110,'blad','b___ (blɛ:t)',3904),(74111,'borst','b__st (bɒst)',3904),(74112,'dag','d__i (dɛɪ)',3904),(74113,'deurtje','d____e (dɔ:ɾkə)',3904),(74114,'geel','___l (ɡɪəl)',3904),(74115,'kaas','____s (tsi:s)',3904),(74116,'oog','___ch (ɛ:x)',3904),(74117,'ik sprak','sp__k (spɾi:k)',3904),(74118,'tand','t__sk (tosk)',3904),(74119,'vis','___s (fɪs)',3904),(74120,'zaterdag','s____n (snɵən)',3904),(74121,'koken','k___e (kojtsə)',3904),(74122,'trein','t___n (tɾeɪn)',3904),(74123,'heel','h___l (he:l)',3904),(74124,'ik ben gegaan','g___ (gɔ:n)',3904),(74125,'ik heb gezet','___n (sɛtn)',3904),(74126,'__armen','e____n (e:ɾmən)',3905),(74127,'avond','j____ne (jaunə)',3905),(74128,'bij','b____ (bæi)',3905),(74129,'blad','b___ (blet)',3905),(74130,'borst','b__st (bɶst)',3905),(74131,'dag','d__i (dɛɪ)',3905),(74132,'deurtje','d____e (dwɑɾkə)',3905),(74133,'geel','___l (ɡɪəl)',3905),(74134,'kaas','____s (tsi:s)',3905),(74135,'oog','___ch (eɪx)',3905),(74136,'ik sprak','sp__s (spɾɵts)',3905),(74137,'tand','t__sk (tosk)',3905),(74138,'vis','___sk (fisk)',3905),(74139,'zaterdag','s_____ (sɑ:təɾjə)',3905),(74140,'koken','s__e (sɪəɾə)',3905),(74141,'trein','t___n (tɾeɪn)',3905),(74142,'heel','h___l (hɪəl)',3905),(74143,'ik ben gegaan','g___ (gɔ:n)',3905),(74144,'ik heb gezet','___n (sɛtn)',3905),(74145,'\"gezet\"','___t (xəsɛt)',3906),(74146,'\"geel\"','___l (ɣiəl)',3906),(74147,'\"vis\"','___s (fɪs)',3906),(74148,'\"bij\" (*insect)','b___ (bɛi)',3906),(74149,'\"sprak (toe)\"','sp__k (spɾɑk)',3906),(74150,'\"gegaan\"','g___ (xəxa:n)',3906),(74151,'\"tand\"','t___d (tɑnt)',3906),(74152,'\"blad\" (aan een boom)','b___ (blɑt)',3906),(74153,'\"heel\"','h___l (heɪl)',3906),(74154,'\"armen\" (*lichaamsdeel)','a____n (ɑɾmən)',3906),(74155,'\"borst\" (*lichaamsdeel)','b__st (bɔɾst)',3906),(74156,'\"oog\"','o___ (o:x)',3906),(74157,'\"trein\"','t____n (tɾɛɪn)',3906),(74158,'\"koken\"','k____e (koukə)',3906),(74159,'\"dag\"','d___ (dɑx)',3906),(74160,'\"kaas\"','k___s (ka:s)',3906),(74161,'\"zaterdag\"','s_____ (sa:tədex)',3906),(74162,'\"avond\"','i___n (ɪwən)',3906),(74163,'\"deurtje\"','d____e (doətjə)',3906),(74164,'\"oog\"','___ch (eɪx)',3907),(74165,'\"kaas\"','____s (si:s)',3907),(74166,'\"geel\"','___l (ɡɪəl)',3907),(74167,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',3907),(74168,'\"gezet\"','___n (sɛdn)',3907),(74169,'\"gegaan\"','g___ (gonən)',3907),(74170,'\"deurtje\"','d____e (dɵ:ɾkə)',3907),(74171,'\"dag\"','d__i (dɑɪ)',3907),(74172,'\"avond\"','j__n (jun)',3907),(74173,'\"zaterdag\"','s____n (snɵən)',3907),(74174,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',3907),(74175,'\"bij\" (*insect)','b___ (bɛi)',3907),(74176,'\"tand\"','t___sk (tosk)',3907),(74177,'\"koken\"','k___e (kɔkjə)',3907),(74178,'\"blad\" (aan een boom)','b___ (blɛ:t)',3907),(74179,'\"sprak (toe)\"','sp___s (spɾɵts)',3907),(74180,'\"trein\"','t____n (tɾɔɪn)',3907),(74181,'\"vis\"','___sk (fisk)',3907),(74182,'\"heel\"','h___l (hɪəl)',3907),(74183,'\"sprak (toe)\"','sp___s (spɾɵts)',3908),(74184,'\"geel\"','___l (ɡeɪl)',3908),(74185,'\"avond\"','j__n (jun)',3908),(74186,'\"heel\"','h___l (hɪəl)',3908),(74187,'\"gegaan\"','g___ (gɔ:n)',3908),(74188,'\"dag\"','d__i (dɑɪ)',3908),(74189,'\"oog\"','___ch (ɪ.əx)',3908),(74190,'\"blad\" (aan een boom)','b___ (blɛ:t)',3908),(74191,'\"zaterdag\"','s____n (snɵən)',3908),(74192,'\"tand\"','t___sk (tosk)',3908),(74193,'\"vis\"','___s (fɪs)',3908),(74194,'\"koken\"','s___e (sɪə
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (98374,'\"gezet\"','___n (sɛtn)',5181),(98375,'\"heel\"','h___l (he:l)',5181),(98376,'\"trein\"','t____n (tɾɑɪn)',5181),(98377,'\"bij\" (*insect)','b___ (bɛi)',5181),(98378,'\"dag\"','d___ (dɑ:x)',5181),(98379,'\"koken\"','s___e (sɪəɾə)',5181),(98380,'\"vis\"','___sk (fisk)',5181),(98381,'\"blad\" (aan een boom)','b___ (blɛ:t)',5181),(98382,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',5181),(98383,'\"geel\"','___l (ɡɪəl)',5181),(98384,'\"sprak (toe)\"','sp___s (spɾɵts)',5181),(98385,'\"oog\"','___ch (eɪx)',5181),(98386,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',5181),(98387,'\"avond\"','j__n (jun)',5181),(98388,'\"kaas\"','____s (tsi:s)',5181),(98389,'\"bij\" (*insect)','b___ (bɛi)',5182),(98390,'\"gegaan\"','g___ (ɣiən)',5182),(98391,'\"kaas\"','____s (tsi:s)',5182),(98392,'\"gezet\"','___n (sɛtn)',5182),(98393,'\"geel\"','___l (ɡɪəl)',5182),(98394,'\"blad\" (aan een boom)','b___ (blet)',5182),(98395,'\"deurtje\"','d____e (dɔ:ɾkə)',5182),(98396,'\"oog\"','___ch (eɪx)',5182),(98397,'\"avond\"','j__ne (junə)',5182),(98398,'\"dag\"','d__i (dɛɪ)',5182),(98399,'\"heel\"','h___l (hɪəl)',5182),(98400,'\"vis\"','___sk (fisk)',5182),(98401,'\"tand\"','t___k (tɵsk)',5182),(98402,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',5182),(98403,'\"trein\"','t____n (tɾɛɪn)',5182),(98404,'\"zaterdag\"','s_____ (sɑ:təɾjə)',5182),(98405,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',5182),(98406,'\"koken\"','k____e (koukə)',5182),(98407,'\"sprak (toe)\"','sp___s (spɾɵts)',5182),(98408,'\"gegaan\"','g___ (gonən)',5183),(98409,'\"trein\"','t____n (tɾɔɪn)',5183),(98410,'\"kaas\"','____s (tsi:s)',5183),(98411,'\"oog\"','___ch (eɪx)',5183),(98412,'\"avond\"','j__n (jun)',5183),(98413,'\"sprak (toe)\"','sp___s (spɾɵts)',5183),(98414,'\"deurtje\"','d____e (dwɑɾkə)',5183),(98415,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',5183),(98416,'\"dag\"','d__i (dɑɪ)',5183),(98417,'\"vis\"','___sk (fisk)',5183),(98418,'\"heel\"','h___l (he:l)',5183),(98419,'\"bij\" (*insect)','b___ (bɛi)',5183),(98420,'\"koken\"','s___e (sɪəɾə)',5183),(98421,'\"zaterdag\"','s____n (snɵən)',5183),(98422,'\"tand\"','t___sk (tosk)',5183),(98423,'\"blad\" (aan een boom)','b___ (blɛ:t)',5183),(98424,'\"geel\"','___l (ɡe:l)',5183),(98425,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',5183),(98426,'\"gezet\"','___n (sɛtn)',5183),(98427,'\"heel\"','h___l (he:l)',5184),(98428,'\"geel\"','___l (ɡeɪl)',5184),(98429,'\"koken\"','s___e (sɪədə)',5184),(98430,'\"gezet\"','___t (sɛt)',5184),(98431,'\"vis\"','___s (fɪs)',5184),(98432,'\"deurtje\"','d____e (dɶɾkə)',5184),(98433,'\"oog\"','o___ (o:x)',5184),(98434,'\"sprak (toe)\"','sp__k (spɾɑk)',5184),(98435,'\"kaas\"','____s (kɪ:s)',5184),(98436,'\"gegaan\"','g___ (ga:n)',5184),(98437,'\"dag\"','d___ (dɑx)',5184),(98438,'\"blad\" (aan een boom)','b___ (blɔd)',5184),(98439,'\"armen\" (*lichaamsdeel)','a____n (ɑRmən)',5184),(98440,'\"trein\"','t____n (tɾeɪn)',5184),(98441,'\"zaterdag\"','s_____ (sa:tədɑx)',5184),(98442,'\"avond\"','i___n (ɪwən)',5184),(98443,'\"borst\" (*lichaamsdeel)','b__st (bɔɾst)',5184),(98444,'\"tand\"','t___n (tɑ:n)',5184),(98445,'\"bij\" (*insect)','b___ (bɛi)',5184),(98446,'\"kaas\"','____s (tsi:s)',5185),(98447,'\"sprak (toe)\"','sp___s (spɾɵts)',5185),(98448,'\"blad\" (aan een boom)','b___ (blɛ:t)',5185),(98449,'\"bij\" (*insect)','b___ (bæi)',5185),(98450,'\"tand\"','t___sk (tosk)',5185),(98451,'\"avond\"','j__n (jun)',5185),(98452,'\"heel\"','h___l (hɪəl)',5185),(98453,'\"trein\"','t____n (tRɛɪn)',5185),(98454,'\"deurtje\"','d____e (dwɑɾkə)',5185),(98455,'\"dag\"','d__i (dɛɪ)',5185),(98456,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',5185),(98457,'\"gegaan\"','g___ (giən)',5185),(98458,'\"gezet\"','___n (sɛtn)',5185),(98459,'\"zaterdag\"','s_____ (sɑ:təɾjə)',5185),(98460,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',5185),(98461,'\"vis\"','___sk (fisk)',5185),(98462,'\"koken\"','s___e (sɪəɾə)',5185),(98463,'\"oog\"','___ch (eɪx)',5
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (123403,'ik sprak','sp__s (spɾɵts)',6498),(123404,'tand','t___k (tɵsk)',6498),(123405,'vis','___sk (fisk)',6498),(123406,'zaterdag','s_____ (sɑ:təɾjə)',6498),(123407,'koken','s__e (sɪəɾə)',6498),(123408,'trein','t___n (tɾeɪn)',6498),(123409,'heel','h___l (hɪəl)',6498),(123410,'ik ben gegaan','g___ (giən)',6498),(123411,'ik heb gezet','___t (sɛt)',6498),(123412,'__armen','j____n (jɛɾmən)',6499),(123413,'avond','j____n (joun)',6499),(123414,'bij','b____ (bɛi)',6499),(123415,'blad','b___ (blɛ:t)',6499),(123416,'borst','b__st (bwɑst)',6499),(123417,'dag','d__i (dɑɪ)',6499),(123418,'deurtje','d____e (dwɑɾkə)',6499),(123419,'geel','___l (ɡeɪl)',6499),(123420,'kaas','____s (tsi:s)',6499),(123421,'oog','___ch (eɪx)',6499),(123422,'ik sprak','sp__s (spɾɵts)',6499),(123423,'tand','t__sk (tosk)',6499),(123424,'vis','___sk (fisk)',6499),(123425,'zaterdag','s____n (snɵən)',6499),(123426,'koken','s__e (sɪəɾə)',6499),(123427,'trein','t___n (tɾɔɪn)',6499),(123428,'heel','h___l (he:l)',6499),(123429,'ik ben gegaan','g___ (gɔ:n)',6499),(123430,'ik heb gezet','___n (sɛdn)',6499),(123431,'__armen','j____s (jɛɾms)',6500),(123432,'avond','j____n (jun)',6500),(123433,'bij','b____ (bɛi)',6500),(123434,'blad','b___ (blɛ:t)',6500),(123435,'borst','b__st (bwɑst)',6500),(123436,'dag','d__i (dɑɪ)',6500),(123437,'deurtje','d____e (dwɑɾkə)',6500),(123438,'geel','___l (ɡeɪl)',6500),(123439,'kaas','____s (tsi:s)',6500),(123440,'oog','___ch (ɛ:x)',6500),(123441,'ik sprak','sp__s (spɾɵts)',6500),(123442,'tand','t__sk (tosk)',6500),(123443,'vis','___sk (fisk)',6500),(123444,'zaterdag','s____n (snɵən)',6500),(123445,'koken','s__e (sɪəɾə)',6500),(123446,'trein','t___n (tɾɛɪn)',6500),(123447,'heel','h___l (he:l)',6500),(123448,'ik ben gegaan','g___ (giən)',6500),(123449,'ik heb gezet','___n (sɛtn)',6500),(123450,'__armen','j____s (jɛɾms)',6501),(123451,'avond','j____n (jun)',6501),(123452,'bij','b____ (bɛi)',6501),(123453,'blad','b___ (blɛ:t)',6501),(123454,'borst','b__st (bwɑst)',6501),(123455,'dag','d__i (dɑɪ)',6501),(123456,'deurtje','d____e (dwɑɾkə)',6501),(123457,'geel','___l (ɡɪəl)',6501),(123458,'kaas','____s (tsi:s)',6501),(123459,'oog','___ch (ɪ.əx)',6501),(123460,'ik sprak','sp__s (spɾɵts)',6501),(123461,'tand','t__sk (tosk)',6501),(123462,'vis','___sk (fisk)',6501),(123463,'zaterdag','s____n (snɵən)',6501),(123464,'koken','s__e (sɪəɾə)',6501),(123465,'trein','t___n (tɾɔɪn)',6501),(123466,'heel','h___l (hɪəl)',6501),(123467,'ik ben gegaan','g___ (gonən)',6501),(123468,'ik heb gezet','___n (sɛdn)',6501),(123469,'__armen','j____n (jɛɾmən)',6502),(123470,'avond','j____n (jun)',6502),(123471,'bij','b____ (bɛi)',6502),(123472,'blad','b___ (blet)',6502),(123473,'borst','b__st (bɪast)',6502),(123474,'dag','d__i (dɑɪ)',6502),(123475,'deurtje','d____e (dwɑɾkə)',6502),(123476,'geel','___l (ɡɪəl)',6502),(123477,'kaas','____s (si:s)',6502),(123478,'oog','___ch (eɪx)',6502),(123479,'ik sprak','sp__s (spɾɵts)',6502),(123480,'tand','t__sk (tosk)',6502),(123481,'vis','___s (fɪs)',6502),(123482,'zaterdag','s_____ (sɑ:təɾjə)',6502),(123483,'koken','s__e (sɪəɾə)',6502),(123484,'trein','t___n (tɾeɪn)',6502),(123485,'heel','h___l (hɪəl)',6502),(123486,'ik ben gegaan','g___ (gɔ:n)',6502),(123487,'ik heb gezet','___n (sɛtn)',6502),(123488,'__armen','j____s (jɛɾms)',6503),(123489,'avond','j____n (jun)',6503),(123490,'bij','b____ (bɛi)',6503),(123491,'blad','b___ (blet)',6503),(123492,'borst','b__st (bɪast)',6503),(123493,'dag','d__i (dɛɪ)',6503),(123494,'deurtje','d____e (dwɑɾkə)',6503),(123495,'geel','___l (ɡɪəl)',6503),(123496,'kaas','____s (tsi:s)',6503),(123497,'oog','___ch (eɪx)',6503),(123498,'ik sprak','sp__s (spɾɵts)',6503),(123499,'tand','t__sk (tosk)',6503),(123500,'vis','___sk (fisk)',6503),(123501,'zaterdag','s____n (snɵən)',6503),(123502,'koken','s__e (sɪəɾə)',6503),(123503,'trein','t___n (tɾɛɪn)',6503),(123504,'heel','h___l (hɪəl)',6503),(12350
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (148489,'\"deurtje\"','d____e (dwɑɾkə)',7818),(148490,'\"bij\" (*insect)','b___ (bɛi)',7818),(148491,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',7818),(148492,'\"zaterdag\"','s____n (snɵən)',7819),(148493,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',7819),(148494,'\"dag\"','d__i (dɛɪ)',7819),(148495,'\"tand\"','t___sk (tosk)',7819),(148496,'\"sprak (toe)\"','sp___s (spɾɵts)',7819),(148497,'\"koken\"','s___e (sɪəɾə)',7819),(148498,'\"oog\"','___ch (eɪx)',7819),(148499,'\"bij\" (*insect)','b___ (bɛi)',7819),(148500,'\"trein\"','t____n (tɾɛɪn)',7819),(148501,'\"vis\"','___sk (fisk)',7819),(148502,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',7819),(148503,'\"deurtje\"','d____e (dwɑɾkə)',7819),(148504,'\"gegaan\"','g___ (giən)',7819),(148505,'\"avond\"','j__n (jun)',7819),(148506,'\"blad\" (aan een boom)','b___ (blɛ:t)',7819),(148507,'\"gezet\"','___n (sɛtn)',7819),(148508,'\"heel\"','h___l (hɪəl)',7819),(148509,'\"kaas\"','____s (tsi:s)',7819),(148510,'\"geel\"','___l (ɡɪəl)',7819),(148511,'__armen','j____s (jɛɾms)',7820),(148512,'avond','j___ne (jɔ:nə)',7820),(148513,'bij','b____ (bɛi)',7820),(148514,'blad','b___ (blet)',7820),(148515,'borst','b__st (bɪast)',7820),(148516,'dag','d__i (dɛɪ)',7820),(148517,'deurtje','d____e (dwɑɾkə)',7820),(148518,'geel','___l (ɡɪəl)',7820),(148519,'kaas','____s (si:s)',7820),(148520,'oog','___ch (eɪx)',7820),(148521,'ik sprak','sp__s (spɾɵts)',7820),(148522,'tand','t__sk (tosk)',7820),(148523,'vis','___s (fɪs)',7820),(148524,'zaterdag','s_____ (sɑ:təɾjə)',7820),(148525,'koken','s__e (sɪəɾə)',7820),(148526,'trein','t___n (tɾɔɪn)',7820),(148527,'heel','h___l (hɪəl)',7820),(148528,'ik ben gegaan','g___ (gɔ:n)',7820),(148529,'ik heb gezet','___t (sɛt)',7820),(148530,'__armen','j____s (jɛɾms)',7821),(148531,'avond','j____n (jun)',7821),(148532,'bij','b____ (bɛi)',7821),(148533,'blad','b___ (blet)',7821),(148534,'borst','b__st (bɒst)',7821),(148535,'dag','d__i (dɛɪ)',7821),(148536,'deurtje','d____e (dwɑɾkə)',7821),(148537,'geel','___l (ɡɪəl)',7821),(148538,'kaas','____s (si:s)',7821),(148539,'oog','___ch (ɛ.ɪx)',7821),(148540,'ik sprak','sp__s (spɾɵts)',7821),(148541,'tand','t__sk (tosk)',7821),(148542,'vis','___sk (fisk)',7821),(148543,'zaterdag','s____n (snɵən)',7821),(148544,'koken','s__e (sɪəɾə)',7821),(148545,'trein','t___n (tɾɑɪn)',7821),(148546,'heel','h___l (he:l)',7821),(148547,'ik ben gegaan','g___ (gonən)',7821),(148548,'ik heb gezet','___n (sɛtn)',7821),(148549,'__armen','j____s (jɛɾms)',7822),(148550,'avond','j____ne (junə)',7822),(148551,'bij','b____ (be:i)',7822),(148552,'blad','b___ (blet)',7822),(148553,'borst','b__st (bɪast)',7822),(148554,'dag','d__i (dɛɪ)',7822),(148555,'deurtje','d____e (dwɑɾkə)',7822),(148556,'geel','___l (ɡɪəl)',7822),(148557,'kaas','____s (si:s)',7822),(148558,'oog','___ch (ɛ.ɪx)',7822),(148559,'ik sprak','sp__s (spɾɵts)',7822),(148560,'tand','t__sk (tosk)',7822),(148561,'vis','___sk (fisk)',7822),(148562,'zaterdag','s_____ (sɑ:təɾjə)',7822),(148563,'koken','s__e (sɪəɾə)',7822),(148564,'trein','t___n (tɾɛɪn)',7822),(148565,'heel','h___l (hø:l)',7822),(148566,'ik ben gegaan','g___ (giən)',7822),(148567,'ik heb gezet','___t (sɛt)',7822),(148568,'\"blad\" (aan een boom)','b___ (blet)',7823),(148569,'\"gezet\"','___t (sɛt)',7823),(148570,'\"gegaan\"','g___ (gonən)',7823),(148571,'\"trein\"','t____n (tɾeɪn)',7823),(148572,'\"deurtje\"','d____e (dwɑɾkə)',7823),(148573,'\"tand\"','t___k (tɵsk)',7823),(148574,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',7823),(148575,'\"heel\"','h___l (hɪəl)',7823),(148576,'\"sprak (toe)\"','sp___s (spɾɵts)',7823),(148577,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',7823),(148578,'\"bij\" (*insect)','b___ (bɛi)',7823),(148579,'\"geel\"','___l (ɡɪəl)',7823),(148580,'\"zaterdag\"','s_____ (sɑ:təɾjə)',7823),(148581,'\"koken\"','s___e (sɪəɾə)',7823),(148582,'\"oog\"','___ch (eɪx)',7823),(148583,'\"avond\"','j__ne (junə)',7
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (171748,'__armen (*lichaamsdeel)','j____n (jɛɾmən)',9043),(171749,'avond','j____n (jun)',9043),(171750,'bij (*insect)','b____ (bɛi)',9043),(171751,'blad (aan een boom)','b___ (blet)',9043),(171752,'borst (*lichaamsdeel)','b__st (bɪast)',9043),(171753,'dag','d__i (dɛɪ)',9043),(171754,'deurtje','d____e (dwɑɾkə)',9043),(171755,'geel','___l (ɡɪəl)',9043),(171756,'kaas','____s (tsi:s)',9043),(171757,'oog','___ch (eɪx)',9043),(171758,'ik sprak (toe)','sp__s (spɾɵts)',9043),(171759,'tand','t___k (tɵsk)',9043),(171760,'vis','___sk (fisk)',9043),(171761,'zaterdag','s_____ (sɑ:təɾjə)',9043),(171762,'koken','s__e (sɪəɾə)',9043),(171763,'trein','t___n (tRɛɪn)',9043),(171764,'heel','h___l (hɪəl)',9043),(171765,'ik ben gegaan','g___ (gɔ:n)',9043),(171766,'ik heb gezet','___n (sɛtn)',9043),(171767,'\"tand\"','t___sk (tosk)',9044),(171768,'\"koken\"','s___e (sɪəɾə)',9044),(171769,'\"bij\" (*insect)','b___ (bɛi)',9044),(171770,'\"gegaan\"','g___ (giən)',9044),(171771,'\"sprak (toe)\"','sp___e (spɾɛktə)',9044),(171772,'\"gezet\"','___n (sɛtn)',9044),(171773,'\"blad\" (aan een boom)','b___ (blɛ:t)',9044),(171774,'\"heel\"','h___l (he:l)',9044),(171775,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',9044),(171776,'\"kaas\"','____s (tsi:s)',9044),(171777,'\"armen\" (*lichaamsdeel)','e____s (ɛ:ɾms)',9044),(171778,'\"zaterdag\"','s____n (snɵən)',9044),(171779,'\"dag\"','d__i (dɛɪ)',9044),(171780,'\"trein\"','t____n (tɾeɪn)',9044),(171781,'\"geel\"','___l (ɡe:l)',9044),(171782,'\"avond\"','j__n (jun)',9044),(171783,'\"deurtje\"','d____e (dwɑɾkə)',9044),(171784,'\"oog\"','___ch (ɛ:x)',9044),(171785,'\"vis\"','___sk (fisk)',9044),(171786,'__armen (*lichaamsdeel)','j____s (jɛɾms)',9045),(171787,'avond','j____ne (junə)',9045),(171788,'bij (*insect)','b____ (bɛi)',9045),(171789,'blad (aan een boom)','b___ (blɛ:t)',9045),(171790,'borst (*lichaamsdeel)','b__st (bɪast)',9045),(171791,'dag','d__i (dɛɪ)',9045),(171792,'deurtje','d____e (dwɑɾkə)',9045),(171793,'geel','___l (ɡɪəl)',9045),(171794,'kaas','____s (tsi:s)',9045),(171795,'oog','___ch (eɪx)',9045),(171796,'ik sprak (toe)','sp__e (spɾɛktə)',9045),(171797,'tand','t__sk (tosk)',9045),(171798,'vis','___sk (fisk)',9045),(171799,'zaterdag','s_____ (sɑ:təɾjə)',9045),(171800,'koken','k___ (ko:kən)',9045),(171801,'trein','t___n (tɾɛɪn)',9045),(171802,'heel','h___l (hɪəl)',9045),(171803,'ik ben gegaan','g___ (giən)',9045),(171804,'ik heb gezet','___n (sɛtn)',9045),(171805,'__armen (*lichaamsdeel)','j____s (jɛɾms)',9046),(171806,'avond','j____n (jun)',9046),(171807,'bij (*insect)','b____ (bɛi)',9046),(171808,'blad (aan een boom)','b___ (blɛ:t)',9046),(171809,'borst (*lichaamsdeel)','b__st (bwɑst)',9046),(171810,'dag','d__i (dɛɪ)',9046),(171811,'deurtje','d____e (dwɑɾkə)',9046),(171812,'geel','___l (ɡe:l)',9046),(171813,'kaas','____s (tsi:s)',9046),(171814,'oog','___ch (ɛ.ɪx)',9046),(171815,'ik sprak (toe)','sp__e (spɾɛktə)',9046),(171816,'tand','t__sk (tosk)',9046),(171817,'vis','___sk (fisk)',9046),(171818,'zaterdag','s____n (snɵən)',9046),(171819,'koken','ts__e (tsɪədə)',9046),(171820,'trein','t___n (tRɛɪn)',9046),(171821,'heel','h___l (he:l)',9046),(171822,'ik ben gegaan','g___ (giən)',9046),(171823,'ik heb gezet','___t (sʌt)',9046),(171824,'\"avond\"','j__n (jun)',9047),(171825,'\"geel\"','___l (ɡe:l)',9047),(171826,'\"zaterdag\"','s____n (snɵən)',9047),(171827,'\"oog\"','___ch (ɛ:x)',9047),(171828,'\"deurtje\"','d____e (dwɑɾkə)',9047),(171829,'\"gezet\"','___t (ɡəsət)',9047),(171830,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',9047),(171831,'\"koken\"','s___e (sɪədə)',9047),(171832,'\"kaas\"','____s (tsi:s)',9047),(171833,'\"heel\"','h___l (hɪəl)',9047),(171834,'\"dag\"','d__i (dɛɪ)',9047),(171835,'\"gegaan\"','g___ (gonən)',9047),(171836,'\"vis\"','___sk (fisk)',9047),(171837,'\"sprak (toe)\"','sp__k (spɾi:k)',9047),(171838,'\"bij\" (*insect)','b___ (bɛi)',9047),(171839,'\"trein\"','t____n (tɾɔɪn)',9047),(171
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (194775,'\"dag\"','d__i (dɑɪ)',10254),(194776,'\"deurtje\"','d____e (dɔ:ɾkə)',10255),(194777,'\"borst\" (*lichaamsdeel)','b__st (bɔɾst)',10255),(194778,'\"gegaan\"','g___ (giən)',10255),(194779,'\"sprak (toe)\"','sp___e (spɾɛktə)',10255),(194780,'\"heel\"','h___l (he:l)',10255),(194781,'\"gezet\"','___n (sɛtn)',10255),(194782,'\"geel\"','___l (ɡɪəl)',10255),(194783,'\"kaas\"','____s (tsi:s)',10255),(194784,'\"koken\"','k___e (kʌtjə)',10255),(194785,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',10255),(194786,'\"vis\"','___s (fɪs)',10255),(194787,'\"zaterdag\"','s____n (snɵən)',10255),(194788,'\"trein\"','t____n (tɾɛɪn)',10255),(194789,'\"oog\"','___ch (eɪx)',10255),(194790,'\"dag\"','d__i (dɛɪ)',10255),(194791,'\"bij\" (*insect)','b___ (bɛi)',10255),(194792,'\"avond\"','j__n (jun)',10255),(194793,'\"blad\" (aan een boom)','b___ (blɛ:t)',10255),(194794,'\"tand\"','t___sk (tosk)',10255),(194795,'\"geel\"','___l (ɡɪəl)',10256),(194796,'\"dag\"','d__i (dɑɪ)',10256),(194797,'\"bij\" (*insect)','b___ (bɛi)',10256),(194798,'\"deurtje\"','d____e (dwɑɾkə)',10256),(194799,'\"gezet\"','___n (sɛtn)',10256),(194800,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',10256),(194801,'\"zaterdag\"','s____n (snɵən)',10256),(194802,'\"avond\"','j__n (jun)',10256),(194803,'\"sprak (toe)\"','sp___s (spɾɵts)',10256),(194804,'\"gegaan\"','g___ (gɔ:n)',10256),(194805,'\"koken\"','s___e (sɪəɾə)',10256),(194806,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',10256),(194807,'\"kaas\"','____s (tsi:s)',10256),(194808,'\"heel\"','h___l (hɪəl)',10256),(194809,'\"blad\" (aan een boom)','b___ (blɛ:t)',10256),(194810,'\"vis\"','___sk (fisk)',10256),(194811,'\"tand\"','t___sk (tosk)',10256),(194812,'\"trein\"','t____n (tɾɑɪn)',10256),(194813,'\"oog\"','___ch (ɪ.əx)',10256),(194814,'\"zaterdag\"','s____n (snɵən)',10257),(194815,'\"bij\" (*insect)','b___ (bɛi)',10257),(194816,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',10257),(194817,'\"gezet\"','___t (ɡəsət)',10257),(194818,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',10257),(194819,'\"kaas\"','____s (tsi:s)',10257),(194820,'\"avond\"','j__n (jun)',10257),(194821,'\"vis\"','___sk (fisk)',10257),(194822,'\"gegaan\"','g___ (gonən)',10257),(194823,'\"geel\"','___l (ɡe:l)',10257),(194824,'\"oog\"','___ch (ɪ.əx)',10257),(194825,'\"koken\"','s___e (sɪəɾə)',10257),(194826,'\"heel\"','h___l (he:l)',10257),(194827,'\"blad\" (aan een boom)','b___ (blɛ:t)',10257),(194828,'\"sprak (toe)\"','sp___s (spɾɵts)',10257),(194829,'\"trein\"','t____n (tɾɔɪn)',10257),(194830,'\"dag\"','d__i (dɑɪ)',10257),(194831,'\"deurtje\"','d____e (dwɑɾkə)',10257),(194832,'\"tand\"','t___sk (tosk)',10257),(194833,'__armen (*lichaamsdeel)','j____n (jɛɾmən)',10258),(194834,'avond','j____n (jun)',10258),(194835,'bij (*insect)','b____ (bɛi)',10258),(194836,'blad (aan een boom)','b___ (blɛ:t)',10258),(194837,'borst (*lichaamsdeel)','b__st (bwɑst)',10258),(194838,'dag','d__i (dɑɪ)',10258),(194839,'deurtje','d____e (dwɑɾkə)',10258),(194840,'geel','___l (ɡeɪl)',10258),(194841,'kaas','____s (tsi:s)',10258),(194842,'oog','___ch (eɪx)',10258),(194843,'ik sprak (toe)','sp__e (spɾɛktə)',10258),(194844,'tand','t__sk (tosk)',10258),(194845,'vis','___sk (fisk)',10258),(194846,'zaterdag','s_____ (sɑ:təɾjə)',10258),(194847,'koken','s__e (sɪəɾə)',10258),(194848,'trein','t___n (tɾɛɪn)',10258),(194849,'heel','h___l (he:l)',10258),(194850,'ik ben gegaan','g___ (gɔ:n)',10258),(194851,'ik heb gezet','___t (sɛt)',10258),(194852,'\"geel\"','___l (ɡɪəl)',10259),(194853,'\"gegaan\"','g___ (giən)',10259),(194854,'\"blad\" (aan een boom)','b___ (blɛ:t)',10259),(194855,'\"armen\" (*lichaamsdeel)','a____n (ɑɾmən)',10259),(194856,'\"sprak (toe)\"','sp__k (spɾɑk)',10259),(194857,'\"kaas\"','____s (tsi:s)',10259),(194858,'\"trein\"','t____n (tɾɑɪn)',10259),(194859,'\"koken\"','k____e (kojtsə)',10259),(194860,'\"vis\"','___s (fɪs)',10259),(194861,'\"zaterdag\"','s____n (snjoun)',10259),(194862,
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (216968,'\"heel\"','h___l (he:l)',11423),(216969,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',11423),(216970,'\"deurtje\"','d____e (dwɑɾkə)',11423),(216971,'\"oog\"','___ch (ɪ.əx)',11423),(216972,'\"bij\" (*insect)','b___ (bɛi)',11423),(216973,'\"vis\"','___sk (fisk)',11423),(216974,'\"zaterdag\"','s____n (snɵən)',11423),(216975,'\"kaas\"','____s (tsi:s)',11423),(216976,'\"tand\"','t___sk (tosk)',11423),(216977,'\"dag\"','d__i (dɛɪ)',11423),(216978,'\"sprak (toe)\"','sp___s (spɾɵts)',11423),(216979,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',11423),(216980,'\"blad\" (aan een boom)','b___ (blɛ:t)',11423),(216981,'\"gezet\"','___n (sɛtn)',11423),(216982,'\"trein\"','t____n (tɾɔɪn)',11423),(216983,'\"koken\"','s___e (sɪəɾə)',11423),(216984,'\"avond\"','j__n (jun)',11423),(216985,'\"gegaan\"','g___ (gonən)',11423),(216986,'\"geel\"','___l (ɡɪəl)',11423),(216987,'\"oog\"','___ch (eɪx)',11424),(216988,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',11424),(216989,'\"koken\"','s___e (sɪəɾə)',11424),(216990,'\"geel\"','___l (ɡɪəl)',11424),(216991,'\"vis\"','___sk (fisk)',11424),(216992,'\"kaas\"','____s (tsi:s)',11424),(216993,'\"sprak (toe)\"','sp___s (spɾɵts)',11424),(216994,'\"trein\"','t____n (tɾeɪn)',11424),(216995,'\"avond\"','j__ne (junə)',11424),(216996,'\"gezet\"','___t (ɡəsət)',11424),(216997,'\"blad\" (aan een boom)','b___ (blɛ:t)',11424),(216998,'\"bij\" (*insect)','h_______r (hɵnəɣowər)',11424),(216999,'\"tand\"','t___n (tɑ:n)',11424),(217000,'\"zaterdag\"','s_____ (sa:tədɑx)',11424),(217001,'\"heel\"','h___l (he:l)',11424),(217002,'\"gegaan\"','g___ (ɣiən)',11424),(217003,'\"armen\" (*lichaamsdeel)','j____s (jɛɾms)',11424),(217004,'\"dag\"','d__i (dɛɪ)',11424),(217005,'\"deurtje\"','d____e (dwɑɾkə)',11424),(217006,'\"gegaan\"','g___ (gɔ:n)',11425),(217007,'\"kaas\"','____s (tsi:s)',11425),(217008,'\"koken\"','s___e (sɪədə)',11425),(217009,'\"vis\"','___sk (fisk)',11425),(217010,'\"armen\" (*lichaamsdeel)','e____s (ɛ:ɾms)',11425),(217011,'\"bij\" (*insect)','b___ (be:i)',11425),(217012,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',11425),(217013,'\"sprak (toe)\"','sp___s (spɾɵts)',11425),(217014,'\"deurtje\"','d____e (dwɑɾkə)',11425),(217015,'\"heel\"','h___l (hɪəl)',11425),(217016,'\"gezet\"','___t (sɛt)',11425),(217017,'\"trein\"','t____n (tɾeɪn)',11425),(217018,'\"geel\"','___l (ɡɪəl)',11425),(217019,'\"zaterdag\"','s_____ (sɑ:təɾjə)',11425),(217020,'\"avond\"','j__n (jun)',11425),(217021,'\"blad\" (aan een boom)','b___ (blet)',11425),(217022,'\"oog\"','___ch (eɪx)',11425),(217023,'\"dag\"','d__i (dɛɪ)',11425),(217024,'\"tand\"','t___k (tɵsk)',11425),(217025,'\"sprak (toe)\"','sp___e (spɾɛktə)',11426),(217026,'\"dag\"','d__i (dɛɪ)',11426),(217027,'\"avond\"','j__n (jun)',11426),(217028,'\"kaas\"','____s (tsi:s)',11426),(217029,'\"vis\"','___s (fɪs)',11426),(217030,'\"armen\" (*lichaamsdeel)','e____s (ɛ:ɾms)',11426),(217031,'\"blad\" (aan een boom)','b___ (blet)',11426),(217032,'\"trein\"','t____n (tɾɛɪn)',11426),(217033,'\"koken\"','s___e (sɪəɾə)',11426),(217034,'\"tand\"','t___sk (tosk)',11426),(217035,'\"zaterdag\"','s_____ (sɑ:təɾjə)',11426),(217036,'\"gegaan\"','g___ (gɔ:n)',11426),(217037,'\"deurtje\"','d____e (dwɑɾkə)',11426),(217038,'\"borst\" (*lichaamsdeel)','b__st (bɪast)',11426),(217039,'\"gezet\"','___t (ɡəsət)',11426),(217040,'\"heel\"','h___l (hø:l)',11426),(217041,'\"oog\"','___ch (eɪx)',11426),(217042,'\"bij\" (*insect)','b___ (bɛi)',11426),(217043,'\"geel\"','___l (ɡɪəl)',11426),(217044,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',11427),(217045,'\"oog\"','___ch (ɛ.ɪx)',11427),(217046,'\"gegaan\"','g___ (giən)',11427),(217047,'\"vis\"','___sk (fisk)',11427),(217048,'\"koken\"','s___e (sɪədə)',11427),(217049,'\"blad\" (aan een boom)','b___ (blɛ:t)',11427),(217050,'\"tand\"','t___sk (tosk)',11427),(217051,'\"zaterdag\"','s_____ (sɑ:təɾjə)',11427),(217052,'\"bij\" (*insect)','b___ (bɛi)',11427),(217053,'\"
INSERT INTO `core_predictionquizresultquestionanswer` VALUES (238959,'\"vis\"','___s (fɪs)',12580),(238960,'\"blad\" (aan een boom)','b___ (blɑt)',12580),(238961,'\"kaas\"','k___s (ka:s)',12580),(238962,'\"gegaan\"','g___ (ga:n)',12580),(238963,'\"koken\"','k___ (ko:kən)',12580),(238964,'\"borst\" (*lichaamsdeel)','b__st (bost)',12580),(238965,'\"deurtje\"','d____e (do:ɾtjə)',12580),(238966,'\"dag\"','d___ (dɑ:x)',12580),(238967,'\"armen\" (*lichaamsdeel)','a____n (ɑɾmən)',12580),(238968,'\"bij\" (*insect)','b___ (be:i)',12580),(238969,'\"oog\"','o___ (o:x)',12580),(238970,'\"trein\"','t____n (tɾɑɪn)',12581),(238971,'\"bij\" (*insect)','h___k (hork)',12581),(238972,'\"blad\" (aan een boom)','b___ (blet)',12581),(238973,'\"gezet\"','___n (sɛdn)',12581),(238974,'\"heel\"','h___l (hø:l)',12581),(238975,'\"armen\" (*lichaamsdeel)','e____n (e:ɾmən)',12581),(238976,'\"sprak (toe)\"','sp___s (spɾɵts)',12581),(238977,'\"zaterdag\"','s____n (snɵən)',12581),(238978,'\"vis\"','___sk (fisk)',12581),(238979,'\"tand\"','k___e (ki:zə)',12581),(238980,'\"koken\"','k____e (kojtsə)',12581),(238981,'\"gegaan\"','g___ (ga:n)',12581),(238982,'\"kaas\"','____s (tsi:s)',12581),(238983,'\"dag\"','d__i (dɛɪ)',12581),(238984,'\"avond\"','a___n (ɑʋən)',12581),(238985,'\"geel\"','___l (ɡe:l)',12581),(238986,'\"oog\"','___ch (ɛ:x)',12581),(238987,'\"borst\" (*lichaamsdeel)','b__st (bɒst)',12581),(238988,'\"deurtje\"','d____e (doətjə)',12581),(238989,'\"armen\" (*lichaamsdeel)','a____n (ɑɾmən)',12582),(238990,'\"blad\" (aan een boom)','b___ (blɔd)',12582),(238991,'\"gegaan\"','g___ (xəxa:n)',12582),(238992,'\"borst\" (*lichaamsdeel)','b__st (bɔɾst)',12582),(238993,'\"avond\"','a__nd (a:vənt)',12582),(238994,'\"sprak (toe)\"','sp__k (spɾɑk)',12582),(238995,'\"kaas\"','k___s (ka:s)',12582),(238996,'\"zaterdag\"','s_____ (sa:tədɑx)',12582),(238997,'\"heel\"','h___l (he:l)',12582),(238998,'\"tand\"','t___d (tɑnt)',12582),(238999,'\"geel\"','___l (ɣiəl)',12582),(239000,'\"koken\"','k___ (kouʔn)',12582),(239001,'\"vis\"','___s (fɪs)',12582),(239002,'\"bij\" (*insect)','b___ (bɛi)',12582),(239003,'\"oog\"','o___ (o:x)',12582),(239004,'\"deurtje\"','d____e (do:ɾtjə)',12582),(239005,'\"trein\"','t____n (tRɛɪn)',12582),(239006,'\"gezet\"','___t (xəsɛt)',12582),(239007,'\"dag\"','d___ (dɑx)',12582),(239008,'\"bij\" (*insect)','b___ (bɛi)',12583),(239009,'\"armen\" (*lichaamsdeel)','e____s (ɛ:ɾms)',12583),(239010,'\"zaterdag\"','s____n (snɵən)',12583),(239011,'\"kaas\"','____s (tsi:s)',12583),(239012,'\"heel\"','h___l (hɪəl)',12583),(239013,'\"dag\"','d__i (dɑɪ)',12583),(239014,'\"blad\" (aan een boom)','b___ (blɛ:t)',12583),(239015,'\"tand\"','t___sk (tosk)',12583),(239016,'\"trein\"','t____n (tɾɑɪn)',12583),(239017,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',12583),(239018,'\"geel\"','___l (ɡɪəl)',12583),(239019,'\"avond\"','j__n (jun)',12583),(239020,'\"koken\"','s___e (sɪədə)',12583),(239021,'\"gegaan\"','g___ (giənt)',12583),(239022,'\"deurtje\"','d____e (dwɑɾkə)',12583),(239023,'\"sprak (toe)\"','sp___e (spɾɛktə)',12583),(239024,'\"oog\"','___ch (ɪ.əx)',12583),(239025,'\"gezet\"','___n (sɛtn)',12583),(239026,'\"vis\"','___sk (fisk)',12583),(239027,'\"tand\"','t___sk (tosk)',12584),(239028,'\"dag\"','d__i (dɑɪ)',12584),(239029,'\"trein\"','t____n (tɾɑɪn)',12584),(239030,'\"heel\"','h___l (heɪl)',12584),(239031,'\"blad\" (aan een boom)','b___ (blɛ:t)',12584),(239032,'\"gezet\"','___n (sɛtn)',12584),(239033,'\"borst\" (*lichaamsdeel)','b__st (bwɑst)',12584),(239034,'\"avond\"','j__n (jun)',12584),(239035,'\"armen\" (*lichaamsdeel)','j____n (jɛɾmən)',12584),(239036,'\"geel\"','___l (ɡɪəl)',12584),(239037,'\"bij\" (*insect)','b___ (bɛi)',12584),(239038,'\"koken\"','s___e (sɪəɾə)',12584),(239039,'\"gegaan\"','g___ (gɔ:n)',12584),(239040,'\"zaterdag\"','s____n (snɵən)',12584),(239041,'\"deurtje\"','d____e (dwɑɾkə)',12584),(239042,'\"oog\"','___ch (eɪx)',12584),(239043,'\"sprak (toe)\"','sp___e (spɾɛktə)',12584),(239044,'\"kaas\"','____s (tsi:s)',1
/*!40000 ALTER TABLE `core_predictionquizresultquestionanswer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_surveyanswer`
--
DROP TABLE IF EXISTS `core_surveyanswer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_surveyanswer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` longtext NOT NULL,
`order` int(10) unsigned NOT NULL,
`updated_at` datetime NOT NULL,
`is_active` tinyint(1) NOT NULL,
`question_id` int(11) NOT NULL,
`text_en` longtext,
`text_fy` longtext,
`text_nl` longtext,
PRIMARY KEY (`id`),
KEY `core_surveyanswer_question_id_86c80a7b_fk_core_surveyquestion_id` (`question_id`),
CONSTRAINT `core_surveyanswer_question_id_86c80a7b_fk_core_surveyquestion_id` FOREIGN KEY (`question_id`) REFERENCES `core_surveyquestion` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_surveyanswer`
--
LOCK TABLES `core_surveyanswer` WRITE;
/*!40000 ALTER TABLE `core_surveyanswer` DISABLE KEYS */;
INSERT INTO `core_surveyanswer` VALUES (14,'0-10',0,'2017-06-26 05:50:45',1,8,'0-10','0-10','0-10'),(15,'11-20',0,'2017-06-26 05:51:15',1,8,'11-20','11-20','11-20'),(16,'male',0,'2017-07-04 14:55:09',1,7,'male','man','man'),(17,'female',0,'2017-07-04 14:55:34',1,7,'female','frou','vrouw'),(18,'other',0,'2017-07-04 14:55:48',1,7,'other','oars','anders'),(19,'Dutch',1,'2017-09-18 12:36:42',1,10,'Dutch','Nederlânsk','Nederlands'),(20,'Frisian',2,'2017-09-18 12:36:42',1,10,'Frisian','Frysk','Fries'),(21,'Frisian',1,'2017-09-18 12:16:44',1,11,'Frisian','Frysk','Fries'),(22,'Dutch',2,'2017-09-18 12:16:44',1,11,'Dutch','Nederlânsk','Nederlands'),(23,'21-30',0,'2017-07-04 14:53:28',1,8,'21-30','21-30','21-30'),(24,'31-40',0,'2017-07-04 14:53:38',1,8,'31-40','31-40','31-40'),(25,'41-50',0,'2017-07-04 14:53:48',1,8,'41-50','41-50','41-50'),(26,'51-60',0,'2017-07-04 14:53:59',1,8,'51-60','51-60','51-60'),(27,'61-70',0,'2017-07-04 14:54:09',1,8,'61-70','61-70','61-70'),(28,'71-80',0,'2017-07-04 14:54:18',1,8,'71-80','71-80','71-80'),(29,'81-90',0,'2017-07-04 14:54:26',1,8,'81-90','81-90','81-90'),(30,'91-100',0,'2017-07-04 14:54:38',1,8,'91-100','91-100','91-100'),(31,'English',17,'2017-09-25 09:53:23',1,10,'English','Ingelsk','Engels'),(32,'Turkish',28,'2017-09-25 09:53:23',1,10,'Turkish','Turks','Turks'),(33,'Papiamentu',24,'2017-09-25 09:53:23',1,10,'Papiamentu','Papiaments','Papiaments'),(34,'German',16,'2017-09-25 09:53:23',1,10,'German','Dûtsk','Duits'),(35,'Mandarin',18,'2017-09-25 09:53:23',1,10,'Mandarin','Sineesk','Mandarijn Chinees'),(36,'Other',30,'2017-09-25 09:53:23',1,10,'Other','Oars','Anders'),(37,'English',16,'2017-09-25 09:48:48',1,11,'English','Ingelsk','Engels'),(38,'German',15,'2017-09-25 09:48:48',1,11,'German','Dûtsk','Duits'),(39,'French',17,'2017-09-25 09:48:48',1,11,'French','Frâns','Frans'),(40,'Turkish',31,'2017-09-25 09:49:00',1,11,'Turkish','Turks','Turks'),(41,'Papiamentu',26,'2017-09-25 09:49:00',1,11,'Papiamentu','Papiaments','Papiaments'),(42,'Mandarin Chinese',19,'2017-09-25 09:48:48',1,11,'Mandarin Chinese','Sineesk','Mandarijn Chinees'),(43,'Polish',27,'2017-09-25 09:49:00',1,11,'Polish','Poalsk','Pools'),(44,'Norwegian',22,'2017-09-25 09:49:00',1,11,'Norwegian','Noarsk','Noors'),(45,'Other',33,'2017-09-25 09:49:00',1,11,'Other','Oars','Anders'),(46,'Afrikaans',12,'2017-09-19 17:42:42',1,11,'Afrikaans','Afrikaansk','Afrikaans'),(47,'Stellingwarfs',8,'2017-09-19 17:42:23',1,11,'Stellingwarfs','Stellingwerfsk','Stellingwerfs'),(48,'Amelands',3,'2017-09-19 17:40:23',1,11,'Amelands','Amelânsk','Amelands'),(49,'Bildts',4,'2017-09-19 17:40:23',1,11,'Bildts','Bildtsk','Bildts'),(50,'City Frisian',7,'2017-09-19 17:42:23',1,11,'City Frisian','Stêdsfrysk','Stadsfries'),(52,'Gronings',11,'2017-09-19 17:42:42',1,11,'Gronings','Grinslânsk','Gronings'),(53,'Tarifit',30,'2017-09-25 09:49:00',1,11,'Tarifit','Tarifit','Tarifit'),(54,'Arabic',13,'2017-09-19 17:42:42',1,11,'Arabic','Arabysk','Arabisch'),(55,'Bahasa Indonesia',18,'2017-09-25 09:48:48',1,11,'Bahasa Indonesia','Yndonesysk','Indonesisch'),(56,'Sranan',29,'2017-09-25 09:49:00',1,11,'Sranan','Sranan','Surinaams'),(57,'Sarnami Hindoestani',28,'2017-09-25 09:49:00',1,11,'Sarnami Hindoestani','Sarnami Hindoestani','Sarnami Hindoestani'),(58,'Stadsfrys',7,'2017-09-19 17:45:16',1,10,'Stadsfrys','Stêdsfrysk','Stadsfries'),(59,'Amelands',3,'2017-09-19 17:44:31',1,10,'Amelands','Amelânsk','Amelands'),(60,'Bildts',4,'2017-09-19 17:44:31',1,10,'Bildts','Bildtsk','Bildts'),(62,'Stellingwarfs',8,'2017-09-19 17:45:16',1,10,'Stellingwarfs','Stellingwerfsk','Stellingwerfs'),(63,'Gronings',11,'2017-09-19 17:45:16',1,10,'Gronings','Grinslânsk','Gronings'),(64,'Afrikaans',12,'2017-09-19 17:45:16',1,10,'Afrikaans','Afrikaansk','Afrikaans'),(65,'Arabic',13,'2017-09-19 17:45:16',1,10,'Arabic','Arabysk','Arabisch'),(66,'Bahasa Indonesia',14,'2017-09-19 17:45:16',1,10,'Bahasa Indonesia','Yndonesysk','Indonesisch'),(67,'Sarnami Hindoestani',25,'2017-09-25 09:53:23',1,10,'Sarnami Hindoestani','Sarnami Hindoestani','Sarnami Hindoestani'),(68,'Sranan',26,'2017-09-25 0
/*!40000 ALTER TABLE `core_surveyanswer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_surveyquestion`
--
DROP TABLE IF EXISTS `core_surveyquestion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_surveyquestion` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(5) unsigned NOT NULL,
`text` longtext NOT NULL,
`is_short_info` tinyint(1) NOT NULL,
`order` int(10) unsigned NOT NULL,
`updated_at` datetime NOT NULL,
`is_active` tinyint(1) NOT NULL,
`category_id` int(11) DEFAULT NULL,
`parent_answer_id` int(11) DEFAULT NULL,
`text_en` longtext,
`text_fy` longtext,
`text_nl` longtext,
PRIMARY KEY (`id`),
KEY `core_surveyquestion_category_id_b83f247c_fk_core_surv` (`category_id`),
KEY `core_surveyquestion_parent_answer_id_f1336aec_fk_core_surv` (`parent_answer_id`),
CONSTRAINT `core_surveyquestion_category_id_b83f247c_fk_core_surv` FOREIGN KEY (`category_id`) REFERENCES `core_surveyquestioncategory` (`id`),
CONSTRAINT `core_surveyquestion_parent_answer_id_f1336aec_fk_core_surv` FOREIGN KEY (`parent_answer_id`) REFERENCES `core_surveyanswer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_surveyquestion`
--
LOCK TABLES `core_surveyquestion` WRITE;
/*!40000 ALTER TABLE `core_surveyquestion` DISABLE KEYS */;
INSERT INTO `core_surveyquestion` VALUES (7,0,'What is your gender?',1,1,'2017-07-04 16:21:19',1,1,NULL,'What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(8,0,'What is your age bracket?',1,2,'2017-07-04 16:24:15',1,1,NULL,'What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(10,0,'Which language are you the most proficient in?',0,1,'2017-09-25 09:53:23',1,2,NULL,'Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(11,1,'Which languages do you actively use in your life?',0,1,'2017-09-25 09:49:00',1,2,NULL,'Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?');
/*!40000 ALTER TABLE `core_surveyquestion` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_surveyquestioncategory`
--
DROP TABLE IF EXISTS `core_surveyquestioncategory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_surveyquestioncategory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`order` int(10) unsigned NOT NULL,
`updated_at` datetime NOT NULL,
`is_active` tinyint(1) NOT NULL,
`name_en` varchar(255) DEFAULT NULL,
`name_fy` varchar(255) DEFAULT NULL,
`name_nl` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_surveyquestioncategory`
--
LOCK TABLES `core_surveyquestioncategory` WRITE;
/*!40000 ALTER TABLE `core_surveyquestioncategory` DISABLE KEYS */;
INSERT INTO `core_surveyquestioncategory` VALUES (1,'About you',1,'2017-07-04 16:25:28',1,'About you','Oer dysels','Over jou'),(2,'Languages',2,'2017-07-04 16:25:32',1,'Languages','Talen','Talen');
/*!40000 ALTER TABLE `core_surveyquestioncategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_surveyresult`
--
DROP TABLE IF EXISTS `core_surveyresult`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_surveyresult` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`device_id` varchar(255) NOT NULL,
`platform` smallint(5) unsigned NOT NULL,
`user_lat` decimal(20,15) NOT NULL,
`user_lng` decimal(20,15) NOT NULL,
`area_lat` decimal(20,15) NOT NULL,
`area_lng` decimal(20,15) NOT NULL,
`area_name` varchar(255) NOT NULL,
`area_name_en` varchar(255) DEFAULT NULL,
`area_name_nl` varchar(255) DEFAULT NULL,
`area_hash` varchar(255) NOT NULL,
`country_name` varchar(255) NOT NULL,
`country_name_en` varchar(255) DEFAULT NULL,
`country_name_nl` varchar(255) DEFAULT NULL,
`submitted_at` datetime NOT NULL,
`area_name_fy` varchar(255) DEFAULT NULL,
`country_name_fy` varchar(255) DEFAULT NULL,
`comment` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `core_surveyresult_device_id_14520c05` (`device_id`),
KEY `core_surveyresult_area_hash_07a50eba` (`area_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=7221 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_surveyresult`
--
LOCK TABLES `core_surveyresult` WRITE;
/*!40000 ALTER TABLE `core_surveyresult` DISABLE KEYS */;
INSERT INTO `core_surveyresult` VALUES (26,'4D72E0BD-6860-4316-9460-CCB174AE74BE',0,53.645225117727750,8.000733905422287,53.662310600000000,7.916517300000001,'Wangerland','Wangerland','Wangerland','62c69d7f75f258bbc59a2f4f7a713baa','Germany','Germany','Duitsland','2017-06-19 11:18:01',NULL,NULL,''),(27,'7d15246a9dac9491',1,53.286525000000000,6.420944000000000,53.303769000000000,6.396263000000000,'Oldehove','Oldehove','Oldehove','37e60b3afdb868dd016f595846b0b415','Netherlands','Netherlands','Nederland','2017-06-19 11:33:01',NULL,NULL,''),(28,'7b9f58b4e9f51203',1,50.562156000000000,6.100865000000000,50.630176000000000,5.969205000000000,'Baelen','Baelen','Balen','fb7ab6ea4bf9a414e2ca323488c16c44','Belgium','Belgium','België','2017-06-23 12:57:23',NULL,NULL,''),(55,'74BF45DB-396C-4148-949F-BF2251A3788D',0,52.541799112879640,6.188934333279058,52.516774700000000,6.083021899999999,'Zwolle','Zwolle','Zwolle','20e72a8d3ed5d26cf9fb7d07450f995d','Netherlands','Netherlands','Nederland','2017-06-27 12:46:39',NULL,NULL,''),(56,'14b6f72d4b86cb05',1,52.963942000000000,5.698033000000000,52.951130000000000,5.710463000000000,'Dijken','Dijken','Dijken','a570feb8b766771613a287dc85748044','Netherlands','Netherlands','Nederland','2017-07-03 10:20:14',NULL,NULL,''),(57,'14b6f72d4b86cb05',1,52.960653000000000,5.798056000000000,52.965521000000000,5.797178000000000,'Joure','Joure','Joure','0fb6f972f7e2ed885b8a62ba75d51e67','Netherlands','Netherlands','Nederland','2017-07-04 11:15:18',NULL,NULL,''),(58,'da814330d0425020',1,53.233129000000000,5.515629000000000,53.234593000000000,5.512321000000000,'Oosterbierum','Oosterbierum','Oosterbierum','7816b865543586d37c15f7749422cf51','Netherlands','Netherlands','Nederland','2017-07-04 11:25:10',NULL,NULL,''),(59,'14b6f72d4b86cb05',1,59.923339000000000,10.743960000000000,59.913869000000000,10.752245000000000,'Oslo','Oslo','Oslo','00d8ff692d749b41022199f2dfced1f7','Norway','Norway','Noorwegen','2017-07-04 15:07:53',NULL,NULL,''),(60,'14b6f72d4b86cb05',1,59.915523000000000,10.729872000000000,59.913869000000000,10.752245000000000,'Oslo','Oslo','Oslo','00d8ff692d749b41022199f2dfced1f7','Norway','Norway','Noorwegen','2017-07-04 15:19:50',NULL,NULL,''),(61,'14b6f72d4b86cb05',1,53.134073000000000,6.648646000000000,53.154780000000000,6.643499000000000,'Onnen','Onnen','Onnen','01df1ac6807c018221b5945e2f940218','Netherlands','Netherlands','Nederland','2017-07-04 15:35:27',NULL,NULL,''),(62,'69686fdc6ef17dd3',1,53.258268000000000,6.038744000000000,53.254494000000000,6.030726000000000,'De Westereen','De Westereen','De Westereen','a3edf6e4d6f64d632de823959012206b','Netherlands','Netherlands','Nederland','2017-07-05 06:33:35',NULL,NULL,''),(63,'6458619a89a7ad7f',1,53.251869000000000,6.155852000000000,53.252495000000000,6.150375000000000,'Buitenpost','Buitenpost','Buitenpost','a6cbd2f15a46a90dff2a30898eb7c3ed','Netherlands','Netherlands','Nederland','2017-07-05 06:35:18',NULL,NULL,''),(64,'9953f40fe979425e',1,53.184282000000000,6.138161000000000,53.184892000000000,6.137903000000000,'Harkema','Harkema','Harkema','3dbbeb48f572ca2c1eba65f23d6238d5','Netherlands','Netherlands','Nederland','2017-07-05 06:35:30',NULL,NULL,''),(65,'7021251b3c699b87',1,53.203822000000000,6.251870000000000,53.199910000000000,6.248529000000000,'Doezum','Doezum','Doezum','3561557955ed1f48fbaaa61640fc76ed','Netherlands','Netherlands','Nederland','2017-07-05 06:35:52',NULL,NULL,''),(66,'cfb383c434e1bf27',1,53.242708000000000,6.199835000000000,53.241119000000000,6.207484000000000,'Gerkesklooster','Gerkesklooster','Gerkesklooster','452795049374feaf86b3bf62698e2945','Netherlands','Netherlands','Nederland','2017-07-05 06:36:55',NULL,NULL,''),(67,'536c388449d6f7cb',1,53.101658000000000,6.002728000000000,53.103662000000000,6.018332000000000,'Smalle Ee','Smalle Ee','Smalle Ee','810e4c7a50290fbb31bf5f666206cca4','Netherlands','Netherlands','Nederland','2017-07-05 06:36:58',NULL,NULL,''),(68,'7021251b3c699b87',1,53.203822000000000,6.251870000000000,53.199910000000000,6.248529000000000,'Doezum','Doezum','Doezum','3561557955ed1f48fbaaa61640fc76ed','Netherlands',
INSERT INTO `core_surveyresult` VALUES (4365,'f681ea9c169b4819',1,52.969455000000000,5.632114000000000,52.981679000000000,5.650151000000000,'Hommerts','Hommerts','Hommerts','77ffb90dcda9e79453df3d120ea99235','Netherlands','Netherlands','Nederland','2017-09-26 16:27:31',NULL,NULL,''),(4366,'8d5d13c0-d733162e-de983731',2,1.000000000000000,1.000000000000000,53.047817959114690,6.437988281250000,'',NULL,NULL,'13199e28244dd835af12013b8562dd2a','',NULL,NULL,'2017-09-26 16:28:31',NULL,NULL,'Makkum'),(4367,'d3d819bf60ebfc35',1,53.105782000000000,6.082989000000000,53.092581000000000,6.058637000000000,'Drachten','Drachten','Drachten','838aca700df85842180cfcff92e0d15b','Netherlands','Netherlands','Nederland','2017-09-26 16:30:49',NULL,NULL,''),(4368,'e81ce3d7-da6b3073-d44b5697',2,1.000000000000000,1.000000000000000,53.082580289558365,6.044282913208008,'',NULL,NULL,'e0b3298f1098a2897edc1ef5ba09d105','',NULL,NULL,'2017-09-26 16:32:09',NULL,NULL,''),(4369,'8d5d13c0-d733162e-de983731',2,1.000000000000000,1.000000000000000,53.047817959114690,6.437988281250000,'',NULL,NULL,'13199e28244dd835af12013b8562dd2a','',NULL,NULL,'2017-09-26 16:32:22',NULL,NULL,'Makkum'),(4370,'b422b77c6cc8cced',1,53.265738000000000,6.006766000000000,53.263444000000000,6.007731000000000,'De Falom','De Falom','De Falom','0cf167ec3700bfb220009599166a8758','Netherlands','Netherlands','Nederland','2017-09-26 16:34:39',NULL,NULL,''),(4371,'60E3901B-6E0A-4522-A424-6E63AAC2EA4A',0,53.037320973725990,5.870254105339017,53.048109300000000,5.892489200000000,'Aldeboarn','Aldeboarn','Aldeboarn','13a912af38ee00d7067b767302c52973','Netherlands','Netherlands','Nederland','2017-09-26 16:34:43',NULL,NULL,''),(4372,'99ce8c6973b93c17',1,53.084695000000000,6.046573000000000,53.082499000000000,6.043975000000000,'Boornbergum','Boornbergum','Boornbergum','ec74d0b02be183cfb6d0b6cf6961e5c7','Netherlands','Netherlands','Nederland','2017-09-26 16:37:45',NULL,NULL,'Ik úterje my it alderbêst yn it Frysk en ik skriuw it eins ik altyd oer de app en mei de bêrn. At se my net fersteane dan hear ik it wol'),(4373,'3632a568-abe95b33-0be2e78f',2,1.000000000000000,1.000000000000000,53.247138717452785,5.592041015625000,'',NULL,NULL,'d9b369d78e0c8dd955838ff415c0cd07','',NULL,NULL,'2017-09-26 16:42:51',NULL,NULL,''),(4374,'434BBA79-F261-4CF5-8F6A-B7C6B082CA2A',0,52.948017296757640,5.936005077879105,52.960561300000000,5.920521700000001,'Heerenveen','Heerenveen','Heerenveen','2307bfd8140779a5419396758d4a3c31','Netherlands','Netherlands','Nederland','2017-09-26 16:46:29',NULL,NULL,''),(4375,'5b77cd52-d0b3f13d-eadb2fc8',2,1.000000000000000,1.000000000000000,53.187933336083150,5.787048339843750,'',NULL,NULL,'67918dc36ce97ee4458e4704d575a62c','',NULL,NULL,'2017-09-26 16:49:47',NULL,NULL,''),(4376,'8ad5a2f8-d763b0e5-a151ca0f',2,1.000000000000000,1.000000000000000,53.029651998273560,5.674438476562500,'',NULL,NULL,'ece707812ee41781fa293d5f93a4b600','',NULL,NULL,'2017-09-26 16:55:08',NULL,NULL,'Dizze kear hew ik \'m su infuld as dat ik Snekers praat.'),(4377,'6352ab98-533d9ae1-7df12c3b',2,1.000000000000000,1.000000000000000,53.197806582764360,5.572814941406250,'',NULL,NULL,'8f1af578ccf26ab2906d5b79b0128d41','',NULL,NULL,'2017-09-26 16:58:01',NULL,NULL,''),(4378,'77966b1700ba85b1',1,53.330452000000000,6.102876000000000,53.330426000000000,6.100842000000000,'Ee','Ee','Ee','253674c4ff598829fa0339153cbbf12a','Netherlands','Netherlands','Nederland','2017-09-26 17:01:22',NULL,NULL,''),(4379,'468adf014c00515e',1,53.249555000000000,6.161893000000000,53.252495000000000,6.150375000000000,'Buitenpost','Buitenpost','Buitenpost','a6cbd2f15a46a90dff2a30898eb7c3ed','Netherlands','Netherlands','Nederland','2017-09-26 17:01:28',NULL,NULL,''),(4380,'F1F4B0E8-4CEE-4101-970C-6BBD34FEB1C0',0,53.046909960127630,5.576260525566692,53.050993299999990,5.576542600000000,'Nijland','Nijland','Nijland','5f7746376249cd7e139b828d95c4d036','Netherlands','Netherlands','Nederland','2017-09-26 17:04:25',NULL,NULL,''),(4381,'5DE6DC4E-2E06-40E5-A563-1DCA3F2FFD67',0,53.279601173054460,6.149304889986343,53.280142400000000,6.147745899999999,'Kollum','K
/*!40000 ALTER TABLE `core_surveyresult` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `core_surveyresultquestionanswer`
--
DROP TABLE IF EXISTS `core_surveyresultquestionanswer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_surveyresultquestionanswer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`question_text` longtext NOT NULL,
`answer_text` longtext NOT NULL,
`answer_id` int(11) DEFAULT NULL,
`question_id` int(11) DEFAULT NULL,
`survey_result_id` int(11) NOT NULL,
`answer_text_en` longtext,
`answer_text_fy` longtext,
`answer_text_nl` longtext,
`question_text_en` longtext,
`question_text_fy` longtext,
`question_text_nl` longtext,
PRIMARY KEY (`id`),
KEY `core_surveyresultque_answer_id_ea34e7a9_fk_core_surv` (`answer_id`),
KEY `core_surveyresultque_question_id_75c81dd6_fk_core_surv` (`question_id`),
KEY `core_surveyresultque_survey_result_id_4ad2e7f5_fk_core_surv` (`survey_result_id`),
CONSTRAINT `core_surveyresultque_answer_id_ea34e7a9_fk_core_surv` FOREIGN KEY (`answer_id`) REFERENCES `core_surveyanswer` (`id`),
CONSTRAINT `core_surveyresultque_question_id_75c81dd6_fk_core_surv` FOREIGN KEY (`question_id`) REFERENCES `core_surveyquestion` (`id`),
CONSTRAINT `core_surveyresultque_survey_result_id_4ad2e7f5_fk_core_surv` FOREIGN KEY (`survey_result_id`) REFERENCES `core_surveyresult` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30587 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `core_surveyresultquestionanswer`
--
LOCK TABLES `core_surveyresultquestionanswer` WRITE;
/*!40000 ALTER TABLE `core_surveyresultquestionanswer` DISABLE KEYS */;
INSERT INTO `core_surveyresultquestionanswer` VALUES (108,'What is your gender?','female',17,7,26,NULL,NULL,NULL,NULL,NULL,NULL),(109,'What is your age?','11-20',15,8,26,NULL,NULL,NULL,NULL,NULL,NULL),(110,'Do you go to school?','No',20,10,26,NULL,NULL,NULL,NULL,NULL,NULL),(111,'Do you go to university?','yes',21,11,26,NULL,NULL,NULL,NULL,NULL,NULL),(112,'What is your gender?','female',17,7,27,NULL,NULL,NULL,NULL,NULL,NULL),(113,'Do you go to university?','yes',21,11,27,NULL,NULL,NULL,NULL,NULL,NULL),(114,'What is your age?','11-20',15,8,27,NULL,NULL,NULL,NULL,NULL,NULL),(115,'Do you go to school?','No',20,10,27,NULL,NULL,NULL,NULL,NULL,NULL),(116,'Do you go to school?','Yes',19,10,28,NULL,NULL,NULL,NULL,NULL,NULL),(117,'What is your gender?','female',17,7,28,NULL,NULL,NULL,NULL,NULL,NULL),(118,'What is your age?','11-20',15,8,28,NULL,NULL,NULL,NULL,NULL,NULL),(216,'What is your gender?','male',16,7,55,'male','male','male','What is your gender?','What is your gender?','What is your gender?'),(217,'What is your age?','11-20',15,8,55,'11-20','11-20','11-20','What is your age?','What is your age?','What is your age?'),(218,'Do you go to school?','Yes',19,10,55,'Yes','Yes','Yes','Do you go to school?','Do you go to school?','Do you go to school?'),(219,'Do you go to university?','no',22,11,56,'no','no','no','Do you go to university?','Do you go to university?','Do you go to university?'),(220,'What is your gender?','female',17,7,56,'female','female','female','What is your gender?','What is your gender?','What is your gender?'),(221,'What is your age?','0-10',14,8,56,'0-10','0-10','0-10','What is your age?','What is your age?','What is your age?'),(222,'Do you go to school?','No',20,10,56,'No','No','No','Do you go to school?','Do you go to school?','Do you go to school?'),(223,'Do you go to school?','Yes',19,10,57,'Yes','Yes','Yes','Do you go to school?','Do you go to school?','Do you go to school?'),(224,'What is your gender?','male',16,7,57,'male','male','male','What is your gender?','What is your gender?','What is your gender?'),(225,'What is your age?','11-20',15,8,57,'11-20','11-20','11-20','What is your age?','What is your age?','What is your age?'),(226,'Do you go to school?','Yes',19,10,58,'Yes','Yes','Yes','Do you go to school?','Do you go to school?','Do you go to school?'),(227,'What is your gender?','female',17,7,58,'female','female','female','What is your gender?','What is your gender?','What is your gender?'),(228,'What is your age?','11-20',15,8,58,'11-20','11-20','11-20','What is your age?','What is your age?','What is your age?'),(229,'Do you go to university?','no',22,11,59,'no','no','no','Do you go to university?','Do you go to university?','Do you go to university?'),(230,'What is your gender?','female',17,7,59,'female','frou','vrouw','What is your gender?','Wat is je geslacht?','Wat is je geslacht?'),(231,'What is your age bracket?','31-40',24,8,59,'31-40','31-40','31-40','What is your age bracket?','Wat is jouw leeftijdscategorie?','Wat is jouw leeftijdscategorie?'),(232,'Which language are you the most proficient in?','Frisian',20,10,59,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Welke taal beheers je het beste?','Welke taal beheers je het beste?'),(233,'What is your gender?','female',17,7,60,'female','frou','vrouw','What is your gender?','Wat is je geslacht?','Wat is je geslacht?'),(234,'Which language are you the most proficient in?','Other',36,10,60,'Other','Oars','Anders','Which language are you the most proficient in?','Welke taal beheers je het beste?','Welke taal beheers je het beste?'),(235,'What is your age bracket?','31-40',24,8,60,'31-40','31-40','31-40','What is your age bracket?','Wat is jouw leeftijdscategorie?','Wat is jouw leeftijdscategorie?'),(236,'What is your gender?','female',17,7,61,'female','frou','vrouw','What is your gender?','Wat is je geslacht?','Wat is je geslacht?'),(237,'Which languages do you actively use in your life?','English',37,11,61,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen bruskt a
INSERT INTO `core_surveyresultquestionanswer` VALUES (5910,'Which languages do you actively use in your life?','Frisian',21,11,1444,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5911,'Which languages do you actively use in your life?','Dutch',22,11,1444,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5912,'Which languages do you actively use in your life?','English',37,11,1444,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5913,'What is your gender?','male',16,7,1445,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(5914,'What is your age bracket?','51-60',26,8,1445,'51-60','51-60','51-60','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(5915,'Which language are you the most proficient in?','Frisian',20,10,1445,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(5916,'Which languages do you actively use in your life?','Frisian',21,11,1445,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5917,'Which languages do you actively use in your life?','Dutch',22,11,1445,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5918,'Which languages do you actively use in your life?','Frisian',21,11,1446,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5919,'What is your age bracket?','21-30',23,8,1446,'21-30','21-30','21-30','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(5920,'Which languages do you actively use in your life?','Dutch',22,11,1446,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5921,'What is your gender?','male',16,7,1446,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(5922,'Which language are you the most proficient in?','Dutch',19,10,1446,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(5923,'Which languages do you actively use in your life?','Frisian',21,11,1447,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5924,'What is your age bracket?','21-30',23,8,1447,'21-30','21-30','21-30','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(5925,'Which languages do you actively use in your life?','Dutch',22,11,1447,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(5926,'Which language are you the most proficient in?','Dutch',19,10,1447,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(5927,'What is your gender?','male',16,7,1447,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(5928,'What is your gender?','male',16,7,1448,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(5929,'What is your age bracket?','71-80',28,8,1448,'71-80','71-80','71-80','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(5930,'What is your gender?','female',17,7,1449,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(5931,'What is your age bracket?','21-30',23,8,1449,'21-30','21-30
INSERT INTO `core_surveyresultquestionanswer` VALUES (11425,'What is your age bracket?','41-50',25,8,2687,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(11426,'Which languages do you actively use in your life?','English',37,11,2688,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11427,'Which languages do you actively use in your life?','Frisian',21,11,2688,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11428,'Which languages do you actively use in your life?','Dutch',22,11,2688,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11429,'What is your gender?','male',16,7,2688,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(11430,'What is your age bracket?','31-40',24,8,2688,'31-40','31-40','31-40','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(11431,'Which language are you the most proficient in?','Frisian',20,10,2688,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(11432,'What is your gender?','female',17,7,2689,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(11433,'What is your age bracket?','61-70',27,8,2689,'61-70','61-70','61-70','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(11434,'What is your gender?','female',17,7,2690,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(11435,'Which languages do you actively use in your life?','English',37,11,2690,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11436,'Which languages do you actively use in your life?','Frisian',21,11,2690,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11437,'Which languages do you actively use in your life?','Dutch',22,11,2690,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11438,'Which language are you the most proficient in?','Dutch',19,10,2690,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(11439,'Which languages do you actively use in your life?','German',38,11,2690,'German','Dûtsk','Duits','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11440,'What is your age bracket?','41-50',25,8,2690,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(11441,'What is your gender?','male',16,7,2691,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(11442,'What is your age bracket?','21-30',23,8,2691,'21-30','21-30','21-30','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(11443,'Which language are you the most proficient in?','Dutch',19,10,2691,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(11444,'Which languages do you actively use in your life?','Frisian',21,11,2691,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11445,'Which languages do you actively use in your life?','Dutch',22,11,2691,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(11446,'Which language
INSERT INTO `core_surveyresultquestionanswer` VALUES (17179,'Which language are you the most proficient in?','Frisian',20,10,4312,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(17180,'What is your gender?','female',17,7,4313,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17181,'What is your age bracket?','21-30',23,8,4313,'21-30','21-30','21-30','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17182,'What is your gender?','male',16,7,4314,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17183,'What is your age bracket?','41-50',25,8,4314,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17184,'What is your gender?','female',17,7,4315,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17185,'What is your age bracket?','21-30',23,8,4315,'21-30','21-30','21-30','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17186,'What is your gender?','female',17,7,4316,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17187,'What is your age bracket?','41-50',25,8,4316,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17188,'Which language are you the most proficient in?','Frisian',20,10,4316,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(17189,'Which languages do you actively use in your life?','Frisian',21,11,4316,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17190,'Which languages do you actively use in your life?','Dutch',22,11,4316,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17191,'What is your gender?','female',17,7,4317,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17192,'What is your age bracket?','51-60',26,8,4317,'51-60','51-60','51-60','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17193,'Which language are you the most proficient in?','Frisian',20,10,4317,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(17194,'Which languages do you actively use in your life?','Dutch',22,11,4317,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17195,'Which languages do you actively use in your life?','Frisian',21,11,4317,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17196,'Which languages do you actively use in your life?','English',37,11,4317,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17197,'Which languages do you actively use in your life?','German',38,11,4317,'German','Dûtsk','Duits','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(17198,'What is your gender?','male',16,7,4318,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(17199,'What is your age bracket?','71-80',28,8,4318,'71-80','71-80','71-80','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(17200,'Which language are you the most proficient in?','Stadsfrys',58,10,4318,'Stadsfrys','Stêdsfrysk','Stadsfries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(17201,'Which languages do you acti
INSERT INTO `core_surveyresultquestionanswer` VALUES (22718,'Which languages do you actively use in your life?','Dutch',22,11,5618,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22719,'Which languages do you actively use in your life?','English',37,11,5619,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22720,'Which languages do you actively use in your life?','Frisian',21,11,5619,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22721,'What is your age bracket?','51-60',26,8,5619,'51-60','51-60','51-60','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(22722,'Which languages do you actively use in your life?','Dutch',22,11,5619,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22723,'What is your gender?','male',16,7,5619,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(22724,'Which language are you the most proficient in?','Dutch',19,10,5619,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(22725,'Which languages do you actively use in your life?','German',38,11,5619,'German','Dûtsk','Duits','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22726,'What is your gender?','male',16,7,5620,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(22727,'What is your age bracket?','61-70',27,8,5620,'61-70','61-70','61-70','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(22728,'What is your gender?','male',16,7,5621,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(22729,'What is your age bracket?','41-50',25,8,5621,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(22730,'Which language are you the most proficient in?','Dutch',19,10,5621,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(22731,'Which languages do you actively use in your life?','Dutch',22,11,5621,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22732,'Which languages do you actively use in your life?','Frisian',21,11,5621,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22733,'Which languages do you actively use in your life?','City Frisian',50,11,5621,'City Frisian','Stêdsfrysk','Stadsfries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22734,'What is your gender?','female',17,7,5622,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(22735,'What is your age bracket?','41-50',25,8,5622,'41-50','41-50','41-50','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(22736,'Which language are you the most proficient in?','Dutch',19,10,5622,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(22737,'Which languages do you actively use in your life?','German',38,11,5622,'German','Dûtsk','Duits','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(22738,'Which languages do you actively use in your life?','Frisian',21,11,5622,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Ho
INSERT INTO `core_surveyresultquestionanswer` VALUES (28104,'Which languages do you actively use in your life?','Amelands',48,11,6710,'Amelands','Amelânsk','Amelands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28105,'What is your gender?','female',17,7,6710,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(28106,'Which languages do you actively use in your life?','English',37,11,6710,'English','Ingelsk','Engels','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28107,'Which languages do you actively use in your life?','City Frisian',50,11,6710,'City Frisian','Stêdsfrysk','Stadsfries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28108,'What is your gender?','female',17,7,6711,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(28109,'Which languages do you actively use in your life?','Dutch',22,11,6711,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28110,'Which language are you the most proficient in?','Dutch',19,10,6711,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(28111,'What is your age bracket?','11-20',15,8,6711,'11-20','11-20','11-20','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(28112,'Which languages do you actively use in your life?','Drents',73,11,6712,'Drents','Drintsk','Drents','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28113,'Which languages do you actively use in your life?','Frisian',21,11,6712,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28114,'Which languages do you actively use in your life?','Dutch',22,11,6712,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28115,'What is your gender?','male',16,7,6712,'male','man','man','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(28116,'What is your age bracket?','11-20',15,8,6712,'11-20','11-20','11-20','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(28117,'Which language are you the most proficient in?','Frisian',20,10,6712,'Frisian','Frysk','Fries','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(28118,'What is your gender?','female',17,7,6713,'female','frou','vrouw','What is your gender?','Wat is dyn geslacht?','Wat is je geslacht?'),(28119,'Which languages do you actively use in your life?','Frisian',21,11,6713,'Frisian','Frysk','Fries','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28120,'Which languages do you actively use in your life?','Dutch',22,11,6713,'Dutch','Nederlânsk','Nederlands','Which languages do you actively use in your life?','Hokker talen brukst aktyf?','Welke talen gebruik je actief?'),(28121,'Which language are you the most proficient in?','Dutch',19,10,6713,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(28122,'What is your age bracket?','11-20',15,8,6713,'11-20','11-20','11-20','What is your age bracket?','Hoe âld bist','Wat is jouw leeftijdscategorie?'),(28123,'Which language are you the most proficient in?','Dutch',19,10,6714,'Dutch','Nederlânsk','Nederlands','Which language are you the most proficient in?','Hokker taal kinsto it bêst?','Welke taal beheers je het beste?'),(28124,'What is your gender?','male',16,7,6714,'male','man','man','What
/*!40000 ALTER TABLE `core_surveyresultquestionanswer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_admin_log`
--
DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action_time` datetime NOT NULL,
`object_id` longtext,
`object_repr` varchar(200) NOT NULL,
`action_flag` smallint(5) unsigned NOT NULL,
`change_message` longtext NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=821 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_admin_log`
--
LOCK TABLES `django_admin_log` WRITE;
/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
INSERT INTO `django_admin_log` VALUES (1,'2017-06-19 10:33:15','11','screenshot',3,'',12,1),(2,'2017-06-19 11:03:15','2','Netherlands',3,'',12,1),(3,'2017-06-19 11:03:15','3','Germany',3,'',12,1),(4,'2017-06-19 11:03:15','4','Frisian logo',3,'',12,1),(5,'2017-06-19 11:03:15','5','Frisian flag',3,'',12,1),(6,'2017-06-19 11:03:15','10','Stimmen icon',3,'',12,1),(7,'2017-06-19 11:03:35','1','gitlab',2,'[{\"changed\": {\"fields\": [\"picture\"]}}]',12,1),(8,'2017-06-19 11:03:44','6','Apple',2,'[{\"changed\": {\"fields\": [\"picture\"]}}]',12,1),(9,'2017-06-19 11:03:51','7','voice memos',2,'[{\"changed\": {\"fields\": [\"picture\"]}}]',12,1),(10,'2017-06-19 11:03:59','8','scheme',2,'[{\"changed\": {\"fields\": [\"picture\"]}}]',12,1),(11,'2017-06-19 11:04:15','9','torch',2,'[{\"changed\": {\"fields\": [\"picture\"]}}]',12,1),(12,'2017-06-19 11:04:43','25','4D72E0BD-6860-4316-9460-CCB174AE74BE (iOS) Berumbur 2017-06-19 T 10:58:50',3,'',7,1),(13,'2017-06-19 11:04:43','24','F3E1D038-09D2-4295-B6D6-2DF992CF02C3 (iOS) Twijzel 2017-06-19 T 10:48:54',3,'',7,1),(14,'2017-06-19 11:04:43','23','C5594291-6A57-4A89-9382-3031C10E70D4 (iOS) Wangerland 2017-06-19 T 10:41:29',3,'',7,1),(15,'2017-06-19 11:04:43','22','123 (iOS) Novosibirsk 2017-06-19 T 10:32:33',3,'',7,1),(16,'2017-06-19 11:04:43','21','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Bunnik 2017-06-14 T 03:54:05',3,'',7,1),(17,'2017-06-19 11:04:43','20','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-13 T 12:02:55',3,'',7,1),(18,'2017-06-19 11:04:43','19','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-13 T 11:55:45',3,'',7,1),(19,'2017-06-19 11:04:43','18','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-13 T 11:52:30',3,'',7,1),(20,'2017-06-19 11:04:43','17','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-13 T 11:42:11',3,'',7,1),(21,'2017-06-19 11:04:43','16','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-13 T 11:29:25',3,'',7,1),(22,'2017-06-19 11:04:43','15','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Kamerik 2017-06-13 T 11:11:00',3,'',7,1),(23,'2017-06-19 11:04:43','14','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Wezep 2017-06-13 T 11:06:53',3,'',7,1),(24,'2017-06-19 11:04:43','13','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Leur 2017-06-13 T 10:29:58',3,'',7,1),(25,'2017-06-19 11:04:43','12','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Heteren 2017-06-13 T 10:29:11',3,'',7,1),(26,'2017-06-19 11:04:43','11','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Ruurlo 2017-06-13 T 10:24:05',3,'',7,1),(27,'2017-06-19 11:04:43','10','CEDAB5B7-C0B8-452D-994F-0FF37ECF1171 (iOS) Odoorn 2017-06-13 T 10:15:32',3,'',7,1),(28,'2017-06-19 11:04:44','9','CEDAB5B7-C0B8-452D-994F-0FF37ECF1171 (iOS) Papendrecht 2017-06-13 T 10:11:41',3,'',7,1),(29,'2017-06-19 11:04:44','8','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Nieuwveen 2017-06-13 T 10:07:33',3,'',7,1),(30,'2017-06-19 11:04:44','7','85D28E4C-B859-4730-A11C-0CC954F3DC75 (iOS) Odoorn 2017-06-13 T 09:22:50',3,'',7,1),(31,'2017-06-19 11:04:44','6','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Hoogmade 2017-06-13 T 09:19:30',3,'',7,1),(32,'2017-06-19 11:04:44','5','C1154CCF-57B1-4F58-A97A-7F4683985684 (iOS) Benningbroek 2017-06-13 T 08:52:08',3,'',7,1),(33,'2017-06-19 11:04:44','4','929C1BC0-E603-4C6F-BC6F-7FDEC202547A (iOS) Jistrum 2017-06-09 T 13:47:43',3,'',7,1),(34,'2017-06-19 11:04:44','3','2F71BC5F-4089-4C44-9E0C-9B1F7EE049A9 (iOS) Leeuwarden 2017-06-09 T 13:05:37',3,'',7,1),(35,'2017-06-19 11:04:44','2','3d32791a57e2344a (Android) Amsterdam-Zuidoost 2017-06-09 T 06:52:24',3,'',7,1),(36,'2017-06-19 11:05:13','3','Undefined location 2017-06-07 T 12:04:01',3,'',18,1),(37,'2017-06-19 11:05:13','2','Undefined location 2017-06-07 T 10:57:31',3,'',18,1),(38,'2017-06-19 11:12:30','1','gitlab',3,'',12,1),(39,'2017-06-19 11:12:30','6','Apple',3,'',12,1),(40,'2017-06-19 11:12:30','7','voice memos',3,'',12,1),(41,'2017-06-19 11:12:30','9','torch',3,'',12,1),(42,'2017-06-19 11:12:48','2','WWW?',3,'',11,1),(43,'2017-06-19 11:12:48','1','QQQ?',3,'',11,1),(44,'2017-06-19 11:12:48','3','EEE?',3,'',11
/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_content_type`
--
DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_content_type`
--
LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(16,'core','freespeechresult'),(8,'core','freespeechtheme'),(14,'core','language'),(12,'core','picturegameitem'),(9,'core','picturegameresult'),(18,'core','predictionquizresult'),(15,'core','predictionquizresultquestionanswer'),(17,'core','surveyanswer'),(11,'core','surveyquestion'),(13,'core','surveyquestioncategory'),(7,'core','surveyresult'),(10,'core','surveyresultquestionanswer'),(6,'sessions','session');
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_migrations`
--
DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_migrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`applied` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_migrations`
--
LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2017-06-19 10:28:43'),(2,'auth','0001_initial','2017-06-19 10:28:45'),(3,'admin','0001_initial','2017-06-19 10:28:45'),(4,'admin','0002_logentry_remove_auto_add','2017-06-19 10:28:45'),(5,'contenttypes','0002_remove_content_type_name','2017-06-19 10:28:45'),(6,'auth','0002_alter_permission_name_max_length','2017-06-19 10:28:45'),(7,'auth','0003_alter_user_email_max_length','2017-06-19 10:28:45'),(8,'auth','0004_alter_user_username_opts','2017-06-19 10:28:45'),(9,'auth','0005_alter_user_last_login_null','2017-06-19 10:28:45'),(10,'auth','0006_require_contenttypes_0002','2017-06-19 10:28:45'),(11,'auth','0007_alter_validators_add_error_messages','2017-06-19 10:28:45'),(12,'auth','0008_alter_user_username_max_length','2017-06-19 10:28:45'),(13,'core','0001_initial','2017-06-19 10:28:48'),(14,'sessions','0001_initial','2017-06-19 10:28:49'),(15,'core','0002_auto_20170621_1607','2017-06-26 05:31:50'),(16,'core','0003_auto_20170815_1332','2017-08-15 08:01:40'),(17,'core','0004_surveyresult_comment','2017-09-07 13:25:39');
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_session`
--
DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_session` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime NOT NULL,
PRIMARY KEY (`session_key`),
KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_session`
--
LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
INSERT INTO `django_session` VALUES ('008ycxk1dymrlq70q6xd0x4iw9yz0val','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-10-16 12:54:27'),('0ad8fen0tct1bnh657wglyawzuxxohbx','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-10-11 11:44:52'),('0ewuwja8rrz6apcd0m3lb8ek4iqvcvg7','ZWU2ZDM0NzA0MTAyMGRiOThmM2QzY2YzZWYyOGU2OWM3NDhmY2VmMTp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjEiLCJfYXV0aF91c2VyX2hhc2giOiI1MDU5ZTU2ZjE1YjFkODIzYTcyYTA4ZTI4MjcxOWUwMmQ5MTMwNDQ2In0=','2017-10-10 07:44:58'),('0fyyep6hq53ecr8tawkarwuppqsogekk','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-10-27 15:57:07'),('1o9o2l2ojm3dvedgpyvz6yuect8k9ko0','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-10-10 10:53:57'),('2yiazq4bg1jm4pubzj13srf3xi5wzqpy','YzQ2NjY3Yzk2NGQyMDgxYTc2ODI3ZDhhNjUzOWM1NDYwZjQyYWZmODp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9iYWNrZW5kIjoiZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5kcy5Nb2RlbEJhY2tlbmQiLCJfYXV0aF91c2VyX2hhc2giOiIzM2YwOWZhNzczOGM3ZGQ5ZDA3YzZlODEzMTI0MGYxOTE1MjA2MzM5In0=','2017-09-15 05:31:19'),('4euneybdjtdepp77zjxf2qsv07yo5wdn','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2018-02-06 09:17:37'),('56q6a0lxxhfur1owwlljzbko1goemiw3','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2018-01-25 11:41:07'),('6cg1ym2w6mtx8llr9559ju1tf4spisyb','ZWU2ZDM0NzA0MTAyMGRiOThmM2QzY2YzZWYyOGU2OWM3NDhmY2VmMTp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjEiLCJfYXV0aF91c2VyX2hhc2giOiI1MDU5ZTU2ZjE1YjFkODIzYTcyYTA4ZTI4MjcxOWUwMmQ5MTMwNDQ2In0=','2017-10-04 11:54:01'),('7gxyyxnuvekkxocdwt4rtcs7nwrzt2rr','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-11-06 16:52:33'),('7ilwmye4083ae6vc28rlivbigttrj75m','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2017-12-20 10:32:00'),('8koioknn6zpku3qlrtl4c20go3krmseo','NGYwYWMxMzk0ZjkyNGE4YTU0MDExODQ5ZTQ2ZTk5M2IwOWZmMDQ0ZDp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=','2018-02-21 08:10:29'),('9roevw9vi1wm2u1nx7eibaz40ttc4din','NTE0YmJkZDIxYWFkNjdlMWFkYjdkZDYxM2Q0ZTFiODc5MzJmMDE2Njp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9oYXNoIjoiNTA1OWU1NmYxNWIxZDgyM2E3MmEwOGUyODI3MTllMDJkOTEzMDQ0NiIsIl9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIn0=',
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Temporary table structure for view `freespeechandsurvey`
--
DROP TABLE IF EXISTS `freespeechandsurvey`;
/*!50001 DROP VIEW IF EXISTS `freespeechandsurvey`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `freespeechandsurvey` (
`survey_id` tinyint NOT NULL,
`result_id` tinyint NOT NULL,
`submitted_at` tinyint NOT NULL,
`app_locale` tinyint NOT NULL,
`recording_filename` tinyint NOT NULL,
`theme` tinyint NOT NULL,
`language` tinyint NOT NULL,
`participant_latitude` tinyint NOT NULL,
`participant_longitude` tinyint NOT NULL,
`participant_area` tinyint NOT NULL,
`participant_country` tinyint NOT NULL,
`session_id` tinyint NOT NULL,
`survey_comment` tinyint NOT NULL,
`device_id` tinyint NOT NULL,
`platform` tinyint NOT NULL,
`question_1` tinyint NOT NULL,
`answer_1` tinyint NOT NULL,
`question_2` tinyint NOT NULL,
`answer_2` tinyint NOT NULL,
`question_3` tinyint NOT NULL,
`answer_3` tinyint NOT NULL,
`question_4` tinyint NOT NULL,
`answer_4` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Temporary table structure for view `picturegameandsurvey`
--
DROP TABLE IF EXISTS `picturegameandsurvey`;
/*!50001 DROP VIEW IF EXISTS `picturegameandsurvey`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `picturegameandsurvey` (
`survey_id` tinyint NOT NULL,
`result_id` tinyint NOT NULL,
`submitted_at` tinyint NOT NULL,
`app_locale` tinyint NOT NULL,
`picture` tinyint NOT NULL,
`recording_filename` tinyint NOT NULL,
`language` tinyint NOT NULL,
`participant_latitude` tinyint NOT NULL,
`participant_longitude` tinyint NOT NULL,
`participant_area` tinyint NOT NULL,
`participant_country` tinyint NOT NULL,
`session_id` tinyint NOT NULL,
`survey_comment` tinyint NOT NULL,
`device_id` tinyint NOT NULL,
`platform` tinyint NOT NULL,
`question_1` tinyint NOT NULL,
`answer_1` tinyint NOT NULL,
`question_2` tinyint NOT NULL,
`answer_2` tinyint NOT NULL,
`question_3` tinyint NOT NULL,
`answer_3` tinyint NOT NULL,
`question_4` tinyint NOT NULL,
`answer_4` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Current Database: `stimmenfryslan`
--
USE `stimmenfryslan`;
--
-- Final view structure for view `freespeechandsurvey`
--
/*!50001 DROP TABLE IF EXISTS `freespeechandsurvey`*/;
/*!50001 DROP VIEW IF EXISTS `freespeechandsurvey`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`stimmenfryslan`@`cosmo.service.rug.nl` SQL SECURITY DEFINER */
/*!50001 VIEW `freespeechandsurvey` AS select `sr`.`id` AS `survey_id`,`fsr`.`id` AS `result_id`,`fsr`.`submitted_at` AS `submitted_at`,`fsr`.`app_locale` AS `app_locale`,`fsr`.`recording` AS `recording_filename`,`fst`.`short_text` AS `theme`,`l`.`name` AS `language`,`sr`.`user_lat` AS `participant_latitude`,`sr`.`user_lng` AS `participant_longitude`,`sr`.`area_name` AS `participant_area`,`sr`.`country_name` AS `participant_country`,`fsr`.`session_id` AS `session_id`,`sr`.`comment` AS `survey_comment`,`sr`.`device_id` AS `device_id`,`sr`.`platform` AS `platform`,`q1`.`text` AS `question_1`,`a1`.`text` AS `answer_1`,`q2`.`text` AS `question_2`,`a2`.`text` AS `answer_2`,`q3`.`text` AS `question_3`,`a3`.`text` AS `answer_3`,`q4`.`text` AS `question_4`,`a4`.`text` AS `answer_4` from (((((((((((((((`core_freespeechresult` `fsr` left join `core_language` `l` on((`l`.`id` = `fsr`.`language_id`))) left join `core_freespeechtheme` `fst` on((`fst`.`id` = `fsr`.`speech_theme_id`))) left join `core_surveyresult` `sr` on((`sr`.`id` = `fsr`.`survey_result_id`))) left join `core_surveyresultquestionanswer` `qa1` on(((`qa1`.`survey_result_id` = `sr`.`id`) and (`qa1`.`question_id` = 7)))) left join `core_surveyquestion` `q1` on((`q1`.`id` = `qa1`.`question_id`))) left join `core_surveyanswer` `a1` on((`a1`.`id` = `qa1`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa2` on(((`qa2`.`survey_result_id` = `sr`.`id`) and (`qa2`.`question_id` = 8)))) left join `core_surveyquestion` `q2` on((`q2`.`id` = `qa2`.`question_id`))) left join `core_surveyanswer` `a2` on((`a2`.`id` = `qa2`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa3` on(((`qa3`.`survey_result_id` = `sr`.`id`) and (`qa3`.`question_id` = 10)))) left join `core_surveyquestion` `q3` on((`q3`.`id` = `qa3`.`question_id`))) left join `core_surveyanswer` `a3` on((`a3`.`id` = `qa3`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa4` on(((`qa4`.`survey_result_id` = `sr`.`id`) and (`qa4`.`question_id` = 11)))) left join `core_surveyquestion` `q4` on((`q4`.`id` = `qa4`.`question_id`))) left join `core_surveyanswer` `a4` on((`a4`.`id` = `qa4`.`answer_id`))) order by `sr`.`id`,`fsr`.`id` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `picturegameandsurvey`
--
/*!50001 DROP TABLE IF EXISTS `picturegameandsurvey`*/;
/*!50001 DROP VIEW IF EXISTS `picturegameandsurvey`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`stimmenfryslan`@`cosmo.service.rug.nl` SQL SECURITY DEFINER */
/*!50001 VIEW `picturegameandsurvey` AS select `sr`.`id` AS `survey_id`,`pgr`.`id` AS `result_id`,`pgr`.`submitted_at` AS `submitted_at`,`pgr`.`app_locale` AS `app_locale`,`pgi`.`name` AS `picture`,`pgr`.`recording` AS `recording_filename`,`l`.`name` AS `language`,`sr`.`user_lat` AS `participant_latitude`,`sr`.`user_lng` AS `participant_longitude`,`sr`.`area_name` AS `participant_area`,`sr`.`country_name` AS `participant_country`,`pgr`.`session_id` AS `session_id`,`sr`.`comment` AS `survey_comment`,`sr`.`device_id` AS `device_id`,`sr`.`platform` AS `platform`,`q1`.`text` AS `question_1`,`a1`.`text` AS `answer_1`,`q2`.`text` AS `question_2`,`a2`.`text` AS `answer_2`,`q3`.`text` AS `question_3`,`a3`.`text` AS `answer_3`,`q4`.`text` AS `question_4`,`a4`.`text` AS `answer_4` from (((((((((((((((`core_picturegameresult` `pgr` left join `core_language` `l` on((`l`.`id` = `pgr`.`language_id`))) left join `core_picturegameitem` `pgi` on((`pgi`.`id` = `pgr`.`picture_game_item_id`))) left join `core_surveyresult` `sr` on((`sr`.`id` = `pgr`.`survey_result_id`))) left join `core_surveyresultquestionanswer` `qa1` on(((`qa1`.`survey_result_id` = `sr`.`id`) and (`qa1`.`question_id` = 7)))) left join `core_surveyquestion` `q1` on((`q1`.`id` = `qa1`.`question_id`))) left join `core_surveyanswer` `a1` on((`a1`.`id` = `qa1`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa2` on(((`qa2`.`survey_result_id` = `sr`.`id`) and (`qa2`.`question_id` = 8)))) left join `core_surveyquestion` `q2` on((`q2`.`id` = `qa2`.`question_id`))) left join `core_surveyanswer` `a2` on((`a2`.`id` = `qa2`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa3` on(((`qa3`.`survey_result_id` = `sr`.`id`) and (`qa3`.`question_id` = 10)))) left join `core_surveyquestion` `q3` on((`q3`.`id` = `qa3`.`question_id`))) left join `core_surveyanswer` `a3` on((`a3`.`id` = `qa3`.`answer_id`))) left join `core_surveyresultquestionanswer` `qa4` on(((`qa4`.`survey_result_id` = `sr`.`id`) and (`qa4`.`question_id` = 11)))) left join `core_surveyquestion` `q4` on((`q4`.`id` = `qa4`.`question_id`))) left join `core_surveyanswer` `a4` on((`a4`.`id` = `qa4`.`answer_id`))) order by `sr`.`id`,`pgr`.`id` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!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 2018-08-14 15:20:05