-- MySQL dump 10.13  Distrib 5.5.29, for osx10.6 (i386)
--
-- Host: localhost    Database: pulso
-- ------------------------------------------------------
-- Server version	5.5.29-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


--
-- Table structure for table `participant_question_tbl`
--

DROP TABLE IF EXISTS `participant_question_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `participant_question_tbl` (
  `participant_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `question_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `sent_datetime` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maintains state of which questions have been sent to partici';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `participant_question_tbl`
--

LOCK TABLES `participant_question_tbl` WRITE;
/*!40000 ALTER TABLE `participant_question_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `participant_question_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `participant_survey_tbl`
--

DROP TABLE IF EXISTS `participant_survey_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `participant_survey_tbl` (
  `participant_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `survey_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `status` enum('pending','underway','completed') DEFAULT NULL,
  `current_question_id` mediumint(9) unsigned DEFAULT NULL,
  KEY `participant_id` (`participant_id`),
  KEY `survey_id` (`survey_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maintains state between participants and surveys so we know ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `participant_survey_tbl`
--

LOCK TABLES `participant_survey_tbl` WRITE;
/*!40000 ALTER TABLE `participant_survey_tbl` DISABLE KEYS */;
INSERT INTO `participant_survey_tbl` VALUES (1,1,'underway',4),(2,1,'completed',NULL),(3,1,'underway',NULL),(4,1,'underway',NULL),(5,1,'underway',NULL),(6,1,'underway',NULL),(7,1,'underway',NULL),(8,1,'underway',NULL),(9,1,'underway',NULL),(10,1,'underway',NULL),(11,1,'underway',NULL),(12,1,'underway',NULL),(13,1,'underway',NULL),(14,1,'underway',NULL),(15,1,'underway',NULL),(16,1,'underway',NULL),(17,1,'underway',NULL),(18,1,'underway',NULL),(19,1,'underway',NULL),(20,1,'underway',NULL),(21,1,'underway',NULL),(22,1,'underway',NULL),(23,1,'underway',NULL),(24,1,'underway',NULL),(25,1,'underway',NULL),(26,1,'underway',NULL),(27,1,'underway',NULL),(28,1,'underway',NULL),(29,1,'underway',NULL),(30,1,'underway',NULL),(31,1,'underway',NULL),(32,1,'underway',NULL),(33,1,'underway',NULL),(34,1,'underway',NULL),(35,1,'underway',NULL),(36,1,'underway',NULL),(37,1,'underway',NULL),(38,1,'underway',NULL),(39,1,'underway',NULL),(40,1,'underway',NULL),(41,1,'underway',NULL),(42,1,'underway',NULL),(43,1,'underway',NULL),(44,1,'underway',NULL),(45,1,'underway',NULL),(46,1,'underway',NULL),(47,1,'underway',NULL),(48,1,'underway',NULL),(49,1,'underway',NULL),(50,1,'underway',NULL),(51,1,'underway',NULL),(52,1,'underway',NULL),(53,1,'underway',NULL),(54,1,'underway',NULL),(55,1,'underway',NULL),(56,1,'underway',NULL),(57,1,'underway',NULL),(58,1,'underway',NULL),(59,1,'underway',NULL),(60,1,'underway',NULL),(61,1,'underway',NULL),(62,1,'underway',NULL),(63,1,'underway',NULL),(64,1,'underway',NULL),(65,1,'underway',NULL),(66,1,'underway',NULL),(67,1,'underway',NULL),(68,1,'underway',NULL),(69,1,'underway',NULL),(70,1,'underway',NULL),(71,1,'underway',NULL),(72,1,'underway',NULL),(73,1,'underway',NULL),(74,1,'underway',NULL),(75,1,'underway',NULL),(76,1,'underway',NULL),(77,1,'underway',NULL),(78,1,'underway',NULL),(79,1,'underway',NULL),(80,1,'underway',NULL),(81,1,'underway',NULL),(82,1,'underway',NULL),(83,1,'underway',NULL),(84,1,'underway',NULL),(85,1,'underway',NULL),(86,1,'underway',NULL),(87,1,'underway',NULL),(88,1,'underway',NULL),(89,1,'underway',NULL),(90,1,'underway',NULL),(91,1,'underway',NULL);
/*!40000 ALTER TABLE `participant_survey_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `participant_tbl`
--

DROP TABLE IF EXISTS `participant_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `participant_tbl` (
  `participant_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) NOT NULL DEFAULT '',
  `status` enum('unknown','active','inactive','opted out') DEFAULT NULL,
  `source` enum('web admin','imported','joined by sms') DEFAULT NULL,
  `last_active_datetime` datetime DEFAULT NULL,
  `added_datetime` datetime DEFAULT NULL,
  `added_by_user_id` smallint(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by_user_id` smallint(11) DEFAULT NULL,
  PRIMARY KEY (`participant_id`),
  KEY `phone` (`phone`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1 COMMENT='Primary participant table.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `participant_tbl`
--

LOCK TABLES `participant_tbl` WRITE;
/*!40000 ALTER TABLE `participant_tbl` DISABLE KEYS */;
INSERT INTO `participant_tbl` VALUES (1,'+5255919614399','active','web admin','2013-11-09 22:52:17','2013-11-09 21:48:46',2,'2013-11-10 15:32:47',1),(2,'+525545578290','active','web admin','2013-11-10 00:14:29','2013-11-09 22:55:12',2,NULL,NULL),(3,'+525591961410','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(4,'+525591961411','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(5,'+525591961412','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(6,'+525591961413','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(7,'+525591961414','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(8,'+525591961415','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(9,'+525591961416','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(10,'+525591961417','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(11,'+525591961418','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(12,'+525591961419','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(13,'+525591961420','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(14,'+525591961421','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(15,'+525591961422','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(16,'+525591961423','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(17,'+525591961424','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(18,'+525591961425','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(19,'+525591961426','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(20,'+525591961427','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(21,'+525591961428','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(22,'+525591961429','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(23,'+525591961430','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(24,'+525591961431','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(25,'+525591961432','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(26,'+525591961433','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(27,'+525591961434','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(28,'+525591961435','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(29,'+525591961436','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(30,'+525591961437','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(31,'+525591961438','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(32,'+525591961440','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(33,'+525591961441','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(34,'+525591961442','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(35,'+525591961443','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(36,'+525591961444','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(37,'+525591961445','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(38,'+525591961446','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(39,'+525591961447','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(40,'+525591961448','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(41,'+525591961449','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(42,'+525591961450','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(43,'+525591961451','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(44,'+525591961452','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(45,'+525591961453','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(46,'+525591961454','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(47,'+525591961455','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(48,'+525591961456','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(49,'+525591961457','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(50,'+525591961458','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(51,'+525591961459','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(52,'+525591961460','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(53,'+525591961461','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(54,'+525591961462','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(55,'+525591961463','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(56,'+525591961464','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(57,'+525591961465','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(58,'+525591961466','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(59,'+525591961467','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(60,'+525591961468','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(61,'+525591961469','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(62,'+525591961470','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(63,'+525591961471','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(64,'+525591961472','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(65,'+525591961473','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(66,'+525591961474','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(67,'+525591961475','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(68,'+525591961476','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(69,'+525591961477','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(70,'+525591961478','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(71,'+525591961479','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(72,'+525591961480','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(73,'+525591961481','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(74,'+525591961482','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(75,'+525591961483','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(76,'+525591961484','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(77,'+525591961485','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(78,'+525591961486','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(79,'+525591961487','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(80,'+525591961488','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(81,'+525591961489','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(82,'+525591961490','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(83,'+525591961491','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(84,'+525591961492','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(85,'+525591961493','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(86,'+525591961494','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(87,'+525591961495','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(88,'+525591961496','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(89,'+525591961497','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(90,'+525591961498','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL),(91,'+525591961499','unknown','imported',NULL,'2013-11-10 11:31:29',1,NULL,NULL);
/*!40000 ALTER TABLE `participant_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pref_tbl`
--

DROP TABLE IF EXISTS `pref_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pref_tbl` (
  `user_id` varchar(32) NOT NULL DEFAULT '',
  `pref_namespace` varchar(32) NOT NULL DEFAULT '',
  `pref_key` varchar(64) NOT NULL DEFAULT '',
  `pref_value` text,
  PRIMARY KEY (`user_id`,`pref_namespace`,`pref_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pref_tbl`
--

LOCK TABLES `pref_tbl` WRITE;
/*!40000 ALTER TABLE `pref_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `pref_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `question_action_tbl`
--

DROP TABLE IF EXISTS `question_action_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `question_action_tbl` (
  `question_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `question_option` varchar(255) NOT NULL DEFAULT '',
  `question_action` enum('continue','goto','end') DEFAULT NULL,
  `target_question_id` mediumint(9) unsigned DEFAULT NULL,
  PRIMARY KEY (`question_id`,`question_option`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Actions to perform for specified options of each answer.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `question_action_tbl`
--

LOCK TABLES `question_action_tbl` WRITE;
/*!40000 ALTER TABLE `question_action_tbl` DISABLE KEYS */;
INSERT INTO `question_action_tbl` VALUES (1,'b','end',NULL),(3,'a','goto',4),(3,'b','goto',5);
/*!40000 ALTER TABLE `question_action_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `question_tbl`
--

DROP TABLE IF EXISTS `question_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `question_tbl` (
  `question_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `survey_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `rank` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `question_text` varchar(255) NOT NULL DEFAULT '',
  `added_datetime` datetime DEFAULT NULL,
  `added_by_user_id` smallint(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by_user_id` smallint(11) DEFAULT NULL,
  PRIMARY KEY (`question_id`),
  KEY `question_text` (`question_text`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COMMENT='Primary question table.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `question_tbl`
--

LOCK TABLES `question_tbl` WRITE;
/*!40000 ALTER TABLE `question_tbl` DISABLE KEYS */;
INSERT INTO `question_tbl` VALUES (1,1,1,'Would you like to participate in this survey? A) Yes B) No\r\n','2013-11-09 20:30:22',2,'2013-11-10 15:23:00',2),(2,1,2,'Which ice cream flavors do you like? (choose one-or-more): A] Chocolate, B] Strawberry, C] Mint, D] Bacon','2013-11-09 20:30:42',2,'2013-11-10 15:23:03',2),(3,1,3,'Do you enjoy filling surveys? A) Yes B) No','2013-11-09 20:31:36',2,'2013-11-10 15:22:47',2),(4,1,4,'Oh? What exactly do you like about them?','2013-11-09 20:32:08',2,'2013-11-10 15:22:50',2),(5,1,5,'One final question: What did you dream last night?','2013-11-09 20:33:26',2,'2013-11-10 15:22:55',2);
/*!40000 ALTER TABLE `question_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `response_tbl`
--

DROP TABLE IF EXISTS `response_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `response_tbl` (
  `participant_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `question_id` mediumint(9) unsigned NOT NULL DEFAULT '0',
  `response` varchar(255) NOT NULL DEFAULT '',
  `response_parsed` varchar(255) NOT NULL DEFAULT '',
  `added_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`participant_id`,`question_id`),
  KEY `question_id` (`question_id`,`participant_id`),
  KEY `response` (`response`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table of received SMS survey responses.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `response_tbl`
--

LOCK TABLES `response_tbl` WRITE;
/*!40000 ALTER TABLE `response_tbl` DISABLE KEYS */;
INSERT INTO `response_tbl` VALUES (1,1,'B','Yes','2013-11-08 12:34:55'),(1,2,'C','Strawberry','2013-11-02 12:34:55'),(1,3,'A','No','2013-11-07 12:34:55'),(2,1,'B','Yes','2013-11-09 12:34:55'),(2,2,'B','Chocolate','2013-11-10 12:34:55'),(2,3,'B','Yes','2013-11-01 12:34:55'),(2,4,'Much.\r','Much.\r','2013-11-06 12:34:55'),(2,5,'Trenchant wombat much whistled.\r','Trenchant wombat much whistled.\r','2013-11-05 12:34:55'),(1,4,'More alongside jeepers.\r','More alongside jeepers.\r','2013-11-05 12:34:55'),(1,5,'Less much a one immensely teasing a some.\r','Less much a one immensely teasing a some.\r','2013-11-02 12:34:55'),(3,1,'B','No','2013-11-11 12:34:55'),(3,2,'D','Strawberry','2013-11-08 12:34:55'),(3,3,'A','Yes','2013-11-07 12:34:55'),(3,4,'Cracked.\r','Cracked.\r','2013-11-09 12:34:55'),(3,5,'Lemming interwove yet a froze.\r','Lemming interwove yet a froze.\r','2013-11-05 12:34:55'),(4,1,'B','Yes','2013-11-08 12:34:55'),(4,2,'A','Chocolate','2013-11-02 12:34:55'),(4,3,'A','Yes','2013-11-05 12:34:55'),(4,4,'Thus.\r','Thus.\r','2013-11-09 12:34:55'),(4,5,'Cockatoo incorrect but much petted extraordinarily measurably.\r','Cockatoo incorrect but much petted extraordinarily measurably.\r','2013-11-08 12:34:55'),(5,1,'A','No','2013-11-04 12:34:55'),(5,2,'A','Mint','2013-11-02 12:34:55'),(5,3,'B','No','2013-11-09 12:34:55'),(5,4,'Anonymous.\r','Anonymous.\r','2013-11-08 12:34:55'),(5,5,'Trenchant wombat much whistled.\r','Trenchant wombat much whistled.\r','2013-11-11 12:34:55'),(6,1,'A','No','2013-11-09 12:34:55'),(6,2,'A','Chocolate','2013-11-02 12:34:55'),(6,3,'B','Yes','2013-11-02 12:34:55'),(6,4,'Hence.\r','Hence.\r','2013-11-02 12:34:55'),(6,5,'Wistfully yikes quick as husky gosh without the.\r','Wistfully yikes quick as husky gosh without the.\r','2013-11-04 12:34:55'),(7,1,'B','Yes','2013-11-01 12:34:55'),(7,2,'A','Bacon','2013-11-05 12:34:55'),(7,3,'B','No','2013-11-11 12:34:55'),(7,4,'Jeez boastful.\r','Jeez boastful.\r','2013-11-07 12:34:55'),(7,5,'Softly as oh.\r','Softly as oh.\r','2013-11-02 12:34:55'),(8,1,'A','Yes','2013-11-06 12:34:55'),(8,2,'C','Chocolate','2013-11-04 12:34:55'),(8,3,'A','No','2013-11-01 12:34:55'),(8,4,'Habitually fit alas.\r','Habitually fit alas.\r','2013-11-04 12:34:55'),(8,5,'Trenchant wombat much whistled.\r','Trenchant wombat much whistled.\r','2013-11-03 12:34:55'),(9,1,'B','No','2013-11-04 12:34:55'),(9,2,'C','Strawberry','2013-11-08 12:34:55'),(9,3,'B','Yes','2013-11-09 12:34:55'),(9,4,'Saliently unnecessarily some.\r','Saliently unnecessarily some.\r','2013-11-08 12:34:55'),(9,5,'Weird octopus outdid oppressive showed and.\r','Weird octopus outdid oppressive showed and.\r','2013-11-11 12:34:55'),(10,1,'A','Yes','2013-11-01 12:34:55'),(10,2,'D','Mint','2013-11-02 12:34:55'),(10,3,'B','No','2013-11-07 12:34:55'),(10,4,'Crud.\r','Crud.\r','2013-11-09 12:34:55'),(10,5,'Modestly hello sardonic lighthearted.\r','Modestly hello sardonic lighthearted.\r','2013-11-10 12:34:55'),(11,1,'B','Yes','2013-11-05 12:34:55'),(11,2,'B','Bacon','2013-11-03 12:34:55'),(11,3,'B','No','2013-11-09 12:34:55'),(11,4,'Well darn beside.\r','Well darn beside.\r','2013-11-05 12:34:55'),(11,5,'Lorem ipsum dolor sit amet.\r','Lorem ipsum dolor sit amet.\r','2013-11-06 12:34:55'),(12,1,'B','Yes','2013-11-05 12:34:55'),(12,2,'D','Bacon','2013-11-04 12:34:55'),(12,3,'B','No','2013-11-03 12:34:55'),(12,4,'With bawled dear.\r','With bawled dear.\r','2013-11-05 12:34:55'),(12,5,'Lorem ipsum dolor sit amet.\r','Lorem ipsum dolor sit amet.\r','2013-11-06 12:34:55'),(13,1,'A','No','2013-11-11 12:34:55'),(13,2,'A','Strawberry','2013-11-07 12:34:55'),(13,3,'B','Yes','2013-11-09 12:34:55'),(13,4,'Some jeez gerbil.\r','Some jeez gerbil.\r','2013-11-06 12:34:55'),(13,5,'Inset this sheep by pure after much past.\r','Inset this sheep by pure after much past.\r','2013-11-02 12:34:55'),(14,1,'B','No','2013-11-09 12:34:55'),(14,2,'A','Bacon','2013-11-07 12:34:55'),(14,3,'B','Yes','2013-11-07 12:34:55'),(14,4,'Much across.\r','Much across.\r','2013-11-05 12:34:55'),(14,5,'Astride that from rat grimily.\r','Astride that from rat grimily.\r','2013-11-11 12:34:55'),(15,1,'A','Yes','2013-11-09 12:34:55'),(15,2,'D','Mint','2013-11-10 12:34:55'),(15,3,'B','No','2013-11-04 12:34:55'),(15,4,'A jeez.\r','A jeez.\r','2013-11-09 12:34:55'),(15,5,'Grimaced much impertinently and flattering among teasingly.\r','Grimaced much impertinently and flattering among teasingly.\r','2013-11-10 12:34:55'),(16,1,'B','Yes','2013-11-05 12:34:55'),(16,2,'A','Strawberry','2013-11-11 12:34:55'),(16,3,'A','No','2013-11-09 12:34:55'),(16,4,'But growled.\r','But growled.\r','2013-11-10 12:34:55'),(16,5,'Cringed much that and far stingily and oh.\r','Cringed much that and far stingily and oh.\r','2013-11-03 12:34:55'),(17,1,'B','Yes','2013-11-03 12:34:55'),(17,2,'A','Mint','2013-11-04 12:34:55'),(17,3,'B','Yes','2013-11-03 12:34:55'),(17,4,'Less one capybara.\r','Less one capybara.\r','2013-11-09 12:34:55'),(17,5,'Jeez dreamed far kookaburra preparatory so.\r','Jeez dreamed far kookaburra preparatory so.\r','2013-11-05 12:34:55'),(18,1,'A','No','2013-11-10 12:34:55'),(18,2,'A','Bacon','2013-11-03 12:34:55'),(18,3,'B','Yes','2013-11-02 12:34:55'),(18,4,'Gecko.\r','Gecko.\r','2013-11-11 12:34:55'),(18,5,'Duis aute irure dolor in reprehenderit in voluptate.\r','Duis aute irure dolor in reprehenderit in voluptate.\r','2013-11-07 12:34:55'),(19,1,'B','No','2013-11-02 12:34:55'),(19,2,'B','Chocolate','2013-11-10 12:34:55'),(19,3,'A','Yes','2013-11-11 12:34:55'),(19,4,'One.\r','One.\r','2013-11-04 12:34:55'),(19,5,'Yes, I do.\r','Yes, I do.\r','2013-11-05 12:34:55'),(20,1,'B','No','2013-11-11 12:34:55'),(20,2,'D','Mint','2013-11-10 12:34:55'),(20,3,'A','Yes','2013-11-05 12:34:55'),(20,4,'Blamelessly moth.\r','Blamelessly moth.\r','2013-11-07 12:34:55'),(20,5,'Redid intrepid indignantly one perceptible lusty off.\r','Redid intrepid indignantly one perceptible lusty off.\r','2013-11-07 12:34:55'),(21,1,'A','No','2013-11-05 12:34:55'),(21,2,'C','Chocolate','2013-11-10 12:34:55'),(21,3,'A','No','2013-11-06 12:34:55'),(21,4,'Between.\r','Between.\r','2013-11-09 12:34:55'),(21,5,'And into bandicoot the.\r','And into bandicoot the.\r','2013-11-07 12:34:55'),(22,1,'B','No','2013-11-06 12:34:55'),(22,2,'C','Strawberry','2013-11-06 12:34:55'),(22,3,'A','Yes','2013-11-04 12:34:55'),(22,4,'Darn less starkly.\r','Darn less starkly.\r','2013-11-02 12:34:55'),(22,5,'Rode grave salamander danced.\r','Rode grave salamander danced.\r','2013-11-05 12:34:55'),(23,1,'A','Yes','2013-11-06 12:34:55'),(23,2,'D','Chocolate','2013-11-07 12:34:55'),(23,3,'B','Yes','2013-11-06 12:34:55'),(23,4,'Hello redoubtably.\r','Hello redoubtably.\r','2013-11-06 12:34:55'),(23,5,'Thus well approvingly awesome.\r','Thus well approvingly awesome.\r','2013-11-01 12:34:55'),(24,1,'B','Yes','2013-11-08 12:34:55'),(24,2,'D','Strawberry','2013-11-07 12:34:55'),(24,3,'A','Yes','2013-11-07 12:34:55'),(24,4,'Less brought beguiling.\r','Less brought beguiling.\r','2013-11-06 12:34:55'),(24,5,'As hey between insistent grizzly.\r','As hey between insistent grizzly.\r','2013-11-07 12:34:55'),(25,1,'B','Yes','2013-11-07 12:34:55'),(25,2,'A','Mint','2013-11-10 12:34:55'),(25,3,'B','No','2013-11-10 12:34:55'),(25,4,'This darn.\r','This darn.\r','2013-11-10 12:34:55'),(25,5,'Swam some bestially.\r','Swam some bestially.\r','2013-11-07 12:34:55'),(26,1,'A','No','2013-11-04 12:34:55'),(26,2,'B','Chocolate','2013-11-08 12:34:55'),(26,3,'A','No','2013-11-07 12:34:55'),(26,4,'Yet removed.\r','Yet removed.\r','2013-11-11 12:34:55'),(26,5,'Shed far unihibitedly jeepers.\r','Shed far unihibitedly jeepers.\r','2013-11-10 12:34:55'),(27,1,'B','No','2013-11-10 12:34:55'),(27,2,'B','Strawberry','2013-11-06 12:34:55'),(27,3,'B','Yes','2013-11-08 12:34:55'),(27,4,'Yikes.\r','Yikes.\r','2013-11-04 12:34:55'),(27,5,'Brought and cumulatively a valiant as under without.\r','Brought and cumulatively a valiant as under without.\r','2013-11-03 12:34:55'),(28,1,'A','Yes','2013-11-02 12:34:55'),(28,2,'D','Bacon','2013-11-11 12:34:55'),(28,3,'B','No','2013-11-06 12:34:55'),(28,4,'Less rueful cogently.\r','Less rueful cogently.\r','2013-11-07 12:34:55'),(28,5,'And more fiendishly by weasel cockatoo.\r','And more fiendishly by weasel cockatoo.\r','2013-11-04 12:34:55'),(29,1,'B','Yes','2013-11-10 12:34:55'),(29,2,'B','Bacon','2013-11-08 12:34:55'),(29,3,'B','Yes','2013-11-09 12:34:55'),(29,4,'Poured.\r','Poured.\r','2013-11-11 12:34:55'),(29,5,'Blubbered yet much rabidly.\r','Blubbered yet much rabidly.\r','2013-11-05 12:34:55'),(30,1,'A','Yes','2013-11-03 12:34:55'),(30,2,'A','Bacon','2013-11-09 12:34:55'),(30,3,'B','Yes','2013-11-04 12:34:55'),(30,4,'Followed fumed.\r','Followed fumed.\r','2013-11-11 12:34:55'),(30,5,'Far partook outside.\r','Far partook outside.\r','2013-11-02 12:34:55'),(31,1,'B','No','2013-11-06 12:34:55'),(31,2,'A','Chocolate','2013-11-03 12:34:55'),(31,3,'A','No','2013-11-08 12:34:55'),(31,4,'Then smoothly.\r','Then smoothly.\r','2013-11-07 12:34:55'),(31,5,'Vulnerably however solicitous some abashedly hey peskily disagreed.\r','Vulnerably however solicitous some abashedly hey peskily disagreed.\r','2013-11-03 12:34:55'),(32,1,'A','No','2013-11-02 12:34:55'),(32,2,'A','Chocolate','2013-11-08 12:34:55'),(32,3,'A','No','2013-11-05 12:34:55'),(32,4,'Krill gnu.\r','Krill gnu.\r','2013-11-08 12:34:55'),(32,5,'Kindhearted shakily where exclusive excursively.\r','Kindhearted shakily where exclusive excursively.\r','2013-11-05 12:34:55'),(33,1,'B','No','2013-11-08 12:34:55'),(33,2,'A','Strawberry','2013-11-06 12:34:55'),(33,3,'A','No','2013-11-04 12:34:55'),(33,4,'Pangolin petulant flirted.\r','Pangolin petulant flirted.\r','2013-11-02 12:34:55'),(33,5,'Hey more swore.\r','Hey more swore.\r','2013-11-05 12:34:55'),(34,1,'B','No','2013-11-07 12:34:55'),(34,2,'A','Mint','2013-11-02 12:34:55'),(34,3,'A','No','2013-11-06 12:34:55'),(34,4,'Flipped more emu.\r','Flipped more emu.\r','2013-11-04 12:34:55'),(34,5,'Dear some militantly editorial much excluding frog.\r','Dear some militantly editorial much excluding frog.\r','2013-11-01 12:34:55'),(35,1,'A','Yes','2013-11-02 12:34:55'),(35,2,'A','Chocolate','2013-11-08 12:34:55'),(35,3,'A','Yes','2013-11-10 12:34:55'),(35,4,'Oh much.\r','Oh much.\r','2013-11-05 12:34:55'),(35,5,'Until thus hot capybara.\r','Until thus hot capybara.\r','2013-11-05 12:34:55'),(36,1,'A','No','2013-11-10 12:34:55'),(36,2,'D','Strawberry','2013-11-02 12:34:55'),(36,3,'B','Yes','2013-11-02 12:34:55'),(36,4,'Articulately dynamic.\r','Articulately dynamic.\r','2013-11-01 12:34:55'),(36,5,'Shark and bluebird and outside after childish.\r','Shark and bluebird and outside after childish.\r','2013-11-09 12:34:55'),(37,1,'A','Yes','2013-11-09 12:34:55'),(37,2,'C','Mint','2013-11-09 12:34:55'),(37,3,'A','No','2013-11-07 12:34:55'),(37,4,'Overcast.\r','Overcast.\r','2013-11-08 12:34:55'),(37,5,'Hello dog guardedly.\r','Hello dog guardedly.\r','2013-11-05 12:34:55'),(38,1,'A','No','2013-11-01 12:34:55'),(38,2,'D','Bacon','2013-11-10 12:34:55'),(38,3,'B','Yes','2013-11-03 12:34:55'),(38,4,'Vindictive unwound.\r','Vindictive unwound.\r','2013-11-08 12:34:55'),(38,5,'And let goldfinch irrational one much.\r','And let goldfinch irrational one much.\r','2013-11-08 12:34:55'),(39,1,'B','No','2013-11-05 12:34:55'),(39,2,'A','Strawberry','2013-11-10 12:34:55'),(39,3,'A','Yes','2013-11-05 12:34:55'),(39,4,'Affectionate spilled a.\r','Affectionate spilled a.\r','2013-11-04 12:34:55'),(39,5,'Promiscuous for far much.\r','Promiscuous for far much.\r','2013-11-03 12:34:55'),(40,1,'B','Yes','2013-11-11 12:34:55'),(40,2,'B','Mint','2013-11-06 12:34:55'),(40,3,'A','Yes','2013-11-05 12:34:55'),(40,4,'Because juggled consoled.\r','Because juggled consoled.\r','2013-11-05 12:34:55'),(40,5,'Crud hare locked industriously outside read one.\r','Crud hare locked industriously outside read one.\r','2013-11-10 12:34:55'),(41,1,'B','Yes','2013-11-03 12:34:55'),(41,2,'D','Chocolate','2013-11-07 12:34:55'),(41,3,'B','No','2013-11-03 12:34:55'),(41,4,'A.\r','A.\r','2013-11-04 12:34:55'),(41,5,'Serene so far less.\r','Serene so far less.\r','2013-11-09 12:34:55'),(42,1,'A','Yes','2013-11-02 12:34:55'),(42,2,'B','Mint','2013-11-04 12:34:55'),(42,3,'A','No','2013-11-02 12:34:55'),(42,4,'Pouted taught jeez.\r','Pouted taught jeez.\r','2013-11-05 12:34:55'),(42,5,'Consoled prissily that hoarse.\r','Consoled prissily that hoarse.\r','2013-11-10 12:34:55'),(43,1,'B','No','2013-11-02 12:34:55'),(43,2,'C','Mint','2013-11-08 12:34:55'),(43,3,'B','No','2013-11-04 12:34:55'),(43,4,'Goodness.\r','Goodness.\r','2013-11-06 12:34:55'),(43,5,'Cut greedy ignorantly.\r','Cut greedy ignorantly.\r','2013-11-04 12:34:55'),(44,1,'A','Yes','2013-11-04 12:34:55'),(44,2,'A','Bacon','2013-11-08 12:34:55'),(44,3,'B','Yes','2013-11-05 12:34:55'),(44,4,'Wow globefish spoke.\r','Wow globefish spoke.\r','2013-11-11 12:34:55'),(44,5,'Lemur one did alongside far split thin.\r','Lemur one did alongside far split thin.\r','2013-11-08 12:34:55'),(45,1,'A','No','2013-11-05 12:34:55'),(45,2,'B','Chocolate','2013-11-02 12:34:55'),(45,3,'B','Yes','2013-11-04 12:34:55'),(45,4,'Put much.\r','Put much.\r','2013-11-10 12:34:55'),(45,5,'Far placid but hello jeez.\r','Far placid but hello jeez.\r','2013-11-11 12:34:55'),(46,1,'A','No','2013-11-11 12:34:55'),(46,2,'D','Bacon','2013-11-02 12:34:55'),(46,3,'B','Yes','2013-11-04 12:34:55'),(46,4,'Goodness the monumentally.\r','Goodness the monumentally.\r','2013-11-05 12:34:55'),(46,5,'Wow ouch when opossum.\r','Wow ouch when opossum.\r','2013-11-11 12:34:55'),(47,1,'A','No','2013-11-08 12:34:55'),(47,2,'A','Strawberry','2013-11-09 12:34:55'),(47,3,'B','No','2013-11-08 12:34:55'),(47,4,'Far onto guiltily.\r','Far onto guiltily.\r','2013-11-04 12:34:55'),(47,5,'Manatee dolphin buffalo dauntless.\r','Manatee dolphin buffalo dauntless.\r','2013-11-05 12:34:55'),(48,1,'A','Yes','2013-11-02 12:34:55'),(48,2,'D','Bacon','2013-11-02 12:34:55'),(48,3,'B','No','2013-11-02 12:34:55'),(48,4,'Approving and.\r','Approving and.\r','2013-11-04 12:34:55'),(48,5,'As terrible far.\r','As terrible far.\r','2013-11-05 12:34:55'),(49,1,'B','Yes','2013-11-10 12:34:55'),(49,2,'B','Chocolate','2013-11-04 12:34:55'),(49,3,'B','No','2013-11-01 12:34:55'),(49,4,'Some banal droll.\r','Some banal droll.\r','2013-11-02 12:34:55'),(49,5,'Wow inexhaustible laudable far additional gosh.\r','Wow inexhaustible laudable far additional gosh.\r','2013-11-06 12:34:55'),(50,1,'A','No','2013-11-01 12:34:55'),(50,2,'D','Mint','2013-11-09 12:34:55'),(50,3,'A','No','2013-11-09 12:34:55'),(50,4,'Oh save.\r','Oh save.\r','2013-11-06 12:34:55'),(50,5,'One lantern shark besides dipped hello.\r','One lantern shark besides dipped hello.\r','2013-11-03 12:34:55'),(51,1,'B','Yes','2013-11-07 12:34:55'),(51,2,'C','Bacon','2013-11-03 12:34:55'),(51,3,'B','No','2013-11-02 12:34:55'),(51,4,'Salmon.\r','Salmon.\r','2013-11-02 12:34:55'),(51,5,'Unlike as chameleon but slovenly opposite as.\r','Unlike as chameleon but slovenly opposite as.\r','2013-11-02 12:34:55'),(52,1,'A','Yes','2013-11-02 12:34:55'),(52,2,'B','Chocolate','2013-11-04 12:34:55'),(52,3,'B','Yes','2013-11-02 12:34:55'),(52,4,'Far wow.\r','Far wow.\r','2013-11-10 12:34:55'),(52,5,'Disrespectful notable much crud yet less factiously.\r','Disrespectful notable much crud yet less factiously.\r','2013-11-10 12:34:55'),(53,1,'A','Yes','2013-11-10 12:34:55'),(53,2,'A','Bacon','2013-11-09 12:34:55'),(53,3,'A','Yes','2013-11-05 12:34:55'),(53,4,'Haltered.\r','Haltered.\r','2013-11-05 12:34:55'),(53,5,'Unproductive yikes crud.\r','Unproductive yikes crud.\r','2013-11-10 12:34:55'),(54,1,'B','Yes','2013-11-05 12:34:55'),(54,2,'B','Strawberry','2013-11-03 12:34:55'),(54,3,'A','No','2013-11-08 12:34:55'),(54,4,'Grasshopper.\r','Grasshopper.\r','2013-11-03 12:34:55'),(54,5,'Toucan at far this therefore irresistibly where a.\r','Toucan at far this therefore irresistibly where a.\r','2013-11-08 12:34:55'),(55,1,'A','Yes','2013-11-09 12:34:55'),(55,2,'A','Chocolate','2013-11-02 12:34:55'),(55,3,'B','No','2013-11-11 12:34:55'),(55,4,'Overpaid yikes.\r','Overpaid yikes.\r','2013-11-07 12:34:55'),(55,5,'This a and reflectively guinea burned glibly.\r','This a and reflectively guinea burned glibly.\r','2013-11-02 12:34:55'),(56,1,'B','Yes','2013-11-06 12:34:55'),(56,2,'A','Strawberry','2013-11-05 12:34:55'),(56,3,'B','No','2013-11-07 12:34:55'),(56,4,'That classic.\r','That classic.\r','2013-11-07 12:34:55'),(56,5,'Forewent regardless adequately hello far jeepers less circa.\r','Forewent regardless adequately hello far jeepers less circa.\r','2013-11-03 12:34:55'),(57,1,'A','No','2013-11-03 12:34:55'),(57,2,'D','Strawberry','2013-11-04 12:34:55'),(57,3,'B','Yes','2013-11-03 12:34:55'),(57,4,'Darn mallard.\r','Darn mallard.\r','2013-11-11 12:34:55'),(57,5,'Cobra but up far.\r','Cobra but up far.\r','2013-11-04 12:34:55'),(58,1,'A','No','2013-11-07 12:34:55'),(58,2,'C','Chocolate','2013-11-02 12:34:55'),(58,3,'B','No','2013-11-07 12:34:55'),(58,4,'Archly a.\r','Archly a.\r','2013-11-08 12:34:55'),(58,5,'Less less thinly much more so sulky fraternal.\r','Less less thinly much more so sulky fraternal.\r','2013-11-08 12:34:55'),(59,1,'A','No','2013-11-04 12:34:55'),(59,2,'B','Strawberry','2013-11-06 12:34:55'),(59,3,'B','No','2013-11-08 12:34:55'),(59,4,'Patted less.\r','Patted less.\r','2013-11-02 12:34:55'),(59,5,'The overcast before one toward far more that.\r','The overcast before one toward far more that.\r','2013-11-04 12:34:55'),(60,1,'A','No','2013-11-02 12:34:55'),(60,2,'B','Mint','2013-11-09 12:34:55'),(60,3,'B','Yes','2013-11-06 12:34:55'),(60,4,'Shook much.\r','Shook much.\r','2013-11-05 12:34:55'),(60,5,'Much via classic because.\r','Much via classic because.\r','2013-11-03 12:34:55'),(61,1,'B','No','2013-11-09 12:34:55'),(61,2,'C','Bacon','2013-11-05 12:34:55'),(61,3,'A','No','2013-11-09 12:34:55'),(61,4,'When purely.\r','When purely.\r','2013-11-08 12:34:55'),(61,5,'Hey far a instead this.\r','Hey far a instead this.\r','2013-11-02 12:34:55'),(62,1,'A','Yes','2013-11-04 12:34:55'),(62,2,'C','Bacon','2013-11-04 12:34:55'),(62,3,'A','No','2013-11-08 12:34:55'),(62,4,'Less wore gosh.\r','Less wore gosh.\r','2013-11-07 12:34:55'),(62,5,'Disagreed more got thankfully swore earthworm preparatory darn.\r','Disagreed more got thankfully swore earthworm preparatory darn.\r','2013-11-01 12:34:55'),(63,1,'B','Yes','2013-11-03 12:34:55'),(63,2,'A','Chocolate','2013-11-09 12:34:55'),(63,3,'A','No','2013-11-08 12:34:55'),(63,4,'More.\r','More.\r','2013-11-09 12:34:55'),(63,5,'Tiger furious much the without much yet.\r','Tiger furious much the without much yet.\r','2013-11-02 12:34:55'),(64,1,'B','No','2013-11-03 12:34:55'),(64,2,'D','Bacon','2013-11-08 12:34:55'),(64,3,'A','Yes','2013-11-09 12:34:55'),(64,4,'A alas.\r','A alas.\r','2013-11-09 12:34:55'),(64,5,'Via extraordinary tiger stuffy romantic behind goodness strangely.\r','Via extraordinary tiger stuffy romantic behind goodness strangely.\r','2013-11-09 12:34:55'),(65,1,'A','No','2013-11-08 12:34:55'),(65,2,'A','Mint','2013-11-11 12:34:55'),(65,3,'B','Yes','2013-11-08 12:34:55'),(65,4,'More some.\r','More some.\r','2013-11-08 12:34:55'),(65,5,'Beneath poured more.\r','Beneath poured more.\r','2013-11-05 12:34:55'),(66,1,'A','Yes','2013-11-10 12:34:55'),(66,2,'D','Mint','2013-11-05 12:34:55'),(66,3,'B','Yes','2013-11-03 12:34:55'),(66,4,'Bluebird.\r','Bluebird.\r','2013-11-09 12:34:55'),(66,5,'Far between much some when.\r','Far between much some when.\r','2013-11-07 12:34:55'),(67,1,'A','No','2013-11-04 12:34:55'),(67,2,'C','Bacon','2013-11-10 12:34:55'),(67,3,'B','Yes','2013-11-09 12:34:55'),(67,4,'Unaccountably.\r','Unaccountably.\r','2013-11-10 12:34:55'),(67,5,'Dependently and wherever hey folded due crud.\r','Dependently and wherever hey folded due crud.\r','2013-11-05 12:34:55'),(68,1,'A','Yes','2013-11-01 12:34:55'),(68,2,'A','Mint','2013-11-02 12:34:55'),(68,3,'A','Yes','2013-11-05 12:34:55'),(68,4,'Thus more wherever.\r','Thus more wherever.\r','2013-11-09 12:34:55'),(68,5,'Rolled in one.\r','Rolled in one.\r','2013-11-09 12:34:55'),(69,1,'B','Yes','2013-11-05 12:34:55'),(69,2,'C','Chocolate','2013-11-08 12:34:55'),(69,3,'A','No','2013-11-03 12:34:55'),(69,4,'Jellyfish wow limpet.\r','Jellyfish wow limpet.\r','2013-11-01 12:34:55'),(69,5,'Hooted wow queer then much.\r','Hooted wow queer then much.\r','2013-11-06 12:34:55'),(70,1,'A','No','2013-11-06 12:34:55'),(70,2,'D','Bacon','2013-11-02 12:34:55'),(70,3,'B','No','2013-11-08 12:34:55'),(70,4,'Groaned a.\r','Groaned a.\r','2013-11-05 12:34:55'),(70,5,'Yikes overslept far and less childish.\r','Yikes overslept far and less childish.\r','2013-11-09 12:34:55'),(71,1,'A','No','2013-11-09 12:34:55'),(71,2,'B','Mint','2013-11-06 12:34:55'),(71,3,'A','Yes','2013-11-02 12:34:55'),(71,4,'Supreme.\r','Supreme.\r','2013-11-03 12:34:55'),(71,5,'Extraordinary witty well as pointed.\r','Extraordinary witty well as pointed.\r','2013-11-05 12:34:55'),(72,1,'A','No','2013-11-08 12:34:55'),(72,2,'A','Strawberry','2013-11-05 12:34:55'),(72,3,'B','Yes','2013-11-07 12:34:55'),(72,4,'Forward.\r','Forward.\r','2013-11-08 12:34:55'),(72,5,'Less one that cowered far vague walrus this.\r','Less one that cowered far vague walrus this.\r','2013-11-10 12:34:55'),(73,1,'B','Yes','2013-11-05 12:34:55'),(73,2,'C','Strawberry','2013-11-04 12:34:55'),(73,3,'A','No','2013-11-04 12:34:55'),(73,4,'Lugubrious much.\r','Lugubrious much.\r','2013-11-07 12:34:55'),(73,5,'On immediately grizzly less meticulously.\r','On immediately grizzly less meticulously.\r','2013-11-11 12:34:55'),(74,1,'B','Yes','2013-11-03 12:34:55'),(74,2,'A','Mint','2013-11-11 12:34:55'),(74,3,'B','Yes','2013-11-05 12:34:55'),(74,4,'Darn much.\r','Darn much.\r','2013-11-10 12:34:55'),(74,5,'Held much house gosh studiedly.\r','Held much house gosh studiedly.\r','2013-11-03 12:34:55'),(75,1,'B','Yes','2013-11-05 12:34:55'),(75,2,'C','Strawberry','2013-11-03 12:34:55'),(75,3,'A','No','2013-11-02 12:34:55'),(75,4,'Portentously slovene before.\r','Portentously slovene before.\r','2013-11-08 12:34:55'),(75,5,'Smirked ferret far equivalently far less some.\r','Smirked ferret far equivalently far less some.\r','2013-11-05 12:34:55'),(76,1,'B','Yes','2013-11-11 12:34:55'),(76,2,'D','Mint','2013-11-07 12:34:55'),(76,3,'A','Yes','2013-11-02 12:34:55'),(76,4,'Irrespective archaic less.\r','Irrespective archaic less.\r','2013-11-06 12:34:55'),(76,5,'That in so more and one despite.\r','That in so more and one despite.\r','2013-11-02 12:34:55'),(77,1,'A','No','2013-11-03 12:34:55'),(77,2,'A','Bacon','2013-11-06 12:34:55'),(77,3,'A','No','2013-11-02 12:34:55'),(77,4,'Much.\r','Much.\r','2013-11-02 12:34:55'),(77,5,'Mannishly off less oh then and upheld.\r','Mannishly off less oh then and upheld.\r','2013-11-01 12:34:55'),(78,1,'B','No','2013-11-09 12:34:55'),(78,2,'D','Chocolate','2013-11-02 12:34:55'),(78,3,'A','Yes','2013-11-02 12:34:55'),(78,4,'That.\r','That.\r','2013-11-02 12:34:55'),(78,5,'With less truly snootily.\r','With less truly snootily.\r','2013-11-03 12:34:55'),(79,1,'B','Yes','2013-11-06 12:34:55'),(79,2,'A','Strawberry','2013-11-03 12:34:55'),(79,3,'A','No','2013-11-04 12:34:55'),(79,4,'Mallard.\r','Mallard.\r','2013-11-10 12:34:55'),(79,5,'Sobbing so grumbled coherent.\r','Sobbing so grumbled coherent.\r','2013-11-09 12:34:55'),(80,1,'B','No','2013-11-02 12:34:55'),(80,2,'C','Bacon','2013-11-04 12:34:55'),(80,3,'A','No','2013-11-02 12:34:55'),(80,4,'Vulture.\r','Vulture.\r','2013-11-09 12:34:55'),(80,5,'Opposite barring oyster wetted instead armadillo hey up.\r','Opposite barring oyster wetted instead armadillo hey up.\r','2013-11-06 12:34:55'),(81,1,'A','No','2013-11-02 12:34:55'),(81,2,'D','Mint','2013-11-11 12:34:55'),(81,3,'B','Yes','2013-11-06 12:34:55'),(81,4,'Piranha less gosh.\r','Piranha less gosh.\r','2013-11-09 12:34:55'),(81,5,'One cobra some.\r','One cobra some.\r','2013-11-07 12:34:55'),(82,1,'A','Yes','2013-11-06 12:34:55'),(82,2,'D','Chocolate','2013-11-07 12:34:55'),(82,3,'A','Yes','2013-11-06 12:34:55'),(82,4,'Less.\r','Less.\r','2013-11-08 12:34:55'),(82,5,'Rolled impeccably pangolin inside.\r','Rolled impeccably pangolin inside.\r','2013-11-11 12:34:55'),(83,1,'B','No','2013-11-09 12:34:55'),(83,2,'A','Chocolate','2013-11-02 12:34:55'),(83,3,'B','No','2013-11-03 12:34:55'),(83,4,'Wherever much irresolute.\r','Wherever much irresolute.\r','2013-11-06 12:34:55'),(83,5,'Gosh darn far.\r','Gosh darn far.\r','2013-11-02 12:34:55'),(84,1,'B','Yes','2013-11-01 12:34:55'),(84,2,'B','Strawberry','2013-11-09 12:34:55'),(84,3,'B','Yes','2013-11-08 12:34:55'),(84,4,'One a.\r','One a.\r','2013-11-03 12:34:55'),(84,5,'Reluctantly after tangible revealed roadrunner furtively threw.\r','Reluctantly after tangible revealed roadrunner furtively threw.\r','2013-11-01 12:34:55'),(85,1,'B','No','2013-11-05 12:34:55'),(85,2,'B','Mint','2013-11-10 12:34:55'),(85,3,'A','Yes','2013-11-06 12:34:55'),(85,4,'Together slid.\r','Together slid.\r','2013-11-06 12:34:55'),(85,5,'More some save oh.\r','More some save oh.\r','2013-11-02 12:34:55'),(86,1,'A','No','2013-11-03 12:34:55'),(86,2,'C','Bacon','2013-11-06 12:34:55'),(86,3,'A','No','2013-11-02 12:34:55'),(86,4,'Via.\r','Via.\r','2013-11-08 12:34:55'),(86,5,'Sexy after much jeepers much yikes.\r','Sexy after much jeepers much yikes.\r','2013-11-06 12:34:55'),(87,1,'B','Yes','2013-11-03 12:34:55'),(87,2,'D','Bacon','2013-11-08 12:34:55'),(87,3,'B','Yes','2013-11-09 12:34:55'),(87,4,'Fragrant.\r','Fragrant.\r','2013-11-02 12:34:55'),(87,5,'Goodness under magnificently innocently far that before.\r','Goodness under magnificently innocently far that before.\r','2013-11-10 12:34:55'),(88,1,'A','No','2013-11-03 12:34:55'),(88,2,'A','Strawberry','2013-11-04 12:34:55'),(88,3,'B','No','2013-11-08 12:34:55'),(88,4,'Airily thoroughly bore.\r','Airily thoroughly bore.\r','2013-11-10 12:34:55'),(88,5,'Much providently more beside.\r','Much providently more beside.\r','2013-11-02 12:34:55'),(89,1,'A','No','2013-11-10 12:34:55'),(89,2,'D','Bacon','2013-11-05 12:34:55'),(89,3,'A','Yes','2013-11-03 12:34:55'),(89,4,'And.\r','And.\r','2013-11-07 12:34:55'),(89,5,'Frog manfully wrote on overcast tidily naked hoggish.\r','Frog manfully wrote on overcast tidily naked hoggish.\r','2013-11-06 12:34:55'),(90,1,'A','No','2013-11-07 12:34:55'),(90,2,'D','Chocolate','2013-11-08 12:34:55'),(90,3,'B','Yes','2013-11-07 12:34:55'),(90,4,'The manta jeepers.\r','The manta jeepers.\r','2013-11-09 12:34:55'),(90,5,'Boyishly wallaby ouch unlike hyena rampant.\r','Boyishly wallaby ouch unlike hyena rampant.\r','2013-11-03 12:34:55'),(91,1,'B','No','2013-11-10 12:34:55'),(91,2,'C','Mint','2013-11-06 12:34:55'),(91,3,'A','Yes','2013-11-02 12:34:55'),(91,4,'Censorious however sped.\r','Censorious however sped.\r','2013-11-10 12:34:55'),(91,5,'One when less knew manfully much.\r','One when less knew manfully much.\r','2013-11-02 12:34:55');
/*!40000 ALTER TABLE `response_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `survey_tbl`
--

DROP TABLE IF EXISTS `survey_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey_tbl` (
  `survey_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `survey_name` varchar(255) NOT NULL DEFAULT '',
  `begin_datetime` datetime DEFAULT NULL,
  `status` enum('queued','underway','closed') DEFAULT NULL,
  `added_datetime` datetime DEFAULT NULL,
  `added_by_user_id` smallint(11) DEFAULT NULL,
  `modified_datetime` datetime DEFAULT NULL,
  `modified_by_user_id` smallint(11) DEFAULT NULL,
  PRIMARY KEY (`survey_id`),
  KEY `survey_name` (`survey_name`),
  KEY `begin_datetime` (`begin_datetime`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Primary survey table.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `survey_tbl`
--

LOCK TABLES `survey_tbl` WRITE;
/*!40000 ALTER TABLE `survey_tbl` DISABLE KEYS */;
INSERT INTO `survey_tbl` VALUES (1,'Hackathon','2013-11-09 21:38:51','underway','2013-11-09 20:29:34',2,NULL,NULL),(2,'Survey Two','2013-11-21 00:00:00','queued','2013-11-10 14:40:35',2,'2013-11-10 15:30:22',1),(3,'A third survey','2013-12-13 00:00:00','queued','2013-11-10 14:40:43',2,NULL,NULL);
/*!40000 ALTER TABLE `survey_tbl` ENABLE KEYS */;
UNLOCK TABLES;


/*!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 2013-11-10 15:42:19
