-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2024-04-09 09:00:22
-- 服务器版本： 5.7.40-log
-- PHP 版本： 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- 数据库： `cooladmin`
--

-- --------------------------------------------------------

--
-- 表的结构 `app_articles`
--

CREATE TABLE `app_articles` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `circleId` int(11) NOT NULL COMMENT '圈子',
  `tagIds` varchar(255) NOT NULL COMMENT '标签',
  `userId` int(11) NOT NULL COMMENT '用户',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0:禁用 1:启用',
  `isTop` tinyint(4) NOT NULL DEFAULT '0' COMMENT '置顶',
  `topEndTime` bigint(20) DEFAULT NULL COMMENT '置顶结束时间',
  `images` text COMMENT '图片',
  `content` text NOT NULL COMMENT '内容',
  `views` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_articles`
--

INSERT INTO `app_articles` (`id`, `createTime`, `updateTime`, `circleId`, `tagIds`, `userId`, `status`, `isTop`, `topEndTime`, `images`, `content`, `views`) VALUES
(34, '2023-10-24 12:43:53.735493', '2024-03-04 09:14:32.495000', 1, '23', 1, 0, 0, NULL, 'http://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/xcxy/1698122632527.jpg,http://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/xcxy/1698122632534.jpg', '首先声明这小程序是我个人20年在校期间写的，每年服务器，域名等费用，以及其他维护成本，都由我个人支出，拱你们这么多人用，相信接触到或者了解这些东西的同学应该知道，我没有任何义务说一定为你们提供服务。\n\n其次免费的东西你们还闲这嫌那的，我求着你用了？有些人吃相不要太难看了。是哪些人我就不说了🙂🙂🙂', 1622);

-- --------------------------------------------------------

--
-- 表的结构 `app_article_likes`
--

CREATE TABLE `app_article_likes` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `articleId` int(11) NOT NULL COMMENT '文章id',
  `userId` int(11) NOT NULL COMMENT '用户id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_article_likes`
--

INSERT INTO `app_article_likes` (`id`, `createTime`, `updateTime`, `articleId`, `userId`) VALUES
(27, '2023-10-18 15:22:50.322062', '2023-10-18 15:22:50.322062', 33, 875),
(29, '2023-10-20 11:59:11.074124', '2023-10-20 11:59:11.074124', 33, 920),
(30, '2023-10-24 12:59:12.794295', '2023-10-24 12:59:12.794295', 34, 426),
(31, '2023-10-24 13:29:14.752087', '2023-10-24 13:29:14.752087', 34, 200),
(32, '2023-10-24 13:29:17.619878', '2023-10-24 13:29:17.619878', 34, 96),
(33, '2023-10-24 13:31:17.564317', '2023-10-24 13:31:17.564317', 34, 243),
(34, '2023-10-24 14:21:37.301319', '2023-10-24 14:21:37.301319', 34, 1415),
(35, '2023-10-24 15:30:59.926512', '2023-10-24 15:30:59.926512', 34, 458),
(36, '2023-10-24 16:10:19.231374', '2023-10-24 16:10:19.231374', 34, 75),
(37, '2023-10-24 17:29:33.912454', '2023-10-24 17:29:33.912454', 34, 167),
(38, '2023-10-24 17:32:58.741588', '2023-10-24 17:32:58.741588', 34, 1324),
(40, '2023-10-24 19:09:45.478093', '2023-10-24 19:09:45.478093', 34, 1291),
(42, '2023-10-24 19:13:03.228523', '2023-10-24 19:13:03.228523', 34, 399),
(43, '2023-10-24 19:42:33.132151', '2023-10-24 19:42:33.132151', 34, 875),
(47, '2023-10-24 19:51:46.940592', '2023-10-24 19:51:46.940592', 34, 230),
(48, '2023-10-24 20:09:39.567701', '2023-10-24 20:09:39.567701', 34, 1565),
(50, '2023-10-24 20:54:50.444210', '2023-10-24 20:54:50.444210', 34, 866),
(52, '2023-10-24 21:24:42.090004', '2023-10-24 21:24:42.090004', 34, 407),
(53, '2023-10-24 21:46:43.439766', '2023-10-24 21:46:43.439766', 34, 292),
(56, '2023-10-24 23:26:55.655598', '2023-10-24 23:26:55.655598', 34, 364),
(57, '2023-10-24 23:47:03.378148', '2023-10-24 23:47:03.378148', 34, 433),
(58, '2023-10-24 23:48:11.425477', '2023-10-24 23:48:11.425477', 34, 783),
(60, '2023-10-25 00:53:16.939037', '2023-10-25 00:53:16.939037', 34, 616),
(61, '2023-10-25 01:07:36.674138', '2023-10-25 01:07:36.674138', 34, 20),
(62, '2023-10-25 01:30:03.375794', '2023-10-25 01:30:03.375794', 34, 22),
(63, '2023-10-25 01:47:21.393776', '2023-10-25 01:47:21.393776', 34, 925),
(64, '2023-10-25 07:32:59.401578', '2023-10-25 07:32:59.401578', 34, 1132),
(65, '2023-10-25 09:09:49.428090', '2023-10-25 09:09:49.428090', 34, 256),
(66, '2023-10-25 09:38:26.157128', '2023-10-25 09:38:26.157128', 34, 293),
(69, '2023-10-25 09:55:38.434544', '2023-10-25 09:55:38.434544', 34, 409),
(70, '2023-10-25 10:34:53.829164', '2023-10-25 10:34:53.829164', 34, 1032),
(71, '2023-10-25 11:03:47.785145', '2023-10-25 11:03:47.785145', 34, 1532),
(73, '2023-10-25 11:19:12.812928', '2023-10-25 11:19:12.812928', 34, 903),
(74, '2023-10-25 11:41:35.685760', '2023-10-25 11:41:35.685760', 34, 620),
(75, '2023-10-25 11:58:25.749008', '2023-10-25 11:58:25.749008', 34, 470),
(76, '2023-10-25 12:34:58.875348', '2023-10-25 12:34:58.875348', 34, 603),
(78, '2023-10-25 12:39:04.515981', '2023-10-25 12:39:04.515981', 34, 1021),
(82, '2023-10-25 15:26:54.358603', '2023-10-25 15:26:54.358603', 34, 98),
(83, '2023-10-25 16:00:57.107228', '2023-10-25 16:00:57.107228', 34, 1409),
(85, '2023-10-25 19:17:54.419736', '2023-10-25 19:17:54.419736', 34, 1609),
(87, '2023-10-26 21:01:10.525314', '2023-10-26 21:01:10.525314', 34, 968),
(88, '2023-10-26 21:37:50.463790', '2023-10-26 21:37:50.463790', 34, 570),
(89, '2023-10-27 01:17:50.248882', '2023-10-27 01:17:50.248882', 34, 449),
(90, '2023-10-28 14:24:35.225589', '2023-10-28 14:24:35.225589', 34, 235),
(91, '2023-10-28 23:53:16.145536', '2023-10-28 23:53:16.145536', 34, 49),
(92, '2023-10-28 23:56:22.689743', '2023-10-28 23:56:22.689743', 34, 774),
(94, '2023-10-29 22:10:42.792054', '2023-10-29 22:10:42.792054', 34, 223),
(95, '2023-10-29 22:11:52.477213', '2023-10-29 22:11:52.477213', 34, 1188),
(96, '2023-10-29 23:53:23.746986', '2023-10-29 23:53:23.746986', 34, 421),
(97, '2023-10-30 00:27:30.939284', '2023-10-30 00:27:30.939284', 34, 443),
(98, '2023-10-30 06:42:26.401775', '2023-10-30 06:42:26.401775', 34, 1677),
(99, '2023-10-30 07:51:58.374888', '2023-10-30 07:51:58.374888', 34, 1407),
(100, '2023-10-30 10:25:59.589954', '2023-10-30 10:25:59.589954', 34, 1564),
(102, '2023-10-30 22:52:33.649036', '2023-10-30 22:52:33.649036', 34, 124),
(103, '2023-10-31 00:11:51.635194', '2023-10-31 00:11:51.635194', 34, 919),
(104, '2023-10-31 08:06:49.934953', '2023-10-31 08:06:49.934953', 34, 1525),
(105, '2023-10-31 08:16:32.895880', '2023-10-31 08:16:32.895880', 34, 1573),
(106, '2023-10-31 11:11:55.588484', '2023-10-31 11:11:55.588484', 34, 1511),
(107, '2023-10-31 20:15:50.991663', '2023-10-31 20:15:50.991663', 34, 1741),
(108, '2023-11-01 01:33:25.362062', '2023-11-01 01:33:25.362062', 34, 1),
(109, '2023-11-02 15:34:58.630923', '2023-11-02 15:34:58.630923', 34, 1371),
(110, '2023-11-02 21:26:13.194283', '2023-11-02 21:26:13.194283', 34, 1804),
(111, '2023-11-03 08:45:20.929608', '2023-11-03 08:45:20.929608', 34, 1483),
(112, '2023-11-06 00:12:27.498391', '2023-11-06 00:12:27.498391', 34, 228),
(113, '2023-11-06 18:06:29.477323', '2023-11-06 18:06:29.477323', 34, 1192),
(114, '2023-11-06 18:06:34.889260', '2023-11-06 18:06:34.889260', 34, 1756),
(115, '2023-11-07 08:53:49.036552', '2023-11-07 08:53:49.036552', 34, 1770),
(116, '2023-11-09 10:19:50.745033', '2023-11-09 10:19:50.745033', 34, 1658),
(117, '2023-11-09 13:32:43.299599', '2023-11-09 13:32:43.299599', 34, 1251),
(118, '2023-11-15 10:50:43.069932', '2023-11-15 10:50:43.069932', 34, 1016),
(122, '2023-11-24 10:27:18.432129', '2023-11-24 10:27:18.432129', 34, 2070),
(123, '2023-11-29 13:00:14.446629', '2023-11-29 13:00:14.446629', 34, 1182),
(124, '2023-11-30 00:59:02.441042', '2023-11-30 00:59:02.441042', 34, 818),
(125, '2023-12-10 23:05:24.157737', '2023-12-10 23:05:24.157737', 34, 1395),
(126, '2023-12-11 00:43:20.727668', '2023-12-11 00:43:20.727668', 34, 2078),
(127, '2023-12-13 17:13:22.621438', '2023-12-13 17:13:22.621438', 34, 2186),
(129, '2023-12-19 01:35:55.706356', '2023-12-19 01:35:55.706356', 34, 1411),
(131, '2024-01-03 23:41:04.833071', '2024-01-03 23:41:04.833071', 34, 632),
(132, '2024-01-18 20:30:00.021690', '2024-01-18 20:30:00.021690', 34, 2240),
(133, '2024-01-21 08:54:32.902870', '2024-01-21 08:54:32.902870', 34, 1048),
(134, '2024-01-25 16:42:00.709905', '2024-01-25 16:42:00.709905', 34, 761),
(135, '2024-01-25 20:16:01.185600', '2024-01-25 20:16:01.185600', 34, 2337),
(136, '2024-02-29 17:01:11.063387', '2024-02-29 17:01:11.063387', 34, 2547),
(137, '2024-03-01 12:46:54.618133', '2024-03-01 12:46:54.618133', 34, 442),
(138, '2024-03-03 12:26:14.954258', '2024-03-03 12:26:14.954258', 34, 451);

-- --------------------------------------------------------

--
-- 表的结构 `app_banner`
--

CREATE TABLE `app_banner` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `image` text NOT NULL COMMENT '图片',
  `url` varchar(255) DEFAULT NULL COMMENT '路径',
  `type` enum('event','navigateTo','ToMiniProgram') NOT NULL DEFAULT 'event' COMMENT '类型 event:触发事件 navigateTo:跳转页面 ToMiniProgram:跳转小程序',
  `appid` varchar(255) DEFAULT NULL COMMENT '小程序appid',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1：启用',
  `title` varchar(255) DEFAULT '' COMMENT '标题',
  `text` varchar(255) DEFAULT '' COMMENT '文本'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_banner`
--

INSERT INTO `app_banner` (`id`, `createTime`, `updateTime`, `image`, `url`, `type`, `appid`, `status`, `title`, `text`) VALUES
(1, '2023-09-06 11:25:28.917000', '2023-11-13 08:46:44.999000', 'https://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/base/ccee418dda0146bda3d5ae5016992219_7d8f69c85e4c696007.jpg', '', 'event', NULL, 1, '', ''),
(2, '2023-09-06 12:58:30.046000', '2023-10-17 14:31:49.701000', 'https://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/base/ce1482b522a240b884669ee688b6e720_5b1b4cb61eaeb36a3a5f3eeff36a2d5c.jpeg', NULL, 'event', NULL, 0, '', ''),
(3, '2022-09-15 11:17:56.000000', '2023-11-21 12:06:49.212000', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/bcad2f3b-7eb6-4bbe-8ead-c727d4bbf2d5_bcf4bc25-984f-4814-93fb-3a5f34ed2b61_5941f68dcae8d763.jpg', '', 'event', NULL, 1, NULL, NULL),
(4, '2022-09-15 11:18:06.000000', '2023-10-24 23:15:28.145000', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/7f1900b2-ef6a-4921-87c5-27bd60dab3aa_00b1cdce-31c6-431b-8887-fc107cb34e41_20210809-152425-f8d5.jpg', '', 'event', NULL, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `app_category`
--

CREATE TABLE `app_category` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(50) NOT NULL COMMENT '分类名称',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1:启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_category`
--

INSERT INTO `app_category` (`id`, `createTime`, `updateTime`, `name`, `status`) VALUES
(1, '2023-09-20 16:03:10.011000', '2023-09-20 16:03:10.011000', '学校', 1),
(2, '2023-09-20 16:03:43.087000', '2023-09-20 16:03:45.102000', '感情', 1);

-- --------------------------------------------------------

--
-- 表的结构 `app_circle`
--

CREATE TABLE `app_circle` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `categoryIds` varchar(50) NOT NULL COMMENT '圈子分类',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(50) NOT NULL COMMENT '圈子名称',
  `description` varchar(255) NOT NULL COMMENT '圈子描述',
  `cover` varchar(500) NOT NULL COMMENT '圈子封面',
  `openid` varchar(50) NOT NULL COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0:禁用 1:启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_circle`
--

INSERT INTO `app_circle` (`id`, `categoryIds`, `createTime`, `updateTime`, `name`, `description`, `cover`, `openid`, `status`) VALUES
(1, '41', '2023-09-20 16:40:25.559000', '2023-10-24 12:19:37.120000', '...', '...', 'https://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/base/208b1b3f2ff14a798d0aa9b2779ffd7d_IMG_0810.jpeg', 'oabDj4oo1wQlQXlYmcz2ncvdfw0U', 1),
(6, '38', '2023-10-17 21:37:28.332149', '2023-10-17 23:21:27.689000', '跑步', '跑步！！', 'http://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/xcxy/1697549847776.jpg', 'oabDj4vMGl2FQOrTcF8ac3XUYfmU', 1);

-- --------------------------------------------------------

--
-- 表的结构 `app_comments`
--

CREATE TABLE `app_comments` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` int(11) NOT NULL COMMENT '用户ID',
  `content` varchar(255) NOT NULL COMMENT '评论内容',
  `articleId` int(11) DEFAULT NULL COMMENT '文章ID',
  `pid` int(11) DEFAULT NULL COMMENT '父ID',
  `toUserId` int(11) DEFAULT NULL COMMENT '回复用户ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_comments`
--

INSERT INTO `app_comments` (`id`, `createTime`, `updateTime`, `userId`, `content`, `articleId`, `pid`, `toUserId`) VALUES
(41, '2023-10-24 19:15:50.705460', '2023-10-24 19:15:50.705460', 399, '学姐/长不要生气啊😖不理他们', 34, NULL, NULL),
(42, '2023-10-24 19:17:18.981088', '2023-10-24 19:17:18.981088', 254, '学长，别生气了，我们真的很需要你', 34, NULL, NULL),
(43, '2023-10-24 19:50:43.575278', '2023-10-24 19:50:43.575278', 1564, '学长别生气别生气，我们需要你😭', 34, NULL, NULL),
(44, '2023-10-24 19:51:35.952118', '2023-10-24 19:51:35.952118', 1564, '学姐别生气～我们需要你😭😭', 34, NULL, NULL),
(45, '2023-10-24 21:46:20.743315', '2023-10-24 21:46:20.743315', 292, '别生气(づ ●─● )づ我们需要你😫', 34, NULL, NULL),
(46, '2023-10-24 21:50:40.360457', '2023-10-24 21:50:40.360457', 292, '建议收费维持。', 34, NULL, NULL),
(47, '2023-10-24 23:34:28.678830', '2023-10-24 23:34:28.678830', 243, '❤️❤️❤️❤️❤️❤️', 34, NULL, NULL),
(48, '2023-10-25 01:12:48.990713', '2023-10-25 01:12:48.990713', 1549, '学长我们需要你', 34, NULL, NULL),
(49, '2023-10-25 01:25:43.458388', '2023-10-25 01:25:43.458388', 309, '学长是个好人啊！吐槽的人是什么玩意啊?', 34, NULL, NULL),
(50, '2023-10-25 01:31:00.707119', '2023-10-25 01:31:00.707119', 22, '学长我们需要你，不要理他们🥹', 34, NULL, NULL),
(51, '2023-10-25 09:39:07.697647', '2023-10-25 09:39:07.697647', 713, '学长我们真的需要你', 34, NULL, NULL),
(52, '2023-10-25 09:50:23.623472', '2023-10-25 09:50:23.623472', 409, '他们不要 我们需要啊😭😭😭', 34, NULL, NULL),
(53, '2023-10-25 09:53:36.978292', '2023-10-25 09:53:36.978292', 679, '学长我们是真的真的很需要 ！！', 34, NULL, NULL),
(54, '2023-10-25 10:13:56.332100', '2023-10-25 10:13:56.332100', 919, '学长/姐不要理小疯子了 我们真的需要', 34, NULL, NULL),
(55, '2023-10-25 10:22:56.079469', '2023-10-25 10:22:56.079469', 347, '我们需要你😭😭😭', 34, NULL, NULL),
(56, '2023-10-25 10:34:49.416153', '2023-10-25 10:34:49.416153', 1032, '收费  支持收费  支持', 34, NULL, NULL),
(57, '2023-10-25 11:01:11.522015', '2023-10-25 11:01:11.522015', 1532, '学长别理他们我们真的很需要', 34, NULL, NULL),
(58, '2023-10-25 11:01:36.685603', '2023-10-25 11:01:36.685603', 1532, '吐槽的我真的服了，免费给他用还不知道珍惜', 34, NULL, NULL),
(59, '2023-10-25 11:02:27.167504', '2023-10-25 11:02:27.167504', 1532, '学长别生气了', NULL, 58, 1532),
(60, '2023-10-25 12:34:31.682581', '2023-10-25 12:34:31.682581', 603, '提灯者不必理会麻木不仁的人，因为他的身后', 34, NULL, NULL),
(61, '2023-10-25 12:34:49.549218', '2023-10-25 12:34:49.549218', 603, '有着无数追着光的人', NULL, 60, 603),
(62, '2023-10-25 14:03:22.518742', '2023-10-25 14:03:22.518742', 128, '我只能说我没有资格去吐槽', 34, NULL, NULL),
(63, '2023-10-25 15:13:33.656087', '2023-10-25 15:13:33.656087', 518, '求你了你不在我都不知道去哪里上课🙏', 34, NULL, NULL),
(64, '2023-10-25 19:19:01.277529', '2023-10-25 19:19:01.277529', 1609, '可以教教我吗？', 34, NULL, NULL),
(65, '2023-10-26 21:01:25.278301', '2023-10-26 21:01:25.278301', 968, '别整学长，咱孩子不懂事儿，别跟他一般见识', 34, NULL, NULL),
(66, '2023-10-28 23:57:48.546856', '2023-10-28 23:57:48.546856', 49, '真的非常需要，非常方便，感恩学长', 34, NULL, NULL),
(67, '2023-10-30 15:50:54.308114', '2023-10-30 15:50:54.308114', 249, '大学生很需要！', 34, NULL, NULL),
(68, '2023-10-30 22:55:33.551536', '2023-10-30 22:55:33.551536', 124, '支持收费', 34, NULL, NULL),
(69, '2023-11-06 00:12:10.011941', '2023-11-06 00:12:10.011941', 228, '支持学长', 34, NULL, NULL),
(70, '2023-11-07 11:39:44.661010', '2023-11-07 11:39:44.661010', 1770, '还搁那提灯者不必理会麻木不仁的人', 34, NULL, NULL),
(71, '2023-11-07 11:39:44.665339', '2023-11-07 11:39:44.665339', 1770, '还搁那提灯者不必理会麻木不仁的人', 34, NULL, NULL),
(72, '2023-11-07 11:39:44.811906', '2023-11-07 11:39:44.811906', 1770, '还搁那提灯者不必理会麻木不仁的人', 34, NULL, NULL),
(73, '2023-11-07 11:40:24.457251', '2023-11-07 11:40:24.457251', 1770, '你道德绑架你妈呢', 34, NULL, NULL),
(74, '2023-11-07 11:40:24.844145', '2023-11-07 11:40:24.844145', 1770, '你道德绑架你妈呢', 34, NULL, NULL),
(75, '2023-11-07 11:40:24.850949', '2023-11-07 11:40:24.850949', 1770, '你道德绑架你妈呢', 34, NULL, NULL),
(76, '2023-11-07 11:41:07.454170', '2023-11-07 11:41:07.454170', 1770, '自己戳给那嘿人用 让他嘴巴那么臭', 34, NULL, NULL),
(77, '2023-11-27 20:59:23.540432', '2023-11-27 20:59:23.540432', 2064, '学长超级棒❤️，不要理会那些阴沟老鼠', 34, NULL, NULL),
(78, '2023-11-30 20:38:35.299700', '2023-11-30 20:38:35.299700', 2108, '收费我都买 那些人纯纯白嫖🐶', 34, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `app_follows`
--

CREATE TABLE `app_follows` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `type` tinyint(4) NOT NULL COMMENT '关注类型 0:圈子 1:用户',
  `userId` int(11) NOT NULL COMMENT '用户ID',
  `followId` int(11) NOT NULL COMMENT '关注ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_follows`
--

INSERT INTO `app_follows` (`id`, `createTime`, `updateTime`, `type`, `userId`, `followId`) VALUES
(20, '2023-10-17 18:37:42.839383', '2023-10-17 18:37:42.839383', 0, 1, 1),
(21, '2023-10-17 19:16:57.901098', '2023-10-17 19:16:57.901098', 0, 124, 1),
(22, '2023-10-17 20:25:22.206894', '2023-10-17 20:25:22.206894', 0, 98, 1),
(23, '2023-10-24 13:28:31.917759', '2023-10-24 13:28:31.917759', 0, 96, 6),
(24, '2023-11-07 08:51:53.610539', '2023-11-07 08:51:53.610539', 0, 1770, 1),
(25, '2023-11-28 13:30:09.895210', '2023-11-28 13:30:09.895210', 0, 2107, 1);

-- --------------------------------------------------------

--
-- 表的结构 `app_menu`
--

CREATE TABLE `app_menu` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `icon` varchar(255) NOT NULL COMMENT '图标',
  `path` varchar(255) NOT NULL COMMENT '路径',
  `badge` varchar(255) DEFAULT NULL COMMENT '标签',
  `login` tinyint(4) NOT NULL DEFAULT '1' COMMENT '登录 0:无需登录 1:需要登录',
  `stuauth` tinyint(4) NOT NULL DEFAULT '1' COMMENT '认证 0:无需认证 1:需要认证',
  `vip` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员 0:普通 1：会员',
  `appId` varchar(255) DEFAULT NULL COMMENT '小程序ID',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `type` enum('nav','mp') NOT NULL DEFAULT 'nav' COMMENT '类型 nav:页面 mp:小程序',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1：启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_menu`
--

INSERT INTO `app_menu` (`id`, `createTime`, `updateTime`, `name`, `icon`, `path`, `badge`, `login`, `stuauth`, `vip`, `appId`, `sort`, `type`, `status`) VALUES
(1, '2022-09-14 17:32:54.000000', '2023-10-25 20:30:19.036000', '课表查询', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/3d04c901-d62a-48bc-83cf-0e0568262657_8361dc51-7b6f-46af-808f-d9bf86f4a018_838d695b-46f8-469e-833b-980f7c2f2bba_课程周期.png ', 'pages/course/index', '热', 1, 1, 0, 'wx5bd4f63845a1e6b3', 99, 'nav', 1),
(2, '2022-09-14 17:38:31.000000', '2023-10-25 14:39:36.551000', '成绩查询', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/6cceb61a-5bea-4178-96bc-80829940576d_c0f2b3a0-9b38-473f-8eab-625816e30528_557182f4-bd88-441f-818b-07c4a817fcad_成绩收集.png', 'pages/score/score', '', 1, 1, 0, NULL, 98, 'nav', 1),
(3, '2022-09-16 14:57:00.000000', '2023-09-06 18:09:53.443000', '空闲教室', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/5748a077-5061-4dc3-8309-4bd517b63a0e_78304a05-b52a-4dee-8e73-85d6f56028db_95c6e73c-ce89-48cb-a3ee-c361ab1fbbe7_81-办公楼.png', 'pages/room/index', NULL, 1, 1, 0, NULL, 97, 'nav', 0),
(4, '2022-09-16 14:59:38.000000', '2023-10-25 14:27:08.869000', '考试查询', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/216b5cbf-e7f6-4b1e-8e23-c64acf69c32c_e4dfd26e-b794-4013-ba35-ff8e8c1285cc_785aba83-6a1f-4b17-8cde-38be983504f0_考试.png', 'pages/exam/exam', NULL, 1, 1, 0, NULL, 96, 'nav', 1),
(5, '2022-09-16 15:00:28.000000', '2023-10-25 14:27:13.953000', '课程通知', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/30337905-d6e9-4eff-b333-b5369c6245f8_cf439a12-5310-4d88-b4a1-64a10b841494_9b8568b6-ada4-4453-9085-735cd80e7810_通知.png', 'pages/notify/notify', '', 1, 1, 0, NULL, 95, 'nav', 1);

-- --------------------------------------------------------

--
-- 表的结构 `app_notice`
--

CREATE TABLE `app_notice` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `label` varchar(255) NOT NULL COMMENT '公告内容',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态: 1:正常 2:禁用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_notice`
--

INSERT INTO `app_notice` (`id`, `createTime`, `updateTime`, `label`, `status`) VALUES
(1, '2022-09-14 17:57:04.000000', '2024-03-04 09:17:08.664000', '课表显示显示假期中，大家自行修改开学时间，不要再问我了，谢谢。', 1),
(2, '2022-09-20 01:01:09.000000', '2023-11-21 12:07:06.517000', '每天0:00 - 7:00学校服务器关闭，暂时无法使用', 1),
(3, '2022-09-21 18:21:55.000000', '2023-10-24 23:14:48.366000', '提示服务器异常，多试几次就行了，或者过5分钟后再试！', 0);

-- --------------------------------------------------------

--
-- 表的结构 `app_school`
--

CREATE TABLE `app_school` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `url` varchar(255) NOT NULL COMMENT 'URL',
  `icon` varchar(255) NOT NULL COMMENT '图片',
  `sysType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '系统 0:正方 1:其他',
  `loginType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '登录 0:默认 1:方式Ⅰ',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1:启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_school`
--

INSERT INTO `app_school` (`id`, `createTime`, `updateTime`, `name`, `url`, `icon`, `sysType`, `loginType`, `status`) VALUES
(1, '2022-10-29 09:09:56.687000', '2023-09-19 01:23:14.290016', '广西职业师范学院', 'https://jw.gxvnu.edu.cn/jwglxt', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/387c99c2-0c35-4abc-87f9-3bbbbf978038_%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20220915153131.jpg', 0, 0, 1),
(2, '2022-11-26 15:10:58.627000', '2023-10-17 14:09:19.313000', '南京工业大学浦江学院', 'https://jw.gxvnu.edu.cn/jwglxt', 'https://c-li.oss-cn-shenzhen.aliyuncs.com/app/2022-11-02/nj.webp', 0, 0, 0);

-- --------------------------------------------------------

--
-- 表的结构 `app_user`
--

CREATE TABLE `app_user` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `avatar` varchar(255) NOT NULL COMMENT '头像',
  `nickname` varchar(255) NOT NULL COMMENT '昵称',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别 0:未知 1:男 2:女',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机',
  `schoolId` int(11) DEFAULT NULL COMMENT '学校',
  `college` varchar(255) DEFAULT NULL COMMENT '学院',
  `class` varchar(255) DEFAULT NULL COMMENT '班级',
  `username` varchar(255) DEFAULT NULL COMMENT '学号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `expire` datetime DEFAULT NULL COMMENT '会员',
  `remind` tinyint(4) NOT NULL DEFAULT '0' COMMENT '提醒 0:关闭 1:开启',
  `openid` varchar(255) DEFAULT NULL COMMENT '唯一标识',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1：启用',
  `idCard` varchar(255) DEFAULT NULL COMMENT '身份证',
  `nation` varchar(255) DEFAULT NULL COMMENT '民族',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `major` varchar(255) DEFAULT NULL COMMENT '专业'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `app_user`
--

INSERT INTO `app_user` (`id`, `createTime`, `updateTime`, `avatar`, `nickname`, `name`, `sex`, `mobile`, `schoolId`, `college`, `class`, `username`, `password`, `expire`, `remind`, `openid`, `status`, `idCard`, `nation`, `birthday`, `major`) VALUES
(1, '2023-09-07 06:11:29.575559', '2024-03-19 06:51:17.000000', 'http://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/xcxy/1710802252563.jpg', '七年', '张三', 1, '18888888888', 1, '计算机与信息工程学院', '软件1班', '22055050333', '123456', NULL, 0, 'oabDj4oo1wQlQXlYmcz2ncvdfw0U', 1, '452727888888888888', '汉族', '2000-05-04', '软件技术'),

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_conf`
--

CREATE TABLE `base_sys_conf` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `cKey` varchar(255) NOT NULL COMMENT '配置键',
  `cValue` varchar(255) NOT NULL COMMENT '配置值'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_conf`
--

INSERT INTO `base_sys_conf` (`id`, `createTime`, `updateTime`, `cKey`, `cValue`) VALUES
(1, '2021-02-25 14:23:26.810981', '2021-02-25 14:23:26.810981', 'logKeep', '31'),
(2, '2021-02-25 14:23:26.810981', '2021-02-25 14:23:26.810981', 'recycleKeep', '31');

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_department`
--

CREATE TABLE `base_sys_department` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '部门名称',
  `parentId` bigint(20) DEFAULT NULL COMMENT '上级部门ID',
  `orderNum` int(11) NOT NULL DEFAULT '0' COMMENT '排序'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_department`
--

INSERT INTO `base_sys_department` (`id`, `createTime`, `updateTime`, `name`, `parentId`, `orderNum`) VALUES
(1, '2021-02-24 21:17:11.971397', '2023-03-07 00:39:53.000000', 'COOL', NULL, 0),
(11, '2021-02-26 14:17:06.690613', '2023-03-07 00:39:53.000000', '开发', 12, 2),
(12, '2021-02-26 14:17:11.576369', '2023-03-07 00:39:53.000000', '测试', 1, 1),
(13, '2021-02-26 14:28:59.685177', '2023-03-07 00:39:53.000000', '游客', 1, 3);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_log`
--

CREATE TABLE `base_sys_log` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `ipAddr` varchar(50) DEFAULT NULL COMMENT 'ip地址',
  `params` json DEFAULT NULL COMMENT '参数',
  `action` varchar(100) NOT NULL COMMENT '行为',
  `ip` varchar(255) DEFAULT NULL COMMENT 'ip'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_log`
--

INSERT INTO `base_sys_log` (`id`, `createTime`, `updateTime`, `userId`, `ipAddr`, `params`, `action`, `ip`) VALUES
(111672, '2024-03-09 00:12:30.439033', '2024-03-09 00:12:30.439033', NULL, '中国广西', '{}', '/api/app/banner/getBanner', '171.106.114.210'),
-- --------------------------------------------------------

--
-- 表的结构 `base_sys_menu`
--

CREATE TABLE `base_sys_menu` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `parentId` bigint(20) DEFAULT NULL COMMENT '父菜单ID',
  `name` varchar(255) NOT NULL COMMENT '菜单名称',
  `router` varchar(255) DEFAULT NULL COMMENT '菜单地址',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型 0-目录 1-菜单 2-按钮',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `orderNum` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `viewPath` varchar(255) DEFAULT NULL COMMENT '视图地址',
  `keepAlive` tinyint(4) NOT NULL DEFAULT '1' COMMENT '路由缓存',
  `isShow` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否显示'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_menu`
--

INSERT INTO `base_sys_menu` (`id`, `createTime`, `updateTime`, `parentId`, `name`, `router`, `perms`, `type`, `icon`, `orderNum`, `viewPath`, `keepAlive`, `isShow`) VALUES
(2, '2019-09-11 11:14:47.000000', '2023-09-06 09:48:44.853000', NULL, '系统管理', '/sys', NULL, 0, 'icon-system', 99, NULL, 1, 1),
(8, '1900-01-20 23:19:57.000000', '2021-03-08 22:59:12.000000', 27, '菜单列表', '/sys/menu', NULL, 1, 'icon-menu', 2, 'cool/modules/base/views/menu.vue', 1, 1),
(10, '1900-01-20 00:19:27.325000', '1900-01-20 00:19:27.325000', 8, '新增', NULL, 'base:sys:menu:add', 2, NULL, 1, NULL, 0, 1),
(11, '1900-01-20 00:19:51.101000', '1900-01-20 00:19:51.101000', 8, '删除', NULL, 'base:sys:menu:delete', 2, NULL, 2, NULL, 0, 1),
(13, '1900-01-20 00:20:19.341000', '1900-01-20 00:20:19.341000', 8, '查询', NULL, 'base:sys:menu:page,base:sys:menu:list,base:sys:menu:info', 2, NULL, 4, NULL, 0, 1),
(22, '2019-09-12 00:34:01.000000', '2023-02-17 16:14:37.299000', 27, '角色列表', '/sys/role', NULL, 1, 'icon-dept', 3, 'cool/modules/base/views/role.vue', 1, 1),
(23, '1900-01-20 00:34:23.459000', '1900-01-20 00:34:23.459000', 22, '新增', NULL, 'base:sys:role:add', 2, NULL, 1, NULL, 0, 1),
(24, '1900-01-20 00:34:40.523000', '1900-01-20 00:34:40.523000', 22, '删除', NULL, 'base:sys:role:delete', 2, NULL, 2, NULL, 0, 1),
(25, '1900-01-20 00:34:53.306000', '1900-01-20 00:34:53.306000', 22, '修改', NULL, 'base:sys:role:update', 2, NULL, 3, NULL, 0, 1),
(26, '1900-01-20 00:35:05.024000', '1900-01-20 00:35:05.024000', 22, '查询', NULL, 'base:sys:role:page,base:sys:role:list,base:sys:role:info', 2, NULL, 4, NULL, 0, 1),
(27, '2019-09-12 15:52:44.000000', '2019-09-15 22:11:56.000000', 2, '权限管理', NULL, NULL, 0, 'icon-auth', 1, NULL, 0, 1),
(29, '2019-09-12 17:35:51.000000', '2021-03-08 23:01:39.000000', 105, '请求日志', '/sys/log', NULL, 1, 'icon-log', 1, 'cool/modules/base/views/log.vue', 1, 1),
(30, '2019-09-12 17:37:03.000000', '2021-03-03 10:16:26.000000', 29, '权限', NULL, 'base:sys:log:page,base:sys:log:clear,base:sys:log:getKeep,base:sys:log:setKeep', 2, NULL, 1, NULL, 0, 1),
(59, '2019-11-18 16:50:27.000000', '2019-11-18 16:50:27.000000', 97, '部门列表', NULL, 'base:sys:department:list', 2, NULL, 0, NULL, 1, 1),
(60, '2019-11-18 16:50:45.000000', '2019-11-18 16:50:45.000000', 97, '新增部门', NULL, 'base:sys:department:add', 2, NULL, 0, NULL, 1, 1),
(61, '2019-11-18 16:50:59.000000', '2019-11-18 16:50:59.000000', 97, '更新部门', NULL, 'base:sys:department:update', 2, NULL, 0, NULL, 1, 1),
(62, '2019-11-18 16:51:13.000000', '2019-11-18 16:51:13.000000', 97, '删除部门', NULL, 'base:sys:department:delete', 2, NULL, 0, NULL, 1, 1),
(63, '2019-11-18 17:49:35.000000', '2019-11-18 17:49:35.000000', 97, '部门排序', NULL, 'base:sys:department:order', 2, NULL, 0, NULL, 1, 1),
(65, '2019-11-18 23:59:21.000000', '2019-11-18 23:59:21.000000', 97, '用户转移', NULL, 'base:sys:user:move', 2, NULL, 0, NULL, 1, 1),
(78, '2019-12-10 13:27:56.000000', '2023-02-17 16:05:06.071000', 2, '参数配置', NULL, NULL, 0, 'icon-params', 3, NULL, 1, 1),
(79, '1900-01-20 13:29:33.000000', '2021-03-08 23:01:48.000000', 78, '参数列表', '/sys/param', NULL, 1, 'icon-menu', 0, 'cool/modules/base/views/param.vue', 1, 1),
(80, '1900-01-20 13:29:50.146000', '1900-01-20 13:29:50.146000', 79, '新增', NULL, 'base:sys:param:add', 2, NULL, 0, NULL, 1, 1),
(81, '1900-01-20 13:30:10.030000', '1900-01-20 13:30:10.030000', 79, '修改', NULL, 'base:sys:param:info,base:sys:param:update', 2, NULL, 0, NULL, 1, 1),
(82, '1900-01-20 13:30:25.791000', '1900-01-20 13:30:25.791000', 79, '删除', NULL, 'base:sys:param:delete', 2, NULL, 0, NULL, 1, 1),
(83, '1900-01-20 13:30:40.469000', '1900-01-20 13:30:40.469000', 79, '查看', NULL, 'base:sys:param:page,base:sys:param:list,base:sys:param:info', 2, NULL, 0, NULL, 1, 1),
(84, '2020-07-25 16:21:30.000000', '2020-07-25 16:21:30.000000', NULL, '通用', NULL, NULL, 0, 'icon-radioboxfill', 99, NULL, 1, 0),
(85, '2020-07-25 16:22:14.000000', '2021-03-03 10:36:00.000000', 84, '图片上传', NULL, 'space:info:page,space:info:list,space:info:info,space:info:add,space:info:delete,space:info:update,space:type:page,space:type:list,space:type:info,space:type:add,space:type:delete,space:type:update', 2, NULL, 1, NULL, 1, 1),
(97, '1900-01-20 14:14:02.000000', '2023-02-28 15:51:30.854000', 27, '用户列表', '/sys/user', NULL, 1, 'icon-user', 0, 'modules/base/views/user/index.vue', 1, 1),
(98, '1900-01-20 14:14:13.528000', '1900-01-20 14:14:13.528000', 97, '新增', NULL, 'base:sys:user:add', 2, NULL, 0, NULL, 1, 1),
(99, '1900-01-20 14:14:22.823000', '1900-01-20 14:14:22.823000', 97, '删除', NULL, 'base:sys:user:delete', 2, NULL, 0, NULL, 1, 1),
(100, '1900-01-20 14:14:33.973000', '1900-01-20 14:14:33.973000', 97, '修改', NULL, 'base:sys:user:delete,base:sys:user:update', 2, NULL, 0, NULL, 1, 1),
(101, '2021-01-12 14:14:51.000000', '2021-01-12 14:14:51.000000', 97, '查询', NULL, 'base:sys:user:page,base:sys:user:list,base:sys:user:info', 2, NULL, 0, NULL, 1, 1),
(105, '2021-01-21 10:42:55.000000', '2023-02-17 16:05:19.312000', 2, '监控管理', NULL, NULL, 0, 'icon-monitor', 9, NULL, 1, 1),
(117, '2021-03-05 10:58:25.000000', '2023-09-06 09:49:56.164000', NULL, '任务管理', NULL, NULL, 0, 'icon-activity', 98, NULL, 1, 1),
(118, '2021-03-05 10:59:42.000000', '2023-02-14 14:05:48.454000', 117, '任务列表', '/task/list', NULL, 1, 'icon-menu', 0, 'modules/task/views/list.vue', 1, 1),
(119, '2021-03-05 11:00:00.000000', '2021-03-05 11:00:00.000000', 118, '权限', NULL, 'task:info:page,task:info:list,task:info:info,task:info:add,task:info:delete,task:info:update,task:info:stop,task:info:start,task:info:once,task:info:log', 2, NULL, 0, NULL, 1, 1),
(197, '2022-07-05 16:05:27.403000', '2023-09-20 16:34:35.096000', NULL, '字典管理', NULL, NULL, 0, 'icon-dict', 3, NULL, 1, 1),
(198, '2022-07-05 16:08:50.307000', '2022-07-05 16:14:13.196000', 197, '字典列表', '/dict/list', NULL, 1, 'icon-menu', 1, 'modules/dict/views/list.vue', 1, 1),
(199, '2022-07-05 16:08:50.748162', '2022-07-05 16:08:50.748162', 198, '删除', NULL, 'dict:info:delete', 2, NULL, 0, NULL, 1, 1),
(200, '2022-07-05 16:08:50.800623', '2022-07-05 16:08:50.800623', 198, '修改', NULL, 'dict:info:update,dict:info:info', 2, NULL, 0, NULL, 1, 1),
(201, '2022-07-05 16:08:50.859141', '2022-07-05 16:08:50.859141', 198, '获得字典数据', NULL, 'dict:info:data', 2, NULL, 0, NULL, 1, 1),
(202, '2022-07-05 16:08:50.916874', '2022-07-05 16:08:50.916874', 198, '单个信息', NULL, 'dict:info:info', 2, NULL, 0, NULL, 1, 1),
(203, '2022-07-05 16:08:50.972783', '2022-07-05 16:08:50.972783', 198, '列表查询', NULL, 'dict:info:list', 2, NULL, 0, NULL, 1, 1),
(204, '2022-07-05 16:08:51.030928', '2022-07-05 16:08:51.030928', 198, '分页查询', NULL, 'dict:info:page', 2, NULL, 0, NULL, 1, 1),
(205, '2022-07-05 16:08:51.087883', '2022-07-05 16:08:51.087883', 198, '新增', NULL, 'dict:info:add', 2, NULL, 0, NULL, 1, 1),
(206, '2022-07-06 10:41:26.503000', '2022-07-06 10:41:37.000000', 198, '组权限', NULL, 'dict:type:list,dict:type:update,dict:type:delete,dict:type:add', 2, NULL, 0, NULL, 1, 1),
(228, '2023-02-13 14:57:10.974000', '2023-09-06 18:08:40.016000', NULL, '数据管理', NULL, NULL, 0, 'icon-data', 96, NULL, 1, 0),
(229, '2023-02-13 14:57:47.855000', '2023-02-17 16:04:57.051000', 228, '数据回收站', '/recycle/data', NULL, 1, 'icon-delete', 1, 'modules/recycle/views/data.vue', 1, 1),
(230, '2023-02-13 14:57:48.293292', '2023-02-13 14:57:48.293292', 229, '恢复数据', NULL, 'recycle:data:restore', 2, NULL, 0, NULL, 1, 1),
(231, '2023-02-13 14:57:48.293292', '2023-02-13 14:57:48.293292', 229, '单个信息', NULL, 'recycle:data:info', 2, NULL, 0, NULL, 1, 1),
(232, '2023-02-13 14:57:48.293292', '2023-02-13 14:57:48.293292', 229, '分页查询', NULL, 'recycle:data:page', 2, NULL, 0, NULL, 1, 1),
(233, '2023-02-13 19:29:49.240000', '2023-09-06 09:43:00.390000', NULL, '物联管理', NULL, NULL, 0, 'icon-iot', 4, NULL, 1, 0),
(234, '2023-02-13 19:31:31.890000', '2023-02-19 14:53:36.538000', 233, 'MQTT', '/iot/device', NULL, 1, 'icon-device', 1, 'modules/iot/views/device.vue', 1, 1),
(235, '2023-02-13 19:32:58.637593', '2023-02-13 19:32:58.637593', 234, '删除', NULL, 'iot:device:delete', 2, NULL, 0, NULL, 1, 1),
(236, '2023-02-13 19:32:58.637593', '2023-02-13 19:32:58.637593', 234, '单个信息', NULL, 'iot:device:info', 2, NULL, 0, NULL, 1, 1),
(237, '2023-02-13 19:32:58.637593', '2023-02-13 19:32:58.637593', 234, '列表查询', NULL, 'iot:device:list', 2, NULL, 0, NULL, 1, 1),
(238, '2023-02-13 19:32:58.637593', '2023-02-13 19:32:58.637593', 234, '分页查询', NULL, 'iot:device:page', 2, NULL, 0, NULL, 1, 1),
(239, '2023-02-15 11:21:16.610000', '2023-09-06 18:08:50.672000', NULL, '文件管理', '/upload/list', NULL, 1, 'icon-log', 97, 'modules/upload/views/list.vue', 1, 0),
(240, '2023-02-15 14:34:46.552000', '2023-09-06 09:42:54.812000', NULL, '函数开发', NULL, NULL, 0, 'icon-fx', 6, NULL, 1, 0),
(241, '2023-02-15 14:35:31.765000', '2023-02-17 16:04:36.963000', 240, '云数据库', '/cloud/db', NULL, 1, 'icon-db', 1, 'modules/cloud/views/db.vue', 1, 1),
(242, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '初始化Entity', NULL, 'cloud:db:initEntity', 2, NULL, 0, NULL, 1, 1),
(243, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '删除', NULL, 'cloud:db:delete', 2, NULL, 0, NULL, 1, 1),
(244, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '修改', NULL, 'cloud:db:update,cloud:db:info', 2, NULL, 0, NULL, 1, 1),
(245, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '数据操作测试', NULL, 'cloud:db:data', 2, NULL, 0, NULL, 1, 1),
(246, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '单个信息', NULL, 'cloud:db:info', 2, NULL, 0, NULL, 1, 1),
(247, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '列表查询', NULL, 'cloud:db:list', 2, NULL, 0, NULL, 1, 1),
(248, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '分页查询', NULL, 'cloud:db:page', 2, NULL, 0, NULL, 1, 1),
(249, '2023-02-15 14:33:24.192728', '2023-02-15 14:33:24.192728', 241, '新增', NULL, 'cloud:db:add', 2, NULL, 0, NULL, 1, 1),
(250, '2023-02-15 15:17:10.524000', '2023-02-15 15:17:10.524000', 240, '云函数', '/cloud/func/info', NULL, 1, 'icon-menu', 2, 'modules/cloud/views/func/info.vue', 1, 1),
(251, '2023-02-15 15:15:02.900934', '2023-02-28 16:08:47.978000', 250, '调用云函数', NULL, 'cloud:func:info:invoke', 2, NULL, 98, NULL, 1, 1),
(252, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '删除', NULL, 'cloud:func:info:delete', 2, NULL, 0, NULL, 1, 1),
(253, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '修改', NULL, 'cloud:func:info:update,cloud:func:info:info', 2, NULL, 0, NULL, 1, 1),
(254, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '单个信息', NULL, 'cloud:func:info:info', 2, NULL, 0, NULL, 1, 1),
(255, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '列表查询', NULL, 'cloud:func:info:list', 2, NULL, 0, NULL, 1, 1),
(256, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '分页查询', NULL, 'cloud:func:info:page', 2, NULL, 0, NULL, 1, 1),
(257, '2023-02-15 15:15:02.900934', '2023-02-15 15:15:02.900934', 250, '新增', NULL, 'cloud:func:info:add', 2, NULL, 0, NULL, 1, 1),
(259, '2023-02-17 15:25:20.762000', '2023-02-17 15:25:20.762000', 234, '修改', NULL, 'iot:device:info,iot:device:update', 2, NULL, 0, NULL, 1, 1),
(260, '2023-02-17 16:26:55.842000', '2023-09-06 09:42:41.576000', NULL, '页面设计', '/design/page', NULL, 1, 'icon-design', 7, 'modules/design/views/page.vue', 1, 0),
(261, '2023-02-20 00:12:20.783000', '2023-02-20 00:12:20.783000', 234, '新增', NULL, 'iot:device:add', 2, NULL, 0, NULL, 1, 1),
(262, '2023-02-20 00:32:45.656000', '2023-02-28 16:08:42.999000', 250, '云函数开发', NULL, 'cloud:func:info:info,cloud:func:info:update,cloud:func:info:invoke', 2, NULL, 99, NULL, 1, 1),
(263, '2023-02-20 00:33:17.789000', '2023-02-20 00:33:17.789000', 250, '查看日志', NULL, 'cloud:func:log:page', 2, NULL, 0, NULL, 1, 1),
(446, '2023-03-06 22:50:24.125000', '2023-03-06 22:50:24.125000', 8, '参数', '/test/aa', NULL, 1, 'icon-goods', 0, 'modules/base/views/info.vue', 1, 1),
(447, '2023-03-07 10:26:51.746000', '2023-10-17 14:08:45.621000', NULL, '工作台', '/', NULL, 1, 'icon-workbench', 0, 'modules/base/views/dashboard.vue', 1, 1),
(448, '2023-03-07 10:27:21.084000', '2023-03-07 10:27:21.084000', 447, '组件预览', '/demo', NULL, 1, 'icon-favor', 1, 'modules/demo/views/demo.vue', 1, 1),
(449, '2023-03-07 10:27:54.079000', '2023-03-07 10:27:54.079000', 447, '组件库', NULL, NULL, 0, 'icon-common', 2, NULL, 1, 1),
(450, '2023-03-07 10:28:17.692000', '2023-03-07 10:28:17.692000', 449, 'crud 示例', '/demo/crud', NULL, 1, 'icon-favor', 1, 'modules/demo/views/crud.vue', 1, 1),
(451, '2023-03-07 10:28:44.322000', '2023-03-07 10:28:44.322000', 449, '编辑器', '/demo/editor', NULL, 1, 'icon-favor', 2, 'modules/demo/views/editor.vue', 1, 1),
(452, '2023-03-07 10:29:06.344000', '2023-03-07 10:29:06.344000', 449, '文件上传', '/demo/upload', NULL, 1, 'icon-favor', 3, 'modules/demo/views/upload.vue', 1, 1),
(453, '2023-03-15 10:38:43.677000', '2023-03-15 10:38:43.677000', 8, '编辑', NULL, 'base:sys:menu:info,base:sys:menu:update', 2, NULL, 0, NULL, 1, 1),
(462, '2023-09-06 11:23:49.526000', '2023-09-20 16:00:53.781000', 469, '轮播管理', '/app/banner', NULL, 1, 'icon-pic', 0, 'modules/app/views/banner.vue', 1, 1),
(463, '2023-09-06 03:23:49.582337', '2023-09-06 14:59:43.768000', 462, '删除', NULL, 'app:banner:delete', 2, NULL, 0, NULL, 1, 1),
(464, '2023-09-06 03:23:49.585656', '2023-09-06 14:59:58.960000', 462, '修改', NULL, 'app:banner:info,app:banner:update', 2, NULL, 0, NULL, 1, 1),
(465, '2023-09-06 03:23:49.590973', '2023-09-06 15:00:11.600000', 462, '单个信息', NULL, 'app:banner:info', 2, NULL, 0, NULL, 1, 1),
(466, '2023-09-06 03:23:49.595444', '2023-09-06 15:00:21.667000', 462, '列表查询', NULL, 'app:banner:list', 2, NULL, 0, NULL, 1, 1),
(467, '2023-09-06 03:23:49.598420', '2023-09-06 15:00:30.864000', 462, '分页查询', NULL, 'app:banner:page', 2, NULL, 0, NULL, 1, 1),
(468, '2023-09-06 03:23:49.601180', '2023-09-06 15:00:39.570000', 462, '新增', NULL, 'app:banner:add', 2, NULL, 0, NULL, 1, 1),
(469, '2023-09-06 14:55:12.738000', '2023-09-06 18:08:58.372000', NULL, '应用管理', NULL, NULL, 0, 'icon-phone', 95, NULL, 1, 1),
(470, '2023-09-06 15:24:07.910000', '2023-09-06 15:24:07.910000', 469, '导航菜单', '/app/menu', NULL, 1, 'icon-workbench', 0, 'modules/app/views/menu.vue', 1, 1),
(471, '2023-09-06 07:24:07.965501', '2023-09-06 07:24:07.965501', 470, '删除', NULL, 'app:menu:delete', 2, NULL, 0, NULL, 1, 1),
(472, '2023-09-06 07:24:07.970342', '2023-09-06 07:24:07.970342', 470, '修改', NULL, 'app:menu:update,app:menu:info', 2, NULL, 0, NULL, 1, 1),
(473, '2023-09-06 07:24:07.973754', '2023-09-06 07:24:07.973754', 470, '单个信息', NULL, 'app:menu:info', 2, NULL, 0, NULL, 1, 1),
(474, '2023-09-06 07:24:07.978552', '2023-09-06 07:24:07.978552', 470, '列表查询', NULL, 'app:menu:list', 2, NULL, 0, NULL, 1, 1),
(475, '2023-09-06 07:24:07.983733', '2023-09-06 07:24:07.983733', 470, '分页查询', NULL, 'app:menu:page', 2, NULL, 0, NULL, 1, 1),
(476, '2023-09-06 07:24:07.987362', '2023-09-06 07:24:07.987362', 470, '新增', NULL, 'app:menu:add', 2, NULL, 0, NULL, 1, 1),
(484, '2023-09-06 17:46:19.742000', '2023-09-06 17:46:48.793000', 469, '用户管理', '/app/user', NULL, 1, 'icon-user', 0, 'modules/app/views/user.vue', 1, 1),
(485, '2023-09-06 09:46:19.817172', '2023-09-06 09:46:19.817172', 484, '删除', NULL, 'app:user:delete', 2, NULL, 0, NULL, 1, 1),
(486, '2023-09-06 09:46:19.822623', '2023-09-06 09:46:19.822623', 484, '修改', NULL, 'app:user:update,app:user:info', 2, NULL, 0, NULL, 1, 1),
(487, '2023-09-06 09:46:19.826401', '2023-09-06 09:46:19.826401', 484, '单个信息', NULL, 'app:user:info', 2, NULL, 0, NULL, 1, 1),
(488, '2023-09-06 09:46:19.829963', '2023-09-06 09:46:19.829963', 484, '列表查询', NULL, 'app:user:list', 2, NULL, 0, NULL, 1, 1),
(489, '2023-09-06 09:46:19.832857', '2023-09-06 09:46:19.832857', 484, '分页查询', NULL, 'app:user:page', 2, NULL, 0, NULL, 1, 1),
(490, '2023-09-06 09:46:19.838402', '2023-09-06 09:46:19.838402', 484, '新增', NULL, 'app:user:add', 2, NULL, 0, NULL, 1, 1),
(491, '2023-09-06 17:53:27.872000', '2023-09-06 17:53:27.872000', 469, '学校管理', '/app/school', NULL, 1, 'icon-map', 0, 'modules/app/views/school.vue', 1, 1),
(492, '2023-09-06 09:53:27.935960', '2023-09-06 09:53:27.935960', 491, '删除', NULL, 'app:school:delete', 2, NULL, 0, NULL, 1, 1),
(493, '2023-09-06 09:53:27.939883', '2023-09-06 09:53:27.939883', 491, '修改', NULL, 'app:school:update,app:school:info', 2, NULL, 0, NULL, 1, 1),
(494, '2023-09-06 09:53:27.943891', '2023-09-06 09:53:27.943891', 491, '单个信息', NULL, 'app:school:info', 2, NULL, 0, NULL, 1, 1),
(495, '2023-09-06 09:53:27.946646', '2023-09-06 09:53:27.946646', 491, '列表查询', NULL, 'app:school:list', 2, NULL, 0, NULL, 1, 1),
(496, '2023-09-06 09:53:27.949063', '2023-09-06 09:53:27.949063', 491, '分页查询', NULL, 'app:school:page', 2, NULL, 0, NULL, 1, 1),
(497, '2023-09-06 09:53:27.953485', '2023-09-06 09:53:27.953485', 491, '新增', NULL, 'app:school:add', 2, NULL, 0, NULL, 1, 1),
(498, '2023-09-06 18:03:03.292000', '2023-09-06 18:03:03.292000', 469, '公告管理', '/app/notice', NULL, 1, 'icon-new', 0, 'modules/app/views/notice.vue', 1, 1),
(499, '2023-09-06 10:03:03.343765', '2023-09-06 10:03:03.343765', 498, '删除', NULL, 'app:notice:delete', 2, NULL, 0, NULL, 1, 1),
(500, '2023-09-06 10:03:03.350362', '2023-09-06 10:03:03.350362', 498, '修改', NULL, 'app:notice:update,app:notice:info', 2, NULL, 0, NULL, 1, 1),
(501, '2023-09-06 10:03:03.353824', '2023-09-06 10:03:03.353824', 498, '单个信息', NULL, 'app:notice:info', 2, NULL, 0, NULL, 1, 1),
(502, '2023-09-06 10:03:03.356899', '2023-09-06 10:03:03.356899', 498, '列表查询', NULL, 'app:notice:list', 2, NULL, 0, NULL, 1, 1),
(503, '2023-09-06 10:03:03.359961', '2023-09-06 10:03:03.359961', 498, '分页查询', NULL, 'app:notice:page', 2, NULL, 0, NULL, 1, 1),
(504, '2023-09-06 10:03:03.366029', '2023-09-06 10:03:03.366029', 498, '新增', NULL, 'app:notice:add', 2, NULL, 0, NULL, 1, 1),
(512, '2023-09-20 16:09:42.276000', '2023-09-20 16:09:42.276000', 469, '圈子管理', '/app/circle', NULL, 1, 'icon-discover', 0, 'modules/app/views/circle.vue', 1, 1),
(513, '2023-09-20 08:09:42.320937', '2023-09-20 08:09:42.320937', 512, '删除', NULL, 'app:circle:delete', 2, NULL, 0, NULL, 1, 1),
(514, '2023-09-20 08:09:42.326824', '2023-09-20 08:09:42.326824', 512, '修改', NULL, 'app:circle:update,app:circle:info', 2, NULL, 0, NULL, 1, 1),
(515, '2023-09-20 08:09:42.330194', '2023-09-20 08:09:42.330194', 512, '单个信息', NULL, 'app:circle:info', 2, NULL, 0, NULL, 1, 1),
(516, '2023-09-20 08:09:42.332818', '2023-09-20 08:09:42.332818', 512, '列表查询', NULL, 'app:circle:list', 2, NULL, 0, NULL, 1, 1),
(517, '2023-09-20 08:09:42.335364', '2023-09-20 08:09:42.335364', 512, '分页查询', NULL, 'app:circle:page', 2, NULL, 0, NULL, 1, 1),
(518, '2023-09-20 08:09:42.338566', '2023-09-20 08:09:42.338566', 512, '新增', NULL, 'app:circle:add', 2, NULL, 0, NULL, 1, 1),
(519, '2023-09-24 15:25:41.482000', '2023-09-24 15:25:41.482000', 469, '文章管理', '/app/articles', NULL, 1, 'icon-discover', 0, 'modules/app/views/articles.vue', 1, 1),
(520, '2023-09-24 07:25:41.580370', '2023-09-24 07:25:41.580370', 519, '删除', NULL, 'app:articles:delete', 2, NULL, 0, NULL, 1, 1),
(521, '2023-09-24 07:25:41.584312', '2023-09-24 07:25:41.584312', 519, '修改', NULL, 'app:articles:update,app:articles:info', 2, NULL, 0, NULL, 1, 1),
(522, '2023-09-24 07:25:41.587542', '2023-09-24 07:25:41.587542', 519, '单个信息', NULL, 'app:articles:info', 2, NULL, 0, NULL, 1, 1),
(523, '2023-09-24 07:25:41.591637', '2023-09-24 07:25:41.591637', 519, '列表查询', NULL, 'app:articles:list', 2, NULL, 0, NULL, 1, 1),
(524, '2023-09-24 07:25:41.596997', '2023-09-24 07:25:41.596997', 519, '分页查询', NULL, 'app:articles:page', 2, NULL, 0, NULL, 1, 1),
(525, '2023-09-24 07:25:41.600449', '2023-09-24 07:25:41.600449', 519, '新增', NULL, 'app:articles:add', 2, NULL, 0, NULL, 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_param`
--

CREATE TABLE `base_sys_param` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `keyName` varchar(255) NOT NULL COMMENT '键',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `data` text NOT NULL COMMENT '数据',
  `dataType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据类型 0-字符串 1-富文本 2-文件 ',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_param`
--

INSERT INTO `base_sys_param` (`id`, `createTime`, `updateTime`, `keyName`, `name`, `data`, `dataType`, `remark`) VALUES
(1, '2021-02-26 13:53:05.000000', '2023-05-31 10:43:23.312000', 'rich', '富文本参数', '<h3><strong>这是一个富文本</strong></h3><p>xxx</p><p>xxxxxxxxxx</p><p><br></p>', 1, NULL),
(2, '2021-02-26 13:53:18.000000', '2023-05-30 18:46:28.282000', 'json', 'JSON参数', '{\n  \"code\": 111233\n}', 0, NULL),
(6, '2023-05-30 18:48:25.371000', '2023-05-31 10:44:25.612000', 'file', '文件', '', 2, NULL),
(8, '2023-05-31 10:07:53.295000', '2023-05-31 10:46:27.960000', 'text', '测试', '这是一段字符串', 0, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_role`
--

CREATE TABLE `base_sys_role` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` varchar(255) NOT NULL COMMENT '用户ID',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `label` varchar(50) DEFAULT NULL COMMENT '角色标签',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `relevance` int(11) NOT NULL DEFAULT '1' COMMENT '数据权限是否关联上下级',
  `menuIdList` json NOT NULL COMMENT '菜单权限',
  `departmentIdList` json NOT NULL COMMENT '部门权限'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_role`
--

INSERT INTO `base_sys_role` (`id`, `createTime`, `updateTime`, `userId`, `name`, `label`, `remark`, `relevance`, `menuIdList`, `departmentIdList`) VALUES
(1, '2021-02-24 21:18:39.682358', '2021-02-24 21:18:39.682358', '1', '超管', 'admin', '最高权限的角色', 1, 'null', 'null'),
(10, '2021-02-26 14:15:38.000000', '2021-02-26 14:15:38.000000', '1', '系统管理员', 'admin-sys', NULL, 1, 'null', 'null'),
(11, '2021-02-26 14:16:49.044744', '2021-02-26 14:16:49.044744', '1', '游客', 'visitor', NULL, 0, 'null', 'null'),
(12, '2021-02-26 14:26:51.000000', '2021-02-26 14:32:35.000000', '1', '开发', 'dev', NULL, 0, 'null', 'null'),
(13, '2021-02-26 14:27:58.000000', '2023-02-20 11:01:16.995000', '1', '测试', 'test', NULL, 0, 'null', 'null');

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_role_department`
--

CREATE TABLE `base_sys_role_department` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `roleId` bigint(20) NOT NULL COMMENT '角色ID',
  `departmentId` bigint(20) NOT NULL COMMENT '部门ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_role_department`
--

INSERT INTO `base_sys_role_department` (`id`, `createTime`, `updateTime`, `roleId`, `departmentId`) VALUES
(1, '2021-02-26 12:00:23.787939', '2021-02-26 12:00:23.787939', 8, 4),
(2, '2021-02-26 12:01:11.525205', '2021-02-26 12:01:11.525205', 9, 1),
(3, '2021-02-26 12:01:11.624266', '2021-02-26 12:01:11.624266', 9, 4),
(4, '2021-02-26 12:01:11.721894', '2021-02-26 12:01:11.721894', 9, 5),
(5, '2021-02-26 12:01:11.823342', '2021-02-26 12:01:11.823342', 9, 8),
(6, '2021-02-26 12:01:11.922873', '2021-02-26 12:01:11.922873', 9, 9),
(23, '2021-02-26 14:32:40.354669', '2021-02-26 14:32:40.354669', 12, 11),
(25, '2021-02-26 14:32:59.726608', '2021-02-26 14:32:59.726608', 10, 1),
(28, '2023-02-20 11:01:23.152883', '2023-02-20 11:01:23.152883', 13, 12);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_role_menu`
--

CREATE TABLE `base_sys_role_menu` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `roleId` bigint(20) NOT NULL COMMENT '角色ID',
  `menuId` bigint(20) NOT NULL COMMENT '菜单ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_role_menu`
--

INSERT INTO `base_sys_role_menu` (`id`, `createTime`, `updateTime`, `roleId`, `menuId`) VALUES
(1, '2021-02-26 12:00:18.240154', '2021-02-26 12:00:18.240154', 8, 1),
(2, '2021-02-26 12:00:18.342131', '2021-02-26 12:00:18.342131', 8, 96),
(3, '2021-02-26 12:00:18.444143', '2021-02-26 12:00:18.444143', 8, 45),
(4, '2021-02-26 12:00:18.545490', '2021-02-26 12:00:18.545490', 8, 43),
(5, '2021-02-26 12:00:18.649626', '2021-02-26 12:00:18.649626', 8, 49),
(6, '2021-02-26 12:00:18.752369', '2021-02-26 12:00:18.752369', 8, 86),
(7, '2021-02-26 12:00:18.856023', '2021-02-26 12:00:18.856023', 8, 2),
(8, '2021-02-26 12:00:18.956131', '2021-02-26 12:00:18.956131', 8, 27),
(9, '2021-02-26 12:00:19.071490', '2021-02-26 12:00:19.071490', 8, 97),
(10, '2021-02-26 12:00:19.171745', '2021-02-26 12:00:19.171745', 8, 59),
(11, '2021-02-26 12:00:19.274495', '2021-02-26 12:00:19.274495', 8, 60),
(12, '2021-02-26 12:00:19.374610', '2021-02-26 12:00:19.374610', 8, 61),
(13, '2021-02-26 12:00:19.474750', '2021-02-26 12:00:19.474750', 8, 62),
(14, '2021-02-26 12:00:19.573369', '2021-02-26 12:00:19.573369', 8, 63),
(15, '2021-02-26 12:00:19.674242', '2021-02-26 12:00:19.674242', 8, 65),
(16, '2021-02-26 12:00:19.772886', '2021-02-26 12:00:19.772886', 8, 98),
(17, '2021-02-26 12:00:19.874134', '2021-02-26 12:00:19.874134', 8, 99),
(18, '2021-02-26 12:00:19.972728', '2021-02-26 12:00:19.972728', 8, 100),
(19, '2021-02-26 12:00:20.085877', '2021-02-26 12:00:20.085877', 8, 101),
(20, '2021-02-26 12:00:20.192887', '2021-02-26 12:00:20.192887', 8, 8),
(21, '2021-02-26 12:00:20.293747', '2021-02-26 12:00:20.293747', 8, 10),
(22, '2021-02-26 12:00:20.393491', '2021-02-26 12:00:20.393491', 8, 11),
(23, '2021-02-26 12:00:20.495110', '2021-02-26 12:00:20.495110', 8, 12),
(24, '2021-02-26 12:00:20.594083', '2021-02-26 12:00:20.594083', 8, 13),
(25, '2021-02-26 12:00:20.695727', '2021-02-26 12:00:20.695727', 8, 22),
(26, '2021-02-26 12:00:20.794729', '2021-02-26 12:00:20.794729', 8, 23),
(27, '2021-02-26 12:00:20.895601', '2021-02-26 12:00:20.895601', 8, 24),
(28, '2021-02-26 12:00:20.994972', '2021-02-26 12:00:20.994972', 8, 25),
(29, '2021-02-26 12:00:21.110384', '2021-02-26 12:00:21.110384', 8, 26),
(30, '2021-02-26 12:00:21.210970', '2021-02-26 12:00:21.210970', 8, 69),
(31, '2021-02-26 12:00:21.311852', '2021-02-26 12:00:21.311852', 8, 70),
(32, '2021-02-26 12:00:21.411591', '2021-02-26 12:00:21.411591', 8, 71),
(33, '2021-02-26 12:00:21.513584', '2021-02-26 12:00:21.513584', 8, 72),
(34, '2021-02-26 12:00:21.612212', '2021-02-26 12:00:21.612212', 8, 73),
(35, '2021-02-26 12:00:21.712720', '2021-02-26 12:00:21.712720', 8, 74),
(36, '2021-02-26 12:00:21.812839', '2021-02-26 12:00:21.812839', 8, 75),
(37, '2021-02-26 12:00:21.913321', '2021-02-26 12:00:21.913321', 8, 76),
(38, '2021-02-26 12:00:22.013970', '2021-02-26 12:00:22.013970', 8, 77),
(39, '2021-02-26 12:00:22.144879', '2021-02-26 12:00:22.144879', 8, 78),
(40, '2021-02-26 12:00:22.246707', '2021-02-26 12:00:22.246707', 8, 79),
(41, '2021-02-26 12:00:22.347579', '2021-02-26 12:00:22.347579', 8, 80),
(42, '2021-02-26 12:00:22.446947', '2021-02-26 12:00:22.446947', 8, 81),
(43, '2021-02-26 12:00:22.547082', '2021-02-26 12:00:22.547082', 8, 82),
(44, '2021-02-26 12:00:22.647197', '2021-02-26 12:00:22.647197', 8, 83),
(45, '2021-02-26 12:00:22.748089', '2021-02-26 12:00:22.748089', 8, 105),
(46, '2021-02-26 12:00:22.847814', '2021-02-26 12:00:22.847814', 8, 102),
(47, '2021-02-26 12:00:22.949071', '2021-02-26 12:00:22.949071', 8, 103),
(48, '2021-02-26 12:00:23.047353', '2021-02-26 12:00:23.047353', 8, 29),
(49, '2021-02-26 12:00:23.147826', '2021-02-26 12:00:23.147826', 8, 30),
(50, '2021-02-26 12:00:23.246800', '2021-02-26 12:00:23.246800', 8, 47),
(51, '2021-02-26 12:00:23.349541', '2021-02-26 12:00:23.349541', 8, 48),
(52, '2021-02-26 12:00:23.463177', '2021-02-26 12:00:23.463177', 8, 84),
(53, '2021-02-26 12:00:23.564096', '2021-02-26 12:00:23.564096', 8, 90),
(54, '2021-02-26 12:00:23.663815', '2021-02-26 12:00:23.663815', 8, 85),
(55, '2021-02-26 12:01:05.971978', '2021-02-26 12:01:05.971978', 9, 1),
(56, '2021-02-26 12:01:06.085568', '2021-02-26 12:01:06.085568', 9, 96),
(57, '2021-02-26 12:01:06.198271', '2021-02-26 12:01:06.198271', 9, 45),
(58, '2021-02-26 12:01:06.309736', '2021-02-26 12:01:06.309736', 9, 43),
(59, '2021-02-26 12:01:06.410785', '2021-02-26 12:01:06.410785', 9, 49),
(60, '2021-02-26 12:01:06.510712', '2021-02-26 12:01:06.510712', 9, 86),
(61, '2021-02-26 12:01:06.612457', '2021-02-26 12:01:06.612457', 9, 2),
(62, '2021-02-26 12:01:06.710397', '2021-02-26 12:01:06.710397', 9, 27),
(63, '2021-02-26 12:01:06.809104', '2021-02-26 12:01:06.809104', 9, 97),
(64, '2021-02-26 12:01:06.907088', '2021-02-26 12:01:06.907088', 9, 59),
(65, '2021-02-26 12:01:07.009988', '2021-02-26 12:01:07.009988', 9, 60),
(66, '2021-02-26 12:01:07.122372', '2021-02-26 12:01:07.122372', 9, 61),
(67, '2021-02-26 12:01:07.223694', '2021-02-26 12:01:07.223694', 9, 62),
(68, '2021-02-26 12:01:07.325022', '2021-02-26 12:01:07.325022', 9, 63),
(69, '2021-02-26 12:01:07.425209', '2021-02-26 12:01:07.425209', 9, 65),
(70, '2021-02-26 12:01:07.522081', '2021-02-26 12:01:07.522081', 9, 98),
(71, '2021-02-26 12:01:07.622775', '2021-02-26 12:01:07.622775', 9, 99),
(72, '2021-02-26 12:01:07.721181', '2021-02-26 12:01:07.721181', 9, 100),
(73, '2021-02-26 12:01:07.819589', '2021-02-26 12:01:07.819589', 9, 101),
(74, '2021-02-26 12:01:07.920497', '2021-02-26 12:01:07.920497', 9, 8),
(75, '2021-02-26 12:01:08.018875', '2021-02-26 12:01:08.018875', 9, 10),
(76, '2021-02-26 12:01:08.135192', '2021-02-26 12:01:08.135192', 9, 11),
(77, '2021-02-26 12:01:08.246405', '2021-02-26 12:01:08.246405', 9, 12),
(78, '2021-02-26 12:01:08.346661', '2021-02-26 12:01:08.346661', 9, 13),
(79, '2021-02-26 12:01:08.448436', '2021-02-26 12:01:08.448436', 9, 22),
(80, '2021-02-26 12:01:08.547496', '2021-02-26 12:01:08.547496', 9, 23),
(81, '2021-02-26 12:01:08.648457', '2021-02-26 12:01:08.648457', 9, 24),
(82, '2021-02-26 12:01:08.750564', '2021-02-26 12:01:08.750564', 9, 25),
(83, '2021-02-26 12:01:08.851783', '2021-02-26 12:01:08.851783', 9, 26),
(84, '2021-02-26 12:01:08.950898', '2021-02-26 12:01:08.950898', 9, 69),
(85, '2021-02-26 12:01:09.061982', '2021-02-26 12:01:09.061982', 9, 70),
(86, '2021-02-26 12:01:09.165258', '2021-02-26 12:01:09.165258', 9, 71),
(87, '2021-02-26 12:01:09.266177', '2021-02-26 12:01:09.266177', 9, 72),
(88, '2021-02-26 12:01:09.366427', '2021-02-26 12:01:09.366427', 9, 73),
(89, '2021-02-26 12:01:09.467877', '2021-02-26 12:01:09.467877', 9, 74),
(90, '2021-02-26 12:01:09.568526', '2021-02-26 12:01:09.568526', 9, 75),
(91, '2021-02-26 12:01:09.668052', '2021-02-26 12:01:09.668052', 9, 76),
(92, '2021-02-26 12:01:09.766367', '2021-02-26 12:01:09.766367', 9, 77),
(93, '2021-02-26 12:01:09.866170', '2021-02-26 12:01:09.866170', 9, 78),
(94, '2021-02-26 12:01:09.963037', '2021-02-26 12:01:09.963037', 9, 79),
(95, '2021-02-26 12:01:10.082046', '2021-02-26 12:01:10.082046', 9, 80),
(96, '2021-02-26 12:01:10.185024', '2021-02-26 12:01:10.185024', 9, 81),
(97, '2021-02-26 12:01:10.283787', '2021-02-26 12:01:10.283787', 9, 82),
(98, '2021-02-26 12:01:10.382883', '2021-02-26 12:01:10.382883', 9, 83),
(99, '2021-02-26 12:01:10.481150', '2021-02-26 12:01:10.481150', 9, 105),
(100, '2021-02-26 12:01:10.579579', '2021-02-26 12:01:10.579579', 9, 102),
(101, '2021-02-26 12:01:10.679489', '2021-02-26 12:01:10.679489', 9, 103),
(102, '2021-02-26 12:01:10.777496', '2021-02-26 12:01:10.777496', 9, 29),
(103, '2021-02-26 12:01:10.878292', '2021-02-26 12:01:10.878292', 9, 30),
(104, '2021-02-26 12:01:10.977354', '2021-02-26 12:01:10.977354', 9, 47),
(105, '2021-02-26 12:01:11.097786', '2021-02-26 12:01:11.097786', 9, 48),
(106, '2021-02-26 12:01:11.201390', '2021-02-26 12:01:11.201390', 9, 84),
(107, '2021-02-26 12:01:11.302120', '2021-02-26 12:01:11.302120', 9, 90),
(108, '2021-02-26 12:01:11.402751', '2021-02-26 12:01:11.402751', 9, 85),
(161, '2021-02-26 14:16:49.162546', '2021-02-26 14:16:49.162546', 11, 1),
(162, '2021-02-26 14:16:49.257677', '2021-02-26 14:16:49.257677', 11, 96),
(163, '2021-02-26 14:16:49.356225', '2021-02-26 14:16:49.356225', 11, 45),
(164, '2021-02-26 14:16:49.450708', '2021-02-26 14:16:49.450708', 11, 43),
(165, '2021-02-26 14:16:49.543794', '2021-02-26 14:16:49.543794', 11, 49),
(166, '2021-02-26 14:16:49.636496', '2021-02-26 14:16:49.636496', 11, 86),
(167, '2021-02-26 14:16:49.728634', '2021-02-26 14:16:49.728634', 11, 47),
(168, '2021-02-26 14:16:49.824754', '2021-02-26 14:16:49.824754', 11, 48),
(169, '2021-02-26 14:16:49.919329', '2021-02-26 14:16:49.919329', 11, 85),
(170, '2021-02-26 14:16:50.015239', '2021-02-26 14:16:50.015239', 11, 84),
(290, '2021-02-26 14:32:35.143867', '2021-02-26 14:32:35.143867', 12, 1),
(291, '2021-02-26 14:32:35.239965', '2021-02-26 14:32:35.239965', 12, 96),
(292, '2021-02-26 14:32:35.336398', '2021-02-26 14:32:35.336398', 12, 45),
(293, '2021-02-26 14:32:35.435180', '2021-02-26 14:32:35.435180', 12, 43),
(294, '2021-02-26 14:32:35.528631', '2021-02-26 14:32:35.528631', 12, 49),
(295, '2021-02-26 14:32:35.623123', '2021-02-26 14:32:35.623123', 12, 86),
(296, '2021-02-26 14:32:35.718831', '2021-02-26 14:32:35.718831', 12, 2),
(297, '2021-02-26 14:32:35.812975', '2021-02-26 14:32:35.812975', 12, 27),
(298, '2021-02-26 14:32:35.904487', '2021-02-26 14:32:35.904487', 12, 97),
(299, '2021-02-26 14:32:35.998773', '2021-02-26 14:32:35.998773', 12, 59),
(300, '2021-02-26 14:32:36.107749', '2021-02-26 14:32:36.107749', 12, 60),
(301, '2021-02-26 14:32:36.213069', '2021-02-26 14:32:36.213069', 12, 61),
(302, '2021-02-26 14:32:36.308985', '2021-02-26 14:32:36.308985', 12, 62),
(303, '2021-02-26 14:32:36.404237', '2021-02-26 14:32:36.404237', 12, 63),
(304, '2021-02-26 14:32:36.499569', '2021-02-26 14:32:36.499569', 12, 65),
(305, '2021-02-26 14:32:36.593710', '2021-02-26 14:32:36.593710', 12, 98),
(306, '2021-02-26 14:32:36.685988', '2021-02-26 14:32:36.685988', 12, 99),
(307, '2021-02-26 14:32:36.778733', '2021-02-26 14:32:36.778733', 12, 100),
(308, '2021-02-26 14:32:36.874715', '2021-02-26 14:32:36.874715', 12, 101),
(309, '2021-02-26 14:32:36.973153', '2021-02-26 14:32:36.973153', 12, 8),
(310, '2021-02-26 14:32:37.082734', '2021-02-26 14:32:37.082734', 12, 10),
(311, '2021-02-26 14:32:37.176859', '2021-02-26 14:32:37.176859', 12, 11),
(312, '2021-02-26 14:32:37.271440', '2021-02-26 14:32:37.271440', 12, 12),
(313, '2021-02-26 14:32:37.365206', '2021-02-26 14:32:37.365206', 12, 13),
(314, '2021-02-26 14:32:37.457092', '2021-02-26 14:32:37.457092', 12, 22),
(315, '2021-02-26 14:32:37.549860', '2021-02-26 14:32:37.549860', 12, 23),
(316, '2021-02-26 14:32:37.645684', '2021-02-26 14:32:37.645684', 12, 24),
(317, '2021-02-26 14:32:37.743370', '2021-02-26 14:32:37.743370', 12, 25),
(318, '2021-02-26 14:32:37.837218', '2021-02-26 14:32:37.837218', 12, 26),
(319, '2021-02-26 14:32:37.930953', '2021-02-26 14:32:37.930953', 12, 69),
(320, '2021-02-26 14:32:38.031191', '2021-02-26 14:32:38.031191', 12, 70),
(321, '2021-02-26 14:32:38.130839', '2021-02-26 14:32:38.130839', 12, 71),
(322, '2021-02-26 14:32:38.229359', '2021-02-26 14:32:38.229359', 12, 72),
(323, '2021-02-26 14:32:38.323868', '2021-02-26 14:32:38.323868', 12, 73),
(324, '2021-02-26 14:32:38.415194', '2021-02-26 14:32:38.415194', 12, 74),
(325, '2021-02-26 14:32:38.505597', '2021-02-26 14:32:38.505597', 12, 75),
(326, '2021-02-26 14:32:38.600426', '2021-02-26 14:32:38.600426', 12, 76),
(327, '2021-02-26 14:32:38.698676', '2021-02-26 14:32:38.698676', 12, 77),
(328, '2021-02-26 14:32:38.793832', '2021-02-26 14:32:38.793832', 12, 78),
(329, '2021-02-26 14:32:38.889203', '2021-02-26 14:32:38.889203', 12, 79),
(330, '2021-02-26 14:32:38.985851', '2021-02-26 14:32:38.985851', 12, 80),
(331, '2021-02-26 14:32:39.092110', '2021-02-26 14:32:39.092110', 12, 81),
(332, '2021-02-26 14:32:39.188945', '2021-02-26 14:32:39.188945', 12, 82),
(333, '2021-02-26 14:32:39.280043', '2021-02-26 14:32:39.280043', 12, 83),
(334, '2021-02-26 14:32:39.374899', '2021-02-26 14:32:39.374899', 12, 105),
(335, '2021-02-26 14:32:39.473563', '2021-02-26 14:32:39.473563', 12, 102),
(336, '2021-02-26 14:32:39.570921', '2021-02-26 14:32:39.570921', 12, 103),
(337, '2021-02-26 14:32:39.665052', '2021-02-26 14:32:39.665052', 12, 29),
(338, '2021-02-26 14:32:39.760189', '2021-02-26 14:32:39.760189', 12, 30),
(339, '2021-02-26 14:32:39.852856', '2021-02-26 14:32:39.852856', 12, 47),
(340, '2021-02-26 14:32:39.944180', '2021-02-26 14:32:39.944180', 12, 48),
(341, '2021-02-26 14:32:40.038086', '2021-02-26 14:32:40.038086', 12, 84),
(342, '2021-02-26 14:32:40.135874', '2021-02-26 14:32:40.135874', 12, 90),
(343, '2021-02-26 14:32:40.234015', '2021-02-26 14:32:40.234015', 12, 85),
(355, '2021-02-26 14:32:54.538822', '2021-02-26 14:32:54.538822', 10, 1),
(356, '2021-02-26 14:32:54.634784', '2021-02-26 14:32:54.634784', 10, 96),
(357, '2021-02-26 14:32:54.732878', '2021-02-26 14:32:54.732878', 10, 45),
(358, '2021-02-26 14:32:54.826023', '2021-02-26 14:32:54.826023', 10, 43),
(359, '2021-02-26 14:32:54.920173', '2021-02-26 14:32:54.920173', 10, 49),
(360, '2021-02-26 14:32:55.019141', '2021-02-26 14:32:55.019141', 10, 86),
(361, '2021-02-26 14:32:55.119438', '2021-02-26 14:32:55.119438', 10, 2),
(362, '2021-02-26 14:32:55.211471', '2021-02-26 14:32:55.211471', 10, 27),
(363, '2021-02-26 14:32:55.304855', '2021-02-26 14:32:55.304855', 10, 97),
(364, '2021-02-26 14:32:55.397939', '2021-02-26 14:32:55.397939', 10, 59),
(365, '2021-02-26 14:32:55.491674', '2021-02-26 14:32:55.491674', 10, 60),
(366, '2021-02-26 14:32:55.584051', '2021-02-26 14:32:55.584051', 10, 61),
(367, '2021-02-26 14:32:55.676449', '2021-02-26 14:32:55.676449', 10, 62),
(368, '2021-02-26 14:32:55.774524', '2021-02-26 14:32:55.774524', 10, 63),
(369, '2021-02-26 14:32:55.871634', '2021-02-26 14:32:55.871634', 10, 65),
(370, '2021-02-26 14:32:55.964611', '2021-02-26 14:32:55.964611', 10, 98),
(371, '2021-02-26 14:32:56.074043', '2021-02-26 14:32:56.074043', 10, 99),
(372, '2021-02-26 14:32:56.169316', '2021-02-26 14:32:56.169316', 10, 100),
(373, '2021-02-26 14:32:56.263408', '2021-02-26 14:32:56.263408', 10, 101),
(374, '2021-02-26 14:32:56.356537', '2021-02-26 14:32:56.356537', 10, 8),
(375, '2021-02-26 14:32:56.448195', '2021-02-26 14:32:56.448195', 10, 10),
(376, '2021-02-26 14:32:56.544394', '2021-02-26 14:32:56.544394', 10, 11),
(377, '2021-02-26 14:32:56.641515', '2021-02-26 14:32:56.641515', 10, 12),
(378, '2021-02-26 14:32:56.735242', '2021-02-26 14:32:56.735242', 10, 13),
(379, '2021-02-26 14:32:56.828811', '2021-02-26 14:32:56.828811', 10, 22),
(380, '2021-02-26 14:32:56.922664', '2021-02-26 14:32:56.922664', 10, 23),
(381, '2021-02-26 14:32:57.016873', '2021-02-26 14:32:57.016873', 10, 24),
(382, '2021-02-26 14:32:57.123800', '2021-02-26 14:32:57.123800', 10, 25),
(383, '2021-02-26 14:32:57.223306', '2021-02-26 14:32:57.223306', 10, 26),
(384, '2021-02-26 14:32:57.328482', '2021-02-26 14:32:57.328482', 10, 69),
(385, '2021-02-26 14:32:57.430006', '2021-02-26 14:32:57.430006', 10, 70),
(386, '2021-02-26 14:32:57.521664', '2021-02-26 14:32:57.521664', 10, 71),
(387, '2021-02-26 14:32:57.612399', '2021-02-26 14:32:57.612399', 10, 72),
(388, '2021-02-26 14:32:57.705553', '2021-02-26 14:32:57.705553', 10, 73),
(389, '2021-02-26 14:32:57.799288', '2021-02-26 14:32:57.799288', 10, 74),
(390, '2021-02-26 14:32:57.893894', '2021-02-26 14:32:57.893894', 10, 75),
(391, '2021-02-26 14:32:57.988856', '2021-02-26 14:32:57.988856', 10, 76),
(392, '2021-02-26 14:32:58.090250', '2021-02-26 14:32:58.090250', 10, 77),
(393, '2021-02-26 14:32:58.196616', '2021-02-26 14:32:58.196616', 10, 78),
(394, '2021-02-26 14:32:58.288151', '2021-02-26 14:32:58.288151', 10, 79),
(395, '2021-02-26 14:32:58.378493', '2021-02-26 14:32:58.378493', 10, 80),
(396, '2021-02-26 14:32:58.471283', '2021-02-26 14:32:58.471283', 10, 81),
(397, '2021-02-26 14:32:58.564666', '2021-02-26 14:32:58.564666', 10, 82),
(398, '2021-02-26 14:32:58.658511', '2021-02-26 14:32:58.658511', 10, 83),
(399, '2021-02-26 14:32:58.752713', '2021-02-26 14:32:58.752713', 10, 105),
(400, '2021-02-26 14:32:58.849472', '2021-02-26 14:32:58.849472', 10, 102),
(401, '2021-02-26 14:32:58.948387', '2021-02-26 14:32:58.948387', 10, 103),
(402, '2021-02-26 14:32:59.042410', '2021-02-26 14:32:59.042410', 10, 29),
(403, '2021-02-26 14:32:59.132594', '2021-02-26 14:32:59.132594', 10, 30),
(404, '2021-02-26 14:32:59.226150', '2021-02-26 14:32:59.226150', 10, 47),
(405, '2021-02-26 14:32:59.319494', '2021-02-26 14:32:59.319494', 10, 48),
(406, '2021-02-26 14:32:59.413370', '2021-02-26 14:32:59.413370', 10, 84),
(407, '2021-02-26 14:32:59.507584', '2021-02-26 14:32:59.507584', 10, 90),
(408, '2021-02-26 14:32:59.604332', '2021-02-26 14:32:59.604332', 10, 85),
(517, '2023-02-20 11:01:17.272678', '2023-02-20 11:01:17.272678', 13, 1),
(518, '2023-02-20 11:01:17.384384', '2023-02-20 11:01:17.384384', 13, 96),
(519, '2023-02-20 11:01:17.509665', '2023-02-20 11:01:17.509665', 13, 45),
(520, '2023-02-20 11:01:17.613195', '2023-02-20 11:01:17.613195', 13, 43),
(521, '2023-02-20 11:01:17.717865', '2023-02-20 11:01:17.717865', 13, 49),
(522, '2023-02-20 11:01:17.821450', '2023-02-20 11:01:17.821450', 13, 86),
(523, '2023-02-20 11:01:17.928597', '2023-02-20 11:01:17.928597', 13, 2),
(524, '2023-02-20 11:01:18.042256', '2023-02-20 11:01:18.042256', 13, 27),
(525, '2023-02-20 11:01:18.152961', '2023-02-20 11:01:18.152961', 13, 97),
(526, '2023-02-20 11:01:18.264862', '2023-02-20 11:01:18.264862', 13, 59),
(527, '2023-02-20 11:01:18.375556', '2023-02-20 11:01:18.375556', 13, 60),
(528, '2023-02-20 11:01:18.486312', '2023-02-20 11:01:18.486312', 13, 61),
(529, '2023-02-20 11:01:18.604764', '2023-02-20 11:01:18.604764', 13, 62),
(530, '2023-02-20 11:01:18.708506', '2023-02-20 11:01:18.708506', 13, 63),
(531, '2023-02-20 11:01:18.810557', '2023-02-20 11:01:18.810557', 13, 65),
(532, '2023-02-20 11:01:18.912572', '2023-02-20 11:01:18.912572', 13, 98),
(533, '2023-02-20 11:01:19.012174', '2023-02-20 11:01:19.012174', 13, 99),
(534, '2023-02-20 11:01:19.111748', '2023-02-20 11:01:19.111748', 13, 100),
(535, '2023-02-20 11:01:19.210923', '2023-02-20 11:01:19.210923', 13, 101),
(536, '2023-02-20 11:01:19.314189', '2023-02-20 11:01:19.314189', 13, 8),
(537, '2023-02-20 11:01:19.428883', '2023-02-20 11:01:19.428883', 13, 10),
(538, '2023-02-20 11:01:19.552934', '2023-02-20 11:01:19.552934', 13, 11),
(539, '2023-02-20 11:01:19.663284', '2023-02-20 11:01:19.663284', 13, 12),
(540, '2023-02-20 11:01:19.771651', '2023-02-20 11:01:19.771651', 13, 13),
(541, '2023-02-20 11:01:19.879238', '2023-02-20 11:01:19.879238', 13, 22),
(542, '2023-02-20 11:01:19.987001', '2023-02-20 11:01:19.987001', 13, 23),
(543, '2023-02-20 11:01:20.095790', '2023-02-20 11:01:20.095790', 13, 24),
(544, '2023-02-20 11:01:20.201315', '2023-02-20 11:01:20.201315', 13, 25),
(545, '2023-02-20 11:01:20.308299', '2023-02-20 11:01:20.308299', 13, 26),
(546, '2023-02-20 11:01:20.414844', '2023-02-20 11:01:20.414844', 13, 69),
(547, '2023-02-20 11:01:20.528804', '2023-02-20 11:01:20.528804', 13, 70),
(548, '2023-02-20 11:01:20.635504', '2023-02-20 11:01:20.635504', 13, 71),
(549, '2023-02-20 11:01:20.749819', '2023-02-20 11:01:20.749819', 13, 72),
(550, '2023-02-20 11:01:20.864884', '2023-02-20 11:01:20.864884', 13, 73),
(551, '2023-02-20 11:01:20.970192', '2023-02-20 11:01:20.970192', 13, 74),
(552, '2023-02-20 11:01:21.074434', '2023-02-20 11:01:21.074434', 13, 75),
(553, '2023-02-20 11:01:21.179895', '2023-02-20 11:01:21.179895', 13, 76),
(554, '2023-02-20 11:01:21.286653', '2023-02-20 11:01:21.286653', 13, 77),
(555, '2023-02-20 11:01:21.389230', '2023-02-20 11:01:21.389230', 13, 78),
(556, '2023-02-20 11:01:21.498122', '2023-02-20 11:01:21.498122', 13, 79),
(557, '2023-02-20 11:01:21.608182', '2023-02-20 11:01:21.608182', 13, 80),
(558, '2023-02-20 11:01:21.716534', '2023-02-20 11:01:21.716534', 13, 81),
(559, '2023-02-20 11:01:21.821921', '2023-02-20 11:01:21.821921', 13, 82),
(560, '2023-02-20 11:01:21.924088', '2023-02-20 11:01:21.924088', 13, 83),
(561, '2023-02-20 11:01:22.027509', '2023-02-20 11:01:22.027509', 13, 105),
(562, '2023-02-20 11:01:22.138587', '2023-02-20 11:01:22.138587', 13, 102),
(563, '2023-02-20 11:01:22.248197', '2023-02-20 11:01:22.248197', 13, 103),
(564, '2023-02-20 11:01:22.348024', '2023-02-20 11:01:22.348024', 13, 29),
(565, '2023-02-20 11:01:22.450315', '2023-02-20 11:01:22.450315', 13, 30),
(566, '2023-02-20 11:01:22.561988', '2023-02-20 11:01:22.561988', 13, 47),
(567, '2023-02-20 11:01:22.672138', '2023-02-20 11:01:22.672138', 13, 48),
(568, '2023-02-20 11:01:22.791173', '2023-02-20 11:01:22.791173', 13, 84),
(569, '2023-02-20 11:01:22.898018', '2023-02-20 11:01:22.898018', 13, 90),
(570, '2023-02-20 11:01:23.008575', '2023-02-20 11:01:23.008575', 13, 85);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_user`
--

CREATE TABLE `base_sys_user` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `departmentId` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `passwordV` int(11) NOT NULL DEFAULT '1' COMMENT '密码版本, 作用是改完密码，让原来的token失效',
  `nickName` varchar(255) DEFAULT NULL COMMENT '昵称',
  `headImg` varchar(255) DEFAULT NULL COMMENT '头像',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:禁用 1：启用',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `socketId` varchar(255) DEFAULT NULL COMMENT 'socketId'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_user`
--

INSERT INTO `base_sys_user` (`id`, `createTime`, `updateTime`, `departmentId`, `name`, `username`, `password`, `passwordV`, `nickName`, `headImg`, `phone`, `email`, `status`, `remark`, `socketId`) VALUES
(1, '2021-02-24 21:16:41.525157', '2023-10-17 16:34:49.000000', 1, '超级管理员', 'admin', '89a4a8b35597d44c2a865dd2740892b7', 8, '管理员', 'https://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/space/112cb4bb2e5941219ca88511e4e9eccd_c01449b0-5a97-11ed-b5b1-7b680a95ea06.jpg', '18000000000', 'team@cool-js.com', 1, '拥有最高权限的用户', NULL),
(24, '2021-02-26 14:17:38.000000', '2023-03-06 20:18:58.000000', 1, '小白', 'xiaobai', 'e10adc3949ba59abbe56e057f20f883e', 1, '小白', 'https://show.cool-admin.com/api/public/uploads/20230306/2e8a293ebfd8495083af93da141b045e_f85bccf6f4cf4890aea4e963e658fb94_1675933340_tplv-dy-cropcenter_323_430.jpg', NULL, NULL, 1, NULL, NULL),
(25, '2021-02-26 14:28:25.000000', '2023-03-06 20:18:53.000000', 1, '小黑', 'xiaohei', 'e10adc3949ba59abbe56e057f20f883e', 1, '小黑', 'https://show.cool-admin.com/api/public/uploads/20230306/0bd3095dd14c4ef89cf1e04c66b62900_e7b3653e07224702a1e8f246453d7d72_tplv-dy-cropcenter_323_430.jpg', NULL, NULL, 1, NULL, NULL),
(26, '2021-02-26 14:28:49.000000', '2023-03-06 20:18:48.000000', 1, '小绿', 'xiaolv', 'e10adc3949ba59abbe56e057f20f883e', 1, '小绿', 'https://show.cool-admin.com/api/public/uploads/20230306/84bff75c07e44eff9beef880fd91e9cb_467d1550bcfc46968deb294b756ff52e_1674986122_tplv-dy-cropcenter_323_430.jpg', NULL, NULL, 1, NULL, NULL),
(27, '2021-02-26 14:29:23.000000', '2023-03-07 13:15:00.000000', 1, '小青', 'xiaoqin', 'e10adc3949ba59abbe56e057f20f883e', 1, '小青', 'https://show.cool-admin.com/api/public/uploads/20230306/fb49e291d4a44c659367f17751699e04_2c0f4758d8484271be34081c8fe49adc_1675679254_tplv-dy-cropcenter_323_430.jpg', NULL, NULL, 1, NULL, NULL),
(28, '2021-02-26 14:29:52.000000', '2023-03-06 19:57:46.000000', 1, '神仙都没用', 'icssoa', 'e10adc3949ba59abbe56e057f20f883e', 1, '神仙都没用', 'https://show.cool-admin.com/api/public/uploads/20230306/26942e8aa783427f8ad73c1a10fcac6f_eb26da2fc07940b1bb63f1510933eb01_1676971271_tplv-dy-cropcenter_323_430.jpg', NULL, NULL, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `base_sys_user_role`
--

CREATE TABLE `base_sys_user_role` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `userId` bigint(20) NOT NULL COMMENT '用户ID',
  `roleId` bigint(20) NOT NULL COMMENT '角色ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `base_sys_user_role`
--

INSERT INTO `base_sys_user_role` (`id`, `createTime`, `updateTime`, `userId`, `roleId`) VALUES
(1, '2021-02-24 22:03:11.665805', '2021-02-24 22:03:11.665805', 1, 1),
(2, '2021-02-25 11:03:55.325988', '2021-02-25 11:03:55.325988', 2, 1),
(3, '2021-02-25 14:30:57.295150', '2021-02-25 14:30:57.295150', 3, 1),
(4, '2021-02-25 14:39:32.975014', '2021-02-25 14:39:32.975014', 4, 1),
(5, '2021-02-25 14:40:56.812948', '2021-02-25 14:40:56.812948', 5, 1),
(6, '2021-02-25 14:44:08.436555', '2021-02-25 14:44:08.436555', 6, 1),
(7, '2021-02-25 14:46:17.409232', '2021-02-25 14:46:17.409232', 7, 1),
(8, '2021-02-25 14:47:47.211749', '2021-02-25 14:47:47.211749', 8, 1),
(9, '2021-02-25 14:48:11.734024', '2021-02-25 14:48:11.734024', 9, 1),
(10, '2021-02-25 14:50:48.288616', '2021-02-25 14:50:48.288616', 10, 1),
(11, '2021-02-25 14:51:32.123884', '2021-02-25 14:51:32.123884', 11, 1),
(12, '2021-02-25 15:46:26.356943', '2021-02-25 15:46:26.356943', 12, 1),
(13, '2021-02-25 15:56:43.475155', '2021-02-25 15:56:43.475155', 13, 1),
(14, '2021-02-25 16:03:14.417784', '2021-02-25 16:03:14.417784', 14, 1),
(16, '2021-02-25 16:22:11.200152', '2021-02-25 16:22:11.200152', 16, 1),
(17, '2021-02-25 17:44:37.635550', '2021-02-25 17:44:37.635550', 15, 1),
(19, '2021-02-25 17:51:00.554812', '2021-02-25 17:51:00.554812', 18, 1),
(21, '2021-02-25 17:54:41.375113', '2021-02-25 17:54:41.375113', 17, 1),
(22, '2021-02-25 17:55:49.385301', '2021-02-25 17:55:49.385301', 20, 1),
(24, '2021-02-25 17:58:35.452363', '2021-02-25 17:58:35.452363', 22, 1),
(27, '2021-02-25 21:25:55.005236', '2021-02-25 21:25:55.005236', 19, 1),
(28, '2021-02-26 13:50:05.633242', '2021-02-26 13:50:05.633242', 21, 8),
(29, '2021-02-26 13:50:17.836990', '2021-02-26 13:50:17.836990', 23, 8),
(45, '2023-02-16 19:11:10.029945', '2023-02-16 19:11:10.029945', 29, 10),
(46, '2023-03-06 19:57:46.215729', '2023-03-06 19:57:46.215729', 28, 12),
(47, '2023-03-06 19:57:46.228651', '2023-03-06 19:57:46.228651', 28, 10),
(49, '2023-03-06 20:18:48.992031', '2023-03-06 20:18:48.992031', 26, 13),
(50, '2023-03-06 20:18:53.818567', '2023-03-06 20:18:53.818567', 25, 13),
(51, '2023-03-06 20:18:58.691102', '2023-03-06 20:18:58.691102', 24, 12),
(52, '2023-03-06 20:28:45.169085', '2023-03-06 20:28:45.169085', 30, 11),
(53, '2023-03-07 11:39:57.672383', '2023-03-07 11:39:57.672383', 31, 10),
(54, '2023-03-07 13:15:00.326613', '2023-03-07 13:15:00.326613', 27, 11);

-- --------------------------------------------------------

--
-- 表的结构 `cloud_db`
--

CREATE TABLE `cloud_db` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `readme` varchar(255) DEFAULT NULL COMMENT '说明',
  `content` text NOT NULL COMMENT '内容',
  `className` varchar(255) DEFAULT NULL COMMENT '类名',
  `tableName` varchar(255) DEFAULT NULL COMMENT '表名',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态 0-禁用 1-启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `cloud_db`
--

INSERT INTO `cloud_db` (`id`, `createTime`, `updateTime`, `name`, `readme`, `content`, `className`, `tableName`, `status`) VALUES
(13, '2023-02-16 19:25:21.995000', '2023-02-23 12:00:43.621000', '用户', NULL, 'import { BaseEntity } from \'@cool-midway/core\';\nimport { Column, Entity } from \'typeorm\';\n\n/**\n * 描述\n */\n@Entity(\'user\')\nexport class UserEntity extends BaseEntity {\n    @Column({ comment: \'姓名\' })\n    name: string;\n    @Column({ comment: \'年龄\' })\n    age: string;\n}', 'UserEntity', 'func_user', 1);

-- --------------------------------------------------------

--
-- 表的结构 `cloud_func_info`
--

CREATE TABLE `cloud_func_info` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `readme` varchar(255) DEFAULT NULL COMMENT '说明',
  `content` text NOT NULL COMMENT '内容',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态 0-禁用 1-启用'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `cloud_func_info`
--

INSERT INTO `cloud_func_info` (`id`, `createTime`, `updateTime`, `name`, `readme`, `content`, `status`) VALUES
(1, '2023-02-15 15:29:00.010000', '2023-03-07 04:14:27.212000', '测试', 'ddd', 'import { CloudCrud } from \'@cool-midway/cloud\';\n\n/**\n * 描述\n */\nexport class User extends CloudCrud {\n    async main() {\n        this.setCurdOption({\n            entity: \'TestUserEntity\',\n            api: [\"add\", \"page\"]\n        });\n    }\n}', 1),
(2, '2023-02-16 01:21:20.485000', '2023-03-07 04:14:26.372000', '用户1', NULL, 'import { CloudCrud } from \'@cool-midway/cloud\';\n\n/**\n * 描述\n */\nexport class Xxx extends CloudCrud {\n  async main() {\n    this.setCurdOption({\n      entity: \'UserEntity\',\n      api: [\'add\', \'delete\', \'update\', \'info\', \'list\', \'page\']\n    });\n  }\n}\n', 0);

-- --------------------------------------------------------

--
-- 表的结构 `cloud_func_log`
--

CREATE TABLE `cloud_func_log` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `infoId` int(11) NOT NULL COMMENT '云函数ID',
  `request` json DEFAULT NULL COMMENT '请求',
  `result` json DEFAULT NULL COMMENT '结果',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型 0-失败 1-成功',
  `error` text COMMENT '异常信息',
  `time` int(11) NOT NULL DEFAULT '0' COMMENT '耗时(毫秒)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `demo_goods`
--

CREATE TABLE `demo_goods` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `price` decimal(5,2) NOT NULL COMMENT '价格',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `mainImage` varchar(255) DEFAULT NULL COMMENT '主图',
  `exampleImages` json DEFAULT NULL COMMENT '示例图',
  `stock` int(11) NOT NULL DEFAULT '0' COMMENT '库存'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `dict_info`
--

CREATE TABLE `dict_info` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `typeId` int(11) NOT NULL COMMENT '类型ID',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `orderNum` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `parentId` int(11) DEFAULT NULL COMMENT '父ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `dict_info`
--

INSERT INTO `dict_info` (`id`, `createTime`, `updateTime`, `typeId`, `name`, `orderNum`, `remark`, `parentId`) VALUES
(21, '2023-03-06 11:40:51.312000', '2023-09-21 16:02:29.499000', 19, '学校', 1, NULL, NULL),
(22, '2023-03-06 11:40:59.000000', '2023-09-21 16:05:17.149000', 19, '感情', 1, NULL, NULL),
(23, '2023-03-06 11:41:20.581000', '2023-10-17 14:51:55.609000', 20, '吐槽', 1, NULL, NULL),
(24, '2023-03-06 11:41:25.740000', '2023-10-17 14:52:13.874000', 20, '八卦', 2, NULL, NULL),
(25, '2023-03-06 11:41:31.297000', '2023-10-17 14:52:42.787000', 20, '游戏', 3, NULL, NULL),
(26, '2023-03-06 11:41:35.987000', '2023-10-17 14:52:54.560000', 20, '旅游', 4, NULL, NULL),
(27, '2023-03-06 11:41:41.430000', '2023-10-17 14:53:20.017000', 20, '捞人', 5, NULL, NULL),
(29, '2023-09-21 16:02:53.026000', '2023-09-21 16:02:53.026000', 19, '电影', 1, NULL, NULL),
(30, '2023-09-21 16:03:00.524000', '2023-09-21 16:03:00.524000', 19, '音乐', 1, NULL, NULL),
(31, '2023-09-21 16:03:35.401000', '2023-09-21 16:03:35.401000', 19, '摄影', 1, NULL, NULL),
(32, '2023-09-21 16:04:00.008000', '2023-09-21 16:04:00.008000', 19, '游戏', 1, NULL, NULL),
(33, '2023-09-21 16:04:13.473000', '2023-09-21 16:04:13.473000', 19, '美食', 1, NULL, NULL),
(34, '2023-09-21 16:04:29.890000', '2023-09-21 16:04:29.890000', 19, '旅游', 1, NULL, NULL),
(35, '2023-09-21 16:04:44.505000', '2023-09-21 16:04:44.505000', 19, '景点', 1, NULL, NULL),
(36, '2023-09-21 16:05:06.145000', '2023-09-21 16:05:06.145000', 19, '宠物', 1, NULL, NULL),
(37, '2023-09-21 16:05:33.871000', '2023-09-21 16:05:33.871000', 19, '学习', 1, NULL, NULL),
(38, '2023-09-21 16:05:45.659000', '2023-09-21 16:05:45.659000', 19, '运动', 1, NULL, NULL),
(39, '2023-09-21 16:05:56.289000', '2023-09-21 16:05:56.289000', 19, '考试', 1, NULL, NULL),
(40, '2023-09-21 16:06:13.003000', '2023-09-21 16:06:26.138000', 19, '设计', 1, NULL, NULL),
(41, '2023-09-21 16:06:18.945000', '2023-09-21 16:06:18.945000', 19, '其他', 1, NULL, NULL),
(42, '2023-10-17 23:22:43.670000', '2023-10-17 23:22:43.670000', 20, '运动', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `dict_type`
--

CREATE TABLE `dict_type` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `key` varchar(255) NOT NULL COMMENT '标识'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `dict_type`
--

INSERT INTO `dict_type` (`id`, `createTime`, `updateTime`, `name`, `key`) VALUES
(19, '2023-03-06 11:40:45.295000', '2023-09-22 14:21:25.856000', '分类', 'category'),
(20, '2023-03-06 11:41:13.227000', '2023-09-22 14:21:19.451000', '话题', 'topic');

-- --------------------------------------------------------

--
-- 表的结构 `func_user`
--

CREATE TABLE `func_user` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '姓名',
  `age` varchar(255) NOT NULL COMMENT '年龄'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `iot_device`
--

CREATE TABLE `iot_device` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `uniqueId` varchar(255) NOT NULL COMMENT '设备唯一ID',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0-离线 1-在线',
  `clientId` varchar(255) DEFAULT NULL COMMENT '客户端ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `iot_message`
--

CREATE TABLE `iot_message` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `deviceId` int(11) NOT NULL COMMENT '设备ID',
  `data` varchar(255) NOT NULL COMMENT '数据',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '类型 0-推送 1-接收'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `query-result-cache`
--

CREATE TABLE `query-result-cache` (
  `id` int(11) NOT NULL,
  `identifier` varchar(255) DEFAULT NULL,
  `time` bigint(20) NOT NULL,
  `duration` int(11) NOT NULL,
  `query` text NOT NULL,
  `result` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `recycle_data`
--

CREATE TABLE `recycle_data` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `entityInfo` json NOT NULL COMMENT '表',
  `userId` varchar(255) DEFAULT NULL COMMENT '操作人',
  `data` json NOT NULL COMMENT '被删除的数据',
  `url` varchar(255) DEFAULT NULL COMMENT '请求的接口',
  `params` json DEFAULT NULL COMMENT '请求参数',
  `count` int(11) NOT NULL DEFAULT '1' COMMENT '删除数据条数'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- 表的结构 `space_info`
--

CREATE TABLE `space_info` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `url` varchar(255) NOT NULL COMMENT '地址',
  `type` varchar(255) NOT NULL COMMENT '类型',
  `classifyId` bigint(20) DEFAULT NULL COMMENT '分类ID',
  `fileId` varchar(255) NOT NULL COMMENT '文件id',
  `name` varchar(255) NOT NULL COMMENT '文件名',
  `size` int(11) NOT NULL COMMENT '文件大小',
  `version` int(11) NOT NULL DEFAULT '1' COMMENT '文档版本',
  `key` varchar(255) NOT NULL COMMENT '文件位置'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `space_info`
--

INSERT INTO `space_info` (`id`, `createTime`, `updateTime`, `url`, `type`, `classifyId`, `fileId`, `name`, `size`, `version`, `key`) VALUES
(1, '2023-02-13 21:34:09.746000', '2023-02-13 21:34:09.746000', 'http://127.0.0.1:8001/public/uploads/20230213/cc2c0b77-be51-4816-800f-ca48c61a08d6_1.pdf', 'file', NULL, '', '', 0, 1, ''),
(2, '2023-02-14 19:35:32.492000', '2023-02-14 19:35:32.492000', 'http://127.0.0.1:8001/public/uploads/20230214/新建 PPTX 演示文稿.pptx', 'Presentation', NULL, '1676374532437', '新建 PPTX 演示文稿.pptx', 28708, 1, ''),
(3, '2023-02-14 19:38:50.277000', '2023-02-14 19:38:50.277000', 'http://127.0.0.1:8001/public/uploads/20230214/1666245309333.jpg', 'image', NULL, '1676374730220', 'blob:http://localhost:9000/a17db32d-9b87-444f-aafb-7c77e788ddcd', 173693, 1, ''),
(4, '2023-02-14 19:38:53.023000', '2023-02-14 19:38:53.023000', 'http://127.0.0.1:8001/public/uploads/20230214/1666245279343.jpg', 'image', NULL, '1676374732986', 'blob:http://localhost:9000/d447b62e-9ba1-4e22-8419-2024488c67e1', 237832, 1, ''),
(5, '2023-02-14 19:38:56.646000', '2023-02-14 19:38:56.646000', 'http://127.0.0.1:8001/public/uploads/20230214/logo.zip', 'file', NULL, '1676374736602', 'logo.zip', 5560, 1, ''),
(6, '2023-02-14 19:39:14.344000', '2023-02-14 19:39:14.344000', 'http://127.0.0.1:8001/public/uploads/20230214/2.png', 'image', NULL, '1676374754220', 'blob:http://localhost:9000/7a9cd28c-16d7-4b31-8d6d-970a83912ab1', 86861, 1, ''),
(11, '2023-02-15 11:04:55.404000', '2023-02-15 11:04:55.404000', 'http://127.0.0.1:8001/public/uploads/20230215/8f8f4d6a847f0491e613e586f51c57b1.mp4', 'video', NULL, '1676430295322', '8f8f4d6a847f0491e613e586f51c57b1.mp4', 2264263, 1, ''),
(12, '2023-02-15 11:05:57.352000', '2023-02-15 11:05:57.352000', 'http://127.0.0.1:8001/public/uploads/20230215/b7ab586ce4122241610be88cade1729e.mp4', 'video', NULL, '1676430357299', 'b7ab586ce4122241610be88cade1729e.mp4', 2200980, 1, ''),
(13, '2023-02-15 11:13:11.986000', '2023-02-15 11:13:11.986000', 'http://127.0.0.1:8001/public/uploads/20230215/新建 文本文档.txt', 'file', NULL, '1676430791940', '新建 文本文档.txt', 0, 1, ''),
(14, '2023-02-15 13:14:47.097000', '2023-02-15 13:14:47.097000', 'http://127.0.0.1:8001/public/uploads/20230215/logo.jpg', 'image', NULL, '1676438087053', 'blob:http://localhost:9000/2606eb20-9a24-4c46-abd5-cd364dda7b34', 7000, 1, ''),
(37, '2023-02-16 21:38:24.004000', '2023-02-16 21:38:24.004000', 'http://127.0.0.1:8001/public/uploads/20230216/1666245279343.jpg', 'image', 1, '1676554703912', 'blob:http://localhost:9000/7b56eef2-2210-4a8e-b292-0f0e96738613', 237832, 1, ''),
(38, '2023-02-16 21:38:24.018000', '2023-02-16 21:38:24.018000', 'http://127.0.0.1:8001/public/uploads/20230216/8f8f4d6a847f0491e613e586f51c57b1.mp4', 'video', 1, '1676554703910', '8f8f4d6a847f0491e613e586f51c57b1.mp4', 2264263, 1, ''),
(39, '2023-02-16 21:38:24.037000', '2023-02-16 21:38:24.037000', 'http://127.0.0.1:8001/public/uploads/20230216/1666245309333.jpg', 'image', 1, '1676554703914', 'blob:http://localhost:9000/863f070d-df1c-4b73-8e1c-cb0344ef7a47', 173693, 1, ''),
(40, '2023-02-16 21:38:24.054000', '2023-02-16 21:38:24.054000', 'http://127.0.0.1:8001/public/uploads/20230216/logo.jpg', 'image', 1, '1676554703917', 'blob:http://localhost:9000/66b0c6d4-9525-44a2-b48d-33456bcbdce1', 7000, 1, ''),
(41, '2023-02-16 21:38:24.058000', '2023-02-16 21:38:24.058000', 'http://127.0.0.1:8001/public/uploads/20230216/b7ab586ce4122241610be88cade1729e.mp4', 'video', 1, '1676554703916', 'b7ab586ce4122241610be88cade1729e.mp4', 2200980, 1, ''),
(42, '2023-02-16 21:40:47.400000', '2023-02-16 21:40:47.400000', 'http://127.0.0.1:8001/public/uploads/20230216/logo.jpg', 'image', 1, '1676554847357', 'blob:http://localhost:9000/cae13036-927e-44fb-942b-58f2d5833191', 7000, 1, ''),
(43, '2023-02-16 21:40:50.514000', '2023-02-16 21:40:50.514000', 'http://127.0.0.1:8001/public/uploads/20230216/1666245309333.jpg', 'image', 1, '1676554850474', 'blob:http://localhost:9000/0f2e7c13-d23c-4a59-a84b-b7318ac43df1', 173693, 1, ''),
(45, '2023-02-16 21:43:06.102000', '2023-02-16 21:43:06.102000', 'http://127.0.0.1:8001/public/uploads/20230216/logo.zip', 'file', 1, '1676554986059', 'logo.zip', 5560, 1, ''),
(46, '2023-02-16 21:45:54.201000', '2023-02-16 21:45:54.201000', 'http://127.0.0.1:8001/public/uploads/20230216/新建 PPTX 演示文稿.pptx', 'Presentation', 1, '1676555154159', '新建 PPTX 演示文稿.pptx', 28708, 1, ''),
(47, '2023-02-16 21:48:02.552000', '2023-02-16 21:48:02.552000', 'http://127.0.0.1:8001/public/uploads/20230216/8f8f4d6a847f0491e613e586f51c57b1.mp4', 'video', 1, '1676555282502', '8f8f4d6a847f0491e613e586f51c57b1.mp4', 2264263, 1, ''),
(48, '2023-02-17 19:43:48.707000', '2023-02-17 19:43:48.707000', 'http://127.0.0.1:8001/public/uploads/20230217/logo.png', 'image', 1, '1676634229583', 'blob:http://localhost:9000/a1c8d351-ff36-47b2-b477-fbb5de61e163', 8093, 1, ''),
(49, '2023-02-17 19:45:05.837000', '2023-02-17 19:45:05.837000', 'http://127.0.0.1:8001/public/uploads/20230217/logo.png', 'image', 1, '1676634305795', 'blob:http://localhost:9000/36659fd0-7bff-4a8a-b064-3f9ba6530191', 8093, 1, ''),
(50, '2023-02-17 19:46:36.423000', '2023-02-17 19:46:36.423000', 'http://127.0.0.1:8001/public/uploads/20230217/c8128c24-d0e9-4e07-9c0d-6f65446e105b.png', 'image', 1, '1676634396368', 'blob:http://localhost:9000/ac931705-c383-47b0-8542-e12f2eba1a55', 3313, 1, ''),
(51, '2023-02-19 23:41:21.326000', '2023-02-19 23:41:21.326000', 'http://127.0.0.1:8001/public/uploads/20230219/图层4.png', 'image', 1, '1676821281209', 'blob:http://localhost:9000/d9ddbe89-b206-4766-a4dc-7df1032bfe39', 357586, 1, ''),
(52, '2023-02-19 23:41:53.150000', '2023-02-19 23:41:53.150000', 'http://127.0.0.1:8001/public/uploads/20230219/1669607797795096.mp4', 'video', 1, '1676821312901', '1669607797795096.mp4', 15929928, 1, ''),
(86, '2023-03-06 20:23:22.467000', '2023-03-08 15:10:05.822205', 'https://show.cool-admin.com/api/public/uploads/20230306/e023a2e79ba643e486310e0e56adbb8b_1666245279343.jpg', 'image', 10, 'e023a2e79ba643e486310e0e56adbb8b', 'blob:https://show.cool-admin.com/ec7b723d-e228-4b22-840d-da0da388aa09', 237832, 1, '/public/uploads/20230306/e023a2e79ba643e486310e0e56adbb8b_1666245279343.jpg'),
(87, '2023-03-06 20:23:22.501000', '2023-03-08 15:10:09.746789', 'https://show.cool-admin.com/api/public/uploads/20230306/7700e5c10b74484097eb6ba80882da4d_1666245309333.jpg', 'image', 10, '7700e5c10b74484097eb6ba80882da4d', 'blob:https://show.cool-admin.com/1588f52f-a3a8-44ed-9387-a9f7e3cacf6d', 173693, 1, '/public/uploads/20230306/7700e5c10b74484097eb6ba80882da4d_1666245309333.jpg'),
(100, '2023-03-08 14:14:50.849000', '2023-03-08 14:21:46.000000', 'https://show.cool-admin.com/api/public/uploads/20230308/f182d2aa3bed4bff85c815dedc9155b1_演示ppt.pptx', 'Presentation', 14, 'f182d2aa3bed4bff85c815dedc9155b1', '演示ppt.pptx', 38865, 3, '/public/uploads/20230308/f182d2aa3bed4bff85c815dedc9155b1_演示ppt.pptx'),
(101, '2023-03-08 14:14:50.871000', '2023-03-08 15:10:17.702950', 'https://show.cool-admin.com/api/public/uploads/20230308/02b08312cb654650853c078289873c84_演示表格.xlsx', 'Spreadsheet', 14, '02b08312cb654650853c078289873c84', '演示表格.xlsx', 8686, 1, '/public/uploads/20230308/02b08312cb654650853c078289873c84_演示表格.xlsx'),
(102, '2023-03-08 14:14:50.900000', '2023-03-08 15:10:21.792369', 'https://show.cool-admin.com/api/public/uploads/20230308/fff47e95a8794073af5a1b90aabb5d52_演示word.docx', 'Writer', 14, 'fff47e95a8794073af5a1b90aabb5d52', '演示word.docx', 10064, 1, '/public/uploads/20230308/fff47e95a8794073af5a1b90aabb5d52_演示word.docx'),
(103, '2023-10-17 16:34:33.386000', '2023-10-17 16:34:33.386000', 'https://oss-1257486725.cos.ap-guangzhou.myqcloud.com/app/space/112cb4bb2e5941219ca88511e4e9eccd_c01449b0-5a97-11ed-b5b1-7b680a95ea06.jpg', 'image', 9, '112cb4bb2e5941219ca88511e4e9eccd', 'blob:https://cuui.cn/585f9361-bb00-4234-b785-93721508fed9', 88488, 1, 'app/space/112cb4bb2e5941219ca88511e4e9eccd_c01449b0-5a97-11ed-b5b1-7b680a95ea06.jpg');

-- --------------------------------------------------------

--
-- 表的结构 `space_type`
--

CREATE TABLE `space_type` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `name` varchar(255) NOT NULL COMMENT '类别名称',
  `parentId` tinyint(4) DEFAULT NULL COMMENT '父分类ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `space_type`
--

INSERT INTO `space_type` (`id`, `createTime`, `updateTime`, `name`, `parentId`) VALUES
(9, '2023-02-20 10:55:27.239000', '2023-02-20 10:55:43.302000', '微信头像', NULL),
(10, '2023-02-20 10:55:51.028000', '2023-02-20 10:55:51.028000', '朋友圈素材', NULL),
(11, '2023-02-20 10:56:23.866000', '2023-02-20 10:56:23.866000', '抖音视频', NULL),
(14, '2023-03-06 20:22:20.288000', '2023-03-06 20:22:20.288000', '文档', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `task_info`
--

CREATE TABLE `task_info` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `jobId` varchar(255) DEFAULT NULL COMMENT '任务ID',
  `repeatConf` varchar(1000) DEFAULT NULL COMMENT '任务配置',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `cron` varchar(255) DEFAULT NULL COMMENT 'cron',
  `limit` int(11) DEFAULT NULL COMMENT '最大执行次数 不传为无限次',
  `every` int(11) DEFAULT NULL COMMENT '每间隔多少毫秒执行一次 如果cron设置了 这项设置就无效',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 0:停止 1：运行',
  `startDate` datetime DEFAULT NULL COMMENT '开始时间',
  `endDate` datetime DEFAULT NULL COMMENT '结束时间',
  `data` varchar(255) DEFAULT NULL COMMENT '数据',
  `service` varchar(255) DEFAULT NULL COMMENT '执行的service实例ID',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0:系统 1：用户',
  `nextRunTime` datetime DEFAULT NULL COMMENT '下一次执行时间',
  `taskType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0:cron 1：时间间隔'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `task_info`
--

INSERT INTO `task_info` (`id`, `createTime`, `updateTime`, `jobId`, `repeatConf`, `name`, `cron`, `limit`, `every`, `remark`, `status`, `startDate`, `endDate`, `data`, `service`, `type`, `nextRunTime`, `taskType`) VALUES
(1, '2021-03-10 14:25:13.381000', '2021-03-10 14:25:19.011000', NULL, '{\"count\":1,\"type\":1,\"limit\":5,\"name\":\"每秒执行,总共5次\",\"taskType\":1,\"every\":1000,\"service\":\"taskDemoService.test()\",\"status\":1,\"id\":1,\"createTime\":\"2021-03-10 14:25:13\",\"updateTime\":\"2021-03-10 14:25:13\",\"jobId\":1}', '每秒执行,总共5次', NULL, 5, 1000, NULL, 0, NULL, NULL, NULL, 'taskDemoService.test()', 1, '2023-10-26 07:30:00', 1),
(2, '2021-03-10 14:25:53.000000', '2023-09-05 09:32:31.992000', NULL, '{\"jobId\":2,\"pattern\":\"0/5 * * * * ? \",\"count\":1}', 'cron任务，5秒执行一次', '0/5 * * * * ? ', NULL, NULL, NULL, 0, NULL, NULL, NULL, 'taskDemoService.test()', 1, '2023-10-26 10:00:00', 0);

-- --------------------------------------------------------

--
-- 表的结构 `task_log`
--

CREATE TABLE `task_log` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `taskId` bigint(20) DEFAULT NULL COMMENT '任务ID',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态 0-失败 1-成功',
  `detail` text COMMENT '详情描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `task_log`
--

INSERT INTO `task_log` (`id`, `createTime`, `updateTime`, `taskId`, `status`, `detail`) VALUES
(1, '2021-03-10 14:25:14.020930', '2021-03-10 14:25:14.020930', 1, 1, '\"任务执行成功\"'),

-- --------------------------------------------------------

--
-- 表的结构 `user_info`
--

CREATE TABLE `user_info` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `unionid` varchar(255) DEFAULT NULL COMMENT '登录唯一ID',
  `avatarUrl` varchar(255) DEFAULT NULL COMMENT '头像',
  `nickName` varchar(255) DEFAULT NULL COMMENT '昵称',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `gender` int(11) NOT NULL DEFAULT '0' COMMENT '性别 0-未知 1-男 2-女',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态 0-禁用 1-正常',
  `loginType` int(11) NOT NULL DEFAULT '1' COMMENT '登录方式 1-小程序 2-公众号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `user_info`
--

INSERT INTO `user_info` (`id`, `createTime`, `updateTime`, `unionid`, `avatarUrl`, `nickName`, `phone`, `gender`, `status`, `loginType`) VALUES
(1, '2023-09-05 10:21:39.938844', '2023-09-06 17:38:52.428000', 'oabDj4oo1wQlQXlYmcz2ncvdfw0U', 'http://127.0.0.1:8001/public/uploads/20230905/00755c80-4bd6-11ee-a061-e3378100bd2d.png', '微信用户', NULL, 0, 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `user_wx`
--

CREATE TABLE `user_wx` (
  `id` int(11) NOT NULL COMMENT 'ID',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间',
  `unionid` varchar(255) DEFAULT NULL COMMENT '微信unionid',
  `openid` varchar(255) NOT NULL COMMENT '微信openid',
  `avatarUrl` varchar(255) DEFAULT NULL COMMENT '头像',
  `nickName` varchar(255) DEFAULT NULL COMMENT '昵称',
  `gender` int(11) NOT NULL DEFAULT '0' COMMENT '性别 0-未知 1-男 2-女',
  `language` varchar(255) DEFAULT NULL COMMENT '语言',
  `city` varchar(255) DEFAULT NULL COMMENT '城市',
  `province` varchar(255) DEFAULT NULL COMMENT '省份',
  `country` varchar(255) DEFAULT NULL COMMENT '国家',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT '类型 1-小程序 2-公众号 3-APP'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `user_wx`
--

INSERT INTO `user_wx` (`id`, `createTime`, `updateTime`, `unionid`, `openid`, `avatarUrl`, `nickName`, `gender`, `language`, `city`, `province`, `country`, `type`) VALUES
(1, '2023-09-05 10:21:39.769323', '2023-09-05 10:21:39.769323', NULL, 'oabDj4oo1wQlQXlYmcz2ncvdfw0U', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', '微信用户', 0, '', '', '', '', 0);

--
-- 转储表的索引
--

--
-- 表的索引 `app_articles`
--
ALTER TABLE `app_articles`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_cf1e24400c8ecee98bb4fe81b3` (`createTime`) USING BTREE,
  ADD KEY `IDX_f644354224c592e6526c44fa5b` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_article_likes`
--
ALTER TABLE `app_article_likes`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_bdf03c51e417caa0e41534bf92` (`createTime`) USING BTREE,
  ADD KEY `IDX_77c40a047c5646960f71fd5a2d` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_banner`
--
ALTER TABLE `app_banner`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_42d4030eda4d0912b35a452966` (`createTime`) USING BTREE,
  ADD KEY `IDX_7b471242826cfcd68aafd81937` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_category`
--
ALTER TABLE `app_category`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_9888ca0fdeb8fe7d2b44f624fc` (`createTime`) USING BTREE,
  ADD KEY `IDX_f86e8ea52e3a989ce2c206d09e` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_circle`
--
ALTER TABLE `app_circle`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_086c3e82e04eed0bc2ec0150db` (`createTime`) USING BTREE,
  ADD KEY `IDX_84d32d1f301807996bdd989e2b` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_comments`
--
ALTER TABLE `app_comments`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_b2482598056fe53c51e30d92f1` (`createTime`) USING BTREE,
  ADD KEY `IDX_b074f6f9c0b46f5e2ac1d18609` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_follows`
--
ALTER TABLE `app_follows`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_059ca01d13e02d732008d48dbc` (`createTime`) USING BTREE,
  ADD KEY `IDX_a4b4176a6e480529f1edf5c897` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_menu`
--
ALTER TABLE `app_menu`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_1cb9231ba96a76982e37847f64` (`createTime`) USING BTREE,
  ADD KEY `IDX_4f04c487c40211affda6bf4070` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_notice`
--
ALTER TABLE `app_notice`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_976b3fed4210d08ffa61efa70f` (`createTime`) USING BTREE,
  ADD KEY `IDX_737dcdaae074c15179cf30b350` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_school`
--
ALTER TABLE `app_school`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_6ae26cb31ec10f589de9a299de` (`createTime`) USING BTREE,
  ADD KEY `IDX_94e271c28af573506835d43c31` (`updateTime`) USING BTREE;

--
-- 表的索引 `app_user`
--
ALTER TABLE `app_user`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_5c6fde5086d4877a22f461b3b2` (`createTime`) USING BTREE,
  ADD KEY `IDX_26a33fc09b587089f836bc4116` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_conf`
--
ALTER TABLE `base_sys_conf`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_9be195d27767b4485417869c3a` (`cKey`) USING BTREE,
  ADD KEY `IDX_905208f206a3ff9fd513421971` (`createTime`) USING BTREE,
  ADD KEY `IDX_4c6f27f6ecefe51a5a196a047a` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_department`
--
ALTER TABLE `base_sys_department`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_be4c53cd671384fa588ca9470a` (`createTime`) USING BTREE,
  ADD KEY `IDX_ca1473a793961ec55bc0c8d268` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_log`
--
ALTER TABLE `base_sys_log`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_51a2caeb5713efdfcb343a8772` (`userId`) USING BTREE,
  ADD KEY `IDX_a03a27f75cf8d502b3060823e1` (`ipAddr`) USING BTREE,
  ADD KEY `IDX_c9382b76219a1011f7b8e7bcd1` (`createTime`) USING BTREE,
  ADD KEY `IDX_bfd44e885b470da43bcc39aaa7` (`updateTime`) USING BTREE,
  ADD KEY `IDX_938f886fb40e163db174b7f6c3` (`action`) USING BTREE,
  ADD KEY `IDX_24e18767659f8c7142580893f2` (`ip`) USING BTREE;

--
-- 表的索引 `base_sys_menu`
--
ALTER TABLE `base_sys_menu`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_05e3d6a56604771a6da47ebf8e` (`createTime`) USING BTREE,
  ADD KEY `IDX_d5203f18daaf7c3fe0ab34497f` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_param`
--
ALTER TABLE `base_sys_param`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_cf19b5e52d8c71caa9c4534454` (`keyName`) USING BTREE,
  ADD KEY `IDX_7bcb57371b481d8e2d66ddeaea` (`createTime`) USING BTREE,
  ADD KEY `IDX_479122e3bf464112f7a7253dac` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_role`
--
ALTER TABLE `base_sys_role`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_469d49a5998170e9550cf113da` (`name`) USING BTREE,
  ADD UNIQUE KEY `IDX_f3f24fbbccf00192b076e549a7` (`label`) USING BTREE,
  ADD KEY `IDX_6f01184441dec49207b41bfd92` (`createTime`) USING BTREE,
  ADD KEY `IDX_d64ca209f3fc52128d9b20e97b` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_role_department`
--
ALTER TABLE `base_sys_role_department`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_e881a66f7cce83ba431cf20194` (`createTime`) USING BTREE,
  ADD KEY `IDX_cbf48031efee5d0de262965e53` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_role_menu`
--
ALTER TABLE `base_sys_role_menu`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_3641f81d4201c524a57ce2aa54` (`createTime`) USING BTREE,
  ADD KEY `IDX_f860298298b26e7a697be36e5b` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_user`
--
ALTER TABLE `base_sys_user`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_469ad55973f5b98930f6ad627b` (`username`) USING BTREE,
  ADD KEY `IDX_0cf944da378d70a94f5fefd803` (`departmentId`) USING BTREE,
  ADD KEY `IDX_9ec6d7ac6337eafb070e4881a8` (`phone`) USING BTREE,
  ADD KEY `IDX_ca8611d15a63d52aa4e292e46a` (`createTime`) USING BTREE,
  ADD KEY `IDX_a0f2f19cee18445998ece93ddd` (`updateTime`) USING BTREE;

--
-- 表的索引 `base_sys_user_role`
--
ALTER TABLE `base_sys_user_role`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_fa9555e03e42fce748c9046b1c` (`createTime`) USING BTREE,
  ADD KEY `IDX_3e36c0d2b1a4c659c6b4fc64b3` (`updateTime`) USING BTREE;

--
-- 表的索引 `cloud_db`
--
ALTER TABLE `cloud_db`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_a6d2bc6059959e15fd0a04b990` (`className`) USING BTREE,
  ADD UNIQUE KEY `IDX_25a096d065be23ac2af376718c` (`tableName`) USING BTREE,
  ADD KEY `IDX_a309f521cedab3a8a9db207615` (`createTime`) USING BTREE,
  ADD KEY `IDX_3c339b2d0e9ef6b9f3c4d07099` (`updateTime`) USING BTREE;

--
-- 表的索引 `cloud_func_info`
--
ALTER TABLE `cloud_func_info`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_e001a4ce107bc204773d8d0c13` (`createTime`) USING BTREE,
  ADD KEY `IDX_e5fe2e2b719335b9e068118095` (`updateTime`) USING BTREE;

--
-- 表的索引 `cloud_func_log`
--
ALTER TABLE `cloud_func_log`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_90161aef313b4ad0142a2553c0` (`createTime`) USING BTREE,
  ADD KEY `IDX_29009a983d2279b6e62fd377d3` (`updateTime`) USING BTREE,
  ADD KEY `IDX_28e9248fd3a99e7c11c95fc61d` (`infoId`) USING BTREE;

--
-- 表的索引 `demo_goods`
--
ALTER TABLE `demo_goods`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_5075bf301ed9c39b5ca534231c` (`createTime`) USING BTREE,
  ADD KEY `IDX_82703e0477d1219261277df718` (`updateTime`) USING BTREE,
  ADD KEY `IDX_85a70ee36c7c1b0a04bfa1ed27` (`title`) USING BTREE;

--
-- 表的索引 `dict_info`
--
ALTER TABLE `dict_info`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_5c311a4af30de1181a5d7a7cc2` (`createTime`) USING BTREE,
  ADD KEY `IDX_10362a62adbf120821fff209d8` (`updateTime`) USING BTREE;

--
-- 表的索引 `dict_type`
--
ALTER TABLE `dict_type`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_69734e5c2d29cc2139d5078f2c` (`createTime`) USING BTREE,
  ADD KEY `IDX_6cccb2e33846cd354e8dc0e0ef` (`updateTime`) USING BTREE;

--
-- 表的索引 `func_user`
--
ALTER TABLE `func_user`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_4e38b83a5f1b661df3c800384d` (`createTime`) USING BTREE,
  ADD KEY `IDX_ad98364413a8c252b0eca2cd8c` (`updateTime`) USING BTREE;

--
-- 表的索引 `iot_device`
--
ALTER TABLE `iot_device`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_5d666ab25bde553237e9a3758d` (`uniqueId`) USING BTREE,
  ADD KEY `IDX_f055b8edd446732d19292629cf` (`createTime`) USING BTREE,
  ADD KEY `IDX_bfe886be31b8f2b6ac54d9260f` (`updateTime`) USING BTREE,
  ADD KEY `IDX_ba4dbc891378e1fe1fcae646b8` (`status`) USING BTREE;

--
-- 表的索引 `iot_message`
--
ALTER TABLE `iot_message`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_2b15e343a5411f334d35ca0855` (`createTime`) USING BTREE,
  ADD KEY `IDX_740b1fd71845756023f3f0bb6a` (`updateTime`) USING BTREE,
  ADD KEY `IDX_e36c4ce1b94e0ff55f93cc036a` (`deviceId`) USING BTREE,
  ADD KEY `IDX_a3694963ea98b7f5e283a6be40` (`type`) USING BTREE;

--
-- 表的索引 `query-result-cache`
--
ALTER TABLE `query-result-cache`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- 表的索引 `recycle_data`
--
ALTER TABLE `recycle_data`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_59fc783673f4a322e9c83e0599` (`createTime`) USING BTREE,
  ADD KEY `IDX_c6a499c4a4fcd37f2930d27816` (`updateTime`) USING BTREE,
  ADD KEY `IDX_f3ed09ba7090f3eb378cb83b5b` (`userId`) USING BTREE;

--
-- 表的索引 `space_info`
--
ALTER TABLE `space_info`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_eb1da2f304c760846b5add09b3` (`createTime`) USING BTREE,
  ADD KEY `IDX_d7a2539961e9aacba8b353f3c9` (`updateTime`) USING BTREE,
  ADD KEY `IDX_0975633032bfe6574468b3a4ae` (`fileId`) USING BTREE;

--
-- 表的索引 `space_type`
--
ALTER TABLE `space_type`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_6669449501d275f367ca295472` (`createTime`) USING BTREE,
  ADD KEY `IDX_0749b509b68488caecd4cc2bbc` (`updateTime`) USING BTREE;

--
-- 表的索引 `task_info`
--
ALTER TABLE `task_info`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_6ced02f467e59bd6306b549bb0` (`createTime`) USING BTREE,
  ADD KEY `IDX_2adc6f9c241391126f27dac145` (`updateTime`) USING BTREE;

--
-- 表的索引 `task_log`
--
ALTER TABLE `task_log`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_b9af0e100be034924b270aab31` (`createTime`) USING BTREE,
  ADD KEY `IDX_8857d8d43d38bebd7159af1fa6` (`updateTime`) USING BTREE,
  ADD KEY `IDX_1142dfec452e924b346f060fda` (`taskId`) USING BTREE;

--
-- 表的索引 `user_info`
--
ALTER TABLE `user_info`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `IDX_6edeceee578056a2c1e493563a` (`unionid`) USING BTREE,
  ADD UNIQUE KEY `IDX_9234e7bac72991a93b172618e2` (`phone`) USING BTREE,
  ADD KEY `IDX_e6386e92c288d85dbc43ac53f7` (`createTime`) USING BTREE,
  ADD KEY `IDX_5271afbb87138d688b6220b589` (`updateTime`) USING BTREE;

--
-- 表的索引 `user_wx`
--
ALTER TABLE `user_wx`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD KEY `IDX_e23b473abf5a6b00e44f3fd842` (`createTime`) USING BTREE,
  ADD KEY `IDX_049adb91204e94c1ede5e6dd23` (`updateTime`) USING BTREE,
  ADD KEY `IDX_d22b5fa040a01ec1b09e1e181e` (`unionid`) USING BTREE,
  ADD KEY `IDX_7946849febadd93cf81fc2b53f` (`openid`) USING BTREE;

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `app_articles`
--
ALTER TABLE `app_articles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=35;

--
-- 使用表AUTO_INCREMENT `app_article_likes`
--
ALTER TABLE `app_article_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=139;

--
-- 使用表AUTO_INCREMENT `app_banner`
--
ALTER TABLE `app_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=5;

--
-- 使用表AUTO_INCREMENT `app_category`
--
ALTER TABLE `app_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `app_circle`
--
ALTER TABLE `app_circle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=7;

--
-- 使用表AUTO_INCREMENT `app_comments`
--
ALTER TABLE `app_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=79;

--
-- 使用表AUTO_INCREMENT `app_follows`
--
ALTER TABLE `app_follows`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=27;

--
-- 使用表AUTO_INCREMENT `app_menu`
--
ALTER TABLE `app_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `app_notice`
--
ALTER TABLE `app_notice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `app_school`
--
ALTER TABLE `app_school`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `app_user`
--
ALTER TABLE `app_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2815;

--
-- 使用表AUTO_INCREMENT `base_sys_conf`
--
ALTER TABLE `base_sys_conf`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `base_sys_department`
--
ALTER TABLE `base_sys_department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=14;

--
-- 使用表AUTO_INCREMENT `base_sys_log`
--
ALTER TABLE `base_sys_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=412824;

--
-- 使用表AUTO_INCREMENT `base_sys_menu`
--
ALTER TABLE `base_sys_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=526;

--
-- 使用表AUTO_INCREMENT `base_sys_param`
--
ALTER TABLE `base_sys_param`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=9;

--
-- 使用表AUTO_INCREMENT `base_sys_role`
--
ALTER TABLE `base_sys_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=14;

--
-- 使用表AUTO_INCREMENT `base_sys_role_department`
--
ALTER TABLE `base_sys_role_department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=29;

--
-- 使用表AUTO_INCREMENT `base_sys_role_menu`
--
ALTER TABLE `base_sys_role_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=571;

--
-- 使用表AUTO_INCREMENT `base_sys_user`
--
ALTER TABLE `base_sys_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=29;

--
-- 使用表AUTO_INCREMENT `base_sys_user_role`
--
ALTER TABLE `base_sys_user_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=55;

--
-- 使用表AUTO_INCREMENT `cloud_db`
--
ALTER TABLE `cloud_db`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=14;

--
-- 使用表AUTO_INCREMENT `cloud_func_info`
--
ALTER TABLE `cloud_func_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `cloud_func_log`
--
ALTER TABLE `cloud_func_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `demo_goods`
--
ALTER TABLE `demo_goods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `dict_info`
--
ALTER TABLE `dict_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=43;

--
-- 使用表AUTO_INCREMENT `dict_type`
--
ALTER TABLE `dict_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=21;

--
-- 使用表AUTO_INCREMENT `func_user`
--
ALTER TABLE `func_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `iot_device`
--
ALTER TABLE `iot_device`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `iot_message`
--
ALTER TABLE `iot_message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- 使用表AUTO_INCREMENT `query-result-cache`
--
ALTER TABLE `query-result-cache`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `recycle_data`
--
ALTER TABLE `recycle_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=10;

--
-- 使用表AUTO_INCREMENT `space_info`
--
ALTER TABLE `space_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=104;

--
-- 使用表AUTO_INCREMENT `space_type`
--
ALTER TABLE `space_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=15;

--
-- 使用表AUTO_INCREMENT `task_info`
--
ALTER TABLE `task_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `task_log`
--
ALTER TABLE `task_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=56;

--
-- 使用表AUTO_INCREMENT `user_info`
--
ALTER TABLE `user_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `user_wx`
--
ALTER TABLE `user_wx`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=2;
COMMIT;

/*!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 */;