1.建立表脚本
CREATE DATABASE `spring` DEFAULT CHARACTER SET utf8; USE `spring`; CREATE TABLE `account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `password` varchar(45) NOT NULL, `birthday` datetime NOT NULL, `email` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; CREATE TABLE `account_flow` ( `id` int(11) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `add_time` datetime DEFAULT CURRENT_TIMESTAMP, `flag` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE DATABASE `spring` DEFAULT