JFIF $
d d 7
Viewing File: /home/alphaedg/public_html/db.sql
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 26, 2024 at 02:20 PM
-- Server version: 8.0.39-cll-lve
-- PHP Version: 8.3.13
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`username` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(120) CHARACTER SET utf8mb4 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;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`id`, `name`, `username`, `email`, `password`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', 'admin@depottop.com', '$2y$10$OLHuTLz9WHkJPJijgxyNn.Zt/z5owqPcKG0ItNfqpVF121HVnyL56', NULL, '2024-11-22 14:46:08', '2024-11-26 12:16:36');
-- --------------------------------------------------------
--
-- Table structure for table `admin_password_resets`
--
CREATE TABLE `admin_password_resets` (
`id` bigint UNSIGNED NOT NULL,
`uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `agents`
--
CREATE TABLE `agents` (
`id` bigint UNSIGNED NOT NULL,
`uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`monthly_investment` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `agent_password_resets`
--
CREATE TABLE `agent_password_resets` (
`id` bigint UNSIGNED NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) CHARACTER SET utf8mb4 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 `agent_transactions`
--
CREATE TABLE `agent_transactions` (
`id` bigint UNSIGNED NOT NULL,
`agent_id` bigint UNSIGNED NOT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`post_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT '1',
`details` varchar(255) CHARACTER SET utf8mb4 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 `agent_withdraw_logs`
--
CREATE TABLE `agent_withdraw_logs` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`withdraw_method_id` bigint UNSIGNED NOT NULL,
`agent_id` bigint UNSIGNED NOT NULL,
`currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`final_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`after_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta` json DEFAULT NULL,
`details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '1',
`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 `commissions`
--
CREATE TABLE `commissions` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`from_user_id` bigint UNSIGNED DEFAULT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` tinyint NOT NULL DEFAULT '2',
`details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`investment_log_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contacts`
--
CREATE TABLE `contacts` (
`id` bigint UNSIGNED NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text CHARACTER SET utf8mb4 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 `crons`
--
CREATE TABLE `crons` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ideal_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_run` timestamp NULL 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 `crons`
--
INSERT INTO `crons` (`id`, `name`, `code`, `ideal_time`, `last_run`, `created_at`, `updated_at`) VALUES
(1, 'Crypto-Currency', '1', 'Daily', NULL, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(2, 'Investment Process', '2', 'Every Minute', NULL, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(3, 'Trade Outcome', '3', 'Every Minute', NULL, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(4, 'Queue Work', '4', 'Every Minute', NULL, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `crypto_currencies`
--
CREATE TABLE `crypto_currencies` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`pair` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`crypto_id` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`symbol` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`top_gainer` tinyint DEFAULT NULL,
`top_loser` tinyint DEFAULT NULL,
`meta` json 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_currencies`
--
INSERT INTO `crypto_currencies` (`id`, `name`, `pair`, `crypto_id`, `file`, `symbol`, `status`, `top_gainer`, `top_loser`, `meta`, `created_at`, `updated_at`) VALUES
(1, 'Bitcoin', 'BTC/USDT', 'bitcoin', 'https://coin-images.coingecko.com/coins/images/1/large/bitcoin.png?1696501400', 'btc', 1, 1, NULL, '{\"low_24h\": 95707, \"high_24h\": 99486, \"market_cap\": 1951035332845, \"total_supply\": 21000000, \"total_volume\": 111182081955, \"current_price\": 98624, \"price_change_24h\": 1085.21, \"market_cap_change_24h\": 22412522221}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(2, 'Ethereum', 'ETH/USDT', 'ethereum', 'https://coin-images.coingecko.com/coins/images/279/large/ethereum.png?1696501628', 'eth', 1, 2, NULL, '{\"low_24h\": 3127.13, \"high_24h\": 3418.54, \"market_cap\": 404991064628, \"total_supply\": 120428391.079985, \"total_volume\": 50034400815, \"current_price\": 3364.38, \"price_change_24h\": 235.18, \"market_cap_change_24h\": 27766856554}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(3, 'Tether', 'USDT/USDT', 'tether', 'https://coin-images.coingecko.com/coins/images/325/large/Tether.png?1696501661', 'usdt', 1, 3, NULL, '{\"low_24h\": 0.996161, \"high_24h\": 1.004, \"market_cap\": 130789834340, \"total_supply\": 130718783155.737, \"total_volume\": 168354997404, \"current_price\": 1.001, \"price_change_24h\": 0.00031679, \"market_cap_change_24h\": 540624943}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(4, 'Solana', 'SOL/USDT', 'solana', 'https://coin-images.coingecko.com/coins/images/4128/large/solana.png?1718769756', 'sol', 1, 4, NULL, '{\"low_24h\": 240.63, \"high_24h\": 262.93, \"market_cap\": 123140891510, \"total_supply\": 588786840.3860501, \"total_volume\": 14719787731, \"current_price\": 259.34, \"price_change_24h\": 16.309999999999995, \"market_cap_change_24h\": 7751667913}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(5, 'BNB', 'BNB/USDT', 'binancecoin', 'https://coin-images.coingecko.com/coins/images/825/large/bnb-icon2_2x.png?1696501970', 'bnb', 1, 5, NULL, '{\"low_24h\": 608.28, \"high_24h\": 638.52, \"market_cap\": 91684973121, \"total_supply\": 145887575.79, \"total_volume\": 2408763189, \"current_price\": 628.6799999999998, \"price_change_24h\": 18.02, \"market_cap_change_24h\": 2442069708}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(6, 'XRP', 'XRP/USDT', 'ripple', 'https://coin-images.coingecko.com/coins/images/44/large/xrp-symbol-white-128.png?1696501442', 'xrp', 1, 6, NULL, '{\"low_24h\": 1.099, \"high_24h\": 1.42, \"market_cap\": 79412716955, \"total_supply\": 99987013354, \"total_volume\": 19418819832, \"current_price\": 1.39, \"price_change_24h\": 0.269952, \"market_cap_change_24h\": 15159150300}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(7, 'Dogecoin', 'DOGE/USDT', 'dogecoin', 'https://coin-images.coingecko.com/coins/images/5/large/dogecoin.png?1696501409', 'doge', 1, 7, NULL, '{\"low_24h\": 0.378327, \"high_24h\": 0.398267, \"market_cap\": 57283494706, \"total_supply\": 146894946383.705, \"total_volume\": 10142157474, \"current_price\": 0.390049, \"price_change_24h\": 0.00739882, \"market_cap_change_24h\": 866125721}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(8, 'USDC', 'USDC/USDT', 'usd-coin', 'https://coin-images.coingecko.com/coins/images/6319/large/usdc.png?1696506694', 'usdc', 1, 8, NULL, '{\"low_24h\": 0.996238, \"high_24h\": 1.002, \"market_cap\": 38286428190, \"total_supply\": 38285412692.6348, \"total_volume\": 10599076152, \"current_price\": 0.999916, \"price_change_24h\": -0.000030311124619486004, \"market_cap_change_24h\": 540231503}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(9, 'Lido Staked Ether', 'STETH/USDT', 'staked-ether', 'https://coin-images.coingecko.com/coins/images/13442/large/steth_logo.png?1696513206', 'steth', 1, 9, NULL, '{\"low_24h\": 3125.6, \"high_24h\": 3412.53, \"market_cap\": 33003712967, \"total_supply\": 9810069.63254846, \"total_volume\": 136497309, \"current_price\": 3362.7, \"price_change_24h\": 232.89, \"market_cap_change_24h\": 2350757953}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(10, 'Cardano', 'ADA/USDT', 'cardano', 'https://coin-images.coingecko.com/coins/images/975/large/cardano.png?1696502090', 'ada', 1, 10, NULL, '{\"low_24h\": 0.771851, \"high_24h\": 0.893983, \"market_cap\": 30959760079, \"total_supply\": 45000000000, \"total_volume\": 3891168406, \"current_price\": 0.864904, \"price_change_24h\": 0.0872, \"market_cap_change_24h\": 2932294693}', '2024-11-22 14:46:10', '2024-11-22 14:46:12'),
(11, 'TRON', 'TRX/USDT', 'tron', 'https://coin-images.coingecko.com/coins/images/1094/large/tron-logo.png?1696502193', 'trx', 1, NULL, NULL, '{\"low_24h\": 0.196666, \"high_24h\": 0.20123, \"market_cap\": 17170399042, \"total_supply\": 86351636258.98392, \"total_volume\": 1063262660, \"current_price\": 0.198836, \"price_change_24h\": -0.000261748185700295, \"market_cap_change_24h\": -25784138.52622795}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(12, 'Avalanche', 'AVAX/USDT', 'avalanche-2', 'https://coin-images.coingecko.com/coins/images/12559/large/Avalanche_Circle_RedWhite_Trans.png?1696512369', 'avax', 1, NULL, NULL, '{\"low_24h\": 33.61999999999999, \"high_24h\": 36.63, \"market_cap\": 14880838545, \"total_supply\": 447444698.563116, \"total_volume\": 1074581832, \"current_price\": 36.38, \"price_change_24h\": 2.37, \"market_cap_change_24h\": 958048276}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(13, 'Shiba Inu', 'SHIB/USDT', 'shiba-inu', 'https://coin-images.coingecko.com/coins/images/11939/large/shiba.png?1696511800', 'shib', 1, NULL, NULL, '{\"low_24h\": 0.00002382, \"high_24h\": 0.00002531, \"market_cap\": 14624588109, \"total_supply\": 589512450521972, \"total_volume\": 1656474301, \"current_price\": 0.00002481, \"price_change_24h\": 0.000000788209, \"market_cap_change_24h\": 462485499}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(14, 'Wrapped Bitcoin', 'WBTC/USDT', 'wrapped-bitcoin', 'https://coin-images.coingecko.com/coins/images/7598/large/wrapped_bitcoin_wbtc.png?1696507857', 'wbtc', 1, NULL, NULL, '{\"low_24h\": 95376, \"high_24h\": 99244, \"market_cap\": 14436262299, \"total_supply\": 146072.42599595, \"total_volume\": 814826430, \"current_price\": 98826, \"price_change_24h\": 1523.63, \"market_cap_change_24h\": 224549746}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(15, 'Wrapped stETH', 'WSTETH/USDT', 'wrapped-steth', 'https://coin-images.coingecko.com/coins/images/18834/large/wstETH.png?1696518295', 'wsteth', 1, NULL, NULL, '{\"low_24h\": 3710.59, \"high_24h\": 4027.64, \"market_cap\": 14434450052, \"total_supply\": 3606550.58393222, \"total_volume\": 89058764, \"current_price\": 3993.37, \"price_change_24h\": 275.7, \"market_cap_change_24h\": 945978925}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(16, 'Toncoin', 'TON/USDT', 'the-open-network', 'https://coin-images.coingecko.com/coins/images/17980/large/photo_2024-09-10_17.09.00.jpeg?1725963446', 'ton', 1, NULL, NULL, '{\"low_24h\": 5.42, \"high_24h\": 5.59, \"market_cap\": 13973276318, \"total_supply\": 5115799021.84768, \"total_volume\": 539958696, \"current_price\": 5.48, \"price_change_24h\": -0.03263083591192206, \"market_cap_change_24h\": -72973368.84905052}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(17, 'Sui', 'SUI/USDT', 'sui', 'https://coin-images.coingecko.com/coins/images/26375/large/sui-ocean-square.png?1727791290', 'sui', 1, NULL, NULL, '{\"low_24h\": 3.36, \"high_24h\": 3.68, \"market_cap\": 10130308914, \"total_supply\": 10000000000, \"total_volume\": 2375895073, \"current_price\": 3.56, \"price_change_24h\": 0.02845176, \"market_cap_change_24h\": 84916444}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(18, 'Bitcoin Cash', 'BCH/USDT', 'bitcoin-cash', 'https://coin-images.coingecko.com/coins/images/780/large/bitcoin-cash-circle.png?1696501932', 'bch', 1, NULL, NULL, '{\"low_24h\": 475.09, \"high_24h\": 523.64, \"market_cap\": 9674606293, \"total_supply\": 21000000, \"total_volume\": 1380794397, \"current_price\": 488.41, \"price_change_24h\": -29.06728460183564, \"market_cap_change_24h\": -537828826.8051376}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(19, 'WETH', 'WETH/USDT', 'weth', 'https://coin-images.coingecko.com/coins/images/2518/large/weth.png?1696503332', 'weth', 1, NULL, NULL, '{\"low_24h\": 3124.16, \"high_24h\": 3425.18, \"market_cap\": 9648605832, \"total_supply\": 2865280.35491131, \"total_volume\": 1215714947, \"current_price\": 3365.2, \"price_change_24h\": 232.13, \"market_cap_change_24h\": 485977891}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(20, 'Chainlink', 'LINK/USDT', 'chainlink', 'https://coin-images.coingecko.com/coins/images/877/large/chainlink-new-logo.png?1696502009', 'link', 1, NULL, NULL, '{\"low_24h\": 14.42, \"high_24h\": 15.41, \"market_cap\": 9544431928, \"total_supply\": 1000000000, \"total_volume\": 1339833899, \"current_price\": 15.21, \"price_change_24h\": 0.622708, \"market_cap_change_24h\": 393650031}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(21, 'Pepe', 'PEPE/USDT', 'pepe', 'https://coin-images.coingecko.com/coins/images/29850/large/pepe-token.jpeg?1696528776', 'pepe', 1, NULL, NULL, '{\"low_24h\": 0.00001906, \"high_24h\": 0.00002174, \"market_cap\": 8870337381, \"total_supply\": 420690000000000, \"total_volume\": 6830773493, \"current_price\": 0.00002108, \"price_change_24h\": 0.00000181, \"market_cap_change_24h\": 762333199}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(22, 'Polkadot', 'DOT/USDT', 'polkadot', 'https://coin-images.coingecko.com/coins/images/12171/large/polkadot.png?1696512008', 'dot', 1, NULL, NULL, '{\"low_24h\": 5.6, \"high_24h\": 6.26, \"market_cap\": 8772199943, \"total_supply\": 1521085834.5699902, \"total_volume\": 868014523, \"current_price\": 6.09, \"price_change_24h\": 0.4303, \"market_cap_change_24h\": 607238228}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(23, 'Stellar', 'XLM/USDT', 'stellar', 'https://coin-images.coingecko.com/coins/images/100/large/Stellar_symbol_black_RGB.png?1696501482', 'xlm', 1, NULL, NULL, '{\"low_24h\": 0.235935, \"high_24h\": 0.288898, \"market_cap\": 8544204051, \"total_supply\": 50001786911.163, \"total_volume\": 2377201684, \"current_price\": 0.283999, \"price_change_24h\": 0.03892091, \"market_cap_change_24h\": 1181969996}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(24, 'LEO Token', 'LEO/USDT', 'leo-token', 'https://coin-images.coingecko.com/coins/images/8418/large/leo-token.png?1696508607', 'leo', 1, NULL, NULL, '{\"low_24h\": 8.52, \"high_24h\": 8.97, \"market_cap\": 8062505275, \"total_supply\": 985239504, \"total_volume\": 3543361, \"current_price\": 8.72, \"price_change_24h\": 0.184908, \"market_cap_change_24h\": 155068141}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(25, 'NEAR Protocol', 'NEAR/USDT', 'near', 'https://coin-images.coingecko.com/coins/images/10365/large/near.jpg?1696510367', 'near', 1, NULL, NULL, '{\"low_24h\": 5.39, \"high_24h\": 5.9, \"market_cap\": 6910483884, \"total_supply\": 1221457249, \"total_volume\": 1102955278, \"current_price\": 5.67, \"price_change_24h\": 0.184587, \"market_cap_change_24h\": 221366030}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(26, 'Litecoin', 'LTC/USDT', 'litecoin', 'https://coin-images.coingecko.com/coins/images/2/large/litecoin.png?1696501400', 'ltc', 1, NULL, NULL, '{\"low_24h\": 87.29, \"high_24h\": 91.17, \"market_cap\": 6813144713, \"total_supply\": 84000000, \"total_volume\": 1154718378, \"current_price\": 90.63, \"price_change_24h\": 0.480469, \"market_cap_change_24h\": 25587289}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(27, 'Aptos', 'APT/USDT', 'aptos', 'https://coin-images.coingecko.com/coins/images/26455/large/aptos_round.png?1696525528', 'apt', 1, NULL, NULL, '{\"low_24h\": 11.420000000000002, \"high_24h\": 12.29, \"market_cap\": 6365298441, \"total_supply\": 1127175246.44804, \"total_volume\": 728068315, \"current_price\": 11.93, \"price_change_24h\": 0.295513, \"market_cap_change_24h\": 160526344}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(28, 'Wrapped eETH', 'WEETH/USDT', 'wrapped-eeth', 'https://coin-images.coingecko.com/coins/images/33033/large/weETH.png?1701438396', 'weeth', 1, NULL, NULL, '{\"low_24h\": 3290.93, \"high_24h\": 3599.57, \"market_cap\": 6188994043, \"total_supply\": 1745110.8915612, \"total_volume\": 88577144, \"current_price\": 3545.66, \"price_change_24h\": 243.15, \"market_cap_change_24h\": 516388905}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(29, 'Uniswap', 'UNI/USDT', 'uniswap', 'https://coin-images.coingecko.com/coins/images/12504/large/uniswap-logo.png?1720676669', 'uni', 1, NULL, NULL, '{\"low_24h\": 8.71, \"high_24h\": 9.51, \"market_cap\": 5638626098, \"total_supply\": 1000000000, \"total_volume\": 899794314, \"current_price\": 9.39, \"price_change_24h\": 0.569825, \"market_cap_change_24h\": 338178120}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(30, 'USDS', 'USDS/USDT', 'usds', 'https://coin-images.coingecko.com/coins/images/39926/large/usds.webp?1726666683', 'usds', 1, NULL, NULL, '{\"low_24h\": 0.988067, \"high_24h\": 1.016, \"market_cap\": 5219944348, \"total_supply\": 5225894283.806509, \"total_volume\": 16122235, \"current_price\": 0.998099, \"price_change_24h\": 0.00205854, \"market_cap_change_24h\": -2297195.932405472}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(31, 'Hedera', 'HBAR/USDT', 'hedera-hashgraph', 'https://coin-images.coingecko.com/coins/images/3688/large/hbar.png?1696504364', 'hbar', 1, NULL, NULL, '{\"low_24h\": 0.119202, \"high_24h\": 0.138847, \"market_cap\": 5189615026, \"total_supply\": 50000000000, \"total_volume\": 1034922603, \"current_price\": 0.135883, \"price_change_24h\": 0.01165025, \"market_cap_change_24h\": 505223487}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(32, 'Cronos', 'CRO/USDT', 'crypto-com-chain', 'https://coin-images.coingecko.com/coins/images/7310/large/cro_token_logo.png?1696507599', 'cro', 1, NULL, NULL, '{\"low_24h\": 0.174386, \"high_24h\": 0.203952, \"market_cap\": 5179629986, \"total_supply\": 30000000000, \"total_volume\": 168900913, \"current_price\": 0.190678, \"price_change_24h\": 0.01552991, \"market_cap_change_24h\": 423409923}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(33, 'Internet Computer', 'ICP/USDT', 'internet-computer', 'https://coin-images.coingecko.com/coins/images/14495/large/Internet_Computer_logo.png?1696514180', 'icp', 1, NULL, NULL, '{\"low_24h\": 8.85, \"high_24h\": 9.77, \"market_cap\": 4574643708, \"total_supply\": 525619040.9618941, \"total_volume\": 281512705, \"current_price\": 9.64, \"price_change_24h\": 0.635312, \"market_cap_change_24h\": 301719047}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(34, 'Ethereum Classic', 'ETC/USDT', 'ethereum-classic', 'https://coin-images.coingecko.com/coins/images/453/large/ethereum-classic-logo.png?1696501717', 'etc', 1, NULL, NULL, '{\"low_24h\": 26.47, \"high_24h\": 28.24, \"market_cap\": 4196304042, \"total_supply\": 210700000, \"total_volume\": 826811639, \"current_price\": 28.05, \"price_change_24h\": 1.47, \"market_cap_change_24h\": 214595731}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(35, 'Bonk', 'BONK/USDT', 'bonk', 'https://coin-images.coingecko.com/coins/images/28600/large/bonk.jpg?1696527587', 'bonk', 1, NULL, NULL, '{\"low_24h\": 0.00004993, \"high_24h\": 0.00005386, \"market_cap\": 3848291594, \"total_supply\": 92696576090662.2, \"total_volume\": 1505985404, \"current_price\": 0.00005121, \"price_change_24h\": -0.000000232373132298, \"market_cap_change_24h\": -13701630.49700737}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(36, 'Kaspa', 'KAS/USDT', 'kaspa', 'https://coin-images.coingecko.com/coins/images/25751/large/kaspa-icon-exchanges.png?1696524837', 'kas', 1, NULL, NULL, '{\"low_24h\": 0.148555, \"high_24h\": 0.156919, \"market_cap\": 3795601319, \"total_supply\": 25206617035.6564, \"total_volume\": 149742014, \"current_price\": 0.150607, \"price_change_24h\": -0.0014591986123165808, \"market_cap_change_24h\": -35460144.97152662}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(37, 'Render', 'RENDER/USDT', 'render-token', 'https://coin-images.coingecko.com/coins/images/11636/large/rndr.png?1696511529', 'render', 1, NULL, NULL, '{\"low_24h\": 7.16, \"high_24h\": 7.6, \"market_cap\": 3777342563, \"total_supply\": 532450926.40549195, \"total_volume\": 406294478, \"current_price\": 7.29, \"price_change_24h\": -0.01854784908992979, \"market_cap_change_24h\": -16350863.767262938}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(38, 'Ethena USDe', 'USDE/USDT', 'ethena-usde', 'https://coin-images.coingecko.com/coins/images/33613/large/USDE.png?1716355685', 'usde', 1, NULL, NULL, '{\"low_24h\": 0.997573, \"high_24h\": 1.006, \"market_cap\": 3697757327, \"total_supply\": 3704456647.63293, \"total_volume\": 241944001, \"current_price\": 1.002, \"price_change_24h\": -0.000610270443646144, \"market_cap_change_24h\": 118661894}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(39, 'Bittensor', 'TAO/USDT', 'bittensor', 'https://coin-images.coingecko.com/coins/images/28452/large/ARUsPeNQ_400x400.jpeg?1696527447', 'tao', 1, NULL, NULL, '{\"low_24h\": 463.77, \"high_24h\": 527.66, \"market_cap\": 3693914860, \"total_supply\": 21000000, \"total_volume\": 245225192, \"current_price\": 500.41, \"price_change_24h\": 28.47, \"market_cap_change_24h\": 210338862}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(40, 'POL (ex-MATIC)', 'POL/USDT', 'polygon-ecosystem-token', 'https://coin-images.coingecko.com/coins/images/32440/large/polygon.png?1698233684', 'pol', 1, NULL, NULL, '{\"low_24h\": 0.429829, \"high_24h\": 0.477169, \"market_cap\": 3667132386, \"total_supply\": 10303710865.0097, \"total_volume\": 503708176, \"current_price\": 0.460179, \"price_change_24h\": 0.02470306, \"market_cap_change_24h\": 188165953}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(41, 'WhiteBIT Coin', 'WBT/USDT', 'whitebit', 'https://coin-images.coingecko.com/coins/images/27045/large/wbt_token.png?1696526096', 'wbt', 1, NULL, 1, '{\"low_24h\": 24.09, \"high_24h\": 24.94, \"market_cap\": 3579606762, \"total_supply\": 339500778, \"total_volume\": 36165072, \"current_price\": 24.84, \"price_change_24h\": 0.684133, \"market_cap_change_24h\": 98871547}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(42, 'Dai', 'DAI/USDT', 'dai', 'https://coin-images.coingecko.com/coins/images/9956/large/Badge_Dai.png?1696509996', 'dai', 1, NULL, 2, '{\"low_24h\": 0.9955520000000002, \"high_24h\": 1.004, \"market_cap\": 3443907099, \"total_supply\": 3445863873.8993907, \"total_volume\": 148743406, \"current_price\": 0.999735, \"price_change_24h\": -0.000925137560725653, \"market_cap_change_24h\": 13885636}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(43, 'MANTRA', 'OM/USDT', 'mantra-dao', 'https://coin-images.coingecko.com/coins/images/12151/large/OM_Token.png?1696511991', 'om', 1, NULL, 3, '{\"low_24h\": 3.43, \"high_24h\": 4.05, \"market_cap\": 3382337938, \"total_supply\": 1786854010.63, \"total_volume\": 333749102, \"current_price\": 3.74, \"price_change_24h\": 0.169679, \"market_cap_change_24h\": 137656631}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(44, 'Artificial Superintelligence Alliance', 'FET/USDT', 'fetch-ai', 'https://coin-images.coingecko.com/coins/images/5681/large/ASI.png?1719827289', 'fet', 1, NULL, 4, '{\"low_24h\": 1.21, \"high_24h\": 1.3, \"market_cap\": 3303236263, \"total_supply\": 2719493896.672, \"total_volume\": 489746788, \"current_price\": 1.27, \"price_change_24h\": 0.04593042, \"market_cap_change_24h\": 116069480}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(45, 'dogwifhat', 'WIF/USDT', 'dogwifcoin', 'https://coin-images.coingecko.com/coins/images/33566/large/dogwifhat.jpg?1702499428', 'wif', 1, NULL, 5, '{\"low_24h\": 3.06, \"high_24h\": 3.42, \"market_cap\": 3292718717, \"total_supply\": 998926392, \"total_volume\": 1371330071, \"current_price\": 3.29, \"price_change_24h\": 0.186983, \"market_cap_change_24h\": 164034727}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(46, 'Arbitrum', 'ARB/USDT', 'arbitrum', 'https://coin-images.coingecko.com/coins/images/16547/large/arb.jpg?1721358242', 'arb', 1, NULL, 6, '{\"low_24h\": 0.690484, \"high_24h\": 0.813134, \"market_cap\": 3256276622, \"total_supply\": 10000000000, \"total_volume\": 1704950606, \"current_price\": 0.794547, \"price_change_24h\": 0.100196, \"market_cap_change_24h\": 396018930}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(47, 'Monero', 'XMR/USDT', 'monero', 'https://coin-images.coingecko.com/coins/images/69/large/monero_logo.png?1696501460', 'xmr', 1, NULL, 7, '{\"low_24h\": 159.38999999999996, \"high_24h\": 162.91, \"market_cap\": 2956154189, \"total_supply\": 18446744.0737096, \"total_volume\": 80689448, \"current_price\": 160.25, \"price_change_24h\": -1.9858958200849768, \"market_cap_change_24h\": -32217299.35093212}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(48, 'Stacks', 'STX/USDT', 'blockstack', 'https://coin-images.coingecko.com/coins/images/2069/large/Stacks_Logo_png.png?1709979332', 'stx', 1, NULL, 8, '{\"low_24h\": 1.88, \"high_24h\": 2, \"market_cap\": 2907222473, \"total_supply\": 1501755756.91888, \"total_volume\": 338028587, \"current_price\": 1.94, \"price_change_24h\": 0.01721331, \"market_cap_change_24h\": 26099175}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(49, 'Mantle', 'MNT/USDT', 'mantle', 'https://coin-images.coingecko.com/coins/images/30980/large/token-logo.png?1696529819', 'mnt', 1, NULL, 9, '{\"low_24h\": 0.751504, \"high_24h\": 0.853294, \"market_cap\": 2865923111, \"total_supply\": 6219316794.990001, \"total_volume\": 200827378, \"current_price\": 0.849471, \"price_change_24h\": 0.095477, \"market_cap_change_24h\": 327183132}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(50, 'Filecoin', 'FIL/USDT', 'filecoin', 'https://coin-images.coingecko.com/coins/images/12817/large/filecoin.png?1696512609', 'fil', 1, NULL, 10, '{\"low_24h\": 4.43, \"high_24h\": 4.73, \"market_cap\": 2782440334, \"total_supply\": 1959850068, \"total_volume\": 528141660, \"current_price\": 4.63, \"price_change_24h\": 0.147775, \"market_cap_change_24h\": 91133614}', '2024-11-22 14:46:11', '2024-11-22 14:46:12'),
(51, 'OKB', 'OKB/USDT', 'okb', 'https://coin-images.coingecko.com/coins/images/4463/large/WeChat_Image_20220118095654.png?1696505053', 'okb', 1, NULL, NULL, '{\"low_24h\": 43.95, \"high_24h\": 46.86, \"market_cap\": 2760207472, \"total_supply\": 235957685.3, \"total_volume\": 20116858, \"current_price\": 45.99, \"price_change_24h\": 1.71, \"market_cap_change_24h\": 103699558}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(52, 'Optimism', 'OP/USDT', 'optimism', 'https://coin-images.coingecko.com/coins/images/25244/large/Optimism.png?1696524385', 'op', 1, NULL, NULL, '{\"low_24h\": 1.67, \"high_24h\": 2.18, \"market_cap\": 2662416555, \"total_supply\": 4294967296, \"total_volume\": 1580122515, \"current_price\": 2.12, \"price_change_24h\": 0.432785, \"market_cap_change_24h\": 540499618}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(53, 'VeChain', 'VET/USDT', 'vechain', 'https://coin-images.coingecko.com/coins/images/1167/large/VET_Token_Icon.png?1710013505', 'vet', 1, NULL, NULL, '{\"low_24h\": 0.03119046, \"high_24h\": 0.03367289, \"market_cap\": 2638527004, \"total_supply\": 85985041177, \"total_volume\": 146544632, \"current_price\": 0.03263086, \"price_change_24h\": 0.0010668, \"market_cap_change_24h\": 76290496}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(54, 'Cosmos Hub', 'ATOM/USDT', 'cosmos', 'https://coin-images.coingecko.com/coins/images/1481/large/cosmos_hub.png?1696502525', 'atom', 1, NULL, NULL, '{\"low_24h\": 6.05, \"high_24h\": 6.68, \"market_cap\": 2609447014, \"total_supply\": 390930035.085365, \"total_volume\": 403883199, \"current_price\": 6.69, \"price_change_24h\": 0.552731, \"market_cap_change_24h\": 209876120}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(55, 'Aave', 'AAVE/USDT', 'aave', 'https://coin-images.coingecko.com/coins/images/12645/large/aave-token-round.png?1720472354', 'aave', 1, NULL, NULL, '{\"low_24h\": 156.75, \"high_24h\": 171.15, \"market_cap\": 2515780706, \"total_supply\": 16000000, \"total_volume\": 465577625, \"current_price\": 167.93, \"price_change_24h\": 9.47, \"market_cap_change_24h\": 140104156}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(56, 'FLOKI', 'FLOKI/USDT', 'floki', 'https://coin-images.coingecko.com/coins/images/16746/large/PNG_image.png?1696516318', 'floki', 1, NULL, NULL, '{\"low_24h\": 0.00025043, \"high_24h\": 0.00026617, \"market_cap\": 2495255637, \"total_supply\": 10000000000000, \"total_volume\": 1033443951, \"current_price\": 0.00025758, \"price_change_24h\": 0.0000023900000000000004, \"market_cap_change_24h\": 23330927}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(57, 'Injective', 'INJ/USDT', 'injective-protocol', 'https://coin-images.coingecko.com/coins/images/12882/large/Secondary_Symbol.png?1696512670', 'inj', 1, NULL, NULL, '{\"low_24h\": 23.21, \"high_24h\": 25.52, \"market_cap\": 2434973573, \"total_supply\": 100000000, \"total_volume\": 277908673, \"current_price\": 24.92, \"price_change_24h\": 1.49, \"market_cap_change_24h\": 143777954}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(58, 'Celestia', 'TIA/USDT', 'celestia', 'https://coin-images.coingecko.com/coins/images/31967/large/tia.jpg?1696530772', 'tia', 1, NULL, NULL, '{\"low_24h\": 4.9, \"high_24h\": 5.67, \"market_cap\": 2345528588, \"total_supply\": 1084686904.10929, \"total_volume\": 425527889, \"current_price\": 5.52, \"price_change_24h\": 0.538624, \"market_cap_change_24h\": 227521428}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(59, 'Immutable', 'IMX/USDT', 'immutable-x', 'https://coin-images.coingecko.com/coins/images/17233/large/immutableX-symbol-BLK-RGB.png?1696516787', 'imx', 1, NULL, NULL, '{\"low_24h\": 1.26, \"high_24h\": 1.38, \"market_cap\": 2279464768, \"total_supply\": 2000000000, \"total_volume\": 154336683, \"current_price\": 1.36, \"price_change_24h\": 0.083975, \"market_cap_change_24h\": 139116518}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(60, 'First Digital USD', 'FDUSD/USDT', 'first-digital-usd', 'https://coin-images.coingecko.com/coins/images/31079/large/FDUSD_icon_black.png?1731097953', 'fdusd', 1, NULL, NULL, '{\"low_24h\": 0.991513, \"high_24h\": 1.003, \"market_cap\": 2231861349, \"total_supply\": 2236360230.44, \"total_volume\": 10357446453, \"current_price\": 0.998673, \"price_change_24h\": 0.00141095, \"market_cap_change_24h\": -69834046.78869963}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(61, 'The Graph', 'GRT/USDT', 'the-graph', 'https://coin-images.coingecko.com/coins/images/13397/large/Graph_Token.png?1696513159', 'grt', 1, NULL, NULL, '{\"low_24h\": 0.211095, \"high_24h\": 0.227063, \"market_cap\": 2104349268, \"total_supply\": 10788004319, \"total_volume\": 204867383, \"current_price\": 0.220218, \"price_change_24h\": 0.00637609, \"market_cap_change_24h\": 61370098}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(62, 'Bitget Token', 'BGB/USDT', 'bitget-token', 'https://coin-images.coingecko.com/coins/images/11610/large/icon_colour.png?1696511504', 'bgb', 1, NULL, NULL, '{\"low_24h\": 1.38, \"high_24h\": 1.49, \"market_cap\": 2066834270, \"total_supply\": 2000000000, \"total_volume\": 76403752, \"current_price\": 1.48, \"price_change_24h\": 0.08442, \"market_cap_change_24h\": 118437490}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(63, 'Sei', 'SEI/USDT', 'sei-network', 'https://coin-images.coingecko.com/coins/images/28205/large/Sei_Logo_-_Transparent.png?1696527207', 'sei', 1, NULL, NULL, '{\"low_24h\": 0.456799, \"high_24h\": 0.500213, \"market_cap\": 2062072844, \"total_supply\": 10000000000, \"total_volume\": 335516422, \"current_price\": 0.48511, \"price_change_24h\": 0.02048002, \"market_cap_change_24h\": 86148412}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(64, 'Binance-Peg WETH', 'WETH/USDT', 'binance-peg-weth', 'https://coin-images.coingecko.com/coins/images/39580/large/weth.png?1723006716', 'weth', 1, NULL, NULL, '{\"low_24h\": 3125.96, \"high_24h\": 3414.77, \"market_cap\": 2035289913, \"total_supply\": 604999.999959841, \"total_volume\": 151541645, \"current_price\": 3359.83, \"price_change_24h\": 231.48, \"market_cap_change_24h\": 140868399}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(65, 'Algorand', 'ALGO/USDT', 'algorand', 'https://coin-images.coingecko.com/coins/images/4380/large/download.png?1696504978', 'algo', 1, NULL, NULL, '{\"low_24h\": 0.203505, \"high_24h\": 0.242308, \"market_cap\": 2006312741, \"total_supply\": 8280000453.312711, \"total_volume\": 386560577, \"current_price\": 0.242528, \"price_change_24h\": 0.03442557, \"market_cap_change_24h\": 282816506}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(66, 'Fantom', 'FTM/USDT', 'fantom', 'https://coin-images.coingecko.com/coins/images/4001/large/Fantom_round.png?1696504642', 'ftm', 1, NULL, NULL, '{\"low_24h\": 0.665295, \"high_24h\": 0.723484, \"market_cap\": 1996797266, \"total_supply\": 3175000000, \"total_volume\": 448717602, \"current_price\": 0.712193, \"price_change_24h\": 0.03442951, \"market_cap_change_24h\": 94562049}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(67, 'THORChain', 'RUNE/USDT', 'thorchain', 'https://coin-images.coingecko.com/coins/images/6595/large/Rune200x200.png?1696506946', 'rune', 1, NULL, NULL, '{\"low_24h\": 5.18, \"high_24h\": 5.45, \"market_cap\": 1829958156, \"total_supply\": 415070384, \"total_volume\": 565543633, \"current_price\": 5.39, \"price_change_24h\": 0.145098, \"market_cap_change_24h\": 52251311}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(68, 'Raydium', 'RAY/USDT', 'raydium', 'https://coin-images.coingecko.com/coins/images/13928/large/PSigc4ie_400x400.jpg?1696513668', 'ray', 1, NULL, NULL, '{\"low_24h\": 5.63, \"high_24h\": 6.49, \"market_cap\": 1780331332, \"total_supply\": 555000000, \"total_volume\": 303738065, \"current_price\": 6.12, \"price_change_24h\": 0.35388, \"market_cap_change_24h\": 100998178}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(69, 'Ethena', 'ENA/USDT', 'ethena', 'https://coin-images.coingecko.com/coins/images/36530/large/ethena.png?1711701436', 'ena', 1, NULL, NULL, '{\"low_24h\": 0.510565, \"high_24h\": 0.615236, \"market_cap\": 1749210544, \"total_supply\": 15000000000, \"total_volume\": 521994909, \"current_price\": 0.615249, \"price_change_24h\": 0.092151, \"market_cap_change_24h\": 262063301}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(70, 'Rocket Pool ETH', 'RETH/USDT', 'rocket-pool-eth', 'https://coin-images.coingecko.com/coins/images/20764/large/reth.png?1696520159', 'reth', 1, NULL, NULL, '{\"low_24h\": 3499.55, \"high_24h\": 3810.56, \"market_cap\": 1748979350, \"total_supply\": 465931.3400771011, \"total_volume\": 44753857, \"current_price\": 3754.01, \"price_change_24h\": 245.86, \"market_cap_change_24h\": 112602880}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(71, 'Theta Network', 'THETA/USDT', 'theta-token', 'https://coin-images.coingecko.com/coins/images/2538/large/theta-token-logo.png?1696503349', 'theta', 1, NULL, NULL, '{\"low_24h\": 1.58, \"high_24h\": 1.72, \"market_cap\": 1698278086, \"total_supply\": 1000000000, \"total_volume\": 73213603, \"current_price\": 1.7, \"price_change_24h\": 0.094321, \"market_cap_change_24h\": 93532594}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(72, 'Brett', 'BRETT/USDT', 'based-brett', 'https://coin-images.coingecko.com/coins/images/35529/large/1000050750.png?1709031995', 'brett', 1, NULL, NULL, '{\"low_24h\": 0.1552, \"high_24h\": 0.17121, \"market_cap\": 1624562383, \"total_supply\": 9910077330.83382, \"total_volume\": 135421964, \"current_price\": 0.164035, \"price_change_24h\": 0.00678668, \"market_cap_change_24h\": 66665215}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(73, 'Worldcoin', 'WLD/USDT', 'worldcoin-wld', 'https://coin-images.coingecko.com/coins/images/31069/large/worldcoin.jpeg?1696529903', 'wld', 1, NULL, NULL, '{\"low_24h\": 2.07, \"high_24h\": 2.32, \"market_cap\": 1622334281, \"total_supply\": 10000000000, \"total_volume\": 741237867, \"current_price\": 2.27, \"price_change_24h\": 0.159439, \"market_cap_change_24h\": 195196244}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(74, 'Coinbase Wrapped BTC', 'CBBTC/USDT', 'coinbase-wrapped-btc', 'https://coin-images.coingecko.com/coins/images/40143/large/cbbtc.webp?1726136727', 'cbbtc', 1, NULL, NULL, '{\"low_24h\": 95335, \"high_24h\": 99508, \"market_cap\": 1618471612, \"total_supply\": 16549.47759152, \"total_volume\": 598617013, \"current_price\": 98672, \"price_change_24h\": 1104.57, \"market_cap_change_24h\": 49032488}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(75, 'Mantle Staked Ether', 'METH/USDT', 'mantle-staked-ether', 'https://coin-images.coingecko.com/coins/images/33345/large/symbol_transparent_bg.png?1701697066', 'meth', 1, NULL, NULL, '{\"low_24h\": 3270.05, \"high_24h\": 3583.14, \"market_cap\": 1617073444, \"total_supply\": 457393.869855724, \"total_volume\": 45232288, \"current_price\": 3522, \"price_change_24h\": 229.24, \"market_cap_change_24h\": 108930177}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(76, 'Popcat', 'POPCAT/USDT', 'popcat', 'https://coin-images.coingecko.com/coins/images/33760/large/image.jpg?1702964227', 'popcat', 1, NULL, NULL, '{\"low_24h\": 1.51, \"high_24h\": 1.6299999999999997, \"market_cap\": 1540311417, \"total_supply\": 979978669.96, \"total_volume\": 155541164, \"current_price\": 1.57, \"price_change_24h\": 0.04798594, \"market_cap_change_24h\": 40413271}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(77, 'Solv Protocol SolvBTC', 'SOLVBTC/USDT', 'solv-btc', 'https://coin-images.coingecko.com/coins/images/36800/large/solvBTC.png?1719810684', 'solvbtc', 1, NULL, NULL, '{\"low_24h\": 95779, \"high_24h\": 99217, \"market_cap\": 1539114321, \"total_supply\": 15623.9663346393, \"total_volume\": 10917105, \"current_price\": 98541, \"price_change_24h\": 1315.94, \"market_cap_change_24h\": 9026754}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(78, 'Jupiter', 'JUP/USDT', 'jupiter-exchange-solana', 'https://coin-images.coingecko.com/coins/images/34188/large/jup.png?1704266489', 'jup', 1, NULL, NULL, '{\"low_24h\": 1.054, \"high_24h\": 1.16, \"market_cap\": 1523196869, \"total_supply\": 10000000000, \"total_volume\": 357188789, \"current_price\": 1.13, \"price_change_24h\": 0.058717, \"market_cap_change_24h\": 78957527}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(79, 'Renzo Restaked ETH', 'EZETH/USDT', 'renzo-restaked-eth', 'https://coin-images.coingecko.com/coins/images/34753/large/Ezeth_logo_circle.png?1713496404', 'ezeth', 1, NULL, NULL, '{\"low_24h\": 3202.86, \"high_24h\": 3508.34, \"market_cap\": 1502202165, \"total_supply\": 435658.08851286094, \"total_volume\": 10174916, \"current_price\": 3447.23, \"price_change_24h\": 233.99, \"market_cap_change_24h\": 87611179}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(80, 'Maker', 'MKR/USDT', 'maker', 'https://coin-images.coingecko.com/coins/images/1364/large/Mark_Maker.png?1696502423', 'mkr', 1, NULL, NULL, '{\"low_24h\": 1528.23, \"high_24h\": 1719.25, \"market_cap\": 1478739247, \"total_supply\": 913907.860916421, \"total_volume\": 240571336, \"current_price\": 1673.08, \"price_change_24h\": 135.65, \"market_cap_change_24h\": 123717989}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(81, 'Pyth Network', 'PYTH/USDT', 'pyth-network', 'https://coin-images.coingecko.com/coins/images/31924/large/pyth.png?1701245725', 'pyth', 1, NULL, NULL, '{\"low_24h\": 0.392765, \"high_24h\": 0.425479, \"market_cap\": 1471688535, \"total_supply\": 10000000000, \"total_volume\": 188090697, \"current_price\": 0.405734, \"price_change_24h\": 0.00594808, \"market_cap_change_24h\": 19213293}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(82, 'Ondo', 'ONDO/USDT', 'ondo-finance', 'https://coin-images.coingecko.com/coins/images/26580/large/ONDO.png?1696525656', 'ondo', 1, NULL, NULL, '{\"low_24h\": 0.962569, \"high_24h\": 1.026, \"market_cap\": 1425436099, \"total_supply\": 10000000000, \"total_volume\": 229529747, \"current_price\": 0.99134, \"price_change_24h\": 0.0104624, \"market_cap_change_24h\": 14980493}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(83, 'Marinade Staked SOL', 'MSOL/USDT', 'msol', 'https://coin-images.coingecko.com/coins/images/17752/large/mSOL.png?1696517278', 'msol', 1, NULL, NULL, '{\"low_24h\": 296.55, \"high_24h\": 324.39, \"market_cap\": 1373649514, \"total_supply\": 4283662, \"total_volume\": 30219330, \"current_price\": 320.7, \"price_change_24h\": 20.1, \"market_cap_change_24h\": 85140436}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(84, 'Bitcoin SV', 'BSV/USDT', 'bitcoin-cash-sv', 'https://coin-images.coingecko.com/coins/images/6799/large/BSV.png?1696507128', 'bsv', 1, NULL, NULL, '{\"low_24h\": 66.17, \"high_24h\": 76.82, \"market_cap\": 1343778132, \"total_supply\": 21000000, \"total_volume\": 157551343, \"current_price\": 67.89, \"price_change_24h\": -8.348774934821307, \"market_cap_change_24h\": -160813709.63437796}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(85, 'KuCoin', 'KCS/USDT', 'kucoin-shares', 'https://coin-images.coingecko.com/coins/images/1047/large/sa9z79.png?1696502152', 'kcs', 1, NULL, NULL, '{\"low_24h\": 10.84, \"high_24h\": 11.2, \"market_cap\": 1334713053, \"total_supply\": 142757114.14608, \"total_volume\": 486662, \"current_price\": 11.09, \"price_change_24h\": 0.102144, \"market_cap_change_24h\": 13655220}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(86, 'Gate', 'GT/USDT', 'gatechain-token', 'https://coin-images.coingecko.com/coins/images/8183/large/gate.png?1696508395', 'gt', 1, NULL, NULL, '{\"low_24h\": 9.68, \"high_24h\": 10.39, \"market_cap\": 1275044477, \"total_supply\": 300000000, \"total_volume\": 6540627, \"current_price\": 10.13, \"price_change_24h\": 0.323327, \"market_cap_change_24h\": 41171700}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(87, 'Quant', 'QNT/USDT', 'quant-network', 'https://coin-images.coingecko.com/coins/images/3370/large/5ZOu7brX_400x400.jpg?1696504070', 'qnt', 1, NULL, NULL, '{\"low_24h\": 84.9, \"high_24h\": 89.39, \"market_cap\": 1252090153, \"total_supply\": 14612493, \"total_volume\": 67952186, \"current_price\": 86.1, \"price_change_24h\": -1.16266565898124, \"market_cap_change_24h\": -17357029.67887664}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(88, 'Peanut the Squirrel', 'PNUT/USDT', 'peanut-the-squirrel', 'https://coin-images.coingecko.com/coins/images/51301/large/pnut.jpg?1730602041', 'pnut', 1, NULL, NULL, '{\"low_24h\": 1.2400000000000002, \"high_24h\": 1.52, \"market_cap\": 1246916295, \"total_supply\": 999858912.07, \"total_volume\": 2340772559, \"current_price\": 1.2400000000000002, \"price_change_24h\": -0.10355081569436277, \"market_cap_change_24h\": -101086467.96760008}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(89, 'Arweave', 'AR/USDT', 'arweave', 'https://coin-images.coingecko.com/coins/images/4343/large/oRt6SiEN_400x400.jpg?1696504946', 'ar', 1, NULL, NULL, '{\"low_24h\": 17.01, \"high_24h\": 18.56, \"market_cap\": 1184531055, \"total_supply\": 65454185.5381511, \"total_volume\": 170748231, \"current_price\": 18.09, \"price_change_24h\": 0.73976, \"market_cap_change_24h\": 48323692}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(90, 'Flare', 'FLR/USDT', 'flare-networks', 'https://coin-images.coingecko.com/coins/images/28624/large/FLR-icon200x200.png?1696527609', 'flr', 1, NULL, NULL, '{\"low_24h\": 0.0195841, \"high_24h\": 0.02292811, \"market_cap\": 1161102280, \"total_supply\": 102755942027.255, \"total_volume\": 44255149, \"current_price\": 0.02202003, \"price_change_24h\": 0.00214715, \"market_cap_change_24h\": 112176870}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(91, 'GALA', 'GALA/USDT', 'gala', 'https://coin-images.coingecko.com/coins/images/12493/large/GALA_token_image_-_200PNG.png?1709725869', 'gala', 1, NULL, NULL, '{\"low_24h\": 0.02733222, \"high_24h\": 0.02984628, \"market_cap\": 1151597527, \"total_supply\": 39995741228.78369, \"total_volume\": 310944473, \"current_price\": 0.02879095, \"price_change_24h\": 0.00092038, \"market_cap_change_24h\": 37145896}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(92, 'Mog Coin', 'MOG/USDT', 'mog-coin', 'https://coin-images.coingecko.com/coins/images/31059/large/MOG_LOGO_200x200.png?1696529893', 'mog', 1, NULL, NULL, '{\"low_24h\": 0.0000023500000000000004, \"high_24h\": 0.0000029700000000000004, \"market_cap\": 1150956066, \"total_supply\": 390567524379064.56, \"total_volume\": 154640061, \"current_price\": 0.0000029600000000000005, \"price_change_24h\": 0.000000531528, \"market_cap_change_24h\": 199488063}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(93, 'Tezos', 'XTZ/USDT', 'tezos', 'https://coin-images.coingecko.com/coins/images/976/large/Tezos-logo.png?1696502091', 'xtz', 1, NULL, NULL, '{\"low_24h\": 1.013, \"high_24h\": 1.13, \"market_cap\": 1138735676, \"total_supply\": 1034616225.06234, \"total_volume\": 179100417, \"current_price\": 1.13, \"price_change_24h\": 0.102956, \"market_cap_change_24h\": 100006184}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(94, 'Beam', 'BEAM/USDT', 'beam-2', 'https://coin-images.coingecko.com/coins/images/32417/large/chain-logo.png?1698114384', 'beam', 1, NULL, NULL, '{\"low_24h\": 0.02084459, \"high_24h\": 0.02244351, \"market_cap\": 1126141499, \"total_supply\": 61148853857, \"total_volume\": 61797134, \"current_price\": 0.02152505, \"price_change_24h\": 0.00041103, \"market_cap_change_24h\": 22983699}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(95, 'BitTorrent', 'BTT/USDT', 'bittorrent', 'https://coin-images.coingecko.com/coins/images/22457/large/btt_logo.png?1696521780', 'btt', 1, NULL, NULL, '{\"low_24h\": 0.0000011100000000000002, \"high_24h\": 0.00000119, \"market_cap\": 1122234367, \"total_supply\": 990000000000000, \"total_volume\": 108736437, \"current_price\": 0.00000116, \"price_change_24h\": -0.000000004372673684, \"market_cap_change_24h\": -4843082.621259689}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(96, 'Flow', 'FLOW/USDT', 'flow', 'https://coin-images.coingecko.com/coins/images/13446/large/5f6294c0c7a8cda55cb1c936_Flow_Wordmark.png?1696513210', 'flow', 1, NULL, NULL, '{\"low_24h\": 0.675411, \"high_24h\": 0.73272, \"market_cap\": 1115787607, \"total_supply\": 1546208578.96295, \"total_volume\": 85442854, \"current_price\": 0.721547, \"price_change_24h\": 0.03658632, \"market_cap_change_24h\": 56389658}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(97, 'Lombard Staked BTC', 'LBTC/USDT', 'lombard-staked-btc', 'https://coin-images.coingecko.com/coins/images/39969/large/LBTC_Logo.png?1724959872', 'lbtc', 1, NULL, NULL, '{\"low_24h\": 95541, \"high_24h\": 99341, \"market_cap\": 1099414402, \"total_supply\": 11186.91092395, \"total_volume\": 12173918, \"current_price\": 98728, \"price_change_24h\": 1431.28, \"market_cap_change_24h\": 9510648}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(98, 'Lido DAO', 'LDO/USDT', 'lido-dao', 'https://coin-images.coingecko.com/coins/images/13573/large/Lido_DAO.png?1696513326', 'ldo', 1, NULL, NULL, '{\"low_24h\": 1.1, \"high_24h\": 1.25, \"market_cap\": 1089278115, \"total_supply\": 1000000000, \"total_volume\": 353374461, \"current_price\": 1.22, \"price_change_24h\": 0.09973, \"market_cap_change_24h\": 89030846}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(99, 'Polygon', 'MATIC/USDT', 'matic-network', 'https://coin-images.coingecko.com/coins/images/4713/large/polygon.png?1698233745', 'matic', 1, NULL, NULL, '{\"low_24h\": 0.429683, \"high_24h\": 0.476416, \"market_cap\": 1073526469, \"total_supply\": 10000000000, \"total_volume\": 20567509, \"current_price\": 0.459757, \"price_change_24h\": 0.0239618, \"market_cap_change_24h\": 56168524}', '2024-11-22 14:46:11', '2024-11-22 14:46:11'),
(100, 'EOS', 'EOS/USDT', 'eos', 'https://coin-images.coingecko.com/coins/images/738/large/CG_EOS_Icon.png?1731705232', 'eos', 1, NULL, NULL, '{\"low_24h\": 0.635993, \"high_24h\": 0.702625, \"market_cap\": 1065940464, \"total_supply\": 2100000000, \"total_volume\": 242084237, \"current_price\": 0.702049, \"price_change_24h\": 0.05416, \"market_cap_change_24h\": 82756871}', '2024-11-22 14:46:11', '2024-11-22 14:46:11');
-- --------------------------------------------------------
--
-- Table structure for table `deposits`
--
CREATE TABLE `deposits` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`payment_gateway_id` bigint UNSIGNED NOT NULL,
`rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`final_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypto_meta` json DEFAULT NULL,
`meta` json DEFAULT NULL,
`wallet_type` tinyint NOT NULL DEFAULT '1',
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`btc_wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`btc_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `email_sms_templates`
--
CREATE TABLE `email_sms_templates` (
`id` bigint UNSIGNED NOT NULL,
`code` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`from_email` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mail_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`sms_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`short_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '2' COMMENT 'Active : 1, Inactive : 0',
`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 `email_sms_templates`
--
INSERT INTO `email_sms_templates` (`id`, `code`, `name`, `subject`, `from_email`, `mail_template`, `sms_template`, `short_key`, `status`, `created_at`, `updated_at`) VALUES
(1, 'agent-credentials', 'Agent Credentials', 'Agent Credentials for access', 'demo@gmail.com', 'Please find your login credentials below: Email: [email] Password: [Password] If you encounter any issues or need further assistance, feel free to reach out.', 'Please find your login credentials below: Email: [email] Password: [Password] If you encounter any issues or need further assistance, feel free to reach out.', '{\"email\":\"Email Address\",\"password\":\"Password\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(2, 'password_reset_code', 'Password Reset for User', 'Password Reset mail', 'demo@gmail.com', 'We have received a request to reset the password for your account', 'Your account recovery code is: [token]', '{\"token\":\"Password Reset Code\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(3, 'admin_password_reset_code', 'Admin Password Reset', 'admin Password Reset mail', 'demo@gmail.com', 'We have received a request to reset the password for your account', 'Your account recovery code is: [code]', '{\"code\":\"Password Reset Code\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(4, 'balance_add', 'Balance add by admin', 'Your Account has been credited', 'demo@gmail.com', 'Payment Confirm', 'Payment Confirm', '{\"amount\":\"Request Amount by admin\",\"wallet_name\":\"Wallet Name\",\"currency\":\"Site Currency\",\"post_balance\":\"Users Balance After this operation\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(5, 'balance_subtract', 'Balance subtract by admin', 'Your Account has been debited', 'demo@gmail.com', 'Payment Confirm', 'Payment Confirm', '{\"amount\":\"Request Amount by admin\",\"wallet_type\":\"Wallet Name\",\"currency\":\"Site Currency\",\"post_balance\":\"Users Balance After this operation\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(6, 'withdraw_request', 'Withdraw Request', 'Withdraw Request', 'demo@gmail.com', 'Withdraw Request', 'Withdraw Request', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(7, 'withdraw_approved', 'Withdraw Approved', 'Withdraw Approved', 'demo@gmail.com', 'Withdraw Approved', 'Withdraw Approved', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(8, 'withdraw_rejected', 'Withdraw Rejected', 'Withdraw Rejected', 'demo@gmail.com', 'Withdraw Rejected', 'Withdraw Rejected', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(9, 'deposit_approved', 'Approved Deposit', 'Deposit Approved', 'demo@gmail.com', 'Deposit', 'Deposit', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(10, 'traditional_deposit', 'Traditional Deposit', 'Traditional Deposit', 'demo@gmail.com', 'Traditional deposit', 'Traditional deposit', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(11, 'deposit_rejected', 'Deposit rejected', 'Deposit rejected', 'demo@gmail.com', 'Deposit rejected', 'Deposit rejected', '{\"amount\":\"Amount\",\"charge\":\"Charge\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(12, 'pin_recharge', 'Pin recharge', 'Pin recharge', 'demo@gmail.com', 'Pin recharge', 'Pin recharge', '{\"currency\":\"Currency Symbol\",\"amount\":\"Amount\",\"pin_number\":\"Pin Number\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(13, 'referral_commission', 'Referral Commission', 'Referral Commission', 'demo@gmail.com', 'Referral Commission', 'Referral Commission', '{\"amount\":\"Amount\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(14, 'level_commission', 'Level Commission', 'Level Commission', 'demo@gmail.com', 'Level Commission', 'Level Commission', '{\"amount\":\"Amount\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(15, 'investment_scheme_purchase', 'Investment Scheme purchase', 'Invest Scheme', 'demo@gmail.com', 'invest', 'invest', '{\"amount\":\"Amount\",\"interest_rate\":\"Interest Rate\",\"plan_name\":\"Plan Name\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(16, 'investment_complete', 'Investment Complete', 'Invest Complete', 'demo@gmail.com', 'invest complete', 'invest complete', '{\"amount\":\"Amount\",\"interest_rate\":\"Interest Rate\",\"plan_name\":\"Plan Name\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(17, 're_invest', 'Re Investment', 'Re Investment', 'demo@gmail.com', 'Re Invest', 'Re Invest', '{\"amount\":\"Amount\",\"interest_rate\":\"Interest Rate\",\"plan_name\":\"Plan Name\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(18, 'investment_cancel', 'Investment Cancel', 'Investment Cancel', 'demo@gmail.com', 'Investment Cancel', 'Investment Cancel', '{\"amount\":\"Amount\",\"interest_rate\":\"Interest Rate\",\"plan_name\":\"Plan Name\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(19, 'matrix_enrolled', 'Matrix Enrolled', 'Matrix Enrolled', 'demo@gmail.com', 'Matrix Enrolled', 'Matrix Enrolled', '{\"amount\":\"Amount\",\"referral_commission\":\"Referral Commission\",\"plan_name\":\"Plan Name\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(20, 'balance_transfer_receive', 'Balance transfer receive', 'Balance transfer receive', 'demo@gmail.com', 'Balance transfer receive', 'Balance transfer receive', '{\"amount\":\"Amount\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(21, 'investment_plan_notify', 'Invest Plan create notify', 'Investment plan notify', 'demo@gmail.com', 'Investment plan notify', 'Investment plan notify', '{\"name\":\"Plan name\",\"amount\":\"Amount\",\"minimum\":\"Minimum Amount\",\"maximum\":\"Maximum Amount\",\"interest_rate\":\"Interest Rate\",\"currency\":\"Currency Symbol\",\"duration\":\"Duration\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(22, 'staking_investment_notify', 'Staking Investment Notify', 'Staking Invest', 'demo@gmail.com', 'invest', 'invest', '{\"amount\":\"Amount\",\"interest\":\"Interest\",\"expiration_date\":\"Expiration Date\",\"currency\":\"Currency\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint UNSIGNED NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `firewall_ips`
--
CREATE TABLE `firewall_ips` (
`id` int UNSIGNED NOT NULL,
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`log_id` int DEFAULT NULL,
`blocked` tinyint(1) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `firewall_logs`
--
CREATE TABLE `firewall_logs` (
`id` int UNSIGNED NOT NULL,
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
`middleware` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int DEFAULT NULL,
`url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`referrer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`request` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `frontends`
--
CREATE TABLE `frontends` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`meta` json 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 `frontends`
--
INSERT INTO `frontends` (`id`, `name`, `key`, `meta`, `created_at`, `updated_at`) VALUES
(1, 'About Section', 'about.fixed', '{\"heading\": \"Innovators in the Digital Finance Realm\", \"first_image\": \"about-1.jpg\", \"sub_heading\": \"Pioneering Your Crypto Journey with Expertise. Our team, a blend of tech wizards and financial aficionados, harnesses the power of Laravel to bring you a seamless, secure, and sophisticated trading platform. Here\'s what sets us apart:\", \"second_image\": \"about-vector.png\", \"vector_image\": \"about-2.jpg\", \"first_item_count\": \"16777\", \"first_item_title\": \"Trading Pair\", \"third_item_count\": \"1546\", \"third_item_title\": \"Investor\", \"second_item_count\": \"5999\", \"second_item_title\": \"Happy Client\"}', NULL, '2024-11-26 11:41:48'),
(2, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"Deep market analysis and insights, empowering informed trading decisions.\"}', NULL, NULL),
(3, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"Leveraging Laravel\'s advanced features for a robust, secure platform.\"}', NULL, NULL),
(4, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"Intuitive interfaces that cater to both novices and professional traders.\"}', NULL, NULL),
(5, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"Round-the-clock assistance and educational resources for continuous learning.\"}', NULL, NULL),
(6, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"Worldwide service with a keen understanding of local market nuances.\"}', NULL, NULL),
(7, 'About Section', 'about.enhancement', '{\"icon\": \"<i class=\'bi bi-check2-circle\'></i>\", \"title\": \"This platform emerges at the forefront of digital finance innovation, dedicated to revolutionizing your experience in the cryptocurrency domain.\"}', NULL, '2024-11-26 11:06:07'),
(8, 'Advertise Section', 'advertise.fixed', '{\"heading\": \"Elevate Your Trading Journey with FinFunder\", \"sub_heading\": \"Exceptional Trading Conditions Tailored for Your Success\"}', NULL, NULL),
(9, 'Advertise Section', 'advertise.enhancement', '{\"title\": \"Optimized Balance Base Draw down\", \"advertise_image\": \"FJSOnebfl5SbtbpM.jpg\"}', NULL, '2024-11-26 11:29:31'),
(10, 'Advertise Section', 'advertise.enhancement', '{\"title\": \"Strategic Balance Base Management\", \"advertise_image\": \"y4eVx2YStWcVfBYC.jpg\"}', NULL, '2024-11-26 11:29:41'),
(11, 'Advertise Section', 'advertise.enhancement', '{\"title\": \"20% Profit Share in Challenge Phase\", \"advertise_image\": \"089icmQRTVBM1dnK.jpg\"}', NULL, '2024-11-26 11:29:55'),
(12, 'Advertise Section', 'advertise.enhancement', '{\"title\": \"Unlimited Trading Opportunities\", \"advertise_image\": \"HA1ZALTm28i7VcXy.jpg\"}', NULL, '2024-11-26 11:30:20'),
(13, 'Advertise Section', 'advertise.enhancement', '{\"title\": \"Exclusive Limited-Time Offers\", \"advertise_image\": \"PQO2mgBVpt0TByLw.jpg\"}', NULL, '2024-11-26 11:30:33'),
(14, 'Banner Section', 'banner.fixed', '{\"btn_url\": \"/login\", \"heading\": \"Refine Invest and Trade Tactics with Matrix\", \"btn_name\": \"Get Started\", \"first_icon\": \"<i class=\\\"bi bi-bar-chart\\\"></i>\", \"first_text\": \"90.00M+\", \"main_image\": \"sBbnscTkSpFAgh94.png\", \"third_icon\": \"<i class=\\\"bi bi-arrow-repeat\\\"></i>\", \"video_link\": \"https://youtu.be/hT_nvWreIhg\", \"first_title\": \"Fast Trading\", \"second_icon\": \"<i class=\\\"bi bi-shield-check\\\"></i>\", \"second_text\": \"Users from the WorldWide\", \"sub_heading\": \"Begin your financial evolution with Depottop groundbreaking Matrix model, a gateway to enhanced earnings and expansive customer reach. Progress to intelligent investment opportunities, tailored for savvy growth.\", \"third_title\": \"Continuous Market Updates\", \"second_title\": \"Secure & Reliable\", \"background_image\": \"banner-bg.png\", \"first_provider_image\": \"banner-coin1.png\", \"third_provider_image\": \"banner-coin3.png\", \"fourth_provider_image\": \"banner-coin4.png\", \"second_provider_image\": \"banner-coin2.png\"}', NULL, '2024-11-26 11:11:56'),
(15, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-1.jpg\"}', NULL, NULL),
(16, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-2.jpg\"}', NULL, NULL),
(17, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-3.jpg\"}', NULL, NULL),
(18, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-4.jpg\"}', NULL, NULL),
(19, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-5.jpg\"}', NULL, NULL),
(20, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-6.jpg\"}', NULL, NULL),
(21, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-7.jpg\"}', NULL, NULL),
(22, 'Banner Section', 'banner.enhancement', '{\"provider_image\": \"provider-8.jpg\"}', NULL, NULL),
(23, 'Blog Section', 'blog.fixed', '{\"heading\": \"Explore Insights with Our Blog\", \"sub_heading\": \"Dive into the world of cryptocurrency and blockchain technology. Our blog brings you the latest trends, expert analyses, and insightful articles to enhance your understanding and trading skills. Stay informed, stay ahead.\"}', NULL, NULL),
(29, 'Choose Us', 'choose_us.fixed', '{\"heading\": \"Advanced Predictive Analytics\", \"sub_heading\": \"Utilize our sophisticated prediction methods to stay ahead in the market. Our technology analyzes trends to enhance your trading strategy and maximize returns.\", \"vector_image\": \"89lPotrNjUroDseD.png\"}', NULL, '2024-11-26 11:32:04'),
(30, 'Choose Us', 'choose_us.enhancement', '{\"icon\": \"<i class=\'bi bi-graph-up-arrow\'></i>\", \"title\": \"Elliott Wave Analysis\", \"details\": \"Leverage Elliott Wave Analysis for deeper market insights. This powerful tool helps in identifying market cycles and trends, offering you a strategic edge in trading.\"}', NULL, NULL),
(31, 'Choose Us', 'choose_us.enhancement', '{\"icon\": \"<i class=\'bi bi-app-indicator\'></i>\", \"title\": \"MACD and RSI Indicators\", \"details\": \"Make informed decisions using MACD and RSI indicators. These tools provide valuable insights into market momentum and trends, enhancing your analysis and decision-making.\"}', NULL, NULL),
(32, 'Choose Us', 'choose_us.enhancement', '{\"icon\": \"<i class=\'bi bi-fan\'></i>\", \"title\": \"Turbo Speed Execution\", \"details\": \"Experience unparalleled speed with our Turbo Speed feature. Swift execution of trades means you never miss an opportunity in the fast-paced crypto market.\"}', NULL, NULL),
(33, 'Choose Us', 'choose_us.enhancement', '{\"icon\": \"<i class=\'bi bi-graph-up\'></i>\", \"title\": \"High Low Option Trading\", \"details\": \"Explore High Low Option Trading for a straightforward approach to the market. This feature simplifies decision-making and is suitable for both beginners and seasoned traders.\"}', NULL, NULL),
(34, 'Crypto Pairs', 'crypto_pairs.fixed', '{\"heading\": \"Top Crypto Conversions at Your Fingertips\", \"sub_heading\": \"Explore the most popular cryptocurrency conversions on FinFunder. Our platform provides you with the latest, most sought-after exchange rates, ensuring you\'re always informed about high-performing currencies. Efficient, accurate, and designed for savvy traders like you.\", \"conversion_image\": \"usdt.png\"}', NULL, NULL),
(35, 'Currency Exchange', 'currency_exchange.fixed', '{\"heading\": \"Advanced Currency Exchange\", \"sub_heading\": \"Navigate the cryptocurrency market with precision. Our platform offers real-time pricing, comprehensive market analysis, and trend forecasts to inform and enhance your trading strategy. Stay ahead in the dynamic world of crypto with FinFunder\'s insightful exchange tools.\"}', NULL, NULL),
(36, 'FAQ Section', 'faq.fixed', '{\"btn_url\": \"https://app.xcapitalforge.com\", \"heading\": \"Frequently Asked Questions\", \"bg_image\": \"FPnsp7MSKRlriAoT.png\", \"btn_name\": \"More Questions ?\", \"sub_heading\": \"Your Queries Answered: Unveiling the Essentials of Crypto Trading and Investment with FinFunder\"}', NULL, '2024-11-26 11:23:50'),
(37, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"This is a cutting-edge crypto trading and investment platform, offering a range of services from real-time trading to strategic investment planning, all powered by Laravel technology.\", \"question\": \"What is Depottop?\"}', NULL, '2024-11-26 11:25:52'),
(38, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"Getting started is simple. Just create an account, complete the verification process, and you\'ll be ready to fund your account and begin trading.\", \"question\": \"How do I start trading on this platform?\"}', NULL, '2024-11-26 11:26:01'),
(39, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"Yes, we prioritize the security of our users\' investments. Our platform employs advanced security protocols and encryption to safeguard your assets and personal information.\", \"question\": \"Is my investment safe?\"}', NULL, '2024-11-26 11:24:22'),
(40, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"Absolutely! Our platform is designed for users of all skill levels. We offer educational resources and intuitive tools to help beginners navigate the crypto market confidently.\", \"question\": \"Can beginners use this platform effectively?\"}', NULL, '2024-11-26 11:24:43'),
(41, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"This stands out with its user-friendly interface, comprehensive market analytics, community-driven insights, and our commitment to using Laravel\'s robust framework for optimal performance and security.\", \"question\": \"What makes this platform different from other crypto platforms?\"}', NULL, '2024-11-26 11:25:07'),
(42, 'FAQ Section', 'faq.enhancement', '{\"answer\": \"The Matrix Plan is a unique community-focused program that connects you with other crypto enthusiasts for shared insights and strategies, enhancing your trading experience through collective wisdom.\", \"question\": \"What is the Matrix Plan, and how does it benefit me?\"}', NULL, NULL),
(43, 'Investment Plan', 'pricing_plan.fixed', '{\"heading\": \"Investment Strategies\", \"sub_heading\": \"Flexible Options for Every Trading Ambition. Plan aims to cater to different user needs, from those just starting in crypto trading to seasoned investors, providing clear options and benefits for each pricing tier.\"}', NULL, NULL),
(44, 'Investment Plan', 'matrix_plan.fixed', '{\"heading\": \"Unlock the Power of Community\", \"award_image\": \"award.png\", \"sub_heading\": \"Embrace the synergy of collective crypto wisdom with our Matrix Elite Plan. This plan connects you to a network of fellow enthusiasts and experts, enabling knowledge sharing, collaborative strategies, and exclusive community insights. \"}', NULL, NULL),
(45, 'Process Section', 'process.enhancement', '{\"icon\": \"<i class=\'bi bi-box-arrow-in-right\'></i>\", \"title\": \"Matrix\", \"details\": \"Harness the power of community-driven growth in the cryptocurrency space with Matrix. Expand your network, refer, and earn, all while contributing to a collective success story.\"}', NULL, NULL),
(46, 'Process Section', 'process.enhancement', '{\"icon\": \"<i class=\'bi bi-currency-dollar\'></i>\", \"title\": \"Invest\", \"details\": \"Experience secure, stress-free investing where risk is mitigated, and profit maximization is a reality. Our platform is designed for seamless, intelligent investment strategies in crypto\"}', NULL, NULL),
(47, 'Process Section', 'process.enhancement', '{\"icon\": \"<i class=\'bi bi-bar-chart\'></i>\", \"title\": \"Trade\", \"details\": \"Elevate your trading skills in cryptocurrency pairs with smart, intuitive tools. Our platform caters to experts seeking sophisticated, yet accessible, trading environments for enhanced profitability.\"}', NULL, NULL),
(48, 'Service Section', 'service.fixed', '{\"heading\": \"Expertise in Crypto Excellence\", \"sub_heading\": \"Harness the full potential of cryptocurrency with our comprehensive suite of trading and investment services, tailored to meet the needs of both novice and seasoned investors.\"}', NULL, NULL),
(49, 'Service Section', 'service.enhancement', '{\"url\": \"#\", \"title\": \"01. Best Payout\", \"service_image\": \"fs2xQEBkcyAa4ASc.jpg\"}', NULL, '2024-11-26 11:18:18'),
(50, 'Service Section', 'service.enhancement', '{\"url\": \"#\", \"title\": \"02. Fund Access\", \"service_image\": \"4jY7NFn4Uuv1hDu0.jpg\"}', NULL, '2024-11-26 11:18:54'),
(51, 'Service Section', 'service.enhancement', '{\"url\": \"#\", \"title\": \"03. Amazing Support\", \"service_image\": \"cgcTrMDN14i7uFZ1.jpg\"}', NULL, '2024-11-26 11:19:07'),
(52, 'Service Section', 'service.enhancement', '{\"url\": \"#\", \"title\": \"04. Cashback Option\", \"service_image\": \"pU8idI88JYtFyJmh.jpg\"}', NULL, '2024-11-26 11:19:24'),
(53, 'Testimonial Section', 'testimonial.fixed', '{\"title\": \"Amazing !\", \"heading\": \"Success Stories from Our Clients\", \"avg_rating\": \"4.5\", \"sub_heading\": \"Discover how we has empowered individuals and businesses in their crypto trading and investment journey.\", \"total_reviews\": \"885 Reviews\"}', NULL, '2024-11-26 11:34:27'),
(54, 'Testimonial Section', 'testimonial.enhancement', '{\"name\": \"Alex Johnson\", \"designation\": \"Financial Analyst\", \"testimonial\": \"As a professional in finance, I\'m impressed by this platform precise market analytics and user-friendly interface. It\'s revolutionized the way I approach crypto investment. Highly recommended for those who value data-driven decisions.\"}', NULL, '2024-11-26 11:34:41'),
(55, 'Testimonial Section', 'testimonial.enhancement', '{\"name\": \"Emily Torres\", \"designation\": \"Tech Entrepreneur\", \"testimonial\": \"This platform commitment to security and innovative technology stands out in the crypto world. It\'s the only platform I trust for managing my diverse crypto portfolio. The interface is incredibly intuitive, even for beginners.\"}', NULL, '2024-11-26 11:34:55'),
(56, 'Testimonial Section', 'testimonial.enhancement', '{\"name\": \"David Kim\", \"designation\": \"Crypto Enthusiast\", \"testimonial\": \"What I love about this platform is the community aspect. It\'s not just a trading platform; it\'s a hub of knowledge and insights. The support team is fantastic, always ready to help with any queries.\"}', NULL, '2024-11-26 11:35:25'),
(57, 'Testimonial Section', 'testimonial.enhancement', '{\"name\": \"Sarah Bennett\", \"designation\": \"Investor\", \"testimonial\": \"I\'ve used several trading platforms, but this platform stands out for its ease of use and comprehensive features. It\'s my go-to for all my crypto investments. The real-time data has been crucial for my investment strategies.\"}', NULL, '2024-11-26 11:35:07'),
(58, 'Testimonial Section', 'testimonial.enhancement', '{\"name\": \"Michael Smith\", \"designation\": \"Blockchain Developer\", \"testimonial\": \"From a developer\'s perspective, I appreciate this platform robust security measures and cutting-edge tech. It\'s great to see a platform that not only prioritizes user experience but also the safety and integrity of digital assets.\"}', NULL, '2024-11-26 11:35:42'),
(59, 'Footer Section', 'footer.fixed', '{\"details\": \"This platform is your trusted partner in navigating the crypto world. We\'re here to assist you 24/7 with any queries and provide support for your trading and investment needs. Discover more about us, access our help center, and follow our social channels for the latest updates and insights.\", \"heading\": \"Stay Connected with us\", \"payment\": \"4HYszDAQKyn8PmV0.png\", \"news_letter\": \"Join our Newsletter\", \"footer_vector\": \"footer-vector.png\", \"copy_right_text\": \"© 2024 by Depottop. All Rights Reserved.\", \"news_letter_title\": \"Subscribe to our newsletter for the latest crypto trends, FinFunder updates, and exclusive insights.\"}', NULL, '2024-11-26 11:38:35'),
(60, 'Sign In', 'sign_in.fixed', '{\"title\": \"Step Into the World of Smart Trading\", \"details\": \"with depottop\", \"heading\": \"Access Your Depottop Account\", \"background_image\": \"form-bg3.jpg\"}', NULL, '2024-11-26 11:20:58'),
(61, 'Sign Up', 'sign_up.fixed', '{\"title\": \"Join Today & Earn More Bonus\", \"details\": \"with depottop\", \"heading\": \"Create Your Depottop Account\", \"background_image\": \"form-bg3.jpg\"}', NULL, '2024-11-26 11:21:54'),
(62, 'Crypto Coin', 'crypto_coin.fixed', '{\"first_crypto_coin\": \"eth.png\", \"third_crypto_coin\": \"ada.png\", \"fourth_crypto_coin\": \"sol.png\", \"second_crypto_coin\": \"bnb.png\"}', NULL, NULL),
(63, 'Social Section', 'social.fixed', '{\"tiktok_url\": \"https://www.tiktok.com/\", \"tiktok_icon\": \"<i class=\'bi bi-tiktok\'></i>\", \"twitter_url\": \"https://www.twitter.com/\", \"facebook_url\": \"https://www.facebook.com/\", \"telegram_url\": \"https://www.telegram.com/\", \"twitter_icon\": \"<i class=\'bi bi-twitter\'></i>\", \"facebook_icon\": \"<i class=\'bi bi-facebook\'></i>\", \"instagram_url\": \"https://www.instagram.com/\", \"telegram_icon\": \"<i class=\'bi bi-telegram\'></i>\", \"instagram_icon\": \"<i class=\'bi bi-instagram\'></i>\"}', NULL, NULL),
(64, 'Contact', 'contact.fixed', '{\"email\": \"info@depottop.com\", \"phone\": \"+9943453453\", \"title\": \"Connect With Us\", \"address\": \"123 Main Street, Suite 456 Cityville, State 78901\", \"heading\": \"Prompt Support, Just an Hour Away\", \"sub_heading\": \"Need assistance or have a query? Reach out to us! We\'re committed to providing you with timely and helpful responses. For immediate assistance, our customer service team is readily available via phone or email. We value your time and strive to address your needs swiftly and efficiently.\", \"background_image\": \"9pg8aPJJ3t9F42On.png\"}', NULL, '2024-11-26 11:32:50'),
(65, 'Page', 'page.enhancement', '{\"name\": \"Privacy Policy\", \"descriptions\": \"The original and most valuable cryptocurrency, Bitcoin is often seen as a digital.\"}', NULL, NULL),
(66, 'Page', 'page.enhancement', '{\"name\": \"Terms & Conditions\", \"descriptions\": \"The original and most valuable cryptocurrency, Bitcoin is often seen as a digital.\"}', NULL, NULL),
(67, 'Feature', 'feature.fixed', '{\"btn_url\": \"#\", \"heading\": \"Real-Time Market Analytics\", \"btn_name\": \"Learn More\", \"sub_heading\": \"Stay ahead of market trends with FinFunder\'s real-time analytics. Gain insights into market movements, track asset performance, and make informed decisions with up-to-the-minute data.\"}', NULL, NULL),
(68, 'Feature', 'feature.enhancement', '{\"icon\": \"<i class=\\\"bi bi-alarm\\\"></i>\", \"title\": \"Secure Investment Environment\", \"details\": \"Security at its finest. Our platform employs advanced encryption and security protocols to ensure your investments are protected at all times. Trade and invest with peace of mind, knowing your assets are in safe hands.\"}', NULL, NULL),
(69, 'Feature', 'feature.enhancement', '{\"icon\": \"<i class=\\\"bi bi-alarm\\\"></i>\", \"title\": \"User-Friendly Interface\", \"details\": \"Navigate the complex world of crypto with ease. FinFunder’s intuitive interface simplifies trading and investing, making it accessible for both beginners and experienced traders.\"}', NULL, NULL),
(70, 'Feature', 'feature.enhancement', '{\"icon\": \"<i class=\\\"bi bi-alarm\\\"></i>\", \"title\": \"Diverse Portfolio Management\", \"details\": \"Expand your investment horizons with our diverse portfolio options. From mainstream cryptocurrencies to emerging tokens, tailor your investment strategy to suit your financial goals.\"}', NULL, NULL),
(71, 'Feature', 'feature.enhancement', '{\"icon\": \"<i class=\\\"bi bi-alarm\\\"></i>\", \"title\": \"Community and Support\", \"details\": \"Join our vibrant community of crypto enthusiasts. Access a wealth of shared knowledge, participate in discussions, and receive dedicated support from our expert team.\"}', NULL, NULL),
(72, 'Cookie', 'cookie.fixed', '{\"title\": \"We use cookies to enhance your browsing experience. By clicking \'Accept all, you agree to the use of cookies.\"}', NULL, NULL),
(73, 'investment Profit', 'investment-profit-calculation.fixed', '{\"heading\": \"Investment Returns Calculator\", \"sub_heading\": \"You should understand the calculations before investing in any plan to avoid mistakes. Verify the figures, and you\'ll find they align with what our calculator indicates.\"}', NULL, NULL),
(74, 'Staking Investment', 'staking-investment.fixed', '{\"heading\": \"Maximizing Profits with Staking Investments\", \"sub_heading\": \"Unleashing Passive Income Potential: Harnessing the Power of Staking Investments\"}', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `holidays`
--
CREATE TABLE `holidays` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date` date 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 `investment_logs`
--
CREATE TABLE `investment_logs` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`investment_plan_id` bigint UNSIGNED DEFAULT NULL,
`plan_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`interest_rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`profit` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_reinvest` tinyint(1) NOT NULL DEFAULT '0',
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`period` int DEFAULT NULL,
`time_table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`hours` int DEFAULT NULL,
`profit_time` timestamp NULL DEFAULT NULL,
`last_time` timestamp NULL DEFAULT NULL,
`should_pay` decimal(28,8) DEFAULT NULL,
`recapture_type` tinyint DEFAULT NULL,
`return_duration_count` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `investment_plans`
--
CREATE TABLE `investment_plans` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`minimum` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`maximum` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`interest_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
`duration` int DEFAULT NULL,
`meta` json DEFAULT NULL,
`terms_policy` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`is_recommend` tinyint(1) NOT NULL DEFAULT '0',
`type` tinyint NOT NULL DEFAULT '1',
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`interest_type` tinyint NOT NULL DEFAULT '1',
`time_id` bigint UNSIGNED DEFAULT NULL,
`interest_return_type` tinyint NOT NULL DEFAULT '1',
`recapture_type` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `investment_plans`
--
INSERT INTO `investment_plans` (`id`, `uid`, `name`, `minimum`, `maximum`, `amount`, `interest_rate`, `duration`, `meta`, `terms_policy`, `is_recommend`, `type`, `status`, `created_at`, `updated_at`, `interest_type`, `time_id`, `interest_return_type`, `recapture_type`) VALUES
(1, 'VEpoyCVHOwfiPM81', 'Basic plan', 300.00000000, 5999.00000000, 0.00000000, 3.00, 5, '[\"Ideal for Beginners\", \"Low-Risk Introduction\", \"Quick Return Period\"]', 'Terms and policies for the basic plan.', 1, 1, 1, '2024-11-22 14:46:09', '2024-11-26 11:01:36', 1, 2, 2, 3),
(2, 'ch350yLAT6lfRUdh', 'Standard Plan', 6000.00000000, 11999.00000000, 0.00000000, 3.50, 5, '[\"Accelerated Earnings\", \"Medium-Term Growth\", \"For Experienced Investors\"]', 'Terms and policies for the Growth plan.', 1, 1, 1, '2024-11-22 14:46:09', '2024-11-26 11:01:51', 1, 2, 2, 3),
(3, 'bKxbFmic4Ehl8HjX', 'Precious Gold Plan', 12000.00000000, 23999.00000000, 0.00000000, 4.50, 5, '[\"High Returns for Experts\", \"Long-Term Investment\", \"Substantial Capital Growth\"]', 'Terms and policies for the Advanced plan.', 1, 1, 1, '2024-11-22 14:46:09', '2024-11-26 11:02:03', 1, 2, 2, 3),
(4, 'xrw5uOsQaBJ1MZTp', 'Professional Plan', 24000.00000000, 10000000.00000000, 0.00000000, 6.00, 5, '[\"Stable Growth\", \"Moderate Risk and Return\", \"Ideal for Conservative Investors\"]', 'Terms and policies for the Balanced plan.', 1, 1, 1, '2024-11-22 14:46:09', '2024-11-26 11:03:08', 1, 2, 2, 3),
(5, '3ZvWCOT9J28qWGiN', 'Flexi', 500.00000000, 2500.00000000, 0.00000000, 2.50, 20, '[\"Flexible Terms\", \"Quick Access to Funds\", \"Lower Risk Profile\"]', 'Terms and policies for the Flexi plan.', 1, 1, 2, '2024-11-22 14:46:09', '2024-11-26 10:55:38', 1, 3, 2, 1),
(6, 'Z95AbtkazVcScCac', 'Premium', 10000.00000000, 50000.00000000, 0.00000000, 5.00, 0, '[\"Highest Return Rates\", \"Longest Investment Period\", \"Exclusive for High Stake Investors\"]', 'Terms and policies for the Premium plan.', 0, 1, 2, '2024-11-22 14:46:09', '2024-11-26 10:55:28', 2, 1, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `investment_user_rewards`
--
CREATE TABLE `investment_user_rewards` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`level` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`invest` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`team_invest` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`deposit` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`referral_count` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`reward` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`status` tinyint 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;
--
-- Dumping data for table `investment_user_rewards`
--
INSERT INTO `investment_user_rewards` (`id`, `name`, `level`, `invest`, `team_invest`, `deposit`, `referral_count`, `reward`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bronze Starter', 'Level-1', 1000.00000000, 5000.00000000, 200.00000000, 10.00000000, 100.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(2, 'Silver Investor', 'Level-2', 2000.00000000, 10000.00000000, 400.00000000, 20.00000000, 200.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(3, 'Gold Partner', 'Level-3', 3000.00000000, 15000.00000000, 600.00000000, 30.00000000, 300.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(4, 'Platinum Sponsor', 'Level-4', 4000.00000000, 20000.00000000, 800.00000000, 40.00000000, 400.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(5, 'Diamond Elite', 'Level-5', 5000.00000000, 25000.00000000, 1000.00000000, 50.00000000, 500.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(6, 'Ruby Champion', 'Level-6', 6000.00000000, 30000.00000000, 1200.00000000, 60.00000000, 600.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(7, 'Sapphire Master', 'Level-7', 7000.00000000, 35000.00000000, 1400.00000000, 70.00000000, 700.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` bigint UNSIGNED NOT NULL,
`queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint UNSIGNED NOT NULL,
`reserved_at` int UNSIGNED DEFAULT NULL,
`available_at` int UNSIGNED NOT NULL,
`created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `jobs`
--
INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"0e333a23-2d06-44e9-901a-87154484b7fd\",\"displayName\":\"App\\\\Jobs\\\\SendEmailVerificationJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendEmailVerificationJob\",\"command\":\"O:33:\\\"App\\\\Jobs\\\\SendEmailVerificationJob\\\":1:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:1;s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}', 0, NULL, 1732269236, 1732269236),
(2, 'default', '{\"uuid\":\"50c34ea5-6f3e-4f15-9af7-927ce74fef43\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"bf53adc6-ba9a-433c-baa1-83bcae505402\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732289465, 1732289465),
(3, 'default', '{\"uuid\":\"0803d127-e403-4225-ac8b-1f54ecc040e0\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:3:\\\"100\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:3:\\\"100\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:11:\\\"balance_add\\\";}\"}}', 0, NULL, 1732289465, 1732289465),
(4, 'default', '{\"uuid\":\"a099eb10-6189-4460-911f-332e65b5d536\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"1fcc898f-ad26-42ed-980d-a7089c7bde53\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732360038, 1732360038),
(5, 'default', '{\"uuid\":\"53ff55dc-514a-4af2-96c6-dc8ebd83380f\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:4:\\\"2000\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:4:\\\"2100\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:11:\\\"balance_add\\\";}\"}}', 0, NULL, 1732360038, 1732360038),
(6, 'default', '{\"uuid\":\"e70a24ab-8210-4937-b1d7-719a5f071e73\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:3;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"548ec09d-b25c-49eb-8b3a-0d4c8fb55e48\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732361405, 1732361405),
(7, 'default', '{\"uuid\":\"16672188-1e8d-4418-b36a-d0062b3bf408\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:4:\\\"5000\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:4:\\\"6100\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:11:\\\"balance_add\\\";}\"}}', 0, NULL, 1732361405, 1732361405),
(8, 'default', '{\"uuid\":\"e34404cd-8867-4219-a0ee-e68e2bfc14e4\",\"displayName\":\"App\\\\Notifications\\\\WithdrawNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\WithdrawLog\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:38:\\\"App\\\\Notifications\\\\WithdrawNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"c275250a-70f6-444f-8e83-b2ad242f9318\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732372028, 1732372028),
(9, 'default', '{\"uuid\":\"27a97dcc-a200-4f91-b64d-8d1b579f8631\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:4:\\\"2000\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:3:\\\"100\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:16:\\\"balance_subtract\\\";}\"}}', 0, NULL, 1732372028, 1732372028),
(10, 'default', '{\"uuid\":\"988b8680-dfda-4f4a-b76a-25ef43ff27e0\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:4;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"131f0380-8d76-4551-9e2f-df4defd986c5\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732372698, 1732372698),
(11, 'default', '{\"uuid\":\"3de69a11-9a23-42ed-902a-a278b75d3874\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:4:\\\"5000\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:4:\\\"5100\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:11:\\\"balance_add\\\";}\"}}', 0, NULL, 1732372698, 1732372698),
(12, 'default', '{\"uuid\":\"b67e7cd9-4ee6-4ac7-9046-45e5d6587963\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:2;s:9:\\\"relations\\\";a:1:{i:0;s:5:\\\"agent\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:6:\\\"amount\\\";s:4:\\\"1000\\\";s:13:\\\"interest_rate\\\";d:20;s:9:\\\"plan_name\\\";s:7:\\\"Starter\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:26:\\\"investment_scheme_purchase\\\";}\"}}', 0, NULL, 1732373025, 1732373025),
(13, 'default', '{\"uuid\":\"cbc87f7e-2593-4045-9a6f-d37ef7b3ed02\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:5;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:44:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:REQUESTED\\\";s:2:\\\"id\\\";s:36:\\\"35fc19c4-c4b5-4b3d-8a38-ec93f02fcd86\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732373292, 1732373292),
(14, 'default', '{\"uuid\":\"b24fb7a9-26eb-4038-8562-c22bf2456eb6\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:5;}s:9:\\\"relations\\\";a:2:{i:0;s:7:\\\"gateway\\\";i:1;s:4:\\\"user\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"dfd58117-8a04-4ddc-97e0-8a0eae25d4ef\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732373324, 1732373324),
(15, 'default', '{\"uuid\":\"b339d9c4-d68e-405b-9b0b-64b18550d59e\",\"displayName\":\"App\\\\Notifications\\\\DepositNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:18:\\\"App\\\\Models\\\\Deposit\\\";s:2:\\\"id\\\";a:1:{i:0;i:24;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:37:\\\"App\\\\Notifications\\\\DepositNotification\\\":2:{s:19:\\\"\\u0000*\\u0000notificationType\\\";E:43:\\\"App\\\\Enums\\\\Payment\\\\NotificationType:APPROVED\\\";s:2:\\\"id\\\";s:36:\\\"4c77b114-f040-4ea8-a58f-cc0ce4053ad6\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1732462520, 1732462520),
(16, 'default', '{\"uuid\":\"40913980-ac08-494d-b2ec-af850e4f6f7f\",\"displayName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\EmailSmsProcessJob\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\EmailSmsProcessJob\\\":3:{s:7:\\\"\\u0000*\\u0000user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";i:7;s:9:\\\"relations\\\";a:1:{i:0;s:6:\\\"wallet\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:11:\\\"\\u0000*\\u0000replacer\\\";a:4:{s:11:\\\"wallet_name\\\";s:14:\\\"Primary Wallet\\\";s:6:\\\"amount\\\";s:4:\\\"5000\\\";s:8:\\\"currency\\\";s:1:\\\"$\\\";s:12:\\\"post_balance\\\";s:4:\\\"5000\\\";}s:7:\\\"\\u0000*\\u0000code\\\";s:11:\\\"balance_add\\\";}\"}}', 0, NULL, 1732462520, 1732462520);
-- --------------------------------------------------------
--
-- Table structure for table `ltu_languages`
--
CREATE TABLE `ltu_languages` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`is_default` tinyint NOT NULL DEFAULT '1',
`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 `ltu_languages`
--
INSERT INTO `ltu_languages` (`id`, `name`, `code`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `matrix`
--
CREATE TABLE `matrix` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`referral_reward` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`is_recommend` tinyint(1) NOT NULL DEFAULT '0',
`status` tinyint NOT NULL DEFAULT '2',
`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 `matrix`
--
INSERT INTO `matrix` (`id`, `uid`, `name`, `amount`, `referral_reward`, `is_recommend`, `status`, `created_at`, `updated_at`) VALUES
(1, 'e3L5LG3JoMS6CtiC', 'Intermediate', 100.00000000, 2.00000000, 0, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(2, '8MRW3tFnwyihZ7Ru', 'Advanced', 200.00000000, 5.00000000, 1, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(3, 'b62KYFGgSDHmdsbK', 'Pro', 300.00000000, 8.00000000, 0, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `matrix_investments`
--
CREATE TABLE `matrix_investments` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_id` bigint UNSIGNED DEFAULT NULL,
`plan_id` bigint UNSIGNED DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`trx` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`price` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`referral_reward` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`referral_commissions` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`level_commissions` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`meta` json DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `matrix_levels`
--
CREATE TABLE `matrix_levels` (
`id` bigint UNSIGNED NOT NULL,
`plan_id` bigint UNSIGNED NOT NULL,
`level` int DEFAULT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`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 `matrix_levels`
--
INSERT INTO `matrix_levels` (`id`, `plan_id`, `level`, `amount`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 13.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(2, 1, 2, 3.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(3, 1, 3, 3.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(4, 1, 4, 3.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(5, 1, 5, 3.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(6, 2, 1, 15.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(7, 2, 2, 5.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(8, 2, 3, 5.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(9, 2, 4, 5.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(10, 2, 5, 5.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(11, 3, 1, 20.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(12, 3, 2, 7.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(13, 3, 3, 7.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(14, 3, 4, 7.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(15, 3, 5, 7.00000000, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `menus`
--
CREATE TABLE `menus` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parent_id` bigint UNSIGNED DEFAULT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`section_key` json DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `menus`
--
INSERT INTO `menus` (`id`, `name`, `url`, `parent_id`, `is_default`, `section_key`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Home', 'https://app.xcapitalforge.com', NULL, 1, NULL, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(2, 'Trade', 'https://app.xcapitalforge.com/trades', NULL, 1, NULL, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(3, 'Pricing', 'plans', NULL, 0, '[\"pricing_plan\", \"matrix_plan\", \"service\", \"feature\", \"faq\"]', 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(4, 'Features', 'features', NULL, 0, '[\"about\", \"process\", \"service\", \"choose_us\", \"testimonial\"]', 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09');
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int UNSIGNED NOT NULL,
`migration` varchar(255) CHARACTER SET utf8mb4 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_07_15_000000_create_firewall_ips_table', 1),
(5, '2019_07_15_000000_create_firewall_logs_table', 1),
(6, '2019_08_19_000000_create_failed_jobs_table', 1),
(7, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(8, '2022_07_22_181617_create_admins_table', 1),
(9, '2022_08_15_073439_create_settings_table', 1),
(10, '2022_08_15_130411_create_email_sms_templates_table', 1),
(11, '2022_08_18_090649_create_sms_gateways_table', 1),
(12, '2022_10_23_180535_create_admin_password_resets_table', 1),
(13, '2022_11_05_163156_create_transactions_table', 1),
(14, '2022_11_11_170906_create_plugin_configurations_table', 1),
(15, '2023_03_09_173433_create_jobs_table', 1),
(16, '2023_04_07_033225_create_matrix_table', 1),
(17, '2023_04_07_033953_create_matrix_levels_table', 1),
(18, '2023_04_07_100450_create_pin_generates_table', 1),
(19, '2023_05_01_011415_create_withdraw_methods_table', 1),
(20, '2023_05_04_003818_create_investment_plans_table', 1),
(21, '2023_10_09_052732_create_crypto_currencies_table', 1),
(22, '2023_10_09_052842_create_trade_parameters_table', 1),
(23, '2023_10_09_052913_create_trade_logs_table', 1),
(24, '2023_11_09_165436_create_menus_table', 1),
(25, '2023_12_07_015820_create_frontends_table', 1),
(26, '2023_12_29_033331_create_deposits_table', 1),
(27, '2023_12_29_044224_create_payment_method_table', 1),
(28, '2023_12_29_132520_create_wallets_table', 1),
(29, '2023_12_30_120958_create_commissions_table', 1),
(30, '2023_12_31_055200_create_withdraw_logs_table', 1),
(31, '2024_01_06_075523_create_investment_logs_table', 1),
(32, '2024_01_07_150350_create_matrix_investments_table', 1),
(33, '2024_02_11_113450_create_languages_table', 1),
(34, '2024_02_26_113307_create_notifications_table', 1),
(35, '2024_03_14_224525_create_subscribers_table', 1),
(36, '2024_03_22_191502_create_contacts_table', 1),
(37, '2024_03_30_215030_create_crons_table', 1),
(38, '2024_04_20_071436_create_notification_id_table', 1),
(39, '2024_04_28_113202_create_payment_details_table', 1),
(40, '2024_04_28_170353_create_referrals_table', 1),
(41, '2024_05_05_113825_create_time_tables_table', 1),
(42, '2024_05_05_142818_create_investment_plan_times_table', 1),
(43, '2024_05_12_104928_create_holidays_table', 1),
(44, '2024_05_15_021055_create_staking_plans_table', 1),
(45, '2024_05_15_021110_create_staking_investments_table', 1),
(46, '2024_06_06_085329_add_expires_at_to_personal_access_tokens_table', 1),
(47, '2024_07_13_140643_deposit_btc_tokens_table', 1),
(48, '2024_07_27_120544_create_investment_user_rewards_table', 1),
(49, '2024_08_03_121456_create_agents_table', 1),
(50, '2024_08_03_121502_create_agent_password_resets_table', 1),
(51, '2024_08_10_120036_create_agent_transactions_table', 1),
(52, '2024_08_11_105426_create_agent_withdraw_logs_table', 1),
(53, '2024_08_25_223627_create_trade_win_balance_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`notifiable_id` bigint UNSIGNED NOT NULL,
`data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`read_at` timestamp NULL 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 `password_resets`
--
CREATE TABLE `password_resets` (
`id` bigint UNSIGNED NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) CHARACTER SET utf8mb4 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 `payment_methods`
--
CREATE TABLE `payment_methods` (
`id` bigint UNSIGNED NOT NULL,
`currency` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`wallet` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`percent_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`file` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parameter` json DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT '1',
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`minimum` decimal(28,8) DEFAULT NULL,
`maximum` decimal(28,8) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `payment_methods`
--
INSERT INTO `payment_methods` (`id`, `currency`, `wallet`, `percent_charge`, `rate`, `name`, `code`, `file`, `parameter`, `type`, `status`, `created_at`, `updated_at`, `details`, `minimum`, `maximum`) VALUES
(1, 'BTC', 'bc1qxxg88tz4nfrlvhw6hu70vtdzurqyc42j6l0kum', 0.00000000, 1.00000000, 'Bitcoin', 'KeJOC', 'oreUW8zGZ7CHByVI.png', '{\"upload_proof_of_payment\": {\"field_name\": \"upload_proof_of_payment\", \"field_type\": \"file\", \"field_label\": \"Upload Proof of Payment\"}}', 2, 1, '2024-11-23 19:47:25', '2024-11-26 11:04:37', '<p>Make Payment to this Bitcoin Wallet Address and upload proof below</p>', 10.00000000, 100000000.00000000),
(2, 'USDT ERC20', '0x732db09b3beCb698203e852bE2d6e6f9cAb10Ba2', 0.00000000, 1.00000000, 'USDT', 'itkiY', 'HcmqfYgNdDRZMKLm.png', '{\"upload_proof_of_payment\": {\"field_name\": \"upload_proof_of_payment\", \"field_type\": \"file\", \"field_label\": \"Upload Proof of Payment\"}}', 2, 1, '2024-11-24 16:17:18', '2024-11-26 11:04:01', '<p>Make payment to this USDT ERC20 wallet address</p>', 10.00000000, 100000000.00000000),
(3, 'ETH', '0x732db09b3beCb698203e852bE2d6e6f9cAb10Ba2', 0.00000000, 1.00000000, 'Ethereum', 'PSzAj', 'WLYP0TcsczNHQ1nD.png', '{\"upload_proof_of_payment\": {\"field_name\": \"upload_proof_of_payment\", \"field_type\": \"file\", \"field_label\": \"Upload Proof of Payment\"}}', 2, 1, '2024-11-26 10:53:35', '2024-11-26 10:53:35', '<p>Make payment to the Ethereum wallet address below</p>', 10.00000000, 100000000.00000000);
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint UNSIGNED NOT NULL,
`tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`last_used_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`expires_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `pin_generates`
--
CREATE TABLE `pin_generates` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint UNSIGNED DEFAULT NULL,
`set_user_id` bigint UNSIGNED DEFAULT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`pin_number` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '0' COMMENT 'Unused : 1, Used : 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 `plugin_configurations`
--
CREATE TABLE `plugin_configurations` (
`id` bigint UNSIGNED NOT NULL,
`code` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`short_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '1',
`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 `plugin_configurations`
--
INSERT INTO `plugin_configurations` (`id`, `code`, `name`, `short_key`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TAWK-111', 'Tawk.to Configuration', '{\"api_key\":\"demo\"}', 2, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(2, 'GOOGLE-ANALYTICS', 'Google Analytics', '{\"api_key\":\"demo\"}', 2, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(3, 'hoory-113', 'Hoory Configuration', '{\"api_key\":\"demo\"}', 2, '2024-11-22 14:46:09', '2024-11-22 14:46:09');
-- --------------------------------------------------------
--
-- Table structure for table `referrals`
--
CREATE TABLE `referrals` (
`id` bigint UNSIGNED NOT NULL,
`level` int NOT NULL,
`percent` decimal(8,2) NOT NULL,
`commission_type` tinyint NOT NULL DEFAULT '1',
`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 `settings`
--
CREATE TABLE `settings` (
`id` bigint UNSIGNED NOT NULL,
`sms_gateway_id` int DEFAULT NULL,
`logo` json DEFAULT NULL,
`appearance` json DEFAULT NULL,
`matrix_parameters` json DEFAULT NULL,
`system_configuration` json DEFAULT NULL,
`theme_setting` json DEFAULT NULL,
`recaptcha_setting` json DEFAULT NULL,
`seo_setting` json DEFAULT NULL,
`mail_configuration` json DEFAULT NULL,
`social_login` json DEFAULT NULL,
`commissions_charge` json DEFAULT NULL,
`crypto_api` json DEFAULT NULL,
`kyc_configuration` json DEFAULT NULL,
`security` json DEFAULT NULL,
`sms_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`mail_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`referral_setting` json DEFAULT NULL,
`holiday_setting` json DEFAULT NULL,
`investment_setting` json DEFAULT NULL,
`agent_investment_commission` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `sms_gateway_id`, `logo`, `appearance`, `matrix_parameters`, `system_configuration`, `theme_setting`, `recaptcha_setting`, `seo_setting`, `mail_configuration`, `social_login`, `commissions_charge`, `crypto_api`, `kyc_configuration`, `security`, `sms_template`, `mail_template`, `version`, `created_at`, `updated_at`, `referral_setting`, `holiday_setting`, `investment_setting`, `agent_investment_commission`) VALUES
(1, 1, '{\"dark\": \"CsMH79CagUxAc6Bf.png\", \"white\": \"vMjHlOwcW223JE0P.png\", \"favicon\": \"favicon.png\"}', '{\"email\": \"info@depottop.com\", \"phone\": \"1234567890\", \"address\": \"3971 Roden Dr NE\", \"paginate\": \"20\", \"timezone\": \"UTC\", \"site_title\": \"Depottop\", \"currency_code\": \"USD\", \"copy_right_text\": \"© 2014 by Depottop. All rights reserved.\", \"currency_symbol\": \"$\"}', '{\"width\": 10, \"height\": 6}', '{\"e_pin\": {\"title\": \"If you disable this module, users won\'t be able to recharge E-pins on this system.\", \"value\": 1}, \"language\": {\"title\": \"If you disable this module, users won\'t be able to change the system language.\", \"value\": 1}, \"binary_trade\": {\"title\": \"If you deactivate the binary trade option, the binary trading feature will be turned off.\", \"value\": 2}, \"practice_trade\": {\"title\": \"If you deactivate the practice trade option, the practice trading feature will be turned off.\", \"value\": 2}, \"balance_transfer\": {\"title\": \"Enabling this module allows users to initiate balance transfers within the system.\", \"value\": 1}, \"kyc_verification\": {\"title\": \"If you disable this module, users won\'t undergo KYC verification in this system.\", \"value\": 1}, \"sms_notification\": {\"title\": \"If you disable this module, users won\'t receive SMS notifications in this system.\", \"value\": 2}, \"withdraw_request\": {\"title\": \"If you disable this module, users won\'t be able to submit withdrawal requests in this system.\", \"value\": 1}, \"cookie_activation\": {\"title\": \"If you disable this module, users won\'t be able to activate cookies in this system.\", \"value\": 1}, \"investment_reward\": {\"title\": \"Enabling this module allows users to receive rewards for their investments within the system.\", \"value\": 1}, \"email_notification\": {\"title\": \"If you disable this module, users won\'t receive email notifications in this system.\", \"value\": 1}, \"email_verification\": {\"title\": \"If you deactivate the email verification module, users won\'t be able to verify their email addresses in this system.\", \"value\": 2}, \"registration_status\": {\"title\": \"If you disable this module, new users won\'t be able to register on this system.\", \"value\": 1}}', '{\"primary_color\": \"#0d7bfe\", \"secondary_color\": \"#0d7bfe\", \"primary_text_color\": \"#150801\", \"secondary_text_color\": \"#6a6a6a\"}', '{\"key\": \"#fe710d\", \"login\": 2, \"secret\": \"#fe710d\", \"registration\": 2}', '{\"image\": null, \"title\": \"Depottop\", \"keywords\": [\"crypto\", \"trade\"], \"description\": \"Depottop\"}', '{\"host\": \"mail.smtp2go.com\", \"port\": \"465\", \"password\": \"demo\", \"username\": \"demo\", \"from_name\": \"FinFunder\", \"encryption\": \"tls\", \"from_email\": \"noreply@kloudinnovation.com\"}', '{\"google\": {\"status\": 2, \"redirect\": \"https://app.xcapitalforge.com/google/callback\", \"client_id\": \"demo\", \"client_secret\": \"demo\"}, \"facebook\": {\"status\": 2, \"redirect\": \"https://app.xcapitalforge.com/facebook/callback\", \"client_id\": \"demo\", \"client_secret\": \"demo\"}}', '{\"e_pin_charge\": 2, \"trade_practice_balance\": 1000, \"balance_transfer_charge\": 1, \"binary_trade_commissions\": 1, \"investment_cancel_charge\": 1, \"investment_transfer_charge\": 1}', NULL, '[{\"options\": null, \"field_type\": \"text\", \"field_label\": \"Name\", \"is_required\": 1}, {\"options\": [\"Male\", \"Female\", \"Other\", \"Prefer not to say\"], \"field_type\": \"select\", \"field_label\": \"Gender\", \"is_required\": 1}, {\"options\": null, \"field_type\": \"text\", \"field_label\": \"Date of Birth\", \"is_required\": 1}, {\"options\": null, \"field_type\": \"text\", \"field_label\": \"Email Address\", \"is_required\": 1}, {\"options\": null, \"field_type\": \"text\", \"field_label\": \"Phone Number\", \"is_required\": 1}, {\"options\": null, \"field_type\": \"text\", \"field_label\": \"Home Address\", \"is_required\": 1}, {\"options\": null, \"field_type\": \"text\", \"field_label\": \"Nationality\", \"is_required\": 1}]', '{\"application_firewall\": {\"period\": 30, \"status\": 2, \"attempts\": 5, \"frequency\": 60}}', 'Hello Dear,', 'Hello Dear,', '1.0', '2024-11-22 14:46:08', '2024-11-26 11:14:57', NULL, NULL, '{\"matrix\": \"0\", \"investment\": \"1\", \"trade_prediction\": \"0\", \"staking_investment\": \"1\"}', '{\"fixed_commission\": {\"bonus\": 5, \"status\": 1}, \"percentage_commission\": {\"bonus\": 5, \"status\": 1}, \"performance_based_commission\": {\"bonus\": 15, \"status\": 1, \"threshold\": 1000}, \"monthly_team_investment_commission\": {\"bonus\": 100, \"status\": 1, \"monthly_team_investment\": 100000}}');
-- --------------------------------------------------------
--
-- Table structure for table `sms_gateways`
--
CREATE TABLE `sms_gateways` (
`id` bigint UNSIGNED NOT NULL,
`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`credential` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '1' COMMENT 'Active : 1, Inactive : 0',
`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 `sms_gateways`
--
INSERT INTO `sms_gateways` (`id`, `code`, `name`, `credential`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TWILIO102', 'Twilio SMS Gateway', '{\"account_sid\":\"demo\",\"auth_token\":\"demo\",\"from_number\":\"demo\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(2, 'IMESSAGE103', 'Message Bird SMS Gateway', '{\"access_key\":\"demo\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08'),
(3, 'MAGIC104', 'Text Magic SMS Gateway', '{\"api_key\":\"demo\",\"text_magic_username\":\"demo\"}', 1, '2024-11-22 14:46:08', '2024-11-22 14:46:08');
-- --------------------------------------------------------
--
-- Table structure for table `staking_investments`
--
CREATE TABLE `staking_investments` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`staking_plan_id` bigint UNSIGNED NOT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`interest` decimal(8,2) NOT NULL DEFAULT '0.00',
`expiration_date` timestamp NULL DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `staking_plans`
--
CREATE TABLE `staking_plans` (
`id` bigint UNSIGNED NOT NULL,
`duration` int NOT NULL DEFAULT '0',
`interest_rate` decimal(8,2) NOT NULL DEFAULT '0.00',
`minimum_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`maximum_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`status` tinyint NOT NULL DEFAULT '1',
`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 `staking_plans`
--
INSERT INTO `staking_plans` (`id`, `duration`, `interest_rate`, `minimum_amount`, `maximum_amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 15, 10.00, 100.00000000, 1000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(2, 30, 15.00, 1000.00000000, 10000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(3, 45, 20.00, 10000.00000000, 100000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(4, 60, 15.00, 100000.00000000, 1000000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(5, 75, 25.00, 10000.00000000, 100000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10'),
(6, 90, 30.00, 100000.00000000, 1000000.00000000, 1, '2024-11-22 14:46:10', '2024-11-22 14:46:10');
-- --------------------------------------------------------
--
-- Table structure for table `subscribers`
--
CREATE TABLE `subscribers` (
`id` bigint UNSIGNED NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 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 `time_tables`
--
CREATE TABLE `time_tables` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`time` int NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `time_tables`
--
INSERT INTO `time_tables` (`id`, `name`, `time`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hours', 1, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(2, 'Days', 24, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(3, 'Weeks', 168, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(4, 'Months', 720, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09'),
(5, 'Years', 8760, 1, '2024-11-22 14:46:09', '2024-11-22 14:46:09');
-- --------------------------------------------------------
--
-- Table structure for table `trade_logs`
--
CREATE TABLE `trade_logs` (
`id` bigint UNSIGNED NOT NULL,
`user_id` int DEFAULT NULL,
`crypto_currency_id` int DEFAULT NULL,
`original_price` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`duration` int DEFAULT NULL,
`arrival_time` timestamp NULL DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT '1',
`volume` tinyint NOT NULL DEFAULT '1',
`outcome` tinyint NOT NULL DEFAULT '4',
`status` tinyint NOT NULL DEFAULT '1',
`meta` json DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`winning_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `trade_parameters`
--
CREATE TABLE `trade_parameters` (
`id` bigint UNSIGNED NOT NULL,
`time` int DEFAULT NULL,
`unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`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 `transactions`
--
CREATE TABLE `transactions` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`post_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT '1',
`wallet_type` tinyint NOT NULL DEFAULT '1',
`source` tinyint NOT NULL DEFAULT '1',
`details` varchar(255) CHARACTER SET utf8mb4 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 `users`
--
CREATE TABLE `users` (
`id` bigint UNSIGNED NOT NULL,
`uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`card_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0528828110554604',
`card_cvv` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '323',
`card_expiry` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '12/27',
`card_status` int DEFAULT NULL,
`google_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`referral_by` int DEFAULT NULL,
`position_id` int DEFAULT NULL,
`position` int DEFAULT NULL,
`email` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`kyc_status` tinyint NOT NULL DEFAULT '2',
`status` tinyint NOT NULL DEFAULT '1' COMMENT 'Active : 1, Banned : 0',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`two_factor_secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`two_factor_recovery_codes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
`remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta` json DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`aggregate_investment` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`collective_investment` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`last_reward_update` timestamp NULL DEFAULT NULL,
`reward_identifier` int NOT NULL DEFAULT '0',
`agent_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `uuid`, `first_name`, `last_name`, `card_number`, `card_cvv`, `card_expiry`, `card_status`, `google_id`, `facebook_id`, `referral_by`, `position_id`, `position`, `email`, `phone`, `email_verified_at`, `image`, `kyc_status`, `status`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `remember_token`, `meta`, `created_at`, `updated_at`, `aggregate_investment`, `collective_investment`, `last_reward_update`, `reward_identifier`, `agent_id`) VALUES
(10, 'b35af042-c417-4a72-b55c-41ffadb15927', 'Ugo', NULL, '0528828110554604', '323', '12/27', NULL, NULL, NULL, NULL, NULL, NULL, 'ugoblade3125@gmail.com', NULL, '2024-11-26 11:52:41', NULL, 2, 1, '$2y$10$sX/JI8E/UKaxaZcPKbHcg.Opr6ycJ7Hh.aWroNp6GXkmpfEcj2PfW', NULL, NULL, NULL, 'A4iAMOfdAFiopgCTgqtCLoXdllvAq6XMJJWUs2IxDT3MOcGzObdwoI0daI7V', NULL, '2024-11-26 11:52:41', '2024-11-26 12:03:55', 0.00000000, 0.00000000, NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `wallets`
--
CREATE TABLE `wallets` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`primary_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`investment_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trade_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`practice_balance` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`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 `wallets`
--
INSERT INTO `wallets` (`id`, `user_id`, `primary_balance`, `investment_balance`, `trade_balance`, `practice_balance`, `created_at`, `updated_at`) VALUES
(1, 1, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-22 14:53:56', '2024-11-22 14:53:56'),
(2, 2, 2150.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-22 16:32:00', '2024-11-23 19:48:44'),
(3, 3, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-23 20:01:36', '2024-11-23 20:01:36'),
(4, 4, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-23 20:19:21', '2024-11-23 20:19:21'),
(5, 5, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-24 03:57:31', '2024-11-24 03:57:31'),
(6, 6, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-24 04:47:59', '2024-11-24 04:47:59'),
(7, 7, 2000.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-24 04:58:49', '2024-11-24 15:00:52'),
(8, 8, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-24 05:15:22', '2024-11-24 05:15:22'),
(9, 9, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-24 16:59:12', '2024-11-24 16:59:12'),
(10, 10, 0.00000000, 0.00000000, 0.00000000, 100.00000000, '2024-11-26 11:52:41', '2024-11-26 11:52:41');
-- --------------------------------------------------------
--
-- Table structure for table `withdraw_logs`
--
CREATE TABLE `withdraw_logs` (
`id` bigint UNSIGNED NOT NULL,
`uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`withdraw_method_id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`final_amount` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`after_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`trx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`meta` json DEFAULT NULL,
`details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '3',
`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 `withdraw_methods`
--
CREATE TABLE `withdraw_methods` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`currency_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`min_limit` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`max_limit` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`fixed_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`percent_charge` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`rate` decimal(28,8) NOT NULL DEFAULT '0.00000000',
`file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parameter` json DEFAULT NULL,
`instruction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admins_username_unique` (`username`),
ADD UNIQUE KEY `admins_email_unique` (`email`);
--
-- Indexes for table `admin_password_resets`
--
ALTER TABLE `admin_password_resets`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admin_password_resets_email_unique` (`email`);
--
-- Indexes for table `agents`
--
ALTER TABLE `agents`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `agents_email_unique` (`email`);
--
-- Indexes for table `agent_password_resets`
--
ALTER TABLE `agent_password_resets`
ADD PRIMARY KEY (`id`),
ADD KEY `agent_password_resets_email_index` (`email`);
--
-- Indexes for table `agent_transactions`
--
ALTER TABLE `agent_transactions`
ADD PRIMARY KEY (`id`),
ADD KEY `agent_transactions_agent_id_index` (`agent_id`);
--
-- Indexes for table `agent_withdraw_logs`
--
ALTER TABLE `agent_withdraw_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `agent_withdraw_logs_uid_index` (`uid`),
ADD KEY `agent_withdraw_logs_agent_id_index` (`agent_id`);
--
-- Indexes for table `commissions`
--
ALTER TABLE `commissions`
ADD PRIMARY KEY (`id`),
ADD KEY `commissions_user_id_index` (`user_id`),
ADD KEY `commissions_from_user_id_index` (`from_user_id`);
--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crons`
--
ALTER TABLE `crons`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crypto_currencies`
--
ALTER TABLE `crypto_currencies`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `email_sms_templates`
--
ALTER TABLE `email_sms_templates`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `email_sms_templates_code_unique` (`code`),
ADD UNIQUE KEY `email_sms_templates_name_unique` (`name`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Indexes for table `firewall_ips`
--
ALTER TABLE `firewall_ips`
ADD PRIMARY KEY (`id`),
ADD KEY `firewall_ips_ip_index` (`ip`);
--
-- Indexes for table `firewall_logs`
--
ALTER TABLE `firewall_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `firewall_logs_ip_index` (`ip`);
--
-- Indexes for table `frontends`
--
ALTER TABLE `frontends`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `holidays`
--
ALTER TABLE `holidays`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `investment_logs`
--
ALTER TABLE `investment_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `investment_logs_uid_index` (`uid`),
ADD KEY `investment_logs_user_id_index` (`user_id`);
--
-- Indexes for table `investment_plans`
--
ALTER TABLE `investment_plans`
ADD PRIMARY KEY (`id`),
ADD KEY `investment_plans_uid_index` (`uid`);
--
-- Indexes for table `investment_user_rewards`
--
ALTER TABLE `investment_user_rewards`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`id`),
ADD KEY `jobs_queue_index` (`queue`);
--
-- Indexes for table `ltu_languages`
--
ALTER TABLE `ltu_languages`
ADD PRIMARY KEY (`id`),
ADD KEY `ltu_languages_code_index` (`code`);
--
-- Indexes for table `matrix`
--
ALTER TABLE `matrix`
ADD PRIMARY KEY (`id`),
ADD KEY `matrix_uid_index` (`uid`);
--
-- Indexes for table `matrix_investments`
--
ALTER TABLE `matrix_investments`
ADD PRIMARY KEY (`id`),
ADD KEY `matrix_investments_uid_index` (`uid`);
--
-- Indexes for table `matrix_levels`
--
ALTER TABLE `matrix_levels`
ADD PRIMARY KEY (`id`),
ADD KEY `matrix_levels_plan_id_index` (`plan_id`);
--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
ADD PRIMARY KEY (`id`),
ADD KEY `menus_parent_id_foreign` (`parent_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD PRIMARY KEY (`id`),
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);
--
-- Indexes for table `pin_generates`
--
ALTER TABLE `pin_generates`
ADD PRIMARY KEY (`id`),
ADD KEY `pin_generates_uid_index` (`uid`),
ADD KEY `pin_generates_user_id_index` (`user_id`),
ADD KEY `pin_generates_set_user_id_index` (`set_user_id`);
--
-- Indexes for table `plugin_configurations`
--
ALTER TABLE `plugin_configurations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sms_gateways`
--
ALTER TABLE `sms_gateways`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `sms_gateways_code_unique` (`code`);
--
-- Indexes for table `staking_investments`
--
ALTER TABLE `staking_investments`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `staking_plans`
--
ALTER TABLE `staking_plans`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
ADD PRIMARY KEY (`id`),
ADD KEY `subscribers_email_index` (`email`);
--
-- Indexes for table `time_tables`
--
ALTER TABLE `time_tables`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `trade_logs`
--
ALTER TABLE `trade_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `trade_parameters`
--
ALTER TABLE `trade_parameters`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
ADD PRIMARY KEY (`id`),
ADD KEY `transactions_user_id_index` (`user_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`),
ADD UNIQUE KEY `users_phone_unique` (`phone`);
--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `withdraw_logs_uid_index` (`uid`),
ADD KEY `withdraw_logs_user_id_index` (`user_id`);
--
-- Indexes for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `admin_password_resets`
--
ALTER TABLE `admin_password_resets`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `agents`
--
ALTER TABLE `agents`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `agent_password_resets`
--
ALTER TABLE `agent_password_resets`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `agent_transactions`
--
ALTER TABLE `agent_transactions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `agent_withdraw_logs`
--
ALTER TABLE `agent_withdraw_logs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crons`
--
ALTER TABLE `crons`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `crypto_currencies`
--
ALTER TABLE `crypto_currencies`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `email_sms_templates`
--
ALTER TABLE `email_sms_templates`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `firewall_ips`
--
ALTER TABLE `firewall_ips`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `firewall_logs`
--
ALTER TABLE `firewall_logs`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `frontends`
--
ALTER TABLE `frontends`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
--
-- AUTO_INCREMENT for table `holidays`
--
ALTER TABLE `holidays`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `investment_logs`
--
ALTER TABLE `investment_logs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `investment_plans`
--
ALTER TABLE `investment_plans`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `investment_user_rewards`
--
ALTER TABLE `investment_user_rewards`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `ltu_languages`
--
ALTER TABLE `ltu_languages`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `matrix`
--
ALTER TABLE `matrix`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `matrix_investments`
--
ALTER TABLE `matrix_investments`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `matrix_levels`
--
ALTER TABLE `matrix_levels`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pin_generates`
--
ALTER TABLE `pin_generates`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `plugin_configurations`
--
ALTER TABLE `plugin_configurations`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `sms_gateways`
--
ALTER TABLE `sms_gateways`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `staking_investments`
--
ALTER TABLE `staking_investments`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `staking_plans`
--
ALTER TABLE `staking_plans`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `time_tables`
--
ALTER TABLE `time_tables`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `trade_logs`
--
ALTER TABLE `trade_logs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `trade_parameters`
--
ALTER TABLE `trade_parameters`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `menus`
--
ALTER TABLE `menus`
ADD CONSTRAINT `menus_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menus` (`id`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Back to Directory
nL+D550H?Mx ,D"v]qv;6*Zqn)ZP 0 !1 A "#a$2Qr D8 a Ri[f\mIykIw0 cuFcRı?lO7к_f˓[C$殷WF<_W ԣs KcëIzyQy /_LKℂ;C",pFA: /]=H ~,ls/9ć:[=/#f;)x {ٛEQ )~ =𘙲r*2~ a _V=' kumF D}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq 1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo( 3=M(zȰ+i*NA r6KnSl )!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\ ͔]ޒ SJȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtf h9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N +0e2]] 9VTPO7h(F*癈 '=QVZDF,d߬~TX
G[`le69CR(!S2!P
<0x < !1AQ "Raq02Br#SCTb
?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ
τVYTD I62'8Y2 7'\TP.6d&˦@Vqi|8- OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL
u"TÙM=6 (^"7r} =6YݾlCuhquympǦ
G jhsǜNlɻ}o7 #S6aw4!OSrD57%|?x>L
|/nD6?/8w#[)L7+6〼T ATg ! %5MmZ/c-{1_Je"|^$'O&ޱմ Trb$ w)R$&
N1EtdU3Uȉ1pM" N*(DN yd96.(jQ)X
5cQɎMyW? Q*!R>6=7)Xj5`J]e 8%t!+'!1Q 5 !1 AQaqё#2"0BRb ? Gt^## .llQT $v,,m 㵜5 ubV =sY+@d{N! dnO< .-B; _wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc. WDtA$j@:) -# u
c1<@ۗ9F)KJ-hpP]_x[qBlbp ʖw q"LFGd ƶ*s+ډ_Zc"? %t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi` ]uJVoV DG< SB 6ϏQ@ TiUly OU0kfV~~}SZ@*WUUi##; s/[ =!7}" WN]'(L! ~y5g9T̅JkbM' +s:S + B)v@Mj
e Cf jE 0Y\QnzG1д~Wo{T 9?`Rmyhsy3!HAD]mc1~2L Su7xT;j$`}4->L#vzŏ ILS ֭ T { rjGKC; bpU= -`BsK.SFw4Mq]ZdHS0)tLg