-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 10.4.21-MariaDB - mariadb.org binary distribution
-- Server OS: Win64
-- HeidiSQL Version: 11.3.0.6295
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping structure for table helpdesksupport.audit_logs
CREATE TABLE IF NOT EXISTS `audit_logs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`subject_id` int(10) unsigned DEFAULT NULL,
`subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
`properties` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`host` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.audit_logs: ~231 rows (approximately)
/*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */;
INSERT INTO `audit_logs` (`id`, `description`, `subject_id`, `subject_type`, `user_id`, `properties`, `host`, `created_at`, `updated_at`) VALUES
(1, 'updated', 96, 'App\\Ticket', 1, '{"id":96,"title":null,"phone":"2300039","imali_account":"290302692","departments_id":"1","content":"Conta iMali bloqueada","author_name":"Ana","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-01T13:20:11.000000Z","updated_at":"2022-02-01T19:57:30.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":"6","attachments":[],"media":[]}', '::1', '2022-02-01 21:57:30', '2022-02-01 21:57:30'),
(2, 'created', 97, 'App\\Ticket', 1, '{"title":null,"phone":"839399323","imali_account":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","category_id":"1","status_id":1,"priority_id":1,"departments_id":5,"updated_at":"2022-02-02T08:21:52.000000Z","created_at":"2022-02-02T08:21:52.000000Z","id":97,"attachments":[],"media":[]}', '::1', '2022-02-02 10:21:52', '2022-02-02 10:21:52'),
(3, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":null,"departments_id":"2","content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T09:29:44.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 11:29:44', '2022-02-02 11:29:44'),
(4, 'updated', 97, 'App\\Ticket', 5, '{"id":97,"title":null,"phone":"839399323","imali_account":null,"departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T09:31:28.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 11:31:28', '2022-02-02 11:31:28'),
(5, 'updated', 97, 'App\\Ticket', 5, '{"id":97,"title":null,"phone":"839399323","imali_account":null,"departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T09:32:31.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"1","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 11:32:31', '2022-02-02 11:32:31'),
(6, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":null,"departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T09:34:42.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"5","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 11:34:42', '2022-02-02 11:34:42'),
(7, 'updated', 81, 'App\\Ticket', 1, '{"id":81,"title":null,"phone":"841414550","imali_account":null,"departments_id":"2","content":"Vamos Guardar o historico","author_name":"Machado","author_email":"machado@teste.com","documento":null,"created_at":"2022-01-31T10:38:34.000000Z","updated_at":"2022-02-02T15:05:10.000000Z","deleted_at":null,"status_id":"6","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-02 17:05:10', '2022-02-02 17:05:10'),
(8, 'updated', 81, 'App\\Ticket', 1, '{"id":81,"title":null,"phone":"841414550","imali_account":null,"departments_id":"2","content":"Vamos Guardar o historico","author_name":"Machado","author_email":"machado@teste.com","documento":null,"created_at":"2022-01-31T10:38:34.000000Z","updated_at":"2022-02-02T15:59:39.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-02 17:59:39', '2022-02-02 17:59:39'),
(9, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":null,"departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T16:01:52.000000Z","deleted_at":null,"status_id":"6","priority_id":"1","category_id":"5","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 18:01:52', '2022-02-02 18:01:52'),
(10, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":"21778","departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T16:04:25.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"5","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 18:04:25', '2022-02-02 18:04:25'),
(11, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":"21778","departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T16:05:46.000000Z","deleted_at":null,"status_id":"6","priority_id":"1","category_id":"5","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 18:05:46', '2022-02-02 18:05:46'),
(12, 'updated', 97, 'App\\Ticket', 1, '{"id":97,"title":null,"phone":"839399323","imali_account":"217781","departments_id":null,"content":"Teste","author_name":"Teste Ticket","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-02T08:21:52.000000Z","updated_at":"2022-02-02T16:06:00.000000Z","deleted_at":null,"status_id":"6","priority_id":"1","category_id":"5","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-02 18:06:00', '2022-02-02 18:06:00'),
(13, 'created', 98, 'App\\Ticket', NULL, '{"author_name":"Ivo","author_email":"naftalivo@gmail.com","title":"Example","content":"Ola iMali","category_id":1,"status_id":1,"priority_id":1,"updated_at":"2022-02-03T18:55:04.000000Z","created_at":"2022-02-03T18:55:04.000000Z","id":98,"attachments":[],"media":[]}', '::1', '2022-02-03 18:55:04', '2022-02-03 18:55:04'),
(14, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-03T19:47:35.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 21:47:35', '2022-02-03 21:47:35'),
(15, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:38:46.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:38:46', '2022-02-03 22:38:46'),
(16, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:41:07.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:41:07', '2022-02-03 22:41:07'),
(17, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:41:40.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:41:40', '2022-02-03 22:41:40'),
(18, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:42:00.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:42:00', '2022-02-03 22:42:00'),
(19, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:42:43.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:42:43', '2022-02-03 22:42:43'),
(20, 'updated', 95, 'App\\Ticket', 1, '{"id":95,"title":null,"phone":"833197222","imali_account":"21010004","departments_id":"2","content":"Os pagamentos por QR Code estao a falhar..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":"icons8-conte\\u00fado-100.png1643728653.png","created_at":"2022-02-01T13:17:33.000000Z","updated_at":"2022-02-03T20:44:32.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-03 22:44:32', '2022-02-03 22:44:32'),
(21, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-04T09:16:12.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-04 11:16:12', '2022-02-04 11:16:12'),
(22, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-04T09:16:35.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-04 11:16:35', '2022-02-04 11:16:35'),
(23, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-04T09:18:15.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-04 11:18:15', '2022-02-04 11:18:15'),
(24, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-04T09:19:20.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-04 11:19:20', '2022-02-04 11:19:20'),
(25, 'created', 99, 'App\\Ticket', 1, '{"title":null,"phone":"83331002","imali_account":null,"content":"Nao consigo transferir valores para os meus contactos...","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":3,"updated_at":"2022-02-04T10:42:35.000000Z","created_at":"2022-02-04T10:42:35.000000Z","id":99,"attachments":[],"media":[]}', '::1', '2022-02-04 12:42:35', '2022-02-04 12:42:35'),
(26, 'created', 100, 'App\\Ticket', 1, '{"title":null,"phone":"832938390","imali_account":null,"content":"Nao consigo transferir dinheiro usando o QRCode","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":3,"updated_at":"2022-02-04T10:48:57.000000Z","created_at":"2022-02-04T10:48:57.000000Z","id":100,"attachments":[],"media":[]}', '::1', '2022-02-04 12:48:58', '2022-02-04 12:48:58'),
(27, 'created', 101, 'App\\Ticket', 1, '{"title":null,"phone":"833329930","imali_account":"21003687","content":"Carregamento Falha...","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"2","status_id":1,"priority_id":1,"departments_id":5,"updated_at":"2022-02-04T11:00:56.000000Z","created_at":"2022-02-04T11:00:56.000000Z","id":101,"attachments":[],"media":[]}', '::1', '2022-02-04 13:00:56', '2022-02-04 13:00:56'),
(28, 'created', 102, 'App\\Ticket', NULL, '{"title":null,"phone":"83302001","imali_account":"210934777","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":3,"updated_at":"2022-02-04T11:03:46.000000Z","created_at":"2022-02-04T11:03:46.000000Z","id":102,"attachments":[],"media":[]}', '::1', '2022-02-04 13:03:46', '2022-02-04 13:03:46'),
(29, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-06T21:07:22.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-06 23:07:22', '2022-02-06 23:07:22'),
(30, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:43:25.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:43:25', '2022-02-07 11:43:25'),
(31, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:43:47.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:43:47', '2022-02-07 11:43:47'),
(32, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:53:11.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:53:11', '2022-02-07 11:53:11'),
(33, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:55:29.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:55:29', '2022-02-07 11:55:29'),
(34, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:55:37.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:55:37', '2022-02-07 11:55:37'),
(35, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:56:11.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:56:11', '2022-02-07 11:56:11'),
(36, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T09:56:17.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 11:56:17', '2022-02-07 11:56:17'),
(37, 'updated', 98, 'App\\Ticket', 1, '{"id":98,"title":null,"phone":"839394","imali_account":"21993450","departments_id":null,"content":"Ola iMali","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-03T16:55:04.000000Z","updated_at":"2022-02-07T10:04:42.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"1","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-07 12:04:42', '2022-02-07 12:04:42'),
(38, 'created', 103, 'App\\Ticket', 1, '{"title":null,"phone":"83984844","imali_account":null,"content":"Teste,....","author_name":"Ivo Naftal *","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-07T13:07:30.000000Z","created_at":"2022-02-07T13:07:30.000000Z","id":103,"attachments":[],"media":[]}', '::1', '2022-02-07 15:07:30', '2022-02-07 15:07:30'),
(39, 'created', 104, 'App\\Ticket', 1, '{"title":null,"phone":"219930","imali_account":null,"content":"Teste..","author_name":"Naftalivo","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-07T14:45:47.000000Z","created_at":"2022-02-07T14:45:47.000000Z","id":104,"attachments":[],"media":[]}', '::1', '2022-02-07 16:45:47', '2022-02-07 16:45:47'),
(40, 'created', 105, 'App\\Ticket', 1, '{"title":null,"phone":"8239491","imali_account":null,"content":"Problema","author_name":null,"author_email":null,"category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-07T15:31:51.000000Z","created_at":"2022-02-07T15:31:51.000000Z","id":105,"attachments":[],"media":[]}', '::1', '2022-02-07 17:31:51', '2022-02-07 17:31:51'),
(41, 'created', 106, 'App\\Ticket', 1, '{"title":null,"phone":"205052058","imali_account":"21345555","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-07T15:56:45.000000Z","created_at":"2022-02-07T15:56:45.000000Z","id":106,"attachments":[],"media":[]}', '::1', '2022-02-07 17:56:45', '2022-02-07 17:56:45'),
(42, 'created', 107, 'App\\Ticket', NULL, '{"title":null,"phone":"21940404","imali_account":null,"content":"Teste Email","author_name":"Ivo Mandemba","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T10:11:46.000000Z","created_at":"2022-02-08T10:11:46.000000Z","id":107,"attachments":[],"media":[]}', '::1', '2022-02-08 12:11:46', '2022-02-08 12:11:46'),
(43, 'created', 108, 'App\\Ticket', NULL, '{"title":null,"phone":"23482e91","imali_account":null,"content":"MMMM","author_name":"Teste","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T11:08:50.000000Z","created_at":"2022-02-08T11:08:50.000000Z","id":108,"attachments":[],"media":[]}', '::1', '2022-02-08 13:08:50', '2022-02-08 13:08:50'),
(44, 'created', 109, 'App\\Ticket', NULL, '{"title":null,"phone":"2102920","imali_account":null,"content":"Nada","author_name":"Alexandre","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T11:34:16.000000Z","created_at":"2022-02-08T11:34:16.000000Z","id":109,"attachments":[],"media":[]}', '::1', '2022-02-08 13:34:16', '2022-02-08 13:34:16'),
(45, 'created', 110, 'App\\Ticket', NULL, '{"title":null,"phone":"2179015","imali_account":"21889","content":"Nada","author_name":"Alec","author_email":"anaxyz2020@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T11:37:37.000000Z","created_at":"2022-02-08T11:37:37.000000Z","id":110,"attachments":[],"media":[]}', '::1', '2022-02-08 13:37:37', '2022-02-08 13:37:37'),
(46, 'created', 111, 'App\\Ticket', NULL, '{"title":null,"phone":"219037477","imali_account":null,"content":"TV","author_name":null,"author_email":"anaxyz2020@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T13:04:52.000000Z","created_at":"2022-02-08T13:04:52.000000Z","id":111,"attachments":[],"media":[]}', '::1', '2022-02-08 15:04:53', '2022-02-08 15:04:53'),
(47, 'created', 112, 'App\\Ticket', NULL, '{"title":null,"phone":"2189494","imali_account":null,"content":"KKKK","author_name":"Andrea","author_email":"anaxyz2020@gmail.com","category_id":"5","status_id":1,"priority_id":1,"departments_id":10,"updated_at":"2022-02-08T13:08:05.000000Z","created_at":"2022-02-08T13:08:05.000000Z","id":112,"attachments":[],"media":[]}', '::1', '2022-02-08 15:08:05', '2022-02-08 15:08:05'),
(48, 'created', 113, 'App\\Ticket', NULL, '{"title":null,"phone":"20999223","imali_account":null,"content":"kkkk","author_name":"Paulo","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T13:14:44.000000Z","created_at":"2022-02-08T13:14:44.000000Z","id":113,"attachments":[],"media":[]}', '::1', '2022-02-08 15:14:44', '2022-02-08 15:14:44'),
(49, 'created', 114, 'App\\Ticket', NULL, '{"title":null,"phone":"19027755","imali_account":null,"content":"Okkkk","author_name":"Xander","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T13:19:52.000000Z","created_at":"2022-02-08T13:19:52.000000Z","id":114,"attachments":[],"media":[]}', '::1', '2022-02-08 15:19:52', '2022-02-08 15:19:52'),
(50, 'created', 115, 'App\\Ticket', NULL, '{"title":null,"phone":"0823477","imali_account":null,"content":"dcceddddddd","author_name":"Kaul Juhan","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T13:23:21.000000Z","created_at":"2022-02-08T13:23:21.000000Z","id":115,"attachments":[],"media":[]}', '::1', '2022-02-08 15:23:21', '2022-02-08 15:23:21'),
(51, 'created', 116, 'App\\Ticket', NULL, '{"title":null,"phone":"299822111","imali_account":null,"content":"Teste...","author_name":"Peter","author_email":"naftalivo@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T13:29:01.000000Z","created_at":"2022-02-08T13:29:01.000000Z","id":116,"attachments":[],"media":[]}', '::1', '2022-02-08 15:29:02', '2022-02-08 15:29:02'),
(52, 'created', 117, 'App\\Ticket', NULL, '{"title":null,"phone":"2002331","imali_account":null,"content":"ggggggG....","author_name":"Stewart","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T13:32:07.000000Z","created_at":"2022-02-08T13:32:07.000000Z","id":117,"attachments":[],"media":[]}', '::1', '2022-02-08 15:32:07', '2022-02-08 15:32:07'),
(53, 'created', 118, 'App\\Ticket', NULL, '{"title":null,"phone":"2002333333","imali_account":null,"content":"Teste Email","author_name":"Teste Email","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T13:46:56.000000Z","created_at":"2022-02-08T13:46:56.000000Z","id":118,"attachments":[],"media":[]}', '::1', '2022-02-08 15:46:56', '2022-02-08 15:46:56'),
(54, 'created', 119, 'App\\Ticket', NULL, '{"title":null,"phone":"2002333333","imali_account":null,"content":"Teste Email","author_name":"Teste Email","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T13:50:11.000000Z","created_at":"2022-02-08T13:50:11.000000Z","id":119,"attachments":[],"media":[]}', '::1', '2022-02-08 15:50:11', '2022-02-08 15:50:11'),
(55, 'created', 120, 'App\\Ticket', NULL, '{"title":null,"phone":"2002333333","imali_account":null,"content":"Teste Email","author_name":"Teste Email","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T13:51:15.000000Z","created_at":"2022-02-08T13:51:15.000000Z","id":120,"attachments":[],"media":[]}', '::1', '2022-02-08 15:51:15', '2022-02-08 15:51:15'),
(56, 'created', 121, 'App\\Ticket', NULL, '{"title":null,"phone":"299000111","imali_account":null,"content":"dddddxxx","author_name":"Tidia","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T14:00:16.000000Z","created_at":"2022-02-08T14:00:16.000000Z","id":121,"attachments":[],"media":[]}', '::1', '2022-02-08 16:00:16', '2022-02-08 16:00:16'),
(57, 'created', 122, 'App\\Ticket', NULL, '{"title":null,"phone":"1112003277","imali_account":null,"content":"cdz","author_name":"Ana","author_email":"anaxyz2020@gmail.com","category_id":"5","status_id":1,"priority_id":1,"departments_id":10,"updated_at":"2022-02-08T14:04:06.000000Z","created_at":"2022-02-08T14:04:06.000000Z","id":122,"attachments":[],"media":[]}', '::1', '2022-02-08 16:04:06', '2022-02-08 16:04:06'),
(58, 'created', 123, 'App\\Ticket', NULL, '{"title":null,"phone":"21100287","imali_account":null,"content":"sssss","author_name":"Abella","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T14:14:01.000000Z","created_at":"2022-02-08T14:14:01.000000Z","id":123,"attachments":[],"media":[]}', '::1', '2022-02-08 16:14:01', '2022-02-08 16:14:01'),
(59, 'created', 124, 'App\\Ticket', NULL, '{"title":null,"phone":"1109777728","imali_account":null,"content":"mmmm","author_name":"Ana Claudia","author_email":"anaxyz2020@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T14:19:21.000000Z","created_at":"2022-02-08T14:19:21.000000Z","id":124,"attachments":[],"media":[]}', '::1', '2022-02-08 16:19:21', '2022-02-08 16:19:21'),
(60, 'created', 125, 'App\\Ticket', NULL, '{"title":null,"phone":"2999200111","imali_account":null,"content":"ddddd","author_name":"Silvia","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T14:26:39.000000Z","created_at":"2022-02-08T14:26:39.000000Z","id":125,"attachments":[],"media":[]}', '::1', '2022-02-08 16:26:39', '2022-02-08 16:26:39'),
(61, 'created', 126, 'App\\Ticket', 1, '{"title":null,"phone":"111114445","imali_account":null,"content":"ddff","author_name":"Tirah","author_email":"anaxyz2020@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":9,"updated_at":"2022-02-08T15:17:56.000000Z","created_at":"2022-02-08T15:17:56.000000Z","id":126,"attachments":[],"media":[]}', '::1', '2022-02-08 17:17:56', '2022-02-08 17:17:56'),
(62, 'created', 127, 'App\\Ticket', 1, '{"title":null,"phone":"211111777","imali_account":null,"content":"Ohhhh","author_name":"Wamda","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T15:22:05.000000Z","created_at":"2022-02-08T15:22:05.000000Z","id":127,"attachments":[],"media":[]}', '::1', '2022-02-08 17:22:05', '2022-02-08 17:22:05'),
(63, 'created', 128, 'App\\Ticket', 1, '{"title":null,"phone":"1111777222","imali_account":null,"content":"dddd","author_name":"Salma","author_email":"anaxyz2020@gmail.com","category_id":"2","status_id":1,"priority_id":1,"departments_id":10,"updated_at":"2022-02-08T15:24:25.000000Z","created_at":"2022-02-08T15:24:25.000000Z","id":128,"attachments":[],"media":[]}', '::1', '2022-02-08 17:24:25', '2022-02-08 17:24:25'),
(64, 'created', 129, 'App\\Ticket', 1, '{"title":null,"phone":"211111111","imali_account":null,"content":"ddddd","author_name":"Berta","author_email":"anaxyz2020@gmail.com","category_id":"5","status_id":1,"priority_id":1,"departments_id":10,"updated_at":"2022-02-08T15:28:50.000000Z","created_at":"2022-02-08T15:28:50.000000Z","id":129,"attachments":[],"media":[]}', '::1', '2022-02-08 17:28:50', '2022-02-08 17:28:50'),
(65, 'created', 130, 'App\\Ticket', 1, '{"title":null,"phone":"299992","imali_account":null,"content":"ssssddd","author_name":"candida","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T15:43:40.000000Z","created_at":"2022-02-08T15:43:40.000000Z","id":130,"attachments":[],"media":[]}', '::1', '2022-02-08 17:43:40', '2022-02-08 17:43:40'),
(66, 'created', 131, 'App\\Ticket', 1, '{"title":null,"phone":"299992","imali_account":null,"content":"ssssddd","author_name":"candida","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T15:45:32.000000Z","created_at":"2022-02-08T15:45:32.000000Z","id":131,"attachments":[],"media":[]}', '::1', '2022-02-08 17:45:32', '2022-02-08 17:45:32'),
(67, 'created', 132, 'App\\Ticket', 1, '{"title":null,"phone":"2100238","imali_account":null,"content":"SXzW","author_name":"Aida","author_email":"anaxyz2020@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T15:50:11.000000Z","created_at":"2022-02-08T15:50:11.000000Z","id":132,"attachments":[],"media":[]}', '::1', '2022-02-08 17:50:11', '2022-02-08 17:50:11'),
(68, 'created', 133, 'App\\Ticket', 1, '{"title":null,"phone":"210923","imali_account":null,"content":"SDX","author_name":"Nolwah","author_email":"anaxyz2020@gmail.com","category_id":"8","status_id":1,"priority_id":1,"departments_id":1,"updated_at":"2022-02-08T15:52:38.000000Z","created_at":"2022-02-08T15:52:38.000000Z","id":133,"attachments":[],"media":[]}', '::1', '2022-02-08 17:52:38', '2022-02-08 17:52:38'),
(69, 'created', 134, 'App\\Ticket', 1, '{"title":null,"phone":"2199021","imali_account":null,"content":"dc","author_name":"Suelen","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T16:11:19.000000Z","created_at":"2022-02-08T16:11:19.000000Z","id":134,"attachments":[],"media":[]}', '::1', '2022-02-08 18:11:19', '2022-02-08 18:11:19'),
(70, 'created', 135, 'App\\Ticket', 1, '{"title":null,"phone":"29028773","imali_account":null,"content":"sc","author_name":"Maria","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T16:15:15.000000Z","created_at":"2022-02-08T16:15:15.000000Z","id":135,"attachments":[],"media":[]}', '::1', '2022-02-08 18:15:15', '2022-02-08 18:15:15'),
(71, 'created', 136, 'App\\Ticket', 1, '{"title":null,"phone":"2190034","imali_account":null,"content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":12,"updated_at":"2022-02-08T16:18:02.000000Z","created_at":"2022-02-08T16:18:02.000000Z","id":136,"attachments":[],"media":[]}', '::1', '2022-02-08 18:18:02', '2022-02-08 18:18:02'),
(72, 'created', 137, 'App\\Ticket', NULL, '{"title":null,"phone":"29902","imali_account":null,"content":"dddd","author_name":"Ilda","author_email":"naftalivo@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-02-08T20:04:18.000000Z","created_at":"2022-02-08T20:04:18.000000Z","id":137,"attachments":[],"media":[]}', '::1', '2022-02-08 22:04:18', '2022-02-08 22:04:18'),
(73, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:37:06.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:37:07', '2022-02-08 22:37:07'),
(74, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:38:21.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:38:21', '2022-02-08 22:38:21'),
(75, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:38:26.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:38:26', '2022-02-08 22:38:26'),
(76, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:38:50.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:38:50', '2022-02-08 22:38:50'),
(77, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:39:01.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:39:01', '2022-02-08 22:39:01'),
(78, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:40:23.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:40:23', '2022-02-08 22:40:23'),
(79, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:41:54.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:41:55', '2022-02-08 22:41:55'),
(80, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:42:05.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:42:05', '2022-02-08 22:42:05'),
(81, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:46:07.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:46:07', '2022-02-08 22:46:07'),
(82, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-08T20:46:16.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-08 22:46:16', '2022-02-08 22:46:16'),
(83, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:15:28.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:15:28', '2022-02-09 12:15:28'),
(84, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:15:52.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:15:52', '2022-02-09 12:15:52'),
(85, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:16:46.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:16:46', '2022-02-09 12:16:46'),
(86, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:16:58.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:16:58', '2022-02-09 12:16:58'),
(87, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:27:13.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:27:13', '2022-02-09 12:27:13'),
(88, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:30:32.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:30:32', '2022-02-09 12:30:32'),
(89, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:32:12.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:32:12', '2022-02-09 12:32:12'),
(90, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:41:23.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:41:23', '2022-02-09 12:41:23'),
(91, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:44:14.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:44:14', '2022-02-09 12:44:14'),
(92, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T10:44:34.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 12:44:34', '2022-02-09 12:44:34'),
(93, 'updated', 106, 'App\\Ticket', 1, '{"id":106,"title":null,"phone":"205052058","imali_account":"21345555","departments_id":"6","content":"Nao aceita pagar com leitura de QRCode","author_name":"Samuela","author_email":"anaxyz2020@gmail.com","documento":"\\u00baM brand asset black.png1644352730.png","created_at":"2022-02-07T15:56:45.000000Z","updated_at":"2022-02-09T11:03:21.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"4","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 13:03:21', '2022-02-09 13:03:21'),
(94, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:07:02.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:07:02', '2022-02-09 15:07:02'),
(95, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:15:47.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:15:47', '2022-02-09 15:15:47'),
(96, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:16:50.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:16:50', '2022-02-09 15:16:50'),
(97, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:17:13.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:17:13', '2022-02-09 15:17:13'),
(98, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:18:03.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:18:03', '2022-02-09 15:18:03'),
(99, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:18:17.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:18:17', '2022-02-09 15:18:17'),
(100, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:19:23.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:19:23', '2022-02-09 15:19:23'),
(101, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:26:06.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:26:06', '2022-02-09 15:26:06'),
(102, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:26:15.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:26:15', '2022-02-09 15:26:15'),
(103, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:26:29.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:26:29', '2022-02-09 15:26:29'),
(104, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:27:36.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:27:36', '2022-02-09 15:27:36'),
(105, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"12","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:29:44.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-09 15:29:44', '2022-02-09 15:29:44'),
(106, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:35:43.000000Z","deleted_at":null,"status_id":"4","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-09 15:35:43', '2022-02-09 15:35:43'),
(107, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T13:36:25.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-09 15:36:25', '2022-02-09 15:36:25'),
(108, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T14:26:35.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-09 16:26:35', '2022-02-09 16:26:35'),
(109, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-09T14:28:38.000000Z","deleted_at":null,"status_id":"3","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-09 16:28:38', '2022-02-09 16:28:38'),
(110, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:16:13.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:16:13', '2022-02-10 11:16:13'),
(111, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:16:38.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:16:38', '2022-02-10 11:16:38'),
(112, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:16:57.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:16:57', '2022-02-10 11:16:57'),
(113, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:17:40.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:17:40', '2022-02-10 11:17:40'),
(114, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:21:51.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:21:51', '2022-02-10 11:21:51'),
(115, 'updated', 102, 'App\\Ticket', 1, '{"id":102,"title":null,"phone":"83302001","imali_account":"210934777","departments_id":"3","content":"Falha..","author_name":"Ivo","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-04T11:03:46.000000Z","updated_at":"2022-02-10T09:22:14.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"3","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 11:22:14', '2022-02-10 11:22:14'),
(116, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:25:33.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:25:33', '2022-02-10 11:25:33'),
(117, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:25:57.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:25:57', '2022-02-10 11:25:57'),
(118, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:34:45.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:34:45', '2022-02-10 11:34:45'),
(119, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:37:32.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:37:32', '2022-02-10 11:37:32'),
(120, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:37:44.000000Z","deleted_at":null,"status_id":"5","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:37:44', '2022-02-10 11:37:44'),
(121, 'updated', 136, 'App\\Ticket', 1, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T09:39:55.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"2","attachments":[],"media":[]}', '::1', '2022-02-10 11:39:55', '2022-02-10 11:39:55'),
(122, 'updated', 136, 'App\\Ticket', 16, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T10:32:20.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":null,"attachments":[],"media":[]}', '::1', '2022-02-10 12:32:20', '2022-02-10 12:32:20'),
(123, 'updated', 136, 'App\\Ticket', 13, '{"id":136,"title":null,"phone":"2190034","imali_account":null,"departments_id":"2","content":"dc","author_name":"Dirce Matos","author_email":"anaxyz2020@gmail.com","documento":null,"created_at":"2022-02-08T16:18:02.000000Z","updated_at":"2022-02-10T10:33:31.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"6","attachments":[],"media":[]}', '::1', '2022-02-10 12:33:31', '2022-02-10 12:33:31'),
(124, 'updated', 137, 'App\\Ticket', 1, '{"id":137,"title":null,"phone":"29902","imali_account":null,"departments_id":"2","content":"dddd","author_name":"Ilda","author_email":"naftalivo@gmail.com","documento":null,"created_at":"2022-02-08T20:04:18.000000Z","updated_at":"2022-02-11T15:01:52.000000Z","deleted_at":null,"status_id":"1","priority_id":"1","category_id":"2","assigned_to_user_id":"5","attachments":[],"media":[]}', '::1', '2022-02-11 17:01:52', '2022-02-11 17:01:52'),
(125, 'created', 138, 'App\\Ticket', 1, '{"title":null,"phone":"830001238","imali_account":"210000004","content":"Tenho enfrentado problemas para transferir valores no iMali","author_name":"Luna","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":2,"documento":"lo100x100.png1644592196.png","updated_at":"2022-02-11T15:09:56.000000Z","created_at":"2022-02-11T15:09:56.000000Z","id":138,"attachments":[],"media":[]}', '::1', '2022-02-11 17:09:56', '2022-02-11 17:09:56'),
(126, 'created', 139, 'App\\Ticket', 1, '{"title":null,"phone":"830001238","imali_account":"210000004","content":"Tenho enfrentado problemas para transferir valores no iMali","author_name":"Luna","author_email":"naftalivo@gmail.com","category_id":"3","status_id":1,"priority_id":1,"departments_id":2,"documento":"lo100x100.png1644592224.png","updated_at":"2022-02-11T15:10:24.000000Z","created_at":"2022-02-11T15:10:24.000000Z","id":139,"attachments":[],"media":[]}', '::1', '2022-02-11 17:10:24', '2022-02-11 17:10:24'),
(127, 'created', 140, 'App\\Ticket', NULL, '{"title":null,"phone":"292010","imali_account":null,"content":"teste","author_name":"Reah","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T14:53:38.000000Z","created_at":"2022-02-15T14:53:38.000000Z","id":140,"attachments":[],"media":[]}', '::1', '2022-02-15 16:53:38', '2022-02-15 16:53:38'),
(128, 'created', 141, 'App\\Ticket', NULL, '{"title":null,"phone":"283013782","imali_account":null,"content":"MMMM","author_name":"Sebasthian","author_email":"naftalivo@gmail.com","category_id":"5","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T14:56:15.000000Z","created_at":"2022-02-15T14:56:15.000000Z","id":141,"attachments":[],"media":[]}', '::1', '2022-02-15 16:56:15', '2022-02-15 16:56:15'),
(129, 'created', 142, 'App\\Ticket', NULL, '{"title":null,"phone":"189930","imali_account":null,"content":"Carregamento feito com sucesso","author_name":"Nubia","author_email":"naftalivo@gmail.com","category_id":"2","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T15:05:30.000000Z","created_at":"2022-02-15T15:05:30.000000Z","id":142,"attachments":[],"media":[]}', '::1', '2022-02-15 17:05:30', '2022-02-15 17:05:30'),
(130, 'created', 143, 'App\\Ticket', NULL, '{"title":null,"phone":"21902","imali_account":null,"content":"ssss","author_name":"Swagger","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T15:14:08.000000Z","created_at":"2022-02-15T15:14:08.000000Z","id":143,"attachments":[],"media":[]}', '::1', '2022-02-15 17:14:08', '2022-02-15 17:14:08'),
(131, 'created', 144, 'App\\Ticket', NULL, '{"title":null,"phone":"128842","imali_account":null,"content":"Carregamento da DSTV","author_name":"Ana","author_email":"naftalivo@gmail.com","category_id":"7","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T15:18:01.000000Z","created_at":"2022-02-15T15:18:01.000000Z","id":144,"attachments":[],"media":[]}', '::1', '2022-02-15 17:18:01', '2022-02-15 17:18:01'),
(132, 'created', 145, 'App\\Ticket', NULL, '{"title":null,"phone":"121233111","imali_account":null,"content":"mmsmsd","author_name":"Teste","author_email":"naftalivo@gmail.com","category_id":"8","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-02-15T15:35:29.000000Z","created_at":"2022-02-15T15:35:29.000000Z","id":145,"attachments":[],"media":[]}', '::1', '2022-02-15 17:35:29', '2022-02-15 17:35:29'),
(133, 'created', 146, 'App\\Ticket', NULL, '{"title":null,"phone":"78484838","imali_account":null,"content":"nenhum","author_name":"P","author_email":"naftalivo@gmail.com","category_id":"4","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-09T19:51:58.000000Z","created_at":"2022-03-09T19:51:58.000000Z","id":146,"attachments":[],"media":[]}', '::1', '2022-03-09 21:51:58', '2022-03-09 21:51:58'),
(134, 'created', 147, 'App\\Ticket', NULL, '{"title":null,"phone":"7888485","imali_account":null,"content":"sfcscsc","author_name":"Ana","author_email":"naftalivo@gmail.com","category_id":"5","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-09T21:53:50.000000Z","created_at":"2022-03-09T21:53:50.000000Z","id":147,"attachments":[],"media":[]}', '::1', '2022-03-09 23:53:50', '2022-03-09 23:53:50'),
(135, 'created', 148, 'App\\Ticket', NULL, '{"title":null,"phone":"7888485","imali_account":null,"content":"sfcscsc","author_name":"Ana Maria","author_email":"naftalivo@gmail.com","category_id":"5","tipos_id":"3","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-09T22:01:07.000000Z","created_at":"2022-03-09T22:01:07.000000Z","id":148,"attachments":[],"media":[]}', '::1', '2022-03-10 00:01:07', '2022-03-10 00:01:07'),
(136, 'created', 149, 'App\\Ticket', NULL, '{"title":null,"phone":"65384494","imali_account":null,"content":"dffdf","author_name":"Sdc","author_email":"naftal@gmail.com","category_id":"8","tipos_id":"2","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-09T22:19:56.000000Z","created_at":"2022-03-09T22:19:56.000000Z","id":149,"attachments":[],"media":[]}', '::1', '2022-03-10 00:19:56', '2022-03-10 00:19:56'),
(137, 'created', 150, 'App\\Ticket', NULL, '{"title":null,"phone":"25900","imali_account":"21000369","content":"WSE","author_name":"Filipa","author_email":"naftalivo@gmail.com","category_id":"5","tipos_id":null,"status_id":1,"priority_id":1,"departments_id":2,"documento":"imali-wp.PNG1646911021.PNG","updated_at":"2022-03-10T11:17:01.000000Z","created_at":"2022-03-10T11:17:01.000000Z","id":150,"attachments":[],"media":[]}', '::1', '2022-03-10 13:17:01', '2022-03-10 13:17:01'),
(138, 'created', 151, 'App\\Ticket', NULL, '{"title":null,"phone":"38348484","imali_account":"28383838","content":"adna damdmad","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"5","tipos_id":"2","status_id":1,"priority_id":1,"departments_id":2,"documento":"dvj.PNG1646924519.PNG","updated_at":"2022-03-10T15:01:59.000000Z","created_at":"2022-03-10T15:01:59.000000Z","id":151,"attachments":[],"media":[]}', '::1', '2022-03-10 17:01:59', '2022-03-10 17:01:59'),
(139, 'created', 152, 'App\\Ticket', NULL, '{"title":null,"phone":"774747","imali_account":"2183838","content":"dcccc","author_name":"Ama","author_email":"ana@hmama.com","category_id":"7","tipos_id":"3","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-10T15:03:31.000000Z","created_at":"2022-03-10T15:03:31.000000Z","id":152,"attachments":[],"media":[]}', '::1', '2022-03-10 17:03:31', '2022-03-10 17:03:31'),
(140, 'created', 153, 'App\\Ticket', NULL, '{"title":null,"phone":null,"imali_account":null,"content":null,"author_name":null,"author_email":null,"category_id":"8","tipos_id":"3","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-10T15:41:03.000000Z","created_at":"2022-03-10T15:41:03.000000Z","id":153,"attachments":[],"media":[]}', '::1', '2022-03-10 17:41:03', '2022-03-10 17:41:03'),
(141, 'created', 154, 'App\\Ticket', NULL, '{"title":null,"phone":"8499","imali_account":"7474848","content":"vvvsvvsdvs","author_name":"W","author_email":"W@add.com","category_id":"10","tipos_id":"2","status_id":1,"priority_id":1,"departments_id":6,"documento":"dvj.PNG1646927038.PNG","updated_at":"2022-03-10T15:43:58.000000Z","created_at":"2022-03-10T15:43:58.000000Z","id":154,"attachments":[],"media":[]}', '::1', '2022-03-10 17:43:58', '2022-03-10 17:43:58'),
(142, 'created', 155, 'App\\Ticket', NULL, '{"title":null,"phone":"3456","imali_account":"210000004","content":"After Hours","author_name":"A","author_email":"naftalivo@gmail.com","category_id":"7","tipos_id":"3","status_id":1,"priority_id":1,"departments_id":2,"documento":"dvj.PNG1646927511.PNG","updated_at":"2022-03-10T15:51:51.000000Z","created_at":"2022-03-10T15:51:51.000000Z","id":155,"attachments":[],"media":[]}', '::1', '2022-03-10 17:51:51', '2022-03-10 17:51:51'),
(143, 'created', 156, 'App\\Ticket', NULL, '{"title":null,"phone":"87 1223 333","imali_account":"21 000000 1","content":"Nenhuma","author_name":"Iva","author_email":"eva@hotmail.com","category_id":"9","tipos_id":"2","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-10T20:00:10.000000Z","created_at":"2022-03-10T20:00:10.000000Z","id":156,"attachments":[],"media":[]}', '::1', '2022-03-10 22:00:10', '2022-03-10 22:00:10'),
(144, 'created', 157, 'App\\Ticket', NULL, '{"title":null,"phone":"83 3197 222","imali_account":"21 000000 4","content":"nenhuma","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"2","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-11T09:21:18.000000Z","created_at":"2022-03-11T09:21:18.000000Z","id":157,"attachments":[],"media":[]}', '::1', '2022-03-11 11:21:18', '2022-03-11 11:21:18'),
(145, 'created', 158, 'App\\Ticket', 1, '{"title":null,"phone":"21 9099 999","imali_account":"21 000000 3","content":"vvvv","author_name":"Marinho","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-11T11:28:24.000000Z","created_at":"2022-03-11T11:28:24.000000Z","id":158,"attachments":[],"media":[]}', '::1', '2022-03-11 13:28:24', '2022-03-11 13:28:24'),
(146, 'created', 159, 'App\\Ticket', NULL, '{"title":null,"phone":"83 3197 222","imali_account":"21 000000 4","content":"NH","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"documento":"Grupo-134-optimized.jpg1647006194.jpg","updated_at":"2022-03-11T13:43:14.000000Z","created_at":"2022-03-11T13:43:14.000000Z","id":159,"attachments":[],"media":[]}', '::1', '2022-03-11 15:43:14', '2022-03-11 15:43:14'),
(147, 'created', 160, 'App\\Ticket', NULL, '{"title":null,"phone":"22 3233 223","imali_account":"23 232332 3","content":"dffdfddf","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"documento":"Grupo-134-optimized.jpg1647007054.jpg","updated_at":"2022-03-11T13:57:34.000000Z","created_at":"2022-03-11T13:57:34.000000Z","id":160,"attachments":[],"media":[]}', '::1', '2022-03-11 15:57:34', '2022-03-11 15:57:34'),
(148, 'created', 161, 'App\\Ticket', NULL, '{"title":null,"phone":"22 3232 322","imali_account":"23 232232 3","content":"fdfdfd","author_name":"Q","author_email":"naftalivo@gmail.com","category_id":"11","tipos_id":null,"gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-11T14:41:11.000000Z","created_at":"2022-03-11T14:41:11.000000Z","id":161,"attachments":[],"media":[]}', '::1', '2022-03-11 16:41:11', '2022-03-11 16:41:11'),
(149, 'created', 162, 'App\\Ticket', NULL, '{"title":null,"phone":"23 2333 232","imali_account":"23 232323 2","content":"fffff","author_name":"Ken","author_email":"naftalivo@gmail.com","category_id":"4","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-11T14:52:06.000000Z","created_at":"2022-03-11T14:52:06.000000Z","id":162,"attachments":[],"media":[]}', '::1', '2022-03-11 16:52:06', '2022-03-11 16:52:06'),
(150, 'created', 163, 'App\\Ticket', NULL, '{"title":null,"phone":"87 3035 450","imali_account":"21 000000 5","content":"Sugestao de conteudo","author_name":"Muhammad Machado","author_email":"muhmachado90@gmail.com","category_id":"11","tipos_id":"3","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-11T15:00:32.000000Z","created_at":"2022-03-11T15:00:32.000000Z","id":163,"attachments":[],"media":[]}', '::1', '2022-03-11 17:00:32', '2022-03-11 17:00:32'),
(151, 'created', 164, 'App\\Ticket', NULL, '{"title":null,"phone":"84 5030 902","imali_account":"21 000000 1","content":"Testsadlsd","author_name":"Miguel Macamo","author_email":"miguelmacamo9@gmail.com","category_id":"10","tipos_id":"1","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"documento":"imali-help-home.PNG1647012351.PNG","updated_at":"2022-03-11T15:25:51.000000Z","created_at":"2022-03-11T15:25:51.000000Z","id":164,"attachments":[],"media":[]}', '::1', '2022-03-11 17:25:51', '2022-03-11 17:25:51'),
(152, 'created', 165, 'App\\Ticket', NULL, '{"title":null,"phone":"21 4444 444","imali_account":"32 667677 6","content":"gfgfgg","author_name":"Antonia Cumbe","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-14T14:49:23.000000Z","created_at":"2022-03-14T14:49:23.000000Z","id":165,"attachments":[],"media":[]}', '::1', '2022-03-14 16:49:23', '2022-03-14 16:49:23'),
(153, 'created', 166, 'App\\Ticket', NULL, '{"title":null,"phone":"82 3823 823","imali_account":"23 823823 8","content":"sssf","author_name":"Mireal","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"3","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-14T14:51:23.000000Z","created_at":"2022-03-14T14:51:23.000000Z","id":166,"attachments":[],"media":[]}', '::1', '2022-03-14 16:51:23', '2022-03-14 16:51:23'),
(154, 'created', 167, 'App\\Ticket', NULL, '{"title":null,"phone":"12 1211 212","imali_account":"12 121221 1","content":"dfdf","author_name":"Suria","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-14T16:22:33.000000Z","created_at":"2022-03-14T16:22:33.000000Z","id":167,"attachments":[],"media":[]}', '::1', '2022-03-14 18:22:33', '2022-03-14 18:22:33'),
(155, 'created', 168, 'App\\Ticket', NULL, '{"title":null,"phone":"11 1313 131","imali_account":"12 121212 1","content":"edc","author_name":"A","author_email":"naftalivo@gmail.com","category_id":"2","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-14T16:23:56.000000Z","created_at":"2022-03-14T16:23:56.000000Z","id":168,"attachments":[],"media":[]}', '::1', '2022-03-14 18:23:57', '2022-03-14 18:23:57'),
(156, 'created', 169, 'App\\Ticket', NULL, '{"title":null,"phone":"21 2323 332","imali_account":"13 311313 1","content":"sffsf","author_name":"Yara","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T09:21:41.000000Z","created_at":"2022-03-15T09:21:41.000000Z","id":169,"attachments":[],"media":[]}', '::1', '2022-03-15 11:21:41', '2022-03-15 11:21:41'),
(157, 'created', 170, 'App\\Ticket', NULL, '{"title":null,"phone":"22 3232 333","imali_account":"23 232323 2","content":"323222","author_name":"Wilma","author_email":"naftalivo@gmail.com","category_id":"11","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T09:25:37.000000Z","created_at":"2022-03-15T09:25:37.000000Z","id":170,"attachments":[],"media":[]}', '::1', '2022-03-15 11:25:37', '2022-03-15 11:25:37'),
(158, 'created', 171, 'App\\Ticket', NULL, '{"title":null,"phone":"32 3322 332","imali_account":"23 223232 3","content":"22323","author_name":"Ana","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T10:26:42.000000Z","created_at":"2022-03-15T10:26:42.000000Z","id":171,"attachments":[],"media":[]}', '::1', '2022-03-15 12:26:42', '2022-03-15 12:26:42'),
(159, 'created', 172, 'App\\Ticket', NULL, '{"title":null,"phone":"11 1313 331","imali_account":"31 333113 1","content":"33131","author_name":"Jussara","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T10:30:32.000000Z","created_at":"2022-03-15T10:30:32.000000Z","id":172,"attachments":[],"media":[]}', '::1', '2022-03-15 12:30:32', '2022-03-15 12:30:32'),
(160, 'created', 173, 'App\\Ticket', NULL, '{"title":null,"phone":"12 1333 232","imali_account":"11 121212 1","content":"12121212","author_name":"Courl","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-15T10:38:44.000000Z","created_at":"2022-03-15T10:38:44.000000Z","id":173,"attachments":[],"media":[]}', '::1', '2022-03-15 12:38:44', '2022-03-15 12:38:44'),
(161, 'created', 174, 'App\\Ticket', NULL, '{"title":null,"phone":"21 1213 344","imali_account":"24 244445 5","content":"rffg","author_name":"Quim","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"1","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T10:44:14.000000Z","created_at":"2022-03-15T10:44:14.000000Z","id":174,"attachments":[],"media":[]}', '::1', '2022-03-15 12:44:14', '2022-03-15 12:44:14'),
(162, 'created', 175, 'App\\Ticket', NULL, '{"title":null,"phone":"12 3345 656","imali_account":"12 345689 9","content":"fggg","author_name":"QA","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T10:46:42.000000Z","created_at":"2022-03-15T10:46:42.000000Z","id":175,"attachments":[],"media":[]}', '::1', '2022-03-15 12:46:42', '2022-03-15 12:46:42'),
(163, 'created', 176, 'App\\Ticket', NULL, '{"title":null,"phone":"21 8393 949","imali_account":"21 000003 0","content":"cdf","author_name":"Steve","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T12:02:26.000000Z","created_at":"2022-03-15T12:02:26.000000Z","id":176,"attachments":[],"media":[]}', '::1', '2022-03-15 14:02:26', '2022-03-15 14:02:26'),
(164, 'created', 177, 'App\\Ticket', NULL, '{"title":null,"phone":"73 3884 848","imali_account":"73 737474 7","content":"dfdd","author_name":"Steve","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T12:04:43.000000Z","created_at":"2022-03-15T12:04:43.000000Z","id":177,"attachments":[],"media":[]}', '::1', '2022-03-15 14:04:43', '2022-03-15 14:04:43'),
(165, 'created', 178, 'App\\Ticket', NULL, '{"title":null,"phone":"12 8323 992","imali_account":"32 332323 2","content":"ffff","author_name":"Arnaldo","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-15T12:57:12.000000Z","created_at":"2022-03-15T12:57:12.000000Z","id":178,"attachments":[],"media":[]}', '::1', '2022-03-15 14:57:13', '2022-03-15 14:57:13'),
(166, 'created', 179, 'App\\Ticket', NULL, '{"title":null,"phone":"13 3372 732","imali_account":"22 444455 4","content":"dgdgdg","author_name":"Dre","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-15T13:00:30.000000Z","created_at":"2022-03-15T13:00:30.000000Z","id":179,"attachments":[],"media":[]}', '::1', '2022-03-15 15:00:30', '2022-03-15 15:00:30'),
(167, 'created', 180, 'App\\Ticket', NULL, '{"title":null,"phone":"23 3333 333","imali_account":null,"content":"ffff","author_name":"W","author_email":"3333@dddd.com","category_id":"9","tipos_id":"2","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T10:49:44.000000Z","created_at":"2022-03-16T10:49:44.000000Z","id":180,"attachments":[],"media":[]}', '::1', '2022-03-16 12:49:45', '2022-03-16 12:49:45'),
(168, 'created', 181, 'App\\Ticket', NULL, '{"title":null,"phone":"22 2222 222","imali_account":"22 222222 2","content":"22222","author_name":"ER","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T11:06:03.000000Z","created_at":"2022-03-16T11:06:03.000000Z","id":181,"attachments":[],"media":[]}', '::1', '2022-03-16 13:06:03', '2022-03-16 13:06:03'),
(169, 'created', 182, 'App\\Ticket', NULL, '{"title":null,"phone":"22 2222 224","imali_account":"22 222222 6","content":"22222ee","author_name":"ERe","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T11:10:26.000000Z","created_at":"2022-03-16T11:10:26.000000Z","id":182,"attachments":[],"media":[]}', '::1', '2022-03-16 13:10:26', '2022-03-16 13:10:26'),
(170, 'created', 183, 'App\\Ticket', NULL, '{"title":null,"phone":"44 44__ ___","imali_account":"45 4545__ _","content":"4445","author_name":"rrr","author_email":"rrr@ddd.com","category_id":"10","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T11:11:12.000000Z","created_at":"2022-03-16T11:11:12.000000Z","id":183,"attachments":[],"media":[]}', '::1', '2022-03-16 13:11:12', '2022-03-16 13:11:12'),
(171, 'created', 184, 'App\\Ticket', NULL, '{"title":null,"phone":"44242424","imali_account":"242424","content":"ffffdfd","author_name":"QAA","author_email":"naftalivo@gmail.com","category_id":"10","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T12:50:37.000000Z","created_at":"2022-03-16T12:50:37.000000Z","id":184,"attachments":[],"media":[]}', '::1', '2022-03-16 14:50:37', '2022-03-16 14:50:37'),
(172, 'created', 185, 'App\\Ticket', NULL, '{"title":null,"phone":"45 4454 545","imali_account":"45 454545 4","content":"fdfdf","author_name":"Aquimi","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T12:58:18.000000Z","created_at":"2022-03-16T12:58:18.000000Z","id":185,"attachments":[],"media":[]}', '::1', '2022-03-16 14:58:18', '2022-03-16 14:58:18'),
(173, 'created', 186, 'App\\Ticket', NULL, '{"title":null,"phone":"34 3434 434","imali_account":"34 334___ _","content":"334","author_name":"ec","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:08:56.000000Z","created_at":"2022-03-16T13:08:56.000000Z","id":186,"attachments":[],"media":[]}', '::1', '2022-03-16 15:08:56', '2022-03-16 15:08:56'),
(174, 'created', 187, 'App\\Ticket', NULL, '{"title":null,"phone":"33 333_ ___","imali_account":null,"content":"333","author_name":"222","author_email":"2222@sss","category_id":"11","tipos_id":null,"gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:32:08.000000Z","created_at":"2022-03-16T13:32:08.000000Z","id":187,"attachments":[],"media":[]}', '::1', '2022-03-16 15:32:08', '2022-03-16 15:32:08'),
(175, 'created', 188, 'App\\Ticket', NULL, '{"title":null,"phone":"33 333_ ___","imali_account":null,"content":"333","author_name":"wwww","author_email":null,"category_id":"11","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:32:35.000000Z","created_at":"2022-03-16T13:32:35.000000Z","id":188,"attachments":[],"media":[]}', '::1', '2022-03-16 15:32:35', '2022-03-16 15:32:35'),
(176, 'created', 189, 'App\\Ticket', NULL, '{"title":null,"phone":"33 333_ ___","imali_account":null,"content":"333","author_name":"wwww","author_email":"www","category_id":"11","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:32:42.000000Z","created_at":"2022-03-16T13:32:42.000000Z","id":189,"attachments":[],"media":[]}', '::1', '2022-03-16 15:32:42', '2022-03-16 15:32:42'),
(177, 'created', 190, 'App\\Ticket', NULL, '{"title":null,"phone":null,"imali_account":null,"content":"333","author_name":"wwww","author_email":"www@ddd","category_id":"11","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:32:54.000000Z","created_at":"2022-03-16T13:32:54.000000Z","id":190,"attachments":[],"media":[]}', '::1', '2022-03-16 15:32:54', '2022-03-16 15:32:54'),
(178, 'created', 191, 'App\\Ticket', NULL, '{"title":null,"phone":"22 2332 222","imali_account":"22 222___ _","content":null,"author_name":"wwww","author_email":"www@ddd","category_id":"11","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:33:16.000000Z","created_at":"2022-03-16T13:33:16.000000Z","id":191,"attachments":[],"media":[]}', '::1', '2022-03-16 15:33:16', '2022-03-16 15:33:16'),
(179, 'created', 192, 'App\\Ticket', NULL, '{"title":null,"phone":"22 2332 222","imali_account":"22 222___ _","content":"dddd","author_name":"wwww","author_email":"www@ddd","category_id":"7","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T13:33:37.000000Z","created_at":"2022-03-16T13:33:37.000000Z","id":192,"attachments":[],"media":[]}', '::1', '2022-03-16 15:33:37', '2022-03-16 15:33:37'),
(180, 'created', 193, 'App\\Ticket', NULL, '{"title":null,"phone":"22 2332 222","imali_account":"22 222222 2","content":"dddd","author_name":"wwww","author_email":"www@ddd.com","category_id":"7","tipos_id":"1","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T13:34:47.000000Z","created_at":"2022-03-16T13:34:47.000000Z","id":193,"attachments":[],"media":[]}', '::1', '2022-03-16 15:34:47', '2022-03-16 15:34:47'),
(181, 'created', 194, 'App\\Ticket', NULL, '{"title":null,"phone":"55 6799 000","imali_account":"34 455566 7","content":"ddffd","author_name":"Qxc","author_email":"naftalivo@gmail.com","category_id":"11","tipos_id":"1","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T13:37:47.000000Z","created_at":"2022-03-16T13:37:47.000000Z","id":194,"attachments":[],"media":[]}', '::1', '2022-03-16 15:37:47', '2022-03-16 15:37:47'),
(182, 'created', 195, 'App\\Ticket', NULL, '{"title":null,"phone":"44 4444 444","imali_account":"44 444444 4","content":"44444444","author_name":"eeee","author_email":"eee@ddddd","category_id":"9","tipos_id":"1","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T15:04:30.000000Z","created_at":"2022-03-16T15:04:30.000000Z","id":195,"attachments":[],"media":[]}', '::1', '2022-03-16 17:04:30', '2022-03-16 17:04:30'),
(183, 'created', 196, 'App\\Ticket', NULL, '{"title":null,"phone":"44 4444 444","imali_account":"44 444444 4","content":"44444444","author_name":"eeeewww","author_email":"eee@ddddd.com","category_id":"11","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"documento":"Grupo-134-optimized.jpg1647443152.jpg","updated_at":"2022-03-16T15:05:52.000000Z","created_at":"2022-03-16T15:05:52.000000Z","id":196,"attachments":[],"media":[]}', '::1', '2022-03-16 17:05:52', '2022-03-16 17:05:52'),
(184, 'created', 197, 'App\\Ticket', NULL, '{"title":null,"phone":"44 4444 455","imali_account":"44 844959 5","content":"ddc44ff","author_name":"eeeewwww","author_email":"eee@ddd.com","category_id":"2","tipos_id":"3","gender":"M","status_id":1,"priority_id":1,"departments_id":2,"documento":"Grupo-134-optimized.jpg1647443272.jpg","updated_at":"2022-03-16T15:07:52.000000Z","created_at":"2022-03-16T15:07:52.000000Z","id":197,"attachments":[],"media":[]}', '::1', '2022-03-16 17:07:52', '2022-03-16 17:07:52'),
(185, 'created', 198, 'App\\Ticket', NULL, '{"title":null,"phone":"34 4343 334","imali_account":"34 334343 4","content":"343434","author_name":"Qas","author_email":"naftalivo@gmail.com","category_id":"11","tipos_id":"2","gender":"F","status_id":1,"priority_id":1,"departments_id":6,"documento":"iMali-HelpDesk.PNG1647443515.PNG","updated_at":"2022-03-16T15:11:55.000000Z","created_at":"2022-03-16T15:11:55.000000Z","id":198,"attachments":[],"media":[]}', '::1', '2022-03-16 17:11:55', '2022-03-16 17:11:55'),
(186, 'created', 199, 'App\\Ticket', NULL, '{"title":null,"phone":"45 4545 ___","imali_account":"45 4545__ _","content":"5454","author_name":"eeee","author_email":"ddfd@dfdfdf","category_id":"10","tipos_id":"3","gender":"M","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T15:12:35.000000Z","created_at":"2022-03-16T15:12:35.000000Z","id":199,"attachments":[],"media":[]}', '::1', '2022-03-16 17:12:35', '2022-03-16 17:12:35'),
(187, 'created', 200, 'App\\Ticket', NULL, '{"title":null,"phone":"34 3496 969","imali_account":"38 384849 4","content":"334ffv","author_name":"ecW","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"1","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T15:21:52.000000Z","created_at":"2022-03-16T15:21:52.000000Z","id":200,"attachments":[],"media":[]}', '::1', '2022-03-16 17:21:52', '2022-03-16 17:21:52'),
(188, 'created', 201, 'App\\Ticket', NULL, '{"title":null,"phone":"38 3884 845","imali_account":"44 544554 5","content":"4445","author_name":"Teste Sync","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T16:42:12.000000Z","created_at":"2022-03-16T16:42:12.000000Z","id":201,"attachments":[],"media":[]}', '::1', '2022-03-16 18:42:12', '2022-03-16 18:42:12'),
(189, 'created', 202, 'App\\Ticket', NULL, '{"title":null,"phone":"73 8838 484","imali_account":"45 666556 5","content":"5t5tg","author_name":"Nadia Narkova","author_email":"naftalivo@gmail.com","category_id":"4","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T16:43:35.000000Z","created_at":"2022-03-16T16:43:35.000000Z","id":202,"attachments":[],"media":[]}', '::1', '2022-03-16 18:43:35', '2022-03-16 18:43:35'),
(190, 'created', 203, 'App\\Ticket', NULL, '{"title":null,"phone":"28 8393 938","imali_account":null,"content":"fdfdfdf","author_name":"Amarilia","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T17:14:01.000000Z","created_at":"2022-03-16T17:14:01.000000Z","id":203,"attachments":[],"media":[]}', '::1', '2022-03-16 19:14:01', '2022-03-16 19:14:01'),
(191, 'created', 204, 'App\\Ticket', NULL, '{"title":null,"phone":"27 3734 848","imali_account":null,"content":"dfdf","author_name":"Yu","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"2","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T17:18:04.000000Z","created_at":"2022-03-16T17:18:04.000000Z","id":204,"attachments":[],"media":[]}', '::1', '2022-03-16 19:18:04', '2022-03-16 19:18:04'),
(192, 'created', 205, 'App\\Ticket', NULL, '{"title":null,"phone":"13 3443 034","imali_account":null,"content":"Ye","author_name":"Ted","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T19:14:46.000000Z","created_at":"2022-03-16T19:14:46.000000Z","id":205,"attachments":[],"media":[]}', '::1', '2022-03-16 21:14:46', '2022-03-16 21:14:46'),
(193, 'created', 206, 'App\\Ticket', NULL, '{"title":null,"phone":"13 3443 035","imali_account":null,"content":"Ye yeah yeah","author_name":"TedX","author_email":"naftalivo@gmail.com","category_id":"2","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T19:16:49.000000Z","created_at":"2022-03-16T19:16:49.000000Z","id":206,"attachments":[],"media":[]}', '::1', '2022-03-16 21:16:49', '2022-03-16 21:16:49'),
(194, 'created', 207, 'App\\Ticket', NULL, '{"title":null,"phone":"74 7484 884","imali_account":null,"content":"mmm","author_name":"Ola","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"1","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T19:34:51.000000Z","created_at":"2022-03-16T19:34:51.000000Z","id":207,"attachments":[],"media":[]}', '::1', '2022-03-16 21:34:51', '2022-03-16 21:34:51'),
(195, 'created', 208, 'App\\Ticket', NULL, '{"title":null,"phone":"45 4545 454","imali_account":null,"content":"nnm","author_name":"Ed","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T22:32:34.000000Z","created_at":"2022-03-16T22:32:34.000000Z","id":208,"attachments":[],"media":[]}', '::1', '2022-03-17 00:32:34', '2022-03-17 00:32:34'),
(196, 'created', 209, 'App\\Ticket', NULL, '{"title":null,"phone":"23 2232 323","imali_account":null,"content":"mbj","author_name":"Samira","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T22:34:44.000000Z","created_at":"2022-03-16T22:34:44.000000Z","id":209,"attachments":[],"media":[]}', '::1', '2022-03-17 00:34:44', '2022-03-17 00:34:44'),
(197, 'created', 210, 'App\\Ticket', NULL, '{"title":null,"phone":"23 9292 323","imali_account":null,"content":"mk","author_name":"Lidia","author_email":"naftalivo@gmail.com","category_id":"7","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T22:37:02.000000Z","created_at":"2022-03-16T22:37:02.000000Z","id":210,"attachments":[],"media":[]}', '::1', '2022-03-17 00:37:02', '2022-03-17 00:37:02'),
(198, 'created', 211, 'App\\Ticket', NULL, '{"title":null,"phone":"33 2323 232","imali_account":null,"content":"mj","author_name":"Uyfgr","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-16T22:41:35.000000Z","created_at":"2022-03-16T22:41:35.000000Z","id":211,"attachments":[],"media":[]}', '::1', '2022-03-17 00:41:35', '2022-03-17 00:41:35'),
(199, 'created', 212, 'App\\Ticket', NULL, '{"title":null,"phone":"73 7457 858","imali_account":null,"content":"nzck","author_name":"Ruman","author_email":"naftalivo@gmail.com","category_id":"4","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-16T23:00:16.000000Z","created_at":"2022-03-16T23:00:16.000000Z","id":212,"attachments":[],"media":[]}', '::1', '2022-03-17 01:00:16', '2022-03-17 01:00:16'),
(200, 'created', 213, 'App\\Ticket', NULL, '{"title":null,"phone":"14 7485 855","imali_account":null,"content":"cvcv","author_name":"Romao","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T13:26:52.000000Z","created_at":"2022-03-17T13:26:52.000000Z","id":213,"attachments":[],"media":[]}', '::1', '2022-03-17 15:26:52', '2022-03-17 15:26:52'),
(201, 'created', 214, 'App\\Ticket', NULL, '{"title":null,"phone":"38 3994 993","imali_account":null,"content":"mmsksk","author_name":"Alexandre","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"4","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T14:22:02.000000Z","created_at":"2022-03-17T14:22:02.000000Z","id":214,"attachments":[],"media":[]}', '::1', '2022-03-17 16:22:02', '2022-03-17 16:22:02'),
(202, 'created', 215, 'App\\Ticket', NULL, '{"title":null,"phone":"38 3848 484","imali_account":"39 949494 9","content":"mmdfk","author_name":"Domingos","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"1","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T14:27:14.000000Z","created_at":"2022-03-17T14:27:14.000000Z","id":215,"attachments":[],"media":[]}', '::1', '2022-03-17 16:27:14', '2022-03-17 16:27:14'),
(203, 'created', 216, 'App\\Ticket', NULL, '{"title":null,"phone":"74 8858 585","imali_account":null,"content":"ndnddm","author_name":"Bennedita","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-17T14:31:14.000000Z","created_at":"2022-03-17T14:31:14.000000Z","id":216,"attachments":[],"media":[]}', '::1', '2022-03-17 16:31:14', '2022-03-17 16:31:14'),
(204, 'created', 217, 'App\\Ticket', NULL, '{"title":null,"phone":"74 7474 848","imali_account":null,"content":"msmsms","author_name":"Suraia","author_email":"naftalivo@gmail.com","category_id":"4","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-17T14:34:45.000000Z","created_at":"2022-03-17T14:34:45.000000Z","id":217,"attachments":[],"media":[]}', '::1', '2022-03-17 16:34:45', '2022-03-17 16:34:45'),
(205, 'created', 218, 'App\\Ticket', NULL, '{"title":null,"phone":"64 4747 474","imali_account":null,"content":"msjidi","author_name":"Candida","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T14:35:19.000000Z","created_at":"2022-03-17T14:35:19.000000Z","id":218,"attachments":[],"media":[]}', '::1', '2022-03-17 16:35:19', '2022-03-17 16:35:19'),
(206, 'created', 219, 'App\\Ticket', NULL, '{"title":null,"phone":"75 7557 575","imali_account":null,"content":"grr","author_name":"IVO","author_email":"naftalivo@gmail.com","category_id":"7","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-17T15:07:17.000000Z","created_at":"2022-03-17T15:07:17.000000Z","id":219,"attachments":[],"media":[]}', '::1', '2022-03-17 17:07:17', '2022-03-17 17:07:17'),
(207, 'created', 220, 'App\\Ticket', NULL, '{"title":null,"phone":"63 6644 646","imali_account":null,"content":"jejej","author_name":"Miguel","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"3","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T15:16:05.000000Z","created_at":"2022-03-17T15:16:05.000000Z","id":220,"attachments":[],"media":[]}', '::1', '2022-03-17 17:16:05', '2022-03-17 17:16:05'),
(208, 'created', 221, 'App\\Ticket', NULL, '{"title":null,"phone":"77 3783 883","imali_account":null,"content":"nsjksk","author_name":"Migel","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T15:23:14.000000Z","created_at":"2022-03-17T15:23:14.000000Z","id":221,"attachments":[],"media":[]}', '::1', '2022-03-17 17:23:14', '2022-03-17 17:23:14'),
(209, 'created', 222, 'App\\Ticket', NULL, '{"title":null,"phone":"21 7272 727","imali_account":null,"content":"msksoso","author_name":"Teste Email","author_email":"naftalivo@gmail.com","category_id":"10","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-17T15:25:36.000000Z","created_at":"2022-03-17T15:25:36.000000Z","id":222,"attachments":[],"media":[]}', '::1', '2022-03-17 17:25:36', '2022-03-17 17:25:36'),
(210, 'created', 223, 'App\\Ticket', NULL, '{"title":null,"phone":"83 8884 848","imali_account":null,"content":"gggg","author_name":"Teste Email Ivo","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T11:04:36.000000Z","created_at":"2022-03-18T11:04:36.000000Z","id":223,"attachments":[],"media":[]}', '::1', '2022-03-18 13:04:36', '2022-03-18 13:04:36'),
(211, 'created', 224, 'App\\Ticket', NULL, '{"title":null,"phone":"34 3443 334","imali_account":null,"content":"fgfggfg","author_name":"Denvo","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T11:07:20.000000Z","created_at":"2022-03-18T11:07:20.000000Z","id":224,"attachments":[],"media":[]}', '::1', '2022-03-18 13:07:20', '2022-03-18 13:07:20'),
(212, 'created', 225, 'App\\Ticket', NULL, '{"title":null,"phone":"24 2424 242","imali_account":null,"content":"trgrgrg","author_name":"Noia","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"4","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T11:10:42.000000Z","created_at":"2022-03-18T11:10:42.000000Z","id":225,"attachments":[],"media":[]}', '::1', '2022-03-18 13:10:42', '2022-03-18 13:10:42'),
(213, 'created', 226, 'App\\Ticket', NULL, '{"title":null,"phone":"23 2322 323","imali_account":null,"content":"fffdff","author_name":"Suwa","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T13:00:27.000000Z","created_at":"2022-03-18T13:00:27.000000Z","id":226,"attachments":[],"media":[]}', '::1', '2022-03-18 15:00:27', '2022-03-18 15:00:27'),
(214, 'created', 227, 'App\\Ticket', NULL, '{"title":null,"phone":"23 2322 344","imali_account":null,"content":"fffdffccc","author_name":"SuwaS","author_email":"naftalivo@gmail.com","category_id":"3","tipos_id":"3","gender":"M","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T13:01:17.000000Z","created_at":"2022-03-18T13:01:17.000000Z","id":227,"attachments":[],"media":[]}', '::1', '2022-03-18 15:01:17', '2022-03-18 15:01:17'),
(215, 'created', 228, 'App\\Ticket', NULL, '{"title":null,"phone":"23 8822 344","imali_account":null,"content":"fffdffcccX","author_name":"SuwaSSx","author_email":"naftalivo@gmail.com","category_id":"2","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T13:02:53.000000Z","created_at":"2022-03-18T13:02:53.000000Z","id":228,"attachments":[],"media":[]}', '::1', '2022-03-18 15:02:53', '2022-03-18 15:02:53'),
(216, 'created', 229, 'App\\Ticket', NULL, '{"title":null,"phone":"35 3535 ___","imali_account":null,"content":"ddfd","author_name":"Ivo","author_email":"naftalivo@gmail.com","category_id":"8","tipos_id":"1","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T13:41:06.000000Z","created_at":"2022-03-18T13:41:06.000000Z","id":229,"attachments":[],"media":[]}', '::1', '2022-03-18 15:41:06', '2022-03-18 15:41:06'),
(217, 'created', 230, 'App\\Ticket', NULL, '{"title":null,"phone":"66 4474 777","imali_account":null,"content":"mdmdm","author_name":"Nim","author_email":"naftalivo@gmail.com","category_id":"9","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T13:43:55.000000Z","created_at":"2022-03-18T13:43:55.000000Z","id":230,"attachments":[],"media":[]}', '::1', '2022-03-18 15:43:55', '2022-03-18 15:43:55'),
(218, 'created', 231, 'App\\Ticket', NULL, '{"title":null,"phone":"73 7373 383","imali_account":null,"content":"Teste","author_name":"Ana","author_email":"anaxyz2020@gmail.com","category_id":"8","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T13:46:44.000000Z","created_at":"2022-03-18T13:46:44.000000Z","id":231,"attachments":[],"media":[]}', '::1', '2022-03-18 15:46:44', '2022-03-18 15:46:44'),
(219, 'created', 232, 'App\\Ticket', NULL, '{"title":null,"phone":"27 7247 424","imali_account":null,"content":"msmsm","author_name":"Ramena","author_email":"anaxyz2020@gmail.com","category_id":"7","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T13:58:12.000000Z","created_at":"2022-03-18T13:58:12.000000Z","id":232,"attachments":[],"media":[]}', '::1', '2022-03-18 15:58:12', '2022-03-18 15:58:12'),
(220, 'created', 233, 'App\\Ticket', NULL, '{"title":null,"phone":"88 3838 383","imali_account":null,"content":"mms","author_name":"Maria","author_email":"anaxyz2020@gmail.com","category_id":"8","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:02:18.000000Z","created_at":"2022-03-18T14:02:18.000000Z","id":233,"attachments":[],"media":[]}', '::1', '2022-03-18 16:02:18', '2022-03-18 16:02:18'),
(221, 'created', 234, 'App\\Ticket', NULL, '{"title":null,"phone":"37 3747 488","imali_account":null,"content":"mdmfk","author_name":"Raul","author_email":"anaxyz2020@gmail.com","category_id":"9","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T14:06:30.000000Z","created_at":"2022-03-18T14:06:30.000000Z","id":234,"attachments":[],"media":[]}', '::1', '2022-03-18 16:06:30', '2022-03-18 16:06:30'),
(222, 'created', 235, 'App\\Ticket', NULL, '{"title":null,"phone":"74 7484 848","imali_account":null,"content":"mdmdk","author_name":"Raymundo","author_email":"anaxyz2020@gmail.com","category_id":"3","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:11:04.000000Z","created_at":"2022-03-18T14:11:04.000000Z","id":235,"attachments":[],"media":[]}', '::1', '2022-03-18 16:11:04', '2022-03-18 16:11:04'),
(223, 'created', 236, 'App\\Ticket', NULL, '{"title":null,"phone":"84 8464 949","imali_account":null,"content":"msfksfs","author_name":"Mia","author_email":"anaxyz2020@gmail.com","category_id":"2","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:15:32.000000Z","created_at":"2022-03-18T14:15:32.000000Z","id":236,"attachments":[],"media":[]}', '::1', '2022-03-18 16:15:32', '2022-03-18 16:15:32'),
(224, 'created', 237, 'App\\Ticket', NULL, '{"title":null,"phone":"73 5735 358","imali_account":null,"content":"msfksfsfk","author_name":"Amanda","author_email":"anaxyz2020@gmail.com","category_id":"8","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:20:35.000000Z","created_at":"2022-03-18T14:20:35.000000Z","id":237,"attachments":[],"media":[]}', '::1', '2022-03-18 16:20:35', '2022-03-18 16:20:35'),
(225, 'created', 238, 'App\\Ticket', NULL, '{"title":null,"phone":"84 8484 848","imali_account":null,"content":"jdasjaf","author_name":"Amaral Costa","author_email":"anaxyz2020@gmail.com","category_id":"8","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:25:28.000000Z","created_at":"2022-03-18T14:25:28.000000Z","id":238,"attachments":[],"media":[]}', '::1', '2022-03-18 16:25:28', '2022-03-18 16:25:28'),
(226, 'created', 239, 'App\\Ticket', NULL, '{"title":null,"phone":"77 7575 758","imali_account":null,"content":"admadkadk","author_name":"Medina Karnokova","author_email":"anaxyz2020@gmail.com","category_id":"3","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:30:26.000000Z","created_at":"2022-03-18T14:30:26.000000Z","id":239,"attachments":[],"media":[]}', '::1', '2022-03-18 16:30:26', '2022-03-18 16:30:26'),
(227, 'created', 240, 'App\\Ticket', NULL, '{"title":null,"phone":"77 3733 838","imali_account":null,"content":"nzada","author_name":"Sufura","author_email":"anaxyz2020@gmail.com","category_id":"3","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:41:14.000000Z","created_at":"2022-03-18T14:41:14.000000Z","id":240,"attachments":[],"media":[]}', '::1', '2022-03-18 16:41:14', '2022-03-18 16:41:14'),
(228, 'created', 241, 'App\\Ticket', NULL, '{"title":null,"phone":"74 7348 348","imali_account":null,"content":"sfsfsf","author_name":"Solange","author_email":"anaxyz2020@gmail.com","category_id":"7","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T14:58:11.000000Z","created_at":"2022-03-18T14:58:11.000000Z","id":241,"attachments":[],"media":[]}', '::1', '2022-03-18 16:58:11', '2022-03-18 16:58:11'),
(229, 'created', 242, 'App\\Ticket', NULL, '{"title":null,"phone":"83 4834 344","imali_account":null,"content":"sfsfsfs","author_name":"Dirce","author_email":"anaxyz2020@gmail.com","category_id":"8","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":2,"updated_at":"2022-03-18T15:06:46.000000Z","created_at":"2022-03-18T15:06:46.000000Z","id":242,"attachments":[],"media":[]}', '::1', '2022-03-18 17:06:47', '2022-03-18 17:06:47'),
(230, 'created', 243, 'App\\Ticket', NULL, '{"title":null,"phone":"24 2424 242","imali_account":null,"content":"dgdgdg","author_name":"Carina","author_email":"anaxyz2020@gmail.com","category_id":"9","tipos_id":"2","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T15:08:52.000000Z","created_at":"2022-03-18T15:08:52.000000Z","id":243,"attachments":[],"media":[]}', '::1', '2022-03-18 17:08:52', '2022-03-18 17:08:52'),
(231, 'created', 244, 'App\\Ticket', NULL, '{"title":null,"phone":"28 3823 283","imali_account":null,"content":"xvv","author_name":"Adan","author_email":"anaxyz2020@gmail.com","category_id":"9","tipos_id":"3","gender":"F","email_status":"OPEN","status_id":1,"priority_id":1,"departments_id":6,"updated_at":"2022-03-18T15:27:38.000000Z","created_at":"2022-03-18T15:27:38.000000Z","id":244,"attachments":[],"media":[]}', '::1', '2022-03-18 17:27:38', '2022-03-18 17:27:38');
/*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.categories
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.categories: ~9 rows (approximately)
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` (`id`, `name`, `color`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Outro', '#d1cbce', '2022-01-17 07:10:27', '2022-02-02 16:17:10', NULL),
(2, 'Carregamento', '#f2ba2a', '2022-01-17 07:10:27', '2022-01-18 07:25:36', NULL),
(3, 'Transferência', '#f0e500', '2022-01-17 07:10:27', '2022-01-18 07:25:22', NULL),
(4, 'Pagamentos', '#0ce62e', '2022-01-17 08:19:46', '2022-01-17 14:15:07', NULL),
(5, 'Recargas', '#00bae3', '2022-01-17 12:47:34', '2022-01-21 12:24:39', NULL),
(7, 'Pacotes de TV', '#ff00f5', '2022-02-04 17:23:39', '2022-02-04 17:23:39', NULL),
(8, 'Entidade e Referencia', '#292323', '2022-02-04 17:24:21', '2022-02-04 17:24:21', NULL),
(9, 'Layout', '#c4a3a3', '2022-02-09 12:02:08', '2022-02-09 12:02:08', NULL),
(10, 'Banners', '#e67373', '2022-02-09 12:02:19', '2022-02-09 12:02:19', NULL),
(11, 'Posts nas redes sociais', '#5c97f0', '2022-02-09 12:02:40', '2022-02-09 12:02:40', NULL);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.category_department
CREATE TABLE IF NOT EXISTS `category_department` (
`department_id` int(10) unsigned NOT NULL,
`category_id` int(10) unsigned NOT NULL,
KEY `department_id` (`department_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Dumping data for table helpdesksupport.category_department: ~24 rows (approximately)
/*!40000 ALTER TABLE `category_department` DISABLE KEYS */;
INSERT INTO `category_department` (`department_id`, `category_id`) VALUES
(1, 1),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 7),
(2, 8),
(3, 1),
(4, 2),
(4, 3),
(4, 4),
(4, 5),
(4, 7),
(4, 8),
(5, 1),
(6, 9),
(6, 10),
(6, 11),
(9, 9),
(10, 9),
(11, 9),
(12, 2),
(12, 3),
(12, 4);
/*!40000 ALTER TABLE `category_department` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.comments
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`departments_id` bigint(20) unsigned DEFAULT NULL,
`comment_text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`ticket_id` int(10) unsigned DEFAULT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ticket_fk_583774` (`ticket_id`),
KEY `user_fk_583777` (`user_id`),
CONSTRAINT `ticket_fk_583774` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`),
CONSTRAINT `user_fk_583777` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.comments: ~19 rows (approximately)
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
INSERT INTO `comments` (`id`, `author_name`, `author_email`, `departments_id`, `comment_text`, `created_at`, `updated_at`, `deleted_at`, `ticket_id`, `user_id`) VALUES
(87, 'Admin', 'admin@admin.com', 1, 'Ok', '2022-01-30 19:44:21', '2022-01-30 19:44:21', NULL, 68, 1),
(88, 'Admin', 'admin@admin.com', 1, 'Esta certo', '2022-02-02 00:02:21', '2022-02-02 00:02:21', NULL, 68, 1),
(89, 'Admin', 'admin@admin.com', 1, 'Ticket Recebido', '2022-02-02 00:02:57', '2022-02-02 00:02:57', NULL, 96, 1),
(90, 'Adao', 'adao@gmail.com', 1, 'Ticket tratado', '2022-02-02 00:10:44', '2022-02-02 12:10:21', NULL, 96, 2),
(91, 'Admin', 'admin@admin.com', 1, 'Recebido', '2022-02-02 11:41:01', '2022-02-02 11:41:01', NULL, 73, 1),
(92, 'Admin', 'admin@admin.com', 1, 'Olá', '2022-02-03 21:37:28', '2022-02-10 15:37:07', NULL, 98, 1),
(93, 'Admin', 'admin@admin.com', 1, 'Okk', '2022-02-03 21:45:12', '2022-02-03 21:45:12', NULL, 98, 1),
(94, 'Admin', 'admin@admin.com', 1, 'Football', '2022-02-03 22:33:46', '2022-02-03 22:33:46', NULL, 95, 1),
(95, 'Admin', 'admin@admin.com', 1, 'Goal', '2022-02-03 22:41:40', '2022-02-03 22:41:40', NULL, 95, 1),
(96, 'Admin', 'admin@admin.com', 1, 'What a goal!', '2022-02-03 22:42:43', '2022-02-03 22:42:43', NULL, 95, 1),
(97, 'Admin', 'admin@admin.com', 1, 'Teste...', '2022-02-04 11:18:15', '2022-02-04 11:18:15', NULL, 98, 1),
(98, 'Admin', 'admin@admin.com', 1, 'Ehhh', '2022-02-06 23:07:22', '2022-02-06 23:07:22', NULL, 98, 1),
(99, 'Admin', 'admin@admin.com', 1, 'Ticket #98', '2022-02-07 12:04:10', '2022-02-07 12:04:10', NULL, 98, 1),
(112, 'Admin', 'admin@admin.com', 1, 'Comment Test', '2022-02-09 15:35:43', '2022-02-09 15:35:43', NULL, 136, 1),
(113, 'Admin', 'admin@admin.com', 1, 'QS', '2022-02-09 16:26:35', '2022-02-10 11:38:03', '2022-02-10 11:38:03', 136, 1),
(114, 'Admin', 'admin@admin.com', 1, 'Teste..', '2022-02-10 11:16:57', '2022-02-10 11:17:24', '2022-02-10 11:17:24', 102, 1),
(115, 'Admin', 'admin@admin.com', 1, 'Q', '2022-02-10 11:21:51', '2022-02-10 11:22:03', '2022-02-10 11:22:03', 102, 1),
(116, 'Admin', 'admin@admin.com', 1, 'W', '2022-02-10 11:25:33', '2022-02-10 11:25:47', '2022-02-10 11:25:47', 136, 1),
(117, 'Admin', 'admin@admin.com', 1, 'Email Sent..#', '2022-02-10 11:34:45', '2022-02-10 11:38:03', '2022-02-10 11:38:03', 136, 1),
(118, 'Admin', 'admin@admin.com', 1, '3#', '2022-02-10 11:37:44', '2022-02-10 11:38:03', '2022-02-10 11:38:03', 136, 1);
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.departments
CREATE TABLE IF NOT EXISTS `departments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.departments: ~9 rows (approximately)
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Sem Departamento', '2022-01-26 09:00:53', '2022-01-26 09:00:53', NULL),
(2, 'Desenvolvimento', '2022-01-26 09:01:00', '2022-01-26 09:01:00', NULL),
(3, 'Parcerias', '2022-01-26 09:01:21', '2022-01-26 09:01:21', NULL),
(4, 'Assistência Técnica', '2022-01-26 12:31:26', '2022-02-02 11:56:10', NULL),
(5, 'Administração', '2022-01-26 12:37:36', '2022-01-26 12:37:36', NULL),
(6, 'Design', '2022-02-02 11:53:47', '2022-02-02 11:53:47', NULL),
(9, 'UX/UI', '2022-02-04 16:22:20', '2022-02-04 16:24:14', NULL),
(10, 'CSS', '2022-02-04 16:32:55', '2022-02-04 16:37:01', NULL),
(11, 'JS', '2022-02-04 16:37:37', '2022-02-04 16:37:37', NULL),
(12, 'WordPoint', '2022-02-04 16:44:06', '2022-02-04 16:44:06', NULL);
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.dep_categoties
CREATE TABLE IF NOT EXISTS `dep_categoties` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`department_id` bigint(20) unsigned DEFAULT NULL,
`category_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.dep_categoties: ~15 rows (approximately)
/*!40000 ALTER TABLE `dep_categoties` DISABLE KEYS */;
INSERT INTO `dep_categoties` (`id`, `department_id`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 2, 4, '2022-01-31 10:53:50', '2022-01-31 10:53:50'),
(6, 3, 3, '2022-01-31 22:46:47', '2022-01-31 22:46:47'),
(8, 5, 1, '2022-01-31 23:00:42', '2022-01-31 23:00:42'),
(9, 5, 2, '2022-01-31 23:00:42', '2022-01-31 23:00:42'),
(10, 5, 3, '2022-01-31 23:00:42', '2022-01-31 23:00:42'),
(11, 5, 4, '2022-01-31 23:00:42', '2022-01-31 23:00:42'),
(12, 5, 5, '2022-01-31 23:00:42', '2022-01-31 23:00:42'),
(13, 4, 1, '2022-01-31 23:01:43', '2022-01-31 23:01:43'),
(14, 4, 2, '2022-01-31 23:01:43', '2022-01-31 23:01:43'),
(15, 4, 3, '2022-01-31 23:01:43', '2022-01-31 23:01:43'),
(16, 4, 4, '2022-01-31 23:01:43', '2022-01-31 23:01:43'),
(17, 4, 5, '2022-01-31 23:01:43', '2022-01-31 23:01:43'),
(18, NULL, 4, '2022-02-04 16:37:37', '2022-02-04 16:37:37'),
(19, NULL, 5, '2022-02-04 16:37:37', '2022-02-04 16:37:37'),
(20, 12, 2, '2022-02-04 16:44:06', '2022-02-04 16:44:06'),
(21, 12, 3, '2022-02-04 16:44:06', '2022-02-04 16:44:06'),
(22, 12, 4, '2022-02-04 16:44:06', '2022-02-04 16:44:06');
/*!40000 ALTER TABLE `dep_categoties` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.emails
CREATE TABLE IF NOT EXISTS `emails` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`id_ticket` int(11) NOT NULL,
`author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`comment_text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.emails: ~9 rows (approximately)
/*!40000 ALTER TABLE `emails` DISABLE KEYS */;
INSERT INTO `emails` (`id`, `name`, `author_name`, `subject`, `id_ticket`, `author_email`, `user_id`, `comment_text`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', 'Teste Ticket', 'Sem assunto', 97, 'naftalivo@gmail.com', 1, 'Ola.. A sua duvida ja foi resolvida.', '2022-02-02 11:33:18', '2022-02-02 11:33:18', NULL),
(2, 'Admin', 'Teste Ticket', 'Recargas', 97, 'naftalivo@gmail.com', 1, 'Ola a sua duvida ja esta resolvida..', '2022-02-02 11:35:04', '2022-02-02 11:35:04', NULL),
(3, 'Admin', 'Teste Ticket', 'Recargas', 97, 'naftalivo@gmail.com', 1, 'oo', '2022-02-02 11:38:11', '2022-02-02 11:38:11', NULL),
(4, 'Admin', 'Teste Ticket', 'Recargas', 97, 'naftalivo@gmail.com', 1, 'rtg', '2022-02-02 11:38:59', '2022-02-02 11:38:59', NULL),
(5, 'Admin', 'Ivo Shazia', 'Pagamentos', 73, 'anaxyz2020@gmail.com', 1, 'Resolvido..', '2022-02-02 11:41:41', '2022-02-07 12:43:41', NULL),
(6, 'Ivo', 'Teste Ticket', 'Recargas', 97, 'naftalivo@gmail.com', 5, 'Ok', '2022-02-02 11:59:43', '2022-02-02 11:59:43', NULL),
(7, 'Admin', 'Teste Ticket', 'Recargas', 97, 'naftalivo@gmail.com', 1, 'Problema resolvido...', '2022-02-02 14:13:04', '2022-02-02 14:13:04', NULL),
(8, 'Admin', 'Ivo Shazia', 'Transferência', 80, 'naftalivo@gmail.com', 1, 'Resolvido...', '2022-02-03 13:51:01', '2022-02-03 13:51:01', NULL),
(9, 'Admin', 'Ivo Shazia', 'Transferência', 80, 'naftalivo@gmail.com', 1, 'Ticket Fechado..', '2022-02-03 13:53:34', '2022-02-03 13:53:34', NULL),
(10, 'Admin', 'Dirce Matos', 'Carregamento', 136, 'anaxyz2020@gmail.com', 1, 'Teste... @#', '2022-02-09 16:29:12', '2022-02-09 16:29:12', NULL),
(11, 'Admin', 'Dirce Matos', 'Carregamento', 136, 'anaxyz2020@gmail.com', 1, 'Ticket Resolvido', '2022-02-10 12:21:08', '2022-02-10 12:21:08', NULL),
(12, 'Admin', 'Dirce Matos', 'Carregamento', 136, 'anaxyz2020@gmail.com', 1, 'Ok', '2022-02-10 12:23:43', '2022-02-10 12:23:43', NULL);
/*!40000 ALTER TABLE `emails` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.email_clients
CREATE TABLE IF NOT EXISTS `email_clients` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`id_ticket` int(11) DEFAULT NULL,
`author_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`comment_text` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.email_clients: ~62 rows (approximately)
/*!40000 ALTER TABLE `email_clients` DISABLE KEYS */;
INSERT INTO `email_clients` (`id`, `name`, `author_name`, `subject`, `id_ticket`, `author_email`, `user_id`, `comment_text`, `created_at`, `updated_at`, `deleted_at`) VALUES
(11, 'Dirce Matos', 'Dirce Matos', 'Transferência', 136, 'anaxyz2020@gmail.com', NULL, NULL, '2022-02-08 18:18:11', '2022-02-08 18:18:11', NULL),
(12, 'Ilda', 'Ilda', 'Pagamentos', 137, 'naftalivo@gmail.com', NULL, NULL, '2022-02-08 22:04:27', '2022-02-08 22:04:27', NULL),
(13, 'Luna', 'Luna', 'Transferência', 139, 'naftalivo@gmail.com', NULL, NULL, '2022-02-11 17:10:29', '2022-02-11 17:10:29', NULL),
(14, 'Reah', 'Reah', 'Pacotes de TV', 140, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 16:53:44', '2022-02-15 16:53:44', NULL),
(15, 'Sebasthian', 'Sebasthian', 'Recargas', 141, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 16:56:19', '2022-02-15 16:56:19', NULL),
(16, 'Nubia', 'Nubia', 'Carregamento', 142, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 17:05:35', '2022-02-15 17:05:35', NULL),
(17, 'Swagger', 'Swagger', 'Pacotes de TV', 143, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 17:14:12', '2022-02-15 17:14:12', NULL),
(18, 'Ana', 'Ana', 'Pacotes de TV', 144, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 17:18:06', '2022-02-15 17:18:06', NULL),
(19, 'Teste', 'Teste', 'Entidade e Referencia', 145, 'naftalivo@gmail.com', NULL, NULL, '2022-02-15 17:35:33', '2022-02-15 17:35:33', NULL),
(20, 'Ama', 'Ama', 'Pacotes de TV', 152, 'ana@hmama.com', NULL, NULL, '2022-03-10 17:03:36', '2022-03-10 17:03:36', NULL),
(21, 'W', 'W', 'Banners', 154, 'W@add.com', NULL, NULL, '2022-03-10 17:44:03', '2022-03-10 17:44:03', NULL),
(22, 'A', 'A', 'Pacotes de TV', 155, 'naftalivo@gmail.com', NULL, NULL, '2022-03-10 17:51:55', '2022-03-10 17:51:55', NULL),
(23, 'Ivo', 'Ivo', 'Banners', 160, 'naftalivo@gmail.com', NULL, NULL, '2022-03-11 15:57:51', '2022-03-11 15:57:51', NULL),
(24, 'Q', 'Q', 'Posts nas redes sociais', 161, 'naftalivo@gmail.com', NULL, NULL, '2022-03-11 16:41:16', '2022-03-11 16:41:16', NULL),
(25, 'Ken', 'Ken', 'Pagamentos', 162, 'naftalivo@gmail.com', NULL, NULL, '2022-03-11 16:52:10', '2022-03-11 16:52:10', NULL),
(26, 'Muhammad Machado', 'Muhammad Machado', 'Posts nas redes sociais', 163, 'muhmachado90@gmail.com', NULL, NULL, '2022-03-11 17:00:36', '2022-03-11 17:00:36', NULL),
(27, 'Miguel Macamo', 'Miguel Macamo', 'Banners', 164, 'miguelmacamo9@gmail.com', NULL, NULL, '2022-03-11 17:25:58', '2022-03-11 17:25:58', NULL),
(28, 'Antonia Cumbe', 'Antonia Cumbe', 'Layout', 165, 'naftalivo@gmail.com', NULL, NULL, '2022-03-14 16:49:28', '2022-03-14 16:49:28', NULL),
(29, 'Mireal', 'Mireal', 'Layout', 166, 'naftalivo@gmail.com', NULL, NULL, '2022-03-14 16:51:27', '2022-03-14 16:51:27', NULL),
(30, 'Suria', 'Suria', 'Layout', 167, 'naftalivo@gmail.com', NULL, NULL, '2022-03-14 18:22:38', '2022-03-14 18:22:38', NULL),
(31, 'A', 'A', 'Carregamento', 168, 'naftalivo@gmail.com', NULL, NULL, '2022-03-14 18:24:01', '2022-03-14 18:24:01', NULL),
(32, 'Teste Sync', 'Teste Sync', 'Banners', 201, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 18:42:12', '2022-03-16 18:42:12', NULL),
(33, 'Nadia Narkova', 'Nadia Narkova', 'Pagamentos', 202, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 18:43:35', '2022-03-16 18:43:35', NULL),
(34, 'Amarilia', 'Amarilia', 'Layout', 203, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 19:14:02', '2022-03-16 19:14:02', NULL),
(35, 'Yu', 'Yu', 'Transferência', 204, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 19:18:04', '2022-03-16 19:18:04', NULL),
(36, 'Ted', 'Ted', 'Layout', 205, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 21:14:46', '2022-03-16 21:14:46', NULL),
(37, 'TedX', 'TedX', 'Carregamento', 206, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 21:16:49', '2022-03-16 21:16:49', NULL),
(38, 'Ola', 'Ola', 'Layout', 207, 'naftalivo@gmail.com', NULL, NULL, '2022-03-16 21:34:52', '2022-03-16 21:34:52', NULL),
(39, 'Ed', 'Ed', 'Banners', 208, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 00:32:34', '2022-03-17 00:32:34', NULL),
(40, 'Samira', 'Samira', 'Transferência', 209, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 00:34:45', '2022-03-17 00:34:45', NULL),
(41, 'Lidia', 'Lidia', 'Pacotes de TV', 210, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 00:37:02', '2022-03-17 00:37:02', NULL),
(42, 'Uyfgr', 'Uyfgr', 'Layout', 211, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 00:41:35', '2022-03-17 00:41:35', NULL),
(43, 'Ruman', 'Ruman', 'Pagamentos', 212, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 01:00:16', '2022-03-17 01:00:16', NULL),
(44, 'Romao', 'Romao', 'Layout', 213, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 15:26:53', '2022-03-17 15:26:53', NULL),
(45, 'Alexandre', 'Alexandre', 'Banners', 214, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 16:22:02', '2022-03-17 16:22:02', NULL),
(46, 'Domingos', 'Domingos', 'Banners', 215, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 16:27:14', '2022-03-17 16:27:14', NULL),
(47, 'Bennedita', 'Bennedita', 'Transferência', 216, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 16:31:14', '2022-03-17 16:31:14', NULL),
(48, 'Suraia', 'Suraia', 'Pagamentos', 217, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 16:34:45', '2022-03-17 16:34:45', NULL),
(49, 'Candida', 'Candida', 'Banners', 218, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 16:35:20', '2022-03-17 16:35:20', NULL),
(50, 'IVO', 'IVO', 'Pacotes de TV', 219, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 17:07:17', '2022-03-17 17:07:17', NULL),
(51, 'Miguel', 'Miguel', 'Banners', 220, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 17:16:05', '2022-03-17 17:16:05', NULL),
(52, 'Migel', 'Migel', 'Banners', 221, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 17:23:15', '2022-03-17 17:23:15', NULL),
(53, 'Teste Email', 'Teste Email', 'Banners', 222, 'naftalivo@gmail.com', NULL, NULL, '2022-03-17 17:25:36', '2022-03-17 17:25:36', NULL),
(54, 'Teste Email Ivo', 'Teste Email Ivo', 'Transferência', 223, 'naftalivo@gmail.com', NULL, NULL, '2022-03-18 13:04:37', '2022-03-18 13:04:37', NULL),
(55, 'Denvo', 'Denvo', 'Layout', 224, 'naftalivo@gmail.com', NULL, NULL, '2022-03-18 13:07:20', '2022-03-18 13:07:20', NULL),
(56, 'Noia', 'Noia', 'Entidade e Referencia', 225, 'naftalivo@gmail.com', NULL, NULL, '2022-03-18 13:10:42', '2022-03-18 13:10:42', NULL),
(57, 'Ivo', 'Ivo', 'Entidade e Referencia', 229, 'naftalivo@gmail.com', NULL, NULL, '2022-03-18 15:41:06', '2022-03-18 15:41:06', NULL),
(58, 'Nim', 'Nim', 'Layout', 230, 'naftalivo@gmail.com', NULL, NULL, '2022-03-18 15:43:55', '2022-03-18 15:43:55', NULL),
(59, 'Ana', 'Ana', 'Entidade e Referencia', 231, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 15:46:44', '2022-03-18 15:46:44', NULL),
(60, 'Ramena', 'Ramena', 'Pacotes de TV', 232, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 15:58:12', '2022-03-18 15:58:12', NULL),
(61, 'Maria', 'Maria', 'Entidade e Referencia', 233, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:02:18', '2022-03-18 16:02:18', NULL),
(62, 'Raul', 'Raul', 'Layout', 234, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:06:30', '2022-03-18 16:06:30', NULL),
(63, 'Raymundo', 'Raymundo', 'Transferência', 235, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:11:04', '2022-03-18 16:11:04', NULL),
(64, 'Mia', 'Mia', 'Carregamento', 236, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:15:32', '2022-03-18 16:15:32', NULL),
(65, 'Amanda', 'Amanda', 'Entidade e Referencia', 237, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:20:35', '2022-03-18 16:20:35', NULL),
(66, 'Amaral Costa', 'Amaral Costa', 'Entidade e Referencia', 238, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:25:28', '2022-03-18 16:25:28', NULL),
(67, 'Medina Karnokova', 'Medina Karnokova', 'Transferência', 239, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:30:26', '2022-03-18 16:30:26', NULL),
(68, 'Sufura', 'Sufura', 'Transferência', 240, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:41:14', '2022-03-18 16:41:14', NULL),
(69, 'Solange', 'Solange', 'Pacotes de TV', 241, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 16:58:11', '2022-03-18 16:58:11', NULL),
(70, 'Dirce', 'Dirce', 'Entidade e Referencia', 242, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 17:06:47', '2022-03-18 17:06:47', NULL),
(71, 'Carina', 'Carina', 'Layout', 243, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 17:08:52', '2022-03-18 17:08:52', NULL),
(72, 'Adan', 'Adan', 'Layout', 244, 'anaxyz2020@gmail.com', NULL, NULL, '2022-03-18 17:27:38', '2022-03-18 17:27:38', NULL);
/*!40000 ALTER TABLE `email_clients` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.failed_jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.jobs
CREATE TABLE IF NOT EXISTS `jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.jobs: ~0 rows (approximately)
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.media
CREATE TABLE IF NOT EXISTS `media` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
`uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`size` bigint(20) unsigned NOT NULL,
`manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
`custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
`responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
`order_column` int(10) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.media: ~0 rows (approximately)
/*!40000 ALTER TABLE `media` DISABLE KEYS */;
/*!40000 ALTER TABLE `media` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.migrations: ~26 rows (approximately)
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_09_000000_create_departments_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_11_09_000001_create_permissions_table', 1),
(9, '2019_11_09_000002_create_roles_table', 1),
(10, '2019_11_09_000003_create_users_table', 1),
(11, '2019_11_09_000004_create_statuses_table', 1),
(12, '2019_11_09_000005_create_priorities_table', 1),
(13, '2019_11_09_000006_create_categories_table', 1),
(14, '2019_11_09_000007_create_tickets_table', 1),
(15, '2019_11_09_000008_create_comments_table', 1),
(16, '2019_11_09_000009_create_permission_role_pivot_table', 1),
(17, '2019_11_09_000010_create_role_user_pivot_table', 1),
(18, '2019_11_09_000011_add_relationship_fields_to_tickets_table', 1),
(19, '2019_11_09_000012_add_relationship_fields_to_comments_table', 1),
(20, '2019_11_09_000013_create_audit_logs_table', 1),
(21, '2019_11_09_000014_create_user_departs_table', 1),
(22, '2019_11_10_000001_create_media_table', 1),
(23, '2022_01_24_132751_create_emails_table', 1),
(24, '2022_01_31_104703_create_dep_categoties_table', 1),
(25, '2022_01_31_141835_create_ticket_histories_table', 1),
(26, '2022_01_31_141906_create_ticket_views_table', 1),
(27, '2022_02_08_143505_create_email_clients_table', 2),
(29, '2014_10_10_000000_create_tipos_table', 3),
(30, '2019_08_19_000000_create_failed_jobs_table', 4),
(31, '2022_03_16_183654_create_jobs_table', 4);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.oauth_access_tokens
CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`client_id` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.oauth_access_tokens: ~0 rows (approximately)
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.oauth_auth_codes
CREATE TABLE IF NOT EXISTS `oauth_auth_codes` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`client_id` bigint(20) unsigned NOT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.oauth_auth_codes: ~0 rows (approximately)
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.oauth_clients
CREATE TABLE IF NOT EXISTS `oauth_clients` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
`personal_access_client` tinyint(1) NOT NULL,
`password_client` tinyint(1) NOT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.oauth_clients: ~0 rows (approximately)
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.oauth_personal_access_clients
CREATE TABLE IF NOT EXISTS `oauth_personal_access_clients` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`client_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.oauth_personal_access_clients: ~0 rows (approximately)
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.oauth_refresh_tokens
CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.oauth_refresh_tokens: ~0 rows (approximately)
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.password_resets: ~1 rows (approximately)
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('naftalivo@gmail.com', '$2y$10$DJQxksaa3s72oQ8.o8.Oe.l0wZtYrp3wCMQSx.zQZH3FqFTxmrwUe', '2022-02-10 15:58:17');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.permissions: ~54 rows (approximately)
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'user_management_access', NULL, NULL, NULL),
(2, 'permission_create', NULL, NULL, NULL),
(3, 'permission_edit', NULL, NULL, NULL),
(4, 'permission_show', NULL, NULL, NULL),
(5, 'permission_delete', NULL, NULL, NULL),
(6, 'permission_access', NULL, NULL, NULL),
(7, 'role_create', NULL, NULL, NULL),
(8, 'role_edit', NULL, NULL, NULL),
(9, 'role_show', NULL, NULL, NULL),
(10, 'role_delete', NULL, NULL, NULL),
(11, 'role_access', NULL, NULL, NULL),
(12, 'user_create', NULL, NULL, NULL),
(13, 'user_edit', NULL, NULL, NULL),
(14, 'user_show', NULL, NULL, NULL),
(15, 'user_delete', NULL, NULL, NULL),
(16, 'user_access', NULL, NULL, NULL),
(17, 'status_create', NULL, NULL, NULL),
(18, 'status_edit', NULL, NULL, NULL),
(19, 'status_show', NULL, NULL, NULL),
(20, 'status_delete', NULL, NULL, NULL),
(21, 'status_access', NULL, NULL, NULL),
(22, 'priority_create', NULL, NULL, NULL),
(23, 'priority_edit', NULL, NULL, NULL),
(24, 'priority_show', NULL, NULL, NULL),
(25, 'priority_delete', NULL, NULL, NULL),
(26, 'priority_access', NULL, NULL, NULL),
(27, 'category_create', NULL, NULL, NULL),
(28, 'category_edit', NULL, NULL, NULL),
(29, 'category_show', NULL, NULL, NULL),
(30, 'category_delete', NULL, NULL, NULL),
(31, 'category_access', NULL, NULL, NULL),
(32, 'ticket_create', NULL, NULL, NULL),
(33, 'ticket_edit', NULL, NULL, NULL),
(34, 'ticket_show', NULL, NULL, NULL),
(35, 'ticket_delete', NULL, NULL, NULL),
(36, 'ticket_access', NULL, NULL, NULL),
(37, 'comment_create', NULL, NULL, NULL),
(38, 'comment_edit', NULL, NULL, NULL),
(39, 'comment_show', NULL, NULL, NULL),
(40, 'comment_delete', NULL, NULL, NULL),
(41, 'comment_access', NULL, NULL, NULL),
(42, 'audit_log_show', NULL, NULL, NULL),
(43, 'audit_log_access', NULL, NULL, NULL),
(44, 'dashboard_access', NULL, NULL, NULL),
(45, 'department_access', '2022-01-26 07:50:18', '2022-01-26 07:50:18', NULL),
(46, 'department_delete', '2022-01-26 07:51:07', '2022-01-26 07:51:07', NULL),
(47, 'department_show', '2022-01-26 07:51:17', '2022-01-26 07:51:17', NULL),
(48, 'department_edit', '2022-01-26 07:51:27', '2022-01-26 07:51:27', NULL),
(49, 'department_create', '2022-01-26 07:51:38', '2022-01-26 07:51:38', NULL),
(50, 'department_category_create', '2022-01-31 14:24:44', '2022-01-31 14:24:44', NULL),
(51, 'department_category_edit', '2022-01-31 14:25:01', '2022-01-31 14:25:01', NULL),
(52, 'department_category_show', '2022-01-31 14:25:17', '2022-01-31 14:25:17', NULL),
(53, 'department_category_delete', '2022-01-31 14:25:33', '2022-01-31 14:25:33', NULL),
(54, 'department_category_access', '2022-01-31 14:25:48', '2022-01-31 14:25:48', NULL),
(55, 'ticket_archived_access', '2022-02-02 17:19:07', '2022-02-02 17:19:07', NULL),
(56, 'ticket_archived_delete', '2022-02-02 17:19:26', '2022-02-02 17:19:26', NULL),
(57, 'ticket_archived_show', '2022-02-02 17:19:45', '2022-02-02 17:19:45', NULL),
(58, 'ticket_archived_edit', '2022-02-02 17:20:03', '2022-02-02 17:20:03', NULL),
(59, 'ticket_archived_create', '2022-02-02 17:20:23', '2022-02-02 17:20:23', NULL),
(60, 'email_create', '2022-02-07 12:14:33', '2022-02-07 12:14:33', NULL),
(61, 'email_edit', '2022-02-07 12:14:46', '2022-02-07 12:14:46', NULL),
(62, 'email_show', '2022-02-07 12:14:55', '2022-02-07 12:14:55', NULL),
(63, 'email_delete', '2022-02-07 12:15:05', '2022-02-07 12:15:05', NULL),
(64, 'email_access', '2022-02-07 12:15:20', '2022-02-07 12:15:20', NULL);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.permission_role
CREATE TABLE IF NOT EXISTS `permission_role` (
`role_id` int(10) unsigned NOT NULL,
`permission_id` int(10) unsigned NOT NULL,
KEY `role_id_fk_583549` (`role_id`),
KEY `permission_id_fk_583549` (`permission_id`),
CONSTRAINT `permission_id_fk_583549` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `role_id_fk_583549` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.permission_role: ~237 rows (approximately)
/*!40000 ALTER TABLE `permission_role` DISABLE KEYS */;
INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(2, 33),
(2, 34),
(2, 36),
(3, 32),
(3, 33),
(3, 34),
(3, 35),
(3, 36),
(3, 37),
(3, 38),
(3, 39),
(3, 40),
(3, 41),
(3, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(4, 32),
(4, 33),
(4, 34),
(4, 35),
(4, 36),
(4, 37),
(4, 38),
(4, 39),
(4, 40),
(4, 41),
(4, 44),
(1, 54),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(2, 33),
(2, 34),
(2, 36),
(3, 32),
(3, 33),
(3, 34),
(3, 35),
(3, 36),
(3, 37),
(3, 38),
(3, 39),
(3, 40),
(3, 41),
(3, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(4, 32),
(4, 33),
(4, 34),
(4, 35),
(4, 36),
(4, 37),
(4, 38),
(4, 39),
(4, 40),
(4, 41),
(4, 44),
(1, 54),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(2, 33),
(2, 34),
(2, 36),
(3, 32),
(3, 33),
(3, 34),
(3, 35),
(3, 36),
(3, 37),
(3, 38),
(3, 39),
(3, 40),
(3, 41),
(3, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(4, 32),
(4, 33),
(4, 34),
(4, 35),
(4, 36),
(4, 37),
(4, 38),
(4, 39),
(4, 40),
(4, 41),
(4, 44),
(1, 54),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(5, 3),
(5, 4),
(1, 64),
(1, 61),
(1, 62),
(1, 63);
/*!40000 ALTER TABLE `permission_role` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.priorities
CREATE TABLE IF NOT EXISTS `priorities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`time` int(11) DEFAULT NULL,
`color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.priorities: ~4 rows (approximately)
/*!40000 ALTER TABLE `priorities` DISABLE KEYS */;
INSERT INTO `priorities` (`id`, `name`, `time`, `color`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Baixa', 24, '#20b426', '2022-01-17 07:10:27', '2022-01-18 07:00:14', NULL),
(2, 'Média', 8, '#ffc107', '2022-01-17 07:10:27', '2022-02-02 11:53:16', NULL),
(3, 'Alta', 2, '#ff0000', '2022-01-17 07:10:27', '2022-01-24 16:54:02', NULL),
(4, 'Urgente', 1, '#823030', '2022-01-25 10:41:15', '2022-01-25 10:41:36', '2022-01-25 10:41:36');
/*!40000 ALTER TABLE `priorities` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.roles
CREATE TABLE IF NOT EXISTS `roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.roles: ~4 rows (approximately)
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', NULL, NULL, NULL),
(2, 'Agent', NULL, NULL, NULL),
(3, 'Help-Desk', '2022-01-17 20:38:50', '2022-01-17 20:38:50', NULL),
(4, 'Chefe-Department', '2022-01-26 12:52:26', '2022-01-26 13:30:10', NULL),
(5, 'Teste', '2022-02-04 16:17:49', '2022-02-04 16:18:58', '2022-02-04 16:18:58');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.role_user
CREATE TABLE IF NOT EXISTS `role_user` (
`user_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
KEY `user_id_fk_583558` (`user_id`),
KEY `role_id_fk_583558` (`role_id`),
CONSTRAINT `role_id_fk_583558` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
CONSTRAINT `user_id_fk_583558` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.role_user: ~10 rows (approximately)
/*!40000 ALTER TABLE `role_user` DISABLE KEYS */;
INSERT INTO `role_user` (`user_id`, `role_id`) VALUES
(1, 1),
(2, 2),
(6, 2),
(9, 4),
(10, 2),
(13, 4),
(15, 2),
(14, 2),
(16, 3),
(8, 2),
(5, 2);
/*!40000 ALTER TABLE `role_user` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.statuses
CREATE TABLE IF NOT EXISTS `statuses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.statuses: ~8 rows (approximately)
/*!40000 ALTER TABLE `statuses` DISABLE KEYS */;
INSERT INTO `statuses` (`id`, `name`, `color`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Aberto', '#26d916', '2022-01-17 07:10:27', '2022-01-18 07:00:50', NULL),
(3, 'Em tratamento', '#00bae3', '2022-01-18 07:01:40', '2022-01-18 07:02:25', NULL),
(4, 'Resolvido', '#0ce62e', '2022-01-18 07:02:55', '2022-01-18 07:02:55', NULL),
(5, 'Fechado', '#ffc107', '2022-01-20 12:59:27', '2022-01-20 13:00:12', NULL),
(6, 'Arquivado', '#ff3939', '2022-02-02 16:36:28', '2022-02-02 16:53:36', NULL),
(7, 'Q', '#6b4e4e', '2022-03-11 11:47:13', '2022-03-11 11:49:14', '2022-03-11 11:49:14'),
(8, 'Q', '#6b4e4e', '2022-03-11 11:49:04', '2022-03-11 11:49:18', '2022-03-11 11:49:18'),
(9, 'QASW', '#292525', '2022-03-11 11:49:33', '2022-03-11 11:49:33', NULL),
(10, 'sss', '#5c2d2d', '2022-03-11 11:54:06', '2022-03-11 11:54:06', NULL);
/*!40000 ALTER TABLE `statuses` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.tickets
CREATE TABLE IF NOT EXISTS `tickets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`imali_account` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`departments_id` int(10) unsigned DEFAULT NULL,
`tipos_id` int(10) unsigned DEFAULT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`documento` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`status_id` int(10) unsigned NOT NULL,
`priority_id` int(10) unsigned NOT NULL,
`category_id` int(10) unsigned NOT NULL,
`assigned_to_user_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `status_fk_583763` (`status_id`),
KEY `priority_fk_583764` (`priority_id`),
KEY `category_fk_583765` (`category_id`),
KEY `assigned_to_user_fk_583768` (`assigned_to_user_id`),
CONSTRAINT `assigned_to_user_fk_583768` FOREIGN KEY (`assigned_to_user_id`) REFERENCES `users` (`id`),
CONSTRAINT `category_fk_583765` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
CONSTRAINT `priority_fk_583764` FOREIGN KEY (`priority_id`) REFERENCES `priorities` (`id`),
CONSTRAINT `status_fk_583763` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.tickets: ~127 rows (approximately)
/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
INSERT INTO `tickets` (`id`, `title`, `phone`, `imali_account`, `departments_id`, `tipos_id`, `content`, `gender`, `email_status`, `author_name`, `author_email`, `documento`, `created_at`, `updated_at`, `deleted_at`, `status_id`, `priority_id`, `category_id`, `assigned_to_user_id`) VALUES
(68, 'Conta iMali', '2193849', '2100004', 4, NULL, 'Carregamento', NULL, NULL, 'Reany', 'reh@gmail.com', 'icons8-caixa-de-entrada-do-reddit-100.png1643579004.png', '2022-01-30 19:43:24', '2022-01-31 06:55:46', NULL, 1, 1, 2, 15),
(69, 'Transferencia de Valores por QR Code', '2299039', '2100078', 2, NULL, 'Transferencia de Valores por QR Code', NULL, NULL, 'Adao', 'adao@gmai.com', 'icons8-avião-de-papel-100.png1643579195.png', '2022-01-30 19:46:35', '2022-01-30 20:32:29', NULL, 1, 1, 1, NULL),
(70, 'Teste Teste Teste..', '222200', '21000004', NULL, NULL, 'Teste Teste Teste..', NULL, NULL, 'Teste', 'teste@teste.com', 'icons8-configurações-de-bate-papo-100.png1643614689.png', '2022-01-31 05:38:09', '2022-01-31 05:40:38', NULL, 1, 1, 1, 2),
(71, NULL, '234', '21344', 1, NULL, 'ffdd', NULL, NULL, 'A', 'dd@erer', NULL, '2022-01-31 07:48:33', '2022-01-31 07:48:33', NULL, 1, 1, 1, NULL),
(72, NULL, '345', NULL, 1, NULL, 'D\'a erro ao tentar transferir e depois me desconta e nao regista.', NULL, NULL, 'R', 'miguel@teste.com', NULL, '2022-01-31 08:10:15', '2022-01-31 08:10:15', NULL, 1, 1, 1, NULL),
(73, NULL, '845154895', '210000003', 1, NULL, 'Est\'a a dar eero no pagamento, n~ao consigo carregar.', NULL, NULL, 'Ivo Shazia', 'anaxyz2020@gmail.com', NULL, '2022-01-31 08:24:44', '2022-01-31 08:24:44', NULL, 1, 1, 4, NULL),
(78, NULL, '845030902', NULL, 1, NULL, 'Estou com problemas de Carregamento', NULL, NULL, 'Miguel', 'miguelmacamo9@gmail.com', NULL, '2022-01-31 08:39:31', '2022-01-31 08:39:31', NULL, 1, 1, 2, NULL),
(79, NULL, '845030902', NULL, 1, NULL, 'Teste', NULL, NULL, 'Miguel', 'miguelmacamo9@gmail.com', NULL, '2022-01-31 08:41:04', '2022-01-31 08:41:04', NULL, 1, 1, 3, NULL),
(80, NULL, '842592349', NULL, 2, NULL, 'Estamos a finalizar.', NULL, NULL, 'Ivo Shazia', 'naftalivo@gmail.com', 'icons8-configurações-da-caixa-de-entrada-100.png1643728413.png', '2022-01-31 11:14:46', '2022-02-01 15:13:33', NULL, 1, 1, 3, NULL),
(81, NULL, '841414550', NULL, 2, NULL, 'Vamos Guardar o historico', NULL, NULL, 'Machado', 'machado@teste.com', NULL, '2022-01-31 12:38:34', '2022-02-02 17:59:39', NULL, 5, 1, 4, NULL),
(82, NULL, '8522144615', NULL, 2, NULL, 'Historia da Origem da Humanidade...', NULL, NULL, 'Joao Gaspar', 'jgaspar@teste.com', NULL, '2022-01-31 13:02:59', '2022-02-01 12:29:53', NULL, 3, 3, 4, 6),
(91, 'mmmm', '21242', '45353', 2, NULL, 'fffff', NULL, NULL, 'Ivo', 'ma@hotmail.com', NULL, '2022-02-01 13:44:51', '2022-02-01 13:44:51', NULL, 1, 1, 2, 6),
(93, 'mmmm', '2124257', '4535356', 2, NULL, 'fffff', NULL, NULL, 'Ivo', 'mann@hotmail.com', NULL, '2022-02-01 13:46:22', '2022-02-01 13:46:22', NULL, 1, 1, 2, 6),
(95, NULL, '833197222', '21010004', 2, NULL, 'Os pagamentos por QR Code estao a falhar..', NULL, NULL, 'Ivo', 'naftalivo@gmail.com', 'icons8-conteúdo-100.png1643728653.png', '2022-02-01 15:17:33', '2022-02-03 22:44:32', NULL, 3, 1, 4, NULL),
(96, NULL, '2300039', '290302692', 1, NULL, 'Conta iMali bloqueada', NULL, NULL, 'Ana', 'naftalivo@gmail.com', NULL, '2022-02-01 15:20:11', '2022-02-01 21:57:30', NULL, 1, 1, 4, 6),
(97, NULL, '839399323', '217781', NULL, NULL, 'Teste', NULL, NULL, 'Teste Ticket', 'naftalivo@gmail.com', NULL, '2022-02-02 10:21:52', '2022-02-02 18:06:00', NULL, 6, 1, 5, 5),
(98, NULL, '839394', '21993450', NULL, NULL, 'Ola iMali', NULL, NULL, 'Ivo', 'naftalivo@gmail.com', NULL, '2022-02-03 18:55:04', '2022-02-07 12:04:42', NULL, 1, 1, 1, NULL),
(102, NULL, '83302001', '210934777', 3, NULL, 'Falha..', NULL, NULL, 'Ivo', 'naftalivo@gmail.com', NULL, '2022-02-04 13:03:46', '2022-02-10 11:22:14', NULL, 1, 1, 3, NULL),
(106, NULL, '205052058', '21345555', 6, NULL, 'Nao aceita pagar com leitura de QRCode', NULL, NULL, 'Samuela', 'anaxyz2020@gmail.com', 'ºM brand asset black.png1644352730.png', '2022-02-07 17:56:45', '2022-02-09 13:03:21', NULL, 1, 1, 4, NULL),
(136, NULL, '2190034', NULL, 2, NULL, 'dc', NULL, NULL, 'Dirce Matos', 'anaxyz2020@gmail.com', NULL, '2022-02-08 18:18:02', '2022-02-10 12:33:31', NULL, 1, 1, 2, 6),
(137, NULL, '29902', NULL, 2, NULL, 'dddd', NULL, NULL, 'Ilda', 'naftalivo@gmail.com', NULL, '2022-02-08 22:04:18', '2022-02-11 17:01:52', NULL, 1, 1, 2, 5),
(139, NULL, '830001238', '210000004', 2, NULL, 'Tenho enfrentado problemas para transferir valores no iMali', NULL, NULL, 'Luna', 'naftalivo@gmail.com', 'lo100x100.png1644592224.png', '2022-02-11 17:10:24', '2022-02-11 17:10:24', NULL, 1, 1, 3, NULL),
(140, NULL, '292010', NULL, 2, NULL, 'teste', NULL, NULL, 'Reah', 'naftalivo@gmail.com', NULL, '2022-02-15 16:53:38', '2022-02-15 16:53:38', NULL, 1, 1, 7, NULL),
(141, NULL, '283013782', NULL, 2, NULL, 'MMMM', NULL, NULL, 'Sebasthian', 'naftalivo@gmail.com', NULL, '2022-02-15 16:56:15', '2022-02-15 16:56:15', NULL, 1, 1, 5, NULL),
(142, NULL, '189930', NULL, 2, NULL, 'Carregamento feito com sucesso', NULL, NULL, 'Nubia', 'naftalivo@gmail.com', NULL, '2022-02-15 17:05:30', '2022-02-15 17:05:30', NULL, 1, 1, 2, NULL),
(143, NULL, '21902', NULL, 2, NULL, 'ssss', NULL, NULL, 'Swagger', 'naftalivo@gmail.com', NULL, '2022-02-15 17:14:08', '2022-02-15 17:14:08', NULL, 1, 1, 7, NULL),
(144, NULL, '128842', NULL, 2, NULL, 'Carregamento da DSTV', NULL, NULL, 'Ana', 'naftalivo@gmail.com', NULL, '2022-02-15 17:18:01', '2022-02-15 17:18:01', NULL, 1, 1, 7, NULL),
(145, NULL, '121233111', NULL, 2, NULL, 'mmsmsd', NULL, NULL, 'Teste', 'naftalivo@gmail.com', NULL, '2022-02-15 17:35:29', '2022-02-15 17:35:29', NULL, 1, 1, 8, NULL),
(146, NULL, '78484838', NULL, 2, NULL, 'nenhum', NULL, NULL, 'P', 'naftalivo@gmail.com', NULL, '2022-03-09 21:51:58', '2022-03-09 21:51:58', NULL, 1, 1, 4, NULL),
(147, NULL, '7888485', NULL, 2, NULL, 'sfcscsc', NULL, NULL, 'Ana', 'naftalivo@gmail.com', NULL, '2022-03-09 23:53:50', '2022-03-09 23:53:50', NULL, 1, 1, 5, NULL),
(148, NULL, '7888485', NULL, 2, 3, 'sfcscsc', NULL, NULL, 'Ana Maria', 'naftalivo@gmail.com', NULL, '2022-03-10 00:01:07', '2022-03-10 00:01:07', NULL, 1, 1, 5, NULL),
(149, NULL, '65384494', NULL, 2, 2, 'dffdf', NULL, NULL, 'Sdc', 'naftal@gmail.com', NULL, '2022-03-10 00:19:56', '2022-03-10 00:19:56', NULL, 1, 1, 8, NULL),
(150, NULL, '25900', '21000369', 2, NULL, 'WSE', NULL, NULL, 'Filipa', 'naftalivo@gmail.com', 'imali-wp.PNG1646911021.PNG', '2022-03-10 13:17:01', '2022-03-10 13:17:01', NULL, 1, 1, 5, NULL),
(151, NULL, '38348484', '28383838', 2, 2, 'adna damdmad', NULL, NULL, 'Ivo', 'naftalivo@gmail.com', 'dvj.PNG1646924519.PNG', '2022-03-10 17:01:59', '2022-03-10 17:01:59', NULL, 1, 1, 5, NULL),
(152, NULL, '774747', '2183838', 2, 3, 'dcccc', NULL, NULL, 'Ama', 'ana@hmama.com', NULL, '2022-03-10 17:03:31', '2022-03-10 17:03:31', NULL, 1, 1, 7, NULL),
(153, NULL, NULL, NULL, 2, 3, NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-10 17:41:03', '2022-03-10 17:41:03', NULL, 1, 1, 8, NULL),
(154, NULL, '8499', '7474848', 6, 2, 'vvvsvvsdvs', NULL, NULL, 'W', 'W@add.com', 'dvj.PNG1646927038.PNG', '2022-03-10 17:43:58', '2022-03-10 17:43:58', NULL, 1, 1, 10, NULL),
(155, NULL, '3456', '210000004', 2, 3, 'After Hours', NULL, NULL, 'A', 'naftalivo@gmail.com', 'dvj.PNG1646927511.PNG', '2022-03-10 17:51:51', '2022-03-10 17:51:51', NULL, 1, 1, 7, NULL),
(156, NULL, '87 1223 333', '21 000000 1', 6, 2, 'Nenhuma', NULL, NULL, 'Iva', 'eva@hotmail.com', NULL, '2022-03-10 22:00:10', '2022-03-10 22:00:10', NULL, 1, 1, 9, NULL),
(157, NULL, '83 3197 222', '21 000000 4', 2, 2, 'nenhuma', NULL, NULL, 'Ivo', 'naftalivo@gmail.com', NULL, '2022-03-11 11:21:18', '2022-03-11 11:21:18', NULL, 1, 1, 3, NULL),
(158, NULL, '21 9099 999', '21 000000 3', 6, 1, 'vvvv', 'M', NULL, 'Marinho', 'naftalivo@gmail.com', NULL, '2022-03-11 13:28:24', '2022-03-11 13:28:24', NULL, 1, 1, 9, NULL),
(159, NULL, '83 3197 222', '21 000000 4', 6, 2, 'NH', 'M', NULL, 'Ivo', 'naftalivo@gmail.com', 'Grupo-134-optimized.jpg1647006194.jpg', '2022-03-11 15:43:14', '2022-03-11 15:43:14', NULL, 1, 1, 9, NULL),
(160, NULL, '22 3233 223', '23 232332 3', 6, 1, 'dffdfddf', 'M', NULL, 'Ivo', 'naftalivo@gmail.com', 'Grupo-134-optimized.jpg1647007054.jpg', '2022-03-11 15:57:34', '2022-03-11 15:57:34', NULL, 1, 1, 10, NULL),
(161, NULL, '22 3232 322', '23 232232 3', 6, NULL, 'fdfdfd', 'F', NULL, 'Q', 'naftalivo@gmail.com', NULL, '2022-03-11 16:41:11', '2022-03-11 16:41:11', NULL, 1, 1, 11, NULL),
(162, NULL, '23 2333 232', '23 232323 2', 2, 2, 'fffff', 'F', NULL, 'Ken', 'naftalivo@gmail.com', NULL, '2022-03-11 16:52:06', '2022-03-11 16:52:06', NULL, 1, 1, 4, NULL),
(163, NULL, '87 3035 450', '21 000000 5', 6, 3, 'Sugestao de conteudo', 'M', NULL, 'Muhammad Machado', 'muhmachado90@gmail.com', NULL, '2022-03-11 17:00:32', '2022-03-11 17:00:32', NULL, 1, 1, 11, NULL),
(164, NULL, '84 5030 902', '21 000000 1', 6, 1, 'Testsadlsd', 'F', NULL, 'Miguel Macamo', 'miguelmacamo9@gmail.com', 'imali-help-home.PNG1647012351.PNG', '2022-03-11 17:25:51', '2022-03-11 17:25:51', NULL, 1, 1, 10, NULL),
(165, NULL, '21 4444 444', '32 667677 6', 6, 2, 'gfgfgg', 'F', NULL, 'Antonia Cumbe', 'naftalivo@gmail.com', NULL, '2022-03-14 16:49:23', '2022-03-14 16:49:23', NULL, 1, 1, 9, NULL),
(166, NULL, '82 3823 823', '23 823823 8', 6, 3, 'sssf', 'M', NULL, 'Mireal', 'naftalivo@gmail.com', NULL, '2022-03-14 16:51:23', '2022-03-14 16:51:23', NULL, 1, 1, 9, NULL),
(167, NULL, '12 1211 212', '12 121221 1', 6, 2, 'dfdf', 'M', NULL, 'Suria', 'naftalivo@gmail.com', NULL, '2022-03-14 18:22:33', '2022-03-14 18:22:33', NULL, 1, 1, 9, NULL),
(168, NULL, '11 1313 131', '12 121212 1', 2, 2, 'edc', 'F', NULL, 'A', 'naftalivo@gmail.com', NULL, '2022-03-14 18:23:56', '2022-03-14 18:23:56', NULL, 1, 1, 2, NULL),
(169, NULL, '21 2323 332', '13 311313 1', 6, 1, 'sffsf', 'M', NULL, 'Yara', 'naftalivo@gmail.com', NULL, '2022-03-15 11:21:41', '2022-03-15 11:21:41', NULL, 1, 1, 10, NULL),
(170, NULL, '22 3232 333', '23 232323 2', 6, 2, '323222', 'M', NULL, 'Wilma', 'naftalivo@gmail.com', NULL, '2022-03-15 11:25:37', '2022-03-15 11:25:37', NULL, 1, 1, 11, NULL),
(171, NULL, '32 3322 332', '23 223232 3', 6, 2, '22323', 'M', NULL, 'Ana', 'naftalivo@gmail.com', NULL, '2022-03-15 12:26:42', '2022-03-15 12:26:42', NULL, 1, 1, 10, NULL),
(172, NULL, '11 1313 331', '31 333113 1', 6, 2, '33131', 'M', NULL, 'Jussara', 'naftalivo@gmail.com', NULL, '2022-03-15 12:30:32', '2022-03-15 12:30:32', NULL, 1, 1, 9, NULL),
(173, NULL, '12 1333 232', '11 121212 1', 2, 1, '12121212', 'M', NULL, 'Courl', 'naftalivo@gmail.com', NULL, '2022-03-15 12:38:44', '2022-03-15 12:38:44', NULL, 1, 1, 8, NULL),
(174, NULL, '21 1213 344', '24 244445 5', 6, 1, 'rffg', 'F', NULL, 'Quim', 'naftalivo@gmail.com', NULL, '2022-03-15 12:44:14', '2022-03-15 12:44:14', NULL, 1, 1, 9, NULL),
(175, NULL, '12 3345 656', '12 345689 9', 6, 1, 'fggg', 'M', NULL, 'QA', 'naftalivo@gmail.com', NULL, '2022-03-15 12:46:42', '2022-03-15 12:46:42', NULL, 1, 1, 9, NULL),
(176, NULL, '21 8393 949', '21 000003 0', 6, 2, 'cdf', 'M', NULL, 'Steve', 'naftalivo@gmail.com', NULL, '2022-03-15 14:02:26', '2022-03-15 14:02:26', NULL, 1, 1, 10, NULL),
(177, NULL, '73 3884 848', '73 737474 7', 6, 2, 'dfdd', 'F', NULL, 'Steve', 'naftalivo@gmail.com', NULL, '2022-03-15 14:04:43', '2022-03-15 14:04:43', NULL, 1, 1, 10, NULL),
(178, NULL, '12 8323 992', '32 332323 2', 2, 2, 'ffff', 'M', NULL, 'Arnaldo', 'naftalivo@gmail.com', NULL, '2022-03-15 14:57:12', '2022-03-15 14:57:12', NULL, 1, 1, 8, NULL),
(179, NULL, '13 3372 732', '22 444455 4', 6, 1, 'dgdgdg', 'M', NULL, 'Dre', 'naftalivo@gmail.com', NULL, '2022-03-15 15:00:30', '2022-03-15 15:00:30', NULL, 1, 1, 10, NULL),
(180, NULL, '23 3333 333', NULL, 6, 2, 'ffff', 'M', NULL, 'W', '3333@dddd.com', NULL, '2022-03-16 12:49:44', '2022-03-16 12:49:44', NULL, 1, 1, 9, NULL),
(181, NULL, '22 2222 222', '22 222222 2', 6, 1, '22222', 'M', NULL, 'ER', 'naftalivo@gmail.com', NULL, '2022-03-16 13:06:03', '2022-03-16 13:06:03', NULL, 1, 1, 10, NULL),
(182, NULL, '22 2222 224', '22 222222 6', 6, 1, '22222ee', 'M', NULL, 'ERe', 'naftalivo@gmail.com', NULL, '2022-03-16 13:10:26', '2022-03-16 13:10:26', NULL, 1, 1, 9, NULL),
(183, NULL, '44 44__ ___', '45 4545__ _', 6, 1, '4445', 'M', NULL, 'rrr', 'rrr@ddd.com', NULL, '2022-03-16 13:11:12', '2022-03-16 13:11:12', NULL, 1, 1, 10, NULL),
(184, NULL, '44242424', '242424', 6, NULL, 'ffffdfd', NULL, NULL, 'QAA', 'naftalivo@gmail.com', NULL, '2022-03-16 14:50:37', '2022-03-16 14:50:37', NULL, 1, 1, 10, NULL),
(185, NULL, '45 4454 545', '45 454545 4', 2, 1, 'fdfdf', 'M', NULL, 'Aquimi', 'naftalivo@gmail.com', NULL, '2022-03-16 14:58:18', '2022-03-16 14:58:18', NULL, 1, 1, 8, NULL),
(186, NULL, '34 3434 434', '34 334___ _', 6, 2, '334', 'F', NULL, 'ec', 'naftalivo@gmail.com', NULL, '2022-03-16 15:08:56', '2022-03-16 15:08:56', NULL, 1, 1, 10, NULL),
(187, NULL, '33 333_ ___', NULL, 6, NULL, '333', 'M', NULL, '222', '2222@sss', NULL, '2022-03-16 15:32:08', '2022-03-16 15:32:08', NULL, 1, 1, 11, NULL),
(188, NULL, '33 333_ ___', NULL, 6, 1, '333', 'M', NULL, 'wwww', NULL, NULL, '2022-03-16 15:32:35', '2022-03-16 15:32:35', NULL, 1, 1, 11, NULL),
(189, NULL, '33 333_ ___', NULL, 6, 1, '333', 'M', NULL, 'wwww', 'www', NULL, '2022-03-16 15:32:42', '2022-03-16 15:32:42', NULL, 1, 1, 11, NULL),
(190, NULL, NULL, NULL, 6, 1, '333', 'M', NULL, 'wwww', 'www@ddd', NULL, '2022-03-16 15:32:54', '2022-03-16 15:32:54', NULL, 1, 1, 11, NULL),
(191, NULL, '22 2332 222', '22 222___ _', 6, 1, NULL, 'M', NULL, 'wwww', 'www@ddd', NULL, '2022-03-16 15:33:16', '2022-03-16 15:33:16', NULL, 1, 1, 11, NULL),
(192, NULL, '22 2332 222', '22 222___ _', 2, 1, 'dddd', 'M', NULL, 'wwww', 'www@ddd', NULL, '2022-03-16 15:33:37', '2022-03-16 15:33:37', NULL, 1, 1, 7, NULL),
(193, NULL, '22 2332 222', '22 222222 2', 2, 1, 'dddd', 'M', NULL, 'wwww', 'www@ddd.com', NULL, '2022-03-16 15:34:47', '2022-03-16 15:34:47', NULL, 1, 1, 7, NULL),
(194, NULL, '55 6799 000', '34 455566 7', 6, 1, 'ddffd', 'F', NULL, 'Qxc', 'naftalivo@gmail.com', NULL, '2022-03-16 15:37:47', '2022-03-16 15:37:47', NULL, 1, 1, 11, NULL),
(195, NULL, '44 4444 444', '44 444444 4', 6, 1, '44444444', 'F', NULL, 'eeee', 'eee@ddddd', NULL, '2022-03-16 17:04:30', '2022-03-16 17:04:30', NULL, 1, 1, 9, NULL),
(196, NULL, '44 4444 444', '44 444444 4', 6, 2, '44444444', 'F', NULL, 'eeeewww', 'eee@ddddd.com', 'Grupo-134-optimized.jpg1647443152.jpg', '2022-03-16 17:05:52', '2022-03-16 17:05:52', NULL, 1, 1, 11, NULL),
(197, NULL, '44 4444 455', '44 844959 5', 2, 3, 'ddc44ff', 'M', NULL, 'eeeewwww', 'eee@ddd.com', 'Grupo-134-optimized.jpg1647443272.jpg', '2022-03-16 17:07:52', '2022-03-16 17:07:52', NULL, 1, 1, 2, NULL),
(198, NULL, '34 4343 334', '34 334343 4', 6, 2, '343434', 'F', NULL, 'Qas', 'naftalivo@gmail.com', 'iMali-HelpDesk.PNG1647443515.PNG', '2022-03-16 17:11:55', '2022-03-16 17:11:55', NULL, 1, 1, 11, NULL),
(199, NULL, '45 4545 ___', '45 4545__ _', 6, 3, '5454', 'M', NULL, 'eeee', 'ddfd@dfdfdf', NULL, '2022-03-16 17:12:35', '2022-03-16 17:12:35', NULL, 1, 1, 10, NULL),
(200, NULL, '34 3496 969', '38 384849 4', 2, 1, '334ffv', 'M', 'OPEN', 'ecW', 'naftalivo@gmail.com', NULL, '2022-03-16 17:21:52', '2022-03-16 17:21:52', NULL, 1, 1, 8, NULL),
(201, NULL, '38 3884 845', '44 544554 5', 6, 1, '4445', 'M', 'OPEN', 'Teste Sync', 'naftalivo@gmail.com', NULL, '2022-03-16 18:42:12', '2022-03-16 18:42:12', NULL, 1, 1, 10, NULL),
(202, NULL, '73 8838 484', '45 666556 5', 2, 2, '5t5tg', 'F', 'OPEN', 'Nadia Narkova', 'naftalivo@gmail.com', NULL, '2022-03-16 18:43:35', '2022-03-16 18:43:35', NULL, 1, 1, 4, NULL),
(203, NULL, '28 8393 938', NULL, 6, 2, 'fdfdfdf', 'F', 'OPEN', 'Amarilia', 'naftalivo@gmail.com', NULL, '2022-03-16 19:14:01', '2022-03-16 19:14:01', NULL, 1, 1, 9, NULL),
(204, NULL, '27 3734 848', NULL, 2, 2, 'dfdf', 'M', 'OPEN', 'Yu', 'naftalivo@gmail.com', NULL, '2022-03-16 19:18:04', '2022-03-16 19:18:04', NULL, 1, 1, 3, NULL),
(205, NULL, '13 3443 034', NULL, 6, 2, 'Ye', 'M', 'OPEN', 'Ted', 'naftalivo@gmail.com', NULL, '2022-03-16 21:14:46', '2022-03-16 21:14:46', NULL, 1, 1, 9, NULL),
(206, NULL, '13 3443 035', NULL, 2, 3, 'Ye yeah yeah', 'F', 'OPEN', 'TedX', 'naftalivo@gmail.com', NULL, '2022-03-16 21:16:49', '2022-03-16 21:16:49', NULL, 1, 1, 2, NULL),
(207, NULL, '74 7484 884', NULL, 6, 1, 'mmm', 'M', 'OPEN', 'Ola', 'naftalivo@gmail.com', NULL, '2022-03-16 21:34:51', '2022-03-16 21:34:51', NULL, 1, 1, 9, NULL),
(208, NULL, '45 4545 454', NULL, 6, 1, 'nnm', 'M', 'OPEN', 'Ed', 'naftalivo@gmail.com', NULL, '2022-03-17 00:32:34', '2022-03-17 00:32:34', NULL, 1, 1, 10, NULL),
(209, NULL, '23 2232 323', NULL, 2, 3, 'mbj', 'F', 'OPEN', 'Samira', 'naftalivo@gmail.com', NULL, '2022-03-17 00:34:44', '2022-03-17 00:34:44', NULL, 1, 1, 3, NULL),
(210, NULL, '23 9292 323', NULL, 2, 2, 'mk', 'F', 'OPEN', 'Lidia', 'naftalivo@gmail.com', NULL, '2022-03-17 00:37:02', '2022-03-17 00:37:02', NULL, 1, 1, 7, NULL),
(211, NULL, '33 2323 232', NULL, 6, 3, 'mj', 'F', 'OPEN', 'Uyfgr', 'naftalivo@gmail.com', NULL, '2022-03-17 00:41:35', '2022-03-17 00:41:35', NULL, 1, 1, 9, NULL),
(212, NULL, '73 7457 858', NULL, 2, 2, 'nzck', 'F', 'OPEN', 'Ruman', 'naftalivo@gmail.com', NULL, '2022-03-17 01:00:16', '2022-03-17 01:00:16', NULL, 1, 1, 4, NULL),
(213, NULL, '14 7485 855', NULL, 6, 2, 'cvcv', 'F', 'OPEN', 'Romao', 'naftalivo@gmail.com', NULL, '2022-03-17 15:26:52', '2022-03-17 15:26:52', NULL, 1, 1, 9, NULL),
(214, NULL, '38 3994 993', NULL, 6, 4, 'mmsksk', 'M', 'OPEN', 'Alexandre', 'naftalivo@gmail.com', NULL, '2022-03-17 16:22:02', '2022-03-17 16:22:02', NULL, 1, 1, 10, NULL),
(215, NULL, '38 3848 484', '39 949494 9', 6, 1, 'mmdfk', 'M', 'OPEN', 'Domingos', 'naftalivo@gmail.com', NULL, '2022-03-17 16:27:14', '2022-03-17 16:27:14', NULL, 1, 1, 10, NULL),
(216, NULL, '74 8858 585', NULL, 2, 3, 'ndnddm', 'F', 'OPEN', 'Bennedita', 'naftalivo@gmail.com', NULL, '2022-03-17 16:31:14', '2022-03-17 16:31:14', NULL, 1, 1, 3, NULL),
(217, NULL, '74 7474 848', NULL, 2, 2, 'msmsms', 'F', 'OPEN', 'Suraia', 'naftalivo@gmail.com', NULL, '2022-03-17 16:34:45', '2022-03-17 16:34:45', NULL, 1, 1, 4, NULL),
(218, NULL, '64 4747 474', NULL, 6, 2, 'msjidi', 'F', 'OPEN', 'Candida', 'naftalivo@gmail.com', NULL, '2022-03-17 16:35:19', '2022-03-17 16:35:19', NULL, 1, 1, 10, NULL),
(219, NULL, '75 7557 575', NULL, 2, 3, 'grr', 'F', 'OPEN', 'IVO', 'naftalivo@gmail.com', NULL, '2022-03-17 17:07:17', '2022-03-17 17:07:17', NULL, 1, 1, 7, NULL),
(220, NULL, '63 6644 646', NULL, 6, 3, 'jejej', 'M', 'OPEN', 'Miguel', 'naftalivo@gmail.com', NULL, '2022-03-17 17:16:05', '2022-03-17 17:16:05', NULL, 1, 1, 10, NULL),
(221, NULL, '77 3783 883', NULL, 6, 2, 'nsjksk', 'F', 'OPEN', 'Migel', 'naftalivo@gmail.com', NULL, '2022-03-17 17:23:14', '2022-03-17 17:23:14', NULL, 1, 1, 10, NULL),
(222, NULL, '21 7272 727', NULL, 6, 2, 'msksoso', 'F', 'OPEN', 'Teste Email', 'naftalivo@gmail.com', NULL, '2022-03-17 17:25:36', '2022-03-17 17:25:36', NULL, 1, 1, 10, NULL),
(223, NULL, '83 8884 848', NULL, 2, 3, 'gggg', 'F', 'OPEN', 'Teste Email Ivo', 'naftalivo@gmail.com', NULL, '2022-03-18 13:04:36', '2022-03-18 13:04:36', NULL, 1, 1, 3, NULL),
(224, NULL, '34 3443 334', NULL, 6, 3, 'fgfggfg', 'F', 'OPEN', 'Denvo', 'naftalivo@gmail.com', NULL, '2022-03-18 13:07:20', '2022-03-18 13:07:20', NULL, 1, 1, 9, NULL),
(225, NULL, '24 2424 242', NULL, 2, 4, 'trgrgrg', 'F', 'OPEN', 'Noia', 'naftalivo@gmail.com', NULL, '2022-03-18 13:10:42', '2022-03-18 13:10:42', NULL, 1, 1, 8, NULL),
(226, NULL, '23 2322 323', NULL, 6, 2, 'fffdff', 'F', 'OPEN', 'Suwa', 'naftalivo@gmail.com', NULL, '2022-03-18 15:00:27', '2022-03-18 15:00:27', NULL, 1, 1, 9, NULL),
(227, NULL, '23 2322 344', NULL, 2, 3, 'fffdffccc', 'M', 'OPEN', 'SuwaS', 'naftalivo@gmail.com', NULL, '2022-03-18 15:01:17', '2022-03-18 15:01:17', NULL, 1, 1, 3, NULL),
(228, NULL, '23 8822 344', NULL, 2, 2, 'fffdffcccX', 'F', 'OPEN', 'SuwaSSx', 'naftalivo@gmail.com', NULL, '2022-03-18 15:02:53', '2022-03-18 15:02:53', NULL, 1, 1, 2, NULL),
(229, NULL, '35 3535 ___', NULL, 2, 1, 'ddfd', 'F', 'OPEN', 'Ivo', 'naftalivo@gmail.com', NULL, '2022-03-18 15:41:06', '2022-03-18 15:41:06', NULL, 1, 1, 8, NULL),
(230, NULL, '66 4474 777', NULL, 6, 2, 'mdmdm', 'F', 'OPEN', 'Nim', 'naftalivo@gmail.com', NULL, '2022-03-18 15:43:55', '2022-03-18 15:43:55', NULL, 1, 1, 9, NULL),
(231, NULL, '73 7373 383', NULL, 2, 3, 'Teste', 'F', 'OPEN', 'Ana', 'anaxyz2020@gmail.com', NULL, '2022-03-18 15:46:44', '2022-03-18 15:46:44', NULL, 1, 1, 8, NULL),
(232, NULL, '27 7247 424', NULL, 2, 3, 'msmsm', 'F', 'OPEN', 'Ramena', 'anaxyz2020@gmail.com', NULL, '2022-03-18 15:58:12', '2022-03-18 15:58:12', NULL, 1, 1, 7, NULL),
(233, NULL, '88 3838 383', NULL, 2, 3, 'mms', 'F', 'OPEN', 'Maria', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:02:18', '2022-03-18 16:02:18', NULL, 1, 1, 8, NULL),
(234, NULL, '37 3747 488', NULL, 6, 3, 'mdmfk', 'F', 'OPEN', 'Raul', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:06:30', '2022-03-18 16:06:30', NULL, 1, 1, 9, NULL),
(235, NULL, '74 7484 848', NULL, 2, 3, 'mdmdk', 'F', 'OPEN', 'Raymundo', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:11:04', '2022-03-18 16:11:04', NULL, 1, 1, 3, NULL),
(236, NULL, '84 8464 949', NULL, 2, 3, 'msfksfs', 'F', 'OPEN', 'Mia', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:15:32', '2022-03-18 16:15:32', NULL, 1, 1, 2, NULL),
(237, NULL, '73 5735 358', NULL, 2, 3, 'msfksfsfk', 'F', 'OPEN', 'Amanda', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:20:35', '2022-03-18 16:20:35', NULL, 1, 1, 8, NULL),
(238, NULL, '84 8484 848', NULL, 2, 2, 'jdasjaf', 'F', 'OPEN', 'Amaral Costa', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:25:28', '2022-03-18 16:25:28', NULL, 1, 1, 8, NULL),
(239, NULL, '77 7575 758', NULL, 2, 3, 'admadkadk', 'F', 'OPEN', 'Medina Karnokova', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:30:26', '2022-03-18 16:30:26', NULL, 1, 1, 3, NULL),
(240, NULL, '77 3733 838', NULL, 2, 2, 'nzada', 'F', 'OPEN', 'Sufura', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:41:14', '2022-03-18 16:41:14', NULL, 1, 1, 3, NULL),
(241, NULL, '74 7348 348', NULL, 2, 3, 'sfsfsf', 'F', 'OPEN', 'Solange', 'anaxyz2020@gmail.com', NULL, '2022-03-18 16:58:11', '2022-03-18 16:58:11', NULL, 1, 1, 7, NULL),
(242, NULL, '83 4834 344', NULL, 2, 3, 'sfsfsfs', 'F', 'OPEN', 'Dirce', 'anaxyz2020@gmail.com', NULL, '2022-03-18 17:06:46', '2022-03-18 17:06:46', NULL, 1, 1, 8, NULL),
(243, NULL, '24 2424 242', NULL, 6, 2, 'dgdgdg', 'F', 'OPEN', 'Carina', 'anaxyz2020@gmail.com', NULL, '2022-03-18 17:08:52', '2022-03-18 17:08:52', NULL, 1, 1, 9, NULL),
(244, NULL, '28 3823 283', NULL, 6, 3, 'xvv', 'F', 'OPEN', 'Adan', 'anaxyz2020@gmail.com', NULL, '2022-03-18 17:27:38', '2022-03-18 17:27:38', NULL, 1, 1, 9, NULL);
/*!40000 ALTER TABLE `tickets` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.ticket_histories
CREATE TABLE IF NOT EXISTS `ticket_histories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`department_id` bigint(20) unsigned DEFAULT NULL,
`tipos_id` bigint(10) unsigned DEFAULT NULL,
`category_id` bigint(20) unsigned DEFAULT NULL,
`status_id` bigint(20) unsigned DEFAULT NULL,
`ticket_id` bigint(20) unsigned DEFAULT NULL,
`priority_id` bigint(20) unsigned DEFAULT NULL,
`agent_id` bigint(20) unsigned DEFAULT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.ticket_histories: ~222 rows (approximately)
/*!40000 ALTER TABLE `ticket_histories` DISABLE KEYS */;
INSERT INTO `ticket_histories` (`id`, `department_id`, `tipos_id`, `category_id`, `status_id`, `ticket_id`, `priority_id`, `agent_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, 4, 1, 81, 1, NULL, NULL, '2022-01-31 12:38:42', '2022-01-31 12:38:42'),
(2, 2, NULL, 4, 3, 81, 1, NULL, NULL, '2022-01-31 12:43:51', '2022-01-31 12:43:51'),
(3, 2, NULL, 4, 4, 81, 1, NULL, 5, '2022-01-31 13:01:03', '2022-01-31 13:01:03'),
(4, 2, NULL, 4, 1, 82, 1, NULL, NULL, '2022-01-31 13:03:08', '2022-01-31 13:03:08'),
(5, 2, NULL, 4, 3, 82, 3, NULL, 5, '2022-01-31 13:05:47', '2022-01-31 13:05:47'),
(6, 2, NULL, 4, 3, 82, 3, 6, 13, '2022-01-31 13:08:25', '2022-01-31 13:08:25'),
(7, 4, NULL, 2, 1, 68, 1, 15, 1, '2022-01-31 14:20:37', '2022-01-31 14:20:37'),
(8, 2, NULL, 4, 3, 82, 3, 6, 1, '2022-02-01 12:29:54', '2022-02-01 12:29:54'),
(9, 2, NULL, 2, 1, 93, 1, 6, 1, '2022-02-01 13:46:31', '2022-02-01 13:46:31'),
(10, 2, NULL, 3, 1, 80, 1, NULL, 1, '2022-02-01 15:09:12', '2022-02-01 15:09:12'),
(11, 2, NULL, 3, 1, 80, 1, NULL, 1, '2022-02-01 15:13:33', '2022-02-01 15:13:33'),
(12, 2, NULL, 4, 1, 95, 1, NULL, NULL, '2022-02-01 15:17:43', '2022-02-01 15:17:43'),
(13, 1, NULL, 4, 1, 96, 1, 6, 1, '2022-02-01 15:20:21', '2022-02-01 15:20:21'),
(14, 1, NULL, 4, 1, 96, 1, 6, 1, '2022-02-01 21:57:30', '2022-02-01 21:57:30'),
(15, 5, NULL, 1, 1, 97, 1, NULL, NULL, '2022-02-02 10:22:01', '2022-02-02 10:22:01'),
(16, 2, NULL, 1, 1, 97, 1, 5, 1, '2022-02-02 11:29:49', '2022-02-02 11:29:49'),
(17, NULL, NULL, 1, 3, 97, 1, 5, 5, '2022-02-02 11:31:28', '2022-02-02 11:31:28'),
(18, NULL, NULL, 1, 4, 97, 1, 5, 5, '2022-02-02 11:32:31', '2022-02-02 11:32:31'),
(19, NULL, NULL, 5, 4, 97, 1, 5, 1, '2022-02-02 11:34:42', '2022-02-02 11:34:42'),
(20, 2, NULL, 4, 6, 81, 1, NULL, 1, '2022-02-02 17:05:10', '2022-02-02 17:05:10'),
(21, 2, NULL, 4, 5, 81, 1, NULL, 1, '2022-02-02 17:59:39', '2022-02-02 17:59:39'),
(22, NULL, NULL, 5, 6, 97, 1, 5, 1, '2022-02-02 18:01:52', '2022-02-02 18:01:52'),
(23, NULL, NULL, 5, 5, 97, 1, 5, 1, '2022-02-02 18:04:25', '2022-02-02 18:04:25'),
(24, NULL, NULL, 5, 6, 97, 1, 5, 1, '2022-02-02 18:05:46', '2022-02-02 18:05:46'),
(25, NULL, NULL, 5, 6, 97, 1, 5, 1, '2022-02-02 18:06:00', '2022-02-02 18:06:00'),
(26, NULL, NULL, 1, 1, 98, 1, NULL, 1, '2022-02-03 21:47:35', '2022-02-03 21:47:35'),
(27, 2, NULL, 4, 1, 95, 1, NULL, 1, '2022-02-03 22:37:04', '2022-02-03 22:37:04'),
(28, 2, NULL, 4, 3, 95, 1, NULL, 1, '2022-02-03 22:38:46', '2022-02-03 22:38:46'),
(29, 2, NULL, 4, 4, 95, 1, NULL, 1, '2022-02-03 22:41:07', '2022-02-03 22:41:07'),
(30, 2, NULL, 4, 1, 95, 1, NULL, 1, '2022-02-03 22:41:40', '2022-02-03 22:41:40'),
(31, 2, NULL, 4, 3, 95, 1, NULL, 1, '2022-02-03 22:42:00', '2022-02-03 22:42:00'),
(32, 2, NULL, 4, 4, 95, 1, NULL, 1, '2022-02-03 22:42:43', '2022-02-03 22:42:43'),
(33, 2, NULL, 4, 3, 95, 1, NULL, 1, '2022-02-03 22:44:32', '2022-02-03 22:44:32'),
(34, 2, NULL, 4, 3, 95, 1, NULL, 1, '2022-02-03 22:50:35', '2022-02-03 22:50:35'),
(35, NULL, NULL, 1, 5, 98, 1, NULL, 1, '2022-02-04 11:16:12', '2022-02-04 11:16:12'),
(36, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-04 11:16:35', '2022-02-04 11:16:35'),
(37, NULL, NULL, 1, 5, 98, 1, NULL, 1, '2022-02-04 11:18:15', '2022-02-04 11:18:15'),
(38, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-04 11:19:20', '2022-02-04 11:19:20'),
(39, 3, NULL, 3, 1, 99, 1, NULL, NULL, '2022-02-04 12:42:58', '2022-02-04 12:42:58'),
(40, 3, NULL, 3, 1, 100, 1, NULL, NULL, '2022-02-04 12:49:09', '2022-02-04 12:49:09'),
(41, 5, NULL, 2, 1, 101, 1, NULL, NULL, '2022-02-04 13:01:12', '2022-02-04 13:01:12'),
(42, 3, NULL, 3, 1, 102, 1, NULL, NULL, '2022-02-04 13:03:59', '2022-02-04 13:03:59'),
(43, NULL, NULL, 1, 5, 98, 1, NULL, 1, '2022-02-06 23:07:22', '2022-02-06 23:07:22'),
(44, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-07 11:43:25', '2022-02-07 11:43:25'),
(45, NULL, NULL, 1, 1, 98, 1, NULL, 1, '2022-02-07 11:43:47', '2022-02-07 11:43:47'),
(46, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-07 11:53:11', '2022-02-07 11:53:11'),
(47, NULL, NULL, 1, 1, 98, 1, NULL, 1, '2022-02-07 11:55:29', '2022-02-07 11:55:29'),
(48, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-07 11:55:37', '2022-02-07 11:55:37'),
(49, NULL, NULL, 1, 1, 98, 1, NULL, 1, '2022-02-07 11:56:11', '2022-02-07 11:56:11'),
(50, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-07 11:56:17', '2022-02-07 11:56:17'),
(51, NULL, NULL, 1, 3, 98, 1, NULL, 1, '2022-02-07 12:04:10', '2022-02-07 12:04:10'),
(52, NULL, NULL, 1, 1, 98, 1, NULL, 1, '2022-02-07 12:04:42', '2022-02-07 12:04:42'),
(53, 9, NULL, 7, 1, 103, 1, NULL, NULL, '2022-02-07 15:07:40', '2022-02-07 15:07:40'),
(54, 9, NULL, 7, 1, 104, 1, NULL, NULL, '2022-02-07 16:46:02', '2022-02-07 16:46:02'),
(55, 9, NULL, 7, 1, 105, 1, NULL, NULL, '2022-02-07 17:32:00', '2022-02-07 17:32:00'),
(56, 6, NULL, 4, 1, 106, 1, NULL, NULL, '2022-02-07 17:56:53', '2022-02-07 17:56:53'),
(57, 9, NULL, 7, 1, 107, 1, NULL, NULL, '2022-02-08 12:11:55', '2022-02-08 12:11:55'),
(58, 9, NULL, 7, 1, 108, 1, NULL, NULL, '2022-02-08 13:09:03', '2022-02-08 13:09:03'),
(59, 12, NULL, 3, 1, 109, 1, NULL, NULL, '2022-02-08 13:34:25', '2022-02-08 13:34:25'),
(60, 9, NULL, 7, 1, 110, 1, NULL, NULL, '2022-02-08 13:37:46', '2022-02-08 13:37:46'),
(61, 9, NULL, 7, 1, 111, 1, NULL, NULL, '2022-02-08 15:05:01', '2022-02-08 15:05:01'),
(62, 10, NULL, 5, 1, 112, 1, NULL, NULL, '2022-02-08 15:08:13', '2022-02-08 15:08:13'),
(63, 12, NULL, 3, 1, 113, 1, NULL, NULL, '2022-02-08 15:14:53', '2022-02-08 15:14:53'),
(64, 6, NULL, 4, 1, 114, 1, NULL, NULL, '2022-02-08 15:20:01', '2022-02-08 15:20:01'),
(65, 12, NULL, 3, 1, 115, 1, NULL, NULL, '2022-02-08 15:23:29', '2022-02-08 15:23:29'),
(66, 6, NULL, 4, 1, 116, 1, NULL, NULL, '2022-02-08 15:29:18', '2022-02-08 15:29:18'),
(67, 12, NULL, 3, 1, 117, 1, NULL, NULL, '2022-02-08 15:32:16', '2022-02-08 15:32:16'),
(68, 6, NULL, 4, 1, 118, 1, NULL, NULL, '2022-02-08 15:47:04', '2022-02-08 15:47:04'),
(69, 6, NULL, 4, 1, 119, 1, NULL, NULL, '2022-02-08 15:50:20', '2022-02-08 15:50:20'),
(70, 6, NULL, 4, 1, 120, 1, NULL, NULL, '2022-02-08 15:51:24', '2022-02-08 15:51:24'),
(71, 6, NULL, 4, 1, 121, 1, NULL, NULL, '2022-02-08 16:00:25', '2022-02-08 16:00:25'),
(72, 10, NULL, 5, 1, 122, 1, NULL, NULL, '2022-02-08 16:04:19', '2022-02-08 16:04:19'),
(73, 6, NULL, 4, 1, 123, 1, NULL, NULL, '2022-02-08 16:14:11', '2022-02-08 16:14:11'),
(74, 9, NULL, 7, 1, 124, 1, NULL, NULL, '2022-02-08 16:19:30', '2022-02-08 16:19:30'),
(75, 6, NULL, 4, 1, 125, 1, NULL, NULL, '2022-02-08 16:26:48', '2022-02-08 16:26:48'),
(76, 9, NULL, 7, 1, 126, 1, NULL, NULL, '2022-02-08 17:18:06', '2022-02-08 17:18:06'),
(77, 12, NULL, 3, 1, 127, 1, NULL, NULL, '2022-02-08 17:22:14', '2022-02-08 17:22:14'),
(78, 10, NULL, 2, 1, 128, 1, NULL, NULL, '2022-02-08 17:24:34', '2022-02-08 17:24:34'),
(79, 10, NULL, 5, 1, 129, 1, NULL, NULL, '2022-02-08 17:28:58', '2022-02-08 17:28:58'),
(80, 12, NULL, 3, 1, 130, 1, NULL, NULL, '2022-02-08 17:43:49', '2022-02-08 17:43:49'),
(81, 12, NULL, 3, 1, 131, 1, NULL, NULL, '2022-02-08 17:45:41', '2022-02-08 17:45:41'),
(82, 6, NULL, 4, 1, 132, 1, NULL, NULL, '2022-02-08 17:50:21', '2022-02-08 17:50:21'),
(83, 12, NULL, 3, 1, 134, 1, NULL, NULL, '2022-02-08 18:11:28', '2022-02-08 18:11:28'),
(84, 12, NULL, 3, 1, 135, 1, NULL, NULL, '2022-02-08 18:15:23', '2022-02-08 18:15:23'),
(85, 12, NULL, 3, 1, 136, 1, NULL, NULL, '2022-02-08 18:18:11', '2022-02-08 18:18:11'),
(86, 6, NULL, 4, 1, 137, 1, NULL, NULL, '2022-02-08 22:04:27', '2022-02-08 22:04:27'),
(87, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:37:07', '2022-02-08 22:37:07'),
(88, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-08 22:38:21', '2022-02-08 22:38:21'),
(89, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:38:26', '2022-02-08 22:38:26'),
(90, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:38:50', '2022-02-08 22:38:50'),
(91, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-08 22:39:01', '2022-02-08 22:39:01'),
(92, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:40:23', '2022-02-08 22:40:23'),
(93, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-08 22:41:55', '2022-02-08 22:41:55'),
(94, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:42:05', '2022-02-08 22:42:05'),
(95, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-08 22:46:07', '2022-02-08 22:46:07'),
(96, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-08 22:46:16', '2022-02-08 22:46:16'),
(97, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-09 12:15:28', '2022-02-09 12:15:28'),
(98, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-09 12:15:52', '2022-02-09 12:15:52'),
(99, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-09 12:16:46', '2022-02-09 12:16:46'),
(100, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-09 12:16:58', '2022-02-09 12:16:58'),
(101, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-09 12:27:13', '2022-02-09 12:27:13'),
(102, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:30:32', '2022-02-09 12:30:32'),
(103, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:30:50', '2022-02-09 12:30:50'),
(104, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:31:48', '2022-02-09 12:31:48'),
(105, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:31:55', '2022-02-09 12:31:55'),
(106, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-09 12:32:12', '2022-02-09 12:32:12'),
(107, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:41:23', '2022-02-09 12:41:23'),
(108, 6, NULL, 4, 3, 106, 1, NULL, 1, '2022-02-09 12:44:14', '2022-02-09 12:44:14'),
(109, 6, NULL, 4, 5, 106, 1, NULL, 1, '2022-02-09 12:44:34', '2022-02-09 12:44:34'),
(110, 6, NULL, 4, 1, 106, 1, NULL, 1, '2022-02-09 13:03:21', '2022-02-09 13:03:21'),
(111, 12, NULL, 3, 3, 136, 1, NULL, 1, '2022-02-09 15:07:02', '2022-02-09 15:07:02'),
(112, 12, NULL, 3, 5, 136, 1, NULL, 1, '2022-02-09 15:15:47', '2022-02-09 15:15:47'),
(113, 12, NULL, 3, 3, 136, 1, NULL, 1, '2022-02-09 15:16:50', '2022-02-09 15:16:50'),
(114, 12, NULL, 3, 5, 136, 1, NULL, 1, '2022-02-09 15:17:13', '2022-02-09 15:17:13'),
(115, 12, NULL, 3, 1, 136, 1, NULL, 1, '2022-02-09 15:18:03', '2022-02-09 15:18:03'),
(116, 12, NULL, 3, 5, 136, 1, NULL, 1, '2022-02-09 15:18:17', '2022-02-09 15:18:17'),
(117, 12, NULL, 3, 1, 136, 1, NULL, 1, '2022-02-09 15:19:23', '2022-02-09 15:19:23'),
(118, 12, NULL, 3, 5, 136, 1, NULL, 1, '2022-02-09 15:26:06', '2022-02-09 15:26:06'),
(119, 12, NULL, 3, 1, 136, 1, NULL, 1, '2022-02-09 15:26:15', '2022-02-09 15:26:15'),
(120, 12, NULL, 3, 5, 136, 1, NULL, 1, '2022-02-09 15:26:29', '2022-02-09 15:26:29'),
(121, 12, NULL, 3, 1, 136, 1, NULL, 1, '2022-02-09 15:27:36', '2022-02-09 15:27:36'),
(122, 12, NULL, 3, 4, 136, 1, NULL, 1, '2022-02-09 15:29:44', '2022-02-09 15:29:44'),
(123, 2, NULL, 2, 4, 136, 1, 2, 1, '2022-02-09 15:35:53', '2022-02-09 15:35:53'),
(124, 2, NULL, 2, 1, 136, 1, 2, 1, '2022-02-09 15:36:25', '2022-02-09 15:36:25'),
(125, 2, NULL, 2, 5, 136, 1, 2, 1, '2022-02-09 16:26:35', '2022-02-09 16:26:35'),
(126, 2, NULL, 2, 3, 136, 1, 2, 1, '2022-02-09 16:28:38', '2022-02-09 16:28:38'),
(127, 3, NULL, 3, 5, 102, 1, NULL, 1, '2022-02-10 11:16:13', '2022-02-10 11:16:13'),
(128, 3, NULL, 3, 1, 102, 1, NULL, 1, '2022-02-10 11:16:38', '2022-02-10 11:16:38'),
(129, 3, NULL, 3, 5, 102, 1, NULL, 1, '2022-02-10 11:16:57', '2022-02-10 11:16:57'),
(130, 3, NULL, 3, 1, 102, 1, NULL, 1, '2022-02-10 11:17:40', '2022-02-10 11:17:40'),
(131, 3, NULL, 3, 5, 102, 1, NULL, 1, '2022-02-10 11:21:51', '2022-02-10 11:21:51'),
(132, 3, NULL, 3, 1, 102, 1, NULL, 1, '2022-02-10 11:22:14', '2022-02-10 11:22:14'),
(133, 2, NULL, 2, 5, 136, 1, 2, 1, '2022-02-10 11:25:33', '2022-02-10 11:25:33'),
(134, 2, NULL, 2, 1, 136, 1, 2, 1, '2022-02-10 11:25:57', '2022-02-10 11:25:57'),
(135, 2, NULL, 2, 5, 136, 1, 2, 1, '2022-02-10 11:34:45', '2022-02-10 11:34:45'),
(136, 2, NULL, 2, 1, 136, 1, 2, 1, '2022-02-10 11:37:32', '2022-02-10 11:37:32'),
(137, 2, NULL, 2, 5, 136, 1, 2, 1, '2022-02-10 11:37:44', '2022-02-10 11:37:44'),
(138, 2, NULL, 2, 1, 136, 1, 2, 1, '2022-02-10 11:39:55', '2022-02-10 11:39:55'),
(139, 2, NULL, 2, 1, 136, 1, NULL, 16, '2022-02-10 12:32:20', '2022-02-10 12:32:20'),
(140, 2, NULL, 2, 1, 136, 1, 6, 13, '2022-02-10 12:33:35', '2022-02-10 12:33:35'),
(141, 2, NULL, 2, 1, 137, 1, 5, 1, '2022-02-11 17:02:03', '2022-02-11 17:02:03'),
(142, 2, NULL, 3, 1, 139, 1, NULL, NULL, '2022-02-11 17:10:29', '2022-02-11 17:10:29'),
(143, 2, NULL, 7, 1, 140, 1, NULL, NULL, '2022-02-15 16:53:44', '2022-02-15 16:53:44'),
(144, 2, NULL, 5, 1, 141, 1, NULL, NULL, '2022-02-15 16:56:19', '2022-02-15 16:56:19'),
(145, 2, NULL, 2, 1, 142, 1, NULL, NULL, '2022-02-15 17:05:35', '2022-02-15 17:05:35'),
(146, 2, NULL, 7, 1, 143, 1, NULL, NULL, '2022-02-15 17:14:12', '2022-02-15 17:14:12'),
(147, 2, NULL, 7, 1, 144, 1, NULL, NULL, '2022-02-15 17:18:06', '2022-02-15 17:18:06'),
(148, 2, NULL, 8, 1, 145, 1, NULL, NULL, '2022-02-15 17:35:33', '2022-02-15 17:35:33'),
(149, 2, NULL, 5, 1, 150, 1, NULL, NULL, '2022-03-10 13:17:09', '2022-03-10 13:17:09'),
(150, 2, 3, 7, 1, 152, 1, NULL, NULL, '2022-03-10 17:03:36', '2022-03-10 17:03:36'),
(151, 2, 3, 8, 1, 153, 1, NULL, NULL, '2022-03-10 17:41:08', '2022-03-10 17:41:08'),
(152, 6, 2, 10, 1, 154, 1, NULL, NULL, '2022-03-10 17:44:03', '2022-03-10 17:44:03'),
(153, 2, 3, 7, 1, 155, 1, NULL, NULL, '2022-03-10 17:51:55', '2022-03-10 17:51:55'),
(154, 2, 2, 3, 1, 157, 1, NULL, NULL, '2022-03-11 11:21:27', '2022-03-11 11:21:27'),
(155, 6, 1, 9, 1, 158, 1, NULL, NULL, '2022-03-11 13:28:34', '2022-03-11 13:28:34'),
(156, 6, 2, 9, 1, 159, 1, NULL, NULL, '2022-03-11 15:43:19', '2022-03-11 15:43:19'),
(157, 6, 1, 10, 1, 160, 1, NULL, NULL, '2022-03-11 15:57:51', '2022-03-11 15:57:51'),
(158, 6, NULL, 11, 1, 161, 1, NULL, NULL, '2022-03-11 16:41:15', '2022-03-11 16:41:15'),
(159, 2, 2, 4, 1, 162, 1, NULL, NULL, '2022-03-11 16:52:10', '2022-03-11 16:52:10'),
(160, 6, 3, 11, 1, 163, 1, NULL, NULL, '2022-03-11 17:00:36', '2022-03-11 17:00:36'),
(161, 6, 1, 10, 1, 164, 1, NULL, NULL, '2022-03-11 17:25:58', '2022-03-11 17:25:58'),
(162, 6, 2, 9, 1, 165, 1, NULL, NULL, '2022-03-14 16:49:28', '2022-03-14 16:49:28'),
(163, 6, 3, 9, 1, 166, 1, NULL, NULL, '2022-03-14 16:51:27', '2022-03-14 16:51:27'),
(164, 6, 2, 9, 1, 167, 1, NULL, NULL, '2022-03-14 18:22:38', '2022-03-14 18:22:38'),
(165, 2, 2, 2, 1, 168, 1, NULL, NULL, '2022-03-14 18:24:01', '2022-03-14 18:24:01'),
(166, 6, 1, 10, 1, 169, 1, NULL, NULL, '2022-03-15 11:21:52', '2022-03-15 11:21:52'),
(167, 6, 2, 11, 1, 170, 1, NULL, NULL, '2022-03-15 11:25:42', '2022-03-15 11:25:42'),
(168, 6, 2, 10, 1, 171, 1, NULL, NULL, '2022-03-15 12:26:47', '2022-03-15 12:26:47'),
(169, 6, 2, 9, 1, 172, 1, NULL, NULL, '2022-03-15 12:30:37', '2022-03-15 12:30:37'),
(170, 2, 1, 8, 1, 173, 1, NULL, NULL, '2022-03-15 12:38:49', '2022-03-15 12:38:49'),
(171, 6, 1, 9, 1, 174, 1, NULL, NULL, '2022-03-15 12:44:19', '2022-03-15 12:44:19'),
(172, 6, 1, 10, 1, 179, 1, NULL, NULL, '2022-03-15 15:00:35', '2022-03-15 15:00:35'),
(173, 6, 2, 10, 1, 186, 1, NULL, NULL, '2022-03-16 15:09:09', '2022-03-16 15:09:09'),
(174, 6, 1, 9, 1, 195, 1, NULL, NULL, '2022-03-16 17:04:35', '2022-03-16 17:04:35'),
(175, 6, 2, 11, 1, 196, 1, NULL, NULL, '2022-03-16 17:05:58', '2022-03-16 17:05:58'),
(176, 2, 3, 2, 1, 197, 1, NULL, NULL, '2022-03-16 17:07:56', '2022-03-16 17:07:56'),
(177, 6, 2, 11, 1, 198, 1, NULL, NULL, '2022-03-16 17:11:59', '2022-03-16 17:11:59'),
(178, 2, 1, 8, 1, 200, 1, NULL, NULL, '2022-03-16 17:21:57', '2022-03-16 17:21:57'),
(179, 6, 1, 10, 1, 201, 1, NULL, NULL, '2022-03-16 18:42:12', '2022-03-16 18:42:12'),
(180, 2, 2, 4, 1, 202, 1, NULL, NULL, '2022-03-16 18:43:35', '2022-03-16 18:43:35'),
(181, 6, 2, 9, 1, 203, 1, NULL, NULL, '2022-03-16 19:14:01', '2022-03-16 19:14:01'),
(182, 2, 2, 3, 1, 204, 1, NULL, NULL, '2022-03-16 19:18:04', '2022-03-16 19:18:04'),
(183, 6, 2, 9, 1, 205, 1, NULL, NULL, '2022-03-16 21:14:46', '2022-03-16 21:14:46'),
(184, 2, 3, 2, 1, 206, 1, NULL, NULL, '2022-03-16 21:16:49', '2022-03-16 21:16:49'),
(185, 6, 1, 9, 1, 207, 1, NULL, NULL, '2022-03-16 21:34:52', '2022-03-16 21:34:52'),
(186, 6, 1, 10, 1, 208, 1, NULL, NULL, '2022-03-17 00:32:34', '2022-03-17 00:32:34'),
(187, 2, 3, 3, 1, 209, 1, NULL, NULL, '2022-03-17 00:34:44', '2022-03-17 00:34:44'),
(188, 2, 2, 7, 1, 210, 1, NULL, NULL, '2022-03-17 00:37:02', '2022-03-17 00:37:02'),
(189, 6, 3, 9, 1, 211, 1, NULL, NULL, '2022-03-17 00:41:35', '2022-03-17 00:41:35'),
(190, 2, 2, 4, 1, 212, 1, NULL, NULL, '2022-03-17 01:00:16', '2022-03-17 01:00:16'),
(191, 6, 2, 9, 1, 213, 1, NULL, NULL, '2022-03-17 15:26:53', '2022-03-17 15:26:53'),
(192, 6, 4, 10, 1, 214, 1, NULL, NULL, '2022-03-17 16:22:02', '2022-03-17 16:22:02'),
(193, 6, 1, 10, 1, 215, 1, NULL, NULL, '2022-03-17 16:27:14', '2022-03-17 16:27:14'),
(194, 2, 3, 3, 1, 216, 1, NULL, NULL, '2022-03-17 16:31:14', '2022-03-17 16:31:14'),
(195, 2, 2, 4, 1, 217, 1, NULL, NULL, '2022-03-17 16:34:45', '2022-03-17 16:34:45'),
(196, 6, 2, 10, 1, 218, 1, NULL, NULL, '2022-03-17 16:35:20', '2022-03-17 16:35:20'),
(197, 2, 3, 7, 1, 219, 1, NULL, NULL, '2022-03-17 17:07:17', '2022-03-17 17:07:17'),
(198, 6, 3, 10, 1, 220, 1, NULL, NULL, '2022-03-17 17:16:05', '2022-03-17 17:16:05'),
(199, 6, 2, 10, 1, 221, 1, NULL, NULL, '2022-03-17 17:23:15', '2022-03-17 17:23:15'),
(200, 6, 2, 10, 1, 222, 1, NULL, NULL, '2022-03-17 17:25:36', '2022-03-17 17:25:36'),
(201, 2, 3, 3, 1, 223, 1, NULL, NULL, '2022-03-18 13:04:37', '2022-03-18 13:04:37'),
(202, 6, 3, 9, 1, 224, 1, NULL, NULL, '2022-03-18 13:07:20', '2022-03-18 13:07:20'),
(203, 2, 4, 8, 1, 225, 1, NULL, NULL, '2022-03-18 13:10:42', '2022-03-18 13:10:42'),
(204, 6, 2, 9, 1, 226, 1, NULL, NULL, '2022-03-18 15:00:27', '2022-03-18 15:00:27'),
(205, 2, 3, 3, 1, 227, 1, NULL, NULL, '2022-03-18 15:01:17', '2022-03-18 15:01:17'),
(206, 2, 2, 2, 1, 228, 1, NULL, NULL, '2022-03-18 15:02:53', '2022-03-18 15:02:53'),
(207, 2, 1, 8, 1, 229, 1, NULL, NULL, '2022-03-18 15:41:06', '2022-03-18 15:41:06'),
(208, 6, 2, 9, 1, 230, 1, NULL, NULL, '2022-03-18 15:43:55', '2022-03-18 15:43:55'),
(209, 2, 3, 8, 1, 231, 1, NULL, NULL, '2022-03-18 15:46:44', '2022-03-18 15:46:44'),
(210, 2, 3, 7, 1, 232, 1, NULL, NULL, '2022-03-18 15:58:12', '2022-03-18 15:58:12'),
(211, 2, 3, 8, 1, 233, 1, NULL, NULL, '2022-03-18 16:02:18', '2022-03-18 16:02:18'),
(212, 6, 3, 9, 1, 234, 1, NULL, NULL, '2022-03-18 16:06:30', '2022-03-18 16:06:30'),
(213, 2, 3, 3, 1, 235, 1, NULL, NULL, '2022-03-18 16:11:04', '2022-03-18 16:11:04'),
(214, 2, 3, 2, 1, 236, 1, NULL, NULL, '2022-03-18 16:15:32', '2022-03-18 16:15:32'),
(215, 2, 3, 8, 1, 237, 1, NULL, NULL, '2022-03-18 16:20:35', '2022-03-18 16:20:35'),
(216, 2, 2, 8, 1, 238, 1, NULL, NULL, '2022-03-18 16:25:28', '2022-03-18 16:25:28'),
(217, 2, 3, 3, 1, 239, 1, NULL, NULL, '2022-03-18 16:30:26', '2022-03-18 16:30:26'),
(218, 2, 2, 3, 1, 240, 1, NULL, NULL, '2022-03-18 16:41:14', '2022-03-18 16:41:14'),
(219, 2, 3, 7, 1, 241, 1, NULL, NULL, '2022-03-18 16:58:11', '2022-03-18 16:58:11'),
(220, 2, 3, 8, 1, 242, 1, NULL, NULL, '2022-03-18 17:06:47', '2022-03-18 17:06:47'),
(221, 6, 2, 9, 1, 243, 1, NULL, NULL, '2022-03-18 17:08:52', '2022-03-18 17:08:52'),
(222, 6, 3, 9, 1, 244, 1, NULL, NULL, '2022-03-18 17:27:38', '2022-03-18 17:27:38');
/*!40000 ALTER TABLE `ticket_histories` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.ticket_views
CREATE TABLE IF NOT EXISTS `ticket_views` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`view` int(11) NOT NULL,
`ticket_id` bigint(20) unsigned DEFAULT NULL,
`helpdesk_id` bigint(20) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.ticket_views: ~30 rows (approximately)
/*!40000 ALTER TABLE `ticket_views` DISABLE KEYS */;
INSERT INTO `ticket_views` (`id`, `view`, `ticket_id`, `helpdesk_id`, `created_at`, `updated_at`) VALUES
(1, 17, 82, 1, '2022-01-31 13:45:29', '2022-02-01 14:23:48'),
(2, 5, 82, 13, '2022-01-31 13:49:35', '2022-02-01 09:41:59'),
(3, 3, 71, 1, '2022-01-31 14:12:10', '2022-01-31 14:17:35'),
(4, 8, 68, 1, '2022-01-31 14:17:57', '2022-02-02 00:02:21'),
(5, 3, 82, 5, '2022-02-01 09:37:09', '2022-02-01 09:44:30'),
(6, 1, 79, 1, '2022-02-01 10:06:59', '2022-02-01 10:06:59'),
(7, 36, 80, 1, '2022-02-01 10:07:18', '2022-02-03 13:53:38'),
(8, 1, 80, 5, '2022-02-01 10:08:08', '2022-02-01 10:08:08'),
(9, 2, 93, 1, '2022-02-01 13:55:10', '2022-02-11 16:17:18'),
(10, 41, 95, 1, '2022-02-01 15:18:22', '2022-02-11 16:17:02'),
(11, 24, 96, 1, '2022-02-01 15:43:02', '2022-02-11 11:03:07'),
(12, 4, 96, 5, '2022-02-01 15:46:30', '2022-02-01 16:06:19'),
(13, 3, 68, 5, '2022-02-01 16:06:33', '2022-02-01 16:07:12'),
(14, 1, 93, 5, '2022-02-01 16:07:41', '2022-02-01 16:07:41'),
(15, 11, 81, 1, '2022-02-01 21:49:17', '2022-02-02 18:01:26'),
(16, 29, 97, 1, '2022-02-02 10:22:14', '2022-02-03 22:53:21'),
(17, 10, 97, 5, '2022-02-02 11:31:21', '2022-02-02 16:31:03'),
(18, 3, 73, 1, '2022-02-02 11:40:48', '2022-02-02 11:41:46'),
(19, 2, 97, 16, '2022-02-02 14:18:53', '2022-02-11 11:13:12'),
(20, 6, 91, 1, '2022-02-02 16:32:58', '2022-02-02 16:35:37'),
(21, 8, NULL, 1, '2022-02-02 17:45:13', '2022-02-02 17:56:05'),
(22, 66, 98, 1, '2022-02-03 21:06:25', '2022-02-07 14:47:03'),
(23, 25, 102, 1, '2022-02-04 15:43:15', '2022-02-11 11:02:50'),
(24, 4, 125, 1, '2022-02-08 16:29:51', '2022-02-08 16:31:26'),
(25, 75, 106, 1, '2022-02-08 22:13:17', '2022-02-09 13:03:40'),
(26, 93, 136, 1, '2022-02-09 14:04:59', '2022-02-10 14:16:05'),
(27, 3, 136, 16, '2022-02-10 12:31:38', '2022-02-11 11:12:21'),
(28, 2, 136, 13, '2022-02-10 12:33:17', '2022-02-10 12:33:36'),
(29, 16, 136, 6, '2022-02-10 12:34:22', '2022-02-11 11:27:45'),
(30, 1, 91, 6, '2022-02-11 11:25:11', '2022-02-11 11:25:11'),
(31, 4, 137, 1, '2022-02-11 16:14:35', '2022-02-11 17:02:03'),
(32, 37, 145, 1, '2022-02-17 12:05:08', '2022-02-25 16:41:59');
/*!40000 ALTER TABLE `ticket_views` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.tipos
CREATE TABLE IF NOT EXISTS `tipos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.tipos: ~4 rows (approximately)
/*!40000 ALTER TABLE `tipos` DISABLE KEYS */;
INSERT INTO `tipos` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Problema', NULL, NULL, NULL),
(2, 'Dúvida', NULL, NULL, NULL),
(3, 'Sugestão', NULL, NULL, NULL),
(4, 'Outro', NULL, NULL, NULL);
/*!40000 ALTER TABLE `tipos` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.users
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` datetime DEFAULT NULL,
`departments_id` bigint(20) unsigned DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.users: ~1 rows (approximately)
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `departments_id`, `password`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(5, 'Ivo Naftal', 'naftalivo@gmail.com', NULL, 2, '$2y$10$XiJoTRD4zNQV/5yJ10XzreRAfFsF/qsEMIn0blikVZ./qjNobgilW', NULL, '2022-01-17 08:02:18', '2022-02-11 17:01:16', NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
-- Dumping structure for table helpdesksupport.user_departs
CREATE TABLE IF NOT EXISTS `user_departs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`users_id` int(10) unsigned DEFAULT NULL,
`departments_id` int(10) unsigned DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.user_departs: ~10 rows (approximately)
/*!40000 ALTER TABLE `user_departs` DISABLE KEYS */;
INSERT INTO `user_departs` (`id`, `users_id`, `departments_id`, `created_at`, `updated_at`) VALUES
(1, 10, 3, '2022-01-26 21:14:08', '2022-01-26 21:14:08'),
(3, 1, 5, NULL, NULL),
(4, 2, 4, NULL, NULL),
(5, 5, 2, NULL, NULL),
(6, 6, 2, NULL, NULL),
(7, 8, 5, NULL, NULL),
(8, 9, 2, NULL, NULL),
(9, 13, 2, '2022-01-27 12:03:14', '2022-01-27 12:03:14'),
(10, 14, 3, '2022-01-27 12:20:40', '2022-01-27 12:20:40'),
(11, 15, 4, '2022-01-30 21:07:36', '2022-01-30 21:07:36'),
(12, 16, 1, '2022-02-02 12:01:54', '2022-02-02 12:01:54');
/*!40000 ALTER TABLE `user_departs` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;