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

START TRANSACTION;



--
-- Database: `bezomzdw_stash`
--

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

--
-- Table structure for table `alldeposits`
--

CREATE TABLE `alldeposits` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `depid` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `additional` varchar(255) NOT NULL,
  `walletadd` varchar(255) NOT NULL,
  `depdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alldeposits`
--

INSERT INTO `alldeposits` (`id`, `email`, `username`, `wallet`, `amount`, `depid`, `status`, `additional`, `walletadd`, `depdate`) VALUES
(20, 'tatianalala23@gmail.com', 'Tatiana Lala', 'USDT', '60000', 'SHd_830247', 'approved', 'marked', '', '2024-01-19 21:01:46'),
(21, 'lucaskauan39098@gmail.com', 'Kauan lucas', 'USDT', '60000', 'SHd_546392', 'approved', 'marked', '', '2024-01-19 21:01:52'),
(22, 'lucasbreno123409@gmail.com', 'Lucas Breno', 'USDT', '60000', 'SHd_84442', 'approved', '', '', '2024-01-19 21:01:58'),
(23, 'lucasbreno123409@gmail.com', 'Lucas Breno', 'USDT', '60000', 'SHd_42713', 'approved', 'marked', '', '2024-01-19 21:02:42'),
(24, 'lodrigo2317@gmail.com', 'Lodrigo', 'USDT', '60000', 'SHd_73658', 'approved', 'marked', '', '2024-01-19 21:02:49'),
(25, 'sentiagoalan@gmail.com', 'Alan sentiago', 'USDT', '60000', 'SHd_637290', 'approved', '', '', '2024-01-19 21:03:00'),
(26, 'sentiagoalan@gmail.com', 'Alan sentiago', 'USDT', '60000', 'SHd_61638', 'approved', '', '', '2024-01-19 21:03:07'),
(27, 'sentiagoalan@gmail.com', 'Alan sentiago', 'USDT', '60000', 'SHd_175284', 'approved', 'marked', '', '2024-01-19 21:03:15'),
(28, 'karinesoares5489@gmail.com', 'Karine soares', 'USDT', '60000', 'SHd_456361', 'approved', 'marked', '', '2024-01-19 21:03:33'),
(29, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'USDT', '60000', 'SHd_629134', 'approved', 'marked', '', '2024-01-19 21:03:48'),
(30, 'lucaskauan39098@gmail.com', 'Kauan lucas', 'USDT', '200', 'SHd_217295', 'approved', '', '', '2024-01-19 21:11:25'),
(31, 'lucaskauan39098@gmail.com', 'Kauan lucas', 'USDT', '200', 'SHd_666803', 'pending', 'marked', '', '2024-01-18 21:25:25'),
(32, 'lucaskauan39098@gmail.com', 'Kauan lucas', 'Bitcoin', '10', 'SHd_30165', 'pending', 'marked', '', '2024-01-18 21:26:51'),
(33, 'lucaskauan39098@gmail.com', 'Kauan lucas', 'USDT', '100', 'SHd_213408', 'pending', '', '', '2024-01-18 21:27:22'),
(34, 'christianbountiful@gmail.com', 'Bountiful Rodrigo', 'USDT', '60000', 'SHd_128343', 'pending', 'marked', '', '2024-01-18 23:43:24'),
(38, 'ramirazcanela@gmail.com', 'Ramirez', 'USDT', '100', 'SHd_774524', 'pending', '', '', '2024-01-19 17:17:03'),
(39, 'louisegibson12e@gmail.com', 'Louise Kelly', 'USDT', '50000', 'SHd_751183', 'approved', 'marked', '', '2024-01-19 21:02:27'),
(40, 'karinesoares5489@gmail.com', 'Karine soares', 'USDT', '60000', 'SHd_982459', 'approved', 'marked', '', '2024-01-19 21:10:20'),
(41, 'otavioferreira27598@gmail.com', 'Otavio', 'USDT', '60000', 'SHd_644335', 'approved', 'marked', '', '2024-01-19 21:14:01'),
(42, 'rodrigogledson05@gmail.com', 'Rodrigo Gledson', 'USDT', '60000', 'SHd_895040', 'pending', 'marked', '', '2024-01-19 21:19:29'),
(43, 'lodrigo2317@gmail.com', 'Alan', 'USDT', '60000', 'SHd_470723', 'pending', 'marked', '', '2024-01-19 21:21:50'),
(44, 'santiagojoari0@gmail.com', 'Santiago Joari', 'USDT', '60000', 'SHd_157332', 'pending', 'marked', '', '2024-01-19 21:28:25'),
(45, 'louisegibson12e@gmail.com', 'Louise Kelly', 'USDT', '500', 'SHd_263602', 'pending', 'marked', '', '2024-01-19 22:19:09'),
(46, 'khalilsameer377@gmail.com', 'Khalil Sameer', 'USDT', '60000', 'SHd_471941', 'pending', 'marked', '', '2024-01-22 14:31:55'),
(47, 'jameshamed8090@gmail.com', 'James Hamed', 'USDT', '60000', 'SHd_920406', 'pending', 'marked', '', '2024-01-22 14:44:29'),
(48, 'majedshake1@gmail.com', 'Majed Shake', 'USDT', '60000', 'SHd_951669', 'pending', 'marked', '', '2024-01-22 14:54:10'),
(49, 'nasersteve1@gmail.com', 'Naser Steve', 'USDT', '60000', 'SHd_728246', 'pending', 'marked', '', '2024-01-22 15:07:42'),
(50, 'hadidavid806@gmail.com', 'Hadi', 'USDT', '60000', 'SHd_109336', 'pending', 'marked', '', '2024-01-22 15:13:49'),
(51, 'abdullahjamal3167@gmail.com', 'Abdullah', 'USDT', '60000', 'SHd_886997', 'pending', 'marked', '', '2024-01-22 15:15:41'),
(52, 'amal659paul@gmail.com', 'Amal', 'USDT', '60000', 'SHd_658961', 'pending', 'marked', '', '2024-01-22 15:17:49'),
(53, 'rajesh37manal@gmail.com', 'Rajesh', 'USDT', '60000', 'SHd_202301', 'pending', 'marked', '', '2024-01-22 15:32:52'),
(54, 'zuhairalaa97@gmail.com', 'Alaa', 'USDT', '60000', 'SHd_186871', 'pending', 'marked', '', '2024-01-22 15:35:11'),
(56, 'emanwaleed726@gmail.com', 'Waleed Eman', 'USDT', '60000', 'SHd_75932', 'approved', '', '', '2024-01-29 19:43:34'),
(57, 'emanwaleed726@gmail.com', 'Waleed Eman', 'USDT', '60000', 'SHd_798990', 'approved', 'marked', '', '2024-01-29 19:42:10'),
(58, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'USDT', '60000', 'SHd_997830', 'approved', 'marked', '', '2024-01-29 19:49:27'),
(59, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'USDT', '50000', 'SHd_771549', 'approved', 'marked', '', '2024-01-29 20:49:09'),
(60, 'patriciapowell303@gmail.com', 'Patricia01', 'USDT', '50000', 'SHd_708672', 'approved', '', '', '2024-03-24 21:21:36'),
(61, 'patriciapowell303@gmail.com', 'Patricia01', 'USDT', '50000', 'SHd_479785', 'approved', '', '', '2024-03-24 21:21:26'),
(62, 'patriciapowell303@gmail.com', 'Patricia01', 'USDT', '50000', 'SHd_705278', 'approved', 'marked', '', '2024-03-24 21:21:17'),
(63, 'patriciapowell303@gmail.com', 'Patricia01', 'USDT', '50000', 'SHd_204521', 'approved', 'marked', '', '2024-03-24 21:21:10'),
(64, 'Viviandamian6@gmail.com', 'Vivian01', 'USDT', '50000', 'SHd_307812', 'approved', 'marked', '', '2024-03-26 20:36:10'),
(65, 'Viviandamian6@gmail.com', 'Vivian01', 'USDT', '50000', 'SHd_968963', 'approved', 'marked', '', '2024-03-26 20:36:18'),
(66, 'christianbountiful@gmail.com', 'Bountiful Rodrigo', 'USDT', '50000', 'SHd_484374', 'approved', 'marked', '', '2024-04-30 19:10:41'),
(67, 'edergleydsom@hotmail.com', 'Eder', 'USDT', '100', 'SHd_532494', 'pending', '', '', '2024-04-30 23:41:25'),
(68, 'edergleydsom@hotmail.com', 'Eder', 'USDT', '50', 'SHd_271070', 'pending', '', '', '2024-04-30 23:41:42'),
(69, 'edergleydsom@hotmail.com', 'Eder', 'USDT', '50', 'SHd_431788', 'pending', '', '', '2024-04-30 23:44:58'),
(70, 'guimaraesrebeiro@gmail.com', 'Guimaraes rebeiro', 'USDT', '50000', 'SHd_754295', 'approved', 'marked', '', '2024-06-04 22:14:39'),
(71, 'guimaraesrebeiro@gmail.com', 'Guimaraes rebeiro', 'USDT', '100', 'SHd_666174', 'pending', '', '', '2024-06-05 21:55:15');

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

--
-- Table structure for table `bnbwall`
--

CREATE TABLE `bnbwall` (
  `id` int(11) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `wallimg` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bnbwall`
--

INSERT INTO `bnbwall` (`id`, `wallet`, `wallimg`, `status`) VALUES
(1, '0x4A6D4CAefc7F7CB6960db4B7B719AdAFbe1A089F', 'Screenshot_20230905-231510~2.jpg', 'active');

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

--
-- Table structure for table `btcwall`
--

CREATE TABLE `btcwall` (
  `id` int(11) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `wallimg` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `btcwall`
--

INSERT INTO `btcwall` (`id`, `wallet`, `wallimg`, `status`) VALUES
(1, 'bc1qz9vspavd25jleh60lljaudft9dvcqnugm2kfc2', 'Screenshot_20240118-215339~2.jpg', 'active');

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

--
-- Table structure for table `ethwall`
--

CREATE TABLE `ethwall` (
  `id` int(11) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `wallimg` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ethwall`
--

INSERT INTO `ethwall` (`id`, `wallet`, `wallimg`, `status`) VALUES
(1, '0x4A6D4CAefc7F7CB6960db4B7B719AdAFbe1A089F', 'Screenshot_20230905-230203~2.jpg', 'active');

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

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

CREATE TABLE `investments` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `transid` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `invtype` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `invdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `investments` (`id`, `email`, `username`, `transid`, `amount`, `invtype`, `status`, `invdate`) VALUES
(15, 'Viviandamian6@gmail.com', 'Vivian01', 'SHi_163349', '2000', 'Professional', 'approved', '2024-04-01 01:26:17'),
(16, 'patriciapowell303@gmail.com', 'Patricia01', 'SHi_833158', '10000', 'Premium', 'approved', '2024-04-13 20:20:54'),
(17, 'Viviandamian6@gmail.com', 'Vivian01', 'SHi_237512', '2000', 'Professional', 'approved', '2024-04-13 20:24:54'),
(18, 'patriciapowell303@gmail.com', 'Patricia01', 'SHi_851644', '2000', 'Professional', 'approved', '2024-04-25 19:23:29'),
(19, 'guimaraesrebeiro@gmail.com', 'Guimaraes rebeiro', 'SHi_605152', '500', 'Minimum', 'approved', '2024-06-04 22:28:48');

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

--
-- Table structure for table `mysuperadmin`
--

CREATE TABLE `mysuperadmin` (
  `id` int(11) NOT NULL,
  `nameadmin` varchar(255) NOT NULL,
  `passadmin` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mysuperadmin`
--

INSERT INTO `mysuperadmin` (`id`, `nameadmin`, `passadmin`, `status`) VALUES
(1, 'nwakanwa210', 'chrisnwakanwa100', 'active');

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

--
-- Table structure for table `ref`
--

CREATE TABLE `ref` (
  `id` int(11) NOT NULL,
  `refemail` varchar(255) NOT NULL,
  `referral` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `regdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ref`
--

INSERT INTO `ref` (`id`, `refemail`, `referral`, `username`, `status`, `regdate`) VALUES
(1, 'admin@stashholding.com', 'goodnesschristian402@gmail.com', 'Kumar Joshi', 'inactive', '2023-09-08 14:43:55'),
(2, 'admin@stashholding.com', 'louisegibson12e@gmail.com', 'Louise Gibson', 'inactive', '2023-09-12 01:02:33'),
(3, 'admin@stashholding.com', 'ronaldfields685@gmail.com', 'Ronald Fields', 'inactive', '2023-09-13 00:09:40'),
(4, 'admin@stashholding.com', 'frankigor975@gmail.com', 'Igor frank', 'inactive', '2023-09-17 23:15:54'),
(5, 'admin@stashholding.com', 'sokhaleo5@gmail.com', 'Sokha leo', 'inactive', '2023-10-04 16:11:44'),
(6, 'admin@stashholding.com', 'raymakgotsobusiness@gmail.com', 'Makgotso', 'inactive', '2023-10-11 22:21:05'),
(7, 'admin@stashholding.com', 'racheltrading17@gmail.com', 'Legwale', 'inactive', '2023-10-11 22:26:31'),
(8, 'admin@stashholding.com', 'Alexklassic@gmail.com', 'Alexklassic', 'inactive', '2023-10-14 14:24:06'),
(9, 'admin@stashholding.com', 'isralisa.hx@gmail.com', 'Isralisa', 'inactive', '2023-10-16 22:45:45'),
(10, 'admin@stashholding.com', 'alexobidon@gmail.com', 'Lisa', 'inactive', '2023-10-16 22:55:42'),
(11, 'admin@stashholding.com', 'martinmatos938@gmail.com', 'Martin Matos', 'inactive', '2023-10-17 11:45:24'),
(12, 'admin@stashholding.com', 'Canelasilaah@gmail.com', 'Ramirez', 'inactive', '2023-11-17 17:53:27'),
(13, 'admin@stashholding.com', 'lucaskauan39098@gmail.com', 'Kauan Lucas', 'inactive', '2024-01-08 19:19:37'),
(14, 'admin@stashholding.com', 'lucasbreno123409@gmail.com', 'Lucas Breno', 'inactive', '2024-01-08 19:19:48'),
(15, 'admin@stashholding.com', 'otavioferreira27598@gmail.com', 'Otavio Ferreira', 'inactive', '2024-01-08 19:29:24'),
(16, 'admin@stashholding.com', 'santiagojoari0@gmail.com', 'Santiago Joari', 'inactive', '2024-01-08 19:30:07'),
(17, 'admin@stashholding.com', 'sentiagoalan@gmail.com', 'Alan sentiago', 'inactive', '2024-01-08 19:38:27'),
(18, 'admin@stashholding.com', 'thiagogomes1234@gmail.com', 'Thiago Gomes', 'inactive', '2024-01-08 19:39:28'),
(19, 'admin@stashholding.com', 'lodrigo2317@gmail.com', 'Beto Rodrigo', 'inactive', '2024-01-08 19:45:21'),
(20, 'admin@stashholding.com', 'karinesoares5489@gmail.com', 'Karine Soares', 'inactive', '2024-01-08 19:51:42'),
(21, 'admin@stashholding.com', 'rodrigogleson05@gmail.com', 'Rodrigo Gledson', 'inactive', '2024-01-08 19:58:32'),
(22, 'admin@stashholding.com', 'tatianlala23@gmail', 'Tatiana Lala', 'inactive', '2024-01-08 20:46:55'),
(23, 'admin@stashholding.com', 'enyiukporgideon630@gmail.com', 'Enyiukpor Gideon Odera', 'inactive', '2024-01-08 21:17:15'),
(24, 'admin@stashholding.com', 'nb894265@gmail.com', 'Gomes Thiago', 'inactive', '2024-01-08 21:26:01'),
(25, 'admin@stashholding.com', 'bountiespayinggamesltd@gmail.com', 'Luiz Ribeiro', 'inactive', '2024-01-18 07:39:02'),
(26, 'admin@stashholding.com', 'otavioferreira27598@gmail.com', 'Otavio ferreira', 'inactive', '2024-01-18 11:17:11'),
(27, 'admin@stashholding.com', 'otavioferreira27598@gmail.com', 'Otavio', 'inactive', '2024-01-18 11:18:43'),
(28, 'admin@stashholding.com', 'lucasbreno123409@gmail.com', 'Lucas Breno', 'inactive', '2024-01-18 11:19:13'),
(29, 'admin@stashholding.com', 'lucaskauan39098@gmail.com', 'Kauan lucas', 'inactive', '2024-01-18 11:20:06'),
(30, 'admin@stashholding.com', 'lucaskauan39098@gmail.com', 'Kauan lucas', 'inactive', '2024-01-18 20:25:19'),
(31, 'admin@stashholding.com', 'tatianalala23@gmail.com', 'Tatiana Lala', 'inactive', '2024-01-18 20:27:26'),
(32, 'admin@stashholding.com', 'lucasbreno123409@gmail.com', 'Lucas Breno', 'inactive', '2024-01-18 20:42:28'),
(33, 'admin@stashholding.com', 'lodrigo2317@gmail.com', 'Lodrigo', 'inactive', '2024-01-18 20:44:21'),
(34, 'admin@stashholding.com', 'sentiagoalan@gmail.com', 'Alan sentiago', 'inactive', '2024-01-18 20:47:28'),
(35, 'admin@stashholding.com', 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'inactive', '2024-01-18 20:48:37'),
(36, 'admin@stashholding.com', 'karinesoares5489@gmail.com', 'Karine soares', 'inactive', '2024-01-18 20:51:32'),
(37, 'admin@stashholding.com', 'christianbountiful@gmail.com', 'Bountiful Rodrigo', 'inactive', '2024-01-18 23:07:29'),
(38, 'admin@stashholding.com', 'ramirazcanela@gmail.com', 'Ramirez', 'inactive', '2024-01-19 17:10:58'),
(39, 'admin@stashholding.com', 'louisegibson12e@gmail.com', 'Louise Kelly', 'inactive', '2024-01-19 18:55:08'),
(40, 'admin@stashholding.com', 'rodrigogledson05@gmail.com', 'Rodrigo Gledson', 'inactive', '2024-01-19 21:14:35'),
(41, 'admin@stashholding.com', 'lodrigo2317@gmail.com', 'Alan', 'inactive', '2024-01-19 21:20:06'),
(42, 'admin@stashholding.com', 'santiagojoari0@gmail.com', 'Santiago Joari', 'inactive', '2024-01-19 21:22:21'),
(43, 'admin@stashholding.com', 'khalilsameer377@gmail.com', 'Khalil Sameer', 'inactive', '2024-01-22 14:20:56'),
(44, 'admin@stashholding.com', 'jameshamed8090@gmail.com', 'James Hamed', 'inactive', '2024-01-22 14:34:33'),
(45, 'admin@stashholding.com', 'hadidavid806@gmail.com', 'Hadi', 'inactive', '2024-01-22 14:47:28'),
(46, 'admin@stashholding.com', 'majedshake1@gmail.com', 'Majed Shake', 'inactive', '2024-01-22 14:47:50'),
(47, 'admin@stashholding.com', 'amal659paul@gmail.com', 'Amal', 'inactive', '2024-01-22 14:51:15'),
(48, 'admin@stashholding.com', 'abdullahjamal3167@gmail.com', 'Abdullah', 'inactive', '2024-01-22 14:53:07'),
(49, 'admin@stashholding.com', 'nasersteve1@gmail.com', 'Naser Steve', 'inactive', '2024-01-22 14:56:38'),
(50, 'admin@stashholding.com', 'rajesh37manal@gmail.com', 'Rajesh', 'inactive', '2024-01-22 15:19:46'),
(51, 'admin@stashholding.com', 'zuhairalaa97@gmail.com', 'Alaa', 'inactive', '2024-01-22 15:20:42'),
(52, 'admin@stashholding.com', 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'inactive', '2024-01-29 16:59:05'),
(53, 'admin@stashholding.com', 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'inactive', '2024-01-29 18:32:46'),
(54, 'admin@stashholding.com', 'emanwaleed726@gmail.com', 'Waleed Eman', 'inactive', '2024-01-29 18:34:56'),
(55, 'admin@stashholding.com', 'abdulomar8090@gmail.com', 'Abdul Omar', 'inactive', '2024-01-29 18:37:30'),
(56, 'admin@stashholding.com', 'patriciapowell303@gmail.com', 'Patricia01', 'inactive', '2024-03-04 20:46:27'),
(57, 'admin@stashholding.com', 'Viviandamian6@gmail.com', 'Vivian01', 'inactive', '2024-03-24 21:43:00'),
(58, 'Viviandamian6@gmail.com', 'yourname@telegmail.com', 'Rahul Kumar', 'inactive', '2024-03-30 16:04:03'),
(59, 'admin@stashholding.com', 'guddufat@gmail.com', 'Gulshan kumar', 'inactive', '2024-03-30 16:12:47'),
(60, 'thiogagomes1234@gmail.com', 'edergleydsom@hotmail.com', 'Eder', 'inactive', '2024-04-28 00:12:12'),
(61, 'admin@stashholding.com', 'vadimnea66+797s@list.ru', 'Nfejdekofhofjwdoe jirekdwjfreohogjkerwkrj rekwlrkfekjgoperrkfoek ojeopkfwkferjgiejfwk okfepjfgrihgoiejfklegjroi jeiokferfekfrjgiorjofeko jeoighirhgioejfoekforjgijriogjeo foefojeigjrigklej jkrjfkrejgkrhglrlrk stashholding.com', 'inactive', '2024-05-05 10:11:06'),
(62, 'admin@stashholding.com', 'guimaraesrebeiro@gmail.com', 'Guimaraes rebeiro', 'inactive', '2024-06-04 22:04:32');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `uptime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `location`, `message`, `status`, `uptime`) VALUES
(1, 'Felix Meldan', 'Austria', 'I had the smoothest earnings with Stashholdings! My trades returned over 200% on investment over a period of 10 days. thanks guys...!', 'active', '2023-09-04 13:45:30'),
(2, 'Cynthia Jackson', 'Florida', 'No one does it better than Stashholdings, these investment returns are steady and mind blowing. Thanks!', 'active', '2023-09-04 13:46:33'),
(3, 'Anita Claire', 'Switzerland', 'Stash holdings offer steady returns on investment, six weeks and still on', 'active', '2023-09-04 14:13:58'),
(4, 'Amartha Charles', 'New York', 'My account here helps me pay my bills and I am grateful, my guys are also earning.', 'active', '2023-09-04 14:14:00'),
(5, 'Stannis Woodward', 'Canada', 'The ease of trade and rest on investment here is under rated. i ahve been on for over six months and the returns just keeps coming', 'active', '2023-09-04 13:49:29');

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

--
-- Table structure for table `usdtwall`
--

CREATE TABLE `usdtwall` (
  `id` int(11) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `wallimg` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `usdtwall`
--

INSERT INTO `usdtwall` (`id`, `wallet`, `wallimg`, `status`) VALUES
(1, 'TMF8vu1NBd7MCTMgCcXZHvD7DuJ6ytwABv', 'Screenshot_20240118-214710~2.jpg', 'active');

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

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

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `withid` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `wallet` varchar(255) NOT NULL,
  `walltype` varchar(255) NOT NULL,
  `withtype` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `withdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `email`, `username`, `withid`, `amount`, `wallet`, `walltype`, `withtype`, `status`, `withdate`) VALUES
(13, 'louisegibson12e@gmail.com', 'Louise Kelly', 'SHw_773007', '500', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9g UC', 'USDT', '', 'approved', '2024-01-19 22:33:27'),
(14, 'louisegibson12e@gmail.com', 'Louise Kelly', 'SHw_802941', '222.59', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9g UC', 'USDT', '', 'approved', '2024-01-19 22:33:17'),
(15, 'louisegibson12e@gmail.com', 'Louise Kelly', 'SHw_379708', '2300', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9g UC', 'USDT', '', 'approved', '2024-01-19 22:33:10'),
(16, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_22428', '500', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-01-29 20:09:17'),
(17, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_514312', '110', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-01-29 20:09:10'),
(18, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_547850', '110', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-01-29 20:17:14'),
(19, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_276823', '110', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-01-29 21:16:06'),
(20, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_250493', '500', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-01-29 21:16:00'),
(21, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'SHw_82426', '110', '0x9F900170b0e188aD59Cc6CdDa3F188A53111A3Da', 'USDT', '', 'approved', '2024-01-29 21:48:13'),
(22, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'SHw_581496', '500', '0x9F900170b0e188aD59Cc6CdDa3F188A53111A3Da', 'USDT', '', 'approved', '2024-01-29 21:48:26'),
(23, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'SHw_515010', '1500', '0x9F900170b0e188aD59Cc6CdDa3F188A53111A3Da', 'USDT', '', 'approved', '2024-01-29 21:48:34'),
(24, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'SHw_803633', '2300', '0x9F900170b0e188aD59Cc6CdDa3F188A53111A3Da', 'USDT', '', 'approved', '2024-01-29 21:48:40'),
(25, 'saeedmahmoud1037@gmail.com', 'Saeed Mahmoud', 'SHw_727825', '10000', '0x9F900170b0e188aD59Cc6CdDa3F188A53111A3Da', 'USDT', '', 'approved', '2024-01-29 21:48:46'),
(26, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_609008', '500', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-01-29 22:01:46'),
(27, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_284730', '115', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-01-31 16:11:36'),
(28, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_318958', '115', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-02-27 00:44:33'),
(29, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_294508', '300', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-02-27 00:44:41'),
(30, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_914335', '1000', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-02-27 00:44:48'),
(31, 'maristelladallangol@gmail.com', 'Maristella Dall Angol', 'SHw_3565', '3300', 'TCKCX5Khy9V96qvD5T5K8c6bzWXzMkawbw', 'USDT', '', 'approved', '2024-05-01 11:00:48'),
(32, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_768536', '115', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-04-25 20:07:33'),
(33, 'patriciapowell303@gmail.com', 'Patricia01', 'SHw_983565', '115', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-03-26 20:35:32'),
(34, 'patriciapowell303@gmail.com', 'Patricia01', 'SHw_755461', '250', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-03-26 20:35:41'),
(35, 'Viviandamian6@gmail.com', 'Vivian01', 'SHw_696620', '115', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'pending', '2024-03-26 22:41:09'),
(36, 'Viviandamian6@gmail.com', 'Vivian01', 'SHw_168776', '250', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'pending', '2024-03-26 22:42:09'),
(37, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_8271', '750', 'No yo te avisoTCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-05-16 22:15:37'),
(38, 'patriciapowell303@gmail.com', 'Patricia01', 'SHw_169518', '3000', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-05-01 11:20:54'),
(39, 'thiogagomes1234@gmail.com', 'Thioga Gomes', 'SHw_282030', '850', 'TCov4gfU2htDBmM1G6vscEHpXLsyih9gUC', 'USDT', '', 'approved', '2024-05-16 22:15:17');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

