231 lines
10 KiB
MySQL
231 lines
10 KiB
MySQL
|
-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
|
|||
|
|
--
|
|||
|
|
-- Host: 192.168.1.102 Database: laravel
|
|||
|
|
-- ------------------------------------------------------
|
|||
|
|
-- Server version 8.4.0
|
|||
|
|
|
|||
|
|
/*!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 */;
|
|||
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `failed_jobs`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `failed_jobs`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `failed_jobs`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`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`),
|
|||
|
|
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `goods`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `goods`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `goods`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`itemid` int NOT NULL COMMENT '商品id',
|
|||
|
|
`typeid` int NOT NULL COMMENT '类型',
|
|||
|
|
`product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品名',
|
|||
|
|
`product_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品code',
|
|||
|
|
`product_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品组',
|
|||
|
|
`market_price` decimal(8, 2) NOT NULL COMMENT '市场价',
|
|||
|
|
`settlement` decimal(8, 2) NOT NULL COMMENT '结算价',
|
|||
|
|
`category_id` int NOT NULL COMMENT '分类id',
|
|||
|
|
`category_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名',
|
|||
|
|
`state` tinyint NOT NULL DEFAULT '1' COMMENT '状态 1上架 0 下架',
|
|||
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
UNIQUE KEY `goods_itemid_unique` (`itemid`),
|
|||
|
|
KEY `goods_product_code_index` (`product_code`),
|
|||
|
|
KEY `goods_category_id_index` (`category_id`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `goods_items`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `goods_items`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `goods_items`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`item_id` int NOT NULL,
|
|||
|
|
`brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '品牌',
|
|||
|
|
`color_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '颜色',
|
|||
|
|
`sell_point` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卖点',
|
|||
|
|
`specifications` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规格',
|
|||
|
|
`shop_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '链接',
|
|||
|
|
`product_images` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品主图',
|
|||
|
|
`images` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主图列表',
|
|||
|
|
`product_infos` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图文信息',
|
|||
|
|
`app_introduce` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'app图文信息',
|
|||
|
|
`applet_introduce` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '详情图片地址',
|
|||
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
UNIQUE KEY `goods_items_item_id_unique` (`item_id`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `jobs`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `jobs`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `jobs`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`attempts` tinyint unsigned NOT NULL,
|
|||
|
|
`reserved_at` int unsigned DEFAULT NULL,
|
|||
|
|
`available_at` int unsigned NOT NULL,
|
|||
|
|
`created_at` int unsigned NOT NULL,
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
KEY `jobs_queue_index` (`queue`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `migrations`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `migrations`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `migrations`
|
|||
|
|
(
|
|||
|
|
`id` int unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`batch` int NOT NULL,
|
|||
|
|
PRIMARY KEY (`id`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `notices`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `notices`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `notices`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`notice_id` int NOT NULL COMMENT '通知id',
|
|||
|
|
`notice_type` int NOT NULL COMMENT '通知type',
|
|||
|
|
`raw_content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始消息内容',
|
|||
|
|
`state` tinyint NOT NULL DEFAULT '1' COMMENT '消息状态，1待消费，2消费进行中,3处理完成',
|
|||
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
UNIQUE KEY `notices_notice_id_unique` (`notice_id`)
|
|||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `password_reset_tokens`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `password_reset_tokens`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `password_reset_tokens`
|
|||
|
|
(
|
|||
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`email`)
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `personal_access_tokens`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `personal_access_tokens`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `personal_access_tokens`
|
|||
|
|
(
|
|||
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|||
|
|
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`tokenable_id` bigint unsigned NOT NULL,
|
|||
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|||
|
|
`abilities` text COLLATE utf8mb4_unicode_ci,
|
|||
|
|
`last_used_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`expires_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
|
|||
|
|
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Table structure for table `users`
|
|||
|
|
--
|
|||
|
|
|
|||
|
|
DROP TABLE IF EXISTS `users`;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
CREATE TABLE `users`
|
|||
|
|
(
|
|||
|
|
`id` bigint 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,
|
|||
|
|
`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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|||
|
|
|
|||
|
|
--
|
|||
|
|
-- Dumping routines for database 'laravel'
|
|||
|
|
--
|
|||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|||
|
|
|
|||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|||
|
|
/*!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 */;
|
|||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|||
|
|
|
|||
|
|
-- Dump completed on 2024-05-27 16:16:45
|