-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Mar 09, 2024 at 10:49 PM -- Server version: 10.4.21-MariaDB -- PHP Version: 7.4.29 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: `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', '<p>A Drawing Of A Skull</p>', 'Imhungry', '<h2><strong>A Drawing Of A Skull With A Bunch Of Plants On It</strong></h2>', '12.00', 'slider-img3.jpeg', '2024-02-19 16:58:05'), (3, '4ca0c2cf0a8432abfbe6124f48a5b60d', '<p>Fantasy Echanted Fa…</p>', 'Imhungry', '<h2><strong>Fantasy Enchanted Fairy Forest Magic Baby Dragon Generative Ai</strong></h2>', '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; /*!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 */;