/*
Navicat MySQL Data Transfer
Source Server : 我的数据库
Source Server Version : 50553
Source Host : localhost:3306
Source Database : xuexi
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2019-03-21 16:05:45
*/
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(55) NOT NULL COMMENT '姓名',
`level` tinyint(2) NOT NULL COMMENT '账号等级',
`nick_Name` varchar(55) NOT NULL COMMENT '昵称',
`mem_HomePage` varchar(255) NOT NULL COMMENT '个人主页',
`mem_IP` varchar(255) NOT NULL COMMENT '登录IP地址',
`qq` int(65) NOT NULL COMMENT '用户QQ',
`phone` varchar(255) NOT NULL COMMENT '手机号',
`email` varchar(255) NOT NULL COMMENT '邮箱',
`brief_Introduction` varchar(255) NOT NULL COMMENT '简介',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '张三 ', '5', '小张', 'www.baidu.com', '127.0.0.1', '123456789', '123456789022222222222', '123@qq.com', '我是张三！叫我小张就行了。');
INSERT INTO `user` VALUES ('2', '李四', '5', '小李', 'www.baidu.com', '127.0.0.1', '123456789', '123456789022222222222', '123@qq.com', '我是李四！叫我小李就行了。');