IP : 18.222.164.41Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
lib/
../
softaculous/
./
beehive/
../
orange/
../
faveo/
./
faveo.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `notifications` --
CREATE TABLE `notifications` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `model_id` int NOT NULL, `userid_created` int NOT NULL, `type_id` int 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;
-- -- Table structure for table `notification_types` --
CREATE TABLE `notification_types` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 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 `notification_types` --
INSERT INTO `notification_types` VALUES (1, 'A new user is registered', 'registration', 'fa fa-user', '[[regtime]]', '[[regtime]]'), (2, 'You have a new reply on this ticket', 'reply', 'fa fa-envelope', '[[regtime]]', '[[regtime]]'), (3, 'A new ticket has been created', 'new_ticket', 'fa fa-envelope', '[[regtime]]', '[[regtime]]');
CREATE TABLE `ratings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `display_order` int NOT NULL, `allow_modification` int NOT NULL, `rating_scale` int NOT NULL, `rating_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restrict` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 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;
CREATE TABLE `rating_ref` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `rating_id` int NOT NULL, `ticket_id` int NOT NULL, `thread_id` int NOT NULL, `rating_value` int 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;
-- -- Table structure for table `settings_security` --
CREATE TABLE `settings_security` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `lockout_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `backlist_offender` int NOT NULL, `backlist_threshold` int NOT NULL, `lockout_period` int NOT NULL, `days_to_keep_logs` int 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 `settings_security` --
INSERT INTO `settings_security` VALUES (1, 'You have been locked out of application due to too many failed login attempts.', 0, 15, 15, 0, '[[regtime]]', '[[regtime]]');
CREATE TABLE `templates` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `variable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` int NOT NULL, `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `set_id` int 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 `templates` --
INSERT INTO `templates` VALUES (1, 'This template is for sending notice to agent when ticket is assigned to them', '0', 1, NULL, '<div>Hello {!!$ticket_agent_name!!},<br /><br /><b>Ticket No:</b> {!!$ticket_number!!}<br />Has been assigned to you by {!!$ticket_assigner!!} <br/> Please check and resppond on the ticket.<br /> Link: {!!$ticket_link!!}<br /><br />Thank You<br />Kind Regards,<br /> {!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (2, 'This template is for sending notice to client with ticket link to check ticket without logging in to system', '1', 2, 'Check your Ticket', '<div>Hello {!!$user!!},<br/><br/>Click the link below to view your requested ticket<br/> {!!$ticket_link_with_number!!}<br/><br/>Kind Regards,<br/> {!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (3, 'This template is for sending notice to client when ticket status is changed to close', '0', 3, NULL, '<div>Hello,<br/><br/>This message is regarding your ticket ID {!!$ticket_number!!}. We are changing the status of this ticket to "Closed" as the issue appears to be resolved.<br/><br/>Thank you<br/>Kind regards,<br/> {!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (4, 'This template is for sending notice to client on successful ticket creation', '0', 4, NULL, '<div><span>Hello {!!$user!!}<br/><br/></span><span>Thank you for contacting us. This is an automated response confirming the receipt of your ticket. Our team will get back to you as soon as possible. When replying, please make sure that the ticket ID is kept in the subject so that we can track your replies.<br/><br/></span><span><b>Ticket ID:</b> {!!$ticket_number!!} <br/><br/></span><span> {!!$department_sign!!}<br/></span>You can check the status of or update this ticket online at: {!!$system_link!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (5, 'This template is for sending notice to agent on new ticket creation', '0', 5, NULL, '<div>Hello {!!$ticket_agent_name!!},<br/><br/>New ticket {!!$ticket_number!!}created <br/><br/><b>From</b><br/><b>Name:</b> {!!$ticket_client_name!!} <br/><b>E-mail:</b> {!!$ticket_client_email!!}<br/><br/> {!!$content!!}<br/><br/>Kind Regards,<br/> {!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (6, 'This template is for sending notice to client on new ticket created by agent in name of client', '0', 6, NULL, '<div> {!!$content!!}<br><br> {!!$agent_sign!!}<br><br>You can check the status of or update this ticket online at: {!!$system_link!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (7, 'This template is for sending notice to client on new registration during new ticket creation for un registered clients', '1', 7, 'Registration Confirmation', '<p>Hello {!!$user!!}, </p><p>This email is confirmation that you are now registered at our helpdesk.</p><p><b>Registered Email:</b> {!!$email_address!!}</p><p><b>Password:</b> {!!$user_password!!}</p><p>You can visit the helpdesk to browse articles and contact us at any time: {!!$system_link!!}</p><p>Thank You.</p><p>Kind Regards,</p><p> {!!$system_from!!} </p>', NULL, 1, '[[regtime]]', '[[regtime]]'), (8, 'This template is for sending notice to any user about reset password option', '1', 8, 'Reset your Password', 'Hello {!!$user!!},<br/><br/>You asked to reset your password. To do so, please click this link:<br/><br/> {!!$password_reset_link!!}<br/><br/>This will let you change your password to something new. If you didn''t ask for this, don''t worry, we''ll keep your password safe.<br/><br/>Thank You.<br/><br/>Kind Regards,<br/> {!!$system_from!!}', NULL, 1, '[[regtime]]', '[[regtime]]'), (9, 'This template is for sending notice to client when a reply made to his/her ticket', '0', 9, NULL, '<span></span><div><span></span><p> {!!$content!!}<br/></p><p> {!!$agent_sign!!} </p><p><b>Ticket Details</b></p><p><b>Ticket ID:</b> {!!$ticket_number!!}</p></div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (10, 'This template is for sending notice to agent when ticket reply is made by client on a ticket', '0', 10, NULL, '<div>Hello {!!$ticket_agent_name!!},<br/><b><br/></b>A reply been made to ticket {!!$ticket_number!!}<br/><b><br/></b><b>From<br/></b><b>Name: </b>{!!$ticket_client_name!!}<br/><b>E-mail: </b>{!!$ticket_client_email!!}<br/><b><br/></b> {!!$content!!}<br/><b><br/></b>Kind Regards,<br/> {!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (11, 'This template is for sending notice to client about registration confirmation link', '1', 11, 'Verify your email address', '<p>Hello {!!$user!!}, </p><p>This email is confirmation that you are now registered at our helpdesk.</p><p><b>Registered Email:</b> {!!$email_address!!}</p><p>Please click on the below link to activate your account and Login to the system {!!$password_reset_link!!}</p><p>Thank You.</p><p>Kind Regards,</p><p> {!!$system_from!!} </p>', NULL, 1, '[[regtime]]', '[[regtime]]'), (12, 'This template is for sending notice to team when ticket is assigned to team', '1', 12, NULL, '<div>Hello {!!$ticket_agent_name!!},<br /><br /><b>Ticket No:</b> {!!$ticket_number!!}<br />Has been assigned to your team : {!!$team!!} by {!!$ticket_assigner!!} <br /><br />Thank You<br />Kind Regards,<br />{!!$system_from!!}</div>', NULL, 1, '[[regtime]]', '[[regtime]]'), (13, 'This template is for sending notice to client when password is changed', '1', 13, 'Verify your email address', 'Hello {!!$user!!},<br /><br />Your password is successfully changed.Your new password is : {!!$user_password!!}<br /><br />Thank You.<br /><br />Kind Regards,<br /> {!!$system_from!!}', NULL, 1, '[[regtime]]', '[[regtime]]'), (14, 'This template is to notify users when their tickets are merged.', '1', 14, 'Your tickets have been merged.', '<p>Hello {!!$user!!},<br /> </p><p>Your ticket(s) with ticket number {!!$merged_ticket_numbers!!} have been closed and merged with <a href="{!!$ticket_link!!}">{!!$ticket_number!!}</a>. </p><p>Possible reasons for merging tickets</p><ul><li>Tickets are duplicate</li<li>Tickets state the same issue</li><li>Another member from your organization has created a ticket for the same issue</li></ul><p><a href="{!!$system_link!!}">Click here</a> to login to your account and check your tickets.</p><p>Regards,</p><p>{!!$system_from!!}</p>', NULL, 1, '[[regtime]]', '[[regtime]]');
-- -- Table structure for table `ticket_status` --
CREATE TABLE `ticket_status` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mode` int NOT NULL, `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `flags` int NOT NULL, `sort` int NOT NULL, `email_user` int DEFAULT NULL, `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `properties` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 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 `ticket_status` --
INSERT INTO `ticket_status` VALUES (1, 'Open', 'open', 3, 'Ticket have been Reopened by', 0, 1, NULL, NULL, 'Open tickets.', '[[regtime]]', '[[regtime]]'), (2, 'Resolved', 'closed', 1, 'Ticket have been Resolved by', 0, 2, NULL, NULL, 'Resolved tickets.', '[[regtime]]', '[[regtime]]'), (3, 'Closed', 'closed', 3, 'Ticket have been Closed by', 0, 3, NULL, NULL, 'Closed tickets. Tickets will still be accessible on client and staff panels.', '[[regtime]]', '[[regtime]]'), (4, 'Archived', 'archived', 3, 'Ticket have been Archived by', 0, 4, NULL, NULL, 'Tickets only adminstratively available but no longer accessible on ticket queues and client panel.', '[[regtime]]', '[[regtime]]'), (5, 'Deleted', 'deleted', 3, 'Ticket have been Deleted by', 0, 5, NULL, NULL, 'Tickets queued for deletion. Not accessible on ticket queues.', '[[regtime]]', '[[regtime]]'), (6, 'Unverified', 'unverified', 3, 'User account verification required.', 0, 6, NULL, NULL, 'Ticket will be open after user verifies his/her account.', '[[regtime]]', '[[regtime]]'), (7, 'Request Approval', 'unverified', 3, 'Approval requested by', 0, 7, NULL, NULL, 'Ticket will be approve after Admin verifies this ticket', '[[regtime]]', '[[regtime]]');
-- -- Table structure for table `user_notification` --
CREATE TABLE `user_notification` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `notification_id` int NOT NULL, `user_id` int NOT NULL, `is_read` int 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;
-- -- Table structure for table `workflow_close` --
CREATE TABLE `workflow_close` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `days` int NOT NULL, `condition` int NOT NULL, `send_email` int NOT NULL, `status` int 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;
-- -- Table structure for table `workflow_name` --
CREATE TABLE `workflow_name` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int NOT NULL, `order` int NOT NULL, `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `internal_note` text COLLATE utf8mb4_unicode_ci 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;
-- -- Constraints for table `ticket_attachment` -- ALTER TABLE `ticket_attachment` ADD CONSTRAINT `ticket_attachment_ibfk_1` FOREIGN KEY (`thread_id`) REFERENCES `ticket_thread` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `ticket_collaborator` -- ALTER TABLE `ticket_collaborator` ADD CONSTRAINT `ticket_collaborator_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE RESTRICT, ADD CONSTRAINT `ticket_collaborator_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `ticket_form_data` -- ALTER TABLE `ticket_form_data` ADD CONSTRAINT `ticket_form_data_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `ticket_thread` -- ALTER TABLE `ticket_thread` ADD CONSTRAINT `ticket_thread_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE RESTRICT, ADD CONSTRAINT `ticket_thread_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT, ADD CONSTRAINT `ticket_thread_ibfk_3` FOREIGN KEY (`source`) REFERENCES `ticket_source` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`assign_group`) REFERENCES `groups` (`id`) ON DELETE RESTRICT, ADD CONSTRAINT `users_ibfk_2` FOREIGN KEY (`primary_dpt`) REFERENCES `department` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `user_assign_organization` -- ALTER TABLE `user_assign_organization` ADD CONSTRAINT `user_assign_organization_ibfk_1` FOREIGN KEY (`org_id`) REFERENCES `organization` (`id`) ON DELETE RESTRICT, ADD CONSTRAINT `user_assign_organization_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `workflow_action` -- ALTER TABLE `workflow_action` ADD CONSTRAINT `workflow_action_1` FOREIGN KEY (`workflow_id`) REFERENCES `workflow_name` (`id`) ON DELETE RESTRICT;
-- -- Constraints for table `workflow_rules` -- ALTER TABLE `workflow_rules` ADD CONSTRAINT `workflow_rules_1` FOREIGN KEY (`workflow_id`) REFERENCES `workflow_name` (`id`) ON DELETE RESTRICT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;