/*

Navicat MySQL Data Transfer

Source Server : mysql

Source Server Version : 50633

Source Host : localhost

Source Database : classwork

Target Server Version : 50633

File Encoding : utf-8

Date: 07/19/2017 00:00:02 AM

*/

SET NAMES utf8;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for `tbl_user`

-- ----------------------------

DROP TABLE IF EXISTS `tbl_user`;

CREATE TABLE `tbl_user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(40) NOT NULL,

`password` varchar(40) NOT NULL,

`email` varchar(40) DEFAULT NULL,

`fullname` varchar(40) DEFAULT NULL,

`idcard` varchar(40) DEFAULT NULL,

`registertime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`logintime` timestamp NULL DEFAULT '0000-00-00 00:00:00',

`registerIp` varchar(40) DEFAULT NULL,

`tel` varchar(20) DEFAULT NULL,

`nickname` varchar(40) DEFAULT NULL,

`sex` varchar(2) DEFAULT NULL,

`qq` varchar(10) DEFAULT NULL,

`address` varchar(100) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;