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

START TRANSACTION;



--
-- Database: `exchange`
--

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

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` bigint NOT NULL,
  `user` int DEFAULT NULL,
  `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `device` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `os` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` (`id`, `user`, `ip_address`, `created_at`, `updated_at`, `device`, `browser`, `os`) VALUES
(1, 217, '127.0.0.1', '2025-03-12 17:32:31', '2025-03-12 17:32:31', 'Macintosh', 'Firefox', 'OS X'),
(2, 217, '127.0.0.1', '2025-03-12 17:32:31', '2025-03-12 17:32:31', 'Macintosh', 'Firefox', 'OS X'),
(3, 217, '127.0.0.1', '2025-03-12 17:37:12', '2025-03-12 17:37:12', 'Macintosh', 'Firefox', 'OS X'),
(4, 217, '127.0.0.1', '2025-03-12 17:37:12', '2025-03-12 17:37:12', 'Macintosh', 'Firefox', 'OS X'),
(5, 217, '127.0.0.1', '2025-03-13 13:15:08', '2025-03-13 13:15:08', 'Macintosh', 'Firefox', 'OS X'),
(6, 217, '127.0.0.1', '2025-03-13 13:15:08', '2025-03-13 13:15:08', 'Macintosh', 'Firefox', 'OS X'),
(7, 245, '127.0.0.1', '2025-03-17 14:37:20', '2025-03-17 14:37:20', 'Macintosh', 'Firefox', 'OS X'),
(8, 245, '127.0.0.1', '2025-03-17 14:37:20', '2025-03-17 14:37:20', 'Macintosh', 'Firefox', 'OS X'),
(9, 265, '127.0.0.1', '2025-03-18 14:32:47', '2025-03-18 14:32:47', 'Macintosh', 'Firefox', 'OS X'),
(10, 265, '127.0.0.1', '2025-03-18 14:32:47', '2025-03-18 14:32:47', 'Macintosh', 'Firefox', 'OS X'),
(11, 265, '127.0.0.1', '2025-03-18 19:17:59', '2025-03-18 19:17:59', 'Macintosh', 'Firefox', 'OS X'),
(12, 265, '127.0.0.1', '2025-03-18 19:17:59', '2025-03-18 19:17:59', 'Macintosh', 'Firefox', 'OS X'),
(13, 265, '127.0.0.1', '2025-03-19 05:32:52', '2025-03-19 05:32:52', 'Macintosh', 'Firefox', 'OS X'),
(14, 265, '127.0.0.1', '2025-03-19 05:32:52', '2025-03-19 05:32:52', 'Macintosh', 'Firefox', 'OS X'),
(15, 265, '127.0.0.1', '2025-03-19 19:50:58', '2025-03-19 19:50:58', 'Macintosh', 'Firefox', 'OS X'),
(16, 265, '127.0.0.1', '2025-03-19 19:50:58', '2025-03-19 19:50:58', 'Macintosh', 'Firefox', 'OS X'),
(17, 265, '127.0.0.1', '2025-03-19 20:11:42', '2025-03-19 20:11:42', 'Macintosh', 'Firefox', 'OS X'),
(18, 265, '127.0.0.1', '2025-03-19 20:11:42', '2025-03-19 20:11:42', 'Macintosh', 'Firefox', 'OS X'),
(19, 265, '127.0.0.1', '2025-03-20 06:37:45', '2025-03-20 06:37:45', 'Macintosh', 'Firefox', 'OS X'),
(20, 265, '127.0.0.1', '2025-03-20 06:37:45', '2025-03-20 06:37:45', 'Macintosh', 'Firefox', 'OS X'),
(21, 265, '127.0.0.1', '2025-03-24 07:48:35', '2025-03-24 07:48:35', 'Macintosh', 'Firefox', 'OS X'),
(22, 265, '127.0.0.1', '2025-03-24 07:48:35', '2025-03-24 07:48:35', 'Macintosh', 'Firefox', 'OS X'),
(23, 265, '127.0.0.1', '2025-03-27 16:41:44', '2025-03-27 16:41:44', 'Macintosh', 'Firefox', 'OS X'),
(24, 265, '127.0.0.1', '2025-03-27 16:41:44', '2025-03-27 16:41:44', 'Macintosh', 'Firefox', 'OS X'),
(25, 265, '127.0.0.1', '2025-03-29 05:22:25', '2025-03-29 05:22:25', 'Macintosh', 'Firefox', 'OS X'),
(26, 265, '127.0.0.1', '2025-03-29 05:22:25', '2025-03-29 05:22:25', 'Macintosh', 'Firefox', 'OS X'),
(27, 265, '127.0.0.1', '2025-03-29 11:44:46', '2025-03-29 11:44:46', 'Macintosh', 'Firefox', 'OS X'),
(28, 265, '127.0.0.1', '2025-03-29 11:44:46', '2025-03-29 11:44:46', 'Macintosh', 'Firefox', 'OS X'),
(29, 267, '127.0.0.1', '2025-03-29 13:58:49', '2025-03-29 13:58:49', 'Macintosh', 'Firefox', 'OS X'),
(30, 267, '127.0.0.1', '2025-03-29 13:58:49', '2025-03-29 13:58:49', 'Macintosh', 'Firefox', 'OS X'),
(31, 268, '127.0.0.1', '2025-03-29 14:01:00', '2025-03-29 14:01:00', 'Macintosh', 'Firefox', 'OS X'),
(32, 268, '127.0.0.1', '2025-03-29 14:01:00', '2025-03-29 14:01:00', 'Macintosh', 'Firefox', 'OS X'),
(33, 275, '127.0.0.1', '2025-03-29 18:19:46', '2025-03-29 18:19:46', 'Macintosh', 'Firefox', 'OS X'),
(34, 275, '127.0.0.1', '2025-03-29 18:19:46', '2025-03-29 18:19:46', 'Macintosh', 'Firefox', 'OS X'),
(35, 275, '127.0.0.1', '2025-03-29 18:24:11', '2025-03-29 18:24:11', 'Macintosh', 'Firefox', 'OS X'),
(36, 275, '127.0.0.1', '2025-03-29 18:24:11', '2025-03-29 18:24:11', 'Macintosh', 'Firefox', 'OS X'),
(37, 265, '127.0.0.1', '2025-03-29 19:09:19', '2025-03-29 19:09:19', 'Macintosh', 'Firefox', 'OS X'),
(38, 265, '127.0.0.1', '2025-03-29 19:09:19', '2025-03-29 19:09:19', 'Macintosh', 'Firefox', 'OS X'),
(39, 275, '127.0.0.1', '2025-03-29 20:51:15', '2025-03-29 20:51:15', 'Macintosh', 'Firefox', 'OS X'),
(40, 275, '127.0.0.1', '2025-03-29 20:51:20', '2025-03-29 20:51:20', 'Macintosh', 'Firefox', 'OS X'),
(41, 275, '127.0.0.1', '2025-03-29 21:05:06', '2025-03-29 21:05:06', 'Macintosh', 'Firefox', 'OS X'),
(42, 275, '127.0.0.1', '2025-03-29 21:05:26', '2025-03-29 21:05:26', 'Macintosh', 'Firefox', 'OS X'),
(43, 275, '127.0.0.1', '2025-03-29 21:05:31', '2025-03-29 21:05:31', 'Macintosh', 'Firefox', 'OS X'),
(44, 275, '127.0.0.1', '2025-03-29 21:12:12', '2025-03-29 21:12:12', 'Macintosh', 'Firefox', 'OS X'),
(45, 275, '127.0.0.1', '2025-03-29 21:13:29', '2025-03-29 21:13:29', 'Macintosh', 'Firefox', 'OS X'),
(46, 275, '127.0.0.1', '2025-03-29 21:13:33', '2025-03-29 21:13:33', 'Macintosh', 'Firefox', 'OS X'),
(47, 275, '127.0.0.1', '2025-03-29 21:15:52', '2025-03-29 21:15:52', 'Macintosh', 'Firefox', 'OS X'),
(48, 275, '127.0.0.1', '2025-03-29 21:15:57', '2025-03-29 21:15:57', 'Macintosh', 'Firefox', 'OS X'),
(49, 265, '127.0.0.1', '2025-03-29 22:45:25', '2025-03-29 22:45:25', 'Macintosh', 'Firefox', 'OS X'),
(50, 265, '127.0.0.1', '2025-03-29 22:45:30', '2025-03-29 22:45:30', 'Macintosh', 'Firefox', 'OS X'),
(51, 265, '127.0.0.1', '2025-03-29 23:01:05', '2025-03-29 23:01:05', 'Macintosh', 'Firefox', 'OS X'),
(52, 265, '127.0.0.1', '2025-03-29 23:01:10', '2025-03-29 23:01:10', 'Macintosh', 'Firefox', 'OS X'),
(53, 275, '127.0.0.1', '2025-03-30 07:30:15', '2025-03-30 07:30:15', 'Macintosh', 'Firefox', 'OS X'),
(54, 275, '127.0.0.1', '2025-03-30 07:30:20', '2025-03-30 07:30:20', 'Macintosh', 'Firefox', 'OS X'),
(55, 265, '127.0.0.1', '2025-03-30 07:37:10', '2025-03-30 07:37:10', 'Macintosh', 'Firefox', 'OS X'),
(56, 265, '127.0.0.1', '2025-03-30 07:37:14', '2025-03-30 07:37:14', 'Macintosh', 'Firefox', 'OS X'),
(57, 265, '127.0.0.1', '2025-03-30 16:00:50', '2025-03-30 16:00:50', 'Macintosh', 'Firefox', 'OS X'),
(58, 265, '127.0.0.1', '2025-03-30 16:00:55', '2025-03-30 16:00:55', 'Macintosh', 'Firefox', 'OS X'),
(59, 275, '127.0.0.1', '2025-04-02 13:51:08', '2025-04-02 13:51:08', 'Macintosh', 'Firefox', 'OS X'),
(60, 275, '127.0.0.1', '2025-04-02 13:51:12', '2025-04-02 13:51:12', 'Macintosh', 'Firefox', 'OS X'),
(61, 275, '127.0.0.1', '2025-04-02 18:41:19', '2025-04-02 18:41:19', 'Macintosh', 'Firefox', 'OS X'),
(62, 275, '127.0.0.1', '2025-04-02 18:41:23', '2025-04-02 18:41:23', 'Macintosh', 'Firefox', 'OS X'),
(63, 265, '127.0.0.1', '2025-04-02 18:41:39', '2025-04-02 18:41:39', 'Macintosh', 'Firefox', 'OS X'),
(64, 265, '127.0.0.1', '2025-04-02 18:41:43', '2025-04-02 18:41:43', 'Macintosh', 'Firefox', 'OS X'),
(65, 265, '127.0.0.1', '2025-04-03 09:29:29', '2025-04-03 09:29:29', 'Macintosh', 'Firefox', 'OS X'),
(66, 265, '127.0.0.1', '2025-04-03 09:29:33', '2025-04-03 09:29:33', 'Macintosh', 'Firefox', 'OS X'),
(67, 275, '127.0.0.1', '2025-04-04 10:49:05', '2025-04-04 10:49:05', 'Macintosh', 'Firefox', 'OS X'),
(68, 275, '127.0.0.1', '2025-04-04 10:49:10', '2025-04-04 10:49:10', 'Macintosh', 'Firefox', 'OS X'),
(69, 282, '127.0.0.1', '2025-04-06 16:40:42', '2025-04-06 16:40:42', 'Macintosh', 'Firefox', 'OS X'),
(70, 282, '127.0.0.1', '2025-04-06 16:40:47', '2025-04-06 16:40:47', 'Macintosh', 'Firefox', 'OS X'),
(71, 282, '127.0.0.1', '2025-04-08 03:16:49', '2025-04-08 03:16:49', 'Macintosh', 'Firefox', 'OS X'),
(72, 282, '127.0.0.1', '2025-04-08 03:16:54', '2025-04-08 03:16:54', 'Macintosh', 'Firefox', 'OS X'),
(73, 282, '127.0.0.1', '2025-04-08 15:21:34', '2025-04-08 15:21:34', 'Macintosh', 'Firefox', 'OS X'),
(74, 282, '127.0.0.1', '2025-04-08 15:21:38', '2025-04-08 15:21:38', 'Macintosh', 'Firefox', 'OS X');

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

--
-- Table structure for table `crypto_price`
--

CREATE TABLE `crypto_price` (
  `id` bigint UNSIGNED NOT NULL,
  `crypto_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `network` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(16,8) NOT NULL,
  `naira_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percent_change_24h` decimal(5,2) DEFAULT 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 `crypto_price`
--

INSERT INTO `crypto_price` (`id`, `crypto_name`, `network`, `price`, `naira_price`, `symbol`, `percent_change_24h`, `created_at`, `updated_at`) VALUES
(1, 'bitcoin', NULL, 76515.00000000, '119629922', 'BTC', -2.12, '2025-03-01 15:55:57', '2025-04-08 18:47:54'),
(2, 'ethereum', NULL, 1459.79000000, '2282351', 'ETH', -5.70, '2025-03-01 15:55:57', '2025-04-08 18:47:54'),
(3, 'litecoin', NULL, 68.63000000, '107308', 'LTC', -3.25, '2025-03-01 15:55:57', '2025-04-08 18:47:54'),
(4, 'ripple', NULL, 1.82000000, '2844.85', 'XRP', -4.38, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(5, 'cardano', NULL, 0.56231600, '879.17', 'ADA', -2.66, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(6, 'solana', NULL, 103.77000000, '162237', 'SOL', -2.31, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(7, 'polkadot', NULL, 3.42000000, '5342.99', 'DOT', -4.32, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(8, 'dogecoin', NULL, 0.14310600, '223.74', 'DOGE', -2.76, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(9, 'binancecoin', NULL, 551.62000000, '862451', 'BNB', -0.26, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(10, 'shiba-inu', NULL, 0.00001066, '0.01666433', 'SHIB', -5.67, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(11, 'avalanche-2', NULL, 16.06000000, '25115', 'AVAX', -4.02, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(12, 'terra-luna', NULL, 0.00005363, '0.083842', 'LUNC', -4.25, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(13, 'tron', NULL, 0.23068600, '360.67', 'TRX', 1.27, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(14, 'chainlink', NULL, 10.90000000, '17044.07', 'LINK', -4.11, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(15, 'uniswap', NULL, 4.89000000, '7638.2', 'UNI', -3.94, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(16, 'cosmos', NULL, 4.17000000, '6523.68', 'ATOM', -4.15, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(17, 'stellar', NULL, 0.22137900, '346.12', 'XLM', -4.51, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(18, 'monero', NULL, 197.19000000, '308296', 'XMR', -1.77, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(19, 'algorand', NULL, 0.15772600, '246.6', 'ALGO', -5.01, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(20, 'vechain', NULL, 0.01963006, '30.69', 'VET', -2.53, '2025-03-02 07:27:48', '2025-04-08 18:47:54'),
(26, 'tether', 'TRC20', 0.99879600, '1561.6', 'USDT.TRC20', -0.07, '2025-04-06 13:32:32', '2025-04-08 18:47:54'),
(27, 'tether', 'ERC20', 0.99879600, '1561.6', 'USDT.ERC20', -0.07, '2025-04-06 13:32:32', '2025-04-08 18:47:54'),
(28, 'naira', NULL, 1561.60000000, NULL, 'NGN', NULL, '2025-04-08 18:41:09', '2025-04-08 18:47:55');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `symbol`, `address`, `logo`, `created_at`) VALUES
(1, 'Bitcoin', 'BTC', 'TCgeYoZwxTP79CjH7jG1WR8iJ2zSV96h4W', 'coin/btc.png', '2025-03-18 13:31:51'),
(2, 'Ethereum', 'ETH', 'TCgeYoZwxTP79CjH7jG1WR8iJ2zSV96h4W', 'coin/eth.png', '2025-03-18 13:31:51'),
(8, 'USD Tether', 'USDT.TRC20', 'TCgeYoZwxTP79CjH7jG1WR8iJ2zSV96h4Wdsddfdd', 'coin/R7r2bqwz9L70fuAIRAJ9XHQT91kJlYOehdmiXZ9i.png', '2025-03-20 13:31:46'),
(9, 'USD Tether', 'USDT.ERC20', 'TCgeYoZwxTP79CjH7jG1WR8iJ2zSV96h4Wd', 'coin/egd0GbnISHrT8wSkQn5MIv8wfNoZn5f8TWF4CAer.png', '2025-03-30 16:18:42'),
(14, 'Naira', 'NGN', '2082500171', 'coin/lBzsAn6VIyFRgpkweLChTsjV8HZG1P7qXz6Nnd0a.png', '2025-04-08 17:53:26');

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

--
-- Table structure for table `ipaddresses`
--

CREATE TABLE `ipaddresses` (
  `id` int UNSIGNED NOT NULL,
  `ipaddress` varchar(191) COLLATE utf8mb4_unicode_ci 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 `kycs`
--

CREATE TABLE `kycs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bvn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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 `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB 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, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2021_03_09_142220_create_sessions_table', 1),
(7, '2021_03_10_082445_create_admins_table', 2),
(8, '2021_03_10_082519_create_agents_table', 2),
(9, '2021_03_10_082715_create_assets_table', 2),
(10, '2021_03_10_082817_create_contents_table', 2),
(11, '2021_03_10_083110_create_cp_transactions_table', 2),
(12, '2021_03_10_083324_create_deposits_table', 2),
(13, '2021_03_10_083400_create_faqs_table', 2),
(14, '2021_03_10_083510_create_images_table', 2),
(15, '2021_03_10_083557_create_mt4_details_table', 2),
(16, '2021_03_10_083627_create_notifications_table', 2),
(17, '2021_03_10_083824_create_plans_table', 2),
(18, '2021_03_10_083850_create_settings_table', 2),
(19, '2021_03_10_083936_create_testimonies_table', 2),
(20, '2021_03_10_084009_create_tp__transactions_table', 2),
(21, '2021_03_10_084031_create_upgrades_table', 2),
(22, '2021_03_10_084120_create_userlogs_table', 2),
(23, '2021_03_10_084140_create_user_plans_table', 2),
(24, '2021_03_10_084235_create_wdmethods_table', 2),
(25, '2021_03_10_084300_create_withdrawals_table', 2),
(26, '2021_04_06_083043_create_tasks_table', 3),
(27, '2021_04_23_110006_create_exchanges_table', 4),
(28, '2021_04_23_114622_create_coin_transactions_table', 5),
(29, '2021_04_27_080945_create_currencies_table', 6),
(30, '2021_04_29_110349_create_c_withdrawals_table', 7),
(31, '2021_10_07_112653_create_ipaddresses_table', 8),
(32, '2021_10_27_114829_create_terms_privacies_table', 9),
(33, '2021_10_31_131124_create_crypto_accounts_table', 10),
(34, '2021_10_31_132849_create_settings_conts_table', 11),
(35, '2022_01_24_123921_create_copy_trade_accounts_table', 12),
(36, '2022_02_03_131113_create_tasks_table', 13),
(37, '2022_03_16_135903_create_adverts_table', 14),
(38, '2022_03_17_114728_create_orders_p2ps_table', 15),
(39, '2022_05_23_215802_create_crypto_records_table', 16),
(40, '2022_06_13_220336_create_kycs_table', 17),
(41, '2022_06_23_030303_create_bnc_transactions_table', 18),
(42, '2022_09_02_074542_create_courses_table', 19),
(43, '2022_09_02_074626_create_course_lessons_table', 20),
(44, '2022_09_02_074608_create_course_categories_table', 21),
(45, '2022_09_06_165000_create_user_courses_table', 22),
(46, '2014_01_28_232217_create_autologin_tokens_table', 23),
(47, '2014_02_07_004118_add_unique_index_to_autologin_tokens_table', 24),
(48, '2014_03_02_162640_add_count_to_autologin_tokens_table', 25),
(53, '2022_09_19_142955_create_master_accounts_table', 26),
(54, '2022_09_29_153351_create_signal_tbs_table', 27),
(55, '2022_09_29_175703_create_signal_subscribers_table', 28),
(56, '2023_01_30_102934_create_themes_table', 29),
(57, '2023_02_17_165829_create_cache_table', 30),
(58, '2021_10_05_122902_create_activities_table', 31),
(59, '2024_02_18_143534_user_investmentplans_table', 31),
(60, '2024_02_18_145243_create_user_investmentplans_table', 32),
(61, '2024_02_19_095728_create_investment_table', 33),
(62, '2024_02_19_100007_create_investments_table', 34),
(63, '2024_02_19_144804_create_signals_table', 35),
(64, '2024_02_19_191659_create_user_signals_table', 36),
(65, '2025_03_01_000000_create_crypto_price_table', 37);

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

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

CREATE TABLE `sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int 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
('eJZwBClddCnZUyIRuhiP7dPnrGcAIUiFw7sTLdP2', 282, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:137.0) Gecko/20100101 Firefox/137.0', 'YToxMzp7czo2OiJfdG9rZW4iO3M6NDA6InhtWURVYVlPSUN6WEMxVVlxQklKVUF6OHdpNWg5QmlhNFpFcDcyRG4iO3M6MzoidXJsIjthOjA6e31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo1MDoiaHR0cDovL2V4Y2hhbmdlLmxvbDo4ODg4L2Rhc2hib2FyZC9kZXRhaWxzL0VUSC8xMzgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjg6ImdldEFub3VjIjtzOjQ6InRydWUiO3M6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI4MjtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEwJFUzVnZObEM2TDJBL2dEMHl1ODFFVGVpdHJJbVg0YkhZT25ib25zWDJyYzlSSmN2bDQxRWllIjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMCRVM1Z2TmxDNkwyQS9nRDB5dTgxRVRlaXRySW1YNGJIWU9uYm9uc1gycmM5Ukpjdmw0MUVpZSI7czo1MjoibG9naW5fYWRtaW5fNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6MTU6ImN1cnJlbmN5X3N5bWJvbCI7czozOiJFVEgiO3M6MTM6InBheW1lbnRtZXRob2QiO047czo2OiJhbW91bnQiO047czoxMjoicGF5bWVudF9tb2RlIjtOO30=', 1744149293);

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

--
-- Table structure for table `terms_privacies`
--

CREATE TABLE `terms_privacies` (
  `id` int UNSIGNED NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `useterms` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  `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 `terms_privacies`
--

INSERT INTO `terms_privacies` (`id`, `description`, `useterms`, `created_at`, `updated_at`) VALUES
(1, '<p><strong>Our Commitment to You:</strong></p>\r\n\r\n<p>Thank you for showing interest in our service. In order for us to provide you with our service, we are required to collect and process certain personal data about you and your activity.</p>\r\n\r\n<p>By entrusting us with your personal data, we would like to assure you of our commitment to keep such information private and to operate in accordance with all regulatory laws and all EU data protection laws, including General Data Protection Regulation (GDPR) 679/2016 (EU).</p>\r\n\r\n<p>We have taken measurable steps to protect the confidentiality, security and integrity of this data. We encourage you to review the following information carefully.</p>\r\n\r\n<p><strong>Grounds for data collection:</strong></p>\r\n\r\n<p>Processing of your personal information (meaning, any data which may potentially allow your identification with reasonable means; hereinafter &ldquo;Personal Data&rdquo;) is necessary for the performance of our contractual obligations towards you and providing you with our services, to protect our legitimate interests and for compliance with legal and financial regulatory obligations to which we are subject.</p>\r\n\r\n<p>When you use our services, you consent to the collection, storage, use, disclosure and other uses of your Personal Data as described in this Privacy Policy.</p>\r\n\r\n<p><strong>How do we receive data about you?</strong></p>\r\n\r\n<p>We receive your Personal Data from various sources:</p>\r\n\r\n<ol>\r\n	<li>When you voluntarily provide us with your personal details in order to create an account (for example, your name and email address)</li>\r\n	<li>When you use or access our site and services, in connection with your use of our services (for example, your financial transactions)</li>\r\n	<li>&nbsp;</li>\r\n</ol>\r\n\r\n<p><strong>What type of data we collect?</strong></p>\r\n\r\n<p>In order to open an account, and in order to provide you with our services we will need you to collect the following data:</p>\r\n\r\n<p><strong>Personal Data<br />\r\nWe collect the following Personal Data about you:</strong></p>\r\n\r\n<ul>\r\n	<li><em>Registration data</em>&nbsp;&ndash; your name, email address, phone number, occupation, country of residence, and your age (in order to verify you are over 18 years of age and eligible to participate in our service).</li>\r\n	<li><em>Voluntary data</em>&nbsp;&ndash; when you communicate with us (for example when you send us an email or use a &ldquo;contact us&rdquo; form on our site) we collect the personal data you provided us with.</li>\r\n	<li><em>Financial data</em>&nbsp;&ndash; by its nature, your use of our services includes financial transactions, thus requiring us to obtain your financial details, which includes, but not limited to your payment details (such as bank account details and financial transactions performed through our services).</li>\r\n	<li><em>Technical data</em>&nbsp;&ndash; we collect certain technical data that is automatically recorded when you use our services, such as your IP address, MAC address, device approximate location</li>\r\n	<li>Non Personal Data</li>\r\n</ul>\r\n\r\n<p>We record and collect data from or about your device (for example your computer or your mobile device) when you access our services and visit our site. This includes, but not limited to: your login credentials, UDID, Google advertising ID, IDFA, cookie identifiers, and may include other identifiers such your operating system version, browser type, language preferences, time zone, referring domains and the duration of your visits. This will facilitate our ability to improve our service and personalize your experience with us.<br />\r\nIf we combine Personal Data with non-Personal Data about you, the combined data will be treated as Personal Data for as long as it remains combined.</p>\r\n\r\n<p><strong>Tracking Technologies</strong></p>\r\n\r\n<p>When you visit or access our services we use (and authorize 3rd parties to use) pixels, cookies, events and other technologies (&ldquo;Tracking Technologies&ldquo;). Those allow us to automatically collect data about you, your device and your online behavior, in order to enhance your navigation in our services, improve our site&rsquo;s performance, perform analytics and customize your experience on it. In addition, we may merge data we have with data collected through said tracking technologies with data we may obtain from other sources and, as a result, such data may become Personal Data.<br />\r\nCookie Policy page.</p>\r\n\r\n<p><strong>How do we use the data We collect?</strong></p>\r\n\r\n<ul>\r\n	<li>Provision of service &ndash; we will use your Personal Data you provide us for the provision and improvement of our services to you.</li>\r\n	<li>Marketing purposes &ndash; we will use your Personal Data (such as your email address or phone number). For example, by subscribing to our newsletter you will receive tips and announcements straight to your email account. We may also send you promotional material concerning our services or our partners&rsquo; services (which we believe may interest you), including but not limited to, by building an automated profile based on your Personal Data, for marketing purposes. You may choose not to receive our promotional or marketing emails (all or any part thereof) by clicking on the &ldquo;unsubscribe&rdquo; link in the emails that you receive from us. Please note that even if you unsubscribe from our newsletter, we may continue to send you service-related updates and notifications or reply to your queries and feedback you provide us.</li>\r\n	<li>Opt-out of receiving marketing materials &ndash; If you do not want us to use or share your personal data for marketing purposes, you may opt-out in accordance with this &ldquo;Opt-out&rdquo; section. Please note that even if you opt-out, we may still use and share your personal information with third parties for non-marketing purposes (for example to fulfill your requests, communicate with you and respond to your inquiries, etc.). In such cases, the companies with whom we share your personal data are authorized to use your Personal Data only as necessary to provide these non-marketing services.</li>\r\n	<li>Analytics, surveys and research &ndash; we are always trying to improve our services and think of new and exciting features for our users. From time to time, we may conduct surveys or test features, and analyze the information we have to develop, evaluate and improve these features.</li>\r\n	<li>Protecting our interests &ndash; we use your Personal Data when we believe it&rsquo;s necessary in order to take precautions against liabilities, investigate and defend ourselves against any third-party claims or allegations, investigate and protect ourselves from fraud, protect the security or integrity of our services and protect the rights and property of the company, its users and/or partners.</li>\r\n	<li>Enforcing of policies &ndash; we use your Personal Data in order to enforce our policies, including but limited to our Terms &amp; Conditions.</li>\r\n	<li>Compliance with legal and regulatory requirements &ndash; we also use your Personal Data to investigate violations and prevent money laundering and perform due-diligence checks, and as required by law, regulation or other governmental authority, or to comply with a subpoena or similar legal process.</li>\r\n</ul>\r\n\r\n<p><strong>With whom do we share your Personal Data</strong></p>\r\n\r\n<ul>\r\n	<li>Internal concerned parties &ndash; we share your data with companies in our group, as well as our employees limited to those employees or partners who need to know the information in order to provide you with our services.</li>\r\n	<li>Financial providers and payment processors &ndash; we share your financial data about you for purposes of accepting deposits or performing risk analysis.</li>\r\n	<li>Business partners &ndash; we share your data with business partners, such as storage providers and analytics providers who help us provide you with our service.</li>\r\n	<li>Legal and regulatory entities &ndash; we may disclose any data in case we believe, in good faith, that such disclosure is necessary in order to enforce our Terms &amp; Conditions take precautions against liabilities, investigate and defend ourselves against any third party claims or allegations, protect the security or integrity of the site and our servers and protect the rights and property, our users and/or partners. We may also disclose your personal data where requested any other regulatory authority having control or jurisdiction over us, you or our associates or in the territories we have clients or providers, as a broker.</li>\r\n	<li>Merger and acquisitions &ndash; we may share your data if we enter into a business transaction such as a merger, acquisition, reorganization, bankruptcy, or sale of some or all of our assets. Any party that acquires our assets as part of such a transaction may continue to use your data in accordance with the terms of this Privacy Policy.</li>\r\n</ul>\r\n\r\n<p><strong>Transfer of data outside the EEA</strong></p>\r\n\r\n<p>Please note that some data recipients may be located outside the EEA. In such cases, we will transfer your data only to such countries as approved by the European Commission as providing an adequate level of data protection or enter into legal agreements ensuring an adequate level of data protection.</p>\r\n\r\n<p><strong>How we protect your data</strong></p>\r\n\r\n<p>We have implemented administrative, technical, and physical safeguards to help prevent unauthorized access, use, or disclosure of your personal data. Your data is stored on secure servers and isn&rsquo;t publicly available. We limit access of your data only to those employees or partners that need to know the information in order to enable the carrying out of the agreement between us.</p>\r\n\r\n<p>You need to help us prevent unauthorized access to your account by protecting your password appropriately and limiting access to your account (for example, by signing off after you have finished accessing your account). You will be solely responsible for keeping your password confidential and for all use of your password and your account, including any unauthorized use.</p>\r\n\r\n<p>While we seek to protect your data to ensure that it is kept confidential, we cannot absolutely guarantee its security. You should be aware that there is always some risk involved in transmitting data over the internet. While we strive to protect your Personal Data, we cannot ensure or warrant the security and privacy of your personal Data or other content you transmit using the service, and you do so at your own risk.</p>\r\n\r\n<p><strong>Retention</strong></p>\r\n\r\n<p>We will retain your personal data for as long as necessary to provide our services, and as necessary to comply with our legal obligations, resolve disputes, and enforce our policies. Retention periods will be determined taking into account the type of data that is collected and the purpose for which it is collected, bearing in mind the requirements applicable to the situation and the need to destroy outdated, unused data at the earliest reasonable time. Under applicable regulations, we will keep records containing client personal data, trading information, account opening documents, communications and anything else as required by applicable laws and regulations.</p>\r\n\r\n<p><strong>User Rights</strong></p>\r\n\r\n<ol>\r\n	<li>Receive confirmation as to whether or not personal data concerning you is being processed, and access your stored personal data, together with supplementary data.</li>\r\n	<li>Receive a copy of personal data you directly volunteer to us in a structured, commonly used and machine-readable format.</li>\r\n	<li>Request rectification of your personal data that is in our control.</li>\r\n	<li>Request erasure of your personal data.</li>\r\n	<li>Object to the processing of personal data by us.</li>\r\n	<li>Request to restrict processing of your personal data by us.</li>\r\n</ol>\r\n\r\n<p>However, please note that these rights are not absolute, and may be subject to our own legitimate interests and regulatory requirements.</p>\r\n\r\n<p><strong>How to Contact us?</strong></p>\r\n\r\n<p>If you wish to exercise any of the aforementioned rights, or receive more information, please contact our General Data Protection Officer (&ldquo;GDPO&rdquo;) using the details provided below:</p>\r\n\r\n<p>Email: support@onlintrade.com</p>\r\n\r\n<p>Attn. GDPO Compliance Officer</p>\r\n\r\n<p>If you decide to terminate your account, you may do so by emailing us at support@onlintrade.com. If you terminate your account, please be aware that personal information that you have provided us may still be maintained for legal and regulatory reasons (as described above), but it will no longer be accessible via your account.</p>\r\n\r\n<p><strong>Updates to this Policy</strong></p>\r\n\r\n<p>This Privacy Policy is subject to changes from time to time, at our sole discretion. The most current version will always be posted on our website (as reflected in the &ldquo;Last Updated&rdquo; heading). You are advised to check for updates regularly. In the event of material changes, we will provide you with a notice. By continuing to access or use our services after any revisions become effective, you agree to be bound by the updated Privacy Policy.</p>', 'no', '2020-12-14 09:39:57', '2022-07-05 06:23:49');

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

--
-- Table structure for table `user_wallets`
--

CREATE TABLE `user_wallets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `currency_id` int UNSIGNED NOT NULL,
  `balance` decimal(18,8) DEFAULT '0.00000000',
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_wallets`
--

INSERT INTO `user_wallets` (`id`, `user_id`, `currency_id`, `balance`, `address`, `created_at`, `updated_at`) VALUES
(82, 282, 1, 42.86153087, 'bc1q7zeuhvqjn3jcfjhzd2c6adex465jqsdlsygcft', '2025-04-06 09:17:31', '2025-04-08 01:34:40'),
(83, 282, 2, 0.04132457, '0x61e6328083e92D27128E23f0764654EC5027d1c8', '2025-04-06 09:17:32', '2025-04-08 01:49:25'),
(85, 282, 8, 1592.67259966, 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN', '2025-04-06 09:17:34', '2025-04-08 19:29:46'),
(86, 282, 9, 1.00000000, '0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97', '2025-04-06 09:17:34', '2025-04-08 02:15:27'),
(87, 282, 14, 0.00000000, NULL, '2025-04-08 16:53:26', '2025-04-08 16:53:26');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint UNSIGNED NOT NULL,
  `txn_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` int DEFAULT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `columns` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_deduct` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paydetails` text COLLATE utf8mb4_unicode_ci,
  `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 `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `txn_id`, `user`, `amount`, `columns`, `to_deduct`, `status`, `payment_mode`, `paydetails`, `created_at`, `updated_at`) VALUES
(15, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN', '2025-03-29 18:09:40', '2025-03-29 18:09:40'),
(16, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 18:12:41', '2025-03-29 18:12:41'),
(17, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 18:13:11', '2025-03-29 18:13:11'),
(18, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 18:13:54', '2025-03-29 18:13:54'),
(19, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 18:14:34', '2025-03-29 18:14:34'),
(20, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEF', '2025-03-29 18:15:16', '2025-03-29 18:15:16'),
(21, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 22:01:24', '2025-03-29 22:01:24'),
(22, NULL, 265, '50', NULL, '55', 'Pending', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 22:04:17', '2025-03-29 22:04:17'),
(23, NULL, 265, '50', NULL, '55', 'Pending', 'ETH', 'ltc1qjl0e69ldupgtvf73um5cnvkz07w2rqrgkgg2x4', '2025-03-29 22:08:46', '2025-03-29 22:08:46'),
(24, NULL, 265, '50', NULL, '55', 'Pending', 'ETH', 'ltc1qjl0e69ldupgtvf73um5cnvkz07w2rqrgkgg2x4', '2025-03-29 22:09:13', '2025-03-29 22:09:13'),
(25, NULL, 265, '50', NULL, '55', 'Pending', 'ETH', 'ltc1qjl0e69ldupgtvf73um5cnvkz07w2rqrgkgg2x4', '2025-03-29 22:09:45', '2025-03-29 22:09:45'),
(26, NULL, 265, '50', NULL, '55', 'Pending', 'ETH', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEF', '2025-03-29 22:12:26', '2025-03-29 22:12:26'),
(27, NULL, 265, '50', NULL, '55', 'Processed', 'ETH', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEF', '2025-03-29 22:14:26', '2025-04-02 20:49:30'),
(28, NULL, 265, '50', NULL, '55', 'Processed', 'ETH', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEF', '2025-03-29 22:15:14', '2025-04-02 20:40:46'),
(29, NULL, 265, '50', NULL, '55', 'Processed', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 22:17:00', '2025-04-02 20:27:51'),
(30, NULL, 265, '50', NULL, '55', 'Processed', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-03-29 22:17:41', '2025-04-02 20:07:59'),
(31, NULL, 265, '50', NULL, '55', 'Processed', 'BTC', 'TDmyUEAtJ8pu69Wkk8e7qeHb7Cb84ouEFN-btc', '2025-04-02 19:43:25', '2025-04-02 19:58:43'),
(32, NULL, 265, '400', NULL, '405', 'Processed', 'ETH', 'ltc1qjl0e69ldupgtvf73um5cnvkz07w2rqrgkgg2x4', '2025-04-02 20:32:30', '2025-04-02 20:34:17'),
(33, NULL, 265, '900000', NULL, '900005', 'Processed', 'BTC', 'bc1q7zeuhvqjn3jcfjhzd2c6adex465jqsdlsygcft', '2025-04-02 20:50:25', '2025-04-02 20:51:19');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `crypto_price`
--
ALTER TABLE `crypto_price`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_crypto_network` (`crypto_name`,`network`);

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

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

--
-- Indexes for table `kycs`
--
ALTER TABLE `kycs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kycs_email_unique` (`bvn`);

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

--
-- 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 `terms_privacies`
--
ALTER TABLE `terms_privacies`
  ADD PRIMARY KEY (`id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activities`
--
ALTER TABLE `activities`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `crypto_price`
--
ALTER TABLE `crypto_price`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `ipaddresses`
--
ALTER TABLE `ipaddresses`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `kycs`
--
ALTER TABLE `kycs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `terms_privacies`
--
ALTER TABLE `terms_privacies`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_wallets`
--
ALTER TABLE `user_wallets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- Constraints for table `user_wallets`
--
ALTER TABLE `user_wallets`
  ADD CONSTRAINT `user_wallets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_wallets_ibfk_2` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE;
COMMIT;

