-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `rocketsoft_flowcheck`
--

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

--
-- Table structure for table `abandoned_cart_rules`
--

CREATE TABLE `abandoned_cart_rules` (
  `id` int(10) UNSIGNED NOT NULL,
  `target_type` enum('all','courses','store_products','bundles','meetings') NOT NULL DEFAULT 'all',
  `target` varchar(255) DEFAULT NULL,
  `action` enum('send_reminder','send_coupon') NOT NULL,
  `discount_id` int(10) UNSIGNED DEFAULT NULL,
  `action_cycle` int(10) UNSIGNED NOT NULL,
  `repeat_action` tinyint(1) NOT NULL DEFAULT 0,
  `repeat_action_count` int(10) UNSIGNED DEFAULT NULL,
  `minimum_cart_amount` double(15,2) UNSIGNED DEFAULT NULL,
  `maximum_cart_amount` double(15,2) UNSIGNED DEFAULT NULL,
  `start_at` bigint(20) UNSIGNED DEFAULT NULL,
  `end_at` bigint(20) UNSIGNED DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `abandoned_cart_rules`
--

INSERT INTO `abandoned_cart_rules` (`id`, `target_type`, `target`, `action`, `discount_id`, `action_cycle`, `repeat_action`, `repeat_action_count`, `minimum_cart_amount`, `maximum_cart_amount`, `start_at`, `end_at`, `enable`, `created_at`) VALUES
(1, 'all', NULL, 'send_reminder', NULL, 12, 1, 5, 200.00, 1000.00, 1709269200, 1837137600, 0, 1709794892),
(2, 'courses', 'all_courses', 'send_coupon', 25, 18, 1, 3, 50.00, NULL, 1709330400, 1838246400, 0, 1709888086);

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

--
-- Table structure for table `abandoned_cart_rule_histories`
--

CREATE TABLE `abandoned_cart_rule_histories` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `cart_rule_id` int(10) UNSIGNED DEFAULT NULL,
  `rule_action` enum('send_reminder','send_coupon') NOT NULL,
  `type` enum('auto','manual') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'auto',
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `abandoned_cart_rule_specification_items`
--

CREATE TABLE `abandoned_cart_rule_specification_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `abandoned_cart_rule_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `instructor_id` int(10) UNSIGNED DEFAULT NULL,
  `seller_id` int(10) UNSIGNED DEFAULT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `abandoned_cart_rule_translations`
--

CREATE TABLE `abandoned_cart_rule_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `abandoned_cart_rule_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `abandoned_cart_rule_translations`
--

INSERT INTO `abandoned_cart_rule_translations` (`id`, `abandoned_cart_rule_id`, `locale`, `title`) VALUES
(1, 1, 'en', 'Cart Reminder Rule'),
(2, 2, 'en', 'Discount Offer Rule');

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

--
-- Table structure for table `abandoned_cart_rule_users_groups`
--

CREATE TABLE `abandoned_cart_rule_users_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `abandoned_cart_rule_id` int(10) UNSIGNED NOT NULL,
  `group_id` int(10) UNSIGNED DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `accounting`
--

CREATE TABLE `accounting` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `order_item_id` int(10) UNSIGNED DEFAULT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `event_ticket_id` int(10) UNSIGNED DEFAULT NULL,
  `meeting_time_id` int(10) UNSIGNED DEFAULT NULL,
  `meeting_package_id` int(10) UNSIGNED DEFAULT NULL,
  `subscribe_id` int(10) UNSIGNED DEFAULT NULL,
  `promotion_id` int(10) UNSIGNED DEFAULT NULL,
  `registration_package_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `installment_payment_id` int(10) UNSIGNED DEFAULT NULL,
  `installment_order_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'This field is filled in the seller''s financial document to find the installment order',
  `gift_id` int(10) UNSIGNED DEFAULT NULL,
  `system` tinyint(1) NOT NULL DEFAULT 0,
  `tax` tinyint(1) NOT NULL DEFAULT 0,
  `amount` decimal(13,2) DEFAULT NULL,
  `type` enum('addiction','deduction') NOT NULL,
  `type_account` enum('income','asset','subscribe','promotion','registration_package','installment_payment') DEFAULT NULL,
  `store_type` enum('automatic','manual') NOT NULL DEFAULT 'automatic',
  `referred_user_id` int(10) UNSIGNED DEFAULT NULL,
  `is_affiliate_amount` tinyint(1) NOT NULL DEFAULT 0,
  `is_affiliate_commission` tinyint(1) NOT NULL DEFAULT 0,
  `is_registration_bonus` tinyint(1) NOT NULL DEFAULT 0,
  `is_cashback` tinyint(1) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `created_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `accounting`
--

INSERT INTO `accounting` (`id`, `user_id`, `creator_id`, `order_item_id`, `webinar_id`, `bundle_id`, `event_ticket_id`, `meeting_time_id`, `meeting_package_id`, `subscribe_id`, `promotion_id`, `registration_package_id`, `product_id`, `installment_payment_id`, `installment_order_id`, `gift_id`, `system`, `tax`, `amount`, `type`, `type_account`, `store_type`, `referred_user_id`, `is_affiliate_amount`, `is_affiliate_commission`, `is_registration_bonus`, `is_cashback`, `description`, `created_at`) VALUES
(251, 996, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 500.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1625944212),
(252, 996, NULL, NULL, NULL, NULL, NULL, 98, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 165.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:30 hours of consultation', 1625944347),
(253, 996, NULL, NULL, NULL, NULL, NULL, 98, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 15.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625944347),
(254, 1015, NULL, NULL, NULL, NULL, NULL, 98, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 120.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625944347),
(255, 1015, NULL, NULL, NULL, NULL, NULL, 98, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 30.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625944347),
(256, 930, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 600.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'Gifts from the platform', 1625950715),
(257, 995, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1000.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1625950749),
(258, 995, NULL, NULL, NULL, NULL, NULL, 160, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:00 hours of consultation', 1625952630),
(259, 995, NULL, NULL, NULL, NULL, NULL, 160, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625952630),
(260, 934, NULL, NULL, NULL, NULL, NULL, 160, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625952630),
(261, 934, NULL, NULL, NULL, NULL, NULL, 160, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625952630),
(262, 995, NULL, NULL, 2005, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 11.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1625953197),
(263, 995, NULL, NULL, 2005, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625953198),
(264, 4, NULL, NULL, 2005, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625953198),
(265, 4, NULL, NULL, 2005, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625953198),
(266, 979, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 400.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1625992548),
(267, 995, NULL, NULL, NULL, NULL, NULL, 103, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 137.50, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:15 hours of consultation', 1625996816),
(268, 995, NULL, NULL, NULL, NULL, NULL, 103, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 12.50, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625996817),
(269, 1015, NULL, NULL, NULL, NULL, NULL, 103, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 100.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625996817),
(270, 1015, NULL, NULL, NULL, NULL, NULL, 103, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 25.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625996817),
(271, 995, NULL, NULL, 1999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 55.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1625996942),
(272, 995, NULL, NULL, 1999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 5.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625996943),
(273, 929, NULL, NULL, 1999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 45.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625996943),
(274, 929, NULL, NULL, 1999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 5.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625996943),
(275, 995, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 55.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1625996979),
(276, 995, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 5.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625996979),
(277, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 40.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625996979),
(278, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625996979),
(279, 995, NULL, NULL, 2001, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 17.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1625997105),
(280, 995, NULL, NULL, 2001, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1625997106),
(281, 3, NULL, NULL, 2001, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 14.40, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1625997106),
(282, 3, NULL, NULL, 2001, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1.60, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1625997106),
(283, 996, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.75, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626060488),
(284, 996, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2.25, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626060488),
(285, 867, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 18.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626060488),
(286, 867, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626060488),
(287, 996, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 44.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626060553),
(288, 996, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 4.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626060553),
(289, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 32.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626060553),
(290, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 8.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626060553),
(291, 930, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 55.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626060836),
(292, 930, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 5.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626060837),
(293, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 40.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626060837),
(294, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626060837),
(295, 1015, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 332.00, 'deduction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Payout request', 1626061220),
(296, 979, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 66.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626061333),
(297, 979, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 6.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626061334),
(298, 929, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 54.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626061334),
(299, 929, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 6.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626061334),
(300, 979, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 22.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626061374),
(301, 979, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626061374),
(302, 863, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 16.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626061374),
(303, 863, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626061374),
(304, 979, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626061375),
(305, 979, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626061376),
(306, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626061376),
(307, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 6.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626061376),
(308, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 22.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626061450),
(309, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626061451),
(310, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'subscribe', 'automatic', NULL, 0, 0, 0, 0, 'Income for Subscribe', 1626061451),
(311, 867, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0.16, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061483),
(312, 1, NULL, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0.16, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061483),
(313, 929, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0.16, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061490),
(314, 1, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0.16, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061490),
(315, 863, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0.16, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061494),
(316, 1, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0.16, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Subscribe', 1626061494),
(317, 1015, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 500.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1626132570),
(318, 1015, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 17.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626132845),
(319, 1015, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626132845),
(320, 863, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 12.80, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626132845),
(321, 863, NULL, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.20, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626132845),
(322, 929, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 300.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1626241074),
(323, 929, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 0, 0, 55.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626241152),
(324, 929, NULL, NULL, 2004, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 0, 1, 5.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626241153),
(325, 929, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, 1, 0, 50.00, 'addiction', 'promotion', 'automatic', NULL, 0, 0, 0, 0, 'Paid for Promotion', 1626241153),
(326, 929, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626241213),
(327, 929, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626241214),
(328, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626241214),
(329, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 6.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626241214),
(330, 995, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:00 hours of consultation', 1626247196),
(331, 995, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626247196),
(332, 870, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626247196),
(333, 870, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626247196),
(334, 995, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Refunded to Buyer', 1626247245),
(335, NULL, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Refunded Tax', 1626247245),
(336, 870, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 100.00, 'deduction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Refunded Income', 1626247245),
(337, 870, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Refunded Commission to Seller', 1626247245),
(338, 870, NULL, NULL, NULL, NULL, NULL, 114, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'deduction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Refunded Commission', 1626247245),
(339, 996, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 29.70, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1626508957),
(340, 996, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2.70, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1626508957),
(341, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 21.60, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1626508957),
(342, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 5.40, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1626508957),
(343, 930, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 250.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1628704280),
(344, 923, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 300.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1628704284),
(345, 995, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 200.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1628704378),
(346, 995, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 100.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1628704382),
(347, 996, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 200.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'offline payment approved', 1628704397),
(348, 929, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1635412197),
(349, 929, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1635412197),
(350, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1635412197),
(351, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 6.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1635412197),
(352, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', 1017, 1, 0, 0, 0, 'public.get_amount_from_referral', 1639378855),
(353, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 80.00, 'deduction', 'income', 'automatic', 1017, 1, 0, 0, 0, 'public.get_amount_from_referral', 1639378855),
(354, 1017, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 50.00, 'addiction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'public.get_amount_from_referral', 1639378855),
(355, 1017, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 50.00, 'deduction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'public.get_amount_from_referral', 1639378855),
(356, 1017, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 500.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'charging for test', 1639379205),
(357, 1017, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1639379284),
(358, 1017, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1639379285),
(359, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1639379285),
(360, 867, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1639379285),
(361, 1015, NULL, NULL, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1.50, 'addiction', 'income', 'automatic', 1017, 0, 1, 0, 0, 'public.get_commission_from_referral', 1639379285),
(362, 1017, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1639379351),
(363, 1017, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1639379352),
(364, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1639379352),
(365, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 15.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1639379352),
(366, 1015, NULL, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 5.00, 'addiction', 'income', 'automatic', 1017, 0, 1, 0, 0, 'public.get_commission_from_referral', 1639379352),
(367, 1017, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form Credit', 1639379394),
(368, 1017, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form Buyer', 1639379395),
(369, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1639379395),
(370, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from Seller', 1639379395),
(371, 1015, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1.50, 'addiction', 'income', 'automatic', 1017, 0, 1, 0, 0, 'public.get_commission_from_referral', 1639379395),
(372, 995, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 11.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646172087),
(373, 995, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646172087),
(374, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1646172087),
(375, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Get Commission From Seller', 1646172087),
(376, 996, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 9.90, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646172124),
(377, 996, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0.90, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646172124),
(378, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 7.20, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1646172124),
(379, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1.80, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Get Commission From Seller', 1646172124),
(380, 979, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 11.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646172160),
(381, 979, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646172160),
(382, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1646172160),
(383, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Get Commission From Seller', 1646172160),
(384, 929, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 11.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646172296),
(385, 929, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646172297),
(386, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1646172297),
(387, 1015, NULL, NULL, 2009, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Get Commission From Seller', 1646172297),
(388, 995, NULL, NULL, NULL, NULL, NULL, 169, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 825.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:00 hours of consultation', 1646379290),
(389, 995, NULL, NULL, NULL, NULL, NULL, 169, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 75.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646379290),
(390, 1015, NULL, NULL, NULL, NULL, NULL, 169, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 600.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Income Sale', 1646379290),
(391, 1015, NULL, NULL, NULL, NULL, NULL, 169, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 150.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Get Commission From Seller', 1646379290),
(392, 867, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 200.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'gift', 1646381415),
(393, 930, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 0, 0, 218.90, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646386792),
(394, 930, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 0, 1, 19.90, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646386797),
(395, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 1, 0, 199.00, 'addiction', 'registration_package', 'automatic', NULL, 0, 0, 0, 0, 'Paid For Registration Package', 1646386797),
(396, 859, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 500.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'Charge for the test.', 1646387608),
(397, 859, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 0, 0, 220.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid Form Credit', 1646387660),
(398, 859, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 0, 1, 20.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax Get Form Buyer', 1646387660),
(399, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 1, 0, 200.00, 'addiction', 'registration_package', 'automatic', NULL, 0, 0, 0, 0, 'Paid For Registration Package', 1646387660),
(400, 930, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 55.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656083263),
(401, 930, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 5.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656083263),
(402, 1015, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 40.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656083263),
(403, 1015, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656083263),
(404, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, 0, 5.25, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656103844),
(405, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, 1, 0.25, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656103844),
(406, 1016, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, 0, 4.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656103844),
(407, 1016, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 1, 0, 1.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656103844),
(408, 923, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 31.25, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656104131),
(409, 923, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 1, 1.25, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656104132),
(410, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 27.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656104132),
(411, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, 2.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656104132),
(412, 996, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 39.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656130482),
(413, 996, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656130482),
(414, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 28.80, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656130482),
(415, 864, NULL, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 7.20, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656130482),
(416, 930, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, 0, 314.50, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656130707),
(417, 930, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, 1, 14.50, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656130707),
(418, 934, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, 0, 271.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656130707),
(419, 934, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 0, 29.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656130707),
(420, 996, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, 0, 78.75, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656130963),
(421, 996, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, 1, 3.75, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656130964),
(422, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, 0, 60.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656130964),
(423, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 1, 0, 15.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656130964),
(424, 979, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.80, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656139704),
(425, 979, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0.80, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656139705),
(426, 934, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 6.40, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656139705),
(427, 934, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1.60, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656139705),
(428, 979, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 27.50, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656139705),
(429, 979, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 2.50, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656139706),
(430, 929, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656139706),
(431, 929, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 5.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656139706),
(432, 1017, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 26.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656148574),
(433, 1017, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656148574),
(434, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 23.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656148574),
(435, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, 2.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656148574),
(436, 995, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 300.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'Gift Balance', 1656148789),
(437, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 52.25, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656148838),
(438, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 1, 2.25, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656148838),
(439, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, 45.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656148838),
(440, 1015, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, 4.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656148838),
(441, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, 0, 17.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1656322658),
(442, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, 1, 1.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1656322658),
(443, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, 0, 12.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1656322658),
(444, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 1, 0, 4.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1656322658),
(739, 870, NULL, NULL, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1678915553),
(740, 870, NULL, NULL, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1678915553),
(744, 979, NULL, 694, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 0, 0, 39.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1678919437),
(745, 979, NULL, 694, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 0, 1, 3.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1678919437),
(746, 929, NULL, 694, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 32.40, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1678919437),
(747, 929, NULL, 694, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.60, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1678919437),
(788, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 20.00, 'addiction', 'income', 'automatic', 1045, 1, 0, 0, 0, 'Affiliate income', 1678958778),
(789, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'deduction', 'income', 'automatic', 1045, 1, 0, 0, 0, 'Affiliate income', 1678958778),
(790, 1045, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 10.00, 'addiction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'Affiliate income', 1678958778),
(791, 1045, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'deduction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'Affiliate income', 1678958778),
(792, 1045, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 150.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'test', 1678959187),
(793, 1045, NULL, 701, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1678959222),
(794, 1045, NULL, 701, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1678959222),
(795, 870, NULL, 701, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1678959222),
(796, 870, NULL, 701, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 15.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1678959222),
(797, 995, NULL, 701, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 5.00, 'addiction', 'income', 'automatic', 1045, 0, 1, 0, 0, 'Affiliate income', 1678959222),
(798, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 20.00, 'addiction', 'income', 'automatic', 1046, 1, 0, 0, 0, 'Affiliate income', 1678959533),
(799, 995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'deduction', 'income', 'automatic', 1046, 1, 0, 0, 0, 'Affiliate income', 1678959533),
(800, 1046, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 10.00, 'addiction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'Affiliate income', 1678959533),
(801, 1046, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'deduction', 'income', 'automatic', NULL, 1, 0, 0, 0, 'Affiliate income', 1678959533),
(805, 930, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 39.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1678961218),
(806, 930, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1678961218),
(807, 929, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 32.40, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1678961218),
(808, 929, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.60, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1678961218),
(809, 930, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.60, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Course', 1678961218),
(810, 930, NULL, 703, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.60, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Course', 1678961218),
(812, 870, NULL, NULL, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1678961558),
(816, 979, NULL, 704, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1678961652),
(817, 979, NULL, 704, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1678961652),
(818, 1045, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1679088431),
(819, 1045, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1679088431),
(820, 867, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 24.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1679088431),
(821, 867, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1679088431),
(822, 995, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1.50, 'addiction', 'income', 'automatic', 1045, 0, 1, 0, 0, 'Affiliate income', 1679088431),
(823, 1045, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Course', 1679088431),
(824, 1045, NULL, 705, 2000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Course', 1679088431),
(825, 995, NULL, 706, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1685783051),
(826, 995, NULL, 706, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1685783051),
(827, 1, NULL, 706, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, 0, 30.00, 'addiction', 'installment_payment', 'automatic', NULL, 0, 0, 0, 0, 'Installment Upfront', 1685783051),
(828, 995, NULL, 706, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1685783051),
(829, 995, NULL, 706, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1685783051),
(830, 870, NULL, NULL, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1685783075),
(831, 870, NULL, NULL, 2022, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 20.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Seller commission', 1685783075),
(832, 930, NULL, 707, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid form credit', 1685783153),
(833, 930, NULL, 707, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax form buyer', 1685783153),
(834, 1, NULL, 707, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 1, 0, 30.00, 'addiction', 'installment_payment', 'automatic', NULL, 0, 0, 0, 0, 'Installment Upfront', 1685783153),
(835, 930, NULL, 707, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1685783153),
(836, 930, NULL, 707, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1685783153),
(837, 1015, NULL, 708, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 44.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1751723593),
(838, 1015, NULL, 708, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 4.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1751723593),
(839, NULL, NULL, 708, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 40.00, 'addiction', 'subscribe', 'automatic', NULL, 0, 0, 0, 0, 'Subscription income', 1751723593),
(840, 1015, NULL, 708, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 4.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Subscribe', 1751723593),
(841, 1015, NULL, 708, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 4.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Subscribe', 1751723593),
(842, 995, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 110.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid for 1:00 hour(s) of consultation.', 1751723857),
(843, 995, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1751723857),
(844, 1015, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 70.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1751723857),
(845, 1015, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 30.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Commission from seller', 1751723857),
(846, 995, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 10.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Meeting', 1751723858),
(847, 995, NULL, 709, NULL, NULL, NULL, 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 10.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Meeting', 1751723858),
(848, 995, NULL, 710, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 33.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1763587190),
(849, 995, NULL, 710, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1763587198),
(850, 1015, NULL, 710, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 30.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1763587198),
(851, 995, NULL, 710, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 3.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1763587218);
INSERT INTO `accounting` (`id`, `user_id`, `creator_id`, `order_item_id`, `webinar_id`, `bundle_id`, `event_ticket_id`, `meeting_time_id`, `meeting_package_id`, `subscribe_id`, `promotion_id`, `registration_package_id`, `product_id`, `installment_payment_id`, `installment_order_id`, `gift_id`, `system`, `tax`, `amount`, `type`, `type_account`, `store_type`, `referred_user_id`, `is_affiliate_amount`, `is_affiliate_commission`, `is_registration_bonus`, `is_cashback`, `description`, `created_at`) VALUES
(852, 995, NULL, 710, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 3.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1763587218),
(853, 995, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 800.00, 'addiction', 'asset', 'manual', NULL, 0, 0, 0, 0, 'gift', 1763590906),
(854, 995, NULL, 712, NULL, NULL, 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 88.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1763591154),
(855, 995, NULL, 712, NULL, NULL, 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 8.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1763591163),
(856, 1015, NULL, 712, NULL, NULL, 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 80.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1763591163),
(857, 995, NULL, 712, NULL, NULL, 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1763591175),
(858, 995, NULL, 712, NULL, NULL, 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 8.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1763591175),
(859, 995, NULL, 713, NULL, NULL, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 99.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1763591242),
(860, 995, NULL, 713, NULL, NULL, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 9.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1763591250),
(861, 934, NULL, 713, NULL, NULL, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 90.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1763591250),
(862, 995, NULL, 713, NULL, NULL, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 9.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1763591262),
(863, 995, NULL, 713, NULL, NULL, 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 9.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1763591262),
(864, 995, NULL, 714, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 176.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1763621346),
(865, 995, NULL, 714, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 16.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1763621355),
(866, 1015, NULL, 714, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 160.00, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1763621355),
(867, 995, NULL, 714, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 16.00, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1763621375),
(868, 995, NULL, 714, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 16.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, NULL, 1763621375),
(869, 996, NULL, 715, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 95.00, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Paid via account credit', 1764055600),
(870, 996, NULL, 715, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 9.50, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 0, 'Tax received from buyer', 1764055608),
(871, 934, NULL, 715, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 85.50, 'addiction', 'income', 'automatic', NULL, 0, 0, 0, 0, 'Sales income', 1764055608),
(872, 996, NULL, 715, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 8.55, 'addiction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1764055628),
(873, 996, NULL, 715, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 8.55, 'deduction', 'asset', 'automatic', NULL, 0, 0, 0, 1, 'Cashback For Event Ticket', 1764055628);

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

--
-- Table structure for table `advertising_banners`
--

CREATE TABLE `advertising_banners` (
  `id` int(10) UNSIGNED NOT NULL,
  `position` enum('home1','home2','course','course_sidebar','product_show','bundle','bundle_sidebar','upcoming_course','upcoming_course_sidebar','event','event_sidebar') NOT NULL,
  `size` int(10) UNSIGNED NOT NULL DEFAULT 12,
  `link` varchar(255) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `advertising_banners`
--

INSERT INTO `advertising_banners` (`id`, `position`, `size`, `link`, `published`, `created_at`) VALUES
(6, 'course_sidebar', 12, '/instructor-finder', 1, 1607886391),
(7, 'course_sidebar', 12, '/reward-courses', 1, 1607886440),
(8, 'product_show', 12, '/forums', 1, 1656569687),
(9, 'bundle_sidebar', 12, '/reward-courses', 1, 1656571896);

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

--
-- Table structure for table `advertising_banners_translations`
--

CREATE TABLE `advertising_banners_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `advertising_banner_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertising_banners_translations`
--

INSERT INTO `advertising_banners_translations` (`id`, `advertising_banner_id`, `locale`, `title`, `image`) VALUES
(4, 6, 'en', 'Meeting Booking - Course page', '/store/1/default_images/banners/meeting-banner-side.png'),
(5, 7, 'en', 'Reward - Course page', '/store/1/default_images/banners/rewards-banner-side.png'),
(13, 6, 'ar', 'حجز اجتماع - صفحة الدورة', '/store/1/default_images/banners/reserve_a_meeting_ar.png'),
(14, 6, 'es', 'Reservar una reunión - página del curso', '/store/1/default_images/banners/reserve_a_meeting_es.png'),
(15, 7, 'ar', 'التحقق من صحة الشهادة - صفحة الدورة', '/store/1/default_images/banners/validate_certificates_banner_ar.png'),
(16, 7, 'es', 'Validación del certificado - página del curso', '/store/1/default_images/banners/validate_certificates_banner_es.png'),
(17, 8, 'en', 'Forums - Product page', '/store/1/default_images/banners/forum-banner-full.png'),
(18, 8, 'ar', 'المتجر - صفحة المنتج', '/store/1/default_images/banners/store_ar.png'),
(19, 8, 'es', 'Tienda - Página del producto', '/store/1/default_images/banners/store_es.png'),
(20, 9, 'en', 'Rewards - Bundle Sidebar', '/store/1/default_images/banners/rewards-banner-side.png'),
(21, 9, 'ar', 'حزمة الدورة - الشريط الجانبي', '/store/1/default_images/banners/bundle_ar.png'),
(22, 9, 'es', 'Paquete de cursos - Barra lateral', '/store/1/default_images/banners/bundle_es.png');

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

--
-- Table structure for table `affiliates`
--

CREATE TABLE `affiliates` (
  `id` int(10) UNSIGNED NOT NULL,
  `affiliate_user_id` int(10) UNSIGNED NOT NULL,
  `referred_user_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `affiliates`
--

INSERT INTO `affiliates` (`id`, `affiliate_user_id`, `referred_user_id`, `created_at`) VALUES
(1, 1015, 1017, 1639378855),
(14, 995, 1045, 1678958778),
(15, 995, 1046, 1678959533);

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

--
-- Table structure for table `affiliates_codes`
--

CREATE TABLE `affiliates_codes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(32) NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `affiliates_codes`
--

INSERT INTO `affiliates_codes` (`id`, `user_id`, `code`, `created_at`) VALUES
(2, 995, '422536', 1635366391),
(3, 996, '442769', 1635420731),
(4, 1015, '822047', 1639378662);

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

--
-- Table structure for table `ai_contents`
--

CREATE TABLE `ai_contents` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `service_type` enum('text','image') NOT NULL,
  `service_id` int(10) UNSIGNED DEFAULT NULL,
  `keyword` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `prompt` text DEFAULT NULL,
  `result` text DEFAULT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_contents`
--

INSERT INTO `ai_contents` (`id`, `user_id`, `service_type`, `service_id`, `keyword`, `language`, `prompt`, `result`, `created_at`) VALUES
(1, 1, 'text', 5, 'Laravel', 'English', 'Generate a text with the Laravel subject in English language with less than 100 word for a blog short description.', '{\"text\":\"Discover the power of Laravel \\u2013 an elegant and intuitive PHP framework designed for web artisans. With its extensive set of tools and libraries, Laravel empowers developers to create robust and scalable web applications with ease. Whether you\\u2019re a beginner or a seasoned professional, delve into the world of Laravel and unlock unparalleled efficiency and productivity in your coding journey. Join us as we explore the wonders of Laravel and its seamless integration capabilities, making web development a breeze.\",\"images\":[]}', 1694943786),
(2, 1015, 'text', 2, 'Photoshop', 'English', 'Generate a text with the Photoshop subject in English language with less than 40 word.', '{\"text\":\"\\\"Learn Photoshop to create stunning graphics, edit images, and design captivating visuals like a pro. Enhance your skills with tools like layers, filters, and blending modes, and unleash your creativity with endless possibilities in the world of digital art.\\\"\",\"images\":[]}', 1694943916),
(4, 1015, 'image', 7, 'Solar Energy', 'English', 'Generate an image with the Solar Energy subject.', '{\"text\":null,\"images\":[\"https:\\/\\/oaidalleapiprodscus.blob.core.windows.net\\/private\\/org-GBuDNNbkAYzVp9PHiPsBuZQ0\\/user-pJ94XsEfNjj0eLFo1wAdIwaZ\\/img-ZJvNYiEHIhmNhSpwLOM3ACQ7.png?st=2023-09-17T08%3A54%3A47Z&se=2023-09-17T10%3A54%3A47Z&sp=r&sv=2021-08-06&sr=b&rscd=inline&rsct=image\\/png&skoid=6aaadede-4fb3-4698-a8f6-684d7786b067&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2023-09-16T23%3A11%3A34Z&ske=2023-09-17T23%3A11%3A34Z&sks=b&skv=2021-08-06&sig=mpGi\\/cRB0RQGPdGeubJnAE4K92tkBam16iV4VLKrd%2BU%3D\"]}', 1694944488),
(5, 870, 'image', 7, 'Health And Fitness', 'English', 'Generate an image with the Health And Fitness subject.', '{\"text\":null,\"images\":[\"https:\\/\\/oaidalleapiprodscus.blob.core.windows.net\\/private\\/org-GBuDNNbkAYzVp9PHiPsBuZQ0\\/user-pJ94XsEfNjj0eLFo1wAdIwaZ\\/img-DwaSM7I2pREUcycrl5CqeBFj.png?st=2023-09-17T08%3A59%3A21Z&se=2023-09-17T10%3A59%3A21Z&sp=r&sv=2021-08-06&sr=b&rscd=inline&rsct=image\\/png&skoid=6aaadede-4fb3-4698-a8f6-684d7786b067&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2023-09-16T23%3A09%3A38Z&ske=2023-09-17T23%3A09%3A38Z&sks=b&skv=2021-08-06&sig=ajGTGay2jhn\\/%2BwFUkllhoWCTCDBhifM2Ux3K5yghpeA%3D\"]}', 1694944761),
(6, 870, 'text', 2, 'Fitness', 'English', 'Generate a text with the Fitness subject in English language with less than 40 word.', '{\"text\":\"\\\"Regular exercise is crucial for maintaining a healthy lifestyle. It improves cardiovascular health, boosts mental wellbeing, and enhances overall strength and endurance. Don\'t underestimate the power of staying fit!\\\"\",\"images\":[]}', 1694944995),
(7, 870, 'image', 7, 'Gym', 'English', 'Generate an image with the Gym subject.', '{\"text\":null,\"images\":[\"https:\\/\\/oaidalleapiprodscus.blob.core.windows.net\\/private\\/org-GBuDNNbkAYzVp9PHiPsBuZQ0\\/user-pJ94XsEfNjj0eLFo1wAdIwaZ\\/img-fXlKAqDK3czIYoRwrWMbyBTY.png?st=2023-09-17T09%3A03%3A51Z&se=2023-09-17T11%3A03%3A51Z&sp=r&sv=2021-08-06&sr=b&rscd=inline&rsct=image\\/png&skoid=6aaadede-4fb3-4698-a8f6-684d7786b067&sktid=a48cca56-e6da-484e-a814-9c849652bcb3&skt=2023-09-16T23%3A16%3A02Z&ske=2023-09-17T23%3A16%3A02Z&sks=b&skv=2021-08-06&sig=0f%2BXJgBKuXWbutQOE\\/ZThK6a27Hg2rofDll2VW2CRDM%3D\"]}', 1694945031);

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

--
-- Table structure for table `ai_content_templates`
--

CREATE TABLE `ai_content_templates` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` enum('text','image') NOT NULL,
  `enable_length` tinyint(1) NOT NULL DEFAULT 0,
  `length` int(10) UNSIGNED DEFAULT NULL,
  `image_size` enum('256','512','1024') DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_content_templates`
--

INSERT INTO `ai_content_templates` (`id`, `type`, `enable_length`, `length`, `image_size`, `enable`, `created_at`) VALUES
(1, 'text', 1, 5, NULL, 1, 1694939030),
(2, 'text', 1, 40, NULL, 1, 1694940999),
(3, 'text', 1, 300, NULL, 1, 1694941070),
(4, 'text', 1, 5, NULL, 1, 1694941199),
(5, 'text', 1, 100, NULL, 1, 1694941500),
(6, 'text', 1, 300, NULL, 1, 1694941560),
(7, 'image', 0, NULL, '512', 1, 1694942113),
(8, 'text', 1, 160, NULL, 1, 1694942972),
(9, 'text', 1, 160, NULL, 1, 1694970677),
(10, 'text', 1, 300, NULL, 1, 1694970808),
(11, 'text', 1, 150, NULL, 1, 1694971282),
(12, 'text', 0, NULL, NULL, 1, 1694994114),
(13, 'text', 0, NULL, NULL, 1, 1694994456),
(14, 'text', 1, 200, NULL, 1, 1694994762),
(15, 'text', 1, 200, NULL, 1, 1694995011),
(16, 'text', 1, 300, NULL, 1, 1694995299),
(17, 'text', 1, 100, NULL, 1, 1694995502),
(18, 'text', 1, 5, NULL, 1, 1695024064),
(19, 'text', 1, 300, NULL, 1, 1695024166),
(20, 'text', 1, 160, NULL, 1, 1695024265);

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

--
-- Table structure for table `ai_content_template_translations`
--

CREATE TABLE `ai_content_template_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `ai_content_template_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL,
  `prompt` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_content_template_translations`
--

INSERT INTO `ai_content_template_translations` (`id`, `ai_content_template_id`, `locale`, `title`, `prompt`) VALUES
(1, 1, 'en', 'Course Title', 'Generate a text with the [keyword] subject in [language] language with less than [length] word for a course title.'),
(2, 2, 'en', 'Course Short Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words.'),
(3, 3, 'en', 'Course Long Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words.'),
(4, 4, 'en', 'Blog Title', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a blog title.'),
(5, 5, 'en', 'Blog Short Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a blog short description.'),
(6, 6, 'en', 'Blog Long Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a blog description.'),
(7, 7, 'en', 'Genrate Image', 'Generate an image with the [keyword] subject.'),
(8, 8, 'en', 'Course SEO Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a course SEO description.'),
(9, 9, 'en', 'Blog SEO Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a blog SEO description.'),
(10, 10, 'en', 'Upcoming Course Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for an upcoming course.'),
(11, 11, 'en', 'Quiz Question', 'Generate a question with the [keyword] subject in the [language] language with less than [length] words.'),
(12, 12, 'en', 'Generate FAQ', 'Generate a faq with the [keyword] subject in the [keyword] language.'),
(13, 13, 'en', 'Course Requirements', 'Generate requirements for a course with [keyword] subject in [language].'),
(14, 14, 'en', 'Form Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a form description.'),
(15, 15, 'en', 'Course Advertising Description', 'Generate a text with the [keyword] subject in [language] with less than [length] words for a course advertising description.'),
(16, 16, 'en', '\"About Us\" Page Description', 'Generate a text with the [keyword] subject in [language] with less than [length] words for the \"About Us\" page description.'),
(17, 17, 'en', 'Generate Notice', 'Generate a text with the [keyword] subject in [language] with less than [length] words for notice.'),
(18, 18, 'en', 'Store Product Title', 'Generate a text with the [keyword] subject in [language] language with less than [length] word for a product title.'),
(19, 19, 'en', 'Store Product Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a store product description.'),
(20, 20, 'en', 'Store Product SEO Description', 'Generate a text with the [keyword] subject in the [language] language with less than [length] words for a store product  SEO description.');

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

--
-- Table structure for table `badges`
--

CREATE TABLE `badges` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `type` enum('register_date','course_count','course_rate','sale_count','support_rate','product_sale_count','make_topic','send_post_in_topic','instructor_blog') NOT NULL,
  `condition` varchar(128) NOT NULL,
  `score` int(11) DEFAULT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `badges`
--

INSERT INTO `badges` (`id`, `image`, `type`, `condition`, `score`, `created_at`) VALUES
(21, '/store/1/default_images/badges/registration1.svg', 'register_date', '{\"from\":\"1\",\"to\":\"30\"}', 5, 1625553769),
(22, '/store/1/default_images/badges/registration2.svg', 'register_date', '{\"from\":\"31\",\"to\":\"365\"}', 10, 1625554171),
(23, '/store/1/default_images/badges/registration3.svg', 'register_date', '{\"from\":\"365\",\"to\":\"1000\"}', 15, 1625554495),
(24, '/store/1/default_images/badges/courses1.svg', 'course_count', '{\"from\":\"1\",\"to\":\"1\"}', 10, 1625554772),
(25, '/store/1/default_images/badges/courses2.svg', 'course_count', '{\"from\":\"2\",\"to\":\"2\"}', 20, 1625554960),
(26, '/store/1/default_images/badges/courses3.svg', 'course_count', '{\"from\":\"3\",\"to\":\"6\"}', 30, 1625555421),
(27, '/store/1/default_images/badges/rating1.svg', 'course_rate', '{\"from\":\"2\",\"to\":\"3\"}', NULL, 1625556048),
(28, '/store/1/default_images/badges/rating2.svg', 'course_rate', '{\"from\":\"3\",\"to\":\"4\"}', 10, 1625556159),
(29, '/store/1/default_images/badges/rating3.svg', 'course_rate', '{\"from\":\"4\",\"to\":\"5\"}', 50, 1625556284),
(30, '/store/1/default_images/badges/sales1.svg', 'sale_count', '{\"from\":\"1\",\"to\":\"2\"}', NULL, 1625557021),
(31, '/store/1/default_images/badges/sales2.svg', 'sale_count', '{\"from\":\"3\",\"to\":\"9\"}', 20, 1625557247),
(32, '/store/1/default_images/badges/sales3.svg', 'sale_count', '{\"from\":\"10\",\"to\":\"20\"}', 50, 1625558061),
(33, '/store/1/default_images/badges/support1.svg', 'support_rate', '{\"from\":\"2\",\"to\":\"3\"}', NULL, 1625558473),
(34, '/store/1/default_images/badges/support2.svg', 'support_rate', '{\"from\":\"3\",\"to\":\"4\"}', NULL, 1625558682),
(35, '/store/1/default_images/badges/support3.svg', 'support_rate', '{\"from\":\"4\",\"to\":\"5\"}', 20, 1625558892),
(36, '/store/1/default_images/badges/store1.svg', 'product_sale_count', '{\"from\":\"5\",\"to\":\"9\"}', 5, 1656145531),
(37, '/store/1/default_images/badges/store2.svg', 'product_sale_count', '{\"from\":\"10\",\"to\":\"15\"}', 10, 1656145677),
(38, '/store/1/default_images/badges/forum1.svg', 'make_topic', '{\"from\":\"1\",\"to\":\"5\"}', 10, 1656145989),
(39, '/store/1/default_images/badges/forum2.svg', 'make_topic', '{\"from\":\"6\",\"to\":\"10\"}', 15, 1656146136),
(40, '/store/1/default_images/badges/articles1.svg', 'instructor_blog', '{\"from\":\"5\",\"to\":\"10\"}', 20, 1656146397),
(41, '/store/1/default_images/badges/forum_replies_1.svg', 'send_post_in_topic', '{\"from\":\"20\",\"to\":\"30\"}', 10, 1656146689);

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

--
-- Table structure for table `badge_translations`
--

CREATE TABLE `badge_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `badge_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `badge_translations`
--

INSERT INTO `badge_translations` (`id`, `badge_id`, `locale`, `title`, `description`) VALUES
(1, 21, 'en', 'New User', '1 Month of Membership'),
(2, 22, 'en', 'Loyal User', '1 year of Membership'),
(3, 23, 'en', 'Faithful User', 'Old Membership'),
(4, 24, 'en', 'Junior Vendor', 'Has 1 Class'),
(5, 25, 'en', 'Senior Vendor', 'Has 2 Classes'),
(6, 26, 'en', 'Expert Vendor', 'Has 3 to 6 Classes'),
(7, 27, 'en', 'Bronze Classes', 'Classes Rating from 2 to 3'),
(8, 28, 'en', 'Silver Classes', 'Classes Rating from 3 to 4'),
(9, 29, 'en', 'Golden Classes', 'Classes Rating from 4 to 5'),
(10, 30, 'en', 'Best Seller', 'Classes Sales from 1 to 2'),
(11, 31, 'en', 'Top Seller', 'Classes Sales from 3 to 9'),
(12, 32, 'en', 'King Seller', 'Classes Sales from 10 to 20'),
(13, 33, 'en', 'Good Support', 'Support Rating from 2 to 3'),
(14, 34, 'en', 'Amazing Support', 'Support Rating from 3 to 4'),
(15, 35, 'en', 'Fantastic Support', 'Support Rating from 4 to 5'),
(16, 36, 'en', 'Store Best Seller', 'Store Products Sales from 1 to 5'),
(17, 37, 'en', 'Store King Seller', 'Store Products Sales from 6 to 15'),
(18, 38, 'en', 'Forums Top User', 'Has 2 to 5 Topics'),
(19, 39, 'en', 'Forums Best User', 'Has 6 to 10 Topics'),
(20, 40, 'en', 'Loyal Writer', 'Has 5 to 10 Articles'),
(21, 41, 'en', 'Forum Loyal User', 'Has 20 to 30 Posts in Forums');

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

--
-- Table structure for table `become_instructors`
--

CREATE TABLE `become_instructors` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `role` enum('teacher','organization') NOT NULL,
  `package_id` int(10) UNSIGNED DEFAULT NULL,
  `certificate` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('pending','accept','reject','pending_pay_package') NOT NULL DEFAULT 'pending',
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `become_instructors`
--

INSERT INTO `become_instructors` (`id`, `user_id`, `role`, `package_id`, `certificate`, `description`, `status`, `created_at`) VALUES
(5, 930, 'teacher', 2, '/store/930/certificate.jpg', 'I taught design in London for two years.', 'pending', 1626242477),
(6, 859, 'organization', 4, '/store/859/certificate.jpg', 'We have 3 years of experience in advanced sewing training.', 'pending', 1646387556),
(14, 995, 'teacher', NULL, '/store/995/1696696655058.jpg', 'test', 'pending', 1749393844);

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `author_id` int(10) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `study_time` int(10) UNSIGNED DEFAULT NULL,
  `visit_count` int(10) UNSIGNED DEFAULT 0,
  `enable_comment` tinyint(1) NOT NULL DEFAULT 1,
  `status` enum('pending','publish') NOT NULL DEFAULT 'pending',
  `created_at` int(10) UNSIGNED NOT NULL,
  `updated_at` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `category_id`, `author_id`, `slug`, `image`, `study_time`, `visit_count`, `enable_comment`, `status`, `created_at`, `updated_at`) VALUES
(21, 34, 1014, 'How-To-Teach-Your-Kid-Anything-Easily', '/store/1/default_images/blogs/blog3.jpg', NULL, 23, 1, 'publish', 1625091953, 1749660581),
(22, 37, 1014, 'Better-Relationship-Between-You-and-Your-Student-s-Parent', '/store/1/default_images/blogs/blog2.jpg', NULL, 11, 1, 'publish', 1625093279, 1749660553),
(23, 36, 1, '3-Laws-to-Become-a-Straight-A-Student', '/store/1/default_images/blogs/blog1.jpg', NULL, 18, 1, 'publish', 1625094412, 1749660520),
(28, 34, 1014, 'How-To-Teach-Your-Kid-Anything-Easily-2', '/store/1/default_images/blogs/blog4.jpg', NULL, 24, 1, 'publish', 1625091953, 1749660614),
(29, 34, 1014, 'How-To-Teach-Your-Kid-Anything-Easily-3', '/store/1/default_images/blogs/blog5.jpg', NULL, 24, 1, 'publish', 1625091953, 1749660640);

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `icon2` varchar(255) DEFAULT NULL,
  `icon2_box_color` varchar(255) DEFAULT NULL,
  `overlay_image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `slug`, `cover_image`, `icon`, `icon2`, `icon2_box_color`, `overlay_image`) VALUES
(33, 'Vel-consequatur', NULL, NULL, NULL, NULL, NULL),
(34, 'Facilis-ea', NULL, NULL, NULL, NULL, NULL),
(36, 'Fugit-dignissimos-possimus', NULL, NULL, NULL, NULL, NULL),
(37, 'new', NULL, NULL, NULL, NULL, NULL),
(39, 'tips', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `blog_category_translations`
--

CREATE TABLE `blog_category_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `blog_category_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_category_translations`
--

INSERT INTO `blog_category_translations` (`id`, `blog_category_id`, `locale`, `title`, `subtitle`) VALUES
(1, 33, 'en', 'Announcements', 'Stay updated with the latest platform updates and releases'),
(2, 34, 'en', 'Articles', 'Explore expert tips, insights, and in-depth learning guides'),
(3, 36, 'en', 'Events', 'Discover upcoming webinars, workshops, and special activities'),
(4, 37, 'en', 'News', 'Catch up on recent education trends and platform news'),
(5, 39, 'en', 'Tip and Tricks', 'Boost your learning with practical tips and smart techniques');

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

--
-- Table structure for table `blog_featured_categories`
--

CREATE TABLE `blog_featured_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `thumbnail` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_featured_categories`
--

INSERT INTO `blog_featured_categories` (`id`, `category_id`, `thumbnail`) VALUES
(1, 33, '/store/1/default_images/store/featured_store_category_1.jpg'),
(2, 34, '/store/1/default_images/store/featured_store_category_2.jpg'),
(3, 36, '/store/1/default_images/store/featured_store_category_3.jpg'),
(4, 37, '/store/1/default_images/store/featured_store_category_4.jpg'),
(5, 39, '/store/1/default_images/store/featured_store_category_5.jpg');

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

--
-- Table structure for table `blog_translations`
--

CREATE TABLE `blog_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text DEFAULT NULL,
  `description` text NOT NULL,
  `content` longtext NOT NULL,
  `meta_description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_translations`
--

INSERT INTO `blog_translations` (`id`, `blog_id`, `locale`, `title`, `subtitle`, `description`, `content`, `meta_description`) VALUES
(2, 21, 'en', 'Freelancing vs. Full-Time: Which Career Path Suits You Best?', NULL, '<p>The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault. I started tutoring math out of financial desperation. I’d just been fired from my job as a waiter, most of the proofreading in jobs in New York had been outsourced to India, and for the third time in my life, I was facing dire poverty.</p>', '<p>A strong academic record can open doors for you down the road. More importantly, through the process of becoming a straight-A student, you’ll learn values like hard work, discipline and determination.</p><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #1: Always have a plan.</h3><div><div>(a) As the semester progresses, keep track of key dates: tests and exams, project submission deadlines, term breaks, etc.</div><div><br></div><div>Enter these dates into a physical or digital calendar.</div><div><br></div><div><div>If you choose to use a digital calendar, I recommend Google Calendar.</div><div><br></div><div>(b) Schedule a fixed time every week where you review your upcoming events over the next two months. Mark down when you’ll start preparing for that Math exam, working on that History project, or writing that English paper.</div><div><br></div><div>(d) Next, note your commitments for the coming week, e.g. extracurricular activities, family gatherings, extra classes. On your calendar, highlight the blocks of time you’ll have for schoolwork.</div><div><br></div><div>This planning process might sound time-consuming, but it’ll typically take just 15 minutes every week.</div><div><br></div><div>This is a wise investment of time as a student, because the rest of your week will become far more productive.</div><div><br></div><div>This way, you’ll be studying smart, not just hard!</div><div><br></div><div><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #2: Be organized.</h3></div></div></div><div><div>Ever had trouble finding your notes or assignments when you needed them? You probably ended up wasting precious time looking for them, before you finally asked to borrow them from your friend.</div><div><br></div><div>Many students tell me that they keep all their notes and assignments in one big pile, and only sort them out before their exams!</div><div><br></div><div>Being organized – it’s easier said than done, I know.</div></div>', 'The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault.'),
(3, 22, 'en', 'Top Tools Every Successful Freelancer Uses to Stay Productive', NULL, '<p>The tutor-parent relationship is an important relationship and unfortunately greatly overlooked. Why is it important? Well, a good relationship between you and the student’s parent or guardian serves to help students perform better personally and academically. Fostering a relationship with them as a tutor can be challenging due to a number of factors, however, there are a number of ways to build this relationship and optimize students’ learning support system over time.</p>', '<p>A strong academic record can open doors for you down the road. More importantly, through the process of becoming a straight-A student, you’ll learn values like hard work, discipline and determination.</p><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #1: Always have a plan.</h3><div><div>(a) As the semester progresses, keep track of key dates: tests and exams, project submission deadlines, term breaks, etc.</div><div><br></div><div>Enter these dates into a physical or digital calendar.</div><div><br></div><div><div>If you choose to use a digital calendar, I recommend Google Calendar.</div><div><br></div><div>(b) Schedule a fixed time every week where you review your upcoming events over the next two months. Mark down when you’ll start preparing for that Math exam, working on that History project, or writing that English paper.</div><div><br></div><div>(d) Next, note your commitments for the coming week, e.g. extracurricular activities, family gatherings, extra classes. On your calendar, highlight the blocks of time you’ll have for schoolwork.</div><div><br></div><div>This planning process might sound time-consuming, but it’ll typically take just 15 minutes every week.</div><div><br></div><div>This is a wise investment of time as a student, because the rest of your week will become far more productive.</div><div><br></div><div>This way, you’ll be studying smart, not just hard!</div><div><br></div><div><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #2: Be organized.</h3></div></div></div><div><div>Ever had trouble finding your notes or assignments when you needed them? You probably ended up wasting precious time looking for them, before you finally asked to borrow them from your friend.</div><div><br></div><div>Many students tell me that they keep all their notes and assignments in one big pile, and only sort them out before their exams!</div><div><br></div><div>Being organized – it’s easier said than done, I know.</div></div>', 'The tutor-parent relationship is an important relationship and unfortunately greatly overlooked.'),
(4, 23, 'en', 'How to Start Freelancing with No Experience or Clients Today', NULL, '<p>In this article, I’ll explain the two rules I followed to become a straight-A student. If you take my advice, you’ll get better grades and lead a more balanced life too.</p>', '<p>A strong academic record can open doors for you down the road. More importantly, through the process of becoming a straight-A student, you’ll learn values like hard work, discipline and determination.</p><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #1: Always have a plan.</h3><div><div>(a) As the semester progresses, keep track of key dates: tests and exams, project submission deadlines, term breaks, etc.</div><div><br></div><div>Enter these dates into a physical or digital calendar.</div><div><br></div><div><div>If you choose to use a digital calendar, I recommend Google Calendar.</div><div><br></div><div>(b) Schedule a fixed time every week where you review your upcoming events over the next two months. Mark down when you’ll start preparing for that Math exam, working on that History project, or writing that English paper.</div><div><br></div><div>(d) Next, note your commitments for the coming week, e.g. extracurricular activities, family gatherings, extra classes. On your calendar, highlight the blocks of time you’ll have for schoolwork.</div><div><br></div><div>This planning process might sound time-consuming, but it’ll typically take just 15 minutes every week.</div><div><br></div><div>This is a wise investment of time as a student, because the rest of your week will become far more productive.</div><div><br></div><div>This way, you’ll be studying smart, not just hard!</div><div><br></div><div><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #2: Be organized.</h3></div></div></div><div><div>Ever had trouble finding your notes or assignments when you needed them? You probably ended up wasting precious time looking for them, before you finally asked to borrow them from your friend.</div><div><br></div><div>Many students tell me that they keep all their notes and assignments in one big pile, and only sort them out before their exams!</div><div><br></div><div>Being organized – it’s easier said than done, I know.</div></div>', 'In this article, I’ll explain the two rules I followed to become a straight-A student.'),
(5, 21, 'ar', 'كيف تعلم طفلك أي شيء بسهولة', NULL, '<p style=\"text-align: right; \">الخوف هو السبب الرئيسي الذي يجعل الأطفال يكافحون مع المدرسة. وفي معظم الحالات ، يكون ذلك خطأ الوالدين. بدأت في تدريس الرياضيات بسبب اليأس المالي.</p>', '<p style=\"text-align: right; \">بدأت في تدريس الرياضيات بسبب اليأس المالي. لقد طُردت للتو من وظيفتي كنادل ، ومعظم عمليات التدقيق اللغوي في الوظائف في نيويورك تم الاستعانة بمصادر خارجية للهند ، وللمرة الثالثة في حياتي ، كنت أواجه فقرًا مدقعًا.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">كان المبلغ الذي نسيته مذهلاً في البداية ، وقد تفوقت في الرياضيات طوال حياتي الأكاديمية. إذا كنت لا تستخدمها ، فأنت تخسرها حقًا ، لذلك ليس من المستغرب أن يبكي معظم الآباء عمي في الرياضيات في الصف الرابع تقريبًا. إنهم لا يتذكرون ولا يريدون أن يتذكروا ، مما يديم هذا الموقف لدى أطفالهم.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">تخيل أنك تفعل أي شيء ، حتى لو كنت بارعًا فيه ، بما يعادل عملاقًا يلوح في الأفق خلفك ويفحص كل تحركاتك. وهذا هو ما يفعله الآباء لأطفالهم. إنهم يحومون وينقضون على كل خطأ.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">1) تعاطف مع أطفالك</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">في جلستي الأولى مع تلميذي الأول ، تراجعت والدته بعصبية خلفنا ، ثم اتصلت بي لمدة خمس دقائق. سألت إذا لاحظت أن ابنها قد أجاب على السؤال الأخير بشكل غير صحيح ، ورأيت على الفور جوهر المشكلة.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">عليك أن ترتاح وتسترخي حتى يكون طفلك مرتاحًا وتنتظر حتى النهاية قبل أن تبدأ في تصحيح أي شيء. هذه هي الطريقة التي يتعلم بها الأطفال التحقق من عملهم ، وأن ارتكاب الأخطاء ليس مشكلة كبيرة.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">الأخطاء لا مفر منها ، ولكن كيفية التعامل معها ليست كذلك. إذا كنت تريد أن يشعر ابنك بالرعب إلى الأبد من الرياضيات ، إذن ، بكل الوسائل ، استمر في الازدحام ومقاطعته على الدوام. من المحتمل أن تجعلهم حذرين من محاولة تعلم أي شيء على الإطلاق.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">2) إعطاء نفسك وأطلق عليه الرصاص</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">لحسن الحظ ، فهمت هذه الأم ومعظم الآباء الآخرين ما كنت أفعله ، وأدركوا تواطؤهم في كفاح أطفالهم. بعد تلك الجلسة الأولى ، تركتنا أمي وشأننا ، وبدأ طفلها في التحسن على الفور.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">تم تشجيع والديه لدرجة أنهم سألوا عما إذا كان بإمكاني المساعدة في مواضيع أخرى. كان التاريخ والعلوم واللغة الإنجليزية داخل غرفة قيادتي ، لكن الطفل ذهب إلى مدرسة كاثوليكية وكان عليه أن يتعلم اللاتينية.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">استعرت نسخة من كتابه اللاتيني وأصيبت بالإحباط تمامًا. اللغة اللاتينية محيرة ، خاصة في البداية. هذا العدد الكبير من الإقتران، ومسألة السياق. الطريقة التي تتحدث بها إلى النبلاء والأقران والعبيد تشبه عمليًا تعلم ثلاث لغات مختلفة.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">ما زلت مفلسة ، وهذا يعني المزيد من المال. وهل كان علي بالفعل معرفة اللاتينية؟ كل ما كان علي فعله هو البقاء قبل الطفل ببضعة أيام.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">3) كن صادقا</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">حالتنا الافتراضية هي إنكار جهلنا ، خاصة أمام الأطفال. نحن دفاعيون ورفضون ، ويمكن لمعظم الأطفال أن يقولوا إنك ضائع مثلهم.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">كان الحل هو الاعتراف بذلك منذ البداية. سألني الطفل عن وجهة نظر تعلم اللاتينية وأخبرته أنني لا أعرف. من المفترض أنه ساعد مع لغات أخرى ، لكن ربما يمكنه استخدامه يومًا ما لإثارة إعجاب الأشخاص الطنانين في حفلات الكوكتيل. سألني لماذا تكسر بعض الأفعال أنماط الاقتران ، وقلت له إنها طريقة القدماء في تعذيبنا.</p><p style=\"text-align: right; \">عندما كان طفلاً صغيرًا ، كان يتعلم اللغة أسرع مني ، لكنه كان يواجه صعوبة أكبر في بعض التفاصيل الدقيقة. كانت هناك أوقات حيرتني فيها وأتحدث بصوت عالٍ أمامه.</p><p style=\"text-align: right; \">أنا مدرس رياضيات. ما الذي جعلني أعتقد أنني مستعد لتدريس اللاتينية ، ناهيك عن تعلمها؟</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">قال لي الطفل إنني أبدو جيدًا في كل شيء آخر ، لذا من المحتمل أن أفهم ذلك ، لكن كان هناك القليل من القلق في صوته. كلما فعلت الأسوأ ، زاد احتمال فشله ، وأراد إخراج اللاتينية من حياته أكثر مما فعلت.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">لقد قربنا كراهيتنا المتبادل للغة اللاتينية من بعضنا البعض. لأول مرة ، أدرك كلانا أننا في هذا معًا.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">4) التعامل مع أولياء الأمور والمعلمين هو جزء من التعليم</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">مع تقدمه في السن ، بدأ يسألني عن والديه ، اللذين كانا من المحافظين في قناة فوكس نيوز. قال لي انه يمكن ان نرى انهم منحازون، ولكن لم أفهم لماذا، أو أعرف ما يفكر.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">أخبرته أن يفكر بنفسه ويعترف عندما لا يعرف شيئًا ، وأنه لا يجب أن يخشى تغيير رأيه في ضوء أدلة جديدة صحيحة.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">واشتكى أساتذته، واحد منهم لم يكن سعيدا كنت قد علمته الطرق المختلفة لعلم الجبر. في نهاية المطاف، وعلم أنه كيفية القيام بذلك بطريقة المعلم، ولكن عنيدا حاجة سبيلا آخر للوصول إلى هناك. كنا غاضبين بعض الشيء ، لكنني أخبرته أن تعلم التعامل مع المعلمين هو جزء من التعليم.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">احتفظت بالضغينة لنفسي ، لكنني أردت أيضًا خنق معلمه. وكان هذا الطفل قد ذهب من متوسط ​​D إلى B +، وكان هذا المعلم لا يزال يطارد له. ولا عجب في ذلك كثير من الناس رديء في الرياضيات - الآباء والامهات والمعلمين ضدهم وحتى لم يدرك ذلك.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">5) احتضان موقف التعلم</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">إذا لم تكن على استعداد للتعلم ، فسيكون من الصعب تدريسه ، والخطوة الأولى هي قبول مدى ضآلة معرفتنا. من النفاق أن تنقض على ابنك عندما لا تتمكن من أداء واجبه المنزلي أيضًا ، ويلاحظ الأطفال ذلك ويشعرون بحق أنك غير عادل.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">التعلم الإلكتروني) سيحسن إدراكك بشكل عام.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">القراءة والرياضيات مهارات أساسية ، وتعلم الرياضيات أمر متواضع. في حين أن هناك القليل من الأدلة التي تدعم أن الرياضيات تحسن التفكير بشكل عام ، فأنت بحاجة إليها لفهم العلوم ، وعندما تشعر بالحيرة تجاه الكثير من الواجبات المدرسية لطفلك في المدرسة الابتدائية ، فإن القليل على الأقل من عدم اليقين يخترق آرائك. أنت تدرك أنك لا تعرف الكثير كما كنت تعتقد ، وبالنسبة لمعظم الناس ، يمكن أن يمثل هذا بداية جديدة. مع انحسار الصلابة ، تعاود اللدونة الظهور ، وعادات التعلم مدى الحياة هي أثمن هدية يمكن أن تقدمها لنفسك ولطفلك.إذا اخترت أن يكون الأطفال، يجب أن يكون لديك الاولوية رقم واحد، وسوف يفاجأ في مقدار التعلم (أو ص</p>', 'الخوف هو السبب الرئيسي الذي يجعل الأطفال يكافحون مع المدرسة. وفي معظم الحالات ، يكون ذلك خطأ الوالدين.'),
(6, 21, 'es', 'Cómo enseñar a tu hija cualquier cosa fácilmente', NULL, '<p>La razón principal por la que los niños luchan con la escuela es el miedo. Y en la mayoría de los casos, es culpa de sus padres. Comencé a dar clases particulares de matemáticas por desesperación financiera. Me acababan de despedir de mi trabajo como camarero, la mayor parte de la corrección de pruebas en los trabajos en Nueva York se habían subcontratado a la India y, por tercera vez en mi vida, me enfrentaba a una pobreza extrema.</p>', '<p>Comencé a dar clases particulares de matemáticas por desesperación financiera. Me acababan de despedir de mi trabajo como camarero, la mayor parte de la corrección de pruebas en los trabajos en Nueva York se habían subcontratado a la India y, por tercera vez en mi vida, me enfrentaba a una pobreza extrema.</p><p><br></p><p>La cantidad que había olvidado fue sorprendente al principio, y había sobresalido en matemáticas durante toda mi vida académica. Si no lo usas, realmente lo pierdes, así que no es de extrañar que la mayoría de los padres lloren a tío en matemáticas de cuarto grado. No recuerdan y no quieren recordar, perpetuando esta actitud en sus hijos.</p><p><br></p><p>Imagínese haciendo cualquier cosa, incluso algo en lo que se le da bien, con el equivalente a un gigante acechando detrás de usted y escudriñando cada uno de sus movimientos. Esto es lo que les hacen los padres a sus hijos. Se ciernen y se abalanzan sobre cada error.</p><p><br></p><p>1) Tenga empatía por sus hijos</p><p><br></p><p>En mi primera sesión con mi primer alumno, su madre se escondió nerviosamente detrás de nosotros, luego me llamó unos cinco minutos después. Me preguntó si noté que su hijo había respondido la última pregunta incorrectamente, e inmediatamente vi la esencia del problema.</p><p><br></p><p>Tienes que descansar y relajarte para que tu hijo se sienta cómodo y esperar hasta el final antes de empezar a corregir algo. Así es como los niños aprenden a controlar su trabajo y que cometer errores no es gran cosa.</p><p><br></p><p>Los errores son inevitables, pero la forma en que los manejamos no lo es. Si quiere que su hijo esté eternamente aterrorizado por las matemáticas, entonces, por supuesto, continúe apiñándolos e interrumpiéndolos perpetuamente. Lo más probable es que los haga desconfiar de intentar aprender algo.</p><p><br></p><p>2) Date una oportunidad</p><p><br></p><p>Afortunadamente, esta madre y la mayoría de los otros padres entendieron lo que estaba haciendo y reconocieron su complicidad en las luchas de sus hijos. Después de esa primera sesión, mamá nos dejó solos y su hijo comenzó a mejorar de inmediato.</p><p><br></p><p>Sus padres estaban tan animados que me preguntaron si podía ayudar con otros temas. La historia, la ciencia y el inglés estaban a mi alcance, pero el niño fue a una escuela católica y tuvo que aprender latín.</p><p><br></p><p>Pedí prestada una copia de su libro en latín y me desmoralicé por completo. El latín es desconcertante, especialmente al principio. Tantas conjugaciones y contexto son importantes. La forma de hablar con nobles, compañeros y esclavos es prácticamente como aprender tres idiomas diferentes.</p><p><br></p><p>Aún así, estaba arruinado y esto significaría más dinero. ¿Y realmente tenía que saber latín? Todo lo que tenía que hacer era quedarme unos días por delante del chico.</p><p><br></p><p>3) Sea honesto</p><p><br></p><p>Nuestro estado predeterminado es negar nuestra ignorancia, especialmente frente a los niños. Estamos a la defensiva y desdeñosos, y la mayoría de los niños pueden decir que estás tan perdido como ellos.</p><p><br></p><p>Mi solución fue admitir esto desde el principio. El niño me preguntó qué sentido tenía aprender latín y le dije que no lo sabía. Supuestamente le ayudó con otros idiomas, pero tal vez algún día podría usarlo para impresionar a personas pretenciosas en los cócteles. Me preguntó por qué algunos verbos rompían los patrones de conjugación y le dije que era la forma de los antiguos de torturarnos.</p><p><br></p><p>Cuando era niño, aprendió el idioma más rápido que yo, pero tuvo más dificultades con algunas de las sutilezas. Hubo momentos en que estaba desconcertado y me hablaba en voz alta frente a él.</p><p><br></p><p>Soy un tutor de matemáticas. ¿Qué diablos me hizo pensar que estaba equipado para enseñar latín, y mucho menos aprenderlo?</p><p><br></p><p>El chico me dijo que parecía ser bastante bueno en todo lo demás, así que probablemente lo entendería, pero había un matiz de preocupación en su voz. Cuanto peor lo hacía, más probabilidades había de que fracasara, y quería que el latín fuera de su vida incluso más que yo.</p><p><br></p><p>Nuestro odio mutuo por el latín nos acercó más. Por primera vez, ambos comprendimos que estábamos juntos en esto.</p><p><br></p><p>4) Tratar con padres y maestros es parte de la educación</p><p><br></p><p>A medida que crecía, empezó a preguntarme sobre sus padres, que eran conservadores de Fox News. Me dijo que podía ver que eran parciales, pero que no entendía por qué ni sabía qué pensar.</p><p><br></p><p>Le dije que pensara por sí mismo y admitiera cuando no sabía algo, y que no debería tener miedo de cambiar de opinión a la luz de nuevas pruebas válidas.</p><p><br></p><p>Se quejaba de sus profesores, uno de los cuales no estaba contento de que le hubiera enseñado diferentes enfoques del álgebra. Con el tiempo, aprendió a hacerlo a la manera del maestro, pero necesitaba otra vía para llegar allí. Ambos estábamos un poco enojados, pero le dije que aprender a tratar con los maestros es parte de la educación.</p><p><br></p><p>Me guardé mi rencor, pero también quería estrangular a su maestro. Este niño había pasado de un promedio D a un B +, y esta maestra todavía lo perseguía. No es de extrañar que tanta gente sea pésima en matemáticas: sus padres y maestros estaban en contra de ellos y ni siquiera se dieron cuenta.</p><p><br></p><p>5) Adopte una actitud de aprendizaje</p><p><br></p><p>Si no está dispuesto a aprender, será difícil enseñar y el primer paso es aceptar lo poco que sabemos. Es hipócrita atacar a tu hijo cuando tú tampoco puedes hacer su tarea, y los niños se dan cuenta de esto y sienten que estás siendo injusto.</p><p><br></p><p>Si elige tener hijos, deberían ser su prioridad número uno y se sorprenderá de cuánto aprendizaje (o relearning) mejorará su cognición en general.</p><p><br></p><p>La lectura y las matemáticas son habilidades fundamentales, y aprender matemáticas es una lección de humildad. Si bien hay poca evidencia que respalde que las matemáticas mejoran el razonamiento en general, las necesita para comprender las ciencias, y cuando gran parte de las tareas de la escuela primaria de su hijo le desconcierta, al menos un poco de incertidumbre penetra en sus puntos de vista. Te das cuenta de que no sabes tanto como pensabas y, para la mayoría, esto puede marcar un nuevo comienzo. A medida que cede la rigidez, resurge la plasticidad y el hábito del aprendizaje permanente es el regalo más valioso que puede hacerse a sí mismo y a su hijo.</p>', 'La razón principal por la que los niños luchan con la escuela es el miedo. Y en la mayoría de los casos, es culpa de sus padres.'),
(7, 23, 'es', '3 leyes para convertirse en una estudiante heterosexual', NULL, '<p>En este artículo, explicaré las dos reglas que seguí para convertirme en un estudiante sobresaliente. Si sigue mi consejo, obtendrá mejores calificaciones y también llevará una vida más equilibrada.</p>', '<p>Un historial académico sólido puede abrirle puertas en el futuro. Más importante aún, a través del proceso de convertirse en un estudiante sobresaliente, aprenderá valores como el trabajo duro, la disciplina y la determinación.</p><p>Regla 1: siempre tenga un plan.</p><p>(a) A medida que avanza el semestre, realice un seguimiento de las fechas clave: pruebas y exámenes, fechas límite para la presentación de proyectos, interrupciones del período, etc.</p><p>Ingrese estas fechas en un calendario físico o digital.</p><p>Si elige utilizar un calendario digital, le recomiendo Google Calendar.</p><p><br></p><p>(b) Programe un horario fijo cada semana en el que revise sus próximos eventos durante los próximos dos meses. Marque cuándo comenzará a prepararse para ese examen de matemáticas, a trabajar en ese proyecto de historia o a escribir ese ensayo en inglés.</p><p>(d) A continuación, anote sus compromisos para la próxima semana, p. ej. actividades extracurriculares, reuniones familiares, clases extra. En su calendario, resalte los bloques de tiempo que tendrá para el trabajo escolar.</p><p>Este proceso de planificación puede parecer lento, pero por lo general solo tomará 15 minutos cada semana.</p><p>Esta es una sabia inversión de tiempo como estudiante, porque el resto de la semana será mucho más productiva.</p><p>De esta manera, estudiarás inteligentemente, ¡no solo duro!</p><p><br></p><p>Regla # 2: Sea organizado.</p><p>Alguna vez ha tenido problemas para encontrar sus notas o tareas cuando las necesitaba? Probablemente terminó perdiendo un tiempo precioso buscándolos, antes de que finalmente se los pidiera prestados a su amigo.</p><p>Muchos estudiantes me dicen que guardan todas sus notas y tareas en una gran pila, ¡y solo las clasifican antes de sus exámenes!</p><p>Ser organizado, es más fácil decirlo que hacerlo, lo sé.</p>', 'En este artículo, explicaré las dos reglas que seguí para convertirme en un estudiante sobresaliente.'),
(8, 23, 'ar', 'علاقة أفضل بينك وبين ولي أمر الطالب', NULL, '<div style=\"text-align: right;\">في هذه المقالة ، سأشرح القاعدتين اللتين اتبعتهما لأصبح طالبًا عاديًا. إذا أخذت بنصيحتي ، ستحصل على درجات أفضل وتعيش حياة أكثر توازناً أيضًا.</div>', '<div style=\"text-align: right; \">يمكن للسجل الأكاديمي القوي أن يفتح لك الأبواب في المستقبل. والأهم من ذلك ، من خلال عملية أن تصبح طالبًا عاديًا ، ستتعلم قيمًا مثل العمل الجاد والانضباط والتصميم.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">القاعدة 1: امتلك خطة دائمًا.</div><div style=\"text-align: right; \">(أ) مع تقدم الفصل الدراسي ، تتبع التواريخ الرئيسية: الاختبارات والامتحانات والمواعيد النهائية لتقديم المشروع وفواصل الفصل الدراسي وما إلى ذلك.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">أدخل هذه التواريخ في تقويم مادي أو رقمي.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">إذا اخترت استخدام تقويم رقمي ، فإنني أوصي بتقويم Google.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">(ب) حدد موعدًا محددًا كل أسبوع حيث تقوم بمراجعة الأحداث القادمة على مدار الشهرين المقبلين. ضع علامة على الوقت الذي ستبدأ فيه التحضير لامتحان الرياضيات هذا ، أو العمل في مشروع التاريخ ، أو كتابة هذه الورقة باللغة الإنجليزية.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">(د) بعد ذلك ، دوِّن التزاماتك للأسبوع القادم ، على سبيل المثال الأنشطة اللامنهجية والتجمعات العائلية والفصول الإضافية. في التقويم الخاص بك ، حدد فترات الوقت التي ستتاح لك للعمل المدرسي.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">قد تبدو عملية التخطيط هذه مضيعة للوقت ، ولكنها عادة ما تستغرق 15 دقيقة فقط كل أسبوع.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">هذا استثمار حكيم للوقت كطالب ، لأن بقية الأسبوع ستصبح أكثر إنتاجية بكثير.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">بهذه الطريقة ، ستدرس بذكاء ، وليس فقط بجد!</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">القاعدة رقم 2: كن منظمًا.</div><div style=\"text-align: right; \">هل واجهت مشكلة في العثور على ملاحظاتك أو مهامك عندما احتجت إليها؟ ربما انتهى بك الأمر إلى إضاعة الوقت الثمين في البحث عنهم ، قبل أن تطلب أخيرًا استعارتهم من صديقك.</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">يخبرني العديد من الطلاب أنهم يحتفظون بجميع ملاحظاتهم وواجباتهم في كومة كبيرة واحدة ، ولا يقوموا بفرزها إلا قبل امتحاناتهم!</div><div style=\"text-align: right; \"><br></div><div style=\"text-align: right; \">كونك منظمًا - القول أسهل من الفعل ، أعلم.</div>', 'في هذه المقالة ، سأشرح القاعدتين اللتين اتبعتهما لأصبح طالبًا عاديًا.'),
(9, 22, 'ar', 'علاقة أفضل بينك وبين ولي أمر الطالب', NULL, '<p style=\"text-align: right; \">العلاقة بين المعلم والوالدين هي علاقة مهمة ويتم التغاضي عنها للأسف إلى حد كبير. لماذا هو مهم؟ حسنًا ، تساعد العلاقة الجيدة بينك وبين ولي أمر الطالب أو الوصي عليه في مساعدة الطلاب على أداء أفضل على المستوى الشخصي والأكاديمي. </p>', '<p style=\"text-align: right; \">الرحمة والإيجابية هي كل شيء</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">قد يكون التعامل معك أمرًا مرهقًا للوالدين أو الأوصياء. قد يكون هناك خوف من أن أداء طفلهم ليس جيدًا كما ينبغي ، أو ضيق الوقت للتواصل ، أو حتى حواجز اللغة. بصفتك مدرسًا ، فإن التعاطف وتقديم المعلومات بنبرة مهذبة يؤدي إلى العجائب في مثل هذه المواقف. من الأفضل الابتسام والتواصل البصري والترحيب وتقديم أي نصيحة إذا لزم الأمر. إحدى الحيل الجيدة للمساعدة في تهدئة الآباء أو الأوصياء عند التحدث إليهم هي الاعتراف أولاً بشيء إيجابي عن طفلهم لاحظته مهما كان صغيراً. على سبيل المثال ، ربما لاحظت أنهم أكثر انخراطًا في دروسهم وطرحوا المزيد من الأسئلة.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">كن استباقيًا وتواصل كثيرًا</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">قد يتحدث بعض المعلمين مع الوالدين أو الأوصياء فقط عندما تكون هناك مشكلة ، مما يخلق بيئة سلبية لكليهما. هذا هو السبب في أنه من الضروري بذل الجهد للتحدث معهم كثيرًا سواء كان ذلك وجهًا لوجه أو مكالمة هاتفية أو حتى رسالة بريد إلكتروني. من الأفضل إبقائهم على اطلاع دائم بما يتعلمه أطفالهم. غالبًا ما يمنعهم التواصل من الشعور باليقظة القصوى عند التواصل معهم ويمكنه أيضًا تعزيز صداقة جميلة. بالطبع من المهم معرفة أن الآباء والأوصياء مشغولون! لذا تأكد عند التواصل معهم أنك تخطط مسبقًا للعثور على وقت يناسبهم بشكل أفضل.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">اجعل الوالد أو الوصي يشعر بالتقدير واطلب مشورتهما</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">من الطرق الرائعة لبناء علاقة مع الوالدين أو الأوصياء إشراكهم في تعليم أطفالهم. هذا لا يعني مجرد مساعدتهم في أداء واجباتهم المدرسية ، ولكن قد يعني مطالبتهم بالمشاركة في الأنشطة أو الأحداث المدرسية. يُعد سؤالهم عما إذا كانوا يرغبون في المساعدة في تنظيم حدث طريقة رائعة للتعرف عليهم ومنحهم فرصة لمقابلة أولياء الأمور أو الأوصياء الآخرين. يمكن أن يكون أيضًا شيئًا بسيطًا مثل إنشاء خطة درس تطلب مدخلات منهم. بالطبع كل هذا يعتمد على جدولهم الزمني وما إذا كان لديهم الوقت للمشاركة. في النهاية ، كلما حاولت إشراكهم في الأنشطة ، كان ذلك أفضل.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">طريقة أخرى رائعة لجعلهم يشعرون بالتقدير هي طلب نصيحتهم. إذا كان الطالب يعرض سلوكيات سلبية أثناء الدرس ، فمن الحكمة طلب مشورة الوالد أو الوصي. من خلال طلب نصيحتهم ، يمكن أن يحدث شيئان. أولاً ، قد لا يعرفون أن هناك سلوكًا سلبيًا للبدء به لأن الطالب قد لا يعرضه في المنزل. ثانيًا ، أنت تبني علاقة أفضل مع الوالد أو الوصي من خلال الحصول على مدخلاتهم في هذا الموقف ، مما سيبني الثقة. لا يجب أن تدور الأسئلة حول تعليم الطالب فقط عند التحدث إليهم ، بل يمكنك أيضًا طرح أسئلة حول اهتمامات الطالب والخطط التي لديهم خلال العطلات. من المهم دائمًا أن تتصرف بشكل احترافي عند التعامل مع أحد الوالدين أو الوصي ، ولكن لا يجب أن تكون المحادثة فقط حول التعليم.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">تجنب أخذها بشكل شخصي والافتراضات</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">الآباء والأوصياء بشر ولديهم ضغوط خاصة بهم للتعامل معها سواء كان ذلك في العمل أو في حياتهم المنزلية. من الأفضل لك أن تحافظ على هدوئك دائمًا ولا تأخذ أي شيء يقولونه على محمل الجد. يجب عليك دائمًا الرد بأسئلة من شأنها أن تساعد في نزع فتيل الموقف. على سبيل المثال ، قد يقول أحد الوالدين أو الوصي \"أنت تقول هذا لأنك خرجت لإحضار طفلي\" وأفضل طريقة للرد على سؤال مثل هذا هي \"أنا آسف لأنك تشعر بهذه الطريقة ، يرجى إعلامي لماذا تعتقد هذا؟\"</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">كما يجب ألا تضع افتراضات حول الحياة المنزلية للطالب. ما لم يتم ذكر ذلك ، يمكن للافتراض أن يسبب العديد من المشاكل ويمكن أن يكون غير حساس لوضع الأسرة. يجب ألا تفترض أن الطالب يعيش مع كلا الوالدين أو أي من الوالدين في هذا الشأن. الآن ، في عالمنا المتنوع عالميًا ، لا يجب أن تفترض أن اللغة الأولى للوالد أو الوصي هي اللغة الإنجليزية ويجب دائمًا تأكيد ما إذا كان بإمكانهم التحدث باللغة الإنجليزية في المقام الأول. سيكون لكل طالب وضع مختلف عن الوضع الذي يليه. تؤدي الافتراضات إلى سوء الفهم الذي يمكن أن يخلق ظروفًا أكثر صعوبة للتعلم.</p><p style=\"text-align: right; \"><br></p><p style=\"text-align: right; \">قد يكون بناء علاقة مع أحد الوالدين أو الوصي أمرًا صعبًا في بعض الأحيان. يمكن أن يساعدك وضع هذه الأفكار في الاعتبار على التواصل معها بشكل أفضل. من الجيد أن تتذكر ، في نهاية اليوم ، أنه كلما كان لديك اتصال أفضل معهم ، كان من الأفضل أن يساعدوا في تعليم الطالب ، مما يسمح لهم في النهاية بتحقيق النجاح الأكاديمي وتعزيز حب التعلم.</p>', 'العلاقة بين المعلم والوالدين هي علاقة مهمة ويتم التغاضي عنها للأسف إلى حد كبير.'),
(10, 22, 'es', 'Mejor relación entre usted y los padres de su estudiante', NULL, '<p>La relación padre / tutor es una relación importante y, lamentablemente, se pasa por alto en gran medida. ¿Por qué es importante? Bueno, una buena relación entre usted y el padre o tutor del estudiante sirve para ayudar a los estudiantes a desempeñarse mejor a nivel personal y académico. Fomentar una relación con ellos como tutor puede ser un desafío debido a una serie de factores; sin embargo, hay varias formas de construir esta relación y optimizar el sistema de apoyo al aprendizaje de los estudiantes a lo largo del tiempo.</p>', '<p>La compasión y la positividad lo son todo</p><p>Puede ser estresante para los padres o tutores interactuar con usted. Puede haber temor de que a su hijo no le esté yendo tan bien como debería, falta de tiempo para conectarse o incluso barreras del idioma. Como tutor, ser compasivo y brindar información en un tono educado hace maravillas en situaciones como esta. Es mejor sonreír, hacer contacto visual, ser acogedor y ofrecer cualquier consejo si es necesario. Un buen truco para ayudar a los padres o tutores a hablar con ellos es reconocer primero algo positivo acerca de su hijo que haya notado, sin importar lo pequeño que sea. Por ejemplo, es posible que haya notado que están más involucrados en sus lecciones y hacen más preguntas.</p><p><br></p><p>Sea proactivo y comuníquese con frecuencia</p><p><br></p><p>Es posible que algunos tutores solo hablen con los padres o tutores cuando hay un problema, lo que crea un entorno negativo para ambos. Por eso es clave hacer el esfuerzo de hablar con ellos a menudo, ya sea cara a cara, por teléfono o incluso por correo electrónico. Es mejor mantenerlos actualizados sobre el aprendizaje de sus hijos. Comunicarse a menudo evita que se sientan en alerta máxima cuando se acerca e incluso puede fomentar una hermosa amistad. ¡Por supuesto que es importante saber que los padres y tutores están ocupados! Por eso, cuando te comuniques con ellos, asegúrate de planificar con anticipación para encontrar el momento que mejor funcione para ellos.</p><p><br></p><p>Haga que el padre o tutor se sienta valorado y solicite su consejo</p><p><br></p><p>Una excelente manera de entablar una relación con los padres o tutores es involucrarlos en la educación de sus hijos. Esto no significa solo que los ayuden con la tarea, sino que también podría significar pedirles que participen en actividades o eventos escolares. Preguntarles si les gustaría ayudar a organizar un evento es una excelente manera de conocerlos y darles la oportunidad de conocer a otros padres o tutores. También podría ser algo tan simple como crear un plan de lección que solicite su opinión. Por supuesto, todo esto depende de su horario y si tienen tiempo para participar. Al final, cuanto más intente involucrarlos en las actividades, mejor.</p><p><br></p><p>Otra excelente manera de hacerlos sentir valorados es pedirles su consejo. Si su estudiante muestra comportamientos negativos durante una lección, es aconsejable buscar el consejo del padre o tutor. Al pedirles su consejo, pueden ocurrir dos cosas. Uno, para empezar, es posible que no sepan que existe un comportamiento negativo, ya que es posible que el estudiante no lo esté mostrando en casa. Dos, está construyendo una mejor relación con el padre o tutor al obtener su opinión en esta situación, lo que generará confianza. Las preguntas no tienen que ser solo sobre la educación del estudiante al hablar con él, también puede hacer preguntas sobre el interés del estudiante y los planes que tiene durante las vacaciones. Siempre es importante que te comportes de manera profesional cuando trates con un padre o tutor, pero la conversación no tiene que ser estrictamente sobre educación.</p><p><br></p><p>Evite tomárselo personalmente y hacer suposiciones</p><p><br></p><p>Los padres y tutores son humanos y tienen que lidiar con su propio estrés, ya sea en el trabajo o en su vida familiar. Es mejor para usted mantener siempre la calma y nunca tomar en serio nada de lo que le digan. Siempre debe responder con preguntas que ayuden a calmar la situación. Por ejemplo, un padre o tutor puede decir \"Dices esto porque quieres atrapar a mi hijo\" y la mejor manera de responder a una pregunta como esta es \"Lamento que te sientas así, por favor avísame Por qué piensas esto?</p><p>Además, no debe hacer suposiciones sobre la vida hogareña de un estudiante. A menos que se haya indicado así, una suposición puede causar muchos problemas y puede ser insensible a la situación de una familia. No debe asumir que el estudiante vive con ambos padres o con cualquier padre. Ahora, en nuestro mundo globalmente diverso, no debe asumir que el primer idioma del padre o tutor es el inglés y siempre debe confirmar si pueden hablar inglés en primer lugar. Cada estudiante tendrá una situación diferente a la del próximo. Las suposiciones conducen a malentendidos que pueden crear circunstancias más desafiantes para el aprendizaje.</p><p><br></p><p>Establecer una relación con un padre o tutor a veces puede ser un desafío. Tener estas ideas en mente puede ayudarlo a conectarse mejor con ellas. Es bueno recordar que, al final del día, cuanto mejor sea la conexión que tenga con ellos, mejor podrán ayudar a enseñar al estudiante, lo que en última instancia les permitirá alcanzar el éxito académico y fomentar el amor por el aprendizaje.</p>', 'La relación padre / tutor es una relación importante y, lamentablemente, se pasa por alto en gran medida.'),
(30, 28, 'en', 'Mastering Client Communication to Build Long-Term Freelance', NULL, '<p>The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault. I started tutoring math out of financial desperation. I’d just been fired from my job as a waiter, most of the proofreading in jobs in New York had been outsourced to India, and for the third time in my life, I was facing dire poverty.</p>', '<p>A strong academic record can open doors for you down the road. More importantly, through the process of becoming a straight-A student, you’ll learn values like hard work, discipline and determination.</p><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #1: Always have a plan.</h3><div><div>(a) As the semester progresses, keep track of key dates: tests and exams, project submission deadlines, term breaks, etc.</div><div><br></div><div>Enter these dates into a physical or digital calendar.</div><div><br></div><div><div>If you choose to use a digital calendar, I recommend Google Calendar.</div><div><br></div><div>(b) Schedule a fixed time every week where you review your upcoming events over the next two months. Mark down when you’ll start preparing for that Math exam, working on that History project, or writing that English paper.</div><div><br></div><div>(d) Next, note your commitments for the coming week, e.g. extracurricular activities, family gatherings, extra classes. On your calendar, highlight the blocks of time you’ll have for schoolwork.</div><div><br></div><div>This planning process might sound time-consuming, but it’ll typically take just 15 minutes every week.</div><div><br></div><div>This is a wise investment of time as a student, because the rest of your week will become far more productive.</div><div><br></div><div>This way, you’ll be studying smart, not just hard!</div><div><br></div><div><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #2: Be organized.</h3></div></div></div><div><div>Ever had trouble finding your notes or assignments when you needed them? You probably ended up wasting precious time looking for them, before you finally asked to borrow them from your friend.</div><div><br></div><div>Many students tell me that they keep all their notes and assignments in one big pile, and only sort them out before their exams!</div><div><br></div><div>Being organized – it’s easier said than done, I know.</div></div>', 'The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault.'),
(31, 29, 'en', 'How to Set Freelance Rates and Negotiate with Confidence', NULL, '<p>The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault. I started tutoring math out of financial desperation. I’d just been fired from my job as a waiter, most of the proofreading in jobs in New York had been outsourced to India, and for the third time in my life, I was facing dire poverty.</p>', '<p>A strong academic record can open doors for you down the road. More importantly, through the process of becoming a straight-A student, you’ll learn values like hard work, discipline and determination.</p><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #1: Always have a plan.</h3><div><div>(a) As the semester progresses, keep track of key dates: tests and exams, project submission deadlines, term breaks, etc.</div><div><br></div><div>Enter these dates into a physical or digital calendar.</div><div><br></div><div><div>If you choose to use a digital calendar, I recommend Google Calendar.</div><div><br></div><div>(b) Schedule a fixed time every week where you review your upcoming events over the next two months. Mark down when you’ll start preparing for that Math exam, working on that History project, or writing that English paper.</div><div><br></div><div>(d) Next, note your commitments for the coming week, e.g. extracurricular activities, family gatherings, extra classes. On your calendar, highlight the blocks of time you’ll have for schoolwork.</div><div><br></div><div>This planning process might sound time-consuming, but it’ll typically take just 15 minutes every week.</div><div><br></div><div>This is a wise investment of time as a student, because the rest of your week will become far more productive.</div><div><br></div><div>This way, you’ll be studying smart, not just hard!</div><div><br></div><div><h3 style=\"color: rgb(0, 0, 0); font-family: Lato, sans-serif; margin-right: 0px; margin-bottom: 16px; margin-left: 0px; padding: 0px; font-size: 24px;\">Rule #2: Be organized.</h3></div></div></div><div><div>Ever had trouble finding your notes or assignments when you needed them? You probably ended up wasting precious time looking for them, before you finally asked to borrow them from your friend.</div><div><br></div><div>Many students tell me that they keep all their notes and assignments in one big pile, and only sort them out before their exams!</div><div><br></div><div>Being organized – it’s easier said than done, I know.</div></div>', 'The primary reason kids struggle with school is fear. And in most cases, it’s their parent\'s fault.');

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

--
-- Table structure for table `bulk_imports`
--

CREATE TABLE `bulk_imports` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `data_type` enum('courses','categories','users','products') NOT NULL,
  `valid_items` int(10) UNSIGNED NOT NULL,
  `invalid_items` int(10) UNSIGNED NOT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bundles`
--

CREATE TABLE `bundles` (
  `id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `teacher_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `image_cover` varchar(255) DEFAULT NULL,
  `video_demo` longtext DEFAULT NULL,
  `video_demo_source` enum('upload','youtube','vimeo','external_link','google_drive','iframe','s3','secure_host') DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `private` tinyint(1) NOT NULL DEFAULT 0,
  `subscribe` tinyint(1) NOT NULL DEFAULT 0,
  `certificate` tinyint(1) NOT NULL DEFAULT 0,
  `only_for_students` tinyint(1) NOT NULL DEFAULT 0,
  `access_days` int(10) UNSIGNED DEFAULT NULL COMMENT 'Number of days to access the bundle',
  `message_for_reviewer` text DEFAULT NULL,
  `status` enum('active','pending','is_draft','inactive') NOT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL,
  `updated_at` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bundles`
--

INSERT INTO `bundles` (`id`, `creator_id`, `teacher_id`, `category_id`, `slug`, `thumbnail`, `image_cover`, `video_demo`, `video_demo_source`, `price`, `points`, `private`, `subscribe`, `certificate`, `only_for_students`, `access_days`, `message_for_reviewer`, `status`, `created_at`, `updated_at`) VALUES
(1, 1015, 1015, 609, 'Microsoft-Office-Beginner-to-Expert-Bundle', '/store/1/default_images/bundles/Mask group.jpg', '/store/1015/office_bundle_c.jpg', '/store/1015/Microsoft Excel - Excel from Beginner to Advanced.mkv', 'upload', 50, NULL, 0, 0, 0, 0, NULL, 'Thank you', 'active', 1656082487, 1749974257),
(2, 934, 934, 606, 'A-Z-Web-Programming', '/store/1/default_images/bundles/bundle2.jpg', '/store/934/A-Z Web Programming_c.jpg', '/store/934/Python for Beginners.mp4', 'upload', 8, NULL, 0, 0, 0, 0, NULL, 'Thank you for your review.', 'active', 1656138736, 1749974233),
(3, 929, 929, 602, 'Solar-Energy-Design-Course-From-Zero-To-Hero', '/store/1/default_images/bundles/bundle1.jpg', '/store/929/Solar Energy Design Course From Zero To Hero_c.jpg', NULL, NULL, 25, NULL, 0, 0, 0, 0, NULL, 'Hi,\r\nThank you.', 'active', 1656139531, 1749974199),
(5, 929, 929, 602, 'Become-a-Probability-&-Statistics-Master', '/store/1/default_images/bundles/bundle4.jpg', '/store/929/Solar Energy Design Course From Zero To Hero_c.jpg', NULL, NULL, 25, NULL, 0, 0, 0, 0, NULL, 'Hi,\r\nThank you.', 'active', 1656139531, 1750062626);

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

--
-- Table structure for table `bundle_filter_option`
--

CREATE TABLE `bundle_filter_option` (
  `id` int(10) UNSIGNED NOT NULL,
  `bundle_id` int(10) UNSIGNED NOT NULL,
  `filter_option_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bundle_filter_option`
--

INSERT INTO `bundle_filter_option` (`id`, `bundle_id`, `filter_option_id`) VALUES
(52, 3, 9120),
(53, 3, 9166),
(54, 3, 9240),
(55, 2, 9148),
(56, 2, 9216),
(57, 2, 9279),
(58, 2, 9280),
(59, 2, 9281),
(60, 1, 9138),
(61, 1, 9139),
(62, 1, 9140),
(63, 1, 9196),
(64, 1, 9266);

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

--
-- Table structure for table `bundle_translations`
--

CREATE TABLE `bundle_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bundle_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `seo_description` text DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `description` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bundle_translations`
--

INSERT INTO `bundle_translations` (`id`, `bundle_id`, `locale`, `title`, `seo_description`, `summary`, `description`) VALUES
(1, 1, 'en', 'Microsoft Office Beginner to Expert Bundle', 'Learn to create professional documents with this beginner to advanced Ultimate Microsoft office Course.', NULL, '<p>In this MS Office video course, you will learn everything you need to know about MS Office Accounting. software needs to be installed and link is included in the training. We\'ll take advantage of a 30-day free trial that anyone who registers in the US will get for free. You can also use the Accountants Edition, which is currently free if you are in the US</p><p><br></p><p>Very clear step by step instructions show you how to navigate each part of MS Office. We\'ll do the complete setup together. You will then experience every common type of transaction that can be entered into MS Office . You will learn how to manage and customize the most important reports in MS Office. You can find and fix data entry errors, and even find everything you\'ve entered into your MS Office account. Projects and tests reproduce real-world challenges I\'m going to show you how to use MS Office. You can learn about any industry-specific assignments you might need by watching this topic on MS Office Desktop Videos. In this course, you can apply this particular topic to MS Office .</p><p><br></p><p>The transactions we learned about are what businesses need when using MS Office. We enter customer invoices, sales receipts and payments to the MS Office Accounting By Sage. This training includes depositing and banking related to MS Office, as well as entering supplier accounts and paying invoices in MS Office. This MS Office video training course also covers cash transactions and other cashbacks. I am constantly providing MS Office tips and MS Office tricks so that students have complete control over all their MS Office entries. The main features of MS Office Accounting will help you become an expert at MS Office</p>'),
(2, 1, 'es', 'Paquete definitivo de Microsoft Office para principiantes y expertos', 'Paquete definitivo de Microsoft Office para principiantes y expertos', NULL, '<p>En este curso de video de MS Office, aprenderá todo lo que necesita saber sobre la contabilidad de MS Office. es necesario instalar el software y el enlace está incluido en la capacitación. Aprovecharemos una prueba gratuita de 30 días que cualquier persona que se registre en los EE. UU. obtendrá de forma gratuita. También puede usar la Edición de contadores, que actualmente es gratuita si se encuentra en los EE. UU.</p><p><br></p><p>Las instrucciones paso a paso muy claras le muestran cómo navegar por cada parte de MS Office. Haremos la configuración completa juntos. Luego experimentará cada tipo común de transacción que se puede ingresar en MS Office. Aprenderá a administrar y personalizar los informes más importantes en MS Office. Puede encontrar y corregir errores de entrada de datos, e incluso encontrar todo lo que ha ingresado en su cuenta de MS Office. Los proyectos y las pruebas reproducen desafíos del mundo real. Le mostraré cómo usar MS Office. Puede obtener información sobre las asignaciones específicas de la industria que pueda necesitar al ver este tema en los videos de escritorio de MS Office. En este curso, puede aplicar este tema en particular a MS Office.</p><p><br></p><p>Las transacciones que aprendimos son lo que las empresas necesitan cuando usan MS Office. Ingresamos facturas de clientes, recibos de ventas y pagos al MS Office Accounting By Sage. Esta capacitación incluye depósitos y operaciones bancarias relacionadas con MS Office, además de ingresar cuentas de proveedores y pagar facturas en MS Office. Este curso de capacitación en video de MS Office también cubre transacciones en efectivo y otros reembolsos. Constantemente brindo consejos y trucos de MS Office para que los estudiantes tengan control total sobre todas sus entradas de MS Office. Las características principales de MS Office Accounting lo ayudarán a convertirse en un experto en MS Office</p>'),
(3, 2, 'en', 'A-Z Web Programming', 'The most complete course available on Web Programming.', NULL, '<p>Brad Hussey is updating the entire course to be even more relevant to the modern web designer and front-end web developer as we enter into 2022. Join now to get access!</p><p><br></p><p>This course by Brad Hussey is the go-to, most comprehensive, A to Z web design, web development and career-building course that will kickstart your progress by focusing on what you need to learn, and avoiding the unnecessary details.</p><p><br></p><p>- - -</p><p><br></p><p>Do you want to learn web design and front-end development? Do you need a career change but don\'t know where to start?</p><p><br></p><p>Are you a total beginner looking for an all-in-one Web Design, Web Development and Career Building course that takes you step-by-step through all of the necessary skills you need to know to start working professionally as a web designer or developer?</p><p><br></p><p>Are you a programmer or web developer looking to improve your design skills, so your designer colleagues can stop making fun of your bad designs?</p><p><br></p><p>Or maybe you\'re a graphic designer looking to learn how to code, so your programmer colleagues can stop laughing at your sad coding attempts?</p><p><br></p><p>Have you wasted time & hard earned money watching boring, drawn-out and overwhelming web design and web development courses that promise to make you a complete master of every possible discipline known to man?</p><p><br></p><p>Look no further! There\'s no better place to learn web design and become a skilled front-end developer than with The Ultimate Web Designer & Front-End Developer Course by Brad Hussey.</p><p><br></p><p>This course will teach you everything you need to know (and none of what you don\'t need to know).</p><p><br></p><p>With more than 80,000 happy students, this Udemy course is trusted by beginners and experts alike. Brad Hussey – an experienced web designer and front-end developer – will teach you everything from web design basics to creating beautiful user interfaces with HTML and CSS. You\'ll also learn how to develop dynamic websites with JavaScript, PHP, MySQL and more. And that\'s just the beginning!</p><p><br></p><p>You\'ll also learn about creating responsive websites and user interfaces that look great on any device by using popular frameworks like Bootstrap and Tailwind CSS.</p><p><br></p><p>By the end of this course, you\'ll have the skills and knowledge you need to start your own successful web design career, whether you want to land a job as a web designer or start taking on clients as a freelance web designer.</p><p><br></p><p>So if you\'re ready to become a web designer in 2022?</p><p><br></p><p>Join the course today!</p><p><br></p><p>- - -</p><p><br></p><p>What can you expect from this course?</p><p><br></p><p>You will go from knowing nothing to creating over 23 impressive designs, websites, and applications — all with step-by-step instruction from one of the most entertaining, engaging and passionate web design educators on the web today!</p><p><br></p><p>We\'ll start by learning Visual & Web Design, how to use Adobe Photoshop, and how to sketch professional wireframes. We\'ll then learn to code with HTML5, CSS3, Javascript and jQuery. At this point, you\'ll be able to code custom websites, animations and web applications by yourself.</p><p><br></p><p>Once we\'re cool with the front-end languages, we\'ll then melt our brain-bits with highly advanced skills like Responsive Websites, PHP, MySQL, WordPress and custom WordPress plugin development. You\'ll then have the ability to build responsive, dynamic websites and blogs, basic eCommerce sites and online stores, and have a professional understanding of all aspects of web design & development.</p><p><br></p><p>After you\'ve learned everything from Design to Development, you\'ll be taken through a hands-on career section fully-loaded with valuable tips, resources, and real-world guidance to help you start your career — whether you want to work-from-home as a freelancer or secure a full-time studio gig at a design agency.</p>'),
(4, 3, 'en', 'Solar Energy Design Course From Zero To Hero', 'Learn How To Design And Install Solar Energy Systems With Step By Step Examples Without Previous Knowledge', NULL, '<p>The only course out there with everything you need to know about solar energy from A to Z</p><p><br></p><p>Throughout the course you will learn:</p><p><br></p><p>The fundamentals of solar energy</p><p><br></p><p>Components and design of on-grid and off-grid solar systems</p><p><br></p><p>Types and selection of solar modules</p><p><br></p><p>Types of charge controllers and their selection techniques</p><p><br></p><p>Types and selection of different solar inverters</p><p><br></p><p>Selection of suitable tilt angle and shading effect in PV systems.</p><p><br></p><p>- Types and selection of batteries in solar energy systems.</p><p><br></p><p>- Design and components of the solar water pumping system</p><p><br></p><p>- Design of grounding or earthing system</p><p><br></p><p>- Design of single line diagram of the PV system using the Autocad</p><p><br></p><p>- Design on and off-grid PV systems using the PVSyst program.</p><p><br></p><p>- Design of protection of PV system</p><p><br></p><p><br></p><p><b>After Taking This Course, You Will Be Able To</b></p><p><br></p><p>Understand everything about solar energy systems such as construction and how to select components such as solar panels, charge controllers, inverters, batteries, and busbars.</p><p><br></p><p>Design different solar energy systems such as off-grid, on-grid, and solar water pumping systems.</p><p><br></p><p>You will learn how to design protection and earthing system for solar energy systems.</p><p><br></p><p>You would be able to apply for jobs in the solar energy field without fear of rejection as you have all the knowledge you need to work in the field.</p><p><br></p><p><br></p><p>If you\'ve been looking for ONE COURSE with in-depth insight into solar energy, take this course.</p>'),
(5, 5, 'en', 'Become a Probability & Statistics Master', 'Become a Full-Stack Web Developer with just ONE bundle.', 'Become a Full-Stack Web Developer with just ONE course. HTML, CSS, Javascript, Node, React, PostgreSQL, Web3 and DApps.', '<p>Welcome to the Complete Web Development Bootcamp, the only course you need to learn to code and become a full-stack web developer. </p><p>With 150,000+ ratings and a 4.8 average, my Web Development course is one of the HIGHEST RATED courses in the history of Udemy! </p><p>At 62+ hours, this Web Development course is without a doubt the most comprehensive web development course available online. </p><p>Even if you have zero programming experience, this course will take you from beginner to mastery.</p>');

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

--
-- Table structure for table `bundle_webinars`
--

CREATE TABLE `bundle_webinars` (
  `id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `bundle_id` int(10) UNSIGNED NOT NULL,
  `webinar_id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bundle_webinars`
--

INSERT INTO `bundle_webinars` (`id`, `creator_id`, `bundle_id`, `webinar_id`, `order`) VALUES
(1, 1015, 1, 1998, NULL),
(2, 1015, 1, 2008, NULL),
(3, 1015, 1, 1996, NULL),
(4, 1015, 1, 2009, NULL),
(5, 934, 2, 1997, NULL),
(6, 934, 2, 2005, NULL),
(7, 929, 3, 2004, NULL),
(8, 929, 3, 1999, NULL),
(12, 929, 5, 1999, NULL),
(13, 929, 5, 2004, NULL);

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `product_order_id` int(10) UNSIGNED DEFAULT NULL,
  `reserve_meeting_id` int(10) UNSIGNED DEFAULT NULL,
  `meeting_package_id` int(10) UNSIGNED DEFAULT NULL,
  `event_ticket_id` int(10) UNSIGNED DEFAULT NULL,
  `quantity` int(10) UNSIGNED DEFAULT NULL,
  `subscribe_id` int(10) UNSIGNED DEFAULT NULL,
  `promotion_id` int(10) UNSIGNED DEFAULT NULL,
  `gift_id` int(10) UNSIGNED DEFAULT NULL,
  `ticket_id` int(10) UNSIGNED DEFAULT NULL,
  `special_offer_id` int(10) UNSIGNED DEFAULT NULL,
  `product_discount_id` int(10) UNSIGNED DEFAULT NULL,
  `installment_payment_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`id`, `creator_id`, `webinar_id`, `bundle_id`, `product_order_id`, `reserve_meeting_id`, `meeting_package_id`, `event_ticket_id`, `quantity`, `subscribe_id`, `promotion_id`, `gift_id`, `ticket_id`, `special_offer_id`, `product_discount_id`, `installment_payment_id`, `created_at`) VALUES
(209, 1046, 2005, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1709199575),
(211, 1046, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1709199846),
(214, 1, NULL, NULL, NULL, NULL, NULL, 73, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1763591106);

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

--
-- Table structure for table `cart_discounts`
--

CREATE TABLE `cart_discounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `show_only_on_empty_cart` tinyint(1) NOT NULL DEFAULT 0,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart_discounts`
--

INSERT INTO `cart_discounts` (`id`, `discount_id`, `show_only_on_empty_cart`, `enable`, `created_at`) VALUES
(1, 25, 1, 1, 1709794527);

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

--
-- Table structure for table `cart_discount_translations`
--

CREATE TABLE `cart_discount_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `cart_discount_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart_discount_translations`
--

INSERT INTO `cart_discount_translations` (`id`, `cart_discount_id`, `locale`, `title`, `subtitle`) VALUES
(1, 1, 'en', 'Finalize your purchase with a discount', 'Please take advantage of this limited special offer by using the coupon and completing your purchase.');

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

--
-- Table structure for table `cashback_rules`
--

CREATE TABLE `cashback_rules` (
  `id` int(10) UNSIGNED NOT NULL,
  `target_type` enum('all','courses','store_products','bundles','meetings','registration_packages','subscription_packages','recharge_wallet') NOT NULL,
  `target` varchar(255) DEFAULT NULL,
  `start_date` bigint(20) UNSIGNED DEFAULT NULL,
  `end_date` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double(15,2) DEFAULT NULL,
  `amount_type` enum('fixed_amount','percent') DEFAULT NULL,
  `apply_cashback_per_item` tinyint(1) NOT NULL DEFAULT 0,
  `max_amount` double(15,2) DEFAULT NULL,
  `min_amount` double(15,2) DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cashback_rules`
--

INSERT INTO `cashback_rules` (`id`, `target_type`, `target`, `start_date`, `end_date`, `amount`, `amount_type`, `apply_cashback_per_item`, `max_amount`, `min_amount`, `enable`, `created_at`) VALUES
(5, 'all', NULL, 1672610400, NULL, 10.00, 'percent', 0, NULL, NULL, 1, 1678921892);

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

--
-- Table structure for table `cashback_rule_specification_items`
--

CREATE TABLE `cashback_rule_specification_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `cashback_rule_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `instructor_id` int(10) UNSIGNED DEFAULT NULL,
  `seller_id` int(10) UNSIGNED DEFAULT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `subscribe_id` int(10) UNSIGNED DEFAULT NULL,
  `registration_package_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cashback_rule_translations`
--

CREATE TABLE `cashback_rule_translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `cashback_rule_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cashback_rule_translations`
--

INSERT INTO `cashback_rule_translations` (`id`, `cashback_rule_id`, `locale`, `title`) VALUES
(5, 5, 'en', 'Christmas Cashback');

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

--
-- Table structure for table `cashback_rule_users_groups`
--

CREATE TABLE `cashback_rule_users_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `cashback_rule_id` int(10) UNSIGNED NOT NULL,
  `group_id` int(10) UNSIGNED DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `order` int(10) UNSIGNED DEFAULT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `icon2` varchar(255) DEFAULT NULL,
  `icon2_box_color` varchar(255) DEFAULT NULL,
  `overlay_image` varchar(255) DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `slug`, `parent_id`, `icon`, `order`, `cover_image`, `icon2`, `icon2_box_color`, `overlay_image`, `enable`) VALUES
(520, 'Design', NULL, '/store/1/default_images/categories_icons/feather.png', 7, NULL, '/store/1/default_images/categories_icons/icon2/design_icon2.svg', '#f8d8bf', '/store/1/default_images/categories_icons/icon2/design_overlay.png', 1),
(522, 'Academics', NULL, '/store/1/default_images/categories_icons/briefcase.png', 6, NULL, '/store/1/default_images/categories_icons/icon2/academics_icon2.svg', '#f8ddac', '/store/1/default_images/categories_icons/icon2/academics_overlay.png', 1),
(523, 'Health-and-Fitness', NULL, '/store/1/default_images/categories_icons/heart.png', 5, NULL, '/store/1/default_images/categories_icons/icon2/health_icon2.svg', '#f6c7cb', '/store/1/default_images/categories_icons/icon2/health_overlay.png', 1),
(524, 'Lifestyles', NULL, '/store/1/default_images/categories_icons/umbrella.png', 4, NULL, '/store/1/default_images/categories_icons/icon2/lifestyle_icon2.svg', '#f2d6e9', '/store/1/default_images/categories_icons/icon2/lifestyle_overlay.png', 1),
(525, 'Marketing', NULL, '/store/1/default_images/categories_icons/pie-chart.png', 3, NULL, '/store/1/default_images/categories_icons/icon2/marketing_icon2.svg', '#bfead3', '/store/1/default_images/categories_icons/icon2/marketing_overlay.png', 1),
(526, 'Business', NULL, '/store/1/default_images/categories_icons/anchor.png', 2, NULL, '/store/1/default_images/categories_icons/icon2/business_icon2.svg', '#accef8', '/store/1/default_images/categories_icons/icon2/business_overlay.png', 1),
(528, 'Development', NULL, '/store/1/default_images/categories_icons/code.png', 1, NULL, '/store/1/default_images/categories_icons/icon2/development_icon2.svg', '#f4dbb9', '/store/1/default_images/categories_icons/icon2/development_overlay.png', 1),
(601, 'Math', 522, '/store/1/default_images/categories_icons/sub_categories/divide-square.png', 1, NULL, '/store/1/default_images/categories_icons/icon2/math_icon2.svg', '#f8ddac', '/store/1/default_images/categories_icons/icon2/math_overlay.png', 1),
(602, 'Science', 522, '/store/1/default_images/categories_icons/sub_categories/zap.png', 2, NULL, '/store/1/default_images/categories_icons/icon2/science_icon2.svg', '#f8ddac', '/store/1/default_images/categories_icons/icon2/science_overlay.png', 1),
(603, 'Language', 522, '/store/1/default_images/categories_icons/sub_categories/globe.png', 3, NULL, '/store/1/default_images/categories_icons/icon2/language_icon2.svg', '#f8ddac', '/store/1/default_images/categories_icons/icon2/language_overlay.png', 1),
(604, 'Lifestyle', 524, '/store/1/default_images/categories_icons/sub_categories/sun.png', 1, NULL, '/store/1/default_images/categories_icons/icon2/lifestyle_icon2.svg', '#f2d6e9', '/store/1/default_images/categories_icons/icon2/lifestyle_overlay.png', 1),
(605, 'Beauty-and-Makeup', 524, '/store/1/default_images/categories_icons/sub_categories/droplet.png', 2, NULL, '/store/1/default_images/categories_icons/icon2/beauti_makeup_icon2.svg', '#f2d6e9', '/store/1/default_images/categories_icons/icon2/beauti_makeup_overlay.png', 1),
(606, 'Web-Development', 528, '/store/1/default_images/categories_icons/sub_categories/layout.png', 1, NULL, '/store/1/default_images/categories_icons/icon2/web_development_icon2.svg', '#f4dbb9', '/store/1/default_images/categories_icons/icon2/web_development_overlay.png', 1),
(607, 'Mobile-Development', 528, '/store/1/default_images/categories_icons/sub_categories/smartphone.png', 2, NULL, '/store/1/default_images/categories_icons/icon2/mobile_development_icon2.svg', '#f4dbb9', '/store/1/default_images/categories_icons/icon2/mobile_development_overlay.png', 1),
(608, 'Game-Development', 528, '/store/1/default_images/categories_icons/sub_categories/codesandbox.png', 3, NULL, '/store/1/default_images/categories_icons/icon2/game_development_icon2.svg', '#f4dbb9', '/store/1/default_images/categories_icons/icon2/game_development_overlay.png', 1),
(609, 'Management', 526, '/store/1/default_images/categories_icons/sub_categories/users.png', 1, NULL, '/store/1/default_images/categories_icons/icon2/management_icon2.svg', '#accef8', '/store/1/default_images/categories_icons/icon2/management_overlay.png', 1),
(610, 'Communications', 526, '/store/1/default_images/categories_icons/sub_categories/share-2.png', 2, NULL, '/store/1/default_images/categories_icons/icon2/communications_icon2.svg', '#accef8', '/store/1/default_images/categories_icons/icon2/communications_overlay.png', 1),
(611, 'Business-Strategy', 526, '/store/1/default_images/categories_icons/sub_categories/target.png', 3, NULL, '/store/1/default_images/categories_icons/icon2/strategy_icon2.svg', '#accef8', '/store/1/default_images/categories_icons/icon2/strategy_overlay.png', 1);

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

--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text DEFAULT NULL,
  `bottom_seo_title` text DEFAULT NULL,
  `bottom_seo_content` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_translations`
--

INSERT INTO `category_translations` (`id`, `category_id`, `locale`, `title`, `subtitle`, `bottom_seo_title`, `bottom_seo_content`) VALUES
(1, 520, 'en', 'Design', 'Learn design principles, tools, and techniques to create visually compelling and user-focused digital experiences', 'About Design Courses', 'Explore our comprehensive design courses that cover everything from graphic design fundamentals to advanced UI/UX techniques. Learn from industry experts through hands-on projects and real-world case studies. Whether you\'re a beginner or looking to enhance your skills, our courses provide the perfect blend of theory and practical application. Gain valuable insights into the latest design trends and tools while building a professional portfolio. Start your creative journey today and unlock exciting career opportunities in the dynamic field of design.'),
(2, 522, 'en', 'Academics', 'Strengthen your academic knowledge across subjects with expert-led lessons, practice exercises, and clear explanations', 'About Academic Courses', 'Enhance your academic performance with our carefully curated courses designed by experienced educators. Covering a wide range of subjects from mathematics to literature, our programs offer structured learning paths with interactive content and personalized feedback. Perfect for students looking to supplement their school curriculum or adults pursuing lifelong learning. Access high-quality educational resources anytime, anywhere, and track your progress with our intuitive learning platform. Invest in your intellectual growth today and achieve your academic goals with confidence.'),
(3, 523, 'en', 'Health & Fitness', 'Explore physical and mental health topics to improve well-being, build habits, and support healthy lifestyles', 'About Health & Fitness Courses', 'Transform your health and wellness journey with our expert-led fitness and nutrition courses. Discover science-backed strategies for weight management, stress reduction, and overall wellbeing. Learn proper exercise techniques, meal planning, and mindfulness practices from certified professionals. Whether you want to lose weight, build muscle, or simply feel better, our courses provide the knowledge and motivation you need. Join a community of health-conscious learners and take the first step toward a healthier, happier you today.'),
(4, 524, 'en', 'Lifestyle', 'Discover courses that enhance daily living, from personal development to hobbies, wellness, and productivity skills', 'About Lifestyle Courses', 'Elevate every aspect of your life with our diverse lifestyle courses covering personal development, hobbies, and productivity. Learn time management techniques, creative skills, and mindfulness practices from top instructors. Whether you want to improve your relationships, discover new passions, or optimize your daily routine, we have the perfect course for you. Our practical, actionable content helps you implement positive changes immediately. Start your journey to a more fulfilling lifestyle today and unlock your full potential.'),
(5, 525, 'en', 'Marketing', 'Master modern marketing strategies to promote brands, engage audiences, and drive business success effectively', 'About Marketing Courses', 'Stay ahead in the competitive marketing landscape with our comprehensive courses covering digital strategies, analytics, and consumer behavior. Learn from industry leaders about SEO, social media marketing, content creation, and data-driven decision making. Perfect for entrepreneurs, business owners, and marketing professionals looking to expand their skill set. Our practical approach combines theoretical knowledge with real-world applications. Launch your marketing career or take your business to new heights with our expert guidance and support.'),
(6, 526, 'en', 'Business', 'Gain essential business skills to manage, grow, and lead successful organizations in any industry', 'About Business Courses', 'Develop the skills needed to succeed in today\'s dynamic business environment with our comprehensive course offerings. Learn about entrepreneurship, management, finance, and strategic planning from experienced business leaders. Our courses combine theoretical frameworks with practical case studies and real-world applications. Whether you\'re starting a business or advancing your corporate career, we provide the knowledge and tools for success. Join thousands of professionals who have transformed their careers through our business education programs.'),
(7, 528, 'en', 'Development', 'Learn to build websites, apps, and software with hands-on coding lessons from expert instructors', 'About Development Courses', 'Launch your tech career with our in-depth development courses covering programming languages, frameworks, and software engineering principles. From beginner to advanced levels, our curriculum is designed by industry experts to provide practical, job-ready skills. Work on real projects, build a portfolio, and learn best practices used by top tech companies. Whether you\'re interested in web development, mobile apps, or software engineering, we have the perfect learning path for you. Start coding today and open doors to exciting opportunities in the tech industry.'),
(8, 601, 'en', 'Math', 'Master mathematical concepts, from basic arithmetic to advanced topics, with step-by-step lessons and practice problems', 'About Math Courses', 'Build a strong mathematical foundation with our comprehensive courses designed for all skill levels. Our structured curriculum covers everything from basic arithmetic to advanced calculus and statistics. Learn through interactive lessons, practical examples, and problem-solving exercises guided by experienced math educators. Perfect for students struggling with math concepts or professionals needing quantitative skills. With flexible learning options and personalized support, you can master math at your own pace and achieve your academic or career goals.'),
(9, 602, 'en', 'Science', 'Explore scientific principles and discoveries through engaging lessons in physics, biology, chemistry, and more', 'About Science Courses', 'Discover the wonders of science through our engaging courses in physics, chemistry, biology, and earth sciences. Our interactive curriculum brings scientific concepts to life with experiments, simulations, and real-world applications. Learn from passionate educators who make complex topics accessible and interesting. Whether you\'re a student preparing for exams or a curious mind exploring scientific phenomena, our courses offer valuable knowledge and critical thinking skills. Embark on a journey of scientific discovery and satisfy your curiosity about how the world works.'),
(10, 603, 'en', 'Language', 'Improve your language skills with interactive courses in grammar, vocabulary, pronunciation, and real-life conversation', 'About Language Courses', 'Achieve fluency in your target language with our immersive courses designed for all proficiency levels. Our proven methodology combines grammar instruction, vocabulary building, and conversational practice with native speakers. Learn practical language skills for travel, business, or personal enrichment through interactive lessons and cultural insights. Whether you\'re starting from scratch or refining your fluency, we provide the tools and support for effective language acquisition. Join our global community of language learners and open doors to new cultures and opportunities.'),
(11, 604, 'en', 'Lifestyle', 'Discover courses that enhance daily living, from personal development to hobbies, wellness, and productivity skills', 'About Lifestyle Courses', 'Transform your daily routine and personal growth with our lifestyle courses that cover everything from productivity hacks to creative pursuits. Learn practical strategies for stress management, organization, and work-life balance from experienced instructors. Discover new hobbies and skills that bring joy and fulfillment to your life. Our courses combine expert knowledge with actionable steps you can implement immediately. Whether you want to improve your home, relationships, or personal wellbeing, we have the perfect course to help you live your best life.'),
(12, 605, 'en', 'Beauty & Makeup', 'Learn professional beauty techniques, makeup artistry, and skincare routines for personal or career growth', 'About Beauty & Makeup Courses', 'Master the art of beauty and makeup with our professional courses taught by industry experts. Learn cutting-edge techniques for skincare, cosmetic application, and personal grooming. Our comprehensive curriculum covers everything from everyday looks to special occasion makeup and professional artistry. Whether you\'re pursuing a beauty career or simply want to enhance your personal skills, our courses provide step-by-step guidance. Gain confidence in your beauty routine and discover the latest trends and products in the ever-evolving world of cosmetics.'),
(13, 606, 'en', 'Web Development', 'Master front-end and back-end skills to create dynamic, responsive, and modern websites from scratch', 'About Web Development Courses', 'Build professional websites and applications with our complete web development curriculum covering HTML, CSS, JavaScript, and popular frameworks. Learn responsive design, backend development, and deployment strategies from experienced developers. Our project-based approach ensures you gain practical skills while building a portfolio of real work. Whether you\'re changing careers or upgrading your skills, we provide the training and support to succeed in this high-demand field. Start your journey to becoming a full-stack developer today with our comprehensive courses.'),
(14, 607, 'en', 'Mobile Development', 'Build powerful Android and iOS apps using modern tools, frameworks, and hands-on mobile projects', 'About Mobile Development Courses', 'Create innovative mobile applications with our expert-led courses in iOS and Android development. Learn to use modern tools like Swift, Kotlin, and React Native to build functional, user-friendly apps. Our curriculum covers everything from UI design to backend integration and app store deployment. Work on real projects that demonstrate your skills to potential employers or clients. Whether you\'re a beginner or experienced developer, our courses will help you master mobile technologies and tap into the booming app market.'),
(15, 608, 'en', 'Game Development', 'Learn to design and develop engaging games using Unity, Unreal Engine, and real-world game projects', 'About Game Development Courses', 'Turn your passion for games into a career with our comprehensive game development program. Learn industry-standard tools like Unity and Unreal Engine while creating playable game prototypes. Our curriculum covers game design principles, programming, 3D modeling, and monetization strategies. Benefit from expert instruction and feedback as you build an impressive portfolio. Whether you dream of indie development or working for major studios, our courses provide the skills and knowledge to succeed in this exciting, creative field.'),
(16, 609, 'en', 'Management', 'Develop leadership and organizational skills to effectively manage teams, projects, and business operations', 'About Management Courses', 'Enhance your leadership capabilities with our management courses designed for professionals at all levels. Learn essential skills in team leadership, project management, strategic planning, and organizational behavior. Our practical approach combines theoretical frameworks with real-world case studies and interactive exercises. Whether you\'re an aspiring manager or experienced executive, our courses will help you navigate complex business challenges and inspire your teams to achieve exceptional results. Invest in your professional growth and become a more effective leader today.'),
(17, 610, 'en', 'Communications', 'Enhance your verbal and written communication skills for effective workplace, public, and interpersonal interactions', 'About Communications Courses', 'Master the art of effective communication with our comprehensive courses covering public speaking, business writing, and interpersonal skills. Learn to convey ideas clearly, persuade audiences, and build strong professional relationships. Our curriculum includes practical exercises, feedback sessions, and real-world applications to build confidence in any communication scenario. Whether you want to excel in presentations, negotiations, or everyday workplace interactions, our courses provide the tools for success. Transform how you communicate and open doors to new career opportunities.'),
(18, 611, 'en', 'Business Strategy', 'Learn to analyze markets, set goals, and craft strategic plans that drive sustainable business growth', 'About Business Strategy Courses', 'Develop the strategic thinking skills needed to guide organizations to long-term success with our expert-led courses. Learn competitive analysis, strategic planning, and execution frameworks used by top companies. Our case-study based approach provides practical insights into real business challenges and solutions. Whether you\'re an entrepreneur, executive, or consultant, these courses will enhance your ability to make data-driven decisions and create sustainable competitive advantages. Gain the strategic mindset that separates successful leaders from the rest.'),
(19, 528, 'ar', 'تطوير', 'تعلم بناء مواقع الويب والتطبيقات والبرامج من خلال دروس البرمجة العملية من مدربين خبراء', 'أفضل دورات تدريبية عبر الإنترنت في تطوير', 'اكتشف عالم التطوير والبرمجة من خلال دوراتنا الشاملة التي تغطي أحدث لغات البرمجة وأطر العمل. تعلم من خبراء الصناعة عبر دروس عملية ومشاريع حقيقية تنمي مهاراتك التقنية. سواء كنت مبتدئًا أو مبرمجًا محترفًا يرغب في تطوير مهاراته، فإن مناهجنا المصممة بعناية توفر لك المسار الأمثل للتعلم. احصل على شهادات معتمدة وابنِ ملفًا شخصيًا يبرز مهاراتك للعملاء وأصحاب العمل. ابدأ رحلتك في عالم التطوير اليوم وافتح أبوابًا جديدة في سوق العمل المتنامي.'),
(20, 606, 'ar', 'تطوير الشبكة', 'أتقن مهارات الواجهة الأمامية والخلفية لإنشاء مواقع ويب ديناميكية وسريعة الاستجابة وحديثة من الصفر', 'أفضل دورات تدريبية عبر الإنترنت في تطوير الشبكة', 'احترف تطوير الويب من خلال دوراتنا المتكاملة التي تغطي HTML، CSS، JavaScript وأشهر أطر العمل مثل React وNode.js. تعلم كيفية إنشاء مواقع متكاملة وتطبيقات ويب تفاعلية من الصفر حتى النشر. استفد من مشاريع عملية حقيقية وملاحظات الخبراء لبناء محفظة أعمال تثبت مهاراتك. سواء كنت تبدأ مسيرتك أو تطور مهاراتك الحالية، نوفر لك الدعم والموارد اللازمة للتميز في هذا المجال المطلوب. ابدأ اليوم رحلتك لتصبح مطور ويب محترف.'),
(21, 607, 'ar', 'تطوير المحمول', 'قم ببناء تطبيقات Android و iOS قوية باستخدام الأدوات والأطر الحديثة ومشاريع الجوال العملية', 'أفضل دورات تدريبية عبر الإنترنت في تطوير المحمول', 'انطلق في عالم تطبيقات الجوال مع دوراتنا الشاملة في تطوير iOS وAndroid. تعلم لغات Swift وKotlin وأطر العمل الحديثة لإنشاء تطبيقات وظيفية وجذابة. من خلال مشاريع عملية وتوجيه من خبراء الصناعة، ستكتسب المهارات اللازمة لنشر تطبيقاتك على متاجر التطبيقات. سواء كنت تطمح للعمل في شركات التقنية أو تنطلق كمطور مستقل، فإن دوراتنا توفر لك المعرفة العملية والخبرة اللازمة للنجاح في سوق التطبيقات المزدهر. ابدأ بناء مستقبلك في تطوير الجوال اليوم.'),
(22, 608, 'ar', 'تطوير اللعبة', 'تعلم تصميم وتطوير ألعاب جذابة باستخدام Unity و Unreal Engine ومشاريع ألعاب واقعية', 'أفضل دورات تدريبية عبر الإنترنت في تطوير اللعبة', 'حوّل شغفك بالألعاب إلى مهنة مع دوراتنا المتخصصة في تطوير الألعاب. تعلم استخدام Unity وUnreal Engine لإنشاء ألعاب احترافية ثنائية وثلاثية الأبعاد. من خلال منهج عملي يركز على المشاريع، ستتعلم تصميم الألعاب، البرمجة، النمذجة ثلاثية الأبعاد واستراتيجيات الربح. استفد من ملاحظات الخبراء أثناء بناء محفظة أعمال تبرز إبداعك وقدراتك التقنية. سواء كنت تطمح للعمل مع استوديوهات كبرى أو تطوير ألعابك المستقلة، فإن دوراتنا توفر لك المهارات اللازمة للنجاح في هذه الصناعة المثيرة.'),
(23, 526, 'ar', 'عمل', 'اكتسب المهارات الأساسية للأعمال لإدارة ونمو وقيادة المنظمات الناجحة في أي صناعة', 'أفضل دورات تدريبية عبر الإنترنت في عمل', 'طور مهاراتك الإدارية والقيادية مع دوراتنا الشاملة في مجال الأعمال التي تغتي ريادة الأعمال، الإدارة المالية، والتخطيط الاستراتيجي. تعلم من خبراء الصناعة عبر دروس تفاعلية ودراسات حالة حقيقية توضح تطبيق النظريات في الواقع العملي. سواء كنت صاحب مشروع ناشئ أو مديرًا محترفًا يسعى للتطور، فإن دوراتنا توفر لك المعرفة والأدوات اللازمة لقيادة مؤسستك نحو النجاح. انضم إلى آلاف المحترفين الذين طوروا مسيرتهم من خلال برامجنا التدريبية وابدأ رحلتك نحو التميز في عالم الأعمال اليوم.'),
(24, 609, 'ar', 'إدارة', 'طور مهارات القيادة والتنظيم لإدارة الفرق والمشاريع وعمليات الأعمال بشكل فعال', 'أفضل دورات تدريبية عبر الإنترنت في إدارة', 'احترف فن الإدارة والقيادة مع دوراتنا المتخصصة التي تغطي أحدث النظريات والممارسات الإدارية. تعلم كيفية قيادة الفرق بفعالية، إدارة المشاريع المعقدة، واتخاذ القرارات الاستراتيجية. من خلال دراسات حالة واقعية وتمارين تفاعلية، ستطور المهارات اللازمة لإدارة التحديات التنظيمية وتحقيق الأهداف بفعالية. سواء كنت مديرًا مبتدئًا أو تنفيذيًا محنكًا، فإن دوراتنا توفر لك الرؤى والأدوات لتصبح قائدًا أكثر فعالية. استثمر في نموك المهني اليوم وتميز في مجال الإدارة التنافسي.'),
(25, 610, 'ar', 'مجال الاتصالات', 'عزز مهارات التواصل اللفظي والكتابي للتفاعلات الفعالة في مكان العمل والعامة والشخصية', 'أفضل دورات تدريبية عبر الإنترنت في مجال الاتصالات', 'أتقن فن التواصل الفعال مع دوراتنا الشاملة في مهارات الاتصال التي تغطي الخطابة، الكتابة المهنية، والتفاوض. تعلم كيفية صياغة الرسائل المؤثرة، إدارة الحوارات الصعبة، وبناء علاقات عمل قوية. من خلال تمارين عملية وملاحظات الخبراء، ستكتسب الثقة في التعبير عن أفكارك بوضوح وإقناع في أي سياق. سواء كنت تسعى للتقدم في عملك أو تحسين تواصلك اليومي، فإن دوراتنا توفر لك الأدوات اللازمة للتميز في هذا المهارة الأساسية للنجاح المهني والشخصي.'),
(26, 611, 'ar', 'استراتيجية العمل', 'تعلم تحليل الأسواق ووضع الأهداف وصياغة الخطط الاستراتيجية التي تدفع نمو الأعمال المستدام', 'أفضل دورات تدريبية عبر الإنترنت في استراتيجية العمل', 'طور مهاراتك الاستراتيجية مع دوراتنا المتخصصة في تخطيط الأعمال وتحليل المنافسة. تعلم كيفية تقييم الفرص السوقية، صياغة خطط عمل فعالة، وقيادة التغيير التنظيمي. من خلال دراسات حالة لشركات عالمية، ستكتسب رؤى عملية حول صنع القرارات الاستراتيجية في بيئات الأعمال المعقدة. سواء كنت قائدًا تنفيذيًا، مستشارًا، أو رائد أعمال، فإن هذه الدورات ستمكنك من تطوير رؤية استراتيجية واضحة تقود مؤسستك نحو النمو المستدام. استثمر في تطوير مهاراتك الاستراتيجية اليوم وتميز في قيادة الأعمال.'),
(27, 525, 'ar', 'تسويق', 'أتقن استراتيجيات التسويق الحديثة للترويج للعلامات التجارية وإشراك الجماهير وتحقيق نجاح الأعمال بشكل فعال', 'أفضل دورات تدريبية عبر الإنترنت في تسويق', 'احترف عالم التسويق الرقمي والتقليدي مع دوراتنا الشاملة التي تغتي أحدث استراتيجيات جذب العملاء وبناء العلامات التجارية. تعلم تقنيات SEO، التسويق عبر وسائل التواصل الاجتماعي، تحليل البيانات، وإدارة الحملات الإعلانية من خبراء الصناعة. من خلال مشاريع عملية ودراسات حالة حقيقية، ستكتسب المهارات اللازمة لتصميم وتنفيذ خطط تسويقية ناجحة. سواء كنت صاحب عمل أو متخصص تسويق يسعى للتطوير، فإن دوراتنا توفر لك المعرفة العملية لتحقيق نتائج ملموسة. ابدأ رحلتك في عالم التسويق المثير اليوم.'),
(28, 524, 'ar', 'أسلوب الحياة', 'اكتشف الدورات التي تعزز الحياة اليومية، من التنمية الشخصية إلى الهوايات والعافية ومهارات الإنتاجية', 'أفضل دورات تدريبية عبر الإنترنت في أسلوب الحياة', 'حسّن جودة حياتك اليومية مع دوراتنا المتنوعة في تطوير الذات، الصحة، الإنتاجية، واكتشاف الهوايات. تعلم تقنيات إدارة الوقت، تخفيف التوتر، والعناية بالذات من خبراء معتمدين. اكتشف شغفك الجديد من خلال ورش عمل إبداعية وتجارب تعليمية تفاعلية. سواء كنت تسعى لتحقيق التوازن بين العمل والحياة، أو تبحث عن شغف جديد، فإن دوراتنا توفر لك الأدوات والمعرفة لإحداث تغييرات إيجابية دائمة. ابدأ رحلتك نحو حياة أكثر إشباعًا وتوازنًا اليوم.'),
(29, 604, 'ar', 'أسلوب الحياة', 'اكتشف الدورات التي تعزز الحياة اليومية، من التنمية الشخصية إلى الهوايات والعافية ومهارات الإنتاجية', 'أفضل دورات تدريبية عبر الإنترنت في أسلوب الحياة', 'ارتقِ بكل جوانب حياتك مع دوراتنا الشاملة في أسلوب الحياة التي تغطي الصحة، العلاقات، التنظيم المنزلي، وتطوير الذات. تعلم من خبراء في مجالاتهم كيفية إدارة الضغوط، تحسين عادات النوم، وبناء روتين يومي مثالي. اكتشف تقنيات عملية لتعزيز إنتاجيتك وإثراء وقت فراغك بأنشطة مجدية. سواء كنت تسعى لتحقيق توازن أفضل أو إحداث تغيير جذري، فإن دوراتنا توفر الإرشاد والدعم اللازمين. ابدأ رحلتك نحو حياة أكثر سعادة وإنجازًا اليوم.'),
(30, 605, 'ar', 'الجمال والمكياج', 'تعلم تقنيات الجمال الاحترافية وفن المكياج والعناية بالبشرة للنمو الشخصي أو المهني', 'أفضل دورات تدريبية عبر الإنترنت في الجمال والمكياج', 'أطلق العنان لإبداعك في عالم الجمال مع دوراتنا المتخصصة في فن المكياج، العناية بالبشرة، وتصفيف الشعر. تعلم أحدث التقنيات من خبراء معتمدين باستخدام منتجات ومعدات احترافية. سواء كنت تسعى لاحتراف المجال أو تطوير مهاراتك الشخصية، فإن دوراتنا توفر تدريبًا عمليًا مع تركيز على أحدث صيحات الموضة والجمال. اكتسب الثقة في تطبيق المكياج للأنواع المختلفة من المناسبات وتعلم أسرار العناية بالبشرة للحصول على إطلالة مشرقة. ابدأ رحلتك في عالم الجمال المثير اليوم.'),
(31, 523, 'ar', 'الصحة واللياقة البدنية', 'استكشف موضوعات الصحة البدنية والعقلية لتحسين الرفاهية وبناء العادات ودعم أنماط الحياة الصحية', 'أفضل دورات تدريبية عبر الإنترنت في الصحة واللياقة البدنية', 'احقق أهدافك الصحية مع دوراتنا الشاملة في اللياقة البدنية، التغذية، والعافية النفسية. تعلم تمارين فعالة من مدربين معتمدين، وخطط تغذية متوازنة من أخصائيين، وتقنيات لإدارة التوتر من خبراء الصحة النفسية. سواء كنت تهدف لخسارة الوزن، بناء العضلات، أو تحسين صحتك العامة، فإن دوراتنا توفر لك البرامج المخصصة والدعم المستمر لتحقيق نتائج دائمة. انضم إلى مجتمعنا من المهتمين بالصحة وابدأ رحلتك نحو حياة أكثر نشاطًا وحيوية اليوم.'),
(32, 522, 'ar', 'أكاديميون', 'قم بتعزيز معرفتك الأكاديمية عبر الموضوعات من خلال دروس يقودها خبراء وتمارين عملية وشروحات واضحة', 'أفضل دورات تدريبية عبر الإنترنت في أكاديميون', 'عزز أداءك الأكاديمي مع دوراتنا المصممة خصيصًا لتعميق الفهم في مختلف التخصصات العلمية والأدبية. تعلم من مدرسين متمرسين يقدمون شروحات واضحة وأساليب حل مبتكرة. سواء كنت طالبًا تستعد للامتحانات أو بالغًا يسعى لتوسيع معارفه، فإن مناهجنا التفاعلية توفر لك الأدوات اللازمة للتفوق الأكاديمي. مع خيارات تعلم مرنة ودروس مكثفة، يمكنك التحكم بوتيرة تعلمك وتحقيق أهدافك التعليمية بكفاءة. ابدأ رحلتك نحو التميز الأكاديمي اليوم.'),
(33, 601, 'ar', 'رياضيات', 'أتقن المفاهيم الرياضية، من الحساب الأساسي إلى الموضوعات المتقدمة، مع دروس خطوة بخطوة ومشاكل الممارسة', 'أفضل دورات تدريبية عبر الإنترنت في رياضيات', 'احترف الرياضيات من خلال دوراتنا الشاملة التي تغطي جميع المستويات من الأساسيات إلى المتقدم. تعلم حل المسائل بثقة مع شروحات واضحة وأمثلة عملية من مدرسين متمرسين. سواء كنت طالبًا يعاني مع الرياضيات أو محترفًا يحتاج لتطوير مهاراته الحسابية، فإن مناهجنا المصممة بعناية توفر لك المسار الأمثل للتعلم. مع تمارين تفاعلية واختبارات تقييمية، يمكنك تتبع تقدمك وإتقان كل مفهوم قبل الانتقال إلى التالي. ابدأ رحلتك لإتقان الرياضيات اليوم.'),
(34, 602, 'ar', 'علم', 'استكشف المبادئ والاكتشافات العلمية من خلال دروس جذابة في الفيزياء والبيولوجيا والكيمياء والمزيد', 'أفضل دورات تدريبية عبر الإنترنت في علم', 'اكتشف عجائب العلوم مع دوراتنا التفاعلية في الفيزياء، الكيمياء، الأحياء، وعلوم الأرض. تعلم من خلال تجارب افتراضية، رسوم متحركة توضيحية، وشروحات مبسطة تجعل المفاهيم المعقدة سهلة الفهم. سواء كنت طالبًا يستعد للامتحانات أو شخصًا شغوفًا بالعلوم، فإن دوراتنا توفر لك بوابة للاستكشاف العلمي الممتع. تعمق في فهم الظواهر الطبيعية وتطور المعرفة العلمية مع مدرسين متخصصين يجعلون التعلم تجربة مثيرة. ابدأ رحلتك في عالم العلوم الواسع اليوم.'),
(35, 603, 'ar', 'لغة', 'حسّن مهاراتك اللغوية من خلال دورات تفاعلية في القواعد والمفردات والنطق والمحادثة في الحياة الواقعية', 'أفضل دورات تدريبية عبر الإنترنت في لغة', 'أتقن لغة جديدة أو حسّن مهاراتك اللغوية الحالية مع دوراتنا المصممة وفق أحدث منهجيات تعليم اللغات. تعلم من متحدثين أصليين عبر دروس تفاعلية تركز على المحادثة العملية واستيعاب الثقافات. سواء كنت تتعلم للعمل، السفر، أو التحدي الشخصي، فإن مناهجنا المخصصة توفر لك المسار الأمثل لتحقيق الطلاقة. مع تمارين يومية ودروس حية، يمكنك ممارسة اللغة في سياقات واقعية وبناء ثقتك في الاستخدام اليومي. ابدأ رحلتك لتعلم اللغة اليوم وافتح أبوابًا جديدة للتواصل.'),
(36, 520, 'ar', 'تصميم', 'تعلم مبادئ وأدوات وتقنيات التصميم لإنشاء تجارب رقمية جذابة بصريًا وتركز على المستخدم', 'أفضل دورات تدريبية عبر الإنترنت في تصميم', 'أطلق إبداعك مع دوراتنا الشاملة في التصميم الجرافيكي، UI/UX، والتصميم الرقمي. تعلم استخدام أحدث الأدوات مثل Adobe Creative Suite وFigma بينما تطور عينك الفنية وفهمك لمبادئ التصميم الأساسية. من خلال مشاريع عملية وملاحظات من مصممين محترفين، ستقوم ببناء محفظة أعمال تبرز موهبتك الفريدة. سواء كنت تسعى للعمل في وكالات التصميم أو كمستقل، فإن دوراتنا توفر لك المهارات اللازمة للنجاح في هذا المجال التنافسي. ابدأ رحلتك في عالم التصميم الإبداعي اليوم.'),
(37, 528, 'es', 'Desarrollo', 'Aprende a crear sitios web, aplicaciones y software con lecciones prácticas de codificación de instructores expertos', 'Los mejores cursos online de Desarrollo', 'Sumérgete en el mundo del desarrollo de software con nuestros cursos completos que cubren los lenguajes de programación más demandados y las mejores prácticas de la industria. Aprende desde los fundamentos hasta temas avanzados con proyectos prácticos que simulan desafíos del mundo real. Ideal para quienes buscan iniciar una carrera tecnológica o profesionales que desean actualizar sus habilidades. Con instructores expertos y una comunidad de aprendizaje activa, obtendrás las herramientas necesarias para destacar en este campo en constante evolución. Comienza tu viaje en el desarrollo hoy mismo.'),
(38, 606, 'es', 'Desarrollo web', 'Domina habilidades de front-end y back-end para crear sitios web dinámicos, responsivos y modernos desde cero', 'Los mejores cursos online de Desarrollo web', 'Conviértete en un desarrollador web full-stack con nuestro plan de estudios integral que abarca HTML, CSS, JavaScript y frameworks modernos como React y Node.js. Aprende a construir aplicaciones web completas, implementar bases de datos y desplegar tus proyectos en la nube. Nuestro enfoque práctico te permite aprender haciendo, con ejercicios reales y retroalimentación de desarrolladores experimentados. Perfecto para quienes buscan cambiar de carrera o emprender en el mundo digital. Domina las habilidades más demandadas del desarrollo web actual.'),
(39, 607, 'es', 'Desarrollo móvil', 'Crea potentes aplicaciones para Android e iOS utilizando herramientas modernas, frameworks y proyectos móviles prácticos', 'Los mejores cursos online de Desarrollo móvil', 'Aprende a desarrollar aplicaciones móviles nativas e híbridas con nuestros cursos especializados en iOS y Android. Domina Swift, Kotlin, React Native y las mejores prácticas para crear apps funcionales y atractivas. Desde la interfaz de usuario hasta la integración con APIs y publicación en las tiendas de aplicaciones, cubrimos todo el proceso de desarrollo. Ideal para emprendedores que quieren lanzar su app o desarrolladores que buscan especializarse en móviles. Conviértete en un desarrollador móvil certificado y accede a oportunidades en este mercado en crecimiento.'),
(40, 608, 'es', 'Desarrollo de juegos', 'Aprende a diseñar y desarrollar juegos atractivos utilizando Unity, Unreal Engine y proyectos de juegos del mundo real', 'Los mejores cursos online de Desarrollo de juegos', 'Transforma tu pasión por los videojuegos en una carrera profesional con nuestros cursos especializados. Aprende game design, programación en C#, modelado 3D y técnicas de monetización utilizando Unity y Unreal Engine. Desarrolla juegos completos desde el concepto inicial hasta la publicación, construyendo un portafolio que demuestre tu creatividad y habilidades técnicas. Ya sea que sueñes con trabajar en grandes estudios o desarrollar juegos independientes, nuestros cursos te proporcionan el conocimiento práctico para triunfar en esta industria emocionante.'),
(41, 526, 'es', 'Negocio', 'Adquiere habilidades empresariales esenciales para gestionar, hacer crecer y liderar organizaciones exitosas en cualquier industria', 'Los mejores cursos online de Negocio', 'Desarrolla las competencias clave para el éxito empresarial con nuestros cursos creados por líderes de la industria. Cubrimos emprendimiento, gestión financiera, marketing digital, operaciones y estrategia corporativa. Aprende mediante casos de estudio reales y simulaciones que te preparan para los desafíos del mundo empresarial actual. Perfecto para dueños de negocios, ejecutivos y profesionales que buscan ascender en sus carreras. Adquiere las herramientas para tomar decisiones informadas, liderar equipos y hacer crecer organizaciones de manera sostenible.'),
(42, 609, 'es', 'Gestión', 'Desarrolla habilidades de liderazgo y organización para gestionar eficazmente equipos, proyectos y operaciones comerciales', 'Los mejores cursos online de Gestión', 'Conviértete en un líder efectivo con nuestros programas de gestión que combinan teoría y práctica. Aprende metodologías ágiles, gestión del cambio, resolución de conflictos y técnicas para motivar equipos de alto rendimiento. Nuestros instructores, con amplia experiencia ejecutiva, comparten insights valiosos y estrategias comprobadas. Ideal para gerentes nuevos que buscan fundamentos sólidos o líderes experimentados que desean refinar sus habilidades. Desarrolla el mindset y las herramientas necesarias para navegar los complejos desafíos de la gestión moderna.'),
(43, 610, 'es', 'Comunicaciones', 'Mejora tus habilidades de comunicación verbal y escrita para interacciones efectivas en el lugar de trabajo, públicas e interpersonales', 'Los mejores cursos online de Comunicaciones', 'Domina el arte de comunicar con impacto a través de nuestros cursos prácticos en oratoria, redacción profesional y comunicación interpersonal. Aprende técnicas para presentaciones convincentes, negociación efectiva y manejo de conversaciones difíciles. Mediante ejercicios grabados y feedback personalizado, desarrollarás confianza en cualquier situación comunicativa. Esencial para profesionales que necesitan influir, vender ideas o liderar equipos. Mejora tus relaciones laborales y personales con habilidades de comunicación clara y persuasiva que marcan la diferencia.'),
(44, 611, 'es', 'Estrategia de negocios', 'Aprende a analizar mercados, establecer objetivos y elaborar planes estratégicos que impulsen el crecimiento empresarial sostenible', 'Los mejores cursos online de Estrategia de negocios', 'Descubre una amplia gama de cursos online de Estrategia de negocios diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(45, 525, 'es', 'Márketing', 'Domina estrategias de marketing modernas para promocionar marcas, involucrar audiencias e impulsar el éxito empresarial de manera efectiva', 'Los mejores cursos online de Márketing', 'Descubre una amplia gama de cursos online de Márketing diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(46, 524, 'es', 'Estilo de vida', 'Descubre cursos que mejoran la vida diaria, desde el desarrollo personal hasta pasatiempos, bienestar y habilidades de productividad', 'Los mejores cursos online de Estilo de vida', 'Descubre una amplia gama de cursos online de Estilo de vida diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(47, 604, 'es', 'Estilo de vida', 'Descubre cursos que mejoran la vida diaria, desde el desarrollo personal hasta pasatiempos, bienestar y habilidades de productividad', 'Los mejores cursos online de Estilo de vida', 'Descubre una amplia gama de cursos online de Estilo de vida diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(48, 605, 'es', 'Belleza y maquillaje', 'Aprende técnicas profesionales de belleza, maquillaje y rutinas de cuidado de la piel para el crecimiento personal o profesional', 'Los mejores cursos online de Belleza y maquillaje', 'Descubre una amplia gama de cursos online de Belleza y maquillaje diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(49, 523, 'es', 'salud y estado fisico', 'Explora temas de salud física y mental para mejorar el bienestar, crear hábitos y apoyar estilos de vida saludables', 'Los mejores cursos online de salud y estado fisico', 'Descubre una amplia gama de cursos online de salud y estado fisico diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(50, 522, 'es', 'Académica', 'Fortalece tu conocimiento académico en todas las materias con lecciones dirigidas por expertos, ejercicios prácticos y explicaciones claras', 'Los mejores cursos online de Académica', 'Descubre una amplia gama de cursos online de Académica diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(51, 601, 'es', 'Matemáticas', 'Domina conceptos matemáticos, desde aritmética básica hasta temas avanzados, con lecciones paso a paso y problemas prácticos', 'Los mejores cursos online de Matemáticas', 'Descubre una amplia gama de cursos online de Matemáticas diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(52, 602, 'es', 'Ciencias', 'Explora principios y descubrimientos científicos a través de lecciones atractivas en física, biología, química y más', 'Los mejores cursos online de Ciencias', 'Descubre una amplia gama de cursos online de Ciencias diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(53, 603, 'es', 'Idioma', 'Mejora tus habilidades lingüísticas con cursos interactivos de gramática, vocabulario, pronunciación y conversación en la vida real', 'Los mejores cursos online de Idioma', 'Descubre una amplia gama de cursos online de Idioma diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.'),
(54, 520, 'es', 'Diseño', 'Aprende principios, herramientas y técnicas de diseño para crear experiencias digitales visualmente atractivas y centradas en el usuario', 'Los mejores cursos online de Diseño', 'Descubre una amplia gama de cursos online de Diseño diseñados para ayudarte a desarrollar tus habilidades y alcanzar tus metas profesionales y personales.');

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

--
-- Table structure for table `certificates`
--

CREATE TABLE `certificates` (
  `id` int(10) UNSIGNED NOT NULL,
  `quiz_id` int(10) UNSIGNED DEFAULT NULL,
  `quiz_result_id` int(10) UNSIGNED DEFAULT NULL,
  `student_id` int(10) UNSIGNED NOT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `user_grade` int(10) UNSIGNED DEFAULT NULL,
  `type` enum('quiz','course','bundle') NOT NULL,
  `created_at` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `certificates`
--

INSERT INTO `certificates` (`id`, `quiz_id`, `quiz_result_id`, `student_id`, `webinar_id`, `bundle_id`, `user_grade`, `type`, `created_at`) VALUES
(3, 28, 28, 995, NULL, NULL, 80, 'quiz', 1626213083),
(4, 33, 29, 996, NULL, NULL, 80, 'quiz', 1626237574),
(5, 34, 30, 979, NULL, NULL, 90, 'quiz', 1626237968),
(6, NULL, NULL, 995, 2007, NULL, NULL, 'course', 1709715260);

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

--
-- Table structure for table `certificates_templates`
--

CREATE TABLE `certificates_templates` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` enum('quiz','course','bundle') NOT NULL,
  `position_x` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `position_y` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `font_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('draft','publish') NOT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `certificates_templates`
--

INSERT INTO `certificates_templates` (`id`, `image`, `type`, `position_x`, `position_y`, `font_size`, `text_color`, `status`, `created_at`, `updated_at`) VALUES
(7, '/store/1/default_images/certificate_background.jpg', 'quiz', NULL, NULL, NULL, NULL, 'publish', 1709112544, NULL),
(8, '/store/1/default_images/certificate_background.jpg', 'course', NULL, NULL, NULL, NULL, 'publish', 1709713472, NULL);

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

--
-- Table structure for table `certificate_template_translations`
--

CREATE TABLE `certificate_template_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `certificate_template_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `rtl` tinyint(4) DEFAULT NULL,
  `elements` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `certificate_template_translations`
--

INSERT INTO `certificate_template_translations` (`id`, `certificate_template_id`, `locale`, `title`, `body`, `rtl`, `elements`) VALUES
(9, 7, 'en', 'Quiz-depended Certificate Template', '<div class=\"certificate-template-container\" style=\"background-image: url(&quot;https://lms.rocket-soft.org/store/1/default_images/certificate_background.jpg&quot;);\"><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"title\" style=\"top: 225.134px; left: 247.125px; font-size: 22px; color: rgb(0, 0, 0); text-align: inherit; font-weight: bold;\">This certificate awarded to [student_name]</div><div class=\"draggable-element ui-draggable ui-draggable-handle ui-draggable-dragging\" data-name=\"subtitle\" style=\"top: 271.982px; left: 320.964px; font-size: 18px; color: rgb(0, 0, 0); text-align: inherit; font-weight: inherit;\">regarding passing [course_name]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"body\" style=\"top: 318.571px; left: 337.563px; font-size: 16px; color: rgb(0, 0, 0); text-align: inherit; font-weight: inherit;\">with the [grade] grade with success</div><div class=\"draggable-element ui-draggable ui-draggable-handle ui-draggable-dragging\" data-name=\"date\" style=\"top: 80.4286px; left: 57.4286px; font-size: 14px; color: rgb(0, 0, 0); text-align: inherit; font-weight: bold;\">[date]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"qr_code\" style=\"top: 392.42px; left: 728.42px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\">[qr_code]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"hint\" style=\"top: 49.4286px; left: 760.429px; font-size: 14px; color: rgb(0, 0, 0); text-align: inherit; font-weight: bold;\">ID : [certificate_id]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"platform_name\" style=\"top: 47.7143px; left: 55.7143px; font-size: 16px; color: rgb(0, 0, 0); text-align: inherit; font-weight: bold;\">[platform_name]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"stamp\" style=\"display: flex; align-items: center; justify-content: center; top: 399.714px; left: 100.714px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\"><img src=\"https://lms.rocket-soft.org/store/1/default_images/stamp.png\" style=\"max-height: 100%; max-width: 100%;\"></div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"platform_signature\" style=\"display: flex; align-items: center; justify-content: center; top: 399.429px; left: 241.429px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\"><img src=\"https://lms.rocket-soft.org/store/1/default_images/signature.png\" style=\"max-height: 100%; max-width: 100%;\"></div></div>', NULL, '{\"title\":{\"content\":\"This certificate awarded to [student_name]\",\"font_size\":\"22\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"enable\":\"on\"},\"subtitle\":{\"content\":\"regarding passing [course_name]\",\"font_size\":\"18\",\"font_color\":\"#000000\",\"styles\":null,\"enable\":\"on\"},\"body\":{\"content\":\"with the [grade] grade with success\",\"font_size\":\"16\",\"font_color\":\"#000000\",\"styles\":null,\"enable\":\"on\"},\"date\":{\"display_date\":\"textual\",\"font_size\":\"14\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"enable\":\"on\",\"content\":\"[date]\"},\"qr_code\":{\"image_size\":\"128\",\"enable\":\"on\",\"content\":\"[qr_code]\"},\"hint\":{\"content\":\"ID : [certificate_id]\",\"font_size\":\"14\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"enable\":\"on\"},\"student_name\":{\"font_size\":\"22\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"content\":\"[student_name]\"},\"instructor_name\":{\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[instructor_name]\"},\"platform_name\":{\"font_size\":\"16\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"enable\":\"on\",\"content\":\"[platform_name]\"},\"course_name\":{\"font_size\":\"22\",\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[course_name]\"},\"instructor_signature\":{\"content\":\"[instructor_signature]\"},\"platform_signature\":{\"image\":\"\\/store\\/1\\/default_images\\/signature.png\",\"image_size\":\"128\",\"enable\":\"on\"},\"stamp\":{\"image\":\"\\/store\\/1\\/default_images\\/stamp.png\",\"image_size\":\"128\",\"enable\":\"on\"}}'),
(10, 8, 'en', 'Completion Certificate Template', '<div class=\"certificate-template-container\" style=\"background-image: url(&quot;https://lms.rocket-soft.org/store/1/default_images/certificate_background.jpg&quot;);\"><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"title\" style=\"top: 244.134px; left: 272.125px; font-size: 22px; color: rgb(0, 0, 0); text-align: inherit; font-weight: bold;\">This certificate awarded to [student]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"subtitle\" style=\"top: 301.134px; left: 338.125px; font-size: 18px; color: rgb(0, 0, 0); text-align: inherit; font-weight: inherit;\">regarding completing [course]</div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"platform_signature\" style=\"display: flex; align-items: center; justify-content: center; top: 408.42px; left: 702.42px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\"><img src=\"https://lms.rocket-soft.org/store/1/default_images/signature.png\" style=\"max-height: 100%; max-width: 100%;\"></div><div class=\"draggable-element ui-draggable ui-draggable-handle\" data-name=\"stamp\" style=\"display: flex; align-items: center; justify-content: center; top: 408.42px; left: 96.4286px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\"><img src=\"https://lms.rocket-soft.org/store/1/default_images/stamp.png\" style=\"max-height: 100%; max-width: 100%;\"></div><div class=\"draggable-element ui-draggable ui-draggable-handle ui-draggable-dragging\" data-name=\"qr_code\" style=\"top: 58.4286px; left: 736.42px; text-align: inherit; font-weight: inherit; width: 128px; height: 128px;\">[qr_code]</div></div>', NULL, '{\"title\":{\"content\":\"This certificate awarded to [student]\",\"font_size\":\"22\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"enable\":\"on\"},\"subtitle\":{\"content\":\"regarding completing [course]\",\"font_size\":\"18\",\"font_color\":\"#000000\",\"styles\":null,\"enable\":\"on\"},\"body\":{\"content\":null,\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null},\"date\":{\"display_date\":\"textual\",\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[date]\"},\"qr_code\":{\"image_size\":\"128\",\"enable\":\"on\",\"content\":\"[qr_code]\"},\"hint\":{\"content\":null,\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null},\"student_name\":{\"font_size\":\"22\",\"font_color\":\"#000000\",\"styles\":null,\"font_weight_bold\":\"on\",\"content\":\"[student_name]\"},\"instructor_name\":{\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[instructor_name]\"},\"platform_name\":{\"font_size\":null,\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[platform_name]\"},\"course_name\":{\"font_size\":\"18\",\"font_color\":\"#000000\",\"styles\":null,\"content\":\"[course_name]\"},\"instructor_signature\":{\"content\":\"[instructor_signature]\"},\"platform_signature\":{\"image\":\"\\/store\\/1\\/default_images\\/signature.png\",\"image_size\":\"128\",\"enable\":\"on\"},\"stamp\":{\"image\":\"\\/store\\/1\\/default_images\\/stamp.png\",\"image_size\":\"128\",\"enable\":\"on\"}}');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `review_id` int(10) UNSIGNED DEFAULT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `event_id` int(10) UNSIGNED DEFAULT NULL,
  `upcoming_course_id` int(10) UNSIGNED DEFAULT NULL,
  `blog_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `product_review_id` int(10) UNSIGNED DEFAULT NULL,
  `reply_id` int(10) UNSIGNED DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `status` enum('pending','active') NOT NULL,
  `report` tinyint(1) NOT NULL DEFAULT 0,
  `disabled` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` int(11) NOT NULL,
  `viewed_at` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `user_id`, `review_id`, `webinar_id`, `bundle_id`, `event_id`, `upcoming_course_id`, `blog_id`, `product_id`, `product_review_id`, `reply_id`, `comment`, `status`, `report`, `disabled`, `created_at`, `viewed_at`) VALUES
(43, 996, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Hi.\r\nWhat is the level of this course?', 'active', 0, 0, 1625863108, NULL),
(44, 930, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'I have already taken another course with this teacher. His teaching method is excellent.', 'active', 0, 0, 1625863203, 1625863611),
(45, 979, NULL, 1999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Is it possible to participate in this course without participating in the prerequisite course?', 'active', 0, 0, 1625863345, NULL),
(47, 1015, NULL, 1998, NULL, NULL, NULL, NULL, NULL, NULL, 44, 'Thanks a lot for your comment, Best regards.', 'active', 0, 0, 1625863726, 1626235570),
(48, 3, NULL, 1997, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Will we be able to build applications at the end of this course?', 'active', 0, 0, 1625864259, 1625864297),
(49, 934, NULL, 1997, NULL, NULL, NULL, NULL, NULL, NULL, 48, 'Hi.\r\nYes you can.', 'active', 0, 0, 1625864351, NULL),
(50, 1016, NULL, 2006, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Will this course be updated in the future?', 'active', 0, 0, 1625864416, NULL),
(51, 995, NULL, 2004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Will we receive a certificate at the end of this course?', 'active', 0, 0, 1625864526, NULL),
(52, 1015, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Perfect course, thank you.', 'active', 0, 0, 1626235679, NULL),
(53, 995, NULL, 1995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Course files are not complete !!!', 'active', 0, 0, 1626240118, 1626240169),
(54, 1016, NULL, 1995, NULL, NULL, NULL, NULL, NULL, NULL, 53, 'Please prove. The course files are complete and 90% of the students are satisfied.', 'active', 0, 0, 1626240342, 1626241422),
(55, 929, NULL, 1995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Is it possible to update the course ?', 'active', 0, 0, 1626241320, 1626241422),
(56, 929, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Hi.\r\nIs it possible to start the class earlier?', 'active', 0, 0, 1626241386, NULL),
(57, 1016, NULL, 1995, NULL, NULL, NULL, NULL, NULL, NULL, 55, 'No, but it may change in the future. Thank you', 'active', 0, 0, 1626241505, NULL),
(58, 3, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, 56, 'Hi kate.\r\nNo, but it may change in the future. Thank you', 'active', 0, 0, 1626242070, NULL),
(63, 996, NULL, 2003, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'As i already new a lot on this matter i was surprised that i actually find out that there are more ways to tweak your time management', 'active', 0, 0, 1626509327, NULL),
(64, 1015, NULL, 1995, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Great course that gives you the basic knowledge needed to become a product manager.', 'pending', 0, 0, 1626509546, NULL),
(65, 863, NULL, 2002, NULL, NULL, NULL, NULL, NULL, NULL, 52, 'We are very happy that you are satisfied with this course.', 'pending', 0, 0, 1626509913, NULL),
(66, 1015, NULL, NULL, NULL, NULL, NULL, 21, NULL, NULL, NULL, 'Thank you for this excellent article.', 'active', 0, 0, 1646413650, NULL);

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

--
-- Table structure for table `comments_reports`
--

CREATE TABLE `comments_reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `blog_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED DEFAULT NULL,
  `webinar_id` int(10) UNSIGNED DEFAULT NULL,
  `bundle_id` int(10) UNSIGNED DEFAULT NULL,
  `event_id` int(10) UNSIGNED DEFAULT NULL,
  `comment_id` int(10) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `comments_reports`
--

INSERT INTO `comments_reports` (`id`, `user_id`, `blog_id`, `product_id`, `webinar_id`, `bundle_id`, `event_id`, `comment_id`, `message`, `created_at`) VALUES
(5, 1016, NULL, NULL, 1995, NULL, NULL, 53, 'this is a spam comment.', 1626240256);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `reply` text DEFAULT NULL,
  `status` enum('pending','replied') NOT NULL DEFAULT 'pending',
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `content_delete_requests`
--

CREATE TABLE `content_delete_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `targetable_id` int(10) UNSIGNED NOT NULL,
  `targetable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_published_date` bigint(20) UNSIGNED DEFAULT NULL,
  `customers_count` int(10) UNSIGNED DEFAULT NULL,
  `sales` decimal(15,2) DEFAULT NULL,
  `status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `content_delete_requests`
--

INSERT INTO `content_delete_requests` (`id`, `user_id`, `targetable_id`, `targetable_type`, `description`, `content_title`, `content_published_date`, `customers_count`, `sales`, `status`, `created_at`) VALUES
(1, 1015, 1996, 'App\\Models\\Webinar', 'I would like to release an update for this course. Could you please delete it?', 'Learn Linux in 5 Days', 1624943782, 5, 0.00, 'pending', 1709711134);

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

--
-- Table structure for table `course_learning_last_views`
--

CREATE TABLE `course_learning_last_views` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `webinar_id` int(10) UNSIGNED NOT NULL,
  `item_id` int(10) UNSIGNED NOT NULL,
  `item_type` enum('file','session','text_lesson','assignment','quiz') NOT NULL,
  `visited_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course_learning_last_views`
--

INSERT INTO `course_learning_last_views` (`id`, `user_id`, `webinar_id`, `item_id`, `item_type`, `visited_at`) VALUES
(1, 1, 2008, 65, 'file', 1750162338),
(2, 1015, 1996, 52, 'session', 1750030160),
(3, 1, 2010, 75, 'file', 1750162277),
(4, 1, 1995, 28, 'quiz', 1750162315),
(5, 995, 2008, 60, 'file', 1750162423),
(6, 995, 1995, 28, 'quiz', 1750162437),
(7, 995, 2009, 74, 'session', 1763587042),
(8, 1015, 2008, 35, 'quiz', 1751723977),
(9, 996, 2009, 75, 'session', 1764575512),
(10, 1, 2009, 75, 'session', 1764575552),
(11, 1015, 2009, 75, 'session', 1764575595),
(12, 995, 1998, 118, 'session', 1764575987),
(13, 996, 1998, 118, 'session', 1764576191),
(14, 1017, 1998, 118, 'session', 1764576247);

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

--
-- Table structure for table `course_noticeboards`
--

CREATE TABLE `course_noticeboards` (
  `id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `webinar_id` int(10) UNSIGNED NOT NULL,
  `color` enum('warning','danger','neutral','info','success') NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_noticeboards`
--

INSERT INTO `course_noticeboards` (`id`, `creator_id`, `webinar_id`, `color`, `title`, `message`, `created_at`) VALUES
(1, 1015, 2008, 'danger', 'Important notice', '<p>Dear students. I will upload the new assignment for you soon. Please send the previous assignment by the end of the month.</p><p>The final quiz&nbsp;will be held at the end of next month. The exact date of the quiz will be announced.</p>', 1656083692),
(2, 1015, 2008, 'warning', 'Quiz date changed', '<p>Hi, Dear students</p><p>The mid-term Quiz date changed.</p><p>We hope to you take mentioned quiz next week.</p><p>Regards.</p>', 1656136473),
(3, 1015, 2008, 'info', 'Upload final chapter', '<p>Hi, Dear students.</p><p>We are going to upload the last chapter next month.</p><p>Regards.</p>', 1656136763),
(4, 1015, 2008, 'success', 'Top Students', '<p>Hi, Dear students</p><p>We intend to appreciate the top students.</p><p>We will announce the list of top students.</p><p>Regards.</p><p><br></p>', 1656136896),
(5, 929, 2010, 'success', 'Top Students', '<p>Hi, Dear students</p><p>We intend to appreciate the top students.</p><p>We will announce the list of top students.</p><p>Regards.</p>', 1656137511),
(6, 929, 2010, 'warning', 'Quiz date changed', '<p>Hi, Dear students</p><p>The mid-term Quiz date changed.</p><p>We hope to you take mentioned quiz next week.</p><p>Regards.</p>', 1656137557);

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

--
-- Table structure for table `course_noticeboard_status`
--

CREATE TABLE `course_noticeboard_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `noticeboard_id` int(10) UNSIGNED NOT NULL,
  `seen_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_noticeboard_status`
--

INSERT INTO `course_noticeboard_status` (`id`, `user_id`, `noticeboard_id`, `seen_at`) VALUES
(1, 995, 1, 1656103105),
(2, 996, 1, 1656103714),
(3, 995, 5, 1656142535),
(4, 995, 6, 1656142535),
(5, 996, 5, 1656219599),
(6, 996, 6, 1656219599),
(7, 995, 2, 1656406722),
(8, 995, 3, 1656406722),
(9, 995, 4, 1656406722),
(10, 996, 2, 1656407301),
(11, 996, 3, 1656407301),
(12, 996, 4, 1656407301);

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

--
-- Table structure for table `course_personal_notes`
--

CREATE TABLE `course_personal_notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `course_id` int(10) UNSIGNED NOT NULL,
  `targetable_id` int(10) UNSIGNED NOT NULL,
  `targetable_type` varchar(255) NOT NULL,
  `note` text DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course_personal_notes`
--

INSERT INTO `course_personal_notes` (`id`, `user_id`, `course_id`, `targetable_id`, `targetable_type`, `note`, `attachment`, `created_at`) VALUES
(1, 996, 2003, 45, 'App\\Models\\File', 'I will complete this lesson on May 5th, 2023.', '/store/996/lmX4K.png', 1709535241),
(2, 996, 2009, 75, 'App\\Models\\Session', 'I need to provide documentation to the teacher for this session.', NULL, 1709535321),
(3, 995, 2008, 61, 'App\\Models\\File', 'I need to provide documentation to the teacher for this session.', NULL, 1709535364),
(4, 995, 2009, 76, 'App\\Models\\Session', 'I need to submit the homework to the teacher for this session.', '/store/995/homework.docx', 1709535439);

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int(10) UNSIGNED NOT NULL,
  `currency` varchar(255) NOT NULL,
  `currency_position` enum('left','right','left_with_space','right_with_space') NOT NULL,
  `currency_separator` enum('dot','comma') NOT NULL,
  `currency_decimal` int(10) UNSIGNED DEFAULT NULL,
  `exchange_rate` double(15,2) DEFAULT NULL,
  `order` int(10) UNSIGNED DEFAULT NULL,
  `created_at` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `currency`, `currency_position`, `currency_separator`, `currency_decimal`, `exchange_rate`, `order`, `created_at`) VALUES
(4, 'EUR', 'left', 'dot', 2, 0.93, 1, 1678868603),
(6, 'INR', 'left', 'dot', 2, 82.52, 2, 1678869222);

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

--
-- Table structure for table `delete_account_requests`
--

CREATE TABLE `delete_account_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delete_account_requests`
--

INSERT INTO `delete_account_requests` (`id`, `user_id`, `created_at`) VALUES
(1, 864, 1656194622);

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

--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `discount_type` enum('percentage','fixed_amount') NOT NULL,
  `source` enum('all','course','category','meeting','product','bundle','event','meeting_package') NOT NULL,
  `code` varchar(64) NOT NULL,
  `percent` int(10) UNSIGNED DEFAULT NULL,
  `amount` decimal(15,2) UNSIGNED DEFAULT NULL,
  `max_amount` decimal(15,2) UNSIGNED DEFAULT NULL,
  `minimum_order` decimal(15,2) UNSIGNED DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT 1,
  `user_type` enum('all_users','special_users') NOT NULL,
  `product_type` enum('all','physical','virtual') DEFAULT NULL,
  `for_first_purchase` tinyint(1) NOT NULL DEFAULT 0,
  `private` tinyint(1) NOT NULL DEFAULT 0,
  `status` enum('active','disable') NOT NULL DEFAULT 'active',
  `expired_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `discounts`
--

INSERT INTO `discounts` (`id`, `creator_id`, `title`, `subtitle`, `discount_type`, `source`, `code`, `percent`, `amount`, `max_amount`, `minimum_order`, `count`, `user_type`, `product_type`, `for_first_purchase`, `private`, `status`, `expired_at`, `created_at`) VALUES
(7, 1, 'Black Friday', NULL, 'percentage', 'course', 'BLK2021', 20, 10.00, NULL, NULL, 20, 'all_users', 'all', 0, 0, 'active', 1797193740, 1626132792),
(8, 1, 'Store Physical Products Coupon', NULL, 'percentage', 'product', 'SPGH22', 10, NULL, NULL, NULL, 5, 'all_users', 'physical', 0, 0, 'active', 1773185400, 1656320198),
(9, 1, 'Store Virtual Products Coupon', NULL, 'percentage', 'product', 'VKRYT22', 20, NULL, NULL, NULL, 10, 'all_users', 'virtual', 0, 0, 'active', 1775052000, 1656320568),
(10, 1, 'Categories Coupon', NULL, 'percentage', 'category', 'GJKTPW', 10, NULL, 10.00, NULL, 1, 'all_users', 'all', 0, 0, 'active', 1828915200, 1656320749),
(24, 1015, 'Black Firday Offer', 'Buy now with a special offer', 'percentage', 'all', 'BLK10', 10, NULL, 50.00, NULL, 100, 'all_users', 'all', 0, 0, 'active', 1806379200, 1709540145),
(25, 1, '2024 Offer for All Users', NULL, 'percentage', 'all', 'All10', 10, NULL, NULL, NULL, 50, 'all_users', 'all', 0, 0, 'active', 1805515200, 1709728742);

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

--
-- Table structure for table `discount_bundles`
--

CREATE TABLE `discount_bundles` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `bundle_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_categories`
--

CREATE TABLE `discount_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `discount_categories`
--

INSERT INTO `discount_categories` (`id`, `discount_id`, `category_id`, `created_at`) VALUES
(10, 10, 520, 1709728551),
(11, 10, 608, 1709728551),
(12, 10, 606, 1709728551);

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

--
-- Table structure for table `discount_courses`
--

CREATE TABLE `discount_courses` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `course_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_events`
--

CREATE TABLE `discount_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `discount_groups`
--

CREATE TABLE `discount_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `group_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_meeting_packages`
--

CREATE TABLE `discount_meeting_packages` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `meeting_package_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `discount_users`
--

CREATE TABLE `discount_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` enum('in_person','online') NOT NULL DEFAULT 'online',
  `slug` varchar(255) NOT NULL,
  `creator_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `video_demo_source` enum('upload','youtube','vimeo','external_link','google_drive','iframe','s3','secure_host') DEFAULT NULL,
  `video_demo` longtext DEFAULT NULL,
  `sales_count_number` int(10) UNSIGNED DEFAULT NULL,
  `capacity` int(10) UNSIGNED DEFAULT NULL,
  `purchase_limit_count` int(10) UNSIGNED DEFAULT NULL,
  `duration` int(10) UNSIGNED DEFAULT NULL,
  `start_date` bigint(20) UNSIGNED DEFAULT NULL,
  `end_date` bigint(20) UNSIGNED DEFAULT NULL,
  `sales_end_date` bigint(20) UNSIGNED DEFAULT NULL,
  `enable_countdown` tinyint(1) NOT NULL DEFAULT 0,
  `countdown_time_reference` enum('start_date','sales_end_date') DEFAULT NULL,
  `timezone` varchar(255) DEFAULT NULL,
  `support` tinyint(1) NOT NULL DEFAULT 0,
  `certificate` tinyint(1) NOT NULL DEFAULT 0,
  `private` tinyint(1) NOT NULL DEFAULT 0,
  `message_for_reviewer` text DEFAULT NULL,
  `status` enum('publish','draft','pending','unpublish','canceled','rejected') NOT NULL DEFAULT 'draft',
  `created_at` bigint(20) UNSIGNED NOT NULL,
  `updated_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `type`, `slug`, `creator_id`, `category_id`, `thumbnail`, `cover_image`, `icon`, `video_demo_source`, `video_demo`, `sales_count_number`, `capacity`, `purchase_limit_count`, `duration`, `start_date`, `end_date`, `sales_end_date`, `enable_countdown`, `countdown_time_reference`, `timezone`, `support`, `certificate`, `private`, `message_for_reviewer`, `status`, `created_at`, `updated_at`) VALUES
(2, 'online', 'mastering-react-development', 1016, 611, '/store/1/default_images/events/thumbnails/event12.jpg', '/store/1/default_images/events/thumbnails/event12.jpg', NULL, NULL, NULL, NULL, 150, 5, 480, 1836409200, 1836495600, 1836322800, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763242809, 1763632951),
(3, 'in_person', 'full-stack-web-development-bootcamp', 1016, 611, '/store/1/default_images/events/thumbnails/event11.jpg', '/store/1/default_images/events/thumbnails/event11.jpg', NULL, NULL, NULL, NULL, 80, 2, 720, 1837279200, 1837365600, 1837196400, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763243809, 1763631601),
(4, 'online', 'python-data-science-masterclass', 934, 520, '/store/1/default_images/events/thumbnails/event10.jpg', '/store/1/default_images/events/thumbnails/event10.jpg', NULL, NULL, NULL, NULL, 120, 3, 360, 1803679200, 1835820000, 1835564400, 1, 'start_date', 'America/New_York', 1, 0, 0, NULL, 'publish', 1763244809, 1763632697),
(5, 'online', 'ui-ux-design-fundamentals', 934, 603, '/store/1/default_images/events/thumbnails/event9.jpg', '/store/1/default_images/events/thumbnails/event9.jpg', NULL, NULL, NULL, NULL, 100, 4, 240, 1775860800, 1776552000, 1775778000, 1, 'start_date', 'America/New_York', 0, 1, 0, NULL, 'publish', 1763245809, 1763630852),
(6, 'in_person', 'agile-project-management-workshop', 934, 608, '/store/1/default_images/events/thumbnails/event8.jpg', '/store/1/default_images/events/thumbnails/event8.jpg', NULL, NULL, NULL, NULL, 60, 2, 180, 1839889200, 1839975600, 1839802800, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763246809, 1763630502),
(7, 'online', 'machine-learning-ai-essentials', 867, 611, '/store/1/default_images/events/thumbnails/event7.jpg', '/store/1/default_images/events/thumbnails/event7.jpg', NULL, NULL, NULL, NULL, 90, 3, 420, 1714096800, 1714615200, 1714446000, 1, 'start_date', 'America/New_York', 1, 0, 0, NULL, 'publish', 1763247809, 1763632123),
(8, 'online', 'cybersecurity-best-practices', 867, 611, '/store/1/default_images/events/thumbnails/event6.jpg', '/store/1/default_images/events/thumbnails/event6.jpg', NULL, NULL, NULL, NULL, 110, 4, 300, 1746934800, 1747021200, 1746848400, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763248809, 1763624238),
(9, 'in_person', 'mobile-app-development-ios-android', 867, 611, '/store/1/default_images/events/thumbnails/event5.jpg', '/store/1/default_images/events/thumbnails/event5.jpg', NULL, NULL, NULL, NULL, 70, 2, 600, 1842499200, 1842585600, 1842416400, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763249809, 1763629605),
(10, 'online', 'digital-marketing-mastery', 1015, 605, '/store/1/default_images/events/thumbnails/event4.jpg', '/store/1/default_images/events/thumbnails/event4.jpg', NULL, NULL, NULL, NULL, 140, 5, 360, 1715756400, 1717225200, 1717052400, 1, 'start_date', 'America/New_York', 0, 1, 0, NULL, 'publish', 1763250809, 1763629160),
(11, 'online', 'cloud-computing-aws-azure', 1015, 606, '/store/1/default_images/events/thumbnails/event3.jpg', '/store/1/default_images/events/thumbnails/event3.jpg', NULL, NULL, NULL, NULL, 95, 3, 480, 1820565600, 1820652000, 1820482800, 1, 'start_date', 'America/New_York', 1, 0, 0, NULL, 'publish', 1763251809, 1763631919),
(12, 'in_person', 'blockchain-crypto-development', 1015, 525, '/store/1/default_images/events/thumbnails/event2.jpg', '/store/1/default_images/events/thumbnails/event2.jpg', NULL, NULL, NULL, NULL, 85, 2, 420, 1749723600, 1750501200, 1749550800, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763252809, 1763631381),
(13, 'online', 'devops-ci-cd-automation', 1015, 611, '/store/1/default_images/events/thumbnails/event1.jpg', '/store/1/default_images/events/thumbnails/event1.jpg', NULL, NULL, NULL, NULL, 105, 4, 540, 1751284800, 1846065600, 1845896400, 1, 'start_date', 'America/New_York', 1, 1, 0, NULL, 'publish', 1763253809, 1763630826);

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

--
-- Table structure for table `event_filter_options`
--

CREATE TABLE `event_filter_options` (
  `id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `filter_option_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_filter_options`
--

INSERT INTO `event_filter_options` (`id`, `event_id`, `filter_option_id`) VALUES
(174, 8, 9146),
(175, 8, 9211),
(176, 8, 9275),
(177, 8, 9276),
(178, 10, 9188),
(179, 10, 9257),
(180, 10, 9258),
(181, 9, 9146),
(182, 9, 9211),
(183, 9, 9275),
(184, 9, 9276),
(185, 6, 9153),
(186, 6, 9155),
(187, 6, 9226),
(188, 6, 9288),
(189, 6, 9289),
(194, 13, 9146),
(195, 13, 9211),
(196, 13, 9275),
(197, 13, 9276),
(198, 5, 9123),
(199, 5, 9171),
(200, 5, 9244),
(201, 5, 9245),
(206, 12, 9136),
(207, 12, 9191),
(208, 12, 9262),
(209, 12, 9264),
(210, 3, 9146),
(211, 3, 9211),
(212, 3, 9275),
(213, 3, 9276),
(214, 11, 9147),
(215, 11, 9216),
(216, 11, 9279),
(217, 11, 9280),
(218, 7, 9146),
(219, 7, 9211),
(220, 7, 9275),
(221, 7, 9276),
(222, 4, 9114),
(223, 4, 9115),
(224, 4, 9116),
(225, 4, 9156),
(226, 4, 9158),
(227, 4, 9231),
(228, 4, 9233),
(229, 2, 9146),
(230, 2, 9211),
(231, 2, 9275),
(232, 2, 9276);

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

--
-- Table structure for table `event_reports`
--

CREATE TABLE `event_reports` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `reason` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `event_speakers`
--

CREATE TABLE `event_speakers` (
  `id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `order` int(10) UNSIGNED DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_speakers`
--

INSERT INTO `event_speakers` (`id`, `event_id`, `image`, `link`, `order`, `enable`, `created_at`) VALUES
(2, 2, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763242922),
(3, 2, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763242923),
(4, 2, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763242924),
(5, 3, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763243922),
(6, 3, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763243923),
(7, 3, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763243924),
(8, 4, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763244922),
(9, 4, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763244923),
(10, 4, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763244924),
(11, 5, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763245922),
(12, 5, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763245923),
(13, 5, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763245924),
(14, 6, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763246922),
(15, 6, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763246923),
(16, 6, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763246924),
(17, 7, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763247922),
(18, 7, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763247923),
(19, 7, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763247924),
(20, 8, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763248922),
(21, 8, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763248923),
(22, 8, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763248924),
(23, 9, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763249922),
(24, 9, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763249923),
(25, 9, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763249924),
(26, 10, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763250922),
(27, 10, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763250923),
(28, 10, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763250924),
(29, 11, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763251922),
(30, 11, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763251923),
(31, 11, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763251924),
(32, 12, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763252922),
(33, 12, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763252923),
(34, 12, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763252924),
(35, 13, '/store/1/default_images/events/speakers/speaker_1.jpg', NULL, 1, 1, 1763253922),
(36, 13, '/store/1/default_images/events/speakers/speaker_2.jpg', NULL, 2, 1, 1763253923),
(37, 13, '/store/1/default_images/events/speakers/speaker_3.jpg', NULL, 3, 1, 1763253924);

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

--
-- Table structure for table `event_speaker_translations`
--

CREATE TABLE `event_speaker_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event_speaker_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(255) NOT NULL,
  `job` text DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_speaker_translations`
--

INSERT INTO `event_speaker_translations` (`id`, `event_speaker_id`, `locale`, `name`, `job`, `description`) VALUES
(2, 2, 'en', 'Sarah Johnson', 'Senior React Developer', 'Expert React developer with 8+ years of experience in modern web development'),
(3, 3, 'en', 'Michael Chen', 'React Performance Specialist', 'Senior developer specializing in React performance optimization and best practices'),
(4, 4, 'en', 'Emma Wilson', 'Frontend Architect', 'Lead frontend architect with expertise in React ecosystem and modern JavaScript'),
(5, 5, 'en', 'Mike Chen', 'Full-Stack Architect', 'Lead architect specializing in MERN stack and scalable web applications'),
(6, 6, 'en', 'Jessica Rodriguez', 'Backend Developer', 'Senior Node.js developer with expertise in RESTful APIs and database design'),
(7, 7, 'en', 'Daniel Kim', 'DevOps Engineer', 'Infrastructure specialist focusing on deployment and scaling web applications'),
(8, 8, 'en', 'Dr. Emily Davis', 'Data Science Lead', 'PhD in Statistics, expert in machine learning and data analysis'),
(9, 9, 'en', 'Robert Martinez', 'Machine Learning Engineer', 'ML engineer specializing in predictive modeling and data visualization'),
(10, 10, 'en', 'Lisa Zhang', 'Data Analyst', 'Senior data analyst with expertise in Python data science libraries'),
(11, 11, 'en', 'Alex Rivera', 'UX Design Director', 'Award-winning UX designer with experience at top tech companies'),
(12, 12, 'en', 'Sophie Anderson', 'UI Designer', 'Creative UI designer specializing in mobile and web interfaces'),
(13, 13, 'en', 'Marcus Johnson', 'Design Researcher', 'User research specialist focusing on user-centered design methodologies'),
(14, 14, 'en', 'James Wilson', 'Agile Coach', 'Certified Scrum Master with 10+ years in agile project management'),
(15, 15, 'en', 'Rachel Green', 'Product Owner', 'Experienced product owner specializing in agile product development'),
(16, 16, 'en', 'Tom Davis', 'Agile Consultant', 'Agile transformation consultant helping teams adopt agile practices'),
(17, 17, 'en', 'Dr. Lisa Park', 'AI Research Scientist', 'AI researcher specializing in deep learning and computer vision'),
(18, 18, 'en', 'Kevin Liu', 'ML Engineer', 'Machine learning engineer with expertise in neural networks and AI applications'),
(19, 19, 'en', 'Anna Schmidt', 'Data Scientist', 'Data scientist specializing in AI model development and deployment'),
(20, 20, 'en', 'Robert Kim', 'Security Expert', 'Cybersecurity consultant with CISSP certification'),
(21, 21, 'en', 'Maria Santos', 'Ethical Hacker', 'Certified ethical hacker specializing in penetration testing and security audits'),
(22, 22, 'en', 'David Chen', 'Security Architect', 'Enterprise security architect designing secure systems and networks'),
(23, 23, 'en', 'Maria Garcia', 'Mobile Dev Lead', 'Senior mobile developer experienced in iOS and Android'),
(24, 24, 'en', 'Carlos Rodriguez', 'iOS Developer', 'Expert iOS developer with 7+ years of experience in Swift and Objective-C'),
(25, 25, 'en', 'Sarah Kim', 'Android Developer', 'Senior Android developer specializing in Kotlin and Android architecture'),
(26, 26, 'en', 'David Brown', 'Digital Marketing Strategist', 'Digital marketing expert helping startups scale globally'),
(27, 27, 'en', 'Jennifer Liu', 'SEO Specialist', 'SEO expert with proven track record in organic search optimization'),
(28, 28, 'en', 'Mark Thompson', 'Social Media Manager', 'Social media strategist specializing in brand growth and engagement'),
(29, 29, 'en', 'Kevin Zhang', 'Cloud Architect', 'AWS certified solutions architect with enterprise experience'),
(30, 30, 'en', 'Sophie Martin', 'Azure Specialist', 'Microsoft Azure expert specializing in cloud migration and infrastructure'),
(31, 31, 'en', 'Alex Chen', 'Cloud Engineer', 'DevOps engineer focusing on cloud-native applications and microservices'),
(32, 32, 'en', 'Anna Petrov', 'Blockchain Developer', 'Smart contract developer and blockchain consultant'),
(33, 33, 'en', 'Michael Wong', 'Crypto Engineer', 'Blockchain engineer specializing in decentralized applications'),
(34, 34, 'en', 'Elena Ivanova', 'DeFi Specialist', 'Decentralized finance expert with experience in crypto protocols'),
(35, 35, 'en', 'Tom Anderson', 'DevOps Engineer', 'Infrastructure automation expert with Docker and Kubernetes'),
(36, 36, 'en', 'Jessica Park', 'CI/CD Specialist', 'Automation engineer specializing in continuous integration and deployment'),
(37, 37, 'en', 'Ryan Mitchell', 'Site Reliability Engineer', 'SRE expert focusing on system reliability and monitoring');

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

--
-- Table structure for table `event_tickets`
--

CREATE TABLE `event_tickets` (
  `id` int(10) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `capacity` int(10) UNSIGNED DEFAULT NULL,
  `point` int(10) UNSIGNED DEFAULT NULL,
  `discount` int(10) UNSIGNED DEFAULT NULL,
  `discount_start_at` bigint(20) UNSIGNED DEFAULT NULL,
  `discount_end_at` bigint(20) UNSIGNED DEFAULT NULL,
  `order` int(10) UNSIGNED DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_tickets`
--

INSERT INTO `event_tickets` (`id`, `event_id`, `price`, `icon`, `capacity`, `point`, `discount`, `discount_start_at`, `discount_end_at`, `order`, `enable`, `created_at`) VALUES
(38, 2, 90.00, 'bul-star', 15, 15, NULL, NULL, NULL, 1, 1, 1763242851),
(39, 2, 60.00, 'bul-code', 25, 10, NULL, NULL, NULL, 2, 1, 1763242852),
(40, 2, 30.00, 'bul-graduation-cap', 35, 5, NULL, NULL, NULL, 3, 1, 1763242853),
(41, 3, 80.00, 'bul-star', 10, 20, NULL, NULL, NULL, 1, 1, 1763243851),
(42, 3, 40.00, 'bul-laptop', 15, 15, NULL, NULL, NULL, 2, 1, 1763243852),
(43, 3, 25.00, 'bul-graduation-cap', 20, 10, NULL, NULL, NULL, 3, 1, 1763243853),
(44, 4, 195.00, 'bul-star', 12, 18, NULL, NULL, NULL, 1, 1, 1763244851),
(45, 4, 145.00, 'bul-chart-bar', 20, 12, NULL, NULL, NULL, 2, 1, 1763244852),
(46, 4, 95.00, 'bul-graduation-cap', 25, 8, NULL, NULL, NULL, 3, 1, 1763244853),
(47, 5, 195.00, 'bul-star', 14, 12, NULL, NULL, NULL, 1, 1, 1763245851),
(48, 5, 145.00, 'bul-palette', 18, 8, NULL, NULL, NULL, 2, 1, 1763245852),
(49, 5, 95.00, 'bul-graduation-cap', 22, 5, NULL, NULL, NULL, 3, 1, 1763245853),
(50, 6, 80.00, 'bul-star', 8, 10, NULL, NULL, NULL, 1, 1, 1763246851),
(51, 6, 75.00, 'bul-users', 12, 6, NULL, NULL, NULL, 2, 1, 1763246852),
(52, 6, 45.00, 'bul-graduation-cap', 16, 3, NULL, NULL, NULL, 3, 1, 1763246853),
(53, 7, 65.00, 'bul-star', 10, 20, NULL, NULL, NULL, 1, 1, 1763247851),
(54, 7, 35.00, 'bul-brain', 16, 14, NULL, NULL, NULL, 2, 1, 1763247852),
(55, 7, 25.00, 'bul-graduation-cap', 18, 10, NULL, NULL, NULL, 3, 1, 1763247853),
(56, 8, 95.00, 'bul-star', 13, 16, NULL, NULL, NULL, 1, 1, 1763248851),
(57, 8, 45.00, 'bul-shield', 22, 11, NULL, NULL, NULL, 2, 1, 1763248852),
(58, 8, 95.00, 'bul-graduation-cap', 26, 8, NULL, NULL, NULL, 3, 1, 1763248853),
(59, 9, 75.00, 'bul-star', 9, 18, NULL, NULL, NULL, 1, 1, 1763249851),
(60, 9, 45.00, 'bul-mobile', 14, 13, NULL, NULL, NULL, 2, 1, 1763249852),
(61, 9, 25.00, 'bul-graduation-cap', 17, 9, NULL, NULL, NULL, 3, 1, 1763249853),
(62, 10, 70.00, 'bul-star', 16, 14, NULL, NULL, NULL, 1, 1, 1763250851),
(63, 10, 45.00, 'bul-bullhorn', 28, 9, NULL, NULL, NULL, 2, 1, 1763250852),
(64, 10, 20.00, 'bul-graduation-cap', 32, 6, NULL, NULL, NULL, 3, 1, 1763250853),
(65, 11, 100.00, 'bul-star', 11, 17, NULL, NULL, NULL, 1, 1, 1763251851),
(66, 11, 60.00, 'bul-cloud', 19, 12, NULL, NULL, NULL, 2, 1, 1763251852),
(67, 11, 30.00, 'bul-graduation-cap', 23, 8, NULL, NULL, NULL, 3, 1, 1763251853),
(68, 12, 70.00, 'bul-star', 12, 16, NULL, NULL, NULL, 1, 1, 1763252851),
(69, 12, 30.00, 'bul-link', 17, 11, NULL, NULL, NULL, 2, 1, 1763252852),
(70, 12, 15.00, 'bul-graduation-cap', 21, 7, NULL, NULL, NULL, 3, 1, 1763252853),
(71, 13, 80.00, 'bul-star', 14, 15, NULL, NULL, NULL, 1, 1, 1763253851),
(72, 13, 40.00, 'bul-cogs', 21, 10, NULL, NULL, NULL, 2, 1, 1763253852),
(73, 13, 20.00, 'bul-graduation-cap', 25, 6, NULL, NULL, NULL, 3, 1, 1763253853);

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

--
-- Table structure for table `event_tickets_sold`
--

CREATE TABLE `event_tickets_sold` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `sale_id` int(10) UNSIGNED NOT NULL,
  `event_ticket_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `paid_amount` decimal(15,2) NOT NULL,
  `paid_at` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_tickets_sold`
--

INSERT INTO `event_tickets_sold` (`id`, `user_id`, `sale_id`, `event_ticket_id`, `code`, `paid_amount`, `paid_at`) VALUES
(1, 995, 287, 71, 'WVX0U35U', 80.00, 1763591163),
(2, 995, 288, 52, 'OBW9C06P', 45.00, 1763591250),
(3, 995, 288, 52, 'R828QAM5', 45.00, 1763591250),
(4, 996, 290, 46, 'E0DCK4EK', 95.00, 1764055608);

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

--
-- Table structure for table `event_ticket_translations`
--

CREATE TABLE `event_ticket_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event_ticket_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `options` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_ticket_translations`
--

INSERT INTO `event_ticket_translations` (`id`, `event_ticket_id`, `locale`, `title`, `description`, `options`) VALUES
(38, 38, 'en', 'VIP React Masterclass', 'Premium access with direct instructor Q&A and exclusive content', 'Includes: Live Q&A, Private Discord, Certificate, Source Code'),
(39, 39, 'en', 'Standard React Pass', 'Full access to React masterclass with course materials', 'Includes: Course materials, Certificate, Community Access'),
(40, 40, 'en', 'Basic React Access', 'Essential React development training', 'Includes: Video content, Basic Certificate'),
(41, 41, 'en', 'VIP Full-Stack Bootcamp', 'Complete mentorship program with personalized guidance', 'Includes: 1-on-1 Mentorship, Job Placement, Premium Resources'),
(42, 42, 'en', 'Standard Bootcamp Pass', 'Complete full-stack development training', 'Includes: All Modules, Code Reviews, Certificate'),
(43, 43, 'en', 'Basic Bootcamp Access', 'Essential full-stack development skills', 'Includes: Core Modules, Basic Certificate'),
(44, 44, 'en', 'VIP Data Science Masterclass', 'Advanced data science with real-world projects', 'Includes: Premium Datasets, GPU Access, 1-on-1 Support'),
(45, 45, 'en', 'Standard Data Science Pass', 'Complete Python data science training', 'Includes: All Projects, ML Models, Certificate'),
(46, 46, 'en', 'Basic Data Science Access', 'Essential data science fundamentals', 'Includes: Core Concepts, Basic Certificate'),
(47, 47, 'en', 'VIP Design Workshop', 'Complete design mentorship with portfolio review', 'Includes: Portfolio Review, Design Templates, Client Projects'),
(48, 48, 'en', 'Standard Design Pass', 'Complete UI/UX design training', 'Includes: Design Tools, Prototyping, Certificate'),
(49, 49, 'en', 'Basic Design Access', 'Essential design principles', 'Includes: Core Concepts, Basic Certificate'),
(50, 50, 'en', 'VIP Agile Workshop', 'Intensive Scrum Master preparation with certification', 'Includes: Certification Exam, Practice Sessions, Job Support'),
(51, 51, 'en', 'Standard Agile Pass', 'Complete agile project management training', 'Includes: Scrum Framework, Tools, Certificate'),
(52, 52, 'en', 'Basic Agile Access', 'Essential agile methodologies', 'Includes: Core Principles, Basic Certificate'),
(53, 53, 'en', 'VIP AI/ML Masterclass', 'Advanced AI research with cutting-edge projects', 'Includes: Research Access, AI Models, Premium Support'),
(54, 54, 'en', 'Standard AI/ML Pass', 'Complete machine learning and AI training', 'Includes: All Algorithms, Projects, Certificate'),
(55, 55, 'en', 'Basic AI/ML Access', 'Essential AI and ML concepts', 'Includes: Core Algorithms, Basic Certificate'),
(56, 56, 'en', 'VIP Security Workshop', 'Advanced security training with hands-on labs', 'Includes: Penetration Testing, Security Tools, Certification'),
(57, 57, 'en', 'Standard Security Pass', 'Complete cybersecurity training', 'Includes: Security Frameworks, Tools, Certificate'),
(58, 58, 'en', 'Basic Security Access', 'Essential security principles', 'Includes: Core Concepts, Basic Certificate'),
(59, 59, 'en', 'VIP Mobile Development', 'Cross-platform development with app store publishing', 'Includes: App Publishing, Monetization, Premium Support'),
(60, 60, 'en', 'Standard Mobile Pass', 'Complete mobile app development training', 'Includes: iOS & Android, Projects, Certificate'),
(61, 61, 'en', 'Basic Mobile Access', 'Essential mobile development skills', 'Includes: Core Concepts, Basic Certificate'),
(62, 62, 'en', 'VIP Marketing Masterclass', 'Complete marketing strategy with client projects', 'Includes: Client Projects, Analytics Tools, Premium Resources'),
(63, 63, 'en', 'Standard Marketing Pass', 'Complete digital marketing training', 'Includes: All Channels, Tools, Certificate'),
(64, 64, 'en', 'Basic Marketing Access', 'Essential digital marketing skills', 'Includes: Core Strategies, Basic Certificate'),
(65, 65, 'en', 'VIP Cloud Workshop', 'Enterprise cloud architecture with certifications', 'Includes: AWS/Azure Credits, Certifications, Premium Support'),
(66, 66, 'en', 'Standard Cloud Pass', 'Complete cloud computing training', 'Includes: AWS & Azure, Projects, Certificate'),
(67, 67, 'en', 'Basic Cloud Access', 'Essential cloud computing concepts', 'Includes: Core Services, Basic Certificate'),
(68, 68, 'en', 'VIP Blockchain Workshop', 'Advanced DeFi development with real deployments', 'Includes: Test Networks, Crypto Wallets, Premium Support'),
(69, 69, 'en', 'Standard Blockchain Pass', 'Complete blockchain development training', 'Includes: Smart Contracts, DApps, Certificate'),
(70, 70, 'en', 'Basic Blockchain Access', 'Essential blockchain concepts', 'Includes: Core Technology, Basic Certificate'),
(71, 71, 'en', 'VIP DevOps Workshop', 'Enterprise DevOps with infrastructure automation', 'Includes: Server Access, Monitoring Tools, Premium Support'),
(72, 72, 'en', 'Standard DevOps Pass', 'Complete DevOps and CI/CD training', 'Includes: Docker/K8s, Pipelines, Certificate'),
(73, 73, 'en', 'Basic DevOps Access', 'Essential DevOps practices', 'Includes: Core Automation, Basic Certificate');

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

--
-- Table structure for table `event_translations`
--

CREATE TABLE `event_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event_id` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text DEFAULT NULL,
  `seo_description` text DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `description` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_translations`
--

INSERT INTO `event_translations` (`id`, `event_id`, `locale`, `title`, `subtitle`, `seo_description`, `summary`, `description`) VALUES
(2, 2, 'en', 'Mastering React Development for Dynamic Web Applications', 'Advanced React & Modern JavaScript', 'Learn React from basics to advanced concepts including hooks, context, and performance optimization', 'Learn to build responsive, high-performance web applications using React. Explore components, state management, hooks, routing, and API integration, while applying best practices to create scalable and maintainable front-end projects.', '<p>Mastering React Development is an intensive, instructor-led program crafted to take experienced JavaScript developers to the next level. You will gain mastery of hooks, Context API, and advanced state management patterns, while learning component architecture techniques used in large-scale production systems. The curriculum emphasizes performance profiling, rendering optimization, and measurable strategies to reduce bundle size and improve UX. Hands-on labs and a guided capstone let you apply best practices for testing, TypeScript integration, and server-side rendering. By course end you will be able to design maintainable component systems, optimize app performance, and deliver production-ready React applications with confidence.</p>'),
(3, 3, 'en', 'Full-Stack Web Development Bootcamp for Beginners and Professionals', 'Complete MERN Stack Mastery', 'Become a full-stack developer with Node.js, React, MongoDB, and Express', 'Master front-end and back-end web development in this intensive bootcamp. Learn HTML, CSS, JavaScript, frameworks, databases, and server-side programming to build fully functional, responsive, and dynamic web applications from scratch.', '<p>This Full-Stack Web Development Bootcamp is a career-focused, project-driven program that teaches you to build, ship, and scale modern web applications. You will learn frontend engineering with React and state management, backend API design with Node.js and Express, and robust data modeling with MongoDB. The course covers authentication, authorization, security best practices, testing, and deployment pipelines so your projects are production-ready. Mentored code reviews, pair programming, and a professional capstone project ensure you graduate with a deployable portfolio and concrete interview-ready experience.</p>'),
(4, 4, 'en', 'Python Data Science Masterclass for Practical Insights', 'Data Analysis & Machine Learning', 'Master Python for data science, pandas, numpy, and machine learning algorithms', 'Master Python for data science, including data manipulation, analysis, and visualization. Learn libraries like Pandas, NumPy, and Matplotlib, apply statistical methods, and build predictive models for real-world data-driven decision-making.', '<p>The Python Data Science Masterclass provides a structured path from data wrangling to deploying machine learning models in production. Through realistic datasets you will master pandas, NumPy, visualization, feature engineering, and statistical reasoning that underpin reliable models. The course introduces supervised and unsupervised methods, model evaluation, and modern tooling such as scikit-learn and TensorFlow/PyTorch, with an emphasis on reproducibility and experiment tracking. Practical modules cover model deployment, monitoring, and interpretability so your solutions deliver business impact. A final capstone demonstrates an end-to-end data science workflow suitable for inclusion in a professional portfolio.</p>'),
(5, 5, 'en', 'UI/UX Design Fundamentals for Engaging Digital Experiences', 'User-Centered Design Principles', 'Learn design thinking, user research, prototyping, and modern design tools', 'Understand core UI/UX principles, from user research and personas to wireframes, visual hierarchy, and usability testing. Learn to design intuitive, accessible, and visually appealing interfaces that delight users and support business goals.', '<p>UI/UX Design Fundamentals is a hands-on course that teaches the full product design lifecycle from research to high-fidelity delivery. You will learn to conduct user research, synthesize insights, and translate findings into wireframes, prototypes, and accessible interfaces using industry tools like Figma. The curriculum covers visual design, interaction design, design systems, and usability testing to ensure your solutions are both beautiful and effective. Real-world projects, portfolio coaching, and professional feedback prepare you to present compelling case studies to employers or clients.</p>'),
(6, 6, 'en', 'Agile Project Management Workshop for High-Performing Teams', 'Scrum & Agile Methodologies', 'Learn agile principles, scrum framework, and effective project management techniques', 'Gain hands-on experience applying Agile principles, Scrum, and Kanban. Learn to prioritize backlogs, run effective sprints, remove blockers, and continuously improve delivery while aligning stakeholders, teams, and business value.', '<p>This Agile Project Management Workshop teaches practical Scrum and Agile techniques that teams use to deliver predictable value. Through simulations and case studies you will practice sprint planning, backlog refinement, effective stand-ups, and constructive retrospectives. The course covers role responsibilities, estimation, metrics that matter, and approaches to scale Agile across multiple teams. Participants receive templates, conflict-resolution strategies, and actionable tools to improve delivery cadence and stakeholder collaboration.</p>'),
(7, 7, 'en', 'Machine Learning and AI Essentials for Beginners', 'AI & ML Fundamentals', 'Understanding machine learning algorithms, neural networks, and AI applications', 'Explore the fundamentals of machine learning and artificial intelligence. Learn algorithms, data preprocessing, model training, evaluation, and real-world applications to build intelligent systems that analyze data and support informed decision-making.', '<p>Machine Learning & AI Essentials is a pragmatic program focused on building and evaluating models that solve real problems. You will learn core algorithms, neural network architectures, and feature engineering techniques, alongside practical model evaluation and validation strategies. Hands-on labs guide you through implementation with TensorFlow or PyTorch, and modules cover deployment considerations, model monitoring, and ethical AI practices. The course culminates in an applied capstone that demonstrates your ability to deliver a complete ML solution.</p>'),
(8, 8, 'en', 'Practical Cybersecurity Best Practices for Modern Organizations', 'Information Security Fundamentals', 'Learn cybersecurity principles, threat analysis, and security implementation', 'Explore essential cybersecurity best practices to protect data, systems, and users. Learn about strong authentication, secure configurations, employee awareness, threat detection, incident response, and ongoing risk assessment to strengthen your organization’s defenses.', '<p>Cybersecurity Best Practices equips developers and IT professionals with pragmatic skills to design, assess, and defend modern applications and infrastructure. You will learn threat modeling, secure coding practices, OWASP Top 10 mitigations, and basic penetration testing techniques in a controlled lab environment. The course covers monitoring, incident response, logging, and compliance considerations to help you operationalize security. Practical exercises and remediation guidance prepare you to reduce risk and communicate security improvements effectively to stakeholders.</p>'),
(9, 9, 'en', 'Modern Mobile App Development for Android and iOS', 'iOS & Android Development', 'Build native mobile apps for iOS and Android platforms', 'Learn core principles of mobile app development, from UI/UX design and architecture to APIs, testing, and deployment. Build performant, secure, and scalable apps using modern frameworks, tools, and best coding practices.', '<p>Mobile App Development is a comprehensive program that covers native and cross-platform approaches to building production-grade mobile applications. You will gain practical experience with UI patterns, navigation, state management, and performance optimization using Swift, Kotlin, React Native, and Flutter. The course includes testing strategies, CI/CD for mobile, and app store publishing best practices to prepare your app for real users. By the end you will have a polished, deployable mobile app suitable for your professional portfolio.</p>'),
(10, 10, 'en', 'Digital Marketing Mastery for High-Impact Growth', 'Online Marketing Strategies', 'Master digital marketing channels, SEO, social media, and conversion optimization', 'Learn to plan and execute powerful digital marketing campaigns across social media, search, email, and content. Master analytics, targeting, funnels, and conversion tactics to attract, engage, and retain loyal customers.', '<p>Digital Marketing Mastery teaches data-driven marketing strategies that grow traffic, conversions, and customer lifetime value. You will learn SEO, paid acquisition, content strategy, email marketing, and analytics to create measurable campaigns. Practical workshops cover funnel optimization, A/B testing, audience segmentation, and reporting so you can demonstrate clear ROI. The final project requires you to plan, launch, and analyze a campaign with actionable recommendations for continuous improvement.</p>'),
(11, 11, 'en', 'Cloud Computing Fundamentals for Modern IT Professionals', 'AWS & Azure Cloud Services', 'Master cloud computing with AWS and Azure platforms', 'Learn the basics of cloud computing, including service models, deployment types, scalability, security, and cost optimization. Understand cloud architecture, providers, and best practices to efficiently manage and deploy applications in the cloud.', '<p>Cloud Computing Fundamentals provides a practical introduction to cloud architecture, core services, and operational best practices across major providers. You will work with compute, storage, networking, and managed services while learning Infrastructure as Code, automation, and cost optimization techniques. Modules include container orchestration, serverless patterns, CI/CD pipelines, and observability to build resilient systems. Hands-on labs and a capstone architecture prepare you to design and deploy real-world cloud solutions.</p>'),
(12, 12, 'en', 'Blockchain and Crypto Development for Applications', 'Decentralized Applications', 'Learn blockchain technology, smart contracts, and cryptocurrency development', 'Explore blockchain technology, smart contracts, and cryptocurrency development. Learn decentralized application architecture, token creation, security considerations, and real-world use cases to build secure, scalable, and innovative blockchain-powered solutions.', '<p>Blockchain & Crypto Development teaches how to design, implement, and secure decentralized applications and smart contracts. You will learn Solidity, contract testing, common vulnerability patterns, and token standards, coupled with frontend integration and deployment to testnets. The course emphasizes secure development practices, developer tooling, and practical DeFi and NFT examples to ground concepts in real use cases. A final capstone demonstrates a full-stack DApp with deployment, audits, and production-readiness considerations.</p>'),
(13, 13, 'en', 'DevOps and CI/CD Automation for Modern Teams', 'Modern Software Delivery', 'Learn DevOps practices, CI/CD pipelines, and infrastructure automation', 'Discover how integrated DevOps practices and CI/CD automation streamline software delivery, reduce errors, enhance collaboration, and accelerate releases. Learn tools, workflows, and best practices to build resilient, scalable, and continuously improving systems.', '<p>DevOps & CI/CD Automation is a hands-on program focused on automating the software delivery lifecycle for reliability and speed. You will master containerization, orchestration, and pipeline automation using Docker, Kubernetes, Terraform, and popular CI tools. The curriculum covers testing, deployment strategies, rollback mechanisms, monitoring, and incident response to build resilient systems. Practical labs culminate in an end-to-end pipeline that demonstrates continuous integration, delivery, and infrastructure automation for a real application.</p>');

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

--
