7EsBRzC1

1-- MySQL dump 10.13  Distrib 5.7.13, for Linux (x86_64)
2--
3-- Host: localhost    Database: global_db
4-- ------------------------------------------------------
5-- Server version	5.7.13-0ubuntu0.16.04.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `demographics`
20--
21
22DROP TABLE IF EXISTS `demographics`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `demographics` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `name` varchar(50) NOT NULL,
28  `description` varchar(150) NOT NULL,
29  `group` varchar(20) NOT NULL,
30  `type` varchar(25) NOT NULL,
31  `options` text NOT NULL,
32  `msp_id` int(11) NOT NULL DEFAULT '0',
33  `admin_set` tinyint(4) NOT NULL DEFAULT '0',
34  `calculated` tinyint(1) NOT NULL,
35  `created` int(11) NOT NULL,
36  `updated` int(11) NOT NULL,
37  `deleted` int(11) NOT NULL,
38  `poll_report` tinyint(1) DEFAULT '0',
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `demographics`
45--
46
47LOCK TABLES `demographics` WRITE;
48/*!40000 ALTER TABLE `demographics` DISABLE KEYS */;
49INSERT INTO `demographics` VALUES (1,'MSPA Certification','MSPA Certification Level','Professional','select','None\r\nSilver\r\nGold',0,0,0,0,0,0,0),(2,'MSPA Certification #','MSPA Certification #','Professional','text','',0,0,0,0,0,0,0),(3,'Gender','Gender','Personal','select','Male\r\nFemale',0,0,0,0,0,0,0),(4,'Education','Education','Personal','select','Some High School\r\nHigh School Degree or GED\r\nJunior College\r\nCollege\r\nGraduate Degree\r\nPost Graduate Degree\r\nOther',0,0,0,0,1466712540,0,0),(5,'Driver\'s License #','Driver\'s License #','Personal','text','',0,0,0,0,0,0,0),(6,'iPhone','Own an iPhone','Equipment','boolean','',0,0,0,0,0,0,0),(7,'Chipolte Certified','Chipolte Certified','Private','boolean','',10,1,0,0,0,0,0),(8,'ABC Certified','ABC Certified','Private','boolean','',10,1,0,0,0,0,0),(9,'iSS 101','iSS 101 - Intro to iSecretShop','Certifications','boolean','',0,1,0,0,0,0,0),(10,'iSS 102','Using the iSecretShop iPhone App','Certifications','boolean','',0,1,0,0,0,0,0),(11,'Paypal Email','Paypal Email ','Personal','text','',0,0,0,0,1403626170,0,0),(12,'Payday Loan Certified','Payday Loan Certified','Private','boolean','',7,1,0,0,0,0,0),(13,'Android','Do you own an Android smartphone','Equipment','boolean','',0,0,0,0,0,0,0),(14,'Age','Shopper\'s Age','Personal','integer','',0,0,1,0,1377676800,0,0),(15,'Income Range','Select appropriate Income Range (Annual)','Personal','select','0 - 10k\r\n10k - 20k\r\n20k - 40k\r\n40k - 60k\r\n60k - 80k\r\n80k - 100k\r\n100k - 150k\r\n150k - 250k\r\n250k - 500k\r\nOver 500k',0,0,0,0,1390941065,0,0),(16,'Marital Status','Marital Status','Personal','select','Single\r\nMarried\r\nWidowed\r\nDivorced\r\nCommon-Law\r\nSeparated',0,0,0,0,1380300985,0,0),(17,'Occupation','Occupation','Personal','text','',0,0,0,0,0,0,0),(18,'Employer','Employer','Personal','text','',0,0,0,0,0,0,0),(19,'Spanish Speaking','Do you speak Spanish?','Language','boolean','',0,0,0,0,1390940964,0,0),(20,'French Speaking','Do you speak French?','Language','boolean','',0,0,0,0,1390940980,0,0),(21,'Portuguese Speaking','Do you speak Portuguese?','Language','boolean','',0,0,0,0,1390940976,0,0),(30,'client_90','Successfully completed a shop for client in the past 90 days','Certifications','boolean','',0,0,1,0,1403554612,0,0),(31,'client_180','Successfully completed a shop for client in the past 180 days','Certifications','boolean','',0,0,1,0,1403554612,0,0),(32,'Vehicles','What vehicles do you drive (check all that apply)?','Personal','check_all','Acura\r\nAudi\r\nBuick\r\nBMW\r\nCadillac\r\nChevrolet\r\nChrysler\r\nDodge\r\nFord\r\nGeneral Motors\r\nHonda\r\nHyundai\r\nInfiniti\r\nJeep\r\nKia\r\nLand Rover\r\nLexus\r\nLincoln\r\nMazda\r\nMercedes-Benz\r\nMercury\r\nMitsubishi\r\nNissan\r\nToyota \r\nVolvo\r\nOther\r\nNone',0,0,0,0,1450725448,0,0),(33,'Secondary Vehicle','Secondary Vehicle','Personal','select','Acura\r\nAudi\r\nBuick\r\nBMW\r\nCadillac\r\nChevrolet\r\nChrysler\r\nDodge\r\nFord\r\nGeneral Motors\r\nHonda\r\nHyundai\r\nInfiniti\r\nJeep\r\nKia\r\nLand Rover\r\nLexus\r\nLincoln\r\nMazda\r\nMercedes-Benz\r\nMercury\r\nMitsubishi\r\nNissan\r\nToyota \r\nVolvo\r\nOther\r\nNone',0,1,0,0,1445638228,1445583600,0),(34,'Bank','What banks do you have accounts with (do not abbreviate, separate with commas)?','Personal','check_all','Bank of American\r\nBank of Hawaii\r\nBanner Bank\r\nCharles Schwab Bank\r\nHawaiian\r\nWells Fargo\r\nWoodTrust Bank\r\nOther',0,0,0,0,1466540301,0,0),(44,'AARP Member','Are you an AARP Member?','Personal','boolean','',0,0,0,0,1422157531,0,0),(45,'Children','How many Children do you have under 12? (as a number)','Family','integer','',0,0,0,0,1422156864,0,0),(46,'QSI Employee','QSI Employee','Private','boolean','',10,1,0,0,0,0,0),(47,'Birthday','Date of Birth (Select the Year first)','Personal','timestamp','',0,0,0,0,1463601059,0,0),(49,'Race','Race','Personal','select','Caucasian/White\nAfrican American/Black\nAmerican Indian/Alaskan Native\nAsian\nHispanic/Latino\nHawaiian/Pacific Islander\nOther',0,0,0,0,1405953988,0,0),(50,'Private Investigator\'s License','Do you have Private Investigator\'s License?','Personal','boolean','',0,0,0,0,1407184195,0,0),(51,'Private Investigator\'s License #','Private Investigator\'s License Number is applicable.','Personal','text','',0,0,0,0,1407214354,0,0),(52,'Video Surveillance','Do you own *Hidden* Video Surveillance Equipment (aka a spy camera NOT a camcorder or smartphone)?','Equipment','boolean','',0,0,0,0,1448733054,0,0),(53,'Video Camera','Do you own a Video Camera?','Equipment','boolean','',0,0,0,0,1390940995,0,0),(55,'Paypal Required','Paypal Email Address On File','Personal','boolean','',0,0,1,0,1403626364,0,0),(56,'Secondary Bank','Secondary Bank','Personal','text','',0,1,0,0,1429463251,1414134000,0),(59,'Palm Beach Tan','Palm Beach Tan Certification','Certifications','boolean','',17,1,0,0,0,0,0),(60,'Radius Certified','Radius Certified','Private','boolean','',7,1,0,0,0,0,0),(61,'Medical Marijuana','Medical Marijuana Cardholder','Personal','boolean','',0,0,0,0,0,0,0),(62,'PPQ Unlimited','PPQ Approved Shopper - Unlimited Shops','Private','boolean','',22,1,0,0,0,0,0),(63,'USSFCU','Are you a member of the United States Senate Federal Credit Union (USSFCU)?','Personal','boolean','',0,0,0,0,1390940976,0,0),(64,'Bar Loss Prevention','Do you have specific Bar Loss Prevention Experience','Personal','boolean','',0,0,0,0,1422057600,0,0),(65,'Kitchen Experience','Do you have experience working in a commercial kitchen?','Personal','boolean','',0,0,0,0,1422057600,0,0),(66,'Hotel Experience','Do you have professional experience working as a hotel employee?','Personal','boolean','',0,0,0,0,1422296140,0,0),(67,'Airport Shopper','Are you able to mystery shop airports behind security?','Personal','boolean','',0,0,0,0,1428683722,0,0),(68,'ARCO Certified','ARCO Certified','Private','boolean','',10,1,0,0,1426723200,0,0),(69,'Video Certification MCP','Video Certification MCP','Private','boolean','',17,1,0,0,0,0,0),(70,'Household Income.','What is your household income (enter numbers only','Family','integer','',0,0,0,0,1437795264,0,0),(71,'Sentry Certified','Sentry Certified','Private','boolean','',10,1,0,0,0,0,0),(72,'Tablet','Do you own a tablet with an active data plan?  This is often required for onsite audits.','Equipment','boolean','',0,0,0,0,1442386800,0,0),(73,'Cell Phone Carrier','Primary Cell Plan Carrier','Personal','select','ATT\r\nVerizon\r\nT-Mobile\r\nSprint\r\nPre-Paid\r\nOther\r\nNo Cell Phone',0,0,0,0,1442386800,0,0),(74,'Cable Provider','Primary Cable (TV or Broadband) Provider','Personal','select','ATT\nComcast/Xfinity\nCablevision\nCenturyLink\nCharter Communication\nCox\nDirecTV\nDISH Network\nFrontier Communications\nGoogle Fiber\nQwest Communications\nTime Warner\nVerizon FiOS\nVIACOM\nOther\nNone\n',0,0,0,0,1453837672,0,0),(75,'Children 15-20','Do you have children 15-20 years old','Family','boolean','',0,0,0,0,1445567664,0,0),(76,'Pet Owner','Do you own a dog or cat?','Personal','boolean','',0,0,0,0,1448123829,0,0),(77,'Military','Are you or your spouse in the military?','Personal','boolean','',0,0,0,0,1445879740,0,0),(78,'Video Certification','Do you have any Video Shopping Certifications? If so, please check all that apply.','Professional','check_all','VSP\r\nIMSC\r\nMSPA\r\nNone',0,0,0,0,1453616993,0,0),(79,'Video Certification #','Enter all the Video Shopping Certification Numbers you have, i.e. \"MSPA #XXXXXXX\"','Professional','text','',0,0,0,0,1453670234,0,0),(80,'DA NV PI','Dynamic Advantage Nevada PI','Private','boolean','',35,1,0,0,1452095564,0,0),(81,'Mandarin Speaking','Do you speak Mandarin?','Language','boolean','',0,0,0,0,1454012980,0,0),(82,'Video Surveillance Equipment','If you own video surveillance equipment please provide the make and model','Equipment','text','',0,0,0,0,1457644634,0,0),(83,'Shake Shack Certified','Shake Shack Certified','Private','boolean','',10,1,0,0,0,0,0),(84,'Fine Dining - QSI','Fine Dining Certified - QSI','Private','boolean','',10,1,0,0,0,0,0),(85,'Demographic test','Demographic test','Personal','check_all','one\r\ntwo\r\nthree\r\nfour',0,0,0,1462664367,1462664385,1462664385,0),(86,'Dietary Preference(s) / Restriction(s)','Please select all your dietary preferences and/or restrictions','Personal','check_all','Carnivore\r\nVegan\r\nVegetarian\r\nOvo-Lacto Vegetarian\r\nPescatarian (fish but no meat)\r\nKosher\r\nHalal\r\nGluten-free/Intolerant\r\nNut Allergy\r\nKetogenic (low/no carb)\r\nOther: Please Explain',0,0,0,1462666534,1462666534,0,0),(87,'College Student or Alumni Status','Please select any college/university you are currently and/or previously enrolled in.','Personal','check_all','Other\r\nNot Applicable\r\nDaymar College',0,0,0,1463514328,1463717474,0,0),(88,'Tobacco Use','What types of tobacco-related products do you use?','Personal','check_all','None\r\nCigarettes\r\nPipe\r\nCigar\r\nSmokeless\r\nVape/eCig\r\n',0,0,0,1463673672,1463673672,0,0),(89,'Country','Country of Residence','Personal','text','',0,0,1,1463714269,1463714269,0,0),(90,'ID Verified','ID Verified','private','boolean','',18,1,0,0,0,0,0),(91,'Photo ID','Please upload a photo id','Personal','photo','',0,0,0,1474302047,1474302047,0,0);
50/*!40000 ALTER TABLE `demographics` ENABLE KEYS */;
51UNLOCK TABLES;
52/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
53
54/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
55/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
56/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
57/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
58/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
59/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
60/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
61
62-- Dump completed on 2016-10-11 12:09:51