-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint UNSIGNED NOT NULL,
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext 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 `blogs`
--

INSERT INTO `blogs` (`id`, `cover`, `title`, `details`, `created_at`, `updated_at`) VALUES
(6, 'global/images/fyPoqgPqQGspt8cfbFqG.jpg', 'Hyiprio allows to Invest jointly all the way', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source.</p><h4><span style=\"font-weight: normal;\">Essential Narration</span></h4><p>These Website Standard Terms and Conditions written on this webpage shall manage your use of our website,&nbsp;Hyiprio accessible at&nbsp;hyiprio.com.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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">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.Minors or people below 18 years old are not allowed to use this Website.</span></p><h4><span style=\"font-weight: normal;\">Intellectual Property Rights</span></h4><p>Other than the content you own, under these Terms,&nbsp;Company Name&nbsp;and/or its licensors own all the intellectual property rights and materials contained in this Website.&nbsp;You are granted limited license only for purposes of viewing the material contained on this Website.</p><h4><span style=\"font-weight: normal;\">The Steps</span></h4><p>You are specifically restricted from all of the following:</p><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><p>Certain areas of this Website are restricted from being access by you and&nbsp;Company Name&nbsp;may 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><h4><span style=\"font-weight: normal;\">Submission Rights</span></h4><p>In these Website Standard Terms and Conditions, “Your Content” 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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">Your Content must be your own and must not be invading any third-party\'s rights.&nbsp;Company Name&nbsp;reserves the right to remove any of Your Content from this Website at any time without notice.</span></p><h4><img src=\"data:image/jpeg;base64,[encoded data, 144600 characters]\" data-filename=\"counter-bg.jpg\" class=\"\" style=\"width: 1109.25px;\"><br></h4><p><span style=\"text-align: var(--bs-body-text-align);\">Website is provided “as is,” with all faults, and&nbsp;Company Name&nbsp;express 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.&nbsp;</span><span style=\"text-align: var(--bs-body-text-align);\">In no event shall&nbsp;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. &nbsp;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.</span><br></p><h4><span style=\"font-weight: normal;\">Variation of Terms</span></h4><p>Company Name&nbsp;is 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.&nbsp;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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">The&nbsp;Company Name&nbsp;is 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.&nbsp;</span></p><h4><span style=\"font-weight: normal; font-size: 1.5rem; text-align: var(--bs-body-text-align);\">Conclusion</span><br></h4><p>These Terms will be governed by and interpreted in accordance with the laws of the State of&nbsp;Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in&nbsp;Country&nbsp;for the resolution of any disputes.</p>', '2022-11-17 02:49:03', '2022-11-17 18:03:56');
INSERT INTO `blogs` (`id`, `cover`, `title`, `details`, `created_at`, `updated_at`) VALUES
(7, 'global/images/pDx6CXfol13SQ2gJkMKc.jpg', 'Yearly Best Investment authority here', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source.</p><h4><span style=\"font-weight: normal;\">Essential Narration</span></h4><p>These Website Standard Terms and Conditions written on this webpage shall manage your use of our website,&nbsp;Hyiprio accessible at&nbsp;hyiprio.com.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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">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.Minors or people below 18 years old are not allowed to use this Website.</span></p><h4><span style=\"font-weight: normal;\">Intellectual Property Rights</span></h4><p>Other than the content you own, under these Terms,&nbsp;Company Name&nbsp;and/or its licensors own all the intellectual property rights and materials contained in this Website.&nbsp;You are granted limited license only for purposes of viewing the material contained on this Website.</p><h4><span style=\"font-weight: normal;\">The Steps</span></h4><p>You are specifically restricted from all of the following:</p><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><p>Certain areas of this Website are restricted from being access by you and&nbsp;Company Name&nbsp;may 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><h4><span style=\"font-weight: normal;\">Submission Rights</span></h4><p>In these Website Standard Terms and Conditions, “Your Content” 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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">Your Content must be your own and must not be invading any third-party\'s rights.&nbsp;Company Name&nbsp;reserves the right to remove any of Your Content from this Website at any time without notice.</span></p><h4><img src=\"data:image/jpeg;base64,[encoded data, 144600 characters]\" data-filename=\"counter-bg.jpg\" class=\"\" style=\"width: 1109.25px;\"><br></h4><p><span style=\"text-align: var(--bs-body-text-align);\">Website is provided “as is,” with all faults, and&nbsp;Company Name&nbsp;express 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.&nbsp;</span><span style=\"text-align: var(--bs-body-text-align);\">In no event shall&nbsp;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. &nbsp;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.</span><br></p><h4><span style=\"font-weight: normal;\">Variation of Terms</span></h4><p>Company Name&nbsp;is 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.&nbsp;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.&nbsp;<span style=\"text-align: var(--bs-body-text-align);\">The&nbsp;Company Name&nbsp;is 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.&nbsp;</span></p><h4><span style=\"font-weight: normal; font-size: 1.5rem; text-align: var(--bs-body-text-align);\">Conclusion</span><br></h4><p>These Terms will be governed by and interpreted in accordance with the laws of the State of&nbsp;Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in&nbsp;Country&nbsp;for the resolution of any disputes.</p>', '2022-11-17 02:50:10', '2022-11-17 18:04:22');

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

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

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



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

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

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

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

--
-- Table structure for table `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 `kycs`
--

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

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

INSERT INTO `kycs` (`id`, `name`, `fields`, `status`, `created_at`, `updated_at`) VALUES
(1, 'National ID Verification', '{\"1\":{\"name\":\"NID Number\",\"type\":\"text\",\"validation\":\"nullable\"},\"2\":{\"name\":\"Image Of NID\",\"type\":\"file\",\"validation\":\"required\"}}', 1, '2022-11-09 13:02:58', '2022-11-17 00:48:54');

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

--
-- 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
) 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`) VALUES
(5, 'global/images/GUe7aa3wR048JtwDTNum.png', 'Register Account', 'By Registering the website you will able to start your operation', 'howitworks', '2022-10-23 08:31:45', '2022-11-16 16:29:10'),
(6, 'global/images/P5xzjaQe7ylXm6qFP11B.png', 'Verify Email', 'After creating the account user need to verify the email for account purpose', 'howitworks', '2022-10-23 08:32:06', '2022-11-16 16:32:39'),
(7, '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', '2022-11-16 22:13:44'),
(11, 'global/images/Upbk4eWUnmEbOUDb0S1n.png', 'Total Users', '522', 'counter', '2022-10-23 09:25:59', '2022-11-16 22:30:23'),
(14, NULL, 'How does it work with two wallets?', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English.', 'faq', '2022-10-23 09:37:44', '2022-11-16 18:51:14'),
(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'),
(16, 'global/images/aGCyaBe8AwtW7N2cYEFN.png', 'Verify KYC', 'Users\' KYC needs to verify to before making any withdrawals', 'howitworks', '2022-11-16 16:29:51', '2022-11-16 10:34:27'),
(17, 'global/images/nGSUZHiPXmm63xFi7xjc.png', 'Deposit Money', 'Users can deposit using any automatic or manual gateways', 'howitworks', '2022-11-16 16:30:20', '2022-11-16 10:34:17'),
(18, 'global/images/fjpDgKEU945IrHwrw4A9.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', '2022-11-16 10:35:20'),
(19, 'global/images/VQ6BURZon0q6bC0JaUmp.png', 'Transfer Money', 'Users can transfer the fund to another user instantly', 'howitworks', '2022-11-16 16:31:41', '2022-11-16 16:32:49'),
(20, 'global/images/DJr551o3d9Rbnvi0K6MM.png', 'Refer to Friends', 'For referring to any friends user can generate the bonus', 'howitworks', '2022-11-16 10:36:25', '2022-11-16 10:36:25'),
(21, 'global/images/rGK3hXKEQJ0P5KUNZVBx.png', 'Withdraw and Enjoy', 'Withdraw can be performed in the main wallet and it will take a few time to complete', 'howitworks', '2022-11-16 22:08:05', '2022-11-16 22:08:05'),
(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', '2022-11-16 22:17:03'),
(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', '2022-11-16 22:17:56'),
(24, 'anticon anticon-lock', 'Secure Application', 'Etaque molestias enim quo harum ex, inventore eos corporis temporibus sint reiciendis nemo similique consequuntur eum.', 'whychooseus', '2022-11-16 22:18:35', '2022-11-16 22:18:35'),
(25, 'global/images/4IbFwZ2PZa8nLudMHzSt.png', 'Total Deposit', '21453', 'counter', '2022-11-16 22:30:49', '2022-11-16 22:30:49'),
(26, 'global/images/brPxBdDNKkKu1oFb3uUl.png', 'Total Investment', '112549', 'counter', '2022-11-16 22:32:35', '2022-11-16 22:32:35'),
(27, 'global/images/cxq0OgALCgYjCCcoI6f2.png', 'Total Withdraw', '58694', 'counter', '2022-11-16 22:33:20', '2022-11-16 22:33:20'),
(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'),
(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'),
(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');

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

--
-- 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
) 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`) 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-user-add\",\"hero_button1_level\":\"Get Started\",\"hero_button1_url\":\"https:\\/\\/hyiprio.tdevs.co\\/register\",\"hero_button1_target\":\"_self\",\"hero_button2_icon\":\"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\\/4qoa67GxVECLruiLaAl5.png\",\"hero_right_top_img\":\"global\\/images\\/lLJT3xQhVp4mkOyxtRC3.png\"}', 1, '2022-10-22 13:54:01', '2022-11-16 16:22:16'),
(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', '2022-11-16 16:24:21'),
(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'),
(4, 'How it works Section\n', 'howitworks', '{\"title_small\":\"How It Works\",\"title_big\":\"The steps are describe how the application works and what\'s inside\"}', 1, '2022-10-22 13:54:48', '2022-11-16 16:28:40'),
(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'),
(6, 'Why Choose Us Section\n', 'whychooseus', '{\"title_small\":\"Why Choose Us\",\"title_big\":\"Explore Why You Will Choose Us.\",\"left_img\":\"global\\/images\\/kvyU9Mr9gYTrpoKNZZNi.jpg\",\"right_img\":\"global\\/images\\/XIeEtiyw8HzFLOK5lLch.png\"}', 1, '2022-10-22 13:54:48', '2022-11-16 22:12:46'),
(7, 'Counter Section\n', 'counter', '{\"counter_bg_img\":\"global\\/images\\/p7e2WARHpcYJbr7RlDDE.jpg\"}', 1, '2022-10-22 13:54:48', '2022-11-16 22:27:00'),
(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', '2022-11-17 17:27:24'),
(9, 'Call To Action\n', 'cta', '{\"cta_title\":\"We\'re a more than 1000+ members family, you can join with us with high confiden\",\"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', '2022-11-16 18:55:49'),
(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'),
(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'),
(12, 'Newslatter Section\n', 'newsletter', '[]', 1, '2022-10-22 13:54:48', '2022-10-26 18:07:58'),
(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 2022. All rights reserved.\",\"right_img\":\"global\\/images\\/GAH1nccf5XhjretvfsYT.png\"}', 1, '2022-10-22 13:54:48', '2022-11-16 23:57:56');

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

--
-- 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, NULL),
(8, NULL, 'Spanish', 'es', 0, 1, '2022-10-05 19:17:20', '2022-11-17 12:10:51'),
(10, NULL, 'France', 'fr', 0, 1, '2022-11-07 01:23:27', '2022-11-17 12:11:19');

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

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

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

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_08_16_143134_create_settings_table', 1),
(6, '2022_08_17_151449_create_admins_table', 1),
(7, '2022_08_18_043158_create_permission_tables', 1),
(8, '2022_08_20_094148_create_schedules_table', 1),
(9, '2022_08_20_095524_create_schemas_table', 1),
(10, '2022_08_25_084337_create_transactions_table', 2),
(11, '2022_08_29_112101_create_invests_table', 3),
(12, '2022_09_01_230050_create_gateways_table', 4),
(15, '2022_09_22_002528_create_withdraw_methods_table', 5),
(16, '2022_09_22_002635_create_withdraw_accounts_table', 5),
(20, '2022_09_26_100457_create_languages_table', 6),
(21, '2022_10_06_224555_create_tickets_table', 7),
(22, '2022_10_06_224556_create_messages_table', 7),
(23, '2022_10_06_224557_create_categories_table', 7),
(24, '2022_10_06_224558_create_labels_table', 7),
(25, '2022_10_09_004323_create_referral_targets_table', 8),
(27, '2022_10_09_105537_create_referrals_table', 9),
(28, '2022_10_10_111029_create_referral_programs_table', 10),
(29, '2022_10_10_111442_create_referral_links_table', 10),
(30, '2022_10_10_111636_create_referral_relationships_table', 10),
(32, '2022_10_15_113925_create_rankings_table', 11),
(34, '2022_10_16_020551_create_kycs_table', 12),
(35, '2022_10_18_044728_create_cache_table', 13),
(36, '2022_10_21_125740_create_navigations_table', 13),
(39, '2022_10_21_214919_create_landing_pages_table', 14),
(40, '2022_10_21_215008_create_pages_table', 14),
(41, '2022_10_23_100310_create_landing_contents_table', 15),
(42, '2022_10_24_133755_create_blogs_table', 16),
(44, '2022_10_25_182707_create_page_settings_table', 17),
(46, '2022_10_26_002241_create_socials_table', 18),
(47, '2022_10_27_002647_create_subscriptions_table', 19),
(49, '2022_10_29_234521_create_plugins_table', 20),
(50, '2022_11_06_171108_create_custom_csses_table', 21),
(51, '2022_11_06_171108_create_custom_css_table', 22),
(52, '2022_11_07_121426_create_email_templates_table', 22);

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

--
-- 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
) 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`) VALUES
(2, 7, 'Contact', 'contact', 'both', 4, 7, 1, '2022-10-24 14:02:26', '2022-11-20 07:50:56'),
(4, 8, 'Privacy', 'privacy-policy', 'footer', 5, NULL, 1, '2022-10-24 14:05:24', '2022-11-20 07:50:56'),
(7, 1, 'Schema', 'schema', 'both', 7, 2, 1, '2022-10-26 23:00:32', '2022-11-20 07:59:13'),
(8, 2, 'How It Works', 'how-it-works', 'header', NULL, 4, 1, '2022-10-26 23:01:13', '2022-11-20 07:50:15'),
(9, 5, 'Ranking', 'rankings', 'both', 6, 3, 1, '2022-10-26 23:01:33', '2022-11-20 07:59:13'),
(11, 3, 'About', 'about-us', 'both', 10, 5, 1, '2022-10-27 15:38:03', '2022-11-20 07:59:18'),
(13, 4, 'FAQ', 'faq', 'footer', 8, NULL, 1, '2022-10-27 15:38:56', '2022-11-20 07:59:13'),
(14, NULL, 'Home', '/', 'both', 1, 1, 1, '2022-10-28 08:34:49', '2022-11-20 07:50:15'),
(16, 6, 'Blog', 'blog', 'both', 3, 6, 1, '2022-11-17 02:35:57', '2022-11-20 07:50:56'),
(18, 10, 'Account Login', '/login', 'footer', 2, NULL, 1, '2022-11-17 00:01:03', '2022-11-20 07:50:56'),
(19, 9, 'Terms and Conditions', 'terms-and-conditions', 'footer', 9, NULL, 1, '2022-11-17 00:03:30', '2022-11-20 07:59:18');

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

--
-- 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,
  `url` varchar(196) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

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

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

INSERT INTO `page_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'breadcrumb', 'global/images/YxeYfLzaEsagR8a7OWXw.jpg', NULL, '2022-11-16 18:59:29'),
(2, 'basic_page_background', '#1bb12c', NULL, '2022-10-25 14:27:37');

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

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



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

--
-- 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,
  `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`, `name`, `description`, `data`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/plugin/tawk.png', 'Tawk Chat', 'Free Instant Messaging system\n\n', '{\"property_id\":\"1ggi9vm2o\",\"widget_id\":\"635d5805b0d6371309cc36aa\"}', 0, NULL, '2022-10-30 17:13:19'),
(2, 'global/plugin/reCaptcha.png', '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', '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');

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

--
-- 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_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_earnings`, `bonus`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/images/sCQgIyl0OKzFiO73nmWF.svg', 'Level 1', 'Hyip Member', 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', 50, 10, 'By earning $50 from the site', 1, '2022-10-15 10:14:53', '2022-11-17 00:42:14'),
(3, 'global/images/hGHllGGCIYfpx5Z2VKrW.svg', 'Level 3', 'Hyip Captain', 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', 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.2, 50, 'First Target of the Deposit Bonus', 1, '2022-11-17 03:08:25', '2022-12-27 12:37:21'),
(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', '2022-10-15 04:04:27'),
(2, 'Target #2', '2022-10-09 04:15:59', '2022-10-09 04:15:59'),
(3, 'Target #3', '2022-10-09 04:16:06', '2022-10-09 04:16:06'),
(4, 'Target #4', '2022-10-09 04:16:10', '2022-10-09 04:16:10'),
(5, 'Target #5', '2022-10-09 04:16:18', '2022-10-09 04:16:18'),
(6, 'Target #6', '2022-10-09 04:19:02', '2022-10-09 04:19:02');

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

--
-- 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 `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` int 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,
  `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`, `created_at`, `updated_at`) VALUES
(1, 'global/images/D7JO6pA0Wj2vbyp9FJsK.png', 'Starter Plan', 'fixed', 500, 0, 0, 1, NULL, 0, 0, 'percentage', 25, 2, 'period', 10, '2022-08-28 11:50:48', '2022-11-16 14:44:43'),
(2, 'global/images/gn6bCbbpkTCtTWIuPzzP.png', 'Standard Plan', 'range', 0, 500, 2000, 0, 'BEST SCHEMA', 1, 1, 'percentage', 48, 3, 'period', 20, '2022-08-28 11:54:58', '2022-11-16 14:44:50'),
(3, 'global/images/I79d1j4CUeMfRtGHs1nQ.png', 'Advanced Plan', 'fixed', 500, 0, 0, 0, NULL, 0, 1, 'fixed', 10, 1, 'lifetime', 0, '2022-08-28 12:18:03', '2022-11-16 14:44:59'),
(4, 'global/images/7oF6RLsG8iAPmNCCKnC7.png', 'Pro Plan', 'fixed', 1000, 0, 0, 1, NULL, 0, 1, 'fixed', 10, 2, 'period', 80, '2022-10-26 08:45:21', '2022-11-16 14:45:06');

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

--
-- 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', '2022-11-07 08:29:26'),
(2, 'site_title', 'Hyiprio', 'string', '2022-08-24 10:01:01', '2022-08-28 03:55:16'),
(3, 'site_email', 'info@tdevs.co', 'string', '2022-08-24 10:01:01', '2023-01-04 07:58:09'),
(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', '2022-08-24 10:01:08'),
(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', '2022-11-14 01:32:48'),
(10, 'maintenance_title', 'Site is not under maintenance', 'string', '2022-09-20 14:29:38', '2022-09-20 14:29:38'),
(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', '5', 'double', '2022-10-10 14:17:10', '2022-11-11 00:46:11'),
(19, 'email_verification', '0', 'boolean', '2022-10-12 05:14:39', '2022-11-11 00:56:52'),
(20, 'kyc_verification', '1', 'boolean', '2022-10-12 05:14:39', '2022-11-06 04:41:45'),
(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', 'info@tdevs.co', 'string', '2022-10-29 14:11:51', '2022-12-21 03:30:42'),
(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', 'smtppro.zoho.com', 'string', '2022-10-29 14:11:51', '2022-12-21 03:30:42'),
(34, 'mail_port', '465', 'integer', '2022-10-29 14:11:51', '2022-11-22 03:25:01'),
(35, 'mail_secure', 'ssl', 'string', '2022-10-29 14:11:51', '2022-11-22 04:33:39'),
(36, 'mail_username', 'info@tdevs.co', 'string', '2022-10-29 15:05:23', '2022-12-21 03:31:02'),
(37, 'mail_password', 'Pc6l43!rqFp6', 'string', '2022-10-29 15:05:23', '2022-12-21 03:30:42'),
(38, 'site_animation', '0', 'boolean', '2022-11-06 10:24:22', '2022-11-16 16:21:00'),
(39, 'support_email', 'info@tdevs.co', 'string', '2022-11-07 08:29:03', '2023-01-04 07:58:10'),
(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', 'secret', 'string', '2022-11-14 01:32:48', '2022-11-14 01:32:48'),
(43, 'transfer_status', '1', 'boolean', '2022-11-16 08:16:07', '2022-11-16 08:17:08'),
(44, 'back_to_top', '1', 'boolean', '2022-11-16 08:16:07', '2022-11-16 08:16:07');

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `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(196) 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,
  `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',
  `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 `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,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `required_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required_time_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` double NOT NULL,
  `charge_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_withdraw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_withdraw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `withdraw_methods` (`id`, `icon`, `name`, `currency`, `rate`, `required_time`, `required_time_format`, `charge`, `charge_type`, `min_withdraw`, `max_withdraw`, `fields`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/images/Bji2A16SZgfICUsc7hIY.png', 'Bank Trasfer', 'USD', 1, '5', 'day', 2, 'percentage', '2000', '2000', '{\"1\":{\"name\":\"Bank Name\",\"type\":\"text\",\"validation\":\"required\"},\"2\":{\"name\":\"Bank Account Number\",\"type\":\"text\",\"validation\":\"required\"},\"3\":{\"name\":\"Bank Country\",\"type\":\"text\",\"validation\":\"required\"},\"4\":{\"name\":\"Bank Holder Name\",\"type\":\"text\",\"validation\":\"required\"},\"5\":{\"name\":\"Bank Branch\",\"type\":\"text\",\"validation\":\"required\"},\"6\":{\"name\":\"Bank Routing Numbe\",\"type\":\"text\",\"validation\":\"required\"},\"7\":{\"name\":\"IBN Number\",\"type\":\"textarea\",\"validation\":\"nullable\"},\"8\":{\"name\":\"photo\",\"type\":\"file\",\"validation\":\"required\"}}', 1, '2022-09-22 11:58:00', '2022-11-16 08:58:59'),
(2, 'global/images/LaDficlayzNPatGOnaAU.png', 'Mobile Money', 'USD', 1, '2', 'day', 2, 'percentage', '20', '2000', '{\"1\":{\"name\":\"Mobile Number\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2022-10-19 17:52:26', '2022-11-16 11:15:50');

--
-- 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 `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_templates_code_unique` (`code`);

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

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

--
-- Indexes for table `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 `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 `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url` (`url`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 `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 `withdraw_accounts`
--
ALTER TABLE `withdraw_accounts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

