-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 18, 2021 at 10:13 AM
-- Server version: 5.7.35
-- PHP Version: 7.3.30

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: `techyroo_nft-api`
--

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

--
-- Table structure for table `mint`
--

CREATE TABLE `mint` (
  `id` int(11) NOT NULL,
  `tx_id` text NOT NULL,
  `wallet_address` text NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `email` text NOT NULL,
  `gas` varchar(50) NOT NULL,
  `ens` text NOT NULL,
  `cid` text NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `external_link` text NOT NULL,
  `description` text NOT NULL,
  `file_type` varchar(200) NOT NULL,
  `royality` int(11) NOT NULL,
  `timestamp_api_call` text NOT NULL,
  `mint_started` varchar(255) NOT NULL,
  `mint_finished` varchar(255) NOT NULL,
  `contract_address` text NOT NULL,
  `token_id` int(11) NOT NULL,
  `gas_paid` text NOT NULL,
  `transaction_hash` text NOT NULL,
  `status` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `mint`
--

INSERT INTO `mint` (`id`, `tx_id`, `wallet_address`, `full_name`, `email`, `gas`, `ens`, `cid`, `item_name`, `external_link`, `description`, `file_type`, `royality`, `timestamp_api_call`, `mint_started`, `mint_finished`, `contract_address`, `token_id`, `gas_paid`, `transaction_hash`, `status`) VALUES
(1, '1', '0x1ed9933FA5Ea44CAD19a1a8E1255E66e044Ec8aF', '', '', '', '', 'abc', '', '', '', '', 0, '', '', '', '', 19, '0.000000001499000003', '0x7800c9c1c0607252c1248011853824ff92bbbc5fe1dd5658305c54484a471a86', 'true'),
(2, '2', '', '', '', '253302', '', 'abc1', '', '', '', '', 0, '0', '1633586810', '1633586823', '0x6fb4EAF716E79882F8BBE70Ebd5b5827856Ab0fC', 23, '0', '', 'true');

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

--
-- Table structure for table `security`
--

CREATE TABLE `security` (
  `id` int(11) NOT NULL,
  `security_code` text NOT NULL,
  `owner` varchar(60) NOT NULL,
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `count` int(11) NOT NULL,
  `email` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `security`
--

INSERT INTO `security` (`id`, `security_code`, `owner`, `creation_time`, `count`, `email`) VALUES
(1, 'ABC', 'Admin', '2021-10-12 07:17:09', 118, 'abc@gmail.com');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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