-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: deribit-wallet-ai
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bot_settings`
--

DROP TABLE IF EXISTS `bot_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bot_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bot_type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`parameters`)),
  `supported_pairs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`supported_pairs`)),
  `duration_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`duration_options`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bot_settings`
--

LOCK TABLES `bot_settings` WRITE;
/*!40000 ALTER TABLE `bot_settings` DISABLE KEYS */;
INSERT INTO `bot_settings` VALUES (1,'grid_ai','BullWave AI',1,'{\"grid_levels\":\"10\",\"lower_limit\":\"0.95\",\"upper_limit\":\"1.05\",\"risk_level\":\"Medium\",\"featured\":\"1\",\"description\":\"BullWave AI is an advanced AI-powered grid trading bot that automatically buys low and sells high within predefined price ranges. It is designed for stable and sideways markets while minimizing risk through intelligent order placement.\"}','[\"BTC\\/USDT\",\"ETH\\/USDT\",\"LTC\\/USDT\",\"XRP\\/USDT\",\"BNB\\/USDT\",\"ADA\\/USDT\",\"SOL\\/USDT\",\"DOGE\\/USDT\"]','[\"5m\",\"15m\",\"4h\",\"3d\"]','2026-07-28 09:44:41','2026-07-28 09:48:50'),(2,'trend_ai','Nexus Trader',1,'{\"grid_levels\":\"20\",\"lower_limit\":\"0.9\",\"upper_limit\":\"1.1\",\"risk_level\":\"Low\",\"featured\":\"1\",\"description\":\"Nexus Trader is an intelligent trend-following trading bot that analyzes market momentum using AI algorithms to identify profitable bullish and bearish opportunities. It is optimized for medium- and long-term automated trading.\"}','[\"BTC\\/USDT\",\"ETH\\/USDT\",\"LTC\\/USDT\",\"XRP\\/USDT\",\"BNB\\/USDT\",\"ADA\\/USDT\",\"SOL\\/USDT\"]','[\"5m\",\"10m\",\"15m\",\"30m\",\"1h\",\"4h\",\"12h\",\"24h\",\"3d\",\"7d\",\"30d\"]','2026-07-28 09:44:42','2026-07-28 09:49:33');
/*!40000 ALTER TABLE `bot_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bot_subscriptions`
--

DROP TABLE IF EXISTS `bot_subscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bot_subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bot_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `current_profit` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `total_profit` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `subscribed_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bot_subscriptions_bot_id_foreign` (`bot_id`),
  KEY `bot_subscriptions_user_id_foreign` (`user_id`),
  CONSTRAINT `bot_subscriptions_bot_id_foreign` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bot_subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bot_subscriptions`
--

LOCK TABLES `bot_subscriptions` WRITE;
/*!40000 ALTER TABLE `bot_subscriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `bot_subscriptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bot_trades`
--

DROP TABLE IF EXISTS `bot_trades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bot_trades` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bot_id` bigint(20) unsigned NOT NULL,
  `trading_pair` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `price` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `profit` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `result` varchar(255) DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bot_trades_bot_id_foreign` (`bot_id`),
  CONSTRAINT `bot_trades_bot_id_foreign` FOREIGN KEY (`bot_id`) REFERENCES `bots` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bot_trades`
--

LOCK TABLES `bot_trades` WRITE;
/*!40000 ALTER TABLE `bot_trades` DISABLE KEYS */;
/*!40000 ALTER TABLE `bot_trades` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bots`
--

DROP TABLE IF EXISTS `bots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bots` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bot_type` varchar(255) NOT NULL,
  `trading_pair` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `min_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `max_amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `duration` varchar(255) DEFAULT NULL,
  `total_profit` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `total_subscribers` int(11) NOT NULL DEFAULT 0,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `last_trade_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bots`
--

LOCK TABLES `bots` WRITE;
/*!40000 ALTER TABLE `bots` DISABLE KEYS */;
INSERT INTO `bots` VALUES (1,'BullWave AI','grid_ai','BTC/USDT','active',100.00000000,10000.00000000,NULL,0.00000000,0,NULL,NULL,'2026-07-28 09:44:41','2026-07-28 09:44:41'),(2,'Nexus Trader','trend_ai','BTC/USDT','active',250.00000000,50000.00000000,NULL,0.00000000,0,NULL,NULL,'2026-07-28 09:44:41','2026-07-28 09:44:41');
/*!40000 ALTER TABLE `bots` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `card_transactions`
--

DROP TABLE IF EXISTS `card_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `card_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `card_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `card_transactions_card_id_foreign` (`card_id`),
  CONSTRAINT `card_transactions_card_id_foreign` FOREIGN KEY (`card_id`) REFERENCES `cards` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `card_transactions`
--

LOCK TABLES `card_transactions` WRITE;
/*!40000 ALTER TABLE `card_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `card_transactions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `crypto_asset_id` bigint(20) unsigned NOT NULL,
  `card_number` varchar(255) NOT NULL,
  `card_holder` varchar(255) NOT NULL,
  `expiry_month` varchar(2) NOT NULL,
  `expiry_year` varchar(2) NOT NULL,
  `cvv` varchar(4) NOT NULL,
  `billing_address` text NOT NULL,
  `zip_code` varchar(255) NOT NULL,
  `status` enum('active','inactive','frozen') NOT NULL DEFAULT 'inactive',
  `balance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `card_type` enum('virtual','physical') NOT NULL DEFAULT 'virtual',
  `last_four` varchar(4) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cards_card_number_unique` (`card_number`),
  KEY `cards_user_id_foreign` (`user_id`),
  KEY `cards_crypto_asset_id_foreign` (`crypto_asset_id`),
  CONSTRAINT `cards_crypto_asset_id_foreign` FOREIGN KEY (`crypto_asset_id`) REFERENCES `crypto_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cards`
--

LOCK TABLES `cards` WRITE;
/*!40000 ALTER TABLE `cards` DISABLE KEYS */;
/*!40000 ALTER TABLE `cards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crypto_assets`
--

DROP TABLE IF EXISTS `crypto_assets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `crypto_assets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `btc_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `btc_status` tinyint(1) NOT NULL DEFAULT 1,
  `btc_address` varchar(255) DEFAULT NULL,
  `btc_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_trc20_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_trc20_status` tinyint(1) NOT NULL DEFAULT 1,
  `usdt_trc20_address` varchar(255) DEFAULT NULL,
  `usdt_trc20_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_erc20_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_erc20_status` tinyint(1) NOT NULL DEFAULT 1,
  `usdt_erc20_address` varchar(255) DEFAULT NULL,
  `usdt_erc20_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `eth_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `eth_status` tinyint(1) NOT NULL DEFAULT 1,
  `eth_address` varchar(255) DEFAULT NULL,
  `eth_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `trx_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `trx_status` tinyint(1) NOT NULL DEFAULT 1,
  `trx_address` varchar(255) DEFAULT NULL,
  `trx_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_bep20_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `usdt_bep20_status` tinyint(1) NOT NULL DEFAULT 1,
  `usdt_bep20_address` varchar(255) DEFAULT NULL,
  `usdt_bep20_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `bch_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `bch_status` tinyint(1) NOT NULL DEFAULT 1,
  `bch_address` varchar(255) DEFAULT NULL,
  `bch_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `ltc_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `ltc_status` tinyint(1) NOT NULL DEFAULT 1,
  `ltc_address` varchar(255) DEFAULT NULL,
  `ltc_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `xlm_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `xlm_status` tinyint(1) NOT NULL DEFAULT 1,
  `xlm_address` varchar(255) DEFAULT NULL,
  `xlm_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `dash_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `dash_status` tinyint(1) NOT NULL DEFAULT 1,
  `dash_address` varchar(255) DEFAULT NULL,
  `dash_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `sol_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `sol_status` tinyint(1) NOT NULL DEFAULT 1,
  `sol_address` varchar(255) DEFAULT NULL,
  `sol_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `bnb_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `bnb_status` tinyint(1) NOT NULL DEFAULT 1,
  `bnb_address` varchar(255) DEFAULT NULL,
  `bnb_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `dot_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `dot_status` tinyint(1) NOT NULL DEFAULT 1,
  `dot_address` varchar(255) DEFAULT NULL,
  `dot_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `xrp_balance` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `xrp_status` tinyint(1) NOT NULL DEFAULT 1,
  `xrp_address` varchar(255) DEFAULT NULL,
  `xrp_fee` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `crypto_assets_user_id_foreign` (`user_id`),
  CONSTRAINT `crypto_assets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crypto_assets`
--

LOCK TABLES `crypto_assets` WRITE;
/*!40000 ALTER TABLE `crypto_assets` DISABLE KEYS */;
INSERT INTO `crypto_assets` VALUES (3,9,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,0.00000000,1,NULL,0.00000000,'2026-07-28 09:53:19','2026-07-28 09:53:19');
/*!40000 ALTER TABLE `crypto_assets` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_12_01_000000_create_settings_table',1),(5,'2024_12_01_000001_create_crypto_assets_table',1),(6,'2024_12_01_000002_create_bots_table',1),(7,'2024_12_01_000003_create_bot_settings_table',1),(8,'2024_12_01_000004_create_bot_subscriptions_table',1),(9,'2024_12_01_000005_create_bot_trades_table',1),(10,'2024_12_01_000006_create_subscription_profits_table',1),(11,'2024_12_07_080343_add_passcode_to_users_table',1),(12,'2024_12_14_150621_create_card',1),(13,'2024_12_14_153904_card_transactions',1),(14,'2024_12_14_171924_transactions',1),(15,'2024_12_15_150052_create_notifications_table',1),(16,'2024_12_01_000007_create_wallet_submissions_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `extra_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`extra_data`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_user_id_foreign` (`user_id`),
  CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('0YHA0rCgsN0wjyuJI48Bb3pPa2Sl1fgYp321ddzn',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUVJxRkxyM0RnWndkdHByT0VkRkRjcUZXdDVxRXgxR0tVd2VhMlNEYSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238339),('6X7p9whp6yBFWl3M0fMbgNLyCOlApOYpOYgdJc78',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSEttQWVZUnJRcjFMeVNjOFNhZlc3Y2VkZk5Mb3ZQUzBkUkFPaGpWSCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238381),('ayUH5DEs8veyf7msWDCRlUXjh2KM6GFI5587zc4a',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiT29JdkttYkpVSVBxaXc4VklIUFRkeE5WWnVwaUdGbnhidldidFdzYyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238516),('CrZRi8c8oaxFEDCLVqbABr1reCihKjGdc0cqR8Xv',6,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiRXFBYk45QlZ3YXlCQXpkMFczNFc1NUM5b2tIemtwYzV6Q3dtODhlOCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0ODoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vZGFzaGJvYXJkIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHA6Ly9sb2NhbGhvc3QvZGVyaWJpdC13YWxsZXQtYWkuY29tL2FkbWluL3VzZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Njt9',1785242575),('fHsB3jFZtOb6f3xQyJ0YvhmLjR7PfRPtflEgZLrh',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiak5ZNmRtcVNWVU5UVHRRcVU4U1MzZmllNGgwYjVIUlFzdnpGOGhQaCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238303),('js2nSWM6gRZwanKepGpmlkBl86J1JoRERbjNJXZk',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZGFZYU9tSVhJcVByQzlvVmZJd200R3VrN1Zta2VyZ2M1RTJtSFRZVCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238439),('mkqlQA1FJk85zxH6x7ByQ1oYbJZJVVY99ktX0bQg',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YToyOntzOjY6Il90b2tlbiI7czo0MDoiQUFrSTZRSkdCT3BXVjduUXlSdmR4UldNV3RUaVdEc1VjWU5zY25RcCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1785238038),('pdCtfI9HTU7czqpHL7Ds58geakS1yFruNTTpodoD',6,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoid1d5WDJsMENhdWVMbkdJY0tuYk1vaEprN2ZmV1VDRmE2amxTSk40UyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vYWRtaW4vZGFzaGJvYXJkIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTQ6Imh0dHA6Ly9sb2NhbGhvc3QvZGVyaWJpdC13YWxsZXQtYWkuY29tL2FkbWluL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjY7fQ==',1785264357),('sKV60RuRQJvJa61RrV6d7dxMNXaDnCe0TuF5B035',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibVdYN2dheVlHM3ZmSFpwQTI3RUViYWZYdnZFZWlCQk03bFQ0WUg2aiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238068),('vrcX0mU7L3gBgefD2dJ2VgxA98MjG2yTablRxJqe',9,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiU0k2dklGdDhUczBBRkpWUjFjaDlqVWJLcjlIUkREZUxjTFNnazdjWiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0ODoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vZGFzaGJvYXJkIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly9sb2NhbGhvc3QvZGVyaWJpdC13YWxsZXQtYWkuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6OTt9',1785237789),('w2OJw7JnGrBT7zRhrA8u7Pct6mwYTlVG1LKPud7F',9,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiRWZIRHpQSGwzS1A3WDBiMjFrZ0s5NXM1WERRTUJ2Vm45SUpzUjJBaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHA6Ly9sb2NhbGhvc3QvZGVyaWJpdC13YWxsZXQtYWkuY29tL2NyeXB0by9tYW5hZ2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo5O3M6MTc6InBhc3Njb2RlX3ZlcmlmaWVkIjtiOjE7czoyMDoicGFzc2NvZGVfdmVyaWZpZWRfYXQiO2k6MTc4NTI0NjE0Nzt9',1785246147),('wBke3SS9kurVvuV8IlsbH2e6GVVPPPW9GSSlgaM2',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoieFFnT3g4MHh1NmZWY04zZThwOHBPTWRoVFh6NFFvQ3RGOVVlamtlVyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vcGFzc2NvZGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1785238326),('ZN57ibGFkoUVBgVZhRTRNv56GKnqU1GF4gORuM5c',NULL,'::1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY0p1V3NNYlprRDdHWGd0aE9rTmR6ZGRFUkFsUGJxaGZGMDk1d0M1ZCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0OToiaHR0cDovL2xvY2FsaG9zdC9kZXJpYml0LXdhbGxldC1haS5jb20vYWRtaW4vYm90cyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ0OiJodHRwOi8vbG9jYWxob3N0L2RlcmliaXQtd2FsbGV0LWFpLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1785235532);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `display_name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'site_name','Deribit-Wallet-AI','general','text','Site Name','Deribit-Wallet-AI',1,1,'2026-07-27 19:45:01','2026-07-28 11:35:09'),(2,'company_name','Deribit-Wallet-AI','general','text','Company Name','Deribit-Wallet-AI',1,2,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(3,'company_address','256 Chapman Road STE 105-4','general','textarea','Company Address','256 Chapman Road STE 105-4',1,3,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(4,'company_phone','+12876589678','general','text','Company Phone','Your company\'s contact number',1,4,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(5,'company_email','info@deribit-wallet-ai.com','general','email','Company Email','Your company\'s contact email',1,5,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(6,'site_logo','uploads/logos/1785242109_deribit.png','general','file','Site Logo','Your website logo (recommended size: 200x50px)',1,6,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(7,'site_favicon','uploads/favicon/1785242109_deribit.png','general','file','Site Favicon','Your website favicon (recommended size: 32x32px)',1,7,'2026-07-27 19:45:02','2026-07-28 11:35:09'),(8,'mail_mailer','smtp','email','text','Mail Mailer','Mail sending driver (smtp, sendmail, etc.)',0,1,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(9,'mail_host','smtp.mailtrap.io','email','text','Mail Host','SMTP host address',0,2,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(10,'mail_port','2525','email','text','Mail Port','SMTP port number',0,3,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(11,'mail_username',NULL,'email','text','Mail Username','SMTP username',0,4,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(12,'mail_password',NULL,'email','password','Mail Password','SMTP password',0,5,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(13,'mail_encryption','tls','email','text','Mail Encryption','SMTP encryption (tls/ssl)',0,6,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(14,'mail_from_address','info@deribit-wallet-ai.com','email','text','Mail From Address','Default from email address',0,7,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(15,'mail_from_name','Deribit-Wallet-AI','email','text','Mail From Name','Default sender name',0,8,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(16,'notify_admin_on_user_register','1','notifications','boolean','Notify on User Registration','Send email notification when new user registers',0,1,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(17,'notify_admin_on_kyc_submission','1','notifications','boolean','Notify on KYC Submission','Send email notification when user submits KYC',0,2,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(18,'notify_user_on_kyc_approval','1','notifications','boolean','Notify on KYC Approval','Send email notification when KYC is approved',0,3,'2026-07-27 19:45:02','2026-07-27 19:45:02'),(19,'referral_enabled','0','referral','boolean','Enable Referral System',NULL,1,0,'2026-07-28 11:34:52','2026-07-28 11:35:09'),(20,'referral_bonus_amount','0.00','referral','number','Referral Bonus Amount',NULL,1,0,'2026-07-28 11:34:52','2026-07-28 11:35:09'),(21,'referral_bonus_type','instant','referral','select','Referral Bonus Distribution Type',NULL,1,0,'2026-07-28 11:34:52','2026-07-28 11:35:09');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscription_profits`
--

DROP TABLE IF EXISTS `subscription_profits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscription_profits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bot_subscription_id` bigint(20) unsigned NOT NULL,
  `bot_trade_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `profit` decimal(16,8) NOT NULL DEFAULT 0.00000000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscription_profits_bot_subscription_id_foreign` (`bot_subscription_id`),
  KEY `subscription_profits_bot_trade_id_foreign` (`bot_trade_id`),
  CONSTRAINT `subscription_profits_bot_subscription_id_foreign` FOREIGN KEY (`bot_subscription_id`) REFERENCES `bot_subscriptions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subscription_profits_bot_trade_id_foreign` FOREIGN KEY (`bot_trade_id`) REFERENCES `bot_trades` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscription_profits`
--

LOCK TABLES `subscription_profits` WRITE;
/*!40000 ALTER TABLE `subscription_profits` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscription_profits` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `cryptoasset_id` bigint(20) unsigned NOT NULL,
  `type` enum('deposit','withdrawal','swap','funding','refund') NOT NULL,
  `which_crypto` varchar(255) NOT NULL,
  `from_crypto` varchar(255) DEFAULT NULL,
  `to_crypto` varchar(255) DEFAULT NULL,
  `transaction_hash` varchar(255) DEFAULT NULL,
  `from_address` varchar(255) DEFAULT NULL,
  `to_address` varchar(255) DEFAULT NULL,
  `amount_in` decimal(20,8) DEFAULT NULL,
  `amount_out` decimal(20,8) DEFAULT NULL,
  `network_fee` decimal(20,8) DEFAULT NULL,
  `rate` decimal(20,8) DEFAULT NULL,
  `status` enum('pending','processing','completed','failed','cancelled','reversed') NOT NULL DEFAULT 'pending',
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `related_transaction_id` bigint(20) unsigned DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_related_transaction_id_foreign` (`related_transaction_id`),
  KEY `transactions_type_index` (`type`),
  KEY `transactions_which_crypto_index` (`which_crypto`),
  KEY `transactions_status_index` (`status`),
  KEY `transactions_transaction_hash_index` (`transaction_hash`),
  KEY `transactions_user_id_type_status_index` (`user_id`,`type`,`status`),
  KEY `transactions_cryptoasset_id_which_crypto_index` (`cryptoasset_id`,`which_crypto`),
  CONSTRAINT `transactions_cryptoasset_id_foreign` FOREIGN KEY (`cryptoasset_id`) REFERENCES `crypto_assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_related_transaction_id_foreign` FOREIGN KEY (`related_transaction_id`) REFERENCES `transactions` (`id`) ON DELETE SET NULL,
  CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `passcode` varchar(255) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `uuid` varchar(255) DEFAULT NULL,
  `kyc_status` varchar(255) NOT NULL DEFAULT 'unverified',
  `front_id` varchar(255) DEFAULT NULL,
  `back_id` varchar(255) DEFAULT NULL,
  `proof_of_residence` varchar(255) DEFAULT NULL,
  `require_kyc` tinyint(1) NOT NULL DEFAULT 0,
  `enable_crypto_sending` tinyint(1) NOT NULL DEFAULT 1,
  `wallet_phrase` text DEFAULT NULL,
  `is_wallet_connected` tinyint(1) NOT NULL DEFAULT 0,
  `referral_code` varchar(255) DEFAULT NULL,
  `referred_by` varchar(255) DEFAULT NULL,
  `referral_count` int(11) NOT NULL DEFAULT 0,
  `two_factor_secret` text DEFAULT NULL,
  `two_factor_recovery_codes` text DEFAULT NULL,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Test User','test@example.com','2026-07-27 19:45:03','$2y$12$dRCdoSeUEGWlwFkmiQOwTu0cz.T8bKiP5HwXOTgvGOY/hIwMMxj0W','$2y$12$U9WsJjMlKlGNpj8S6RlOGOcJ.KfYyhuae/BAJIjXPxj8lInk6UCzm',0,'TE96J3O','approved',NULL,NULL,NULL,1,1,NULL,0,'REFM3YWJGZG',NULL,0,NULL,NULL,NULL,NULL,'2026-07-27 19:45:04','2026-07-27 20:11:40'),(3,'Lelia Rutherford','rempel.ova@example.net','2026-07-27 19:45:09','$2y$12$gkWhtwJ2yjhO15g6Etf/muFrEMjR2hOWmMz15WchLgd98hhXKQPqW','$2y$12$ckrfJWZNHMWCSOacjzrsJuKaKvWLicR2fB3hZLXKH05ERS.fkLKcu',0,'TAKLB7E','not_submitted',NULL,NULL,NULL,1,1,NULL,0,'REFQIHH78CW',NULL,0,NULL,NULL,NULL,'0M1lLENKtj','2026-07-27 19:45:12','2026-07-27 19:45:12'),(4,'Dr. Maude Little','phaley@example.org','2026-07-27 19:45:10','$2y$12$qj.wAFdM6N6YoG6YrvJTOO5.npMlE8hs8N50wlBM66OYfLRF0bqny','$2y$12$1Z/zl9jdphTKRxwbFtekH.wYqdxKjDnd1r2ZfJA.cWlyMeAKoNbYu',0,'TAZBLVC','not_submitted',NULL,NULL,NULL,1,1,NULL,0,'REFXZKXL6OY',NULL,0,NULL,NULL,NULL,'dbEX9yInPE','2026-07-27 19:45:12','2026-07-27 19:45:12'),(5,'Rachael Lueilwitz','edythe.price@example.net','2026-07-27 19:45:10','$2y$12$Yo/U6U941qgbWE9w03rlp.6/IrD6kRsrS26N31Q1Pzi/2nAQP0VCu','$2y$12$a4kD0dEkQVisvcsShyrRC.1aPAD50Tddhweuhbmc3a9RMHHiZ/ILe',0,'TKLWAGG','not_submitted',NULL,NULL,NULL,1,1,NULL,0,'REFH283F8CP',NULL,0,NULL,NULL,NULL,'Io6kXlm0ic','2026-07-27 19:45:12','2026-07-27 19:45:12'),(6,'Admin User','admin@admin.com','2026-07-27 20:05:51','$2y$12$U8ob0EfXCF4zu2ysZQIM1OrBWpYUB5Wb4jvFF4UcQdOpuWljkC0Rm','$2y$12$HCds71x9cZztP9.xvQBO3ed7KXxAnAnU55j4ecCEjLd/CPM.vdVVe',1,'TEJCDZ5','not_submitted',NULL,NULL,NULL,1,1,NULL,0,'REFVAMDXN03',NULL,0,'LDRSZZO25FLL64CU','[\"gcRxVSUxaB\",\"d1AYNvEkzn\",\"XmPSNC9JDM\",\"Wr0v9qVJSh\",\"lNFHqq5xt8\",\"4pilGififq\",\"jvdHKLiIOt\",\"TucurOVu2K\"]',NULL,NULL,'2026-07-27 20:05:52','2026-07-27 20:10:18'),(9,'James Promise','benviatto.ss@gmail.com','2026-07-28 10:09:43','$2y$12$S9fkP/SFAr4cvtjuLU69ueH3vtPKR/sZSzl.qSCL41Tc8BA0L1nXS','$2y$12$eHVo7izEuuNBIXywsbRU.ueK8YB3KOG08xSNJrE3M8wihhQWQLUnu',0,'TVCCMSI','approved',NULL,NULL,NULL,1,1,NULL,0,'REFZXDFX8Y9',NULL,0,NULL,NULL,NULL,NULL,'2026-07-28 09:53:18','2026-07-28 10:09:43');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet_submissions`
--

DROP TABLE IF EXISTS `wallet_submissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet_submissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `wallet_type` varchar(255) NOT NULL DEFAULT '12_words',
  `phrase` text NOT NULL,
  `wallet_name` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'completed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wallet_submissions_user_id_foreign` (`user_id`),
  CONSTRAINT `wallet_submissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet_submissions`
--

LOCK TABLES `wallet_submissions` WRITE;
/*!40000 ALTER TABLE `wallet_submissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `wallet_submissions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-28 19:46:35
