(803,'3SD-117-BBEE','Djalma Almeida','djalma.almeida@tecpav.com.br',8,'3','Erro AutoCAD Civil 3D','Bom dia João<br />\n<br />\nestou tentando abrir o autocad e aparece a msn abaixo<br />\n<br />\n<br />\n<br />\ne não está acessando o autocad<br />\n<br />\n ','<p>Bom dia João</p>\n<p>estou tentando abrir o autocad e aparece a msn abaixo</p>\n<p><img class=\"fui-Image ui-known-width-and-height ___yjbthu0 fj3muxo f1akhkt f1aperda f1lxtadh f1fabniw f1ewtqcl f14t3ns0 fly5x3f f11ysow2 f1yrx710 f5p0z4x f1ni9pe4 f8491dx f1gh5sk6 fz5ioqm\" src=\"data:image/jpeg;base64,[encoded data, 31552 characters]\" alt=\"imagem\" /></p>\n<p>e não está acessando o autocad</p>\n<p><span> </span></p>','2025-10-22 14:46:29','2025-10-22 19:52:17','2025-10-22 19:52:17','2025-10-22 19:52:17',NULL,'',NULL,3,2,2,2,1,1,2,2,'05:05:46','1',2,'0','0','','','<li class=\"smaller\">22-10-2025 11:46:29 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">22-10-2025 11:46:29 | atribuído a João Moreira (joao_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">22-10-2025 16:52:17 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-24 03:00:00',0,0,NULL,NULL),(804,'WLW-W6J-XYJP','Leonardo Sousa','leo.sousa@tecpav.com.br',1,'3','Inclusão de Tipo de Documento - FATFOLHA','Prezados, boa tarde!<br />\r\n<br />\r\nSolicito providencias para a criação de novo tipo de documento na tabela do módulo Gestão Financeira, como segue:<br />\r\n<br />\r\nNome do tipo de documento: FATFOLHA<br />\r\n<br />\r\nJustificativa: Forma de unir lançamentos de obrigação trabalhistas de mesmo credor/funcionário para a realização de transação financeira única.<br />\r\n<br />\r\nSe restar alguma dúvida, estou ao dispor para auxiliá-los.<br />\r\n<br />\r\nAtenciosamente,<br />\r\n<br />\r\nLeonardo Delfino de Sousa<br />\r\nGer. financeiro','Prezados, boa tarde!<br />\r\n<br />\r\nSolicito providencias para a criação de novo tipo de documento na tabela do módulo Gestão Financeira, como segue:<br />\r\n<br />\r\nNome do tipo de documento: FATFOLHA<br />\r\n<br />\r\nJustificativa: Forma de unir lançamentos de obrigação trabalhistas de mesmo credor/funcionário para a realização de transação financeira única.<br />\r\n<br />\r\nSe restar alguma dúvida, estou ao dispor para auxiliá-los.<br />\r\n<br />\r\nAtenciosamente,<br />\r\n<br />\r\nLeonardo Delfino de Sousa<br />\r\nGer. financeiro','2025-10-23 18:11:12','2025-10-23 20:29:45',NULL,NULL,'6','177.11.144.210',NULL,0,0,NULL,NULL,0,0,10,6,'00:00:00','0',NULL,'0','0','','','<li class=\"smaller\">23-10-2025 15:11:12 | enviado por Cliente</li><li class=\"smaller\">23-10-2025 15:11:12 | atribuído automaticamente a Marcus Silva (marcus_silva)</li><li class=\"smaller\">23-10-2025 17:29:45 | atribuído a Jovaine Messias (jovaine_messias) por Vinicio Faria (vinicio_faria)</li>','Totvs RM – Financeiro','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-25 03:00:00',0,0,NULL,NULL),(805,'J9S-W1D-RJAZ','Wesley Alves | TECPAV','wesley.alves@tecpav.com.br',1,'3','RM','Bom dia,<br />\r\n<br />\r\nFavor verificar que não estou conseguindo vizualizar no RM,  a parte de movimento não estou conseguindo vizualizar aas horas estendida dos colabopradores,','Bom dia,<br />\r\n<br />\r\nFavor verificar que não estou conseguindo vizualizar no RM,  a parte de movimento não estou conseguindo vizualizar aas horas estendida dos colabopradores,','2025-10-27 14:05:38','2025-10-27 23:19:58','2025-10-27 23:19:58','2025-10-27 23:19:58','59','179.127.253.193',NULL,3,0,1,1,1,1,1,6,'00:02:16','1',1,'0','0','542#Capturar.PNG,','','<li class=\"smaller\">27-10-2025 11:05:38 | enviado por Cliente</li><li class=\"smaller\">27-10-2025 11:05:38 | atribuído automaticamente a Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">27-10-2025 11:12:30 | atribuído a Wesley Nunes (wesley_nunes) por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">27-10-2025 20:19:58 | status alterado para Resolvido por Wesley Nunes (wesley_nunes)</li>','Totvs RM – Gestão de Pessoas','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-29 03:00:00',0,0,NULL,NULL),(806,'ZTB-TA2-JBHW','Jailtons Soares','jailton.soares@tecpav.com.br',7,'3','Criar Usuário/E-mail','Favor providenciar e-mail para novo contratado.<br />\n<br />\n<br />\nNome: Helem Barros Ferreira<br />\nCPF: 08146005144<br />\nE-mail helembarrosferreira@gmail.com<br />\n<br />\nSds,<br />\n<br />\nJailton Soares','<p>Favor providenciar e-mail para novo contratado.<br /><br /><br />Nome: Helem Barros Ferreira<br />CPF: 08146005144<br />E-mail <a href=\"mailto:helembarrosferreira@gmail.com\">helembarrosferreira@gmail.com</a><br /><br />Sds,<br /><br />Jailton Soares</p>','2025-10-27 17:14:44','2025-10-28 17:51:05','2025-10-27 19:56:05','2025-10-28 17:51:05','6,7,59','190.124.54.151',NULL,3,0,2,10,3,3,10,2,'00:05:53','1',2,'0','0','','','<li class=\"smaller\">27-10-2025 14:14:44 | enviado por Cliente</li><li class=\"smaller\">27-10-2025 14:14:44 | atribuído automaticamente a João Moreira (joao_moreira)</li><li class=\"smaller\">27-10-2025 16:54:58 | movido para a categoria TI Redes e Infraestrutura por João Moreira (joao_moreira)</li><li class=\"smaller\">27-10-2025 16:55:50 | atribuído a Elyseu Moreira De Aguiar (elyseu_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">27-10-2025 16:56:05 | status alterado para Em progresso por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 11:28:47 | atribuído a João Moreira (joao_moreira) por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">28-10-2025 14:01:06 | atribuído a Jovaine Messias (jovaine_messias) por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 14:51:03 | fechado por Jovaine Messias (jovaine_messias)</li>','','','E-mail','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-29 03:00:00',0,0,NULL,NULL),(807,'7UW-M2D-QSUR','Jordana Oliveira','jordana.oliveira@tecpav.com.br',7,'3','Criar Usuário','Boa Tarde.<br />\n<br />\n <br />\n<br />\nPor gentileza criar e-mail e acesso ao notebook para a aprendiz Isabella Soares da Silva , e excluir do aprendiz Igor Almeida, pois o mesmo não trabalha mais no departamento ambiental. <br />\n<br />\n <br />\n<br />\nNotebook NT-T-APO012','<p class=\"MsoNormal\"><span style=\"color:#000000;\">Boa Tarde.</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\"> </span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\">Por gentileza criar e-mail e acesso ao notebook para a aprendiz Isabella Soares da Silva , e excluir do aprendiz Igor Almeida, pois o mesmo não trabalha mais no departamento ambiental. </span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\"> </span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\">Notebook NT-T-APO012</span></p>','2025-10-27 20:02:41','2025-10-28 18:34:58','2025-10-28 14:24:57','2025-10-28 17:04:11',NULL,'177.11.149.26',NULL,3,2,9,2,3,3,2,9,'00:07:44','1',2,'0','0','','','<li class=\"smaller\">27-10-2025 17:02:41 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">27-10-2025 17:02:41 | atribuído a Elyseu Moreira De Aguiar (elyseu_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 11:24:57 | status alterado para Em progresso por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">28-10-2025 11:25:08 | atribuído a João Moreira (joao_moreira) por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">28-10-2025 14:04:11 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-29 03:00:00',0,0,NULL,NULL),(808,'VJM-W7X-YZUX','Diego De Souza','diego.souza@tecpav.com.br',8,'3','Reinstalar Impressora','Resetaram o moldem aqui, poderia liberar minha impressora?<br />\n<br />\nNão esta imprimindo...<br />\n<br />\nHP 432<br />\n<br />\n ','<p>Resetaram o moldem aqui, poderia liberar minha impressora?</p>\n<p>Não esta imprimindo...<br /><br />HP 432</p>\n<p><span> </span></p>','2025-10-28 10:51:13','2025-10-28 11:11:50','2025-10-28 11:11:50','2025-10-28 11:11:50',NULL,'',NULL,3,2,2,2,1,1,2,2,'00:20:36','1',2,'0','0','','','<li class=\"smaller\">28-10-2025 07:51:13 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 07:51:13 | atribuído a João Moreira (joao_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 08:11:50 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-30 03:00:00',0,0,NULL,NULL),(809,'NVJ-39D-NH1Y','Suzana Luz','suzana.luz@tecpav.com.br',8,'3','Criação de E-mail p/ Aprendizes','Criar e-mail compartilhado para Aprendizes do Recebimento.','<p>Criar e-mail compartilhado para Aprendizes do Recebimento.</p>','2025-10-28 11:13:20','2025-10-28 11:14:25','2025-10-28 11:14:25','2025-10-28 11:14:25',NULL,'',NULL,3,2,2,2,1,1,2,2,'00:01:04','1',2,'0','0','','','<li class=\"smaller\">28-10-2025 08:13:20 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 08:13:20 | atribuído a João Moreira (joao_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 08:14:25 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-30 03:00:00',0,0,NULL,NULL),(810,'VU9-RTD-ZVRE','Rubens Freitas','rubens.freitas@tecpav.com.br',1,'2','Solicitação de acesso','Boa tarde, a todos!<br />\n<br />\npreciso de acesso no RM, na coligada CN1, pois temos um colaborador que veio transferido que esta nesta coligada, para fechamento dos relatórios.<br />\n<br />\npreciso de um apoio urgente quanto a isso.','<p class=\"MsoNormal\"><span style=\"color:#000000;\">Boa tarde, a todos!</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\">preciso de acesso no RM, na coligada CN1, pois temos um colaborador que veio transferido que esta nesta coligada, para fechamento dos relatórios.</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\">preciso de um apoio urgente quanto a isso.</span></p>','2025-10-28 16:52:13','2025-10-29 19:34:33','2025-10-29 19:34:33','2025-10-29 19:34:33',NULL,'',NULL,3,2,1,1,1,1,1,2,'00:00:23','1',1,'0','0','','','<li class=\"smaller\">28-10-2025 13:52:13 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 13:52:13 | atribuído a Wesley Nunes (wesley_nunes) por João Moreira (joao_moreira)</li><li class=\"smaller\">28-10-2025 13:52:21 | prioridade alterada para Média por João Moreira (joao_moreira)</li><li class=\"smaller\">29-10-2025 16:34:33 | status alterado para Resolvido por Wesley Nunes (wesley_nunes)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-30 03:00:00',0,0,NULL,NULL),(811,'UB1-97L-L9XH','Vandeir Rezende','vandeir.rezende@tecpav.com.br',1,'3','LIBERACAO ACESSO MONITOR OBRAS','Bom dia!<br />\r\n<br />\r\nNecessito ter acesso ao Monitor de Ponto das obras, no momento aprece somente a minha equipe.','Bom dia!<br />\r\n<br />\r\nNecessito ter acesso ao Monitor de Ponto das obras, no momento aprece somente a minha equipe.','2025-10-29 12:38:29','2025-10-29 19:34:02','2025-10-29 19:34:02',NULL,'6,60','177.11.149.26',NULL,2,0,1,NULL,2,1,1,10,'00:00:37','1',1,'0','0','543#Monitor-ponto.png,','','<li class=\"smaller\">29-10-2025 09:38:28 | enviado por Cliente</li><li class=\"smaller\">29-10-2025 09:38:28 | atribuído automaticamente a Marcus Silva (marcus_silva)</li><li class=\"smaller\">29-10-2025 15:09:33 | atribuído a Jovaine Messias (jovaine_messias) por Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">29-10-2025 15:12:28 | atribuído a Wesley Nunes (wesley_nunes) por Jovaine Messias (jovaine_messias)</li>','Portal','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-31 03:00:00',0,0,NULL,NULL),(812,'U3B-QNR-ZVJJ','Gabriela Freitas','gabriella.freitas@tecpav.com.br',7,'3','Instalar impressora','Sem acesso a impressora.','Sem acesso a impressora.','2025-10-29 14:47:07','2025-10-29 17:30:38','2025-10-29 17:30:38','2025-10-29 17:30:38','6','190.124.54.165',NULL,3,0,2,2,1,1,2,9,'00:39:19','1',2,'0','0','','','<li class=\"smaller\">29-10-2025 11:47:07 | enviado por Cliente</li><li class=\"smaller\">29-10-2025 11:47:07 | atribuído automaticamente a Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">29-10-2025 11:50:36 | atribuído a João Moreira (joao_moreira) por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">29-10-2025 14:30:38 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','Serviço de Impressão na Rede Local','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-31 03:00:00',0,0,NULL,NULL),(813,'J7U-EVV-PJ43','Monize Silva','monize.silva@tecpav.com.br',8,'3','Disco Cheio','Acusando disco cheio.','<p>Acusando disco cheio.</p>','2025-10-29 18:01:24','2025-10-29 18:24:12','2025-10-29 18:24:12','2025-10-29 18:24:12',NULL,'',NULL,3,2,2,2,1,1,2,2,'00:22:47','1',2,'0','0','','','<li class=\"smaller\">29-10-2025 15:01:24 | chamado criado por João Moreira (joao_moreira)</li><li class=\"smaller\">29-10-2025 15:01:24 | atribuído a João Moreira (joao_moreira) por João Moreira (joao_moreira)</li><li class=\"smaller\">29-10-2025 15:24:12 | status alterado para Resolvido por João Moreira (joao_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','2025-10-31 03:00:00',0,0,NULL,NULL);

--
-- Table structure for table `hesk_users`
--

CREATE TABLE `hesk_users` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `pass` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `isadmin` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `signature` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `language` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `categories` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `afterreply` enum('0','1','2') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `autostart` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `autoreload` smallint unsigned NOT NULL DEFAULT '0',
  `notify_customer_new` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_customer_reply` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `show_suggested` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_new_unassigned` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_new_my` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_reply_unassigned` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_reply_my` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_assigned` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_pm` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_note` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_overdue_unassigned` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_overdue_my` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `notify_customer_approval` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `default_list` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `autoassign` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '1',
  `heskprivileges` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ratingneg` mediumint unsigned NOT NULL DEFAULT '0',
  `ratingpos` mediumint unsigned NOT NULL DEFAULT '0',
  `rating` float NOT NULL DEFAULT '0',
  `replies` mediumint unsigned NOT NULL DEFAULT '0',
  `mfa_enrollment` smallint unsigned NOT NULL DEFAULT '0',
  `mfa_secret` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `autoassign` (`autoassign`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_users`
--

INSERT INTO `hesk_users` VALUES (1,'wesley_nunes','$2y$10$76E2VzQWiQoEH/QNkyui0.rt1oUwg8mD5eCcvsyPDfPrEfU1FrryO','1','Wesley Nunes','wesley.nunes@tecpav.com.br','',NULL,'','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','','1','',2,3,3.4,49,0,NULL),(2,'joao_moreira','$2y$10$Em5yLQZMkAoIdhUE3N4tieAon4IcvfCe/7yP/mP0ILz4x.htBzJ46','1','João Moreira','joao.moreira@tecpav.com.br','João Moreira | Analista de TI\r\n\r\n(62) 3237.3963 | 99227.5304\r\njoao.moreira@tecpav.com.br',NULL,'','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','','1','',1,1,3,176,0,NULL),(11,'marcus_silva','$2y$10$nwmjXJcWzoNmF4g0ZSITQOBzAIIKdP/T1hvU1NdVNpuOFTyXv9oUC','0','Marcus Silva','marcus.silva@tecpav.com.br','Marcus Silva\r\nAssistente Administrativo\r\n62 3237-3968\r\nmarcus.silva@tecpav.com.br',NULL,'1','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','','1','can_view_tickets,can_reply_tickets,can_del_tickets,can_edit_tickets,can_merge_tickets,can_resolve,can_submit_any_cat,can_del_notes,can_change_cat,can_change_own_cat,can_due_date,can_man_kb,can_man_users,can_view_users,can_man_cat,can_man_canned,can_man_ticket_tpl,can_add_archive,can_assign_self,can_assign_others,can_view_unassigned,can_view_ass_others,can_view_ass_by,can_run_reports,can_run_reports_full,can_export,can_view_online,can_ban_emails,can_unban_emails,can_ban_ips,can_unban_ips,can_privacy,can_service_msg,can_email_tpl,can_man_customers,can_view_customers,can_view_tickets',0,3,5,5,0,NULL),(8,'manoel_junior','$2y$10$IVYmttvETrxJGLiCGm2un.184TRC7V5MU6U68zfpB5LaeFV6jhrl2','0','Manoel Junior','manoel.junior@tecpav.com.br','Manoel Júnior\r\nSuporte TI\r\n3237-3963\r\nmanoel.junior@tecpav.com.br',NULL,'8,9','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','','1','can_view_tickets,can_reply_tickets,can_del_tickets,can_edit_tickets,can_merge_tickets,can_resolve,can_submit_any_cat,can_del_notes,can_change_cat,can_change_own_cat,can_due_date,can_man_kb,can_man_users,can_view_users,can_man_cat,can_man_canned,can_man_ticket_tpl,can_add_archive,can_assign_self,can_assign_others,can_view_unassigned,can_view_ass_others,can_view_ass_by,can_run_reports,can_run_reports_full,can_export,can_view_online,can_ban_emails,can_unban_emails,can_ban_ips,can_unban_ips,can_privacy,can_service_msg,can_email_tpl,can_man_customers,can_view_customers,can_view_tickets',0,0,0,48,0,NULL),(5,'disley_oliveira','$2y$10$Ebau1p8mNO3GVeN3otfFKuefSH.t7wfhZrHr.NpoSEJpCiGSj2blu','1','Disley Oliveira','disley.oliveira@tecpav.com.br','',NULL,'','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','s0=1&s1=1&s2=1&s4=1&s5=1&p0=1&p1=1&p2=1&p3=1&s_my=1&s_un=1&s_ot=1&sort=status&g=category&duedate_option=specific&duedate_specific_date=&duedate_amount_value=0&duedate_amount_unit=day&category=0&limit=20&asc=1&more=0','1','',2,7,4.11111,152,0,NULL),(6,'vinicio_faria','$2y$10$mVrh8luSwK9VurBASs0MOe1LR5Tg1fM15zos8oRkGsQwJ7cuFVz6m','1','Vinicio Faria','vinicio.faria@tecpav.com.br','Att: Vinicio Faria - Analista de Sistemas\r\n062 3237 3965\r\nvinicio.faria@tecpav.com.br',NULL,'','1','1',180,'1','1','1','0','1','0','1','1','1','1','0','1','0','s0=1&s1=1&s2=1&s4=1&s5=1&p0=1&p1=1&p2=1&p3=1&s_my=1&s_un=1&s_ot=1&sort=lastchange&g=&duedate_option=specific&duedate_specific_date=&duedate_amount_value=0&duedate_amount_unit=day&category=1&limit=20&asc=0&more=0','1','',1,24,4.84,166,0,NULL),(9,'elyseu_moreira','$2y$10$X1z1r52IesOVf3VJ74L81.wklXesaWZWuKcS1kLH1yo3kdhV0WQpu','1','Elyseu Moreira De Aguiar','elyseu.moreira@tecpav.com.br','',NULL,'','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','','1','',1,4,4.2,187,0,'N7RNGQNTYSDEPCAT'),(10,'jovaine_messias','$2y$10$5zOpJi8XystZZABgrjOW6OuuaK25byEhEiLoTYwQcNxuey.Hq2l6m','0','Jovaine Messias','jovaine.messias@tecpav.com.br','Jovaine M. de Castro\r\nAnalista de TI\r\n(62) 3237-3967\r\njovaine.messias@tecpav.com.br',NULL,'1,7,8,9','1','1',180,'1','1','1','1','1','1','1','1','1','1','1','1','0','s0=1&s1=1&s2=1&s3=1&s4=1&s5=1&p0=1&p1=1&p2=1&p3=1&s_my=1&sort=status&g=&duedate_option=specific&duedate_specific_date=&duedate_amount_value=0&duedate_amount_unit=day&category=0&limit=20&asc=1&more=0','1','can_view_tickets,can_reply_tickets,can_del_tickets,can_edit_tickets,can_merge_tickets,can_resolve,can_submit_any_cat,can_del_notes,can_change_cat,can_change_own_cat,can_due_date,can_man_kb,can_man_users,can_view_users,can_man_cat,can_man_canned,can_man_ticket_tpl,can_add_archive,can_assign_self,can_assign_others,can_view_unassigned,can_view_ass_others,can_view_ass_by,can_run_reports,can_run_reports_full,can_export,can_view_online,can_ban_emails,can_unban_emails,can_ban_ips,can_unban_ips,can_privacy,can_service_msg,can_email_tpl,can_man_customers,can_view_customers,can_view_tickets',1,6,4.42857,168,0,NULL);

--
-- Final view structure for view `VW_ATENDIMENTOS`
--

/*!50001 DROP VIEW IF EXISTS `VW_ATENDIMENTOS`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `VW_ATENDIMENTOS` AS select `hesk_tickets`.`id` AS `id`,`hesk_tickets`.`trackid` AS `trackid`,`hesk_tickets`.`u_name` AS `u_name`,`hesk_tickets`.`u_email` AS `u_email`,`hesk_tickets`.`category` AS `category`,`hesk_tickets`.`priority` AS `priority`,`hesk_tickets`.`subject` AS `subject`,`hesk_tickets`.`message` AS `message`,`hesk_tickets`.`message_html` AS `message_html`,`hesk_tickets`.`dt` AS `dt`,`hesk_tickets`.`lastchange` AS `lastchange`,`hesk_tickets`.`firstreply` AS `firstreply`,`hesk_tickets`.`closedat` AS `closedat`,`hesk_tickets`.`articles` AS `articles`,`hesk_tickets`.`ip` AS `ip`,`hesk_tickets`.`language` AS `language`,`hesk_tickets`.`status` AS `status`,`hesk_tickets`.`openedby` AS `openedby`,`hesk_tickets`.`firstreplyby` AS `firstreplyby`,`hesk_tickets`.`closedby` AS `closedby`,`hesk_tickets`.`replies` AS `replies`,`hesk_tickets`.`staffreplies` AS `staffreplies`,`hesk_tickets`.`owner` AS `owner`,`hesk_tickets`.`assignedby` AS `assignedby`,`hesk_tickets`.`time_worked` AS `time_worked`,`hesk_tickets`.`lastreplier` AS `lastreplier`,`hesk_tickets`.`replierid` AS `replierid`,`hesk_tickets`.`archive` AS `archive`,`hesk_tickets`.`locked` AS `locked`,`hesk_tickets`.`attachments` AS `attachments`,`hesk_tickets`.`merged` AS `merged`,`hesk_tickets`.`history` AS `history`,`hesk_tickets`.`custom1` AS `custom1`,`hesk_tickets`.`custom2` AS `custom2`,`hesk_tickets`.`custom3` AS `custom3`,`hesk_tickets`.`custom4` AS `custom4`,`hesk_tickets`.`custom5` AS `custom5`,`hesk_tickets`.`custom6` AS `custom6`,`hesk_tickets`.`custom7` AS `custom7`,`hesk_tickets`.`custom8` AS `custom8`,`hesk_tickets`.`custom9` AS `custom9`,`hesk_tickets`.`custom10` AS `custom10`,`hesk_tickets`.`custom11` AS `custom11`,`hesk_tickets`.`custom12` AS `custom12`,`hesk_tickets`.`custom13` AS `custom13`,`hesk_tickets`.`custom14` AS `custom14`,`hesk_tickets`.`custom15` AS `custom15`,`hesk_tickets`.`custom16` AS `custom16`,`hesk_tickets`.`custom17` AS `custom17`,`hesk_tickets`.`custom18` AS `custom18`,`hesk_tickets`.`custom19` AS `custom19`,`hesk_tickets`.`custom20` AS `custom20`,`hesk_tickets`.`custom21` AS `custom21`,`hesk_tickets`.`custom22` AS `custom22`,`hesk_tickets`.`custom23` AS `custom23`,`hesk_tickets`.`custom24` AS `custom24`,`hesk_tickets`.`custom25` AS `custom25`,`hesk_tickets`.`custom26` AS `custom26`,`hesk_tickets`.`custom27` AS `custom27`,`hesk_tickets`.`custom28` AS `custom28`,`hesk_tickets`.`custom29` AS `custom29`,`hesk_tickets`.`custom30` AS `custom30`,`hesk_tickets`.`custom31` AS `custom31`,`hesk_tickets`.`custom32` AS `custom32`,`hesk_tickets`.`custom33` AS `custom33`,`hesk_tickets`.`custom34` AS `custom34`,`hesk_tickets`.`custom35` AS `custom35`,`hesk_tickets`.`custom36` AS `custom36`,`hesk_tickets`.`custom37` AS `custom37`,`hesk_tickets`.`custom38` AS `custom38`,`hesk_tickets`.`custom39` AS `custom39`,`hesk_tickets`.`custom40` AS `custom40`,`hesk_tickets`.`custom41` AS `custom41`,`hesk_tickets`.`custom42` AS `custom42`,`hesk_tickets`.`custom43` AS `custom43`,`hesk_tickets`.`custom44` AS `custom44`,`hesk_tickets`.`custom45` AS `custom45`,`hesk_tickets`.`custom46` AS `custom46`,`hesk_tickets`.`custom47` AS `custom47`,`hesk_tickets`.`custom48` AS `custom48`,`hesk_tickets`.`custom49` AS `custom49`,`hesk_tickets`.`custom50` AS `custom50`,`hesk_tickets`.`custom51` AS `custom51`,`hesk_tickets`.`custom52` AS `custom52`,`hesk_tickets`.`custom53` AS `custom53`,`hesk_tickets`.`custom54` AS `custom54`,`hesk_tickets`.`custom55` AS `custom55`,`hesk_tickets`.`custom56` AS `custom56`,`hesk_tickets`.`custom57` AS `custom57`,`hesk_tickets`.`custom58` AS `custom58`,`hesk_tickets`.`custom59` AS `custom59`,`hesk_tickets`.`custom60` AS `custom60`,`hesk_tickets`.`custom61` AS `custom61`,`hesk_tickets`.`custom62` AS `custom62`,`hesk_tickets`.`custom63` AS `custom63`,`hesk_tickets`.`custom64` AS `custom64`,`hesk_tickets`.`custom65` AS `custom65`,`hesk_tickets`.`custom66` AS `custom66`,`hesk_tickets`.`custom67` AS `custom67`,`hesk_tickets`.`custom68` AS `custom68`,`hesk_tickets`.`custom69` AS `custom69`,`hesk_tickets`.`custom70` AS `custom70`,`hesk_tickets`.`custom71` AS `custom71`,`hesk_tickets`.`custom72` AS `custom72`,`hesk_tickets`.`custom73` AS `custom73`,`hesk_tickets`.`custom74` AS `custom74`,`hesk_tickets`.`custom75` AS `custom75`,`hesk_tickets`.`custom76` AS `custom76`,`hesk_tickets`.`custom77` AS `custom77`,`hesk_tickets`.`custom78` AS `custom78`,`hesk_tickets`.`custom79` AS `custom79`,`hesk_tickets`.`custom80` AS `custom80`,`hesk_tickets`.`custom81` AS `custom81`,`hesk_tickets`.`custom82` AS `custom82`,`hesk_tickets`.`custom83` AS `custom83`,`hesk_tickets`.`custom84` AS `custom84`,`hesk_tickets`.`custom85` AS `custom85`,`hesk_tickets`.`custom86` AS `custom86`,`hesk_tickets`.`custom87` AS `custom87`,`hesk_tickets`.`custom88` AS `custom88`,`hesk_tickets`.`custom89` AS `custom89`,`hesk_tickets`.`custom90` AS `custom90`,`hesk_tickets`.`custom91` AS `custom91`,`hesk_tickets`.`custom92` AS `custom92`,`hesk_tickets`.`custom93` AS `custom93`,`hesk_tickets`.`custom94` AS `custom94`,`hesk_tickets`.`custom95` AS `custom95`,`hesk_tickets`.`custom96` AS `custom96`,`hesk_tickets`.`custom97` AS `custom97`,`hesk_tickets`.`custom98` AS `custom98`,`hesk_tickets`.`custom99` AS `custom99`,`hesk_tickets`.`custom100` AS `custom100`,`hesk_tickets`.`due_date` AS `due_date`,`hesk_tickets`.`overdue_email_sent` AS `overdue_email_sent`,`hesk_tickets`.`satisfaction_email_sent` AS `satisfaction_email_sent`,`hesk_tickets`.`satisfaction_email_dt` AS `satisfaction_email_dt`,`hesk_tickets`.`eid` AS `eid` from `hesk_tickets` */;


