商品规格设计两种方案数据库文件

/* Navicat Premium Data Transfer Source Server : 本地 Source Server Type : MySQL Source Server Version : 80029 Source Host : localhost:3306 Source Schema : db_wego Target Server Type : MySQL Target Server Version : 80029 File Encoding : 65001 Date: 05/09/2023 22:04:01 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_category -- ---------------------------- DROP TABLE IF EXISTS `tb_category`; CREATE TABLE `tb_category` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '类别编号', `name` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别名称', `icon` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别图片', `priority` int UNSIGNED NULL DEFAULT 0 COMMENT '显示优化级', `pid` bigint UNSIGNED NULL DEFAULT NULL COMMENT '父类别编号', `is_parent` bit(1) NULL DEFAULT NULL COMMENT '是否为父节点', `info` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息', `state` tinyint UNSIGNED NULL DEFAULT 1 COMMENT '状态：1上架，0下架', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2048 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品类别' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tb_category -- ---------------------------- INSERT INTO `tb_category` VALUES (1, '图书、音像、电子书刊', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (2, '家用电器', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (3, '电脑、办公', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (4, '个护化妆', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (5, '钟表', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (6, '母婴', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (7, '食品饮料、保健食品', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (8, '汽车用品', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (9, '玩具乐器', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (10, '手机', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (11, '数码', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (12, '家居家装', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (13, '厨具', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (14, '服饰内衣', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (15, '鞋靴', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (16, '礼品箱包', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (17, '珠宝', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (18, '运动健康', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (19, '彩票、旅行、充值、票务', NULL, 0, NULL, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (20, '电子书刊', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (21, '音像', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (22, '英文原版', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (23, '文艺', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (24, '少儿', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (25, '人文社科', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (26, '经管励志', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (27, '生活', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (28, '科技', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (29, '教育', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (30, '港台图书', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (31, '其它', NULL, 0, 1, b'1', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (32, '电子书', NULL, 0, 2, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (33, '网络原创', NULL, 0, 2, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (34, '数字杂志', NULL, 0, 2, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (35, '多媒体图书', NULL, 0, 2, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (36, '音乐', NULL, 0, 7, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (37, '影视', NULL, 0, 7, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (38, '教育音像', NULL, 0, 7, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (39, '少儿', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (40, '商务投资', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (41, '英语学习与考试', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (42, '小说', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (43, '传记', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (44, '励志', NULL, 0, 11, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (45, '小说', NULL, 0, 18, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (46, '文学', NULL, 0, 18, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (47, '青春文学', NULL, 0, 18, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (48, '传记', NULL, 0, 18, b'0', NULL, 1, '2014-10-15 18:31:55', '2014-10-15 18:31:55'); INSERT INTO `tb_category` VALUES (49, '艺术', NULL, 0, 18, b'0', NULL, 1, '2014-10-15 18:31: