/*
 Navicat Premium Data Transfer

 Source Server         : msn
 Source Server Type    : MySQL
 Source Server Version : 80030
 Source Host           : localhost:3306
 Source Schema         : egoshop

 Target Server Type    : MySQL
 Target Server Version : 80030
 File Encoding         : 65001

 Date: 15/02/2023 11:03:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` int NULL DEFAULT NULL,
  `cid` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, 101, '家用电器');
INSERT INTO `category` VALUES (1, 102, '手机/运营商/数码');
INSERT INTO `category` VALUES (1, 103, '电脑/办公');
INSERT INTO `category` VALUES (1, 104, '家具/家居');
INSERT INTO `category` VALUES (101, 1011, '电视');
INSERT INTO `category` VALUES (101, 1012, '空调');
INSERT INTO `category` VALUES (101, 1013, '洗衣机');
INSERT INTO `category` VALUES (101, 1014, '冰箱');
INSERT INTO `category` VALUES (102, 1021, '手机通讯');
INSERT INTO `category` VALUES (102, 1022, '运营商');
INSERT INTO `category` VALUES (102, 1023, '摄影');
INSERT INTO `category` VALUES (102, 1024, '摄像');
INSERT INTO `category` VALUES (103, 1031, '电脑整机');
INSERT INTO `category` VALUES (103, 1032, '电脑配件');
INSERT INTO `category` VALUES (103, 1033, '外设产品');
INSERT INTO `category` VALUES (103, 1034, '游戏设备');
INSERT INTO `category` VALUES (104, 1041, '厨具');
INSERT INTO `category` VALUES (104, 1042, '家纺');
INSERT INTO `category` VALUES (104, 1043, '灯具');
INSERT INTO `category` VALUES (104, 1044, '家具');
INSERT INTO `category` VALUES (1011, 10111, '超薄电视');
INSERT INTO `category` VALUES (1011, 10112, '全面屏电视');

-- ----------------------------
-- Table structure for content
-- ----------------------------
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content`  (
  `id` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `pid` int NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content
-- ----------------------------
INSERT INTO `content` VALUES (1, '广告分类', 1001);
INSERT INTO `content` VALUES (1001, 'banner广告', 10001);
INSERT INTO `content` VALUES (1001, '直播代购', 10002);
INSERT INTO `content` VALUES (1001, '京东618', 90410);
INSERT INTO `content` VALUES (10003, '小广告子元素', 44160);
INSERT INTO `content` VALUES (19412, '刚刚赚钱', 89602);
INSERT INTO `content` VALUES (1001, '电子产品广告', 10003);
INSERT INTO `content` VALUES (90410, '电脑', 56320);
INSERT INTO `content` VALUES (1001, '小米', 721270);

-- ----------------------------
-- Table structure for contentinfo
-- ----------------------------
DROP TABLE IF EXISTS `contentinfo`;
CREATE TABLE `contentinfo`  (
  `id` int NULL DEFAULT NULL,
  `pid` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contentinfo
-- ----------------------------
INSERT INTO `contentinfo` VALUES (1, 10001, 'OPPO Watch', '无', '无');

-- ----------------------------
-- Table structure for params
-- ----------------------------
DROP TABLE IF EXISTS `params`;
CREATE TABLE `params`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemCatId` int NULL DEFAULT NULL,
  `paramData` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10009 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of params
-- ----------------------------
INSERT INTO `params` VALUES (10005, 101, '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"Mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"childValue\":\"液态\",\"value\":\"\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `sellPoint` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `price` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `cid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `barcode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `created` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `updated` varchar(225) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `descs` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10018 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES (1001, '红楼梦', 'https://img1.doubanio.com/view/subject/l/public/s1070959.jpg', '宝黛爱情悲剧', '59.70', NULL, '300', NULL, NULL, '1996-12', NULL, '结构宏大、情节委婉、细节精致，人物形象栩栩如生，声口毕现，堪称中国古代小说中的经 典。');
INSERT INTO `project` VALUES (1002, '活着', 'https://img9.doubanio.com/view/subject/l/public/s27279654.jpg', '生的苦难与伟', '20.00', NULL, '1000', NULL, NULL, '2012-8-1', NULL, '谁过中国人没有信仰？中国人的信仰就是两个字，活着。');
INSERT INTO `project` VALUES (1003, '	\r\n1984', 'https://img1.doubanio.com/view/subject/l/public/s4371408.jpg', '栗树荫下，我出卖你，你出卖我', '28.00', NULL, '143', NULL, NULL, ' 2010-4-1', NULL, '战争就是和平 自由就是奴役 无知就是力量');
INSERT INTO `project` VALUES (1004, '	\r\n百年孤独', 'https://img3.doubanio.com/view/subject/l/public/s27237850.jpg', '魔幻现实主义文学代表作', '39.50', NULL, '532', NULL, NULL, '2011-6', NULL, '回忆没有归路，春天总是一去不返。车窗外瞬间闪过世间万象，如同将一首飞逝的长诗撕成碎片向着遗忘之乡一路抛洒。');
INSERT INTO `project` VALUES (1005, '飘', 'https://img1.doubanio.com/view/subject/l/public/s1078958.jpg', '革命时期的爱情，随风而逝', '40.00', NULL, '45', NULL, NULL, '2000-9', NULL, '它让爱你的人心碎崩溃，它让你失去爱和爱的能力，它让你最终，除了形单影只，什么都不剩下。\r\n是的，请记住，软弱是一种罪。');
INSERT INTO `project` VALUES (1006, '	\r\n哈利·波特', 'https://img9.doubanio.com/view/subject/l/public/s29101586.jpg', '从9¾站台开始的旅程', '498.00', NULL, '654', NULL, NULL, '2008-12-1', NULL, '沉湎于虚幻的梦想，而忘记现实的生活，这是毫无益处的，千万记住。');
INSERT INTO `project` VALUES (1007, '房思琪的初恋乐园', 'https://img2.doubanio.com/view/subject/l/public/s29651121.jpg', '向死而生的文学绝唱', '45.00', NULL, '23', NULL, NULL, '2018-2', NULL, '实际上更直指文学及语言如何成为诱奸与哄骗之物；在加害者对受侵害者不可逆转之剥夺和取乐中，成为残忍的同谋，背叛了沟通与文明，也使人迎向了失语和疯癫。');
INSERT INTO `project` VALUES (1008, '三国演义（全二册）  ', 'https://img2.doubanio.com/view/subject/l/public/s1076932.jpg', '是非成败转头空', '39.50', NULL, '436', NULL, NULL, '1998-05', NULL, '其中人物善於用計使詐，處心積慮、勾心鬥角，作為應該“知天命”的老人應該安度晚年，不能整天想着算計別人，對自己身心無益。');
INSERT INTO `project` VALUES (1009, '动物农场', 'https://img3.doubanio.com/view/subject/l/public/s2347590.jpg', '太阳底下并无新事', '657', NULL, '657', NULL, NULL, '2007-3', NULL, '艺术家用谎言说出真相 政客用谎言掩盖事实');
INSERT INTO `project` VALUES (10010, '福尔摩斯探案全集', 'https://img3.doubanio.com/view/subject/l/public/s1229240.jpg', '名侦探的代名词', '68.00', NULL, '234', NULL, NULL, '1981-8', NULL, '我最爱的侦探小说！！！！！');
INSERT INTO `project` VALUES (10013, '梦里花落知多少', 'https://img9.doubanio.com/view/subject/l/public/s29401475.jpg', '三毛的字真是深深的魔法，愁云下笔亦能似鲜花。可总有彻骨悲伤在字里行间，极尽萧瑟。', '35.00', NULL, '243', '', NULL, '2017-3', NULL, '三毛的字真是深深的魔法，愁云下笔亦能似鲜花。可总有彻骨悲伤在字里行间，极尽萧瑟。');
INSERT INTO `project` VALUES (10015, '三体全集 : 地球往事三部曲', 'https://img9.doubanio.com/view/subject/l/public/s28357056.jpg', '未来科幻', '168.00', NULL, '999', NULL, NULL, '2012-1-1', NULL, '酒好喝吗？烟好抽吗？即使是可口可乐，第一次尝也不好喝，让人上瘾的东西都是这样。');
INSERT INTO `project` VALUES (10016, '流浪地球', 'https://img9.doubanio.com/view/subject/l/public/s28780375.jpg', '拍成电影', '222', NULL, '222', NULL, NULL, '2016-6', NULL, '用科幻的小刀，雕琢人性之光。');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'iwen', '123', 'iwen@iwenwiki.com');
INSERT INTO `user` VALUES (2, 'ime', '123', 'ime@iwenwiki.com');
INSERT INTO `user` VALUES (3, 'iwens', '123', 'liuxingyu@stx.cn');
INSERT INTO `user` VALUES (9, 'admin', '123', NULL);

SET FOREIGN_KEY_CHECKS = 1;