MySql语句

--用户信息表
drop table if exists tb_user;
create table tb_user
(
   userID int not null primary key auto_increment,
   password varchar(12) not null ,
   phoneNum varchar(11) null,
   address varchar(50) null,
   maill char(50) not null
)default charset=utf8;


--留言信息表
drop table if exists tb_message;
create table tb_message
(
	messageID int not null primary key auto_increment,
	title char(20) not null ,
	content varchar(100) not null,
	userID int not null,
	foreign key(userID) references tb_user(userID)
)default charset=utf8;