USE studentbmj;
CREATE TABLE elective(
id int(6) unsigned NOT NULL auto_increment,

name varchar(128),
email varchar(128),
country varchar(128),
year varchar(128),
institute varchar(128),
language varchar(128),
period varchar(128),
hospital TEXT,
speciality TEXT,
tasks TEXT,
teaching TEXT,
lang_dif TEXT,
med_studies TEXT,
social TEXT,
difficulties TEXT,
good TEXT,
improve TEXT,
advice TEXT,
comments TEXT,
approve varchar(4), 
IP varchar(25),
date char(35) DEFAULT '0000-00-00' NOT NULL,
PRIMARY KEY (id));