ios_sign/fadmin_jg.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 103.108.43.176--客服外网
 Source Server Type    : MySQL
 Source Server Version : 50645
 Source Host           : 127.0.0.1:3306
 Source Schema         : fsadmin

 Target Server Type    : MySQL
 Target Server Version : 50645
 File Encoding         : 65001

 Date: 18/11/2019 10:56:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

-- ----------------------------
-- Records of admin_app
-- ----------------------------
INSERT INTO `admin_app` 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);
INSERT INTO `admin_app` VALUES (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 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'URL',
  `log_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'ip',
  `log_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `log_time` datetime(0) NULL DEFAULT NULL COMMENT '日志日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 71 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标题',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图标',
  `uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URI',
  `routes` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '路由,如url:/menu,controller:MenuController',
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for 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,
  INDEX `permission_menu_permission_id_menu_id_index`(`permission_id`, `menu_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of admin_permission_menu
-- ----------------------------
INSERT INTO `admin_permission_menu` VALUES (1, 2);
INSERT INTO `admin_permission_menu` VALUES (2, 2);
INSERT INTO `admin_permission_menu` VALUES (3, 3);
INSERT INTO `admin_permission_menu` VALUES (4, 3);
INSERT INTO `admin_permission_menu` VALUES (5, 4);
INSERT INTO `admin_permission_menu` VALUES (6, 4);
INSERT INTO `admin_permission_menu` VALUES (7, 5);
INSERT INTO `admin_permission_menu` VALUES (8, 5);
INSERT INTO `admin_permission_menu` VALUES (9, 7);

-- ----------------------------
-- Table structure for 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,
  INDEX `permission_role_role_id_foreign`(`role_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of admin_permission_role
-- ----------------------------
INSERT INTO `admin_permission_role` VALUES (1, 1);
INSERT INTO `admin_permission_role` VALUES (2, 1);
INSERT INTO `admin_permission_role` VALUES (3, 1);
INSERT INTO `admin_permission_role` VALUES (4, 1);
INSERT INTO `admin_permission_role` VALUES (5, 1);
INSERT INTO `admin_permission_role` VALUES (6, 1);
INSERT INTO `admin_permission_role` VALUES (7, 1);
INSERT INTO `admin_permission_role` VALUES (8, 1);
INSERT INTO `admin_permission_role` VALUES (9, 1);
INSERT INTO `admin_permission_role` VALUES (10, 1);
INSERT INTO `admin_permission_role` VALUES (10, 2);
INSERT INTO `admin_permission_role` VALUES (10, 4);

-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限名 英文',
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '显示名 中文',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `controllers` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '对应的controllers',
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `permissions_name_unique`(`name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for 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,
  INDEX `role_menu_role_id_menu_id_index`(`role_id`, `menu_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of admin_role_menu
-- ----------------------------
INSERT INTO `admin_role_menu` VALUES (1, 1);
INSERT INTO `admin_role_menu` VALUES (1, 2);
INSERT INTO `admin_role_menu` VALUES (1, 3);
INSERT INTO `admin_role_menu` VALUES (1, 4);
INSERT INTO `admin_role_menu` VALUES (1, 5);
INSERT INTO `admin_role_menu` VALUES (1, 6);
INSERT INTO `admin_role_menu` VALUES (1, 7);
INSERT INTO `admin_role_menu` VALUES (1, 8);
INSERT INTO `admin_role_menu` VALUES (1, 9);
INSERT INTO `admin_role_menu` VALUES (1, 10);

-- ----------------------------
-- Table structure for 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,
  INDEX `role_user_role_id_foreign`(`role_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of admin_role_user
-- ----------------------------
INSERT INTO `admin_role_user` VALUES (1, 1);

-- ----------------------------
-- Table structure for 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名',
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '显示名',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `created_at` timestamp(0) NULL DEFAULT NULL,
  `updated_at` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `roles_name_unique`(`name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin_roles
-- ----------------------------
INSERT INTO `admin_roles` VALUES (1, 'admin', '超级管理员', '最高级的权限', '2019-11-08 17:38:39', '2019-11-08 17:38:39');
INSERT INTO `admin_roles` VALUES (2, 'Operator', '运营人员', '运营人员', '2019-11-14 17:07:25', '2019-11-14 17:07:25');
INSERT INTO `admin_roles` VALUES (4, 'guanli', '一般管理员', '山东省发生的规范化', '2019-11-16 14:36:21', '2019-11-16 14:37:00');

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

-- ----------------------------
-- Records of admin_users
-- ----------------------------
INSERT INTO `admin_users` 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');
INSERT INTO `admin_users` VALUES (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');
INSERT INTO `admin_users` VALUES (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');
INSERT INTO `admin_users` VALUES (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');
INSERT INTO `admin_users` VALUES (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');
INSERT INTO `admin_users` VALUES (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 migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2017_07_04_104528_create_admin_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2017_07_04_104719_create_admin_roles_table', 1);
INSERT INTO `migrations` VALUES (3, '2017_07_04_104933_create_admin_logs_table', 1);
INSERT INTO `migrations` VALUES (4, '2017_07_04_104933_create_admin_menus_table', 1);
INSERT INTO `migrations` VALUES (5, '2017_07_04_104933_create_admin_permission_menu_table', 1);
INSERT INTO `migrations` VALUES (6, '2017_07_04_104933_create_admin_permission_role_table', 1);
INSERT INTO `migrations` VALUES (7, '2017_07_04_104933_create_admin_permissions_table', 1);
INSERT INTO `migrations` VALUES (8, '2017_07_04_104933_create_admin_role_menu_table', 1);
INSERT INTO `migrations` VALUES (9, '2017_07_04_104933_create_admin_role_user_table', 1);

SET FOREIGN_KEY_CHECKS = 1;