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

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

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

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `code`, `for`, `banner`, `title`, `subject`, `salutation`, `message_body`, `button_level`, `button_link`, `footer_status`, `footer_body`, `bottom_status`, `bottom_title`, `bottom_body`, `short_codes`, `status`, `created_at`, `updated_at`) VALUES
(1, 'User Mail Send', 'user_mail', 'User', 'global/images/Uxp3vfYFFi4GuO95lyZn.jpg', 'Sample Email', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', 'Thanks for joining us  [[site_title]]<br />\r\n<br />\r\n[[message]]<br />\r\n<br />\r\n<br />\r\nFind out more about in - [[site_url]]', 'Login Your Account', 'https://hyiorio.tdevs.co/login', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.<br />\r\n<br />\r\n[[site_url]]', '[\"[[full_name]]\",\"[[site_url]]\",\"[[site_title]]\",\"[[subject]]\",\"[[message]]\"]', 0, NULL, '2022-12-10 00:37:23'),
(2, 'Subscriber Mail Send', 'subscriber_mail', 'Subscriber', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[message]]<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]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[message]]<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]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.<br />\r\n<br />\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[subject]]\",\"[[message]]\"]', 0, NULL, '2022-12-10 00:37:30'),
(3, 'Email Verification', 'email_verification', 'User', NULL, 'Verify Email Address', 'Verify Email Address', 'Hi [[full_name]],', 'Hello!<br />\r\nPlease click the button below to verify your email address.', 'Verify Email Address', '[[token]]', 1, 'Regards,<br />\r\n[[site_title]]', 1, 'Verify Email Address', 'If you\'re having trouble clicking the \"Verify Email Address\" button, copy and paste the URL below into your web browser:[[token]]', '[\"[[token]]\",\"[[full_name]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2023-02-16 09:06:43'),
(4, 'Forget Password', 'user_password_change', 'User', NULL, 'User Password Change', 'User Forget Password', 'Hi user,', 'Please click the button below to Change the Password.', 'Reset Password', '[[token]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'User Password Change', '[[token]]', '[\"[[token]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2023-02-16 09:07:29'),
(5, 'User Investment', 'user_investment', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'You Invested on [[plan_name]]', 'Thanks for the Investment on [[site_title]]', 'Hi [[full_name]],', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', 'Login Account', '[[token]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Successfully Investment', '[[txn]]. \' Successfully Investment', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2022-12-05 02:03:15'),
(6, 'User Account Disabled', 'user_account_disabled', 'User', NULL, 'Sorry to say that', 'Your Account is Disabled', 'Hi [[full_name]],', 'Your account is disabled for a serious cause. Sorry! you\'re unable to use your account again.', 'Contact Us', 'https://hyiprio.tdevs.co/contact', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'User Account Disabled', '[[full_name]]', '[\"[[full_name]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2022-12-05 02:03:19'),
(7, 'Manual Deposit request', 'manual_deposit_request', 'Admin', NULL, 'Manual Deposit request', 'Got a request for Manual Deposit', 'Hi Admin,', 'The manual deposit request details:<br />\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]', 'Review The requests', 'https://hyiprio.tdevs.co/admin', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Manual Deposit request', '[[site_title]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2023-02-04 02:27:15'),
(8, 'Withdraw Request', 'withdraw_request ', 'Admin', NULL, 'Withdraw Request', 'Got a Withdraw Request', 'Hi Admin,', 'Withdraw Request details:<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]', 'Withdraw Request', '[[token]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2022-12-05 02:03:27'),
(9, 'Admin Forget Password', 'admin_forget_password', 'Admin', NULL, 'Admin Forget Password', 'Admin Forget Password', 'Hi Admin,', 'Please click the button below to reset your password', 'Password reset', '[[token]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]   <br />\r\n[[token]]', '[\"[[token]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2022-12-05 02:03:31'),
(10, 'Contact Mail Send', 'contact_mail', 'Admin', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', '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]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[message]]<br />\r\n<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]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.<br />\r\n<br />\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[subject]]\",\"[[message]]\"]', 0, NULL, '2022-12-05 02:03:36'),
(11, 'KYC Request', 'kyc_request', 'Admin', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', '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]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[kyc_type]]<br />\r\n<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]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.<br />\r\n<br />\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[kyc_type]]\"]', 0, NULL, '2023-01-30 05:12:10'),
(12, 'KYC Action', 'kyc_action', 'User', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', '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]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! ---  [[site_title]]<br />\r\n<br />\r\n[[kyc_type]]<br />\r\n<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]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.<br />\r\n<br />\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[message]]\",\"[[kyc_type]]\"]', 0, NULL, '2023-01-30 05:12:19'),
(13, 'Invest ROI', 'invest_roi', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'You Invested on [[plan_name]]', 'Thanks for the Investment on [[site_title]]', 'Hi [[full_name]],', 'Hello!<br />\n[[txn]]. \'Successfully Investment<br />\n[[plan_name]]<br />\n[[invest_amount]]<br />\n[[roi]]', 'Login Account', 'hi', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Successfully ROI', '[[txn]]. \' Successfully ROI', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[roi]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2023-01-30 05:11:41'),
(14, 'Investment End', 'investment_end', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'You Invested on [[plan_name]]', 'Thanks for the Investment on [[site_title]]', 'Hi [[full_name]],', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment End<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', 'Hello', '#', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Successfully Investment', 'Successfully Investment End', '[\"[[full_name]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 0, NULL, '2023-01-30 05:11:57'),
(15, 'Withdraw Request Action', 'withdraw_request_user', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'Withdraw Request', 'Got a Withdraw Request', 'Hi [[full_name]],', '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]]', 'Withdraw Request', '[[site_url]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 0, NULL, '2023-01-30 05:11:57'),
(16, 'Manual Deposit request Action', 'user_manual_deposit_request', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'Manual Deposit request', 'Got a request for Manual Deposit', 'Hi [[full_name]],', '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', 'Review The requests', '[[site_url]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Manual Deposit request', '[[full_name]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 0, NULL, '2023-01-30 05:11:57'),
(17, 'Support Ticket', 'user_support_ticket', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'Support Ticket', 'Support Ticket', 'Hi [[full_name]],', 'Support Ticket:<br />\r\n[[title]]<br />\r\n[[message]]<br />\r\n[[status]]', '..', '[[site_url]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Support Ticket', '[[full_name]]', '[\"[[full_name]]\",\"[[title]]\",\"[[message]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, '2023-04-26 14:44:42'),
(18, 'Support Ticket', 'admin_support_ticket', 'Admin', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'Support Ticket', 'Support Ticket', 'Hi [[full_name]],', 'Support Ticket:<br />\r\n[[title]]<br />\r\n[[message]]<br />\r\n[[status]]', '..', '[[site_url]]', 1, 'Regards,<br />\r\n[[site_title]]', 0, 'Support Ticket', '[[full_name]]', '[\"[[full_name]]\",\"[[title]]\",\"[[message]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, '2023-04-26 14:44:51');

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

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

CREATE TABLE `gateways` (
  `id` bigint UNSIGNED NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gateway_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `supported_currencies` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `credentials` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_withdraw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `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 `gateways`
--

INSERT INTO `gateways` (`id`, `logo`, `name`, `gateway_code`, `supported_currencies`, `credentials`, `is_withdraw`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/gateway/paypal.png', 'Paypal', 'paypal', '[\"USD\", \"EUR\", \"GBP\", \"CAD\", \"AUD\", \"JPY\", \"SGD\", \"NZD\", \"CHF\", \"SEK\", \"NOK\", \"DKK\", \"PLN\", \"HUF\", \"CZK\", \"ILS\", \"BRL\", \"MXN\", \"HKD\", \"TWD\", \"TRY\", \"INR\", \"RUB\", \"ZAR\", \"MYR\", \"THB\", \"IDR\", \"PHP\", \"NGN\", \"GHS\"]', '{\"client_id\":\"AUnfkQ3v2J-d5g-ZEq8l5Oosha8FmAJ3Z9jt71BkD6l-Z3FMIR5FmkYp_6QHwaYx0LvMNvHDsB9Vh84O\",\"client_secret\":\"EJjci35CFj762ut15pn0VWmojEG0GwE68byyHnBq_NoAXXW9mjkjdLFYLfVQwyLs8QAbP1QJAXPl5oAl\",\"app_id\":\"APP-80W284485P519543T\",\"mode\":\"sandbox\"}', 'paypal_email', 1, NULL, '2023-06-20 16:51:45'),
(2, 'global/gateway/stripe.png', 'Stripe', 'stripe', '[\"USD\",\"AUD\",\"BRL\",\"CAD\",\"CHF\",\"DKK\",\"EUR\",\"GBP\",\"HKD\",\"INR\",\"JPY\",\"MXN\",\"MYR\",\"NOK\",\"NZD\",\"PLN\",\"SEK\",\"SGD\"]', '{\"stripe_key\":\"pk_test_51KHQhKAmfDlh6wQq4srkOEY3FkivTCXmRSb7bJqr90q3ZkVWAR2AkRWfKBnegpmKAHea5cNVAToiy7yoa3Q075mR00jlhXsZTO\",\"stripe_secret\":\"sk_test_51KHQhKAmfDlh6wQqXfg4ZScnTRahxbdXV0mKw30nOI4f8gtB2v5rho7IyJtZqkf8SwwuNgLTO2WPGFyk9vnFl8gO00MhSe8Kbj\"}', '0', 1, NULL, '2022-11-13 07:46:46'),
(3, 'global/gateway/mollie.png', 'Mollie', 'mollie', '[\"EUR\", \"USD\", \"GBP\", \"CAD\", \"AUD\", \"CHF\", \"DKK\", \"NOK\", \"SEK\", \"PLN\", \"CZK\", \"HUF\", \"RON\", \"BGN\", \"HRK\", \"ISK\", \"ZAR\"]', '{\"api_key\":\"test_intSTCDEBaDSu28D6DUpn5wnQhTnzB\"}', '0', 1, NULL, '2022-10-28 15:43:50'),
(4, 'global/gateway/perfectmoney.png', 'Perfect Money', 'perfectmoney', '[\"USD\", \"EUR\", \"RUB\", \"UAH\"]', '{\"PM_ACCOUNTID\":\"96793260\",\"PM_PASSPHRASE\":\"77887848a\",\"PM_MARCHANTID\":\"U36928259\",\"PM_MARCHANT_NAME\":\"tdevs\"}', 'member_id', 1, NULL, '2023-06-19 13:01:24'),
(5, 'global/gateway/coinbase.png', 'Coinbase', 'coinbase', '[\"USD\", \"EUR\", \"GBP\", \"CAD\", \"AUD\", \"JPY\", \"BTC\", \"ETH\", \"LTC\", \"BCH\", \"XRP\", \"EOS\"]', '{\"apiKey\":\"8ef6c4ca-f5c7-4717-9d9a-002adf7e7590\",\"account_id\":\"\",\"private_key\":\"\",\"webhookSecret\":\"b789f547-8954-4880-89ae-5a0233006647\",\"apiVersion\":\"2018-03-22\"}', 'email_address', 1, NULL, '2022-10-28 19:16:15'),
(6, 'global/gateway/paystack.png', 'Paystack', 'paystack', '[\"NGN\", \"USD\", \"GBP\", \"EUR\", \"GHS\", \"KES\", \"ZAR\", \"UGX\", \"TZS\", \"RWF\"]', '{\"public_key\":\"pk_test_8e60e513e47ba5619ac0888c9fac99f2853641fa\",\"secret_key\":\"sk_test_e521a3c6d1c37897092868e02e0ddba8c3f0aa01\",\"merchant_email\":\"learn2222earn@gmail.com\"}', '0', 1, NULL, '2022-12-17 09:18:45'),
(7, 'global/gateway/voguepay.png', 'Voguepay', 'voguepay', '[\"USD\", \"EUR\", \"GBP\", \"NGN\", \"GHS\", \"KES\", \"ZAR\", \"UGX\", \"TZS\", \"RWF\"]', '{\"merchant_id\":\"sandbox_760e43f202878f651659820234cad9\"}', '0', 1, NULL, '2022-11-14 02:08:13'),
(8, 'global/gateway/flutterwave.png', 'Flutterwave', 'flutterwave', '[\"USD\", \"EUR\", \"GBP\", \"NGN\", \"GHS\", \"KES\", \"ZAR\", \"UGX\", \"TZS\", \"RWF\", \"CAD\", \"AUD\", \"JPY\", \"INR\"]', '{\"public_key\":\"FLWPUBK_TEST-34d73043494d02b871d7ba051efa471f-X\",\"secret_key\":\"FLWSECK_TEST-efc192c9a48969fc259c517aef8bcc82-X\",\"encryption_key\":\"FLWSECK_TEST4a47bb501118\"}', 'account_bank,account_number', 1, NULL, '2022-12-16 23:06:06'),
(9, 'global/gateway/coingate.png', 'CoinGate', 'coingate', '[\"BTC\", \"ETH\", \"LTC\", \"XRP\", \"BCH\", \"EOS\", \"XLM\", \"XMR\", \"DASH\", \"DOGE\", \"ZEC\"]', '{\"api_token\":\"NPfn5eAGjha_PqfQmC6F_rMA6_zaGVLmVk6Uvsfu\"}', '0', 1, NULL, '2022-11-22 22:01:12'),
(10, 'global/gateway/monnify.svg', 'Monnify', 'monnify', '[\"NGN\"]', '{\"api_key\":\"MK_TEST_BDQKAE9QNX\",\"api_secret\":\"4PSEUWJJ1HAKEYPXTT375CR9Y1LLX369\",\"base_url\":\"https:\\/\\/sandbox.monnify.com\",\"contract_code\":\"0086188339\"}', '0', 1, NULL, '2022-12-05 09:02:39'),
(11, 'global/gateway/securionpay.png', 'SecurionPay', 'securionpay', '[\"USD\", \"EUR\", \"GBP\", \"JPY\", \"CAD\", \"AUD\", \"CHF\", \"SEK\", \"NOK\", \"DKK\"]', '{\"public_key\":\"pk_test_7bkvbNaJzb1Eh2Egtp9NQ9Os\",\"secret_key\":\"sk_test_7bkvbSEKpHWR4bJL8qdoq7c9\"}', '0', 1, NULL, '2022-12-07 11:11:19'),
(12, 'global/gateway/coinpayments.svg', 'CoinPayments', 'coinpayments', '[\"BTC\", \"BTC.LN\", \"BCH\", \"LTC\", \"VLX\", \"VLX.Native\", \"APL\", \"ASK\", \"BCN\", \"BEAM\", \"BIZZ.TRC20\", \"BNB\", \"BNB.BSC\", \"BTCV\", \"BTG\", \"BTT.OLD\", \"BTT.TRC20\", \"CELO\", \"CLOAK\", \"CRW\", \"CURE\", \"cUSD\", \"USD\", \"CAD\", \"EUR\", \"ARS\", \"AUD\", \"AZN\", \"BGN\", \"BRL\", \"BYN\", \"CHF\", \"CLP\", \"CNY\", \"COP\", \"CZK\",\"DKK\", \"GBP\", \"GIP\", \"HKD\", \"HUF\", \"IDR\", \"ILS\", \"INR\", \"IRR\", \"IRT\", \"ISK\",\"JPY\",\"KRW\",\"LAK\",\"MKD\",\"MXN\",\"ZAR\",\"MYR\", \"NGN\", \"NOK\", \"NZD\", \"PEN\", \"PHP\", \"PKR\", \"PLN\", \"RON\", \"RUB\", \"SEK\", \"SGD\", \"THB\", \"TRY\", \"TWD\", \"UAH\", \"VND\"]', '{\"buyer_email\":\"tdevs330@gmail.com\",\"public_key\":\"07de16d3d2100a2440dc81b8659e1b1e607501ca1a5d57f5dfeeedcee361d7a2\",\"private_key\":\"077D15c2C8F915efbbb054a97A3dcc35a7c994e5F6111deb20f38D3AfF34eD8D\",\"ipn_secret\":\"@tdevs\",\"marchant_id\":\"26dd12941806e2c5e8ecc30460c8b7fc\"}', '0', 1, NULL, '2023-07-08 02:18:04'),
(13, 'global/gateway/nowpayments.png', 'Nowpayments', 'nowpayments', '[\"BTC\", \"ETH\", \"LTC\", \"BCH\", \"BNB\", \"XRP\", \"USDT\", \"DOGE\", \"ADA\", \"DOT\", \"LINK\", \"XLM\", \"USDC\", \"TRX\", \"ATOM\", \"XTZ\", \"EOS\", \"XMR\", \"ZEC\", \"DASH\"]', '{\"api_key\":\"SZTR71W-Z48MZ8G-Q5YH6X5-91F72XK\",\"secret_key\":\"cX7FhXcLYX\\/KJPqFnGgRKbcXDzyVUccN\"}', '0', 1, NULL, '2023-07-07 03:33:31'),
(14, 'global/gateway/coinremitter.png', 'Coinremitter', 'coinremitter', '[\"BTC\",\"ETH\"]', '{\"api_key\":\"$2y$10$mTa7SwWG8k1hJ\\/LP3PLTrOclnliQSrC99fsc528mBeTqBsNlj4MvK\",\"password\":\"12345678\"}', 'to_address', 1, NULL, '2023-07-07 03:33:31'),
(15, 'global/gateway/cryptomus.png', 'Cryptomus', 'cryptomus', '[\"BCH\",\"BNB\",\"BTC\",\"BUSD\",\"CGPT\",\"DAI\",\"DASH\",\"DOFE\",\"ETH\",\"LTC\",\"MATIC\",\"TON\",\"TRX\",\"USDC\",\"USDT\",\"VERSE\",\"XMR\"]\r\n\r\n', '{\"payment_key\":\"uQ4LFWCBE3dT84uQnt7ycL7p9WcSwjkSPQaZbik3ChoWO0egw51f4EAaZQKmefhPP0F1cX8OpRcl2c3HexNedoR7FGEYGA1mTgMPI8lzKl7Ct2I43R6SSC3gVDS3rkGX\",\"payout_key\":\"qseRhcxu6wsxhygfhyidwrrgryrrgefhPP0F1cNedoR7FGEYGA1mTgMPX8OpRcl2c3HexNedoR7FGEYGA1mTgMPI8lzKl7Ct2I43R6S1f4EAaZQKmefhSC3gVDS3rkGX\",\"merchant_id\":\"c26b80a8-9549-4a66-bb53-774f12809249\"}', 'address', 1, NULL, '2023-07-08 10:20:55'),
(16, 'global/gateway/paymongo.png', 'Paymongo', 'paymongo', '[\"PHP\", \"USD\", \"AUD\", \"CAD\", \"EUR\", \"HKD\", \"JPY\", \"SGD\", \"GBP\"]\n', '{\"public_key\":\"pk_test_4dV3PdbbGie3BffowbHVSKCU\",\"secret_key\":\"sk_test_xA6gsPKtgESQY1YMndhufaCo\",\"password\":\"5k0HVZ0^%33n\"}', '0', 1, NULL, '2023-07-11 04:48:12'),
(17, 'global/gateway/btcpayserver.png', 'Btcpayserver', 'btcpayserver', '[\"BTC\", \"ETH\", \"XRP\", \"BCH\", \"LTC\", \"ADA\", \"DOT\", \"LINK\", \"XLM\", \"DOGE\"]', '{\"host\":\"https:\\/\\/btcpay.greenway.management\",\"api_key\":\"94f975f1af98d75df559b9d67e13993929ed2e01\",\"store_id\":\"8kP1mwvGdFpFd55pYkuA8B6fEomnUUvGAa8Ad4n4z91M\",\"webhook_secret\":\"3awb9SbJkqozTkYrfGJ5Bx1R8Xrz\"}', '0', 1, NULL, '2023-07-07 03:33:31'),
(18, 'global/gateway/binance.svg', 'Binance', 'binance', '[\"BTC\", \"ETH\", \"BNB\", \"XRP\", \"LTC\", \"BCH\", \"ADA\", \"DOT\", \"LINK\",\"XLM\",\"USDT\",\"USDC\",\"DOGE\",\"SOL\",\"UNI\",\"MATIC\",\"ICP\", \"ETC\", \"XMR\", \"THETA\"]', '{\"api_key\":\"nmgmcaz7oaqijdefee8okmoghsrxrnxzctxzkm7nsgqwjhxe2i7hhyncsgihgxiu\",\"api_secret\":\"birh9qjpyyg4jtt9zsok2ozvpaq3cc9gb1wrtn8ojcnfas71ulg9cxm4su6kttbx\"}', 'address', 1, NULL, '2023-08-17 17:42:51'),
(19, 'global/gateway/cashmaal.png', 'Cashmaal', 'cashmaal', '[\"USD\", \"PKR\"]', '{\"web_id\":\"9101\",\"secret_key\":\"\"}', 'to_email', 1, NULL, '2023-08-19 18:47:56'),
(20, 'global/gateway/blockio.png', 'Block.io', 'blockio', '[\"BTC\", \"LTC\",\"DOGE\"]', '{\"pin\":\"169725cdd2800148b029f804f8f681f102c69b3c\",\"api_key\":\"d4a4-399b-8b74-c73f\"}', 'to_address', 1, NULL, '2023-09-02 14:06:34'),
(21, 'global/gateway/blockchain.png', 'Blockchain', 'blockchain', '[\"BTC\"]', '{\"api_key\":\"21\",\"xpub_code\":\"12\"}', '0', 1, NULL, '2023-08-29 04:30:54'),
(22, 'global/gateway/instamojo.png', 'Instamojo', 'instamojo', '[\"INR\"]', '{\"api_key\":\"test_2241633c3bc44a3de84a3b33969\",\"auth_token\":\"test_279f083f7bebefd35217feef22d\",\"salt\":\"19d38908eeff4f58b2ddda2c6d86ca25\"}', '0', 1, NULL, '2023-08-29 04:30:54'),
(23, 'global/gateway/paytm.png', 'Paytm', 'paytm', '[\"AUD\", \"ARS\", \"BDT\", \"BRL\", \"BGN\", \"CAD\", \"CLP\", \"CNY\", \"COP\",\r\n    \"HRK\", \"CZK\", \"DKK\", \"EGP\", \"EUR\", \"GEL\", \"GHS\", \"HKD\", \"HUF\",\r\n    \"INR\", \"IDR\", \"ILS\", \"JPY\", \"KES\", \"MYR\", \"MXN\", \"MAD\", \"NPR\",\r\n    \"NZD\", \"NGN\", \"NOK\", \"PKR\", \"PEN\", \"PHP\", \"PLN\", \"RON\", \"RUB\",\r\n    \"SGD\", \"ZAR\", \"KRW\", \"LKR\", \"SEK\", \"CHF\", \"THB\", \"TRY\", \"UGX\",\r\n    \"UAH\", \"AED\", \"GBP\", \"USD\", \"VND\", \"XOF\"]', '{\"merchant_id\":\"DIY12386817555501617\",\"merchant_key\":\"bKMfNxPPf_QdZppa\",\"merchant_website\":\"DIYtestingweb\",\"channel\":\"WEB\",\"industry_type\":\"Retail\"}', '0', 1, NULL, '2023-08-30 07:47:57'),
(24, 'global/gateway/razorpay.png', 'Razorpay', 'razorpay', '[\"INR\"]', '{\"razorpay_key\":\"rzp_test_kiOtejPbRZU90E\",\"razorpay_secret\":\"osRDebzEqbsE1kbyQJ4y0re7\"}', '0', 1, NULL, '2023-08-30 14:13:27'),
(25, 'global/gateway/twocheckout.png', '2Checkout', 'twocheckout', '[\"AFN\", \"ALL\", \"DZD\", \"ARS\", \"AUD\", \"AZN\", \"BSD\", \"BDT\", \"BBD\", \"BZD\", \r\n    \"BMD\", \"BOB\", \"BWP\", \"BRL\", \"GBP\", \"BND\", \"BGN\", \"CAD\", \"CLP\", \"CNY\", \r\n    \"COP\", \"CRC\", \"HRK\", \"CZK\", \"DKK\", \"DOP\", \"XCD\", \"EGP\", \"EUR\", \"FJD\", \r\n    \"GTQ\", \"HKD\", \"HNL\", \"HUF\", \"INR\", \"IDR\", \"ILS\", \"JMD\", \"JPY\", \"KZT\", \r\n    \"KES\", \"LAK\", \"MMK\", \"LBP\", \"LRD\", \"MOP\", \"MYR\", \"MVR\", \"MRO\", \"MUR\", \r\n    \"MXN\", \"MAD\", \"NPR\", \"TWD\", \"NZD\", \"NIO\", \"NOK\", \"PKR\", \"PGK\", \"PEN\", \r\n    \"PHP\", \"PLN\", \"QAR\", \"RON\", \"RUB\", \"WST\", \"SAR\", \"SCR\", \"SGD\", \"SBD\", \r\n    \"ZAR\", \"KRW\", \"LKR\", \"SEK\", \"CHF\", \"SYP\", \"THB\", \"TOP\", \"TTD\", \"TRY\", \r\n    \"UAH\", \"AED\", \"USD\", \"VUV\", \"VND\", \"XOF\", \"YER\"]', '{\"seller_id\":\"250507228545\",\"secret_word\":\"=+0CNzfvTItqp*ygwiQE\"}', '0', 1, NULL, '2023-08-30 14:13:27');

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

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

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

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

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

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

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

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

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

CREATE TABLE `languages` (
  `id` bigint 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', 1, 1, NULL, '2023-05-24 18:24:32'),
(8, NULL, 'Spanish', 'es', 0, 1, '2022-10-05 19:17:20', '2023-05-24 18:23:48'),
(10, NULL, 'Franch', 'fr', 0, 1, '2022-11-07 01:23:27', '2023-07-31 13:13:34');

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

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

CREATE TABLE `level_referrals` (
  `id` bigint 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,
  `activation` double NOT 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`, `activation`) VALUES
(1, 'deposit', '1', 2, '2023-03-29 05:38:44', '2023-03-29 05:38:44', 0),
(2, 'deposit', '2', 5, '2023-03-29 05:38:52', '2023-03-29 05:38:52', 0),
(3, 'deposit', '3', 10, '2023-03-29 05:39:00', '2023-03-29 05:39:00', 0),
(4, 'investment', '1', 3, '2023-03-29 05:39:12', '2023-03-29 05:39:12', 0),
(5, 'investment', '2', 6, '2023-03-29 05:39:22', '2023-03-29 05:39:22', 0),
(6, 'investment', '3', 10, '2023-03-29 05:39:28', '2023-03-29 05:39:28', 0),
(7, 'profit', '1', 4, '2023-03-29 05:39:47', '2023-03-29 05:39:47', 0),
(8, 'profit', '2', 8, '2023-03-29 05:39:56', '2023-03-29 05:39:56', 0),
(9, 'profit', '3', 12, '2023-03-29 05:40:03', '2023-03-29 05:40:03', 0);

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

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

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

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

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

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

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

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

CREATE TABLE `migrations` (
  `id` int 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);

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

--
-- 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),
(3, 'App\\Models\\Admin', 2),
(2, 'App\\Models\\Admin', 3),
(2, 'App\\Models\\Admin', 4),
(2, 'App\\Models\\Admin', 5);

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

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

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

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

CREATE TABLE `notifications` (
  `id` bigint 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;

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

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

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

INSERT INTO `pages` (`id`, `title`, `code`, `data`, `type`, `status`, `created_at`, `updated_at`, `locale`, `url`) VALUES
(1, 'Schema', 'schema', '{\"title\":\"All the Schemas\",\"title_small\":\"Our Investment Plans\",\"title_big\":\"The plans we offer is specifically made for you.\",\"left_top_img\":\"global\\/images\\/J2spy6ilkLergst4Glcy.png\",\"meta_keywords\":\"All the Schemas\",\"meta_description\":\"All the Schemas\"}', 'static', 1, NULL, '2023-07-31 14:26:56', 'en', 'schema'),
(2, 'How It Works', 'howitworks', '{\"title\":\"How it Works\",\"title_small\":\"How it Works\",\"title_big\":\"The process and steps of the application\",\"section_id\":\"9\",\"meta_keywords\":\"How it Works\",\"meta_description\":\"How it Works\"}', 'static', 1, NULL, '2023-07-31 14:27:10', 'en', 'how-it-works'),
(3, 'About Us', 'about', '{\"title\":\"About Us\",\"left_img_badge\":\"High Yield Hyip Investment\",\"title_small\":\"Who We Are\",\"title_big\":\"Explore us from the experience\",\"side_content\":\"In no event shall Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract.  Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website. Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elitss\\r\\n\\r\\nLorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates libero!ss\",\"content\":\"<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit<\\/p>\\n\\n<p>Lorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates<\\/p>\",\"aboutusLeftImg\":\"global\\/images\\/g4xp4oSimXAEZGvOKugJ.png\",\"meta_keywords\":\"About Us\",\"meta_description\":\"About Us\"}', 'static', 1, NULL, '2022-11-17 17:35:10', 'en', 'about-us'),
(4, 'FAQ ', 'faq', '{\"title\":\"FAQ Page\",\"title_small\":\"FAQ Page\",\"title_big\":\"Explore Your Questions\",\"section_id\":\"9\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"hero_button2_target\":\"_self\",\"meta_keywords\":\"FAQ Page\",\"meta_description\":\"FAQ Page\"}', 'static', 1, NULL, '2023-07-31 14:29:23', 'en', 'faq'),
(5, 'Rankings ', 'ranking', '{\"title\":\"Rankings Page\",\"title_small\":\"Achievements\",\"title_big\":\"Explore all the badges here\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"$\",\"hero_button2_target\":\"_blank\",\"content\":\"<p><br><\\/p>\",\"meta_keywords\":\"Rankings Page\",\"meta_description\":\"Rankings Page\"}', 'static', 1, NULL, '2022-11-16 20:08:45', 'en', 'rankings'),
(6, 'Blog ', 'blog', '{\"title\":\"All Blogs\",\"title_small\":\"Blog Title Smallss\",\"title_big\":\"Our Latest News\",\"sidebar_widget_title\":\"Other Blog Posts\",\"sidebar_widget_title_2\":\"Recent Blogss\",\"meta_keywords\":\"All Blogs\",\"meta_description\":\"All Blogs\"}', 'static', 1, NULL, '2022-11-17 17:47:21', 'en', 'blog'),
(7, 'Contact Us', 'contact', '{\"title\":\"Contact Us\",\"title_small\":\"Get In Touch\",\"title_big\":\"Say Hi to us\",\"meta_keywords\":\"Contact Us\",\"meta_description\":\"Contact Us\"}', 'static', 1, NULL, '2022-11-16 23:42:33', 'en', 'contact'),
(8, 'Privacy Policy', 'privacy', '{\"title\":\"Privacy Policy\",\"content\":\"<p><b>Privacy Policy for Hyiprio<\\/b><\\/p>\\r\\n\\r\\n<p><\\/p>\\r\\n\\r\\n<p>At Hyiprio, accessible at hyiprio.com, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Website Name and how we use it.If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us through email at info@hyiprio.com<\\/p>\\r\\n\\r\\n<p>This privacy policy applies only to our online activities and is valid for visitors to our website with regard to the information that they shared and\\/or collect in the hyiprio.com. This policy is not applicable to any information collected offline or via channels other than this website.<\\/p>\\r\\n\\r\\n<p>Consent<\\/p>\\r\\n\\r\\n<p>By using our website, you hereby consent to our Privacy Policy and agree to its terms.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\r\\n\\r\\n<p>Information we collect<\\/p>\\r\\n\\r\\n<p>The personal information that you are asked to provide, and the reasons why you are asked to provide it, will be made clear to you at the point we ask you to provide your personal information.\\u00a0If you contact us directly, we may receive additional information about you such as your name, email address, phone number, the contents of the message and\\/or attachments you may send us, and any other information you may choose to provide.<\\/p>\\r\\n\\r\\n<p>When you register for an Account, we may ask for your contact information, including items such as name, company name, address, email address, and telephone number.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\r\\n\\r\\n<p>How we use your information<\\/p>\\r\\n\\r\\n<p>We use the information we collect in various ways, including to:<\\/p>\\r\\n\\r\\n<p>Provide, operate, and maintain our websiteImprove, personalize, and expand our websiteUnderstand and analyze how you use our websiteDevelop new products, services, features, and functionalityCommunicate with you, either directly or through one of our partners, including for customer service, to provide you with updates and other information relating to the website, and for marketing and promotional purposesSend you emailsFind and prevent fraud<\\/p>\\r\\n\\r\\n<p>Log Files<\\/p>\\r\\n\\r\\n<p>Hyiprio follows a standard procedure of using log files. These files log visitors when they visit websites. All hosting companies do this and a part of hosting services\' analytics. The information collected by log files include internet protocol (IP) addresses, browser type, Internet Service Provider (ISP), date and time stamp, referring\\/exit pages, and possibly the number of clicks. These are not linked to any information that is personally identifiable. The purpose of the information is for analyzing trends, administering the site, tracking users\' movement on the website, and gathering demographic information.<\\/p>\\r\\n\\r\\n<p>Cookies and Web Beacons<\\/p>\\r\\n\\r\\n<p>Like any other website, Website Name uses \\u2018cookies\'. These cookies are used to store information including visitors\' preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users\' experience by customizing our web page content based on visitors\' browser type and\\/or other information.<\\/p>\\r\\n\\r\\n<p>DoubleClick DART Cookie<\\/p>\\r\\n\\r\\n<p>Google is one of a third-party vendor on our site. It also uses cookies, known as DART cookies, to serve ads to our site visitors based upon their visit to www.website.com and other sites on the internet. However, visitors may choose to decline the use of DART cookies by visiting the Google ad and content network Privacy Policy at the following URL \\u2013 https:\\/\\/policies.google.com\\/technologies\\/ads.<\\/p>\\r\\n\\r\\n<p>Some of advertisers on our site may use cookies and web beacons. Our advertising partners are listed below. Each of our advertising partners has their own Privacy Policy for their policies on user data. For easier access, we hyperlinked to their Privacy Policies below.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\r\\n\\r\\n<p>Google<\\/p>\\r\\n\\r\\n<p>https:\\/\\/policies.google.com\\/technologies\\/ads<\\/p>\\r\\n\\r\\n<p>Advertising Partners Privacy Policies<\\/p>\\r\\n\\r\\n<p>You may consult this list to find the Privacy Policy for each of the advertising partners of Website Name.<\\/p>\\r\\n\\r\\n<p>Third-party ad servers or ad networks uses technologies like cookies, JavaScript, or Web Beacons that are used in their respective advertisements and links that appear on Website Name, which are sent directly to users\' browser. They automatically receive your IP address when this occurs. These technologies are used to measure the effectiveness of their advertising campaigns and\\/or to personalize the advertising content that you see on websites that you visit.\\u00a0Note that Website Name has no access to or control over these cookies that are used by third-party advertisers.<\\/p>\\r\\n\\r\\n<p>Third-Party Privacy Policies<\\/p>\\r\\n\\r\\n<p>Website Name\'s Privacy Policy does not apply to other advertisers or websites. Thus, we are advising you to consult the respective Privacy Policies of these third-party ad servers for more detailed information. It may include their practices and instructions about how to opt-out of certain options. You may find a complete list of these Privacy Policies and their links here: Privacy Policy Links.<\\/p>\\r\\n\\r\\n<p>You can choose to disable cookies through your individual browser options. To know more detailed information about cookie management with specific web browsers, it can be found at the browsers\' respective websites. What Are Cookies?<\\/p>\\r\\n\\r\\n<p>CCPA Privacy Policy (Do Not Sell My Personal Information)<\\/p>\\r\\n\\r\\n<p>Under the CCPA, among other rights, California consumers have the right to:<\\/p>\\r\\n\\r\\n<p>Request that a business that collects a consumer\'s personal data disclose the categories and specific pieces of personal data that a business has collected about consumers.\\u00a0Request that a business deletes any personal data about the consumer that a business has collected.\\u00a0Request that a business that sells a consumer\'s personal data, not sell the consumer\'s personal data.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\r\\n\\r\\n<p>GDPR Privacy Policy (Data Protection Rights)<\\/p>\\r\\n\\r\\n<p>We would like to make sure you are fully aware of all of your data protection rights. Every user is entitled to the following:<\\/p>\\r\\n\\r\\n<p>The right to access \\u2013 You have the right to request copies of your personal data. We may charge you a small fee for this service.\\u00a0The right to rectification \\u2013 You have the right to request that we correct any information you believe is inaccurate. You also have the right to request that we complete the information you believe is incomplete.<\\/p>\\r\\n\\r\\n<p>The right to erasure \\u2013 You have the right to request that we erase your personal data, under certain conditions.\\u00a0The right to restrict processing \\u2013 You have the right to request that we restrict the processing of your personal data, under certain conditions.\\u00a0The right to object to processing \\u2013 You have the right to object to our processing of your personal data, under certain conditions.\\u00a0The right to data portability \\u2013 You have the right to request that we transfer the data that we have collected to another organization, or directly to you, under certain conditions.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.<\\/p>\\r\\n\\r\\n<p>Children\'s Information<\\/p>\\r\\n\\r\\n<p>Another part of our priority is adding protection for children while using the internet. We encourage parents and guardians to observe, participate in, and\\/or monitor and guide their online activity.\\u00a0Website Name does not knowingly collect any Personal Identifiable Information from children under the age of 13. If you think that your child provided this kind of information on our website, we strongly encourage you to contact us immediately and we will do our best efforts to promptly remove such information from our records.<\\/p>\",\"files\":\"global\\/images\\/h0hwylrv2QFLC0bAHxQk.jpg\",\"meta_keywords\":\"Privacy Policy\",\"meta_description\":\"Privacy Policy\"}', 'static', 1, NULL, '2023-01-23 12:06:16', 'en', 'privacy-policy'),
(9, 'Terms and Conditions', 'terms', '{\"title\":\"Terms and Conditions\",\"content\":\"<h4><span style=\\\"font-weight:normal;\\\">Introduction<\\/span><\\/h4>\\n\\n<p>These Website Standard Terms and Conditions written on this webpage shall manage your use of our website,\\u00a0Hyiprio accessible at\\u00a0hyiprio.com.<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<p>These Terms will be applied fully and affect to your use of this Website. By using this Website, you agreed to accept all terms and conditions written in here. You must not use this Website if you disagree with any of these Website Standard Terms and Conditions.<span>Minors or people below 18 years old are not allowed to use this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Intellectual Property Rights<\\/span><\\/h4>\\n\\n<p>Other than the content you own, under these Terms,\\u00a0Company Name\\u00a0and\\/or its licensors own all the intellectual property rights and materials contained in this Website.\\u00a0<span>You are granted limited license only for purposes of viewing the material contained on this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Restrictions<\\/span><\\/h4>\\n\\n<p>You are specifically restricted from all of the following:<\\/p>\\n\\n<ul><li>publishing any Website material in any other media;<\\/li><li>selling, sublicensing and\\/or otherwise commercializing any Website material;<\\/li><li>publicly performing and\\/or showing any Website material;<\\/li><li>using this Website in any way that is or may be damaging to this Website;<\\/li><li>using this Website in any way that impacts user access to this Website;<\\/li><li>using this Website contrary to applicable laws and regulations, or in any way may cause harm to the Website, or to any person or business entity;<\\/li><li>engaging in any data mining, data harvesting, data extracting or any other similar activity in relation to this Website;<\\/li><li>using this Website to engage in any advertising or marketing.<\\/li><\\/ul>\\n\\n<p>Certain areas of this Website are restricted from being access by you and\\u00a0Company Name\\u00a0may further restrict access by you to any areas of this Website, at any time, in absolute discretion. Any user ID and password you may have for this Website are confidential and you must maintain confidentiality as well.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Your Content<\\/span><\\/h4>\\n\\n<p>In these Website Standard Terms and Conditions, \\u201cYour Content\\u201d shall mean any audio, video text, images or other material you choose to display on this Website. By displaying Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Your Content must be your own and must not be invading any third-party\'s rights.\\u00a0Company Name\\u00a0reserves the right to remove any of Your Content from this Website at any time without notice.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">No warranties<\\/span><\\/h4>\\n\\n<p>This Website is provided \\u201cas is,\\u201d with all faults, and\\u00a0Company Name\\u00a0express no representations or warranties, of any kind related to this Website or the materials contained on this Website. Also, nothing contained on this Website shall be interpreted as advising you.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Limitation of liability<\\/span><\\/h4>\\n\\n<p>In no event shall\\u00a0Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract. \\u00a0Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Indemnification<\\/span><\\/h4>\\n\\n<h5><span style=\\\"font-weight:normal;\\\">You hereby indemnify to the fullest extent\\u00a0Company Name\\u00a0from and against any and\\/or all liabilities, costs, demands, causes of action, damages and expenses arising in any way related to your breach of any of the provisions of these Terms.<\\/span><\\/h5>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Severability<\\/span><\\/h4>\\n\\n<p>If any provision of these Terms is found to be invalid under any applicable law, such provisions shall be deleted without affecting the remaining provisions herein.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Variation of Terms<\\/span><\\/h4>\\n\\n<p>Company Name\\u00a0is permitted to revise these Terms at any time as it sees fit, and by using this Website you are expected to review these Terms on a regular basis.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Assignment<\\/span><\\/h4>\\n\\n<p>The\\u00a0Company Name\\u00a0is allowed to assign, transfer, and subcontract its rights and\\/or obligations under these Terms without any notification. However, you are not allowed to assign, transfer, or subcontract any of your rights and\\/or obligations under these Terms.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Entire Agreement<\\/span><\\/h4>\\n\\n<p>These Terms constitute the entire agreement between\\u00a0Company Name\\u00a0and you in relation to your use of this Website, and supersede all prior agreements and understandings.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Governing Law &amp; Jurisdiction<\\/span><\\/h4>\\n\\n<p>These Terms will be governed by and interpreted in accordance with the laws of the State of\\u00a0Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in\\u00a0Country\\u00a0for the resolution of any disputes.<\\/p>\",\"files\":\"global\\/images\\/1gcQReqxFvALwGLLItbu.jpg\",\"meta_keywords\":\"Terms and Conditions\",\"meta_description\":\"Terms and Conditions\"}', 'static', 1, NULL, '2022-11-17 17:40:00', 'en', 'terms-and-conditions'),
(10, 'Login', 'login', '{\"title\":\"\\ud83d\\udc4b Welcome Back!\",\"bottom_text\":\"Sign in to continue with Hyiprio User Panel\"}', 'static', 1, NULL, '2022-10-24 07:08:53', 'en', '/login'),
(11, 'Registration', 'registration', '{\"title\":\"\\ud83d\\udcaa Create an account\",\"bottom_text\":\"Register to continue with Hyiprio\"}', 'static', 1, NULL, '2022-11-10 08:35:48', 'en', '/registration'),
(12, 'Forgot Password', 'forgetpassword', '{\"title\":\"Password Reset\",\"bottom_text\":\"Reset your Password\"}', 'static', 1, NULL, '2022-11-16 09:24:24', 'en', '/forgot-password'),
(13, 'Schema', 'schema', '{\"title\":\"todos los esquemas\",\"title_small\":\"todos los esquemas\",\"title_big\":\"Los planes que ofrecemos est\\u00e1n hechos espec\\u00edficamente para usted.\",\"left_top_img\":\"global\\/images\\/I68p4rslg9zW4R83R9sN.png\",\"meta_keywords\":\"todos los esquemas\",\"meta_description\":\"todos los esquemas\"}', 'static', 1, '2023-05-13 15:03:38', '2023-07-31 14:26:56', 'es', 'schema'),
(14, 'Schema', 'schema', '{\"title\":\"Tous les sch\\u00e9mas\",\"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\\/I68p4rslg9zW4R83R9sN.png\",\"meta_keywords\":\"Tous les sch\\u00e9mas\",\"meta_description\":\"Tous les sch\\u00e9mas\"}', 'static', 1, '2023-05-13 15:03:44', '2023-07-31 14:26:56', 'fr', 'schema'),
(18, 'Blog ', 'blog', '{\"title\":\"Tous les blogs\",\"title_small\":\"Blog Title Smallss\",\"title_big\":\"Nos derni\\u00e8res nouvelles\",\"sidebar_widget_title\":\"Autres articles de blog\",\"sidebar_widget_title_2\":\"Recent Blogss\",\"meta_keywords\":\"Tous les blogs\",\"meta_description\":\"Tous les blogs\"}', 'static', 1, '2023-05-13 16:28:25', '2023-07-31 14:33:10', 'fr', 'blog'),
(19, 'How It Works', 'howitworks', '{\"title\":\"C\\u00f3mo funciona\",\"title_small\":\"C\\u00f3mo funciona\",\"title_big\":\"El proceso y los pasos de la aplicaci\\u00f3n.\",\"section_id\":\"9\",\"meta_keywords\":\"C\\u00f3mo funciona\",\"meta_description\":\"C\\u00f3mo funciona\"}', 'static', 1, '2023-05-14 12:04:06', '2023-07-31 14:27:30', 'es', 'how-it-works'),
(20, 'About Us', 'about', '{\"title\":\"Sobre nosotras\",\"left_img_badge\":\"Inversi\\u00f3n Hyip de alto rendimiento\",\"title_small\":\"Quienes somos\",\"title_big\":\"Exploranos desde la experiencia\",\"side_content\":\"In no event shall Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract.  Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website. Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elitss\\r\\n\\r\\nLorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates libero!ss\",\"content\":\"<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit<\\/p>\\n\\n<p>Lorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates<\\/p>\",\"aboutusLeftImg\":\"global\\/images\\/g4xp4oSimXAEZGvOKugJ.png\",\"meta_keywords\":\"Sobre nosotras\",\"meta_description\":\"Sobre nosotras\"}', 'static', 1, '2023-05-14 12:11:32', '2023-07-31 14:28:30', 'es', 'about-us'),
(21, 'FAQ ', 'faq', '{\"title\":\"P\\u00e1gina de preguntas frecuentes\",\"title_small\":\"P\\u00e1gina de preguntas frecuentes\",\"title_big\":\"Explora tus preguntas\",\"section_id\":\"9\",\"button_icon\":\"anticon-mail\",\"button_level\":\"\\u00bfTodav\\u00eda sin suerte?\",\"button_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"hero_button2_target\":\"_self\",\"meta_keywords\":\"P\\u00e1gina de preguntas frecuentes\",\"meta_description\":\"P\\u00e1gina de preguntas frecuentes\"}', 'static', 1, '2023-05-14 12:18:11', '2023-07-31 14:30:00', 'es', 'faq'),
(22, 'Rankings ', 'ranking', '{\"title\":\"P\\u00e1gina de clasificaciones\",\"title_small\":\"logros\",\"title_big\":\"Explora todas las insignias aqu\\u00ed\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"$\",\"hero_button2_target\":\"_blank\",\"content\":\"<p><br><\\/p>\",\"meta_keywords\":\"P\\u00e1gina de clasificaciones\",\"meta_description\":\"P\\u00e1gina de clasificaciones\"}', 'static', 1, '2023-05-14 12:22:10', '2023-07-31 14:31:49', 'es', 'rankings'),
(23, 'Contact Us', 'contact', '{\"title\":\"Contactez-nous\",\"title_small\":\"Entrer en contact\",\"title_big\":\"Dites-nous bonjour\",\"meta_keywords\":\"Contactez-nous\",\"meta_description\":\"Contactez-nous\"}', 'static', 1, '2023-05-14 12:45:05', '2023-07-31 14:34:56', 'fr', 'contact'),
(24, 'Terms and Conditions', 'terms', '{\"title\":\"T\\u00e9rminos y condiciones\",\"content\":\"<h4><span style=\\\"font-weight:normal;\\\">Introduction<\\/span><\\/h4>\\n\\n<p>These Website Standard Terms and Conditions written on this webpage shall manage your use of our website,\\u00a0Hyiprio accessible at\\u00a0hyiprio.com.<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<p>These Terms will be applied fully and affect to your use of this Website. By using this Website, you agreed to accept all terms and conditions written in here. You must not use this Website if you disagree with any of these Website Standard Terms and Conditions.<span>Minors or people below 18 years old are not allowed to use this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Intellectual Property Rights<\\/span><\\/h4>\\n\\n<p>Other than the content you own, under these Terms,\\u00a0Company Name\\u00a0and\\/or its licensors own all the intellectual property rights and materials contained in this Website.\\u00a0<span>You are granted limited license only for purposes of viewing the material contained on this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Restrictions<\\/span><\\/h4>\\n\\n<p>You are specifically restricted from all of the following:<\\/p>\\n\\n<ul><li>publishing any Website material in any other media;<\\/li><li>selling, sublicensing and\\/or otherwise commercializing any Website material;<\\/li><li>publicly performing and\\/or showing any Website material;<\\/li><li>using this Website in any way that is or may be damaging to this Website;<\\/li><li>using this Website in any way that impacts user access to this Website;<\\/li><li>using this Website contrary to applicable laws and regulations, or in any way may cause harm to the Website, or to any person or business entity;<\\/li><li>engaging in any data mining, data harvesting, data extracting or any other similar activity in relation to this Website;<\\/li><li>using this Website to engage in any advertising or marketing.<\\/li><\\/ul>\\n\\n<p>Certain areas of this Website are restricted from being access by you and\\u00a0Company Name\\u00a0may further restrict access by you to any areas of this Website, at any time, in absolute discretion. Any user ID and password you may have for this Website are confidential and you must maintain confidentiality as well.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Your Content<\\/span><\\/h4>\\n\\n<p>In these Website Standard Terms and Conditions, \\u201cYour Content\\u201d shall mean any audio, video text, images or other material you choose to display on this Website. By displaying Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Your Content must be your own and must not be invading any third-party\'s rights.\\u00a0Company Name\\u00a0reserves the right to remove any of Your Content from this Website at any time without notice.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">No warranties<\\/span><\\/h4>\\n\\n<p>This Website is provided \\u201cas is,\\u201d with all faults, and\\u00a0Company Name\\u00a0express no representations or warranties, of any kind related to this Website or the materials contained on this Website. Also, nothing contained on this Website shall be interpreted as advising you.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Limitation of liability<\\/span><\\/h4>\\n\\n<p>In no event shall\\u00a0Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract. \\u00a0Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Indemnification<\\/span><\\/h4>\\n\\n<h5><span style=\\\"font-weight:normal;\\\">You hereby indemnify to the fullest extent\\u00a0Company Name\\u00a0from and against any and\\/or all liabilities, costs, demands, causes of action, damages and expenses arising in any way related to your breach of any of the provisions of these Terms.<\\/span><\\/h5>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Severability<\\/span><\\/h4>\\n\\n<p>If any provision of these Terms is found to be invalid under any applicable law, such provisions shall be deleted without affecting the remaining provisions herein.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Variation of Terms<\\/span><\\/h4>\\n\\n<p>Company Name\\u00a0is permitted to revise these Terms at any time as it sees fit, and by using this Website you are expected to review these Terms on a regular basis.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Assignment<\\/span><\\/h4>\\n\\n<p>The\\u00a0Company Name\\u00a0is allowed to assign, transfer, and subcontract its rights and\\/or obligations under these Terms without any notification. However, you are not allowed to assign, transfer, or subcontract any of your rights and\\/or obligations under these Terms.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Entire Agreement<\\/span><\\/h4>\\n\\n<p>These Terms constitute the entire agreement between\\u00a0Company Name\\u00a0and you in relation to your use of this Website, and supersede all prior agreements and understandings.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Governing Law &amp; Jurisdiction<\\/span><\\/h4>\\n\\n<p>These Terms will be governed by and interpreted in accordance with the laws of the State of\\u00a0Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in\\u00a0Country\\u00a0for the resolution of any disputes.<\\/p>\",\"files\":\"global\\/images\\/1gcQReqxFvALwGLLItbu.jpg\",\"meta_keywords\":\"T\\u00e9rminos y condiciones\",\"meta_description\":\"T\\u00e9rminos y condiciones\"}', 'static', 1, '2023-05-14 13:12:28', '2023-07-31 14:35:38', 'es', 'terms-and-conditions'),
(25, 'Login', 'login', '{\"title\":\"\\ud83d\\udc4b \\u00a1Bienvenido de nuevo!\",\"bottom_text\":\"Inicie sesi\\u00f3n para continuar con el panel de usuario de Hyiprio\"}', 'static', 1, '2023-05-14 13:13:54', '2023-07-31 14:36:20', 'es', '/login'),
(26, 'How It Works', 'howitworks', '{\"title\":\"Comment \\u00e7a fonctionne\",\"title_small\":\"Comment \\u00e7a fonctionne\",\"title_big\":\"Le processus et les \\u00e9tapes de la demande\",\"section_id\":\"9\",\"meta_keywords\":\"Comment \\u00e7a fonctionne\",\"meta_description\":\"Comment \\u00e7a fonctionne\"}', 'static', 1, '2023-07-19 06:53:11', '2023-07-31 14:27:42', 'fr', 'how-it-works'),
(36, 'About Us', 'about', '{\"title\":\"\\u00c0 propos de nous\",\"left_img_badge\":\"Investissement Hyip \\u00e0 haut rendement\",\"title_small\":\"Qui nous sommes\",\"title_big\":\"D\\u00e9couvrez-nous \\u00e0 partir de l\'exp\\u00e9rience\",\"side_content\":\"In no event shall Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract.  Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website. Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elitss\\r\\n\\r\\nLorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates libero!ss\",\"content\":\"<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit<\\/p>\\n\\n<p>Lorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates<\\/p>\",\"aboutusLeftImg\":\"global\\/images\\/g4xp4oSimXAEZGvOKugJ.png\",\"meta_keywords\":\"\\u00c0 propos de nous\",\"meta_description\":\"\\u00c0 propos de nous\"}', 'static', 1, '2023-07-31 14:29:00', '2023-07-31 14:29:00', 'fr', 'about-us'),
(37, 'FAQ ', 'faq', '{\"title\":\"FAQ\",\"title_small\":\"FAQ\",\"title_big\":\"Explorez vos questions\",\"section_id\":\"9\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Toujours pas de chance\\u00a0?\",\"button_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"hero_button2_target\":\"_self\",\"meta_keywords\":\"FAQ\",\"meta_description\":\"FAQ\"}', 'static', 1, '2023-07-31 14:30:25', '2023-07-31 14:30:25', 'fr', 'faq'),
(38, 'Rankings ', 'ranking', '{\"title\":\"Page des classements\",\"title_small\":\"R\\u00e9alisations\",\"title_big\":\"D\\u00e9couvrez tous les badges ici\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"$\",\"hero_button2_target\":\"_blank\",\"content\":\"<p><br><\\/p>\",\"meta_keywords\":\"Page des classements\",\"meta_description\":\"Page des classements\"}', 'static', 1, '2023-07-31 14:32:14', '2023-07-31 14:32:14', 'fr', 'rankings'),
(39, 'Blog ', 'blog', '{\"title\":\"Todos los blogs\",\"title_small\":\"Blog Title Smallss\",\"title_big\":\"Nuestras \\u00faltimas noticias\",\"sidebar_widget_title\":\"Otras publicaciones de blog\",\"sidebar_widget_title_2\":\"Recent Blogss\",\"meta_keywords\":\"Todos los blogs\",\"meta_description\":\"Todos los blogs\"}', 'static', 1, '2023-07-31 14:32:47', '2023-07-31 14:32:47', 'es', 'blog'),
(40, 'Contact Us', 'contact', '{\"title\":\"Contacta con nosotras\",\"title_small\":\"Ponerse en contacto\",\"title_big\":\"Saluda a nosotras\",\"meta_keywords\":\"Contacta con nosotras\",\"meta_description\":\"Contacta con nosotras\"}', 'static', 1, '2023-07-31 14:34:28', '2023-07-31 14:34:28', 'es', 'contact'),
(41, 'Privacy Policy', 'privacy', '{\"title\":\"politique de confidentialit\\u00e9\",\"content\":\"<p><b>Privacy Policy for Hyiprio<\\/b><\\/p>\\n\\n\\n\\n<p>At Hyiprio, accessible at hyiprio.com, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Website Name and how we use it.If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us through email at info@hyiprio.com<\\/p>\\n\\n<p>This privacy policy applies only to our online activities and is valid for visitors to our website with regard to the information that they shared and\\/or collect in the hyiprio.com. This policy is not applicable to any information collected offline or via channels other than this website.<\\/p>\\n\\n<p>Consent<\\/p>\\n\\n<p>By using our website, you hereby consent to our Privacy Policy and agree to its terms.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Information we collect<\\/p>\\n\\n<p>The personal information that you are asked to provide, and the reasons why you are asked to provide it, will be made clear to you at the point we ask you to provide your personal information.\\u00a0If you contact us directly, we may receive additional information about you such as your name, email address, phone number, the contents of the message and\\/or attachments you may send us, and any other information you may choose to provide.<\\/p>\\n\\n<p>When you register for an Account, we may ask for your contact information, including items such as name, company name, address, email address, and telephone number.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>How we use your information<\\/p>\\n\\n<p>We use the information we collect in various ways, including to:<\\/p>\\n\\n<p>Provide, operate, and maintain our websiteImprove, personalize, and expand our websiteUnderstand and analyze how you use our websiteDevelop new products, services, features, and functionalityCommunicate with you, either directly or through one of our partners, including for customer service, to provide you with updates and other information relating to the website, and for marketing and promotional purposesSend you emailsFind and prevent fraud<\\/p>\\n\\n<p>Log Files<\\/p>\\n\\n<p>Hyiprio follows a standard procedure of using log files. These files log visitors when they visit websites. All hosting companies do this and a part of hosting services\' analytics. The information collected by log files include internet protocol (IP) addresses, browser type, Internet Service Provider (ISP), date and time stamp, referring\\/exit pages, and possibly the number of clicks. These are not linked to any information that is personally identifiable. The purpose of the information is for analyzing trends, administering the site, tracking users\' movement on the website, and gathering demographic information.<\\/p>\\n\\n<p>Cookies and Web Beacons<\\/p>\\n\\n<p>Like any other website, Website Name uses \\u2018cookies\'. These cookies are used to store information including visitors\' preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users\' experience by customizing our web page content based on visitors\' browser type and\\/or other information.<\\/p>\\n\\n<p>DoubleClick DART Cookie<\\/p>\\n\\n<p>Google is one of a third-party vendor on our site. It also uses cookies, known as DART cookies, to serve ads to our site visitors based upon their visit to www.website.com and other sites on the internet. However, visitors may choose to decline the use of DART cookies by visiting the Google ad and content network Privacy Policy at the following URL \\u2013 https:\\/\\/policies.google.com\\/technologies\\/ads.<\\/p>\\n\\n<p>Some of advertisers on our site may use cookies and web beacons. Our advertising partners are listed below. Each of our advertising partners has their own Privacy Policy for their policies on user data. For easier access, we hyperlinked to their Privacy Policies below.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Google<\\/p>\\n\\n<p>https:\\/\\/policies.google.com\\/technologies\\/ads<\\/p>\\n\\n<p>Advertising Partners Privacy Policies<\\/p>\\n\\n<p>You may consult this list to find the Privacy Policy for each of the advertising partners of Website Name.<\\/p>\\n\\n<p>Third-party ad servers or ad networks uses technologies like cookies, JavaScript, or Web Beacons that are used in their respective advertisements and links that appear on Website Name, which are sent directly to users\' browser. They automatically receive your IP address when this occurs. These technologies are used to measure the effectiveness of their advertising campaigns and\\/or to personalize the advertising content that you see on websites that you visit.\\u00a0Note that Website Name has no access to or control over these cookies that are used by third-party advertisers.<\\/p>\\n\\n<p>Third-Party Privacy Policies<\\/p>\\n\\n<p>Website Name\'s Privacy Policy does not apply to other advertisers or websites. Thus, we are advising you to consult the respective Privacy Policies of these third-party ad servers for more detailed information. It may include their practices and instructions about how to opt-out of certain options. You may find a complete list of these Privacy Policies and their links here: Privacy Policy Links.<\\/p>\\n\\n<p>You can choose to disable cookies through your individual browser options. To know more detailed information about cookie management with specific web browsers, it can be found at the browsers\' respective websites. What Are Cookies?<\\/p>\\n\\n<p>CCPA Privacy Policy (Do Not Sell My Personal Information)<\\/p>\\n\\n<p>Under the CCPA, among other rights, California consumers have the right to:<\\/p>\\n\\n<p>Request that a business that collects a consumer\'s personal data disclose the categories and specific pieces of personal data that a business has collected about consumers.\\u00a0Request that a business deletes any personal data about the consumer that a business has collected.\\u00a0Request that a business that sells a consumer\'s personal data, not sell the consumer\'s personal data.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>GDPR Privacy Policy (Data Protection Rights)<\\/p>\\n\\n<p>We would like to make sure you are fully aware of all of your data protection rights. Every user is entitled to the following:<\\/p>\\n\\n<p>The right to access \\u2013 You have the right to request copies of your personal data. We may charge you a small fee for this service.\\u00a0The right to rectification \\u2013 You have the right to request that we correct any information you believe is inaccurate. You also have the right to request that we complete the information you believe is incomplete.<\\/p>\\n\\n<p>The right to erasure \\u2013 You have the right to request that we erase your personal data, under certain conditions.\\u00a0The right to restrict processing \\u2013 You have the right to request that we restrict the processing of your personal data, under certain conditions.\\u00a0The right to object to processing \\u2013 You have the right to object to our processing of your personal data, under certain conditions.\\u00a0The right to data portability \\u2013 You have the right to request that we transfer the data that we have collected to another organization, or directly to you, under certain conditions.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.<\\/p>\\n\\n<p>Children\'s Information<\\/p>\\n\\n<p>Another part of our priority is adding protection for children while using the internet. We encourage parents and guardians to observe, participate in, and\\/or monitor and guide their online activity.\\u00a0Website Name does not knowingly collect any Personal Identifiable Information from children under the age of 13. If you think that your child provided this kind of information on our website, we strongly encourage you to contact us immediately and we will do our best efforts to promptly remove such information from our records.<\\/p>\",\"files\":\"global\\/images\\/h0hwylrv2QFLC0bAHxQk.jpg\",\"meta_keywords\":\"politique de confidentialit\\u00e9\",\"meta_description\":\"politique de confidentialit\\u00e9\"}', 'static', 1, '2023-07-31 14:35:14', '2023-07-31 14:35:14', 'fr', 'privacy-policy');
INSERT INTO `pages` (`id`, `title`, `code`, `data`, `type`, `status`, `created_at`, `updated_at`, `locale`, `url`) VALUES
(42, 'Privacy Policy', 'privacy', '{\"title\":\"pol\\u00edtica de privacidad\",\"content\":\"<p><b>Privacy Policy for Hyiprio<\\/b><\\/p>\\n\\n\\n\\n<p>At Hyiprio, accessible at hyiprio.com, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Website Name and how we use it.If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us through email at info@hyiprio.com<\\/p>\\n\\n<p>This privacy policy applies only to our online activities and is valid for visitors to our website with regard to the information that they shared and\\/or collect in the hyiprio.com. This policy is not applicable to any information collected offline or via channels other than this website.<\\/p>\\n\\n<p>Consent<\\/p>\\n\\n<p>By using our website, you hereby consent to our Privacy Policy and agree to its terms.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Information we collect<\\/p>\\n\\n<p>The personal information that you are asked to provide, and the reasons why you are asked to provide it, will be made clear to you at the point we ask you to provide your personal information.\\u00a0If you contact us directly, we may receive additional information about you such as your name, email address, phone number, the contents of the message and\\/or attachments you may send us, and any other information you may choose to provide.<\\/p>\\n\\n<p>When you register for an Account, we may ask for your contact information, including items such as name, company name, address, email address, and telephone number.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>How we use your information<\\/p>\\n\\n<p>We use the information we collect in various ways, including to:<\\/p>\\n\\n<p>Provide, operate, and maintain our websiteImprove, personalize, and expand our websiteUnderstand and analyze how you use our websiteDevelop new products, services, features, and functionalityCommunicate with you, either directly or through one of our partners, including for customer service, to provide you with updates and other information relating to the website, and for marketing and promotional purposesSend you emailsFind and prevent fraud<\\/p>\\n\\n<p>Log Files<\\/p>\\n\\n<p>Hyiprio follows a standard procedure of using log files. These files log visitors when they visit websites. All hosting companies do this and a part of hosting services\' analytics. The information collected by log files include internet protocol (IP) addresses, browser type, Internet Service Provider (ISP), date and time stamp, referring\\/exit pages, and possibly the number of clicks. These are not linked to any information that is personally identifiable. The purpose of the information is for analyzing trends, administering the site, tracking users\' movement on the website, and gathering demographic information.<\\/p>\\n\\n<p>Cookies and Web Beacons<\\/p>\\n\\n<p>Like any other website, Website Name uses \\u2018cookies\'. These cookies are used to store information including visitors\' preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users\' experience by customizing our web page content based on visitors\' browser type and\\/or other information.<\\/p>\\n\\n<p>DoubleClick DART Cookie<\\/p>\\n\\n<p>Google is one of a third-party vendor on our site. It also uses cookies, known as DART cookies, to serve ads to our site visitors based upon their visit to www.website.com and other sites on the internet. However, visitors may choose to decline the use of DART cookies by visiting the Google ad and content network Privacy Policy at the following URL \\u2013 https:\\/\\/policies.google.com\\/technologies\\/ads.<\\/p>\\n\\n<p>Some of advertisers on our site may use cookies and web beacons. Our advertising partners are listed below. Each of our advertising partners has their own Privacy Policy for their policies on user data. For easier access, we hyperlinked to their Privacy Policies below.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Google<\\/p>\\n\\n<p>https:\\/\\/policies.google.com\\/technologies\\/ads<\\/p>\\n\\n<p>Advertising Partners Privacy Policies<\\/p>\\n\\n<p>You may consult this list to find the Privacy Policy for each of the advertising partners of Website Name.<\\/p>\\n\\n<p>Third-party ad servers or ad networks uses technologies like cookies, JavaScript, or Web Beacons that are used in their respective advertisements and links that appear on Website Name, which are sent directly to users\' browser. They automatically receive your IP address when this occurs. These technologies are used to measure the effectiveness of their advertising campaigns and\\/or to personalize the advertising content that you see on websites that you visit.\\u00a0Note that Website Name has no access to or control over these cookies that are used by third-party advertisers.<\\/p>\\n\\n<p>Third-Party Privacy Policies<\\/p>\\n\\n<p>Website Name\'s Privacy Policy does not apply to other advertisers or websites. Thus, we are advising you to consult the respective Privacy Policies of these third-party ad servers for more detailed information. It may include their practices and instructions about how to opt-out of certain options. You may find a complete list of these Privacy Policies and their links here: Privacy Policy Links.<\\/p>\\n\\n<p>You can choose to disable cookies through your individual browser options. To know more detailed information about cookie management with specific web browsers, it can be found at the browsers\' respective websites. What Are Cookies?<\\/p>\\n\\n<p>CCPA Privacy Policy (Do Not Sell My Personal Information)<\\/p>\\n\\n<p>Under the CCPA, among other rights, California consumers have the right to:<\\/p>\\n\\n<p>Request that a business that collects a consumer\'s personal data disclose the categories and specific pieces of personal data that a business has collected about consumers.\\u00a0Request that a business deletes any personal data about the consumer that a business has collected.\\u00a0Request that a business that sells a consumer\'s personal data, not sell the consumer\'s personal data.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.\\u00a0Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>GDPR Privacy Policy (Data Protection Rights)<\\/p>\\n\\n<p>We would like to make sure you are fully aware of all of your data protection rights. Every user is entitled to the following:<\\/p>\\n\\n<p>The right to access \\u2013 You have the right to request copies of your personal data. We may charge you a small fee for this service.\\u00a0The right to rectification \\u2013 You have the right to request that we correct any information you believe is inaccurate. You also have the right to request that we complete the information you believe is incomplete.<\\/p>\\n\\n<p>The right to erasure \\u2013 You have the right to request that we erase your personal data, under certain conditions.\\u00a0The right to restrict processing \\u2013 You have the right to request that we restrict the processing of your personal data, under certain conditions.\\u00a0The right to object to processing \\u2013 You have the right to object to our processing of your personal data, under certain conditions.\\u00a0The right to data portability \\u2013 You have the right to request that we transfer the data that we have collected to another organization, or directly to you, under certain conditions.\\u00a0If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.<\\/p>\\n\\n<p>Children\'s Information<\\/p>\\n\\n<p>Another part of our priority is adding protection for children while using the internet. We encourage parents and guardians to observe, participate in, and\\/or monitor and guide their online activity.\\u00a0Website Name does not knowingly collect any Personal Identifiable Information from children under the age of 13. If you think that your child provided this kind of information on our website, we strongly encourage you to contact us immediately and we will do our best efforts to promptly remove such information from our records.<\\/p>\",\"files\":\"global\\/images\\/h0hwylrv2QFLC0bAHxQk.jpg\",\"meta_keywords\":\"pol\\u00edtica de privacidad\",\"meta_description\":\"pol\\u00edtica de privacidad\"}', 'static', 1, '2023-07-31 14:35:22', '2023-07-31 14:35:22', 'es', 'privacy-policy'),
(43, 'Terms and Conditions', 'terms', '{\"title\":\"Termes et conditions\",\"content\":\"<h4><span style=\\\"font-weight:normal;\\\">Introduction<\\/span><\\/h4>\\n\\n<p>These Website Standard Terms and Conditions written on this webpage shall manage your use of our website,\\u00a0Hyiprio accessible at\\u00a0hyiprio.com.<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<p>These Terms will be applied fully and affect to your use of this Website. By using this Website, you agreed to accept all terms and conditions written in here. You must not use this Website if you disagree with any of these Website Standard Terms and Conditions.<span>Minors or people below 18 years old are not allowed to use this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Intellectual Property Rights<\\/span><\\/h4>\\n\\n<p>Other than the content you own, under these Terms,\\u00a0Company Name\\u00a0and\\/or its licensors own all the intellectual property rights and materials contained in this Website.\\u00a0<span>You are granted limited license only for purposes of viewing the material contained on this Website.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Restrictions<\\/span><\\/h4>\\n\\n<p>You are specifically restricted from all of the following:<\\/p>\\n\\n<ul><li>publishing any Website material in any other media;<\\/li><li>selling, sublicensing and\\/or otherwise commercializing any Website material;<\\/li><li>publicly performing and\\/or showing any Website material;<\\/li><li>using this Website in any way that is or may be damaging to this Website;<\\/li><li>using this Website in any way that impacts user access to this Website;<\\/li><li>using this Website contrary to applicable laws and regulations, or in any way may cause harm to the Website, or to any person or business entity;<\\/li><li>engaging in any data mining, data harvesting, data extracting or any other similar activity in relation to this Website;<\\/li><li>using this Website to engage in any advertising or marketing.<\\/li><\\/ul>\\n\\n<p>Certain areas of this Website are restricted from being access by you and\\u00a0Company Name\\u00a0may further restrict access by you to any areas of this Website, at any time, in absolute discretion. Any user ID and password you may have for this Website are confidential and you must maintain confidentiality as well.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Your Content<\\/span><\\/h4>\\n\\n<p>In these Website Standard Terms and Conditions, \\u201cYour Content\\u201d shall mean any audio, video text, images or other material you choose to display on this Website. By displaying Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/p>\\n\\n<p>Your Content must be your own and must not be invading any third-party\'s rights.\\u00a0Company Name\\u00a0reserves the right to remove any of Your Content from this Website at any time without notice.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">No warranties<\\/span><\\/h4>\\n\\n<p>This Website is provided \\u201cas is,\\u201d with all faults, and\\u00a0Company Name\\u00a0express no representations or warranties, of any kind related to this Website or the materials contained on this Website. Also, nothing contained on this Website shall be interpreted as advising you.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Limitation of liability<\\/span><\\/h4>\\n\\n<p>In no event shall\\u00a0Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract. \\u00a0Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Indemnification<\\/span><\\/h4>\\n\\n<h5><span style=\\\"font-weight:normal;\\\">You hereby indemnify to the fullest extent\\u00a0Company Name\\u00a0from and against any and\\/or all liabilities, costs, demands, causes of action, damages and expenses arising in any way related to your breach of any of the provisions of these Terms.<\\/span><\\/h5>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Severability<\\/span><\\/h4>\\n\\n<p>If any provision of these Terms is found to be invalid under any applicable law, such provisions shall be deleted without affecting the remaining provisions herein.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Variation of Terms<\\/span><\\/h4>\\n\\n<p>Company Name\\u00a0is permitted to revise these Terms at any time as it sees fit, and by using this Website you are expected to review these Terms on a regular basis.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Assignment<\\/span><\\/h4>\\n\\n<p>The\\u00a0Company Name\\u00a0is allowed to assign, transfer, and subcontract its rights and\\/or obligations under these Terms without any notification. However, you are not allowed to assign, transfer, or subcontract any of your rights and\\/or obligations under these Terms.<\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Entire Agreement<\\/span><\\/h4>\\n\\n<p>These Terms constitute the entire agreement between\\u00a0Company Name\\u00a0and you in relation to your use of this Website, and supersede all prior agreements and understandings.\\u00a0<span>Your Content, you grant Company Name a non-exclusive, worldwide irrevocable, sub licensable license to use, reproduce, adapt, publish, translate and distribute it in any and all media.<\\/span><\\/p>\\n\\n<h4><span style=\\\"font-weight:normal;\\\">Governing Law &amp; Jurisdiction<\\/span><\\/h4>\\n\\n<p>These Terms will be governed by and interpreted in accordance with the laws of the State of\\u00a0Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in\\u00a0Country\\u00a0for the resolution of any disputes.<\\/p>\",\"files\":\"global\\/images\\/1gcQReqxFvALwGLLItbu.jpg\",\"meta_keywords\":\"Termes et conditions\",\"meta_description\":\"Termes et conditions\"}', 'static', 1, '2023-07-31 14:35:46', '2023-07-31 14:35:46', 'fr', 'terms-and-conditions'),
(44, 'Login', 'login', '{\"title\":\"\\ud83d\\udc4b Bienvenue \\u00e0 nouveau\\u00a0!\",\"bottom_text\":\"Connectez-vous pour continuer avec le panneau d\'utilisateur Hyiprio\"}', 'static', 1, '2023-07-31 14:36:09', '2023-07-31 14:36:09', 'fr', '/login'),
(45, 'Registration', 'registration', '{\"title\":\"\\ud83d\\udcaa Crear una cuenta\",\"bottom_text\":\"Reg\\u00edstrese para continuar con Hyiprio\"}', 'static', 1, '2023-07-31 14:36:42', '2023-07-31 14:36:42', 'es', '/registration'),
(46, 'Registration', 'registration', '{\"title\":\"\\ud83d\\udcaa Cr\\u00e9er un compte\",\"bottom_text\":\"Inscrivez-vous pour continuer avec Hyiprio\"}', 'static', 1, '2023-07-31 14:36:56', '2023-07-31 14:36:56', 'fr', '/registration'),
(47, 'Forgot Password', 'forgetpassword', '{\"title\":\"R\\u00e9initialisation du mot de passe\",\"bottom_text\":\"R\\u00e9initialisez votre mot de passe\"}', 'static', 1, '2023-07-31 14:37:22', '2023-07-31 14:37:22', 'fr', '/forgot-password'),
(48, 'Forgot Password', 'forgetpassword', '{\"title\":\"Restablecimiento de contrase\\u00f1a\",\"bottom_text\":\"Restablecer su contrase\\u00f1a\"}', 'static', 1, '2023-07-31 14:37:38', '2023-07-31 14:37:38', 'es', '/forgot-password'),
(49, 'test', 'test', '{\"section_id\":\"1\",\"meta_keywords\":\"test\",\"meta_description\":\"sedr\",\"content\":\"<p>test<\\/p>\"}', 'dynamic', 1, '2023-08-23 13:37:44', '2023-08-23 13:37:54', 'en', '/page/test'),
(50, 'test', 'test', '{\"section_id\":\"1\",\"meta_keywords\":\"test\",\"meta_description\":\"sedr\",\"content\":\"<p>test<\\/p>\"}', 'dynamic', 1, '2023-08-23 13:37:57', '2023-08-23 14:05:35', 'es', '/page/test'),
(51, 'test', 'test', '{\"section_id\":\"1\",\"meta_keywords\":\"test\",\"meta_description\":\"sedr\",\"content\":\"<p>test<\\/p>\"}', 'dynamic', 1, '2023-08-23 14:05:38', '2023-08-23 14:05:38', 'fr', '/page/test'),
(52, 'tetset', 'testtt', '{\"section_id\":\"1\",\"meta_keywords\":\"te\",\"meta_description\":\"et\",\"content\":\"<p>tt<\\/p>\"}', 'dynamic', 1, '2023-08-23 14:05:54', '2023-08-23 14:06:13', 'en', '/page/testtt'),
(53, 'ok', 'testtt', '{\"section_id\":\"1\",\"meta_keywords\":\"te\",\"meta_description\":\"et\",\"content\":\"<p>tt<\\/p>\"}', 'dynamic', 1, '2023-08-23 14:06:01', '2023-08-23 14:06:21', 'es', '/page/testtt'),
(54, 'rrer', 'testtt', '{\"section_id\":\"1\",\"meta_keywords\":\"te\",\"meta_description\":\"et\",\"content\":\"<p>tt<\\/p>\"}', 'dynamic', 1, '2023-08-23 14:06:32', '2023-08-23 14:06:32', 'fr', '/page/testtt');

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

--
-- 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/POklQFyF3YG4HBQUd3SU.jpg', NULL, '2023-05-24 17:42:59'),
(2, 'basic_page_background', '#1bb12c', NULL, '2022-10-25 14:27:37'),
(3, 'username_show', '0', '2023-05-24 17:46:21', '2023-09-04 07:20:23'),
(4, 'phone_show', '0', '2023-05-24 17:46:21', '2023-06-11 17:58:29'),
(5, 'country_show', '1', '2023-05-24 17:46:21', '2023-07-21 16:48:54'),
(6, 'referral_code_show', '1', '2023-05-24 17:46:21', '2023-06-11 18:11:54');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `category`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Customer Management', 'customer-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(2, 'Customer Management', 'customer-login', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(3, 'Customer Management', 'customer-mail-send', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(4, 'Customer Management', 'customer-basic-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(5, 'Customer Management', 'customer-balance-add-or-subtract', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(6, 'Customer Management', 'customer-change-password', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(7, 'Customer Management', 'all-type-status', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(8, 'Kyc Management', 'kyc-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(9, 'Kyc Management', 'kyc-action', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(10, 'Kyc Management', 'kyc-form-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(11, 'Role Management', 'role-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(12, 'Role Management', 'role-create', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(13, 'Role Management', 'role-edit', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(14, 'Staff Management', 'staff-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(15, 'Staff Management', 'staff-create', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(16, 'Staff Management', 'staff-edit', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(17, 'Plan Management', 'schedule-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(18, 'Plan Management', 'schema-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(19, 'Plan Management', 'schema-create', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(20, 'Plan Management', 'schema-edit', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(21, 'Transaction Management', 'transaction-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(22, 'Transaction Management', 'investment-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(23, 'Transaction Management', 'profit-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(24, 'Deposit Management', 'automatic-gateway-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(25, 'Deposit Management', 'manual-gateway-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(26, 'Deposit Management', 'deposit-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(27, 'Deposit Management', 'deposit-action', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(28, 'Withdraw Management', 'withdraw-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(29, 'Withdraw Management', 'withdraw-method-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(30, 'Withdraw Management', 'withdraw-action', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(31, 'Withdraw Management', 'withdraw-schedule', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(32, 'Referral Management', 'target-manage', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(33, 'Referral Management', 'referral-create', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(34, 'Referral Management', 'referral-list', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(35, 'Referral Management', 'referral-edit', 'admin', '2023-02-19 07:32:02', '2023-02-19 07:32:02'),
(36, 'Referral Management', 'referral-delete', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(37, 'Ranking Management', 'ranking-list', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(38, 'Ranking Management', 'ranking-create', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(39, 'Ranking Management', 'ranking-edit', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(40, 'Frontend Management', 'landing-page-manage', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(41, 'Frontend Management', 'page-manage', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(42, 'Frontend Management', 'footer-manage', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(43, 'Frontend Management', 'navigation-manage', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(44, 'Subscriber Management', 'subscriber-list', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(45, 'Subscriber Management', 'subscriber-mail-send', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(46, 'Support Ticket Management', 'support-ticket-list', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(47, 'Support Ticket Management', 'support-ticket-action', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(48, 'Setting Management', 'site-setting', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(49, 'Setting Management', 'email-setting', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(50, 'Setting Management', 'plugin-setting', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(51, 'Setting Management', 'language-setting', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(52, 'Setting Management', 'page-setting', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(53, 'Setting Management', 'custom-css', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03'),
(54, 'Setting Management', 'email-template', 'admin', '2023-02-19 07:32:03', '2023-02-19 07:32:03');

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

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

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

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

CREATE TABLE `push_notification_templates` (
  `id` bigint 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.', NULL, 1, NULL, NULL),
(7, 'landmark', 'User Investment Start', 'user_investment', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, NULL, NULL),
(8, 'gem', 'Invested on Profit', 'invest_roi', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]<br />\r\n[[roi]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[roi]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, NULL),
(9, 'git-pull-request-closed', 'Investment End', 'investment_end', 'User', 'You Invested on [[plan_name]]', 'Hello!<br />\r\n[[txn]]. \'Successfully Investment End<br />\r\n[[plan_name]]<br />\r\n[[invest_amount]]', '[\"[[plan_name]]\",\"[[invest_amount]]\"]', 1, NULL, NULL),
(10, 'wallet', 'Withdraw Request Action', 'withdraw_request_user', 'User', 'Withdraw Request', 'Withdraw Request details:<br />\r\n[[message]]<br />\r\n[[txn]]<br />\r\n[[method_name]]<br />\r\n[[withdraw_amount]]<br />\r\n[[status]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[status]]\"]', 1, NULL, NULL),
(11, 'newspaper', 'Manual Deposit request Action', 'user_manual_deposit_request', 'User', 'Manual Deposit request', 'The manual deposit request details:<br />\r\n[[message]]\r\n[[txn]]<br />\r\n[[gateway_name]]<br />\r\n[[deposit_amount]]\r\n[[status]]\r\n', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[status]]\"]', 1, NULL, NULL);

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

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

CREATE TABLE `rankings` (
  `id` bigint 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, 0, 10, 'By earning $50 from the site', 1, '2022-10-15 10:14:53', '2023-02-20 15:21:47'),
(3, 'global/images/hGHllGGCIYfpx5Z2VKrW.svg', 'Level 3', 'Hyip Captain', 0, 0, 0, 0, 0, 200, 20, 'By earning $200 from the site', 1, '2022-10-15 18:16:59', '2022-11-16 09:03:56'),
(4, 'global/images/SaNfYL7WD2pzAAME8Sqb.svg', 'Level 4', 'Hyip Victor', 0, 0, 0, 0, 0, 2000, 50, 'By earning $500 from the site', 1, '2022-10-15 18:18:23', '2022-11-16 09:04:44');

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

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

CREATE TABLE `referrals` (
  `id` bigint 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;

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

--
-- 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 `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'),
(2, 'Manager', 'admin', '2022-09-03 03:29:43', '2022-10-31 15:16:03'),
(3, 'Editor', 'admin', '2022-10-31 14:46:15', '2022-10-31 15:09:24');

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

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

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

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

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

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

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

CREATE TABLE `scheduled_task` (
  `id` bigint 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, 'Hour', 1, '2022-08-28 11:40:42', '2022-11-16 21:46:51'),
(2, 'Daily', 24, '2022-08-28 11:40:54', '2022-08-28 11:48:38'),
(3, 'Weekly', 168, '2022-08-28 11:41:18', '2022-11-12 04:59:06');

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

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

CREATE TABLE `schemas` (
  `id` bigint 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('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `return_interest` double NOT 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,
  `off_days` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `expiry_minute` int DEFAULT '50',
  `is_trending` tinyint(1) DEFAULT '0',
  `schema_cancel` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `schemas` (`id`, `icon`, `name`, `type`, `fixed_amount`, `min_amount`, `max_amount`, `capital_back`, `badge`, `featured`, `status`, `interest_type`, `return_interest`, `return_period`, `return_type`, `number_of_period`, `off_days`, `expiry_minute`, `is_trending`, `schema_cancel`, `created_at`, `updated_at`) VALUES
(1, 'global/images/qHO0xXvfRTXFj3ZiLTq5.png', 'Starter Plan', 'fixed', 400, 0, 0, 1, NULL, 0, 1, 'percentage', 1.5, 2, 'period', 10, NULL, 59, 1, 1, '2022-08-28 11:50:48', '2023-08-04 20:26:46'),
(2, 'global/images/cm3jYayWlxFLLEdYhso5.png', 'Standard Plan', 'range', 0, 500, 2000, 0, 'BEST SCHEMA', 1, 1, 'percentage', 1.2, 3, 'period', 20, '[\"Monday\"]', 40, 0, 1, '2022-08-28 11:54:58', '2023-08-04 20:26:54'),
(3, 'global/images/Y6cMYY9vkrJj4z0gP7jX.png', 'Advanced Plan', 'fixed', 500, 0, 0, 0, NULL, 0, 1, 'fixed', 11, 1, 'lifetime', 0, NULL, 59, 0, 1, '2022-08-28 12:18:03', '2023-08-04 20:27:06'),
(4, 'global/images/NjSS6z1y7aEdJrgPDie7.png', 'Pro Plan', 'fixed', 1000, 0, 0, 1, NULL, 0, 1, 'fixed', 10, 2, 'period', 80, NULL, 50, 0, 1, '2022-10-26 08:45:21', '2023-08-04 20:27:13');

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

--
-- 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 NOT NULL,
  `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', '2023-08-13 15:38:25'),
(6, 'login_bg', 'global/images/bdVMA7Po89q8yjy8LIVh.jpg', 'string', '2022-08-28 02:25:00', '2022-11-17 04:41:41'),
(7, 'site_logo', 'global/images/gfRumZOy2KeS4XHeuBFB.png', 'string', '2022-08-28 02:25:14', '2022-11-16 06:18:00'),
(8, 'site_favicon', 'global/images/dXxWXFfPMXh1N1gcVEdl.png', 'string', '2022-08-28 02:25:14', '2022-11-16 06:18:11'),
(9, 'maintenance_mode', '0', 'boolean', '2022-09-20 14:29:38', '2023-08-01 04:58:23'),
(10, 'maintenance_title', 'Site is not under maintenance for big update with big price', 'string', '2022-09-20 14:29:38', '2023-08-01 04:58:23'),
(11, 'maintenance_text', 'Sorry for interrupting! The site will be live soon.', 'string', '2022-09-20 14:29:38', '2022-09-20 15:04:34'),
(12, 'min_send', '10', 'double', '2022-09-21 08:35:47', '2022-11-13 07:34:21'),
(13, 'max_send', '5000', 'double', '2022-09-21 08:35:47', '2022-11-17 01:40:19'),
(14, 'send_charge_type', 'percentage', 'string', '2022-09-21 08:35:47', '2022-09-21 11:26:22'),
(15, 'send_charge', '5', 'double', '2022-09-21 08:35:47', '2022-11-10 21:07:42'),
(16, 'referral_commission', '21', 'double', '2022-10-10 04:34:02', '2022-10-10 04:34:02'),
(17, 'referral_bonus', '10', 'double', '2022-10-10 14:17:10', '2022-11-11 00:56:34'),
(18, 'signup_bonus', '8', 'double', '2022-10-10 14:17:10', '2023-07-16 12:07:22'),
(19, 'email_verification', '0', 'boolean', '2022-10-12 05:14:39', '2023-09-03 17:51:30'),
(20, 'kyc_verification', '1', 'boolean', '2022-10-12 05:14:39', '2023-04-13 14:38:48'),
(21, 'fa_verification', '0', 'boolean', '2022-10-12 05:14:39', '2022-11-11 00:56:52'),
(22, 'account_creation', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(23, 'user_deposit', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(24, 'user_withdraw', '1', 'boolean', '2022-10-12 05:14:39', '2022-11-17 20:46:38'),
(25, 'sign_up_referral', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(26, 'referral_signup_bonus', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:15:15'),
(27, 'investment_referral_bounty', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(28, 'deposit_referral_bounty', '1', 'boolean', '2022-10-12 05:14:39', '2022-10-12 05:14:39'),
(29, 'email_from_name', '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-08-27 12:52:36'),
(34, 'mail_port', '587', 'integer', '2022-10-29 14:11:51', '2023-08-27 05:37:19'),
(35, 'mail_secure', 'tls', 'string', '2022-10-29 14:11:51', '2023-02-15 11:26:49'),
(36, 'mail_username', 'roi4x1@gmail.com', 'string', '2022-10-29 15:05:23', '2023-08-27 05:37:19'),
(37, 'mail_password', 'lvcimdivvjkjlytm', 'string', '2022-10-29 15:05:23', '2023-08-27 12:52:35'),
(38, 'site_animation', '1', 'boolean', '2022-11-06 10:24:22', '2023-09-03 17:51:42'),
(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', '2023-09-03 17:51:42'),
(45, 'referral_deposit_bonus', '2.4', 'double', '2023-02-04 03:39:35', '2023-02-04 03:39:35'),
(46, 'site_timezone', 'Asia/Dhaka', 'string', '2023-02-15 08:26:05', '2023-02-18 02:41:46'),
(47, 'debug_mode', '0', 'boolean', '2023-02-15 14:07:46', '2023-09-03 17:51:42'),
(48, 'profit_level', '1', 'boolean', NULL, '2023-03-25 00:39:43'),
(49, 'investment_level', '1', 'boolean', NULL, '2023-03-28 06:35:55'),
(50, 'deposit_level', '1', 'boolean', NULL, '2023-03-25 00:39:46'),
(51, 'site_referral', 'level', 'string', '2023-03-25 01:14:29', '2023-07-30 23:13:24'),
(52, 'site_admin_prefix', 'admin', 'string', '2023-05-20 11:03:46', '2023-07-26 12:01:45'),
(53, 'home_redirect', '/', 'string', '2023-05-21 08:16:02', '2023-05-24 11:10:49'),
(54, 'wallet_exchange_day_limit', '1', 'int', '2023-05-24 11:07:21', '2023-07-19 17:58:06'),
(55, 'send_money_day_limit', '14', 'int', '2023-05-24 11:07:21', '2023-05-24 11:07:21'),
(56, 'withdraw_day_limit', '500', 'int', '2023-05-24 11:07:21', '2023-07-20 16:42:42'),
(57, 'investment_cancellation_daily_limit', '7', 'int', '2023-05-24 11:15:41', '2023-05-24 11:15:41'),
(58, 'referral_code_limit', '10', 'integer', '2023-06-11 20:56:07', '2023-06-11 20:56:07'),
(59, 'site_currency_type', 'fiat', 'string', '2023-07-20 12:18:23', '2023-08-13 15:38:25');

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

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

CREATE TABLE `set_tunes` (
  `id` bigint 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', 1, NULL, '2023-05-26 11:37:38'),
(2, 'global/tune-icon/crunchy.png', 'Crunchy', 'global/tune/crunchy.mp3', 0, NULL, '2023-05-26 11:37:38'),
(3, 'global/tune-icon/expert_notification.png', 'Expert Notification', 'global/tune/expert_notification.mp3', 0, NULL, '2023-05-26 11:37:38'),
(4, 'global/tune-icon/knock_knock.png', 'knock knock', 'global/tune/knock_knock.mp3', 0, NULL, '2023-05-26 11:37:38'),
(5, 'global/tune-icon/silencer.png', 'Silencer', 'global/tune/silencer.mp3', 0, NULL, '2023-05-26 11:37:38'),
(6, 'global/tune-icon/sticky.png', 'Sticky', 'global/tune/sticky.mp3', 0, NULL, '2023-05-26 11:37:38'),
(7, 'global/tune-icon/vopvoopvooop.png', 'Vopvoopvooop', 'global/tune/vopvoopvooop.mp3', 0, NULL, '2023-05-26 11:37:38');

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

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

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

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

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

CREATE TABLE `socials` (
  `id` bigint 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, 'Telegram', 'fab fa-telegram', 'https://telegram.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',
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

CREATE TABLE `tickets` (
  `id` bigint 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;

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `ranking_id` bigint DEFAULT NULL,
  `rankings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` enum('male','female','other','') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `date_of_birth` date DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `balance` float(10,2) NOT NULL DEFAULT '0.00',
  `profit_balance` float(10,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `ref_id` int DEFAULT NULL,
  `kyc` tinyint(1) NOT NULL DEFAULT '0',
  `kyc_credential` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `google2fa_secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `two_fa` tinyint(1) NOT NULL DEFAULT '0',
  `deposit_status` tinyint(1) NOT NULL DEFAULT '1',
  `withdraw_status` tinyint(1) NOT NULL DEFAULT '1',
  `transfer_status` tinyint(1) NOT NULL DEFAULT '1',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) 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 `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;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `gateways`
--
ALTER TABLE `gateways`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gateways_gateway_code_unique` (`gateway_code`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_username_unique` (`username`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- 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 dumped tables
--

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

--
-- AUTO_INCREMENT for table `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 `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 for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

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

--
-- 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 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 for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- 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 for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

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

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

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

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

--
-- 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 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 `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

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

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

--
-- 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 for table `users`
--
ALTER TABLE `users`
  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=22;

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

--
-- Constraints for dumped tables
--

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

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

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

