-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 22, 2026 at 02:03 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `123_quantixflow.world`
--

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

--
-- Table structure for table `meddolic_config_country_list`
--

CREATE TABLE `meddolic_config_country_list` (
  `country_id` int(11) NOT NULL,
  `countryName` varchar(80) NOT NULL,
  `country_code` int(5) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_country_list`
--

INSERT INTO `meddolic_config_country_list` (`country_id`, `countryName`, `country_code`, `status`) VALUES
(1, 'Afghanistan', 93, 1),
(2, 'Albania', 355, 1),
(3, 'Algeria', 213, 1),
(4, 'American Samoa', 1684, 1),
(5, 'Andorra', 376, 1),
(6, 'Angola', 244, 1),
(7, 'Anguilla', 1264, 1),
(8, 'Antarctica', 0, 1),
(9, 'Antigua and Barbuda', 1268, 1),
(10, 'Argentina', 54, 1),
(11, 'Armenia', 374, 1),
(12, 'Aruba', 297, 1),
(13, 'Australia', 61, 1),
(14, 'Austria', 43, 1),
(15, 'Azerbaijan', 994, 1),
(16, 'Bahamas', 1242, 1),
(17, 'Bahrain', 973, 1),
(18, 'Bangladesh', 880, 1),
(19, 'Barbados', 1246, 1),
(20, 'Belarus', 375, 1),
(21, 'Belgium', 32, 1),
(22, 'Belize', 501, 1),
(23, 'Benin', 229, 1),
(24, 'Bermuda', 1441, 1),
(25, 'Bhutan', 975, 1),
(26, 'Bolivia', 591, 1),
(27, 'Bosnia and Herzegovina', 387, 1),
(28, 'Botswana', 267, 1),
(29, 'Bouvet Island', 0, 1),
(30, 'Brazil', 55, 1),
(31, 'British Indian Ocean Territory', 246, 1),
(32, 'Brunei Darussalam', 673, 1),
(33, 'Bulgaria', 359, 1),
(34, 'Burkina Faso', 226, 1),
(35, 'Burundi', 257, 1),
(36, 'Cambodia', 855, 1),
(37, 'Cameroon', 237, 1),
(38, 'Canada', 1, 1),
(39, 'Cape Verde', 238, 1),
(40, 'Cayman Islands', 1345, 1),
(41, 'Central African Republic', 236, 1),
(42, 'Chad', 235, 1),
(43, 'Chile', 56, 1),
(44, 'China', 86, 1),
(45, 'Christmas Island', 61, 1),
(46, 'Cocos (Keeling) Islands', 672, 1),
(47, 'Colombia', 57, 1),
(48, 'Comoros', 269, 1),
(49, 'Congo', 242, 1),
(50, 'Congo, the Democratic Republic of the', 242, 1),
(51, 'Cook Islands', 682, 1),
(52, 'Costa Rica', 506, 1),
(53, 'Cote D\'Ivoire', 225, 1),
(54, 'Croatia', 385, 1),
(55, 'Cuba', 53, 1),
(56, 'Cyprus', 357, 1),
(57, 'Czech Republic', 420, 1),
(58, 'Denmark', 45, 1),
(59, 'Djibouti', 253, 1),
(60, 'Dominica', 1767, 1),
(61, 'Dominican Republic', 1809, 1),
(62, 'Ecuador', 593, 1),
(63, 'Egypt', 20, 1),
(64, 'El Salvador', 503, 1),
(65, 'Equatorial Guinea', 240, 1),
(66, 'Eritrea', 291, 1),
(67, 'Estonia', 372, 1),
(68, 'Ethiopia', 251, 1),
(69, 'Falkland Islands (Malvinas)', 500, 1),
(70, 'Faroe Islands', 298, 1),
(71, 'Fiji', 679, 1),
(72, 'Finland', 358, 1),
(73, 'France', 33, 1),
(74, 'French Guiana', 594, 1),
(75, 'French Polynesia', 689, 1),
(76, 'French Southern Territories', 0, 1),
(77, 'Gabon', 241, 1),
(78, 'Gambia', 220, 1),
(79, 'Georgia', 995, 1),
(80, 'Germany', 49, 1),
(81, 'Ghana', 233, 1),
(82, 'Gibraltar', 350, 1),
(83, 'Greece', 30, 1),
(84, 'Greenland', 299, 1),
(85, 'Grenada', 1473, 1),
(86, 'Guadeloupe', 590, 1),
(87, 'Guam', 1671, 1),
(88, 'Guatemala', 502, 1),
(89, 'Guinea', 224, 1),
(90, 'Guinea-Bissau', 245, 1),
(91, 'Guyana', 592, 1),
(92, 'Haiti', 509, 1),
(93, 'Heard Island and Mcdonald Islands', 0, 1),
(94, 'Holy See (Vatican City State)', 39, 1),
(95, 'Honduras', 504, 1),
(96, 'Hong Kong', 852, 1),
(97, 'Hungary', 36, 1),
(98, 'Iceland', 354, 1),
(99, 'India', 91, 1),
(100, 'Indonesia', 62, 1),
(101, 'Iran, Islamic Republic of', 98, 1),
(102, 'Iraq', 964, 1),
(103, 'Ireland', 353, 1),
(104, 'Israel', 972, 1),
(105, 'Italy', 39, 1),
(106, 'Jamaica', 1876, 1),
(107, 'Japan', 81, 1),
(108, 'Jordan', 962, 1),
(109, 'Kazakhstan', 7, 1),
(110, 'Kenya', 254, 1),
(111, 'Kiribati', 686, 1),
(112, 'Korea, Democratic People\'s Republic of', 850, 1),
(113, 'Korea, Republic of', 82, 1),
(114, 'Kuwait', 965, 1),
(115, 'Kyrgyzstan', 996, 1),
(116, 'Lao People\'s Democratic Republic', 856, 1),
(117, 'Latvia', 371, 1),
(118, 'Lebanon', 961, 1),
(119, 'Lesotho', 266, 1),
(120, 'Liberia', 231, 1),
(121, 'Libyan Arab Jamahiriya', 218, 1),
(122, 'Liechtenstein', 423, 1),
(123, 'Lithuania', 370, 1),
(124, 'Luxembourg', 352, 1),
(125, 'Macao', 853, 1),
(126, 'Macedonia, the Former Yugoslav Republic of', 389, 1),
(127, 'Madagascar', 261, 1),
(128, 'Malawi', 265, 1),
(129, 'Malaysia', 60, 1),
(130, 'Maldives', 960, 1),
(131, 'Mali', 223, 1),
(132, 'Malta', 356, 1),
(133, 'Marshall Islands', 692, 1),
(134, 'Martinique', 596, 1),
(135, 'Mauritania', 222, 1),
(136, 'Mauritius', 230, 1),
(137, 'Mayotte', 269, 1),
(138, 'Mexico', 52, 1),
(139, 'Micronesia, Federated States of', 691, 1),
(140, 'Moldova, Republic of', 373, 1),
(141, 'Monaco', 377, 1),
(142, 'Mongolia', 976, 1),
(143, 'Montserrat', 1664, 1),
(144, 'Morocco', 212, 1),
(145, 'Mozambique', 258, 1),
(146, 'Myanmar', 95, 1),
(147, 'Namibia', 264, 1),
(148, 'Nauru', 674, 1),
(149, 'Nepal', 977, 1),
(150, 'Netherlands', 31, 1),
(151, 'Netherlands Antilles', 599, 1),
(152, 'New Caledonia', 687, 1),
(153, 'New Zealand', 64, 1),
(154, 'Nicaragua', 505, 1),
(155, 'Niger', 227, 1),
(156, 'Nigeria', 234, 1),
(157, 'Niue', 683, 1),
(158, 'Norfolk Island', 672, 1),
(159, 'Northern Mariana Islands', 1670, 1),
(160, 'Norway', 47, 1),
(161, 'Oman', 968, 1),
(162, 'Pakistan', 92, 1),
(163, 'Palau', 680, 1),
(164, 'Palestinian Territory, Occupied', 970, 1),
(165, 'Panama', 507, 1),
(166, 'Papua New Guinea', 675, 1),
(167, 'Paraguay', 595, 1),
(168, 'Peru', 51, 1),
(169, 'Philippines', 63, 1),
(170, 'Pitcairn', 0, 1),
(171, 'Poland', 48, 1),
(172, 'Portugal', 351, 1),
(173, 'Puerto Rico', 1787, 1),
(174, 'Qatar', 974, 1),
(175, 'Reunion', 262, 1),
(176, 'Romania', 40, 1),
(177, 'Russian Federation', 70, 1),
(178, 'Rwanda', 250, 1),
(179, 'Saint Helena', 290, 1),
(180, 'Saint Kitts and Nevis', 1869, 1),
(181, 'Saint Lucia', 1758, 1),
(182, 'Saint Pierre and Miquelon', 508, 1),
(183, 'Saint Vincent and the Grenadines', 1784, 1),
(184, 'Samoa', 684, 1),
(185, 'San Marino', 378, 1),
(186, 'Sao Tome and Principe', 239, 1),
(187, 'Saudi Arabia', 966, 1),
(188, 'Senegal', 221, 1),
(189, 'Serbia and Montenegro', 381, 1),
(190, 'Seychelles', 248, 1),
(191, 'Sierra Leone', 232, 1),
(192, 'Singapore', 65, 1),
(193, 'Slovakia', 421, 1),
(194, 'Slovenia', 386, 1),
(195, 'Solomon Islands', 677, 1),
(196, 'Somalia', 252, 1),
(197, 'South Africa', 27, 1),
(198, 'South Georgia and the South Sandwich Islands', 0, 1),
(199, 'Spain', 34, 1),
(200, 'Sri Lanka', 94, 1),
(201, 'Sudan', 249, 1),
(202, 'Suriname', 597, 1),
(203, 'Svalbard and Jan Mayen', 47, 1),
(204, 'Swaziland', 268, 1),
(205, 'Sweden', 46, 1),
(206, 'Switzerland', 41, 1),
(207, 'Syrian Arab Republic', 963, 1),
(208, 'Taiwan, Province of China', 886, 1),
(209, 'Tajikistan', 992, 1),
(210, 'Tanzania, United Republic of', 255, 1),
(211, 'Thailand', 66, 1),
(212, 'Timor-Leste', 670, 1),
(213, 'Togo', 228, 1),
(214, 'Tokelau', 690, 1),
(215, 'Tonga', 676, 1),
(216, 'Trinidad and Tobago', 1868, 1),
(217, 'Tunisia', 216, 1),
(218, 'Turkey', 90, 1),
(219, 'Turkmenistan', 7370, 1),
(220, 'Turks and Caicos Islands', 1649, 1),
(221, 'Tuvalu', 688, 1),
(222, 'Uganda', 256, 1),
(223, 'Ukraine', 380, 1),
(224, 'United Arab Emirates', 971, 1),
(225, 'United Kingdom', 44, 1),
(226, 'United States', 1, 1),
(227, 'United States Minor Outlying Islands', 1, 1),
(228, 'Uruguay', 598, 1),
(229, 'Uzbekistan', 998, 1),
(230, 'Vanuatu', 678, 1),
(231, 'Venezuela', 58, 1),
(232, 'Viet Nam', 84, 1),
(233, 'Virgin Islands, British', 1284, 1),
(234, 'Virgin Islands, U.s.', 1340, 1),
(235, 'Wallis and Futuna', 681, 1),
(236, 'Western Sahara', 212, 1),
(237, 'Yemen', 967, 1),
(238, 'Zambia', 260, 1),
(239, 'Zimbabwe', 263, 1);

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

--
-- Table structure for table `meddolic_config_currency_list`
--

CREATE TABLE `meddolic_config_currency_list` (
  `currency_id` int(11) NOT NULL,
  `currencyName` text DEFAULT NULL,
  `currencyCode` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `withdrawStatus` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_config_currency_list`
--

INSERT INTO `meddolic_config_currency_list` (`currency_id`, `currencyName`, `currencyCode`, `status`, `withdrawStatus`) VALUES
(1, 'TRON', 'TRX', 0, 0),
(2, 'MATIC', 'MATIC', 0, 0),
(3, 'BNB Smart Chain (Bep 20)', 'BNBBSC', 0, 0),
(4, 'SHIBA INU', 'SHIB', 0, 0),
(5, 'USDT TRC20', 'USDTTRC20', 0, 0),
(6, 'USDT-BEP20', 'USDT-BEP20', 1, 1);

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

--
-- Table structure for table `meddolic_config_direct_income`
--

CREATE TABLE `meddolic_config_direct_income` (
  `level` int(11) NOT NULL,
  `levelPercent` decimal(10,2) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_direct_income`
--

INSERT INTO `meddolic_config_direct_income` (`level`, `levelPercent`, `status`) VALUES
(1, 10.00, 1),
(2, 5.00, 1);

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

--
-- Table structure for table `meddolic_config_level_income`
--

CREATE TABLE `meddolic_config_level_income` (
  `level` int(11) NOT NULL,
  `levelPercent` decimal(10,2) NOT NULL,
  `directNeed` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_level_income`
--

INSERT INTO `meddolic_config_level_income` (`level`, `levelPercent`, `directNeed`, `status`) VALUES
(1, 15.00, 1, 1),
(2, 10.00, 3, 1),
(3, 5.00, 5, 1),
(4, 4.00, 7, 1),
(5, 3.00, 8, 1),
(6, 2.00, 10, 1),
(7, 1.00, 12, 1),
(8, 1.00, 13, 1),
(9, 1.00, 14, 1),
(10, 1.00, 15, 1);

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

--
-- Table structure for table `meddolic_config_misc_setting`
--

CREATE TABLE `meddolic_config_misc_setting` (
  `id` int(11) NOT NULL,
  `botReferralPercent` decimal(10,2) NOT NULL DEFAULT 0.00,
  `referralPercent` decimal(10,2) NOT NULL DEFAULT 0.00,
  `roiPercent` decimal(10,2) NOT NULL DEFAULT 0.00,
  `fundCharge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `withdrawCharge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `minimumWithdraw` decimal(10,2) NOT NULL,
  `maximum_withdraw` decimal(10,2) NOT NULL,
  `minTransfer` decimal(10,0) NOT NULL,
  `incomeToFund` decimal(10,2) NOT NULL DEFAULT 0.00,
  `dashboardImage` text DEFAULT NULL,
  `imageStatus` int(11) NOT NULL DEFAULT 0,
  `loginEmailId` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_misc_setting`
--

INSERT INTO `meddolic_config_misc_setting` (`id`, `botReferralPercent`, `referralPercent`, `roiPercent`, `fundCharge`, `withdrawCharge`, `minimumWithdraw`, `maximum_withdraw`, `minTransfer`, `incomeToFund`, `dashboardImage`, `imageStatus`, `loginEmailId`) VALUES
(1, 30.00, 20.00, 1.00, 0.00, 5.00, 10.00, 0.00, 1, 5.00, 'assets/SupportFile/NoticeImage-6a840761bd7411.00835125.png', 0, NULL);

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

--
-- Table structure for table `meddolic_config_news_list`
--

CREATE TABLE `meddolic_config_news_list` (
  `newsId` int(11) NOT NULL,
  `news` text NOT NULL,
  `addDate` datetime NOT NULL,
  `newStatus` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_news_list`
--

INSERT INTO `meddolic_config_news_list` (`newsId`, `news`, `addDate`, `newStatus`) VALUES
(1, 'Welcome Tron 100 payment gateway work ', '2022-11-18 20:17:59', 0),
(2, 'gfhjfg', '2025-07-09 10:30:29', 0),
(3, 'Welcome To Bit Global', '2025-08-18 15:45:43', 0),
(4, 'Hy Everyone coming soon', '2025-08-20 02:40:14', 0),
(5, 'WELCOME TO BLUE WHALE CRYPTO', '2026-02-21 12:59:48', 0),
(6, 'hello well come blue whale', '2026-02-21 15:00:28', 0),
(7, 'wellcome  wellcome \r\n', '2026-02-21 15:07:02', 0),
(8, 'wellcome', '2026-02-27 10:05:48', 0),
(9, 'DGEARNGALOBALAI TOP EARNER MG SIR CHANDIGARH DAILY INCOME 60$', '2026-05-20 08:51:27', 0),
(10, 'WELCOME TO DGEARNGALOBALAI ', '2026-05-20 08:53:52', 0),
(11, 'WELCOME TO MARA TRADE x', '2026-08-18 13:00:02', 0),
(12, 'Welcome To Quantix Flow', '2026-09-22 09:31:58', 1);

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

--
-- Table structure for table `meddolic_config_payment_details`
--

CREATE TABLE `meddolic_config_payment_details` (
  `payment_id` int(11) NOT NULL,
  `paymentName` text DEFAULT NULL,
  `paymentAddress` text DEFAULT NULL,
  `paymentImage` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_config_payment_details`
--

INSERT INTO `meddolic_config_payment_details` (`payment_id`, `paymentName`, `paymentAddress`, `paymentImage`, `status`) VALUES
(1, 'NA', 'dcgdsh', 'assets/SupportFile/QRImage-63c93f81ef5b99.93535145.jpg', 0),
(2, 'GURU MONEY BUSINESS', 'QR CODE Payment Accept', 'assets/SupportFile/QRImage-63ca516f5b01f8.07605190.jpg', 0),
(3, 'QR CODE PAYMENT ACCPECT ', 'GURU MONEY BUSINESS ', 'assets/SupportFile/QRImage-63ca54c7d3c047.42263862.jpg', 0),
(4, 'INR MODE ', 'abcd ', 'assets/SupportFile/QRImage-64c0ab536a2445.01442032.jpg', 0),
(5, 'INR Deposit', 'sschandradairyyudog5679@barodampay', 'assets/SupportFile/QRImage-6525398dd5c268.94225332.jpeg', 0),
(6, 'INR MODE ', 'sschandradairyyudog5679@barodampay', 'assets/SupportFile/QRImage-652d10bc170bf6.63418247.jpg', 0),
(7, 'Qr', 'Bright income ', 'assets/SupportFile/QRImage-6546186eceecc7.78650817.jpg', 0),
(8, 'Qr ', 'Bright income in organic advertising ', 'assets/SupportFile/QRImage-654619547e2ea6.79520199.jpg', 0),
(9, 'QR', 'Bright income in organic ', 'assets/SupportFile/QRImage-654619bfc9fc26.33732013.jpg', 0),
(10, 'QR', 'Bright income in advertising and organic ', 'assets/SupportFile/QRImage-65463d74305864.68656370.jpg', 0),
(11, 'QR code ', 'Bright income in organic and advertising ', 'assets/SupportFile/QRImage-654652a88582e4.46828564.jpg', 0),
(12, 'QR code ', 'Bright income in organic and advertising ', 'assets/SupportFile/QRImage-654653baf3e8f8.00137341.jpg', 0),
(13, 'QR code ', 'Bright income in organic and advertising ', 'assets/SupportFile/QRImage-65465445e4da26.80418043.jpg', 0),
(14, 'QR code ', 'Bright income in organic and advertising ', 'assets/SupportFile/QRImage-654654d0743b34.93944860.jpg', 0),
(15, 'Bank acount', 'Hdfc bank', 'assets/SupportFile/QRImage-6576d716b414e0.21247144.jpg', 0),
(16, 'Bank acount', 'BRIGHT INCOME ', 'assets/SupportFile/QRImage-65819a62e19b61.53786365.jpg', 0),
(17, 'Bank acount', 'BRIGHT INCOME     \r\n25770210001653\r\nIfsc - UCBA0002577\r\n', 'assets/SupportFile/QRImage-65819b4211b1d5.08950763.jpg', 0),
(18, 'Bank acount', 'BRIGHT INCOME\r\n25770210001653\r\nUCBA0002577', 'assets/SupportFile/QRImage-65819bc4045dd6.09928342.jpg', 0),
(19, 'QR', 'Bright income in organic', 'assets/SupportFile/QRImage-65829d2d9327c0.99578955.jpg', 0),
(20, 'Account no', 'Bright income in organic', 'assets/SupportFile/QRImage-659e8803bd38e9.08989091.jpg', 0),
(21, 'UPI', 'pay', 'assets/SupportFile/QRImage-668e1cab3355c9.60867539.jpg', 0),
(22, 'BEP20', 'hj;h;klhf;kjhsa;lkjhfkljdskljfhdkljhf', 'assets/SupportFile/QRImage-66f4f7d21772c0.94682209.jpeg', 0),
(23, 'USDT BEP20', '0x6214a918628c7cf61adc70CD543d69bf0c1f1a91', 'assets/SupportFile/QRImage-6718e6aa1bed02.32799497.jpeg', 0),
(24, 'INR', 'battlemoney@upi', 'assets/SupportFile/QRImage-6718e7918a69a7.22780727.jpeg', 0),
(25, 'USDT BEP20', '0x4c084E5A00c5d42D19652fCAFf7db587047d53F6', 'assets/SupportFile/QRImage-673377ca903fe5.12759425.jpeg', 0),
(26, 'USDT', 'USDT', 'assets/SupportFile/QRImage-68639d6d499294.29962788.jpg', 0),
(27, 'QR CODE', 'QR CODE DETAILS', 'assets/SupportFile/QRImage-6a054d8aa56165.48450712.jpg', 0),
(28, 'QR CODE', 'QR CODE DETAILS', 'assets/SupportFile/QRImage-6a08890bcf7324.68652253.jpg', 0),
(29, 'QRQ', 'QR', NULL, 0),
(30, 'QRQ', 'DDD', 'assets/SupportFile/QRImage-6a3cbee2dc5fb8.66101049.jpg', 0),
(31, 'QRQ', 'ASD', NULL, 0),
(32, 'USDTBP20', 'asdfghjmk,', 'assets/SupportFile/QRImage-6a82b8c954d9d5.48189427.png', 1);

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

--
-- Table structure for table `meddolic_config_reward_income`
--

CREATE TABLE `meddolic_config_reward_income` (
  `rewardId` int(11) NOT NULL,
  `firstLeg` decimal(20,2) NOT NULL,
  `secondLeg` decimal(20,2) NOT NULL,
  `otherLeg` decimal(20,2) NOT NULL,
  `totalBusiness` decimal(20,2) NOT NULL DEFAULT 0.00,
  `rewardIncome` decimal(20,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_config_reward_income`
--

INSERT INTO `meddolic_config_reward_income` (`rewardId`, `firstLeg`, `secondLeg`, `otherLeg`, `totalBusiness`, `rewardIncome`) VALUES
(1, 2000.00, 1500.00, 1500.00, 5000.00, 50.00),
(2, 4000.00, 3000.00, 3000.00, 10000.00, 100.00),
(3, 10000.00, 7500.00, 7500.00, 25000.00, 200.00),
(4, 20000.00, 15000.00, 15000.00, 50000.00, 500.00),
(5, 40000.00, 30000.00, 30000.00, 100000.00, 1000.00),
(6, 100000.00, 75000.00, 75000.00, 250000.00, 2500.00),
(7, 200000.00, 150000.00, 150000.00, 500000.00, 5000.00),
(8, 400000.00, 300000.00, 300000.00, 1000000.00, 10000.00),
(9, 1000000.00, 750000.00, 750000.00, 5000000.00, 25000.00),
(10, 2000000.00, 15000000.00, 15000000.00, 5000000.00, 50000.00),
(11, 40000000.00, 30000000.00, 30000000.00, 10000000.00, 100000.00);

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

--
-- Table structure for table `meddolic_config_support_priority`
--

CREATE TABLE `meddolic_config_support_priority` (
  `priorityId` int(11) NOT NULL,
  `priorityName` text DEFAULT NULL,
  `priorityStatus` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_config_support_priority`
--

INSERT INTO `meddolic_config_support_priority` (`priorityId`, `priorityName`, `priorityStatus`) VALUES
(1, 'Urgent', 1),
(2, 'High', 1),
(3, 'Normal/Minor Impact', 1),
(4, 'Low/Informational', 1);

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

--
-- Table structure for table `meddolic_config_support_subject`
--

CREATE TABLE `meddolic_config_support_subject` (
  `subjectId` int(11) NOT NULL,
  `subjectName` text DEFAULT NULL,
  `subjectStatus` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_config_support_subject`
--

INSERT INTO `meddolic_config_support_subject` (`subjectId`, `subjectName`, `subjectStatus`) VALUES
(1, 'General', 1),
(2, 'Financial', 1),
(3, 'Withdrawal', 1),
(4, 'Other', 1);

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

--
-- Table structure for table `meddolic_config_wallet_statement_type`
--

CREATE TABLE `meddolic_config_wallet_statement_type` (
  `wallet_statement_id` int(11) NOT NULL,
  `statement_type` text NOT NULL,
  `wallet_remark` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_config_wallet_statement_type`
--

INSERT INTO `meddolic_config_wallet_statement_type` (`wallet_statement_id`, `statement_type`, `wallet_remark`) VALUES
(1, 'LEVEL INCOME', 'Wallet Credited on Level On ROI  Income Release.'),
(2, 'SALARY INCOME', 'Wallet Credited on Salary Income Released.'),
(3, 'DIRECT INCOME', 'Wallet Credited on Direct Income Released.'),
(4, 'PASSIVE INCOME', 'Wallet Credited on Passive Income Released'),
(5, 'FUND TRANSFER', 'Fund Wallet Debited on Fund transfer.'),
(6, 'FUND RECEIVED', 'Fund Wallet Credited on Fund Receiver by Wallet transfer.'),
(7, 'WALLET ADDED', 'Wallet Balance Added Through Online Payment.'),
(8, 'PACKAGE PURCHASE', 'Fund Wallet Debited on Package Purchase.'),
(9, 'WALLET TRANSFER', 'Main Wallet Debited on Fund Transfer to Fund Wallet.'),
(10, 'WALLET WITHDRAWAL', 'Wallet debited on Wallet Withdrawal Request'),
(11, 'WALLET WITHDRAWAL REJECTED', 'Wallet Credited on Wallet Withdrawal Request Rejected.'),
(12, 'CASHBACK INCOME', 'Wallet Credited on ROI Income Released.');

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

--
-- Table structure for table `meddolic_user_cashback_income_details`
--

CREATE TABLE `meddolic_user_cashback_income_details` (
  `id` int(11) NOT NULL,
  `summary_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `incomeAmount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `packageAmount` int(11) NOT NULL,
  `date_time` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1-Released,0-panding\r\n'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_user_cashback_income_details`
--

INSERT INTO `meddolic_user_cashback_income_details` (`id`, `summary_id`, `member_id`, `incomeAmount`, `packageAmount`, `date_time`, `status`) VALUES
(1, 1, 2, 0.10, 10, '2026-09-22 17:27:25', 1),
(2, 1, 2, 0.10, 10, '2026-09-22 17:27:26', 1),
(3, 1, 2, 0.10, 10, '2026-09-22 17:27:41', 1),
(4, 1, 2, 0.10, 10, '2026-09-22 17:27:42', 1),
(5, 1, 2, 0.10, 10, '2026-09-22 17:29:24', 1),
(6, 1, 2, 0.10, 10, '2026-09-22 17:29:24', 1),
(7, 1, 2, 0.10, 10, '2026-09-22 17:30:38', 1),
(8, 1, 2, 0.10, 10, '2026-09-22 17:30:38', 1);

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

--
-- Table structure for table `meddolic_user_cashback_income_summary`
--

CREATE TABLE `meddolic_user_cashback_income_summary` (
  `summary_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `incomeAmount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `roiPercent` decimal(10,2) NOT NULL DEFAULT 0.00,
  `packagePrice` decimal(10,2) NOT NULL DEFAULT 0.00,
  `date_time` datetime DEFAULT NULL,
  `dueDate` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1=running,0=stop'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_user_cashback_income_summary`
--

INSERT INTO `meddolic_user_cashback_income_summary` (`summary_id`, `member_id`, `incomeAmount`, `roiPercent`, `packagePrice`, `date_time`, `dueDate`, `status`) VALUES
(1, 2, 0.10, 1.00, 10.00, '2026-09-22 17:25:35', '2025-09-22 18:35:35', 1);

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

--
-- Table structure for table `meddolic_user_child_ids`
--

CREATE TABLE `meddolic_user_child_ids` (
  `id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `child_id` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `legPosition` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `topup_status` int(11) NOT NULL DEFAULT 0 COMMENT '0-Not-Active,1-Active',
  `topup_date` datetime DEFAULT NULL,
  `goldStatus` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_user_child_ids`
--

INSERT INTO `meddolic_user_child_ids` (`id`, `member_id`, `child_id`, `level`, `legPosition`, `date_time`, `topup_status`, `topup_date`, `goldStatus`) VALUES
(1, 1, 2, 1, 0, '2026-09-22 17:23:32', 1, '2026-09-22 17:25:35', 0);

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

--
-- Table structure for table `meddolic_user_details`
--

CREATE TABLE `meddolic_user_details` (
  `member_id` int(11) NOT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  `name` text NOT NULL,
  `walletAddress` varchar(255) NOT NULL,
  `phone` text NOT NULL,
  `email_id` text DEFAULT NULL,
  `password` text NOT NULL,
  `trnPassword` text DEFAULT NULL,
  `sponser_id` int(11) NOT NULL,
  `placeholderId` int(11) NOT NULL DEFAULT 0,
  `placeholderIdGold` int(11) NOT NULL DEFAULT 0,
  `legPosition` int(11) NOT NULL DEFAULT 0,
  `directPlace` int(11) DEFAULT NULL,
  `topup_flag` int(11) NOT NULL DEFAULT 0,
  `user_type` int(11) NOT NULL DEFAULT 2 COMMENT '1-Admin,2-Member',
  `date_time` datetime NOT NULL,
  `activation_date` datetime DEFAULT NULL,
  `fundWallet` decimal(10,2) NOT NULL DEFAULT 0.00,
  `wallet` decimal(10,2) NOT NULL DEFAULT 0.00,
  `account_status` int(11) DEFAULT 1 COMMENT '1=Active,0=InActive',
  `rewardRank` int(11) NOT NULL DEFAULT 0,
  `countryId` int(11) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `previous_login` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_user_details`
--

INSERT INTO `meddolic_user_details` (`member_id`, `user_id`, `name`, `walletAddress`, `phone`, `email_id`, `password`, `trnPassword`, `sponser_id`, `placeholderId`, `placeholderIdGold`, `legPosition`, `directPlace`, `topup_flag`, `user_type`, `date_time`, `activation_date`, `fundWallet`, `wallet`, `account_status`, `rewardRank`, `countryId`, `last_login`, `previous_login`) VALUES
(1, 'QF112233', 'ADMIN', 'ABCD', '7676767676', 'maratradex@support.world', '123456', '123456', 0, 0, 0, 0, NULL, 0, 1, '2021-04-27 13:13:35', NULL, 0.00, 0.00, 1, 0, NULL, '2026-09-22 11:08:04', '2026-09-22 09:24:42'),
(2, 'QF47625', 'ivpT1L1', '', '117894561236', 'this1@this.com', '1', '1', 1, 0, 0, 0, NULL, 1, 2, '2026-09-22 17:23:32', '2026-09-22 17:25:35', 9990.00, 0.80, 1, 0, 16, NULL, NULL);

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

--
-- Table structure for table `meddolic_user_direct_income`
--

CREATE TABLE `meddolic_user_direct_income` (
  `id` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `childId` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `levelIncome` decimal(10,2) NOT NULL,
  `packagePrice` decimal(10,2) NOT NULL,
  `levelPercent` decimal(5,2) NOT NULL,
  `dateTime` datetime NOT NULL,
  `status` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_fund_deduct_history`
--

CREATE TABLE `meddolic_user_fund_deduct_history` (
  `id` int(11) NOT NULL,
  `sender_member_id` int(11) NOT NULL,
  `receiver_member_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `date_time` datetime DEFAULT NULL,
  `wallet_type` varchar(20) NOT NULL,
  `action_type` varchar(20) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_fund_request`
--

CREATE TABLE `meddolic_user_fund_request` (
  `id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `name` text NOT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  `requestFund` decimal(10,2) NOT NULL,
  `paymentDate` date DEFAULT NULL,
  `paymentHash` text DEFAULT NULL,
  `paymentRemark` text DEFAULT NULL,
  `transactionImage` text NOT NULL,
  `date_time` datetime NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0-Pending,1-Approved,2-Reject',
  `payment_id` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `meddolic_user_fund_transfer_history`
--

CREATE TABLE `meddolic_user_fund_transfer_history` (
  `id` int(11) NOT NULL,
  `sender_member_id` int(11) NOT NULL,
  `receiver_member_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `date_time` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_income_wallet_transfer`
--

CREATE TABLE `meddolic_user_income_wallet_transfer` (
  `id` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `transferAmount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transferCharge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `depositAmount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transferDate` datetime DEFAULT NULL,
  `incomeWallet` decimal(10,2) NOT NULL DEFAULT 0.00,
  `fundWallet` decimal(10,2) NOT NULL DEFAULT 0.00,
  `releaseDate` date DEFAULT NULL,
  `releaseStatus` int(11) NOT NULL DEFAULT 0 COMMENT '0-No,1-Yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_invest_history`
--

CREATE TABLE `meddolic_user_invest_history` (
  `investId` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `sponserId` int(11) NOT NULL,
  `loginMemberId` int(11) NOT NULL,
  `investAmount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `dateTime` datetime DEFAULT NULL,
  `investStatus` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `meddolic_user_invest_history`
--

INSERT INTO `meddolic_user_invest_history` (`investId`, `memberId`, `sponserId`, `loginMemberId`, `investAmount`, `dateTime`, `investStatus`) VALUES
(1, 2, 1, 2, 10.00, '2026-09-22 17:25:35', 1);

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

--
-- Table structure for table `meddolic_user_invest_purchase_details`
--

CREATE TABLE `meddolic_user_invest_purchase_details` (
  `tempId` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `loginMemberId` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `emailId` text DEFAULT NULL,
  `packagePrice` decimal(10,2) NOT NULL DEFAULT 0.00,
  `addDate` datetime DEFAULT NULL,
  `orderId` text DEFAULT NULL,
  `priceAmount` text DEFAULT NULL,
  `priceCurrency` text DEFAULT NULL,
  `payAmount` text DEFAULT NULL,
  `payCurrency` text DEFAULT NULL,
  `amountReceived` text DEFAULT NULL,
  `paymentId` int(11) DEFAULT NULL,
  `paymentStatus` text DEFAULT NULL,
  `payAddress` text DEFAULT NULL,
  `createdTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `purchaseId` text DEFAULT NULL,
  `actionTaken` int(11) NOT NULL DEFAULT 0 COMMENT '0-No,1-Yes',
  `actionType` int(11) NOT NULL DEFAULT 1 COMMENT '1-Invest,2-Fund Add',
  `nextPayOpen` int(11) NOT NULL DEFAULT 0 COMMENT '0-No,1-Yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_level_on_roi_income`
--

CREATE TABLE `meddolic_user_level_on_roi_income` (
  `id` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `childId` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `levelIncome` decimal(10,2) NOT NULL,
  `packagePrice` decimal(10,2) NOT NULL,
  `levelPercent` decimal(5,2) NOT NULL,
  `dateTime` datetime NOT NULL,
  `status` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_support_ticket`
--

CREATE TABLE `meddolic_user_support_ticket` (
  `ticketId` int(11) NOT NULL,
  `memberId` int(11) NOT NULL,
  `ticketCode` varchar(50) DEFAULT NULL,
  `subjectId` int(11) NOT NULL,
  `priorityId` int(11) NOT NULL,
  `ticketMessage` text DEFAULT NULL,
  `adminMessage` text DEFAULT NULL,
  `raiseDate` datetime DEFAULT NULL,
  `actionDate` datetime DEFAULT NULL,
  `ticketStatus` int(11) NOT NULL DEFAULT 1 COMMENT '1-Open,2-Processing,3-Completed',
  `actionBy` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_wallet_address_details`
--

CREATE TABLE `meddolic_user_wallet_address_details` (
  `payment_id` int(11) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `walletAddress` text DEFAULT NULL,
  `addDate` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `meddolic_user_wallet_statement`
--

CREATE TABLE `meddolic_user_wallet_statement` (
  `wallet_st_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `wallet_statement_id` int(11) NOT NULL,
  `deb_cr` int(11) NOT NULL,
  `amount` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `date_time` datetime DEFAULT NULL,
  `trn_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `meddolic_user_wallet_statement`
--

INSERT INTO `meddolic_user_wallet_statement` (`wallet_st_id`, `member_id`, `wallet_statement_id`, `deb_cr`, `amount`, `date_time`, `trn_id`) VALUES
(1, 2, 8, 1, 10.0000, '2026-09-22 17:25:35', 1),
(2, 2, 12, 2, 0.1000, '2026-09-22 17:27:25', 1),
(3, 2, 12, 2, 0.1000, '2026-09-22 17:27:26', 2),
(4, 2, 12, 2, 0.1000, '2026-09-22 17:27:41', 3),
(5, 2, 12, 2, 0.1000, '2026-09-22 17:27:42', 4),
(6, 2, 12, 2, 0.1000, '2026-09-22 17:29:24', 5),
(7, 2, 12, 2, 0.1000, '2026-09-22 17:29:24', 6),
(8, 2, 12, 2, 0.1000, '2026-09-22 17:30:38', 7),
(9, 2, 12, 2, 0.1000, '2026-09-22 17:30:38', 8);

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

--
-- Table structure for table `meddolic_user_wallet_withdrawal_crypto`
--

CREATE TABLE `meddolic_user_wallet_withdrawal_crypto` (
  `id` int(11) NOT NULL,
  `withdrawal_date` datetime NOT NULL DEFAULT current_timestamp(),
  `member_id` int(11) NOT NULL,
  `payout_date` date DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `amount` decimal(10,8) NOT NULL,
  `upiId` int(11) DEFAULT NULL,
  `withdrawCharge` decimal(10,8) NOT NULL DEFAULT 0.00000000,
  `netAmount` decimal(10,8) NOT NULL DEFAULT 0.00000000,
  `released` int(11) NOT NULL DEFAULT 0 COMMENT '0=NotApproved,1=Approved,2=Reject,3=Released,4=NotReleased',
  `payment_date` datetime DEFAULT NULL,
  `paymentId` int(11) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `cancel_by` int(11) DEFAULT NULL,
  `orderid` text DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `withdrwalIn` int(11) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `txHash` text DEFAULT NULL,
  `address` text NOT NULL,
  `trnxId` text DEFAULT NULL,
  `currency` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `meddolic_config_country_list`
--
ALTER TABLE `meddolic_config_country_list`
  ADD PRIMARY KEY (`country_id`);

--
-- Indexes for table `meddolic_config_currency_list`
--
ALTER TABLE `meddolic_config_currency_list`
  ADD PRIMARY KEY (`currency_id`);

--
-- Indexes for table `meddolic_config_direct_income`
--
ALTER TABLE `meddolic_config_direct_income`
  ADD PRIMARY KEY (`level`);

--
-- Indexes for table `meddolic_config_level_income`
--
ALTER TABLE `meddolic_config_level_income`
  ADD PRIMARY KEY (`level`);

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

--
-- Indexes for table `meddolic_config_news_list`
--
ALTER TABLE `meddolic_config_news_list`
  ADD PRIMARY KEY (`newsId`);

--
-- Indexes for table `meddolic_config_reward_income`
--
ALTER TABLE `meddolic_config_reward_income`
  ADD PRIMARY KEY (`rewardId`);

--
-- Indexes for table `meddolic_config_support_priority`
--
ALTER TABLE `meddolic_config_support_priority`
  ADD PRIMARY KEY (`priorityId`);

--
-- Indexes for table `meddolic_config_support_subject`
--
ALTER TABLE `meddolic_config_support_subject`
  ADD PRIMARY KEY (`subjectId`);

--
-- Indexes for table `meddolic_config_wallet_statement_type`
--
ALTER TABLE `meddolic_config_wallet_statement_type`
  ADD PRIMARY KEY (`wallet_statement_id`);

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

--
-- Indexes for table `meddolic_user_cashback_income_summary`
--
ALTER TABLE `meddolic_user_cashback_income_summary`
  ADD PRIMARY KEY (`summary_id`);

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

--
-- Indexes for table `meddolic_user_details`
--
ALTER TABLE `meddolic_user_details`
  ADD PRIMARY KEY (`member_id`);

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

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

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

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

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

--
-- Indexes for table `meddolic_user_invest_history`
--
ALTER TABLE `meddolic_user_invest_history`
  ADD PRIMARY KEY (`investId`);

--
-- Indexes for table `meddolic_user_invest_purchase_details`
--
ALTER TABLE `meddolic_user_invest_purchase_details`
  ADD PRIMARY KEY (`tempId`);

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

--
-- Indexes for table `meddolic_user_support_ticket`
--
ALTER TABLE `meddolic_user_support_ticket`
  ADD PRIMARY KEY (`ticketId`);

--
-- Indexes for table `meddolic_user_wallet_address_details`
--
ALTER TABLE `meddolic_user_wallet_address_details`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `meddolic_user_wallet_statement`
--
ALTER TABLE `meddolic_user_wallet_statement`
  ADD PRIMARY KEY (`wallet_st_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `meddolic_config_country_list`
--
ALTER TABLE `meddolic_config_country_list`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

--
-- AUTO_INCREMENT for table `meddolic_config_currency_list`
--
ALTER TABLE `meddolic_config_currency_list`
  MODIFY `currency_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `meddolic_config_direct_income`
--
ALTER TABLE `meddolic_config_direct_income`
  MODIFY `level` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `meddolic_config_level_income`
--
ALTER TABLE `meddolic_config_level_income`
  MODIFY `level` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `meddolic_config_misc_setting`
--
ALTER TABLE `meddolic_config_misc_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `meddolic_config_news_list`
--
ALTER TABLE `meddolic_config_news_list`
  MODIFY `newsId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `meddolic_config_reward_income`
--
ALTER TABLE `meddolic_config_reward_income`
  MODIFY `rewardId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `meddolic_config_support_priority`
--
ALTER TABLE `meddolic_config_support_priority`
  MODIFY `priorityId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `meddolic_config_support_subject`
--
ALTER TABLE `meddolic_config_support_subject`
  MODIFY `subjectId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `meddolic_config_wallet_statement_type`
--
ALTER TABLE `meddolic_config_wallet_statement_type`
  MODIFY `wallet_statement_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `meddolic_user_cashback_income_details`
--
ALTER TABLE `meddolic_user_cashback_income_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `meddolic_user_cashback_income_summary`
--
ALTER TABLE `meddolic_user_cashback_income_summary`
  MODIFY `summary_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `meddolic_user_child_ids`
--
ALTER TABLE `meddolic_user_child_ids`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `meddolic_user_details`
--
ALTER TABLE `meddolic_user_details`
  MODIFY `member_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `meddolic_user_direct_income`
--
ALTER TABLE `meddolic_user_direct_income`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_fund_deduct_history`
--
ALTER TABLE `meddolic_user_fund_deduct_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_fund_request`
--
ALTER TABLE `meddolic_user_fund_request`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_fund_transfer_history`
--
ALTER TABLE `meddolic_user_fund_transfer_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_income_wallet_transfer`
--
ALTER TABLE `meddolic_user_income_wallet_transfer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_invest_history`
--
ALTER TABLE `meddolic_user_invest_history`
  MODIFY `investId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `meddolic_user_invest_purchase_details`
--
ALTER TABLE `meddolic_user_invest_purchase_details`
  MODIFY `tempId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_level_on_roi_income`
--
ALTER TABLE `meddolic_user_level_on_roi_income`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_support_ticket`
--
ALTER TABLE `meddolic_user_support_ticket`
  MODIFY `ticketId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_wallet_address_details`
--
ALTER TABLE `meddolic_user_wallet_address_details`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meddolic_user_wallet_statement`
--
ALTER TABLE `meddolic_user_wallet_statement`
  MODIFY `wallet_st_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `meddolic_user_wallet_withdrawal_crypto`
--
ALTER TABLE `meddolic_user_wallet_withdrawal_crypto`
  MODIFY `id` int(11) 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 */;