/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50744 Source Host : localhost:3306 Source Schema : virtual_mall Target Server Type : MySQL Target Server Version : 50744 File Encoding : 65001 Date: 19/04/2024 17:27:20 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for authority -- ---------------------------- DROP TABLE IF EXISTS `authority`; CREATE TABLE `authority` ( `id` int(11) NOT NULL AUTO_INCREMENT, `authority_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `authority_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of authority -- ---------------------------- INSERT INTO `authority` VALUES (1, '登录', '/api/ping'); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_id` int(11) NOT NULL COMMENT '分类id', `goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名字', `introduction_id` int(11) NULL DEFAULT NULL COMMENT '商品介绍id', `tag_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品标签', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES (1, 1, '苹果礼品卡特惠包', NULL, NULL); INSERT INTO `goods` VALUES (2, 2, 'PUBG国际服直充', NULL, NULL); -- ---------------------------- -- Table structure for goods_commodity_area -- ---------------------------- DROP TABLE IF EXISTS `goods_commodity_area`; CREATE TABLE `goods_commodity_area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `commodity_area_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品属地名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods_commodity_area -- ---------------------------- INSERT INTO `goods_commodity_area` VALUES (1, '美国'); INSERT INTO `goods_commodity_area` VALUES (2, '日本'); INSERT INTO `goods_commodity_area` VALUES (3, '香港'); INSERT INTO `goods_commodity_area` VALUES (4, '台湾'); -- ---------------------------- -- Table structure for goods_introduction -- ---------------------------- DROP TABLE IF EXISTS `goods_introduction`; CREATE TABLE `goods_introduction` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章id', `goods_article_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品文章名', `goods_article` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品文章', `create_by` longblob NULL COMMENT '创建人', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品介绍' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods_introduction -- ---------------------------- -- ---------------------------- -- Table structure for goods_sku -- ---------------------------- DROP TABLE IF EXISTS `goods_sku`; CREATE TABLE `goods_sku` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品sku名字', `price` decimal(10, 2) NOT NULL COMMENT '现在价格', `historical_prices` decimal(10, 2) NOT NULL COMMENT '历史价格', `inventory_number` int(11) NOT NULL COMMENT '库存', `commodity_area_id` int(11) NOT NULL COMMENT '属地id', `goods_id` int(11) NOT NULL COMMENT '商品id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods_sku -- ---------------------------- INSERT INTO `goods_sku` VALUES (1, '特惠包1【苹果礼品卡3美金+精品账号】', 36.00, 36.00, 50, 1, 1); INSERT INTO `goods_sku` VALUES (2, '特惠包2【苹果礼品卡5美金+精品账号】', 52.00, 58.80, 50, 1, 1); INSERT INTO `goods_sku` VALUES (3, '特惠包3【苹果礼品卡3美金+5美金】', 75.00, 67.00, 50, 1, 1); INSERT INTO `goods_sku` VALUES (4, '特惠包2【苹果礼品卡500日元+精美账号】', 48.00, 55.00, 50, 2, 1); INSERT INTO `goods_sku` VALUES (5, '特惠包1【苹果礼品卡150港元+200港元】', 381.00, 384.00, 50, 3, 1); INSERT INTO `goods_sku` VALUES (6, '特惠包1【苹果礼品卡100NT+300NT】', 135.00, 139.00, 50, 4, 1); INSERT INTO `goods_sku` VALUES (7, 'PUBG国际服(地铁逃生)直充-300+25UC', 37.39, 41.00, 50, 0, 2); -- ---------------------------- -- Table structure for goods_tag -- ---------------------------- DROP TABLE IF EXISTS `goods_tag`; CREATE TABLE `goods_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字', `icon_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标路径', `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods_tag -- ---------------------------- -- ---------------------------- -- Table structure for goods_type -- ---------------------------- DROP TABLE IF EXISTS `goods_type`; CREATE TABLE `goods_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sort` int(11) NULL DEFAULT NULL COMMENT '排序', `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品类别名称', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goods_type -- ---------------------------- INSERT INTO `goods_type` VALUES (1, NULL, '礼品卡', NULL); INSERT INTO `goods_type` VALUES (2, NULL, '海外直冲', NULL); -- ---------------------------- -- Table structure for role -- ---------------------------- DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of role -- ---------------------------- INSERT INTO `role` VALUES (1, '超级管理员'); INSERT INTO `role` VALUES (2, '普通用户'); -- ---------------------------- -- Table structure for role_authority -- ---------------------------- DROP TABLE IF EXISTS `role_authority`; CREATE TABLE `role_authority` ( `authority_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, PRIMARY KEY (`authority_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of role_authority -- ---------------------------- INSERT INTO `role_authority` VALUES (1, 1); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码', `creation_time` int(11) NULL DEFAULT NULL COMMENT '账号创建时间', `login_time` int(11) NULL DEFAULT NULL COMMENT '登录时间', `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号状态', `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id', `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机', `recommend_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推荐码', PRIMARY KEY (`id`) USING BTREE, INDEX `usernames`(`username`) USING BTREE COMMENT '用户名' ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, '516702882@qq.com', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1711168151, NULL, '0', 1, '15537351020', NULL); INSERT INTO `user` VALUES (2, '875182750@qq.com', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1711168151, NULL, '0', 2, '13233826561', NULL); SET FOREIGN_KEY_CHECKS = 1;