· 11 years ago · Apr 06, 2015, 05:04 PM
1-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64)
2--
3-- Host: 0.0.0.0 Database: c9
4-- ------------------------------------------------------
5-- Server version 5.5.40-0ubuntu0.14.04.1
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 `tb_categoria`
20--
21
22DROP TABLE IF EXISTS `tb_categoria`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `tb_categoria` (
26 `id` bigint(20) NOT NULL AUTO_INCREMENT,
27 `nome` varchar(25) NOT NULL,
28 `icone` longblob NOT NULL,
29 PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `tb_categoria`
35--
36
37LOCK TABLES `tb_categoria` WRITE;
38/*!40000 ALTER TABLE `tb_categoria` DISABLE KEYS */;
39/*!40000 ALTER TABLE `tb_categoria` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `tb_conquista`
44--
45
46DROP TABLE IF EXISTS `tb_conquista`;
47/*!40101 SET @saved_cs_client = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `tb_conquista` (
50 `id` bigint(20) NOT NULL AUTO_INCREMENT,
51 `nome` varchar(32) NOT NULL,
52 `descricao` varchar(50) NOT NULL,
53 `type` int(11) NOT NULL,
54 `count` int(11) NOT NULL,
55 `gain_exp` int(11) NOT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `tb_conquista`
62--
63
64LOCK TABLES `tb_conquista` WRITE;
65/*!40000 ALTER TABLE `tb_conquista` DISABLE KEYS */;
66INSERT INTO `tb_conquista` VALUES (7,'Conselheiro Iniciante','Dar 10 conselhos',1,10,10),(8,'Conselheiro Intermediário','Dar 20 conselhos',1,20,20),(9,'Achei um amigo!','Seguir uma pessoa',2,1,50),(10,'Sou muito popular!','Conseguir 100 seguidores',2,100,100);
67/*!40000 ALTER TABLE `tb_conquista` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `tb_conquistas_user`
72--
73
74DROP TABLE IF EXISTS `tb_conquistas_user`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `tb_conquistas_user` (
78 `id` bigint(20) NOT NULL AUTO_INCREMENT,
79 `id_usuario` bigint(20) NOT NULL,
80 `id_conquista` bigint(20) NOT NULL,
81 `count` int(11) NOT NULL,
82 `finished` tinyint(1) NOT NULL DEFAULT '0',
83 `data_conquista` datetime NOT NULL,
84 PRIMARY KEY (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `tb_conquistas_user`
90--
91
92LOCK TABLES `tb_conquistas_user` WRITE;
93/*!40000 ALTER TABLE `tb_conquistas_user` DISABLE KEYS */;
94INSERT INTO `tb_conquistas_user` VALUES (47,97,10,24,0,'0000-00-00 00:00:00'),(48,97,9,24,1,'2015-03-25 14:32:44'),(49,171,8,2,0,'0000-00-00 00:00:00'),(50,171,7,2,0,'0000-00-00 00:00:00'),(51,171,10,3,0,'0000-00-00 00:00:00'),(52,171,9,3,1,'2015-03-25 16:19:47'),(53,133,8,5,0,'0000-00-00 00:00:00'),(54,133,7,5,0,'0000-00-00 00:00:00'),(55,133,10,7,0,'0000-00-00 00:00:00'),(56,133,9,7,1,'2015-04-01 00:00:12'),(57,97,8,4,0,'0000-00-00 00:00:00'),(58,97,7,4,0,'0000-00-00 00:00:00'),(59,135,8,2,0,'0000-00-00 00:00:00'),(60,135,7,2,0,'0000-00-00 00:00:00');
95/*!40000 ALTER TABLE `tb_conquistas_user` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `tb_denuncia_problema`
100--
101
102DROP TABLE IF EXISTS `tb_denuncia_problema`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `tb_denuncia_problema` (
106 `id` bigint(20) NOT NULL AUTO_INCREMENT,
107 `id_usuario` bigint(20) NOT NULL COMMENT 'Executou a denuncia',
108 `id_problema` bigint(20) NOT NULL,
109 `time` bigint(20) NOT NULL,
110 PRIMARY KEY (`id`)
111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112/*!40101 SET character_set_client = @saved_cs_client */;
113
114--
115-- Dumping data for table `tb_denuncia_problema`
116--
117
118LOCK TABLES `tb_denuncia_problema` WRITE;
119/*!40000 ALTER TABLE `tb_denuncia_problema` DISABLE KEYS */;
120/*!40000 ALTER TABLE `tb_denuncia_problema` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `tb_denuncia_resposta`
125--
126
127DROP TABLE IF EXISTS `tb_denuncia_resposta`;
128/*!40101 SET @saved_cs_client = @@character_set_client */;
129/*!40101 SET character_set_client = utf8 */;
130CREATE TABLE `tb_denuncia_resposta` (
131 `id` bigint(20) NOT NULL AUTO_INCREMENT,
132 `id_usuario` bigint(20) NOT NULL COMMENT 'Usuario que fez a denuncia',
133 `id_resposta` bigint(20) NOT NULL,
134 `time` bigint(20) NOT NULL,
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Dumping data for table `tb_denuncia_resposta`
141--
142
143LOCK TABLES `tb_denuncia_resposta` WRITE;
144/*!40000 ALTER TABLE `tb_denuncia_resposta` DISABLE KEYS */;
145/*!40000 ALTER TABLE `tb_denuncia_resposta` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `tb_idioma`
150--
151
152DROP TABLE IF EXISTS `tb_idioma`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `tb_idioma` (
156 `id` int(11) NOT NULL AUTO_INCREMENT,
157 `nome` varchar(20) NOT NULL,
158 PRIMARY KEY (`id`)
159) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
160/*!40101 SET character_set_client = @saved_cs_client */;
161
162--
163-- Dumping data for table `tb_idioma`
164--
165
166LOCK TABLES `tb_idioma` WRITE;
167/*!40000 ALTER TABLE `tb_idioma` DISABLE KEYS */;
168INSERT INTO `tb_idioma` VALUES (1,'pt'),(2,'en'),(3,'es');
169/*!40000 ALTER TABLE `tb_idioma` ENABLE KEYS */;
170UNLOCK TABLES;
171
172--
173-- Table structure for table `tb_notificacao`
174--
175
176DROP TABLE IF EXISTS `tb_notificacao`;
177/*!40101 SET @saved_cs_client = @@character_set_client */;
178/*!40101 SET character_set_client = utf8 */;
179CREATE TABLE `tb_notificacao` (
180 `id` bigint(20) NOT NULL AUTO_INCREMENT,
181 `id_usuario` bigint(20) NOT NULL,
182 `tipo` int(11) NOT NULL COMMENT '1:Comentaram seu problema\\n2:te seguiram',
183 `id_usuario_acao` bigint(20) NOT NULL,
184 `id_problema_acao` bigint(20) NOT NULL,
185 `vista` tinyint(4) NOT NULL DEFAULT '0',
186 `data` datetime NOT NULL,
187 PRIMARY KEY (`id`)
188) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
189/*!40101 SET character_set_client = @saved_cs_client */;
190
191--
192-- Dumping data for table `tb_notificacao`
193--
194
195LOCK TABLES `tb_notificacao` WRITE;
196/*!40000 ALTER TABLE `tb_notificacao` DISABLE KEYS */;
197INSERT INTO `tb_notificacao` VALUES (9,97,1,171,233,0,'2015-03-25 16:01:14'),(10,97,1,171,229,0,'2015-03-25 16:12:28'),(11,97,2,133,0,0,'2015-03-25 17:01:58'),(12,97,1,133,229,0,'2015-03-25 17:04:00'),(13,171,1,133,243,0,'2015-03-27 15:52:12'),(14,97,2,133,0,0,'2015-03-31 18:10:20'),(15,97,2,133,0,0,'2015-03-31 18:10:24'),(16,97,2,133,0,0,'2015-03-31 18:11:26'),(17,97,2,133,0,0,'2015-03-31 18:11:28'),(18,171,1,133,242,0,'2015-03-31 21:43:52'),(19,97,1,133,228,0,'2015-03-31 21:46:44'),(20,171,1,97,243,0,'2015-04-01 16:57:27'),(21,171,1,97,243,0,'2015-04-01 17:12:16'),(22,171,1,97,243,0,'2015-04-01 17:16:43'),(23,97,1,135,225,0,'2015-04-01 19:27:51'),(24,97,1,135,229,0,'2015-04-01 19:37:56'),(25,97,1,133,226,0,'2015-04-01 23:22:06'),(26,135,2,133,0,0,'2015-04-01 23:23:31'),(27,171,2,97,0,0,'2015-04-02 18:01:58'),(28,171,2,97,0,0,'2015-04-02 18:03:12'),(29,171,2,97,0,0,'2015-04-02 18:06:53'),(30,171,2,97,0,0,'2015-04-02 18:07:37'),(31,171,2,97,0,0,'2015-04-02 18:07:43'),(32,171,2,97,0,0,'2015-04-02 18:09:40'),(33,171,2,97,0,0,'2015-04-02 18:11:41'),(34,171,2,97,0,0,'2015-04-02 18:13:56'),(35,171,2,97,0,0,'2015-04-02 18:16:25'),(36,171,2,97,0,0,'2015-04-02 18:20:04'),(37,171,2,97,0,0,'2015-04-02 18:21:02'),(38,171,2,97,0,0,'2015-04-02 18:24:19'),(39,171,2,97,0,0,'2015-04-02 18:26:30'),(40,171,2,97,0,0,'2015-04-02 18:26:44'),(41,171,2,97,0,0,'2015-04-02 18:27:23'),(42,171,2,97,0,0,'2015-04-02 18:28:56'),(43,171,2,97,0,0,'2015-04-02 18:30:06'),(44,171,2,97,0,0,'2015-04-02 18:30:08'),(45,133,2,97,0,0,'2015-04-02 19:01:28'),(46,133,2,97,0,0,'2015-04-02 19:01:31'),(47,133,2,97,0,0,'2015-04-02 19:01:33'),(48,133,2,97,0,0,'2015-04-02 19:01:35'),(49,133,2,97,0,0,'2015-04-02 19:01:36'),(50,133,2,97,0,0,'2015-04-02 19:01:38'),(51,133,2,97,0,0,'2015-04-02 19:01:40'),(52,133,2,97,0,0,'2015-04-02 19:02:23'),(53,133,2,97,0,0,'2015-04-02 19:02:45'),(54,133,2,97,0,0,'2015-04-02 19:02:47'),(55,133,2,97,0,0,'2015-04-02 19:03:12'),(56,133,2,97,0,0,'2015-04-02 19:03:14'),(57,133,2,97,0,0,'2015-04-02 19:03:17'),(58,133,2,97,0,0,'2015-04-02 19:03:29'),(59,133,2,97,0,0,'2015-04-02 19:03:31'),(60,133,2,97,0,0,'2015-04-02 19:03:33'),(61,133,2,97,0,0,'2015-04-02 19:03:35'),(62,133,2,97,0,0,'2015-04-02 19:03:37'),(63,133,2,97,0,0,'2015-04-02 19:03:50'),(64,133,2,97,0,0,'2015-04-02 19:03:52'),(65,133,2,97,0,0,'2015-04-02 19:03:54'),(66,133,2,97,0,0,'2015-04-02 19:03:56'),(67,133,2,97,0,0,'2015-04-02 19:04:07'),(68,133,2,97,0,0,'2015-04-02 19:04:08'),(69,133,2,97,0,0,'2015-04-02 19:04:10'),(70,133,2,97,0,0,'2015-04-02 19:04:12'),(71,133,2,97,0,0,'2015-04-02 19:04:14'),(72,133,2,97,0,0,'2015-04-02 19:04:16'),(73,133,2,97,0,0,'2015-04-02 19:04:20'),(74,133,2,97,0,0,'2015-04-02 19:05:25'),(75,133,2,97,0,0,'2015-04-02 19:05:32'),(76,133,2,97,0,0,'2015-04-02 19:07:20'),(77,133,2,97,0,0,'2015-04-02 19:07:22'),(78,133,2,97,0,0,'2015-04-02 19:08:02'),(79,133,2,97,0,0,'2015-04-02 19:08:05'),(80,133,2,97,0,0,'2015-04-02 19:08:08'),(81,133,2,97,0,0,'2015-04-02 19:08:11'),(82,133,2,97,0,0,'2015-04-02 19:08:14'),(83,133,2,97,0,0,'2015-04-02 19:08:16'),(84,97,2,135,0,0,'2015-04-02 22:39:42'),(85,97,2,135,0,0,'2015-04-02 22:39:45'),(86,97,2,135,0,0,'2015-04-02 22:39:49'),(87,171,1,97,241,0,'2015-04-03 00:54:53'),(88,135,2,133,0,0,'2015-04-03 16:38:45'),(89,135,2,133,0,0,'2015-04-03 16:38:48'),(90,135,2,133,0,0,'2015-04-03 16:38:51'),(91,135,2,133,0,0,'2015-04-03 16:39:01'),(92,135,2,133,0,0,'2015-04-03 16:39:23');
198/*!40000 ALTER TABLE `tb_notificacao` ENABLE KEYS */;
199UNLOCK TABLES;
200
201--
202-- Table structure for table `tb_problema`
203--
204
205DROP TABLE IF EXISTS `tb_problema`;
206/*!40101 SET @saved_cs_client = @@character_set_client */;
207/*!40101 SET character_set_client = utf8 */;
208CREATE TABLE `tb_problema` (
209 `id` bigint(20) NOT NULL AUTO_INCREMENT,
210 `id_usuario` bigint(20) NOT NULL,
211 `id_categoria` bigint(20) NOT NULL,
212 `id_idioma` tinyint(4) NOT NULL DEFAULT '1',
213 `best_response` bigint(20) NOT NULL,
214 `tipo` tinyint(4) NOT NULL COMMENT '1:simples, 2:algoritmo, 3:alternativa',
215 `descricao` varchar(250) NOT NULL,
216 `imagem` longblob,
217 `premium` tinyint(1) NOT NULL,
218 `anonimo` smallint(1) NOT NULL DEFAULT '0',
219 `resolvido` tinyint(1) NOT NULL DEFAULT '0',
220 `data` datetime NOT NULL,
221 PRIMARY KEY (`id`)
222) ENGINE=InnoDB AUTO_INCREMENT=258 DEFAULT CHARSET=latin1;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Dumping data for table `tb_problema`
227--
228
229LOCK TABLES `tb_problema` WRITE;
230/*!40000 ALTER TABLE `tb_problema` DISABLE KEYS */;
231INSERT INTO `tb_problema` VALUES (224,97,2,1,0,1,'Eu não estou conseguindo fazer meus exercÃcios de matemática, o que devo fazer ?','(null)',0,0,0,'2015-03-25 14:32:44'),(225,97,6,2,0,2,'Quero muito trabalhar em uma startup de tecnologia. O que devo fazer pra alcançar isso ?','(null)',0,0,0,'2015-03-25 14:36:29'),(226,97,4,1,0,3,'Estou em duvida entre assistir estes dois filmes. Qual me recomendam ?','(null)',0,0,0,'2015-03-25 14:51:42'),(227,97,5,1,0,1,'Como posso pedir pra um amigo meu me pagar sem ser considerado grosso ?','(null)',0,1,0,'2015-03-25 14:52:57'),(228,97,3,1,0,1,'Minhas contas estão apertadas. Como economizar dinheiro ?','(null)',0,0,0,'2015-03-25 14:56:11'),(229,97,7,1,0,3,'O que vocês me recomendam comprar ?','(null)',0,0,0,'2015-03-25 15:00:53'),(241,171,3,1,0,1,'Estou devendo 20 mil no banco e estou com risco de perder bens. Como posso evitar isso de forma legal ?','(null)',0,0,0,'2015-03-25 16:19:47'),(242,171,1,1,0,1,'Terminei um relacionamento e estou muito mal. Um psicólogo conseguiria me ajudar nessa situação ?','(null)',0,0,0,'2015-03-25 16:21:53'),(243,171,4,1,0,1,'Como desenhar personagens de anime de forma razoavel ?','(null)',0,0,0,'2015-03-25 16:24:31'),(247,97,2,2,0,2,'Como faço para me tornar um estudante melhor??','(null)',0,0,0,'2015-04-01 19:11:53'),(251,133,5,1,0,1,'Eu sou uma pessoa perfeccionista e me preocupo bastante com tudo. Mas as vezes isso me atrapalha um pouco. Como vocês fazem para não se preocuparem tanto?','(null)',0,1,0,'2015-04-02 21:42:20'),(252,97,4,1,0,1,'Teste de problema anônimo!','(null)',0,1,0,'2015-04-02 22:36:53'),(254,133,7,1,0,2,'Como posso melhorar a perfomance de um aplicativo iOS?','(null)',0,0,0,'2015-04-03 01:41:27'),(255,133,6,1,0,2,'Eu sei que uma das coisas mais importantes para uma carreira é o networking mas tenho um pouco de dificuldade em me comunicar com as pessoas. Como posso superar essa dificuldade?','(null)',0,1,0,'2015-04-03 05:00:54'),(256,133,5,1,0,1,'Muitas vezes eu não consigo pegar no sono porque automaticamente começo a pensar na vida e me preocupar. Como lidar com isso?','(null)',0,1,0,'2015-04-03 16:38:00'),(257,97,5,1,0,2,'Eu sou viciado em jogos e não consigo fazer nada além disso! Como me livrar desse vicio?','(null)',0,1,0,'2015-04-04 04:46:24');
232/*!40000 ALTER TABLE `tb_problema` ENABLE KEYS */;
233UNLOCK TABLES;
234
235--
236-- Table structure for table `tb_problema_alternativa`
237--
238
239DROP TABLE IF EXISTS `tb_problema_alternativa`;
240/*!40101 SET @saved_cs_client = @@character_set_client */;
241/*!40101 SET character_set_client = utf8 */;
242CREATE TABLE `tb_problema_alternativa` (
243 `id` bigint(20) NOT NULL AUTO_INCREMENT,
244 `id_problema` bigint(20) NOT NULL,
245 `descricao` varchar(50) NOT NULL,
246 `votos` int(11) NOT NULL COMMENT 'REDUNDANTE',
247 PRIMARY KEY (`id`)
248) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;
249/*!40101 SET character_set_client = @saved_cs_client */;
250
251--
252-- Dumping data for table `tb_problema_alternativa`
253--
254
255LOCK TABLES `tb_problema_alternativa` WRITE;
256/*!40000 ALTER TABLE `tb_problema_alternativa` DISABLE KEYS */;
257INSERT INTO `tb_problema_alternativa` VALUES (92,226,'Frozen',1),(93,226,'Shrek',0),(94,229,'iPhone 6',3),(95,229,'iPhone 5C',0);
258/*!40000 ALTER TABLE `tb_problema_alternativa` ENABLE KEYS */;
259UNLOCK TABLES;
260
261--
262-- Table structure for table `tb_problema_filtros`
263--
264
265DROP TABLE IF EXISTS `tb_problema_filtros`;
266/*!40101 SET @saved_cs_client = @@character_set_client */;
267/*!40101 SET character_set_client = utf8 */;
268CREATE TABLE `tb_problema_filtros` (
269 `id` bigint(20) NOT NULL AUTO_INCREMENT,
270 `id_problema` bigint(20) NOT NULL,
271 `tipo` tinyint(4) NOT NULL,
272 `value` int(11) NOT NULL,
273 PRIMARY KEY (`id`)
274) ENGINE=InnoDB DEFAULT CHARSET=latin1;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Dumping data for table `tb_problema_filtros`
279--
280
281LOCK TABLES `tb_problema_filtros` WRITE;
282/*!40000 ALTER TABLE `tb_problema_filtros` DISABLE KEYS */;
283/*!40000 ALTER TABLE `tb_problema_filtros` ENABLE KEYS */;
284UNLOCK TABLES;
285
286--
287-- Table structure for table `tb_problema_tags`
288--
289
290DROP TABLE IF EXISTS `tb_problema_tags`;
291/*!40101 SET @saved_cs_client = @@character_set_client */;
292/*!40101 SET character_set_client = utf8 */;
293CREATE TABLE `tb_problema_tags` (
294 `id` bigint(20) NOT NULL AUTO_INCREMENT,
295 `id_problema` bigint(20) NOT NULL,
296 `id_tag` int(11) NOT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `tb_problema_tags`
303--
304
305LOCK TABLES `tb_problema_tags` WRITE;
306/*!40000 ALTER TABLE `tb_problema_tags` DISABLE KEYS */;
307INSERT INTO `tb_problema_tags` VALUES (1,225,48),(2,228,49),(3,228,50),(4,241,49),(5,242,51),(6,244,52),(7,255,53),(8,255,54),(9,255,55);
308/*!40000 ALTER TABLE `tb_problema_tags` ENABLE KEYS */;
309UNLOCK TABLES;
310
311--
312-- Table structure for table `tb_problema_visualizar`
313--
314
315DROP TABLE IF EXISTS `tb_problema_visualizar`;
316/*!40101 SET @saved_cs_client = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `tb_problema_visualizar` (
319 `id` bigint(20) NOT NULL AUTO_INCREMENT,
320 `id_usuario` bigint(20) NOT NULL,
321 `id_problema` bigint(20) NOT NULL,
322 `data` datetime NOT NULL,
323 PRIMARY KEY (`id`)
324) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
325/*!40101 SET character_set_client = @saved_cs_client */;
326
327--
328-- Dumping data for table `tb_problema_visualizar`
329--
330
331LOCK TABLES `tb_problema_visualizar` WRITE;
332/*!40000 ALTER TABLE `tb_problema_visualizar` DISABLE KEYS */;
333INSERT INTO `tb_problema_visualizar` VALUES (27,133,224,'2015-04-01 20:12:16'),(28,133,225,'2015-04-01 20:12:16'),(29,133,226,'2015-04-01 20:12:16'),(30,133,227,'2015-04-01 20:12:16'),(31,133,228,'2015-04-01 20:12:16'),(32,133,229,'2015-04-01 20:12:16'),(33,133,241,'2015-04-01 20:12:16'),(34,133,242,'2015-04-01 20:12:16'),(35,133,243,'2015-04-01 20:12:16'),(36,133,244,'2015-04-01 20:12:16'),(37,133,247,'2015-04-01 23:32:32'),(38,133,241,'2015-04-02 21:39:40'),(39,133,242,'2015-04-02 21:39:40'),(40,133,243,'2015-04-02 21:39:40'),(41,133,244,'2015-04-02 21:39:40'),(42,133,250,'2015-04-02 22:37:11'),(43,135,252,'2015-04-02 22:38:05'),(44,135,224,'2015-04-02 22:38:21'),(45,135,225,'2015-04-02 22:38:21'),(46,135,226,'2015-04-02 22:38:21'),(47,135,227,'2015-04-02 22:38:21'),(48,135,228,'2015-04-02 22:38:21'),(49,135,229,'2015-04-02 22:38:21'),(50,135,241,'2015-04-02 22:38:21'),(51,135,242,'2015-04-02 22:38:21'),(52,135,243,'2015-04-02 22:38:21'),(53,135,247,'2015-04-02 22:38:21'),(54,97,251,'2015-04-03 00:53:58'),(55,97,253,'2015-04-03 00:53:58'),(56,133,252,'2015-04-04 04:46:50');
334/*!40000 ALTER TABLE `tb_problema_visualizar` ENABLE KEYS */;
335UNLOCK TABLES;
336
337--
338-- Table structure for table `tb_resposta`
339--
340
341DROP TABLE IF EXISTS `tb_resposta`;
342/*!40101 SET @saved_cs_client = @@character_set_client */;
343/*!40101 SET character_set_client = utf8 */;
344CREATE TABLE `tb_resposta` (
345 `id` bigint(20) NOT NULL AUTO_INCREMENT,
346 `id_usuario` bigint(20) NOT NULL,
347 `id_problema` bigint(20) NOT NULL,
348 `id_alternativa` int(11) DEFAULT NULL,
349 `descricao` varchar(1024) DEFAULT NULL,
350 `data` datetime NOT NULL,
351 PRIMARY KEY (`id`)
352) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `tb_resposta`
357--
358
359LOCK TABLES `tb_resposta` WRITE;
360/*!40000 ALTER TABLE `tb_resposta` DISABLE KEYS */;
361INSERT INTO `tb_resposta` VALUES (10,171,229,94,'<Passos>','2015-03-25 16:12:28'),(11,133,229,94,'<Passos>','2015-03-25 17:04:00'),(12,133,243,0,'Baixe o livro online Desenhando com Yako Ashira','2015-03-27 15:52:12'),(13,133,242,0,'Provavelmente sim.','2015-03-31 21:43:52'),(14,133,228,0,'Teste','2015-03-31 21:46:44'),(15,97,243,0,'Testando!!!','2015-04-01 16:57:27'),(16,97,243,0,'Será que agora vai?','2015-04-01 17:12:16'),(17,97,243,0,'Hmmmm','2015-04-01 17:16:43'),(18,135,225,0,'<passos>','2015-04-01 19:27:51'),(19,135,229,94,'<Passos>','2015-04-01 19:37:56'),(20,133,226,92,'<Passos>','2015-04-01 23:22:06'),(21,97,241,0,'Vender os seus bens e pagar suas dÃvidas!','2015-04-03 00:54:53');
362/*!40000 ALTER TABLE `tb_resposta` ENABLE KEYS */;
363UNLOCK TABLES;
364
365--
366-- Table structure for table `tb_resposta_ideia`
367--
368
369DROP TABLE IF EXISTS `tb_resposta_ideia`;
370/*!40101 SET @saved_cs_client = @@character_set_client */;
371/*!40101 SET character_set_client = utf8 */;
372CREATE TABLE `tb_resposta_ideia` (
373 `id` bigint(20) NOT NULL AUTO_INCREMENT,
374 `id_usuario` bigint(20) NOT NULL,
375 `id_resposta` bigint(20) NOT NULL,
376 `pontuacao` int(11) NOT NULL,
377 PRIMARY KEY (`id`)
378) ENGINE=InnoDB DEFAULT CHARSET=latin1;
379/*!40101 SET character_set_client = @saved_cs_client */;
380
381--
382-- Dumping data for table `tb_resposta_ideia`
383--
384
385LOCK TABLES `tb_resposta_ideia` WRITE;
386/*!40000 ALTER TABLE `tb_resposta_ideia` DISABLE KEYS */;
387/*!40000 ALTER TABLE `tb_resposta_ideia` ENABLE KEYS */;
388UNLOCK TABLES;
389
390--
391-- Table structure for table `tb_resposta_ideia_alteracao`
392--
393
394DROP TABLE IF EXISTS `tb_resposta_ideia_alteracao`;
395/*!40101 SET @saved_cs_client = @@character_set_client */;
396/*!40101 SET character_set_client = utf8 */;
397CREATE TABLE `tb_resposta_ideia_alteracao` (
398 `id` bigint(20) NOT NULL AUTO_INCREMENT,
399 `id_ideia` bigint(20) NOT NULL,
400 `descricao` varchar(250) NOT NULL,
401 `data` datetime NOT NULL,
402 PRIMARY KEY (`id`)
403) ENGINE=InnoDB DEFAULT CHARSET=latin1;
404/*!40101 SET character_set_client = @saved_cs_client */;
405
406--
407-- Dumping data for table `tb_resposta_ideia_alteracao`
408--
409
410LOCK TABLES `tb_resposta_ideia_alteracao` WRITE;
411/*!40000 ALTER TABLE `tb_resposta_ideia_alteracao` DISABLE KEYS */;
412/*!40000 ALTER TABLE `tb_resposta_ideia_alteracao` ENABLE KEYS */;
413UNLOCK TABLES;
414
415--
416-- Table structure for table `tb_resposta_ideia_comentario`
417--
418
419DROP TABLE IF EXISTS `tb_resposta_ideia_comentario`;
420/*!40101 SET @saved_cs_client = @@character_set_client */;
421/*!40101 SET character_set_client = utf8 */;
422CREATE TABLE `tb_resposta_ideia_comentario` (
423 `id` bigint(20) NOT NULL AUTO_INCREMENT,
424 `id_usuario` bigint(20) NOT NULL,
425 `id_ideia` int(11) NOT NULL,
426 `descricao` varchar(250) NOT NULL,
427 `data` datetime NOT NULL,
428 PRIMARY KEY (`id`)
429) ENGINE=InnoDB DEFAULT CHARSET=latin1;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Dumping data for table `tb_resposta_ideia_comentario`
434--
435
436LOCK TABLES `tb_resposta_ideia_comentario` WRITE;
437/*!40000 ALTER TABLE `tb_resposta_ideia_comentario` DISABLE KEYS */;
438/*!40000 ALTER TABLE `tb_resposta_ideia_comentario` ENABLE KEYS */;
439UNLOCK TABLES;
440
441--
442-- Table structure for table `tb_resposta_passos`
443--
444
445DROP TABLE IF EXISTS `tb_resposta_passos`;
446/*!40101 SET @saved_cs_client = @@character_set_client */;
447/*!40101 SET character_set_client = utf8 */;
448CREATE TABLE `tb_resposta_passos` (
449 `id` bigint(20) NOT NULL AUTO_INCREMENT,
450 `id_resposta` bigint(20) NOT NULL,
451 `numero` tinyint(2) NOT NULL,
452 `descricao` varchar(250) NOT NULL,
453 PRIMARY KEY (`id`)
454) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
455/*!40101 SET character_set_client = @saved_cs_client */;
456
457--
458-- Dumping data for table `tb_resposta_passos`
459--
460
461LOCK TABLES `tb_resposta_passos` WRITE;
462/*!40000 ALTER TABLE `tb_resposta_passos` DISABLE KEYS */;
463INSERT INTO `tb_resposta_passos` VALUES (1,18,1,'Seguir o seu coração.'),(2,18,2,'Fazer coisas legais.');
464/*!40000 ALTER TABLE `tb_resposta_passos` ENABLE KEYS */;
465UNLOCK TABLES;
466
467--
468-- Table structure for table `tb_tag`
469--
470
471DROP TABLE IF EXISTS `tb_tag`;
472/*!40101 SET @saved_cs_client = @@character_set_client */;
473/*!40101 SET character_set_client = utf8 */;
474CREATE TABLE `tb_tag` (
475 `id` bigint(20) NOT NULL AUTO_INCREMENT,
476 `nome` varchar(25) NOT NULL,
477 PRIMARY KEY (`id`)
478) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
479/*!40101 SET character_set_client = @saved_cs_client */;
480
481--
482-- Dumping data for table `tb_tag`
483--
484
485LOCK TABLES `tb_tag` WRITE;
486/*!40000 ALTER TABLE `tb_tag` DISABLE KEYS */;
487INSERT INTO `tb_tag` VALUES (48,'startup'),(49,'naotafacilpraninguem'),(50,'pobre'),(51,'bad'),(52,'ansiedade'),(53,'carreira'),(54,'networkinf'),(55,'dificuldades');
488/*!40000 ALTER TABLE `tb_tag` ENABLE KEYS */;
489UNLOCK TABLES;
490
491--
492-- Table structure for table `tb_usuario`
493--
494
495DROP TABLE IF EXISTS `tb_usuario`;
496/*!40101 SET @saved_cs_client = @@character_set_client */;
497/*!40101 SET character_set_client = utf8 */;
498CREATE TABLE `tb_usuario` (
499 `id` bigint(20) NOT NULL AUTO_INCREMENT,
500 `fbid` bigint(20) NOT NULL,
501 `nome` varchar(32) NOT NULL,
502 `email` varchar(50) NOT NULL,
503 `usuario` varchar(15) NOT NULL,
504 `senha` varchar(40) NOT NULL,
505 `biografia` varchar(1024) DEFAULT NULL,
506 `nivel` int(1) NOT NULL DEFAULT '1',
507 `experiencia` int(11) NOT NULL DEFAULT '0',
508 `nascimento` date NOT NULL,
509 `genero` int(1) NOT NULL,
510 `fotoPerfil` mediumblob,
511 `deletado` smallint(1) NOT NULL DEFAULT '0',
512 PRIMARY KEY (`id`)
513) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=latin1;
514/*!40101 SET character_set_client = @saved_cs_client */;
515
516--
517-- Dumping data for table `tb_usuario`
518--
519
520LOCK TABLES `tb_usuario` WRITE;
521/*!40000 ALTER TABLE `tb_usuario` DISABLE KEYS */;
522INSERT INTO `tb_usuario` VALUES (97,0,'Gabriel Sartori','biel.sartori@hotmail.com','G4BB3R','40bd001563085fc35165329ea1ff5c5ecbdbbeef','Sou uma pessoa simpatica',7,1068377,'1994-01-01',1,'__invalid__',0),(133,0,'André Gimenez Faria','andgfaria@msn.com','Andgfaria','40bd001563085fc35165329ea1ff5c5ecbdbbeef',' Eu sou um desenvolvedor mobile com orgulho!',6,1825,'0000-00-00',0,'__invalid__',0),(134,0,'Joao Torres','joaozin@zika.com','JoaoXD','40bd001563085fc35165329ea1ff5c5ecbdbbeef',' ',1,5,'0000-00-00',1,'__invalid__',0),(135,0,'Leticia Barbosa','lebb@mail.com','Lebarbosa','40bd001563085fc35165329ea1ff5c5ecbdbbeef',' Insira aqui minha biografia fofinha <3',1,40,'0000-00-00',2,'__invalid__',0),(159,920943704586321,'Gabriel Sartori','gabriel.sartori04@gmail.com','Haskell Coder','da39a3ee5e6b4b0d3255bfef95601890afd80709','Quem sou eu ?',1,0,'1994-02-04',2,NULL,0),(167,352494084961827,'Nicolau Maquiavel','','facebookGabriel','da39a3ee5e6b4b0d3255bfef95601890afd80709','Penso, logo existo',1,0,'0000-00-00',2,NULL,0),(168,0,'Joaozinhu','fake@hahah.com','xJETSx','40bd001563085fc35165329ea1ff5c5ecbdbbeef','',1,0,'1992-01-02',1,'',0),(169,0,'Gabriel Sx','123@fake.com','JoseManoel','40bd001563085fc35165329ea1ff5c5ecbdbbeef','',2,135,'2015-03-08',0,'__invalid__',0),(170,0,'Gabriel Ninja','uahuah@fake.com','Gabs','40bd001563085fc35165329ea1ff5c5ecbdbbeef','',1,65,'1996-03-08',0,'__invalid__',0),(171,1008199809194043,'Gabriel Sartori','gabriel.sartori04@gmail.com','Gabts','da39a3ee5e6b4b0d3255bfef95601890afd80709','Veni, vidi, vici',3,270,'1994-02-04',2,NULL,0),(173,0,'pikachu','123@123','ash','40bd001563085fc35165329ea1ff5c5ecbdbbeef','',1,0,'2015-03-26',0,'__invalid__',0),(174,0,'Robson Naosei','hahaah@gmail.com','Tiririca','40bd001563085fc35165329ea1ff5c5ecbdbbeef','',1,0,'2015-03-31',1,'__invalid__',0);
523/*!40000 ALTER TABLE `tb_usuario` ENABLE KEYS */;
524UNLOCK TABLES;
525
526--
527-- Table structure for table `tb_usuario_idioma`
528--
529
530DROP TABLE IF EXISTS `tb_usuario_idioma`;
531/*!40101 SET @saved_cs_client = @@character_set_client */;
532/*!40101 SET character_set_client = utf8 */;
533CREATE TABLE `tb_usuario_idioma` (
534 `id` bigint(20) NOT NULL AUTO_INCREMENT,
535 `id_usuario` bigint(20) NOT NULL,
536 `id_idioma` bigint(20) NOT NULL,
537 PRIMARY KEY (`id`)
538) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
539/*!40101 SET character_set_client = @saved_cs_client */;
540
541--
542-- Dumping data for table `tb_usuario_idioma`
543--
544
545LOCK TABLES `tb_usuario_idioma` WRITE;
546/*!40000 ALTER TABLE `tb_usuario_idioma` DISABLE KEYS */;
547INSERT INTO `tb_usuario_idioma` VALUES (19,173,1),(20,174,0),(21,133,2),(22,133,1),(23,135,3),(24,135,2),(25,135,1),(26,97,2),(27,97,1);
548/*!40000 ALTER TABLE `tb_usuario_idioma` ENABLE KEYS */;
549UNLOCK TABLES;
550
551--
552-- Table structure for table `tb_usuario_interesses`
553--
554
555DROP TABLE IF EXISTS `tb_usuario_interesses`;
556/*!40101 SET @saved_cs_client = @@character_set_client */;
557/*!40101 SET character_set_client = utf8 */;
558CREATE TABLE `tb_usuario_interesses` (
559 `id` bigint(20) NOT NULL AUTO_INCREMENT,
560 `id_usuario` bigint(20) NOT NULL,
561 `id_categoria` bigint(20) NOT NULL,
562 PRIMARY KEY (`id`)
563) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
564/*!40101 SET character_set_client = @saved_cs_client */;
565
566--
567-- Dumping data for table `tb_usuario_interesses`
568--
569
570LOCK TABLES `tb_usuario_interesses` WRITE;
571/*!40000 ALTER TABLE `tb_usuario_interesses` DISABLE KEYS */;
572INSERT INTO `tb_usuario_interesses` VALUES (95,151,7),(96,151,5),(97,151,1),(98,152,2),(99,152,1),(106,133,6),(107,133,5),(108,153,3),(109,161,1),(110,162,7),(111,162,1),(112,163,2),(113,163,1),(114,164,7),(115,164,1),(116,165,7),(117,165,3),(118,165,2),(119,165,1),(120,166,7),(121,166,4),(122,166,3),(123,166,1),(124,167,3),(125,167,2),(126,167,1),(127,168,3),(128,168,2),(129,168,1),(130,169,1),(131,170,1),(132,171,2),(133,171,1),(134,173,4),(135,174,2),(136,174,1),(137,135,2),(138,135,1),(139,97,7),(140,97,6),(141,97,5),(142,97,4),(143,97,2),(144,97,1);
573/*!40000 ALTER TABLE `tb_usuario_interesses` ENABLE KEYS */;
574UNLOCK TABLES;
575
576--
577-- Table structure for table `tb_usuario_notification_token`
578--
579
580DROP TABLE IF EXISTS `tb_usuario_notification_token`;
581/*!40101 SET @saved_cs_client = @@character_set_client */;
582/*!40101 SET character_set_client = utf8 */;
583CREATE TABLE `tb_usuario_notification_token` (
584 `id` bigint(20) NOT NULL AUTO_INCREMENT,
585 `id_usuario` bigint(20) NOT NULL,
586 `token` varchar(20) NOT NULL,
587 PRIMARY KEY (`id`)
588) ENGINE=InnoDB DEFAULT CHARSET=latin1;
589/*!40101 SET character_set_client = @saved_cs_client */;
590
591--
592-- Dumping data for table `tb_usuario_notification_token`
593--
594
595LOCK TABLES `tb_usuario_notification_token` WRITE;
596/*!40000 ALTER TABLE `tb_usuario_notification_token` DISABLE KEYS */;
597/*!40000 ALTER TABLE `tb_usuario_notification_token` ENABLE KEYS */;
598UNLOCK TABLES;
599
600--
601-- Table structure for table `tb_usuario_seguidores`
602--
603
604DROP TABLE IF EXISTS `tb_usuario_seguidores`;
605/*!40101 SET @saved_cs_client = @@character_set_client */;
606/*!40101 SET character_set_client = utf8 */;
607CREATE TABLE `tb_usuario_seguidores` (
608 `id` bigint(20) NOT NULL AUTO_INCREMENT,
609 `id_usuario` bigint(20) NOT NULL,
610 `id_seguidor` int(11) NOT NULL,
611 PRIMARY KEY (`id`)
612) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
613/*!40101 SET character_set_client = @saved_cs_client */;
614
615--
616-- Dumping data for table `tb_usuario_seguidores`
617--
618
619LOCK TABLES `tb_usuario_seguidores` WRITE;
620/*!40000 ALTER TABLE `tb_usuario_seguidores` DISABLE KEYS */;
621INSERT INTO `tb_usuario_seguidores` VALUES (5,97,133),(63,133,97),(66,97,135),(71,135,133);
622/*!40000 ALTER TABLE `tb_usuario_seguidores` ENABLE KEYS */;
623UNLOCK TABLES;
624/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
625
626/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
627/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
628/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
629/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
630/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
631/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
632/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
633
634-- Dump completed on 2015-04-06 17:03:14