/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 80028
Source Host : localhost:3306
Source Database : express_service
Target Server Type : MYSQL
Target Server Version : 80028
File Encoding : 65001
Date: 2024-03-04 16:53:14
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int NOT NULL AUTO_INCREMENT,
`goodsId` varchar(32) NOT NULL COMMENT '商品ID',
`goodsName` varchar(32) DEFAULT NULL COMMENT '商品名称',
`shopId` varchar(32) DEFAULT NULL COMMENT '商户ID',
`createId` varchar(32) DEFAULT NULL COMMENT '创建者ID',
`inventory` int DEFAULT NULL COMMENT '库存',
`specs` varchar(32) DEFAULT NULL COMMENT '规格',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('4', '87694604f46b2562fc48f5f3c7fb80cd', '百世可乐', 'be2383f2c80fbc672f4b506976c4e502', 'd9ef196010ee41be28ba70a0f819da9d', '500', '24罐/箱');
INSERT INTO `goods` VALUES ('5', '9f876742ad7d66fce888defaea204157', '可口可乐', 'be2383f2c80fbc672f4b506976c4e502', 'd9ef196010ee41be28ba70a0f819da9d', '500', '24罐/箱');
-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
`id` int NOT NULL AUTO_INCREMENT,
`shopId` varchar(32) DEFAULT NULL COMMENT '商户ID',
`shopName` varchar(32) DEFAULT NULL COMMENT '商户名称',
`createId` varchar(32) DEFAULT NULL COMMENT '创建者ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Records of shop
-- ----------------------------
INSERT INTO `shop` VALUES ('4', 'be2383f2c80fbc672f4b506976c4e502', 'shop01', 'd9ef196010ee41be28ba70a0f819da9d');
INSERT INTO `shop` VALUES ('6', '28ae0bcc79367176922b5dfd8daf6578', 'shop02', 'e9fd658aa2e171a3c145c4586d750b50');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`userId` varchar(32) DEFAULT NULL COMMENT '用户id',
`userName` varchar(32) DEFAULT NULL COMMENT '用户名',
`password` varchar(70) DEFAULT NULL COMMENT '密码',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('4', 'd9ef196010ee41be28ba70a0f819da9d', 'longlongago1', '$2a$09$Tvymwtws02AphwY/Kzx2s.lqgSjeSIITqWBSWDdgha5wO.J6kAB1q');
INSERT INTO `user` VALUES ('5', 'e9fd658aa2e171a3c145c4586d750b50', 'longlongago2', '$2a$09$GqWHooN2TqdYYQKlVS0mO.FzejwMEFXI8bMC/GiT2hJPgduedSq3e');
INSERT INTO `user` VALUES ('6', '85eaa8a0aaa572d904b34e00281c1b9b', 'longlongago3', '$2a$09$JuiKT/6aRlbqJxCYlgErheVMqHgxOq29WME5VOpTDvRqFIWspQbUa');
express+mysql+vue,从零搭建一个商城管理系统10-添加商品
108 浏览量
2024-03-04
16:54:37
上传
评论
收藏 25KB ZIP 举报
longlongago~~
- 粉丝: 382
- 资源: 24
最新资源
- Screenshot_2024-05-28-11-40-58-177_com.tencent.mm.jpg
- 基于Dart的Flutter小提琴调音器APP设计源码 - violinhelper
- 基于JavaScript和CSS的随寻订购网页设计源码 - web-order
- 基于MATLAB的声纹识别系统设计源码 - VoiceprintRecognition
- 基于Java的微服务插件集合设计源码 - wsy-plugins
- 基于Vue和微信小程序的监理日志系统设计源码 - supervisionLog
- 基于Java和LCN分布式事务框架的设计源码 - tx-lcn
- 基于Java和JavaScript的茶叶评级管理系统设计源码 - tea
- IMG_5680.JPG
- IMG_0437.jpg
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈