我上边发的就是呀，

/*
Navicat MySQL Data Transfer

Source Server : localhost
Source Server Version : 50553
Source Host : localhost:3306
Source Database : oauth2

Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001

Date: 2017-01-16 13:57:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- Table structure for mxq_guide

DROP TABLE IF EXISTS mxq_guide;
CREATE TABLE mxq_guide (
id int(11) NOT NULL,
imgurl varchar(255) DEFAULT NULL,
status smallint(2) DEFAULT NULL,
flag smallint(2) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Records of mxq_guide

INSERT INTO mxq_guide VALUES ('0', 'ddd', '1', '1111');
INSERT INTO mxq_guide VALUES ('2', 'ssss', '1', '2222');
INSERT INTO mxq_guide VALUES ('3', '555', '4', '444');

-- Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int(20) unsigned NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL COMMENT '用户名',
password_hash varchar(80) DEFAULT NULL COMMENT '密码',
password_reset_token varchar(60) DEFAULT NULL COMMENT '密码token',
email varchar(60) DEFAULT NULL COMMENT '邮箱',
auth_key varchar(60) DEFAULT NULL,
status int(5) DEFAULT NULL COMMENT '状态',
created_at int(18) DEFAULT NULL COMMENT '创建时间',
updated_at int(18) DEFAULT NULL COMMENT '更新时间',
password varchar(50) DEFAULT NULL COMMENT '密码',
role varchar(50) DEFAULT NULL COMMENT 'role',
curr_login_at varchar(50) DEFAULT NULL,
curr_login_ip varchar(50) DEFAULT NULL,
access_token varchar(60) DEFAULT NULL,
login_count varchar(50) DEFAULT NULL,
allowance int(20) NOT NULL,
allowance_updated_at int(20) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY username (username),
UNIQUE KEY access_token (access_token)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Records of user

INSERT INTO user VALUES ('1', 'terry', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, 'zqy234@126.com', 'pBJi3hyFsLsTuvUM9paFpWjYRatn3qwS', '10', '1441763620', '1484546128', null, null, '1484235121', '::1', 'qvuhh01lt4Q4GZnnLI2gdL1HwYR0nLWN', '17', '0', '1447318986');
INSERT INTO user VALUES ('2', 'terry1', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, 'zqy2341@126.com', 'wIvJk7dMm6PQ1dJFz8iUqJ1RfH6rsDTW', '10', '1441763906', '1484235959', null, null, '1484235121', '::1', '_ydI-L1lQQwKZzoOWzMOUjMZ-t1PcM4k', '2', '0', '0');
INSERT INTO user VALUES ('3', 'zqy', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, 'zqy23114@126.com', 'K-76pcy7gxceemxRI2IeN5g1EhLMaCj8', '10', '1442544183', '1442544183', null, 'moderator', null, null, null, null, '0', '0');
INSERT INTO user VALUES ('4', 'admin', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, 'zqy2342321@126.com', 'hZWOaamjHEsPtuJJVghFRdE2oTj7Qv8P', '10', '1446524232', '1446524232', null, null, null, null, null, null, '0', '0');

数据库