-- Table structure for table `cache`
--

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

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

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

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

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

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

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `crowd_invests`
--

CREATE TABLE `crowd_invests` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `crowd_schema_id` bigint UNSIGNED NOT NULL,
  `transaction_id` bigint UNSIGNED DEFAULT NULL,
  `invest_amount` double NOT NULL,
  `interest_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interest` double DEFAULT NULL,
  `profit_amount` double NOT NULL DEFAULT '0',
  `wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `crowd_schemas`
--

CREATE TABLE `crowd_schemas` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('fixed','range') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fixed_amount` double NOT NULL DEFAULT '0',
  `min_amount` double NOT NULL DEFAULT '0',
  `max_amount` double NOT NULL DEFAULT '0',
  `badge` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interest_type` enum('fixed','range') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `roi_interest_type` enum('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fixed_roi` double NOT NULL DEFAULT '0',
  `min_roi` double NOT NULL DEFAULT '0',
  `max_roi` double NOT NULL DEFAULT '0',
  `max_collection` double NOT NULL,
  `total_collected` double NOT NULL DEFAULT '0',
  `return_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `featured` 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;

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

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

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

--
-- Dumping data for table `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 UNSIGNED NOT NULL,
  `gateway_id` int UNSIGNED DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('auto','manual') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'manual',
  `gateway_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` double NOT NULL DEFAULT '0',
  `charge_type` enum('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `minimum_deposit` double NOT NULL,
  `maximum_deposit` double NOT NULL,
  `rate` double NOT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payment_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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, 5, NULL, 'Bitcoin', 'auto', 'coinbase-usd', 10, 'percentage', 100, 50000, 200, 'USD', 'BTC', NULL, NULL, 1, '2026-03-10 04:49:31', '2026-03-10 04:49:31'),
(11, NULL, NULL, 'Bitcoin', 'manual', 'Bitcoin', 10, 'percentage', 1, 1000000, 1, 'BTC', 'BTC', '[{\"name\":\"transactionId\",\"type\":\"text\",\"validation\":\"nullable\",\"label\":\"Transaction ID\"},{\"name\":\"paymentProof\",\"type\":\"file\",\"validation\":\"nullable\",\"label\":\"Payment Proof\"}]', '<div><strong>Wallet Name:</strong> Bitcoin</div><div><strong>Wallet Symbol:</strong> BTC</div><div><strong>Wallet Address:</strong> <code>bitcoin_wallet_address_here</code></div>', 1, '2026-03-11 09:34:48', '2026-03-21 16:57:53'),
(12, NULL, NULL, 'Ethereum', 'manual', 'Ethereum', 10, 'percentage', 1, 1000000, 1, 'ETH', 'ETH', '[{\"name\":\"transactionId\",\"type\":\"text\",\"validation\":\"nullable\",\"label\":\"Transaction ID\"},{\"name\":\"paymentProof\",\"type\":\"file\",\"validation\":\"nullable\",\"label\":\"Payment Proof\"}]', '<div><strong>Wallet Name:</strong> Ethereum</div><div><strong>Wallet Symbol:</strong> ETH</div><div><strong>Wallet Address:</strong> <code>ethereum_wallet_address_here</code></div>', 1, '2026-03-11 09:34:48', '2026-03-21 16:57:53'),
(13, NULL, NULL, 'USDT', 'manual', 'TRC20', 10, 'percentage', 1, 1000000, 1, 'USDT', 'USDT', '[{\"name\":\"transactionId\",\"type\":\"text\",\"validation\":\"nullable\",\"label\":\"Transaction ID\"},{\"name\":\"paymentProof\",\"type\":\"file\",\"validation\":\"nullable\",\"label\":\"Payment Proof\"}]', '<div><strong>Wallet Name:</strong> USDT</div><div><strong>Wallet Symbol:</strong> USDT</div><div><strong>Wallet Address:</strong> <code>usdt_wallet_address_here</code></div>', 1, '2026-03-11 09:34:48', '2026-03-21 16:57:53'),
(15, NULL, NULL, 'PI', 'manual', 'Pi network', 0, 'percentage', 1, 1000000, 1, '#', '#', '[{\"name\":\"transactionId\",\"label\":\"Transaction ID\",\"type\":\"text\",\"validation\":\"nullable\"},{\"name\":\"paymentProof\",\"label\":\"Payment Proof\",\"type\":\"file\",\"validation\":\"nullable\"}]', '<!-- wallet_meta:{&quot;wallet_name&quot;:&quot;PI&quot;,&quot;wallet_symbol&quot;:&quot;#&quot;,&quot;wallet_address&quot;:&quot;pi_wallet_address_here&quot;} --><div><strong>Wallet Name:</strong> PI</div><div><strong>Wallet Symbol:</strong> #</div><div><strong>Wallet Address:</strong> <code>pi_wallet_address_here</code></div>', 1, '2026-03-11 16:55:34', '2026-03-22 13:41:54');

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

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

CREATE TABLE `email_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `for` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'User',
  `banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salutation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `message_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `button_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_status` tinyint(1) NOT NULL DEFAULT '1',
  `footer_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bottom_status` tinyint(1) NOT NULL DEFAULT '1',
  `bottom_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `short_codes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 UNSIGNED NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date 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 `invests`
--

CREATE TABLE `invests` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `schema_id` bigint NOT NULL,
  `transaction_id` bigint DEFAULT NULL,
  `invest_amount` double NOT NULL,
  `original_invest_amount` double NOT NULL,
  `already_return_profit` int 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 DEFAULT NULL,
  `interest` double DEFAULT NULL,
  `interest_type` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_period` int NOT NULL,
  `return_interest_type` enum('periodic','after_maturity') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `period_hours` int DEFAULT NULL,
  `wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_auto_renewal` tinyint(1) NOT NULL DEFAULT '0',
  `remaining_time` bigint UNSIGNED 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 `jobs`
--

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

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

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

CREATE TABLE `kycs` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `kycs`
--

INSERT INTO `kycs` (`id`, `name`, `fields`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Passport', '{\"1\":{\"name\":\"International Passport\",\"type\":\"file\",\"validation\":\"required\"}}', 1, '2026-03-11 12:05:34', '2026-03-11 12:05:34');

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

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

CREATE TABLE `labels` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `locale_id` int NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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/xm7VdyiolApXkSkxEMsM.png', 'Register Account', 'By Registering the website you will able to start your operation', 'howitworks', '2022-10-23 08:31:45', '2025-12-08 04:05:19', 5, 'en'),
(6, 'global/images/WO2sw3RSCoDGsPx5gFAP.png', 'Verify Email', 'After creating the account user need to verify the email for account purpose', 'howitworks', '2022-10-23 08:32:06', '2025-12-08 04:05:27', 6, 'en'),
(7, 'global/images/uO3W1oDXcOuVW6j4K7s9.png', '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', '2025-12-08 04:08:07', 7, 'en'),
(11, 'global/images/rNxwHWzmiGrkKEhPCnBZ.svg', 'Total Users', '522', 'counter', '2022-10-23 09:25:59', '2025-12-08 04:14:32', 11, 'en'),
(14, NULL, 'How does it work with two wallets?', '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', '2022-11-16 18:51:14', 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/feg5OQEofNf0Sl5v9qdS.png', 'Verify KYC', 'Users\' KYC needs to verify to before making any withdrawals', 'howitworks', '2022-11-16 16:29:51', '2025-12-08 04:05:40', 16, 'en'),
(17, 'global/images/FHZnRnnHav9TgfiLYdtR.png', 'Deposit Money', 'Users can deposit using any automatic or manual gateways', 'howitworks', '2022-11-16 16:30:20', '2025-12-08 04:05:50', 17, 'en'),
(18, 'global/images/oBsXwlIVKqF9GNKHMhFv.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', '2025-12-08 04:05:59', 18, 'en'),
(19, 'global/images/awTBcuzHrRzSItRSkL2H.png', 'Transfer Money', 'Users can transfer the fund to another user instantly', 'howitworks', '2022-11-16 16:31:41', '2025-12-08 04:06:06', 19, 'en'),
(20, 'global/images/G7t2z7lru0bwHoaf8p0X.png', 'Refer to Friends', 'For referring to any friends user can generate the bonus', 'howitworks', '2022-11-16 10:36:25', '2025-12-08 04:06:13', 20, 'en'),
(21, 'global/images/6JyQX0T9OCweE8Ul3XZR.png', 'Withdraw and Enjoy', 'Users can withdraw their money from their wallet', 'howitworks', '2022-11-16 22:08:05', '2025-12-08 04:06:21', 21, 'en'),
(22, 'global/images/1BWiT8gbJ5t8cqfG8TB2.png', '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', '2025-12-08 04:08:28', 22, 'en'),
(23, 'global/images/fPmpFEvHgcKykZGNqp8T.png', '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', '2025-12-08 04:08:37', 23, 'en'),
(25, 'global/images/tVVlWGdAKcB8RH5O81EJ.svg', 'Total Deposit', '21453', 'counter', '2022-11-16 22:30:49', '2025-12-08 04:14:49', 25, 'en'),
(26, 'global/images/oae2C7OvTsSdYMfykSuL.svg', 'Total Investment', '112549', 'counter', '2022-11-16 22:32:35', '2025-12-08 04:14:59', 26, 'en'),
(27, 'global/images/AdOpOcgrqtbgKEOk01xa.svg', 'Total Withdraw', '58694', 'counter', '2022-11-16 22:33:20', '2025-12-08 04:15:08', 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, 'global/images/b2MBHBuiqb9WrJsUdwpG.png', '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', '2025-12-08 04:08:46', 35, 'en'),
(39, 'global/images/xm7VdyiolApXkSkxEMsM.png', 'Registrar Cuenta', 'Al registrarse en el sitio web podrá iniciar su operación', 'howitworks', '2022-10-23 08:31:45', '2025-12-08 04:05:19', 5, 'es'),
(40, 'global/images/xm7VdyiolApXkSkxEMsM.png', 'Créer un compte', 'En enregistrant le site Web, vous pourrez commencer votre opération', 'howitworks', '2022-10-23 08:31:45', '2025-12-08 04:05:19', 5, 'fr'),
(41, 'global/images/WO2sw3RSCoDGsPx5gFAP.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', '2025-12-08 04:05:27', 6, 'es'),
(42, 'global/images/WO2sw3RSCoDGsPx5gFAP.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', '2025-12-08 04:05:27', 6, 'fr'),
(43, 'global/images/feg5OQEofNf0Sl5v9qdS.png', 'Verificar KYC', 'El KYC de los usuarios debe verificar antes de realizar cualquier retiro', 'howitworks', '2022-11-16 16:29:51', '2025-12-08 04:05:40', 16, 'es'),
(44, 'global/images/feg5OQEofNf0Sl5v9qdS.png', 'Vérifier KYC', 'Le KYC des utilisateurs doit être vérifié avant d\'effectuer des retraits', 'howitworks', '2022-11-16 16:29:51', '2025-12-08 04:05:40', 16, 'fr'),
(45, 'global/images/FHZnRnnHav9TgfiLYdtR.png', 'Depositar dinero', 'Los usuarios pueden depositar utilizando cualquier pasarela automática o manual', 'howitworks', '2022-11-16 16:30:20', '2025-12-08 04:05:50', 17, 'es'),
(46, 'global/images/FHZnRnnHav9TgfiLYdtR.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', '2025-12-08 04:05:50', 17, 'fr'),
(47, 'global/images/oBsXwlIVKqF9GNKHMhFv.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', '2025-12-08 04:05:59', 18, 'es'),
(48, 'global/images/oBsXwlIVKqF9GNKHMhFv.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', '2025-12-08 04:05:59', 18, 'fr'),
(49, 'global/images/awTBcuzHrRzSItRSkL2H.png', 'Transferir dinero', 'Los usuarios pueden transferir el fondo a otro usuario al instante', 'howitworks', '2022-11-16 16:31:41', '2025-12-08 04:06:06', 19, 'es'),
(50, 'global/images/awTBcuzHrRzSItRSkL2H.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', '2025-12-08 04:06:06', 19, 'fr'),
(51, 'global/images/G7t2z7lru0bwHoaf8p0X.png', 'Referirse a amigas', 'Por referirse a cualquier amigo, el usuario puede generar el bono.', 'howitworks', '2022-11-16 10:36:25', '2025-12-08 04:06:13', 20, 'es'),
(52, 'global/images/G7t2z7lru0bwHoaf8p0X.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', '2025-12-08 04:06:13', 20, 'fr'),
(53, 'global/images/6JyQX0T9OCweE8Ul3XZR.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', '2025-12-08 04:06:21', 21, 'es'),
(54, 'global/images/uO3W1oDXcOuVW6j4K7s9.png', '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', '2025-12-08 04:08:07', 7, 'fr'),
(55, 'global/images/uO3W1oDXcOuVW6j4K7s9.png', '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', '2025-12-08 04:08:07', 7, 'es'),
(56, 'global/images/1BWiT8gbJ5t8cqfG8TB2.png', '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', '2025-12-08 04:08:28', 22, 'es'),
(57, 'global/images/1BWiT8gbJ5t8cqfG8TB2.png', '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', '2025-12-08 04:08:28', 22, 'fr'),
(58, 'global/images/fPmpFEvHgcKykZGNqp8T.png', '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', '2025-12-08 04:08:37', 23, 'es'),
(59, 'global/images/fPmpFEvHgcKykZGNqp8T.png', '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', '2025-12-08 04:08:37', 23, 'fr'),
(60, 'global/images/b2MBHBuiqb9WrJsUdwpG.png', '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', '2025-12-08 04:08:46', 35, 'es'),
(61, 'global/images/b2MBHBuiqb9WrJsUdwpG.png', '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', '2025-12-08 04:08:46', 35, 'fr'),
(62, 'global/images/rNxwHWzmiGrkKEhPCnBZ.svg', 'Total de usuarias', '522', 'counter', '2022-10-23 09:25:59', '2025-12-08 04:14:32', 11, 'es'),
(63, 'global/images/rNxwHWzmiGrkKEhPCnBZ.svg', 'Nombre total d\'utilisateurs', '522', 'counter', '2022-10-23 09:25:59', '2025-12-08 04:14:32', 11, 'fr'),
(64, 'global/images/tVVlWGdAKcB8RH5O81EJ.svg', 'Depósito total', '21453', 'counter', '2022-11-16 22:30:49', '2025-12-08 04:14:49', 25, 'es'),
(65, 'global/images/tVVlWGdAKcB8RH5O81EJ.svg', 'Dépôt total', '21453', 'counter', '2022-11-16 22:30:49', '2025-12-08 04:14:49', 25, 'fr'),
(66, 'global/images/oae2C7OvTsSdYMfykSuL.svg', 'Inversión total', '112549', 'counter', '2022-11-16 22:32:35', '2025-12-08 04:14:59', 26, 'es'),
(67, 'global/images/oae2C7OvTsSdYMfykSuL.svg', 'Investissement total', '112549', 'counter', '2022-11-16 22:32:35', '2025-12-08 04:14:59', 26, 'fr'),
(68, 'global/images/AdOpOcgrqtbgKEOk01xa.svg', 'Retiro total', '58694', 'counter', '2022-11-16 22:33:20', '2025-12-08 04:15:08', 27, 'es'),
(69, 'global/images/AdOpOcgrqtbgKEOk01xa.svg', 'Retrait total', '58694', 'counter', '2022-11-16 22:33:20', '2025-12-08 04:15:08', 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 UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `short` int DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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\\/A5K4UzBeS3QNpkybGtZG.png\",\"hero_right_top_img\":\"global\\/images\\/lLJT3xQhVp4mkOyxtRC3.png\",\"company_slogan\":\"\"}', 1, '2022-10-22 13:54:01', '2025-12-08 04:02:01', 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\\/DlcMlyH1b0aQ39m5TyL6.jpg\"}', 1, '2022-10-22 13:54:48', '2025-12-06 10:01:17', 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 2025. All rights reserved.\",\"right_img\":\"global\\/images\\/GAH1nccf5XhjretvfsYT.png\"}', 1, '2022-10-22 13:54:48', '2025-09-03 06:09:15', 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', '2025-12-08 04:02:01', 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', '2025-12-08 04:02:01', 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', '2025-09-03 06:09:15', 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', '2025-09-03 06:09:15', 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', '2025-12-06 10:01:17', 7, 'es'),
(46, 'Counter Section\n', 'counter', '{\"counter_bg_img\":\"global\\/images\\/p7e2WARHpcYJbr7RlDDE.jpg\"}', 1, '2023-07-18 16:59:25', '2025-12-06 10:01:17', 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 UNSIGNED NOT NULL,
  `flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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', 0, 1, NULL, '2026-01-04 19:08:58'),
(8, NULL, 'Spanish', 'es', 0, 1, '2022-10-05 19:17:20', '2026-01-03 10:08:29'),
(10, NULL, 'Franch', 'fr', 0, 1, '2022-11-07 01:23:27', '2026-01-02 20:16:28');

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

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

CREATE TABLE `level_referrals` (
  `id` bigint UNSIGNED NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `the_order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `login_activities` (`id`, `user_id`, `ip`, `location`, `agent`, `created_at`, `updated_at`) VALUES
(1, 0, '172.23.0.1', 'Unknown', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-11 11:58:18', '2026-03-11 11:58:18'),
(2, 1, '172.23.0.1', 'Unknown', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-21 15:18:56', '2026-03-21 15:18:56'),
(3, 1, '172.23.0.1', 'Unknown', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-21 15:57:34', '2026-03-21 15:57:34'),
(4, 1, '172.23.0.1', 'Unknown', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-21 15:58:33', '2026-03-21 15:58:33'),
(5, 1, '172.23.0.1', 'Unknown', 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:148.0) Gecko/20100101 Firefox/148.0', '2026-03-22 12:45:52', '2026-03-22 12:45:52');

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

--
-- Table structure for table `log_activities`
--

CREATE TABLE `log_activities` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mac` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int 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 `messages`
--

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

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '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),
(136, '2024_08_15_170331_create_holidays_table', 39),
(137, '2025_11_06_172254_create_crowd_schemas_table', 40),
(138, '2025_11_06_172321_create_crowd_invests_table', 40),
(139, '2026_03_21_000001_add_login_ips_to_admins_table', 41),
(140, '2026_03_21_000002_add_login_ip_to_users_table', 42);

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

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint 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 UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint 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);

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

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

CREATE TABLE `navigations` (
  `id` bigint UNSIGNED NOT NULL,
  `page_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_position` int DEFAULT NULL,
  `header_position` int DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `translate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) 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', 12, 6, 1, '2022-10-24 14:02:26', '2025-12-06 09:33:50', '{\"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', 13, 4, 1, '2022-10-26 23:00:32', '2025-12-06 09:33:50', '{\"en\":\"Schema\",\"es\":\"Esquema\",\"fr\":\"Sch\\u00e9ma\"}'),
(8, 2, 'How It Works', 'how-it-works', 'header', NULL, 2, 1, '2022-10-26 23:01:13', '2025-12-06 09:33:50', '{\"en\":\"How It Works\",\"fr\":\"Comment \\u00e7a fonctionne\",\"es\":\"C\\u00f3mo funciona\"}'),
(9, 5, 'Ranking', 'rankings', 'footer', 6, NULL, 1, '2022-10-26 23:01:33', '2024-02-29 23:08:27', '{\"en\":\"Ranking\",\"es\":\"Clasificaci\\u00f3n\",\"fr\":\"Classement\"}'),
(11, 3, 'About', 'about-us', 'both', 14, 5, 1, '2022-10-27 15:38:03', '2025-12-06 09:33:50', '{\"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', '/', 'header', NULL, 1, 1, '2022-10-28 08:34:49', '2024-02-06 17:48:07', '{\"en\":\"Home\",\"fr\":\"Maison\",\"es\":\"Hogar\"}'),
(16, 6, 'Blog', 'blog', 'header', NULL, 3, 1, '2022-11-17 02:35:57', '2025-12-06 09:33:50', '{\"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 UNSIGNED NOT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `for` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `action_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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', 1, 'admin', 'Wellcome to Grady Armstrong', 'Thanks for joining us  Grady Armstrong\r\n\r\n.New User added our system.', 'http://localhost:8000/admin/user/1/edit', 0, '2026-03-11 11:58:18', '2026-03-11 11:58:18'),
(2, 'fingerprint', 1, 'admin', 'Kyc Request', '\r\nGrady Armstrong Kyc requested\r\nsericalef@mailinator.com\r\n', 'http://localhost:8000/admin/kyc/pending', 0, '2026-03-11 12:11:55', '2026-03-11 12:11:55'),
(3, 'fingerprint', 1, 'user', 'Kyc approved.', 'Kyc approved successfully.', 'http://localhost:8000/user/kyc', 0, '2026-03-11 12:12:13', '2026-03-11 12:12:13');

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

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

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




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

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

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

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

INSERT INTO `page_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'breadcrumb', 'global/images/Cada44hv3LIzJ8VIJWxk.jpg', NULL, '2023-08-05 17:30:56'),
(2, 'basic_page_background', '#1bb12c', NULL, '2022-10-25 14:27:37'),
(3, 'username_show', '1', '2023-05-24 17:46:21', '2024-03-11 12:19:50'),
(4, 'phone_show', '1', '2023-05-24 17:46:21', '2024-03-11 12:19:50'),
(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'),
(7, 'app_splash_one_image', 'global/images/YCkdUsZ1rXEuLAdqs5rS.png', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(8, 'app_splash_one_title', 'Grow Your Wealth Fast', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(9, 'app_splash_one_description', 'Start investing in secure, high-yield plans and earn daily profits.', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(10, 'app_splash_two_image', 'global/images/m2tvMr8JactwKhCWmPRL.png', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(11, 'app_splash_two_title', 'Automatic Withdraw System', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(12, 'app_splash_two_description', 'Withdraw your earnings instantly — 24/7 automation.', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(13, 'app_splash_three_image', 'global/images/ETcqPTzCF89lBP1x1BwP.png', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(14, 'app_splash_three_title', 'Climb the Ranks, Unlock Rewards', '2025-11-16 00:21:13', '2025-11-16 00:21:22'),
(15, 'app_splash_three_description', 'Join global investors and rise through the Rio Ranking System.', '2025-11-16 00:21:13', '2025-11-16 00:21:22');

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

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

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



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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `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 UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'system',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(196) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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\":\"\",\"widget_id\":\"\"}', 0, NULL, '2024-03-11 12:18:35'),
(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\":\"\",\"google_recaptcha_secret\":\"\"}', 0, NULL, '2025-12-22 04:23:25'),
(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\":\"\"}', 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\":\"\"}', 0, NULL, '2023-02-09 22:53:13'),
(5, 'global/plugin/vonage.png', 'sms', 'Vonage', 'Programmatically send and receive high volumes of SMS globally\r\n\r\n\r\n', '{\"from\":\"\",\"api_key\":\"\",\"api_secret\":\"\"}', 0, NULL, '2024-03-11 12:18:18'),
(6, 'global/plugin/twilio.png', 'sms', 'Twilio', 'Build agility into your customer engagement\r\n\r\n\r\n', '{\"twilio_sid\":\"\",\"twilio_auth_token\":\"\",\"twilio_phone\":\"\"}', 0, NULL, '2024-03-11 12:18:18'),
(7, 'global/plugin/pusher.png', 'notification', 'Pusher', 'Leader In Realtime Technologies\r\n\r\n\r\n', '{\"pusher_app_id\":\"\",\"pusher_app_key\":\"\",\"pusher_app_secret\":\"\",\"pusher_app_cluster\":\"\"}', 0, NULL, '2024-10-08 09:12:22'),
(8, 'global/plugin/firebase.png', 'notification', 'Firebase', 'Real Time Notifications For Flutter App', '{\"upload_account_json\":\"\"}', 1, NULL, '2025-12-21 12:21:48');

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

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

CREATE TABLE `push_notification_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `for` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'User',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_codes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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.', '[]', 1, NULL, NULL),
(7, 'landmark', 'User Investment Start', 'user_investment', 'User', 'You Invested on [[plan_name]]', '\'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]]', '\'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]]', '\'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),
(13, 'refresh-ccw', 'Investment Auto Renewal Success', 'investment_auto_renewal_success', 'User', 'Investment Auto Renewal Successful', 'Your investment [[plan_name]] has been successfully renewed. Amount: [[invest_amount]], Transaction ID: [[txn]]', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[txn]]\"]', 1, '2025-10-30 05:00:00', '2025-10-29 23:22:12'),
(14, 'alert-octagon', 'Investment Auto Renewal Failed', 'investment_auto_renewal_failed', 'User', 'Investment Auto Renewal Failed', 'Your investment [[plan_name]] could not be renewed due to insufficient balance. Please log in to your account and invest to continue earning.', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[txn]]\"]', 1, '2025-10-30 05:00:00', '2025-10-29 23:20:17'),
(15, 'gift', 'Crowd Investment Profit', 'crowd_investment_profit', 'User', 'Crowd Investment Profit', 'Your crowd investment in [[plan_name]] has matured. Profit: [[profit_amount]] has been added to your account.', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[profit_amount]]\",\"[[txn]]\"]', 1, '2025-11-05 23:00:00', '2025-11-29 23:00:00'),
(16, 'landmark', 'User Crowd Investment Start', 'user_crowd_investment', 'User', 'You Invested in Crowd Plan [[plan_name]]', 'Hello!<br />\r\nYour crowd investment transaction was successful.<br />\r\nTransaction ID: [[txn]]<br />\r\nPlan Name: [[plan_name]]<br />\r\nInvested Amount: [[invest_amount]]', '[\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, '2025-11-05 23:00:00', '2025-11-29 23:00:00'),
(17, 'help-circle', 'New Support Ticket', 'support_ticket_created', 'Admin', 'New Support Ticket: [[subject]]', 'A new support ticket has been created.<br/>Ticket ID: [[subject]]<br/>Title: [[title]]<br/>User: [[full_name]]<br/>Email: [[email]]', '[\"[[subject]]\",\"[[title]]\",\"[[full_name]]\",\"[[email]]\"]', 1, '2025-12-20 23:00:00', '2025-11-29 23:00:00'),
(18, 'message-square', 'Support Ticket Reply', 'support_ticket_reply', 'Admin', 'New Reply on Ticket [[subject]]', 'A new reply has been added.<br/>Ticket ID: [[subject]]<br/>Message:<br/>[[message]]', '[\"[[subject]]\",\"[[message]]\"]', 1, '2025-12-20 23:00:00', '2025-11-29 23:00:00');

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

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

CREATE TABLE `rankings` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ranking` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ranking_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `minimum_deposit` int DEFAULT '0',
  `minimum_invest` int DEFAULT '0',
  `minimum_referral_deposit` int DEFAULT '0',
  `minimum_referral_invest` int DEFAULT '0',
  `minimum_referral` int DEFAULT '0',
  `minimum_earnings` double NOT NULL,
  `bonus` double NOT NULL DEFAULT '0',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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, 60, 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 UNSIGNED NOT NULL,
  `referral_target_id` bigint UNSIGNED NOT NULL,
  `type` enum('investment','deposit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bounty` double NOT NULL,
  `target_amount` double DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `referral_program_id` int UNSIGNED NOT NULL,
  `code` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 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, '7wQ29EFBxs', '2026-03-11 11:58:19', '2026-03-11 11:58:19');

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

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

CREATE TABLE `referral_programs` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lifetime_minutes` int 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 UNSIGNED NOT NULL,
  `referral_link_id` int NOT NULL,
  `user_id` int 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 `referral_targets`
--

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

--
-- 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 `reward_point_earnings`
--

CREATE TABLE `reward_point_earnings` (
  `id` bigint UNSIGNED NOT NULL,
  `ranking_id` bigint UNSIGNED NOT NULL,
  `amount_of_transactions` int NOT NULL,
  `point` int 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 `reward_point_redeems`
--

CREATE TABLE `reward_point_redeems` (
  `id` bigint UNSIGNED NOT NULL,
  `ranking_id` bigint UNSIGNED NOT NULL,
  `point` int NOT NULL,
  `amount` int 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 `roles`
--

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

--
-- 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');

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

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

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

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

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

CREATE TABLE `scheduled_task` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `command` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `frequency` int NOT NULL COMMENT 'in minutes',
  `scheduled_at` timestamp NOT NULL,
  `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 UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` int 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, 'Hourly', 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 UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('fixed','range') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `interest_type` enum('fixed','range') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `roi_interest_type` enum('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed',
  `min_roi` double NOT NULL,
  `max_roi` double NOT NULL,
  `fixed_roi` double NOT NULL,
  `return_interest` double DEFAULT NULL,
  `return_period` int NOT NULL,
  `return_type` enum('period','lifetime') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_period` int NOT NULL,
  `return_interest_type` enum('periodic','after_maturity') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `off_days` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `expiry_minute` int DEFAULT '50',
  `is_trending` tinyint(1) DEFAULT '0',
  `is_auto_renewal` tinyint(1) NOT NULL DEFAULT '0',
  `auto_renew_source` enum('base','profit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'base',
  `is_compounding` tinyint(1) NOT NULL 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;

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

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

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `val` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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', 'Hyiprio', 'string', '2022-08-24 10:01:01', '2022-08-28 03:55:16'),
(3, 'site_email', 'test@mail.com', 'string', '2022-08-24 10:01:01', '2023-03-28 21:50:43'),
(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', '2024-03-12 09:58:59'),
(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/omzmiODTeLJKzQEWHkzA.png', 'string', '2022-08-28 02:25:14', '2025-12-08 04:00:53'),
(8, 'site_favicon', 'global/images/IJuRju70ECD2vkjreszL.png', 'string', '2022-08-28 02:25:14', '2025-12-08 04:00:53'),
(9, 'maintenance_mode', '0', 'boolean', '2022-09-20 14:29:38', '2023-07-31 21:15:10'),
(10, 'maintenance_title', 'Site is not under maintenance for big update with big price', 'string', '2022-09-20 14:29:38', '2023-07-28 15:32:56'),
(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', '500', 'double', '2022-09-21 08:35:47', '2024-05-16 23:11:13'),
(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', '2', 'double', '2022-10-10 14:17:10', '2024-03-11 12:15:31'),
(18, 'signup_bonus', '3', 'double', '2022-10-10 14:17:10', '2024-03-11 12:15:31'),
(19, 'email_verification', '0', 'boolean', '2022-10-12 05:14:39', '2024-05-23 19:41:50'),
(20, 'kyc_verification', '1', 'boolean', '2022-10-12 05:14:39', '2024-03-11 12:16:01'),
(21, 'fa_verification', '1', 'boolean', '2022-10-12 05:14:39', '2024-03-11 12:16:01'),
(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', 'Hyiprio', 'string', '2022-10-29 14:11:51', '2022-11-21 15:41:28'),
(30, 'email_from_address', 'tdevs.official@gmail.com', 'string', '2022-10-29 14:11:51', '2023-04-09 16:39:44'),
(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', 'smtp.gmail.com', 'string', '2022-10-29 14:11:51', '2023-04-09 16:40:05'),
(34, 'mail_port', '465', 'integer', '2022-10-29 14:11:51', '2022-11-22 03:25:01'),
(35, 'mail_secure', 'tls', 'string', '2022-10-29 14:11:51', '2023-02-15 11:26:49'),
(36, 'mail_username', 'tdevs.official@gmail.com', 'string', '2022-10-29 15:05:23', '2023-04-09 16:39:44'),
(37, 'mail_password', 'nucacbnfytzmfnax', 'string', '2022-10-29 15:05:23', '2023-08-28 15:51:33'),
(38, 'site_animation', '1', 'boolean', '2022-11-06 10:24:22', '2024-05-23 20:28:11'),
(39, 'support_email', 'test@mail.com', 'string', '2022-11-07 08:29:03', '2023-03-28 21:50:43'),
(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', '2024-05-23 20:28:11'),
(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', '2026-01-05 04:51:32'),
(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', '100', 'int', '2023-05-24 11:07:21', '2023-09-14 00:39:47'),
(55, 'send_money_day_limit', '140', 'int', '2023-05-24 11:07:21', '2023-09-14 00:39:47'),
(56, 'withdraw_day_limit', '5', 'int', '2023-05-24 11:07:21', '2024-03-11 12:15:31'),
(57, 'investment_cancellation_daily_limit', '4', 'int', '2023-05-24 11:15:41', '2024-03-11 12:15:31'),
(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', '2024-03-12 09:58:59'),
(60, 'default_mode', 'dark', 'string', '2024-08-19 17:16:23', '2025-01-13 06:46:52'),
(61, 'user_portfolio', '1', 'boolean', '2024-08-19 17:16:23', '2024-08-19 17:16:23'),
(62, 'user_reward', '1', 'boolean', '2024-08-19 17:16:23', '2024-08-19 17:16:23'),
(63, 'inactive_account_disabled', '0', 'string', '2024-08-19 17:16:23', '2024-08-19 17:16:23'),
(64, 'inactive_days', '30', 'string', '2024-08-19 17:16:23', '2024-08-19 17:16:23'),
(65, 'app_enabled', '0', 'string', '2024-08-19 17:16:23', '2024-08-19 17:16:23'),
(66, 'app_license_key', NULL, 'string', '2024-08-19 17:16:23', '2024-08-19 17:16:23');

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

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

CREATE TABLE `set_tunes` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tune` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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', 0, NULL, '2025-10-30 14:00:32'),
(2, 'global/tune-icon/crunchy.png', 'Crunchy', 'global/tune/crunchy.mp3', 0, NULL, '2025-10-30 14:00:32'),
(3, 'global/tune-icon/expert_notification.png', 'Expert Notification', 'global/tune/expert_notification.mp3', 0, NULL, '2025-10-30 14:00:32'),
(4, 'global/tune-icon/knock_knock.png', 'knock knock', 'global/tune/knock_knock.mp3', 1, NULL, '2025-10-30 14:00:32'),
(5, 'global/tune-icon/silencer.png', 'Silencer', 'global/tune/silencer.mp3', 0, NULL, '2025-10-30 14:00:32'),
(6, 'global/tune-icon/sticky.png', 'Sticky', 'global/tune/sticky.mp3', 0, NULL, '2025-10-30 14:00:32'),
(7, 'global/tune-icon/vopvoopvooop.png', 'Vopvoopvooop', 'global/tune/vopvoopvooop.mp3', 0, NULL, '2025-10-30 14:00:32');

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

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

CREATE TABLE `sms_templates` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `for` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'User',
  `message_body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_codes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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', '\'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', '\'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', '\'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),
(12, 'Investment Auto Renewal Success', 'investment_auto_renewal_success', 'User', 'Your investment [[plan_name]] has been successfully renewed. Amount: [[invest_amount]], Transaction ID: [[txn]]', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[txn]]\"]', 1, '2025-10-30 05:00:00', '2025-10-29 23:21:45'),
(13, 'Investment Auto Renewal Failed', 'investment_auto_renewal_failed', 'User', 'Your investment [[plan_name]] renewal failed due to insufficient balance. Please log in to your account and invest to continue earning.', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[txn]]\"]', 1, '2025-10-30 05:00:00', '2025-10-29 23:19:33'),
(14, 'Crowd Investment Profit', 'crowd_investment_profit', 'User', 'Your crowd investment in [[plan_name]] has matured. Investment: [[invest_amount]], Profit: [[profit_amount]], Transaction ID: [[txn]]. Thank you for investing with [[site_title]].', '[\"[[plan_name]]\",\"[[invest_amount]]\",\"[[profit_amount]]\",\"[[txn]]\",\"[[site_title]]\"]', 1, '2025-11-05 23:00:00', '2025-11-06 00:45:29'),
(15, 'User Crowd Investment', 'user_crowd_investment', 'User', 'Hello! Your crowd investment transaction was successful. Transaction ID: [[txn]], Plan Name: [[plan_name]], Invested Amount: [[invest_amount]]', '[\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, '2025-11-05 23:00:00', '2025-11-06 00:45:29');

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

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

CREATE TABLE `socials` (
  `id` bigint UNSIGNED NOT NULL,
  `icon_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int 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 UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `themes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('landing','site') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'landing',
  `user_dashboard` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'investify',
  `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`, `user_dashboard`, `status`, `created_at`, `updated_at`) VALUES
(1, 'investify', 'site', 'investify', 1, '2024-07-04 12:47:28', '2025-12-08 03:54:09'),
(2, 'coin_orbit', 'site', 'investify', 0, '2023-08-04 12:47:28', '2025-12-07 02:02:06'),
(3, 'coinefy', 'site', 'investify', 0, '2023-08-04 12:47:28', '2023-08-08 05:05:08'),
(4, 'neovest', 'site', 'neovest', 0, '2025-11-04 05:05:08', '2025-12-07 02:03:05'),
(5, 'default', 'site', 'default', 0, '2023-07-04 12:47:28', '2025-12-08 03:54:09'),
(6, 'mining_invest', 'site', 'default', 0, '2023-07-04 12:47:28', '2023-08-04 05:05:08'),
(7, 'money_invest', 'site', 'default', 0, '2023-07-04 12:47:28', '2025-12-07 03:31:06');

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

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

CREATE TABLE `tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attach` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'low',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `from_user_id` int UNSIGNED DEFAULT NULL,
  `from_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'User',
  `target_id` bigint DEFAULT NULL,
  `target_type` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_level` tinyint(1) DEFAULT '0',
  `tnx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `final_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pay_currency` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pay_amount` double DEFAULT NULL,
  `manual_field_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `approval_cause` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 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, 1, NULL, 'User', NULL, NULL, 0, 'TRX5ZVIX2T7XV', 'Signup Bonus', '3', 'signup_bonus', '0', '3', 'system', NULL, NULL, '[]', 'none', 'success', '2026-03-11 11:58:18', '2026-03-11 11:58:18'),
(2, 1, NULL, 'User', NULL, NULL, 0, 'TRXDZFE0FYIFD', 'Deposit With Bitcoin', '100', 'deposit', '10', '110', 'coinbase-usd', 'USD', 22000, '[]', 'none', 'pending', '2026-03-11 12:12:52', '2026-03-11 12:12:52'),
(3, 1, NULL, 'User', NULL, NULL, 0, 'TRXYV3L2QGIJW', 'Deposit With Bitcoin', '1000', 'manual_deposit', '100', '1100', 'Bitcoin', 'BTC', 1100, '{\"transactionId\":\"qwertyuiop123456789\",\"paymentProof\":\"global\\/images\\/Bdsw93VFNCttZrufrp2F.png\"}', 'none', 'pending', '2026-03-22 12:49:52', '2026-03-22 12:49:52');

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

--
-- Table structure for table `user_devices`
--

CREATE TABLE `user_devices` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `device_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fcm_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `withdrawal_schedules` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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_accounts`
--

CREATE TABLE `withdraw_accounts` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `withdraw_method_id` bigint UNSIGNED NOT NULL,
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `credentials` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `withdraw_methods` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'manual',
  `gateway_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `required_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required_time_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` double NOT NULL,
  `charge_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_withdraw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_withdraw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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
(10, '', 'manual', NULL, 'Bitcoin', 'BTC', 1, '1', 'hour', 1, 'fixed', '1', '1000000', '[{\"name\":\"wallet_address\",\"type\":\"text\",\"validation\":\"required\"},{\"name\":\"network\",\"type\":\"text\",\"validation\":\"nullable\"},{\"name\":\"note\",\"type\":\"textarea\",\"validation\":\"nullable\"},{\"name\":\"admin_wallet_address::bitcoin_wallet_address_here\",\"type\":\"text\",\"validation\":\"nullable\"}]', 1, '2026-03-11 09:34:48', '2026-03-11 17:00:51'),
(11, '', 'manual', NULL, 'Ethereum', 'ETH', 1, '1', 'hour', 0, 'fixed', '1', '1000000', '[{\"name\":\"wallet_address\",\"type\":\"text\",\"validation\":\"required\"},{\"name\":\"network\",\"type\":\"text\",\"validation\":\"nullable\"},{\"name\":\"note\",\"type\":\"textarea\",\"validation\":\"nullable\"},{\"name\":\"admin_wallet_address::ethereum_wallet_address_here\",\"type\":\"text\",\"validation\":\"nullable\"}]', 1, '2026-03-11 09:34:48', '2026-03-11 16:26:36'),
(12, '', 'manual', NULL, 'USDT', 'USDT', 1, '1', 'hour', 0, 'fixed', '1', '1000000', '[{\"name\":\"wallet_address\",\"type\":\"text\",\"validation\":\"required\"},{\"name\":\"network\",\"type\":\"text\",\"validation\":\"nullable\"},{\"name\":\"note\",\"type\":\"textarea\",\"validation\":\"nullable\"},{\"name\":\"admin_wallet_address::usdt_wallet_address_here\",\"type\":\"text\",\"validation\":\"nullable\"}]', 1, '2026-03-11 09:34:48', '2026-03-11 09:34:48'),
(14, '', 'manual', NULL, 'PI', '#', 1, '1', 'hour', 0, 'percentage', '1', '1000000', '[{\"name\":\"wallet_address\",\"type\":\"text\",\"validation\":\"required\"},{\"name\":\"network\",\"type\":\"text\",\"validation\":\"nullable\"},{\"name\":\"note\",\"type\":\"textarea\",\"validation\":\"nullable\"},{\"name\":\"admin_wallet_address::pi_wallet_address_here\",\"type\":\"text\",\"validation\":\"nullable\"}]', 1, '2026-03-11 16:55:34', '2026-03-22 13:41:54');

--
-- 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 `crowd_invests`
--
ALTER TABLE `crowd_invests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `crowd_invests_user_id_foreign` (`user_id`),
  ADD KEY `crowd_invests_crowd_schema_id_foreign` (`crowd_schema_id`);

--
-- Indexes for table `crowd_schemas`
--
ALTER TABLE `crowd_schemas`
  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 `holidays`
--
ALTER TABLE `holidays`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `reward_point_redeems`
--
ALTER TABLE `reward_point_redeems`
  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 `user_devices`
--
ALTER TABLE `user_devices`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `withdraw_accounts`
--
ALTER TABLE `withdraw_accounts`
  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 UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `crowd_invests`
--
ALTER TABLE `crowd_invests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crowd_schemas`
--
ALTER TABLE `crowd_schemas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `holidays`
--
ALTER TABLE `holidays`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invests`
--
ALTER TABLE `invests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `log_activities`
--
ALTER TABLE `log_activities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `referral_relationships`
--
ALTER TABLE `referral_relationships`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `reward_point_earnings`
--
ALTER TABLE `reward_point_earnings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reward_point_redeems`
--
ALTER TABLE `reward_point_redeems`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `schemas`
--
ALTER TABLE `schemas`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `user_devices`
--
ALTER TABLE `user_devices`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `withdraw_accounts`
--
ALTER TABLE `withdraw_accounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `crowd_invests`
--
ALTER TABLE `crowd_invests`
  ADD CONSTRAINT `crowd_invests_crowd_schema_id_foreign` FOREIGN KEY (`crowd_schema_id`) REFERENCES `crowd_schemas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `crowd_invests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- 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;

