/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50524
Source Host           : localhost:3306
Source Database       : yyk

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

Date: 2015-09-25 17:38:15
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `myinfo`
-- ----------------------------
DROP TABLE IF EXISTS `myinfo`;
CREATE TABLE `myinfo` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` char(20) DEFAULT NULL,
  `sex` int(4) DEFAULT '0',
  `age` int(2) DEFAULT NULL,
  `pic` varchar(32) DEFAULT NULL,
  `role` int(2) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  `job` varchar(32) DEFAULT NULL,
  `address` varchar(32) DEFAULT NULL,
  `phone` int(15) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of myinfo
-- ----------------------------
INSERT INTO `myinfo` VALUES ('1', 'Tom', '0', '96', null, null, null, null, null, null, null);
INSERT INTO `myinfo` VALUES ('2', 'Joan', '0', '83', null, null, null, null, null, null, null);
INSERT INTO `myinfo` VALUES ('3', 'Wang', '0', '97', null, null, null, null, null, null, null);