express+mysql+vue,从零搭建一个商城管理系统11-使用Sequelize

/* 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-13 16:51:34 */ 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(255) DEFAULT NULL, `goodsName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `inventory` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `goodsName` (`goodsName`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '8.8', '100', '200克/盒', '2024-03-13 08:08:51', '2024-03-13 08:08:51'); INSERT INTO `goods` VALUES ('5', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '6.4', '200', '160克/罐', '2024-03-13 08:37:07', '2024-03-13 08:37:07'); -- ---------------------------- -- Table structure for shop -- ---------------------------- DROP TABLE IF EXISTS `shop`; CREATE TABLE `shop` ( `id` int NOT NULL AUTO_INCREMENT, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `shopName` (`shopName`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of shop -- ---------------------------- INSERT INTO `shop` VALUES ('1', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94bca74490de0f84e1f478ed602123d3', '2024-03-13 07:49:01', '2024-03-13 07:49:01'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int NOT NULL AUTO_INCREMENT, `userId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `userName` varchar(255) NOT NULL, `password` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `userName` (`userName`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('17', '94bca74490de0f84e1f478ed602123d3', 'test0001', '$2a$09$5dEXj./B8oLvoC31ty9EHeiWKBeSevccS.JLcMOFbpjRxZiPOxkqm', '2024-03-13 07:23:41', '2024-03-13 07:23:41'); INSERT INTO `user` VALUES ('18', '1c270113be21412c87b87aff22fe19ec', 'test0002', '$2a$09$v/NV07v3SLW6jFnNRD7JmORlHHSrwIKrJF9he8CZEIlkFybyTPVau', '2024-03-13 07:23:44', '2024-03-13 07:23:44'); INSERT INTO `user` VALUES ('19', '69a41e3cc40e980da8d7b7d36ef273c2', 'test0003', '$2a$09$ksvlGnHHdF25RkB.qW1OpOb6ctj3uq8WiIqxYWokLYnTjC20pVZ/K', '2024-03-13 07:23:49', '2024-03-13 07:23:49');