-- Table structure for employee_loans_status
-- ----------------------------
CREATE TABLE `employee_loans_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_loans_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_loans_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_loans_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_loans_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_loans_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_loans_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_loans_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_loans_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_loans_status
-- ----------------------------
INSERT INTO `employee_loans_status` VALUES (1, 'قيد التحصيل', '1', 'Pending', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `employee_loans_status` VALUES (2, 'سددت', '2', 'Paid', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `employee_loans_status` VALUES (3, 'اجلت', '3', 'Deferral', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `employee_loans_status` VALUES (4, 'قسمت', '4', 'Splited', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);

-- ----------------------------
-- Table structure for employee_old_balances
-- ----------------------------
CREATE TABLE `employee_old_balances`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `date` date NULL DEFAULT NULL,
  `balance` double NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_old_balances_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_old_balances_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_old_balances_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_old_balances_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_old_balances_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_old_balances_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_old_balances_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_old_balances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_old_balances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_old_balances_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_old_balances
-- ----------------------------

-- ----------------------------
-- Table structure for employee_penalties
-- ----------------------------
CREATE TABLE `employee_penalties`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `employee_penalties_group_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_penalties_employee_penalties_group_id_foreign`(`employee_penalties_group_id` ASC) USING BTREE,
  INDEX `employee_penalties_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_penalties_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_penalties_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_penalties_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_penalties_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_employee_penalties_group_id_foreign` FOREIGN KEY (`employee_penalties_group_id`) REFERENCES `employee_penalties_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_penalties
-- ----------------------------

-- ----------------------------
-- Table structure for employee_penalties_asserts
-- ----------------------------
CREATE TABLE `employee_penalties_asserts`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `employee_penaltie_id` int UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_penalties_asserts_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_penalties_asserts_employee_penaltie_id_foreign`(`employee_penaltie_id` ASC) USING BTREE,
  INDEX `employee_penalties_asserts_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_penalties_asserts_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_penalties_asserts_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_penalties_asserts_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_penalties_asserts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_asserts_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_asserts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_asserts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_asserts_employee_penaltie_id_foreign` FOREIGN KEY (`employee_penaltie_id`) REFERENCES `employee_penalties` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_asserts_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_penalties_asserts
-- ----------------------------

-- ----------------------------
-- Table structure for employee_penalties_groups
-- ----------------------------
CREATE TABLE `employee_penalties_groups`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `main_child_zeros` double NULL DEFAULT 10,
  `main_child_counter` double NULL DEFAULT NULL,
  `sub_child_zeros` double NULL DEFAULT 1000,
  `sub_child_counter` double NULL DEFAULT NULL,
  `employee_penalties_group_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_penalties_groups_employee_penalties_group_id_foreign`(`employee_penalties_group_id` ASC) USING BTREE,
  INDEX `employee_penalties_groups_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_penalties_groups_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_penalties_groups_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_penalties_groups_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_penalties_groups_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_groups_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_groups_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_penalties_groups_employee_penalties_group_id_foreign` FOREIGN KEY (`employee_penalties_group_id`) REFERENCES `employee_penalties_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_penalties_groups
-- ----------------------------
INSERT INTO `employee_penalties_groups` VALUES (1, 'تنبيهات', '1', 'Alerts', 10, NULL, 1000, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `employee_penalties_groups` VALUES (2, 'انذارات', '2', 'Ultimatum', 10, NULL, 1000, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for employee_permit_balances
-- ----------------------------
CREATE TABLE `employee_permit_balances`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `permit_type_id` int UNSIGNED NOT NULL,
  `balance` double NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_permit_balances_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_permit_balances_permit_type_id_foreign`(`permit_type_id` ASC) USING BTREE,
  INDEX `employee_permit_balances_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_permit_balances_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_permit_balances_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_permit_balances_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_permit_balances_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_balances_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_balances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_balances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_balances_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_balances_permit_type_id_foreign` FOREIGN KEY (`permit_type_id`) REFERENCES `permit_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_permit_balances
-- ----------------------------

-- ----------------------------
-- Table structure for employee_permit_types
-- ----------------------------
CREATE TABLE `employee_permit_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NULL DEFAULT NULL,
  `permit_type_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_permit_types_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_permit_types_permit_type_id_foreign`(`permit_type_id` ASC) USING BTREE,
  INDEX `employee_permit_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_permit_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_permit_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_permit_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_permit_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_types_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permit_types_permit_type_id_foreign` FOREIGN KEY (`permit_type_id`) REFERENCES `permit_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_permit_types
-- ----------------------------

-- ----------------------------
-- Table structure for employee_permits
-- ----------------------------
CREATE TABLE `employee_permits`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `permit_type_id` int UNSIGNED NOT NULL,
  `employee_user_id` int UNSIGNED NOT NULL,
  `get_balance_from_total_balance` int UNSIGNED NOT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_permits_permit_type_id_foreign`(`permit_type_id` ASC) USING BTREE,
  INDEX `employee_permits_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_permits_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_permits_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_permits_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_permits_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_permits_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permits_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permits_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permits_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permits_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_permits_permit_type_id_foreign` FOREIGN KEY (`permit_type_id`) REFERENCES `permit_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_permits
-- ----------------------------

-- ----------------------------
-- Table structure for employee_petty_cashs
-- ----------------------------
CREATE TABLE `employee_petty_cashs`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `from_account_id` int UNSIGNED NULL DEFAULT NULL,
  `petty_cash_id` int UNSIGNED NULL DEFAULT NULL,
  `journal_entry_id` int UNSIGNED NULL DEFAULT NULL,
  `date` date NOT NULL,
  `value` double NOT NULL,
  `collected_amount` double NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_petty_cashs_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_petty_cashs_branch_id_foreign`(`branch_id` ASC) USING BTREE,
  INDEX `employee_petty_cashs_from_account_id_foreign`(`from_account_id` ASC) USING BTREE,
  INDEX `employee_petty_cashs_petty_cash_id_foreign`(`petty_cash_id` ASC) USING BTREE,
  INDEX `employee_petty_cashs_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_petty_cashs_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_petty_cashs_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_petty_cashs_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_petty_cashs_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_from_account_id_foreign` FOREIGN KEY (`from_account_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_petty_cashs_petty_cash_id_foreign` FOREIGN KEY (`petty_cash_id`) REFERENCES `petty_cashs` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_petty_cashs
-- ----------------------------

-- ----------------------------
-- Table structure for employee_promotions
-- ----------------------------
CREATE TABLE `employee_promotions`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `value` double UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_promotions_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_promotions_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_promotions_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_promotions_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_promotions_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_promotions_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_promotions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_promotions_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_promotions
-- ----------------------------

-- ----------------------------
-- Table structure for employee_rewards
-- ----------------------------
CREATE TABLE `employee_rewards`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `reward_id` int UNSIGNED NOT NULL,
  `value` double NULL DEFAULT NULL,
  `percentage_from_main_salary` double NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `date` date NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_rewards_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_rewards_reward_id_foreign`(`reward_id` ASC) USING BTREE,
  INDEX `employee_rewards_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_rewards_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_rewards_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_rewards_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_rewards_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_rewards_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_rewards_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_rewards_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_rewards_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_rewards_reward_id_foreign` FOREIGN KEY (`reward_id`) REFERENCES `rewards` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_rewards
-- ----------------------------

-- ----------------------------
-- Table structure for employee_salaries
-- ----------------------------
CREATE TABLE `employee_salaries`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `salary_account_id` int UNSIGNED NOT NULL,
  `state_id` int UNSIGNED NULL DEFAULT NULL,
  `amount` double NOT NULL,
  `date` date NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_salaries_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_salaries_salary_account_id_foreign`(`salary_account_id` ASC) USING BTREE,
  INDEX `employee_salaries_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_salaries_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_salaries_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_salaries_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_salaries_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salaries_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salaries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salaries_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salaries_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salaries_salary_account_id_foreign` FOREIGN KEY (`salary_account_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_salaries
-- ----------------------------

-- ----------------------------
-- Table structure for employee_salary_calc_types
-- ----------------------------
CREATE TABLE `employee_salary_calc_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_salary_calc_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_salary_calc_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_salary_calc_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_salary_calc_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_salary_calc_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_calc_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_calc_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_calc_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_salary_calc_types
-- ----------------------------
INSERT INTO `employee_salary_calc_types` VALUES (1, 'حسب البصمة', '1', 'By finger print', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:54', '2025-06-12 14:05:54', NULL);
INSERT INTO `employee_salary_calc_types` VALUES (2, 'بدون بصمة', '2', 'Without finger print', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:54', '2025-06-12 14:05:54', NULL);

-- ----------------------------
-- Table structure for employee_salary_cutoffs
-- ----------------------------
CREATE TABLE `employee_salary_cutoffs`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `salary_cutoff_id` int UNSIGNED NOT NULL,
  `employee_user_id` int UNSIGNED NOT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `value` double NOT NULL,
  `from_date` date NULL DEFAULT NULL,
  `to_date` date NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_salary_cutoffs_salary_cutoff_id_foreign`(`salary_cutoff_id` ASC) USING BTREE,
  INDEX `employee_salary_cutoffs_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_salary_cutoffs_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_salary_cutoffs_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_salary_cutoffs_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_salary_cutoffs_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_salary_cutoffs_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_cutoffs_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_cutoffs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_cutoffs_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_cutoffs_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_salary_cutoffs_salary_cutoff_id_foreign` FOREIGN KEY (`salary_cutoff_id`) REFERENCES `salary_cutoffs` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_salary_cutoffs
-- ----------------------------

-- ----------------------------
-- Table structure for employee_shifts
-- ----------------------------
CREATE TABLE `employee_shifts`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NOT NULL,
  `shift_id` int UNSIGNED NOT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `from_date` date NULL DEFAULT NULL,
  `to_date` date NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_shifts_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_shifts_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_shifts_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_shifts_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_shifts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_shifts_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_shifts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_shifts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_shifts
-- ----------------------------

-- ----------------------------
-- Table structure for employee_status
-- ----------------------------
CREATE TABLE `employee_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_status
-- ----------------------------
INSERT INTO `employee_status` VALUES (1, 'فعال', '1', 'value', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:01', '2025-06-12 14:06:01', NULL);
INSERT INTO `employee_status` VALUES (2, 'غير فعال', '2', 'value', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:01', '2025-06-12 14:06:01', NULL);

-- ----------------------------
-- Table structure for employee_team_users
-- ----------------------------
CREATE TABLE `employee_team_users`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_user_id` int UNSIGNED NULL DEFAULT NULL,
  `employee_team_id` int UNSIGNED NULL DEFAULT NULL,
  `is_leader` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_team_users_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `employee_team_users_employee_team_id_foreign`(`employee_team_id` ASC) USING BTREE,
  INDEX `employee_team_users_is_leader_foreign`(`is_leader` ASC) USING BTREE,
  INDEX `employee_team_users_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_team_users_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_team_users_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_team_users_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_team_users_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_employee_team_id_foreign` FOREIGN KEY (`employee_team_id`) REFERENCES `employee_teams` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_team_users_is_leader_foreign` FOREIGN KEY (`is_leader`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_team_users
-- ----------------------------

-- ----------------------------
-- Table structure for employee_teams
-- ----------------------------
CREATE TABLE `employee_teams`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_teams_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_teams_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_teams_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_teams_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_teams_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_teams_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_teams_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_teams_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_teams
-- ----------------------------

-- ----------------------------
-- Table structure for employee_visa_status
-- ----------------------------
CREATE TABLE `employee_visa_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_visa_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_visa_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_visa_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_visa_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_visa_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visa_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visa_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visa_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_visa_status
-- ----------------------------
INSERT INTO `employee_visa_status` VALUES (1, 'فعال', '1', 'value', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:01', '2025-06-12 14:06:01', NULL);
INSERT INTO `employee_visa_status` VALUES (2, 'غير فعال', '1', 'value', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:01', '2025-06-12 14:06:01', NULL);

-- ----------------------------
-- Table structure for employee_visas
-- ----------------------------
CREATE TABLE `employee_visas`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `employee_user_id` int UNSIGNED NULL DEFAULT NULL,
  `employee_visa_state_id` int UNSIGNED NULL DEFAULT NULL,
  `release_date` date NULL DEFAULT NULL,
  `expire_date` date NULL DEFAULT NULL,
  `amount` double NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employee_visas_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employee_visas_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employee_visas_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employee_visas_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employee_visas_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visas_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visas_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employee_visas_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employee_visas
-- ----------------------------

-- ----------------------------
-- Table structure for employees
-- ----------------------------
CREATE TABLE `employees`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `badge_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `job_positions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `passport_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `passport_expire` date NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `annual_permits` double NULL DEFAULT NULL,
  `health_permits` double NULL DEFAULT NULL,
  `main_salary` double UNSIGNED NULL DEFAULT NULL,
  `social_salary` double UNSIGNED NULL DEFAULT NULL,
  `date_of_birth` date NULL DEFAULT NULL,
  `social_security_employee_percentage` double NULL DEFAULT NULL,
  `social_security_company_percentage` double NULL DEFAULT NULL,
  `hair_date` date NULL DEFAULT NULL,
  `end_date` date NULL DEFAULT NULL,
  `social_security_start_calc_date` date NULL DEFAULT NULL,
  `id_type_id` int UNSIGNED NULL DEFAULT NULL,
  `id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `social_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `national_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `education` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mother_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `back_account_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `available_vaction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `number_of_working_hours` double NULL DEFAULT NULL,
  `employee_state_id` int UNSIGNED NULL DEFAULT NULL,
  `education_type_id` int UNSIGNED NULL DEFAULT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `branch_id` int UNSIGNED NOT NULL,
  `manager_user_id` int UNSIGNED NULL DEFAULT NULL,
  `marital_state_id` int UNSIGNED NOT NULL,
  `marital_state_exemption_id` int UNSIGNED NOT NULL,
  `gender_id` int UNSIGNED NOT NULL,
  `employee_visa_id` int UNSIGNED NULL DEFAULT NULL,
  `nationallty_country_id` int UNSIGNED NOT NULL,
  `employee_group_id` int UNSIGNED NOT NULL,
  `department_id` int UNSIGNED NULL DEFAULT NULL,
  `salary_account_id` int UNSIGNED NULL DEFAULT NULL,
  `shift_id` int UNSIGNED NULL DEFAULT NULL,
  `time_calculation_method_id` int UNSIGNED NULL DEFAULT NULL,
  `active_in_salary` int UNSIGNED NOT NULL,
  `active_in_attendance_report` int UNSIGNED NOT NULL,
  `employee_salary_calc_type_id` int UNSIGNED NOT NULL,
  `permission_id` int UNSIGNED NULL DEFAULT NULL,
  `allowd_monthly_petty_cash` double NULL DEFAULT NULL,
  `sallry_as_check` int UNSIGNED NOT NULL,
  `hollyday` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `last_permit_calc_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `employees_branch_id_foreign`(`branch_id` ASC) USING BTREE,
  INDEX `employees_manager_user_id_foreign`(`manager_user_id` ASC) USING BTREE,
  INDEX `employees_marital_state_id_foreign`(`marital_state_id` ASC) USING BTREE,
  INDEX `employees_marital_state_exemption_id_foreign`(`marital_state_exemption_id` ASC) USING BTREE,
  INDEX `employees_gender_id_foreign`(`gender_id` ASC) USING BTREE,
  INDEX `employees_employee_visa_id_foreign`(`employee_visa_id` ASC) USING BTREE,
  INDEX `employees_nationallty_country_id_foreign`(`nationallty_country_id` ASC) USING BTREE,
  INDEX `employees_employee_group_id_foreign`(`employee_group_id` ASC) USING BTREE,
  INDEX `employees_department_id_foreign`(`department_id` ASC) USING BTREE,
  INDEX `employees_salary_account_id_foreign`(`salary_account_id` ASC) USING BTREE,
  INDEX `employees_active_in_salary_foreign`(`active_in_salary` ASC) USING BTREE,
  INDEX `employees_active_in_attendance_report_foreign`(`active_in_attendance_report` ASC) USING BTREE,
  INDEX `employees_sallry_as_check_foreign`(`sallry_as_check` ASC) USING BTREE,
  INDEX `employees_permission_id_foreign`(`permission_id` ASC) USING BTREE,
  INDEX `employees_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `employees_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `employees_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `employees_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `employees_active_in_attendance_report_foreign` FOREIGN KEY (`active_in_attendance_report`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_active_in_salary_foreign` FOREIGN KEY (`active_in_salary`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_employee_group_id_foreign` FOREIGN KEY (`employee_group_id`) REFERENCES `employee_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_employee_visa_id_foreign` FOREIGN KEY (`employee_visa_id`) REFERENCES `employee_visas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_gender_id_foreign` FOREIGN KEY (`gender_id`) REFERENCES `genders` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_manager_user_id_foreign` FOREIGN KEY (`manager_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_marital_state_exemption_id_foreign` FOREIGN KEY (`marital_state_exemption_id`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_marital_state_id_foreign` FOREIGN KEY (`marital_state_id`) REFERENCES `marital_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_nationallty_country_id_foreign` FOREIGN KEY (`nationallty_country_id`) REFERENCES `countries` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_salary_account_id_foreign` FOREIGN KEY (`salary_account_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `employees_sallry_as_check_foreign` FOREIGN KEY (`sallry_as_check`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of employees
-- ----------------------------

-- ----------------------------
-- Table structure for events
-- ----------------------------
CREATE TABLE `events`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `date` datetime NOT NULL,
  `user_type_id` int UNSIGNED NULL DEFAULT NULL,
  `subject_id` int UNSIGNED NULL DEFAULT NULL,
  `class_id` int UNSIGNED NULL DEFAULT NULL,
  `event_user_id` int UNSIGNED NOT NULL,
  `number_of_minits` int UNSIGNED NOT NULL,
  `join_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `events_user_type_id_foreign`(`user_type_id` ASC) USING BTREE,
  INDEX `events_event_user_id_foreign`(`event_user_id` ASC) USING BTREE,
  INDEX `events_subject_id_foreign`(`subject_id` ASC) USING BTREE,
  INDEX `events_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `events_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `events_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `events_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `events_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_event_user_id_foreign` FOREIGN KEY (`event_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `events_user_type_id_foreign` FOREIGN KEY (`user_type_id`) REFERENCES `user_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of events
-- ----------------------------

-- ----------------------------
-- Table structure for excel_export_columns
-- ----------------------------
CREATE TABLE `excel_export_columns`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `model_id` int UNSIGNED NOT NULL,
  `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `excel_export_columns_model_id_foreign`(`model_id` ASC) USING BTREE,
  INDEX `excel_export_columns_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `excel_export_columns_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `excel_export_columns_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `excel_export_columns_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `excel_export_columns_model_id_foreign` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of excel_export_columns
-- ----------------------------
INSERT INTO `excel_export_columns` VALUES (1, 24, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (2, 24, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (3, 24, 'email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (4, 24, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (5, 25, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (6, 25, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (7, 25, 'main_child_zeros', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (8, 25, 'main_child_counter', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (9, 25, 'sub_child_zeros', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (10, 25, 'sub_child_counter', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (11, 25, 'warehouse_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (12, 25, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (13, 26, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (14, 26, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (15, 27, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (16, 27, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (17, 27, 'current_rate', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (18, 28, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (19, 28, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (20, 28, 'email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (21, 28, 'phone', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (22, 28, 'fax', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (23, 28, 'address', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (24, 28, 'tax_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (25, 28, 'number_after_comma', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (26, 28, 'invoice_journal_note_type', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (27, 28, 'cash_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (28, 28, 'revenue_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (29, 28, 'sales_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (30, 28, 'sales_tax_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (31, 28, 'purchases_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (32, 28, 'discount_allowed_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (33, 28, 'discount_received_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (34, 28, 'salary_expenses_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (35, 28, 'cost_of_goods_sold_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (36, 28, 'voucher_posting_state_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (37, 28, 'selling_price_state_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (38, 28, 'employees_main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (39, 28, 'customers_main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (40, 28, 'vendors_main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (41, 28, 'default_currency', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (42, 28, 'tax_state_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (43, 28, 'cost_center_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (44, 28, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (45, 29, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (46, 29, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (47, 29, 'mobile', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (48, 29, 'email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (49, 29, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (50, 29, 'customer_main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (51, 30, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (52, 30, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (53, 30, 'country_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (54, 31, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (55, 31, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (56, 31, 'mobile', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (57, 31, 'email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (58, 31, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (59, 31, 'vendor_main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (60, 32, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (61, 32, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (62, 32, 'foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (63, 32, 'main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (64, 32, 'main_child_zeros', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (65, 32, 'sub_child_zeros', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (66, 32, 'sub_child_counter', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (67, 33, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (68, 33, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (69, 33, 'foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (70, 33, 'main_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (71, 33, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (72, 34, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (73, 34, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (74, 34, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (75, 35, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (76, 35, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (77, 35, 'cost_center_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (78, 35, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (79, 36, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (80, 36, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (81, 36, 'next_number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (82, 36, 'cost_center_state', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (83, 36, 'journal_type_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (84, 36, 'numbering_type_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (85, 36, 'default_debit_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (86, 36, 'default_credit_account_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (87, 36, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (88, 41, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (89, 41, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (90, 41, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (91, 42, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (92, 44, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (93, 44, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (94, 44, 'validation', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (95, 44, 'product_specification_type_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (96, 45, 'value', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (97, 45, 'product_specification_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (98, 46, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (99, 46, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (100, 46, 'foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (101, 46, 'product_id_category_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (102, 46, 'main_child_zeros', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (103, 46, 'main_child_counter', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (104, 46, 'note', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (105, 47, 'number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (106, 47, 'name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (107, 47, 'numbering_type_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_export_columns` VALUES (108, 47, 'in_out_type_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);

-- ----------------------------
-- Table structure for excel_import_columns
-- ----------------------------
CREATE TABLE `excel_import_columns`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `model_id` int UNSIGNED NOT NULL,
  `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `validation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `excel_import_columns_model_id_foreign`(`model_id` ASC) USING BTREE,
  INDEX `excel_import_columns_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `excel_import_columns_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `excel_import_columns_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `excel_import_columns_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `excel_import_columns_model_id_foreign` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of excel_import_columns
-- ----------------------------
INSERT INTO `excel_import_columns` VALUES (1, 24, 'number', 'required|integer|min:1|unique:users,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (2, 24, 'name', 'required|min:3|max:255|unique:users,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (3, 24, 'foreign_name', 'nullable|min:1|max:255|unique:users,foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (4, 24, 'password', 'required|max:255|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (5, 24, 'email', 'nullable|email|unique:users,email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (6, 24, 'note', 'nullable|min:1|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (7, 24, 'gender_id', 'required|integer|exists:genders,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (8, 24, 'warehouse_id', 'nullable|integer|exists:warehouses', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (9, 25, 'number', 'required|integer|min:1|unique:warehouses,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (10, 25, 'name', 'required|min:3|max:255|unique:warehouses,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (11, 25, 'main_child_zeros', 'required|integer', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (12, 25, 'main_child_counter', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (13, 25, 'sub_child_zeros', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (14, 25, 'sub_child_counter', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (15, 25, 'warehouse_id', 'nullable|integer', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (16, 25, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (17, 26, 'number', 'required|integer|min:1|unique:product_categories,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (18, 26, 'name', 'required|min:3|max:255|unique:product_categories,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (19, 26, 'warehouse_id', 'nullable|integer|exists:product_categories,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (20, 26, 'tree_type_id', 'required|integer|exists:tree_types,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (21, 26, 'subs_start_from', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (22, 27, 'number', 'required|integer|min:1|unique:currencies,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (23, 27, 'name', 'required|min:3|max:255|unique:currencies,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (24, 27, 'current_rate', 'required|numeric', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (25, 28, 'number', 'required|integer|min:1|unique:branches,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (26, 28, 'name', 'required|min:3|max:255|unique:branches,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (27, 28, 'email', 'nullable|min:3|max:255|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (28, 28, 'phone', 'nullable|min:3|max:255|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (29, 28, 'tax_id', 'nullable|min:3|max:255|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (30, 29, 'number', 'required|integer|min:1|unique:customers,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (31, 29, 'name', 'required|min:3|max:255|unique:customers,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (32, 29, 'email', 'nullable|min:3|max:255|unique:customers,email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (33, 29, 'tax_id', 'nullable|min:3|max:255|unique:customers,tax_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (34, 29, 'phone', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (35, 29, 'mobile', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (36, 29, 'note', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (37, 29, 'financial_account_type_id', 'required|integer|min:1|max:2', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (38, 30, 'number', 'required|integer|min:1|unique:cities,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (39, 30, 'name', 'required|min:3|max:255|unique:cities,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (40, 30, 'country_id', 'nullable|integer|exists:countries,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (41, 31, 'number', 'required|integer|min:1|unique:vendors,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (42, 31, 'name', 'required|min:3|max:255|unique:vendors,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (43, 31, 'email', 'nullable|min:3|max:255|unique:vendors,email', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (44, 31, 'tax_id', 'nullable|min:3|max:255|unique:vendors,tax_id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (45, 31, 'phone', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (46, 31, 'mobile', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (47, 31, 'note', 'nullable|min:3|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (48, 31, 'financial_account_type_id', 'required|integer|min:1|max:2', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (49, 32, 'number', 'required|unique:main_accounts,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (50, 32, 'name', 'required|unique:main_accounts,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (51, 32, 'foreign_name', 'nullable|unique:main_accounts,foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (52, 32, 'main_account_id', 'nullable|integer|exists:main_accounts,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (53, 32, 'main_child_zeros', 'required|integer|max:1000000', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (54, 32, 'sub_child_zeros', 'required|integer|max:1000000', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (55, 32, 'sub_child_counter', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (56, 32, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (57, 33, 'number', 'required|max:255|unique:accounts,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (58, 33, 'name', 'required|max:255|unique:accounts,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (59, 33, 'foreign_name', 'nullable|max:255|unique:accounts,foreign_name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (60, 33, 'main_account_id', 'required|integer|exists:main_accounts,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (61, 33, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (62, 34, 'number', 'required|max:255|unique:journal_groups,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (63, 34, 'name', 'required|max:255|unique:journal_groups,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (64, 34, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (65, 35, 'number', 'required|max:255|unique:cost_centers,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (66, 35, 'name', 'required|max:255|unique:cost_centers,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (67, 35, 'cost_center_id', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (68, 35, 'tree_type_id', 'required|integer|exists:tree_types,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (69, 35, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (70, 36, 'number', 'required|max:255|unique:journals,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (71, 36, 'name', 'required|max:255|unique:journals,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (72, 36, 'next_number', 'nullable|integer|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (73, 36, 'cost_center_state', 'required|integer|exists:status,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (74, 36, 'journal_type_id', 'required|integer|exists:journal_types,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (75, 36, 'numbering_type_id', 'required|integer|exists:numbering_types,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (76, 36, 'default_debit_account_id', 'nullable|integer|exists:accounts,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (77, 36, 'default_credit_account_id', 'nullable|integer|exists:accounts,id', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (78, 36, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (79, 41, 'number', 'required|max:255|unique:units,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (80, 41, 'name', 'required|max:255|unique:units,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (81, 41, 'note', 'nullable|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (82, 42, 'name', 'required|max:255|unique:product_ids,key', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (83, 44, 'number', 'required|max:255|unique:product_specifications,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (84, 44, 'name', 'required|max:255|unique:product_specifications,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (85, 44, 'validation', 'required|max:255', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (86, 44, 'product_specification_type_id', 'required|integer|max:3', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (87, 45, 'value', 'required|max:255|', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (88, 45, 'product_specification_id', 'required|integer', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (89, 46, 'number', 'integer|unique:product_id_categories,number', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `excel_import_columns` VALUES (90, 46, 'name', 'string|max:255|unique:product_id_categories,name', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);

-- ----------------------------
-- Table structure for facebook_customer_groups
-- ----------------------------
CREATE TABLE `facebook_customer_groups`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_customer_group_id` int UNSIGNED NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `main_child_zeros` int NULL DEFAULT NULL,
  `main_child_counter` int NULL DEFAULT NULL,
  `sub_child_zeros` int NULL DEFAULT NULL,
  `sub_child_counter` int NULL DEFAULT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_customer_groups_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_customer_groups_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_customer_groups_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_customer_groups_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_customer_groups_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customer_groups_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customer_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customer_groups_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_customer_groups
-- ----------------------------

-- ----------------------------
-- Table structure for facebook_customers
-- ----------------------------
CREATE TABLE `facebook_customers`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `facebook_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_messages_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `chat_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `is_employee` int UNSIGNED NULL DEFAULT NULL,
  `has_messages` int UNSIGNED NULL DEFAULT NULL,
  `facebook_customer_group_id` int UNSIGNED NULL DEFAULT NULL,
  `customer_main_account_id` int UNSIGNED NULL DEFAULT NULL,
  `product_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_customers_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `facebook_customers_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_customers_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_customers_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_customers_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_customers_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customers_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customers_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_customers
-- ----------------------------

-- ----------------------------
-- Table structure for facebook_message_templates
-- ----------------------------
CREATE TABLE `facebook_message_templates`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_template_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bootstrap_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_message_templates_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_message_templates_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_message_templates_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_message_templates_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_message_templates_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_message_templates_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_message_templates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_message_templates_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_message_templates
-- ----------------------------

-- ----------------------------
-- Table structure for facebook_messages
-- ----------------------------
CREATE TABLE `facebook_messages`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `facebook_customer_id` int UNSIGNED NULL DEFAULT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `read_state_id` int UNSIGNED NULL DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `to_facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_thread_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_message_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_messages_read_state_id_foreign`(`read_state_id` ASC) USING BTREE,
  INDEX `facebook_messages_facebook_customer_id_foreign`(`facebook_customer_id` ASC) USING BTREE,
  INDEX `facebook_messages_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `facebook_messages_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_messages_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_messages_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_messages_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_messages_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_facebook_customer_id_foreign` FOREIGN KEY (`facebook_customer_id`) REFERENCES `facebook_customers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_read_state_id_foreign` FOREIGN KEY (`read_state_id`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_messages
-- ----------------------------

-- ----------------------------
-- Table structure for facebook_pipelines
-- ----------------------------
CREATE TABLE `facebook_pipelines`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `facebook_customer_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `pipeline_id` int UNSIGNED NOT NULL,
  `pipeline_state_id` int UNSIGNED NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_pipelines_facebook_customer_id_foreign`(`facebook_customer_id` ASC) USING BTREE,
  INDEX `facebook_pipelines_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `facebook_pipelines_pipeline_id_foreign`(`pipeline_id` ASC) USING BTREE,
  INDEX `facebook_pipelines_pipeline_state_id_foreign`(`pipeline_state_id` ASC) USING BTREE,
  INDEX `facebook_pipelines_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_pipelines_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_pipelines_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_pipelines_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_pipelines_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_facebook_customer_id_foreign` FOREIGN KEY (`facebook_customer_id`) REFERENCES `facebook_customers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_pipeline_id_foreign` FOREIGN KEY (`pipeline_id`) REFERENCES `pipelines` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_pipeline_state_id_foreign` FOREIGN KEY (`pipeline_state_id`) REFERENCES `pipeline_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_pipelines_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_pipelines
-- ----------------------------

-- ----------------------------
-- Table structure for facebook_settings
-- ----------------------------
CREATE TABLE `facebook_settings`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `page_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `page_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook_upload_file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `message_count` int NULL DEFAULT NULL,
  `stage_id` int NULL DEFAULT NULL,
  `review_stage_id` int NULL DEFAULT NULL,
  `customer_main_account_id` int NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `facebook_settings_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `facebook_settings_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `facebook_settings_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `facebook_settings_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `facebook_settings_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_settings_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_settings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `facebook_settings_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of facebook_settings
-- ----------------------------

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------

-- ----------------------------
-- Table structure for favorites
-- ----------------------------
CREATE TABLE `favorites`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `application_id` int UNSIGNED NOT NULL,
  `model_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `favorites_application_id_foreign`(`application_id` ASC) USING BTREE,
  INDEX `favorites_model_id_foreign`(`model_id` ASC) USING BTREE,
  INDEX `favorites_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `favorites_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `favorites_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `favorites_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `favorites_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `favorites_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_model_id_foreign` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 65 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of favorites
-- ----------------------------
INSERT INTO `favorites` VALUES (1, 6, 29, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (2, 6, 31, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (3, 6, 33, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (4, 6, 38, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (5, 6, 39, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (6, 6, 40, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (7, 6, 55, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (8, 6, 50, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (9, 3, 104, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (10, 3, 104, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (11, 3, 107, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (12, 3, 109, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (13, 3, 111, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (14, 3, 112, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (15, 4, 95, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (16, 4, 100, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (17, 5, 162, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (18, 5, 163, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (19, 5, 164, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (20, 9, 43, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (21, 9, 48, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (22, 9, 54, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (23, 9, 93, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (24, 11, 60, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (25, 11, 64, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (26, 11, 66, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (27, 11, 69, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (28, 11, 70, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (29, 12, 83, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (30, 12, 87, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (31, 13, 90, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (32, 13, 87, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (33, 14, 152, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (34, 14, 153, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (35, 14, 154, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (36, 15, 156, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (37, 15, 158, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (38, 15, 159, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (39, 15, 160, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (40, 17, 115, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (41, 17, 118, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (42, 17, 119, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (43, 17, 122, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (44, 18, 123, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (45, 18, 125, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (46, 18, 126, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (47, 19, 127, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (48, 19, 128, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (49, 19, 129, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (50, 19, 130, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (51, 19, 131, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (52, 19, 132, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (53, 19, 133, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (54, 19, 143, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (55, 19, 144, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (56, 19, 145, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (57, 19, 146, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (58, 19, 147, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (59, 19, 148, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (60, 19, 149, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (61, 19, 150, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `favorites` VALUES (62, 5, 24, 71, 'https://eesa.cyberlapaccounts.com/main/public/storage/eesa.cyberlapaccounts.com/logo.png', 'https://eesa.cyberlapaccounts.com/main/public/one_way_journals/1?journal_id=2', 'سند قبض', 71, NULL, NULL, NULL, NULL, '2025-07-12 12:05:24', '2025-07-12 12:05:24', NULL);
INSERT INTO `favorites` VALUES (63, 5, 24, 71, 'https://eesa.cyberlapaccounts.com/main/public/storage/eesa.cyberlapaccounts.com/logo.png', 'https://eesa.cyberlapaccounts.com/main/public/one_way_journals/2', 'سند صرف', 71, NULL, NULL, NULL, NULL, '2025-07-12 12:06:25', '2025-07-12 12:06:25', NULL);
INSERT INTO `favorites` VALUES (64, 5, 24, 71, 'https://eesa.cyberlapaccounts.com/main/public/storage/eesa.cyberlapaccounts.com/logo.png', 'https://eesa.cyberlapaccounts.com/main/public/journal_entries/create?navbar=', 'سند قيد', 71, NULL, NULL, NULL, NULL, '2025-07-12 12:07:09', '2025-07-12 12:07:09', NULL);

-- ----------------------------
-- Table structure for final_balance_sheets
-- ----------------------------
CREATE TABLE `final_balance_sheets`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `balance_sheet_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `final_balance_sheets_balance_sheet_id_foreign`(`balance_sheet_id` ASC) USING BTREE,
  INDEX `final_balance_sheets_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `final_balance_sheets_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `final_balance_sheets_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `final_balance_sheets_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `final_balance_sheets_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `final_balance_sheets_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `final_balance_sheets_balance_sheet_id_foreign` FOREIGN KEY (`balance_sheet_id`) REFERENCES `balance_sheets` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `final_balance_sheets_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `final_balance_sheets_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of final_balance_sheets
-- ----------------------------

-- ----------------------------
-- Table structure for financial_account_types
-- ----------------------------
CREATE TABLE `financial_account_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `financial_account_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `financial_account_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `financial_account_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `financial_account_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of financial_account_types
-- ----------------------------
INSERT INTO `financial_account_types` VALUES (1, 'فردي', 'individual', '1', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `financial_account_types` VALUES (2, 'شركة', 'company', '2', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);

-- ----------------------------
-- Table structure for foreign_order_accounts
-- ----------------------------
CREATE TABLE `foreign_order_accounts`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `foreign_order_main_account_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_accounts_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `foreign_order_accounts_foreign_order_main_account_id_foreign`(`foreign_order_main_account_id` ASC) USING BTREE,
  INDEX `foreign_order_accounts_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_accounts_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_accounts_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_accounts_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_accounts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_accounts_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_accounts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_accounts_foreign_order_main_account_id_foreign` FOREIGN KEY (`foreign_order_main_account_id`) REFERENCES `foreign_order_main_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_accounts
-- ----------------------------

-- ----------------------------
-- Table structure for foreign_order_journals
-- ----------------------------
CREATE TABLE `foreign_order_journals`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `foreign_orders` int UNSIGNED NOT NULL,
  `journal_entry_id` int UNSIGNED NOT NULL,
  `is_main` int UNSIGNED NULL DEFAULT NULL,
  `is_it_for_createing` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_journals_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_journals_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_journals_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_journals_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_journals_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_journals_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_journals_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_journals_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_journals
-- ----------------------------

-- ----------------------------
-- Table structure for foreign_order_lines
-- ----------------------------
CREATE TABLE `foreign_order_lines`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `foreign_order_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `unit_id` int UNSIGNED NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `date` date NULL DEFAULT NULL,
  `in_date_unit_rate` double UNSIGNED NOT NULL,
  `price` double UNSIGNED NULL DEFAULT NULL,
  `price_t` double UNSIGNED NULL DEFAULT NULL,
  `price_with_cost` double UNSIGNED NULL DEFAULT NULL,
  `price_with_cost_t` double UNSIGNED NULL DEFAULT NULL,
  `discount_percentage` double UNSIGNED NULL DEFAULT NULL,
  `discount_value` double UNSIGNED NULL DEFAULT NULL,
  `tax_value` double UNSIGNED NULL DEFAULT NULL,
  `quantity` double UNSIGNED NULL DEFAULT NULL,
  `quantity_t` double UNSIGNED NULL DEFAULT NULL,
  `currency_id` int UNSIGNED NULL DEFAULT NULL,
  `in_date_currency_rate` double UNSIGNED NULL DEFAULT NULL,
  `in_date_tax` double UNSIGNED NULL DEFAULT NULL,
  `in_date_custom` double UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_lines_foreign_order_id_foreign`(`foreign_order_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_currency_id_foreign`(`currency_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_product_id_foreign`(`product_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_unit_id_foreign`(`unit_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_lines_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_lines_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_lines_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_lines_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_foreign_order_id_foreign` FOREIGN KEY (`foreign_order_id`) REFERENCES `foreign_orders` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_lines_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_lines
-- ----------------------------

-- ----------------------------
-- Table structure for foreign_order_main_accounts
-- ----------------------------
CREATE TABLE `foreign_order_main_accounts`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_order_main_account_id` int UNSIGNED NULL DEFAULT NULL,
  `main_child_zeros` int NULL DEFAULT NULL,
  `main_child_counter` int NULL DEFAULT NULL,
  `sub_child_zeros` int NULL DEFAULT NULL,
  `sub_child_counter` int NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_main_accounts_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_main_accounts_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_main_accounts_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_main_accounts_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_main_accounts_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_main_accounts_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_main_accounts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_main_accounts_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_main_accounts
-- ----------------------------
INSERT INTO `foreign_order_main_accounts` VALUES (1, 'طلبيات الصين', '1', 'Chinese Foreign order', NULL, 10, NULL, 1000, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:59', '2025-06-12 14:05:59', NULL);

-- ----------------------------
-- Table structure for foreign_order_status
-- ----------------------------
CREATE TABLE `foreign_order_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_status
-- ----------------------------
INSERT INTO `foreign_order_status` VALUES (1, 'قيد الانشاء', '1', 'Under construction', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `foreign_order_status` VALUES (2, 'في الطريق', '2', 'Pending', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `foreign_order_status` VALUES (3, 'وصلت ولم تقفل', '3', 'Arrived and not close', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `foreign_order_status` VALUES (4, 'الغيت', '4', 'Canceled', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `foreign_order_status` VALUES (5, 'وصلت واقفلت', '5', 'Arrived and closed', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);
INSERT INTO `foreign_order_status` VALUES (6, 'تم الادخال في المستودع ولم ترحل في المحاسبة', '6', 'Arrived in warehouse and not in accounting', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);

-- ----------------------------
-- Table structure for foreign_order_types
-- ----------------------------
CREATE TABLE `foreign_order_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `numbering_type_id` int UNSIGNED NOT NULL,
  `next_number` int UNSIGNED NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `has_journal_entry` int UNSIGNED NULL DEFAULT NULL,
  `header` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `footer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_order_types_has_journal_entry_foreign`(`has_journal_entry` ASC) USING BTREE,
  INDEX `foreign_order_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_order_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_order_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_order_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_order_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_order_types_has_journal_entry_foreign` FOREIGN KEY (`has_journal_entry`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_order_types
-- ----------------------------
INSERT INTO `foreign_order_types` VALUES (1, 'بضاعة مواد اولية', '1', 'Row material', 1, NULL, NULL, 1, '\r\n            <div class=\"row\">\r\n                <div class=\"col-5 center\">\r\n                    <div class=\"bold\" style=\"font-size:30px\">اسم الشركة</div>\r\n                </div>\r\n                <div class=\"col-2 center\">\r\n                    <img width=\"180px\" height=\"100px\" src=\"https://softya.com/demo/public/storage/logo.png\" />\r\n                </div>\r\n                <div class=\"col-5 center\">\r\n                    <div class=\"bold\" style=\"font-size:30px\">Company name</div>\r\n                </div>\r\n            </div>\r\n        ', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:58', '2025-06-12 14:05:58', NULL);

-- ----------------------------
-- Table structure for foreign_orders
-- ----------------------------
CREATE TABLE `foreign_orders`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `foreign_order_state_id` int UNSIGNED NOT NULL,
  `foreign_order_type_id` int UNSIGNED NOT NULL,
  `transport_type_id` int UNSIGNED NOT NULL,
  `journal_entry_payment_type_id` int UNSIGNED NOT NULL,
  `country_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `account_user_id` int UNSIGNED NOT NULL,
  `tax_state_id` int UNSIGNED NOT NULL,
  `currency_id` int UNSIGNED NOT NULL,
  `branch_id` int UNSIGNED NOT NULL,
  `note_voucher_id` int UNSIGNED NULL DEFAULT NULL,
  `in_date_currency_rate` double UNSIGNED NOT NULL,
  `purchase_order_id` double UNSIGNED NULL DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bank_credit_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `actual_arrival_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bank_id` int UNSIGNED NULL DEFAULT NULL,
  `date` date NOT NULL,
  `date_of_import` date NOT NULL,
  `ship_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `number_of_containers` int NULL DEFAULT NULL,
  `total_price` double NULL DEFAULT NULL,
  `total_discount` double NULL DEFAULT NULL,
  `tax_value` double NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `foreign_orders_foreign_order_state_id_foreign`(`foreign_order_state_id` ASC) USING BTREE,
  INDEX `foreign_orders_foreign_order_type_id_foreign`(`foreign_order_type_id` ASC) USING BTREE,
  INDEX `foreign_orders_transport_type_id_foreign`(`transport_type_id` ASC) USING BTREE,
  INDEX `foreign_orders_journal_entry_payment_type_id_foreign`(`journal_entry_payment_type_id` ASC) USING BTREE,
  INDEX `foreign_orders_country_id_foreign`(`country_id` ASC) USING BTREE,
  INDEX `foreign_orders_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `foreign_orders_tax_state_id_foreign`(`tax_state_id` ASC) USING BTREE,
  INDEX `foreign_orders_currency_id_foreign`(`currency_id` ASC) USING BTREE,
  INDEX `foreign_orders_branch_id_foreign`(`branch_id` ASC) USING BTREE,
  INDEX `foreign_orders_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `foreign_orders_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `foreign_orders_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `foreign_orders_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `foreign_orders_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_foreign_order_state_id_foreign` FOREIGN KEY (`foreign_order_state_id`) REFERENCES `foreign_order_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_foreign_order_type_id_foreign` FOREIGN KEY (`foreign_order_type_id`) REFERENCES `foreign_order_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_journal_entry_payment_type_id_foreign` FOREIGN KEY (`journal_entry_payment_type_id`) REFERENCES `journal_entry_payment_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_tax_state_id_foreign` FOREIGN KEY (`tax_state_id`) REFERENCES `tax_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_transport_type_id_foreign` FOREIGN KEY (`transport_type_id`) REFERENCES `transport_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `foreign_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of foreign_orders
-- ----------------------------

-- ----------------------------
-- Table structure for formula_lines
-- ----------------------------
CREATE TABLE `formula_lines`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `formula_id` int UNSIGNED NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `unit_id` int UNSIGNED NOT NULL,
  `quantity` double UNSIGNED NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `formula_lines_formula_id_foreign`(`formula_id` ASC) USING BTREE,
  INDEX `formula_lines_product_id_foreign`(`product_id` ASC) USING BTREE,
  INDEX `formula_lines_unit_id_foreign`(`unit_id` ASC) USING BTREE,
  INDEX `formula_lines_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `formula_lines_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `formula_lines_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `formula_lines_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `formula_lines_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_formula_id_foreign` FOREIGN KEY (`formula_id`) REFERENCES `formulas` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_lines_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of formula_lines
-- ----------------------------

-- ----------------------------
-- Table structure for formula_types
-- ----------------------------
CREATE TABLE `formula_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `numbering_type_id` int UNSIGNED NOT NULL,
  `next_number` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `formula_types_numbering_type_id_foreign`(`numbering_type_id` ASC) USING BTREE,
  INDEX `formula_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `formula_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `formula_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `formula_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `formula_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formula_types_numbering_type_id_foreign` FOREIGN KEY (`numbering_type_id`) REFERENCES `numbering_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of formula_types
-- ----------------------------
INSERT INTO `formula_types` VALUES (1, 'نصف مصنعة', '1', 'Half', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);
INSERT INTO `formula_types` VALUES (2, 'منتج تام', '2', 'Final', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:53', '2025-06-12 14:05:53', NULL);

-- ----------------------------
-- Table structure for formulas
-- ----------------------------
CREATE TABLE `formulas`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `formula_type_id` int UNSIGNED NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `unit_id` int UNSIGNED NOT NULL,
  `work_order_step_template_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `formulas_formula_type_id_foreign`(`formula_type_id` ASC) USING BTREE,
  INDEX `formulas_product_id_foreign`(`product_id` ASC) USING BTREE,
  INDEX `formulas_unit_id_foreign`(`unit_id` ASC) USING BTREE,
  INDEX `formulas_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `formulas_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `formulas_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `formulas_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `formulas_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_formula_type_id_foreign` FOREIGN KEY (`formula_type_id`) REFERENCES `formula_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `formulas_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of formulas
-- ----------------------------

-- ----------------------------
-- Table structure for genders
-- ----------------------------
CREATE TABLE `genders`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of genders
-- ----------------------------
INSERT INTO `genders` VALUES (1, 'ذكر', NULL, 'Mail', 1, NULL, '2025-06-12 14:05:47', '2025-06-12 14:05:47', NULL);
INSERT INTO `genders` VALUES (2, 'انثى', NULL, 'Femail', 1, NULL, '2025-06-12 14:05:47', '2025-06-12 14:05:47', NULL);

-- ----------------------------
-- Table structure for holidays
-- ----------------------------
CREATE TABLE `holidays`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `holidays_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `holidays_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `holidays_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `holidays_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `holidays_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `holidays_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `holidays_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `holidays_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of holidays
-- ----------------------------
INSERT INTO `holidays` VALUES (1, 'عيد الفطر', '1', 'Eid al-Fitr', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:52', '2025-06-12 14:05:52', NULL);

-- ----------------------------
-- Table structure for hrm_settings
-- ----------------------------
CREATE TABLE `hrm_settings`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `employee_clearances_header` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `employee_clearances_footer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `salary_debit_account_id` int UNSIGNED NULL DEFAULT NULL,
  `income_tax_account_id` int UNSIGNED NULL DEFAULT NULL,
  `income_tax_limit_marred` double UNSIGNED NULL DEFAULT NULL,
  `income_tax_limit_single` double UNSIGNED NULL DEFAULT NULL,
  `branch_id` int UNSIGNED NOT NULL,
  `calc_salary_with_allowances` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hrm_settings_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `hrm_settings_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `hrm_settings_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `hrm_settings_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `hrm_settings_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `hrm_settings_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `hrm_settings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `hrm_settings_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hrm_settings
-- ----------------------------
INSERT INTO `hrm_settings` VALUES (1, NULL, NULL, 47, NULL, 18000, 9000, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for id_types
-- ----------------------------
CREATE TABLE `id_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `id_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `id_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `id_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `id_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `id_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `id_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `id_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of id_types
-- ----------------------------
INSERT INTO `id_types` VALUES (1, 'هوية شخصية', '1', 'Id', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `id_types` VALUES (2, 'جواز سفر', '2', 'Passport', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `id_types` VALUES (3, 'بطاقة اقامة موؤقتة', '3', 'Temp id', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for import_export_types
-- ----------------------------
CREATE TABLE `import_export_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `import_export_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `import_export_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `import_export_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `import_export_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `import_export_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `import_export_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `import_export_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `import_export_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of import_export_types
-- ----------------------------
INSERT INTO `import_export_types` VALUES (1, 'تصدير', '1', 'Export', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:05', '2025-06-12 14:06:05', NULL);
INSERT INTO `import_export_types` VALUES (2, 'استيراد', '2', 'Import', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:05', '2025-06-12 14:06:05', NULL);

-- ----------------------------
-- Table structure for in_out_types
-- ----------------------------
CREATE TABLE `in_out_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of in_out_types
-- ----------------------------
INSERT INTO `in_out_types` VALUES (1, 'ادخال', 'input', '2025-06-12 14:05:50', '2025-06-12 14:05:50', NULL);
INSERT INTO `in_out_types` VALUES (2, 'اخراج', 'output', '2025-06-12 14:05:50', '2025-06-12 14:05:50', NULL);
INSERT INTO `in_out_types` VALUES (3, 'نقل', 'Transfer', '2025-06-12 14:05:50', '2025-06-12 14:05:50', NULL);

-- ----------------------------
-- Table structure for installment_period_names
-- ----------------------------
CREATE TABLE `installment_period_names`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `number_of_days` int NULL DEFAULT NULL,
  `start_date` int NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `installment_period_names_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `installment_period_names_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `installment_period_names_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `installment_period_names_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `installment_period_names_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_period_names_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_period_names_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_period_names_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of installment_period_names
-- ----------------------------
INSERT INTO `installment_period_names` VALUES (1, 'يومي', '1', 'Dailly', 1, 1, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (2, 'اسبوعي', '2', 'Weekly', 7, 1, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (3, 'شهري', '3', 'Monthly', 30, 28, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (4, 'شهرين', '4', 'Tow month', 60, 28, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (5, 'ثلاث شهور', '5', 'Three month', 90, 28, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (6, 'ست شهور', '6', '6 month', 90, 28, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_period_names` VALUES (7, 'سنوي', '7', 'One Year', 90, 28, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);

-- ----------------------------
-- Table structure for installment_status
-- ----------------------------
CREATE TABLE `installment_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `installment_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `installment_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `installment_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `installment_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `installment_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `installment_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of installment_status
-- ----------------------------
INSERT INTO `installment_status` VALUES (1, 'بانتظار الدفع', '1', 'Pending', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (2, 'دفع بنجاح', '2', 'Done', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (3, 'تم تأجيله', '3', 'Postponed', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (4, 'سدد المبلغ ناقص', '4', 'Pay the amount minus', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (5, 'لم يتم الدفع', '5', 'Not paid', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (6, 'دفع قبل الموعد', '6', 'Pay ahead of time', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);
INSERT INTO `installment_status` VALUES (7, 'محامي', '7', 'Layer', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:06:03', '2025-06-12 14:06:03', NULL);

-- ----------------------------
-- Table structure for insurance_companies
-- ----------------------------
CREATE TABLE `insurance_companies`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `state_id` int UNSIGNED NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `insurance_companies_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `insurance_companies_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `insurance_companies_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `insurance_companies_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `insurance_companies_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_companies_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_companies_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_companies_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of insurance_companies
-- ----------------------------
INSERT INTO `insurance_companies` VALUES (1, 'شركة تأمين 1', '1', 'Insurance company 1', 1, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:59', '2025-06-12 14:05:59', NULL);
INSERT INTO `insurance_companies` VALUES (2, 'شركة تأمين 2', '2', 'Insurance company 2', 1, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:59', '2025-06-12 14:05:59', NULL);

-- ----------------------------
-- Table structure for insurance_company_percentages
-- ----------------------------
CREATE TABLE `insurance_company_percentages`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int UNSIGNED NOT NULL,
  `insurance_company_id` int UNSIGNED NOT NULL,
  `user_percentage` double UNSIGNED NOT NULL,
  `insurance_company_percentage` double UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `insurance_company_percentages_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `insurance_company_percentages_insurance_company_id_foreign`(`insurance_company_id` ASC) USING BTREE,
  INDEX `insurance_company_percentages_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `insurance_company_percentages_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `insurance_company_percentages_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `insurance_company_percentages_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `insurance_company_percentages_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_percentages_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_percentages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_percentages_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_percentages_insurance_company_id_foreign` FOREIGN KEY (`insurance_company_id`) REFERENCES `insurance_companies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_percentages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of insurance_company_percentages
-- ----------------------------

-- ----------------------------
-- Table structure for insurance_company_status
-- ----------------------------
CREATE TABLE `insurance_company_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `insurance_company_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `insurance_company_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `insurance_company_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `insurance_company_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `insurance_company_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of insurance_company_status
-- ----------------------------
INSERT INTO `insurance_company_status` VALUES (1, 'قيد التحصيل', '1', 'Under collection', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:59', '2025-06-12 14:05:59', NULL);
INSERT INTO `insurance_company_status` VALUES (2, 'تم التحصيل', '2', 'Collected', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:59', '2025-06-12 14:05:59', NULL);

-- ----------------------------
-- Table structure for insurance_company_users
-- ----------------------------
CREATE TABLE `insurance_company_users`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int UNSIGNED NOT NULL,
  `insurance_company_id` int UNSIGNED NOT NULL,
  `user_percentage` double UNSIGNED NOT NULL,
  `insurance_company_percentage` double UNSIGNED NOT NULL,
  `posting_state_id` int UNSIGNED NOT NULL,
  `journal_entry_id` int UNSIGNED NOT NULL,
  `amount` int UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `insurance_company_users_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `insurance_company_users_insurance_company_id_foreign`(`insurance_company_id` ASC) USING BTREE,
  INDEX `insurance_company_users_posting_state_id_foreign`(`posting_state_id` ASC) USING BTREE,
  INDEX `insurance_company_users_journal_entry_id_foreign`(`journal_entry_id` ASC) USING BTREE,
  INDEX `insurance_company_users_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `insurance_company_users_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `insurance_company_users_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `insurance_company_users_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `insurance_company_users_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_insurance_company_id_foreign` FOREIGN KEY (`insurance_company_id`) REFERENCES `insurance_companies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_journal_entry_id_foreign` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_posting_state_id_foreign` FOREIGN KEY (`posting_state_id`) REFERENCES `posting_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `insurance_company_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of insurance_company_users
-- ----------------------------

-- ----------------------------
-- Table structure for inventory_types
-- ----------------------------
CREATE TABLE `inventory_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `inventory_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `inventory_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `inventory_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `inventory_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of inventory_types
-- ----------------------------
INSERT INTO `inventory_types` VALUES (1, 'جرد دوري', 'Periodic inventory', '1', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);
INSERT INTO `inventory_types` VALUES (2, 'جرد مستمر', 'Continuous inventory', '2', 1, NULL, '2025-06-12 14:05:48', '2025-06-12 14:05:48', NULL);

-- ----------------------------
-- Table structure for invoice_maintenance_groups
-- ----------------------------
CREATE TABLE `invoice_maintenance_groups`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `main_child_zeros` double NULL DEFAULT 10,
  `main_child_counter` double NULL DEFAULT NULL,
  `sub_child_zeros` double NULL DEFAULT 1000,
  `sub_child_counter` double NULL DEFAULT NULL,
  `invoice_maintenance_group_id` int UNSIGNED NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenance_groups_invoice_maintenance_group_id_foreign`(`invoice_maintenance_group_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_groups_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_groups_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_groups_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_groups_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenance_groups_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_groups_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_groups_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_groups_invoice_maintenance_group_id_foreign` FOREIGN KEY (`invoice_maintenance_group_id`) REFERENCES `invoice_maintenance_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenance_groups
-- ----------------------------
INSERT INTO `invoice_maintenance_groups` VALUES (1, 'عيوب مصنعية', '1', 'Internal', 10, NULL, 1000, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_groups` VALUES (2, 'الكسر', '2', 'External', 10, NULL, 1000, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for invoice_maintenance_kinds
-- ----------------------------
CREATE TABLE `invoice_maintenance_kinds`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenance_kinds_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_kinds_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_kinds_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_kinds_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenance_kinds_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_kinds_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_kinds_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_kinds_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenance_kinds
-- ----------------------------
INSERT INTO `invoice_maintenance_kinds` VALUES (1, 'يومي', '1', 'Daily', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (2, 'اسبوعي', '2', 'Weekly', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (3, 'شهري', '3', 'Monthly', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (4, 'شهرين', '4', 'Tow month', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (5, 'ثلاث اشهر', '5', 'Three month', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (6, 'اربع اشهر', '6', 'Four month', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (7, 'خمس اشهر', '7', 'Fife month', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (8, 'ست اشهر', '8', 'Six month', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_kinds` VALUES (9, 'سنوي', '9', 'Annual', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for invoice_maintenance_lines
-- ----------------------------
CREATE TABLE `invoice_maintenance_lines`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `date` date NOT NULL,
  `line_id` int UNSIGNED NULL DEFAULT NULL,
  `invoice_maintenance_group_id` int UNSIGNED NOT NULL,
  `invoice_maintenance_id` int UNSIGNED NOT NULL,
  `invoice_maintenance_type_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `invoice_maintenance_state_id` int UNSIGNED NOT NULL,
  `employee_user_id` int UNSIGNED NULL DEFAULT NULL,
  `journal_entry_id` int UNSIGNED NULL DEFAULT NULL,
  `working_contract_id` int UNSIGNED NULL DEFAULT NULL,
  `has_spare_part` int UNSIGNED NOT NULL,
  `spare_part_is_free` int UNSIGNED NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenance_lines_invoice_maintenance_group_id_foreign`(`invoice_maintenance_group_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_invoice_maintenance_id_foreign`(`invoice_maintenance_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_invoice_maintenance_type_id_foreign`(`invoice_maintenance_type_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_invoice_maintenance_state_id_foreign`(`invoice_maintenance_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_employee_user_id_foreign`(`employee_user_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_journal_entry_id_foreign`(`journal_entry_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_working_contract_id_foreign`(`working_contract_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_has_spare_part_foreign`(`has_spare_part` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_spare_part_is_free_foreign`(`spare_part_is_free` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_lines_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenance_lines_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_employee_user_id_foreign` FOREIGN KEY (`employee_user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_has_spare_part_foreign` FOREIGN KEY (`has_spare_part`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_invoice_maintenance_group_id_foreign` FOREIGN KEY (`invoice_maintenance_group_id`) REFERENCES `invoice_maintenance_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_invoice_maintenance_id_foreign` FOREIGN KEY (`invoice_maintenance_id`) REFERENCES `invoice_maintenances` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_invoice_maintenance_state_id_foreign` FOREIGN KEY (`invoice_maintenance_state_id`) REFERENCES `invoice_maintenance_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_invoice_maintenance_type_id_foreign` FOREIGN KEY (`invoice_maintenance_type_id`) REFERENCES `invoice_maintenance_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_journal_entry_id_foreign` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_spare_part_is_free_foreign` FOREIGN KEY (`spare_part_is_free`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_lines_working_contract_id_foreign` FOREIGN KEY (`working_contract_id`) REFERENCES `working_contracts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenance_lines
-- ----------------------------

-- ----------------------------
-- Table structure for invoice_maintenance_status
-- ----------------------------
CREATE TABLE `invoice_maintenance_status`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenance_status_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_status_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_status_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_status_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenance_status_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_status_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_status_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_status_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenance_status
-- ----------------------------
INSERT INTO `invoice_maintenance_status` VALUES (1, 'تحت الصيانة', '1', 'Avaliable', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);
INSERT INTO `invoice_maintenance_status` VALUES (2, 'انتهت', '2', 'Finshed', NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for invoice_maintenance_types
-- ----------------------------
CREATE TABLE `invoice_maintenance_types`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `create_schedules` int UNSIGNED NOT NULL,
  `invoice_maintenance_kind_id` int UNSIGNED NOT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenance_types_create_schedules_foreign`(`create_schedules` ASC) USING BTREE,
  INDEX `invoice_maintenance_types_invoice_maintenance_kind_id_foreign`(`invoice_maintenance_kind_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_types_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_types_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenance_types_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenance_types_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenance_types_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_types_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_types_create_schedules_foreign` FOREIGN KEY (`create_schedules`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_types_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenance_types_invoice_maintenance_kind_id_foreign` FOREIGN KEY (`invoice_maintenance_kind_id`) REFERENCES `invoice_maintenance_kinds` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenance_types
-- ----------------------------
INSERT INTO `invoice_maintenance_types` VALUES (1, 'صيانة  شهرية', '1', 'Monthly', 1, 3, NULL, 1, NULL, NULL, NULL, NULL, '2025-06-12 14:05:57', '2025-06-12 14:05:57', NULL);

-- ----------------------------
-- Table structure for invoice_maintenances
-- ----------------------------
CREATE TABLE `invoice_maintenances`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `invoice_maintenance_group_id` int UNSIGNED NOT NULL,
  `line_id` int UNSIGNED NULL DEFAULT NULL,
  `journal_entry_id` int UNSIGNED NULL DEFAULT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `invoice_maintenance_state_id` int UNSIGNED NOT NULL,
  `working_contract_id` int UNSIGNED NULL DEFAULT NULL,
  `invoice_maintenance_type_id` int UNSIGNED NOT NULL,
  `has_spare_part` int UNSIGNED NOT NULL,
  `spare_part_is_free` int UNSIGNED NOT NULL,
  `from_date` date NULL DEFAULT NULL,
  `to_date` date NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `created_by` int UNSIGNED NULL DEFAULT NULL,
  `deleted_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_by` int UNSIGNED NULL DEFAULT NULL,
  `approved_date` date NULL DEFAULT NULL,
  `approved_state_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `invoice_maintenances_invoice_maintenance_group_id_foreign`(`invoice_maintenance_group_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_journal_entry_id_foreign`(`journal_entry_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_invoice_maintenance_state_id_foreign`(`invoice_maintenance_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_working_contract_id_foreign`(`working_contract_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_invoice_maintenance_type_id_foreign`(`invoice_maintenance_type_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_has_spare_part_foreign`(`has_spare_part` ASC) USING BTREE,
  INDEX `invoice_maintenances_spare_part_is_free_foreign`(`spare_part_is_free` ASC) USING BTREE,
  INDEX `invoice_maintenances_approved_by_foreign`(`approved_by` ASC) USING BTREE,
  INDEX `invoice_maintenances_approved_state_id_foreign`(`approved_state_id` ASC) USING BTREE,
  INDEX `invoice_maintenances_created_by_foreign`(`created_by` ASC) USING BTREE,
  INDEX `invoice_maintenances_deleted_by_foreign`(`deleted_by` ASC) USING BTREE,
  CONSTRAINT `invoice_maintenances_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_approved_state_id_foreign` FOREIGN KEY (`approved_state_id`) REFERENCES `approval_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_deleted_by_foreign` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_has_spare_part_foreign` FOREIGN KEY (`has_spare_part`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_invoice_maintenance_group_id_foreign` FOREIGN KEY (`invoice_maintenance_group_id`) REFERENCES `invoice_maintenance_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_invoice_maintenance_state_id_foreign` FOREIGN KEY (`invoice_maintenance_state_id`) REFERENCES `invoice_maintenance_status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_invoice_maintenance_type_id_foreign` FOREIGN KEY (`invoice_maintenance_type_id`) REFERENCES `invoice_maintenance_types` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_journal_entry_id_foreign` FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_spare_part_is_free_foreign` FOREIGN KEY (`spare_part_is_free`) REFERENCES `status` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `invoice_maintenances_working_contract_id_foreign` FOREIGN KEY (`working_contract_id`) REFERENCES `working_contracts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of invoice_maintenances
-- ----------------------------

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
CREATE TABLE `jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED NULL DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jobs_queue_index`(`queue` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 74 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of jobs
-- ----------------------------
INSERT INTO `jobs` VALUES (1, 'default', '{\"uuid\":\"faff9477-b18f-4d58-aa58-c61da647ff86\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:1;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1751976851, 1751976851);
INSERT INTO `jobs` VALUES (2, 'default', '{\"uuid\":\"5be5a847-90bf-492d-87fd-c51fa200e900\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:1;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1751977039, 1751977039);
INSERT INTO `jobs` VALUES (3, 'default', '{\"uuid\":\"fb43374a-8a4f-49f2-987a-522b815c96dd\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:7;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1751977433, 1751977433);
INSERT INTO `jobs` VALUES (4, 'default', '{\"uuid\":\"0c012ce3-2b01-410e-9d98-37bf0b39f45f\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:8;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1751977469, 1751977469);
INSERT INTO `jobs` VALUES (5, 'default', '{\"uuid\":\"0cc979d1-91c3-4ce4-904c-3182977d10c7\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:35;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056002, 1752056002);
INSERT INTO `jobs` VALUES (6, 'default', '{\"uuid\":\"726f096f-313b-4d89-a4e1-fbabce02fcaf\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:29;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056040, 1752056040);
INSERT INTO `jobs` VALUES (7, 'default', '{\"uuid\":\"138cd21f-aa59-471b-a53d-76327e37130f\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:30;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056075, 1752056075);
INSERT INTO `jobs` VALUES (8, 'default', '{\"uuid\":\"4740903b-590b-4079-83aa-301a365a82b7\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:31;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056106, 1752056106);
INSERT INTO `jobs` VALUES (9, 'default', '{\"uuid\":\"044a065b-1917-4941-8bfe-aeefe1adb399\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:32;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056191, 1752056191);
INSERT INTO `jobs` VALUES (10, 'default', '{\"uuid\":\"d51300c9-98fa-4993-ba83-84ef66195175\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:35;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056221, 1752056221);
INSERT INTO `jobs` VALUES (11, 'default', '{\"uuid\":\"78d92d19-7864-4316-b005-b116bf52d7a5\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:32;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056265, 1752056265);
INSERT INTO `jobs` VALUES (12, 'default', '{\"uuid\":\"a411f50e-d82c-42c7-9f4a-da8e22947143\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:39;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056805, 1752056805);
INSERT INTO `jobs` VALUES (13, 'default', '{\"uuid\":\"4aaa75aa-fe9b-4324-bbef-2c6f0ceab511\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:38;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056826, 1752056826);
INSERT INTO `jobs` VALUES (14, 'default', '{\"uuid\":\"40069709-c26e-47d7-aba7-270c037077af\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:37;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056846, 1752056846);
INSERT INTO `jobs` VALUES (15, 'default', '{\"uuid\":\"3bc37e22-1735-446b-96fd-6a4170f25e3d\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:36;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056863, 1752056863);
INSERT INTO `jobs` VALUES (16, 'default', '{\"uuid\":\"555d65ed-379a-4ea4-a68c-d3e09a101083\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:35;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056888, 1752056888);
INSERT INTO `jobs` VALUES (17, 'default', '{\"uuid\":\"f50ea960-d428-48a1-a9b6-102eea367c13\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:34;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056912, 1752056912);
INSERT INTO `jobs` VALUES (18, 'default', '{\"uuid\":\"50574650-6d74-4e6f-8642-25358ac2b64e\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:33;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056932, 1752056932);
INSERT INTO `jobs` VALUES (19, 'default', '{\"uuid\":\"9490c959-0c1f-4c48-82e7-b6b8f112b107\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:32;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056950, 1752056950);
INSERT INTO `jobs` VALUES (20, 'default', '{\"uuid\":\"452f9936-70e2-44c8-8b23-322da825d70d\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:31;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752056981, 1752056981);
INSERT INTO `jobs` VALUES (21, 'default', '{\"uuid\":\"bbd87623-6fbb-4cbf-85bf-fd458ca57058\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:29;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752057006, 1752057006);
INSERT INTO `jobs` VALUES (22, 'default', '{\"uuid\":\"69fc3a22-e297-4aa5-8013-98e4411070a8\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:30;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752057039, 1752057039);
INSERT INTO `jobs` VALUES (23, 'default', '{\"uuid\":\"689ee69d-d8cf-44da-a633-4c720691b8d8\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:32;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752057067, 1752057067);
INSERT INTO `jobs` VALUES (24, 'default', '{\"uuid\":\"3e02369d-75f1-4128-811d-5add90e1a106\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:1;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752474212, 1752474212);
INSERT INTO `jobs` VALUES (25, 'default', '{\"uuid\":\"b32cb35f-f78c-4de0-bd99-777fce996007\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:45;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752866668, 1752866668);
INSERT INTO `jobs` VALUES (26, 'default', '{\"uuid\":\"a18f294c-2788-4e67-bca0-6771ab3b6c90\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:45;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752868780, 1752868780);
INSERT INTO `jobs` VALUES (27, 'default', '{\"uuid\":\"3648792e-1000-471e-aa33-293544141173\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:45;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752868800, 1752868800);
INSERT INTO `jobs` VALUES (28, 'default', '{\"uuid\":\"33380efa-5930-4bd8-bcf6-6bdf04a39ae2\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:45;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998264, 1752998264);
INSERT INTO `jobs` VALUES (29, 'default', '{\"uuid\":\"9a8aae33-2d9e-4758-88cf-338563172f3e\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:44;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998468, 1752998468);
INSERT INTO `jobs` VALUES (30, 'default', '{\"uuid\":\"2c8459f2-439d-4945-bd8f-b124f393906d\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:43;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998496, 1752998496);
INSERT INTO `jobs` VALUES (31, 'default', '{\"uuid\":\"4831b152-4776-43ae-a5b0-5f7fa50e9486\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:42;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998522, 1752998522);
INSERT INTO `jobs` VALUES (32, 'default', '{\"uuid\":\"0e33ab02-2371-4ee4-9101-1127b55d76fe\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:41;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998555, 1752998555);
INSERT INTO `jobs` VALUES (33, 'default', '{\"uuid\":\"2e70f79f-d63d-4b19-a5ba-48fefc75f26d\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:40;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998578, 1752998578);
INSERT INTO `jobs` VALUES (34, 'default', '{\"uuid\":\"2db30396-d587-4646-993d-7a1dce27dce8\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:39;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998599, 1752998599);
INSERT INTO `jobs` VALUES (35, 'default', '{\"uuid\":\"9aa0ce34-8c08-4079-9003-fa3e00bf2097\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:38;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998611, 1752998611);
INSERT INTO `jobs` VALUES (36, 'default', '{\"uuid\":\"64a8819a-efbe-453a-a9bc-5a47a1b03134\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:37;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998626, 1752998626);
INSERT INTO `jobs` VALUES (37, 'default', '{\"uuid\":\"9f30bee8-683e-45be-956b-c4c5c67e905d\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:36;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998640, 1752998640);
INSERT INTO `jobs` VALUES (38, 'default', '{\"uuid\":\"b263cdcf-5794-465d-bedc-343449b74078\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:35;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998671, 1752998671);
INSERT INTO `jobs` VALUES (39, 'default', '{\"uuid\":\"70d80a21-00c6-41d6-b3f2-fa88447ec8b1\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:34;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998684, 1752998684);
INSERT INTO `jobs` VALUES (40, 'default', '{\"uuid\":\"a9cd7d78-f648-4790-8370-f59c2fa8d6ee\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:33;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998697, 1752998697);
INSERT INTO `jobs` VALUES (41, 'default', '{\"uuid\":\"a39b8f16-aa62-4eb9-9b1b-e34dc35aa437\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:32;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998717, 1752998717);
INSERT INTO `jobs` VALUES (42, 'default', '{\"uuid\":\"2c1a0102-e4d1-4df0-8e7b-4c6417b79bb5\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:31;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998730, 1752998730);
INSERT INTO `jobs` VALUES (43, 'default', '{\"uuid\":\"826e5903-4d02-493c-99ea-ee03f7a8d929\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:30;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998745, 1752998745);
INSERT INTO `jobs` VALUES (44, 'default', '{\"uuid\":\"49783fd3-aabd-46fa-ae16-fdf035bf4541\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:29;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998758, 1752998758);
INSERT INTO `jobs` VALUES (45, 'default', '{\"uuid\":\"4a83177d-ef81-4ca0-b697-c8ec58e4b29f\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:28;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998772, 1752998772);
INSERT INTO `jobs` VALUES (46, 'default', '{\"uuid\":\"07720865-0f7b-48aa-8e1b-32614ad0a805\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:27;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998785, 1752998785);
INSERT INTO `jobs` VALUES (47, 'default', '{\"uuid\":\"1d8a077f-d4ca-4cd6-b042-7c1e6da3f980\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:26;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998799, 1752998799);
INSERT INTO `jobs` VALUES (48, 'default', '{\"uuid\":\"f02accc9-1705-4fe4-bc27-df2f48cda573\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:25;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998815, 1752998815);
INSERT INTO `jobs` VALUES (49, 'default', '{\"uuid\":\"6624728b-4804-48bb-a1ef-b38c7f14d39c\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:24;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998832, 1752998832);
INSERT INTO `jobs` VALUES (50, 'default', '{\"uuid\":\"3d3530cd-aca3-492b-b480-8a5ce73c99dd\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:23;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998845, 1752998845);
INSERT INTO `jobs` VALUES (51, 'default', '{\"uuid\":\"57e82a89-5456-4317-bae0-3725c3ab10fe\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:22;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998874, 1752998874);
INSERT INTO `jobs` VALUES (52, 'default', '{\"uuid\":\"ec4872f4-847d-4b6d-8369-09878bbe6c6e\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:21;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998892, 1752998892);
INSERT INTO `jobs` VALUES (53, 'default', '{\"uuid\":\"88ef4b12-ea69-46a6-b771-53f2d5e57518\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:20;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998914, 1752998914);
INSERT INTO `jobs` VALUES (54, 'default', '{\"uuid\":\"3c0fe811-d199-4584-9ff3-3a98b8511135\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:19;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998935, 1752998935);
INSERT INTO `jobs` VALUES (55, 'default', '{\"uuid\":\"8e294591-c94c-4a3e-9066-76d0fc6212ee\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:20;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998953, 1752998953);
INSERT INTO `jobs` VALUES (56, 'default', '{\"uuid\":\"dd6cbc60-07a9-47e6-a716-b375391664d9\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:18;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998968, 1752998968);
INSERT INTO `jobs` VALUES (57, 'default', '{\"uuid\":\"522e3ac8-d013-4731-9b55-44b037e2b5aa\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:17;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998984, 1752998984);
INSERT INTO `jobs` VALUES (58, 'default', '{\"uuid\":\"0319b55a-379a-4f5f-9455-aa79a2f5b95c\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:16;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752998997, 1752998997);
INSERT INTO `jobs` VALUES (59, 'default', '{\"uuid\":\"548e4545-5230-453f-a4c2-fc42f51c6106\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:15;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999019, 1752999019);
INSERT INTO `jobs` VALUES (60, 'default', '{\"uuid\":\"6c9c5394-1f80-4e2f-bded-196e1af05053\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:14;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999034, 1752999034);
INSERT INTO `jobs` VALUES (61, 'default', '{\"uuid\":\"161d3f1c-3e69-408d-8447-87d1f98baa3f\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:13;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999049, 1752999049);
INSERT INTO `jobs` VALUES (62, 'default', '{\"uuid\":\"07d1bb75-f93b-48dd-a6c3-b713b18c14a3\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:12;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999065, 1752999065);
INSERT INTO `jobs` VALUES (63, 'default', '{\"uuid\":\"83e21cf3-bc38-440d-8dc4-50d648be72a5\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:11;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999084, 1752999084);
INSERT INTO `jobs` VALUES (64, 'default', '{\"uuid\":\"03b4ed2e-f7af-4560-916e-33df81491231\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:10;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999098, 1752999098);
INSERT INTO `jobs` VALUES (65, 'default', '{\"uuid\":\"f36ad8c4-e95d-4d27-9f34-0eaac8c14f53\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:9;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999188, 1752999188);
INSERT INTO `jobs` VALUES (66, 'default', '{\"uuid\":\"777980ec-c8ee-4349-bf34-792c1585d831\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:8;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999206, 1752999206);
INSERT INTO `jobs` VALUES (67, 'default', '{\"uuid\":\"0cb03ad5-be9b-419a-9b02-af337ef0c5ac\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:7;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999223, 1752999223);
INSERT INTO `jobs` VALUES (68, 'default', '{\"uuid\":\"4d7d579c-f839-4228-960a-fccfe6ab7cfb\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:6;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999245, 1752999245);
INSERT INTO `jobs` VALUES (69, 'default', '{\"uuid\":\"dad89577-5972-4324-9be9-3d82db6525b4\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:5;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999268, 1752999268);
INSERT INTO `jobs` VALUES (70, 'default', '{\"uuid\":\"43fb0de3-ecff-49a5-90ff-ee7bf888f8e1\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:4;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999287, 1752999287);
INSERT INTO `jobs` VALUES (71, 'default', '{\"uuid\":\"55eededf-c1e0-4af3-b978-979acf6b18cc\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:3;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999304, 1752999304);
INSERT INTO `jobs` VALUES (72, 'default', '{\"uuid\":\"4a9c72d5-6f85-4b4d-bef1-c3ab1b9508cf\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:2;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999325, 1752999325);
INSERT INTO `jobs` VALUES (73, 'default', '{\"uuid\":\"95d036b3-bdbc-428a-bb43-3b5cdf5b9c7e\",\"displayName\":\"App\\\\Events\\\\Products_event\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":13:{s:5:\\\"event\\\";O:25:\\\"App\\\\Events\\\\Products_event\\\":1:{s:10:\\\"\\u0000*\\u0000product\\\";i:1;}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}', 0, NULL, 1752999340, 1752999340);

-- ----------------------------
