-- -------------------------------------------------------- -- 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=199 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- Dumping data for table hgagent.permissions: ~198 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-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (86, 'agent_reject', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (87, 'agent_abandon', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (88, 'agent_recover', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (89, 'agent_code_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (90, 'agent_code_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (91, 'agent_code_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (92, 'agent_code_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (93, 'agent_code_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (94, 'grade_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (95, 'grade_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (96, 'grade_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (97, 'grade_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (98, 'grade_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (99, 'referral_fee_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (100, 'referral_fee_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (101, 'referral_fee_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (102, 'referral_fee_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (103, 'referral_fee_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (104, 'bank_code_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (105, 'bank_code_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (106, 'bank_code_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (107, 'bank_code_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (108, 'bank_code_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (109, 'hq_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (110, 'purchase_order_print', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (111, 'sales_order_approve', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (112, 'sales_order_print', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (113, 'series_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (114, 'series_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (115, 'series_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (116, 'series_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (117, 'series_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (118, 'warehouse_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (119, 'warehouse_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (120, 'warehouse_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (121, 'warehouse_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (122, 'warehouse_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (123, 'picking_list_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (124, 'picking_list_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (125, 'picking_list_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (126, 'picking_list_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (127, 'picking_list_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (128, 'picking_list_validate', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (129, 'picking_list_print', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (130, 'picking_list_start', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (131, 'warehouse_picking_list_data_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (132, 'warehouse_picking_list_data_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (133, 'warehouse_picking_list_data_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (134, 'warehouse_picking_list_data_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (135, 'warehouse_picking_list_data_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (136, 'warehouse_picking_list_data_complete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (137, 'agent_reject_list_data_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (138, 'agent_reject_list_data_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (139, 'agent_reject_list_data_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (140, 'agent_reject_list_data_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (141, 'agent_reject_list_data_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (142, 'agent_reject_list_data_complete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (143, 'available_store_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (144, 'available_store_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (145, 'available_store_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (146, 'available_store_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (147, 'available_store_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (148, 'delivery_order_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (149, 'delivery_order_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (150, 'delivery_order_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (151, 'delivery_order_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (152, 'delivery_order_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (153, 'delivery_order_print', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (154, 'delivery_order_group', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (155, 'store_audit_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (156, 'store_audit_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (157, 'store_audit_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (158, 'store_audit_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (159, 'store_audit_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (160, 'promoter_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (161, 'promoter_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (162, 'promoter_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (163, 'promoter_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (164, 'promoter_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (165, 'promoter_task_management_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (166, 'promoter_task_list_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (167, 'promoter_task_list_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (168, 'promoter_task_list_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (169, 'promoter_task_list_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (170, 'promoter_task_list_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (171, 'promoter_task_list_print', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (172, 'promoter_task_list_clock_in_out', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (173, 'sales_invoice_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (174, 'sales_invoice_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (175, 'sales_invoice_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (176, 'sales_invoice_show', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (177, 'sales_invoice_delete', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (178, 'merchandise_management_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (179, 'merchandise_report_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (180, 'merchandise_category_access', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (181, 'merchandise_category_create', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (182, 'merchandise_category_edit', '2022-05-05 04:27:31', '2022-05-05 04:27:31', NULL), (183, 'merchandise_category_show', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (184, 'merchandise_category_delete', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (185, 'invoice_access', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (186, 'invoice_create', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (187, 'invoice_edit', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (188, 'invoice_show', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (189, 'invoice_sort_item', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (190, 'invoice_delete', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (191, 'time_entry_create', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (192, 'time_entry_edit', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (193, 'time_entry_show', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (194, 'time_entry_validate', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (195, 'time_entry_delete', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (196, 'time_entry_access', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (197, 'promoter_task_list_fill_quantity', '2022-05-05 04:27:32', '2022-05-05 04:27:32', NULL), (198, 'promoter_task_list_upload_pdf', '2022-05-05 04:27:32', '2022-05-05 04:27:32', 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) */;