--
-- Host: localhost    Database: loan_website
-- ------------------------------------------------------


--
-- Table structure for table `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`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `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 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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` VALUES (25,796000.00,6,7960.00,11,'PENDING',NULL,'2022-10-25 09:00:45','2022-10-25 09:00:45','669647397945199',1),(26,147000.00,6,1470.00,13,'PENDING',NULL,'2022-10-25 09:35:22','2022-10-25 09:35:22','669647397945199',1),(27,70000.00,36,700.00,15,'APPROVE',NULL,'2022-10-25 10:06:07','2022-10-25 11:50:14','669647397945199',1),(28,210000.00,12,2100.00,16,'REJECT',NULL,'2022-10-25 10:16:22','2022-10-26 06:05:49','669647397945199',1),(29,70000.00,36,700.00,17,'APPROVED',NULL,'2022-10-25 10:25:54','2023-03-23 10:26:52','669647397945199',1),(30,70000.00,36,700.00,14,'APPROVE',NULL,'2022-10-25 11:02:12','2022-10-26 04:20:25','669647397945199',1),(31,70000.00,36,700.00,18,'APPROVE',NULL,'2022-10-25 12:33:37','2022-10-26 06:56:31','669647397945199',1),(32,70000.00,24,700.00,19,'APPROVE',NULL,'2022-10-25 13:24:26','2022-10-27 07:52:13','669647397945199',1),(33,50000.00,24,500.00,16,'APPROVE',NULL,'2022-10-26 06:12:30','2022-10-26 06:24:28','669647397945199',1),(34,50000.00,12,500.00,22,'APPROVE',NULL,'2022-10-26 07:11:50','2022-10-26 08:53:27','669647397945199',1),(35,50000.00,36,500.00,23,'APPROVE',NULL,'2022-10-26 07:54:33','2022-10-27 05:31:53','669647397945199',1),(36,70000.00,12,700.00,21,'APPROVE',NULL,'2022-10-26 09:52:53','2022-10-26 10:40:27','669647397945199',1),(37,300000.00,24,3000.00,20,'PENDING',NULL,'2022-10-26 10:08:34','2022-10-26 10:08:34','669647397945199',1),(38,50000.00,24,500.00,24,'PENDING',NULL,'2022-10-26 10:50:12','2022-10-26 10:50:12','669647397945199',1),(39,50000.00,36,500.00,25,'PENDING',NULL,'2022-10-26 13:00:32','2022-10-26 13:00:32','669647397945199',1),(40,50000.00,24,500.00,26,'APPROVE',NULL,'2022-10-26 13:05:32','2022-10-27 06:07:31','669647397945199',1),(41,50000.00,36,500.00,27,'APPROVE',NULL,'2022-10-26 13:14:34','2022-10-27 05:24:15','669647397945199',1),(42,50000.00,12,500.00,28,'PENDING',NULL,'2022-10-26 14:03:43','2022-10-26 14:03:43','669647397945199',1),(43,50000.00,36,500.00,23,'PENDING',NULL,'2022-10-27 06:10:30','2022-10-27 06:10:30','669647397945199',1),(44,940000.00,6,9400.00,32,'PENDING',NULL,'2022-10-27 06:40:36','2022-10-27 06:40:36','669647397945199',1),(45,50000.00,36,500.00,33,'APPROVE',NULL,'2022-10-27 07:08:49','2022-10-27 09:05:30','669647397945199',1),(46,50000.00,24,500.00,30,'APPROVE',NULL,'2022-10-27 07:13:23','2022-10-27 08:11:11','669647397945199',1),(47,284000.00,24,2840.00,34,'PENDING',NULL,'2022-10-27 07:48:20','2022-10-27 07:48:20','669647397945199',1),(48,70000.00,24,700.00,35,'APPROVE',NULL,'2022-10-27 08:28:25','2022-10-27 09:10:59','669647397945199',1),(49,50000.00,12,500.00,37,'APPROVE',NULL,'2022-10-27 10:12:23','2022-10-27 11:37:09','669647397945199',1),(50,100000.00,24,1000.00,36,'PENDING',NULL,'2022-10-27 10:13:04','2022-10-27 10:13:04','669647397945199',1),(51,300000.00,36,3000.00,38,'REJECT',NULL,'2022-10-27 10:21:15','2022-10-27 12:43:24','669647397945199',1),(52,50000.00,6,500.00,39,'REJECT',NULL,'2022-10-27 12:43:45','2022-10-30 13:01:55','669647397945199',1),(53,250000.00,36,2500.00,38,'APPROVE',NULL,'2022-10-27 12:45:24','2022-10-27 12:47:37','669647397945199',1),(54,50000.00,36,500.00,40,'REJECT',NULL,'2022-10-27 12:52:16','2022-10-28 06:00:17','669647397945199',1),(55,50000.00,24,500.00,41,'APPROVE',NULL,'2022-10-28 05:39:39','2022-10-28 07:01:00','669647397945199',1),(56,500000.00,36,5000.00,40,'APPROVE',NULL,'2022-10-28 06:36:17','2022-10-28 07:31:33','669647397945199',1),(57,50000.00,24,500.00,41,'PENDING',NULL,'2022-10-28 11:02:06','2022-10-28 11:02:06','669647397945199',1),(58,174000.00,36,1740.00,42,'APPROVE',NULL,'2022-10-29 07:15:57','2022-10-29 08:19:40','669647397945199',1),(59,50000.00,6,500.00,43,'PENDING',NULL,'2022-10-29 09:05:17','2022-10-29 09:05:17','669647397945199',1),(60,100000.00,6,1000.00,44,'APPROVE',NULL,'2022-10-29 09:54:47','2022-10-29 11:53:32','669647397945199',1),(61,756000.00,24,7560.00,46,'REJECT',NULL,'2022-10-30 07:30:37','2022-10-30 10:39:18','669647397945199',1),(62,50000.00,24,500.00,48,'PENDING',NULL,'2022-10-30 10:33:33','2022-10-30 10:33:33','669647397945199',1),(63,59000.00,12,590.00,49,'REJECT',NULL,'2022-10-30 10:47:45','2022-11-05 03:07:46','669647397945199',1),(64,150000.00,36,1500.00,50,'PENDING',NULL,'2022-10-30 11:04:43','2022-10-30 11:04:43','669647397945199',1),(65,958000.00,6,9580.00,51,'PENDING',NULL,'2022-10-30 12:52:56','2022-10-30 12:52:56','669647397945199',1),(66,50000.00,24,500.00,52,'PENDING',NULL,'2022-10-30 14:02:44','2022-10-30 14:02:44','669647397945199',1),(67,50000.00,24,500.00,53,'PENDING',NULL,'2022-10-30 14:45:03','2022-10-30 14:45:03','669647397945199',1),(68,100000.00,12,1000.00,54,'APPROVE',NULL,'2022-10-31 05:21:57','2022-10-31 06:22:28','669647397945199',1),(69,100000.00,36,1000.00,55,'APPROVE',NULL,'2022-10-31 05:43:21','2022-10-31 11:44:44','669647397945199',1),(70,10000.00,6,100.00,56,'APPROVE',NULL,'2022-10-31 05:52:21','2022-10-31 06:24:45','669647397945199',1),(71,40000.00,36,400.00,57,'PENDING',NULL,'2022-10-31 06:13:44','2022-10-31 06:13:44','669647397945199',1),(72,50000.00,36,500.00,58,'PENDING',NULL,'2022-10-31 08:32:15','2022-10-31 08:32:15','669647397945199',1),(73,50000.00,24,500.00,59,'PENDING',NULL,'2022-10-31 08:34:52','2022-10-31 08:34:52','669647397945199',1),(74,614000.00,6,6140.00,60,'APPROVE',NULL,'2022-10-31 12:29:16','2022-10-31 13:12:27','669647397945199',1),(75,62000.00,6,620.00,60,'PENDING',NULL,'2022-10-31 13:37:43','2022-10-31 13:37:43','669647397945199',1),(76,50000.00,12,500.00,54,'PENDING',NULL,'2022-11-01 01:16:07','2022-11-01 01:16:07','669647397945199',1),(77,150000.00,24,1500.00,61,'PENDING',NULL,'2022-11-01 04:17:33','2022-11-01 04:17:33','669647397945199',1),(78,50000.00,12,500.00,62,'APPROVE',NULL,'2022-11-01 05:55:21','2022-11-02 03:28:02','669647397945199',1),(79,82000.00,6,820.00,63,'PENDING',NULL,'2022-11-01 06:18:42','2022-11-01 06:18:42','669647397945199',1),(80,100000.00,24,1000.00,65,'APPROVE',NULL,'2022-11-01 06:51:19','2022-11-01 11:10:20','669647397945199',1),(81,300000.00,24,3000.00,67,'REJECT',NULL,'2022-11-01 07:31:46','2022-11-01 13:45:29','669647397945199',1),(82,50000.00,6,500.00,68,'PENDING',NULL,'2022-11-01 08:00:51','2022-11-01 08:00:51','669647397945199',1),(83,81000.00,36,810.00,66,'PENDING',NULL,'2022-11-01 08:29:51','2022-11-01 08:29:51','669647397945199',1),(84,100000.00,36,1000.00,69,'APPROVE',NULL,'2022-11-01 09:04:12','2022-11-01 09:50:26','669647397945199',1),(85,812000.00,24,8120.00,70,'PENDING',NULL,'2022-11-01 09:05:33','2022-11-01 09:05:33','669647397945199',1),(86,10000.00,6,100.00,71,'REJECT',NULL,'2022-11-01 09:24:46','2022-11-02 12:16:50','669647397945199',1),(87,80000.00,12,800.00,67,'APPROVE',NULL,'2022-11-01 13:51:00','2022-11-01 13:55:12','669647397945199',1),(88,70000.00,24,700.00,76,'APPROVE',NULL,'2022-11-02 14:34:09','2022-11-03 07:42:12','669647397945199',1),(89,50000.00,36,500.00,71,'APPROVE',NULL,'2022-11-03 02:35:22','2022-11-03 02:58:59','669647397945199',1),(90,50000.00,36,500.00,77,'APPROVE',NULL,'2022-11-03 04:00:14','2022-11-03 04:01:34','669647397945199',1),(91,50000.00,36,500.00,78,'APPROVE',NULL,'2022-11-03 04:52:24','2022-11-03 05:15:37','669647397945199',1),(92,50000.00,36,500.00,71,'REJECT',NULL,'2022-11-03 07:09:46','2022-11-03 07:41:55','669647397945199',1),(93,20000.00,6,200.00,77,'APPROVE',NULL,'2022-11-03 08:57:05','2022-11-03 08:57:42','669647397945199',1),(94,5000.00,6,50.00,79,'REJECT',NULL,'2022-11-05 01:23:45','2022-11-05 03:08:42','669647397945199',1),(95,50000.00,12,500.00,79,'APPROVE',NULL,'2022-11-05 03:51:11','2022-11-05 04:08:37','669647397945199',1),(96,91000.00,12,910.00,82,'APPROVE',NULL,'2022-11-05 09:43:29','2022-11-05 11:57:08','669647397945199',1),(97,30000.00,12,300.00,84,'PENDING',NULL,'2022-11-05 10:16:49','2022-11-05 10:16:49','669647397945199',1),(98,50000.00,24,500.00,86,'APPROVE',NULL,'2022-11-05 11:35:49','2022-11-06 02:08:43','669647397945199',1),(99,70000.00,24,700.00,87,'PENDING',NULL,'2022-11-05 12:45:28','2022-11-05 12:45:28','669647397945199',1),(100,150000.00,12,1500.00,88,'APPROVE',NULL,'2022-11-06 03:17:57','2022-11-06 07:54:53','669647397945199',1),(101,100000.00,24,1000.00,89,'APPROVE',NULL,'2022-11-06 03:34:02','2022-11-08 10:02:46','669647397945199',1),(102,50000.00,24,500.00,90,'APPROVE',NULL,'2022-11-06 03:43:42','2022-11-06 05:22:45','669647397945199',1),(103,50000.00,36,500.00,91,'PENDING',NULL,'2022-11-06 03:47:06','2022-11-06 03:47:06','669647397945199',1),(104,50000.00,24,500.00,92,'APPROVE',NULL,'2022-11-06 05:49:54','2022-11-08 10:09:56','669647397945199',1),(105,70000.00,36,700.00,93,'APPROVE',NULL,'2022-11-06 05:55:52','2022-11-06 06:30:31','669647397945199',1),(106,50000.00,12,500.00,95,'APPROVE',NULL,'2022-11-06 06:07:51','2022-11-08 10:06:35','669647397945199',1),(107,200000.00,24,2000.00,96,'APPROVE',NULL,'2022-11-06 06:20:42','2022-11-08 10:04:42','669647397945199',1),(108,50000.00,6,500.00,98,'APPROVE',NULL,'2022-11-06 06:21:44','2022-11-08 10:03:15','669647397945199',1),(109,50000.00,36,500.00,99,'PENDING',NULL,'2022-11-06 07:12:55','2022-11-06 07:12:55','669647397945199',1),(110,50000.00,36,500.00,100,'APPROVE',NULL,'2022-11-06 07:50:55','2022-11-08 10:01:15','669647397945199',1),(111,170000.00,36,1700.00,101,'PENDING',NULL,'2022-11-06 08:17:48','2022-11-06 08:17:48','669647397945199',1),(112,50000.00,24,500.00,102,'APPROVE',NULL,'2022-11-06 08:29:23','2022-11-08 10:20:45','669647397945199',1),(113,70000.00,24,700.00,103,'APPROVE',NULL,'2022-11-06 09:54:18','2022-11-08 10:08:47','669647397945199',1),(114,62000.00,36,620.00,104,'PENDING',NULL,'2022-11-06 10:30:51','2022-11-06 10:30:51','669647397945199',1),(115,50000.00,24,500.00,106,'PENDING',NULL,'2022-11-06 12:13:08','2022-11-06 12:13:08','669647397945199',1),(116,50000.00,36,500.00,107,'PENDING',NULL,'2022-11-06 13:27:29','2022-11-06 13:27:29','669647397945199',1),(117,50000.00,24,500.00,108,'APPROVE',NULL,'2022-11-07 03:54:31','2022-11-08 11:05:33','669647397945199',1),(118,50000.00,24,500.00,109,'PENDING',NULL,'2022-11-07 06:44:25','2022-11-07 06:44:25','669647397945199',1),(119,50000.00,6,500.00,98,'REJECT',NULL,'2022-11-08 12:38:02','2022-11-08 14:32:29','669647397945199',1),(120,127000.00,24,1270.00,113,'PENDING',NULL,'2022-11-10 05:23:28','2022-11-10 05:23:28','669647397945199',1),(121,779000.00,12,7790.00,114,'PENDING',NULL,'2022-11-10 07:53:28','2022-11-10 07:53:28','669647397945199',1),(122,50000.00,36,500.00,116,'PENDING',NULL,'2022-11-10 09:17:58','2022-11-10 09:17:58','669647397945199',1),(123,100000.00,24,1000.00,118,'PENDING',NULL,'2022-11-10 09:59:03','2022-11-10 09:59:03','669647397945199',1),(124,779000.00,36,7790.00,119,'PENDING',NULL,'2022-11-24 09:57:28','2022-11-24 09:57:28','669647397945199',1),(125,1000000.00,12,21000.00,120,'APPROVE',NULL,'2023-03-20 10:49:50','2023-03-20 11:20:09','669647397945199',1),(126,7.00,6,0.05,120,'APPROVE',NULL,'2023-03-20 11:55:53','2023-03-22 07:37:25','669647397945199',1),(127,80000.00,6,375.00,135,'PENDING',NULL,'2023-03-22 06:55:27','2023-03-22 06:55:27','669647397945199',1),(128,1000000.00,6,15000.00,134,'PENDING',NULL,'2023-03-22 10:12:15','2023-03-22 10:12:15','669647397945199',1),(129,600000.00,6,3000.00,123,'REJECT','2023-03-23 08:53:31','2023-03-23 05:00:44','2023-03-23 08:53:31','728899037499238',1),(130,100000.00,12,500.00,123,'PENDING','2023-03-23 08:55:22','2023-03-23 08:54:48','2023-03-23 08:55:22','291691061134776',1),(131,80000.00,6,375.00,123,'PENDING','2023-03-23 09:08:58','2023-03-23 08:55:30','2023-03-23 09:08:58','841254387404607',1),(132,80000.00,6,375.00,123,'PENDING','2023-03-23 09:09:49','2023-03-23 09:09:09','2023-03-23 09:09:49','354810625004091',1),(133,80000.00,6,375.00,123,'APPROVED',NULL,'2023-03-23 09:10:00','2023-03-23 10:28:00','162484454008647',1),(134,80000.00,6,375.00,136,'APPROVED',NULL,'2023-03-23 10:31:19','2023-03-23 10:32:31','393363317604176',1),(135,80000.00,6,375.00,137,'UNDER REVIEW',NULL,'2023-03-23 18:45:57','2023-03-23 18:45:57','103680498859764',1),(136,80000.00,6,375.00,139,'APPROVED',NULL,'2023-03-24 16:57:41','2023-03-24 17:23:50','593475221754579',1),(137,80000.00,6,375.00,141,'APPROVED',NULL,'2023-03-25 10:09:00','2023-03-30 16:45:34','891448711571527',1),(138,168000.00,6,840.00,142,'Under Review','2023-03-27 09:16:26','2023-03-27 09:16:26','2023-03-27 09:16:26','724319585102388',0),(139,7500.00,6,37.50,144,'Under Review','2023-03-27 14:11:29','2023-03-27 14:11:29','2023-03-27 14:11:29','716473288370748',0),(140,80000.00,6,375.00,146,'Under Review','2023-03-30 16:40:40','2023-03-30 16:40:40','2023-03-30 16:40:40','138317116668244',0),(141,80000.00,12,375.00,146,'Under Review','2023-03-30 16:45:14','2023-03-30 16:45:14','2023-03-30 16:45:14','263317942135728',0);

--
-- Table structure for table `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`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

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

--
-- Table structure for table `order_statuses`
--

CREATE TABLE `order_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int 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 DEFAULT NULL,
  `background_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `step_number` int NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_statuses`
--

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

--
-- Table structure for table `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`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

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

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `feature_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `order` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` VALUES (1,'assets/images/banner-sliders/slide1.jpg',1,1,NULL,'2023-03-01 12:59:23','2023-03-01 12:59:23'),(2,'assets/images/banner-sliders/slide2.jpg',1,6,NULL,'2023-03-01 13:00:08','2023-03-22 13:10:11'),(3,'assets/images/banner-sliders/slide3.jpg',1,2,NULL,'2023-03-01 13:00:08','2023-03-22 13:00:08'),(4,'assets/images/banner-sliders/slide4.jpg',1,2,NULL,'2023-03-01 13:00:08','2023-03-22 13:00:08'),(5,'assets/images/banner-sliders/slide5.jpg',1,2,NULL,'2023-03-01 13:00:08','2023-03-22 13:00:08'),(6,'assets/images/banner-sliders/slide6.webp',1,2,NULL,'2023-03-01 13:00:08','2023-03-22 13:00:08');

--
-- Table structure for table `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 DEFAULT NULL,
  `status` enum('pending','approve','reject') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `user_id` bigint unsigned 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 DEFAULT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '647853339593808',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` VALUES (38,'credit',70000.00,15,'approve',1,NULL,'2022-10-25 11:50:14','2022-10-25 11:50:14','xx','647853339593808'),(39,'credit',70000.00,14,'approve',1,NULL,'2022-10-26 04:20:26','2022-10-26 04:20:26','xxxx','647853339593808'),(40,'credit',50000.00,16,'approve',1,NULL,'2022-10-26 06:24:28','2022-10-26 06:24:28','xx','647853339593808'),(41,'credit',70000.00,18,'approve',1,NULL,'2022-10-26 06:56:31','2022-10-26 06:56:31','xx','647853339593808'),(42,'credit',50000.00,22,'approve',1,NULL,'2022-10-26 08:53:27','2022-10-26 08:53:27','xx','647853339593808'),(43,'credit',70000.00,21,'approve',1,NULL,'2022-10-26 10:40:27','2022-10-26 10:40:27','xx','647853339593808'),(44,'credit',50000.00,27,'approve',1,NULL,'2022-10-27 05:24:15','2022-10-27 05:24:15','xxx','647853339593808'),(45,'credit',50000.00,23,'approve',1,NULL,'2022-10-27 05:31:53','2022-10-27 05:31:53','xx','647853339593808'),(46,'credit',50000.00,26,'approve',1,NULL,'2022-10-27 06:07:31','2022-10-27 06:07:31',NULL,'647853339593808'),(47,'credit',70000.00,19,'approve',1,NULL,'2022-10-27 07:52:13','2022-10-27 07:52:13',NULL,'647853339593808'),(48,'credit',50000.00,30,'approve',1,NULL,'2022-10-27 08:11:11','2022-10-27 08:11:11','xx','647853339593808'),(49,'credit',50000.00,33,'approve',1,NULL,'2022-10-27 09:05:30','2022-10-27 09:05:30',NULL,'647853339593808'),(50,'credit',70000.00,35,'approve',1,NULL,'2022-10-27 09:10:59','2022-10-27 09:10:59',NULL,'647853339593808'),(51,'credit',50000.00,37,'approve',1,NULL,'2022-10-27 11:37:09','2022-10-27 11:37:09',NULL,'647853339593808'),(52,'credit',300000.00,38,'approve',1,NULL,'2022-10-27 12:43:11','2022-10-27 12:43:11',NULL,'647853339593808'),(53,'debt',300000.00,38,'approve',1,NULL,'2022-10-27 12:43:18','2022-10-27 12:43:18',NULL,'647853339593808'),(54,'credit',300000.00,38,'approve',1,NULL,'2022-10-27 12:43:22','2022-10-27 12:43:22',NULL,'647853339593808'),(55,'debt',300000.00,38,'approve',1,NULL,'2022-10-27 12:43:24','2022-10-27 12:43:24',NULL,'647853339593808'),(56,'credit',250000.00,38,'approve',1,NULL,'2022-10-27 12:47:38','2022-10-27 12:47:38',NULL,'647853339593808'),(57,'credit',50000.00,41,'approve',1,NULL,'2022-10-28 07:01:00','2022-10-28 07:01:00',NULL,'647853339593808'),(58,'credit',500000.00,40,'approve',1,NULL,'2022-10-28 07:31:33','2022-10-28 07:31:33',NULL,'647853339593808'),(59,'credit',174000.00,42,'approve',1,NULL,'2022-10-29 08:19:40','2022-10-29 08:19:40',NULL,'647853339593808'),(60,'credit',100000.00,44,'approve',1,NULL,'2022-10-29 11:53:32','2022-10-29 11:53:32',NULL,'647853339593808'),(61,'credit',100000.00,54,'approve',1,NULL,'2022-10-31 06:22:28','2022-10-31 06:22:28',NULL,'647853339593808'),(62,'credit',10000.00,56,'approve',1,NULL,'2022-10-31 06:24:45','2022-10-31 06:24:45',NULL,'647853339593808'),(63,'credit',100000.00,55,'approve',1,NULL,'2022-10-31 11:44:44','2022-10-31 11:44:44',NULL,'647853339593808'),(64,'credit',614000.00,60,'approve',1,NULL,'2022-10-31 13:12:27','2022-10-31 13:12:27',NULL,'647853339593808'),(65,'credit',100000.00,69,'approve',1,NULL,'2022-11-01 09:50:26','2022-11-01 09:50:26',NULL,'647853339593808'),(66,'credit',100000.00,65,'approve',1,NULL,'2022-11-01 11:10:20','2022-11-01 11:10:20',NULL,'647853339593808'),(67,'credit',80000.00,67,'approve',1,NULL,'2022-11-01 13:55:12','2022-11-01 13:55:12',NULL,'647853339593808'),(68,'credit',50000.00,62,'approve',1,NULL,'2022-11-02 03:28:02','2022-11-02 03:28:02',NULL,'647853339593808'),(69,'credit',50000.00,71,'approve',1,NULL,'2022-11-03 02:58:59','2022-11-03 02:58:59',NULL,'647853339593808'),(70,'credit',50000.00,77,'approve',1,NULL,'2022-11-03 04:01:34','2022-11-03 04:01:34',NULL,'647853339593808'),(71,'withdraw',50000.00,77,'reject',NULL,'2023-03-23 07:45:21','2022-11-03 04:05:50','2023-03-23 07:45:21',NULL,'647853339593808'),(72,'credit',50000.00,78,'approve',1,NULL,'2022-11-03 05:15:37','2022-11-03 05:15:37',NULL,'647853339593808'),(73,'withdraw',50000.00,71,'reject',NULL,'2023-03-23 07:47:07','2022-11-03 06:49:28','2023-03-23 07:47:07',NULL,'647853339593808'),(74,'credit',70000.00,76,'approve',1,NULL,'2022-11-03 07:42:12','2022-11-03 07:42:12',NULL,'647853339593808'),(75,'credit',20000.00,77,'approve',1,NULL,'2022-11-03 08:57:42','2022-11-03 08:57:42',NULL,'647853339593808'),(76,'withdraw',70000.00,76,'pending',NULL,NULL,'2022-11-03 11:09:21','2022-11-03 11:09:21',NULL,'647853339593808'),(77,'credit',50000.00,79,'approve',1,NULL,'2022-11-05 04:08:37','2022-11-05 04:08:37',NULL,'647853339593808'),(78,'credit',91000.00,82,'approve',1,NULL,'2022-11-05 11:57:08','2022-11-05 11:57:08',NULL,'647853339593808'),(79,'credit',50000.00,86,'approve',1,NULL,'2022-11-06 02:08:43','2022-11-06 02:08:43',NULL,'647853339593808'),(80,'credit',50000.00,90,'approve',1,NULL,'2022-11-06 05:22:45','2022-11-06 05:22:45',NULL,'647853339593808'),(81,'withdraw',50000.00,71,'pending',NULL,NULL,'2022-11-06 05:28:11','2022-11-06 05:28:11',NULL,'647853339593808'),(82,'credit',70000.00,93,'approve',1,NULL,'2022-11-06 06:30:31','2022-11-06 06:30:31',NULL,'647853339593808'),(83,'credit',150000.00,88,'approve',1,NULL,'2022-11-06 07:54:53','2022-11-06 07:54:53',NULL,'647853339593808'),(84,'credit',50000.00,100,'approve',1,NULL,'2022-11-08 10:01:15','2022-11-08 10:01:15',NULL,'647853339593808'),(85,'credit',100000.00,89,'approve',1,NULL,'2022-11-08 10:02:46','2022-11-08 10:02:46',NULL,'647853339593808'),(86,'credit',50000.00,98,'approve',1,NULL,'2022-11-08 10:03:15','2022-11-08 10:03:15',NULL,'647853339593808'),(87,'credit',200000.00,96,'approve',1,NULL,'2022-11-08 10:04:42','2022-11-08 10:04:42',NULL,'647853339593808'),(88,'credit',50000.00,95,'approve',1,NULL,'2022-11-08 10:06:35','2022-11-08 10:06:35',NULL,'647853339593808'),(89,'credit',70000.00,103,'approve',1,NULL,'2022-11-08 10:08:47','2022-11-08 10:08:47',NULL,'647853339593808'),(90,'credit',50000.00,92,'approve',1,NULL,'2022-11-08 10:09:56','2022-11-08 10:09:56',NULL,'647853339593808'),(91,'credit',50000.00,102,'approve',1,NULL,'2022-11-08 10:20:45','2022-11-08 10:20:45',NULL,'647853339593808'),(92,'credit',50000.00,108,'approve',1,NULL,'2022-11-08 11:05:33','2022-11-08 11:05:33',NULL,'647853339593808'),(93,'withdraw',50000.00,98,'reject',NULL,NULL,'2022-11-08 13:07:38','2022-11-08 14:37:59',NULL,'647853339593808'),(94,'withdraw',50000.00,98,'pending',NULL,NULL,'2022-11-09 08:34:42','2022-11-09 08:34:42',NULL,'647853339593808'),(95,'withdraw',200.00,96,'reject',NULL,NULL,'2022-11-10 05:39:49','2022-11-10 05:47:41',NULL,'647853339593808'),(96,'withdraw',220.00,96,'approve',NULL,NULL,'2022-11-10 05:47:41','2023-03-23 06:23:45','trtrtr','647853339593808'),(97,'withdraw',200.00,96,'approve',NULL,NULL,'2022-11-10 05:54:13','2023-03-22 10:12:39','tretretr','647853339593808'),(98,'credit',1000000.00,120,'approve',1,NULL,'2023-03-20 11:20:09','2023-03-20 11:20:09','deretr','647853339593808'),(99,'credit',7.00,120,'approve',1,NULL,'2023-03-22 07:37:25','2023-03-22 07:37:25','xx','647853339593808'),(100,'withdraw',80000.00,123,'approve',NULL,NULL,'2023-03-23 05:06:12','2023-03-23 05:09:33','123456','647853339593808'),(101,'withdraw',80000.00,136,'reject',NULL,NULL,'2023-03-23 10:33:06','2023-03-23 10:35:43','123456','647853339593808'),(102,'withdraw',80000.00,137,'pending',NULL,NULL,'2023-03-24 14:13:17','2023-03-24 14:13:17','1','647853339593808'),(103,'withdraw',80000.00,141,'pending',NULL,NULL,'2023-03-25 13:16:28','2023-03-25 13:16:28','1','222736979235386');

--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `login_area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_browser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_device` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` VALUES (1,2,'Phnom Penh, Cambodia, IP 117.20.113.145','Chrome 108.0.0.0','Linux',NULL,'2023-06-03 15:43:59','2023-06-03 15:43:59'),(2,2,'Phnom Penh, Cambodia, IP 117.20.113.145','Chrome 108.0.0.0','Linux',NULL,'2023-06-03 16:08:32','2023-06-03 16:08:32');

--
-- Table structure for table `withdraw_codes`
--

CREATE TABLE `withdraw_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `withdraw_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned 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`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw_codes`
--

INSERT INTO `withdraw_codes` VALUES (13,'a1g23a',1,'2022-10-29 08:37:15','2022-10-26 04:23:19','2022-10-29 08:37:15',1),(14,'af12c3',1,'2022-10-29 08:37:13','2022-10-28 09:15:09','2022-10-29 08:37:13',1),(15,'fj3k11',1,NULL,'2022-11-03 04:04:00','2022-11-03 04:05:50',0),(16,'ks1a26',1,NULL,'2022-11-03 06:47:00','2022-11-03 06:49:28',0),(17,'ks2p34',1,NULL,'2022-11-03 11:03:43','2022-11-03 11:09:21',0),(18,'f1ki22',1,NULL,'2022-11-06 05:24:29','2022-11-06 05:28:11',0),(19,'ks9m90',1,NULL,'2022-11-08 13:06:30','2022-11-08 13:07:38',0),(20,'fj3k11',1,NULL,'2022-11-09 08:28:42','2022-11-09 08:34:42',0),(21,'fj3k11',1,NULL,'2022-11-10 05:21:42','2022-11-10 05:39:49',0),(22,'fj3k11',1,NULL,'2022-11-10 05:43:53','2022-11-10 05:47:41',0),(23,'fj3k62',1,NULL,'2022-11-10 05:53:01','2022-11-10 05:54:13',0),(24,'xxxx',1,NULL,'2023-03-22 10:13:30','2023-03-22 10:13:30',1);


