# Copyright (C) 2009 DNA Bank Network
# http://www.dnabank-network.org
#
# The contents of this file are subject to the Mozilla Public License Version 1.1
# See LICENSE.TXT at the top of this package for the full license terms.

# --------------------------------------------------------
# Host:                         #####
# Database:                     dna_kew
# Server version:               5.0.51a-24+lenny2+spu1
# Server OS:                    debian-linux-gnu
# HeidiSQL version:             5.0.0.3222
# Date/time:                    2010-04-13 14:03:23
# --------------------------------------------------------


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

# Dumping data for table dna_kew.tableabcdmetadata: 1 rows
INSERT INTO `tableabcdmetadata` (`MetadataID`, `DatasetGUID`, `TechnicalContactName`, `TechnicalContactEmail`, `TechnicalContactPhone`, `TechnicalContactAddress`, `ContentContactName`, `ContentContactEmail`, `ContentContactPhone`, `ContentContactAddress`, `OtherProviderUDDI`, `DatasetTitle`, `DatasetDetails`, `DatasetCoverage`, `DatasetURI`, `DatasetIconURI`, `DatasetVersionMajor`, `DatasetCreators`, `DatasetContributors`, `DateCreated`, `DateModified`, `OwnerOrganizationName`, `OwnerOrganizationAbbrev`, `OwnerContactPerson`, `OwnerContactRole`, `OwnerAddress`, `OwnerTelephone`, `OwnerEmail`, `OwnerURI`, `OwnerLogoURI`, `IPRText`, `IPRDetails`, `IPRURI`, `CopyrightText`, `CopyrightDetails`, `CopyrightURI`, `TermsOfUseText`, `TermsOfUseDetails`, `TermsOfUseURI`, `DisclaimersText`, `DisclaimersDetails`, `DisclaimersURI`, `LicenseText`, `LicensesDetails`, `LicenseURI`, `AcknowledgementsText`, `AcknowledgementsDetails`, `AcknowledgementsURI`, `CitationsText`, `CitationsDetails`, `CitationsURI`, `SourceInstitutionID`, `SourceID`, `RecordBasis`, `DNA_Quality_Description`) VALUES (1, NULL, 'Gabriele Dröge', 'g.droege@bgbm.org', '', 'Königin-Luise-Str.6-8, 14195 Berlin, Germany', 'Dr. Birgit Gemeinholzer', 'b.gemeinholzer@bgbm.org', NULL, 'Königin-Luise-Str.6-8, 14195 Berlin, Germany', NULL, 'DNA Bank of the Herbarium Berolinense', 'The DNA bank of the Botanic Garden and Botanical Museum Berlin-Dahlem holds currently a collection of 3100 plant DNA and 4300 plant tissue samples growing constantly. Its core collection focuses on the flora of the Berlin and Brandenburg but it also preserves DNA from the Alps, the Mediterranean and the Altai Mountains. \r\nThe DNA bank is part of the DNA Bank Network which was established in spring 2007 and is currently funded by the DFG. The network was initiated by GBIF Germany and provides a technically optimized DNA collection service facility for all biological research accessible via one central web portal. The network promotes deposition of well documented reference DNA samples after project completion or data publication from scientists of other universities and institutions.', NULL, NULL, NULL, '', 'Gabriele Dröge; Holger Zetzsche; Birgit Gemeinholzer', 'Botanic Garden and Botanical Museum Berlin-Dahlem', '2008-06-12 00:00:00', '2009-04-07 00:00:00', 'Botanic Garden an Botanical Museum Berlin-Dahlem (Freie Universität Berlin)', 'BGBM', '', NULL, 'Königin-Luise-Str. 6-8, 14195 Berlin, Germany', NULL, '', 'http://www.bgbm.org', 'http://www.bgbm.org/BGBM/icons/bgbmlogo.gif', '', NULL, '', 'The copyright for any material created by the DNA bank of the BGBM is reserved. The duplication or use of information and data such as texts or images is only permitted with the indication of the source or with prior approval by the BGBM.', NULL, NULL, 'The use of the data is allowed only for non-profit scientific use and for non-profit nature conservation purpose. The data bases or part of it may only be used or copied by the written permission from the legal owner.', NULL, NULL, '', NULL, NULL, '', NULL, NULL, '', NULL, NULL, 'Dröge, G., Zetzsche, H. & Gemeinholzer, B. (Ed.) 2008 - (continuously updated): DNA samples of the DNA bank at the BGBM (Botanic Garden and Botanical Museum Berlin-Dahlem).', NULL, NULL, 'BGBM', 'DNA Bank', 'OtherSpecimen', NULL);


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

# Dumping data for table dna_kew.tableabcdmetadataspecimens: 1 rows
INSERT INTO `tableabcdmetadataspecimens` (`MetadataID`, `DatasetGUID`, `TechnicalContactName`, `TechnicalContactEmail`, `TechnicalContactPhone`, `TechnicalContactAddress`, `ContentContactName`, `ContentContactEmail`, `ContentContactPhone`, `ContentContactAddress`, `OtherProviderUDDI`, `DatasetTitle`, `DatasetDetails`, `DatasetCoverage`, `DatasetURI`, `DatasetIconURI`, `DatasetVersionMajor`, `DatasetCreators`, `DatasetContributors`, `DateCreated`, `DateModified`, `OwnerOrganizationName`, `OwnerOrganizationAbbrev`, `OwnerContactPerson`, `OwnerContactRole`, `OwnerAddress`, `OwnerTelephone`, `OwnerEmail`, `OwnerURI`, `OwnerLogoURI`, `IPRText`, `IPRDetails`, `IPRURI`, `CopyrightText`, `CopyrightDetails`, `CopyrightURI`, `TermsOfUseText`, `TermsOfUseDetails`, `TermsOfUseURI`, `DisclaimersText`, `DisclaimersDetails`, `DisclaimersURI`, `LicenseText`, `LicensesDetails`, `LicenseURI`, `AcknowledgementsText`, `AcknowledgementsDetails`, `AcknowledgementsURI`, `CitationsText`, `CitationsDetails`, `CitationsURI`, `SourceInstitutionID`, `SourceID`, `RecordBasis`, `DNA_Quality_Description`) VALUES (1, NULL, 'Gabriele Dröge', 'g.droege@bgbm.org', '', 'Königin-Luise-Str. 6-8, 14195 Berlin, Germany', 'Botanic Garden and Botanical Museum Berlin-Dahlem', 'g.droege@bgbm.org', NULL, 'Königin-Luise-Str. 6-8, 14195 Berlin, Germany', NULL, 'Herbarium Berolinense', 'The herbarium of the Botanic Garden and Botanical Museum Berlin-Dahlem (herbarium acronym: B) is the largest in Germany and holds a collection of more than 3.5 million preserved specimens. All plant groups – flowering plants, ferns, mosses, liverworts, and algae, as well as fungi and lichens – are represented in the collections which are worldwide in scope. Associated with the general herbarium are special collections of dried fruits and seeds, wood samples, and specimens preserved in alcohol. The collections of the herbarium are growing constantly through field research conducted by staff, and through gifts, acquisitions, and exchanges of specimens from other herbaria', NULL, NULL, NULL, '', NULL, NULL, '2008-06-12 00:00:00', '2008-06-12 00:00:00', 'Botanic Garden an Botanical Museum Berlin-Dahlem (Freie Universität Berlin)', 'BGBM', '', NULL, 'Königin-Luise-Str. 6-8, 14195 Berlin, Germany', NULL, '', 'http://www.bgbm.de/', 'http://www.bgbm.org/BGBM/icons/bgbmlogo.gif', '', NULL, '', '', NULL, NULL, 'The use of the data is allowed only for non-profit scientific use and for non-profit nature conservation purpose. The data base or part of it may only be used or copied by the written permission from the legal owner.', NULL, NULL, '', NULL, NULL, '', NULL, NULL, '', NULL, NULL, '', NULL, NULL, 'ZSM', 'ZSM', 'PreservedSpecimen', NULL);


# Dumping structure for table dna_kew.tablealiquots
CREATE TABLE IF NOT EXISTS `tablealiquots` (
  `ID_Aliquots` bigint(20) NOT NULL auto_increment,
  `ID_DNA` bigint(20) NOT NULL,
  `ID_Aliquots_Box` bigint(20) NOT NULL,
  `ID_Aliquots_Rack` bigint(20) NOT NULL,
  `ID_Aliquots_Fridge` bigint(20) NOT NULL,
  `Aliquot_Number` varchar(100) collate utf8_unicode_ci NOT NULL,
  `Origin_Quantity` float NOT NULL,
  `Rest_Quantity` float NOT NULL,
  `Aliquot_Position` varchar(50) collate utf8_unicode_ci default NULL,
  `Aliquot_Barcode` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `Order_All` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Order_Partial` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Order_Rest` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_All` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_Partial` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_Rest` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  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 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablealiquots: 0 rows


# Dumping structure for table dna_kew.tablealiquots_box
CREATE TABLE IF NOT EXISTS `tablealiquots_box` (
  `ID_Aliquots_Box` bigint(20) NOT NULL auto_increment,
  `Aliquots_Box` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Aliquots_Box`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablealiquots_box: 4 rows
INSERT INTO `tablealiquots_box` (`ID_Aliquots_Box`, `Aliquots_Box`, `Created_When`, `Created_Who`) VALUES (1, '1', '2009-05-07 12:24:01', 'H.Zetzsche'), (2, '2', '2009-05-07 12:24:02', 'H.Zetzsche'), (3, '3', '2009-05-07 12:24:03', 'H.Zetzsche'), (4, '4', '2009-05-07 12:24:04', 'H.Zetzsche');


# Dumping structure for table dna_kew.tablealiquots_fridge
CREATE TABLE IF NOT EXISTS `tablealiquots_fridge` (
  `ID_Aliquots_Fridge` int(11) NOT NULL auto_increment,
  `Aliquots_Fridge` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Aliquots_Fridge`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablealiquots_fridge: 1 rows
INSERT INTO `tablealiquots_fridge` (`ID_Aliquots_Fridge`, `Aliquots_Fridge`, `Created_When`, `Created_Who`) VALUES (1, 'Scrat', '2009-05-07 12:23:53', 'H.Zetzsche');


# Dumping structure for table dna_kew.tablealiquots_rack
CREATE TABLE IF NOT EXISTS `tablealiquots_rack` (
  `ID_Aliquots_Rack` int(11) NOT NULL auto_increment,
  `Aliquots_Rack` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`ID_Aliquots_Rack`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablealiquots_rack: 2 rows
INSERT INTO `tablealiquots_rack` (`ID_Aliquots_Rack`, `Aliquots_Rack`, `Created_When`, `Created_Who`) VALUES (1, '1', '2009-05-07 12:23:58', 'H.Zetzsche'), (2, '2', '2009-05-07 12:24:00', 'H.Zetzsche');


# Dumping structure for table dna_kew.tableamplifications
CREATE TABLE IF NOT EXISTS `tableamplifications` (
  `ID_Amplification` bigint(20) NOT NULL auto_increment,
  `ID_DNA` bigint(20) NOT NULL,
  `ID_Fragment` bigint(20) NOT NULL,
  `GenBankNumber` varchar(150) collate utf8_unicode_ci NOT NULL,
  `Link` longtext collate utf8_unicode_ci NOT NULL,
  `Amplification_Date` date NOT NULL,
  `ID_Amplification_Staff` bigint(20) NOT NULL,
  `Amplification_Success` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Cons_Sequence` longtext collate utf8_unicode_ci,
  `Cons_Sequence_Link` longtext collate utf8_unicode_ci,
  `ID_Primer1` bigint(20) NOT NULL,
  `ID_Primer2` bigint(20) NOT NULL,
  `Fasta1_Link` longtext collate utf8_unicode_ci,
  `Fasts2_Link` longtext collate utf8_unicode_ci,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID_Amplification`),
  KEY `TableGenbank_Numbers_FKIndex1` (`ID_DNA`),
  KEY `ID_Fragment` (`ID_Fragment`),
  KEY `ID_Amplification_Staff` (`ID_Amplification_Staff`),
  KEY `ID_Primer1` (`ID_Primer1`),
  KEY `ID_Primer2` (`ID_Primer2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableamplifications: 0 rows


# Dumping structure for table dna_kew.tableauthors
CREATE TABLE IF NOT EXISTS `tableauthors` (
  `ID_Author` bigint(20) NOT NULL auto_increment,
  `Author` longtext collate latin1_general_ci NOT NULL,
  `Created_Who` varchar(50) collate latin1_general_ci default NULL,
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID_Author`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tableauthors: 0 rows


# Dumping structure for table dna_kew.tablebasisofrecordspecimen
CREATE TABLE IF NOT EXISTS `tablebasisofrecordspecimen` (
  `ID_BasisOfRecord_Specimen` bigint(20) NOT NULL auto_increment,
  `BasisOfRecord_Specimen` varchar(50) collate latin1_general_ci NOT NULL,
  `Description` varchar(255) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`ID_BasisOfRecord_Specimen`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablebasisofrecordspecimen: 5 rows
INSERT INTO `tablebasisofrecordspecimen` (`ID_BasisOfRecord_Specimen`, `BasisOfRecord_Specimen`, `Description`) VALUES (1, 'Specimen', 'A physical object representing one or more organisms.'), (2, 'Observation', 'A report by a known observer'), (3, 'Living', 'An organism removed from its natural occurrence and now living in captivity or cultivation'), (4, 'Germplasm', 'Plant, animal and bacterial genetic material for use in breeding new organisms'), (5, 'Fossil', 'A physical object representing one or more fossil organisms');


# Dumping structure for table dna_kew.tableberlinbrandenburg
CREATE TABLE IF NOT EXISTS `tableberlinbrandenburg` (
  `ID_BB` bigint(20) unsigned NOT NULL auto_increment,
  `NameAuthorYear` varchar(255) default NULL,
  `Genus` varchar(255) default NULL,
  `FirstEpithet` varchar(255) default NULL,
  `Rank` varchar(50) NOT NULL,
  `SecondEpithet` varchar(255) NOT NULL,
  `Rank2` varchar(50) NOT NULL,
  `ThirdEpithet` varchar(255) NOT NULL,
  `EinwanderungsZeitraum` varchar(10) NOT NULL,
  `RL_BB_heute` varchar(10) NOT NULL,
  `RL_BB_1993` varchar(10) NOT NULL,
  `RL_BRD` varchar(10) NOT NULL,
  `Bundesartenschutz` varchar(10) NOT NULL,
  `In_DNA_Bank` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID_BB`),
  KEY `Genus` (`ID_BB`),
  KEY `FirstEpithet` (`FirstEpithet`),
  KEY `SecondEpithet` (`SecondEpithet`),
  KEY `ThirdEpithet` (`ThirdEpithet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Komplettliste BB';

# Dumping data for table dna_kew.tableberlinbrandenburg: 0 rows


# Dumping structure for table dna_kew.tablecache
CREATE TABLE IF NOT EXISTS `tablecache` (
  `ID_Cache` bigint(20) NOT NULL auto_increment,
  `ID_Dataset_Specimen` bigint(20) unsigned NOT NULL,
  `UnitID_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `CollectionCode_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `InstitutionCode_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `ContinentOrOcean` varchar(255) collate utf8_unicode_ci NOT NULL,
  `CountryName` varchar(255) collate utf8_unicode_ci NOT NULL,
  `CountryISO2` varchar(50) collate utf8_unicode_ci NOT NULL,
  `GatheringAgent` longtext collate utf8_unicode_ci NOT NULL,
  `GatheringDate` longtext collate utf8_unicode_ci NOT NULL,
  `GatheringNo` varchar(100) collate utf8_unicode_ci default NULL,
  `LocalityText` longtext collate utf8_unicode_ci NOT NULL,
  `Altitude` varchar(50) collate utf8_unicode_ci NOT NULL,
  `LongitudeDecimal` varchar(50) collate utf8_unicode_ci NOT NULL,
  `LatitudeDecimal` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Gathering_Other` longtext collate utf8_unicode_ci NOT NULL,
  `TypeStatus` varchar(150) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_Cache`),
  KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablecache: 0 rows


# Dumping structure for table dna_kew.tablecachehighertaxa
CREATE TABLE IF NOT EXISTS `tablecachehighertaxa` (
  `ID_HigherTaxon` bigint(20) NOT NULL auto_increment,
  `ID_CacheTaxonIdentified` bigint(20) NOT NULL,
  `HigherTaxon` varchar(255) collate utf8_unicode_ci NOT NULL,
  `TaxonRank` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_HigherTaxon`),
  KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`),
  KEY `HigherTaxon` (`HigherTaxon`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablecachehighertaxa: 0 rows


# Dumping structure for table dna_kew.tablecacheimages
CREATE TABLE IF NOT EXISTS `tablecacheimages` (
  `ID_Images` bigint(20) NOT NULL auto_increment,
  `ID_Cache` bigint(20) NOT NULL,
  `Images` longtext collate latin1_general_ci NOT NULL,
  `Created_Who` varchar(50) collate latin1_general_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated._Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID_Images`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablecacheimages: 0 rows


# Dumping structure for table dna_kew.tablecachetaxonidentified
CREATE TABLE IF NOT EXISTS `tablecachetaxonidentified` (
  `ID_TaxonIdentified` bigint(20) NOT NULL auto_increment,
  `ID_Cache` bigint(20) NOT NULL,
  `Genus` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Subgenus` varchar(255) collate utf8_unicode_ci NOT NULL,
  `FirstEpithet` varchar(255) collate utf8_unicode_ci NOT NULL,
  `SecondEpithet` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Rank` varchar(50) collate utf8_unicode_ci NOT NULL,
  `HybridFlag` tinyint(4) NOT NULL,
  `Other` longtext collate utf8_unicode_ci NOT NULL,
  `NameAuthorYear` longtext collate utf8_unicode_ci NOT NULL,
  `PreferredFlag` tinytext collate utf8_unicode_ci NOT NULL,
  `GroupOrganism` varchar(20) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_TaxonIdentified`),
  KEY `Genus` (`Genus`),
  KEY `FirstEpithet` (`FirstEpithet`),
  KEY `SecondEpithet` (`SecondEpithet`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablecachetaxonidentified: 0 rows


# Dumping structure for table dna_kew.tablecontinentorocean
CREATE TABLE IF NOT EXISTS `tablecontinentorocean` (
  `ID_Continent` bigint(20) NOT NULL auto_increment,
  `ContinentOrOcean` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Continent`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablecontinentorocean: 12 rows
INSERT INTO `tablecontinentorocean` (`ID_Continent`, `ContinentOrOcean`) VALUES (1, 'Africa'), (2, 'Middle and South America'), (3, 'Asia'), (4, 'Australia and Oceania'), (5, 'Europe'), (6, 'North America'), (7, 'Atlantic Ocean'), (8, 'Arctic Ocean'), (9, 'Indian Ocean'), (10, 'Pacific Ocean'), (11, 'Southern Ocean'), (12, 'Landlocked Sea');


# Dumping structure for table dna_kew.tablecountryisocode
CREATE TABLE IF NOT EXISTS `tablecountryisocode` (
  `ID_Country` bigint(20) NOT NULL auto_increment,
  `IsoCode` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Country` varchar(150) collate utf8_unicode_ci NOT NULL,
  `ID_Continent` bigint(20) NOT NULL,
  PRIMARY KEY  (`ID_Country`),
  KEY `ID_Continent` (`ID_Continent`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


# Dumping structure for table dna_kew.tabledataset
CREATE TABLE IF NOT EXISTS `tabledataset` (
  `ID_Dataset` bigint(20) NOT NULL auto_increment,
  `ID_Provider` bigint(20) NOT NULL,
  `Digir_Resource` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Digir_Source` varchar(255) collate utf8_unicode_ci NOT NULL,
  `View` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Intern_Extern` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Dataset`),
  KEY `ID_Provider` (`ID_Provider`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tabledataset: 6 rows
INSERT INTO `tabledataset` (`ID_Dataset`, `ID_Provider`, `Digir_Resource`, `Digir_Source`, `View`, `Intern_Extern`, `Created_When`, `Created_Who`) VALUES (1, 0, '', '', ' Offline Specimen Data', '1', '2008-07-02 13:00:43', 'G.Droege'), (2, 1, '', '', 'Herbarium Berolinense', '2', '2008-07-02 13:54:43', 'G.Droege'), (8, 8, 'GBIF', 'http://www.kew.org:80/digir/www/DiGIR.php', 'HerbCat', '1', '2009-11-13 13:10:27', 'T.Fulcher'), (5, 4, '', '', 'Naational Herbarium Nederland', '2', '2009-04-12 20:00:31', 'G.Droege'), (6, 5, 'NMNH-Botany', 'http://nhb-acsmith1.si.edu/emuwebbotweb/webservices/digir.php', 'Smithsonian', '2', '2009-04-12 20:21:26', 'G.Droege'), (7, 6, '', '', 'Herbarium Vienna, W', '2', '2009-06-02 18:15:30', 'Guest');


# Dumping structure for table dna_kew.tabledegradation
CREATE TABLE IF NOT EXISTS `tabledegradation` (
  `ID_Degradation` bigint(20) NOT NULL auto_increment,
  `Degradation` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_Degradation`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tabledegradation: 3 rows
INSERT INTO `tabledegradation` (`ID_Degradation`, `Degradation`) VALUES (1, 'low'), (2, 'medium'), (3, 'high');


# Dumping structure for table dna_kew.tablednabanknumbers
CREATE TABLE IF NOT EXISTS `tablednabanknumbers` (
  `ID_DNA` bigint(20) NOT NULL auto_increment,
  `ID_Cache` bigint(20) NOT NULL,
  `ID_Provided_By_People` bigint(20) NOT NULL,
  `ID_Type` bigint(20) NOT NULL,
  `ID_Location_Stock` bigint(20) NOT NULL,
  `DNA_Bank_Number` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ID_RelationDNA_Voucher` bigint(20) NOT NULL,
  `ID_Tissue` bigint(20) NOT NULL,
  `ID_Preservation` bigint(20) NOT NULL,
  `Extraction_Date` date NOT NULL,
  `NoExtractDate` tinyint(4) default NULL,
  `ID_Extraction_Method` bigint(20) NOT NULL,
  `ID_Purification` bigint(20) NOT NULL,
  `ID_Extraction_Staff` bigint(20) NOT NULL,
  `ID_Degradation` bigint(20) NOT NULL,
  `Degradation_Date` date NOT NULL,
  `Concentration` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Absorbance280` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Absorbance230` varchar(50) collate utf8_unicode_ci NOT NULL,
  `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,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Notes` varchar(500) collate utf8_unicode_ci NOT NULL default '',
  `Notes_Intern` varchar(500) collate utf8_unicode_ci default NULL,
  `Block_Until` date NOT NULL,
  `Block_General` tinyint(1) NOT NULL,
  `Number_Aliquots` float NOT NULL,
  `Backup_Aliquot` tinyint(1) NOT NULL,
  `Update_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Lock_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Lock_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  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_People` (`ID_Provided_By_People`),
  KEY `ID_RelationDNA_Voucher` (`ID_RelationDNA_Voucher`),
  KEY `ID_Purification` (`ID_Purification`),
  KEY `ID_Extraction_Staff` (`ID_Extraction_Staff`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablednabanknumbers: 0 rows


# Dumping structure for table dna_kew.tableextractionmethod
CREATE TABLE IF NOT EXISTS `tableextractionmethod` (
  `ID_Method` bigint(20) NOT NULL auto_increment,
  `Method` varchar(255) collate utf8_unicode_ci default NULL,
  `Company` varchar(255) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Method`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableextractionmethod: 3 rows
INSERT INTO `tableextractionmethod` (`ID_Method`, `Method`, `Company`, `Created_When`, `Created_Who`) VALUES (1, 'DNeasy Plant Mini Spin Kit', 'Qiagen', '2008-07-02 14:46:28', 'G.Droege'), (2, 'NucleoSpin Plant II', 'Macherey & Nagel', '2008-07-02 14:46:37', 'G.Droege'), (3, 'unknown', NULL, '2008-07-02 14:46:50', 'G.Droege');


# Dumping structure for table dna_kew.tablefragment
CREATE TABLE IF NOT EXISTS `tablefragment` (
  `ID_Fragment` bigint(20) NOT NULL auto_increment,
  `Fragment` varchar(150) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Fragment`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablefragment: 2 rows
INSERT INTO `tablefragment` (`ID_Fragment`, `Fragment`, `Created_When`, `Created_Who`) VALUES (1, 'ITS (ITS1, 5.8S rRNA, ITS2)', '2008-07-08 17:27:56', 'G.Droege'), (2, 'matK', '2009-09-02 11:10:32', 'G.Droege');


# Dumping structure for table dna_kew.tableimages
CREATE TABLE IF NOT EXISTS `tableimages` (
  `ID_Images` bigint(20) NOT NULL auto_increment,
  `ID_DNA` bigint(20) default NULL,
  `ImageUrl` mediumtext,
  `ImageRemarks` varchar(150) default NULL,
  PRIMARY KEY  (`ID_Images`),
  KEY `ID_DNA` (`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gel Images';

# Dumping data for table dna_kew.tableimages: 0 rows


# Dumping structure for table dna_kew.tableinstitut
CREATE TABLE IF NOT EXISTS `tableinstitut` (
  `ID_Institut` bigint(20) NOT NULL auto_increment,
  `University` varchar(255) collate utf8_unicode_ci default NULL,
  `Division` varchar(255) collate utf8_unicode_ci default NULL,
  `Address` varchar(255) collate utf8_unicode_ci default NULL,
  `Postal_Code` varchar(50) collate utf8_unicode_ci default NULL,
  `City` varchar(255) collate utf8_unicode_ci default NULL,
  `Country` varchar(255) collate utf8_unicode_ci default NULL,
  `Homepage` mediumtext collate utf8_unicode_ci,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ID_Institut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableinstitut: 0 rows


# Dumping structure for table dna_kew.tablejournals
CREATE TABLE IF NOT EXISTS `tablejournals` (
  `ID_Journal` bigint(20) NOT NULL auto_increment,
  `Journal_View` varchar(255) collate latin1_general_ci NOT NULL,
  `Journal_All` longtext collate latin1_general_ci NOT NULL,
  `Created_Who` varchar(50) collate latin1_general_ci default NULL,
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID_Journal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablejournals: 0 rows


# Dumping structure for table dna_kew.tablelocation_stock
CREATE TABLE IF NOT EXISTS `tablelocation_stock` (
  `ID_Location_Stock` int(11) NOT NULL auto_increment,
  `ID_Stock_Box` bigint(20) NOT NULL,
  `ID_Stock_Rack` bigint(20) NOT NULL,
  `ID_Stock_Fridge` int(11) NOT NULL,
  `Stock_Position` varchar(50) collate utf8_unicode_ci default NULL,
  `Stock_Barcode` longtext collate utf8_unicode_ci,
  `Origin_Quantity` float NOT NULL,
  `Rest_Quantity` float NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Update_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  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 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablelocation_stock: 0 rows


# Dumping structure for table dna_kew.tableofflinegathering
CREATE TABLE IF NOT EXISTS `tableofflinegathering` (
  `ID_Gathering` bigint(20) NOT NULL auto_increment,
  `UnitID_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `CollectionCode_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `InstitutionCode_Specimen` varchar(255) collate utf8_unicode_ci NOT NULL,
  `ContinentOrOcean` varchar(50) collate utf8_unicode_ci NOT NULL,
  `CountryName` varchar(255) collate utf8_unicode_ci NOT NULL,
  `CountryISO2` varchar(50) collate utf8_unicode_ci NOT NULL,
  `SeasAndOceans` varchar(255) collate utf8_unicode_ci NOT NULL,
  `GatheringAgent` longtext collate utf8_unicode_ci NOT NULL,
  `GatheringDate` longtext collate utf8_unicode_ci NOT NULL,
  `GatheringNo` mediumtext collate utf8_unicode_ci NOT NULL,
  `Locality_ID` varchar(150) collate utf8_unicode_ci default NULL,
  `TitleLabel` longtext collate utf8_unicode_ci NOT NULL,
  `ExpeditionDetails` longtext collate utf8_unicode_ci NOT NULL,
  `Region` longtext collate utf8_unicode_ci NOT NULL,
  `Locality` longtext collate utf8_unicode_ci NOT NULL,
  `Biotope` longtext collate utf8_unicode_ci NOT NULL,
  `Depth` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Altitude` varchar(50) collate utf8_unicode_ci NOT NULL,
  `LongitudeDecimal` float NOT NULL,
  `LatitudeDecimal` float NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ID_Sex` bigint(20) NOT NULL,
  `Protected` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Admission` varchar(50) collate utf8_unicode_ci NOT NULL,
  `ID_BasisOfRecord` bigint(20) NOT NULL,
  `ID_Cache` bigint(20) NOT NULL,
  `ID_Type` bigint(20) NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_Gathering`),
  KEY `ID_Sex` (`ID_Sex`),
  KEY `ID_BasisOfRecord` (`ID_BasisOfRecord`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Type` (`ID_Type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableofflinegathering: 0 rows


# Dumping structure for table dna_kew.tableofflinehighertaxon
CREATE TABLE IF NOT EXISTS `tableofflinehighertaxon` (
  `ID_HigherTaxon` bigint(20) NOT NULL auto_increment,
  `ID_Taxa` bigint(20) NOT NULL,
  `HigherTaxon` varchar(255) collate utf8_unicode_ci NOT NULL,
  `TaxonRank` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_HigherTaxon`),
  KEY `ID_Taxa` (`ID_Taxa`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableofflinehighertaxon: 0 rows


# Dumping structure for table dna_kew.tableofflineimages
CREATE TABLE IF NOT EXISTS `tableofflineimages` (
  `ID_Images` bigint(20) NOT NULL auto_increment,
  `ID_OfflineGathering` bigint(20) NOT NULL,
  `ImageLink` longtext collate latin1_general_ci NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate latin1_general_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID_Images`),
  KEY `ID_OfflineGathering` (`ID_OfflineGathering`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tableofflineimages: 0 rows


# Dumping structure for table dna_kew.tableofflinetaxa
CREATE TABLE IF NOT EXISTS `tableofflinetaxa` (
  `ID_TaxonIdentified` bigint(20) NOT NULL auto_increment,
  `ID_Gathering` bigint(20) NOT NULL,
  `Genus` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Subgenus` varchar(255) collate utf8_unicode_ci NOT NULL,
  `FirstEpithet` varchar(255) collate utf8_unicode_ci NOT NULL,
  `SecondEpithet` varchar(255) collate utf8_unicode_ci NOT NULL,
  `Rank` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Author` longtext collate utf8_unicode_ci NOT NULL,
  `Year` year(4) NOT NULL,
  `NameAuthorYear` longtext collate utf8_unicode_ci NOT NULL,
  `Identifier` longtext collate utf8_unicode_ci NOT NULL,
  `IdentificationDate` longtext collate utf8_unicode_ci NOT NULL,
  `PreferredFlag` varchar(50) collate utf8_unicode_ci NOT NULL,
  `EntryNameFlag` tinyint(4) NOT NULL,
  `Notes` mediumtext collate utf8_unicode_ci,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_TaxonIdentified`),
  KEY `ID_Gathering` (`ID_Gathering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableofflinetaxa: 0 rows


# Dumping structure for table dna_kew.tablepeople
CREATE TABLE IF NOT EXISTS `tablepeople` (
  `ID_People` bigint(20) NOT NULL auto_increment,
  `ID_Institut` bigint(20) default NULL,
  `Title` varchar(100) collate utf8_unicode_ci default NULL,
  `Forename` varchar(50) collate utf8_unicode_ci default NULL,
  `Surname` varchar(50) collate utf8_unicode_ci default NULL,
  `Phone` varchar(100) collate utf8_unicode_ci default NULL,
  `Email` varchar(100) collate utf8_unicode_ci default NULL,
  `Name_All` varchar(50) collate utf8_unicode_ci default NULL,
  `Customer_Number` float default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Updated_When` timestamp NULL default '0000-00-00 00:00:00',
  `Updated_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_People`),
  KEY `TableCustomers_Person_FKIndex1` (`ID_Institut`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablepeople: 1 rows
INSERT INTO `tablepeople` (`ID_People`, `ID_Institut`, `Title`, `Forename`, `Surname`, `Phone`, `Email`, `Name_All`, `Customer_Number`, `Created_When`, `Created_Who`, `Updated_When`, `Updated_Who`) VALUES (1, 0, '', '', 'Unknown', '', '', 'Unknown', NULL, '2009-11-13 15:03:58', 'T.Fulcher', '0000-00-00 00:00:00', NULL);


# Dumping structure for table dna_kew.tablepeople_rank
CREATE TABLE IF NOT EXISTS `tablepeople_rank` (
  `ID_People` bigint(20) NOT NULL,
  `ID_Rank` int(11) NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  KEY `TablePerson_Rank_FKIndex2` (`ID_Rank`),
  KEY `TablePeople_Rank_FKIndex2` (`ID_People`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablepeople_rank: 2 rows
INSERT INTO `tablepeople_rank` (`ID_People`, `ID_Rank`, `Created_When`, `Created_Who`) VALUES (1, 1, '2009-11-09 13:51:48', 'T.Fulcher'), (1, 1, '2009-11-13 15:03:58', 'T.Fulcher');


# Dumping structure for table dna_kew.tablepreservation
CREATE TABLE IF NOT EXISTS `tablepreservation` (
  `ID_Preservation` bigint(20) NOT NULL auto_increment,
  `Preservation` varchar(150) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Preservation`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablepreservation: 6 rows
INSERT INTO `tablepreservation` (`ID_Preservation`, `Preservation`, `Created_When`, `Created_Who`) VALUES (1, 'silica gel', '2008-07-15 14:29:45', 'G.Droege'), (2, 'herbarium sheet', '2009-04-10 17:24:17', 'G.Droege'), (3, 'seed specimen (dried)', '2009-04-10 17:24:46', 'G.Droege'), (4, 'unknown', '2009-04-10 17:25:22', 'G.Droege'), (5, 'fresh', '2009-05-26 15:35:25', 'G.Droege'), (6, 'fresh (degraded)', '2009-07-15 11:08:23', 'G.Droege');


# Dumping structure for table dna_kew.tableprimer
CREATE TABLE IF NOT EXISTS `tableprimer` (
  `ID_Primer` bigint(20) unsigned NOT NULL auto_increment,
  `Primer` mediumtext,
  `Sequence` longtext,
  `Created_Who` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Created_When` varchar(50) default NULL,
  PRIMARY KEY  (`ID_Primer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.tableprimer: 0 rows


# Dumping structure for table dna_kew.tableprovider
CREATE TABLE IF NOT EXISTS `tableprovider` (
  `ID_Provider` bigint(20) NOT NULL auto_increment,
  `Provider` varchar(500) collate utf8_unicode_ci NOT NULL default '',
  `ID_Schema` bigint(20) NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Provider`),
  KEY `ID_Schema` (`ID_Schema`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tableprovider: 5 rows
INSERT INTO `tableprovider` (`ID_Provider`, `Provider`, `ID_Schema`, `Created_When`, `Created_Who`) VALUES (1, 'http://ww3.bgbm.org/biocase/pywrapper.cgi?dsa=Herbar', 2, '2008-07-02 13:54:43', 'G.Droege'), (4, 'http://145.18.162.91/biocase/pywrapper.cgi?dsa=NHN-W', 1, '2009-04-12 20:00:31', 'G.Droege'), (5, 'http://nhb-acsmith1.si.edu/emuwebbotweb/webservices/digir.php', 6, '2009-04-12 20:21:26', 'G.Droege'), (6, 'http://131.130.131.9/biocase/pywrapper.cgi?dsa=gbif_w', 1, '2009-06-02 18:15:30', 'Guest'), (8, 'http://www.kew.org/digir/www/DiGIR.php', 3, '2009-11-13 13:10:27', 'T.Fulcher');


# Dumping structure for table dna_kew.tablepublications
CREATE TABLE IF NOT EXISTS `tablepublications` (
  `ID_Publications` bigint(20) NOT NULL auto_increment,
  `Editors` varchar(10) collate latin1_general_ci NOT NULL,
  `Year` varchar(20) collate latin1_general_ci NOT NULL default '',
  `Title` longtext collate latin1_general_ci NOT NULL,
  `ID_Journal` bigint(20) NOT NULL,
  `Volume` varchar(50) collate latin1_general_ci NOT NULL,
  `Pages` varchar(50) collate latin1_general_ci NOT NULL,
  `Book` longtext collate latin1_general_ci NOT NULL,
  `Publisher` varchar(255) collate latin1_general_ci NOT NULL,
  `Link` longtext collate latin1_general_ci NOT NULL,
  `Created_Who` varchar(50) collate latin1_general_ci default NULL,
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Update_When` timestamp NULL default NULL,
  `Update_Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID_Publications`),
  KEY `ID_Journal` (`ID_Journal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablepublications: 0 rows


# Dumping structure for table dna_kew.tablepublications_amplifications
CREATE TABLE IF NOT EXISTS `tablepublications_amplifications` (
  `ID_Pub_Amp` bigint(20) unsigned NOT NULL auto_increment,
  `ID_Publications` bigint(20) NOT NULL,
  `ID_Amplification` bigint(20) NOT NULL,
  `ID_DNA` bigint(20) NOT NULL,
  `Paper_Cache` longtext collate latin1_general_ci,
  `Fragment` tinytext collate latin1_general_ci,
  `Created_Who` mediumtext collate latin1_general_ci,
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID_Pub_Amp`),
  KEY `ID_Publications` (`ID_Publications`,`ID_Amplification`,`ID_DNA`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablepublications_amplifications: 0 rows


# Dumping structure for table dna_kew.tablepublications_authors
CREATE TABLE IF NOT EXISTS `tablepublications_authors` (
  `ID_Publications` bigint(20) NOT NULL,
  `ID_Author` bigint(20) NOT NULL,
  `Order` bigint(20) NOT NULL auto_increment,
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`Order`),
  KEY `ID_Publications` (`ID_Publications`,`ID_Author`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablepublications_authors: 0 rows


# Dumping structure for table dna_kew.tablepurification
CREATE TABLE IF NOT EXISTS `tablepurification` (
  `ID_Purification` bigint(20) NOT NULL auto_increment,
  `Method` varchar(150) collate utf8_unicode_ci default NULL,
  `Company` varchar(150) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(150) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`ID_Purification`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablepurification: 0 rows


# Dumping structure for table dna_kew.tablerank
CREATE TABLE IF NOT EXISTS `tablerank` (
  `ID_Rank` int(11) NOT NULL auto_increment,
  `Rank` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`ID_Rank`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablerank: 3 rows
INSERT INTO `tablerank` (`ID_Rank`, `Rank`, `Created_When`, `Created_Who`) VALUES (1, 'Internal Staff', '0000-00-00 00:00:00', ''), (2, 'Provider', '0000-00-00 00:00:00', ''), (3, 'Customer', '0000-00-00 00:00:00', '');


# Dumping structure for table dna_kew.tablerelationdna_voucher
CREATE TABLE IF NOT EXISTS `tablerelationdna_voucher` (
  `ID_RelationDNA_Voucher` int(11) NOT NULL auto_increment,
  `RelationDNA_Voucher` varchar(250) collate utf8_unicode_ci NOT NULL default '',
  `Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`ID_RelationDNA_Voucher`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablerelationdna_voucher: 8 rows
INSERT INTO `tablerelationdna_voucher` (`ID_RelationDNA_Voucher`, `RelationDNA_Voucher`, `Created_When`, `Created_Who`) VALUES (4, 'No voucher available (voucher->observation)', '2008-05-29 15:34:52', 'G.Droege'), (5, 'No voucher available (voucher->gone)', '2008-05-29 15:34:52', 'G.Droege'), (6, 'DNA and voucher from same in situ individual', '2009-07-17 12:30:23', 'G.Droege'), (7, 'DNA and voucher from same in situ population', '2009-07-17 12:30:53', 'G.Droege'), (8, 'DNA and voucher from same ex situ individual', '2009-07-17 12:31:14', 'G.Droege'), (9, 'DNA and voucher from same ex situ population', '2009-07-17 12:31:30', 'G.Droege'), (10, 'DNA from cultivated plant, voucher specimen and garden accession from same in situ population', '2009-07-17 12:32:04', 'G.Droege'), (11, 'Unknown', '2009-07-17 12:43:14', 'G.Droege');


# Dumping structure for table dna_kew.tablerequest
CREATE TABLE IF NOT EXISTS `tablerequest` (
  `ID_Request` bigint(20) NOT NULL auto_increment,
  `ID_People` bigint(20) NOT NULL,
  `ID_DNA` bigint(20) default NULL,
  `ID_Aliquots` bigint(20) NOT NULL,
  `Request_Date` date default NULL,
  `Request_Number_Aliquots` varchar(150) collate utf8_unicode_ci default NULL,
  `Request_Volume` float NOT NULL,
  `Request_Notes` longtext collate utf8_unicode_ci,
  `Shipping_Date` date NOT NULL,
  `Price` float NOT NULL,
  `Order_All` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Order_Partial` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Order_Rest` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_All` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_Partial` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Shipping_Rest` varchar(50) collate utf8_unicode_ci NOT NULL,
  `Agreement` varchar(10) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Request`),
  KEY `TableRequest_FKIndex1` (`ID_DNA`),
  KEY `TableRequest_FKIndex2` (`ID_People`),
  KEY `ID_Aliquots` (`ID_Aliquots`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablerequest: 0 rows


# Dumping structure for table dna_kew.tableschema
CREATE TABLE IF NOT EXISTS `tableschema` (
  `ID_Schema` bigint(20) NOT NULL auto_increment,
  `Schemata` varchar(50) NOT NULL,
  `QueryPart1` longtext NOT NULL,
  `QueryPart1_1` longtext NOT NULL,
  `QueryPart1_2` longtext NOT NULL,
  `QueryPart1_2b` longtext NOT NULL,
  `QueryPart1b` longtext NOT NULL,
  `QueryPart2` longtext NOT NULL,
  `QueryPart3` longtext NOT NULL,
  `QueryPart4` longtext NOT NULL,
  `QueryPart5` longtext NOT NULL,
  `Query_Encoded` longtext NOT NULL,
  `Query_Original` longtext NOT NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID_Schema`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.tableschema: 6 rows
INSERT INTO `tableschema` (`ID_Schema`, `Schemata`, `QueryPart1`, `QueryPart1_1`, `QueryPart1_2`, `QueryPart1_2b`, `QueryPart1b`, `QueryPart2`, `QueryPart3`, `QueryPart4`, `QueryPart5`, `Query_Encoded`, `Query_Original`, `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', '%3C%2Fequals%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E', '%3C%2Fequals%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', '&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%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E\r\n%3C%2Fequals%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E\r\n%3C%2Fequals%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceName%22%3E\r\n%3C%2Fequals%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '&query=<?xml+version=\'1.0\'+encoding=\'UTF-8\'?><request+xmlns=\'http://www.biocase.org/schemas/protocol/1.3\'><header><type>search</type></header><search><requestFormat>http://www.tdwg.org/schemas/abcd/1.2</requestFormat><responseFormat+start=\'0\'+limit=\'10\'>http://www.tdwg.org/schemas/abcd/1.2</responseFormat><filter><like+path=\'/DataSets/DataSet/Units/Unit/UnitID\'></like></filter><count>false</count></search></request>', '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', '%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', '&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%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceInstitutionID%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceID%22%3E\r\n%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '&query=<?xml+version=\'1.0\'+encoding=\'UTF-8\'?><request+xmlns=\'http://www.biocase.org/schemas/protocol/1.3\'><header><type>search</type></header><search><requestFormat>http://www.tdwg.org/schemas/abcd/2.06</requestFormat><responseFormat+start=\'0\'+limit=\'10\'>http://www.tdwg.org/schemas/abcd/2.06</responseFormat><filter><like+path=\'/DataSets/DataSet/Units/Unit/UnitID\'></like></filter><count>false</count></search></request>', '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+%3Cequals%3E+%3Cdarwin%3ACatalogNumber%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%3ACatalogNumber%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%3ACatalogNumber%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', '%3C%2Fdarwin%3ACatalogNumber%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', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E+%3Crequest+xmlns%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%22+xmlns%3Axsd%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%22+xmlns%3Adigir%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%22+xmlns%3Adarwin%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%22+xmlns%3Aobis%3D%22http%3A%2F%2Fwww.iobis.org%2Fobis%22+xmlns%3Amanis%3D%22http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%22+xmlns%3Axsi%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%22+%3E+%3Cheader%3E+%3Cversion%3E1.0%3C%2Fversion%3E+%3CsendTime%3E2007-11-27+15%3A00%3A24.23%3C%2FsendTime%3E+%3Csource%2F%3E+%3Cdestination+resource%3D%22\r\n%22%3E\r\n%3C%2Fdestination%3E+%3Ctype%3Esearch%3C%2Ftype%3E+%3C%2Fheader%3E+%3Csearch%3E+%3Cfilter%3E+%3Cand%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumber%3E\r\n%3C%2Fdarwin%3ACatalogNumber%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3AInstitutionCode%3E\r\n%3C%2Fdarwin%3AInstitutionCode%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3ACollectionCode%3E\r\n%3C%2Fdarwin%3ACollectionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E+%3C%2Ffilter%3E+%3Crecords+start%3D%220%22+limit%3D%2210%22%3E+%3Cstructure%3E+%3Cxsd%3Aelement+name%3D%22record%22%3E+%3Cxsd%3AcomplexType%3E+%3Cxsd%3Asequence%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ADateLastModified%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AInstitutionCode%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACollectionCode%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACatalogNumber%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AScientificName%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ABasisOfRecord%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AKingdom%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3APhylum%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AClass%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AOrder%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AFamily%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AGenus%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ASpecies%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ASubspecies%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AScientificNameAuthor%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AIdentifiedBy%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AYearIdentified%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMonthIdentified%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ADayIdentified%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ATypeStatus%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACollectorNumber%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AFieldNumber%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACollector%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AYearCollected%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMonthCollected%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ADayCollected%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AJulianDay%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ATimeOfDay%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AContinentOcean%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACountry%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AStateProvince%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACounty%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ALocality%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ALongitude%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ALatitude%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ACoordinatePrecision%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ABoundingBox%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMinimumElevation%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMaximumElevation%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMinimumDepth%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AMaximumDepth%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ASex%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3APreparationType%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3AIndividualCount%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3APreviousCatalogNumber%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ARelationshipType%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ARelatedCatalogItem%22%2F%3E+%3Cxsd%3Aelement+ref%3D%22darwin%3ANotes%22%2F%3E++%3Cxsd%3Aelement+ref%3D%22obis%3ASource%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ACitation%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ASubgenus%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartYearCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndYearCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartMonthCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndMonthCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartDayCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndDayCollected%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartJulianDay%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndJulianDay%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartTimeofDay%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndTimeofDay%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ATimeZone%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartLongitude%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndLongitude%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStartLatitude%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AEndLatitude%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AStart_EndCoordinatePrecision%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ADepthRange%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ATemperature%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ALifeStage%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AObservedIndividualCount%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3ASampleSize%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AObservedWeight%22+%2F%3E+%3Cxsd%3Aelement+ref%3D%22obis%3AGMLFeature%22+%2F%3E+%3C%2Fxsd%3Asequence%3E+%3C%2Fxsd%3AcomplexType%3E+%3C%2Fxsd%3Aelement%3E+%3C%2Fstructure%3E+%3C%2Frecords%3E+%3Ccount%3Efalse%3C%2Fcount%3E+%3C%2Fsearch%3E+%3C%2Frequest%3E', '?request=<?xml version=`1.0` encoding=`UTF-8`?> <request xmlns=`http://digir.net/schema/protocol/2003/1.0` xmlns:xsd=`http://www.w3.org/2001/XMLSchema` xmlns:digir=`http://digir.net/schema/protocol/2003/1.0` \r\nxmlns:darwin=`http://digir.net/schema/conceptual/darwin/2003/1.0` xmlns:obis=`http://www.iobis.org/obis` xmlns:manis=`http://digir.net/schema/protocol/2003/1.0` xmlns:xsi=`http://www.w3.org/2001/XMLSchema-instance` > <header> <version>1.0</version> <sendTime>2007-11-27 15:00:24.23</sendTime> <source/> <destination resource=`canb`>http://www.anbg.gov.au:80/digir/www/DiGIR.php</destination> <type>search</type> </header> <search> <filter> <equals> <darwin:CatalogNumber></darwin:CatalogNumber> </equals> </filter> <records start=`0` limit=`10`> <structure> <xsd:element name=`record`> <xsd:complexType> <xsd:sequence> <xsd:element ref=`darwin:DateLastModified`/> <xsd:element ref=`darwin:InstitutionCode`/> <xsd:element ref=`darwin:CollectionCode`/> <xsd:element ref=`darwin:CatalogNumber`/> <xsd:element ref=`darwin:ScientificName`/> <xsd:element ref=`darwin:BasisOfRecord`/> <xsd:element ref=`darwin:Kingdom`/> <xsd:element ref=`darwin:Phylum`/> <xsd:element ref=`darwin:Class`/> <xsd:element ref=`darwin:Order`/> <xsd:element ref=`darwin:Family`/> <xsd:element ref=`darwin:Genus`/> <xsd:element ref=`darwin:Species`/> <xsd:element ref=`darwin:Subspecies`/> <xsd:element ref=`darwin:ScientificNameAuthor`/> <xsd:element ref=`darwin:IdentifiedBy`/> <xsd:element ref=`darwin:YearIdentified`/> <xsd:element ref=`darwin:MonthIdentified`/> <xsd:element ref=`darwin:DayIdentified`/> <xsd:element ref=`darwin:TypeStatus`/> <xsd:element ref=`darwin:CollectorNumber`/> <xsd:element ref=`darwin:FieldNumber`/> <xsd:element ref=`darwin:Collector`/> <xsd:element ref=`darwin:YearCollected`/> <xsd:element ref=`darwin:MonthCollected`/> <xsd:element ref=`darwin:DayCollected`/> <xsd:element ref=`darwin:JulianDay`/> <xsd:element ref=`darwin:TimeOfDay`/> <xsd:element ref=`darwin:ContinentOcean`/> <xsd:element ref=`darwin:Country`/> <xsd:element ref=`darwin:StateProvince`/> <xsd:element ref=`darwin:County`/> <xsd:element ref=`darwin:Locality`/> <xsd:element ref=`darwin:Longitude`/> <xsd:element ref=`darwin:Latitude`/> <xsd:element ref=`darwin:CoordinatePrecision`/> <xsd:element ref=`darwin:BoundingBox`/> <xsd:element ref=`darwin:MinimumElevation`/> <xsd:element ref=`darwin:MaximumElevation`/> <xsd:element ref=`darwin:MinimumDepth`/> <xsd:element ref=`darwin:MaximumDepth`/> <xsd:element ref=`darwin:Sex`/> <xsd:element ref=`darwin:PreparationType`/> <xsd:element ref=`darwin:IndividualCount`/> <xsd:element ref=`darwin:PreviousCatalogNumber`/> <xsd:element ref=`darwin:RelationshipType`/> <xsd:element ref=`darwin:RelatedCatalogItem`/> <xsd:element ref=`darwin:Notes`/>  <xsd:element ref=`obis:Source` /> <xsd:element ref=`obis:Citation` /> <xsd:element ref=`obis:Subgenus` /> <xsd:element ref=`obis:StartYearCollected` /> <xsd:element ref=`obis:EndYearCollected` /> <xsd:element ref=`obis:StartMonthCollected` /> <xsd:element ref=`obis:EndMonthCollected` /> <xsd:element ref=`obis:StartDayCollected` /> <xsd:element ref=`obis:EndDayCollected` /> <xsd:element ref=`obis:StartJulianDay` /> <xsd:element ref=`obis:EndJulianDay` /> <xsd:element ref=`obis:StartTimeofDay` /> <xsd:element ref=`obis:EndTimeofDay` /> <xsd:element ref=`obis:TimeZone` /> <xsd:element ref=`obis:StartLongitude` /> <xsd:element ref=`obis:EndLongitude` /> <xsd:element ref=`obis:StartLatitude` /> <xsd:element ref=`obis:EndLatitude` /> <xsd:element ref=`obis:Start_EndCoordinatePrecision` /> <xsd:element ref=`obis:DepthRange` /> <xsd:element ref=`obis:Temperature` /> <xsd:element ref=`obis:LifeStage` /> <xsd:element ref=`obis:ObservedIndividualCount` /> <xsd:element ref=`obis:SampleSize` /> <xsd:element ref=`obis:ObservedWeight` /> <xsd:element ref=`obis:GMLFeature` /> </xsd:sequence> </xsd:complexType> </xsd:element> </structure> </records> <count>false</count> </search> </request>', '0000-00-00 00:00:00', ''), (4, 'ABCD 2.05', '&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.05%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.05%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.05%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.05%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', '%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', '&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.05%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.05%3C%2FresponseFormat%3E%3Cfilter%3E%3Cand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceInstitutionID%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceID%22%3E\r\n%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '&query=<?xml+version=\'1.0\'+encoding=\'UTF-8\'?><request+xmlns=\'http://www.biocase.org/schemas/protocol/1.3\'><header><type>search</type></header><search><requestFormat>http://www.tdwg.org/schemas/abcd/2.05</requestFormat><responseFormat+start=\'0\'+limit=\'10\'>http://www.tdwg.org/schemas/abcd/2.05</responseFormat><filter><like+path=\'/DataSets/DataSet/Units/Unit/UnitID\'></like></filter><count>false</count></search></request>', '0000-00-00 00:00:00', ''), (5, '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%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%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%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', '%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceName%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%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%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E\r\n%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceName%22%3E\r\n%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '?query=<?xml+version=\'1.0\'+encoding=\'UTF-8\'?><request+xmlns=\'http://www.biocase.org/schemas/protocol/1.3\'><header><type>search</type></header><search><requestFormat>http://www.tdwg.org/schemas/abcd/1.2</requestFormat><responseFormat+start=\'0\'+limit=\'10\'>http://www.tdwg.org/schemas/abcd/1.2</responseFormat><filter><like+path=\'/DataSets/DataSet/Units/Unit/UnitID\'></like></filter><count>false</count></search></request>', '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', '%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', '');


# Dumping structure for table dna_kew.tableseasandoceans
CREATE TABLE IF NOT EXISTS `tableseasandoceans` (
  `ID_SeasAndOceans` bigint(20) NOT NULL auto_increment,
  `SeasAndOceans` longtext collate latin1_general_ci NOT NULL,
  `ID_Continent` bigint(20) NOT NULL,
  PRIMARY KEY  (`ID_SeasAndOceans`),
  KEY `ID_Continent` (`ID_Continent`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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


# Dumping structure for table dna_kew.tablesex
CREATE TABLE IF NOT EXISTS `tablesex` (
  `ID_Sex` int(11) NOT NULL auto_increment,
  `Sex` varchar(50) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`ID_Sex`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

# Dumping data for table dna_kew.tablesex: 4 rows
INSERT INTO `tablesex` (`ID_Sex`, `Sex`) VALUES (1, 'female'), (2, 'male'), (3, 'hermaphrodite'), (4, 'unknown');


# Dumping structure for table dna_kew.tablespecimentype
CREATE TABLE IF NOT EXISTS `tablespecimentype` (
  `ID_SpecimenType` bigint(20) NOT NULL auto_increment,
  `SpecimenType` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_SpecimenType`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablespecimentype: 18 rows
INSERT INTO `tablespecimentype` (`ID_SpecimenType`, `SpecimenType`) VALUES (1, 'epitype'), (2, 'holotype'), (3, 'isotype'), (4, 'isoepitype'), (5, 'isolectotype'), (6, 'isoneotype'), (7, 'isoparatype'), (8, 'isoparalectotype'), (9, 'isosyntype'), (10, 'kleptotype'), (11, 'lectotype'), (12, 'neotype'), (13, 'original material'), (14, 'paratype'), (15, 'paralectotype'), (16, 'syntype'), (17, 'topotype'), (18, 'type');


# Dumping structure for table dna_kew.tablestock_box
CREATE TABLE IF NOT EXISTS `tablestock_box` (
  `ID_Stock_Box` bigint(20) NOT NULL auto_increment,
  `Stock_Box` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Stock_Box`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablestock_box: 0 rows


# Dumping structure for table dna_kew.tablestock_fridge
CREATE TABLE IF NOT EXISTS `tablestock_fridge` (
  `ID_Stock_Fridge` int(11) NOT NULL auto_increment,
  `Stock_Fridge` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Stock_Fridge`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablestock_fridge: 1 rows
INSERT INTO `tablestock_fridge` (`ID_Stock_Fridge`, `Stock_Fridge`, `Created_When`, `Created_Who`) VALUES (1, 'Scrat', '2008-07-08 17:30:33', 'G.Droege');


# Dumping structure for table dna_kew.tablestock_rack
CREATE TABLE IF NOT EXISTS `tablestock_rack` (
  `ID_Stock_Rack` bigint(20) NOT NULL auto_increment,
  `Stock_Rack` varchar(50) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Stock_Rack`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tablestock_rack: 3 rows
INSERT INTO `tablestock_rack` (`ID_Stock_Rack`, `Stock_Rack`, `Created_When`, `Created_Who`) VALUES (1, '1', '2008-07-08 17:30:47', 'G.Droege'), (2, '2', '2009-05-05 12:20:09', 'G.Droege'), (3, '3', '2009-05-05 12:20:11', 'G.Droege');


# Dumping structure for table dna_kew.tablethomas
CREATE TABLE IF NOT EXISTS `tablethomas` (
  `ID_List` bigint(20) unsigned NOT NULL auto_increment,
  `NameAuthorYear` varchar(255) default NULL,
  `Genus` varchar(255) default NULL,
  `FirstEpithet` varchar(255) default NULL,
  `Author1` varchar(255) default NULL,
  `Rank` varchar(50) default NULL,
  `SecondEpithet` varchar(255) default NULL,
  `Author2` varchar(255) default NULL,
  `Sammler` varchar(50) default NULL,
  `Sammeldatum` varchar(50) default NULL,
  `LocalityText` longtext,
  PRIMARY KEY  (`ID_List`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Sammelliste Thomas BB';

# Dumping data for table dna_kew.tablethomas: 0 rows


# Dumping structure for table dna_kew.tabletissue
CREATE TABLE IF NOT EXISTS `tabletissue` (
  `ID_Tissue` bigint(20) NOT NULL auto_increment,
  `Tissue` varchar(255) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Tissue`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tabletissue: 9 rows
INSERT INTO `tabletissue` (`ID_Tissue`, `Tissue`, `Created_When`, `Created_Who`) VALUES (1, 'Leaf', '2008-07-02 14:44:33', 'G.Droege'), (2, 'Bloom', '2008-07-02 14:44:44', 'G.Droege'), (3, 'Complete organism', '2009-02-03 16:01:57', 'G.Droege'), (4, 'Seed', '2009-04-10 17:23:31', 'G.Droege'), (5, 'Bulbil', '2009-04-10 19:25:51', 'G.Droege'), (6, 'Leaf and bloom', '2009-04-10 19:26:27', 'G.Droege'), (7, 'Stipe, bloom and seed', '2009-04-10 19:26:48', 'G.Droege'), (8, 'Pericarp', '2009-07-17 13:33:25', 'G.Droege'), (9, 'Stem', '2009-08-27 15:18:20', 'G.Droege');


# Dumping structure for table dna_kew.tabletype
CREATE TABLE IF NOT EXISTS `tabletype` (
  `ID_Type` int(11) NOT NULL auto_increment,
  `Type` varchar(150) collate utf8_unicode_ci default NULL,
  `Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Created_Who` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`ID_Type`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dumping data for table dna_kew.tabletype: 2 rows
INSERT INTO `tabletype` (`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', '');


# Dumping structure for table dna_kew.table_log_aliquots
CREATE TABLE IF NOT EXISTS `table_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 dna_kew.table_log_aliquots: 0 rows


# Dumping structure for table dna_kew.table_log_amplifications
CREATE TABLE IF NOT EXISTS `table_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` date 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 dna_kew.table_log_amplifications: 0 rows


# Dumping structure for table dna_kew.table_log_cache
CREATE TABLE IF NOT EXISTS `table_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` longtext,
  `UnitID_Specimen` varchar(255) default NULL,
  `CollectionCode_Specimen` varchar(255) default NULL,
  `InstitutionCode_Specimen` varchar(255) default NULL,
  `ContinentOrOcean` varchar(255) default NULL,
  `CountryName` varchar(255) default NULL,
  `CountryISO2` varchar(50) default NULL,
  `GatheringAgent` longtext,
  `GatheringDate` longtext,
  `LocalityText` longtext,
  `Altitude` varchar(50) default NULL,
  `LongitudeDecimal` float unsigned default NULL,
  `LatitudeDecimal` float unsigned default NULL,
  `Gathering_Other` longtext,
  `TypeStatus` varchar(150) default NULL,
  `Update_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) default NULL,
  PRIMARY KEY  (`ID_Log_Cache`),
  KEY `ID_Cache` (`ID_Cache`),
  KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.table_log_cache: 0 rows


# Dumping structure for table dna_kew.table_log_cachehighertaxa
CREATE TABLE IF NOT EXISTS `table_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) default NULL,
  `TaxonRank` varchar(255) default NULL,
  `Update_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) 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=latin1;

# Dumping data for table dna_kew.table_log_cachehighertaxa: 0 rows


# Dumping structure for table dna_kew.table_log_cacheimages
CREATE TABLE IF NOT EXISTS `table_log_cacheimages` (
  `ID_Log_CacheImages` bigint(20) NOT NULL auto_increment,
  `ID_CacheImages` bigint(20) default NULL,
  `ID_Cache` bigint(20) default NULL,
  `Images` longtext,
  `Update_Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) 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=latin1;

# Dumping data for table dna_kew.table_log_cacheimages: 0 rows


# Dumping structure for table dna_kew.table_log_cachetaxonidentified
CREATE TABLE IF NOT EXISTS `table_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) default NULL,
  `Subgenus` varchar(50) default NULL,
  `FirstEpithet` varchar(255) default NULL,
  `SecondEpithet` varchar(255) default NULL,
  `Rank` varchar(50) default NULL,
  `HybridFlag` tinyint(4) default NULL,
  `Other` longtext,
  `NameAuthorYear` longtext,
  `PreferredFlag` tinytext NOT NULL,
  `Update_Created_When` timestamp NULL default CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) 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=latin1;

# Dumping data for table dna_kew.table_log_cachetaxonidentified: 0 rows


# Dumping structure for table dna_kew.table_log_dnabanknumbers
CREATE TABLE IF NOT EXISTS `table_log_dnabanknumbers` (
  `ID_Log_DNA` bigint(20) 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` date 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,
  `Degradation_Date` date 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 dna_kew.table_log_dnabanknumbers: 0 rows


# Dumping structure for table dna_kew.table_log_offlinegathering
CREATE TABLE IF NOT EXISTS `table_log_offlinegathering` (
  `ID_Log_Gathering` bigint(20) NOT NULL auto_increment,
  `ID_Gathering` bigint(20) default NULL,
  `UnitID_Specimen` varchar(255) default NULL,
  `CollectionCode_Specimen` varchar(255) default NULL,
  `InstitutionCode_Specimen` varchar(255) default NULL,
  `ContinentOrOcean` varchar(50) default NULL,
  `CountryName` varchar(255) default NULL,
  `CountryISO2` varchar(50) default NULL,
  `SeasAndOceans` varchar(255) default NULL,
  `GatheringAgent` longtext,
  `GatheringDate` longtext,
  `GatheringNo` mediumtext,
  `TitleLabel` longtext,
  `ExpeditionDetails` longtext,
  `Region` longtext,
  `Locality` longtext,
  `Biotope` longtext,
  `Altitude` varchar(50) default NULL,
  `LongitudeDecimal` float unsigned default NULL,
  `LatitudeDecimal` float unsigned default NULL,
  `Updated_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Updated_Created_Who` varchar(50) default NULL,
  `Sex` varchar(50) default NULL,
  `Protected` varchar(50) default NULL,
  `Admission` varchar(50) default NULL,
  `BasisOfRecord` varchar(50) default NULL,
  `ID_Cache` bigint(20) default NULL,
  `Source_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) default NULL,
  `Depth` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID_Log_Gathering`),
  KEY `ID_Gathering` (`ID_Gathering`),
  KEY `ID_Cache` (`ID_Cache`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.table_log_offlinegathering: 0 rows


# Dumping structure for table dna_kew.table_log_offlinehighertaxon
CREATE TABLE IF NOT EXISTS `table_log_offlinehighertaxon` (
  `ID_Log_HigherTaxon` bigint(20) NOT NULL auto_increment,
  `ID_HigherTaxon` bigint(20) default NULL,
  `ID_Taxa` bigint(20) default NULL,
  `HigherTaxon` varchar(255) default NULL,
  `TaxonRank` varchar(255) default NULL,
  `Update_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Cource_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Cource_Created_Who` varchar(50) 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=latin1;

# Dumping data for table dna_kew.table_log_offlinehighertaxon: 0 rows


# Dumping structure for table dna_kew.table_log_offlineimages
CREATE TABLE IF NOT EXISTS `table_log_offlineimages` (
  `ID_Log_OfflineImages` bigint(20) NOT NULL auto_increment,
  `ID_Images` bigint(20) default NULL,
  `ID_OfflineGathering` bigint(20) default NULL,
  `ImageLink` longtext,
  `Update_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) default NULL,
  `ID_Log_OfflineGathering` bigint(20) default NULL,
  PRIMARY KEY  (`ID_Log_OfflineImages`),
  KEY `ID_Images` (`ID_Images`),
  KEY `ID_OfflineGathering` (`ID_OfflineGathering`),
  KEY `ID_Log_OfflineGathering` (`ID_Log_OfflineGathering`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.table_log_offlineimages: 0 rows


# Dumping structure for table dna_kew.table_log_offlinetaxa
CREATE TABLE IF NOT EXISTS `table_log_offlinetaxa` (
  `ID_Log_TaxonIdentified` bigint(20) NOT NULL auto_increment,
  `ID_TaxonIdentified` bigint(20) default NULL,
  `ID_Gathering` bigint(20) default 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,
  `Author` longtext,
  `Year` year(4) default NULL,
  `NameAuthorYear` longtext,
  `Identifier` longtext,
  `IdentificationDate` longtext,
  `PreferredFlag` varchar(50) default NULL,
  `EntryNameFlag` tinyint(4) unsigned default NULL,
  `Type` varchar(50) default NULL,
  `Update_Created_When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Update_Created_Who` varchar(50) default NULL,
  `Source_Created_When` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Source_Created_Who` varchar(50) default NULL,
  `ID_Log_OfflineGathering` bigint(20) default NULL,
  PRIMARY KEY  (`ID_Log_TaxonIdentified`),
  KEY `ID_TaxonIdentified` (`ID_TaxonIdentified`),
  KEY `ID_Gathering` (`ID_Gathering`),
  KEY `ID_Log_OfflineGathering` (`ID_Log_OfflineGathering`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

# Dumping data for table dna_kew.table_log_offlinetaxa: 0 rows



# Dumping structure for view dna_kew.wrapper_view_amplifications
CREATE VIEW `wrapper_view_amplifications` AS select `amplifications`.`ID_DNA` AS `ID_DNA`,`amplifications`.`ID_Amplification` AS `ID_Amplification`,`fragment`.`Fragment` AS `Fragment`,`amplifications`.`GenBankNumber` AS `GenBankNumber`,`amplifications`.`Link` AS `GenBankLink`,`amplifications`.`Amplification_Date` AS `Amplification_Date`,`amplifications`.`Amplification_Success` AS `Amplification_Success`,`people`.`Name_All` AS `Amplification_Staff`,`amplifications`.`Cons_Sequence` AS `Consensus_Sequence`,`primer`.`Primer` AS `Primer` from (((`tableamplifications` `amplifications` left join `tablefragment` `fragment` on((`fragment`.`ID_Fragment` = `amplifications`.`ID_Fragment`))) left join `tablepeople` `people` on((`people`.`ID_People` = `amplifications`.`ID_Amplification_Staff`))) left join `tableprimer` `primer` on((`primer`.`ID_Primer` = `amplifications`.`ID_Primer1`)));


# Dumping structure for view dna_kew.wrapper_view_dna
CREATE VIEW `wrapper_view_dna` AS select `dnabanknumbers`.`ID_DNA` AS `ID_DNA`,`specimencache`.`ID_Cache` AS `ID_Cache`,`dnabanknumbers`.`DNA_Bank_Number` AS `DNA_Bank_Number`,`type`.`Type` AS `Type`,`relationdna_voucher`.`RelationDNA_Voucher` AS `RelationDNA_Voucher`,`tissue`.`Tissue` AS `Tissue`,`preservation`.`Preservation` AS `Preservation`,`people`.`Name_All` AS `Provided_By`,`dnabanknumbers`.`Extraction_Date` AS `Extraction_Date`,`staff`.`Name_All` AS `Extraction_Staff`,`extractionmethod`.`Method` AS `Extraction_Method`,`extractionmethod`.`Company` AS `Extraction_Company`,`purification`.`Method` AS `Purification_Method`,`purification`.`Company` AS `Purification_Company`,`dnabanknumbers`.`Absorbance280` AS `Absorbance280`,`dnabanknumbers`.`Absorbance230` AS `Absorbance230`,`dnabanknumbers`.`Concentration` AS `Concentration`,`quality`.`Degradation` AS `Quality`,`dnabanknumbers`.`Degradation_Date` AS `Quality_Check_Date`,`dnabanknumbers`.`Block_Until` AS `Block_Until`,`dnabanknumbers`.`Notes` AS `Notes` from ((((((((((`tablednabanknumbers` `dnabanknumbers` left join `tabletype` `type` on((`type`.`ID_Type` = `dnabanknumbers`.`ID_Type`))) left join `tablerelationdna_voucher` `relationdna_voucher` on((`relationdna_voucher`.`ID_RelationDNA_Voucher` = `dnabanknumbers`.`ID_RelationDNA_Voucher`))) left join `tabletissue` `tissue` on((`tissue`.`ID_Tissue` = `dnabanknumbers`.`ID_Tissue`))) left join `tablepreservation` `preservation` on((`preservation`.`ID_Preservation` = `dnabanknumbers`.`ID_Preservation`))) left join `tablepeople` `people` on((`people`.`ID_People` = `dnabanknumbers`.`ID_Provided_By_People`))) left join `tableextractionmethod` `extractionmethod` on((`extractionmethod`.`ID_Method` = `dnabanknumbers`.`ID_Extraction_Method`))) left join `tablepeople` `staff` on((`staff`.`ID_People` = `dnabanknumbers`.`ID_Extraction_Staff`))) left join `tablepurification` `purification` on((`purification`.`ID_Purification` = `dnabanknumbers`.`ID_Purification`))) left join `tabledegradation` `quality` on((`quality`.`ID_Degradation` = `dnabanknumbers`.`ID_Degradation`))) left join `tablecache` `specimencache` on((`specimencache`.`ID_Cache` = `dnabanknumbers`.`ID_Cache`))) where (`dnabanknumbers`.`Block_General` <> _latin1'1');


# Dumping structure for view dna_kew.wrapper_view_providers
CREATE VIEW `wrapper_view_providers` AS select `datasets`.`ID_Dataset` AS `ID_Dataset`,`datasets`.`Digir_Resource` AS `Digir_Resource`,`datasets`.`Digir_Source` AS `Digir_Source`,`providers`.`Provider` AS `Provider`,`schemata`.`Schemata` AS `Schemata` from ((`tabledataset` `datasets` left join `tableprovider` `providers` on((`providers`.`ID_Provider` = `datasets`.`ID_Provider`))) left join `tableschema` `schemata` on((`schemata`.`ID_Schema` = `providers`.`ID_Schema`)));


# Dumping structure for view dna_kew.wrapper_view_publications_dna
CREATE VIEW `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`,`publications`.`Link` AS `Link`,`publications_dna`.`Fragment` AS `Fragment` from (`tablepublications_amplifications` `publications_dna` left join `tablepublications` `publications` on((`publications`.`ID_Publications` = `publications_dna`.`ID_Publications`)));


# Dumping structure for view dna_kew.wrapper_view_specimens
CREATE VIEW `wrapper_view_specimens` AS select `specimens`.`ID_Gathering` AS `ID_Gathering`,`specimens`.`UnitID_Specimen` AS `UnitID_Specimen`,`specimens`.`CollectionCode_Specimen` AS `CollectionCode_Specimen`,`specimens`.`InstitutionCode_Specimen` AS `InstitutionCode_Specimen`,`specimens`.`ContinentOrOcean` AS `ContinentOrOcean`,`specimens`.`CountryName` AS `CountryName`,`specimens`.`CountryISO2` AS `CountryISO2`,`specimens`.`SeasAndOceans` AS `SeasAndOceans`,`specimens`.`GatheringAgent` AS `GatheringAgent`,`specimens`.`GatheringDate` AS `GatheringDate`,`specimens`.`GatheringNo` AS `GatheringNo`,`specimens`.`Locality_ID` AS `Locality_ID`,if((`specimens`.`TitleLabel` <> _utf8''),concat_ws(_utf8' ',`specimens`.`TitleLabel`,`specimens`.`ExpeditionDetails`),`specimens`.`ExpeditionDetails`) AS `ExpeditionDetails`,if((`specimens`.`Region` <> _utf8''),concat_ws(_utf8', ',`specimens`.`Region`,`specimens`.`Locality`),`specimens`.`Locality`) AS `Locality`,`specimens`.`Biotope` AS `Biotope`,`specimens`.`Depth` AS `Depth`,`specimens`.`Altitude` AS `Altitude`,`specimens`.`LongitudeDecimal` AS `LongitudeDecimal`,`specimens`.`LatitudeDecimal` AS `LatitudeDecimal`,`sex`.`Sex` AS `Sex`,`basisofrecord`.`BasisOfRecord_Specimen` AS `BasisOfRecord`,`typestatus`.`SpecimenType` AS `TypeStatus` from (((`tableofflinegathering` `specimens` left join `tablespecimentype` `typestatus` on((`typestatus`.`ID_SpecimenType` = `specimens`.`ID_Type`))) left join `tablebasisofrecordspecimen` `basisofrecord` on((`basisofrecord`.`ID_BasisOfRecord_Specimen` = `specimens`.`ID_BasisOfRecord`))) left join `tablesex` `sex` on((`sex`.`ID_Sex` = `specimens`.`ID_Sex`))) where ((`specimens`.`Protected` <> _utf8'Yes') and (`specimens`.`Admission` <> _utf8'No'));
