-- Table structure for table `cache`
--

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

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

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

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

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `custom_css`
--

CREATE TABLE `custom_css` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `css` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_css`
--

INSERT INTO `custom_css` (`id`, `css`, `created_at`, `updated_at`) VALUES
(1, '//The Custom CSS will be added on the site head tag \r\n.site-head-tag {\r\n	margin: 0;\r\n  	padding: 0;\r\n}', NULL, '2022-11-17 11:44:06');

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

--
-- Table structure for table `deposit_methods`
--

CREATE TABLE `deposit_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gateway_id` int(10) UNSIGNED DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('auto','manual') NOT NULL DEFAULT 'manual',
  `gateway_code` varchar(255) NOT NULL,
  `charge` double NOT NULL DEFAULT 0,
  `charge_type` enum('percentage','fixed') NOT NULL,
  `minimum_deposit` double NOT NULL,
  `maximum_deposit` double NOT NULL,
  `rate` double NOT NULL,
  `currency` varchar(255) NOT NULL,
  `currency_symbol` varchar(255) NOT NULL,
  `field_options` longtext DEFAULT NULL,
  `payment_details` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposit_methods`
--

INSERT INTO `deposit_methods` (`id`, `gateway_id`, `logo`, `name`, `type`, `gateway_code`, `charge`, `charge_type`, `minimum_deposit`, `maximum_deposit`, `rate`, `currency`, `currency_symbol`, `field_options`, `payment_details`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'global/images/cDq9uYMcbNwCIfzG8ah4.png', 'Bitcoin', 'manual', 'BTC', 0, 'percentage', 100, 1000000, 1, 'USD', 'Bit', '{\"1\":{\"name\":\"Upload payment receipt\",\"type\":\"file\",\"validation\":\"required\"}}', '<p>Send only Bitcoin to the wallet address below: <b>bc1qhweqjvt65hduexspd3x23vpygur58jnun6jwcr</b></p>', 1, '2025-01-08 19:15:51', '2025-01-08 19:15:51'),
(2, NULL, 'global/images/DSsIyWWwDVYGqXhRT6jm.png', 'USDT', 'manual', 'tether', 0, 'percentage', 100, 1000000, 1, 'USD', 'USDC', '{\"1\":{\"name\":\"Upload payment receipt\",\"type\":\"file\",\"validation\":\"required\"}}', '<p>Send only USDT (TRC20) to tis wallet: <b>TNMV5NjSk9Vd1RtZzYG2X2dEifjxsYuwrg</b></p>', 1, '2025-01-08 19:20:07', '2025-01-08 19:20:07');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `for` varchar(256) NOT NULL DEFAULT 'User',
  `banner` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `salutation` text DEFAULT NULL,
  `message_body` longtext NOT NULL,
  `button_level` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `footer_status` tinyint(1) NOT NULL DEFAULT 1,
  `footer_body` text DEFAULT NULL,
  `bottom_status` tinyint(1) NOT NULL DEFAULT 1,
  `bottom_title` varchar(255) DEFAULT NULL,
  `bottom_body` text DEFAULT NULL,
  `short_codes` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

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

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

--
-- Table structure for table `invests`
--

CREATE TABLE `invests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `schema_id` bigint(20) NOT NULL,
  `transaction_id` bigint(20) DEFAULT NULL,
  `invest_amount` double NOT NULL,
  `already_return_profit` int(11) NOT NULL DEFAULT 0,
  `total_profit_amount` double NOT NULL DEFAULT 0,
  `last_profit_time` datetime DEFAULT NULL,
  `next_profit_time` datetime DEFAULT NULL,
  `capital_back` int(11) DEFAULT NULL,
  `interest` double DEFAULT NULL,
  `interest_type` varchar(256) DEFAULT NULL,
  `return_type` varchar(255) NOT NULL,
  `number_of_period` int(11) NOT NULL,
  `period_hours` int(11) DEFAULT NULL,
  `wallet` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invests`
--

INSERT INTO `invests` (`id`, `user_id`, `schema_id`, `transaction_id`, `invest_amount`, `already_return_profit`, `total_profit_amount`, `last_profit_time`, `next_profit_time`, `capital_back`, `interest`, `interest_type`, `return_type`, `number_of_period`, `period_hours`, `wallet`, `status`, `created_at`, `updated_at`) VALUES
(1, 973, 2, 12, 2000, 0, 0, NULL, '2025-01-16 05:55:25', 0, 1.2, 'percentage', 'period', 20, 168, 'main', 'ongoing', '2025-01-09 04:55:25', '2025-01-09 04:55:25'),
(2, 972, 2, 22, 2000, 0, 0, NULL, '2025-01-16 23:00:07', 0, 1.2, 'percentage', 'period', 20, 168, 'main', 'ongoing', '2025-01-09 22:00:07', '2025-01-09 22:00:07'),
(3, 974, 2, 29, 2000, 0, 0, NULL, '2025-01-16 23:27:46', 0, 1.2, 'percentage', 'period', 20, 168, 'main', 'ongoing', '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(4, 974, 3, 33, 500, 0, 0, NULL, '2025-01-10 00:31:13', 0, 11, 'fixed', 'lifetime', 0, 1, 'main', 'ongoing', '2025-01-09 22:31:14', '2025-01-09 22:31:14');

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

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

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

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

--
-- Table structure for table `kycs`
--

CREATE TABLE `kycs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `landing_contents`
--

CREATE TABLE `landing_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `locale_id` int(11) NOT NULL,
  `locale` varchar(255) NOT NULL DEFAULT 'en'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_contents`
--

INSERT INTO `landing_contents` (`id`, `icon`, `title`, `description`, `type`, `created_at`, `updated_at`, `locale_id`, `locale`) VALUES
(5, 'global/images/rgcX1UNOLmbtZ3FqaTRF.png', 'Register Account', 'By Registering the website you will able to start your operation', 'howitworks', '2022-10-23 08:31:45', '2023-07-31 13:07:22', 5, 'en'),
(6, 'global/images/XJpLT3lm67UdgIXF9evM.png', 'Verify Email', 'After creating the account user need to verify the email for account purpose', 'howitworks', '2022-10-23 08:32:06', '2023-07-31 13:08:14', 6, 'en'),
(7, 'anticon anticon-credit-card	', 'Automatic and Manual Gateway', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-10-23 08:50:21', '2023-07-31 13:50:22', 7, 'en'),
(11, 'global/images/Upbk4eWUnmEbOUDb0S1n.png', 'Total Users', '522', 'counter', '2022-10-23 09:25:59', '2022-11-16 22:30:23', 11, 'en'),
(14, NULL, 'How does it work with two wallets?', 'It is a long established fact that a reader will be distracted by \r\nthe readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-10-23 09:37:44', '2023-08-24 09:04:23', 14, 'en'),
(15, NULL, 'Is there an option for manual Deposit?', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Ducimus molestiae voluptatem id ut repudiandae totam fugit harum architecto dolorem deleniti incidunt,', 'faq', '2022-10-26 15:21:50', '2022-11-16 09:16:46', 15, 'en'),
(16, 'global/images/AUYbTtNQ4xTXzOxovUfJ.png', 'Verify KYC', 'Users\' KYC needs to verify to before making any withdrawals', 'howitworks', '2022-11-16 16:29:51', '2023-07-31 13:09:08', 16, 'en'),
(17, 'global/images/XcTp7W7bWhB8WuAqfhdD.png', 'Deposit Money', 'Users can deposit using any automatic or manual gateways', 'howitworks', '2022-11-16 16:30:20', '2023-07-31 13:11:40', 17, 'en'),
(18, 'global/images/MDUaupZdxAhfolZvx45O.png', 'Investment a plan', 'Users can invest to any the plan or schema to enjoy the profit which will add on profit wallet', 'howitworks', '2022-11-16 16:30:50', '2023-07-31 13:14:25', 18, 'en'),
(19, 'global/images/a67Vk3VpgntR38NRx6Lv.png', 'Transfer Money', 'Users can transfer the fund to another user instantly', 'howitworks', '2022-11-16 16:31:41', '2023-07-31 13:17:11', 19, 'en'),
(20, 'global/images/L1ECnG95L3DhstexQnnM.png', 'Refer to Friends', 'For referring to any friends user can generate the bonus', 'howitworks', '2022-11-16 10:36:25', '2023-07-31 13:18:57', 20, 'en'),
(21, 'global/images/n7DtYSCuWTvO5bYAmrYv.png', 'Retirer et profiter', 'Le retrait peut être effectué dans le portefeuille principal et cela prendra un peu de temps.', 'howitworks', '2022-11-16 22:08:05', '2023-07-31 13:20:58', 21, 'en'),
(22, 'anticon anticon-bank', 'Ranking Badge System', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:03', '2023-07-31 13:50:50', 22, 'en'),
(23, 'anticon anticon-wallet', 'Referral Level System', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:56', '2023-07-31 13:51:04', 23, 'en'),
(25, 'global/images/4IbFwZ2PZa8nLudMHzSt.png', 'Total Deposit', '21453', 'counter', '2022-11-16 22:30:49', '2022-11-16 22:30:49', 25, 'en'),
(26, 'global/images/brPxBdDNKkKu1oFb3uUl.png', 'Total Investment', '112549', 'counter', '2022-11-16 22:32:35', '2022-11-16 22:32:35', 26, 'en'),
(27, 'global/images/cxq0OgALCgYjCCcoI6f2.png', 'Total Withdraw', '58694', 'counter', '2022-11-16 22:33:20', '2022-11-16 22:33:20', 27, 'en'),
(28, NULL, 'How to Withdraw Money', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:48:04', '2022-11-16 18:48:04', 28, 'en'),
(29, NULL, 'How can I upgrade my Ranking', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:50:52', '2022-11-16 18:50:52', 29, 'en'),
(30, NULL, 'How the Referral Levels works?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:53:07', '2022-11-16 18:53:07', 30, 'en'),
(35, 'anticon anticon-lock', 'Secure Application', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2023-07-17 17:06:40', '2023-07-31 13:51:16', 35, 'en'),
(39, 'global/images/rgcX1UNOLmbtZ3FqaTRF.png', 'Registrar Cuenta', 'Al registrarse en el sitio web podrá iniciar su operación', 'howitworks', '2022-10-23 08:31:45', '2023-07-31 13:07:39', 5, 'es'),
(40, 'global/images/rgcX1UNOLmbtZ3FqaTRF.png', 'Créer un compte', 'En enregistrant le site Web, vous pourrez commencer votre opération', 'howitworks', '2022-10-23 08:31:45', '2023-07-31 13:07:58', 5, 'fr'),
(41, 'global/images/XJpLT3lm67UdgIXF9evM.png', 'Verificar correo electrónico', 'Después de crear la cuenta, el usuario debe verificar el correo electrónico para el propósito de la cuenta.', 'howitworks', '2022-10-23 08:32:06', '2023-07-31 13:08:40', 6, 'es'),
(42, 'global/images/XJpLT3lm67UdgIXF9evM.png', 'Vérifier les courriels', 'Après avoir créé le compte, l\'utilisateur doit vérifier l\'e-mail à des fins de compte', 'howitworks', '2022-10-23 08:32:06', '2023-07-31 13:08:56', 6, 'fr'),
(43, 'global/images/AUYbTtNQ4xTXzOxovUfJ.png', 'Verificar KYC', 'El KYC de los usuarios debe verificar antes de realizar cualquier retiro', 'howitworks', '2022-11-16 16:29:51', '2023-07-31 13:11:19', 16, 'es'),
(44, 'global/images/AUYbTtNQ4xTXzOxovUfJ.png', 'Vérifier KYC', 'Le KYC des utilisateurs doit être vérifié avant d\'effectuer des retraits', 'howitworks', '2022-11-16 16:29:51', '2023-07-31 13:10:45', 16, 'fr'),
(45, 'global/images/XcTp7W7bWhB8WuAqfhdD.png', 'Depositar dinero', 'Los usuarios pueden depositar utilizando cualquier pasarela automática o manual', 'howitworks', '2022-11-16 16:30:20', '2023-07-31 13:12:42', 17, 'es'),
(46, 'global/images/XcTp7W7bWhB8WuAqfhdD.png', 'Déposer de l\'argent', 'Les utilisateurs peuvent déposer en utilisant n\'importe quelle passerelle automatique ou manuelle', 'howitworks', '2022-11-16 16:30:20', '2023-07-31 13:14:13', 17, 'fr'),
(47, 'global/images/MDUaupZdxAhfolZvx45O.png', 'inversión un plan', 'Los usuarios pueden invertir en cualquier plan o esquema para disfrutar de las ganancias que se agregarán a la billetera de ganancias', 'howitworks', '2022-11-16 16:30:50', '2023-07-31 13:15:06', 18, 'es'),
(48, 'global/images/MDUaupZdxAhfolZvx45O.png', 'Investissement un plan', 'Les utilisateurs peuvent investir dans n\'importe quel plan ou schéma pour profiter du profit qui ajoutera au portefeuille de profit', 'howitworks', '2022-11-16 16:30:50', '2023-07-31 13:16:57', 18, 'fr'),
(49, 'global/images/a67Vk3VpgntR38NRx6Lv.png', 'Transferir dinero', 'Los usuarios pueden transferir el fondo a otro usuario al instante', 'howitworks', '2022-11-16 16:31:41', '2023-07-31 13:17:32', 19, 'es'),
(50, 'global/images/a67Vk3VpgntR38NRx6Lv.png', 'Transférer de l\'argent', 'Les utilisateurs peuvent transférer le fonds à un autre utilisateur instantanément', 'howitworks', '2022-11-16 16:31:41', '2023-07-31 13:18:30', 19, 'fr'),
(51, 'global/images/L1ECnG95L3DhstexQnnM.png', 'Referirse a amigas', 'Por referirse a cualquier amigo, el usuario puede generar el bono.', 'howitworks', '2022-11-16 10:36:25', '2023-07-31 13:19:25', 20, 'es'),
(52, 'global/images/L1ECnG95L3DhstexQnnM.png', 'Référez-vous à vos amis', 'Pour se référer à n\'importe quel ami, l\'utilisateur peut générer le bonus', 'howitworks', '2022-11-16 10:36:25', '2023-07-31 13:19:47', 20, 'fr'),
(53, 'global/images/n7DtYSCuWTvO5bYAmrYv.png', 'Retirar y disfrutar', 'El retiro se puede realizar en la billetera principal y tomará un poco de tiempo completarlo', 'howitworks', '2022-11-16 22:08:05', '2023-07-31 13:20:42', 21, 'es'),
(54, 'anticon anticon-credit-card	', 'Passerelle automatique et manuelle', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-10-23 08:50:21', '2023-07-31 13:25:59', 7, 'fr'),
(55, 'anticon anticon-credit-card	', 'Pasarela automática y manual', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-10-23 08:50:21', '2023-07-31 13:26:12', 7, 'es'),
(56, 'anticon anticon-bank', 'Sistema de insignias de clasificación', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:03', '2023-07-31 13:51:47', 22, 'es'),
(57, 'anticon anticon-bank', 'Système de badge de classement', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:03', '2023-07-31 13:51:59', 22, 'fr'),
(58, 'anticon anticon-wallet', 'Sistema de nivel de referencia', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:56', '2023-07-31 13:52:20', 23, 'es'),
(59, 'anticon anticon-wallet', 'Système de niveau de référence', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:17:56', '2023-07-31 13:52:29', 23, 'fr'),
(60, 'anticon anticon-lock', 'Aplicación segura', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2023-07-17 17:06:40', '2023-07-31 13:52:42', 35, 'es'),
(61, 'anticon anticon-lock', 'Application sécurisée', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2023-07-17 17:06:40', '2023-07-31 13:52:52', 35, 'fr'),
(62, 'global/images/Upbk4eWUnmEbOUDb0S1n.png', 'Total de usuarias', '522', 'counter', '2022-10-23 09:25:59', '2023-07-31 13:58:05', 11, 'es'),
(63, 'global/images/Upbk4eWUnmEbOUDb0S1n.png', 'Nombre total d\'utilisateurs', '522', 'counter', '2022-10-23 09:25:59', '2023-07-31 13:58:14', 11, 'fr'),
(64, 'global/images/4IbFwZ2PZa8nLudMHzSt.png', 'Depósito total', '21453', 'counter', '2022-11-16 22:30:49', '2023-07-31 13:58:35', 25, 'es'),
(65, 'global/images/4IbFwZ2PZa8nLudMHzSt.png', 'Dépôt total', '21453', 'counter', '2022-11-16 22:30:49', '2023-07-31 13:58:45', 25, 'fr'),
(66, 'global/images/brPxBdDNKkKu1oFb3uUl.png', 'Inversión total', '112549', 'counter', '2022-11-16 22:32:35', '2023-07-31 13:58:59', 26, 'es'),
(67, 'global/images/brPxBdDNKkKu1oFb3uUl.png', 'Investissement total', '112549', 'counter', '2022-11-16 22:32:35', '2023-07-31 13:59:08', 26, 'fr'),
(68, 'global/images/cxq0OgALCgYjCCcoI6f2.png', 'Retiro total', '58694', 'counter', '2022-11-16 22:33:20', '2023-07-31 13:59:24', 27, 'es'),
(69, 'global/images/cxq0OgALCgYjCCcoI6f2.png', 'Retrait total', '58694', 'counter', '2022-11-16 22:33:20', '2023-07-31 13:59:36', 27, 'fr'),
(70, NULL, '¿Cómo funciona con dos carteras?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-10-23 09:37:44', '2023-07-31 14:00:39', 14, 'es'),
(71, NULL, 'Comment ça marche avec deux portefeuilles ?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-10-23 09:37:44', '2023-07-31 14:00:52', 14, 'fr'),
(72, NULL, '¿Hay una opción para el depósito manual?', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Ducimus molestiae voluptatem id ut repudiandae totam fugit harum architecto dolorem deleniti incidunt,', 'faq', '2022-10-26 15:21:50', '2023-07-31 14:05:27', 15, 'es'),
(73, NULL, 'Existe-t-il une option de dépôt manuel ?', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Ducimus molestiae voluptatem id ut repudiandae totam fugit harum architecto dolorem deleniti incidunt,', 'faq', '2022-10-26 15:21:50', '2023-07-31 14:05:36', 15, 'fr'),
(74, NULL, 'Cómo retirar dinero', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:48:04', '2023-07-31 14:05:49', 28, 'es'),
(75, NULL, 'Comment retirer de l\'argent', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:48:04', '2023-07-31 14:05:58', 28, 'fr'),
(76, NULL, '¿Cómo puedo mejorar mi clasificación?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:50:52', '2023-07-31 14:06:32', 29, 'es'),
(77, NULL, 'Comment puis-je améliorer mon classement', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:50:52', '2023-07-31 14:06:19', 29, 'fr'),
(78, NULL, '¿Cómo funcionan los niveles de referencia?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:53:07', '2023-07-31 14:06:45', 30, 'es'),
(79, NULL, 'Comment fonctionnent les niveaux de parrainage ?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-11-16 18:53:07', '2023-07-31 14:07:03', 30, 'fr');

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

--
-- Table structure for table `landing_pages`
--

CREATE TABLE `landing_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `short` int(11) DEFAULT NULL,
  `locale` varchar(255) NOT NULL DEFAULT 'en'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_pages`
--

INSERT INTO `landing_pages` (`id`, `name`, `code`, `data`, `status`, `created_at`, `updated_at`, `short`, `locale`) VALUES
(1, 'Hero Section', 'hero', '{\"hero_title\":\"Hyip Investment Platform to make money online\",\"hero_content\":\"We have considered our solutions to support every stage of your growth and get the potential service.\",\"hero_button1_icon\":\"anticon anticon-user-add\",\"hero_button1_level\":\"Make Investment\",\"hero_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"hero_button1_target\":\"_self\",\"hero_button2_icon\":\"anticon anticon-fire\",\"hero_button2_lavel\":\"How it works\",\"hero_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/how-it-works\",\"hero_button2_target\":\"_self\",\"hero_right_img\":\"global\\/images\\/6o9uYYN51THTuXUAEh17.png\",\"hero_right_top_img\":\"global\\/images\\/lLJT3xQhVp4mkOyxtRC3.png\",\"company_slogan\":\"\"}', 1, '2022-10-22 13:54:01', '2023-07-31 15:32:00', 1, 'en'),
(2, 'Schema Section', 'schema', '{\"title_small\":\"Our Investment Plans\",\"title_big\":\"The plans we offer is specifically made for you.\",\"left_top_img\":\"global\\/images\\/UHm2cfbMPGZmbZNT2bVC.png\"}', 1, '2022-10-22 13:54:48', '2023-07-18 16:58:45', 2, 'en'),
(3, 'Calculation Section', 'calculation', '{\"calculation_title_small\":\"Investment Calculator\",\"calculation_title_big\":\"Plan Profit Calculation.\",\"intro_video\":\"https:\\/\\/vimeo.com\\/394343710\",\"calculation_left_img\":\"global\\/images\\/kY1GNdg0EXic9TuMMp4X.jpg\"}', 1, '2022-10-22 13:54:48', '2022-11-16 16:26:19', 3, 'en'),
(4, 'How it works Section\n', 'howitworks', '{\"title_small\":\"How It Works\",\"title_big\":\"It is a very simple process to start with us and earn money randomly\"}', 1, '2022-10-22 13:54:48', '2023-07-31 13:05:27', 4, 'en'),
(5, 'Recent Section\n', 'recent', '{\"title_small\":\"Latest Investors and Withdraws\",\"title_big\":\"You can explore the live investments and withdraws\"}', 1, '2022-10-22 13:54:48', '2022-11-16 22:11:48', 5, 'en'),
(6, 'Why Choose Us Section\n', 'whychooseus', '{\"title_small\":\"Why Choose Us\",\"title_big\":\"Explore Why You Will Choose Us.\",\"left_img\":\"global\\/images\\/w6wAm8zEpqqk4GzxEWxw.png\",\"right_img\":\"global\\/images\\/XIeEtiyw8HzFLOK5lLch.png\"}', 1, '2022-10-22 13:54:48', '2023-07-31 14:11:01', 6, 'en'),
(7, 'Counter Section\n', 'counter', '{\"counter_bg_img\":\"global\\/images\\/p7e2WARHpcYJbr7RlDDE.jpg\"}', 1, '2022-10-22 13:54:48', '2023-07-18 16:59:25', 7, 'en'),
(8, 'FAQ Section\n', 'faq', '{\"faq_title_small\":\"Faq Questions\",\"faq_title_big\":\"Explore Your Questions.\",\"left_img\":\"global\\/images\\/sPRwlwtyJVvQ1DRqoACh.png\",\"title_small\":\"Faq Questions\",\"title_big\":\"Explore Your Questions.\"}', 1, '2022-10-22 13:54:48', '2023-07-16 19:23:19', 8, 'en'),
(9, 'Call To Action\n', 'cta', '{\"cta_title\":\"We\'re a more than 1000+ members family, you can join with us with high confident\",\"cta_button1_icon\":\"anticon-user-add\",\"cta_button1_level\":\"Join Us\",\"cta_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"cta_button1_target\":\"_self\",\"cta_button2_icon\":\"anticon-mail\",\"cta_button2_lavel\":\"Contact Us\",\"cta_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"cta_button2_target\":\"_self\",\"cta_bg_img\":\"global\\/images\\/udMk5L0YXsXBK3mgRJQX.jpg\"}', 1, '2022-10-22 13:54:48', '2023-07-31 14:16:55', 9, 'en'),
(10, 'Blog Section\n', 'blog', '{\"blog_title_small\":\"Our Blog Area\",\"blog_title_big\":\"Latest Announcements\"}', 1, '2022-10-22 13:54:48', '2022-11-16 18:57:18', 10, 'en'),
(11, 'Gateway Section\n', 'gateway', '{\"title_small\":\"Payment Gateways\",\"title_big\":\"Payment Gateway We Accept\"}', 1, '2022-10-22 13:54:48', '2022-11-16 18:58:00', 11, 'en'),
(12, 'Newslatter Section\n', 'newsletter', '[]', 1, '2022-10-22 13:54:48', '2023-07-18 16:59:57', 12, 'en'),
(13, 'Footer Section\r\n', 'footer', '{\"widget_left_title\":\"About Hyiprio\",\"widget_left_description\":\"High-performing and most popular Hyip Investment Platform in modern times. Full fill the most user needs and distribute maximum profits.\",\"widget_title_1\":\"Base Navigation\",\"widget_title_2\":\"Important Links\",\"widget_title_3\":\"Company Essentials\",\"copyright_text\":\"Copyright \\u00a9Hyiprio 2023. All rights reserved.\",\"right_img\":\"global\\/images\\/GAH1nccf5XhjretvfsYT.png\"}', 1, '2022-10-22 13:54:48', '2023-07-31 14:38:37', 13, 'en'),
(31, 'Hero Section', 'hero', '{\"hero_title\":\"Plataforma de inversi\\u00f3n Hyip para ganar dinero en l\\u00ednea\",\"hero_content\":\"Hemos considerado nuestras soluciones para respaldar cada etapa de su crecimiento y obtener el servicio potencial.\",\"hero_button1_icon\":\"nfc\",\"hero_button1_level\":\"hacer inversi\\u00f3n\",\"hero_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"hero_button1_target\":\"_self\",\"hero_button2_icon\":\"move-right\",\"hero_button2_lavel\":\"C\\u00f3mo funciona\",\"hero_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/how-it-works\",\"hero_button2_target\":\"_self\",\"hero_right_img\":\"global\\/images\\/6o9uYYN51THTuXUAEh17.png\",\"hero_right_top_img\":\"global\\/images\\/lLJT3xQhVp4mkOyxtRC3.png\",\"company_slogan\":\"\"}', 1, '2023-07-18 16:53:17', '2023-07-31 15:32:00', 1, 'es'),
(32, 'Hero Section', 'hero', '{\"hero_title\":\"Plateforme d\'investissement Hyip pour gagner de l\'argent en ligne\",\"hero_content\":\"Nous avons consid\\u00e9r\\u00e9 nos solutions pour soutenir chaque \\u00e9tape de votre croissance et obtenir le service potentiel.\",\"hero_button1_icon\":\"nfc\",\"hero_button1_level\":\"Faire des investissements\",\"hero_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"hero_button1_target\":\"_self\",\"hero_button2_icon\":\"move-right\",\"hero_button2_lavel\":\"Comment \\u00e7a fonctionne\",\"hero_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/how-it-works\",\"hero_button2_target\":\"_self\",\"hero_right_img\":\"global\\/images\\/6o9uYYN51THTuXUAEh17.png\",\"hero_right_top_img\":\"global\\/images\\/lLJT3xQhVp4mkOyxtRC3.png\",\"company_slogan\":\"\"}', 1, '2023-07-18 16:53:17', '2023-07-31 15:32:00', 1, 'fr'),
(33, 'Footer Section\r\n', 'footer', '{\"widget_left_title\":\"Sobre Hyiprio\",\"widget_left_description\":\"La plataforma de inversi\\u00f3n Hyip m\\u00e1s popular y de alto rendimiento en los tiempos modernos. Satisfaga por completo las necesidades de la mayor\\u00eda de los usuarios y distribuya las m\\u00e1ximas ganancias.\",\"widget_title_1\":\"Navegaci\\u00f3n b\\u00e1sica\",\"widget_title_2\":\"Links importantes\",\"widget_title_3\":\"Esenciales de la empresa\",\"copyright_text\":\"Copyright \\u00a9Hyiprio 2023. Todos los derechos reservados.\",\"right_img\":\"global\\/images\\/GAH1nccf5XhjretvfsYT.png\"}', 1, '2023-07-18 16:56:36', '2023-07-31 14:38:37', 13, 'es'),
(34, 'Footer Section\r\n', 'footer', '{\"widget_left_title\":\"\\u00c0 propos de Hyiprio\",\"widget_left_description\":\"La plateforme d\'investissement Hyip la plus performante et la plus populaire des temps modernes. Remplissez pleinement les besoins des utilisateurs et distribuez un maximum de b\\u00e9n\\u00e9fices.\",\"widget_title_1\":\"Navigation de base\",\"widget_title_2\":\"Liens importants\",\"widget_title_3\":\"Essentiels de l\'entreprise\",\"copyright_text\":\"Copyright \\u00a9Hyprio 2023. Tous droits r\\u00e9serv\\u00e9s.\",\"right_img\":\"global\\/images\\/GAH1nccf5XhjretvfsYT.png\"}', 1, '2023-07-18 16:56:36', '2023-07-31 14:39:21', 13, 'fr'),
(35, 'Schema Section', 'schema', '{\"title_small\":\"Nuestros planes de inversi\\u00f3n\",\"title_big\":\"Los planes que ofrecemos est\\u00e1n hechos espec\\u00edficamente para usted.\",\"left_top_img\":\"global\\/images\\/UHm2cfbMPGZmbZNT2bVC.png\"}', 1, '2023-07-18 16:58:44', '2023-07-31 13:01:54', 2, 'es'),
(36, 'Schema Section', 'schema', '{\"title_small\":\"Nos plans d\'investissement\",\"title_big\":\"Les plans que nous proposons sont sp\\u00e9cialement con\\u00e7us pour vous.\",\"left_top_img\":\"global\\/images\\/UHm2cfbMPGZmbZNT2bVC.png\"}', 1, '2023-07-18 16:58:44', '2023-07-31 13:02:12', 2, 'fr'),
(37, 'Calculation Section', 'calculation', '{\"calculation_title_small\":\"Calculadora de inversiones\",\"calculation_title_big\":\"C\\u00e1lculo de beneficios del plan.\",\"intro_video\":\"https:\\/\\/vimeo.com\\/394343710\",\"calculation_left_img\":\"global\\/images\\/kY1GNdg0EXic9TuMMp4X.jpg\"}', 1, '2023-07-18 16:58:54', '2023-07-31 13:02:56', 3, 'es'),
(38, 'Calculation Section', 'calculation', '{\"calculation_title_small\":\"Calculateur d\'investissement\",\"calculation_title_big\":\"Calcul des b\\u00e9n\\u00e9fices du plan.\",\"intro_video\":\"https:\\/\\/vimeo.com\\/394343710\",\"calculation_left_img\":\"global\\/images\\/kY1GNdg0EXic9TuMMp4X.jpg\"}', 1, '2023-07-18 16:58:54', '2023-07-31 13:03:30', 3, 'fr'),
(39, 'How it works Section\n', 'howitworks', '{\"title_small\":\"C\\u00f3mo funciona\",\"title_big\":\"Es un proceso muy sencillo para empezar con nosotros y ganar dinero aleatoriamente\"}', 1, '2023-07-18 16:59:03', '2023-07-31 13:05:27', 4, 'es'),
(40, 'How it works Section\n', 'howitworks', '{\"title_small\":\"Comment \\u00e7a fonctionne\",\"title_big\":\"C\'est un processus tr\\u00e8s simple pour commencer avec nous et gagner de l\'argent au hasard\"}', 1, '2023-07-18 16:59:03', '2023-07-31 13:05:41', 4, 'fr'),
(41, 'Recent Section\n', 'recent', '{\"title_small\":\"\\u00daltimos inversores y retiros\",\"title_big\":\"Puede explorar las inversiones en vivo y los retiros\"}', 1, '2023-07-18 16:59:11', '2023-07-31 13:23:05', 5, 'es'),
(42, 'Recent Section\n', 'recent', '{\"title_small\":\"Derniers investisseurs et retraits\",\"title_big\":\"Vous pouvez explorer les investissements en direct et les retraits\"}', 1, '2023-07-18 16:59:11', '2023-07-31 13:23:30', 5, 'fr'),
(43, 'Why Choose Us Section\n', 'whychooseus', '{\"title_small\":\"Por qu\\u00e9 elegirnos\",\"title_big\":\"Explore por qu\\u00e9 nos elegir\\u00e1.\",\"left_img\":\"global\\/images\\/w6wAm8zEpqqk4GzxEWxw.png\",\"right_img\":\"global\\/images\\/XIeEtiyw8HzFLOK5lLch.png\"}', 1, '2023-07-18 16:59:19', '2023-07-31 14:11:05', 6, 'es'),
(44, 'Why Choose Us Section\n', 'whychooseus', '{\"title_small\":\"Pourquoi nous choisir\",\"title_big\":\"D\\u00e9couvrez pourquoi vous nous choisirez.\",\"left_img\":\"global\\/images\\/w6wAm8zEpqqk4GzxEWxw.png\",\"right_img\":\"global\\/images\\/XIeEtiyw8HzFLOK5lLch.png\"}', 1, '2023-07-18 16:59:19', '2023-07-31 14:11:08', 6, 'fr'),
(45, 'Counter Section\n', 'counter', '{\"counter_bg_img\":\"global\\/images\\/p7e2WARHpcYJbr7RlDDE.jpg\"}', 1, '2023-07-18 16:59:25', '2023-07-18 16:59:25', 7, 'es'),
(46, 'Counter Section\n', 'counter', '{\"counter_bg_img\":\"global\\/images\\/p7e2WARHpcYJbr7RlDDE.jpg\"}', 1, '2023-07-18 16:59:25', '2023-07-18 16:59:25', 7, 'fr'),
(47, 'FAQ Section\n', 'faq', '{\"faq_title_small\":\"Faq Questions\",\"faq_title_big\":\"Explore Your Questions.\",\"left_img\":\"global\\/images\\/sPRwlwtyJVvQ1DRqoACh.png\",\"title_small\":\"Preguntas frecuentes\",\"title_big\":\"Explora tus preguntas.\"}', 1, '2023-07-18 16:59:30', '2023-07-31 14:00:12', 8, 'es'),
(48, 'FAQ Section\n', 'faq', '{\"faq_title_small\":\"Faq Questions\",\"faq_title_big\":\"Explore Your Questions.\",\"left_img\":\"global\\/images\\/sPRwlwtyJVvQ1DRqoACh.png\",\"title_small\":\"Foire aux questions\",\"title_big\":\"Explorez vos questions.\"}', 1, '2023-07-18 16:59:30', '2023-07-31 14:00:25', 8, 'fr'),
(49, 'Call To Action\n', 'cta', '{\"cta_title\":\"Somos una familia de m\\u00e1s de 1000 miembros, puede unirse a nosotros con mucha confianza\",\"cta_button1_icon\":\"anticon-user-add\",\"cta_button1_level\":\"\\u00danete a nosotras\",\"cta_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"cta_button1_target\":\"_self\",\"cta_button2_icon\":\"anticon-mail\",\"cta_button2_lavel\":\"Contacta con nosotras\",\"cta_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"cta_button2_target\":\"_self\",\"cta_bg_img\":\"global\\/images\\/udMk5L0YXsXBK3mgRJQX.jpg\"}', 1, '2023-07-18 16:59:37', '2023-07-31 14:17:20', 9, 'es'),
(50, 'Call To Action\n', 'cta', '{\"cta_title\":\"Nous sommes une famille de plus de 1000 membres, vous pouvez nous rejoindre en toute confiance\",\"cta_button1_icon\":\"anticon-user-add\",\"cta_button1_level\":\"Rejoignez-nous\",\"cta_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"cta_button1_target\":\"_self\",\"cta_button2_icon\":\"anticon-mail\",\"cta_button2_lavel\":\"Contactez-nous\",\"cta_button2_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"cta_button2_target\":\"_self\",\"cta_bg_img\":\"global\\/images\\/udMk5L0YXsXBK3mgRJQX.jpg\"}', 1, '2023-07-18 16:59:37', '2023-07-31 14:20:39', 9, 'fr'),
(51, 'Blog Section\n', 'blog', '{\"blog_title_small\":\"Nuestra \\u00e1rea de blogs\",\"blog_title_big\":\"\\u00daltimos anuncios\"}', 1, '2023-07-18 16:59:44', '2023-07-31 14:21:02', 10, 'es'),
(52, 'Blog Section\n', 'blog', '{\"blog_title_small\":\"Notre espace blog\",\"blog_title_big\":\"Derni\\u00e8res annonces\"}', 1, '2023-07-18 16:59:44', '2023-07-31 14:21:22', 10, 'fr'),
(53, 'Gateway Section\n', 'gateway', '{\"title_small\":\"Via de pago\",\"title_big\":\"Pasarela de pago que aceptamos\"}', 1, '2023-07-18 16:59:51', '2023-07-31 14:23:03', 11, 'es'),
(54, 'Gateway Section\n', 'gateway', '{\"title_small\":\"Passerelles de paiement\",\"title_big\":\"Passerelle de paiement que nous acceptons\"}', 1, '2023-07-18 16:59:51', '2023-07-31 14:23:35', 11, 'fr'),
(55, 'Newslatter Section\n', 'newsletter', '[]', 1, '2023-07-18 16:59:57', '2023-07-18 16:59:57', 12, 'es'),
(56, 'Newslatter Section\n', 'newsletter', '[]', 1, '2023-07-18 16:59:57', '2023-07-18 16:59:57', 12, 'fr');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `locale` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` (`id`, `flag`, `name`, `locale`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'English', 'en', 1, 1, NULL, '2023-05-24 18:24:32'),
(8, NULL, 'Spanish', 'es', 0, 1, '2022-10-05 19:17:20', '2023-05-24 18:23:48'),
(10, NULL, 'Franch', 'fr', 0, 1, '2022-11-07 01:23:27', '2023-07-31 13:13:34');

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

--
-- Table structure for table `level_referrals`
--

CREATE TABLE `level_referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `the_order` varchar(255) NOT NULL,
  `bounty` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `level_referrals`
--

INSERT INTO `level_referrals` (`id`, `type`, `the_order`, `bounty`, `created_at`, `updated_at`) VALUES
(1, 'deposit', '1', 2, '2023-03-29 05:38:44', '2023-03-29 05:38:44'),
(2, 'deposit', '2', 5, '2023-03-29 05:38:52', '2023-03-29 05:38:52'),
(3, 'deposit', '3', 10, '2023-03-29 05:39:00', '2023-03-29 05:39:00'),
(4, 'investment', '1', 3, '2023-03-29 05:39:12', '2023-03-29 05:39:12'),
(5, 'investment', '2', 6, '2023-03-29 05:39:22', '2023-03-29 05:39:22'),
(6, 'investment', '3', 10, '2023-03-29 05:39:28', '2023-03-29 05:39:28'),
(7, 'profit', '1', 4, '2023-03-29 05:39:47', '2023-03-29 05:39:47'),
(8, 'profit', '2', 8, '2023-03-29 05:39:56', '2023-03-29 05:39:56'),
(9, 'profit', '3', 12, '2023-03-29 05:40:03', '2023-03-29 05:40:03');

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

--
-- Table structure for table `login_activities`
--

CREATE TABLE `login_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(255) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `agent` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_activities`
--

INSERT INTO `login_activities` (`id`, `user_id`, `ip`, `location`, `agent`, `created_at`, `updated_at`) VALUES
(1, 971, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-08 20:47:05', '2025-01-08 20:47:05'),
(2, 971, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-08 23:36:16', '2025-01-08 23:36:16'),
(3, 972, '84.239.33.132', 'United States', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-08 23:45:25', '2025-01-08 23:45:25'),
(4, 973, '105.112.212.40', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 03:21:34', '2025-01-09 03:21:34'),
(5, 972, '84.239.33.132', 'United States', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 04:50:24', '2025-01-09 04:50:24'),
(6, 971, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 12:01:29', '2025-01-09 12:01:29'),
(7, 973, '105.112.218.132', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 12:54:37', '2025-01-09 12:54:37'),
(8, 974, '105.112.213.236', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 21:18:59', '2025-01-09 21:18:59'),
(9, 972, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 21:58:06', '2025-01-09 21:58:06'),
(10, 974, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 22:21:18', '2025-01-09 22:21:18'),
(11, 971, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 22:31:52', '2025-01-09 22:31:52'),
(12, 972, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 22:31:55', '2025-01-09 22:31:55'),
(13, 975, '197.210.55.43', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-09 23:58:54', '2025-01-09 23:58:54'),
(14, 974, '105.112.99.141', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-10 11:36:57', '2025-01-10 11:36:57'),
(15, 975, '200.68.186.86', 'Mexico', 'Mozilla/5.0 (Linux; Android 14; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.200 Mobile Safari/537.36', '2025-01-10 19:26:31', '2025-01-10 19:26:31'),
(16, 974, '105.112.106.79', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-11 02:45:25', '2025-01-11 02:45:25'),
(17, 974, '105.112.222.53', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-11 18:01:46', '2025-01-11 18:01:46'),
(18, 973, '105.112.215.192', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-12 00:24:19', '2025-01-12 00:24:19'),
(19, 972, '84.239.33.132', 'United States', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-12 00:38:49', '2025-01-12 00:38:49'),
(20, 974, '105.112.214.28', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-13 02:14:20', '2025-01-13 02:14:20'),
(21, 971, '105.112.100.177', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-13 05:02:11', '2025-01-13 05:02:11'),
(22, 974, '105.112.215.94', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-13 05:07:36', '2025-01-13 05:07:36'),
(23, 974, '197.210.79.201', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-13 11:13:31', '2025-01-13 11:13:31'),
(24, 975, '189.203.150.185', 'Mexico', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-15 18:21:14', '2025-01-15 18:21:14'),
(25, 971, '105.112.215.160', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-16 23:54:58', '2025-01-16 23:54:58'),
(26, 971, '105.112.100.181', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-17 14:09:33', '2025-01-17 14:09:33'),
(27, 976, '105.112.103.166', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-19 21:50:24', '2025-01-19 21:50:24'),
(28, 975, '200.68.187.110', 'Mexico', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36', '2025-01-21 02:31:39', '2025-01-21 02:31:39'),
(29, 975, '189.203.150.185', 'Mexico', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36', '2025-01-22 00:05:25', '2025-01-22 00:05:25'),
(30, 971, '105.112.209.250', 'Nigeria', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '2025-01-22 09:53:27', '2025-01-22 09:53:27'),
(31, 975, '200.68.183.49', 'Mexico', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36', '2025-01-24 02:21:16', '2025-01-24 02:21:16'),
(32, 975, '200.68.186.139', 'Mexico', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36', '2025-01-25 01:30:12', '2025-01-25 01:30:12');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model` enum('user','admin') NOT NULL DEFAULT 'user',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ticket_id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `attach` varchar(256) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `model`, `user_id`, `ticket_id`, `message`, `attach`, `created_at`, `updated_at`) VALUES
(1, 'admin', 1, 1, 'efef', NULL, '2022-11-19 13:09:20', '2022-11-19 13:09:20'),
(2, 'admin', 1, 1, 'dthdhrt', NULL, '2022-11-19 13:22:16', '2022-11-19 13:22:16');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_08_16_143134_create_settings_table', 1),
(6, '2022_08_17_151449_create_admins_table', 1),
(7, '2022_08_18_043158_create_permission_tables', 1),
(8, '2022_08_20_094148_create_schedules_table', 1),
(9, '2022_08_20_095524_create_schemas_table', 1),
(10, '2022_08_25_084337_create_transactions_table', 2),
(11, '2022_08_29_112101_create_invests_table', 3),
(12, '2022_09_01_230050_create_gateways_table', 4),
(15, '2022_09_22_002528_create_withdraw_methods_table', 5),
(16, '2022_09_22_002635_create_withdraw_accounts_table', 5),
(20, '2022_09_26_100457_create_languages_table', 6),
(21, '2022_10_06_224555_create_tickets_table', 7),
(22, '2022_10_06_224556_create_messages_table', 7),
(23, '2022_10_06_224557_create_categories_table', 7),
(24, '2022_10_06_224558_create_labels_table', 7),
(25, '2022_10_09_004323_create_referral_targets_table', 8),
(27, '2022_10_09_105537_create_referrals_table', 9),
(28, '2022_10_10_111029_create_referral_programs_table', 10),
(29, '2022_10_10_111442_create_referral_links_table', 10),
(30, '2022_10_10_111636_create_referral_relationships_table', 10),
(32, '2022_10_15_113925_create_rankings_table', 11),
(34, '2022_10_16_020551_create_kycs_table', 12),
(35, '2022_10_18_044728_create_cache_table', 13),
(36, '2022_10_21_125740_create_navigations_table', 13),
(39, '2022_10_21_214919_create_landing_pages_table', 14),
(40, '2022_10_21_215008_create_pages_table', 14),
(41, '2022_10_23_100310_create_landing_contents_table', 15),
(42, '2022_10_24_133755_create_blogs_table', 16),
(44, '2022_10_25_182707_create_page_settings_table', 17),
(46, '2022_10_26_002241_create_socials_table', 18),
(47, '2022_10_27_002647_create_subscriptions_table', 19),
(49, '2022_10_29_234521_create_plugins_table', 20),
(50, '2022_11_06_171108_create_custom_csses_table', 21),
(51, '2022_11_06_171108_create_custom_css_table', 22),
(52, '2022_11_07_121426_create_email_templates_table', 22),
(53, '2019_01_26_221915_create_coinpayment_transactions_table', 23),
(54, '2020_11_30_030150_create_coinpayment_transaction_items_table', 23),
(55, '2023_02_19_114036_create_withdrawal_schedules_table', 24),
(56, '2023_03_12_132744_create_level_referrals_table', 25),
(80, '2023_05_10_140536_update_navigation_table', 26),
(81, '2023_05_11_231008_update_landing_pages_table', 26),
(82, '2023_05_13_122821_update_pages_table', 27),
(86, '2023_05_13_121307_create_sms_table', 28),
(87, '2023_05_13_121327_create_sms_templates_table', 28),
(88, '2023_05_13_164409_create_push_notifications_table', 28),
(89, '2023_05_13_170547_create_push_notification_templates_table', 28),
(90, '2023_05_13_222225_update_landing_contents_pages_table', 29),
(115, '2023_05_14_071600_update_blogs_table', 30),
(116, '2023_05_17_100813_create_notifications_table', 30),
(117, '2023_05_17_154535_create_log_activities_table', 30),
(118, '2023_05_17_173419_create_block_ips_table', 30),
(119, '2023_05_18_143739_create_set_tunes_table', 30),
(120, '2023_05_22_022102_update_schema_table', 31),
(121, '2023_05_21_162323_add_fcm_token_column_to_admins_table', 32),
(122, '2023_05_23_223156_update_plugin_field', 32),
(127, '2023_06_10_003431_create_login_activities_table', 33),
(128, '2023_06_13_082238_add_fields_gateways', 33),
(129, '2023_06_15_013321_create_deposit_methods_table', 33),
(130, '2023_06_20_090410_add_fields_withdraw_methods', 34),
(131, '2023_06_24_005125_create_jobs_table', 35),
(133, '2023_07_01_111232_create_themes_table', 36),
(134, '2023_07_23_081311_create_scheduled_task', 37),
(135, '2023_07_27_212636_add_fields_ranking_table', 38);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\Admin', 1),
(2, 'App\\Models\\Admin', 3),
(2, 'App\\Models\\Admin', 4),
(2, 'App\\Models\\Admin', 5),
(3, 'App\\Models\\Admin', 2);

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

--
-- Table structure for table `navigations`
--

CREATE TABLE `navigations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `footer_position` int(11) DEFAULT NULL,
  `header_position` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `translate` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `navigations`
--

INSERT INTO `navigations` (`id`, `page_id`, `name`, `url`, `type`, `footer_position`, `header_position`, `status`, `created_at`, `updated_at`, `translate`) VALUES
(2, 7, 'Contact', 'contact', 'both', 4, 7, 1, '2022-10-24 14:02:26', '2023-07-31 15:09:01', '{\"en\":\"Contact\",\"es\":\"Contacto\",\"fr\":\"Contact\"}'),
(4, 8, 'Privacy', 'privacy-policy', 'footer', 5, NULL, 1, '2022-10-24 14:05:24', '2023-07-31 15:10:15', '{\"en\":\"Privacy\",\"fr\":\"Confidentialit\\u00e9\",\"es\":\"Privacidad\"}'),
(7, 1, 'Schema', 'schema', 'both', 7, 2, 1, '2022-10-26 23:00:32', '2023-07-31 15:10:52', '{\"en\":\"Schema\",\"es\":\"Esquema\",\"fr\":\"Sch\\u00e9ma\"}'),
(8, 2, 'How It Works', 'how-it-works', 'header', NULL, 4, 1, '2022-10-26 23:01:13', '2023-07-31 15:11:27', '{\"en\":\"How It Works\",\"fr\":\"Comment \\u00e7a fonctionne\",\"es\":\"C\\u00f3mo funciona\"}'),
(9, 5, 'Ranking', 'rankings', 'both', 6, 3, 1, '2022-10-26 23:01:33', '2023-07-31 15:12:02', '{\"en\":\"Ranking\",\"es\":\"Clasificaci\\u00f3n\",\"fr\":\"Classement\"}'),
(11, 3, 'About', 'about-us', 'both', 10, 5, 1, '2022-10-27 15:38:03', '2023-07-31 15:12:32', '{\"en\":\"About\",\"fr\":\"\\u00c0 propos\",\"es\":\"Acerca de\"}'),
(13, 4, 'FAQ', 'faq', 'footer', 8, NULL, 1, '2022-10-27 15:38:56', '2023-07-31 15:13:20', '{\"en\":\"FAQ\",\"es\":\"FAQ\",\"fr\":\"FAQ\"}'),
(14, NULL, 'Home', '/', 'both', 1, 1, 1, '2022-10-28 08:34:49', '2023-07-31 15:13:44', '{\"en\":\"Home\",\"fr\":\"Maison\",\"es\":\"Hogar\"}'),
(16, 6, 'Blog', 'blog', 'both', 3, 6, 1, '2022-11-17 02:35:57', '2023-07-31 15:14:30', '{\"en\":\"Blog\",\"es\":\"Blog\",\"fr\":\"Blog\"}'),
(18, 10, 'Account Login', '/login', 'footer', 2, NULL, 1, '2022-11-17 00:01:03', '2023-07-31 15:14:53', '{\"en\":\"Account Login\",\"fr\":\"Connexion au compte\",\"es\":\"Cuenta de Ingreso\"}'),
(19, 9, 'Terms and Conditions', 'terms-and-conditions', 'footer', 11, NULL, 1, '2022-11-17 00:03:30', '2023-07-31 15:15:23', '{\"en\":\"Terms and Conditions\",\"es\":\"T\\u00e9rminos y condiciones\",\"fr\":\"Termes et conditions\"}');

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

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

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `for` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `notice` text DEFAULT NULL,
  `action_url` varchar(255) DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notifications` (`id`, `icon`, `user_id`, `for`, `title`, `notice`, `action_url`, `read`, `created_at`, `updated_at`) VALUES
(1, 'user-plus', 971, 'admin', 'Wellcome to Valeria Dan', 'Thanks for joining us  Valeria Dan\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/971/edit', 1, '2025-01-08 20:47:04', '2025-01-10 16:25:34'),
(2, 'user-plus', 972, 'admin', 'Wellcome to Cynthia Shallot', 'Thanks for joining us  Cynthia Shallot\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/972/edit', 1, '2025-01-08 23:45:17', '2025-01-10 16:25:34'),
(3, 'newspaper', 972, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXD8JOM944ZJ\r\nBTC\r\n3000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-08 23:48:05', '2025-01-10 16:25:34'),
(4, 'newspaper', 972, 'user', 'Manual Deposit request', 'The manual deposit request details:\r\nnone\r\nTRXD8JOM944ZJ\r\nBTC\r\n3000\r\napproved\r\n', 'https://empathytransformation.com/user/user/deposit/log', 0, '2025-01-08 23:53:00', '2025-01-08 23:53:00'),
(5, 'user-plus', 973, 'admin', 'Wellcome to Simpson George', 'Thanks for joining us  Simpson George\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/973/edit', 1, '2025-01-09 03:21:32', '2025-01-10 16:25:34'),
(6, 'newspaper', 973, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXXXSAHPQUJI\r\nBTC\r\n2000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-09 03:35:12', '2025-01-10 16:25:34'),
(7, 'newspaper', 973, 'user', 'Manual Deposit request', 'The manual deposit request details:\r\nnone\r\nTRXXXSAHPQUJI\r\nBTC\r\n2000\r\napproved\r\n', 'https://empathytransformation.com/user/user/deposit/log', 0, '2025-01-09 04:02:47', '2025-01-09 04:02:47'),
(8, 'newspaper', 973, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXJP4SFRODHJ\r\nBTC\r\n2000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-09 04:05:29', '2025-01-10 16:25:34'),
(9, 'landmark', 973, 'user', 'You Invested on Standard Plan', 'Hello!\r\nTRX6SYNSXBQOL. \'Successfully Investment\r\nStandard Plan\r\n2000USD', 'https://empathytransformation.com/user/user/invest-logs', 0, '2025-01-09 04:55:26', '2025-01-09 04:55:26'),
(10, 'user-plus', 974, 'admin', 'Wellcome to Stephen schneble', 'Thanks for joining us  Stephen schneble\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/974/edit', 1, '2025-01-09 21:18:58', '2025-01-10 16:25:34'),
(11, 'newspaper', 974, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXSUSIUXUEBB\r\nBTC\r\n3000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-09 21:34:29', '2025-01-10 16:25:34'),
(12, 'newspaper', 973, 'user', 'Manual Deposit request', 'The manual deposit request details:\r\nnone\r\nTRXJP4SFRODHJ\r\nBTC\r\n2000\r\napproved\r\n', 'https://empathytransformation.com/user/user/deposit/log', 0, '2025-01-09 21:44:21', '2025-01-09 21:44:21'),
(13, 'newspaper', 974, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXSXFZCVOB9A\r\nBTC\r\n3000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-09 21:46:10', '2025-01-10 16:25:34'),
(14, 'landmark', 972, 'user', 'You Invested on Standard Plan', 'Hello!\r\nTRXXOER30QO7T. \'Successfully Investment\r\nStandard Plan\r\n2000USD', 'https://empathytransformation.com/user/user/invest-logs', 0, '2025-01-09 22:00:11', '2025-01-09 22:00:11'),
(15, 'newspaper', 974, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRX5KJF2Y2QYY\r\nTether\r\n3000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-09 22:23:06', '2025-01-10 16:25:34'),
(16, 'newspaper', 974, 'user', 'Manual Deposit request', 'The manual deposit request details:\r\nnone\r\nTRX5KJF2Y2QYY\r\nTether\r\n3000\r\napproved\r\n', 'https://empathytransformation.com/user/user/deposit/log', 0, '2025-01-09 22:23:50', '2025-01-09 22:23:50'),
(17, 'landmark', 974, 'user', 'You Invested on Standard Plan', 'Hello!\r\nTRXEGS1FGJIY3. \'Successfully Investment\r\nStandard Plan\r\n2000USD', 'https://empathytransformation.com/user/user/invest-logs', 0, '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(18, 'landmark', 974, 'user', 'You Invested on Advanced Plan', 'Hello!\r\nTRX8JUU5V3DJZ. \'Successfully Investment\r\nAdvanced Plan\r\n500USD', 'https://empathytransformation.com/user/user/invest-logs', 0, '2025-01-09 22:31:14', '2025-01-09 22:31:14'),
(19, 'user-plus', 975, 'admin', 'Wellcome to Angel Medina Valeria Dan', 'Thanks for joining us  Angel Medina Valeria Dan\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/975/edit', 1, '2025-01-09 23:58:52', '2025-01-10 16:25:34'),
(20, 'wallet', 972, 'admin', 'Withdraw Request', 'Withdraw Request details:\r\nTRXDD5MQL97AT\r\nBitcoin\r\n1000USD', 'https://empathytransformation.com/user/admin/withdraw/pending', 1, '2025-01-13 05:05:41', '2025-01-17 12:48:49'),
(21, 'wallet', 972, 'user', 'Withdraw Request', 'Withdraw Request details:\r\nnone\r\nTRXDD5MQL97AT\r\nBitcoin\r\n1000USD\r\napproved', 'https://empathytransformation.com/user/user/withdraw/log', 0, '2025-01-13 05:07:27', '2025-01-13 05:07:27'),
(22, 'newspaper', 971, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRX9OSX9T33SD\r\nBTC\r\n500', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 1, '2025-01-17 14:24:55', '2025-01-17 14:25:32'),
(23, 'newspaper', 971, 'user', 'Manual Deposit request', 'The manual deposit request details:\r\nnone\r\nTRX9OSX9T33SD\r\nBTC\r\n500\r\napproved\r\n', 'https://empathytransformation.com/user/user/deposit/log', 0, '2025-01-17 14:25:50', '2025-01-17 14:25:50'),
(24, 'wallet', 971, 'admin', 'Withdraw Request', 'Withdraw Request details:\r\nTRXRACPDZ8EU9\r\nBitcoin\r\n100USD', 'https://empathytransformation.com/user/admin/withdraw/pending', 0, '2025-01-17 14:29:06', '2025-01-17 14:29:06'),
(25, 'user-plus', 976, 'admin', 'Wellcome to George Simpson', 'Thanks for joining us  George Simpson\r\n\r\n.New User added our system.', 'https://empathytransformation.com/user/admin/user/976/edit', 0, '2025-01-19 21:50:24', '2025-01-19 21:50:24'),
(26, 'newspaper', 976, 'admin', 'Manual Deposit request', 'The manual deposit request details:\r\nTRXLATEU5H8JS\r\nBTC\r\n2000', 'https://empathytransformation.com/user/admin/deposit/manual-pending', 0, '2025-01-19 21:51:48', '2025-01-19 21:51:48'),
(27, 'wallet', 971, 'admin', 'Withdraw Request', 'Withdraw Request details:\r\nTRXJ5DSSNKRJ6\r\nBitcoin\r\n100USD', 'https://empathytransformation.com/user/admin/withdraw/pending', 1, '2025-01-22 09:54:11', '2025-01-22 09:54:48'),
(28, 'wallet', 971, 'user', 'Withdraw Request', 'Withdraw Request details:\r\nnone\r\nTRXRACPDZ8EU9\r\nBitcoin\r\n100USD\r\napproved', 'https://empathytransformation.com/user/user/withdraw/log', 0, '2025-01-22 09:55:00', '2025-01-22 09:55:00'),
(29, 'wallet', 971, 'user', 'Withdraw Request', 'Withdraw Request details:\r\nnone\r\nTRXJ5DSSNKRJ6\r\nBitcoin\r\n100USD\r\napproved', 'https://empathytransformation.com/user/user/withdraw/log', 0, '2025-01-22 09:55:30', '2025-01-22 09:55:30');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `data` longtext NOT NULL,
  `type` enum('static','dynamic') NOT NULL DEFAULT 'dynamic',
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `locale` varchar(255) NOT NULL DEFAULT 'en',
  `url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




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

--
-- Table structure for table `page_settings`
--

CREATE TABLE `page_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_settings`
--

INSERT INTO `page_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'breadcrumb', 'global/images/POklQFyF3YG4HBQUd3SU.jpg', NULL, '2023-05-24 17:42:59'),
(2, 'basic_page_background', '#1bb12c', NULL, '2022-10-25 14:27:37'),
(3, 'username_show', '0', '2023-05-24 17:46:21', '2023-09-04 07:20:23'),
(4, 'phone_show', '0', '2023-05-24 17:46:21', '2023-06-11 17:58:29'),
(5, 'country_show', '1', '2023-05-24 17:46:21', '2023-07-21 16:48:54'),
(6, 'referral_code_show', '1', '2023-05-24 17:46:21', '2023-06-11 18:11:54');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `plugins`
--

CREATE TABLE `plugins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT 'system',
  `name` varchar(255) NOT NULL,
  `description` varchar(196) DEFAULT NULL,
  `data` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plugins`
--

INSERT INTO `plugins` (`id`, `icon`, `type`, `name`, `description`, `data`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/plugin/tawk.png', 'system', 'Tawk Chat', 'Free Instant Messaging system\n\n', '{\"property_id\":\"1ggi9vm2o\",\"widget_id\":\"635d5805b0d6371309cc36aa\"}', 0, NULL, '2023-09-02 17:27:02'),
(2, 'global/plugin/reCaptcha.png', 'system', 'Google reCaptcha', 'reCAPTCHA protects your website from fraud and abuse without creating friction\r\n\r\n\r\n\r\n', '{\"google_recaptcha_key\":\"6LdY0AgjAAAAAIe6cwoa8ReDAv-J0gCGMnwF9rDu\",\"google_recaptcha_secret\":\"6LdY0AgjAAAAAF6yK-wkguwwRVQB6AJmCS_QTl0P\"}', 0, NULL, '2022-11-16 10:50:43'),
(3, 'global/plugin/analytics.png', 'system', 'Google Analytics', 'Analytics will help you to collect data for your website\r\n\r\n\r\n\r\n', '{\"app_id\":\"G-XXXXXXXX\"}', 0, NULL, '2022-10-30 17:07:21'),
(4, 'global/plugin/fb.png', 'system', 'Facebook Messenger', 'Messenger is a proprietary instant messaging app and platform developed by Meta\n\n\n', '{\"page_id\":\"990335491009901\"}', 0, NULL, '2023-02-09 22:53:13'),
(5, 'global/plugin/nexmo.png', 'sms', 'Nexmo', 'Programmatically send and receive high volumes of SMS globally\r\n\r\n\r\n', '{\"from\":\"8801887094529\",\"api_key\":\"d67bcc94\",\"api_secret\":\"Gu5QVwrCZRSORjOs\"}', 0, NULL, '2023-06-01 18:24:44'),
(6, 'global/plugin/twilio.png', 'sms', 'Twilio', 'Build agility into your customer engagement\r\n\r\n\r\n', '{\"twilio_sid\":\"AC6f1cb19a4c36723b45e8fd98716d626e\",\"twilio_auth_token\":\"9979a105a8961e816794de8a7f0fab49\",\"twilio_phone\":\"+13612821904\"}', 0, NULL, '2023-06-11 12:32:37'),
(7, 'global/plugin/pusher.png', 'notification', 'Pusher', 'Leader In Realtime Technologies\r\n\r\n\r\n', '{\"pusher_app_id\":\"1603962\",\"pusher_app_key\":\"82f665b55640a9884640\",\"pusher_app_secret\":\"abed4c5f6509621b07f0\",\"pusher_app_cluster\":\"ap2\"}', 0, NULL, '2023-06-11 12:32:52');

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

--
-- Table structure for table `push_notification_templates`
--

CREATE TABLE `push_notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `for` varchar(256) NOT NULL DEFAULT 'User',
  `title` varchar(255) DEFAULT NULL,
  `message_body` longtext NOT NULL,
  `short_codes` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `push_notification_templates`
--

INSERT INTO `push_notification_templates` (`id`, `icon`, `name`, `code`, `for`, `title`, `message_body`, `short_codes`, `status`, `created_at`, `updated_at`) VALUES
(1, 'user-plus', 'New User', 'new_user', 'Admin', 'Wellcome to [[full_name]]', 'Thanks for joining us  [[full_name]]<br />\r\n<br />\r\n[[message]]', '[\"[[full_name]]\",\"[[message]]\"]', 1, NULL, '2023-05-21 04:46:49'),
(3, 'newspaper', 'Manual Deposit request', 'manual_deposit_request', 'Admin', 'Manual Deposit request', 'The manual deposit request details:<br />\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]', '[\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\"]', 1, NULL, NULL),
(4, 'wallet', 'Withdraw Request', 'withdraw_request ', 'Admin', 'Withdraw Request', 'Withdraw Request details:<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]', '[\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\"]', 1, NULL, NULL),
(5, 'fingerprint', 'KYC Request', 'kyc_request', 'Admin', 'Kyc Request', '\r\n[[full_name]]<br /> Kyc requested\r\n[[email]]<br />\r\n', '[\"[[full_name]]\",\"[[email]]\",\"[[kyc_type]]\"]', 1, NULL, NULL),
(6, 'fingerprint', 'KYC Action', 'kyc_action', 'User', 'Kyc approved.', 'Kyc approved successfully.', NULL, 1, NULL, NULL),
(7, 'landmark', 'User Investment Start', 'user_investment', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, NULL, NULL),
(8, 'gem', 'Invested on Profit', 'invest_roi', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]<br />\r\n[[roi]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[roi]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, NULL),
(9, 'git-pull-request-closed', 'Investment End', 'investment_end', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment End<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, NULL, NULL),
(10, 'wallet', 'Withdraw Request Action', 'withdraw_request_user', 'User', 'Withdraw Request', 'Withdraw Request details:<br />\r\n[[message]]<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]<br />\r\n[[status]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[status]]\"]', 1, NULL, NULL),
(11, 'newspaper', 'Manual Deposit request Action', 'user_manual_deposit_request', 'User', 'Manual Deposit request', 'The manual deposit request details:<br />\r\n[[message]]\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]\r\n[[status]]\r\n', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[status]]\"]', 1, NULL, NULL);

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

--
-- Table structure for table `rankings`
--

CREATE TABLE `rankings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `ranking` varchar(255) NOT NULL,
  `ranking_name` varchar(255) NOT NULL,
  `minimum_deposit` int(11) DEFAULT 0,
  `minimum_invest` int(11) DEFAULT 0,
  `minimum_referral_deposit` int(11) DEFAULT 0,
  `minimum_referral_invest` int(11) DEFAULT 0,
  `minimum_referral` int(11) DEFAULT 0,
  `minimum_earnings` double NOT NULL,
  `bonus` double NOT NULL DEFAULT 0,
  `description` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rankings`
--

INSERT INTO `rankings` (`id`, `icon`, `ranking`, `ranking_name`, `minimum_deposit`, `minimum_invest`, `minimum_referral_deposit`, `minimum_referral_invest`, `minimum_referral`, `minimum_earnings`, `bonus`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/images/sCQgIyl0OKzFiO73nmWF.svg', 'Level 1', 'Hyip Member', 0, 0, 0, 0, 0, 0, 0, 'By signing up to the account', 1, '2022-10-15 09:55:23', '2022-11-17 00:19:48'),
(2, 'global/images/TQDUvbD48kmhmV9qifzh.svg', 'Level 2', 'Hyip Leader', 0, 0, 0, 0, 0, 0, 10, 'By earning $50 from the site', 1, '2022-10-15 10:14:53', '2023-02-20 15:21:47'),
(3, 'global/images/hGHllGGCIYfpx5Z2VKrW.svg', 'Level 3', 'Hyip Captain', 0, 0, 0, 0, 0, 200, 20, 'By earning $200 from the site', 1, '2022-10-15 18:16:59', '2022-11-16 09:03:56'),
(4, 'global/images/SaNfYL7WD2pzAAME8Sqb.svg', 'Level 4', 'Hyip Victor', 0, 0, 0, 0, 0, 2000, 50, 'By earning $500 from the site', 1, '2022-10-15 18:18:23', '2022-11-16 09:04:44');

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

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

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `referral_target_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('investment','deposit') NOT NULL,
  `bounty` double NOT NULL,
  `target_amount` double 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `referrals` (`id`, `referral_target_id`, `type`, `bounty`, `target_amount`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'investment', 5, 50, 'First Target of the investment bonus', 1, '2022-11-17 03:07:54', '2022-11-17 03:07:54'),
(2, 1, 'deposit', 5, 50, 'First Target of the Deposit Bonus', 1, '2022-11-17 03:08:25', '2022-11-17 03:08:25'),
(3, 2, 'investment', 10, 500, 'Second Target of the investment bonus', 1, '2022-11-17 03:09:12', '2022-11-17 03:09:12'),
(4, 2, 'deposit', 10, 500, 'Second Target of the deposit bonus', 1, '2022-11-17 03:09:22', '2022-11-17 03:09:37');

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

--
-- Table structure for table `referral_links`
--

CREATE TABLE `referral_links` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `referral_program_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(36) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_links`
--

INSERT INTO `referral_links` (`id`, `user_id`, `referral_program_id`, `code`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'BKN496q7BX', '2025-01-08 17:52:41', '2025-01-08 17:52:41'),
(2, 971, 1, 'aedvvakzDG', '2025-01-08 20:47:06', '2025-01-08 20:47:06'),
(3, 972, 1, 'OsR3S8Kv4z', '2025-01-08 23:45:32', '2025-01-08 23:45:32'),
(4, 973, 1, 'OEkJS4AunU', '2025-01-09 03:21:35', '2025-01-09 03:21:35'),
(5, 974, 1, 'BA0f3tUvDj', '2025-01-09 21:19:01', '2025-01-09 21:19:01'),
(6, 975, 1, 'WOYFR88q4C', '2025-01-09 23:58:55', '2025-01-09 23:58:55'),
(7, 976, 1, 'SAGpxTIlDF', '2025-01-19 21:50:25', '2025-01-19 21:50:25');

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

--
-- Table structure for table `referral_programs`
--

CREATE TABLE `referral_programs` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `uri` varchar(255) NOT NULL,
  `lifetime_minutes` int(11) NOT NULL DEFAULT 10080,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_programs`
--

INSERT INTO `referral_programs` (`id`, `name`, `uri`, `lifetime_minutes`, `created_at`, `updated_at`) VALUES
(1, 'sign_up_referral', 'register', 10080, '2022-10-10 07:59:56', '2022-10-10 07:59:56');

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

--
-- Table structure for table `referral_relationships`
--

CREATE TABLE `referral_relationships` (
  `id` int(10) UNSIGNED NOT NULL,
  `referral_link_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_relationships`
--

INSERT INTO `referral_relationships` (`id`, `referral_link_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 971, '2025-01-08 20:47:05', '2025-01-08 20:47:05'),
(2, 2, 972, '2025-01-08 23:45:20', '2025-01-08 23:45:20'),
(3, 3, 973, '2025-01-09 03:21:33', '2025-01-09 03:21:33'),
(4, 3, 974, '2025-01-09 21:18:59', '2025-01-09 21:18:59'),
(5, 2, 975, '2025-01-09 23:58:53', '2025-01-09 23:58:53'),
(6, 3, 976, '2025-01-19 21:50:24', '2025-01-19 21:50:24');

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

--
-- Table structure for table `referral_targets`
--

CREATE TABLE `referral_targets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_targets`
--

INSERT INTO `referral_targets` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Target #1', '2022-10-09 03:11:24', '2023-03-25 00:41:28'),
(2, 'Target #2', '2022-10-09 04:15:59', '2023-03-25 00:41:34'),
(3, 'Target #3', '2022-10-09 04:16:06', '2023-03-25 00:41:40'),
(4, 'Target #4', '2022-10-09 04:16:10', '2023-03-25 00:41:44'),
(5, 'Target #5', '2022-10-09 04:16:18', '2023-03-25 00:41:49'),
(6, 'Target #6', '2022-10-09 04:19:02', '2023-03-25 00:41:53');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super-Admin', 'admin', '2022-08-24 03:03:35', '2022-08-24 03:03:35'),
(2, 'Manager', 'admin', '2022-09-03 03:29:43', '2022-10-31 15:16:03'),
(3, 'Editor', 'admin', '2022-10-31 14:46:15', '2022-10-31 15:09:24');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 2),
(1, 3),
(5, 3);

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

--
-- Table structure for table `scheduled_task`
--

CREATE TABLE `scheduled_task` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `command` varchar(255) NOT NULL,
  `frequency` int(11) NOT NULL COMMENT 'in minutes',
  `scheduled_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `scheduled_previous_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `schedules`
--

CREATE TABLE `schedules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` (`id`, `name`, `time`, `created_at`, `updated_at`) VALUES
(1, 'Hour', 1, '2022-08-28 11:40:42', '2022-11-16 21:46:51'),
(2, 'Daily', 24, '2022-08-28 11:40:54', '2022-08-28 11:48:38'),
(3, 'Weekly', 168, '2022-08-28 11:41:18', '2022-11-12 04:59:06');

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

--
-- Table structure for table `schemas`
--

CREATE TABLE `schemas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('fixed','range') NOT NULL,
  `fixed_amount` double NOT NULL DEFAULT 0,
  `min_amount` double NOT NULL DEFAULT 0,
  `max_amount` double NOT NULL DEFAULT 0,
  `capital_back` tinyint(1) NOT NULL DEFAULT 0,
  `badge` varchar(255) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `interest_type` enum('percentage','fixed') NOT NULL,
  `return_interest` double NOT NULL,
  `return_period` int(11) NOT NULL,
  `return_type` enum('period','lifetime') NOT NULL,
  `number_of_period` int(11) NOT NULL,
  `off_days` text DEFAULT NULL,
  `expiry_minute` int(11) DEFAULT 50,
  `is_trending` tinyint(1) DEFAULT 0,
  `schema_cancel` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schemas`
--

INSERT INTO `schemas` (`id`, `icon`, `name`, `type`, `fixed_amount`, `min_amount`, `max_amount`, `capital_back`, `badge`, `featured`, `status`, `interest_type`, `return_interest`, `return_period`, `return_type`, `number_of_period`, `off_days`, `expiry_minute`, `is_trending`, `schema_cancel`, `created_at`, `updated_at`) VALUES
(1, 'global/images/qHO0xXvfRTXFj3ZiLTq5.png', 'Starter Plan', 'range', 0, 100, 499, 1, NULL, 0, 1, 'percentage', 6, 2, 'period', 2, NULL, 59, 1, 1, '2022-08-28 11:50:48', '2025-01-17 03:57:36'),
(2, 'global/images/cm3jYayWlxFLLEdYhso5.png', 'Standard Plan', 'range', 0, 500, 4999, 1, NULL, 0, 1, 'percentage', 14, 2, 'period', 4, NULL, 40, 0, 1, '2022-08-28 11:54:58', '2025-01-17 03:58:16'),
(3, 'global/images/Y6cMYY9vkrJj4z0gP7jX.png', 'Advanced Plan', 'range', 0, 5000, 9999, 1, NULL, 0, 1, 'fixed', 25, 2, 'period', 6, NULL, 59, 0, 1, '2022-08-28 12:18:03', '2025-01-17 03:59:01'),
(4, 'global/images/NjSS6z1y7aEdJrgPDie7.png', 'Pro Plan', 'range', 0, 10000, 1000000, 1, NULL, 0, 1, 'fixed', 10, 2, 'period', 80, NULL, 50, 0, 1, '2022-10-26 08:45:21', '2025-01-17 04:00:19');

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `val` text NOT NULL,
  `type` char(20) NOT NULL DEFAULT 'string',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `name`, `val`, `type`, `created_at`, `updated_at`) VALUES
(1, 'currency_symbol', '$', 'string', '2022-08-24 10:01:01', '2023-07-30 23:13:24'),
(2, 'site_title', 'Empathy Transformation', 'string', '2022-08-24 10:01:01', '2025-01-08 18:02:18'),
(3, 'site_email', 'support@empathytransformation.com', 'string', '2022-08-24 10:01:01', '2025-01-08 18:02:19'),
(4, 'copyright_text', 'All rights reserved @tdevs 2022', 'string', '2022-08-24 10:01:01', '2022-08-24 10:01:01'),
(5, 'site_currency', 'USD', 'string', '2022-08-24 10:01:08', '2023-08-13 15:38:25'),
(6, 'login_bg', 'global/images/bdVMA7Po89q8yjy8LIVh.jpg', 'string', '2022-08-28 02:25:00', '2022-11-17 04:41:41'),
(7, 'site_logo', 'global/images/gfRumZOy2KeS4XHeuBFB.png', 'string', '2022-08-28 02:25:14', '2022-11-16 06:18:00'),
(8, 'site_favicon', 'global/images/dXxWXFfPMXh1N1gcVEdl.png', 'string', '2022-08-28 02:25:14', '2022-11-16 06:18:11'),
(9, 'maintenance_mode', '0', 'boolean', '2022-09-20 14:29:38', '2023-08-01 04:58:23'),
(10, 'maintenance_title', 'Site is not under maintenance for big update with big price', 'string', '2022-09-20 14:29:38', '2023-08-01 04:58:23'),
(11, 'maintenance_text', 'Sorry for interrupting! The site will be live soon.', 'string', '2022-09-20 14:29:38', '2022-09-20 15:04:34'),
(12, 'min_send', '10', 'double', '2022-09-21 08:35:47', '2022-11-13 07:34:21'),
(13, 'max_send', '5000', 'double', '2022-09-21 08:35:47', '2022-11-17 01:40:19'),
(14, 'send_charge_type', 'percentage', 'string', '2022-09-21 08:35:47', '2022-09-21 11:26:22'),
(15, 'send_charge', '5', 'double', '2022-09-21 08:35:47', '2022-11-10 21:07:42'),
(16, 'referral_commission', '21', 'double', '2022-10-10 04:34:02', '2022-10-10 04:34:02'),
(17, 'referral_bonus', '10', 'double', '2022-10-10 14:17:10', '2022-11-11 00:56:34'),
(18, 'signup_bonus', '8', 'double', '2022-10-10 14:17:10', '2023-07-16 12:07:22'),
(19, 'email_verification', '0', 'boolean', '2022-10-12 05:14:39', '2023-09-03 17:51:30'),
(20, 'kyc_verification', '1', 'boolean', '2022-10-12 05:14:39', '2023-04-13 14:38:48'),
(21, 'fa_verification', '0', 'boolean', '2022-10-12 05:14:39', '2022-11-11 00:56:52'),
(22, 'account_creation', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(23, 'user_deposit', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(24, 'user_withdraw', '1', 'boolean', '2022-10-12 05:14:39', '2022-11-17 20:46:38'),
(25, 'sign_up_referral', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(26, 'referral_signup_bonus', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:15:15'),
(27, 'investment_referral_bounty', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(28, 'deposit_referral_bounty', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(29, 'email_from_name', 'Empathy Transformation', 'string', '2022-10-29 14:11:51', '2025-01-08 18:44:43'),
(30, 'email_from_address', 'support@empathytransformation.com', 'string', '2022-10-29 14:11:51', '2025-01-08 18:44:43'),
(31, 'email_footer', 'Best Regard, \r\nTeam of  [[msg]]', 'string', '2022-10-29 14:11:51', '2022-10-29 16:15:30'),
(32, 'mailing_driver', 'smtp', 'string', '2022-10-29 14:11:51', '2022-10-29 14:50:36'),
(33, 'mail_host', 'firm.bullceederserver.com', 'string', '2022-10-29 14:11:51', '2025-01-08 18:47:12'),
(34, 'mail_port', '465', 'integer', '2022-10-29 14:11:51', '2025-01-08 18:46:22'),
(35, 'mail_secure', 'ssl', 'string', '2022-10-29 14:11:51', '2025-01-08 18:47:13'),
(36, 'mail_username', 'support@empathytransformation.com', 'string', '2022-10-29 15:05:23', '2025-01-08 18:46:01'),
(37, 'mail_password', 'Nairamate@2', 'string', '2022-10-29 15:05:23', '2025-01-08 18:48:17'),
(38, 'site_animation', '1', 'boolean', '2022-11-06 10:24:22', '2023-09-03 17:51:42'),
(39, 'support_email', 'support@empathytransformation.com', 'string', '2022-11-07 08:29:03', '2025-01-08 18:49:06'),
(40, 'wallet_exchange_charge_type', 'percentage', 'string', '2022-11-11 05:31:21', '2022-11-11 05:31:21'),
(41, 'wallet_exchange_charge', '0.05', 'string', '2022-11-11 05:31:21', '2022-11-11 05:31:21'),
(42, 'secret_key', '1212secret', 'string', '2022-11-14 01:32:48', '2023-07-28 15:30:45'),
(43, 'transfer_status', '1', 'boolean', '2022-11-16 08:16:07', '2022-11-16 08:17:08'),
(44, 'back_to_top', '0', 'boolean', '2022-11-16 08:16:07', '2023-09-03 17:51:42'),
(45, 'referral_deposit_bonus', '2.4', 'double', '2023-02-04 03:39:35', '2023-02-04 03:39:35'),
(46, 'site_timezone', 'Asia/Dhaka', 'string', '2023-02-15 08:26:05', '2023-02-18 02:41:46'),
(47, 'debug_mode', '0', 'boolean', '2023-02-15 14:07:46', '2023-09-03 17:51:42'),
(48, 'profit_level', '1', 'boolean', NULL, '2023-03-25 00:39:43'),
(49, 'investment_level', '1', 'boolean', NULL, '2023-03-28 06:35:55'),
(50, 'deposit_level', '1', 'boolean', NULL, '2023-03-25 00:39:46'),
(51, 'site_referral', 'level', 'string', '2023-03-25 01:14:29', '2023-07-30 23:13:24'),
(52, 'site_admin_prefix', 'admin', 'string', '2023-05-20 11:03:46', '2023-07-26 12:01:45'),
(53, 'home_redirect', '/', 'string', '2023-05-21 08:16:02', '2023-05-24 11:10:49'),
(54, 'wallet_exchange_day_limit', '1', 'int', '2023-05-24 11:07:21', '2023-07-19 17:58:06'),
(55, 'send_money_day_limit', '14', 'int', '2023-05-24 11:07:21', '2023-05-24 11:07:21'),
(56, 'withdraw_day_limit', '500', 'int', '2023-05-24 11:07:21', '2023-07-20 16:42:42'),
(57, 'investment_cancellation_daily_limit', '7', 'int', '2023-05-24 11:15:41', '2023-05-24 11:15:41'),
(58, 'referral_code_limit', '10', 'integer', '2023-06-11 20:56:07', '2023-06-11 20:56:07'),
(59, 'site_currency_type', 'fiat', 'string', '2023-07-20 12:18:23', '2023-08-13 15:38:25');

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

--
-- Table structure for table `set_tunes`
--

CREATE TABLE `set_tunes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `tune` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `set_tunes`
--

INSERT INTO `set_tunes` (`id`, `icon`, `name`, `tune`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/tune-icon/bewitched.png', 'Bewitched', 'global/tune/bewitched.mp3', 1, NULL, '2023-05-26 11:37:38'),
(2, 'global/tune-icon/crunchy.png', 'Crunchy', 'global/tune/crunchy.mp3', 0, NULL, '2023-05-26 11:37:38'),
(3, 'global/tune-icon/expert_notification.png', 'Expert Notification', 'global/tune/expert_notification.mp3', 0, NULL, '2023-05-26 11:37:38'),
(4, 'global/tune-icon/knock_knock.png', 'knock knock', 'global/tune/knock_knock.mp3', 0, NULL, '2023-05-26 11:37:38'),
(5, 'global/tune-icon/silencer.png', 'Silencer', 'global/tune/silencer.mp3', 0, NULL, '2023-05-26 11:37:38'),
(6, 'global/tune-icon/sticky.png', 'Sticky', 'global/tune/sticky.mp3', 0, NULL, '2023-05-26 11:37:38'),
(7, 'global/tune-icon/vopvoopvooop.png', 'Vopvoopvooop', 'global/tune/vopvoopvooop.mp3', 0, NULL, '2023-05-26 11:37:38');

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

--
-- Table structure for table `sms_templates`
--

CREATE TABLE `sms_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `for` varchar(256) NOT NULL DEFAULT 'User',
  `message_body` longtext NOT NULL,
  `short_codes` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_templates`
--

INSERT INTO `sms_templates` (`id`, `name`, `code`, `for`, `message_body`, `short_codes`, `status`, `created_at`, `updated_at`) VALUES
(1, 'New User', 'new_user', 'Admin', 'Thanks for joining us  [[full_name]]<br />\r\n [[message]]', '[\"[[full_name]]\",\"[[message]]\"]', 1, NULL, '2023-05-21 09:17:51'),
(2, 'User Investment\r\n', 'user_investment', 'User', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[site_title]]\"]', 1, NULL, NULL),
(3, 'User Account Disabled', 'user_account_disabled', 'Admin', 'Your account is disabled for a serious cause. Sorry! you\'re unable to use your account again.', NULL, 1, NULL, NULL),
(4, 'Manual Deposit request', 'manual_deposit_request', 'User', 'The manual deposit request details:<br />\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\"]', 1, NULL, NULL),
(5, 'Withdraw Request', 'withdraw_request ', 'User', 'Withdraw Request details:<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\"]', 1, NULL, NULL),
(6, 'KYC Request', 'kyc_request', 'User', 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[full_name]]<br />\r\n[[email]]<br />\r\n<br />\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.<br />\r\n<br />\r\nFind out more about in - [[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[kyc_type]]\"]', 1, NULL, NULL),
(7, 'KYC Action', 'kyc_action', 'User', 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[message]]<br />\r\n[[full_name]]<br />\r\n[[email]]<br />\r\n<br />\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.<br />\r\n<br />\r\nFind out more about in - [[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[message]]\",\"[[kyc_type]]\"]', 1, NULL, NULL),
(8, 'Invest ROI', 'invest_roi', 'User', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]<br />\r\n[[roi]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[roi]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, NULL),
(9, 'Investment End', 'investment_end', 'User', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment End<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[full_name]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, NULL),
(10, 'Withdraw Request Action', 'withdraw_request_user', 'User', 'Withdraw Request details:<br />\r\n[[message]]<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]<br />\r\n[[status]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, NULL),
(11, 'Manual Deposit request Action', 'user_manual_deposit_request', 'User', 'The manual deposit request details:<br />\r\n[[message]]\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]\r\n[[status]]\r\n', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, NULL);

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

--
-- Table structure for table `socials`
--

CREATE TABLE `socials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon_name` varchar(255) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `socials`
--

INSERT INTO `socials` (`id`, `icon_name`, `class_name`, `url`, `position`, `created_at`, `updated_at`) VALUES
(1, 'Facebook', 'fab fa-facebook-f', 'https://www.facebook.com/hyiprio/', 0, '2022-10-25 19:35:16', '2022-11-16 23:55:17'),
(2, 'Instagram', 'fab fa-instagram', 'https://www.instagram.com/hyiprio', 1, '2022-10-25 19:35:45', '2022-11-16 23:55:17'),
(3, 'Youtube', 'fab fa-youtube', 'https://youtube.com', 2, '2022-11-16 23:53:02', '2022-11-16 23:55:17'),
(4, 'Discord', 'fab fa-discord', 'https://discord.com', 3, '2022-11-16 23:54:33', '2022-11-16 23:55:17');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `email`, `created_at`, `updated_at`) VALUES
(1, 'skoparisian@yahoo.com', '2025-01-08 05:14:19', '2025-01-08 05:14:19'),
(2, 'shtobourbonneux@yahoo.com', '2025-01-08 05:56:31', '2025-01-08 05:56:31'),
(3, 'apvbqsq6dbr3mve@yahoo.com', '2025-01-08 07:39:32', '2025-01-08 07:39:32'),
(4, 'axoz9s6yvq8elbb3@yahoo.com', '2025-01-08 10:42:29', '2025-01-08 10:42:29'),
(5, 'slxphqpprat@yahoo.com', '2025-01-08 11:44:17', '2025-01-08 11:44:17'),
(6, 'f3ze8cr9orpwc@yahoo.com', '2025-01-08 11:50:47', '2025-01-08 11:50:47'),
(7, 'oj5xiwr515jf@yahoo.com', '2025-01-08 13:21:59', '2025-01-08 13:21:59'),
(8, 'kenikububequ06@gmail.com', '2025-01-08 14:34:56', '2025-01-08 14:34:56'),
(9, 'stoutenbaechle@yahoo.com', '2025-01-08 14:47:25', '2025-01-08 14:47:25'),
(10, 'usaqdmaahaoh@yahoo.com', '2025-01-08 18:16:29', '2025-01-08 18:16:29'),
(11, 'aracoaldabaja@yahoo.com', '2025-01-08 18:44:42', '2025-01-08 18:44:42'),
(12, 'kibbenbrghoefr@yahoo.com', '2025-01-08 21:06:55', '2025-01-08 21:06:55'),
(13, 'gtereaorysikku@yahoo.com', '2025-01-08 21:10:24', '2025-01-08 21:10:24'),
(14, 'ifveppwobbsyiwwvp@yahoo.com', '2025-01-08 21:13:00', '2025-01-08 21:13:00'),
(15, 'bdvasibmrbnwoc@yahoo.com', '2025-01-08 22:25:10', '2025-01-08 22:25:10'),
(16, 'jxfirqufdk@yahoo.com', '2025-01-08 22:52:16', '2025-01-08 22:52:16'),
(17, 'opvwexy40jirl@yahoo.com', '2025-01-08 23:41:17', '2025-01-08 23:41:17'),
(18, 'hhmsxk6lm1@yahoo.com', '2025-01-09 00:14:44', '2025-01-09 00:14:44'),
(19, 'qtclrrcxvndob@yahoo.com', '2025-01-09 01:17:29', '2025-01-09 01:17:29'),
(20, 'ezefasafis88@gmail.com', '2025-01-09 01:32:30', '2025-01-09 01:32:30'),
(21, 'apicatibuye570@gmail.com', '2025-01-09 04:18:19', '2025-01-09 04:18:19'),
(22, 'mqqvopz3haoejj@yahoo.com', '2025-01-09 07:12:30', '2025-01-09 07:12:30'),
(23, 'yilofose20@gmail.com', '2025-01-09 07:54:44', '2025-01-09 07:54:44'),
(24, 'ijuqolun42@gmail.com', '2025-01-09 08:59:11', '2025-01-09 08:59:11'),
(25, 'lingefeltermardiro@yahoo.com', '2025-01-09 10:58:27', '2025-01-09 10:58:27'),
(26, 'wefalupuqo335@gmail.com', '2025-01-09 13:49:28', '2025-01-09 13:49:28'),
(27, 'metonkalilikane@yahoo.com', '2025-01-09 18:30:06', '2025-01-09 18:30:06'),
(28, 'mcgoegleras@yahoo.com', '2025-01-09 19:19:14', '2025-01-09 19:19:14'),
(29, 'uhxb2uvkqfjxnm1s@yahoo.com', '2025-01-09 21:59:27', '2025-01-09 21:59:27'),
(30, 'bezantaati@yahoo.com', '2025-01-09 23:33:29', '2025-01-09 23:33:29'),
(31, 'lvgbpuofgf@yahoo.com', '2025-01-10 05:20:36', '2025-01-10 05:20:36'),
(32, 'helfenteinknazs@yahoo.com', '2025-01-10 05:41:15', '2025-01-10 05:41:15'),
(33, 'ktpi5kntf4pdnj4qn@yahoo.com', '2025-01-10 07:56:42', '2025-01-10 07:56:42'),
(34, 'tenereayavo@yahoo.com', '2025-01-10 08:57:30', '2025-01-10 08:57:30'),
(35, 'agaerosbrow@yahoo.com', '2025-01-10 10:46:44', '2025-01-10 10:46:44'),
(36, 'lqgtkfhveyr@yahoo.com', '2025-01-10 11:32:04', '2025-01-10 11:32:04'),
(37, 'cokowifuced604@gmail.com', '2025-01-10 12:38:23', '2025-01-10 12:38:23'),
(38, 'afekeyezima875@gmail.com', '2025-01-10 13:28:04', '2025-01-10 13:28:04'),
(39, 'fiodwwdwo@yahoo.com', '2025-01-10 14:17:32', '2025-01-10 14:17:32'),
(40, 'cuyuzugo63@gmail.com', '2025-01-10 15:26:35', '2025-01-10 15:26:35'),
(41, 'bfxpbeempgytgf@yahoo.com', '2025-01-10 17:08:22', '2025-01-10 17:08:22'),
(42, 'bcrduaahbcb@yahoo.com', '2025-01-10 17:17:19', '2025-01-10 17:17:19'),
(43, 'l7ngkyjixxyr@yahoo.com', '2025-01-10 19:48:25', '2025-01-10 19:48:25'),
(44, 'labizixoda24@gmail.com', '2025-01-10 20:48:13', '2025-01-10 20:48:13'),
(45, 'ufevewupe98@gmail.com', '2025-01-10 20:48:16', '2025-01-10 20:48:16'),
(46, 'satryfriedlan@yahoo.com', '2025-01-10 22:31:12', '2025-01-10 22:31:12'),
(47, 'fizakoffvoneschen@yahoo.com', '2025-01-10 23:16:24', '2025-01-10 23:16:24'),
(48, 'lushecknavrrette@yahoo.com', '2025-01-10 23:36:13', '2025-01-10 23:36:13'),
(49, 'rewozojusil41@gmail.com', '2025-01-11 01:19:24', '2025-01-11 01:19:24'),
(50, 'spnecvcbrqdqncibr@yahoo.com', '2025-01-11 02:23:57', '2025-01-11 02:23:57'),
(51, 'goeegieuckuhajo@yahoo.com', '2025-01-11 04:34:57', '2025-01-11 04:34:57'),
(52, 'dgqmqxk7zl@yahoo.com', '2025-01-11 06:12:53', '2025-01-11 06:12:53'),
(53, 'ilorikewa35@gmail.com', '2025-01-11 06:39:27', '2025-01-11 06:39:27'),
(54, 'ppn0xdctyif19@yahoo.com', '2025-01-11 07:12:18', '2025-01-11 07:12:18'),
(55, 'shakilheniff@yahoo.com', '2025-01-11 08:52:41', '2025-01-11 08:52:41'),
(56, 'q0xchsyamzht7w4@yahoo.com', '2025-01-11 11:20:17', '2025-01-11 11:20:17'),
(57, 'kaamuliisena@yahoo.com', '2025-01-11 11:25:12', '2025-01-11 11:25:12'),
(58, 'machizhokensmit@yahoo.com', '2025-01-11 12:27:15', '2025-01-11 12:27:15'),
(59, 'lqsddvlqgrprr@yahoo.com', '2025-01-11 12:33:55', '2025-01-11 12:33:55'),
(60, 'odufupe550@gmail.com', '2025-01-11 12:43:17', '2025-01-11 12:43:17'),
(61, 'meichertyrna@yahoo.com', '2025-01-11 14:06:21', '2025-01-11 14:06:21'),
(62, 'dtavflexbgdtu@yahoo.com', '2025-01-11 15:17:44', '2025-01-11 15:17:44'),
(63, 'iyuzitokequm29@gmail.com', '2025-01-11 17:30:47', '2025-01-11 17:30:47'),
(64, 'avowanaja17@gmail.com', '2025-01-11 17:43:48', '2025-01-11 17:43:48'),
(65, 'everittlaerman@yahoo.com', '2025-01-11 21:16:24', '2025-01-11 21:16:24'),
(66, 'kroeseferavich@yahoo.com', '2025-01-11 22:08:16', '2025-01-11 22:08:16'),
(67, 'mylkstape@yahoo.com', '2025-01-11 23:31:21', '2025-01-11 23:31:21'),
(68, 'hollndspondo@yahoo.com', '2025-01-12 02:36:04', '2025-01-12 02:36:04'),
(69, 'lmdfidsaxys@yahoo.com', '2025-01-12 04:35:17', '2025-01-12 04:35:17'),
(70, 'ocngkwioiug@yahoo.com', '2025-01-12 05:10:50', '2025-01-12 05:10:50'),
(71, 'mctuluiniidywkr@yahoo.com', '2025-01-12 05:20:29', '2025-01-12 05:20:29'),
(72, 'scheirmannmcsween@yahoo.com', '2025-01-12 06:51:20', '2025-01-12 06:51:20'),
(73, 'amgwbiarftxterhsg@yahoo.com', '2025-01-12 07:19:48', '2025-01-12 07:19:48'),
(74, 'petrozzstiepe@yahoo.com', '2025-01-12 08:44:05', '2025-01-12 08:44:05'),
(75, 'dgoasmansnaohmhh@yahoo.com', '2025-01-12 09:29:26', '2025-01-12 09:29:26'),
(76, 'ubikegevi18@gmail.com', '2025-01-12 10:33:00', '2025-01-12 10:33:00'),
(77, 'maodelicata@yahoo.com', '2025-01-12 11:52:10', '2025-01-12 11:52:10'),
(78, 'oxpcaqxwu@yahoo.com', '2025-01-12 18:34:10', '2025-01-12 18:34:10'),
(79, 'daumereflewellen@yahoo.com', '2025-01-12 18:59:36', '2025-01-12 18:59:36'),
(80, 'ftncbnpx2n0y@yahoo.com', '2025-01-12 20:30:27', '2025-01-12 20:30:27'),
(81, 'kuelusheinzan@yahoo.com', '2025-01-12 20:41:14', '2025-01-12 20:41:14'),
(82, 'tbrvnfiamnmfm@yahoo.com', '2025-01-12 22:39:22', '2025-01-12 22:39:22'),
(83, 'oqbxmxtosrbqn3vd@yahoo.com', '2025-01-13 03:38:08', '2025-01-13 03:38:08'),
(84, 'aldamaluebbertschre@yahoo.com', '2025-01-13 03:55:42', '2025-01-13 03:55:42'),
(85, 'wqozqsqy8jd31iy@yahoo.com', '2025-01-13 04:38:19', '2025-01-13 04:38:19'),
(86, 's4smphlx6e1zkf@yahoo.com', '2025-01-13 05:55:46', '2025-01-13 05:55:46'),
(87, 'ilokisto@yahoo.com', '2025-01-13 07:06:35', '2025-01-13 07:06:35'),
(88, 'bvofyghjh@yahoo.com', '2025-01-13 07:48:53', '2025-01-13 07:48:53'),
(89, 'hbcdwqocfj@yahoo.com', '2025-01-13 08:35:13', '2025-01-13 08:35:13'),
(90, 'mttlinwaterson@yahoo.com', '2025-01-13 08:42:24', '2025-01-13 08:42:24'),
(91, 'qu1greoige@yahoo.com', '2025-01-13 09:53:19', '2025-01-13 09:53:19'),
(92, 'curutekur33@gmail.com', '2025-01-13 10:24:50', '2025-01-13 10:24:50'),
(93, 'onebezode21@gmail.com', '2025-01-13 10:38:22', '2025-01-13 10:38:22'),
(94, 'myetteoeter@yahoo.com', '2025-01-13 12:27:20', '2025-01-13 12:27:20'),
(95, 'flcbccgbnffqxvd@yahoo.com', '2025-01-13 14:14:14', '2025-01-13 14:14:14'),
(96, 'gakagjrsqwdsi@yahoo.com', '2025-01-13 15:13:52', '2025-01-13 15:13:52'),
(97, 'echeeriakilasa@yahoo.com', '2025-01-13 16:37:18', '2025-01-13 16:37:18'),
(98, 'timariusipov@yahoo.com', '2025-01-13 16:49:19', '2025-01-13 16:49:19'),
(99, 'asajy3dluwhhxy@yahoo.com', '2025-01-13 17:48:41', '2025-01-13 17:48:41'),
(100, 'icgfoborljbio@yahoo.com', '2025-01-13 19:24:20', '2025-01-13 19:24:20'),
(101, 'primitivotae@yahoo.com', '2025-01-13 20:35:00', '2025-01-13 20:35:00'),
(102, 'goetchnarms@yahoo.com', '2025-01-13 21:14:20', '2025-01-13 21:14:20'),
(103, 'oy0sns633uf3mlj2g@yahoo.com', '2025-01-13 23:00:18', '2025-01-13 23:00:18'),
(104, 'cochranmya1990@gmail.com', '2025-01-14 00:36:15', '2025-01-14 00:36:15'),
(105, 'widmarkapwu@yahoo.com', '2025-01-14 02:24:02', '2025-01-14 02:24:02'),
(106, 'vxdpnrxadsokgsem@yahoo.com', '2025-01-14 02:29:32', '2025-01-14 02:29:32'),
(107, 'rxqqqbbdayhv@yahoo.com', '2025-01-14 04:39:18', '2025-01-14 04:39:18'),
(108, 'yj881x8npb@yahoo.com', '2025-01-14 05:46:14', '2025-01-14 05:46:14'),
(109, 'bmkovic1jl74wbw@yahoo.com', '2025-01-14 06:34:31', '2025-01-14 06:34:31'),
(110, 'ccxufkxqwd@yahoo.com', '2025-01-14 08:36:17', '2025-01-14 08:36:17'),
(111, 'x9kjwbm5wacr@yahoo.com', '2025-01-14 08:57:13', '2025-01-14 08:57:13'),
(112, 'nquhd01kwecr173ls@yahoo.com', '2025-01-14 10:11:33', '2025-01-14 10:11:33'),
(113, 'lutzkortnipi@gmail.com', '2025-01-14 10:35:17', '2025-01-14 10:35:17'),
(114, 'vburchh1998@gmail.com', '2025-01-14 11:06:42', '2025-01-14 11:06:42'),
(115, 'bouldedenersn@yahoo.com', '2025-01-14 11:12:16', '2025-01-14 11:12:16'),
(116, 'ridlandyerman@yahoo.com', '2025-01-14 15:34:00', '2025-01-14 15:34:00'),
(117, 'kstafforday@gmail.com', '2025-01-14 16:35:27', '2025-01-14 16:35:27'),
(118, 'xradgmckwpo@yahoo.com', '2025-01-14 20:11:24', '2025-01-14 20:11:24'),
(119, 'mwbkgqpmbftw@yahoo.com', '2025-01-14 20:12:05', '2025-01-14 20:12:05'),
(120, 'cakxkskqmixwxqpm@yahoo.com', '2025-01-14 20:59:25', '2025-01-14 20:59:25'),
(121, 'lbebsapmtum@yahoo.com', '2025-01-14 21:25:18', '2025-01-14 21:25:18'),
(122, 'jids7c00cwxd@yahoo.com', '2025-01-14 22:25:12', '2025-01-14 22:25:12'),
(123, 'dfhlhnrtnbq@yahoo.com', '2025-01-14 22:31:27', '2025-01-14 22:31:27'),
(124, 'pfnnenstiehlclyed@yahoo.com', '2025-01-14 22:40:11', '2025-01-14 22:40:11'),
(125, 'uqjtm5ylhi262l@yahoo.com', '2025-01-15 00:02:10', '2025-01-15 00:02:10'),
(126, 'kiohovmaplbv@yahoo.com', '2025-01-15 04:01:21', '2025-01-15 04:01:21'),
(127, 'qpwcfmhwrmcvgq@yahoo.com', '2025-01-15 06:00:20', '2025-01-15 06:00:20'),
(128, 'hokpnkdmv@yahoo.com', '2025-01-15 07:09:43', '2025-01-15 07:09:43'),
(129, 'wekclfqfgmgngcvo@yahoo.com', '2025-01-15 07:50:21', '2025-01-15 07:50:21'),
(130, 'p7inuenjta@yahoo.com', '2025-01-15 08:33:56', '2025-01-15 08:33:56'),
(131, 'whisperio41delve42@gmail.com', '2025-01-15 08:56:24', '2025-01-15 08:56:24'),
(132, 'hhjwoywrtkjrflq@yahoo.com', '2025-01-15 09:22:38', '2025-01-15 09:22:38'),
(133, 'vhtysywbfybijwv@yahoo.com', '2025-01-15 09:42:00', '2025-01-15 09:42:00'),
(134, 'gallowvaie1@gmail.com', '2025-01-15 09:50:07', '2025-01-15 09:50:07'),
(135, 'fqfrnvsuceqj@yahoo.com', '2025-01-15 10:28:35', '2025-01-15 10:28:35'),
(136, 'edwmwldhfcdpj@yahoo.com', '2025-01-15 10:53:03', '2025-01-15 10:53:03'),
(137, 'dtrbuliname@yahoo.com', '2025-01-15 14:35:18', '2025-01-15 14:35:18'),
(138, 'ratisullender@yahoo.com', '2025-01-15 14:51:05', '2025-01-15 14:51:05'),
(139, 'mementooonexus@gmail.com', '2025-01-15 16:14:25', '2025-01-15 16:14:25'),
(140, 'sbnfwamwqp@yahoo.com', '2025-01-15 18:45:50', '2025-01-15 18:45:50'),
(141, 'viohthfjmwrsafyx@yahoo.com', '2025-01-15 19:44:42', '2025-01-15 19:44:42'),
(142, 'illuminatea29kaleidoscope@gmail.com', '2025-01-15 20:13:22', '2025-01-15 20:13:22'),
(143, 'mericyekelchyk@yahoo.com', '2025-01-15 21:04:32', '2025-01-15 21:04:32'),
(144, 'mortgi4fbu9@yahoo.com', '2025-01-15 22:26:12', '2025-01-15 22:26:12'),
(145, 'cprvlbnrgxjscss@yahoo.com', '2025-01-16 00:52:22', '2025-01-16 00:52:22'),
(146, 'eiwqjslzxjcp@yahoo.com', '2025-01-16 06:09:34', '2025-01-16 06:09:34'),
(147, 'ostellara28kaleidoscope39@gmail.com', '2025-01-16 06:49:00', '2025-01-16 06:49:00'),
(148, 'nwoxauynirbw@yahoo.com', '2025-01-16 07:44:29', '2025-01-16 07:44:29'),
(149, 'ayquiveriuumbraio@gmail.com', '2025-01-16 09:55:38', '2025-01-16 09:55:38'),
(150, 'utdsnmfwsh@yahoo.com', '2025-01-16 11:22:55', '2025-01-16 11:22:55'),
(151, 'einiqqnroivapo@yahoo.com', '2025-01-16 11:33:39', '2025-01-16 11:33:39'),
(152, 'otonelsncervena@yahoo.com', '2025-01-16 12:39:11', '2025-01-16 12:39:11'),
(153, 'hv15bijuqqw@yahoo.com', '2025-01-16 12:55:25', '2025-01-16 12:55:25'),
(154, 'cib0gullrtl12@yahoo.com', '2025-01-16 13:18:17', '2025-01-16 13:18:17'),
(155, 'cweemkcyfnh@yahoo.com', '2025-01-16 14:56:10', '2025-01-16 14:56:10'),
(156, 'rhcmum0grefufnx@yahoo.com', '2025-01-16 14:58:51', '2025-01-16 14:58:51'),
(157, 'katutihetuc271@gmail.com', '2025-01-16 16:32:41', '2025-01-16 16:32:41'),
(158, 'pw2vusucqc0mfo@yahoo.com', '2025-01-16 18:08:29', '2025-01-16 18:08:29'),
(159, 'g1s8yq5k3jh0kes@yahoo.com', '2025-01-16 18:19:08', '2025-01-16 18:19:08'),
(160, 'phantomiajade21ua@gmail.com', '2025-01-16 18:32:28', '2025-01-16 18:32:28'),
(161, 'qw1rvk0hrmmcicv@yahoo.com', '2025-01-16 19:10:24', '2025-01-16 19:10:24'),
(162, 'lw7jeotjicqw@yahoo.com', '2025-01-16 19:12:24', '2025-01-16 19:12:24'),
(163, 'rvzguuaykeljz9buc@yahoo.com', '2025-01-16 20:56:17', '2025-01-16 20:56:17'),
(164, 'hxnnpfqhrlg@yahoo.com', '2025-01-16 21:06:18', '2025-01-16 21:06:18'),
(165, 'flfomiultx@yahoo.com', '2025-01-16 22:15:34', '2025-01-16 22:15:34'),
(166, 'abelyheilnr@yahoo.com', '2025-01-16 23:27:16', '2025-01-16 23:27:16'),
(167, 'kozaniraquh996@gmail.com', '2025-01-16 23:54:17', '2025-01-16 23:54:17'),
(168, 'rivv6b0cgx5nmu@yahoo.com', '2025-01-17 00:54:23', '2025-01-17 00:54:23'),
(169, 'dkjwgmjsnj@yahoo.com', '2025-01-17 01:55:23', '2025-01-17 01:55:23'),
(170, 'hoopmanbandurian@yahoo.com', '2025-01-17 03:20:36', '2025-01-17 03:20:36'),
(171, 'krysxugqpcsal@yahoo.com', '2025-01-17 04:41:21', '2025-01-17 04:41:21'),
(172, 'gn4kumfoxt4nrs@yahoo.com', '2025-01-17 04:50:13', '2025-01-17 04:50:13'),
(173, 'bfjckivkfbwkv@yahoo.com', '2025-01-17 05:39:09', '2025-01-17 05:39:09'),
(174, 'roetlerchac@yahoo.com', '2025-01-17 05:50:51', '2025-01-17 05:50:51'),
(175, 'w34uejjlkurcpo@yahoo.com', '2025-01-17 07:03:25', '2025-01-17 07:03:25'),
(176, 'gossamerae43nexus14oy@gmail.com', '2025-01-17 07:54:18', '2025-01-17 07:54:18'),
(177, 'licccjq9djglj@yahoo.com', '2025-01-17 08:41:51', '2025-01-17 08:41:51'),
(178, 'bwcltclyuky@yahoo.com', '2025-01-17 10:30:19', '2025-01-17 10:30:19'),
(179, 'rkfkjqrgoct@yahoo.com', '2025-01-17 10:35:13', '2025-01-17 10:35:13'),
(180, 'mxmxnfhxoqibm@yahoo.com', '2025-01-17 12:03:07', '2025-01-17 12:03:07'),
(181, 'vortexauiris43ai@gmail.com', '2025-01-17 12:13:48', '2025-01-17 12:13:48'),
(182, 'bueleimseeh@yahoo.com', '2025-01-17 13:03:14', '2025-01-17 13:03:14'),
(183, 'illuminateouikaleidoscope21oo@gmail.com', '2025-01-17 13:54:27', '2025-01-17 13:54:27'),
(184, 'dpvhkdyor@yahoo.com', '2025-01-17 14:49:12', '2025-01-17 14:49:12'),
(185, 'scaniwittic@yahoo.com', '2025-01-17 16:09:10', '2025-01-17 16:09:10'),
(186, 'towsnryhoud@yahoo.com', '2025-01-17 18:25:09', '2025-01-17 18:25:09'),
(187, 'kdmobmpyyidedkfr@yahoo.com', '2025-01-17 20:44:10', '2025-01-17 20:44:10'),
(188, 'nwmkawwuijj@yahoo.com', '2025-01-17 22:16:17', '2025-01-17 22:16:17'),
(189, 'luciansekhadt@yahoo.com', '2025-01-18 00:50:08', '2025-01-18 00:50:08'),
(190, 'pfsfckuy7o1ujth@yahoo.com', '2025-01-18 01:24:13', '2025-01-18 01:24:13'),
(191, 'wkosiebyhyvywgnnu@yahoo.com', '2025-01-18 04:46:10', '2025-01-18 04:46:10'),
(192, 'oqnutvxap@yahoo.com', '2025-01-18 05:31:01', '2025-01-18 05:31:01'),
(193, 'expanseuo2legacy72@gmail.com', '2025-01-18 06:23:00', '2025-01-18 06:23:00'),
(194, 'pw7e9xlg6h86zu@yahoo.com', '2025-01-18 09:16:51', '2025-01-18 09:16:51'),
(195, 'guibarreeghey@yahoo.com', '2025-01-18 09:42:40', '2025-01-18 09:42:40'),
(196, 'ouzenithaypinnaclea@gmail.com', '2025-01-18 10:26:26', '2025-01-18 10:26:26'),
(197, 'xanyhl0mlhu@yahoo.com', '2025-01-18 12:23:08', '2025-01-18 12:23:08'),
(198, 'lzoliu9pl4zpqm@yahoo.com', '2025-01-18 14:15:20', '2025-01-18 14:15:20'),
(199, 'gemgqgmeyhup1@yahoo.com', '2025-01-18 14:25:52', '2025-01-18 14:25:52'),
(200, 'sdrfoxnukf@yahoo.com', '2025-01-18 16:20:48', '2025-01-18 16:20:48'),
(201, 'xicerumabi519@gmail.com', '2025-01-18 17:31:40', '2025-01-18 17:31:40'),
(202, 'xffsmnhtsjsm3vo64@yahoo.com', '2025-01-18 17:41:45', '2025-01-18 17:41:45'),
(203, 'jv0gld5er3do4zqdr@yahoo.com', '2025-01-18 18:14:34', '2025-01-18 18:14:34'),
(204, 'asprijykqvfltxnta@yahoo.com', '2025-01-18 18:40:19', '2025-01-18 18:40:19'),
(205, 'gitm0yybltc1v@yahoo.com', '2025-01-18 20:09:53', '2025-01-18 20:09:53'),
(206, 'wvmorhayp@yahoo.com', '2025-01-18 21:05:30', '2025-01-18 21:05:30'),
(207, 'ebikidayolo42@gmail.com', '2025-01-18 21:29:21', '2025-01-18 21:29:21'),
(208, 'bosmurit@yahoo.com', '2025-01-18 22:21:33', '2025-01-18 22:21:33'),
(209, 'cerenosa@yahoo.com', '2025-01-19 08:49:30', '2025-01-19 08:49:30'),
(210, 'tuessywnic@yahoo.com', '2025-01-19 09:02:19', '2025-01-19 09:02:19'),
(211, 'engesanpitr@yahoo.com', '2025-01-19 09:59:58', '2025-01-19 09:59:58'),
(212, 'cavataioroailia@yahoo.com', '2025-01-19 14:47:16', '2025-01-19 14:47:16'),
(213, 'oinrnqfxgqougq@yahoo.com', '2025-01-19 14:47:21', '2025-01-19 14:47:21'),
(214, 'alederrer@yahoo.com', '2025-01-19 18:36:53', '2025-01-19 18:36:53'),
(215, 'ouifableeo65glyph13uy@gmail.com', '2025-01-19 19:54:22', '2025-01-19 19:54:22'),
(216, 'g4lck7sjcwdh@yahoo.com', '2025-01-19 20:54:26', '2025-01-19 20:54:26'),
(217, 'bernthalzumaeta@yahoo.com', '2025-01-19 21:00:22', '2025-01-19 21:00:22'),
(218, 'lunarau72oracle74@gmail.com', '2025-01-19 21:23:20', '2025-01-19 21:23:20'),
(219, 'n4mmrq5zzgb71hlaw@yahoo.com', '2025-01-19 22:48:43', '2025-01-19 22:48:43'),
(220, 'e4hw8b6euwadxdf7v@yahoo.com', '2025-01-20 00:42:55', '2025-01-20 00:42:55'),
(221, 'dscalttjsd@yahoo.com', '2025-01-20 01:01:21', '2025-01-20 01:01:21'),
(222, 'nugyrexhrweckbcyt@yahoo.com', '2025-01-20 02:20:50', '2025-01-20 02:20:50'),
(223, 'anukovwde@yahoo.com', '2025-01-20 05:39:31', '2025-01-20 05:39:31'),
(224, 'yhlrrhingqlms@yahoo.com', '2025-01-20 07:58:07', '2025-01-20 07:58:07'),
(225, 'scragscouman@yahoo.com', '2025-01-20 08:34:14', '2025-01-20 08:34:14'),
(226, 'no1ofpyijwny@yahoo.com', '2025-01-20 10:37:18', '2025-01-20 10:37:18'),
(227, 'erteliske@yahoo.com', '2025-01-20 13:13:25', '2025-01-20 13:13:25'),
(228, 'telay9adrjxsed2i@yahoo.com', '2025-01-20 16:36:28', '2025-01-20 16:36:28'),
(229, 'ycrescentuo44chime76oi@gmail.com', '2025-01-20 17:58:27', '2025-01-20 17:58:27'),
(230, 'drafbyhqbra@yahoo.com', '2025-01-20 18:01:44', '2025-01-20 18:01:44'),
(231, 'katirebasbene@yahoo.com', '2025-01-20 18:32:24', '2025-01-20 18:32:24'),
(232, 'u1rtqemrhu@yahoo.com', '2025-01-20 19:30:17', '2025-01-20 19:30:17'),
(233, 'iuthilon@yahoo.com', '2025-01-20 19:56:03', '2025-01-20 19:56:03'),
(234, 'qxwlmvvqlcwvewcti@yahoo.com', '2025-01-20 20:21:19', '2025-01-20 20:21:19'),
(235, 'slpheferett@yahoo.com', '2025-01-20 22:23:10', '2025-01-20 22:23:10'),
(236, 'rigngqepbjtpaodqh@yahoo.com', '2025-01-20 23:11:13', '2025-01-20 23:11:13'),
(237, 'lwrqzeclx@yahoo.com', '2025-01-21 00:15:32', '2025-01-21 00:15:32'),
(238, 'uogossamerechooy@gmail.com', '2025-01-21 02:25:42', '2025-01-21 02:25:42'),
(239, 'eldxldpanjjcnvvl@yahoo.com', '2025-01-21 03:47:20', '2025-01-21 03:47:20'),
(240, 'kdwyrqeqiqk@yahoo.com', '2025-01-21 04:49:31', '2025-01-21 04:49:31'),
(241, 'iofveywxxloukbbso@yahoo.com', '2025-01-21 06:21:24', '2025-01-21 06:21:24'),
(242, 'yewtlsxo9hh7@yahoo.com', '2025-01-21 07:23:58', '2025-01-21 07:23:58'),
(243, 'borealzeal86@gmail.com', '2025-01-21 08:28:45', '2025-01-21 08:28:45'),
(244, 'ifrshoqbsmrkw@yahoo.com', '2025-01-21 10:38:16', '2025-01-21 10:38:16'),
(245, 'lareryscaff@yahoo.com', '2025-01-21 13:36:48', '2025-01-21 13:36:48'),
(246, 'tacgendgcbcfl@yahoo.com', '2025-01-21 14:42:10', '2025-01-21 14:42:10'),
(247, 'wjyewvojdm4fy@yahoo.com', '2025-01-21 15:53:09', '2025-01-21 15:53:09'),
(248, 'hiavettarovinky@yahoo.com', '2025-01-21 16:37:24', '2025-01-21 16:37:24'),
(249, 'weinweigsptzmiler@yahoo.com', '2025-01-21 18:16:55', '2025-01-21 18:16:55'),
(250, 'ipipny6qm@yahoo.com', '2025-01-21 19:32:15', '2025-01-21 19:32:15'),
(251, 'mscubxogtsxf@yahoo.com', '2025-01-21 19:50:24', '2025-01-21 19:50:24'),
(252, 'tapvohdvpjubuq@yahoo.com', '2025-01-21 20:50:30', '2025-01-21 20:50:30'),
(253, 'onirvanaae9pinnacle99@gmail.com', '2025-01-21 21:56:42', '2025-01-21 21:56:42'),
(254, 'obsidianoui8pinnacle@gmail.com', '2025-01-21 22:16:16', '2025-01-21 22:16:16'),
(255, 'ivt5peusrrkdr5@yahoo.com', '2025-01-21 22:43:07', '2025-01-21 22:43:07'),
(256, 'griagtsubrqbnkb@yahoo.com', '2025-01-22 00:20:14', '2025-01-22 00:20:14'),
(257, 'dihwwfsgbhcdfwv@yahoo.com', '2025-01-22 00:23:13', '2025-01-22 00:23:13'),
(258, 'vgq5tsfaxn@yahoo.com', '2025-01-22 00:23:22', '2025-01-22 00:23:22'),
(259, 'toedtlnicki@yahoo.com', '2025-01-22 08:21:26', '2025-01-22 08:21:26'),
(260, 'bceheggli@yahoo.com', '2025-01-22 11:00:19', '2025-01-22 11:00:19'),
(261, 'tkcfntryhsmbi@yahoo.com', '2025-01-22 13:29:21', '2025-01-22 13:29:21'),
(262, 'cidngfqym@yahoo.com', '2025-01-22 14:27:26', '2025-01-22 14:27:26'),
(263, 'fwtfds7q6v1f@yahoo.com', '2025-01-22 15:53:20', '2025-01-22 15:53:20'),
(264, 'chinasjoukens@yahoo.com', '2025-01-22 17:24:49', '2025-01-22 17:24:49'),
(265, 'dnmj9ey3uunngk@yahoo.com', '2025-01-22 18:56:41', '2025-01-22 18:56:41'),
(266, 'smlerotschng@yahoo.com', '2025-01-22 19:16:15', '2025-01-22 19:16:15'),
(267, 'exctpaxnrjkd@yahoo.com', '2025-01-22 21:32:18', '2025-01-22 21:32:18'),
(268, 'wchtgjsoemn@yahoo.com', '2025-01-22 23:22:36', '2025-01-22 23:22:36'),
(269, 'tincupdnom@yahoo.com', '2025-01-23 01:31:07', '2025-01-23 01:31:07'),
(270, 'zvolenskystebaboatwriht@yahoo.com', '2025-01-23 03:53:18', '2025-01-23 03:53:18'),
(271, 'dttfurthfeineich@yahoo.com', '2025-01-23 06:54:28', '2025-01-23 06:54:28'),
(272, 'runbergcauino@yahoo.com', '2025-01-23 08:55:22', '2025-01-23 08:55:22'),
(273, 'piotgyfgnrahnejn@yahoo.com', '2025-01-23 08:58:29', '2025-01-23 08:58:29'),
(274, 'cirssuvansri@yahoo.com', '2025-01-23 12:13:29', '2025-01-23 12:13:29'),
(275, 'xpqwqlsbghvoybn@yahoo.com', '2025-01-23 13:48:20', '2025-01-23 13:48:20'),
(276, 'rddhhihumn@yahoo.com', '2025-01-23 14:59:22', '2025-01-23 14:59:22'),
(277, 'omgnlfoyvtbavcqo@yahoo.com', '2025-01-23 16:07:13', '2025-01-23 16:07:13'),
(278, 'champoirezell@yahoo.com', '2025-01-23 17:51:52', '2025-01-23 17:51:52'),
(279, 'Margaret0Andrews2207@gmail.com', '2025-01-23 18:13:10', '2025-01-23 18:13:10'),
(280, 'cjxdotqfdi@yahoo.com', '2025-01-23 19:13:42', '2025-01-23 19:13:42'),
(281, 'xnhf4nswsuu1gj3s6@yahoo.com', '2025-01-23 21:51:20', '2025-01-23 21:51:20'),
(282, 'aw1beuahlpfgjn42b@yahoo.com', '2025-01-23 23:04:23', '2025-01-23 23:04:23'),
(283, 'sb4xepjtiir2@yahoo.com', '2025-01-24 01:46:01', '2025-01-24 01:46:01'),
(284, 'bl6den8qs@yahoo.com', '2025-01-24 02:26:22', '2025-01-24 02:26:22'),
(285, 'breuningschiavottiello@yahoo.com', '2025-01-24 03:44:45', '2025-01-24 03:44:45'),
(286, 'xm1tcd00w@yahoo.com', '2025-01-24 07:01:24', '2025-01-24 07:01:24'),
(287, 'kp1btjeryr0it3@yahoo.com', '2025-01-24 17:55:46', '2025-01-24 17:55:46'),
(288, 'Toni7Eleanor0234@gmail.com', '2025-01-24 18:19:29', '2025-01-24 18:19:29'),
(289, 'mcktkkeegk0r@yahoo.com', '2025-01-24 19:23:40', '2025-01-24 19:23:40'),
(290, 'ulonolwalski@yahoo.com', '2025-01-24 20:47:29', '2025-01-24 20:47:29'),
(291, 'renjlajefr@yahoo.com', '2025-01-24 21:01:20', '2025-01-24 21:01:20'),
(292, 'poouicyhynb@yahoo.com', '2025-01-24 23:11:20', '2025-01-24 23:11:20'),
(293, 'huptcliibuphcq@yahoo.com', '2025-01-24 23:18:26', '2025-01-24 23:18:26'),
(294, 'ingtocfi0vhwvucwv@yahoo.com', '2025-01-24 23:20:27', '2025-01-24 23:20:27'),
(295, 'Arthur3Foster1480@gmail.com', '2025-01-25 01:37:15', '2025-01-25 01:37:15'),
(296, 'verbuggenlibeson@yahoo.com', '2025-01-25 03:22:16', '2025-01-25 03:22:16'),
(297, 'Abbie8Mason5200@gmail.com', '2025-01-25 04:30:20', '2025-01-25 04:30:20'),
(298, 'gjefbjxbwyhblyrf@yahoo.com', '2025-01-25 04:31:57', '2025-01-25 04:31:57'),
(299, 'Adele4Nguyen5694@gmail.com', '2025-01-25 05:57:26', '2025-01-25 05:57:26');

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('landing','site') NOT NULL DEFAULT 'landing',
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'default', 'site', 1, '2023-07-04 18:47:28', '2023-08-22 13:32:24'),
(2, 'money_invest', 'site', 0, '2023-07-04 18:47:28', '2023-08-22 13:32:24'),
(3, 'mining_invest', 'site', 0, '2023-07-04 18:47:28', '2023-08-04 11:05:08');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `attach` varchar(300) DEFAULT NULL,
  `priority` varchar(255) NOT NULL DEFAULT 'low',
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `is_resolved` tinyint(1) NOT NULL DEFAULT 0,
  `is_locked` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `from_user_id` int(10) UNSIGNED DEFAULT NULL,
  `from_model` varchar(255) NOT NULL DEFAULT 'User',
  `target_id` bigint(20) DEFAULT NULL,
  `target_type` varchar(256) DEFAULT NULL,
  `is_level` tinyint(1) DEFAULT 0,
  `tnx` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `charge` varchar(255) NOT NULL DEFAULT '0',
  `final_amount` varchar(255) NOT NULL DEFAULT '0',
  `method` varchar(255) DEFAULT NULL,
  `pay_currency` varchar(256) DEFAULT NULL,
  `pay_amount` double DEFAULT NULL,
  `manual_field_data` text DEFAULT NULL,
  `approval_cause` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` (`id`, `user_id`, `from_user_id`, `from_model`, `target_id`, `target_type`, `is_level`, `tnx`, `description`, `amount`, `type`, `charge`, `final_amount`, `method`, `pay_currency`, `pay_amount`, `manual_field_data`, `approval_cause`, `status`, `created_at`, `updated_at`) VALUES
(1, 971, NULL, 'User', NULL, NULL, 0, 'TRXLXCEDXKVNN', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-08 20:47:05', '2025-01-08 20:47:05'),
(2, 972, NULL, 'User', NULL, NULL, 0, 'TRXRVXIU3KTXD', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-08 23:45:24', '2025-01-08 23:45:24'),
(3, 972, NULL, 'User', NULL, NULL, 0, 'TRXD8JOM944ZJ', 'Deposit With Bitcoin', '3000', 'manual_deposit', '0', '3000', 'BTC', 'USD', 3000, '{\"Upload payment receipt\":\"global\\/images\\/r3TupqiagwsYMy8CaSVI.jpg\"}', '', 'success', '2025-01-08 23:48:04', '2025-01-08 23:53:00'),
(4, 971, 972, 'User', 1, 'deposit', 1, 'TRXL9KIYSQUGR', 'Deposit Referral Bonus Via Cynthia Shallot - Level 1', '60', 'referral', '0', '60', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-08 23:52:59', '2025-01-08 23:52:59'),
(5, 1, 972, 'User', 2, 'deposit', 1, 'TRXVL2V94GJNW', 'Deposit Referral Bonus Via Cynthia Shallot - Level 2', '150', 'referral', '0', '150', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-08 23:52:59', '2025-01-08 23:52:59'),
(6, 973, NULL, 'User', NULL, NULL, 0, 'TRXHOJOIGREP2', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 03:21:33', '2025-01-09 03:21:33'),
(7, 973, NULL, 'User', NULL, NULL, 0, 'TRXXXSAHPQUJI', 'Deposit With Bitcoin', '2000', 'manual_deposit', '0', '2000', 'BTC', 'USD', 2000, '{\"Upload payment receipt\":\"global\\/images\\/hXHdJhaKvZsHY84Svlsz.png\"}', '', 'success', '2025-01-09 03:35:12', '2025-01-09 04:02:47'),
(8, 972, 973, 'User', 1, 'deposit', 1, 'TRXDJ3UFWQS3D', 'Deposit Referral Bonus Via Simpson George - Level 1', '40', 'referral', '0', '40', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:02:46', '2025-01-09 04:02:46'),
(9, 971, 973, 'User', 2, 'deposit', 1, 'TRX3A4LMVAYJS', 'Deposit Referral Bonus Via Simpson George - Level 2', '100', 'referral', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:02:46', '2025-01-09 04:02:46'),
(10, 1, 972, 'User', 3, 'deposit', 1, 'TRX4ZGRJKWHCX', 'Deposit Referral Bonus Via Cynthia Shallot - Level 3', '200', 'referral', '0', '200', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:02:47', '2025-01-09 04:02:47'),
(11, 973, NULL, 'User', NULL, NULL, 0, 'TRXJP4SFRODHJ', 'Deposit With Bitcoin', '2000', 'manual_deposit', '0', '2000', 'BTC', 'USD', 2000, '{\"Upload payment receipt\":\"global\\/images\\/3DjXl5zZumntzSUGmKg5.png\"}', '', 'success', '2025-01-09 04:05:28', '2025-01-09 21:44:21'),
(12, 973, NULL, 'User', NULL, NULL, 0, 'TRX6SYNSXBQOL', 'Standard Plan Plan Invested', '2000', 'investment', '0', '2000', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:55:25', '2025-01-09 04:55:25'),
(13, 972, 973, 'User', 1, 'investment', 1, 'TRXUAEALLXSVR', 'Investment Referral Bonus Via Simpson George - Level 1', '60', 'referral', '0', '60', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:55:25', '2025-01-09 04:55:25'),
(14, 971, 973, 'User', 2, 'investment', 1, 'TRXZPRUJQ83KZ', 'Investment Referral Bonus Via Simpson George - Level 2', '120', 'referral', '0', '120', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:55:25', '2025-01-09 04:55:25'),
(15, 1, 972, 'User', 3, 'investment', 1, 'TRX7DMAQTF9U7', 'Investment Referral Bonus Via Cynthia Shallot - Level 3', '200', 'referral', '0', '200', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 04:55:26', '2025-01-09 04:55:26'),
(16, 974, NULL, 'User', NULL, NULL, 0, 'TRXQTLYRCNJTE', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 21:18:59', '2025-01-09 21:18:59'),
(17, 974, NULL, 'User', NULL, NULL, 0, 'TRXSUSIUXUEBB', 'Deposit With Bitcoin', '3000', 'deposit', '0', '3000', 'BTC', 'USD', 3000, '[]', 'none', 'pending', '2025-01-09 21:34:29', '2025-01-09 21:34:29'),
(18, 972, 973, 'User', 1, 'deposit', 1, 'TRXWLWRZMKE0Z', 'Deposit Referral Bonus Via Simpson George - Level 1', '40', 'referral', '0', '40', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 21:44:20', '2025-01-09 21:44:20'),
(19, 971, 973, 'User', 2, 'deposit', 1, 'TRXDV6XW5AGDJ', 'Deposit Referral Bonus Via Simpson George - Level 2', '100', 'referral', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 21:44:20', '2025-01-09 21:44:20'),
(20, 1, 972, 'User', 3, 'deposit', 1, 'TRXRA61IUJEX1', 'Deposit Referral Bonus Via Cynthia Shallot - Level 3', '200', 'referral', '0', '200', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 21:44:20', '2025-01-09 21:44:20'),
(21, 974, NULL, 'User', NULL, NULL, 0, 'TRXSXFZCVOB9A', 'Deposit With Bitcoin', '3000', 'deposit', '0', '3000', 'BTC', 'USD', 3000, '[]', 'none', 'pending', '2025-01-09 21:46:09', '2025-01-09 21:46:09'),
(22, 972, NULL, 'User', NULL, NULL, 0, 'TRXXOER30QO7T', 'Standard Plan Plan Invested', '2000', 'investment', '0', '2000', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:00:07', '2025-01-09 22:00:07'),
(23, 971, 972, 'User', 1, 'investment', 1, 'TRXVSZ2OAIQJ2', 'Investment Referral Bonus Via Cynthia Shallot - Level 1', '60', 'referral', '0', '60', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:00:08', '2025-01-09 22:00:08'),
(24, 1, 972, 'User', 2, 'investment', 1, 'TRXATLHL9UXUD', 'Investment Referral Bonus Via Cynthia Shallot - Level 2', '120', 'referral', '0', '120', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:00:10', '2025-01-09 22:00:10'),
(25, 974, NULL, 'User', NULL, NULL, 0, 'TRX5KJF2Y2QYY', 'Deposit With USDT', '3000', 'manual_deposit', '0', '3000', 'tether', 'USD', 3000, '{\"Upload payment receipt\":\"global\\/images\\/OLWSXakKP9V4gPGBH2CP.jpg\"}', '', 'success', '2025-01-09 22:23:06', '2025-01-09 22:23:50'),
(26, 972, 974, 'User', 1, 'deposit', 1, 'TRXC7N3RKFDR4', 'Deposit Referral Bonus Via Stephen Schneble - Level 1', '60', 'referral', '0', '60', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:23:50', '2025-01-09 22:23:50'),
(27, 971, 974, 'User', 2, 'deposit', 1, 'TRX1ADDEEB0PL', 'Deposit Referral Bonus Via Stephen Schneble - Level 2', '150', 'referral', '0', '150', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:23:50', '2025-01-09 22:23:50'),
(28, 1, 972, 'User', 3, 'deposit', 1, 'TRXNVYGLMKPQT', 'Deposit Referral Bonus Via Cynthia Shallot - Level 3', '300', 'referral', '0', '300', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:23:50', '2025-01-09 22:23:50'),
(29, 974, NULL, 'User', NULL, NULL, 0, 'TRXEGS1FGJIY3', 'Standard Plan Plan Invested', '2000', 'investment', '0', '2000', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(30, 972, 974, 'User', 1, 'investment', 1, 'TRX1ZN1T53PGV', 'Investment Referral Bonus Via Stephen Schneble - Level 1', '60', 'referral', '0', '60', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(31, 971, 974, 'User', 2, 'investment', 1, 'TRXGKAGD6M3G5', 'Investment Referral Bonus Via Stephen Schneble - Level 2', '120', 'referral', '0', '120', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(32, 1, 972, 'User', 3, 'investment', 1, 'TRXOSZX36JKTS', 'Investment Referral Bonus Via Cynthia Shallot - Level 3', '200', 'referral', '0', '200', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:27:47', '2025-01-09 22:27:47'),
(33, 974, NULL, 'User', NULL, NULL, 0, 'TRX8JUU5V3DJZ', 'Advanced Plan Plan Invested', '500', 'investment', '0', '500', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:31:13', '2025-01-09 22:31:13'),
(34, 972, 974, 'User', 1, 'investment', 1, 'TRXA54PIFBRLI', 'Investment Referral Bonus Via Stephen Schneble - Level 1', '15', 'referral', '0', '15', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:31:14', '2025-01-09 22:31:14'),
(35, 971, 974, 'User', 2, 'investment', 1, 'TRXZ7NXRWRIRP', 'Investment Referral Bonus Via Stephen Schneble - Level 2', '30', 'referral', '0', '30', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:31:14', '2025-01-09 22:31:14'),
(36, 1, 972, 'User', 3, 'investment', 1, 'TRXNWOW9NSQSP', 'Investment Referral Bonus Via Cynthia Shallot - Level 3', '50', 'referral', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 22:31:14', '2025-01-09 22:31:14'),
(37, 975, NULL, 'User', NULL, NULL, 0, 'TRXKBREJ9JRWY', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-09 23:58:53', '2025-01-09 23:58:53'),
(38, 975, 1, 'Admin', NULL, NULL, 0, 'TRX6VBKPVKFZA', 'Money added in Main Wallet from System', '1780000', 'deposit', '0', '1780000', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-10 16:26:21', '2025-01-10 16:26:21'),
(39, 972, NULL, 'User', NULL, NULL, 0, 'TRXDD5MQL97AT', 'Withdraw With Bitcoin-USD', '1000', 'withdraw', '0', '1000', 'Bitcoin', 'USD', 1000, '{\"Please confirm your withdrawal address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"1PpEAK6mVy7M9gu1rMqVYowKCncj9NktYV\"}}', 'Withdrawal approval', 'success', '2025-01-13 05:05:38', '2025-01-13 05:07:27'),
(40, 971, NULL, 'User', NULL, NULL, 0, 'TRX9OSX9T33SD', 'Deposit With Bitcoin', '500', 'manual_deposit', '0', '500', 'BTC', 'USD', 500, '{\"Upload payment receipt\":\"global\\/images\\/vkiAIuNxTvxwJ5SlE80s.jpg\"}', '', 'success', '2025-01-17 14:24:48', '2025-01-17 14:25:50'),
(41, 1, 971, 'User', 1, 'deposit', 1, 'TRXEDUQF30ZCP', 'Deposit Referral Bonus Via Valeria Dan - Level 1', '10', 'referral', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-17 14:25:50', '2025-01-17 14:25:50'),
(42, 971, NULL, 'User', NULL, NULL, 0, 'TRXRACPDZ8EU9', 'Withdraw With Bitcoin-USD', '100', 'withdraw', '0', '100', 'Bitcoin', 'USD', 100, '{\"Please confirm your withdrawal address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Hakjfsb8nmvysbm0avfsldbyefeoehvs\"}}', '', 'success', '2025-01-17 14:29:06', '2025-01-22 09:55:00'),
(43, 976, NULL, 'User', NULL, NULL, 0, 'TRXMOPY0LAT6E', 'Signup Bonus', '8', 'signup_bonus', '0', '8', 'system', NULL, NULL, '[]', 'none', 'success', '2025-01-19 21:50:24', '2025-01-19 21:50:24'),
(44, 976, NULL, 'User', NULL, NULL, 0, 'TRXLATEU5H8JS', 'Deposit With Bitcoin', '2000', 'manual_deposit', '0', '2000', 'BTC', 'USD', 2000, '{\"Upload payment receipt\":\"global\\/images\\/zOTlDb4t30aCDc0mZOuO.png\"}', 'none', 'pending', '2025-01-19 21:51:48', '2025-01-19 21:51:48'),
(45, 971, NULL, 'User', NULL, NULL, 0, 'TRXJ5DSSNKRJ6', 'Withdraw With Bitcoin-USD', '100', 'withdraw', '0', '100', 'Bitcoin', 'USD', 100, '{\"Please confirm your withdrawal address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Hakjfsb8nmvysbm0avfsldbyefeoehvs\"}}', 'Withdrawal approved successfully', 'success', '2025-01-22 09:54:11', '2025-01-22 09:55:30');

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

--
-- Table structure for table `withdrawal_schedules`
--

CREATE TABLE `withdrawal_schedules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawal_schedules`
--

INSERT INTO `withdrawal_schedules` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Sunday', 1, NULL, '2023-06-23 20:22:05'),
(2, 'Monday', 1, NULL, '2023-06-23 20:22:05'),
(3, 'Tuesday', 1, NULL, '2023-06-23 20:22:05'),
(4, 'Wednesday', 1, NULL, '2023-06-23 20:22:05'),
(5, 'Thursday', 1, NULL, '2023-06-23 20:22:05'),
(6, 'Friday', 1, NULL, '2023-06-23 20:22:05'),
(7, 'Saturday', 1, NULL, '2023-06-23 20:22:05');

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

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

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT 'manual',
  `gateway_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `rate` double NOT NULL,
  `required_time` varchar(255) NOT NULL,
  `required_time_format` varchar(255) NOT NULL,
  `charge` double NOT NULL,
  `charge_type` varchar(255) NOT NULL,
  `min_withdraw` varchar(255) NOT NULL,
  `max_withdraw` varchar(255) NOT NULL,
  `fields` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `withdraw_methods` (`id`, `icon`, `type`, `gateway_id`, `name`, `currency`, `rate`, `required_time`, `required_time_format`, `charge`, `charge_type`, `min_withdraw`, `max_withdraw`, `fields`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/images/1aW0yhQdUHlJd40ZL8hk.png', 'manual', NULL, 'Bitcoin', 'USD', 1, '24', 'hour', 0, 'percentage', '100', '1000000', '{\"1\":{\"name\":\"Please confirm your withdrawal address\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2025-01-13 03:30:45', '2025-01-13 03:30:45'),
(2, 'global/images/cot11eQ8jVFzu6ZjMyGt.png', 'manual', NULL, 'Ethereum', 'USD', 1, '24', 'hour', 0, 'percentage', '100', '1000000', '{\"1\":{\"name\":\"Please confirm your withdrawal address\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2025-01-13 03:31:35', '2025-01-13 03:31:35'),
(3, 'global/images/EltKq49lgPWJOTTS4Z4b.png', 'manual', NULL, 'USDT', 'USD', 1, '24', 'hour', 0, 'percentage', '100', '1000000', '{\"1\":{\"name\":\"Please confirm your withdrawal address\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2025-01-13 03:33:43', '2025-01-13 03:33:43');

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

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

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

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

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

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

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_templates_code_unique` (`code`);

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

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

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

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

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

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

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_locale_unique` (`locale`);

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

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

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

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

--
-- Indexes for table `page_settings`
--
ALTER TABLE `page_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `page_settings_key_unique` (`key`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

--
-- Indexes for table `rankings`
--
ALTER TABLE `rankings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rankings_ranking_unique` (`ranking`),
  ADD UNIQUE KEY `rankings_ranking_name_unique` (`ranking_name`);

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

--
-- Indexes for table `referral_links`
--
ALTER TABLE `referral_links`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_links_referral_program_id_user_id_unique` (`referral_program_id`,`user_id`),
  ADD KEY `referral_links_code_index` (`code`);

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscriptions_email_unique` (`email`);

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_tnx_unique` (`tnx`),
  ADD KEY `transactions_user_id_index` (`user_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

