tp5-api/tp5qpi.sql

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : tp5api

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

Date: 2019-03-22 13:59:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tp_admin
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin`;
CREATE TABLE `tp_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `userName` char(16) NOT NULL COMMENT '用户名',
  `password` char(32) NOT NULL COMMENT '密码',
  `email` char(32) NOT NULL COMMENT '用户邮箱',
  `realName` varchar(50) NOT NULL COMMENT '姓名',
  `phone` char(15) NOT NULL COMMENT '用户手机',
  `img` varchar(255) DEFAULT NULL,
  `regTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `regIp` varchar(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `loginTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `loginIp` varchar(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `isEnabled` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态  0 禁用，1正常',
  `groupId` mediumint(8) NOT NULL DEFAULT '0' COMMENT '权限组',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`userName`) USING BTREE,
  KEY `status` (`isEnabled`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='管理员用户表';

-- ----------------------------
-- Records of tp_admin
-- ----------------------------
INSERT INTO `tp_admin` VALUES ('1', 'admin', '227af9354aef4e7d4050b1043d5be6b7', '123@163.com', '123', '', 'http://api.hardphp.com/uploads/images/20190322/41ef26c97b94a327562671abd56385a6.jpg', '1498276451', '127.0.0.1', '1553234296', '39.149.12.184', '1553234323', '1', '1');

-- ----------------------------
-- Table structure for tp_app
-- ----------------------------
DROP TABLE IF EXISTS `tp_app`;
CREATE TABLE `tp_app` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `appId` char(18) NOT NULL COMMENT '应用id',
  `appSecret` char(32) DEFAULT NULL COMMENT '应用密钥',
  `title` varchar(150) DEFAULT NULL COMMENT '名称',
  `description` varchar(255) NOT NULL COMMENT '备注',
  `regTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `regIp` varchar(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
  `loginTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `loginIp` varchar(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `isEnabled` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态  0 禁用，1正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='app应用表';

-- ----------------------------
-- Records of tp_app
-- ----------------------------
INSERT INTO `tp_app` VALUES ('1', 'ty9fd2848a039ab554', 'ec32286d0718118861afdbf6e401ee81', '管理员端', '', '1498276451', '127.0.0.1', '1521305444', '123.149.208.76', '1514962598', '1');
INSERT INTO `tp_app` VALUES ('2', 'ty9fd2848a039abbbb', 'ec32286d0718118861afdbf6e401ee81', '淘宝客端', '', '1498276451', '127.0.0.1', '1521305444', '123.149.208.76', '1514962598', '1');

-- ----------------------------
-- Table structure for tp_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group`;
CREATE TABLE `tp_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '为1正常，为0禁用',
  `rules` text NOT NULL COMMENT '用户组拥有的规则id， 多个规则","隔开',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户组表';

-- ----------------------------
-- Records of tp_auth_group
-- ----------------------------
INSERT INTO `tp_auth_group` VALUES ('1', '超级管理员', '1', '44,45,41,43,42,39,40,1,38,7,2', '1552300913');
INSERT INTO `tp_auth_group` VALUES ('2', '普通管理员', '1', '1,2', '1542787522');

-- ----------------------------
-- Table structure for tp_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_rule`;
CREATE TABLE `tp_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一标识',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '规则中文名称',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '为1正常，为0禁用',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 正常，0=禁用',
  `condition` char(100) NOT NULL DEFAULT '' COMMENT '规则表达式，为空表示存在就验证',
  `pid` mediumint(8) NOT NULL DEFAULT '0' COMMENT '上级菜单',
  `sorts` mediumint(8) NOT NULL DEFAULT '0' COMMENT '升序',
  `icon` varchar(50) DEFAULT NULL,
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `path` varchar(255) NOT NULL COMMENT '路经',
  `component` varchar(255) NOT NULL COMMENT '组件',
  `hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '左侧菜单 0==显示,1隐藏',
  `noCache` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1=不缓存，0=缓存',
  `alwaysShow` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1= 总显示,0=否 依据子菜单个数',
  `redirect` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='规则表';

-- ----------------------------
-- Records of tp_auth_rule
-- ----------------------------
INSERT INTO `tp_auth_rule` VALUES ('1', 'manage', '权限管理', '1', '1', '', '0', '0', 'component', '1547187800', '/manage', 'layout/Layout', '0', '0', '1', '');
INSERT INTO `tp_auth_rule` VALUES ('2', 'manage/admin', '管理员列表', '1', '1', '', '1', '0', 'user', '1541666364', 'admin', 'manage/admin', '0', '0', '0', '');
INSERT INTO `tp_auth_rule` VALUES ('7', 'manage/rules', '权限列表', '1', '1', '', '1', '0', 'lock', '1542353476', 'rules', 'manage/rules', '0', '0', '0', '');
INSERT INTO `tp_auth_rule` VALUES ('38', 'manage/roles', '角色列表', '1', '1', '', '1', '0', 'list', '1542602805', 'roles', 'manage/roles', '0', '1', '1', '');
INSERT INTO `tp_auth_rule` VALUES ('39', 'log', '日志管理', '1', '1', '', '0', '0', 'component', '1542602916', '/log', 'layout/Layout', '0', '0', '1', '');
INSERT INTO `tp_auth_rule` VALUES ('40', 'log/log', '登陆日志', '1', '1', '', '39', '0', 'list', '1552301777', 'log', 'log/log', '0', '1', '1', '');

-- ----------------------------
-- Table structure for tp_login_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_login_log`;
CREATE TABLE `tp_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(10) unsigned NOT NULL COMMENT '用户ID',
  `userName` char(16) NOT NULL COMMENT '用户名',
  `loginIp` varchar(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
  `loginTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
  `roles` varchar(50) NOT NULL DEFAULT '0' COMMENT '角色',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员登录';

-- ----------------------------
-- Records of tp_login_log
-- ----------------------------
INSERT INTO `tp_login_log` VALUES ('1', '1', 'admin', '127.0.0.1', '1553234028', '超级管理员');
INSERT INTO `tp_login_log` VALUES ('2', '1', 'admin', '127.0.0.1', '1553234296', '超级管理员');

-- ----------------------------
-- Table structure for tp_user
-- ----------------------------
DROP TABLE IF EXISTS `tp_user`;
CREATE TABLE `tp_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `openId` varchar(150) DEFAULT NULL COMMENT '微信身份标识',
  `password` char(32) DEFAULT NULL COMMENT '32位小写MD5密码',
  `phone` varchar(30) DEFAULT NULL COMMENT '手机号',
  `userName` varchar(30) DEFAULT NULL COMMENT '用户名',
  `realName` varchar(50) DEFAULT NULL COMMENT '姓名',
  `isEnabled` tinyint(1) DEFAULT '1' COMMENT '是否启用',
  `nickName` varchar(20) DEFAULT NULL COMMENT '用户昵称',
  `img` varchar(255) DEFAULT NULL COMMENT '头像URL',
  `sex` tinyint(1) DEFAULT '0' COMMENT '性别标志：0，其他；1，男；2，女',
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '账户余额',
  `birth` varchar(50) DEFAULT NULL COMMENT '生日',
  `descript` varchar(200) DEFAULT NULL,
  `totalMoney` decimal(10,2) DEFAULT '0.00' COMMENT '账户总金额',
  `pid` int(10) DEFAULT '0',
  `pid2` int(10) DEFAULT '0',
  `androidChannelId` varchar(100) DEFAULT NULL COMMENT '推送Android终端ID',
  `iosChannelId` varchar(100) DEFAULT NULL COMMENT '推送IOS终端ID',
  `regTime` int(10) DEFAULT NULL COMMENT '注册时间',
  `regIp` varchar(20) DEFAULT NULL COMMENT '注册IP',
  `loginIp` varchar(20) DEFAULT NULL COMMENT 'IP',
  `loginTime` int(10) DEFAULT NULL COMMENT '登录时间',
  `updateTime` int(10) DEFAULT NULL COMMENT '时间',
  `isDel` tinyint(1) DEFAULT '0',
  `adzoneId` varchar(50) DEFAULT NULL COMMENT '淘宝客广告位',
  `isCheck` tinyint(1) DEFAULT '0' COMMENT '0=待审核，1=通过，2=拒绝',
  `level` tinyint(2) DEFAULT '7' COMMENT '代理级别',
  PRIMARY KEY (`id`),
  KEY `phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='主系统用户表。';

-- ----------------------------
-- Records of tp_user
-- ----------------------------
INSERT INTO `tp_user` VALUES ('1', '', 'ee8512502ab075a1ad969238ca83a15d', '', '12312333', '张三', '1', 'hardphp', 'http://api.hardphp.com/uploads/images/20190108/21b4a8aa748142cd506976ef0f7e1bbb.png', '0', '20210.00', '1989-10-10', '我要给你一个拥抱 给你一双温热手掌', '525225.00', '0', '0', '', '', '1515057952', '123.149.214.69', '', '0', '1553167717', '1', '74735600372', '0', '7');

-- ----------------------------
-- Table structure for tp_user_login_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_user_login_log`;
CREATE TABLE `tp_user_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(10) unsigned DEFAULT NULL COMMENT '用户ID',
  `userName` char(16) DEFAULT NULL COMMENT '用户名',
  `loginIp` varchar(20) DEFAULT '0' COMMENT '最后登录IP',
  `loginTime` int(10) unsigned DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员登录';

-- ----------------------------
-- Records of tp_user_login_log
-- ----------------------------
INSERT INTO `tp_user_login_log` VALUES ('1', '6', null, '121.199.30.7', '1501656638');
INSERT INTO `tp_user_login_log` VALUES ('2', '6', null, '121.199.30.7', '1501833739');