-- ----------------------------
-- Table structure for `applications`
-- ----------------------------
CREATE TABLE `applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL COMMENT '11.111.111.111',
  `status` tinyint(2) NOT NULL,
  `answerOne` varchar(200) DEFAULT NULL,
  `answerTwo` varchar(200) DEFAULT NULL,
  `answerThree` varchar(200) DEFAULT NULL,
  `motivation` varchar(1000) NOT NULL,
  `diet` tinyint(2) NOT NULL,
  `visa` tinyint(1) NOT NULL,
  `passportNumber` varchar(50) DEFAULT NULL,
  `nationality` varchar(3) DEFAULT NULL,
  `placeOfBirth` varchar(200) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `events`
-- ----------------------------
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `localOrganisers` varchar(100) NOT NULL,
  `europeanOrganisers` varchar(100) DEFAULT NULL,
  `status` int(2) NOT NULL,
  `title` varchar(150) NOT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `range` int(2) DEFAULT NULL,
  `type` int(2) DEFAULT NULL,
  `arrival` date DEFAULT NULL,
  `departure` date DEFAULT NULL,
  `applicationStart` date DEFAULT NULL,
  `applicationEnd` date DEFAULT NULL,
  `place` varchar(400) DEFAULT NULL,
  `fee` decimal(5,2) DEFAULT NULL,
  `accomPlace` tinyint(2) DEFAULT NULL,
  `accomCapacity` tinyint(2) DEFAULT NULL,
  `accomType` tinyint(2) DEFAULT NULL,
  `participants` int(4) DEFAULT NULL,
  `disabled` int(4) DEFAULT NULL,
  `disabledAccepted` varchar(100) DEFAULT NULL,
  `omsHandlesApplications` tinyint(1) DEFAULT NULL,
  `applicationLink` varchar(1000) DEFAULT NULL,
  `contactUid` varchar(100) DEFAULT NULL,
  `contactEmail` varchar(100) DEFAULT NULL,
  `contactPhone` varchar(20) DEFAULT NULL,
  `url` varchar(1000) DEFAULT NULL,
  `facebook` varchar(1000) DEFAULT NULL,
  `idealParticipant` varchar(100) DEFAULT NULL,
  `mainFieldsOfAction` varchar(10) DEFAULT NULL,
  `focusArea` varchar(10) DEFAULT NULL,
  `focusOther` varchar(50) DEFAULT NULL,
  `theme` tinyint(2) DEFAULT NULL,
  `programme` varchar(1500) DEFAULT NULL,
  `photos` varchar(1500) DEFAULT NULL,
  `questionOne` varchar(400) NOT NULL,
  `questionTwo` varchar(400) NOT NULL,
  `questionThree` varchar(400) NOT NULL,
  PRIMARY KEY (`id`)
)  ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
