
-- ----------------------------
-- Table structure for `diets`
-- ----------------------------
CREATE TABLE `diets` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of diets
-- ----------------------------
INSERT INTO `diets` VALUES ('1', 'standard', '1', null);
INSERT INTO `diets` VALUES ('2', 'vegetarian', '1', null);
INSERT INTO `diets` VALUES ('3', 'vegan', '1', null);
INSERT INTO `diets` VALUES ('4', 'meatarian', '0', null);

-- ----------------------------
-- Table structure for `disabilities`
-- ----------------------------
CREATE TABLE `disabilities` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of disabilities
-- ----------------------------
INSERT INTO `disabilities` VALUES ('1', 'blind', '1', null);
INSERT INTO `disabilities` VALUES ('2', 'deaf', '1', null);
INSERT INTO `disabilities` VALUES ('3', 'dumb', '1', null);
INSERT INTO `disabilities` VALUES ('4', 'on a wheelchair', '1', null);
INSERT INTO `disabilities` VALUES ('5', 'motorically disabled not on a wheelchair', '1', null);
INSERT INTO `disabilities` VALUES ('6', 'an organiser will be responsible for the disability aspect during the event', '1', null);
INSERT INTO `disabilities` VALUES ('7', 'an accompanying person (a facilitator) can be hosted to take care of the person with disability', '1', null);

-- ----------------------------
-- Table structure for `focusareas`
-- ----------------------------
CREATE TABLE `focusareas` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of focusareas
-- ----------------------------
INSERT INTO `focusareas` VALUES ('1', 'Youth Participation', '1', null);
INSERT INTO `focusareas` VALUES ('2', 'Bridging Europe', '1', null);
INSERT INTO `focusareas` VALUES ('3', 'Inclusion of Minorities', '1', null);

-- ----------------------------
-- Table structure for `mainfieldsofactions`
-- ----------------------------
CREATE TABLE `mainfieldsofactions` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mainfieldsofactions
-- ----------------------------
INSERT INTO `mainfieldsofactions` VALUES ('1', 'Active Citizenship', '1', null);
INSERT INTO `mainfieldsofactions` VALUES ('2', 'Peace and Stability', '1', null);
INSERT INTO `mainfieldsofactions` VALUES ('3', 'Higher Education', '1', null);
INSERT INTO `mainfieldsofactions` VALUES ('4', 'Cultural Exchange', '1', null);

-- ----------------------------
-- Table structure for `ranges`
-- ----------------------------
CREATE TABLE `ranges` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ranges
-- ----------------------------
INSERT INTO `ranges` VALUES ('1', 'Local', '1', null);
INSERT INTO `ranges` VALUES ('2', 'Regional', '1', null);
INSERT INTO `ranges` VALUES ('3', 'National', '1', null);
INSERT INTO `ranges` VALUES ('4', 'European', '1', null);
INSERT INTO `ranges` VALUES ('5', 'International', '1', null);

-- ----------------------------
-- Table structure for `themes`
-- ----------------------------
CREATE TABLE `themes` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of themes
-- ----------------------------
INSERT INTO `themes` VALUES ('1', 'representing views and interests of young people in their diversity at European ', '1', null);
INSERT INTO `themes` VALUES ('2', 'youth exchange and voluntary service', '1', null);
INSERT INTO `themes` VALUES ('3', 'non-formal and informal learning', '1', null);
INSERT INTO `themes` VALUES ('4', 'intercultural learning and understanding', '1', null);
INSERT INTO `themes` VALUES ('5', 'debate on European matters', '1', null);
INSERT INTO `themes` VALUES ('6', 'dissemination of information on EU action', '1', null);
INSERT INTO `themes` VALUES ('7', 'actions promoting participation and initiative by young people', '1', null);

-- ----------------------------
-- Table structure for `types`
-- ----------------------------
CREATE TABLE `types` (
  `id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of types
-- ----------------------------
INSERT INTO `types` VALUES ('1', 'Network Meeting', '1', null);
INSERT INTO `types` VALUES ('2', 'Conference', '1', null);
INSERT INTO `types` VALUES ('3', 'Training Course', '1', null);
INSERT INTO `types` VALUES ('4', 'Seminar', '1', null);
INSERT INTO `types` VALUES ('5', 'Workshop', '1', null);
INSERT INTO `types` VALUES ('6', 'Summer University', '1', null);
INSERT INTO `types` VALUES ('7', 'Winter University', '1', null);
INSERT INTO `types` VALUES ('8', 'Thematic Activity', '1', null);
INSERT INTO `types` VALUES ('9', 'Celebration', '1', null);
INSERT INTO `types` VALUES ('10', 'Exchange', '1', null);
INSERT INTO `types` VALUES ('11', 'Recreation', '1', null);
