基于nodejs+vue+mysql在线化妆品购物商城网站设计+sql数据库(毕设源码).zip

/* Navicat Premium Data Transfer Source Server : mysql8.0 Source Server Type : MySQL Source Server Version : 80016 Source Host : localhost:3306 Source Schema : mall Target Server Type : MySQL Target Server Version : 80016 File Encoding : 65001 Date: 05/11/2022 13:46:44 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for addresses -- ---------------------------- DROP TABLE IF EXISTS `addresses`; CREATE TABLE `addresses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人姓名', `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人电话', `is_default` tinyint(1) NULL DEFAULT 1 COMMENT '是否是默认地址', `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, `user_id` int(11) NULL DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人详细地址', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `addresses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of addresses -- ---------------------------- INSERT INTO `addresses` VALUES (3, '王五', '13545678900', 0, '2021-03-15 19:03:28', '2021-03-15 19:57:17', 2, '北京市朝阳区'); INSERT INTO `addresses` VALUES (5, '李四', '13445678900', 1, '2021-03-15 19:30:04', '2021-03-15 19:57:17', 2, '北京市海淀区'); INSERT INTO `addresses` VALUES (8, '测试地址', '13633663366', 1, '2021-03-16 11:31:18', '2021-03-16 11:31:18', 4, '北京'); -- ---------------------------- -- Table structure for carts -- ---------------------------- DROP TABLE IF EXISTS `carts`; CREATE TABLE `carts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `count` int(11) NULL DEFAULT 1 COMMENT '商品数量', `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, `user_id` int(11) NULL DEFAULT NULL, `product_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, CONSTRAINT `carts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `carts_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of carts -- ---------------------------- INSERT INTO `carts` VALUES (52, 1, '2022-03-29 05:22:58', '2022-03-29 05:22:58', 5, 14); INSERT INTO `carts` VALUES (53, 1, '2022-11-04 16:54:54', '2022-11-04 16:54:54', 6, 17); -- ---------------------------- -- Table structure for collections -- ---------------------------- DROP TABLE IF EXISTS `collections`; CREATE TABLE `collections` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, `user_id` int(11) NULL DEFAULT NULL, `product_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `collections_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of collections -- ---------------------------- INSERT INTO `collections` VALUES (6, '2021-03-12 16:57:12', '2021-03-12 16:57:12', 2, 2); INSERT INTO `collections` VALUES (7, '2021-03-15 20:36:17', '2021-03-15 20:36:17', 2, 18); INSERT INTO `collections` VALUES (8, '2021-03-16 11:30:29', '2021-03-16 11:30:29', 4, 2); -- ---------------------------- -- Table structure for comments -- ---------------------------- DROP TABLE IF EXISTS `comments`; CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `score` int(11) NULL DEFAULT NULL COMMENT '评分', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容', `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, `order_id` int(11) NULL DEFAULT NULL, `product_id` int(11) NULL DEFAULT NULL, `user_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `order_id`(`order_id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `comments_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of comments -- ---------------------------- INSERT INTO `comments` VALUES (9, 5, '五星好评', '2021-03-15 22:11:36', '2021-03-15 22:11:36', 39, 15, 2); INSERT INTO `comments` VALUES (10, 1, '产品不是很满意', '2021-03-15 22:12:46', '2021-03-15 22:12:46', 39, 15, 2); INSERT INTO `comments` VALUES (11, 2, '还可以', '2021-03-16 11:31:46', '2021-03-16 11:31:46', 40, 18, 4); -- ---------------------------- -- Table structure for companies -- ---------------------------- DROP TABLE IF EXISTS `companies`; CREATE TABLE `companies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主图', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `brief` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品简介', `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of companies -- ---------------------------- INSERT INTO `companies` VALUES (6, '/upload/20210302/a8dbefc0-7afe-11eb-85c7-55b83ce40e52.jpg', '香水公司', '香水公司', '2021-03-02 02:26:29', '2021-03-03 07:54:24'); -- ---------------------------- -- Table structure for news -- ---------------------------- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` smallint(6) NOT NULL, `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0', `publisher` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'Admin', `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `created_at` datetime(0) NOT NULL, `updated_at` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of news -- ---------------------------- INSERT INTO `news` VALUES (1, 1, '内地全方位援港抗疫，区议员：香港也要争气，不能拖国家后退', '观察者网', '/upload/20220329/254a6630-af75-11ec-8513-1527696b1ea6.jpg', '2022-03-29 20:07:46', '2022-03-29 20:2