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

START TRANSACTION;



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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cards`
--

CREATE TABLE `cards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `residential_address` varchar(255) NOT NULL,
  `registration_token` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date` date NOT NULL DEFAULT '2024-06-21',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `reference_id` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `date` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `card_number` varchar(255) DEFAULT NULL,
  `cvv` varchar(255) DEFAULT NULL,
  `card_expiry_date` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `occupation` varchar(255) NOT NULL,
  `reference_id` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  `type` varchar(255) NOT NULL,
  `income` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(68, '0001_01_01_000000_create_users_table', 1),
(69, '0001_01_01_000001_create_cache_table', 1),
(70, '0001_01_01_000002_create_jobs_table', 1),
(71, '2024_06_17_094404_create_admins_table', 1),
(72, '2024_06_17_094737_create_masters_table', 1),
(73, '2024_06_18_142211_create_transfers_table', 1),
(74, '2024_06_18_142448_create_transactions_table', 1),
(75, '2024_06_18_142719_create_notifications_table', 1),
(76, '2024_06_18_143116_create_deposits_table', 1),
(77, '2024_06_18_143909_create_verification_codes_table', 1),
(78, '2024_06_18_143948_create_transfer_codes_table', 1),
(79, '2024_06_19_222234_create_loans_table', 1),
(80, '2024_06_20_083219_create_contacts_table', 1),
(81, '2024_06_20_091543_create_cards_table', 1);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notification` longtext NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `uuid`, `type`, `notification`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'cf692281-e939-4c04-b2f2-fcdb2cc8daf2', 'CREDIT', 'Realtime Bank Acct holder:Test User CREDIT: ₦10,000.00 Desc:Profit for trade DT:2024-06-21 Available Bal:₦14,841.67 Status: Successful', 2, '2024-06-21 10:24:13', '2024-06-21 10:24:13'),
(2, '4fd541ae-7cc0-4f3f-aadc-72c5e4e3b3d0', 'CREDIT', 'Realtime Bank Acct holder:Claudia Ankunding CREDIT: ₩50,000.00 Desc:Profit for trade DT:2024-06-21 Available Bal:₩50,358.67 Status: Successful', 1, '2024-06-21 10:32:46', '2024-06-21 10:32:46'),
(3, '6c37d336-e8f2-47eb-aa13-fc4c9f9606fb', 'CREDIT', 'Realtime Bank Acct holder:Claudia Ankunding CREDIT: ₩10,000.00 Desc:Profit for trade DT:2024-06-21 Available Bal:₩60,358.67 Status: Successful', 1, '2024-06-21 10:38:37', '2024-06-21 10:38:37'),
(4, 'e9c07a3a-4cf4-47b9-aaee-8b5e911e871c', 'CREDIT', 'Realtime Bank Acct holder:Claudia Ankunding CREDIT: ₩10,000.00 Desc:Cost of Deduction DT:2024-06-21 Available Bal:₩70,358.67 Status: Successful', 1, '2024-06-21 10:40:30', '2024-06-21 10:40:30'),
(5, '53a50088-ec86-4aff-b8cd-79c482ac2ca9', 'Quality Maintenance', 'This is to inform you that your acount will be disabled in 40days time lol 😂😂😂', 1, '2024-06-21 10:42:22', '2024-06-21 10:42:22'),
(6, '8a450e2f-fd70-457e-a2c5-ad132a916836', 'DEBIT', 'Realtime Bank Acct holder:Test User DEBIT: ₦560.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-06-21 Available Bal:₦14,281.67 Status: Successful', 2, '2024-06-21 21:11:57', '2024-06-21 21:11:57'),
(7, 'a1d11ae1-9cee-491a-8de9-0c3f1b66f9d1', 'DEBIT', 'Realtime Bank Acct holder:Claudia Ankunding DEBIT: ₩4,000.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-06-22 Available Bal:₩66,358.67 Status: Successful', 1, '2024-06-22 05:22:24', '2024-06-22 05:22:24'),
(8, '592c73e0-920e-4ba3-89b5-0b9235b89170', 'DEBIT', 'Realtime Bank Acct holder:Claudia Ankunding DEBIT: ₩3,000.00 Desc:Profit for trade DT:2024-06-22 Available Bal:₩63,358.67 Status: Successful', 1, '2024-06-22 06:05:51', '2024-06-22 06:05:51'),
(9, '061db056-71a8-4f4b-b2d1-30523a92ca2e', 'DEBIT', 'Realtime Bank Acct holder:Test User DEBIT: ₦10,000.00 Desc:Electronic TF: Money Gram/ DT:2024-06-23 Available Bal:₦14,281.67 Status: Failed', 2, '2024-06-23 15:34:02', '2024-06-23 15:34:02'),
(10, 'af9c3dd6-d750-40df-9b0d-9e1c7990f56d', 'DEBIT', 'Realtime Bank Acct holder:Claudia Ankunding DEBIT: ₩500.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-06-23 Available Bal:₩62,858.67 Status: Successful', 1, '2024-06-23 15:40:32', '2024-06-23 15:40:32'),
(11, '10441e7d-15a1-4b12-bec3-d6b6431959bf', 'DEBIT', 'Realtime Bank Acct holder:Claudia Ankunding DEBIT: ₩500.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-06-23 Available Bal:₩62,358.67 Status: Successful', 1, '2024-06-23 15:43:54', '2024-06-23 15:43:54'),
(12, '58e7ca12-9e23-4745-9283-c6949c10171e', 'DEBIT', 'Realtime Bank Acct holder:Test User DEBIT: ₦500.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-07-02 Available Bal:₦14,281.67 Status: Failed', 2, '2024-07-02 09:13:54', '2024-07-02 09:13:54'),
(13, 'f9e78067-db24-42d6-8c55-4d82a4f0acda', 'DEBIT', 'Realtime Bank Acct holder:Test User DEBIT: ₦300.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-07-02 Available Bal:₦13,981.67 Status: Successful', 2, '2024-07-02 10:03:43', '2024-07-02 10:03:43'),
(14, '01af474f-2ce3-46ec-b51c-fee7415ffef1', 'DEBIT', 'Realtime Bank Acct holder:Test User DEBIT: ₦500.00 Desc:Profit for trade DT:2024-07-02 Available Bal:₦13,481.67 Status: Successful', 2, '2024-07-02 10:18:21', '2024-07-02 10:18:21'),
(15, '316b0fa8-42fb-48aa-9eba-d9604f368c4a', 'CREDIT', 'ELite Saving Online Bank Acct holder:Micheal King CREDIT: $30,000,000.00 Desc:Profit for trade DT:2024-07-02 Available Bal:$30,000,000.00 Status: Successful', 4, '2024-07-02 12:56:33', '2024-07-02 12:56:33'),
(16, '4ff1906b-2292-4b0f-859d-b7a7c0e96e0b', 'CREDIT', 'ELite Saving Online Bank Acct holder:Micheal King CREDIT: $10,000.00 Desc:Profit for income DT:2024-07-03 Available Bal:$30,010,000.00 Status: Successful', 4, '2024-07-03 17:46:30', '2024-07-03 17:46:30'),
(17, 'bc3f3209-c486-4ee1-bdaf-92c199ee8a47', 'CREDIT', 'Elite Saving Online Bank Acct holder:Micheal King CREDIT: $30,000,000.00 Desc:Loan DT:2024-07-03 Available Bal:$30,000,000.00 Status: Successful', 4, '2024-07-03 17:53:29', '2024-07-03 17:53:29'),
(18, '9801d159-a4cf-49e0-b846-41d5282137df', 'CREDIT', 'Elite Saving Online Bank Acct holder:Micheal King CREDIT: $50,000.00 Desc:Loan Again DT:2024-07-03 Available Bal:$30,000,000.00 Status: Successful', 4, '2024-07-03 17:54:06', '2024-07-03 17:54:06'),
(19, 'fa1cded0-ba24-4c10-8baf-d91b6de6aeb1', 'DEBIT', 'Elite Saving Online Bank Acct holder:Test User DEBIT: ₦500.00 Desc:Electronic TF: Bitcoin Wallet/ DT:2024-07-03 Available Bal:₦12,981.67 Status: Successful', 2, '2024-07-03 19:19:31', '2024-07-03 19:19:31'),
(20, '536512fb-3145-4b17-86e7-fe745ec9aa92', 'CREDIT', 'Elite Saving Online Bank Acct holder:Test User CREDIT: ₦50,000,000.00 Desc:Value Added Tax DT:2024-05-06 Available Bal:₦50,012,981.67 Status: Successful', 2, '2024-07-04 04:08:05', '2024-07-04 04:08:05'),
(21, '6e98285b-7d1d-4fdc-9d02-0359bef5e11f', 'CREDIT', 'Elite Saving Online Bank Acct holder:Test User CREDIT: ₦50,000,000.00 Desc:Value Added Tax DT:2024-01-29 Available Bal:₦50,012,981.67 Status: Successful', 2, '2024-07-04 04:08:36', '2024-07-04 04:08:36'),
(22, '3039e520-20d2-4664-8469-e1b60963e300', 'CREDIT', 'Elite Saving Online Bank Acct holder:Test User CREDIT: ₦89,000.00 Desc:One Time Password DT:2023-10-16 Available Bal:₦50,012,981.67 Status: Successful', 2, '2024-07-04 04:09:00', '2024-07-04 04:09:00'),
(23, '44da386e-6362-4489-8d0e-ca1e9ea4f2ea', 'DEBIT', 'Elite Saving Online Bank Acct holder:Test User DEBIT: ₦40,000,000.00 Desc:One Time Password DT:2024-07-01 Available Bal:₦50,012,981.67 Status: Successful', 2, '2024-07-04 04:09:49', '2024-07-04 04:09:49');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('06i76IrdfAsVxtluQo5UIX6lIc7atckbS2F2NgFx', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSnhsN25pUkpFaVd5T2FUV1RjaVA3M3NqZHpjejhWMW9lUDZubzZENCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1726849659),
('8NnPVraQHVINBgGpa2jOYZNtQtAnAPBhyNk9wOCh', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:127.0) Gecko/20100101 Firefox/127.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSG9Lakw2UmNWTDIyOGVaSlNBSVlUOU9yN0Q4QkpXQTM1dDFyZHBpSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC91c2VyL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTE6ImxvZ2luX3VzZXJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=', 1720070452),
('bs4OjLipp1g2bUKeIrbc5GFaTzGNq4VHuLGKigbm', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNmRpOHc2VU5nS2tVZlk5MXpGMW04Y2dydGZMRDlQelpiTFdWSlZnYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1722787458),
('NbgW3mLI5Do7JzCIqF4xjQsXgqpmBYSImjl2x1gg', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMk9lb3J3T0dqNWpwWTFuM1dVU2RVVjNPTDJwdEhvczRhNmlCWUJrRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1726853313),
('qYvdkpSQqXKmsw0YLcdWOkomfNH71GV1MOFSkl6V', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiclV1c2tqczNyYnQ5MjJYV0dPTktwb2ZDdmJpWjN5QzZiaU1nc0Q4YyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi91c2Vycy90cmFuc2FjdGlvbi9pbmRleC8zMGIwMTA5ZC1kNTk2LTM5NjQtYjNhMS0xZjRhZWI1OWMyM2IiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUyOiJsb2dpbl9hZG1pbl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI7fQ==', 1720069790),
('vMlXhmmSiCBSRXNkreKtyVoQIYCToOghMBdd8sqo', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoienA0aGx0SjNQU3V3R3FPOWNla1FIdWxNN0RCTzJvQkxXVmFtMDg3WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zZXJ2aWNlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1722787472);

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `current_balance` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `reference_id` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cards`
--
ALTER TABLE `cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cards_user_id_foreign` (`user_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deposits_user_id_foreign` (`user_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `loans`
--
ALTER TABLE `loans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_user_id_foreign` (`user_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for table `cards`
--
ALTER TABLE `cards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loans`
--
ALTER TABLE `loans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cards`
--
ALTER TABLE `cards`
  ADD CONSTRAINT `cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `deposits`
--
ALTER TABLE `deposits`
  ADD CONSTRAINT `deposits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

