-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 23, 2025 at 04:02 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.3.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `hyip`
--
-- --------------------------------------------------------
--
-- Table structure for table `addons`
--
CREATE TABLE `addons` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`app_id` varchar(255) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`current_version` varchar(255) NOT NULL DEFAULT '1',
`is_actived` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`username` varchar(191) DEFAULT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`sct` varchar(191) DEFAULT NULL,
`user_group_id` int(11) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`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;
-- --------------------------------------------------------
--
-- Table structure for table `bill_requests`
--
CREATE TABLE `bill_requests` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`type` varchar(255) NOT NULL,
`bill_type` varchar(255) NOT NULL,
`amount` decimal(8,2) NOT NULL,
`status` int(11) NOT NULL COMMENT '0=pending, 1 = accept , 2 = rejected',
`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 `deposits`
--
CREATE TABLE `deposits` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) NOT NULL,
`gateway_id` bigint(20) NOT NULL,
`amount` varchar(255) DEFAULT NULL,
`charge` varchar(255) DEFAULT NULL,
`usd_amo` varchar(255) DEFAULT NULL,
`btc_amo` varchar(255) DEFAULT NULL,
`btc_wallet` varchar(255) DEFAULT NULL,
`trx` varchar(255) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT 0,
`try` int(11) 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 `deposit_requests`
--
CREATE TABLE `deposit_requests` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) DEFAULT NULL,
`gateway_id` bigint(20) DEFAULT NULL,
`amount` varchar(255) DEFAULT NULL,
`usd_amo` varchar(255) DEFAULT NULL,
`charge` varchar(255) DEFAULT NULL,
`accepted` int(11) NOT NULL DEFAULT 0,
`trx` varchar(255) DEFAULT NULL,
`sent` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`detail` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `email_templates`
--
CREATE TABLE `email_templates` (
`id` bigint(20) UNSIGNED NOT NULL,
`act` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`subj` varchar(255) NOT NULL,
`email_body` text DEFAULT NULL,
`shortcodes` text DEFAULT NULL COMMENT 'object',
`email_status` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `email_templates`
--
INSERT INTO `email_templates` (`id`, `act`, `name`, `subj`, `email_body`, `shortcodes`, `email_status`, `created_at`, `updated_at`) VALUES
(1, 'PASS_RESET_CODE', 'Password Reset', 'Password Reset', 'We have received a request to reset the password for your account on {{time}} .
Requested From IP: {{ip}} using {{browser}} on {{operating_system}} .
Your account recovery code is: {{code}}
If you do not wish to reset your password, please disregard this message.
', ' {\"code\":\"Password Reset Code\",\"ip\":\"IP of User\",\"browser\":\"Browser of User\",\"operating_system\":\"Operating System of User\",\"time\":\"Request Time\"}', 1, '2022-03-25 07:24:04', '2022-03-25 01:28:01'),
(2, 'PASS_RESET_DONE', 'Password Reset Confirmation', 'You have Reset your password', '\n You have successfully reset your password.
You changed from IP: {{ip}} using {{browser}} on {{operating_system}} on {{time}}
If you did not changed that, Please contact with us as soon as possible.
Thanks For join with us.
Please use below code to verify your email address.
Your email verification code is: {{code}}
', '{\"code\":\"Email Verification code\"}', 1, '2022-03-25 07:28:23', '2022-03-25 07:28:23'),
(4, '2FA_ENABLE', 'Google Two Factor - Enable', 'Google Two Factor Authentication is now Enabled for Your Account', 'You just enabled Google Two Factor Authentication for Your Account.
Enabled at {{time}} From IP: {{ip}} using {{browser}} on {{operating_system}} .
', '{\"ip\":\"IP of User\",\"browser\":\"Browser of User\",\"operating_system\":\"Operating System of User\",\"time\":\"Request Time\"}', 1, '2022-03-25 07:30:32', '2022-03-25 07:30:32'),
(5, '2FA_DISABLE', 'Google Two Factor Disable', 'Google Two Factor Authentication is now Disabled for Your Account', 'You just Disabled Google Two Factor Authentication for Your Account.
Disabled at {{time}} From IP: {{ip}} using {{browser}} on {{operating_system}} .
', '{\"ip\":\"IP of User\",\"browser\":\"Browser of User\",\"operating_system\":\"Operating System of User\",\"time\":\"Request Time\"}', 1, '2022-03-25 07:30:32', '2022-03-25 07:30:32'),
(6, 'DEPOSIT_COMPLETE', 'Automated Deposit - Successful', 'Deposit Completed Successfully', 'Your deposit of {{amount}} {{currency}} is via {{method_name}} has been completed Successfully.
Details of your Deposit :
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
Payable : {{method_amount}} {{method_currency}}
Paid via : {{method_name}}
Transaction Number : {{trx}}
Your current Balance is {{post_balance}} {{currency}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"method_name\":\"Deposit Method Name\"}', 1, '2022-03-25 07:35:33', '2022-03-25 07:35:33'),
(7, 'DEPOSIT_REQUEST', 'Manual Deposit - User Requested', 'Deposit Request Submitted Successfully', 'Your deposit request of {{amount}} {{currency}} is via {{method_name}} submitted successfully .
Details of your Deposit :
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
Payable : {{method_amount}} {{method_currency}}
Pay via : {{method_name}}
Transaction Number : {{trx}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Deposit Method Name\",\"method_currency\":\"Deposit Method Currency\"}', 1, '2022-03-25 07:35:33', '2022-03-25 07:35:33'),
(8, 'WITHDRAW_REQUEST', 'Manual Withdraw - User Requested', 'Withdraw Request Submitted Successfully', 'Your withdraw request of {{amount}} {{currency}} via {{method_name}} has been submitted Successfully, Please wait for processing days.
Details of your withdraw:
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
You will get: {{method_amount}} {{method_currency}}
Via : {{method_name}}
Transaction Number : {{trx}}
This may take {{delay}} to process the payment.
Your current Balance is {{post_balance}} {{currency}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Withdraw Method Name\",\"method_amount\":\"Withdraw Method Amount After Conversion\",\"method_currency\":\"Withdraw Method Currency\",\"post_balance\":\"Your current Balance\",\"delay\":\"Delay time for processing\"}', 1, '2022-10-22 07:35:33', '2022-10-26 10:03:24'),
(9, 'WITHDRAW_REJECT', 'Withdraw - Admin Rejected', 'Withdraw Request has been Rejected and your money is refunded to your account', 'Your withdraw request of {{amount}} {{currency}} via {{method_name}} has been Rejected.
Details of your withdraw:
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
You should get: {{method_amount}} {{method_currency}}
Via : {{method_name}}
Transaction Number : {{trx}}
----
{{amount}} {{currency}} has been refunded to your account and your current Balance is {{post_balance}} {{currency}}
-----
Details of Rejection :
{{admin_details}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Withdraw Method Name\",\"method_currency\":\"Withdraw Method Currency\",\"method_message\":\"Withdraw Payment Message\"}', 1, '2022-10-25 07:35:33', '2022-10-25 07:35:33'),
(10, 'WITHDRAW_APPROVE', 'Withdraw - Admin Approved', 'Withdraw Request has been Processed and your money is sent', 'Your withdraw request of {{amount}} {{currency}} via {{method_name}} has been Processed Successfully.
Details of your withdraw:
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
You will get: {{method_amount}} {{method_currency}}
Via : {{method_name}}
Transaction Number : {{trx}}
-----
Details of Processed Payment :
{{method_message}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Withdraw Method Name\",\"method_currency\":\"Withdraw Method Currency\",\"method_message\":\"Withdraw Payment Message\"}', 1, '2022-10-25 07:35:33', '2022-10-25 07:35:33'),
(11, 'DEPOSIT_APPROVE', 'Manual Deposit - Admin Approved', 'Your Deposit is Approved', 'Your deposit request of {{amount}} {{currency}} is via {{method_name}} is Approved .
Details of your Deposit :
Amount : {{amount}} {{currency}}
Charge: {{charge}} {{currency}}
Conversion Rate : 1 {{currency}} = {{rate}} {{method_currency}}
Payable : {{method_amount}} {{method_currency}}
Paid via : {{method_name}}
Transaction Number : {{trx}}
Your current Balance is {{post_balance}} {{currency}}
', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Deposit Method Name\",\"method_currency\":\"Deposit Method Currency\"}', 1, '2022-10-25 07:35:33', '2022-10-25 07:35:33'),
(12, 'DEPOSIT_REJECT', 'Manual Deposit - Admin Rejected', 'Your Deposit Request is Rejected', 'Your deposit request of {{amount}} {{currency}} is via {{method_name}} has been rejected.
Transaction Number was : {{trx}}
if you have any query, feel free to contact us.
\n\n\n\n{{method_message}}', '{\"trx\":\"Transaction Number\",\"amount\":\"Request Amount By user\",\"charge\":\"Gateway Charge\",\"currency\":\"Site Currency\",\"rate\":\"Conversion Rate\",\"method_name\":\"Deposit Method Name\",\"method_currency\":\"Deposit Method Currency\"}', 1, '2022-10-25 07:35:33', '2022-10-25 07:35:33'),
(13, 'ADMIN_SUPPORT_REPLY', 'Support Ticket Reply', 'Reply Support Ticket', 'A member from our support team has replied to the following ticket:
[Ticket#{{ticket_id}}] {{ticket_subject}}
Click here to reply: {{link}}
----------------------------------------------
Here is the reply :
{{reply}}
', '{\"ticket_id\":\"Support Ticket ID\", \"ticket_subject\":\"Subject Of Support Ticket\", \"reply\":\"Reply from Staff/Admin\",\"link\":\"Ticket URL For reply\"}', 1, '2022-10-25 07:01:41', '2022-10-25 07:01:41'),
(14, 'REFERRAL_COMMISSION', 'Referral Commission', 'You got referral commission', 'Congratulations, you got {{amount}} {{currency}} as referral commission.
Details :
Transaction Number : {{trx}}
{{level}}
Your Current Balance is : {{post_balance}} {{currency}}', '{\"amount\":\"Commission Amount\",\"post_balance\":\"Users Balance After this operation\",\"level\":\"Level\",\"currency\":\"Site Currency\"}', 1, '2022-10-25 07:01:41', '2022-10-25 07:01:41'),
(15, 'BAL_ADD', 'Balance Add by Admin', 'Your Account has been Credited', '{{amount}} {{currency}} has been added to your account .
Transaction Number : {{trx}}
Your Current Balance is : {{post_balance}} {{currency}} ', '{\"amount\":\"Request Amount By Admin\",\"currency\":\"Site Currency\", \"post_balance\":\"Users Balance After this operation\",\"post_message\":\"Balance add Message\"}', 1, '2022-10-25 07:04:44', '2022-10-25 07:04:44'),
(16, 'BAL_SUB', 'Balance Subtracted by Admin', 'Your Account has been Debited', '{{amount}} {{currency}} has been subtracted from your account .
Transaction Number : {{trx}}
Your Current Balance is : {{post_balance}} {{currency}}', '{\"amount\":\"Request Amount By Admin\",\"currency\":\"Site Currency\", \"post_balance\":\"Users Balance After this operation\",\"post_message\":\"Balance Deduct Message\"}', 1, '2022-10-25 07:07:08', '2022-10-25 07:07:08'),
(17, 'KYC_REJECTED', 'Kyc Rejected', 'Your Kyc Request is Rejected', 'Your {{kyc_type}} has been rejected', '{\"kyc_type\":\"kyc type\"}', 1, '2023-03-08 08:32:14', '2023-03-08 08:32:14'),
(18, 'KYC_APPROVED', 'KYC APPROVED', 'Your Kyc Request is Approved', 'Your {{kyc_type}} has been apporved', '{\"kyc_type\":\"kyc type\"}', 1, '2023-03-08 08:36:39', '2023-03-08 08:36:39');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED 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 `faqs`
--
CREATE TABLE `faqs` (
`id` bigint(20) UNSIGNED NOT NULL,
`question` varchar(255) NOT NULL,
`answer` 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 `faqs`
--
INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(1, 'What is a HYIP?', 'There are many variations of passages Lorem Ipsum available,but the majority have suffered alteration.There are many variations of passages Lorem Ipsum available design here', '2023-05-23 23:02:11', '2023-05-23 23:12:02'),
(2, 'Is investing in a HYIP safe', 'There are many variations of passages Lorem Ipsum available,but the majority have suffered alteration.There are many variations of passages Lorem Ipsum available design here', '2023-05-23 23:12:18', '2023-05-23 23:12:18');
-- --------------------------------------------------------
--
-- Table structure for table `generals`
--
CREATE TABLE `generals` (
`id` bigint(20) UNSIGNED NOT NULL,
`web_name` varchar(50) DEFAULT 'Banking E-Wallet',
`currency` varchar(50) DEFAULT 'USD',
`cp_currency` varchar(191) DEFAULT NULL,
`cp_currency_rt` varchar(191) NOT NULL DEFAULT '0',
`ico` tinyint(1) NOT NULL DEFAULT 0,
`g_captcha` tinyint(1) NOT NULL DEFAULT 0,
`captcha_key_one` varchar(191) DEFAULT NULL,
`captcha_key_two` varchar(191) DEFAULT NULL,
`bal_trans_coin_fixed_charge` varchar(191) DEFAULT NULL,
`bal_trans_coin_percentage_charge` varchar(191) DEFAULT NULL,
`emailver` int(11) DEFAULT 0,
`date_wise_action` varchar(191) DEFAULT NULL,
`social_api` tinyint(1) NOT NULL DEFAULT 0,
`fb_client_id` varchar(191) DEFAULT NULL,
`fb_client_secret` varchar(191) DEFAULT NULL,
`google_client_id` varchar(191) DEFAULT NULL,
`google_client_secret` varchar(191) DEFAULT NULL,
`fb_callback_url` varchar(191) NOT NULL,
`google_callback_url` varchar(191) NOT NULL,
`color_code` varchar(50) DEFAULT '#fff',
`contact_address` varchar(255) DEFAULT 'Berlin,Germany',
`contact_email` varchar(255) DEFAULT 'support@example.com',
`contact_phone` varchar(255) DEFAULT '0123654789',
`copyright_text` varchar(255) DEFAULT 'All Rights Reserved',
`banner_header` varchar(255) DEFAULT NULL,
`banner_body` varchar(255) DEFAULT NULL,
`banner_footer` varchar(255) DEFAULT NULL,
`about_head` varchar(255) DEFAULT NULL,
`about_title` varchar(255) DEFAULT NULL,
`about_body` longtext DEFAULT NULL,
`about_video_url` varchar(255) DEFAULT NULL,
`single_about1_icon` varchar(255) DEFAULT NULL,
`single_about1_title` varchar(255) DEFAULT NULL,
`single_about1_description` longtext DEFAULT NULL,
`single_about2_icon` varchar(255) DEFAULT NULL,
`single_about2_title` varchar(255) DEFAULT NULL,
`single_about2_description` longtext DEFAULT NULL,
`invest_head` varchar(255) DEFAULT NULL,
`invest_title` varchar(255) DEFAULT NULL,
`invest_description` text DEFAULT NULL,
`investor_head` varchar(255) DEFAULT NULL,
`investor_title` varchar(255) DEFAULT NULL,
`investor_description` text DEFAULT NULL,
`footer_text` text DEFAULT NULL,
`email_template` text DEFAULT NULL,
`sms_api` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`esender` varchar(255) DEFAULT NULL,
`comment_script` text DEFAULT NULL,
`livechat_script` text DEFAULT NULL,
`bal_trans_fixed_charge` varchar(255) NOT NULL DEFAULT '0',
`bal_trans_percentage_charge` varchar(255) NOT NULL DEFAULT '0',
`email_verification` tinyint(1) NOT NULL DEFAULT 0,
`template_sel` int(11) DEFAULT 1,
`identity_verification` tinyint(1) NOT NULL DEFAULT 0,
`paginate` int(11) DEFAULT NULL,
`min_transfer` decimal(11,2) DEFAULT 0.00,
`max_transfer` decimal(11,2) DEFAULT 0.00,
`bonus_amount` int(11) DEFAULT 10,
`joining_bonus` tinyint(1) NOT NULL,
`time_zone` varchar(255) DEFAULT NULL,
`sender_email` varchar(255) DEFAULT NULL,
`sender_email_name` varchar(255) DEFAULT NULL,
`email_description` longtext DEFAULT NULL,
`email_configuration` text DEFAULT NULL,
`push_notification` tinyint(1) DEFAULT NULL,
`theme` varchar(255) DEFAULT 'deepblue',
`seo_title` varchar(255) DEFAULT NULL,
`seo_details` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `generals`
--
INSERT INTO `generals` (`id`, `web_name`, `currency`, `cp_currency`, `cp_currency_rt`, `ico`, `g_captcha`, `captcha_key_one`, `captcha_key_two`, `bal_trans_coin_fixed_charge`, `bal_trans_coin_percentage_charge`, `emailver`, `date_wise_action`, `social_api`, `fb_client_id`, `fb_client_secret`, `google_client_id`, `google_client_secret`, `fb_callback_url`, `google_callback_url`, `color_code`, `contact_address`, `contact_email`, `contact_phone`, `copyright_text`, `banner_header`, `banner_body`, `banner_footer`, `about_head`, `about_title`, `about_body`, `about_video_url`, `single_about1_icon`, `single_about1_title`, `single_about1_description`, `single_about2_icon`, `single_about2_title`, `single_about2_description`, `invest_head`, `invest_title`, `invest_description`, `investor_head`, `investor_title`, `investor_description`, `footer_text`, `email_template`, `sms_api`, `created_at`, `updated_at`, `esender`, `comment_script`, `livechat_script`, `bal_trans_fixed_charge`, `bal_trans_percentage_charge`, `email_verification`, `template_sel`, `identity_verification`, `paginate`, `min_transfer`, `max_transfer`, `bonus_amount`, `joining_bonus`, `time_zone`, `sender_email`, `sender_email_name`, `email_description`, `email_configuration`, `push_notification`, `theme`, `seo_title`, `seo_details`) VALUES
(1, 'InvestPro', 'USD', 'BTC', '0.000019', 1, 0, '6LcLDO4cAAAAAC7U1skaseJ1dXwMZBVZTtChNl8_', '6LcLDO4cAAAAAJn4imznvyWWd5mBKEUgjFfX4qft', '0', '0', 0, '[\"Sat\",\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\"]', 1, '184580323757571', '735879785fce248cd030e7902821221c', '189687505284-t7ihvmsf16ulh181bml28u6v4smlb8uv.apps.googleusercontent.com', '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', 'https://investpro.wowtheme7/login/facebook/callback', 'https://investpro.wowtheme7/login/google/callback', 'f7931a', 'Berlin,Germany', 'support@example.com', '0123654789', 'All Rights Reserved', 'We have 24/7 supported team', 'Best Invest Company Since 2024', 'Investpro have much planned for the future, working with great clients and continued blockchain investment. If you\'d like to invest our company, then we\'d also love to hear from you.', 'About us', 'About Investpro', 'Investpro is plastered cheeky loo what a plonker some dodgy chav a barney wellies, gutted mate quaint the little rotter pardon.', 'https://www.youtube.com/watch?v=_51KXfwcPMs', NULL, 'Licensed & Certified', 'The Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.', NULL, 'Saving & Investments', 'Financial institutions offer a number of different savings options. Investing is buying assets such as stocks, bonds, mutual funds or real estate with the expectation.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.\r\n\r\nThe Certified Licensing Professional certification is for individuals working in the fields of licensing, business development and commercialization of intellectual.', 'Investon Price', 'Grab Our Mega Package', 'Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many', 'Top Investors', 'Meet Our Investors', 'Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web', 'It is a long established fact that a reader will be distracted by the', 'Hi {{name}}, {{message}} , Thank you', NULL, NULL, '2024-10-01 12:23:06', 'do-no-reply@example.com', '\r\n \r\n ', '', '2', '2', 0, 0, 0, 15, 10.00, 100.00, 10, 0, NULL, 'investpro@wowtheme7.com', 'Investpro', 'Hi {{name}}, {{message}} , Thank you', '{\"name\":\"smtp\",\"smtp_host\":\"mail.wowtheme7.com\",\"smtp_port\":\"587\",\"smtp_encryption\":\"tls\",\"smtp_username\":\"investpro@wowtheme7.com\",\"smtp_password\":\"aAXkh!(^XknU\"}', NULL, 'mediumpurple', 'asdasd', 'asdasdasd');
-- --------------------------------------------------------
--
-- Table structure for table `identify_forms`
--
CREATE TABLE `identify_forms` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`services_form` text DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `identify_forms`
--
INSERT INTO `identify_forms` (`id`, `name`, `slug`, `services_form`, `status`, `created_at`, `updated_at`) VALUES
(1, 'National ID', 'national-id', '{\"FrontPage\":{\"field_name\":\"FrontPage\",\"field_level\":\"Front Page\",\"type\":\"file\",\"field_length\":\"500\",\"length_type\":\"max\",\"validation\":\"required\"},\"RearPage\":{\"field_name\":\"RearPage\",\"field_level\":\"Rear Page\",\"type\":\"file\",\"field_length\":\"500\",\"length_type\":\"max\",\"validation\":\"required\"},\"NidNumber\":{\"field_name\":\"NidNumber\",\"field_level\":\"Nid Number\",\"type\":\"text\",\"field_length\":\"10\",\"length_type\":\"max\",\"validation\":\"required\"},\"Address\":{\"field_name\":\"Address\",\"field_level\":\"Address\",\"type\":\"text\",\"field_length\":\"2\",\"length_type\":\"max\",\"validation\":\"required\"}}', 1, '2023-02-26 22:40:02', '2024-04-25 01:08:30'),
(2, 'Driving License', 'driving-license', '{\"Address\":{\"field_name\":\"Address\",\"field_level\":\"Address\",\"type\":\"text\",\"field_length\":\"2\",\"length_type\":\"max\",\"validation\":\"required\"}}', 0, '2023-02-27 21:28:47', '2024-04-25 01:09:13'),
(3, 'Passport', 'passport', '{\"FrontPage\":{\"field_name\":\"FrontPage\",\"field_level\":\"Front Page\",\"type\":\"text\",\"field_length\":\"25\",\"length_type\":\"max\",\"validation\":\"required\"},\"PassportImage\":{\"field_name\":\"PassportImage\",\"field_level\":\"Passport Image\",\"type\":\"file\",\"field_length\":\"1025\",\"length_type\":\"max\",\"validation\":\"required\"}}', 1, '2023-02-27 21:29:33', '2023-02-27 21:29:33');
-- --------------------------------------------------------
--
-- Table structure for table `investors`
--
CREATE TABLE `investors` (
`id` bigint(20) UNSIGNED NOT NULL,
`image` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`designation` varchar(255) NOT NULL,
`fb_link` varchar(255) DEFAULT NULL,
`twitter_link` varchar(255) DEFAULT NULL,
`linkedin_link` varchar(255) 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 `investors`
--
INSERT INTO `investors` (`id`, `image`, `name`, `designation`, `fb_link`, `twitter_link`, `linkedin_link`, `created_at`, `updated_at`) VALUES
(2, '5ec1654a23285186.png', 'Bradon Crithia', 'Founder', 'https://www.facebook.com/', 'https://twitter.com/', 'https://www.linkedin.com/', '2020-05-17 10:24:42', '2020-06-09 14:09:27'),
(4, '5ec16567a178c381.png', 'Katrin Alex', 'Top Investor', 'https://www.facebook.com/', 'https://twitter.com/', 'https://www.linkedin.com/', '2020-05-17 10:25:11', '2020-06-09 15:47:33'),
(5, '5ec16573d1cc5850.png', 'Prema Boura', 'Affilator', 'https://www.facebook.com/', 'https://twitter.com/', 'https://www.linkedin.com/', '2020-05-17 10:25:23', '2020-06-09 15:48:20'),
(6, '5edf7789aa78e958.png', 'Suvro Sen', 'CEO', 'https://www.facebook.com/', 'https://twitter.com/', 'https://www.linkedin.com/', '2020-06-09 15:50:33', '2020-06-09 15:50:33');
-- --------------------------------------------------------
--
-- Table structure for table `invest_logs`
--
CREATE TABLE `invest_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) NOT NULL,
`plan_name` varchar(255) NOT NULL,
`get_percent` char(4) NOT NULL COMMENT '% get every ROI',
`get_action` int(11) DEFAULT NULL COMMENT 'plan wise action number',
`get_period` int(11) NOT NULL COMMENT 'plan wise period:1=Hourly,24=Daily,168=Weekly,720=Monthly,2880=Quarterly,8640=Yearly',
`took_action` int(11) NOT NULL DEFAULT 0 COMMENT 'already taken action',
`invest_amount` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL COMMENT '0 = Running, 1 = complete',
`next_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`capital_back` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `kycs`
--
CREATE TABLE `kycs` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` int(11) DEFAULT NULL,
`kyc_type` varchar(255) DEFAULT NULL,
`details` text DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=> Approved, 2 => Reject',
`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`, `user_id`, `kyc_type`, `details`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'national-id', '{\"NidNumber\":{\"field_name\":\"sfsdfsdf\",\"type\":\"text\"},\"Address\":{\"field_name\":\"sdfsdfdsf\",\"type\":\"textarea\"},\"FrontPage\":{\"field_name\":\"66292d4e1808e1713974606.png\",\"type\":\"file\"},\"RearPage\":{\"field_name\":\"66292d4e20f571713974606.png\",\"type\":\"file\"}}', 1, '2024-04-24 10:03:26', '2024-04-24 10:03:38');
-- --------------------------------------------------------
--
-- Table structure for table `languages`
--
CREATE TABLE `languages` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`code` 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 `manage_times`
--
CREATE TABLE `manage_times` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) DEFAULT NULL,
`time` varchar(255) DEFAULT NULL COMMENT 'Hourly',
`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 `manage_times`
--
INSERT INTO `manage_times` (`id`, `name`, `time`, `created_at`, `updated_at`) VALUES
(1, 'Hour', '1', '2024-05-04 07:38:10', '2024-05-22 18:40:49'),
(2, 'Day', '24', '2024-05-22 18:40:22', '2024-05-22 18:40:22'),
(3, 'Month', '720', '2024-05-23 11:38:16', '2024-05-23 11:38:16'),
(4, 'Week', '168', '2024-05-23 11:38:29', '2024-05-23 11:38:29'),
(5, 'Year', '8760', '2024-05-23 11:38:41', '2024-05-23 11:38:41');
-- --------------------------------------------------------
--
-- Table structure for table `manage_users`
--
CREATE TABLE `manage_users` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) DEFAULT NULL,
`permission` longtext DEFAULT 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 `manage_users`
--
INSERT INTO `manage_users` (`id`, `name`, `permission`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', '[{\"name\":\"referral\",\"label\":\"Manage Referral\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"user_management\",\"label\":\"User Management\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"active_user\",\"label\":\"Active User\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"ban_user\",\"label\":\"Deactive User\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"pending_kyc\",\"label\":\"Pending KYC\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"log_kyc\",\"label\":\"KYC Log\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"gateway_management\",\"label\":\"Gateway\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"admin-manual-gateway\",\"label\":\"Manual Gateway\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"deposit_pending\",\"label\":\"Pending Deposit\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"deposit_accept\",\"label\":\"Accept Deposit\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"deposit_reject\",\"label\":\"Reject Deposit\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"deposit_log\",\"label\":\"Deposit Log\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"withdraw_method\",\"label\":\"Withdraw Management\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"withdraw_pending\",\"label\":\"Pending Withdraw\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"withdraw_log\",\"label\":\"Withdraw Log\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"schedule\",\"label\":\"Schedule\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"email_settings\",\"label\":\"Email Settings\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"identity_form\",\"label\":\"Identity Form\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"transaction\",\"label\":\"Transaction\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"banner\",\"label\":\"Banner\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"logo\",\"label\":\"Logo & Favicon\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"news\",\"label\":\"News\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"plan\",\"label\":\"Plan\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"menu\",\"label\":\"Menu\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"view_pass\",\"label\":\"View Password\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"web_interface\",\"label\":\"Web Interface\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"manage_user\",\"label\":\"Manage User\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"ico\",\"label\":\"Ico Settings\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"google_tools\",\"label\":\"Google Tools\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"support\",\"label\":\"Support\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"settings\",\"label\":\"Settings\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"theme\",\"label\":\"Manage Theme\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"language\",\"label\":\"Language Manage\",\"group\":\"Post Management\",\"value\":true},{\"name\":\"ranking\",\"label\":\"Ranking Manage\",\"group\":\"Post Management\",\"value\":true}]', 1, 1, '2021-09-04 05:41:28', '2024-04-24 02:03:44');
-- --------------------------------------------------------
--
-- Table structure for table `menus`
--
CREATE TABLE `menus` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`slug` varchar(255) DEFAULT NULL,
`seo_title` varchar(255) NOT NULL,
`seo_details` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `menus`
--
INSERT INTO `menus` (`id`, `title`, `description`, `created_at`, `updated_at`, `slug`, `seo_title`, `seo_details`) VALUES
(2, 'About', 'Bankzone Investment Fund :\r\nBankzone is the best choice. An investment fund is a supply of capital belonging to numerous investors used to collectively purchase securities while each investor retains ownership and control of his own shares. An investment fund provides a broader selection of investment opportunities, greater management expertise, and lower investment fees than investors might be able to obtain on their own. Types of investment funds include mutual funds, exchange-traded funds, money market funds, and hedge funds.\r\n\r\n\r\nBREAKING DOWN Investment Fund:\r\nWith investment funds, individual investors do not make decisions about how a fund\'s assets should be invested. They simply choose a fund based on its goals, risk, fees and other factors. A fund manager oversees the fund and decides which securities it should hold, in what quantities and when the securities should be bought and sold. An investment fund can be broad-based, such as an index fund that tracks the S&P 500, or it can be tightly focused, such as an ETF that invests only in small technology stocks.\r\n\r\n\r\nWhile investment funds in various forms have been around for many years, the Massachusetts Investors Trust Fund is generally considered the first open-end mutual fund in the industry. The fund, investing in a mix of large-cap stocks, launched in 1924.\r\n\r\nOpen-end vs. Closed-end\r\nThe majority of investment fund assets belong to open-end mutual funds. These funds issue new shares as investors add money to the pool, and retire shares as investors redeem. These funds are typically priced just once at the end of the trading day.\r\n\r\nClosed-end funds trade more similarly to stocks than open-end funds. Closed-end funds are managed investment funds that issue a fixed number of shares, and trade on an exchange. While a net asset value (NAV) for the fund is calculated, the fund trades based on investor supply and demand. Therefore, a closed-end fund may trade at a premium or a discount to its NAV.\r\n\r\nEmergence of ETFs\r\nExchange-traded funds (ETFs) emerged as an alternative to mutual funds for traders who wanted more flexibility with their investment funds. Similar to closed-end funds, ETFs trade on exchanges, and are priced and available for trading throughout the business day. Many mutual funds, such as the Vanguard 500 Index Fund, have ETF counterparts. The Vanguard S&P 500 ETF is essentially the same fund, but came to be bought and sold intraday. ETFs frequently have the additional advantage of slightly lower expense ratios than their mutual fund equal.\r\n\r\nThe first ETF, the SPDR S&P 500 ETF, debuted in the United States in 1993. By the end of 2018, ETFs had roughly $3.4 trillion in assets under management.\r\n\r\nInvestment Funds: Hedge Funds\r\nA hedge fund is an investment type that is distinct from mutual funds or ETFs. This fund is an actively managed fund made available to accredited investors. A hedge fund faces less federal regulation and is therefore able to invest in a variety of asset classes using a wide range of strategies. For example, a hedge find might pairs stocks it wants to short (bet will decrease) with stocks it expects to go up in order to decrease the potential for loss.\r\n\r\nHedge funds also tend to invest in riskier assets in addition to stocks, bonds, ETFs, commodities and alternative assets. These include derivatives such as futures and options that may also be purchased with leverage, or borrowed money. \r\n\r\nCompete Risk Free with $100,000 in Virtual Cash\r\nPut your trading skills to the test with our FREE Stock Simulator. Compete with thousands of Investopedia traders and trade your way to the top! Submit trades in a virtual environment before you start risking your own money. Practice trading strategies so that when you\'re ready to enter the real market, you\'ve had the practice you need. Try our Stock Simulator today >>\r\n\r\nRelated Terms\r\nDefinition of an Equity Unit Investment Trust (EUIT)\r\nAn equity unit investment trust is a publicly offered, pooled trust fund managed by an investment company. \r\n\r\nShould You Be Open to a Closed-End Fund?\r\nA closed-end fund is created when an investment company raises money through an IPO and then trades the fund shares on the public market like a stock. After its IPO, no additional shares are issued by the fund\'s parent investment company.\r\n\r\nFamily of Funds Definition\r\nA family of funds includes all of the funds managed by one investment company. \r\n\r\nExchange Traded Fund – ETFs\r\nAn exchange traded fund (ETF) is a basket of securities that tracks an underlying index. ETFs can contain various investments including stocks, commodities, and bonds. \r\n\r\nNew Fund Offer (NFO) Definition\r\nA new fund offer is the first subscription offering for any new fund offered by an investment company. \r\n\r\nOpen-End Fund\r\nAn open-end fund is a mutual fund that can issue unlimited new shares, priced daily on their net asset value. The fund sponsor sells shares directly to investors and buys them back as well.', '2020-05-18 02:37:00', '2024-04-24 01:43:10', 'about', 'about', 'sdfdsfsdf'),
(3, 'Service', 'Financial institutions and professional financial advisers offer a host of investment services that are focused on helping their clients meet predetermined financial goals. These investment services may be customized to a client’s income levels, circumstances and objectives and focus on wealth creation and protection. Investment services include making, organizing and managing investments and may also encompass financial planning, accounting, life insurance and tax planning.\r\n\r\n \r\nTypes of Investment Services\r\nPrior to the late 1990s, US commercial banks were forbidden by law to offer investment services. The Gramm-Leach-Bliley Act of 1999 made it legal for a bank to offer both commercial and investment services. Over the years, the distinction between commercial and investment banks has blurred. The types of investment services offered by banks include:\r\n\r\nMoney management: The first step for any investor is to ascertain the amount of money he has at his disposal for investing and the various financial options available to maximize returns and tax rebates and minimize risks.\r\n \r\n\r\nPortfolio management services: These services are aimed at investors achieving the right mix of investments, such as stocks, bonds, commodities, derivatives and CDs, depending upon their financial goals and risk appetite. Portfolio management encompasses making a choice between equity and debt, domestic and international investments as well as growth and safety.\r\n \r\n\r\nRetirement planning services: Once the retirement goals have been laid down, appropriate investments need to be made into pension plans, 401(k) plans and profit sharing plans. One may also need to invest into the financial and money markets to ensure a steady stream of income post retirement.\r\n \r\n\r\nCollective investment portfolio management: Banks offer advice on collective investments, such as mutual funds, ETFs and managed funds. One may also need professional advice for investing in hedge funds. Such funds hedge their risks via methods like short selling.\r\n \r\n\r\nBrokerage services: Investors need brokers to trade in bonds, stocks, foreign currency and derivatives. The brokerage services offered by banks are considered more reliable and are preferred to those offered by individual brokers.\r\n \r\n\r\nApart from financial goals, investors may have other priorities that financial institutions providing investment services can take into account. Such priorities may include socially responsible investing, green investing and sustainable investing.', '2020-05-18 02:37:06', '2024-04-24 01:38:07', 'service', 'asdsad', 'asdasdasd');
-- --------------------------------------------------------
--
-- 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, '2020_05_08_051020_create_admins_table', 1),
(9, '2020_05_08_062218_create_generals_table', 2),
(10, '2020_05_15_181205_create_work_areas_table', 3),
(11, '2020_05_17_152754_create_services_table', 4),
(12, '2020_05_17_155345_create_investors_table', 5),
(13, '2020_05_18_062629_create_partners_table', 6),
(14, '2020_05_18_065907_create_news_table', 7),
(15, '2020_05_18_075332_create_socials_table', 8),
(16, '2020_05_18_082957_create_menus_table', 9),
(19, '2020_05_27_165523_create_plans_table', 10),
(20, '2020_05_29_194526_create_invest_logs_table', 10),
(21, '2020_05_29_201328_create_transactions_table', 11),
(25, '2020_05_30_180013_create_deposits_table', 12),
(26, '2020_05_30_181943_create_gateways_table', 12),
(27, '2020_05_30_190242_create_trxes_table', 12),
(28, '2020_06_01_152124_create_deposit_requests_table', 13),
(29, '2020_06_01_195520_add_column_to_generals', 14),
(30, '2020_06_02_115734_create_withdraw_methods_table', 15),
(31, '2020_06_02_120651_create_withdraw_logs_table', 16),
(32, '2020_06_02_193551_add_column_to_users', 17),
(33, '2020_08_21_125824_create_payment_gatways_table', 18),
(37, '2020_09_23_120617_add_column_ref_id_to_users', 19),
(38, '2021_01_08_174023_create_languages_table', 20),
(39, '2021_10_07_063809_create_supports_table', 21),
(40, '2021_10_07_063834_create_support_comments_table', 21),
(41, '2021_10_23_061632_create_date_wise_crons_table', 22),
(42, '2021_11_13_103742_create_sliders_table', 23),
(43, '2023_01_22_130714_add_capital_back_status_to_plans_table', 24),
(44, '2023_02_07_033912_create_identify_forms_table', 24),
(45, '2023_02_07_034343_add_identity_verification_to_generals_table', 24),
(46, '2023_02_13_033450_create_manage_times_table', 24),
(47, '2023_02_13_033807_add_paginate_to_generals_table', 24),
(48, '2019_12_14_000001_create_personal_access_tokens_table', 25),
(49, '2023_02_16_055804_add_add_add_address_verification_to_generals_table', 26),
(50, '2023_02_22_095328_create_email_templates_table', 27),
(51, '2023_02_23_054421_add_capital_back_to_invest_logs_table', 28),
(52, '2023_02_27_080941_add_email_configuration_to_generals_table', 29),
(53, '2023_03_05_105939_create_kycs_table', 30),
(54, '2023_03_06_102055_create_notifications_table', 31),
(55, '2023_03_06_110104_add_push_notification_to_generals_table', 32),
(56, '2023_03_07_031919_add_user_id_to_notifications_table', 33),
(57, '2023_03_08_122532_add_identity_verify_to_users_table', 34),
(58, '2023_03_08_144516_drop_address_verify_from_users_table', 35),
(59, '2023_03_08_144747_drop_address_verification_from_generals_table', 36),
(60, '2023_05_16_071317_add_theme_to_generals_table', 37),
(61, '2023_05_24_044907_create_faqs_table', 38),
(62, '2023_06_12_031001_add_slug_to_menus_table', 39),
(63, '2023_06_12_033505_drop_slug_from_menus_table', 40),
(64, '2023_06_12_035323_add_slug_to_menus_table', 41),
(65, '2023_10_06_081716_add_field_options_to_payment_gatways_table', 42),
(66, '2023_10_06_105449_add_field_options_to_withdraw_methods_table', 43),
(67, '2023_10_09_063824_add_details_to_deposit_requests_table', 44),
(68, '2023_11_24_091940_create_sliders_table', 45),
(69, '2024_04_24_080453_create_rankings_table', 46);
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`id` bigint(20) UNSIGNED NOT NULL,
`image` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` 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 `news`
--
INSERT INTO `news` (`id`, `image`, `title`, `description`, `created_at`, `updated_at`) VALUES
(6, '64881588acdec183.png', 'Grab Our Mega Package For You', 'Create an account and get 50$ free on MEGA\'s end-to-end encrypted cloud collaboration .Subject to your participation in our achievements program.\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.', '2023-06-13 01:06:48', '2023-06-13 01:06:48'),
(7, '648815a190aad970.png', 'How To Earn Money From Investment', 'Bank fixed deposits (FD) A bank fixed deposit (FD) is a popular choice for investing owing to its assured return and the safety involved.. 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\r\n\r\nContrary 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. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.', '2023-06-13 01:07:13', '2023-06-13 01:07:13'),
(8, '648815c168766599.png', 'How To Reinvestment Earn Money', 'Reinvesting in your company is using a percentage of your company\'s profits to invest in your company all over again. Instead of using the capital money, you use profits. This is a wise business move because it will keep your company running. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.\r\n\r\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.\r\n\r\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.\r\n\r\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2023-06-13 01:07:45', '2023-06-13 01:07:45');
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`read_status` tinyint(1) NOT NULL DEFAULT 0,
`click_url` text 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 `partners`
--
CREATE TABLE `partners` (
`id` bigint(20) UNSIGNED NOT NULL,
`image` 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 `partners`
--
INSERT INTO `partners` (`id`, `image`, `created_at`, `updated_at`) VALUES
(1, '5ee1102971ba7577.png', '2020-05-18 00:43:49', '2020-06-10 20:54:01'),
(4, '5ee11046a6513432.png', '2020-05-18 00:51:52', '2020-06-10 20:54:30'),
(5, '5ee111bab3ed8461.png', '2020-06-09 16:06:27', '2020-06-10 21:00:42'),
(6, '5ee111c82b485950.png', '2020-06-10 21:00:56', '2020-06-10 21:00:56');
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(50) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0,
`token` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `password_resets`
--
INSERT INTO `password_resets` (`email`, `status`, `token`, `created_at`) VALUES
('user@user.com', 0, 'm6csmkQpwfv4UQLB3p48BspaRpi2mj', '2024-05-20 20:01:50'),
('user@user.com', 0, 'Uizr3oWAH6T1Mj8s66gzZfT4gaWXDs', '2024-05-20 20:02:10');
-- --------------------------------------------------------
--
-- Table structure for table `payment_gatways`
--
CREATE TABLE `payment_gatways` (
`id` bigint(20) UNSIGNED NOT NULL,
`image` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`minimum_deposit_amount` varchar(255) NOT NULL DEFAULT '1',
`maximum_deposit_amount` varchar(255) NOT NULL DEFAULT '100',
`fixed_charge` varchar(255) NOT NULL DEFAULT '0',
`percentage_charge` varchar(255) NOT NULL DEFAULT '0',
`rate` varchar(255) NOT NULL DEFAULT '1',
`gateway_key_one` varchar(255) DEFAULT NULL,
`gateway_key_two` varchar(255) DEFAULT NULL,
`gateway_key_three` varchar(255) DEFAULT NULL,
`gateway_key_four` varchar(255) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`field_options` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `payment_gatways`
--
INSERT INTO `payment_gatways` (`id`, `image`, `name`, `minimum_deposit_amount`, `maximum_deposit_amount`, `fixed_charge`, `percentage_charge`, `rate`, `gateway_key_one`, `gateway_key_two`, `gateway_key_three`, `gateway_key_four`, `status`, `created_at`, `updated_at`, `field_options`) VALUES
(1, '1600414774.jpg', 'Paypal', '10', '1000', '1', '1', '1', 'ASjU3VITdWM6M5gDJuIAGd0_h6pWawlqrc4n9mFlBMnotP9FE2oNCUzSn8zS0kO4qBVtg3W6rjojnR_B', 'EChb-6HSZTI6s2OKDqJXZ4PFFsQ6Bdp5lsmvvIzsWxkEKjWFp-Mn4-zV-G1ycZx-QW3uOOdfBaA6f3iN', NULL, NULL, 1, NULL, '2024-05-04 10:18:42', NULL),
(2, '1600416608.jpg', 'Coinpayment', '1', '100', '0', '0', '1', '0c86e76c1eb1a985736259b110715479', '3KPG3ifVamPrRvXjsU96uZzqix9tZ4dxN6', NULL, NULL, 1, NULL, '2020-09-18 02:45:04', NULL),
(3, '1600415960.jpg', 'Stripe', '1', '100', '0', '0', '1', 'sk_test_aat3tzBCCXXBkS4sxY3M8A1B', 'pk_test_AU3G7doZ1sbdpJLj0NaozPBu', NULL, NULL, 1, NULL, '2020-09-18 01:59:20', NULL),
(4, '1610796274.jpg', 'Payfast', '1', '1000', '1', '1', '1', '10021291', '2tlvihaplhxvo', NULL, NULL, 1, NULL, '2021-01-16 05:24:48', NULL),
(5, '1615179775.jpg', 'Paystack', '1', '100', '0', '0', '1', 'pk_test_3c97c08e08eeab72963f9cf9dcb2efde73385eb2', 'sk_test_25dda689e55082138f831c6805acab8c5856f6e4', 'prantobackup@gmail.com', NULL, 1, NULL, '2021-03-07 23:04:44', NULL),
(6, '1618390975.jpg', 'Flutterwave', '1', '1000', '0', '0', '1', 'FLWPUBK-66c9a8d599a11d4c977934bdd2010c48-X', 'FLWSECK-7b0f2213923d52c65d0db1d59c830c93-X', '7b0f2213923dfa785998ac9e', NULL, 1, NULL, '2021-04-14 03:02:55', NULL),
(7, '1618391016.jpg', 'Paytm', '1', '100', '0', '0', '1', 'DIY12386817555501617', 'bKMfNxPPf_QdZppa', NULL, NULL, 1, NULL, '2021-04-14 03:03:36', NULL),
(8, '1618407840.jpg', 'Skrill', '1', '100', '0', '0', '1', 'demoqco@sun-fish.com', NULL, NULL, NULL, 1, NULL, '2021-04-14 07:44:00', NULL),
(9, '1673784130.jpg', 'Authorize.Net', '1', '1000', '0', '0', '1', '7XMs2L4gr6u', '9M2HH6unv99u9V42', NULL, NULL, 1, '2023-03-05 04:28:28', '2023-03-05 04:28:28', NULL),
(10, '1673784154.jpg', 'Mollie', '1', '1000', '0', '0', '1', 'test_v3UHJrw3K9h2n9WkHkVtp993SKF9G8', NULL, NULL, NULL, 1, '2023-03-05 04:38:06', '2023-03-05 04:38:06', NULL),
(11, '1673784174.jpg', 'Instamojo', '1', '1000', '0', '0', '1', 'test_d883b3a8d2bc1adc7a535506713', 'test_dc229039d2232a260a2df3f7502', 'https://test.instamojo.com/api/1.1/', NULL, 1, '2023-03-05 04:34:05', '2023-03-05 04:34:05', NULL),
(12, '1673784586.jpg', 'SecurionPay', '1', '1000', '0', '0', '1', 'pk_test_1osHcULHElDE58lrsjxWun4b', 'sk_test_H7rlwnDJDGfp5BmcQhiUU0KR', NULL, NULL, 1, '2023-03-05 10:42:37', '2023-03-05 10:42:37', NULL),
(13, '1673784213.jpg', 'Coingate', '1', '1000', '0', '0', '1', '62TWcezrdugjALV2Bz89BEypajZtdZS3sd_j-HMJ', NULL, NULL, NULL, 1, '2023-03-05 04:34:57', '2023-03-05 04:34:57', NULL),
(14, '1673784234.jpg', 'Coinbase Commerce', '1', '1000', '0', '0', '1', 'f7706d38-37af-4024-83aa-73c82309ef5d', 'e8040850-d191-4a5a-8fe9-bb7b5698832e', NULL, NULL, 1, '2023-03-05 04:35:19', '2023-03-05 04:35:19', NULL),
(15, '1673784398.jpg', '2checkout', '1', '1000', '0', '0', '1', '252477737496', 'lrXOoJTPqrk=', NULL, NULL, 1, '2023-03-05 04:35:38', '2023-10-06 01:57:14', NULL),
(16, '662ce53e8a613211.png', 'razorpay', '1', '1000', '0', '0', '1', 'rzp_test_r8XIwoQUldfBxE', 'G21wL8EwAeO2RIEg33qC1WjM', NULL, NULL, 1, '2023-03-05 04:35:38', '2024-04-27 05:45:03', NULL),
(70, '1598017936.jpg', 'Citi Bank', '10', '100', '1.1', '1.2', '1', NULL, NULL, NULL, 'Account Num : 4242 4242 4242 4242', 1, '2020-08-21 07:52:16', '2023-10-09 03:14:02', '{\"1\":{\"name\":\"Contact Number\",\"type\":\"text\",\"validation\":\"nullable\"},\"2\":{\"name\":\"Screenshot\",\"type\":\"file\",\"validation\":\"required\"},\"3\":{\"name\":\"Details\",\"type\":\"textarea\",\"validation\":\"required\"}}');
-- --------------------------------------------------------
--
-- 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,
`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 `plans`
--
CREATE TABLE `plans` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`min_amount` varchar(255) DEFAULT NULL,
`max_amount` varchar(255) DEFAULT NULL,
`fixed_amount` varchar(255) DEFAULT NULL,
`percent` char(4) NOT NULL,
`action` tinyint(4) DEFAULT NULL,
`period` int(11) NOT NULL COMMENT '1=Hourly,24=Daily,168=Weekly,720=Monthly,2880=Quarterly,8640=Yearly',
`return_time_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = ROI, 0 = Fixed',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`capital_back_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = Capital Not Back, 0 = Capital Back'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `rankings`
--
CREATE TABLE `rankings` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`minimum_deposit` decimal(8,2) NOT NULL,
`minimum_invest` decimal(8,2) NOT NULL,
`minimum_referral` int(11) NOT NULL,
`bonus` decimal(8,2) NOT NULL,
`status` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `referrals`
--
CREATE TABLE `referrals` (
`id` bigint(20) UNSIGNED NOT NULL,
`percentage` varchar(255) 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 `services`
--
CREATE TABLE `services` (
`id` bigint(20) UNSIGNED NOT NULL,
`icon` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` 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 `services`
--
INSERT INTO `services` (`id`, `icon`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, '64a918c0737b8688.png', 'Stable & Profitable', 'Experienced business owners and managers know that 3 things are necessary to ensure the long- term success of any business: growth, profit and stability', '2020-05-17 09:40:27', '2023-07-08 02:05:20'),
(2, '5ec15af1d7c70717.png', 'Instant Withdraw', 'Withdrawal Speed: Up to 4 hours .General rules for depositing and withdrawing funds . If a deposit or withdrawal is not subject to instant execution', '2020-05-17 09:40:33', '2020-06-09 15:22:05'),
(3, '5ec15b40a5fb9648.png', 'Referral Provides', 'A referral program is an organized process in which customers are rewarded for spreading the word.', '2020-05-17 09:40:38', '2020-06-09 15:24:42');
-- --------------------------------------------------------
--
-- Table structure for table `sliders`
--
CREATE TABLE `sliders` (
`id` bigint(20) UNSIGNED NOT NULL,
`header` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`description` 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 `sliders`
--
INSERT INTO `sliders` (`id`, `header`, `title`, `image`, `description`, `created_at`, `updated_at`) VALUES
(1, 'We create opportunity', 'UniCrypt is the real game changer', '65606c2d4bf69387.png', 'Mauris lacinia mauris ac leo pulvinar onsectetur adipisicint enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequ aute irure dolor in reprehenderit in vo luptate velit esse cillum dolore eu fugiat nulla pariatur.', '2023-11-24 03:26:05', '2023-11-24 03:26:05'),
(2, 'We have 24/7 supported team', 'Best Invest Company Since 2024', '65606c49710fc278.png', 'look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Inter your email address', '2023-11-24 03:26:33', '2023-11-24 03:26:33');
-- --------------------------------------------------------
--
-- Table structure for table `socials`
--
CREATE TABLE `socials` (
`id` bigint(20) UNSIGNED NOT NULL,
`icon` varchar(255) NOT NULL,
`link` 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 `socials`
--
INSERT INTO `socials` (`id`, `icon`, `link`, `created_at`, `updated_at`) VALUES
(2, 'facebook', 'https://www.facebook.com/', '2020-05-18 02:18:00', '2021-10-22 02:40:47'),
(3, 'instagram', 'https://www.instagram.com/', '2020-05-18 02:18:25', '2021-10-22 02:40:53'),
(4, 'twitter', 'https://twitter.com/', '2020-05-18 02:18:43', '2021-10-22 02:40:58'),
(5, 'linkedin', 'https://linkedin.com/in/', '2020-05-18 02:19:14', '2021-10-22 02:41:04');
-- --------------------------------------------------------
--
-- Table structure for table `supports`
--
CREATE TABLE `supports` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) NOT NULL,
`ticket` varchar(255) NOT NULL,
`subject` 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;
-- --------------------------------------------------------
--
-- Table structure for table `support_comments`
--
CREATE TABLE `support_comments` (
`id` bigint(20) UNSIGNED NOT NULL,
`ticket_id` varchar(255) NOT NULL,
`type` tinyint(1) NOT NULL,
`comment` longtext 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 `transactions`
--
CREATE TABLE `transactions` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) NOT NULL,
`trans_id` bigint(20) NOT NULL,
`description` varchar(255) NOT NULL,
`amount` varchar(255) NOT NULL,
`old_bal` varchar(255) NOT NULL,
`new_bal` varchar(255) NOT NULL,
`status` int(11) NOT NULL COMMENT '0 = Purchase Plan, 1 = Deposit, 2 = Bal Trans, 3 = Withdraw, 4 = ROI',
`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 `transfer_logs`
--
CREATE TABLE `transfer_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`form_user_id` bigint(20) NOT NULL,
`to_user_id` int(11) NOT NULL,
`from_wallet_id` bigint(20) NOT NULL,
`to_wallet_id` bigint(20) NOT NULL,
`coin_amount` varchar(255) NOT NULL,
`main_amount` varchar(255) DEFAULT NULL,
`charge` varchar(255) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(50) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`tfver` int(11) DEFAULT 0,
`emailv` int(11) DEFAULT 0,
`vercode` varchar(191) DEFAULT '0',
`balance` varchar(191) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT 1,
`gender` tinyint(1) DEFAULT NULL COMMENT '1 = Men & 0 = Female',
`address` varchar(255) DEFAULT NULL,
`zip_code` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`bvn_number` varchar(191) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`ref_id` int(11) DEFAULT NULL,
`referral_token` varchar(255) DEFAULT NULL,
`vsent` varchar(191) DEFAULT NULL,
`secretcode` varchar(191) DEFAULT '0',
`tauth` int(11) DEFAULT 0,
`identity_verify` tinyint(1) NOT NULL COMMENT '0 => Not Applied, 1=> Applied, 2=> Approved, 3 => Rejected',
`is_premium` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_rankings`
--
CREATE TABLE `user_rankings` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`ranking_id` int(11) NOT NULL,
`bonus` decimal(10,0) NOT NULL,
`is_current` tinyint(1) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `wallets`
--
CREATE TABLE `wallets` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) NOT NULL,
`wallet_name` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`balance` 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;
-- --------------------------------------------------------
--
-- Table structure for table `withdraw_logs`
--
CREATE TABLE `withdraw_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`withdraw_id` varchar(255) NOT NULL,
`user_id` bigint(20) NOT NULL,
`amount` varchar(255) NOT NULL,
`charge` varchar(255) NOT NULL,
`method_name` varchar(255) NOT NULL,
`processing_time` varchar(255) NOT NULL,
`detail` text DEFAULT NULL,
`status` int(11) NOT NULL COMMENT '0 = pending, 1 = approved, 2 = Reject',
`method_cur` varchar(255) NOT NULL,
`method_rate` varchar(191) 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 `withdraw_methods`
--
CREATE TABLE `withdraw_methods` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`min_amo` varchar(255) NOT NULL,
`max_amo` varchar(255) NOT NULL,
`chargefx` varchar(255) NOT NULL,
`chargepc` varchar(255) NOT NULL,
`rate` varchar(255) NOT NULL,
`processing_day` varchar(255) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT 1,
`currency` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`field_options` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `work_areas`
--
CREATE TABLE `work_areas` (
`id` bigint(20) UNSIGNED NOT NULL,
`icon` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` 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 `work_areas`
--
INSERT INTO `work_areas` (`id`, `icon`, `title`, `description`, `created_at`, `updated_at`) VALUES
(2, '5edf6e8574dc7852.png', 'OPEN AN ACCOUNT', 'You can open bank accounts entirely online, with no need for signatures or branch ... you can complete most banking tasks online—even opening your account', '2020-05-15 14:00:18', '2020-06-09 15:12:05'),
(3, '5edf6ed6035bb901.png', 'GIVE INTEREST', 'Review and compare interest rates to find the best bank for a savings account, ... While it\'s true that some checking accounts pay interest, the vast majority don\'t.', '2020-05-15 14:00:30', '2020-06-09 15:13:26'),
(4, '5edf6d01b90ef567.png', 'GET DEPOSIT', 'Using GET from a Web Browser to make an Online Credit Card Deposit. Using the UMass GET web site, you can make VISA, MC, or Discover card deposits', '2020-05-15 14:28:53', '2020-06-09 15:09:33');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `addons`
--
ALTER TABLE `addons`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `sp_addons_name_unique` (`name`);
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admins_email_unique` (`email`);
--
-- Indexes for table `bill_requests`
--
ALTER TABLE `bill_requests`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `deposit_requests`
--
ALTER TABLE `deposit_requests`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `generals`
--
ALTER TABLE `generals`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `identify_forms`
--
ALTER TABLE `identify_forms`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `investors`
--
ALTER TABLE `investors`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `invest_logs`
--
ALTER TABLE `invest_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `kycs`
--
ALTER TABLE `kycs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `manage_times`
--
ALTER TABLE `manage_times`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `manage_users`
--
ALTER TABLE `manage_users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `news`
--
ALTER TABLE `news`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `payment_gatways`
--
ALTER TABLE `payment_gatways`
ADD PRIMARY KEY (`id`);
--
-- 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 `plans`
--
ALTER TABLE `plans`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `rankings`
--
ALTER TABLE `rankings`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `rankings_title_unique` (`title`);
--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `socials`
--
ALTER TABLE `socials`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `supports`
--
ALTER TABLE `supports`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `support_comments`
--
ALTER TABLE `support_comments`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transfer_logs`
--
ALTER TABLE `transfer_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- Indexes for table `user_rankings`
--
ALTER TABLE `user_rankings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `work_areas`
--
ALTER TABLE `work_areas`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `addons`
--
ALTER TABLE `addons`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `bill_requests`
--
ALTER TABLE `bill_requests`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `deposit_requests`
--
ALTER TABLE `deposit_requests`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `generals`
--
ALTER TABLE `generals`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `identify_forms`
--
ALTER TABLE `identify_forms`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `investors`
--
ALTER TABLE `investors`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `invest_logs`
--
ALTER TABLE `invest_logs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kycs`
--
ALTER TABLE `kycs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `manage_times`
--
ALTER TABLE `manage_times`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `manage_users`
--
ALTER TABLE `manage_users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `payment_gatways`
--
ALTER TABLE `payment_gatways`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;
--
-- 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 `plans`
--
ALTER TABLE `plans`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `rankings`
--
ALTER TABLE `rankings`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `socials`
--
ALTER TABLE `socials`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `support_comments`
--
ALTER TABLE `support_comments`
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 for table `transfer_logs`
--
ALTER TABLE `transfer_logs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_rankings`
--
ALTER TABLE `user_rankings`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `work_areas`
--
ALTER TABLE `work_areas`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;