用户信息表

/*
Navicat MySQL Data Transfer

Source Server         : www.a.com
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : ceshi

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

Date: 2019-03-21 01:08:05
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '用户名',
  `age` tinyint(3) NOT NULL COMMENT '年龄',
  `py` varchar(50) NOT NULL COMMENT '拼音',
  `city` varchar(30) NOT NULL COMMENT '城市',
  `classNo` int(8) NOT NULL COMMENT '学号',
  `email` varchar(40) NOT NULL COMMENT '邮箱',
  `telphone` int(11) DEFAULT NULL COMMENT '***',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `qq` int(13) NOT NULL COMMENT 'qq号',
  `weixin` varchar(50) NOT NULL COMMENT '微信号',
  `zhiye` varchar(50) NOT NULL COMMENT '职业',
  `shuoming` varchar(255) DEFAULT NULL COMMENT '个人说明',
  `shuxiang` varchar(3) DEFAULT NULL COMMENT '属相',
  `data` varchar(10) NOT NULL COMMENT '出生日期',
  `regdate` varchar(10) NOT NULL COMMENT '注册日期',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '灭绝师太', '22', 'miejue', '合肥', '333333', '1370730471@qq.com', '110', '123', '1370730471', '1370730471', '', '91340100MA2R9H262M\r\n', '马', '1991-01-01', '1992-02-02');
INSERT INTO `user` VALUES ('2', '猪哥', '21', 'zhuge', '合肥', '3333', '333', '112', '123', '88526', '1111', '计算机/互联网/通信', '这家伙很懒', '猪', '', '');