/*
 Navicat Premium Data Transfer

 Source Server         : localMySQL
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : team-ssm

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

 Date: 05/12/2021 23:38:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
  `price` decimal(6, 2) NOT NULL DEFAULT 0.00 COMMENT '商品价格',
  `created_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '商品创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '香蕉', 5.50, '2021-12-05 19:49:41');
INSERT INTO `goods` VALUES (2, '苹果', 5.10, '2021-12-05 19:49:41');
INSERT INTO `goods` VALUES (3, '梨子', 5.30, '2021-12-05 19:49:41');
INSERT INTO `goods` VALUES (4, '葡萄', 5.40, '2021-12-05 19:49:41');
INSERT INTO `goods` VALUES (5, '百香果', 10.50, '2021-12-05 19:49:41');
INSERT INTO `goods` VALUES (6, '猕猴桃', 5.55, '2021-12-05 21:20:14');
INSERT INTO `goods` VALUES (7, '猕猴桃1', 5.55, '2021-12-05 21:25:11');
INSERT INTO `goods` VALUES (8, '青苹果', 12.00, '2021-12-05 21:30:08');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户唯一自增长id',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户密码',
  `name` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名',
  `disabled` bit(1) NULL DEFAULT b'0' COMMENT '账号是否被禁用，0不禁用，1禁用， 默认为0',
  `deleted` bit(1) NULL DEFAULT b'0' COMMENT '账号是否被禁用，0不禁用，1禁用， 默认为0',
  `created_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '账号创建时间',
  `modified_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '账号更新时间，自动更改',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ix_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'zhangsan1', 'f379eaf3c831b04de153469d1bec345e', '张三1', b'0', b'0', '2021-12-05 19:40:02', '2021-12-05 19:40:02');
INSERT INTO `users` VALUES (2, 'zhangsan2', 'f379eaf3c831b04de153469d1bec345e', '张三2', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (3, 'zhangsan3', 'f379eaf3c831b04de153469d1bec345e', '张三3', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (4, 'zhangsan4', 'f379eaf3c831b04de153469d1bec345e', '张三4', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (5, 'zhangsan5', 'f379eaf3c831b04de153469d1bec345e', '张三5', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (6, 'zhangsan6', 'f379eaf3c831b04de153469d1bec345e', '张三6', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (7, 'zhangsan7', 'f379eaf3c831b04de153469d1bec345e', '张三7', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (8, 'zhangsan8', 'f379eaf3c831b04de153469d1bec345e', '张三8', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (9, 'zhangsan9', 'f379eaf3c831b04de153469d1bec345e', '张三9', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (10, 'zhangsan10', 'f379eaf3c831b04de153469d1bec345e', '张三10', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (11, 'zhangsan11', 'f379eaf3c831b04de153469d1bec345e', '张三11', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (12, 'zhangsan12', 'f379eaf3c831b04de153469d1bec345e', '张三12', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (13, 'zhangsan13', 'f379eaf3c831b04de153469d1bec345e', '张三13', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (14, 'zhangsan14', 'f379eaf3c831b04de153469d1bec345e', '张三14', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (15, 'zhangsan15', 'f379eaf3c831b04de153469d1bec345e', '张三15', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (16, 'zhangsan16', 'f379eaf3c831b04de153469d1bec345e', '张三16', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (17, 'zhangsan17', 'f379eaf3c831b04de153469d1bec345e', '张三17', b'0', b'0', '2021-12-05 19:40:57', '2021-12-05 19:40:57');
INSERT INTO `users` VALUES (18, 'wangwu', 'f379eaf3c831b04de153469d1bec345e', '王五', b'0', b'0', '2021-12-05 23:16:22', '2021-12-05 23:16:22');
INSERT INTO `users` VALUES (19, 'wangwu1', 'f379eaf3c831b04de153469d1bec345e', '王五1', b'0', b'0', '2021-12-05 23:16:40', '2021-12-05 23:16:40');
INSERT INTO `users` VALUES (20, 'wangwu2', 'f379eaf3c831b04de153469d1bec345e', '王五2', b'0', b'0', '2021-12-05 23:18:02', '2021-12-05 23:18:02');
INSERT INTO `users` VALUES (21, 'xiaoming', 'f379eaf3c831b04de153469d1bec345e', '小明', b'0', b'0', '2021-12-05 23:18:18', '2021-12-05 23:18:18');

SET FOREIGN_KEY_CHECKS = 1;