数据库表设计
一共五张表
菜单表 权限表 用户表 菜单权限表 用户权限表
数据库表之间的关系
import com. baomidou. mybatisplus. core. conditions. query. QueryWrapper;
import com. yj. aclservice. entity. Permission;
import com. yj. aclservice. service. PermissionService;
import org. junit. Test;
import org. junit. runner. RunWith;
import org. springframework. beans. factory. annotation. Autowired;
import org. springframework. boot. test. context. SpringBootTest;
import org. springframework. test. context. junit4. SpringRunner;
import java. util. ArrayList;
import java. util. HashMap;
import java. util. List;
import java. util. Map;
@RunWith ( SpringRunner. class )
@SpringBootTest ( classes = com. yj. aclservice. ServiceAclApplication. class )
public class TestPermission {
@Autowired
private PermissionService permissionService;
@Test
public void findAllPermission ( ) {
QueryWrapper< Permission> queryWrapper = new QueryWrapper < > ( ) ;
queryWrapper. select ( "id" , "name" , "pid" ) ;
List< Permission> list = permissionService. list ( queryWrapper) ;
Map< String, Object> map= findAll ( list, "0" ) ;
System. out. println ( "---------------->" + map) ;
}
public static Map< String, Object> findAll ( List< Permission> list, String level) {
HashMap< String, Object> map = new HashMap < > ( ) ;
for ( int i = 0 ; i < list. size ( ) ; i++ ) {
if ( level. equals ( list. get ( i) . getPid ( ) ) ) {
map. put ( "id" , level) ;
map. put ( "name" , list. get ( i) . getName ( ) ) ;
map. put ( "children" , build ( list, list. get ( i) . getId ( ) ) ) ;
}
}
return map;
}
public static List< Map< String, Object> > build ( List< Permission> children, String level) {
List< Map< String, Object> > mapList= new ArrayList < > ( ) ;
Map< String, Object> map = null;
for ( int i = 0 ; i < children. size ( ) ; i++ ) {
if ( level. equals ( children. get ( i) . getPid ( ) ) ) {
map = new HashMap < > ( ) ;
map. put ( "id" , level) ;
map. put ( "name" , children. get ( i) . getName ( ) ) ;
map. put ( "children" , build ( children, children. get ( i) . getId ( ) ) ) ;
mapList. add ( map) ;
}
}
return mapList;
}
}
{
children = [ {
children = [ {
children = [ {
children = [ ] ,
name = 查看,
id = 1195268616021139457
} , {
children = [ ] ,
name = 添加,
id = 1195268616021139457
} , {
children = [ ] ,
name = 修改,
id = 1195268616021139457
} , {
children = [ ] ,
name = 删除,
id = 1195268616021139457
} , {
children = [ ] ,
name = 分配角色,
id = 1195268616021139457
} ] ,
name = 用户管理,
id = 1195268474480156673
} , {
children = [ {
children = [ ] ,
name = 修改,
id = 1195268788138598401
} , {
children = [ ] ,
name = 查看,
id = 1195268788138598401
} , {
children = [ ] ,
name = 添加,
id = 1195268788138598401
} , {
children = [ ] ,
name = 删除,
id = 1195268788138598401
} , {
children = [ ] ,
name = 角色权限,
id = 1195268788138598401
} ] ,
name = 角色管理,
id = 1195268474480156673
} , {
children = [ {
children = [ ] ,
name = 查看,
id = 1195268893830864898
} , {
children = [ ] ,
name = 添加,
id = 1195268893830864898
} , {
children = [ ] ,
name = 修改,
id = 1195268893830864898
} , {
children = [ ] ,
name = 删除,
id = 1195268893830864898
} ] ,
name = 菜单管理,
id = 1195268474480156673
} ] ,
name = 权限管理,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 查看,
id = 1195349699995734017
} , {
children = [ ] ,
name = 修改,
id = 1195349699995734017
} , {
children = [ ] ,
name = 删除,
id = 1195349699995734017
} ] ,
name = 讲师列表,
id = 1195349439240048642
} , {
children = [ {
children = [ ] ,
name = 添加,
id = 1195349810561781761
} ] ,
name = 添加讲师,
id = 1195349439240048642
} ] ,
name = 讲师管理,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 查看,
id = 1195350397751758850
} ] ,
name = 课程分类列表,
id = 1195350299365969922
} , {
children = [ {
children = [ ] ,
name = 导入,
id = 1195350500512206850
} ] ,
name = 导入课程分类,
id = 1195350299365969922
} ] ,
name = 课程分类,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 完成发布,
id = 1195350919074385921
} , {
children = [ ] ,
name = 编辑课程,
id = 1195350919074385921
} , {
children = [ ] ,
name = 编辑课程大纲,
id = 1195350919074385921
} ] ,
name = 课程列表,
id = 1195350831744782337
} , {
children = [ ] ,
name = 发布课程,
id = 1195350831744782337
} ] ,
name = 课程管理,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 生成,
id = 1195351968841568257
} ] ,
name = 生成统计,
id = 1195351862889254913
} , {
children = [ {
children = [ ] ,
name = 查看,
id = 1195352054917074946
} ] ,
name = 统计图表,
id = 1195351862889254913
} ] ,
name = 统计分析,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 查看,
id = 1195353513549205505
} , {
children = [ ] ,
name = 添加,
id = 1195353513549205505
} , {
children = [ ] ,
name = 修改,
id = 1195353513549205505
} , {
children = [ ] ,
name = 删除,
id = 1195353513549205505
} ] ,
name = Bander列表,
id = 1195352547621965825
} ] ,
name = CMS管理,
id = 1
} , {
children = [ {
children = [ {
children = [ ] ,
name = 查看,
id = 1195354153482555393
} ] ,
name = 订单列表,
id = 1195354076890370050
} ] ,
name = 订单管理,
id = 1
} ] , name = 全部数据, id = 0
}
以下是建表语句
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 = '权限' ;
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' ) ;
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;
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' ) ;
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 = '角色权限' ;
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' ) ;
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 = '用户表' ;
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' ) ;
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;
INSERT INTO ` acl_user_role` VALUES ( '1' , '1' , '2' , 0 , '2019-11-11 13:09:53' , '2019-11-11 13:09:53' ) ;