master

分支 (1)

管理

管理

master

JDcomBookStore201910
/
bookstore.sql

/*
 Navicat Premium Data Transfer

 Source Server         : sa
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : zcsd

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

 Date: 13/11/2019 10:07:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_sys_category
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_category`;
CREATE TABLE `t_sys_category`  (
  `cate_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
  `cate_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类编码',
  `parent_cate_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父级分类编码',
  `level` int(11) NOT NULL COMMENT '层级',
  `remark` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `created_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人信息（用户编码）',
  `update_time` timestamp(0) NOT NULL COMMENT '修改时间',
  `update_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息（用户编码）',
  `is_delete` int(11) NOT NULL COMMENT '删除位标记（0：未删除 1：删除）',
  `version` int(11) NOT NULL COMMENT '锁控制（乐观锁）',
  `sort` int(11) NOT NULL COMMENT '序号（默认给0）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_category
-- ----------------------------
INSERT INTO `t_sys_category` VALUES ('电器', 'c8e83d05e35511e9a18838d5479c38e4', '0', 1, 'aaa', 1, '2019-09-30 15:41:59', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:41:59', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_category` VALUES ('服饰', '275aee08e35611e9a18838d5479c38e4', '0', 1, 'bbb', 2, '2019-09-30 15:44:37', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:44:37', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_category` VALUES ('手机', '400956d0e35611e9a18838d5479c38e4', 'c8e83d05e35511e9a18838d5479c38e4', 2, 'a1', 3, '2019-09-30 15:45:19', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:45:19', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_category` VALUES ('电脑', '78c324cee35611e9a18838d5479c38e4', 'c8e83d05e35511e9a18838d5479c38e4', 2, 'a2', 4, '2019-09-30 15:46:54', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:46:54', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_category` VALUES ('衣服', '8d8a5acfe35611e9a18838d5479c38e4', '275aee08e35611e9a18838d5479c38e4', 2, 'b1', 5, '2019-09-30 15:47:29', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:47:29', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_category` VALUES ('长裤', '97f570cde35611e9a18838d5479c38e4', '275aee08e35611e9a18838d5479c38e4', 2, NULL, 6, '2019-09-30 16:16:09', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 15:47:46', '26027b25df5d11e9b05438d5479c38e4', 1, 0, 0);
INSERT INTO `t_sys_category` VALUES ('言情', '82bfa5d2efd511e9af1138d5479c38e4', '0', 1, '按时是打发', 7, '2019-10-16 15:08:07', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 13:26:31', '707c2b68ee3111e9ac4f38d5479c38e4', 1, 0, 0);

-- ----------------------------
-- Table structure for t_sys_customer
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_customer`;
CREATE TABLE `t_sys_customer`  (
  `user_accont` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `user_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名称',
  `user_sex` int(11) NOT NULL COMMENT '性别（0：男 1：女）',
  `phone` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号（中国大陆11位手机号）',
  `email` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱地址',
  `id_card` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `user_pwd` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `score` decimal(8, 2) NOT NULL COMMENT '积分',
  `user_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户编码',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `created_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人信息（用户编码）',
  `update_time` timestamp(0) NOT NULL COMMENT '修改时间',
  `update_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息（用户编码）',
  `is_delete` int(11) NOT NULL COMMENT '删除位标记（0：未删除 1：删除）',
  `version` int(11) NOT NULL COMMENT '锁控制（乐观锁）',
  `sort` int(11) NOT NULL COMMENT '序号（默认给0）',
  `admin_flag` int(11) NOT NULL COMMENT '管理员标记（后台注册得用户默认都是管理员，app注册默认都是普通用户，0：管理员 1：普通用户）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_customer
-- ----------------------------
INSERT INTO `t_sys_customer` VALUES ('11', '11', 1, '111', '11', '11', '6512bd43d9caa6e02c990b0a82652dca', 11.00, '798d08f2dea611e981ce38d5479c38e4', 1, '2019-09-26 15:04:56', 'admin', '2019-09-24 16:36:59', 'admin', 1, 0, 0, 1);
INSERT INTO `t_sys_customer` VALUES ('456', '低速', 0, '1234567', '232658', '52232656', '71b3b26aaa319e0cdf6fdb8429c112b0', 12220.00, 'd22d307fdea711e981ce38d5479c38e4', 2, '2019-10-15 16:06:32', 'admin', '2019-10-15 15:52:45', '707c2b68ee3111e9ac4f38d5479c38e4', 1, 0, 0, 1);
INSERT INTO `t_sys_customer` VALUES ('123', 'aaa', 0, '1234', '111', '111', 'e10adc3949ba59abbe56e057f20f883e', 1.00, '7a153ab9df5611e9b05438d5479c38e4', 3, '2019-10-17 14:28:42', 'admin', '2019-09-25 13:36:51', 'admin', 1, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('ljn058', '沧桑058', 0, '15073717970', NULL, '1', 'd2ca6888c385ada2010fb1de10afe7fd', 100000.00, '26027b25df5d11e9b05438d5479c38e4', 4, '2019-10-17 14:28:42', 'admin', '2019-09-25 14:24:37', 'admin', 1, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('aaaa', 'bbbb', 1, '123', '111', '111', '698d51a19d8a121ce581499d7b701668', 1.00, '0bf6a0abdf6411e9b05438d5479c38e4', 5, '2019-10-17 14:29:33', 'admin', '2019-09-25 15:14:00', 'admin', 1, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('1230', 'zzz', 1, '222225', '66664', '885511', 'e10adc3949ba59abbe56e057f20f883e', 2222.00, 'da946560e02311e9b1ca38d5479c38e4', 6, '2019-09-26 14:07:00', '26027b25df5d11e9b05438d5479c38e4', '2019-09-26 14:07:00', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0, 1);
INSERT INTO `t_sys_customer` VALUES ('123456', '沧桑058', 0, '123456', '12345', '123456789', 'e10adc3949ba59abbe56e057f20f883e', 0.00, '707c2b68ee3111e9ac4f38d5479c38e4', 7, '2019-10-14 11:19:31', '26027b25df5d11e9b05438d5479c38e4', '2019-10-14 11:19:31', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('789', '啦啦啦啦', 0, '565659', '44444', '44555', 'e10adc3949ba59abbe56e057f20f883e', 100.00, 'f0e20e71ef1411e98f8e38d5479c38e4', 8, '2019-10-15 14:28:03', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-15 14:28:03', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('1281826717', '刘先生', 0, '17673944369', '1281826717@qq.com', '430524199910023279', 'fceede97feb847a3e666ab86edf9e290', 20.00, 'b5c75cf1ef4211e98f8e38d5479c38e4', 9, '2019-10-15 19:55:40', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-15 19:55:40', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('484848484', '48', 0, '17673644569', '484848484@qq.com', '484848484', '60504c86cfac986562018d459db223e1', 20.00, '3e186c68efab11e9ae9a38d5479c38e4', 10, '2019-10-16 08:23:57', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:23:57', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('dsadasd', 'ds', 0, '17673944365', 'dsadasd@aa.cc', 'dsadasd', '5676e37338d668578a3686ab581abe0f', 20.00, '7b9a0916efab11e9ae9a38d5479c38e4', 11, '2019-10-16 08:25:40', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:25:40', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('dsdsadsa', 'dsa', 1, '17645963214', 'dsadasd@dsadsa.csa', 'dsadsadsadsadwadsads', 'a32aca527067997d6ef393c4b3b07339', 20.00, '38f36b9defac11e9ae9a38d5479c38e4', 12, '2019-10-16 08:30:58', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:30:58', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);
INSERT INTO `t_sys_customer` VALUES ('4848484', '484s', 0, '14578961256', 'dsadasd@dsad.asdsad', 'dsad5s4ad4sa9d1as9', 'bb578e912bd1f089ce39e672eddd1bb5', 20.00, '5657f85befac11e9ae9a38d5479c38e4', 13, '2019-10-16 08:31:47', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:31:47', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0, 0);

-- ----------------------------
-- Table structure for t_sys_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_goods`;
CREATE TABLE `t_sys_goods`  (
  `sku_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SKU商品编码',
  `sku_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SKU商品名称',
  `isbn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '书的ISBN编号',
  `cb_price` decimal(20, 2) NOT NULL COMMENT '定价（成本价格）',
  `sale_price` decimal(20, 2) NOT NULL COMMENT '销售价格',
  `sale_num` int(11) NOT NULL COMMENT '已售数量',
  `sku_status` int(11) NOT NULL COMMENT 'SKU商品状态（0：在售1：已下架2：未发布）',
  `first_cate_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '一级分类编码',
  `second_cate_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二级分类编码',
  `sku_introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'SKU广告词',
  `sale_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '上架时间',
  `store_num` int(11) NOT NULL COMMENT '库存量',
  `viste_num` int(11) NULL DEFAULT NULL COMMENT '浏览量',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_time` datetime(0) NOT NULL COMMENT '创建时间',
  `created_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人信息（用户编码）',
  `update_time` datetime(0) NOT NULL COMMENT '修改时间',
  `update_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息（用户编码）',
  `is_delete` int(11) NOT NULL COMMENT '删除位标记（0：未删除 1：删除）',
  `version` int(11) NOT NULL COMMENT '锁控制（乐观锁）',
  `sort` int(11) NOT NULL COMMENT '序号（默认给0）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_goods
-- ----------------------------
INSERT INTO `t_sys_goods` VALUES ('00853637462d4084b252d961a982ebd1', '竞赛加快', '462356565', 20.00, 30.00, 0, 1, '465644', '46464644', '减肥的空间开发基地', '2019-10-16 16:06:33', 100, NULL, 4, '2019-10-11 16:03:37', '26027b25df5d11e9b05438d5479c38e4', '2019-10-16 16:06:33', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);

-- ----------------------------
-- Table structure for t_sys_goods_images
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_goods_images`;
CREATE TABLE `t_sys_goods_images`  (
  `sku_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'sku编码',
  `sku_image_path` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'sku图片路径',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_time` datetime(0) NOT NULL COMMENT '创建时间',
  `created_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人信息（用户编码）',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息（用户编码）',
  `is_delete` int(11) NOT NULL COMMENT '删除位标记（0：未删除 1：删除）',
  `version` int(11) NOT NULL COMMENT '锁控制（乐观锁）',
  `sort` int(11) NOT NULL COMMENT '序号（默认给0）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_goods_images
-- ----------------------------
INSERT INTO `t_sys_goods_images` VALUES ('00853637462d4084b252d961a982ebd1', 'E:/ideaCode/bootStore/target/classes/images/1570780824111.jpeg', 5, '2019-10-11 16:03:37', '26027b25df5d11e9b05438d5479c38e4', '2019-10-11 16:03:37', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);

-- ----------------------------
-- Table structure for t_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_menu`;
CREATE TABLE `t_sys_menu`  (
  `menu_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `menu_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单链接',
  `parent_menu_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父级菜单代码（已经处于顶层的目录，父级菜单给默认值:0）',
  `type` int(11) NOT NULL COMMENT '菜单类型（目录1：菜单2），菜单是挂在目录之下的',
  `remark` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `menu_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单代码',
  `level` int(11) NOT NULL COMMENT '菜单处于哪一级别',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `created_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人信息（用户编码）',
  `update_time` timestamp(0) NOT NULL COMMENT '修改时间',
  `update_by` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息（用户编码）',
  `is_delete` int(11) NOT NULL COMMENT '删除位标记（0：未删除 1：删除）',
  `version` int(11) NOT NULL COMMENT '锁控制（乐观锁）',
  `sort` int(11) NOT NULL COMMENT '序号（默认给0）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_menu
-- ----------------------------
INSERT INTO `t_sys_menu` VALUES ('首页', '', '0', 2, '', '32e706c3e1f611e9998c544810e75499', 1, 38, '2018-06-25 14:36:39', '1', '2019-09-29 09:57:37', '1', 0, 0, 1);
INSERT INTO `t_sys_menu` VALUES ('订单', '', '0', 2, '', '32e7c59be1f611e9998c544810e75499', 1, 39, '2019-09-30 10:38:06', '1', '2019-09-29 09:57:45', '1', 1, 1, 2);
INSERT INTO `t_sys_menu` VALUES ('系统', '', '32e706c3e1f611e9998c544810e75499', 2, '', '32e7c8dae1f611e9998c544810e75499', 2, 44, '2018-06-25 14:38:02', '1', '2019-09-29 09:57:49', '1', 0, 1, 7);
INSERT INTO `t_sys_menu` VALUES ('新增', 'abc', '0', 1, 'ccc', 'c2c5b30fe31b11e9a18838d5479c38e4', 1, 45, '2019-09-30 10:24:46', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 08:46:38', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_menu` VALUES ('系统管理', 'menu', 'c2c5b30fe31b11e9a18838d5479c38e4', 2, 'aa', '04f854c2e31f11e9a18838d5479c38e4', 2, 50, '2019-09-30 09:09:57', '26027b25df5d11e9b05438d5479c38e4', '2019-09-30 09:09:57', '26027b25df5d11e9b05438d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_menu` VALUES ('沧桑', '565', '0', 1, '好好干会更好', '02f6e922efad11e9ae9a38d5479c38e4', 1, 51, '2019-10-16 08:36:36', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:36:36', '707c2b68ee3111e9ac4f38d5479c38e4', 0, 0, 0);
INSERT INTO `t_sys_menu` VALUES ('你你你', '456565', '0', 0, '加快', '2d98d7adefad11e9ae9a38d5479c38e4', 1, 52, '2019-10-16 10:52:14', '707c2b68ee3111e9ac4f38d5479c38e4', '2019-10-16 08:37:48', '707c2b68ee3111e9ac4f38d5479c38e4', 1, 0, 0);

SET FOREIGN_KEY_CHECKS = 1;