123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494 |
- -- --------------------------------------------------------
- -- 主机: 127.0.0.1
- -- 服务器版本: 5.7.20-log - MySQL Community Server (GPL)
- -- 服务器操作系统: Win64
- -- HeidiSQL 版本: 10.2.0.5670
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8 */;
- /*!50503 SET NAMES utf8mb4 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- -- 导出 ly-fms 的数据库结构
- DROP DATABASE IF EXISTS `ly-fms`;
- CREATE DATABASE IF NOT EXISTS `ly-fms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
- USE `ly-fms`;
- DROP TABLE IF EXISTS `t_peony`;
- CREATE TABLE IF NOT EXISTS `t_peony` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
- `kind` varchar(500) DEFAULT NULL COMMENT '品种',
- `name` varchar(500) DEFAULT NULL COMMENT '名字',
- `color` varchar(500) DEFAULT NULL COMMENT '颜色',
- `image_url` text COMMENT '图片链接',
- `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='牡丹花';
- INSERT INTO `t_peony` (`id`, `kind`, `name`, `color`, `image_url`, `create_time`, `update_time`) VALUES
- (5, '复色类', '什样锦', '红色', 'https://bkimg.cdn.bcebos.com/pic/3c6d55fbb2fb43160ee185da2aa4462308f7d390?x-bce-process=image/watermark,g_7,image_d2F0ZXIvYmFpa2UxNTA=,xp_5,yp_5', '2020-04-06 22:02:32', '2020-04-06 22:03:30'),
- (6, '绿色', '绿香球', '绿色', '11', '2020-04-06 22:14:35', '2020-04-06 22:17:51'),
- (7, '墨紫色类', '冠世墨玉', '紫色', '34534534534', '2020-04-06 22:15:19', '2020-04-06 22:18:21');
- -- 导出 表 ly-fms.t_department 结构
- DROP TABLE IF EXISTS `t_department`;
- CREATE TABLE IF NOT EXISTS `t_department` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '部门主键id',
- `name` varchar(50) NOT NULL COMMENT '部门名称',
- `short_name` varchar(50) DEFAULT NULL COMMENT '部门简称',
- `manager_id` int(10) unsigned DEFAULT NULL COMMENT '部门负责人id',
- `parent_id` int(10) unsigned DEFAULT NULL COMMENT '部门的父级id',
- `sort` int(10) NOT NULL COMMENT '部门排序',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `parent_id` (`parent_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';
- -- 正在导出表 ly-fms.t_department 的数据:~20 rows (大约)
- /*!40000 ALTER TABLE `t_department` DISABLE KEYS */;
- INSERT INTO `t_department` (`id`, `name`, `short_name`, `manager_id`, `parent_id`, `sort`, `update_time`, `create_time`) VALUES
- (1, '1024创新实验室', 'ZWGWL', 16, 0, 1, '2019-04-03 10:41:25', '2019-04-03 10:41:25'),
- (2, '二级部门-2', NULL, 15, 1, 17, '2019-04-15 16:45:10', '2019-04-15 16:45:10'),
- (4, '二级部门-1', '管理', 14, 1, 20, '2019-04-17 16:14:55', '2019-04-17 16:14:55'),
- (8, '三级部门-1', NULL, NULL, 4, 8, '2019-04-25 12:25:52', '2019-04-25 12:25:52'),
- (9, '四级部门-1', NULL, NULL, 8, 9, '2019-04-25 12:26:36', '2019-04-25 12:26:36'),
- (10, '五级部门-1', NULL, NULL, 9, 10, '2019-04-25 12:26:49', '2019-04-25 12:26:49'),
- (11, '六级部门-1', NULL, NULL, 10, 11, '2019-04-25 12:26:59', '2019-04-25 12:26:59'),
- (12, '七级部门-1', NULL, NULL, 11, 12, '2019-04-25 12:27:18', '2019-04-25 12:27:18'),
- (13, '八级部门-1', NULL, NULL, 12, 13, '2019-04-25 12:27:34', '2019-04-25 12:27:34'),
- (14, '九级部门-1', NULL, NULL, 13, 14, '2019-04-25 12:27:47', '2019-04-25 12:27:47'),
- (15, '十级部门-1', NULL, NULL, 14, 15, '2019-04-25 12:28:16', '2019-04-25 12:28:16'),
- (16, '十一级部门部门部部门门嘻嘻哈哈-1', NULL, 13, 15, 16, '2019-04-25 14:56:40', '2019-04-25 14:56:40'),
- (17, '信息中心', NULL, 16, 1, 4, '2019-04-26 11:53:50', '2019-04-26 11:53:50'),
- (18, '测试部门', NULL, 16, 17, 18, '2019-04-26 11:54:06', '2019-04-26 11:54:06'),
- (19, '张娇测试', NULL, NULL, 2, 22, '2019-04-26 14:36:18', '2019-04-26 14:36:18'),
- (20, '子部门', NULL, NULL, 2, 23, '2019-04-26 14:36:28', '2019-04-26 14:36:28'),
- (22, '张静如', NULL, 16, 1, 2, '2019-04-28 14:21:44', '2019-04-28 14:21:44'),
- (23, '张静如2', NULL, 22, 4, 19, '2019-04-28 14:22:48', '2019-04-28 14:22:48'),
- (24, '测试', NULL, 18, 23, 24, '2019-04-29 10:12:42', '2019-04-29 10:12:42'),
- (25, '测试', NULL, 18, 23, 25, '2019-04-29 10:12:42', '2019-04-29 10:12:42');
- /*!40000 ALTER TABLE `t_department` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_email 结构
- DROP TABLE IF EXISTS `t_email`;
- CREATE TABLE IF NOT EXISTS `t_email` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
- `to_emails` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收件人',
- `send_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '发送状态 0未发送 1已发送',
- `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮件内容',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_email 的数据:~56 rows (大约)
- /*!40000 ALTER TABLE `t_email` DISABLE KEYS */;
- INSERT INTO `t_email` (`id`, `title`, `to_emails`, `send_status`, `content`, `create_time`, `update_time`) VALUES
- (20, '新增测试12345', '新增测试@11.com', 1, '<p>这是内容</p>', '2019-08-30 15:35:12', '2019-08-30 15:35:12'),
- (21, 'b', 'asdf@33.com', 1, '<p>c</p>', '2019-09-06 14:25:33', '2019-09-06 14:25:33'),
- (23, 'string', 'string', 0, 'string', '2019-09-06 06:55:01', '2019-09-06 06:55:01'),
- (24, 'string', 'string', 0, 'string', '2019-09-06 06:55:01', '2019-09-06 06:55:01'),
- (26, 'string', 'string', 0, 'string', '2019-09-06 07:01:32', '2019-09-06 07:01:32'),
- (27, 'string', 'string', 0, 'string', '2019-09-06 07:01:32', '2019-09-06 07:01:32'),
- (37, 'ewqwe', '适者生存@22.cc', 1, '<p>qweqwe</p>', '2019-11-09 10:00:46', '2019-11-09 10:00:46'),
- (38, 'ewqwe', '适者生存@22.cc', 1, '<p>qweqwe</p>', '2019-11-09 10:00:49', '2019-11-09 10:00:49'),
- (39, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:54', '2019-11-09 10:04:54'),
- (40, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:57', '2019-11-09 10:04:57'),
- (41, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:57', '2019-11-09 10:04:57'),
- (42, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:58', '2019-11-09 10:04:58'),
- (43, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:59', '2019-11-09 10:04:59'),
- (44, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:04:59', '2019-11-09 10:04:59'),
- (45, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:05:16', '2019-11-09 10:05:16'),
- (46, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:06:29', '2019-11-09 10:06:29'),
- (47, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:07:02', '2019-11-09 10:07:02'),
- (48, 'dsfds', 'dsfsd@qq.ccc', 1, '<p>fsdfs</p>', '2019-11-09 10:07:16', '2019-11-09 10:07:16'),
- (49, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:13', '2019-11-09 10:08:13'),
- (50, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:30', '2019-11-09 10:08:30'),
- (51, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:08:50', '2019-11-09 10:08:50'),
- (52, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:09:09', '2019-11-09 10:09:09'),
- (53, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:09:31', '2019-11-09 10:09:31'),
- (54, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:12:24', '2019-11-09 10:12:24'),
- (55, '2342', '11@ss.cc', 1, '<p>234234</p>', '2019-11-09 10:13:13', '2019-11-09 10:13:13'),
- (56, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:20:42', '2019-11-09 10:20:42'),
- (57, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:20:52', '2019-11-09 10:20:52'),
- (58, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:16', '2019-11-09 10:21:16'),
- (59, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:24', '2019-11-09 10:21:24'),
- (60, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:30', '2019-11-09 10:21:30'),
- (61, 'asdasd', '3423@aqq.cc', 0, '<p>asdasd</p>', '2019-11-09 10:21:53', '2019-11-09 10:21:53'),
- (62, 'a21312', '23423@qq.cc', 0, '<p>asdasdas</p>', '2019-11-09 10:23:40', '2019-11-09 10:23:40'),
- (63, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:12', '2019-11-15 15:35:12'),
- (64, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:15', '2019-11-15 15:35:15'),
- (65, '11', '1234@qq.com', 0, '<p>23</p>', '2019-11-15 15:35:16', '2019-11-15 15:35:16'),
- (66, 'eeee', '1234@qq.com', 0, '<p> eee2233<br></p>', '2019-11-15 17:00:00', '2019-11-15 17:00:00'),
- (67, 'eeee', '1234@qq.com', 0, '<p> eee2233<br></p>', '2019-11-15 17:00:03', '2019-11-15 17:00:03'),
- (68, 'eeee', '1234@qq.com', 0, '<p> eee2233<br></p>', '2019-11-15 17:00:04', '2019-11-15 17:00:04'),
- (69, '22223', '1017146812@qq.com', 0, '<p> e34233<br></p>', '2019-11-15 17:00:33', '2019-11-15 17:00:33'),
- (70, '22223', '1017146812@qq.com', 0, '<p> e34233<br></p>', '2019-11-15 17:00:34', '2019-11-15 17:00:34'),
- (71, '22223', '1017146812@qq.com', 0, '<p> e34233<br></p>', '2019-11-15 17:00:34', '2019-11-15 17:00:34'),
- (72, '22223', '12232', 0, '<p> e34233<br></p>', '2019-11-15 17:00:49', '2019-11-15 17:00:49'),
- (73, '22223', '12232@qq.com', 0, '<p> e34233<br></p>', '2019-11-15 17:00:56', '2019-11-15 17:00:56'),
- (74, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 08:51:44', '2019-11-16 08:51:44'),
- (75, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:05:10', '2019-11-16 09:05:10'),
- (76, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:05:14', '2019-11-16 09:05:14'),
- (77, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:06:34', '2019-11-16 09:06:34'),
- (78, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:09', '2019-11-16 09:07:09'),
- (79, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:30', '2019-11-16 09:07:30'),
- (80, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:07:32', '2019-11-16 09:07:32'),
- (81, 'dsasdasd', 'asdas@qq.com', 0, '<p>asdasd</p>', '2019-11-16 09:08:29', '2019-11-16 09:08:29'),
- (82, 'sdfs', 'ss@ss.cc', 0, '<p>dsdsf</p>', '2019-11-16 09:08:46', '2019-11-16 09:08:46'),
- (83, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:18', '2019-11-16 09:09:18'),
- (84, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:42', '2019-11-16 09:09:42'),
- (85, 'asdasd', 'asd@qq.vv', 0, '<p>asdas</p>', '2019-11-16 09:09:46', '2019-11-16 09:09:46'),
- (86, 'dasdad', 'dasda@ss.cc', 1, '<p>dasasdas</p>', '2019-11-16 09:10:05', '2019-11-16 09:10:05');
- /*!40000 ALTER TABLE `t_email` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_employee 结构
- DROP TABLE IF EXISTS `t_employee`;
- CREATE TABLE IF NOT EXISTS `t_employee` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
- `login_name` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '登录帐号',
- `login_pwd` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '登录密码',
- `actual_name` varchar(30) CHARACTER SET utf8 NOT NULL COMMENT '员工名称',
- `nick_name` varchar(30) DEFAULT '' COMMENT '别名',
- `phone` varchar(15) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机号码',
- `id_card` varchar(18) CHARACTER SET utf8 DEFAULT NULL COMMENT '身份证',
- `birthday` date DEFAULT NULL COMMENT '出生日期',
- `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
- `department_id` int(10) unsigned NOT NULL COMMENT '部门id',
- `is_leave` int(10) NOT NULL DEFAULT '0' COMMENT '是否离职1是',
- `is_disabled` int(10) NOT NULL DEFAULT '0' COMMENT '是否被禁用 0否1是',
- `remark` varchar(200) DEFAULT NULL COMMENT '备注',
- `create_user` int(10) unsigned NOT NULL COMMENT '创建者id',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `is_delete` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除0否 1是',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COMMENT='员工表';
- -- 正在导出表 ly-fms.t_employee 的数据:~28 rows (大约)
- /*!40000 ALTER TABLE `t_employee` DISABLE KEYS */;
- INSERT INTO `t_employee` (`id`, `login_name`, `login_pwd`, `actual_name`, `nick_name`, `phone`, `id_card`, `birthday`, `email`, `department_id`, `is_leave`, `is_disabled`, `remark`, `create_user`, `update_time`, `create_time`, `is_delete`) VALUES
- (1, 'sa', 'c655798e4648c540812a1b8f48759af7', '管理员', '15515515515', '13112312131', '410306199202020020', '1992-02-02', NULL, 1, 0, 0, NULL, 0, '2019-04-27 09:56:17', '2018-05-11 09:38:54', 0),
- (11, 'role1', 'c655798e4648c540812a1b8f48759af7', '角色测试1', '', '18123245230', '', '1970-01-01', '', 4, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 12:30:22', 0),
- (12, 'role2', 'c655798e4648c540812a1b8f48759af7', '角色测试2', '', '18121451241', '', NULL, '', 4, 0, 0, NULL, 1, '2019-08-01 10:04:38', '2019-04-25 12:31:11', 0),
- (13, 'lihaifan', 'c655798e4648c540812a1b8f48759af7', 'lihaifan', '', '18399485774', '', NULL, '', 1, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 13:50:44', 0),
- (14, 'lipeng', 'c655798e4648c540812a1b8f48759af7', '李鹏1', '', '13937988294', '', NULL, '', 2, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-25 14:34:47', 0),
- (15, 'huangwenli', 'c655798e4648c540812a1b8f48759af7', '黄文丽', '', '15515515515', '', NULL, '', 16, 0, 0, NULL, 1, '2019-04-27 09:56:17', '2019-04-26 10:05:05', 0),
- (16, 'huangwenli1', 'c655798e4648c540812a1b8f48759af7', '黄文丽', '', '15515515515', '', NULL, '', 15, 0, 0, NULL, 1, '2019-04-27 14:04:19', '2019-04-26 10:25:04', 0),
- (17, 'zhangjiao', 'c655798e4648c540812a1b8f48759af7', '张娇', '阿娇', '15670390391', '410305199102020020', '1991-02-02', '86484@qq.com', 19, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:37:23', 0),
- (18, 'zhangjiao1', 'c655798e4648c540812a1b8f48759af7', '张娇1', '', '15670390391', '', '2019-04-18', '6666@qq.com', 20, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:45:55', 0),
- (19, 'zhenxiaocang', 'c655798e4648c540812a1b8f48759af7', '珍小藏', '', '15670390391', '', NULL, '', 19, 0, 1, NULL, 1, '2019-09-09 08:34:35', '2019-04-26 14:46:57', 0),
- (20, 'matengfei', 'c655798e4648c540812a1b8f48759af7', '马腾飞', '', '15670390393', '', NULL, '', 19, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-04-26 14:47:24', 0),
- (21, 'ceshi123', 'c655798e4648c540812a1b8f48759af7', '测试人员', '', '18829938477', '', NULL, '', 1, 0, 1, NULL, 13, '2019-04-27 09:56:17', '2019-04-27 09:38:07', 1),
- (22, 'zhangjingru', 'c655798e4648c540812a1b8f48759af7', '张静如', '', '15600000000', '', NULL, '', 1, 0, 0, NULL, 1, '2019-09-04 09:06:47', '2019-04-28 14:05:03', 0),
- (23, 'sdfsdfdsfsdfdsfdsf', 'c655798e4648c540812a1b8f48759af7', 'werewr', '', '15698585858', '', NULL, '', 19, 0, 0, NULL, 1, '2019-09-05 16:13:03', '2019-04-28 16:26:27', 0),
- (25, 'shq2019', 'c655798e4648c540812a1b8f48759af7', 'shq', 'shq', '18798801298', '410281199309024040', '1993-09-02', '', 17, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-05-05 09:13:41', 0),
- (26, 'zhangjiao666', 'c655798e4648c540812a1b8f48759af7', 'tom我是五个字12', '', '15612345678', '', NULL, '', 18, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-05-05 15:34:10', 0),
- (28, 'dfsfgds', 'c655798e4648c540812a1b8f48759af7', 'fds', '', '15854127845', '', NULL, '', 22, 0, 1, NULL, 1, '2019-09-06 08:58:40', '2019-05-06 10:36:57', 0),
- (29, 'abcabc', 'c655798e4648c540812a1b8f48759af7', 'abccba', 'aaabac', '13311112222', '', NULL, '', 17, 0, 0, NULL, 1, '2019-08-05 16:33:57', '2019-07-10 17:00:58', 0),
- (30, 'gengweigang', 'c655798e4648c540812a1b8f48759af7', '耿为刚', 'geng', '15038588418', '', NULL, '', 17, 0, 0, NULL, 1, '2019-08-08 14:35:51', '2019-08-08 14:35:51', 0),
- (31, 'gengweigang1', 'c655798e4648c540812a1b8f48759af7', '耿为刚1', '这是别名', '15038588418', '410322193312123232', '1933-12-12', '32@qq.com', 18, 0, 0, NULL, 30, '2019-08-23 09:27:22', '2019-08-23 09:25:50', 0),
- (32, 'ceshi123', 'c655798e4648c540812a1b8f48759af7', '测试', '测试', '15670702651', '', NULL, '', 17, 0, 0, NULL, 1, '2019-09-04 09:05:48', '2019-09-03 11:48:04', 0),
- (33, 'ceshi321', 'c655798e4648c540812a1b8f48759af7', '测试', '测试', '15670702651', '', NULL, '', 17, 0, 1, NULL, 1, '2019-09-03 15:51:16', '2019-09-03 11:49:17', 0),
- (34, 'ceshi123321', 'c655798e4648c540812a1b8f48759af7', '123', '', '15600000000', '', NULL, '', 22, 0, 1, NULL, 1, '2019-09-06 08:58:37', '2019-09-04 09:13:54', 0),
- (35, 'guoqingfeng', 'c655798e4648c540812a1b8f48759af7', '郭青枫', '', '15670702651', '', NULL, '', 18, 0, 0, NULL, 1, '2019-09-04 15:09:00', '2019-09-04 15:09:00', 0),
- (36, 'li327263458', 'c655798e4648c540812a1b8f48759af7', 'lipeng', '', '13937988294', '', NULL, '', 17, 0, 0, NULL, 1, '2019-09-09 17:01:39', '2019-09-09 17:01:39', 0),
- (37, 'test123', 'c655798e4648c540812a1b8f48759af7', 'test', '', '13211110201', '', NULL, '', 18, 0, 1, NULL, 1, '2019-11-14 16:08:08', '2019-11-08 09:32:39', 0),
- (38, 'tiantian', 'c655798e4648c540812a1b8f48759af7', '天天管理员', '', '13574502368', '', NULL, '', 17, 0, 0, NULL, 1, '2019-11-14 02:08:08', '2019-11-08 11:09:46', 0),
- (39, 'wang13211111', 'c655798e4648c540812a1b8f48759af7', 'ceshi111', 'dddd', '13244553212', '', NULL, '', 25, 0, 0, NULL, 38, '2019-11-15 17:14:34', '2019-11-15 17:03:04', 0);
- /*!40000 ALTER TABLE `t_employee` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_file 结构
- DROP TABLE IF EXISTS `t_file`;
- CREATE TABLE IF NOT EXISTS `t_file` (
- `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
- `module_id` varchar(50) NOT NULL COMMENT '相关业务id',
- `module_type` varchar(50) NOT NULL COMMENT '相关业务类型',
- `file_name` varchar(255) DEFAULT NULL COMMENT '文件名称',
- `file_size` varchar(255) DEFAULT NULL COMMENT '文件大小',
- `file_type` varchar(50) DEFAULT NULL COMMENT '文件类型,程序中枚举控制,文件类型:如身份证正面,三证合一等等',
- `file_path` varchar(255) NOT NULL COMMENT '文件key,用于文件下载',
- `file_location_type` int(10) NOT NULL COMMENT '文件位置类型',
- `creater_user` int(10) NOT NULL COMMENT '创建人,即上传人',
- `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '上次更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `module_id_module_type` (`module_id`,`module_type`) USING BTREE,
- KEY `module_type` (`module_type`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
- -- 正在导出表 ly-fms.t_file 的数据:~23 rows (大约)
- /*!40000 ALTER TABLE `t_file` DISABLE KEYS */;
- INSERT INTO `t_file` (`id`, `module_id`, `module_type`, `file_name`, `file_size`, `file_type`, `file_path`, `file_location_type`, `creater_user`, `update_time`, `create_time`) VALUES
- (1, '1', '1', '阿里云1.jpg', NULL, NULL, 'backUser/config/d1788b717be24f14ba526f25397b936f', 2, 1, NULL, '2019-07-05 10:38:15'),
- (2, '2', '1', '1.jpg', NULL, NULL, 'backUser/config/8895ec770c4e4e558c6d9b54eb00dffc', 2, 1, '2019-07-18 09:20:59', '2019-07-18 09:20:25'),
- (3, '3', '1', '随笔.txt', NULL, NULL, 'backUser/config/f5cbc4c9a56f4fa7ad0ba58b0aa5d169', 2, 1, NULL, '2019-07-18 09:22:47'),
- (4, '3', '1', '1.jpg', NULL, NULL, 'backUser/config/2019071809245603e0a4e449a4bf3aa28ee731c309040.jpg', 1, 1, NULL, '2019-07-18 09:24:51'),
- (6, '4', '1', '1.jpg', NULL, NULL, 'backUser/config/ddcb8214ba274dec9bb2c33e0e246391', 3, 1, NULL, '2019-07-19 16:19:43'),
- (7, '5', '1', 'sql.txt', NULL, NULL, 'backUser/config/cfbdf9562c894405b5b6f64f71fa812a', 3, 1, NULL, '2019-07-19 17:41:55'),
- (9, '1', '1', '20190912023241a6132f5713b54e1fb490f4ea88115747.md', NULL, NULL, 'backUser/config/20190912023241a6132f5713b54e1fb490f4ea88115747.md', 1, 1, '2019-09-12 15:25:35', '2019-09-12 14:32:42'),
- (10, '1', '1', '201909120232499804998573f643ff8e58189d23485629.mjs', NULL, NULL, 'backUser/config/201909120232499804998573f643ff8e58189d23485629.mjs', 1, 1, '2019-09-12 15:25:19', '2019-09-12 14:32:50'),
- (11, '1', '1', '201909120326564cdc8df7b8cc49cfb273926877f047f5.json', NULL, NULL, 'backUser/config/201909120326564cdc8df7b8cc49cfb273926877f047f5.json', 1, 1, NULL, '2019-09-12 15:26:56'),
- (12, '1', '1', '201909120343357104b7f1cc684f5797ada35c06aba770.json', NULL, NULL, 'backUser/config/201909120343357104b7f1cc684f5797ada35c06aba770.json', 1, 1, NULL, '2019-09-12 15:43:36'),
- (13, '1', '1', '201909120343427e408141a0ea467ea2e012f7086a6265.json', NULL, NULL, 'backUser/config/201909120343427e408141a0ea467ea2e012f7086a6265.json', 1, 1, NULL, '2019-09-12 15:43:42'),
- (14, '1', '1', '20190912034543b4d3a061fb2e416c899fe2ff6b9327e0.ts', NULL, NULL, 'backUser/config/20190912034543b4d3a061fb2e416c899fe2ff6b9327e0.ts', 1, 1, NULL, '2019-09-12 15:45:43'),
- (15, '1', '1', '20190912034550a5dc04ce79b14a1cb2bb76545c909aa8.md', NULL, NULL, 'backUser/config/20190912034550a5dc04ce79b14a1cb2bb76545c909aa8.md', 1, 1, NULL, '2019-09-12 15:45:51'),
- (16, '1', '1', 'LICENCE', NULL, NULL, 'backUser/config/cc02b99c0ec548f1a2231b70b7d569b8', 2, 1, NULL, '2019-09-12 15:47:22'),
- (17, '1', '1', 'bignumber.min.js', NULL, NULL, 'backUser/config/bda49e8ad6d242fe8735b2023dfbf125', 2, 1, NULL, '2019-09-12 15:47:29'),
- (18, '1', '1', '20190912034880a881fa8fbc841bfb7194ff312bd1058.json', NULL, NULL, 'backUser/config/20190912034880a881fa8fbc841bfb7194ff312bd1058.json', 1, 1, NULL, '2019-09-12 15:48:08'),
- (19, '1', '1', '20190912034816ece14084acf345a79396a0f4347c4e44.md', NULL, NULL, 'backUser/config/20190912034816ece14084acf345a79396a0f4347c4e44.md', 1, 1, NULL, '2019-09-12 15:48:16'),
- (20, '1', '1', '20191024054412fac4b4e04c574c6eab71f91e13a8a0b6.jpg', NULL, NULL, 'backUser/config/20191024054412fac4b4e04c574c6eab71f91e13a8a0b6.jpg', 1, 1, NULL, '2019-10-24 17:44:13'),
- (21, '1', '1', '20191106042073f7ef01bde3046bd8e01928f397230bd.jpg', NULL, NULL, 'backUser/config/20191106042073f7ef01bde3046bd8e01928f397230bd.jpg', 1, 1, NULL, '2019-11-06 02:20:13'),
- (22, '1', '1', '201911130802024b8a2ebf80543a98241bb464682650d.jpg', NULL, NULL, 'backUser/config/201911130802024b8a2ebf80543a98241bb464682650d.jpg', 1, 1, NULL, '2019-11-13 06:02:01'),
- (23, '1', '1', '20191113080210d1d98eea46364d268b2a03fa03f7a446.jpg', NULL, NULL, 'backUser/config/20191113080210d1d98eea46364d268b2a03fa03f7a446.jpg', 1, 1, NULL, '2019-11-13 06:02:14'),
- (24, '1', '1', '20191115043844e92b25e70fb140a1885614b978469ca9.jpg', NULL, NULL, 'backUser/config/20191115043844e92b25e70fb140a1885614b978469ca9.jpg', 1, 38, NULL, '2019-11-15 02:38:45'),
- (25, '1', '1', '20191116060546d3a2c703cb5546b3851612907cc3786f.png', NULL, NULL, 'backUser/config/20191116060546d3a2c703cb5546b3851612907cc3786f.png', 1, 1, NULL, '2019-11-16 10:05:47');
- /*!40000 ALTER TABLE `t_file` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_heart_beat_record 结构
- DROP TABLE IF EXISTS `t_heart_beat_record`;
- CREATE TABLE IF NOT EXISTS `t_heart_beat_record` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
- `project_path` varchar(100) DEFAULT NULL COMMENT '项目名称',
- `server_ip` varchar(200) DEFAULT NULL COMMENT '服务器ip',
- `process_no` int(10) DEFAULT NULL COMMENT '进程号',
- `process_start_time` datetime DEFAULT NULL COMMENT '进程开启时间',
- `heart_beat_time` datetime DEFAULT NULL COMMENT '心跳时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
- -- 正在导出表 ly-fms.t_heart_beat_record 的数据:~2 rows (大约)
- /*!40000 ALTER TABLE `t_heart_beat_record` DISABLE KEYS */;
- INSERT INTO `t_heart_beat_record` (`id`, `project_path`, `server_ip`, `process_no`, `process_start_time`, `heart_beat_time`) VALUES
- (1, '/home/server/smart-admin/dev', '192.168.122.1;172.16.0.145', 14843, '2019-11-16 03:11:50', '2019-11-16 03:58:01'),
- (2, 'F:\\codespace\\idea\\gangquan360\\foundation', '172.16.1.188;192.168.56.1', 227992, '2019-11-16 10:02:39', '2019-11-16 10:06:50');
- /*!40000 ALTER TABLE `t_heart_beat_record` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_id_generator 结构
- DROP TABLE IF EXISTS `t_id_generator`;
- CREATE TABLE IF NOT EXISTS `t_id_generator` (
- `id` int(11) DEFAULT NULL,
- `key_name` varchar(50) NOT NULL COMMENT '英文key',
- `rule_format` varchar(500) NOT NULL COMMENT '规则格式。no_cycle没有周期, year_cycle 年周期, month_cycle月周期, day_cycle 日周期',
- `rule_type` varchar(50) NOT NULL COMMENT '格式[yyyy]表示年,[mm]标识月,[dd]表示日,[nnn]表示三位数字',
- `init_number` int(11) NOT NULL DEFAULT '1' COMMENT '初始值',
- `last_number` int(11) DEFAULT NULL COMMENT '上次产生的id, 默认为空',
- `remark` varchar(1000) NOT NULL COMMENT '备注',
- `update_time` datetime DEFAULT NULL,
- `create_time` datetime NOT NULL,
- UNIQUE KEY `key_name` (`key_name`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='id生成器定义表';
- -- 正在导出表 ly-fms.t_id_generator 的数据:~2 rows (大约)
- /*!40000 ALTER TABLE `t_id_generator` DISABLE KEYS */;
- INSERT INTO `t_id_generator` (`id`, `key_name`, `rule_format`, `rule_type`, `init_number`, `last_number`, `remark`, `update_time`, `create_time`) VALUES
- (2, 'goods_num', '[nnnnnnn]', 'NO_CYCLE', 1, NULL, '商品编号', '2019-04-09 09:48:04', '2019-03-29 14:14:12'),
- (1, 'order', '[yyyy][mm][dd][nnnnn]', 'DAY_CYCLE', 1, 1, '订单编号', '2019-03-30 11:25:42', '2019-03-29 14:14:12');
- /*!40000 ALTER TABLE `t_id_generator` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_id_generator_record 结构
- DROP TABLE IF EXISTS `t_id_generator_record`;
- CREATE TABLE IF NOT EXISTS `t_id_generator_record` (
- `generator_id` int(11) NOT NULL,
- `year` int(11) NOT NULL,
- `month` int(11) NOT NULL,
- `day` int(11) NOT NULL,
- `last_number` int(11) NOT NULL,
- PRIMARY KEY (`generator_id`,`year`,`month`,`day`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='id_generator记录表';
- -- 正在导出表 ly-fms.t_id_generator_record 的数据:~5 rows (大约)
- /*!40000 ALTER TABLE `t_id_generator_record` DISABLE KEYS */;
- INSERT INTO `t_id_generator_record` (`generator_id`, `year`, `month`, `day`, `last_number`) VALUES
- (1, 2019, 3, 30, 1),
- (2, 2019, 3, 30, 1),
- (2, 2019, 4, 3, 2),
- (2, 2019, 4, 8, 2),
- (2, 2019, 4, 9, 1);
- /*!40000 ALTER TABLE `t_id_generator_record` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_notice 结构
- DROP TABLE IF EXISTS `t_notice`;
- CREATE TABLE IF NOT EXISTS `t_notice` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息标题',
- `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息内容',
- `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态:0未删除 0删除 ',
- `send_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送状态 0未发送 1发送',
- `create_user` bigint(20) NOT NULL COMMENT '消息创建人',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_notice 的数据:~14 rows (大约)
- /*!40000 ALTER TABLE `t_notice` DISABLE KEYS */;
- INSERT INTO `t_notice` (`id`, `title`, `content`, `deleted`, `send_status`, `create_user`, `create_time`, `update_time`) VALUES
- (93, '大扫把', '晓冬吃大便', 1, 1, 1, '2019-07-13 17:54:13', '2019-07-13 17:54:21'),
- (95, '4444444', '444444444444', 1, 1, 1, '2019-07-13 17:54:53', '2019-09-04 09:42:02'),
- (96, '3434', '444444', 1, 1, 1, '2019-07-13 17:58:42', '2019-11-08 09:05:24'),
- (97, '44444', '555555555555', 1, 1, 1, '2019-07-13 17:58:54', '2019-09-03 16:19:50'),
- (98, '《青花瓷》', '素胚勾勒出青花笔锋浓转淡\n瓶身描绘的牡丹一如你初妆\n冉冉檀香透过窗心事我了然\n周杰伦 青花瓷\n周杰伦 青花瓷\n宣纸上走笔至此搁一半\n釉色渲染仕女图韵味被私藏\n而你嫣然的一笑如含苞待放\n你的美一缕飘散\n去到我去不了的地方\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意\n色白花青的锦鲤跃然于碗底\n临摹宋体落款时却惦记着你\n你隐藏在窑烧里千年的秘密\n极细腻犹如绣花针落地\n篱外芭蕉惹骤雨门环惹铜绿\n而我路过那江南小镇惹了你\n在泼墨山水画里\n你从墨色深处被隐去\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意\n天青色等烟雨 而我在等你\n炊烟袅袅升起 隔江千万里\n在瓶底书刻隶仿前朝的飘逸\n就当我为遇见你伏笔\n天青色等烟雨 而我在等你\n月色被打捞起 晕开了结局\n如传世的青花瓷自顾自美丽\n你眼带笑意 ', 1, 1, 1, '2019-08-05 16:36:44', '2019-09-02 17:53:12'),
- (99, '1', '2', 1, 1, 30, '2019-08-08 14:53:58', '2019-08-08 14:54:07'),
- (100, '呵呵', '呵呵', 1, 1, 1, '2019-08-20 16:52:53', '2019-09-02 17:46:59'),
- (101, 'aa', 'bbcc', 1, 1, 30, '2019-08-23 09:51:01', '2019-08-23 09:51:28'),
- (102, '1', '2', 0, 1, 1, '2019-09-05 14:28:10', '2019-09-05 14:28:10'),
- (103, '12', '22', 0, 1, 1, '2019-09-05 14:29:30', '2019-09-05 14:29:30'),
- (104, 'a', 'b', 1, 1, 30, '2019-09-06 14:21:18', '2019-09-06 14:24:07'),
- (105, '22222222222', '1111', 0, 0, 1, '2019-11-07 19:05:56', '2019-11-07 19:05:56'),
- (106, '423', '234', 0, 0, 37, '2019-11-08 21:48:19', '2019-11-08 21:48:19'),
- (107, 'AAS', 's\'da\'ssdas', 1, 1, 1, '2019-11-13 19:06:55', '2019-11-14 09:07:06');
- /*!40000 ALTER TABLE `t_notice` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_notice_receive_record 结构
- DROP TABLE IF EXISTS `t_notice_receive_record`;
- CREATE TABLE IF NOT EXISTS `t_notice_receive_record` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `notice_id` bigint(20) NOT NULL COMMENT '消息id',
- `employee_id` bigint(20) NOT NULL COMMENT '用户id',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_notice_receive_record 的数据:~27 rows (大约)
- /*!40000 ALTER TABLE `t_notice_receive_record` DISABLE KEYS */;
- INSERT INTO `t_notice_receive_record` (`id`, `notice_id`, `employee_id`, `create_time`, `update_time`) VALUES
- (114, 93, 1, '2019-07-13 17:54:16', '2019-07-13 17:54:16'),
- (115, 95, 1, '2019-07-13 17:54:55', '2019-07-13 17:54:55'),
- (116, 95, 22, '2019-07-13 17:58:03', '2019-07-13 17:58:03'),
- (117, 93, 22, '2019-07-13 17:58:05', '2019-07-13 17:58:05'),
- (118, 96, 1, '2019-07-13 17:58:44', '2019-07-13 17:58:44'),
- (119, 97, 1, '2019-07-13 17:58:58', '2019-07-13 17:58:58'),
- (120, 98, 1, '2019-08-05 16:37:01', '2019-08-05 16:37:01'),
- (121, 99, 30, '2019-08-08 14:54:05', '2019-08-08 14:54:05'),
- (122, 99, 1, '2019-08-08 15:15:44', '2019-08-08 15:15:44'),
- (123, 100, 1, '2019-08-20 16:53:29', '2019-08-20 16:53:29'),
- (124, 101, 30, '2019-08-23 09:51:11', '2019-08-23 09:51:11'),
- (125, 101, 1, '2019-08-23 12:46:27', '2019-08-23 12:46:27'),
- (126, 102, 1, '2019-09-05 14:28:32', '2019-09-05 14:28:32'),
- (127, 104, 30, '2019-09-06 14:23:58', '2019-09-06 14:23:58'),
- (128, 104, 1, '2019-09-06 15:25:13', '2019-09-06 15:25:13'),
- (129, 101, 14, '2019-11-02 21:46:13', '2019-11-02 21:46:13'),
- (130, 102, 14, '2019-11-02 21:46:14', '2019-11-02 21:46:14'),
- (131, 104, 14, '2019-11-02 21:46:15', '2019-11-02 21:46:15'),
- (132, 98, 14, '2019-11-02 21:46:18', '2019-11-02 21:46:18'),
- (133, 103, 37, '2019-11-07 19:58:06', '2019-11-07 19:58:06'),
- (134, 103, 1, '2019-11-07 20:03:54', '2019-11-07 20:03:54'),
- (135, 107, 1, '2019-11-13 19:07:02', '2019-11-13 19:07:02'),
- (136, 107, 38, '2019-11-15 02:11:04', '2019-11-15 02:11:04'),
- (137, 104, 38, '2019-11-15 02:11:17', '2019-11-15 02:11:17'),
- (138, 101, 38, '2019-11-15 02:26:33', '2019-11-15 02:26:33'),
- (139, 98, 38, '2019-11-15 02:29:32', '2019-11-15 02:29:32'),
- (140, 100, 38, '2019-11-15 03:19:18', '2019-11-15 03:19:18');
- /*!40000 ALTER TABLE `t_notice_receive_record` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_order_operate_log 结构
- DROP TABLE IF EXISTS `t_order_operate_log`;
- CREATE TABLE IF NOT EXISTS `t_order_operate_log` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `order_id` int(11) NOT NULL COMMENT '各种单据的id',
- `order_type` int(11) NOT NULL COMMENT '单据类型',
- `operate_type` int(11) NOT NULL COMMENT '操作类型',
- `operate_content` text NOT NULL COMMENT '操作类型 对应的中文',
- `operate_remark` text COMMENT '操作备注',
- `employee_id` int(11) NOT NULL COMMENT '员工id',
- `employee_name` varchar(1000) NOT NULL COMMENT '员工名称',
- `ext_data` text COMMENT '额外信息',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- KEY `order_id_order_type` (`order_id`,`order_type`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='各种单据操作记录\r\n';
- -- 正在导出表 ly-fms.t_order_operate_log 的数据:~0 rows (大约)
- /*!40000 ALTER TABLE `t_order_operate_log` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_order_operate_log` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_position 结构
- DROP TABLE IF EXISTS `t_position`;
- CREATE TABLE IF NOT EXISTS `t_position` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `position_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '岗位名称',
- `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '岗位描述',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位表';
- -- 正在导出表 ly-fms.t_position 的数据:~13 rows (大约)
- /*!40000 ALTER TABLE `t_position` DISABLE KEYS */;
- INSERT INTO `t_position` (`id`, `position_name`, `remark`, `update_time`, `create_time`) VALUES
- (1, 'java develop', 'java develop is good job', '2019-07-03 15:18:45', '2019-07-03 15:18:45'),
- (2, 'android develop', 'android develop is good job', '2019-07-04 16:11:11', '2019-07-04 16:11:00'),
- (3, '测试岗位1', '这是内容11', '2019-09-02 16:39:33', '2019-07-10 14:03:50'),
- (8, '测试岗位2', '测试岗位2.。', '2019-09-04 10:19:40', '2019-09-04 10:19:32'),
- (9, '测试岗位3', '测试岗位3', '2019-09-05 14:39:43', '2019-09-05 14:39:43'),
- (10, '测试岗位4', '测试岗位4', '2019-09-05 14:39:48', '2019-09-05 14:39:48'),
- (11, '测试岗位5', '测试岗位5', '2019-09-05 14:39:53', '2019-09-05 14:39:53'),
- (12, '测试岗位6', '测试岗位6', '2019-09-05 14:39:58', '2019-09-05 14:39:58'),
- (13, '测试岗位7', '测试岗位7', '2019-09-05 14:40:03', '2019-09-05 14:40:03'),
- (14, '测试岗位8', '测试岗位8', '2019-09-05 14:40:09', '2019-09-05 14:40:09'),
- (15, '测试岗位9', '测试岗位9', '2019-09-05 14:40:19', '2019-09-05 14:40:19'),
- (16, 'aaa22222', 'ddddddddddd', '2019-11-15 17:04:29', '2019-11-06 15:58:37'),
- (17, 'ddd', 'fsdef', '2019-11-15 17:04:40', '2019-11-15 17:04:40');
- /*!40000 ALTER TABLE `t_position` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_position_relation 结构
- DROP TABLE IF EXISTS `t_position_relation`;
- CREATE TABLE IF NOT EXISTS `t_position_relation` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `position_id` int(10) DEFAULT NULL COMMENT '岗位ID',
- `employee_id` int(10) DEFAULT NULL COMMENT '员工ID',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `job_id` (`position_id`) USING BTREE,
- KEY `employee_id` (`employee_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位关联表';
- -- 正在导出表 ly-fms.t_position_relation 的数据:~27 rows (大约)
- /*!40000 ALTER TABLE `t_position_relation` DISABLE KEYS */;
- INSERT INTO `t_position_relation` (`id`, `position_id`, `employee_id`, `update_time`, `create_time`) VALUES
- (14, 1, 28, '2019-07-10 16:40:14', '2019-07-10 16:40:14'),
- (18, 1, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
- (19, 3, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
- (20, 2, 29, '2019-07-11 10:18:22', '2019-07-11 10:18:22'),
- (21, 1, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
- (22, 2, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
- (23, 3, 30, '2019-08-08 14:35:51', '2019-08-08 14:35:51'),
- (26, 2, 31, '2019-08-23 09:26:44', '2019-08-23 09:26:44'),
- (27, 3, 31, '2019-08-23 09:26:44', '2019-08-23 09:26:44'),
- (28, 3, 32, '2019-09-04 09:05:47', '2019-09-04 09:05:47'),
- (29, 2, 32, '2019-09-04 09:05:47', '2019-09-04 09:05:47'),
- (30, 3, 22, '2019-09-04 09:06:46', '2019-09-04 09:06:46'),
- (31, 2, 22, '2019-09-04 09:06:46', '2019-09-04 09:06:46'),
- (35, 8, 35, '2019-09-04 15:09:00', '2019-09-04 15:09:00'),
- (36, 3, 35, '2019-09-04 15:09:00', '2019-09-04 15:09:00'),
- (37, 15, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
- (38, 14, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
- (39, 13, 23, '2019-09-05 16:13:02', '2019-09-05 16:13:02'),
- (40, 3, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
- (41, 2, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
- (42, 1, 34, '2019-09-06 08:55:18', '2019-09-06 08:55:18'),
- (43, 14, 36, '2019-09-09 17:01:39', '2019-09-09 17:01:39'),
- (44, 3, 37, '2019-11-08 09:32:39', '2019-11-08 09:32:39'),
- (46, 8, 38, '2019-11-14 16:08:05', '2019-11-14 16:08:05'),
- (50, 16, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04'),
- (51, 13, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04'),
- (52, 14, 39, '2019-11-15 17:07:04', '2019-11-15 17:07:04');
- /*!40000 ALTER TABLE `t_position_relation` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_privilege 结构
- DROP TABLE IF EXISTS `t_privilege`;
- CREATE TABLE IF NOT EXISTS `t_privilege` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '功能权限表主键id',
- `type` tinyint(11) NOT NULL COMMENT '1.菜单 2.功能点',
- `name` varchar(50) NOT NULL COMMENT '菜单名称',
- `key` varchar(1000) NOT NULL COMMENT '路由name 英文关键字',
- `url` text COMMENT '路由path/type=3为API接口',
- `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
- `parent_key` varchar(1000) DEFAULT NULL COMMENT '父级key',
- `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `key` (`key`) USING BTREE,
- KEY `type` (`type`) USING BTREE,
- KEY `parent_key` (`parent_key`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COMMENT='权限功能表';
- -- 正在导出表 ly-fms.t_privilege 的数据:~103 rows (大约)
- /*!40000 ALTER TABLE `t_privilege` DISABLE KEYS */;
- INSERT INTO `t_privilege` (`id`, `type`, `name`, `key`, `url`, `sort`, `parent_key`, `update_time`, `create_time`) VALUES
- (1, 1, '人员管理', 'Employee', '/employee', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (2, 1, '角色管理', 'RoleManage', '/employee/role', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (3, 1, '岗位管理', 'PositionList', '/employee/position', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (4, 1, '员工管理', 'RoleEmployeeManage', '/employee/role-employee-manage', 0, 'Employee', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (5, 1, '系统设置', 'SystemSetting', '/system-setting', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (6, 1, '系统参数', 'SystemConfig', '/system-setting/system-config', 0, 'SystemSetting', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (8, 1, '菜单管理', 'SystemPrivilege', '/system-setting/system-privilege', 0, 'SystemSetting', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (9, 1, '消息管理', 'Notice', '/notice', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (10, 1, '通知管理', 'NoticeList', '/notice/notice-list', 0, 'Notice', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (11, 1, '个人消息', 'PersonNotice', '/notice/person-notice', 0, 'Notice', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (12, 1, '邮件管理', 'Email', '/email', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (13, 1, '邮件管理', 'EmailList', '/email/email-list', 0, 'Email', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (14, 1, '发送邮件', 'SendMail', '/email/send-mail', 0, 'Email', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (15, 1, '用户日志', 'UserLog', '/user-log', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (16, 1, '用户操作日志', 'UserOperateLog', '/user-log/user-operate-log', 0, 'UserLog', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (17, 1, '用户登录日志', 'UserLoginLog', '/user-log/user-login-log', 0, 'UserLog', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (18, 1, '系统监控', 'Monitor', '/monitor', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (19, 1, '在线人数', 'OnlineUser', '/monitor/online-user', 0, 'Monitor', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (20, 1, 'SQL监控', 'Sql', '/monitor/sql', 0, 'Monitor', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (21, 1, '定时任务', 'Task', '/task', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (22, 1, '任务管理', 'TaskList', '/system-setting/task-list', 0, 'Task', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (23, 1, '动态加载', 'Reload', '/reload', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (24, 1, 'SmartReload', 'SmartReloadList', '/reload/smart-reload-list', 0, 'Reload', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (25, 1, '接口文档', 'ApiDoc', '/api-doc', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (26, 1, 'Swagger接口文档', 'Swagger', '/api-doc/swagger', 0, 'ApiDoc', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (27, 1, '三级路由', 'ThreeRouter', '/three-router', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (28, 1, '三级菜单', 'LevelTwo', '/three-router/level-two', 0, 'ThreeRouter', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (29, 1, '三级A', 'RoleOneTwo', '/three-router/level-two/level-three1', 0, 'LevelTwo', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (30, 1, '三级B', 'RoleTwoTwo', '/three-router/level-two/level-three2', 0, 'LevelTwo', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (31, 1, '二级菜单', 'RoleOneOne', '/three-router/level-two2', 0, 'ThreeRouter', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (32, 1, 'KeepAlive', 'KeepAlive', '/keep-alive', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (33, 1, 'KeepAlive列表', 'KeepAliveContentList', '/keep-alive/content-list', 0, 'KeepAlive', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (34, 1, 'KeepAlive表单', 'KeepAliveAddContent', '/keep-alive/add-content', 0, 'KeepAlive', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (35, 1, '心跳服务', 'HeartBeat', '/heart-beat', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (36, 1, '心跳服务', 'HeartBeatList', '/heart-beat/heart-beat-list', 0, 'HeartBeat', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (37, 1, '文件服务', 'File', '/file', 0, NULL, '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (38, 1, '文件列表', 'FileList', '/file/file-list', 0, 'File', '2019-11-14 14:05:10', '2019-11-01 11:28:07'),
- (39, 2, '添加角色', 'add-role', 'roleController.addRole', 0, 'RoleManage', '2019-11-01 11:47:29', '2019-11-01 11:47:29'),
- (40, 2, '删除角色', 'delete-role', 'roleController.deleteRole', 1, 'RoleManage', '2019-11-01 11:47:43', '2019-11-01 11:47:43'),
- (41, 2, '编辑角色', 'update-role', 'roleController.updateRole', 2, 'RoleManage', '2019-11-01 11:47:55', '2019-11-01 11:47:55'),
- (42, 2, '修改角色权限', 'update-role-privilege', 'rolePrivilegeController.updateRolePrivilege', 3, 'RoleManage', '2019-11-01 11:48:09', '2019-11-01 11:48:09'),
- (43, 2, '添加成员', 'add-employee-role', 'roleEmployeeController.addEmployeeList', 4, 'RoleManage', '2019-11-05 10:38:11', '2019-11-05 10:38:11'),
- (44, 2, '查询成员', 'search-employee-list', 'roleEmployeeController.listAllEmployeeRoleId,roleEmployeeController.listEmployeeByName,roleController.getAllRole,rolePrivilegeController.listPrivilegeByRoleId', 7, 'RoleManage', '2019-11-05 10:39:04', '2019-11-05 10:39:04'),
- (45, 2, '移除成员', 'delete-employee-role', 'roleEmployeeController.removeEmployee', 5, 'RoleManage', '2019-11-05 10:40:09', '2019-11-05 10:40:09'),
- (46, 2, '批量移除', 'delete-employee-role-batch', 'roleEmployeeController.removeEmployeeList', 6, 'RoleManage', '2019-11-05 10:40:27', '2019-11-05 10:40:27'),
- (47, 2, '查询数据范围', 'query-data-scope', 'dataScopeController.dataScopeList,dataScopeController.dataScopeListByRole,rolePrivilegeController.listPrivilegeByRoleId,privilegeController.queryAll,privilegeController.getAllUrl', 8, 'RoleManage', '2019-11-05 10:40:57', '2019-11-05 10:40:57'),
- (48, 2, '更新数据范围', 'update-data-scope', 'dataScopeController.dataScopeBatchSet', 9, 'RoleManage', '2019-11-05 10:41:03', '2019-11-05 10:41:03'),
- (49, 2, '查询', 'search-position', 'positionController.queryJobById,positionController.getJobPage', 0, 'PositionList', '2019-11-05 10:41:30', '2019-11-05 10:41:30'),
- (50, 2, '添加', 'add-position', 'positionController.addJob', 1, 'PositionList', '2019-11-05 10:41:40', '2019-11-05 10:41:40'),
- (51, 2, '修改', 'update-position', 'positionController.updateJob', 2, 'PositionList', '2019-11-05 10:41:49', '2019-11-05 10:41:49'),
- (52, 2, '删除', 'delete-position', 'positionController.removeJob', 3, 'PositionList', '2019-11-05 10:41:57', '2019-11-05 10:41:57'),
- (53, 2, '添加部门', 'add-department', 'departmentController.addDepartment', 0, 'RoleEmployeeManage', '2019-11-05 11:11:18', '2019-11-05 11:11:18'),
- (54, 2, '编辑部门', 'update-department', 'departmentController.updateDepartment', 1, 'RoleEmployeeManage', '2019-11-05 11:11:29', '2019-11-05 11:11:29'),
- (55, 2, '删除部门', 'delete-department', 'departmentController.delDepartment', 2, 'RoleEmployeeManage', '2019-11-05 11:11:48', '2019-11-05 11:11:48'),
- (56, 2, '查询', 'search-department', 'departmentController.listAll,departmentController.getDepartment,departmentController.listDepartmentEmployee,departmentController.listDepartment,employeeController.query', 3, 'RoleEmployeeManage', '2019-11-05 11:12:09', '2019-11-05 11:12:09'),
- (57, 2, '添加成员', 'add-employee', 'employeeController.addEmployee', 4, 'RoleEmployeeManage', '2019-11-05 17:06:23', '2019-11-05 17:06:23'),
- (58, 2, '编辑成员', 'update-employee', 'employeeController.updateEmployee', 5, 'RoleEmployeeManage', '2019-11-05 17:06:57', '2019-11-05 17:06:57'),
- (59, 2, '禁用', 'disabled-employee', 'employeeController.updateStatus', 6, 'RoleEmployeeManage', '2019-11-05 17:14:35', '2019-11-05 17:14:35'),
- (60, 2, '批量操作', 'disabled-employee-batch', 'employeeController.batchUpdateStatus', 7, 'RoleEmployeeManage', '2019-11-05 17:19:23', '2019-11-05 17:19:23'),
- (61, 2, '员工角色编辑', 'update-employee-role', 'employeeController.updateRoles', 8, 'RoleEmployeeManage', '2019-11-05 17:21:15', '2019-11-05 17:21:15'),
- (62, 2, '重置密码', 'reset-employee-password', 'employeeController.resetPasswd', 10, 'RoleEmployeeManage', '2019-11-05 17:22:13', '2019-11-05 17:22:13'),
- (63, 2, '删除员工', 'delete-employee', 'employeeController.deleteEmployeeById', 9, 'RoleEmployeeManage', '2019-11-05 17:22:27', '2019-11-05 17:22:27'),
- (64, 2, '查询系统参数', 'system-params-search', 'systemConfigController.selectByKey,systemConfigController.getListByGroup,systemConfigController.getSystemConfigPage', 0, 'SystemConfig', '2019-11-05 17:23:41', '2019-11-05 17:23:41'),
- (65, 2, '添加系统参数', 'system-params-add', 'systemConfigController.addSystemConfig', 1, 'SystemConfig', '2019-11-05 17:26:00', '2019-11-05 17:26:00'),
- (66, 2, '修改系统参数', 'system-config-update', 'systemConfigController.updateSystemConfig', 2, 'SystemConfig', '2019-11-05 17:26:07', '2019-11-05 17:26:07'),
- (67, 2, '搜索系统参数', 'system-config-search', 'systemConfigController.selectByKey,systemConfigController.getListByGroup,systemConfigController.getSystemConfigPage', 3, 'SystemConfig', '2019-11-05 17:26:44', '2019-11-05 17:26:44'),
- (69, 2, '编辑', 'privilege-main-update', 'privilegeController.menuBatchSave,privilegeController.functionSaveOrUpdate', 0, 'SystemPrivilege', '2019-11-05 17:27:28', '2019-11-05 17:27:28'),
- (70, 2, '查询', 'privilege-main-search', 'privilegeController.queryAll,privilegeController.getAllUrl,privilegeController.functionQuery', 1, 'SystemPrivilege', '2019-11-05 17:28:45', '2019-11-05 17:28:45'),
- (71, 2, '查询', 'notice-query', 'noticeController.queryReceiveByPage,noticeController.queryUnreadByPage,noticeController.queryByPage,noticeController.detail', 0, 'NoticeList', '2019-11-05 17:30:16', '2019-11-05 17:30:16'),
- (72, 2, '添加', 'notice-add', 'noticeController.add', 1, 'NoticeList', '2019-11-05 17:30:28', '2019-11-05 17:30:28'),
- (73, 2, '修改', 'notice-edit', 'noticeController.update', 2, 'NoticeList', '2019-11-05 17:31:24', '2019-11-05 17:31:24'),
- (74, 2, '删除', 'notice-delete', 'noticeController.delete', 3, 'NoticeList', '2019-11-06 11:12:32', '2019-11-06 11:12:32'),
- (75, 2, '详情', 'notice-detail', 'noticeController.detail', 4, 'NoticeList', '2019-11-06 11:12:44', '2019-11-06 11:12:44'),
- (76, 2, '发送', 'notice-send', 'noticeController.send', 5, 'NoticeList', '2019-11-06 11:12:51', '2019-11-06 11:12:51'),
- (77, 2, '查询', 'person-notice-query', 'noticeController.queryReceiveByPage,noticeController.queryUnreadByPage,noticeController.queryByPage', 0, 'PersonNotice', '2019-11-06 11:13:27', '2019-11-06 11:13:27'),
- (78, 2, '详情', 'person-notice-detail', 'noticeController.detail', 1, 'PersonNotice', '2019-11-06 11:13:35', '2019-11-06 11:13:35'),
- (79, 2, '查询', 'email-query', 'emailController.queryByPage,emailController.detail', 0, 'EmailList', '2019-11-06 11:13:49', '2019-11-06 11:13:49'),
- (80, 2, '新增', 'email-add', 'emailController.add', 1, 'EmailList', '2019-11-06 11:14:02', '2019-11-06 11:14:02'),
- (81, 2, '编辑', 'email-update', 'emailController.update', 2, 'EmailList', '2019-11-06 11:14:08', '2019-11-06 11:14:08'),
- (82, 2, '删除', 'email-delete', 'emailController.delete', 3, 'EmailList', '2019-11-06 11:14:16', '2019-11-06 11:14:16'),
- (83, 2, '发送', 'email-send', 'emailController.send', 0, 'SendMail', '2019-11-06 11:14:40', '2019-11-06 11:14:40'),
- (84, 2, '查询', 'user-operate-log-search', 'userOperateLogController.queryByPage', 0, 'UserOperateLog', '2019-11-06 11:15:04', '2019-11-06 11:15:04'),
- (85, 2, '详情', 'user-operate-log-detail', 'userOperateLogController.detail', 1, 'UserOperateLog', '2019-11-06 11:15:16', '2019-11-06 11:15:16'),
- (86, 2, '删除', 'user-operate-log-delete', 'userOperateLogController.delete', 2, 'UserOperateLog', '2019-11-06 11:15:25', '2019-11-06 11:15:25'),
- (87, 2, '查询', 'user-login-log-search', 'userLoginLogController.queryByPage', 0, 'UserLoginLog', '2019-11-06 11:15:43', '2019-11-06 11:15:43'),
- (88, 2, '删除', 'user-login-log-delete', 'userLoginLogController.delete', 1, 'UserLoginLog', '2019-11-06 11:15:49', '2019-11-06 11:15:49'),
- (89, 2, '查询', 'online-user-search', 'userLoginLogController.queryUserOnLine', 0, 'OnlineUser', '2019-11-06 11:16:05', '2019-11-06 11:16:05'),
- (90, 2, '查询任务', 'task-search', 'quartzController.query', 0, 'TaskList', '2019-11-06 11:16:24', '2019-11-06 11:16:24'),
- (91, 2, '刷新任务', 'task-refresh', 'quartzController.query', 1, 'TaskList', '2019-11-06 11:16:50', '2019-11-06 11:16:50'),
- (92, 2, '添加任务', 'task-add', 'quartzController.saveOrUpdateTask', 2, 'TaskList', '2019-11-06 11:17:04', '2019-11-06 11:17:04'),
- (93, 2, '编辑任务', 'task-update', 'quartzController.saveOrUpdateTask', 3, 'TaskList', '2019-11-06 11:17:17', '2019-11-06 11:17:17'),
- (94, 2, '暂停任务', 'task-pause', 'quartzController.pauseTask', 4, 'TaskList', '2019-11-06 11:17:25', '2019-11-06 11:17:25'),
- (95, 2, '恢复任务', 'task-resume', 'quartzController.resumeTask', 5, 'TaskList', '2019-11-06 11:17:31', '2019-11-06 11:17:31'),
- (96, 2, '立即运行任务', 'task-run', 'quartzController.runTask', 6, 'TaskList', '2019-11-06 11:17:38', '2019-11-06 11:17:38'),
- (97, 2, '查看任务日志', 'task-query-log', 'quartzController.queryLog', 7, 'TaskList', '2019-11-06 11:17:47', '2019-11-06 11:17:47'),
- (98, 2, '删除任务', 'task-delete', 'quartzController.deleteTask', 8, 'TaskList', '2019-11-06 11:17:53', '2019-11-06 11:17:53'),
- (99, 2, '查询', 'smart-reload-search', 'smartReloadController.listAllReloadItem', 0, 'SmartReloadList', '2019-11-06 11:18:06', '2019-11-06 11:18:06'),
- (100, 2, '执行reload', 'smart-reload-update', 'smartReloadController.updateByTag', 1, 'SmartReloadList', '2019-11-06 11:18:14', '2019-11-06 11:18:14'),
- (101, 2, '查看执行结果', 'smart-reload-result', 'smartReloadController.queryReloadResult', 2, 'SmartReloadList', '2019-11-06 11:18:19', '2019-11-06 11:18:19'),
- (102, 2, '查询任务', 'heart-beat-query', 'heartBeatController.query', 0, 'HeartBeatList', '2019-11-06 11:18:38', '2019-11-06 11:18:38'),
- (103, 2, '查询', 'file-filePage-query', 'fileController.queryListByPage,fileController.localGetFile,fileController.downLoadById', 0, 'FileList', '2019-11-06 11:19:06', '2019-11-06 11:19:06'),
- (104, 2, '上传', 'file-filePage-upload', 'fileController.qiNiuUpload,fileController.localUpload,fileController.aliYunUpload,fileController.saveFile', 1, 'FileList', '2019-11-06 11:19:36', '2019-11-06 11:19:36'),
- (105, 2, '下载', 'file-filePage-download', 'fileController.downLoadById', 2, 'FileList', '2019-11-16 10:05:02', '2019-11-16 10:05:02');
- /*!40000 ALTER TABLE `t_privilege` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_quartz_task 结构
- DROP TABLE IF EXISTS `t_quartz_task`;
- CREATE TABLE IF NOT EXISTS `t_quartz_task` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
- `task_bean` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'spring bean名称',
- `task_params` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务参数',
- `task_cron` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '运行cron表达式',
- `task_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '任务状态0:正常,1:暂停',
- `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_quartz_task 的数据:~5 rows (大约)
- /*!40000 ALTER TABLE `t_quartz_task` DISABLE KEYS */;
- INSERT INTO `t_quartz_task` (`id`, `task_name`, `task_bean`, `task_params`, `task_cron`, `task_status`, `remark`, `update_time`, `create_time`) VALUES
- (9, '2312332', 'exampleTask', '21314', '*/5 * * * * ?', 1, NULL, '2019-09-06 14:41:55', '2019-04-19 15:24:26'),
- (13, '567', 'exampleTask', 'ads', '*/5 * * * * ?', 1, NULL, '2019-09-04 16:37:25', '2019-04-23 15:32:17'),
- (21, '11', 'exampleTask', '11', '*/5 * * * * ?', 1, NULL, '2019-09-04 16:37:30', '2019-04-26 17:29:21'),
- (22, '33', 'exampleTask', '333', '*/5 * * * * ?', 1, NULL, '2019-04-26 17:29:36', '2019-04-26 17:29:36'),
- (23, '1', 'exampleTask', '3', '*/5 * * * * ?', 0, NULL, '2019-09-05 17:21:12', '2019-04-26 17:29:50');
- /*!40000 ALTER TABLE `t_quartz_task` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_quartz_task_log 结构
- DROP TABLE IF EXISTS `t_quartz_task_log`;
- CREATE TABLE IF NOT EXISTS `t_quartz_task_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `task_id` int(11) NOT NULL COMMENT '任务id',
- `task_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '任务名称',
- `task_params` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务参数',
- `process_status` tinyint(4) NOT NULL COMMENT '任务处理状态0:成功,1:失败',
- `process_duration` bigint(11) NOT NULL DEFAULT '0' COMMENT '运行时长',
- `process_log` text COLLATE utf8mb4_unicode_ci COMMENT '日志',
- `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '运行主机ip',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=732881 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_quartz_task_log 的数据:~11 rows (大约)
- /*!40000 ALTER TABLE `t_quartz_task_log` DISABLE KEYS */;
- INSERT INTO `t_quartz_task_log` (`id`, `task_id`, `task_name`, `task_params`, `process_status`, `process_duration`, `process_log`, `ip_address`, `update_time`, `create_time`) VALUES
- (732870, 9, '231233', '2131', 0, 5, NULL, '127.0.0.1', '2019-05-05 15:28:01', '2019-05-05 15:28:01'),
- (732871, 9, '231233', '2131', 0, 32, NULL, '172.16.0.145', '2019-05-05 15:54:40', '2019-05-05 15:54:40'),
- (732872, 22, '33', '333', 0, 31, NULL, '172.16.0.145', '2019-05-07 16:20:31', '2019-05-07 16:20:31'),
- (732873, 9, '231233', '2131', 0, 304, NULL, '172.16.0.145', '2019-08-02 09:29:36', '2019-08-02 09:29:36'),
- (732874, 9, '231233', '2131', 0, 24, NULL, '172.16.0.145', '2019-08-08 16:48:49', '2019-08-08 16:48:49'),
- (732875, 9, '231233', '2131', 0, 147, NULL, '172.16.0.145', '2019-08-23 09:41:08', '2019-08-23 09:41:08'),
- (732876, 9, '231233', '2131', 0, 610, NULL, '172.16.0.145', '2019-08-26 16:16:34', '2019-08-26 16:16:34'),
- (732877, 9, '2312332', '2131', 0, 27, NULL, '172.16.0.145', '2019-09-05 14:34:51', '2019-09-05 14:34:51'),
- (732878, 9, '2312332', '2131', 0, 5, NULL, '172.16.0.145', '2019-09-05 17:18:17', '2019-09-05 17:18:17'),
- (732879, 9, '2312332', '2131', 0, 1, NULL, '172.16.0.145', '2019-09-05 17:20:15', '2019-09-05 17:20:15'),
- (732880, 9, '2312332', '2131', 0, 5, NULL, '172.16.0.145', '2019-09-06 14:42:04', '2019-09-06 14:42:04');
- /*!40000 ALTER TABLE `t_quartz_task_log` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_reload_item 结构
- DROP TABLE IF EXISTS `t_reload_item`;
- CREATE TABLE IF NOT EXISTS `t_reload_item` (
- `tag` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '项名称',
- `args` varchar(255) DEFAULT NULL COMMENT '参数 可选',
- `identification` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '运行标识',
- `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`tag`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- -- 正在导出表 ly-fms.t_reload_item 的数据:~1 rows (大约)
- /*!40000 ALTER TABLE `t_reload_item` DISABLE KEYS */;
- INSERT INTO `t_reload_item` (`tag`, `args`, `identification`, `update_time`, `create_time`) VALUES
- ('system_config', '234', 'xxxx', '2019-11-14 16:46:21', '2019-04-18 11:48:27');
- /*!40000 ALTER TABLE `t_reload_item` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_reload_result 结构
- DROP TABLE IF EXISTS `t_reload_result`;
- CREATE TABLE IF NOT EXISTS `t_reload_result` (
- `tag` varchar(255) NOT NULL,
- `identification` varchar(255) NOT NULL COMMENT '运行标识',
- `args` varchar(255) DEFAULT NULL,
- `result` tinyint(3) unsigned NOT NULL COMMENT '是否成功 ',
- `exception` text,
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- -- 正在导出表 ly-fms.t_reload_result 的数据:~126 rows (大约)
- /*!40000 ALTER TABLE `t_reload_result` DISABLE KEYS */;
- INSERT INTO `t_reload_result` (`tag`, `identification`, `args`, `result`, `exception`, `create_time`) VALUES
- ('system_config', '23', '', 1, NULL, '2019-09-07 17:26:04'),
- ('system_config', '23', '', 1, NULL, '2019-09-07 17:28:16'),
- ('system_config', '23', '', 1, NULL, '2019-09-07 17:35:39'),
- ('system_config', '23', '', 1, NULL, '2019-09-07 17:42:58'),
- ('system_config', '23', '', 1, NULL, '2019-09-09 08:30:13'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 10:38:19'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 10:42:46'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 10:49:27'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:09:10'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:10:06'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:18:17'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:41:18'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:45:41'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:46:37'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 11:50:35'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 14:55:00'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:26:19'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:35:51'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:36:19'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:36:53'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:37:58'),
- ('system_config', '23', '', 1, NULL, '2019-09-11 15:41:37'),
- ('system_config', '23', '', 1, NULL, '2019-09-16 10:12:29'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:14:08'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:18:24'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:23:07'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:24:17'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:30:17'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:31:40'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:32:34'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:52:31'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:55:10'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:55:47'),
- ('system_config', '23', '', 1, NULL, '2019-09-20 17:58:49'),
- ('system_config', '23', '', 1, NULL, '2019-09-21 10:53:47'),
- ('system_config', '23', '', 1, NULL, '2019-09-22 18:24:21'),
- ('system_config', '23', '', 1, NULL, '2019-09-24 09:04:42'),
- ('system_config', '23', '', 1, NULL, '2019-10-15 11:06:12'),
- ('system_config', '23', '', 1, NULL, '2019-10-15 11:22:10'),
- ('system_config', '23', '', 1, NULL, '2019-10-15 16:42:16'),
- ('system_config', '23', '', 1, NULL, '2019-10-19 15:18:54'),
- ('system_config', '23', '', 1, NULL, '2019-10-19 16:50:10'),
- ('system_config', '23', '', 1, NULL, '2019-10-21 15:52:25'),
- ('system_config', '23', '', 1, NULL, '2019-10-23 10:24:38'),
- ('system_config', '23', '', 1, NULL, '2019-10-23 10:28:45'),
- ('system_config', '23', '', 1, NULL, '2019-10-23 16:35:45'),
- ('system_config', '23', '', 1, NULL, '2019-10-23 16:38:48'),
- ('system_config', '23', '', 1, NULL, '2019-10-25 08:52:22'),
- ('system_config', '23', '', 1, NULL, '2019-10-28 16:04:30'),
- ('system_config', '23', '', 1, NULL, '2019-10-30 19:59:24'),
- ('system_config', '23', '', 1, NULL, '2019-10-31 14:29:26'),
- ('system_config', '23', '', 1, NULL, '2019-10-31 14:35:38'),
- ('system_config', '23', '', 1, NULL, '2019-10-31 15:58:39'),
- ('system_config', '23', '', 1, NULL, '2019-10-31 17:34:48'),
- ('system_config', '23', '', 1, NULL, '2019-11-01 11:23:26'),
- ('system_config', '23', '', 1, NULL, '2019-11-01 14:55:34'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 08:49:44'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:40:52'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:42:48'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:47:38'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:50:57'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:51:32'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 09:51:48'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 15:48:21'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 20:48:44'),
- ('system_config', '23', '', 1, NULL, '2019-11-02 21:27:50'),
- ('system_config', '23', '', 1, NULL, '2019-11-03 22:10:32'),
- ('system_config', '23', '', 1, NULL, '2019-11-03 22:10:32'),
- ('system_config', '23', '', 1, NULL, '2019-11-04 09:10:24'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-05 10:24:51'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:22:42'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:25:54'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:27:04'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:28:00'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:34:06'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:34:43'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:53:11'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 11:56:05'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 13:52:39'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 15:29:29'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:05:36'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:06:13'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:13:22'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:19:38'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:21:37'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-06 16:22:23'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-08 08:50:08'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-08 13:37:34'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 08:35:08'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 08:54:38'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:00:32'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:01:24'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:24:16'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:26:46'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:43:13'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 09:44:48'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 10:28:30'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-09 11:24:19'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-11 09:40:42'),
- ('system_config', '23', '4234234', 1, NULL, '2019-11-13 17:25:42'),
- ('system_config', '23343', '2423', 1, NULL, '2019-11-13 20:29:19'),
- ('system_config', '23343', '2423', 1, NULL, '2019-11-13 20:29:23'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 11:43:57'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 11:50:18'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 11:51:13'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 11:52:03'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 11:53:02'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 13:49:11'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 13:51:05'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 13:53:53'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 13:55:57'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 16:15:44'),
- ('system_config', '23343', '234', 1, NULL, '2019-11-14 16:39:36'),
- ('system_config', '23343234234', '234', 1, NULL, '2019-11-14 16:41:05'),
- ('system_config', '23343234234', '234', 1, NULL, '2019-11-14 16:41:05'),
- ('system_config', 'aaaa', '234', 1, NULL, '2019-11-14 16:41:20'),
- ('system_config', 'aaaa', '234', 1, NULL, '2019-11-14 16:41:25'),
- ('system_config', '111', '234', 1, NULL, '2019-11-14 16:43:20'),
- ('system_config', '111', '234', 1, NULL, '2019-11-14 16:44:13'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:46:26'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:46:39'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-14 16:48:47'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-15 14:39:55'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 08:47:43'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 17:12:10'),
- ('system_config', 'xxxx', '234', 1, NULL, '2019-11-16 18:02:57');
- /*!40000 ALTER TABLE `t_reload_result` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_role 结构
- DROP TABLE IF EXISTS `t_role`;
- CREATE TABLE IF NOT EXISTS `t_role` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
- `role_name` varchar(20) NOT NULL COMMENT '角色名称',
- `remark` varchar(255) DEFAULT NULL COMMENT '角色描述',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='角色表';
- -- 正在导出表 ly-fms.t_role 的数据:~14 rows (大约)
- /*!40000 ALTER TABLE `t_role` DISABLE KEYS */;
- INSERT INTO `t_role` (`id`, `role_name`, `remark`, `update_time`, `create_time`) VALUES
- (1, '管理员', '', '2019-06-21 12:09:34', '2019-06-21 12:09:34'),
- (34, '销售', '', '2019-08-30 09:30:50', '2019-08-30 09:30:50'),
- (35, '总经理', '', '2019-08-30 09:31:05', '2019-08-30 09:31:05'),
- (36, '董事长', '', '2019-08-30 09:31:11', '2019-08-30 09:31:11'),
- (37, '财务', '', '2019-08-30 09:31:16', '2019-08-30 09:31:16'),
- (38, '运营', '', '2019-08-30 09:31:22', '2019-08-30 09:31:22'),
- (40, '测试角色1', '测试角色1', '2019-09-05 15:05:38', '2019-09-05 15:05:38'),
- (41, '测试角色2', '测试角色2', '2019-09-05 15:05:43', '2019-09-05 15:05:43'),
- (42, '测试角色3', '测试角色3', '2019-09-05 15:05:49', '2019-09-05 15:05:49'),
- (43, '测试角色4', '测试角色4', '2019-09-05 15:05:56', '2019-09-05 15:05:56'),
- (45, '测试角色6', '测试角色6', '2019-09-05 15:06:06', '2019-09-05 15:06:06'),
- (46, '测试角色7', '测试角色7', '2019-09-05 15:06:18', '2019-09-05 15:06:18'),
- (47, '测试角色8', '测试角色8', '2019-09-05 15:06:25', '2019-09-05 15:06:25'),
- (48, '测试角色9', '测试角色9', '2019-11-15 17:06:11', '2019-09-05 15:06:30');
- /*!40000 ALTER TABLE `t_role` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_role_data_scope 结构
- DROP TABLE IF EXISTS `t_role_data_scope`;
- CREATE TABLE IF NOT EXISTS `t_role_data_scope` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `data_scope_type` int(11) NOT NULL COMMENT '数据范围id',
- `view_type` int(11) NOT NULL COMMENT '数据范围类型',
- `role_id` int(11) NOT NULL COMMENT '角色id',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_role_data_scope 的数据:~4 rows (大约)
- /*!40000 ALTER TABLE `t_role_data_scope` DISABLE KEYS */;
- INSERT INTO `t_role_data_scope` (`id`, `data_scope_type`, `view_type`, `role_id`, `update_time`, `create_time`) VALUES
- (5, 0, 2, 9, '2019-04-29 15:01:04', '2019-04-29 15:01:04'),
- (14, 0, 2, 40, '2019-09-05 15:25:37', '2019-09-05 15:25:37'),
- (15, 0, 0, 1, '2019-09-06 08:35:45', '2019-09-06 08:35:45'),
- (16, 0, 3, 34, '2019-11-06 16:08:02', '2019-11-06 16:08:02');
- /*!40000 ALTER TABLE `t_role_data_scope` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_role_employee 结构
- DROP TABLE IF EXISTS `t_role_employee`;
- CREATE TABLE IF NOT EXISTS `t_role_employee` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `role_id` int(11) NOT NULL COMMENT '角色id',
- `employee_id` int(11) NOT NULL COMMENT '员工id',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4 COMMENT='角色员工功能表';
- -- 正在导出表 ly-fms.t_role_employee 的数据:~25 rows (大约)
- /*!40000 ALTER TABLE `t_role_employee` DISABLE KEYS */;
- INSERT INTO `t_role_employee` (`id`, `role_id`, `employee_id`, `update_time`, `create_time`) VALUES
- (121, 38, 22, '2019-09-04 09:23:09', '2019-09-04 09:23:09'),
- (130, 1, 30, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (131, 1, 17, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (132, 1, 26, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (135, 1, 12, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (136, 1, 11, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (137, 1, 16, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (138, 1, 18, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (139, 1, 19, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (140, 1, 20, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (141, 1, 23, '2019-09-05 15:32:40', '2019-09-05 15:32:40'),
- (147, 1, 35, '2019-09-06 09:00:27', '2019-09-06 09:00:27'),
- (148, 40, 35, '2019-09-06 09:00:27', '2019-09-06 09:00:27'),
- (165, 40, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
- (166, 34, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
- (167, 38, 32, '2019-11-08 10:39:35', '2019-11-08 10:39:35'),
- (168, 38, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
- (169, 40, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
- (170, 37, 36, '2019-11-08 10:40:16', '2019-11-08 10:40:16'),
- (174, 38, 37, '2019-11-08 11:05:39', '2019-11-08 11:05:39'),
- (175, 42, 37, '2019-11-08 11:05:39', '2019-11-08 11:05:39'),
- (188, 1, 1, '2019-11-15 16:05:33', '2019-11-15 16:05:33'),
- (211, 40, 38, '2019-11-15 16:54:54', '2019-11-15 16:54:54'),
- (212, 34, 29, '2019-11-16 18:04:04', '2019-11-16 18:04:04'),
- (213, 45, 29, '2019-11-16 18:04:04', '2019-11-16 18:04:04');
- /*!40000 ALTER TABLE `t_role_employee` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_role_privilege 结构
- DROP TABLE IF EXISTS `t_role_privilege`;
- CREATE TABLE IF NOT EXISTS `t_role_privilege` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `role_id` int(11) NOT NULL COMMENT '角色id',
- `privilege_key` varchar(1000) NOT NULL COMMENT '权限key',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10835 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限功能表';
- -- 正在导出表 ly-fms.t_role_privilege 的数据:~322 rows (大约)
- /*!40000 ALTER TABLE `t_role_privilege` DISABLE KEYS */;
- INSERT INTO `t_role_privilege` (`id`, `role_id`, `privilege_key`, `update_time`, `create_time`) VALUES
- (3506, 48, 'search-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3507, 48, 'add-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3508, 48, 'update-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3509, 48, 'delete-position', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3510, 48, 'add-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3511, 48, 'delete-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3512, 48, 'update-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3513, 48, 'update-role-privilege', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3514, 48, 'add-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3515, 48, 'delete-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3516, 48, 'delete-employee-role-batch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3517, 48, 'search-employee-list', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3518, 48, 'query-data-scope', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3519, 48, 'update-data-scope', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3520, 48, 'add-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3521, 48, 'update-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3522, 48, 'delete-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3523, 48, 'search-department', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3524, 48, 'add-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3525, 48, 'update-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3526, 48, 'delete-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3527, 48, 'disabled-employee', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3528, 48, 'reset-employee-password', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3529, 48, 'set-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3530, 48, 'disabled-employee-batch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3531, 48, 'update-employee-role', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3533, 48, 'system-params-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3534, 48, 'system-params-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3535, 48, 'system-config-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3536, 48, 'system-config-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3537, 48, 'privilegeMainSearch', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3538, 48, 'privilegeMainUpdate', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3539, 48, 'task-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3540, 48, 'task-refresh', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3541, 48, 'task-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3542, 48, 'task-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3543, 48, 'task-pause', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3544, 48, 'task-resume', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3545, 48, 'task-run', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3546, 48, 'task-query-log', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3547, 48, 'task-delete', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3548, 48, 'systemCodeVersionsQuery', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3552, 48, 'roleOneTwo-add', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3555, 48, 'apiDocument', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3557, 48, 'reload', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3559, 48, 'smart-reload-search', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3560, 48, 'smart-reload-update', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3561, 48, 'smart-reload-result', '2019-09-06 15:28:07', '2019-09-06 15:28:07'),
- (3575, 45, 'task-search', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3576, 45, 'task-refresh', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3577, 45, 'task-add', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3578, 45, 'task-update', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3579, 45, 'task-pause', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3580, 45, 'task-resume', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3581, 45, 'task-run', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3582, 45, 'task-query-log', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3583, 45, 'task-delete', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3586, 45, 'add-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3587, 45, 'delete-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3588, 45, 'update-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3589, 45, 'update-role-privilege', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3590, 45, 'add-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3591, 45, 'delete-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3592, 45, 'delete-employee-role-batch', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3593, 45, 'search-employee-list', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3594, 45, 'query-data-scope', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3595, 45, 'update-data-scope', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3597, 45, 'search-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3598, 45, 'add-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3599, 45, 'update-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3600, 45, 'delete-position', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3602, 45, 'add-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3603, 45, 'set-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3604, 45, 'update-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3605, 45, 'delete-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3606, 45, 'search-department', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3607, 45, 'add-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3608, 45, 'update-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3609, 45, 'disabled-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3610, 45, 'disabled-employee-batch', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3611, 45, 'update-employee-role', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3612, 45, 'delete-employee', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (3613, 45, 'reset-employee-password', '2019-09-06 15:28:17', '2019-09-06 15:28:17'),
- (8112, 41, 'SystemSetting', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
- (8113, 41, 'SystemPrivilege', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
- (8114, 41, 'privilege-main-update', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
- (8115, 41, 'privilege-main-search', '2019-11-08 11:21:22', '2019-11-08 11:21:22'),
- (8549, 35, 'SystemSetting', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8550, 35, 'SystemConfig', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8551, 35, 'SystemPrivilege', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8552, 35, 'Notice', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8553, 35, 'NoticeList', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8554, 35, 'PersonNotice', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8555, 35, 'Email', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8556, 35, 'EmailList', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8557, 35, 'UserLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8558, 35, 'UserOperateLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8559, 35, 'UserLoginLog', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8560, 35, 'system-config-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8561, 35, 'privilege-main-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8562, 35, 'privilege-main-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8563, 35, 'notice-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8564, 35, 'notice-add', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8565, 35, 'notice-edit', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8566, 35, 'notice-delete', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8567, 35, 'person-notice-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8568, 35, 'person-notice-detail', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8569, 35, 'email-query', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8570, 35, 'email-add', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8571, 35, 'email-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8572, 35, 'user-operate-log-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8573, 35, 'user-login-log-search', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (8574, 35, 'system-config-update', '2019-11-15 15:47:52', '2019-11-15 15:47:52'),
- (9005, 37, 'SystemSetting', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
- (9006, 37, 'SystemConfig', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
- (9007, 37, 'system-params-search', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
- (9008, 37, 'system-params-add', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
- (9009, 37, 'system-config-update', '2019-11-15 16:33:09', '2019-11-15 16:33:09'),
- (9368, 34, 'SystemSetting', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9369, 34, 'SystemConfig', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9370, 34, 'SystemPrivilege', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9371, 34, 'system-params-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9372, 34, 'system-params-add', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9373, 34, 'privilege-main-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9374, 34, 'Task', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9375, 34, 'TaskList', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9376, 34, 'task-search', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9377, 34, 'task-refresh', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9378, 34, 'task-add', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9379, 34, 'task-update', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9380, 34, 'task-pause', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9381, 34, 'task-resume', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9382, 34, 'task-run', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9383, 34, 'task-query-log', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9384, 34, 'task-delete', '2019-11-15 16:45:39', '2019-11-15 16:45:39'),
- (9536, 42, 'Task', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9537, 42, 'TaskList', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9538, 42, 'task-search', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9539, 42, 'task-add', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9540, 42, 'task-update', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9541, 42, 'task-query-log', '2019-11-15 16:50:40', '2019-11-15 16:50:40'),
- (9674, 38, 'Employee', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9675, 38, 'PositionList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9676, 38, 'SystemSetting', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9677, 38, 'SystemConfig', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9678, 38, 'Notice', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9679, 38, 'PersonNotice', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9680, 38, 'Email', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9681, 38, 'EmailList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9682, 38, 'SendMail', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9683, 38, 'Monitor', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9684, 38, 'OnlineUser', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9685, 38, 'Task', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9686, 38, 'TaskList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9687, 38, 'KeepAlive', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9688, 38, 'KeepAliveContentList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9689, 38, 'HeartBeat', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9690, 38, 'HeartBeatList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9691, 38, 'File', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9692, 38, 'FileList', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9693, 38, 'search-position', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9694, 38, 'system-params-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9695, 38, 'system-config-update', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9696, 38, 'system-config-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9697, 38, 'person-notice-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9698, 38, 'person-notice-detail', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9699, 38, 'email-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9700, 38, 'email-send', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9701, 38, 'online-user-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9702, 38, 'task-search', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9703, 38, 'heart-beat-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9704, 38, 'file-filePage-query', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9705, 38, 'file-filePage-upload', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (9706, 38, 'task-refresh', '2019-11-15 16:53:47', '2019-11-15 16:53:47'),
- (10585, 40, 'Employee', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10586, 40, 'RoleManage', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10587, 40, 'PositionList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10588, 40, 'RoleEmployeeManage', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10589, 40, 'SystemSetting', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10590, 40, 'SystemConfig', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10591, 40, 'SystemPrivilege', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10592, 40, 'Notice', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10593, 40, 'NoticeList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10594, 40, 'PersonNotice', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10595, 40, 'Email', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10596, 40, 'SendMail', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10597, 40, 'Task', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10598, 40, 'TaskList', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10599, 40, 'add-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10600, 40, 'delete-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10601, 40, 'update-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10602, 40, 'update-role-privilege', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10603, 40, 'add-employee-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10604, 40, 'search-employee-list', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10605, 40, 'delete-employee-role', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10606, 40, 'delete-employee-role-batch', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10607, 40, 'query-data-scope', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10608, 40, 'update-data-scope', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10609, 40, 'search-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10610, 40, 'add-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10611, 40, 'update-position', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10612, 40, 'search-department', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10613, 40, 'system-params-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10614, 40, 'system-config-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10615, 40, 'privilege-main-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10616, 40, 'notice-query', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10617, 40, 'notice-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10618, 40, 'notice-edit', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10619, 40, 'notice-delete', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10620, 40, 'notice-detail', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10621, 40, 'notice-send', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10622, 40, 'person-notice-query', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10623, 40, 'email-send', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10624, 40, 'task-search', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10625, 40, 'task-refresh', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10626, 40, 'task-add', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10627, 40, 'task-update', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10628, 40, 'task-query-log', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10629, 40, 'task-delete', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10630, 40, 'delete-department', '2019-11-15 17:19:42', '2019-11-15 17:19:42'),
- (10733, 1, 'Employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10734, 1, 'RoleManage', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10735, 1, 'PositionList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10736, 1, 'RoleEmployeeManage', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10737, 1, 'SystemSetting', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10738, 1, 'SystemConfig', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10739, 1, 'SystemPrivilege', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10740, 1, 'Notice', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10741, 1, 'NoticeList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10742, 1, 'PersonNotice', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10743, 1, 'Email', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10744, 1, 'EmailList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10745, 1, 'SendMail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10746, 1, 'UserLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10747, 1, 'UserOperateLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10748, 1, 'UserLoginLog', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10749, 1, 'Monitor', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10750, 1, 'OnlineUser', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10751, 1, 'Sql', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10752, 1, 'Task', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10753, 1, 'TaskList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10754, 1, 'Reload', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10755, 1, 'SmartReloadList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10756, 1, 'ApiDoc', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10757, 1, 'Swagger', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10758, 1, 'ThreeRouter', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10759, 1, 'LevelTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10760, 1, 'RoleOneTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10761, 1, 'RoleTwoTwo', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10762, 1, 'RoleOneOne', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10763, 1, 'KeepAlive', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10764, 1, 'KeepAliveContentList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10765, 1, 'KeepAliveAddContent', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10766, 1, 'HeartBeat', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10767, 1, 'HeartBeatList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10768, 1, 'File', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10769, 1, 'FileList', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10770, 1, 'add-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10771, 1, 'delete-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10772, 1, 'update-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10773, 1, 'update-role-privilege', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10774, 1, 'add-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10775, 1, 'search-employee-list', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10776, 1, 'delete-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10777, 1, 'delete-employee-role-batch', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10778, 1, 'query-data-scope', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10779, 1, 'update-data-scope', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10780, 1, 'search-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10781, 1, 'add-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10782, 1, 'update-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10783, 1, 'delete-position', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10784, 1, 'add-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10785, 1, 'update-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10786, 1, 'delete-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10787, 1, 'search-department', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10788, 1, 'add-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10789, 1, 'update-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10790, 1, 'disabled-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10791, 1, 'disabled-employee-batch', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10792, 1, 'update-employee-role', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10793, 1, 'reset-employee-password', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10794, 1, 'delete-employee', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10795, 1, 'system-params-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10796, 1, 'system-params-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10797, 1, 'system-config-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10798, 1, 'system-config-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10799, 1, 'privilege-main-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10800, 1, 'privilege-main-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10801, 1, 'notice-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10802, 1, 'notice-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10803, 1, 'notice-edit', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10804, 1, 'notice-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10805, 1, 'notice-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10806, 1, 'notice-send', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10807, 1, 'person-notice-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10808, 1, 'person-notice-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10809, 1, 'email-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10810, 1, 'email-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10811, 1, 'email-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10812, 1, 'email-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10813, 1, 'email-send', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10814, 1, 'user-operate-log-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10815, 1, 'user-operate-log-detail', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10816, 1, 'user-operate-log-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10817, 1, 'user-login-log-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10818, 1, 'user-login-log-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10819, 1, 'online-user-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10820, 1, 'task-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10821, 1, 'task-refresh', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10822, 1, 'task-add', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10823, 1, 'task-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10824, 1, 'task-pause', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10825, 1, 'task-resume', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10826, 1, 'task-run', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10827, 1, 'task-query-log', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10828, 1, 'task-delete', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10829, 1, 'smart-reload-search', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10830, 1, 'smart-reload-update', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10831, 1, 'smart-reload-result', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10832, 1, 'heart-beat-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10833, 1, 'file-filePage-query', '2019-11-16 18:04:10', '2019-11-16 18:04:10'),
- (10834, 1, 'file-filePage-upload', '2019-11-16 18:04:10', '2019-11-16 18:04:10');
- /*!40000 ALTER TABLE `t_role_privilege` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_system_config 结构
- DROP TABLE IF EXISTS `t_system_config`;
- CREATE TABLE IF NOT EXISTS `t_system_config` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
- `config_name` varchar(255) NOT NULL COMMENT '参数名字',
- `config_key` varchar(255) NOT NULL COMMENT '参数key',
- `config_value` text NOT NULL,
- `config_group` varchar(255) NOT NULL COMMENT '参数类别',
- `is_using` int(10) NOT NULL COMMENT '是否使用0 否 1 是',
- `remark` varchar(255) DEFAULT NULL,
- `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次修改时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
- -- 正在导出表 ly-fms.t_system_config 的数据:~8 rows (大约)
- /*!40000 ALTER TABLE `t_system_config` DISABLE KEYS */;
- INSERT INTO `t_system_config` (`id`, `config_name`, `config_key`, `config_value`, `config_group`, `is_using`, `remark`, `update_time`, `create_time`) VALUES
- (1, '超级管理员', 'employee_superman', '12,13,1', 'employee', 1, '123r8566456', '2019-11-14 16:40:48', '2018-08-18 16:28:03'),
- (13, '本地上传URL前缀', 'local_upload_url_prefix', 'http://172.16.0.145/smartAdmin/file/', 'upload', 1, '', '2019-09-04 16:23:49', '2019-04-26 17:06:53'),
- (14, '阿里云上传配置', 'ali_oss', '{"accessKeyId":"","accessKeySecret":"","bucketName":"sit","endpoint":"http://oss-cn-beijing.aliyuncs.com"}', 'upload', 1, 'eefwfwfds', '2019-11-16 18:04:30', '2019-05-11 18:00:06'),
- (15, '邮件发配置', 'email_config', '{"password":"smartadmin","smtpHost":"smtp.163.com","username":"smartadmin1024@163.com"}', 'email', 1, NULL, '2019-09-04 16:42:17', '2019-05-13 16:57:48'),
- (16, '七牛云上传配置', 'qi_niu_oss', '{"accessKeyId":"rX7HgY1ZLpUD25JrA-uwMM_jj-","accessKeySecret":"","bucketName":"sun-smart-admin","endpoint":"http://puvpyay08.bkt.clouddn.com"}', 'upload', 1, NULL, '2019-11-16 18:04:42', '2019-07-19 16:05:56'),
- (17, 'test', 'ww_1', 'ewr', '3', 1, 'testoo', '2019-11-08 09:43:36', '2019-11-08 09:27:19'),
- (18, '4234', '42342', '423423', '23423', 1, '423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111423423111111111111111111111111111111111111', '2019-11-14 14:58:39', '2019-11-14 11:22:49'),
- (19, 'test323@', 'test', '123456', '11_', 1, 'gggggg', '2019-11-15 16:24:52', '2019-11-15 16:24:52');
- /*!40000 ALTER TABLE `t_system_config` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_user_login_log 结构
- DROP TABLE IF EXISTS `t_user_login_log`;
- CREATE TABLE IF NOT EXISTS `t_user_login_log` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
- `user_id` int(11) NOT NULL COMMENT '员工id',
- `user_name` varchar(50) NOT NULL COMMENT '用户名',
- `remote_ip` varchar(50) DEFAULT NULL COMMENT '用户ip',
- `remote_port` int(11) DEFAULT NULL COMMENT '用户端口',
- `remote_browser` varchar(100) DEFAULT NULL COMMENT '浏览器',
- `remote_os` varchar(50) DEFAULT NULL COMMENT '操作系统',
- `login_status` tinyint(4) NOT NULL COMMENT '登录状态 0 失败 1成功',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`),
- KEY `customer_id` (`user_id`) USING BTREE,
- KEY `auditor_id` (`remote_browser`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1742 DEFAULT CHARSET=utf8mb4 COMMENT='用户登录日志';
- -- 正在导出表 ly-fms.t_user_login_log 的数据:~122 rows (大约)
- /*!40000 ALTER TABLE `t_user_login_log` DISABLE KEYS */;
- INSERT INTO `t_user_login_log` (`id`, `user_id`, `user_name`, `remote_ip`, `remote_port`, `remote_browser`, `remote_os`, `login_status`, `update_time`, `create_time`) VALUES
- (1501, 30, '耿为刚', '172.16.1.234', 61406, 'Chrome', 'Windows 10', 1, '2019-09-06 14:19:47', '2019-09-06 14:19:47'),
- (1502, 30, '耿为刚', '172.16.1.234', 61405, 'Chrome', 'Windows 10', 1, '2019-09-06 14:20:46', '2019-09-06 14:20:46'),
- (1503, 30, '耿为刚', '172.16.1.234', 62213, 'Chrome', 'Windows 10', 1, '2019-09-06 14:28:50', '2019-09-06 14:28:50'),
- (1505, 30, '耿为刚', '172.16.1.234', 62478, 'Chrome', 'Windows 10', 1, '2019-09-06 14:32:57', '2019-09-06 14:32:57'),
- (1506, 1, '管理员', '127.0.0.1', 55613, 'Chrome', 'Windows 10', 1, '2019-09-06 14:35:48', '2019-09-06 14:35:48'),
- (1507, 1, '管理员', '172.16.1.234', 63132, 'Chrome', 'Windows 10', 1, '2019-09-06 14:38:43', '2019-09-06 14:38:43'),
- (1508, 30, '耿为刚', '172.16.1.234', 63132, 'Chrome', 'Windows 10', 1, '2019-09-06 14:41:36', '2019-09-06 14:41:36'),
- (1509, 1, '管理员', '172.16.1.234', 63332, 'Chrome', 'Windows 10', 1, '2019-09-06 14:42:37', '2019-09-06 14:42:37'),
- (1511, 1, '管理员', '172.16.1.166', 29923, 'Chrome', 'Windows 10', 1, '2019-09-06 15:09:22', '2019-09-06 15:09:22'),
- (1512, 1, '管理员', '172.16.1.113', 58150, 'Chrome', 'Windows 7', 1, '2019-09-06 15:23:31', '2019-09-06 15:23:31'),
- (1513, 1, '管理员', '172.16.1.166', 31226, 'Chrome', 'Windows 10', 1, '2019-09-06 15:24:51', '2019-09-06 15:24:51'),
- (1514, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:25:04', '2019-09-06 15:25:04'),
- (1515, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:25:26', '2019-09-06 15:25:26'),
- (1516, 1, '管理员', '172.16.1.166', 31243, 'Chrome', 'Windows 10', 1, '2019-09-06 15:25:29', '2019-09-06 15:25:29'),
- (1517, 1, '管理员', '172.16.1.221', 61458, 'Chrome', 'Windows 10', 1, '2019-09-06 15:27:07', '2019-09-06 15:27:07'),
- (1518, 1, '管理员', '172.16.1.166', 31243, 'Chrome', 'Windows 10', 1, '2019-09-06 15:27:09', '2019-09-06 15:27:09'),
- (1519, 1, '管理员', '172.16.1.113', 58300, 'Chrome', 'Windows 7', 1, '2019-09-06 15:27:10', '2019-09-06 15:27:10'),
- (1520, 1, '管理员', '172.16.1.166', 31551, 'Chrome', 'Windows 10', 1, '2019-09-06 15:30:01', '2019-09-06 15:30:01'),
- (1521, 1, '管理员', '172.16.4.160', 50527, 'Chrome', 'Windows 10', 1, '2019-09-06 15:50:20', '2019-09-06 15:50:20'),
- (1522, 1, '管理员', '172.16.1.166', 36381, 'Chrome', 'Windows 10', 1, '2019-09-06 16:20:46', '2019-09-06 16:20:46'),
- (1523, 1, '管理员', '172.16.1.166', 40039, 'Chrome', 'Windows 10', 1, '2019-09-06 17:02:33', '2019-09-06 17:02:33'),
- (1524, 1, '管理员', '172.16.1.166', 41014, 'Chrome', 'Windows 10', 1, '2019-09-06 17:16:09', '2019-09-06 17:16:09'),
- (1525, 1, '管理员', '172.16.1.188', 56577, 'Chrome', 'Windows 7', 1, '2019-09-07 08:36:31', '2019-09-07 08:36:31'),
- (1526, 1, '管理员', '172.16.1.48', 60852, 'Chrome', 'Windows 10', 1, '2019-09-07 08:45:02', '2019-09-07 08:45:02'),
- (1527, 1, '管理员', '172.16.4.85', 4818, 'Chrome', 'Windows 10', 1, '2019-09-07 09:04:44', '2019-09-07 09:04:44'),
- (1528, 1, '管理员', '172.16.4.85', 5230, 'Chrome', 'Windows 10', 1, '2019-09-07 09:25:41', '2019-09-07 09:25:41'),
- (1529, 1, '管理员', '172.16.1.166', 10251, 'Chrome', 'Windows 10', 1, '2019-09-07 10:15:20', '2019-09-07 10:15:20'),
- (1530, 1, '管理员', '172.16.1.48', 63877, 'Chrome', 'Windows 10', 1, '2019-09-07 11:26:19', '2019-09-07 11:26:19'),
- (1531, 1, '管理员', '172.16.1.166', 26667, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:15', '2019-09-07 14:08:15'),
- (1532, 1, '管理员', '172.16.4.85', 10604, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:33', '2019-09-07 14:08:33'),
- (1533, 1, '管理员', '172.16.4.85', 10604, 'Chrome', 'Windows 10', 1, '2019-09-07 14:08:50', '2019-09-07 14:08:50'),
- (1534, 1, '管理员', '172.16.1.166', 26812, 'Chrome', 'Windows 10', 1, '2019-09-07 14:14:09', '2019-09-07 14:14:09'),
- (1535, 1, '管理员', '172.16.1.188', 52924, 'Chrome', 'Windows 7', 1, '2019-09-07 14:37:16', '2019-09-07 14:37:16'),
- (1536, 1, '管理员', '172.16.1.188', 56721, 'Chrome', 'Windows 7', 1, '2019-09-07 14:49:37', '2019-09-07 14:49:37'),
- (1537, 1, '管理员', '172.16.1.188', 52839, 'Chrome', 'Windows 7', 1, '2019-09-07 15:33:04', '2019-09-07 15:33:04'),
- (1538, 1, '管理员', '172.16.1.166', 32489, 'Chrome', 'Windows 10', 1, '2019-09-07 15:48:02', '2019-09-07 15:48:02'),
- (1539, 1, '管理员', '172.16.1.166', 32847, 'Chrome', 'Windows 10', 1, '2019-09-07 15:52:25', '2019-09-07 15:52:25'),
- (1540, 1, '管理员', '172.16.1.166', 33456, 'Chrome', 'Windows 10', 1, '2019-09-07 16:00:01', '2019-09-07 16:00:01'),
- (1541, 1, '管理员', '172.16.1.188', 61015, 'Chrome', 'Windows 7', 1, '2019-09-07 17:05:49', '2019-09-07 17:05:49'),
- (1542, 1, '管理员', '127.0.0.1', 51566, 'Chrome', 'Windows 7', 1, '2019-09-07 17:31:20', '2019-09-07 17:31:20'),
- (1543, 1, '管理员', '127.0.0.1', 54228, 'Chrome', 'Windows 7', 1, '2019-09-07 17:41:12', '2019-09-07 17:41:12'),
- (1544, 1, '管理员', '127.0.0.1', 54957, 'Chrome', 'Windows 7', 1, '2019-09-07 17:43:21', '2019-09-07 17:43:21'),
- (1545, 1, '管理员', '172.16.4.85', 2336, 'Chrome', 'Windows 10', 1, '2019-09-07 18:25:51', '2019-09-07 18:25:51'),
- (1546, 1, '管理员', '127.0.0.1', 52161, 'Chrome', 'Windows 7', 1, '2019-09-09 08:30:47', '2019-09-09 08:30:47'),
- (1547, 1, '管理员', '172.16.4.85', 5903, 'Chrome', 'Windows 10', 1, '2019-09-09 08:47:47', '2019-09-09 08:47:47'),
- (1548, 1, '管理员', '172.16.1.243', 55673, 'Chrome', 'Windows 10', 1, '2019-09-09 11:25:02', '2019-09-09 11:25:02'),
- (1549, 1, '管理员', '172.16.4.85', 4672, 'Chrome', 'Windows 10', 1, '2019-09-09 11:25:34', '2019-09-09 11:25:34'),
- (1550, 1, '管理员', '172.16.1.188', 61186, 'Chrome', 'Windows 7', 1, '2019-09-09 11:39:24', '2019-09-09 11:39:24'),
- (1551, 1, '管理员', '172.16.4.85', 3032, 'Chrome', 'Windows 10', 1, '2019-09-09 14:17:53', '2019-09-09 14:17:53'),
- (1552, 1, '管理员', '172.16.4.85', 5829, 'Chrome', 'Windows 10', 1, '2019-09-09 14:54:27', '2019-09-09 14:54:27'),
- (1553, 1, '管理员', '172.16.1.166', 23398, 'Chrome', 'Windows 10', 1, '2019-09-09 15:06:50', '2019-09-09 15:06:50'),
- (1554, 1, '管理员', '172.16.5.60', 61094, 'Chrome', 'Windows 10', 1, '2019-09-09 15:20:50', '2019-09-09 15:20:50'),
- (1555, 1, '管理员', '172.16.4.85', 10566, 'Chrome', 'Windows 10', 1, '2019-09-09 15:51:22', '2019-09-09 15:51:22'),
- (1556, 1, '管理员', '172.16.1.166', 32190, 'Chrome', 'Windows 10', 1, '2019-09-09 17:00:59', '2019-09-09 17:00:59'),
- (1557, 1, '管理员', '172.16.5.60', 54502, 'Chrome', 'Windows 10', 1, '2019-09-10 09:10:48', '2019-09-10 09:10:48'),
- (1558, 1, '管理员', '172.16.4.85', 10659, 'Chrome', 'Windows 10', 1, '2019-09-10 09:21:48', '2019-09-10 09:21:48'),
- (1559, 1, '管理员', '172.16.4.85', 3363, 'Chrome', 'Windows 10', 1, '2019-09-10 10:56:23', '2019-09-10 10:56:23'),
- (1560, 1, '管理员', '172.16.4.85', 4460, 'Chrome', 'Windows 10', 1, '2019-09-10 14:23:44', '2019-09-10 14:23:44'),
- (1561, 1, '管理员', '172.16.4.85', 7344, 'Chrome', 'Windows 10', 1, '2019-09-10 14:59:52', '2019-09-10 14:59:52'),
- (1562, 1, '管理员', '172.16.5.89', 49996, 'Chrome', 'Windows 10', 1, '2019-09-10 18:08:04', '2019-09-10 18:08:04'),
- (1563, 1, '管理员', '172.16.1.38', 50152, 'Chrome', 'Windows 10', 1, '2019-09-11 10:19:27', '2019-09-11 10:19:27'),
- (1564, 1, '管理员', '172.16.1.38', 50173, 'Chrome', 'Windows 10', 1, '2019-09-11 10:20:38', '2019-09-11 10:20:38'),
- (1565, 1, '管理员', '172.16.4.141', 60881, 'Chrome', 'Windows 10', 1, '2019-09-11 14:52:02', '2019-09-11 14:52:02'),
- (1566, 1, '管理员', '172.16.4.93', 52688, 'Chrome', 'Windows 10', 1, '2019-09-11 15:15:14', '2019-09-11 15:15:14'),
- (1567, 1, '管理员', '172.16.5.127', 54993, 'Chrome', 'Windows 10', 1, '2019-09-12 14:29:58', '2019-09-12 14:29:58'),
- (1568, 1, '管理员', '172.16.5.127', 57424, 'Chrome', 'Windows 10', 1, '2019-09-12 15:26:46', '2019-09-12 15:26:46'),
- (1569, 1, '管理员', '172.16.5.127', 58073, 'Chrome', 'Windows 10', 1, '2019-09-12 15:41:54', '2019-09-12 15:41:54'),
- (1570, 1, '管理员', '172.16.5.146', 63230, 'Chrome', 'Windows 10', 1, '2019-09-16 10:17:15', '2019-09-16 10:17:15'),
- (1571, 1, '管理员', '172.16.5.146', 52857, 'Chrome', 'Windows 10', 1, '2019-09-16 11:17:18', '2019-09-16 11:17:18'),
- (1572, 1, '管理员', '172.16.1.190', 64527, 'Chrome', 'Windows 10', 1, '2019-09-19 14:06:45', '2019-09-19 14:06:45'),
- (1573, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:33', '2019-09-20 17:24:33'),
- (1574, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:43', '2019-09-20 17:24:43'),
- (1575, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:24:59', '2019-09-20 17:24:59'),
- (1576, 1, '管理员', '127.0.0.1', 53267, 'Chrome', 'Windows 7', 1, '2019-09-20 17:26:05', '2019-09-20 17:26:05'),
- (1577, 1, '管理员', '127.0.0.1', 60612, 'Chrome', 'Windows 7', 1, '2019-09-20 17:56:06', '2019-09-20 17:56:06'),
- (1578, 1, '管理员', '172.16.1.202', 58066, 'Chrome', 'Windows 7', 1, '2019-09-22 18:25:03', '2019-09-22 18:25:03'),
- (1579, 1, '管理员', '172.16.1.48', 52290, 'Chrome', 'Windows 10', 1, '2019-09-23 16:01:16', '2019-09-23 16:01:16'),
- (1580, 1, '管理员', '172.16.4.141', 60997, 'Chrome', 'Windows 10', 1, '2019-09-23 17:16:55', '2019-09-23 17:16:55'),
- (1581, 1, '管理员', '172.16.5.146', 53246, 'Chrome', 'Windows 10', 1, '2019-09-23 17:54:14', '2019-09-23 17:54:14'),
- (1582, 1, '管理员', '127.0.0.1', 51987, 'Chrome', 'Windows 7', 1, '2019-09-24 09:16:37', '2019-09-24 09:16:37'),
- (1583, 1, '管理员', '172.16.1.202', 55724, 'Chrome', 'Windows 7', 1, '2019-09-24 12:57:39', '2019-09-24 12:57:39'),
- (1584, 1, '管理员', '172.16.1.166', 51876, 'Chrome', 'Windows 10', 1, '2019-09-24 16:24:37', '2019-09-24 16:24:37'),
- (1585, 1, '管理员', '172.16.1.202', 51648, 'Chrome', 'Windows 7', 1, '2019-09-24 19:26:39', '2019-09-24 19:26:39'),
- (1586, 1, '管理员', '172.16.1.234', 60984, 'Chrome', 'Windows 10', 1, '2019-09-26 10:52:07', '2019-09-26 10:52:07'),
- (1587, 1, '管理员', '172.16.1.234', 63440, 'Chrome', 'Windows 10', 1, '2019-09-26 11:30:54', '2019-09-26 11:30:54'),
- (1588, 1, '管理员', '172.16.1.202', 51956, 'Chrome', 'Windows 7', 1, '2019-09-27 20:55:08', '2019-09-27 20:55:08'),
- (1589, 1, '管理员', '172.16.1.48', 56166, 'Chrome', 'Windows 10', 1, '2019-09-30 08:59:13', '2019-09-30 08:59:13'),
- (1590, 1, '管理员', '172.16.1.202', 51448, 'Chrome', 'Windows 7', 1, '2019-09-30 09:00:13', '2019-09-30 09:00:13'),
- (1591, 1, '管理员', '172.16.1.188', 62679, 'Chrome', 'Windows 7', 1, '2019-10-15 11:25:26', '2019-10-15 11:25:26'),
- (1592, 1, '管理员', '172.16.1.234', 54034, 'Chrome', 'Windows 10', 1, '2019-10-18 10:47:14', '2019-10-18 10:47:14'),
- (1593, 1, '管理员', '172.16.1.234', 64515, 'Chrome', 'Windows 10', 1, '2019-10-18 13:32:10', '2019-10-18 13:32:10'),
- (1594, 1, '管理员', '172.16.1.234', 50211, 'Chrome', 'Windows 10', 1, '2019-10-18 13:56:19', '2019-10-18 13:56:19'),
- (1595, 1, '管理员', '172.16.1.234', 55469, 'Chrome', 'Windows 10', 1, '2019-10-18 14:56:24', '2019-10-18 14:56:24'),
- (1596, 1, '管理员', '172.16.1.234', 56392, 'Chrome', 'Windows 10', 1, '2019-10-18 15:08:25', '2019-10-18 15:08:25'),
- (1597, 1, '管理员', '172.16.1.234', 60896, 'Chrome', 'Windows 10', 1, '2019-10-18 16:14:15', '2019-10-18 16:14:15'),
- (1598, 1, '管理员', '172.16.1.234', 50590, 'Chrome', 'Windows 10', 1, '2019-10-19 08:38:54', '2019-10-19 08:38:54'),
- (1599, 1, '管理员', '172.16.1.166', 4879, 'Chrome', 'Windows 10', 1, '2019-10-19 09:19:08', '2019-10-19 09:19:08'),
- (1600, 1, '管理员', '172.16.1.188', 62895, 'Chrome', 'Windows 7', 1, '2019-10-19 13:49:29', '2019-10-19 13:49:29'),
- (1601, 1, '管理员', '172.16.1.234', 58144, 'Chrome', 'Windows 10', 1, '2019-10-19 14:55:50', '2019-10-19 14:55:50'),
- (1602, 1, '管理员', '127.0.0.1', 61033, 'Chrome', 'Windows 7', 1, '2019-10-19 15:19:38', '2019-10-19 15:19:38'),
- (1603, 1, '管理员', '172.16.1.188', 58944, 'Chrome', 'Windows 7', 1, '2019-10-19 16:48:49', '2019-10-19 16:48:49'),
- (1604, 1, '管理员', '172.16.1.188', 63950, 'Chrome', 'Windows 7', 1, '2019-10-21 08:10:38', '2019-10-21 08:10:38'),
- (1605, 1, '管理员', '172.16.1.188', 64899, 'Chrome', 'Windows 7', 1, '2019-10-21 08:17:40', '2019-10-21 08:17:40'),
- (1606, 1, '管理员', '172.16.1.221', 53180, 'Chrome', 'Windows 10', 1, '2019-10-21 15:52:36', '2019-10-21 15:52:36'),
- (1607, 1, '管理员', '172.16.1.221', 56067, 'Chrome', 'Windows 10', 1, '2019-10-23 10:19:39', '2019-10-23 10:19:39'),
- (1608, 1, '管理员', '172.16.1.221', 57692, 'Chrome', 'Windows 10', 1, '2019-10-23 16:36:39', '2019-10-23 16:36:39'),
- (1609, 1, '管理员', '172.16.1.188', 57180, 'Chrome', 'Windows 7', 1, '2019-10-24 08:26:21', '2019-10-24 08:26:21'),
- (1610, 1, '管理员', '172.16.0.196', 61409, 'Chrome', 'Windows 10', 1, '2019-10-24 08:26:55', '2019-10-24 08:26:55'),
- (1611, 1, '管理员', '172.16.1.234', 51906, 'Chrome', 'Windows 10', 1, '2019-10-24 15:56:50', '2019-10-24 15:56:50'),
- (1612, 1, '管理员', '172.16.1.234', 56793, 'Chrome', 'Windows 10', 1, '2019-10-24 17:04:54', '2019-10-24 17:04:54'),
- (1613, 30, '耿为刚', '172.16.1.234', 60368, 'Chrome', 'Windows 10', 1, '2019-10-24 17:51:13', '2019-10-24 17:51:13'),
- (1614, 1, '管理员', '172.16.1.234', 60368, 'Chrome', 'Windows 10', 1, '2019-10-24 17:51:56', '2019-10-24 17:51:56'),
- (1615, 30, '耿为刚', '172.16.1.234', 60589, 'Chrome 65', 'Windows 10', 1, '2019-10-24 17:52:52', '2019-10-24 17:52:52'),
- (1616, 1, '管理员', '172.16.1.234', 52998, 'Chrome', 'Windows 10', 1, '2019-10-25 09:28:13', '2019-10-25 09:28:13'),
- (1617, 1, '管理员', '172.16.1.234', 54948, 'Chrome', 'Windows 10', 1, '2019-10-25 10:01:34', '2019-10-25 10:01:34'),
- (1618, 1, '管理员', '172.16.1.234', 56800, 'Chrome', 'Windows 10', 1, '2019-10-25 10:32:53', '2019-10-25 10:32:53'),
- (1619, 1, '管理员', '127.0.0.1', 59071, 'Chrome', 'Windows 7', 1, '2019-10-28 16:05:21', '2019-10-28 16:05:21'),
- (1620, 1, '管理员', '127.0.0.1', 60106, 'Chrome', 'Windows 7', 1, '2019-10-28 16:11:29', '2019-10-28 16:11:29'),
- (1621, 1, '管理员', '127.0.0.1', 63479, 'Chrome', 'Windows 7', 1, '2019-10-28 16:28:59', '2019-10-28 16:28:59'),
- (1622, 1, '管理员', '127.0.0.1', 63479, 'Chrome', 'Windows 7', 1, '2019-10-28 16:29:55', '2019-10-28 16:29:55'),
- (1623, 1, '管理员', '127.0.0.1', 57588, 'Chrome', 'Windows 7', 1, '2019-10-29 15:37:03', '2019-10-29 15:37:03'),
- (1741, 1, '管理员', '127.0.0.1', 54621, 'Chrome', 'Windows 7', 1, '2019-11-16 18:03:45', '2019-11-16 18:03:45');
- /*!40000 ALTER TABLE `t_user_login_log` ENABLE KEYS */;
- -- 导出 表 ly-fms.t_user_operate_log 结构
- DROP TABLE IF EXISTS `t_user_operate_log`;
- CREATE TABLE IF NOT EXISTS `t_user_operate_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `user_id` int(11) NOT NULL COMMENT '用户id',
- `user_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名称',
- `module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作模块',
- `content` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作内容',
- `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求路径',
- `method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求方法',
- `param` text COLLATE utf8mb4_unicode_ci COMMENT '请求参数',
- `result` tinyint(4) DEFAULT NULL COMMENT '请求结果 0失败 1成功',
- `fail_reason` longtext COLLATE utf8mb4_unicode_ci COMMENT '失败原因',
- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 正在导出表 ly-fms.t_user_operate_log 的数据:~32 rows (大约)
- /*!40000 ALTER TABLE `t_user_operate_log` DISABLE KEYS */;
- INSERT INTO `t_user_operate_log` (`id`, `user_id`, `user_name`, `module`, `content`, `url`, `method`, `param`, `result`, `fail_reason`, `update_time`, `create_time`) VALUES
- (1, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/0', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[0]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (2, 1, '管理员', '管理端-角色', '获取所有角色', '/smart-admin-api/role/getAll', 'com.gangquan360.smartadmin.module.role.basic.RoleController.getAllRole', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (3, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/1', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[1]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (4, 1, '管理员', '管理端-岗位', '分页查询所有岗位', '/smart-admin-api/position/getListPage', 'com.gangquan360.smartadmin.module.position.PositionController.getJobPage', 'PositionQueryDTO[{"pageNum":1,"pageSize":10,"positionName":"","searchCount":true,"sort":false}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (5, 1, '管理员', '管理端-角色', '获取所有角色', '/smart-admin-api/role/getAll', 'com.gangquan360.smartadmin.module.role.basic.RoleController.getAllRole', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (6, 1, '管理员', '管理端-部门', '根据部门名称查询部门及员工列表', '/smart-admin-api/department/listEmployeeByDepartmentName', 'com.gangquan360.smartadmin.module.department.DepartmentController.listDepartmentEmployee', 'String[""]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (7, 1, '管理员', '管理端-部门', '查询部门及员工列表', '/smart-admin-api/department/listEmployee', 'com.gangquan360.smartadmin.module.department.DepartmentController.listDepartmentEmployee', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (8, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (9, 1, '管理员', '管理端-用户', '员工重置密码', '/smart-admin-api/employee/resetPasswd/29', 'com.gangquan360.smartadmin.module.employee.EmployeeController.resetPasswd', 'Integer[29]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (10, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (11, 1, '管理员', '管理端-角色用户', '通过员工id获取所有角色以及员工具有的角色', '/smart-admin-api/role/getRoles/29', 'com.gangquan360.smartadmin.module.role.roleemployee.RoleEmployeeController.getRoleByEmployeeId', 'Long[29]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (12, 1, '管理员', '管理端-用户', '单个员工角色授权', '/smart-admin-api/employee/updateRoles', 'com.gangquan360.smartadmin.module.employee.EmployeeController.updateRoles', 'EmployeeUpdateRolesDTO[{"employeeId":29,"roleIds":[34,45]}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (13, 1, '管理员', '管理端-用户', '员工管理查询', '/smart-admin-api/employee/query', 'com.gangquan360.smartadmin.module.employee.EmployeeController.query', 'EmployeeQueryDTO[{"isDelete":0,"isDisabled":0,"keyword":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (14, 1, '管理员', '管理端-角色权限', '更新角色权限', '/smart-admin-api/privilege/updateRolePrivilege', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.updateRolePrivilege', 'RolePrivilegeDTO[{"privilegeKeyList":["Employee","RoleManage","PositionList","RoleEmployeeManage","SystemSetting","SystemConfig","SystemPrivilege","Notice","NoticeList","PersonNotice","Email","EmailList","SendMail","UserLog","UserOperateLog","UserLoginLog","Monitor","OnlineUser","Sql","Task","TaskList","Reload","SmartReloadList","ApiDoc","Swagger","ThreeRouter","LevelTwo","RoleOneTwo","RoleTwoTwo","RoleOneOne","KeepAlive","KeepAliveContentList","KeepAliveAddContent","HeartBeat","HeartBeatList","File","FileList","add-role","delete-role","update-role","update-role-privilege","add-employee-role","search-employee-list","delete-employee-role","delete-employee-role-batch","query-data-scope","update-data-scope","search-position","add-position","update-position","delete-position","add-department","update-department","delete-department","search-department","add-employee","update-employee","disabled-employee","disabled-employee-batch","update-employee-role","reset-employee-password","delete-employee","system-params-search","system-params-add","system-config-update","system-config-search","privilege-main-update","privilege-main-search","notice-query","notice-add","notice-edit","notice-delete","notice-detail","notice-send","person-notice-query","person-notice-detail","email-query","email-add","email-update","email-delete","email-send","user-operate-log-search","user-operate-log-detail","user-operate-log-delete","user-login-log-search","user-login-log-delete","online-user-search","task-search","task-refresh","task-add","task-update","task-pause","task-resume","task-run","task-query-log","task-delete","smart-reload-search","smart-reload-update","smart-reload-result","heart-beat-query","file-filePage-query","file-filePage-upload"],"roleId":1}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (15, 1, '管理员', '管理端-角色权限', '获取角色可选的功能权限', '/smart-admin-api/privilege/listPrivilegeByRoleId/1', 'com.gangquan360.smartadmin.module.role.roleprivilege.RolePrivilegeController.listPrivilegeByRoleId', 'Long[1]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (16, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (17, 1, '管理员', '管理端-系统配置', '修改配置参数', '/smart-admin-api/systemConfig/update', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.updateSystemConfig', 'SystemConfigUpdateDTO[{"configGroup":"upload","configKey":"ali_oss","configName":"阿里云上传配置","configValue":"{\\"accessKeyId\\":\\"\\",\\"accessKeySecret\\":\\"\\",\\"bucketName\\":\\"sit\\",\\"endpoint\\":\\"http://oss-cn-beijing.aliyuncs.com\\"}","id":14,"remark":"eefwfwfds"}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (18, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (19, 1, '管理员', '管理端-系统配置', '修改配置参数', '/smart-admin-api/systemConfig/update', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.updateSystemConfig', 'SystemConfigUpdateDTO[{"configGroup":"upload","configKey":"qi_niu_oss","configName":"七牛云上传配置","configValue":"{\\"accessKeyId\\":\\"rX7HgY1ZLpUD25JrA-uwMM_jj-\\",\\"accessKeySecret\\":\\"\\",\\"bucketName\\":\\"sun-smart-admin\\",\\"endpoint\\":\\"http://puvpyay08.bkt.clouddn.com\\"}","id":16}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (20, 1, '管理员', '管理端-系统配置', '分页查询所有系统配置', '/smart-admin-api/systemConfig/getListPage', 'com.gangquan360.smartadmin.module.systemconfig.SystemConfigController.getSystemConfigPage', 'SystemConfigQueryDTO[{"key":"","pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (21, 1, '管理员', '通用-权限', '获取所有请求路径', '/smart-admin-api/privilege/getAllUrl', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.getAllUrl', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (22, 1, '管理员', '通用-权限', '查询所有菜单项', '/smart-admin-api/privilege/menu/queryAll', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.queryAll', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (23, 1, '管理员', '通用-权限', '查询菜单功能点', '/smart-admin-api/privilege/function/query/FileList', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionQuery', 'String["FileList"]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (24, 1, '管理员', '通用-权限', '保存更新功能点', '/smart-admin-api/privilege/function/saveOrUpdate', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionSaveOrUpdate', 'PrivilegeFunctionDTO[{"functionKey":"file-filePage-download","functionName":"下载","menuKey":"FileList","sort":2,"url":"fileController.downLoadById"}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (25, 1, '管理员', '通用-权限', '查询菜单功能点', '/smart-admin-api/privilege/function/query/FileList', 'com.gangquan360.smartadmin.module.privilege.controller.PrivilegeController.functionQuery', 'String["FileList"]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (26, 1, '管理员', '通用-邮件发送', '分页查询', '/smart-admin-api/email/page/query', 'com.gangquan360.smartadmin.module.email.EmailController.queryByPage', 'EmailQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"startDate":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (27, 1, '管理员', '管理端-用户操作日志', '分页查询', '/smart-admin-api/userOperateLog/page/query', 'com.gangquan360.smartadmin.module.log.useroperatelog.UserOperateLogController.queryByPage', 'UserOperateLogQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"sort":false,"startDate":"","userName":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (28, 1, '管理员', '管理端-用户登录日志', '分页查询用户登录日志', '/smart-admin-api/userLoginLog/page/query', 'com.gangquan360.smartadmin.module.log.userloginlog.UserLoginLogController.queryByPage', 'UserLoginLogQueryDTO[{"endDate":"","pageNum":1,"pageSize":10,"searchCount":true,"sort":false,"startDate":"","userName":""}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (29, 1, '管理员', '管理端-用户登录日志', '查询员工在线状态', '/smart-admin-api/userOnLine/query', 'com.gangquan360.smartadmin.module.log.userloginlog.UserLoginLogController.queryUserOnLine', 'EmployeeQueryDTO[{"actualName":"","employeeIds":[1],"isDelete":0,"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (30, 1, '管理员', '管理端-任务调度', '查询任务', '/smart-admin-api/quartz/task/query', 'com.gangquan360.smartadmin.module.quartz.controller.QuartzController.query', 'QuartzQueryDTO[{"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (31, 1, '管理员', '管理端-smart reload', '获取全部Smart-reload项', '/smart-admin-api/smartReload/all', 'com.gangquan360.smartadmin.module.smartreload.SmartReloadController.listAllReloadItem', '', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00'),
- (32, 1, '管理员', '通用-心跳服务', '查询心跳记录 @author zhuoda', '/smart-admin-api/heartBeat/query', 'com.gangquan360.smartadmin.module.heartbeat.HeartBeatController.query', 'PageParamDTO[{"pageNum":1,"pageSize":10}]', 1, NULL, '2019-11-01 00:00:00', '2019-11-01 00:00:00');
- /*!40000 ALTER TABLE `t_user_operate_log` ENABLE KEYS */;
- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|