drop database if exists tt;

create database tt default character set utf8;

use tt;

create table admin_tb(

	id int(11) auto_increment primary key,

	username varchar(20) not null unique,

	password varchar(20) not null,

	name varchar(10) not null,

	createtime timestamp default current_timestamp

)engine=InnoDB auto_increment=1 default charset=utf8;

INSERT INTO admin_tb (username,password,name) VALUES ('xx','xx','xx');

create table user_tb(

	id int(11) auto_increment primary key,

	username varchar(20) not null unique,

	password varchar(20) not null,

	name varchar(20) not null,

	nicknamek varchar(20),

	sex varchar(1) check(sex='男' or sex='女'),

	birth date,

	phone varchar(15),

	qq varchar(11),

	integral int(5) default 5,

	signature varchar(200),

	avater varchar(200),  /*头像*/

	status int(2) default 1,

	createtime timestamp default current_timestamp

)engine=InnoDB auto_increment=1 default charset=utf8;

INSERT INTO user_tb (username,password,name,nicknamek,sex,birth,phone,qq,integral,signature)

	VALUES ('xx','xx','xx','xx','m','1996-7-27','33','33','5','from xx');

INSERT INTO user_tb (username,password,name,nicknamek,sex,birth,phone,qq,integral,signature)

	VALUES ('xx','xx','xx','xx','m','1996-7-27','333','33','5','from xx');