-- MySQL dump 10.13  Distrib 5.7.16, for osx10.11 (x86_64)
--
-- Host: 127.0.0.1    Database: mp
-- ------------------------------------------------------
-- Server version	5.7.16

/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE */;
/*!40103 SET TIME_ZONE = '+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
/*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;

--
-- Table structure for table `DATABASECHANGELOG`
--

DROP TABLE IF EXISTS `DATABASECHANGELOG`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `DATABASECHANGELOG` (
  `ID`            varchar(255) NOT NULL,
  `AUTHOR`        varchar(255) NOT NULL,
  `FILENAME`      varchar(255) NOT NULL,
  `DATEEXECUTED`  datetime     NOT NULL,
  `ORDEREXECUTED` int(11)      NOT NULL,
  `EXECTYPE`      varchar(10)  NOT NULL,
  `MD5SUM`        varchar(35)  DEFAULT NULL,
  `DESCRIPTION`   varchar(255) DEFAULT NULL,
  `COMMENTS`      varchar(255) DEFAULT NULL,
  `TAG`           varchar(255) DEFAULT NULL,
  `LIQUIBASE`     varchar(20)  DEFAULT NULL,
  `CONTEXTS`      varchar(255) DEFAULT NULL,
  `LABELS`        varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID` varchar(10)  DEFAULT NULL
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DATABASECHANGELOG`
--

LOCK TABLES `DATABASECHANGELOG` WRITE;
/*!40000 ALTER TABLE `DATABASECHANGELOG`
  DISABLE KEYS */;
INSERT INTO `DATABASECHANGELOG` VALUES
  ('add_column_avatar_for_sys_user', '闻品高', 'classpath:liquibase/master.xml', '2019-10-28 14:10:48', 1, 'EXECUTED',
                                     '7:b8f0d382f2e159321ca63c56ada99066', 'addColumn tableName=sys_user', '', NULL,
                                     '3.5.3', NULL, NULL, '2243048425'),
  ('update_sys_user_gender', '闻品高', 'classpath:liquibase/master.xml', '2019-10-28 14:10:48', 2, 'EXECUTED',
                             '7:6045e2e3855c32e3079dd271ae61df9b', 'sql', '', NULL, '3.5.3', NULL, NULL, '2243048425'),
  ('create_table_fls_activity', '闻品高', 'classpath:liquibase/master.xml', '2020-01-16 09:01:11', 3, 'EXECUTED',
                                '7:f9cfcd46013e737c65e328aefd66a612',
                                'createTable tableName=fls_activity; createTable tableName=fls_activity_awards; createTable tableName=fls_activity_win_result',
                                '', NULL, '3.5.3', NULL, NULL, '9136471691');
/*!40000 ALTER TABLE `DATABASECHANGELOG`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DATABASECHANGELOGLOCK`
--

DROP TABLE IF EXISTS `DATABASECHANGELOGLOCK`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `DATABASECHANGELOGLOCK` (
  `ID`          int(11) NOT NULL,
  `LOCKED`      bit(1)  NOT NULL,
  `LOCKGRANTED` datetime     DEFAULT NULL,
  `LOCKEDBY`    varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DATABASECHANGELOGLOCK`
--

LOCK TABLES `DATABASECHANGELOGLOCK` WRITE;
/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK`
  DISABLE KEYS */;
INSERT INTO `DATABASECHANGELOGLOCK` VALUES (1, '\0', NULL, NULL);
/*!40000 ALTER TABLE `DATABASECHANGELOGLOCK`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fls_activity`
--

DROP TABLE IF EXISTS `fls_activity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fls_activity` (
  `id`            int(11) NOT NULL AUTO_INCREMENT,
  `name`          varchar(1024)    DEFAULT ''
  COMMENT '名称',
  `content`       varchar(2048)    DEFAULT ''
  COMMENT '内容',
  `rule`          varchar(2048)    DEFAULT ''
  COMMENT '规则',
  `precautions`   varchar(2048)    DEFAULT ''
  COMMENT '注意事项',
  `starting_time` datetime         DEFAULT CURRENT_TIMESTAMP
  COMMENT '开始时间',
  `end_time`      datetime         DEFAULT CURRENT_TIMESTAMP
  COMMENT '结束时间',
  `add_time`      datetime         DEFAULT CURRENT_TIMESTAMP
  COMMENT '添加时间',
  `remark`        varchar(1024)    DEFAULT ''
  COMMENT '备注',
  `status`        int(11)          DEFAULT '0'
  COMMENT '状态',
  `user_id`       int(11)          DEFAULT '0'
  COMMENT '创建人',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 4
  DEFAULT CHARSET = utf8mb4
  COMMENT ='活动';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fls_activity`
--

LOCK TABLES `fls_activity` WRITE;
/*!40000 ALTER TABLE `fls_activity`
  DISABLE KEYS */;
INSERT INTO `fls_activity` VALUES
  (1, '2020年春节活动', '<pre>\r\n2020年春节活动--内容4\r\n</pre>\r\n', '<p>2020年春节活动--规则3</p>\r\n', '<p>2020年春节活动--注意事项2</p>\r\n',
    '2020-01-20 09:00:00', '2020-01-20 21:59:59', '2020-01-16 09:06:58', '<p>2020年春节活动--备注1</p>\r\n', 1, 1);
/*!40000 ALTER TABLE `fls_activity`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fls_activity_awards`
--

DROP TABLE IF EXISTS `fls_activity_awards`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fls_activity_awards` (
  `id`          int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11)          DEFAULT '0'
  COMMENT '活动ID',
  `name`        varchar(1024)    DEFAULT ''
  COMMENT '奖项名称',
  `nick`        varchar(1024)    DEFAULT ''
  COMMENT '奖项昵称',
  `probability` float            DEFAULT '0'
  COMMENT '概率',
  `amount`      float            DEFAULT '0'
  COMMENT '金额',
  `discount`    float            DEFAULT '0'
  COMMENT '折扣',
  `remark`      varchar(1024)    DEFAULT '0'
  COMMENT '备注',
  `number`      int(11)          DEFAULT '0'
  COMMENT '奖品数量，为0代表无限',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 36
  DEFAULT CHARSET = utf8mb4
  COMMENT ='活动奖项';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fls_activity_awards`
--

LOCK TABLES `fls_activity_awards` WRITE;
/*!40000 ALTER TABLE `fls_activity_awards`
  DISABLE KEYS */;
INSERT INTO `fls_activity_awards`
VALUES (31, 1, '一等奖', '剪头优惠10元', 20, 10, 0, '剪头优惠', 0), (32, 1, '二等奖', '洗头优惠7元', 30, 7, 0, '洗头优惠', 0),
  (33, 1, '三等奖', '剪头优惠5元', 50, 5, 0, '剪头优惠', 0);
/*!40000 ALTER TABLE `fls_activity_awards`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fls_activity_win_result`
--

DROP TABLE IF EXISTS `fls_activity_win_result`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fls_activity_win_result` (
  `id`                 int(11) NOT NULL AUTO_INCREMENT,
  `activity_id`        int(11)          DEFAULT '0'
  COMMENT '活动ID',
  `activity_awards_id` int(11)          DEFAULT '0'
  COMMENT '活动奖项ID',
  `user_id`            int(11)          DEFAULT '0'
  COMMENT '中奖人ID',
  `user_mobile`        varchar(16)      DEFAULT ''
  COMMENT '中奖人手机号码',
  `user_name`          varchar(64)      DEFAULT ''
  COMMENT '中奖人称呼',
  `user_gender`        int(11)          DEFAULT NULL
  COMMENT '中奖人性别（1：男、2：女、3：未知）',
  `win_time`           datetime         DEFAULT CURRENT_TIMESTAMP
  COMMENT '中奖时间',
  `remark`             varchar(1024)    DEFAULT ''
  COMMENT '备注',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COMMENT ='中奖结果';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fls_activity_win_result`
--

LOCK TABLES `fls_activity_win_result` WRITE;
/*!40000 ALTER TABLE `fls_activity_win_result`
  DISABLE KEYS */;
/*!40000 ALTER TABLE `fls_activity_win_result`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_menu` (
  `id`            int(11)     NOT NULL AUTO_INCREMENT
  COMMENT '主键',
  `name`          varchar(64) NOT NULL DEFAULT ''
  COMMENT '菜单名称',
  `module_name`   varchar(32) NOT NULL DEFAULT ''
  COMMENT '模块名称',
  `action_name`   varchar(32) NOT NULL DEFAULT ''
  COMMENT '控制器名称',
  `function_name` varchar(32) NOT NULL DEFAULT ''
  COMMENT '方法名称',
  `user_id`       int(11)     NOT NULL DEFAULT '1'
  COMMENT '创建人',
  `parent_id`     int(11)     NOT NULL DEFAULT '0'
  COMMENT '父级菜单,默认根菜单',
  `is_menu`       int(11)     NOT NULL DEFAULT '1'
  COMMENT '是否显示在菜单上（0：不显示在菜单上，1：显示在菜单上。默认显示在菜单上）',
  `create_time`   datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '创建时间',
  `update_time`   datetime    NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '更新时间',
  `delete_time`   datetime             DEFAULT NULL
  COMMENT '删除时间',
  `sort`          int(11)     NOT NULL DEFAULT '1'
  COMMENT '排序',
  `icon`          varchar(32)          DEFAULT 'icon-music'
  COMMENT '菜单图标',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 44
  DEFAULT CHARSET = utf8mb4
  COMMENT ='菜单表 ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu`
  DISABLE KEYS */;
INSERT INTO `sys_menu` VALUES
  (1, '系统管理', 'sys', 'index', 'index', 1, 0, 1, '2018-09-26 18:51:00', '2019-04-25 17:53:11', NULL, 1, 'fa fa-gear'),
  (2, '用户管理', 'sys', 'user', 'index', 1, 1, 1, '2018-09-26 18:52:29', '2019-10-28 14:13:04', NULL, 3, 'fa fa-user'),
  (11, '菜单管理', 'sys', 'menu', 'index', 1, 1, 1, '2018-09-27 13:59:28', '2019-10-28 14:12:52', NULL, 1, 'fa fa-th-list'),
  (18, '用户-添加', 'sys', 'user', 'add', 1, 2, 0, '2018-09-27 16:13:49', '2019-10-28 14:20:24', NULL, 1, 'fa fa-user-plus'),
  (19, '用户-编辑', 'sys', 'user', 'edit', 1, 2, 0, '2018-09-27 16:14:34', '2019-10-28 14:17:24', NULL, 2, 'fa fa-edit'),
  (20, '用户-删除', 'sys', 'user', 'delete', 1, 2, 0, '2018-09-27 16:15:09', '2019-10-28 14:16:51', NULL, 3, 'fa fa-trash-o'),
  (21, '菜单-添加', 'sys', 'menu', 'add', 1, 11, 0, '2018-09-27 16:16:05', '2019-10-28 14:15:49', NULL, 1, 'fa fa-plus'),
  (22, '菜单-编辑', 'sys', 'menu', 'edit', 1, 11, 0, '2018-09-27 16:16:33', '2019-10-28 14:16:09', NULL, 2, 'fa fa-edit'),
  (23, '菜单-删除', 'sys', 'menu', 'delete', 1, 11, 0, '2018-09-27 16:17:04', '2019-10-28 14:16:23', NULL, 3, 'fa fa-trash-o'),
  (24, '角色管理', 'sys', 'role', 'index', 1, 1, 1, '2018-09-27 19:04:03', '2019-10-28 14:12:41', NULL, 2, 'fa fa-users'),
  (25, '角色-添加', 'sys', 'role', 'add', 1, 24, 0, '2018-09-28 10:20:18', '2019-10-28 14:17:43', NULL, 1, 'fa fa-plus'),
  (26, '角色-编辑', 'sys', 'role', 'edit', 1, 24, 0, '2018-09-28 10:20:53', '2019-10-28 14:17:55', NULL, 2, 'fa fa-edit'),
  (27, '角色-删除', 'sys', 'role', 'delete', 1, 24, 0, '2018-09-28 10:21:29', '2019-04-25 20:12:33', NULL, 3, 'fa fa-trash-o'),
  (28, '角色-设置权限', 'sys', 'role', 'roleSetting', 1, 24, 0, '2018-09-28 10:24:25', '2019-04-25 20:12:11', NULL, 4, 'icon-edit'),
  (36, '系统监控', 'others', 'index', 'index', 1, 0, 1, '2019-04-25 13:00:59', '2019-10-28 14:13:30', NULL, 2, 'fa fa-gears'),
  (37, '数据源', 'druid', '', '', 1, 36, 1, '2019-04-25 13:01:31', '2019-10-28 14:18:35', NULL, 1, 'fa fa-database'),
  (38, 'swagger', 'swagger-ui.html', '', '', 1, 36, 1, '2019-04-25 13:11:12', '2019-10-28 14:14:00', NULL, 2, 'fa fa-paper-plane'),
  (39, '时尚淋剪', 'fls', 'index', 'index', 1, 0, 1, '2020-01-15 10:50:10', '2020-01-15 11:01:53', NULL, 3, 'fa fa-paperclip'),
  (40, '活动管理', 'fls', 'activity', 'index', 1, 39, 1, '2020-01-15 10:51:16', '2020-01-15 11:02:07', NULL, 1, 'fa fa-glass'),
  (41, '添加', 'fls', 'activity', 'add', 1, 40, 0, '2020-01-15 10:57:15', '2020-01-15 10:57:15', NULL, 1, 'fa fa-plus'),
  (42, '编辑', 'fls', 'activity', 'edit', 1, 40, 0, '2020-01-15 10:57:55', '2020-01-15 10:57:55', NULL, 2, 'fa fa-edit'),
  (43, '删除', 'fls', 'activity', 'delete', 1, 40, 0, '2020-01-15 10:58:43', '2020-01-15 10:58:43', NULL, 3,
   'fa fa-trash-o');
/*!40000 ALTER TABLE `sys_menu`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_permission`
--

DROP TABLE IF EXISTS `sys_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_permission` (
  `id`          int(11)  NOT NULL AUTO_INCREMENT
  COMMENT '主键',
  `role_id`     int(11)  NOT NULL DEFAULT '1'
  COMMENT '角色ID',
  `menu_id`     int(11)  NOT NULL DEFAULT '1'
  COMMENT '菜单ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '更新时间',
  `delete_time` datetime          DEFAULT NULL
  COMMENT '删除时间',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 349
  DEFAULT CHARSET = utf8mb4
  COMMENT ='权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_permission`
--

LOCK TABLES `sys_permission` WRITE;
/*!40000 ALTER TABLE `sys_permission`
  DISABLE KEYS */;
INSERT INTO `sys_permission` VALUES (303, 13, 1, '2019-12-22 00:10:14', '2019-12-22 00:10:14', NULL),
  (304, 13, 24, '2019-12-22 00:10:14', '2019-12-22 00:10:14', NULL),
  (305, 13, 2, '2019-12-22 00:10:14', '2019-12-22 00:10:14', NULL),
  (306, 13, 36, '2019-12-22 00:10:14', '2019-12-22 00:10:14', NULL),
  (307, 13, 38, '2019-12-22 00:10:14', '2019-12-22 00:10:14', NULL),
  (327, 1, 1, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (328, 1, 11, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (329, 1, 21, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (330, 1, 22, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (331, 1, 23, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (332, 1, 24, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (333, 1, 25, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (334, 1, 26, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (335, 1, 27, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (336, 1, 28, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (337, 1, 2, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (338, 1, 18, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (339, 1, 19, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (340, 1, 20, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (341, 1, 36, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (342, 1, 37, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (343, 1, 38, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (344, 1, 39, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (345, 1, 40, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (346, 1, 41, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (347, 1, 42, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL),
  (348, 1, 43, '2020-01-15 10:59:10', '2020-01-15 10:59:10', NULL);
/*!40000 ALTER TABLE `sys_permission`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role` (
  `id`          int(11)      NOT NULL AUTO_INCREMENT
  COMMENT '主键',
  `name`        varchar(32)  NOT NULL DEFAULT ''
  COMMENT '角色名称',
  `code`        varchar(32)  NOT NULL DEFAULT ''
  COMMENT '角色code',
  `user_id`     int(11)      NOT NULL DEFAULT '1'
  COMMENT '创建人',
  `create_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '创建时间',
  `update_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '更新时间',
  `delete_time` datetime              DEFAULT NULL
  COMMENT '删除时间',
  `represent`   varchar(128) NOT NULL DEFAULT ''
  COMMENT '描述',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 14
  DEFAULT CHARSET = utf8mb4
  COMMENT ='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role`
  DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', 1, '2018-09-26 16:06:35', '2019-04-24 16:08:18', NULL, '超级管理员'),
  (13, '普通管理员', 'putong', 1, '2018-09-27 20:59:36', '2019-12-22 00:29:05', NULL, '这是普通管理员123');
/*!40000 ALTER TABLE `sys_role`
  ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user` (
  `id`          int(11)      NOT NULL AUTO_INCREMENT
  COMMENT '主键',
  `name`        varchar(32)  NOT NULL DEFAULT ''
  COMMENT '名称',
  `password`    varchar(32)  NOT NULL DEFAULT ''
  COMMENT '密码',
  `nick`        varchar(32)  NOT NULL DEFAULT ''
  COMMENT '昵称',
  `email`       varchar(128) NOT NULL DEFAULT ''
  COMMENT '电子邮件',
  `gender`      int(11)      NOT NULL DEFAULT '1'
  COMMENT '性别（1，男、2，女）',
  `birthday`    datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '生日',
  `address`     varchar(128) NOT NULL DEFAULT ''
  COMMENT '地址',
  `create_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '创建时间',
  `update_time` datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP
  COMMENT '更新时间',
  `delete_time` datetime              DEFAULT NULL
  COMMENT '删除时间',
  `role_id`     int(11)      NOT NULL DEFAULT '1'
  COMMENT '用户所属角色',
  `avatar`      varchar(1024)         DEFAULT ''
  COMMENT '头像',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  AUTO_INCREMENT = 15
  DEFAULT CHARSET = utf8mb4
  COMMENT ='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user`
  DISABLE KEYS */;
INSERT INTO `sys_user` VALUES
  (1, 'admin', '4841469ad3c057edb6ce63c31e37f836', '闻品高', '1099422716@qq.com', 2, '1992-07-05 00:03:00',
      '哈哈国呵呵省嘿嘿市哦哦县嗯嗯镇', '2018-09-26 15:47:05', '2019-10-28 14:53:12', NULL, 1,
   '/upload/2019/10/28/14/cac9f1c7-a8c8-4b67-819f-1d0157ebaecf.jpg'),
  (11, 'lajigao', 'c0774224227a631ae21fc1fdb741bae5', '垃圾高', 'wenpingao1992@gmail.com', 2, '1992-07-05 00:00:00',
       '大理州洱源县', '2018-09-28 14:02:01', '2019-04-24 14:22:26', NULL, 13, ''),
  (12, 'guns', 'c0774224227a631ae21fc1fdb741bae5', 'guns', 'wenpingao1992@163.com', 2, '2018-09-27 00:00:00', '昆明市',
       '2018-09-28 14:26:39', '2020-01-16 13:45:59', NULL, 13, ''),
  (13, 'test', 'caf5d04b8ace314016a4d549b3fca735', 'demo123', 'test@qq.com', 1, '1992-07-05 00:00:00', '哈哈哈',
       '2019-04-23 22:20:10', '2019-04-25 08:32:00', '2019-11-27 21:00:56', 13, ''),
  (14, '张山', 'c0774224227a631ae21fc1fdb741bae5', 'tets', 'wen@qq.com', 1, '2012-04-10 00:00:00', 'cds',
       '2019-04-24 14:18:56', '2019-04-24 14:18:56', '2019-11-27 21:00:56', 13, '');
/*!40000 ALTER TABLE `sys_user`
  ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE = @OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE = @OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES = @OLD_SQL_NOTES */;

-- Dump completed on 2020-01-16 14:19:23