CREATE TABLE user_info( \
id INT NOT NULL AUTO_INCREMENT,\
username VARCHAR(64) NOT NULL UNIQUE,\
password VARCHAR(64) NOT NULL UNIQUE,\
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\
index(id)\
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
create table shell_history(\
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\
username VARCHAR(64) NOT NULL,\
command VARCHAR(256) NOT NULL UNIQUE,\
date DATETIME NOT NULL,\
CONSTRAINT fk_username\
foreign key (username)\
references user_info(username)\
ON DELETE RESTRICT ON UPDATE RESTRICT\
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;