· 10 years ago · May 14, 2016, 05:12 PM
1-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: encuestas2014
4-- ------------------------------------------------------
5-- Server version 5.5.31-0+wheezy1
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 `lime_answers`
20--
21
22DROP TABLE IF EXISTS `lime_answers`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `lime_answers` (
26 `qid` int(11) NOT NULL DEFAULT '0',
27 `code` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
28 `answer` text COLLATE utf8_unicode_ci NOT NULL,
29 `sortorder` int(11) NOT NULL,
30 `assessment_value` int(11) NOT NULL DEFAULT '0',
31 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
32 `scale_id` int(11) NOT NULL DEFAULT '0',
33 PRIMARY KEY (`qid`,`code`,`language`,`scale_id`),
34 KEY `answers_idx2` (`sortorder`)
35) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `lime_answers`
40--
41
42LOCK TABLES `lime_answers` WRITE;
43/*!40000 ALTER TABLE `lime_answers` DISABLE KEYS */;
44INSERT INTO `lime_answers` VALUES (1,'A1','Para consultar los planes de contratación',1,0,'es',0),(1,'A2','Para inscribirse en algún proceso de contratación ',2,1,'es',0),(1,'A3','Para consultar información de procesos vigentes',3,1,'es',0),(1,'A4','Para conocer la adjudicación de contratos',4,1,'es',0),(1,'A5','Para consultar procesos de contratación realizados ',5,1,'es',0),(1,'A99','NS/NR',6,1,'es',0),(2,'1','Mala',5,1,'es',0),(2,'2','Regular',4,1,'es',0),(2,'3','Buena',3,1,'es',0),(2,'4','Muy Buena',2,1,'es',0),(2,'5','Excelente',1,1,'es',0),(2,'99','NS/NR',6,1,'es',0),(3,'1','Totalmente en desacuerdo',5,1,'es',0),(3,'2','Desacuerdo',4,1,'es',0),(3,'3','Ni de acuerdo/ Ni en desacuerdo',3,1,'es',0),(3,'4','De acuerdo',2,1,'es',0),(3,'5','Totalmente de acuerdo',1,1,'es',0),(3,'99','NS/NR',6,1,'es',0),(4,'1','Si',1,1,'es',0),(4,'2','No',2,1,'es',0),(6,'1','Más de una vez por semana',1,1,'es',0),(6,'2','Una vez por semana',2,1,'es',0),(6,'3','Una o dos veces al mes',3,1,'es',0),(6,'4','Una o dos veces cada trimestre',4,1,'es',0),(6,'5','Una o dos veces cada semestre',5,1,'es',0),(6,'6','Rara vez',6,1,'es',0),(6,'7','Nunca',7,1,'es',0),(9,'1','0',1,1,'es',0),(9,'2','1',2,1,'es',0),(9,'3','2',3,1,'es',0),(9,'4','3',4,1,'es',0),(9,'5','4',5,1,'es',0),(9,'6','5',6,1,'es',0),(9,'7','6',7,1,'es',0),(9,'8','Ns/Nr',8,1,'es',0),(10,'1','Soltero',1,1,'es',0),(10,'2','Casado/ Unión Libre',2,1,'es',0),(10,'3','Separado/ Divorciado',3,1,'es',0),(10,'4','Viudo',4,1,'es',0),(11,'1','Empleado',1,1,'es',0),(11,'2','Estudiante',2,1,'es',0),(11,'3','Empleado / Estudiante',3,1,'es',0),(11,'4','Desempleado',4,1,'es',0),(11,'5','Pensionado',5,1,'es',0),(11,'6','Ama de Casa',6,1,'es',0),(11,'7','Independiente',7,1,'es',0),(11,'8','No responde',8,1,'es',0),(12,'1','Primaria',1,1,'es',0),(12,'2','Bachillerato',2,1,'es',0),(12,'3','Técnico/ Tecnólogo',3,1,'es',0),(12,'4','Universitario',4,1,'es',0),(12,'5','Posgrado',5,1,'es',0),(12,'6','Ninguno',6,1,'es',0),(12,'7','No responde',7,1,'es',0),(13,'1','Femenino',1,1,'es',0),(13,'2','Masculino',2,1,'es',0),(13,'3','Otro',3,1,'es',0),(41,'6','NS/NR',6,1,'es',0),(41,'5','Mala',5,1,'es',0),(41,'4','Regular',4,1,'es',0),(41,'3','Buena',3,1,'es',0),(41,'2','Muy Buena',2,1,'es',0),(41,'1','Excelente',1,1,'es',0),(42,'1','Excelente',1,1,'es',0),(42,'2','Muy Buena',2,1,'es',0),(42,'3','Buena',3,1,'es',0),(42,'4','Regular',4,1,'es',0),(42,'5','Mala',5,1,'es',0),(42,'6','NS/NR',6,1,'es',0),(42,'7','No Aplica',7,1,'es',0),(52,'1','Excelente',1,1,'es',0),(52,'2','Muy buena',2,1,'es',0),(52,'3','Buena',3,1,'es',0),(52,'4','Regular',4,1,'es',0),(52,'5','Mala',5,1,'es',0),(52,'6','Ns/Nr',6,1,'es',0),(59,'6','NS/NR',6,1,'es',0),(59,'5','Mala',5,1,'es',0),(59,'4','Regular',4,1,'es',0),(59,'3','Buena',3,1,'es',0),(59,'2','Muy Buena',2,1,'es',0),(59,'1','Excelente',1,1,'es',0),(59,'7','No Aplica',7,1,'es',0),(65,'6','Ocio',6,1,'es',0),(65,'5','GastronomÃa',5,1,'es',0),(65,'4','Deportes',4,1,'es',0),(65,'3','Cultura',3,1,'es',0),(65,'2','Eventos',2,1,'es',0),(65,'1','Temáticas especÃficas de Bogotá',1,1,'es',0),(65,'7','Otra, ¿Cuál?',7,1,'es',0),(67,'1','0',1,1,'es',0),(67,'2','1',2,1,'es',0),(67,'3','2',3,1,'es',0),(67,'4','3',4,1,'es',0),(67,'5','4',5,1,'es',0),(67,'6','5',6,1,'es',0),(67,'7','6',7,1,'es',0),(67,'8','Ns/Nr',8,1,'es',0),(68,'1','Soltero',1,1,'es',0),(68,'2','Casado/ Unión Libre',2,1,'es',0),(68,'3','Separado/ Divorciado',3,1,'es',0),(68,'4','Viudo',4,1,'es',0),(69,'1','Empleado',1,1,'es',0),(69,'2','Estudiante',2,1,'es',0),(69,'3','Empleado / Estudiante',3,1,'es',0),(69,'4','Desempleado',4,1,'es',0),(69,'5','Pensionado',5,1,'es',0),(69,'6','Ama de Casa',6,1,'es',0),(69,'7','Independiente',7,1,'es',0),(69,'8','No responde',8,1,'es',0),(70,'1','Primaria',1,1,'es',0),(70,'2','Bachillerato',2,1,'es',0),(70,'3','Técnico/ Tecnólogo',3,1,'es',0),(70,'4','Universitario',4,1,'es',0),(70,'5','Posgrado',5,1,'es',0),(70,'6','Ninguno',6,1,'es',0),(70,'7','No responde',7,1,'es',0),(72,'1','Antonio Nariño',1,1,'es',0),(72,'2','Barrios Unidos',2,1,'es',0),(72,'3','Bosa',3,1,'es',0),(72,'4','Chapinero',4,1,'es',0),(72,'5','Ciudad BolÃvar',5,1,'es',0),(72,'6','Engativá',6,1,'es',0),(72,'7','Fontibón',7,1,'es',0),(72,'8','Kennedy',8,1,'es',0),(72,'9','La Candelaria',9,1,'es',0),(72,'10','Los Mártires',10,1,'es',0),(72,'11','Puente Aranda',11,1,'es',0),(72,'12','Rafael Uribe Uribe',12,1,'es',0),(72,'13','San Cristóbal',13,1,'es',0),(72,'14','Santa Fe',14,1,'es',0),(72,'15','Suba',15,1,'es',0),(72,'16','Sumapaz',16,1,'es',0),(72,'17','Teusaquillo',17,1,'es',0),(72,'18','Tunjuelito',18,1,'es',0),(72,'19','Usaquén',19,1,'es',0),(72,'20','Usme',20,1,'es',0),(40,'1','Si',1,1,'es',0),(40,'2','No',2,1,'es',0),(64,'1','Excelente',1,1,'es',0),(64,'2','Muy Buena',2,1,'es',0),(64,'3','Buena',3,1,'es',0),(64,'4','Regular',4,1,'es',0),(64,'5','Mala',5,1,'es',0),(64,'6','NS/NR',6,1,'es',0),(64,'7','No Aplica',7,1,'es',0),(112,'3','Buena',3,1,'es',0),(112,'1','Excelente',1,1,'es',0),(112,'2','Muy Buena',2,1,'es',0),(112,'6','NS/NR',6,1,'es',0),(112,'5','Mala',5,1,'es',0),(112,'4','Regular',4,1,'es',0),(117,'3','Ni de acuerdo/ Ni en desacuerdo',3,1,'es',0),(117,'2','De acuerdo',2,1,'es',0),(117,'1','Totalmente de acuerdo',1,1,'es',0),(113,'7','No Aplica',7,1,'es',0),(113,'6','NS/NR',6,1,'es',0),(113,'5','Mala',5,1,'es',0),(113,'4','Regular',4,1,'es',0),(113,'3','Buena',3,1,'es',0),(113,'1','Excelente',1,1,'es',0),(113,'2','Muy Buena',2,1,'es',0),(117,'5','Totalmente en desacuerdo',5,1,'es',0),(117,'4','Desacuerdo',4,1,'es',0),(123,'7','Negocios',7,1,'es',0),(123,'6','Mapa Callejero',6,1,'es',0),(123,'5','Localidades',5,1,'es',0),(123,'4','GuÃa de Trámites y Servicios',4,1,'es',0),(123,'3','Gobierno',3,1,'es',0),(123,'2','Información General',2,1,'es',0),(123,'1','Bogotá por temas',1,1,'es',0),(117,'6','NS/NR',6,1,'es',0),(89,'1','0',1,1,'es',0),(89,'2','1',2,1,'es',0),(89,'3','2',3,1,'es',0),(89,'4','3',4,1,'es',0),(89,'5','4',5,1,'es',0),(89,'6','5',6,1,'es',0),(89,'7','6',7,1,'es',0),(89,'8','Ns/Nr',8,1,'es',0),(90,'1','Soltero',1,1,'es',0),(90,'2','Casado/ Unión Libre',2,1,'es',0),(90,'3','Separado/ Divorciado',3,1,'es',0),(90,'4','Viudo',4,1,'es',0),(91,'1','Empleado',1,1,'es',0),(91,'2','Estudiante',2,1,'es',0),(91,'3','Empleado / Estudiante',3,1,'es',0),(91,'4','Desempleado',4,1,'es',0),(91,'5','Pensionado',5,1,'es',0),(91,'6','Ama de Casa',6,1,'es',0),(91,'7','Independiente',7,1,'es',0),(91,'8','No responde',8,1,'es',0),(92,'1','Primaria',1,1,'es',0),(92,'2','Bachillerato',2,1,'es',0),(92,'3','Técnico/ Tecnólogo',3,1,'es',0),(92,'4','Universitario',4,1,'es',0),(92,'5','Posgrado',5,1,'es',0),(92,'6','Ninguno',6,1,'es',0),(92,'7','No responde',7,1,'es',0),(93,'1','Antonio Nariño',1,1,'es',0),(93,'10','Los Mártires',10,1,'es',0),(93,'11','Puente Aranda',11,1,'es',0),(93,'12','Rafael Uribe Uribe',12,1,'es',0),(93,'13','San Cristóbal',13,1,'es',0),(93,'14','Santa Fe',14,1,'es',0),(93,'15','Suba',15,1,'es',0),(93,'16','Sumapaz',16,1,'es',0),(93,'17','Teusaquillo',17,1,'es',0),(93,'18','Tunjuelito',18,1,'es',0),(93,'19','Usaquén',19,1,'es',0),(93,'2','Barrios Unidos',2,1,'es',0),(93,'20','Usme',20,1,'es',0),(93,'3','Bosa',3,1,'es',0),(93,'4','Chapinero',4,1,'es',0),(93,'5','Ciudad BolÃvar',5,1,'es',0),(93,'6','Engativá',6,1,'es',0),(93,'7','Fontibón',7,1,'es',0),(93,'8','Kennedy',8,1,'es',0),(93,'9','La Candelaria',9,1,'es',0),(123,'8','Noticias',8,1,'es',0),(123,'9','GuÃa cultural',9,1,'es',0),(123,'10','Dirección Distrital de Servicio al Ciudadano',10,1,'es',0),(123,'11','Disfrutando',11,1,'es',0),(124,'1','Actualizarse sobre la información del gobierno distrital',1,1,'es',0),(124,'2','Informarse sobre un tramite o servicio',2,1,'es',0),(124,'3','Realizar un tramite o servicio',3,1,'es',0),(124,'4','Hacer seguimiento a un tramite o servicio',4,1,'es',0),(124,'5','Conocer los programas del gobierno distrital',5,1,'es',0),(124,'6','Conocer la oferta cultural de la ciudad',6,1,'es',0),(124,'7','Conocer la oferta de negocios que tiene la ciudad',7,1,'es',0),(124,'8','Otro, ¿Cuál?',8,1,'es',0),(127,'6','NS/NR',6,1,'es',0),(127,'5','Mala',5,1,'es',0),(127,'4','Regular',4,1,'es',0),(127,'3','Buena',3,1,'es',0),(127,'2','Muy Buena',2,1,'es',0),(127,'1','Excelente',1,1,'es',0);
45/*!40000 ALTER TABLE `lime_answers` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `lime_assessments`
50--
51
52DROP TABLE IF EXISTS `lime_assessments`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `lime_assessments` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `sid` int(11) NOT NULL DEFAULT '0',
58 `scope` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
59 `gid` int(11) NOT NULL DEFAULT '0',
60 `name` text COLLATE utf8_unicode_ci NOT NULL,
61 `minimum` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
62 `maximum` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
63 `message` text COLLATE utf8_unicode_ci NOT NULL,
64 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
65 PRIMARY KEY (`id`,`language`),
66 KEY `assessments_idx2` (`sid`),
67 KEY `assessments_idx3` (`gid`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `lime_assessments`
73--
74
75LOCK TABLES `lime_assessments` WRITE;
76/*!40000 ALTER TABLE `lime_assessments` DISABLE KEYS */;
77/*!40000 ALTER TABLE `lime_assessments` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `lime_conditions`
82--
83
84DROP TABLE IF EXISTS `lime_conditions`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `lime_conditions` (
88 `cid` int(11) NOT NULL AUTO_INCREMENT,
89 `qid` int(11) NOT NULL DEFAULT '0',
90 `cqid` int(11) NOT NULL DEFAULT '0',
91 `cfieldname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
92 `method` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
93 `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
94 `scenario` int(11) NOT NULL DEFAULT '1',
95 PRIMARY KEY (`cid`),
96 KEY `conditions_idx2` (`qid`),
97 KEY `conditions_idx3` (`cqid`)
98) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `lime_conditions`
103--
104
105LOCK TABLES `lime_conditions` WRITE;
106/*!40000 ALTER TABLE `lime_conditions` DISABLE KEYS */;
107INSERT INTO `lime_conditions` VALUES (1,5,4,'158942X3X47','==','1',1),(2,41,40,'658539X6X40','==','1',1),(3,42,40,'658539X6X40','==','1',1),(4,51,40,'658539X6X40','==','1',1),(5,52,40,'658539X6X40','==','1',1),(6,57,40,'658539X6X40','==','1',1),(7,58,40,'658539X6X40','==','1',1),(8,59,40,'658539X6X40','==','1',1),(9,64,40,'658539X6X40','==','1',1),(10,65,40,'658539X6X40','==','1',1),(11,52,51,'658539X8X51','==','Y',1),(12,58,57,'658539X9X57','==','Y',1);
108/*!40000 ALTER TABLE `lime_conditions` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `lime_defaultvalues`
113--
114
115DROP TABLE IF EXISTS `lime_defaultvalues`;
116/*!40101 SET @saved_cs_client = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `lime_defaultvalues` (
119 `qid` int(11) NOT NULL DEFAULT '0',
120 `scale_id` int(11) NOT NULL DEFAULT '0',
121 `sqid` int(11) NOT NULL DEFAULT '0',
122 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
123 `specialtype` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
124 `defaultvalue` text COLLATE utf8_unicode_ci,
125 PRIMARY KEY (`qid`,`specialtype`,`language`,`scale_id`,`sqid`)
126) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `lime_defaultvalues`
131--
132
133LOCK TABLES `lime_defaultvalues` WRITE;
134/*!40000 ALTER TABLE `lime_defaultvalues` DISABLE KEYS */;
135/*!40000 ALTER TABLE `lime_defaultvalues` ENABLE KEYS */;
136UNLOCK TABLES;
137
138--
139-- Table structure for table `lime_expression_errors`
140--
141
142DROP TABLE IF EXISTS `lime_expression_errors`;
143/*!40101 SET @saved_cs_client = @@character_set_client */;
144/*!40101 SET character_set_client = utf8 */;
145CREATE TABLE `lime_expression_errors` (
146 `id` int(11) NOT NULL AUTO_INCREMENT,
147 `errortime` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
148 `sid` int(11) DEFAULT NULL,
149 `gid` int(11) DEFAULT NULL,
150 `qid` int(11) DEFAULT NULL,
151 `gseq` int(11) DEFAULT NULL,
152 `qseq` int(11) DEFAULT NULL,
153 `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
154 `eqn` text COLLATE utf8_unicode_ci,
155 `prettyprint` text COLLATE utf8_unicode_ci,
156 PRIMARY KEY (`id`)
157) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
158/*!40101 SET character_set_client = @saved_cs_client */;
159
160--
161-- Dumping data for table `lime_expression_errors`
162--
163
164LOCK TABLES `lime_expression_errors` WRITE;
165/*!40000 ALTER TABLE `lime_expression_errors` DISABLE KEYS */;
166/*!40000 ALTER TABLE `lime_expression_errors` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `lime_failed_login_attempts`
171--
172
173DROP TABLE IF EXISTS `lime_failed_login_attempts`;
174/*!40101 SET @saved_cs_client = @@character_set_client */;
175/*!40101 SET character_set_client = utf8 */;
176CREATE TABLE `lime_failed_login_attempts` (
177 `id` int(11) NOT NULL AUTO_INCREMENT,
178 `ip` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
179 `last_attempt` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
180 `number_attempts` int(11) NOT NULL,
181 PRIMARY KEY (`id`)
182) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
183/*!40101 SET character_set_client = @saved_cs_client */;
184
185--
186-- Dumping data for table `lime_failed_login_attempts`
187--
188
189LOCK TABLES `lime_failed_login_attempts` WRITE;
190/*!40000 ALTER TABLE `lime_failed_login_attempts` DISABLE KEYS */;
191/*!40000 ALTER TABLE `lime_failed_login_attempts` ENABLE KEYS */;
192UNLOCK TABLES;
193
194--
195-- Table structure for table `lime_groups`
196--
197
198DROP TABLE IF EXISTS `lime_groups`;
199/*!40101 SET @saved_cs_client = @@character_set_client */;
200/*!40101 SET character_set_client = utf8 */;
201CREATE TABLE `lime_groups` (
202 `gid` int(11) NOT NULL AUTO_INCREMENT,
203 `sid` int(11) NOT NULL DEFAULT '0',
204 `group_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
205 `group_order` int(11) NOT NULL DEFAULT '0',
206 `description` text COLLATE utf8_unicode_ci,
207 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
208 `randomization_group` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
209 `grelevance` text COLLATE utf8_unicode_ci,
210 PRIMARY KEY (`gid`,`language`),
211 KEY `groups_idx2` (`sid`)
212) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
213/*!40101 SET character_set_client = @saved_cs_client */;
214
215--
216-- Dumping data for table `lime_groups`
217--
218
219LOCK TABLES `lime_groups` WRITE;
220/*!40000 ALTER TABLE `lime_groups` DISABLE KEYS */;
221INSERT INTO `lime_groups` VALUES (1,158942,'MOTIVO DE LAS VISITAS',0,'','es','',''),(2,158942,'EVALUACIÓN DEL SERVICIO',1,'','es','',''),(3,158942,'EXPERIENCIA EN EL PORTAL',2,'','es','',''),(4,158942,'EXPECTATIVA',3,'','es','',''),(5,158942,'DATOS DEL ENTREVISTADO',4,'','es','',''),(6,658539,'Conocimiento de la guÃa',0,'','es','',''),(7,658539,'Calificación general',1,'','es','',''),(8,658539,'Evaluación del servicio',2,'','es','',''),(9,658539,'Mapa callejero',3,'','es','',''),(10,658539,'Portal Bogotá',4,'','es','',''),(11,658539,'Datos del entrevistado',5,'','es','',''),(18,289827,'Calificación general',0,'','es','',''),(19,289827,'Evaluación del servicio',1,'','es','',''),(20,289827,'Infraestructura',2,'','es','',''),(21,289827,'Experiencia con el servicio',3,'','es','',''),(17,289827,'Datos del entrevistado',4,'','es','','');
222/*!40000 ALTER TABLE `lime_groups` ENABLE KEYS */;
223UNLOCK TABLES;
224
225--
226-- Table structure for table `lime_labels`
227--
228
229DROP TABLE IF EXISTS `lime_labels`;
230/*!40101 SET @saved_cs_client = @@character_set_client */;
231/*!40101 SET character_set_client = utf8 */;
232CREATE TABLE `lime_labels` (
233 `lid` int(11) NOT NULL DEFAULT '0',
234 `code` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
235 `title` text COLLATE utf8_unicode_ci,
236 `sortorder` int(11) NOT NULL,
237 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
238 `assessment_value` int(11) NOT NULL DEFAULT '0',
239 PRIMARY KEY (`lid`,`sortorder`,`language`),
240 KEY `labels_code_idx` (`code`)
241) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
242/*!40101 SET character_set_client = @saved_cs_client */;
243
244--
245-- Dumping data for table `lime_labels`
246--
247
248LOCK TABLES `lime_labels` WRITE;
249/*!40000 ALTER TABLE `lime_labels` DISABLE KEYS */;
250/*!40000 ALTER TABLE `lime_labels` ENABLE KEYS */;
251UNLOCK TABLES;
252
253--
254-- Table structure for table `lime_labelsets`
255--
256
257DROP TABLE IF EXISTS `lime_labelsets`;
258/*!40101 SET @saved_cs_client = @@character_set_client */;
259/*!40101 SET character_set_client = utf8 */;
260CREATE TABLE `lime_labelsets` (
261 `lid` int(11) NOT NULL AUTO_INCREMENT,
262 `label_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
263 `languages` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'en',
264 PRIMARY KEY (`lid`)
265) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
266/*!40101 SET character_set_client = @saved_cs_client */;
267
268--
269-- Dumping data for table `lime_labelsets`
270--
271
272LOCK TABLES `lime_labelsets` WRITE;
273/*!40000 ALTER TABLE `lime_labelsets` DISABLE KEYS */;
274/*!40000 ALTER TABLE `lime_labelsets` ENABLE KEYS */;
275UNLOCK TABLES;
276
277--
278-- Table structure for table `lime_old_survey_158942_20140128215440`
279--
280
281DROP TABLE IF EXISTS `lime_old_survey_158942_20140128215440`;
282/*!40101 SET @saved_cs_client = @@character_set_client */;
283/*!40101 SET character_set_client = utf8 */;
284CREATE TABLE `lime_old_survey_158942_20140128215440` (
285 `id` int(11) NOT NULL AUTO_INCREMENT,
286 `submitdate` datetime DEFAULT NULL,
287 `lastpage` int(11) DEFAULT NULL,
288 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
289 `startdate` datetime NOT NULL,
290 `datestamp` datetime NOT NULL,
291 `ipaddr` text COLLATE utf8_unicode_ci,
292 `refurl` text COLLATE utf8_unicode_ci,
293 `158942X1X1` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
294 `158942X1X1other` text COLLATE utf8_unicode_ci,
295 `158942X2X2SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
296 `158942X2X2SQ002` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
297 `158942X2X2SQ003` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
298 `158942X2X2SQ004` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
299 `158942X2X31` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
300 `158942X2X32` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
301 `158942X2X33` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
302 `158942X3X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
303 `158942X3X42` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
304 `158942X3X43` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
305 `158942X3X44` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
306 `158942X3X45` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
307 `158942X3X46` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
308 `158942X3X47` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
309 `158942X3X48` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
310 `158942X3X5` text COLLATE utf8_unicode_ci,
311 `158942X3X6` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
312 `158942X4X71` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
313 `158942X4X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
314 `158942X4X73` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
315 `158942X4X74` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
316 `158942X4X75` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
317 `158942X4X76` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
318 `158942X4X7other` text COLLATE utf8_unicode_ci,
319 `158942X5X8` decimal(30,10) DEFAULT NULL,
320 `158942X5X9` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
321 `158942X5X10` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
322 `158942X5X11` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
323 `158942X5X12` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
324 `158942X5X13` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
325 `158942X5X14SQ001` text COLLATE utf8_unicode_ci,
326 `158942X5X141` text COLLATE utf8_unicode_ci,
327 `158942X5X142` text COLLATE utf8_unicode_ci,
328 `158942X5X143` text COLLATE utf8_unicode_ci,
329 PRIMARY KEY (`id`)
330) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
331/*!40101 SET character_set_client = @saved_cs_client */;
332
333--
334-- Dumping data for table `lime_old_survey_158942_20140128215440`
335--
336
337LOCK TABLES `lime_old_survey_158942_20140128215440` WRITE;
338/*!40000 ALTER TABLE `lime_old_survey_158942_20140128215440` DISABLE KEYS */;
339INSERT INTO `lime_old_survey_158942_20140128215440` VALUES (1,NULL,NULL,'es','2014-01-27 21:16:18','2014-01-27 21:16:18','192.101.7.23','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index/sid/158942/newtest/Y/lang/es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,'es','2014-01-27 21:17:41','2014-01-27 21:17:41','192.101.7.23','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index/sid/158942/newtest/Y/lang/es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,2,'es','2014-01-27 21:19:56','2014-01-27 21:19:56','192.101.7.23','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index/sid/158942/newtest/Y/lang/es','A5','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
340/*!40000 ALTER TABLE `lime_old_survey_158942_20140128215440` ENABLE KEYS */;
341UNLOCK TABLES;
342
343--
344-- Table structure for table `lime_old_survey_158942_20140129220922`
345--
346
347DROP TABLE IF EXISTS `lime_old_survey_158942_20140129220922`;
348/*!40101 SET @saved_cs_client = @@character_set_client */;
349/*!40101 SET character_set_client = utf8 */;
350CREATE TABLE `lime_old_survey_158942_20140129220922` (
351 `id` int(11) NOT NULL AUTO_INCREMENT,
352 `submitdate` datetime DEFAULT NULL,
353 `lastpage` int(11) DEFAULT NULL,
354 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
355 `startdate` datetime NOT NULL,
356 `datestamp` datetime NOT NULL,
357 `ipaddr` text COLLATE utf8_unicode_ci,
358 `refurl` text COLLATE utf8_unicode_ci,
359 `158942X1X1` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
360 `158942X1X1other` text COLLATE utf8_unicode_ci,
361 `158942X2X2SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
362 `158942X2X2SQ002` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
363 `158942X2X2SQ003` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
364 `158942X2X2SQ004` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
365 `158942X2X31` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
366 `158942X2X32` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
367 `158942X2X33` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
368 `158942X3X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
369 `158942X3X42` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
370 `158942X3X43` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
371 `158942X3X44` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
372 `158942X3X45` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
373 `158942X3X46` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
374 `158942X3X47` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
375 `158942X3X48` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
376 `158942X3X5` text COLLATE utf8_unicode_ci,
377 `158942X3X6` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
378 `158942X4X71` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
379 `158942X4X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
380 `158942X4X73` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
381 `158942X4X74` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
382 `158942X4X75` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
383 `158942X4X76` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
384 `158942X4X7other` text COLLATE utf8_unicode_ci,
385 `158942X5X8` decimal(30,10) DEFAULT NULL,
386 `158942X5X9` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
387 `158942X5X10` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
388 `158942X5X11` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
389 `158942X5X12` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
390 `158942X5X13` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
391 `158942X5X14SQ001` text COLLATE utf8_unicode_ci,
392 `158942X5X141` text COLLATE utf8_unicode_ci,
393 `158942X5X142` text COLLATE utf8_unicode_ci,
394 `158942X5X143` text COLLATE utf8_unicode_ci,
395 PRIMARY KEY (`id`)
396) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
397/*!40101 SET character_set_client = @saved_cs_client */;
398
399--
400-- Dumping data for table `lime_old_survey_158942_20140129220922`
401--
402
403LOCK TABLES `lime_old_survey_158942_20140129220922` WRITE;
404/*!40000 ALTER TABLE `lime_old_survey_158942_20140129220922` DISABLE KEYS */;
405INSERT INTO `lime_old_survey_158942_20140129220922` VALUES (4,NULL,NULL,'es','2014-01-28 22:23:13','2014-01-28 22:23:13','192.101.7.23','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,-1,'es','2014-01-29 15:42:20','2014-01-29 15:42:20','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
406/*!40000 ALTER TABLE `lime_old_survey_158942_20140129220922` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Table structure for table `lime_old_survey_158942_timings_20140128215440`
411--
412
413DROP TABLE IF EXISTS `lime_old_survey_158942_timings_20140128215440`;
414/*!40101 SET @saved_cs_client = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `lime_old_survey_158942_timings_20140128215440` (
417 `id` int(11) NOT NULL AUTO_INCREMENT,
418 `interviewtime` float DEFAULT NULL,
419 `158942X1time` float DEFAULT NULL,
420 `158942X1X1time` float DEFAULT NULL,
421 `158942X2time` float DEFAULT NULL,
422 `158942X2X2time` float DEFAULT NULL,
423 `158942X2X3time` float DEFAULT NULL,
424 `158942X3time` float DEFAULT NULL,
425 `158942X3X4time` float DEFAULT NULL,
426 `158942X3X5time` float DEFAULT NULL,
427 `158942X3X6time` float DEFAULT NULL,
428 `158942X4time` float DEFAULT NULL,
429 `158942X4X7time` float DEFAULT NULL,
430 `158942X5time` float DEFAULT NULL,
431 `158942X5X8time` float DEFAULT NULL,
432 `158942X5X9time` float DEFAULT NULL,
433 `158942X5X10time` float DEFAULT NULL,
434 `158942X5X11time` float DEFAULT NULL,
435 `158942X5X12time` float DEFAULT NULL,
436 `158942X5X13time` float DEFAULT NULL,
437 `158942X5X14time` float DEFAULT NULL,
438 PRIMARY KEY (`id`)
439) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
440/*!40101 SET character_set_client = @saved_cs_client */;
441
442--
443-- Dumping data for table `lime_old_survey_158942_timings_20140128215440`
444--
445
446LOCK TABLES `lime_old_survey_158942_timings_20140128215440` WRITE;
447/*!40000 ALTER TABLE `lime_old_survey_158942_timings_20140128215440` DISABLE KEYS */;
448INSERT INTO `lime_old_survey_158942_timings_20140128215440` VALUES (1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,318.06,120.92,NULL,197.14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
449/*!40000 ALTER TABLE `lime_old_survey_158942_timings_20140128215440` ENABLE KEYS */;
450UNLOCK TABLES;
451
452--
453-- Table structure for table `lime_old_survey_158942_timings_20140129220922`
454--
455
456DROP TABLE IF EXISTS `lime_old_survey_158942_timings_20140129220922`;
457/*!40101 SET @saved_cs_client = @@character_set_client */;
458/*!40101 SET character_set_client = utf8 */;
459CREATE TABLE `lime_old_survey_158942_timings_20140129220922` (
460 `id` int(11) NOT NULL AUTO_INCREMENT,
461 `interviewtime` float DEFAULT NULL,
462 `158942X1time` float DEFAULT NULL,
463 `158942X1X1time` float DEFAULT NULL,
464 `158942X2time` float DEFAULT NULL,
465 `158942X2X2time` float DEFAULT NULL,
466 `158942X2X3time` float DEFAULT NULL,
467 `158942X3time` float DEFAULT NULL,
468 `158942X3X4time` float DEFAULT NULL,
469 `158942X3X5time` float DEFAULT NULL,
470 `158942X3X6time` float DEFAULT NULL,
471 `158942X4time` float DEFAULT NULL,
472 `158942X4X7time` float DEFAULT NULL,
473 `158942X5time` float DEFAULT NULL,
474 `158942X5X8time` float DEFAULT NULL,
475 `158942X5X9time` float DEFAULT NULL,
476 `158942X5X10time` float DEFAULT NULL,
477 `158942X5X11time` float DEFAULT NULL,
478 `158942X5X12time` float DEFAULT NULL,
479 `158942X5X13time` float DEFAULT NULL,
480 `158942X5X14time` float DEFAULT NULL,
481 PRIMARY KEY (`id`)
482) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
483/*!40101 SET character_set_client = @saved_cs_client */;
484
485--
486-- Dumping data for table `lime_old_survey_158942_timings_20140129220922`
487--
488
489LOCK TABLES `lime_old_survey_158942_timings_20140129220922` WRITE;
490/*!40000 ALTER TABLE `lime_old_survey_158942_timings_20140129220922` DISABLE KEYS */;
491INSERT INTO `lime_old_survey_158942_timings_20140129220922` VALUES (4,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,75.78,70.44,NULL,5.34,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
492/*!40000 ALTER TABLE `lime_old_survey_158942_timings_20140129220922` ENABLE KEYS */;
493UNLOCK TABLES;
494
495--
496-- Table structure for table `lime_old_survey_289827_20140128214401`
497--
498
499DROP TABLE IF EXISTS `lime_old_survey_289827_20140128214401`;
500/*!40101 SET @saved_cs_client = @@character_set_client */;
501/*!40101 SET character_set_client = utf8 */;
502CREATE TABLE `lime_old_survey_289827_20140128214401` (
503 `id` int(11) NOT NULL AUTO_INCREMENT,
504 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
505 `submitdate` datetime DEFAULT NULL,
506 `lastpage` int(11) DEFAULT NULL,
507 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
508 `289827X12X78` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
509 `289827X13X79` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
510 `289827X14X801` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
511 `289827X14X802` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
512 `289827X14X803` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
513 `289827X14X804` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
514 `289827X14X805` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
515 `289827X14X806` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
516 `289827X14X807` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
517 `289827X14X81` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
518 `289827X14X821` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
519 `289827X14X822` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
520 `289827X14X823` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
521 `289827X15X83` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
522 `289827X15X84` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
523 `289827X15X851` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
524 `289827X15X852` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
525 `289827X15X853` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
526 `289827X16X86SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
527 `289827X16X87` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
528 `289827X17X96SQ001` text COLLATE utf8_unicode_ci,
529 `289827X17X88` decimal(30,10) DEFAULT NULL,
530 `289827X17X89` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
531 `289827X17X90` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
532 `289827X17X91` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
533 `289827X17X92` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
534 `289827X17X93` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
535 `289827X17X94` decimal(30,10) DEFAULT NULL,
536 `289827X17X95` text COLLATE utf8_unicode_ci,
537 PRIMARY KEY (`id`),
538 KEY `idx_survey_token_289827_10862` (`token`)
539) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
540/*!40101 SET character_set_client = @saved_cs_client */;
541
542--
543-- Dumping data for table `lime_old_survey_289827_20140128214401`
544--
545
546LOCK TABLES `lime_old_survey_289827_20140128214401` WRITE;
547/*!40000 ALTER TABLE `lime_old_survey_289827_20140128214401` DISABLE KEYS */;
548/*!40000 ALTER TABLE `lime_old_survey_289827_20140128214401` ENABLE KEYS */;
549UNLOCK TABLES;
550
551--
552-- Table structure for table `lime_old_survey_289827_20140128221012`
553--
554
555DROP TABLE IF EXISTS `lime_old_survey_289827_20140128221012`;
556/*!40101 SET @saved_cs_client = @@character_set_client */;
557/*!40101 SET character_set_client = utf8 */;
558CREATE TABLE `lime_old_survey_289827_20140128221012` (
559 `id` int(11) NOT NULL AUTO_INCREMENT,
560 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
561 `submitdate` datetime DEFAULT NULL,
562 `lastpage` int(11) DEFAULT NULL,
563 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
564 `289827X18X112` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
565 `289827X19X1131` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
566 `289827X19X1132` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
567 `289827X20X1171` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
568 `289827X20X1172` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
569 `289827X20X1173` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
570 `289827X20X1174` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
571 `289827X21X123` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
572 `289827X21X124` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
573 `289827X17X96SQ001` text COLLATE utf8_unicode_ci,
574 `289827X17X88` decimal(30,10) DEFAULT NULL,
575 `289827X17X89` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
576 `289827X17X90` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
577 `289827X17X91` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
578 `289827X17X92` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
579 `289827X17X93` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
580 `289827X17X94` decimal(30,10) DEFAULT NULL,
581 `289827X17X95` text COLLATE utf8_unicode_ci,
582 PRIMARY KEY (`id`),
583 KEY `idx_survey_token_289827_3475` (`token`)
584) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
585/*!40101 SET character_set_client = @saved_cs_client */;
586
587--
588-- Dumping data for table `lime_old_survey_289827_20140128221012`
589--
590
591LOCK TABLES `lime_old_survey_289827_20140128221012` WRITE;
592/*!40000 ALTER TABLE `lime_old_survey_289827_20140128221012` DISABLE KEYS */;
593/*!40000 ALTER TABLE `lime_old_survey_289827_20140128221012` ENABLE KEYS */;
594UNLOCK TABLES;
595
596--
597-- Table structure for table `lime_old_survey_289827_20140129221423`
598--
599
600DROP TABLE IF EXISTS `lime_old_survey_289827_20140129221423`;
601/*!40101 SET @saved_cs_client = @@character_set_client */;
602/*!40101 SET character_set_client = utf8 */;
603CREATE TABLE `lime_old_survey_289827_20140129221423` (
604 `id` int(11) NOT NULL AUTO_INCREMENT,
605 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
606 `submitdate` datetime DEFAULT NULL,
607 `lastpage` int(11) DEFAULT NULL,
608 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
609 `289827X18X112` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
610 `289827X19X1131` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
611 `289827X19X1132` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
612 `289827X20X1171` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
613 `289827X20X1172` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
614 `289827X20X1173` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
615 `289827X20X1174` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
616 `289827X21X123` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
617 `289827X21X124` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
618 `289827X17X96SQ001` text COLLATE utf8_unicode_ci,
619 `289827X17X88` decimal(30,10) DEFAULT NULL,
620 `289827X17X89` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
621 `289827X17X90` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
622 `289827X17X91` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
623 `289827X17X92` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
624 `289827X17X93` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
625 `289827X17X94` decimal(30,10) DEFAULT NULL,
626 `289827X17X95` text COLLATE utf8_unicode_ci,
627 PRIMARY KEY (`id`),
628 KEY `idx_survey_token_289827_30218` (`token`)
629) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
630/*!40101 SET character_set_client = @saved_cs_client */;
631
632--
633-- Dumping data for table `lime_old_survey_289827_20140129221423`
634--
635
636LOCK TABLES `lime_old_survey_289827_20140129221423` WRITE;
637/*!40000 ALTER TABLE `lime_old_survey_289827_20140129221423` DISABLE KEYS */;
638INSERT INTO `lime_old_survey_289827_20140129221423` VALUES (1,NULL,NULL,NULL,'es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,4,'es','3','3','3','2','2','2','2','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
639/*!40000 ALTER TABLE `lime_old_survey_289827_20140129221423` ENABLE KEYS */;
640UNLOCK TABLES;
641
642--
643-- Table structure for table `lime_old_survey_658539_20140128212953`
644--
645
646DROP TABLE IF EXISTS `lime_old_survey_658539_20140128212953`;
647/*!40101 SET @saved_cs_client = @@character_set_client */;
648/*!40101 SET character_set_client = utf8 */;
649CREATE TABLE `lime_old_survey_658539_20140128212953` (
650 `id` int(11) NOT NULL AUTO_INCREMENT,
651 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
652 `submitdate` datetime DEFAULT NULL,
653 `lastpage` int(11) DEFAULT NULL,
654 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
655 `658539X6X40` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
656 `658539X7X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
657 `658539X8X421` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
658 `658539X8X422` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
659 `658539X8X423` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
660 `658539X8X424` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
661 `658539X8X425` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
662 `658539X8X426` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
663 `658539X8X427` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
664 `658539X8X51` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
665 `658539X8X521` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
666 `658539X8X522` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
667 `658539X8X523` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
668 `658539X9X57` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
669 `658539X9X58` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
670 `658539X9X591` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
671 `658539X9X592` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
672 `658539X9X593` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
673 `658539X10X64SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
674 `658539X10X65` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
675 `658539X11X75SQ001` text COLLATE utf8_unicode_ci,
676 `658539X11X66` decimal(30,10) DEFAULT NULL,
677 `658539X11X67` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
678 `658539X11X68` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
679 `658539X11X69` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
680 `658539X11X70` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
681 `658539X11X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
682 `658539X11X73` decimal(30,10) DEFAULT NULL,
683 `658539X11X74` text COLLATE utf8_unicode_ci,
684 PRIMARY KEY (`id`),
685 KEY `idx_survey_token_658539_28577` (`token`)
686) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
687/*!40101 SET character_set_client = @saved_cs_client */;
688
689--
690-- Dumping data for table `lime_old_survey_658539_20140128212953`
691--
692
693LOCK TABLES `lime_old_survey_658539_20140128212953` WRITE;
694/*!40000 ALTER TABLE `lime_old_survey_658539_20140128212953` DISABLE KEYS */;
695INSERT INTO `lime_old_survey_658539_20140128212953` VALUES (1,NULL,NULL,1,'es','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
696/*!40000 ALTER TABLE `lime_old_survey_658539_20140128212953` ENABLE KEYS */;
697UNLOCK TABLES;
698
699--
700-- Table structure for table `lime_old_survey_658539_20140128220958`
701--
702
703DROP TABLE IF EXISTS `lime_old_survey_658539_20140128220958`;
704/*!40101 SET @saved_cs_client = @@character_set_client */;
705/*!40101 SET character_set_client = utf8 */;
706CREATE TABLE `lime_old_survey_658539_20140128220958` (
707 `id` int(11) NOT NULL AUTO_INCREMENT,
708 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
709 `submitdate` datetime DEFAULT NULL,
710 `lastpage` int(11) DEFAULT NULL,
711 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
712 `658539X6X40` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
713 `658539X7X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
714 `658539X8X421` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
715 `658539X8X422` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
716 `658539X8X423` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
717 `658539X8X424` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
718 `658539X8X425` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
719 `658539X8X426` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
720 `658539X8X427` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
721 `658539X8X51` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
722 `658539X8X521` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
723 `658539X8X522` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
724 `658539X8X523` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
725 `658539X9X57` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
726 `658539X9X58` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
727 `658539X9X591` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
728 `658539X9X592` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
729 `658539X9X593` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
730 `658539X10X64SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
731 `658539X10X65` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
732 `658539X11X75SQ001` text COLLATE utf8_unicode_ci,
733 `658539X11X66` decimal(30,10) DEFAULT NULL,
734 `658539X11X67` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
735 `658539X11X68` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
736 `658539X11X69` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
737 `658539X11X70` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
738 `658539X11X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
739 `658539X11X73` decimal(30,10) DEFAULT NULL,
740 `658539X11X74` text COLLATE utf8_unicode_ci,
741 PRIMARY KEY (`id`),
742 KEY `idx_survey_token_658539_9612` (`token`)
743) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
744/*!40101 SET character_set_client = @saved_cs_client */;
745
746--
747-- Dumping data for table `lime_old_survey_658539_20140128220958`
748--
749
750LOCK TABLES `lime_old_survey_658539_20140128220958` WRITE;
751/*!40000 ALTER TABLE `lime_old_survey_658539_20140128220958` DISABLE KEYS */;
752/*!40000 ALTER TABLE `lime_old_survey_658539_20140128220958` ENABLE KEYS */;
753UNLOCK TABLES;
754
755--
756-- Table structure for table `lime_old_survey_658539_20140129220529`
757--
758
759DROP TABLE IF EXISTS `lime_old_survey_658539_20140129220529`;
760/*!40101 SET @saved_cs_client = @@character_set_client */;
761/*!40101 SET character_set_client = utf8 */;
762CREATE TABLE `lime_old_survey_658539_20140129220529` (
763 `id` int(11) NOT NULL AUTO_INCREMENT,
764 `token` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
765 `submitdate` datetime DEFAULT NULL,
766 `lastpage` int(11) DEFAULT NULL,
767 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
768 `658539X6X40` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
769 `658539X7X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
770 `658539X8X421` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
771 `658539X8X422` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
772 `658539X8X423` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
773 `658539X8X424` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
774 `658539X8X425` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
775 `658539X8X426` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
776 `658539X8X427` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
777 `658539X8X51` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
778 `658539X8X521` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
779 `658539X8X522` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
780 `658539X8X523` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
781 `658539X9X57` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
782 `658539X9X58` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
783 `658539X9X591` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
784 `658539X9X592` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
785 `658539X9X593` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
786 `658539X10X64SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
787 `658539X10X65` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
788 `658539X11X75SQ001` text COLLATE utf8_unicode_ci,
789 `658539X11X66` decimal(30,10) DEFAULT NULL,
790 `658539X11X67` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
791 `658539X11X68` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
792 `658539X11X69` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
793 `658539X11X70` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
794 `658539X11X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
795 `658539X11X73` decimal(30,10) DEFAULT NULL,
796 `658539X11X74` text COLLATE utf8_unicode_ci,
797 PRIMARY KEY (`id`),
798 KEY `idx_survey_token_658539_1509` (`token`)
799) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
800/*!40101 SET character_set_client = @saved_cs_client */;
801
802--
803-- Dumping data for table `lime_old_survey_658539_20140129220529`
804--
805
806LOCK TABLES `lime_old_survey_658539_20140129220529` WRITE;
807/*!40000 ALTER TABLE `lime_old_survey_658539_20140129220529` DISABLE KEYS */;
808INSERT INTO `lime_old_survey_658539_20140129220529` VALUES (2,NULL,NULL,NULL,'es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
809/*!40000 ALTER TABLE `lime_old_survey_658539_20140129220529` ENABLE KEYS */;
810UNLOCK TABLES;
811
812--
813-- Table structure for table `lime_participant_attribute`
814--
815
816DROP TABLE IF EXISTS `lime_participant_attribute`;
817/*!40101 SET @saved_cs_client = @@character_set_client */;
818/*!40101 SET character_set_client = utf8 */;
819CREATE TABLE `lime_participant_attribute` (
820 `participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
821 `attribute_id` int(11) NOT NULL,
822 `value` text COLLATE utf8_unicode_ci NOT NULL,
823 PRIMARY KEY (`participant_id`,`attribute_id`)
824) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
825/*!40101 SET character_set_client = @saved_cs_client */;
826
827--
828-- Dumping data for table `lime_participant_attribute`
829--
830
831LOCK TABLES `lime_participant_attribute` WRITE;
832/*!40000 ALTER TABLE `lime_participant_attribute` DISABLE KEYS */;
833/*!40000 ALTER TABLE `lime_participant_attribute` ENABLE KEYS */;
834UNLOCK TABLES;
835
836--
837-- Table structure for table `lime_participant_attribute_names`
838--
839
840DROP TABLE IF EXISTS `lime_participant_attribute_names`;
841/*!40101 SET @saved_cs_client = @@character_set_client */;
842/*!40101 SET character_set_client = utf8 */;
843CREATE TABLE `lime_participant_attribute_names` (
844 `attribute_id` int(11) NOT NULL AUTO_INCREMENT,
845 `attribute_type` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
846 `defaultname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
847 `visible` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
848 PRIMARY KEY (`attribute_id`,`attribute_type`)
849) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
850/*!40101 SET character_set_client = @saved_cs_client */;
851
852--
853-- Dumping data for table `lime_participant_attribute_names`
854--
855
856LOCK TABLES `lime_participant_attribute_names` WRITE;
857/*!40000 ALTER TABLE `lime_participant_attribute_names` DISABLE KEYS */;
858/*!40000 ALTER TABLE `lime_participant_attribute_names` ENABLE KEYS */;
859UNLOCK TABLES;
860
861--
862-- Table structure for table `lime_participant_attribute_names_lang`
863--
864
865DROP TABLE IF EXISTS `lime_participant_attribute_names_lang`;
866/*!40101 SET @saved_cs_client = @@character_set_client */;
867/*!40101 SET character_set_client = utf8 */;
868CREATE TABLE `lime_participant_attribute_names_lang` (
869 `attribute_id` int(11) NOT NULL,
870 `attribute_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
871 `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
872 PRIMARY KEY (`attribute_id`,`lang`)
873) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
874/*!40101 SET character_set_client = @saved_cs_client */;
875
876--
877-- Dumping data for table `lime_participant_attribute_names_lang`
878--
879
880LOCK TABLES `lime_participant_attribute_names_lang` WRITE;
881/*!40000 ALTER TABLE `lime_participant_attribute_names_lang` DISABLE KEYS */;
882/*!40000 ALTER TABLE `lime_participant_attribute_names_lang` ENABLE KEYS */;
883UNLOCK TABLES;
884
885--
886-- Table structure for table `lime_participant_attribute_values`
887--
888
889DROP TABLE IF EXISTS `lime_participant_attribute_values`;
890/*!40101 SET @saved_cs_client = @@character_set_client */;
891/*!40101 SET character_set_client = utf8 */;
892CREATE TABLE `lime_participant_attribute_values` (
893 `value_id` int(11) NOT NULL AUTO_INCREMENT,
894 `attribute_id` int(11) NOT NULL,
895 `value` text COLLATE utf8_unicode_ci NOT NULL,
896 PRIMARY KEY (`value_id`)
897) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
898/*!40101 SET character_set_client = @saved_cs_client */;
899
900--
901-- Dumping data for table `lime_participant_attribute_values`
902--
903
904LOCK TABLES `lime_participant_attribute_values` WRITE;
905/*!40000 ALTER TABLE `lime_participant_attribute_values` DISABLE KEYS */;
906/*!40000 ALTER TABLE `lime_participant_attribute_values` ENABLE KEYS */;
907UNLOCK TABLES;
908
909--
910-- Table structure for table `lime_participant_shares`
911--
912
913DROP TABLE IF EXISTS `lime_participant_shares`;
914/*!40101 SET @saved_cs_client = @@character_set_client */;
915/*!40101 SET character_set_client = utf8 */;
916CREATE TABLE `lime_participant_shares` (
917 `participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
918 `share_uid` int(11) NOT NULL,
919 `date_added` datetime NOT NULL,
920 `can_edit` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
921 PRIMARY KEY (`participant_id`,`share_uid`)
922) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
923/*!40101 SET character_set_client = @saved_cs_client */;
924
925--
926-- Dumping data for table `lime_participant_shares`
927--
928
929LOCK TABLES `lime_participant_shares` WRITE;
930/*!40000 ALTER TABLE `lime_participant_shares` DISABLE KEYS */;
931/*!40000 ALTER TABLE `lime_participant_shares` ENABLE KEYS */;
932UNLOCK TABLES;
933
934--
935-- Table structure for table `lime_participants`
936--
937
938DROP TABLE IF EXISTS `lime_participants`;
939/*!40101 SET @saved_cs_client = @@character_set_client */;
940/*!40101 SET character_set_client = utf8 */;
941CREATE TABLE `lime_participants` (
942 `participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
943 `firstname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
944 `lastname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
945 `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
946 `language` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
947 `blacklisted` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
948 `owner_uid` int(11) NOT NULL,
949 `created_by` int(11) NOT NULL,
950 `created` datetime DEFAULT NULL,
951 `modified` datetime DEFAULT NULL,
952 PRIMARY KEY (`participant_id`)
953) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
954/*!40101 SET character_set_client = @saved_cs_client */;
955
956--
957-- Dumping data for table `lime_participants`
958--
959
960LOCK TABLES `lime_participants` WRITE;
961/*!40000 ALTER TABLE `lime_participants` DISABLE KEYS */;
962/*!40000 ALTER TABLE `lime_participants` ENABLE KEYS */;
963UNLOCK TABLES;
964
965--
966-- Table structure for table `lime_permissions`
967--
968
969DROP TABLE IF EXISTS `lime_permissions`;
970/*!40101 SET @saved_cs_client = @@character_set_client */;
971/*!40101 SET character_set_client = utf8 */;
972CREATE TABLE `lime_permissions` (
973 `id` int(11) NOT NULL AUTO_INCREMENT,
974 `entity` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
975 `entity_id` int(11) NOT NULL,
976 `uid` int(11) NOT NULL,
977 `permission` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
978 `create_p` int(11) NOT NULL DEFAULT '0',
979 `read_p` int(11) NOT NULL DEFAULT '0',
980 `update_p` int(11) NOT NULL DEFAULT '0',
981 `delete_p` int(11) NOT NULL DEFAULT '0',
982 `import_p` int(11) NOT NULL DEFAULT '0',
983 `export_p` int(11) NOT NULL DEFAULT '0',
984 PRIMARY KEY (`id`),
985 UNIQUE KEY `idxPermissions` (`entity_id`,`entity`,`permission`,`uid`)
986) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
987/*!40101 SET character_set_client = @saved_cs_client */;
988
989--
990-- Dumping data for table `lime_permissions`
991--
992
993LOCK TABLES `lime_permissions` WRITE;
994/*!40000 ALTER TABLE `lime_permissions` DISABLE KEYS */;
995INSERT INTO `lime_permissions` VALUES (1,'global',0,1,'superadmin',0,1,0,0,0,0),(2,'survey',158942,1,'surveyactivation',0,0,1,0,0,0),(3,'survey',158942,1,'surveysettings',0,1,1,0,0,0),(4,'survey',158942,1,'surveylocale',0,1,1,0,0,0),(5,'survey',158942,1,'surveycontent',1,1,1,1,1,1),(6,'survey',158942,1,'quotas',1,1,1,1,0,0),(7,'survey',158942,1,'survey',0,1,0,1,0,0),(8,'survey',158942,1,'tokens',1,1,1,1,1,1),(9,'survey',158942,1,'statistics',0,1,0,0,0,0),(10,'survey',158942,1,'assessments',1,1,1,1,0,0),(11,'survey',158942,1,'responses',1,1,1,1,1,1),(12,'survey',158942,1,'surveysecurity',1,1,1,1,0,0),(13,'survey',158942,1,'translations',0,1,1,0,0,0),(14,'survey',658539,1,'surveyactivation',0,0,1,0,0,0),(15,'survey',658539,1,'surveysettings',0,1,1,0,0,0),(16,'survey',658539,1,'surveylocale',0,1,1,0,0,0),(17,'survey',658539,1,'surveycontent',1,1,1,1,1,1),(18,'survey',658539,1,'quotas',1,1,1,1,0,0),(19,'survey',658539,1,'survey',0,1,0,1,0,0),(20,'survey',658539,1,'tokens',1,1,1,1,1,1),(21,'survey',658539,1,'statistics',0,1,0,0,0,0),(22,'survey',658539,1,'assessments',1,1,1,1,0,0),(23,'survey',658539,1,'responses',1,1,1,1,1,1),(24,'survey',658539,1,'surveysecurity',1,1,1,1,0,0),(25,'survey',658539,1,'translations',0,1,1,0,0,0),(26,'survey',289827,1,'surveyactivation',0,0,1,0,0,0),(27,'survey',289827,1,'surveysettings',0,1,1,0,0,0),(28,'survey',289827,1,'surveylocale',0,1,1,0,0,0),(29,'survey',289827,1,'surveycontent',1,1,1,1,1,1),(30,'survey',289827,1,'quotas',1,1,1,1,0,0),(31,'survey',289827,1,'survey',0,1,0,1,0,0),(32,'survey',289827,1,'tokens',1,1,1,1,1,1),(33,'survey',289827,1,'statistics',0,1,0,0,0,0),(34,'survey',289827,1,'assessments',1,1,1,1,0,0),(35,'survey',289827,1,'responses',1,1,1,1,1,1),(36,'survey',289827,1,'surveysecurity',1,1,1,1,0,0),(37,'survey',289827,1,'translations',0,1,1,0,0,0);
996/*!40000 ALTER TABLE `lime_permissions` ENABLE KEYS */;
997UNLOCK TABLES;
998
999--
1000-- Table structure for table `lime_plugin_settings`
1001--
1002
1003DROP TABLE IF EXISTS `lime_plugin_settings`;
1004/*!40101 SET @saved_cs_client = @@character_set_client */;
1005/*!40101 SET character_set_client = utf8 */;
1006CREATE TABLE `lime_plugin_settings` (
1007 `id` int(11) NOT NULL AUTO_INCREMENT,
1008 `plugin_id` int(11) NOT NULL,
1009 `model` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1010 `model_id` int(11) DEFAULT NULL,
1011 `key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1012 `value` text COLLATE utf8_unicode_ci,
1013 PRIMARY KEY (`id`)
1014) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1015/*!40101 SET character_set_client = @saved_cs_client */;
1016
1017--
1018-- Dumping data for table `lime_plugin_settings`
1019--
1020
1021LOCK TABLES `lime_plugin_settings` WRITE;
1022/*!40000 ALTER TABLE `lime_plugin_settings` DISABLE KEYS */;
1023/*!40000 ALTER TABLE `lime_plugin_settings` ENABLE KEYS */;
1024UNLOCK TABLES;
1025
1026--
1027-- Table structure for table `lime_plugins`
1028--
1029
1030DROP TABLE IF EXISTS `lime_plugins`;
1031/*!40101 SET @saved_cs_client = @@character_set_client */;
1032/*!40101 SET character_set_client = utf8 */;
1033CREATE TABLE `lime_plugins` (
1034 `id` int(11) NOT NULL AUTO_INCREMENT,
1035 `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1036 `active` int(1) NOT NULL DEFAULT '0',
1037 PRIMARY KEY (`id`)
1038) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1039/*!40101 SET character_set_client = @saved_cs_client */;
1040
1041--
1042-- Dumping data for table `lime_plugins`
1043--
1044
1045LOCK TABLES `lime_plugins` WRITE;
1046/*!40000 ALTER TABLE `lime_plugins` DISABLE KEYS */;
1047INSERT INTO `lime_plugins` VALUES (1,'Authdb',1);
1048/*!40000 ALTER TABLE `lime_plugins` ENABLE KEYS */;
1049UNLOCK TABLES;
1050
1051--
1052-- Table structure for table `lime_question_attributes`
1053--
1054
1055DROP TABLE IF EXISTS `lime_question_attributes`;
1056/*!40101 SET @saved_cs_client = @@character_set_client */;
1057/*!40101 SET character_set_client = utf8 */;
1058CREATE TABLE `lime_question_attributes` (
1059 `qaid` int(11) NOT NULL AUTO_INCREMENT,
1060 `qid` int(11) NOT NULL DEFAULT '0',
1061 `attribute` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1062 `value` text COLLATE utf8_unicode_ci,
1063 `language` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
1064 PRIMARY KEY (`qaid`),
1065 KEY `question_attributes_idx2` (`qid`),
1066 KEY `question_attributes_idx3` (`attribute`)
1067) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1068/*!40101 SET character_set_client = @saved_cs_client */;
1069
1070--
1071-- Dumping data for table `lime_question_attributes`
1072--
1073
1074LOCK TABLES `lime_question_attributes` WRITE;
1075/*!40000 ALTER TABLE `lime_question_attributes` DISABLE KEYS */;
1076INSERT INTO `lime_question_attributes` VALUES (1,1,'display_columns','2',NULL),(2,1,'other_comment_mandatory','1',NULL),(3,1,'other_replace_text','Otro. Cuál?','es'),(4,6,'display_columns','2',NULL),(5,7,'other_replace_text','Otro. Cuál?','es'),(6,9,'display_columns','3',NULL),(7,13,'display_columns','4',NULL),(8,14,'text_input_width','35',NULL),(9,66,'max_num_value_n','99',NULL),(10,66,'maximum_chars','2',NULL),(11,66,'min_num_value_n','10',NULL),(12,66,'num_value_int_only','1',NULL),(13,73,'maximum_chars','13',NULL),(14,73,'num_value_int_only','1',NULL),(16,75,'maximum_chars','100',NULL),(17,88,'max_num_value_n','99',NULL),(18,88,'maximum_chars','2',NULL),(19,88,'min_num_value_n','10',NULL),(20,88,'num_value_int_only','1',NULL),(21,94,'maximum_chars','13',NULL),(22,94,'num_value_int_only','1',NULL),(23,96,'maximum_chars','100',NULL);
1077/*!40000 ALTER TABLE `lime_question_attributes` ENABLE KEYS */;
1078UNLOCK TABLES;
1079
1080--
1081-- Table structure for table `lime_questions`
1082--
1083
1084DROP TABLE IF EXISTS `lime_questions`;
1085/*!40101 SET @saved_cs_client = @@character_set_client */;
1086/*!40101 SET character_set_client = utf8 */;
1087CREATE TABLE `lime_questions` (
1088 `qid` int(11) NOT NULL AUTO_INCREMENT,
1089 `parent_qid` int(11) NOT NULL DEFAULT '0',
1090 `sid` int(11) NOT NULL DEFAULT '0',
1091 `gid` int(11) NOT NULL DEFAULT '0',
1092 `type` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'T',
1093 `title` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1094 `question` text COLLATE utf8_unicode_ci NOT NULL,
1095 `preg` text COLLATE utf8_unicode_ci,
1096 `help` text COLLATE utf8_unicode_ci,
1097 `other` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1098 `mandatory` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1099 `question_order` int(11) NOT NULL,
1100 `language` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
1101 `scale_id` int(11) NOT NULL DEFAULT '0',
1102 `same_default` int(11) NOT NULL DEFAULT '0' COMMENT 'Saves if user set to use the same default value across languages in default options dialog',
1103 `relevance` text COLLATE utf8_unicode_ci,
1104 PRIMARY KEY (`qid`,`language`),
1105 KEY `questions_idx2` (`sid`),
1106 KEY `questions_idx3` (`gid`),
1107 KEY `questions_idx4` (`type`),
1108 KEY `parent_qid_idx` (`parent_qid`)
1109) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1110/*!40101 SET character_set_client = @saved_cs_client */;
1111
1112--
1113-- Dumping data for table `lime_questions`
1114--
1115
1116LOCK TABLES `lime_questions` WRITE;
1117/*!40000 ALTER TABLE `lime_questions` DISABLE KEYS */;
1118INSERT INTO `lime_questions` VALUES (1,0,158942,1,'L','a',' ¿Para qué utiliza usted la página de Contratación a la Vista?','','','Y','Y',0,'es',0,0,'1'),(2,0,158942,2,'F','b','¿Cómo califica la calidad general del Portal de Contratación a la Vista respecto a:','','','N','N',1,'es',0,0,'1'),(3,0,158942,2,'F','c','¿Qué tan de acuerdo está usted en considerar que el Portal Contratación a la Vista tiene... ','','','N','N',2,'es',0,0,'1'),(4,0,158942,3,'F','d','Usted consulta la pagina de Contratación a la Vista, para','','','N','N',0,'es',0,0,'1'),(5,0,158942,3,'S','e','Otra. Cuál?','','','N','N',1,'es',0,0,'((158942X3X47.NAOK == \"1\"))'),(6,0,158942,3,'L','f','¿Con qué frecuencia consulta la pagina de Contratación a la Vista?','','','N','N',2,'es',0,0,'1'),(7,0,158942,4,'M','g','¿Tiene usted alguna sugerencia para mejorar la calidad del Portal de Contratación a la Vista y que expectativas tiene? ','','','Y','N',0,'es',0,0,'1'),(8,0,158942,5,'N','i','Edad','','','N','N',0,'es',0,0,'1'),(9,0,158942,5,'L','j',' ¿Cuál es el estrato que aparece en la factura de servicios de energÃa?','','','N','N',1,'es',0,0,'1'),(10,0,158942,5,'!','k','¿Cuál es su estado civil?','','','N','N',2,'es',0,0,'1'),(11,0,158942,5,'!','l','¿Cuál es su principal ocupación o actividad económica?','','','N','N',3,'es',0,0,'1'),(12,0,158942,5,'!','m','¿Cuál es su máximo Nivel educativo alcanzado?','','','N','N',4,'es',0,0,'1'),(13,0,158942,5,'L','n','Sexo','','','N','N',5,'es',0,0,'1'),(14,0,158942,5,'Q','o','<b>Datos entrevistado</b>','','','N','N',6,'es',0,0,'1'),(15,2,158942,2,'F','SQ001','Publicación oportuna de la información',NULL,NULL,'N','N',1,'es',0,0,NULL),(16,2,158942,2,'F','SQ002','Utilidad del contenido',NULL,NULL,'N','N',2,'es',0,0,NULL),(17,2,158942,2,'F','SQ003','El envÃo de correos avisando la apertura de los procesos',NULL,NULL,'N','N',3,'es',0,0,NULL),(127,0,158942,2,'L','w','Cómo califica la calidad general del portal de contratación a la vista?','','','N','N',0,'es',0,0,'1'),(19,3,158942,2,'F','1','Facilidad de acceso a la página',NULL,NULL,'N','N',1,'es',0,0,NULL),(20,3,158942,2,'F','2','Rapidez de acceso a la página',NULL,NULL,'N','N',2,'es',0,0,NULL),(21,3,158942,2,'F','3','Facilidad de consulta',NULL,NULL,'N','N',3,'es',0,0,NULL),(22,4,158942,3,'F','1','Procesos de mÃnima cuantÃa',NULL,NULL,'N','N',1,'es',0,0,NULL),(23,4,158942,3,'F','2','Procesos de Licitaciones',NULL,NULL,'N','N',2,'es',0,0,NULL),(24,4,158942,3,'F','3','Proceso de menor cuantÃa',NULL,NULL,'N','N',3,'es',0,0,NULL),(25,4,158942,3,'F','4','Concurso de Méritos Sistema Abierto',NULL,NULL,'N','N',4,'es',0,0,NULL),(26,4,158942,3,'F','5','Concurso de Méritos Lista Corta',NULL,NULL,'N','N',5,'es',0,0,NULL),(27,4,158942,3,'F','6','Subasta',NULL,NULL,'N','N',6,'es',0,0,NULL),(28,4,158942,3,'F','7','Otra ¿Cuál?',NULL,NULL,'N','N',7,'es',0,0,NULL),(29,4,158942,3,'F','8','Ns/Nr',NULL,NULL,'N','N',8,'es',0,0,NULL),(30,7,158942,4,'M','1','Ãgil',NULL,NULL,'N','N',1,'es',0,0,NULL),(31,7,158942,4,'M','2','Mejor tecnologÃa',NULL,NULL,'N','N',2,'es',0,0,NULL),(32,7,158942,4,'M','3','Mantener la pagina actualizada',NULL,NULL,'N','N',3,'es',0,0,NULL),(33,7,158942,4,'M','4','Ninguna',NULL,NULL,'N','N',4,'es',0,0,NULL),(34,7,158942,4,'M','5','Más opciones de servicios',NULL,NULL,'N','N',5,'es',0,0,NULL),(35,7,158942,4,'M','6','No sabe/no responde',NULL,NULL,'N','N',6,'es',0,0,NULL),(36,14,158942,5,'Q','SQ001','Nombre',NULL,NULL,'N','N',1,'es',0,0,NULL),(37,14,158942,5,'Q','1','Localidad de residencia',NULL,NULL,'N','N',2,'es',0,0,NULL),(38,14,158942,5,'Q','2','Teléfono de contacto',NULL,NULL,'N','N',3,'es',0,0,NULL),(39,14,158942,5,'Q','3','Correo electrónico',NULL,NULL,'N','N',4,'es',0,0,NULL),(40,0,658539,6,'L','a','¿Conoce o ha consultado la GuÃa de trámites y servicios?','','','N','N',0,'es',0,0,'1'),(41,0,658539,7,'L','b','¿Cómo califica la calidad general del servicio que le presta la GuÃa de trámites y servicios?','','','N','N',0,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(42,0,658539,8,'F','c',' EspecÃficamente, ¿Cómo califica usted?','','','N','N',0,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(44,42,658539,8,'T','1','Facilidad para acceder a la guÃa de trámites y servicios',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(45,42,658539,8,'T','2','Facilidad para encontrar la información que usted necesitaba',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(46,42,658539,8,'T','3','La pagina WEB ',NULL,NULL,'N',NULL,3,'es',0,0,NULL),(47,42,658539,8,'T','4','Ubicar fácilmente la información requerida ',NULL,NULL,'N',NULL,4,'es',0,0,NULL),(48,42,658539,8,'T','5','Utilidad de los pasos para obtener lo que quiere',NULL,NULL,'N',NULL,5,'es',0,0,NULL),(49,42,658539,8,'T','6','Información actualizada',NULL,NULL,'N',NULL,6,'es',0,0,NULL),(50,42,658539,8,'T','7','La Oferta de trámites y en lÃnea publicados en la guÃa ',NULL,NULL,'N',NULL,7,'es',0,0,NULL),(51,0,658539,8,'Y','e','¿En el último año, ¿usted ha ingresado a la  GuÃa de Trámites de Servicios?','','','N','N',1,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(52,0,658539,8,'F','f','Cómo la califica los siguientes puntos','','','N','N',2,'es',0,0,'((658539X6X40.NAOK == \"1\") and (658539X8X51.NAOK == \"Y\"))'),(54,52,658539,8,'T','1','Calidad general de la GuÃa de Tramites y Servicios ',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(55,52,658539,8,'T','2','Utilidad de los pasos para obtener lo que quiere ',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(56,52,658539,8,'T','3','El estar actualizada ',NULL,NULL,'N',NULL,3,'es',0,0,NULL),(57,0,658539,9,'Y','g','¿Conoce o ha consultado El Mapa Callejero?','','','N','N',0,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(58,0,658539,9,'Y','i','¿En lo corrido del año, ha ingresado al Mapa Callejero?','','','N','N',1,'es',0,0,'((658539X6X40.NAOK == \"1\") and (658539X9X57.NAOK == \"Y\"))'),(59,0,658539,9,'F','j','¿Cómo califia los siguientes aspectos?','','','N','N',2,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(61,59,658539,9,'T','1','Calidad general del Mapa Callejero',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(62,59,658539,9,'T','2','Estar bien en la ubicación de la malla vial ',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(63,59,658539,9,'T','3','El estar actualizado',NULL,NULL,'N',NULL,3,'es',0,0,NULL),(64,0,658539,10,'F','k','EspecÃficamente, ¿Cómo califica el Portal Bogotá en cuanto a ...  ','','','N','N',0,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(65,0,658539,10,'L','l','¿Qué tipo de información o servicio le gustarÃa encontrar en la GuÃa de trámites y servicios? ','','','N','N',1,'es',0,0,'((658539X6X40.NAOK == \"1\"))'),(66,0,658539,11,'N','m','Edad','','','N','N',1,'es',0,0,'1'),(67,0,658539,11,'!','n','¿Cuál es el estrato que aparece en la factura de servicios de energÃa?','','','N','N',2,'es',0,0,'1'),(68,0,658539,11,'!','o','¿Cuál es su estado civil?','','','N','N',3,'es',0,0,'1'),(69,0,658539,11,'!','p','¿Cuál es su principal ocupación o actividad económica?','','','N','N',4,'es',0,0,'1'),(70,0,658539,11,'!','q','¿Cuál es su máximo Nivel educativo alcanzado?   (Leer alternativas)','','','N','N',5,'es',0,0,'1'),(77,64,658539,10,'T','SQ001','Facilidad para encontrar lo que usted necesita',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(72,0,658539,11,'!','s','Localidad de residencia','','','N','N',6,'es',0,0,'1'),(73,0,658539,11,'N','t','Teléfono de contacto','','','N','N',7,'es',0,0,'1'),(74,0,658539,11,'S','u','Correo electrónico','/^(\\w[-._+\\w]*\\w@\\w[-._\\w]*\\w\\.\\w{2,3})$/','','N','N',8,'es',0,0,'1'),(126,64,658539,10,'T','SQ003','Diseño y diagramación',NULL,NULL,'N',NULL,3,'es',0,0,NULL),(75,0,658539,11,'Q','v','Nombre','','','N','N',0,'es',0,0,'1'),(76,75,658539,11,'T','SQ001','Nombre',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(125,64,658539,10,'T','SQ002','Utilidad de la información',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(112,0,289827,18,'L','a','¿Cómo califica la calidad general del servicio que le presta el Portal Bogotá?','','','N','N',0,'es',0,0,'1'),(113,0,289827,19,'F','b','EspecÃficamente, ¿Cómo califica usted: ','','','N','N',0,'es',0,0,'1'),(115,113,289827,19,'T','1','Utilidad de la información',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(116,113,289827,19,'T','2','Información actualizada',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(117,0,289827,20,'F','c','¿Qué tan de acuerdo está usted en considerar que el portal Bogotá tiene…   ','','','N','N',0,'es',0,0,'1'),(119,117,289827,20,'T','1','Facilidad para acceder al Portal ',NULL,NULL,'N',NULL,1,'es',0,0,NULL),(120,117,289827,20,'T','2','Facilidad para encontrar lo que usted necesita ',NULL,NULL,'N',NULL,2,'es',0,0,NULL),(121,117,289827,20,'T','3','Conexión a otros sitios de Interés',NULL,NULL,'N',NULL,3,'es',0,0,NULL),(122,117,289827,20,'T','4','Diseño y diagramación',NULL,NULL,'N',NULL,4,'es',0,0,NULL),(123,0,289827,21,'L','d','¿Cuál es la información del portal de Bogotá que consulta con mayor frecuencia?','','','N','N',0,'es',0,0,'1'),(124,0,289827,21,'L','e','La información que obtuvo le sirvio para...','','','N','N',1,'es',0,0,'1'),(88,0,289827,17,'N','m','Edad','','','N','N',1,'es',0,0,'1'),(89,0,289827,17,'!','n','¿Cuál es el estrato que aparece en la factura de servicios de energÃa?','','','N','N',2,'es',0,0,'1'),(90,0,289827,17,'!','o','¿Cuál es su estado civil?','','','N','N',3,'es',0,0,'1'),(91,0,289827,17,'!','p','¿Cuál es su principal ocupación o actividad económica?','','','N','N',4,'es',0,0,'1'),(92,0,289827,17,'!','q','¿Cuál es su máximo Nivel educativo alcanzado?   (Leer alternativas)','','','N','N',5,'es',0,0,'1'),(93,0,289827,17,'!','s','Localidad de residencia','','','N','N',6,'es',0,0,'1'),(94,0,289827,17,'N','t','Teléfono de contacto','','','N','N',7,'es',0,0,'1'),(95,0,289827,17,'S','u','Correo electrónico','/^(\\w[-._+\\w]*\\w@\\w[-._\\w]*\\w\\.\\w{2,3})$/','','N','N',8,'es',0,0,'1'),(96,0,289827,17,'Q','v','Nombre','','','N','N',0,'es',0,0,'1'),(110,96,289827,17,'T','SQ001','Nombre',NULL,NULL,'N','N',1,'es',0,0,NULL);
1119/*!40000 ALTER TABLE `lime_questions` ENABLE KEYS */;
1120UNLOCK TABLES;
1121
1122--
1123-- Table structure for table `lime_quota`
1124--
1125
1126DROP TABLE IF EXISTS `lime_quota`;
1127/*!40101 SET @saved_cs_client = @@character_set_client */;
1128/*!40101 SET character_set_client = utf8 */;
1129CREATE TABLE `lime_quota` (
1130 `id` int(11) NOT NULL AUTO_INCREMENT,
1131 `sid` int(11) DEFAULT NULL,
1132 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1133 `qlimit` int(11) DEFAULT NULL,
1134 `action` int(11) DEFAULT NULL,
1135 `active` int(11) NOT NULL DEFAULT '1',
1136 `autoload_url` int(11) NOT NULL DEFAULT '0',
1137 PRIMARY KEY (`id`),
1138 KEY `quota_idx2` (`sid`)
1139) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1140/*!40101 SET character_set_client = @saved_cs_client */;
1141
1142--
1143-- Dumping data for table `lime_quota`
1144--
1145
1146LOCK TABLES `lime_quota` WRITE;
1147/*!40000 ALTER TABLE `lime_quota` DISABLE KEYS */;
1148INSERT INTO `lime_quota` VALUES (1,158942,'limite',100,1,1,0),(2,658539,'cierre',100,1,1,0),(3,289827,'cierre',100,1,1,0);
1149/*!40000 ALTER TABLE `lime_quota` ENABLE KEYS */;
1150UNLOCK TABLES;
1151
1152--
1153-- Table structure for table `lime_quota_languagesettings`
1154--
1155
1156DROP TABLE IF EXISTS `lime_quota_languagesettings`;
1157/*!40101 SET @saved_cs_client = @@character_set_client */;
1158/*!40101 SET character_set_client = utf8 */;
1159CREATE TABLE `lime_quota_languagesettings` (
1160 `quotals_id` int(11) NOT NULL AUTO_INCREMENT,
1161 `quotals_quota_id` int(11) NOT NULL DEFAULT '0',
1162 `quotals_language` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
1163 `quotals_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1164 `quotals_message` text COLLATE utf8_unicode_ci NOT NULL,
1165 `quotals_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1166 `quotals_urldescrip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1167 PRIMARY KEY (`quotals_id`)
1168) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1169/*!40101 SET character_set_client = @saved_cs_client */;
1170
1171--
1172-- Dumping data for table `lime_quota_languagesettings`
1173--
1174
1175LOCK TABLES `lime_quota_languagesettings` WRITE;
1176/*!40000 ALTER TABLE `lime_quota_languagesettings` DISABLE KEYS */;
1177INSERT INTO `lime_quota_languagesettings` VALUES (1,1,'es','limite','Disculpe, sus respuestas han excedido la cuota definida para esta encuesta.','',''),(2,2,'es','cierre','Disculpe, sus respuestas han excedido la cuota definida para esta encuesta.','',''),(3,3,'es','cierre','Disculpe, sus respuestas han excedido la cuota definida para esta encuesta.','','');
1178/*!40000 ALTER TABLE `lime_quota_languagesettings` ENABLE KEYS */;
1179UNLOCK TABLES;
1180
1181--
1182-- Table structure for table `lime_quota_members`
1183--
1184
1185DROP TABLE IF EXISTS `lime_quota_members`;
1186/*!40101 SET @saved_cs_client = @@character_set_client */;
1187/*!40101 SET character_set_client = utf8 */;
1188CREATE TABLE `lime_quota_members` (
1189 `id` int(11) NOT NULL AUTO_INCREMENT,
1190 `sid` int(11) DEFAULT NULL,
1191 `qid` int(11) DEFAULT NULL,
1192 `quota_id` int(11) DEFAULT NULL,
1193 `code` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
1194 PRIMARY KEY (`id`),
1195 UNIQUE KEY `sid` (`sid`,`qid`,`quota_id`,`code`)
1196) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1197/*!40101 SET character_set_client = @saved_cs_client */;
1198
1199--
1200-- Dumping data for table `lime_quota_members`
1201--
1202
1203LOCK TABLES `lime_quota_members` WRITE;
1204/*!40000 ALTER TABLE `lime_quota_members` DISABLE KEYS */;
1205/*!40000 ALTER TABLE `lime_quota_members` ENABLE KEYS */;
1206UNLOCK TABLES;
1207
1208--
1209-- Table structure for table `lime_saved_control`
1210--
1211
1212DROP TABLE IF EXISTS `lime_saved_control`;
1213/*!40101 SET @saved_cs_client = @@character_set_client */;
1214/*!40101 SET character_set_client = utf8 */;
1215CREATE TABLE `lime_saved_control` (
1216 `scid` int(11) NOT NULL AUTO_INCREMENT,
1217 `sid` int(11) NOT NULL DEFAULT '0',
1218 `srid` int(11) NOT NULL DEFAULT '0',
1219 `identifier` text COLLATE utf8_unicode_ci NOT NULL,
1220 `access_code` text COLLATE utf8_unicode_ci NOT NULL,
1221 `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
1222 `ip` text COLLATE utf8_unicode_ci NOT NULL,
1223 `saved_thisstep` text COLLATE utf8_unicode_ci NOT NULL,
1224 `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1225 `saved_date` datetime NOT NULL,
1226 `refurl` text COLLATE utf8_unicode_ci,
1227 PRIMARY KEY (`scid`),
1228 KEY `saved_control_idx2` (`sid`)
1229) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1230/*!40101 SET character_set_client = @saved_cs_client */;
1231
1232--
1233-- Dumping data for table `lime_saved_control`
1234--
1235
1236LOCK TABLES `lime_saved_control` WRITE;
1237/*!40000 ALTER TABLE `lime_saved_control` DISABLE KEYS */;
1238/*!40000 ALTER TABLE `lime_saved_control` ENABLE KEYS */;
1239UNLOCK TABLES;
1240
1241--
1242-- Table structure for table `lime_sessions`
1243--
1244
1245DROP TABLE IF EXISTS `lime_sessions`;
1246/*!40101 SET @saved_cs_client = @@character_set_client */;
1247/*!40101 SET character_set_client = utf8 */;
1248CREATE TABLE `lime_sessions` (
1249 `id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
1250 `expire` int(11) DEFAULT NULL,
1251 `data` longblob,
1252 PRIMARY KEY (`id`)
1253) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1254/*!40101 SET character_set_client = @saved_cs_client */;
1255
1256--
1257-- Dumping data for table `lime_sessions`
1258--
1259
1260LOCK TABLES `lime_sessions` WRITE;
1261/*!40000 ALTER TABLE `lime_sessions` DISABLE KEYS */;
1262/*!40000 ALTER TABLE `lime_sessions` ENABLE KEYS */;
1263UNLOCK TABLES;
1264
1265--
1266-- Table structure for table `lime_settings_global`
1267--
1268
1269DROP TABLE IF EXISTS `lime_settings_global`;
1270/*!40101 SET @saved_cs_client = @@character_set_client */;
1271/*!40101 SET character_set_client = utf8 */;
1272CREATE TABLE `lime_settings_global` (
1273 `stg_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1274 `stg_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1275 PRIMARY KEY (`stg_name`)
1276) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1277/*!40101 SET character_set_client = @saved_cs_client */;
1278
1279--
1280-- Dumping data for table `lime_settings_global`
1281--
1282
1283LOCK TABLES `lime_settings_global` WRITE;
1284/*!40000 ALTER TABLE `lime_settings_global` DISABLE KEYS */;
1285INSERT INTO `lime_settings_global` VALUES ('DBVersion','176'),('SessionName','%sC=@X|[h,jFre0=)75c!5./96:hoQesE*2eb/AK;,p/q\"Lz8`^9ukH/#avq4\\fY'),('sitename','Encuestas Alcaldia Mayor'),('siteadminname','Administrador'),('siteadminemail','webmaster@alcaldiabogota.gov.co'),('siteadminbounce','webmaster@alcaldiabogota.gov.co'),('defaultlang','es'),('updateversions','{\"master\":{\"build\":\"140204\",\"versionnumber\":\"2.05+\",\"branch\":\"master\",\"created\":\"2014-02-04 13:24:19\"}}'),('updateavailable','1'),('updatelastcheck','2014-02-04 16:49:23'),('restrictToLanguages',''),('updatecheckperiod','7'),('updatenotification','both'),('defaulthtmleditormode','inline'),('defaultquestionselectormode','default'),('defaulttemplateeditormode','default'),('defaulttemplate','mint_idea'),('admintheme','gringegreen'),('adminthemeiconsize','32'),('emailmethod','mail'),('emailsmtphost',''),('emailsmtppassword',''),('bounceaccounthost',''),('bounceaccounttype','off'),('bounceencryption',''),('bounceaccountuser',''),('bounceaccountpass',''),('emailsmtpssl',''),('emailsmtpdebug','0'),('emailsmtpuser',''),('filterxsshtml','1'),('shownoanswer','1'),('showxquestions','choose'),('showgroupinfo','choose'),('showqnumcode','choose'),('repeatheadings','25'),('maxemails','50'),('iSessionExpirationTime','7200'),('ipInfoDbAPIKey',''),('googleMapsAPIKey',''),('googleanalyticsapikey',''),('googletranslateapikey',''),('force_ssl','neither'),('surveyPreview_require_Auth','1'),('RPCInterface','off'),('rpc_publish_api',''),('timeadjust','+0 minutes'),('usercontrolSameGroupPolicy','1'),('updatebuild','140204'),('updateversion','2.05+');
1286/*!40000 ALTER TABLE `lime_settings_global` ENABLE KEYS */;
1287UNLOCK TABLES;
1288
1289--
1290-- Table structure for table `lime_survey_158942`
1291--
1292
1293DROP TABLE IF EXISTS `lime_survey_158942`;
1294/*!40101 SET @saved_cs_client = @@character_set_client */;
1295/*!40101 SET character_set_client = utf8 */;
1296CREATE TABLE `lime_survey_158942` (
1297 `id` int(11) NOT NULL AUTO_INCREMENT,
1298 `submitdate` datetime DEFAULT NULL,
1299 `lastpage` int(11) DEFAULT NULL,
1300 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
1301 `startdate` datetime NOT NULL,
1302 `datestamp` datetime NOT NULL,
1303 `ipaddr` text COLLATE utf8_unicode_ci,
1304 `refurl` text COLLATE utf8_unicode_ci,
1305 `158942X1X1` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1306 `158942X1X1other` text COLLATE utf8_unicode_ci,
1307 `158942X2X127` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1308 `158942X2X2SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1309 `158942X2X2SQ002` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1310 `158942X2X2SQ003` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1311 `158942X2X31` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1312 `158942X2X32` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1313 `158942X2X33` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1314 `158942X3X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1315 `158942X3X42` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1316 `158942X3X43` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1317 `158942X3X44` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1318 `158942X3X45` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1319 `158942X3X46` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1320 `158942X3X47` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1321 `158942X3X48` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1322 `158942X3X5` text COLLATE utf8_unicode_ci,
1323 `158942X3X6` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1324 `158942X4X71` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1325 `158942X4X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1326 `158942X4X73` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1327 `158942X4X74` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1328 `158942X4X75` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1329 `158942X4X76` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1330 `158942X4X7other` text COLLATE utf8_unicode_ci,
1331 `158942X5X8` decimal(30,10) DEFAULT NULL,
1332 `158942X5X9` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1333 `158942X5X10` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1334 `158942X5X11` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1335 `158942X5X12` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1336 `158942X5X13` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1337 `158942X5X14SQ001` text COLLATE utf8_unicode_ci,
1338 `158942X5X141` text COLLATE utf8_unicode_ci,
1339 `158942X5X142` text COLLATE utf8_unicode_ci,
1340 `158942X5X143` text COLLATE utf8_unicode_ci,
1341 PRIMARY KEY (`id`)
1342) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1343/*!40101 SET character_set_client = @saved_cs_client */;
1344
1345--
1346-- Dumping data for table `lime_survey_158942`
1347--
1348
1349LOCK TABLES `lime_survey_158942` WRITE;
1350/*!40000 ALTER TABLE `lime_survey_158942` DISABLE KEYS */;
1351INSERT INTO `lime_survey_158942` VALUES (6,NULL,1,'es','2014-02-04 20:40:24','2014-02-04 20:40:24','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A4','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'2014-02-05 15:21:26',5,'es','2014-02-05 15:21:26','2014-02-05 15:21:26','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A4','','3','3','3','3','4','4','4','1','','','','','','','',NULL,'2','','','Y','','','','',45.0000000000,'4','1','','4','2','rafael gonzalez','8','n/a','n/a'),(8,'2014-02-05 15:36:19',5,'es','2014-02-05 15:36:19','2014-02-05 15:36:19','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A4','','2','3','4','3','4','5','4','1','2','1','1','1','2','2','',NULL,'2','','','Y','','','','',43.0000000000,'5','1','','5','1','claudia','6','n/a','candrade@gmail'),(9,'2014-02-05 15:46:19',5,'es','2014-02-05 15:46:19','2014-02-05 15:46:19','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','2','3','3','3','5','5','5','2','1','1','1','1','1','','',NULL,'3','','','','','Y','','',33.0000000000,'5','2','7','4','2','alberto','2','n/a','correaa@hotmail.com'),(10,'2014-02-05 16:15:13',5,'es','2014-02-05 16:15:13','2014-02-05 16:15:13','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','4','','3','2','5','5','4','1','2','1','2','','','','',NULL,'4','','','','','Y','','',29.0000000000,'4','2','4','4','1','sandra','16','2613628','n/a'),(11,'2014-02-05 16:15:41',5,'es','2014-02-05 16:15:41','2014-02-05 16:15:41','10.101.70.143','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','1','5','5','5','5','4','4','1','1','1','1','1','1','','',NULL,'1','','Y','Y','','Y','','',35.0000000000,'4','1','7','5','2','ALEXANDER RAMOS','SUBA','4532554','gavela23@gmail.com'),(12,'2014-02-05 17:23:54',5,'es','2014-02-05 17:23:54','2014-02-05 17:23:54','10.101.70.115','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','1','4','5','5','5','4','4','','','1','','','','','',NULL,'1','Y','Y','Y','','','','',33.0000000000,'4','2','1','4','2','Carlos Adolfo','Engativá','',''),(13,'2014-02-05 20:51:43',5,'es','2014-02-05 20:51:43','2014-02-05 20:51:43','10.101.70.115','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A4','','2','4','5','5','5','5','4','1','1','1','1','1','1','','',NULL,'1','','Y','Y','','','','',28.0000000000,'4','1','2','3','2','Francisco GarcÃa','Barrios Unidos','',''),(14,'2014-02-06 14:24:08',5,'es','2014-02-06 14:24:08','2014-02-06 14:24:08','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A3','','2','4','4','4','4','4','4','1','1','1','1','1','1','','',NULL,'2','','','','Y','','','',44.0000000000,'5','3','7','4','1','lucia','siete de agosto','2764828','lrodriguez'),(15,NULL,2,'es','2014-02-06 15:24:36','2014-02-06 15:24:36','192.101.7.23','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es','A1','','2','5','','','5','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,NULL,NULL,'es','2014-02-06 15:24:57','2014-02-06 15:24:57','192.101.7.48','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=158942&lang=es',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1352/*!40000 ALTER TABLE `lime_survey_158942` ENABLE KEYS */;
1353UNLOCK TABLES;
1354
1355--
1356-- Table structure for table `lime_survey_158942_timings`
1357--
1358
1359DROP TABLE IF EXISTS `lime_survey_158942_timings`;
1360/*!40101 SET @saved_cs_client = @@character_set_client */;
1361/*!40101 SET character_set_client = utf8 */;
1362CREATE TABLE `lime_survey_158942_timings` (
1363 `id` int(11) NOT NULL AUTO_INCREMENT,
1364 `interviewtime` float DEFAULT NULL,
1365 `158942X1time` float DEFAULT NULL,
1366 `158942X1X1time` float DEFAULT NULL,
1367 `158942X2time` float DEFAULT NULL,
1368 `158942X2X127time` float DEFAULT NULL,
1369 `158942X2X2time` float DEFAULT NULL,
1370 `158942X2X3time` float DEFAULT NULL,
1371 `158942X3time` float DEFAULT NULL,
1372 `158942X3X4time` float DEFAULT NULL,
1373 `158942X3X5time` float DEFAULT NULL,
1374 `158942X3X6time` float DEFAULT NULL,
1375 `158942X4time` float DEFAULT NULL,
1376 `158942X4X7time` float DEFAULT NULL,
1377 `158942X5time` float DEFAULT NULL,
1378 `158942X5X8time` float DEFAULT NULL,
1379 `158942X5X9time` float DEFAULT NULL,
1380 `158942X5X10time` float DEFAULT NULL,
1381 `158942X5X11time` float DEFAULT NULL,
1382 `158942X5X12time` float DEFAULT NULL,
1383 `158942X5X13time` float DEFAULT NULL,
1384 `158942X5X14time` float DEFAULT NULL,
1385 PRIMARY KEY (`id`)
1386) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1387/*!40101 SET character_set_client = @saved_cs_client */;
1388
1389--
1390-- Dumping data for table `lime_survey_158942_timings`
1391--
1392
1393LOCK TABLES `lime_survey_158942_timings` WRITE;
1394/*!40000 ALTER TABLE `lime_survey_158942_timings` DISABLE KEYS */;
1395INSERT INTO `lime_survey_158942_timings` VALUES (6,1325.45,1325.45,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,174.86,13.05,NULL,14.59,NULL,NULL,NULL,40.5,NULL,NULL,NULL,19.74,NULL,86.98,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,338.7,14.87,NULL,39.02,NULL,NULL,NULL,170.06,NULL,NULL,NULL,13.4,NULL,101.35,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1509.03,9.67,NULL,1322.67,NULL,NULL,NULL,68.35,NULL,NULL,NULL,9.14,NULL,99.2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,567.11,15.51,NULL,65.8,NULL,NULL,NULL,77.87,NULL,NULL,NULL,20.08,NULL,387.85,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1049.07,27.22,NULL,58.49,NULL,NULL,NULL,33.38,NULL,NULL,NULL,845.75,NULL,84.23,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,200.98,37.79,NULL,43.14,NULL,NULL,NULL,28.07,NULL,NULL,NULL,31.33,NULL,60.65,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,153.03,21.28,NULL,32.74,NULL,NULL,NULL,26.87,NULL,NULL,NULL,11.09,NULL,61.05,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,574.93,20.27,NULL,15.93,NULL,NULL,NULL,396.75,NULL,NULL,NULL,38.85,NULL,103.13,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,13.23,6.6,NULL,6.63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1396/*!40000 ALTER TABLE `lime_survey_158942_timings` ENABLE KEYS */;
1397UNLOCK TABLES;
1398
1399--
1400-- Table structure for table `lime_survey_289827`
1401--
1402
1403DROP TABLE IF EXISTS `lime_survey_289827`;
1404/*!40101 SET @saved_cs_client = @@character_set_client */;
1405/*!40101 SET character_set_client = utf8 */;
1406CREATE TABLE `lime_survey_289827` (
1407 `id` int(11) NOT NULL AUTO_INCREMENT,
1408 `submitdate` datetime DEFAULT NULL,
1409 `lastpage` int(11) DEFAULT NULL,
1410 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
1411 `startdate` datetime NOT NULL,
1412 `datestamp` datetime NOT NULL,
1413 `ipaddr` text COLLATE utf8_unicode_ci,
1414 `refurl` text COLLATE utf8_unicode_ci,
1415 `289827X18X112` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1416 `289827X19X1131` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1417 `289827X19X1132` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1418 `289827X20X1171` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1419 `289827X20X1172` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1420 `289827X20X1173` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1421 `289827X20X1174` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1422 `289827X21X123` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1423 `289827X21X124` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1424 `289827X17X96SQ001` text COLLATE utf8_unicode_ci,
1425 `289827X17X88` decimal(30,10) DEFAULT NULL,
1426 `289827X17X89` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1427 `289827X17X90` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1428 `289827X17X91` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1429 `289827X17X92` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1430 `289827X17X93` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1431 `289827X17X94` decimal(30,10) DEFAULT NULL,
1432 `289827X17X95` text COLLATE utf8_unicode_ci,
1433 PRIMARY KEY (`id`)
1434) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1435/*!40101 SET character_set_client = @saved_cs_client */;
1436
1437--
1438-- Dumping data for table `lime_survey_289827`
1439--
1440
1441LOCK TABLES `lime_survey_289827` WRITE;
1442/*!40000 ALTER TABLE `lime_survey_289827` DISABLE KEYS */;
1443INSERT INTO `lime_survey_289827` VALUES (3,'2014-02-05 15:31:37',5,'es','2014-02-05 15:31:37','2014-02-05 15:31:37','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','2','2','2','2','2','2','2','8','1','sara',31.0000000000,'5','3','1','5','6',3008251361.0000000000,'sara123@gmail.com'),(4,'2014-02-05 15:36:02',5,'es','2014-02-05 15:36:02','2014-02-05 15:36:02','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','3','3','3','1','1','1','1','2','6','mario',45.0000000000,'4','2','1','4','7',NULL,''),(5,'2014-02-05 15:37:18',5,'es','2014-02-05 15:37:18','2014-02-05 15:37:18','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','4','3','4','1','1','1','1','5','3','',31.0000000000,'4','1','7','2','3',NULL,''),(6,'2014-02-05 15:38:50',5,'es','2014-02-05 15:38:50','2014-02-05 15:38:50','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','1','1','1','1','1','1','1','11','','daniel',36.0000000000,'4','1','2','2','7',NULL,''),(7,'2014-02-05 15:39:47',5,'es','2014-02-05 15:39:47','2014-02-05 15:39:47','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','3','3','4','2','2','2','3','8','','gina',29.0000000000,'3','1','2','2','14',NULL,''),(8,'2014-02-05 15:40:52',5,'es','2014-02-05 15:40:52','2014-02-05 15:40:52','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','2','1','3','1','2','2','1','9','6','pedro',28.0000000000,'4','1','2','2','4',NULL,''),(9,'2014-02-05 15:42:00',5,'es','2014-02-05 15:42:00','2014-02-05 15:42:00','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','3','3','3','2','2','2','2','7','','martha',30.0000000000,'3','2','4','2','13',NULL,''),(10,'2014-02-05 15:43:27',5,'es','2014-02-05 15:43:27','2014-02-05 15:43:27','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','4','4','4','3','3','3','3','','','yolima',22.0000000000,'3','1','7','2','7',NULL,''),(11,'2014-02-05 15:44:31',5,'es','2014-02-05 15:44:31','2014-02-05 15:44:31','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','','4','4','2','2','3','3','8','','guillermo',25.0000000000,'4','1','7','3','14',NULL,''),(12,'2014-02-05 15:45:31',5,'es','2014-02-05 15:45:31','2014-02-05 15:45:31','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','4','4','3','3','3','3','3','8','','milena',26.0000000000,'3','1','8','2','3',NULL,''),(13,'2014-02-05 15:46:34',5,'es','2014-02-05 15:46:34','2014-02-05 15:46:34','10.101.70.180','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','2','2','3','2','2','2','2','3','5','carlos',39.0000000000,'4','2','7','3','2',NULL,''),(14,'2014-02-05 15:50:01',5,'es','2014-02-05 15:50:01','2014-02-05 15:50:01','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','4','3','','3','3','3','4','6','3','',NULL,'4','1','2','4','4',NULL,''),(15,'2014-02-06 13:32:20',5,'es','2014-02-06 13:32:20','2014-02-06 13:32:20','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','2','2','3','2','1','1','2','2','2','gonzalo',27.0000000000,'3','1','4','3','5',7782090.0000000000,'mgonzalo@gmail.co'),(16,'2014-02-06 13:46:23',5,'es','2014-02-06 13:46:23','2014-02-06 13:46:23','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','3','3','3','2','2','2','2','7','7','samuel',34.0000000000,'4','2','1','','',3205732488.0000000000,'srincon@hotmail.com'),(17,'2014-02-06 14:33:57',5,'es','2014-02-06 14:33:57','2014-02-06 14:33:57','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','2','3','3','2','2','2','2','2','3','carlos',29.0000000000,'4','1','7','3','7',7903020.0000000000,'ccarlos@hotmail.com'),(18,NULL,2,'es','2014-02-06 16:44:49','2014-02-06 16:44:49','10.101.50.162','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=289827&lang=es','4','1','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1444/*!40000 ALTER TABLE `lime_survey_289827` ENABLE KEYS */;
1445UNLOCK TABLES;
1446
1447--
1448-- Table structure for table `lime_survey_289827_timings`
1449--
1450
1451DROP TABLE IF EXISTS `lime_survey_289827_timings`;
1452/*!40101 SET @saved_cs_client = @@character_set_client */;
1453/*!40101 SET character_set_client = utf8 */;
1454CREATE TABLE `lime_survey_289827_timings` (
1455 `id` int(11) NOT NULL AUTO_INCREMENT,
1456 `interviewtime` float DEFAULT NULL,
1457 `289827X18time` float DEFAULT NULL,
1458 `289827X18X112time` float DEFAULT NULL,
1459 `289827X19time` float DEFAULT NULL,
1460 `289827X19X113time` float DEFAULT NULL,
1461 `289827X20time` float DEFAULT NULL,
1462 `289827X20X117time` float DEFAULT NULL,
1463 `289827X21time` float DEFAULT NULL,
1464 `289827X21X123time` float DEFAULT NULL,
1465 `289827X21X124time` float DEFAULT NULL,
1466 `289827X17time` float DEFAULT NULL,
1467 `289827X17X96time` float DEFAULT NULL,
1468 `289827X17X88time` float DEFAULT NULL,
1469 `289827X17X89time` float DEFAULT NULL,
1470 `289827X17X90time` float DEFAULT NULL,
1471 `289827X17X91time` float DEFAULT NULL,
1472 `289827X17X92time` float DEFAULT NULL,
1473 `289827X17X93time` float DEFAULT NULL,
1474 `289827X17X94time` float DEFAULT NULL,
1475 `289827X17X95time` float DEFAULT NULL,
1476 PRIMARY KEY (`id`)
1477) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1478/*!40101 SET character_set_client = @saved_cs_client */;
1479
1480--
1481-- Dumping data for table `lime_survey_289827_timings`
1482--
1483
1484LOCK TABLES `lime_survey_289827_timings` WRITE;
1485/*!40000 ALTER TABLE `lime_survey_289827_timings` DISABLE KEYS */;
1486INSERT INTO `lime_survey_289827_timings` VALUES (3,170.07,13.36,NULL,16.46,NULL,14.37,NULL,17.65,NULL,NULL,108.23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,67.79,5.8,NULL,5.09,NULL,7.29,NULL,10.91,NULL,NULL,38.7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,50.26,4.12,NULL,4.12,NULL,11.11,NULL,7.3,NULL,NULL,23.61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,49.97,4.01,NULL,3.29,NULL,5.49,NULL,8.46,NULL,NULL,28.72,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,60.1,4.7,NULL,4.62,NULL,6.36,NULL,11.45,NULL,NULL,32.97,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,61.79,7.26,NULL,4.38,NULL,5.93,NULL,13.5,NULL,NULL,30.72,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,50.92,3.92,NULL,3.76,NULL,5.36,NULL,7.63,NULL,NULL,30.25,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,58.72,3.79,NULL,4.22,NULL,6.23,NULL,8.06,NULL,NULL,36.42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,54.86,4.23,NULL,4.04,NULL,5.52,NULL,7.64,NULL,NULL,33.43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,56.67,4.04,NULL,3.9,NULL,4.44,NULL,5.76,NULL,NULL,38.53,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,53.57,3.47,NULL,7.21,NULL,4.31,NULL,7.64,NULL,NULL,30.94,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,124.64,11.52,NULL,8.21,NULL,44.48,NULL,21.41,NULL,NULL,39.02,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,225.87,4.9,NULL,8.84,NULL,10.39,NULL,32.09,NULL,NULL,169.65,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,952.04,5,NULL,7.9,NULL,8.82,NULL,36.28,NULL,NULL,894.04,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,196.66,4.99,NULL,9.42,NULL,19.11,NULL,34.76,NULL,NULL,128.38,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,12.86,3.84,NULL,9.02,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1487/*!40000 ALTER TABLE `lime_survey_289827_timings` ENABLE KEYS */;
1488UNLOCK TABLES;
1489
1490--
1491-- Table structure for table `lime_survey_658539`
1492--
1493
1494DROP TABLE IF EXISTS `lime_survey_658539`;
1495/*!40101 SET @saved_cs_client = @@character_set_client */;
1496/*!40101 SET character_set_client = utf8 */;
1497CREATE TABLE `lime_survey_658539` (
1498 `id` int(11) NOT NULL AUTO_INCREMENT,
1499 `submitdate` datetime DEFAULT NULL,
1500 `lastpage` int(11) DEFAULT NULL,
1501 `startlanguage` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
1502 `startdate` datetime NOT NULL,
1503 `datestamp` datetime NOT NULL,
1504 `ipaddr` text COLLATE utf8_unicode_ci,
1505 `refurl` text COLLATE utf8_unicode_ci,
1506 `658539X6X40` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1507 `658539X7X41` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1508 `658539X8X421` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1509 `658539X8X422` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1510 `658539X8X423` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1511 `658539X8X424` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1512 `658539X8X425` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1513 `658539X8X426` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1514 `658539X8X427` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1515 `658539X8X51` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1516 `658539X8X521` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1517 `658539X8X522` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1518 `658539X8X523` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1519 `658539X9X57` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1520 `658539X9X58` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1521 `658539X9X591` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1522 `658539X9X592` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1523 `658539X9X593` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1524 `658539X10X64SQ001` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1525 `658539X10X64SQ002` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1526 `658539X10X64SQ003` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1527 `658539X10X65` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1528 `658539X11X75SQ001` text COLLATE utf8_unicode_ci,
1529 `658539X11X66` decimal(30,10) DEFAULT NULL,
1530 `658539X11X67` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1531 `658539X11X68` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1532 `658539X11X69` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1533 `658539X11X70` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1534 `658539X11X72` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1535 `658539X11X73` decimal(30,10) DEFAULT NULL,
1536 `658539X11X74` text COLLATE utf8_unicode_ci,
1537 PRIMARY KEY (`id`)
1538) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1539/*!40101 SET character_set_client = @saved_cs_client */;
1540
1541--
1542-- Dumping data for table `lime_survey_658539`
1543--
1544
1545LOCK TABLES `lime_survey_658539` WRITE;
1546/*!40000 ALTER TABLE `lime_survey_658539` DISABLE KEYS */;
1547INSERT INTO `lime_survey_658539` VALUES (3,'2014-02-04 13:37:59',6,'es','2014-02-04 13:37:59','2014-02-04 13:37:59','10.101.70.145','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','2','2','2','1','1','1','2','Y','1','1','1','Y','Y','1','1','1','1','1','1','1','',NULL,'','','','','',NULL,''),(4,'2014-02-05 15:29:25',6,'es','2014-02-05 15:29:25','2014-02-05 15:29:25','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','1','2','1','2','1','1','1','1','Y','1','1','1','Y','Y','1','1','1','4','4','5','2','Patricia Campos',40.0000000000,'5','2','1','5','19',3813000.0000000000,''),(5,'2014-02-05 15:30:34',6,'es','2014-02-05 15:30:34','2014-02-05 15:30:34','10.101.70.112','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','1','1','1','3','1','1','2','1','Y','1','1','2','Y','Y','1','1','2','3','3','5','','',NULL,'','','','','',NULL,''),(6,'2014-02-05 15:44:17',6,'es','2014-02-05 15:44:17','2014-02-05 15:44:17','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','1','1','1','1','1','1','1','1','Y','1','1','1','Y','Y','1','1','1','2','3','3','2','',35.0000000000,'6','1','1','4','17',NULL,''),(7,'2014-02-05 15:46:47',6,'es','2014-02-05 15:46:47','2014-02-05 15:46:47','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','1','2','1','1','2','1','1','1','Y','1','1','1','Y','Y','1','1','1','3','3','4','1','',57.0000000000,'5','3','7','5','19',NULL,''),(8,'2014-02-05 16:25:22',6,'es','2014-02-05 16:25:22','2014-02-05 16:25:22','10.101.65.159','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','2','2','2','2','2','2','2','Y','2','2','2','Y','Y','2','2','2','2','2','2','1','julia',31.0000000000,'4','2','7','3','4',3457011.0000000000,'gjulia@hotmail.com'),(9,'2014-02-05 19:36:09',6,'es','2014-02-05 19:36:09','2014-02-05 19:36:09','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','2','1','2','2','2','1','1','Y','1','1','1','Y','Y','1','2','1','3','3','3','1','',NULL,'6','3','5','5','19',NULL,''),(10,'2014-02-05 19:38:30',6,'es','2014-02-05 19:38:30','2014-02-05 19:38:30','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','2','1','3','1','2','1','2','Y','2','2','2','Y','Y','1','1','1','4','3','5','3','',25.0000000000,'3','1','2','2','15',2356875.0000000000,''),(11,'2014-02-05 21:31:04',6,'es','2014-02-05 21:31:04','2014-02-05 21:31:04','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','2','2','2','1','1','1','1','Y','2','1','1','Y','Y','1','1','1','4','3','5','1','MARIA DEL SOCORRO GONZALEZ',37.0000000000,'5','3','3','3','15',5685362.0000000000,''),(12,'2014-02-06 13:34:39',6,'es','2014-02-06 13:34:39','2014-02-06 13:34:39','10.101.70.113','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1','2','3','2','3','2','1','1','1','Y','1','1','1','Y','Y','1','1','1','4','4','5','2','',43.0000000000,'4','3','','5','15',NULL,''),(13,NULL,1,'es','2014-02-06 16:43:44','2014-02-06 16:43:44','10.101.50.162','http://burstpage.alcaldiabogota.gov.co/encuestas/index.php?r=survey/index&sid=658539&lang=es','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1548/*!40000 ALTER TABLE `lime_survey_658539` ENABLE KEYS */;
1549UNLOCK TABLES;
1550
1551--
1552-- Table structure for table `lime_survey_658539_timings`
1553--
1554
1555DROP TABLE IF EXISTS `lime_survey_658539_timings`;
1556/*!40101 SET @saved_cs_client = @@character_set_client */;
1557/*!40101 SET character_set_client = utf8 */;
1558CREATE TABLE `lime_survey_658539_timings` (
1559 `id` int(11) NOT NULL AUTO_INCREMENT,
1560 `interviewtime` float DEFAULT NULL,
1561 `658539X6time` float DEFAULT NULL,
1562 `658539X6X40time` float DEFAULT NULL,
1563 `658539X7time` float DEFAULT NULL,
1564 `658539X7X41time` float DEFAULT NULL,
1565 `658539X8time` float DEFAULT NULL,
1566 `658539X8X42time` float DEFAULT NULL,
1567 `658539X8X51time` float DEFAULT NULL,
1568 `658539X8X52time` float DEFAULT NULL,
1569 `658539X9time` float DEFAULT NULL,
1570 `658539X9X57time` float DEFAULT NULL,
1571 `658539X9X58time` float DEFAULT NULL,
1572 `658539X9X59time` float DEFAULT NULL,
1573 `658539X10time` float DEFAULT NULL,
1574 `658539X10X64time` float DEFAULT NULL,
1575 `658539X10X65time` float DEFAULT NULL,
1576 `658539X11time` float DEFAULT NULL,
1577 `658539X11X75time` float DEFAULT NULL,
1578 `658539X11X66time` float DEFAULT NULL,
1579 `658539X11X67time` float DEFAULT NULL,
1580 `658539X11X68time` float DEFAULT NULL,
1581 `658539X11X69time` float DEFAULT NULL,
1582 `658539X11X70time` float DEFAULT NULL,
1583 `658539X11X72time` float DEFAULT NULL,
1584 `658539X11X73time` float DEFAULT NULL,
1585 `658539X11X74time` float DEFAULT NULL,
1586 PRIMARY KEY (`id`)
1587) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1588/*!40101 SET character_set_client = @saved_cs_client */;
1589
1590--
1591-- Dumping data for table `lime_survey_658539_timings`
1592--
1593
1594LOCK TABLES `lime_survey_658539_timings` WRITE;
1595/*!40000 ALTER TABLE `lime_survey_658539_timings` DISABLE KEYS */;
1596INSERT INTO `lime_survey_658539_timings` VALUES (3,124.05,7.77,NULL,8.62,NULL,43.78,NULL,NULL,NULL,15.29,NULL,NULL,NULL,30.51,NULL,NULL,18.08,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,181.86,9.07,NULL,3.59,NULL,55.46,NULL,NULL,NULL,14.69,NULL,NULL,NULL,26.64,NULL,NULL,72.41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,481.14,6.83,NULL,9.25,NULL,73.88,NULL,NULL,NULL,14.36,NULL,NULL,NULL,352.14,NULL,NULL,24.68,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,143.48,14.36,NULL,10.69,NULL,22.42,NULL,NULL,NULL,23.48,NULL,NULL,NULL,16.31,NULL,NULL,56.22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,150.93,6.72,NULL,4.71,NULL,52.94,NULL,NULL,NULL,15.18,NULL,NULL,NULL,25.56,NULL,NULL,45.82,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,281.8,11.13,NULL,6.01,NULL,44.16,NULL,NULL,NULL,27.53,NULL,NULL,NULL,65.59,NULL,NULL,127.38,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,128.85,6.11,NULL,5.09,NULL,36.14,NULL,NULL,NULL,13.17,NULL,NULL,NULL,18.12,NULL,NULL,50.22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,162.13,6.26,NULL,6.17,NULL,58.02,NULL,NULL,NULL,20.41,NULL,NULL,NULL,28.7,NULL,NULL,42.57,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,122.36,4.1,NULL,6.34,NULL,21.9,NULL,NULL,NULL,17.64,NULL,NULL,NULL,18.05,NULL,NULL,54.33,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,127.65,7.94,NULL,8.5,NULL,46.1,NULL,NULL,NULL,14.39,NULL,NULL,NULL,12.03,NULL,NULL,38.69,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,978.23,978.23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1597/*!40000 ALTER TABLE `lime_survey_658539_timings` ENABLE KEYS */;
1598UNLOCK TABLES;
1599
1600--
1601-- Table structure for table `lime_survey_links`
1602--
1603
1604DROP TABLE IF EXISTS `lime_survey_links`;
1605/*!40101 SET @saved_cs_client = @@character_set_client */;
1606/*!40101 SET character_set_client = utf8 */;
1607CREATE TABLE `lime_survey_links` (
1608 `participant_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1609 `token_id` int(11) NOT NULL,
1610 `survey_id` int(11) NOT NULL,
1611 `date_created` datetime DEFAULT NULL,
1612 `date_invited` datetime DEFAULT NULL,
1613 `date_completed` datetime DEFAULT NULL,
1614 PRIMARY KEY (`participant_id`,`token_id`,`survey_id`)
1615) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1616/*!40101 SET character_set_client = @saved_cs_client */;
1617
1618--
1619-- Dumping data for table `lime_survey_links`
1620--
1621
1622LOCK TABLES `lime_survey_links` WRITE;
1623/*!40000 ALTER TABLE `lime_survey_links` DISABLE KEYS */;
1624/*!40000 ALTER TABLE `lime_survey_links` ENABLE KEYS */;
1625UNLOCK TABLES;
1626
1627--
1628-- Table structure for table `lime_survey_url_parameters`
1629--
1630
1631DROP TABLE IF EXISTS `lime_survey_url_parameters`;
1632/*!40101 SET @saved_cs_client = @@character_set_client */;
1633/*!40101 SET character_set_client = utf8 */;
1634CREATE TABLE `lime_survey_url_parameters` (
1635 `id` int(11) NOT NULL AUTO_INCREMENT,
1636 `sid` int(11) NOT NULL,
1637 `parameter` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1638 `targetqid` int(11) DEFAULT NULL,
1639 `targetsqid` int(11) DEFAULT NULL,
1640 PRIMARY KEY (`id`)
1641) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1642/*!40101 SET character_set_client = @saved_cs_client */;
1643
1644--
1645-- Dumping data for table `lime_survey_url_parameters`
1646--
1647
1648LOCK TABLES `lime_survey_url_parameters` WRITE;
1649/*!40000 ALTER TABLE `lime_survey_url_parameters` DISABLE KEYS */;
1650/*!40000 ALTER TABLE `lime_survey_url_parameters` ENABLE KEYS */;
1651UNLOCK TABLES;
1652
1653--
1654-- Table structure for table `lime_surveys`
1655--
1656
1657DROP TABLE IF EXISTS `lime_surveys`;
1658/*!40101 SET @saved_cs_client = @@character_set_client */;
1659/*!40101 SET character_set_client = utf8 */;
1660CREATE TABLE `lime_surveys` (
1661 `sid` int(11) NOT NULL,
1662 `owner_id` int(11) NOT NULL,
1663 `admin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1664 `active` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1665 `expires` datetime DEFAULT NULL,
1666 `startdate` datetime DEFAULT NULL,
1667 `adminemail` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
1668 `anonymized` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1669 `faxto` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
1670 `format` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1671 `savetimings` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1672 `template` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'default',
1673 `language` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1674 `additional_languages` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1675 `datestamp` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1676 `usecookie` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1677 `allowregister` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1678 `allowsave` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
1679 `autonumber_start` int(11) NOT NULL DEFAULT '0',
1680 `autoredirect` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1681 `allowprev` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1682 `printanswers` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1683 `ipaddr` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1684 `refurl` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1685 `datecreated` date DEFAULT NULL,
1686 `publicstatistics` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1687 `publicgraphs` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1688 `listpublic` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1689 `htmlemail` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1690 `sendconfirmation` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
1691 `tokenanswerspersistence` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1692 `assessments` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1693 `usecaptcha` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1694 `usetokens` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
1695 `bounce_email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
1696 `attributedescriptions` text COLLATE utf8_unicode_ci,
1697 `emailresponseto` text COLLATE utf8_unicode_ci,
1698 `emailnotificationto` text COLLATE utf8_unicode_ci,
1699 `tokenlength` int(11) NOT NULL DEFAULT '15',
1700 `showxquestions` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
1701 `showgroupinfo` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'B',
1702 `shownoanswer` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
1703 `showqnumcode` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'X',
1704 `bouncetime` int(11) DEFAULT NULL,
1705 `bounceprocessing` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
1706 `bounceaccounttype` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
1707 `bounceaccounthost` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
1708 `bounceaccountpass` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1709 `bounceaccountencryption` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
1710 `bounceaccountuser` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
1711 `showwelcome` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
1712 `showprogress` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'Y',
1713 `questionindex` int(11) NOT NULL DEFAULT '0',
1714 `navigationdelay` int(11) NOT NULL DEFAULT '0',
1715 `nokeyboard` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
1716 `alloweditaftercompletion` varchar(1) COLLATE utf8_unicode_ci DEFAULT 'N',
1717 `googleanalyticsstyle` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
1718 `googleanalyticsapikey` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
1719 PRIMARY KEY (`sid`)
1720) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1721/*!40101 SET character_set_client = @saved_cs_client */;
1722
1723--
1724-- Dumping data for table `lime_surveys`
1725--
1726
1727LOCK TABLES `lime_surveys` WRITE;
1728/*!40000 ALTER TABLE `lime_surveys` DISABLE KEYS */;
1729INSERT INTO `lime_surveys` VALUES (158942,1,'Administrator','Y',NULL,NULL,'admin@alcaldiabogota.gov.co','Y','','G','Y','mint_idea','es','','Y','N','N','Y',6,'N','Y','N','Y','Y','2014-01-27','N','N','Y','Y','Y','N','N','D','N','admin@alcaldiabogota.gov.co','a:0:{}','','',15,'Y','B','Y','X',NULL,'N',NULL,NULL,NULL,NULL,NULL,'Y','Y',0,0,'N','N','0',''),(658539,1,'Administrador','Y',NULL,NULL,'webmaster@alcaldiabogota.gov.co','Y','','G','Y','mint_idea','es','','Y','N','N','N',3,'N','N','N','Y','Y','2014-01-28','N','N','Y','Y','Y','N','N','D','N','webmaster@alcaldiabogota.gov.co','a:0:{}','','',15,'Y','B','Y','X',NULL,'N',NULL,NULL,NULL,NULL,NULL,'Y','Y',0,0,'N','N','0',''),(289827,1,'Administrador','Y',NULL,NULL,'webmaster@alcaldiabogota.gov.co','Y','','G','Y','mint_idea','es','','Y','N','N','N',3,'N','N','N','Y','Y','2014-01-28','N','N','Y','Y','Y','N','N','D','N','webmaster@alcaldiabogota.gov.co','a:0:{}','','',15,'Y','B','Y','X',NULL,'N',NULL,NULL,NULL,NULL,NULL,'Y','Y',0,0,'N','N','0','');
1730/*!40000 ALTER TABLE `lime_surveys` ENABLE KEYS */;
1731UNLOCK TABLES;
1732
1733--
1734-- Table structure for table `lime_surveys_languagesettings`
1735--
1736
1737DROP TABLE IF EXISTS `lime_surveys_languagesettings`;
1738/*!40101 SET @saved_cs_client = @@character_set_client */;
1739/*!40101 SET character_set_client = utf8 */;
1740CREATE TABLE `lime_surveys_languagesettings` (
1741 `surveyls_survey_id` int(11) NOT NULL,
1742 `surveyls_language` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
1743 `surveyls_title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
1744 `surveyls_description` text COLLATE utf8_unicode_ci,
1745 `surveyls_welcometext` text COLLATE utf8_unicode_ci,
1746 `surveyls_endtext` text COLLATE utf8_unicode_ci,
1747 `surveyls_url` text COLLATE utf8_unicode_ci,
1748 `surveyls_urldescription` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1749 `surveyls_email_invite_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1750 `surveyls_email_invite` text COLLATE utf8_unicode_ci,
1751 `surveyls_email_remind_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1752 `surveyls_email_remind` text COLLATE utf8_unicode_ci,
1753 `surveyls_email_register_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1754 `surveyls_email_register` text COLLATE utf8_unicode_ci,
1755 `surveyls_email_confirm_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1756 `surveyls_email_confirm` text COLLATE utf8_unicode_ci,
1757 `surveyls_dateformat` int(11) NOT NULL DEFAULT '1',
1758 `surveyls_attributecaptions` text COLLATE utf8_unicode_ci,
1759 `email_admin_notification_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1760 `email_admin_notification` text COLLATE utf8_unicode_ci,
1761 `email_admin_responses_subj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1762 `email_admin_responses` text COLLATE utf8_unicode_ci,
1763 `surveyls_numberformat` int(11) NOT NULL DEFAULT '0',
1764 `attachments` text COLLATE utf8_unicode_ci,
1765 PRIMARY KEY (`surveyls_survey_id`,`surveyls_language`)
1766) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1767/*!40101 SET character_set_client = @saved_cs_client */;
1768
1769--
1770-- Dumping data for table `lime_surveys_languagesettings`
1771--
1772
1773LOCK TABLES `lime_surveys_languagesettings` WRITE;
1774/*!40000 ALTER TABLE `lime_surveys_languagesettings` DISABLE KEYS */;
1775INSERT INTO `lime_surveys_languagesettings` VALUES (158942,'es','Encuesta sobre servicios del Portal de Contratacion a la vista','','','','','','Invitación para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nHa sido invitado a participar en la siguiente encuesta:<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\n¡Muchas gracias por su interés y colaboración!<br />\n<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}<br />\n<br />\nSi usted se encuentra en la lista negra de usuarios, pero quiere participar en esta encuesta y quiere recibir invitaciones, por favor haga click en el siguiente enlace:<br />\n{OPTINURL}','Recordatorio para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nRecientemente se le invitó a participar en la encuesta de tÃtulo<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nAdvertimos que aún no la ha completado, y de la forma más atenta querÃamos recordarle que todavÃa se encuentra disponible si desea participar.<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nNuevamente le agradecemos su interés y colaboración.<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}','Confirmación de registro en la encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nUsted, o alguien utilizando su dirección de correo electrónico, se ha registrado para participar en una encuesta en lÃnea titulada <br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara completarla, pulse en la siguiente dirección:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nSi tiene cualquier duda con respecto a la encuesta, o si no se registró para participar y cree que este correo es un error, por favor, póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.','Confirmación de su participación en nuestra encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nEste correo es para confirmarle que ha completado la encuesta titulada \"{SURVEYNAME}\" y sus respuestas han quedado correctamente guardadas.<br />\n<br />\n ¡Muchas gracias por su participación!.<br />\n<br />\nSi tiene alguna duda o consulta adicional, por favor póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.<br />\n<br />\nReciba un cordial saludo,<br />\n<br />\n{ADMINNAME}',5,'a:0:{}','EnvÃo de respuestas de la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}','Enviar los resultados de las respuestas en la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}<br />\n<br />\n<br />\nEstas son las respuestas dadas por el/la encuestado/a:<br />\n{ANSWERTABLE}',1,NULL),(658539,'es','GuÃa de trámites y mapa callejero','','','','','','Invitación para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nHa sido invitado a participar en la siguiente encuesta:<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\n¡Muchas gracias por su interés y colaboración!<br />\n<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}<br />\n<br />\nSi usted se encuentra en la lista negra de usuarios, pero quiere participar en esta encuesta y quiere recibir invitaciones, por favor haga click en el siguiente enlace:<br />\n{OPTINURL}','Recordatorio para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nRecientemente se le invitó a participar en la encuesta de tÃtulo<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nAdvertimos que aún no la ha completado, y de la forma más atenta querÃamos recordarle que todavÃa se encuentra disponible si desea participar.<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nNuevamente le agradecemos su interés y colaboración.<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}','Confirmación de registro en la encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nUsted, o alguien utilizando su dirección de correo electrónico, se ha registrado para participar en una encuesta en lÃnea titulada <br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara completarla, pulse en la siguiente dirección:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nSi tiene cualquier duda con respecto a la encuesta, o si no se registró para participar y cree que este correo es un error, por favor, póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.','Confirmación de su participación en nuestra encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nEste correo es para confirmarle que ha completado la encuesta titulada \"{SURVEYNAME}\" y sus respuestas han quedado correctamente guardadas.<br />\n<br />\n ¡Muchas gracias por su participación!.<br />\n<br />\nSi tiene alguna duda o consulta adicional, por favor póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.<br />\n<br />\nReciba un cordial saludo,<br />\n<br />\n{ADMINNAME}',5,'a:0:{}','EnvÃo de respuestas de la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}','Enviar los resultados de las respuestas en la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}<br />\n<br />\n<br />\nEstas son las respuestas dadas por el/la encuestado/a:<br />\n{ANSWERTABLE}',1,NULL),(289827,'es','Portal Bogotá','','','','','','Invitación para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nHa sido invitado a participar en la siguiente encuesta:<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\n¡Muchas gracias por su interés y colaboración!<br />\n<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}<br />\n<br />\nSi usted se encuentra en la lista negra de usuarios, pero quiere participar en esta encuesta y quiere recibir invitaciones, por favor haga click en el siguiente enlace:<br />\n{OPTINURL}','Recordatorio para participar en una encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nRecientemente se le invitó a participar en la encuesta de tÃtulo<br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nAdvertimos que aún no la ha completado, y de la forma más atenta querÃamos recordarle que todavÃa se encuentra disponible si desea participar.<br />\n<br />\nPara hacerlo, por favor pulse en el siguiente enlace:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nNuevamente le agradecemos su interés y colaboración.<br />\nAtentamente,<br />\n<br />\n{ADMINNAME} ({ADMINEMAIL})<br />\n<br />\nSi no desea participar en esta encuesta y tampoco desea recibir más invitaciones a la misma, por favor, pulse en el siguiente enlace:<br />\n{OPTOUTURL}','Confirmación de registro en la encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nUsted, o alguien utilizando su dirección de correo electrónico, se ha registrado para participar en una encuesta en lÃnea titulada <br />\n<br />\n«{SURVEYNAME}»<br />\n<br />\n«{SURVEYDESCRIPTION}»<br />\n<br />\nPara completarla, pulse en la siguiente dirección:<br />\n<br />\n{SURVEYURL}<br />\n<br />\nSi tiene cualquier duda con respecto a la encuesta, o si no se registró para participar y cree que este correo es un error, por favor, póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.','Confirmación de su participación en nuestra encuesta','Estimado/a {FIRSTNAME} {LASTNAME}:<br />\n<br />\nEste correo es para confirmarle que ha completado la encuesta titulada \"{SURVEYNAME}\" y sus respuestas han quedado correctamente guardadas.<br />\n<br />\n ¡Muchas gracias por su participación!.<br />\n<br />\nSi tiene alguna duda o consulta adicional, por favor póngase en contacto con {ADMINNAME} en {ADMINEMAIL}.<br />\n<br />\nReciba un cordial saludo,<br />\n<br />\n{ADMINNAME}',5,'a:0:{}','EnvÃo de respuestas de la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}','Enviar los resultados de las respuestas en la encuesta {SURVEYNAME}','Hola!<br />\n<br />\nUna nueva respuesta ha sido concluida en su encuesta \'{SURVEYNAME}\'.<br />\n<br />\nPulse aquà para recargar la encuesta:<br />\n{RELOADURL}<br />\n<br />\nPulse el siguiente enlace para ver la respuesta individual:<br />\n{VIEWRESPONSEURL}<br />\n<br />\nPulse el siguiente enlace para editar la respuesta individual:<br />\n{EDITRESPONSEURL}<br />\n<br />\nVer estadÃsticas pulsando el siguiente enlace:<br />\n{STATISTICSURL}<br />\n<br />\n<br />\nEstas son las respuestas dadas por el/la encuestado/a:<br />\n{ANSWERTABLE}',1,NULL);
1776/*!40000 ALTER TABLE `lime_surveys_languagesettings` ENABLE KEYS */;
1777UNLOCK TABLES;
1778
1779--
1780-- Table structure for table `lime_templates`
1781--
1782
1783DROP TABLE IF EXISTS `lime_templates`;
1784/*!40101 SET @saved_cs_client = @@character_set_client */;
1785/*!40101 SET character_set_client = utf8 */;
1786CREATE TABLE `lime_templates` (
1787 `folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1788 `creator` int(11) NOT NULL,
1789 PRIMARY KEY (`folder`)
1790) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1791/*!40101 SET character_set_client = @saved_cs_client */;
1792
1793--
1794-- Dumping data for table `lime_templates`
1795--
1796
1797LOCK TABLES `lime_templates` WRITE;
1798/*!40000 ALTER TABLE `lime_templates` DISABLE KEYS */;
1799/*!40000 ALTER TABLE `lime_templates` ENABLE KEYS */;
1800UNLOCK TABLES;
1801
1802--
1803-- Table structure for table `lime_templates_rights`
1804--
1805
1806DROP TABLE IF EXISTS `lime_templates_rights`;
1807/*!40101 SET @saved_cs_client = @@character_set_client */;
1808/*!40101 SET character_set_client = utf8 */;
1809CREATE TABLE `lime_templates_rights` (
1810 `uid` int(11) NOT NULL,
1811 `folder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1812 `use` int(11) NOT NULL,
1813 PRIMARY KEY (`uid`,`folder`)
1814) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1815/*!40101 SET character_set_client = @saved_cs_client */;
1816
1817--
1818-- Dumping data for table `lime_templates_rights`
1819--
1820
1821LOCK TABLES `lime_templates_rights` WRITE;
1822/*!40000 ALTER TABLE `lime_templates_rights` DISABLE KEYS */;
1823/*!40000 ALTER TABLE `lime_templates_rights` ENABLE KEYS */;
1824UNLOCK TABLES;
1825
1826--
1827-- Table structure for table `lime_user_groups`
1828--
1829
1830DROP TABLE IF EXISTS `lime_user_groups`;
1831/*!40101 SET @saved_cs_client = @@character_set_client */;
1832/*!40101 SET character_set_client = utf8 */;
1833CREATE TABLE `lime_user_groups` (
1834 `ugid` int(11) NOT NULL AUTO_INCREMENT,
1835 `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
1836 `description` text COLLATE utf8_unicode_ci NOT NULL,
1837 `owner_id` int(11) NOT NULL,
1838 PRIMARY KEY (`ugid`),
1839 UNIQUE KEY `name` (`name`)
1840) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1841/*!40101 SET character_set_client = @saved_cs_client */;
1842
1843--
1844-- Dumping data for table `lime_user_groups`
1845--
1846
1847LOCK TABLES `lime_user_groups` WRITE;
1848/*!40000 ALTER TABLE `lime_user_groups` DISABLE KEYS */;
1849/*!40000 ALTER TABLE `lime_user_groups` ENABLE KEYS */;
1850UNLOCK TABLES;
1851
1852--
1853-- Table structure for table `lime_user_in_groups`
1854--
1855
1856DROP TABLE IF EXISTS `lime_user_in_groups`;
1857/*!40101 SET @saved_cs_client = @@character_set_client */;
1858/*!40101 SET character_set_client = utf8 */;
1859CREATE TABLE `lime_user_in_groups` (
1860 `ugid` int(11) NOT NULL,
1861 `uid` int(11) NOT NULL,
1862 PRIMARY KEY (`ugid`,`uid`)
1863) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1864/*!40101 SET character_set_client = @saved_cs_client */;
1865
1866--
1867-- Dumping data for table `lime_user_in_groups`
1868--
1869
1870LOCK TABLES `lime_user_in_groups` WRITE;
1871/*!40000 ALTER TABLE `lime_user_in_groups` DISABLE KEYS */;
1872/*!40000 ALTER TABLE `lime_user_in_groups` ENABLE KEYS */;
1873UNLOCK TABLES;
1874
1875--
1876-- Table structure for table `lime_users`
1877--
1878
1879DROP TABLE IF EXISTS `lime_users`;
1880/*!40101 SET @saved_cs_client = @@character_set_client */;
1881/*!40101 SET character_set_client = utf8 */;
1882CREATE TABLE `lime_users` (
1883 `uid` int(11) NOT NULL AUTO_INCREMENT,
1884 `users_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1885 `password` blob NOT NULL,
1886 `full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1887 `parent_id` int(11) NOT NULL,
1888 `lang` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
1889 `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
1890 `htmleditormode` varchar(7) COLLATE utf8_unicode_ci DEFAULT 'default',
1891 `templateeditormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
1892 `questionselectormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
1893 `one_time_pw` blob,
1894 `dateformat` int(11) NOT NULL DEFAULT '1',
1895 `created` datetime DEFAULT NULL,
1896 `modified` datetime DEFAULT NULL,
1897 PRIMARY KEY (`uid`),
1898 UNIQUE KEY `users_name` (`users_name`)
1899) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1900/*!40101 SET character_set_client = @saved_cs_client */;
1901
1902--
1903-- Dumping data for table `lime_users`
1904--
1905
1906LOCK TABLES `lime_users` WRITE;
1907/*!40000 ALTER TABLE `lime_users` DISABLE KEYS */;
1908INSERT INTO `lime_users` VALUES (1,'admin','a9b9698aa16d3406eba90dafdce9f59b7491e3f86502a301faa2d610e678ddc6','Administrador',0,'es','webmaster@alcaldiabogota.gov.co','default','default','default',NULL,1,'2014-01-27 16:14:14',NULL);
1909/*!40000 ALTER TABLE `lime_users` ENABLE KEYS */;
1910UNLOCK TABLES;
1911/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1912
1913/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1914/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1915/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1916/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1917/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1918/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1919/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1920
1921-- Dump completed on 2014-02-06 12:24:11