DROP TABLE Students;
DROP TABLE Subjects;

CREATE TABLE Students (
  ID bigint(20) DEFAULT '0' NOT NULL auto_increment,
  Givenname varchar(20) DEFAULT ',' NOT NULL,
  Surname varchar(40) DEFAULT ',' NOT NULL,
  PRIMARY KEY (ID)
);

CREATE TABLE Subjects (
  ID bigint(20) DEFAULT '0' NOT NULL auto_increment,
  Student_ID bigint(20) DEFAULT '0' NOT NULL,
  SUBJECT_CODE varchar(20) DEFAULT ',' NOT NULL,
  PRIMARY KEY (ID)
);