本次使用的mysql配置文件

-- -------------------------------------------------------- -- 主机: 192.168.150.101 -- 服务器版本: 8.0.27 - MySQL Community Server - GPL -- 服务器操作系统: Linux -- HeidiSQL 版本: 12.2.0.6576 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- 导出 hmall 的数据库结构 CREATE DATABASE IF NOT EXISTS `hmall` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `hmall`; -- 导出 表 hmall.address 结构 CREATE TABLE IF NOT EXISTS `address` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint DEFAULT NULL COMMENT '用户ID', `province` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '省', `city` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '市', `town` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '县/区', `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机', `street` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '详细地址', `contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人', `is_default` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否是默认 1默认 0否', `notes` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, KEY `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT; -- 正在导出表 hmall.address 的数据：~4 rows (大约) DELETE FROM `address`; INSERT INTO `address` (`id`, `user_id`, `province`, `city`, `town`, `mobile`, `street`, `contact`, `is_default`, `notes`) VALUES (59, 1, '北京', '北京', '朝阳区', '13900112222', '金燕龙办公楼', '李嘉诚', '0', NULL), (60, 1, '北京', '北京', '朝阳区', '13700221122', '修正大厦', '李佳红', '0', NULL), (61, 1, '上海', '上海', '浦东新区', '13301212233', '航头镇航头路', '李佳星', '1', NULL), (63, 1, '广东', '佛山', '永春', '13301212233', '永春武馆', '李小龙', '0', NULL); -- 导出 表 hmall.cart 结构 CREATE TABLE IF NOT EXISTS `cart` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '购物车条目id ', `user_id` bigint NOT NULL COMMENT '用户id', `item_id` bigint NOT NULL COMMENT 'sku商品id', `num` int NOT NULL DEFAULT '1' COMMENT '购买数量', `name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品标题', `spec` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品动态属性键值集', `price` int NOT NULL COMMENT '价格,单位：分', `image` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '商品图片', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, KEY `key_user_item_id` (`user_id`,`item_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='订单详情表'; -- 正在导出表 hmall.cart 的数据：~0 rows (大约) DELETE FROM `cart`; -- 导出 表 hmall.item 结构 CREATE TABLE IF NOT EXISTS `item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '商品id', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'SKU名称', `price` int NOT NULL DEFAULT '0' COMMENT '价格（分）', `stock` int NOT NULL COMMENT '库存数量', `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品图片', `category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类目名称', `brand` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '品牌名称', `spec` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '规格', `sold` int DEFAULT '0' COMMENT '销量', `comment_count` int DEFAULT '0' COMMENT '评论数', `isAD` tinyint(1) DEFAULT '0' COMMENT '是否是推广广告，true/false', `status` int DEFAULT '2' COMMENT '商品状态 1-正常，2-下架，3-删除', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `creater` bigint DEFAULT NULL COMMENT '创建人', `updater` bigint DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `updated` (`update_time`) USING BTREE, KEY `category` (`category`) ) ENGINE=InnoDB AUTO_INCREMENT=100002672305 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='商品表'; -- 正在导出表 hmall.item 的数据：~87,780 rows (大约) DELETE FROM `item`; INSERT INTO `item` (`id`, `name`, `price`, `stock`, `image`, `category`, `brand`, `spec`, `sold`, `comment_count`, `isAD`, `status`, `create_time`, `update_time`, `creater`, `updater`) VALUES (317578, 'RIMOWA 21寸托运箱拉杆箱 SALSA AIR系列果绿色 820.70.36.4', 28900, 10000, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t6934/364/1195375010/84676/e9f2c55f/597ece38N0ddcbc77.jpg!q70.jpg.webp', '拉杆箱', 'RIMOWA', '{"颜色": "红色", "尺码": "21寸"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2023-05-06 11:06:17', NULL, 100), (317580, 'RIMOWA 26寸托运箱拉杆箱 SALSA AIR系列果绿色 820.70.36.4', 28600, 9999, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t6934/364/1195375010/84676/e9f2c55f/597ece38N0ddcbc77.jpg!q70.jpg.webp', '拉杆箱', 'RIMOWA', '{"颜色": "蓝色", "尺码": "26寸"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2023-10-07 10:04:39', NULL, NULL), (546872, '博兿（BOYI）拉杆包男23英寸大容量旅行包户外手提休闲拉杆袋 BY09186黑灰色', 27500, 10000, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t3301/221/3887995271/90563/bf2cadb/57f9fbf4N8e47c225.jpg!q70.jpg.webp', '拉杆箱', '博兿', '{"颜色": "黑色"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2019-05-01 00:00:00', NULL, NULL), (561178, 'RIMOWA 30寸托运箱拉杆箱 SALSA AIR系列果绿色 820.70.36.4', 13000, 10000, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t6934/364/1195375010/84676/e9f2c55f/597ece38N0ddcbc77.jpg!q70.jpg.webp', '拉杆箱', 'RIMOWA', '{"颜色": "红色", "尺码": "30寸"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2023-10-07 10:04:54', NULL, NULL), (577967, '莎米特SUMMIT 旅行拉杆箱28英寸PC材质大容量旅行行李箱PC154 黑色', 71300, 10000, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t30454/163/719393962/79149/13bcc06a/5bfca9b6N493202d2.jpg!q70.jpg.webp', '拉杆箱', '莎米特', '{"颜色": "黑色"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2019-05-01 00:00:00', NULL, NULL), (584382, '美旅AmericanTourister拉杆箱 商务男女超轻PP行李箱时尚大容量耐磨飞机轮旅行箱 25英寸海关锁DL7灰色', 36600, 10000, 'https://m.360buyimg.com/mobilecms/s720x720_jfs/t1/22734/21/2036/130399/5c18af2aEab296c01/7b148f18c6081654.jpg!q70.jpg.webp', '拉杆箱', '美旅箱包', '{"颜色": "绿色", "尺寸": "25英寸"}', 0, 0, 0, 1, '2019-05-01 00:00:00', '2019-05-01 00:00:00', NULL, NULL), (584387, '美旅AmericanTourister�