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

START TRANSACTION;



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

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

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `details` longtext 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) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

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

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

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

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

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

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



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

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

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

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

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

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

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

INSERT INTO `invests` (`id`, `user_id`, `schema_id`, `transaction_id`, `invest_amount`, `already_return_profit`, `total_profit_amount`, `last_profit_time`, `next_profit_time`, `capital_back`, `interest`, `interest_type`, `return_type`, `number_of_period`, `period_hours`, `wallet`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 4, 12000, 10, 1000, '2023-01-18 22:20:35', '2023-01-18 23:20:35', 1, 100, 'fixed', 'period', 0, 1, 'main', 'completed', '2023-01-17 01:29:48', '2023-01-19 03:20:35'),
(2, 1, 1, 16, 500, 2, 250, '2023-01-19 12:50:01', '2023-01-20 12:50:01', 1, 25, 'percentage', 'period', 8, 24, 'main', 'ongoing', '2023-01-17 10:40:56', '2023-01-19 17:50:01'),
(3, 1, 1, 17, 500, 2, 250, '2023-01-19 12:50:01', '2023-01-20 12:50:01', 1, 25, 'percentage', 'period', 8, 24, 'main', 'ongoing', '2023-01-17 11:19:10', '2023-01-19 17:50:01'),
(4, 4, 1, 23, 500, 2, 250, '2023-01-19 12:50:01', '2023-01-20 12:50:01', 1, 25, 'percentage', 'period', 8, 24, 'main', 'ongoing', '2023-01-17 14:39:00', '2023-01-19 17:50:01'),
(5, 7, 4, 33, 2000, 10, 1000, '2023-01-18 22:20:35', '2023-01-18 23:20:35', 1, 100, 'fixed', 'period', 0, 1, 'main', 'completed', '2023-01-17 18:04:07', '2023-01-19 03:20:35'),
(6, 4, 5, 73, 100, 2, 100, '2023-01-19 15:40:02', '2023-01-19 16:40:02', 1, 50, 'percentage', 'period', 0, 1, 'main', 'completed', '2023-01-19 18:31:57', '2023-01-19 20:40:02'),
(7, 11, 6, 78, 25000, 1, 20000, '2023-01-19 15:55:11', '2023-01-19 16:55:11', 1, 80, 'percentage', 'period', 0, 1, 'main', 'completed', '2023-01-19 19:54:01', '2023-01-19 20:55:11'),
(8, 12, 6, 96, 25000, 1, 20000, '2023-01-19 18:15:32', '2023-01-19 19:15:32', 1, 80, 'percentage', 'period', 0, 1, 'main', 'completed', '2023-01-19 22:13:15', '2023-01-19 23:15:32');

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

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

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

--
-- 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(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `landing_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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:\\/\\/codedphpscripts.xyz\\/hyipp\\/a\",\"hero_button1_target\":\"_self\",\"hero_button2_icon\":\"anticon-fire\",\"hero_button2_lavel\":\"How it works\",\"hero_button2_url\":\"https:\\/\\/codedphpscripts.xyz\\/hyipp\\/a\",\"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', '2023-01-19 22:36:36'),
(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(20) UNSIGNED NOT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `locale` varchar(255) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` (`id`, `flag`, `name`, `locale`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'English', 'en', 1, 1, NULL, 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'),
(11, NULL, 'German', 'de', 0, 1, '2023-01-19 22:40:06', '2023-01-19 22:40:06');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `navigations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `footer_position` int(11) DEFAULT NULL,
  `header_position` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(196) NOT NULL,
  `code` varchar(255) NOT NULL,
  `data` longtext NOT NULL,
  `type` enum('static','dynamic') NOT NULL DEFAULT 'dynamic',
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

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

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

INSERT INTO `page_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'breadcrumb', 'global/images/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) NOT NULL,
  `token` varchar(255) 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(20) UNSIGNED NOT NULL,
  `category` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

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

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

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

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

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

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

INSERT INTO `plugins` (`id`, `icon`, `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(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `ranking` varchar(255) NOT NULL,
  `ranking_name` varchar(255) NOT NULL,
  `minimum_earnings` double NOT NULL,
  `bonus` double NOT NULL DEFAULT 0,
  `description` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `rankings` (`id`, `icon`, `ranking`, `ranking_name`, `minimum_earnings`, `bonus`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'global/images/sCQgIyl0OKzFiO73nmWF.svg', 'Level 1', 'WebPro KID', 0, 0, 'By signing up to the account', 1, '2022-10-15 09:55:23', '2023-01-19 22:35:54'),
(2, 'global/images/TQDUvbD48kmhmV9qifzh.svg', 'Level 2', 'WebPro Leader', 50, 10, 'By earning $50 from the site', 1, '2022-10-15 10:14:53', '2023-01-17 10:14:47'),
(3, 'global/images/hGHllGGCIYfpx5Z2VKrW.svg', 'Level 3', 'WebPro Captain', 200, 20, 'By earning $200 from the site', 1, '2022-10-15 18:16:59', '2023-01-17 10:15:15'),
(4, 'global/images/SaNfYL7WD2pzAAME8Sqb.svg', 'Level 4', 'WebPro Victor', 2000, 50, 'By earning $500 from the site', 1, '2022-10-15 18:18:23', '2023-01-17 10:15:35');

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

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

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `referral_target_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('investment','deposit') NOT NULL,
  `bounty` double NOT NULL,
  `target_amount` double DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `referrals` (`id`, `referral_target_id`, `type`, `bounty`, `target_amount`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'investment', 5, 50, 'First Target of the investment bonus', 1, '2022-11-17 03:07:54', '2022-11-17 03:07:54'),
(2, 1, 'deposit', 5.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(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `referral_program_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(36) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `referral_links` (`id`, `user_id`, `referral_program_id`, `code`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '97137840-95c7-11ed-9f06-bd3cfb942361', '2023-01-16 22:59:58', '2023-01-16 22:59:58'),
(2, 2, 1, '892ed420-95e7-11ed-9b0e-8100e47acc60', '2023-01-17 02:48:38', '2023-01-17 02:48:38'),
(3, 3, 1, '5961edb2-961a-11ed-875b-ede7d6847d51', '2023-01-17 08:52:23', '2023-01-17 08:52:23'),
(4, 4, 1, '2980a3ee-9648-11ed-b6d7-b7938e94e3ba', '2023-01-17 14:20:19', '2023-01-17 14:20:19'),
(5, 6, 1, 'a505103c-965b-11ed-b736-8b760379d648', '2023-01-17 16:39:47', '2023-01-17 16:39:47'),
(6, 7, 1, '3cd254ec-9661-11ed-b915-9d1139112a7f', '2023-01-17 17:19:49', '2023-01-17 17:19:49'),
(7, 8, 1, '9aa67106-9667-11ed-982f-7f7b1deeac98', '2023-01-17 18:05:23', '2023-01-17 18:05:23'),
(8, 11, 1, '85dd6de4-9804-11ed-9f1c-6b2141aff4c1', '2023-01-19 19:21:11', '2023-01-19 19:21:11'),
(9, 12, 1, '64adf9ba-981b-11ed-a0f6-81809ceedcae', '2023-01-19 22:04:53', '2023-01-19 22:04:53'),
(10, 13, 1, 'b27d04ea-9836-11ed-a983-f51f5fa81703', '2023-01-20 01:20:20', '2023-01-20 01:20:20');

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

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

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

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

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

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

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

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

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

INSERT INTO `referral_relationships` (`id`, `referral_link_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 11, '2023-01-19 19:15:41', '2023-01-19 19:15:41');

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

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

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

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

INSERT INTO `referral_targets` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Target #1', '2022-10-09 03:11:24', '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(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Dumping data for table `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', 'Real Esate', 'fixed', 500, 0, 0, 1, 'A', 1, 1, 'percentage', 25, 2, 'period', 10, '2022-08-28 11:50:48', '2023-01-20 03:46:22'),
(2, 'global/images/gn6bCbbpkTCtTWIuPzzP.png', 'Oil and Gas', 'range', 0, 500, 2000, 0, 'BEST SCHEMA', 1, 1, 'percentage', 48, 3, 'period', 20, '2022-08-28 11:54:58', '2023-01-20 03:46:44'),
(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', 'range', 0, 1000, 20000, 1, 'APRO', 1, 1, 'fixed', 100, 1, 'period', 10, '2022-10-26 08:45:21', '2023-01-16 23:05:40'),
(5, 'global/images/JPJUp8V7AxGIqQJFf4QD.jpg', 'Swift Plan', 'range', 0, 100, 500, 1, 'A', 1, 1, 'percentage', 50, 1, 'period', 2, '2023-01-19 18:29:13', '2023-01-19 18:29:13'),
(6, 'global/images/aIHkbt8iJja70O5qXNtZ.png', 'Rush Plan', 'fixed', 25000, 0, 0, 1, 'RUS', 1, 1, 'percentage', 80, 1, 'period', 1, '2023-01-19 19:35:03', '2023-01-19 19:35:03'),
(7, 'global/images/rrNDG5MXRyD7M5VA3YWZ.png', 'PremiumPro', 'range', 0, 1000, 100000, 1, 'PPPR', 1, 1, 'percentage', 90, 1, 'period', 10, '2023-01-19 22:20:33', '2023-01-19 22:20:33');

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

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

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

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

INSERT INTO `settings` (`id`, `name`, `val`, `type`, `created_at`, `updated_at`) VALUES
(1, 'currency_symbol', '$', 'string', '2022-08-24 10:01:01', '2022-11-07 08:29:26'),
(2, 'site_title', 'WebPro Broker', 'string', '2022-08-24 10:01:01', '2023-01-16 22:04:25'),
(3, 'site_email', 'info@codedphpscripts.xyz', 'string', '2022-08-24 10:01:01', '2023-01-16 22:04:25'),
(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', '10000', 'double', '2022-09-21 08:35:47', '2023-01-16 22:04:58'),
(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', '1', 'boolean', '2022-10-12 05:14:39', '2023-01-17 16:32:47'),
(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', 'Web Hip Broker', 'string', '2022-10-29 14:11:51', '2023-01-16 22:23:28'),
(30, 'email_from_address', 'info@codedphpscripts.xyz', 'string', '2022-10-29 14:11:51', '2023-01-16 22:23:28'),
(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', 'server219.web-hosting.com', 'string', '2022-10-29 14:11:51', '2023-01-17 14:34:32'),
(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@codedphpscripts.xyz', 'string', '2022-10-29 15:05:23', '2023-01-17 10:43:47'),
(37, 'mail_password', 'z9OexBI@V8TY', 'string', '2022-10-29 15:05:23', '2023-01-17 10:43:47'),
(38, 'site_animation', '0', 'boolean', '2022-11-06 10:24:22', '2022-11-16 16:21:00'),
(39, 'support_email', 'info@codedphpscripts.xyz', 'string', '2022-11-07 08:29:03', '2023-01-16 22:04:25'),
(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(20) UNSIGNED NOT NULL,
  `icon_name` varchar(255) NOT NULL,
  `class_name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `transactions` (`id`, `user_id`, `from_user_id`, `from_model`, `target_id`, `target_type`, `tnx`, `description`, `amount`, `type`, `charge`, `final_amount`, `method`, `pay_currency`, `pay_amount`, `manual_field_data`, `approval_cause`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 'User', NULL, NULL, 'TRXEXLTMKTR29', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-16 22:57:25', '2023-01-16 22:57:25'),
(2, 1, NULL, 'User', NULL, NULL, 'TRXE185UMZJ0L', 'Deposit With Bitcoin', '20000', 'manual_deposit', '0', '20000', 'BTC', '$', 20000, '{\"Upload Proof\":\"global\\/images\\/dFpDHxiqI4rOVc3OzcBH.png\"}', '', 'success', '2023-01-16 23:07:10', '2023-01-16 23:08:41'),
(3, 1, NULL, 'User', NULL, NULL, 'TRXKM64PGIQDT', 'Deposit With Paystack', '5000', 'deposit', '0', '5000', 'paystack', 'GHS', 5000, '[]', 'none', 'pending', '2023-01-16 23:07:49', '2023-01-16 23:07:49'),
(4, 1, NULL, 'User', NULL, NULL, 'TRX2R6FVMEFOO', 'Pro Plan Plan Invested', '12000', 'investment', '0', '12000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 01:29:48', '2023-01-17 01:29:48'),
(5, 2, NULL, 'User', NULL, NULL, 'TRX80XAJ01JWD', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 02:48:38', '2023-01-17 02:48:38'),
(6, 1, NULL, 'User', NULL, NULL, 'TRXNTKRFDWZSM', 'Main to Profit Wallet Exchanged', '2000', 'exchange', '1', '2001', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 03:00:04', '2023-01-17 03:00:04'),
(7, 3, NULL, 'User', NULL, NULL, 'TRXUGG0LDOBMC', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 08:52:22', '2023-01-17 08:52:22'),
(8, 3, NULL, 'User', NULL, NULL, 'TRXCIJBMMXIUC', 'Deposit With Flutterwave', '100', 'deposit', '0', '100', 'flutterwave', 'USD', 100, '[]', 'none', 'failed', '2023-01-17 08:54:45', '2023-01-17 08:54:46'),
(9, 3, NULL, 'User', NULL, NULL, 'TRXKVUVVU0QZP', 'Deposit With Bitcoin', '100', 'manual_deposit', '0', '100', 'BTC', '$', 100, '{\"Upload Proof\":\"global\\/images\\/9fwG4CxvQPnmt2PS4YxF.png\"}', '', 'success', '2023-01-17 08:56:27', '2023-01-17 10:28:06'),
(10, 1, NULL, 'User', NULL, NULL, 'TRXNOQOSINAAB', 'Withdraw With Bitcoin-USD', '5', 'withdraw', '0', '5', 'Bitcoin', 'USD', 5, '{\"Wallet Address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"bc1q0lpntdkz0ys2k5wstrkvlap0w73gtdq8e4ppgk\"},\"Wallet Name\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Bitcoin\"}}', '', 'success', '2023-01-17 10:20:48', '2023-01-17 10:21:59'),
(11, 1, 3, 'User', NULL, NULL, 'TRXZOJOU0ZDD9', 'Transfer Money To Orjikeyz', '500', 'send_money', '25', '525', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 10:29:37', '2023-01-17 10:29:37'),
(12, 3, 1, 'User', NULL, NULL, 'TRX5MOJGDHPWW', 'Transfer Money Form adislove', '500', 'receive_money', '25', '525', 'system', NULL, NULL, '[]', 'Please accept my money gift', 'success', '2023-01-17 10:29:37', '2023-01-17 10:29:37'),
(13, 1, NULL, 'User', NULL, NULL, 'TRXAMGXKYFOWH', 'Deposit With Paystack', '3000', 'deposit', '0', '3000', 'paystack', 'GHS', 3000, '[]', 'none', 'pending', '2023-01-17 10:30:09', '2023-01-17 10:30:09'),
(14, 2, 1, 'Admin', NULL, NULL, 'TRXUQO8TFAHUW', 'Money Deposit From Admin', '1000', 'deposit', '0', '1000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 10:36:33', '2023-01-17 10:36:33'),
(15, 3, 1, 'Admin', NULL, NULL, 'TRXTX70IQ518Y', 'Money Deposit From Admin', '6000', 'deposit', '0', '6000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 10:37:19', '2023-01-17 10:37:19'),
(16, 1, NULL, 'User', NULL, NULL, 'TRXQASJZXTQXR', 'Starter Plan Plan Invested', '500', 'investment', '0', '500', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 10:40:56', '2023-01-17 10:40:56'),
(17, 1, NULL, 'User', NULL, NULL, 'TRXZ7CPJYI6PR', 'Starter Plan Plan Invested', '500', 'investment', '0', '500', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 11:19:10', '2023-01-17 11:19:10'),
(18, 4, NULL, 'User', NULL, NULL, 'TRXTF5HUS1UO8', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 14:20:19', '2023-01-17 14:20:19'),
(19, 4, NULL, 'User', NULL, NULL, 'TRXKRCKOFVKJD', 'Deposit With Bitcoin', '1000', 'manual_deposit', '0', '1000', 'BTC', '$', 1000, '{\"Upload Proof\":\"global\\/images\\/nRwz4oz6YEpgiX8tgx84.png\"}', '', 'success', '2023-01-17 14:21:37', '2023-01-19 19:33:19'),
(20, 4, NULL, 'User', NULL, NULL, 'TRXFQXQPI4GKF', 'Deposit With Mobile Money (Manual)', '100', 'manual_deposit', '0', '100', 'mobile-money', 'Ghana Cedis', 1200, '{\"01236547859\":\"99999999999\",\"Transaction Screenshot\":\"global\\/images\\/Xey4Wt6gCD1IGEKZbWhW.png\"}', '', 'success', '2023-01-17 14:22:09', '2023-01-19 19:33:09'),
(21, 4, NULL, 'User', NULL, NULL, 'TRXMWYV40ZIJZ', 'Deposit With Bitcoin', '1000', 'manual_deposit', '0', '1000', 'BTC', '$', 1000, '{\"Upload Proof\":\"global\\/images\\/D7QYXrK7KeCOEw4L03hI.png\"}', '', 'success', '2023-01-17 14:31:21', '2023-01-19 19:32:59'),
(22, 4, NULL, 'User', NULL, NULL, 'TRX635DON15EW', 'Deposit With Bitcoin', '1000', 'manual_deposit', '0', '1000', 'BTC', '$', 1000, '{\"Upload Proof\":\"global\\/images\\/POrWdWSLdbru5EpXAGJT.png\"}', '', 'success', '2023-01-17 14:34:54', '2023-01-17 14:36:34'),
(23, 4, NULL, 'User', NULL, NULL, 'TRXQ8TUQZCUGB', 'Starter Plan Plan Invested', '500', 'investment', '0', '500', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 14:39:00', '2023-01-17 14:39:00'),
(24, 4, 1, 'Admin', NULL, NULL, 'TRXHZU0VACY3W', 'Money Deposit From Admin', '100', 'deposit', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 14:42:03', '2023-01-17 14:42:03'),
(25, 4, NULL, 'User', NULL, NULL, 'TRXFODQFMFIXQ', 'Withdraw With Bitcoin-USD', '2', 'withdraw', '0', '2', 'Bitcoin', 'USD', 2, '{\"Wallet Address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"sddddddddddddd\"},\"Wallet Name\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Bitc\"}}', '', 'success', '2023-01-17 15:03:35', '2023-01-17 15:03:51'),
(26, 5, NULL, 'User', NULL, NULL, 'TRXOBIQIZYTCP', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 16:34:21', '2023-01-17 16:34:21'),
(27, 6, NULL, 'User', NULL, NULL, 'TRXI2SSTQQOQN', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 16:35:30', '2023-01-17 16:35:30'),
(28, 7, NULL, 'User', NULL, NULL, 'TRXWMVOCB9AKF', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 16:39:06', '2023-01-17 16:39:06'),
(29, 7, NULL, 'User', NULL, NULL, 'TRXSJLMAQHL0R', 'Deposit With Paystack', '5000', 'deposit', '0', '5000', 'paystack', 'GHS', 5000, '[]', 'none', 'pending', '2023-01-17 17:20:43', '2023-01-17 17:20:43'),
(30, 7, NULL, 'User', NULL, NULL, 'TRX6RHIP6H4KY', 'Deposit With Mobile Money (Manual)', '1000', 'manual_deposit', '0', '1000', 'mobile-money', 'Ghana Cedis', 12000, '{\"01236547859\":\"87866666767\",\"Transaction Screenshot\":\"global\\/images\\/alrZ0sG0RG3LE1zoC7Nn.png\"}', '', 'success', '2023-01-17 17:29:08', '2023-01-17 17:43:57'),
(31, 7, NULL, 'User', NULL, NULL, 'TRXLIHKJCEAZ1', 'Deposit With Bitcoin', '7000', 'manual_deposit', '0', '7000', 'BTC', '$', 7000, '{\"Upload Proof\":\"global\\/images\\/WsbDU63t7QUdgzjlGAzJ.png\"}', '', 'success', '2023-01-17 17:29:51', '2023-01-17 17:43:19'),
(32, 8, NULL, 'User', NULL, NULL, 'TRXC7NISVXCEU', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 18:02:01', '2023-01-17 18:02:01'),
(33, 7, NULL, 'User', NULL, NULL, 'TRXEWRR89UA1D', 'Pro Plan Plan Invested', '2000', 'investment', '0', '2000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-17 18:04:07', '2023-01-17 18:04:07'),
(34, 8, NULL, 'User', NULL, NULL, 'TRXNILJF7JTGU', 'Deposit With Bitcoin', '5000', 'manual_deposit', '0', '5000', 'BTC', '$', 5000, '{\"Upload Proof\":\"global\\/images\\/CaqLPDXyxQu1RyiNO6xN.jpg\"}', '', 'success', '2023-01-17 18:23:26', '2023-01-19 19:32:43'),
(35, 1, NULL, 'User', NULL, NULL, 'TRXSM1R8HM0DM', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:45:22', '2023-01-18 17:45:22'),
(36, 1, NULL, 'User', NULL, NULL, 'TRX55NLMGRU78', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:45:22', '2023-01-18 17:45:22'),
(37, 1, NULL, 'User', NULL, NULL, 'TRXVJNGWKZENZ', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:45:22', '2023-01-18 17:45:22'),
(38, 4, NULL, 'User', NULL, NULL, 'TRXPRRFHJ5SW0', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:45:22', '2023-01-18 17:45:22'),
(39, 7, NULL, 'User', NULL, NULL, 'TRX4MVRVPQUPQ', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:45:22', '2023-01-18 17:45:22'),
(40, 1, NULL, 'User', NULL, NULL, 'TRXGQSUIVAWA7', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:55:48', '2023-01-18 17:55:48'),
(41, 1, NULL, 'User', NULL, NULL, 'TRXPZIJ8N2QNG', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 17:55:48', '2023-01-18 17:55:48'),
(42, 1, NULL, 'User', NULL, NULL, 'TRX95YRGYNETQ', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:00:28', '2023-01-18 18:00:28'),
(43, 4, NULL, 'User', NULL, NULL, 'TRX206UKY1MES', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:05:27', '2023-01-18 18:05:27'),
(44, 7, NULL, 'User', NULL, NULL, 'TRXOJ038H3IGK', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:10:04', '2023-01-18 18:10:04'),
(45, 1, NULL, 'User', NULL, NULL, 'TRX2T3YDVU8OT', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:50:40', '2023-01-18 18:50:40'),
(46, 7, NULL, 'User', NULL, NULL, 'TRXUGHMIUO1HR', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:50:40', '2023-01-18 18:50:40'),
(47, 7, NULL, 'User', NULL, NULL, 'TRXJR06KU2DQI', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 18:55:49', '2023-01-18 18:55:49'),
(48, 1, NULL, 'User', NULL, NULL, 'TRXRZFDG2SZT7', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 19:55:15', '2023-01-18 19:55:15'),
(49, 7, NULL, 'User', NULL, NULL, 'TRXSOIY0VD8NJ', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 19:55:15', '2023-01-18 19:55:15'),
(50, 1, NULL, 'User', NULL, NULL, 'TRX1RWQKVP279', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 21:00:27', '2023-01-18 21:00:27'),
(51, 7, NULL, 'User', NULL, NULL, 'TRXP26PHC7S3P', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 21:00:27', '2023-01-18 21:00:27'),
(52, 1, NULL, 'User', NULL, NULL, 'TRXQOCSHPB1PZ', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 22:00:34', '2023-01-18 22:00:34'),
(53, 7, NULL, 'User', NULL, NULL, 'TRXIZBZVHJTTJ', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 22:00:34', '2023-01-18 22:00:34'),
(54, 1, NULL, 'User', NULL, NULL, 'TRX7CMRX8TL1U', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 23:05:42', '2023-01-18 23:05:42'),
(55, 7, NULL, 'User', NULL, NULL, 'TRXW1ZNWKFU2U', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-18 23:05:42', '2023-01-18 23:05:42'),
(56, 1, NULL, 'User', NULL, NULL, 'TRXRMSOK9XHQE', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 00:10:08', '2023-01-19 00:10:08'),
(57, 7, NULL, 'User', NULL, NULL, 'TRXT4BTBFM3JC', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 00:10:08', '2023-01-19 00:10:08'),
(58, 1, NULL, 'User', NULL, NULL, 'TRXDXUK3DGYS7', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 01:10:48', '2023-01-19 01:10:48'),
(59, 7, NULL, 'User', NULL, NULL, 'TRXVUM6VR8W9V', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 01:10:48', '2023-01-19 01:10:48'),
(60, 1, NULL, 'User', NULL, NULL, 'TRXUPJNV9T3TR', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 02:15:17', '2023-01-19 02:15:17'),
(61, 7, NULL, 'User', NULL, NULL, 'TRXWZYSGRZPRY', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 02:15:17', '2023-01-19 02:15:17'),
(62, 1, NULL, 'User', NULL, NULL, 'TRXDT19T5MENA', 'Pro Plan Capital Back', '100', 'refund', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 03:20:35', '2023-01-19 03:20:35'),
(63, 1, NULL, 'User', NULL, NULL, 'TRXCQJTBJQ7H1', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 03:20:35', '2023-01-19 03:20:35'),
(64, 7, NULL, 'User', NULL, NULL, 'TRXZM3MLHWLVC', 'Pro Plan Capital Back', '100', 'refund', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 03:20:35', '2023-01-19 03:20:35'),
(65, 7, NULL, 'User', NULL, NULL, 'TRXVD1RYLD0RG', 'Pro Plan Plan Interest', '100', 'interest', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 03:20:35', '2023-01-19 03:20:35'),
(66, 9, NULL, 'User', NULL, NULL, 'TRXOATASNN5GM', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 16:07:07', '2023-01-19 16:07:07'),
(67, 1, NULL, 'User', NULL, NULL, 'TRXPDLEWG2DHE', 'Withdraw With Bitcoin-USD', '1000', 'withdraw', '0', '1000', 'Bitcoin', 'USD', 1000, '{\"Wallet Address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"bc1q0lpntdkz0ys2k5wstrkvlap0w73gtdq8e4ppgk\"},\"Wallet Name\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Bitcoin\"}}', '', 'success', '2023-01-19 16:51:00', '2023-01-19 19:33:44'),
(68, 1, NULL, 'User', NULL, NULL, 'TRXGZETANLK2D', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 17:50:01', '2023-01-19 17:50:01'),
(69, 1, NULL, 'User', NULL, NULL, 'TRXMGNPB3XIAW', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 17:50:01', '2023-01-19 17:50:01'),
(70, 4, NULL, 'User', NULL, NULL, 'TRX7IUJIAJAFO', 'Starter Plan Plan Interest', '125', 'interest', '0', '125', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 17:50:01', '2023-01-19 17:50:01'),
(71, 10, NULL, 'User', NULL, NULL, 'TRXEHZKOF9JJE', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 17:50:09', '2023-01-19 17:50:09'),
(72, 4, NULL, 'User', NULL, NULL, 'TRXLCNQ183UXA', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 17:50:19', '2023-01-19 17:50:19'),
(73, 4, NULL, 'User', NULL, NULL, 'TRXCA2YX7NPFV', 'Swift Plan Plan Invested', '100', 'investment', '0', '100', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 18:31:57', '2023-01-19 18:31:57'),
(74, 1, NULL, 'User', NULL, NULL, 'TRXGIGZPMNGRV', 'Referral Bonus via Ca Solomon', '10', 'referral', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:15:41', '2023-01-19 19:15:41'),
(75, 11, NULL, 'User', NULL, NULL, 'TRX10B5K48BEJ', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:15:41', '2023-01-19 19:15:41'),
(76, 4, NULL, 'User', NULL, NULL, 'TRXYVTMGJMYCL', 'Swift Plan Plan Interest', '50', 'interest', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:35:26', '2023-01-19 19:35:26'),
(77, 11, NULL, 'User', NULL, NULL, 'TRXYXGSV965ES', 'Deposit With USDT TRC20', '25000', 'manual_deposit', '0', '25000', 'USDT', 'USD', 25000, '{\"Username\":\"caro4gold\"}', '', 'success', '2023-01-19 19:53:00', '2023-01-19 19:53:30'),
(78, 11, NULL, 'User', NULL, NULL, 'TRXY2PGFUSCVA', 'Rush Plan Plan Invested', '25000', 'investment', '0', '25000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:54:01', '2023-01-19 19:54:01'),
(79, 1, 11, 'User', 1, 'investment', 'TRXSXJ5TCZG0I', 'Referral Bonus with Target #1 Via Ca Solomon', '2.5', 'referral', '0', '2.5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:55:47', '2023-01-19 19:55:47'),
(80, 1, 11, 'User', 1, 'deposit', 'TRX4TBUFEUGYR', 'Referral Bonus with Target #1 Via Ca Solomon', '2.6', 'referral', '0', '2.6', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:55:47', '2023-01-19 19:55:47'),
(81, 1, 11, 'User', 2, 'investment', 'TRXIIRTOIXLSC', 'Referral Bonus with Target #2 Via Ca Solomon', '50', 'referral', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:55:47', '2023-01-19 19:55:47'),
(82, 1, 11, 'User', 2, 'deposit', 'TRXITHWG2WOMF', 'Referral Bonus with Target #2 Via Ca Solomon', '50', 'referral', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 19:55:47', '2023-01-19 19:55:47'),
(83, 4, NULL, 'User', NULL, NULL, 'TRXHNF0FNYROK', 'Swift Plan Capital Back', '50', 'refund', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 20:40:02', '2023-01-19 20:40:02'),
(84, 4, NULL, 'User', NULL, NULL, 'TRX6AJH4VMQLC', 'Swift Plan Plan Interest', '50', 'interest', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 20:40:02', '2023-01-19 20:40:02'),
(85, 11, NULL, 'User', NULL, NULL, 'TRXAVOTUOXM4V', 'Rush Plan Capital Back', '20000', 'refund', '0', '20000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 20:55:11', '2023-01-19 20:55:11'),
(86, 11, NULL, 'User', NULL, NULL, 'TRXEUXGCNIPA3', 'Rush Plan Plan Interest', '20000', 'interest', '0', '20000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 20:55:11', '2023-01-19 20:55:11'),
(87, 11, NULL, 'User', NULL, NULL, 'TRXBRTJUXQRMU', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:00:45', '2023-01-19 21:00:45'),
(88, 11, NULL, 'User', NULL, NULL, 'TRX8AJVGE06W1', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:00:45', '2023-01-19 21:00:45'),
(89, 11, NULL, 'User', NULL, NULL, 'TRXX3AEYXV9JU', 'Referral Bonus by ', '50', 'bonus', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:00:45', '2023-01-19 21:00:45'),
(90, 11, NULL, 'User', NULL, NULL, 'TRXA08EAK7FQR', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:05:22', '2023-01-19 21:05:22'),
(91, 11, NULL, 'User', NULL, NULL, 'TRXZ0LMU2IDPW', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:05:22', '2023-01-19 21:05:22'),
(92, 11, NULL, 'User', NULL, NULL, 'TRXSV3GQ1R5EO', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:10:02', '2023-01-19 21:10:02'),
(93, 11, NULL, 'User', NULL, NULL, 'TRXBUDDYIKVI5', 'Profit to Main Wallet Exchanged', '20000', 'exchange', '10', '20010', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:15:49', '2023-01-19 21:15:49'),
(94, 12, NULL, 'User', NULL, NULL, 'TRXZRKCLN6GPC', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 21:54:52', '2023-01-19 21:54:52'),
(95, 12, NULL, 'User', NULL, NULL, 'TRXV35CZYY4OJ', 'Deposit With USDT TRC20', '25000', 'manual_deposit', '0', '25000', 'USDT', 'USD', 25000, '{\"Username\":\"dilion\"}', '', 'success', '2023-01-19 22:10:33', '2023-01-19 22:11:53'),
(96, 12, NULL, 'User', NULL, NULL, 'TRXIATRCGEU5V', 'Rush Plan Plan Invested', '25000', 'investment', '0', '25000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 22:13:15', '2023-01-19 22:13:15'),
(97, 10, 1, 'Admin', NULL, NULL, 'TRXDW31QCYZGJ', 'Money Deposit From Admin', '5000', 'deposit', '0', '5000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 22:15:06', '2023-01-19 22:15:06'),
(98, 12, NULL, 'User', NULL, NULL, 'TRXISLGC8X292', 'Rush Plan Capital Back', '20000', 'refund', '0', '20000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:15:32', '2023-01-19 23:15:32'),
(99, 12, NULL, 'User', NULL, NULL, 'TRX7JYUBPXP2K', 'Rush Plan Plan Interest', '20000', 'interest', '0', '20000', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:15:32', '2023-01-19 23:15:32'),
(100, 12, NULL, 'User', NULL, NULL, 'TRXAWOGE8JIJU', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:20:23', '2023-01-19 23:20:23'),
(101, 12, NULL, 'User', NULL, NULL, 'TRXVDIT26E69X', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:20:23', '2023-01-19 23:20:23'),
(102, 12, NULL, 'User', NULL, NULL, 'TRXKR2BLNWFSM', 'Referral Bonus by ', '50', 'bonus', '0', '50', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:20:23', '2023-01-19 23:20:23'),
(103, 12, NULL, 'User', NULL, NULL, 'TRX95PVA16OD2', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:25:49', '2023-01-19 23:25:49'),
(104, 12, NULL, 'User', NULL, NULL, 'TRXSVQKUMVIUY', 'Referral Bonus by ', '20', 'bonus', '0', '20', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:25:49', '2023-01-19 23:25:49'),
(105, 12, NULL, 'User', NULL, NULL, 'TRXLWMJDN0N49', 'Referral Bonus by ', '10', 'bonus', '0', '10', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-19 23:30:24', '2023-01-19 23:30:24'),
(106, 13, NULL, 'User', NULL, NULL, 'TRXI6RU3YVLK4', 'Signup Bonus', '5', 'signup_bonus', '0', '5', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-20 01:13:28', '2023-01-20 01:13:28'),
(107, 12, NULL, 'User', NULL, NULL, 'TRXHCJWQDA1AT', 'Profit to Main Wallet Exchanged', '10000', 'exchange', '5', '10005', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-20 03:42:16', '2023-01-20 03:42:16'),
(108, 12, 1, 'User', NULL, NULL, 'TRXGG0MGSMXSW', 'Transfer Money To adislove', '2300', 'send_money', '115', '2415', 'system', NULL, NULL, '[]', 'none', 'success', '2023-01-20 03:42:58', '2023-01-20 03:42:58'),
(109, 1, 12, 'User', NULL, NULL, 'TRXCEJPNHKRNU', 'Transfer Money Form digitalmarketingtrainingagency', '2300', 'receive_money', '115', '2415', 'system', NULL, NULL, '[]', '', 'success', '2023-01-20 03:42:58', '2023-01-20 03:42:58');

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

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

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

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

INSERT INTO `withdraw_methods` (`id`, `icon`, `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'),
(3, 'global/images/x6dCsdkADO5kEwbCSfW1.png', 'Bitcoin', 'USD', 1, '1', 'minute', 0, 'percentage', '0', '100000', '{\"1\":{\"name\":\"Wallet Address\",\"type\":\"text\",\"validation\":\"required\"},\"2\":{\"name\":\"Wallet Name\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2023-01-17 10:17:48', '2023-01-17 10:17:48'),
(4, 'global/images/mZ9wwy9y4V7nCUYtQtkv.jpg', 'Binance', 'BNB', 1, '1', 'minute', 0, 'percentage', '20', '20000', '{\"1\":{\"name\":\"Wallet Address\",\"type\":\"text\",\"validation\":\"required\"}}', 1, '2023-01-19 22:34:41', '2023-01-19 22:34:41');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

