--
-- Host: localhost    Database: trade
-- ------------------------------------------------------


--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `click_url` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_notifications`
--

INSERT INTO `admin_notifications` VALUES
(1,1,'New member registered',0,'/admin/users/detail/1','2025-12-21 15:43:27','2025-12-21 15:43:27');

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `quantity` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `total_cost` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `assets`
--


--
-- Table structure for table `binary_trades`
--

CREATE TABLE `binary_trades` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `coin_pair_id` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `result_price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `win_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `profit` decimal(8,2) NOT NULL DEFAULT 0.00,
  `duration` int(11) NOT NULL DEFAULT 0,
  `trade_ended_at` datetime DEFAULT NULL,
  `direction` varchar(40) DEFAULT NULL,
  `result` varchar(40) DEFAULT NULL,
  `trx` varchar(40) DEFAULT NULL,
  `win_status` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `coin_pair_id` (`coin_pair_id`),
  KEY `win_status` (`win_status`),
  KEY `status` (`status`),
  KEY `trx` (`trx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `binary_trades`
--


--
-- Table structure for table `coin_pairs`
--

CREATE TABLE `coin_pairs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `listed_market_name` text DEFAULT NULL,
  `symbol` text DEFAULT NULL,
  `market_id` int(11) NOT NULL DEFAULT 0,
  `coin_id` int(11) NOT NULL DEFAULT 0,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `minimum_buy_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `maximum_buy_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `minimum_sell_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `maximum_sell_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `minimum_swap_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `maximum_swap_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `minimum_swap_fee` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `maximum_swap_fee` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `percent_charge_for_sell` decimal(5,2) NOT NULL DEFAULT 0.00,
  `percent_charge_for_buy` decimal(5,2) NOT NULL DEFAULT 0.00,
  `binary_trade_profit` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `min_binary_trade_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `max_binary_trade_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `binary_trade_duration` text DEFAULT NULL,
  `binary_increment_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_liquidation_check_at` datetime NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=enable,0=disable',
  `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=yes,0=no',
  `type` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coin_pairs`
--

INSERT INTO `coin_pairs` VALUES
(1,'BINANCE','USDT_BTC',1,3,0.00000000,0.10000000,10000.00000000,0.10000000,10000.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.50,0.50,0.00000000,0.00000000,0.00000000,NULL,0.00000000,'2025-12-24 06:03:36',1,0,1,'2025-11-12 15:12:26','2025-12-24 05:03:36'),
(2,'BINANCE','ETH_BTC',1,2,0.00000000,0.10000000,10000.00000000,0.10000000,10000.00000000,0.00000000,0.00000000,0.00000000,0.00000000,0.50,0.50,0.00000000,0.00000000,0.00000000,NULL,0.00000000,'2025-12-24 06:03:36',1,0,1,'2025-11-12 15:18:00','2025-12-24 05:03:36'),
(3,'BINANCE','BTC_USDT',2,1,0.00000000,0.00020000,-1.00000000,0.00400000,-1.00000000,0.00000000,0.00000000,0.00000000,0.00000000,1.00,0.50,85.00000000,0.00100000,10.00000000,'[\"30\",\"60\",\"90\"]',0.01000000,'2025-12-23 15:03:43',1,1,3,'2025-11-12 17:23:58','2025-12-23 14:03:43'),
(4,'BINANCE','XRP_USDT',2,4,0.00000000,1.00000000,-1.00000000,1.00000000,-1.00000000,0.00000000,0.00000000,0.00000000,0.00000000,1.00,0.50,0.00000000,0.00000000,0.00000000,NULL,0.00000000,'2025-12-24 06:03:36',1,0,1,'2025-11-12 17:27:30','2025-12-24 05:03:36');

--
-- Table structure for table `commodities`
--

CREATE TABLE `commodities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `unit` varchar(40) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `twenty_four_hour_change` decimal(5,2) NOT NULL DEFAULT 0.00,
  `seven_day_change` decimal(5,2) NOT NULL DEFAULT 0.00,
  `market_capital` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commodities`
--


--
-- Table structure for table `commodity_price_snapshots`
--

CREATE TABLE `commodity_price_snapshots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commodity_id` int(11) NOT NULL DEFAULT 0,
  `price_24h_ago` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_24h_update` timestamp NULL DEFAULT NULL,
  `price_7d_ago` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_7d_update` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `commodity_price_snapshots`
--


--
-- Table structure for table `cron_job_logs`
--

CREATE TABLE `cron_job_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cron_job_id` int(10) unsigned NOT NULL DEFAULT 0,
  `start_at` datetime DEFAULT NULL,
  `end_at` datetime DEFAULT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `error` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cron_job_logs`
--


--
-- Table structure for table `cron_jobs`
--

CREATE TABLE `cron_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `alias` varchar(40) DEFAULT NULL,
  `action` text DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `cron_schedule_id` int(11) NOT NULL DEFAULT 0,
  `next_run` datetime DEFAULT NULL,
  `last_run` datetime DEFAULT NULL,
  `is_running` tinyint(1) NOT NULL DEFAULT 1,
  `is_default` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cron_jobs`
--

INSERT INTO `cron_jobs` VALUES
(5,'Commodity Price Update','price_update','[\"App\\\\Http\\\\Controllers\\\\CronController\", \"priceUpdate\"]','',3,'2025-05-04 05:55:07','2025-05-03 05:55:07',1,1,'2024-05-05 22:46:06','2025-05-02 17:55:07');

--
-- Table structure for table `cron_schedules`
--

CREATE TABLE `cron_schedules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `interval` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cron_schedules`
--

INSERT INTO `cron_schedules` VALUES
(1,'Hourly',3600,1,'2024-03-13 17:34:09','2024-05-05 22:45:32'),
(3,'Daily',86400,1,'2024-05-05 22:46:39','2024-05-05 22:46:39');

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

CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Crypto,2=Fiat',
  `name` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL,
  `symbol` varchar(55) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000 COMMENT 'only for fiat currency',
  `ranking` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Enable,0=Disable',
  `highlighted_coin` tinyint(1) NOT NULL DEFAULT 0,
  `p2p_sn` int(11) NOT NULL DEFAULT 0,
  `last_update` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `currencies_name_unique` (`name`),
  UNIQUE KEY `currencies_symbol_unique` (`symbol`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `currencies` VALUES
(1,1,'Bitcoin','','BTC',NULL,88248.25240350,1,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(2,1,'Ethereum','','ETH',NULL,2981.66688786,2,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(3,1,'Tether USDt','','USDT',NULL,0.99949009,3,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(4,1,'XRP','','XRP',NULL,1.94964858,4,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(5,1,'BNB','','BNB',NULL,853.64004928,4,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(6,1,'Solana','','SOL',NULL,126.34978746,7,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(7,1,'USDC','','USDC',NULL,0.99980918,6,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(8,1,'TRON','','TRX',NULL,0.27935495,8,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(9,1,'Dogecoin','','DOGE',NULL,0.13188577,9,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(10,1,'Cardano','','ADA',NULL,0.37644952,10,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(11,1,'Hyperliquid','','HYPE',NULL,25.22126100,13,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(12,1,'Chainlink','','LINK',NULL,12.63775764,12,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(13,1,'Zcash','','ZEC',NULL,452.66598280,15,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(14,1,'Bitcoin Cash','','BCH',NULL,596.85723822,11,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(15,1,'Ethena USDe','','USDe',NULL,0.99874215,15,1,0,0,0,'2025-11-07 10:39:39','2025-11-07 10:39:39'),
(16,1,'Stellar','','XLM',NULL,0.22241489,17,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(17,1,'UNUS SED LEO','','LEO',NULL,8.07884673,15,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(18,1,'Sui','','SUI',NULL,1.47611365,20,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(19,1,'Avalanche','','AVAX',NULL,12.32995160,22,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(20,1,'Hedera','','HBAR',NULL,0.11301618,23,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(21,1,'Litecoin','','LTC',NULL,77.32928113,19,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(22,1,'Monero','','XMR',NULL,447.32273334,14,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(23,1,'Shiba Inu','','SHIB',NULL,0.00000749,24,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(24,1,'Dai','','DAI',NULL,0.99972346,21,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(25,1,'Toncoin','','TON',NULL,1.48463630,28,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(26,1,'Polkadot','','DOT',NULL,1.86060004,32,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(27,1,'Cronos','','CRO',NULL,0.09774063,26,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(28,1,'Internet Computer','','ICP',NULL,2.94906217,46,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(29,1,'Mantle','','MNT',NULL,1.14328716,27,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(30,1,'Bittensor','','TAO',NULL,229.50303408,36,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(31,1,'Uniswap','','UNI',NULL,5.72899414,29,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(32,1,'Aave','','AAVE',NULL,181.03391645,33,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(33,1,'World Liberty Financial USD','','USD1',NULL,0.99900371,34,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(34,1,'NEAR Protocol','','NEAR',NULL,1.52066514,38,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(35,1,'World Liberty Financial','','WLFI',NULL,0.13494232,30,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(36,1,'PayPal USD','','PYUSD',NULL,0.99954899,25,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(37,1,'Bitget Token','','BGB',NULL,3.47022081,35,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(38,1,'MemeCore','','M',NULL,1.41030911,42,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(39,1,'OKB','','OKB',NULL,108.41546623,37,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(40,1,'Ethereum Classic','','ETC',NULL,12.45513771,39,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(41,1,'Pepe','','PEPE',NULL,0.00000409,43,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(42,1,'Ethena','','ENA',NULL,0.21103669,45,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(43,1,'Aptos','','APT',NULL,1.63906021,54,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(44,1,'Aster','','ASTER',NULL,0.72472100,40,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(45,1,'Ondo','','ONDO',NULL,0.40042573,54,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(46,1,'Pi','','PI',NULL,0.21219615,3714,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(47,1,'Polygon (prev. MATIC)','','POL',NULL,0.11050947,56,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(48,1,'Worldcoin','','WLD',NULL,0.51812363,52,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(49,1,'KuCoin Token','','KCS',NULL,10.72974446,50,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(50,1,'Tether Gold','','XAUt',NULL,3985.48457930,50,1,0,0,0,'2025-11-07 10:39:39','2025-11-07 10:39:39'),
(51,1,'OFFICIAL TRUMP','','TRUMP',NULL,5.14900098,59,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(52,1,'Filecoin','','FIL',NULL,1.30781528,62,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(53,1,'Arbitrum','','ARB',NULL,0.19063650,58,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(54,1,'Algorand','','ALGO',NULL,0.11424163,60,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(55,1,'Dash','','DASH',NULL,38.93777273,85,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(56,1,'PAX Gold','','PAXG',NULL,4351.82133232,47,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(57,1,'Kaspa','','KAS',NULL,0.04428416,55,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(58,1,'Cosmos','','ATOM',NULL,1.97677948,61,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(59,1,'Pump.fun','','PUMP',NULL,0.00197930,71,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(60,1,'VeChain','','VET',NULL,0.01074146,64,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(61,1,'Story','','IP',NULL,0.00004468,3945,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(62,1,'Flare','','FLR',NULL,0.01168535,63,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(63,1,'Sky','','SKY',NULL,0.06244120,49,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(64,1,'Jupiter','','JUP',NULL,0.19708667,75,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(65,1,'Render','','RENDER',NULL,1.29381887,73,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(66,1,'Ripple USD','','RLUSD',NULL,0.99979412,51,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(67,1,'Sei','','SEI',NULL,0.11208096,70,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(68,1,'First Digital USD','','FDUSD',NULL,0.99923713,80,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(69,1,'Bonk','','BONK',NULL,0.00000833,72,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(70,1,'Quant','','QNT',NULL,74.19599194,66,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(71,1,'XDC Network','','XDC',NULL,0.04938328,65,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(72,1,'GateToken','','GT',NULL,10.27745571,67,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(73,1,'Pudgy Penguins','','PENGU',NULL,0.00931426,77,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(74,1,'Virtuals Protocol','','VIRTUAL',NULL,0.71842297,89,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(75,1,'Immutable','','IMX',NULL,0.23137419,93,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(76,1,'Aerodrome Finance','','AERO',NULL,0.51609462,90,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(77,1,'PancakeSwap','','CAKE',NULL,1.85084590,74,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(78,1,'Optimism','','OP',NULL,0.28026420,79,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(79,1,'Tezos','','XTZ',NULL,0.45009297,88,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(80,1,'Nexo','','NEXO',NULL,0.92377227,76,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(81,1,'Celestia','','TIA',NULL,0.47683439,98,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(82,1,'Stacks','','STX',NULL,0.25785623,92,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(83,1,'Lido DAO','','LDO',NULL,0.55448561,83,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(84,1,'Injective','','INJ',NULL,4.84277345,87,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(85,1,'The Graph','','GRT',NULL,0.03794307,100,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(86,1,'Curve DAO Token','','CRV',NULL,0.35021246,82,1,0,0,1766217661,'2025-11-07 10:39:39','2025-12-20 07:01:01'),
(87,1,'Morpho','','MORPHO',NULL,1.21896806,95,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(88,1,'Artificial Superintelligence Alliance','','FET',NULL,0.21268365,86,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(89,1,'SPX6900','','SPX',NULL,0.49538040,93,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(90,1,'FLOKI','','FLOKI',NULL,0.00004120,102,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(91,1,'DoubleZero','','2Z',NULL,0.10971376,106,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(92,1,'Kaia','','KAIA',NULL,0.06103422,107,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(93,1,'ZKsync','','ZK',NULL,0.02840333,127,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(94,1,'Pyth Network','','PYTH',NULL,0.05981073,119,1,0,0,1766224861,'2025-11-07 10:39:39','2025-12-20 09:01:01'),
(95,1,'IOTA','','IOTA',NULL,0.09012869,108,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(96,1,'Trust Wallet Token','','TWT',NULL,0.82241269,115,1,0,0,1766232061,'2025-11-07 10:39:39','2025-12-20 11:01:01'),
(97,1,'DeXe','','DEXE',NULL,3.33621165,134,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(98,1,'Decred','','DCR',NULL,16.77220681,130,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(99,1,'Starknet','','STRK',NULL,0.08318402,97,1,0,0,1766221261,'2025-11-07 10:39:39','2025-12-20 08:01:01'),
(100,1,'ether.fi','','ETHFI',NULL,0.74918116,84,1,0,0,1766228461,'2025-11-07 10:39:39','2025-12-20 10:01:01'),
(101,2,'United States Dollar','$','USD',NULL,0.00000000,0,0,0,0,0,'2025-11-09 13:23:10','2025-11-11 19:21:01'),
(102,2,'Australian Dollar','$','AUD',NULL,0.00000000,0,0,0,0,0,'2025-11-09 13:23:10','2025-11-11 19:21:05'),
(103,2,'Brazilian Real','R$','BRL',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(104,2,'Canadian Dollar','$','CAD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(105,2,'Swiss Franc','Fr','CHF',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(106,2,'Chilean Peso','$','CLP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(107,2,'Chinese Yuan','¥','CNY',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(108,2,'Czech Koruna','Kč','CZK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(109,2,'Danish Krone','kr','DKK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(110,2,'Euro','€','EUR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(111,2,'Pound Sterling','£','GBP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(112,2,'Hong Kong Dollar','$','HKD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(113,2,'Hungarian Forint','Ft','HUF',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(114,2,'Indonesian Rupiah','Rp','IDR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(115,2,'Israeli New Shekel','₪','ILS',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(116,2,'Indian Rupee','₹','INR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(117,2,'Japanese Yen','¥','JPY',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(118,2,'South Korean Won','₩','KRW',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(119,2,'Mexican Peso','$','MXN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(120,2,'Malaysian Ringgit','RM','MYR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(121,2,'Norwegian Krone','kr','NOK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(122,2,'New Zealand Dollar','$','NZD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(123,2,'Philippine Peso','₱','PHP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(124,2,'Pakistani Rupee','₨','PKR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(125,2,'Polish Złoty','zł','PLN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(126,2,'Russian Ruble','₽','RUB',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(127,2,'Swedish Krona','kr','SEK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(128,2,'Singapore Dollar','S$','SGD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(129,2,'Thai Baht','฿','THB',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(130,2,'Turkish Lira','₺','TRY',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(131,2,'New Taiwan Dollar','NT$','TWD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(132,2,'South African Rand','R','ZAR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(133,2,'United Arab Emirates Dirham','د.إ','AED',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(134,2,'Bulgarian Lev','лв','BGN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(135,2,'Croatian Kuna','kn','HRK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(136,2,'Mauritian Rupee','₨','MUR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(137,2,'Romanian Leu','lei','RON',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(138,2,'Icelandic Króna','kr','ISK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(139,2,'Nigerian Naira','₦','NGN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(140,2,'Colombian Peso','$','COP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(141,2,'Argentine Peso','$','ARS',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(142,2,'Peruvian Sol','S/.','PEN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(143,2,'Vietnamese Dong','₫','VND',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(144,2,'Ukrainian Hryvnia','₴','UAH',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(145,2,'Bolivian Boliviano','Bs.','BOB',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(146,2,'Albanian Lek','L','ALL',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(147,2,'Armenian Dram','֏','AMD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(148,2,'Azerbaijani Manat','₼','AZN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(149,2,'Bosnia-Herzegovina Convertible Mark','KM','BAM',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(150,2,'Bangladeshi Taka','৳','BDT',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(151,2,'Bahraini Dinar','.د.ب','BHD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(152,2,'Bermudan Dollar','$','BMD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(153,2,'Belarusian Ruble','Br','BYN',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(154,2,'Costa Rican Colón','₡','CRC',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(155,2,'Cuban Peso','$','CUP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(156,2,'Dominican Peso','$','DOP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(157,2,'Algerian Dinar','د.ج','DZD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(158,2,'Egyptian Pound','£','EGP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(159,2,'Georgian Lari','₾','GEL',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(160,2,'Ghanaian Cedi','₵','GHS',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(161,2,'Guatemalan Quetzal','Q','GTQ',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(162,2,'Honduran Lempira','L','HNL',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(163,2,'Iraqi Dinar','ع.د','IQD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(164,2,'Iranian Rial','﷼','IRR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(165,2,'Jamaican Dollar','$','JMD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(166,2,'Jordanian Dinar','د.ا','JOD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(167,2,'Kenyan Shilling','Sh','KES',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(168,2,'Kyrgystani Som','с','KGS',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(169,2,'Cambodian Riel','៛','KHR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(170,2,'Kuwaiti Dinar','د.ك','KWD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(171,2,'Kazakhstani Tenge','₸','KZT',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(172,2,'Lebanese Pound','ل.ل','LBP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(173,2,'Sri Lankan Rupee','Rs','LKR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(174,2,'Moroccan Dirham','د.م.','MAD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(175,2,'Moldovan Leu','L','MDL',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(176,2,'Macedonian Denar','ден','MKD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(177,2,'Myanma Kyat','Ks','MMK',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(178,2,'Namibian Dollar','$','NAD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(179,2,'Nicaraguan Córdoba','C$','NIO',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(180,2,'Nepalese Rupee','₨','NPR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(181,2,'Omani Rial','ر.ع.','OMR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(182,2,'Panamanian Balboa','B/.','PAB',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(183,2,'Qatari Rial','ر.ق','QAR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(184,2,'Serbian Dinar','дин.','RSD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(185,2,'Saudi Riyal','ر.س','SAR',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(186,2,'South Sudanese Pound','£','SSP',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(187,2,'Tunisian Dinar','د.ت','TND',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(188,2,'Trinidad and Tobago Dollar','$','TTD',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(189,2,'Ugandan Shilling','Sh','UGX',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(190,2,'Uruguayan Peso','$','UYU',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(191,2,'Uzbekistan Som','so\'m','UZS',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10'),
(192,2,'Sovereign Bolivar','Bs.','VES',NULL,0.00000000,0,1,0,0,0,'2025-11-09 13:23:10','2025-11-09 13:23:10');

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

CREATE TABLE `deposits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `method_code` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `method_currency` varchar(40) DEFAULT NULL,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `final_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `detail` text DEFAULT NULL,
  `btc_amount` varchar(255) DEFAULT NULL,
  `btc_wallet` varchar(255) DEFAULT NULL,
  `trx` varchar(40) DEFAULT NULL,
  `payment_try` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=>success, 2=>pending, 3=>cancel',
  `from_api` tinyint(1) NOT NULL DEFAULT 0,
  `is_web` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'This will be 1 if the request is from NextJs application',
  `admin_feedback` text DEFAULT NULL,
  `success_url` varchar(255) DEFAULT NULL,
  `failed_url` varchar(255) DEFAULT NULL,
  `last_cron` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposits`
--


--
-- Table structure for table `extensions`
--

CREATE TABLE `extensions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `act` varchar(40) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `script` text DEFAULT NULL,
  `shortcode` text DEFAULT NULL COMMENT 'object',
  `support` text DEFAULT NULL COMMENT 'help section',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=>enable, 2=>disable',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `extensions`
--

INSERT INTO `extensions` VALUES
(1,'tawk-chat','Tawk.to','Key location is shown bellow','tawky_big.png','<script>\r\n                        var Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n                        (function(){\r\n                        var s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\n                        s1.async=true;\r\n                        s1.src=\"https://embed.tawk.to/{{app_key}}\";\r\n                        s1.charset=\"UTF-8\";\r\n                        s1.setAttribute(\"crossorigin\",\"*\");\r\n                        s0.parentNode.insertBefore(s1,s0);\r\n                        })();\r\n                    </script>','{\"app_key\":{\"title\":\"App Key\",\"value\":\"------\"}}','twak.png',0,'2019-10-18 11:16:05','2022-03-21 17:22:24'),
(2,'google-recaptcha2','Google Recaptcha 2','Key location is shown bellow','recaptcha3.png','\n<script src=\"https://www.google.com/recaptcha/api.js\"></script>\n<div class=\"g-recaptcha\" data-sitekey=\"{{site_key}}\" data-callback=\"verifyCaptcha\"></div>\n<div id=\"g-recaptcha-error\"></div>','{\"site_key\":{\"title\":\"Site Key\",\"value\":\"6LdPC88fAAAAADQlUf_DV6Hrvgm-pZuLJFSLDOWV\"},\"secret_key\":{\"title\":\"Secret Key\",\"value\":\"6LdPC88fAAAAAG5SVaRYDnV2NpCrptLg2XLYKRKB\"}}','recaptcha.png',0,'2019-10-18 11:16:05','2024-05-15 03:44:53'),
(3,'custom-captcha','Custom Captcha','Just put any random string','customcaptcha.png',NULL,'{\"random_key\":{\"title\":\"Random String\",\"value\":\"SecureString\"}}','na',0,'2019-10-18 11:16:05','2022-10-12 17:02:43'),
(4,'google-analytics','Google Analytics','Key location is shown bellow','google_analytics.png','<script async src=\"https://www.googletagmanager.com/gtag/js?id={{measurement_id}}\"></script>\n                <script>\n                  window.dataLayer = window.dataLayer || [];\n                  function gtag(){dataLayer.push(arguments);}\n                  gtag(\"js\", new Date());\n                \n                  gtag(\"config\", \"{{measurement_id}}\");\n                </script>','{\"measurement_id\":{\"title\":\"Measurement ID\",\"value\":\"------\"}}','ganalytics.png',0,NULL,'2021-05-03 22:19:12'),
(5,'fb-comment','Facebook Comment ','Key location is shown bellow','Facebook.png','<div id=\"fb-root\"></div><script async defer crossorigin=\"anonymous\" src=\"https://connect.facebook.net/en_GB/sdk.js#xfbml=1&version=v4.0&appId={{app_key}}&autoLogAppEvents=1\"></script>','{\"app_key\":{\"title\":\"App Key\",\"value\":\"----\"}}','fb_com.PNG',0,NULL,'2022-03-21 17:18:36');

--
-- Table structure for table `forms`
--

CREATE TABLE `forms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `act` varchar(40) DEFAULT NULL,
  `form_data` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `forms`
--


--
-- Table structure for table `frontends`
--

CREATE TABLE `frontends` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `data_keys` varchar(40) DEFAULT NULL,
  `data_values` longtext DEFAULT NULL,
  `seo_content` longtext DEFAULT NULL,
  `tempname` varchar(40) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `frontends`
--

INSERT INTO `frontends` VALUES
(24,'about.content','{\"has_image\":\"1\",\"heading\":\"Why Trade Commodities?\",\"subheading\":\"Trade commodities for profit, diversification, and protection against inflation, leveraging their inherent value and market dynamics to fortify your portfolio\",\"video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=WOb4cj7izpE\",\"image\":\"664acda3efafe1716178339.png\"}',NULL,'basic','','2020-10-28 00:51:20','2024-05-19 22:12:20'),
(25,'blog.content','{\"heading\":\"Latest Article & Blog\",\"subheading\":\"Explore insights and ideas, dive into our latest blog posts for expert tips, trend analysis, inspirational and motivational  content\"}',NULL,'basic',NULL,'2020-10-28 00:51:34','2024-04-24 06:15:45'),
(27,'contact_us.content','{\"has_image\":\"1\",\"heading\":\"Reach Out for Inquiries\",\"subheading\":\"Reach out for inquiries, assistance, or collaborations. We\'re here to help! Fill out the form or connect via phone\\/email\",\"form_heading\":\"Get in Touch\",\"email\":\"support@visertrade.com\",\"mobile_number\":\"+44 20 1234 5678\",\"address\":\"123 Main Street, London\",\"image\":\"664acc4d4fb4b1716177997.png\"}',NULL,'basic','','2020-10-28 00:59:19','2024-05-19 22:06:38'),
(28,'counter.content','{\"heading\":\"Latest News\",\"sub_heading\":\"Register New Account\"}',NULL,NULL,NULL,'2020-10-28 01:04:02','2020-10-28 01:04:02'),
(31,'social_icon.element','{\"icon\":\"<i class=\\\"fab fa-facebook\\\"><\\/i>\",\"url\":\"https:\\/\\/www.facebook.com\\/\"}',NULL,'basic',NULL,'2020-11-12 04:07:30','2024-03-23 23:09:41'),
(33,'feature.content','{\"heading\":\"asdf\",\"sub_heading\":\"asdf\"}',NULL,NULL,NULL,'2021-01-03 23:40:54','2021-01-03 23:40:55'),
(34,'feature.element','{\"title\":\"asdf\",\"description\":\"asdf\",\"feature_icon\":\"asdf\"}',NULL,NULL,NULL,'2021-01-03 23:41:02','2021-01-03 23:41:02'),
(35,'service.element','{\"trx_type\":\"withdraw\",\"service_icon\":\"<i class=\\\"las la-highlighter\\\"><\\/i>\",\"title\":\"asdfasdf\",\"description\":\"asdfasdfasdfasdf\"}',NULL,NULL,NULL,'2021-03-06 01:12:10','2021-03-06 01:12:10'),
(36,'service.content','{\"trx_type\":\"deposit\",\"heading\":\"asdf fffff\",\"subheading\":\"555\"}',NULL,NULL,NULL,'2021-03-06 01:27:34','2022-03-30 08:07:06'),
(39,'banner.content','{\"has_image\":\"1\",\"heading\":\"Trade Commodities With Confidence In Our Platform\",\"subheading\":\"Optimize your trading strategy with advantageous conditions for precious metals and energies, ensuring profitability & resilience\",\"left_title\":\"Built for\",\"left_subtitle\":\"Super Traders\",\"right_title\":\"Tailored Trading\",\"right_subtitle\":\"Elite\",\"left_button_text\":\"Register\",\"left_button_link\":\"user\\/register\",\"right_button_text\":\"Login\",\"right_button_link\":\"user\\/login\",\"image\":\"65f552af8be571710576303.png\",\"left_image\":\"664acd5a86a461716178266.png\",\"right_image\":\"664acd5a8b87e1716178266.png\"}',NULL,'basic','','2021-05-02 06:09:30','2024-05-19 22:11:06'),
(41,'cookie.data','{\"short_desc\":\"We may use cookies or any other tracking technologies when you visit our website, including any other media form, mobile website, or mobile application related or connected to help customize the Site and improve your experience.\",\"description\":\"<div>\\r\\n  <h5>What information do we collect?<\\/h5>\\r\\n  <p>\\r\\n    We gather data from you when you register on our site, submit a request, buy\\r\\n    any services, react to an overview, or round out a structure. At the point\\r\\n    when requesting any assistance or enrolling on our site, as suitable, you\\r\\n    might be approached to enter your: name, email address, or telephone number.\\r\\n    You may, nonetheless, visit our site anonymously. <br><\\/p><p><br><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>How do we protect your information?<\\/h5>\\r\\n  <p>\\r\\n    All provided delicate\\/credit data is sent through Stripe.<br>After an\\r\\n    exchange, your private data (credit cards, social security numbers,\\r\\n    financials, and so on) won\'t be put away on our workers. <br><\\/p><p><br><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Do we disclose any information to outside parties?<\\/h5>\\r\\n  <p>\\r\\n    We don\'t sell, exchange, or in any case move to outside gatherings by and by\\r\\n    recognizable data. This does exclude confided in outsiders who help us in\\r\\n    working our site, leading our business, or adjusting you, since those\\r\\n    gatherings consent to keep this data private. We may likewise deliver your\\r\\n    data when we accept discharge is suitable to follow the law, implement our\\r\\n    site strategies, or ensure our own or others\' rights, property, or\\r\\n    wellbeing. <br><\\/p><p><br><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Children\'s Online Privacy Protection Act Compliance<\\/h5>\\r\\n  <p>\\r\\n    We are consistent with the prerequisites of COPPA (Children\'s Online Privacy\\r\\n    Protection Act), we don\'t gather any data from anybody under 13 years old.\\r\\n    Our site, items, and administrations are completely coordinated to\\r\\n    individuals who are in any event 13 years of age or more established. <br><\\/p><p><br><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Changes to our Privacy Policy<\\/h5>\\r\\n  <p>\\r\\n    If we decide to change our privacy policy, we will post those changes on\\r\\n    this page. <br><\\/p><p><br><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>How long we retain your information?<\\/h5>\\r\\n  <p>\\r\\n    At the point when you register for our site, we cycle and keep your\\r\\n    information we have about you however long you don\'t erase the record or\\r\\n    withdraw yourself (subject to laws and guidelines).<\\/p><p><br>\\r\\n  <\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>What we don\\u2019t do with your data<\\/h5>\\r\\n  <p>\\r\\n    We don\'t and will never share, unveil, sell, or in any case give your\\r\\n    information to different organizations for the promoting of their items or\\r\\n    administrations.\\r\\n  <\\/p>\\r\\n<\\/div>\",\"status\":1}',NULL,'basic',NULL,'2020-07-04 23:42:52','2024-04-08 01:10:27'),
(42,'policy_pages.element','{\"title\":\"Privacy Policy\",\"details\":\"<div><h5>What information do we collect?<\\/h5><p>We gather data from you when you register on our site, submit a request, buy any services, react to an overview, or round out a structure. At the point when requesting any assistance or enrolling on our site, as suitable, you might be approached to enter your: name, email address, or telephone number. You may, nonetheless, visit our site anonymously.<\\/p><p><br \\/><\\/p><\\/div><div><h5>How do we protect your information?<\\/h5><p>All provided delicate\\/credit data is sent through Stripe.<br \\/>After an exchange, your private data (credit cards, social security numbers, financials, and so on) won\'t be put away on our workers.<\\/p><p><br \\/><\\/p><\\/div><div><h5>Do we disclose any information to outside parties?<\\/h5><p>We don\'t sell, exchange, or in any case move to outside gatherings by and by recognizable data. This does exclude confided in outsiders who help us in working our site, leading our business, or adjusting you, since those gatherings consent to keep this data private. We may likewise deliver your data when we accept discharge is suitable to follow the law, implement our site strategies, or ensure our own or others\' rights, property, or wellbeing.<\\/p><p><br \\/><\\/p><\\/div><div><h5>Children\'s Online Privacy Protection Act Compliance<\\/h5><p>We are consistent with the prerequisites of COPPA (Children\'s Online Privacy Protection Act), we don\'t gather any data from anybody under 13 years old. Our site, items, and administrations are completely coordinated to individuals who are in any event 13 years of age or more established.<\\/p><p><br \\/><\\/p><\\/div><div><h5>Changes to our Privacy Policy<\\/h5><p>If we decide to change our privacy policy, we will post those changes on this page.<br \\/><br \\/><\\/p><\\/div><div><h5>How long we retain your information?<\\/h5><p>At the point when you register for our site, we cycle and keep your information we have about you however long you don\'t erase the record or withdraw yourself (subject to laws and guidelines).<\\/p><p><br \\/><\\/p><\\/div><div><h5>What we don\\u2019t do with your data<\\/h5><p>We don\'t and will never share, unveil, sell, or in any case give your information to different organizations for the promoting of their items or administrations.<\\/p><\\/div>\"}',NULL,'basic','privacy-policy','2021-06-09 08:50:42','2024-04-05 03:00:39'),
(43,'policy_pages.element','{\"title\":\"Terms of Service\",\"details\":\"<div>\\r\\n  <h5>Terms & Conditions for Users<\\/h5>\\r\\n  <p>\\r\\n    Before getting to this site, you are consenting to be limited by these site\\r\\n    Terms and Conditions of Use, every single appropriate law, and guidelines,\\r\\n    and concur that you are answerable for consistency with any material\\r\\n    neighborhood laws. If you disagree with any of these terms, you are\\r\\n    restricted from utilizing or getting to this site.\\r\\n  <\\/p>\\r\\n  <p><br \\/><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Support<\\/h5>\\r\\n  <p>\\r\\n    Whenever you have downloaded our item, you may get in touch with us for help\\r\\n    through email and we will give a valiant effort to determine your issue. We\\r\\n    will attempt to answer using the Email for more modest bug fixes, after\\r\\n    which we will refresh the center bundle. Content help is offered to\\r\\n    confirmed clients by Tickets as it were. Backing demands made by email and\\r\\n    Livechat.\\r\\n  <\\/p>\\r\\n  <p>\\r\\n    On the off chance that your help requires extra adjustment of the System, at\\r\\n    that point, you have two alternatives:<\\/p><ul><li><br \\/><\\/li>\\r\\n  <\\/ul>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Ownership<\\/h5>\\r\\n  <p>\\r\\n    You may not guarantee scholarly or selective possession of any of our items,\\r\\n    altered or unmodified. All items are property, we created them. Our items\\r\\n    are given \\\"with no guarantees\\\" without guarantee of any sort, either\\r\\n    communicated or suggested. On no occasion will our juridical individual be\\r\\n    subject to any harms including, however not restricted to, immediate,\\r\\n    roundabout, extraordinary, accidental, or significant harms or different\\r\\n    misfortunes emerging out of the utilization of or powerlessness to utilize\\r\\n    our items.\\r\\n  <\\/p>\\r\\n  <p><br \\/><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Warranty<\\/h5>\\r\\n  <p>\\r\\n    We don\'t offer any guarantee or assurance of these Services in any way. When\\r\\n    our Services have been modified we can\'t ensure they will work with all\\r\\n    outsider plugins, modules, or internet browsers. Program similarity ought to\\r\\n    be tried against the show formats on the demo worker. If you don\'t mind\\r\\n    guarantee that the programs you use will work with the component, as we can\\r\\n    not ensure that our systems will work with all program mixes.\\r\\n  <\\/p>\\r\\n  <p><br \\/><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Unauthorized\\/Illegal Usage<\\/h5>\\r\\n  <p>\\r\\n    You may not utilize our things for any illicit or unapproved reason or may\\r\\n    you, in the utilization of the stage, disregard any laws in your locale\\r\\n    (counting yet not restricted to copyright laws) just as the laws of your\\r\\n    nation and International law. Specifically, it is disallowed to utilize the\\r\\n    things on our foundation for pages that advance: brutality, illegal\\r\\n    intimidation, hard sexual entertainment, bigotry, obscenity content or warez\\r\\n    programming joins.<br \\/><br \\/>You can\'t imitate, copy, duplicate, sell,\\r\\n    exchange or adventure any of our segment, utilization of the offered on our\\r\\n    things, or admittance to the administration without the express composed\\r\\n    consent by us or item proprietor.<br \\/><br \\/>Our Members are liable for all\\r\\n    substance posted on the discussion and demo and movement that happens under\\r\\n    your record.<br \\/><br \\/>We hold the chance of hindering your participation\\r\\n    account quickly if we will think about a particularly not allowed\\r\\n    conduct.<br \\/><br \\/>If you make a record on our site, you are liable for\\r\\n    keeping up the security of your record, and you are completely answerable\\r\\n    for all exercises that happen under the record and some other activities\\r\\n    taken regarding the record. You should quickly inform us, of any unapproved\\r\\n    employments of your record or some other penetrates of security\\r\\n  <\\/p>\\r\\n  <p><br \\/><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Payment\\/Refund Policy<\\/h5>\\r\\n  <p>\\r\\n    No refund or cash back will be made. After a deposit has been finished, it\\r\\n    is extremely unlikely to invert it. You should utilize your equilibrium on\\r\\n    requests our administrations, Hosting, SEO campaign. You concur that once\\r\\n    you complete a deposit, you won\'t document a debate or a chargeback against\\r\\n    us in any way, shape, or form.<br \\/><br \\/>If you document a debate or\\r\\n    chargeback against us after a deposit, we claim all authority to end every\\r\\n    single future request, prohibit you from our site. False action, for\\r\\n    example, utilizing unapproved or taken charge cards will prompt the end of\\r\\n    your record. There are no special cases.\\r\\n  <\\/p>\\r\\n  <p><br \\/><\\/p>\\r\\n<\\/div>\\r\\n<div>\\r\\n  <h5>Free Balance \\/ Coupon Policy<\\/h5>\\r\\n  <p>\\r\\n    We offer numerous approaches to get FREE Balance, Coupons and Deposit offers\\r\\n    yet we generally reserve the privilege to audit it and deduct it from your\\r\\n    record offset with any explanation we may it is a sort of misuse. If we\\r\\n    choose to deduct a few or all of free Balance from your record balance, and\\r\\n    your record balance becomes negative, at that point the record will\\r\\n    naturally be suspended. If your record is suspended because of a negative\\r\\n    Balance you can request to make a custom payment to settle your equilibrium\\r\\n    to actuate your record.\\r\\n  <\\/p>\\r\\n<\\/div>\"}',NULL,'basic','terms-of-service','2021-06-09 08:51:18','2024-04-08 01:03:48'),
(44,'maintenance.data','{\"description\":\"<div class=\\\"mb-5\\\" style=\\\"color: rgb(111, 111, 111); font-family: Nunito, sans-serif; margin-bottom: 3rem !important;\\\"><h3 class=\\\"mb-3\\\" style=\\\"font-weight: 600; line-height: 1.3; font-size: 24px; text-align: center; font-family: Exo, sans-serif;\\\"><font color=\\\"#ff0000\\\">THE SITE IS UNDER MAINTENANCE<\\/font><\\/h3><h3 class=\\\"mb-3\\\" style=\\\"text-align: center; font-weight: 600; line-height: 1.3; font-size: 24px; font-family: Exo, sans-serif; color: rgb(54, 54, 54);\\\"><p class=\\\"font-18\\\" style=\\\"margin-right: 0px; margin-left: 0px; color: rgb(111, 111, 111); font-family: Nunito, sans-serif; font-size: 18px !important;\\\"><span style=\\\"color: rgb(91, 110, 136); font-family: Poppins, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\\\">Our site is undergoing maintenance to provide you with an enhanced experience. We apologize for any inconvenience caused during this period. Rest assured, our team is working diligently to bring you a better platform. Thank you for your patience and understanding. We look forward to serving you better soon.<br><\\/span><\\/p><\\/h3><\\/div>\",\"image\":\"66443ac054e381715747520.png\"}',NULL,'basic',NULL,'2020-07-04 23:42:52','2024-05-14 22:35:34'),
(45,'about.element','{\"title\":\"Low & Stable Spreads\",\"subtitle\":\"Super competitive spreads with ultra fast execution speed\",\"has_image\":\"1\",\"image\":\"6613a586e3e0f1712563590.png\"}',NULL,'basic',NULL,'2024-03-16 02:16:53','2024-04-08 02:06:30'),
(46,'about.element','{\"title\":\"Fast Execution\",\"subtitle\":\"Never miss a pip. Get your orders executed in milliseconds.\",\"has_image\":\"1\",\"image\":\"6613a50a15f841712563466.png\"}',NULL,'basic',NULL,'2024-03-16 02:17:23','2024-04-08 02:04:26'),
(47,'about.element','{\"title\":\"Security of Funds\",\"subtitle\":\"Trade the commodity markets with negative balance protection\",\"has_image\":\"1\",\"image\":\"6613a4562d9e51712563286.png\"}',NULL,'basic',NULL,'2024-03-16 02:17:47','2024-04-08 02:01:26'),
(48,'how_trade.content','{\"heading\":\"How to Trade\",\"subheading\":\"Trade with trust & reliability across a range of commodity instruments including gold, silver, copper, oil, and coffee, enhancing your investment strategy\"}',NULL,'basic',NULL,'2024-03-16 02:26:37','2024-04-24 03:17:18'),
(49,'how_trade.element','{\"title\":\"Sign Up\",\"subtitle\":\"Start your journey by creating your free account\",\"has_image\":\"1\",\"image\":\"664ace0eed0b51716178446.png\"}',NULL,'basic','','2024-03-16 02:26:52','2024-05-19 22:14:06'),
(50,'how_trade.element','{\"title\":\"Verify Account\",\"subtitle\":\"Quickly verify your account including email, sms, KYC verification\",\"has_image\":\"1\",\"image\":\"664ace0579fa91716178437.png\"}',NULL,'basic','','2024-03-16 02:27:12','2024-05-19 22:13:57'),
(51,'how_trade.element','{\"title\":\"Buy \\/ Sale Commodities\",\"subtitle\":\"After your account verification, buy or sell your favorite commodities\",\"has_image\":\"1\",\"image\":\"664acdfd831a51716178429.png\"}',NULL,'basic','','2024-03-16 02:27:31','2024-05-19 22:13:49'),
(52,'how_trade.element','{\"title\":\"Win and Earn Money\",\"subtitle\":\"Earn money by sale or buying commodities on our platform within a short time\",\"has_image\":\"1\",\"image\":\"664acdf67ef731716178422.png\"}',NULL,'basic','','2024-03-16 02:27:51','2024-05-19 22:13:42'),
(53,'counter.element','{\"total_count\":\"12\",\"count_start\":\"2\",\"title\":\"Trillion\",\"subtitle\":\"Monthly Trading Volume\"}',NULL,'basic',NULL,'2024-03-16 02:32:34','2024-04-05 02:14:53'),
(54,'counter.element','{\"total_count\":\"2.5\",\"count_start\":\"0.5\",\"title\":\"Billion\",\"subtitle\":\"Trades Executed in 2024\"}',NULL,'basic',NULL,'2024-03-16 02:32:58','2024-04-05 02:12:35'),
(55,'counter.element','{\"total_count\":\"64000\",\"count_start\":\"60000\",\"title\":\"+\",\"subtitle\":\"Registered Partners\"}',NULL,'basic',NULL,'2024-03-16 02:33:32','2024-04-05 02:14:01'),
(56,'counter.element','{\"total_count\":\"4.6\",\"count_start\":\"2\",\"title\":\"+\",\"subtitle\":\"Trustpilot Rating\"}',NULL,'basic',NULL,'2024-03-16 02:34:13','2024-04-05 02:13:35'),
(57,'testimonial.content','{\"heading\":\"Don\'t take our words\",\"subheading\":\"From beginners to experts, True stories showing success in commodity trading - listen to our successful commodity traders\"}',NULL,'basic',NULL,'2024-03-16 02:41:16','2024-04-24 06:15:16'),
(58,'testimonial.element','{\"name\":\"Alixha Hales\",\"title\":\"@curtis\",\"comment\":\"Trading made easy! this platform is a must-try for commodities enthusiasts\",\"has_image\":\"1\",\"image\":\"6628f046687681713958982.png\"}',NULL,'basic',NULL,'2024-03-16 02:42:42','2024-04-24 05:43:02'),
(59,'testimonial.element','{\"name\":\"Jane Cooper\",\"title\":\"@curtis\",\"comment\":\"This platform exceeded my expectations, making commodities trading a smooth journey\",\"has_image\":\"1\",\"image\":\"6628efaeb2a201713958830.png\"}',NULL,'basic',NULL,'2024-03-16 02:43:17','2024-04-24 05:40:30'),
(60,'testimonial.element','{\"name\":\"Shane Smith\",\"title\":\"@curtis\",\"comment\":\"This platform has made commodities trading a breeze.\",\"has_image\":\"1\",\"image\":\"6628f09a5a4161713959066.png\"}',NULL,'basic',NULL,'2024-03-16 02:43:41','2024-04-24 05:44:26'),
(61,'testimonial.element','{\"name\":\"David Woe\",\"title\":\"@curtis\",\"comment\":\"This platform\'s simplicity and real-time updates are a game-changer\",\"has_image\":\"1\",\"image\":\"6628effc23d401713958908.png\"}',NULL,'basic',NULL,'2024-03-16 02:44:12','2024-04-24 05:41:48'),
(62,'faq.content','{\"heading\":\"Frequently Asked Questions\",\"subheading\":\"Answers to your burning questions, frequently asked questions (faq) - find the solutions to common queries and concern\"}',NULL,'basic',NULL,'2024-03-16 02:46:42','2024-04-24 06:15:33'),
(63,'faq.element','{\"question\":\"What is a commodities trade?\",\"answer\":\"A digital marketplace where traders buy and sell commodities like agricultural products, energy resources, and precious metals.\"}',NULL,'basic',NULL,'2024-03-16 02:47:43','2024-04-07 07:45:19'),
(64,'faq.element','{\"question\":\"What commodities can be traded?\",\"answer\":\"Agricultural products, energy resources, precious metals, base metals, and soft commodities.\"}',NULL,'basic',NULL,'2024-03-16 02:48:20','2024-04-07 07:44:07'),
(65,'faq.element','{\"question\":\"Is it regulated?\",\"answer\":\"Yes, reputable platforms are typically regulated to ensure transparency and security for traders.\"}',NULL,'basic',NULL,'2024-03-16 02:49:13','2024-04-07 07:44:18'),
(66,'faq.element','{\"question\":\"What are the benefits?\",\"answer\":\"Accessibility, liquidity, diverse options, and advanced trading tools.\"}',NULL,'basic',NULL,'2024-03-16 02:49:36','2024-04-07 07:44:26'),
(67,'faq.element','{\"question\":\"How secure is it?\",\"answer\":\"Platforms employ encryption, authentication, and regulatory oversight to secure user data and funds.\"}',NULL,'basic',NULL,'2024-03-16 02:49:48','2024-04-07 07:44:39'),
(68,'faq.element','{\"question\":\"Can I trade with leverage?\",\"answer\":\"Some platforms offer leverage, but it amplifies both profits and losses and should be used cautiously.\"}',NULL,'basic',NULL,'2024-03-16 02:50:07','2024-04-07 07:44:47'),
(74,'social_icon.element','{\"icon\":\"<i class=\\\"fab fa-twitter\\\"><\\/i>\",\"url\":\"https:\\/\\/www.twitter.com\"}',NULL,'basic',NULL,'2024-03-23 23:00:22','2024-03-23 23:09:57'),
(75,'social_icon.element','{\"icon\":\"<i class=\\\"fab fa-linkedin\\\"><\\/i>\",\"url\":\"https:\\/\\/www.linkedin.com\"}',NULL,'basic',NULL,'2024-03-23 23:00:54','2024-03-23 23:10:09'),
(76,'social_icon.element','{\"icon\":\"<i class=\\\"fab fa-pinterest\\\"><\\/i>\",\"url\":\"https:\\/\\/www.pinterest.com\"}',NULL,'basic',NULL,'2024-03-23 23:01:45','2024-03-23 23:10:21'),
(79,'contact_us.element','{\"title\":\"Send Us an Email\",\"subtitle\":\"Reach out support@viserlab.com and we\'ll get back to you in 24 hours.\",\"icon\":\"<i class=\\\"las la-envelope\\\"><\\/i>\"}',NULL,'basic',NULL,'2024-04-01 05:42:09','2024-04-05 02:46:31'),
(80,'contact_us.element','{\"title\":\"Give Us a Call\",\"subtitle\":\"In need of more assistance? Give us a call at +09658-2549836\",\"icon\":\"<i class=\\\"las la-phone\\\"><\\/i>\"}',NULL,'basic',NULL,'2024-04-01 05:42:32','2024-04-05 02:46:43'),
(81,'contact_us.element','{\"title\":\"We Are Located At\",\"subtitle\":\"Suite 145 93949 Heidenreich Square, Port Dulce, AR 08059-7854, United States\",\"icon\":\"<i class=\\\"las la-map-marker\\\"><\\/i>\"}',NULL,'basic',NULL,'2024-04-01 05:43:02','2024-04-05 02:46:58'),
(82,'footer.content','{\"short_details\":\"The company had consecutive increases in its net income throughout the entirety of 2023, from last record showing an increase of 8%  per year.\"}',NULL,'basic',NULL,'2024-04-02 05:03:25','2024-04-03 03:31:27'),
(83,'policy_pages.element','{\"title\":\"Trading Policy\",\"details\":\"<p>This trading policy outlines the rules and guidelines for users of the commodity trading platform to ensure fair, transparent, and efficient trading practices. The policy aims to protect the integrity of the platform and promote a level playing field for all participants.<\\/p><p><br \\/><\\/p>\\r\\n\\r\\n<h5>Eligibility<\\/h5>\\r\\n<p>a. Users must meet the eligibility criteria as outlined in the platform\'s terms of service to participate in trading activities.<\\/p>\\r\\n<p>b. Users must provide accurate and up-to-date information during the registration process.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Compliance<\\/h5>\\r\\n<p>a. Users must comply with all applicable laws and regulations governing commodity trading in their respective jurisdictions.<\\/p>\\r\\n<p>b. Any attempt to manipulate or disrupt the market, including but not limited to price manipulation, spoofing, or insider trading, will result in immediate account suspension and potential legal action.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Risk Management<\\/h5>\\r\\n<p>a. Users are responsible for managing their own risk exposure and are encouraged to conduct thorough research before engaging in trading activities.<\\/p>\\r\\n<p>b. The platform may impose position limits or margin requirements to mitigate risk and ensure market stability.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Order Execution<\\/h5>\\r\\n<p>a. Orders must be placed in accordance with the platform\'s trading protocols and procedures.<\\/p>\\r\\n<p>b. The platform will execute orders based on a fair and transparent matching algorithm to ensure equitable treatment for all participants.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Market Integrity<\\/h5>\\r\\n<p>a. Users must refrain from engaging in any activity that could compromise the integrity of the market, including spreading false information or engaging in deceptive trading practices.<\\/p>\\r\\n<p>b. Suspicious or fraudulent activities will be thoroughly investigated, and appropriate action will be taken, including account termination and reporting to relevant authorities.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Confidentiality<\\/h5>\\r\\n<p>a. Users must respect the confidentiality of their trading activities and refrain from disclosing sensitive information to unauthorized parties.<\\/p>\\r\\n<p>b. The platform will implement robust security measures to protect users\' personal and financial data from unauthorized access or disclosure.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Dispute Resolution<\\/h5>\\r\\n<p>a. In the event of a dispute between users or between a user and the platform, parties are encouraged to resolve the issue amicably through negotiation or mediation.<\\/p>\\r\\n<p>b. If a resolution cannot be reached, the platform will facilitate arbitration or legal proceedings as per the terms outlined in the platform\'s dispute resolution policy.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Amendments<\\/h5>\\r\\n<p>a. The platform reserves the right to amend or update this trading policy as necessary to reflect changes in market conditions or regulatory requirements.<\\/p>\\r\\n<p>b. Users will be notified of any changes to the trading policy, and continued use of the platform will constitute acceptance of the revised terms.<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h5>Conclusion<\\/h5>\\r\\n<p>This trading policy serves as a guideline for users of the commodity trading platform and is designed to promote fair, transparent, and efficient trading practices. By adhering to these principles, users can contribute to the integrity and stability of the platform\'s marketplace.<\\/p>\"}',NULL,'basic','trading-policy','2024-04-02 05:38:53','2024-04-08 01:07:50'),
(84,'authentication.content','{\"login_page_title\":\"Welcome to Viserlab\",\"login_page_subtitle\":\"Start trading with incredible features. Trade like a Super Trader!\",\"register_page_title\":\"Welcome to Viserlab\",\"register_page_subtitle\":\"Start trading with incredible features. Trade like a Super Trader!\",\"login_page_heading\":\"Trading & Investing in Commodity\",\"register_page_heading\":\"Trading & Investing in Commodity\",\"has_image\":\"1\",\"login_image\":\"660d1e52add531712135762.png\",\"register_image\":\"660d1e532ef9b1712135763.png\"}',NULL,'basic',NULL,'2024-04-03 03:16:02','2024-04-03 03:16:03'),
(86,'login.content','{\"heading\":\"Welcome Back\",\"subheading\":\"We missed you and are excited to have you here again\",\"has_image\":\"1\",\"image\":\"6612769351e0c1712486035.png\"}',NULL,'basic',NULL,'2024-04-06 07:20:37','2024-04-07 04:33:55'),
(87,'register.content','{\"heading\":\"Register Now\",\"subheading\":\"Take the first step and unlock endless possibilities\",\"has_image\":\"1\",\"image\":\"66127683948c71712486019.png\"}',NULL,'basic',NULL,'2024-04-06 07:20:56','2024-04-07 04:33:40'),
(88,'about.element','{\"title\":\"Excellent Community\",\"subtitle\":\"There is an active team behind us, and we adore communicating with our users\",\"has_image\":\"1\",\"image\":\"6613a421d8f631712563233.png\"}',NULL,'basic',NULL,'2024-04-07 04:59:33','2024-04-08 02:00:33'),
(90,'blog.element','{\"has_image\":[\"1\"],\"title\":\"Evolution of Commodity Trading\",\"description\":\"<p>\\r\\nIn the intricate tapestry of commerce, the trading of commodities stands as a cornerstone of human interaction. Our blog, \\\"Evolution of Commodity Trading,\\\" embarks on a captivating journey through time, exploring the metamorphosis of this age-old practice from its humble beginnings to its modern-day manifestations.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Ancient Bartering: The Foundation of Trade<\\/h4>\\r\\n<p>\\r\\nStep back in time to the origins of commerce, where civilizations engaged in the ancient art of bartering. From Mesopotamia to the Indus Valley, discover how early societies exchanged goods such as grains, spices, and livestock to satisfy their needs and desires.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Emergence of Organized Markets: A Catalyst for Growth<\\/h4>\\r\\n<p>\\r\\nEnter the bustling marketplaces of antiquity, where the exchange of commodities became more structured and organized. Explore the role of market towns and trading posts in facilitating commerce, as well as the development of standardized units of measurement to streamline transactions.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Medieval Trading: From Silk Roads to Spice Routes<\\/h4>\\r\\n<p>\\r\\nJourney through the medieval era, a period of unprecedented exploration and trade expansion. Follow the footsteps of merchants along the legendary Silk Road and Spice Routes, where commodities like silk, spices, and precious metals traversed continents, enriching cultures and economies along the way.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Rise of Digital Exchanges: A New Frontier in Trading<\\/h4>\\r\\n<p>\\r\\nFast forward to the 21st century, where technology has revolutionized the way commodities are bought and sold. pe into the world of digital exchanges, where investors can trade a vast array of commodities with unprecedented speed, efficiency, and transparency.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Navigating Challenges: Risks and Opportunities in Modern Trading<\\/h4>\\r\\n<p>\\r\\nHowever, with progress comes challenges. Explore the complexities of modern commodity trading, from market volatility and regulatory scrutiny to geopolitical tensions and environmental concerns. Learn how traders navigate these obstacles to seize opportunities and mitigate risks in an ever-changing landscape.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us on a captivating exploration of the Evolution of Commodity Trading, as we unravel the threads of history and innovation that have shaped this timeless practice. Whether you\'re a seasoned trader or a curious observer, discover the rich tapestry of human ingenuity and enterprise that continues to drive commerce forward in the digital age.<\\/p>\",\"blog_image\":\"664b0cac3428d1716194476.png\"}',NULL,'basic','evolution-of-commodity-trading','2024-04-08 00:36:34','2024-05-20 02:41:16'),
(91,'blog.element','{\"has_image\":[\"1\"],\"title\":\"Advantages of Commodity Trading Platforms\",\"description\":\"<p>\\r\\n  In today\'s dynamic financial landscape, commodity trading platforms have\\r\\n  emerged as powerful tools for investors and traders alike. Our blog,\\r\\n  \\\"Advantages of Commodity Trading Platforms,\\\" explores the myriad benefits\\r\\n  these platforms offer in navigating the complexities of commodity markets and\\r\\n  seizing lucrative opportunities.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Streamlined Access to Global Markets<\\/h4>\\r\\n<p>\\r\\n  Commodity trading platforms provide investors with seamless access to a wide\\r\\n  range of global markets, allowing them to trade commodities such as oil, gold,\\r\\n  agricultural products, and more from anywhere in the world. With just a few\\r\\n  clicks, traders can capitalize on market movements and persify their\\r\\n  portfolios with ease.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Real-Time Market Data and Insights<\\/h4>\\r\\n<p>\\r\\n  One of the key advantages of commodity trading platforms is the access to\\r\\n  real-time market data and insights. These platforms offer comprehensive\\r\\n  analytics, charts, and news feeds, empowering traders to make informed\\r\\n  decisions and stay ahead of market trends. Whether it\'s tracking price\\r\\n  movements, monitoring supply and demand dynamics, or analyzing technical\\r\\n  indicators, traders have access to the information they need to execute\\r\\n  successful trades.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Advanced Trading Tools and Features<\\/h4>\\r\\n<p>\\r\\n  Commodity trading platforms come equipped with a plethora of advanced trading\\r\\n  tools and features designed to enhance trading efficiency and effectiveness.\\r\\n  From customizable trading dashboards to sophisticated order types and risk\\r\\n  management tools, these platforms empower traders to execute complex trading\\r\\n  strategies with precision and confidence.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Reduced Costs and Fees<\\/h4>\\r\\n<p>\\r\\n  Commodity trading platforms often offer competitive pricing structures and\\r\\n  lower transaction costs compared to traditional brokerage services. With\\r\\n  reduced fees and commissions, traders can maximize their profits and optimize\\r\\n  their trading performance over the long term.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Enhanced Security and Reliability<\\/h4>\\r\\n<p>\\r\\n  Security is paramount in the world of online trading, and commodity trading\\r\\n  platforms prioritize the protection of user funds and sensitive information.\\r\\n  With robust encryption protocols, multi-factor authentication, and secure\\r\\n  payment gateways, these platforms offer peace of mind to traders, ensuring\\r\\n  their assets are safe and transactions are executed with utmost reliability.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Accessible Education and Training Resources<\\/h4>\\r\\n<p>\\r\\n  Moreover, commodity trading platforms often provide access to educational\\r\\n  resources and training materials to help traders improve their skills and\\r\\n  knowledge. From beginner\'s guides and tutorials to advanced trading courses\\r\\n  and webinars, these platforms empower traders of all levels to sharpen their\\r\\n  trading acumen and achieve their financial goals.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us as we delve into the Advantages of Commodity Trading Platforms,\\r\\n    exploring how these innovative tools are reshaping the landscape of commodity\\r\\n    trading and empowering traders to succeed in today\'s dynamic markets.<\\/p>\",\"blog_image\":\"664b0b4b64d9a1716194123.png\"}',NULL,'basic','advantages-of-commodity-trading-platforms','2024-04-08 00:36:51','2024-05-20 02:35:23'),
(92,'blog.element','{\"has_image\":[\"1\"],\"title\":\"Risk Management Strategies in Commodity Trading\",\"description\":\"<p>\\r\\nIn the volatile world of commodity trading, effective risk management is essential for preserving capital and maximizing returns. Our blog, \\\"Risk Management Strategies in Commodity Trading,\\\" delves into the various techniques and approaches traders employ to mitigate risks and navigate uncertain market conditions.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>persification of Portfolio<\\/h4>\\r\\n<p>\\r\\nOne of the fundamental principles of risk management in commodity trading is portfolio persification. By spreading investments across different commodities, sectors, and geographic regions, traders can reduce the impact of adverse price movements in any single asset and protect their overall portfolio from excessive risk.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Utilization of Hedging Instruments<\\/h4>\\r\\n<p>\\r\\nHedging is another common risk management strategy used by commodity traders to protect against adverse price fluctuations. By entering into derivative contracts such as futures and options, traders can lock in prices for future delivery, thereby mitigating the impact of market volatility and ensuring price stability for their commodities.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Setting Stop-Loss Orders<\\/h4>\\r\\n<p>\\r\\nStop-loss orders are a vital tool in a commodity trader\'s risk management arsenal. These orders automatically trigger a sell order when a commodity\'s price reaches a predetermined level, helping traders limit potential losses and protect their capital in the event of unfavorable market movements.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Implementing Position Sizing Strategies<\\/h4>\\r\\n<p>\\r\\nPosition sizing is another critical aspect of risk management in commodity trading. By carefully determining the size of each position relative to the total capital at risk, traders can ensure that no single trade has the potential to significantly impact their overall portfolio. This helps prevent catastrophic losses and promotes long-term sustainability.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Continuous Monitoring and Evaluation<\\/h4>\\r\\n<p>\\r\\nRisk management is an ongoing process that requires constant vigilance and adaptation to changing market conditions. Commodity traders must continuously monitor their positions, assess their risk exposure, and adjust their strategies accordingly to maintain a balanced and resilient portfolio.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Adherence to Trading Discipline<\\/h4>\\r\\n<p>\\r\\nDiscipline is key to effective risk management in commodity trading. Traders must adhere to their predefined risk management rules and avoid succumbing to emotional impulses or irrational decisions. By maintaining discipline and sticking to their trading plan, traders can minimize the likelihood of impulsive actions that could lead to costly mistakes.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us as we explore the intricacies of Risk Management Strategies in Commodity Trading, uncovering the techniques and best practices that enable traders to navigate the challenges of the commodity markets with confidence and resilience.<\\/p>\",\"blog_image\":\"664b0ccce0ee71716194508.png\"}',NULL,'basic','risk-management-strategies-in-commodity-trading','2024-04-08 00:37:03','2024-05-20 02:41:49'),
(93,'blog.element','{\"has_image\":[\"1\"],\"title\":\"Promoting Sustainability in Commodity Markets\",\"description\":\"<p>\\r\\nIn an era where environmental and social responsibility are paramount, promoting sustainability in commodity markets has become a pressing imperative. Our blog, \\\"Promoting Sustainability in Commodity Markets,\\\" examines the role of traders, investors, and market participants in fostering sustainable practices that balance economic growth with environmental stewardship and social equity.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Integration of Environmental, Social, and Governance (ESG) Factors<\\/h4>\\r\\n<p>\\r\\nA cornerstone of promoting sustainability in commodity markets is the integration of Environmental, Social, and Governance (ESG) factors into investment decisions and trading strategies. By considering criteria such as carbon emissions, resource usage, labor practices, and corporate governance, traders can identify sustainable investment opportunities and drive positive change within the commodity industry.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Support for Sustainable Supply Chains<\\/h4>\\r\\n<p>\\r\\nTraders and investors play a pivotal role in promoting sustainability throughout commodity supply chains. By engaging with suppliers, producers, and other stakeholders, traders can encourage the adoption of environmentally friendly practices, ethical labor standards, and fair trade principles, thereby fostering a more sustainable and socially responsible supply chain ecosystem.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Investment in Renewable and Eco-Friendly Commodities<\\/h4>\\r\\n<p>\\r\\nAnother avenue for promoting sustainability in commodity markets is through investment in renewable and eco-friendly commodities. From renewable energy sources such as solar and wind power to sustainable agriculture and forestry products, traders can support industries that prioritize environmental conservation and mitigate the impact of climate change.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Advocacy for Regulatory and Policy Reforms<\\/h4>\\r\\n<p>\\r\\nTraders and market participants can also advocate for regulatory and policy reforms that promote sustainability in commodity markets. By engaging with policymakers, industry associations, and regulatory bodies, traders can influence the development of frameworks and standards that incentivize sustainable practices, enhance transparency, and mitigate environmental and social risks.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Transparency and Disclosure of ESG Metrics<\\/h4>\\r\\n<p>\\r\\nTransparency and disclosure of Environmental, Social, and Governance (ESG) metrics are essential for promoting sustainability in commodity markets. Traders can encourage companies to report on their sustainability performance and disclose relevant ESG information to investors and stakeholders, enabling informed decision-making and accountability.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Collaboration and Knowledge Sharing<\\/h4>\\r\\n<p>\\r\\nPromoting sustainability in commodity markets requires collaboration and knowledge sharing among traders, investors, industry stakeholders, and civil society organizations. By sharing best practices, experiences, and innovations, market participants can collectively drive positive change and create a more sustainable and resilient commodity market ecosystem.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us as we delve into the imperative of Promoting Sustainability in Commodity Markets, exploring the strategies and initiatives that empower traders and investors to drive positive environmental, social, and economic outcomes in the global commodity markets.<\\/p>\",\"blog_image\":\"664b0cf34f5ac1716194547.png\"}',NULL,'basic','promoting-sustainability-in-commodity-markets','2024-04-08 00:37:15','2024-05-20 02:42:27'),
(94,'blog.element','{\"has_image\":[\"1\"],\"title\":\"The Future of Commodity Trading\",\"description\":\"<p>\\r\\nIn an era of rapid technological advancement and global interconnectedness, the future of commodity trading holds both promise and uncertainty. Our blog, \\\"The Future of Commodity Trading,\\\" peers into the crystal ball of innovation and disruption to forecast the trends and transformations that will shape the commodity markets of tomorrow.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Digitalization and Automation<\\/h4>\\r\\n<p>\\r\\nDigitalization and automation are poised to revolutionize commodity trading in the years ahead. From algorithmic trading and artificial intelligence to blockchain technology and smart contracts, traders can expect increased efficiency, transparency, and scalability in their operations, leading to reduced costs and enhanced market liquidity.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Rise of Sustainable and Ethical Trading<\\/h4>\\r\\n<p>\\r\\nAs environmental and social concerns take center stage, the future of commodity trading will witness a growing emphasis on sustainability and ethical practices. Traders and investors will prioritize investments in renewable energy, eco-friendly commodities, and socially responsible supply chains, driving positive change and promoting a more sustainable future.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Integration of Big Data and Analytics<\\/h4>\\r\\n<p>\\r\\nBig data and analytics will play an increasingly pivotal role in shaping the future of commodity trading. By harnessing vast amounts of data from perse sources, traders can gain deeper insights into market trends, supply chain dynamics, and consumer behavior, enabling more informed decision-making and predictive analysis.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Shift Towards Decentralized Exchanges<\\/h4>\\r\\n<p>\\r\\nThe rise of decentralized finance (DeFi) and blockchain technology is likely to spur a shift towards decentralized exchanges in commodity trading. These peer-to-peer platforms offer greater autonomy, security, and transparency, empowering traders to engage in direct transactions without intermediaries and traditional financial institutions.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Adaptation to Regulatory and Geopolitical Changes<\\/h4>\\r\\n<p>\\r\\nCommodity traders will need to adapt to evolving regulatory frameworks and geopolitical dynamics in the future. From climate-related regulations and trade policies to geopolitical tensions and supply chain disruptions, traders must stay agile and resilient in navigating the complexities of the global commodity markets.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Embrace of Green and Sustainable Finance<\\/h4>\\r\\n<p>\\r\\nThe future of commodity trading will witness a broader embrace of green and sustainable finance initiatives. Traders and investors will seek opportunities to support environmentally friendly projects, mitigate climate risks, and align their investments with the goals of sustainability and responsible stewardship of natural resources.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us as we peer into \\\"The Future of Commodity Trading,\\\" exploring the exciting opportunities and challenges that lie ahead and charting a course towards a more innovative, sustainable, and resilient commodity market ecosystem.<\\/p>\",\"blog_image\":\"664b0ce1b3d821716194529.png\"}',NULL,'basic','the-future-of-commodity-trading','2024-04-08 00:37:29','2024-05-20 02:42:10'),
(95,'blog.element','{\"has_image\":[\"1\"],\"title\":\"Globalization and Commodity Trading\",\"description\":\"<p>\\r\\nIn an increasingly interconnected world, globalization has transformed the landscape of commodity trading, reshaping markets, supply chains, and economic dynamics on a global scale. Our blog, \\\"Globalization and Commodity Trading,\\\" delves into the profound impact of globalization on commodity markets and explores the opportunities and challenges it presents for traders and investors.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Expansion of Market Access and Opportunities<\\/h4>\\r\\n<p>\\r\\nGlobalization has led to the expansion of market access and opportunities for commodity traders worldwide. With advancements in transportation, communication, and trade agreements, traders can tap into a perse array of markets and commodities, enabling greater persification and potential for profit.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Integration of Supply Chains and Logistics<\\/h4>\\r\\n<p>\\r\\nOne of the hallmarks of globalization in commodity trading is the integration of supply chains and logistics on a global scale. From raw material sourcing to manufacturing and distribution, supply chains have become increasingly interconnected and reliant on efficient logistics networks, facilitating the seamless flow of commodities across borders and continents.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Impact of Economic and Political Factors<\\/h4>\\r\\n<p>\\r\\nGlobalization exposes commodity markets to a myriad of economic and political factors that can influence supply, demand, and prices. Economic trends, currency fluctuations, geopolitical tensions, and trade policies all play a significant role in shaping commodity market dynamics, requiring traders to stay vigilant and adapt to changing conditions.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Environmental and Social Considerations<\\/h4>\\r\\n<p>\\r\\nGlobalization has also brought greater attention to environmental and social considerations in commodity trading. Traders and investors are increasingly mindful of issues such as sustainability, ethical sourcing, and corporate social responsibility, driving demand for commodities produced in accordance with responsible practices and standards.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Emergence of Cross-Border Regulations<\\/h4>\\r\\n<p>\\r\\nAs commodity trading becomes more globalized, regulators are increasingly focusing on cross-border regulations to ensure market integrity, transparency, and fair competition. Traders must navigate a complex web of regulatory frameworks, compliance requirements, and reporting standards across different jurisdictions to maintain regulatory compliance and mitigate legal risks.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<h4>Opportunities for Innovation and Collaboration<\\/h4>\\r\\n<p>\\r\\nDespite the challenges, globalization presents opportunities for innovation and collaboration in commodity trading. Traders can leverage technology, data analytics, and strategic partnerships to gain a competitive edge, unlock new markets, and address emerging trends and consumer preferences on a global scale.\\r\\n<\\/p>\\r\\n<br \\/>\\r\\n\\r\\n<p>Join us as we explore the profound impact of \\\"Globalization and Commodity Trading,\\\" shedding light on the opportunities and challenges inherent in navigating the interconnected and dynamic global commodity market landscape.<\\/p>\",\"blog_image\":\"664b0bc2cc8dc1716194242.png\"}',NULL,'basic','globalization-and-commodity-trading','2024-04-08 00:37:37','2024-05-20 02:37:23'),
(96,'seo.data','{\"seo_image\":\"1\",\"keywords\":[\"tradiing\",\"trading platform\",\"commodity trading\",\"commodity buy\",\"commodity sell\",\"gold sell\",\"gold buy\",\"oil sell\",\"oil buy\"],\"description\":\"ViserTrade makes building a stock market trading system super easy. No more coding headaches! With ViserTrade, you can create your own custom trading system in short time.\",\"social_title\":\"ViserTrade - Stock Market Trading System\",\"social_description\":\"ViserTrade makes building a stock market trading system super easy. No more coding headaches! With ViserTrade, you can create your own custom trading system in short time.\",\"image\":\"6613cf4190dcc1712574273.jpg\"}',NULL,NULL,NULL,'2024-04-08 05:04:20','2024-04-08 05:06:39'),
(97,'commodity.content','{\"heading\":\"Explore Our Commodity\",\"subheading\":\"Discover a vast selection of high-quality goods at competitive prices across a wide range of categories and industries\"}',NULL,'basic',NULL,'2024-04-24 06:26:17','2024-04-24 06:30:28'),
(98,'register_disable.content','{\"has_image\":\"1\",\"heading\":\"Registration Currently Disabled\",\"subheading\":\"Registration process is temporarily unavailable. We apologize for any inconvenience and assure you that we\'re working diligently to restore it promptly.\",\"button_name\":\"Go To Home\",\"button_url\":\"#\",\"image\":\"663a0f20ecd0b1715080992.png\"}',NULL,'basic',NULL,NULL,NULL),
(99,'kyc.content','{\"required\":\"Complete KYC to unlock the full potential of our platform! KYC helps us verify your identity and keep things secure. It is quick and easy just follow the on-screen instructions. Get started with KYC verification now!\",\"pending\":\"Your KYC verification is being reviewed. We might need some additional information. You will get an email update soon. In the meantime, explore our platform with limited features.\",\"reject\":\"We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards.\"}',NULL,'basic','','2024-05-14 07:08:15','2024-05-14 07:08:15');

--
-- Table structure for table `gateway_currencies`
--

CREATE TABLE `gateway_currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `currency` varchar(40) DEFAULT NULL,
  `symbol` varchar(40) DEFAULT NULL,
  `method_code` int(11) DEFAULT NULL,
  `gateway_alias` varchar(40) DEFAULT NULL,
  `min_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `max_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `percent_charge` decimal(5,2) NOT NULL DEFAULT 0.00,
  `fixed_charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `gateway_parameter` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gateway_currencies`
--


--
-- Table structure for table `gateways`
--

CREATE TABLE `gateways` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(10) unsigned NOT NULL DEFAULT 0,
  `code` int(11) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `alias` varchar(40) NOT NULL DEFAULT 'NULL',
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=>enable, 2=>disable',
  `gateway_parameters` text DEFAULT NULL,
  `supported_currencies` text DEFAULT NULL,
  `crypto` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: fiat currency, 1: crypto currency',
  `extra` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gateways`
--

INSERT INTO `gateways` VALUES
(1,0,101,'Paypal','Paypal','66437b632713b1715698531.png',1,'{\"paypal_email\":{\"title\":\"PayPal Email\",\"global\":true,\"value\":\"sb-owud61543012@business.example.com\"}}','{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:55:31'),
(2,0,102,'Perfect Money','PerfectMoney','66437b1d30b3d1715698461.png',1,'{\"passphrase\":{\"title\":\"ALTERNATE PASSPHRASE\",\"global\":true,\"value\":\"hR26aw02Q1eEeUPSIfuwNypXX\"},\"wallet_id\":{\"title\":\"PM Wallet\",\"global\":false,\"value\":\"\"}}','{\"USD\":\"$\",\"EUR\":\"\\u20ac\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:54:21'),
(3,0,103,'Stripe Hosted','Stripe','663a39861cb9d1715091846.png',1,'{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"}}','{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-07 08:24:06'),
(4,0,104,'Skrill','Skrill','663a39494c4a91715091785.png',1,'{\"pay_to_email\":{\"title\":\"Skrill Email\",\"global\":true,\"value\":\"merchant@skrill.com\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"---\"}}','{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"MAD\":\"MAD\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"SAR\":\"SAR\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TND\":\"TND\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\",\"COP\":\"COP\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-07 08:23:05'),
(5,0,105,'PayTM','Paytm','66437b0fba6601715698447.png',1,'{\"MID\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"DIY12386817555501617\"},\"merchant_key\":{\"title\":\"Merchant Key\",\"global\":true,\"value\":\"bKMfNxPPf_QdZppa\"},\"WEBSITE\":{\"title\":\"Paytm Website\",\"global\":true,\"value\":\"DIYtestingweb\"},\"INDUSTRY_TYPE_ID\":{\"title\":\"Industry Type\",\"global\":true,\"value\":\"Retail\"},\"CHANNEL_ID\":{\"title\":\"CHANNEL ID\",\"global\":true,\"value\":\"WEB\"},\"transaction_url\":{\"title\":\"Transaction URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/oltp-web\\/processTransaction\"},\"transaction_status_url\":{\"title\":\"Transaction STATUS URL\",\"global\":true,\"value\":\"https:\\/\\/pguat.paytm.com\\/paytmchecksum\\/paytmCallback.jsp\"}}','{\"AUD\":\"AUD\",\"ARS\":\"ARS\",\"BDT\":\"BDT\",\"BRL\":\"BRL\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"GEL\":\"GEL\",\"GHS\":\"GHS\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"NGN\":\"NGN\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"UGX\":\"UGX\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"GBP\":\"GBP\",\"USD\":\"USD\",\"VND\":\"VND\",\"XOF\":\"XOF\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:54:07'),
(6,0,106,'Payeer','Payeer','66437ada943af1715698394.png',1,'{\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"866989763\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"7575\"}}','{\"USD\":\"USD\",\"EUR\":\"EUR\",\"RUB\":\"RUB\"}',0,'{\"status\":{\"title\": \"Status URL\",\"value\":\"ipn.Payeer\"}}',NULL,'2019-09-14 13:14:22','2024-05-14 08:53:14'),
(7,0,107,'PayStack','Paystack','66437b012be7f1715698433.png',1,'{\"public_key\":{\"title\":\"Public key\",\"global\":true,\"value\":\"pk_test_cd330608eb47970889bca397ced55c1dd5ad3783\"},\"secret_key\":{\"title\":\"Secret key\",\"global\":true,\"value\":\"sk_test_8a0b1f199362d7acc9c390bff72c4e81f74e2ac3\"}}','{\"USD\":\"USD\",\"NGN\":\"NGN\"}',0,'{\"callback\":{\"title\": \"Callback URL\",\"value\":\"ipn.Paystack\"},\"webhook\":{\"title\": \"Webhook URL\",\"value\":\"ipn.Paystack\"}}\r\n',NULL,'2019-09-14 13:14:22','2024-05-14 08:53:53'),
(9,0,109,'Flutterwave','Flutterwave','66437a4e0cca31715698254.png',1,'{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"----------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------------------\"},\"encryption_key\":{\"title\":\"Encryption Key\",\"global\":true,\"value\":\"------------------\"}}','{\"BIF\":\"BIF\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CVE\":\"CVE\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"GHS\":\"GHS\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"KES\":\"KES\",\"LRD\":\"LRD\",\"MWK\":\"MWK\",\"MZN\":\"MZN\",\"NGN\":\"NGN\",\"RWF\":\"RWF\",\"SLL\":\"SLL\",\"STD\":\"STD\",\"TZS\":\"TZS\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"XAF\":\"XAF\",\"XOF\":\"XOF\",\"ZMK\":\"ZMK\",\"ZMW\":\"ZMW\",\"ZWD\":\"ZWD\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:50:54'),
(10,0,110,'RazorPay','Razorpay','66437b2a85d251715698474.png',1,'{\"key_id\":{\"title\":\"Key Id\",\"global\":true,\"value\":\"rzp_test_kiOtejPbRZU90E\"},\"key_secret\":{\"title\":\"Key Secret \",\"global\":true,\"value\":\"osRDebzEqbsE1kbyQJ4y0re7\"}}','{\"INR\":\"INR\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:54:34'),
(11,0,111,'Stripe Storefront','StripeJs','663a3995417171715091861.png',1,'{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"}}','{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-07 08:24:21'),
(12,0,112,'Instamojo','Instamojo','66437a7c8c0ff1715698300.png',1,'{\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"test_2241633c3bc44a3de84a3b33969\"},\"auth_token\":{\"title\":\"Auth Token\",\"global\":true,\"value\":\"test_279f083f7bebefd35217feef22d\"},\"salt\":{\"title\":\"Salt\",\"global\":true,\"value\":\"19d38908eeff4f58b2ddda2c6d86ca25\"}}','{\"INR\":\"INR\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:51:40'),
(13,0,501,'Blockchain','Blockchain','664379d21a8851715698130.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"55529946-05ca-48ff-8710-f279d86b1cc5\"},\"xpub_code\":{\"title\":\"XPUB CODE\",\"global\":true,\"value\":\"xpub6CKQ3xxWyBoFAF83izZCSFUorptEU9AF8TezhtWeMU5oefjX3sFSBw62Lr9iHXPkXmDQJJiHZeTRtD9Vzt8grAYRhvbz4nEvBu3QKELVzFK\"}}','{\"BTC\":\"BTC\"}',1,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:48:50'),
(15,0,503,'CoinPayments','Coinpayments','66437a320aaf11715698226.png',1,'{\"public_key\":{\"title\":\"Public Key\",\"global\":true,\"value\":\"---------------------\"},\"private_key\":{\"title\":\"Private Key\",\"global\":true,\"value\":\"---------------------\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"---------------------\"}}','{\"BTC\":\"Bitcoin\",\"BTC.LN\":\"Bitcoin (Lightning Network)\",\"LTC\":\"Litecoin\",\"CPS\":\"CPS Coin\",\"VLX\":\"Velas\",\"APL\":\"Apollo\",\"AYA\":\"Aryacoin\",\"BAD\":\"Badcoin\",\"BCD\":\"Bitcoin Diamond\",\"BCH\":\"Bitcoin Cash\",\"BCN\":\"Bytecoin\",\"BEAM\":\"BEAM\",\"BITB\":\"Bean Cash\",\"BLK\":\"BlackCoin\",\"BSV\":\"Bitcoin SV\",\"BTAD\":\"Bitcoin Adult\",\"BTG\":\"Bitcoin Gold\",\"BTT\":\"BitTorrent\",\"CLOAK\":\"CloakCoin\",\"CLUB\":\"ClubCoin\",\"CRW\":\"Crown\",\"CRYP\":\"CrypticCoin\",\"CRYT\":\"CryTrExCoin\",\"CURE\":\"CureCoin\",\"DASH\":\"DASH\",\"DCR\":\"Decred\",\"DEV\":\"DeviantCoin\",\"DGB\":\"DigiByte\",\"DOGE\":\"Dogecoin\",\"EBST\":\"eBoost\",\"EOS\":\"EOS\",\"ETC\":\"Ether Classic\",\"ETH\":\"Ethereum\",\"ETN\":\"Electroneum\",\"EUNO\":\"EUNO\",\"EXP\":\"EXP\",\"Expanse\":\"Expanse\",\"FLASH\":\"FLASH\",\"GAME\":\"GameCredits\",\"GLC\":\"Goldcoin\",\"GRS\":\"Groestlcoin\",\"KMD\":\"Komodo\",\"LOKI\":\"LOKI\",\"LSK\":\"LSK\",\"MAID\":\"MaidSafeCoin\",\"MUE\":\"MonetaryUnit\",\"NAV\":\"NAV Coin\",\"NEO\":\"NEO\",\"NMC\":\"Namecoin\",\"NVST\":\"NVO Token\",\"NXT\":\"NXT\",\"OMNI\":\"OMNI\",\"PINK\":\"PinkCoin\",\"PIVX\":\"PIVX\",\"POT\":\"PotCoin\",\"PPC\":\"Peercoin\",\"PROC\":\"ProCurrency\",\"PURA\":\"PURA\",\"QTUM\":\"QTUM\",\"RES\":\"Resistance\",\"RVN\":\"Ravencoin\",\"RVR\":\"RevolutionVR\",\"SBD\":\"Steem Dollars\",\"SMART\":\"SmartCash\",\"SOXAX\":\"SOXAX\",\"STEEM\":\"STEEM\",\"STRAT\":\"STRAT\",\"SYS\":\"Syscoin\",\"TPAY\":\"TokenPay\",\"TRIGGERS\":\"Triggers\",\"TRX\":\" TRON\",\"UBQ\":\"Ubiq\",\"UNIT\":\"UniversalCurrency\",\"USDT\":\"Tether USD (Omni Layer)\",\"USDT.BEP20\":\"Tether USD (BSC Chain)\",\"USDT.ERC20\":\"Tether USD (ERC20)\",\"USDT.TRC20\":\"Tether USD (Tron/TRC20)\",\"VTC\":\"Vertcoin\",\"WAVES\":\"Waves\",\"XCP\":\"Counterparty\",\"XEM\":\"NEM\",\"XMR\":\"Monero\",\"XSN\":\"Stakenet\",\"XSR\":\"SucreCoin\",\"XVG\":\"VERGE\",\"XZC\":\"ZCoin\",\"ZEC\":\"ZCash\",\"ZEN\":\"Horizen\"}',1,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:50:26'),
(16,0,504,'CoinPayments Fiat','CoinpaymentsFiat','66437a3fcdb031715698239.png',1,'{\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"6515561\"}}','{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:50:39'),
(17,0,505,'Coingate','Coingate','66437a0890e4c1715698184.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"6354mwVCEw5kHzRJ6thbGo-N\"}}','{\"USD\":\"USD\",\"EUR\":\"EUR\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:49:44'),
(18,0,506,'Coinbase Commerce','CoinbaseCommerce','664379fc3594d1715698172.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"c47cd7df-d8e8-424b-a20a\"},\"secret\":{\"title\":\"Webhook Shared Secret\",\"global\":true,\"value\":\"55871878-2c32-4f64-ab66\"}}','{\"USD\":\"USD\",\"EUR\":\"EUR\",\"JPY\":\"JPY\",\"GBP\":\"GBP\",\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CNY\":\"CNY\",\"SEK\":\"SEK\",\"NZD\":\"NZD\",\"MXN\":\"MXN\",\"SGD\":\"SGD\",\"HKD\":\"HKD\",\"NOK\":\"NOK\",\"KRW\":\"KRW\",\"TRY\":\"TRY\",\"RUB\":\"RUB\",\"INR\":\"INR\",\"BRL\":\"BRL\",\"ZAR\":\"ZAR\",\"AED\":\"AED\",\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AWG\":\"AWG\",\"AZN\":\"AZN\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYN\":\"BYN\",\"BZD\":\"BZD\",\"CDF\":\"CDF\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHS\":\"GHS\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MYR\":\"MYR\",\"MZN\":\"MZN\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NPR\":\"NPR\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDG\":\"SDG\",\"SHP\":\"SHP\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SRD\":\"SRD\",\"SSP\":\"SSP\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMT\":\"TMT\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TTD\":\"TTD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZMW\":\"ZMW\",\"ZWL\":\"ZWL\"}\r\n\r\n',0,'{\"endpoint\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.CoinbaseCommerce\"}}',NULL,'2019-09-14 13:14:22','2024-05-14 08:49:32'),
(24,0,113,'Paypal Express','PaypalSdk','66437b5574fc31715698517.png',1,'{\"clientId\":{\"title\":\"Paypal Client ID\",\"global\":true,\"value\":\"Ae0-tixtSV7DvLwIh3Bmu7JvHrjh5EfGdXr_cEklKAVjjezRZ747BxKILiBdzlKKyp-W8W_T7CKH1Ken\"},\"clientSecret\":{\"title\":\"Client Secret\",\"global\":true,\"value\":\"EOhbvHZgFNO21soQJT1L9Q00M3rK6PIEsdiTgXRBt2gtGtxwRer5JvKnVUGNU5oE63fFnjnYY7hq3HBA\"}}','{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"$\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:55:17'),
(25,0,114,'Stripe Checkout','StripeV3','663a39afb519f1715091887.png',1,'{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"sk_test_51I6GGiCGv1sRiQlEi5v1or9eR0HVbuzdMd2rW4n3DxC8UKfz66R4X6n4yYkzvI2LeAIuRU9H99ZpY7XCNFC9xMs500vBjZGkKG\"},\"publishable_key\":{\"title\":\"PUBLISHABLE KEY\",\"global\":true,\"value\":\"pk_test_51I6GGiCGv1sRiQlEOisPKrjBqQqqcFsw8mXNaZ2H2baN6R01NulFS7dKFji1NRRxuchoUTEDdB7ujKcyKYSVc0z500eth7otOM\"},\"end_point\":{\"title\":\"End Point Secret\",\"global\":true,\"value\":\"whsec_lUmit1gtxwKTveLnSe88xCSDdnPOt8g5\"}}','{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}',0,'{\"webhook\":{\"title\": \"Webhook Endpoint\",\"value\":\"ipn.StripeV3\"}}',NULL,'2019-09-14 13:14:22','2024-05-07 08:24:47'),
(27,0,115,'Mollie','Mollie','66437a9f10aea1715698335.png',1,'{\"mollie_email\":{\"title\":\"Mollie Email \",\"global\":true,\"value\":\"vi@gmail.com\"},\"api_key\":{\"title\":\"API KEY\",\"global\":true,\"value\":\"test_cucfwKTWfft9s337qsVfn5CC4vNkrn\"}}','{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}',0,NULL,NULL,'2019-09-14 13:14:22','2024-05-14 08:52:15'),
(30,0,116,'Cashmaal','Cashmaal','664379df84c691715698143.png',1,'{\"web_id\":{\"title\":\"Web Id\",\"global\":true,\"value\":\"3748\"},\"ipn_key\":{\"title\":\"IPN Key\",\"global\":true,\"value\":\"546254628759524554647987\"}}','{\"PKR\":\"PKR\",\"USD\":\"USD\"}',0,'{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"ipn.Cashmaal\"}}',NULL,NULL,'2024-05-14 08:49:03'),
(36,0,119,'Mercado Pago','MercadoPago','66437a8c175511715698316.png',1,'{\"access_token\":{\"title\":\"Access Token\",\"global\":true,\"value\":\"APP_USR-7924565816849832-082312-21941521997fab717db925cf1ea2c190-1071840315\"}}','{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\",\"ARS\":\"ARS\",\"BRL\":\"BRL\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"MXN\":\"MXN\",\"PEN\":\"PEN\",\"UYU\":\"UYU\",\"VEF\":\"VEF\",\"BOB\":\"BOB\"}',0,NULL,NULL,NULL,'2024-05-14 08:51:56'),
(37,0,120,'Authorize.net','Authorize','664379b12503e1715698097.png',1,'{\"login_id\":{\"title\":\"Login ID\",\"global\":true,\"value\":\"59e4P9DBcZv\"},\"transaction_key\":{\"title\":\"Transaction Key\",\"global\":true,\"value\":\"47x47TJyLw2E7DbR\"}}','{\"USD\":\"USD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"AUD\":\"AUD\",\"NZD\":\"NZD\"}',0,NULL,NULL,NULL,'2024-05-14 08:48:17'),
(46,0,121,'NMI','NMI','66437ab4128be1715698356.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"2F822Rw39fx762MaV7Yy86jXGTC7sCDy\"}}','{\"AED\":\"AED\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"RUB\":\"RUB\",\"SEC\":\"SEC\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}',0,NULL,NULL,NULL,'2024-05-14 08:52:36'),
(50,0,507,'BTCPay','BTCPay','664379c414a481715698116.png',1,'{\"store_id\":{\"title\":\"Store Id\",\"global\":true,\"value\":\"HsqFVTXSeUFJu7caoYZc3CTnP8g5LErVdHhEXPVTheHf\"},\"api_key\":{\"title\":\"Api Key\",\"global\":true,\"value\":\"4436bd706f99efae69305e7c4eff4780de1335ce\"},\"server_name\":{\"title\":\"Server Name\",\"global\":true,\"value\":\"https:\\/\\/testnet.demo.btcpayserver.org\"},\"secret_code\":{\"title\":\"Secret Code\",\"global\":true,\"value\":\"SUCdqPn9CDkY7RmJHfpQVHP2Lf2\"}}','{\"BTC\":\"Bitcoin\",\"LTC\":\"Litecoin\"}',1,'{\"webhook\":{\"title\": \"IPN URL\",\"value\":\"ipn.BTCPay\"}}',NULL,NULL,'2024-05-14 08:48:36'),
(51,0,508,'Now payments hosted','NowPaymentsHosted','66437ace77c611715698382.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"--------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------------\"}}','{\"BTG\":\"BTG\",\"ETH\":\"ETH\",\"XMR\":\"XMR\",\"ZEC\":\"ZEC\",\"XVG\":\"XVG\",\"ADA\":\"ADA\",\"LTC\":\"LTC\",\"BCH\":\"BCH\",\"QTUM\":\"QTUM\",\"DASH\":\"DASH\",\"XLM\":\"XLM\",\"XRP\":\"XRP\",\"XEM\":\"XEM\",\"DGB\":\"DGB\",\"LSK\":\"LSK\",\"DOGE\":\"DOGE\",\"TRX\":\"TRX\",\"KMD\":\"KMD\",\"REP\":\"REP\",\"BAT\":\"BAT\",\"ARK\":\"ARK\",\"WAVES\":\"WAVES\",\"BNB\":\"BNB\",\"XZC\":\"XZC\",\"NANO\":\"NANO\",\"TUSD\":\"TUSD\",\"VET\":\"VET\",\"ZEN\":\"ZEN\",\"GRS\":\"GRS\",\"FUN\":\"FUN\",\"NEO\":\"NEO\",\"GAS\":\"GAS\",\"PAX\":\"PAX\",\"USDC\":\"USDC\",\"ONT\":\"ONT\",\"XTZ\":\"XTZ\",\"LINK\":\"LINK\",\"RVN\":\"RVN\",\"BNBMAINNET\":\"BNBMAINNET\",\"ZIL\":\"ZIL\",\"BCD\":\"BCD\",\"USDT\":\"USDT\",\"USDTERC20\":\"USDTERC20\",\"CRO\":\"CRO\",\"DAI\":\"DAI\",\"HT\":\"HT\",\"WABI\":\"WABI\",\"BUSD\":\"BUSD\",\"ALGO\":\"ALGO\",\"USDTTRC20\":\"USDTTRC20\",\"GT\":\"GT\",\"STPT\":\"STPT\",\"AVA\":\"AVA\",\"SXP\":\"SXP\",\"UNI\":\"UNI\",\"OKB\":\"OKB\",\"BTC\":\"BTC\"}',1,'',NULL,NULL,'2024-05-14 08:53:02'),
(52,0,509,'Now payments checkout','NowPaymentsCheckout','66437ac2536a11715698370.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"---------------\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"-----------\"}}','{\"USD\":\"USD\",\"EUR\":\"EUR\"}',1,'',NULL,NULL,'2024-05-14 08:52:50'),
(53,0,122,'2Checkout','TwoCheckout','663a39b8e64b91715091896.png',1,'{\"merchant_code\":{\"title\":\"Merchant Code\",\"global\":true,\"value\":\"253248016872\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"eQM)ID@&vG84u!O*g[p+\"}}','{\"AFN\": \"AFN\",\"ALL\": \"ALL\",\"DZD\": \"DZD\",\"ARS\": \"ARS\",\"AUD\": \"AUD\",\"AZN\": \"AZN\",\"BSD\": \"BSD\",\"BDT\": \"BDT\",\"BBD\": \"BBD\",\"BZD\": \"BZD\",\"BMD\": \"BMD\",\"BOB\": \"BOB\",\"BWP\": \"BWP\",\"BRL\": \"BRL\",\"GBP\": \"GBP\",\"BND\": \"BND\",\"BGN\": \"BGN\",\"CAD\": \"CAD\",\"CLP\": \"CLP\",\"CNY\": \"CNY\",\"COP\": \"COP\",\"CRC\": \"CRC\",\"HRK\": \"HRK\",\"CZK\": \"CZK\",\"DKK\": \"DKK\",\"DOP\": \"DOP\",\"XCD\": \"XCD\",\"EGP\": \"EGP\",\"EUR\": \"EUR\",\"FJD\": \"FJD\",\"GTQ\": \"GTQ\",\"HKD\": \"HKD\",\"HNL\": \"HNL\",\"HUF\": \"HUF\",\"INR\": \"INR\",\"IDR\": \"IDR\",\"ILS\": \"ILS\",\"JMD\": \"JMD\",\"JPY\": \"JPY\",\"KZT\": \"KZT\",\"KES\": \"KES\",\"LAK\": \"LAK\",\"MMK\": \"MMK\",\"LBP\": \"LBP\",\"LRD\": \"LRD\",\"MOP\": \"MOP\",\"MYR\": \"MYR\",\"MVR\": \"MVR\",\"MRO\": \"MRO\",\"MUR\": \"MUR\",\"MXN\": \"MXN\",\"MAD\": \"MAD\",\"NPR\": \"NPR\",\"TWD\": \"TWD\",\"NZD\": \"NZD\",\"NIO\": \"NIO\",\"NOK\": \"NOK\",\"PKR\": \"PKR\",\"PGK\": \"PGK\",\"PEN\": \"PEN\",\"PHP\": \"PHP\",\"PLN\": \"PLN\",\"QAR\": \"QAR\",\"RON\": \"RON\",\"RUB\": \"RUB\",\"WST\": \"WST\",\"SAR\": \"SAR\",\"SCR\": \"SCR\",\"SGD\": \"SGD\",\"SBD\": \"SBD\",\"ZAR\": \"ZAR\",\"KRW\": \"KRW\",\"LKR\": \"LKR\",\"SEK\": \"SEK\",\"CHF\": \"CHF\",\"SYP\": \"SYP\",\"THB\": \"THB\",\"TOP\": \"TOP\",\"TTD\": \"TTD\",\"TRY\": \"TRY\",\"UAH\": \"UAH\",\"AED\": \"AED\",\"USD\": \"USD\",\"VUV\": \"VUV\",\"VND\": \"VND\",\"XOF\": \"XOF\",\"YER\": \"YER\"}',0,'{\"approved_url\":{\"title\": \"Approved URL\",\"value\":\"ipn.TwoCheckout\"}}',NULL,NULL,'2024-05-07 08:24:56'),
(54,0,123,'Checkout','Checkout','664379efb898b1715698159.png',1,'{\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"------\"},\"public_key\":{\"title\":\"PUBLIC KEY\",\"global\":true,\"value\":\"------\"},\"processing_channel_id\":{\"title\":\"PROCESSING CHANNEL\",\"global\":true,\"value\":\"------\"}}','{\"USD\":\"USD\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"AUD\":\"AUD\",\"CAN\":\"CAN\",\"CHF\":\"CHF\",\"SGD\":\"SGD\",\"JPY\":\"JPY\",\"NZD\":\"NZD\"}',0,NULL,NULL,NULL,'2024-05-14 08:49:19'),
(55,19,1000,'Bank Transfer','bank_transfer','66437b80317991715698560.png',1,'[]','[]',0,NULL,'<div><p>Send the amount to the below bank information</p><p>\r\n</p><p><span>Bank Name:</span> Bank of America</p>\r\n<p><span>Branch:</span> New York</p>\r\n<p><span>Routing:</span> 1234</p>\r\n<p><span>Account Number:</span> 997855xxxxxxxx6985</p></div>','2024-03-13 23:11:21','2024-05-14 09:14:58'),
(56,0,510,'Binance','Binance','663a35db4fd621715090907.png',1,'{\"api_key\":{\"title\":\"API Key\",\"global\":true,\"value\":\"tsu3tjiq0oqfbtmlbevoeraxhfbp3brejnm9txhjxcp4to29ujvakvfl1ibsn3ja\"},\"secret_key\":{\"title\":\"Secret Key\",\"global\":true,\"value\":\"jzngq4t04ltw8d4iqpi7admfl8tvnpehxnmi34id1zvfaenbwwvsvw7llw3zdko8\"},\"merchant_id\":{\"title\":\"Merchant ID\",\"global\":true,\"value\":\"231129033\"}}','{\"BTC\":\"Bitcoin\",\"USD\":\"USD\",\"BNB\":\"BNB\"}',1,'{\"cron\":{\"title\": \"Cron Job URL\",\"value\":\"ipn.Binance\"}}',NULL,NULL,'2024-05-07 08:08:27'),
(57,0,124,'SslCommerz','SslCommerz','663a397a70c571715091834.png',1,'{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"---------\"},\"store_password\":{\"title\":\"Store Password\",\"global\":true,\"value\":\"----------\"}}','{\"BDT\":\"BDT\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"SGD\":\"SGD\",\"INR\":\"INR\",\"MYR\":\"MYR\"}',0,NULL,NULL,NULL,'2024-05-07 08:23:54'),
(58,0,125,'Aamarpay','Aamarpay','6643799a83db81715698074.png',1,'{\"store_id\":{\"title\":\"Store ID\",\"global\":true,\"value\":\"---------\"},\"signature_key\":{\"title\":\"Signature Key\",\"global\":true,\"value\":\"----------\"}}','{\"BDT\":\"BDT\"}',0,NULL,NULL,NULL,'2024-05-14 08:47:54'),
(60,0,126,'bKash','BKash','67e1432683b5a1742816038.png',1,'{\"username\":{\"title\":\"Username\",\"global\":true,\"value\":\"01770618567\"},\"password\":{\"title\":\"Password\",\"global\":true,\"value\":\"D7DaC<*E*eG\"},\"app_key\":{\"title\":\"App Key\",\"global\":true,\"value\":\"0vWQuCRGiUX7EPVjQDr0EUAYtc\"},\"app_secret\":{\"title\":\"App Secret\",\"global\":true,\"value\":\"jcUNPBgbcqEDedNKdvE4G1cAK7D3hCjmJccNPZZBq96QIxxwAMEx\"}}','{\"BDT\":\"BDT\"}',0,NULL,NULL,NULL,'2025-03-15 21:58:31');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `code` varchar(40) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: not default language, 1: default language',
  `image` varchar(40) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES
(1,'English','en',1,'660b94fa876ac1712035066.png','2020-07-06 03:47:55','2024-04-01 23:17:46');

--
-- Table structure for table `market_data`
--

CREATE TABLE `market_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `currency_id` int(10) unsigned NOT NULL DEFAULT 0,
  `symbol` text DEFAULT NULL,
  `pair_id` int(11) NOT NULL DEFAULT 0,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `market_cap` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `last_market_cap` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `percent_change_1h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `last_percent_change_1h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `percent_change_24h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `last_percent_change_24h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `percent_change_7d` decimal(5,2) NOT NULL DEFAULT 0.00,
  `last_percent_change_7d` decimal(5,2) NOT NULL DEFAULT 0.00,
  `volume_24h` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `volume_change_24h` decimal(5,2) NOT NULL DEFAULT 0.00,
  `html_classes` varchar(255) DEFAULT NULL COMMENT 'Price, percent changes html class indicator',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `market_data`
--

INSERT INTO `market_data` VALUES
(1,1,'BTC',0,88248.25240350,88224.12846467,1761840706942.00000000,0.00000000,0.03,0.04,0.17,1.36,2.45,2.40,35707617640.89000000,-39.32,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(2,2,'ETH',0,2981.66688786,2982.42543336,359872333126.56000000,0.00000000,0.00,0.17,1.06,2.13,4.33,3.51,19056521951.69400000,-47.59,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(3,3,'USDT',0,0.99949009,0.99944722,186229245735.13000000,0.00000000,0.00,0.01,0.01,0.01,0.07,0.07,76432056946.60100000,-37.18,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(4,4,'XRP',0,1.94964858,1.91307532,118095955252.78000000,0.00000000,1.05,0.51,4.63,4.58,4.08,5.81,2804081867.58830000,-40.36,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(5,5,'BNB',0,853.64004928,854.49209428,117576303803.63000000,0.00000000,0.02,0.42,1.08,2.13,4.00,3.58,3936122953.54250000,-7.69,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(6,6,'SOL',0,126.34978746,126.16230526,71045889592.53600000,0.00000000,0.27,0.04,0.84,1.48,5.33,5.10,3514635660.50150000,-49.23,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(7,7,'USDC',0,0.99980918,0.99987181,77082186341.20700000,0.00000000,0.01,0.00,0.01,0.01,0.02,0.01,9900519049.81390000,-33.76,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(8,8,'TRX',0,0.27935495,0.27906202,26450765492.97500000,0.00000000,0.04,0.01,0.26,0.14,2.55,2.05,495798252.65311000,-26.68,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(9,9,'DOGE',0,0.13188577,0.13077720,22152860584.41300000,0.00000000,0.31,0.57,2.85,3.74,4.78,4.92,1105862804.97400000,-44.66,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(10,10,'ADA',0,0.37644952,0.37228089,13522489011.71300000,0.00000000,0.59,0.59,2.58,3.09,8.69,9.36,472686736.25772000,-41.84,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(11,11,'HYPE',0,25.22126100,24.59257520,8491625784.03940000,0.00000000,1.35,0.03,5.11,5.34,10.18,13.25,240153543.51071000,-53.84,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(12,12,'LINK',0,12.63775764,12.49115091,8948795814.71520000,0.00000000,0.27,0.45,1.86,1.82,9.25,9.13,453959558.69507000,-40.62,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(13,13,'ZEC',0,452.66598280,439.15048710,7444605032.70920000,0.00000000,0.65,1.52,10.30,9.85,2.18,4.53,758185522.79393000,12.42,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(14,14,'BCH',0,596.85723822,602.12004342,11918875337.44000000,0.00000000,0.19,0.18,1.37,2.21,3.50,4.06,696360600.51102000,-1.63,'{\"price_change\":\"down\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(15,15,'USDe',0,0.99874215,0.00000000,0.00000000,0.00000000,0.00,0.00,0.00,0.00,0.00,0.00,0.00000000,0.00,NULL,'2025-11-07 10:39:39','2025-11-07 10:39:39'),
(16,16,'XLM',0,0.22241489,0.21903857,7208027897.04430000,0.00000000,0.78,0.55,3.06,3.82,7.17,8.70,145818632.06098000,-26.29,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(17,17,'LEO',0,8.07884673,7.94528627,7447436040.70490000,0.00000000,0.88,0.08,9.41,9.59,15.11,16.57,2618500.62790620,-35.60,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(18,18,'SUI',0,1.47611365,1.46682135,5516039460.65430000,0.00000000,0.15,0.53,3.45,5.83,7.81,7.07,635884017.38560000,-41.31,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(19,19,'AVAX',0,12.32995160,12.21473968,5295929735.24040000,0.00000000,0.05,0.37,3.04,4.68,8.09,7.75,307348642.38328000,-44.91,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(20,20,'HBAR',0,0.11301618,0.11094820,4834460190.10430000,0.00000000,0.43,0.18,3.35,4.28,9.38,11.96,131177539.33810000,-39.19,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(21,21,'LTC',0,77.32928113,77.05598475,5926976851.44770000,0.00000000,0.24,0.40,1.55,1.71,5.31,5.80,315470269.98453000,-40.58,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(22,22,'XMR',0,447.32273334,449.09467198,8251647980.26040000,0.00000000,0.52,0.16,2.51,5.88,8.60,9.95,189854240.22204000,1.74,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(23,23,'SHIB',0,0.00000749,0.00000747,4415056178.68510000,0.00000000,0.52,0.57,1.39,1.53,10.55,10.59,98820366.12476500,-49.35,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(24,24,'DAI',0,0.99972346,0.99937925,5363898960.59390000,0.00000000,0.02,0.03,0.01,0.05,0.01,0.05,117009112.34325000,-8.32,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(25,25,'TON',0,1.48463630,1.46871756,3639345354.24080000,0.00000000,0.16,0.11,3.27,2.44,8.00,9.07,85004531.51996600,-45.54,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(26,26,'DOT',0,1.86060004,1.83522915,3064597905.28860000,0.00000000,0.21,0.34,3.53,3.40,8.77,9.80,159003907.19667000,-33.67,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(27,27,'CRO',0,0.09774063,0.09668603,3767734099.37770000,0.00000000,1.16,0.34,6.07,5.32,2.34,3.81,18857065.98534300,-6.87,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(28,28,'ICP',0,2.94906217,2.90240650,1609564009.37610000,0.00000000,0.29,0.45,2.98,1.84,9.34,10.94,71929503.35557400,-25.38,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(29,29,'MNT',0,1.14328716,1.14425712,3719049162.87880000,0.00000000,0.61,0.40,2.10,2.42,10.75,7.97,120873544.69012000,-25.90,'{\"price_change\":\"down\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(30,30,'TAO',0,229.50303408,228.17979913,2412655394.58190000,0.00000000,0.49,0.37,1.19,1.29,21.57,22.30,137770127.58835000,-18.13,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(31,31,'UNI',0,5.72899414,5.29368495,3611159896.76030000,0.00000000,0.43,0.32,9.48,4.23,4.56,2.21,345107748.49936000,-24.17,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(32,32,'AAVE',0,181.03391645,181.86743803,2770690342.02560000,0.00000000,0.44,0.11,0.13,1.23,9.66,6.52,260414935.95166000,-25.22,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(33,33,'USD1',0,0.99900371,0.99898493,2715425954.13880000,0.00000000,0.00,0.01,0.02,0.01,0.04,0.03,574311253.14124000,-30.13,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(34,34,'NEAR',0,1.52066514,1.53204367,1950967088.16660000,0.00000000,0.25,1.07,0.87,2.86,9.29,7.12,167181487.14891000,-41.12,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(35,35,'WLFI',0,0.13494232,0.13427337,3607623385.08970000,0.00000000,0.17,0.58,1.80,3.87,6.19,6.73,111170167.45350000,-20.31,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(36,36,'PYUSD',0,0.99954899,0.99959968,3883827850.04840000,0.00000000,0.01,0.00,0.00,0.02,0.03,0.01,66276279.41329600,-30.99,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(37,37,'BGB',0,3.47022081,3.45622059,2416417308.44490000,0.00000000,0.03,0.09,0.46,0.10,3.77,4.08,60019870.20067900,-24.92,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(38,38,'M',0,1.41030911,1.41874358,1759481543.40090000,0.00000000,0.81,1.16,6.49,7.97,15.55,12.72,18313377.22076400,-16.56,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(39,39,'OKB',0,108.41546623,108.17239251,2276724790.82080000,0.00000000,0.25,0.01,1.82,1.88,6.10,6.08,20103119.41292100,-57.56,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(40,40,'ETC',0,12.45513771,12.37519075,1927943483.55650000,0.00000000,0.40,0.61,3.24,4.50,5.49,5.61,70756187.40386600,-28.66,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(41,41,'PEPE',0,0.00000409,0.00000407,1722061818.21200000,0.00000000,0.56,0.37,5.45,6.59,6.94,7.54,366937926.84522000,-17.94,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(42,42,'ENA',0,0.21103669,0.21110834,1623004015.31280000,0.00000000,0.84,0.26,3.67,4.42,15.73,15.14,155245087.89071000,-48.89,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(43,43,'APT',0,1.63906021,1.65718285,1227796657.87800000,0.00000000,0.69,0.57,7.96,9.44,2.62,0.20,165466989.70246000,23.15,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(44,44,'ASTER',0,0.72472100,0.72347824,1808526174.16230000,0.00000000,0.06,0.68,6.47,6.32,23.50,23.69,241652021.27551000,-26.04,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(45,45,'ONDO',0,0.40042573,0.39598847,1264987923.37950000,0.00000000,0.12,0.57,3.94,4.91,13.49,13.96,51654528.51205800,-44.01,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(46,46,'PI',0,0.21219615,0.21230542,0.00000000,0.00000000,0.05,0.12,2.94,3.64,2.45,1.95,1833469.52156190,45.87,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(47,47,'POL',0,0.11050947,0.10976468,1166872991.97850000,0.00000000,0.85,0.14,4.81,4.19,9.12,8.66,78024721.86436400,-38.02,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(48,48,'WLD',0,0.51812363,0.51689609,1282237832.90190000,0.00000000,0.64,0.09,3.00,3.39,12.11,11.24,70781591.04736800,-33.48,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(49,49,'KCS',0,10.72974446,10.79094977,1391382421.58720000,0.00000000,0.53,0.08,1.30,2.12,0.10,1.12,5818803.45538350,-42.83,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(50,50,'XAUt',0,3985.48457930,0.00000000,0.00000000,0.00000000,0.00,0.00,0.00,0.00,0.00,0.00,0.00000000,0.00,NULL,'2025-11-07 10:39:39','2025-11-07 10:39:39'),
(51,51,'TRUMP',0,5.14900098,5.15938671,1029796009.80750000,0.00000000,0.22,0.57,0.57,0.40,7.76,7.66,127420054.09666000,-21.27,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(52,52,'FIL',0,1.30781528,1.29867884,952294761.54300000,0.00000000,0.33,0.08,4.98,4.53,2.94,3.11,110805261.03029000,-17.48,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(53,53,'ARB',0,0.19063650,0.18936230,1090304759.44950000,0.00000000,0.75,0.11,3.34,3.92,9.45,8.31,119748270.15362000,-32.25,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(54,54,'ALGO',0,0.11424163,0.11433543,1009229852.90380000,0.00000000,0.27,0.43,2.38,2.84,6.86,6.56,34949737.79028300,-40.01,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(55,55,'DASH',0,38.93777273,39.42082715,487562506.46782000,0.00000000,2.38,1.07,5.34,6.78,15.32,14.27,103609730.98982000,1.38,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(56,56,'PAXG',0,4351.82133232,4356.68145225,1527066390.70270000,0.00000000,0.05,0.02,0.34,0.48,0.84,0.92,52519058.87785500,-62.71,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(57,57,'KAS',0,0.04428416,0.04380044,1197162413.59590000,0.00000000,0.72,1.31,5.48,5.10,3.57,4.54,20886361.24624100,-32.74,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(58,58,'ATOM',0,1.97677948,1.97245824,956048162.98674000,0.00000000,0.59,0.06,6.05,5.94,9.44,8.75,52364778.08633700,-32.76,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(59,59,'PUMP',0,0.00197930,0.00197449,700672285.35103000,0.00000000,0.31,0.07,0.34,1.80,29.09,28.20,102731842.35938000,-37.74,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(60,60,'VET',0,0.01074146,0.01067203,923605307.61170000,0.00000000,0.24,0.56,4.92,6.62,8.64,8.91,25138490.85620500,-26.57,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(61,61,'IP',0,0.00004468,1.64093791,0.00000000,0.00000000,23.63,0.28,302.15,1.49,263.95,12.72,295003.50292850,-20.52,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(62,62,'FLR',0,0.01168535,0.01157701,940722898.30943000,0.00000000,0.42,0.25,3.98,4.21,6.84,7.32,5214900.95357240,-33.46,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(63,63,'SKY',0,0.06244120,0.06171126,1431276012.09320000,0.00000000,0.45,0.34,4.22,4.40,8.76,7.23,20160570.66586200,-3.27,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(64,64,'JUP',0,0.19708667,0.19303371,618250413.79300000,0.00000000,0.69,1.08,8.16,7.62,3.50,5.96,30566829.09850200,2.25,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(65,65,'RENDER',0,1.29381887,1.30520752,670954559.49972000,0.00000000,0.57,1.04,2.70,4.73,17.16,15.66,35350902.63706000,-2.10,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(66,66,'RLUSD',0,0.99979412,0.99967220,1335856192.19300000,0.00000000,0.01,0.01,0.00,0.01,0.02,0.02,64977193.36447900,-44.47,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(67,67,'SEI',0,0.11208096,0.11211487,727529954.74388000,0.00000000,0.66,0.18,0.59,0.69,13.55,13.37,56994999.85450300,-28.37,'{\"price_change\":0,\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(68,68,'FDUSD',0,0.99923713,0.99901997,518027796.74361000,0.00000000,0.02,0.01,0.02,0.01,0.05,0.02,3225248833.55330000,-43.92,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"up\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(69,69,'BONK',0,0.00000833,0.00000830,690775403.96980000,0.00000000,0.74,0.51,4.28,4.37,10.14,11.10,67494150.93615400,-42.63,'{\"price_change\":0,\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(70,70,'QNT',0,74.19599194,73.79858557,895748771.33578000,0.00000000,0.36,0.61,0.80,0.64,8.42,10.06,14719838.87492900,-11.59,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(71,71,'XDC',0,0.04938328,0.04811279,914847248.67821000,0.00000000,0.44,0.05,4.25,3.71,0.46,2.47,33693891.80557700,-19.13,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(72,72,'GT',0,10.27745571,10.26142012,825156128.91175000,0.00000000,0.08,0.02,2.36,2.21,1.12,1.21,4376727.79183180,-26.36,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(73,73,'PENGU',0,0.00931426,0.00929147,585498105.67505000,0.00000000,0.20,0.46,2.02,2.79,14.97,14.96,122535764.55387000,-45.63,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(74,74,'VIRTUAL',0,0.71842297,0.72349465,471358299.31893000,0.00000000,0.77,1.95,5.21,7.97,11.42,9.90,81939779.13231900,-19.06,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(75,75,'IMX',0,0.23137419,0.23163605,460196902.44755000,0.00000000,0.24,0.14,4.54,4.57,16.63,15.02,20718286.24111300,-29.21,'{\"price_change\":\"down\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(76,76,'AERO',0,0.51609462,0.51027784,470508591.84311000,0.00000000,0.84,1.10,5.55,5.90,15.04,15.87,30114297.31552600,-17.50,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(77,77,'CAKE',0,1.85084590,1.82909250,622339013.63962000,0.00000000,0.85,0.30,0.65,0.16,17.05,17.30,38483070.73321800,-22.59,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(78,78,'OP',0,0.28026420,0.27815432,544859519.04920000,0.00000000,1.22,0.01,4.75,7.68,10.03,9.93,71977855.45521700,-27.54,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(79,79,'XTZ',0,0.45009297,0.44152930,481277541.90863000,0.00000000,0.40,0.14,3.48,3.84,9.88,11.25,21704655.69681900,-16.57,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(80,80,'NEXO',0,0.92377227,0.91770274,596891606.01976000,0.00000000,0.18,0.45,0.03,1.21,5.05,6.15,9465187.22915230,-25.46,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(81,81,'TIA',0,0.47683439,0.47470272,408337010.63179000,0.00000000,1.34,0.71,2.63,6.74,18.71,17.35,42114354.11054500,-28.88,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(82,82,'STX',0,0.25785623,0.25608608,467907404.03432000,0.00000000,0.47,0.35,3.23,6.90,10.52,10.94,10263830.01498500,-3.96,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(83,83,'LDO',0,0.55448561,0.55258428,495470707.13847000,0.00000000,0.24,0.02,4.62,6.36,7.35,6.77,44019544.74574700,-29.30,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(84,84,'INJ',0,4.84277345,4.80215549,484136591.50292000,0.00000000,0.22,0.18,3.43,5.20,10.58,11.51,36928145.97105900,-47.43,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(85,85,'GRT',0,0.03794307,0.03757182,404314421.49017000,0.00000000,0.09,0.59,3.48,3.51,8.70,8.31,17425367.94239400,-28.05,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(86,86,'CRV',0,0.35021246,0.34710914,499262904.37300000,0.00000000,1.05,0.59,0.83,1.84,12.55,12.27,78999864.94030400,-28.49,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 07:01:01'),
(87,87,'MORPHO',0,1.21896806,1.21562682,457144021.82336000,0.00000000,0.12,0.20,1.48,1.43,5.14,6.61,20756291.18607300,-37.81,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(88,88,'FET',0,0.21268365,0.20871678,491738307.37624000,0.00000000,0.01,0.31,3.48,3.80,12.56,12.72,65234678.04658800,-17.46,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(89,89,'SPX',0,0.49538040,0.49317076,461195724.90829000,0.00000000,0.26,0.57,1.97,4.20,16.80,15.58,14571362.15049800,-31.94,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(90,90,'FLOKI',0,0.00004120,0.00004097,393063945.22269000,0.00000000,0.71,0.09,2.25,3.16,12.01,11.88,37029631.70277900,-36.74,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(91,91,'2Z',0,0.10971376,0.10946913,380862250.24726000,0.00000000,0.48,0.36,1.12,2.17,9.17,9.40,15667293.59212500,-24.62,'{\"price_change\":\"up\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(92,92,'KAIA',0,0.06103422,0.06087864,378265935.77214000,0.00000000,0.06,0.23,2.75,4.13,19.31,18.29,15574574.16245800,-57.19,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(93,93,'ZK',0,0.02840333,0.02725795,301422654.93420000,0.00000000,0.29,1.13,9.40,3.46,8.82,12.99,23197159.87608600,-21.82,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(94,94,'PYTH',0,0.05981073,0.05801654,343910648.90264000,0.00000000,0.16,0.34,6.16,3.67,7.81,10.62,13770672.18805700,-35.87,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 09:01:01'),
(95,95,'IOTA',0,0.09012869,0.08997655,378014167.08968000,0.00000000,1.90,0.52,3.25,4.35,10.69,10.68,12866238.40595200,-26.39,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(96,96,'TWT',0,0.82241269,0.83096798,353522744.96926000,0.00000000,0.06,0.00,1.72,3.71,15.00,13.91,18428779.45316800,-39.94,'{\"price_change\":\"down\",\"percent_change_1h\":\"up\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 11:01:01'),
(97,97,'DEXE',0,3.33621165,3.39319523,279353137.74634000,0.00000000,0.25,0.37,3.88,5.02,6.20,3.26,11371779.10889800,-65.26,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(98,98,'DCR',0,16.77220681,16.86806478,288185772.88149000,0.00000000,0.80,1.00,3.28,3.96,18.78,17.69,2033897.55603400,-21.14,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(99,99,'STRK',0,0.08318402,0.08198425,412983666.51528000,0.00000000,0.42,0.45,0.85,0.46,20.96,21.98,53372663.70510600,-27.36,'{\"price_change\":\"up\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 08:01:01'),
(100,100,'ETHFI',0,0.74918116,0.75275454,489037255.24931000,0.00000000,0.84,0.41,3.80,6.17,7.36,6.57,31075019.98836200,-35.19,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-07 10:39:39','2025-12-20 10:01:01'),
(101,0,'USDT',1,0.00001134,0.00001133,2112821.64540200,0.00000000,0.00,0.01,0.00,0.01,0.06,0.06,708464.37799370,-46.63,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-12 15:12:26','2025-12-20 15:01:14'),
(102,0,'ETH',2,0.03375956,0.03383003,4074610.43345580,0.00000000,0.10,0.27,0.39,0.75,4.35,4.31,143620.51407849,-63.13,'{\"price_change\":0,\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-12 15:18:00','2025-12-20 15:01:14'),
(103,0,'BTC',3,88187.60293591,88301.13941716,1760640888274.10000000,0.00000000,0.08,0.15,0.28,0.11,2.19,2.33,26048364210.25500000,-53.76,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"up\",\"percent_change_7d\":\"down\"}','2025-11-12 17:23:58','2025-12-20 15:01:14'),
(104,0,'XRP',4,1.92169372,1.94279491,116402647132.87000000,0.00000000,0.36,0.02,2.47,3.87,5.39,4.56,2543469639.17720000,-43.76,'{\"price_change\":\"down\",\"percent_change_1h\":\"down\",\"percent_change_24h\":\"down\",\"percent_change_7d\":\"down\"}','2025-11-12 17:27:30','2025-12-20 15:01:14');

--
-- Table structure for table `markets`
--

CREATE TABLE `markets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `currency_id` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Enable,0=Disable',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `markets_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `markets`
--

INSERT INTO `markets` VALUES
(1,'BTC',1,1,'2025-11-07 10:41:05','2025-11-12 15:16:25'),
(2,'USDT',3,1,'2025-11-12 15:16:35','2025-11-12 15:16:35');

--
-- Table structure for table `notification_logs`
--

CREATE TABLE `notification_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `sender` varchar(40) DEFAULT NULL,
  `sent_from` varchar(40) DEFAULT NULL,
  `sent_to` varchar(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `notification_type` varchar(40) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_logs`
--


--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `act` varchar(40) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `push_title` varchar(255) DEFAULT NULL,
  `email_body` text DEFAULT NULL,
  `sms_body` text DEFAULT NULL,
  `push_body` text DEFAULT NULL,
  `shortcodes` text DEFAULT NULL,
  `email_status` tinyint(1) NOT NULL DEFAULT 1,
  `email_sent_from_name` varchar(40) DEFAULT NULL,
  `email_sent_from_address` varchar(40) DEFAULT NULL,
  `sms_status` tinyint(1) NOT NULL DEFAULT 1,
  `sms_sent_from` varchar(40) DEFAULT NULL,
  `push_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` VALUES
(1,'BAL_ADD','Balance - Added','Your Account has been Credited','{{site_name}} - Balance Added','<div>We\'re writing to inform you that an amount of {{amount}} {{site_currency}} has been successfully added to your account.</div><div><br></div><div>Here are the details of the transaction:</div><div><br></div><div><b>Transaction Number: </b>{{trx}}</div><div><b>Current Balance:</b> {{post_balance}} {{site_currency}}</div><div><b>Admin Note:</b> {{remark}}</div><div><br></div><div>If you have any questions or require further assistance, please don\'t hesitate to contact us. We\'re here to assist you.</div>','We\'re writing to inform you that an amount of {{amount}} {{site_currency}} has been successfully added to your account.','{{amount}} {{site_currency}} has been successfully added to your account.','{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}',1,'{{site_name}} Finance',NULL,0,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:17:24'),
(2,'BAL_SUB','Balance - Subtracted','Your Account has been Debited','{{site_name}} - Balance Subtracted','<div>We wish to inform you that an amount of {{amount}} {{site_currency}} has been successfully deducted from your account.</div><div><br></div><div>Below are the details of the transaction:</div><div><br></div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Current Balance: </b>{{post_balance}} {{site_currency}}</div><div><b>Admin Note:</b> {{remark}}</div><div><br></div><div>Should you require any further clarification or assistance, please do not hesitate to reach out to us. We are here to assist you in any way we can.</div><div><br></div><div>Thank you for your continued trust in {{site_name}}.</div>','We wish to inform you that an amount of {{amount}} {{site_currency}} has been successfully deducted from your account.','{{amount}} {{site_currency}} debited from your account.','{\"trx\":\"Transaction number for the action\",\"amount\":\"Amount inserted by the admin\",\"remark\":\"Remark inserted by the admin\",\"post_balance\":\"Balance of the user after this transaction\"}',1,'{{site_name}} Finance',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:17:48'),
(3,'DEPOSIT_COMPLETE','Deposit - Automated - Successful','Deposit Completed Successfully','{{site_name}} - Deposit successful','<div>We\'re delighted to inform you that your deposit of {{amount}} {{site_currency}} via {{method_name}} has been completed.</div><div><br></div><div>Below, you\'ll find the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge: </b>{{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received:</b> {{method_amount}} {{method_currency}}</div><div><b>Paid via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Your current balance stands at {{post_balance}} {{site_currency}}.</div><div><br></div><div>If you have any questions or need further assistance, feel free to reach out to our support team. We\'re here to assist you in any way we can.</div>','We\'re delighted to inform you that your deposit of {{amount}} {{site_currency}} via {{method_name}} has been completed.','Deposit Completed Successfully','{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}',1,'{{site_name}} Billing',NULL,1,NULL,1,'2021-11-03 12:00:00','2024-05-08 07:20:34'),
(4,'DEPOSIT_APPROVE','Deposit - Manual - Approved','Deposit Request Approved','{{site_name}} - Deposit Request Approved','<div>We are pleased to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been approved.</div><div><br></div><div>Here are the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge: </b>{{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received: </b>{{method_amount}} {{method_currency}}</div><div><b>Paid via: </b>{{method_name}}</div><div><b>Transaction Number: </b>{{trx}}</div><div><br></div><div>Your current balance now stands at {{post_balance}} {{site_currency}}.</div><div><br></div><div>Should you have any questions or require further assistance, please feel free to contact our support team. We\'re here to help.</div>','We are pleased to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been approved.','Deposit of {{amount}} {{site_currency}} via {{method_name}} has been approved.','{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after this transaction\"}',1,'{{site_name}} Billing',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:19:49'),
(5,'DEPOSIT_REJECT','Deposit - Manual - Rejected','Deposit Request Rejected','{{site_name}} - Deposit Request Rejected','<div>We regret to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.</div><div><br></div><div>Here are the details of the rejected deposit:</div><div><br></div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Received:</b> {{method_amount}} {{method_currency}}</div><div><b>Paid via:</b> {{method_name}}</div><div><b>Charge:</b> {{charge}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>If you have any questions or need further clarification, please don\'t hesitate to contact us. We\'re here to assist you.</div><div><br></div><div>Rejection Reason:</div><div>{{rejection_message}}</div><div><br></div><div>Thank you for your understanding.</div>','We regret to inform you that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.','Your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.','{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"rejection_message\":\"Rejection message by the admin\"}',1,'{{site_name}} Billing',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:20:13'),
(6,'DEPOSIT_REQUEST','Deposit - Manual - Requested','Deposit Request Submitted Successfully',NULL,'<div>We are pleased to confirm that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.</div><div><br></div><div>Below are the details of your deposit:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Payable:</b> {{method_amount}} {{method_currency}}</div><div><b>Pay via: </b>{{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Should you have any questions or require further assistance, please feel free to reach out to our support team. We\'re here to assist you.</div>','We are pleased to confirm that your deposit request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.','Your deposit request of {{amount}} {{site_currency}} via {{method_name}} submitted successfully.','{\"trx\":\"Transaction number for the deposit\",\"amount\":\"Amount inserted by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the deposit method\",\"method_currency\":\"Currency of the deposit method\",\"method_amount\":\"Amount after conversion between base currency and method currency\"}',1,'{{site_name}} Billing',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-04-25 03:27:42'),
(7,'PASS_RESET_CODE','Password - Reset - Code','Password Reset','{{site_name}} Password Reset Code','<div>We\'ve received a request to reset the password for your account on <b>{{time}}</b>. The request originated from\r\n            the following IP address: <b>{{ip}}</b>, using <b>{{browser}}</b> on <b>{{operating_system}}</b>.\r\n    </div><br>\r\n    <div><span>To proceed with the password reset, please use the following account recovery code</span>: <span><b><font size=\"6\">{{code}}</font></b></span></div><br>\r\n    <div><span>If you did not initiate this password reset request, please disregard this message. Your account security\r\n            remains our top priority, and we advise you to take appropriate action if you suspect any unauthorized\r\n            access to your account.</span></div>','To proceed with the password reset, please use the following account recovery code: {{code}}','To proceed with the password reset, please use the following account recovery code: {{code}}','{\"code\":\"Verification code for password reset\",\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}',1,'{{site_name}} Authentication Center',NULL,0,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:24:57'),
(8,'PASS_RESET_DONE','Password - Reset - Confirmation','Password Reset Successful',NULL,'<div><div><span>We are writing to inform you that the password reset for your account was successful. This action was completed at {{time}} from the following browser</span>: <span>{{browser}}</span><span>on {{operating_system}}, with the IP address</span>: <span>{{ip}}</span>.</div><br><div><span>Your account security is our utmost priority, and we are committed to ensuring the safety of your information. If you did not initiate this password reset or notice any suspicious activity on your account, please contact our support team immediately for further assistance.</span></div></div>','We are writing to inform you that the password reset for your account was successful.','We are writing to inform you that the password reset for your account was successful.','{\"ip\":\"IP address of the user\",\"browser\":\"Browser of the user\",\"operating_system\":\"Operating system of the user\",\"time\":\"Time of the request\"}',1,'{{site_name}} Authentication Center',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-04-25 03:27:24'),
(9,'ADMIN_SUPPORT_REPLY','Support - Reply','Re: {{ticket_subject}} - Ticket #{{ticket_id}}','{{site_name}} - Support Ticket Replied','<div>\r\n    <div><span>Thank you for reaching out to us regarding your support ticket with the subject</span>:\r\n        <span>\"{{ticket_subject}}\"&nbsp;</span><span>and ticket ID</span>: {{ticket_id}}.</div><br>\r\n    <div><span>We have carefully reviewed your inquiry, and we are pleased to provide you with the following\r\n            response</span><span>:</span></div><br>\r\n    <div>{{reply}}</div><br>\r\n    <div><span>If you have any further questions or need additional assistance, please feel free to reply by clicking on\r\n            the following link</span>: <a href=\"{{link}}\" title=\"\" target=\"_blank\">{{link}}</a><span>. This link will take you to\r\n            the ticket thread where you can provide further information or ask for clarification.</span></div><br>\r\n    <div><span>Thank you for your patience and cooperation as we worked to address your concerns.</span></div>\r\n</div>','Thank you for reaching out to us regarding your support ticket with the subject: \"{{ticket_subject}}\" and ticket ID: {{ticket_id}}. We have carefully reviewed your inquiry. To check the response, please go to the following link: {{link}}','Re: {{ticket_subject}} - Ticket #{{ticket_id}}','{\"ticket_id\":\"ID of the support ticket\",\"ticket_subject\":\"Subject  of the support ticket\",\"reply\":\"Reply made by the admin\",\"link\":\"URL to view the support ticket\"}',1,'{{site_name}} Support Team',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:26:06'),
(10,'EVER_CODE','Verification - Email','Email Verification Code',NULL,'<div>\r\n    <div><span>Thank you for taking the time to verify your email address with us. Your email verification code\r\n            is</span>: <b><font size=\"6\">{{code}}</font></b></div><br>\r\n    <div><span>Please enter this code in the designated field on our platform to complete the verification\r\n            process.</span></div><br>\r\n    <div><span>If you did not request this verification code, please disregard this email. Your account security is our\r\n            top priority, and we advise you to take appropriate measures if you suspect any unauthorized access.</span>\r\n    </div><br>\r\n    <div><span>If you have any questions or encounter any issues during the verification process, please don\'t hesitate\r\n            to contact our support team for assistance.</span></div><br>\r\n    <div><span>Thank you for choosing us.</span></div>\r\n</div>','---','---','{\"code\":\"Email verification code\"}',1,'{{site_name}} Verification Center',NULL,0,NULL,0,'2021-11-03 12:00:00','2024-04-25 03:27:12'),
(11,'SVER_CODE','Verification - SMS','Verify Your Mobile Number',NULL,'---','Your mobile verification code is {{code}}. Please enter this code in the appropriate field to verify your mobile number. If you did not request this code, please ignore this message.','---','{\"code\":\"SMS Verification Code\"}',0,'{{site_name}} Verification Center',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-04-25 03:27:03'),
(12,'WITHDRAW_APPROVE','Withdraw - Approved','Withdrawal Confirmation: Your Request Processed Successfully','{{site_name}} - Withdrawal Request Approved','<div>We are writing to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been processed successfully.</div><div><br></div><div>Below are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>You will receive:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><hr><div><br></div><div><b>Details of Processed Payment:</b></div><div>{{admin_details}}</div><div><br></div><div>Should you have any questions or require further assistance, feel free to reach out to our support team. We\'re here to help.</div>','We are writing to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been processed successfully.','Withdrawal Confirmation: Your Request Processed Successfully','{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"admin_details\":\"Details provided by the admin\"}',1,'{{site_name}} Finance',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:26:37'),
(13,'WITHDRAW_REJECT','Withdraw - Rejected','Withdrawal Request Rejected','{{site_name}} - Withdrawal Request Rejected','<div>We regret to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.</div><div><br></div><div>Here are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Expected Amount:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><hr><div><br></div><div><b>Refund Details:</b></div><div>{{amount}} {{site_currency}} has been refunded to your account, and your current balance is {{post_balance}} {{site_currency}}.</div><div><br></div><hr><div><br></div><div><b>Reason for Rejection:</b></div><div>{{admin_details}}</div><div><br></div><div>If you have any questions or concerns regarding this rejection or need further assistance, please do not hesitate to contact our support team. We apologize for any inconvenience this may have caused.</div>','We regret to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been rejected.','Withdrawal Request Rejected','{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this action\",\"admin_details\":\"Rejection message by the admin\"}',1,'{{site_name}} Finance',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:26:55'),
(14,'WITHDRAW_REQUEST','Withdraw - Requested','Withdrawal Request Confirmation','{{site_name}} - Requested for withdrawal','<div>We are pleased to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.</div><div><br></div><div>Here are the details of your withdrawal:</div><div><br></div><div><b>Amount:</b> {{amount}} {{site_currency}}</div><div><b>Charge:</b> {{charge}} {{site_currency}}</div><div><b>Conversion Rate:</b> 1 {{site_currency}} = {{rate}} {{method_currency}}</div><div><b>Expected Amount:</b> {{method_amount}} {{method_currency}}</div><div><b>Via:</b> {{method_name}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><br></div><div>Your current balance is {{post_balance}} {{site_currency}}.</div><div><br></div><div>Should you have any questions or require further assistance, feel free to reach out to our support team. We\'re here to help.</div>','We are pleased to inform you that your withdrawal request of {{amount}} {{site_currency}} via {{method_name}} has been submitted successfully.','Withdrawal request submitted successfully','{\"trx\":\"Transaction number for the withdraw\",\"amount\":\"Amount requested by the user\",\"charge\":\"Gateway charge set by the admin\",\"rate\":\"Conversion rate between base currency and method currency\",\"method_name\":\"Name of the withdraw method\",\"method_currency\":\"Currency of the withdraw method\",\"method_amount\":\"Amount after conversion between base currency and method currency\",\"post_balance\":\"Balance of the user after fter this transaction\"}',1,'{{site_name}} Finance',NULL,1,NULL,0,'2021-11-03 12:00:00','2024-05-08 07:27:20'),
(15,'DEFAULT','Default Template','{{subject}}','{{subject}}','{{message}}','{{message}}','{{message}}','{\"subject\":\"Subject\",\"message\":\"Message\"}',1,NULL,NULL,1,NULL,0,'2019-09-14 13:14:22','2024-05-08 07:18:21'),
(16,'KYC_APPROVE','KYC Approved','KYC Details has been approved','{{site_name}} - KYC Approved','<div><div><span>We are pleased to inform you that your Know Your Customer (KYC) information has been successfully reviewed and approved. This means that you are now eligible to conduct any payout operations within our system.</span></div><br><div><span>Your commitment to completing the KYC process promptly is greatly appreciated, as it helps us ensure the security and integrity of our platform for all users.</span></div><br><div><span>With your KYC verification now complete, you can proceed with confidence to carry out any payout transactions you require. Should you encounter any issues or have any questions along the way, please don\'t hesitate to reach out to our support team. We\'re here to assist you every step of the way.</span></div><br><div><span>Thank you once again for choosing {{site_name}} and for your cooperation in this matter.</span></div></div>','We are pleased to inform you that your Know Your Customer (KYC) information has been successfully reviewed and approved. This means that you are now eligible to conduct any payout operations within our system.','Your  Know Your Customer (KYC) information has been approved successfully','[]',1,'{{site_name}} Verification Center',NULL,1,NULL,0,NULL,'2024-05-08 07:23:57'),
(17,'KYC_REJECT','KYC Rejected','KYC has been rejected','{{site_name}} - KYC Rejected','<div><div><span>We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards. As a result, we are unable to approve your KYC submission at this time.</span></div><br><div><span>We understand that this news may be disappointing, and we want to assure you that we take these matters seriously to maintain the security and integrity of our platform.</span></div><br><div><span>Reasons for rejection may include discrepancies or incomplete information in the documentation provided. If you believe there has been a misunderstanding or if you would like further clarification on why your KYC was rejected, please don\'t hesitate to contact our support team.</span></div><br><div><span>We encourage you to review your submitted information and ensure that all details are accurate and up-to-date. Once any necessary adjustments have been made, you are welcome to resubmit your KYC information for review.</span></div><br><div><span>We apologize for any inconvenience this may cause and appreciate your understanding and cooperation in this matter.</span></div><br><div>Rejection Reason:</div><div>{{reason}}</div><div><br></div><div><span>Thank you for your continued support and patience.</span></div></div>','We regret to inform you that the Know Your Customer (KYC) information provided has been reviewed and unfortunately, it has not met our verification standards. As a result, we are unable to approve your KYC submission at this time. We encourage you to review your submitted information and ensure that all details are accurate and up-to-date. Once any necessary adjustments have been made, you are welcome to resubmit your KYC information for review.','Your  Know Your Customer (KYC) information has been rejected','{\"reason\":\"Rejection Reason\"}',1,'{{site_name}} Verification Center',NULL,1,NULL,0,NULL,'2024-05-08 07:24:13'),
(18,'REFERRAL_COMMISSION','Referral Commission - Received','Referral Commission Earned','{{site_name}} - Referral Commission','<div>Congratulations! You have earned a referral commission from your referral network.</div><div><br></div><div>Here are the details of your commission:</div><div><br></div><div><b>Commission Amount:</b> {{amount}} {{currency_symbol}}</div><div><b>Referral Level:</b> {{level}}</div><div><b>Commission Type:</b> {{type}}</div><div><b>Transaction Number:</b> {{trx}}</div><div><b>Current Balance:</b> {{post_balance}} {{currency_symbol}}</div><div><br></div><div>This commission has been automatically added to your account balance. Keep referring friends and family to earn more commissions!</div><div><br></div><div>Thank you for being a valued member of our referral program.</div>','Congratulations! You have earned {{amount}} {{site_currency}} referral commission from your {{level}} referral. Transaction: {{trx}}. Current balance: {{post_balance}} {{site_currency}}.','You earned {{amount}} {{site_currency}} referral commission from {{level}} referral!','{\"amount\":\"Referral commission amount\",\"post_balance\":\"User balance after commission\",\"trx\":\"Transaction number for the commission\",\"level\":\"Referral level (1st, 2nd, 3rd, etc.)\",\"type\":\"Type of commission earned\"}',1,'{{site_name}} Referral',NULL,1,NULL,1,'2025-06-18 03:04:40','2025-06-19 00:00:24');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `slug` varchar(40) DEFAULT NULL,
  `tempname` varchar(40) DEFAULT NULL COMMENT 'template name',
  `secs` text DEFAULT NULL,
  `seo_content` text DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES
(1,'HOME','/','templates.basic.','[\"about\",\"how_trade\",\"commodity\",\"counter\",\"testimonial\",\"faq\",\"blog\"]',NULL,1,'2020-07-11 06:23:58','2024-04-24 07:01:48'),
(4,'Blog','blog','templates.basic.',NULL,NULL,1,'2020-10-22 01:14:43','2024-04-02 01:23:58'),
(5,'Contact','contact','templates.basic.',NULL,NULL,1,'2020-10-22 01:14:53','2024-04-24 04:02:35'),
(19,'About','about','templates.basic.','[\"about\",\"counter\",\"how_trade\"]',NULL,0,'2024-03-16 04:36:13','2024-03-16 04:36:59');

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `commission_type` varchar(40) DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `percent` decimal(5,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referrals`
--


--
-- Table structure for table `support_attachments`
--

CREATE TABLE `support_attachments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `support_message_id` int(10) unsigned NOT NULL DEFAULT 0,
  `attachment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_attachments`
--


--
-- Table structure for table `support_messages`
--

CREATE TABLE `support_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `support_ticket_id` int(10) unsigned NOT NULL DEFAULT 0,
  `admin_id` int(10) unsigned NOT NULL DEFAULT 0,
  `message` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_messages`
--


--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT 0,
  `name` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `ticket` varchar(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed',
  `priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = Low, 2 = medium, 3 = heigh',
  `last_reply` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_tickets`
--


--
-- Table structure for table `trades`
--

CREATE TABLE `trades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `commodity_id` int(10) unsigned NOT NULL,
  `type` tinyint(1) NOT NULL,
  `quantity` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `price` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `total_cost` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trades`
--


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

CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `commodity_id` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `post_balance` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `trx_type` varchar(40) DEFAULT NULL,
  `trx` varchar(40) DEFAULT NULL,
  `details` varchar(255) DEFAULT NULL,
  `remark` varchar(40) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `update_logs`
--

CREATE TABLE `update_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(40) DEFAULT NULL,
  `update_log` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `update_logs`
--


--
-- Table structure for table `user_logins`
--

CREATE TABLE `user_logins` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `user_ip` varchar(40) DEFAULT NULL,
  `city` varchar(40) DEFAULT NULL,
  `country` varchar(40) DEFAULT NULL,
  `country_code` varchar(40) DEFAULT NULL,
  `longitude` varchar(40) DEFAULT NULL,
  `latitude` varchar(40) DEFAULT NULL,
  `browser` varchar(40) DEFAULT NULL,
  `os` varchar(40) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` VALUES
(1,1,'124.29.194.206','','','','','','Chrome','Linux','2025-12-21 15:43:27','2025-12-21 15:43:27');

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `form_id` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(40) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `min_limit` decimal(28,8) DEFAULT 0.00000000,
  `max_limit` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `fixed_charge` decimal(28,8) DEFAULT 0.00000000,
  `rate` decimal(28,8) DEFAULT 0.00000000,
  `percent_charge` decimal(5,2) DEFAULT NULL,
  `currency` varchar(40) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw_methods`
--


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

CREATE TABLE `withdrawals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `currency` varchar(40) DEFAULT NULL,
  `rate` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `trx` varchar(40) DEFAULT NULL,
  `final_amount` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `after_charge` decimal(28,8) NOT NULL DEFAULT 0.00000000,
  `withdraw_information` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=>success, 2=>pending, 3=>cancel,  ',
  `admin_feedback` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--


--
-- Dumping events for database 'trade'
--

--
-- Dumping routines for database 'trade'
--


