PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u342410624/domains/srareauctionmarket.com/public_html/database/default.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 03, 2024 at 03:58 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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: `marible`
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `nft_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_09_16_162705_create_marketplace_listings_table', 1),
(5, '2024_09_16_162705_create_nfts_table', 1),
(6, '2024_09_26_052816_create_cache_table', 2),
(7, '2024_10_03_135344_create_cache_table', 0),
(8, '2024_10_03_135344_create_cache_locks_table', 0),
(9, '2024_10_03_135344_create_likes_table', 0),
(10, '2024_10_03_135344_create_nft_categories_table', 0),
(11, '2024_10_03_135344_create_nfts_table', 0),
(12, '2024_10_03_135344_create_password_reset_tokens_table', 0),
(13, '2024_10_03_135344_create_role_user_table', 0),
(14, '2024_10_03_135344_create_roles_table', 0),
(15, '2024_10_03_135344_create_sessions_table', 0),
(16, '2024_10_03_135344_create_settings_table', 0),
(17, '2024_10_03_135344_create_transactions_table', 0),
(18, '2024_10_03_135344_create_users_table', 0);

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

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

CREATE TABLE `nfts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nft_name` varchar(255) DEFAULT NULL,
  `nft_image` varchar(255) DEFAULT NULL,
  `nft_price` double NOT NULL DEFAULT 0,
  `nft_price_usd` double NOT NULL DEFAULT 0,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `nft_category_id` varchar(255) NOT NULL,
  `user_id` int(55) NOT NULL,
  `old_user_id` int(55) DEFAULT 0,
  `nft_description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `nfts` (`id`, `nft_name`, `nft_image`, `nft_price`, `nft_price_usd`, `status`, `nft_category_id`, `user_id`, `old_user_id`, `nft_description`, `created_at`, `updated_at`) VALUES
(1, 'The Pretty Fantasy Flower', 'card-item-3.jpg', 0.3453, 388, '1', '1', 6, 3, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', NULL),
(2, 'Space babe - Night 2/25', 'card-item-10.jpg', 0.0011, 433, '1', '2', 2, 2, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-25 19:11:43'),
(4, 'Crypto Egg Stamp #5', 'card-item-2.jpg', 0.052, 245, '1', '4', 2, 6, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-21 17:59:51'),
(5, 'Kashys Essential Store', 'card-item-7.jpg', 0.633, 245, '1', '3', 4, 2, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-25 13:54:10'),
(6, 'Monkey King', 'card-item-4.jpg', 0.551, 244, '1', '2', 6, 3, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-25 16:03:58'),
(7, 'Junk Egg Stamp #8', 'card-item-2.jpg', 0.056, 53, '1', '4', 5, 5, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-21 17:59:51'),
(8, 'CyberPrimal 072 LAN', 'card-item-9.jpg', 0.061, 63, '1', '3', 4, 4, 'Habitant sollicitudin faucibus cursus lectus pulvinar dolor non ultrices eget.', '2024-09-16 17:51:46', '2024-09-25 16:15:06');

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

--
-- Table structure for table `nft_categories`
--

CREATE TABLE `nft_categories` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `nft_categories`
--

INSERT INTO `nft_categories` (`id`, `category_name`) VALUES
(1, 'Art'),
(2, 'Music'),
(3, 'Collectibles'),
(4, 'Sports');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`) VALUES
(1, 'admin'),
(2, 'user');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`id`, `user_id`, `role_id`) VALUES
(1, 1, 1);

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('WcbxX84qw6W03rNpK2naTb8dAE1Np1fDcvc76QH6', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:130.0) Gecko/20100101 Firefox/130.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnM1WHBEa29Ma3djQ05pYjJ1d0tRcUJkMTV5bUY3aENiRXdhcUFEeSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9pbnN0YWxsIjt9fQ==', 1727963877);

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `settings_key` text DEFAULT NULL,
  `settings_value` text DEFAULT NULL,
  `settings_description` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`id`, `settings_key`, `settings_value`, `settings_description`, `created_at`, `updated_at`) VALUES
(1, 'site_name', 'Marible', 'site name', '2024-09-25 15:05:33', '2024-09-25 15:05:33'),
(2, 'site_email', 'ofofonobs@gmail.com', 'site email', '2024-09-25 15:05:33', '2024-09-25 15:05:33'),
(3, 'site_phone', '08114313795', 'phone number', '2024-09-25 15:06:36', '2024-09-25 15:06:36'),
(4, 'site_logo', 'logo_dark.png', 'site logo', '2024-09-25 15:06:52', '2024-09-25 15:06:52'),
(5, 'nft_fee', '74', 'nft fee', '2024-09-25 15:07:07', '2024-09-25 15:07:07'),
(6, 'fee_status', '1', '1 = active, 0 = disabled', '2024-09-25 15:07:25', '2024-09-25 15:07:25'),
(7, 'wallet_address', '0xb9c04F01FDa6be4156B613B5C9DDFCDde7Fa5c02', 'Deposit wallet address', '2024-09-25 15:07:25', '2024-09-25 15:07:25'),
(8, 'wallet_address_network', 'ETH', 'Crypto Network', '2024-09-25 15:07:25', '2024-09-25 15:07:25'),
(9, 'bidding_fee', '30', 'bidding fee', '2024-09-25 15:07:07', '2024-09-25 15:07:07');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(55) NOT NULL,
  `amount` double DEFAULT 0,
  `eth_amount` double DEFAULT 0,
  `network` varchar(255) DEFAULT NULL,
  `wallet_address` varchar(255) DEFAULT NULL,
  `transaction_type` enum('deposit','withdrawal','nft') NOT NULL,
  `status` enum('active','approved','completed','declined','failed','rejected','disabled','pending') NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `amount`, `eth_amount`, `network`, `wallet_address`, `transaction_type`, `status`, `created_at`, `updated_at`) VALUES
(5, 1, 2222, 1.111, 'Eth', '0x1e23b4AaE66a27BRAwdSZrG', 'deposit', 'pending', '2024-09-21 18:19:59', '2024-09-21 18:19:59'),
(6, 1, 23, 0.0115, 'Eth', '0x1e23b4AaE66a27BRAwdSZrG', 'deposit', 'completed', '2024-09-25 14:20:26', '2024-09-25 14:20:26'),
(7, 1, 100, 0.05, 'Eth', '0x1e23b4AaE66a27BRAwdSZrG', 'withdrawal', 'pending', '2024-09-25 14:28:35', '2024-09-25 14:28:35'),
(8, 1, 200, NULL, 'Eth', '87654345678qdfffsf', 'withdrawal', 'rejected', '2024-09-25 14:32:39', '2024-10-03 12:07:36'),
(10, 1, 100, 0.05, 'eth', '87654345678qdfffsf', 'withdrawal', 'rejected', '2024-09-25 14:49:40', '2024-10-03 12:16:12'),
(11, 1, 100, 0.05, 'eth', '87654345678qdfffsf', 'withdrawal', 'pending', '2024-09-25 14:49:50', '2024-09-25 14:49:50'),
(12, 1, 222, 0.111, 'eth', '87654345678qdfffsf', 'withdrawal', 'pending', '2024-09-25 14:52:39', '2024-09-25 14:52:39'),
(13, 1, 244, 0.551, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 16:52:25', '2024-09-25 16:52:25'),
(14, 1, 244, 0.551, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 16:52:47', '2024-09-25 16:52:47'),
(15, 1, 244, 0.551, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 17:03:58', '2024-09-25 17:03:58'),
(16, 1, 443, 0.161, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 17:15:06', '2024-09-25 17:15:06'),
(17, 1, 433, 0.0011, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 20:09:42', '2024-09-25 20:09:42'),
(18, 1, 433, 0.0011, 'ETH', '0x1e23b4AaE66a27BRAwdSZrG', 'nft', 'completed', '2024-09-25 20:11:43', '2024-09-25 20:11:43'),
(19, 2, 344, NULL, 'ETH', '0xb9c04F01FDa6be4156B613B5C9DDFCDde7Fa5c02', 'deposit', 'pending', '2024-09-30 07:38:21', '2024-09-30 07:38:21'),
(20, 2, 33, 0.0125, 'ETH', '0xb9c04F01FDa6be4156B613B5C9DDFCDde7Fa5c02', 'deposit', 'pending', '2024-09-30 07:39:39', '2024-09-30 07:39:39'),
(21, 2, 33, 0.0125, 'ETH', 'dffsfffffff', 'withdrawal', 'pending', '2024-09-30 07:39:55', '2024-09-30 07:39:55');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `balance` double NOT NULL DEFAULT 0,
  `wallet_address` varchar(255) DEFAULT NULL,
  `recovery_phrase` varchar(255) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `role_id` enum('1','2') NOT NULL DEFAULT '1',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `image`, `email`, `phone_number`, `balance`, `wallet_address`, `recovery_phrase`, `bio`, `role_id`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'alldarkcodes', 'avt-8.jpg', 'support@alldarkcodes.com', '08114313795', 100, '', '', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laborum obcaecati dignissimos quae quo ad iste ipsum officiis deleniti asperiores sit.', '2', '2024-09-16 18:04:17', '$2y$12$MHxfTK20FPsqykIZ2glycedWOzJtXMnDOEkSCHQ4cdg9YkeHsHuui', NULL, '2024-09-16 18:04:17', '2024-10-03 11:16:12'),
(2, 'Ofofonobs', 'avt-8.jpg', 'ofofonobs@gmail.com', '08114313795', 243.27452483325, '0x1e23b4AaE66a27g90bjoaZ6', 'house, car, bank, milk, cow, fish, box, animal, get, mat, beep, class', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laborum obcaecati dignissimos quae quo ad iste ipsum officiis deleniti asperiores sit.', '1', '2024-09-16 18:04:17', '$2y$12$MHxfTK20FPsqykIZ2glycedWOzJtXMnDOEkSCHQ4cdg9YkeHsHuui', NULL, '2024-09-16 18:04:17', '2024-10-02 17:07:35'),
(4, 'James Wealth', 'avt-9.jpg', 'jamesfhwfhd@gmail.com', '0907543672', 0, '0xwwwrr42427BRAwdSZrG', 'okay, milk, bank, club, shoe, like, ram, work, man, woman, new, egg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laborum obcaecati dignissimos quae quo ad iste ipsum officiis deleniti asperiores sit.', '1', '2024-09-16 18:04:17', '$2y$12$MHxfTK20FPsqykIZ2glycedWOzJtXMnDOEkSCHQ4cdg9YkeHsHuui', NULL, '2024-09-16 18:04:17', '2024-09-26 14:13:36'),
(5, 'PhunkMonkey', 'avt-10.jpg', 'monkey7383@gmail.com', '09075436732', 0, '0xwwwrraadfffsBRAwdSZrG', 'okay, milk, yes, club, shoe, like, ram, work, man, woman, new, egg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laborum obcaecati dignissimos quae quo ad iste ipsum officiis deleniti asperiores sit.', '1', '2024-09-16 18:04:17', '$2y$12$MHxfTK20FPsqykIZ2glycedWOzJtXMnDOEkSCHQ4cdg9YkeHsHuui', NULL, '2024-09-16 18:04:17', '2024-09-26 14:13:46'),
(6, 'Kashifat', 'avt-7.jpg', 'kashifat_broke@gmail.com', '09075853672', 0, '0xwwwrr42427BRAwdSZrG', 'house, milk, bank, club, shoe, like, ram, work, man, woman, new, egg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laborum obcaecati dignissimos quae quo ad iste ipsum officiis deleniti asperiores sit.', '1', '2024-09-16 18:04:17', '$2y$12$MHxfTK20FPsqykIZ2glycedWOzJtXMnDOEkSCHQ4cdg9YkeHsHuui', NULL, '2024-09-16 18:04:17', '2024-09-18 06:54:54');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `likes`
--
ALTER TABLE `likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `likes_user_id_foreign` (`user_id`);

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

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

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

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `likes`
--
ALTER TABLE `likes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `nfts`
--
ALTER TABLE `nfts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `likes`
--
ALTER TABLE `likes`
  ADD CONSTRAINT `likes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
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=ceiIENDB`