-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.7.33 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------

/*!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 hgagent.permissions
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) 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=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table hgagent.permissions: ~197 rows (approximately)
DELETE FROM `permissions`;
/*!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, 'employee_create', NULL, NULL, NULL),
	(18, 'employee_edit', NULL, NULL, NULL),
	(19, 'employee_show', NULL, NULL, NULL),
	(20, 'employee_delete', NULL, NULL, NULL),
	(21, 'employee_access', NULL, NULL, NULL),
	(22, 'agent_create', NULL, NULL, NULL),
	(23, 'agent_edit', NULL, NULL, NULL),
	(24, 'agent_show', NULL, NULL, NULL),
	(25, 'agent_delete', NULL, NULL, NULL),
	(26, 'agent_access', NULL, NULL, NULL),
	(27, 'audit_log_show', NULL, NULL, NULL),
	(28, 'audit_log_access', NULL, NULL, NULL),
	(29, 'customer_create', NULL, NULL, NULL),
	(30, 'customer_edit', NULL, NULL, NULL),
	(31, 'customer_show', NULL, NULL, NULL),
	(32, 'customer_delete', NULL, NULL, NULL),
	(33, 'customer_access', NULL, NULL, NULL),
	(34, 'master_access', NULL, NULL, NULL),
	(35, 'store_create', NULL, NULL, NULL),
	(36, 'store_edit', NULL, NULL, NULL),
	(37, 'store_show', NULL, NULL, NULL),
	(38, 'store_delete', NULL, NULL, NULL),
	(39, 'store_access', NULL, NULL, NULL),
	(40, 'product_create', NULL, NULL, NULL),
	(41, 'product_edit', NULL, NULL, NULL),
	(42, 'product_show', NULL, NULL, NULL),
	(43, 'product_delete', NULL, NULL, NULL),
	(44, 'product_access', NULL, NULL, NULL),
	(45, 'product_store_create', NULL, NULL, NULL),
	(46, 'product_store_edit', NULL, NULL, NULL),
	(47, 'product_store_show', NULL, NULL, NULL),
	(48, 'product_store_delete', NULL, NULL, NULL),
	(49, 'product_store_access', NULL, NULL, NULL),
	(50, 'category_create', NULL, NULL, NULL),
	(51, 'category_edit', NULL, NULL, NULL),
	(52, 'category_show', NULL, NULL, NULL),
	(53, 'category_delete', NULL, NULL, NULL),
	(54, 'category_access', NULL, NULL, NULL),
	(55, 'payment_term_create', NULL, NULL, NULL),
	(56, 'payment_term_edit', NULL, NULL, NULL),
	(57, 'payment_term_show', NULL, NULL, NULL),
	(58, 'payment_term_delete', NULL, NULL, NULL),
	(59, 'payment_term_access', NULL, NULL, NULL),
	(60, 'sales_order_create', NULL, NULL, NULL),
	(61, 'sales_order_edit', NULL, NULL, NULL),
	(62, 'sales_order_show', NULL, NULL, NULL),
	(63, 'sales_order_delete', NULL, NULL, NULL),
	(64, 'sales_order_access', NULL, NULL, NULL),
	(65, 'sales_order_item_create', NULL, NULL, NULL),
	(66, 'sales_order_item_edit', NULL, NULL, NULL),
	(67, 'sales_order_item_show', NULL, NULL, NULL),
	(68, 'sales_order_item_delete', NULL, NULL, NULL),
	(69, 'sales_order_item_access', NULL, NULL, NULL),
	(70, 'billing_address_create', NULL, NULL, NULL),
	(71, 'billing_address_edit', NULL, NULL, NULL),
	(72, 'billing_address_show', NULL, NULL, NULL),
	(73, 'billing_address_delete', NULL, NULL, NULL),
	(74, 'billing_address_access', NULL, NULL, NULL),
	(75, 'shipping_address_create', NULL, NULL, NULL),
	(76, 'shipping_address_edit', NULL, NULL, NULL),
	(77, 'shipping_address_show', NULL, NULL, NULL),
	(78, 'shipping_address_delete', NULL, NULL, NULL),
	(79, 'purchase_order_access', NULL, NULL, NULL),
	(80, 'purchase_order_create', NULL, NULL, NULL),
	(81, 'purchase_order_edit', NULL, NULL, NULL),
	(82, 'purchase_order_show', NULL, NULL, NULL),
	(83, 'purchase_order_delete', NULL, NULL, NULL),
	(84, 'profile_password_edit', NULL, NULL, NULL),
	(85, 'agent_approve', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(86, 'agent_reject', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(87, 'agent_abandon', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(88, 'agent_recover', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(89, 'agent_code_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(90, 'agent_code_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(91, 'agent_code_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(92, 'agent_code_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(93, 'agent_code_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(94, 'grade_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(95, 'grade_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(96, 'grade_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(97, 'grade_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(98, 'grade_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(99, 'referral_fee_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(100, 'referral_fee_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(101, 'referral_fee_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(102, 'referral_fee_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(103, 'referral_fee_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(104, 'bank_code_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(105, 'bank_code_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(106, 'bank_code_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(107, 'bank_code_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(108, 'bank_code_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(109, 'hq_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(110, 'purchase_order_print', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(111, 'sales_order_approve', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(112, 'sales_order_print', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(113, 'series_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(114, 'series_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(115, 'series_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(116, 'series_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(117, 'series_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(118, 'warehouse_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(119, 'warehouse_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(120, 'warehouse_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(121, 'warehouse_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(122, 'warehouse_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(123, 'picking_list_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(124, 'picking_list_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(125, 'picking_list_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(126, 'picking_list_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(127, 'picking_list_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(128, 'picking_list_validate', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(129, 'picking_list_print', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(130, 'warehouse_picking_list_data_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(131, 'warehouse_picking_list_data_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(132, 'warehouse_picking_list_data_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(133, 'warehouse_picking_list_data_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(134, 'warehouse_picking_list_data_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(135, 'warehouse_picking_list_data_complete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(136, 'agent_reject_list_data_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(137, 'agent_reject_list_data_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(138, 'agent_reject_list_data_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(139, 'agent_reject_list_data_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(140, 'agent_reject_list_data_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(141, 'agent_reject_list_data_complete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(142, 'available_store_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(143, 'available_store_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(144, 'available_store_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(145, 'available_store_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(146, 'available_store_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(147, 'delivery_order_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(148, 'delivery_order_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(149, 'delivery_order_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(150, 'delivery_order_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(151, 'delivery_order_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(152, 'delivery_order_print', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(153, 'delivery_order_group', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(154, 'store_audit_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(155, 'store_audit_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(156, 'store_audit_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(157, 'store_audit_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(158, 'store_audit_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(159, 'promoter_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(160, 'promoter_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(161, 'promoter_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(162, 'promoter_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(163, 'promoter_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(164, 'promoter_task_management_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(165, 'promoter_task_list_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(166, 'promoter_task_list_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(167, 'promoter_task_list_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(168, 'promoter_task_list_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(169, 'promoter_task_list_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(170, 'promoter_task_list_print', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(171, 'promoter_task_list_clock_in_out', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(172, 'sales_invoice_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(173, 'sales_invoice_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(174, 'sales_invoice_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(175, 'sales_invoice_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(176, 'sales_invoice_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(177, 'merchandise_management_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(178, 'merchandise_report_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(179, 'merchandise_category_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(180, 'merchandise_category_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(181, 'merchandise_category_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(182, 'merchandise_category_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(183, 'merchandise_category_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(184, 'invoice_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(185, 'invoice_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(186, 'invoice_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(187, 'invoice_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(188, 'invoice_sort_item', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(189, 'invoice_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(190, 'time_entry_create', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(191, 'time_entry_edit', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(192, 'time_entry_show', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(193, 'time_entry_validate', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(194, 'time_entry_delete', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(195, 'time_entry_access', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(196, 'promoter_task_list_fill_quantity', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL),
	(197, 'promoter_task_list_upload_pdf', '2022-04-29 10:20:34', '2022-04-29 10:20:34', NULL);
/*!40000 ALTER TABLE `permissions` 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) */;
