File Manager

Editing File: /home/rareljzw/public_html/SQL File/SQL.sql

-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 05, 2023 at 10:27 AM
-- Server version: 10.5.19-MariaDB
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `doordash_nft`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `username` text NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `bio` text NOT NULL,
  `admin_image` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `name`, `username`, `email`, `password`, `bio`, `admin_image`, `createdAt`) VALUES
(1, 'dirtyscripts', 'admin', 'support@dirtyscripts.shop', '$2y$10$GvESYvpe6vYllRs5GvquiOCieanLtQIFp2cc4mT/fFc.DHmyKAv5O', 'Aenean commodo ligula eget dolor. Aenean massa. Cum sociis Theme natoque penatibus et magnis dis parturient montes. ', 'user_avatar.gif', '2022-12-01 00:00:00');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `blog_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `tagline` text NOT NULL,
  `content` text NOT NULL,
  `image` text NOT NULL,
  `category` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`blog_id`, `title`, `tagline`, `content`, `image`, `category`, `createdAt`) VALUES
(1, 'Ripple Announces $250 Million Creator Fund to Evolve NFT Utility', 'Ripple, the leading provider of enterprise blockchain and crypto solutions that are faster, more transparent and more cost-effective', 'Ripple, the leading provider of enterprise blockchain and crypto solutions that are faster, more transparent and more cost-effective, today announced a $250 million fund to provide creators with the financial, creative and technical support needed to explore and craft premium non-fungible token (NFT) and other tokenization projects on the XRP Ledger. \r\n\r\nThe heightened interest and boom in NFTs globally has introduced new revenue streams and business models while deepening the mainstream’s relationships with the communities, people and things they care about. However, when it comes to creating state-of-the-art NFTs, many creators face barriers to entry–including the fear their NFTs won’t sell and a lack of understanding when it comes to navigating NFT concepts. Developers, meanwhile, are often burdened with high transaction fees and clunky user experiences on marketplaces or platforms. \r\n\r\nWhile digital art and collectibles have quickly captured public interest and popularity, the utility of NFTs goes far beyond these use cases. By providing creative and technical support to a diverse array of marketplaces, creators, artists and brands, Ripple’s Creator Fund seeks to enable longtail use cases for tokenization—for example, interactive experiences and fractional ownership.\r\n\r\nRipple is teaming up with innovative NFT marketplaces and creative agencies who recognize the potential of these unique tokenized assets and, as part of the launch, will have first access to the fund.', 'post_3.jpg', 'Press Release', '2022-12-05 00:00:00');

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

--
-- Table structure for table `collections`
--

CREATE TABLE `collections` (
  `id` int(11) NOT NULL,
  `col_id` int(11) NOT NULL,
  `col_name` text NOT NULL,
  `icon` text NOT NULL,
  `svg` text NOT NULL,
  `image` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `collections`
--

INSERT INTO `collections` (`id`, `col_id`, `col_name`, `icon`, `svg`, `image`, `createdAt`) VALUES
(1, 2, 'Art', '<span class=\"mr-3 rounded-xl bg-[#E4FCF4] p-[0.375rem]\">\r\n                        <svg\r\n                          xmlns=\"http://www.w3.org/2000/svg\"\r\n                          viewBox=\"0 0 24 24\"\r\n                          width=\"24\"\r\n                          height=\"24\"\r\n                          class=\"h-4 w-4 fill-[#10B981]\"\r\n                        >\r\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\r\n                          <path\r\n                            d=\"M12 2c5.522 0 10 3.978 10 8.889a5.558 5.558 0 0 1-5.556 5.555h-1.966c-.922 0-1.667.745-1.667 1.667 0 .422.167.811.422 1.1.267.3.434.689.434 1.122C13.667 21.256 12.9 22 12 22 6.478 22 2 17.522 2 12S6.478 2 12 2zm-1.189 16.111a3.664 3.664 0 0 1 3.667-3.667h1.966A3.558 3.558 0 0 0 20 10.89C20 7.139 16.468 4 12 4a8 8 0 0 0-.676 15.972 3.648 3.648 0 0 1-.513-1.86zM7.5 12a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zm9 0a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zM12 9a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3z\"\r\n                          />\r\n                        </svg>\r\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M12 2c5.522 0 10 3.978 10 8.889a5.558 5.558 0 0 1-5.556 5.555h-1.966c-.922 0-1.667.745-1.667 1.667 0 .422.167.811.422 1.1.267.3.434.689.434 1.122C13.667 21.256 12.9 22 12 22 6.478 22 2 17.522 2 12S6.478 2 12 2zm-1.189 16.111a3.664 3.664 0 0 1 3.667-3.667h1.966A3.558 3.558 0 0 0 20 10.89C20 7.139 16.468 4 12 4a8 8 0 0 0-.676 15.972 3.648 3.648 0 0 1-.513-1.86zM7.5 12a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zm9 0a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zM12 9a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3z\"></path>                   </svg>', 'category_1.png', '2022-12-01 00:00:00'),
(2, 3, 'Collectibies', '<span class=\"mr-3 rounded-xl bg-[#FDF7EE] p-[0.375rem]\">\n                        <svg\n                          xmlns=\"http://www.w3.org/2000/svg\"\n                          viewBox=\"0 0 24 24\"\n                          width=\"24\"\n                          height=\"24\"\n                          class=\"h-4 w-4 fill-[#FEB240]\"\n                        >\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\n                          <path\n                            d=\"M17.5 2a4.5 4.5 0 0 1 2.951 7.897c.355.967.549 2.013.549 3.103A9 9 0 1 1 3.55 9.897a4.5 4.5 0 1 1 6.791-5.744 9.05 9.05 0 0 1 3.32 0A4.494 4.494 0 0 1 17.5 2zm0 2c-.823 0-1.575.4-2.038 1.052l-.095.144-.718 1.176-1.355-.253a7.05 7.05 0 0 0-2.267-.052l-.316.052-1.356.255-.72-1.176A2.5 2.5 0 1 0 4.73 8.265l.131.123 1.041.904-.475 1.295A7 7 0 1 0 19 13c0-.716-.107-1.416-.314-2.083l-.112-.33-.475-1.295 1.04-.904A2.5 2.5 0 0 0 17.5 4zM10 13a2 2 0 1 0 4 0h2a4 4 0 1 1-8 0h2z\"\n                          />\n                        </svg>\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M2 4a1 1 0 0 1 1-1h18a1 1 0 0 1 1 1v5.5a2.5 2.5 0 1 0 0 5V20a1 1 0 0 1-1 1H3a1 1 0 0 1-1-1V4zm6.085 15a1.5 1.5 0 0 1 2.83 0H20v-2.968a4.5 4.5 0 0 1 0-8.064V5h-9.085a1.5 1.5 0 0 1-2.83 0H4v14h4.085zM9.5 11a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zm0 5a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3z\"></path>                   </svg>', 'category_2.png', '2022-12-01 00:00:00'),
(3, 4, 'Domain Names', ' <span class=\"mr-3 rounded-xl bg-[#F2EEFF] p-[0.375rem]\">\n                        <svg\n                          xmlns=\"http://www.w3.org/2000/svg\"\n                          viewBox=\"0 0 24 24\"\n                          width=\"24\"\n                          height=\"24\"\n                          class=\"h-4 w-4 fill-[#8358FF]\"\n                        >\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\n                          <path\n                            d=\"M5 15v4h4v2H3v-6h2zm16 0v6h-6v-2h4v-4h2zm-8.001-9l4.4 11h-2.155l-1.201-3h-4.09l-1.199 3H6.6l4.399-11h2zm-1 2.885L10.752 12h2.492l-1.245-3.115zM9 3v2H5v4H3V3h6zm12 0v6h-2V5h-4V3h6z\"\n                          />\n                        </svg>\n                      </span>', ' <svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M5 15v4h4v2H3v-6h2zm16 0v6h-6v-2h4v-4h2zm-8.001-9l4.4 11h-2.155l-1.201-3h-4.09l-1.199 3H6.6l4.399-11h2zm-1 2.885L10.752 12h2.492l-1.245-3.115zM9 3v2H5v4H3V3h6zm12 0v6h-2V5h-4V3h6z\"></path>                   </svg>', 'category_3.png', '2022-12-01 00:00:00'),
(4, 5, 'Music', ' <span class=\"mr-3 rounded-xl bg-[#FFEEFA] p-[0.375rem]\">\n                        <svg\n                          xmlns=\"http://www.w3.org/2000/svg\"\n                          viewBox=\"0 0 24 24\"\n                          width=\"24\"\n                          height=\"24\"\n                          class=\"h-4 w-4 fill-[#F35BC7]\"\n                        >\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\n                          <path d=\"M12 13.535V3h8v3h-6v11a4 4 0 1 1-2-3.465z\" />\n                        </svg>\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M12 13.535V3h8v3h-6v11a4 4 0 1 1-2-3.465z\"></path>                   </svg>', 'category_7.png', '2022-12-01 00:00:00'),
(5, 6, 'Photography', '<span class=\"mr-3 rounded-xl bg-[#EAF2FE] p-[0.375rem]\">\n                        <svg\n                          xmlns=\"http://www.w3.org/2000/svg\"\n                          viewBox=\"0 0 24 24\"\n                          width=\"24\"\n                          height=\"24\"\n                          class=\"h-4 w-4 fill-[#428AF8]\"\n                        >\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\n                          <path\n                            d=\"M2 6c0-.552.455-1 .992-1h18.016c.548 0 .992.445.992 1v14c0 .552-.455 1-.992 1H2.992A.994.994 0 0 1 2 20V6zm2 1v12h16V7H4zm10 9a3 3 0 1 0 0-6 3 3 0 0 0 0 6zm0 2a5 5 0 1 1 0-10 5 5 0 0 1 0 10zM4 2h6v2H4V2z\"\n                          />\n                        </svg>\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M2 6c0-.552.455-1 .992-1h18.016c.548 0 .992.445.992 1v14c0 .552-.455 1-.992 1H2.992A.994.994 0 0 1 2 20V6zm2 1v12h16V7H4zm10 9a3 3 0 1 0 0-6 3 3 0 0 0 0 6zm0 2a5 5 0 1 1 0-10 5 5 0 0 1 0 10zM4 2h6v2H4V2z\"></path>                   </svg>', 'category_6.png', '2022-12-01 00:00:00'),
(6, 7, 'Sports', '<span class=\"mr-3 rounded-xl bg-[#EBEDFF] p-[0.375rem]\">\n                        <svg\n                          xmlns=\"http://www.w3.org/2000/svg\"\n                          viewBox=\"0 0 24 24\"\n                          width=\"24\"\n                          height=\"24\"\n                          class=\"h-4 w-4 fill-[#737EF2]\"\n                        >\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\n                          <path\n                            d=\"M12 2c5.523 0 10 4.477 10 10s-4.477 10-10 10S2 17.523 2 12 6.477 2 12 2zm.366 11.366l-3.469 6.01a8.053 8.053 0 0 0 4.459.51 9.937 9.937 0 0 1 .784-5.494l-1.774-1.026zm3.518 2.031a7.956 7.956 0 0 0-.587 3.894 8.022 8.022 0 0 0 3.077-2.456l-2.49-1.438zm-7.025-4.055a9.95 9.95 0 0 1-4.365 3.428 8.01 8.01 0 0 0 2.671 3.604l3.469-6.008-1.775-1.024zm11.103-.13l-.258.12a7.947 7.947 0 0 0-2.82 2.333l2.492 1.439a7.975 7.975 0 0 0 .586-3.893zM4 12c0 .266.013.53.038.789a7.95 7.95 0 0 0 3.078-2.454L4.624 8.897A7.975 7.975 0 0 0 4 12zm12.835-6.374l-3.469 6.008 1.775 1.025a9.95 9.95 0 0 1 4.366-3.43 8.015 8.015 0 0 0-2.419-3.402l-.253-.201zM12 4c-.463 0-.916.04-1.357.115a9.928 9.928 0 0 1-.784 5.494l1.775 1.025 3.469-6.01A7.975 7.975 0 0 0 12 4zm-3.297.71l-.191.088a8.033 8.033 0 0 0-2.886 2.367l2.49 1.438a7.956 7.956 0 0 0 .587-3.893z\"\n                          />\n                        </svg>\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M12 22C6.477 22 2 17.523 2 12S6.477 2 12 2s10 4.477 10 10-4.477 10-10 10zm-2.29-2.333A17.9 17.9 0 0 1 8.027 13H4.062a8.008 8.008 0 0 0 5.648 6.667zM10.03 13c.151 2.439.848 4.73 1.97 6.752A15.905 15.905 0 0 0 13.97 13h-3.94zm9.908 0h-3.965a17.9 17.9 0 0 1-1.683 6.667A8.008 8.008 0 0 0 19.938 13zM4.062 11h3.965A17.9 17.9 0 0 1 9.71 4.333 8.008 8.008 0 0 0 4.062 11zm5.969 0h3.938A15.905 15.905 0 0 0 12 4.248 15.905 15.905 0 0 0 10.03 11zm4.259-6.667A17.9 17.9 0 0 1 15.973 11h3.965a8.008 8.008 0 0 0-5.648-6.667z\"></path>                   </svg>', 'category_5.png', '2022-12-01 00:00:00'),
(7, 8, 'Virtual Worlds', ' <span class=\"mr-3 rounded-xl bg-[#EEFCFF] p-[0.375rem]\">\r\n                        <svg\r\n                          xmlns=\"http://www.w3.org/2000/svg\"\r\n                          viewBox=\"0 0 24 24\"\r\n                          width=\"24\"\r\n                          height=\"24\"\r\n                          class=\"h-4 w-4 fill-[#46C7E3]\"\r\n                        >\r\n                          <path fill=\"none\" d=\"M0 0h24v24H0z\" />\r\n                          <path\r\n                            d=\"M12 22C6.477 22 2 17.523 2 12S6.477 2 12 2s10 4.477 10 10-4.477 10-10 10zm-2.29-2.333A17.9 17.9 0 0 1 8.027 13H4.062a8.008 8.008 0 0 0 5.648 6.667zM10.03 13c.151 2.439.848 4.73 1.97 6.752A15.905 15.905 0 0 0 13.97 13h-3.94zm9.908 0h-3.965a17.9 17.9 0 0 1-1.683 6.667A8.008 8.008 0 0 0 19.938 13zM4.062 11h3.965A17.9 17.9 0 0 1 9.71 4.333 8.008 8.008 0 0 0 4.062 11zm5.969 0h3.938A15.905 15.905 0 0 0 12 4.248 15.905 15.905 0 0 0 10.03 11zm4.259-6.667A17.9 17.9 0 0 1 15.973 11h3.965a8.008 8.008 0 0 0-5.648-6.667z\"\r\n                          />\r\n                        </svg>\r\n                      </span>', '<svg xmlns=\"http://www.w3.org/2000/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" class=\"mr-1 h-4 w-4 fill-jacarta-700 transition-colors group-hover:fill-white dark:fill-jacarta-100\">                     <path fill=\"none\" d=\"M0 0h24v24H0z\"></path>                     <path d=\"M12 22C6.477 22 2 17.523 2 12S6.477 2 12 2s10 4.477 10 10-4.477 10-10 10zm-2.29-2.333A17.9 17.9 0 0 1 8.027 13H4.062a8.008 8.008 0 0 0 5.648 6.667zM10.03 13c.151 2.439.848 4.73 1.97 6.752A15.905 15.905 0 0 0 13.97 13h-3.94zm9.908 0h-3.965a17.9 17.9 0 0 1-1.683 6.667A8.008 8.008 0 0 0 19.938 13zM4.062 11h3.965A17.9 17.9 0 0 1 9.71 4.333 8.008 8.008 0 0 0 4.062 11zm5.969 0h3.938A15.905 15.905 0 0 0 12 4.248 15.905 15.905 0 0 0 10.03 11zm4.259-6.667A17.9 17.9 0 0 1 15.973 11h3.965a8.008 8.008 0 0 0-5.648-6.667z\"></path>                   </svg>', 'category_4.png', '2022-12-01 00:00:00');

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

--
-- Table structure for table `keylist`
--

CREATE TABLE `keylist` (
  `id` int(11) NOT NULL,
  `text` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `keylist`
--

INSERT INTO `keylist` (`id`, `text`, `createdAt`) VALUES
(1, 'abandon ability able about above absent absorb abstract absurd abuse access accident account accuse achieve acid acoustic acquire across act action actor actress actual adapt add addict address adjust admit adult advance advice aerobic affair afford afraid again age agent agree ahead aim air airport aisle alarm album alcohol alert alien all alley allow almost alone alpha already also alter always amateur amazing among amount amused analyst anchor ancient anger angle angry animal ankle announce annual another answer antenna antique anxiety any apart apology appear apple approve april arch arctic area arena argue arm armed armor army around arrange arrest arrive arrow art artefact artist artwork ask aspect assault asset assist assume asthma athlete atom attack attend attitude attract auction audit august aunt author auto autumn average avocado avoid awake aware away awesome awful awkward axis baby bachelor bacon badge bag balance balcony ball bamboo banana banner bar barely bargain barrel base basic basket battle beach bean beauty because become beef before begin behave behind believe below belt bench benefit best betray better between beyond bicycle bid bike bind biology bird birth bitter black blade blame blanket blast bleak bless blind blood blossom blouse blue blur blush board boat body boil bomb bone bonus book boost border boring borrow boss bottom bounce box boy bracket brain brand brass brave bread breeze brick bridge brief bright bring brisk broccoli broken bronze broom brother brown brush bubble buddy budget buffalo build bulb bulk bullet bundle bunker burden burger burst bus business busy butter buyer buzz cabbage cabin cable cactus cage cake call calm camera camp can canal cancel candy cannon canoe canvas canyon capable capital captain car carbon card cargo carpet carry cart case cash casino castle casual cat catalog catch category cattle caught cause caution cave ceiling celery cement census century cereal certain chair chalk champion change chaos chapter charge chase chat cheap check cheese chef cherry chest chicken chief child chimney choice choose chronic chuckle chunk churn cigar cinnamon circle citizen city civil claim clap clarify claw clay clean clerk clever click client cliff climb clinic clip clock clog close cloth cloud clown club clump cluster clutch coach coast coconut code coffee coil coin collect color column combine come comfort comic common company concert conduct confirm congress connect consider control convince cook cool copper copy coral core corn correct cost cotton couch country couple course cousin cover coyote crack cradle craft cram crane crash crater crawl crazy cream credit creek crew cricket crime crisp critic crop cross crouch crowd crucial cruel cruise crumble crunch crush cry crystal cube culture cup cupboard curious current curtain curve cushion custom cute cycle dad damage damp dance danger daring dash daughter dawn day deal debate debris decade december decide decline decorate decrease deer defense define defy degree delay deliver demand demise denial dentist deny depart depend deposit depth deputy derive describe desert design desk despair destroy detail detect develop device devote diagram dial diamond diary dice diesel diet differ digital dignity dilemma dinner dinosaur direct dirt disagree discover disease dish dismiss disorder display distance divert divide divorce dizzy doctor document dog doll dolphin domain donate donkey donor door dose double dove draft dragon drama drastic draw dream dress drift drill drink drip drive drop drum dry duck dumb dune during dust dutch duty dwarf dynamic eager eagle early earn earth easily east easy echo ecology economy edge edit educate effort egg eight either elbow elder electric elegant element elephant elevator elite else embark embody embrace emerge emotion employ empower empty enable enact end endless endorse enemy energy enforce engage engine enhance enjoy enlist enough enrich enroll ensure enter entire entry envelope episode equal equip era erase erode erosion error erupt escape essay essence estate eternal ethics evidence evil evoke evolve exact example excess exchange excite exclude excuse execute exercise exhaust exhibit exile exist exit exotic expand expect expire explain expose express extend extra eye eyebrow fabric face faculty fade faint faith fall false fame family famous fan fancy fantasy farm fashion fat fatal father fatigue fault favorite feature february federal fee feed feel female fence festival fetch fever few fiber fiction field figure file film filter final find fine finger finish fire firm first fiscal fish fit fitness fix flag flame flash flat flavor flee flight flip float flock floor flower fluid flush fly foam focus fog foil fold follow food foot force forest forget fork fortune forum forward fossil foster found fox fragile frame frequent fresh friend fringe frog front frost frown frozen fruit fuel fun funny furnace fury future gadget gain galaxy gallery game gap garage garbage garden garlic garment gas gasp gate gather gauge gaze general genius genre gentle genuine gesture ghost giant gift giggle ginger giraffe girl give glad glance glare glass glide glimpse globe gloom glory glove glow glue goat goddess gold good goose gorilla gospel gossip govern gown grab grace grain grant grape grass gravity great green grid grief grit grocery group grow grunt guard guess guide guilt guitar gun gym habit hair half hammer hamster hand happy harbor hard harsh harvest hat have hawk hazard head health heart heavy hedgehog height hello helmet help hen hero hidden high hill hint hip hire history hobby hockey hold hole holiday hollow home honey hood hope horn horror horse hospital host hotel hour hover hub huge human humble humor hundred hungry hunt hurdle hurry hurt husband hybrid ice icon idea identify idle ignore ill illegal illness image imitate immense immune impact impose improve impulse inch include income increase index indicate indoor industry infant inflict inform inhale inherit initial inject injury inmate inner innocent input inquiry insane insect inside inspire install intact interest into invest invite involve iron island isolate issue item ivory jacket jaguar jar jazz jealous jeans jelly jewel job join joke journey joy judge juice jump jungle junior junk just kangaroo keen keep ketchup key kick kid kidney kind kingdom kiss kit kitchen kite kitten kiwi knee knife knock know lab label labor ladder lady lake lamp language laptop large later latin laugh laundry lava law lawn lawsuit layer lazy leader leaf learn leave lecture left leg legal legend leisure lemon lend length lens leopard lesson letter level liar liberty library license life lift light like limb limit link lion liquid list little live lizard load loan lobster local lock logic lonely long loop lottery loud lounge love loyal lucky luggage lumber lunar lunch luxury lyrics machine mad magic magnet maid mail main major make mammal man manage mandate mango mansion manual maple marble march margin marine market marriage mask mass master match material math matrix matter maximum maze meadow mean measure meat mechanic medal media melody melt member memory mention menu mercy merge merit merry mesh message metal method middle midnight milk million mimic mind minimum minor minute miracle mirror misery miss mistake mix mixed mixture mobile model modify mom moment monitor monkey monster month moon moral more morning mosquito mother motion motor mountain mouse move movie much muffin mule multiply muscle museum mushroom music must mutual myself mystery myth naive name napkin narrow nasty nation nature near neck need negative neglect neither nephew nerve nest net network neutral never news next nice night noble noise nominee noodle normal north nose notable note nothing notice novel now nuclear number nurse nut oak obey object oblige obscure observe obtain obvious occur ocean october odor off offer office often oil okay old olive olympic omit once one onion online only open opera opinion oppose option orange orbit orchard order ordinary organ orient original orphan ostrich other outdoor outer output outside oval oven over own owner oxygen oyster ozone pact paddle page pair palace palm panda panel panic panther paper parade parent park parrot party pass patch path patient patrol pattern pause pave payment peace peanut pear peasant pelican pen penalty pencil people pepper perfect permit person pet phone photo phrase physical piano picnic picture piece pig pigeon pill pilot pink pioneer pipe pistol pitch pizza place planet plastic plate play please pledge pluck plug plunge poem poet point polar pole police pond pony pool popular portion position possible post potato pottery poverty powder power practice praise predict prefer prepare present pretty prevent price pride primary print priority prison private prize problem process produce profit program project promote proof property prosper protect proud provide public pudding pull pulp pulse pumpkin punch pupil puppy purchase purity purpose purse push put puzzle pyramid quality quantum quarter question quick quit quiz quote rabbit raccoon race rack radar radio rail rain raise rally ramp ranch random range rapid rare rate rather raven raw razor ready real reason rebel rebuild recall receive recipe record recycle reduce reflect reform refuse region regret regular reject relax release relief rely remain remember remind remove render renew rent reopen repair repeat replace report require rescue resemble resist resource response result retire retreat return reunion reveal review reward rhythm rib ribbon rice rich ride ridge rifle right rigid ring riot ripple risk ritual rival river road roast robot robust rocket romance roof rookie room rose rotate rough round route royal rubber rude rug rule run runway rural sad saddle sadness safe sail salad salmon salon salt salute same sample sand satisfy satoshi sauce sausage save say scale scan scare scatter scene scheme school science scissors scorpion scout scrap screen script scrub sea search season seat second secret section security seed seek segment select sell seminar senior sense sentence series service session settle setup seven shadow shaft shallow share shed shell sheriff shield shift shine ship shiver shock shoe shoot shop short shoulder shove shrimp shrug shuffle shy sibling sick side siege sight sign silent silk silly silver similar simple since sing siren sister situate six size skate sketch ski skill skin skirt skull slab slam sleep slender slice slide slight slim slogan slot slow slush small smart smile smoke smooth snack snake snap sniff snow soap soccer social sock soda soft solar soldier solid solution solve someone song soon sorry sort soul sound soup source south space spare spatial spawn speak special speed spell spend sphere spice spider spike spin spirit split spoil sponsor spoon sport spot spray spread spring spy square squeeze squirrel stable stadium staff stage stairs stamp stand start state stay steak steel stem step stereo stick still sting stock stomach stone stool story stove strategy street strike strong struggle student stuff stumble style subject submit subway success such sudden suffer sugar suggest suit summer sun sunny sunset super supply supreme sure surface surge surprise surround survey suspect sustain swallow swamp swap swarm swear sweet swift swim swing switch sword symbol symptom syrup system table tackle tag tail talent talk tank tape target task taste tattoo taxi teach team tell ten tenant tennis tent term test text thank that theme then theory there they thing this thought three thrive throw thumb thunder ticket tide tiger tilt timber time tiny tip tired tissue title toast tobacco today toddler toe together toilet token tomato tomorrow tone tongue tonight tool tooth top topic topple torch tornado tortoise toss total tourist toward tower town toy track trade traffic tragic train transfer trap trash travel tray treat tree trend trial tribe trick trigger trim trip trophy trouble truck true truly trumpet trust truth try tube tuition tumble tuna tunnel turkey turn turtle twelve twenty twice twin twist two type typical ugly umbrella unable unaware uncle uncover under undo unfair unfold unhappy uniform unique unit universe unknown unlock until unusual unveil update upgrade uphold upon upper upset urban urge usage use used useful useless usual utility vacant vacuum vague valid valley valve van vanish vapor various vast vault vehicle velvet vendor venture venue verb verify version very vessel veteran viable vibrant vicious victory video view village vintage violin virtual virus visa visit visual vital vivid vocal voice void volcano volume vote voyage wage wagon wait walk wall walnut want warfare warm warrior wash wasp waste water wave way wealth weapon wear weasel weather web wedding weekend weird welcome west wet whale what wheat wheel when where whip whisper wide width wife wild will win window wine wing wink winner winter wire wisdom wise wish witness wolf woman wonder wood wool word work world worry worth wrap wreck wrestle wrist write wrong yard year yellow you young youth zebra zero zone zoo', '2022-12-26 07:32:14');

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

--
-- Table structure for table `nfts`
--

CREATE TABLE `nfts` (
  `nft_id` int(11) NOT NULL,
  `asset` text NOT NULL,
  `username` text NOT NULL,
  `nft_name` text NOT NULL,
  `image` text NOT NULL,
  `tagline` text DEFAULT NULL,
  `description` text NOT NULL,
  `amount` double NOT NULL,
  `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minted` int(11) NOT NULL,
  `explicit` int(11) DEFAULT 0,
  `collection` int(11) DEFAULT 0 COMMENT 'Categories',
  `level` int(11) NOT NULL DEFAULT 20,
  `payment_id` int(11) NOT NULL,
  `nft_status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fee` double DEFAULT 5,
  `metadata` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `refrence_id` text DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp(),
  `updatetimedAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `nfts`
--

INSERT INTO `nfts` (`nft_id`, `asset`, `username`, `nft_name`, `image`, `tagline`, `description`, `amount`, `link`, `minted`, `explicit`, `collection`, `level`, `payment_id`, `nft_status`, `fee`, `metadata`, `refrence_id`, `createdAt`, `updatetimedAt`) VALUES
(1, '0x49c36afa33642da38c8564c', 'degods', 'DeGod #86', '1680712588Screen Shot 2023-04-05 at 5.34.50 PM.png', NULL, 'A collection of 10,000 of the most degenerate gods in the universe.', 0.092, 'https://etherscan.io/address/0x8821bee2ba0df28761afff119d66390d594cd280', 3, 0, 2, 20, 24, 'active', 0.17, '0', '642da38c85650', '2023-04-05 09:36:28', '2023-04-05 09:36:28'),
(2, '0x49c36afa33642da40a80056', 'degods', 'DeGod #2448', '1680712714Screen Shot 2023-04-05 at 5.38.13 PM.png', NULL, 'A collection of 10,000 of the most degenerate gods in the universe.', 0.67, 'https://etherscan.io/address/0x8821bee2ba0df28761afff119d66390d594cd280', 8, 0, 2, 20, 24, 'sale', 0.17, '0', '642da40a80058', '2023-04-05 09:38:34', '2023-04-05 09:38:34'),
(3, '0x49c36afa33642da527c8f87', 'coolcats', 'Cool Cat #573', '1680712999Screen Shot 2023-04-05 at 5.43.02 PM.png', NULL, 'Cool Cats is a collection of 9,999 randomly generated and stylistically curated NFTs that exist on the Ethereum Blockchain.', 1.1237, 'https://etherscan.io/address/0x1a92f7381b9f03921564a437210bb9396471050c', 3, 0, 3, 20, 24, 'active', 0.17, '0', '642da527c8f89', '2023-04-05 09:43:19', '2023-04-05 09:43:19'),
(4, '0x49c36afa33642da7547a772', 'coolcats', 'Cool Cat #9741', '1680713556Screen Shot 2023-04-05 at 5.52.16 PM.png', NULL, 'Cool Cats is a collection of 9,999 randomly generated and stylistically curated NFTs that exist on the Ethereum Blockchain.', 1.1237, 'https://etherscan.io/address/0x1a92f7381b9f03921564a437210bb9396471050c', 5, 0, 3, 20, 24, 'sold', 0.17, '0', '642da7547a773', '2023-04-05 09:52:36', '2023-04-05 09:52:36'),
(5, '0x49c36afa33642da7f9c34c9', 'boredapeyachtclub', '#1751', '1680713721Screen Shot 2023-04-05 at 5.54.34 PM.png', NULL, 'The Bored Ape Yacht Club is a collection of 10,000 unique Bored Ape NFTsâ€” unique digital collectibles living on the Ethereum blockchain. Your Bored Ape doubles as your Yacht Club membership card, and grants access to members-only benefits, the first of which is access to THE BATHROOM, a collaborative graffiti board. ', 1.9, 'https://etherscan.io/address/0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', 7, 0, 6, 20, 24, 'active', 0.17, '0', '642da7f9c34cc', '2023-04-05 09:55:21', '2023-04-05 09:55:21'),
(6, '0x49c36afa33642da868f1374', 'boredapeyachtclub', '#8795', '1680713832Screen Shot 2023-04-05 at 5.56.50 PM.png', NULL, 'The Bored Ape Yacht Club is a collection of 10,000 unique Bored Ape NFTsâ€” unique digital collectibles living on the Ethereum blockchain.', 0.83, 'https://etherscan.io/address/0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', 4, 0, 6, 20, 24, 'active', 0.17, '0', '642da868f1376', '2023-04-05 09:57:12', '2023-04-05 09:57:12'),
(7, '0x49c36afa33642dab7d5e673', 'opepen', 'Opepen Edition 3804', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 1.883, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 6, 0, 8, 20, 24, 'active', 0.17, '0', '642dab7d5e676', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(8, '0x49c36alkjhgt42dab7d5e673', 'opepen', 'Opepen Edition 8766', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 1.383, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 3, 0, 8, 20, 24, 'active', 0.17, '0', '642dab7d5es87s', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(9, '0x49c36afa33642dac27794b4', 'doodles', 'Doodle #74', '1680714791Screen Shot 2023-04-05 at 6.12.18 PM.png', NULL, 'A community-driven collectibles project featuring art by Burnt Toast. Doodles come in a joyful range of colors, traits and sizes with a collection size of 10,000. Each Doodle allows its owner to vote for experiences and activations paid for by the Doodles Community Treasury. Burnt Toast is the working alias for Scott Martin, a Canadianâ€“based illustrator, designer, animator and muralist.', 0.655, 'https://etherscan.io/address/0x8a90cab2b38dba80c64b7734e58ee1db38b8992e', 4, 0, 5, 20, 24, 'active', 0.17, '0', '642dac27794b7', '2023-04-05 10:13:11', '2023-04-05 10:13:11'),
(10, '0x49c36alkjhgt42dab7d5e8763', 'opepen', 'Opepen Edition 8926', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 1.081, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 9, 0, 8, 20, 24, 'active', 0.17, '0', '642dab7d5eskjhggs', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(11, '0x49c36afa33642dac7df0634', 'doodles', 'Doodle #5770', '1680714877Screen Shot 2023-04-05 at 6.14.04 PM.png', NULL, 'A community-driven collectibles project featuring art by Burnt Toast. Doodles come in a joyful range of colors, traits and sizes with a collection size of 10,000', 0.2876, 'https://etherscan.io/address/0x8821bee2ba0df28761afff119d66390d594cd280', 8, 0, 7, 20, 24, 'active', 0.17, '0', '642dac7df0636', '2023-04-05 10:14:37', '2023-04-05 10:14:37'),
(12, '0x49c36iuhgs2dab7d5e8763', 'opepen', 'Opepen Edition 1990', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 0.282, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 10, 0, 8, 20, 24, 'active', 0.17, '0', '68765d5eskjhggs', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(13, '0x43436afa33642da7f9c34c9', 'boredapeyachtclub', '#1759', '1680713721Screen Shot 2023-04-05 at 5.54.34 PM.png', NULL, 'The Bored Ape Yacht Club is a collection of 10,000 unique Bored Ape NFTsâ€” unique digital collectibles living on the Ethereum blockchain. Your Bored Ape doubles as your Yacht Club membership card, and grants access to members-only benefits, the first of which is access to THE BATHROOM, a collaborative graffiti board. ', 1, 'https://etherscan.io/address/0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', 7, 0, 6, 20, 24, 'active', 0.17, '0', '642da7ffds34cc', '2023-04-05 09:55:21', '2023-04-05 09:55:21'),
(14, '0x49c36afa33642da868f1374', 'boredapeyachtclub', '#8233', '1680713832Screen Shot 2023-04-05 at 5.56.50 PM.png', NULL, 'The Bored Ape Yacht Club is a collection of 10,000 unique Bored Ape NFTsâ€” unique digital collectibles living on the Ethereum blockchain.', 0.73, 'https://etherscan.io/address/0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', 4, 0, 6, 20, 24, 'sale', 0.17, '0', '642da868f12d', '2023-04-05 09:57:12', '2023-04-05 09:57:12'),
(15, '0x49c36iuhgs2dab7d5e8763', 'opepen', 'Opepen Edition 1098', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 0.28, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 10, 0, 8, 20, 24, 'sold', 0.17, '0', '687kjgheskjhggs', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(16, '0x49c36aljuhygghss5e673', 'opepen', 'Opepen Edition 8987', '1680714621Screen Shot 2023-04-05 at 6.08.54 PM.png', NULL, 'This artwork may or may not be handmade.', 1.83, 'https://etherscan.io/address/0x6339e5e072086621540d0362c4e3cea0d643e114', 3, 0, 8, 20, 24, 'sale', 0.17, '0', 'fhgjhkjhgfss', '2023-04-05 10:10:21', '2023-04-05 10:10:21'),
(17, '0x49knjhggh72dac27794b4', 'doodles', 'Doodle #709', '1680714791Screen Shot 2023-04-05 at 6.12.18 PM.png', NULL, 'A community-driven collectibles project featuring art by Burnt Toast. Doodles come in a joyful range of colors, traits and sizes with a collection size of 10,000. Each Doodle allows its owner to vote for experiences and activations paid for by the Doodles Community Treasury. Burnt Toast is the working alias for Scott Martin, a Canadianâ€“based illustrator, designer, animator and muralist.', 0.85, 'https://etherscan.io/address/0x8a90cab2b38dba80c64b7734e58ee1db38b8992e', 4, 0, 5, 20, 24, 'active', 0.17, '0', '642dac2779hgf', '2023-04-05 10:13:11', '2023-04-05 10:13:11');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `payment_name` varchar(200) NOT NULL,
  `short_name` text NOT NULL,
  `svg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet_address` text NOT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `payment_id`, `payment_name`, `short_name`, `svg`, `wallet_address`, `currency`, `createdAt`) VALUES
(2, 24, 'Ethereum', 'ETH', '', '0xC55AE9e64fD6a598Caac72c2b66a4359c54BEA36', '$', '2022-12-01 00:00:00');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `web_name` text NOT NULL,
  `web_tagline` text NOT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  `email` text NOT NULL,
  `image` text NOT NULL,
  `max_deposit` text NOT NULL,
  `min_deposit` text NOT NULL,
  `gasfee` double NOT NULL DEFAULT 0.0677,
  `royalties` int(11) NOT NULL DEFAULT 5,
  `livechat` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `web_name`, `web_tagline`, `currency`, `phone`, `address`, `email`, `image`, `max_deposit`, `min_deposit`, `gasfee`, `royalties`, `livechat`, `createdAt`) VALUES
(1, 'Xhibiter', 'NFT Marketplace', '$', '08114313795', '18th Str NW, 24 Washington DC', 'support@dirtyscripts.shop', 'logo.png', '100000', '0.00001', 0.17, 20, '#', '2022-12-01 00:00:00');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `id` int(11) NOT NULL,
  `ticket_id` text NOT NULL,
  `username` text NOT NULL,
  `acct_email` text NOT NULL,
  `reference_id` text NOT NULL,
  `amount` double DEFAULT NULL,
  `messageid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trans_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ticket_status` int(11) NOT NULL DEFAULT 0,
  `ticket_type` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `acct_fullname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` text NOT NULL,
  `acct_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance` double NOT NULL DEFAULT 0,
  `avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acct_password` varchar(255) NOT NULL,
  `twitter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text DEFAULT NULL,
  `wallkeys` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified` int(11) NOT NULL DEFAULT 0,
  `acct_status` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `user_id`, `acct_fullname`, `username`, `acct_email`, `bio`, `balance`, `avatar`, `user_cover`, `acct_password`, `twitter`, `address`, `wallkeys`, `verified`, `acct_status`, `createdAt`) VALUES
(1, 53, 'DeGods', 'degods', 'Degods876567@gmail.com', 'DeGods is a digital art collection and global community of creators, developers, entrepreneurs, athletes, artists, experimenters and innovators.', 0.73521, 'degodsScreen Shot 2023-04-05 at 6.03.41 PM.png', NULL, '$2y$10$UIawHWy4jJbuq7uHDIWXCeZWA/o7/A70o8gBYin7SSoA/iWZ3rMui', 'ofofonobs', '0x69D00Ac89642d9b2fdb92e', 'good', 1, 'active', '2023-04-05 08:40:37'),
(3, 54, 'Cool Cats NFT', 'coolcats', 'coolcats32@gmail.com', 'Cool Cats is a collection of 9,999 randomly generated and stylistically curated NFTs that exist on the Ethereum Blockchain.', 0.521, 'coolcatsScreen Shot 2023-04-05 at 6.03.08 PM.png', NULL, '$2y$10$UIawHWy4jJbuq7uHDIWXCeZWA/o7/A70o8gBYin7SSoA/iWZ3rMui', 'coolcats', '', NULL, 1, 'active', '2023-04-05 08:40:37'),
(4, 56, 'Bored Ape Yacht Club', 'boredapeyachtclub', 'boredapemail2@gmail.com', 'The Bored Ape Yacht Club is a collection of 10,000 unique Bored Ape NFTs— unique digital collectibles living on the Ethereum blockchain.', 0.007, 'boredapeyachtclubScreen Shot 2023-04-05 at 6.00.09 PM.png', NULL, '$2y$10$UIawHWy4jJbuq7uHDIWXCeZWA/o7/A70o8gBYin7SSoA/iWZ3rMui', 'boredape', '', NULL, 1, 'active', '2023-04-05 08:40:37'),
(5, 56, 'Opepen Edition', 'opepen', 'Opepenedition97@gmail.com', 'This artwork may or may not be handmade.', 0.007, 'opepenScreen Shot 2023-04-05 at 6.07.19 PM.png', NULL, '$2y$10$UIawHWy4jJbuq7uHDIWXCeZWA/o7/A70o8gBYin7SSoA/iWZ3rMui', 'Opepen', '', NULL, 1, 'active', '2023-04-05 08:40:37'),
(6, 56, 'Doodles Offical', 'doodles', 'Doodleson97@gmail.com', ' community-driven collectibles project featuring art by Burnt Toast. Doodles come in a joyful range of colors, traits and sizes with a collection size of 10,000. ', 0.02, 'doodlesScreen Shot 2023-04-05 at 6.11.09 PM.png', NULL, '$2y$10$UIawHWy4jJbuq7uHDIWXCeZWA/o7/A70o8gBYin7SSoA/iWZ3rMui', 'doodles', '', NULL, 1, 'active', '2023-04-05 08:40:37');

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

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

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `amount` double NOT NULL,
  `wallet_address` text DEFAULT NULL,
  `payment_id` int(11) DEFAULT 24,
  `image` text DEFAULT NULL,
  `refrence_id` text DEFAULT NULL,
  `trans_type` text NOT NULL,
  `wallet_status` int(11) NOT NULL DEFAULT 0,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `wallet` (`id`, `username`, `amount`, `wallet_address`, `payment_id`, `image`, `refrence_id`, `trans_type`, `wallet_status`, `createdAt`) VALUES
(1, 'Ofofonobs', 0.00321, NULL, 24, '1680710838gtbank.png', '642d9cb641da1', 'Funding', 3, '2023-04-05 09:07:18'),
(2, 'Ofofonobs', 0.002, NULL, 24, NULL, '642d9daf3834f', 'Funding', 1, '2023-04-06 00:00:00'),
(3, 'Ofofonobs', 0.75, NULL, 24, NULL, '642d9dc818060', 'Funding', 1, '2023-04-13 00:00:00'),
(4, 'Ofofonobs', 0.01, 'D8TsD87dVjDFSoN33vYnrqva58dmnMdfPN', 24, NULL, '642da053a9475', 'Withdrawal', 1, '2023-04-05 09:22:43'),
(5, 'Ofofonobs', 0.01, 'D8TsD87dVjDFSoN33vYnrqva58dmnMdfPN', 24, NULL, '642da05a48b19', 'Withdrawal', 1, '2023-04-05 09:22:50');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
  ADD PRIMARY KEY (`blog_id`);

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

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

--
-- Indexes for table `nfts`
--
ALTER TABLE `nfts`
  ADD PRIMARY KEY (`nft_id`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `wallet`
--
ALTER TABLE `wallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;

Back to Directory File Manager