-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 5.5.16 - MySQL Community Server (GPL) -- Server OS: Win32 -- HeidiSQL version: 7.0.0.4053 -- Date/time: 2012-07-20 14:50:05 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!40014 SET FOREIGN_KEY_CHECKS=0 */; -- Dumping database structure for dnabank CREATE DATABASE IF NOT EXISTS `dnabank` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `dnabank`; -- Dumping structure for table dnabank.abcdmetadata DROP TABLE IF EXISTS `abcdmetadata`; CREATE TABLE IF NOT EXISTS `abcdmetadata` ( `MetadataID` int(11) unsigned NOT NULL DEFAULT '0', `DatasetGUID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `TechnicalContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `TechnicalContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `TechnicalContactPhone` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `TechnicalContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `ContentContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactPhone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OtherProviderUDDI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetTitle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetCoverage` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetIconURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetVersionMajor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `DatasetCreators` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetContributors` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `DateCreated` datetime DEFAULT NULL, `DateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `OwnerOrganizationName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerOrganizationAbbrev` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerContactPerson` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `OwnerContactRole` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerTelephone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerLogoURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `LicenseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `LicensesDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `LicenseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SourceInstitutionID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `SourceID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `RecordBasis` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`MetadataID`), KEY `DatasetGUID` (`DatasetGUID`), KEY `SourceInstitutionID` (`SourceInstitutionID`), KEY `SourceID` (`SourceID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank.abcdmetadata: 0 rows /*!40000 ALTER TABLE `abcdmetadata` DISABLE KEYS */; /*!40000 ALTER TABLE `abcdmetadata` ENABLE KEYS */; -- Dumping structure for table dnabank.abcdmetadataspecimens DROP TABLE IF EXISTS `abcdmetadataspecimens`; CREATE TABLE IF NOT EXISTS `abcdmetadataspecimens` ( `MetadataID` int(11) unsigned NOT NULL DEFAULT '0', `DatasetGUID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `TechnicalContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `TechnicalContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `TechnicalContactPhone` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `TechnicalContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactName` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `ContentContactEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactPhone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ContentContactAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OtherProviderUDDI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetTitle` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetCoverage` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetIconURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetVersionMajor` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `DatasetCreators` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `DatasetContributors` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `DateCreated` datetime DEFAULT NULL, `DateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `OwnerOrganizationName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerOrganizationAbbrev` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerContactPerson` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `OwnerContactRole` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerAddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerTelephone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerEmail` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerURI` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `OwnerLogoURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `IPRURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `CopyrightURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `TermsOfUseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `DisclaimersURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `LicenseText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `LicensesDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `LicenseURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsDetails` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `AcknowledgementsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsText` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsDetails` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, `CitationsURI` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SourceInstitutionID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `SourceID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `RecordBasis` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`MetadataID`), KEY `DatasetGUID` (`DatasetGUID`), KEY `SourceInstitutionID` (`SourceInstitutionID`), KEY `SourceID` (`SourceID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- Dumping data for table dnabank.abcdmetadataspecimens: 0 rows /*!40000 ALTER TABLE `abcdmetadataspecimens` DISABLE KEYS */; /*!40000 ALTER TABLE `abcdmetadataspecimens` ENABLE KEYS */; -- Dumping structure for table dnabank.aliquots DROP TABLE IF EXISTS `aliquots`; CREATE TABLE IF NOT EXISTS `aliquots` ( `ID_Aliquots` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_DNA` int(20) unsigned NOT NULL, `ID_Aliquots_Box` int(20) unsigned DEFAULT NULL, `ID_Aliquots_Rack` int(20) unsigned DEFAULT NULL, `ID_Aliquots_Fridge` int(20) unsigned DEFAULT NULL, `Aliquot_Number` varchar(100) DEFAULT NULL, `Origin_Quantity` float DEFAULT NULL, `Rest_Quantity` float DEFAULT NULL, `Aliquot_Position` varchar(50) DEFAULT NULL, `Aliquot_Barcode` varchar(255) DEFAULT NULL, `Order_All` varchar(50) DEFAULT NULL, `Order_Partial` varchar(50) DEFAULT NULL, `Order_Rest` varchar(50) DEFAULT NULL, `Shipping_All` varchar(50) DEFAULT NULL, `Shipping_Partial` varchar(50) DEFAULT NULL, `Shipping_Rest` varchar(50) DEFAULT NULL, `Price` varchar(50) DEFAULT NULL, `Currency` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Update_Who` varchar(50) DEFAULT NULL, `Update_When` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_Aliquots`), KEY `TableAliquots_FKIndex1` (`ID_Aliquots_Fridge`), KEY `TableAliquots_FKIndex2` (`ID_Aliquots_Rack`), KEY `TableAliquots_FKIndex3` (`ID_Aliquots_Box`), KEY `TableAliquots_FKIndex4` (`ID_DNA`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.aliquots: 0 rows /*!40000 ALTER TABLE `aliquots` DISABLE KEYS */; /*!40000 ALTER TABLE `aliquots` ENABLE KEYS */; -- Dumping structure for table dnabank.aliquots_box DROP TABLE IF EXISTS `aliquots_box`; CREATE TABLE IF NOT EXISTS `aliquots_box` ( `ID_Aliquots_Box` int(20) unsigned NOT NULL AUTO_INCREMENT, `Aliquots_Box` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Aliquots_Box`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.aliquots_box: 0 rows /*!40000 ALTER TABLE `aliquots_box` DISABLE KEYS */; /*!40000 ALTER TABLE `aliquots_box` ENABLE KEYS */; -- Dumping structure for table dnabank.aliquots_fridge DROP TABLE IF EXISTS `aliquots_fridge`; CREATE TABLE IF NOT EXISTS `aliquots_fridge` ( `ID_Aliquots_Fridge` int(20) unsigned NOT NULL AUTO_INCREMENT, `Aliquots_Fridge` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Aliquots_Fridge`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.aliquots_fridge: 0 rows /*!40000 ALTER TABLE `aliquots_fridge` DISABLE KEYS */; /*!40000 ALTER TABLE `aliquots_fridge` ENABLE KEYS */; -- Dumping structure for table dnabank.aliquots_rack DROP TABLE IF EXISTS `aliquots_rack`; CREATE TABLE IF NOT EXISTS `aliquots_rack` ( `ID_Aliquots_Rack` int(20) unsigned NOT NULL AUTO_INCREMENT, `Aliquots_Rack` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Aliquots_Rack`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.aliquots_rack: 0 rows /*!40000 ALTER TABLE `aliquots_rack` DISABLE KEYS */; /*!40000 ALTER TABLE `aliquots_rack` ENABLE KEYS */; -- Dumping structure for table dnabank.amplifications DROP TABLE IF EXISTS `amplifications`; CREATE TABLE IF NOT EXISTS `amplifications` ( `ID_Amplification` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_DNA` int(20) unsigned NOT NULL, `ID_GeneticLocus` int(20) unsigned NOT NULL, `GenBankNumber` varchar(150) DEFAULT NULL, `Link` varchar(500) DEFAULT NULL, `Amplification_Date` datetime DEFAULT NULL, `ID_Amplification_Staff` int(20) unsigned DEFAULT NULL, `Amplification_Success` varchar(10) DEFAULT NULL, `ID_Purification` int(20) DEFAULT NULL, `ID_PrimerForward` int(20) unsigned DEFAULT NULL, `ID_PrimerReverse` int(20) unsigned DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Update_Who` varchar(50) DEFAULT NULL, `Update_When` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_Amplification`), KEY `ID_DNA` (`ID_DNA`), KEY `ID_GeneticLocus` (`ID_GeneticLocus`), KEY `ID_Amplification_Staff` (`ID_Amplification_Staff`), KEY `ID_Purification` (`ID_Purification`), KEY `ID_PrimerForward` (`ID_PrimerForward`), KEY `ID_PrimerReverse` (`ID_PrimerReverse`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.amplifications: 0 rows /*!40000 ALTER TABLE `amplifications` DISABLE KEYS */; /*!40000 ALTER TABLE `amplifications` ENABLE KEYS */; -- Dumping structure for table dnabank.authors DROP TABLE IF EXISTS `authors`; CREATE TABLE IF NOT EXISTS `authors` ( `ID_Author` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Author` varchar(150) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Author`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.authors: 0 rows /*!40000 ALTER TABLE `authors` DISABLE KEYS */; /*!40000 ALTER TABLE `authors` ENABLE KEYS */; -- Dumping structure for table dnabank.basisofrecordspecimen DROP TABLE IF EXISTS `basisofrecordspecimen`; CREATE TABLE IF NOT EXISTS `basisofrecordspecimen` ( `ID_BasisOfRecord_Specimen` int(20) unsigned NOT NULL AUTO_INCREMENT, `BasisOfRecord_Specimen` varchar(50) NOT NULL, `Description` varchar(255) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_BasisOfRecord_Specimen`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.basisofrecordspecimen: 5 rows /*!40000 ALTER TABLE `basisofrecordspecimen` DISABLE KEYS */; INSERT INTO `basisofrecordspecimen` (`ID_BasisOfRecord_Specimen`, `BasisOfRecord_Specimen`, `Description`, `Created_Who`, `Created_When`) VALUES (1, 'Specimen', 'A physical object representing one or more organisms.', 'unknown', '0000-00-00 00:00:00'), (2, 'Observation', 'A report by a known observer', 'unknown', '0000-00-00 00:00:00'), (3, 'Living', 'An organism removed from its natural occurrence and now living in captivity or cultivation', 'unknown', '0000-00-00 00:00:00'), (4, 'Germplasm', 'Plant, animal and bacterial genetic material for use in breeding new organisms', 'unknown', '0000-00-00 00:00:00'), (5, 'Fossil', 'A physical object representing one or more fossil organisms', 'unknown', '0000-00-00 00:00:00'); /*!40000 ALTER TABLE `basisofrecordspecimen` ENABLE KEYS */; -- Dumping structure for table dnabank.biogeographicregion DROP TABLE IF EXISTS `biogeographicregion`; CREATE TABLE IF NOT EXISTS `biogeographicregion` ( `ID_BiogeographicRegion` int(10) unsigned NOT NULL AUTO_INCREMENT, `BiogeographicRegion` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_BiogeographicRegion`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.biogeographicregion: 12 rows /*!40000 ALTER TABLE `biogeographicregion` DISABLE KEYS */; INSERT INTO `biogeographicregion` (`ID_BiogeographicRegion`, `BiogeographicRegion`, `Created_Who`, `Created_When`) VALUES (1, 'Arctic', 'G.Droege', '2011-08-31 10:43:18'), (2, 'Boreal', 'G.Droege', '2011-08-31 10:43:26'), (3, 'Atlantic', 'G.Droege', '2011-08-31 10:43:35'), (4, 'Continental', 'G.Droege', '2011-08-31 10:43:47'), (5, 'Alpine', 'G.Droege', '2011-08-31 10:43:57'), (6, 'Pannonian', 'G.Droege', '2011-08-31 10:44:05'), (7, 'West Mediterranean', 'G.Droege', '2011-08-31 10:44:14'), (8, 'East Mediterranean', 'G.Droege', '2011-08-31 10:44:24'), (9, 'Macaronesian', 'G.Droege', '2011-08-31 10:44:44'), (10, 'Steppic', 'G.Droege', '2011-08-31 10:44:53'), (11, 'Black Sea', 'G.Droege', '2011-08-31 10:45:00'), (12, 'Anatolian', 'G.Droege', '2011-08-31 10:45:09'); /*!40000 ALTER TABLE `biogeographicregion` ENABLE KEYS */; -- Dumping structure for table dnabank.cachecollection DROP TABLE IF EXISTS `cachecollection`; CREATE TABLE IF NOT EXISTS `cachecollection` ( `ID_Cache` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Dataset_Specimen` int(20) unsigned NOT NULL, `UnitID_Specimen` varchar(255) NOT NULL, `CollectionCode_Specimen` varchar(255) NOT NULL, `InstitutionCode_Specimen` varchar(255) NOT NULL, `ContinentOrOcean` varchar(255) DEFAULT NULL, `CountryName` varchar(255) DEFAULT NULL, `CountryISO2` varchar(50) DEFAULT NULL, `Collectors` varchar(200) DEFAULT NULL, `CollectionDate` varchar(200) DEFAULT NULL, `CollectionDateMin` varchar(200) DEFAULT NULL, `CollectionDateMax` varchar(200) DEFAULT NULL, `CollectorsNo` varchar(100) DEFAULT NULL, `Locality` varchar(300) DEFAULT NULL, `Altitude` varchar(50) DEFAULT NULL, `Longitude` varchar(50) DEFAULT NULL, `Latitude` varchar(50) DEFAULT NULL, `CollectionInfo_Other` varchar(500) DEFAULT NULL, `TypeStatus` varchar(150) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Cache`), KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.cachecollection: 0 rows /*!40000 ALTER TABLE `cachecollection` DISABLE KEYS */; /*!40000 ALTER TABLE `cachecollection` ENABLE KEYS */; -- Dumping structure for table dnabank.cachehighertaxa DROP TABLE IF EXISTS `cachehighertaxa`; CREATE TABLE IF NOT EXISTS `cachehighertaxa` ( `ID_HigherTaxon` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_CacheTaxonIdentified` bigint(20) unsigned NOT NULL, `HigherTaxon` varchar(255) DEFAULT NULL, `TaxonRank` varchar(255) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_HigherTaxon`), KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.cachehighertaxa: 0 rows /*!40000 ALTER TABLE `cachehighertaxa` DISABLE KEYS */; /*!40000 ALTER TABLE `cachehighertaxa` ENABLE KEYS */; -- Dumping structure for table dnabank.cacheimages DROP TABLE IF EXISTS `cacheimages`; CREATE TABLE IF NOT EXISTS `cacheimages` ( `ID_Images` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Cache` int(20) unsigned NOT NULL, `Images` varchar(500) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Images`), KEY `ID_Cache` (`ID_Cache`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.cacheimages: 0 rows /*!40000 ALTER TABLE `cacheimages` DISABLE KEYS */; /*!40000 ALTER TABLE `cacheimages` ENABLE KEYS */; -- Dumping structure for table dnabank.cachetaxonidentified DROP TABLE IF EXISTS `cachetaxonidentified`; CREATE TABLE IF NOT EXISTS `cachetaxonidentified` ( `ID_TaxonIdentified` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Cache` bigint(20) unsigned NOT NULL, `Genus` varchar(255) DEFAULT NULL, `Subgenus` varchar(255) DEFAULT NULL, `FirstEpithet` varchar(255) DEFAULT NULL, `SecondEpithet` varchar(255) DEFAULT NULL, `Rank` varchar(50) DEFAULT NULL, `HybridFlag` varchar(50) DEFAULT NULL, `Other` varchar(500) DEFAULT NULL, `NameAuthorYear` varchar(500) DEFAULT NULL, `PreferredFlag` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_TaxonIdentified`), KEY `ID_Cache` (`ID_Cache`), KEY `Genus` (`Genus`), KEY `FirstEpithet` (`FirstEpithet`), KEY `SecondEpithet` (`SecondEpithet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.cachetaxonidentified: 0 rows /*!40000 ALTER TABLE `cachetaxonidentified` DISABLE KEYS */; /*!40000 ALTER TABLE `cachetaxonidentified` ENABLE KEYS */; -- Dumping structure for table dnabank.cloningmethod DROP TABLE IF EXISTS `cloningmethod`; CREATE TABLE IF NOT EXISTS `cloningmethod` ( `ID_CloningMethod` int(10) unsigned NOT NULL AUTO_INCREMENT, `CloningMethod` varchar(50) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_CloningMethod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.cloningmethod: 0 rows /*!40000 ALTER TABLE `cloningmethod` DISABLE KEYS */; /*!40000 ALTER TABLE `cloningmethod` ENABLE KEYS */; -- Dumping structure for table dnabank.countryisocode DROP TABLE IF EXISTS `countryisocode`; CREATE TABLE IF NOT EXISTS `countryisocode` ( `ID_Country` bigint(20) NOT NULL AUTO_INCREMENT, `IsoCode` varchar(50) NOT NULL, `Country` varchar(150) NOT NULL, PRIMARY KEY (`ID_Country`) ) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.countryisocode: 254 rows /*!40000 ALTER TABLE `countryisocode` DISABLE KEYS */; INSERT INTO `countryisocode` (`ID_Country`, `IsoCode`, `Country`) VALUES (1, 'AD', 'Andorra'), (2, 'AE', 'United Arab Emirates'), (3, 'AF', 'Afghanistan'), (4, 'AG', 'Antigua & Barbuda'), (5, 'AI', 'Anguilla'), (6, 'AL', 'Albania'), (7, 'AM', 'Armenia'), (8, 'AN', 'Netherlands Antilles'), (9, 'AO', 'Angola'), (10, 'AQ', 'Antarctica'), (11, 'AR', 'Argentina'), (12, 'AS', 'American Samoa'), (13, 'AT', 'Austria'), (14, 'AU', 'Australia'), (15, 'AW', 'Aruba'), (16, 'AZ', 'Azerbaijan'), (17, 'BA', 'Bosnia-Hercegovina'), (18, 'BB', 'Barbados'), (19, 'BD', 'Bangladesh'), (20, 'BE', 'Belgium'), (21, 'BF', 'Burkina Faso'), (22, 'BG', 'Bulgaria'), (23, 'BH', 'Bahrain'), (24, 'BI', 'Burundi'), (25, 'BJ', 'Benin'), (26, 'BM', 'Bermuda'), (27, 'BN', 'Brunei'), (28, 'BO', 'Bolivia'), (29, 'BR', 'Brazil'), (30, 'BS', 'Bahamas'), (31, 'BT', 'Bhutan'), (32, 'BU', 'Burma'), (33, 'BV', 'Bouvet Island'), (34, 'BW', 'Botswana'), (35, 'BY', 'Belarus'), (36, 'BZ', 'Belize'), (37, 'CA', 'Canada'), (38, 'CC', 'Cocos (Keeling) Islands'), (39, 'CD', 'Congo, The Democratic Republic of the'), (40, 'CF', 'Central Africa'), (41, 'CG', 'Congo, Republic of'), (42, 'CH', 'Switzerland'), (43, 'CI', 'Ivory Coast'), (44, 'CK', 'Cook Islands'), (45, 'CL', 'Chile'), (46, 'CM', 'Cameroon'), (47, 'CN', 'China'), (48, 'CO', 'Colombia'), (49, 'CR', 'Costa Rica'), (50, 'CS', 'Czechoslovakia'), (51, 'CU', 'Cuba'), (52, 'CV', 'Cape Verde'), (53, 'CX', 'Christmas Island'), (54, 'CY', 'Cyprus'), (55, 'CZ', 'Czech Republic'), (258, 'PS', 'Palestinian Territory, Occupied'), (57, 'DE', 'Germany'), (58, 'DJ', 'Djibouti'), (59, 'DK', 'Denmark'), (60, 'DM', 'Dominica'), (61, 'DO', 'Dominican Republic'), (62, 'DZ', 'Algeria'), (63, 'EC', 'Ecuador'), (64, 'EE', 'Estonia'), (65, 'EG', 'Egypt'), (66, 'EH', 'Western Sahara'), (67, 'ER', 'Eritrea'), (68, 'ES', 'Spain'), (69, 'ET', 'Ethiopia'), (70, 'FI', 'Finland'), (71, 'FJ', 'Fiji'), (72, 'FK', 'Falkland Islands and dependencies'), (73, 'FM', 'Micronesia'), (74, 'FO', 'Faroe Islands'), (75, 'FR', 'France'), (76, 'FX', 'France, Metropolitan'), (77, 'GA', 'Gabon'), (78, 'GB', 'United Kingdom'), (79, 'GD', 'Grenada'), (80, 'GE', 'Georgia'), (81, 'GF', 'French Guiana'), (82, 'GH', 'Ghana'), (83, 'GI', 'Gibraltar'), (84, 'GL', 'Greenland'), (85, 'GM', 'Gambia'), (86, 'GN', 'Guinea'), (87, 'GP', 'Guadeloupe'), (88, 'GQ', 'Equatorial Guinea'), (89, 'GR', 'Greece'), (90, 'GS', 'South Georgia and the South Sandwich Islands'), (91, 'GT', 'Guatemala'), (92, 'GU', 'Guam'), (93, 'GW', 'Guinea Bissau'), (94, 'GY', 'Guyana'), (95, 'HK', 'Hong Kong'), (96, 'HM', 'Heard & McDonald Islands'), (97, 'HN', 'Honduras'), (98, 'HR', 'Croatia'), (99, 'HT', 'Haiti'), (100, 'HU', 'Hungary'), (101, 'ID', 'Indonesia'), (102, 'IE', 'Ireland'), (103, 'IL', 'Israel'), (104, 'IN', 'India'), (105, 'IO', 'British Indian Ocean Territory'), (106, 'IQ', 'Iraq'), (107, 'IR', 'Islamic Republic of Iran'), (108, 'IS', 'Iceland'), (109, 'IT', 'Italy'), (110, 'JM', 'Jamaica'), (111, 'JO', 'Jordan'), (112, 'JP', 'Japan'), (113, 'KE', 'Kenya'), (114, 'KG', 'Kyrgyzstan'), (115, 'KH', 'Cambodia'), (116, 'KI', 'Kiribati'), (117, 'KM', 'Comoros'), (118, 'KN', 'Saint Kitts and Nevis'), (119, 'KP', 'Korea, Democratic People´s Republic of'), (120, 'KR', 'Korea, Republic of'), (121, 'KW', 'Kuwait'), (122, 'KY', 'Cayman Islands'), (123, 'KZ', 'Kazakhstan'), (124, 'LA', 'Laos'), (125, 'LB', 'Lebanon'), (126, 'LC', 'Saint Lucia'), (127, 'LI', 'Liechtenstein'), (128, 'LK', 'Sri Lanka'), (129, 'LR', 'Liberia'), (130, 'LS', 'Lesotho'), (131, 'LT', 'Lithuania'), (132, 'LU', 'Luxembourg'), (133, 'LV', 'Latvia'), (134, 'LY', 'Libya'), (135, 'MA', 'Morocco'), (136, 'MC', 'Monaco'), (137, 'MD', 'Moldova, Republic of'), (138, 'MG', 'Madagascar'), (139, 'MH', 'Marshall Islands'), (140, 'MK', 'Macedonia'), (141, 'ML', 'Mali'), (142, 'MM', 'Myanmar'), (143, 'MN', 'Mongolia'), (144, 'MO', 'Macau'), (145, 'MP', 'Northern Mariana Islands'), (146, 'MQ', 'Martinique'), (147, 'MR', 'Mauritania'), (148, 'MS', 'Montserrat'), (149, 'MT', 'Malta'), (150, 'MU', 'Mauritius'), (151, 'MV', 'Maldives'), (152, 'MW', 'Malawi'), (153, 'MX', 'Mexico'), (154, 'MY', 'Malaysia'), (155, 'MZ', 'Mozambique'), (156, 'NA', 'Namibia'), (157, 'NC', 'New Caledonia'), (158, 'NE', 'Niger'), (159, 'NF', 'Norfolk Island'), (160, 'NG', 'Nigeria'), (161, 'NI', 'Nicaragua'), (162, 'NL', 'Netherlands'), (163, 'NO', 'Norway'), (164, 'NP', 'Nepal'), (165, 'NR', 'Nauru'), (166, 'NT', 'Neutral Zone (no longer exists)'), (167, 'NU', 'Niue'), (168, 'NZ', 'New Zealand'), (169, 'OM', 'Oman'), (170, 'PA', 'Panama'), (171, 'PE', 'Peru'), (172, 'PF', 'French Polynesia'), (173, 'PG', 'Papua New Guinea'), (174, 'PH', 'Philippines'), (175, 'PK', 'Pakistan'), (176, 'PL', 'Poland'), (177, 'PM', 'Saint Pierre and Miquelon'), (178, 'PN', 'Pitcairn'), (179, 'PR', 'Puerto Rico'), (180, 'PT', 'Portugal'), (181, 'PW', 'Palau'), (182, 'PY', 'Paraguay'), (183, 'QA', 'Qatar'), (184, 'RE', 'Reunion'), (185, 'RO', 'Romania'), (186, 'RU', 'Russia'), (187, 'RW', 'Rwanda'), (188, 'SA', 'Saudi Arabia'), (189, 'SB', 'Solomon Islands'), (190, 'SC', 'Seychelles'), (191, 'SD', 'Sudan'), (192, 'SE', 'Sweden'), (193, 'SG', 'Singapore'), (194, 'SH', 'Saint Helena'), (195, 'SI', 'Slovenia'), (196, 'SJ', 'Svalbard and Jan Mayen Islands'), (197, 'SK', 'Slovakia'), (198, 'SL', 'Sierra Leone'), (199, 'SM', 'San Marino'), (200, 'SN', 'Senegal'), (201, 'SO', 'Somalia'), (202, 'SR', 'Suriname'), (203, 'ST', 'Sao Tome and Principe'), (205, 'SV', 'El Salvador'), (206, 'SY', 'Syria'), (207, 'SZ', 'Swaziland'), (208, 'TC', 'Turks and Caicos Islands'), (209, 'TD', 'Chad'), (210, 'TF', 'French Southern Territories'), (211, 'TG', 'Togo'), (212, 'TH', 'Thailand'), (213, 'TJ', 'Tajikistan'), (214, 'TK', 'Tokelau'), (215, 'TM', 'Turkmenistan'), (216, 'TN', 'Tunisia'), (217, 'TO', 'Tonga'), (218, 'TP', 'East Timor'), (219, 'TR', 'Turkey'), (220, 'TT', 'Trinidad and Tobago'), (221, 'TV', 'Tuvalu'), (222, 'TW', 'Taiwan'), (223, 'TZ', 'Tanzania'), (224, 'UA', 'Ukraine'), (225, 'UG', 'Uganda'), (226, 'UM', 'United States Minor Outlying Islands'), (227, 'US', 'United States of America'), (228, 'UY', 'Uruguay'), (229, 'UZ', 'Uzbekistan'), (230, 'VA', 'Vatican'), (231, 'VC', 'Saint Vincent and the Grenadines'), (232, 'VE', 'Venezuela'), (233, 'VG', 'British Virgin Islands'), (234, 'VI', 'Virgin Islands of the United States'), (235, 'VN', 'Vietnam'), (236, 'VU', 'Vanuatu'), (237, 'WF', 'Wallis & Futuna Islands'), (238, 'WS', 'Samoa'), (239, 'XA', 'Unknown or unspecified Africa'), (240, 'XB', 'Unknown or unspecified Middle and South America'), (241, 'XC', 'Unknown or unspecified Asia'), (242, 'XD', 'Unknown or unspecified Australia and Oceania'), (243, 'XE', 'Unknown or unspecified Europe'), (244, 'XF', 'Unknown or unspecified North America'), (245, 'YD', 'Democratic Yemen'), (246, 'YE', 'Yemen'), (247, 'YT', 'Mayotte'), (248, 'YU', 'Yugoslavia'), (249, 'ZA', 'South Africa'), (250, 'ZM', 'Zambia'), (251, 'ZR', 'Zaire'), (252, 'ZW', 'Zimbabwe'), (253, 'ZZ', 'Unknown or unspecified country'), (254, 'ME', 'Montenegro'), (257, 'RS', 'Serbia'); /*!40000 ALTER TABLE `countryisocode` ENABLE KEYS */; -- Dumping structure for table dnabank.country_continent DROP TABLE IF EXISTS `country_continent`; CREATE TABLE IF NOT EXISTS `country_continent` ( `ID_Country` bigint(20) DEFAULT NULL, `Continent` varchar(50) DEFAULT NULL, KEY `ID_Coutry` (`ID_Country`), KEY `Country` (`Continent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.country_continent: 256 rows /*!40000 ALTER TABLE `country_continent` DISABLE KEYS */; INSERT INTO `country_continent` (`ID_Country`, `Continent`) VALUES (1, 'Europe'), (2, 'Asia'), (3, 'Asia'), (4, 'Middle and South America'), (5, 'Middle and South America'), (6, 'Europe'), (7, 'Asia'), (8, 'Middle and South America'), (9, 'Africa'), (10, 'Antarctica'), (11, 'Middle and South America'), (12, 'Australia and Oceania'), (13, 'Europe'), (14, 'Australia and Oceania'), (15, 'Middle and South America'), (16, 'Asia'), (17, 'Europe'), (18, 'Middle and South America'), (19, 'Asia'), (20, 'Europe'), (21, 'Africa'), (22, 'Europe'), (23, 'Asia'), (24, 'Africa'), (25, 'Africa'), (26, 'Middle and South America'), (27, 'Asia'), (28, 'Middle and South America'), (29, 'Middle and South America'), (30, 'Middle and South America'), (31, 'Asia'), (32, 'Africa'), (33, 'Unknown'), (34, 'Africa'), (35, 'Europe'), (36, 'Middle and South America'), (37, 'North America'), (38, 'Unknown'), (39, 'Africa'), (40, 'Africa'), (41, 'Africa'), (42, 'Europe'), (43, 'Africa'), (44, 'Australia and Oceania'), (45, 'Middle and South America'), (46, 'Africa'), (47, 'Asia'), (48, 'Middle and South America'), (49, 'Middle and South America'), (50, 'Europe'), (51, 'Middle and South America'), (52, 'Africa'), (53, 'Unknown'), (54, 'Europe'), (55, 'Europe'), (56, 'Europe'), (57, 'Europe'), (58, 'Africa'), (59, 'Europe'), (60, 'Middle and South America'), (61, 'Middle and South America'), (62, 'Africa'), (63, 'Middle and South America'), (64, 'Europe'), (65, 'Africa'), (66, 'Africa'), (67, 'Africa'), (68, 'Europe'), (69, 'Africa'), (70, 'Europe'), (71, 'Australia and Oceania'), (72, 'Middle and South America'), (73, 'Australia and Oceania'), (74, 'Europe'), (75, 'Europe'), (76, 'Europe'), (77, 'Africa'), (78, 'Europe'), (79, 'Middle and South America'), (80, 'Asia'), (81, 'Middle and South America'), (82, 'Africa'), (83, 'Europe'), (84, 'North America'), (85, 'Africa'), (86, 'Africa'), (87, 'Middle and South America'), (88, 'Africa'), (89, 'Europe'), (90, 'Middle and South America'), (91, 'Middle and South America'), (92, 'Australia and Oceania'), (93, 'Africa'), (94, 'Middle and South America'), (95, 'Asia'), (96, 'Unknown'), (97, 'Middle and South America'), (98, 'Europe'), (99, 'Middle and South America'), (100, 'Europe'), (101, 'Asia'), (102, 'Europe'), (103, 'Asia'), (104, 'Asia'), (105, 'Unknown'), (106, 'Asia'), (107, 'Asia'), (108, 'Europe'), (109, 'Europe'), (110, 'Middle and South America'), (111, 'Asia'), (112, 'Asia'), (113, 'Africa'), (114, 'Asia'), (115, 'Asia'), (116, 'Australia and Oceania'), (117, 'Africa'), (118, 'Middle and South America'), (119, 'Asia'), (120, 'Asia'), (121, 'Asia'), (122, 'Middle and South America'), (123, 'Asia'), (124, 'Asia'), (125, 'Asia'), (126, 'Middle and South America'), (127, 'Europe'), (128, 'Asia'), (129, 'Africa'), (130, 'Africa'), (131, 'Europe'), (132, 'Europe'), (133, 'Europe'), (134, 'Europe'), (135, 'Africa'), (136, 'Europe'), (137, 'Europe'), (138, 'Africa'), (139, 'Australia and Oceania'), (140, 'Europe'), (141, 'Africa'), (142, 'Asia'), (143, 'Asia'), (144, 'Unknown'), (145, 'Australia and Oceania'), (146, 'Middle and South America'), (147, 'Africa'), (148, 'Middle and South America'), (149, 'Europe'), (150, 'Africa'), (151, 'Asia'), (152, 'Africa'), (153, 'North America'), (154, 'Asia'), (155, 'Africa'), (156, 'Africa'), (157, 'Australia and Oceania'), (158, 'Africa'), (159, 'Australia and Oceania'), (160, 'Africa'), (161, 'Middle and South America'), (162, 'Europe'), (163, 'Europe'), (164, 'Asia'), (165, 'Australia and Oceania'), (166, 'Unknown'), (167, 'Australia and Oceania'), (168, 'Australia and Oceania'), (169, 'Asia'), (170, 'Middle and South America'), (171, 'Middle and South America'), (172, 'Australia and Oceania'), (173, 'Australia and Oceania'), (174, 'Asia'), (175, 'Asia'), (176, 'Europe'), (177, 'Middle and South America'), (178, 'Unknown'), (179, 'Middle and South America'), (180, 'Europe'), (181, 'Australia and Oceania'), (182, 'Middle and South America'), (183, 'Asia'), (184, 'Africa'), (185, 'Europe'), (186, 'Asia'), (187, 'Africa'), (188, 'Asia'), (189, 'Australia and Oceania'), (190, 'Africa'), (191, 'Africa'), (192, 'Europe'), (193, 'Asia'), (194, 'Africa'), (195, 'Europe'), (196, 'Europe'), (197, 'Europe'), (198, 'Africa'), (199, 'Europe'), (200, 'Africa'), (201, 'Africa'), (202, 'Middle and South America'), (203, 'Africa'), (205, 'Middle and South America'), (206, 'Asia'), (207, 'Africa'), (208, 'Middle and South America'), (209, 'Africa'), (210, 'Unknown'), (211, 'Africa'), (212, 'Asia'), (213, 'Asia'), (214, 'Australia and Oceania'), (215, 'Asia'), (216, 'Africa'), (217, 'Australia and Oceania'), (218, 'Asia'), (219, 'Asia'), (220, 'Middle and South America'), (221, 'Australia and Oceania'), (222, 'Asia'), (223, 'Africa'), (224, 'Europe'), (225, 'Africa'), (226, 'Unknown'), (227, 'North America'), (228, 'Middle and South America'), (229, 'Asia'), (230, 'Europe'), (231, 'Middle and South America'), (232, 'Middle and South America'), (233, 'Middle and South America'), (234, 'Middle and South America'), (235, 'Asia'), (236, 'Australia and Oceania'), (237, 'Australia and Oceania'), (238, 'Australia and Oceania'), (239, 'Africa'), (240, 'Middle and South America'), (241, 'Asia'), (242, 'Australia and Oceania'), (243, 'Europe'), (244, 'North America'), (245, 'Africa'), (246, 'Asia'), (247, 'Africa'), (248, 'Europe'), (249, 'Africa'), (250, 'Africa'), (251, 'Africa'), (252, 'Africa'), (253, 'Unknown'), (254, 'Europe'), (256, 'Europe'), (256, 'Asia'), (258, 'Asia'); /*!40000 ALTER TABLE `country_continent` ENABLE KEYS */; -- Dumping structure for table dnabank.dataset DROP TABLE IF EXISTS `dataset`; CREATE TABLE IF NOT EXISTS `dataset` ( `ID_Dataset` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Provider` int(20) unsigned NOT NULL, `Digir_Resource` varchar(255) DEFAULT NULL, `Digir_Source` varchar(255) DEFAULT NULL, `Display` varchar(255) DEFAULT NULL, `Internal_External` varchar(10) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Dataset`), KEY `ID_Provider` (`ID_Provider`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.dataset: 1 rows /*!40000 ALTER TABLE `dataset` DISABLE KEYS */; INSERT INTO `dataset` (`ID_Dataset`, `ID_Provider`, `Digir_Resource`, `Digir_Source`, `Display`, `Internal_External`, `Created_When`, `Created_Who`) VALUES (1, 0, NULL, NULL, ' Specimen Tool', '1', '2008-07-20 14:06:02', 'G.Droege'); /*!40000 ALTER TABLE `dataset` ENABLE KEYS */; -- Dumping structure for table dnabank.degradation DROP TABLE IF EXISTS `degradation`; CREATE TABLE IF NOT EXISTS `degradation` ( `ID_Degradation` int(20) unsigned NOT NULL AUTO_INCREMENT, `Degradation` varchar(50) NOT NULL, PRIMARY KEY (`ID_Degradation`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.degradation: 3 rows /*!40000 ALTER TABLE `degradation` DISABLE KEYS */; INSERT INTO `degradation` (`ID_Degradation`, `Degradation`) VALUES (1, 'low'), (2, 'medium'), (3, 'high'); /*!40000 ALTER TABLE `degradation` ENABLE KEYS */; -- Dumping structure for table dnabank.dnabanknumbers DROP TABLE IF EXISTS `dnabanknumbers`; CREATE TABLE IF NOT EXISTS `dnabanknumbers` ( `ID_DNA` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Cache` bigint(20) unsigned NOT NULL, `ID_Provided_By_People` bigint(20) unsigned DEFAULT NULL, `ID_Type` bigint(20) unsigned DEFAULT NULL, `ID_Location_Stock` bigint(20) unsigned DEFAULT NULL, `DNA_Bank_Number` varchar(50) DEFAULT NULL, `ID_RelationDNA_Voucher` bigint(20) unsigned DEFAULT NULL, `ID_Tissue` bigint(20) unsigned DEFAULT NULL, `ID_Preservation` bigint(20) unsigned DEFAULT NULL, `Extraction_Date` datetime DEFAULT NULL, `NoExtractDate` tinyint(4) DEFAULT NULL, `ID_Extraction_Method` bigint(20) unsigned DEFAULT NULL, `ID_Purification` bigint(20) unsigned DEFAULT NULL, `ID_Extraction_Staff` bigint(20) unsigned DEFAULT NULL, `ID_Degradation` bigint(20) unsigned DEFAULT NULL, `Check_Date` datetime DEFAULT NULL, `Concentration` varchar(5) DEFAULT NULL, `Absorbance280` varchar(5) DEFAULT NULL, `Absorbance230` varchar(5) DEFAULT NULL, `Stock_Gone` tinyint(1) DEFAULT NULL, `Source_Gone` tinyint(1) DEFAULT NULL, `Notes` varchar(500) DEFAULT NULL, `Notes_Intern` varchar(500) DEFAULT NULL, `Block_Until` varchar(50) DEFAULT NULL, `Block_General` tinyint(1) DEFAULT NULL, `Backup_Aliquot` tinyint(1) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Update_Who` varchar(50) DEFAULT NULL, `Update_When` timestamp NULL DEFAULT NULL, `Lock_Who` varchar(50) DEFAULT NULL, `Lock_When` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_DNA`), KEY `TableDNABankNumbers_FKIndex1` (`ID_Extraction_Method`), KEY `TableDNABankNumbers_FKIndex4` (`ID_Degradation`), KEY `TableDNABankNumbers_FKIndex6` (`ID_Tissue`), KEY `TableDNABankNumbers_FKIndex7` (`ID_Preservation`), KEY `TableDNABankNumbers_FKIndex9` (`ID_Type`), KEY `TableDNABankNumbers_FKIndex10` (`ID_Location_Stock`), KEY `TableDnaBankNumbers_FKIndexCache` (`ID_Cache`), KEY `ID_Provided_By` (`ID_Provided_By_People`), KEY `ID_RelationtoVoucher` (`ID_RelationDNA_Voucher`), KEY `ID_Purification` (`ID_Purification`), KEY `ID_Extraction_Staff` (`ID_Extraction_Staff`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.dnabanknumbers: 0 rows /*!40000 ALTER TABLE `dnabanknumbers` DISABLE KEYS */; /*!40000 ALTER TABLE `dnabanknumbers` ENABLE KEYS */; -- Dumping structure for table dnabank.dnatype DROP TABLE IF EXISTS `dnatype`; CREATE TABLE IF NOT EXISTS `dnatype` ( `ID_Type` int(11) unsigned NOT NULL AUTO_INCREMENT, `Type` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Type`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.dnatype: 2 rows /*!40000 ALTER TABLE `dnatype` DISABLE KEYS */; INSERT INTO `dnatype` (`ID_Type`, `Type`, `Created_When`, `Created_Who`) VALUES (1, 'Mitochondrial DNA', '0000-00-00 00:00:00', ''), (2, 'gDNA', '0000-00-00 00:00:00', ''); /*!40000 ALTER TABLE `dnatype` ENABLE KEYS */; -- Dumping structure for table dnabank.extractionmethod DROP TABLE IF EXISTS `extractionmethod`; CREATE TABLE IF NOT EXISTS `extractionmethod` ( `ID_Method` int(20) unsigned NOT NULL AUTO_INCREMENT, `Method` varchar(50) NOT NULL, `Company` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Method`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.extractionmethod: 0 rows /*!40000 ALTER TABLE `extractionmethod` DISABLE KEYS */; /*!40000 ALTER TABLE `extractionmethod` ENABLE KEYS */; -- Dumping structure for table dnabank.geneticlocus DROP TABLE IF EXISTS `geneticlocus`; CREATE TABLE IF NOT EXISTS `geneticlocus` ( `ID_GeneticLocus` int(20) unsigned NOT NULL AUTO_INCREMENT, `GeneticLocus` varchar(150) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_GeneticLocus`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.geneticlocus: 0 rows /*!40000 ALTER TABLE `geneticlocus` DISABLE KEYS */; /*!40000 ALTER TABLE `geneticlocus` ENABLE KEYS */; -- Dumping structure for table dnabank.geocodemethod DROP TABLE IF EXISTS `geocodemethod`; CREATE TABLE IF NOT EXISTS `geocodemethod` ( `ID_Geocode` int(10) unsigned NOT NULL AUTO_INCREMENT, `Geocode` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Geocode`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.geocodemethod: 5 rows /*!40000 ALTER TABLE `geocodemethod` DISABLE KEYS */; INSERT INTO `geocodemethod` (`ID_Geocode`, `Geocode`, `Created_Who`, `Created_When`) VALUES (1, 'GPS', 'G.Droege', '2011-08-31 10:40:36'), (2, 'DGPS', 'G.Droege', '2011-08-31 10:40:46'), (3, 'Estimate', 'G.Droege', '2011-08-31 10:40:54'), (4, 'Map', 'G.Droege', '2011-08-31 10:41:03'), (5, 'Others', 'G.Droege', '2011-08-31 10:41:10'); /*!40000 ALTER TABLE `geocodemethod` ENABLE KEYS */; -- Dumping structure for table dnabank.habitatcode DROP TABLE IF EXISTS `habitatcode`; CREATE TABLE IF NOT EXISTS `habitatcode` ( `ID_HabitatCode` int(10) unsigned NOT NULL AUTO_INCREMENT, `HabitatCode` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_HabitatCode`) ) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.habitatcode: 58 rows /*!40000 ALTER TABLE `habitatcode` DISABLE KEYS */; INSERT INTO `habitatcode` (`ID_HabitatCode`, `HabitatCode`, `Created_Who`, `Created_When`) VALUES (1, 'A1 - Littoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:09:18'), (2, 'A2 - Littoral sediment', 'G.Droege', '2011-08-31 17:09:41'), (3, 'A3 - Infralittoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:10:30'), (4, 'A4 - Circalittoral rock and other hard substrata', 'G.Droege', '2011-08-31 17:10:31'), (5, 'A5 - Sublittoral sediment', 'G.Droege', '2011-08-31 17:10:42'), (6, 'A6 - Deep-sea bead', 'G.Droege', '2011-08-31 17:10:51'), (7, 'A7 - Pelagic water column', 'G.Droege', '2011-08-31 17:11:12'), (8, 'A8 - Ice-associated marine habitats', 'G.Droege', '2011-08-31 17:11:24'), (9, 'B1 - Coastal Dunes and Sandy Shores', 'G.Droege', '2011-08-31 17:11:39'), (10, 'B2 - Coastal Shingle', 'G.Droege', '2011-08-31 17:11:50'), (11, 'B3 - Rock cliffs, ledges and shores, including the', 'G.Droege', '2011-08-31 17:12:07'), (12, 'C1 - Surface standing waters', 'G.Droege', '2011-08-31 17:12:21'), (13, 'C2 - Surface running waters', 'G.Droege', '2011-08-31 17:12:32'), (14, 'C3 - Littoral zone of inland surface waterbodies', 'G.Droege', '2011-08-31 17:12:47'), (15, 'D1 - Raised and blanket bogs', 'G.Droege', '2011-08-31 17:13:28'), (16, 'D2 - Valley mires, poor fens and transition mires', 'G.Droege', '2011-08-31 17:13:42'), (17, 'D3 - Aapa, palsa and polygon mires', 'G.Droege', '2011-08-31 17:13:55'), (18, 'D4 - Base-rich fens and calcareous spring mires', 'G.Droege', '2011-08-31 17:14:11'), (19, 'D5 - Sedge and reedbeds, normally without free-sta', 'G.Droege', '2011-08-31 17:14:29'), (20, 'D6 - Inland saline and brackish marshes and reedbe', 'G.Droege', '2011-08-31 17:14:43'), (21, 'E1 - Dry grasslands', 'G.Droege', '2011-08-31 17:19:56'), (22, 'E2 - Mesic grasslands', 'G.Droege', '2011-08-31 17:20:13'), (23, 'E3 - Seasonally wet and wet grasslands', 'G.Droege', '2011-08-31 17:20:29'), (24, 'E4 - Alpine and subalpine grasslands', 'G.Droege', '2011-08-31 17:20:45'), (25, 'E5 - Woodland fringes and clearings and tall forb ', 'G.Droege', '2011-08-31 17:21:03'), (26, 'E6 - Inland salt steppes', 'G.Droege', '2011-08-31 17:21:12'), (27, 'E7 - Sparsely wooded grasslands', 'G.Droege', '2011-08-31 17:21:24'), (28, 'F1 - Tundra', 'G.Droege', '2011-08-31 17:21:39'), (29, 'F2 - Arctic, alpine and subalpine scrub', 'G.Droege', '2011-08-31 17:21:52'), (30, 'F3 - Temperate and mediterranean-montane scrub', 'G.Droege', '2011-08-31 17:22:43'), (31, 'F4 - Temperate shrub heathland', 'G.Droege', '2011-08-31 17:22:58'), (32, 'F5 - Maquis, arborescent matorral and thermo-Medit', 'G.Droege', '2011-08-31 17:23:20'), (33, 'F6 - Garrigue', 'G.Droege', '2011-08-31 17:23:29'), (34, 'F7 - Spiny Mediterranean heaths (phrygana, hedgeho', 'G.Droege', '2011-08-31 17:24:20'), (35, 'F8 - Thermo-Atlantic xerophytic scrub', 'G.Droege', '2011-08-31 17:24:33'), (36, 'F9 - Riverine and fen scrubs', 'G.Droege', '2011-08-31 17:24:43'), (37, 'FA - Hedgerows', 'G.Droege', '2011-08-31 17:24:54'), (38, 'FB - Shrub plantations', 'G.Droege', '2011-08-31 17:25:04'), (39, 'G1 - Broadleaved decidous woodland', 'G.Droege', '2011-08-31 17:29:32'), (40, 'G2 - Broadleaved evergreen woodland', 'G.Droege', '2011-08-31 17:29:44'), (41, 'G3 - Coniferous woodland', 'G.Droege', '2011-08-31 17:29:52'), (42, 'G4 - Mixed deciduous and coniferous woodland', 'G.Droege', '2011-08-31 17:30:19'), (43, 'G5 - Lines of trees, small anthropogenic woodlands', 'G.Droege', '2011-08-31 17:30:59'), (44, 'H1 - Terrestrial underground caves, cave systems, ', 'G.Droege', '2011-08-31 17:31:16'), (45, 'H2 - Screes', 'G.Droege', '2011-08-31 17:31:22'), (46, 'H3 - Inland cliffs, rock pavements and outcrops', 'G.Droege', '2011-08-31 17:31:33'), (47, 'H4 - Snow or ice-dominated habitats', 'G.Droege', '2011-08-31 17:31:49'), (48, 'H5 - Miscellaneous inland habitats with very spars', 'G.Droege', '2011-08-31 17:32:06'), (49, 'H6 - Recent volcanic features', 'G.Droege', '2011-08-31 17:32:18'), (50, 'I1 - Arable land and market gardens', 'G.Droege', '2011-08-31 17:32:34'), (51, 'I2 - Cultivated areas of gardens and parks', 'G.Droege', '2011-08-31 17:32:56'), (52, 'J1 - Buildings of cities, towns and villages', 'G.Droege', '2011-08-31 17:33:20'), (53, 'J2 - Low density buildings', 'G.Droege', '2011-08-31 17:33:31'), (54, 'J3 - Extractive industrial sites', 'G.Droege', '2011-08-31 17:33:44'), (55, 'J4 - Transport networks and other constructed hard', 'G.Droege', '2011-08-31 17:34:03'), (56, 'J5 - Highly artificial man-made waters and associa', 'G.Droege', '2011-08-31 17:34:25'), (57, 'J6 - Waste deposits', 'G.Droege', '2011-08-31 17:34:34'), (58, 'X : Habitat complexes', 'G.Droege', '2011-08-31 17:34:43'); /*!40000 ALTER TABLE `habitatcode` ENABLE KEYS */; -- Dumping structure for table dnabank.images DROP TABLE IF EXISTS `images`; CREATE TABLE IF NOT EXISTS `images` ( `ID_Images` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_DNA` int(20) unsigned DEFAULT NULL, `ImageUrl` varchar(500) DEFAULT NULL, `ImageRemarks` varchar(150) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Images`), KEY `ID_DNA` (`ID_DNA`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Gel Images'; -- Dumping data for table dnabank.images: 0 rows /*!40000 ALTER TABLE `images` DISABLE KEYS */; /*!40000 ALTER TABLE `images` ENABLE KEYS */; -- Dumping structure for table dnabank.journals DROP TABLE IF EXISTS `journals`; CREATE TABLE IF NOT EXISTS `journals` ( `ID_Journal` int(20) unsigned NOT NULL AUTO_INCREMENT, `Journal_Display` varchar(255) NOT NULL, `Journal_All` varchar(500) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Journal`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.journals: 0 rows /*!40000 ALTER TABLE `journals` DISABLE KEYS */; /*!40000 ALTER TABLE `journals` ENABLE KEYS */; -- Dumping structure for table dnabank.landusecode DROP TABLE IF EXISTS `landusecode`; CREATE TABLE IF NOT EXISTS `landusecode` ( `ID_LandUseCode` int(10) unsigned NOT NULL AUTO_INCREMENT, `LandUseCode` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_LandUseCode`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.landusecode: 24 rows /*!40000 ALTER TABLE `landusecode` DISABLE KEYS */; INSERT INTO `landusecode` (`ID_LandUseCode`, `LandUseCode`, `Created_Who`, `Created_When`) VALUES (1, 'L1.1 Pasture', 'G.Droege', '2011-08-31 17:35:59'), (2, 'L1.2 Fallow', 'G.Droege', '2011-08-31 17:36:14'), (3, 'L1.3 Crop', 'G.Droege', '2011-08-31 17:36:19'), (4, 'L1.4 Grassland', 'G.Droege', '2011-08-31 17:36:42'), (5, 'L1.5 Forest', 'G.Droege', '2011-08-31 17:36:48'), (6, 'L1.6 Woodland', 'G.Droege', '2011-08-31 17:36:54'), (7, 'L1.7 Protected enclosure', 'G.Droege', '2011-08-31 17:37:04'), (8, 'L2.1 Draining', 'G.Droege', '2011-08-31 17:37:13'), (9, 'L2.2 Dumping', 'G.Droege', '2011-08-31 17:37:24'), (10, 'L2.3 Aquaculture', 'G.Droege', '2011-08-31 17:37:32'), (11, 'L2.4 Quarrying / Mining', 'G.Droege', '2011-08-31 17:37:43'), (12, 'L2.5 Industrial', 'G.Droege', '2011-08-31 17:37:48'), (13, 'L2.6 Peat cutting', 'G.Droege', '2011-08-31 17:37:54'), (14, 'L3.1 Light', 'G.Droege', '2011-08-31 17:37:58'), (15, 'L3.2 Moderate', 'G.Droege', '2011-08-31 17:38:16'), (16, 'L3.3 Severe', 'G.Droege', '2011-08-31 17:38:30'), (17, 'L4.1 Walking', 'unknown', '2011-08-31 17:38:39'), (18, 'L4.2 Fishing', 'G.Droege', '2011-08-31 17:38:45'), (19, 'L4.3 Hunting', 'G.Droege', '2011-08-31 17:38:51'), (20, 'L4.4 Golf', 'G.Droege', '2011-08-31 17:38:56'), (21, 'L4.5 Sports pitch', 'G.Droege', '2011-08-31 17:39:04'), (22, 'L4.6 Camping', 'G.Droege', '2011-08-31 17:39:09'), (23, 'L4.7 Horse riding', 'G.Droege', '2011-08-31 17:39:22'), (24, 'L4.8 Cycling', 'G.Droege', '2011-08-31 17:39:29'); /*!40000 ALTER TABLE `landusecode` ENABLE KEYS */; -- Dumping structure for table dnabank.location_stock DROP TABLE IF EXISTS `location_stock`; CREATE TABLE IF NOT EXISTS `location_stock` ( `ID_Location_Stock` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Stock_Box` int(20) unsigned DEFAULT NULL, `ID_Stock_Rack` int(20) unsigned DEFAULT NULL, `ID_Stock_Fridge` int(11) unsigned DEFAULT NULL, `Stock_Position` varchar(50) DEFAULT NULL, `Stock_Barcode` varchar(200) DEFAULT NULL, `Origin_Quantity` float DEFAULT NULL, `Rest_Quantity` float DEFAULT NULL, `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Update_Who` varchar(50) DEFAULT NULL, `Update_When` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_Location_Stock`), KEY `TableLocation_FKIndex4` (`ID_Stock_Fridge`), KEY `TableLocation_FKIndex5` (`ID_Stock_Rack`), KEY `TableLocation_FKIndex6` (`ID_Stock_Box`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.location_stock: 0 rows /*!40000 ALTER TABLE `location_stock` DISABLE KEYS */; /*!40000 ALTER TABLE `location_stock` ENABLE KEYS */; -- Dumping structure for table dnabank.people DROP TABLE IF EXISTS `people`; CREATE TABLE IF NOT EXISTS `people` ( `ID_People` int(20) unsigned NOT NULL AUTO_INCREMENT, `FormOfAddress` varchar(50) DEFAULT NULL, `Title` varchar(100) DEFAULT NULL, `Forename` varchar(50) DEFAULT NULL, `Surname` varchar(50) DEFAULT NULL, `Phone` varchar(100) DEFAULT NULL, `Email` varchar(100) DEFAULT NULL, `Remarks` varchar(500) DEFAULT NULL, `Name_All` varchar(50) DEFAULT NULL, `Institut` varchar(150) DEFAULT NULL, `Division` varchar(150) DEFAULT NULL, `Street` varchar(150) DEFAULT NULL, `City` varchar(150) DEFAULT NULL, `Postal_Code` varchar(150) DEFAULT NULL, `Country` varchar(150) DEFAULT NULL, `Institut_Delivery` varchar(150) DEFAULT NULL, `Division_Delivery` varchar(150) DEFAULT NULL, `Street_Delivery` varchar(150) DEFAULT NULL, `City_Delivery` varchar(150) DEFAULT NULL, `Postal_Code_Delivery` varchar(150) DEFAULT NULL, `Country_Delivery` varchar(150) DEFAULT NULL, `ExtractionStaff` varchar(10) DEFAULT NULL, `Provider` varchar(10) DEFAULT NULL, `Customer` varchar(10) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_People`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.people: 0 rows /*!40000 ALTER TABLE `people` DISABLE KEYS */; /*!40000 ALTER TABLE `people` ENABLE KEYS */; -- Dumping structure for table dnabank.preservation DROP TABLE IF EXISTS `preservation`; CREATE TABLE IF NOT EXISTS `preservation` ( `ID_Preservation` int(20) unsigned NOT NULL AUTO_INCREMENT, `Preservation` varchar(150) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Preservation`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.preservation: 0 rows /*!40000 ALTER TABLE `preservation` DISABLE KEYS */; /*!40000 ALTER TABLE `preservation` ENABLE KEYS */; -- Dumping structure for table dnabank.prevalentaspect DROP TABLE IF EXISTS `prevalentaspect`; CREATE TABLE IF NOT EXISTS `prevalentaspect` ( `ID_Aspect` int(10) unsigned NOT NULL AUTO_INCREMENT, `Aspect` varchar(50) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Aspect`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.prevalentaspect: 10 rows /*!40000 ALTER TABLE `prevalentaspect` DISABLE KEYS */; INSERT INTO `prevalentaspect` (`ID_Aspect`, `Aspect`, `Created_Who`, `Created_When`) VALUES (1, 'N', 'G.Droege', '2011-07-27 11:24:14'), (2, 'NE', 'G.Droege', '2011-07-27 11:24:28'), (3, 'E', 'G.Droege', '2011-07-27 11:24:34'), (4, 'SE', 'G.Droege', '2011-07-27 11:24:42'), (5, 'S', 'G.Droege', '2011-07-27 11:24:49'), (6, 'SW', 'G.Droege', '2011-07-27 11:24:57'), (7, 'W', 'G.Droege', '2011-07-27 11:25:11'), (8, 'NW', 'G.Droege', '2011-07-27 11:25:22'), (10, 'Open', 'G.Droege', '2011-07-27 11:25:27'), (11, 'Closed', 'G.Droege', '2011-07-27 11:25:34'); /*!40000 ALTER TABLE `prevalentaspect` ENABLE KEYS */; -- Dumping structure for table dnabank.primer DROP TABLE IF EXISTS `primer`; CREATE TABLE IF NOT EXISTS `primer` ( `ID_Primer` int(20) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(100) NOT NULL DEFAULT '0', `Sequence` varchar(5000) DEFAULT NULL, `ReferenceCitation` varchar(500) DEFAULT NULL, `ReferenceLink` varchar(500) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Primer`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.primer: 0 rows /*!40000 ALTER TABLE `primer` DISABLE KEYS */; /*!40000 ALTER TABLE `primer` ENABLE KEYS */; -- Dumping structure for table dnabank.provider DROP TABLE IF EXISTS `provider`; CREATE TABLE IF NOT EXISTS `provider` ( `ID_Provider` int(20) unsigned NOT NULL AUTO_INCREMENT, `Provider` varchar(500) NOT NULL, `ID_Schema` int(20) unsigned NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Provider`), KEY `ID_Schema` (`ID_Schema`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.provider: 0 rows /*!40000 ALTER TABLE `provider` DISABLE KEYS */; /*!40000 ALTER TABLE `provider` ENABLE KEYS */; -- Dumping structure for table dnabank.publications DROP TABLE IF EXISTS `publications`; CREATE TABLE IF NOT EXISTS `publications` ( `ID_Publications` int(20) unsigned NOT NULL AUTO_INCREMENT, `Editors` varchar(10) DEFAULT NULL, `Year` varchar(20) DEFAULT NULL, `Title` varchar(1000) DEFAULT NULL, `ID_Journal` int(20) unsigned DEFAULT NULL, `Volume` varchar(10) DEFAULT NULL, `Pages` varchar(20) DEFAULT NULL, `Book` varchar(100) DEFAULT NULL, `Publisher` varchar(250) DEFAULT NULL, `Link` varchar(400) DEFAULT NULL, `Paper_Cache` varchar(700) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Update_When` timestamp NULL DEFAULT NULL, `Update_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Publications`), KEY `ID_Journal` (`ID_Journal`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.publications: 0 rows /*!40000 ALTER TABLE `publications` DISABLE KEYS */; /*!40000 ALTER TABLE `publications` ENABLE KEYS */; -- Dumping structure for table dnabank.publications_amplifications DROP TABLE IF EXISTS `publications_amplifications`; CREATE TABLE IF NOT EXISTS `publications_amplifications` ( `ID_Pub_Amp` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Publications` bigint(20) unsigned NOT NULL, `ID_Amplification` bigint(20) unsigned NOT NULL, `ID_DNA` bigint(20) unsigned NOT NULL, `Paper_Cache` varchar(1000) DEFAULT NULL, `GeneticLocus` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Pub_Amp`), KEY `ID_Publications` (`ID_Publications`,`ID_Amplification`,`ID_DNA`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.publications_amplifications: 0 rows /*!40000 ALTER TABLE `publications_amplifications` DISABLE KEYS */; /*!40000 ALTER TABLE `publications_amplifications` ENABLE KEYS */; -- Dumping structure for table dnabank.publications_authors DROP TABLE IF EXISTS `publications_authors`; CREATE TABLE IF NOT EXISTS `publications_authors` ( `Order` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Publications` bigint(20) unsigned NOT NULL, `ID_Author` bigint(20) unsigned NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`Order`), KEY `ID_Publications` (`ID_Publications`,`ID_Author`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.publications_authors: 0 rows /*!40000 ALTER TABLE `publications_authors` DISABLE KEYS */; /*!40000 ALTER TABLE `publications_authors` ENABLE KEYS */; -- Dumping structure for table dnabank.purification DROP TABLE IF EXISTS `purification`; CREATE TABLE IF NOT EXISTS `purification` ( `ID_Purification` int(20) unsigned NOT NULL AUTO_INCREMENT, `Method` varchar(150) NOT NULL, `Company` varchar(150) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Purification`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.purification: 0 rows /*!40000 ALTER TABLE `purification` DISABLE KEYS */; /*!40000 ALTER TABLE `purification` ENABLE KEYS */; -- Dumping structure for table dnabank.relationdna_voucher DROP TABLE IF EXISTS `relationdna_voucher`; CREATE TABLE IF NOT EXISTS `relationdna_voucher` ( `ID_RelationDNA_Voucher` int(20) unsigned NOT NULL AUTO_INCREMENT, `RelationDNA_Voucher` varchar(250) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_RelationDNA_Voucher`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.relationdna_voucher: 6 rows /*!40000 ALTER TABLE `relationdna_voucher` DISABLE KEYS */; INSERT INTO `relationdna_voucher` (`ID_RelationDNA_Voucher`, `RelationDNA_Voucher`, `Created_When`, `Created_Who`) VALUES (1, 'DNA and voucher from same in situ individual', '2008-05-29 15:34:52', 'G.Droege'), (2, 'DNA and voucher from same in situ population', '2008-05-29 15:34:52', 'G.Droege'), (3, 'DNA and voucher from same ex situ individual', '2008-05-29 15:34:52', 'G.Droege'), (4, 'DNA and voucher from same ex situ population', '2008-05-29 15:34:52', 'G.Droege'), (5, 'DNA from cultivated plant, voucher specimen and garden accession from same in situ population', '2008-05-29 15:34:52', 'G.Droege'), (6, 'Unknown', '2009-07-17 12:30:23', 'G.Droege'); /*!40000 ALTER TABLE `relationdna_voucher` ENABLE KEYS */; -- Dumping structure for table dnabank.request DROP TABLE IF EXISTS `request`; CREATE TABLE IF NOT EXISTS `request` ( `ID_Request` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_People` bigint(20) unsigned NOT NULL, `ID_DNA` bigint(20) unsigned NOT NULL, `ID_Aliquots` bigint(20) unsigned NOT NULL, `Request_Date` datetime DEFAULT NULL, `Request_Number_Aliquots` varchar(150) DEFAULT NULL, `Request_Volume` float DEFAULT NULL, `Request_Notes` varchar(500) DEFAULT NULL, `Shipping_Date` datetime DEFAULT NULL, `PriceAndCurrency` varchar(50) DEFAULT NULL, `Agreement` varchar(10) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Request`), KEY `TableRequest_FKIndex1` (`ID_DNA`), KEY `TableRequest_FKIndex2` (`ID_People`), KEY `ID_Aliquots` (`ID_Aliquots`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.request: 0 rows /*!40000 ALTER TABLE `request` DISABLE KEYS */; /*!40000 ALTER TABLE `request` ENABLE KEYS */; -- Dumping structure for table dnabank.schemata DROP TABLE IF EXISTS `schemata`; CREATE TABLE IF NOT EXISTS `schemata` ( `ID_Schema` int(20) NOT NULL AUTO_INCREMENT, `Schemata` varchar(50) DEFAULT NULL, `QueryPart1` varchar(2000) DEFAULT NULL, `QueryPart1_1` varchar(200) DEFAULT NULL, `QueryPart1_2` varchar(2000) DEFAULT NULL, `QueryPart1_2b` varchar(2000) DEFAULT NULL, `QueryPart1b` varchar(2000) DEFAULT NULL, `QueryPart2` varchar(2000) DEFAULT NULL, `QueryPart2a` varchar(2000) DEFAULT NULL, `QueryPart3` varchar(2000) DEFAULT NULL, `QueryPart4` varchar(2000) DEFAULT NULL, `QueryPart5` varchar(2000) DEFAULT NULL, `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Schema`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.schemata: 4 rows /*!40000 ALTER TABLE `schemata` DISABLE KEYS */; INSERT INTO `schemata` (`ID_Schema`, `Schemata`, `QueryPart1`, `QueryPart1_1`, `QueryPart1_2`, `QueryPart1_2b`, `QueryPart1b`, `QueryPart2`, `QueryPart2a`, `QueryPart3`, `QueryPart4`, `QueryPart5`, `Created_When`, `Created_Who`) VALUES (1, 'ABCD 1.2', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FresponseFormat%3E%3Cfilter%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '', '', '', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F1.2%3C%2FresponseFormat%3E%3Cfilter%3E%3Cand%3E%3Cand%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '%3C%2Fequals%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', NULL, '%3C%2Flike%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceInstitutionCode%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3Cequals+path%3D%22%2FDataSets%2FDataSet%2FOriginalSource%2FSourceName%22%3E', '%3C%2Fequals%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '0000-00-00 00:00:00', ''), (2, 'ABCD 2.06', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FresponseFormat%3E%3Cfilter%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '', '', '', '&query=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%3Crequest+xmlns%3D%22http%3A%2F%2Fwww.biocase.org%2Fschemas%2Fprotocol%2F1.3%22%3E%3Cheader%3E%3Ctype%3Esearch%3C%2Ftype%3E%3C%2Fheader%3E%3Csearch%3E%3CrequestFormat%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FrequestFormat%3E%3CresponseFormat+start%3D%220%22+limit%3D%2210%22%3Ehttp%3A%2F%2Fwww.tdwg.org%2Fschemas%2Fabcd%2F2.06%3C%2FresponseFormat%3E%3Cfilter%3E%3Cand%3E%3Cand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FUnitID%22%3E', '%3C%2Flike%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', NULL, '%3C%2Flike%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceInstitutionID%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3Clike+path%3D%22%2FDataSets%2FDataSet%2FUnits%2FUnit%2FSourceID%22%3E', '%3C%2Flike%3E%3C%2Fand%3E%3C%2Ffilter%3E%3Ccount%3Efalse%3C%2Fcount%3E%3C%2Fsearch%3E%3C%2Frequest%3E', '0000-00-00 00:00:00', ''), (3, 'DWC (digir, CatalogNumber)', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A+%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%22%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cor%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cand%3E+%3Cand%3E+%3Cequals%3E+%3Cdarwin%3A', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumber%3E', '%3C%2Fdarwin%3ACatalogNumber%3E+%3C%2Fequals%3E+%3C%2For%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3AInstitutionCode%3E', '%3C%2Fdarwin%3AInstitutionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E+%3Cequals%3E+%3Cdarwin%3ACollectionCode%3E', '%3C%2Fdarwin%3ACollectionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '0000-00-00 00:00:00', ''), (6, 'DWC (digir, CatalogNumberText)', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%22%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '%3C%2Fdestination%3E%0A%09%09%3Ctype%3Esearch%3C%2Ftype%3E%0A%09%09%3C%2Fheader%3E%0A%09%09%3Csearch%3E%0A%09%09%3Cfilter%3E%3Cand%3E+%3Cand%3E+%3Cequals%3E+%3Cdarwin%3ACatalogNumberText%3E', '?request=%3C%3Fxml+version%3D%221.0%22+encoding%3D%22UTF-8%22%3F%3E%0A%09%09%3Crequest+xmlns%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Axsd%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%27%0A%09xmlns%3Axsi%3D%27http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%27%0A%09xmlns%3Adigir%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0%27%0A%09xmlns%3Adarwin%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xmlns%3Adwc%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%27%0A%09xsi%3AschemaLocation%3D%27http%3A%2F%2Fdigir.net%2Fschema%2Fprotocol%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fprotocol%2F2003%2F1.0%2Fdigir.xsd+http%3A%2F%2Fdigir.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0+http%3A%2F%2Fdigir.sourceforge.net%2Fschema%2Fconceptual%2Fdarwin%2F2003%2F1.0%2Fdarwin2.xsd%27%3E%0A+%0A++++++++%0A%09%09%3Cheader%3E%0A%09%09%3Cversion%3E1.0.0%3C%2Fversion%3E%0A%09%09%3CsendTime%3E2009-11-13+14%3A40%3A56.000%3C%2FsendTime%3E%0A%09%09%3Csource%2F%3E%0A%09%09%3Cdestination+resource%3D%22', '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', NULL, '%3C%2Fdarwin%3ACatalogNumberText%3E+%3C%2Fequals%3E+%3Cequals%3E+%3Cdarwin%3AInstitutionCode%3E', '%3C%2Fdarwin%3AInstitutionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E+%3Cequals%3E+%3Cdarwin%3ACollectionCode%3E', '%3C%2Fdarwin%3ACollectionCode%3E+%3C%2Fequals%3E+%3C%2Fand%3E%3C%2Ffilter%3E%0A%09%09%3Crecords++start%3D%220%22+limit%3D%2210%22%3E%0A%09%09%3Cstructure+schemaLocation%3D%22http%3A%2F%2Fsearch.biocase.org%2Feurope%2Fstatic%2FdarwinObis.xsd%22%2F%3E%0A%09%09%3C%2Frecords%3E%0A%09%09%3Ccount%3Efalse%3C%2Fcount%3E%0A%09%09%3C%2Fsearch%3E%0A%09%09%3C%2Frequest%3E', '2009-04-23 16:02:37', ''); /*!40000 ALTER TABLE `schemata` ENABLE KEYS */; -- Dumping structure for table dnabank.seasandoceans DROP TABLE IF EXISTS `seasandoceans`; CREATE TABLE IF NOT EXISTS `seasandoceans` ( `ID_SeasAndOceans` int(20) unsigned NOT NULL AUTO_INCREMENT, `SeasAndOceans` varchar(255) NOT NULL, `Ocean` varchar(255) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_SeasAndOceans`) ) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.seasandoceans: 125 rows /*!40000 ALTER TABLE `seasandoceans` DISABLE KEYS */; INSERT INTO `seasandoceans` (`ID_SeasAndOceans`, `SeasAndOceans`, `Ocean`, `Created_Who`, `Created_When`) VALUES (1, 'Adriatic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (2, 'Aegean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (3, 'Alboran Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (4, 'Argentine Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (5, 'Bay of Bothnia', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (6, 'Bay of Fundy', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (7, 'Baltic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (8, 'Black Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (9, 'Bothnian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (10, 'Caribbean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (11, 'Celtic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (12, 'Central Baltic Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (13, 'Chesapeake Bay', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (14, 'English Channel', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (15, 'Gulf of Bothnia', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (16, 'Gulf of Guinea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (17, 'Gulf of Finland', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (18, 'Gulf of Mexico', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (19, 'Gulf of Sidra', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (20, 'Gulf of St. Lawrence', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (21, 'Gulf of Venezuela', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (22, 'Ionian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (23, 'Irish Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (24, 'Marmara Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (25, 'Mediterranean Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (26, 'Mirtoon Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (27, 'North Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (28, 'Sea of Azov', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (29, 'Sea of Crete', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (30, 'Sea of the Hebrides', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (31, 'Sargasso Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (32, 'Thracian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (33, 'Tyrrhenian Sea', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (34, 'Amundsen Gulf', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (35, 'Baffin Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (36, 'Barents Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (37, 'Beaufort Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (39, 'Cambridge Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (40, 'Chukchi Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (41, 'Cold Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (42, 'Davis Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (43, 'Denmark Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (44, 'East Siberian Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (45, 'Greenland Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (46, 'Hudson Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (47, 'James Bay', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (48, 'Kara Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (49, 'Kara Strait', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (50, 'Labrador Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (51, 'Laptev Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (52, 'Lincoln Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (53, 'Norwegian Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (54, 'White Sea', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (56, 'Andaman Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (57, 'Arabian Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (58, 'Bay of Bengal', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (59, 'Gulf of Aden', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (60, 'Gulf of Oman', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (61, 'Mozambique Channel', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (62, 'Persian Gulf', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (63, 'Red Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (64, 'Timor Sea', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (65, 'Arafura Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (66, 'Banda Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (67, 'Bering Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (68, 'Bismarck Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (70, 'Bohol Sea (Mindanao Sea)', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (71, 'Camotes Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (72, 'Celebes Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (73, 'Ceram Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (74, 'Chilean Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (75, 'Coral Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (76, 'East China Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (77, 'Flores Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (78, 'Gulf of Alaska', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (79, 'Gulf of California (Sea of Cortés)', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (80, 'Gulf of Carpentaria', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (81, 'Gulf of Thailand', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (82, 'Halmahera Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (83, 'Java Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (84, 'Molucca Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (85, 'Philippine Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (86, 'Savu Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (87, 'Sea of Japan', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (88, 'Sea of Okhotsk', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (89, 'Seto Inland Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (90, 'Solomon Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (91, 'South China Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (92, 'Sulu Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (93, 'Tasman Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (95, 'Yellow Sea', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (96, 'Amundsen Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (97, 'Bass Strait', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (98, 'Bellingshausen Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (99, 'Davis Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (100, 'Great Australian Bight', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (101, 'Gulf Saint Vincent', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (102, 'Ross Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (103, 'Scotia Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (104, 'Spencer Gulf', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (105, 'Weddell Sea', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (106, 'Aral Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (107, 'Caspian Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (108, 'Dead Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (109, 'Sea of Galilee', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (110, 'Salton Sea', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (111, 'Great Salt Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (112, 'Unknown or unspecified Atlantic Ocean', 'Atlantic Ocean', 'unknown', '0000-00-00 00:00:00'), (113, 'Unknown or unspecified Artic Ocean', 'Arctic Ocean', 'unknown', '0000-00-00 00:00:00'), (114, 'Unknown or unspecified Indian Ocean', 'Indian Ocean', 'unknown', '0000-00-00 00:00:00'), (115, 'Unknown or unspecified Pacific Ocean', 'Pacific Ocean', 'unknown', '0000-00-00 00:00:00'), (116, 'Unknown or unspecified Southern Ocean', 'Southern Ocean', 'unknown', '0000-00-00 00:00:00'), (117, 'Unknown or unspecified Ocean', 'Unknown', 'unknown', '0000-00-00 00:00:00'), (118, 'Chott Melrhir', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (119, 'Great Lakes', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (120, 'Issyk Kul', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (121, 'Lake Balkhash', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (122, 'Lake Chad', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (123, 'Lake Chilwa', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (124, 'Lake Turkana', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (125, 'Lake Van', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (126, 'Namtso', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (127, 'Pyramid Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (128, 'Qinghai Lake', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'), (129, 'Tonle Sap', 'Landlocked Sea', 'unknown', '0000-00-00 00:00:00'); /*!40000 ALTER TABLE `seasandoceans` ENABLE KEYS */; -- Dumping structure for table dnabank.sequencing DROP TABLE IF EXISTS `sequencing`; CREATE TABLE IF NOT EXISTS `sequencing` ( `ID_Sequencing` int(10) unsigned NOT NULL AUTO_INCREMENT, `ID_Amplification` int(10) unsigned NOT NULL, `CloningDate` datetime DEFAULT NULL, `ID_CloningStaff` int(10) unsigned DEFAULT NULL, `ID_CloningMethod` int(10) unsigned DEFAULT NULL, `CloneStrain` varchar(50) DEFAULT NULL, `ConsensusSequence` varchar(1000) DEFAULT NULL, `ConsensusSequenceLength` varchar(10) DEFAULT NULL, `ConsensusSequenceChromatogram` varchar(500) DEFAULT NULL, `BarcodeSequence` varchar(1000) DEFAULT NULL, `GenBankNumber` varchar(50) DEFAULT NULL, `GenBankNumber-URI` varchar(500) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Sequencing`), KEY `ID_Amplification` (`ID_Amplification`), KEY `ID_CloningStaff` (`ID_CloningStaff`), KEY `ID_CloningMethod` (`ID_CloningMethod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sequencing: 0 rows /*!40000 ALTER TABLE `sequencing` DISABLE KEYS */; /*!40000 ALTER TABLE `sequencing` ENABLE KEYS */; -- Dumping structure for table dnabank.sequencingmethod DROP TABLE IF EXISTS `sequencingmethod`; CREATE TABLE IF NOT EXISTS `sequencingmethod` ( `ID_SequencingMethod` int(10) unsigned NOT NULL AUTO_INCREMENT, `SequencingMethod` varchar(50) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_SequencingMethod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sequencingmethod: 0 rows /*!40000 ALTER TABLE `sequencingmethod` DISABLE KEYS */; /*!40000 ALTER TABLE `sequencingmethod` ENABLE KEYS */; -- Dumping structure for table dnabank.sex DROP TABLE IF EXISTS `sex`; CREATE TABLE IF NOT EXISTS `sex` ( `ID_Sex` int(20) unsigned NOT NULL AUTO_INCREMENT, `Sex` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Sex`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sex: 4 rows /*!40000 ALTER TABLE `sex` DISABLE KEYS */; INSERT INTO `sex` (`ID_Sex`, `Sex`, `Created_When`, `Created_Who`) VALUES (1, 'female', '2009-02-10 17:45:28', ''), (2, 'male', '2009-02-10 17:45:28', ''), (3, 'hermaphrodite', '2009-02-10 17:45:28', ''), (4, 'unknown', '2009-02-10 17:45:28', ''); /*!40000 ALTER TABLE `sex` ENABLE KEYS */; -- Dumping structure for table dnabank.singlesequencing DROP TABLE IF EXISTS `singlesequencing`; CREATE TABLE IF NOT EXISTS `singlesequencing` ( `ID_SingleSequencing` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Sequencing` bigint(20) unsigned NOT NULL, `ID_Amplification` bigint(20) unsigned NOT NULL, `SequencingDate` datetime DEFAULT NULL, `ID_SequencingStaff` bigint(20) unsigned DEFAULT NULL, `ID_SequencingMethod` bigint(20) unsigned DEFAULT NULL, `SingleSequence` varchar(1000) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_SingleSequencing`), KEY `ID_Sequencing` (`ID_Sequencing`), KEY `ID_Amplification` (`ID_Amplification`), KEY `ID_SequencingStaff` (`ID_SequencingStaff`), KEY `ID_SequencingMethod` (`ID_SequencingMethod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.singlesequencing: 0 rows /*!40000 ALTER TABLE `singlesequencing` DISABLE KEYS */; /*!40000 ALTER TABLE `singlesequencing` ENABLE KEYS */; -- Dumping structure for table dnabank.singlesequencingchromatograms DROP TABLE IF EXISTS `singlesequencingchromatograms`; CREATE TABLE IF NOT EXISTS `singlesequencingchromatograms` ( `ID_Chromatograms` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_SingleSequencing` bigint(20) unsigned NOT NULL, `ID_Sequencing` bigint(20) unsigned NOT NULL, `ID_Amplification` bigint(20) unsigned NOT NULL, `FileURI` varchar(500) DEFAULT NULL, `Remarks` varchar(500) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Chromatograms`), KEY `ID_SingleSequencing` (`ID_SingleSequencing`), KEY `ID_Sequencing` (`ID_Sequencing`), KEY `ID_Amplification` (`ID_Amplification`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.singlesequencingchromatograms: 0 rows /*!40000 ALTER TABLE `singlesequencingchromatograms` DISABLE KEYS */; /*!40000 ALTER TABLE `singlesequencingchromatograms` ENABLE KEYS */; -- Dumping structure for table dnabank.singlesequencing_primers DROP TABLE IF EXISTS `singlesequencing_primers`; CREATE TABLE IF NOT EXISTS `singlesequencing_primers` ( `ID_SingleSequencing` bigint(20) unsigned NOT NULL, `ID_Primer` bigint(20) unsigned NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, KEY `ID_SingleSequencing` (`ID_SingleSequencing`), KEY `ID_Primer` (`ID_Primer`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.singlesequencing_primers: 0 rows /*!40000 ALTER TABLE `singlesequencing_primers` DISABLE KEYS */; /*!40000 ALTER TABLE `singlesequencing_primers` ENABLE KEYS */; -- Dumping structure for table dnabank.slope DROP TABLE IF EXISTS `slope`; CREATE TABLE IF NOT EXISTS `slope` ( `ID_Slope` int(10) unsigned NOT NULL AUTO_INCREMENT, `Slope` varchar(50) NOT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Slope`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.slope: 5 rows /*!40000 ALTER TABLE `slope` DISABLE KEYS */; INSERT INTO `slope` (`ID_Slope`, `Slope`, `Created_Who`, `Created_When`) VALUES (1, 'Level 0-5 %', 'G.Droege', '2011-07-27 11:21:43'), (2, 'Undulating 6-10 %', 'G.Droege', '2011-07-27 11:22:02'), (3, 'Rolling 11-20 %', 'G.Droege', '2011-07-27 11:22:16'), (4, 'Moderate 21-30%', 'G.Droege', '2011-07-27 11:22:30'), (5, 'Steep > 30 %', 'G.Droege', '2011-07-27 11:22:50'); /*!40000 ALTER TABLE `slope` ENABLE KEYS */; -- Dumping structure for table dnabank.soilph DROP TABLE IF EXISTS `soilph`; CREATE TABLE IF NOT EXISTS `soilph` ( `ID_SoilpH` int(10) unsigned NOT NULL AUTO_INCREMENT, `SoilpH` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_SoilpH`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.soilph: 3 rows /*!40000 ALTER TABLE `soilph` DISABLE KEYS */; INSERT INTO `soilph` (`ID_SoilpH`, `SoilpH`, `Created_Who`, `Created_When`) VALUES (1, 'Acidic', 'G.Droege', '2011-08-31 17:07:58'), (2, 'Alkaline', 'G.Droege', '2011-08-31 17:08:03'), (3, 'Neutral', 'G.Droege', '2011-08-31 17:08:08'); /*!40000 ALTER TABLE `soilph` ENABLE KEYS */; -- Dumping structure for table dnabank.soiltexture DROP TABLE IF EXISTS `soiltexture`; CREATE TABLE IF NOT EXISTS `soiltexture` ( `ID_SoilTexture` int(10) unsigned NOT NULL AUTO_INCREMENT, `SoilTexture` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_SoilTexture`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.soiltexture: 8 rows /*!40000 ALTER TABLE `soiltexture` DISABLE KEYS */; INSERT INTO `soiltexture` (`ID_SoilTexture`, `SoilTexture`, `Created_Who`, `Created_When`) VALUES (1, 'Gravel', 'G.Droege', '2011-08-31 17:06:42'), (2, 'Sand', 'G.Droege', '2011-08-31 17:06:47'), (3, 'Sandy loam', 'G.Droege', '2011-08-31 17:06:53'), (4, 'Loam', 'G.Droege', '2011-08-31 17:06:57'), (5, 'Clay loam', 'G.Droege', '2011-08-31 17:07:04'), (6, 'Clay', 'G.Droege', '2011-08-31 17:07:10'), (7, 'Peat', 'G.Droege', '2011-08-31 17:07:17'), (8, 'No soil', 'G.Droege', '2011-08-31 17:07:22'); /*!40000 ALTER TABLE `soiltexture` ENABLE KEYS */; -- Dumping structure for table dnabank.specimentype DROP TABLE IF EXISTS `specimentype`; CREATE TABLE IF NOT EXISTS `specimentype` ( `ID_SpecimenType` int(20) unsigned NOT NULL AUTO_INCREMENT, `SpecimenType` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_SpecimenType`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.specimentype: 18 rows /*!40000 ALTER TABLE `specimentype` DISABLE KEYS */; INSERT INTO `specimentype` (`ID_SpecimenType`, `SpecimenType`, `Created_When`, `Created_Who`) VALUES (1, 'epitype', '0000-00-00 00:00:00', 'unknown'), (2, 'holotype', '0000-00-00 00:00:00', 'unknown'), (3, 'isotype', '0000-00-00 00:00:00', 'unknown'), (4, 'isoepitype', '0000-00-00 00:00:00', 'unknown'), (5, 'isolectotype', '0000-00-00 00:00:00', 'unknown'), (6, 'isoneotype', '0000-00-00 00:00:00', 'unknown'), (7, 'isoparatype', '0000-00-00 00:00:00', 'unknown'), (8, 'isoparalectotype', '0000-00-00 00:00:00', 'unknown'), (9, 'isosyntype', '0000-00-00 00:00:00', 'unknown'), (10, 'kleptotype', '0000-00-00 00:00:00', 'unknown'), (11, 'lectotype', '0000-00-00 00:00:00', 'unknown'), (12, 'neotype', '0000-00-00 00:00:00', 'unknown'), (13, 'original material', '0000-00-00 00:00:00', 'unknown'), (14, 'paratype', '0000-00-00 00:00:00', 'unknown'), (15, 'paralectotype', '0000-00-00 00:00:00', 'unknown'), (16, 'syntype', '0000-00-00 00:00:00', 'unknown'), (17, 'topotype', '0000-00-00 00:00:00', 'unknown'), (18, 'type', '0000-00-00 00:00:00', 'unknown'); /*!40000 ALTER TABLE `specimentype` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolassociatedunits DROP TABLE IF EXISTS `sptoolassociatedunits`; CREATE TABLE IF NOT EXISTS `sptoolassociatedunits` ( `ID_Association` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) unsigned NOT NULL, `UnitID_Main` varchar(100) DEFAULT NULL, `CollectionCode_Main` varchar(100) DEFAULT NULL, `InstitutionCode_Main` varchar(100) DEFAULT NULL, `RelationToMainUnit` varchar(100) DEFAULT NULL, `UnitID` varchar(100) DEFAULT NULL, `CollectionCode` varchar(100) DEFAULT NULL, `InstitutionCode` varchar(100) DEFAULT NULL, `KindOfUnit` varchar(100) DEFAULT NULL, `FormerCollection` varchar(100) DEFAULT NULL, `ID_BasisOfRecord` bigint(20) unsigned DEFAULT NULL, `ID_Dataset` bigint(20) unsigned DEFAULT NULL, `Notes` varchar(200) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(100) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(100) DEFAULT NULL, PRIMARY KEY (`ID_Association`), KEY `ID_Collection` (`ID_Collection`), KEY `ID_BasisOfRecord` (`ID_BasisOfRecord`), KEY `ID_Dataset` (`ID_Dataset`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptoolassociatedunits: 0 rows /*!40000 ALTER TABLE `sptoolassociatedunits` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolassociatedunits` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolcollection DROP TABLE IF EXISTS `sptoolcollection`; CREATE TABLE IF NOT EXISTS `sptoolcollection` ( `ID_Collection` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `UnitID_Specimen` varchar(100) NOT NULL, `CollectionCode_Specimen` varchar(100) NOT NULL, `InstitutionCode_Specimen` varchar(100) NOT NULL, `FormerCollection` varchar(100) DEFAULT NULL, `ID_BiogeographicRegion` bigint(20) unsigned DEFAULT NULL, `ID_Country` bigint(20) unsigned DEFAULT NULL, `ID_SeasAndOceans` bigint(20) unsigned DEFAULT NULL, `Collectors` varchar(500) DEFAULT NULL, `CollectionDateMin` datetime DEFAULT NULL, `CollectionDateMax` datetime DEFAULT NULL, `CollectionYear` varchar(50) DEFAULT NULL, `CollectorsNo` varchar(100) DEFAULT NULL, `CollectionNotes` varchar(400) DEFAULT NULL, `CollectionMethod` varchar(400) DEFAULT NULL, `Locality_ID` varchar(150) DEFAULT NULL, `ExpeditionDetails` varchar(300) DEFAULT NULL, `Region` varchar(500) DEFAULT NULL, `Locality` varchar(500) DEFAULT NULL, `Habitat` varchar(100) DEFAULT NULL, `ID_SoilTexture` bigint(20) unsigned DEFAULT NULL, `ID_SoilpH` bigint(20) unsigned DEFAULT NULL, `ID_HabitatCode` bigint(20) unsigned DEFAULT NULL, `ID_LandUseCode` bigint(20) unsigned DEFAULT NULL, `ID_Slope` bigint(20) unsigned DEFAULT NULL, `ID_Aspect` bigint(20) unsigned DEFAULT NULL, `DepthAccuracyStatement` varchar(50) DEFAULT NULL, `DepthMin` varchar(50) DEFAULT NULL, `DepthMax` varchar(50) DEFAULT NULL, `DepthUnit` varchar(50) DEFAULT NULL, `DepthMethod` varchar(50) DEFAULT NULL, `DepthRaw` varchar(50) DEFAULT NULL, `AltitudeAccuracyStatement` varchar(50) DEFAULT NULL, `AltitudeMin` varchar(50) DEFAULT NULL, `AltitudeMax` varchar(50) DEFAULT NULL, `AltitudeUnit` varchar(50) DEFAULT NULL, `AltitudeMethod` varchar(50) DEFAULT NULL, `AltitudeRaw` varchar(50) DEFAULT NULL, `CoordinatesAccuracyStatement` varchar(50) DEFAULT NULL, `CoordinatesErrorDistance` varchar(50) DEFAULT NULL, `LongitudeMin` varchar(50) DEFAULT NULL, `LongitudeMax` varchar(50) DEFAULT NULL, `LatitudeMin` varchar(50) DEFAULT NULL, `LatitudeMax` varchar(50) DEFAULT NULL, `LongitudeRaw` varchar(50) DEFAULT NULL, `LatitudeRaw` varchar(50) DEFAULT NULL, `GeodeticDatum` varchar(50) DEFAULT NULL, `ID_GeocodeMethod` bigint(20) unsigned DEFAULT NULL, `ID_Sex` bigint(20) unsigned DEFAULT NULL, `Protected` varchar(20) NOT NULL DEFAULT 'No', `Permission` varchar(20) NOT NULL DEFAULT 'NotRequired', `Blocked` varchar(20) NOT NULL DEFAULT 'No', `ID_BasisOfRecord` bigint(20) unsigned DEFAULT NULL, `KindOfUnit` varchar(150) DEFAULT NULL, `ID_Cache` bigint(20) unsigned DEFAULT NULL, `ID_Type` bigint(20) unsigned DEFAULT NULL, `Notes` varchar(400) DEFAULT NULL, `AccessionNo` varchar(50) DEFAULT NULL, `AccessionName` varchar(100) DEFAULT NULL, `LifeStage` varchar(50) DEFAULT NULL, `LifeForm` varchar(50) DEFAULT NULL, `PrepType` varchar(50) DEFAULT NULL, `PrepDate` varchar(50) DEFAULT NULL, `PrepStaff` varchar(50) DEFAULT NULL, `SampleGroup` varchar(15) DEFAULT NULL, `GUID` varchar(50) DEFAULT NULL, `Multimedia` varchar(10) DEFAULT NULL, `VoucherRefText` varchar(1000) DEFAULT NULL, `VoucherRefUrl` varchar(1000) DEFAULT NULL, `VoucherRefDoi` varchar(200) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, `Lock_Who` varchar(50) DEFAULT NULL, `Lock_When` timestamp NULL DEFAULT NULL, PRIMARY KEY (`ID_Collection`), KEY `ID_Sex` (`ID_Sex`), KEY `ID_BasisOfRecord` (`ID_BasisOfRecord`), KEY `ID_Cache` (`ID_Cache`), KEY `ID_Type` (`ID_Type`), KEY `ID_Country` (`ID_Country`), KEY `ID_SeasAndOceans` (`ID_SeasAndOceans`), KEY `UnitID_Specimen` (`UnitID_Specimen`), KEY `ID_BiogeographicRegion` (`ID_BiogeographicRegion`), KEY `ID_SoilTexture` (`ID_SoilTexture`), KEY `ID_SoilpH` (`ID_SoilpH`), KEY `ID_HabitatCode` (`ID_HabitatCode`), KEY `ID_LandUseCode` (`ID_LandUseCode`), KEY `ID_Slope` (`ID_Slope`), KEY `ID_Aspect` (`ID_Aspect`), KEY `ID_GeocodeMethod` (`ID_GeocodeMethod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptoolcollection: 0 rows /*!40000 ALTER TABLE `sptoolcollection` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolcollection` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolecology DROP TABLE IF EXISTS `sptoolecology`; CREATE TABLE IF NOT EXISTS `sptoolecology` ( `ID_Ecology` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) unsigned NOT NULL, `Value` varchar(20) DEFAULT NULL, `Unit` varchar(50) DEFAULT NULL, `Parameter` varchar(50) DEFAULT NULL, `Method` varchar(200) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Ecology`), KEY `ID_Collection` (`ID_Collection`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptoolecology: 0 rows /*!40000 ALTER TABLE `sptoolecology` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolecology` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolhighertaxon DROP TABLE IF EXISTS `sptoolhighertaxon`; CREATE TABLE IF NOT EXISTS `sptoolhighertaxon` ( `ID_HigherTaxon` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Taxa` bigint(20) unsigned NOT NULL, `HigherTaxon` varchar(255) DEFAULT NULL, `TaxonRank` varchar(255) DEFAULT NULL, `Synecology` varchar(255) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_HigherTaxon`), KEY `ID_Taxa` (`ID_Taxa`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptoolhighertaxon: 0 rows /*!40000 ALTER TABLE `sptoolhighertaxon` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolhighertaxon` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolmeasurementorfact DROP TABLE IF EXISTS `sptoolmeasurementorfact`; CREATE TABLE IF NOT EXISTS `sptoolmeasurementorfact` ( `ID_Ecology` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) unsigned DEFAULT NULL, `Value` varchar(20) DEFAULT NULL, `Unit` varchar(50) DEFAULT NULL, `Parameter` varchar(50) DEFAULT NULL, `Method` varchar(200) DEFAULT NULL, `Rank` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Ecology`), KEY `ID_Collection` (`ID_Collection`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- Dumping data for table dnabank.sptoolmeasurementorfact: 0 rows /*!40000 ALTER TABLE `sptoolmeasurementorfact` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolmeasurementorfact` ENABLE KEYS */; -- Dumping structure for table dnabank.sptoolmultimedia DROP TABLE IF EXISTS `sptoolmultimedia`; CREATE TABLE IF NOT EXISTS `sptoolmultimedia` ( `ID_Multimedia` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) unsigned NOT NULL, `File_Path` varchar(500) NOT NULL, `File_Type` varchar(20) NOT NULL, `File_Created_When` datetime NOT NULL, `File_Created_Who` datetime NOT NULL, `File_Context` varchar(500) NOT NULL, `File_Comment` varchar(500) NOT NULL, `File_Group` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_Multimedia`), KEY `ID_OfflineGathering` (`ID_Collection`), KEY `File_Group` (`File_Group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptoolmultimedia: 0 rows /*!40000 ALTER TABLE `sptoolmultimedia` DISABLE KEYS */; /*!40000 ALTER TABLE `sptoolmultimedia` ENABLE KEYS */; -- Dumping structure for table dnabank.sptooltaxa DROP TABLE IF EXISTS `sptooltaxa`; CREATE TABLE IF NOT EXISTS `sptooltaxa` ( `ID_TaxonIdentified` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) unsigned NOT NULL, `Genus` varchar(255) DEFAULT NULL, `Subgenus` varchar(255) DEFAULT NULL, `SpecificEpithet` varchar(255) DEFAULT NULL, `InfraspecificEpithet` varchar(255) DEFAULT NULL, `Rank` varchar(50) DEFAULT NULL, `AuthorParenth` varchar(100) DEFAULT NULL, `YearParenth` varchar(50) DEFAULT NULL, `Author` varchar(100) DEFAULT NULL, `Year` varchar(50) DEFAULT NULL, `NameAuthorYear` varchar(500) DEFAULT NULL, `KindOfIdentification` varchar(20) DEFAULT NULL, `Identifier` varchar(100) DEFAULT NULL, `IdentificationDate` varchar(50) DEFAULT NULL, `PreferredFlag` varchar(50) DEFAULT NULL, `IdentificationNotes` varchar(500) DEFAULT NULL, `Synecology` varchar(50) DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Updated_When` timestamp NULL DEFAULT NULL, `Updated_Who` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID_TaxonIdentified`), KEY `ID_Gathering` (`ID_Collection`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.sptooltaxa: 0 rows /*!40000 ALTER TABLE `sptooltaxa` DISABLE KEYS */; /*!40000 ALTER TABLE `sptooltaxa` ENABLE KEYS */; -- Dumping structure for table dnabank.stock_box DROP TABLE IF EXISTS `stock_box`; CREATE TABLE IF NOT EXISTS `stock_box` ( `ID_Stock_Box` int(20) unsigned NOT NULL AUTO_INCREMENT, `Stock_Box` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Stock_Box`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.stock_box: 0 rows /*!40000 ALTER TABLE `stock_box` DISABLE KEYS */; /*!40000 ALTER TABLE `stock_box` ENABLE KEYS */; -- Dumping structure for table dnabank.stock_fridge DROP TABLE IF EXISTS `stock_fridge`; CREATE TABLE IF NOT EXISTS `stock_fridge` ( `ID_Stock_Fridge` int(20) unsigned NOT NULL AUTO_INCREMENT, `Stock_Fridge` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Stock_Fridge`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.stock_fridge: 0 rows /*!40000 ALTER TABLE `stock_fridge` DISABLE KEYS */; /*!40000 ALTER TABLE `stock_fridge` ENABLE KEYS */; -- Dumping structure for table dnabank.stock_rack DROP TABLE IF EXISTS `stock_rack`; CREATE TABLE IF NOT EXISTS `stock_rack` ( `ID_Stock_Rack` int(20) NOT NULL AUTO_INCREMENT, `Stock_Rack` varchar(50) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Stock_Rack`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.stock_rack: 0 rows /*!40000 ALTER TABLE `stock_rack` DISABLE KEYS */; /*!40000 ALTER TABLE `stock_rack` ENABLE KEYS */; -- Dumping structure for table dnabank.tissue DROP TABLE IF EXISTS `tissue`; CREATE TABLE IF NOT EXISTS `tissue` ( `ID_Tissue` int(20) unsigned NOT NULL AUTO_INCREMENT, `Tissue` varchar(255) NOT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', PRIMARY KEY (`ID_Tissue`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.tissue: 0 rows /*!40000 ALTER TABLE `tissue` DISABLE KEYS */; /*!40000 ALTER TABLE `tissue` ENABLE KEYS */; -- Dumping structure for table dnabank.user DROP TABLE IF EXISTS `user`; CREATE TABLE IF NOT EXISTS `user` ( `ID_User` int(20) unsigned NOT NULL AUTO_INCREMENT, `Login` varchar(50) NOT NULL, `Password` varchar(50) NOT NULL, `Signature` varchar(50) NOT NULL, `Email` varchar(100) NOT NULL, `ID_Group` tinyint(4) unsigned DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_User`), UNIQUE KEY `user_login` (`Login`), KEY `ID_Group` (`ID_Group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.user: 0 rows /*!40000 ALTER TABLE `user` DISABLE KEYS */; /*!40000 ALTER TABLE `user` ENABLE KEYS */; -- Dumping structure for table dnabank.usergroups DROP TABLE IF EXISTS `usergroups`; CREATE TABLE IF NOT EXISTS `usergroups` ( `ID_Group` int(20) unsigned NOT NULL AUTO_INCREMENT, `Group` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Group`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.usergroups: 4 rows /*!40000 ALTER TABLE `usergroups` DISABLE KEYS */; INSERT INTO `usergroups` (`ID_Group`, `Group`, `Created_Who`, `Created_When`) VALUES (1, 'Administrator', 'unknown', '0000-00-00 00:00:00'), (2, 'DNA Bank Management', 'unknown', '0000-00-00 00:00:00'), (3, 'Project', 'unknown', '0000-00-00 00:00:00'), (4, 'Guest', 'unknown', '0000-00-00 00:00:00'); /*!40000 ALTER TABLE `usergroups` ENABLE KEYS */; -- Dumping structure for table dnabank.usersettings DROP TABLE IF EXISTS `usersettings`; CREATE TABLE IF NOT EXISTS `usersettings` ( `ID_Setting` int(20) unsigned NOT NULL AUTO_INCREMENT, `ID_User` int(20) unsigned NOT NULL, `RecordsPerPage` float DEFAULT NULL, `Sorting` varchar(50) DEFAULT NULL, `RecordsPerPageSP` float DEFAULT NULL, `SortingSP` varchar(50) DEFAULT NULL, `Created_Who` varchar(50) NOT NULL DEFAULT 'unknown', `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID_Setting`), KEY `ID_User` (`ID_User`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- Dumping data for table dnabank.usersettings: 0 rows /*!40000 ALTER TABLE `usersettings` DISABLE KEYS */; /*!40000 ALTER TABLE `usersettings` ENABLE KEYS */; -- Dumping structure for view dnabank.wrapper_view_amplifications DROP VIEW IF EXISTS `wrapper_view_amplifications`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_amplifications` ( `ID_DNA` INT(20) UNSIGNED NOT NULL, `ID_Amplification` INT(20) UNSIGNED NOT NULL DEFAULT '0', `GeneticLocus` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GenBankNumber` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GenBankLink` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Amplification_Date` DATETIME NULL DEFAULT NULL, `Amplification_Success` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Amplification_Staff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_biotope DROP VIEW IF EXISTS `wrapper_view_biotope`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_biotope` ( `ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `Value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Parameter` VARCHAR(13) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_dna DROP VIEW IF EXISTS `wrapper_view_dna`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_dna` ( `ID_DNA` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `ID_Cache` INT(20) UNSIGNED NULL DEFAULT '0', `DNA_Bank_Number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `RelationDNA_Voucher` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Tissue` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Preservation` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Provided_By` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Extraction_Date` DATETIME NULL DEFAULT NULL, `Extraction_Staff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Extraction_Method` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Extraction_Company` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Purification_Method` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Purification_Company` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Absorbance280` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Absorbance230` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Concentration` VARCHAR(5) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Quality` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Quality_Check_Date` DATETIME NULL DEFAULT NULL, `Block_Until` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Notes` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_ecology DROP VIEW IF EXISTS `wrapper_view_ecology`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_ecology` ( `ID_Collection` BIGINT(20) UNSIGNED NULL DEFAULT NULL, `Value` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Unit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Parameter` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Method` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_multimedia_site DROP VIEW IF EXISTS `wrapper_view_multimedia_site`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_multimedia_site` ( `ID_Multimedia` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `ID_Collection` BIGINT(20) UNSIGNED NOT NULL, `Path` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci', `Type` VARCHAR(20) NOT NULL COLLATE 'utf8_general_ci', `Created_When` DATETIME NOT NULL, `Created_Who` DATETIME NOT NULL, `Context` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci', `Comment` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_multimedia_specimens DROP VIEW IF EXISTS `wrapper_view_multimedia_specimens`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_multimedia_specimens` ( `ID_Multimedia` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `ID_Collection` BIGINT(20) UNSIGNED NOT NULL, `Path` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci', `Type` VARCHAR(20) NOT NULL COLLATE 'utf8_general_ci', `Created_When` DATETIME NOT NULL, `Created_Who` DATETIME NOT NULL, `Context` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci', `Comment` VARCHAR(500) NOT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_namedareas DROP VIEW IF EXISTS `wrapper_view_namedareas`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_namedareas` ( `ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `AreaName` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `Value` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_phases DROP VIEW IF EXISTS `wrapper_view_phases`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_phases` ( `ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `Phase` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_providers DROP VIEW IF EXISTS `wrapper_view_providers`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_providers` ( `ID_Dataset` INT(20) UNSIGNED NOT NULL DEFAULT '0', `Digir_Resource` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Digir_Source` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Provider` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Schemata` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_publications_dna DROP VIEW IF EXISTS `wrapper_view_publications_dna`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_publications_dna` ( `ID_Pub_Amp` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `ID_Amplification` BIGINT(20) UNSIGNED NOT NULL, `Paper_Cache` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Link` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GeneticLocus` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for view dnabank.wrapper_view_specimens DROP VIEW IF EXISTS `wrapper_view_specimens`; -- Creating temporary table to overcome VIEW dependency errors CREATE TABLE `wrapper_view_specimens` ( `ID_Collection` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `UnitID_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci', `CollectionCode_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci', `InstitutionCode_Specimen` VARCHAR(100) NOT NULL COLLATE 'utf8_general_ci', `ContinentOrOcean` VARCHAR(307) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CountryName` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CountryISO2` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Collectors` VARCHAR(500) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CollectionDateMin` DATETIME NULL DEFAULT NULL, `CollectionDateMax` DATETIME NULL DEFAULT NULL, `CollectorsNo` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CollectionNotes` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CollectionMethod` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Locality_ID` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `ExpeditionDetails` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Locality` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Habitat` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `DepthMin` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `DepthMax` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `DepthUnit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `DepthAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `DepthMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `AltitudeMin` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `AltitudeMax` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `AltitudeUnit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `AltitudeMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `AltitudeAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `LongitudeDecimal` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `LatitudeDecimal` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CoordAccuracyStatement` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `CoordErrorDistance` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GeodeticDatum` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GeocodeMethod` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Sex` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `BasisOfRecord` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `KindOfUnit` VARCHAR(150) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `PrepType` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `PrepStaff` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `TypeStatus` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Notes` VARCHAR(400) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `GUID` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `VoucherRefText` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `VoucherRefUrl` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci', `Aspect` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' ) ENGINE=MyISAM; -- Dumping structure for table dnabank._log_aliquots DROP TABLE IF EXISTS `_log_aliquots`; CREATE TABLE IF NOT EXISTS `_log_aliquots` ( `ID_Log_Aliquots` bigint(20) NOT NULL AUTO_INCREMENT, `ID_Aliquots` bigint(20) NOT NULL, `ID_DNA` bigint(20) NOT NULL, `Aliquots_Box` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Aliquots_Rack` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Aliquots_Fridge` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Aliquot_Number` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `Aliquot_Position` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Aliquot_Barcode` longtext COLLATE utf8_unicode_ci, `Origin_Quantity` float NOT NULL, `Rest_Quantity` float NOT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`ID_Log_Aliquots`), KEY `ID_Aliquots` (`ID_Aliquots`), KEY `ID_DNA` (`ID_DNA`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_aliquots: 0 rows /*!40000 ALTER TABLE `_log_aliquots` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_aliquots` ENABLE KEYS */; -- Dumping structure for table dnabank._log_amplifications DROP TABLE IF EXISTS `_log_amplifications`; CREATE TABLE IF NOT EXISTS `_log_amplifications` ( `ID_Log_Amplification` bigint(20) NOT NULL AUTO_INCREMENT, `ID_Amplification` bigint(20) NOT NULL, `ID_DNA` bigint(20) NOT NULL, `Fragment` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `GenBankNumber` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Link` longtext COLLATE utf8_unicode_ci NOT NULL, `Amplification_Date` datetime NOT NULL, `Amplification_Staff` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Amplification_Success` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`ID_Log_Amplification`), KEY `ID_Amplification` (`ID_Amplification`), KEY `ID_DNA` (`ID_DNA`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_amplifications: 0 rows /*!40000 ALTER TABLE `_log_amplifications` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_amplifications` ENABLE KEYS */; -- Dumping structure for table dnabank._log_cache DROP TABLE IF EXISTS `_log_cache`; CREATE TABLE IF NOT EXISTS `_log_cache` ( `ID_Log_Cache` bigint(20) NOT NULL AUTO_INCREMENT, `ID_Cache` bigint(20) DEFAULT NULL, `ID_Dataset_Specimen` bigint(20) DEFAULT NULL, `Provider_url` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `UnitID_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CollectionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `InstitutionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ContinentOrOcean` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CountryName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CountryISO2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `GatheringAgent` longtext COLLATE utf8_unicode_ci, `GatheringDate` longtext COLLATE utf8_unicode_ci, `LocalityText` longtext COLLATE utf8_unicode_ci, `Altitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LongitudeDecimal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LatitudeDecimal` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Gathering_Other` longtext COLLATE utf8_unicode_ci, `TypeStatus` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID_Log_Cache`), KEY `ID_Cache` (`ID_Cache`), KEY `ID_Dataset_Specimen` (`ID_Dataset_Specimen`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_cache: 0 rows /*!40000 ALTER TABLE `_log_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_cache` ENABLE KEYS */; -- Dumping structure for table dnabank._log_cachehighertaxa DROP TABLE IF EXISTS `_log_cachehighertaxa`; CREATE TABLE IF NOT EXISTS `_log_cachehighertaxa` ( `ID_Log_CacheHigherTaxon` bigint(20) NOT NULL AUTO_INCREMENT, `ID_HigherTaxon` bigint(20) DEFAULT NULL, `ID_CacheTaxonIdentified` bigint(20) DEFAULT NULL, `HigherTaxon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TaxonRank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_CacheTaxonidentified` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID_Log_CacheHigherTaxon`), KEY `ID_HigherTaxon` (`ID_HigherTaxon`), KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`), KEY `ID_Log_CacheTaxonIdentified` (`ID_Log_CacheTaxonidentified`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_cachehighertaxa: 0 rows /*!40000 ALTER TABLE `_log_cachehighertaxa` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_cachehighertaxa` ENABLE KEYS */; -- Dumping structure for table dnabank._log_cacheimages DROP TABLE IF EXISTS `_log_cacheimages`; CREATE TABLE IF NOT EXISTS `_log_cacheimages` ( `ID_Log_CacheImages` bigint(20) NOT NULL AUTO_INCREMENT, `ID_CacheImages` bigint(20) DEFAULT NULL, `ID_Cache` bigint(20) DEFAULT NULL, `Images` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_Cache` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`ID_Log_CacheImages`), KEY `ID_CacheImages` (`ID_CacheImages`), KEY `ID_Cache` (`ID_Cache`), KEY `ID_Log_Cache` (`ID_Log_Cache`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_cacheimages: 0 rows /*!40000 ALTER TABLE `_log_cacheimages` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_cacheimages` ENABLE KEYS */; -- Dumping structure for table dnabank._log_cachetaxonidentified DROP TABLE IF EXISTS `_log_cachetaxonidentified`; CREATE TABLE IF NOT EXISTS `_log_cachetaxonidentified` ( `ID_Log_CacheTaxonIdentified` bigint(20) NOT NULL AUTO_INCREMENT, `ID_CacheTaxonIdentified` bigint(20) DEFAULT NULL, `ID_Cache` bigint(20) DEFAULT NULL, `Genus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Subgenus` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `FirstEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SecondEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Rank` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `HybridFlag` tinyint(4) DEFAULT NULL, `Other` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `NameAuthorYear` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `PreferredFlag` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_Cache` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID_Log_CacheTaxonIdentified`), KEY `ID_CacheTaxonIdentified` (`ID_CacheTaxonIdentified`), KEY `ID_Cache` (`ID_Cache`), KEY `ID_Log_Cache` (`ID_Log_Cache`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_cachetaxonidentified: 0 rows /*!40000 ALTER TABLE `_log_cachetaxonidentified` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_cachetaxonidentified` ENABLE KEYS */; -- Dumping structure for table dnabank._log_dnabanknumbers DROP TABLE IF EXISTS `_log_dnabanknumbers`; CREATE TABLE IF NOT EXISTS `_log_dnabanknumbers` ( `ID_Log_DNA` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ID_DNA` bigint(20) NOT NULL, `ID_Cache` bigint(20) NOT NULL, `Provided_By_People` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Type` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `Location_Stock` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `DNA_Bank_Number` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `RelationDNA_Voucher` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Tissue` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Preservation` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Extraction_Date` datetime NOT NULL, `NoExtractDate` tinyint(4) DEFAULT NULL, `Extraction_Method` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Purification` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `Extraction_Staff` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Degradation` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Check_Date` datetime NOT NULL, `Concentration` float NOT NULL, `Absorbance280` float NOT NULL, `Absorbance230` float NOT NULL, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Quantity_Aliquots` float NOT NULL, `Stock_Gone` tinyint(1) NOT NULL, `Source_Gone` tinyint(1) NOT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Notes` longtext COLLATE utf8_unicode_ci NOT NULL, `Block_Until` date NOT NULL, `Block_General` tinyint(1) NOT NULL, `Number_Aliquots` float NOT NULL, `Backup_Aliquot` tinyint(1) NOT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`ID_Log_DNA`), KEY `ID_DNA` (`ID_DNA`), KEY `ID_Cache` (`ID_Cache`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_dnabanknumbers: 0 rows /*!40000 ALTER TABLE `_log_dnabanknumbers` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_dnabanknumbers` ENABLE KEYS */; -- Dumping structure for table dnabank._log_sptoolcollection DROP TABLE IF EXISTS `_log_sptoolcollection`; CREATE TABLE IF NOT EXISTS `_log_sptoolcollection` ( `ID_Log_Collection` bigint(20) NOT NULL AUTO_INCREMENT, `ID_Collection` bigint(20) DEFAULT NULL, `UnitID_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CollectionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `InstitutionCode_Specimen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `FormerCollection` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CountryName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `SeasAndOceans` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Collectors` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `CollectionDateMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `CollectionDateMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `CollectorsNo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Locality_ID` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `ExpeditionDetails` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL, `Region` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Locality` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Habitat` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Exposition` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `DepthAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DepthMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DepthMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `DepthUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AltitudeAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AltitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AltitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AltitudeUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `CoordinatesAccuracyStatement` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `CoordinatesErrorDistance` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LongitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LongitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LatitudeMin` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LatitudeMax` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LongitudeOther` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LatitudeOther` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Sex` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Protected` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Permission` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `BasisOfRecord` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `KindOfUnit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Cache` bigint(20) DEFAULT NULL, `Type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Notes` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL, `Blocked` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AccessionNo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AccessionName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `LifeStage` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `LifeForm` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID_Log_Collection`), KEY `ID_Gathering` (`ID_Collection`), KEY `ID_Cache` (`ID_Cache`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_sptoolcollection: 0 rows /*!40000 ALTER TABLE `_log_sptoolcollection` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_sptoolcollection` ENABLE KEYS */; -- Dumping structure for table dnabank._log_sptoolecology DROP TABLE IF EXISTS `_log_sptoolecology`; CREATE TABLE IF NOT EXISTS `_log_sptoolecology` ( `ID_Log_Ecology` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `ID_Ecology` bigint(10) unsigned NOT NULL DEFAULT '0', `ID_Collection` bigint(10) unsigned DEFAULT '0', `Value` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `Unit` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Parameter` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Method` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NULL DEFAULT '0000-00-00 00:00:00', `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID_Log_Ecology`), KEY `ID_Collection` (`ID_Collection`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_sptoolecology: 0 rows /*!40000 ALTER TABLE `_log_sptoolecology` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_sptoolecology` ENABLE KEYS */; -- Dumping structure for table dnabank._log_sptoolhighertaxon DROP TABLE IF EXISTS `_log_sptoolhighertaxon`; CREATE TABLE IF NOT EXISTS `_log_sptoolhighertaxon` ( `ID_Log_HigherTaxon` bigint(20) NOT NULL AUTO_INCREMENT, `ID_HigherTaxon` bigint(20) DEFAULT NULL, `ID_Taxa` bigint(20) DEFAULT NULL, `HigherTaxon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TaxonRank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Synecology` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_TaxonIdentified` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID_Log_HigherTaxon`), KEY `ID_HigherTaxon` (`ID_HigherTaxon`), KEY `ID_Taxa` (`ID_Taxa`), KEY `ID_Log_TaxonIdentified` (`ID_Log_TaxonIdentified`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_sptoolhighertaxon: 0 rows /*!40000 ALTER TABLE `_log_sptoolhighertaxon` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_sptoolhighertaxon` ENABLE KEYS */; -- Dumping structure for table dnabank._log_sptoolimages DROP TABLE IF EXISTS `_log_sptoolimages`; CREATE TABLE IF NOT EXISTS `_log_sptoolimages` ( `ID_Log_OfflineImages` bigint(20) NOT NULL AUTO_INCREMENT, `ID_Images` bigint(20) DEFAULT NULL, `ID_OfflineGathering` bigint(20) DEFAULT NULL, `ImageLink` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Update_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Update_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_OfflineGathering` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID_Log_OfflineImages`), KEY `ID_Log_OfflineGathering` (`ID_Log_OfflineGathering`), KEY `ID_Images` (`ID_Images`), KEY `ID_OfflineGathering` (`ID_OfflineGathering`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_sptoolimages: 0 rows /*!40000 ALTER TABLE `_log_sptoolimages` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_sptoolimages` ENABLE KEYS */; -- Dumping structure for table dnabank._log_sptooltaxa DROP TABLE IF EXISTS `_log_sptooltaxa`; CREATE TABLE IF NOT EXISTS `_log_sptooltaxa` ( `ID_Log_TaxonIdentified` bigint(20) NOT NULL AUTO_INCREMENT, `ID_TaxonIdentified` bigint(20) DEFAULT NULL, `ID_Collection` bigint(20) DEFAULT NULL, `Genus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Subgenus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SpecificEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `InfraspecificEpithet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Rank` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `AuthorParenth` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `YearParenth` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Author` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `Year` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `NameAuthorYear` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `KindOfIdentification` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Identifier` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `IdentificationDate` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `PreferredFlag` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `IdentificationNotes` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Synecology` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `This_Created_When` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `This_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Source_Created_When` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Source_Created_Who` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `ID_Log_Collection` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID_Log_TaxonIdentified`), KEY `ID_Log_OfflineGathering` (`ID_Log_Collection`), KEY `ID_TaxonIdentified` (`ID_TaxonIdentified`), KEY `ID_Gathering` (`ID_Collection`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- Dumping data for table dnabank._log_sptooltaxa: 0 rows /*!40000 ALTER TABLE `_log_sptooltaxa` DISABLE KEYS */; /*!40000 ALTER TABLE `_log_sptooltaxa` ENABLE KEYS */; -- Dumping structure for view dnabank.wrapper_view_amplifications DROP VIEW IF EXISTS `wrapper_view_amplifications`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_amplifications`; CREATE VIEW `wrapper_view_amplifications` AS select `dnabank`.`amplifications`.`ID_DNA` AS `ID_DNA`,`dnabank`.`amplifications`.`ID_Amplification` AS `ID_Amplification`,`dnabank`.`geneticlocus`.`GeneticLocus` AS `GeneticLocus`,`dnabank`.`amplifications`.`GenBankNumber` AS `GenBankNumber`,`dnabank`.`amplifications`.`Link` AS `GenBankLink`,`dnabank`.`amplifications`.`Amplification_Date` AS `Amplification_Date`,`dnabank`.`amplifications`.`Amplification_Success` AS `Amplification_Success`,`dnabank`.`people`.`Name_All` AS `Amplification_Staff` from ((`amplifications` left join `geneticlocus` on((`dnabank`.`geneticlocus`.`ID_GeneticLocus` = `dnabank`.`amplifications`.`ID_GeneticLocus`))) left join `people` on((`dnabank`.`people`.`ID_People` = `dnabank`.`amplifications`.`ID_Amplification_Staff`))) ; -- Dumping structure for view dnabank.wrapper_view_biotope DROP VIEW IF EXISTS `wrapper_view_biotope`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_biotope`; CREATEVIEW `wrapper_view_biotope` AS select `sptoolcollection`.`ID_Collection`,`soiltexture`.`SoilTexture`, 'Soil Texture' from (`sptoolcollection` join `soiltexture`) where ((`sptoolcollection`.`ID_SoilTexture` <> '') and (`sptoolcollection`.`ID_SoilTexture` = `soiltexture`.`ID_SoilTexture`)) union select `sptoolcollection`.`ID_Collection`,`habitatcode`.`HabitatCode`,'Habitat Code' from (`sptoolcollection` join `habitatcode`) where ((`sptoolcollection`.`ID_HabitatCode` <> '') and (`sptoolcollection`.`ID_HabitatCode` = `habitatcode`.`ID_HabitatCode`)) union select `sptoolcollection`.`ID_Collection`,`landusecode`.`LandUseCode`,'Land Use Code' from (`sptoolcollection` join `landusecode`) where ((`sptoolcollection`.`ID_LandUseCode` <> '') and (`sptoolcollection`.`ID_LandUseCode` = `landusecode`.`ID_LandUseCode`)) union select `sptoolcollection`.`ID_Collection`,`slope`.`Slope`,'Slope' from (`sptoolcollection` join `slope`) where ((`sptoolcollection`.`ID_Slope` <> '') and (`sptoolcollection`.`ID_Slope` = `slope`.`ID_Slope`)) ; -- Dumping structure for view dnabank.wrapper_view_dna DROP VIEW IF EXISTS `wrapper_view_dna`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_dna`; CREATE VIEW `wrapper_view_dna` AS select `dnabank`.`dnabanknumbers`.`ID_DNA` AS `ID_DNA`,`specimencache`.`ID_Cache` AS `ID_Cache`,`dnabank`.`dnabanknumbers`.`DNA_Bank_Number` AS `DNA_Bank_Number`,`dnabank`.`dnatype`.`Type` AS `Type`,`dnabank`.`relationdna_voucher`.`RelationDNA_Voucher` AS `RelationDNA_Voucher`,`dnabank`.`tissue`.`Tissue` AS `Tissue`,`dnabank`.`preservation`.`Preservation` AS `Preservation`,`dnabank`.`people`.`Name_All` AS `Provided_By`,`dnabank`.`dnabanknumbers`.`Extraction_Date` AS `Extraction_Date`,`staff`.`Name_All` AS `Extraction_Staff`,`dnabank`.`extractionmethod`.`Method` AS `Extraction_Method`,`dnabank`.`extractionmethod`.`Company` AS `Extraction_Company`,`dnabank`.`purification`.`Method` AS `Purification_Method`,`dnabank`.`purification`.`Company` AS `Purification_Company`,`dnabank`.`dnabanknumbers`.`Absorbance280` AS `Absorbance280`,`dnabank`.`dnabanknumbers`.`Absorbance230` AS `Absorbance230`,`dnabank`.`dnabanknumbers`.`Concentration` AS `Concentration`,`quality`.`Degradation` AS `Quality`,`dnabank`.`dnabanknumbers`.`Check_Date` AS `Quality_Check_Date`,`dnabank`.`dnabanknumbers`.`Block_Until` AS `Block_Until`,`dnabank`.`dnabanknumbers`.`Notes` AS `Notes` from ((((((((((`dnabanknumbers` left join `dnatype` on((`dnabank`.`dnatype`.`ID_Type` = `dnabank`.`dnabanknumbers`.`ID_Type`))) left join `relationdna_voucher` on((`dnabank`.`relationdna_voucher`.`ID_RelationDNA_Voucher` = `dnabank`.`dnabanknumbers`.`ID_RelationDNA_Voucher`))) left join `tissue` on((`dnabank`.`tissue`.`ID_Tissue` = `dnabank`.`dnabanknumbers`.`ID_Tissue`))) left join `preservation` on((`dnabank`.`preservation`.`ID_Preservation` = `dnabank`.`dnabanknumbers`.`ID_Preservation`))) left join `people` on((`dnabank`.`people`.`ID_People` = `dnabank`.`dnabanknumbers`.`ID_Provided_By_People`))) left join `extractionmethod` on((`dnabank`.`extractionmethod`.`ID_Method` = `dnabank`.`dnabanknumbers`.`ID_Extraction_Method`))) left join `people` `staff` on((`staff`.`ID_People` = `dnabank`.`dnabanknumbers`.`ID_Extraction_Staff`))) left join `purification` on((`dnabank`.`purification`.`ID_Purification` = `dnabank`.`dnabanknumbers`.`ID_Purification`))) left join `degradation` `quality` on((`quality`.`ID_Degradation` = `dnabank`.`dnabanknumbers`.`ID_Degradation`))) left join `cachecollection` `specimencache` on((`specimencache`.`ID_Cache` = `dnabank`.`dnabanknumbers`.`ID_Cache`))) where (`dnabank`.`dnabanknumbers`.`Block_General` <> _utf8'1') ; -- Dumping structure for view dnabank.wrapper_view_ecology DROP VIEW IF EXISTS `wrapper_view_ecology`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_ecology`; CREATE VIEW `wrapper_view_ecology` AS select `sptoolecology`.`ID_Collection` AS `ID_Collection`,`sptoolecology`.`Value` AS `Value`,`sptoolecology`.`Unit` AS `Unit`,`sptoolecology`.`Parameter` AS `Parameter`,`sptoolecology`.`Method` AS `Method` from `sptoolmeasurementorfact` AS `sptoolecology` where (`sptoolecology`.`Value` <> '' and `sptoolecology`.`Rank` = 'Ecology') union select `sptoolcollection`.`ID_Collection` AS `ID_Collection`,`soilph`.`SoilpH` AS `SoilpH`,'','Soil pH' AS `Soil pH`,'' from (`sptoolcollection` join `soilph`) where ((`sptoolcollection`.`ID_SoilpH` <> '') and (`sptoolcollection`.`ID_SoilpH` = `soilph`.`ID_SoilpH`)) ; -- Dumping structure for view dnabank.wrapper_view_multimedia_site DROP VIEW IF EXISTS `wrapper_view_multimedia_site`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_multimedia_site`; CREATE VIEW `wrapper_view_multimedia_site` AS select `specimenmultimedia`.`ID_Multimedia` AS `ID_Multimedia`,`specimenmultimedia`.`ID_Collection` AS `ID_Collection`,`specimenmultimedia`.`File_Path` AS `Path`,`specimenmultimedia`.`File_Type` AS `Type`,`specimenmultimedia`.`File_Created_When` AS `Created_When`,`specimenmultimedia`.`File_Created_Who` AS `Created_Who`,`specimenmultimedia`.`File_Context` AS `Context`,`specimenmultimedia`.`File_Comment` AS `Comment` from `sptoolmultimedia` `specimenmultimedia` where (`specimenmultimedia`.`File_Group` = _utf8'site') ; -- Dumping structure for view dnabank.wrapper_view_multimedia_specimens DROP VIEW IF EXISTS `wrapper_view_multimedia_specimens`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_multimedia_specimens`; CREATE VIEW `wrapper_view_multimedia_specimens` AS select `specimenmultimedia`.`ID_Multimedia` AS `ID_Multimedia`,`specimenmultimedia`.`ID_Collection` AS `ID_Collection`,`specimenmultimedia`.`File_Path` AS `Path`,`specimenmultimedia`.`File_Type` AS `Type`,`specimenmultimedia`.`File_Created_When` AS `Created_When`,`specimenmultimedia`.`File_Created_Who` AS `Created_Who`,`specimenmultimedia`.`File_Context` AS `Context`,`specimenmultimedia`.`File_Comment` AS `Comment` from `sptoolmultimedia` `specimenmultimedia` where (`specimenmultimedia`.`File_Group` = _utf8'specimen') ; -- Dumping structure for view dnabank.wrapper_view_namedareas DROP VIEW IF EXISTS `wrapper_view_namedareas`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_namedareas`; CREATE VIEW `wrapper_view_namedareas` AS select `specimens`.`ID_Collection` AS `ID_Collection`, 'Continent', `country_continent`.`Continent` AS `Continent` from `sptoolcollection` AS `specimens` left join `country_continent` on `specimens`.ID_Country = `country_continent`.ID_Country where `specimens`.ID_Country <> '' union select `specimens`.`ID_Collection` AS `ID_Collection`, 'Ocean', `seasandoceans`.`Ocean` AS `Ocean` from `sptoolcollection` AS `specimens` left join `seasandoceans` on `specimens`.ID_SeasAndOceans = `seasandoceans`.ID_SeasAndOceans where `specimens`.ID_SeasAndOceans <> '' union select `specimens`.`ID_Collection` AS `ID_Collection`, 'Biogeographic Region', `biogeographicregion`.`BiogeographicRegion` AS `BiogeographicRegion` from `sptoolcollection` AS `specimens` left join `biogeographicregion` on `specimens`.ID_BiogeographicRegion = `biogeographicregion`.ID_BiogeographicRegion where `specimens`.ID_BiogeographicRegion <> '' ; -- Dumping structure for view dnabank.wrapper_view_phases DROP VIEW IF EXISTS `wrapper_view_phases`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_phases`; CREATE VIEW `wrapper_view_phases` AS select ID_Collection, LifeForm FROM sptoolcollection where LifeForm != "" UNION select ID_Collection, LifeStage FROM sptoolcollection where LifeStage != "" ; -- Dumping structure for view dnabank.wrapper_view_providers DROP VIEW IF EXISTS `wrapper_view_providers`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_providers`; CREATE `wrapper_view_providers` AS select `dnabank`.`dataset`.`ID_Dataset` AS `ID_Dataset`,`dnabank`.`dataset`.`Digir_Resource` AS `Digir_Resource`,`dnabank`.`dataset`.`Digir_Source` AS `Digir_Source`,`dnabank`.`provider`.`Provider` AS `Provider`,`dnabank`.`schemata`.`Schemata` AS `Schemata` from ((`dataset` left join `provider` on((`dnabank`.`provider`.`ID_Provider` = `dnabank`.`dataset`.`ID_Provider`))) left join `schemata` on((`dnabank`.`schemata`.`ID_Schema` = `dnabank`.`provider`.`ID_Schema`))) ; -- Dumping structure for view dnabank.wrapper_view_publications_dna DROP VIEW IF EXISTS `wrapper_view_publications_dna`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_publications_dna`; CREATE `wrapper_view_publications_dna` AS select `publications_dna`.`ID_Pub_Amp` AS `ID_Pub_Amp`,`publications_dna`.`ID_Amplification` AS `ID_Amplification`,`publications_dna`.`Paper_Cache` AS `Paper_Cache`,`dnabank`.`publications`.`Link` AS `Link`,`publications_dna`.`GeneticLocus` AS `GeneticLocus` from (`publications_amplifications` `publications_dna` left join `publications` on((`dnabank`.`publications`.`ID_Publications` = `publications_dna`.`ID_Publications`))) ; -- Dumping structure for view dnabank.wrapper_view_specimens DROP VIEW IF EXISTS `wrapper_view_specimens`; -- Removing temporary table and create final VIEW structure DROP TABLE IF EXISTS `wrapper_view_specimens`; CREATE VIEW `wrapper_view_specimens` AS select `specimens`.`ID_Collection` AS `ID_Collection`,`specimens`.`UnitID_Specimen` AS `UnitID_Specimen`,`specimens`.`CollectionCode_Specimen` AS `CollectionCode_Specimen`,`specimens`.`InstitutionCode_Specimen` AS `InstitutionCode_Specimen`,concat_ws(_utf8', ',`country_continent`.`Continent`,`seasandoceans`.`Ocean`) AS `ContinentOrOcean`,`countryisocode`.`Country` AS `CountryName`,`countryisocode`.`IsoCode` AS `CountryISO2`,`specimens`.`Collectors` AS `Collectors`,`specimens`.`CollectionDateMin` AS `CollectionDateMin`,`specimens`.`CollectionDateMax` AS `CollectionDateMax`,`specimens`.`CollectorsNo` AS `CollectorsNo`,`specimens`.`CollectionNotes` AS `CollectionNotes`,`specimens`.`CollectionMethod` AS `CollectionMethod`,`specimens`.`Locality_ID` AS `Locality_ID`,`specimens`.`ExpeditionDetails` AS `ExpeditionDetails`,concat_ws(_utf8', ',`seasandoceans`.`SeasAndOceans`,`specimens`.`Region`,`specimens`.`Locality`) AS `Locality`,`specimens`.`Habitat` AS `Habitat`,`specimens`.`DepthMin` AS `DepthMin`,`specimens`.`DepthMax` AS `DepthMax`,`specimens`.`DepthUnit` AS `DepthUnit`,`specimens`.`DepthAccuracyStatement` AS `DepthAccuracyStatement`,`specimens`.`DepthMethod` AS `DepthMethod`,`specimens`.`AltitudeMin` AS `AltitudeMin`,`specimens`.`AltitudeMax` AS `AltitudeMax`,`specimens`.`AltitudeUnit` AS `AltitudeUnit`,`specimens`.`AltitudeMethod` AS `AltitudeMethod`,`specimens`.`AltitudeAccuracyStatement` AS `AltitudeAccuracyStatement`,`specimens`.`LongitudeMin` AS `LongitudeDecimal`,`specimens`.`LatitudeMin` AS `LatitudeDecimal`,`specimens`.`CoordinatesAccuracyStatement` AS `CoordAccuracyStatement`,`specimens`.`CoordinatesErrorDistance` AS `CoordErrorDistance`,`specimens`.`GeodeticDatum` AS `GeodeticDatum`, `geocode`.`Geocode` AS `GeocodeMethod`,`sex`.`Sex` AS `Sex`,`basisofrecord`.`BasisOfRecord_Specimen` AS `BasisOfRecord`,`specimens`.`KindOfUnit` AS `KindOfUnit`,`specimens`.`PrepType` AS `PrepType`,`specimens`.`PrepStaff` AS `PrepStaff`,`typestatus`.`SpecimenType` AS `TypeStatus`,`specimens`.`Notes` AS `Notes`,`specimens`.`GUID` AS `GUID`, `specimens`.`VoucherRefText` AS `VoucherRefText`,`specimens`.`VoucherRefUrl` AS `VoucherRefUrl`, `aspect`.`Aspect` AS `Aspect` from `sptoolcollection` AS `specimens` left join `specimentype` `typestatus` on `typestatus`.`ID_SpecimenType` = `specimens`.`ID_Type` left join `basisofrecordspecimen` AS `basisofrecord` on `basisofrecord`.`ID_BasisOfRecord_Specimen` = `specimens`.`ID_BasisOfRecord` left join `sex` on `sex`.`ID_Sex` = `specimens`.`ID_Sex` left join `seasandoceans` on `seasandoceans`.`ID_SeasAndOceans` = `specimens`.`ID_SeasAndOceans` left join `countryisocode` on `countryisocode`.`ID_Country` = `specimens`.`ID_Country` left join `country_continent` on `country_continent`.`ID_Country` = `countryisocode`.`ID_Country` left join `prevalentaspect` AS `aspect` on `specimens`.`ID_Aspect` = `aspect`.`ID_Aspect` left join `geocodemethod` AS `geocode` on `specimens`.`ID_GeocodeMethod` = `geocode`.`ID_Geocode` where `specimens`.`Protected` <> _utf8'Yes' and `specimens`.`Permission` <> _utf8'No' and `specimens`.`Blocked` <> _utf8'Yes' ; /*!40014 SET FOREIGN_KEY_CHECKS=1 */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;