/*
 Navicat Premium Data Transfer

 Source Server         : goods练习
 Source Server Type    : MySQL
 Source Server Version : 50568
 Source Host           : 139.224.53.188:3306
 Source Schema         : single_data

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

 Date: 02/03/2022 16:10:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sl_goods
-- ----------------------------
DROP TABLE IF EXISTS `sl_goods`;
CREATE TABLE `sl_goods`  (
  `id` int(16) NOT NULL COMMENT '商品id',
  `good_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品名字',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品价格',
  `describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品描述',
  `supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '提供商',
  `goodsImg` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品图片',
  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '店家留言',
  `recommend` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否推荐 1 / 0',
  `create_time` datetime NULL DEFAULT NULL COMMENT '上架时间',
  `goodsShow` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否显示/隐藏',
  `type_id` int(16) NULL DEFAULT NULL COMMENT '关联分类',
  `first_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '商品首图',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_goods
-- ----------------------------
INSERT INTO `sl_goods` VALUES (1, '小牛肉', 10.00, '好吃的牛肉', '伟大供应商', '[{\"uid\":\"rc-upload-1645670488927-7\",\"name\":\"（2021）闽0128民初4719号-摩恩达集团（上海）净水技术有限公司-送达回证.pdf.jpg\",\"url\":\"http://47.98.215.115:8089/upload/2022/02/24//2eecb88d-24d6-43cd-8715-f37c6f097af0.jpg\"},{\"uid\":\"rc-upload-1645670488927-9\",\"name\":\"aaaaaa.jpg\",\"url\":\"http://47.98.215.115:8089/upload/2022/02/24//3292be48-3f31-4409-aca5-c41c31d0b611.jpg\"}]', '推荐亲们品尝', '1', '2022-02-19 22:15:57', '1', 1, 'http://47.98.215.115:8089/upload/2022/02/25//d5e50676-11c2-4457-9fb4-3ed303ae8245.jpg');
INSERT INTO `sl_goods` VALUES (2, '大羊排1111', 16.00, '好吃的羊排推荐', '伟大牛排', '[]', '推荐来买大大的羊排', '1', '2022-02-20 13:42:24', '1', 2, 'http://47.98.215.115:8089/upload/2022/02/25//a8cc2016-d092-44b2-a6a2-68a3c49f499d.jpg');
INSERT INTO `sl_goods` VALUES (3, '大羊肉', 16.00, '好吃的羊排推荐', '伟大牛排', '[]', '推荐来买大大的羊排', '1', NULL, '1', 3, 'http://47.98.215.115:8089/upload/2022/02/25//d6fad47c-c6d7-42f5-9750-15fa3b09557d.jpg');
INSERT INTO `sl_goods` VALUES (4, '牛排', 10.00, '好吃的牛肉', '伟大供应商', '[{\"uid\":\"rc-upload-1645670488927-7\",\"name\":\"（2021）闽0128民初4719号-摩恩达集团（上海）净水技术有限公司-送达回证.pdf.jpg\",\"url\":\"http://47.98.215.115:8089/upload/2022/02/24//2eecb88d-24d6-43cd-8715-f37c6f097af0.jpg\"},{\"uid\":\"rc-upload-1645670488927-9\",\"name\":\"aaaaaa.jpg\",\"url\":\"http://47.98.215.115:8089/upload/2022/02/24//3292be48-3f31-4409-aca5-c41c31d0b611.jpg\"}]', '推荐亲们品尝', '1', '2022-02-19 22:15:57', '1', 1, 'http://47.98.215.115:8089/upload/2022/02/24//c9c82346-7310-429e-8d82-7cd0ab35eae9.jpg');

-- ----------------------------
-- Table structure for sl_journal
-- ----------------------------
DROP TABLE IF EXISTS `sl_journal`;
CREATE TABLE `sl_journal`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(56) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '标题',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '日志内容',
  `journal_img` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '日志图片',
  `show` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '显示/隐藏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sl_journal
-- ----------------------------
INSERT INTO `sl_journal` VALUES (1, '测试用3', '2022-03-01 10:15:45', '测试内容1', '[{\"uid\":\"rc-upload-1646121905723-5\",\"name\":\"（2021）闽0128民初4719号-摩恩达集团（上海）净水技术有限公司-送达回证.pdf.jpg\",\"url\":\"http://139.224.53.188:8089/upload/2022/03/01//e86fbb57-2c0d-48bc-b4ed-4abea8113148.jpg\"}]', '1');
INSERT INTO `sl_journal` VALUES (2, '测试用', '2022-03-01 03:06:28', '测试内容', NULL, '1');
INSERT INTO `sl_journal` VALUES (3, '测试用11111', '2022-03-01 03:06:44', '测试内容1', '[{\"uid\":\"rc-upload-1646119838656-2\",\"name\":\"（2021）闽0128民初4719号-摩恩达集团（上海）净水技术有限公司-送达回证.pdf.jpg\",\"url\":\"http://139.224.53.188:8089/upload/2022/03/01//b684278c-fdb0-4862-be29-afe942e32535.jpg\"}]', '0');
INSERT INTO `sl_journal` VALUES (4, '测试用3', '2022-03-01 03:11:35', '测试内容1', '3333', '1');
INSERT INTO `sl_journal` VALUES (5, '版本2.0', '2022-03-01 07:37:14', '测试内容看看', NULL, '1');
INSERT INTO `sl_journal` VALUES (6, '版本3.0', '2022-03-01 07:37:57', '12312321', NULL, '1');
INSERT INTO `sl_journal` VALUES (7, '版本4.0', '2022-03-01 07:43:47', '测试内容看看', '[{\"uid\":\"rc-upload-1646120615044-2\",\"name\":\"5d8a53114d51516d1053a05c238e454.jpg\",\"url\":\"http://139.224.53.188:8089/upload/2022/03/01//0be108e7-6c3a-4ab4-bbf2-cd838b21fd72.jpg\"},{\"uid\":\"rc-upload-1646120615044-4\",\"name\":\"5d8a53114d51516d1053a05c238e454.jpg\",\"url\":\"http://139.224.53.188:8089/upload/2022/03/01//25c2cc51-51a1-480b-b4e5-bb56b5778ec2.jpg\"}]', '1');

-- ----------------------------
-- Table structure for sl_menu
-- ----------------------------
DROP TABLE IF EXISTS `sl_menu`;
CREATE TABLE `sl_menu`  (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '菜单名字',
  `parent_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '父菜单ID',
  `order_num` int(4) NULL DEFAULT NULL COMMENT '显示顺序',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '组件路由',
  `query` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '路由参数',
  `menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '菜单状态（0显示 1隐藏）',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '菜单图标',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_menu
-- ----------------------------
INSERT INTO `sl_menu` VALUES (1, '首页', '0', 1, '/welcome', './Welcome', NULL, 'M', '0', 'UserOutlined', '2022-01-11 22:21:13', '无');
INSERT INTO `sl_menu` VALUES (2, '用户管理', '0', 2, '', '', NULL, 'M', '0', 'UserOutlined', '2022-01-09 23:48:47', '无');
INSERT INTO `sl_menu` VALUES (3, '轮播图管理', '0', 3, '/roleImg', './roleImg', NULL, 'M', '0', 'AreaChartOutlined', '2022-01-09 23:50:58', '无');
INSERT INTO `sl_menu` VALUES (4, '通知公告', '0', 4, '/journal', './Welcome', NULL, 'M', '0', 'MessageOutlined', '2022-01-10 00:15:18', '无');
INSERT INTO `sl_menu` VALUES (5, '商品管理', '0', 5, '/', NULL, NULL, 'M', '0', 'GiftFilled', '2022-02-19 23:20:59', '无');
INSERT INTO `sl_menu` VALUES (100, '账号管理', '2', 1, '/userManage', './userManage', NULL, 'C', '0', 'UserOutlined', '2022-01-11 22:22:59', '无');
INSERT INTO `sl_menu` VALUES (102, '一级分类', '5', 6, '/types', './types', NULL, 'C', '0', 'UserOutlined', '2022-02-19 23:22:09', NULL);
INSERT INTO `sl_menu` VALUES (103, '商品', '5', 7, '/goods', './goods', NULL, 'C', '0', 'GiftFilled', '2022-02-19 23:22:45', NULL);

-- ----------------------------
-- Table structure for sl_role
-- ----------------------------
DROP TABLE IF EXISTS `sl_role`;
CREATE TABLE `sl_role`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色id',
  `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '角色名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `remark` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_role
-- ----------------------------
INSERT INTO `sl_role` VALUES (1, '超级管理员', '2022-01-09 23:16:20', '超级管理员');
INSERT INTO `sl_role` VALUES (2, '普通用户', '2022-01-09 23:16:33', '普通用户');

-- ----------------------------
-- Table structure for sl_rotation
-- ----------------------------
DROP TABLE IF EXISTS `sl_rotation`;
CREATE TABLE `sl_rotation`  (
  `id` int(16) NOT NULL AUTO_INCREMENT COMMENT '轮播图id',
  `rota_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '轮播图名称',
  `rota_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '轮播图图片地址',
  `rota_show` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '轮播图显示/隐藏  = 1 / 0 ',
  `create_time` datetime NULL DEFAULT NULL,
  `rota_sort` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '轮播图排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_rotation
-- ----------------------------
INSERT INTO `sl_rotation` VALUES (1, '第一个轮播图', 'http://139.224.53.188:8089/upload/2022/03/01//e83a8305-50d5-43ee-888b-b358d32f758d.jpg', '1', '2022-02-13 22:31:33', '111');
INSERT INTO `sl_rotation` VALUES (2, '第二个轮播图', 'http://139.224.53.188:8089/upload/2022/03/02//cfa3df1a-976d-4fd8-a2d3-3ce14abaa6d1.jpg', '1', '2022-02-15 16:18:55', NULL);
INSERT INTO `sl_rotation` VALUES (3, '第二个轮播图', 'http://47.98.215.115:8089/upload/2022/02/25//cd4e4701-1fe4-4397-ae58-f6aee1f868f3.jpg', '1', '2022-02-15 16:19:58', NULL);
INSERT INTO `sl_rotation` VALUES (4, '第四个轮播图', 'http://139.224.53.188:8089/upload/2022/03/02//a0086d23-6e76-4a92-8c54-c68ceb11b4b6.jpg', '0', '2022-02-17 15:54:13', '1');
INSERT INTO `sl_rotation` VALUES (11, '测试333', 'http://47.98.215.115:8089/upload/2022/02/24//32b028ac-556e-424c-8353-9b45340dafb9.png', '1', '2022-02-24 06:15:25', '中文');

-- ----------------------------
-- Table structure for sl_type
-- ----------------------------
DROP TABLE IF EXISTS `sl_type`;
CREATE TABLE `sl_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '分类名',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间\r\n',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  `show` char(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '显示隐藏 1/0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_type
-- ----------------------------
INSERT INTO `sl_type` VALUES (1, '超级牛肉', '2022-02-19 00:00:00', '1', '1');
INSERT INTO `sl_type` VALUES (2, '水产1', '2022-02-19 00:00:00', '水产商品', '1');
INSERT INTO `sl_type` VALUES (3, '海鲜干货', '2022-02-19 00:00:00', NULL, '1');
INSERT INTO `sl_type` VALUES (4, '冰冻产品', '2022-02-19 00:00:00', NULL, '1');
INSERT INTO `sl_type` VALUES (5, '鲜肉', '2022-02-19 00:00:00', NULL, '1');
INSERT INTO `sl_type` VALUES (6, '更新数据1', NULL, '测试备注', '1');
INSERT INTO `sl_type` VALUES (7, '测试数据1', '2022-02-19 15:42:41', '测试备注', '1');
INSERT INTO `sl_type` VALUES (8, '页面数据1', '2022-02-20 13:40:37', '暂无', '1');
INSERT INTO `sl_type` VALUES (9, '1231', '2022-02-24 02:43:06', '123', '1');
INSERT INTO `sl_type` VALUES (10, '123', '2022-02-24 02:43:14', '13', '1');
INSERT INTO `sl_type` VALUES (11, '1231', '2022-02-24 02:43:17', '123', '1');

-- ----------------------------
-- Table structure for sl_user
-- ----------------------------
DROP TABLE IF EXISTS `sl_user`;
CREATE TABLE `sl_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户昵称',
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户性别（0男 1女 2未知）',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '密码',
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户状态',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '删除标志（0代表存在 2代表删除）',
  `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注',
  `avatar` blob NULL COMMENT '用户头像',
  PRIMARY KEY (`user_id`, `user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_user
-- ----------------------------
INSERT INTO `sl_user` VALUES (1, 'admin', 'admin', '0', 'E10ADC3949BA59ABBE56E057F20F883E', '1', '0', '2022-01-09 23:06:57', '2022-01-11 20:06:57', '备注信息', 0x687474703A2F2F3133392E3232342E35332E3138383A383038392F75706C6F61642F323032322F30332F30322F2F63336566626565302D616364622D343136362D393365392D6639336330303331326331642E6A7067);
INSERT INTO `sl_user` VALUES (2, 'ceshi', 'ceshi11111', '0', '123456', '1', '0', NULL, '2022-01-06 07:06:57', '暂无', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F31372F2F35653661393531322D653165372D343032642D623362302D3030643961623838313363652E6A666966);
INSERT INTO `sl_user` VALUES (3, 'ceshi1', 'ceshi1', '0', '123456', '1', '0', NULL, '2022-01-06 23:06:57', '这是测试账号2', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F31372F2F37373262323239612D613661642D346137642D613462622D3331373136356635363362662E6A666966);
INSERT INTO `sl_user` VALUES (4, 'ceshi2', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-06 07:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F31372F2F62316439313633662D343236612D346264372D613935642D6265626130306166306666612E6A666966);
INSERT INTO `sl_user` VALUES (5, 'ceshi3', 'ceshi', '0', '123456', '1', '0', NULL, '2022-01-06 07:06:57', '无', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (6, 'ceshi4', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-06 07:06:57', '测试图片', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30392F2F34653464626432312D653035332D343661382D623034352D6332303161303431613534332E6A666966);
INSERT INTO `sl_user` VALUES (7, 'ceshi5', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-05 23:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (8, 'ceshi6', 'ceshi', '2', '123456', '1', '0', NULL, '2022-01-05 23:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (9, 'ceshi7', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-05 23:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (10, 'ceshi8', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-05 23:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (11, 'ceshi9', 'ceshi', '1', '123456', '1', '0', NULL, '2022-01-05 23:06:57', NULL, 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (15, 'admin1', '', '1', '123456', '1', '0', NULL, '2022-01-09 17:11:16', '备注信息', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (16, 'admin1', '', '1', '123456', '1', '0', NULL, '2022-01-09 19:37:22', '备注信息', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (17, 'admin12', '', '1', NULL, '1', '0', NULL, '2022-01-23 23:12:52', '备注信息', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (18, 'admin12', '', '1', '123456', '1', '0', NULL, '2022-01-23 23:13:18', '备注信息', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (19, 'admin12333', '', '1', '123456', '1', '0', NULL, '2022-01-23 23:14:19', '备注信息', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A6669662C687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (20, 'doudou', '豆豆', '0', '123456', '1', '0', NULL, '2022-01-23 23:20:37', '123', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30382F2F66626561353763372D663239612D346265622D623034652D6236616231643633623039352E6A666966);
INSERT INTO `sl_user` VALUES (21, 'xiaoqi', '小七', '1', '123456', '1', '0', NULL, '2022-01-24 07:22:06', '测试小七', 0x687474703A2F2F34372E39382E3231352E3131353A383038392F75706C6F61642F323032322F30322F32342F2F38303763383463352D366637362D346462332D623065622D3762633230396264313131622E706E67);
INSERT INTO `sl_user` VALUES (22, 'douyi', '花花', '0', '123456', '1', '0', NULL, '2022-02-09 23:58:13', '测试图片', 0x687474703A2F2F6C6F63616C686F73743A383038392F75706C6F61642F323032322F30322F30392F2F31333865326238382D666538632D343165322D383534612D3332383534303335376462612E6A666966);

-- ----------------------------
-- Table structure for sl_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sl_user_role`;
CREATE TABLE `sl_user_role`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `role_id` bigint(20) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sl_user_role
-- ----------------------------
INSERT INTO `sl_user_role` VALUES (1, 1);
INSERT INTO `sl_user_role` VALUES (2, 2);

SET FOREIGN_KEY_CHECKS = 1;