-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 20, 2024 at 08:38 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `ayurgreen` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin@mail.com', '2024-02-28 14:38:47', '$2y$12$dby4bK08Aw6tcHdnTNRPLu.rhkDOqEhmVuZLNKFV/NOG9RzKspUT6', NULL, '2024-02-28 14:38:47', '2024-02-28 14:38:47'); -- -------------------------------------------------------- -- -- Table structure for table `carts` -- CREATE TABLE `carts` ( `id` bigint(20) UNSIGNED NOT NULL, `cookie_id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `client_id` varchar(10) DEFAULT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `quantity` tinyint(4) NOT NULL, `type` varchar(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `carts` -- INSERT INTO `carts` (`id`, `cookie_id`, `user_id`, `client_id`, `product_id`, `quantity`, `type`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '1709227329XqtSQjZgYH', 3, NULL, 1, 10, NULL, '2024-02-29 17:22:09', '2024-02-29 17:22:17', NULL), (2, '1709227329XqtSQjZgYH', 3, NULL, 2, 10, NULL, '2024-02-29 17:22:12', '2024-02-29 17:22:23', NULL), (3, '1709227393GrZB3mRhPF', 3, NULL, 1, 20, NULL, '2024-02-29 17:23:13', '2024-02-29 17:23:23', NULL), (4, '1709227393GrZB3mRhPF', 3, NULL, 2, 20, NULL, '2024-02-29 17:23:15', '2024-02-29 17:23:28', NULL), (5, '1709227393GrZB3mRhPF', 3, NULL, 3, 20, NULL, '2024-02-29 17:23:16', '2024-02-29 17:23:31', NULL), (6, '1709227393GrZB3mRhPF', 3, NULL, 4, 20, NULL, '2024-02-29 17:23:18', '2024-02-29 17:23:33', NULL), (7, '1709227666HbhcrlVT8txty0fNHRlp', NULL, '18', 1, 1, NULL, '2024-02-29 17:27:46', '2024-02-29 17:27:46', NULL), (8, '1709544449TJRXtaoayIeQnR8ZIa3l', NULL, '19', 1, 1, NULL, '2024-03-04 09:27:29', '2024-03-04 09:27:29', NULL), (9, '1709545370IUmdpwk8xUdPyFbn6oPf', NULL, '20', 1, 1, NULL, '2024-03-04 09:42:50', '2024-03-04 09:42:50', NULL), (10, '1709733280x0sI3PNdGJM6oGLN7z7D', NULL, '21', 2, 1, NULL, '2024-03-06 13:54:40', '2024-03-06 13:54:40', NULL), (11, '1709733693y6ve4lxOoD', 3, NULL, 1, 1, 'product', '2024-03-06 14:01:33', '2024-03-06 14:01:33', NULL), (12, '1709740650aMPSSFwqJ0', 3, NULL, 1, 1, 'product', '2024-03-06 15:57:30', '2024-03-06 15:57:30', NULL), (13, '1709740935mOYJB5U73tblr0Ak6gG9', NULL, '22', 2, 1, NULL, '2024-03-06 16:02:15', '2024-03-06 16:02:15', NULL), (14, '1709743460Qv9Cw9aG8v', 3, NULL, 3, 100, NULL, '2024-03-06 16:44:20', '2024-03-06 16:44:26', NULL), (15, '1709743460Qv9Cw9aG8v', 3, NULL, 2, 10, NULL, '2024-03-06 16:44:37', '2024-03-06 16:44:49', NULL), (16, '1709743584KMVeQOzh92', 3, NULL, 1, 10, NULL, '2024-03-06 16:46:24', '2024-03-06 16:47:01', NULL), (17, '1709743584KMVeQOzh92', 3, NULL, 2, 10, NULL, '2024-03-06 16:46:28', '2024-03-06 16:47:00', NULL), (18, '1709743584KMVeQOzh92', 3, NULL, 3, 10, NULL, '2024-03-06 16:46:32', '2024-03-06 16:46:59', NULL), (19, '1709743584KMVeQOzh92', 3, NULL, 4, 10, NULL, '2024-03-06 16:46:33', '2024-03-06 16:46:55', NULL), (20, '1709743584KMVeQOzh92', 3, NULL, 5, 100, NULL, '2024-03-06 16:46:40', '2024-03-06 16:46:52', NULL), (21, '1709743789XIzaSjb8bB', 3, NULL, 4, 1, 'product', '2024-03-06 16:49:49', '2024-03-06 16:49:49', NULL), (22, '1710959840fDxc7UtGYd', 3, NULL, 2, 1, 'product', '2024-03-20 18:37:20', '2024-03-20 18:37:20', NULL), (23, '1710960029oShluNvplf', 3, NULL, 3, 1, 'product', '2024-03-20 18:40:29', '2024-03-20 18:40:29', NULL), (24, '1710960029oShluNvplf', 3, NULL, 2, 1, 'package', '2024-03-20 18:40:33', '2024-03-20 18:40:33', NULL), (25, '1710960029oShluNvplf', 3, NULL, 3, 1, 'package', '2024-03-20 18:40:36', '2024-03-20 18:40:36', NULL); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `category_name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `category_name`, `slug`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Home Appliance', 'home-appliance-18', 'home-appliance-18.png', '2024-02-28 15:02:26', '2024-02-28 15:02:26', NULL), (2, 'Fashion House', 'fashion-house-300', 'fashion-house-300.png', '2024-02-28 15:02:36', '2024-02-28 15:02:36', NULL), (3, 'Medical Equipment', 'medical-equipment-385', 'medical-equipment-385.png', '2024-02-28 15:03:05', '2024-02-28 15:03:05', NULL); -- -------------------------------------------------------- -- -- Table structure for table `checkouts` -- CREATE TABLE `checkouts` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `club_bonus_details` -- CREATE TABLE `club_bonus_details` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `club_bonus_details` -- INSERT INTO `club_bonus_details` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Development Bonus', '2023-12-29 21:39:35', '2023-12-29 21:39:35', NULL), (2, 'Car Fund Details', '2023-12-29 21:40:29', '2023-12-29 21:40:29', NULL), (3, 'House Fund Bonus', '2023-12-29 21:42:54', '2023-12-29 21:42:54', NULL); -- -------------------------------------------------------- -- -- Table structure for table `club_bonus_details_assets` -- CREATE TABLE `club_bonus_details_assets` ( `id` bigint(20) UNSIGNED NOT NULL, `club_id` bigint(20) UNSIGNED DEFAULT NULL, `rank_id` bigint(20) UNSIGNED DEFAULT NULL, `bonus` decimal(20,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `club_bonus_details_assets` -- INSERT INTO `club_bonus_details_assets` (`id`, `club_id`, `rank_id`, `bonus`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 7, 1.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (2, 1, 8, 1.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (3, 1, 9, 2.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (4, 1, 10, 2.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (5, 1, 11, 2.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (6, 1, 12, 2.00, '2023-12-29 21:39:35', '2024-03-08 17:17:40', NULL), (7, 2, 8, 1.00, '2023-12-29 21:40:29', '2024-03-08 17:18:44', NULL), (8, 2, 9, 1.00, '2023-12-29 21:40:29', '2024-03-08 17:18:44', NULL), (9, 2, 10, 1.00, '2023-12-29 21:40:29', '2024-03-08 17:18:44', NULL), (10, 2, 11, 1.00, '2023-12-29 21:40:29', '2024-03-08 17:18:44', NULL), (11, 2, 12, 1.00, '2023-12-29 21:40:29', '2024-03-08 17:18:44', NULL), (12, 3, 10, 1.00, '2023-12-29 21:42:54', '2024-03-08 17:19:07', NULL), (13, 3, 11, 1.00, '2023-12-29 21:42:54', '2024-03-08 17:19:18', NULL), (14, 3, 12, 1.00, '2023-12-29 21:42:54', '2024-03-08 17:19:07', NULL); -- -------------------------------------------------------- -- -- Table structure for table `comapany_infos` -- CREATE TABLE `comapany_infos` ( `id` bigint(20) UNSIGNED NOT NULL, `system_name` varchar(255) DEFAULT NULL, `website_logo` varchar(255) DEFAULT NULL, `user_logo` varchar(255) DEFAULT NULL, `admin_logo` varchar(255) DEFAULT NULL, `favicon` varchar(255) DEFAULT NULL, `timezone` varchar(255) DEFAULT NULL, `company_name` varchar(255) DEFAULT NULL, `site_mettro` varchar(255) DEFAULT NULL, `meta_title` varchar(255) DEFAULT NULL, `meta_des` varchar(255) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_image` varchar(255) DEFAULT NULL, `min_withdraw` decimal(20,2) DEFAULT NULL, `max_withdraw` decimal(20,2) DEFAULT NULL, `min_deposit` decimal(20,2) DEFAULT NULL, `max_deposit` decimal(20,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `comapany_infos` -- INSERT INTO `comapany_infos` (`id`, `system_name`, `website_logo`, `user_logo`, `admin_logo`, `favicon`, `timezone`, `company_name`, `site_mettro`, `meta_title`, `meta_des`, `meta_keywords`, `meta_image`, `min_withdraw`, `max_withdraw`, `min_deposit`, `max_deposit`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Ayur Green', 'ayur-green-website-logo-30.png', 'ayur-green-user-logo-50.jpg', 'ayur-green-admin-logo-40.jpg', 'ayur-green-favicon-185.png', 'Asia/Dhaka', 'Test Company Name', 'Test Company Name', 'Test Company Name', 'Test Company Name', 'Test Company Name', 'ayur-grean-website-logo-412.gif', NULL, NULL, NULL, NULL, '2024-02-28 14:38:47', '2024-02-28 14:42:57', NULL); -- -------------------------------------------------------- -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `currency_name` varchar(255) DEFAULT NULL, `currency_symbol` varchar(255) DEFAULT NULL, `timezone` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `name`, `currency_name`, `currency_symbol`, `timezone`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Malaysia', 'MYR', 'RM‎', 'Asia/Kuala_Lumpur', '2024-01-24 16:09:31', '2024-01-24 16:14:25', NULL), (2, 'United Arab Emirates', 'AED', 'د.إ', 'Asia/Muscat', '2024-01-24 16:13:40', '2024-01-24 16:13:40', NULL), (3, 'Saudi Arabia', 'SAR', 'SR', 'Asia/Kuwait', '2024-01-24 16:16:44', '2024-01-24 16:16:44', NULL); -- -------------------------------------------------------- -- -- Table structure for table `cron_logs` -- CREATE TABLE `cron_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `time` varchar(255) NOT NULL, `des` text DEFAULT NULL, `type` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cron_logs` -- INSERT INTO `cron_logs` (`id`, `time`, `des`, `type`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '1710676324', 'Give User Rank', '1', '2024-03-16 19:06:25', '2024-03-16 19:06:25', NULL), (2, '1709743491', 'Distribute Club Bonus', '3', '2024-03-16 19:17:21', '2024-03-16 19:17:21', NULL), (3, '1709743491', 'Distribute User Rank Commissions', '2', '2024-03-16 19:17:46', '2024-03-16 19:17:46', NULL), (4, '1710699718', 'Give User Rank', '1', '2024-03-17 18:21:58', '2024-03-17 18:21:58', NULL); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `generations` -- CREATE TABLE `generations` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(200) NOT NULL, `serial` int(11) NOT NULL, `comission` decimal(8,2) NOT NULL, `status` tinyint(4) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `generations` -- INSERT INTO `generations` (`id`, `name`, `serial`, `comission`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Lavel-1', 1, 2.00, 1, '2023-12-29 12:57:43', '2024-01-14 18:46:51', NULL), (2, 'Lavel-2', 2, 2.00, 1, '2024-01-14 18:47:20', '2024-01-14 18:47:20', NULL), (3, 'Lavel-3', 3, 2.00, 1, '2024-01-14 18:47:37', '2024-01-14 18:47:37', NULL), (4, 'Lavel-4', 4, 2.00, 1, '2024-01-14 18:47:49', '2024-01-14 18:47:49', NULL), (5, 'Lavel-5', 5, 2.00, 1, '2024-01-14 18:48:02', '2024-01-14 18:48:02', NULL), (6, 'Lavel-6', 6, 2.00, 1, '2024-01-14 18:48:22', '2024-01-14 18:48:22', NULL), (7, 'Lavel-7', 7, 3.00, 1, '2024-01-14 18:48:33', '2024-01-14 18:48:33', NULL); -- -------------------------------------------------------- -- -- Table structure for table `invoices` -- CREATE TABLE `invoices` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `agent_id` varchar(60) DEFAULT NULL, `refer_id` varchar(60) DEFAULT NULL, `total_point` decimal(20,2) DEFAULT NULL, `sub_total` decimal(20,2) DEFAULT NULL, `bill_amount` decimal(20,2) DEFAULT NULL, `type` tinyint(4) NOT NULL DEFAULT 1, `status` tinyint(4) NOT NULL DEFAULT 2, `order_status` tinyint(4) NOT NULL DEFAULT 1, `commission_status` tinyint(4) NOT NULL DEFAULT 0, `cookie_id` varchar(255) DEFAULT NULL, `date` varchar(60) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `invoices` -- INSERT INTO `invoices` (`id`, `user_id`, `agent_id`, `refer_id`, `total_point`, `sub_total`, `bill_amount`, `type`, `status`, `order_status`, `commission_status`, `cookie_id`, `date`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 3, NULL, NULL, 13000.00, 172500.00, 172500.00, 3, 1, 4, 0, '1709743460Qv9Cw9aG8v', '1709743491', '2024-03-06 16:44:51', '2024-03-06 16:45:33', NULL), (2, 3, NULL, NULL, 28500.00, 604500.00, 604500.00, 2, 1, 4, 0, '1709743584KMVeQOzh92', '1709743621', '2024-03-06 16:47:01', '2024-03-06 16:47:24', NULL), (3, 22, 'agent2', 'AYUR4172418', 100.00, 2000.00, 2000.00, 5, 1, 4, 1, '1709743789XIzaSjb8bB', '1709743820', '2024-03-06 16:50:20', '2024-03-16 19:17:46', NULL), (4, 4, 'agent2', 'user', 2000.00, 3000.00, 3000.00, 5, 1, 4, 0, '1710959840fDxc7UtGYd', '1710959846', '2024-03-20 18:37:26', '2024-03-20 18:38:38', NULL), (5, 5, 'agent2', 'AYUR000001', 800.00, 65225.00, 65225.00, 5, 1, 4, 0, '1710960029oShluNvplf', '1710960041', '2024-03-20 18:40:41', '2024-03-20 18:40:58', NULL); -- -------------------------------------------------------- -- -- Table structure for table `invoice_items` -- CREATE TABLE `invoice_items` ( `id` bigint(20) UNSIGNED NOT NULL, `invoice_id` bigint(20) UNSIGNED NOT NULL, `product_id` int(11) DEFAULT NULL, `package_id` varchar(10) DEFAULT NULL, `point` decimal(20,2) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `price` decimal(20,2) DEFAULT NULL, `offer_price` decimal(20,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `invoice_items` -- INSERT INTO `invoice_items` (`id`, `invoice_id`, `product_id`, `package_id`, `point`, `qty`, `price`, `offer_price`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, NULL, '3', 100.00, 100, 225.00, 0.00, '2024-03-06 16:44:51', '2024-03-06 16:44:51', NULL), (2, 1, NULL, '2', 300.00, 10, 15000.00, 0.00, '2024-03-06 16:44:51', '2024-03-06 16:44:51', NULL), (3, 2, 1, NULL, 150.00, 10, 5000.00, 0.00, '2024-03-06 16:47:01', '2024-03-06 16:47:01', NULL), (4, 2, 2, NULL, 2000.00, 10, 3000.00, 0.00, '2024-03-06 16:47:01', '2024-03-06 16:47:01', NULL), (5, 2, 3, NULL, 400.00, 10, 50000.00, 0.00, '2024-03-06 16:47:01', '2024-03-06 16:47:01', NULL), (6, 2, 4, NULL, 100.00, 10, 3000.00, 2000.00, '2024-03-06 16:47:01', '2024-03-06 16:47:01', NULL), (7, 2, 5, NULL, 20.00, 100, 45.00, 0.00, '2024-03-06 16:47:01', '2024-03-06 16:47:01', NULL), (8, 3, 4, NULL, 100.00, 1, 3000.00, 2000.00, '2024-03-06 16:50:20', '2024-03-06 16:50:20', NULL), (9, 4, 2, NULL, 2000.00, 1, 3000.00, 0.00, '2024-03-20 18:37:26', '2024-03-20 18:37:26', NULL), (10, 5, 3, NULL, 400.00, 1, 50000.00, 0.00, '2024-03-20 18:40:41', '2024-03-20 18:40:41', NULL), (11, 5, NULL, '2', 300.00, 1, 15000.00, 0.00, '2024-03-20 18:40:41', '2024-03-20 18:40:41', NULL), (12, 5, NULL, '3', 100.00, 1, 225.00, 0.00, '2024-03-20 18:40:41', '2024-03-20 18:40:41', NULL); -- -------------------------------------------------------- -- -- Table structure for table `leaderships` -- CREATE TABLE `leaderships` ( `id` bigint(20) UNSIGNED NOT NULL, `rank_id` bigint(20) UNSIGNED NOT NULL, `lavel_1` decimal(20,2) DEFAULT 0.00, `lavel_2` decimal(20,2) DEFAULT 0.00, `lavel_3` decimal(20,2) DEFAULT 0.00, `lavel_4` decimal(20,2) DEFAULT 0.00, `lavel_5` decimal(20,2) DEFAULT 0.00, `lavel_6` decimal(20,2) DEFAULT 0.00, `lavel_7` decimal(20,2) DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_reset_tokens_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_12_18_083637_create_admins_table', 1), (6, '2023_12_19_090653_create_comapany_infos_table', 1), (7, '2023_12_20_091649_create_categories_table', 1), (8, '2023_12_20_123853_create_sub_categories_table', 1), (9, '2023_12_21_034244_create_products_table', 1), (10, '2023_12_21_043419_create_product_featured_images_table', 1), (11, '2023_12_21_045114_create_product_exta_infos_table', 1), (12, '2023_12_23_094659_create_carts_table', 1), (13, '2023_12_24_073614_create_checkouts_table', 1), (14, '2023_12_25_091015_create_ranks_table', 1), (15, '2023_12_25_103610_create_leaderships_table', 1), (16, '2023_12_25_130127_create_generations_table', 1), (17, '2023_12_26_090949_create_club_bonus_details_table', 1), (18, '2023_12_26_090955_create_club_bonus_details_assets_table', 1), (19, '2023_12_30_071556_create_page_banners_table', 1), (20, '2023_12_30_113100_create_transactions_table', 1), (21, '2024_01_01_160334_create_invoices_table', 1), (22, '2024_01_01_160351_create_invoice_items_table', 1), (23, '2024_01_02_185637_add_invoice_id_for_transection_table', 1), (24, '2024_01_03_113529_add_user_id_for_carts_table', 1), (25, '2024_01_03_122749_add_point_for_transection_table', 1), (26, '2024_01_03_125035_add_type_for_invoice_table', 1), (27, '2024_01_04_151952_add_image_for_user_table', 1), (28, '2024_01_07_223017_create_rank2s_table', 1), (29, '2024_01_11_100251_add_commission_status_for_invoice_table', 1), (30, '2024_01_21_101209_create_countries_table', 1), (31, '2024_01_21_101218_create_states_table', 1), (32, '2024_01_21_104442_add_rank_id_for_ranks2_table', 1), (33, '2024_01_22_132531_add_new_field_for_users_table', 1), (34, '2024_01_23_122458_create_packages_table', 1), (35, '2024_01_24_111011_add_column_to_country_table', 1), (36, '2024_01_24_112448_add_column_to_packages_table', 1), (37, '2024_01_27_151327_add_client_id_for_add_to_cart_table', 1), (38, '2024_01_27_180159_package_id_for_invoice_item_table', 1), (39, '2024_01_31_184526_add_type_for_cart_table', 1), (40, '2024_02_02_110431_add_deposit_config_for_company_info_table', 1), (41, '2024_02_15_131057_change_max_min_deposit_limit_data_type_rang', 1), (42, '2024_03_10_112014_add_club_bonus_data_field_for_transection_table', 2), (43, '2024_03_17_004850_create_cron_logs_table', 3), (44, '2024_03_17_013826_add_monthly_personal_ap_for_ranks2_table', 4), (45, '2024_03_20_144520_create_royel_club_achievers_table', 5); -- -------------------------------------------------------- -- -- Table structure for table `packages` -- CREATE TABLE `packages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `price` decimal(15,2) DEFAULT NULL, `description` longtext DEFAULT NULL, `status` int(11) DEFAULT NULL, `stock_status` int(11) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `point` decimal(15,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `packages` -- INSERT INTO `packages` (`id`, `name`, `price`, `description`, `status`, `stock_status`, `image`, `point`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Startup Package', 10000.00, '

dfgdgfdg

', 0, 0, 'startup-package-293.png', 250.00, '2024-02-28 15:05:40', '2024-02-28 15:05:40', NULL), (2, 'Startup Package Two', 15000.00, '

dfgdf

', 0, 0, 'startup-package-two-190.png', 300.00, '2024-02-28 15:06:30', '2024-02-28 15:06:30', NULL), (3, 'Wellness Package', 225.00, '

Wellness Package contains 3 best dietary supplements

', 0, 0, 'wellness-package-260.jpg', 100.00, '2024-03-04 10:33:08', '2024-03-04 10:33:08', NULL), (4, 'Detoxification Package', 215.00, '

Detoxification Package contains 3 Products

', 0, 0, 'detoxification-package-390.jpg', 100.00, '2024-03-04 10:51:54', '2024-03-04 10:51:54', NULL); -- -------------------------------------------------------- -- -- Table structure for table `page_banners` -- CREATE TABLE `page_banners` ( `id` bigint(20) UNSIGNED NOT NULL, `img` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `type` tinyint(4) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `subcategory_id` bigint(20) UNSIGNED DEFAULT NULL, `title` varchar(255) NOT NULL, `sub_title` varchar(255) DEFAULT NULL, `slug` varchar(255) NOT NULL, `thumbnail` varchar(255) DEFAULT NULL, `point` decimal(8,2) DEFAULT 0.00, `price` decimal(8,2) DEFAULT 0.00, `offer_price` decimal(8,2) DEFAULT 0.00, `description` longtext DEFAULT NULL, `policy` tinyint(4) NOT NULL DEFAULT 1, `terms` tinyint(4) NOT NULL DEFAULT 1, `status` tinyint(4) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `category_id`, `subcategory_id`, `title`, `sub_title`, `slug`, `thumbnail`, `point`, `price`, `offer_price`, `description`, `policy`, `terms`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 2, 'Home Appliance Combo', 'Home Appliance Combo', 'home-appliance-combo-251', 'home-appliance-combo-251.png', 150.00, 5000.00, 0.00, '

sdfsdf

', 0, 0, 0, '2024-02-28 15:08:33', '2024-02-28 15:08:33', NULL), (2, 1, 1, 'Rice Cooker', 'Rice Cooker', 'rice-cooker-323', 'rice-cooker-323.png', 2000.00, 3000.00, 0.00, '

sdfsdf

', 1, 1, 0, '2024-02-28 15:09:56', '2024-02-28 15:09:56', NULL), (3, 3, 3, 'Digital ECG', 'Digital ECG', 'digital-ecg-487', 'digital-ecg-487.png', 400.00, 50000.00, 0.00, '

sdfsdf

', 1, 1, 0, '2024-02-28 15:11:31', '2024-02-28 15:11:31', NULL), (4, 2, 4, 'Tesfdf sdfsdf', 'Tesfdf sdfsdf', 'tesfdf-sdfsdf-227', 'tesfdf-sdfsdf-227.png', 100.00, 3000.00, 2000.00, '

sdfsa

', 1, 1, 0, '2024-02-28 15:12:43', '2024-02-28 15:12:43', NULL), (5, 3, NULL, 'Tulshi Juice Powder', 'Natural Tulshi Juice', 'tulshi-juice-powder-14', 'tulshi-juice-powder-14.png', 20.00, 45.00, 0.00, '

Tulshi Juice Powder
100gms

', 1, 1, 0, '2024-03-04 11:23:41', '2024-03-04 11:23:41', NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_exta_infos` -- CREATE TABLE `product_exta_infos` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `info_title` varchar(255) DEFAULT NULL, `info_details` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_exta_infos` -- INSERT INTO `product_exta_infos` (`id`, `product_id`, `info_title`, `info_details`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'sdfsd', 'sdfs', '2024-02-28 15:08:33', '2024-02-28 15:08:33', NULL), (2, 2, 'sdfsd', 'sdfsd', '2024-02-28 15:09:57', '2024-02-28 15:09:57', NULL), (3, 3, 'sdfsd', 'sdfsd', '2024-02-28 15:11:31', '2024-02-28 15:11:31', NULL); -- -------------------------------------------------------- -- -- Table structure for table `product_featured_images` -- CREATE TABLE `product_featured_images` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_featured_images` -- INSERT INTO `product_featured_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'home-appliance-combo-251-featured-image-product-id-889-1.png', '2024-02-28 15:08:33', '2024-02-28 15:08:33', NULL), (2, 2, 'rice-cooker-323-featured-image-product-id-841-2.png', '2024-02-28 15:09:56', '2024-02-28 15:09:56', NULL), (3, 2, 'rice-cooker-323-featured-image-product-id-517-2.png', '2024-02-28 15:09:57', '2024-02-28 15:09:57', NULL), (4, 3, 'digital-ecg-487-featured-image-product-id-209-3.png', '2024-02-28 15:11:31', '2024-02-28 15:11:31', NULL), (5, 3, 'digital-ecg-487-featured-image-product-id-527-3.png', '2024-02-28 15:11:31', '2024-02-28 15:11:31', NULL), (6, 3, 'digital-ecg-487-featured-image-product-id-345-3.png', '2024-02-28 15:11:31', '2024-02-28 15:11:31', NULL), (7, 4, 'tesfdf-sdfsdf-227-featured-image-product-id-272-4.png', '2024-02-28 15:12:43', '2024-02-28 15:12:43', NULL), (8, 4, 'tesfdf-sdfsdf-227-featured-image-product-id-638-4.png', '2024-02-28 15:12:44', '2024-02-28 15:12:44', NULL); -- -------------------------------------------------------- -- -- Table structure for table `rank2s` -- CREATE TABLE `rank2s` ( `id` bigint(20) UNSIGNED NOT NULL, `rank_name` varchar(200) NOT NULL, `rank_id` bigint(20) UNSIGNED NOT NULL, `username` varchar(200) NOT NULL, `monthly_personal_ap` decimal(20,2) NOT NULL DEFAULT 0.00, `team_sales` decimal(20,2) NOT NULL, `team_point` decimal(20,2) NOT NULL, `self_sales` decimal(20,2) NOT NULL, `self_point` decimal(20,2) NOT NULL, `self_earning` decimal(20,2) NOT NULL, `team_earning` decimal(20,2) NOT NULL, `self_bonus` decimal(20,2) NOT NULL, `team_bonus` decimal(20,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `rank2s` -- INSERT INTO `rank2s` (`id`, `rank_name`, `rank_id`, `username`, `monthly_personal_ap`, `team_sales`, `team_point`, `self_sales`, `self_point`, `self_earning`, `team_earning`, `self_bonus`, `team_bonus`, `created_at`, `updated_at`) VALUES (1, 'customer', 1, 'user', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-02-29 16:54:45'), (2, 'customer', 1, 'agent', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (3, 'customer', 1, 'agent2', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (4, 'customer', 1, 'AYUR000001', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-02-29 16:54:45'), (5, 'customer', 1, 'AYUR000002', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (6, 'customer', 1, 'AYUR000003', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (7, 'customer', 1, 'AYUR000004', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (8, 'customer', 1, 'AYUR000005', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-02-29 16:54:45'), (9, 'customer', 1, 'AYUR000006', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (10, 'customer', 1, 'AYUR000007', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (11, 'customer', 1, 'AYUR000008', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (12, 'customer', 1, 'AYUR000009', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (13, 'customer', 1, 'AYUR000010', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (14, 'customer', 1, 'AYUR000011', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (15, 'customer', 1, 'AYUR000012', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (16, 'customer', 1, 'AYUR000013', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (17, 'customer', 1, 'AYUR000014', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 16:54:45', '2024-03-17 18:21:58'), (18, 'Brand Ambassador', 12, 'AYUR000001', 0.00, 0.00, 7000.00, 0.00, 300.00, 0.00, 0.00, 40.00, 2.00, '2024-02-29 17:13:16', '2024-02-29 17:13:16'), (19, 'Crown Director', 8, 'AYUR000005', 0.00, 0.00, 6000.00, 0.00, 250.00, 0.00, 0.00, 30.00, 3.00, '2024-02-29 17:18:11', '2024-02-29 17:18:11'), (20, 'Customer', 1, 'AYUR000015', 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 0.00, 10.00, 0.00, '2024-02-29 17:27:21', '2024-02-29 17:27:21'), (21, 'Customer', 1, 'AYUR4172418', 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 0.00, 10.00, 0.00, '2024-03-04 09:27:08', '2024-03-04 09:27:08'), (22, 'Customer', 1, 'AYUR4511319', 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 0.00, 10.00, 0.00, '2024-03-04 09:42:29', '2024-03-04 09:42:29'), (23, 'distributor', 2, 'user', 0.00, 30000.00, 750.00, 0.00, 0.00, 0.00, 0.00, 12.00, 2.00, '2024-03-06 07:07:35', '2024-03-06 07:07:35'), (24, 'customer', 1, 'AYUR000001', 0.00, 20000.00, 500.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 07:07:35', '2024-03-06 07:07:35'), (25, 'customer', 1, 'AYUR000005', 0.00, 10000.00, 250.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 07:07:35', '2024-03-06 07:07:35'), (26, 'customer', 1, 'AYUR000015', 0.00, 0.00, 0.00, 10000.00, 250.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 07:07:35', '2024-03-17 18:21:58'), (27, 'customer', 1, 'AYUR4172418', 0.00, 0.00, 0.00, 10000.00, 250.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 07:07:35', '2024-03-06 07:07:35'), (28, 'customer', 1, 'AYUR4511319', 0.00, 0.00, 0.00, 10000.00, 250.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 07:07:35', '2024-03-17 18:21:58'), (29, 'Customer', 1, 'AYUR6499520', 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 13:54:11', '2024-03-06 13:54:11'), (30, 'Brand Ambassador', 12, 'AYUR000001', 0.00, 20000.00, 10000.00, 0.00, 500.00, 0.00, 0.00, 40.00, 2.00, '2024-03-06 13:57:00', '2024-03-06 13:57:00'), (31, 'customer', 1, 'AYUR000001', 0.00, 20000.00, 500.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 13:57:10', '2024-03-06 13:57:10'), (32, 'customer', 1, 'AYUR6499520', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 13:57:10', '2024-03-17 18:21:58'), (33, 'Brand Ambassador', 12, 'AYUR000001', 0.00, 20000.00, 6000.00, 0.00, 300.00, 0.00, 0.00, 40.00, 2.00, '2024-03-06 14:00:08', '2024-03-06 14:00:08'), (34, 'customer', 1, 'AYUR000001', 0.00, 20000.00, 500.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 14:00:37', '2024-03-06 14:00:37'), (35, 'distributor', 2, 'AYUR000001', 0.00, 25000.00, 650.00, 0.00, 0.00, 0.00, 0.00, 12.00, 2.00, '2024-03-06 15:59:34', '2024-03-06 15:59:34'), (36, 'Customer', 1, 'AYUR3415121', 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 16:01:56', '2024-03-06 16:01:56'), (37, 'customer', 1, 'AYUR3415121', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-06 16:02:53', '2024-03-06 16:02:53'), (38, 'Brand Ambassador', 12, 'AYUR000001', 0.00, 40000.00, 6000.00, 0.00, 350.00, 0.00, 0.00, 40.00, 2.00, '2024-03-06 16:08:43', '2024-03-06 16:08:43'), (39, 'Sales Manager', 4, 'AYUR4172418', 0.00, 15000.00, 5000.00, 15000.00, 250.00, 0.00, 0.00, 18.00, 3.00, '2024-03-06 16:09:50', '2024-03-06 16:09:50'), (40, 'Crown Director', 8, 'AYUR000005', 0.00, 0.00, 10000.00, 0.00, 10000.00, 0.00, 0.00, 30.00, 3.00, '2024-03-09 18:59:26', '2024-03-09 18:59:26'), (43, 'sales_manager', 4, 'AYUR3415121', 151.00, 0.00, 5005.00, 2000.00, 100.00, 0.00, 0.00, 18.00, 3.00, '2024-03-17 17:13:52', '2024-03-17 17:24:00'), (44, 'customer', 1, 'user', 0.00, 2000.00, 100.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-17 18:21:58', '2024-03-17 18:21:58'), (45, 'customer', 1, 'AYUR000001', 0.00, 2000.00, 100.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-17 18:21:58', '2024-03-17 18:21:58'), (46, 'customer', 1, 'AYUR000005', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-17 18:21:58', '2024-03-17 18:21:58'), (47, 'customer', 1, 'AYUR4172418', 0.00, 2000.00, 100.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, '2024-03-17 18:21:58', '2024-03-17 18:21:58'), (48, 'customer', 1, 'AYUR3415121', 0.00, 0.00, 0.00, 2000.00, 100.00, 0.00, 0.00, 10.00, 0.00, '2024-03-17 18:21:58', '2024-03-17 18:21:58'); -- -------------------------------------------------------- -- -- Table structure for table `ranks` -- CREATE TABLE `ranks` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT '0', `ap` decimal(20,2) DEFAULT 0.00, `group_sales` decimal(20,2) DEFAULT 0.00, `commission` decimal(20,2) DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `ranks` -- INSERT INTO `ranks` (`id`, `name`, `ap`, `group_sales`, `commission`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Customer', 0.00, 0.00, 10.00, '2024-01-18 16:44:21', '2024-01-18 16:45:40', NULL), (2, 'Distributor', 0.00, 2.00, 12.00, '2024-01-18 16:44:57', '2024-01-18 16:44:57', NULL), (3, 'Leader', 0.00, 3.00, 15.00, '2024-01-18 16:45:19', '2024-01-18 16:45:19', NULL), (4, 'Sales Manager', 100.00, 3.00, 18.00, '2024-01-18 16:46:12', '2024-01-18 16:47:39', NULL), (5, 'Silver Director', 150.00, 3.00, 21.00, '2024-01-18 16:47:33', '2024-01-18 16:47:33', NULL), (6, 'Gold Director', 200.00, 3.00, 24.00, '2024-01-18 16:48:53', '2024-01-18 16:48:53', NULL), (7, 'Platinum Director', 250.00, 3.00, 27.00, '2024-01-18 16:49:15', '2024-01-18 16:49:15', NULL), (8, 'Crown Director', 250.00, 3.00, 30.00, '2024-01-18 16:49:56', '2024-01-18 16:49:56', NULL), (9, 'Ruby Director', 300.00, 3.00, 33.00, '2024-01-18 16:50:59', '2024-01-18 16:50:59', NULL), (10, 'Diamond Director', 300.00, 3.00, 36.00, '2024-01-18 16:51:23', '2024-01-18 16:51:23', NULL), (11, 'Star Ambassador', 300.00, 2.00, 38.00, '2024-01-18 16:51:41', '2024-01-18 16:51:41', NULL), (12, 'Brand Ambassador', 300.00, 2.00, 40.00, '2024-01-18 16:51:57', '2024-01-18 16:51:57', NULL); -- -------------------------------------------------------- -- -- Table structure for table `royel_club_achievers` -- CREATE TABLE `royel_club_achievers` ( `id` bigint(20) UNSIGNED NOT NULL, `lavel` varchar(255) DEFAULT NULL, `bonus` decimal(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `royel_club_achievers` -- INSERT INTO `royel_club_achievers` (`id`, `lavel`, `bonus`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, '1', 0.70, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (2, '2', 0.60, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (3, '3', 0.50, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (4, '4', 0.40, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (5, '5', 0.30, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (6, '6', 0.10, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (7, '7', 0.10, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (8, '8', 0.10, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (9, '9', 0.10, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL), (10, '10', 0.10, '2024-03-20 14:59:58', '2024-03-20 14:59:58', NULL); -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE `states` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `postal_code` varchar(255) DEFAULT NULL, `tele_code` varchar(255) DEFAULT NULL, `country_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `states` -- INSERT INTO `states` (`id`, `name`, `postal_code`, `tele_code`, `country_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Kuala Lumpur', '43200', '+60', '1', '2024-01-24 16:17:45', '2024-01-24 16:17:45', NULL), (2, 'Muscat', '113', '+968', '2', '2024-01-24 16:19:43', '2024-01-24 16:19:43', NULL), (3, 'Kuwait', '54600', '+965', '3', '2024-01-24 16:20:51', '2024-01-24 16:20:51', NULL), (4, 'Penang', '11600', '+60', '1', '2024-02-02 06:45:46', '2024-02-02 06:45:46', NULL), (5, 'Riyadh', '00', '00', '3', '2024-02-02 07:15:13', '2024-02-02 07:17:09', NULL), (6, 'Johor Bahru', '79100', '+60', '1', '2024-02-03 04:44:20', '2024-02-03 04:44:20', NULL); -- -------------------------------------------------------- -- -- Table structure for table `sub_categories` -- CREATE TABLE `sub_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `subcategory` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sub_categories` -- INSERT INTO `sub_categories` (`id`, `category_id`, `subcategory`, `slug`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'Rice Cooker', 'rice-cooker-382', '2024-02-28 15:03:49', '2024-02-28 15:03:49', NULL), (2, 1, 'All Of Appliance', 'all-of-appliance-211', '2024-02-28 15:04:15', '2024-02-28 15:04:15', NULL), (3, 3, 'ECG', 'ecg-48', '2024-02-28 15:04:26', '2024-02-28 15:04:26', NULL), (4, 2, 'T-Shirt', 't-shirt-444', '2024-02-28 15:04:36', '2024-02-28 15:04:36', NULL); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `admin_id` bigint(20) UNSIGNED DEFAULT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `agent_id` bigint(20) UNSIGNED DEFAULT NULL, `invoice_id` bigint(20) UNSIGNED DEFAULT NULL, `wallet_type` tinyint(4) DEFAULT NULL, `deb_amount` decimal(20,2) NOT NULL DEFAULT 0.00, `cred_amount` decimal(20,2) NOT NULL DEFAULT 0.00, `cred_point` decimal(20,2) NOT NULL DEFAULT 0.00, `deb_point` decimal(20,2) NOT NULL DEFAULT 0.00, `status` tinyint(4) NOT NULL DEFAULT 2, `in_status` tinyint(4) NOT NULL DEFAULT 1, `transaction_type` tinyint(4) DEFAULT NULL, `transaction_no` varchar(255) DEFAULT NULL, `transaction_note` varchar(255) DEFAULT NULL, `method` varchar(255) DEFAULT NULL, `wallet_address` varchar(255) DEFAULT NULL, `currency` varchar(255) DEFAULT NULL, `withdrawal_status` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `club_id` varchar(255) DEFAULT NULL, `rank_id` varchar(255) DEFAULT NULL, `bonus` varchar(255) DEFAULT NULL, `equals_of_club_bonus` varchar(255) DEFAULT NULL, `date` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `admin_id`, `user_id`, `agent_id`, `invoice_id`, `wallet_type`, `deb_amount`, `cred_amount`, `cred_point`, `deb_point`, `status`, `in_status`, `transaction_type`, `transaction_no`, `transaction_note`, `method`, `wallet_address`, `currency`, `withdrawal_status`, `image`, `club_id`, `rank_id`, `bonus`, `equals_of_club_bonus`, `date`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, NULL, 3, NULL, NULL, 1, 0.00, 2000000.00, 0.00, 0.00, 1, 1, 1, '43543534543', 'Fund Added - Date : 06 Mar 2024 10:43:39 pm', '1', '34534543545', 'MYR', NULL, '3-1709743418.png', NULL, NULL, NULL, NULL, '1709743419', '2024-03-06 16:43:39', '2024-03-06 16:43:48', NULL), (2, NULL, 3, NULL, 1, 1, 172500.00, 0.00, 13000.00, 0.00, 1, 1, 6, NULL, 'Package purchase admin to 3', NULL, NULL, 'MYR', NULL, NULL, NULL, NULL, NULL, NULL, '1709743533', '2024-03-06 16:45:33', '2024-03-06 16:45:33', NULL), (3, NULL, 3, NULL, 2, 1, 604500.00, 0.00, 28500.00, 0.00, 1, 1, 5, NULL, 'Product purchase admin to 3', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709743644', '2024-03-06 16:47:24', '2024-03-06 16:47:24', NULL), (4, NULL, 22, NULL, 3, 1, 2000.00, 0.00, 100.00, 0.00, 1, 1, 3, NULL, 'Product Purchase agent2 to AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709743894', '2024-03-06 16:51:34', '2024-03-06 16:51:34', NULL), (5, NULL, 19, NULL, 3, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 10, NULL, 'Leadership Commission Generation 1 from AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709743894', '2024-03-06 16:51:34', '2024-03-06 16:51:34', NULL), (6, NULL, 4, NULL, 3, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 10, NULL, 'Leadership Commission Generation 2 from AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709743894', '2024-03-06 16:51:34', '2024-03-06 16:51:34', NULL), (10, NULL, 22, NULL, 3, 1, 0.00, 0.00, 10.00, 0.00, 1, 1, 4, NULL, '10.00 Sell Commission for Invoice 3 To AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709744917', '2024-03-06 17:08:37', '2024-03-06 17:08:37', NULL), (11, NULL, 19, NULL, 3, 1, 0.00, 0.00, 26.00, 0.00, 1, 1, 4, NULL, '26 Sell Commission for Invoice 3 To AYUR4172418', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709744917', '2024-03-06 17:08:37', '2024-03-06 17:08:37', NULL), (12, NULL, 4, NULL, 3, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 4, NULL, '2 Sell Commission for Invoice 3 To AYUR000001', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709744917', '2024-03-06 17:08:37', '2024-03-06 17:08:37', NULL), (13, NULL, 22, NULL, 3, 1, 0.00, 0.00, 10.00, 0.00, 1, 1, 4, NULL, '10.00 Sell Commission for Invoice 3 To AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745527', '2024-03-06 17:18:47', '2024-03-06 17:18:47', NULL), (14, NULL, 19, NULL, 3, 1, 0.00, 0.00, 26.00, 0.00, 1, 1, 4, NULL, '26 Sell Commission for Invoice 3 To AYUR4172418', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745527', '2024-03-06 17:18:47', '2024-03-06 17:18:47', NULL), (15, NULL, 4, NULL, 3, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 4, NULL, '2 Sell Commission for Invoice 3 To AYUR000001', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745527', '2024-03-06 17:18:47', '2024-03-06 17:18:47', NULL), (16, NULL, 22, NULL, 3, 1, 0.00, 0.00, 10.00, 0.00, 1, 1, 4, NULL, '10.00 Sell Commission for Invoice 3 To AYUR3415121', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745586', '2024-03-06 17:19:46', '2024-03-06 17:19:46', NULL), (17, NULL, 19, NULL, 3, 1, 0.00, 0.00, 26.00, 0.00, 1, 1, 4, NULL, '26 Sell Commission for Invoice 3 To AYUR4172418', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745586', '2024-03-06 17:19:46', '2024-03-06 17:19:46', NULL), (18, NULL, 4, NULL, 3, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 4, NULL, '2 Sell Commission for Invoice 3 To AYUR000001', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1709745586', '2024-03-06 17:19:46', '2024-03-06 17:19:46', NULL), (24, NULL, 4, NULL, NULL, 1, 0.00, 0.00, 2.00, 0.00, 1, 1, 12, NULL, '2.00% Development Bonus', NULL, NULL, 'BDT', NULL, NULL, '1', '12', '2.00', '2', '1710090065', '2024-03-10 17:01:05', '2024-03-10 17:01:05', NULL), (25, NULL, 4, NULL, NULL, 1, 0.00, 0.00, 1.00, 0.00, 1, 1, 12, NULL, '1.00% Car Fund Details', NULL, NULL, 'BDT', NULL, NULL, '2', '12', '1.00', '1', '1710090065', '2024-03-10 17:01:05', '2024-03-10 17:01:05', NULL), (26, NULL, 4, NULL, NULL, 1, 0.00, 0.00, 1.00, 0.00, 1, 1, 12, NULL, '1.00% House Fund Bonus', NULL, NULL, 'BDT', NULL, NULL, '3', '12', '1.00', '1', '1710090065', '2024-03-10 17:01:05', '2024-03-10 17:01:05', NULL), (27, NULL, 8, NULL, NULL, 1, 0.00, 0.00, 1.00, 0.00, 1, 1, 12, NULL, '1.00% Development Bonus', NULL, NULL, 'BDT', NULL, NULL, '1', '8', '1.00', '1', '1710090065', '2024-03-10 17:01:05', '2024-03-10 17:01:05', NULL), (28, NULL, 8, NULL, NULL, 1, 0.00, 0.00, 1.00, 0.00, 1, 1, 12, NULL, '1.00% Car Fund Details', NULL, NULL, 'BDT', NULL, NULL, '2', '8', '1.00', '1', '1710090065', '2024-03-10 17:01:05', '2024-03-10 17:01:05', NULL), (29, NULL, 4, NULL, 4, 1, 3000.00, 0.00, 2000.00, 0.00, 1, 1, 3, NULL, 'Product Purchase agent2 to AYUR000001', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1710959918', '2024-03-20 18:38:38', '2024-03-20 18:38:38', NULL), (30, NULL, 5, NULL, 5, 1, 65225.00, 0.00, 800.00, 0.00, 1, 1, 3, NULL, 'Product Purchase agent2 to AYUR000002', NULL, NULL, 'BDT', NULL, NULL, NULL, NULL, NULL, NULL, '1710960058', '2024-03-20 18:40:58', '2024-03-20 18:40:58', NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `refer` varchar(255) DEFAULT NULL, `agent` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `nid_no` varchar(60) NOT NULL, `gender` tinyint(4) NOT NULL, `birthday` varchar(30) NOT NULL, `country` bigint(20) UNSIGNED NOT NULL, `states` bigint(20) UNSIGNED NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `show_password` varchar(255) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `type` tinyint(4) NOT NULL DEFAULT 0, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `username`, `phone`, `refer`, `agent`, `email`, `image`, `nid_no`, `gender`, `birthday`, `country`, `states`, `email_verified_at`, `password`, `show_password`, `status`, `type`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'User', 'user', '123456789', 'refer', 'agent', 'user@mail.com', 'user857.png', '', 0, '', 1, 1, '2023-12-23 14:37:47', '$2y$12$BjuOWL2ugoDMEe.Z0IJMfepqx6XlnxW/7krqIL8DdoNxLZUD/ov4e', '12345678', 0, 0, NULL, '2023-12-23 14:37:47', '2024-01-04 14:25:19', NULL), (2, 'Agent', 'agent', '123456789', 'refer', 'agent', 'user@mail.com', 'agent341.jpg', '', 0, '', 1, 1, '2023-12-23 14:37:47', '$2y$12$SISukeog3N7bnyG6tfyEAe1ziKesPv1zHYlkOs6ikjaaCNWhYWKCi', '12345678', 0, 1, NULL, '2023-12-23 14:37:47', '2024-01-04 14:26:30', NULL), (3, 'Agent 2', 'agent2', '+6054645645', 'user', 'agent', 'dfsdfsd@mail.com', NULL, '456546546456', 1, '01-02-1996', 1, 1, NULL, '$2y$12$r8xLkXnVzW/.mc503N6MV.RDlcylKEWlgFZq5gUDMhBRB7AFCdpOK', '12345678', 0, 1, NULL, '2024-02-28 09:27:38', '2024-02-28 09:27:38', NULL), (4, 'User 1', 'AYUR000001', '+6001724343698', 'user', 'agent2', 'z.illur78489@gmail.com', NULL, '546456456456456', 1, '01-02-1999', 1, 1, NULL, '$2y$12$oDoAKX7NKWoAcydOkodE9ens0zDoJusFMwZO089geVvqJXL1ebi3q', '12345678', 0, 0, NULL, '2024-02-28 09:22:58', '2024-02-28 09:29:29', NULL), (5, 'User 2', 'AYUR000002', '+60435345345', 'AYUR000001', 'agent2', 'admindsfs@mail.com', NULL, '4543534', 1, '01-02-1994', 1, 1, NULL, '$2y$12$Tocc0o2VS98GCr7e2HRepeW8xOnWZS7OHDCPURFzSJXD3UXJMQRMO', '12345678', 0, 0, NULL, '2024-02-28 16:11:53', '2024-02-28 16:11:53', NULL), (6, 'User 3', 'AYUR000003', '+6045435435345', 'AYUR000002', 'agent2', 'sdfsdfs@gmail.com', NULL, '43534534534', 1, '01-02-2000', 1, 1, NULL, '$2y$12$HK4/Em3Nk5PipY0qogKXaegYDL2h2nN55bJ0.SQtdEyJtMwefoZWK', '12345678', 0, 0, NULL, '2024-02-28 18:19:07', '2024-02-28 18:19:07', NULL), (7, 'User 4', 'AYUR000004', '+6045654645', 'AYUR000003', 'agent2', 'sdfsdfsdfs@gmail.com', NULL, '32423423423', 1, '02-02-1996', 1, 1, NULL, '$2y$12$53bmaA1xQEByEs1bZ1VecebIzq4fOe8Qx5SfZqTo.gu16m5k5m/36', '12345678', 0, 0, NULL, '2024-02-28 18:28:57', '2024-02-28 18:28:57', NULL), (8, 'User 5', 'AYUR000005', '+605675756756', 'AYUR000004', 'agent2', 'gfjgffjh@gmail.com', NULL, '76567465', 1, '01-02-2002', 1, 1, NULL, '$2y$12$hkCcLgVCuOphpMFRnxfJk.nnXnto1oT.pv5lElEz35fHIBYqcrQO.', '12345678', 0, 0, NULL, '2024-02-28 18:31:00', '2024-02-28 18:31:00', NULL), (9, 'User 6', 'AYUR000006', '+605645645645854', 'AYUR000005', 'agent2', 'fsdfsdfs@gmail.com', NULL, '4564645645', 1, '01-02-1999', 1, 1, NULL, '$2y$12$BpZadFvfljZhDB1Mpf074.XTVRPaEf4OsTRCmQY.AvUFL6m/PjZ7u', '12345678', 0, 0, NULL, '2024-02-28 18:32:44', '2024-02-28 18:32:44', NULL), (10, 'User 7', 'AYUR000007', '+604534534534', 'AYUR000006', 'agent2', 'sdfsdfds@gmail.com', NULL, '3453463534', 1, '01-02-2000', 1, 1, NULL, '$2y$12$eV/o6fNA3ay9Wlmw3gypIOAuKw7.NF/aaPSOckoinHjKAgPGTEC/O', '12345678', 0, 0, NULL, '2024-02-28 18:36:58', '2024-02-28 18:36:58', NULL), (11, 'User 8', 'AYUR000008', '+6046435345345', 'AYUR000007', 'agent2', 'sdfsdfsdf@gmail.com', NULL, '435347345345', 1, '01-02-2002', 1, 1, NULL, '$2y$12$5Dzip4dstti0nRF1v.MqNu2JI0l02ubYMcpeeQltrEDk7Tc8PuZBq', '12345678', 0, 0, NULL, '2024-02-28 18:38:12', '2024-02-28 18:38:12', NULL), (12, 'User 9', 'AYUR000009', '+60565464654', 'AYUR000008', 'agent2', 'dsfsdfsdfsd@gmail.com', NULL, '54646456456', 1, '01-02-2000', 1, 1, NULL, '$2y$12$UJlcywtkyfVAUzRQA7zPKu6hNNDLK4cDMqXG9rA2SRUsCuGAsBpAG', '12345678', 0, 0, NULL, '2024-02-28 18:39:19', '2024-02-28 18:39:19', NULL), (13, 'User 10', 'AYUR000010', '+6054645645645', 'AYUR000009', 'agent2', 'sdfsdfsd@gmail.com', NULL, '5464645645', 1, '01-02-2000', 1, 1, NULL, '$2y$12$flxu8JlfVmJCTh.erZcH9OVORAJ1AMhxzm.RqoR56Ul1042vLAIHK', '12345678', 0, 0, NULL, '2024-02-28 18:40:34', '2024-02-28 18:40:34', NULL), (14, 'User 11', 'AYUR000011', '+6054654645645', 'AYUR000010', 'agent2', 'sdfsdsdfsdfsd@gmail.com', NULL, '5434534534', 1, '02-02-1998', 1, 1, NULL, '$2y$12$BemjwaN6YyEmaGMlTeR4R.09EyGGALhuTRgmZp.xY43oKvyXUl7qG', '12345678', 0, 0, NULL, '2024-02-28 18:44:19', '2024-02-28 18:44:19', NULL), (15, 'User 12', 'AYUR000012', '+6045645645645', 'AYUR000011', 'agent2', 'sdfsdrewrew@gmail.com', NULL, '34543543534', 1, '03-02-1999', 1, 1, NULL, '$2y$12$8Wc9.6geB.0O8RosTwNbsOAMS0MdeaH5ZaMDbXsBqLQZGyNDtDXeu', '12345678', 0, 0, NULL, '2024-02-28 18:46:32', '2024-02-28 18:46:32', NULL), (16, 'User 13 (Refer by User 11)', 'AYUR000013', '+60645645', 'AYUR000011', 'agent2', 'gfhgfhfg@mail.com', NULL, 'dfgdfgfd', 1, '01-02-1985', 1, 1, NULL, '$2y$12$nICZeaDRZPp6u0pCOYtlYOJeFIZPzXecoNg00B2arW3it4iDKExeO', '12345678', 0, 0, NULL, '2024-02-29 06:19:30', '2024-02-29 06:19:30', NULL), (17, 'User 14 (Refer By User 4)', 'AYUR000014', '+60435345345', 'AYUR000004', 'agent2', 'fgdfgfhfgh@gmail.com', NULL, '45654645645654', 1, '01-02-1996', 1, 1, NULL, '$2y$12$9RVi9h6k9NoG.t84tcWAFOr4NskOE8LOFsdjRhejnTfVmzeokv812', '12345678', 0, 0, NULL, '2024-02-29 10:14:34', '2024-02-29 10:14:34', NULL), (18, 'User 15 (Refer By User 6)', 'AYUR000015', '+604534534534534', 'AYUR000006', 'agent2', 'sdfsdfsdfsdfsd@mail.com', NULL, '54645645645645', 1, '01-02-1988', 1, 1, NULL, '$2y$12$xnpKA.pwcvf1qrX6Ql7g5.iLA4l4EEosCtO6HDS7tEsmxG.satBla', '12345678', 0, 0, NULL, '2024-02-29 17:27:21', '2024-02-29 17:27:21', NULL), (19, 'Hafizur Rahman', 'AYUR4172418', '+9688466464649', 'AYUR000001', 'agent2', 'superstar.hafiz@gmail.com', NULL, '8287337777', 1, '27-03-2003', 2, 2, NULL, '$2y$12$68qO14myppMGVMefMSyWEONc3mKbaQFWj7YhZgSA4GDNYZW/R32Bu', '11111111', 0, 0, NULL, '2024-03-04 09:27:08', '2024-03-04 09:27:08', NULL), (20, 'Mahmudur Rahman', 'AYUR4511319', '+6001789110048', 'user', 'agent2', 'sellerhaat@gmail.com', NULL, '12345678911', 1, '01-01-2000', 1, 4, NULL, '$2y$12$2N1kb1n3fJELrS5nBB0QeeAmwrAw0zi2PbE3JjA1ksyWLMX43eKA6', '12345678', 0, 0, NULL, '2024-03-04 09:42:29', '2024-03-04 09:42:29', NULL), (21, 'Check 01', 'AYUR6499520', '+606464654654654', 'AYUR4172418', 'agent2', 'ugiguihiuhiuhiuhiu@gmail.com', NULL, '5684654645466', 1, '13-03-1974', 1, 4, NULL, '$2y$12$Lc0OCFSzo4KZekx.z7re9OjR7gKDwx1aI4mihUK5gbvZkgwgFPL2.', '11111111', 0, 0, NULL, '2024-03-06 13:54:11', '2024-03-06 13:54:11', NULL), (22, 'Check 02', 'AYUR3415121', '+60654654654654', 'AYUR4172418', 'agent2', 'hjgjhgjkgjhgjhgjhgjhgjh@gmail.com', NULL, '65464654654654', 1, '12-03-1975', 1, 1, NULL, '$2y$12$Ac0ax7vV6YwdgEYOGYojwuqrzTqwVChrH.IwYv7pBqgdOOhrCHOXO', '11111111', 0, 0, NULL, '2024-03-06 16:01:56', '2024-03-06 16:01:56', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `carts` -- ALTER TABLE `carts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `checkouts` -- ALTER TABLE `checkouts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `club_bonus_details` -- ALTER TABLE `club_bonus_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `club_bonus_details_assets` -- ALTER TABLE `club_bonus_details_assets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comapany_infos` -- ALTER TABLE `comapany_infos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cron_logs` -- ALTER TABLE `cron_logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `generations` -- ALTER TABLE `generations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `invoices` -- ALTER TABLE `invoices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `invoice_items` -- ALTER TABLE `invoice_items` ADD PRIMARY KEY (`id`); -- -- Indexes for table `leaderships` -- ALTER TABLE `leaderships` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `page_banners` -- ALTER TABLE `page_banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_exta_infos` -- ALTER TABLE `product_exta_infos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_featured_images` -- ALTER TABLE `product_featured_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rank2s` -- ALTER TABLE `rank2s` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ranks` -- ALTER TABLE `ranks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `royel_club_achievers` -- ALTER TABLE `royel_club_achievers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `states` -- ALTER TABLE `states` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sub_categories` -- ALTER TABLE `sub_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `carts` -- ALTER TABLE `carts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `checkouts` -- ALTER TABLE `checkouts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `club_bonus_details` -- ALTER TABLE `club_bonus_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `club_bonus_details_assets` -- ALTER TABLE `club_bonus_details_assets` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `comapany_infos` -- ALTER TABLE `comapany_infos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `cron_logs` -- ALTER TABLE `cron_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `generations` -- ALTER TABLE `generations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `invoices` -- ALTER TABLE `invoices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `invoice_items` -- ALTER TABLE `invoice_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `leaderships` -- ALTER TABLE `leaderships` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `packages` -- ALTER TABLE `packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `page_banners` -- ALTER TABLE `page_banners` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `product_exta_infos` -- ALTER TABLE `product_exta_infos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `product_featured_images` -- ALTER TABLE `product_featured_images` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `rank2s` -- ALTER TABLE `rank2s` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49; -- -- AUTO_INCREMENT for table `ranks` -- ALTER TABLE `ranks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `royel_club_achievers` -- ALTER TABLE `royel_club_achievers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `states` -- ALTER TABLE `states` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `sub_categories` -- ALTER TABLE `sub_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;