-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.16 - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-07-20 14:50:05
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping database structure for dnabank
CREATE DATABASE IF NOT EXISTS `dnabank` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `dnabank`;


-- Dumping structure for table dnabank.abcdmetadata
DROP TABLE IF EXISTS `abcdmetadata`;
CREATE TABLE IF NOT EXISTS `abcdmetadata` (
  `MetadataID` int(11) unsigned NOT NULL DEFAULT '0',
  `DatasetGUID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TechnicalContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `TechnicalContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TechnicalContactPhone` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `TechnicalContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ContentContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactPhone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OtherProviderUDDI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetTitle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetCoverage` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetIconURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetVersionMajor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `DatasetCreators` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetContributors` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OwnerOrganizationName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerOrganizationAbbrev` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerContactPerson` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `OwnerContactRole` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerTelephone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerLogoURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicenseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicensesDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicenseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SourceInstitutionID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `SourceID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `RecordBasis` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`MetadataID`),
  KEY `DatasetGUID` (`DatasetGUID`),
  KEY `SourceInstitutionID` (`SourceInstitutionID`),
  KEY `SourceID` (`SourceID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank.abcdmetadata: 0 rows
/*!40000 ALTER TABLE `abcdmetadata` DISABLE KEYS */;
/*!40000 ALTER TABLE `abcdmetadata` ENABLE KEYS */;


-- Dumping structure for table dnabank.abcdmetadataspecimens
DROP TABLE IF EXISTS `abcdmetadataspecimens`;
CREATE TABLE IF NOT EXISTS `abcdmetadataspecimens` (
  `MetadataID` int(11) unsigned NOT NULL DEFAULT '0',
  `DatasetGUID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TechnicalContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `TechnicalContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TechnicalContactPhone` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `TechnicalContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ContentContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactPhone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContentContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OtherProviderUDDI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetTitle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetCoverage` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetIconURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetVersionMajor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `DatasetCreators` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DatasetContributors` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DateCreated` datetime DEFAULT NULL,
  `DateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OwnerOrganizationName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerOrganizationAbbrev` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerContactPerson` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `OwnerContactRole` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerTelephone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerLogoURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IPRURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CopyrightURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TermsOfUseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DisclaimersURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicenseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicensesDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LicenseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AcknowledgementsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CitationsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SourceInstitutionID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `SourceID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `RecordBasis` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`MetadataID`),
  KEY `DatasetGUID` (`DatasetGUID`),
  KEY `SourceInstitutionID` (`SourceInstitutionID`),
  KEY `SourceID` (`SourceID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table dnabank.abcdmetadataspecimens: 0 rows
/*!40000 ALTER TABLE `abcdmetadataspecimens` DISABLE KEYS */;
/*!40000 ALTER TABLE `abcdmetadataspecimens` ENABLE KEYS */;


-- Dumping structure for table dnabank.aliquots
DROP TABLE IF EXISTS `aliquots`;
CREATE TABLE IF NOT EXISTS `aliquots` (
  `ID_Aliquots` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_DNA` int(20) unsigned NOT NULL,
  `ID_Aliquots_Box` int(20) unsigned DEFAULT NULL,
  `ID_Aliquots_Rack` int(20) unsigned DEFAULT NULL,
  `ID_Aliquots_Fridge` int(20) unsigned DEFAULT NULL,
  `Aliquot_Number` varchar(100) DEFAULT NULL,
  `Origin_Quantity` float DEFAULT NULL,
  `Rest_Quantity` float DEFAULT NULL,
  `Aliquot_Position` varchar(50) DEFAULT NULL,
  `Aliquot_Barcode` varchar(255) DEFAULT NULL,
  `Order_All` varchar(50) DEFAULT NULL,
  `Order_Partial` varchar(50) DEFAULT NULL,
  `Order_Rest` varchar(50) DEFAULT NULL,
  `Shipping_All` varchar(50) DEFAULT NULL,
  `Shipping_Partial` varchar(50) DEFAULT NULL,
  `Shipping_Rest` varchar(50) DEFAULT NULL,
  `Price` varchar(50) DEFAULT NULL,
  `Currency` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Update_Who` varchar(50) DEFAULT NULL,
  `Update_When` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_Aliquots`),
  KEY `TableAliquots_FKIndex1` (`ID_Aliquots_Fridge`),
  KEY `TableAliquots_FKIndex2` (`ID_Aliquots_Rack`),
  KEY `TableAliquots_FKIndex3` (`ID_Aliquots_Box`),
  KEY `TableAliquots_FKIndex4` (`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.aliquots: 0 rows
/*!40000 ALTER TABLE `aliquots` DISABLE KEYS */;
/*!40000 ALTER TABLE `aliquots` ENABLE KEYS */;


-- Dumping structure for table dnabank.aliquots_box
DROP TABLE IF EXISTS `aliquots_box`;
CREATE TABLE IF NOT EXISTS `aliquots_box` (
  `ID_Aliquots_Box` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Aliquots_Box` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Aliquots_Box`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.aliquots_box: 0 rows
/*!40000 ALTER TABLE `aliquots_box` DISABLE KEYS */;
/*!40000 ALTER TABLE `aliquots_box` ENABLE KEYS */;


-- Dumping structure for table dnabank.aliquots_fridge
DROP TABLE IF EXISTS `aliquots_fridge`;
CREATE TABLE IF NOT EXISTS `aliquots_fridge` (
  `ID_Aliquots_Fridge` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Aliquots_Fridge` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Aliquots_Fridge`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.aliquots_fridge: 0 rows
/*!40000 ALTER TABLE `aliquots_fridge` DISABLE KEYS */;
/*!40000 ALTER TABLE `aliquots_fridge` ENABLE KEYS */;


-- Dumping structure for table dnabank.aliquots_rack
DROP TABLE IF EXISTS `aliquots_rack`;
CREATE TABLE IF NOT EXISTS `aliquots_rack` (
  `ID_Aliquots_Rack` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Aliquots_Rack` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Aliquots_Rack`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.aliquots_rack: 0 rows
/*!40000 ALTER TABLE `aliquots_rack` DISABLE KEYS */;
/*!40000 ALTER TABLE `aliquots_rack` ENABLE KEYS */;


-- Dumping structure for table dnabank.amplifications
DROP TABLE IF EXISTS `amplifications`;
CREATE TABLE IF NOT EXISTS `amplifications` (
  `ID_Amplification` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_DNA` int(20) unsigned NOT NULL,
  `ID_GeneticLocus` int(20) unsigned NOT NULL,
  `GenBankNumber` varchar(150) DEFAULT NULL,
  `Link` varchar(500) DEFAULT NULL,
  `Amplification_Date` datetime DEFAULT NULL,
  `ID_Amplification_Staff` int(20) unsigned DEFAULT NULL,
  `Amplification_Success` varchar(10) DEFAULT NULL,
  `ID_Purification` int(20) DEFAULT NULL,
  `ID_PrimerForward` int(20) unsigned DEFAULT NULL,
  `ID_PrimerReverse` int(20) unsigned DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Update_Who` varchar(50) DEFAULT NULL,
  `Update_When` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_Amplification`),
  KEY `ID_DNA` (`ID_DNA`),
  KEY `ID_GeneticLocus` (`ID_GeneticLocus`),
  KEY `ID_Amplification_Staff` (`ID_Amplification_Staff`),
  KEY `ID_Purification` (`ID_Purification`),
  KEY `ID_PrimerForward` (`ID_PrimerForward`),
  KEY `ID_PrimerReverse` (`ID_PrimerReverse`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.amplifications: 0 rows
/*!40000 ALTER TABLE `amplifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `amplifications` ENABLE KEYS */;


-- Dumping structure for table dnabank.authors
DROP TABLE IF EXISTS `authors`;
CREATE TABLE IF NOT EXISTS `authors` (
  `ID_Author` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Author` varchar(150) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.authors: 0 rows
/*!40000 ALTER TABLE `authors` DISABLE KEYS */;
/*!40000 ALTER TABLE `authors` ENABLE KEYS */;


-- Dumping structure for table dnabank.basisofrecordspecimen
DROP TABLE IF EXISTS `basisofrecordspecimen`;
CREATE TABLE IF NOT EXISTS `basisofrecordspecimen` (
  `ID_BasisOfRecord_Specimen` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `BasisOfRecord_Specimen` varchar(50) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_BasisOfRecord_Specimen`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.basisofrecordspecimen: 5 rows
/*!40000 ALTER TABLE `basisofrecordspecimen` DISABLE KEYS */;
INSERT INTO `basisofrecordspecimen` (`ID_BasisOfRecord_Specimen`, `BasisOfRecord_Specimen`, `Description`, `Created_Who`, `Created_When`) VALUES
	(1, 'Specimen', 'A physical object representing one or more organisms.', 'unknown', '0000-00-00 00:00:00'),
	(2, 'Observation', 'A report by a known observer', 'unknown', '0000-00-00 00:00:00'),
	(3, 'Living', 'An organism removed from its natural occurrence and now living in captivity or cultivation', 'unknown', '0000-00-00 00:00:00'),
	(4, 'Germplasm', 'Plant, animal and bacterial genetic material for use in breeding new organisms', 'unknown', '0000-00-00 00:00:00'),
	(5, 'Fossil', 'A physical object representing one or more fossil organisms', 'unknown', '0000-00-00 00:00:00');
/*!40000 ALTER TABLE `basisofrecordspecimen` ENABLE KEYS */;


-- Dumping structure for table dnabank.biogeographicregion
DROP TABLE IF EXISTS `biogeographicregion`;
CREATE TABLE IF NOT EXISTS `biogeographicregion` (
  `ID_BiogeographicRegion` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BiogeographicRegion` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_BiogeographicRegion`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.biogeographicregion: 12 rows
/*!40000 ALTER TABLE `biogeographicregion` DISABLE KEYS */;
INSERT INTO `biogeographicregion` (`ID_BiogeographicRegion`, `BiogeographicRegion`, `Created_Who`, `Created_When`) VALUES
	(1, 'Arctic', 'G.Droege', '2011-08-31 10:43:18'),
	(2, 'Boreal', 'G.Droege', '2011-08-31 10:43:26'),
	(3, 'Atlantic', 'G.Droege', '2011-08-31 10:43:35'),
	(4, 'Continental', 'G.Droege', '2011-08-31 10:43:47'),
	(5, 'Alpine', 'G.Droege', '2011-08-31 10:43:57'),
	(6, 'Pannonian', 'G.Droege', '2011-08-31 10:44:05'),
	(7, 'West Mediterranean', 'G.Droege', '2011-08-31 10:44:14'),
	(8, 'East Mediterranean', 'G.Droege', '2011-08-31 10:44:24'),
	(9, 'Macaronesian', 'G.Droege', '2011-08-31 10:44:44'),
	(10, 'Steppic', 'G.Droege', '2011-08-31 10:44:53'),
	(11, 'Black Sea', 'G.Droege', '2011-08-31 10:45:00'),
	(12, 'Anatolian', 'G.Droege', '2011-08-31 10:45:09');
/*!40000 ALTER TABLE `biogeographicregion` ENABLE KEYS */;


-- Dumping structure for table dnabank.cachecollection
DROP TABLE IF EXISTS `cachecollection`;
CREATE TABLE IF NOT EXISTS `cachecollection` (
  `ID_Cache` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Dataset_Specimen` int(20) unsigned NOT NULL,
  `UnitID_Specimen` varchar(255) NOT NULL,
  `CollectionCode_Specimen` varchar(255) NOT NULL,
  `InstitutionCode_Specimen` varchar(255) NOT NULL,
  `ContinentOrOcean` varchar(255) DEFAULT NULL,
  `CountryName` varchar(255) DEFAULT NULL,
  `CountryISO2` varchar(50) DEFAULT NULL,
  `Collectors` varchar(200) DEFAULT NULL,
  `CollectionDate` varchar(200) DEFAULT NULL,
  `CollectionDateMin` varchar(200) DEFAULT NULL,
  `CollectionDateMax` varchar(200) DEFAULT NULL,
  `CollectorsNo` varchar(100) DEFAULT NULL,
  `Locality` varchar(300) DEFAULT NULL,
  `Altitude` varchar(50) DEFAULT NULL,
  `Longitude` varchar(50) DEFAULT NULL,
  `Latitude` varchar(50) DEFAULT NULL,
  `CollectionInfo_Other` varchar(500) DEFAULT NULL,
  `TypeStatus` varchar(150) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Cache`),
  KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.cachecollection: 0 rows
/*!40000 ALTER TABLE `cachecollection` DISABLE KEYS */;
/*!40000 ALTER TABLE `cachecollection` ENABLE KEYS */;


-- Dumping structure for table dnabank.cachehighertaxa
DROP TABLE IF EXISTS `cachehighertaxa`;
CREATE TABLE IF NOT EXISTS `cachehighertaxa` (
  `ID_HigherTaxon` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_CacheTaxonIdentified` bigint(20) unsigned NOT NULL,
  `HigherTaxon` varchar(255) DEFAULT NULL,
  `TaxonRank` varchar(255) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_HigherTaxon`),
  KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.cachehighertaxa: 0 rows
/*!40000 ALTER TABLE `cachehighertaxa` DISABLE KEYS */;
/*!40000 ALTER TABLE `cachehighertaxa` ENABLE KEYS */;


-- Dumping structure for table dnabank.cacheimages
DROP TABLE IF EXISTS `cacheimages`;
CREATE TABLE IF NOT EXISTS `cacheimages` (
  `ID_Images` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Cache` int(20) unsigned NOT NULL,
  `Images` varchar(500) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Images`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.cacheimages: 0 rows
/*!40000 ALTER TABLE `cacheimages` DISABLE KEYS */;
/*!40000 ALTER TABLE `cacheimages` ENABLE KEYS */;


-- Dumping structure for table dnabank.cachetaxonidentified
DROP TABLE IF EXISTS `cachetaxonidentified`;
CREATE TABLE IF NOT EXISTS `cachetaxonidentified` (
  `ID_TaxonIdentified` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Cache` bigint(20) unsigned NOT NULL,
  `Genus` varchar(255) DEFAULT NULL,
  `Subgenus` varchar(255) DEFAULT NULL,
  `FirstEpithet` varchar(255) DEFAULT NULL,
  `SecondEpithet` varchar(255) DEFAULT NULL,
  `Rank` varchar(50) DEFAULT NULL,
  `HybridFlag` varchar(50) DEFAULT NULL,
  `Other` varchar(500) DEFAULT NULL,
  `NameAuthorYear` varchar(500) DEFAULT NULL,
  `PreferredFlag` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_TaxonIdentified`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `Genus` (`Genus`),
  KEY `FirstEpithet` (`FirstEpithet`),
  KEY `SecondEpithet` (`SecondEpithet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.cachetaxonidentified: 0 rows
/*!40000 ALTER TABLE `cachetaxonidentified` DISABLE KEYS */;
/*!40000 ALTER TABLE `cachetaxonidentified` ENABLE KEYS */;


-- Dumping structure for table dnabank.cloningmethod
DROP TABLE IF EXISTS `cloningmethod`;
CREATE TABLE IF NOT EXISTS `cloningmethod` (
  `ID_CloningMethod` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `CloningMethod` varchar(50) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_CloningMethod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.cloningmethod: 0 rows
/*!40000 ALTER TABLE `cloningmethod` DISABLE KEYS */;
/*!40000 ALTER TABLE `cloningmethod` ENABLE KEYS */;


-- Dumping structure for table dnabank.countryisocode
DROP TABLE IF EXISTS `countryisocode`;
CREATE TABLE IF NOT EXISTS `countryisocode` (
  `ID_Country` bigint(20) NOT NULL AUTO_INCREMENT,
  `IsoCode` varchar(50) NOT NULL,
  `Country` varchar(150) NOT NULL,
  PRIMARY KEY (`ID_Country`)
) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8;

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


-- Dumping structure for table dnabank.country_continent
DROP TABLE IF EXISTS `country_continent`;
CREATE TABLE IF NOT EXISTS `country_continent` (
  `ID_Country` bigint(20) DEFAULT NULL,
  `Continent` varchar(50) DEFAULT NULL,
  KEY `ID_Coutry` (`ID_Country`),
  KEY `Country` (`Continent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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


-- Dumping structure for table dnabank.dataset
DROP TABLE IF EXISTS `dataset`;
CREATE TABLE IF NOT EXISTS `dataset` (
  `ID_Dataset` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Provider` int(20) unsigned NOT NULL,
  `Digir_Resource` varchar(255) DEFAULT NULL,
  `Digir_Source` varchar(255) DEFAULT NULL,
  `Display` varchar(255) DEFAULT NULL,
  `Internal_External` varchar(10) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Dataset`),
  KEY `ID_Provider` (`ID_Provider`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.dataset: 1 rows
/*!40000 ALTER TABLE `dataset` DISABLE KEYS */;
INSERT INTO `dataset` (`ID_Dataset`, `ID_Provider`, `Digir_Resource`, `Digir_Source`, `Display`, `Internal_External`, `Created_When`, `Created_Who`) VALUES
	(1, 0, NULL, NULL, ' Specimen Tool', '1', '2008-07-20 14:06:02', 'G.Droege');
/*!40000 ALTER TABLE `dataset` ENABLE KEYS */;


-- Dumping structure for table dnabank.degradation
DROP TABLE IF EXISTS `degradation`;
CREATE TABLE IF NOT EXISTS `degradation` (
  `ID_Degradation` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Degradation` varchar(50) NOT NULL,
  PRIMARY KEY (`ID_Degradation`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.degradation: 3 rows
/*!40000 ALTER TABLE `degradation` DISABLE KEYS */;
INSERT INTO `degradation` (`ID_Degradation`, `Degradation`) VALUES
	(1, 'low'),
	(2, 'medium'),
	(3, 'high');
/*!40000 ALTER TABLE `degradation` ENABLE KEYS */;


-- Dumping structure for table dnabank.dnabanknumbers
DROP TABLE IF EXISTS `dnabanknumbers`;
CREATE TABLE IF NOT EXISTS `dnabanknumbers` (
  `ID_DNA` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Cache` bigint(20) unsigned NOT NULL,
  `ID_Provided_By_People` bigint(20) unsigned DEFAULT NULL,
  `ID_Type` bigint(20) unsigned DEFAULT NULL,
  `ID_Location_Stock` bigint(20) unsigned DEFAULT NULL,
  `DNA_Bank_Number` varchar(50) DEFAULT NULL,
  `ID_RelationDNA_Voucher` bigint(20) unsigned DEFAULT NULL,
  `ID_Tissue` bigint(20) unsigned DEFAULT NULL,
  `ID_Preservation` bigint(20) unsigned DEFAULT NULL,
  `Extraction_Date` datetime DEFAULT NULL,
  `NoExtractDate` tinyint(4) DEFAULT NULL,
  `ID_Extraction_Method` bigint(20) unsigned DEFAULT NULL,
  `ID_Purification` bigint(20) unsigned DEFAULT NULL,
  `ID_Extraction_Staff` bigint(20) unsigned DEFAULT NULL,
  `ID_Degradation` bigint(20) unsigned DEFAULT NULL,
  `Check_Date` datetime DEFAULT NULL,
  `Concentration` varchar(5) DEFAULT NULL,
  `Absorbance280` varchar(5) DEFAULT NULL,
  `Absorbance230` varchar(5) DEFAULT NULL,
  `Stock_Gone` tinyint(1) DEFAULT NULL,
  `Source_Gone` tinyint(1) DEFAULT NULL,
  `Notes` varchar(500) DEFAULT NULL,
  `Notes_Intern` varchar(500) DEFAULT NULL,
  `Block_Until` varchar(50) DEFAULT NULL,
  `Block_General` tinyint(1) DEFAULT NULL,
  `Backup_Aliquot` tinyint(1) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_Who` varchar(50) DEFAULT NULL,
  `Update_When` timestamp NULL DEFAULT NULL,
  `Lock_Who` varchar(50) DEFAULT NULL,
  `Lock_When` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_DNA`),
  KEY `TableDNABankNumbers_FKIndex1` (`ID_Extraction_Method`),
  KEY `TableDNABankNumbers_FKIndex4` (`ID_Degradation`),
  KEY `TableDNABankNumbers_FKIndex6` (`ID_Tissue`),
  KEY `TableDNABankNumbers_FKIndex7` (`ID_Preservation`),
  KEY `TableDNABankNumbers_FKIndex9` (`ID_Type`),
  KEY `TableDNABankNumbers_FKIndex10` (`ID_Location_Stock`),
  KEY `TableDnaBankNumbers_FKIndexCache` (`ID_Cache`),
  KEY `ID_Provided_By` (`ID_Provided_By_People`),
  KEY `ID_RelationtoVoucher` (`ID_RelationDNA_Voucher`),
  KEY `ID_Purification` (`ID_Purification`),
  KEY `ID_Extraction_Staff` (`ID_Extraction_Staff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.dnabanknumbers: 0 rows
/*!40000 ALTER TABLE `dnabanknumbers` DISABLE KEYS */;
/*!40000 ALTER TABLE `dnabanknumbers` ENABLE KEYS */;


-- Dumping structure for table dnabank.dnatype
DROP TABLE IF EXISTS `dnatype`;
CREATE TABLE IF NOT EXISTS `dnatype` (
  `ID_Type` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Type` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Type`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.dnatype: 2 rows
/*!40000 ALTER TABLE `dnatype` DISABLE KEYS */;
INSERT INTO `dnatype` (`ID_Type`, `Type`, `Created_When`, `Created_Who`) VALUES
	(1, 'Mitochondrial DNA', '0000-00-00 00:00:00', ''),
	(2, 'gDNA', '0000-00-00 00:00:00', '');
/*!40000 ALTER TABLE `dnatype` ENABLE KEYS */;


-- Dumping structure for table dnabank.extractionmethod
DROP TABLE IF EXISTS `extractionmethod`;
CREATE TABLE IF NOT EXISTS `extractionmethod` (
  `ID_Method` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Method` varchar(50) NOT NULL,
  `Company` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Method`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.extractionmethod: 0 rows
/*!40000 ALTER TABLE `extractionmethod` DISABLE KEYS */;
/*!40000 ALTER TABLE `extractionmethod` ENABLE KEYS */;


-- Dumping structure for table dnabank.geneticlocus
DROP TABLE IF EXISTS `geneticlocus`;
CREATE TABLE IF NOT EXISTS `geneticlocus` (
  `ID_GeneticLocus` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `GeneticLocus` varchar(150) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_GeneticLocus`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.geneticlocus: 0 rows
/*!40000 ALTER TABLE `geneticlocus` DISABLE KEYS */;
/*!40000 ALTER TABLE `geneticlocus` ENABLE KEYS */;


-- Dumping structure for table dnabank.geocodemethod
DROP TABLE IF EXISTS `geocodemethod`;
CREATE TABLE IF NOT EXISTS `geocodemethod` (
  `ID_Geocode` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Geocode` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Geocode`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.geocodemethod: 5 rows
/*!40000 ALTER TABLE `geocodemethod` DISABLE KEYS */;
INSERT INTO `geocodemethod` (`ID_Geocode`, `Geocode`, `Created_Who`, `Created_When`) VALUES
	(1, 'GPS', 'G.Droege', '2011-08-31 10:40:36'),
	(2, 'DGPS', 'G.Droege', '2011-08-31 10:40:46'),
	(3, 'Estimate', 'G.Droege', '2011-08-31 10:40:54'),
	(4, 'Map', 'G.Droege', '2011-08-31 10:41:03'),
	(5, 'Others', 'G.Droege', '2011-08-31 10:41:10');
/*!40000 ALTER TABLE `geocodemethod` ENABLE KEYS */;


-- Dumping structure for table dnabank.habitatcode
DROP TABLE IF EXISTS `habitatcode`;
CREATE TABLE IF NOT EXISTS `habitatcode` (
  `ID_HabitatCode` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `HabitatCode` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_HabitatCode`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.habitatcode: 58 rows
/*!40000 ALTER TABLE `habitatcode` DISABLE KEYS */;
INSERT INTO `habitatcode` (`ID_HabitatCode`, `HabitatCode`, `Created_Who`, `Created_When`) VALUES
	(1, 'A1 - Littoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:09:18'),
	(2, 'A2 - Littoral sediment', 'G.Droege', '2011-08-31 17:09:41'),
	(3, 'A3 - Infralittoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:10:30'),
	(4, 'A4 - Circalittoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:10:31'),
	(5, 'A5 - Sublittoral sediment', 'G.Droege', '2011-08-31 17:10:42'),
	(6, 'A6 - Deep-sea bead', 'G.Droege', '2011-08-31 17:10:51'),
	(7, 'A7 - Pelagic water column', 'G.Droege', '2011-08-31 17:11:12'),
	(8, 'A8 - Ice-associated marine habitats', 'G.Droege', '2011-08-31 17:11:24'),
	(9, 'B1 - Coastal Dunes and Sandy Shores', 'G.Droege', '2011-08-31 17:11:39'),
	(10, 'B2 - Coastal Shingle', 'G.Droege', '2011-08-31 17:11:50'),
	(11, 'B3 - Rock cliffs, ledges and shores, including the', 'G.Droege', '2011-08-31 17:12:07'),
	(12, 'C1 - Surface standing waters', 'G.Droege', '2011-08-31 17:12:21'),
	(13, 'C2 - Surface running waters', 'G.Droege', '2011-08-31 17:12:32'),
	(14, 'C3 - Littoral zone of inland surface waterbodies', 'G.Droege', '2011-08-31 17:12:47'),
	(15, 'D1 - Raised and blanket bogs', 'G.Droege', '2011-08-31 17:13:28'),
	(16, 'D2 - Valley mires, poor fens and transition mires', 'G.Droege', '2011-08-31 17:13:42'),
	(17, 'D3 - Aapa, palsa and polygon mires', 'G.Droege', '2011-08-31 17:13:55'),
	(18, 'D4 - Base-rich fens and calcareous spring mires', 'G.Droege', '2011-08-31 17:14:11'),
	(19, 'D5 - Sedge and reedbeds, normally without free-sta', 'G.Droege', '2011-08-31 17:14:29'),
	(20, 'D6 - Inland saline and brackish marshes and reedbe', 'G.Droege', '2011-08-31 17:14:43'),
	(21, 'E1 - Dry grasslands', 'G.Droege', '2011-08-31 17:19:56'),
	(22, 'E2 - Mesic grasslands', 'G.Droege', '2011-08-31 17:20:13'),
	(23, 'E3 - Seasonally wet and wet grasslands', 'G.Droege', '2011-08-31 17:20:29'),
	(24, 'E4 - Alpine and subalpine grasslands', 'G.Droege', '2011-08-31 17:20:45'),
	(25, 'E5 - Woodland fringes and clearings and tall forb ', 'G.Droege', '2011-08-31 17:21:03'),
	(26, 'E6 - Inland salt steppes', 'G.Droege', '2011-08-31 17:21:12'),
	(27, 'E7 - Sparsely wooded grasslands', 'G.Droege', '2011-08-31 17:21:24'),
	(28, 'F1 - Tundra', 'G.Droege', '2011-08-31 17:21:39'),
	(29, 'F2 - Arctic, alpine and subalpine scrub', 'G.Droege', '2011-08-31 17:21:52'),
	(30, 'F3 - Temperate and mediterranean-montane scrub', 'G.Droege', '2011-08-31 17:22:43'),
	(31, 'F4 - Temperate shrub heathland', 'G.Droege', '2011-08-31 17:22:58'),
	(32, 'F5 - Maquis, arborescent matorral and thermo-Medit', 'G.Droege', '2011-08-31 17:23:20'),
	(33, 'F6 - Garrigue', 'G.Droege', '2011-08-31 17:23:29'),
	(34, 'F7 - Spiny Mediterranean heaths (phrygana, hedgeho', 'G.Droege', '2011-08-31 17:24:20'),
	(35, 'F8 - Thermo-Atlantic xerophytic scrub', 'G.Droege', '2011-08-31 17:24:33'),
	(36, 'F9 - Riverine and fen scrubs', 'G.Droege', '2011-08-31 17:24:43'),
	(37, 'FA - Hedgerows', 'G.Droege', '2011-08-31 17:24:54'),
	(38, 'FB - Shrub plantations', 'G.Droege', '2011-08-31 17:25:04'),
	(39, 'G1 - Broadleaved decidous woodland', 'G.Droege', '2011-08-31 17:29:32'),
	(40, 'G2 - Broadleaved evergreen woodland', 'G.Droege', '2011-08-31 17:29:44'),
	(41, 'G3 - Coniferous woodland', 'G.Droege', '2011-08-31 17:29:52'),
	(42, 'G4 - Mixed deciduous and coniferous woodland', 'G.Droege', '2011-08-31 17:30:19'),
	(43, 'G5 - Lines of trees, small anthropogenic woodlands', 'G.Droege', '2011-08-31 17:30:59'),
	(44, 'H1 - Terrestrial underground caves, cave systems, ', 'G.Droege', '2011-08-31 17:31:16'),
	(45, 'H2 - Screes', 'G.Droege', '2011-08-31 17:31:22'),
	(46, 'H3 - Inland cliffs, rock pavements and outcrops', 'G.Droege', '2011-08-31 17:31:33'),
	(47, 'H4 - Snow or ice-dominated habitats', 'G.Droege', '2011-08-31 17:31:49'),
	(48, 'H5 - Miscellaneous inland habitats with very spars', 'G.Droege', '2011-08-31 17:32:06'),
	(49, 'H6 - Recent volcanic features', 'G.Droege', '2011-08-31 17:32:18'),
	(50, 'I1 - Arable land and market gardens', 'G.Droege', '2011-08-31 17:32:34'),
	(51, 'I2 - Cultivated areas of gardens and parks', 'G.Droege', '2011-08-31 17:32:56'),
	(52, 'J1 - Buildings of cities, towns and villages', 'G.Droege', '2011-08-31 17:33:20'),
	(53, 'J2 - Low density buildings', 'G.Droege', '2011-08-31 17:33:31'),
	(54, 'J3 - Extractive industrial sites', 'G.Droege', '2011-08-31 17:33:44'),
	(55, 'J4 - Transport networks and other constructed hard', 'G.Droege', '2011-08-31 17:34:03'),
	(56, 'J5 - Highly artificial man-made waters and associa', 'G.Droege', '2011-08-31 17:34:25'),
	(57, 'J6 - Waste deposits', 'G.Droege', '2011-08-31 17:34:34'),
	(58, 'X : Habitat complexes', 'G.Droege', '2011-08-31 17:34:43');
/*!40000 ALTER TABLE `habitatcode` ENABLE KEYS */;


-- Dumping structure for table dnabank.images
DROP TABLE IF EXISTS `images`;
CREATE TABLE IF NOT EXISTS `images` (
  `ID_Images` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_DNA` int(20) unsigned DEFAULT NULL,
  `ImageUrl` varchar(500) DEFAULT NULL,
  `ImageRemarks` varchar(150) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Images`),
  KEY `ID_DNA` (`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gel Images';

-- Dumping data for table dnabank.images: 0 rows
/*!40000 ALTER TABLE `images` DISABLE KEYS */;
/*!40000 ALTER TABLE `images` ENABLE KEYS */;


-- Dumping structure for table dnabank.journals
DROP TABLE IF EXISTS `journals`;
CREATE TABLE IF NOT EXISTS `journals` (
  `ID_Journal` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Journal_Display` varchar(255) NOT NULL,
  `Journal_All` varchar(500) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Journal`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.journals: 0 rows
/*!40000 ALTER TABLE `journals` DISABLE KEYS */;
/*!40000 ALTER TABLE `journals` ENABLE KEYS */;


-- Dumping structure for table dnabank.landusecode
DROP TABLE IF EXISTS `landusecode`;
CREATE TABLE IF NOT EXISTS `landusecode` (
  `ID_LandUseCode` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `LandUseCode` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_LandUseCode`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.landusecode: 24 rows
/*!40000 ALTER TABLE `landusecode` DISABLE KEYS */;
INSERT INTO `landusecode` (`ID_LandUseCode`, `LandUseCode`, `Created_Who`, `Created_When`) VALUES
	(1, 'L1.1 Pasture', 'G.Droege', '2011-08-31 17:35:59'),
	(2, 'L1.2 Fallow', 'G.Droege', '2011-08-31 17:36:14'),
	(3, 'L1.3 Crop', 'G.Droege', '2011-08-31 17:36:19'),
	(4, 'L1.4 Grassland', 'G.Droege', '2011-08-31 17:36:42'),
	(5, 'L1.5 Forest', 'G.Droege', '2011-08-31 17:36:48'),
	(6, 'L1.6 Woodland', 'G.Droege', '2011-08-31 17:36:54'),
	(7, 'L1.7 Protected enclosure', 'G.Droege', '2011-08-31 17:37:04'),
	(8, 'L2.1 Draining', 'G.Droege', '2011-08-31 17:37:13'),
	(9, 'L2.2 Dumping', 'G.Droege', '2011-08-31 17:37:24'),
	(10, 'L2.3 Aquaculture', 'G.Droege', '2011-08-31 17:37:32'),
	(11, 'L2.4 Quarrying / Mining', 'G.Droege', '2011-08-31 17:37:43'),
	(12, 'L2.5 Industrial', 'G.Droege', '2011-08-31 17:37:48'),
	(13, 'L2.6 Peat cutting', 'G.Droege', '2011-08-31 17:37:54'),
	(14, 'L3.1 Light', 'G.Droege', '2011-08-31 17:37:58'),
	(15, 'L3.2 Moderate', 'G.Droege', '2011-08-31 17:38:16'),
	(16, 'L3.3 Severe', 'G.Droege', '2011-08-31 17:38:30'),
	(17, 'L4.1 Walking', 'unknown', '2011-08-31 17:38:39'),
	(18, 'L4.2 Fishing', 'G.Droege', '2011-08-31 17:38:45'),
	(19, 'L4.3 Hunting', 'G.Droege', '2011-08-31 17:38:51'),
	(20, 'L4.4 Golf', 'G.Droege', '2011-08-31 17:38:56'),
	(21, 'L4.5 Sports pitch', 'G.Droege', '2011-08-31 17:39:04'),
	(22, 'L4.6 Camping', 'G.Droege', '2011-08-31 17:39:09'),
	(23, 'L4.7 Horse riding', 'G.Droege', '2011-08-31 17:39:22'),
	(24, 'L4.8 Cycling', 'G.Droege', '2011-08-31 17:39:29');
/*!40000 ALTER TABLE `landusecode` ENABLE KEYS */;


-- Dumping structure for table dnabank.location_stock
DROP TABLE IF EXISTS `location_stock`;
CREATE TABLE IF NOT EXISTS `location_stock` (
  `ID_Location_Stock` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Stock_Box` int(20) unsigned DEFAULT NULL,
  `ID_Stock_Rack` int(20) unsigned DEFAULT NULL,
  `ID_Stock_Fridge` int(11) unsigned DEFAULT NULL,
  `Stock_Position` varchar(50) DEFAULT NULL,
  `Stock_Barcode` varchar(200) DEFAULT NULL,
  `Origin_Quantity` float DEFAULT NULL,
  `Rest_Quantity` float DEFAULT NULL,
  `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Update_Who` varchar(50) DEFAULT NULL,
  `Update_When` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_Location_Stock`),
  KEY `TableLocation_FKIndex4` (`ID_Stock_Fridge`),
  KEY `TableLocation_FKIndex5` (`ID_Stock_Rack`),
  KEY `TableLocation_FKIndex6` (`ID_Stock_Box`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.location_stock: 0 rows
/*!40000 ALTER TABLE `location_stock` DISABLE KEYS */;
/*!40000 ALTER TABLE `location_stock` ENABLE KEYS */;


-- Dumping structure for table dnabank.people
DROP TABLE IF EXISTS `people`;
CREATE TABLE IF NOT EXISTS `people` (
  `ID_People` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `FormOfAddress` varchar(50) DEFAULT NULL,
  `Title` varchar(100) DEFAULT NULL,
  `Forename` varchar(50) DEFAULT NULL,
  `Surname` varchar(50) DEFAULT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `Name_All` varchar(50) DEFAULT NULL,
  `Institut` varchar(150) DEFAULT NULL,
  `Division` varchar(150) DEFAULT NULL,
  `Street` varchar(150) DEFAULT NULL,
  `City` varchar(150) DEFAULT NULL,
  `Postal_Code` varchar(150) DEFAULT NULL,
  `Country` varchar(150) DEFAULT NULL,
  `Institut_Delivery` varchar(150) DEFAULT NULL,
  `Division_Delivery` varchar(150) DEFAULT NULL,
  `Street_Delivery` varchar(150) DEFAULT NULL,
  `City_Delivery` varchar(150) DEFAULT NULL,
  `Postal_Code_Delivery` varchar(150) DEFAULT NULL,
  `Country_Delivery` varchar(150) DEFAULT NULL,
  `ExtractionStaff` varchar(10) DEFAULT NULL,
  `Provider` varchar(10) DEFAULT NULL,
  `Customer` varchar(10) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_People`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.people: 0 rows
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
/*!40000 ALTER TABLE `people` ENABLE KEYS */;


-- Dumping structure for table dnabank.preservation
DROP TABLE IF EXISTS `preservation`;
CREATE TABLE IF NOT EXISTS `preservation` (
  `ID_Preservation` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Preservation` varchar(150) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Preservation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.preservation: 0 rows
/*!40000 ALTER TABLE `preservation` DISABLE KEYS */;
/*!40000 ALTER TABLE `preservation` ENABLE KEYS */;


-- Dumping structure for table dnabank.prevalentaspect
DROP TABLE IF EXISTS `prevalentaspect`;
CREATE TABLE IF NOT EXISTS `prevalentaspect` (
  `ID_Aspect` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Aspect` varchar(50) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Aspect`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.prevalentaspect: 10 rows
/*!40000 ALTER TABLE `prevalentaspect` DISABLE KEYS */;
INSERT INTO `prevalentaspect` (`ID_Aspect`, `Aspect`, `Created_Who`, `Created_When`) VALUES
	(1, 'N', 'G.Droege', '2011-07-27 11:24:14'),
	(2, 'NE', 'G.Droege', '2011-07-27 11:24:28'),
	(3, 'E', 'G.Droege', '2011-07-27 11:24:34'),
	(4, 'SE', 'G.Droege', '2011-07-27 11:24:42'),
	(5, 'S', 'G.Droege', '2011-07-27 11:24:49'),
	(6, 'SW', 'G.Droege', '2011-07-27 11:24:57'),
	(7, 'W', 'G.Droege', '2011-07-27 11:25:11'),
	(8, 'NW', 'G.Droege', '2011-07-27 11:25:22'),
	(10, 'Open', 'G.Droege', '2011-07-27 11:25:27'),
	(11, 'Closed', 'G.Droege', '2011-07-27 11:25:34');
/*!40000 ALTER TABLE `prevalentaspect` ENABLE KEYS */;


-- Dumping structure for table dnabank.primer
DROP TABLE IF EXISTS `primer`;
CREATE TABLE IF NOT EXISTS `primer` (
  `ID_Primer` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL DEFAULT '0',
  `Sequence` varchar(5000) DEFAULT NULL,
  `ReferenceCitation` varchar(500) DEFAULT NULL,
  `ReferenceLink` varchar(500) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Primer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.primer: 0 rows
/*!40000 ALTER TABLE `primer` DISABLE KEYS */;
/*!40000 ALTER TABLE `primer` ENABLE KEYS */;


-- Dumping structure for table dnabank.provider
DROP TABLE IF EXISTS `provider`;
CREATE TABLE IF NOT EXISTS `provider` (
  `ID_Provider` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Provider` varchar(500) NOT NULL,
  `ID_Schema` int(20) unsigned NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Provider`),
  KEY `ID_Schema` (`ID_Schema`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.provider: 0 rows
/*!40000 ALTER TABLE `provider` DISABLE KEYS */;
/*!40000 ALTER TABLE `provider` ENABLE KEYS */;


-- Dumping structure for table dnabank.publications
DROP TABLE IF EXISTS `publications`;
CREATE TABLE IF NOT EXISTS `publications` (
  `ID_Publications` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Editors` varchar(10) DEFAULT NULL,
  `Year` varchar(20) DEFAULT NULL,
  `Title` varchar(1000) DEFAULT NULL,
  `ID_Journal` int(20) unsigned DEFAULT NULL,
  `Volume` varchar(10) DEFAULT NULL,
  `Pages` varchar(20) DEFAULT NULL,
  `Book` varchar(100) DEFAULT NULL,
  `Publisher` varchar(250) DEFAULT NULL,
  `Link` varchar(400) DEFAULT NULL,
  `Paper_Cache` varchar(700) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_When` timestamp NULL DEFAULT NULL,
  `Update_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Publications`),
  KEY `ID_Journal` (`ID_Journal`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.publications: 0 rows
/*!40000 ALTER TABLE `publications` DISABLE KEYS */;
/*!40000 ALTER TABLE `publications` ENABLE KEYS */;


-- Dumping structure for table dnabank.publications_amplifications
DROP TABLE IF EXISTS `publications_amplifications`;
CREATE TABLE IF NOT EXISTS `publications_amplifications` (
  `ID_Pub_Amp` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Publications` bigint(20) unsigned NOT NULL,
  `ID_Amplification` bigint(20) unsigned NOT NULL,
  `ID_DNA` bigint(20) unsigned NOT NULL,
  `Paper_Cache` varchar(1000) DEFAULT NULL,
  `GeneticLocus` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Pub_Amp`),
  KEY `ID_Publications` (`ID_Publications`,`ID_Amplification`,`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.publications_amplifications: 0 rows
/*!40000 ALTER TABLE `publications_amplifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `publications_amplifications` ENABLE KEYS */;


-- Dumping structure for table dnabank.publications_authors
DROP TABLE IF EXISTS `publications_authors`;
CREATE TABLE IF NOT EXISTS `publications_authors` (
  `Order` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Publications` bigint(20) unsigned NOT NULL,
  `ID_Author` bigint(20) unsigned NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`Order`),
  KEY `ID_Publications` (`ID_Publications`,`ID_Author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.publications_authors: 0 rows
/*!40000 ALTER TABLE `publications_authors` DISABLE KEYS */;
/*!40000 ALTER TABLE `publications_authors` ENABLE KEYS */;


-- Dumping structure for table dnabank.purification
DROP TABLE IF EXISTS `purification`;
CREATE TABLE IF NOT EXISTS `purification` (
  `ID_Purification` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Method` varchar(150) NOT NULL,
  `Company` varchar(150) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Purification`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.purification: 0 rows
/*!40000 ALTER TABLE `purification` DISABLE KEYS */;
/*!40000 ALTER TABLE `purification` ENABLE KEYS */;


-- Dumping structure for table dnabank.relationdna_voucher
DROP TABLE IF EXISTS `relationdna_voucher`;
CREATE TABLE IF NOT EXISTS `relationdna_voucher` (
  `ID_RelationDNA_Voucher` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `RelationDNA_Voucher` varchar(250) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_RelationDNA_Voucher`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.relationdna_voucher: 6 rows
/*!40000 ALTER TABLE `relationdna_voucher` DISABLE KEYS */;
INSERT INTO `relationdna_voucher` (`ID_RelationDNA_Voucher`, `RelationDNA_Voucher`, `Created_When`, `Created_Who`) VALUES
	(1, 'DNA and voucher from same in situ individual', '2008-05-29 15:34:52', 'G.Droege'),
	(2, 'DNA and voucher from same in situ population', '2008-05-29 15:34:52', 'G.Droege'),
	(3, 'DNA and voucher from same ex situ individual', '2008-05-29 15:34:52', 'G.Droege'),
	(4, 'DNA and voucher from same ex situ population', '2008-05-29 15:34:52', 'G.Droege'),
	(5, 'DNA from cultivated plant, voucher specimen and garden accession from same in situ population', '2008-05-29 15:34:52', 'G.Droege'),
	(6, 'Unknown', '2009-07-17 12:30:23', 'G.Droege');
/*!40000 ALTER TABLE `relationdna_voucher` ENABLE KEYS */;


-- Dumping structure for table dnabank.request
DROP TABLE IF EXISTS `request`;
CREATE TABLE IF NOT EXISTS `request` (
  `ID_Request` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_People` bigint(20) unsigned NOT NULL,
  `ID_DNA` bigint(20) unsigned NOT NULL,
  `ID_Aliquots` bigint(20) unsigned NOT NULL,
  `Request_Date` datetime DEFAULT NULL,
  `Request_Number_Aliquots` varchar(150) DEFAULT NULL,
  `Request_Volume` float DEFAULT NULL,
  `Request_Notes` varchar(500) DEFAULT NULL,
  `Shipping_Date` datetime DEFAULT NULL,
  `PriceAndCurrency` varchar(50) DEFAULT NULL,
  `Agreement` varchar(10) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Request`),
  KEY `TableRequest_FKIndex1` (`ID_DNA`),
  KEY `TableRequest_FKIndex2` (`ID_People`),
  KEY `ID_Aliquots` (`ID_Aliquots`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.request: 0 rows
/*!40000 ALTER TABLE `request` DISABLE KEYS */;
/*!40000 ALTER TABLE `request` ENABLE KEYS */;


-- Dumping structure for table dnabank.schemata
DROP TABLE IF EXISTS `schemata`;
CREATE TABLE IF NOT EXISTS `schemata` (
  `ID_Schema` int(20) NOT NULL AUTO_INCREMENT,
  `Schemata` varchar(50) DEFAULT NULL,
  `QueryPart1` varchar(2000) DEFAULT NULL,
  `QueryPart1_1` varchar(200) DEFAULT NULL,
  `QueryPart1_2` varchar(2000) DEFAULT NULL,
  `QueryPart1_2b` varchar(2000) DEFAULT NULL,
  `QueryPart1b` varchar(2000) DEFAULT NULL,
  `QueryPart2` varchar(2000) DEFAULT NULL,
  `QueryPart2a` varchar(2000) DEFAULT NULL,
  `QueryPart3` varchar(2000) DEFAULT NULL,
  `QueryPart4` varchar(2000) DEFAULT NULL,
  `QueryPart5` varchar(2000) DEFAULT NULL,
  `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Schema`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.schemata: 4 rows
/*!40000 ALTER TABLE `schemata` DISABLE KEYS */;
INSERT INTO `schemata` (`ID_Schema`, `Schemata`, `QueryPart1`, `QueryPart1_1`, `QueryPart1_2`, `QueryPart1_2b`, `QueryPart1b`, `QueryPart2`, `QueryPart2a`, `QueryPart3`, `QueryPart4`, `QueryPart5`, `Created_When`, `Created_Who`) VALUES
	(1, 'ABCD 1.2', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FresponseFormat%3E%3Cfilter%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '', '', '', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FresponseFormat%3E%3Cfilter%3E%3Cand%3E%3Cand%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '%3C%2Fequals%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', NULL, '%3C%2Flike%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceName%22%3E', '%3C%2Fequals%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '0000-00-00 00:00:00', ''),
	(2, 'ABCD 2.06', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FresponseFormat%3E%3Cfilter%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '', '', '', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FresponseFormat%3E%3Cfilter%3E%3Cand%3E%3Cand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '%3C%2Flike%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', NULL, '%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceInstitutionID%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceID%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '0000-00-00 00:00:00', ''),
	(3, 'DWC (digir, CatalogNumber)', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A+%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%22%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cor%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cand%3E+%3Cand%3E+%3Cequals%3E+%3Cdarwin%3A', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumber%3E', '%3C%2Fdarwin%3ACatalogNumber%3E+%3C%2Fequals%3E+%3C%2For%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3AInstitutionCode%3E', '%3C%2Fdarwin%3AInstitutionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E+%3Cequals%3E+%3Cdarwin%3ACollectionCode%3E', '%3C%2Fdarwin%3ACollectionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '0000-00-00 00:00:00', ''),
	(6, 'DWC (digir, CatalogNumberText)', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%22%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cand%3E+%3Cand%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', NULL, '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3AInstitutionCode%3E', '%3C%2Fdarwin%3AInstitutionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E+%3Cequals%3E+%3Cdarwin%3ACollectionCode%3E', '%3C%2Fdarwin%3ACollectionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '2009-04-23 16:02:37', '');
/*!40000 ALTER TABLE `schemata` ENABLE KEYS */;


-- Dumping structure for table dnabank.seasandoceans
DROP TABLE IF EXISTS `seasandoceans`;
CREATE TABLE IF NOT EXISTS `seasandoceans` (
  `ID_SeasAndOceans` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `SeasAndOceans` varchar(255) NOT NULL,
  `Ocean` varchar(255) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_SeasAndOceans`)
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.seasandoceans: 125 rows
/*!40000 ALTER TABLE `seasandoceans` DISABLE KEYS */;
INSERT INTO `seasandoceans` (`ID_SeasAndOceans`, `SeasAndOceans`, `Ocean`, `Created_Who`, `Created_When`) VALUES
	(1, 'Adriatic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(2, 'Aegean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(3, 'Alboran Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(4, 'Argentine Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(5, 'Bay of Bothnia', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(6, 'Bay of Fundy', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(7, 'Baltic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(8, 'Black Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(9, 'Bothnian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(10, 'Caribbean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(11, 'Celtic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(12, 'Central Baltic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(13, 'Chesapeake Bay', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(14, 'English Channel', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(15, 'Gulf of Bothnia', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(16, 'Gulf of Guinea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(17, 'Gulf of Finland', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(18, 'Gulf of Mexico', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(19, 'Gulf of Sidra', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(20, 'Gulf of St. Lawrence', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(21, 'Gulf of Venezuela', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(22, 'Ionian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(23, 'Irish Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(24, 'Marmara Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(25, 'Mediterranean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(26, 'Mirtoon Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(27, 'North Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(28, 'Sea of Azov', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(29, 'Sea of Crete', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(30, 'Sea of the Hebrides', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(31, 'Sargasso Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(32, 'Thracian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(33, 'Tyrrhenian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(34, 'Amundsen Gulf', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(35, 'Baffin Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(36, 'Barents Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(37, 'Beaufort Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(39, 'Cambridge Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(40, 'Chukchi Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(41, 'Cold Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(42, 'Davis Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(43, 'Denmark Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(44, 'East Siberian Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(45, 'Greenland Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(46, 'Hudson Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(47, 'James Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(48, 'Kara Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(49, 'Kara Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(50, 'Labrador Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(51, 'Laptev Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(52, 'Lincoln Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(53, 'Norwegian Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(54, 'White Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(56, 'Andaman Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(57, 'Arabian Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(58, 'Bay of Bengal', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(59, 'Gulf of Aden', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(60, 'Gulf of Oman', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(61, 'Mozambique Channel', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(62, 'Persian Gulf', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(63, 'Red Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(64, 'Timor Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(65, 'Arafura Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(66, 'Banda Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(67, 'Bering Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(68, 'Bismarck Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(70, 'Bohol Sea (Mindanao Sea)', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(71, 'Camotes Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(72, 'Celebes Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(73, 'Ceram Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(74, 'Chilean Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(75, 'Coral Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(76, 'East China Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(77, 'Flores Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(78, 'Gulf of Alaska', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(79, 'Gulf of California (Sea of CortÃ©s)', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(80, 'Gulf of Carpentaria', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(81, 'Gulf of Thailand', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(82, 'Halmahera Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(83, 'Java Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(84, 'Molucca Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(85, 'Philippine Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(86, 'Savu Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(87, 'Sea of Japan', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(88, 'Sea of Okhotsk', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(89, 'Seto Inland Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(90, 'Solomon Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(91, 'South China Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(92, 'Sulu Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(93, 'Tasman Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(95, 'Yellow Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(96, 'Amundsen Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(97, 'Bass Strait', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(98, 'Bellingshausen Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(99, 'Davis Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(100, 'Great Australian Bight', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(101, 'Gulf Saint Vincent', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(102, 'Ross Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(103, 'Scotia Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(104, 'Spencer Gulf', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(105, 'Weddell Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(106, 'Aral Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(107, 'Caspian Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(108, 'Dead Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(109, 'Sea of Galilee', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(110, 'Salton Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(111, 'Great Salt Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(112, 'Unknown or unspecified Atlantic Ocean', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(113, 'Unknown or unspecified Artic Ocean', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'),
	(114, 'Unknown or unspecified Indian Ocean', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'),
	(115, 'Unknown or unspecified Pacific Ocean', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'),
	(116, 'Unknown or unspecified Southern Ocean', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'),
	(117, 'Unknown or unspecified Ocean', 'Unknown', 'unknown', '0000-00-00 00:00:00'),
	(118, 'Chott Melrhir', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(119, 'Great Lakes', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(120, 'Issyk Kul', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(121, 'Lake Balkhash', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(122, 'Lake Chad', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(123, 'Lake Chilwa', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(124, 'Lake Turkana', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(125, 'Lake Van', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(126, 'Namtso', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(127, 'Pyramid Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(128, 'Qinghai Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'),
	(129, 'Tonle Sap', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00');
/*!40000 ALTER TABLE `seasandoceans` ENABLE KEYS */;


-- Dumping structure for table dnabank.sequencing
DROP TABLE IF EXISTS `sequencing`;
CREATE TABLE IF NOT EXISTS `sequencing` (
  `ID_Sequencing` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Amplification` int(10) unsigned NOT NULL,
  `CloningDate` datetime DEFAULT NULL,
  `ID_CloningStaff` int(10) unsigned DEFAULT NULL,
  `ID_CloningMethod` int(10) unsigned DEFAULT NULL,
  `CloneStrain` varchar(50) DEFAULT NULL,
  `ConsensusSequence` varchar(1000) DEFAULT NULL,
  `ConsensusSequenceLength` varchar(10) DEFAULT NULL,
  `ConsensusSequenceChromatogram` varchar(500) DEFAULT NULL,
  `BarcodeSequence` varchar(1000) DEFAULT NULL,
  `GenBankNumber` varchar(50) DEFAULT NULL,
  `GenBankNumber-URI` varchar(500) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Sequencing`),
  KEY `ID_Amplification` (`ID_Amplification`),
  KEY `ID_CloningStaff` (`ID_CloningStaff`),
  KEY `ID_CloningMethod` (`ID_CloningMethod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sequencing: 0 rows
/*!40000 ALTER TABLE `sequencing` DISABLE KEYS */;
/*!40000 ALTER TABLE `sequencing` ENABLE KEYS */;


-- Dumping structure for table dnabank.sequencingmethod
DROP TABLE IF EXISTS `sequencingmethod`;
CREATE TABLE IF NOT EXISTS `sequencingmethod` (
  `ID_SequencingMethod` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `SequencingMethod` varchar(50) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_SequencingMethod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sequencingmethod: 0 rows
/*!40000 ALTER TABLE `sequencingmethod` DISABLE KEYS */;
/*!40000 ALTER TABLE `sequencingmethod` ENABLE KEYS */;


-- Dumping structure for table dnabank.sex
DROP TABLE IF EXISTS `sex`;
CREATE TABLE IF NOT EXISTS `sex` (
  `ID_Sex` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Sex` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Sex`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sex: 4 rows
/*!40000 ALTER TABLE `sex` DISABLE KEYS */;
INSERT INTO `sex` (`ID_Sex`, `Sex`, `Created_When`, `Created_Who`) VALUES
	(1, 'female', '2009-02-10 17:45:28', ''),
	(2, 'male', '2009-02-10 17:45:28', ''),
	(3, 'hermaphrodite', '2009-02-10 17:45:28', ''),
	(4, 'unknown', '2009-02-10 17:45:28', '');
/*!40000 ALTER TABLE `sex` ENABLE KEYS */;


-- Dumping structure for table dnabank.singlesequencing
DROP TABLE IF EXISTS `singlesequencing`;
CREATE TABLE IF NOT EXISTS `singlesequencing` (
  `ID_SingleSequencing` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Sequencing` bigint(20) unsigned NOT NULL,
  `ID_Amplification` bigint(20) unsigned NOT NULL,
  `SequencingDate` datetime DEFAULT NULL,
  `ID_SequencingStaff` bigint(20) unsigned DEFAULT NULL,
  `ID_SequencingMethod` bigint(20) unsigned DEFAULT NULL,
  `SingleSequence` varchar(1000) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_SingleSequencing`),
  KEY `ID_Sequencing` (`ID_Sequencing`),
  KEY `ID_Amplification` (`ID_Amplification`),
  KEY `ID_SequencingStaff` (`ID_SequencingStaff`),
  KEY `ID_SequencingMethod` (`ID_SequencingMethod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.singlesequencing: 0 rows
/*!40000 ALTER TABLE `singlesequencing` DISABLE KEYS */;
/*!40000 ALTER TABLE `singlesequencing` ENABLE KEYS */;


-- Dumping structure for table dnabank.singlesequencingchromatograms
DROP TABLE IF EXISTS `singlesequencingchromatograms`;
CREATE TABLE IF NOT EXISTS `singlesequencingchromatograms` (
  `ID_Chromatograms` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_SingleSequencing` bigint(20) unsigned NOT NULL,
  `ID_Sequencing` bigint(20) unsigned NOT NULL,
  `ID_Amplification` bigint(20) unsigned NOT NULL,
  `FileURI` varchar(500) DEFAULT NULL,
  `Remarks` varchar(500) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Chromatograms`),
  KEY `ID_SingleSequencing` (`ID_SingleSequencing`),
  KEY `ID_Sequencing` (`ID_Sequencing`),
  KEY `ID_Amplification` (`ID_Amplification`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.singlesequencingchromatograms: 0 rows
/*!40000 ALTER TABLE `singlesequencingchromatograms` DISABLE KEYS */;
/*!40000 ALTER TABLE `singlesequencingchromatograms` ENABLE KEYS */;


-- Dumping structure for table dnabank.singlesequencing_primers
DROP TABLE IF EXISTS `singlesequencing_primers`;
CREATE TABLE IF NOT EXISTS `singlesequencing_primers` (
  `ID_SingleSequencing` bigint(20) unsigned NOT NULL,
  `ID_Primer` bigint(20) unsigned NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `ID_SingleSequencing` (`ID_SingleSequencing`),
  KEY `ID_Primer` (`ID_Primer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.singlesequencing_primers: 0 rows
/*!40000 ALTER TABLE `singlesequencing_primers` DISABLE KEYS */;
/*!40000 ALTER TABLE `singlesequencing_primers` ENABLE KEYS */;


-- Dumping structure for table dnabank.slope
DROP TABLE IF EXISTS `slope`;
CREATE TABLE IF NOT EXISTS `slope` (
  `ID_Slope` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Slope` varchar(50) NOT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Slope`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.slope: 5 rows
/*!40000 ALTER TABLE `slope` DISABLE KEYS */;
INSERT INTO `slope` (`ID_Slope`, `Slope`, `Created_Who`, `Created_When`) VALUES
	(1, 'Level 0-5 %', 'G.Droege', '2011-07-27 11:21:43'),
	(2, 'Undulating 6-10 %', 'G.Droege', '2011-07-27 11:22:02'),
	(3, 'Rolling 11-20 %', 'G.Droege', '2011-07-27 11:22:16'),
	(4, 'Moderate 21-30%', 'G.Droege', '2011-07-27 11:22:30'),
	(5, 'Steep > 30 %', 'G.Droege', '2011-07-27 11:22:50');
/*!40000 ALTER TABLE `slope` ENABLE KEYS */;


-- Dumping structure for table dnabank.soilph
DROP TABLE IF EXISTS `soilph`;
CREATE TABLE IF NOT EXISTS `soilph` (
  `ID_SoilpH` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `SoilpH` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_SoilpH`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.soilph: 3 rows
/*!40000 ALTER TABLE `soilph` DISABLE KEYS */;
INSERT INTO `soilph` (`ID_SoilpH`, `SoilpH`, `Created_Who`, `Created_When`) VALUES
	(1, 'Acidic', 'G.Droege', '2011-08-31 17:07:58'),
	(2, 'Alkaline', 'G.Droege', '2011-08-31 17:08:03'),
	(3, 'Neutral', 'G.Droege', '2011-08-31 17:08:08');
/*!40000 ALTER TABLE `soilph` ENABLE KEYS */;


-- Dumping structure for table dnabank.soiltexture
DROP TABLE IF EXISTS `soiltexture`;
CREATE TABLE IF NOT EXISTS `soiltexture` (
  `ID_SoilTexture` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `SoilTexture` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_SoilTexture`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.soiltexture: 8 rows
/*!40000 ALTER TABLE `soiltexture` DISABLE KEYS */;
INSERT INTO `soiltexture` (`ID_SoilTexture`, `SoilTexture`, `Created_Who`, `Created_When`) VALUES
	(1, 'Gravel', 'G.Droege', '2011-08-31 17:06:42'),
	(2, 'Sand', 'G.Droege', '2011-08-31 17:06:47'),
	(3, 'Sandy loam', 'G.Droege', '2011-08-31 17:06:53'),
	(4, 'Loam', 'G.Droege', '2011-08-31 17:06:57'),
	(5, 'Clay loam', 'G.Droege', '2011-08-31 17:07:04'),
	(6, 'Clay', 'G.Droege', '2011-08-31 17:07:10'),
	(7, 'Peat', 'G.Droege', '2011-08-31 17:07:17'),
	(8, 'No soil', 'G.Droege', '2011-08-31 17:07:22');
/*!40000 ALTER TABLE `soiltexture` ENABLE KEYS */;


-- Dumping structure for table dnabank.specimentype
DROP TABLE IF EXISTS `specimentype`;
CREATE TABLE IF NOT EXISTS `specimentype` (
  `ID_SpecimenType` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `SpecimenType` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_SpecimenType`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.specimentype: 18 rows
/*!40000 ALTER TABLE `specimentype` DISABLE KEYS */;
INSERT INTO `specimentype` (`ID_SpecimenType`, `SpecimenType`, `Created_When`, `Created_Who`) VALUES
	(1, 'epitype', '0000-00-00 00:00:00', 'unknown'),
	(2, 'holotype', '0000-00-00 00:00:00', 'unknown'),
	(3, 'isotype', '0000-00-00 00:00:00', 'unknown'),
	(4, 'isoepitype', '0000-00-00 00:00:00', 'unknown'),
	(5, 'isolectotype', '0000-00-00 00:00:00', 'unknown'),
	(6, 'isoneotype', '0000-00-00 00:00:00', 'unknown'),
	(7, 'isoparatype', '0000-00-00 00:00:00', 'unknown'),
	(8, 'isoparalectotype', '0000-00-00 00:00:00', 'unknown'),
	(9, 'isosyntype', '0000-00-00 00:00:00', 'unknown'),
	(10, 'kleptotype', '0000-00-00 00:00:00', 'unknown'),
	(11, 'lectotype', '0000-00-00 00:00:00', 'unknown'),
	(12, 'neotype', '0000-00-00 00:00:00', 'unknown'),
	(13, 'original material', '0000-00-00 00:00:00', 'unknown'),
	(14, 'paratype', '0000-00-00 00:00:00', 'unknown'),
	(15, 'paralectotype', '0000-00-00 00:00:00', 'unknown'),
	(16, 'syntype', '0000-00-00 00:00:00', 'unknown'),
	(17, 'topotype', '0000-00-00 00:00:00', 'unknown'),
	(18, 'type', '0000-00-00 00:00:00', 'unknown');
/*!40000 ALTER TABLE `specimentype` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolassociatedunits
DROP TABLE IF EXISTS `sptoolassociatedunits`;
CREATE TABLE IF NOT EXISTS `sptoolassociatedunits` (
  `ID_Association` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) unsigned NOT NULL,
  `UnitID_Main` varchar(100) DEFAULT NULL,
  `CollectionCode_Main` varchar(100) DEFAULT NULL,
  `InstitutionCode_Main` varchar(100) DEFAULT NULL,
  `RelationToMainUnit` varchar(100) DEFAULT NULL,
  `UnitID` varchar(100) DEFAULT NULL,
  `CollectionCode` varchar(100) DEFAULT NULL,
  `InstitutionCode` varchar(100) DEFAULT NULL,
  `KindOfUnit` varchar(100) DEFAULT NULL,
  `FormerCollection` varchar(100) DEFAULT NULL,
  `ID_BasisOfRecord` bigint(20) unsigned DEFAULT NULL,
  `ID_Dataset` bigint(20) unsigned DEFAULT NULL,
  `Notes` varchar(200) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(100) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID_Association`),
  KEY `ID_Collection` (`ID_Collection`),
  KEY `ID_BasisOfRecord` (`ID_BasisOfRecord`),
  KEY `ID_Dataset` (`ID_Dataset`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptoolassociatedunits: 0 rows
/*!40000 ALTER TABLE `sptoolassociatedunits` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolassociatedunits` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolcollection
DROP TABLE IF EXISTS `sptoolcollection`;
CREATE TABLE IF NOT EXISTS `sptoolcollection` (
  `ID_Collection` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `UnitID_Specimen` varchar(100) NOT NULL,
  `CollectionCode_Specimen` varchar(100) NOT NULL,
  `InstitutionCode_Specimen` varchar(100) NOT NULL,
  `FormerCollection` varchar(100) DEFAULT NULL,
  `ID_BiogeographicRegion` bigint(20) unsigned DEFAULT NULL,
  `ID_Country` bigint(20) unsigned DEFAULT NULL,
  `ID_SeasAndOceans` bigint(20) unsigned DEFAULT NULL,
  `Collectors` varchar(500) DEFAULT NULL,
  `CollectionDateMin` datetime DEFAULT NULL,
  `CollectionDateMax` datetime DEFAULT NULL,
  `CollectionYear` varchar(50) DEFAULT NULL,
  `CollectorsNo` varchar(100) DEFAULT NULL,
  `CollectionNotes` varchar(400) DEFAULT NULL,
  `CollectionMethod` varchar(400) DEFAULT NULL,
  `Locality_ID` varchar(150) DEFAULT NULL,
  `ExpeditionDetails` varchar(300) DEFAULT NULL,
  `Region` varchar(500) DEFAULT NULL,
  `Locality` varchar(500) DEFAULT NULL,
  `Habitat` varchar(100) DEFAULT NULL,
  `ID_SoilTexture` bigint(20) unsigned DEFAULT NULL,
  `ID_SoilpH` bigint(20) unsigned DEFAULT NULL,
  `ID_HabitatCode` bigint(20) unsigned DEFAULT NULL,
  `ID_LandUseCode` bigint(20) unsigned DEFAULT NULL,
  `ID_Slope` bigint(20) unsigned DEFAULT NULL,
  `ID_Aspect` bigint(20) unsigned DEFAULT NULL,
  `DepthAccuracyStatement` varchar(50) DEFAULT NULL,
  `DepthMin` varchar(50) DEFAULT NULL,
  `DepthMax` varchar(50) DEFAULT NULL,
  `DepthUnit` varchar(50) DEFAULT NULL,
  `DepthMethod` varchar(50) DEFAULT NULL,
  `DepthRaw` varchar(50) DEFAULT NULL,
  `AltitudeAccuracyStatement` varchar(50) DEFAULT NULL,
  `AltitudeMin` varchar(50) DEFAULT NULL,
  `AltitudeMax` varchar(50) DEFAULT NULL,
  `AltitudeUnit` varchar(50) DEFAULT NULL,
  `AltitudeMethod` varchar(50) DEFAULT NULL,
  `AltitudeRaw` varchar(50) DEFAULT NULL,
  `CoordinatesAccuracyStatement` varchar(50) DEFAULT NULL,
  `CoordinatesErrorDistance` varchar(50) DEFAULT NULL,
  `LongitudeMin` varchar(50) DEFAULT NULL,
  `LongitudeMax` varchar(50) DEFAULT NULL,
  `LatitudeMin` varchar(50) DEFAULT NULL,
  `LatitudeMax` varchar(50) DEFAULT NULL,
  `LongitudeRaw` varchar(50) DEFAULT NULL,
  `LatitudeRaw` varchar(50) DEFAULT NULL,
  `GeodeticDatum` varchar(50) DEFAULT NULL,
  `ID_GeocodeMethod` bigint(20) unsigned DEFAULT NULL,
  `ID_Sex` bigint(20) unsigned DEFAULT NULL,
  `Protected` varchar(20) NOT NULL DEFAULT 'No',
  `Permission` varchar(20) NOT NULL DEFAULT 'NotRequired',
  `Blocked` varchar(20) NOT NULL DEFAULT 'No',
  `ID_BasisOfRecord` bigint(20) unsigned DEFAULT NULL,
  `KindOfUnit` varchar(150) DEFAULT NULL,
  `ID_Cache` bigint(20) unsigned DEFAULT NULL,
  `ID_Type` bigint(20) unsigned DEFAULT NULL,
  `Notes` varchar(400) DEFAULT NULL,
  `AccessionNo` varchar(50) DEFAULT NULL,
  `AccessionName` varchar(100) DEFAULT NULL,
  `LifeStage` varchar(50) DEFAULT NULL,
  `LifeForm` varchar(50) DEFAULT NULL,
  `PrepType` varchar(50) DEFAULT NULL,
  `PrepDate` varchar(50) DEFAULT NULL,
  `PrepStaff` varchar(50) DEFAULT NULL,
  `SampleGroup` varchar(15) DEFAULT NULL,
  `GUID` varchar(50) DEFAULT NULL,
  `Multimedia` varchar(10) DEFAULT NULL,
  `VoucherRefText` varchar(1000) DEFAULT NULL,
  `VoucherRefUrl` varchar(1000) DEFAULT NULL,
  `VoucherRefDoi` varchar(200) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  `Lock_Who` varchar(50) DEFAULT NULL,
  `Lock_When` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID_Collection`),
  KEY `ID_Sex` (`ID_Sex`),
  KEY `ID_BasisOfRecord` (`ID_BasisOfRecord`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Type` (`ID_Type`),
  KEY `ID_Country` (`ID_Country`),
  KEY `ID_SeasAndOceans` (`ID_SeasAndOceans`),
  KEY `UnitID_Specimen` (`UnitID_Specimen`),
  KEY `ID_BiogeographicRegion` (`ID_BiogeographicRegion`),
  KEY `ID_SoilTexture` (`ID_SoilTexture`),
  KEY `ID_SoilpH` (`ID_SoilpH`),
  KEY `ID_HabitatCode` (`ID_HabitatCode`),
  KEY `ID_LandUseCode` (`ID_LandUseCode`),
  KEY `ID_Slope` (`ID_Slope`),
  KEY `ID_Aspect` (`ID_Aspect`),
  KEY `ID_GeocodeMethod` (`ID_GeocodeMethod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptoolcollection: 0 rows
/*!40000 ALTER TABLE `sptoolcollection` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolcollection` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolecology
DROP TABLE IF EXISTS `sptoolecology`;
CREATE TABLE IF NOT EXISTS `sptoolecology` (
  `ID_Ecology` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) unsigned NOT NULL,
  `Value` varchar(20) DEFAULT NULL,
  `Unit` varchar(50) DEFAULT NULL,
  `Parameter` varchar(50) DEFAULT NULL,
  `Method` varchar(200) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Ecology`),
  KEY `ID_Collection` (`ID_Collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptoolecology: 0 rows
/*!40000 ALTER TABLE `sptoolecology` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolecology` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolhighertaxon
DROP TABLE IF EXISTS `sptoolhighertaxon`;
CREATE TABLE IF NOT EXISTS `sptoolhighertaxon` (
  `ID_HigherTaxon` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Taxa` bigint(20) unsigned NOT NULL,
  `HigherTaxon` varchar(255) DEFAULT NULL,
  `TaxonRank` varchar(255) DEFAULT NULL,
  `Synecology` varchar(255) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_HigherTaxon`),
  KEY `ID_Taxa` (`ID_Taxa`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptoolhighertaxon: 0 rows
/*!40000 ALTER TABLE `sptoolhighertaxon` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolhighertaxon` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolmeasurementorfact
DROP TABLE IF EXISTS `sptoolmeasurementorfact`;
CREATE TABLE IF NOT EXISTS `sptoolmeasurementorfact` (
  `ID_Ecology` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) unsigned DEFAULT NULL,
  `Value` varchar(20) DEFAULT NULL,
  `Unit` varchar(50) DEFAULT NULL,
  `Parameter` varchar(50) DEFAULT NULL,
  `Method` varchar(200) DEFAULT NULL,
  `Rank` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Ecology`),
  KEY `ID_Collection` (`ID_Collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table dnabank.sptoolmeasurementorfact: 0 rows
/*!40000 ALTER TABLE `sptoolmeasurementorfact` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolmeasurementorfact` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptoolmultimedia
DROP TABLE IF EXISTS `sptoolmultimedia`;
CREATE TABLE IF NOT EXISTS `sptoolmultimedia` (
  `ID_Multimedia` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) unsigned NOT NULL,
  `File_Path` varchar(500) NOT NULL,
  `File_Type` varchar(20) NOT NULL,
  `File_Created_When` datetime NOT NULL,
  `File_Created_Who` datetime NOT NULL,
  `File_Context` varchar(500) NOT NULL,
  `File_Comment` varchar(500) NOT NULL,
  `File_Group` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_Multimedia`),
  KEY `ID_OfflineGathering` (`ID_Collection`),
  KEY `File_Group` (`File_Group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptoolmultimedia: 0 rows
/*!40000 ALTER TABLE `sptoolmultimedia` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptoolmultimedia` ENABLE KEYS */;


-- Dumping structure for table dnabank.sptooltaxa
DROP TABLE IF EXISTS `sptooltaxa`;
CREATE TABLE IF NOT EXISTS `sptooltaxa` (
  `ID_TaxonIdentified` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) unsigned NOT NULL,
  `Genus` varchar(255) DEFAULT NULL,
  `Subgenus` varchar(255) DEFAULT NULL,
  `SpecificEpithet` varchar(255) DEFAULT NULL,
  `InfraspecificEpithet` varchar(255) DEFAULT NULL,
  `Rank` varchar(50) DEFAULT NULL,
  `AuthorParenth` varchar(100) DEFAULT NULL,
  `YearParenth` varchar(50) DEFAULT NULL,
  `Author` varchar(100) DEFAULT NULL,
  `Year` varchar(50) DEFAULT NULL,
  `NameAuthorYear` varchar(500) DEFAULT NULL,
  `KindOfIdentification` varchar(20) DEFAULT NULL,
  `Identifier` varchar(100) DEFAULT NULL,
  `IdentificationDate` varchar(50) DEFAULT NULL,
  `PreferredFlag` varchar(50) DEFAULT NULL,
  `IdentificationNotes` varchar(500) DEFAULT NULL,
  `Synecology` varchar(50) DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Updated_When` timestamp NULL DEFAULT NULL,
  `Updated_Who` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_TaxonIdentified`),
  KEY `ID_Gathering` (`ID_Collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.sptooltaxa: 0 rows
/*!40000 ALTER TABLE `sptooltaxa` DISABLE KEYS */;
/*!40000 ALTER TABLE `sptooltaxa` ENABLE KEYS */;


-- Dumping structure for table dnabank.stock_box
DROP TABLE IF EXISTS `stock_box`;
CREATE TABLE IF NOT EXISTS `stock_box` (
  `ID_Stock_Box` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Stock_Box` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Stock_Box`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.stock_box: 0 rows
/*!40000 ALTER TABLE `stock_box` DISABLE KEYS */;
/*!40000 ALTER TABLE `stock_box` ENABLE KEYS */;


-- Dumping structure for table dnabank.stock_fridge
DROP TABLE IF EXISTS `stock_fridge`;
CREATE TABLE IF NOT EXISTS `stock_fridge` (
  `ID_Stock_Fridge` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Stock_Fridge` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Stock_Fridge`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.stock_fridge: 0 rows
/*!40000 ALTER TABLE `stock_fridge` DISABLE KEYS */;
/*!40000 ALTER TABLE `stock_fridge` ENABLE KEYS */;


-- Dumping structure for table dnabank.stock_rack
DROP TABLE IF EXISTS `stock_rack`;
CREATE TABLE IF NOT EXISTS `stock_rack` (
  `ID_Stock_Rack` int(20) NOT NULL AUTO_INCREMENT,
  `Stock_Rack` varchar(50) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Stock_Rack`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.stock_rack: 0 rows
/*!40000 ALTER TABLE `stock_rack` DISABLE KEYS */;
/*!40000 ALTER TABLE `stock_rack` ENABLE KEYS */;


-- Dumping structure for table dnabank.tissue
DROP TABLE IF EXISTS `tissue`;
CREATE TABLE IF NOT EXISTS `tissue` (
  `ID_Tissue` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Tissue` varchar(255) NOT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`ID_Tissue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.tissue: 0 rows
/*!40000 ALTER TABLE `tissue` DISABLE KEYS */;
/*!40000 ALTER TABLE `tissue` ENABLE KEYS */;


-- Dumping structure for table dnabank.user
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `ID_User` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Login` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `Signature` varchar(50) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `ID_Group` tinyint(4) unsigned DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_User`),
  UNIQUE KEY `user_login` (`Login`),
  KEY `ID_Group` (`ID_Group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.user: 0 rows
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;


-- Dumping structure for table dnabank.usergroups
DROP TABLE IF EXISTS `usergroups`;
CREATE TABLE IF NOT EXISTS `usergroups` (
  `ID_Group` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `Group` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Group`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.usergroups: 4 rows
/*!40000 ALTER TABLE `usergroups` DISABLE KEYS */;
INSERT INTO `usergroups` (`ID_Group`, `Group`, `Created_Who`, `Created_When`) VALUES
	(1, 'Administrator', 'unknown', '0000-00-00 00:00:00'),
	(2, 'DNA Bank Management', 'unknown', '0000-00-00 00:00:00'),
	(3, 'Project', 'unknown', '0000-00-00 00:00:00'),
	(4, 'Guest', 'unknown', '0000-00-00 00:00:00');
/*!40000 ALTER TABLE `usergroups` ENABLE KEYS */;


-- Dumping structure for table dnabank.usersettings
DROP TABLE IF EXISTS `usersettings`;
CREATE TABLE IF NOT EXISTS `usersettings` (
  `ID_Setting` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_User` int(20) unsigned NOT NULL,
  `RecordsPerPage` float DEFAULT NULL,
  `Sorting` varchar(50) DEFAULT NULL,
  `RecordsPerPageSP` float DEFAULT NULL,
  `SortingSP` varchar(50) DEFAULT NULL,
  `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown',
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_Setting`),
  KEY `ID_User` (`ID_User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table dnabank.usersettings: 0 rows
/*!40000 ALTER TABLE `usersettings` DISABLE KEYS */;
/*!40000 ALTER TABLE `usersettings` ENABLE KEYS */;


-- Dumping structure for view dnabank.wrapper_view_amplifications
DROP VIEW IF EXISTS `wrapper_view_amplifications`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_amplifications` (
	`ID_DNA` INT(20) UNSIGNED NOT NULL,
	`ID_Amplification` INT(20) UNSIGNED NOT NULL DEFAULT '0',
	`GeneticLocus` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GenBankNumber` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GenBankLink` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Amplification_Date` DATETIME NULL DEFAULT NULL,
	`Amplification_Success` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Amplification_Staff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_biotope
DROP VIEW IF EXISTS `wrapper_view_biotope`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_biotope` (
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`Value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Parameter` VARCHAR(13) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_dna
DROP VIEW IF EXISTS `wrapper_view_dna`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_dna` (
	`ID_DNA` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`ID_Cache` INT(20) UNSIGNED NULL DEFAULT '0',
	`DNA_Bank_Number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`RelationDNA_Voucher` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Tissue` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Preservation` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Provided_By` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Extraction_Date` DATETIME NULL DEFAULT NULL,
	`Extraction_Staff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Extraction_Method` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Extraction_Company` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Purification_Method` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Purification_Company` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Absorbance280` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Absorbance230` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Concentration` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Quality` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Quality_Check_Date` DATETIME NULL DEFAULT NULL,
	`Block_Until` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Notes` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_ecology
DROP VIEW IF EXISTS `wrapper_view_ecology`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_ecology` (
	`ID_Collection` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
	`Value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Parameter` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Method` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_multimedia_site
DROP VIEW IF EXISTS `wrapper_view_multimedia_site`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_multimedia_site` (
	`ID_Multimedia` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL,
	`Path` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci',
	`Type` VARCHAR(20) NOT NULL COLLATE 'utf8_general_ci',
	`Created_When` DATETIME NOT NULL,
	`Created_Who` DATETIME NOT NULL,
	`Context` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci',
	`Comment` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_multimedia_specimens
DROP VIEW IF EXISTS `wrapper_view_multimedia_specimens`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_multimedia_specimens` (
	`ID_Multimedia` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL,
	`Path` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci',
	`Type` VARCHAR(20) NOT NULL COLLATE 'utf8_general_ci',
	`Created_When` DATETIME NOT NULL,
	`Created_Who` DATETIME NOT NULL,
	`Context` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci',
	`Comment` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_namedareas
DROP VIEW IF EXISTS `wrapper_view_namedareas`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_namedareas` (
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`AreaName` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`Value` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_phases
DROP VIEW IF EXISTS `wrapper_view_phases`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_phases` (
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`Phase` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_providers
DROP VIEW IF EXISTS `wrapper_view_providers`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_providers` (
	`ID_Dataset` INT(20) UNSIGNED NOT NULL DEFAULT '0',
	`Digir_Resource` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Digir_Source` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Provider` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Schemata` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_publications_dna
DROP VIEW IF EXISTS `wrapper_view_publications_dna`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_publications_dna` (
	`ID_Pub_Amp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`ID_Amplification` BIGINT(20) UNSIGNED NOT NULL,
	`Paper_Cache` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Link` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GeneticLocus` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for view dnabank.wrapper_view_specimens
DROP VIEW IF EXISTS `wrapper_view_specimens`;
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `wrapper_view_specimens` (
	`ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
	`UnitID_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci',
	`CollectionCode_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci',
	`InstitutionCode_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci',
	`ContinentOrOcean` VARCHAR(307) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CountryName` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CountryISO2` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Collectors` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CollectionDateMin` DATETIME NULL DEFAULT NULL,
	`CollectionDateMax` DATETIME NULL DEFAULT NULL,
	`CollectorsNo` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CollectionNotes` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CollectionMethod` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Locality_ID` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`ExpeditionDetails` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Locality` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Habitat` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`DepthMin` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`DepthMax` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`DepthUnit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`DepthAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`DepthMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`AltitudeMin` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`AltitudeMax` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`AltitudeUnit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`AltitudeMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`AltitudeAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`LongitudeDecimal` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`LatitudeDecimal` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CoordAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`CoordErrorDistance` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GeodeticDatum` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GeocodeMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Sex` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`BasisOfRecord` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`KindOfUnit` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`PrepType` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`PrepStaff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`TypeStatus` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Notes` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`GUID` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`VoucherRefText` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`VoucherRefUrl` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`Aspect` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
) ENGINE=MyISAM;


-- Dumping structure for table dnabank._log_aliquots
DROP TABLE IF EXISTS `_log_aliquots`;
CREATE TABLE IF NOT EXISTS `_log_aliquots` (
  `ID_Log_Aliquots` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_Aliquots` bigint(20) NOT NULL,
  `ID_DNA` bigint(20) NOT NULL,
  `Aliquots_Box` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Aliquots_Rack` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Aliquots_Fridge` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Aliquot_Number` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Aliquot_Position` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Aliquot_Barcode` longtext COLLATE utf8_unicode_ci,
  `Origin_Quantity` float NOT NULL,
  `Rest_Quantity` float NOT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID_Log_Aliquots`),
  KEY `ID_Aliquots` (`ID_Aliquots`),
  KEY `ID_DNA` (`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_aliquots: 0 rows
/*!40000 ALTER TABLE `_log_aliquots` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_aliquots` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_amplifications
DROP TABLE IF EXISTS `_log_amplifications`;
CREATE TABLE IF NOT EXISTS `_log_amplifications` (
  `ID_Log_Amplification` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_Amplification` bigint(20) NOT NULL,
  `ID_DNA` bigint(20) NOT NULL,
  `Fragment` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `GenBankNumber` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Link` longtext COLLATE utf8_unicode_ci NOT NULL,
  `Amplification_Date` datetime NOT NULL,
  `Amplification_Staff` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Amplification_Success` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID_Log_Amplification`),
  KEY `ID_Amplification` (`ID_Amplification`),
  KEY `ID_DNA` (`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_amplifications: 0 rows
/*!40000 ALTER TABLE `_log_amplifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_amplifications` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_cache
DROP TABLE IF EXISTS `_log_cache`;
CREATE TABLE IF NOT EXISTS `_log_cache` (
  `ID_Log_Cache` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_Cache` bigint(20) DEFAULT NULL,
  `ID_Dataset_Specimen` bigint(20) DEFAULT NULL,
  `Provider_url` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UnitID_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CollectionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `InstitutionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContinentOrOcean` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CountryName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CountryISO2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `GatheringAgent` longtext COLLATE utf8_unicode_ci,
  `GatheringDate` longtext COLLATE utf8_unicode_ci,
  `LocalityText` longtext COLLATE utf8_unicode_ci,
  `Altitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LongitudeDecimal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LatitudeDecimal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Gathering_Other` longtext COLLATE utf8_unicode_ci,
  `TypeStatus` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_Log_Cache`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_cache: 0 rows
/*!40000 ALTER TABLE `_log_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_cache` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_cachehighertaxa
DROP TABLE IF EXISTS `_log_cachehighertaxa`;
CREATE TABLE IF NOT EXISTS `_log_cachehighertaxa` (
  `ID_Log_CacheHigherTaxon` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_HigherTaxon` bigint(20) DEFAULT NULL,
  `ID_CacheTaxonIdentified` bigint(20) DEFAULT NULL,
  `HigherTaxon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TaxonRank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_CacheTaxonidentified` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_Log_CacheHigherTaxon`),
  KEY `ID_HigherTaxon` (`ID_HigherTaxon`),
  KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`),
  KEY `ID_Log_CacheTaxonIdentified` (`ID_Log_CacheTaxonidentified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_cachehighertaxa: 0 rows
/*!40000 ALTER TABLE `_log_cachehighertaxa` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_cachehighertaxa` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_cacheimages
DROP TABLE IF EXISTS `_log_cacheimages`;
CREATE TABLE IF NOT EXISTS `_log_cacheimages` (
  `ID_Log_CacheImages` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_CacheImages` bigint(20) DEFAULT NULL,
  `ID_Cache` bigint(20) DEFAULT NULL,
  `Images` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_Cache` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID_Log_CacheImages`),
  KEY `ID_CacheImages` (`ID_CacheImages`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Log_Cache` (`ID_Log_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_cacheimages: 0 rows
/*!40000 ALTER TABLE `_log_cacheimages` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_cacheimages` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_cachetaxonidentified
DROP TABLE IF EXISTS `_log_cachetaxonidentified`;
CREATE TABLE IF NOT EXISTS `_log_cachetaxonidentified` (
  `ID_Log_CacheTaxonIdentified` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_CacheTaxonIdentified` bigint(20) DEFAULT NULL,
  `ID_Cache` bigint(20) DEFAULT NULL,
  `Genus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Subgenus` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FirstEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SecondEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Rank` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HybridFlag` tinyint(4) DEFAULT NULL,
  `Other` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NameAuthorYear` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PreferredFlag` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_Cache` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_Log_CacheTaxonIdentified`),
  KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Log_Cache` (`ID_Log_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_cachetaxonidentified: 0 rows
/*!40000 ALTER TABLE `_log_cachetaxonidentified` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_cachetaxonidentified` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_dnabanknumbers
DROP TABLE IF EXISTS `_log_dnabanknumbers`;
CREATE TABLE IF NOT EXISTS `_log_dnabanknumbers` (
  `ID_Log_DNA` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ID_DNA` bigint(20) NOT NULL,
  `ID_Cache` bigint(20) NOT NULL,
  `Provided_By_People` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `Location_Stock` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `DNA_Bank_Number` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `RelationDNA_Voucher` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Tissue` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Preservation` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Extraction_Date` datetime NOT NULL,
  `NoExtractDate` tinyint(4) DEFAULT NULL,
  `Extraction_Method` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Purification` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Extraction_Staff` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Degradation` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Check_Date` datetime NOT NULL,
  `Concentration` float NOT NULL,
  `Absorbance280` float NOT NULL,
  `Absorbance230` float NOT NULL,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Quantity_Aliquots` float NOT NULL,
  `Stock_Gone` tinyint(1) NOT NULL,
  `Source_Gone` tinyint(1) NOT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Notes` longtext COLLATE utf8_unicode_ci NOT NULL,
  `Block_Until` date NOT NULL,
  `Block_General` tinyint(1) NOT NULL,
  `Number_Aliquots` float NOT NULL,
  `Backup_Aliquot` tinyint(1) NOT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ID_Log_DNA`),
  KEY `ID_DNA` (`ID_DNA`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_dnabanknumbers: 0 rows
/*!40000 ALTER TABLE `_log_dnabanknumbers` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_dnabanknumbers` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_sptoolcollection
DROP TABLE IF EXISTS `_log_sptoolcollection`;
CREATE TABLE IF NOT EXISTS `_log_sptoolcollection` (
  `ID_Log_Collection` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_Collection` bigint(20) DEFAULT NULL,
  `UnitID_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CollectionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `InstitutionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FormerCollection` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CountryName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SeasAndOceans` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Collectors` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CollectionDateMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CollectionDateMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CollectorsNo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Locality_ID` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExpeditionDetails` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Region` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Locality` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Habitat` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Exposition` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DepthAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DepthMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DepthMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DepthUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AltitudeAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AltitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AltitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AltitudeUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CoordinatesAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CoordinatesErrorDistance` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LongitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LongitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LatitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LatitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LongitudeOther` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LatitudeOther` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Sex` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Protected` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Permission` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BasisOfRecord` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `KindOfUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Cache` bigint(20) DEFAULT NULL,
  `Type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Notes` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Blocked` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AccessionNo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AccessionName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LifeStage` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LifeForm` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_Log_Collection`),
  KEY `ID_Gathering` (`ID_Collection`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_sptoolcollection: 0 rows
/*!40000 ALTER TABLE `_log_sptoolcollection` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_sptoolcollection` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_sptoolecology
DROP TABLE IF EXISTS `_log_sptoolecology`;
CREATE TABLE IF NOT EXISTS `_log_sptoolecology` (
  `ID_Log_Ecology` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `ID_Ecology` bigint(10) unsigned NOT NULL DEFAULT '0',
  `ID_Collection` bigint(10) unsigned DEFAULT '0',
  `Value` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Unit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Parameter` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Method` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_Log_Ecology`),
  KEY `ID_Collection` (`ID_Collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_sptoolecology: 0 rows
/*!40000 ALTER TABLE `_log_sptoolecology` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_sptoolecology` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_sptoolhighertaxon
DROP TABLE IF EXISTS `_log_sptoolhighertaxon`;
CREATE TABLE IF NOT EXISTS `_log_sptoolhighertaxon` (
  `ID_Log_HigherTaxon` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_HigherTaxon` bigint(20) DEFAULT NULL,
  `ID_Taxa` bigint(20) DEFAULT NULL,
  `HigherTaxon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TaxonRank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Synecology` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_TaxonIdentified` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_Log_HigherTaxon`),
  KEY `ID_HigherTaxon` (`ID_HigherTaxon`),
  KEY `ID_Taxa` (`ID_Taxa`),
  KEY `ID_Log_TaxonIdentified` (`ID_Log_TaxonIdentified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_sptoolhighertaxon: 0 rows
/*!40000 ALTER TABLE `_log_sptoolhighertaxon` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_sptoolhighertaxon` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_sptoolimages
DROP TABLE IF EXISTS `_log_sptoolimages`;
CREATE TABLE IF NOT EXISTS `_log_sptoolimages` (
  `ID_Log_OfflineImages` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_Images` bigint(20) DEFAULT NULL,
  `ID_OfflineGathering` bigint(20) DEFAULT NULL,
  `ImageLink` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_OfflineGathering` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_Log_OfflineImages`),
  KEY `ID_Log_OfflineGathering` (`ID_Log_OfflineGathering`),
  KEY `ID_Images` (`ID_Images`),
  KEY `ID_OfflineGathering` (`ID_OfflineGathering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_sptoolimages: 0 rows
/*!40000 ALTER TABLE `_log_sptoolimages` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_sptoolimages` ENABLE KEYS */;


-- Dumping structure for table dnabank._log_sptooltaxa
DROP TABLE IF EXISTS `_log_sptooltaxa`;
CREATE TABLE IF NOT EXISTS `_log_sptooltaxa` (
  `ID_Log_TaxonIdentified` bigint(20) NOT NULL AUTO_INCREMENT,
  `ID_TaxonIdentified` bigint(20) DEFAULT NULL,
  `ID_Collection` bigint(20) DEFAULT NULL,
  `Genus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Subgenus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SpecificEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `InfraspecificEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Rank` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AuthorParenth` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `YearParenth` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Author` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Year` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NameAuthorYear` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `KindOfIdentification` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Identifier` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IdentificationDate` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PreferredFlag` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IdentificationNotes` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Synecology` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ID_Log_Collection` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID_Log_TaxonIdentified`),
  KEY `ID_Log_OfflineGathering` (`ID_Log_Collection`),
  KEY `ID_TaxonIdentified` (`ID_TaxonIdentified`),
  KEY `ID_Gathering` (`ID_Collection`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Dumping data for table dnabank._log_sptooltaxa: 0 rows
/*!40000 ALTER TABLE `_log_sptooltaxa` DISABLE KEYS */;
/*!40000 ALTER TABLE `_log_sptooltaxa` ENABLE KEYS */;


-- Dumping structure for view dnabank.wrapper_view_amplifications
DROP VIEW IF EXISTS `wrapper_view_amplifications`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_amplifications`;
CREATE VIEW `wrapper_view_amplifications` AS select `dnabank`.`amplifications`.`ID_DNA` AS `ID_DNA`,`dnabank`.`amplifications`.`ID_Amplification` AS `ID_Amplification`,`dnabank`.`geneticlocus`.`GeneticLocus` AS `GeneticLocus`,`dnabank`.`amplifications`.`GenBankNumber` AS `GenBankNumber`,`dnabank`.`amplifications`.`Link` AS `GenBankLink`,`dnabank`.`amplifications`.`Amplification_Date` AS `Amplification_Date`,`dnabank`.`amplifications`.`Amplification_Success` AS `Amplification_Success`,`dnabank`.`people`.`Name_All` AS `Amplification_Staff` from ((`amplifications` left join `geneticlocus` on((`dnabank`.`geneticlocus`.`ID_GeneticLocus` = `dnabank`.`amplifications`.`ID_GeneticLocus`))) left join `people` on((`dnabank`.`people`.`ID_People` = `dnabank`.`amplifications`.`ID_Amplification_Staff`))) ;


-- Dumping structure for view dnabank.wrapper_view_biotope
DROP VIEW IF EXISTS `wrapper_view_biotope`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_biotope`;
CREATEVIEW `wrapper_view_biotope` AS select `sptoolcollection`.`ID_Collection`,`soiltexture`.`SoilTexture`, 'Soil Texture' from (`sptoolcollection` join `soiltexture`) where ((`sptoolcollection`.`ID_SoilTexture` <> '') and (`sptoolcollection`.`ID_SoilTexture` = `soiltexture`.`ID_SoilTexture`)) 
union select `sptoolcollection`.`ID_Collection`,`habitatcode`.`HabitatCode`,'Habitat Code' from (`sptoolcollection` join `habitatcode`) where ((`sptoolcollection`.`ID_HabitatCode` <> '') and (`sptoolcollection`.`ID_HabitatCode` = `habitatcode`.`ID_HabitatCode`))
union select `sptoolcollection`.`ID_Collection`,`landusecode`.`LandUseCode`,'Land Use Code' from (`sptoolcollection` join `landusecode`) where ((`sptoolcollection`.`ID_LandUseCode` <> '') and (`sptoolcollection`.`ID_LandUseCode` = `landusecode`.`ID_LandUseCode`))
union select `sptoolcollection`.`ID_Collection`,`slope`.`Slope`,'Slope' from (`sptoolcollection` join `slope`) where ((`sptoolcollection`.`ID_Slope` <> '') and (`sptoolcollection`.`ID_Slope` = `slope`.`ID_Slope`)) ;


-- Dumping structure for view dnabank.wrapper_view_dna
DROP VIEW IF EXISTS `wrapper_view_dna`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_dna`;
CREATE VIEW `wrapper_view_dna` AS select `dnabank`.`dnabanknumbers`.`ID_DNA` AS `ID_DNA`,`specimencache`.`ID_Cache` AS `ID_Cache`,`dnabank`.`dnabanknumbers`.`DNA_Bank_Number` AS `DNA_Bank_Number`,`dnabank`.`dnatype`.`Type` AS `Type`,`dnabank`.`relationdna_voucher`.`RelationDNA_Voucher` AS `RelationDNA_Voucher`,`dnabank`.`tissue`.`Tissue` AS `Tissue`,`dnabank`.`preservation`.`Preservation` AS `Preservation`,`dnabank`.`people`.`Name_All` AS `Provided_By`,`dnabank`.`dnabanknumbers`.`Extraction_Date` AS `Extraction_Date`,`staff`.`Name_All` AS `Extraction_Staff`,`dnabank`.`extractionmethod`.`Method` AS `Extraction_Method`,`dnabank`.`extractionmethod`.`Company` AS `Extraction_Company`,`dnabank`.`purification`.`Method` AS `Purification_Method`,`dnabank`.`purification`.`Company` AS `Purification_Company`,`dnabank`.`dnabanknumbers`.`Absorbance280` AS `Absorbance280`,`dnabank`.`dnabanknumbers`.`Absorbance230` AS `Absorbance230`,`dnabank`.`dnabanknumbers`.`Concentration` AS `Concentration`,`quality`.`Degradation` AS `Quality`,`dnabank`.`dnabanknumbers`.`Check_Date` AS `Quality_Check_Date`,`dnabank`.`dnabanknumbers`.`Block_Until` AS `Block_Until`,`dnabank`.`dnabanknumbers`.`Notes` AS `Notes` from ((((((((((`dnabanknumbers` left join `dnatype` on((`dnabank`.`dnatype`.`ID_Type` = `dnabank`.`dnabanknumbers`.`ID_Type`))) left join `relationdna_voucher` on((`dnabank`.`relationdna_voucher`.`ID_RelationDNA_Voucher` = `dnabank`.`dnabanknumbers`.`ID_RelationDNA_Voucher`))) left join `tissue` on((`dnabank`.`tissue`.`ID_Tissue` = `dnabank`.`dnabanknumbers`.`ID_Tissue`))) left join `preservation` on((`dnabank`.`preservation`.`ID_Preservation` = `dnabank`.`dnabanknumbers`.`ID_Preservation`))) left join `people` on((`dnabank`.`people`.`ID_People` = `dnabank`.`dnabanknumbers`.`ID_Provided_By_People`))) left join `extractionmethod` on((`dnabank`.`extractionmethod`.`ID_Method` = `dnabank`.`dnabanknumbers`.`ID_Extraction_Method`))) left join `people` `staff` on((`staff`.`ID_People` = `dnabank`.`dnabanknumbers`.`ID_Extraction_Staff`))) left join `purification` on((`dnabank`.`purification`.`ID_Purification` = `dnabank`.`dnabanknumbers`.`ID_Purification`))) left join `degradation` `quality` on((`quality`.`ID_Degradation` = `dnabank`.`dnabanknumbers`.`ID_Degradation`))) left join `cachecollection` `specimencache` on((`specimencache`.`ID_Cache` = `dnabank`.`dnabanknumbers`.`ID_Cache`))) where (`dnabank`.`dnabanknumbers`.`Block_General` <> _utf8'1') ;


-- Dumping structure for view dnabank.wrapper_view_ecology
DROP VIEW IF EXISTS `wrapper_view_ecology`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_ecology`;
CREATE VIEW `wrapper_view_ecology` AS select `sptoolecology`.`ID_Collection` AS `ID_Collection`,`sptoolecology`.`Value` AS `Value`,`sptoolecology`.`Unit` AS `Unit`,`sptoolecology`.`Parameter` AS `Parameter`,`sptoolecology`.`Method` AS `Method` from `sptoolmeasurementorfact` AS `sptoolecology` where (`sptoolecology`.`Value` <> '' and `sptoolecology`.`Rank` = 'Ecology') union select `sptoolcollection`.`ID_Collection` AS `ID_Collection`,`soilph`.`SoilpH` AS `SoilpH`,'','Soil pH' AS `Soil pH`,'' from (`sptoolcollection` join `soilph`) where ((`sptoolcollection`.`ID_SoilpH` <> '') and (`sptoolcollection`.`ID_SoilpH` = `soilph`.`ID_SoilpH`)) ;


-- Dumping structure for view dnabank.wrapper_view_multimedia_site
DROP VIEW IF EXISTS `wrapper_view_multimedia_site`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_multimedia_site`;
CREATE VIEW `wrapper_view_multimedia_site` AS select `specimenmultimedia`.`ID_Multimedia` AS `ID_Multimedia`,`specimenmultimedia`.`ID_Collection` AS `ID_Collection`,`specimenmultimedia`.`File_Path` AS `Path`,`specimenmultimedia`.`File_Type` AS `Type`,`specimenmultimedia`.`File_Created_When` AS `Created_When`,`specimenmultimedia`.`File_Created_Who` AS `Created_Who`,`specimenmultimedia`.`File_Context` AS `Context`,`specimenmultimedia`.`File_Comment` AS `Comment` from `sptoolmultimedia` `specimenmultimedia` where (`specimenmultimedia`.`File_Group` = _utf8'site') ;


-- Dumping structure for view dnabank.wrapper_view_multimedia_specimens
DROP VIEW IF EXISTS `wrapper_view_multimedia_specimens`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_multimedia_specimens`;
CREATE VIEW `wrapper_view_multimedia_specimens` AS select `specimenmultimedia`.`ID_Multimedia` AS `ID_Multimedia`,`specimenmultimedia`.`ID_Collection` AS `ID_Collection`,`specimenmultimedia`.`File_Path` AS `Path`,`specimenmultimedia`.`File_Type` AS `Type`,`specimenmultimedia`.`File_Created_When` AS `Created_When`,`specimenmultimedia`.`File_Created_Who` AS `Created_Who`,`specimenmultimedia`.`File_Context` AS `Context`,`specimenmultimedia`.`File_Comment` AS `Comment` from `sptoolmultimedia` `specimenmultimedia` where (`specimenmultimedia`.`File_Group` = _utf8'specimen') ;


-- Dumping structure for view dnabank.wrapper_view_namedareas
DROP VIEW IF EXISTS `wrapper_view_namedareas`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_namedareas`;
CREATE VIEW `wrapper_view_namedareas` AS select `specimens`.`ID_Collection` AS `ID_Collection`, 'Continent', `country_continent`.`Continent` AS `Continent` 
from `sptoolcollection` AS `specimens` left join `country_continent` on `specimens`.ID_Country = `country_continent`.ID_Country where `specimens`.ID_Country <> ''
union select `specimens`.`ID_Collection` AS `ID_Collection`, 'Ocean', `seasandoceans`.`Ocean` AS `Ocean` 
from `sptoolcollection` AS `specimens` left join `seasandoceans` on `specimens`.ID_SeasAndOceans = `seasandoceans`.ID_SeasAndOceans where `specimens`.ID_SeasAndOceans <> ''
union select `specimens`.`ID_Collection` AS `ID_Collection`, 'Biogeographic Region', `biogeographicregion`.`BiogeographicRegion` AS `BiogeographicRegion` 
from `sptoolcollection` AS `specimens` left join `biogeographicregion` on `specimens`.ID_BiogeographicRegion = `biogeographicregion`.ID_BiogeographicRegion where `specimens`.ID_BiogeographicRegion <> '' ;


-- Dumping structure for view dnabank.wrapper_view_phases
DROP VIEW IF EXISTS `wrapper_view_phases`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_phases`;
CREATE VIEW `wrapper_view_phases` AS select ID_Collection, LifeForm FROM sptoolcollection where LifeForm != ""
UNION
select ID_Collection, LifeStage FROM sptoolcollection where LifeStage != "" ;


-- Dumping structure for view dnabank.wrapper_view_providers
DROP VIEW IF EXISTS `wrapper_view_providers`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_providers`;
CREATE `wrapper_view_providers` AS select `dnabank`.`dataset`.`ID_Dataset` AS `ID_Dataset`,`dnabank`.`dataset`.`Digir_Resource` AS `Digir_Resource`,`dnabank`.`dataset`.`Digir_Source` AS `Digir_Source`,`dnabank`.`provider`.`Provider` AS `Provider`,`dnabank`.`schemata`.`Schemata` AS `Schemata` from ((`dataset` left join `provider` on((`dnabank`.`provider`.`ID_Provider` = `dnabank`.`dataset`.`ID_Provider`))) left join `schemata` on((`dnabank`.`schemata`.`ID_Schema` = `dnabank`.`provider`.`ID_Schema`))) ;


-- Dumping structure for view dnabank.wrapper_view_publications_dna
DROP VIEW IF EXISTS `wrapper_view_publications_dna`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_publications_dna`;
CREATE `wrapper_view_publications_dna` AS select `publications_dna`.`ID_Pub_Amp` AS `ID_Pub_Amp`,`publications_dna`.`ID_Amplification` AS `ID_Amplification`,`publications_dna`.`Paper_Cache` AS `Paper_Cache`,`dnabank`.`publications`.`Link` AS `Link`,`publications_dna`.`GeneticLocus` AS `GeneticLocus` from (`publications_amplifications` `publications_dna` left join `publications` on((`dnabank`.`publications`.`ID_Publications` = `publications_dna`.`ID_Publications`))) ;


-- Dumping structure for view dnabank.wrapper_view_specimens
DROP VIEW IF EXISTS `wrapper_view_specimens`;
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `wrapper_view_specimens`;
CREATE VIEW `wrapper_view_specimens` AS select `specimens`.`ID_Collection` AS `ID_Collection`,`specimens`.`UnitID_Specimen` AS `UnitID_Specimen`,`specimens`.`CollectionCode_Specimen` AS `CollectionCode_Specimen`,`specimens`.`InstitutionCode_Specimen` AS `InstitutionCode_Specimen`,concat_ws(_utf8', ',`country_continent`.`Continent`,`seasandoceans`.`Ocean`) AS `ContinentOrOcean`,`countryisocode`.`Country` AS `CountryName`,`countryisocode`.`IsoCode` AS `CountryISO2`,`specimens`.`Collectors` AS `Collectors`,`specimens`.`CollectionDateMin` AS `CollectionDateMin`,`specimens`.`CollectionDateMax` AS `CollectionDateMax`,`specimens`.`CollectorsNo` AS `CollectorsNo`,`specimens`.`CollectionNotes` AS `CollectionNotes`,`specimens`.`CollectionMethod` AS `CollectionMethod`,`specimens`.`Locality_ID` AS `Locality_ID`,`specimens`.`ExpeditionDetails` AS `ExpeditionDetails`,concat_ws(_utf8', ',`seasandoceans`.`SeasAndOceans`,`specimens`.`Region`,`specimens`.`Locality`) AS `Locality`,`specimens`.`Habitat` AS `Habitat`,`specimens`.`DepthMin` AS `DepthMin`,`specimens`.`DepthMax` AS `DepthMax`,`specimens`.`DepthUnit` AS `DepthUnit`,`specimens`.`DepthAccuracyStatement` AS `DepthAccuracyStatement`,`specimens`.`DepthMethod` AS `DepthMethod`,`specimens`.`AltitudeMin` AS `AltitudeMin`,`specimens`.`AltitudeMax` AS `AltitudeMax`,`specimens`.`AltitudeUnit` AS `AltitudeUnit`,`specimens`.`AltitudeMethod` AS `AltitudeMethod`,`specimens`.`AltitudeAccuracyStatement` AS `AltitudeAccuracyStatement`,`specimens`.`LongitudeMin` AS `LongitudeDecimal`,`specimens`.`LatitudeMin` AS `LatitudeDecimal`,`specimens`.`CoordinatesAccuracyStatement` AS `CoordAccuracyStatement`,`specimens`.`CoordinatesErrorDistance` AS `CoordErrorDistance`,`specimens`.`GeodeticDatum` AS `GeodeticDatum`, `geocode`.`Geocode` AS `GeocodeMethod`,`sex`.`Sex` AS `Sex`,`basisofrecord`.`BasisOfRecord_Specimen` AS `BasisOfRecord`,`specimens`.`KindOfUnit` AS `KindOfUnit`,`specimens`.`PrepType` AS `PrepType`,`specimens`.`PrepStaff` AS `PrepStaff`,`typestatus`.`SpecimenType` AS `TypeStatus`,`specimens`.`Notes` AS `Notes`,`specimens`.`GUID` AS `GUID`, `specimens`.`VoucherRefText` AS `VoucherRefText`,`specimens`.`VoucherRefUrl` AS `VoucherRefUrl`, `aspect`.`Aspect` AS `Aspect` from `sptoolcollection` AS `specimens` left join `specimentype` `typestatus` on `typestatus`.`ID_SpecimenType` = `specimens`.`ID_Type` left join `basisofrecordspecimen` AS `basisofrecord` on `basisofrecord`.`ID_BasisOfRecord_Specimen` = `specimens`.`ID_BasisOfRecord` left join `sex` on `sex`.`ID_Sex` = `specimens`.`ID_Sex` left join `seasandoceans` on `seasandoceans`.`ID_SeasAndOceans` = `specimens`.`ID_SeasAndOceans` left join `countryisocode` on `countryisocode`.`ID_Country` = `specimens`.`ID_Country` left join `country_continent` on `country_continent`.`ID_Country` = `countryisocode`.`ID_Country` left join `prevalentaspect` AS `aspect` on `specimens`.`ID_Aspect` = `aspect`.`ID_Aspect` left join `geocodemethod` AS `geocode` on `specimens`.`ID_GeocodeMethod` = `geocode`.`ID_Geocode` where `specimens`.`Protected` <> _utf8'Yes' and `specimens`.`Permission` <> _utf8'No' and `specimens`.`Blocked` <> _utf8'Yes' ;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
