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

START TRANSACTION;



--
-- Database: `totalcare`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) 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) COLLATE utf8mb4_unicode_ci 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2021_08_08_120429_create_temp_user_table', 2),
(6, '2021_08_10_165548_create_payments_table', 3),
(7, '2021_08_10_181012_create_settings_table', 4);

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` float(10,2) NOT NULL,
  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sponsor_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sponsor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ifsc_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_date` datetime NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `payment_type` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '0 =qr code, 1=wallet',
  `first_payment_date` date NOT NULL,
  `first_payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `second_payment_date` date NOT NULL,
  `second_payment_status` varchar(255) COLLATE utf8mb4_unicode_ci 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 `payments`
--

INSERT INTO `payments` (`id`, `ticket_id`, `user_id`, `amount`, `fullname`, `mobile`, `sponsor_id`, `sponsor_name`, `state`, `city`, `pin_code`, `payment_mode`, `bank`, `account_number`, `ifsc_code`, `account_holder_name`, `payment_image`, `register_date`, `status`, `payment_type`, `first_payment_date`, `first_payment_status`, `second_payment_date`, `second_payment_status`, `created_at`, `updated_at`) VALUES
(2, 'TC78220121104422', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-21 10:44:22', '1', '1', '2022-01-24', '1', '2022-01-27', '1', '2022-01-21 05:14:22', '2022-01-28 04:51:12'),
(3, 'TC41220121113250', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-21 11:32:50', '1', '1', '2022-01-24', '1', '2022-01-27', '1', '2022-01-21 06:02:50', '2022-01-28 04:51:09'),
(4, 'TC59220121113258', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-21 11:32:58', '1', '1', '2022-01-24', '1', '2022-01-27', '1', '2022-01-21 06:02:58', '2022-01-28 04:51:06'),
(5, 'TC70220124012350', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-24 13:23:50', '1', '1', '2022-01-27', '1', '2022-01-30', '1', '2022-01-24 07:53:50', '2022-01-28 04:51:03'),
(6, 'TC80220126084154', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-26 20:41:54', '1', '1', '2022-01-29', '1', '2022-02-01', '1', '2022-01-26 15:11:54', '2022-01-31 18:30:02'),
(7, 'TC40220130105252', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-30 10:52:52', '1', '1', '2022-02-02', '1', '2022-02-05', '1', '2022-01-30 05:22:52', '2022-02-04 18:30:04'),
(8, 'TC82220130105310', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-30 10:53:10', '1', '1', '2022-02-02', '1', '2022-02-05', '1', '2022-01-30 05:23:10', '2022-02-04 18:30:04'),
(9, 'TC47220130105316', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-30 10:53:16', '1', '1', '2022-02-02', '1', '2022-02-05', '1', '2022-01-30 05:23:16', '2022-02-04 18:30:04'),
(10, 'TC21220130105326', 33, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-30 10:53:26', '1', '1', '2022-02-02', '1', '2022-02-05', '1', '2022-01-30 05:23:26', '2022-02-04 18:30:04'),
(11, 'TC11220131011455', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-01-31 13:14:55', '1', '1', '2022-02-03', '1', '2022-02-06', '1', '2022-01-31 07:44:55', '2022-02-12 13:35:25'),
(12, 'TC80220212043443', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-12 16:34:43', '1', '1', '2022-02-15', '1', '2022-02-18', '1', '2022-02-12 11:04:43', '2022-02-17 18:30:03'),
(13, 'TC71220212043451', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-12 16:34:51', '1', '1', '2022-02-15', '1', '2022-02-18', '1', '2022-02-12 11:04:51', '2022-02-17 18:30:03'),
(14, 'TC10220213091531', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-13 09:15:31', '1', '1', '2022-02-16', '1', '2022-02-19', '1', '2022-02-13 03:45:31', '2022-02-18 18:30:04'),
(15, 'TC73220214092559', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-14 09:25:59', '1', '1', '2022-02-17', '1', '2022-02-20', '0', '2022-02-14 03:55:59', '2022-02-16 18:30:03'),
(16, 'TC96220214092645', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-14 09:26:45', '1', '1', '2022-02-17', '1', '2022-02-20', '0', '2022-02-14 03:56:45', '2022-02-16 18:30:03'),
(17, 'TC30220215024335', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-15 14:43:35', '1', '1', '2022-02-18', '1', '2022-02-21', '0', '2022-02-15 09:13:35', '2022-02-17 18:30:03'),
(18, 'TC75220215024400', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-15 14:44:00', '1', '1', '2022-02-18', '1', '2022-02-21', '0', '2022-02-15 09:14:00', '2022-02-17 18:30:03'),
(19, 'TC69220216080831', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-16 08:08:31', '1', '1', '2022-02-19', '1', '2022-02-22', '0', '2022-02-16 02:38:31', '2022-02-18 18:30:04'),
(20, 'TC95220217101807', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-17 10:18:07', '1', '1', '2022-02-20', '0', '2022-02-23', '0', '2022-02-17 04:48:07', '2022-02-17 04:48:07'),
(21, 'TC61220218122349', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-18 12:23:49', '1', '1', '2022-02-21', '0', '2022-02-24', '0', '2022-02-18 06:53:49', '2022-02-18 06:53:49'),
(22, 'TC34220219103908', 34, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-19 10:39:08', '1', '1', '2022-02-22', '0', '2022-02-25', '0', '2022-02-19 05:09:08', '2022-02-19 05:09:08'),
(23, 'TC88220510101048', 36, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-10 10:10:48', '1', '1', '2022-05-13', '0', '2022-05-16', '0', '2022-05-10 04:40:48', '2022-05-10 04:40:48'),
(24, 'TC27220510102410', 36, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-10 10:24:10', '1', '1', '2022-05-13', '0', '2022-05-16', '0', '2022-05-10 04:54:10', '2022-05-10 04:54:10'),
(25, 'TC72220510102426', 36, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-10 10:24:26', '1', '1', '2022-05-13', '0', '2022-05-16', '0', '2022-05-10 04:54:26', '2022-05-10 04:54:26'),
(26, 'TC84220510103007', 36, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-10 10:30:07', '1', '1', '2022-05-13', '0', '2022-05-16', '0', '2022-05-10 05:00:07', '2022-05-10 05:00:07'),
(27, 'TC67220510104116', 36, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-05-10 10:41:16', '1', '1', '2022-05-13', '0', '2022-05-16', '0', '2022-05-10 05:11:16', '2022-05-10 05:11:16'),
(28, 'TC49240420114013', 37, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-20 11:40:13', '1', '1', '2024-04-23', '0', '2024-04-26', '0', '2024-04-20 06:10:13', '2024-04-20 06:10:13'),
(29, 'TC81250315100639', 37, 1300.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-15 10:06:39', '1', '1', '2025-03-18', '0', '2025-03-21', '0', '2025-03-15 04:36:39', '2025-03-15 04:36:39');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `value_label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value_data` varchar(255) COLLATE utf8mb4_unicode_ci 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 `settings`
--

INSERT INTO `settings` (`id`, `value_label`, `value_data`, `created_at`, `updated_at`) VALUES
(1, 'TICKET_LIMIT', '5', NULL, '2022-01-30 05:25:24');

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

--
-- Table structure for table `temp_user`
--

CREATE TABLE `temp_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `unique_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `purchase_date` datetime 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 `user_wallet`
--

CREATE TABLE `user_wallet` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `referral_user_id` int(11) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `amount` float(10,2) NOT NULL,
  `date` datetime NOT NULL,
  `payment_type` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','2') NOT NULL DEFAULT '1',
  `is_updated` int(11) NOT NULL DEFAULT 0 COMMENT ' 0 => not update in refer case ,\r\n1 = updated on refer',
  `payment_image` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_wallet`
--

INSERT INTO `user_wallet` (`id`, `user_id`, `referral_user_id`, `payment_id`, `amount`, `date`, `payment_type`, `status`, `is_updated`, `payment_image`, `created_at`, `updated_at`) VALUES
(5, 33, NULL, NULL, 12345.00, '2022-01-21 08:56:15', 14, '1', 0, '1642735575-payment-image.png', '2022-01-21 08:56:15', '2022-01-21 10:44:02'),
(6, 33, NULL, 2, 1300.00, '2022-01-21 10:44:22', 11, '1', 0, NULL, '2022-01-21 10:44:22', '2022-01-21 10:44:22'),
(7, 33, NULL, NULL, 500.00, '2022-01-21 11:32:00', 3, '1', 0, NULL, '2022-01-21 11:32:00', '2022-01-21 11:43:23'),
(8, 33, NULL, NULL, 579.00, '2022-01-21 11:32:14', 3, '1', 0, NULL, '2022-01-21 11:32:14', '2022-01-21 11:43:21'),
(9, 33, NULL, NULL, 6570.00, '2022-01-21 11:32:38', 4, '1', 0, NULL, '2022-01-21 11:32:38', '2022-01-21 11:43:02'),
(10, 33, NULL, 3, 1300.00, '2022-01-21 11:32:50', 11, '1', 0, NULL, '2022-01-21 11:32:50', '2022-01-21 11:32:50'),
(11, 33, NULL, 4, 1300.00, '2022-01-21 11:32:58', 11, '1', 0, NULL, '2022-01-21 11:32:58', '2022-01-21 11:32:58'),
(12, 33, NULL, 2, 1000.00, '2022-01-24 00:00:05', 6, '1', 0, NULL, '2022-01-24 00:00:05', '2022-01-24 00:00:05'),
(13, 33, NULL, 3, 1000.00, '2022-01-24 00:00:05', 6, '1', 0, NULL, '2022-01-24 00:00:05', '2022-01-24 00:00:05'),
(14, 33, NULL, 4, 1000.00, '2022-01-24 00:00:05', 6, '1', 0, NULL, '2022-01-24 00:00:05', '2022-01-24 00:00:05'),
(15, 33, NULL, 5, 1300.00, '2022-01-24 13:23:50', 11, '1', 0, NULL, '2022-01-24 13:23:50', '2022-01-24 13:23:50'),
(16, 33, NULL, NULL, 133.00, '2022-01-25 10:10:00', 14, '1', 0, '1643085600-payment-image.png', '2022-01-25 10:10:00', '2022-01-25 10:41:02'),
(17, 33, NULL, 6, 1300.00, '2022-01-26 20:41:54', 11, '1', 0, NULL, '2022-01-26 20:41:54', '2022-01-26 20:41:54'),
(18, 33, NULL, NULL, 100.00, '2022-01-26 21:14:52', 14, '1', 0, '1643211892-payment-image.jpg', '2022-01-26 21:14:52', '2022-01-26 21:17:54'),
(19, 33, NULL, 5, 1000.00, '2022-01-28 10:20:55', 6, '1', 0, NULL, '2022-01-28 10:20:55', '2022-01-28 10:20:55'),
(20, 33, NULL, 5, 1000.00, '2022-01-28 10:21:03', 7, '1', 0, NULL, '2022-01-28 10:21:03', '2022-01-28 10:21:03'),
(21, 33, NULL, 4, 1000.00, '2022-01-28 10:21:06', 7, '1', 0, NULL, '2022-01-28 10:21:06', '2022-01-28 10:21:06'),
(22, 33, NULL, 3, 1000.00, '2022-01-28 10:21:09', 7, '1', 0, NULL, '2022-01-28 10:21:09', '2022-01-28 10:21:09'),
(23, 33, NULL, 2, 1000.00, '2022-01-28 10:21:12', 7, '1', 0, NULL, '2022-01-28 10:21:12', '2022-01-28 10:21:12'),
(24, 33, NULL, 6, 1000.00, '2022-01-29 00:00:04', 6, '1', 0, NULL, '2022-01-29 00:00:04', '2022-01-29 00:00:04'),
(25, 34, NULL, NULL, 8799.00, '2022-01-29 09:48:53', 14, '1', 0, '1643429933-payment-image.mp4', '2022-01-29 09:48:53', '2022-01-30 10:55:07'),
(26, 33, NULL, 7, 1300.00, '2022-01-30 10:52:52', 11, '1', 0, NULL, '2022-01-30 10:52:52', '2022-01-30 10:52:52'),
(27, 33, NULL, 8, 1300.00, '2022-01-30 10:53:10', 11, '1', 0, NULL, '2022-01-30 10:53:10', '2022-01-30 10:53:10'),
(28, 33, NULL, 9, 1300.00, '2022-01-30 10:53:16', 11, '1', 0, NULL, '2022-01-30 10:53:16', '2022-01-30 10:53:16'),
(29, 33, NULL, 10, 1300.00, '2022-01-30 10:53:26', 11, '1', 0, NULL, '2022-01-30 10:53:26', '2022-01-30 10:53:26'),
(30, 34, 35, NULL, 100.00, '2022-01-31 13:14:20', 5, '2', 0, NULL, '2022-01-31 13:14:20', '2022-01-31 13:14:20'),
(31, 34, NULL, 11, 1300.00, '2022-01-31 13:14:55', 11, '1', 0, NULL, '2022-01-31 13:14:55', '2022-01-31 13:14:55'),
(32, 33, NULL, 6, 1000.00, '2022-02-01 00:00:02', 7, '1', 0, NULL, '2022-02-01 00:00:02', '2022-02-01 00:00:02'),
(33, 33, NULL, 7, 1000.00, '2022-02-02 00:00:02', 6, '1', 0, NULL, '2022-02-02 00:00:02', '2022-02-02 00:00:02'),
(34, 33, NULL, 8, 1000.00, '2022-02-02 00:00:02', 6, '1', 0, NULL, '2022-02-02 00:00:02', '2022-02-02 00:00:02'),
(35, 33, NULL, 9, 1000.00, '2022-02-02 00:00:02', 6, '1', 0, NULL, '2022-02-02 00:00:02', '2022-02-02 00:00:02'),
(36, 33, NULL, 10, 1000.00, '2022-02-02 00:00:02', 6, '1', 0, NULL, '2022-02-02 00:00:02', '2022-02-02 00:00:02'),
(37, 34, NULL, 11, 1000.00, '2022-02-03 00:00:04', 6, '1', 0, NULL, '2022-02-03 00:00:04', '2022-02-03 00:00:04'),
(38, 33, NULL, 7, 1000.00, '2022-02-05 00:00:04', 7, '1', 0, NULL, '2022-02-05 00:00:04', '2022-02-05 00:00:04'),
(39, 33, NULL, 8, 1000.00, '2022-02-05 00:00:04', 7, '1', 0, NULL, '2022-02-05 00:00:04', '2022-02-05 00:00:04'),
(40, 33, NULL, 9, 1000.00, '2022-02-05 00:00:04', 7, '1', 0, NULL, '2022-02-05 00:00:04', '2022-02-05 00:00:04'),
(41, 33, NULL, 10, 1000.00, '2022-02-05 00:00:04', 7, '1', 0, NULL, '2022-02-05 00:00:04', '2022-02-05 00:00:04'),
(42, 34, NULL, 12, 1300.00, '2022-02-12 16:34:43', 11, '1', 0, NULL, '2022-02-12 16:34:43', '2022-02-12 16:34:43'),
(43, 34, NULL, 13, 1300.00, '2022-02-12 16:34:51', 11, '1', 0, NULL, '2022-02-12 16:34:51', '2022-02-12 16:34:51'),
(44, 34, NULL, 11, 1000.00, '2022-02-12 19:05:25', 7, '1', 0, NULL, '2022-02-12 19:05:25', '2022-02-12 19:05:25'),
(45, 34, NULL, 14, 1300.00, '2022-02-13 09:15:31', 11, '1', 0, NULL, '2022-02-13 09:15:31', '2022-02-13 09:15:31'),
(46, 34, NULL, 15, 1300.00, '2022-02-14 09:25:59', 11, '1', 0, NULL, '2022-02-14 09:25:59', '2022-02-14 09:25:59'),
(47, 34, NULL, 16, 1300.00, '2022-02-14 09:26:45', 11, '1', 0, NULL, '2022-02-14 09:26:45', '2022-02-14 09:26:45'),
(48, 34, NULL, 12, 1000.00, '2022-02-15 00:00:03', 6, '1', 0, NULL, '2022-02-15 00:00:03', '2022-02-15 00:00:03'),
(49, 34, NULL, 13, 1000.00, '2022-02-15 00:00:03', 6, '1', 0, NULL, '2022-02-15 00:00:03', '2022-02-15 00:00:03'),
(50, 34, NULL, 17, 1300.00, '2022-02-15 14:43:35', 11, '1', 0, NULL, '2022-02-15 14:43:35', '2022-02-15 14:43:35'),
(51, 34, NULL, 18, 1300.00, '2022-02-15 14:44:00', 11, '1', 0, NULL, '2022-02-15 14:44:00', '2022-02-15 14:44:00'),
(52, 34, NULL, 14, 1000.00, '2022-02-16 00:00:02', 6, '1', 0, NULL, '2022-02-16 00:00:02', '2022-02-16 00:00:02'),
(53, 34, NULL, 19, 1300.00, '2022-02-16 08:08:31', 11, '1', 0, NULL, '2022-02-16 08:08:31', '2022-02-16 08:08:31'),
(54, 34, NULL, 15, 1000.00, '2022-02-17 00:00:03', 6, '1', 0, NULL, '2022-02-17 00:00:03', '2022-02-17 00:00:03'),
(55, 34, NULL, 16, 1000.00, '2022-02-17 00:00:03', 6, '1', 0, NULL, '2022-02-17 00:00:03', '2022-02-17 00:00:03'),
(56, 34, NULL, 20, 1300.00, '2022-02-17 10:18:07', 11, '1', 0, NULL, '2022-02-17 10:18:07', '2022-02-17 10:18:07'),
(57, 34, NULL, 12, 1000.00, '2022-02-18 00:00:03', 7, '1', 0, NULL, '2022-02-18 00:00:03', '2022-02-18 00:00:03'),
(58, 34, NULL, 13, 1000.00, '2022-02-18 00:00:03', 7, '1', 0, NULL, '2022-02-18 00:00:03', '2022-02-18 00:00:03'),
(59, 34, NULL, 17, 1000.00, '2022-02-18 00:00:03', 6, '1', 0, NULL, '2022-02-18 00:00:03', '2022-02-18 00:00:03'),
(60, 34, NULL, 18, 1000.00, '2022-02-18 00:00:03', 6, '1', 0, NULL, '2022-02-18 00:00:03', '2022-02-18 00:00:03'),
(61, 34, NULL, 21, 1300.00, '2022-02-18 12:23:49', 11, '1', 0, NULL, '2022-02-18 12:23:49', '2022-02-18 12:23:49'),
(62, 34, NULL, 19, 1000.00, '2022-02-19 00:00:04', 6, '1', 0, NULL, '2022-02-19 00:00:04', '2022-02-19 00:00:04'),
(63, 34, NULL, 14, 1000.00, '2022-02-19 00:00:04', 7, '1', 0, NULL, '2022-02-19 00:00:04', '2022-02-19 00:00:04'),
(64, 34, NULL, 22, 1300.00, '2022-02-19 10:39:08', 11, '1', 0, NULL, '2022-02-19 10:39:08', '2022-02-19 10:39:08'),
(65, 36, NULL, NULL, 10000.00, '2022-05-10 10:08:59', 14, '1', 0, '1652157539-payment-image.jpg', '2022-05-10 10:08:59', '2022-05-10 10:09:38'),
(66, 36, NULL, 23, 1300.00, '2022-05-10 10:10:48', 11, '1', 0, NULL, '2022-05-10 10:10:48', '2022-05-10 10:10:48'),
(67, 36, NULL, 24, 1300.00, '2022-05-10 10:24:10', 11, '1', 0, NULL, '2022-05-10 10:24:10', '2022-05-10 10:24:10'),
(68, 36, NULL, 25, 1300.00, '2022-05-10 10:24:26', 11, '1', 0, NULL, '2022-05-10 10:24:26', '2022-05-10 10:24:26'),
(69, 36, NULL, 26, 1300.00, '2022-05-10 10:30:07', 11, '1', 0, NULL, '2022-05-10 10:30:07', '2022-05-10 10:30:07'),
(70, 36, NULL, 27, 1300.00, '2022-05-10 10:41:16', 11, '1', 0, NULL, '2022-05-10 10:41:16', '2022-05-10 10:41:16'),
(71, 37, NULL, NULL, 15000.00, '2024-04-20 11:33:49', 14, '1', 0, '1713593029-payment-image.jpg', '2024-04-20 11:33:49', '2024-04-20 11:39:36'),
(72, 37, NULL, 28, 1300.00, '2024-04-20 11:40:13', 11, '1', 0, NULL, '2024-04-20 11:40:13', '2024-04-20 11:40:13'),
(73, 37, NULL, 29, 1300.00, '2025-03-15 10:06:39', 11, '1', 0, NULL, '2025-03-15 10:06:39', '2025-03-15 10:06:39'),
(74, 37, NULL, NULL, 500.00, '2025-03-15 10:20:30', 1, '1', 0, NULL, '2025-03-15 10:20:30', '2025-03-15 10:20:30');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `user_wallet`
--
ALTER TABLE `user_wallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
COMMIT;

