/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.5.40 : Database - bisai
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bisai` /*!40100 DEFAULT CHARACTER SET gbk */;

USE `bisai`;

/*Table structure for table `play` */

DROP TABLE IF EXISTS `play`;

CREATE TABLE `play` (
  `pk_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `fk_user_id` int(11) NOT NULL COMMENT '用户ID',
  `play_times` varchar(50) NOT NULL COMMENT '涂抹时间',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

/*Data for the table `play` */

insert  into `play`(`pk_id`,`fk_user_id`,`play_times`,`create_time`,`update_time`) values (7,2,'2.99秒','2015-12-25 16:16:22','2015-12-25 16:16:22'),(6,2,'2.39秒','2015-12-25 16:15:51','2015-12-25 16:15:51'),(8,2,'1.57秒','2015-12-25 16:16:46','2015-12-25 16:16:46'),(9,2,'1.62秒','2015-12-25 16:19:23','2015-12-25 16:19:23'),(10,3,'0.83秒','2015-12-25 16:21:42','2015-12-25 16:21:42'),(11,2,'10.33秒','2015-12-25 16:23:55','2015-12-25 16:23:55'),(12,3,'1.72秒','2015-12-25 16:24:31','2015-12-25 16:24:31');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `pk_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `openid` varchar(50) NOT NULL COMMENT '微信标识',
  `nickname` varchar(30) NOT NULL COMMENT '昵称',
  `country` varchar(10) NOT NULL DEFAULT '' COMMENT '国家',
  `province` varchar(10) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(10) NOT NULL DEFAULT '' COMMENT '城市',
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '名字',
  `phone` varchar(15) NOT NULL DEFAULT '' COMMENT '电话',
  `address` varchar(50) NOT NULL DEFAULT '' COMMENT '地址',
  `play_times` varchar(100) NOT NULL DEFAULT '' COMMENT '花费最少的涂抹时间',
  `play_num` varchar(50) NOT NULL DEFAULT '' COMMENT '次数',
  `headimgurl` varchar(200) NOT NULL DEFAULT '' COMMENT '头像',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`pk_id`,`openid`,`nickname`,`country`,`province`,`city`,`name`,`phone`,`address`,`play_times`,`play_num`,`headimgurl`,`create_time`,`update_time`) values (2,'omIEJvzeICy2neGZZ-VQNeHCd-f4','张淑洲','','','','','','','1.57秒','','','2015-12-25 16:16:46','2015-12-25 16:16:46'),(3,'omIEJvxoYbJvbouhCInWs08YSKSk','秧歌','','','','','','','0.83秒','1','','2015-12-25 16:21:42','2015-12-25 16:21:42');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;