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

START TRANSACTION;



--
-- Database: `qsdintsl_celeb`
--

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

--
-- Table structure for table `account_balance`
--

CREATE TABLE `account_balance` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `balance` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `screenshot_proof` blob DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `verified` tinyint(4) NOT NULL DEFAULT 0,
  `date` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `investments`
--

CREATE TABLE `investments` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `duration` varchar(50) NOT NULL,
  `plan` varchar(50) NOT NULL,
  `profit` varchar(11) NOT NULL,
  `trading` tinyint(4) NOT NULL DEFAULT 0,
  `time` varchar(25) NOT NULL,
  `date` varchar(255) NOT NULL,
  `end` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`id`, `userID`, `amount`, `duration`, `plan`, `profit`, `trading`, `time`, `date`, `end`) VALUES
(14, 86, 500, '1', 'BASIC PLAN', '50015', 0, '10:07:34', '01-12-2024', '2024-12-08 10:07:34am'),
(15, 87, 500, '1', 'BASIC PLAN', '50015', 0, '09:17:37', '03-12-2024', '2024-12-10 09:17:37am'),
(16, 88, 500, '1', 'BASIC PLAN', '50015', 0, '06:41:50', '04-12-2024', '2024-12-11 06:41:50pm'),
(17, 90, 500, '1', 'BASIC PLAN', '50015', 0, '05:09:00', '05-12-2024', '2024-12-12 05:09:00am'),
(18, 95, 500, '1', 'BASIC PLAN', '50015', 0, '03:05:52', '27-12-2024', '2025-01-03 03:05:52pm'),
(19, 96, 500, '1', 'BASIC PLAN', '50015', 0, '03:16:35', '28-12-2024', '2025-01-04 03:16:35am'),
(20, 98, 500, '1', 'BASIC PLAN', '50015', 0, '09:21:14', '06-01-2025', '2025-01-13 09:21:14am'),
(21, 94, 500, '1', 'BASIC PLAN', '50015', 0, '03:37:03', '11-01-2025', '2025-01-18 03:37:03pm'),
(22, 101, 500, '1', 'BASIC PLAN', '50015', 0, '02:37:49', '31-01-2025', '2025-02-07 02:37:49pm'),
(23, 103, 500, '1', 'BASIC PLAN', '50015', 0, '06:58:46', '11-02-2025', '2025-02-18 06:58:46pm');

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `percent` decimal(10,2) NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `name`, `percent`, `min`, `max`) VALUES
(1, 'BASIC', 14.29, 500, 1000),
(2, 'STANDARD', 21.42, 1100, 10000),
(3, 'PREMIUM', 28.57, 10100, 20000),
(4, 'EXCLUSIVE', 42.86, 20100, 1000000);

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `t_id` varchar(50) NOT NULL,
  `amount` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `transactions` (`id`, `userID`, `t_id`, `amount`, `type`, `status`, `date`) VALUES
(10, 78, '8', 10, 'WITHDRAWAL', 0, '2024-10-11 10:33:36'),
(11, 78, '8', 10, 'WITHDRAWAL', 0, '2024-10-11 10:33:59'),
(12, 78, '8', 10, 'WITHDRAWAL', 0, '2024-10-11 10:35:10'),
(13, 81, '5', 10000, 'DEPOSIT', 0, '2024-10-15 12:59:04'),
(14, 81, '6', 10000, 'DEPOSIT', 0, '2024-10-15 01:58:47'),
(15, 81, '7', 10000, 'DEPOSIT', 0, '2024-10-15 02:01:39'),
(16, 81, '8', 10000, 'DEPOSIT', 0, '2024-10-15 02:02:19'),
(17, 81, '9', 10000, 'DEPOSIT', 0, '2024-10-15 02:03:18'),
(18, 81, '10', 10000, 'DEPOSIT', 0, '2024-10-15 02:04:19'),
(19, 81, '11', 10000, 'DEPOSIT', 0, '2024-10-15 02:11:47'),
(20, 82, '12', 100, 'DEPOSIT', 0, '2024-10-27 05:39:40'),
(21, 82, '13', 100, 'DEPOSIT', 0, '2024-10-27 05:40:24'),
(22, 86, '14', 100, 'DEPOSIT', 0, '2024-12-01 09:31:05'),
(23, 86, '15', 200, 'DEPOSIT', 0, '2024-12-01 09:35:52'),
(24, 86, '16', 200, 'DEPOSIT', 0, '2024-12-01 09:36:38'),
(25, 91, '25', 4000, 'WITHDRAWAL', 0, '2024-12-05 06:22:07'),
(26, 91, '26', 4000, 'WITHDRAWAL', 0, '2024-12-05 06:22:48'),
(27, 89, '27', 5000, 'WITHDRAWAL', 0, '2024-12-05 09:05:55'),
(28, 89, '28', 5000, 'WITHDRAWAL', 0, '2024-12-05 09:07:55'),
(29, 93, '17', 100, 'DEPOSIT', 0, '2024-12-21 08:49:02');

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

--
-- Table structure for table `users_wallets`
--

CREATE TABLE `users_wallets` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `method` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `acc_name` varchar(255) DEFAULT NULL,
  `acc_no` varchar(255) DEFAULT NULL,
  `routing_no` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `qrcode` blob NOT NULL,
  `status` varchar(11) NOT NULL DEFAULT 'OFF'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallet`
--

INSERT INTO `wallet` (`id`, `name`, `address`, `qrcode`, `status`) VALUES
(1, 'Bitcoin', '', 0x6274632e706e67, 'ON'),
(2, 'Ethereum', '', 0x38374341393537302d443035442d344343312d394634392d32373238434239413035343920283129202831292e706e67, 'ON'),
(3, 'Usdt', '', '', '1'),
(4, 'Dogecoin', '', '', '1');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `method` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `acc_name` varchar(255) DEFAULT NULL,
  `acc_no` varchar(255) DEFAULT NULL,
  `swift` varchar(255) DEFAULT NULL,
  `wallet` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `time` varchar(255) DEFAULT NULL,
  `verified` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
COMMIT;

