-- --------------------------------------------------------
-- Host:                         bgbm-import
-- Server Version:               5.5.47-0+deb8u1 - (Debian)
-- Server Betriebssystem:        debian-linux-gnu
-- HeidiSQL Version:             9.3.0.5056
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Exportiere Struktur von Tabelle wfo.country
CREATE TABLE IF NOT EXISTS `country` (
  `countryid` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(255) NOT NULL DEFAULT '',
  `iso` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`countryid`)
) ENGINE=InnoDB AUTO_INCREMENT=270 DEFAULT CHARSET=utf8;


-- Exportiere Daten aus Tabelle wfo.country: ~266 rows (ungefähr)
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT IGNORE INTO `country` (`countryid`, `country`, `iso`) VALUES
	(1, 'Bangladesh', 'BD'),
	(2, 'Belgium', 'BE'),
	(3, 'Burkina Faso', 'BF'),
	(4, 'Bulgaria', 'BG'),
	(5, 'Bosnia and Herzegovina', 'BA'),
	(6, 'Barbados', 'BB'),
	(7, 'Wallis and Futuna', 'WF'),
	(8, 'Saint Barthélemy', 'BL'),
	(9, 'Bermuda', 'BM'),
	(10, 'Brunei Darussalam', 'BN'),
	(11, 'Bolivia, Plurinational State of', 'BO'),
	(12, 'Bahrain', 'BH'),
	(13, 'Burundi', 'BI'),
	(14, 'Benin', 'BJ'),
	(15, 'Bhutan', 'BT'),
	(16, 'Jamaica', 'JM'),
	(17, 'Bouvet Island', 'BV'),
	(18, 'Botswana', 'BW'),
	(19, 'Samoa', 'WS'),
	(20, 'Bonaire, Sint Eustatius and Saba', 'BQ'),
	(21, 'Brazil', 'BR'),
	(22, 'Bahamas', 'BS'),
	(23, 'Jersey', 'JE'),
	(24, 'Belarus', 'BY'),
	(25, 'Belize', 'BZ'),
	(28, 'Russian Federation', 'RU'),
	(29, 'Rwanda', 'RW'),
	(30, 'Serbia', 'RS'),
	(31, 'Timor-Leste', 'TL'),
	(32, 'Réunion', 'RE'),
	(33, 'Turkmenistan', 'TM'),
	(34, 'Tajikistan', 'TJ'),
	(35, 'Romania', 'RO'),
	(36, 'Tokelau', 'TK'),
	(37, 'Guinea-Bissau', 'GW'),
	(38, 'Guam', 'GU'),
	(39, 'Guatemala', 'GT'),
	(40, 'South Georgia and the South Sandwich Islands', 'GS'),
	(41, 'Greece', 'GR'),
	(42, 'Equatorial Guinea', 'GQ'),
	(43, 'Guadeloupe', 'GP'),
	(44, 'Japan', 'JP'),
	(45, 'Guyana', 'GY'),
	(46, 'Guernsey', 'GG'),
	(47, 'French Guiana', 'GF'),
	(48, 'Georgia', 'GE'),
	(49, 'Grenada', 'GD'),
	(50, 'United Kingdom', 'GB'),
	(51, 'Gabon', 'GA'),
	(52, 'Guinea', 'GN'),
	(53, 'Gambia', 'GM'),
	(54, 'Greenland', 'GL'),
	(55, 'Gibraltar', 'GI'),
	(56, 'Ghana', 'GH'),
	(57, 'Oman', 'OM'),
	(58, 'Tunisia', 'TN'),
	(59, 'Jordan', 'JO'),
	(60, 'Croatia', 'HR'),
	(61, 'Haiti', 'HT'),
	(62, 'Hungary', 'HU'),
	(63, 'Hong Kong', 'HK'),
	(64, 'Honduras', 'HN'),
	(65, 'Heard Island and McDonald Islands', 'HM'),
	(66, 'Venezuela, Bolivarian Republic of', 'VE'),
	(67, 'Puerto Rico', 'PR'),
	(68, 'Palestine, State of', 'PS'),
	(69, 'Palau', 'PW'),
	(70, 'Portugal', 'PT'),
	(71, 'Saint Kitts and Nevis', 'KN'),
	(72, 'Paraguay', 'PY'),
	(73, 'Iraq', 'IQ'),
	(74, 'Panama', 'PA'),
	(75, 'French Polynesia', 'PF'),
	(76, 'Papua New Guinea', 'PG'),
	(77, 'Peru', 'PE'),
	(78, 'Pakistan', 'PK'),
	(79, 'Philippines', 'PH'),
	(80, 'Pitcairn', 'PN'),
	(81, 'Poland', 'PL'),
	(82, 'Saint Pierre and Miquelon', 'PM'),
	(83, 'Zambia', 'ZM'),
	(84, 'Western Sahara', 'EH'),
	(85, 'Estonia', 'EE'),
	(86, 'Egypt', 'EG'),
	(87, 'South Africa', 'ZA'),
	(88, 'Ecuador', 'EC'),
	(89, 'Italy', 'IT'),
	(90, 'Unknown or unspecified America', 'XL'),
	(91, 'Viet Nam', 'VN'),
	(92, 'Unknown or unspecified country', 'ZZ'),
	(93, 'Solomon Islands', 'SB'),
	(94, 'Ethiopia', 'ET'),
	(95, 'Somalia', 'SO'),
	(96, 'Zimbabwe', 'ZW'),
	(97, 'Saudi Arabia', 'SA'),
	(98, 'Spain', 'ES'),
	(99, 'Eritrea', 'ER'),
	(100, 'Montenegro', 'ME'),
	(101, 'Moldova, Republic of', 'MD'),
	(102, 'Madagascar', 'MG'),
	(103, 'Saint Martin (French part)', 'MF'),
	(104, 'Morocco', 'MA'),
	(105, 'Monaco', 'MC'),
	(106, 'Uzbekistan', 'UZ'),
	(107, 'Myanmar', 'MM'),
	(108, 'Mali', 'ML'),
	(109, 'Macao', 'MO'),
	(110, 'Mongolia', 'MN'),
	(111, 'Marshall Islands', 'MH'),
	(112, 'Macedonia, Republic of', 'MK'),
	(113, 'Mauritius', 'MU'),
	(114, 'Malta', 'MT'),
	(115, 'Malawi', 'MW'),
	(116, 'Maldives', 'MV'),
	(117, 'Martinique', 'MQ'),
	(118, 'Northern Mariana Islands', 'MP'),
	(119, 'Montserrat', 'MS'),
	(120, 'Mauritania', 'MR'),
	(121, 'Isle of Man', 'IM'),
	(122, 'Uganda', 'UG'),
	(123, 'Tanzania, United Republic of', 'TZ'),
	(124, 'Malaysia', 'MY'),
	(125, 'Mexico', 'MX'),
	(126, 'Israel', 'IL'),
	(127, 'France', 'FR'),
	(128, 'Aruba', 'AW'),
	(129, 'Saint Helena, Ascension and Tristan da Cunha', 'SH'),
	(130, 'Unknown or unspecified South America', 'XB'),
	(131, 'Svalbard and Jan Mayen', 'SJ'),
	(132, 'Finland', 'FI'),
	(133, 'Fiji', 'FJ'),
	(134, 'Falkland Islands (Malvinas)', 'FK'),
	(135, 'Micronesia, Federated States of', 'FM'),
	(136, 'Faroe Islands', 'FO'),
	(137, 'Nicaragua', 'NI'),
	(138, 'Netherlands', 'NL'),
	(139, 'Norway', 'NO'),
	(140, 'Namibia', 'NA'),
	(141, 'Vanuatu', 'VU'),
	(142, 'New Caledonia', 'NC'),
	(143, 'Niger', 'NE'),
	(144, 'Norfolk Island', 'NF'),
	(145, 'Nigeria', 'NG'),
	(146, 'New Zealand', 'NZ'),
	(147, 'Nepal', 'NP'),
	(148, 'Nauru', 'NR'),
	(149, 'Niue', 'NU'),
	(150, 'Cook Islands', 'CK'),
	(152, 'Côte d\'Ivoire', 'CI'),
	(153, 'Switzerland', 'CH'),
	(154, 'Colombia', 'CO'),
	(155, 'China', 'CN'),
	(156, 'Cameroon', 'CM'),
	(157, 'Chile', 'CL'),
	(158, 'Cocos (Keeling) Islands', 'CC'),
	(159, 'Unknown or unspecified Asia', 'XC'),
	(160, 'Canada', 'CA'),
	(161, 'Unknown or unspecified Africa', 'XA'),
	(162, 'Congo', 'CG'),
	(163, 'Central African Republic', 'CF'),
	(164, 'Unknown or unspecified Eurasia', 'XD'),
	(165, 'Congo, The Democratic Republic of the', 'CD'),
	(166, 'Czech Republic', 'CZ'),
	(167, 'Cyprus', 'CY'),
	(168, 'Christmas Island', 'CX'),
	(169, 'Costa Rica', 'CR'),
	(170, 'Curaçao', 'CW'),
	(171, 'Cape Verde', 'CV'),
	(172, 'Cuba', 'CU'),
	(173, 'Swaziland', 'SZ'),
	(174, 'Syrian Arab Republic', 'SY'),
	(175, 'Sint Maarten (Dutch part)', 'SX'),
	(176, 'Kyrgyzstan', 'KG'),
	(177, 'Kenya', 'KE'),
	(178, 'South Sudan', 'SS'),
	(179, 'Suriname', 'SR'),
	(180, 'Kiribati', 'KI'),
	(181, 'Cambodia', 'KH'),
	(182, 'El Salvador', 'SV'),
	(183, 'Comoros', 'KM'),
	(184, 'Sao Tome and Principe', 'ST'),
	(185, 'Slovakia', 'SK'),
	(186, 'Korea, Republic of', 'KR'),
	(187, 'Slovenia', 'SI'),
	(188, 'Korea, Democratic People\'s Republic of', 'KP'),
	(189, 'Kuwait', 'KW'),
	(190, 'Senegal', 'SN'),
	(191, 'San Marino', 'SM'),
	(192, 'Sierra Leone', 'SL'),
	(193, 'Seychelles', 'SC'),
	(194, 'Kazakhstan', 'KZ'),
	(195, 'Cayman Islands', 'KY'),
	(196, 'Singapore', 'SG'),
	(197, 'Sweden', 'SE'),
	(198, 'Sudan', 'SD'),
	(199, 'Dominican Republic', 'DO'),
	(200, 'Dominica', 'DM'),
	(201, 'Djibouti', 'DJ'),
	(202, 'Denmark', 'DK'),
	(203, 'Virgin Islands, British', 'VG'),
	(204, 'Unknown or unspecified Central or North America', 'XF'),
	(205, 'Germany', 'DE'),
	(206, 'Yemen', 'YE'),
	(208, 'Algeria', 'DZ'),
	(209, 'United States', 'US'),
	(210, 'Uruguay', 'UY'),
	(211, 'Mayotte', 'YT'),
	(212, 'Unknown or unspecified Oceania', 'XO'),
	(213, 'United States Minor Outlying Islands', 'UM'),
	(214, 'Lebanon', 'LB'),
	(215, 'Saint Lucia', 'LC'),
	(216, 'Lao People\'s Democratic Republic', 'LA'),
	(217, 'Tuvalu', 'TV'),
	(218, 'Taiwan, Province of China', 'TW'),
	(219, 'Trinidad and Tobago', 'TT'),
	(220, 'Turkey', 'TR'),
	(221, 'Sri Lanka', 'LK'),
	(222, 'Liechtenstein', 'LI'),
	(223, 'Latvia', 'LV'),
	(224, 'Tonga', 'TO'),
	(225, 'Lithuania', 'LT'),
	(226, 'Luxembourg', 'LU'),
	(227, 'Liberia', 'LR'),
	(228, 'Lesotho', 'LS'),
	(229, 'Thailand', 'TH'),
	(230, 'French Southern Territories', 'TF'),
	(231, 'Togo', 'TG'),
	(232, 'Chad', 'TD'),
	(233, 'Turks and Caicos Islands', 'TC'),
	(234, 'Libya', 'LY'),
	(235, 'Holy See (Vatican City State)', 'VA'),
	(237, 'Saint Vincent and the Grenadines', 'VC'),
	(238, 'United Arab Emirates', 'AE'),
	(239, 'Andorra', 'AD'),
	(240, 'Antigua and Barbuda', 'AG'),
	(241, 'Afghanistan', 'AF'),
	(242, 'Anguilla', 'AI'),
	(243, 'Virgin Islands, U.S.', 'VI'),
	(244, 'Iceland', 'IS'),
	(245, 'Iran, Islamic Republic of', 'IR'),
	(246, 'Armenia', 'AM'),
	(247, 'Albania', 'AL'),
	(248, 'Angola', 'AO'),
	(250, 'Antarctica', 'AQ'),
	(251, 'American Samoa', 'AS'),
	(252, 'Argentina', 'AR'),
	(253, 'Australia', 'AU'),
	(254, 'Austria', 'AT'),
	(255, 'British Indian Ocean Territory', 'IO'),
	(256, 'India', 'IN'),
	(257, 'Åland Islands', 'AX'),
	(259, 'Azerbaijan', 'AZ'),
	(260, 'Ireland', 'IE'),
	(261, 'Indonesia', 'ID'),
	(262, 'Unknown or unspecified Europe', 'XE'),
	(263, 'Ukraine', 'UA'),
	(264, 'Qatar', 'QA'),
	(265, 'Mozambique', 'MZ');

/*!40000 ALTER TABLE `country` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle wfo.countryToOceanOrContinent
CREATE TABLE IF NOT EXISTS `countryToOceanOrContinent` (
  `fk_countryid` int(11) NOT NULL,
  `fk_oceanOrContinentid` int(11) NOT NULL,
  PRIMARY KEY (`fk_countryid`,`fk_oceanOrContinentid`),
  KEY `idxParentid` (`fk_oceanOrContinentid`),
  CONSTRAINT `fk_countryToOceanOrContinent_1` FOREIGN KEY (`fk_countryid`) REFERENCES `country` (`countryid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_countryToOceanOrContinent_2` FOREIGN KEY (`fk_oceanOrContinentid`) REFERENCES `oceanOrContinent` (`oceanOrContinentid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle wfo.countryToOceanOrContinent: ~402 rows (ungefähr)
/*!40000 ALTER TABLE `countryToOceanOrContinent` DISABLE KEYS */;
INSERT IGNORE INTO `countryToOceanOrContinent` (`fk_countryid`, `fk_oceanOrContinentid`) VALUES
	(1, 11),
	(2, 10),
	(3, 12),
	(4, 10),
	(5, 10),
	(6, 15),
	(6, 61),
	(7, 4),
	(7, 10),
	(7, 16),
	(8, 10),
	(8, 15),
	(8, 61),
	(9, 1),
	(9, 10),
	(9, 15),
	(10, 11),
	(11, 14),
	(12, 11),
	(13, 12),
	(14, 12),
	(15, 11),
	(16, 15),
	(16, 61),
	(17, 1),
	(17, 10),
	(17, 84),
	(17, 176),
	(18, 12),
	(19, 4),
	(19, 16),
	(20, 10),
	(20, 15),
	(20, 61),
	(21, 14),
	(22, 1),
	(22, 15),
	(23, 1),
	(23, 10),
	(24, 10),
	(25, 15),
	(28, 10),
	(28, 11),
	(29, 12),
	(30, 10),
	(31, 3),
	(31, 11),
	(32, 3),
	(32, 10),
	(32, 12),
	(33, 11),
	(34, 11),
	(35, 10),
	(36, 4),
	(36, 16),
	(37, 12),
	(38, 4),
	(38, 15),
	(38, 16),
	(39, 15),
	(40, 1),
	(40, 10),
	(40, 84),
	(40, 176),
	(41, 10),
	(42, 12),
	(43, 10),
	(43, 15),
	(43, 61),
	(44, 4),
	(44, 11),
	(45, 14),
	(46, 1),
	(46, 10),
	(47, 10),
	(47, 14),
	(48, 10),
	(48, 11),
	(49, 15),
	(49, 61),
	(50, 1),
	(50, 10),
	(51, 12),
	(52, 12),
	(53, 12),
	(54, 1),
	(54, 10),
	(54, 15),
	(55, 10),
	(56, 12),
	(57, 11),
	(58, 12),
	(59, 11),
	(60, 10),
	(61, 15),
	(61, 61),
	(62, 10),
	(63, 11),
	(64, 15),
	(65, 3),
	(65, 16),
	(65, 84),
	(65, 176),
	(66, 14),
	(67, 15),
	(67, 61),
	(68, 11),
	(69, 4),
	(69, 16),
	(70, 10),
	(71, 15),
	(71, 61),
	(72, 14),
	(73, 11),
	(74, 14),
	(74, 15),
	(75, 4),
	(75, 10),
	(75, 16),
	(76, 4),
	(76, 16),
	(77, 14),
	(78, 11),
	(79, 4),
	(79, 11),
	(80, 4),
	(80, 10),
	(80, 16),
	(81, 10),
	(82, 1),
	(82, 10),
	(82, 15),
	(83, 12),
	(84, 12),
	(85, 10),
	(86, 11),
	(86, 12),
	(87, 12),
	(88, 14),
	(89, 10),
	(90, 13),
	(90, 14),
	(90, 15),
	(91, 11),
	(92, 7),
	(93, 4),
	(93, 16),
	(94, 12),
	(95, 12),
	(96, 12),
	(97, 11),
	(98, 10),
	(99, 12),
	(100, 10),
	(101, 10),
	(102, 3),
	(102, 12),
	(103, 10),
	(103, 15),
	(103, 61),
	(104, 12),
	(105, 10),
	(106, 11),
	(107, 11),
	(108, 12),
	(109, 11),
	(110, 11),
	(111, 4),
	(111, 16),
	(112, 10),
	(113, 3),
	(113, 12),
	(114, 10),
	(114, 76),
	(115, 12),
	(116, 3),
	(116, 11),
	(117, 10),
	(117, 15),
	(117, 61),
	(118, 4),
	(118, 15),
	(118, 16),
	(119, 10),
	(119, 15),
	(119, 61),
	(120, 12),
	(121, 1),
	(121, 10),
	(122, 12),
	(123, 12),
	(124, 11),
	(125, 15),
	(126, 11),
	(127, 10),
	(128, 10),
	(128, 14),
	(128, 61),
	(129, 1),
	(129, 10),
	(129, 12),
	(130, 14),
	(131, 2),
	(131, 10),
	(132, 10),
	(133, 4),
	(133, 16),
	(134, 1),
	(134, 10),
	(134, 14),
	(135, 4),
	(135, 16),
	(136, 1),
	(136, 10),
	(137, 15),
	(138, 10),
	(138, 15),
	(139, 10),
	(140, 12),
	(141, 4),
	(141, 16),
	(142, 4),
	(142, 10),
	(142, 16),
	(143, 12),
	(144, 4),
	(144, 16),
	(145, 12),
	(146, 4),
	(146, 16),
	(147, 11),
	(148, 4),
	(148, 16),
	(149, 4),
	(149, 16),
	(150, 4),
	(150, 16),
	(152, 12),
	(153, 10),
	(154, 14),
	(155, 11),
	(156, 12),
	(157, 14),
	(158, 3),
	(158, 11),
	(158, 16),
	(159, 11),
	(160, 15),
	(161, 12),
	(162, 12),
	(163, 12),
	(164, 10),
	(164, 11),
	(165, 12),
	(166, 10),
	(167, 10),
	(167, 76),
	(168, 3),
	(168, 11),
	(168, 16),
	(169, 15),
	(170, 10),
	(170, 15),
	(170, 61),
	(171, 1),
	(171, 12),
	(172, 15),
	(172, 61),
	(173, 12),
	(174, 11),
	(175, 10),
	(175, 15),
	(175, 61),
	(176, 11),
	(177, 12),
	(178, 12),
	(179, 14),
	(180, 4),
	(180, 16),
	(181, 11),
	(182, 15),
	(183, 3),
	(183, 12),
	(184, 1),
	(184, 12),
	(185, 10),
	(186, 11),
	(187, 10),
	(188, 11),
	(189, 11),
	(190, 12),
	(191, 10),
	(192, 12),
	(193, 3),
	(193, 12),
	(194, 10),
	(194, 11),
	(195, 10),
	(195, 15),
	(195, 61),
	(196, 11),
	(197, 10),
	(198, 12),
	(199, 15),
	(199, 61),
	(200, 15),
	(200, 61),
	(201, 12),
	(202, 10),
	(203, 10),
	(203, 15),
	(203, 61),
	(204, 15),
	(205, 10),
	(206, 11),
	(208, 12),
	(209, 15),
	(210, 14),
	(211, 3),
	(211, 12),
	(212, 16),
	(213, 4),
	(213, 15),
	(213, 16),
	(213, 61),
	(214, 11),
	(215, 15),
	(215, 61),
	(216, 11),
	(217, 4),
	(217, 16),
	(218, 11),
	(219, 15),
	(219, 61),
	(220, 10),
	(220, 11),
	(221, 11),
	(222, 10),
	(223, 10),
	(224, 4),
	(224, 16),
	(225, 10),
	(226, 10),
	(227, 12),
	(228, 12),
	(229, 11),
	(230, 3),
	(230, 10),
	(230, 12),
	(230, 84),
	(230, 176),
	(231, 12),
	(232, 12),
	(233, 10),
	(233, 15),
	(233, 61),
	(234, 12),
	(235, 10),
	(237, 15),
	(237, 61),
	(238, 11),
	(239, 10),
	(240, 15),
	(240, 61),
	(241, 11),
	(242, 10),
	(242, 15),
	(242, 61),
	(243, 15),
	(243, 61),
	(244, 1),
	(244, 10),
	(245, 11),
	(246, 11),
	(247, 10),
	(248, 12),
	(250, 176),
	(251, 4),
	(251, 15),
	(251, 16),
	(252, 14),
	(253, 16),
	(254, 10),
	(255, 3),
	(255, 10),
	(255, 11),
	(256, 11),
	(257, 1),
	(257, 10),
	(259, 11),
	(260, 1),
	(260, 10),
	(261, 3),
	(261, 4),
	(261, 11),
	(261, 16),
	(262, 10),
	(263, 10),
	(264, 11),
	(265, 12);
/*!40000 ALTER TABLE `countryToOceanOrContinent` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle wfo.oceanOrContinent
CREATE TABLE IF NOT EXISTS `oceanOrContinent` (
  `oceanOrContinentid` int(11) NOT NULL AUTO_INCREMENT,
  `oceanOrContinent` varchar(155) DEFAULT NULL,
  `parentid` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`oceanOrContinentid`),
  KEY `fk_oceanOrContinent_1_idx` (`parentid`),
  KEY `oceanOrContinent` (`oceanOrContinent`),
  KEY `category` (`category`),
  CONSTRAINT `fk_oceanOrContinent_1` FOREIGN KEY (`parentid`) REFERENCES `oceanOrContinent` (`oceanOrContinentid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle wfo.oceanOrContinent: ~147 rows (ungefähr)
/*!40000 ALTER TABLE `oceanOrContinent` DISABLE KEYS */;
INSERT IGNORE INTO `oceanOrContinent` (`oceanOrContinentid`, `oceanOrContinent`, `parentid`, `type`) VALUES
	(1, 'Atlantic Ocean', 8, 'water', 'ocean'),
	(2, 'Arctic Ocean', 8, 'water', 'ocean'),
	(3, 'Indian Ocean', 8, 'water', 'ocean'),
	(4, 'Pacific Ocean', 8, 'water', 'ocean'),
	(5, 'Southern Ocean', 8, 'water', 'ocean'),
	(6, 'Landlocked Sea', 8, 'water', 'ocean'),
	(7, 'Unknown', 8, NULL, 'continent'),
	(8, 'World', 8, NULL, 'other'),
	(9, 'Eurasia', 8, NULL, 'other'),
	(10, 'Europe', 9, NULL, 'continent'),
	(11, 'Asia', 9, NULL, 'continent'),
	(12, 'Africa', 8, NULL, 'continent'),
	(13, 'America', 8, NULL, 'other'),
	(14, 'South America', 13, NULL, 'continent'),
	(15, 'Central or North America', 13, NULL, 'continent'),
	(16, 'Oceania', 8, NULL, 'continent'),
	(21, 'Aral Sea', 6, 'water', 'sea'),
	(22, 'Caspian Sea', 6, 'water', 'sea'),
	(23, 'Dead Sea', 6, 'water', 'sea'),
	(24, 'Sea of Galilee', 6, 'water', 'sea'),
	(25, 'Salton Sea', 6, 'water', 'sea'),
	(26, 'Great Salt Lake', 6, 'water', 'sea'),
	(27, 'Chott Melrhir', 6, 'water', 'sea'),
	(28, 'Great Lakes', 6, 'water', 'sea'),
	(29, 'Issyk Kul', 6, 'water', 'sea'),
	(30, 'Lake Balkhash', 6, 'water', 'sea'),
	(31, 'Lake Chad', 6, 'water', 'sea'),
	(32, 'Lake Chilwa', 6, 'water', 'sea'),
	(33, 'Lake Turkana', 6, 'water', 'sea'),
	(34, 'Lake Van', 6, 'water', 'sea'),
	(35, 'Namtso', 6, 'water', 'sea'),
	(36, 'Pyramid Lake', 6, 'water', 'sea'),
	(37, 'Qinghai Lake', 6, 'water', 'sea'),
	(38, 'Tonle Sap', 6, 'water', 'sea'),
	(52, 'Adriatic Sea', 1, 'water', 'sea'),
	(53, 'Aegean Sea', 1, 'water', 'sea'),
	(54, 'Alboran Sea', 1, 'water', 'sea'),
	(55, 'Argentine Sea', 1, 'water', 'sea'),
	(56, 'Bay of Bothnia', 1, 'water', 'sea'),
	(57, 'Bay of Fundy', 1, 'water', 'sea'),
	(58, 'Baltic Sea', 1, 'water', 'sea'),
	(59, 'Black Sea', 1, 'water', 'sea'),
	(60, 'Bothnian Sea', 1, 'water', 'sea'),
	(61, 'Caribbean Sea', 1, 'water', 'sea'),
	(62, 'Celtic Sea', 1, 'water', 'sea'),
	(63, 'Central Baltic Sea', 1, 'water', 'sea'),
	(64, 'Chesapeake Bay', 1, 'water', 'sea'),
	(65, 'English Channel', 1, 'water', 'sea'),
	(66, 'Gulf of Bothnia', 1, 'water', 'sea'),
	(67, 'Gulf of Guinea', 1, 'water', 'sea'),
	(68, 'Gulf of Finland', 1, 'water', 'sea'),
	(69, 'Gulf of Mexico', 1, 'water', 'sea'),
	(70, 'Gulf of Sidra', 1, 'water', 'sea'),
	(71, 'Gulf of St. Lawrence', 1, 'water', 'sea'),
	(72, 'Gulf of Venezuela', 1, 'water', 'sea'),
	(73, 'Ionian Sea', 1, 'water', 'sea'),
	(74, 'Irish Sea', 1, 'water', 'sea'),
	(75, 'Marmara Sea', 1, 'water', 'sea'),
	(76, 'Mediterranean Sea', 1, 'water', 'sea'),
	(77, 'Mirtoon Sea', 1, 'water', 'sea'),
	(78, 'North Sea', 1, 'water', 'sea'),
	(79, 'Sea of Azov', 1, 'water', 'sea'),
	(80, 'Sea of Crete', 1, 'water', 'sea'),
	(81, 'Sea of the Hebrides', 1, 'water', 'sea'),
	(82, 'Sargasso Sea', 1, 'water', 'sea'),
	(83, 'Thracian Sea', 1, 'water', 'sea'),
	(84, 'Tyrrhenian Sea', 1, 'water', 'sea'),
	(85, 'Amundsen Gulf', 2, 'water', 'sea'),
	(86, 'Baffin Bay', 2, 'water', 'sea'),
	(87, 'Barents Sea', 2, 'water', 'sea'),
	(88, 'Beaufort Sea', 2, 'water', 'sea'),
	(89, 'Cambridge Bay', 2, 'water', 'sea'),
	(90, 'Chukchi Sea', 2, 'water', 'sea'),
	(91, 'Cold Bay', 2, 'water', 'sea'),
	(92, 'Davis Strait', 2, 'water', 'sea'),
	(93, 'Denmark Strait', 2, 'water', 'sea'),
	(94, 'East Siberian Sea', 2, 'water', 'sea'),
	(95, 'Greenland Sea', 2, 'water', 'sea'),
	(96, 'Hudson Bay', 2, 'water', 'sea'),
	(97, 'James Bay', 2, 'water', 'sea'),
	(98, 'Kara Sea', 2, 'water', 'sea'),
	(99, 'Kara Strait', 2, 'water', 'sea'),
	(101, 'Laptev Sea', 2, 'water', 'sea'),
	(102, 'Lincoln Sea', 2, 'water', 'sea'),
	(103, 'Norwegian Sea', 1, 'water', 'sea'),
	(104, 'White Sea', 2, 'water', 'sea'),
	(105, 'Andaman Sea', 3, 'water', 'sea'),
	(106, 'Arabian Sea', 3, 'water', 'sea'),
	(107, 'Bay of Bengal', 3, 'water', 'sea'),
	(108, 'Gulf of Aden', 3, 'water', 'sea'),
	(109, 'Gulf of Oman', 3, 'water', 'sea'),
	(110, 'Mozambique Channel', 3, 'water', 'sea'),
	(111, 'Persian Gulf', 3, 'water', 'sea'),
	(112, 'Red Sea', 3, 'water', 'sea'),
	(113, 'Timor Sea', 3, 'water', 'sea'),
	(114, 'Arafura Sea', 4, 'water', 'sea'),
	(115, 'Banda Sea', 4, 'water', 'sea'),
	(116, 'Bering Sea', 4, 'water', 'sea'),
	(117, 'Bismarck Sea', 4, 'water', 'sea'),
	(118, 'Bohol Sea', 4, 'water', 'sea'),
	(119, 'Camotes Sea', 4, 'water', 'sea'),
	(120, 'Celebes Sea', 4, 'water', 'sea'),
	(121, 'Ceram Sea', 4, 'water', 'sea'),
	(122, 'Chilean Sea', 4, 'water', 'sea'),
	(123, 'Coral Sea', 4, 'water', 'sea'),
	(124, 'East China Sea', 4, 'water', 'sea'),
	(125, 'Flores Sea', 4, 'water', 'sea'),
	(126, 'Gulf of Alaska', 4, 'water', 'sea'),
	(127, 'Gulf of California', 4, 'water', 'sea'),
	(128, 'Gulf of Carpentaria', 4, 'water', 'sea'),
	(129, 'Gulf of Thailand', 4, 'water', 'sea'),
	(130, 'Halmahera Sea', 4, 'water', 'sea'),
	(131, 'Java Sea', 4, 'water', 'sea'),
	(132, 'Molucca Sea', 4, 'water', 'sea'),
	(133, 'Philippine Sea', 4, 'water', 'sea'),
	(134, 'Savu Sea', 4, 'water', 'sea'),
	(135, 'Sea of Japan', 4, 'water', 'sea'),
	(136, 'Sea of Okhotsk', 4, 'water', 'sea'),
	(137, 'Seto Inland Sea', 4, 'water', 'sea'),
	(138, 'Solomon Sea', 4, 'water', 'sea'),
	(139, 'South China Sea', 4, 'water', 'sea'),
	(140, 'Sulu Sea', 4, 'water', 'sea'),
	(141, 'Tasman Sea', 4, 'water', 'sea'),
	(142, 'Yellow Sea', 4, 'water', 'sea'),
	(143, 'Amundsen Sea', 5, 'water', 'sea'),
	(144, 'Bass Strait', 5, 'water', 'sea'),
	(145, 'Bellingshausen Sea', 5, 'water', 'sea'),
	(146, 'Davis Sea', 5, 'water', 'sea'),
	(147, 'Great Australian Bight', 5, 'water', 'sea'),
	(148, 'Gulf Saint Vincent', 5, 'water', 'sea'),
	(149, 'Ross Sea', 5, 'water', 'sea'),
	(150, 'Scotia Sea', 5, 'water', 'sea'),
	(151, 'Spencer Gulf', 5, 'water', 'sea'),
	(152, 'Weddell Sea', 5, 'water', 'sea'),
	(153, 'Unknown or unspecified Atlantic Ocean', 1, 'water', 'sea'),
	(154, 'Unknown or unspecified Arctic Ocean', 2, 'water', 'sea'),
	(155, 'Unknown or unspecified Indian Ocean', 3, 'water', 'sea'),
	(156, 'Unknown or unspecified Pacific Ocean', 4, 'water', 'sea'),
	(157, 'Unknown or unspecified Southern Ocean', 5, 'water', 'sea'),
	(158, 'Unknown or unspecified Ocean', 7, 'water', 'sea'),
	(171, 'Labrador Sea', 1, 'water', 'sea'),
	(176, 'Antarctica', 8, NULL, 'continent');
/*!40000 ALTER TABLE `oceanOrContinent` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle wfo.protocol
CREATE TABLE IF NOT EXISTS `protocol` (
  `protocolid` int(11) NOT NULL AUTO_INCREMENT,
  `protocolname` varchar(45) NOT NULL DEFAULT '',
  `created_when` datetime DEFAULT NULL,
  PRIMARY KEY (`protocolid`,`protocolname`),
  UNIQUE KEY `protocolid_UNIQUE` (`protocolid`),
  UNIQUE KEY `protocolname_UNIQUE` (`protocolname`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle wfo.protocol: ~4 rows (ungefähr)
/*!40000 ALTER TABLE `protocol` DISABLE KEYS */;
INSERT IGNORE INTO `protocol` (`protocolid`, `protocolname`, `created_when`) VALUES
	(1, 'noprotocol', '2013-06-25 00:00:00'),
	(2, 'biocase_1_3', '2013-06-25 00:00:00'),
	(3, 'manis_digir_1_0', '2013-06-26 00:00:00'),
	(4, 'DwC-A', '2014-01-10 00:00:00');
/*!40000 ALTER TABLE `protocol` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle wfo.standardschema
CREATE TABLE IF NOT EXISTS `standardschema` (
  `schemaid` int(11) NOT NULL AUTO_INCREMENT,
  `schemaname` varchar(45) NOT NULL,
  `schemaurl` text,
  `created_when` datetime DEFAULT NULL,
  PRIMARY KEY (`schemaid`,`schemaname`),
  UNIQUE KEY `schemaid_UNIQUE` (`schemaid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Exportiere Daten aus Tabelle wfo.standardschema: ~5 rows (ungefähr)
/*!40000 ALTER TABLE `standardschema` DISABLE KEYS */;
INSERT IGNORE INTO `standardschema` (`schemaid`, `schemaname`, `schemaurl`, `created_when`) VALUES
	(1, 'noschema', 'nourl', '2013-06-25 00:00:00'),
	(2, 'abcd', 'http://www.tdwg.org/schemas/abcd/2.06', '2013-06-25 00:00:00'),
	(3, 'darwincore', 'http://bnhm.berkeley.edu/DwC/bnhm_dc2_schema.xsd', '2013-06-26 00:00:00'),
	(4, 'abcd', 'http://www.tdwg.org/schemas/abcd/2.1', '2015-02-26 00:00:00'),
	(5, 'DwC-A', 'http://rs.tdwg.org/dwc/', '2014-10-01 00:00:00');
/*!40000 ALTER TABLE `standardschema` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
