-- --------------------------------------------------------
-- 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=158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.audit_logs: ~124 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');
/*!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=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.email_clients: ~20 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);
/*!40000 ALTER TABLE `email_clients` 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=30 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);
/*!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,
`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=171 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.tickets: ~48 rows (approximately)
/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
INSERT INTO `tickets` (`id`, `title`, `phone`, `imali_account`, `departments_id`, `tipos_id`, `content`, `gender`, `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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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, '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', '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', 'Wilma', 'naftalivo@gmail.com', NULL, '2022-03-15 11:25:37', '2022-03-15 11:25:37', NULL, 1, 1, 11, 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=168 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table helpdesksupport.ticket_histories: ~150 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');
/*!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: ~10 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
(1, 'Admin', 'imali.helps@gmail.com', NULL, 1, '$2y$10$K.ZdGqjJ6GBQxXXGPXnDO.qJeJTMq9ns9I1z/c4JISPfTChoMESHa', 'ZSaoLM9pB5FiR9rGjGKHqSXt4Larj9xs3V4HC7iUqDupP2q7h6Z88U2boYjS', NULL, '2022-02-15 17:16:23', NULL),
(2, 'Miguel Macamo', 'miguelmacamo9@gmail.com', NULL, 2, '$2y$10$i9ohZ3j67DPJQWXmGfGz.O2zdNapVIH227l5odmlthVv4Kke2sZLG', NULL, NULL, '2022-02-02 11:58:04', NULL),
(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),
(6, 'Rodrigues Mafumo', 'mafumorodrigues@gmail.com', NULL, 2, '$2y$10$EyYD40SBoZ78yQHmIMMOSeJ5jlZ1mdim/SkAGKi5lu/tfUlz9R84K', NULL, '2022-01-17 20:39:24', '2022-02-02 11:47:34', NULL),
(8, 'João Gaspar', 'joao.gaspar@paytek-africa.com', NULL, 5, '$2y$10$h3.zL5EU96VUZW69uYboHOCFeiyimTo1Hx9F2HHC9W8o8u6scrDxO', NULL, '2022-01-26 08:24:42', '2022-01-26 12:37:49', NULL),
(9, 'Assist Tecnica', 'tecnica@gmail.com', NULL, 4, '$2y$10$jIoahdamP6peKs7Ok62tpeQqBIu.AlS.faN1XBnf7AT3F6OsN7mXS', NULL, '2022-01-26 13:32:26', '2022-02-02 11:57:17', NULL),
(10, 'Parcerias', 'parcerias@gmail.com', NULL, 3, '$2y$10$1DfFKUXH.iTy8qDRrL7Leemtkvpeeb62qqXagbppgHJQ78wjKBkY2', NULL, '2022-01-26 21:14:08', '2022-02-02 11:55:30', NULL),
(13, 'Depart Chefe', 'paytek@gmail.com', NULL, 2, '$2y$10$B/a5S90a12OhaX2CXjq85.MGpg7iwHkY1ru2FfEeUlvMrg1c0tfD.', NULL, '2022-01-27 12:03:14', '2022-02-02 11:54:58', NULL),
(14, 'Gerson Zandamela', 'gerson.zandamela@paytek-africa.com', NULL, 3, '$2y$10$p.FIAoxZy39eEVGhirBjsuGa7.OMQ6z2hiudNTTElKg9ts3jn8hkq', NULL, '2022-01-27 12:20:40', '2022-02-02 11:45:26', NULL),
(15, 'Muhammad Machado', 'muhmachado90@gmail.com', NULL, 6, '$2y$10$ucqaDKWXczMKagngw3bUbuiodRTISopK2yhUQX4AHJxSRvMQfczYG', NULL, '2022-01-30 21:07:36', '2022-02-02 11:54:02', NULL),
(16, 'Help Desk', 'helpdesk@gmail.com', NULL, 1, '$2y$10$f5/iVtyPn9uZ2xZDhVrZae9tTTXg3UJP6K6jR9GhnKZfgOSRiSLOK', NULL, '2022-02-02 12:01:54', '2022-02-02 12:01:54', 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) */;