/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 100432 (10.4.32-MariaDB)
 Source Host           : localhost:3306
 Source Schema         : loan_website

 Target Server Type    : MySQL
 Target Server Version : 100432 (10.4.32-MariaDB)
 File Encoding         : 65001

 Date: 25/09/2024 08:46:41
*/


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

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

-- ----------------------------
-- Table structure for images
-- ----------------------------
CREATE TABLE `images`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `feature_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `page_to_display` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'home',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `order` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of images
-- ----------------------------

-- ----------------------------
-- Table structure for loans
-- ----------------------------
CREATE TABLE `loans`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `amount` double(15, 2) NOT NULL DEFAULT 0.00,
  `loan_period` int NOT NULL DEFAULT 0,
  `interest` double(15, 2) NOT NULL DEFAULT 1.00,
  `member_id` bigint UNSIGNED NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UNDER REVIEW',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `loan_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '669647397945199',
  `is_member_information_completed` tinyint(1) NOT NULL DEFAULT 1,
  `interest_rate` double(15, 5) NOT NULL DEFAULT 0.00100,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of loans
-- ----------------------------
INSERT INTO `loans` VALUES (1, 698000.00, 6, 3490.00, 1, 'Under Review', '2024-09-15 00:14:15', '2024-09-03 17:22:00', '2024-09-15 00:14:15', '880037677022383', 1, 0.00100);
INSERT INTO `loans` VALUES (2, 75000.00, 36, 0.50, 2, 'Under Review', '2024-09-15 00:09:32', '2024-09-14 16:18:19', '2024-09-15 00:09:32', '216751982341206', 1, 0.00100);
INSERT INTO `loans` VALUES (3, 75000.00, 36, 0.50, 2, 'Under Review', '2024-09-15 00:14:04', '2024-09-15 00:10:43', '2024-09-15 00:14:04', '697025056014539', 1, 0.00100);
INSERT INTO `loans` VALUES (4, 630000.00, 6, 31.50, 2, 'Under Review', '2024-09-15 00:57:52', '2024-09-15 00:57:52', '2024-09-15 00:57:52', '248354332930064', 0, 0.00300);
INSERT INTO `loans` VALUES (5, 75000.00, 36, 0.50, 2, 'Under Review', NULL, '2024-09-15 01:07:00', '2024-09-15 01:07:00', '793422373658225', 1, 0.00100);
INSERT INTO `loans` VALUES (6, 2260000.00, 36, 0.50, 3, 'Under Review', '2024-09-16 17:26:36', '2024-09-16 17:26:35', '2024-09-16 17:26:36', '291432662446042', 0, 0.00100);
INSERT INTO `loans` VALUES (7, 640000.00, 12, 0.50, 3, 'Under Review', NULL, '2024-09-16 17:29:50', '2024-09-16 17:29:50', '635120417514669', 1, 0.00100);

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2013_10_09_150305_create_roles_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (3, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (4, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (5, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (6, '2022_10_09_150518_create_members_table', 1);
INSERT INTO `migrations` VALUES (7, '2022_10_09_150526_create_transactions_table', 1);
INSERT INTO `migrations` VALUES (8, '2022_10_09_153147_create_settings_table', 1);
INSERT INTO `migrations` VALUES (9, '2022_10_09_153159_create_slides_table', 1);
INSERT INTO `migrations` VALUES (10, '2022_10_10_151126_create_withdraw_codes_table', 1);
INSERT INTO `migrations` VALUES (11, '2022_10_17_150237_create_loans_table', 2);
INSERT INTO `migrations` VALUES (12, '2022_10_20_135559_add_is_active_to_withdraw_codes_table', 3);
INSERT INTO `migrations` VALUES (14, '2023_03_20_185036_add_credit_score_to_members_table', 4);
INSERT INTO `migrations` VALUES (15, '2023_03_20_193808_add_amount_to_account_to_members_table', 5);
INSERT INTO `migrations` VALUES (17, '2023_03_20_194325_add_loan_id_to_loan_table', 6);
INSERT INTO `migrations` VALUES (18, '2023_03_20_233533_add_withdrawal_code_to_members_dd_paid_to_users_table', 7);
INSERT INTO `migrations` VALUES (19, '2023_03_22_181940_remove_withdrawal_code_id_table', 8);
INSERT INTO `migrations` VALUES (32, '2023_03_22_190943_remove_credit_to_accounts_table', 9);
INSERT INTO `migrations` VALUES (33, '2023_03_22_194508_create_order_statuses_table', 9);
INSERT INTO `migrations` VALUES (34, '2023_03_23_170012_add_add_background-color_and_text_color_to_order_statuses_table', 10);
INSERT INTO `migrations` VALUES (35, '2023_03_23_185438_add_company_name_to_members_table', 11);
INSERT INTO `migrations` VALUES (36, '2023_03_24_195757_add_transaction_number_to_transactions_table', 12);
INSERT INTO `migrations` VALUES (37, '2023_03_24_235254_add_step_number_to_order_statuses_table', 13);
INSERT INTO `migrations` VALUES (38, '2023_03_25_165902_add_add_is_information_complated_table', 14);
INSERT INTO `migrations` VALUES (39, '2023_03_25_203644_add_is_admin_to_users_table', 15);
INSERT INTO `migrations` VALUES (41, '2023_03_27_213306_add_registration_area_to_users_table', 16);
INSERT INTO `migrations` VALUES (43, '2023_04_01_233426_add_note_to_members_table', 17);
INSERT INTO `migrations` VALUES (44, '2023_06_01_003320_create_user_logins_table', 17);
INSERT INTO `migrations` VALUES (45, '2023_10_29_211425_create_notifications_table', 18);
INSERT INTO `migrations` VALUES (46, '2023_10_23_225015_add_interest_rate_to_loans', 19);
INSERT INTO `migrations` VALUES (47, '2023_10_24_222647_add_facebook_name_to_members_table', 19);
INSERT INTO `migrations` VALUES (48, '2023_10_24_232030_create_images_table', 19);
INSERT INTO `migrations` VALUES (49, '2024_01_13_164306_add_telephone_members_table', 20);
INSERT INTO `migrations` VALUES (50, '2024_01_15_162829_add_other_info_img_to_members', 20);

-- ----------------------------
-- Table structure for notifications
-- ----------------------------
CREATE TABLE `notifications`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `already_read` tinyint(1) NOT NULL DEFAULT 0,
  `member_id` bigint UNSIGNED NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notifications
-- ----------------------------

-- ----------------------------
-- Table structure for order_statuses
-- ----------------------------
CREATE TABLE `order_statuses`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `order` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `text_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `background_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `step_number` int NOT NULL DEFAULT 2,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_statuses
-- ----------------------------
INSERT INTO `order_statuses` VALUES (1, 'INSURANCE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:20:29', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (2, 'INVALID CARD NUMBEROR BANK ACCOUNT NUMBER', 2, NULL, '2023-03-23 16:02:56', '2023-03-23 17:20:34', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (3, 'GAMBLING', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:20:43', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (4, 'WITHDRAWAL SUCCESSFULLY', 1, NULL, '2023-03-23 16:02:56', '2023-03-25 00:20:41', 'white', '#28a745', 4);
INSERT INTO `order_statuses` VALUES (5, 'INSUFFICIENT CREDIT', 2, NULL, '2023-03-23 16:02:56', '2023-03-24 23:55:21', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (6, 'FREEZE LOAN ACCOUNT', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:21:36', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (7, 'SUCCESSFULLY APPLICATION', 3, NULL, '2023-03-23 16:02:56', '2023-03-24 23:56:46', 'white', '#28a745', 2);
INSERT INTO `order_statuses` VALUES (8, 'APPROVED', 3, NULL, '2023-03-23 16:02:56', '2023-10-26 01:00:30', 'white', 'green', 3);
INSERT INTO `order_statuses` VALUES (9, 'VIP CHANNEL', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:21:55', 'white', '#28a745', 2);
INSERT INTO `order_statuses` VALUES (10, 'HANDLING FEE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:06', 'white', 'blue', 2);
INSERT INTO `order_statuses` VALUES (11, 'OVERDUE RECORD', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:11', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (12, 'INLAND REVENUE TAX', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:15', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (13, 'BANK ACCOUNT INVOLVING ILLEGAL ACTIVITY', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:20', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (14, 'LOAN ACCOUNT IS INSURED', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:25', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (15, 'LIFE INSURANCE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:35', 'white', 'green', 2);
INSERT INTO `order_statuses` VALUES (16, 'NEW DOCUMENT AND NEW OTP CODE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:41', 'white', '#28a745', 2);
INSERT INTO `order_statuses` VALUES (17, 'CONFIRMED NEW OTP CODE AND NEW DOCUMENTARY', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:45', 'whtie', '#28a745', 2);
INSERT INTO `order_statuses` VALUES (18, 'UNFROZEN ACCOUNT', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:51', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (19, 'PLATEFORM FEE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:22:58', 'white', '#28a745', 2);
INSERT INTO `order_statuses` VALUES (20, 'INVALID CARD NUMBER OR BANK ACCOUNT NUMBER', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:23:02', 'whtie', 'red', 2);
INSERT INTO `order_statuses` VALUES (21, 'INSURANCE', 1, NULL, '2023-03-23 16:02:56', '2023-03-23 17:08:23', 'white', 'red', 2);
INSERT INTO `order_statuses` VALUES (22, 'PENDING', 100, NULL, '2023-03-23 17:10:47', '2023-10-26 01:00:54', 'white', 'orange', 2);
INSERT INTO `order_statuses` VALUES (23, 'REJECTED', 10, NULL, '2023-10-26 01:01:33', '2023-10-26 01:01:33', 'white', 'red', 2);

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------

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

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'Admin', NULL, '2022-10-10 16:02:44', '2022-10-10 16:02:44');
INSERT INTO `roles` VALUES (2, 'Member', NULL, '2022-10-10 16:02:44', '2022-10-10 16:02:44');

-- ----------------------------
-- Table structure for slides
-- ----------------------------
CREATE TABLE `slides`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `feature_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `order` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of slides
-- ----------------------------
INSERT INTO `slides` VALUES (1, 'images/1698241655.1.jpg', 1, 1, '2024-09-25 00:42:11', '2023-03-01 19:59:23', '2024-09-25 00:42:11');
INSERT INTO `slides` VALUES (2, 'images/1698241691.5.jpg', 1, 6, '2024-09-25 00:42:00', '2023-03-01 20:00:08', '2024-09-25 00:42:00');
INSERT INTO `slides` VALUES (3, 'images/1727196160.sl1.jpg', 1, 1, NULL, '2023-03-01 20:00:08', '2024-09-25 00:42:40');
INSERT INTO `slides` VALUES (4, 'images/1698241855.7.png', 1, 2, '2024-09-04 19:03:29', '2023-03-01 20:00:08', '2024-09-04 19:03:29');
INSERT INTO `slides` VALUES (5, 'images/1698241684.4.jpg', 1, 2, '2024-09-04 19:03:21', '2023-03-01 20:00:08', '2024-09-04 19:03:21');
INSERT INTO `slides` VALUES (6, 'images/1727196184.c5deaba69073aaa9f9649795bd5d9d10.png', 1, 2, NULL, '2023-03-01 20:00:08', '2024-09-25 00:43:04');
INSERT INTO `slides` VALUES (7, 'images/1725530925.ads1.webp', 1, NULL, '2024-09-05 19:24:30', '2024-09-05 17:53:57', '2024-09-05 19:24:30');
INSERT INTO `slides` VALUES (8, 'images/1725535522.wallet001.png', 1, 1, '2024-09-05 19:25:29', '2024-09-05 19:25:22', '2024-09-05 19:25:29');

-- ----------------------------
-- Table structure for transactions
-- ----------------------------
CREATE TABLE `transactions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `transaction_type` enum('credit','debt','deposit','witdraw','withdraw') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(15, 2) NOT NULL DEFAULT 0.00,
  `member_id` bigint UNSIGNED NULL DEFAULT NULL,
  `status` enum('pending','approve','reject') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `withdraw_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '647853339593808',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of transactions
-- ----------------------------
INSERT INTO `transactions` VALUES (1, 'withdraw', 698000.00, 1, 'approve', NULL, NULL, '2024-09-03 17:32:28', '2024-09-04 18:59:50', '1111', '354962619522979');

-- ----------------------------
-- Table structure for user_logins
-- ----------------------------
CREATE TABLE `user_logins`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `login_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `login_browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `login_device` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_logins
-- ----------------------------
INSERT INTO `user_logins` VALUES (1, 1, 'Phnom Penh, Cambodia, IP 117.20.113.143', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-04 18:58:22', '2024-09-04 18:58:22');
INSERT INTO `user_logins` VALUES (2, 4, 'California, United States, IP 66.102.0.0', 'Chrome 126.0.0.0', 'Windows', NULL, '2024-09-05 13:15:02', '2024-09-05 13:15:02');
INSERT INTO `user_logins` VALUES (3, 4, 'California, United States, IP 66.102.0.0', 'Chrome 126.0.0.0', 'Windows', NULL, '2024-09-05 19:26:51', '2024-09-05 19:26:51');
INSERT INTO `user_logins` VALUES (4, 1, 'Phnom Penh, Cambodia, IP 27.109.114.246', 'Chrome 126.0.0.0', 'Windows', NULL, '2024-09-05 19:49:37', '2024-09-05 19:49:37');
INSERT INTO `user_logins` VALUES (5, 4, 'California, United States, IP 66.102.0.0', 'Chrome 126.0.0.0', 'Windows', NULL, '2024-09-05 19:52:02', '2024-09-05 19:52:02');
INSERT INTO `user_logins` VALUES (6, 1, 'Phnom Penh, Cambodia, IP 117.20.116.25', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 00:08:50', '2024-09-15 00:08:50');
INSERT INTO `user_logins` VALUES (7, 5, 'California, United States, IP 66.102.0.0', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 00:10:36', '2024-09-15 00:10:36');
INSERT INTO `user_logins` VALUES (8, 1, 'Phnom Penh, Cambodia, IP 117.20.116.25', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 00:13:50', '2024-09-15 00:13:50');
INSERT INTO `user_logins` VALUES (9, 5, 'Phnom Penh, Cambodia, IP 117.20.116.25', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 00:15:09', '2024-09-15 00:15:09');
INSERT INTO `user_logins` VALUES (10, 5, 'California, United States, IP 66.102.0.0', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 01:06:51', '2024-09-15 01:06:51');
INSERT INTO `user_logins` VALUES (11, 5, 'California, United States, IP 66.102.0.0', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 01:17:16', '2024-09-15 01:17:16');
INSERT INTO `user_logins` VALUES (12, 5, 'California, United States, IP 66.102.0.0', 'Edge 128.0.0.0', 'Windows', NULL, '2024-09-15 19:30:31', '2024-09-15 19:30:31');
INSERT INTO `user_logins` VALUES (13, 4, 'California, United States, IP 66.102.0.0', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-18 18:04:54', '2024-09-18 18:04:54');
INSERT INTO `user_logins` VALUES (14, 4, 'California, United States, IP 66.102.0.0', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-18 19:32:24', '2024-09-18 19:32:24');
INSERT INTO `user_logins` VALUES (15, 5, 'Phnom Penh, Cambodia, IP 117.20.115.183', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-18 23:50:31', '2024-09-18 23:50:31');
INSERT INTO `user_logins` VALUES (16, 4, 'Phnom Penh, Cambodia, IP 117.20.115.183', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-19 13:25:43', '2024-09-19 13:25:43');
INSERT INTO `user_logins` VALUES (17, 4, 'Phnom Penh, Cambodia, IP 117.20.115.183', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-19 13:26:08', '2024-09-19 13:26:08');
INSERT INTO `user_logins` VALUES (18, 1, 'Phnom Penh, Cambodia, IP 27.109.114.79', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-24 19:47:47', '2024-09-24 19:47:47');
INSERT INTO `user_logins` VALUES (19, 5, 'Phnom Penh, Cambodia, IP 27.109.114.79', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-24 19:50:18', '2024-09-24 19:50:18');
INSERT INTO `user_logins` VALUES (20, 5, 'Phnom Penh, Cambodia, IP 27.109.113.170', 'Chrome 129.0.0.0', 'Windows', NULL, '2024-09-25 00:40:32', '2024-09-25 00:40:32');
INSERT INTO `user_logins` VALUES (21, 5, 'Phnom Penh, Cambodia, IP 27.109.113.170', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-25 00:40:56', '2024-09-25 00:40:56');
INSERT INTO `user_logins` VALUES (22, 1, 'Phnom Penh, Cambodia, IP 27.109.113.170', 'Chrome 129.0.0.0', 'Windows', NULL, '2024-09-25 00:41:27', '2024-09-25 00:41:27');
INSERT INTO `user_logins` VALUES (23, 7, 'Phnom Penh, Cambodia, IP 27.109.113.170', 'Chrome 128.0.0.0', 'Windows', NULL, '2024-09-25 01:28:27', '2024-09-25 01:28:27');
INSERT INTO `user_logins` VALUES (24, 5, 'Phnom Penh, , IP 27.109.114.252', 'Chrome 129.0.0.0', 'Windows', NULL, '2024-09-25 09:27:49', '2024-09-25 09:27:49');

-- ----------------------------
-- Table structure for withdraw_codes
-- ----------------------------
CREATE TABLE `withdraw_codes`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `withdraw_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of withdraw_codes
-- ----------------------------

