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

START TRANSACTION;



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

--
-- 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 `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');
COMMIT;

