谷粒学院-数据库脚本
guli_edu
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.21-log : Database - guli_edu
*********************************************************************
*/
/*!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 */;
/*Table structure for table `edu_chapter` */
DROP TABLE IF EXISTS `edu_chapter`;
CREATE TABLE `edu_chapter` (
`id` char(19) NOT NULL COMMENT \'章节ID\',
`course_id` char(19) NOT NULL COMMENT \'课程ID\',
`title` varchar(50) NOT NULL COMMENT \'章节名称\',
`sort` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'显示排序\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_course_id` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=\'课程\';
/*Data for the table `edu_chapter` */
/*Table structure for table `edu_comment` */
DROP TABLE IF EXISTS `edu_comment`;
CREATE TABLE `edu_comment` (
`id` char(19) NOT NULL COMMENT \'讲师ID\',
`course_id` char(19) NOT NULL DEFAULT \'\' COMMENT \'课程id\',
`teacher_id` char(19) NOT NULL DEFAULT \'\' COMMENT \'讲师id\',
`member_id` char(19) NOT NULL DEFAULT \'\' COMMENT \'会员id\',
`nickname` varchar(50) DEFAULT NULL COMMENT \'会员昵称\',
`avatar` varchar(255) DEFAULT NULL COMMENT \'会员头像\',
`content` varchar(500) DEFAULT NULL COMMENT \'评论内容\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_course_id` (`course_id`),
KEY `idx_teacher_id` (`teacher_id`),
KEY `idx_member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'评论\';
/*Data for the table `edu_comment` */
/*Table structure for table `edu_course` */
DROP TABLE IF EXISTS `edu_course`;
CREATE TABLE `edu_course` (
`id` char(19) NOT NULL COMMENT \'课程ID\',
`teacher_id` char(19) NOT NULL COMMENT \'课程讲师ID\',
`subject_id` char(19) NOT NULL COMMENT \'课程专业ID\',
`subject_parent_id` char(19) NOT NULL COMMENT \'课程专业父级ID\',
`title` varchar(50) NOT NULL COMMENT \'课程标题\',
`price` decimal(10,2) unsigned NOT NULL DEFAULT \'0.00\' COMMENT \'课程销售价格，设置为0则可免费观看\',
`lesson_num` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'总课时\',
`cover` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT \'课程封面图片路径\',
`buy_count` bigint(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'销售数量\',
`view_count` bigint(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'浏览数量\',
`version` bigint(20) unsigned NOT NULL DEFAULT \'1\' COMMENT \'乐观锁\',
`status` varchar(10) NOT NULL DEFAULT \'Draft\' COMMENT \'课程状态 Draft未发布 Normal已发布\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_title` (`title`),
KEY `idx_subject_id` (`subject_id`),
KEY `idx_teacher_id` (`teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=\'课程\';
/*Data for the table `edu_course` */
/*Table structure for table `edu_course_collect` */
DROP TABLE IF EXISTS `edu_course_collect`;
CREATE TABLE `edu_course_collect` (
`id` char(19) NOT NULL COMMENT \'收藏ID\',
`course_id` char(19) NOT NULL COMMENT \'课程讲师ID\',
`member_id` char(19) NOT NULL DEFAULT \'\' COMMENT \'课程专业ID\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=\'课程收藏\';
/*Data for the table `edu_course_collect` */
/*Table structure for table `edu_course_description` */
DROP TABLE IF EXISTS `edu_course_description`;
CREATE TABLE `edu_course_description` (
`id` char(19) NOT NULL COMMENT \'课程ID\',
`description` text COMMENT \'课程简介\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'课程简介\';
/*Data for the table `edu_course_description` */
/*Table structure for table `edu_subject` */
DROP TABLE IF EXISTS `edu_subject`;
CREATE TABLE `edu_subject` (
`id` char(19) NOT NULL COMMENT \'课程类别ID\',
`title` varchar(10) NOT NULL COMMENT \'类别名称\',
`parent_id` char(19) NOT NULL DEFAULT \'0\' COMMENT \'父ID\',
`sort` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'排序字段\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=\'课程科目\';
/*Data for the table `edu_subject` */
/*Table structure for table `edu_teacher` */
DROP TABLE IF EXISTS `edu_teacher`;
CREATE TABLE `edu_teacher` (
`id` char(19) NOT NULL COMMENT \'讲师ID\',
`name` varchar(20) NOT NULL COMMENT \'讲师姓名\',
`intro` varchar(500) NOT NULL DEFAULT \'\' COMMENT \'讲师简介\',
`career` varchar(500) DEFAULT NULL COMMENT \'讲师资历,一句话说明讲师\',
`level` int(10) unsigned NOT NULL COMMENT \'头衔 1高级讲师 2首席讲师\',
`avatar` varchar(255) DEFAULT NULL COMMENT \'讲师头像\',
`sort` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'排序\',
`join_date` date DEFAULT NULL COMMENT \'入驻时间\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'讲师\';
/*Data for the table `edu_teacher` */
insert into `edu_teacher`(`id`,`name`,`intro`,`career`,`level`,`avatar`,`sort`,`join_date`,`is_deleted`,`gmt_create`,`gmt_modified`) values (\'1\',\'刘德华\',\'毕业于师范大学数学系，热爱教育事业，执教数学思维6年有余\',\'具备深厚的数学思维功底、丰富的小学教育经验，授课风格生动活泼，擅长用形象生动的比喻帮助理解、简单易懂的语言讲解难题，深受学生喜欢\',2,\'https://online-teach-file-helen.oss-cn-beijing.aliyuncs.com/avatar/2019/11/25/03.jpg\',10,\'2019-10-29\',0,\'2018-03-30 17:15:57\',\'2019-04-28 05:02:18\'),(\'10\',\'唐嫣\',\'北京师范大学法学院副教授\',\'北京师范大学法学院副教授、清华大学法学博士。自2004年至今已有9年的司法考试培训经验。长期从事司法考试辅导，深知命题规律，了解解题技巧。内容把握准确，授课重点明确，层次分明，调理清晰，将法条法理与案例有机融合，强调综合，深入浅出。\',1,\'http://guli-file.oss-cn-beijing.aliyuncs.com/avatar/2019/02/27/073eb5d2-f5f4-488a-82ed-aec8a5289a5d.png\',20,\'2019-10-29\',0,\'2018-04-03 14:32:19\',\'2019-02-22 02:01:26\'),(\'2\',\'周润发\',\'中国人民大学附属中学数学一级教师\',\'中国科学院数学与系统科学研究院应用数学专业博士，研究方向为数字图像处理，中国工业与应用数学学会会员。参与全国教育科学“十五”规划重点课题“信息化进程中的教育技术发展研究”的子课题“基与课程改革的资源开发与应用”，以及全国“十五”科研规划全国重点项目“掌上型信息技术产品在教学中的运用和开发研究”的子课题“用技术学数学”。\',2,\'https://guli-file-helen.oss-cn-beijing.aliyuncs.com/avatar/2020/04/14/f606ed5b-1d46-43a1-945c-3e1b3b58fc0a.jpg\',1,\'2019-10-28\',0,\'2018-03-30 18:28:26\',\'2020-04-14 17:40:36\'),(\'3\',\'钟汉良\',\'钟汉良钟汉良钟汉良钟汉良\',\'中教一级职称。讲课极具亲和力。\',1,\'http://guli-file.oss-cn-beijing.aliyuncs.com/avatar/2019/02/26/250bab5f-bbd6-49ab-80c3-7413ce806e83.jpg\',2,\'2019-10-29\',0,\'2018-03-31 09:20:46\',\'2019-02-22 02:01:27\'),(\'4\',\'周杰伦\',\'长期从事考研政治课讲授和考研命题趋势与应试对策研究。考研辅导新锐派的代表。\',\'政治学博士、管理学博士后，北京师范大学马克思主义学院副教授。多年来总结出了一套行之有效的应试技巧与答题方法，针对性和实用性极强，能帮助考生在轻松中应考，在激励的竞争中取得高分，脱颖而出。\',1,\'https://online-teach-file-helen.oss-cn-beijing.aliyuncs.com/avatar/2019/11/25/fee1e99f-8852-4da0-a256-9732e55bb608.jpg\',1,\'2019-10-27\',0,\'2018-04-03 14:13:51\',\'2019-10-29 19:52:46\'),(\'5\',\'陈伟霆\',\'人大附中2009届毕业生\',\'北京大学数学科学学院2008级本科生，2012年第八届学生五四奖章获得者，在数学领域取得多项国际国内奖项，学术研究成绩突出。曾被两次评为北京大学三好学生、一次评为北京大学三好标兵，获得过北京大学国家奖学金、北京大学廖凯原奖学金、北京大学星光国际一等奖学金、北京大学明德新生奖学金等。\',1,\'\',1,\'2019-10-29\',0,\'2018-04-03 14:15:36\',\'2019-02-22 02:01:29\'),(\'6\',\'姚晨\',\'华东师范大学数学系硕士生导师，中国数学奥林匹克高级教练\',\'曾参与北京市及全国多项数学活动的命题和组织工作，多次带领北京队参加高中、初中、小学的各项数学竞赛，均取得优异成绩。教学活而新，能够调动学生的学习兴趣并擅长对学生进行思维点拨，对学生学习习惯的养成和非智力因素培养有独到之处，是一位深受学生喜爱的老师。\',1,\'\',1,\'2019-10-29\',0,\'2018-04-01 14:19:28\',\'2019-02-22 02:01:29\'),(\'7\',\'胡歌\',\'考研政治辅导实战派专家，全国考研政治命题研究组核心成员。\',\'法学博士，北京师范大学马克思主义学院副教授，专攻毛概、*理论，长期从事考研辅导。出版著作两部，发表学术论文30余篇，主持国家社会科学基金项目和教育部重大课题子课题各一项，参与中央实施马克思主义理论研究和建设工程项目。\',2,\'\',8,\'2019-09-04\',0,\'2018-04-03 14:21:03\',\'2019-02-22 02:01:30\'),(\'8\',\'谢娜\',\'资深课程设计专家，专注10年AACTP美国培训协会认证导师\',\'十年课程研发和培训咨询经验，曾任国企人力资源经理、大型外企培训经理，负责企业大学和培训体系搭建；曾任专业培训机构高级顾问、研发部总监，为包括广东移动、东莞移动、深圳移动、南方电网、工商银行、农业银行、民生银行、邮储银行、TCL集团、清华大学继续教育学院、中天路桥、广西扬翔股份等超过200家企业提供过培训与咨询服务，并担任近50个大型项目的总负责人。\',1,\'\',10,\'2019-10-29\',0,\'2018-04-03 14:23:33\',\'2019-11-23 08:38:09\');
/*Table structure for table `edu_video` */
DROP TABLE IF EXISTS `edu_video`;
CREATE TABLE `edu_video` (
`id` char(19) NOT NULL COMMENT \'视频ID\',
`course_id` char(19) NOT NULL COMMENT \'课程ID\',
`chapter_id` char(19) NOT NULL COMMENT \'章节ID\',
`title` varchar(50) NOT NULL COMMENT \'节点名称\',
`video_source_id` varchar(100) DEFAULT NULL COMMENT \'云端视频资源\',
`video_original_name` varchar(100) DEFAULT NULL COMMENT \'原始文件名称\',
`sort` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'排序字段\',
`play_count` bigint(20) unsigned NOT NULL DEFAULT \'0\' COMMENT \'播放次数\',
`is_free` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'是否可以试听：0收费 1免费\',
`duration` float NOT NULL DEFAULT \'0\' COMMENT \'视频时长（秒）\',
`status` varchar(20) NOT NULL DEFAULT \'Empty\' COMMENT \'状态\',
`size` bigint(20) unsigned NOT NULL DEFAULT \'0\' COMMENT \'视频源文件大小（字节）\',
`version` bigint(20) unsigned NOT NULL DEFAULT \'1\' COMMENT \'乐观锁\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_course_id` (`course_id`),
KEY `idx_chapter_id` (`chapter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=\'课程视频\';
/*Data for the table `edu_video` */
/*!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 */;
guli_acl
# Host: localhost (Version 5.7.19)
# Date: 2019-11-18 15:49:15
# Generator: MySQL-Front 6.1 (Build 1.26)
#
# Structure for table "acl_permission"
#
CREATE TABLE `acl_permission` (
`id` char(19) NOT NULL DEFAULT \'\' COMMENT \'编号\',
`pid` char(19) NOT NULL DEFAULT \'\' COMMENT \'所属上级\',
`name` varchar(20) NOT NULL DEFAULT \'\' COMMENT \'名称\',
`type` tinyint(3) NOT NULL DEFAULT \'0\' COMMENT \'类型(1:菜单,2:按钮)\',
`permission_value` varchar(50) DEFAULT NULL COMMENT \'权限值\',
`path` varchar(100) DEFAULT NULL COMMENT \'访问路径\',
`component` varchar(100) DEFAULT NULL COMMENT \'组件路径\',
`icon` varchar(50) DEFAULT NULL COMMENT \'图标\',
`status` tinyint(4) DEFAULT NULL COMMENT \'状态(0:禁止,1:正常)\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime DEFAULT NULL COMMENT \'创建时间\',
`gmt_modified` datetime DEFAULT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'权限\';
#
# Data for table "acl_permission"
#
INSERT INTO `acl_permission` VALUES (\'1\',\'0\',\'全部数据\',0,NULL,NULL,NULL,NULL,NULL,0,\'2019-11-15 17:13:06\',\'2019-11-15 17:13:06\'),(\'1195268474480156673\',\'1\',\'权限管理\',1,NULL,\'/acl\',\'Layout\',NULL,NULL,0,\'2019-11-15 17:13:06\',\'2019-11-18 13:54:25\'),(\'1195268616021139457\',\'1195268474480156673\',\'用户管理\',1,NULL,\'user/list\',\'/acl/user/list\',NULL,NULL,0,\'2019-11-15 17:13:40\',\'2019-11-18 13:53:12\'),(\'1195268788138598401\',\'1195268474480156673\',\'角色管理\',1,NULL,\'role/list\',\'/acl/role/list\',NULL,NULL,0,\'2019-11-15 17:14:21\',\'2019-11-15 17:14:21\'),(\'1195268893830864898\',\'1195268474480156673\',\'菜单管理\',1,NULL,\'menu/list\',\'/acl/menu/list\',NULL,NULL,0,\'2019-11-15 17:14:46\',\'2019-11-15 17:14:46\'),(\'1195269143060602882\',\'1195268616021139457\',\'查看\',2,\'user.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:15:45\',\'2019-11-17 21:57:16\'),(\'1195269295926206466\',\'1195268616021139457\',\'添加\',2,\'user.add\',\'user/add\',\'/acl/user/form\',NULL,NULL,0,\'2019-11-15 17:16:22\',\'2019-11-15 17:16:22\'),(\'1195269473479483394\',\'1195268616021139457\',\'修改\',2,\'user.update\',\'user/update/:id\',\'/acl/user/form\',NULL,NULL,0,\'2019-11-15 17:17:04\',\'2019-11-15 17:17:04\'),(\'1195269547269873666\',\'1195268616021139457\',\'删除\',2,\'user.remove\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:17:22\',\'2019-11-15 17:17:22\'),(\'1195269821262782465\',\'1195268788138598401\',\'修改\',2,\'role.update\',\'role/update/:id\',\'/acl/role/form\',NULL,NULL,0,\'2019-11-15 17:18:27\',\'2019-11-15 17:19:53\'),(\'1195269903542444034\',\'1195268788138598401\',\'查看\',2,\'role.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:18:47\',\'2019-11-15 17:18:47\'),(\'1195270037005197313\',\'1195268788138598401\',\'添加\',2,\'role.add\',\'role/add\',\'/acl/role/form\',NULL,NULL,0,\'2019-11-15 17:19:19\',\'2019-11-18 11:05:42\'),(\'1195270442602782721\',\'1195268788138598401\',\'删除\',2,\'role.remove\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:20:55\',\'2019-11-15 17:20:55\'),(\'1195270621548568578\',\'1195268788138598401\',\'角色权限\',2,\'role.acl\',\'role/distribution/:id\',\'/acl/role/roleForm\',NULL,NULL,0,\'2019-11-15 17:21:38\',\'2019-11-15 17:21:38\'),(\'1195270744097742849\',\'1195268893830864898\',\'查看\',2,\'permission.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:22:07\',\'2019-11-15 17:22:07\'),(\'1195270810560684034\',\'1195268893830864898\',\'添加\',2,\'permission.add\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:22:23\',\'2019-11-15 17:22:23\'),(\'1195270862100291586\',\'1195268893830864898\',\'修改\',2,\'permission.update\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:22:35\',\'2019-11-15 17:22:35\'),(\'1195270887933009922\',\'1195268893830864898\',\'删除\',2,\'permission.remove\',\'\',\'\',NULL,NULL,0,\'2019-11-15 17:22:41\',\'2019-11-15 17:22:41\'),(\'1195349439240048642\',\'1\',\'讲师管理\',1,NULL,\'/edu/teacher\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:34:49\',\'2019-11-15 22:34:49\'),(\'1195349699995734017\',\'1195349439240048642\',\'讲师列表\',1,NULL,\'list\',\'/edu/teacher/list\',NULL,NULL,0,\'2019-11-15 22:35:52\',\'2019-11-15 22:35:52\'),(\'1195349810561781761\',\'1195349439240048642\',\'添加讲师\',1,NULL,\'create\',\'/edu/teacher/form\',NULL,NULL,0,\'2019-11-15 22:36:18\',\'2019-11-15 22:36:18\'),(\'1195349876252971010\',\'1195349810561781761\',\'添加\',2,\'teacher.add\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:36:34\',\'2019-11-15 22:36:34\'),(\'1195349979797753857\',\'1195349699995734017\',\'查看\',2,\'teacher.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:36:58\',\'2019-11-15 22:36:58\'),(\'1195350117270261762\',\'1195349699995734017\',\'修改\',2,\'teacher.update\',\'edit/:id\',\'/edu/teacher/form\',NULL,NULL,0,\'2019-11-15 22:37:31\',\'2019-11-15 22:37:31\'),(\'1195350188359520258\',\'1195349699995734017\',\'删除\',2,\'teacher.remove\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:37:48\',\'2019-11-15 22:37:48\'),(\'1195350299365969922\',\'1\',\'课程分类\',1,NULL,\'/edu/subject\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:38:15\',\'2019-11-15 22:38:15\'),(\'1195350397751758850\',\'1195350299365969922\',\'课程分类列表\',1,NULL,\'list\',\'/edu/subject/list\',NULL,NULL,0,\'2019-11-15 22:38:38\',\'2019-11-15 22:38:38\'),(\'1195350500512206850\',\'1195350299365969922\',\'导入课程分类\',1,NULL,\'import\',\'/edu/subject/import\',NULL,NULL,0,\'2019-11-15 22:39:03\',\'2019-11-15 22:39:03\'),(\'1195350612172967938\',\'1195350397751758850\',\'查看\',2,\'subject.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:39:29\',\'2019-11-15 22:39:29\'),(\'1195350687590748161\',\'1195350500512206850\',\'导入\',2,\'subject.import\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:39:47\',\'2019-11-15 22:39:47\'),(\'1195350831744782337\',\'1\',\'课程管理\',1,NULL,\'/edu/course\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:40:21\',\'2019-11-15 22:40:21\'),(\'1195350919074385921\',\'1195350831744782337\',\'课程列表\',1,NULL,\'list\',\'/edu/course/list\',NULL,NULL,0,\'2019-11-15 22:40:42\',\'2019-11-15 22:40:42\'),(\'1195351020463296513\',\'1195350831744782337\',\'发布课程\',1,NULL,\'info\',\'/edu/course/info\',NULL,NULL,0,\'2019-11-15 22:41:06\',\'2019-11-15 22:41:06\'),(\'1195351159672246274\',\'1195350919074385921\',\'完成发布\',2,\'course.publish\',\'publish/:id\',\'/edu/course/publish\',NULL,NULL,0,\'2019-11-15 22:41:40\',\'2019-11-15 22:44:01\'),(\'1195351326706208770\',\'1195350919074385921\',\'编辑课程\',2,\'course.update\',\'info/:id\',\'/edu/course/info\',NULL,NULL,0,\'2019-11-15 22:42:19\',\'2019-11-15 22:42:19\'),(\'1195351566221938690\',\'1195350919074385921\',\'编辑课程大纲\',2,\'chapter.update\',\'chapter/:id\',\'/edu/course/chapter\',NULL,NULL,0,\'2019-11-15 22:43:17\',\'2019-11-15 22:43:17\'),(\'1195351862889254913\',\'1\',\'统计分析\',1,NULL,\'/statistics/daily\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:44:27\',\'2019-11-15 22:44:27\'),(\'1195351968841568257\',\'1195351862889254913\',\'生成统计\',1,NULL,\'create\',\'/statistics/daily/create\',NULL,NULL,0,\'2019-11-15 22:44:53\',\'2019-11-15 22:44:53\'),(\'1195352054917074946\',\'1195351862889254913\',\'统计图表\',1,NULL,\'chart\',\'/statistics/daily/chart\',NULL,NULL,0,\'2019-11-15 22:45:13\',\'2019-11-15 22:45:13\'),(\'1195352127734386690\',\'1195352054917074946\',\'查看\',2,\'daily.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:45:30\',\'2019-11-15 22:45:30\'),(\'1195352215768633346\',\'1195351968841568257\',\'生成\',2,\'daily.add\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:45:51\',\'2019-11-15 22:45:51\'),(\'1195352547621965825\',\'1\',\'CMS管理\',1,NULL,\'/cms\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:47:11\',\'2019-11-18 10:51:46\'),(\'1195352856645701633\',\'1195353513549205505\',\'查看\',2,\'banner.list\',\'\',NULL,NULL,NULL,0,\'2019-11-15 22:48:24\',\'2019-11-15 22:48:24\'),(\'1195352909401657346\',\'1195353513549205505\',\'添加\',2,\'banner.add\',\'banner/add\',\'/cms/banner/form\',NULL,NULL,0,\'2019-11-15 22:48:37\',\'2019-11-18 10:52:10\'),(\'1195353051395624961\',\'1195353513549205505\',\'修改\',2,\'banner.update\',\'banner/update/:id\',\'/cms/banner/form\',NULL,NULL,0,\'2019-11-15 22:49:11\',\'2019-11-18 10:52:05\'),(\'1195353513549205505\',\'1195352547621965825\',\'Bander列表\',1,NULL,\'banner/list\',\'/cms/banner/list\',NULL,NULL,0,\'2019-11-15 22:51:01\',\'2019-11-18 10:51:29\'),(\'1195353672110673921\',\'1195353513549205505\',\'删除\',2,\'banner.remove\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:51:39\',\'2019-11-15 22:51:39\'),(\'1195354076890370050\',\'1\',\'订单管理\',1,NULL,\'/order\',\'Layout\',NULL,NULL,0,\'2019-11-15 22:53:15\',\'2019-11-15 22:53:15\'),(\'1195354153482555393\',\'1195354076890370050\',\'订单列表\',1,NULL,\'list\',\'/order/list\',NULL,NULL,0,\'2019-11-15 22:53:33\',\'2019-11-15 22:53:58\'),(\'1195354315093282817\',\'1195354153482555393\',\'查看\',2,\'order.list\',\'\',\'\',NULL,NULL,0,\'2019-11-15 22:54:12\',\'2019-11-15 22:54:12\'),(\'1196301740985311234\',\'1195268616021139457\',\'分配角色\',2,\'user.assgin\',\'user/role/:id\',\'/acl/user/roleForm\',NULL,NULL,0,\'2019-11-18 13:38:56\',\'2019-11-18 13:38:56\');
#
# Structure for table "acl_role"
#
CREATE TABLE `acl_role` (
`id` char(19) NOT NULL DEFAULT \'\' COMMENT \'角色id\',
`role_name` varchar(20) NOT NULL DEFAULT \'\' COMMENT \'角色名称\',
`role_code` varchar(20) DEFAULT NULL COMMENT \'角色编码\',
`remark` varchar(255) DEFAULT NULL COMMENT \'备注\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "acl_role"
#
INSERT INTO `acl_role` VALUES (\'1\',\'普通管理员\',NULL,NULL,0,\'2019-11-11 13:09:32\',\'2019-11-18 10:27:18\'),(\'1193757683205607426\',\'课程管理员\',NULL,NULL,0,\'2019-11-11 13:09:45\',\'2019-11-18 10:25:44\'),(\'1196300996034977794\',\'test\',NULL,NULL,0,\'2019-11-18 13:35:58\',\'2019-11-18 13:35:58\');
#
# Structure for table "acl_role_permission"
#
CREATE TABLE `acl_role_permission` (
`id` char(19) NOT NULL DEFAULT \'\',
`role_id` char(19) NOT NULL DEFAULT \'\',
`permission_id` char(19) NOT NULL DEFAULT \'\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_permission_id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'角色权限\';
#
# Data for table "acl_role_permission"
#
INSERT INTO `acl_role_permission` VALUES (\'1196301979754455041\',\'1\',\'1\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979792203778\',\'1\',\'1195268474480156673\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979821563906\',\'1\',\'1195268616021139457\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979842535426\',\'1\',\'1195269143060602882\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979855118338\',\'1\',\'1195269295926206466\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979880284161\',\'1\',\'1195269473479483394\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979913838593\',\'1\',\'1195269547269873666\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979926421506\',\'1\',\'1196301740985311234\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301979951587330\',\'1\',\'1195268788138598401\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980014501889\',\'1\',\'1195269821262782465\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980035473410\',\'1\',\'1195269903542444034\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980052250626\',\'1\',\'1195270037005197313\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980077416450\',\'1\',\'1195270442602782721\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980094193665\',\'1\',\'1195270621548568578\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980119359489\',\'1\',\'1195268893830864898\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980136136706\',\'1\',\'1195270744097742849\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980249382913\',\'1\',\'1195270810560684034\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980270354434\',\'1\',\'1195270862100291586\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980287131649\',\'1\',\'1195270887933009922\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980303908866\',\'1\',\'1195349439240048642\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980320686082\',\'1\',\'1195349699995734017\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980345851905\',\'1\',\'1195349979797753857\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980362629121\',\'1\',\'1195350117270261762\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980383600641\',\'1\',\'1195350188359520258\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980408766465\',\'1\',\'1195349810561781761\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980421349378\',\'1\',\'1195349876252971010\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980438126593\',\'1\',\'1195350299365969922\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980450709506\',\'1\',\'1195350397751758850\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980501041153\',\'1\',\'1195350612172967938\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980517818370\',\'1\',\'1195350500512206850\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980538789889\',\'1\',\'1195350687590748161\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980622675970\',\'1\',\'1195350831744782337\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980639453186\',\'1\',\'1195350919074385921\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980660424705\',\'1\',\'1195351159672246274\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980677201922\',\'1\',\'1195351326706208770\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980698173441\',\'1\',\'1195351566221938690\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980714950658\',\'1\',\'1195351020463296513\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980723339266\',\'1\',\'1195351862889254913\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980744310786\',\'1\',\'1195351968841568257\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980761088001\',\'1\',\'1195352215768633346\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980777865217\',\'1\',\'1195352054917074946\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980794642434\',\'1\',\'1195352127734386690\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980811419650\',\'1\',\'1195352547621965825\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980828196865\',\'1\',\'1195353513549205505\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980844974082\',\'1\',\'1195352856645701633\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980861751298\',\'1\',\'1195352909401657346\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980886917122\',\'1\',\'1195353051395624961\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980928860162\',\'1\',\'1195353672110673921\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980954025986\',\'1\',\'1195354076890370050\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980970803201\',\'1\',\'1195354153482555393\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196301980987580418\',\'1\',\'1195354315093282817\',1,\'2019-11-18 13:39:53\',\'2019-11-18 13:39:53\'),(\'1196305293070077953\',\'1\',\'1\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293099438081\',\'1\',\'1195268474480156673\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293120409602\',\'1\',\'1195268616021139457\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293153964034\',\'1\',\'1195269143060602882\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293183324162\',\'1\',\'1195269295926206466\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293212684290\',\'1\',\'1195269473479483394\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293237850114\',\'1\',\'1195269547269873666\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293271404545\',\'1\',\'1196301740985311234\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293485314049\',\'1\',\'1195268788138598401\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293506285569\',\'1\',\'1195269821262782465\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293527257089\',\'1\',\'1195269903542444034\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293552422914\',\'1\',\'1195270037005197313\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293565005825\',\'1\',\'1195270442602782721\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293594365954\',\'1\',\'1195270621548568578\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293611143169\',\'1\',\'1195268893830864898\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293627920385\',\'1\',\'1195270744097742849\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293657280513\',\'1\',\'1195349439240048642\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293674057729\',\'1\',\'1195349699995734017\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293690834946\',\'1\',\'1195349979797753857\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293716000770\',\'1\',\'1195350117270261762\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293736972290\',\'1\',\'1195350188359520258\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293749555202\',\'1\',\'1195349810561781761\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293766332417\',\'1\',\'1195349876252971010\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293795692546\',\'1\',\'1195350299365969922\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293812469762\',\'1\',\'1195350397751758850\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293837635586\',\'1\',\'1195350612172967938\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293858607106\',\'1\',\'1195350500512206850\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293875384322\',\'1\',\'1195350687590748161\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293892161538\',\'1\',\'1195350831744782337\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293950881794\',\'1\',\'1195350919074385921\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305293976047617\',\'1\',\'1195351159672246274\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294127042561\',\'1\',\'1195351326706208770\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294156402690\',\'1\',\'1195351566221938690\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294177374209\',\'1\',\'1195351862889254913\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294194151425\',\'1\',\'1195351968841568257\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294223511554\',\'1\',\'1195352215768633346\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294240288770\',\'1\',\'1195352054917074946\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294248677377\',\'1\',\'1195352127734386690\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294248677378\',\'1\',\'1195352547621965825\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294319980546\',\'1\',\'1195353513549205505\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294319980547\',\'1\',\'1195352856645701633\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294319980548\',\'1\',\'1195352909401657346\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294378700802\',\'1\',\'1195353051395624961\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294378700803\',\'1\',\'1195353672110673921\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294458392577\',\'1\',\'1195354076890370050\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294483558402\',\'1\',\'1195354153482555393\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305294500335618\',\'1\',\'1195354315093282817\',1,\'2019-11-18 13:53:03\',\'2019-11-18 13:53:03\'),(\'1196305566656139266\',\'1\',\'1\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566689693698\',\'1\',\'1195268474480156673\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566706470913\',\'1\',\'1195268616021139457\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566740025346\',\'1\',\'1195269143060602882\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566756802561\',\'1\',\'1195269295926206466\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566781968385\',\'1\',\'1195269473479483394\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566811328514\',\'1\',\'1195269547269873666\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566828105730\',\'1\',\'1196301740985311234\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566853271554\',\'1\',\'1195268788138598401\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566878437378\',\'1\',\'1195269821262782465\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566895214593\',\'1\',\'1195269903542444034\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566916186113\',\'1\',\'1195270037005197313\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566949740546\',\'1\',\'1195270442602782721\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566966517761\',\'1\',\'1195270621548568578\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305566991683585\',\'1\',\'1195268893830864898\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567012655106\',\'1\',\'1195270744097742849\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567029432322\',\'1\',\'1195270810560684034\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567042015233\',\'1\',\'1195270862100291586\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567100735490\',\'1\',\'1195270887933009922\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567117512705\',\'1\',\'1195349439240048642\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567142678530\',\'1\',\'1195349699995734017\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567155261442\',\'1\',\'1195349979797753857\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567172038658\',\'1\',\'1195350117270261762\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567188815873\',\'1\',\'1195350188359520258\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567218176001\',\'1\',\'1195349810561781761\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567234953217\',\'1\',\'1195349876252971010\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567251730434\',\'1\',\'1195350299365969922\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567272701954\',\'1\',\'1195350397751758850\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567289479170\',\'1\',\'1195350612172967938\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567310450690\',\'1\',\'1195350500512206850\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567327227905\',\'1\',\'1195350687590748161\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567448862722\',\'1\',\'1195350831744782337\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567478222850\',\'1\',\'1195350919074385921\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567495000065\',\'1\',\'1195351159672246274\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567520165889\',\'1\',\'1195351326706208770\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567541137409\',\'1\',\'1195351566221938690\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567570497538\',\'1\',\'1195351862889254913\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567587274754\',\'1\',\'1195351968841568257\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567604051970\',\'1\',\'1195352215768633346\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567633412098\',\'1\',\'1195352054917074946\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567683743745\',\'1\',\'1195352127734386690\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567721492481\',\'1\',\'1195352547621965825\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567742464002\',\'1\',\'1195353513549205505\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567771824129\',\'1\',\'1195352856645701633\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567792795650\',\'1\',\'1195352909401657346\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567809572866\',\'1\',\'1195353051395624961\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567843127298\',\'1\',\'1195353672110673921\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567868293122\',\'1\',\'1195354076890370050\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567885070338\',\'1\',\'1195354153482555393\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196305567910236162\',\'1\',\'1195354315093282817\',1,\'2019-11-18 13:54:08\',\'2019-11-18 13:54:08\'),(\'1196312702601695234\',\'1\',\'1\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702652026881\',\'1\',\'1195268474480156673\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702668804098\',\'1\',\'1195268616021139457\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702698164226\',\'1\',\'1195269143060602882\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702723330049\',\'1\',\'1195269295926206466\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702744301569\',\'1\',\'1195269473479483394\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702765273089\',\'1\',\'1195269547269873666\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702790438913\',\'1\',\'1196301740985311234\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702945628161\',\'1\',\'1195268788138598401\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312702970793985\',\'1\',\'1195269821262782465\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703000154114\',\'1\',\'1195269903542444034\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703025319938\',\'1\',\'1195270037005197313\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703046291458\',\'1\',\'1195270442602782721\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703063068673\',\'1\',\'1195270621548568578\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703084040193\',\'1\',\'1195268893830864898\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703113400321\',\'1\',\'1195270744097742849\',0,\'2019-11-18 14:22:29\',\'2019-11-18 14:22:29\'),(\'1196312703134371842\',\'1\',\'1195270810560684034\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703159537665\',\'1\',\'1195270862100291586\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703184703490\',\'1\',\'1195270887933009922\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703209869313\',\'1\',\'1195349439240048642\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703230840834\',\'1\',\'1195349699995734017\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703251812354\',\'1\',\'1195349979797753857\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703272783873\',\'1\',\'1195350117270261762\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703293755394\',\'1\',\'1195350188359520258\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703327309826\',\'1\',\'1195349810561781761\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703348281345\',\'1\',\'1195349876252971010\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703365058561\',\'1\',\'1195350299365969922\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703386030082\',\'1\',\'1195350397751758850\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703440556034\',\'1\',\'1195350612172967938\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703486693378\',\'1\',\'1195350500512206850\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703511859202\',\'1\',\'1195350687590748161\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703654465537\',\'1\',\'1195350831744782337\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703683825665\',\'1\',\'1195350919074385921\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703700602882\',\'1\',\'1195351159672246274\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703717380098\',\'1\',\'1195351326706208770\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703738351618\',\'1\',\'1195351566221938690\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703759323137\',\'1\',\'1195351020463296513\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703776100353\',\'1\',\'1195351862889254913\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703792877570\',\'1\',\'1195351968841568257\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703830626305\',\'1\',\'1195352215768633346\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703843209217\',\'1\',\'1195352054917074946\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703868375041\',\'1\',\'1195352127734386690\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703889346561\',\'1\',\'1195352547621965825\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703901929473\',\'1\',\'1195353513549205505\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703918706689\',\'1\',\'1195352856645701633\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703952261121\',\'1\',\'1195352909401657346\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703973232642\',\'1\',\'1195353051395624961\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312703990009857\',\'1\',\'1195353672110673921\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312704048730114\',\'1\',\'1195354076890370050\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312704069701633\',\'1\',\'1195354153482555393\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\'),(\'1196312704094867457\',\'1\',\'1195354315093282817\',0,\'2019-11-18 14:22:30\',\'2019-11-18 14:22:30\');
#
# Structure for table "acl_user"
#
CREATE TABLE `acl_user` (
`id` char(19) NOT NULL COMMENT \'会员id\',
`username` varchar(20) NOT NULL DEFAULT \'\' COMMENT \'微信openid\',
`password` varchar(32) NOT NULL DEFAULT \'\' COMMENT \'密码\',
`nick_name` varchar(50) DEFAULT NULL COMMENT \'昵称\',
`salt` varchar(255) DEFAULT NULL COMMENT \'用户头像\',
`token` varchar(100) DEFAULT NULL COMMENT \'用户签名\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'用户表\';
#
# Data for table "acl_user"
#
INSERT INTO `acl_user` VALUES (\'1\',\'admin\',\'96e79218965eb72c92a549dd5a330112\',\'admin\',\'\',NULL,0,\'2019-11-01 10:39:47\',\'2019-11-01 10:39:47\'),(\'2\',\'test\',\'96e79218965eb72c92a549dd5a330112\',\'test\',NULL,NULL,0,\'2019-11-01 16:36:07\',\'2019-11-01 16:40:08\');
#
# Structure for table "acl_user_role"
#
CREATE TABLE `acl_user_role` (
`id` char(19) NOT NULL DEFAULT \'\' COMMENT \'主键id\',
`role_id` char(19) NOT NULL DEFAULT \'0\' COMMENT \'角色id\',
`user_id` char(19) NOT NULL DEFAULT \'0\' COMMENT \'用户id\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Data for table "acl_user_role"
#
INSERT INTO `acl_user_role` VALUES (\'1\',\'1\',\'2\',0,\'2019-11-11 13:09:53\',\'2019-11-11 13:09:53\');
guli_cms
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.21-log : Database - dbhelen_guli_cms
*********************************************************************
*/
/*!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 */;
/*Table structure for table `cms_ad` */
CREATE TABLE `cms_ad` (
`id` char(19) NOT NULL DEFAULT \'\' COMMENT \'ID\',
`title` varchar(20) DEFAULT \'\' COMMENT \'标题\',
`type_id` char(19) NOT NULL COMMENT \'类型ID\',
`image_url` varchar(500) NOT NULL DEFAULT \'\' COMMENT \'图片地址\',
`color` varchar(10) DEFAULT NULL COMMENT \'背景颜色\',
`link_url` varchar(500) DEFAULT \'\' COMMENT \'链接地址\',
`sort` int(10) unsigned NOT NULL DEFAULT \'0\' COMMENT \'排序\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_name` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'广告推荐\';
/*Table structure for table `cms_ad_type` */
CREATE TABLE `cms_ad_type` (
`id` char(19) NOT NULL COMMENT \'ID\',
`title` varchar(20) NOT NULL COMMENT \'标题\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'推荐位\';
/*!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 */;
guli_order
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.21-log : Database - dbhelen_guli_trade
*********************************************************************
*/
/*!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 */;
/*Table structure for table `trade_order` */
CREATE TABLE `trade_order` (
`id` char(19) NOT NULL DEFAULT \'\',
`order_no` varchar(20) NOT NULL DEFAULT \'\' COMMENT \'订单号\',
`course_id` varchar(19) NOT NULL DEFAULT \'\' COMMENT \'课程id\',
`course_title` varchar(100) DEFAULT NULL COMMENT \'课程名称\',
`course_cover` varchar(255) DEFAULT NULL COMMENT \'课程封面\',
`teacher_name` varchar(20) DEFAULT NULL COMMENT \'讲师名称\',
`member_id` varchar(19) NOT NULL DEFAULT \'\' COMMENT \'会员id\',
`nickname` varchar(50) DEFAULT NULL COMMENT \'会员昵称\',
`mobile` varchar(11) DEFAULT NULL COMMENT \'会员手机\',
`total_fee` decimal(20,2) DEFAULT NULL COMMENT \'订单金额（分）\',
`pay_type` tinyint(3) DEFAULT NULL COMMENT \'支付类型（1：微信 2：支付宝）\',
`status` tinyint(3) DEFAULT NULL COMMENT \'订单状态（0：未支付 1：已支付）\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
UNIQUE KEY `ux_order_no` (`order_no`),
KEY `idx_course_id` (`course_id`),
KEY `idx_member_id` (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'订单\';
/*Table structure for table `trade_pay_log` */
CREATE TABLE `trade_pay_log` (
`id` char(19) NOT NULL DEFAULT \'\',
`order_no` varchar(20) NOT NULL DEFAULT \'\' COMMENT \'订单号\',
`pay_time` datetime DEFAULT NULL COMMENT \'支付完成时间\',
`total_fee` bigint(20) DEFAULT NULL COMMENT \'支付金额（分）\',
`transaction_id` varchar(30) DEFAULT NULL COMMENT \'交易流水号\',
`trade_state` char(20) DEFAULT NULL COMMENT \'交易状态\',
`pay_type` tinyint(3) NOT NULL DEFAULT \'0\' COMMENT \'支付类型（1：微信 2：支付宝）\',
`attr` text COMMENT \'其他属性\',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_order_no` (`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'支付日志表\';
/*!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 */;
guli_statistics
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.21-log : Database - guli_statistics
*********************************************************************
*/
/*!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 */;
/*Table structure for table `statistics_daily` */
DROP TABLE IF EXISTS `statistics_daily`;
CREATE TABLE `statistics_daily` (
`id` char(19) NOT NULL COMMENT \'主键\',
`date_calculated` varchar(20) NOT NULL COMMENT \'统计日期\',
`register_num` int(11) NOT NULL DEFAULT \'0\' COMMENT \'注册人数\',
`login_num` int(11) NOT NULL DEFAULT \'0\' COMMENT \'登录人数\',
`video_view_num` int(11) NOT NULL DEFAULT \'0\' COMMENT \'每日播放视频数\',
`course_num` int(11) NOT NULL DEFAULT \'0\' COMMENT \'每日新增课程数\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`),
KEY `statistics_day` (`date_calculated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'网站统计日数据\';
/*Data for the table `statistics_daily` */
insert into `statistics_daily`(`id`,`date_calculated`,`register_num`,`login_num`,`video_view_num`,`course_num`,`gmt_create`,`gmt_modified`) values (\'1078490017163833345\',\'2018-12-28\',0,0,154,170,\'2018-12-28 11:17:12\',\'2019-09-09 12:12:12\'),(\'1087142127818768386\',\'2019-01-02\',2,0,167,177,\'2019-01-21 08:17:36\',\'2019-09-09 12:12:12\'),(\'1087198383973236738\',\'2019-01-03\',0,0,114,130,\'2019-01-21 12:01:09\',\'2019-09-09 12:12:12\'),(\'1087451681764982785\',\'2019-01-04\',0,0,118,155,\'2019-01-22 04:47:39\',\'2019-09-09 12:12:12\'),(\'1087455336471785473\',\'2019-01-05\',0,0,184,186,\'2019-01-22 05:02:11\',\'2019-09-09 12:12:12\'),(\'1105339962460491777\',\'2019-03-01\',0,143,168,136,\'2019-03-12 13:29:18\',\'2019-03-12 13:29:18\'),(\'1105339977027309569\',\'2019-03-02\',0,165,171,158,\'2019-03-12 13:29:21\',\'2019-03-12 13:29:21\'),(\'1105339990738489346\',\'2019-03-03\',0,143,147,194,\'2019-03-12 13:29:25\',\'2019-03-12 13:29:25\'),(\'1105340000544772098\',\'2019-03-04\',0,155,106,153,\'2019-03-12 13:29:27\',\'2019-03-12 13:29:27\'),(\'1105340011244441602\',\'2019-03-05\',0,186,102,155,\'2019-03-12 13:29:30\',\'2019-03-12 13:29:30\'),(\'1105340020929089538\',\'2019-03-06\',0,140,192,129,\'2019-03-12 13:29:32\',\'2019-03-12 13:29:32\'),(\'1105340029800042497\',\'2019-03-07\',0,186,139,116,\'2019-03-12 13:29:34\',\'2019-03-12 13:29:34\'),(\'1105340038696161282\',\'2019-03-08\',0,120,166,112,\'2019-03-12 13:29:36\',\'2019-03-12 13:29:36\'),(\'1105340049441968129\',\'2019-03-09\',0,182,147,119,\'2019-03-12 13:29:39\',\'2019-03-12 13:29:39\'),(\'1105340059738984449\',\'2019-03-10\',0,199,141,103,\'2019-03-12 13:29:41\',\'2019-03-12 13:29:41\'),(\'1105340070438653953\',\'2019-03-11\',0,127,137,156,\'2019-03-12 13:29:44\',\'2019-03-12 13:29:44\'),(\'1105340080307851266\',\'2019-03-12\',0,167,123,132,\'2019-03-12 13:29:46\',\'2019-03-12 13:29:46\'),(\'1105340090047025153\',\'2019-03-13\',0,106,132,103,\'2019-03-12 13:29:48\',\'2019-03-12 13:29:48\'),(\'1105340100075606017\',\'2019-03-14\',0,166,180,118,\'2019-03-12 13:29:51\',\'2019-03-12 13:29:51\'),(\'1105340110511034370\',\'2019-03-15\',0,114,151,185,\'2019-03-12 13:29:53\',\'2019-03-12 13:29:53\'),(\'1105340121412030466\',\'2019-03-16\',0,134,105,126,\'2019-03-12 13:29:56\',\'2019-03-12 13:29:56\'),(\'1105340132833120258\',\'2019-03-17\',0,169,106,131,\'2019-03-12 13:29:59\',\'2019-03-12 13:29:59\'),(\'1105340145659301890\',\'2019-03-18\',0,120,106,163,\'2019-03-12 13:30:02\',\'2019-03-12 13:30:02\'),(\'1105340153578147842\',\'2019-03-19\',0,146,155,153,\'2019-03-12 13:30:03\',\'2019-03-12 13:30:03\'),(\'1105340162436517890\',\'2019-03-20\',0,127,181,186,\'2019-03-12 13:30:06\',\'2019-03-12 13:30:06\'),(\'1105340171517186050\',\'2019-03-21\',0,106,134,145,\'2019-03-12 13:30:08\',\'2019-03-12 13:30:08\'),(\'1105340181034061825\',\'2019-03-22\',0,161,182,143,\'2019-03-12 13:30:10\',\'2019-03-12 13:30:10\'),(\'1105340190072786946\',\'2019-03-23\',0,183,101,182,\'2019-03-12 13:30:12\',\'2019-03-12 13:30:12\'),(\'1105340199426084865\',\'2019-03-24\',0,117,100,102,\'2019-03-12 13:30:14\',\'2019-03-12 13:30:14\'),(\'1105340209261727745\',\'2019-03-25\',0,116,103,160,\'2019-03-12 13:30:17\',\'2019-03-12 13:30:17\'),(\'1105340217935548418\',\'2019-03-26\',0,101,119,150,\'2019-03-12 13:30:19\',\'2019-03-12 13:30:19\'),(\'1105340225967640577\',\'2019-03-27\',0,129,141,181,\'2019-03-12 13:30:21\',\'2019-03-12 13:30:21\'),(\'1105340234075230209\',\'2019-03-28\',0,113,179,158,\'2019-03-12 13:30:23\',\'2019-03-12 13:30:23\'),(\'1105340242837131265\',\'2019-03-29\',0,117,131,101,\'2019-03-12 13:30:25\',\'2019-03-12 13:30:25\'),(\'1105340252395950082\',\'2019-03-30\',0,153,187,174,\'2019-03-12 13:30:27\',\'2019-03-12 13:30:27\'),(\'1105340261958963201\',\'2019-03-31\',0,179,135,199,\'2019-03-12 13:30:29\',\'2019-03-12 13:30:29\'),(\'1105372743634898945\',\'2019-01-06\',0,113,143,148,\'2019-03-12 15:39:34\',\'2019-03-12 15:39:34\'),(\'1105372754380705793\',\'2019-01-07\',0,173,158,153,\'2019-03-12 15:39:36\',\'2019-03-12 15:39:36\'),(\'1105372762526044162\',\'2019-01-08\',0,135,199,131,\'2019-03-12 15:39:38\',\'2019-03-12 15:39:38\'),(\'1105372771229224961\',\'2019-01-09\',0,161,107,162,\'2019-03-12 15:39:40\',\'2019-03-12 15:39:40\'),(\'1105372780922261505\',\'2019-01-10\',0,182,196,135,\'2019-03-12 15:39:42\',\'2019-03-12 15:39:42\'),(\'1105372790103592961\',\'2019-01-11\',0,123,194,102,\'2019-03-12 15:39:45\',\'2019-03-12 15:39:45\'),(\'1105372798626418689\',\'2019-01-12\',0,185,106,180,\'2019-03-12 15:39:47\',\'2019-03-12 15:39:47\'),(\'1165\',\'2018-01-01\',583,26,236,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1166\',\'2018-01-02\',583,26,236,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1167\',\'2018-01-03\',584,26,236,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1168\',\'2018-01-04\',584,26,237,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1169\',\'2018-01-05\',585,26,237,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1170\',\'2018-01-06\',585,26,237,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1171\',\'2018-01-07\',586,26,237,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1172\',\'2018-01-08\',586,26,237,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1173\',\'2018-01-09\',587,26,238,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1174\',\'2018-01-10\',587,26,238,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1175\',\'2018-01-11\',588,27,238,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1176\',\'2018-01-12\',588,27,238,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1177\',\'2018-01-13\',589,27,238,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1178\',\'2018-01-14\',589,27,239,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1179\',\'2018-01-15\',590,27,239,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1180\',\'2018-01-16\',590,27,239,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1181\',\'2018-01-17\',591,27,239,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1182\',\'2018-01-18\',591,27,239,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1183\',\'2018-01-19\',592,27,240,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1183991737299263490\',\'2019-10-01\',0,145,149,153,\'2019-10-15 14:23:22\',\'2019-10-15 14:23:22\'),(\'1183999299272904705\',\'2019-10-03\',0,125,102,153,\'2019-10-15 14:53:25\',\'2019-10-15 14:53:25\'),(\'1183999309477646338\',\'2019-10-04\',0,103,194,161,\'2019-10-15 14:53:28\',\'2019-10-15 14:53:28\'),(\'1183999318919024642\',\'2019-10-05\',0,173,174,147,\'2019-10-15 14:53:30\',\'2019-10-15 14:53:30\'),(\'1183999331409661954\',\'2019-10-06\',0,129,197,173,\'2019-10-15 14:53:33\',\'2019-10-15 14:53:33\'),(\'1183999342897860610\',\'2019-10-07\',0,184,125,169,\'2019-10-15 14:53:36\',\'2019-10-15 14:53:36\'),(\'1183999351588458498\',\'2019-10-08\',0,173,143,138,\'2019-10-15 14:53:38\',\'2019-10-15 14:53:38\'),(\'1183999360316805122\',\'2019-10-09\',0,161,158,117,\'2019-10-15 14:53:40\',\'2019-10-15 14:53:40\'),(\'1183999367480676353\',\'2019-10-10\',0,190,166,135,\'2019-10-15 14:53:42\',\'2019-10-15 14:53:42\'),(\'1184\',\'2018-01-20\',592,27,240,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1184030117693284353\',\'2019-10-11\',0,182,199,193,\'2019-10-15 16:55:53\',\'2019-10-15 16:55:53\'),(\'1185\',\'2018-01-21\',593,27,240,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1186\',\'2018-01-22\',593,27,240,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1186536619937435650\',\'2019-10-02\',0,187,183,108,\'2019-10-22 14:55:50\',\'2019-10-22 14:55:50\'),(\'1187\',\'2018-01-23\',594,27,240,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1188\',\'2018-01-24\',594,27,241,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1189\',\'2018-01-25\',595,27,241,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1190\',\'2018-01-26\',595,27,241,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1191\',\'2018-01-27\',596,27,241,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1192\',\'2018-01-28\',596,27,241,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1192253597226455042\',\'2019-11-01\',0,129,122,167,\'2019-11-07 09:33:03\',\'2019-11-07 09:33:03\'),(\'1192253902756335617\',\'2019-11-02\',0,170,192,192,\'2019-11-07 09:34:16\',\'2019-11-07 09:34:16\'),(\'1193\',\'2018-01-29\',597,27,242,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1194\',\'2018-01-30\',597,27,242,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1194060032935493633\',\'2019-11-11\',0,121,121,122,\'2019-11-12 09:11:11\',\'2019-11-12 09:11:11\'),(\'1194060301425475585\',\'2019-11-10\',0,155,187,140,\'2019-11-12 09:12:15\',\'2019-11-12 09:12:15\'),(\'1195\',\'2018-01-31\',598,27,242,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1196\',\'2018-02-01\',598,27,242,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1197\',\'2018-02-02\',599,27,242,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1198\',\'2018-02-03\',599,27,243,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1199\',\'2018-02-04\',600,27,243,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1200\',\'2018-02-05\',600,27,243,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1201\',\'2018-02-06\',601,27,243,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1202\',\'2018-02-07\',601,27,243,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1202530237531873282\',\'2019-01-01\',0,152,118,138,\'2019-12-05 18:08:45\',\'2019-12-05 18:08:45\'),(\'1202530567418019842\',\'2019-01-19\',0,183,134,164,\'2019-12-05 18:10:04\',\'2019-12-05 18:10:04\'),(\'1203\',\'2018-02-08\',602,27,244,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1204\',\'2018-02-09\',602,27,244,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1205\',\'2018-02-10\',603,27,244,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1206\',\'2018-02-11\',603,27,244,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1207\',\'2018-02-12\',604,27,244,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1208\',\'2018-02-13\',604,27,245,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1209\',\'2018-02-14\',605,27,245,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1210\',\'2018-02-15\',605,27,245,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1211\',\'2018-02-16\',606,27,245,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1212\',\'2018-02-17\',606,27,245,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1213\',\'2018-02-18\',607,27,246,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1214\',\'2018-02-19\',607,27,246,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1215\',\'2018-02-20\',608,27,246,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1216\',\'2018-02-21\',608,27,246,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1217\',\'2018-02-22\',609,27,246,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1218\',\'2018-02-23\',609,27,247,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1219\',\'2018-02-24\',610,27,247,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1220\',\'2018-02-25\',610,27,247,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1221\',\'2018-02-26\',611,27,247,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1222\',\'2018-02-27\',611,27,247,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1223\',\'2018-02-28\',612,27,248,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1224\',\'2018-03-01\',612,27,248,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1225\',\'2018-03-02\',613,28,248,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1226\',\'2018-03-03\',613,28,248,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1227\',\'2018-03-04\',614,28,248,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1228\',\'2018-03-05\',614,28,249,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1229\',\'2018-03-06\',615,28,249,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1230\',\'2018-03-07\',615,28,249,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1231\',\'2018-03-08\',616,28,249,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1232\',\'2018-03-09\',616,28,249,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1233\',\'2018-03-10\',617,28,250,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1234\',\'2018-03-11\',617,28,250,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1235\',\'2018-03-12\',618,28,250,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1236\',\'2018-03-13\',618,28,250,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1237\',\'2018-03-14\',619,28,250,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1238\',\'2018-03-15\',619,28,251,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1239\',\'2018-03-16\',620,28,251,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1240\',\'2018-03-17\',620,28,251,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1241\',\'2018-03-18\',621,28,251,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1242\',\'2018-03-19\',621,28,251,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1243\',\'2018-03-20\',622,28,252,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1244\',\'2018-03-21\',622,28,252,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1245\',\'2018-03-22\',623,28,252,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1246\',\'2018-03-23\',623,28,252,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1247\',\'2018-03-24\',624,28,252,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1248\',\'2018-03-25\',624,28,253,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1249\',\'2018-03-26\',625,28,253,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1250\',\'2018-03-27\',625,28,253,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1251\',\'2018-03-28\',626,28,253,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1252\',\'2018-03-29\',626,28,253,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1253\',\'2018-03-30\',627,28,254,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1254\',\'2018-03-31\',627,28,254,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1255\',\'2018-04-01\',628,28,254,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1256\',\'2018-04-02\',628,28,254,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1257\',\'2018-04-03\',629,28,254,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1258\',\'2018-04-04\',629,28,255,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1259\',\'2018-04-05\',630,28,255,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1260\',\'2018-04-06\',630,28,255,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1261\',\'2018-04-07\',631,28,255,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1262\',\'2018-04-08\',631,28,255,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1263\',\'2018-04-09\',632,28,256,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1264\',\'2018-04-10\',632,28,256,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1265\',\'2018-04-11\',633,28,256,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1266\',\'2018-04-12\',633,28,256,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1267\',\'2018-04-13\',634,28,256,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1268\',\'2018-04-14\',634,28,257,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1269\',\'2018-04-15\',635,28,257,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1270\',\'2018-04-16\',635,28,257,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1271\',\'2018-04-17\',636,28,257,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1272\',\'2018-04-18\',636,28,257,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1273\',\'2018-04-19\',637,28,258,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1274\',\'2018-04-20\',637,28,258,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1275\',\'2018-04-21\',638,29,258,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1276\',\'2018-04-22\',638,29,258,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1277\',\'2018-04-23\',639,29,258,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1278\',\'2018-04-24\',639,29,259,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1279\',\'2018-04-25\',640,29,259,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1280\',\'2018-04-26\',640,29,259,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1281\',\'2018-04-27\',641,29,259,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1282\',\'2018-04-28\',641,29,259,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1283\',\'2018-04-29\',642,29,260,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1284\',\'2018-04-30\',642,29,260,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1285\',\'2018-05-01\',643,29,260,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1286\',\'2018-05-02\',643,29,260,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1287\',\'2018-05-03\',644,29,260,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1288\',\'2018-05-04\',644,29,261,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1289\',\'2018-05-05\',645,29,261,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1290\',\'2018-05-06\',645,29,261,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1291\',\'2018-05-07\',646,29,261,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1292\',\'2018-05-08\',646,29,261,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1293\',\'2018-05-09\',647,29,262,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1294\',\'2018-05-10\',647,29,262,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1295\',\'2018-05-11\',648,29,262,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1296\',\'2018-05-12\',648,29,262,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1297\',\'2018-05-13\',649,29,262,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1298\',\'2018-05-14\',649,29,263,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1299\',\'2018-05-15\',5,29,263,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1300\',\'2018-05-16\',650,29,263,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1301\',\'2018-05-17\',651,29,263,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1302\',\'2018-05-18\',651,29,263,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1303\',\'2018-05-19\',652,29,264,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1304\',\'2018-05-20\',652,29,264,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1305\',\'2018-05-21\',653,29,264,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1306\',\'2018-05-22\',1,29,264,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1307\',\'2018-05-23\',654,29,264,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1308\',\'2018-05-24\',654,29,265,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1309\',\'2018-05-25\',1,29,265,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1310\',\'2018-05-26\',655,29,265,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1311\',\'2018-05-27\',656,29,265,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1312\',\'2018-05-28\',656,29,265,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1313\',\'2018-05-29\',657,29,266,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1314\',\'2018-05-30\',657,29,266,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1315\',\'2018-05-31\',658,29,266,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1316\',\'2018-06-01\',658,29,266,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1317\',\'2018-06-02\',659,29,266,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1318\',\'2018-06-03\',659,29,267,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1319\',\'2018-06-04\',660,29,267,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1320\',\'2018-06-05\',660,29,267,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1321\',\'2018-06-06\',661,29,267,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1322\',\'2018-06-07\',661,29,267,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1323\',\'2018-06-08\',662,29,268,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1324\',\'2018-06-09\',662,29,268,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1325\',\'2018-06-10\',663,30,268,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1326\',\'2018-06-11\',663,30,268,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1327\',\'2018-06-12\',664,30,268,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1328\',\'2018-06-13\',664,30,269,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1329\',\'2018-06-14\',665,30,269,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1330\',\'2018-06-15\',665,30,269,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1331\',\'2018-06-16\',666,30,269,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1332\',\'2018-06-17\',666,30,269,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1333\',\'2018-06-18\',667,30,270,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1334\',\'2018-06-19\',667,30,270,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1335\',\'2018-06-20\',668,30,270,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1336\',\'2018-06-21\',668,30,270,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1337\',\'2018-06-22\',669,30,270,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1338\',\'2018-06-23\',669,30,271,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1339\',\'2018-06-24\',670,30,271,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1340\',\'2018-06-25\',670,30,271,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1341\',\'2018-06-26\',671,30,271,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1342\',\'2018-06-27\',671,30,271,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1343\',\'2018-06-28\',672,30,272,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1344\',\'2018-06-29\',672,30,272,14,\'2018-01-25 06:38:19\',\'2019-09-09 12:12:12\'),(\'1345\',\'2018-06-30\',673,30,272,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1346\',\'2018-07-01\',673,30,272,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1347\',\'2018-07-02\',674,30,272,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1348\',\'2018-07-03\',674,30,273,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1349\',\'2018-07-04\',675,30,273,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1350\',\'2018-07-05\',675,30,273,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1351\',\'2018-07-06\',676,30,273,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1352\',\'2018-07-07\',676,30,273,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1353\',\'2018-07-08\',677,30,274,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1354\',\'2018-07-09\',677,30,274,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1355\',\'2018-07-10\',678,30,274,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1356\',\'2018-07-11\',678,30,274,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1357\',\'2018-07-12\',679,30,274,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1358\',\'2018-07-13\',679,30,275,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1359\',\'2018-07-14\',680,30,275,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1360\',\'2018-07-15\',680,30,275,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1361\',\'2018-07-16\',681,30,275,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1362\',\'2018-07-17\',681,30,275,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1363\',\'2018-07-18\',682,30,276,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1364\',\'2018-07-19\',682,30,276,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1365\',\'2018-07-20\',683,30,276,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1366\',\'2018-07-21\',683,30,276,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1367\',\'2018-07-22\',684,30,276,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1368\',\'2018-07-23\',684,30,277,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1369\',\'2018-07-24\',685,30,277,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1370\',\'2018-07-25\',685,30,277,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1371\',\'2018-07-26\',686,30,277,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1372\',\'2018-07-27\',686,30,277,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1373\',\'2018-07-28\',687,30,278,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1374\',\'2018-07-29\',687,30,278,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1375\',\'2018-07-30\',688,31,278,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1376\',\'2018-07-31\',688,31,278,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1377\',\'2018-08-01\',689,31,278,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1378\',\'2018-08-02\',689,31,279,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1379\',\'2018-08-03\',690,31,279,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1380\',\'2018-08-04\',690,31,279,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1381\',\'2018-08-05\',691,31,279,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1382\',\'2018-08-06\',691,31,279,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1383\',\'2018-08-07\',692,31,280,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1384\',\'2018-08-08\',692,31,280,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1385\',\'2018-08-09\',1,31,280,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1386\',\'2018-08-10\',693,31,280,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1387\',\'2018-08-11\',694,31,280,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1388\',\'2018-08-12\',694,31,281,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1389\',\'2018-08-13\',695,31,281,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1390\',\'2018-08-14\',695,31,281,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1391\',\'2018-08-15\',696,31,281,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1392\',\'2018-08-16\',696,31,281,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1393\',\'2018-08-17\',697,31,282,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1394\',\'2018-08-18\',697,31,282,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1395\',\'2018-08-19\',698,31,282,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1396\',\'2018-08-20\',698,31,282,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1397\',\'2018-08-21\',699,31,282,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1398\',\'2018-08-22\',699,31,283,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1399\',\'2018-08-23\',700,31,283,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1400\',\'2018-08-24\',700,31,283,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1401\',\'2018-08-25\',701,31,283,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1402\',\'2018-08-26\',701,31,283,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1403\',\'2018-08-27\',702,31,284,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1404\',\'2018-08-28\',702,31,284,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1405\',\'2018-08-29\',703,31,284,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1406\',\'2018-08-30\',703,31,284,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1407\',\'2018-08-31\',704,31,284,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1408\',\'2018-09-01\',1,31,285,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1409\',\'2018-09-02\',705,31,285,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1410\',\'2018-09-03\',705,31,285,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1411\',\'2018-09-04\',706,31,285,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1412\',\'2018-09-05\',706,31,285,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1413\',\'2018-09-06\',707,31,286,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1414\',\'2018-09-07\',707,31,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1415\',\'2018-09-08\',708,31,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1416\',\'2018-09-09\',1,31,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1417\',\'2018-09-10\',1,31,2,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1418\',\'2018-09-11\',709,31,287,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1419\',\'2018-09-12\',710,31,287,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1420\',\'2018-09-13\',710,31,287,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1421\',\'2018-09-14\',711,31,287,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1422\',\'2018-09-15\',711,31,287,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1423\',\'2018-09-16\',712,31,288,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1424\',\'2018-09-17\',712,31,288,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1425\',\'2018-09-18\',713,32,288,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1426\',\'2018-09-19\',713,32,288,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1427\',\'2018-09-20\',714,32,288,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1428\',\'2018-09-21\',714,32,289,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1429\',\'2018-09-22\',715,32,289,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1430\',\'2018-09-23\',715,32,289,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1431\',\'2018-09-24\',716,32,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1432\',\'2018-09-25\',716,32,289,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1433\',\'2018-09-26\',717,32,290,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1434\',\'2018-09-27\',717,32,290,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1435\',\'2018-09-28\',718,32,290,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1436\',\'2018-09-29\',718,32,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1437\',\'2018-09-30\',719,32,290,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1438\',\'2018-10-01\',719,32,291,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1439\',\'2018-10-02\',720,32,291,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1440\',\'2018-10-03\',720,32,291,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1441\',\'2018-10-04\',721,32,291,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1442\',\'2018-10-05\',721,32,291,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1443\',\'2018-10-06\',722,32,292,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1444\',\'2018-10-07\',722,32,292,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1445\',\'2018-10-08\',1,32,292,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1446\',\'2018-10-09\',723,32,292,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1447\',\'2018-10-10\',724,32,292,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1448\',\'2018-10-11\',724,32,293,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1449\',\'2018-10-12\',725,32,293,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1450\',\'2018-10-13\',725,32,293,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1451\',\'2018-10-14\',726,32,4,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1452\',\'2018-10-15\',726,32,293,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1453\',\'2018-10-16\',727,32,294,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1454\',\'2018-10-17\',727,32,294,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1455\',\'2018-10-18\',728,32,294,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1456\',\'2018-10-19\',728,32,294,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1457\',\'2018-10-20\',729,32,294,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1458\',\'2018-10-21\',729,32,295,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1459\',\'2018-10-22\',730,32,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1460\',\'2018-10-23\',730,32,295,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1461\',\'2018-10-24\',731,32,295,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1462\',\'2018-10-25\',731,32,295,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1463\',\'2018-10-26\',732,32,296,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1464\',\'2018-10-27\',732,32,296,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1465\',\'2018-10-28\',733,32,296,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1466\',\'2018-10-29\',2,32,3,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1467\',\'2018-10-30\',734,32,296,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1468\',\'2018-10-31\',734,32,297,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1469\',\'2018-11-01\',735,32,297,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1470\',\'2018-11-02\',735,32,297,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1471\',\'2018-11-03\',1,32,297,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1472\',\'2018-11-04\',736,32,1,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1473\',\'2018-11-05\',737,32,298,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1474\',\'2018-11-06\',737,32,298,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1475\',\'2018-11-07\',738,33,298,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1476\',\'2018-11-08\',738,33,169,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1477\',\'2018-11-09\',1,33,298,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1478\',\'2018-11-10\',739,33,78,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1479\',\'2018-11-11\',740,33,299,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1480\',\'2018-11-12\',740,33,299,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1481\',\'2018-11-13\',741,33,299,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1482\',\'2018-11-14\',741,33,299,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1483\',\'2018-11-15\',742,33,300,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1484\',\'2018-11-16\',742,33,35,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1485\',\'2018-11-17\',743,33,300,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1486\',\'2018-11-18\',743,33,300,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1487\',\'2018-11-19\',744,33,300,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1488\',\'2018-11-20\',744,33,301,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1489\',\'2018-11-21\',745,33,234,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1490\',\'2018-11-22\',456,33,301,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1491\',\'2018-11-23\',746,33,301,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1492\',\'2018-11-24\',746,33,301,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1493\',\'2018-11-25\',747,33,302,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1494\',\'2018-11-26\',747,4,302,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1495\',\'2018-11-27\',748,33,302,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1496\',\'2018-11-28\',748,33,36,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1497\',\'2018-11-29\',749,33,302,2,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1498\',\'2018-11-30\',749,3,303,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1499\',\'2018-12-01\',750,33,303,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1500\',\'2018-12-02\',234,33,303,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1501\',\'2018-12-03\',751,33,303,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1502\',\'2018-12-04\',751,33,303,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1503\',\'2018-12-05\',752,6,304,33,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1505\',\'2018-12-07\',753,33,55,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1506\',\'2018-12-08\',753,33,304,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1507\',\'2018-12-09\',754,33,304,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1508\',\'2018-12-10\',754,1,305,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1509\',\'2018-12-11\',755,33,305,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1510\',\'2018-12-12\',755,33,305,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1511\',\'2018-12-13\',756,33,305,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1512\',\'2018-12-14\',366,33,305,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1513\',\'2018-12-15\',757,33,66,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1514\',\'2018-12-16\',757,33,306,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1515\',\'2018-12-17\',758,33,306,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1516\',\'2018-12-18\',758,2,306,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1517\',\'2018-12-19\',759,33,306,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1518\',\'2018-12-20\',564,33,307,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1519\',\'2018-12-21\',760,33,307,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1520\',\'2018-12-22\',760,33,307,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1521\',\'2018-12-23\',761,33,307,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1522\',\'2018-12-24\',761,33,307,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1527\',\'2018-12-29\',764,34,308,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1528\',\'2018-12-30\',764,34,309,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1529\',\'2018-12-31\',765,34,309,14,\'2018-01-25 06:38:20\',\'2019-09-09 12:12:12\'),(\'1554\',\'2018-01-01\',333,34,314,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1555\',\'2018-01-02\',778,34,314,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1556\',\'2018-01-03\',778,34,314,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1557\',\'2018-01-04\',779,34,314,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1558\',\'2018-01-05\',779,34,315,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1559\',\'2018-01-06\',780,34,315,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1560\',\'2018-01-07\',780,34,315,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1561\',\'2018-01-08\',781,34,315,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1562\',\'2018-01-09\',781,34,315,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1563\',\'2018-01-10\',782,34,316,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1564\',\'2018-01-11\',782,34,316,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1565\',\'2018-01-12\',783,34,316,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1566\',\'2018-01-13\',783,34,316,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1567\',\'2018-01-14\',784,34,316,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1568\',\'2018-01-15\',784,34,317,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1569\',\'2018-01-16\',23,34,317,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1570\',\'2018-01-17\',785,34,317,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1571\',\'2018-01-18\',786,34,317,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1572\',\'2018-01-19\',786,34,317,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1573\',\'2018-01-20\',787,2,318,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1574\',\'2018-01-21\',787,2,318,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1575\',\'2018-01-22\',788,1,318,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1576\',\'2018-01-23\',788,35,318,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1577\',\'2018-01-24\',789,35,318,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1578\',\'2018-01-25\',789,1,319,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1579\',\'2018-01-26\',790,1,319,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1580\',\'2018-01-27\',531,2,319,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1581\',\'2018-01-28\',791,2,319,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1582\',\'2018-01-29\',791,2,319,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1583\',\'2018-01-30\',2,4,2,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1584\',\'2018-01-31\',792,35,320,14,\'2018-02-02 08:58:31\',\'2019-09-09 12:12:12\'),(\'1586\',\'2018-02-01\',793,4,3,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1587\',\'2018-02-02\',794,2,1,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1588\',\'2018-02-03\',794,1,4,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1589\',\'2018-02-04\',795,35,321,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1590\',\'2018-02-05\',795,35,321,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1591\',\'2018-02-06\',796,35,321,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1592\',\'2018-02-07\',796,35,321,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1593\',\'2018-02-08\',797,35,322,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1594\',\'2018-02-09\',797,35,322,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1595\',\'2018-02-10\',99,35,322,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1596\',\'2018-02-11\',798,35,322,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1597\',\'2018-02-12\',799,35,322,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1598\',\'2018-02-13\',799,35,323,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1599\',\'2018-02-14\',800,35,323,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1600\',\'2018-02-15\',800,35,323,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1601\',\'2018-02-16\',89,35,90,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1602\',\'2018-02-17\',801,35,323,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1603\',\'2018-02-18\',802,23,324,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1604\',\'2018-02-19\',802,2,324,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1605\',\'2018-02-20\',803,56,324,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1606\',\'2018-02-21\',45,35,89,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1607\',\'2018-02-22\',804,35,324,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1608\',\'2018-02-23\',804,35,325,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1609\',\'2018-02-24\',805,1,3,14,\'2018-02-25 10:54:34\',\'2019-09-09 12:12:12\'),(\'1610\',\'2018-05-15\',0,0,0,7,\'2018-05-16 00:25:27\',\'2019-09-09 12:12:12\'),(\'1611\',\'2018-10-01\',0,0,0,7,\'2018-10-24 16:17:15\',\'2019-09-09 12:12:12\'),(\'1612\',\'2018-10-02\',0,0,0,7,\'2018-10-24 16:17:15\',\'2019-09-09 12:12:12\'),(\'1613\',\'2018-10-03\',0,0,0,7,\'2018-10-24 16:17:15\',\'2019-09-09 12:12:12\'),(\'1614\',\'2018-10-04\',0,0,0,7,\'2018-10-24 16:17:15\',\'2019-09-09 12:12:12\'),(\'1615\',\'2018-10-05\',0,0,0,7,\'2018-10-24 16:17:15\',\'2019-09-09 12:12:12\');
/*!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 */;
guli_ucenter
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.21-log : Database - guli_ucenter
*********************************************************************
*/
/*!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 */;
/*Table structure for table `ucenter_member` */
DROP TABLE IF EXISTS `ucenter_member`;
CREATE TABLE `ucenter_member` (
`id` char(19) NOT NULL COMMENT \'会员id\',
`openid` varchar(128) DEFAULT NULL COMMENT \'微信openid\',
`mobile` varchar(11) DEFAULT \'\' COMMENT \'手机号\',
`password` varchar(255) DEFAULT NULL COMMENT \'密码\',
`nickname` varchar(50) DEFAULT NULL COMMENT \'昵称\',
`sex` tinyint(2) unsigned DEFAULT NULL COMMENT \'性别 1 男，2 女\',
`age` tinyint(3) unsigned DEFAULT NULL COMMENT \'年龄\',
`avatar` varchar(255) DEFAULT NULL COMMENT \'用户头像\',
`sign` varchar(100) DEFAULT NULL COMMENT \'用户签名\',
`is_disabled` tinyint(1) NOT NULL DEFAULT \'0\' COMMENT \'是否禁用 1（true）已禁用， 0（false）未禁用\',
`is_deleted` tinyint(1) NOT NULL DEFAULT \'0\' COMMENT \'逻辑删除 1（true）已删除， 0（false）未删除\',
`gmt_create` datetime NOT NULL COMMENT \'创建时间\',
`gmt_modified` datetime NOT NULL COMMENT \'更新时间\',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=\'会员表\';
/*Data for the table `ucenter_member` */
insert into `ucenter_member`(`id`,`openid`,`mobile`,`password`,`nickname`,`sex`,`age`,`avatar`,`sign`,`is_disabled`,`is_deleted`,`gmt_create`,`gmt_modified`) values (\'1080736474267144193\',NULL,\'13700000011\',\'96e79218965eb72c92a549dd5a330112\',\'用户XJtDfaYeKk\',1,19,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-02 12:12:45\',\'2019-01-02 12:12:56\'),(\'1080736474355224577\',NULL,\'13700000002\',\'96e79218965eb72c92a549dd5a330112\',\'用户wUrNkzAPrc\',1,27,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-02 12:13:56\',\'2019-01-02 12:14:07\'),(\'1086387099449442306\',NULL,\'13520191388\',\'96e79218965eb72c92a549dd5a330112\',\'用户XTMUeHDAoj\',2,20,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1086387099520745473\',NULL,\'13520191389\',\'96e79218965eb72c92a549dd5a330112\',\'用户vSdKeDlimn\',1,21,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1086387099608825858\',NULL,\'13520191381\',\'96e79218965eb72c92a549dd5a330112\',\'用户EoyWUVXQoP\',1,18,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1086387099701100545\',NULL,\'13520191382\',\'96e79218965eb72c92a549dd5a330112\',\'用户LcAYbxLNdN\',2,24,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1086387099776598018\',NULL,\'13520191383\',\'96e79218965eb72c92a549dd5a330112\',\'用户dZdjcgltnk\',2,25,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1086387099852095490\',NULL,\'13520191384\',\'96e79218965eb72c92a549dd5a330112\',\'用户wNHGHlxUwX\',2,23,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-01-19 06:17:23\',\'2019-01-19 06:17:23\'),(\'1106746895272849410\',\'o1R-t5u2TfEVeVjO9CPGdHPNw-to\',NULL,NULL,\'檀梵\\'\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/zZfLXcetf2Rpsibq6HbPUWKgWSJHtha9y1XBeaqluPUs6BYicW1FJaVqj7U3ozHd3iaodGKJOvY2PvqYTuCKwpyfQ/132\',NULL,0,0,\'2019-03-16 10:39:57\',\'2019-03-16 10:39:57\'),(\'1106823035660357634\',\'o1R-t5i4gENwHYRb5lVFy98Z0bdk\',NULL,NULL,\'GaoSir\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJI53RcCuc1no02os6ZrattWGiazlPnicoZQ59zkS7phNdLEWUPDk8fzoxibAnXV1Sbx0trqXEsGhXPw/132\',NULL,0,0,\'2019-03-16 15:42:30\',\'2019-03-16 15:42:30\'),(\'1106823115788341250\',\'o1R-t5l_3rnbZbn4jWwFdy6Gk6cg\',NULL,NULL,\'换个网名哇、\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/jJHyeM0EN2jhB70LntI3k8fEKe7W6CwykrKMgDJM4VZqCpcxibVibX397p0vmbKURGkLS4jxjGB0GpZfxCicgt07w/132\',NULL,0,0,\'2019-03-16 15:42:49\',\'2019-03-16 15:42:49\'),(\'1106828185829490690\',\'o1R-t5nNlou5lRwBVgGNJFm4rbc4\',NULL,NULL,\' 虎头\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKxCqRzuYWQmpwiaqQEjNxbC7WicebicXQusU306jgmfoOzUcFg1qaDq5BStiblwBjw5dUOblQ2gUicQOQ/132\',NULL,0,0,\'2019-03-16 16:02:58\',\'2019-03-16 16:02:58\'),(\'1106830599651442689\',\'o1R-t5hZHQB1cbX7HZJsiM727_SA\',NULL,NULL,\'是吴啊\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJ9CsqApybcs7f3Dyib9IxIh0sBqJb7LicbjU4WticJFF0PVwFvHgtbFdBwfmk3H2t3NyqmEmVx17tRA/132\',NULL,0,0,\'2019-03-16 16:12:34\',\'2019-03-16 16:12:34\'),(\'1106830976199278593\',\'o1R-t5meKOoyEJ3-IhWRCBKFcvzU\',NULL,NULL,\'我才是Helen\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epMicP9UT6mVjYWdno0OJZkOXiajG0sllJTbGJ9DYiceej2XvbDSGCK8LCF7jv1PuG2uoYlePWic9XO8A/132\',NULL,0,0,\'2019-03-16 16:14:03\',\'2019-03-16 16:14:03\'),(\'1106831936900415490\',\'o1R-t5jXYSWakGtnUBnKbfVT5Iok\',NULL,NULL,\'文若姬\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/3HEmJwpSzguqqAyzmBwqT6aicIanswZibEOicQInQJI3ZY1qmu59icJC6N7SahKqWYv24GvX5KH2fibwt0mPWcTJ3fg/132\',NULL,0,0,\'2019-03-16 16:17:52\',\'2019-03-16 16:17:52\'),(\'1106832491064442882\',\'o1R-t5sud081Qsa2Vb2xSKgGnf_g\',NULL,NULL,\'Peanut\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-03-16 16:20:04\',\'2019-03-16 16:20:04\'),(\'1106833021442510849\',\'o1R-t5lsGc3I8P5bDpHj7m_AIRvQ\',NULL,NULL,\'食物链终结者\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/MQ7qUmCprK9am16M1Ia1Cs3RK0qiarRrl9y8gsssBjIZeS2GwKSrnq7ZYhmrzuzDwBxSMMAofrXeLic9IBlW4M3Q/132\',NULL,0,0,\'2019-03-16 16:22:11\',\'2019-03-16 16:22:11\'),(\'1191600824445046786\',NULL,\'15210078344\',\'96e79218965eb72c92a549dd5a330112\',\'IT妖姬\',1,5,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-11-05 14:19:10\',\'2019-11-08 18:04:43\'),(\'1191616288114163713\',NULL,\'17866603606\',\'96e79218965eb72c92a549dd5a330112\',\'xiaowu\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-11-05 15:20:37\',\'2019-11-05 15:20:37\'),(\'1195187659054329857\',NULL,\'15010546384\',\'96e79218965eb72c92a549dd5a330112\',\'qy\',NULL,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132\',NULL,0,0,\'2019-11-15 11:51:58\',\'2019-11-15 11:51:58\'),(\'1203050193780584450\',NULL,\'18686842318\',\'e10adc3949ba59abbe56e057f20f883e\',\'cohen\',NULL,NULL,\'https://online-teach-file-helen.oss-cn-beijing.aliyuncs.com/avatar/default.jpg\',NULL,0,0,\'2019-12-07 04:34:52\',\'2019-12-07 04:34:52\'),(\'1203065189981810689\',NULL,\'13766816630\',\'e10adc3949ba59abbe56e057f20f883e\',\'helen\',NULL,NULL,\'https://online-teach-file-helen.oss-cn-beijing.aliyuncs.com/avatar/default.jpg\',NULL,0,0,\'2019-12-07 05:34:28\',\'2019-12-07 05:34:28\'),(\'1203898148695597058\',\'o3_SC58aj3laPkwse2H2mBP8PFyk\',\'\',NULL,\'我是Helenฉันคิดถึง\',2,NULL,\'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIhQbQxWia9dQyfUESGSiaI2qxgznhNsRsOoxYXGwn65icSYGRcosxdqTRA4a1g23icGLMSKPibxa0PHGg/132\',NULL,0,0,\'2019-12-09 12:44:21\',\'2019-12-09 12:44:21\');
/*!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 */;
版权声明：本文为smalldong原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。