代码拉取完成,页面将自动刷新
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.24 : Database - vigorous
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bm` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ruange_today`;
/*Table structure for table `os_user` */
DROP TABLE IF EXISTS `os_user`;
CREATE TABLE `os_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '用户名',
`phone` varchar(50) DEFAULT NULL COMMENT '手机号',
`password` varchar(255) DEFAULT NULL COMMENT '密码',
`add_time` varchar(50) DEFAULT NULL COMMENT '注册时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Data for the table `os_user` */
insert into `os_user`(`id`,`name`,`phone`,`password`,`add_time`) values (4,'159482642431','15948264243','e10adc3949ba59abbe56e057f20f883e','1537933504'),(5,'杨航','13644302689','e10adc3949ba59abbe56e057f20f883e','1540347811');
/*Table structure for table `ssc_played` */
DROP TABLE IF EXISTS `ssc_played`;
CREATE TABLE `ssc_played` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `ssc_played` */
/*Table structure for table `system_auth` */
DROP TABLE IF EXISTS `system_auth`;
CREATE TABLE `system_auth` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(20) NOT NULL COMMENT '权限名称',
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
`sort` smallint(6) unsigned DEFAULT '0' COMMENT '排序权重',
`desc` varchar(255) DEFAULT NULL COMMENT '备注说明',
`create_by` bigint(11) unsigned DEFAULT '0' COMMENT '创建人',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `index_system_auth_title` (`title`) USING BTREE,
KEY `index_system_auth_status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统权限表';
/*Data for the table `system_auth` */
insert into `system_auth`(`id`,`title`,`status`,`sort`,`desc`,`create_by`,`create_at`) values (1,'超级管理员',1,0,'超级管理员',0,'2017-09-15 19:18:14'),(2,'管理员',1,0,'管理',0,'2017-10-16 15:48:18');
/*Table structure for table `system_auth_node` */
DROP TABLE IF EXISTS `system_auth_node`;
CREATE TABLE `system_auth_node` (
`auth` bigint(20) unsigned DEFAULT NULL COMMENT '角色ID',
`node` varchar(200) DEFAULT NULL COMMENT '节点路径',
KEY `index_system_auth_auth` (`auth`) USING BTREE,
KEY `index_system_auth_node` (`node`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与节点关系表';
/*Data for the table `system_auth_node` */
insert into `system_auth_node`(`auth`,`node`) values (2,'admin'),(2,'admin/config'),(2,'admin/config/index'),(2,'admin/log'),(2,'admin/log/index'),(2,'admin/log/del'),(2,'home'),(2,'home/dx'),(2,'home/dx/sendmsg'),(2,'home/home'),(2,'home/home/fuli'),(2,'home/home/index'),(2,'home/home/aa'),(2,'home/home/huiyuanka'),(2,'home/home/fuwu'),(2,'home/home/fuwuhw'),(2,'home/home/gongyi'),(2,'home/home/huiyuanka_x'),(2,'home/home/gongyi_x'),(2,'home/home/fuwu_x'),(2,'home/home/z_peizh_x'),(2,'home/home/z_p'),(2,'home/home/wode'),(2,'home/home/zhuce'),(2,'home/home/denglu'),(2,'home/home/zhaohuimima'),(2,'home/home/z_peizh'),(2,'home/home/z_zix'),(2,'home/home/z_haiw'),(2,'home/home/z_yisheng'),(2,'home/uploads'),(2,'home/uploads/uploads'),(2,'home/uploads/haiwai'),(2,'home/wode'),(2,'home/wode/gerenziliao'),(2,'home/wode/wode'),(2,'home/wode/xitongxinxi'),(2,'home/wode/xitongxinxi_x'),(2,'home/wode/bingli'),(2,'home/wode/bingli_x'),(2,'home/wode/bingli_hw'),(2,'home/wode/bingli_ys'),(2,'home/wode/bingli_pz'),(2,'os'),(2,'os/act'),(2,'os/act/index'),(2,'os/act/actadd'),(2,'os/act/actdel'),(2,'os/act/actedit'),(2,'os/advice'),(2,'os/advice/index'),(2,'os/advice/gene'),(2,'os/advice/beijing'),(2,'os/advice/over'),(2,'os/advice/overadd'),(2,'os/advice/overedit'),(2,'os/advice/overdel'),(2,'os/advice/ery'),(2,'os/advice/yiliao'),(2,'os/banner'),(2,'os/banner/index'),(2,'os/banner/banadd'),(2,'os/banner/bandel'),(2,'os/banner/serviceimg'),(2,'os/banner/servimgadd'),(2,'os/banner/servdel'),(2,'os/come'),(2,'os/come/index'),(2,'os/come/ysdel'),(2,'os/come/yssee'),(2,'os/come/zixun'),(2,'os/come/zixundel'),(2,'os/come/zixunsee'),(2,'os/come/hw'),(2,'os/come/hwsee'),(2,'os/come/hwdel'),(2,'os/come/peizh'),(2,'os/come/peizhsee'),(2,'os/come/peizhdel'),(2,'os/cons'),(2,'os/cons/index'),(2,'os/cons/he'),(2,'os/cons/del'),(2,'os/cons/edit'),(2,'os/cons/add'),(2,'os/cons/company'),(2,'os/cons/comadd'),(2,'os/cons/compdel'),(2,'os/cons/compedit'),(2,'os/kefu'),(2,'os/kefu/index'),(2,'os/long'),(2,'os/long/index'),(2,'os/long/rb'),(2,'os/membercard'),(2,'os/membercard/index'),(2,'os/membercard/mberadd'),(2,'os/membercard/mberedit'),(2,'os/membercard/mberdel'),(2,'os/order'),(2,'os/order/index'),(2,'os/useru'),(2,'os/useru/index'),(2,'os/useru/add'),(2,'os/useru/co'),(2,'os/useru/del'),(2,'os/useru/edit'),(2,'os/useru/yh'),(2,'os/useru/excel'),(2,'os/waitact'),(2,'os/waitact/index'),(2,'os/waitact/del'),(2,'os/waitact/add'),(2,'os/wal'),(2,'os/wal/index'),(2,'os/wal/waladd'),(2,'os/wal/waldel'),(2,'os/wal/waledit'),(2,'os/wal/number'),(2,'os/wal/numadd'),(2,'os/wal/numedit'),(2,'os/wal/numdel'),(2,'os/welfare'),(2,'os/welfare/index'),(2,'os/welfare/welfadd'),(2,'os/welfare/welfedit'),(2,'os/welfare/welfdel'),(2,'os/xitong'),(2,'os/xitong/index'),(2,'os/xitong/add'),(2,'os/xitong/edit'),(2,'os/xitong/del'),(2,'os/xitong/agree'),(2,'os/yy'),(2,'os/yy/index'),(2,'os/yy/yyadd'),(2,'os/yy/yyedit'),(2,'os/yy/yydel'),(2,'os/yy/ks'),(2,'os/yy/ksadd'),(2,'os/yy/ksedit'),(2,'os/yy/ksdel'),(1,'admin'),(1,'admin/auth'),(1,'admin/auth/index'),(1,'admin/auth/apply'),(1,'admin/auth/add'),(1,'admin/auth/edit'),(1,'admin/auth/forbid'),(1,'admin/auth/resume'),(1,'admin/auth/del'),(1,'admin/config'),(1,'admin/config/index'),(1,'admin/config/file'),(1,'admin/log'),(1,'admin/log/index'),(1,'admin/log/del'),(1,'admin/menu'),(1,'admin/menu/index'),(1,'admin/menu/add'),(1,'admin/menu/edit'),(1,'admin/menu/del'),(1,'admin/menu/forbid'),(1,'admin/menu/resume'),(1,'admin/node'),(1,'admin/node/index'),(1,'admin/node/save'),(1,'admin/user'),(1,'admin/user/index'),(1,'admin/user/auth'),(1,'admin/user/add'),(1,'admin/user/edit'),(1,'admin/user/pass'),(1,'admin/user/del'),(1,'admin/user/forbid'),(1,'admin/user/resume'),(1,'demo'),(1,'demo/plugs'),(1,'demo/plugs/file'),(1,'demo/plugs/region'),(1,'demo/plugs/editor'),(1,'os'),(1,'os/banner'),(1,'os/banner/index'),(1,'os/grade'),(1,'os/grade/index'),(1,'os/grade/add'),(1,'os/grade/del'),(1,'os/grade/edit'),(1,'os/index'),(1,'os/index/index'),(1,'os/user'),(1,'os/user/index'),(1,'os/user/add'),(1,'os/user/edit'),(1,'os/user/del'),(1,'os/waybill'),(1,'os/waybill/index'),(1,'os/waybill/add'),(1,'os/waybill/del'),(1,'os/waybill/edit'),(1,'os/yingli'),(1,'os/yingli/index'),(1,'os/yingli/add'),(1,'os/yingli/del'),(1,'os/yingli/edit'),(1,'wechat'),(1,'wechat/config'),(1,'wechat/config/index'),(1,'wechat/config/pay'),(1,'wechat/fans'),(1,'wechat/fans/index'),(1,'wechat/fans/back'),(1,'wechat/fans/backadd'),(1,'wechat/fans/tagset'),(1,'wechat/fans/backdel'),(1,'wechat/fans/tagadd'),(1,'wechat/fans/tagdel'),(1,'wechat/fans/sync'),(1,'wechat/keys'),(1,'wechat/keys/index'),(1,'wechat/keys/add'),(1,'wechat/keys/edit'),(1,'wechat/keys/del'),(1,'wechat/keys/forbid'),(1,'wechat/keys/resume'),(1,'wechat/keys/subscribe'),(1,'wechat/keys/defaults'),(1,'wechat/menu'),(1,'wechat/menu/index'),(1,'wechat/menu/edit'),(1,'wechat/menu/cancel'),(1,'wechat/news'),(1,'wechat/news/index'),(1,'wechat/news/select'),(1,'wechat/news/image'),(1,'wechat/news/add'),(1,'wechat/news/edit'),(1,'wechat/news/del'),(1,'wechat/news/push'),(1,'wechat/tags'),(1,'wechat/tags/index'),(1,'wechat/tags/add'),(1,'wechat/tags/edit'),(1,'wechat/tags/sync');
/*Table structure for table `system_config` */
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL COMMENT '配置编码',
`value` varchar(500) DEFAULT NULL COMMENT '配置值',
PRIMARY KEY (`id`),
KEY `index_system_config_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统参数配置';
/*Data for the table `system_config` */
insert into `system_config`(`id`,`name`,`value`) values (148,'site_name','活力城'),(149,'site_copy','活力城© 2016~2018'),(164,'storage_type','local'),(165,'storage_qiniu_is_https','1'),(166,'storage_qiniu_bucket','static'),(167,'storage_qiniu_domain','static.ctolog.com'),(168,'storage_qiniu_access_key','OAFHGzCgZjod2-s4xr-g5ptkXsNbxDO_t2fozIEC'),(169,'storage_qiniu_secret_key','gy0aYdSFMSayQ4kMkgUeEeJRLThVjLpUJoPFxd-Z'),(170,'storage_qiniu_region','华东'),(173,'app_name','活力城'),(174,'app_version','v1.01'),(176,'browser_icon','/static/upload/2cc74f07d1a0456a/626092b8d2caec40.png'),(184,'wechat_appid','wxc4978101b35a6f39'),(185,'wechat_appsecret','ae17f65649b8a8f1cf6d47cdc9f2d4d5'),(186,'wechat_token','mytoken'),(187,'wechat_encodingaeskey','KHyoWLoS7oLZYkB4PokMTfA5sm6Hrqc9Tzgn9iXc0YH'),(188,'wechat_mch_id','1489989602'),(189,'wechat_partnerkey','yangguangpuhuiyangguangpuhui1234'),(194,'wechat_cert_key','D:\\websoft\\web\\yangguangpuhui\\static/upload/e4ac05c9951a62e1/0df41288b854c1e7.pem'),(196,'wechat_cert_cert','D:\\websoft\\web\\yangguangpuhui\\static/upload/1bb2ba56eb6fbb3b/4f163ef95866cfe4.pem'),(197,'tongji_baidu_key',''),(198,'tongji_cnzz_key','1261854404'),(199,'storage_oss_bucket','think-oss'),(200,'storage_oss_keyid','WjeX0AYSfgy5VbXQ'),(201,'storage_oss_secret','hQTENHy6MYVUTgwjcgfOCq5gckm2Lp'),(202,'storage_oss_domain','think-oss.oss-cn-shanghai.aliyuncs.com'),(203,'storage_oss_is_https','1');
/*Table structure for table `system_log` */
DROP TABLE IF EXISTS `system_log`;
CREATE TABLE `system_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ip` char(15) NOT NULL DEFAULT '' COMMENT '操作者IP地址',
`node` char(200) NOT NULL DEFAULT '' COMMENT '当前操作节点',
`username` varchar(32) NOT NULL DEFAULT '' COMMENT '操作人用户名',
`action` varchar(200) NOT NULL DEFAULT '' COMMENT '操作行为',
`content` text NOT NULL COMMENT '操作内容描述',
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=556 DEFAULT CHARSET=utf8 COMMENT='系统操作日志表';
/*Data for the table `system_log` */
insert into `system_log`(`id`,`ip`,`node`,`username`,`action`,`content`,`create_at`) values (17,'127.0.0.1','wechat/config/index','admin','微信管理','修改微信接口参数成功','2017-09-15 20:08:17'),(18,'127.0.0.1','admin/login/out','admin','系统管理','用户退出系统成功','2017-09-15 20:09:01'),(19,'127.0.0.1','admin/login/index','admin','系统管理','用户登录系统成功','2017-09-15 21:03:26'),(20,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-13 15:33:38'),(21,'0.0.0.0','admin/login/out','admin','系统管理','用户退出系统成功','2017-10-13 16:05:23'),(22,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-13 16:10:50'),(23,'0.0.0.0','admin/login/out','admin','系统管理','用户退出系统成功','2017-10-13 16:11:46'),(24,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-13 16:12:14'),(25,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-16 08:36:40'),(26,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-16 10:13:53'),(27,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-16 10:55:32'),(28,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-16 11:24:07'),(29,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-16 15:52:00'),(30,'0.0.0.0','admin/login/index','admin','系统管理','用户登录系统成功','2017-10-16 15:53:13'),(31,'0.0.0.0','admin/login/out','admin','系统管理','用户退出系统成功','2017-10-16 15:55:28'),(32,'0.0.0.0','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-16 15:56:28'),(33,'0.0.0.0','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-16 15:57:48'),(34,'0.0.0.0','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-16 16:00:57'),(35,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2017-10-16 16:19:21'),(36,'0.0.0.0','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-16 16:19:56'),(37,'0.0.0.0','admin/config/index','ygph','系统管理','修改系统配置参数成功','2017-10-16 16:22:36'),(38,'0.0.0.0','admin/config/index','ygph','系统管理','修改系统配置参数成功','2017-10-16 16:24:46'),(39,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-17 08:56:13'),(40,'0.0.0.0','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-17 15:27:35'),(41,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-18 09:19:50'),(42,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2017-10-18 11:14:48'),(43,'0.0.0.0','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-18 11:15:07'),(44,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-18 11:19:13'),(45,'0.0.0.0','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-18 11:23:41'),(46,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-18 11:23:51'),(47,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-18 14:09:09'),(48,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-19 08:53:17'),(49,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-20 08:46:07'),(50,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-23 08:46:46'),(51,'0.0.0.0','admin/login/out','','系统管理','用户退出系统成功','2017-10-23 14:57:22'),(52,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-23 14:57:30'),(53,'0.0.0.0','admin/login/out','','系统管理','用户退出系统成功','2017-10-23 16:39:27'),(54,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-23 16:39:37'),(55,'0.0.0.0','admin/login/out','','系统管理','用户退出系统成功','2017-10-23 16:50:13'),(56,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-23 16:50:21'),(57,'0.0.0.0','admin/login/out','','系统管理','用户退出系统成功','2017-10-24 08:46:40'),(58,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-10-24 08:46:49'),(59,'0.0.0.0','admin/config/file','root','系统管理','修改系统配置参数成功','2017-10-24 11:04:02'),(60,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-24 11:26:50'),(61,'127.0.0.1','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-24 17:20:46'),(62,'127.0.0.1','admin/login/out','root','系统管理','用户退出系统成功','2017-10-24 17:31:55'),(63,'127.0.0.1','admin/login/out','','系统管理','用户退出系统成功','2017-10-25 08:47:10'),(64,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 08:47:20'),(65,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 09:17:07'),(66,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 10:05:46'),(67,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 11:06:52'),(68,'127.0.0.1','admin/login/out','','系统管理','用户退出系统成功','2017-10-25 13:34:57'),(69,'127.0.0.1','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 13:35:04'),(70,'36.48.27.165','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 16:10:18'),(71,'36.48.27.165','admin/login/index','root','系统管理','用户登录系统成功','2017-10-25 16:11:03'),(72,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 18:18:31'),(73,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 19:42:31'),(74,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 20:03:47'),(75,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 20:03:56'),(76,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 21:12:19'),(77,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 21:12:31'),(78,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 22:10:22'),(79,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 22:10:33'),(80,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 22:17:10'),(81,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 22:17:21'),(82,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 23:07:17'),(83,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 23:07:27'),(84,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 23:20:12'),(85,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 23:20:24'),(86,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-25 23:53:36'),(87,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-25 23:58:36'),(88,'36.48.22.113','admin/login/index','root','系统管理','用户登录系统成功','2017-10-26 08:42:51'),(89,'36.48.22.113','admin/login/index','root','系统管理','用户登录系统成功','2017-10-26 09:04:09'),(90,'58.244.51.27','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-26 09:11:29'),(91,'58.244.51.27','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-26 09:12:58'),(92,'58.244.51.27','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-26 09:13:44'),(93,'36.48.22.113','admin/login/index','root','系统管理','用户登录系统成功','2017-10-26 09:56:32'),(94,'36.48.22.113','admin/login/index','root','系统管理','用户登录系统成功','2017-10-26 12:38:51'),(95,'36.48.22.113','admin/login/out','root','系统管理','用户退出系统成功','2017-10-26 12:39:29'),(96,'36.48.22.113','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-26 12:39:38'),(97,'36.48.22.113','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-26 14:48:16'),(98,'36.48.22.113','admin/login/index','root','系统管理','用户登录系统成功','2017-10-26 15:17:49'),(99,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-26 23:33:26'),(100,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-26 23:41:53'),(101,'124.235.183.230','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-27 09:24:07'),(102,'124.235.183.230','admin/login/index','root','系统管理','用户登录系统成功','2017-10-27 10:30:27'),(103,'119.51.151.88','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-27 12:52:58'),(104,'119.51.151.88','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-27 13:32:29'),(105,'119.51.151.88','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-27 13:34:13'),(106,'124.235.183.230','admin/login/index','root','系统管理','用户登录系统成功','2017-10-27 14:50:26'),(107,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-27 21:03:35'),(108,'222.161.32.11','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-27 21:05:14'),(109,'222.161.32.11','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-27 21:05:25'),(110,'119.51.151.195','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-28 13:59:13'),(111,'119.51.151.195','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-28 14:25:34'),(112,'119.51.60.153','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-29 17:27:04'),(113,'36.48.26.209','admin/login/index','root','系统管理','用户登录系统成功','2017-10-30 08:58:32'),(114,'58.244.49.173','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-30 10:16:33'),(115,'58.244.49.173','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-30 10:54:05'),(116,'58.244.49.173','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-30 11:07:31'),(117,'58.244.49.173','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-30 11:29:59'),(118,'58.244.49.173','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-30 12:37:34'),(119,'58.244.49.173','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-30 13:35:20'),(120,'58.244.49.173','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-30 13:37:25'),(121,'175.17.155.71','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-31 09:09:32'),(122,'175.17.155.71','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-31 11:55:46'),(123,'175.17.155.71','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-31 11:56:23'),(124,'175.17.155.71','admin/config/index','ygph','系统管理','修改系统配置参数成功','2017-10-31 12:32:48'),(125,'175.17.155.71','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-31 12:33:03'),(126,'175.17.155.71','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-31 13:30:15'),(127,'175.17.155.71','admin/login/out','','系统管理','用户退出系统成功','2017-10-31 14:31:16'),(128,'175.17.155.71','admin/login/index','ygph','系统管理','用户登录系统成功','2017-10-31 14:31:41'),(129,'175.17.155.71','admin/login/out','ygph','系统管理','用户退出系统成功','2017-10-31 15:22:56'),(130,'36.48.26.218','admin/login/index','root','系统管理','用户登录系统成功','2017-11-01 13:13:02'),(131,'60.253.230.58','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-01 16:47:02'),(132,'60.253.230.58','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-01 17:25:00'),(133,'36.48.22.7','admin/login/index','root','系统管理','用户登录系统成功','2017-11-02 16:48:52'),(134,'139.214.254.164','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-04 09:52:56'),(135,'119.51.148.219','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-04 11:05:51'),(136,'119.51.148.219','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-04 13:55:36'),(137,'36.48.27.37','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-04 13:56:21'),(138,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-06 13:10:52'),(139,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-06 14:25:56'),(140,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-06 14:26:56'),(141,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-07 09:16:11'),(142,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-11-07 09:38:49'),(143,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-11-07 09:42:46'),(144,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-07 15:02:03'),(145,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-07 15:02:13'),(146,'36.48.25.152','admin/login/index','root','系统管理','用户登录系统成功','2017-11-07 15:08:16'),(147,'36.48.25.152','admin/login/out','root','系统管理','用户退出系统成功','2017-11-07 15:37:16'),(148,'36.48.25.152','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-07 15:37:27'),(149,'36.48.25.152','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-07 15:37:45'),(150,'36.48.25.152','admin/login/index','root','系统管理','用户登录系统成功','2017-11-07 15:37:52'),(151,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 09:03:32'),(152,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-08 10:28:46'),(153,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 10:29:16'),(154,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-08 10:30:44'),(155,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 10:40:15'),(156,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-08 11:43:53'),(157,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 11:44:04'),(158,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-08 11:59:46'),(159,'36.48.25.216','admin/login/index','root','系统管理','用户登录系统成功','2017-11-08 12:49:23'),(160,'36.48.25.216','admin/login/index','root','系统管理','用户登录系统成功','2017-11-08 12:57:40'),(161,'139.214.251.102','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 13:53:39'),(162,'106.39.191.234','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 13:55:11'),(163,'36.48.25.216','admin/login/index','root','系统管理','用户登录系统成功','2017-11-08 14:19:42'),(164,'119.51.67.177','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-08 21:40:06'),(165,'119.51.67.177','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-08 21:41:58'),(166,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-09 09:22:00'),(167,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-09 09:47:27'),(168,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-09 09:47:35'),(169,'36.48.25.145','admin/login/index','root','系统管理','用户登录系统成功','2017-11-09 09:51:55'),(170,'36.48.25.145','admin/login/index','root','系统管理','用户登录系统成功','2017-11-09 15:25:54'),(171,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-09 15:26:42'),(172,'36.48.25.145','admin/login/out','root','系统管理','用户退出系统成功','2017-11-09 15:27:22'),(173,'36.48.25.145','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-09 15:27:30'),(174,'61.151.207.252','admin/login/out','','系统管理','用户退出系统成功','2017-11-09 15:27:36'),(175,'36.48.25.145','admin/login/out','ygphkf','系统管理','用户退出系统成功','2017-11-09 15:28:55'),(176,'36.48.25.145','admin/login/index','root','系统管理','用户登录系统成功','2017-11-09 15:29:02'),(177,'101.226.33.202','admin/login/out','','系统管理','用户退出系统成功','2017-11-09 15:29:05'),(178,'122.139.142.49','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-09 15:58:36'),(179,'122.139.142.49','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-09 16:12:48'),(180,'36.48.27.119','admin/login/index','root','系统管理','用户登录系统成功','2017-11-10 09:10:22'),(181,'36.48.27.119','admin/login/out','root','系统管理','用户退出系统成功','2017-11-10 09:43:37'),(182,'36.48.27.119','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 09:43:46'),(183,'36.48.27.119','admin/login/out','ygphkf','系统管理','用户退出系统成功','2017-11-10 09:50:09'),(184,'61.129.7.254','admin/login/out','','系统管理','用户退出系统成功','2017-11-10 09:50:19'),(185,'36.48.27.119','admin/login/index','root','系统管理','用户登录系统成功','2017-11-10 09:50:23'),(186,'36.48.27.119','admin/login/out','root','系统管理','用户退出系统成功','2017-11-10 09:51:09'),(187,'36.48.27.119','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 09:51:17'),(188,'36.48.27.119','admin/login/out','ygphkf','系统管理','用户退出系统成功','2017-11-10 09:51:39'),(189,'36.48.27.119','admin/login/index','root','系统管理','用户登录系统成功','2017-11-10 09:51:45'),(190,'101.226.65.105','admin/login/out','','系统管理','用户退出系统成功','2017-11-10 09:51:49'),(191,'175.17.166.241','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 09:55:35'),(192,'175.17.166.241','admin/login/out','ygphkf','系统管理','用户退出系统成功','2017-11-10 09:58:41'),(193,'175.17.166.241','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 10:04:58'),(194,'175.17.166.241','admin/login/out','ygphkf','系统管理','用户退出系统成功','2017-11-10 10:09:21'),(195,'175.17.166.241','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 10:11:51'),(196,'175.17.166.241','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-10 10:12:34'),(197,'175.17.166.241','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-10 10:13:33'),(198,'175.17.166.241','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-10 10:13:41'),(199,'175.17.166.241','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-10 10:31:35'),(200,'175.17.166.241','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-10 10:31:45'),(201,'36.48.27.119','admin/login/out','root','系统管理','用户退出系统成功','2017-11-10 11:11:39'),(202,'101.226.33.200','admin/login/out','','系统管理','用户退出系统成功','2017-11-10 11:11:49'),(203,'36.48.27.119','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-10 11:11:56'),(204,'36.48.27.119','admin/login/out','ygph','系统管理','用户退出系统成功','2017-11-10 11:12:39'),(205,'36.48.27.119','admin/login/index','root','系统管理','用户登录系统成功','2017-11-10 11:12:44'),(206,'175.17.166.241','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-10 15:53:54'),(207,'175.17.166.241','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-10 15:59:39'),(208,'175.17.166.241','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-11 10:16:41'),(209,'58.244.57.90','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-13 09:09:49'),(210,'58.244.57.90','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-13 09:12:06'),(211,'36.48.25.119','admin/login/index','root','系统管理','用户登录系统成功','2017-11-13 10:13:36'),(212,'58.244.57.90','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-13 13:31:40'),(213,'58.244.57.90','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-13 14:56:53'),(214,'58.244.57.90','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-13 16:33:11'),(215,'58.245.2.24','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-14 09:37:45'),(216,'36.48.93.206','admin/login/index','root','系统管理','用户登录系统成功','2017-11-14 14:38:04'),(217,'36.48.27.5','admin/login/index','root','系统管理','用户登录系统成功','2017-11-15 09:37:19'),(218,'58.245.2.24','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-15 14:53:26'),(219,'36.48.27.5','admin/login/index','root','系统管理','用户登录系统成功','2017-11-15 16:55:52'),(220,'175.17.158.163','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-16 10:12:11'),(221,'175.17.158.163','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-16 10:28:40'),(222,'58.244.48.97','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-16 16:05:08'),(223,'123.151.77.91','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-16 16:36:15'),(224,'175.17.155.247','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-17 15:27:58'),(225,'175.17.155.247','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-17 16:05:53'),(226,'58.244.52.92','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-18 11:33:35'),(227,'119.51.69.219','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-19 11:41:04'),(228,'58.244.48.194','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-20 09:39:15'),(229,'175.17.166.28','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-20 14:42:44'),(230,'58.244.49.38','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-21 13:04:16'),(231,'58.244.49.38','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-21 13:07:42'),(232,'119.51.151.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-22 08:49:30'),(233,'119.51.151.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-22 13:17:24'),(234,'119.51.151.167','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-22 13:40:31'),(235,'119.51.151.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-22 16:27:36'),(236,'119.51.151.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-23 08:55:52'),(237,'36.48.22.24','admin/login/index','root','系统管理','用户登录系统成功','2017-11-23 09:58:46'),(238,'175.17.165.59','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-23 11:28:33'),(239,'175.17.165.59','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-24 09:21:15'),(240,'175.17.165.59','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-24 09:45:11'),(241,'175.17.165.59','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-24 11:57:36'),(242,'119.48.44.6','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-25 09:20:44'),(243,'119.48.44.6','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-25 09:22:11'),(244,'119.48.44.6','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-25 11:33:39'),(245,'36.48.26.168','admin/login/index','root','系统管理','用户登录系统成功','2017-11-27 09:01:57'),(246,'175.17.162.81','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-27 09:20:07'),(247,'175.17.162.81','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-27 09:20:22'),(248,'175.17.162.81','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-27 11:58:50'),(249,'36.48.26.168','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-27 13:40:37'),(250,'175.17.162.81','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-27 14:39:19'),(251,'175.17.160.198','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-28 09:09:29'),(252,'175.17.160.198','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-28 09:14:39'),(253,'36.48.21.137','admin/login/index','root','系统管理','用户登录系统成功','2017-11-28 14:20:42'),(254,'175.17.160.198','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-28 14:40:38'),(255,'175.17.160.198','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-28 15:44:06'),(256,'36.48.21.137','admin/login/index','root','系统管理','用户登录系统成功','2017-11-28 15:52:51'),(257,'36.48.21.137','admin/login/index','root','系统管理','用户登录系统成功','2017-11-28 16:10:07'),(258,'36.48.27.208','admin/login/index','root','系统管理','用户登录系统成功','2017-11-29 09:02:37'),(259,'58.244.48.40','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-29 09:38:17'),(260,'221.9.92.69','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-29 19:30:43'),(261,'175.17.159.207','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-11-30 08:32:16'),(262,'175.17.159.207','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-30 09:19:37'),(263,'175.17.159.207','admin/login/index','ygph','系统管理','用户登录系统成功','2017-11-30 14:16:05'),(264,'58.244.54.148','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-01 08:58:47'),(265,'58.244.54.148','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-01 09:32:40'),(266,'36.48.26.159','admin/login/index','root','系统管理','用户登录系统成功','2017-12-01 11:14:36'),(267,'58.244.54.148','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-01 11:39:58'),(268,'58.244.54.148','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-01 13:54:05'),(269,'58.244.54.148','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-01 13:54:19'),(270,'122.139.142.30','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-01 14:32:57'),(271,'139.214.251.29','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-01 21:19:16'),(272,'119.51.151.10','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-02 08:56:00'),(273,'119.51.151.10','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-02 09:04:55'),(274,'119.51.151.10','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-02 10:36:19'),(275,'119.51.151.10','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-02 15:52:11'),(276,'119.51.148.110','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-04 09:11:31'),(277,'119.51.148.110','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-04 11:27:39'),(278,'119.51.148.110','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-04 14:57:11'),(279,'175.17.164.229','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-05 09:10:57'),(280,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-05 09:11:35'),(281,'175.17.164.229','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-05 12:17:34'),(282,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-05 12:25:40'),(283,'175.17.164.229','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-05 14:11:21'),(284,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-05 14:29:28'),(285,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-06 09:25:19'),(286,'175.17.164.229','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-06 10:41:13'),(287,'36.48.27.212','admin/login/index','root','系统管理','用户登录系统成功','2017-12-06 10:43:26'),(288,'36.48.27.212','admin/login/index','root','系统管理','用户登录系统成功','2017-12-06 14:16:34'),(289,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-06 15:55:25'),(290,'36.48.22.223','admin/login/index','root','系统管理','用户登录系统成功','2017-12-07 09:30:44'),(291,'175.17.164.229','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-07 10:14:00'),(292,'36.48.22.223','admin/login/index','root','系统管理','用户登录系统成功','2017-12-07 14:48:29'),(293,'175.17.164.229','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-07 14:48:44'),(294,'175.17.160.192','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-08 08:52:24'),(295,'175.17.160.192','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-08 09:08:31'),(296,'175.17.160.192','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-08 11:02:13'),(297,'36.48.27.46','admin/login/index','root','系统管理','用户登录系统成功','2017-12-08 16:22:51'),(298,'125.32.83.235','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-09 09:14:49'),(299,'125.32.83.235','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-09 09:40:20'),(300,'125.32.83.235','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-09 11:03:38'),(301,'125.32.83.235','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-09 11:05:50'),(302,'125.32.83.235','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-09 13:02:52'),(303,'125.32.83.235','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-09 13:30:01'),(304,'125.32.83.235','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-09 14:45:21'),(305,'119.51.151.236','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-11 11:15:32'),(306,'58.244.52.108','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-12 09:50:55'),(307,'58.244.52.108','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-12 09:52:14'),(308,'36.48.93.174','admin/login/index','root','系统管理','用户登录系统成功','2017-12-12 10:32:35'),(309,'36.48.93.174','wechat/config/pay','root','微信管理','修改微信支付参数成功','2017-12-12 10:36:19'),(310,'36.48.93.174','wechat/config/pay','root','微信管理','修改微信支付参数成功','2017-12-12 10:36:49'),(311,'36.48.93.174','wechat/config/index','root','微信管理','修改微信接口参数成功','2017-12-12 10:37:56'),(312,'36.48.93.174','wechat/config/index','root','微信管理','修改微信接口参数成功','2017-12-12 11:47:16'),(313,'58.244.52.108','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-12 12:01:27'),(314,'58.245.3.141','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-13 10:03:49'),(315,'58.245.3.141','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-13 10:04:35'),(316,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-14 08:50:47'),(317,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-14 08:52:19'),(318,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-14 08:53:02'),(319,'175.17.166.64','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-14 11:20:56'),(320,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-15 08:39:46'),(321,'119.51.150.199','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-15 09:38:09'),(322,'119.51.150.199','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-15 16:33:59'),(323,'175.17.164.85','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-16 09:11:57'),(324,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-18 08:44:43'),(325,'175.17.160.195','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-18 09:25:56'),(326,'175.17.160.195','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-18 10:41:50'),(327,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-18 11:00:36'),(328,'36.48.93.247','admin/login/index','root','系统管理','用户登录系统成功','2017-12-18 11:15:48'),(329,'175.17.160.195','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-18 11:34:54'),(330,'175.17.160.195','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-18 11:35:13'),(331,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-18 12:45:19'),(332,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-18 14:59:11'),(333,'175.17.160.195','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-18 16:15:59'),(334,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-19 08:54:35'),(335,'175.17.159.201','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-19 10:01:17'),(336,'36.48.22.197','admin/login/index','root','系统管理','用户登录系统成功','2017-12-19 10:44:41'),(337,'175.17.159.201','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-19 10:51:07'),(338,'175.17.159.201','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-19 10:52:46'),(339,'36.48.22.197','admin/login/index','root','系统管理','用户登录系统成功','2017-12-19 11:36:40'),(340,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-19 11:37:18'),(341,'119.48.44.28','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-20 09:13:38'),(342,'119.48.44.28','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-20 09:44:18'),(343,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-20 10:41:53'),(344,'119.48.44.28','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-20 10:56:52'),(345,'36.48.21.163','admin/login/index','root','系统管理','用户登录系统成功','2017-12-20 15:07:41'),(346,'175.17.155.82','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-21 08:47:32'),(347,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-21 09:00:12'),(348,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-21 15:04:27'),(349,'175.17.155.215','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-22 08:53:13'),(350,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 10:01:34'),(351,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 10:03:52'),(352,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-22 10:23:14'),(353,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 11:31:06'),(354,'175.17.155.215','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-22 12:43:09'),(355,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-22 12:43:21'),(356,'36.48.21.28','admin/login/out','root','系统管理','用户退出系统成功','2017-12-22 12:49:15'),(357,'36.48.21.28','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2017-12-22 12:49:29'),(358,'36.48.21.28','admin/login/out','ygphkf1','系统管理','用户退出系统成功','2017-12-22 12:49:50'),(359,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 12:49:57'),(360,'175.17.155.215','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-22 12:50:14'),(361,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-22 12:50:25'),(362,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 13:46:19'),(363,'175.17.155.215','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-22 14:19:52'),(364,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 15:58:16'),(365,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:01:47'),(366,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2017-12-22 16:02:04'),(367,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:02:15'),(368,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2017-12-22 16:03:00'),(369,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:05:00'),(370,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:06:50'),(371,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:10:37'),(372,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2017-12-22 16:21:14'),(373,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:21:30'),(374,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:28:19'),(375,'36.48.21.28','admin/login/index','root','系统管理','用户登录系统成功','2017-12-22 16:31:43'),(376,'175.17.155.215','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-23 09:07:35'),(377,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-23 12:23:13'),(378,'175.17.155.215','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-25 08:58:05'),(379,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 09:47:31'),(380,'36.48.25.140','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 09:49:13'),(381,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 10:13:31'),(382,'36.48.25.140','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 10:26:13'),(383,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-25 10:33:29'),(384,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 11:04:37'),(385,'36.48.25.140','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 11:08:39'),(386,'175.17.155.215','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-25 14:59:54'),(387,'175.17.155.215','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-25 15:15:03'),(388,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-25 16:34:54'),(389,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2017-12-26 09:07:01'),(390,'122.139.143.109','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-26 09:07:51'),(391,'122.139.143.109','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-26 09:20:06'),(392,'36.48.22.119','admin/login/index','root','系统管理','用户登录系统成功','2017-12-26 09:50:48'),(393,'122.139.143.109','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-26 11:29:47'),(394,'122.139.143.109','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-26 11:29:58'),(395,'122.139.143.109','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-26 12:13:25'),(396,'122.139.143.109','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-26 12:50:18'),(397,'119.51.149.196','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-27 09:19:37'),(398,'119.51.149.196','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-27 09:26:34'),(399,'119.51.149.196','admin/login/index','ygphkf','系统管理','用户登录系统成功','2017-12-29 09:33:38'),(400,'119.51.149.196','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-29 10:02:31'),(401,'119.51.149.196','admin/login/out','ygph','系统管理','用户退出系统成功','2017-12-29 10:15:23'),(402,'119.51.149.196','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-29 10:15:32'),(403,'221.9.91.18','admin/login/index','ygph','系统管理','用户登录系统成功','2017-12-30 09:36:17'),(404,'36.48.26.35','admin/login/index','root','系统管理','用户登录系统成功','2018-01-02 09:10:42'),(405,'175.17.169.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-02 09:13:47'),(406,'175.17.169.167','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-02 09:17:25'),(407,'175.17.169.167','admin/login/out','ygph','系统管理','用户退出系统成功','2018-01-02 14:09:04'),(408,'175.17.169.167','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-02 14:09:14'),(409,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-01-02 14:12:48'),(410,'175.17.169.167','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-02 15:39:25'),(411,'119.51.148.32','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-03 09:30:23'),(412,'119.51.148.32','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-03 10:11:10'),(413,'58.244.56.123','admin/login/out','ygph','系统管理','用户退出系统成功','2018-01-03 10:19:35'),(414,'58.244.56.123','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-03 10:19:47'),(415,'58.244.56.123','admin/login/out','ygph','系统管理','用户退出系统成功','2018-01-03 10:28:37'),(416,'58.244.56.123','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-03 10:28:47'),(417,'175.17.167.123','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-04 09:01:32'),(418,'175.17.167.123','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-04 09:05:10'),(419,'36.48.21.188','admin/login/index','root','系统管理','用户登录系统成功','2018-01-04 09:08:41'),(420,'175.17.167.142','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-05 09:16:48'),(421,'175.17.167.142','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-05 09:18:37'),(422,'36.48.22.84','admin/login/index','root','系统管理','用户登录系统成功','2018-01-05 09:48:14'),(423,'36.48.22.84','admin/login/index','root','系统管理','用户登录系统成功','2018-01-05 09:52:54'),(424,'36.48.22.84','admin/login/index','root','系统管理','用户登录系统成功','2018-01-05 10:01:16'),(425,'36.48.22.84','admin/login/index','root','系统管理','用户登录系统成功','2018-01-05 14:33:03'),(426,'175.17.167.142','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-05 15:27:24'),(427,'175.17.167.142','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-05 16:08:55'),(428,'36.48.22.84','admin/login/index','root','系统管理','用户登录系统成功','2018-01-05 16:08:58'),(429,'175.17.167.142','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-05 16:35:37'),(430,'175.17.167.142','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-06 10:03:21'),(431,'175.17.167.142','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-06 13:36:02'),(432,'175.17.167.142','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-06 15:29:02'),(433,'122.139.142.228','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-08 09:21:23'),(434,'122.139.142.228','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-09 09:38:39'),(435,'122.139.142.228','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-09 13:01:36'),(436,'36.48.26.48','admin/login/index','root','系统管理','用户登录系统成功','2018-01-09 14:12:48'),(437,'58.244.56.213','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-10 09:09:02'),(438,'58.244.56.213','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-10 09:43:51'),(439,'58.244.56.213','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-10 10:09:43'),(440,'36.48.22.46','admin/login/index','root','系统管理','用户登录系统成功','2018-01-10 12:13:16'),(441,'58.244.56.213','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-11 09:31:42'),(442,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 09:51:18'),(443,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 11:45:42'),(444,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 12:55:46'),(445,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 13:01:27'),(446,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 15:12:47'),(447,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 15:16:33'),(448,'58.244.59.154','admin/login/index','ygphkf','系统管理','用户登录系统成功','2018-01-12 15:17:22'),(449,'58.244.59.154','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-12 15:18:58'),(450,'58.244.59.154','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-12 15:19:52'),(451,'58.244.59.154','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-13 08:52:13'),(452,'58.244.59.154','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-15 09:05:07'),(453,'175.17.159.4','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-16 09:16:27'),(454,'125.32.82.116','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-17 08:57:25'),(455,'58.244.54.129','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-18 09:00:25'),(456,'36.48.25.167','admin/login/index','root','系统管理','用户登录系统成功','2018-01-18 09:22:39'),(457,'58.244.54.129','admin/login/out','ygphkf1','系统管理','用户退出系统成功','2018-01-18 14:56:06'),(458,'58.244.54.129','admin/login/index','ygph','系统管理','用户登录系统成功','2018-01-18 14:56:29'),(459,'58.244.54.129','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-18 15:48:28'),(460,'119.51.150.162','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-19 09:18:45'),(461,'119.51.150.162','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-19 14:21:54'),(462,'119.51.150.162','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-20 11:06:36'),(463,'58.244.52.216','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-22 09:11:30'),(464,'36.48.26.37','admin/login/index','root','系统管理','用户登录系统成功','2018-01-22 11:18:52'),(465,'124.235.126.84','admin/login/index','ygph01','系统管理','用户登录系统成功','2018-01-22 14:19:13'),(466,'125.32.80.55','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-23 08:48:36'),(467,'125.32.80.55','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-23 10:27:39'),(468,'119.51.150.76','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-25 09:56:48'),(469,'36.48.21.37','admin/login/index','ygph01','系统管理','用户登录系统成功','2018-01-25 10:57:24'),(470,'175.17.166.167','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-26 09:07:32'),(471,'175.17.166.167','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-27 08:47:22'),(472,'175.17.166.167','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-29 09:03:05'),(473,'36.48.93.200','admin/login/index','root','系统管理','用户登录系统成功','2018-01-29 09:30:24'),(474,'119.51.150.44','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-01-30 14:13:06'),(475,'119.51.150.188','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-01 09:52:11'),(476,'119.51.150.188','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-02 09:03:16'),(477,'119.51.150.188','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-03 09:11:58'),(478,'175.17.170.91','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-05 09:47:58'),(479,'175.17.170.91','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-06 11:02:11'),(480,'58.245.3.136','admin/login/index','ygphkf1','系统管理','用户登录系统成功','2018-02-07 13:01:27'),(481,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-25 15:23:03'),(482,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-28 09:24:55'),(483,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2018-05-28 09:28:45'),(484,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-28 15:53:55'),(485,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-29 09:06:37'),(486,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2018-05-29 09:40:43'),(487,'0.0.0.0','admin/login/index','ludan','系统管理','用户登录系统成功','2018-05-29 09:40:50'),(488,'0.0.0.0','admin/login/out','ludan','系统管理','用户退出系统成功','2018-05-29 09:41:05'),(489,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-29 09:41:14'),(490,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2018-05-29 09:41:52'),(491,'0.0.0.0','admin/login/index','ludan','系统管理','用户登录系统成功','2018-05-29 09:42:03'),(492,'0.0.0.0','admin/login/out','ludan','系统管理','用户退出系统成功','2018-05-29 09:42:12'),(493,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-29 09:42:17'),(494,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-30 09:06:43'),(495,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-30 17:37:03'),(496,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-30 17:42:52'),(497,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-31 09:37:50'),(498,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-31 19:17:41'),(499,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-05-31 22:22:54'),(500,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-01 09:58:16'),(501,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-04 10:04:55'),(502,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-06 14:16:37'),(503,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-07 09:19:59'),(504,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-10 14:38:06'),(505,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-10 15:55:14'),(506,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-10 17:15:10'),(507,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2018-06-10 19:13:28'),(508,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-11 09:15:41'),(509,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-11 17:15:04'),(510,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-13 09:05:11'),(511,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-14 10:12:53'),(512,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-14 15:51:15'),(513,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-21 10:12:22'),(514,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-21 10:52:19'),(515,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-25 11:19:59'),(516,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2018-06-25 11:23:19'),(517,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-26 09:25:50'),(518,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-27 15:00:56'),(519,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-29 09:03:45'),(520,'0.0.0.0','admin/login/out','root','系统管理','用户退出系统成功','2018-06-29 09:44:59'),(521,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-06-29 09:45:16'),(522,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-07-03 09:16:27'),(523,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-02 10:04:03'),(524,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-03 09:21:47'),(525,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-08 10:15:34'),(526,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-09 12:54:57'),(527,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-10 09:53:27'),(528,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-13 09:27:40'),(529,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-20 09:58:07'),(530,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-21 10:30:21'),(531,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-22 10:27:34'),(532,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-30 10:08:02'),(533,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2018-08-30 15:47:32'),(534,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-08-31 09:20:53'),(535,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-03 11:06:27'),(536,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-19 10:02:11'),(537,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-20 09:28:27'),(538,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-20 14:36:49'),(539,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-21 10:53:30'),(540,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-25 09:14:13'),(541,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-25 13:01:17'),(542,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-26 09:20:02'),(543,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-27 14:24:14'),(544,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-28 09:20:25'),(545,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-09-30 09:10:44'),(546,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-09 16:35:36'),(547,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-10 10:17:01'),(548,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-23 09:56:41'),(549,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-23 21:34:29'),(550,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-24 09:10:45'),(551,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-24 21:20:03'),(552,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2018-10-24 21:25:40'),(553,'0.0.0.0','admin/login/index','root','系统管理','用户登录系统成功','2019-07-06 09:42:31'),(554,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2019-07-06 09:43:38'),(555,'0.0.0.0','admin/config/index','root','系统管理','修改系统配置参数成功','2019-07-06 09:43:45');
/*Table structure for 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 NOT NULL DEFAULT '0' COMMENT '父id',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
`node` varchar(200) NOT NULL DEFAULT '' COMMENT '节点代码',
`icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
`url` varchar(400) NOT NULL DEFAULT '' COMMENT '链接',
`params` varchar(500) DEFAULT '' COMMENT '链接参数',
`target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
`sort` int(11) unsigned DEFAULT '0' COMMENT '菜单排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
`create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_system_menu_node` (`node`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';
/*Data for the table `system_menu` */
insert into `system_menu`(`id`,`pid`,`title`,`node`,`icon`,`url`,`params`,`target`,`sort`,`status`,`create_by`,`create_at`) values (2,0,'系统管理','','','#','','_self',1000,1,0,'2015-11-16 19:15:38'),(4,2,'系统配置','','','#','','_self',100,1,0,'2016-03-14 18:12:55'),(5,4,'网站参数','','fa fa-apple','admin/config/index','','_self',20,1,0,'2016-05-06 14:36:49'),(6,4,'文件存储','','fa fa-save','admin/config/file','','_self',30,1,0,'2016-05-06 14:39:43'),(9,20,'操作日志','','glyphicon glyphicon-console','admin/log/index','','_self',50,1,0,'2017-03-24 15:49:31'),(19,20,'权限管理','','fa fa-user-secret','admin/auth/index','','_self',10,1,0,'2015-11-17 13:18:12'),(20,2,'系统权限','','','#','','_self',200,1,0,'2016-03-14 18:11:41'),(21,20,'系统菜单','','glyphicon glyphicon-menu-hamburger','admin/menu/index','','_self',30,1,0,'2015-11-16 19:16:16'),(22,20,'节点管理','','fa fa-ellipsis-v','admin/node/index','','_self',20,1,0,'2015-11-16 19:16:16'),(29,20,'系统用户','','fa fa-users','admin/user/index','','_self',40,1,0,'2016-10-31 14:31:40'),(61,0,'微信管理','','','#','','_self',2000,0,0,'2017-03-29 11:00:21'),(62,61,'微信接入参数','','','#','','_self',100,0,0,'2017-03-29 11:03:38'),(63,62,'微信参数配置','','fa fa-usb','wechat/config/index','','_self',10,0,0,'2017-03-29 11:04:44'),(65,61,'微信粉丝管理','','','#','','_self',300,0,0,'2017-03-29 11:08:32'),(66,65,'粉丝标签','','fa fa-tags','wechat/tags/index','','_self',10,0,0,'2017-03-29 11:09:41'),(67,65,'已关注粉丝','','fa fa-wechat','wechat/fans/index','','_self',20,0,0,'2017-03-29 11:10:07'),(68,61,'微信订制','','','#','','_self',200,0,0,'2017-03-29 11:10:39'),(69,68,'微信菜单','','glyphicon glyphicon-phone','wechat/menu/index','','_self',40,0,0,'2017-03-29 11:11:08'),(70,68,'关键字管理','','fa fa-paw','wechat/keys/index','','_self',10,0,0,'2017-03-29 11:11:49'),(71,68,'欢迎消息','','fa fa-commenting-o','wechat/keys/subscribe','','_self',20,0,0,'2017-03-29 11:12:32'),(81,68,'默认回复','','fa fa-commenting-o','wechat/keys/defaults','','_self',30,0,0,'2017-04-21 14:48:25'),(82,61,'素材资源管理','','','#','','_self',300,0,0,'2017-04-24 11:23:18'),(83,82,'添加图文','','fa fa-folder-open-o','wechat/news/add?id=1','','_self',20,0,0,'2017-04-24 11:23:40'),(85,82,'图文列表','','fa fa-file-pdf-o','wechat/news/index','','_self',10,0,0,'2017-04-24 11:25:45'),(86,65,'粉丝黑名单','','fa fa-reddit-alien','wechat/fans/back','','_self',30,0,0,'2017-05-05 16:17:03'),(88,2,'第三方插件','','','#','','_self',300,1,0,'2017-07-10 15:10:37'),(90,88,'PCAS 省市区','','','demo/plugs/region','','_self',0,1,0,'2017-07-10 18:45:47'),(91,2,'内置插件','','','#','','_self',310,1,0,'2017-07-10 18:56:59'),(92,91,'文件上传','','','demo/plugs/file','','_self',0,1,0,'2017-07-10 18:57:22'),(93,88,'富文本编辑器','','','demo/plugs/editor','','_self',0,1,0,'2017-07-28 15:19:44'),(94,0,'后台首页','','','admin/index/main','','_self',0,0,0,'2017-08-08 11:28:43'),(138,62,'支付配置','','','index.php/wechat/config/pay','','_self',0,0,0,'2017-12-12 10:33:37');
/*Table structure for table `system_node` */
DROP TABLE IF EXISTS `system_node`;
CREATE TABLE `system_node` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`node` varchar(100) DEFAULT NULL COMMENT '节点代码',
`title` varchar(500) DEFAULT NULL COMMENT '节点标题',
`is_menu` tinyint(1) unsigned DEFAULT '0' COMMENT '是否可设置为菜单',
`is_auth` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动RBAC权限控制',
`is_login` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动登录控制',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_system_node_node` (`node`)
) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统节点表';
/*Data for the table `system_node` */
insert into `system_node`(`id`,`node`,`title`,`is_menu`,`is_auth`,`is_login`,`create_at`) values (131,'admin/auth/index','权限列表',1,1,1,'2017-08-23 15:45:42'),(132,'admin','后台管理',0,1,1,'2017-08-23 15:45:44'),(133,'admin/auth/apply','节点授权',0,1,1,'2017-08-23 16:05:18'),(134,'admin/auth/add','添加授权',0,1,1,'2017-08-23 16:05:19'),(135,'admin/auth/edit','编辑权限',0,1,1,'2017-08-23 16:05:19'),(136,'admin/auth/forbid','禁用权限',0,1,1,'2017-08-23 16:05:20'),(137,'admin/auth/resume','启用权限',0,1,1,'2017-08-23 16:05:20'),(138,'admin/auth/del','删除权限',0,1,1,'2017-08-23 16:05:21'),(139,'admin/config/index','参数配置',1,1,1,'2017-08-23 16:05:22'),(140,'admin/config/file','文件配置',1,1,1,'2017-08-23 16:05:22'),(141,'admin/log/index','日志列表',1,1,1,'2017-08-23 16:05:23'),(142,'admin/log/del','删除日志',0,1,1,'2017-08-23 16:05:24'),(143,'admin/menu/index','菜单列表',1,1,1,'2017-08-23 16:05:25'),(144,'admin/menu/add','添加菜单',0,1,1,'2017-08-23 16:05:25'),(145,'admin/menu/edit','编辑菜单',0,1,1,'2017-08-23 16:05:26'),(146,'admin/menu/del','删除菜单',0,1,1,'2017-08-23 16:05:26'),(147,'admin/menu/forbid','禁用菜单',0,1,1,'2017-08-23 16:05:27'),(148,'admin/menu/resume','启用菜单',0,1,1,'2017-08-23 16:05:28'),(149,'admin/node/index','节点列表',1,1,1,'2017-08-23 16:05:29'),(150,'admin/node/save','节点更新',0,1,1,'2017-08-23 16:05:30'),(151,'admin/user/index','用户管理',1,1,1,'2017-08-23 16:05:31'),(152,'admin/user/auth','用户授权',0,1,1,'2017-08-23 16:05:32'),(153,'admin/user/add','添加用户',0,1,1,'2017-08-23 16:05:33'),(154,'admin/user/edit','编辑用户',0,1,1,'2017-08-23 16:05:33'),(155,'admin/user/pass','用户密码',0,1,1,'2017-08-23 16:05:34'),(156,'admin/user/del','删除用户',0,1,1,'2017-08-23 16:05:34'),(157,'admin/user/forbid','禁用用户',0,1,1,'2017-08-23 16:05:34'),(158,'admin/user/resume','启用用户',0,1,1,'2017-08-23 16:05:35'),(159,'demo/plugs/file','文件上传',0,1,1,'2017-08-23 16:05:36'),(160,'demo/plugs/region','区域选择',0,1,1,'2017-08-23 16:05:36'),(161,'demo/plugs/editor','富文本器',0,1,1,'2017-08-23 16:05:37'),(162,'wechat/config/index','微信参数',1,1,1,'2017-08-23 16:05:37'),(163,'wechat/config/pay','微信支付',1,1,1,'2017-08-23 16:05:38'),(164,'wechat/fans/index','粉丝列表',1,1,1,'2017-08-23 16:05:39'),(165,'wechat/fans/back','粉丝黑名单',1,1,1,'2017-08-23 16:05:39'),(166,'wechat/fans/backadd','移入黑名单',0,1,1,'2017-08-23 16:05:40'),(167,'wechat/fans/tagset','设置标签',0,1,1,'2017-08-23 16:05:41'),(168,'wechat/fans/backdel','移出黑名单',0,1,1,'2017-08-23 16:05:41'),(169,'wechat/fans/tagadd','添加标签',0,1,1,'2017-08-23 16:05:41'),(170,'wechat/fans/tagdel','删除标签',0,1,1,'2017-08-23 16:05:42'),(171,'wechat/fans/sync','同步粉丝',0,1,1,'2017-08-23 16:05:43'),(172,'wechat/keys/index','关键字列表',1,1,1,'2017-08-23 16:05:44'),(173,'wechat/keys/add','添加关键字',0,1,1,'2017-08-23 16:05:44'),(174,'wechat/keys/edit','编辑关键字',0,1,1,'2017-08-23 16:05:45'),(175,'wechat/keys/del','删除关键字',0,1,1,'2017-08-23 16:05:45'),(176,'wechat/keys/forbid','禁用关键字',0,1,1,'2017-08-23 16:05:46'),(177,'wechat/keys/resume','启用关键字',0,1,1,'2017-08-23 16:05:46'),(178,'wechat/keys/subscribe','关注默认回复',0,1,1,'2017-08-23 16:05:48'),(179,'wechat/keys/defaults','默认响应回复',0,1,1,'2017-08-23 16:05:49'),(180,'wechat/menu/index','微信菜单',1,1,1,'2017-08-23 16:05:51'),(181,'wechat/menu/edit','发布微信菜单',0,1,1,'2017-08-23 16:05:51'),(182,'wechat/menu/cancel','取消微信菜单',0,1,1,'2017-08-23 16:05:52'),(183,'wechat/news/index','微信图文列表',1,1,1,'2017-08-23 16:05:52'),(184,'wechat/news/select','微信图文选择',0,1,1,'2017-08-23 16:05:53'),(185,'wechat/news/image','微信图片选择',0,1,1,'2017-08-23 16:05:53'),(186,'wechat/news/add','添加图文',0,1,1,'2017-08-23 16:05:54'),(187,'wechat/news/edit','编辑图文',0,1,1,'2017-08-23 16:05:56'),(188,'wechat/news/del','删除图文',0,1,1,'2017-08-23 16:05:56'),(189,'wechat/news/push','推送图文',0,1,1,'2017-08-23 16:05:56'),(190,'wechat/tags/index','微信标签列表',1,1,1,'2017-08-23 16:05:58'),(191,'wechat/tags/add','添加微信标签',0,1,1,'2017-08-23 16:05:58'),(192,'wechat/tags/edit','编辑微信标签',0,1,1,'2017-08-23 16:05:58'),(193,'wechat/tags/sync','同步微信标签',0,1,1,'2017-08-23 16:05:59'),(194,'admin/auth','权限管理',0,1,1,'2017-08-23 16:06:58'),(195,'admin/config','系统配置',0,1,1,'2017-08-23 16:07:34'),(196,'admin/log','系统日志',0,1,1,'2017-08-23 16:07:46'),(197,'admin/menu','系统菜单',0,1,1,'2017-08-23 16:08:02'),(198,'admin/node','系统节点',0,1,1,'2017-08-23 16:08:44'),(199,'admin/user','系统用户',0,1,1,'2017-08-23 16:09:43'),(200,'demo','插件案例',0,1,1,'2017-08-23 16:10:43'),(201,'demo/plugs','插件案例',0,1,1,'2017-08-23 16:10:51'),(202,'wechat','微信管理',0,1,1,'2017-08-23 16:11:13'),(203,'wechat/config','微信配置',0,1,1,'2017-08-23 16:11:19'),(204,'wechat/fans','粉丝管理',0,1,1,'2017-08-23 16:11:36'),(205,'wechat/keys','关键字管理',0,1,1,'2017-08-23 16:13:00'),(206,'wechat/menu','微信菜单管理',0,1,1,'2017-08-23 16:14:11'),(207,'wechat/news','微信图文管理',0,1,1,'2017-08-23 16:14:40'),(208,'wechat/tags','微信标签管理',0,1,1,'2017-08-23 16:15:25'),(209,'os/advice/index','省内导医管理',0,1,1,'2017-10-13 15:59:24'),(210,'os/advice','医疗系统',0,1,1,'2017-10-13 15:59:24'),(211,'os','医疗系统',0,1,1,'2017-10-13 15:59:52'),(212,'os/advice/edit','省内导医管理修改',1,1,1,'2017-10-16 14:32:35'),(213,'os/advice/add','省内导医管理添加',0,1,1,'2017-10-16 15:50:41'),(214,'os/advice/del','省内导医管理删除',0,1,1,'2017-10-16 15:50:44'),(215,'os/advice/beijing','北京导医管理',0,1,1,'2017-10-16 15:50:52'),(216,'os/advice/bjadd','北京导医添加',0,1,1,'2017-10-16 15:50:56'),(217,'os/advice/bjdel','北京导医删除',0,1,1,'2017-10-16 15:51:00'),(218,'os/advice/bjedit','北京导医修改',0,1,1,'2017-10-16 15:51:04'),(219,'os/advice/over','美国医学第二意见',0,1,1,'2017-10-16 15:51:13'),(220,'os/advice/overadd','美国医学第二意见添加',0,1,1,'2017-10-16 15:51:18'),(221,'os/advice/overedit','美国医学第二意见修改',0,1,1,'2017-10-16 15:51:22'),(222,'os/advice/overdel','美国医学第二意见删除',0,1,1,'2017-10-16 15:51:26'),(223,'os/advice/ery','海外就医管理',0,1,1,'2017-10-16 15:51:42'),(224,'os/advice/eryadd','海外就医添加',0,1,1,'2017-10-16 15:54:07'),(225,'os/advice/erydel','海外就医删除',0,1,1,'2017-10-16 15:54:09'),(226,'os/advice/eryedit','海外就医修改',0,1,1,'2017-10-16 15:54:11'),(227,'os/banner/index','banner',0,1,1,'2017-10-16 15:54:12'),(228,'os/banner/banadd','添加banner',0,1,1,'2017-10-16 15:54:13'),(229,'os/banner/bandel','删除banner',0,1,1,'2017-10-16 15:54:14'),(230,'os/membercard/index','会员卡管理',0,1,1,'2017-10-16 15:54:15'),(231,'os/membercard/mberadd','添加会员卡',0,1,1,'2017-10-16 15:54:16'),(232,'os/membercard/mberedit','修改会员卡',0,1,1,'2017-10-16 15:54:17'),(233,'os/membercard/mberdel','删除会员卡',0,1,1,'2017-10-16 15:54:17'),(234,'os/welfare/index','公益管理',0,1,1,'2017-10-16 15:54:21'),(235,'os/welfare/welfadd','添加公益',0,1,1,'2017-10-16 15:54:21'),(236,'os/welfare/welfedit','修改公益',0,1,1,'2017-10-16 15:54:22'),(237,'os/welfare/welfdel','删除公益',0,1,1,'2017-10-16 15:54:23'),(238,'os/banner','banner管理',0,1,1,'2017-10-16 16:02:23'),(239,'os/membercard','会员卡管理',0,1,1,'2017-10-16 16:02:47'),(240,'os/welfare','公益管理',0,1,1,'2017-10-17 09:05:17'),(241,'os/act/index',NULL,0,1,1,'2017-11-10 09:42:41'),(242,'os/act/actadd',NULL,0,1,1,'2017-11-10 09:42:42'),(243,'os/act/actdel',NULL,0,1,1,'2017-11-10 09:42:43'),(244,'os/act/actedit',NULL,0,1,1,'2017-11-10 09:42:44'),(245,'os/advice/gene','',0,1,1,'2017-11-10 09:42:47'),(246,'os/advice/yiliao',NULL,0,1,1,'2017-11-10 09:42:48'),(247,'os/banner/serviceimg',NULL,0,1,1,'2017-11-10 09:42:50'),(248,'os/banner/servimgadd',NULL,0,1,1,'2017-11-10 09:42:51'),(249,'os/banner/servdel',NULL,0,1,1,'2017-11-10 09:42:51'),(250,'os/come/index',NULL,0,1,1,'2017-11-10 09:42:53'),(251,'os/come/ysdel',NULL,0,1,1,'2017-11-10 09:42:53'),(252,'os/come/yssee',NULL,0,1,1,'2017-11-10 09:42:54'),(253,'os/come/zixun',NULL,0,1,1,'2017-11-10 09:42:54'),(254,'os/come/zixundel',NULL,0,1,1,'2017-11-10 09:42:54'),(255,'os/come/zixunsee',NULL,0,1,1,'2017-11-10 09:42:55'),(256,'os/come/hw',NULL,0,1,1,'2017-11-10 09:42:56'),(257,'os/come/hwsee',NULL,0,1,1,'2017-11-10 09:42:58'),(258,'os/come/hwdel',NULL,0,1,1,'2017-11-10 09:42:58'),(259,'os/come/peizh',NULL,0,1,1,'2017-11-10 09:42:59'),(260,'os/come/peizhsee',NULL,0,1,1,'2017-11-10 09:42:59'),(261,'os/come/peizhdel',NULL,0,1,1,'2017-11-10 09:43:00'),(262,'os/cons/index',NULL,0,1,1,'2017-11-10 09:43:01'),(263,'os/cons/he',NULL,0,1,1,'2017-11-10 09:43:01'),(264,'os/cons/del',NULL,0,1,1,'2017-11-10 09:43:02'),(265,'os/cons/edit',NULL,0,1,1,'2017-11-10 09:43:02'),(266,'os/cons/add',NULL,0,1,1,'2017-11-10 09:43:03'),(267,'os/cons/company',NULL,0,1,1,'2017-11-10 09:43:03'),(268,'os/cons/comadd',NULL,0,1,1,'2017-11-10 09:43:05'),(269,'os/cons/compdel',NULL,0,1,1,'2017-11-10 09:43:05'),(270,'os/cons/compedit',NULL,0,1,1,'2017-11-10 09:43:06'),(271,'os/kefu/index',NULL,0,1,1,'2017-11-10 09:43:08'),(272,'os/long/index',NULL,0,1,1,'2017-11-10 09:43:09'),(273,'os/long/rb',NULL,0,1,1,'2017-11-10 09:43:10'),(274,'os/order/index',NULL,0,1,1,'2017-11-10 09:43:13'),(275,'os/useru/index',NULL,0,1,1,'2017-11-10 09:43:13'),(276,'os/useru/del',NULL,0,1,1,'2017-11-10 09:43:14'),(277,'os/useru/edit',NULL,0,1,1,'2017-11-10 09:43:14'),(278,'os/useru/yh',NULL,0,1,1,'2017-11-10 09:43:16'),(279,'os/wal/index',NULL,0,1,1,'2017-11-10 09:43:17'),(280,'os/wal/waladd',NULL,0,1,1,'2017-11-10 09:43:17'),(281,'os/wal/waldel',NULL,0,1,1,'2017-11-10 09:43:17'),(282,'os/wal/waledit',NULL,0,1,1,'2017-11-10 09:43:18'),(283,'os/wal/number',NULL,0,1,1,'2017-11-10 09:43:20'),(284,'os/wal/numadd',NULL,0,1,1,'2017-11-10 09:43:21'),(285,'os/wal/numedit',NULL,0,1,1,'2017-11-10 09:43:21'),(286,'os/wal/numdel',NULL,0,1,1,'2017-11-10 09:43:22'),(287,'os/xitong/index',NULL,0,1,1,'2017-11-10 09:43:25'),(288,'os/xitong/add',NULL,0,1,1,'2017-11-10 09:43:25'),(289,'os/xitong/edit',NULL,0,1,1,'2017-11-10 09:43:26'),(290,'os/xitong/del',NULL,0,1,1,'2017-11-10 09:43:27'),(291,'os/xitong/agree',NULL,0,1,1,'2017-11-10 09:43:27'),(292,'os/yy/index',NULL,0,1,1,'2017-11-10 09:43:29'),(293,'os/yy/yyadd',NULL,0,1,1,'2017-11-10 09:43:30'),(294,'os/yy/yyedit',NULL,0,1,1,'2017-11-10 09:43:30'),(295,'os/yy/yydel',NULL,0,1,1,'2017-11-10 09:43:31'),(296,'os/yy/ks',NULL,0,1,1,'2017-11-10 09:43:31'),(297,'os/yy/ksadd',NULL,0,1,1,'2017-11-10 09:43:32'),(298,'os/yy/ksedit',NULL,0,1,1,'2017-11-10 09:43:33'),(299,'os/yy/ksdel',NULL,0,1,1,'2017-11-10 09:43:33'),(300,'os/useru/add',NULL,0,1,1,'2017-12-22 11:17:10'),(301,'os/useru/co',NULL,0,1,1,'2017-12-22 11:17:11'),(302,'os/waitact/index',NULL,1,1,1,'2017-12-22 11:17:16'),(303,'os/waitact/del',NULL,1,1,1,'2017-12-22 11:17:17'),(304,'os/waitact/add',NULL,1,1,1,'2017-12-22 11:17:17'),(305,'os/grade/index',NULL,0,1,1,'2018-05-28 14:26:50'),(306,'os/grade/add',NULL,0,1,1,'2018-05-28 14:26:51'),(307,'os/grade/del',NULL,0,1,1,'2018-05-28 14:26:51'),(308,'os/grade/edit',NULL,0,1,1,'2018-05-28 14:26:52'),(309,'os/index/index',NULL,0,1,1,'2018-05-28 14:26:54'),(310,'os/user/index',NULL,0,1,1,'2018-05-28 14:26:55'),(311,'os/user/add',NULL,0,1,1,'2018-05-28 14:26:56'),(312,'os/user/edit',NULL,0,1,1,'2018-05-28 14:26:56'),(313,'os/user/del',NULL,0,1,1,'2018-05-28 14:26:57'),(314,'os/waybill/index',NULL,0,1,1,'2018-05-28 14:26:58'),(315,'os/waybill/add',NULL,0,1,1,'2018-05-28 14:26:58'),(316,'os/waybill/del',NULL,0,1,1,'2018-05-28 14:26:59'),(317,'os/waybill/edit',NULL,0,1,1,'2018-05-28 14:27:00'),(318,'app/login','',0,1,1,'2018-06-14 10:40:30'),(319,'app/prese','',0,1,1,'2018-06-14 10:40:31'),(320,'app/prese/index','',0,1,1,'2018-06-14 10:40:40'),(321,'os/member','会员卡管理',0,1,1,'2018-06-14 10:41:06'),(322,'os/membertype','会员卡类型',0,1,1,'2018-06-14 10:41:12'),(323,'os/personnel','人员管理',0,1,1,'2018-06-14 10:41:17'),(324,'os/presenta','报告管理',0,1,1,'2018-06-14 10:41:25'),(325,'os/subject','报告类型管理',0,1,1,'2018-06-14 10:41:36'),(326,'os/usermodel','模板管理',0,1,1,'2018-06-14 10:41:41');
/*Table structure for table `system_sequence` */
DROP TABLE IF EXISTS `system_sequence`;
CREATE TABLE `system_sequence` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(20) DEFAULT NULL COMMENT '序号类型',
`sequence` char(50) NOT NULL COMMENT '序号值',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `index_system_sequence_unique` (`type`,`sequence`) USING BTREE,
KEY `index_system_sequence_type` (`type`),
KEY `index_system_sequence_number` (`sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='系统序号表';
/*Data for the table `system_sequence` */
insert into `system_sequence`(`id`,`type`,`sequence`,`create_at`) values (1,'WECHAT-PAY-TEST','5018988667','2017-12-12 10:34:44'),(2,'WXPAY-OUTER-NO','779197374130524141','2017-12-12 10:34:44'),(3,'WXPAY-OUTER-NO','696251593357612826','2017-12-12 10:36:21'),(4,'WXPAY-OUTER-NO','105964902772776933','2017-12-12 10:36:24'),(5,'WXPAY-OUTER-NO','567199576159557917','2017-12-12 10:36:45'),(6,'WXPAY-OUTER-NO','411328044612547261','2017-12-12 10:36:47'),(7,'WXPAY-OUTER-NO','749427819217224982','2017-12-12 10:38:30'),(8,'WECHAT-PAY-TEST','9642775258','2017-12-12 11:15:24'),(9,'WXPAY-OUTER-NO','704369526764757251','2017-12-12 11:15:24'),(10,'WECHAT-PAY-TEST','3406517802','2017-12-12 11:40:09'),(11,'WXPAY-OUTER-NO','649179019960272390','2017-12-12 11:40:09'),(12,'WECHAT-PAY-TEST','5903172781','2017-12-12 11:41:03'),(13,'WXPAY-OUTER-NO','340511532324479049','2017-12-12 11:41:03'),(14,'WECHAT-PAY-TEST','6385262337','2017-12-12 11:45:41'),(15,'WXPAY-OUTER-NO','173571958387288393','2017-12-12 11:45:41'),(16,'WECHAT-PAY-TEST','5621198947','2017-12-12 11:56:59'),(17,'WXPAY-OUTER-NO','598348729453292307','2017-12-12 11:56:59'),(18,'WXPAY-OUTER-NO','958607370681637126','2017-12-12 14:12:54');
/*Table structure for table `system_user` */
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户登录名',
`password` char(32) NOT NULL DEFAULT '' COMMENT '用户登录密码',
`qq` varchar(16) DEFAULT NULL COMMENT '联系QQ',
`mail` varchar(32) DEFAULT NULL COMMENT '联系邮箱',
`phone` varchar(16) DEFAULT NULL COMMENT '联系手机号',
`desc` varchar(255) DEFAULT '' COMMENT '备注说明',
`login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
`login_at` datetime DEFAULT NULL,
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
`authorize` varchar(255) DEFAULT NULL,
`is_deleted` tinyint(1) unsigned DEFAULT '0' COMMENT '删除状态(1:删除,0:未删)',
`create_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `index_system_user_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10010 DEFAULT CHARSET=utf8 COMMENT='系统用户表';
/*Data for the table `system_user` */
insert into `system_user`(`id`,`username`,`password`,`qq`,`mail`,`phone`,`desc`,`login_num`,`login_at`,`status`,`authorize`,`is_deleted`,`create_by`,`create_at`) values (10000,'root','e10adc3949ba59abbe56e057f20f883e','22222222','qq@qq.com','13000000000','哥就是欧莱雅,你,值得拥有',27229,'2019-07-06 09:42:31',1,'1',0,NULL,'2015-11-13 15:14:22'),(10009,'123','',NULL,'2336642891@qq.com','13644302689','1',0,NULL,1,'1',1,NULL,'2019-07-06 09:46:19');
/*Table structure for table `wechat_fans` */
DROP TABLE IF EXISTS `wechat_fans`;
CREATE TABLE `wechat_fans` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '粉丝表ID',
`appid` varchar(50) DEFAULT NULL COMMENT '公众号Appid',
`groupid` bigint(20) unsigned DEFAULT NULL COMMENT '分组ID',
`tagid_list` varchar(100) DEFAULT '' COMMENT '标签id',
`is_back` tinyint(1) unsigned DEFAULT '0' COMMENT '是否为黑名单用户',
`subscribe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户是否订阅该公众号,0:未关注,1:已关注',
`openid` char(100) NOT NULL DEFAULT '' COMMENT '用户的标识,对当前公众号唯一',
`spread_openid` char(100) DEFAULT NULL COMMENT '推荐人OPENID',
`spread_at` datetime DEFAULT NULL,
`nickname` varchar(100) DEFAULT NULL COMMENT '用户的昵称',
`sex` tinyint(1) unsigned DEFAULT NULL COMMENT '用户的性别,值为1时是男性,值为2时是女性,值为0时是未知',
`country` varchar(50) DEFAULT NULL COMMENT '用户所在国家',
`province` varchar(50) DEFAULT NULL COMMENT '用户所在省份',
`city` varchar(50) DEFAULT NULL COMMENT '用户所在城市',
`language` varchar(50) DEFAULT NULL COMMENT '用户的语言,简体中文为zh_CN',
`headimgurl` varchar(500) DEFAULT NULL COMMENT '用户头像',
`subscribe_time` bigint(20) unsigned DEFAULT NULL COMMENT '用户关注时间',
`subscribe_at` datetime DEFAULT NULL COMMENT '关注时间',
`unionid` varchar(100) DEFAULT NULL COMMENT 'unionid',
`remark` varchar(50) DEFAULT NULL COMMENT '备注',
`expires_in` bigint(20) unsigned DEFAULT '0' COMMENT '有效时间',
`refresh_token` varchar(200) DEFAULT NULL COMMENT '刷新token',
`access_token` varchar(200) DEFAULT NULL COMMENT '访问token',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_wechat_fans_spread_openid` (`spread_openid`) USING BTREE,
KEY `index_wechat_fans_openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信粉丝';
/*Data for the table `wechat_fans` */
/*Table structure for table `wechat_fans_tags` */
DROP TABLE IF EXISTS `wechat_fans_tags`;
CREATE TABLE `wechat_fans_tags` (
`id` bigint(20) unsigned NOT NULL COMMENT '标签ID',
`appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
`name` varchar(35) DEFAULT NULL COMMENT '标签名称',
`count` int(11) unsigned DEFAULT NULL COMMENT '总数',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
KEY `index_wechat_fans_tags_id` (`id`) USING BTREE,
KEY `index_wechat_fans_tags_appid` (`appid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信会员标签';
/*Data for the table `wechat_fans_tags` */
/*Table structure for table `wechat_keys` */
DROP TABLE IF EXISTS `wechat_keys`;
CREATE TABLE `wechat_keys` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
`type` varchar(20) DEFAULT NULL COMMENT '类型,text 文件消息,image 图片消息,news 图文消息',
`keys` varchar(100) DEFAULT NULL COMMENT '关键字',
`content` text COMMENT '文本内容',
`image_url` varchar(255) DEFAULT NULL COMMENT '图片链接',
`voice_url` varchar(255) DEFAULT NULL COMMENT '语音链接',
`music_title` varchar(100) DEFAULT NULL COMMENT '音乐标题',
`music_url` varchar(255) DEFAULT NULL COMMENT '音乐链接',
`music_image` varchar(255) DEFAULT NULL COMMENT '音乐缩略图链接',
`music_desc` varchar(255) DEFAULT NULL COMMENT '音乐描述',
`video_title` varchar(100) DEFAULT NULL COMMENT '视频标题',
`video_url` varchar(255) DEFAULT NULL COMMENT '视频URL',
`video_desc` varchar(255) DEFAULT NULL COMMENT '视频描述',
`news_id` bigint(20) unsigned DEFAULT NULL COMMENT '图文ID',
`sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序字段',
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '0 禁用,1 启用',
`create_by` bigint(20) unsigned DEFAULT NULL COMMENT '创建人',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=' 微信关键字';
/*Data for the table `wechat_keys` */
insert into `wechat_keys`(`id`,`appid`,`type`,`keys`,`content`,`image_url`,`voice_url`,`music_title`,`music_url`,`music_image`,`music_desc`,`video_title`,`video_url`,`video_desc`,`news_id`,`sort`,`status`,`create_by`,`create_at`) values (1,NULL,'image','8','说点什么吧','http://127.0.0.1:10092/static/theme/default/img/image.png','','音乐标题','','http://127.0.0.1:10092/static/theme/default/img/image.png','音乐描述','视频标题','','视频描述',0,0,1,NULL,'2017-09-15 18:58:10');
/*Table structure for table `wechat_menu` */
DROP TABLE IF EXISTS `wechat_menu`;
CREATE TABLE `wechat_menu` (
`id` bigint(16) unsigned NOT NULL AUTO_INCREMENT,
`index` bigint(20) DEFAULT NULL,
`pindex` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
`type` varchar(24) NOT NULL DEFAULT '' COMMENT '菜单类型 null主菜单 link链接 keys关键字',
`name` varchar(256) NOT NULL DEFAULT '' COMMENT '菜单名称',
`content` text NOT NULL COMMENT '文字内容',
`sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序',
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(0禁用1启用)',
`create_by` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_wechat_menu_pindex` (`pindex`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='微信菜单配置';
/*Data for the table `wechat_menu` */
insert into `wechat_menu`(`id`,`index`,`pindex`,`type`,`name`,`content`,`sort`,`status`,`create_by`,`create_at`) values (1,1,0,'text','一级菜单','',0,1,0,'2017-09-15 18:58:53');
/*Table structure for table `wechat_news` */
DROP TABLE IF EXISTS `wechat_news`;
CREATE TABLE `wechat_news` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`media_id` varchar(100) DEFAULT NULL COMMENT '永久素材MediaID',
`local_url` varchar(300) DEFAULT NULL COMMENT '永久素材显示URL',
`article_id` varchar(60) DEFAULT NULL COMMENT '关联图文ID,用,号做分割',
`is_deleted` tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
PRIMARY KEY (`id`),
KEY `index_wechat_new_artcle_id` (`article_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信图文表';
/*Data for the table `wechat_news` */
/*Table structure for table `wechat_news_article` */
DROP TABLE IF EXISTS `wechat_news_article`;
CREATE TABLE `wechat_news_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT NULL COMMENT '素材标题',
`local_url` varchar(300) DEFAULT NULL COMMENT '永久素材显示URL',
`show_cover_pic` tinyint(4) unsigned DEFAULT '0' COMMENT '是否显示封面 0不显示,1 显示',
`author` varchar(20) DEFAULT NULL COMMENT '作者',
`digest` varchar(300) DEFAULT NULL COMMENT '摘要内容',
`content` longtext COMMENT '图文内容',
`content_source_url` varchar(200) DEFAULT NULL COMMENT '图文消息原文地址',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_by` bigint(20) DEFAULT NULL COMMENT '创建人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信素材表';
/*Data for the table `wechat_news_article` */
/*Table structure for table `wechat_news_image` */
DROP TABLE IF EXISTS `wechat_news_image`;
CREATE TABLE `wechat_news_image` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`md5` varchar(32) DEFAULT NULL COMMENT '文件md5',
`local_url` varchar(300) DEFAULT NULL COMMENT '本地文件链接',
`media_url` varchar(300) DEFAULT NULL COMMENT '远程图片链接',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `index_wechat_news_image_md5` (`md5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信服务器图片';
/*Data for the table `wechat_news_image` */
/*Table structure for table `wechat_news_media` */
DROP TABLE IF EXISTS `wechat_news_media`;
CREATE TABLE `wechat_news_media` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`appid` varchar(200) DEFAULT NULL COMMENT '公众号ID',
`md5` varchar(32) DEFAULT NULL COMMENT '文件md5',
`type` varchar(20) DEFAULT NULL COMMENT '媒体类型',
`media_id` varchar(100) DEFAULT NULL COMMENT '永久素材MediaID',
`local_url` varchar(300) DEFAULT NULL COMMENT '本地文件链接',
`media_url` varchar(300) DEFAULT NULL COMMENT '远程图片链接',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信素材表';
/*Data for the table `wechat_news_media` */
/*Table structure for table `wechat_pay_notify` */
DROP TABLE IF EXISTS `wechat_pay_notify`;
CREATE TABLE `wechat_pay_notify` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`appid` varchar(50) DEFAULT NULL COMMENT '公众号Appid',
`bank_type` varchar(50) DEFAULT NULL COMMENT '银行类型',
`cash_fee` bigint(20) DEFAULT NULL COMMENT '现金价',
`fee_type` char(20) DEFAULT NULL COMMENT '币种,1人民币',
`is_subscribe` char(1) DEFAULT 'N' COMMENT '是否关注,Y为关注,N为未关注',
`mch_id` varchar(50) DEFAULT NULL COMMENT '商户MCH_ID',
`nonce_str` varchar(32) DEFAULT NULL COMMENT '随机串',
`openid` varchar(50) DEFAULT NULL COMMENT '微信用户openid',
`out_trade_no` varchar(50) DEFAULT NULL COMMENT '支付平台退款交易号',
`sign` varchar(100) DEFAULT NULL COMMENT '签名',
`time_end` datetime DEFAULT NULL COMMENT '结束时间',
`result_code` varchar(10) DEFAULT NULL,
`return_code` varchar(10) DEFAULT NULL,
`total_fee` varchar(11) DEFAULT NULL COMMENT '支付总金额,单位为分',
`trade_type` varchar(20) DEFAULT NULL COMMENT '支付方式',
`transaction_id` varchar(64) DEFAULT NULL COMMENT '订单号',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '本地系统时间',
PRIMARY KEY (`id`),
KEY `index_wechat_pay_notify_openid` (`openid`) USING BTREE,
KEY `index_wechat_pay_notify_out_trade_no` (`out_trade_no`) USING BTREE,
KEY `index_wechat_pay_notify_transaction_id` (`transaction_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付日志表';
/*Data for the table `wechat_pay_notify` */
/*Table structure for table `wechat_pay_prepayid` */
DROP TABLE IF EXISTS `wechat_pay_prepayid`;
CREATE TABLE `wechat_pay_prepayid` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`appid` char(50) DEFAULT NULL COMMENT '公众号APPID',
`from` char(32) DEFAULT 'shop' COMMENT '支付来源',
`fee` bigint(20) unsigned DEFAULT NULL COMMENT '支付费用(分)',
`trade_type` varchar(20) DEFAULT NULL COMMENT '订单类型',
`order_no` varchar(50) DEFAULT NULL COMMENT '内部订单号',
`out_trade_no` varchar(50) DEFAULT NULL COMMENT '外部订单号',
`prepayid` varchar(500) DEFAULT NULL COMMENT '预支付码',
`expires_in` bigint(20) unsigned DEFAULT NULL COMMENT '有效时间',
`transaction_id` varchar(64) DEFAULT NULL COMMENT '微信平台订单号',
`is_pay` tinyint(1) unsigned DEFAULT '0' COMMENT '1已支付,0未支退款',
`pay_at` datetime DEFAULT NULL COMMENT '支付时间',
`is_refund` tinyint(1) unsigned DEFAULT '0' COMMENT '是否退款,退款单号(T+原来订单)',
`refund_at` datetime DEFAULT NULL COMMENT '退款时间',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '本地系统时间',
PRIMARY KEY (`id`),
KEY `index_wechat_pay_prepayid_outer_no` (`out_trade_no`) USING BTREE,
KEY `index_wechat_pay_prepayid_order_no` (`order_no`) USING BTREE,
KEY `index_wechat_pay_is_pay` (`is_pay`) USING BTREE,
KEY `index_wechat_pay_is_refund` (`is_refund`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='支付订单号对应表';
/*Data for the table `wechat_pay_prepayid` */
insert into `wechat_pay_prepayid`(`id`,`appid`,`from`,`fee`,`trade_type`,`order_no`,`out_trade_no`,`prepayid`,`expires_in`,`transaction_id`,`is_pay`,`pay_at`,`is_refund`,`refund_at`,`create_at`) values (1,'wxc4978101b35a6f39','wechat',1,'NATIVE','5018988667','749427819217224982','weixin://wxpay/bizpayurl?pr=W7u3gJr',1513051711,NULL,0,NULL,0,NULL,'2017-12-12 10:38:31'),(2,'wxc4978101b35a6f39','wechat',1,'JSAPI','9642775258','704369526764757251','wx201712121115249c3762d14d0466796521',1513053924,NULL,0,NULL,0,NULL,'2017-12-12 11:15:24'),(3,'wxc4978101b35a6f39','wechat',1,'JSAPI','3406517802','649179019960272390','wx20171212114010aba93d3ef90549662827',1513055410,NULL,0,NULL,0,NULL,'2017-12-12 11:40:10'),(4,'wxc4978101b35a6f39','wechat',1,'JSAPI','5903172781','340511532324479049','wx201712121141049568d5346f0826870201',1513055464,NULL,0,NULL,0,NULL,'2017-12-12 11:41:04'),(5,'wxc4978101b35a6f39','wechat',1,'JSAPI','6385262337','173571958387288393','wx2017121211454111a15fccf70216505191',1513055742,NULL,0,NULL,0,NULL,'2017-12-12 11:45:42'),(6,'wxc4978101b35a6f39','wechat',1,'JSAPI','5621198947','598348729453292307','wx201712121156599e97bc344b0439338715',1513056419,NULL,0,NULL,0,NULL,'2017-12-12 11:56:59'),(7,'wxc4978101b35a6f39','wechat',1,'JSAPI','6385262337','958607370681637126','wx20171212141254bb6c43e3ad0245591121',1513064575,NULL,0,NULL,0,NULL,'2017-12-12 14:12:55');
/*Table structure for table `weixin_paylogs` */
DROP TABLE IF EXISTS `weixin_paylogs`;
CREATE TABLE `weixin_paylogs` (
`logid` int(11) NOT NULL AUTO_INCREMENT,
`appid` varchar(20) DEFAULT NULL,
`attach` int(11) DEFAULT NULL,
`bank_type` varchar(10) DEFAULT NULL,
`cash_fee` varchar(10) DEFAULT NULL,
`fee_type` varchar(10) DEFAULT NULL,
`is_subscribe` varchar(5) DEFAULT NULL,
`mch_id` varchar(15) DEFAULT NULL,
`nonce_str` varchar(40) DEFAULT NULL,
`openid` varchar(30) DEFAULT NULL,
`out_trade_no` varchar(30) DEFAULT NULL,
`result_code` varchar(10) DEFAULT NULL,
`return_code` varchar(10) DEFAULT NULL,
`sign` varchar(40) DEFAULT NULL,
`time_end` varchar(20) DEFAULT NULL,
`total_fee` varchar(10) DEFAULT NULL,
`trade_type` varchar(10) DEFAULT NULL,
`transaction_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`logid`)
) ENGINE=InnoDB AUTO_INCREMENT=644 DEFAULT CHARSET=utf8;
/*Data for the table `weixin_paylogs` */
insert into `weixin_paylogs`(`logid`,`appid`,`attach`,`bank_type`,`cash_fee`,`fee_type`,`is_subscribe`,`mch_id`,`nonce_str`,`openid`,`out_trade_no`,`result_code`,`return_code`,`sign`,`time_end`,`total_fee`,`trade_type`,`transaction_id`) values (613,'wxc4978101b35a6f39',72,'CFT','1','CNY','N','1489989602','7x4bwxj7dvxd5hyu1l89tje9vrb9daaf','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171213143541','SUCCESS','SUCCESS','AC433408BE97749D8AEBCC271DD2C381','20171213143548','1','JSAPI','4200000002201712133367413592'),(614,'wxc4978101b35a6f39',74,'CFT','1','CNY','N','1489989602','8hqicjkzm9czjqlgb4t3v30e2otlfbow','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171213143955','SUCCESS','SUCCESS','3284E56A38B52D4E5FD4BD9BB59D7135','20171213144002','1','JSAPI','4200000012201712133372236115'),(615,'wxc4978101b35a6f39',67,'CFT','1','CNY','N','1489989602','57hg3fr559qeetyejlq0f70wuly2hhev','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171213140729','SUCCESS','SUCCESS','8394B22DF5C6D1092EE344BD4E01C92E','20171213140843','1','JSAPI','4200000006201712133412708897'),(616,'wxc4978101b35a6f39',71,'CFT','1','CNY','N','1489989602','uhoyknb0m6lsip4ylfzwhrmubxehb9wv','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171213142216','SUCCESS','SUCCESS','9767B656A5737F3C8B126CECC35AA27B','20171213142224','1','JSAPI','4200000010201712133351104653'),(617,'wxc4978101b35a6f39',80,'CFT','1','CNY','N','1489989602','b0p90eek5ijll2o7kw700l5eeubdmxqj','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171213155718','SUCCESS','SUCCESS','79BC07714358F0B315EB80782C639FBB','20171213155725','1','JSAPI','4200000004201712133410802568'),(618,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(619,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(620,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(621,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(622,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(623,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(624,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(625,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(626,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(627,'wxc4978101b35a6f39',89,'CFT','1','CNY','N','1489989602','lwbi8fxfnaluvcv9mnt0p5xv4pur52zo','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171219103541','SUCCESS','SUCCESS','FCE39E4545B9462834B27B78D76FFC04','20171219103552','1','JSAPI','4200000024201712196984663579'),(628,'wxc4978101b35a6f39',144,'CFT','1','CNY','N','1489989602','xkg4j6w9ldytljbmecwyyiyvtgjm842m','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220171225101943','SUCCESS','SUCCESS','7AD0851997D92D2D456DA37589FA1044','20171225101952','1','JSAPI','4200000008201712250954100276'),(629,'wxc4978101b35a6f39',189,'COMM_DEBIT','29900','CNY','Y','1489989602','icxrsx48ya6n959rjy2hjw3ffvkeo5yk','oySCywabcvwaU84uobztAxXXlRfY','148998960220180105140626','SUCCESS','SUCCESS','520703C7CEDE6735A1F66C0038F93392','20180105140641','29900','JSAPI','4200000019201801058456761201'),(630,'wxc4978101b35a6f39',190,'CFT','1','CNY','N','1489989602','muv554695b4p77bo8m81ciies8m2oedc','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180105144036','SUCCESS','SUCCESS','16291ACC8BDE19191B20FEA6CC85F1B9','20180105144047','1','JSAPI','4200000030201801058575181282'),(631,'wxc4978101b35a6f39',193,'CFT','1495','CNY','Y','1489989602','2fe7mexzz97hrmofr43g1g9bzq1mu2t7','oySCywabcvwaU84uobztAxXXlRfY','148998960220180105160015','SUCCESS','SUCCESS','10545780C46757557A2BBC5F625CB67D','20180105160022','1495','JSAPI','4200000024201801058595181009'),(632,'wxc4978101b35a6f39',195,'CFT','1','CNY','N','1489989602','93h8wjeusf6c0r0grgizuwc949o4fj78','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180105160833','SUCCESS','SUCCESS','0A02913480F693942FA5EDC91F8098E0','20180105160843','1','JSAPI','4200000012201801058614457896'),(633,'wxc4978101b35a6f39',196,'CFT','1','CNY','N','1489989602','of210hyn97qikefsd2zfnw8ipa1i759l','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180105162149','SUCCESS','SUCCESS','A3BEB5C219EFC442A97BDF6D6CEDB364','20180105162200','1','JSAPI','4200000021201801058630622757'),(634,'wxc4978101b35a6f39',197,'CFT','1','CNY','N','1489989602','gn1gvryor0jetmqf393h57c6nicng9zf','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180105162437','SUCCESS','SUCCESS','15A8A5B146F75F1E668AF1C7B6492A2C','20180105162444','1','JSAPI','4200000028201801058663206637'),(635,'wxc4978101b35a6f39',198,'CFT','1','CNY','N','1489989602','ryw1pjhoz3x07m86e6eohhkv79uck92v','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180105162727','SUCCESS','SUCCESS','CC783DF9BE63891D17AD1137ECB2B4AE','20180105162735','1','JSAPI','4200000001201801058564846507'),(636,'wxc4978101b35a6f39',204,'CFT','1495','CNY','Y','1489989602','o2x5c7f3dhubdiv0wi4wyp6uk7ya545w','oySCywabcvwaU84uobztAxXXlRfY','148998960220180105163304','SUCCESS','SUCCESS','CF83180A7B3CE67D1E39C2F78A13382B','20180105163315','1495','JSAPI','4200000030201801058528511641'),(637,'wxc4978101b35a6f39',205,'CFT','1495','CNY','Y','1489989602','33p5w4ivf2j1j9otibqmrm9cpau3hz74','oySCywabcvwaU84uobztAxXXlRfY','148998960220180105165031','SUCCESS','SUCCESS','3391FB9313465858CC5A3D25177F0F6E','20180105165038','1495','JSAPI','4200000008201801058616501685'),(638,'wxc4978101b35a6f39',206,'CFT','299','CNY','Y','1489989602','0hntkry2pmmwsla6zd16nvn6euyf5u16','oySCywabcvwaU84uobztAxXXlRfY','148998960220180109135448','SUCCESS','SUCCESS','8A38C335DB836A2589E2D4F44064F6AF','20180109135457','299','JSAPI','4200000051201801090808404226'),(639,'wxc4978101b35a6f39',207,'CFT','299','CNY','Y','1489989602','wes8ex7liat4pxvrle1di8dkbq3x26jf','oySCywabcvwaU84uobztAxXXlRfY','148998960220180109140306','SUCCESS','SUCCESS','E1467759C2EE06ED64392A6F0B8DCA62','20180109140312','299','JSAPI','4200000077201801090899864585'),(640,'wxc4978101b35a6f39',210,'CFT','1','CNY','N','1489989602','k1yi8j7ggij8pq0z814xkn0r9ytjzix2','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180109152549','SUCCESS','SUCCESS','E84CBAE601E5400631AE5DCEE50DBBC1','20180109152559','1','JSAPI','4200000069201801090879406430'),(641,'wxc4978101b35a6f39',216,'CFT','1','CNY','N','1489989602','kgwpryssr4em339cn99zg778665nhhk2','oySCywV1yBSRuMnaQv8WM4WapzBc','148998960220180110155654','SUCCESS','SUCCESS','815AE4C1928DFFD0287D2BB30D718706','20180110155703','1','JSAPI','4200000070201801101454728738'),(642,'wxc4978101b35a6f39',218,'CFT','299','CNY','Y','1489989602','sq5till1g5cpe4kvz97kl3fyoszbzrft','oySCywabcvwaU84uobztAxXXlRfY','148998960220180110160511','SUCCESS','SUCCESS','DADF064A10D0CE0C8A94A553C8EF66C7','20180110160518','299','JSAPI','4200000064201801101502542508'),(643,'wxc4978101b35a6f39',220,'ICBC_DEBIT','29900','CNY','Y','1489989602','okj2kovzk2lvb0hmu6dd0nxs5xuqz0dz','oySCywUnZDWcAM3c6--OMOdfIU-g','148998960220180115102342','SUCCESS','SUCCESS','58869DD81AEE001A73F7FDDD25EB33FB','20180115102401','29900','JSAPI','4200000060201801154266002743');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。