
--
-- Table structure for table `hesk_reset_password`
--

CREATE TABLE `hesk_reset_password` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `user` smallint unsigned NOT NULL,
  `hash` char(40) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_type` varchar(8) NOT NULL DEFAULT 'STAFF',
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hesk_reset_password`
--


--
-- Table structure for table `hesk_service_messages`
--

CREATE TABLE `hesk_service_messages` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `author` smallint unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `language` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `style` enum('0','1','2','3','4') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `type` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `order` smallint unsigned NOT NULL DEFAULT '0',
  `location` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_service_messages`
--


--
-- Table structure for table `hesk_std_replies`
--

CREATE TABLE `hesk_std_replies` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message_html` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `reply_order` smallint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_std_replies`
--

INSERT INTO `hesk_std_replies` VALUES (1,'Atendimento realizado via Ticket','Conforme solicitado, atendimento realizado via ticket.','<p>Conforme solicitado, atendimento realizado via ticket.</p>',10),(2,'Atendimento realizado via ligação','Conforme solicitado, atendimento realizado via Ligação.','<p>Conforme solicitado, atendimento realizado via Ligação.</p>',30),(3,'Atendimento realizado via WhatsApp/Teams','Conforme solicitado, atendimento realizado via WhatsApp/Teams.','<p>Conforme solicitado, atendimento realizado via WhatsApp/Teams.</p>',40),(5,'Atendimento realizado via Acesso Remoto','Conforme solicitado, atendimento realizado via acesso remoto.','<p>Conforme solicitado, atendimento realizado via acesso remoto.</p>',20);

--
-- Table structure for table `hesk_temp_attachments`
--

CREATE TABLE `hesk_temp_attachments` (
  `att_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `saved_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `real_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `size` int unsigned NOT NULL DEFAULT '0',
  `expires_at` timestamp NOT NULL,
  PRIMARY KEY (`att_id`)
) ENGINE=MyISAM AUTO_INCREMENT=562 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_temp_attachments`
--


--
-- Table structure for table `hesk_temp_attachments_limits`
--

CREATE TABLE `hesk_temp_attachments_limits` (
  `ip` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `upload_count` int unsigned NOT NULL DEFAULT '1',
  `last_upload_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_temp_attachments_limits`
--


--
-- Table structure for table `hesk_ticket_templates`
--

CREATE TABLE `hesk_ticket_templates` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message_html` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `tpl_order` smallint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_ticket_templates`
--

INSERT INTO `hesk_ticket_templates` VALUES (4,'Criação de usuários e suas permissões','- Nome do Solicitante: [Preenchido automaticamente]\r\n- Setor: [Selecionar no menu suspenso]\r\n- E-mail para contato: [E-mail do usuário]\r\n\r\n- Descrição detalhada:\r\nExplique o problema, quando começou e o que já foi tentado para resolver.\r\n\r\n- Mensagem de erro (se houver):\r\n[Copiar e colar a mensagem exata]\r\n\r\n- Impacto no trabalho:\r\n? Alto | ? Médio | ? Baixo','<ul>\n<li><strong>Nome do Solicitante:</strong> [Preenchido automaticamente]</li>\n<li><strong>Setor:</strong> [Selecionar no menu suspenso]</li>\n<li><strong>E-mail para contato:</strong> [E-mail do usuário]</li>\n</ul>\n<ul>\n<li><strong>Descrição detalhada:</strong>\n<blockquote>\n<p>Explique o problema, quando começou e o que já foi tentado para resolver.</p>\n</blockquote>\n</li>\n<li><strong>Mensagem de erro (se houver):</strong>\n<blockquote>\n<p>[Copiar e colar a mensagem exata]</p>\n</blockquote>\n</li>\n<li><strong>Impacto no trabalho:</strong>\n<blockquote>\n<p>? Alto | ? Médio | ? Baixo</p>\n</blockquote>\n</li>\n</ul>',10),(3,'TI - Erro ao acessar o sistema ERP','- Nome do Solicitante: [Preenchido automaticamente]\r\n- Setor: [Selecionar no menu suspenso]\r\n- E-mail para contato: [E-mail do usuário]\r\n\r\n- Descrição detalhada:\r\nExplique o problema, quando começou e o que já foi tentado para resolver.\r\n\r\n- Mensagem de erro (se houver):\r\n[Copiar e colar a mensagem exata]\r\n\r\n- Impacto no trabalho:\r\n? Alto | ? Médio | ? Baixo','<ul>\n<li><strong>Nome do Solicitante:</strong> [Preenchido automaticamente]</li>\n<li><strong>Setor:</strong> [Selecionar no menu suspenso]</li>\n<li><strong>E-mail para contato:</strong> [E-mail do usuário]</li>\n</ul>\n<ul>\n<li><strong>Descrição detalhada:</strong>\n<blockquote>\n<p>Explique o problema, quando começou e o que já foi tentado para resolver.</p>\n</blockquote>\n</li>\n<li><strong>Mensagem de erro (se houver):</strong>\n<blockquote>\n<p>[Copiar e colar a mensagem exata]</p>\n</blockquote>\n</li>\n<li><strong>Impacto no trabalho:</strong>\n<blockquote>\n<p>? Alto | ? Médio | ? Baixo</p>\n</blockquote>\n</li>\n</ul>',20);

--
-- Table structure for table `hesk_ticket_to_customer`
--

CREATE TABLE `hesk_ticket_to_customer` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` mediumint unsigned NOT NULL,
  `customer_id` mediumint unsigned NOT NULL,
  `customer_type` varchar(9) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'REQUESTER',
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1189 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_ticket_to_customer`
--

INSERT INTO `hesk_ticket_to_customer` VALUES (28,27,66,'REQUESTER'),(31,30,87,'REQUESTER'),(32,31,256,'REQUESTER'),(33,32,201,'REQUESTER'),(34,33,257,'REQUESTER'),(36,34,66,'REQUESTER'),(37,35,97,'REQUESTER'),(38,36,201,'REQUESTER'),(39,37,257,'REQUESTER'),(40,38,258,'REQUESTER'),(44,39,133,'REQUESTER'),(42,40,37,'REQUESTER'),(43,41,102,'REQUESTER'),(45,42,258,'REQUESTER'),(46,43,102,'REQUESTER'),(47,44,102,'REQUESTER'),(48,45,86,'REQUESTER'),(49,46,135,'REQUESTER'),(50,46,259,'FOLLOWER'),(51,46,256,'FOLLOWER'),(52,47,152,'REQUESTER'),(54,49,190,'REQUESTER'),(55,49,66,'FOLLOWER'),(286,225,129,'REQUESTER'),(278,217,87,'REQUESTER'),(277,216,87,'REQUESTER'),(280,219,102,'REQUESTER'),(282,221,73,'REQUESTER'),(413,311,107,'REQUESTER'),(64,52,259,'REQUESTER'),(65,53,260,'REQUESTER'),(66,54,135,'REQUESTER'),(67,55,126,'REQUESTER'),(68,56,210,'REQUESTER'),(69,57,237,'REQUESTER'),(70,58,252,'REQUESTER'),(71,59,195,'REQUESTER'),(133,60,270,'REQUESTER'),(73,61,178,'REQUESTER'),(74,62,120,'REQUESTER'),(75,63,16,'REQUESTER'),(76,63,132,'FOLLOWER'),(77,64,261,'REQUESTER'),(78,65,96,'REQUESTER'),(79,66,227,'REQUESTER'),(80,67,178,'REQUESTER'),(81,67,79,'FOLLOWER'),(83,69,180,'REQUESTER'),(84,70,184,'REQUESTER'),(85,71,180,'REQUESTER'),(86,72,102,'REQUESTER'),(87,73,161,'REQUESTER'),(88,73,143,'FOLLOWER'),(89,74,249,'REQUESTER'),(90,75,238,'REQUESTER'),(91,75,30,'FOLLOWER'),(92,76,87,'REQUESTER'),(93,76,57,'FOLLOWER'),(94,77,90,'REQUESTER'),(95,77,135,'FOLLOWER'),(96,78,161,'REQUESTER'),(97,79,126,'REQUESTER'),(99,81,139,'REQUESTER'),(100,81,67,'FOLLOWER'),(176,82,122,'REQUESTER'),(103,84,262,'REQUESTER'),(104,84,263,'FOLLOWER'),(105,84,264,'FOLLOWER'),(106,85,257,'REQUESTER'),(107,86,114,'REQUESTER'),(108,86,111,'FOLLOWER'),(109,87,102,'REQUESTER'),(110,88,12,'REQUESTER'),(111,89,161,'REQUESTER'),(112,89,126,'FOLLOWER'),(113,90,16,'REQUESTER'),(114,91,86,'REQUESTER'),(115,92,178,'REQUESTER'),(116,93,122,'REQUESTER'),(117,93,31,'FOLLOWER'),(118,94,157,'REQUESTER'),(119,95,265,'REQUESTER'),(120,96,31,'REQUESTER'),(121,97,129,'REQUESTER'),(122,98,41,'REQUESTER'),(123,98,122,'FOLLOWER'),(124,99,77,'REQUESTER'),(125,100,230,'REQUESTER'),(126,101,266,'REQUESTER'),(127,102,253,'REQUESTER'),(128,103,41,'REQUESTER'),(129,104,198,'REQUESTER'),(130,105,97,'REQUESTER'),(131,106,182,'REQUESTER'),(132,107,34,'REQUESTER'),(134,108,229,'REQUESTER'),(135,108,187,'FOLLOWER'),(136,108,190,'FOLLOWER'),(137,108,37,'FOLLOWER'),(138,108,44,'FOLLOWER'),(139,109,135,'REQUESTER'),(140,109,90,'FOLLOWER'),(288,227,157,'REQUESTER'),(142,111,110,'REQUESTER'),(143,111,218,'FOLLOWER'),(144,112,253,'REQUESTER'),(145,113,139,'REQUESTER'),(146,114,129,'REQUESTER'),(147,115,135,'REQUESTER'),(148,115,152,'FOLLOWER'),(149,116,277,'REQUESTER'),(150,117,44,'REQUESTER'),(151,118,29,'REQUESTER'),(152,118,135,'FOLLOWER'),(153,119,153,'REQUESTER'),(154,120,152,'REQUESTER'),(155,120,135,'FOLLOWER'),(156,121,184,'REQUESTER'),(157,122,129,'REQUESTER'),(158,123,277,'REQUESTER'),(159,123,114,'FOLLOWER'),(160,124,197,'REQUESTER'),(161,125,31,'REQUESTER'),(162,125,122,'FOLLOWER'),(163,126,87,'REQUESTER'),(164,126,30,'FOLLOWER'),(165,127,13,'REQUESTER'),(166,128,210,'REQUESTER'),(167,129,111,'REQUESTER'),(168,130,53,'REQUESTER'),(169,131,67,'REQUESTER'),(170,132,178,'REQUESTER'),(171,133,65,'REQUESTER'),(172,134,109,'REQUESTER'),(173,135,260,'REQUESTER'),(174,136,96,'REQUESTER'),(175,137,279,'REQUESTER'),(200,157,187,'REQUESTER'),(189,150,134,'REQUESTER'),(190,150,32,'FOLLOWER'),(191,150,93,'FOLLOWER'),(192,150,281,'FOLLOWER'),(193,151,108,'REQUESTER'),(194,151,76,'FOLLOWER'),(195,152,41,'REQUESTER'),(196,153,41,'REQUESTER'),(197,154,180,'REQUESTER'),(253,156,87,'REQUESTER'),(201,158,248,'REQUESTER'),(202,159,258,'REQUESTER'),(203,160,76,'REQUESTER'),(204,161,277,'REQUESTER'),(205,162,31,'REQUESTER'),(206,163,87,'REQUESTER'),(207,164,251,'REQUESTER'),(209,166,77,'REQUESTER'),(210,166,254,'FOLLOWER'),(211,167,155,'REQUESTER'),(212,168,87,'REQUESTER'),(213,169,238,'REQUESTER'),(214,169,32,'FOLLOWER'),(216,170,201,'REQUESTER'),(217,170,66,'FOLLOWER'),(218,171,238,'REQUESTER'),(219,172,277,'REQUESTER'),(220,173,157,'REQUESTER'),(221,174,87,'REQUESTER'),(222,175,138,'REQUESTER'),(223,175,141,'FOLLOWER'),(224,176,180,'REQUESTER'),(225,177,149,'REQUESTER'),(226,178,111,'REQUESTER'),(227,179,57,'REQUESTER'),(228,179,87,'FOLLOWER'),(229,180,197,'REQUESTER'),(230,181,89,'REQUESTER'),(591,182,26,'REQUESTER'),(590,183,26,'REQUESTER'),(233,184,195,'REQUESTER'),(234,185,192,'REQUESTER'),(235,185,243,'FOLLOWER'),(236,185,193,'FOLLOWER'),(237,186,233,'REQUESTER'),(287,226,166,'REQUESTER'),(589,188,77,'REQUESTER'),(588,189,109,'REQUESTER'),(241,190,64,'REQUESTER'),(242,190,277,'FOLLOWER'),(243,191,108,'REQUESTER'),(244,192,250,'REQUESTER'),(245,193,31,'REQUESTER'),(246,194,200,'REQUESTER'),(248,195,41,'REQUESTER'),(249,195,96,'FOLLOWER'),(250,196,29,'REQUESTER'),(251,197,195,'REQUESTER'),(252,198,87,'REQUESTER'),(254,199,128,'REQUESTER'),(255,199,141,'FOLLOWER'),(256,200,128,'REQUESTER'),(257,200,141,'FOLLOWER'),(258,201,201,'REQUESTER'),(259,202,59,'REQUESTER'),(260,203,108,'REQUESTER'),(261,204,41,'REQUESTER'),(262,204,243,'FOLLOWER'),(264,205,257,'REQUESTER'),(265,205,66,'FOLLOWER'),(266,206,248,'REQUESTER'),(267,207,238,'REQUESTER'),(268,208,238,'REQUESTER'),(301,236,201,'REQUESTER'),(270,210,259,'REQUESTER'),(271,211,259,'REQUESTER'),(272,212,87,'REQUESTER'),(273,213,87,'REQUESTER'),(275,214,227,'REQUESTER'),(289,228,166,'REQUESTER'),(290,229,111,'REQUESTER'),(292,230,281,'REQUESTER'),(296,231,265,'REQUESTER'),(295,232,268,'REQUESTER'),(297,233,201,'REQUESTER'),(298,234,201,'REQUESTER'),(300,235,265,'REQUESTER'),(302,237,111,'REQUESTER'),(303,237,132,'FOLLOWER'),(304,238,201,'REQUESTER'),(305,239,201,'REQUESTER'),(306,240,201,'REQUESTER'),(307,241,138,'REQUESTER'),(308,242,128,'REQUESTER'),(309,242,66,'FOLLOWER'),(310,243,111,'REQUESTER'),(311,243,132,'FOLLOWER'),(312,244,141,'REQUESTER'),(313,245,129,'REQUESTER'),(314,246,114,'REQUESTER'),(315,247,201,'REQUESTER'),(316,248,28,'REQUESTER'),(317,249,297,'REQUESTER'),(318,250,201,'REQUESTER'),(319,251,201,'REQUESTER'),(320,252,201,'REQUESTER'),(428,253,201,'REQUESTER'),(322,254,201,'REQUESTER'),(323,255,297,'REQUESTER'),(324,256,107,'REQUESTER'),(325,257,106,'REQUESTER'),(326,258,138,'REQUESTER'),(711,485,187,'FOLLOWER'),(328,260,201,'REQUESTER'),(329,261,297,'REQUESTER'),(330,262,114,'REQUESTER'),(331,263,114,'REQUESTER'),(453,356,57,'REQUESTER'),(333,265,114,'REQUESTER'),(337,268,268,'REQUESTER'),(335,267,201,'REQUESTER'),(338,269,298,'REQUESTER'),(341,270,185,'REQUESTER'),(340,271,47,'REQUESTER'),(342,270,132,'FOLLOWER'),(343,272,166,'REQUESTER'),(344,273,300,'REQUESTER'),(345,274,18,'REQUESTER'),(346,275,28,'REQUESTER'),(347,276,114,'REQUESTER'),(348,277,298,'REQUESTER'),(349,278,27,'REQUESTER'),(350,279,300,'REQUESTER'),(351,280,298,'REQUESTER'),(352,281,251,'REQUESTER'),(353,282,185,'REQUESTER'),(587,283,323,'REQUESTER'),(361,284,281,'REQUESTER'),(586,285,281,'REQUESTER'),(357,286,129,'REQUESTER'),(358,287,60,'REQUESTER'),(359,288,129,'REQUESTER'),(360,289,201,'REQUESTER'),(362,290,172,'REQUESTER'),(363,291,16,'REQUESTER'),(364,292,114,'REQUESTER'),(406,325,201,'REQUESTER'),(366,294,201,'REQUESTER'),(367,295,298,'REQUESTER'),(368,296,298,'REQUESTER'),(369,297,201,'REQUESTER'),(370,298,116,'REQUESTER'),(372,299,253,'REQUESTER'),(373,300,116,'REQUESTER'),(374,301,277,'REQUESTER'),(375,302,299,'REQUESTER'),(376,303,116,'REQUESTER'),(377,304,258,'REQUESTER'),(378,305,258,'REQUESTER'),(379,306,298,'REQUESTER'),(380,307,201,'REQUESTER'),(381,308,107,'REQUESTER'),(382,309,298,'REQUESTER'),(383,310,15,'REQUESTER'),(385,312,201,'REQUESTER'),(585,313,363,'REQUESTER'),(391,314,366,'REQUESTER'),(388,315,201,'REQUESTER'),(389,316,201,'REQUESTER'),(390,317,107,'REQUESTER'),(392,318,259,'REQUESTER'),(405,293,57,'FOLLOWER'),(395,319,87,'REQUESTER'),(416,320,30,'REQUESTER'),(397,321,367,'REQUESTER'),(398,322,297,'REQUESTER'),(399,323,257,'REQUESTER'),(404,293,201,'REQUESTER'),(403,324,160,'REQUESTER'),(407,326,201,'REQUESTER'),(418,327,13,'REQUESTER'),(409,328,270,'REQUESTER'),(410,329,270,'REQUESTER'),(617,330,298,'REQUESTER'),(412,331,259,'REQUESTER'),(414,332,116,'REQUESTER'),(433,333,101,'REQUESTER'),(417,320,57,'FOLLOWER'),(419,334,201,'REQUESTER'),(651,335,201,'REQUESTER'),(421,336,201,'REQUESTER'),(422,337,270,'REQUESTER'),(423,338,87,'REQUESTER'),(424,339,298,'REQUESTER'),(449,340,201,'REQUESTER'),(426,341,116,'REQUESTER'),(427,342,139,'REQUESTER'),(429,253,57,'FOLLOWER'),(430,343,299,'REQUESTER'),(436,344,294,'REQUESTER'),(432,345,294,'REQUESTER'),(434,333,294,'FOLLOWER'),(439,346,124,'REQUESTER'),(437,344,32,'FOLLOWER'),(438,344,187,'FOLLOWER'),(440,347,253,'REQUESTER'),(441,347,150,'FOLLOWER'),(442,347,187,'FOLLOWER'),(443,348,294,'REQUESTER'),(631,349,227,'REQUESTER'),(445,350,201,'REQUESTER'),(447,352,117,'REQUESTER'),(448,353,143,'REQUESTER'),(450,340,57,'FOLLOWER'),(451,354,143,'REQUESTER'),(452,355,143,'REQUESTER'),(454,357,270,'REQUESTER'),(455,358,270,'REQUESTER'),(456,359,270,'REQUESTER'),(457,360,160,'REQUESTER'),(458,361,166,'REQUESTER'),(459,362,16,'REQUESTER'),(460,362,259,'FOLLOWER'),(461,362,21,'FOLLOWER'),(462,362,258,'FOLLOWER'),(463,362,256,'FOLLOWER'),(464,362,139,'FOLLOWER'),(481,363,291,'REQUESTER'),(466,364,299,'REQUESTER'),(467,365,300,'REQUESTER'),(468,366,99,'REQUESTER'),(512,367,66,'FOLLOWER'),(470,368,259,'REQUESTER'),(510,369,270,'REQUESTER'),(472,370,172,'REQUESTER'),(516,388,259,'REQUESTER'),(478,371,270,'REQUESTER'),(480,371,277,'FOLLOWER'),(482,363,129,'FOLLOWER'),(511,367,270,'REQUESTER'),(545,372,294,'REQUESTER'),(486,373,259,'REQUESTER'),(487,374,270,'REQUESTER'),(518,389,294,'FOLLOWER'),(490,376,258,'REQUESTER'),(491,377,258,'REQUESTER'),(492,378,57,'REQUESTER'),(493,378,201,'FOLLOWER'),(494,378,12,'FOLLOWER'),(517,389,57,'REQUESTER'),(496,380,258,'REQUESTER'),(513,381,270,'REQUESTER'),(499,382,294,'REQUESTER'),(500,382,323,'FOLLOWER'),(501,383,201,'REQUESTER'),(502,383,59,'FOLLOWER'),(503,384,323,'REQUESTER'),(504,385,111,'REQUESTER'),(505,385,132,'FOLLOWER'),(603,386,370,'REQUESTER'),(509,387,129,'REQUESTER'),(519,389,251,'FOLLOWER'),(520,389,101,'FOLLOWER'),(521,389,79,'FOLLOWER'),(522,390,201,'REQUESTER'),(523,391,270,'REQUESTER'),(524,392,201,'REQUESTER'),(525,392,57,'FOLLOWER'),(526,392,139,'FOLLOWER'),(527,393,270,'REQUESTER'),(528,394,270,'REQUESTER'),(529,395,57,'REQUESTER'),(530,396,270,'REQUESTER'),(543,397,370,'REQUESTER'),(657,398,298,'FOLLOWER'),(533,399,270,'REQUESTER'),(534,400,299,'REQUESTER'),(550,401,263,'REQUESTER'),(537,402,263,'REQUESTER'),(538,403,299,'REQUESTER'),(539,404,201,'REQUESTER'),(540,404,191,'FOLLOWER'),(541,405,160,'REQUESTER'),(542,406,106,'REQUESTER'),(544,407,201,'REQUESTER'),(546,372,30,'FOLLOWER'),(547,372,187,'FOLLOWER'),(548,372,32,'FOLLOWER'),(551,408,367,'REQUESTER'),(552,409,277,'REQUESTER'),(602,410,363,'FOLLOWER'),(554,411,87,'REQUESTER'),(556,412,371,'REQUESTER'),(557,413,371,'REQUESTER'),(558,414,298,'REQUESTER'),(559,414,297,'FOLLOWER'),(560,415,298,'REQUESTER'),(561,416,259,'REQUESTER'),(562,417,201,'REQUESTER'),(563,418,201,'REQUESTER'),(564,418,191,'FOLLOWER'),(569,419,277,'FOLLOWER'),(568,419,270,'REQUESTER'),(570,420,201,'REQUESTER'),(571,421,201,'REQUESTER'),(572,421,191,'FOLLOWER'),(573,421,57,'FOLLOWER'),(575,423,363,'REQUESTER'),(576,424,152,'REQUESTER'),(577,425,257,'REQUESTER'),(578,426,258,'REQUESTER'),(579,427,270,'REQUESTER'),(581,428,106,'REQUESTER'),(582,429,259,'REQUESTER'),(583,430,268,'REQUESTER'),(584,431,268,'REQUESTER'),(592,432,152,'REQUESTER'),(604,386,253,'FOLLOWER'),(594,434,300,'REQUESTER'),(601,410,373,'FOLLOWER'),(600,410,184,'FOLLOWER'),(599,410,13,'REQUESTER'),(605,386,187,'FOLLOWER'),(606,386,149,'FOLLOWER'),(607,435,201,'REQUESTER'),(612,436,374,'FOLLOWER'),(611,436,297,'REQUESTER'),(613,436,266,'FOLLOWER'),(614,437,270,'REQUESTER'),(615,438,166,'REQUESTER'),(616,439,270,'REQUESTER'),(618,330,297,'FOLLOWER'),(656,398,297,'REQUESTER'),(705,259,297,'REQUESTER'),(623,440,323,'REQUESTER'),(624,440,30,'FOLLOWER'),(625,441,87,'REQUESTER'),(626,442,366,'REQUESTER'),(627,442,66,'FOLLOWER'),(632,443,201,'REQUESTER'),(633,444,168,'REQUESTER'),(634,445,57,'REQUESTER'),(649,446,201,'REQUESTER'),(638,447,296,'REQUESTER'),(639,448,270,'REQUESTER'),(640,449,376,'REQUESTER'),(641,450,376,'REQUESTER'),(642,451,270,'REQUESTER'),(643,452,129,'REQUESTER'),(644,453,201,'REQUESTER'),(645,454,39,'REQUESTER'),(646,454,248,'FOLLOWER'),(647,455,270,'REQUESTER'),(648,456,323,'REQUESTER'),(650,446,57,'FOLLOWER'),(652,335,57,'FOLLOWER'),(655,457,297,'REQUESTER'),(658,458,106,'REQUESTER'),(659,459,270,'REQUESTER'),(660,460,259,'REQUESTER'),(661,461,259,'REQUESTER'),(662,462,259,'REQUESTER'),(663,463,259,'REQUESTER'),(666,464,270,'REQUESTER'),(665,465,298,'REQUESTER'),(668,467,270,'REQUESTER'),(691,468,66,'FOLLOWER'),(690,468,366,'REQUESTER'),(689,469,257,'REQUESTER'),(672,470,268,'REQUESTER'),(673,471,259,'REQUESTER'),(674,472,24,'REQUESTER'),(685,473,142,'REQUESTER'),(688,474,21,'REQUESTER'),(687,475,66,'FOLLOWER'),(686,475,366,'REQUESTER'),(679,476,376,'REQUESTER'),(680,477,57,'REQUESTER'),(681,477,323,'FOLLOWER'),(682,478,323,'REQUESTER'),(683,478,57,'FOLLOWER'),(885,479,138,'REQUESTER'),(697,480,323,'FOLLOWER'),(696,480,294,'REQUESTER'),(694,481,139,'REQUESTER'),(695,481,66,'FOLLOWER'),(698,480,30,'FOLLOWER'),(699,482,270,'REQUESTER'),(700,483,366,'REQUESTER'),(701,483,66,'FOLLOWER'),(702,484,294,'REQUESTER'),(710,485,294,'REQUESTER'),(716,489,294,'REQUESTER'),(721,490,277,'REQUESTER'),(713,491,268,'REQUESTER'),(714,492,270,'REQUESTER'),(715,493,106,'REQUESTER'),(717,494,184,'REQUESTER'),(718,495,192,'REQUESTER'),(719,495,243,'FOLLOWER'),(720,495,193,'FOLLOWER'),(722,490,268,'FOLLOWER'),(723,496,116,'REQUESTER'),(724,497,248,'REQUESTER'),(725,498,366,'REQUESTER'),(726,498,66,'FOLLOWER'),(727,499,366,'REQUESTER'),(728,499,66,'FOLLOWER'),(729,500,270,'REQUESTER'),(730,501,300,'REQUESTER'),(734,502,116,'REQUESTER'),(732,503,297,'REQUESTER'),(733,504,298,'REQUESTER'),(735,502,30,'FOLLOWER'),(736,502,57,'FOLLOWER'),(737,505,201,'REQUESTER'),(738,505,57,'FOLLOWER'),(740,506,16,'REQUESTER'),(741,507,106,'REQUESTER'),(742,508,270,'REQUESTER'),(743,509,201,'REQUESTER'),(744,509,57,'FOLLOWER'),(745,509,116,'FOLLOWER'),(746,510,16,'REQUESTER'),(747,511,201,'REQUESTER'),(748,512,230,'REQUESTER'),(749,512,187,'FOLLOWER'),(750,513,366,'REQUESTER'),(751,513,66,'FOLLOWER'),(770,528,201,'REQUESTER'),(767,526,300,'REQUESTER'),(754,515,201,'REQUESTER'),(755,516,201,'REQUESTER'),(756,517,368,'REQUESTER'),(769,527,201,'REQUESTER'),(768,518,363,'REQUESTER'),(759,519,57,'REQUESTER'),(760,520,201,'REQUESTER'),(761,520,30,'FOLLOWER'),(762,521,141,'REQUESTER'),(845,522,294,'REQUESTER'),(765,524,116,'REQUESTER'),(771,529,201,'REQUESTER'),(772,529,57,'FOLLOWER'),(773,530,378,'REQUESTER'),(774,531,41,'REQUESTER'),(775,532,195,'REQUESTER'),(785,533,300,'REQUESTER'),(777,534,270,'REQUESTER'),(783,535,297,'REQUESTER'),(781,536,297,'REQUESTER'),(784,537,270,'REQUESTER'),(786,538,57,'REQUESTER'),(787,538,201,'FOLLOWER'),(788,538,12,'FOLLOWER'),(789,538,66,'FOLLOWER'),(790,539,168,'REQUESTER'),(791,540,270,'REQUESTER'),(792,541,201,'REQUESTER'),(793,541,12,'FOLLOWER'),(794,541,57,'FOLLOWER'),(795,542,297,'REQUESTER'),(796,543,41,'REQUESTER'),(797,544,129,'REQUESTER'),(798,545,201,'REQUESTER'),(799,545,57,'FOLLOWER'),(800,546,270,'REQUESTER'),(821,547,300,'REQUESTER'),(802,548,270,'REQUESTER'),(803,549,270,'REQUESTER'),(804,550,297,'REQUESTER'),(833,570,201,'REQUESTER'),(822,552,300,'REQUESTER'),(807,553,270,'REQUESTER'),(808,554,300,'REQUESTER'),(809,555,122,'REQUESTER'),(810,556,201,'REQUESTER'),(811,557,298,'REQUESTER'),(812,558,380,'REQUESTER'),(813,559,366,'REQUESTER'),(814,559,66,'FOLLOWER'),(860,588,201,'REQUESTER'),(817,561,265,'REQUESTER'),(818,562,270,'REQUESTER'),(824,563,270,'REQUESTER'),(820,564,230,'REQUESTER'),(823,565,41,'REQUESTER'),(825,563,268,'FOLLOWER'),(832,566,268,'FOLLOWER'),(831,566,270,'REQUESTER'),(828,567,270,'REQUESTER'),(829,568,300,'REQUESTER'),(830,569,259,'REQUESTER'),(834,570,57,'FOLLOWER'),(835,571,129,'REQUESTER'),(836,572,139,'REQUESTER'),(837,573,270,'REQUESTER'),(838,574,297,'REQUESTER'),(840,575,270,'REQUESTER'),(841,576,300,'REQUESTER'),(842,577,270,'REQUESTER'),(846,580,265,'REQUESTER'),(847,581,110,'REQUESTER'),(848,581,79,'FOLLOWER'),(849,581,122,'FOLLOWER'),(850,581,132,'FOLLOWER'),(864,582,270,'REQUESTER'),(852,583,270,'REQUESTER'),(853,584,201,'REQUESTER'),(854,584,57,'FOLLOWER'),(855,585,294,'REQUESTER'),(856,585,371,'FOLLOWER'),(857,586,294,'REQUESTER'),(858,586,371,'FOLLOWER'),(859,587,129,'REQUESTER'),(861,589,270,'REQUESTER'),(862,590,270,'REQUESTER'),(863,591,270,'REQUESTER'),(865,592,87,'REQUESTER'),(866,592,57,'FOLLOWER'),(867,593,139,'REQUESTER'),(868,594,248,'REQUESTER'),(869,595,57,'REQUESTER'),(870,595,66,'FOLLOWER'),(871,596,57,'REQUESTER'),(872,596,66,'FOLLOWER'),(873,596,201,'FOLLOWER'),(874,597,294,'REQUESTER'),(875,598,77,'REQUESTER'),(876,599,248,'REQUESTER'),(877,599,363,'FOLLOWER'),(878,600,129,'REQUESTER'),(879,601,229,'REQUESTER'),(886,479,383,'FOLLOWER'),(881,603,281,'REQUESTER'),(882,604,21,'REQUESTER'),(883,605,363,'REQUESTER'),(884,606,270,'REQUESTER'),(1013,607,132,'FOLLOWER'),(1012,607,66,'FOLLOWER'),(1011,607,110,'REQUESTER'),(890,608,368,'REQUESTER'),(891,609,270,'REQUESTER'),(892,610,298,'REQUESTER'),(893,610,297,'FOLLOWER'),(894,611,259,'REQUESTER'),(895,612,383,'REQUESTER'),(896,613,201,'REQUESTER'),(897,614,94,'REQUESTER'),(898,615,298,'REQUESTER'),(901,616,129,'REQUESTER'),(900,617,270,'REQUESTER'),(902,616,139,'FOLLOWER'),(904,619,298,'REQUESTER'),(906,618,298,'REQUESTER'),(907,620,57,'REQUESTER'),(908,621,294,'REQUESTER'),(914,626,270,'REQUESTER'),(910,623,77,'REQUESTER'),(911,624,184,'REQUESTER'),(912,624,253,'FOLLOWER'),(913,625,259,'REQUESTER'),(916,627,270,'REQUESTER'),(917,627,259,'FOLLOWER'),(918,627,277,'FOLLOWER'),(919,627,268,'FOLLOWER'),(921,628,270,'REQUESTER'),(922,628,259,'FOLLOWER'),(923,628,268,'FOLLOWER'),(924,628,277,'FOLLOWER'),(925,629,376,'REQUESTER'),(926,630,300,'REQUESTER'),(927,631,16,'REQUESTER'),(930,632,367,'REQUESTER'),(931,634,201,'REQUESTER'),(932,635,380,'REQUESTER'),(936,636,248,'REQUESTER'),(934,637,53,'REQUESTER'),(935,638,160,'REQUESTER'),(937,636,222,'FOLLOWER'),(938,639,300,'REQUESTER'),(940,640,300,'REQUESTER'),(941,641,124,'REQUESTER'),(960,642,294,'REQUESTER'),(972,658,16,'REQUESTER'),(944,644,230,'REQUESTER'),(945,644,24,'FOLLOWER'),(946,644,187,'FOLLOWER'),(947,645,230,'REQUESTER'),(948,645,24,'FOLLOWER'),(949,645,187,'FOLLOWER'),(950,646,248,'REQUESTER'),(951,647,248,'REQUESTER'),(952,647,150,'FOLLOWER'),(953,648,230,'REQUESTER'),(954,648,24,'FOLLOWER'),(955,648,187,'FOLLOWER'),(956,649,201,'REQUESTER'),(957,649,12,'FOLLOWER'),(971,643,294,'REQUESTER'),(961,642,385,'FOLLOWER'),(962,650,114,'REQUESTER'),(963,651,299,'REQUESTER'),(964,652,384,'REQUESTER'),(965,653,384,'REQUESTER'),(966,654,384,'REQUESTER'),(967,655,366,'REQUESTER'),(968,655,66,'FOLLOWER'),(969,656,248,'REQUESTER'),(970,657,386,'REQUESTER'),(973,659,387,'REQUESTER'),(974,659,386,'FOLLOWER'),(975,660,386,'REQUESTER'),(976,661,37,'REQUESTER'),(977,662,252,'REQUESTER'),(978,663,366,'REQUESTER'),(979,663,66,'FOLLOWER'),(980,664,366,'REQUESTER'),(981,665,383,'REQUESTER'),(982,666,201,'REQUESTER'),(983,667,129,'REQUESTER'),(984,668,201,'REQUESTER'),(985,669,366,'REQUESTER'),(986,669,66,'FOLLOWER'),(987,670,87,'REQUESTER'),(988,671,77,'REQUESTER'),(989,672,376,'REQUESTER'),(990,673,366,'REQUESTER'),(991,673,66,'FOLLOWER'),(992,674,384,'REQUESTER'),(994,676,41,'REQUESTER'),(995,677,93,'REQUESTER'),(996,677,293,'FOLLOWER'),(997,678,114,'REQUESTER'),(998,679,297,'REQUESTER'),(999,680,299,'REQUESTER'),(1000,681,157,'REQUESTER'),(1001,682,248,'REQUESTER'),(1007,686,265,'REQUESTER'),(1006,685,96,'REQUESTER'),(1004,684,248,'REQUESTER'),(1005,684,283,'FOLLOWER'),(1008,687,270,'REQUESTER'),(1009,688,93,'REQUESTER'),(1010,689,41,'REQUESTER'),(1014,607,62,'FOLLOWER'),(1015,690,368,'REQUESTER'),(1022,691,371,'FOLLOWER'),(1021,691,294,'REQUESTER'),(1018,692,87,'REQUESTER'),(1019,693,47,'REQUESTER'),(1020,694,283,'REQUESTER'),(1023,695,72,'REQUESTER'),(1024,696,270,'REQUESTER'),(1025,697,270,'REQUESTER'),(1026,698,299,'REQUESTER'),(1027,699,230,'REQUESTER'),(1028,700,108,'REQUESTER'),(1029,701,122,'REQUESTER'),(1030,702,192,'REQUESTER'),(1031,703,265,'REQUESTER'),(1055,704,294,'REQUESTER'),(1053,705,294,'REQUESTER'),(1057,706,270,'REQUESTER'),(1038,707,376,'REQUESTER'),(1039,708,201,'REQUESTER'),(1040,708,12,'FOLLOWER'),(1041,708,57,'FOLLOWER'),(1042,709,230,'REQUESTER'),(1043,710,230,'REQUESTER'),(1044,710,251,'FOLLOWER'),(1045,711,201,'REQUESTER'),(1046,711,139,'FOLLOWER'),(1047,712,201,'REQUESTER'),(1048,713,251,'REQUESTER'),(1049,714,251,'REQUESTER'),(1050,715,251,'REQUESTER'),(1051,716,238,'REQUESTER'),(1054,705,22,'FOLLOWER'),(1056,717,53,'REQUESTER'),(1058,706,277,'FOLLOWER'),(1059,706,268,'FOLLOWER'),(1060,718,294,'REQUESTER'),(1061,719,294,'REQUESTER'),(1066,720,129,'REQUESTER'),(1063,721,282,'REQUESTER'),(1064,722,77,'REQUESTER'),(1065,723,296,'REQUESTER'),(1067,720,139,'FOLLOWER'),(1068,724,201,'REQUESTER'),(1069,725,135,'REQUESTER'),(1082,726,248,'REQUESTER'),(1077,727,135,'REQUESTER'),(1072,728,389,'REQUESTER'),(1073,729,389,'REQUESTER'),(1074,730,265,'REQUESTER'),(1075,731,384,'REQUESTER'),(1078,727,152,'FOLLOWER'),(1079,732,282,'REQUESTER'),(1080,733,270,'REQUESTER'),(1081,734,83,'REQUESTER'),(1083,726,222,'FOLLOWER'),(1084,735,141,'REQUESTER'),(1085,736,281,'REQUESTER'),(1086,737,281,'REQUESTER'),(1087,738,122,'REQUESTER'),(1088,739,281,'REQUESTER'),(1089,740,152,'REQUESTER'),(1090,741,259,'REQUESTER'),(1091,742,195,'REQUESTER'),(1092,743,390,'REQUESTER'),(1093,744,270,'REQUESTER'),(1098,745,129,'REQUESTER'),(1096,747,122,'REQUESTER'),(1097,748,265,'REQUESTER'),(1099,745,139,'FOLLOWER'),(1100,749,139,'REQUESTER'),(1101,750,270,'REQUESTER'),(1102,751,258,'REQUESTER'),(1106,755,294,'REQUESTER'),(1104,753,270,'REQUESTER'),(1105,754,251,'REQUESTER'),(1107,756,258,'REQUESTER'),(1108,757,201,'REQUESTER'),(1109,758,116,'REQUESTER'),(1116,765,298,'REQUESTER'),(1111,760,183,'REQUESTER'),(1112,761,183,'REQUESTER'),(1113,762,141,'REQUESTER'),(1114,763,384,'REQUESTER'),(1115,764,116,'REQUESTER'),(1126,769,267,'REQUESTER'),(1118,767,87,'REQUESTER'),(1119,768,201,'REQUESTER'),(1120,768,12,'FOLLOWER'),(1123,770,57,'REQUESTER'),(1124,770,66,'FOLLOWER'),(1125,770,251,'FOLLOWER'),(1127,769,268,'FOLLOWER'),(1128,769,277,'FOLLOWER'),(1129,771,363,'REQUESTER'),(1130,771,363,'FOLLOWER'),(1131,772,87,'REQUESTER'),(1132,773,270,'REQUESTER'),(1134,774,201,'REQUESTER'),(1135,775,277,'REQUESTER'),(1136,776,141,'REQUESTER'),(1137,777,282,'REQUESTER'),(1138,778,141,'REQUESTER'),(1140,779,141,'REQUESTER'),(1142,780,298,'REQUESTER'),(1143,780,297,'FOLLOWER'),(1147,782,277,'REQUESTER'),(1146,781,57,'REQUESTER'),(1148,783,270,'REQUESTER'),(1149,784,270,'REQUESTER'),(1150,785,270,'REQUESTER'),(1151,786,277,'REQUESTER'),(1152,787,227,'REQUESTER'),(1153,788,293,'REQUESTER'),(1154,789,230,'REQUESTER'),(1155,789,187,'FOLLOWER'),(1156,790,230,'REQUESTER'),(1157,791,390,'REQUESTER'),(1158,792,129,'REQUESTER'),(1162,793,270,'REQUESTER'),(1160,794,270,'REQUESTER'),(1161,795,41,'REQUESTER'),(1163,793,277,'FOLLOWER'),(1164,796,294,'REQUESTER'),(1165,797,386,'REQUESTER'),(1166,798,129,'REQUESTER'),(1167,799,281,'REQUESTER'),(1168,799,293,'FOLLOWER'),(1169,800,248,'REQUESTER'),(1170,800,340,'FOLLOWER'),(1171,801,168,'REQUESTER'),(1172,801,135,'FOLLOWER'),(1173,802,248,'REQUESTER'),(1174,802,251,'FOLLOWER'),(1175,802,222,'FOLLOWER'),(1176,802,30,'FOLLOWER'),(1177,803,68,'REQUESTER'),(1178,804,139,'REQUESTER'),(1179,805,363,'REQUESTER'),(1184,806,294,'REQUESTER'),(1181,807,126,'REQUESTER'),(1182,808,376,'REQUESTER'),(1183,809,227,'REQUESTER'),(1185,810,378,'REQUESTER'),(1186,811,238,'REQUESTER'),(1187,812,389,'REQUESTER'),(1188,813,168,'REQUESTER');

--
-- Table structure for table `hesk_tickets`
--

CREATE TABLE `hesk_tickets` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `trackid` varchar(13) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `u_name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `u_email` varchar(1000) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `category` smallint unsigned NOT NULL DEFAULT '1',
  `priority` enum('0','1','2','3') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '3',
  `subject` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `message` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message_html` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `dt` timestamp NOT NULL DEFAULT '2000-01-01 00:00:00',
  `lastchange` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `firstreply` timestamp NULL DEFAULT NULL,
  `closedat` timestamp NULL DEFAULT NULL,
  `articles` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ip` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `language` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `status` tinyint unsigned NOT NULL DEFAULT '0',
  `openedby` mediumint DEFAULT '0',
  `firstreplyby` smallint unsigned DEFAULT NULL,
  `closedby` mediumint DEFAULT NULL,
  `replies` smallint unsigned NOT NULL DEFAULT '0',
  `staffreplies` smallint unsigned NOT NULL DEFAULT '0',
  `owner` smallint unsigned NOT NULL DEFAULT '0',
  `assignedby` mediumint DEFAULT NULL,
  `time_worked` time NOT NULL DEFAULT '00:00:00',
  `lastreplier` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `replierid` smallint unsigned DEFAULT NULL,
  `archive` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `locked` enum('0','1') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `attachments` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `merged` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `history` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom1` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom2` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom3` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom4` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom5` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom6` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom7` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom8` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom9` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom10` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom11` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom12` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom13` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom14` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom15` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom16` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom17` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom18` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom19` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom20` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom21` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom22` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom23` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom24` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom25` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom26` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom27` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom28` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom29` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom30` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom31` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom32` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom33` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom34` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom35` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom36` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom37` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom38` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom39` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom40` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom41` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom42` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom43` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom44` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom45` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom46` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom47` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom48` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom49` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom50` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom51` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom52` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom53` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom54` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom55` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom56` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom57` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom58` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom59` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom60` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom61` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom62` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom63` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom64` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom65` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom66` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom67` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom68` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom69` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom70` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom71` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom72` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom73` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom74` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom75` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom76` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom77` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom78` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom79` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom80` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom81` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom82` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom83` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom84` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom85` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom86` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom87` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom88` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom89` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom90` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom91` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom92` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom93` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom94` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom95` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom96` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom97` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom98` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom99` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `custom100` mediumtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `due_date` timestamp NULL DEFAULT NULL,
  `overdue_email_sent` tinyint(1) DEFAULT '0',
  `satisfaction_email_sent` tinyint(1) DEFAULT '0',
  `satisfaction_email_dt` timestamp NULL DEFAULT NULL,
  `eid` varchar(1000) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `trackid` (`trackid`),
  KEY `archive` (`archive`),
  KEY `categories` (`category`),
  KEY `statuses` (`status`),
  KEY `owner` (`owner`),
  KEY `openedby` (`openedby`,`firstreplyby`,`closedby`),
  KEY `dt` (`dt`)
) ENGINE=MyISAM AUTO_INCREMENT=814 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hesk_tickets`
--

INSERT INTO `hesk_tickets` VALUES (27,'QHJ-5XJ-WAY1','Disley','disley.oliveira@tecpav.com.br',1,'3','Efetuar retenções de IR e INSS com valor menor que R$ 10,00','Bom dia!<br />\r\nFoi definido hoje em reunião com os membros do setor contábil/fiscal que a partir de agora faremos retenções dos tributos INSS e IR de qualquer valor inclusive se for menor que R$ 10,00.<br />\r\nO entendimento é porque o DARF passou a ser gerado a partir da DCTFWeb, é a soma de todos os tributos de uma competência e o conceito de valor mínimo é para um documento DARF.<br />\r\nFavor configurar o sistema para valor mínimo igual a 0 (zero)','Bom dia!<br />\r\nFoi definido hoje em reunião com os membros do setor contábil/fiscal que a partir de agora faremos retenções dos tributos INSS e IR de qualquer valor inclusive se for menor que R$ 10,00.<br />\r\nO entendimento é porque o DARF passou a ser gerado a partir da DCTFWeb, é a soma de todos os tributos de uma competência e o conceito de valor mínimo é para um documento DARF.<br />\r\nFavor configurar o sistema para valor mínimo igual a 0 (zero)','2025-03-25 13:51:25','2025-03-25 21:05:13','2025-03-25 21:04:52','2025-03-25 21:05:13',NULL,'177.11.149.26',NULL,3,0,10,10,1,1,10,5,'00:31:15','1',10,'0','0','5#darf_menor_10.png,','','<li class=\"smaller\">25-03-2025 10:51:25 | enviado por Cliente</li><li class=\"smaller\">25-03-2025 10:51:25 | atribuído automaticamente a Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">25-03-2025 10:54:59 | atribuído a Jovaine Messias (jovaine_messias) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">25-03-2025 18:05:12 | fechado por Jovaine Messias (jovaine_messias)</li>','Totvs RM – Financeiro','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(30,'L6S-T98-MABD','Fernando','fernando.silva@tecpav.com.br',1,'3','Importar Tabela de advertência COL 67','Boa tarde Disley. <br />\n<br />\nEspero que esteja bem,<br />\n<br />\n Conforme  imagem abaixo, não consta cadastrada a tabela de advertência para a coligada 67. Por favor inclua a tabela no consorcio pera férrea.','<p class=\"MsoNormal\"><span style=\"color:#000000;\">Boa tarde Disley. </span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\">Espero que esteja bem,</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\"> </span><span style=\"color:#000000;\">Conforme  imagem abaixo, não consta cadastrada a tabela de advertência para a coligada 67. Por favor inclua a tabela no consorcio pera férrea.</span></p>\n<p class=\"MsoNormal\"><span style=\"color:#000000;\"><span style=\"font-size:12pt;font-family:sans-serif;color:#000000;\"><img src=\"data:image/png;base64,[encoded data, 124936 characters]\" width=\"738\" height=\"415\" alt=\"G7LfyxYECBDYKdC4U53E471GEiBAgAABAgT+E7LGPOjI7wZQAAAAAElFTkSuQmCC\" /></span></span></p>','2025-03-28 19:50:08','2025-03-28 20:43:32','2025-03-28 19:51:32','2025-03-28 20:43:32',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:01:09','1',5,'0','0','','','<li class=\"smaller\">28-03-2025 16:50:08 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 16:50:08 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:43:31 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Gestão de Pessoas','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(31,'1ER-YRB-TE5X','Didacio - Sobrado','didacio.andrade@sobradoconstrucao.com.br',1,'3','Visita para auxílio na geração da ECD 2024 das filiais 1001 e 1007','Visita presencial para auxílio na geração do arquivo ECD 2024','<p>Visita presencial para auxílio na geração do arquivo ECD 2024</p>','2025-03-28 20:02:59','2025-03-28 20:43:45','2025-03-28 20:03:18','2025-03-28 20:43:45',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:00:05','1',5,'0','0','','','<li class=\"smaller\">28-03-2025 17:02:59 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:02:59 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:03:12 | status alterado para Respondido por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:43:45 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Contabilidade/Fiscal','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(32,'R98-RGS-DAJ2','Renan','renan.silva@tecpav.com.br',1,'3','Cadastro de nova Seção - 00.CNT.0477.01 LUIZ ALVES/DNIT 12 00368/23/PA','Disley, bom dia<br />\n<br />\nPrecisamos que seja criado a seção 00.CNT.0477.01, conforme informações abaixo:<br />\n<br />\nColigada original: 59_CONSÓRCIO RODOVIA BR-080 II.<br />\n<br />\n <br />\n<br />\n1.     Cód. da Seção: 00.CNT.0477.01 - LUIZ ALVES / DNIT 12 00368/23 / PAV BR-080<br />\n<br />\n2.     Coligadas:   02_GOI / 03_SOB / 07_GAE<br />\n<br />\n3.     Nome da Lotação Tributaria: CNO_ 900227516576<br />\n<br />\n4.     Tipo da lotação: 01<br />\n<br />\n5.     CNO: 90.022.75165/76<br />\n<br />\n6.     Sind: (0003)<br />\n<br />\n7.     Tomador/Cliente: DNIT-DEPARTAMENTO NACIONAL DE INFRAEST DE TRANSPORTES - 04.892.707/0004-53','<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\">Disley, bom dia</span></p>\n<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\">Precisamos que seja criado a seção 00.CNT.0477.01, conforme informações abaixo:</span></p>\n<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\">Coligada original: 59_CONSÓRCIO RODOVIA BR-080 II.</span></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong> </strong></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">1.</span></strong><span style=\"font-size:10pt;font-family:sans-serif;\">     <strong><span style=\"font-family:sans-serif;\">Cód. da Seção:</span></strong> 00.CNT.0477.01 - LUIZ ALVES / DNIT 12 00368/23 / PAV BR-080</span></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">2.</span></strong><span style=\"font-size:10pt;font-family:sans-serif;\">     <strong><span style=\"font-family:sans-serif;\">Coligadas:</span></strong>   02_GOI </span><strong>/ </strong><span style=\"font-size:10pt;font-family:sans-serif;\">03_SOB / 07_GAE</span></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">3.     <u>Nome da Lotação Tributaria</u>: </span></strong><span style=\"font-size:10pt;font-family:sans-serif;color:#000000;\">CNO_</span><strong><span style=\"font-size:10pt;font-family:sans-serif;\"> </span></strong><span style=\"font-size:10pt;font-family:sans-serif;\">900227516576</span></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">4.</span></strong><span style=\"font-size:10pt;font-family:sans-serif;\">     <strong><span style=\"font-family:sans-serif;\">Tipo da lotação: </span></strong>01</span></p>\n<p class=\"MsoNormal\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">5.     CNO:</span></strong><span style=\"font-size:10pt;font-family:sans-serif;\"> 90.022.75165/76</span></p>\n<p class=\"gmail-m2077024363093808866msolistparagraph\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">6.     Sind:</span></strong><span style=\"font-size:10pt;font-family:sans-serif;\"> (0003)</span></p>\n<p class=\"gmail-m2077024363093808866msolistparagraph\" style=\"text-indent:35.4pt;\"><strong><span style=\"font-size:10pt;font-family:sans-serif;\">7.     Tomador/Cliente: </span></strong><span style=\"font-size:10pt;font-family:sans-serif;\">DNIT-DEPARTAMENTO NACIONAL DE INFRAEST DE TRANSPORTES - 04.892.707/0004-53</span></p>','2025-03-28 20:29:56','2025-09-03 13:00:37','2025-03-28 20:33:16','2025-03-28 20:43:55',NULL,'177.149.152.153',NULL,3,5,5,5,1,1,5,5,'00:01:50','1',5,'0','0','6#20200609_Ordem_de_Servico_n_01_2020_33039.pdf,','','<li class=\"smaller\">28-03-2025 17:29:56 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:30:02 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:43:55 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Folha de Pagamento','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(33,'LGP-ZAP-BYQT','Josias Vilela - Gae','rh.josias@gaeconstrucao.com.br',1,'3','Adicional Noturno no envelope não é devido','O sistema apresentou cálculo de R$ 30,00 para funcionários indevidamente.','<p>O sistema apresentou cálculo de R$ 30,00 para funcionários indevidamente.</p>','2025-03-28 20:37:02','2025-03-28 20:43:16','2025-03-28 20:43:10','2025-03-28 20:43:16',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:05:49','1',5,'0','0','','','<li class=\"smaller\">28-03-2025 17:37:02 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:37:02 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:43:05 | status alterado para Respondido por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 17:43:15 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Folha de Pagamento','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(34,'RUX-DHT-E1QL','João','joao.moreira@tecpav.com.br',8,'3','Lançar notas e boletos Totvs - Emissão 03/25 vencimento 04/25','Boa tarde!<br />\n<br />\nLançar notas e boletos Totvs - Emissão 03/25 vencimento 04/25.','<p>Boa tarde!</p>\n<p>Lançar notas e boletos Totvs - Emissão 03/25 vencimento 04/25.</p>','2025-03-28 21:06:06','2025-03-31 13:31:37','2025-03-31 11:37:23','2025-03-31 11:37:23',NULL,'177.11.149.26',NULL,3,5,2,2,1,1,2,5,'00:00:07','1',2,'0','0','7#2025_03_BOLETO_10_04_25.pdf,8#2025_03_NF_10_04_25.pdf,9#2025_03_RPS_24_04_25.pdf,10#2025_03_NF_24_04_25.pdf,11#2025_03_BOLETO_24_04_25.pdf,12#2025_03_RPS_10_04_25.pdf,','','<li class=\"smaller\">28-03-2025 18:06:06 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">28-03-2025 18:06:06 | atribuído a Joao Moreira (joao_moreira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 08:37:23 | status alterado para Resolvido por Joao Moreira (joao_moreira)</li>','','','Compra e Suprimentos','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(35,'WQR-RVB-76QS','Glaucia','glaucia.lelis@tecpav.com.br',9,'3','Permissão de pasta Juridico','Sr. Elyseu, boa tarde. <br />\n<br />\n <br />\n<br />\nGentileza liberar acesso à pasta do jurídico, para Dr. Sanábio.<br />\n<br />\n <br />\n<br />\nAntecipadamente agradeço.<br />\n<br />\n <br />\n<br />\nAtenciosamente. ','<p class=\"MsoNormal\"><span style=\"font-size:13.5pt;\">Sr. Elyseu, boa tarde. </span></p>\n<p class=\"MsoNormal\"> </p>\n<p class=\"MsoNormal\"><span style=\"font-size:13.5pt;\">Gentileza liberar acesso à pasta do jurídico, para Dr. Sanábio.</span></p>\n<p class=\"MsoNormal\"> </p>\n<p class=\"MsoNormal\"><span style=\"font-size:13.5pt;\">Antecipadamente agradeço.</span></p>\n<p class=\"MsoNormal\"> </p>\n<p class=\"MsoNormal\"><span style=\"font-size:13.5pt;\">Atenciosamente. </span></p>','2025-03-31 11:58:16','2025-03-31 21:48:24','2025-03-31 12:01:14','2025-03-31 21:48:24',NULL,'',NULL,3,9,9,9,2,2,9,9,'00:04:11','1',9,'0','0','','','<li class=\"smaller\">31-03-2025 08:58:16 | chamado criado por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 08:58:16 | atribuído a Elyseu Moreira De Aguiar (elyseu_moreira) por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 09:01:14 | status alterado para Aguardando resposta por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 10:46:29 | status alterado para Em espera por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 18:48:23 | fechado por Elyseu Moreira De Aguiar (elyseu_moreira)</li>','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(36,'GLB-T61-QWEA','Renan','renan.silva@tecpav.com.br',1,'3','ENC: CORREÇÃO DE PONTO','Disley, boa tarde!<br />\n<br />\nConforme havia solicitado via aplicativo Teams, reitero a urgência em finalizar a migração das batidas de ponto dos funcionários transferidos, pois já estamos finalizando o processamento da folha de algumas empresas hoje (e o restante na segunda-feira) e os mesmos estão ficando com faltas.<br />\n<br />\n Atenciosamente,<br />\n<br />\n ','<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\">Disley, boa tarde!</span></p>\n<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\">Conforme havia solicitado via aplicativo Teams, reitero a urgência em finalizar a migração das batidas de ponto dos funcionários transferidos, pois já estamos finalizando o processamento da folha de algumas empresas hoje (e o restante na segunda-feira) e os mesmos estão ficando com faltas.</span></p>\n<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\"> </span><span style=\"font-size:10pt;font-family:sans-serif;\">Atenciosamente,</span></p>\n<p class=\"MsoNormal\"><span style=\"font-size:10pt;font-family:sans-serif;\"> </span></p>\n<p><span style=\"font-size:10pt;font-family:sans-serif;\"><img style=\"height:4.333in;width:7.333in;\" src=\"data:image/gif;base64,[encoded data, 38836 characters]\" width=\"704\" height=\"416\" alt=\"9+EdABlKQgyRkIQ15SEQmUpGLZGQjHflISEZSkpOkZCUteclxBQQAOw==\" /></span></p>','2025-03-31 12:33:04','2025-04-01 21:41:07','2025-03-31 12:34:06','2025-04-01 21:41:07',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:02:09','1',5,'0','0','','','<li class=\"smaller\">31-03-2025 09:33:04 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 09:33:04 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">01-04-2025 18:41:07 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Jornadas/Ponto','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(37,'DQN-9QE-QUH1','Josias Vilela - Gae','rh.josias@gaeconstrucao.com.br',1,'3','Lançar diferença de Férias','Ao tentar lançar diferença de férias o sistema mostrou mensagem de nenhum funcionário atende a seleção.','<p>Ao tentar lançar diferença de férias o sistema mostrou mensagem de nenhum funcionário atende a seleção.</p>','2025-03-31 13:22:22','2025-03-31 13:27:27','2025-03-31 13:26:52','2025-03-31 13:27:27',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:04:21','1',5,'0','0','','','<li class=\"smaller\">31-03-2025 10:22:22 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 10:22:22 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 10:27:26 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Folha de Pagamento','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(38,'XJE-NP9-4EQM','Thais - Gae','thais.contabilidade@gaeconstrucao.com.br',1,'3','Erro ao Tentar fazer o zeramento de 2024','Erro ao tentar fazer o zeramento de 2024.<br />\n<br />\n<br />\n<br />\n <br />\n<br />\n ','<p>Erro ao tentar fazer o zeramento de 2024.</p>\n<p><img src=\"data:image/jpeg;base64,[encoded data, 216040 characters]\" width=\"534\" height=\"300\" alt=\"9k=\" /></p>\n<p> </p>\n<p> </p>','2025-03-31 13:41:20','2025-03-31 14:26:33','2025-03-31 13:46:35','2025-03-31 14:26:33',NULL,'',NULL,3,5,5,5,1,1,5,5,'00:05:06','1',5,'0','0','','','<li class=\"smaller\">31-03-2025 10:41:20 | chamado criado por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 10:41:20 | atribuído a Disley Oliveira (disley_oliveira) por Disley Oliveira (disley_oliveira)</li><li class=\"smaller\">31-03-2025 11:26:32 | fechado por Disley Oliveira (disley_oliveira)</li>','Totvs RM – Contabilidade/Fiscal','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(39,'379-BX7-UWLA','Juan José','juan.eger@tecpav.com.br',1,'3','Alteração do Campo de Justificativa no Mapa de Cotação nº 2025.002334','Justificativa anterior: MODELOS  EXCLUSIVOS DO FORNECEDOR. INFORMO QUE OS ITENS FORAM ESCOLHIDOS PELO PRÓPRIO SOLICITANTE DOS ITENS.','<p class=\"MsoNormal\"><strong><span style=\"font-size:11pt;font-family:sans-serif;color:#222222;\">Justificativa anterior</span></strong><span style=\"font-size:11pt;font-family:sans-serif;color:#222222;\">: </span><span style=\"font-size:11pt;font-family:sans-serif;color:#c82613;\">MODELOS  EXCLUSIVOS DO FORNECEDOR. INFORMO QUE OS ITENS FORAM ESCOLHIDOS PELO PRÓPRIO SOLICITANTE DOS ITENS.</span></p>','2025-03-31 13:45:59','2025-04-09 14:44:05','2025-04-09 14:44:05','2025-04-09 14:44:05',NULL,'',NULL,3,10,10,10,1,1,10,10,'00:00:18','1',10,'0','0','','','<li class=\"smaller\">31-03-2025 10:45:59 | chamado criado por Jovaine Messias (jovaine_messias)</li><li class=\"smaller\">31-03-2025 10:45:59 | atribuído automaticamente a Vinicio Faria (vinicio_faria)</li><li class=\"smaller\">31-03-2025 11:25:41 | atribuído a Jovaine Messias (jovaine_messias) por Jovaine Messias (jovaine_messias)</li><li class=\"smaller\">31-03-2025 11:28:46 | status alterado para Respondido por Jovaine Messias (jovaine_messias)</li><li class=\"smaller\">31-03-2025 11:29:31 | fechado por Jovaine Messias (jovaine_messias)</li>','Totvs RM – Compras','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(40,'N56-NQJ-VHXY','Bruno','bruno.silva@tecpav.com.br',8,'3','Instalação de CAD','[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Elyseu<br />\n[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Bom dia Dr.<br />\n[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Preciso instalar um cad aqui<br />\n[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: versão teste<br />\n[11:00, 31/03/2025] Bruno Fabrício Emp Pedreira: porem pede adm<br />\n[11:00, 31/03/2025] Bruno Fabrício Emp Pedreira: vc consegue liberar aqui pra mim?','<p>[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Elyseu<br />[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Bom dia Dr.<br />[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: Preciso instalar um cad aqui<br />[10:59, 31/03/2025] Bruno Fabrício Emp Pedreira: versão teste<br />[11:00, 31/03/2025] Bruno Fabrício Emp Pedreira: porem pede adm<br />[11:00, 31/03/2025] Bruno Fabrício Emp Pedreira: vc consegue liberar aqui pra mim?</p>','2025-03-31 14:08:24','2025-03-31 14:35:47','2025-03-31 14:35:47','2025-03-31 14:35:47',NULL,'',NULL,3,9,2,2,1,1,2,9,'00:04:26','1',2,'0','0','','','<li class=\"smaller\">31-03-2025 11:08:24 | chamado criado por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 11:08:24 | atribuído a Joao Moreira (joao_moreira) por Elyseu Moreira De Aguiar (elyseu_moreira)</li><li class=\"smaller\">31-03-2025 11:35:47 | status alterado para Resolvido por Joao Moreira (joao_moreira)</li>','','','Software','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(41,'QRW-LX2-6ER7','Hebert','contratos@tecpav.com.br',1,'3','Correção de Status','Correção do Status do Lançamento para Pendente no movimento 1.1.54 na Coligada 67, IDMOV 1047.','<p>Correção do Status do Lançamento para Pendente no movimento 1.1.54 na Coligada 67, IDMOV 1047.</p>','2025-03-31 14:13:01','2025-04-09 14:45:11','2025-04-09 14:45:11','2025-04-09 14:45:11',NULL,'',NULL,3,10,10,10,1,1,10,10,'00:00:05','1',10,'0','0','','','<li class=\"smaller\">31-03-2025 11:13:01 | chamado criado por Jovaine Messias (jovaine_messias)</li><li class=\"smaller\">31-03-2025 11:13:01 | atribuído automaticamente a Marcus Silva (marcus_silva)</li><li class=\"smaller\">31-03-2025 11:26:03 | atribuído a Jovaine Messias (jovaine_messias) por Jovaine Messias (jovaine_messias)</li><li class=\"smaller\">31-03-2025 11:30:45 | fechado por Jovaine Messias (jovaine_messias)</li>','Totvs RM – Faturamento/Vendas','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',NULL,0,0,NULL,NULL),(42,'3PX-ZU6-UVQ9','Thais - Gae','thais.contabilidade@gaeconstrucao.com.br',1,'3','Inconsistências nos rateios gerenciais ao tentar fazer zeramento','Ao tentar executar o zeramento das contas de resultados o sistema mostrou as inconsistências abaixo:','<p>Ao tentar executar o zeramento das contas de resultados o sistema mostrou as inconsistências abaixo:</p>\n<p><img src=\"data:image/jpeg;base64,[encoded data, 75080 characters]