Department database design (13) - Create graduate student database

Create new table students:
DROP TABLE IF EXISTS `ubc_surgery_pub`.`students`;
CREATE TABLE  `ubc_surgery_pub`.`students` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `firstname` varchar(127) NOT NULL default '',
  `lastname` varchar(127) NOT NULL default '',
  `position` varchar(63) NOT NULL default '',
  `program` varchar(100) NOT NULL default '',
  `degree` varchar(63) NOT NULL default '',
  `email` varchar(127) NOT NULL default '',
  `pi_id` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY  (`id`),
  KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 
 C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\index.php, line 548 add
  <li><a href="./?action=importcsvstudent">Import students via csv file </a></li> 
line 97 add
case 'importcsvstudent':
  require_once('superadmin/importcsvstudent.php');
  break;   

copy superadmin/importcsvuser.php to superadmin/importcsvstudent.php and modify

C:\Users\jiansen\Desktop\CAS\jiansen_dir\www_cesei0_mobile\ubc_surgery_pub\scripts\manage\common.php