
use university; -- change to your own database name

drop table enrollment;
drop table student;

create table student (
  student_id int not null auto_increment,
  last_name varchar(100) not null,
  primary key(student_id)
) engine=InnoDB;

create table enrollment (
  student_id int not null,
  foreign key (student_id) references student(student_id) on delete cascade,
  instance_id int not null
) engine=InnoDB;

load data infile "/tmp/students.csv" into table student;

insert into enrollment values (1,2);

