Tb_admin/数据库.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 47.111.246.47 (MySQL 5.6.49-log)
# Database: tb
# Generation Time: 2021-11-04 08:22:50 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table system_auth
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_auth`;

CREATE TABLE `system_auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) DEFAULT NULL COMMENT '权限名称',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '权限状态',
  `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序权重',
  `desc` varchar(255) DEFAULT '' COMMENT '备注说明',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_auth_status` (`status`) USING BTREE,
  KEY `idx_system_auth_title` (`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-权限';

LOCK TABLES `system_auth` WRITE;
/*!40000 ALTER TABLE `system_auth` DISABLE KEYS */;

INSERT INTO `system_auth` (`id`, `title`, `status`, `sort`, `desc`, `create_at`)
VALUES
	(1,'2',1,0,'12','2021-08-17 18:40:23'),
	(6,'角色2',1,0,'','2021-09-16 18:17:12'),
	(7,'1231231',1,0,'','2021-09-22 16:30:00'),
	(8,'证书管理员',1,0,'','2021-09-26 15:46:22'),
	(9,'普通员工',1,0,'','2021-09-26 16:01:00'),
	(10,'21312312',1,0,'','2021-09-28 21:23:00');

/*!40000 ALTER TABLE `system_auth` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_auth_node
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_auth_node`;

CREATE TABLE `system_auth_node` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `auth` bigint(20) unsigned DEFAULT NULL COMMENT '角色',
  `node` varchar(200) DEFAULT NULL COMMENT '节点',
  `auth_info` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_auth_auth` (`auth`) USING BTREE,
  KEY `idx_system_auth_node` (`node`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-权限-授权';

LOCK TABLES `system_auth_node` WRITE;
/*!40000 ALTER TABLE `system_auth_node` DISABLE KEYS */;

INSERT INTO `system_auth_node` (`id`, `auth`, `node`, `auth_info`, `time`)
VALUES
	(224,1,'','2,75,156,158,159,160,284,13,196,197,204,205,285,286,289,290,293,294,305,306',1632395093),
	(231,6,NULL,'2,5,147,148,149,7,150,151,152,153,75,155,156,157,158,159,160',1632395086),
	(232,7,NULL,'13,196,197,198,199,204,205,206,207,285,286,287,288,289,290,291,292,293,294,295,296,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,326,327,328,329',1632624062),
	(233,8,NULL,'2,158,159,160,284,13,330,331,332,333,334,335,336,337,358,359,360,361,362,363,364,365,366,367,368,369,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445',1632643248),
	(234,9,NULL,'2,158,159,160,284,13,330,331,332,334,335,336,338,339,340,346,347,348,350,351,352,358,359,360,362,363,364,366,367,368,370,372,374,375,376,378,379,380,382,383,384,386,387,388,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,406,407,408,410,411,41',1632646707);

/*!40000 ALTER TABLE `system_auth_node` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_car
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_car`;

CREATE TABLE `system_car` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(11) DEFAULT NULL,
  `programaid` int(255) DEFAULT NULL,
  `create_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组合导出表';

LOCK TABLES `system_car` WRITE;
/*!40000 ALTER TABLE `system_car` DISABLE KEYS */;

INSERT INTO `system_car` (`id`, `user_id`, `programaid`, `create_at`)
VALUES
	(3,10001,42,'2021-09-23 19:05:55'),
	(9,10000,44,'2021-09-24 09:10:57'),
	(10,10000,42,'2021-09-24 09:10:57'),
	(12,10000,46,'2021-09-24 09:28:13'),
	(13,10000,47,'2021-09-24 09:31:09'),
	(14,10000,48,'2021-09-24 09:34:27'),
	(20,10005,50,'2021-09-24 14:58:53'),
	(21,10005,45,'2021-09-24 14:58:53'),
	(41,10000,76,'2021-09-27 10:33:58'),
	(47,10000,87,'2021-09-29 09:57:58'),
	(48,10000,89,'2021-10-08 10:48:08'),
	(49,10000,90,'2021-10-08 17:17:31'),
	(50,10000,93,'2021-10-09 13:35:26'),
	(51,10000,94,'2021-10-09 14:02:26'),
	(52,10000,95,'2021-10-09 14:09:37'),
	(53,10000,98,'2021-10-09 14:19:31'),
	(54,10000,97,'2021-10-09 14:19:31'),
	(55,10000,100,'2021-10-09 14:40:28'),
	(56,10000,99,'2021-10-09 14:40:28'),
	(57,10000,102,'2021-10-11 09:01:19'),
	(58,10000,101,'2021-10-11 09:01:19'),
	(107,10000,108,'2021-10-13 14:04:32'),
	(108,10000,60,'2021-10-13 14:04:56'),
	(109,10000,74,'2021-10-13 14:05:07'),
	(110,10000,73,'2021-10-13 14:05:07'),
	(111,10000,78,'2021-10-13 14:05:19'),
	(112,10000,109,'2021-10-13 14:05:25'),
	(113,10000,71,'2021-10-13 14:05:36'),
	(114,10000,63,'2021-10-13 14:05:42'),
	(115,10000,115,'2021-10-13 14:25:19'),
	(116,10000,69,'2021-10-13 15:03:19'),
	(117,10000,61,'2021-10-13 15:04:01'),
	(118,10000,116,'2021-10-13 15:41:54'),
	(119,10000,117,'2021-10-13 15:44:56'),
	(120,10000,118,'2021-10-13 15:46:02'),
	(121,10000,119,'2021-10-13 16:17:56'),
	(122,10000,58,'2021-10-14 17:50:20'),
	(123,10000,120,'2021-10-14 18:01:07'),
	(124,10000,121,'2021-10-19 09:18:00');

/*!40000 ALTER TABLE `system_car` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_config`;

CREATE TABLE `system_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '配置名',
  `value` varchar(2000) DEFAULT '' COMMENT '配置值',
  `info` varchar(255) DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_config_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-配置';

LOCK TABLES `system_config` WRITE;
/*!40000 ALTER TABLE `system_config` DISABLE KEYS */;

INSERT INTO `system_config` (`id`, `name`, `value`, `info`)
VALUES
	(1,'app_name','投标资料管理系统',NULL),
	(2,'site_name','投标资料管理系统',NULL),
	(3,'app_version','dev',NULL),
	(4,'site_copy','©版权所有 2014-2018 楚才科技',NULL),
	(5,'site_icon','/upload/decb0fe26fa3f486/b3f6521bf29403c8.png',NULL),
	(7,'miitbeian','粤ICP备16006642号-2',NULL),
	(8,'storage_type','local',NULL),
	(9,'storage_local_exts','docx,gif,icon,jpg,mp3,mp4,p12,pem,png,rar,pdf',NULL),
	(10,'storage_qiniu_bucket','https',NULL),
	(11,'storage_qiniu_domain','用你自己的吧',NULL),
	(12,'storage_qiniu_access_key','用你自己的吧',NULL),
	(13,'storage_qiniu_secret_key','用你自己的吧',NULL),
	(14,'storage_oss_bucket','888',NULL),
	(15,'storage_oss_endpoint','oss-cn-beijing.aliyuncs.com',NULL),
	(16,'storage_oss_domain','tushangmen.oss-cn-beijing.aliyuncs.com',NULL),
	(17,'storage_oss_keyid','LTAI5tQatsyWswf31jrrh3dS',NULL),
	(18,'storage_oss_secret','KQeJ7mWq0povTXBzZA4Og9NjL6S79b',NULL),
	(36,'storage_oss_is_https','http',NULL),
	(43,'storage_qiniu_region','华东',NULL),
	(44,'storage_qiniu_is_https','https',NULL),
	(45,'wechat_mch_id','1609696205',NULL),
	(46,'wechat_mch_key','lMZIVguKAbGHqbBYOjqljOkDqQMG9o6R',NULL),
	(47,'wechat_mch_ssl_type','p12',NULL),
	(48,'wechat_mch_ssl_p12','65b8e4f56718182d/1bc857ee646aa15d.p12',NULL),
	(49,'wechat_mch_ssl_key','cc2e3e1345123930/c407d033294f283d.pem',NULL),
	(50,'wechat_mch_ssl_cer','966eaf89299e9c95/7014872cc109b29a.pem',NULL),
	(51,'wechat_token','mytoken',NULL),
	(52,'wechat_appid','wx39557f52d9cebf4a',NULL),
	(53,'wechat_appsecret','86814e184852a36aba7b5c001f9b46a9',NULL),
	(54,'wechat_encodingaeskey','',NULL),
	(55,'wechat_push_url','消息推送地址：http://127.0.0.1:8000/wechat/api.push',NULL),
	(56,'wechat_type','thr',NULL),
	(57,'wechat_thr_appid','wx60a43dd8161666d4',NULL),
	(58,'wechat_thr_appkey','5caf4b0727f6e46a7e6ccbe773cc955d',NULL),
	(60,'wechat_thr_appurl','消息推送地址：http://127.0.0.1:2314/wechat/api.push',NULL),
	(61,'component_appid','wx28b58798480874f9',NULL),
	(62,'component_appsecret','8d0e1ec14ea0adc5027dd0ad82c64bc9',NULL),
	(63,'component_token','P8QHTIxpBEq88IrxatqhgpBm2OAQROkI',NULL),
	(64,'component_encodingaeskey','L5uFIa0U6KLalPyXckyqoVIJYLhsfrg8k9YzybZIHsx',NULL),
	(65,'system_message_state','0',NULL),
	(66,'sms_zt_username','可以找CUCI申请',NULL),
	(67,'sms_zt_password','可以找CUCI申请',NULL),
	(68,'sms_reg_template','您的验证码为{code}，请在十分钟内完成操作！',NULL),
	(69,'sms_secure','可以找CUCI申请',NULL),
	(70,'store_title','设计接单APP',NULL),
	(71,'store_order_wait_time','0.50',NULL),
	(72,'store_order_clear_time','24.00',NULL),
	(73,'store_order_confirm_time','60.00',NULL),
	(74,'sms_zt_username2','可以找CUCI申请2',NULL),
	(75,'sms_zt_password2','可以找CUCI申请2',NULL),
	(76,'sms_secure2','可以找CUCI申请2',NULL),
	(77,'sms_reg_template2','您的验证码为{code}，请在十分钟内完成操作！2',NULL),
	(78,'michat_appid','2882303761518074614',NULL),
	(79,'michat_appkey','5861807470614',NULL),
	(80,'michat_appsecert','CP/WUTUgDuyOxgLQ5ztesg==',NULL),
	(87,'alipay_appid','2021002149643361','支付宝支付appid'),
	(88,'alipay_rsaPrivateKey','MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQCmlrw+SzbknVLvYyo0c4/H4YZOAu4Ap6DQeES3W1oeqyv32iFF/UEwNY5CUP0ohuMi8cyyeFew7pIQy8dROb1XOpdWoRZvutIiWt3pV/a5ozXljdR24J7foCdXtWRSsRxibxPxHMJa9uCcpvnOEnZiUWFLtgddQQgdSL5Kc2BCiE2BR8QltXwB1kSY3wsWp/dmSUzO1YnhgmRaANIxrMEEnlXl48fSLVwwUDpkdiT2WanLCmo28/5G2srIlrUxJfF7n5oGpT2JLaXVlT1Bc3+gFSepd5qYCAP5SWJR78USqCo2ILTDtrocMD2jGF/T3pmNdC7BhzhzoxUol04IwpqRAgMBAAECggEAOEFAsjyN/eeOoR44m1vG2vWyd9ePbZMtwBhNBCoKJb8h6uGzSMI76D69mnFk+/GI9Dz5Je9zlWEK3DckSK6Z3MIBZxSg0fwhh85tj6XPwGJ4Cdu6Oqahn9yiTIEJrs72Sds+vbY7f6JMuTm9s7QSXCMlGv8OP5R9W/47nEKX5/84c6aT03wNkEtLy4Lh73mVxb4oIt4pio//ZkkXlF4/w4750LsJ3crUmATegspzRH3QKNQr+bOdyVxFoawnh6pZHo+CYbt4AjcFa0Q1sJBq9KipniW/KDaapdAFxYE6tMlVUriEbv2Ve9smQTPUdf7ICCMDYYJZJCeqZF5iLnABLQKBgQDtO/YsMzewsmWiS12/5zNvlVGnCL97LUH7yZ3DexLYJrHBf4ij/cLv3sRjidS4+a788mg9fx5Y8v/hJAFwVayXekmnXwcxvpUv242EiYxrOzwwU6jpRpjW3UAeysKVY9uLx2usTrs0wGDA9VIqSJ04c9pdgsjcXcyExFR75HYdnwKBgQCzxDDIWz93z+vxPdLCITKydjilismsL+DuTdJrUTbVJYSwEpj5CygUQcwr5vBVo6dqzM7FBF6oMlIAAOTiuIqotiDUpVoUGbp2QD/EOwq/bgxPntQmI3q71fzAqLL2NyIZ8BdgxNIyRp+D8GnerJcPMQwwz0JiKfq3uH9/Xe/5zwKBgGJa4MYUeftNCywNORIN5dpWOuMYkmKcMeYVAc6A4SAycrH5kQoEdGSEpEFsbIBALFd8nNEaOdfA72tFRT9wlby7m3vDvzTVgf60dOjFKi1vApY6qSYF+enjEulxQNk07Fn4VOC8R4soUzTMwML9FgnIpnjsdyA910QYLbqrznibAoGAB2Gf6yosAfxsoLw8IjKAxWkrTEjVnRdeMgrKABQWn0vqFdy9oUQ/Ag3tl0PlTG7q2ezM9LQIOvnN+igPPev77Y+E65Zai4a+7EoZFDKkb1XSdZZ8+Y/tYzcXKMYEiy2aXdxI6XVLeDsEI8PEZRtLHJmT+ZEZFbTJka+mtJEj4GsCgYBqcl9XyL5q/THMS7uIYDsft+qWjbb2tOkCi0FjAaOqCfbV96aM7sEvqTLaHduoUIyoghIAQNZeHi39Rn0ddZzBqATWdyqSEtpUhEcNS2tA8W2LkJHe8F3f7A/ZCmOakIlO5I1WOrkprHOjBvkPOfFVPFjnRNYVwVIbKg/jF/AZ2A==','支付宝支付私钥'),
	(89,'alipay_RsaPublicKey','MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAppa8Pks25J1S72MqNHOPx+GGTgLuAKeg0HhEt1taHqsr99ohRf1BMDWOQlD9KIbjIvHMsnhXsO6SEMvHUTm9VzqXVqEWb7rSIlrd6Vf2uaM15Y3UduCe36AnV7VkUrEcYm8T8RzCWvbgnKb5zhJ2YlFhS7YHXUEIHUi+SnNgQohNgUfEJbV8AdZEmN8LFqf3ZklMztWJ4YJkWgDSMazBBJ5V5ePH0i1cMFA6ZHYk9lmpywpqNvP+RtrKyJa1MSXxe5+aBqU9iS2l1ZU9QXN/oBUnqXeamAgD+UliUe/FEqgqNiC0w7a6HDA9oxhf096ZjXQuwYc4c6MVKJdOCMKakQIDAQAB','支付宝支付公钥'),
	(90,'_token_','csrf6135b11a9d74d',NULL),
	(92,'small_wechat_id','wxdef89d7107305671',NULL),
	(93,'small_wechat_appsecret','71a2be9de55295c586301baff11dc769',NULL),
	(94,'ali_accesskey','LTAIs4hsJe0mfYuz',NULL),
	(95,'ali_accesskey_secret','Bm3H1dvcPs9jniSKzFRDrBh98Y2a6y',NULL),
	(96,'templateCode','SMS_166371909',NULL),
	(107,'email','liqin457@163.com','邮箱'),
	(108,'phone','18033408666','电话'),
	(109,'switch','1','游客看到联系方式开关  1：开 0：关'),
	(110,'about_us','<div style=\"margin-top: 13px; margin-left: 36px; text-indent: -0.38in;\"><span style=\"language:zh-CN\"><span style=\"unicode-bidi:embed\"><span style=\"word-break:normal\"><span style=\"punctuation-wrap:hanging\"><span style=\"font-size:18.0pt\"><span style=\"font-family:幼圆\"><span style=\"color:#404040\"><span style=\"language:zh-CN\">&nbsp; &nbsp; &nbsp;&nbsp;<span style=\"font-size:16px;\">疫情防控时代，需求方与资源方，见面越来越难，我们的项目落地需求、资源承接需求愈发迫切，基于此我们做了这个产品。</span></span></span></span></span></span></span></span></span><span style=\"font-size:16px;\"><span style=\"unicode-bidi:embed\"><span style=\"word-break:normal\"><span style=\"font-family:幼圆\"><span style=\"color:#404040\">打通资源方和资源需求方信息不对称的局面，让资源需求方对自己的需求可满足的资源可视化、图形化、一目了然；节省大量的人力物力去从事采购工作,让资源方快速销售掉自己的资源，让自己的投资汇报高效回收；同时节约大量的人力财力去营销自己的资源,后期还会为资源提供方提供催款、核对流量、核对费用的工作压缩资金回笼的周期，减少回款压力；为资源采购方争取资源的优惠权益，为资源使用方提供资源核查、资源落地、资源开通等专业的服务。</span></span></span></span></span></div>\r\n\r\n<p>&nbsp;</p>\r\n','关于我们');

/*!40000 ALTER TABLE `system_config` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_data
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_data`;

CREATE TABLE `system_data` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '配置名',
  `value` longtext COMMENT '配置值',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_data_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-数据';

LOCK TABLES `system_data` WRITE;
/*!40000 ALTER TABLE `system_data` DISABLE KEYS */;

INSERT INTO `system_data` (`id`, `name`, `value`)
VALUES
	(1,'menudata','[{\"name\":\"请输入名称\",\"type\":\"scancode_push\",\"key\":\"scancode_push\"}]'),
	(2,NULL,'w');

/*!40000 ALTER TABLE `system_data` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_log`;

CREATE TABLE `system_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `node` varchar(200) NOT NULL DEFAULT '' COMMENT '当前操作节点',
  `geoip` varchar(15) NOT NULL DEFAULT '' COMMENT '操作者IP地址',
  `action` varchar(200) NOT NULL DEFAULT '' COMMENT '操作行为名称',
  `content` varchar(1024) NOT NULL DEFAULT '' COMMENT '操作内容描述',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人用户名',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-日志';

LOCK TABLES `system_log` WRITE;
/*!40000 ALTER TABLE `system_log` DISABLE KEYS */;

INSERT INTO `system_log` (`id`, `node`, `geoip`, `action`, `content`, `username`, `create_at`)
VALUES
	(1,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','123456','2021-09-10 14:05:59'),
	(2,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','admin','2021-09-10 14:51:28'),
	(3,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','123456','2021-09-10 14:52:00'),
	(4,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','admin','2021-09-10 14:53:00'),
	(5,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','123456','2021-09-10 14:53:24'),
	(6,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','admin','2021-09-10 14:55:24'),
	(7,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','123456','2021-09-10 14:56:21'),
	(8,'admin/login/index','112.234.152.141','系统管理','用户登录系统后台成功','admin','2021-09-10 15:33:36'),
	(9,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-16 16:56:28'),
	(10,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-16 17:07:10'),
	(11,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-16 17:08:30'),
	(12,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-16 17:09:18'),
	(13,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-16 17:53:46'),
	(14,'admin/login/index','124.65.8.30','系统管理','用户登录系统后台成功','admin','2021-09-16 18:08:53'),
	(15,'admin/login/index','117.61.246.93','系统管理','用户登录系统后台成功','admin','2021-09-16 18:09:38'),
	(16,'admin/login/index','124.65.9.196','系统管理','用户登录系统后台成功','admin','2021-09-16 18:36:29'),
	(17,'admin/login/index','117.61.246.93','系统管理','用户登录系统后台成功','admin','2021-09-16 18:39:14'),
	(18,'admin/login/index','117.61.246.93','系统管理','用户登录系统后台成功','admin','2021-09-16 18:51:40'),
	(19,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-17 09:55:54'),
	(20,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-17 16:50:48'),
	(21,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-17 19:48:21'),
	(22,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-18 09:14:24'),
	(23,'admin/login/index','124.65.8.30','系统管理','用户登录系统后台成功','admin','2021-09-18 09:14:51'),
	(24,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-18 09:59:29'),
	(25,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-18 10:04:52'),
	(26,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-18 10:26:02'),
	(27,'admin/login/index','124.65.8.74','系统管理','用户登录系统后台成功','admin','2021-09-18 10:34:38'),
	(28,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-18 11:49:54'),
	(29,'admin/login/index','124.65.8.30','系统管理','用户登录系统后台成功','admin','2021-09-18 13:41:43'),
	(30,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-18 13:46:11'),
	(31,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-18 15:03:29'),
	(32,'admin/login/index','124.65.8.74','系统管理','用户登录系统后台成功','admin','2021-09-18 15:22:19'),
	(33,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-22 10:13:32'),
	(34,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-22 11:02:15'),
	(35,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-22 11:09:58'),
	(36,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-22 11:13:21'),
	(37,'admin/login/index','124.65.8.251','系统管理','用户登录系统后台成功','admin','2021-09-22 11:25:36'),
	(38,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','admin','2021-09-22 14:56:12'),
	(39,'admin/login/index','112.228.184.201','系统管理','用户登录系统后台成功','123456','2021-09-22 15:26:50'),
	(40,'admin/login/index','124.65.9.85','系统管理','用户登录系统后台成功','admin','2021-09-22 16:23:11'),
	(41,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-22 16:26:44'),
	(42,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-22 16:38:04'),
	(43,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-22 18:40:12'),
	(44,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-22 18:41:32'),
	(45,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 09:29:30'),
	(46,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','123456','2021-09-23 09:33:32'),
	(47,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 09:39:57'),
	(48,'admin/login/index','124.65.9.237','系统管理','用户登录系统后台成功','admin','2021-09-23 09:57:46'),
	(49,'admin/login/index','124.65.9.237','系统管理','用户登录系统后台成功','admin','2021-09-23 09:59:26'),
	(50,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 09:59:46'),
	(51,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-23 10:02:58'),
	(52,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 10:04:51'),
	(53,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 10:10:16'),
	(54,'admin/login/index','124.65.9.237','系统管理','用户登录系统后台成功','admin','2021-09-23 11:33:21'),
	(55,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-23 11:39:26'),
	(56,'admin/login/index','124.65.9.237','系统管理','用户登录系统后台成功','admin','2021-09-23 11:47:22'),
	(57,'admin/login/index','124.65.9.237','系统管理','用户登录系统后台成功','admin','2021-09-23 11:47:34'),
	(58,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 12:09:04'),
	(59,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 12:11:11'),
	(60,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 12:52:17'),
	(61,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-23 13:40:42'),
	(62,'admin/login/index','117.61.241.244','系统管理','用户登录系统后台成功','admin','2021-09-23 13:41:42'),
	(63,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','123456','2021-09-23 13:49:54'),
	(64,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 14:38:03'),
	(65,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 14:41:57'),
	(66,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 14:44:48'),
	(67,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 14:47:00'),
	(68,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','0000','2021-09-23 14:47:01'),
	(69,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','0000','2021-09-23 15:11:32'),
	(70,'admin/login/index','124.65.9.90','系统管理','用户登录系统后台成功','admin','2021-09-23 15:55:26'),
	(71,'admin/login/index','124.65.9.90','系统管理','用户登录系统后台成功','admin','2021-09-23 16:00:17'),
	(72,'admin/login/index','124.65.9.90','系统管理','用户登录系统后台成功','admin','2021-09-23 16:01:53'),
	(73,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','123456','2021-09-23 17:18:08'),
	(74,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:20:29'),
	(75,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','123456','2021-09-23 17:20:47'),
	(76,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:26:11'),
	(77,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:31:36'),
	(78,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:33:47'),
	(79,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 17:42:36'),
	(80,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 17:43:24'),
	(81,'admin/login/index','124.65.9.85','系统管理','用户登录系统后台成功','admin','2021-09-23 17:44:22'),
	(82,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 17:51:46'),
	(83,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','0000','2021-09-23 17:52:18'),
	(84,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 17:54:37'),
	(85,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:56:08'),
	(86,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:58:52'),
	(87,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','admin','2021-09-23 17:59:22'),
	(88,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 18:12:53'),
	(89,'admin/login/index','39.144.15.141','系统管理','用户登录系统后台成功','admin','2021-09-23 18:36:51'),
	(90,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','Test','2021-09-23 18:46:49'),
	(91,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 18:47:22'),
	(92,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','Test','2021-09-23 18:48:02'),
	(93,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 18:48:34'),
	(94,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','Test','2021-09-23 18:49:07'),
	(95,'admin/login/index','124.65.8.185','系统管理','用户登录系统后台成功','admin','2021-09-23 18:49:51'),
	(96,'admin/login/index','39.76.244.111','系统管理','用户登录系统后台成功','123456','2021-09-23 19:05:46'),
	(97,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 09:12:18'),
	(98,'admin/login/index','124.65.9.90','系统管理','用户登录系统后台成功','admin','2021-09-24 09:15:17'),
	(99,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-24 09:36:56'),
	(100,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 09:37:46'),
	(101,'admin/login/index','27.218.180.170','系统管理','用户登录系统后台成功','admin','2021-09-24 10:42:11'),
	(102,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','admin','2021-09-24 14:00:42'),
	(103,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','admin','2021-09-24 14:12:03'),
	(104,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 14:18:00'),
	(105,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','mulaoshi','2021-09-24 14:56:56'),
	(106,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','admin','2021-09-24 14:58:06'),
	(107,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','mulaoshi','2021-09-24 14:58:44'),
	(108,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 16:55:56'),
	(109,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-24 17:02:59'),
	(110,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 17:03:42'),
	(111,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-24 17:06:09'),
	(112,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 17:11:53'),
	(113,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-24 17:12:59'),
	(114,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-24 17:16:12'),
	(115,'admin/login/index','124.65.9.233','系统管理','用户登录系统后台成功','admin','2021-09-24 17:21:24'),
	(116,'admin/login/index','27.218.180.170','系统管理','用户登录系统后台成功','admin','2021-09-24 17:25:18'),
	(117,'admin/login/index','112.228.176.6','系统管理','用户登录系统后台成功','admin','2021-09-25 14:45:31'),
	(118,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-26 09:29:16'),
	(119,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-26 09:36:10'),
	(120,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-26 09:36:41'),
	(121,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','Test','2021-09-26 09:37:21'),
	(122,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-26 09:38:05'),
	(123,'admin/login/index','27.218.178.195','系统管理','用户登录系统后台成功','admin','2021-09-26 10:48:46'),
	(124,'admin/login/index','27.218.178.195','系统管理','用户登录系统后台成功','admin','2021-09-26 14:01:17'),
	(125,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-26 14:28:55'),
	(126,'admin/login/index','121.69.43.54','系统管理','用户登录系统后台成功','admin','2021-09-26 15:06:26'),
	(127,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','zsgly','2021-09-26 15:49:35'),
	(128,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-26 15:50:23'),
	(129,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','zsgly','2021-09-26 15:51:50'),
	(130,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-26 15:54:33'),
	(131,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','ptyg','2021-09-26 17:06:47'),
	(132,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-26 17:08:09'),
	(133,'admin/login/index','124.64.19.128','系统管理','用户登录系统后台成功','admin','2021-09-27 10:30:00'),
	(134,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-27 11:02:25'),
	(135,'admin/login/index','39.76.71.109','系统管理','用户登录系统后台成功','admin','2021-09-27 14:16:56'),
	(136,'admin/login/index','124.65.8.55','系统管理','用户登录系统后台成功','admin','2021-09-27 16:23:58'),
	(137,'admin/login/index','124.65.8.2','系统管理','用户登录系统后台成功','admin','2021-09-27 19:22:52'),
	(138,'admin/login/index','124.65.9.3','系统管理','用户登录系统后台成功','admin','2021-09-28 09:47:01'),
	(139,'admin/login/index','39.76.58.60','系统管理','用户登录系统后台成功','123456','2021-09-28 09:52:58'),
	(140,'admin/login/index','124.202.222.157','系统管理','用户登录系统后台成功','admin','2021-09-28 13:53:31'),
	(141,'admin/login/index','124.202.214.30','系统管理','用户登录系统后台成功','admin','2021-09-28 16:26:01'),
	(142,'admin/login/index','124.202.214.30','系统管理','用户登录系统后台成功','admin','2021-09-28 16:43:53'),
	(143,'admin/login/index','39.67.148.33','系统管理','用户登录系统后台成功','admin','2021-09-29 14:21:51'),
	(144,'admin/login/index','124.65.9.121','系统管理','用户登录系统后台成功','admin','2021-09-30 10:57:55'),
	(145,'admin/login/index','117.61.244.188','系统管理','用户登录系统后台成功','admin','2021-09-30 14:03:28'),
	(146,'admin/login/index','124.65.9.121','系统管理','用户登录系统后台成功','admin','2021-09-30 15:13:50'),
	(147,'admin/login/index','124.202.214.30','系统管理','用户登录系统后台成功','admin','2021-10-08 10:07:58'),
	(148,'admin/login/index','124.65.9.57','系统管理','用户登录系统后台成功','admin','2021-10-08 11:55:29'),
	(149,'admin/login/index','124.65.8.251','系统管理','用户登录系统后台成功','admin','2021-10-08 17:16:06'),
	(150,'admin/login/index','124.65.9.57','系统管理','用户登录系统后台成功','admin','2021-10-08 18:00:45'),
	(151,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 09:09:49'),
	(152,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-09 13:58:27'),
	(153,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-09 14:04:31'),
	(154,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 14:13:43'),
	(155,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-09 15:45:01'),
	(156,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 16:42:58'),
	(157,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 16:55:03'),
	(158,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 16:55:22'),
	(159,'admin/login/index','112.228.188.16','系统管理','用户登录系统后台成功','admin','2021-10-09 16:55:53'),
	(160,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-11 08:58:35'),
	(161,'admin/login/index','124.65.9.154','系统管理','用户登录系统后台成功','admin','2021-10-11 09:02:03'),
	(162,'admin/login/index','112.228.225.104','系统管理','用户登录系统后台成功','admin','2021-10-11 11:31:18'),
	(163,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-11 11:34:55'),
	(164,'admin/login/index','115.47.153.247','系统管理','用户登录系统后台成功','admin','2021-10-12 09:56:50'),
	(165,'admin/login/index','115.47.153.247','系统管理','用户登录系统后台成功','admin','2021-10-12 10:17:45'),
	(166,'admin/login/index','115.47.153.247','系统管理','用户登录系统后台成功','admin','2021-10-12 10:23:31'),
	(167,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-12 10:58:54'),
	(168,'admin/login/index','115.47.153.247','系统管理','用户登录系统后台成功','admin','2021-10-12 11:02:56'),
	(169,'admin/login/index','115.47.153.247','系统管理','用户登录系统后台成功','admin','2021-10-12 11:23:45'),
	(170,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-12 13:40:43'),
	(171,'admin/login/index','27.218.189.131','系统管理','用户登录系统后台成功','admin','2021-10-13 09:22:27'),
	(172,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-13 09:49:20'),
	(173,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-13 13:54:04'),
	(174,'admin/login/index','124.202.214.30','系统管理','用户登录系统后台成功','admin','2021-10-13 14:03:51'),
	(175,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-13 14:24:37'),
	(176,'admin/login/index','124.65.9.179','系统管理','用户登录系统后台成功','admin','2021-10-13 14:58:23'),
	(177,'admin/login/index','124.65.9.75','系统管理','用户登录系统后台成功','admin','2021-10-13 15:25:02'),
	(178,'admin/login/index','124.202.214.30','系统管理','用户登录系统后台成功','admin','2021-10-13 15:42:50'),
	(179,'admin/login/index','27.218.189.131','系统管理','用户登录系统后台成功','admin','2021-10-14 14:41:52'),
	(180,'admin/login/index','124.65.9.47','系统管理','用户登录系统后台成功','admin','2021-10-14 17:50:07'),
	(181,'admin/login/index','117.61.242.112','系统管理','用户登录系统后台成功','admin','2021-10-14 17:54:22'),
	(182,'admin/login/index','117.61.242.112','系统管理','用户登录系统后台成功','admin','2021-10-14 18:01:55'),
	(183,'admin/login/index','202.60.134.227','系统管理','用户登录系统后台成功','admin','2021-10-15 09:24:05'),
	(184,'admin/login/index','27.218.187.97','系统管理','用户登录系统后台成功','admin','2021-10-15 09:43:50'),
	(185,'admin/login/index','221.217.137.245','系统管理','用户登录系统后台成功','admin','2021-10-18 09:26:03'),
	(186,'admin/login/index','27.218.181.86','系统管理','用户登录系统后台成功','admin','2021-10-18 13:07:33'),
	(187,'admin/login/index','27.218.181.86','系统管理','用户登录系统后台成功','admin','2021-10-18 15:19:27'),
	(188,'admin/login/index','221.217.139.120','系统管理','用户登录系统后台成功','admin','2021-10-18 18:27:50'),
	(189,'admin/login/index','221.217.139.120','系统管理','用户登录系统后台成功','admin','2021-10-19 09:15:53'),
	(190,'admin/login/index','112.228.190.218','系统管理','用户登录系统后台成功','admin','2021-11-03 17:00:30'),
	(191,'admin/login/index','114.63.19.203','系统管理','用户登录系统后台成功','admin','2021-11-03 21:52:56');

/*!40000 ALTER TABLE `system_log` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_menu
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_menu`;

CREATE TABLE `system_menu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) unsigned DEFAULT '0' COMMENT '父ID',
  `title` varchar(100) DEFAULT '' COMMENT '名称',
  `node` varchar(200) DEFAULT '' COMMENT '节点代码',
  `icon` varchar(100) DEFAULT '' COMMENT '菜单图标',
  `url` varchar(400) DEFAULT '' COMMENT '链接',
  `params` varchar(500) DEFAULT '' COMMENT '链接参数',
  `target` varchar(20) DEFAULT '_self' COMMENT '打开方式',
  `sort` int(11) unsigned DEFAULT '0' COMMENT '菜单排序',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `type` tinyint(1) DEFAULT '0',
  `level` tinyint(1) DEFAULT '1',
  `auth_show` tinyint(1) DEFAULT '1',
  `fpid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_menu_node` (`node`(191)) USING BTREE,
  KEY `idx_system_menu_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-菜单';

LOCK TABLES `system_menu` WRITE;
/*!40000 ALTER TABLE `system_menu` DISABLE KEYS */;

INSERT INTO `system_menu` (`id`, `pid`, `title`, `node`, `icon`, `url`, `params`, `target`, `sort`, `status`, `create_at`, `type`, `level`, `auth_show`, `fpid`)
VALUES
	(2,0,'设置','','','#','','_self',100,1,'2018-09-05 18:04:52',0,1,1,0),
	(5,2,'账号管理','','','admin/user/index','id=5','_self',3,1,'2018-09-06 11:10:42',0,1,1,2),
	(7,2,'角色管理','','','admin/auth/index','id=7','_self',2,1,'2018-09-06 15:17:14',0,1,1,2),
	(13,0,'首页','','','#','','_self',99,1,'2018-10-12 13:56:29',0,1,1,0),
	(75,2,'栏目管理','','','admin/column/index','id=75','_self',1,1,'2021-09-06 17:00:39',0,1,1,2),
	(147,5,'新建','','','admin/user/add','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(148,5,'编辑','','','admin/user/edit','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(149,5,'删除','','','admin/user/remove','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(150,7,'新建','','','admin/auth/add','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(151,7,'编辑','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(152,7,'删除','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(153,7,'设置权限','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(155,75,'新建','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(156,75,'编辑','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(157,75,'删除','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(158,2,'首页','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,2),
	(159,158,'组合导出','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(160,158,'资料上传','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(194,5,'密码','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(284,158,'删除','','','','','_self',1,0,'2018-09-06 11:10:42',0,1,1,0),
	(306,305,'列表','','','','','_self',0,0,'2021-09-23 10:13:49',0,1,1,0),
	(307,305,'下载','','','','','_self',0,0,'2021-09-23 10:13:49',0,1,1,0),
	(308,305,'删除','','','','','_self',0,0,'2021-09-23 10:13:49',0,1,1,0),
	(327,326,'列表','','','','','_self',0,0,'2021-09-26 09:41:20',0,1,1,0),
	(328,326,'下载','','','','','_self',0,0,'2021-09-26 09:41:20',0,1,1,0),
	(329,326,'删除','','','','','_self',0,0,'2021-09-26 09:41:20',0,1,1,0),
	(330,13,'资质证照','','','admin/programa/index','id=330','_self',1,1,'2021-09-26 14:31:16',1,1,1,13),
	(331,330,'列表','','','','','_self',0,0,'2021-09-26 14:31:17',0,1,1,0),
	(332,330,'下载','','','','','_self',0,0,'2021-09-26 14:31:17',0,1,1,0),
	(333,330,'删除','','','','','_self',0,0,'2021-09-26 14:31:17',0,1,1,0),
	(334,13,'人员证书','','','admin/programa/index','id=334','_self',2,1,'2021-09-26 14:31:37',1,1,1,13),
	(335,334,'列表','','','','','_self',0,0,'2021-09-26 14:31:37',0,1,1,0),
	(336,334,'下载','','','','','_self',0,0,'2021-09-26 14:31:37',0,1,1,0),
	(337,334,'删除','','','','','_self',0,0,'2021-09-26 14:31:37',0,1,1,0),
	(338,13,'业绩','','','admin/programa/index','id=338','_self',3,1,'2021-09-26 14:31:47',1,1,1,13),
	(339,338,'列表','','','','','_self',0,0,'2021-09-26 14:31:47',0,1,1,0),
	(340,338,'下载','','','','','_self',0,0,'2021-09-26 14:31:47',0,1,1,0),
	(341,338,'删除','','','','','_self',0,0,'2021-09-26 14:31:47',0,1,1,0),
	(346,330,'甲级资质','','','admin/programa/index','id=346','_self',0,1,'2021-09-26 14:34:04',1,2,1,13),
	(347,346,'列表','','','','','_self',0,0,'2021-09-26 14:34:04',0,1,1,0),
	(348,346,'下载','','','','','_self',0,0,'2021-09-26 14:34:04',0,1,1,0),
	(349,346,'删除','','','','','_self',0,0,'2021-09-26 14:34:04',0,1,1,0),
	(350,330,'荣誉证书','','','admin/programa/index','id=350','_self',0,1,'2021-09-26 14:34:16',1,2,1,13),
	(351,350,'列表','','','','','_self',0,0,'2021-09-26 14:34:16',0,1,1,0),
	(352,350,'下载','','','','','_self',0,0,'2021-09-26 14:34:16',0,1,1,0),
	(353,350,'删除','','','','','_self',0,0,'2021-09-26 14:34:16',0,1,1,0),
	(358,334,'一级造价师','','','admin/programa/index','id=358','_self',0,1,'2021-09-26 14:36:13',1,2,1,13),
	(359,358,'列表','','','','','_self',0,0,'2021-09-26 14:36:13',0,1,1,0),
	(360,358,'下载','','','','','_self',0,0,'2021-09-26 14:36:13',0,1,1,0),
	(361,358,'删除','','','','','_self',0,0,'2021-09-26 14:36:13',0,1,1,0),
	(362,334,'一级建造师','','','admin/programa/index','id=362','_self',0,1,'2021-09-26 14:36:23',1,2,1,13),
	(363,362,'列表','','','','','_self',0,0,'2021-09-26 14:36:23',0,1,1,0),
	(364,362,'下载','','','','','_self',0,0,'2021-09-26 14:36:23',0,1,1,0),
	(365,362,'删除','','','','','_self',0,0,'2021-09-26 14:36:23',0,1,1,0),
	(366,334,'高级工程师','','','admin/programa/index','id=366','_self',0,1,'2021-09-26 14:36:34',1,2,1,13),
	(367,366,'列表','','','','','_self',0,0,'2021-09-26 14:36:34',0,1,1,0),
	(368,366,'下载','','','','','_self',0,0,'2021-09-26 14:36:34',0,1,1,0),
	(369,366,'删除','','','','','_self',0,0,'2021-09-26 14:36:34',0,1,1,0),
	(370,338,'造价咨询','','','admin/programa/index','id=370','_self',0,1,'2021-09-26 14:37:25',1,2,1,13),
	(371,370,'列表','','','','','_self',0,0,'2021-09-26 14:37:25',0,1,1,0),
	(372,370,'下载','','','','','_self',0,0,'2021-09-26 14:37:25',0,1,1,0),
	(373,370,'删除','','','','','_self',0,0,'2021-09-26 14:37:25',0,1,1,0),
	(374,338,'项目管理','','','admin/programa/index','id=374','_self',0,1,'2021-09-26 14:37:36',1,2,1,13),
	(375,374,'列表','','','','','_self',0,0,'2021-09-26 14:37:36',0,1,1,0),
	(376,374,'下载','','','','','_self',0,0,'2021-09-26 14:37:36',0,1,1,0),
	(377,374,'删除','','','','','_self',0,0,'2021-09-26 14:37:36',0,1,1,0),
	(378,338,'投资咨询','','','admin/programa/index','id=378','_self',0,1,'2021-09-26 14:37:46',1,2,1,13),
	(379,378,'列表','','','','','_self',0,0,'2021-09-26 14:37:46',0,1,1,0),
	(380,378,'下载','','','','','_self',0,0,'2021-09-26 14:37:46',0,1,1,0),
	(381,378,'删除','','','','','_self',0,0,'2021-09-26 14:37:46',0,1,1,0),
	(382,13,'投标方案','','','admin/programa/index','id=382','_self',4,1,'2021-09-26 14:39:54',1,1,1,13),
	(383,382,'列表','','','','','_self',0,0,'2021-09-26 14:39:54',0,1,1,0),
	(384,382,'下载','','','','','_self',0,0,'2021-09-26 14:39:54',0,1,1,0),
	(385,382,'删除','','','','','_self',0,0,'2021-09-26 14:39:54',0,1,1,0),
	(386,330,'营业执照','','','admin/programa/index','id=386','_self',0,1,'2021-09-26 14:47:24',1,2,1,13),
	(387,386,'列表','','','','','_self',0,0,'2021-09-26 14:47:24',0,1,1,0),
	(388,386,'下载','','','','','_self',0,0,'2021-09-26 14:47:24',0,1,1,0),
	(389,386,'删除','','','','','_self',0,0,'2021-09-26 14:47:24',0,1,1,0),
	(390,382,'造价咨询','','','admin/programa/index','id=390','_self',0,1,'2021-09-26 15:11:48',1,2,1,13),
	(391,390,'列表','','','','','_self',0,0,'2021-09-26 15:11:48',0,1,1,0),
	(392,390,'下载','','','','','_self',0,0,'2021-09-26 15:11:48',0,1,1,0),
	(393,390,'删除','','','','','_self',0,0,'2021-09-26 15:11:48',0,1,1,0),
	(394,382,'投资咨询','','','admin/programa/index','id=394','_self',0,1,'2021-09-26 15:11:57',1,2,1,13),
	(395,394,'列表','','','','','_self',0,0,'2021-09-26 15:11:57',0,1,1,0),
	(396,394,'下载','','','','','_self',0,0,'2021-09-26 15:11:57',0,1,1,0),
	(397,394,'删除','','','','','_self',0,0,'2021-09-26 15:11:57',0,1,1,0),
	(398,382,'项目管理','','','admin/programa/index','id=398','_self',0,1,'2021-09-26 15:12:08',1,2,1,13),
	(399,398,'列表','','','','','_self',0,0,'2021-09-26 15:12:08',0,1,1,0),
	(400,398,'下载','','','','','_self',0,0,'2021-09-26 15:12:08',0,1,1,0),
	(401,398,'删除','','','','','_self',0,0,'2021-09-26 15:12:08',0,1,1,0),
	(402,382,'招标代理','','','admin/programa/index','id=402','_self',0,1,'2021-09-26 15:12:23',1,2,1,13),
	(403,402,'列表','','','','','_self',0,0,'2021-09-26 15:12:23',0,1,1,0),
	(404,402,'下载','','','','','_self',0,0,'2021-09-26 15:12:23',0,1,1,0),
	(405,402,'删除','','','','','_self',0,0,'2021-09-26 15:12:23',0,1,1,0),
	(406,330,'企业介绍','','','admin/programa/index','id=406','_self',0,1,'2021-09-26 15:26:29',1,2,1,13),
	(407,406,'列表','','','','','_self',0,0,'2021-09-26 15:26:29',0,1,1,0),
	(408,406,'下载','','','','','_self',0,0,'2021-09-26 15:26:29',0,1,1,0),
	(409,406,'删除','','','','','_self',0,0,'2021-09-26 15:26:29',0,1,1,0),
	(410,334,'监理工程师','','','admin/programa/index','id=410','_self',0,1,'2021-09-26 15:40:34',1,2,1,13),
	(411,410,'列表','','','','','_self',0,0,'2021-09-26 15:40:34',0,1,1,0),
	(412,410,'下载','','','','','_self',0,0,'2021-09-26 15:40:34',0,1,1,0),
	(413,410,'删除','','','','','_self',0,0,'2021-09-26 15:40:34',0,1,1,0),
	(414,334,'咨询师（投资）','','','admin/programa/index','id=414','_self',0,1,'2021-09-26 15:40:48',1,2,1,13),
	(415,414,'列表','','','','','_self',0,0,'2021-09-26 15:40:48',0,1,1,0),
	(416,414,'下载','','','','','_self',0,0,'2021-09-26 15:40:48',0,1,1,0),
	(417,414,'删除','','','','','_self',0,0,'2021-09-26 15:40:48',0,1,1,0),
	(418,334,'二级造价师','','','admin/programa/index','id=418','_self',0,1,'2021-09-26 15:42:00',1,2,1,13),
	(419,418,'列表','','','','','_self',0,0,'2021-09-26 15:42:00',0,1,1,0),
	(420,418,'下载','','','','','_self',0,0,'2021-09-26 15:42:00',0,1,1,0),
	(421,418,'删除','','','','','_self',0,0,'2021-09-26 15:42:00',0,1,1,0),
	(422,334,'二级建造师','','','admin/programa/index','id=422','_self',0,1,'2021-09-26 15:42:13',1,2,1,13),
	(423,422,'列表','','','','','_self',0,0,'2021-09-26 15:42:13',0,1,1,0),
	(424,422,'下载','','','','','_self',0,0,'2021-09-26 15:42:13',0,1,1,0),
	(425,422,'删除','','','','','_self',0,0,'2021-09-26 15:42:13',0,1,1,0),
	(426,334,'工程师','','','admin/programa/index','id=426','_self',0,1,'2021-09-26 15:42:21',1,2,1,13),
	(427,426,'列表','','','','','_self',0,0,'2021-09-26 15:42:21',0,1,1,0),
	(428,426,'下载','','','','','_self',0,0,'2021-09-26 15:42:21',0,1,1,0),
	(429,426,'删除','','','','','_self',0,0,'2021-09-26 15:42:21',0,1,1,0),
	(430,334,'经济师','','','admin/programa/index','id=430','_self',0,1,'2021-09-26 15:42:29',1,2,1,13),
	(431,430,'列表','','','','','_self',0,0,'2021-09-26 15:42:29',0,1,1,0),
	(432,430,'下载','','','','','_self',0,0,'2021-09-26 15:42:29',0,1,1,0),
	(433,430,'删除','','','','','_self',0,0,'2021-09-26 15:42:29',0,1,1,0),
	(434,334,'高级经济师','','','admin/programa/index','id=434','_self',0,1,'2021-09-26 15:42:38',1,2,1,13),
	(435,434,'列表','','','','','_self',0,0,'2021-09-26 15:42:38',0,1,1,0),
	(436,434,'下载','','','','','_self',0,0,'2021-09-26 15:42:38',0,1,1,0),
	(437,434,'删除','','','','','_self',0,0,'2021-09-26 15:42:38',0,1,1,0),
	(438,334,'初级经济师','','','admin/programa/index','id=438','_self',0,1,'2021-09-26 15:42:58',1,2,1,13),
	(439,438,'列表','','','','','_self',0,0,'2021-09-26 15:42:58',0,1,1,0),
	(440,438,'下载','','','','','_self',0,0,'2021-09-26 15:42:58',0,1,1,0),
	(441,438,'删除','','','','','_self',0,0,'2021-09-26 15:42:58',0,1,1,0),
	(442,334,'初级工程师','','','admin/programa/index','id=442','_self',0,1,'2021-09-26 15:43:25',1,2,1,13),
	(443,442,'列表','','','','','_self',0,0,'2021-09-26 15:43:25',0,1,1,0),
	(444,442,'下载','','','','','_self',0,0,'2021-09-26 15:43:25',0,1,1,0),
	(445,442,'删除','','','','','_self',0,0,'2021-09-26 15:43:25',0,1,1,0),
	(486,13,'测试导出文件','','','admin/programa/index','id=486','_self',1,1,'2021-10-11 11:05:53',1,1,1,13),
	(487,486,'列表','','','','','_self',0,0,'2021-10-11 11:05:53',0,1,1,0),
	(488,486,'下载','','','','','_self',0,0,'2021-10-11 11:05:53',0,1,1,0),
	(489,486,'删除','','','','','_self',0,0,'2021-10-11 11:05:53',0,1,1,0);

/*!40000 ALTER TABLE `system_menu` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_programa
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_programa`;

CREATE TABLE `system_programa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '上传者ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '栏目ID',
  `type` char(20) DEFAULT 'image' COMMENT '类型',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `label` varchar(255) DEFAULT NULL COMMENT '标签',
  `url` varchar(255) DEFAULT NULL COMMENT '路径',
  `create_at` timestamp NULL DEFAULT NULL COMMENT '上传时间',
  `update_at` timestamp NULL DEFAULT NULL COMMENT '编辑时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='资料管理';

LOCK TABLES `system_programa` WRITE;
/*!40000 ALTER TABLE `system_programa` DISABLE KEYS */;

INSERT INTO `system_programa` (`id`, `user_id`, `menu_id`, `type`, `title`, `label`, `url`, `create_at`, `update_at`)
VALUES
	(57,10000,342,'image','营业执照.jpg','营业执照','http://tb.hdlkeji.com/upload/0516cbc344c98549/0454d40cc36a9c5f.jpg','2021-09-26 14:45:55',NULL),
	(58,10000,330,'image','营业执照.jpg','','http://tb.hdlkeji.com/upload/0516cbc344c98549/0454d40cc36a9c5f.jpg','2021-09-26 14:47:58',NULL),
	(59,10000,386,'image','营业执照.jpg','营业执照副本，美图，信心','http://tb.hdlkeji.com/upload/0516cbc344c98549/0454d40cc36a9c5f.jpg','2021-09-26 14:48:32','2021-10-13 15:25:51'),
	(60,10000,346,'image','造价资质证书-正本.jpg','甲级资质证书正本','http://tb.hdlkeji.com/upload/8f84cacf686745cb/2b4cd6afab0564f0.jpg','2021-09-26 15:08:23',NULL),
	(61,10000,346,'image','造价资质证书-副本.jpg','甲级资质证书副本','http://tb.hdlkeji.com/upload/2711ac39d6bfb9c8/f576c989e21dfb44.jpg','2021-09-26 15:08:54',NULL),
	(62,10000,346,'image','资质证书变更页.jpg','甲级资质证书副本变更页','http://tb.hdlkeji.com/upload/671a19d96fa0784a/1f29d7e647aa8ef5.jpg','2021-09-26 15:09:23',NULL),
	(63,10000,386,'image','北京知信工程咨询有限公司营业执照正本.jpg','营业执照正本','http://tb.hdlkeji.com/upload/9ab3ae242fc8a58b/b9ad9b7e3a04b6de.jpg','2021-09-26 15:10:08',NULL),
	(64,10000,386,'image','公司更名通知函（工商局发）.jpg','公司更名通知函','http://tb.hdlkeji.com/upload/a6c7d7fa8fe11fda/32715ae27a84d2a5.jpg','2021-09-26 15:10:30',NULL),
	(66,10000,350,'image','2014-2015年度先进单位会员.jpg','京价协先进单位会员','http://tb.hdlkeji.com/upload/b201e8a60d347893/abe43a574f870742.jpg','2021-09-26 15:17:15',NULL),
	(67,10000,350,'image','第四届优秀工程造价成果奖.jpg','中价协优秀工程造价成果奖','http://tb.hdlkeji.com/upload/c41b7471530f519e/d0138b1725ee5fd8.jpg','2021-09-26 15:24:02',NULL),
	(68,10000,350,'image','2020年度中信城开成都公司优秀供应商证书.jpg','优秀供应商证书','http://tb.hdlkeji.com/upload/72e8c0050c6db1ed/46cce56e4b1d7e08.jpg','2021-09-26 15:24:29',NULL),
	(69,10000,350,'image','中价协2014先进单位会员.jpg','中价协先进单位会员','http://tb.hdlkeji.com/upload/557d4c47783e5c09/1f4374dea024fd4a.jpg','2021-09-26 15:24:55',NULL),
	(70,10000,406,'application','公司简介（简版）.docx','公司简介简版','http://tb.hdlkeji.com/upload/4e42b2ba5407e1ef/d1a74eb65ac3d69a.docx','2021-09-26 15:30:20',NULL),
	(71,10000,406,'application','企业简介（包含服务内容）.docx','公司简介包含服务内容版','http://tb.hdlkeji.com/upload/8d3f957c8bf509c1/32223b51e2ffb50b.docx','2021-09-26 15:36:03',NULL),
	(73,10000,358,'application','02-苏莉颖证书.docx','苏莉颖造价师证件扫描件','http://tb.hdlkeji.com/upload/c1675b6b8e971ba9/54827fbb16f00516.docx','2021-09-26 15:41:14',NULL),
	(74,10000,358,'application','01-李文证书.docx','李文造价师证件扫描件','http://tb.hdlkeji.com/upload/7b20317cfd329f85/70c3ced18ef33ac9.docx','2021-09-26 15:41:52',NULL),
	(78,10000,370,'application','造价咨询业绩表.docx','造价咨询业绩表','http://tb.hdlkeji.com/upload/b2e5c797b18b9bb7/c28751edab40692c.docx','2021-09-26 16:27:21',NULL),
	(81,10000,390,'application','新建 DOCX 文档.docx','','http://tb.hdlkeji.com/upload/c0e2fb8278e48e80/9c13ce1dc4fc2c81.docx','2021-09-27 16:25:44',NULL),
	(82,10000,390,'image','8aee04fb43b9cdf0677f85313478c03.png','','http://tb.hdlkeji.com/upload/a1defa8616372c21/ace2eb1b390e5057.png','2021-09-27 16:26:24',NULL),
	(83,10000,390,'image','Dingtalk_20210916161020.jpg','','http://tb.hdlkeji.com/upload/fdf4d97c42a6ec77/f51f95dda29f1803.jpg','2021-09-27 16:26:48',NULL),
	(84,10000,390,'application','公司更名通知函.docx','','http://tb.hdlkeji.com/upload/1632733487.docx','2021-09-27 17:04:53',NULL),
	(85,10000,390,'application','1.docx','','http://tb.hdlkeji.com/upload/1632733540.docx','2021-09-27 17:05:45',NULL),
	(108,10000,350,'pdf','北京知信管理体系认证2021.pdf','质量体系，环境管理体系，职业健康安全管理体系，2021','http://tb.hdlkeji.com/upload/ea23b3948dac00af/2028251c2efe8654.pdf','2021-10-12 10:04:03',NULL),
	(109,10000,374,'pdf','中关村东升科技园二期项目管理服务合同（0624终版）扫描件.pdf','中关村','http://tb.hdlkeji.com/upload/ab415afcfb9e9764/6236136dac68133f.pdf','2021-10-12 10:10:20',NULL),
	(117,10000,390,'application','投标方案1.docx','','http://tb.hdlkeji.com/upload/9a88e2d84d7bd25d/7e2432085e7015fd.docx','2021-10-13 15:44:50',NULL),
	(118,10000,486,'pdf','中关村东升科技园二期项目管理服务合同（0624终版）扫描件.pdf','1013','http://tb.hdlkeji.com/upload/ab415afcfb9e9764/6236136dac68133f.pdf','2021-10-13 15:45:55',NULL),
	(119,10000,398,'application','新城14街区棚户区框架桥施工、监理招标代理-知信报价比选方案.docx','新城14街；监理；比选','http://tb.hdlkeji.com/upload/6e608b75a196d264/f230df73fe25a05d.docx','2021-10-13 16:17:45',NULL),
	(120,10000,486,'application','投标文件导出 - 副本.docx','校验表格','http://tb.hdlkeji.com/upload/c8fc73e44c222a9b/273ad3f978788938.docx','2021-10-14 18:00:16',NULL),
	(121,10000,330,'pdf','投标资料管理及标书制作系统软件开发合同-扫描件.pdf','','http://tb.hdlkeji.com/upload/9f189e14fb257d20/a8e79c9e841f25e5.pdf','2021-10-19 09:17:51',NULL);

/*!40000 ALTER TABLE `system_programa` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table system_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `system_user`;

CREATE TABLE `system_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `username` varchar(50) DEFAULT '' COMMENT '用户账号',
  `password` varchar(32) DEFAULT '' COMMENT '用户密码',
  `qq` varchar(16) DEFAULT '' COMMENT '联系QQ',
  `mail` varchar(32) DEFAULT '' COMMENT '联系邮箱',
  `phone` varchar(16) DEFAULT '' COMMENT '联系手机',
  `login_at` datetime DEFAULT NULL COMMENT '登录时间',
  `login_ip` varchar(255) DEFAULT '' COMMENT '登录IP',
  `login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
  `authorize` varchar(255) DEFAULT '' COMMENT '权限授权',
  `tags` varchar(255) DEFAULT '' COMMENT '用户标签',
  `desc` varchar(255) DEFAULT '' COMMENT '备注说明',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0禁用,1启用)',
  `is_deleted` tinyint(1) unsigned DEFAULT '0' COMMENT '删除(1删除,0未删)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_system_user_username` (`username`) USING BTREE,
  KEY `idx_system_user_status` (`status`) USING BTREE,
  KEY `idx_system_user_deleted` (`is_deleted`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统-用户';

LOCK TABLES `system_user` WRITE;
/*!40000 ALTER TABLE `system_user` DISABLE KEYS */;

INSERT INTO `system_user` (`id`, `name`, `username`, `password`, `qq`, `mail`, `phone`, `login_at`, `login_ip`, `login_num`, `authorize`, `tags`, `desc`, `status`, `is_deleted`, `create_at`)
VALUES
	(10000,'admin','admin','21232f297a57a5a743894a0e4a801fc3','22222222','','','2021-11-03 21:52:56','114.63.19.203',926,'','','',1,0,'2015-11-13 15:14:22'),
	(10001,'张三','123456','507f513353702b50c145d5b7d138095c','','','','2021-09-28 09:52:58','39.76.58.60',20,'1','','',1,0,'2021-09-02 09:49:33'),
	(10002,'yangtao','yangtao','','','','',NULL,'',0,'7','','',1,0,'2021-09-23 10:19:07'),
	(10003,'笑笑','0000','e7590fee92b79b7ed8464fbd468b70e0','','','','2021-09-23 17:52:18','39.144.15.141',3,'7','','',1,0,'2021-09-23 14:46:45'),
	(10004,'Test','Test','9f95c68e7ceff25f65962a24e21b85c1','','','','2021-09-26 09:37:21','124.65.8.55',9,'7','','',1,0,'2021-09-23 18:46:17'),
	(10005,'穆老师','mulaoshi','5ad9b20438b4278418734d1bc306171e','','','','2021-09-24 14:58:44','124.65.9.233',2,'7','','',1,0,'2021-09-24 14:56:40'),
	(10006,'证书管理员','zsgly','0fb4f4def0b3d35d75222132084df7a1','','','','2021-09-26 15:51:50','124.202.222.157',2,'8','','',1,0,'2021-09-26 15:48:44'),
	(10007,'普通员工','ptyg','a2ad46a71bc8d548266cf2c453324628','','','','2021-09-26 17:06:47','124.202.222.157',1,'9','','',1,0,'2021-09-26 17:05:21');

/*!40000 ALTER TABLE `system_user` ENABLE KEYS */;
UNLOCK TABLES;



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