This policy explains how StackFood website and related applications (the “Site”, “we” or “us”) collects, uses, shares and protects the personal information that we collect through this site or different channels. StackFood has established the site to link up the users who need foods or grocery items to be shipped or delivered by the riders from the affiliated restaurants or shops to the desired location. This policy also applies to any mobile applications that we develop for use with our services on the Site, and references to this “Site”, “we” or “us” is intended to also include these mobile applications. Please read below to learn more about our information policies. By using this Site, you agree to these policies.
\r\n\r\n\r\n\r\n
Information provided by web browser
\r\nYou have to provide us with personal information like your name, contact no, mailing address and email id, our app will also fetch your location information in order to give you the best service. Like many other websites, we may record information that your web browser routinely shares, such as your browser type, browser language, software and hardware attributes, the date and time of your visit, the web page from which you came, your Internet Protocol address and the geographic location associated with that address, the pages on this Site that you visit and the time you spent on those pages. This will generally be anonymous data that we collect on an aggregate basis.
\r\n\r\n
If you want to use our service, you must create an account on our Site. To establish your account, we will ask for personally identifiable information that can be used to contact or identify you, which may include your name, phone number, and e-mail address. We may also collect demographic information about you, such as your zip code, and allow you to submit additional information that will be part of your profile. Other than basic information that we need to establish your account, it will be up to you to decide how much information to share as part of your profile. We encourage you to think carefully about the information that you share and we recommend that you guard your identity and your sensitive information. Of course, you can review and revise your profile at any time.
\r\n\r\n\r\n\r\n
To make the payment online for availing our services, you have to provide the bank account, mobile financial service (MFS), debit card, credit card information to the StackFood platform.
\r\n\r\n\r\n\r\n
\r\nWe may use third parties, such as Google, to serve ads about our website over the internet. These third parties may use cookies to identify ads that may be relevant to your interest (for example, based on your recent visit to our website), to limit the number of times that you see an ad, and to measure the effectiveness of the ads.
\r\nWe may also use Google Analytics or a similar service to gather statistical information about the visitors to this Site and how they use the Site. This, also, is done on an anonymous basis. We will not try to associate anonymous data with your personally identifiable data. If you would like to learn more about Google Analytics, please click here.
These terms of use (the "Terms of Use") govern your use of our website www.evaly.com.bd (the "Website") and our "StackFood" application for mobile and handheld devices (the "App"). The Website and the App are jointly referred to as the "Platform". Please read these Terms of Use carefully before you use the services. If you do not agree to these Terms of Use, you may not use the services on the Platform, and we request you to uninstall the App. By installing, downloading and/or even merely using the Platform, you shall be contracting with StackFood and you provide your acceptance to the Terms of Use and other StackFood policies (including but not limited to the Cancellation & Refund Policy, Privacy Policy etc.) as posted on the Platform from time to time, which takes effect on the date on which you download, install or use the Services, and create a legally binding arrangement to abide by the same. The Platforms will be used by (i) natural persons who have reached 18 years of age and (ii) corporate legal entities, e.g companies. Where applicable, these Terms shall be subject to country-specific provisions as set out herein.
\r\n\r\n\r\n\r\n
All commercial/contractual terms are offered by and agreed to between Buyers and Merchants alone. The commercial/contractual terms include without limitation to price, taxes, shipping costs, payment methods, payment terms, date, period and mode of delivery, warranties related to products and services and after sales services related to products and services. StackFood does not have any kind of control or does not determine or advise or in any way involve itself in the offering or acceptance of such commercial/contractual terms between the Buyers and Merchants. StackFood may, however, offer support services to Merchants in respect to order fulfilment, payment collection, call ce
\r\n\r\nStackFood is operating an e-commerce platform and assumes and operates the role of facilitator, and does not at any point of time during any transaction between Buyer and Merchant on the Platform come into or take possession of any of the products or services offered by Merchant. At no time shall StackFood hold any right, title or interest over the products nor shall StackFood have any obligations or liabilities in respect of such contract entered into between Buyer and Merchant. You agree and acknowledge that we shall not be responsible for:
\r\n\r\nThe goods provided by the shops or restaurants including, but not limited, serving of food orders suiting your requirements and needs;
\r\nThe Merchant"s goods not being up to your expectations or leading to any loss, harm or damage to you;
\r\nThe availability or unavailability of certain items on the menu;
\r\nThe Merchant serving the incorrect orders.
\r\nThe details of the menu and price list available on the Platform are based on the information provided by the Merchants and we shall not be responsible for any change or cancellation or unavailability. All Menu & Food Images used on our platforms are only representative and shall/might not match with the actual Menu/Food Ordered, StackFood shall not be responsible or Liable for any discrepancies or variations on this aspect.
\r\n\r\n
If you want to use our service, you must create an account on our Site. To establish your account, we will ask for personally identifiable information that can be used to contact or identify you, which may include your name, phone number, and e-mail address. We may also collect demographic information about you, such as your zip code, and allow you to submit additional information that will be part of your profile. Other than basic information that we need to establish your account, it will be up to you to decide how much information to share as part of your profile. We encourage you to think carefully about the information that you share and we recommend that you guard your identity and your sensitive information. Of course, you can review and revise your profile at any time.
', NULL, '2023-09-26 08:16:30'), (37, 'inactive_auth_minute', '30', NULL, NULL), (38, 'about_us', 'MXWallet is a digital wallet-supported system that offers secure and efficient transactions through a mobile application. It was created with the aim of providing a convenient and hassle-free way for people to manage their finances, whether it be sending or receiving money, making online purchases, or paying bills.
\r\n\r\nAs a digital wallet system, MXWallet operates entirely online, allowing users to access their funds from anywhere with an internet connection. This means that users no longer need to carry cash or cards with them, reducing the risk of theft or loss. Moreover, it offers a fast and easy way to manage transactions without the need to go to a physical bank or financial institution.
\r\n\r\nThe MXWallet platform is user-friendly and intuitive, making it accessible to people of all ages and backgrounds. It offers a range of features such as Add Money, Send Money, Cash Out, and Request Money, which can be accessed via the customer app and agent app. One of the key features of MXWallet is its QR code scanner, which allows for quick and safe transactions.
\r\n\r\nOverall, MXWallet is a digital wallet-supported system that offers a range of features to make financial management more accessible, secure, and efficient. With its user-friendly platform, advanced security features, and comprehensive transaction reports, MXWallet is a reliable and convenient tool for managing your finances.
', NULL, '2024-05-16 20:15:03'), (39, 'stripe', '{\"status\":\"0\",\"api_key\":\"\",\"published_key\":\"\"}', '2022-04-16 07:43:45', '2022-04-19 06:30:02'), (40, 'razor_pay', '{\"status\":\"0\",\"razor_key\":\"\",\"razor_secret\":\"\"}', '2022-04-16 08:04:01', '2022-04-19 06:31:39'), (41, 'paystack', '{\"status\":\"0\",\"publicKey\":\"\",\"secretKey\":\"\",\"paymentUrl\":\"https:\\/\\/api.paystack.co\",\"merchantEmail\":\"demo@gmail.com\"}', '2022-04-16 08:04:29', '2022-04-19 06:29:56'), (42, 'bkash', '{\"status\":\"0\",\"api_key\":null,\"api_secret\":null,\"username\":null,\"password\":null}', NULL, NULL), (43, 'paymob', '{\"status\":\"0\",\"api_key\":\"==\",\"iframe_id\":\"\",\"integration_id\":\"\",\"hmac\":\"\"}', NULL, NULL), (44, 'mercadopago', '{\"status\":\"0\",\"public_key\":\"\",\"access_token\":\"\"}', NULL, NULL), (45, 'flutterwave', '{\"status\":\"0\",\"public_key\":\"\",\"secret_key\":\"\",\"hash\":\"\"}', NULL, NULL), (46, 'senang_pay', '{\"status\":\"0\",\"secret_key\":\"\",\"merchant_id\":\"\"}', '2022-04-16 08:05:57', '2022-04-16 08:17:12'), (47, 'app_theme', '1', NULL, NULL), (48, 'payment_otp_verification', '1', NULL, NULL), (49, 'hotline_number', '+919903909333', NULL, NULL), (50, 'merchant_commission_percent', '15', NULL, NULL), (51, 'payment', '{\"status\":1,\"message\":\"payment done successfully.\"}', NULL, NULL), (52, 'withdraw_charge_percent', '5', NULL, NULL), (53, 'add_money_bonus', '{\"status\":1,\"message\":\"Added to your account with bonus.\"}', NULL, NULL), (54, 'agent_self_registration', '1', NULL, NULL), (55, 'maximum_otp_hit', '5', NULL, NULL), (56, 'otp_resend_time', '60', NULL, NULL), (57, 'temporary_block_time', '600', NULL, NULL), (58, 'maximum_login_hit', '5', NULL, NULL), (59, 'temporary_login_block_time', '600', NULL, NULL), (60, 'add_money_status', '1', NULL, NULL), (61, 'send_money_status', '1', NULL, NULL), (62, 'cash_out_status', '1', NULL, NULL), (63, 'send_money_request_status', '1', NULL, NULL), (64, 'withdraw_request_status', '1', NULL, NULL), (65, 'linked_website_status', '1', NULL, NULL), (66, 'banner_status', '1', NULL, NULL), (67, 'customer_add_money_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (68, 'customer_send_money_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (69, 'customer_send_money_request_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (70, 'customer_cash_out_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (71, 'customer_withdraw_request_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (72, 'agent_add_money_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (73, 'agent_send_money_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (74, 'agent_send_money_request_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (75, 'agent_withdraw_request_limit', '{\"status\":0,\"transaction_limit_per_day\":3,\"max_amount_per_transaction\":10,\"total_transaction_amount_per_day\":20,\"transaction_limit_per_month\":5,\"total_transaction_amount_per_month\":50}', NULL, NULL), (76, 'agent_self_delete', '1', NULL, NULL), (77, 'customer_self_delete', '1', NULL, NULL), (78, 'landing_intro_section_status', '1', NULL, NULL), (79, 'intro_section', '{\"title\":\"Your day-to-day %% **Online Wallet**\",\"description\":\"Welcome to MXWallet! Your personal digital wallet for daily life. With MXWallet, you can easily make payments, transfer money, add money, and cash out from your MXWallet.\",\"download_link\":\"#\",\"button_name\":\"Download\",\"intro_left_image\":\"2024-05-17-664704c1d8dd2.png\",\"intro_middle_image\":\"2024-05-17-664706c56c406.png\",\"intro_right_image\":\"2024-05-17-6647052608319.png\"}', NULL, NULL), (80, 'user_rating_with_total_user_section', '{\"reviewer_name\":\"John Snow\",\"rating\":\"5\",\"total_user_count\":\"1900\",\"total_user_content\":\"Active Users\",\"review_user_icon\":\"2024-05-17-664716cf70ccd.png\",\"user_image_one\":\"2024-05-17-664716cf70fc9.png\",\"user_image_two\":\"2024-05-17-664716cf714b4.png\",\"user_image_three\":\"2024-05-17-664716cf71a38.png\"}', NULL, NULL), (81, 'landing_feature_title', 'Using Digital Wallet is Now ##Easier!##', NULL, NULL), (82, 'landing_feature_status', '1', NULL, NULL), (83, 'landing_screenshots_status', '1', NULL, NULL), (84, 'landing_why_choose_us_status', '1', NULL, NULL), (85, 'landing_why_choose_us_title', 'Choose ##MXWallet## for %% Secure and Convenient Digital Payments', NULL, NULL), (86, 'landing_agent_registration_section_status', '1', NULL, NULL), (87, 'agent_registration_section', '{\"title\":\"Join As Agent & %% @@Earn Money@@\",\"banner\":\"2024-05-17-664703aa09813.png\"}', NULL, NULL), (88, 'landing_how_it_works_section_status', '1', NULL, NULL), (89, 'landing_how_it_works_section_title', 'How it **works**', NULL, NULL), (90, 'landing_download_section_status', '1', NULL, NULL), (91, 'download_section', '{\"title\":\"Access MXWallet %% Anytime, Anywhere!\",\"sub_title\":\"All the power of niche in your pocket. Schedule, publish and monitir your accounts with ease.\",\"play_store_link\":\"#\",\"app_store_link\":null,\"image\":\"2024-05-17-6647024bc7c61.png\"}', NULL, NULL), (92, 'landing_business_statistics_status', '1', NULL, NULL), (93, 'business_statistics_download', '{\"download_count\":\"2500\",\"review_count\":\"4.5\",\"title\":\"##Real## Stories from MXWallet Users\",\"sub_title\":\"MXWallet is loved by millions of people & trusted by thousands of businesses nationwide.\",\"country_count\":\"15000\",\"download_sort_description\":\"Downloads from Android & iOS\",\"review_sort_description\":\"Based on 1258 reviews\",\"country_sort_description\":\"Users around the country.\",\"download_icon\":\"2024-05-17-664718a34a812.png\",\"review_icon\":\"2024-05-17-6647188f4cf25.png\",\"country_icon\":\"2024-05-17-6647188150c5e.png\"}', NULL, NULL), (94, 'contact_us_section', '{\"title\":\"##Contact## Us\",\"sub_title\":\"Reach out to us easily and quickly. We\'re here to assist you with any concerns, or inquiries you may have\"}', NULL, NULL), (95, 'about_us_title', 'About ##MXWallet##', NULL, '2024-05-16 20:15:03'), (96, 'about_us_sub_title', 'Learn more about who we are, our mission, and our values. Discover the people behind our journey', NULL, '2024-05-16 20:15:03'), (97, 'about_us_image', '2024-05-17-6646d9fc5c74e.png', NULL, NULL), (98, 'privacy_policy_title', '##Privacy## Policy', NULL, '2023-09-26 08:20:40'), (99, 'privacy_policy_sub_title', 'Discover how we protect your personal information and respect your privacy. Explore our privacy policy to learn about data handling and security practices', NULL, '2023-09-26 08:20:40'), (100, 'terms_and_conditions_title', '##Terms## & Condition', NULL, '2023-09-26 08:16:30'), (101, 'terms_and_conditions_sub_title', 'Explore the legal terms and conditions that govern our services. Understand the rules, policies, and agreements that apply to your interactions with us', NULL, '2023-09-26 08:16:30'), (102, 'business_short_description', 'MXWallet is your personal digital wallet solution for your daily life. Download the MXWallet app today!', NULL, NULL), (103, 'landing_page_logo', '2024-06-05-66605b9ca7e0d.png', NULL, NULL), (104, 'mail_config', '{\"status\":\"1\",\"name\":\"Miracuves\",\"host\":\"mail.mimeld.com\",\"driver\":\"smtp\",\"port\":\"465\",\"username\":\"demo@mimeld.com\",\"email_id\":\"info@miracuves.com\",\"encryption\":\"ssl\",\"password\":\"DemoEmail_$321\"}', NULL, '2024-05-16 21:50:15'), (105, 'feature', '[{\"id\":\"5567416407\",\"title\":\"Send Money\",\"sub_title\":\"Transfer your money to another MXWallet.\",\"status\":\"1\",\"image\":\"2024-05-16-6646f069e9a1a.png\"},{\"id\":\"5841841733\",\"title\":\"Cashout\",\"sub_title\":\"Ask for cash out from a nearby MXWallet agent.\",\"status\":\"1\",\"image\":\"2024-05-16-6646f7cf35cb1.png\"},{\"id\":\"3016780574\",\"title\":\"Add Money\",\"sub_title\":\"Add money to your MXWallet from other accounts.\",\"status\":\"1\",\"image\":\"2024-05-16-6646f6a0bbfb0.png\"},{\"id\":\"6329031938\",\"title\":\"Request Money\",\"sub_title\":\"Request money from other MXWallet users to your wallet.\",\"status\":\"1\",\"image\":\"2024-05-16-6646f892e8e69.png\"}]', NULL, NULL), (106, 'screenshots', '[{\"id\":\"5966070515\",\"image\":\"2024-05-17-6647459a5e05c.png\",\"status\":\"1\"},{\"id\":\"9478130614\",\"image\":\"2024-05-17-664745ab022b7.png\",\"status\":\"1\"},{\"id\":\"1111092826\",\"image\":\"2024-05-17-664745dc718eb.png\",\"status\":\"1\"},{\"id\":\"4658118857\",\"image\":\"2024-05-17-664745ef6da9a.png\",\"status\":\"1\"},{\"id\":\"4946297612\",\"image\":\"2024-05-17-66474601202c7.png\",\"status\":\"1\"},{\"id\":\"2393337748\",\"image\":\"2024-05-17-6647460d67687.png\",\"status\":\"1\"},{\"id\":\"1095013034\",\"image\":\"2024-05-17-6647461c3fe29.png\",\"status\":\"1\"},{\"id\":8507328737,\"image\":\"2024-05-17-6647482a83f38.png\",\"status\":\"1\"}]', NULL, NULL), (107, 'why_choose_us', '[{\"id\":\"5865925067\",\"title\":\"Authentic User Verification\",\"sub_title\":\"Verify phone and account with biometric face & OTP verification during login.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ec95ab9eb.png\"},{\"id\":\"3264571294\",\"title\":\"Scan & Share QR Code\",\"sub_title\":\"Get your authentic QR code for sharing & scan others\\u2019 QR for money transfers.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ed00d038a.png\"},{\"id\":\"1513795937\",\"title\":\"Add Purpose to Money Transfer\",\"sub_title\":\"Let your friends know why you\\u2019re transferring money to their MXWallet wallet.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ed665ac0d.png\"},{\"id\":\"3649402573\",\"title\":\"Share Transaction History\",\"sub_title\":\"Share your transaction history after successfully completing it on other platforms.\",\"status\":\"1\",\"image\":\"2024-05-16-6646eda642c8f.png\"},{\"id\":\"2735635219\",\"title\":\"Multiple Languages\",\"sub_title\":\"Choose your favorite language & get a native feel from your MXWallet mobile app.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ee3d06e21.png\"},{\"id\":\"5743752310\",\"title\":\"24\\/7 Customer Support\",\"sub_title\":\"We\\u2019re here to help you with any wallet-related issues, so feel free to call us.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ef1417383.png\"}]', NULL, NULL), (108, 'how_it_works_section', '[{\"id\":\"6385669496\",\"title\":\"Easy and Secure Login\",\"sub_title\":\"Login to your MXWallet account using a biometric or 4\\u2013digit PIN to access the wallet.\",\"status\":\"1\",\"image\":\"2024-05-16-6646fdea4bad0.png\"},{\"id\":\"5068057319\",\"title\":\"Send Money Anytime\",\"sub_title\":\"Send money to your loved ones easily by entering number or scanning QR code.\",\"status\":\"1\",\"image\":\"2024-05-16-6646ff263b719.png\"},{\"id\":\"6512150726\",\"title\":\"Enter Amount, PIN & Proceed\",\"sub_title\":\"After entering a MXWallet wallet number, add amount, and PIN to confirm transaction.\",\"status\":\"1\",\"image\":\"2024-05-16-6646fa78a7abf.png\"}]', NULL, NULL), (109, 'testimonial', '[{\"id\":\"9515779530\",\"rating\":\"5\",\"name\":\"Kwame Osei\",\"opinion\":\"Simple payment with swipe option. I can even save agent numbers for future. Highly recommended!\",\"user_type\":\"Customer\",\"status\":\"1\",\"image\":\"2024-05-17-66471a16d8556.png\"},{\"id\":\"8116331494\",\"rating\":\"5\",\"name\":\"Amina Ndiaye\",\"opinion\":\"Easy to collect payments from customers. My business is booming and becoming very much popular!\",\"user_type\":\"Merchant\",\"status\":\"1\",\"image\":\"2024-05-17-66471a2fa5327.png\"},{\"id\":\"9291787467\",\"rating\":\"5\",\"name\":\"Ousmane Camara\",\"opinion\":\"Quick support from team. The design is top-notch, simple and safe. An easy-to-use digital wallet!\",\"user_type\":\"Agent\",\"status\":\"1\",\"image\":\"2024-05-17-66471a3e3f501.png\"}]', NULL, NULL), (110, 'favicon', '2024-05-17-6647291d8b95c.png', NULL, NULL), (111, 'recaptcha', '{\"status\":\"0\",\"site_key\":\"6Lc5fNYpAAAAANb8AMZeU8YVxR9V8zMFtMJdIJPe\",\"secret_key\":\"6Lc5fNYpAAAAAHCRiTp2EC_TxQhWDHxH6g6aW_xz\"}', '2024-05-09 08:55:45', '2024-05-09 08:55:45'); -- -------------------------------------------------------- -- -- Table structure for table `contact_messages` -- CREATE TABLE `contact_messages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile_number` varchar(255) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `message` text NOT NULL, `reply` text DEFAULT NULL, `feedback` varchar(255) DEFAULT '0', `seen` tinyint(1) DEFAULT 0, `status` tinyint(1) 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 `contact_messages` -- INSERT INTO `contact_messages` (`id`, `name`, `email`, `mobile_number`, `subject`, `message`, `reply`, `feedback`, `seen`, `status`, `created_at`, `updated_at`) VALUES (1, 'Test', 'user@demo.com', NULL, 'Test', 'Test', NULL, '0', 0, 1, '2024-09-26 00:08:34', '2024-09-26 00:08:34'), (2, 'Dr. Benjamin Scott', 'user@demo.com', NULL, 'Hello', 'Hello Admin', NULL, '0', 0, 1, '2024-09-26 19:41:22', '2024-09-26 19:41:22'); -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` bigint(20) UNSIGNED NOT NULL, `country` varchar(255) DEFAULT NULL, `currency_code` varchar(255) DEFAULT NULL, `currency_symbol` varchar(255) DEFAULT NULL, `exchange_rate` decimal(8,2) 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 `currencies` -- INSERT INTO `currencies` (`id`, `country`, `currency_code`, `currency_symbol`, `exchange_rate`, `created_at`, `updated_at`) VALUES (1, 'US Dollar', 'USD', '$', 1.00, NULL, NULL), (2, 'Canadian Dollar', 'CAD', 'CA$', 1.00, NULL, NULL), (3, 'Euro', 'EUR', '€', 1.00, NULL, NULL), (4, 'United Arab Emirates Dirham', 'AED', 'د.إ.', 1.00, NULL, NULL), (5, 'Afghan Afghani', 'AFN', '؋', 1.00, NULL, NULL), (6, 'Albanian Lek', 'ALL', 'L', 1.00, NULL, NULL), (7, 'Armenian Dram', 'AMD', '֏', 1.00, NULL, NULL), (8, 'Argentine Peso', 'ARS', '$', 1.00, NULL, NULL), (9, 'Australian Dollar', 'AUD', '$', 1.00, NULL, NULL), (10, 'Azerbaijani Manat', 'AZN', '₼', 1.00, NULL, NULL), (11, 'Bosnia-Herzegovina Convertible Mark', 'BAM', 'KM', 1.00, NULL, NULL), (12, 'Bangladeshi Taka', 'BDT', '৳', 1.00, NULL, NULL), (13, 'Bulgarian Lev', 'BGN', 'лв.', 1.00, NULL, NULL), (14, 'Bahraini Dinar', 'BHD', 'د.ب.', 1.00, NULL, NULL), (15, 'Burundian Franc', 'BIF', 'FBu', 1.00, NULL, NULL), (16, 'Brunei Dollar', 'BND', 'B$', 1.00, NULL, NULL), (17, 'Bolivian Boliviano', 'BOB', 'Bs', 1.00, NULL, NULL), (18, 'Brazilian Real', 'BRL', 'R$', 1.00, NULL, NULL), (19, 'Botswanan Pula', 'BWP', 'P', 1.00, NULL, NULL), (20, 'Belarusian Ruble', 'BYN', 'Br', 1.00, NULL, NULL), (21, 'Belize Dollar', 'BZD', '$', 1.00, NULL, NULL), (22, 'Congolese Franc', 'CDF', 'FC', 1.00, NULL, NULL), (23, 'Swiss Franc', 'CHF', 'CHf', 1.00, NULL, NULL), (24, 'Chilean Peso', 'CLP', '$', 1.00, NULL, NULL), (25, 'Chinese Yuan', 'CNY', '¥', 1.00, NULL, NULL), (26, 'Colombian Peso', 'COP', '$', 1.00, NULL, NULL), (27, 'Costa Rican Colón', 'CRC', '₡', 1.00, NULL, NULL), (28, 'Cape Verdean Escudo', 'CVE', '$', 1.00, NULL, NULL), (29, 'Czech Republic Koruna', 'CZK', 'Kč', 1.00, NULL, NULL), (30, 'Djiboutian Franc', 'DJF', 'Fdj', 1.00, NULL, NULL), (31, 'Danish Krone', 'DKK', 'Kr.', 1.00, NULL, NULL), (32, 'Dominican Peso', 'DOP', 'RD$', 1.00, NULL, NULL), (33, 'Algerian Dinar', 'DZD', 'د.ج.', 1.00, NULL, NULL), (34, 'Estonian Kroon', 'EEK', 'kr', 1.00, NULL, NULL), (35, 'Egyptian Pound', 'EGP', 'E£', 1.00, NULL, NULL), (36, 'Eritrean Nakfa', 'ERN', 'Nfk', 1.00, NULL, NULL), (37, 'Ethiopian Birr', 'ETB', 'Br', 1.00, NULL, NULL), (38, 'British Pound Sterling', 'GBP', '£', 1.00, NULL, NULL), (39, 'Georgian Lari', 'GEL', 'GEL', 1.00, NULL, NULL), (40, 'Ghanaian Cedi', 'GHS', 'GH¢', 1.00, NULL, NULL), (41, 'Guinean Franc', 'GNF', 'FG', 1.00, NULL, NULL), (42, 'Guatemalan Quetzal', 'GTQ', 'Q', 1.00, NULL, NULL), (43, 'Hong Kong Dollar', 'HKD', 'HK$', 1.00, NULL, NULL), (44, 'Honduran Lempira', 'HNL', 'L', 1.00, NULL, NULL), (45, 'Croatian Kuna', 'HRK', 'kn', 1.00, NULL, NULL), (46, 'Hungarian Forint', 'HUF', 'Ft', 1.00, NULL, NULL), (47, 'Indonesian Rupiah', 'IDR', 'Rp', 1.00, NULL, NULL), (48, 'Israeli New Sheqel', 'ILS', '₪', 1.00, NULL, NULL), (49, 'Indian Rupee', 'INR', '₹', 1.00, NULL, NULL), (50, 'Iraqi Dinar', 'IQD', 'ع.د', 1.00, NULL, NULL), (51, 'Iranian Rial', 'IRR', '﷼', 1.00, NULL, NULL), (52, 'Icelandic Króna', 'ISK', 'kr', 1.00, NULL, NULL), (53, 'Jamaican Dollar', 'JMD', '$', 1.00, NULL, NULL), (54, 'Jordanian Dinar', 'JOD', 'د.ا', 1.00, NULL, NULL), (55, 'Japanese Yen', 'JPY', '¥', 1.00, NULL, NULL), (56, 'Kenyan Shilling', 'KES', 'Ksh', 1.00, NULL, NULL), (57, 'Cambodian Riel', 'KHR', '៛', 1.00, NULL, NULL), (58, 'Comorian Franc', 'KMF', 'FC', 1.00, NULL, NULL), (59, 'South Korean Won', 'KRW', 'CF', 1.00, NULL, NULL), (60, 'Kuwaiti Dinar', 'KWD', 'د.ك.', 1.00, NULL, NULL), (61, 'Kazakhstani Tenge', 'KZT', '₸.', 1.00, NULL, NULL), (62, 'Lebanese Pound', 'LBP', 'ل.ل.', 1.00, NULL, NULL), (63, 'Sri Lankan Rupee', 'LKR', 'Rs', 1.00, NULL, NULL), (64, 'Lithuanian Litas', 'LTL', 'Lt', 1.00, NULL, NULL), (65, 'Latvian Lats', 'LVL', 'Ls', 1.00, NULL, NULL), (66, 'Libyan Dinar', 'LYD', 'د.ل.', 1.00, NULL, NULL), (67, 'Moroccan Dirham', 'MAD', 'د.م.', 1.00, NULL, NULL), (68, 'Moldovan Leu', 'MDL', 'L', 1.00, NULL, NULL), (69, 'Malagasy Ariary', 'MGA', 'Ar', 1.00, NULL, NULL), (70, 'Macedonian Denar', 'MKD', 'Ден', 1.00, NULL, NULL), (71, 'Myanma Kyat', 'MMK', 'K', 1.00, NULL, NULL), (72, 'Macanese Pataca', 'MOP', 'MOP$', 1.00, NULL, NULL), (73, 'Mauritian Rupee', 'MUR', 'Rs', 1.00, NULL, NULL), (74, 'Mexican Peso', 'MXN', '$', 1.00, NULL, NULL), (75, 'Malaysian Ringgit', 'MYR', 'RM', 1.00, NULL, NULL), (76, 'Mozambican Metical', 'MZN', 'MT', 1.00, NULL, NULL), (77, 'Namibian Dollar', 'NAD', 'N$', 1.00, NULL, NULL), (78, 'Nigerian Naira', 'NGN', '₦', 1.00, NULL, NULL), (79, 'Nicaraguan Córdoba', 'NIO', 'C$', 1.00, NULL, NULL), (80, 'Norwegian Krone', 'NOK', 'kr', 1.00, NULL, NULL), (81, 'Nepalese Rupee', 'NPR', 'Re.', 1.00, NULL, NULL), (82, 'New Zealand Dollar', 'NZD', '$', 1.00, NULL, NULL), (83, 'Omani Rial', 'OMR', 'ر.ع.', 1.00, NULL, NULL), (84, 'Panamanian Balboa', 'PAB', 'B/.', 1.00, NULL, NULL), (85, 'Peruvian Nuevo Sol', 'PEN', 'S/', 1.00, NULL, NULL), (86, 'Philippine Peso', 'PHP', '₱', 1.00, NULL, NULL), (87, 'Pakistani Rupee', 'PKR', 'Rs', 1.00, NULL, NULL), (88, 'Polish Zloty', 'PLN', 'zł', 1.00, NULL, NULL), (89, 'Paraguayan Guarani', 'PYG', '₲', 1.00, NULL, NULL), (90, 'Qatari Rial', 'QAR', 'ر.ق.', 1.00, NULL, NULL), (91, 'Romanian Leu', 'RON', 'lei', 1.00, NULL, NULL), (92, 'Serbian Dinar', 'RSD', 'din.', 1.00, NULL, NULL), (93, 'Russian Ruble', 'RUB', '₽.', 1.00, NULL, NULL), (94, 'Rwandan Franc', 'RWF', 'FRw', 1.00, NULL, NULL), (95, 'Saudi Riyal', 'SAR', 'ر.س.', 1.00, NULL, NULL), (96, 'Sudanese Pound', 'SDG', 'ج.س.', 1.00, NULL, NULL), (97, 'Swedish Krona', 'SEK', 'kr', 1.00, NULL, NULL), (98, 'Singapore Dollar', 'SGD', '$', 1.00, NULL, NULL), (99, 'Somali Shilling', 'SOS', 'Sh.so.', 1.00, NULL, NULL), (100, 'Syrian Pound', 'SYP', 'LS', 1.00, NULL, NULL), (101, 'Thai Baht', 'THB', '฿', 1.00, NULL, NULL), (102, 'Tunisian Dinar', 'TND', 'د.ت', 1.00, NULL, NULL), (103, 'Tongan Paʻanga', 'TOP', 'T$', 1.00, NULL, NULL), (104, 'Turkish Lira', 'TRY', '₺', 1.00, NULL, NULL), (105, 'Trinidad and Tobago Dollar', 'TTD', '$', 1.00, NULL, NULL), (106, 'New Taiwan Dollar', 'TWD', 'NT$', 1.00, NULL, NULL), (107, 'Tanzanian Shilling', 'TZS', 'TSh', 1.00, NULL, NULL), (108, 'Ukrainian Hryvnia', 'UAH', '₴', 1.00, NULL, NULL), (109, 'Ugandan Shilling', 'UGX', 'USh', 1.00, NULL, NULL), (110, 'Uruguayan Peso', 'UYU', '$', 1.00, NULL, NULL), (111, 'Uzbekistan Som', 'UZS', 'so\'m', 1.00, NULL, NULL), (112, 'Venezuelan Bolívar', 'VEF', 'Bs.F.', 1.00, NULL, NULL), (113, 'Vietnamese Dong', 'VND', '₫', 1.00, NULL, NULL), (114, 'CFA Franc BEAC', 'XAF', 'FCFA', 1.00, NULL, NULL), (115, 'CFA Franc BCEAO', 'XOF', 'CFA', 1.00, NULL, NULL), (116, 'Yemeni Rial', 'YER', '﷼', 1.00, NULL, NULL), (117, 'South African Rand', 'ZAR', 'R', 1.00, NULL, NULL), (118, 'Zambian Kwacha', 'ZMK', 'ZK', 1.00, NULL, NULL), (119, 'Zimbabwean Dollar', 'ZWL', 'Z$', 1.00, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `e_money` -- CREATE TABLE `e_money` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `current_balance` double(14,2) NOT NULL DEFAULT 0.00, `charge_earned` double(14,2) NOT NULL DEFAULT 0.00, `pending_balance` double 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 `e_money` -- INSERT INTO `e_money` (`id`, `user_id`, `current_balance`, `charge_earned`, `pending_balance`, `created_at`, `updated_at`) VALUES (1, 1, 3199.00, 20.00, 0, '2023-09-26 07:05:38', '2024-09-26 19:44:34'), (2, 1, 0.00, 0.00, 0, '2024-05-07 15:36:44', '2024-05-07 15:36:44'), (3, 2, 2000.00, 0.00, 0, '2024-05-09 09:38:15', '2024-05-09 09:41:35'), (4, 3, 5000.00, 0.00, 0, '2024-05-09 09:39:54', '2024-09-26 19:44:16'), (5, 4, 0.00, 0.00, 0, '2024-05-09 10:13:15', '2024-05-09 10:13:15'), (6, 5, 5000.00, 0.00, 0, '2024-05-09 10:14:34', '2024-09-26 19:44:34'), (7, 6, 942.00, 0.00, 0, '2024-05-16 20:46:59', '2024-05-16 20:46:59'), (8, 7, 1045.00, 0.00, 0, '2024-05-16 21:13:14', '2024-05-17 02:18:18'), (9, 8, 575.00, 0.00, 0, '2024-05-16 21:44:45', '2024-05-17 02:18:18'), (10, 9, 0.00, 0.00, 0, '2024-06-27 19:32:13', '2024-06-27 19:32:13'), (11, 10, 0.00, 0.00, 0, '2024-06-27 19:39:36', '2024-06-27 19:39:36'), (12, 11, 0.00, 0.00, 0, '2024-09-26 19:47:01', '2024-09-26 19:47:01'), (13, 12, 0.00, 0.00, 0, '2024-09-26 19:49:13', '2024-09-26 19:49:13'), (14, 13, 0.00, 0.00, 0, '2024-09-26 19:50:22', '2024-09-26 19:50:22'); -- -------------------------------------------------------- -- -- 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 `funds` -- CREATE TABLE `funds` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `amount` double(14,2) NOT NULL DEFAULT 0.00, `payment_method` varchar(255) NOT NULL, `tran_id` varchar(255) DEFAULT NULL, `status` 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; -- -------------------------------------------------------- -- -- Table structure for table `help_topics` -- CREATE TABLE `help_topics` ( `id` bigint(20) UNSIGNED NOT NULL, `question` text DEFAULT NULL, `answer` text DEFAULT NULL, `ranking` int(11) NOT NULL DEFAULT 1, `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 `help_topics` -- INSERT INTO `help_topics` (`id`, `question`, `answer`, `ranking`, `status`, `created_at`, `updated_at`) VALUES (1, 'How do send money?', 'Try', 1, 0, '2024-09-26 19:52:31', '2024-09-26 19:52:34'); -- -------------------------------------------------------- -- -- Table structure for table `linked_websites` -- CREATE TABLE `linked_websites` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `url` 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; -- -- Dumping data for table `linked_websites` -- INSERT INTO `linked_websites` (`id`, `name`, `image`, `url`, `status`, `created_at`, `updated_at`) VALUES (1, 'Blinkit', '2024-05-17-66472d9f28eed.png', 'https://blinkit.com/', 1, '2022-04-07 08:23:08', '2024-05-17 01:12:47'), (2, 'Amazon', '2024-05-17-66472d545bbe1.png', 'http://www.amazon.com/', 1, '2022-04-07 08:27:25', '2024-05-17 01:11:32'), (3, 'Flipkart', '2024-05-17-66472d32a7d81.png', 'https://www.flipkart.com/', 1, '2022-04-18 09:49:58', '2024-05-17 01:10:58'), (4, 'Swiggy', '2024-05-17-66472cd7a9736.png', 'https://www.swiggy.com/', 1, '2022-04-18 09:50:23', '2024-05-17 01:09:27'), (5, 'McDonald\'s', '2024-05-17-66472e1d7ae60.png', 'https://www.mcdonalds.com/us/en-us.html', 1, '2024-05-17 01:14:53', '2024-05-17 01:14:53'), (6, 'Domino\'s', '2024-05-17-66472e5da6dc5.png', 'https://pizzaonline.dominos.co.in/?src=google_sem_brand&utm_source=google&utm_medium=cpc&utm_campaign=Brand-PanIndia-Exact-Others-Desktop&gad_source=1&gclid=Cj0KCQjwgJyyBhCGARIsAK8LVLO8Abi8z6f_Hf15ivf2MXWOt5u8ryInHc_ic5IyBJ5ilkbOu055yAEaAmwyEALw_wcB', 1, '2024-05-17 01:15:57', '2024-05-17 01:16:11'), (7, 'MxBank', '2024-09-26-66f63a4b5ae58.png', 'https://mxbank.mimeld.com/', 1, '2024-09-26 19:53:31', '2024-09-26 19:53:31'); -- -------------------------------------------------------- -- -- Table structure for table `merchants` -- CREATE TABLE `merchants` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `store_name` varchar(255) DEFAULT NULL, `callback` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `bin` varchar(255) DEFAULT NULL, `public_key` varchar(255) DEFAULT NULL, `secret_key` varchar(255) DEFAULT NULL, `merchant_number` 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 `merchants` -- INSERT INTO `merchants` (`id`, `user_id`, `store_name`, `callback`, `logo`, `address`, `bin`, `public_key`, `secret_key`, `merchant_number`, `created_at`, `updated_at`) VALUES (1, 12, 'New Store', 'Hello', '2024-09-26-66f6394950429.png', 'abc mumbai', '7412', 'rM4vKUH14l1TbWRfzQ0VoeFCK0lnlxkZfQM0lcXRGutVeAQPmw', '5rPCdWHoqsAA0w0I5sh4D9iTNFhrYl80GDPmjCHNXkH9KUW6Gm', '7896541235', '2024-09-26 19:49:13', '2024-09-26 19:49:13'); -- -------------------------------------------------------- -- -- 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 (241, '2014_10_12_000000_create_users_table', 1), (242, '2014_10_12_100000_create_password_resets_table', 1), (243, '2016_06_01_000001_create_oauth_auth_codes_table', 1), (244, '2016_06_01_000002_create_oauth_access_tokens_table', 1), (245, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1), (246, '2016_06_01_000004_create_oauth_clients_table', 1), (247, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1), (248, '2019_08_19_000000_create_failed_jobs_table', 1), (249, '2019_12_14_000001_create_personal_access_tokens_table', 1), (250, '2021_11_18_104105_create_business_settings_table', 1), (251, '2021_11_20_090531_create_currencies_table', 1), (252, '2021_11_22_065212_add_last_active_at_to_users_table', 1), (253, '2021_11_23_090107_create_linked_websites_table', 1), (254, '2021_11_23_104425_add_reference_columns_to_users_table', 1), (255, '2021_11_23_123056_create_notifications_table', 1), (256, '2021_11_27_041913_create_phone_verifications_table', 1), (257, '2021_11_27_052236_add_columns_to_users_table', 1), (258, '2021_11_29_100204_create_transfers_table', 1), (259, '2021_12_01_053955_create_transactions_table', 1), (260, '2021_12_01_063108_create_e_money_table', 1), (261, '2021_12_04_113130_create_request_money_table', 1), (262, '2021_12_05_051247_create_funds_table', 1), (263, '2021_12_06_101224_create_purposes_table', 1), (264, '2021_12_14_104755_add_note_column_to_transaction', 1), (265, '2021_12_19_071059_add_twofactor_and_fcmtoken_to_users_table', 1), (266, '2021_12_21_110529_create_banners_table', 1), (267, '2021_12_22_121505_add_receiver_column_to_notifications', 1), (268, '2021_12_26_061202_create_help_topics_table', 1), (269, '2022_02_01_041254_add_transaction_i_d_to_transactions', 1), (270, '2022_02_01_065231_type_change_of_ref_trans_id_to_transactions', 1), (271, '2022_04_07_045435_add_receiver_to_banner_table', 2), (272, '2022_04_07_060244_add_is_active_column_to_to_users_table', 3), (273, '2021_06_17_054551_create_soft_credentials_table', 4), (274, '2022_06_30_051435_add_column_to_user_table', 5), (275, '2022_07_05_102531_change_data_type_of_transfer_table', 6), (276, '2022_10_16_063545_create_withdrawal_methods_table', 7), (277, '2022_10_18_040302_create_withdraw_requests_table', 7), (278, '2022_10_18_141838_create_user_log_histories_table', 7), (279, '2022_11_08_055006_change_default_kyc_status', 7), (280, '2022_12_08_045549_create_merchants_table', 8), (281, '2022_12_11_050638_create_payment_records_table', 8), (282, '2022_12_21_041139_add_column_dail_country_code_to_users_table', 8), (283, '2022_12_26_122524_add_expired_at_column_in_payment_records_table', 8), (284, '2023_01_23_065548_add_pending_balance_in_e_money_table', 8), (285, '2023_03_25_082756_create_bonuses_table', 9), (286, '2023_03_29_085117_add_col_to_withdraw_requests_table', 9), (287, '2023_04_03_030436_add_column_to_transactions_table', 9), (288, '2023_05_11_084421_change_notifications_table_column_type', 10), (289, '2023_05_15_153550_add_otp_hist_counts_column_in_phone_verification_tabel', 10), (290, '2023_05_25_083248_add_multiple_column_to_password_resets', 10), (291, '2023_05_25_083248_add_multiple_column_to_users', 10), (292, '2023_05_28_085211_create_transaction_limits_table', 10), (293, '2023_05_31_051107_add_soft_delete_in_users', 10), (294, '2023_09_18_042428_create_news_letters_table', 11), (295, '2023_09_18_054929_create_contact_messages_table', 11), (296, '2023_09_19_045232_change_identification_image_to_users_table', 11), (297, '2023_09_20_095151_create_social_media_table', 11); -- -------------------------------------------------------- -- -- Table structure for table `news_letters` -- CREATE TABLE `news_letters` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(191) NOT NULL COMMENT 'Subscribers email', `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_letters` -- INSERT INTO `news_letters` (`id`, `email`, `created_at`, `updated_at`) VALUES (1, 'user11@demo.com', '2024-09-26 19:40:21', '2024-09-26 19:40:21'), (2, 'user@demo.com', '2024-09-26 19:42:22', '2024-09-26 19:42:22'); -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `description` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `receiver` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_access_tokens` -- CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `client_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `oauth_access_tokens` -- INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES ('7127ed60bf07b01753586dcfc025e2f186ceef3df42d6658ccf35951ca0b32db6236888d94762a8b', 6, 3, 'CustomerAuthToken', '[]', 0, '2024-05-16 20:49:50', '2024-05-16 20:49:50', '2024-05-16 23:29:50'), ('89ef2700f1d5ae5f71aaa4109e06ea8803a49837ea88f25b4c56fa6e764f811622763d4b93dece85', 8, 3, 'CustomerAuthToken', '[]', 0, '2024-06-16 21:46:06', '2024-06-16 21:46:06', '2024-06-17 00:26:06'), ('cca3e8f52a15d80b77094380e59968e533d885a23db9a3b3095b94e489c98fa5cc5f3dd061faa85f', 7, 3, 'CustomerAuthToken', '[]', 0, '2024-05-17 23:31:33', '2024-05-17 23:31:33', '2024-05-18 02:11:33'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_auth_codes` -- CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `client_id` bigint(20) UNSIGNED NOT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_clients` -- CREATE TABLE `oauth_clients` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `name` varchar(255) NOT NULL, `secret` varchar(100) DEFAULT NULL, `provider` varchar(255) DEFAULT NULL, `redirect` text NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` 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 `oauth_clients` -- INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1, NULL, 'Laravel Personal Access Client', 'bR3oc2ab81JlHVMcsIXdFcAhBuXQTipmcIcd7Fno', NULL, 'http://localhost', 1, 0, 0, '2022-04-07 08:03:44', '2022-04-07 08:03:44'), (2, NULL, 'Laravel Password Grant Client', 'UhJDtulOAo0vdfuaHCtQ4KT4QOiYDdmImM9x48Ax', 'users', 'http://localhost', 0, 1, 0, '2022-04-07 08:03:44', '2022-04-07 08:03:44'), (3, NULL, 'Laravel Personal Access Client', 'HpFYsWP7yU6grzZOwpsWP1oACFUuOwMHHMGuqYgl', NULL, 'http://localhost', 1, 0, 0, '2022-04-07 08:03:56', '2022-04-07 08:03:56'), (4, NULL, 'Laravel Password Grant Client', 'P03bw333WuSbG3KcWW0VYBBOOTAhcCZaCB3rTt3V', 'users', 'http://localhost', 0, 1, 0, '2022-04-07 08:03:56', '2022-04-07 08:03:56'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_personal_access_clients` -- CREATE TABLE `oauth_personal_access_clients` ( `id` bigint(20) UNSIGNED NOT NULL, `client_id` bigint(20) UNSIGNED 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 `oauth_personal_access_clients` -- INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1, 1, '2022-04-07 08:03:44', '2022-04-07 08:03:44'), (2, 3, '2022-04-07 08:03:56', '2022-04-07 08:03:56'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_refresh_tokens` -- CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) NOT NULL, `access_token_id` varchar(100) NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `phone` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_records` -- CREATE TABLE `payment_records` ( `id` char(36) NOT NULL, `merchant_user_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `transaction_id` varchar(255) DEFAULT NULL, `amount` double(14,2) NOT NULL DEFAULT 0.00, `callback` varchar(255) DEFAULT NULL, `is_paid` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=unpaid, 1=paid', `expired_at` datetime 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 `payment_requests` -- CREATE TABLE `payment_requests` ( `id` char(36) NOT NULL, `payer_id` varchar(64) DEFAULT NULL, `receiver_id` varchar(64) DEFAULT NULL, `payment_amount` decimal(24,2) NOT NULL DEFAULT 0.00, `gateway_callback_url` varchar(191) DEFAULT NULL, `success_hook` varchar(100) DEFAULT NULL, `failure_hook` varchar(100) DEFAULT NULL, `transaction_id` varchar(100) DEFAULT NULL, `currency_code` varchar(20) NOT NULL DEFAULT 'USD', `payment_method` varchar(50) DEFAULT NULL, `additional_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`additional_data`)), `is_paid` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `payer_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payer_information`)), `external_redirect_link` varchar(255) DEFAULT NULL, `receiver_information` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`receiver_information`)), `attribute_id` varchar(64) DEFAULT NULL, `attribute` varchar(255) DEFAULT NULL, `payment_platform` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `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 `phone_verifications` -- CREATE TABLE `phone_verifications` ( `id` bigint(20) UNSIGNED NOT NULL, `phone` varchar(255) DEFAULT NULL, `otp` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `otp_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `phone_verifications` -- INSERT INTO `phone_verifications` (`id`, `phone`, `otp`, `created_at`, `updated_at`, `otp_hit_count`, `is_temp_blocked`, `temp_block_time`) VALUES (1, '+33641259394', '3662', '2024-06-01 20:01:01', '2024-06-01 20:01:08', 1, 0, NULL), (2, '+330641259394', '2384', '2024-06-01 20:03:09', '2024-06-01 20:03:09', 0, 0, NULL), (3, '+919999993333', '5046', '2024-09-26 00:10:04', '2024-09-26 00:10:04', 0, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `purposes` -- CREATE TABLE `purposes` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `logo` varchar(255) NOT NULL, `color` 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 `purposes` -- INSERT INTO `purposes` (`id`, `title`, `logo`, `color`, `created_at`, `updated_at`) VALUES (8, 'Mobile Recharge', '2024-05-19-664adf02532e1.png', '#000000', '2024-05-19 20:26:26', '2024-05-19 20:26:26'); -- -------------------------------------------------------- -- -- Table structure for table `request_money` -- CREATE TABLE `request_money` ( `id` bigint(20) UNSIGNED NOT NULL, `from_user_id` bigint(20) NOT NULL, `to_user_id` bigint(20) NOT NULL, `type` varchar(255) NOT NULL, `amount` double(14,2) NOT NULL DEFAULT 0.00, `note` text 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 `social_media` -- CREATE TABLE `social_media` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `link` 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 `social_media` -- INSERT INTO `social_media` (`id`, `name`, `link`, `status`, `created_at`, `updated_at`) VALUES (1, 'facebook', 'https://facebook.com', 1, NULL, '2024-09-26 00:13:09'), (2, 'twitter', 'https://twitter.com', 1, NULL, '2024-09-26 00:13:01'), (3, 'linkedin', 'https://linkedin.com', 1, NULL, '2024-09-26 00:12:47'), (4, 'instagram', 'https://instagram.com', 1, NULL, '2024-09-26 00:12:53'), (5, 'pinterest', 'https://pinterest.com', 1, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `soft_credentials` -- CREATE TABLE `soft_credentials` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) DEFAULT NULL, `value` longtext 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 `transactions` -- CREATE TABLE `transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) NOT NULL, `ref_trans_id` varchar(255) DEFAULT NULL, `transaction_type` varchar(255) NOT NULL, `debit` double(14,2) NOT NULL DEFAULT 0.00, `credit` double(14,2) NOT NULL DEFAULT 0.00, `balance` double(14,2) NOT NULL DEFAULT 0.00, `from_user_id` bigint(20) DEFAULT NULL, `to_user_id` bigint(20) DEFAULT NULL, `bonus_id` bigint(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `note` varchar(255) DEFAULT NULL, `transaction_id` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `user_id`, `ref_trans_id`, `transaction_type`, `debit`, `credit`, `balance`, `from_user_id`, `to_user_id`, `bonus_id`, `created_at`, `updated_at`, `note`, `transaction_id`) VALUES (1, 1, NULL, 'cash_in', 0.00, 2000.00, 2000.00, 1, 1, NULL, '2024-05-09 09:41:05', '2024-05-09 09:41:05', NULL, 'o2srP1715233265'), (2, 1, NULL, 'cash_in', 0.00, 5000.00, 7000.00, 1, 1, NULL, '2024-05-09 09:41:16', '2024-05-09 09:41:16', NULL, 'ruQr31715233276'), (3, 2, NULL, 'cash_in', 0.00, 2000.00, 2000.00, 1, 2, NULL, '2024-05-09 09:41:35', '2024-05-09 09:41:35', NULL, 'Dj2eP1715233295'), (4, 1, 'Dj2eP1715233295', 'cash_out', 2000.00, 0.00, 5000.00, 1, 2, NULL, '2024-05-09 09:41:35', '2024-05-09 09:41:35', NULL, 'xurFF1715233295'), (5, 1, NULL, 'cash_in', 0.00, 4000.00, 9000.00, 1, 1, NULL, '2024-05-09 09:49:00', '2024-05-09 09:49:00', NULL, 'OJdIF1715233740'), (6, 1, NULL, 'cash_in', 0.00, 1200.00, 10200.00, 1, 1, NULL, '2024-05-09 10:11:01', '2024-05-09 10:11:01', NULL, 'czdaK1715235061'), (7, 3, NULL, 'cash_in', 0.00, 3000.00, 3000.00, 1, 3, NULL, '2024-05-09 10:11:23', '2024-05-09 10:11:23', NULL, 'eIeHo1715235083'), (8, 1, 'eIeHo1715235083', 'cash_out', 3000.00, 0.00, 7200.00, 1, 3, NULL, '2024-05-09 10:11:23', '2024-05-09 10:11:23', NULL, 'zdZz51715235083'), (9, 5, NULL, 'cash_in', 0.00, 4000.00, 4000.00, 1, 5, NULL, '2024-05-09 10:14:59', '2024-05-09 10:14:59', NULL, 'F03NS1715235299'), (10, 1, 'F03NS1715235299', 'cash_out', 4000.00, 0.00, 3200.00, 1, 5, NULL, '2024-05-09 10:14:59', '2024-05-09 10:14:59', NULL, '6O4SR1715235299'), (11, 8, NULL, 'send_money', 110.00, 0.00, 685.00, 8, 7, NULL, '2024-05-16 22:26:40', '2024-05-16 22:26:40', NULL, 'F3H061715930800'), (12, 7, 'F3H061715930800', 'received_money', 0.00, 100.00, 945.00, 8, 7, NULL, '2024-05-16 22:26:40', '2024-05-16 22:26:40', NULL, 'fpJvd1715930800'), (13, 8, 'F3H061715930800', 'admin_charge', 0.00, 10.00, 3200.00, 8, 1, NULL, '2024-05-16 22:26:40', '2024-05-16 22:26:40', NULL, 'LOuO31715930800'), (14, 8, NULL, 'send_money', 55.00, 0.00, 630.00, 8, 7, NULL, '2024-05-17 02:13:32', '2024-05-17 02:13:32', NULL, 'dMNIj1715944412'), (15, 7, 'dMNIj1715944412', 'received_money', 0.00, 50.00, 995.00, 8, 7, NULL, '2024-05-17 02:13:32', '2024-05-17 02:13:32', NULL, '9JieT1715944412'), (16, 8, 'dMNIj1715944412', 'admin_charge', 0.00, 5.00, 3200.00, 8, 1, NULL, '2024-05-17 02:13:32', '2024-05-17 02:13:32', NULL, 'kcI041715944412'), (17, 8, NULL, 'send_money', 55.00, 0.00, 575.00, 8, 7, NULL, '2024-05-17 02:18:18', '2024-05-17 02:18:18', NULL, 'uhwBM1715944698'), (18, 7, 'uhwBM1715944698', 'received_money', 0.00, 50.00, 1045.00, 8, 7, NULL, '2024-05-17 02:18:18', '2024-05-17 02:18:18', NULL, 'NIJhg1715944698'), (19, 8, 'uhwBM1715944698', 'admin_charge', 0.00, 5.00, 3200.00, 8, 1, NULL, '2024-05-17 02:18:18', '2024-05-17 02:18:18', NULL, '65UUf1715944698'), (20, 1, NULL, 'cash_in', 0.00, 2999.00, 6199.00, 1, 1, NULL, '2024-09-26 19:43:50', '2024-09-26 19:43:50', NULL, 'ZtL841727412230'), (21, 3, NULL, 'cash_in', 0.00, 2000.00, 5000.00, 1, 3, NULL, '2024-09-26 19:44:16', '2024-09-26 19:44:16', NULL, 'nKoI61727412256'), (22, 1, 'nKoI61727412256', 'cash_out', 2000.00, 0.00, 4199.00, 1, 3, NULL, '2024-09-26 19:44:16', '2024-09-26 19:44:16', NULL, 'qT7761727412256'), (23, 5, NULL, 'cash_in', 0.00, 1000.00, 5000.00, 1, 5, NULL, '2024-09-26 19:44:34', '2024-09-26 19:44:34', NULL, 'Kfjk51727412274'), (24, 1, 'Kfjk51727412274', 'cash_out', 1000.00, 0.00, 3199.00, 1, 5, NULL, '2024-09-26 19:44:34', '2024-09-26 19:44:34', NULL, 'Tp5OQ1727412274'); -- -------------------------------------------------------- -- -- Table structure for table `transaction_limits` -- CREATE TABLE `transaction_limits` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `todays_count` int(11) NOT NULL DEFAULT 0, `todays_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `this_months_count` int(11) NOT NULL DEFAULT 0, `this_months_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `type` varchar(255) DEFAULT NULL COMMENT 'add_money, send_money, cash_out, send_money_request, withdraw_request', `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 `transfers` -- CREATE TABLE `transfers` ( `id` bigint(20) UNSIGNED NOT NULL, `unique_id` varchar(255) DEFAULT NULL, `sender` bigint(20) NOT NULL, `receiver` bigint(20) NOT NULL, `receiver_type` varchar(255) NOT NULL, `amount` double(14,2) NOT NULL DEFAULT 0.00, `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 `transfers` -- INSERT INTO `transfers` (`id`, `unique_id`, `sender`, `receiver`, `receiver_type`, `amount`, `created_at`, `updated_at`) VALUES (1, '16866835277', 1, 2, '2', 2000.00, '2024-05-09 09:41:35', '2024-05-09 09:41:35'), (2, '23678361724', 1, 3, '2', 3000.00, '2024-05-09 10:11:23', '2024-05-09 10:11:23'), (3, '32474775741', 1, 5, '1', 4000.00, '2024-05-09 10:14:59', '2024-05-09 10:14:59'), (4, '49055655863', 1, 3, '2', 2000.00, '2024-09-26 19:44:16', '2024-09-26 19:44:16'), (5, '51086917452', 1, 5, '1', 1000.00, '2024-09-26 19:44:34', '2024-09-26 19:44:34'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `f_name` varchar(255) DEFAULT NULL, `l_name` varchar(255) DEFAULT NULL, `dial_country_code` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `type` tinyint(1) NOT NULL COMMENT '[''Admin''=>0, ''Agent''=>1, ''Customer''=>2]', `role` tinyint(1) DEFAULT NULL, `password` varchar(255) NOT NULL, `is_phone_verified` tinyint(1) NOT NULL DEFAULT 0, `is_email_verified` tinyint(1) NOT NULL DEFAULT 0, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `last_active_at` timestamp NULL DEFAULT NULL, `unique_id` varchar(255) DEFAULT NULL, `referral_id` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `occupation` varchar(255) DEFAULT NULL, `two_factor` tinyint(1) NOT NULL DEFAULT 0, `fcm_token` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `identification_type` varchar(255) DEFAULT NULL, `identification_number` varchar(255) DEFAULT NULL, `identification_image` varchar(255) DEFAULT '[]', `is_kyc_verified` tinyint(1) NOT NULL DEFAULT 3 COMMENT '[''Pending''=>0, ''Approved''=>1, ''denied''=>2, ''YetToApply''=>3]', `login_hit_count` tinyint(4) NOT NULL DEFAULT 0, `is_temp_blocked` tinyint(1) NOT NULL DEFAULT 0, `temp_block_time` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `f_name`, `l_name`, `dial_country_code`, `phone`, `email`, `image`, `type`, `role`, `password`, `is_phone_verified`, `is_email_verified`, `remember_token`, `created_at`, `updated_at`, `last_active_at`, `unique_id`, `referral_id`, `gender`, `occupation`, `two_factor`, `fcm_token`, `is_active`, `identification_type`, `identification_number`, `identification_image`, `is_kyc_verified`, `login_hit_count`, `is_temp_blocked`, `temp_block_time`, `deleted_at`) VALUES (1, 'Master', 'Demo', '+91', '+919999996666', 'mira@mxwallet.com', NULL, 0, NULL, '$2y$10$01UMSlbnq1BC438QVavzx.KqtBMgHcTwYARLzTgttGl4kY.w/Lxo.', 1, 0, NULL, '2024-05-07 15:36:44', '2024-05-07 15:36:44', NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (2, 'User1', 'demo', '+91', '+9108890342156', 'User1@demo.com', '2024-05-09-663c6146e4db1.png', 2, NULL, '$2y$10$vE9ICnq7/t.aVvJu4Om8Hu16QrPKyvQfS.0uWrm2u4k/zvr1m4vMW', 0, 0, NULL, '2024-05-09 09:38:15', '2024-05-09 09:38:15', NULL, '24166', NULL, 'female', 'buissness', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (3, 'User2', 'demo', '+91', '+918899456703', 'User2@demo.com', '2024-05-09-663c61aa6c6d4.png', 2, NULL, '$2y$10$pPCgZkHyFkI1HtM1.HLeNOW.cQTJ3fRh0QdySaTeSYxno7GNx.R0O', 0, 0, NULL, '2024-05-09 09:39:54', '2024-05-09 09:39:54', NULL, '386498', NULL, 'male', 'Buissness', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (4, 'liza', 'desuza', '+91', '+918899432569', 'lizadesuza@demo.com', '2024-05-09-663c6c94af1b4.png', 1, NULL, '$2y$10$rUUtnzbxqBfPCHDhh2dc1.nlPrC/uI9JOct.hyPTDPsbmO/95D3rS', 0, 0, NULL, '2024-05-09 10:13:15', '2024-05-09 10:26:28', NULL, '456303', NULL, 'female', 'Buissness', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (5, 'kelvin', 'augstien', '+91', '+9106645897632', 'kelvin342@demo.com', '2024-05-09-663c6b005156a.png', 1, NULL, '$2y$10$THD7.5h2W5xOj9f3ecoHMuIYAwYCReM1E0bwq1L8Kw0kFSa.ew.UO', 0, 0, NULL, '2024-05-09 10:14:34', '2024-05-09 10:19:44', NULL, '579300', NULL, 'female', 'Buissness', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (6, 'User', 'Demo', '+91', '+919876543210', 'user@demo.com', '2024-05-16-6646ef5378485.png', 2, NULL, '$2y$10$xWTLtRF2Y31PHj3weUkZTOgHYNO8ULOpm4kwy6arABN/ZZcB867BW', 0, 0, NULL, '2024-05-16 20:46:59', '2024-06-16 21:45:19', '2024-05-16 20:49:52', '652693', NULL, 'male', 'Driver', 0, 'eqDPCBxVRXW-EBX7DXSssx:APA91bGI2Xa-4hgHkVM6DxQy_Pw_TIRoSUA0JYhj8ihaPiuPtf7eHNdxCaot_Tne46mZ4YmotDRiq1E7oqss4AykaTfUnNS0L5PYX2LchG1upIGBvbLJnzxIY_9VhXBBdPjQ_tZU5cUm', 1, NULL, NULL, '[]', 3, 3, 0, NULL, NULL), (7, 'Ayush', 'Ranjan', '+91', '+918287093441', 'ranaayush0730@gmail.com', '2024-05-16-6646fcc3dccbd.png', 2, NULL, '$2y$10$Xsazv93i86t4ZfqvLa2AOux9mtKiQ.jm4MPpu.Jz6GdMnI9wd8XQq', 0, 0, NULL, '2024-05-16 21:13:14', '2024-05-17 23:31:35', '2024-05-17 23:31:35', '785714', NULL, 'Male', 'Dev', 0, 'clnYYqZuTTe6N54MgYq97L:APA91bFgP3XnGnVnJmsdgMC455cvJIELffaVViF-R0N996D77eTUJvF386Hjgm0PLNWWOWwK9BMtkVVj-xFoLo9QgJZkwqvLnUGVPRL2YYgg-iCQxqg-3dTf-vEnDVN6F4EzFh6v9mrp', 1, 'passport', 'w3456789', '[\"2024-05-17-664705a41cfd3.png\"]', 1, 0, 0, NULL, NULL), (8, 'User', 'Demo', '+91', '+919876543211', 'user3@demo.com', '2024-05-16-6646fcdda3431.png', 2, NULL, '$2y$10$aaKOdOzTJ5dAttyK/vOJQet5dnhpqIqKWSsqS8Hw1IAPvSG6Xegpq', 0, 0, NULL, '2024-05-16 21:44:45', '2024-06-16 21:46:09', '2024-06-16 21:46:09', '811243', NULL, 'female', 'Driver', 0, 'dG8z7e_LTrm7Lzk-Wr4CAP:APA91bHVtWi7F5O6MPvhdAvoQcSKMYRmI9pK9lXAZeW8Rc5cENLaet2tNROKsEdDHa8ew5FpKhbjHJCPRZnf4M3hHDnODSJdxnk1aQny8423cFkRq6wwqHXNbffbdfbtteOjLvm1uVoa', 1, 'nid', '5779', '[\"2024-05-17-6647064fe8e52.png\"]', 1, 2, 0, NULL, NULL), (10, 'Admin', 'Demo', '+91', '+919999994444', 'admin@demo.com', '2024-06-27-667e3e87d61eb.png', 0, NULL, '$2y$10$nIhiLN0uFxvZwcKjAyKe5eFmOOGJ.ZTxDqxKA4aoFrCWqzR9XAVT.', 0, 0, NULL, '2024-06-27 19:39:35', '2024-06-27 19:39:35', NULL, '105632', NULL, 'male', 'Admin', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (11, 'Yash', 'Yadav', '+91', '+919898989897', 'user22@demo.com', '2024-09-26-66f638c56fca9.png', 1, NULL, '$2y$10$UMYqST520LOWbcv03NW3au4iwB5ZBPVXYyaobCsI6k4rGj2IzCDei', 0, 0, NULL, '2024-09-26 19:47:01', '2024-09-26 19:47:01', NULL, '1154018', NULL, 'male', 'Student', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL), (12, 'Yash', 'Kumar', '+91', '+917896541235', NULL, '2024-09-26-66f639494e9d7.png', 3, NULL, '$2y$10$.0CeWJZIUB2VtRahOAmo/.d3DPgu5a/VBg83h1AtDxw40rZ.vb6j.', 0, 0, NULL, '2024-09-26 19:49:13', '2024-09-26 19:49:22', NULL, '1298429', NULL, NULL, NULL, 0, NULL, 0, 'passport', '7412', '[\"2024-09-26-66f6394950e9d.png\"]', 1, 0, 0, NULL, NULL), (13, 'Puja', 'Gupta', '+91', '+919874563215', NULL, '2024-09-26-66f6398eb96a6.png', 2, NULL, '$2y$10$.7xHRPCXA6tDOxS9854li.W1VOR6dKvz9Y74dWmOYMGwyh8x1yuea', 0, 0, NULL, '2024-09-26 19:50:22', '2024-09-26 19:50:22', NULL, '136564', NULL, 'male', 'Intern', 0, NULL, 1, NULL, NULL, '[]', 3, 0, 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_log_histories` -- CREATE TABLE `user_log_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `ip_address` varchar(255) DEFAULT NULL, `device_id` varchar(255) DEFAULT NULL, `browser` varchar(255) DEFAULT NULL, `os` varchar(255) DEFAULT NULL, `device_model` varchar(255) DEFAULT NULL, `user_id` bigint(20) NOT NULL, `is_active` 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 `user_log_histories` -- INSERT INTO `user_log_histories` (`id`, `ip_address`, `device_id`, `browser`, `os`, `device_model`, `user_id`, `is_active`, `created_at`, `updated_at`) VALUES (1, '202.8.119.75', 'd11767b555208a60', NULL, 'android', 'google sdk_gphone64_arm64', 6, 0, '2024-05-16 20:48:30', '2024-05-16 20:49:50'), (2, '202.8.119.75', 'd11767b555208a60', NULL, 'android', 'google sdk_gphone64_arm64', 6, 0, '2024-05-16 20:49:02', '2024-05-16 20:49:50'), (3, '202.8.119.75', 'd11767b555208a60', NULL, 'android', 'google sdk_gphone64_arm64', 6, 1, '2024-05-16 20:49:50', '2024-05-16 20:49:50'), (4, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:13:26', '2024-05-17 23:31:33'), (5, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:28:36', '2024-05-17 23:31:33'), (6, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:28:43', '2024-05-17 23:31:33'), (7, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:39:29', '2024-05-17 23:31:33'), (8, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:49:39', '2024-05-17 23:31:33'), (9, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:50:43', '2024-05-17 23:31:33'), (10, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:54:13', '2024-05-17 23:31:33'), (11, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:55:20', '2024-05-17 23:31:33'), (12, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:55:56', '2024-05-17 23:31:33'), (13, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:56:44', '2024-05-17 23:31:33'), (14, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 21:57:55', '2024-05-17 23:31:33'), (15, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:00:08', '2024-05-17 23:31:33'), (16, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:01:42', '2024-05-17 23:31:33'), (17, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:02:38', '2024-05-17 23:31:33'), (18, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:04:02', '2024-05-17 23:31:33'), (19, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:05:15', '2024-05-17 23:31:33'), (20, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:05:29', '2024-05-17 23:31:33'), (21, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:06:41', '2024-05-17 23:31:33'), (22, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:07:38', '2024-05-17 23:31:33'), (23, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:08:23', '2024-05-17 23:31:33'), (24, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:09:58', '2024-05-17 23:31:33'), (25, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:10:33', '2024-05-17 23:31:33'), (26, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:11:24', '2024-05-17 23:31:33'), (27, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:12:19', '2024-05-17 23:31:33'), (28, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:13:12', '2024-05-17 23:31:33'), (29, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:16:35', '2024-05-17 23:31:33'), (30, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:17:42', '2024-05-17 23:31:33'), (31, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:18:31', '2024-05-17 23:31:33'), (32, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-16 22:21:44', '2024-05-17 23:31:33'), (33, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 22:24:48', '2024-06-16 21:46:06'), (34, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 22:50:08', '2024-06-16 21:46:06'), (35, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 22:52:10', '2024-06-16 21:46:06'), (36, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 22:55:20', '2024-06-16 21:46:06'), (37, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 22:59:13', '2024-06-16 21:46:06'), (38, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:01:04', '2024-06-16 21:46:06'), (39, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:06:35', '2024-06-16 21:46:06'), (40, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:25:11', '2024-06-16 21:46:06'), (41, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:29:00', '2024-06-16 21:46:06'), (42, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:30:20', '2024-06-16 21:46:06'), (43, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:31:24', '2024-06-16 21:46:06'), (44, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:32:54', '2024-06-16 21:46:06'), (45, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:38:05', '2024-06-16 21:46:06'), (46, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:41:04', '2024-06-16 21:46:06'), (47, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:42:17', '2024-06-16 21:46:06'), (48, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:43:45', '2024-06-16 21:46:06'), (49, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:46:03', '2024-06-16 21:46:06'), (50, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:47:11', '2024-06-16 21:46:06'), (51, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-16 23:55:00', '2024-06-16 21:46:06'), (52, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 00:05:19', '2024-06-16 21:46:06'), (53, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 00:07:25', '2024-06-16 21:46:06'), (54, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 00:09:11', '2024-06-16 21:46:06'), (55, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 00:12:02', '2024-06-16 21:46:06'), (56, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 00:55:52', '2024-06-16 21:46:06'), (57, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:26:43', '2024-06-16 21:46:06'), (58, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:29:59', '2024-06-16 21:46:06'), (59, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:37:45', '2024-06-16 21:46:06'), (60, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:40:02', '2024-06-16 21:46:06'), (61, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:45:24', '2024-06-16 21:46:06'), (62, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:49:26', '2024-06-16 21:46:06'), (63, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 01:59:16', '2024-06-16 21:46:06'), (64, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 02:12:49', '2024-06-16 21:46:06'), (65, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 02:51:38', '2024-06-16 21:46:06'), (66, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 23:07:49', '2024-06-16 21:46:06'), (67, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 0, '2024-05-17 23:08:40', '2024-06-16 21:46:06'), (68, '223.190.82.216', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-17 23:09:08', '2024-05-17 23:31:33'), (69, '223.190.82.216', '7a70fa79f82f8878', NULL, 'android', 'vivo V2253', 7, 0, '2024-05-17 23:18:09', '2024-05-17 23:31:33'), (70, '223.190.82.216', '7a70fa79f82f8878', NULL, 'android', 'vivo V2253', 7, 1, '2024-05-17 23:31:33', '2024-05-17 23:31:33'), (71, '106.219.120.185', 'c64b06fb6c70cc75', NULL, 'android', 'vivo V2253', 8, 1, '2024-06-16 21:46:06', '2024-06-16 21:46:06'); -- -------------------------------------------------------- -- -- Table structure for table `withdrawal_methods` -- CREATE TABLE `withdrawal_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `method_name` varchar(255) NOT NULL, `method_fields` 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 `withdraw_requests` -- CREATE TABLE `withdraw_requests` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `amount` double(14,2) NOT NULL DEFAULT 0.00, `admin_charge` double(14,2) NOT NULL DEFAULT 0.00, `request_status` varchar(255) NOT NULL DEFAULT 'pending', `is_paid` tinyint(1) NOT NULL DEFAULT 0, `sender_note` varchar(255) DEFAULT NULL, `admin_note` varchar(255) DEFAULT NULL, `withdrawal_method_id` bigint(20) DEFAULT NULL, `withdrawal_method_fields` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `addon_settings` -- ALTER TABLE `addon_settings` ADD PRIMARY KEY (`id`), ADD KEY `payment_settings_id_index` (`id`); -- -- Indexes for table `banners` -- ALTER TABLE `banners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bonuses` -- ALTER TABLE `bonuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `business_settings` -- ALTER TABLE `business_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contact_messages` -- ALTER TABLE `contact_messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `currencies` -- ALTER TABLE `currencies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `e_money` -- ALTER TABLE `e_money` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `funds` -- ALTER TABLE `funds` ADD PRIMARY KEY (`id`); -- -- Indexes for table `help_topics` -- ALTER TABLE `help_topics` ADD PRIMARY KEY (`id`); -- -- Indexes for table `linked_websites` -- ALTER TABLE `linked_websites` ADD PRIMARY KEY (`id`); -- -- Indexes for table `merchants` -- ALTER TABLE `merchants` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `news_letters` -- ALTER TABLE `news_letters` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `news_letters_email_unique` (`email`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_access_tokens` -- ALTER TABLE `oauth_access_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_access_tokens_user_id_index` (`user_id`); -- -- Indexes for table `oauth_auth_codes` -- ALTER TABLE `oauth_auth_codes` ADD PRIMARY KEY (`id`), ADD KEY `oauth_auth_codes_user_id_index` (`user_id`); -- -- Indexes for table `oauth_clients` -- ALTER TABLE `oauth_clients` ADD PRIMARY KEY (`id`), ADD KEY `oauth_clients_user_id_index` (`user_id`); -- -- Indexes for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_refresh_tokens` -- ALTER TABLE `oauth_refresh_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_phone_index` (`phone`); -- -- Indexes for table `payment_records` -- ALTER TABLE `payment_records` 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 `phone_verifications` -- ALTER TABLE `phone_verifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `purposes` -- ALTER TABLE `purposes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `request_money` -- ALTER TABLE `request_money` ADD PRIMARY KEY (`id`); -- -- Indexes for table `social_media` -- ALTER TABLE `social_media` ADD PRIMARY KEY (`id`); -- -- Indexes for table `soft_credentials` -- ALTER TABLE `soft_credentials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transaction_limits` -- ALTER TABLE `transaction_limits` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transfers` -- ALTER TABLE `transfers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_log_histories` -- ALTER TABLE `user_log_histories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdrawal_methods` -- ALTER TABLE `withdrawal_methods` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdraw_requests` -- ALTER TABLE `withdraw_requests` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `banners` -- ALTER TABLE `banners` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `bonuses` -- ALTER TABLE `bonuses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `business_settings` -- ALTER TABLE `business_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112; -- -- AUTO_INCREMENT for table `contact_messages` -- ALTER TABLE `contact_messages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `currencies` -- ALTER TABLE `currencies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120; -- -- AUTO_INCREMENT for table `e_money` -- ALTER TABLE `e_money` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `funds` -- ALTER TABLE `funds` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `help_topics` -- ALTER TABLE `help_topics` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `linked_websites` -- ALTER TABLE `linked_websites` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `merchants` -- ALTER TABLE `merchants` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=298; -- -- AUTO_INCREMENT for table `news_letters` -- ALTER TABLE `news_letters` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `notifications` -- ALTER TABLE `notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `oauth_clients` -- ALTER TABLE `oauth_clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `phone_verifications` -- ALTER TABLE `phone_verifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `purposes` -- ALTER TABLE `purposes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `request_money` -- ALTER TABLE `request_money` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `social_media` -- ALTER TABLE `social_media` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `soft_credentials` -- ALTER TABLE `soft_credentials` 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=25; -- -- AUTO_INCREMENT for table `transaction_limits` -- ALTER TABLE `transaction_limits` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transfers` -- ALTER TABLE `transfers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `user_log_histories` -- ALTER TABLE `user_log_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72; -- -- AUTO_INCREMENT for table `withdrawal_methods` -- ALTER TABLE `withdrawal_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `withdraw_requests` -- ALTER TABLE `withdraw_requests` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; 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 */;