CREATE TABLE `hr_forms` (
  `hr_id` varchar(200) NOT NULL default '0',
  `formtype` varchar(30) default NULL,
  `language` char(2) NOT NULL default '',
  `registrationdate` varchar(20) NOT NULL default '',
  `formshortcut` varchar(25) NOT NULL default '',
  `lastname` varchar(30) default NULL,
  `firstname` varchar(30) default NULL,
  `service` varchar(30) default NULL,
  `service2` varchar(30) default NULL,
  `division` varchar(30) default NULL,
  `departmentnbr` varchar(10) default NULL,
  `jobtitle` varchar(30) default NULL,
  `mainmission` varchar(250) default NULL,
  `contracttype` varchar(10) default NULL,
  `duration` varchar(10) default NULL,
  `startdate` varchar(10) default NULL,
  `enddate` varchar(10) default NULL,
  `reason` varchar(20) default NULL,
  `fullreason` varchar(100) default NULL,
  `employeename` varchar(30) default NULL,
  `officelocation` varchar(20) default NULL,
  `status` varchar(10) default NULL,
  `compensation` varchar(10) default NULL,
  `working_hours` varchar(10) default NULL,
  `bonus` varchar(10) default NULL,
  `education_req` varchar(250) default NULL,
  `experience_req` varchar(250) default NULL,
  `englishlevel` varchar(100) default NULL,
  `computerskills` varchar(250) default NULL,
  `specific_req` varchar(250) default NULL,
  `personal_req` varchar(250) default NULL,
  `comments` varchar(250) default NULL,
  `file_path` varchar(150) default NULL,
  UNIQUE KEY `hr_id` (`hr_id`)
) TYPE=MyISAM;