sql.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE TABLE IF NOT EXISTS `hr_wxusera` (
  `id` mediumint(8) unsigned AUTO_INCREMENT NOT NULL COMMENT '权限id',
  `openid` char(30) NOT NULL COMMENT 'openid',
  `nickname` varchar(30) NOT NULL COMMENT '用户名',
  `sex` enum('1','0','2') DEFAULT '1' COMMENT '性别1男2女',
  `city` varchar(30) NOT NULL COMMENT '城市',
  `province` varchar(30) NOT NULL COMMENT '城市',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  `avatar` varchar(150) DEFAULT '' COMMENT '用户头像',
  `status` tinyint DEFAULT 0 COMMENT '会员等级',
  `subscribe` enum('0','1') DEFAULT '0' COMMENT '是否关注',
  `ischeck` enum('0','1') DEFAULT '0' COMMENT '是否认证',
  `parentid` mediumint(8) DEFAULT '0' COMMENT '上级id',
  `parentphone` char(11) DEFAULT '0' COMMENT '上级手机号id',
  `myphone` char(11) DEFAULT '0' COMMENT '自己手机号',
  `sendcode` char(6) DEFAULT '0' COMMENT '手机验证码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `openid` (`openid`),
  KEY `nickname` (`nickname`),
  KEY `city` (`city`),
  KEY `province` (`province`),
  KEY `createtime` (`createtime`),
  KEY `subscribe` (`subscribe`),
  KEY `ischeck` (`ischeck`),
  KEY `parentid` (`parentid`),
  KEY `parentphone` (`parentphone`),
  KEY `myphone` (`myphone`),
  KEY `sendcode` (`sendcode`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='微信用户表' AUTO_INCREMENT=1 ;

-- 支付记录
create table hr_userrecorda(
  id mediumint unsigned auto_increment comment 'id',
  openid char(30) default '' COMMENT 'openid',
  phone char(11) DEFAULT '1' COMMENT '手机',
  recharge decimal(10,2) unsigned not null default 0 COMMENT '付费金额',
  pdate datetime default NULL comment '支付时间',
  primary key(id),
  key openid(openid),
  key phone(phone),
  key pdate(pdate)
)engine=InnoDB default charset=utf8 comment'用户支付记录表';