express+mysql+vue,从零搭建一个商城管理系统10-添加商品

/* 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 17:23:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cart -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int NOT NULL, `userId` varchar(32) DEFAULT NULL COMMENT '用户ID', `userName` varchar(32) DEFAULT NULL COMMENT '用户名', `shopId` varchar(32) DEFAULT NULL COMMENT '商品所属商户ID', `shopName` varchar(32) DEFAULT NULL COMMENT '商户名称', `goodsId` varchar(32) DEFAULT NULL COMMENT '商品ID', `goodsName` varchar(32) DEFAULT NULL COMMENT '商品名称', `count` int DEFAULT NULL COMMENT '数量', `specs` varchar(32) DEFAULT NULL COMMENT '商品规格', `createTime` datetime DEFAULT NULL COMMENT '添加时间', `removed` int DEFAULT NULL COMMENT '0、未移除，1、移除', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of cart -- ---------------------------- -- ---------------------------- -- 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', `price` float(10,2) DEFAULT NULL COMMENT '单价', `inventory` int DEFAULT NULL COMMENT '库存', `specs` varchar(32) DEFAULT NULL COMMENT '规格', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('10', '87694604f46b2562fc48f5f3c7fb80cd', '百世可乐', 'be2383f2c80fbc672f4b506976c4e502', 'd9ef196010ee41be28ba70a0f819da9d', '60.00', '500', '24罐/箱'); INSERT INTO `goods` VALUES ('11', '9f876742ad7d66fce888defaea204157', '可口可乐', 'be2383f2c80fbc672f4b506976c4e502', 'd9ef196010ee41be28ba70a0f819da9d', '65.00', '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=10 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'); INSERT INTO `user` VALUES ('7', '36c5933c3d93787d6a3fefb4cc286a8e', 'test0001', '$2a$09$z4eYfnqrqlhjQVi7DR2DPucCnemHl9wYS4LeDAstv68u6PTW48arS'); INSERT INTO `user` VALUES ('8', '8d8fd55ae1a99be74711e3f27e7c387b', 'test0002', '$2a$09$V8JYNM5vwaHtuXQekGJk6eaVKH6mxr5raB0KLsREnqi8MzQ41spg2'); INSERT INTO `user` VALUES ('9', '86fa40ce91ea1447ee7c09db43eba225', 'test0003', '$2a$09$dXuabUK2kNTocxVvu9tV1eVNyG1il4Z/3CtI9SE7a4yA5sVvpCsiq');