/*
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', '计算机/互联网/通信', '这家伙很懒', '猪', '', '');
