Metrics
0
Watch 13 Star 32 Fork 13

小龙王 / veadminPHPApache-2.0

Sign up for free
Explore and code with more than 2 million developers,Free private repositories !:)
Sign up
VEadmin是逻辑敲简单的后端权限管理快速开发的平台 spread retract

  • HTML 64.9%
  • JavaScript 26.5%
  • CSS 4.4%
  • PHP 4.1%
  • Smarty 0.1%
Clone or download
veadmin.sql 20.51 KB
Copy Edit Web IDE Raw Blame History
小龙王 authored 2018-11-28 08:40 . 更新 veadmin.sql
/*
Navicat Premium Data Transfer
Source Server : 本地连接
Source Server Type : MySQL
Source Server Version : 50553
Source Host : localhost:3306
Source Schema : weadmin
Target Server Type : MySQL
Target Server Version : 50553
File Encoding : 65001
Date: 27/02/2018 16:19:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for blog_comment
-- ----------------------------
DROP TABLE IF EXISTS `blog_comment`;
CREATE TABLE `blog_comment` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '评论主键ID',
`parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父ID',
`posts_id` bigint(20) NULL DEFAULT NULL COMMENT '文章ID',
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '评论者ID',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容',
`created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建者',
`updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
`updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
`deleted_at` timestamp NULL DEFAULT NULL COMMENT '软删除',
`ip_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者地址',
`status` int(10) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for blog_option
-- ----------------------------
DROP TABLE IF EXISTS `blog_option`;
CREATE TABLE `blog_option` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`option_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'key值',
`option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'value值',
`autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes' COMMENT '自动加载 yes或者no',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `option_name`(`option_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for blog_posts
-- ----------------------------
DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '标题',
`excerpt` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '摘录或者简介',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`clicks` int(10) NOT NULL COMMENT '点击量',
`created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`creator` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建者',
`updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
`updater` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
`deleted_at` timestamp NULL DEFAULT NULL COMMENT '软删除',
`ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者地址',
`status` int(10) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for blog_tag
-- ----------------------------
DROP TABLE IF EXISTS `blog_tag`;
CREATE TABLE `blog_tag` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '标签主键',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
-- ----------------------------
-- Table structure for blog_user
-- ----------------------------
DROP TABLE IF EXISTS `blog_user`;
CREATE TABLE `blog_user` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`email` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`password` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`introduction` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户简介',
`sex` tinyint(4) NULL DEFAULT 0 COMMENT '用户性别',
`birth_at` timestamp NULL DEFAULT NULL COMMENT '出生日期',
`real_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实名',
`id_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',
`location` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户位置',
`remember_token` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户token',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`status` int(10) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_abilities
-- ----------------------------
DROP TABLE IF EXISTS `sys_abilities`;
CREATE TABLE `sys_abilities` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',
`parent_id` int(10) NOT NULL COMMENT '父级编号',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
`sort` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '10' COMMENT '排序',
`icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
`href` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接',
`permission` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
`is_show` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否在菜单中显示',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sys_abilities
-- ----------------------------
INSERT INTO `sys_abilities` VALUES ('1', 0, '功能菜单', '0', 'fa-paper-plane', '/', NULL, '1', '2018-01-18 23:38:29', '2017-10-15 00:21:59');
INSERT INTO `sys_abilities` VALUES ('1589915135324581', 3, '添加编辑', '', 'fa-paper-plane', '/admin/user/save', NULL, 'on', '2018-01-18 23:38:28', '2018-01-18 15:50:02');
INSERT INTO `sys_abilities` VALUES ('1589915288722603', 3, '编辑信息', '', 'fa-paper-plane', '/admin/user/get_find', NULL, 'on', '2018-01-18 23:38:27', '2018-01-18 15:42:56');
INSERT INTO `sys_abilities` VALUES ('1589917014815888', 3, '删除', '', 'fa-paper-plane', '/admin/user/del', NULL, 'on', '2018-01-18 23:38:30', '2018-01-18 16:10:22');
INSERT INTO `sys_abilities` VALUES ('1589917803742122', 4, '添加编辑', '', 'fa-paper-plane', '/admin/role/save', NULL, 'on', '2018-01-18 23:38:27', '2018-01-18 16:22:54');
INSERT INTO `sys_abilities` VALUES ('1589917905316174', 4, '编辑信息', '', 'fa-paper-plane', '/admin/role/get_find', NULL, 'on', '2018-01-18 23:38:27', '2018-01-18 16:24:31');
INSERT INTO `sys_abilities` VALUES ('1589918168544183', 4, '删除', '', 'fa-paper-plane', '/admin/role/del', NULL, 'on', '2018-01-18 23:38:26', '2018-01-18 16:28:42');
INSERT INTO `sys_abilities` VALUES ('1589918202475924', 4, '权限', '', 'fa-paper-plane', '/admin/role/get_power', NULL, 'on', '2018-01-18 23:38:32', '2018-01-18 16:29:14');
INSERT INTO `sys_abilities` VALUES ('1589918245209256', 5, '添加编辑', '', 'fa-paper-plane', '/admin/menu/save', NULL, 'on', '2018-01-18 23:38:26', '2018-01-18 16:29:55');
INSERT INTO `sys_abilities` VALUES ('1589918286669976', 5, '编辑信息', '', 'fa-paper-plane', '/admin/menu/get_find', NULL, 'on', '2018-01-18 23:38:25', '2018-01-18 16:30:35');
INSERT INTO `sys_abilities` VALUES ('1589918835757815', 5, '删除', '', 'fa-paper-plane', '/admin/menu', NULL, 'on', '2018-01-18 23:38:25', '2018-01-18 16:39:18');
INSERT INTO `sys_abilities` VALUES ('2', 1, '系统设置', '1', 'fa-gears', '/admin/index/dashboard', NULL, 'on', '2018-01-18 23:38:08', '2017-10-15 00:30:52');
INSERT INTO `sys_abilities` VALUES ('3', 2, '用户管理', '10', 'fa-paper-plane', '/admin/user/index', NULL, 'on', '2018-01-18 23:38:22', '2017-10-15 00:29:43');
INSERT INTO `sys_abilities` VALUES ('4', 2, '角色管理', '20', 'fa-paper-plane', '/admin/role/index', NULL, 'on', '2018-01-18 23:38:23', '2017-10-15 00:28:36');
INSERT INTO `sys_abilities` VALUES ('5', 2, '菜单管理', '30', 'fa-paper-plane', '/admin/menu/index', NULL, '1', '2018-01-18 23:38:24', '2017-10-15 00:33:43');
INSERT INTO `sys_abilities` VALUES ('6', 1, '博客管理', '2', 'fa-anchor', '/admin/aa', NULL, 'on', '2018-01-18 23:39:09', '2017-10-15 00:35:49');
-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志表ID',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
`ip_address` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
`status` tinyint(1) NULL DEFAULT NULL COMMENT '1 成功 2 失败',
`add_time` timestamp NULL DEFAULT NULL COMMENT '发生时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名',
`ename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色英文名',
`role_type` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色类型',
`display_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色简介',
`description` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色备注',
`usable` int(64) NOT NULL DEFAULT 1 COMMENT '是否可用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '系统管理员', 'object', 'object', '这是个上帝角色', '有任何权限的人', 1, '2017-10-15 00:43:28', '2017-10-15 00:43:30');
INSERT INTO `sys_role` VALUES ('2', 'test1', 'test1', 'object', 'test1', 'test1', 0, '2017-12-07 22:37:12', '2017-12-07 22:37:12');
INSERT INTO `sys_role` VALUES ('3', 'test2', 'test2', 'object', 'test2', 'test2', 0, '2017-12-07 22:37:31', '2017-12-07 22:37:31');
-- ----------------------------
-- Table structure for sys_role_abilities
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_abilities`;
CREATE TABLE `sys_role_abilities` (
`role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`abilities_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sys_role_abilities
-- ----------------------------
INSERT INTO `sys_role_abilities` VALUES ('1', '1', NULL);
INSERT INTO `sys_role_abilities` VALUES ('1', '2', NULL);
INSERT INTO `sys_role_abilities` VALUES ('1', '3', NULL);
INSERT INTO `sys_role_abilities` VALUES ('1', '4', NULL);
INSERT INTO `sys_role_abilities` VALUES ('1', '5', NULL);
INSERT INTO `sys_role_abilities` VALUES ('1', '6', NULL);
INSERT INTO `sys_role_abilities` VALUES ('2', '1', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '2', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '4', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '1589917803742122', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '1589917905316174', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '1589918168544183', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '1589918202475924', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('2', '6', '2018-01-18 17:33:31');
INSERT INTO `sys_role_abilities` VALUES ('3', '1', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '2', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '4', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589917803742122', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589917905316174', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589918168544183', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589918202475924', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '5', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589918245209256', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589918286669976', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '1589918835757815', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('3', '6', '2018-01-22 14:13:01');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '2', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '3', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589915135324581', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589915288722603', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589917014815888', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '4', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589917803742122', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589917905316174', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589918168544183', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589918202475924', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '5', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589918245209256', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589918286669976', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '1589918835757815', '2018-01-29 17:05:20');
INSERT INTO `sys_role_abilities` VALUES ('1590917030933028', '6', '2018-01-29 17:05:20');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`email` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`password` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`introduction` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户简介',
`sex` tinyint(4) NULL DEFAULT 0 COMMENT '用户性别',
`birth_at` timestamp NULL DEFAULT NULL COMMENT '出生日期',
`real_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实名',
`id_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',
`location` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户位置',
`remember_token` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户token',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`status` int(10) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `users_name_unique`(`name`) USING BTREE,
UNIQUE INDEX `users_email_unique`(`email`) USING BTREE,
UNIQUE INDEX `users_phone_unique`(`phone`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', '991382548@qq.com', '13888888888', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', '个人介绍,签名啥的', 0, '1993-02-18 22:57:22', '动画', 'haigle', NULL, NULL, '2017-09-27 21:32:44', '2017-09-27 21:32:41', NULL, 1);
INSERT INTO `sys_user` VALUES ('1589935614637746', 'te', 'a@qq.com', '12342456543', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', NULL, 0, '2018-01-18 00:00:00', NULL, NULL, NULL, NULL, '2018-01-18 21:06:00', '2018-01-18 21:06:00', NULL, 1);
INSERT INTO `sys_user` VALUES ('1589935737474995', 'wq', 'q@qq.com', '12343233333', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', NULL, 0, '2018-01-18 21:07:56', NULL, NULL, NULL, NULL, '2018-01-18 21:07:57', '2018-01-18 21:07:57', NULL, 1);
INSERT INTO `sys_user` VALUES ('1589936878501239', 'wefr', 'werf@aa.com', '12342334555', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', NULL, 0, '2018-01-18 21:25:09', NULL, NULL, NULL, NULL, '2018-01-18 21:26:05', '2018-01-29 17:48:13', NULL, 1);
INSERT INTO `sys_user` VALUES ('1593541396913056', 'sdf', 'dsf@qwe.com', '12321098675', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', NULL, 0, '2018-02-27 00:00:00', NULL, NULL, NULL, NULL, '2018-02-27 16:18:22', '2018-02-27 16:18:22', NULL, 1);
INSERT INTO `sys_user` VALUES ('2', 'qwer', 'qwe@g.com', '12345678911', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.ImFkbWluIg.5iLvvLohi9Lz6Xy_wlrB9uypZzOoHJ2cBr09u2IeicQ', NULL, 0, '2018-01-07 00:00:00', NULL, NULL, NULL, NULL, '2018-01-10 22:36:26', '2018-01-18 16:59:14', NULL, 1);
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('1', '1', '2018-01-07 17:30:48');
INSERT INTO `sys_user_role` VALUES ('0', '2', '2018-01-11 22:55:53');
INSERT INTO `sys_user_role` VALUES ('0', '3', '2018-01-11 22:55:53');
INSERT INTO `sys_user_role` VALUES ('0', '2', '2018-01-18 16:12:45');
INSERT INTO `sys_user_role` VALUES ('2', '2', '2018-01-18 16:59:14');
INSERT INTO `sys_user_role` VALUES ('0', '2', '2018-01-18 21:06:00');
INSERT INTO `sys_user_role` VALUES ('0', '2', '2018-01-18 21:26:05');
INSERT INTO `sys_user_role` VALUES ('0', '1', '2018-02-27 16:11:56');
INSERT INTO `sys_user_role` VALUES ('0', '1', '2018-02-27 16:18:22');
SET FOREIGN_KEY_CHECKS = 1;

Comment ( 0 )

You need to Sign in for post a comment

Help Search