File "nft-20260115061032.sql"
Full Path: /home/quiczmwg/lightspringdigitals.com/database/nft-20260115061032.sql
File size: 15.93 KB
MIME-type: text/plain
Charset: utf-8
-- 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 */;