# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 07, 2005 at 01:59 AM
# Server version: 4.0.15
# PHP Version: 4.3.8
# 
# Database : `wondercare_co_uk`
# 

# --------------------------------------------------------

#
# Table structure for table `applicationform`
#

CREATE TABLE `applicationform` (
  `userid` int(11) NOT NULL default '0',
  `position` varchar(50) default NULL,
  `lastname` varchar(50) default NULL,
  `title` varchar(50) default NULL,
  `firstname` varchar(50) default NULL,
  `sex` char(1) default NULL,
  `address` varchar(255) default NULL,
  `workaddress` varchar(255) default NULL,
  `telephone` varchar(50) default NULL,
  `worktelephone` varchar(50) default NULL,
  `contactwork` char(1) default NULL,
  `noticeperiod` varchar(50) default NULL,
  `dob` date default NULL,
  `nationality` varchar(50) default NULL,
  `workpermit` char(1) default NULL,
  `goodhealth` char(1) default NULL,
  `healthreasons` varchar(255) default NULL,
  `nosickdays` int(11) default NULL,
  `annualsalary` float default NULL,
  `school1` varchar(255) default NULL,
  `exams1` varchar(255) default NULL,
  `examdate1` varchar(50) default NULL,
  `examgrades1` varchar(50) default NULL,
  `school2` varchar(255) default NULL,
  `school3` varchar(255) default NULL,
  `school4` varchar(255) default NULL,
  `school5` varchar(255) default NULL,
  `school6` varchar(255) default NULL,
  `exams2` varchar(255) default NULL,
  `exams3` varchar(255) default NULL,
  `exams4` varchar(255) default NULL,
  `exams5` varchar(255) default NULL,
  `exams6` varchar(255) default NULL,
  `examdate2` varchar(50) default NULL,
  `examdate3` varchar(50) default NULL,
  `examdate4` varchar(50) default NULL,
  `examdate5` varchar(50) default NULL,
  `examdate6` varchar(50) default NULL,
  `examgrades2` varchar(50) default NULL,
  `examgrades3` varchar(50) default NULL,
  `examgrades4` varchar(50) default NULL,
  `examgrades5` varchar(50) default NULL,
  `examgrades6` varchar(50) default NULL,
  `interests` text,
  `ref1` varchar(255) default NULL,
  `refaddr1` varchar(255) default NULL,
  `refphone1` varchar(50) default NULL,
  `reffax1` varchar(50) default NULL,
  `refjob1` varchar(50) default NULL,
  `ref2` varchar(50) default NULL,
  `refaddr2` varchar(255) default NULL,
  `refphone2` varchar(50) default NULL,
  `reffax2` varchar(50) default NULL,
  `refjob2` varchar(50) default NULL,
  `contactref` char(1) default NULL,
  `employer1` varchar(255) default NULL,
  `jobtitle1` varchar(50) default NULL,
  `jobdates1` varchar(50) default NULL,
  `jobreason1` varchar(255) default NULL,
  `employer2` varchar(255) default NULL,
  `employer3` varchar(255) default NULL,
  `employer4` varchar(255) default NULL,
  `employer5` varchar(255) default NULL,
  `employer6` varchar(255) default NULL,
  `jobtitle2` varchar(50) default NULL,
  `jobtitle3` varchar(50) default NULL,
  `jobtitle4` varchar(50) default NULL,
  `jobtitle5` varchar(50) default NULL,
  `jobtitle6` varchar(50) default NULL,
  `jobdates2` varchar(50) default NULL,
  `jobdates3` varchar(50) default NULL,
  `jobdates4` varchar(50) default NULL,
  `jobdates5` varchar(50) default NULL,
  `jobdates6` varchar(50) default NULL,
  `jobreason2` varchar(255) default NULL,
  `jobreason3` varchar(255) default NULL,
  `jobreason4` varchar(255) default NULL,
  `jobreason5` varchar(255) default NULL,
  `jobreason6` varchar(255) default NULL,
  `reasonforapplying` text,
  `criminalconviction` char(1) NOT NULL default '',
  `criminaldetails` text NOT NULL,
  `whichadvert` varchar(255) NOT NULL default '',
  `appdate` varchar(12) NOT NULL default ''
) TYPE=MyISAM COMMENT='Application form';

#
# Dumping data for table `applicationform`
#

INSERT INTO `applicationform` VALUES (12, 'secretary II', 'akande', 'Mr', 'ah', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', 0, '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' \r\n  jogging?\r\n  \r\n  \r\n  \r\n  \r\n ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' \r\n  laughter\r\n  \r\n  \r\n  \r\n  \r\n ', 'n', ' \r\n  \r\n  \r\n ', 'papers23', '');
