ios_sign/ios_sign.sql

/*
SQLyog Ultimate v12.5.1 (64 bit)
MySQL - 10.4.8-MariaDB-1:10.4.8+maria~bionic : Database - fsadmin
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`fsadmin` /*!40100 DEFAULT CHARACTER SET utf8 */;

/*Table structure for table `admin_app` */

DROP TABLE IF EXISTS `admin_app`;

CREATE TABLE `admin_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `app_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用标题\r\n',
  `icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标',
  `edition` varchar(11) COLLATE utf8_unicode_ci DEFAULT '1.0' COMMENT '版本',
  `build_edition` varchar(11) COLLATE utf8_unicode_ci DEFAULT '1.0' COMMENT 'Build版本',
  `app_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用id',
  `sys_edition` varchar(11) COLLATE utf8_unicode_ci DEFAULT '8.0' COMMENT '系统版本',
  `filesize` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件大小',
  `f_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '副标题',
  `f_age` int(11) DEFAULT 18 COMMENT '使用年龄',
  `f_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',
  `f_ranking` int(11) DEFAULT 1 COMMENT '排名',
  `f_score` int(11) DEFAULT 5 COMMENT '评分星级',
  `f_score_num` int(11) DEFAULT NULL COMMENT '评分数量',
  `f_brief` text COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '简介',
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '预览图',
  `a_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '安装 标题',
  `a_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织名称',
  `a_desc` text COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  `a_down` int(11) DEFAULT NULL COMMENT '下载设备数量',
  `a_down_limit` int(11) DEFAULT NULL COMMENT '下载设备限制',
  `a_ation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '邀请码',
  `a_c_ation` int(11) unsigned DEFAULT 1 COMMENT '查看邀请码',
  `a_down_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '安装地址，链接',
  `a_qr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '二维码',
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '本地应用路径',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_app` */

insert  into `admin_app`(`id`,`app_title`,`icon`,`edition`,`build_edition`,`app_id`,`sys_edition`,`filesize`,`f_title`,`f_age`,`f_class`,`f_ranking`,`f_score`,`f_score_num`,`f_brief`,`img`,`a_title`,`a_name`,`a_desc`,`a_down`,`a_down_limit`,`a_ation`,`a_c_ation`,`a_down_url`,`a_qr`,`path`) values 
(1,'棋盘达曼贯','/uploads/ico/201911141208485dccd350208a4.png','1.0','1.0','1.2','7.0','21.89','大满贯',18,'娱乐',1111,1,888,'大1满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘大满贯棋盘。','/uploads/ico/201911141343045dcce96817aa0.jpeg|/uploads/ico/201911141343105dcce96edc7a6.jpeg','155','.213',NULL,467,500,'/xxx',1,'http://','xxx',NULL),
(2,'大满贯期盼','/uploads/ico/201911141217055dccd541e10df.png','1.0','1.0','1.2','7.0','21.89','自走棋',18,'娱乐',4,4,888,'大满贯棋牌是精心打造的顶级棋牌娱乐中心，火爆全网，超多玩法。提供刺激好玩的百人牛牛，炸金花，斗地主，麻将，捕鱼，百家乐，龙虎斗，奔驰宝马，红黑大战等等。下载APP送3元，支持支付宝，微信，银行卡充值！提现秒到账！幸运转盘天天赚，每天大奖888元等您拿！活动多多！惊喜多多！10000捕鱼金币免费体验，开启疯狂捕鱼之旅！资金安全有保障，顶级安全团队24小时保障您的资金安全！新玩家使用您的推广链接或二维码下载游戏并且登录，即可成为您的直属玩家。通过您的直属玩家推广链接或二维码下载并登录的新玩家，即可成为您的2级玩家，以此推类。...','/uploads/ico/201911141251135dccdd41c3a4f.jpeg|/uploads/ico/201911141329515dcce64f39e24.jpeg','12','111','大满贯棋牌是精心打造的顶级棋牌娱乐中心，火爆全网，超多玩法。提供刺激好玩的百人牛牛，炸金花，斗地主，麻将，捕鱼，百家乐，龙虎斗，奔驰宝马，红黑大战等等。下载APP送3元，支持支付宝，微信，银行卡充值！提现秒到账！幸运转盘天天赚，每天大奖888元等您拿！活动多多！惊喜多多！10000捕鱼金币免费体验，开启疯狂捕鱼之旅！资金安全有保障，顶级安全团队24小时保障您的资金安全！新玩家使用您的推广链接或二维码下载游戏并且登录，即可成为您的直属玩家。通过您的直属玩家推广链接或二维码下载并登录的新玩家，即可成为您的2级玩家，以此推类。...',467,500,'/xxx',0,'http://','/uploads/ico/201911141121495dccc84d497a8.ico',NULL);

/*Table structure for table `admin_logs` */

DROP TABLE IF EXISTS `admin_logs`;

CREATE TABLE `admin_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(11) NOT NULL COMMENT '用户ID',
  `log_url` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL',
  `log_ip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ip',
  `log_info` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `log_time` datetime DEFAULT NULL COMMENT '日志日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_logs` */

insert  into `admin_logs`(`id`,`admin_id`,`log_url`,`log_ip`,`log_info`,`log_time`) values 
(1,1,'/login','127.0.0.1','后台登陆','2019-11-08 17:57:49'),
(2,1,'/login','127.0.0.1','后台登陆','2019-11-08 17:58:15'),
(3,1,'/saveinfo/1','127.0.0.1','修改用户信息操作成功','2019-11-08 18:31:15'),
(4,1,'/login','127.0.0.1','后台登陆','2019-11-08 21:50:45'),
(5,1,'/users/story','127.0.0.1','操作用户操作成功','2019-11-08 21:53:33'),
(6,1,'/login','127.0.0.1','后台登陆','2019-11-09 06:43:14'),
(7,1,'/login','127.0.0.1','后台登陆','2019-11-11 08:49:35'),
(8,1,'/users/destroy/2','127.0.0.1','删除用户操作成功','2019-11-11 15:10:42'),
(9,1,'/users/destroy/3','127.0.0.1','删除用户操作成功','2019-11-11 15:10:44'),
(10,1,'/users/destroy/4','127.0.0.1','删除用户操作成功','2019-11-11 15:10:46'),
(11,1,'/users/destroy/5','127.0.0.1','删除用户操作成功','2019-11-11 15:10:53'),
(12,1,'/users/destroy/9','127.0.0.1','删除用户操作成功','2019-11-11 16:34:52'),
(13,1,'/login','127.0.0.1','后台登陆','2019-11-12 09:59:38'),
(14,1,'/menus/destroy','127.0.0.1','操作菜单操作失败','2019-11-12 10:44:41'),
(15,1,'/menus/story','127.0.0.1','操作菜单操作成功','2019-11-12 10:48:42'),
(16,1,'/menus/story','127.0.0.1','操作菜单操作成功','2019-11-12 10:50:25'),
(17,1,'/menus/destroy','127.0.0.1','操作菜单操作失败','2019-11-12 10:55:43'),
(18,1,'/menus/story','127.0.0.1','操作菜单操作成功','2019-11-12 10:56:25'),
(19,1,'/login','127.0.0.1','后台登陆','2019-11-13 09:44:22'),
(20,1,'/login','127.0.0.1','后台登陆','2019-11-13 11:50:00'),
(21,1,'/login','127.0.0.1','后台登陆','2019-11-13 14:32:52'),
(22,1,'/users/destroy/15','127.0.0.1','删除用户操作成功','2019-11-13 17:15:49'),
(23,1,'/users/destroy/10','127.0.0.1','删除用户操作成功','2019-11-13 17:15:53'),
(24,1,'/users/destroy/8','127.0.0.1','删除用户操作成功','2019-11-13 17:15:55'),
(25,1,'/users/destroy/7','127.0.0.1','删除用户操作成功','2019-11-13 17:15:58'),
(26,1,'/users/destroy/11','127.0.0.1','删除用户操作成功','2019-11-13 17:16:00'),
(27,1,'/login','127.0.0.1','后台登陆','2019-11-13 18:29:12'),
(28,1,'/login','127.0.0.1','后台登陆','2019-11-14 09:32:01'),
(29,1,'/login','127.0.0.1','后台登陆','2019-11-14 09:38:49'),
(30,1,'/login','127.0.0.1','后台登陆','2019-11-14 09:39:12'),
(31,1,'/login','118.112.72.114','后台登陆','2019-11-14 15:40:20'),
(32,1,'/login','118.112.72.114','后台登陆','2019-11-14 15:42:39'),
(33,1,'/roles/story','118.112.72.114','操作角色操作成功','2019-11-14 17:07:25'),
(34,1,'/permissions/story','118.112.72.114','操作权限操作成功','2019-11-14 17:08:37'),
(35,1,'/login','118.112.72.237','后台登陆','2019-11-15 11:01:35'),
(36,1,'/login','118.112.72.237','后台登陆','2019-11-15 11:33:24'),
(37,1,'/login','154.209.23.169','后台登陆','2019-11-15 14:00:37'),
(38,1,'/login','118.112.72.237','后台登陆','2019-11-15 14:05:13'),
(39,1,'/login','118.112.72.237','后台登陆','2019-11-15 17:17:35'),
(40,1,'/login','118.112.72.237','后台登陆','2019-11-15 17:50:35'),
(41,1,'/login','118.112.72.237','后台登陆','2019-11-15 19:46:52'),
(42,1,'/roles/story','118.112.72.237','操作角色操作成功','2019-11-15 20:47:30'),
(43,1,'/roles/destroy/3','118.112.72.237','删除角色操作成功','2019-11-15 20:47:51'),
(44,1,'/login','183.36.112.205','后台登陆','2019-11-15 21:34:58'),
(45,1,'/login','118.112.72.237','后台登陆','2019-11-16 09:59:01'),
(46,1,'/login','118.112.72.237','后台登陆','2019-11-16 10:00:26'),
(47,1,'/login','118.112.72.237','后台登陆','2019-11-16 10:01:33'),
(48,1,'/login','118.112.72.237','后台登陆','2019-11-16 10:05:29'),
(49,1,'/login','118.112.72.237','后台登陆','2019-11-16 10:24:37'),
(50,1,'/login','118.112.72.237','后台登陆','2019-11-16 11:02:37'),
(51,1,'/login','117.136.63.188','后台登陆','2019-11-16 11:04:43'),
(52,1,'/login','118.112.72.237','后台登陆','2019-11-16 11:44:27'),
(53,1,'/login','118.112.72.237','后台登陆','2019-11-16 11:55:54'),
(54,1,'/login','118.112.72.237','后台登陆','2019-11-16 12:08:28'),
(55,1,'/login','118.112.72.237','后台登陆','2019-11-16 13:27:27'),
(56,1,'/login','118.112.72.237','后台登陆','2019-11-16 13:32:29'),
(57,16,'/login','118.112.72.237','后台登陆','2019-11-16 13:34:00'),
(58,1,'/login','118.112.72.237','后台登陆','2019-11-16 13:38:03'),
(59,16,'/login','118.112.72.237','后台登陆','2019-11-16 13:39:29'),
(60,1,'/login','118.112.72.237','后台登陆','2019-11-16 13:40:01'),
(61,1,'/login','118.112.72.237','后台登陆','2019-11-16 13:43:31'),
(62,1,'/login','118.112.72.237','后台登陆','2019-11-16 14:32:48'),
(63,6,'/login','118.112.72.237','后台登陆','2019-11-16 14:33:03'),
(64,1,'/roles/story','118.112.72.237','操作角色操作成功','2019-11-16 14:36:21'),
(65,1,'/roles/story','118.112.72.237','操作角色操作成功','2019-11-16 14:37:00'),
(66,1,'/login','118.112.72.237','后台登陆','2019-11-16 14:53:13'),
(67,17,'/login','117.136.62.44','后台登陆','2019-11-16 14:55:58');

/*Table structure for table `admin_menus` */

DROP TABLE IF EXISTS `admin_menus`;

CREATE TABLE `admin_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '上级ID',
  `order` int(11) NOT NULL DEFAULT 0 COMMENT '菜单排序',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图标',
  `uri` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URI',
  `routes` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路由,如url:/menu,controller:MenuController',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_menus` */

insert  into `admin_menus`(`id`,`parent_id`,`order`,`title`,`icon`,`uri`,`routes`,`created_at`,`updated_at`) values 
(1,0,6,'权限设置','','url:/qx','url:','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(2,10,9,'日志记录','','/logs','url:/logs','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(3,1,6,'角色管理','','/roles','url:/roles','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(4,1,7,'权限管理','','/permissions','url:/permissions','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(5,1,8,'菜单管理','','/menus','url:/menus','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(6,0,-7,'账户设置','','/log','url:/','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(8,0,-4,'应用管理','','/app','url:/app','2019-11-12 09:23:18','2019-11-12 10:48:42'),
(7,6,1,'账户管理','','/users','url:/users','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(9,8,3,'上传应用','','/apps','url:/apps','2019-11-12 09:33:18','2019-11-12 10:50:25'),
(10,0,20,'日志管理','','/log','url:/log','2019-11-12 09:33:18','2019-11-12 10:56:25');

/*Table structure for table `admin_permission_menu` */

DROP TABLE IF EXISTS `admin_permission_menu`;

CREATE TABLE `admin_permission_menu` (
  `permission_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  KEY `permission_menu_permission_id_menu_id_index` (`permission_id`,`menu_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=FIXED;

/*Data for the table `admin_permission_menu` */

insert  into `admin_permission_menu`(`permission_id`,`menu_id`) values 
(1,2),
(2,2),
(3,3),
(4,3),
(5,4),
(6,4),
(7,5),
(8,5),
(9,7);

/*Table structure for table `admin_permission_role` */

DROP TABLE IF EXISTS `admin_permission_role`;

CREATE TABLE `admin_permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`) USING BTREE,
  KEY `permission_role_role_id_foreign` (`role_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=FIXED;

/*Data for the table `admin_permission_role` */

insert  into `admin_permission_role`(`permission_id`,`role_id`) values 
(1,1),
(2,1),
(3,1),
(4,1),
(5,1),
(6,1),
(7,1),
(8,1),
(9,1),
(10,1),
(10,2),
(10,4);

/*Table structure for table `admin_permissions` */

DROP TABLE IF EXISTS `admin_permissions`;

CREATE TABLE `admin_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限名 英文',
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示名 中文',
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `controllers` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对应的controllers',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `permissions_name_unique` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_permissions` */

insert  into `admin_permissions`(`id`,`name`,`display_name`,`description`,`controllers`,`created_at`,`updated_at`) values 
(1,'userlist','用户管理查看','用户管理查看','UserController@get','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(2,'userhandle','用户管理编辑','用户管理编辑','UserController@post','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(3,'rolelist','角色管理查看','角色管理查看','RoleController@get','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(4,'rolehandle','角色管理编辑','角色管理编辑','RoleController@post','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(5,'perlist','权限管理查看','权限管理查看','PermissionController@get','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(6,'perhandle','权限管理编辑','权限管理编辑','PermissionController@post','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(7,'menulist','菜单管理查看','菜单管理查看','MenuController@get','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(8,'menuhandle','菜单管理编辑','菜单管理编辑','MenuController@post','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(9,'loglist','日志管理查看','日志管理查看','LogController@get','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(10,'apps','上传应用','上传应用','apps@post','2019-11-14 17:08:37','2019-11-14 17:08:37');

/*Table structure for table `admin_role_menu` */

DROP TABLE IF EXISTS `admin_role_menu`;

CREATE TABLE `admin_role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  KEY `role_menu_role_id_menu_id_index` (`role_id`,`menu_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=FIXED;

/*Data for the table `admin_role_menu` */

insert  into `admin_role_menu`(`role_id`,`menu_id`) values 
(1,1),
(1,2),
(1,3),
(1,4),
(1,5),
(1,6),
(1,7),
(1,8),
(1,9),
(1,10);

/*Table structure for table `admin_role_user` */

DROP TABLE IF EXISTS `admin_role_user`;

CREATE TABLE `admin_role_user` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `role_user_role_id_foreign` (`role_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=FIXED;

/*Data for the table `admin_role_user` */

insert  into `admin_role_user`(`user_id`,`role_id`) values 
(1,1);

/*Table structure for table `admin_roles` */

DROP TABLE IF EXISTS `admin_roles`;

CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名',
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '显示名',
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `roles_name_unique` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_roles` */

insert  into `admin_roles`(`id`,`name`,`display_name`,`description`,`created_at`,`updated_at`) values 
(1,'admin','超级管理员','最高级的权限','2019-11-08 17:38:39','2019-11-08 17:38:39'),
(2,'Operator','运营人员','运营人员','2019-11-14 17:07:25','2019-11-14 17:07:25'),
(4,'guanli','一般管理员','山东省发生的规范化','2019-11-16 14:36:21','2019-11-16 14:37:00');

/*Table structure for table `admin_users` */

DROP TABLE IF EXISTS `admin_users`;

CREATE TABLE `admin_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '登录账号',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录密码',
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '开发者账户',
  `csr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'csr',
  `IssuerID` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IssuerID：',
  `miyaoID` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '密钥ID',
  `p8` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'p8',
  `number` int(11) DEFAULT NULL COMMENT '数量',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '是否停用',
  `device` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '设备列表',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `users_username_unique` (`email`) USING BTREE,
  UNIQUE KEY `users_email_unique` (`csr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `admin_users` */

insert  into `admin_users`(`id`,`username`,`password`,`email`,`csr`,`IssuerID`,`miyaoID`,`p8`,`number`,`created_at`,`status`,`device`) values 
(1,'admin','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','admin@admin.com','admin@admin.com','18888888888','10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975r','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO',1,'2019-11-08 17:38:39',1,'Platform:Android OS_Version:8.1.0'),
(12,'2qer','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','TestAdmin@qq.com','ewqr','wefrq','edfq','12312312312321',100,'2019-11-11 15:31:52',1,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.8'),
(6,'user','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','user@user.com','dsfas','dsfjkasdf;j','sdfajsl','fasldfa',100,'2019-11-11 14:42:14',0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.8'),
(14,'meow','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','meow@sina.com','meow','meiow','meowei','meiwoew',100,'2019-11-12 10:20:24',0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.87 Safari/537.36'),
(16,'0711','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','0711@qq.com','qwe','qwe','123456','qwe',100,'2019-11-16 10:12:02',1,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36'),
(17,'123','$2y$10$0nZ2IJJQzkuwTUvmsxVCYOAFw09sGceAk5b9p.AQ.h7I0YEj975rO','123@qq.com','123456','123456','123456','123456',100,'2019-11-16 14:33:49',1,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36');

/*Table structure for table `migrations` */

DROP TABLE IF EXISTS `migrations`;

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2017_07_04_104528_create_admin_users_table',1),
(2,'2017_07_04_104719_create_admin_roles_table',1),
(3,'2017_07_04_104933_create_admin_logs_table',1),
(4,'2017_07_04_104933_create_admin_menus_table',1),
(5,'2017_07_04_104933_create_admin_permission_menu_table',1),
(6,'2017_07_04_104933_create_admin_permission_role_table',1),
(7,'2017_07_04_104933_create_admin_permissions_table',1),
(8,'2017_07_04_104933_create_admin_role_menu_table',1),
(9,'2017_07_04_104933_create_admin_role_user_table',1);

/*!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 */;