mysqldump: [Warning] Using a password on the command line interface can be insecure.
--
-- Host: localhost    Database: laravel_db
-- ------------------------------------------------------


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `item_conditions`
--

CREATE TABLE `item_conditions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_no` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `item_conditions`
--

INSERT INTO `item_conditions` VALUES (1,'指定価格販売',1,'2021-08-31 16:47:37','2021-08-31 16:47:37');

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nft_id` bigint(20) unsigned DEFAULT NULL,
  `seller_id` bigint(20) unsigned NOT NULL,
  `buyer_id` bigint(20) unsigned DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `item_condition_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blockchain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blockchain_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ipfs_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(16,8) DEFAULT NULL,
  `resale_royalty` double(9,6) DEFAULT NULL,
  `put_for_sell_at` timestamp NULL DEFAULT NULL,
  `bought_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` VALUES (72,26,2,4,1,1,'2030','2030.jpg','xxx',NULL,'bought',NULL,NULL,'QmPpKz2teY4mugjdSsfQT4am1uE5T6mpQdtKBoDf7pQ8Dz','ETH',0.00250000,NULL,'2021-09-13 17:56:02','2021-09-15 20:16:37','2021-09-11 17:42:39','2021-09-11 17:42:39'),(79,25,2,NULL,1,1,'Lake View','nature1_gettyimages.jpg','ddd',NULL,'selling',NULL,NULL,'QmQdL72DC8b5ZepiZ1jkTP3atU39ucxt1EWC98eBXbWhWX','ETH',0.00210000,NULL,'2021-09-13 17:51:55',NULL,'2021-09-13 15:42:15','2021-09-16 16:55:08'),(80,29,1,4,1,1,'Django','0bb80e1a187264.jpg','sssssss',NULL,'bought',NULL,NULL,'QmPhYpgdBufMWW4Jtv6JJVVcihzV2sZUMuoQZtJqjURcga','ETH',0.00040000,NULL,'2021-09-13 22:10:15','2021-09-15 20:42:55','2021-09-13 22:07:58','2021-09-13 22:08:23'),(81,30,2,4,1,1,'Wong','wrong-turn5.png','wwwwww',NULL,'bought',NULL,NULL,'QmcBpAEEaWV8ARFk7p1XaGqY3BBR4cvzzFeobxPGJHXX15','ETH',0.00020000,NULL,'2021-09-15 21:47:09','2021-09-16 12:54:11','2021-09-15 21:46:24','2021-09-15 21:46:42'),(83,NULL,2,NULL,1,1,'Glass Ball','80e1a1876547264.jpeg','ddddd',NULL,'holding',NULL,NULL,'QmX9wXPqD35cqTgkmMRWsqEnGRNgifpBYnRi1St6HuiARh','ETH',0.00300000,NULL,NULL,NULL,'2021-09-15 21:56:33','2021-09-15 21:56:33'),(84,32,1,NULL,1,1,'Cute','CuteWallpapers.jpg','sssss',NULL,'selling',NULL,NULL,'QmYXzQx8bKT6E8LNxLNSya6myWdrMmkFWWnMXqsNLzjj2F','ETH',0.00045000,NULL,'2021-09-15 22:56:19',NULL,'2021-09-15 22:32:04','2021-09-16 05:12:48'),(85,34,1,NULL,1,1,'Duck','DuckPug.jpg','dddddd',NULL,'selling',NULL,NULL,'QmPgfYH9ThLC8xv2pGuFt2Wco1PsN98uVJSHbDenV91LVj','ETH',0.00500000,NULL,'2021-09-16 15:07:02',NULL,'2021-09-16 02:02:23','2021-09-16 02:02:56'),(86,33,1,2,1,1,'Invoking','invoker.jpg','aaaaaa',NULL,'bought',NULL,NULL,'QmeBYqLZLfuQA15bokUAeb2RPw7MYvk7VsCNaJJy2aeq1Q','ETH',0.00025000,NULL,'2021-09-16 14:23:47','2021-09-16 14:27:16','2021-09-16 14:20:32','2021-09-16 14:20:32'),(87,35,1,NULL,1,1,'Logo','logo.png','aaaa',NULL,'selling',NULL,NULL,'QmWoQoNNFpgqpDCbrqcqYnL9WCXw3mZzQos9hVNvG3LtE7','ETH',0.00350000,NULL,'2021-09-16 15:23:10',NULL,'2021-09-16 14:33:33','2021-09-16 14:33:33'),(88,NULL,1,NULL,1,1,'Pencil','3d__icons--6.png','sssss',NULL,'holding',NULL,NULL,'QmX96QuRM2ig5QF2mqtcKZEXwMraqV3XucorKbj82yeyzH','ETH',0.00100000,NULL,NULL,NULL,'2021-09-16 14:40:31','2021-09-16 14:40:31');

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` VALUES (1,'Hello Ichiro','2021-09-01 23:21:27','2021-09-10 12:13:59'),(2,'Good Afternoon','2021-09-10 01:22:34','2021-09-09 16:55:32'),(3,'Hi Jack','2021-09-10 11:22:26','2021-09-10 11:22:26'),(4,'Hi Hanako','2021-09-10 11:24:03','2021-09-10 11:27:29');

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

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

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2021_08_21_135911_create_app_tables',1);

--
-- Table structure for table `password_resets`
--

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

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `primary_categories`
--

CREATE TABLE `primary_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_no` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `primary_categories`
--

INSERT INTO `primary_categories` VALUES (1,'アート',1,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(2,'音楽',2,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(3,'仮想ワールド',3,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(4,'トレーディング・カード',4,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(5,'コレクション',5,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(6,'スポーツ',6,'2021-08-31 16:47:37','2021-08-31 16:47:37'),(7,'ユーティリティー',7,'2021-08-31 16:47:37','2021-08-31 16:47:37');

--
-- Table structure for table `setups`
--

CREATE TABLE `setups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `setups`
--


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

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar_file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales` int(10) unsigned NOT NULL DEFAULT '0',
  `wallet_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,'Yamada','yamada@ntl.world','2021-08-31 16:47:37','$2y$10$ucl.WE7qS2sEqQN0EBDlGuOkmyMgSW/04BWT5l0xtwqoDJ8yycnzW',NULL,0,'0x65bc300d5e82cbf700b1393ed74fe4b3863a5757','9H7f8oI9hElHU7tCok4aq3IlTmXzUbfcrVTlc2Co5To8dtfphcf2ZhzxYRf4','2021-08-31 16:47:37','2021-08-31 16:47:37'),(2,'sato','sato@ntl.world','2021-08-31 16:47:37','$2y$10$vR5Va3cdeTOBiICjbK3l7eD3Fo85X3Gryi4he1FMxDe1ZPlEMEveq',NULL,0,'0x65bc300d5e82cbf700b1393ed74fe4b3863a5757','mkQpUJfhcRvIV10LqdXw1IGCCWVPZUO3zCP7go3zWufa5gLoiSqGu31WE38l','2021-08-31 16:47:37','2021-08-31 16:47:37'),(3,'新野','kniino@ntl.world',NULL,'$2y$10$8X.M7qvByhvwXdkFtkPEseP2Rlk5Pdp6.3vKo9/huWpugbSbh9UfK',NULL,0,NULL,'B83XWMdZ106Ht99osSO5cbGQesbJCxBc0ZS2wQFSDri4nn0bmtBhpDKk4vfk','2021-09-01 19:13:23','2021-09-01 19:13:23'),(4,'suzuki','suzuki@ntl.world',NULL,'$2y$10$701i0Hz.znYKQ81IlSTrIOOYKjrhSi49MNgxMIIYvDLKxLTZAZBqi',NULL,0,'0x65bc300d5e82cbf700b1393ed74fe4b3863a5757',NULL,'2021-09-13 19:19:10','2021-09-13 19:19:10'),(5,'kimura','kimura@ntl.world',NULL,'$2y$10$oPQk1tW6ZJDDhl9Q5w6HNeOnxOrb1Q1Y8lf1Hwn2iB7myK72OsAPy',NULL,0,NULL,NULL,'2021-09-13 21:39:24','2021-09-13 21:39:24'),(6,'kishi','kishi@ntl.world',NULL,'$2y$10$AnSqd7nM5MwjtaKJWcBLi.Q/xbfSsU/LuMahzoiL4Tj2RUOzBGVGa',NULL,0,NULL,NULL,'2021-09-14 00:24:17','2021-09-14 00:24:17'),(7,'noda','noda@ntl.world',NULL,'$2y$10$HurmbqKMR/Ty5TbaLtgPZeUT5Htf.LTStKTWdW2ZMt9uY/vsy522O',NULL,0,NULL,NULL,'2021-09-14 16:21:52','2021-09-14 16:21:52'),(8,'kitano','kitano@ntl.world',NULL,'$2y$10$WdU0aMgrV59rAIZz4CI9ruKlyrz82a5ycZPKUcAd20dKjIX91bbp6',NULL,0,NULL,NULL,'2021-09-14 17:08:47','2021-09-14 17:08:47');


