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

START TRANSACTION;



--
-- Database: `northfield_investment_banking`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admins_email_unique` (`email`),
  UNIQUE KEY `admins_username_unique` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `email`, `username`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'admin@email.com', 'admin', NULL, '$2y$12$wp1XiTVjUpo7Df1y0EIcYOfj5BqjavzBViGnclS.bZ1eRrlh30UpO', NULL, NULL, NULL);

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

--
-- Table structure for table `bank_charges`
--

CREATE TABLE IF NOT EXISTS `bank_charges` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `currency_conversion` int(11) NOT NULL,
  `cost_of_transfer` int(11) NOT NULL,
  `tax_revenue` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_charges`
--

INSERT INTO `bank_charges` (`id`, `currency_conversion`, `cost_of_transfer`, `tax_revenue`, `created_at`, `updated_at`) VALUES
(1, 10, 15, 10, NULL, NULL);

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

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

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `images`
--

CREATE TABLE IF NOT EXISTS `images` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `img` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `img`, `created_at`, `updated_at`) VALUES
(1, '1612611454WhatsApp Image 2021-02-05 at 10.35.18 AM.jpeg', '2021-02-06 10:37:34', '2021-02-06 10:37:34');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 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),
(4, '2020_01_01_153023_create_admins_table', 1),
(5, '2020_01_01_153247_create_images_table', 1),
(6, '2020_01_01_153529_create_transactions_table', 1),
(10, '2020_01_01_154111_create_transfers_table', 4),
(9, '2020_07_26_124331_create_bank_charges_table', 3);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `currbal` int(11) NOT NULL,
  `ref` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `debit` int(11) DEFAULT NULL,
  `credit` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_user_id_index` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` (`id`, `user_id`, `currbal`, `ref`, `description`, `debit`, `credit`, `created_at`, `updated_at`) VALUES
(1, 8, 94461, 'CITI-63980845', 'Fund Transfer of 5538 From 3944832280/emeka mbachu To benefitiary/4444444444 Reference: CITI-63980845', 5538, NULL, '2020-05-13 23:00:00', '2020-05-18 17:52:24'),
(2, 8, 94231, 'SFB-67757845', 'Fund Transfer of 230 From 1111111111/emeka mbachu To name of ben/444444 Reference: SFB-67757845', 230, NULL, '2020-08-01 16:35:42', '2020-08-01 16:35:42'),
(3, 8, 94197, 'SFB-89201995', 'Fund Transfer of 34 From 1111111111/emeka mbachu To benefitiary/555555 Reference: SFB-89201995', 34, NULL, '2020-10-06 19:19:20', '2020-10-06 19:19:20'),
(4, 8, 93753, 'SFB-94712019', 'Fund Transfer of 444 From 1111111111/emeka mbachu To benefitiary/3333 Reference: SFB-94712019', 444, NULL, '2020-12-23 18:37:28', '2020-12-23 18:37:28'),
(5, 8, 93676, 'SFB-89859345', 'Fund Transfer of 77 From 1111111111/emeka mbachu To benefitiary/88888888888 Reference: SFB-89859345', 77, NULL, '2021-01-23 17:04:15', '2021-01-23 17:04:15'),
(6, 8, 93231, 'SFB-80352796', 'Fund Transfer of 445 From 1111111111/emeka mbachu To benefitiary/3333333 Reference: SFB-80352796', 445, NULL, '2021-01-26 09:12:27', '2021-01-26 09:12:27'),
(7, 8, 93143, 'SFB-42125900', 'Fund Transfer of 88 From 1111111111/Dexter Neutron To benefitiary/0000000 Reference: SFB-42125900', 88, NULL, '2021-03-04 08:47:38', '2021-03-04 08:47:38'),
(8, 8, 93110, 'SFB-62374404', 'Fund Transfer of 33 From 1111111111/Dexter Neutron To benefitiary/44444444444444 Reference: SFB-62374404', 33, NULL, '2021-06-28 13:57:17', '2021-06-28 13:57:17');

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

--
-- Table structure for table `transfers`
--

CREATE TABLE IF NOT EXISTS `transfers` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `recbank` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recaccname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recaccnum` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost_of_transfer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_of_transfer_charge` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amt` int(11) NOT NULL,
  `currency_conversion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_conversion_charge` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_revenue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_revenue_charge` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'incomplete',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transfers_user_id_index` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transfers`
--

INSERT INTO `transfers` (`id`, `user_id`, `recbank`, `recaccname`, `recaccnum`, `cost_of_transfer`, `cost_of_transfer_charge`, `otp`, `amt`, `currency_conversion`, `currency_conversion_charge`, `description`, `ref`, `tax_revenue`, `tax_revenue_charge`, `status`, `created_at`, `updated_at`) VALUES
(6, 8, 'bank', 'name of ben', '9988888888', 'SFB-8541', '%15, $51.6', NULL, 344, 'SFB-68188885', '%10, $34.4', 'iiiiiiiiiiiiiiiiiiiiiiiiiiiii', 'SFB-07522223', NULL, NULL, 'incomplete', '2020-08-24 12:19:32', '2020-08-24 14:24:23'),
(5, 8, 'bank', 'name of ben', '444444', 'SFB-2193', '%15, $34.5', 'SFB2356', 230, 'SFB-50355091', '%10, $23', NULL, 'SFB-67757845', 'SFB-124232', '%10, $23', 'complete', '2020-08-01 15:26:10', '2020-08-01 16:35:42'),
(7, 8, 'Citigroup', 'benefitiary', '4444444444444', NULL, NULL, NULL, 8, 'SFB-65269801', '%10, $0.8', 'rrrrrrrrrrrrr', 'SFB-73720629', NULL, NULL, 'incomplete', '2020-09-19 18:38:31', '2020-09-19 18:38:31'),
(8, 8, 'Truist Financial', 'benefitiary', '555555', NULL, NULL, 'MTF0379', 34, NULL, NULL, 'gggggggggggggggggg', 'SFB-89201995', NULL, NULL, 'complete', '2020-10-06 19:12:05', '2020-10-06 19:19:20'),
(9, 8, 'Citigroup', 'benefitiary', '3333', 'COT3346', NULL, 'BCB1180', 444, NULL, NULL, 'kf]fl]f ff]lf lggl glg]glg [glg]lg g[lg]', 'SFB-94712019', NULL, NULL, 'complete', '2020-12-23 18:31:18', '2020-12-23 18:37:28'),
(10, 8, 'bank name', 'benefitiary', '88888888888', NULL, NULL, 'BCB9404', 77, NULL, NULL, NULL, 'SFB-89859345', NULL, NULL, 'complete', '2021-01-23 17:03:15', '2021-01-23 17:04:15'),
(11, 8, 'TD Bank, N.A.', 'benefitiary', '3333333', NULL, NULL, 'BCB1962', 445, NULL, NULL, 'k[oktt[tktkt', 'SFB-80352796', NULL, NULL, 'complete', '2021-01-26 09:07:23', '2021-01-26 09:12:27'),
(12, 8, 'bank name', 'benefitiary', '0000000', NULL, NULL, 'BCB8489', 88, NULL, NULL, NULL, 'SFB-42125900', NULL, NULL, 'complete', '2021-03-04 08:42:43', '2021-03-04 08:47:38'),
(13, 8, 'bank name', 'name of ben', '99999', NULL, NULL, 'BCB4780', 999, NULL, NULL, 'jjjjj', 'SFB-19788877', NULL, NULL, 'incomplete', '2021-03-19 20:46:49', '2021-03-19 20:53:59'),
(14, 8, 'TIAA', 'benefitiary', '44444444444444', NULL, NULL, 'BCB5677', 33, NULL, NULL, 'fmfopmfplfmpf pfmfpofnf', 'SFB-62374404', NULL, NULL, 'complete', '2021-06-28 13:53:59', '2021-06-28 13:57:17');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `is_active` tinyint(11) NOT NULL DEFAULT '0',
  `fname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_backup` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dob` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accnum` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `acctype` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accbal` int(11) NOT NULL DEFAULT '0',
  `pin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `credit_card_number_one` text COLLATE utf8mb4_unicode_ci,
  `credit_card_number_two` text COLLATE utf8mb4_unicode_ci,
  `payment_status` tinyint(1) NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_accnum_unique` (`accnum`),
  KEY `users_image_id_index` (`image_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `image_id`, `is_active`, `fname`, `lname`, `email`, `email_verified_at`, `password`, `password_backup`, `mobile`, `dob`, `gender`, `address`, `state`, `country`, `accnum`, `acctype`, `accbal`, `pin`, `credit_card_number_one`, `credit_card_number_two`, `payment_status`, `remember_token`, `created_at`, `updated_at`) VALUES
(19, NULL, 1, 'Dexter', 'Neutron', 'neutrondeveloper@gmail.com', NULL, '$2y$10$PhX0nP0SmZ2kdSWkTz3WwOYCwEzXhgpOyx5FFeTaF4hVrv7eVmO8m', '11111111', '0000000000', '2021-09-22', 'Male', '13rWB8DnHgoPQJ8r79gnMaDkFDG9FSNVVd', 'Tasmania', 'Australia', '1111111111', 'Savings Account', 0, '1111', '8830652249498248', '1075717028849598', 1, NULL, '2021-09-19 13:32:23', '2021-09-19 13:32:23');
COMMIT;

