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

START TRANSACTION;



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

--
-- Table structure for table `admin_ledgers`
--

CREATE TABLE `admin_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `reason` varchar(255) NOT NULL,
  `perticulation` varchar(255) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `debit` double NOT NULL DEFAULT 0,
  `credit` double NOT NULL DEFAULT 0,
  `status` enum('pending','approved','rejected','default') NOT NULL DEFAULT 'default',
  `date` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `bank_lists`
--

CREATE TABLE `bank_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bank_code` varchar(255) NOT NULL,
  `gtr_bank_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `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 `bank_lists`
--

INSERT INTO `bank_lists` (`id`, `bank_code`, `gtr_bank_code`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, '167', '', 'Nagad', 1, '2023-01-25 07:35:27', '2023-01-25 07:35:27'),
(2, '247', '', 'Bkash', 1, '2023-01-25 07:35:27', '2023-01-25 07:35:27');

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

--
-- Table structure for table `bonuses`
--

CREATE TABLE `bonuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `bonus_name` varchar(255) NOT NULL,
  `counter` int(11) DEFAULT 0 COMMENT 'user get service count',
  `set_service_counter` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bonuses`
--

INSERT INTO `bonuses` (`id`, `bonus_name`, `counter`, `set_service_counter`, `code`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(77, 'Second Bonuse', 6, 2, 'BD91WU', 100, 'inactive', '2024-11-04 22:24:17', '2025-10-19 13:56:14'),
(84, 'Fist Boune', 0, 1, 'AUTOEARN01', 50, 'active', '2025-10-19 13:54:42', '2025-10-19 13:56:14');

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

--
-- Table structure for table `bonus_ledgers`
--

CREATE TABLE `bonus_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `bonus_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `bonus_code` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bonus_ledgers`
--

INSERT INTO `bonus_ledgers` (`id`, `user_id`, `bonus_id`, `amount`, `bonus_code`, `created_at`, `updated_at`) VALUES
(1, 4612, 75, 0.00, 'Wkf0s6gj', '2024-08-29 21:03:46', '2024-08-29 21:03:46'),
(2, 4628, 76, 0.00, 'hello', '2024-11-01 01:45:10', '2024-11-01 01:45:10'),
(3, 1, 77, 0.00, 'BD91WU', '2024-11-04 22:24:53', '2024-11-04 22:24:53'),
(4, 4644, 77, 0.00, 'BD91WU', '2024-11-05 06:55:32', '2024-11-05 06:55:32'),
(5, 4646, 77, 0.00, 'BD91WU', '2024-11-05 07:02:33', '2024-11-05 07:02:33'),
(6, 4647, 77, 0.00, 'BD91WU', '2024-11-05 07:08:47', '2024-11-05 07:08:47'),
(7, 4692, 77, 0.00, 'BD91WU', '2024-11-05 08:06:18', '2024-11-05 08:06:18'),
(8, 4649, 77, 0.00, 'BD91WU', '2024-11-05 08:58:40', '2024-11-05 08:58:40'),
(9, 4786, 79, 0.00, '20TEAM', '2024-11-05 09:26:46', '2024-11-05 09:26:46'),
(10, 4771, 79, 0.00, '20TEAM', '2024-11-05 09:28:56', '2024-11-05 09:28:56'),
(11, 4680, 79, 0.00, '20TEAM', '2024-11-05 09:29:36', '2024-11-05 09:29:36'),
(12, 4691, 79, 0.00, '20TEAM', '2024-11-05 09:29:52', '2024-11-05 09:29:52'),
(13, 4692, 79, 0.00, '20TEAM', '2024-11-05 09:30:10', '2024-11-05 09:30:10'),
(14, 4879, 79, 0.00, '20TEAM', '2024-11-05 09:30:33', '2024-11-05 09:30:33'),
(15, 4646, 79, 0.00, '20TEAM', '2024-11-05 09:32:00', '2024-11-05 09:32:00'),
(16, 4695, 79, 0.00, '20TEAM', '2024-11-05 09:32:06', '2024-11-05 09:32:06'),
(17, 4764, 79, 0.00, '20TEAM', '2024-11-05 09:32:30', '2024-11-05 09:32:30'),
(18, 4793, 79, 0.00, '20TEAM', '2024-11-05 09:32:35', '2024-11-05 09:32:35'),
(19, 4782, 79, 0.00, '20TEAM', '2024-11-05 09:32:39', '2024-11-05 09:32:39'),
(20, 4682, 79, 0.00, '20TEAM', '2024-11-05 09:33:25', '2024-11-05 09:33:25'),
(21, 4841, 79, 0.00, '20TEAM', '2024-11-05 09:34:48', '2024-11-05 09:34:48'),
(22, 4784, 79, 0.00, '20TEAM', '2024-11-05 09:36:45', '2024-11-05 09:36:45'),
(23, 4904, 79, 0.00, '20TEAM', '2024-11-05 09:37:45', '2024-11-05 09:37:45'),
(24, 4645, 79, 0.00, '20TEAM', '2024-11-05 09:37:58', '2024-11-05 09:37:58'),
(25, 4905, 79, 0.00, '20TEAM', '2024-11-05 09:38:34', '2024-11-05 09:38:34'),
(26, 4907, 79, 0.00, '20TEAM', '2024-11-05 09:41:07', '2024-11-05 09:41:07'),
(27, 4719, 79, 0.00, '20TEAM', '2024-11-05 09:50:20', '2024-11-05 09:50:20'),
(28, 4647, 80, 0.00, '6125', '2024-11-05 10:28:18', '2024-11-05 10:28:18'),
(29, 4705, 78, 0.00, 'ZG91WU', '2024-11-05 12:23:42', '2024-11-05 12:23:42'),
(30, 4692, 82, 0.00, 'ryu230rkv967', '2024-11-05 15:23:22', '2024-11-05 15:23:22'),
(31, 1, 83, 0.00, '7970165730', '2024-11-05 16:14:16', '2024-11-05 16:14:16');

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

--
-- Table structure for table `checkins`
--

CREATE TABLE `checkins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `date` varchar(255) NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `comings`
--

CREATE TABLE `comings` (
  `id` int(11) NOT NULL,
  `photo` varchar(250) DEFAULT NULL,
  `price` double(20,2) NOT NULL DEFAULT 0.00,
  `step` enum('zone_a','zone_b','zone_c') DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `comings`
--

INSERT INTO `comings` (`id`, `photo`, `price`, `step`, `created_at`, `updated_at`) VALUES
(1, '/upload/coming/1692347592bJF.jpg', 200.00, 'zone_b', '2023-08-18 08:33:21', '2023-08-18 08:33:21'),
(2, '/upload/coming/1692347672KU8.jpg', 150.00, 'zone_b', '2023-08-18 08:34:33', '2023-08-18 08:34:33'),
(3, '/upload/coming/1692347694wtX.jpg', 210.00, 'zone_a', '2023-08-18 08:34:55', '2023-08-18 08:34:55'),
(4, '/upload/coming/1692347714zAH.jpg', 365.00, 'zone_c', '2023-08-18 08:35:14', '2023-08-18 08:35:14');

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

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `date` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `method_name` varchar(255) NOT NULL,
  `oid` varchar(255) DEFAULT NULL,
  `order_id` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL COMMENT 'User Deposit Amount',
  `charge_amount` double(20,2) NOT NULL DEFAULT 0.00,
  `final_amount` double(20,2) NOT NULL DEFAULT 0.00,
  `date` varchar(255) NOT NULL,
  `feedback` text DEFAULT NULL,
  `pay_link` text DEFAULT NULL,
  `data` text DEFAULT NULL,
  `status` enum('pending','rejected','approved') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `drows`
--

CREATE TABLE `drows` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- 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=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `funds`
--

CREATE TABLE `funds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` longtext NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `commission` bigint(20) NOT NULL COMMENT 'percent',
  `validity` bigint(20) NOT NULL,
  `minimum_invest` double(20,2) NOT NULL DEFAULT 0.00 COMMENT 'amount',
  `status` enum('upcoming','active') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `fund_invests`
--

CREATE TABLE `fund_invests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `fund_id` bigint(20) UNSIGNED NOT NULL,
  `validity_expired` varchar(255) NOT NULL,
  `price` double NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `hiru_notices`
--

CREATE TABLE `hiru_notices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `desc` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `hiru_notices`
--

INSERT INTO `hiru_notices` (`id`, `desc`, `created_at`, `updated_at`) VALUES
(5, 'Welcome to PNG-LDT. It\'s a mining era privilege.\r\n\r\n You can activated\r\n different machines here. If you have activated either machine, know that you must activate the machine every 24 hours. \r\nIf you don\'t turn on the machine it can\'t earn. PNG robotics machines can give you income through mining, you can keep an eye on the Telegram discussion group for details. \r\n\r\nThank you for being a PNG member.', '2023-05-14 19:10:36', '2023-05-14 19:10:36');

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

--
-- Table structure for table `improvments`
--

CREATE TABLE `improvments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `level` varchar(255) NOT NULL,
  `amount_limit` double NOT NULL DEFAULT 0,
  `between_amount` double(20,2) NOT NULL DEFAULT 0.00,
  `commission` double(20,2) NOT NULL DEFAULT 1.00 COMMENT 'percentage',
  `first_refer_commission` double(20,2) NOT NULL DEFAULT 1.00 COMMENT 'percentage',
  `second_refer_commission` double(20,2) NOT NULL DEFAULT 1.00 COMMENT 'percentage',
  `third_refer_commission` double(20,2) NOT NULL DEFAULT 1.00 COMMENT 'percentage',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `lucky_ledgers`
--

CREATE TABLE `lucky_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `draw_id` bigint(20) DEFAULT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `current_date` varchar(255) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_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=utf8mb3 COLLATE=utf8mb3_general_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_resets_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_03_16_074227_create_admins_table', 1),
(6, '2023_03_17_123007_create_packages_table', 2),
(8, '2023_03_27_103153_create_payment_methods_table', 3),
(10, '2023_03_28_074201_create_deposits_table', 4),
(11, '2023_03_28_142734_create_user_ledgers_table', 5),
(12, '2023_03_28_142802_create_admin_ledgers_table', 6),
(13, '2023_03_30_071745_create_vip_sliders_table', 7),
(14, '2023_03_30_150139_create_settings_table', 8),
(15, '2023_04_01_185541_create_bonuses_table', 9),
(16, '2023_04_01_205009_create_bonus_ledgers_table', 10),
(17, '2023_04_05_203304_create_purchases_table', 11),
(18, '2023_04_09_200835_create_minings_table', 12),
(19, '2023_05_05_092841_create_drows_table', 13),
(20, '2023_05_05_111428_create_lucky_ledgers_table', 14),
(21, '2023_05_05_161904_create_icons_table', 15),
(22, '2023_05_09_214610_create_hiru_notices_table', 16),
(23, '2023_06_06_210226_create_funds_table', 17),
(24, '2023_06_06_222047_create_fund_invests_table', 18),
(25, '2023_06_11_113547_create_checkins_table', 19),
(26, '2023_06_23_193458_create_improvments_table', 20),
(27, '2023_06_24_083626_create_commissions_table', 21),
(28, '2025_10_19_000001_create_referral_levels_table', 22),
(29, '2025_10_19_000002_create_referral_bonus_claims_table', 23);

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

--
-- Table structure for table `minings`
--

CREATE TABLE `minings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) DEFAULT NULL,
  `running_start_date` varchar(255) DEFAULT NULL,
  `running_end_date` varchar(255) DEFAULT NULL,
  `total_time` varchar(255) DEFAULT NULL COMMENT 'total_package_hour',
  `continue_date_time` varchar(255) DEFAULT NULL,
  `amount_24_hour` double(20,4) NOT NULL DEFAULT 0.0000 COMMENT '24=1counter',
  `counter_24_hour` int(11) NOT NULL DEFAULT 0 COMMENT '24=1counter',
  `running_status` enum('start','end') NOT NULL DEFAULT 'start',
  `amount_status` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'true=balance added, false=''mining running''',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `notice_type` varchar(255) NOT NULL,
  `notice_title` varchar(255) NOT NULL,
  `notice_desc` text NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `ROI` varchar(255) NOT NULL,
  `referral_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `referral_required` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `max_per_user` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `title` text DEFAULT NULL,
  `photo` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `validity` varchar(255) NOT NULL COMMENT 'count days',
  `commission_with_avg_amount` double NOT NULL DEFAULT 0 COMMENT 'user get average amount after validity',
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `is_default` enum('1','0') NOT NULL DEFAULT '0',
  `desc` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `name`, `ROI`, `referral_enabled`, `referral_required`, `max_per_user`, `title`, `photo`, `price`, `validity`, `commission_with_avg_amount`, `status`, `is_default`, `desc`, `created_at`, `updated_at`) VALUES
(34, 'Invest plan 0', '1', 0, 0, 1, 'Car', '/upload/package/1761220920EMg.jpg', 300, '90', 1350, 'active', '0', NULL, '2025-10-23 02:21:43', '2025-10-24 17:03:11'),
(35, 'Invest plan 0', '30', 0, 0, 2, 'Car', '/upload/package/17612213290nH.jpg', 1200, '90', 2700, 'active', '0', NULL, '2025-10-23 02:26:11', '2025-10-24 17:09:09'),
(36, 'Invest plan 1', '100', 1, 1, 0, 'Car', '/upload/package/1761221276r24.jpg', 3000, '180', 18000, 'active', '0', NULL, '2025-10-23 02:29:02', '2025-10-23 07:07:56'),
(37, 'Invest plan 2', '150', 1, 5, 0, 'Car', '/upload/package/1761221404f8r.jpg', 5000, '180', 27000, 'active', '0', NULL, '2025-10-23 07:10:04', '2025-10-23 07:10:04'),
(38, 'Invest plan 3', '180', 1, 15, 0, 'Car', '/upload/package/1761221473F6z.jpg', 10000, '180', 32400, 'active', '0', NULL, '2025-10-23 07:11:13', '2025-10-23 07:11:13'),
(39, 'Invest plan 2', '150', 1, 35, 0, 'Car', '/upload/package/1761221633z6o.jpg', 5000, '180', 27000, 'active', '0', NULL, '2025-10-23 07:13:53', '2025-10-23 07:14:54');

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(32) NOT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `photo` varchar(255) NOT NULL,
  `address` text DEFAULT NULL,
  `auto` tinyint(1) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `tag`, `photo`, `address`, `auto`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bkash', 'gtr', '/upload/method/1759957399IFb.webp', '01321195009', 1, 'active', '2024-07-24 21:00:00', '2025-10-17 05:13:04'),
(2, 'Nagad', 'bank_transfer', '/upload/method/1759957425jJA.png', '01321195009', 1, 'active', '2024-07-24 21:00:00', '2025-10-17 05:13:20');

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `daily_income` double(20,2) NOT NULL DEFAULT 0.00,
  `hours` varchar(255) DEFAULT '0',
  `date` varchar(255) NOT NULL,
  `note` text DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `running_status` enum('running','stop') NOT NULL DEFAULT 'stop',
  `validity` varchar(255) DEFAULT NULL,
  `total_return` int(11) NOT NULL DEFAULT 0,
  `count_return` int(11) NOT NULL DEFAULT 0,
  `next_return_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `user_id`, `package_id`, `amount`, `daily_income`, `hours`, `date`, `note`, `status`, `running_status`, `validity`, `total_return`, `count_return`, `next_return_date`, `created_at`, `updated_at`) VALUES
(1146, 5405, 35, 1200, 30.00, '0', '24-10-2025 20:28', NULL, 'active', 'running', '2026-01-22 20:28:33', 90, 0, '2025-10-25 20:28:33', '2025-10-24 14:28:33', '2025-10-24 14:28:33'),
(1147, 5405, 34, 300, 15.00, '0', '24-10-2025 23:11', NULL, 'active', 'running', '2026-01-22 23:11:04', 90, 0, '2025-10-25 23:11:04', '2025-10-24 17:11:04', '2025-10-24 17:11:04');

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

--
-- Table structure for table `referral_bonus_claims`
--

CREATE TABLE `referral_bonus_claims` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `level_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `claimed_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 `referral_levels`
--

CREATE TABLE `referral_levels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `target_count` int(10) UNSIGNED NOT NULL,
  `reward_amount` decimal(12,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `referral_levels`
--

INSERT INTO `referral_levels` (`id`, `target_count`, `reward_amount`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 7, 250.00, 1, '2025-10-18 19:21:43', '2025-10-24 17:46:18'),
(2, 15, 500.00, 1, '2025-10-18 19:26:01', '2025-10-24 17:47:24'),
(3, 1, 30.00, 1, '2025-10-21 14:06:30', '2025-10-23 07:12:39'),
(4, 3, 150.00, 1, '2025-10-21 14:07:00', '2025-10-24 17:43:42'),
(5, 30, 1000.00, 1, '2025-10-24 17:48:31', '2025-10-24 17:48:31'),
(6, 50, 2000.00, 1, '2025-10-24 17:49:57', '2025-10-24 17:49:57');

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

--
-- Table structure for table `user_ledgers`
--

CREATE TABLE `user_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `get_balance_from_user_id` bigint(20) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `reason` varchar(255) NOT NULL,
  `perticulation` varchar(255) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `debit` double NOT NULL DEFAULT 0,
  `credit` double NOT NULL DEFAULT 0,
  `status` enum('pending','approved','rejected','default') NOT NULL DEFAULT 'default',
  `date` varchar(255) DEFAULT NULL,
  `step` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `user_ledgers`
--

INSERT INTO `user_ledgers` (`id`, `user_id`, `get_balance_from_user_id`, `type`, `reason`, `perticulation`, `amount`, `debit`, `credit`, `status`, `date`, `step`, `created_at`, `updated_at`) VALUES
(14908, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-16 14:55:21', NULL, '2025-10-16 08:55:21', '2025-10-16 08:55:21'),
(14909, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 75, 75, 0, 'approved', '16-10-2025 14:55', 'first', '2025-10-16 08:55:21', '2025-10-16 08:55:21'),
(14910, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-16 15:09:15', NULL, '2025-10-16 09:09:15', '2025-10-16 09:09:15'),
(14911, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 75, 75, 0, 'approved', '16-10-2025 15:09', 'first', '2025-10-16 09:09:15', '2025-10-16 09:09:15'),
(14912, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-16 18:03:43', NULL, '2025-10-16 12:03:43', '2025-10-16 12:03:43'),
(14913, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 75, 75, 0, 'approved', '16-10-2025 18:03', 'first', '2025-10-16 12:03:43', '2025-10-16 12:03:43'),
(14914, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 5000, 0, 5000, 'approved', '2025-10-16 18:36:25', NULL, '2025-10-16 12:36:25', '2025-10-16 12:36:25'),
(14915, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 1250, 1250, 0, 'approved', '16-10-2025 18:36', 'first', '2025-10-16 12:36:25', '2025-10-16 12:36:25'),
(14916, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-16 19:51:06', NULL, '2025-10-16 13:51:06', '2025-10-16 13:51:06'),
(14917, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 75, 75, 0, 'approved', '16-10-2025 19:51', 'first', '2025-10-16 13:51:06', '2025-10-16 13:51:06'),
(14918, 5401, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-20 15:15:49', NULL, '2025-10-20 09:15:49', '2025-10-20 09:15:49'),
(14919, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 500, 0, 500, 'approved', '2025-10-23 06:05:57', NULL, '2025-10-23 00:05:57', '2025-10-23 00:05:57'),
(14920, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 25, 25, 0, 'approved', '23-10-2025 06:05', 'first', '2025-10-23 00:05:57', '2025-10-23 00:05:57'),
(14921, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 500, 0, 500, 'approved', '2025-10-23 06:34:39', NULL, '2025-10-23 00:34:39', '2025-10-23 00:34:39'),
(14922, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 25, 25, 0, 'approved', '23-10-2025 06:34', 'first', '2025-10-23 00:34:39', '2025-10-23 00:34:39'),
(14923, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 300, 0, 300, 'approved', '2025-10-23 06:35:21', NULL, '2025-10-23 00:35:21', '2025-10-23 00:35:21'),
(14924, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 15, 15, 0, 'approved', '23-10-2025 06:35', 'first', '2025-10-23 00:35:21', '2025-10-23 00:35:21'),
(14925, 5405, NULL, NULL, 'vip_purchase', 'Your vip purchase successfully. thank you', 500, 0, 500, 'approved', '2025-10-23 06:35:30', NULL, '2025-10-23 00:35:30', '2025-10-23 00:35:30'),
(14926, 5401, 5405, NULL, 'refer_bonus', 'Congratulations', 25, 25, 0, 'approved', '23-10-2025 06:35', 'first', '2025-10-23 00:35:30', '2025-10-23 00:35:30'),
(14927, 5405, NULL, NULL, 'vip_purchase', 'Your VIP purchase was successful. Thank you!', 300, 0, 300, 'approved', '2025-10-23 06:49:11', NULL, '2025-10-23 00:49:11', '2025-10-23 00:49:11'),
(14928, 5401, 5405, NULL, 'refer_bonus', 'Congratulations! You received referral income.', 15, 15, 0, 'approved', '23-10-2025 06:49', 'first', '2025-10-23 00:49:11', '2025-10-23 00:49:11'),
(14929, 5405, NULL, NULL, 'vip_purchase', 'Your VIP purchase was successful. Thank you!', 300, 0, 300, 'approved', '2025-10-23 09:42:11', NULL, '2025-10-23 03:42:11', '2025-10-23 03:42:11'),
(14930, 5401, 5405, NULL, 'refer_bonus', 'Congratulations! You received referral income.', 15, 15, 0, 'approved', '23-10-2025 09:42', 'first', '2025-10-23 03:42:11', '2025-10-23 03:42:11'),
(14931, 5405, NULL, NULL, 'vip_purchase', 'Your VIP purchase was successful. Thank you!', 1200, 0, 1200, 'approved', '2025-10-24 20:28:33', NULL, '2025-10-24 14:28:33', '2025-10-24 14:28:33'),
(14932, 5401, 5405, NULL, 'refer_bonus', 'Congratulations! You received referral income.', 60, 60, 0, 'approved', '24-10-2025 20:28', 'first', '2025-10-24 14:28:33', '2025-10-24 14:28:33'),
(14933, 5405, NULL, NULL, 'vip_purchase', 'Your VIP purchase was successful. Thank you!', 300, 0, 300, 'approved', '2025-10-24 23:11:04', NULL, '2025-10-24 17:11:04', '2025-10-24 17:11:04'),
(14934, 5401, 5405, NULL, 'refer_bonus', 'Congratulations! You received referral income.', 15, 15, 0, 'approved', '24-10-2025 23:11', 'first', '2025-10-24 17:11:04', '2025-10-24 17:11:04');

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

--
-- Table structure for table `vip_sliders`
--

CREATE TABLE `vip_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo` varchar(255) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `page_type` enum('home_page','vip_page') NOT NULL DEFAULT 'home_page',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `vip_sliders`
--

INSERT INTO `vip_sliders` (`id`, `photo`, `status`, `page_type`, `created_at`, `updated_at`) VALUES
(1, '/upload/slider/1730425152yBh.jpg', 'active', 'home_page', '2024-11-01 01:39:12', '2024-11-01 01:39:12');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `method_name` varchar(255) DEFAULT NULL,
  `oid` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `amount` decimal(20,2) NOT NULL DEFAULT 0.00,
  `currency` varchar(40) NOT NULL,
  `rate` decimal(20,2) NOT NULL DEFAULT 0.00,
  `charge` decimal(20,2) NOT NULL DEFAULT 0.00,
  `trx` varchar(40) DEFAULT NULL,
  `final_amount` decimal(20,2) NOT NULL DEFAULT 0.00,
  `after_charge` decimal(20,2) NOT NULL DEFAULT 0.00,
  `withdraw_information` text DEFAULT NULL,
  `account_info` text DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending' COMMENT '1=>success, 2=>pending, 3=>cancel,  ',
  `admin_feedback` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for table `admin_ledgers`
--
ALTER TABLE `admin_ledgers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bank_lists`
--
ALTER TABLE `bank_lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bonuses`
--
ALTER TABLE `bonuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bonus_ledgers`
--
ALTER TABLE `bonus_ledgers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `checkins`
--
ALTER TABLE `checkins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `checkins_user_id_foreign` (`user_id`);

--
-- Indexes for table `comings`
--
ALTER TABLE `comings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `commissions`
--
ALTER TABLE `commissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `drows`
--
ALTER TABLE `drows`
  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 `funds`
--
ALTER TABLE `funds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fund_invests`
--
ALTER TABLE `fund_invests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fund_invests_user_id_foreign` (`user_id`),
  ADD KEY `fund_invests_fund_id_foreign` (`fund_id`);

--
-- Indexes for table `hiru_notices`
--
ALTER TABLE `hiru_notices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `improvments`
--
ALTER TABLE `improvments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lucky_ledgers`
--
ALTER TABLE `lucky_ledgers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lucky_ledgers_user_id_foreign` (`user_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `minings`
--
ALTER TABLE `minings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `minings_user_id_foreign` (`user_id`),
  ADD KEY `minings_package_id_foreign` (`package_id`);

--
-- Indexes for table `notices`
--
ALTER TABLE `notices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchases_user_id_foreign` (`user_id`),
  ADD KEY `purchases_package_id_foreign` (`package_id`);

--
-- Indexes for table `referral_bonus_claims`
--
ALTER TABLE `referral_bonus_claims`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_bonus_claims_user_id_level_id_unique` (`user_id`,`level_id`),
  ADD KEY `referral_bonus_claims_level_id_foreign` (`level_id`);

--
-- Indexes for table `referral_levels`
--
ALTER TABLE `referral_levels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_levels_target_count_unique` (`target_count`);

--
-- Indexes for table `user_ledgers`
--
ALTER TABLE `user_ledgers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vip_sliders`
--
ALTER TABLE `vip_sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `admin_ledgers`
--
ALTER TABLE `admin_ledgers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_lists`
--
ALTER TABLE `bank_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1002;

--
-- AUTO_INCREMENT for table `bonuses`
--
ALTER TABLE `bonuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT for table `bonus_ledgers`
--
ALTER TABLE `bonus_ledgers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `checkins`
--
ALTER TABLE `checkins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `comings`
--
ALTER TABLE `comings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2066;

--
-- AUTO_INCREMENT for table `drows`
--
ALTER TABLE `drows`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `funds`
--
ALTER TABLE `funds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fund_invests`
--
ALTER TABLE `fund_invests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hiru_notices`
--
ALTER TABLE `hiru_notices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `improvments`
--
ALTER TABLE `improvments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lucky_ledgers`
--
ALTER TABLE `lucky_ledgers`
  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=30;

--
-- AUTO_INCREMENT for table `minings`
--
ALTER TABLE `minings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1148;

--
-- AUTO_INCREMENT for table `referral_bonus_claims`
--
ALTER TABLE `referral_bonus_claims`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_levels`
--
ALTER TABLE `referral_levels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `user_ledgers`
--
ALTER TABLE `user_ledgers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14935;

--
-- AUTO_INCREMENT for table `vip_sliders`
--
ALTER TABLE `vip_sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1708;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `checkins`
--
ALTER TABLE `checkins`
  ADD CONSTRAINT `checkins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `fund_invests`
--
ALTER TABLE `fund_invests`
  ADD CONSTRAINT `fund_invests_fund_id_foreign` FOREIGN KEY (`fund_id`) REFERENCES `funds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fund_invests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lucky_ledgers`
--
ALTER TABLE `lucky_ledgers`
  ADD CONSTRAINT `lucky_ledgers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referral_bonus_claims`
--
ALTER TABLE `referral_bonus_claims`
  ADD CONSTRAINT `referral_bonus_claims_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `referral_levels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referral_bonus_claims_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

