-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 19, 2023 at 05:53 PM -- Server version: 10.3.37-MariaDB-log-cll-lve -- PHP Version: 7.4.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `firsdyna_hyipdb` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `avatar` varchar(256) DEFAULT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(256) DEFAULT NULL, `password` 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 `admins` -- INSERT INTO `admins` (`id`, `avatar`, `name`, `email`, `phone`, `password`, `status`, `created_at`, `updated_at`) VALUES (1, 'global/images/GKrjCHkpnslfgQ6texjS.jpg', 'Supar Admin', 'admin@hyiprio.com', '01847305958', '$2y$10$wnBdmB5qXADVohxJqvxb.uE.kSIYb4QQzjkz3GAFyFV/iBqhHajG6', 1, '2022-08-24 03:03:35', '2022-11-17 04:43:01'), (2, NULL, 'Admin2', 'admin@codedphpscripts.xyz', NULL, '$2y$10$.spw1h1TNGCunfjn.tB6XOnviKAkwzd6mDvU96ck1sW2zfbvAqZnS', 1, '2023-01-20 03:39:19', '2023-01-20 03:39:19'); -- -------------------------------------------------------- -- -- 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', '

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.

Essential Narration

These Website Standard Terms and Conditions written on this webpage shall manage your use of our website, Hyiprio accessible at 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. 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.

Intellectual Property Rights

Other than the content you own, under these Terms, Company Name and/or its licensors own all the intellectual property rights and materials contained in this Website. You are granted limited license only for purposes of viewing the material contained on this Website.

The Steps

You are specifically restricted from all of the following:

Certain areas of this Website are restricted from being access by you and Company Name 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.

Submission Rights

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. Your Content must be your own and must not be invading any third-party\'s rights. Company Name reserves the right to remove any of Your Content from this Website at any time without notice.


Website is provided “as is,” with all faults, and Company Name 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. In no event shall Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract.  Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website.

Variation of Terms

Company Name 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. 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. The Company Name 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. 

Conclusion

These Terms will be governed by and interpreted in accordance with the laws of the State of Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in Country for the resolution of any disputes.

', '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', '

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.

Essential Narration

These Website Standard Terms and Conditions written on this webpage shall manage your use of our website, Hyiprio accessible at 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. 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.

Intellectual Property Rights

Other than the content you own, under these Terms, Company Name and/or its licensors own all the intellectual property rights and materials contained in this Website. You are granted limited license only for purposes of viewing the material contained on this Website.

The Steps

You are specifically restricted from all of the following:

Certain areas of this Website are restricted from being access by you and Company Name 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.

Submission Rights

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. Your Content must be your own and must not be invading any third-party\'s rights. Company Name reserves the right to remove any of Your Content from this Website at any time without notice.


Website is provided “as is,” with all faults, and Company Name 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. In no event shall Company Name, nor any of its officers, directors and employees, shall be held liable for anything arising out of or in any way connected with your use of this Website whether such liability is under contract.  Company Name, including its officers, directors and employees shall not be held liable for any indirect, consequential or special liability arising out of or in any way related to your use of this Website.

Variation of Terms

Company Name 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. 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. The Company Name 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. 

Conclusion

These Terms will be governed by and interpreted in accordance with the laws of the State of Country, and you submit to the non-exclusive jurisdiction of the state and federal courts located in Country for the resolution of any disputes.

', '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; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`id`, `name`, `code`, `for`, `banner`, `title`, `subject`, `salutation`, `message_body`, `button_level`, `button_link`, `footer_status`, `footer_body`, `bottom_status`, `bottom_title`, `bottom_body`, `short_codes`, `status`, `created_at`, `updated_at`) VALUES (1, 'User Mail Send', 'user_mail', 'User', 'global/images/Uxp3vfYFFi4GuO95lyZn.jpg', 'Sample Email', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', 'Thanks for joining us [[site_title]]
\r\n
\r\n[[message]]
\r\n
\r\n
\r\nFind out more about in - [[site_url]]', 'Login Your Account', 'https://codedphpscripts.xyz/hyipp', 1, 'Regards,
\r\n[[site_title]]', 0, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.
\r\n
\r\n[[site_url]]', '[\"[[full_name]]\",\"[[site_url]]\",\"[[site_title]]\",\"[[subject]]\",\"[[message]]\"]', 1, NULL, '2023-01-19 22:40:40'), (2, 'Subscriber Mail Send', 'subscriber_mail', 'Subscriber', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', 'Thanks for joining our platform! --- [[site_title]]
\r\n
\r\n[[message]]
\r\n
\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.
\r\n
\r\nFind out more about in - [[site_url]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! --- [[site_title]]
\r\n
\r\n[[message]]
\r\n
\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.
\r\n
\r\nFind out more about in - [[site_url]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.
\r\n
\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[subject]]\",\"[[message]]\"]', 1, NULL, '2022-11-08 19:58:00'), (3, 'Email Verification', 'email_verification', 'User', NULL, 'Verify Email Address', 'Verify Email Address', 'Hi [[full_name]],', 'Hello!
\r\nPlease click the button below to verify your email address.', 'Verify Email Address', '[[token]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Verify Email Address', 'If you\'re having trouble clicking the \"Verify Email Address\" button, copy and paste the URL below into your web browser:[[token]]', '[\"[[token]]\",\"[[full_name]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:24:12'), (4, 'Forget Password', 'user_password_change', 'User', NULL, 'User Password Change', 'User Forget Password', 'Hi [[full_name]],', 'Please click the button below to Change the Password.', 'Reset Password', '[[token]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'User Password Change', '[[token]]', '[\"[[token]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:28:32'), (5, 'User Investment', 'user_investment', 'User', 'global/images/3Z7UnXe62WeZkJdpSQic.jpg', 'You Invested on [[plan_name]]', 'Thanks for the Investment on [[site_title]]', 'Hi [[full_name]],', 'Hello!
\r\n[[txn]]. \'Successfully Investment
\r\n[[plan_name]]
\r\n[[invest_amount]]', 'Login Account', '[[token]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Successfully Investment', '[[txn]]. \' Successfully Investment', '[\"[[full_name]]\",\"[[txn]]\",\"[[plan_name]]\",\"[[invest_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:30:18'), (6, 'User Account Disabled', 'user_account_disabled', 'User', NULL, 'Sorry to say that', 'Your Account is Disabled', 'Hi [[full_name]],', 'Your account is disabled for a serious cause. Sorry! you\'re unable to use your account again.', 'Contact Us', 'https://hyiprio.tdevs.co/contact', 1, 'Regards,
\r\n[[site_title]]', 0, 'User Account Disabled', '[[full_name]]', '[\"[[full_name]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:32:44'), (7, 'Manual Deposit request', 'manual_deposit_request', 'Admin', NULL, 'Manual Deposit request', 'Got a request for Manual Deposit', 'Hi Admin,', 'The manual deposit request details:
\r\n[[txn]]
\r\n[[gateway_name]]
\r\n[[deposit_amount]]', 'Review The requests', 'https://hyiprio.tdevs.co/admin', 1, 'Regards,
\r\n[[site_title]]', 0, 'Manual Deposit request', '[[site_title]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:35:05'), (8, 'Withdraw Request', 'withdraw_request', 'Admin', NULL, 'Withdraw Request', 'Got a Withdraw Request', 'Hi Admin,', 'Withdraw Request details:
\r\n[[txn]]
\r\n[[method_name]]
\r\n[[withdraw_amount]]', 'Withdraw Request', '[[token]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]', '[\"[[full_name]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:36:03'), (9, 'Admin Forget Password', 'admin_forget_password', 'Admin', NULL, 'Admin Forget Password', 'Admin Forget Password', 'Hi Admin,', 'Please click the button below to reset your password', 'Password reset', '[[token]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]
\r\n[[token]]', '[\"[[token]]\",\"[[site_title]]\",\"[[site_url]]\"]', 1, NULL, '2022-11-17 19:36:52'), (10, 'Contact Mail Send', 'contact_mail', 'Admin', NULL, 'Welcome to [[site_title]]', '[[subject]] for [[full_name]]', 'Hi [[full_name]],', 'Thanks for joining our platform! --- [[site_title]]
\r\n
\r\n[[message]]
\r\n[[full_name]]
\r\n[[email]]
\r\n
\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.
\r\n
\r\nFind out more about in - [[site_url]]', 'Login Your Account', 'https://hyiorio.com/login', 1, 'Thanks for joining our platform! --- [[site_title]]
\r\n
\r\n[[message]]
\r\n
\r\n
\r\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency, invest and earn profits.
\r\n
\r\nFind out more about in - [[site_url]]', 1, 'What is [[site_title]]', 'Hyiprio is a visual asset manager made for collaboration. Build a central library for your team\'s visual assets. Empower creation and ensure consistency from your desktop.
\r\n
\r\n[[site_url]]', '[\"[[site_url]]\",\"[[site_title]]\",\"[[full_name]]\",\"[[email]]\",\"[[subject]]\",\"[[message]]\"]', 1, NULL, '2022-11-22 06:36:02'), (11, 'Withdraw Request', 'withdraw_request_user', 'User', NULL, 'Withdraw Request', 'Got a Withdraw Request', 'Hi [[full_name]],', 'Withdraw Request details:
\r\n[[message]]
\r\n[[txn]]
\r\n[[method_name]]
\r\n[[withdraw_amount]]
\r\n[[status]]', 'Withdraw Request', '[[site_url]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Withdraw Request', '[[full_name]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[method_name]]\",\"[[withdraw_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, '2023-01-04 07:26:55'), (12, 'Manual Deposit request', 'user_manual_deposit_request', 'User', NULL, 'Manual Deposit request', 'Got a request for Manual Deposit', 'Hi [[full_name]],', 'The manual deposit request details:
\r\n[[message]]\r\n[[txn]]
\r\n[[gateway_name]]
\r\n[[deposit_amount]]\r\n[[status]]\r\n', 'Review The requests', '[[site_url]]', 1, 'Regards,
\r\n[[site_title]]', 0, 'Manual Deposit request', '[[site_title]]', '[\"[[full_name]]\",\"[[message]]\",\"[[txn]]\",\"[[gateway_name]]\",\"[[deposit_amount]]\",\"[[site_title]]\",\"[[site_url]]\",\"[[status]]\"]', 1, NULL, '2022-11-17 19:35:05'); -- -------------------------------------------------------- -- -- 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 `gateways` -- CREATE TABLE `gateways` ( `id` bigint(20) UNSIGNED NOT NULL, `logo` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `type` enum('auto','manual') NOT NULL DEFAULT 'manual', `gateway_code` varchar(255) NOT NULL, `charge` double NOT NULL DEFAULT 0, `charge_type` enum('percentage','fixed') NOT NULL, `minimum_deposit` double NOT NULL, `maximum_deposit` double NOT NULL, `rate` double NOT NULL, `supported_currencies` text DEFAULT NULL, `currency` varchar(256) NOT NULL DEFAULT 'USD', `currency_symbol` varchar(256) NOT NULL DEFAULT '$', `credentials` text NOT NULL, `payment_details` longtext DEFAULT NULL, `status` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `gateways` -- INSERT INTO `gateways` (`id`, `logo`, `name`, `type`, `gateway_code`, `charge`, `charge_type`, `minimum_deposit`, `maximum_deposit`, `rate`, `supported_currencies`, `currency`, `currency_symbol`, `credentials`, `payment_details`, `status`, `created_at`, `updated_at`) VALUES (1, 'global/images/Wj9LkSsf99Y4mMy4mkFL.svg', 'Paypal', 'auto', 'paypal', 5, 'percentage', 10, 90000, 2, '[\"AUD\",\"BRL\",\"CAD\",\"CZK\",\"DKK\",\"EUR\",\"HKD\",\"HUF\",\"INR\",\"ILS\",\"JPY\",\"MYR\",\"MXN\",\"TWD\",\"NZD\",\"NOK\",\"PHP\",\"PLN\",\"GBP\",\"RUB\",\"SGD\",\"SEK\",\"CHF\",\"THB\",\"USD\"]', 'CAD', '$', '{\"client_id\":\"AUnfkQ3v2J-d5g-ZEq8l5Oosha8FmAJ3Z9jt71BkD6l-Z3FMIR5FmkYp_6QHwaYx0LvMNvHDsB9Vh84O\",\"client_secret\":\"EJjci35CFj762ut15pn0VWmojEG0GwE68byyHnBq_NoAXXW9mjkjdLFYLfVQwyLs8QAbP1QJAXPl5oAl\",\"app_id\":\"APP-80W284485P519543T\",\"mode\":\"sandbox\"}', '', 1, NULL, '2022-11-16 10:09:20'), (2, 'global/gateway/stripe.png', 'Stripe', 'auto', 'stripe', 0, 'fixed', 10, 200, 1, '[\"USD\",\"AUD\",\"BRL\",\"CAD\",\"CHF\",\"DKK\",\"EUR\",\"GBP\",\"HKD\",\"INR\",\"JPY\",\"MXN\",\"MYR\",\"NOK\",\"NZD\",\"PLN\",\"SEK\",\"SGD\"]', 'USD', '$', '{\"stripe_key\":\"pk_test_51KHQhKAmfDlh6wQq4srkOEY3FkivTCXmRSb7bJqr90q3ZkVWAR2AkRWfKBnegpmKAHea5cNVAToiy7yoa3Q075mR00jlhXsZTO\",\"stripe_secret\":\"sk_test_51KHQhKAmfDlh6wQqXfg4ZScnTRahxbdXV0mKw30nOI4f8gtB2v5rho7IyJtZqkf8SwwuNgLTO2WPGFyk9vnFl8gO00MhSe8Kbj\"}', '', 1, NULL, '2022-11-13 07:46:46'), (3, 'global/gateway/mollie.png', 'Mollie', 'auto', 'mollie', 0, 'fixed', 0, 0, 1, '[\"USD\",\"EUR\"]', 'EUR', '$', '{\"api_key\":\"test_intSTCDEBaDSu28D6DUpn5wnQhTnzB\"}', '', 1, NULL, '2022-10-28 15:43:50'), (4, 'global/gateway/perfectmoney.png', 'Perfect Money', 'auto', 'perfectmoney', 0, 'fixed', 0, 0, 20, '[\"USD\",\"EUR\"]', 'USD', '$', '{\"PM_ACCOUNTID\":\"96793260\",\"PM_PASSPHRASE\":\"77887848a\",\"PM_MARCHANTID\":\"U36928259\",\"PM_MARCHANT_NAME\":\"tdevs\"}', '', 1, NULL, '2022-10-28 16:38:11'), (5, 'global/gateway/coinbase.png', 'Coinbase', 'auto', 'coinbase', 0, 'fixed', 0, 5000, 1, '[\"USD\",\"EUR\"]', 'USD', '$', '{\"apiKey\":\"8ef6c4ca-f5c7-4717-9d9a-002adf7e7590\",\"webhookSecret\":\"b789f547-8954-4880-89ae-5a0233006647\",\"apiVersion\":\"2018-03-22\"}', '', 1, NULL, '2022-12-26 12:24:26'), (6, 'global/gateway/paystack.png', 'Paystack', 'auto', 'paystack', 0, 'fixed', 500, 5000, 1, '[\"GHS\"]', 'GHS', '$', '{\"public_key\":\"pk_live_56db449aad218f8c06c3d23ddfe0276631d7dae3\",\"secret_key\":\"sk_live_b8ad5d6b269998b68f8199cb1b121440732d374b\",\"merchant_email\":\"gseun129@gmail.com\"}', '', 1, NULL, '2023-01-16 22:26:54'), (7, 'global/gateway/voguepay.png', 'Voguepay', 'auto', 'voguepay', 0, 'fixed', 10, 500, 2, '[\"NGN\"]', 'NGN', 'NGN', '{\"merchant_id\":\"sandbox_760e43f202878f651659820234cad9\"}', '', 1, NULL, '2022-11-14 02:08:13'), (8, 'global/gateway/flutterwave.png', 'Flutterwave', 'auto', 'flutterwave', 0, 'fixed', 10, 500, 1, '[\"USD\"]', 'USD', '$', '{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\"}', '', 1, NULL, '2022-11-14 02:08:13'), (9, 'global/gateway/coingate.png', 'CoinGate', 'auto', 'coingate', 0, 'fixed', 10, 500, 1, '[\"USD\"]', 'USD', '$', '{\"api_token\":\"NPfn5eAGjha_PqfQmC6F_rMA6_zaGVLmVk6Uvsfu\"}', '', 1, NULL, '2022-11-22 22:01:12'), (10, 'global/gateway/monnify.svg', 'Monnify', 'auto', 'monnify', 0, 'fixed', 10, 500, 1, '[\"NGN\"]', 'NGN', '$', '{\"api_key\":\"MK_TEST_BDQKAE9QNX\",\"api_secret\":\"4PSEUWJJ1HAKEYPXTT375CR9Y1LLX369\",\"base_url\":\"https:\\/\\/sandbox.monnify.com\",\"contract_code\":\"0086188339\"}', '', 1, NULL, '2022-12-05 09:02:39'), (11, 'global/gateway/securionpay.png', 'SecurionPay', 'auto', 'securionpay', 0, 'fixed', 10, 500, 444.81, '[\"NGN\"]', 'NGN', '$', '{\"public_key\":\"pk_test_7bkvbNaJzb1Eh2Egtp9NQ9Os\",\"secret_key\":\"sk_test_7bkvbSEKpHWR4bJL8qdoq7c9\"}', '', 1, NULL, '2022-12-07 11:11:19'), (12, 'global/gateway/coinpayments.svg', 'CoinPayments', 'auto', 'coinpayments', 0, 'fixed', 10, 500, 444.81, '[\"BTC\",\"BTC.LN\"]', 'BTC', '$', '{\"public_key\":null,\"private_key\":null}', '', 1, NULL, '2023-01-04 08:31:43'), (15, 'global/images/xEkt58alLcaE826Ddw7c.png', 'Mobile Money (Manual)', 'manual', 'mobile-money', 0, 'percentage', 100, 100000, 12, NULL, 'Ghana Cedis', 'GHC', '{\"1\":{\"name\":\"01236547859\",\"type\":\"text\",\"validation\":\"required\"},\"2\":{\"name\":\"Transaction Screenshot\",\"type\":\"file\",\"validation\":\"required\"}}', '

Mobile Money number: 01236547859

\n\n

It will take a maximum of 60 minutes to deposit manually

', 1, '2022-09-04 13:59:01', '2023-01-16 22:29:58'), (16, 'global/images/7whR5ZpvyXddiTlm1cVh.png', 'Bank Transfer(Manual)', 'manual', 'bank-transfer', 2, 'percentage', 10, 90000, 1, NULL, 'USD', '$', '{\"1\":{\"name\":\"Bank Name\",\"type\":\"text\",\"validation\":\"required\"},\"2\":{\"name\":\"Bank Holder Name\",\"type\":\"text\",\"validation\":\"required\"},\"3\":{\"name\":\"IBN Number\",\"type\":\"text\",\"validation\":\"required\"},\"4\":{\"name\":\"Account Number\",\"type\":\"text\",\"validation\":\"required\"}}', '

Account Number: 2578-569645665

\n\n

Bank Name: Bank of Baroda

', 1, '2022-09-17 17:48:58', '2022-11-16 08:53:11'), (18, 'global/images/ta9IkQHkUCohp4jXtvoO.png', 'Bitcoin', 'manual', 'BTC', 0, 'percentage', 100, 100000, 1, NULL, '$', 'USD', '{\"1\":{\"name\":\"Upload Proof\",\"type\":\"file\",\"validation\":\"required\"}}', '

Please pay into the Bitcoin Wallet Below

\n\n

bc1q0lpntdkz0ys2k5wstrkvlap0w73gtdq8e4ppgk

', 1, '2023-01-16 22:56:22', '2023-01-16 22:56:22'), (19, 'global/images/M1bHNwQseEyTU5tZkY56.jpg', 'USDT TRC20', 'manual', 'USDT', 0, 'percentage', 10, 25000, 1, NULL, 'USD', '$', '{\"1\":{\"name\":\"Username\",\"type\":\"text\",\"validation\":\"nullable\"}}', '
Please Pay Here
\n\n
TT8ScysgXX8Y2LnzvNA2N7fDPyM2nGzpsd
\n\n

After payment please send a ticket to admin
', 1, '2023-01-19 19:50:20', '2023-01-19 19:50:20'), (20, 'global/images/HLzKsg8YbWU9WhKioLv1.jpg', 'Binance Coin', 'manual', 'BNB', 10000, 'percentage', 2000, 20000, 100, NULL, 'USD', '$', '{\"1\":{\"name\":\"Upload Proof\",\"type\":\"text\",\"validation\":\"required\"}}', '

Please Make Payment To The BNB Address Below

\n\n

BNBYUYTTYUY77e64748848489

', 1, '2023-01-19 22:32:02', '2023-01-19 22:32:02'); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `title`, `url`, `code`, `data`, `type`, `status`, `created_at`, `updated_at`) VALUES (1, 'Schema', 'schema', 'schema', '{\"title\":\"All the Schemas\",\"title_small\":\"Our Investment Plans\",\"title_big\":\"The plans we offer is specifically made for you.\",\"left_top_img\":\"global\\/images\\/I68p4rslg9zW4R83R9sN.png\",\"meta_keywords\":\"All the Schemas\",\"meta_description\":\"All the Schemas\"}', 'static', 1, NULL, '2022-11-16 19:02:23'), (2, 'How It Works', 'how-it-works', 'howitworks', '{\"title\":\"How it Works\",\"title_small\":\"\",\"title_big\":\"We provide seemless investment options\",\"section_id\":\"9\",\"meta_keywords\":\"How it Works\",\"meta_description\":\"How it Works\"}', 'static', 1, NULL, '2023-01-16 22:24:47'), (3, 'About Us', 'about-us', 'about', '{\"title\":\"About Us\",\"left_img_badge\":\"High Yield Hyip Investment\",\"title_small\":\"Who We Are\",\"title_big\":\"Explore us from the experience\",\"side_content\":\"We are private investment company that you will love\",\"content\":\"

Lorem ipsum dolor sit amet consectetur adipisicing elit. Culpa, aperiam eum impedit sit facilis itaque tempore dicta mollitia error quibusdam. Obcaecati at velit ipsam incidunt quidem eius, repellat voluptatem in. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Inventore ratione facere, veritatis sunt voluptatibus corrupti blanditiis cum autem dolorem. Quos esse est voluptate labore unde, soluta deleniti. Temporibus, cum deserunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit<\\/p>\\n\\n

Lorem ipsum dolor sit, amet consectetur adipisicing elit. Sapiente totam dicta qui quae ut incidunt aliquam vel veritatis quasi laudantium! Ullam accusamus dolorum recusandae ratione. Quis praesentium id alias ullam? Lorem ipsum, dolor sit amet consectetur adipisicing elit. Quas fugiat enim corrupti, adipisci dolores perferendis vero sit tempora recusandae laboriosam officiis inventore distinctio. A eos quam, autem deserunt voluptates<\\/p>\",\"aboutusLeftImg\":\"global\\/images\\/g4xp4oSimXAEZGvOKugJ.png\",\"meta_keywords\":\"About Us\",\"meta_description\":\"About Us\"}', 'static', 1, NULL, '2023-01-19 22:38:25'), (4, 'FAQ ', 'faq', 'faq', '{\"title\":\"FAQ Page\",\"title_small\":\"sdfgsdfsd\",\"title_big\":\"Explore Your Questions\",\"section_id\":\"9\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"https:\\/\\/hyiprio.tdevs.co\\/contact\",\"hero_button2_target\":\"_self\",\"meta_keywords\":\"FAQ Page\",\"meta_description\":\"FAQ Page\"}', 'static', 1, NULL, '2022-11-16 20:16:53'), (5, 'Rankings ', 'rankings', 'ranking', '{\"title\":\"Rankings Page\",\"title_small\":\"Achievements\",\"title_big\":\"Explore all the badges here\",\"button_icon\":\"anticon-mail\",\"button_level\":\"Still No Luck?\",\"button_url\":\"$\",\"hero_button2_target\":\"_blank\",\"content\":\"


<\\/p>\",\"meta_keywords\":\"Rankings Page\",\"meta_description\":\"Rankings Page\"}', 'static', 1, NULL, '2022-11-16 20:08:45'), (6, 'Blog ', 'blog', 'blog', '{\"title\":\"All Blogs\",\"title_small\":\"Blog Title Smallss\",\"title_big\":\"Our Latest News\",\"sidebar_widget_title\":\"Other Blog Posts\",\"sidebar_widget_title_2\":\"Recent Blogss\",\"meta_keywords\":\"All Blogs\",\"meta_description\":\"All Blogs\"}', 'static', 1, NULL, '2022-11-17 17:47:21'), (7, 'Contact Us', 'contact', 'contact', '{\"title\":\"Contact Us\",\"title_small\":\"Get In Touch\",\"title_big\":\"Say Hi to us\",\"meta_keywords\":\"Contact Us\",\"meta_description\":\"Contact Us\"}', 'static', 1, NULL, '2022-11-16 23:42:33'), (8, 'Privacy Policy', 'privacy-policy', 'privacy', '{\"title\":\"Privacy Policy\",\"content\":\"\\r\\n\\r\\n

In order to provide the services of the Platform to Users, Ivest Plan Way needs to collect some of your personal information when you register with the Platform, log in to the Platform and\\/or use the services offered by the Platform. This Privacy Policy, in combination with KuCoin\\u2019s other applicable policies, set out the rules as to the use and protection of the collected information in order to prevent misuse.\\u00a0<\\/p>

For the convenience of wording in this agreement (the \\u201cAgreement\\u201d), the Platform is referred to as \\u201cwe\\u201d, \\u201cus\\u201d or \\u201cour\\u201d. Users of and other visitors to the Platform are referred to as \\u201cyou\\u201d, \\u201cyour\\u201d or \\u201cUser\\u201d. We and you are collectively referred to as \\u201cboth parties\\u201d and as \\u201ca\\/one party\\u201d individually.<\\/p>


<\\/div><\\/div>\",\"files\":\"global\\/images\\/h0hwylrv2QFLC0bAHxQk.jpg\",\"meta_keywords\":\"Privacy Policy\",\"meta_description\":\"Privacy Policy\"}', 'static', 1, NULL, '2022-12-25 14:41:14'), (9, 'Terms and Conditions', 'terms-and-conditions', 'terms', '{\"title\":\"Terms and Conditions\",\"content\":\"

Invest Plan Way (www.investplanway.com<\\/a>) is an information intermediary service Platform (hereinafter referred to as the \\u201cPlatform\\\") that provides Users with digital asset trading and related services. The Platform provides services to Users registered with the Platform (hereinafter referred to as the \\u201cUsers\\\") in accordance with the terms and conditions of this Agreement (defined below), and this Agreement shall be legally binding between the Users and the Platform. The Platform hereby reminds the Users to carefully read and fully understand the terms and conditions of this Agreement, especially those terms and conditions of this Agreement that exclude or limit the liability of the Platform and exclude or restrict the rights and interests of the Users. The Users shall read carefully and choose to accept or reject this Agreement. Unless a User accepts all the terms and conditions of this Agreement, the User shall not be entitled to use the services provided by the Platform. If the User does not agree to the content of this Agreement or refuses to recognize the right of the Platform to make unilateral amendments to this Agreement at any time, the User shall promptly stop using and cease to access the Platform. By registering as a User of the Platform or using the services offered, a User is deemed to fully understand and fully accept all the terms and conditions of this Agreement, including any amendments that this Company may make to this Agreement at any time.<\\/p>\\r\\n\\r\\n


<\\/p>\\r\\n\\r\\n

For the convenience of wording in this Agreement, the Platform is collectively referred to as \\\"we\\\" or other applicable forms of first-person pronouns in this Agreement.All natural persons and other visitors who log onto this Website shall be referred to as \\\"you\\\" or any other applicable forms of the second-person pronouns. You and we are collectively referred to as \\u201cboth parties\\u201d, and individually as \\u201cone party\\u201d herein.<\\/p>\",\"files\":\"global\\/images\\/1gcQReqxFvALwGLLItbu.jpg\",\"meta_keywords\":\"Terms and Conditions\",\"meta_description\":\"Terms and Conditions\"}', 'static', 1, NULL, '2022-12-25 14:48:04'), (10, 'Login', '/login', 'login', '{\"title\":\"\\ud83d\\udc4b Welcome Back!\",\"bottom_text\":\"Sign in to continue with Hyiprio User Panel\"}', 'static', 1, NULL, '2022-10-24 07:08:53'), (11, 'Registration', '/registration', 'registration', '{\"title\":\"\\ud83d\\udcaa Create an account\",\"bottom_text\":\"Register to continue with Hyiprio\"}', 'static', 1, NULL, '2022-11-10 08:35:48'), (12, 'Forgot Password', '/forgot-password', 'forgetpassword', '{\"title\":\"Password Reset\",\"bottom_text\":\"Reset your Password\"}', 'static', 1, NULL, '2022-11-16 09:24:24'); -- -------------------------------------------------------- -- -- 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; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `category`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'Customer Management', 'customer-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (2, 'Customer Management', 'customer-login', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (3, 'Customer Management', 'customer-mail-send', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (4, 'Customer Management', 'customer-basic-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (5, 'Customer Management', 'customer-balance-add-or-subtract', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (6, 'Customer Management', 'customer-change-password', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (7, 'Customer Management', 'all-type-status', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (8, 'Kyc Management', 'kyc-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (9, 'Kyc Management', 'kyc-action', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (10, 'Kyc Management', 'kyc-form-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (11, 'Role Management', 'role-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (12, 'Role Management', 'role-create', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (13, 'Role Management', 'role-edit', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (14, 'Staff Management', 'staff-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (15, 'Staff Management', 'staff-create', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (16, 'Staff Management', 'staff-edit', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (17, 'Plan Management', 'schedule-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (18, 'Plan Management', 'schema-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (19, 'Plan Management', 'schema-create', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (20, 'Plan Management', 'schema-edit', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (21, 'Transaction Management', 'transaction-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (22, 'Transaction Management', 'investment-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (23, 'Transaction Management', 'profit-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (24, 'Deposit Management', 'automatic-gateway-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (25, 'Deposit Management', 'manual-gateway-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (26, 'Deposit Management', 'deposit-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (27, 'Deposit Management', 'deposit-action', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (28, 'Withdraw Management', 'withdraw-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (29, 'Withdraw Management', 'withdraw-method-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (30, 'Withdraw Management', 'withdraw-action', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (31, 'Referral Management', 'target-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (32, 'Referral Management', 'referral-create', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (33, 'Referral Management', 'referral-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (34, 'Referral Management', 'referral-edit', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (35, 'Referral Management', 'referral-delete', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (36, 'Ranking Management', 'ranking-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (37, 'Ranking Management', 'ranking-create', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (38, 'Ranking Management', 'ranking-edit', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (39, 'Frontend Management', 'landing-page-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (40, 'Frontend Management', 'page-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (41, 'Frontend Management', 'footer-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (42, 'Frontend Management', 'navigation-manage', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (43, 'Subscriber Management', 'subscriber-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (44, 'Subscriber Management', 'subscriber-mail-send', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (45, 'Support Ticket Management', 'support-ticket-list', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (46, 'Support Ticket Management', 'support-ticket-action', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (47, 'Setting Management', 'site-setting', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (48, 'Setting Management', 'email-setting', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (49, 'Setting Management', 'plugin-setting', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (50, 'Setting Management', 'language-setting', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (51, 'Setting Management', 'page-setting', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (52, 'Setting Management', 'email-template', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'), (53, 'Setting Management', 'custom-css', 'admin', '2022-10-31 14:37:48', '2022-10-31 14:37:48'); -- -------------------------------------------------------- -- -- 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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `ranking_id` bigint(20) DEFAULT NULL, `rankings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `avatar` varchar(256) DEFAULT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `gender` enum('male','female','other','') NOT NULL DEFAULT '', `date_of_birth` date DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `zip_code` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `balance` float(10,2) NOT NULL DEFAULT 0.00, `profit_balance` float(10,2) NOT NULL DEFAULT 0.00, `status` tinyint(1) NOT NULL DEFAULT 1, `kyc` tinyint(1) NOT NULL DEFAULT 0, `kyc_credential` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `google2fa_secret` text DEFAULT NULL, `two_fa` tinyint(1) NOT NULL DEFAULT 0, `deposit_status` tinyint(1) NOT NULL DEFAULT 1, `withdraw_status` tinyint(1) NOT NULL DEFAULT 1, `transfer_status` tinyint(1) NOT NULL DEFAULT 1, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) 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 `users` -- INSERT INTO `users` (`id`, `ranking_id`, `rankings`, `avatar`, `first_name`, `last_name`, `country`, `phone`, `username`, `email`, `gender`, `date_of_birth`, `city`, `zip_code`, `address`, `balance`, `profit_balance`, `status`, `kyc`, `kyc_credential`, `google2fa_secret`, `two_fa`, `deposit_status`, `withdraw_status`, `transfer_status`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 2, '[1,3,2]', NULL, 'Emeka', 'Ene', 'United Kingdom', '+44 09087654323', 'adislove', 'gseun129@gmail.com', '', NULL, NULL, NULL, NULL, 17769.00, 3660.10, 1, 1, '{\"NID Number\":\"65455555\",\"Image Of NID\":\"global\\/images\\/JvRsR4lDBKZxcBUCNjH4.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-16T18:00:40.906225Z\",\"Action Message\":\"\"}', 'eyJpdiI6IkZGUDFNeVpyWU9aU2h0cjBGUEZpSHc9PSIsInZhbHVlIjoiU0U4YzRWY25OQzZCNHJtU0JPcXQzM2pzN1VBc0JPbnFuYWhDczU1QlFaND0iLCJtYWMiOiIxZDA1Njc0ZWE2MWIyZWQ1ZDdhYzdlMzE3MzEzMTQzNTk4MzVhMDhkMGNkNGU1MGU0YzA4YjhmNWFmNDI1ODlmIiwidGFnIjoiIn0=', 0, 1, 1, 1, '2023-01-16 22:59:36', '$2y$10$fpKL96SNqmVMumQEFV7wM.sU3P4uvjOl8xq0l.tQMYz7aEMO4ojsq', 'IZdkSPIZ81MiVQvUdtMuAPJRNak40qrxxvb05pVD295YOKVU2IxkOUsXr0tn', '2023-01-16 22:57:25', '2023-01-20 03:42:58'), (2, 1, '[1]', NULL, 'Precious', 'Abraham', 'Nigeria', '+234 9013665198', 'Prec1234', 'Abrahamprecious940@gmail.com', '', NULL, NULL, NULL, NULL, 1000.00, 5.00, 1, 0, NULL, NULL, 0, 1, 1, 1, '2023-01-17 10:36:14', '$2y$10$yMNaV3evNXxURFg0LHx.1ehuIQR4S0IcZUqvg6VuENIkr8RUz8xy.', NULL, '2023-01-17 02:48:38', '2023-01-17 10:36:33'), (3, 1, '[1]', NULL, 'Amos', 'Orji', 'Nigeria', '+234 09162829', 'Orjikeyz', 'Orjikeyz7@gmail.com', '', NULL, NULL, NULL, NULL, 6600.00, 5.00, 1, 1, NULL, NULL, 0, 1, 1, 1, '2023-01-17 10:37:04', '$2y$10$VGZ3qXD.9XlQsgeRHqjhEOFFa.Gk9SC8JDzqdgrr4TS0QClEqWfau', NULL, '2023-01-17 08:52:22', '2023-01-17 10:37:19'), (4, 3, '[1,2,3]', NULL, 'Bryte', 'David', 'Nigeria', '+234 111111111111', 'bryte', 'brytedree@gmail.com', '', NULL, NULL, NULL, NULL, 2698.00, 385.00, 1, 1, '{\"NID Number\":\"34532532534\",\"Image Of NID\":\"global\\/images\\/ISah8QJ7xWcK13NSxu4l.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-17T10:06:16.268859Z\",\"Action Message\":\"\"}', NULL, 0, 1, 1, 1, '2023-01-19 18:31:26', '$2y$10$YdlAjVw790dim2302/yUUeIsYTgWPx6E469rL5L6iOUEuaFDTypPi', NULL, '2023-01-17 14:20:19', '2023-01-19 20:40:02'), (5, 1, '[1]', NULL, 'Solomom', 'Solomon', 'Nigeria', '+234 9766766767', 'adislove1', 'ayoungchief@gmail.com', '', NULL, NULL, NULL, NULL, 0.00, 5.00, 1, 0, NULL, NULL, 0, 1, 1, 1, NULL, '$2y$10$CrAPQv3WZq/UBLvxTC.3MOqRwRADt0SHvP6xHlTZ5H0ZwHKmIR2rG', NULL, '2023-01-17 16:34:21', '2023-01-17 16:34:21'), (6, 1, '[1]', NULL, 'Siya', 'Bonga', 'Nigeria', '+234 5512574991', 'Gail', 'biggod042@gmail.com', '', NULL, NULL, NULL, NULL, 0.00, 5.00, 1, 0, NULL, NULL, 0, 1, 1, 1, '2023-01-17 16:39:46', '$2y$10$TrHg1XhPIe8apdbI4NkA5uubkbRfW2sgqmNJ2d82PQRsxMTXvn5YG', NULL, '2023-01-17 16:35:30', '2023-01-17 16:39:46'), (7, 3, '[1,2,3]', NULL, 'biodun', 'desmond', 'Nigeria', '+234 07890000', 'webbiit', 'daydealayeye@gmail.com', '', NULL, NULL, NULL, NULL, 8000.00, 1035.00, 1, 1, '{\"NID Number\":\"64566666\",\"Image Of NID\":\"global\\/images\\/vnl8axeusp9SJEN3RKWS.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-17T12:20:24.506493Z\",\"Action Message\":\"\"}', NULL, 0, 1, 1, 1, '2023-01-17 17:19:49', '$2y$10$I.ld2PzDlfuQzmlDxuGJfOcZrMb1KoiSxLGyWTEnY6qRP1EDSJB4K', NULL, '2023-01-17 16:39:06', '2023-01-19 03:20:35'), (8, 1, '[1]', NULL, 'sunshine', 'daboss', 'Nigeria', '+234 7014196078', 'sunshine2022', 'sunshinedaboss2022@gmail.com', '', NULL, NULL, NULL, NULL, 5000.00, 5.00, 1, 1, '{\"NID Number\":\"82113552408\",\"Image Of NID\":\"global\\/images\\/6FTQXM5Ate2MnzdtM4xv.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-17T13:21:23.558324Z\",\"Action Message\":\"\"}', NULL, 0, 1, 1, 1, '2023-01-17 18:05:23', '$2y$10$EEQyMCMbkJCELrWWDVo/M.pPPdlXtsX3i.CESDPAE1AXZmr0QQyne', NULL, '2023-01-17 18:02:01', '2023-01-19 19:32:43'), (9, 1, '[1]', NULL, 'Annisa', 'Diann', 'Aland Islands', '+358 9063939870', 'Annisa', 'annisadiann5@gmail.com', '', NULL, NULL, NULL, NULL, 0.00, 5.00, 1, 0, NULL, NULL, 0, 1, 1, 1, NULL, '$2y$10$BvFUfQBxIxm/C7KXkAWwFeTTqGDIXnmsNKtbSZiH1A3uO4wqE6P/C', NULL, '2023-01-19 16:07:07', '2023-01-19 16:07:07'), (10, 1, '[1]', NULL, 'daniel', 'ibitimi', 'Nigeria', '+234 8144259018', 'Dannyscott', 'danielibitimiolomu@gmail.com', '', NULL, NULL, NULL, NULL, 5000.00, 5.00, 0, 1, NULL, NULL, 0, 0, 0, 0, '2023-01-19 22:14:38', '$2y$10$1zF9J4st5RY/7nMuBF7/2eM2dkJYJElfltFmSeVWBTQ8NPaAArTza', NULL, '2023-01-19 17:50:09', '2023-01-19 22:15:06'), (11, 2, '[1,4,3,2]', 'global/images/eCe06copR0vSC3GczXRr.png', 'Ca', 'Solomon', 'Nigeria', '+234 9766766767', 'carogold4life', 'carogold4life@gmail.com', 'male', NULL, '', '', '', 45000.00, 115.00, 1, 1, '{\"NID Number\":\"4333222333\",\"Image Of NID\":\"global\\/images\\/eRhFDwvgjDLXXXHSo3Sm.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-19T14:29:10.848133Z\",\"Action Message\":\"\"}', NULL, 0, 1, 1, 1, '2023-01-19 19:21:10', '$2y$10$pxeHGwkY5c1f22huIf5Nw.FaQgNB.wS3H/EfEJxzv0xWHRNZba0tS', NULL, '2023-01-19 19:15:41', '2023-01-19 21:15:49'), (12, 2, '[1,4,3,2]', NULL, 'Dilion', 'Bencarson', 'Aland Islands', '+358 09087654323', 'digitalmarketingtrainingagency', 'digitalmarketingtrainingagency@gmail.com', '', NULL, NULL, NULL, NULL, 32585.00, 10120.00, 1, 1, '{\"NID Number\":\"7637363733\",\"Image Of NID\":\"global\\/images\\/WXpix9wAPbJp3tWSTLru.png\",\"kyc_type_of_name\":\"National ID Verification\",\"kyc_time_of_time\":\"2023-01-19T17:05:59.084523Z\",\"Action Message\":\"\"}', 'eyJpdiI6Ik1wRE5rODU1aGd3QU5XUUtSdk5ITVE9PSIsInZhbHVlIjoiOFNyTG43OVNjSUhmYWdTTmI0QU1EQnQzdlk0c0J3bzN5ZnpxOENCNkJaND0iLCJtYWMiOiJhNjZlZTZjOGVlN2Q0Y2I5MzEzMDk2MjMyZWQ1ZjIwYTNjYWQ0OTJiNWU5MWRiNmQ5MGUzNDZmM2NkZjBhNTI0IiwidGFnIjoiIn0=', 0, 1, 1, 1, '2023-01-19 22:04:53', '$2y$10$KdGP4ju.umIx16ZSQMe6R.qNbkQVYuUwd91KMUXKX9odGHzeslIrW', NULL, '2023-01-19 21:54:52', '2023-01-20 03:44:48'), (13, 1, '[1]', NULL, 'James', 'Adams', 'Nigeria', '+234 1234567890', 'James24', 'drxu333@gmail.com', '', NULL, NULL, NULL, NULL, 0.00, 5.00, 1, 0, NULL, NULL, 0, 1, 1, 1, '2023-01-20 01:20:20', '$2y$10$yYXrt/kzd3UR995Glwu9kO5vp2zc9KwOPf3SD.e1cvl/sO77Rdc9e', NULL, '2023-01-20 01:13:28', '2023-01-20 01:20:20'); -- -------------------------------------------------------- -- -- Table structure for table `withdraw_accounts` -- CREATE TABLE `withdraw_accounts` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `withdraw_method_id` bigint(20) UNSIGNED NOT NULL, `method_name` varchar(255) NOT NULL, `credentials` 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 `withdraw_accounts` -- INSERT INTO `withdraw_accounts` (`id`, `user_id`, `withdraw_method_id`, `method_name`, `credentials`, `created_at`, `updated_at`) VALUES (1, 1, 3, 'Bitcoin-USD', '{\"Wallet Address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"bc1q0lpntdkz0ys2k5wstrkvlap0w73gtdq8e4ppgk\"},\"Wallet Name\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Bitcoin\"}}', '2023-01-17 10:20:25', '2023-01-17 10:20:25'), (2, 4, 3, 'Bitcoin-USD', '{\"Wallet Address\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"sddddddddddddd\"},\"Wallet Name\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"Bitc\"}}', '2023-01-17 15:03:04', '2023-01-17 15:03:04'), (3, 7, 2, 'Mobile Money-USD', '{\"Mobile Number\":{\"type\":\"text\",\"validation\":\"required\",\"value\":\"8687676556\"}}', '2023-01-17 19:35:13', '2023-01-17 19:35:13'); -- -------------------------------------------------------- -- -- 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 dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `custom_css` -- ALTER TABLE `custom_css` ADD PRIMARY KEY (`id`); -- -- Indexes for table `email_templates` -- ALTER TABLE `email_templates` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email_templates_code_unique` (`code`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `gateways` -- ALTER TABLE `gateways` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `gateways_gateway_code_unique` (`gateway_code`); -- -- Indexes for table `invests` -- ALTER TABLE `invests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kycs` -- ALTER TABLE `kycs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `kycs_name_unique` (`name`); -- -- Indexes for table `labels` -- ALTER TABLE `labels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `landing_contents` -- ALTER TABLE `landing_contents` ADD PRIMARY KEY (`id`); -- -- Indexes for table `landing_pages` -- ALTER TABLE `landing_pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `languages` -- ALTER TABLE `languages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `languages_locale_unique` (`locale`); -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `navigations` -- ALTER TABLE `navigations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `url` (`url`); -- -- Indexes for table `page_settings` -- ALTER TABLE `page_settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `page_settings_key_unique` (`key`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `plugins` -- ALTER TABLE `plugins` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rankings` -- ALTER TABLE `rankings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `rankings_ranking_unique` (`ranking`), ADD UNIQUE KEY `rankings_ranking_name_unique` (`ranking_name`); -- -- Indexes for table `referrals` -- ALTER TABLE `referrals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referral_links` -- ALTER TABLE `referral_links` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `referral_links_referral_program_id_user_id_unique` (`referral_program_id`,`user_id`), ADD KEY `referral_links_code_index` (`code`); -- -- Indexes for table `referral_programs` -- ALTER TABLE `referral_programs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referral_relationships` -- ALTER TABLE `referral_relationships` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referral_targets` -- ALTER TABLE `referral_targets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indexes for table `schedules` -- ALTER TABLE `schedules` ADD PRIMARY KEY (`id`); -- -- Indexes for table `schemas` -- ALTER TABLE `schemas` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `socials` -- ALTER TABLE `socials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `subscriptions_email_unique` (`email`); -- -- Indexes for table `tickets` -- ALTER TABLE `tickets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `transactions_tnx_unique` (`tnx`), ADD KEY `transactions_user_id_index` (`user_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `withdraw_accounts` -- ALTER TABLE `withdraw_accounts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw_methods` -- ALTER TABLE `withdraw_methods` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `gateways` -- ALTER TABLE `gateways` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `withdraw_accounts` -- ALTER TABLE `withdraw_accounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;