wget http://labfile.oss.aliyuncs.com/contestlou2/loudatabase.zip
unzip loudatabase.zip;

sudo service mysql start;
mysql -uroot;

create database shiyanlou;
use shiyanlou;

create user 'shiyanlou' @ 'localhost' identified by 'shiyanlou';
grant all privileges on shiyanlou.* to 'shiyanlou'@'localhost';

create table user(
	id int NOT NULL,
	name varchar(10) NOT NULL,
	PRIMARY KEY(id)
	);
load data infile  '/home/shiyanlou/loudatabase/shiyanlou_user.csv'  into table user fields terminated by',';

create table course(
	id int NOT NULL,
	name varchar(30) NOT NULL,
	PRIMARY KEY(id)
	);
load data infile '/home/shiyanlou/loudatabase/shiyanlou_course.csv' into table course fields terminated by',';

create table usercourse(
	id int NOT NULL AUTO_INCREMENT,
	user_id int NOT NULL,
	course_id int NOT NULL,
	study_time int NOT NULL,
	PRIMARY KEY(id),
	FOREIGN KEY(user_id) REFERENCES user(id),
	FOREIGN KEY(course_id) REFERENCES course(id)
	);
load data infile '/home/shiyanlou/loudatabase/shiyanlou_usercourse.csv' into table usercourse fields terminated by','(user_id,course_id,study_time);