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

START TRANSACTION;



--
-- Database: `nft`
--

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

--
-- Table structure for table `dart`
--

CREATE TABLE `dart` (
  `id` int(11) NOT NULL,
  `a_id` varchar(34) NOT NULL,
  `a_image` varchar(191) NOT NULL,
  `a_price` varchar(191) NOT NULL,
  `a_title` varchar(191) NOT NULL,
  `a_description` varchar(191) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dart`
--

INSERT INTO `dart` (`id`, `a_id`, `a_image`, `a_price`, `a_title`, `a_description`, `created_at`) VALUES
(1, '4ba5f40c75a72cab5a85bbfc09ee51eb', 'nft1.jpeg', '2', 'nft fish', 'nft fish art work', '2024-02-22 23:30:23');

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

--
-- Table structure for table `dblog`
--

CREATE TABLE `dblog` (
  `id` int(11) NOT NULL,
  `blog_id` varchar(34) NOT NULL,
  `b_image` varchar(191) NOT NULL,
  `b_name` varchar(191) NOT NULL,
  `b_creator` varchar(191) NOT NULL,
  `b_price` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dblog`
--

INSERT INTO `dblog` (`id`, `blog_id`, `b_image`, `b_name`, `b_creator`, `b_price`, `created_at`) VALUES
(7, '3ca48e28b9f2f79b5e6b13c7a795f027', 'nft-item1.jpeg', 'Decorative', 'Nafisehimanipanah', '2.88', '2024-02-19 00:39:22'),
(8, '32af37478d9175c921c51d61d25e2b73', 'nft-item2.jpeg', 'Decorative', 'Nafisehimanipanah', '2.88', '2024-02-19 00:56:07'),
(9, 'ebd9b370cdffbb02e4865b078790d35d', 'nft-item3.jpeg', 'Decorative', 'Nafisehimanipanah', '2.88', '2024-02-19 00:56:36'),
(10, 'a42e02a046868173d347578a6a4c429d', 'nft-item4.jpeg', 'Decorative', 'Nafisehimanipanah', '2.88', '2024-02-19 00:59:53'),
(11, '305a71ae46fc91af7f080798b393e46b', 'nft-item5.jpeg', '15-burocracy', 'Rose Uranga', '2.00', '2024-02-19 01:12:39'),
(12, 'f0216ce5c1739e49b39b857ccf2848b3', 'nft-item6.jpeg', 'Mickel Angelico', 'Rose Uranga', '3.59', '2024-02-19 01:13:33'),
(13, 'edceadb4ffd1c161b5c9e4637ac0cd3b', 'nft-item7.jpeg', 'میکروسمنت', 'Fateme Alikani', '2.00', '2024-02-19 01:15:15'),
(14, '3656c70618a74b743700e865d1d2a8be', 'nft-item8.jpeg', 'Drawing', 'Mania_artnft', '2.50', '2024-02-19 01:17:08'),
(15, 'c492b56d72cd048c9690b3aea451d7be', 'nft-item9.jpeg', 'Ataturk', 'Ugur Kartal Satir', '30.60', '2024-02-19 01:21:31'),
(16, '31ce54eab3fd1ec3cfad4948c05b42e8', 'nft-item12.jpeg', 'The Four Season: Summer', 'Guillermo Schein', '3.61', '2024-02-19 01:22:36'),
(17, 'defbdae90f15eab527e7fe3f6127da20', 'nft-item10.jpeg', 'The Four Seasons: Autumn', 'Guillermo Schein', '3.61', '2024-02-19 01:23:48'),
(18, 'a1ffe060476ea36ec84172992ec62478', 'nft-item11.jpeg', 'The Four Seasons: Autumn', 'Guillermo Schein', '3.61', '2024-02-19 01:24:32'),
(19, 'a7957f513ef4a92657b14fa76bb2f185', 'nft-item10.jpeg', 'Decorative', 'Nafisehimanipanah', '2.88', '2024-02-21 06:46:26');

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

--
-- Table structure for table `dcarousel`
--

CREATE TABLE `dcarousel` (
  `id` int(11) NOT NULL,
  `carousel_id` varchar(34) NOT NULL,
  `c_name` varchar(191) NOT NULL,
  `c_creator` varchar(191) NOT NULL,
  `c_description` varchar(191) NOT NULL,
  `c_price` varchar(191) NOT NULL,
  `c_image` varchar(191) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dcarousel`
--

INSERT INTO `dcarousel` (`id`, `carousel_id`, `c_name`, `c_creator`, `c_description`, `c_price`, `c_image`, `created_at`) VALUES
(1, '918fa9916ef25ddbc3fc6afcf18a9596', 'Fashion Little Boy', 'Imhungry', 'Fashion Little Boy', '2.00', 'slider-img2.jpeg', '2024-02-19 16:55:52'),
(2, '41016eb17f794bc7553167f4d418a746', '&lt;p&gt;A Drawing Of A Skull&lt;/p&gt;', 'Imhungry', '&lt;h2&gt;&lt;strong&gt;A Drawing Of A Skull With A Bunch Of Plants On It&lt;/strong&gt;&lt;/h2&gt;', '12.00', 'slider-img3.jpeg', '2024-02-19 16:58:05'),
(3, '4ca0c2cf0a8432abfbe6124f48a5b60d', '&lt;p&gt;Fantasy Echanted Fa…&lt;/p&gt;', 'Imhungry', '&lt;h2&gt;&lt;strong&gt;Fantasy Enchanted Fairy Forest Magic Baby Dragon Generative Ai&lt;/strong&gt;&lt;/h2&gt;', '34.00', 'slider-img4.jpeg', '2024-02-19 16:59:38');

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

--
-- Table structure for table `dcreatenft`
--

CREATE TABLE `dcreatenft` (
  `id` int(11) NOT NULL,
  `userid` varchar(34) NOT NULL,
  `itemid` varchar(34) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `username` varchar(191) NOT NULL,
  `account_balance` decimal(10,2) NOT NULL,
  `network` varchar(34) NOT NULL,
  `nft_img` varchar(191) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `price` varchar(121) NOT NULL,
  `collection` varchar(191) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `created_` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `deposit`
--

CREATE TABLE `deposit` (
  `id` int(11) NOT NULL,
  `userid` varchar(34) NOT NULL,
  `deposit_id` varchar(34) NOT NULL,
  `demail` varchar(191) NOT NULL,
  `amount` varchar(191) NOT NULL,
  `payment_method` varchar(191) NOT NULL,
  `network` varchar(100) NOT NULL,
  `wallet_address` varchar(100) NOT NULL,
  `dstatus` varchar(34) NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `deposit`
--

INSERT INTO `deposit` (`id`, `userid`, `deposit_id`, `demail`, `amount`, `payment_method`, `network`, `wallet_address`, `dstatus`, `created_at`) VALUES
(1, '$userid', '$deposit_id', '$email', '$amount', '$wallet_type', '', '', '$status', '2024-02-25 16:29:55'),
(2, '$userid', '$deposit_id', '$demail', '$amount', '$payment_method', '$network', '$wallet_address', 'pending', '2024-02-25 17:04:13'),
(3, '1', '', '', '1', '', '', '', 'pending', '2024-02-25 20:58:07'),
(4, '1', 'DEP_65db9fb3ad4d7', '', '1', '', '', '', 'pending', '2024-02-25 21:14:43'),
(5, '1', 'DEP_65dba18d8aa4d', '', '5', '', '', '', 'confirmed', '2024-02-25 21:22:37'),
(6, '1', 'DEP_65dba1ab2866b', '', '2', '', '', '', 'pending', '2024-02-25 21:23:07'),
(7, '1', 'DEP_65dba2302262d', '', '2', '', '', '', 'pending', '2024-02-25 21:25:20'),
(8, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dba33f0921a', '', '2', '', '', '', 'pending', '2024-02-25 21:29:51'),
(9, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dba71d564a4', '', '2', '', '', '', 'pending', '2024-02-25 21:46:21'),
(10, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dba87a832fa', '', '2', '', '', '', 'pending', '2024-02-25 21:52:10'),
(11, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbd3ade8f4e', '', '2', '', '', '', 'pending', '2024-02-26 00:56:29'),
(12, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbd3c93be54', '', '2', '', '', '', 'pending', '2024-02-26 00:56:57'),
(13, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbd3d2318b9', '', '1', '', '', '', 'pending', '2024-02-26 00:57:06'),
(14, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbd41c2f822', '', '1', '', '', '', 'pending', '2024-02-26 00:58:20'),
(15, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbd8ef950b6', '', '1', '', '', '', 'pending', '2024-02-26 01:18:55'),
(16, '$userid', '$deposit_id', '$demail', '$price', '$payment_method', '$network', '$wallet_address', 'pending', '2024-02-26 01:36:21'),
(17, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe56fe610b', '', '2', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:12:15'),
(18, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe581288d6', '', '2', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:12:33'),
(19, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe5afac4b4', '', '2', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:13:19'),
(20, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe748a3637', '', '7', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:20:08'),
(21, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe75552dd0', '', '7', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:20:21'),
(22, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe82ecb57d', '', '5', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:23:58'),
(23, 'c0a305ff84f6446f5dc30cae998c8a03', 'DEP65dbe8feb387b', '', '6', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-02-26 02:27:26'),
(24, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4051b92f12', '', '1', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 06:05:31'),
(25, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4056feda41', '', '1', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 06:06:55'),
(26, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e406904d789', '', '1', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 06:11:44'),
(27, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4069ac69f8', '', '1', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 06:11:54'),
(28, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e406fcec76e', '', '2', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 06:13:32'),
(29, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4078de221a', '', '3', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'confirmed', '2024-03-03 06:15:57'),
(30, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4083e89a3c', '', '4', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'confirmed', '2024-03-03 06:18:54'),
(31, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4a90028525', 'admin@gmail.com', '2', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'pending', '2024-03-03 17:44:48'),
(32, 'c7c4920436e36d55477745e8a5b92c57', 'DEP65e4aa62355be', 'admin@gmail.com', '29', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', 'confirmed', '2024-03-03 17:50:42');

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

--
-- Table structure for table `dlogin`
--

CREATE TABLE `dlogin` (
  `id` int(11) NOT NULL,
  `userid` varchar(34) NOT NULL,
  `dfname` varchar(34) NOT NULL,
  `demail` varchar(50) NOT NULL,
  `dusername` varchar(191) NOT NULL,
  `bio` varchar(200) NOT NULL,
  `dpass` varchar(255) NOT NULL,
  `dtype` varchar(34) NOT NULL DEFAULT 'staff',
  `balance` decimal(10,2) NOT NULL,
  `dstatus` varchar(34) NOT NULL DEFAULT 'verify',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dlogin`
--

INSERT INTO `dlogin` (`id`, `userid`, `dfname`, `demail`, `dusername`, `bio`, `dpass`, `dtype`, `balance`, `dstatus`, `created_at`) VALUES
(5, 'c7c4920436e36d55477745e8a5b92c57', 'Admin', 'admin@gmail.com', 'Admin', '', '$2y$10$dm2zWFpnxw1BXxiNFyb5BeJxMtteT.THd8yFeHbZq.Cdcm51Y/f3q', 'staff', '36.00', 'verify', '2024-03-02 09:18:45');

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

--
-- Table structure for table `dnft`
--

CREATE TABLE `dnft` (
  `id` int(11) NOT NULL,
  `img_id` varchar(34) NOT NULL,
  `p_image` varchar(191) NOT NULL,
  `p_description` varchar(191) NOT NULL,
  `p_title` varchar(191) NOT NULL,
  `p_price` varchar(191) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dnft`
--

INSERT INTO `dnft` (`id`, `img_id`, `p_image`, `p_description`, `p_title`, `p_price`, `created_at`) VALUES
(1, 'c3cc6bebc44bf18853733501cdab7be3', 'nft1.jpeg', 'Digital Art Fish Selected Fo…', 'Admin', '2.00', '2024-02-18 04:03:11'),
(2, '3df5aca749a3c0186ba6374e4203c73f', 'nft2.jpeg', 'A Robot With Red Eyes And …', 'Admin1', '7.00', '2024-02-18 04:14:35'),
(3, 'ea7d22b8bf0d626ca59b9caa35515d3a', 'nft3.jpeg', 'Autumn Evening', 'Admin2', '6.00', '2024-02-18 04:16:45'),
(4, '0383d2b19110ced3fec41108a6c0cc89', 'nft4.jpeg', 'Portrait Of Mystical Leprec…', 'Admin3', '8.33', '2024-02-18 04:20:05');

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

--
-- Table structure for table `dwallet`
--

CREATE TABLE `dwallet` (
  `id` int(11) NOT NULL,
  `wallet_id` varchar(191) NOT NULL,
  `wallet_type` varchar(191) NOT NULL,
  `network` varchar(191) NOT NULL,
  `wallet_address` varchar(191) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dwallet`
--

INSERT INTO `dwallet` (`id`, `wallet_id`, `wallet_type`, `network`, `wallet_address`, `created_at`) VALUES
(1, '51579864dae87d181f1f41480fa400ce', 'Ethereum', 'ERC20', '0x742d35Cc6634C0532925a3b844Bc454e4438f44a', '2024-02-25 07:18:24');

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

--
-- Table structure for table `withdrawal_details`
--

CREATE TABLE `withdrawal_details` (
  `id` int(11) NOT NULL,
  `userid` varchar(34) NOT NULL,
  `demail` varchar(50) NOT NULL,
  `wid` varchar(34) NOT NULL,
  `withdrawal_amount` double NOT NULL,
  `wallet_type` varchar(50) NOT NULL,
  `wallet_address` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

