--
-- Host: localhost    Database: lifecashlendingcooperation2
-- ------------------------------------------------------


--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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=24 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-10-25 18:00:30','white','green',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-10-25 18:00:54','white','orange',2),(23,'REJECTED',10,NULL,'2023-10-25 18:01:33','2023-10-25 18:01:33','white','red',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,'images/1698241655.1.jpg',1,1,NULL,'2023-03-01 12:59:23','2023-10-25 14:47:35'),(2,'images/1698241691.5.jpg',1,6,NULL,'2023-03-01 13:00:08','2023-10-25 14:48:11'),(3,'images/1698241661.2.jpg',1,2,NULL,'2023-03-01 13:00:08','2023-10-25 14:47:41'),(4,'images/1698241855.7.png',1,2,NULL,'2023-03-01 13:00:08','2023-10-25 14:50:55'),(5,'images/1698241684.4.jpg',1,2,NULL,'2023-03-01 13:00:08','2023-10-25 14:48:04'),(6,'assets/images/banner-sliders/slide6.webp',0,2,NULL,'2023-03-01 13:00:08','2023-10-25 14:48:29');

--
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '647853339593808',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_device` varchar(255) CHARACTER SET utf8mb4 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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



