1、创建一个保存用户的user表
CREATE table IF NOT EXISTS `user`(
`uid` INT AUTO_INCREMENT PRIMARY KEY,
`username` VARCHAR(20) NOT NULL,
`email` VARCHAR(50) NOT NULL,
`sex` VARCHAR(10) NOT NULL,
`password` VARCHAR(32) NOT NULL,
`picture` VARCHAR(50) default '/image/default.jpg',
`time` DATE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
如图:
2、创建保存留言的message表
CREATE table IF NOT EXISTS `message`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`content` VARCHAR(100) NOT NULL,
`uid` INT NOT NULL,
`ip` VARCHAR(20) NOT NULL,
`time` DATETIME,
FOREIGN KEY (uid) REFERENCES user(uid) on delete cascade on update no action
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
如图: