mobedac.sql

-- MySQL dump 10.13  Distrib 5.5.18, for osx10.6 (i386)
--
-- Host: localhost    Database: mobedac
-- ------------------------------------------------------
-- Server version	5.5.18

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AIR`
--

DROP TABLE IF EXISTS `AIR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AIR` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `BAROMETRIC_PRESS` double DEFAULT NULL,
  `CARB_DIOXIDE` double DEFAULT NULL,
  `CARB_MONOXIDE` double DEFAULT NULL,
  `HUMIDITY` double DEFAULT NULL,
  `POLLUTANTS` varchar(500) DEFAULT NULL,
  `RESP_PART_MATTER` varchar(200) DEFAULT NULL,
  `SOLAR_IRRADIANCE` double DEFAULT NULL,
  `VENTILATION_RATE` double DEFAULT NULL,
  `VENTILATION_TYPE` varchar(500) DEFAULT NULL,
  `VOLATILE_ORG_COMP` varchar(500) DEFAULT NULL,
  `WIND_DIRECTION` int(11) DEFAULT NULL,
  `WIND_SPEED` double DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  KEY `IDX_AIR_AIR_CARD_DIR` (`WIND_DIRECTION`),
  CONSTRAINT `FK_AIR_CONT_VOCABS` FOREIGN KEY (`WIND_DIRECTION`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`),
  CONSTRAINT `FK_AIR_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `AIR`
--

LOCK TABLES `AIR` WRITE;
/*!40000 ALTER TABLE `AIR` DISABLE KEYS */;
/*!40000 ALTER TABLE `AIR` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `COLUMN_CONTROLLED_VOCAB`
--

DROP TABLE IF EXISTS `COLUMN_CONTROLLED_VOCAB`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COLUMN_CONTROLLED_VOCAB` (
  `COLUMN_NAME` varchar(200) NOT NULL,
  `CONTROLLED_VOCAB_ID` int(11) NOT NULL,
  PRIMARY KEY (`COLUMN_NAME`,`CONTROLLED_VOCAB_ID`),
  KEY `FK_COL_CONT_VOCAB_CONT_VOCAB` (`CONTROLLED_VOCAB_ID`),
  CONSTRAINT `FK_COL_CONT_VOCAB_COL_NAME` FOREIGN KEY (`COLUMN_NAME`) REFERENCES `COLUMN_DICTIONARY` (`COLUMN_NAME`),
  CONSTRAINT `FK_COL_CONT_VOCAB_CONT_VOCAB` FOREIGN KEY (`CONTROLLED_VOCAB_ID`) REFERENCES `CONTROLLED_VOCABS` (`CONTROLLED_VOCAB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `COLUMN_CONTROLLED_VOCAB`
--

LOCK TABLES `COLUMN_CONTROLLED_VOCAB` WRITE;
/*!40000 ALTER TABLE `COLUMN_CONTROLLED_VOCAB` DISABLE KEYS */;
/*!40000 ALTER TABLE `COLUMN_CONTROLLED_VOCAB` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `COLUMN_DICTIONARY`
--

DROP TABLE IF EXISTS `COLUMN_DICTIONARY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COLUMN_DICTIONARY` (
  `COLUMN_NAME` varchar(200) NOT NULL,
  `DATA_TYPE` varchar(100) NOT NULL,
  `DESC_OR_VALUE` varchar(1000) DEFAULT NULL,
  `DEFINITION` varchar(4000) DEFAULT NULL,
  `MIN_LENGTH` int(11) DEFAULT NULL,
  `ACTIVE` int(11) DEFAULT '1',
  PRIMARY KEY (`COLUMN_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `COLUMN_DICTIONARY`
--

LOCK TABLES `COLUMN_DICTIONARY` WRITE;
/*!40000 ALTER TABLE `COLUMN_DICTIONARY` DISABLE KEYS */;
/*!40000 ALTER TABLE `COLUMN_DICTIONARY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `COLUMN_ONTOLOGY`
--

DROP TABLE IF EXISTS `COLUMN_ONTOLOGY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COLUMN_ONTOLOGY` (
  `COLUMN_NAME` varchar(200) NOT NULL,
  `ONTOLOGY_SHORT_NAME` varchar(50) NOT NULL,
  PRIMARY KEY (`COLUMN_NAME`,`ONTOLOGY_SHORT_NAME`),
  CONSTRAINT `FK_COL_ONT_COL_NAME` FOREIGN KEY (`COLUMN_NAME`) REFERENCES `COLUMN_DICTIONARY` (`COLUMN_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `COLUMN_ONTOLOGY`
--

LOCK TABLES `COLUMN_ONTOLOGY` WRITE;
/*!40000 ALTER TABLE `COLUMN_ONTOLOGY` DISABLE KEYS */;
/*!40000 ALTER TABLE `COLUMN_ONTOLOGY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `COMMON_FIELDS`
--

DROP TABLE IF EXISTS `COMMON_FIELDS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `COMMON_FIELDS` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `ALKALINITY` double DEFAULT NULL,
  `ALKYL_DIETHERS` double DEFAULT NULL,
  `AMINOPEPT_ACT` double DEFAULT NULL,
  `AMMONIUM` double DEFAULT NULL,
  `BACTERIA_CARB_PROD` double DEFAULT NULL,
  `BIOMASS` varchar(400) DEFAULT NULL,
  `BISHOMOHOPANOL` double DEFAULT NULL,
  `BROMIDE` double DEFAULT NULL,
  `CALCIUM` double DEFAULT NULL,
  `CARB_NITRO_RATIO` double DEFAULT NULL,
  `CHLORIDE` double DEFAULT NULL,
  `CHLOROPHYLL` double DEFAULT NULL,
  `CURRENT` double DEFAULT NULL,
  `DENSITY` double DEFAULT NULL,
  `DIETHER_LIPIDS` varchar(400) DEFAULT NULL,
  `DISS_CARB_DIOXIDE` double DEFAULT NULL,
  `DISS_HYDROGEN` double DEFAULT NULL,
  `DISS_ORG_CARBON` double DEFAULT NULL,
  `DISS_OXYGEN` double DEFAULT NULL,
  `GLUCOSIDASE_ACT` double DEFAULT NULL,
  `MAGNESIUM` double DEFAULT NULL,
  `MEAN_FRICT_VEL` double DEFAULT NULL,
  `MEAN_PEAK_FRICT_VEL` double DEFAULT NULL,
  `METHANE` double DEFAULT NULL,
  `MISC_PARAM` varchar(4000) DEFAULT NULL,
  `N_ALKANES` double DEFAULT NULL,
  `NITRATE` double DEFAULT NULL,
  `NITRITE` double DEFAULT NULL,
  `NITRO` double DEFAULT NULL,
  `ORG_CARB` double DEFAULT NULL,
  `ORG_MATTER` double DEFAULT NULL,
  `ORG_NITRO` double DEFAULT NULL,
  `ORGANISM_COUNT` varchar(500) DEFAULT NULL,
  `OXYGEN` double DEFAULT NULL,
  `PART_ORG_CARB` double DEFAULT NULL,
  `PETROLEUM_HYDROCARB` double DEFAULT NULL,
  `PH` double DEFAULT NULL,
  `PHAEOPIGMENTS` varchar(500) DEFAULT NULL,
  `PHOSPHATE` double DEFAULT NULL,
  `PHOSPLIPID_FATT_ACID` varchar(500) DEFAULT NULL,
  `POTASSIUM` double DEFAULT NULL,
  `PRESS` double DEFAULT NULL,
  `REDOX_POTENTIAL` double DEFAULT NULL,
  `SALINITY` double DEFAULT NULL,
  `SILICATE` double DEFAULT NULL,
  `SULFATE` double DEFAULT NULL,
  `SULFIDE` double DEFAULT NULL,
  `TOT_CARB` double DEFAULT NULL,
  `TOT_NITRO` double DEFAULT NULL,
  `TOT_ORG_CARB` double DEFAULT NULL,
  `TURBIDITY` double DEFAULT NULL,
  `WATER_CONTENT` double DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_COMMON_FIELDS_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `COMMON_FIELDS`
--

LOCK TABLES `COMMON_FIELDS` WRITE;
/*!40000 ALTER TABLE `COMMON_FIELDS` DISABLE KEYS */;
INSERT INTO `COMMON_FIELDS` VALUES (258,2,2.1,2.1,2.1,2.1,'big',2.3,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'many fats',2.3,2.4,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'2',2.3,2.4,2.5,2.6,2.7,2.8,2.9,NULL,2.1,2.2,2.3,NULL,'red green yellow',2.5,'fat and more fat',2.6,2.7,2.8,2.9,2.1,2.2,2.3,2.4,2.5,2.6,2.7,2.8),(259,2,2.1,2.1,2.1,2.1,'big',2.3,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'many fats',2.3,2.4,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'2',2.3,2.4,2.5,2.6,2.7,2.8,2.9,NULL,2.1,2.2,2.3,NULL,'red green yellow',2.5,'fat and more fat',2.6,2.7,2.8,2.9,2.1,2.2,2.3,2.4,2.5,2.6,2.7,2.8),(260,2,2.1,2.1,2.1,2.1,'big',2.3,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'many fats',2.3,2.4,2.5,2.6,2.7,2.8,2.9,2.1,2.2,'2',2.3,2.4,2.5,2.6,2.7,2.8,2.9,NULL,2.1,2.2,2.3,NULL,'red green yellow',2.5,'fat and more fat',2.6,2.7,2.8,2.9,2.1,2.2,2.3,2.4,2.5,2.6,2.7,2.8);
/*!40000 ALTER TABLE `COMMON_FIELDS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CONTROLLED_VOCABS`
--

DROP TABLE IF EXISTS `CONTROLLED_VOCABS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONTROLLED_VOCABS` (
  `CONTROLLED_VOCAB_ID` int(11) NOT NULL,
  `VOCAB_NAME` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`CONTROLLED_VOCAB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CONTROLLED_VOCABS`
--

LOCK TABLES `CONTROLLED_VOCABS` WRITE;
/*!40000 ALTER TABLE `CONTROLLED_VOCABS` DISABLE KEYS */;
/*!40000 ALTER TABLE `CONTROLLED_VOCABS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CONTROLLED_VOCAB_VALUES`
--

DROP TABLE IF EXISTS `CONTROLLED_VOCAB_VALUES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONTROLLED_VOCAB_VALUES` (
  `VOCAB_VALUE_ID` int(11) NOT NULL,
  `CONTROLLED_VOCAB_ID` int(11) NOT NULL,
  `TERM` varchar(500) NOT NULL,
  `ORDER_BY` int(11) DEFAULT NULL,
  `DEFAULT_ITEM` char(1) DEFAULT NULL,
  PRIMARY KEY (`VOCAB_VALUE_ID`),
  KEY `FK_CONT_VCB_VALUES_CONT_VCBS` (`CONTROLLED_VOCAB_ID`),
  CONSTRAINT `FK_CONT_VCB_VALUES_CONT_VCBS` FOREIGN KEY (`CONTROLLED_VOCAB_ID`) REFERENCES `CONTROLLED_VOCABS` (`CONTROLLED_VOCAB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CONTROLLED_VOCAB_VALUES`
--

LOCK TABLES `CONTROLLED_VOCAB_VALUES` WRITE;
/*!40000 ALTER TABLE `CONTROLLED_VOCAB_VALUES` DISABLE KEYS */;
/*!40000 ALTER TABLE `CONTROLLED_VOCAB_VALUES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DIET_COMPONENETS`
--

DROP TABLE IF EXISTS `DIET_COMPONENETS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DIET_COMPONENETS` (
  `EXP_DIET_ID` int(11) NOT NULL,
  `PERENT_CARBO` float DEFAULT NULL,
  `PERCENT_FAT` float DEFAULT NULL,
  `PERCENT_PROTEIN` float DEFAULT NULL,
  `PERCENT_STARCH` float DEFAULT NULL,
  KEY `FK_DIET_COMP_CONT_VOCABS` (`EXP_DIET_ID`),
  CONSTRAINT `FK_DIET_COMP_CONT_VOCABS` FOREIGN KEY (`EXP_DIET_ID`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DIET_COMPONENETS`
--

LOCK TABLES `DIET_COMPONENETS` WRITE;
/*!40000 ALTER TABLE `DIET_COMPONENETS` DISABLE KEYS */;
/*!40000 ALTER TABLE `DIET_COMPONENETS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `EXTRA_COLUMN_METADATA`
--

DROP TABLE IF EXISTS `EXTRA_COLUMN_METADATA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `EXTRA_COLUMN_METADATA` (
  `STUDY_ID` int(11) NOT NULL,
  `TABLE_LEVEL` varchar(50) NOT NULL,
  `COLUMN_NAME` varchar(30) NOT NULL,
  `DESCRIPTION` varchar(2000) DEFAULT NULL,
  `DATA_TYPE` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`STUDY_ID`,`TABLE_LEVEL`,`COLUMN_NAME`),
  KEY `IDX_ECM_STUDY_ID` (`STUDY_ID`),
  KEY `IDX_ECM_TABLE_LEVEL` (`TABLE_LEVEL`),
  KEY `IDX_ECM_COLUMN_NAME` (`COLUMN_NAME`),
  CONSTRAINT `FK_TO_STUDY_STUDY_ID` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `EXTRA_COLUMN_METADATA`
--

LOCK TABLES `EXTRA_COLUMN_METADATA` WRITE;
/*!40000 ALTER TABLE `EXTRA_COLUMN_METADATA` DISABLE KEYS */;
/*!40000 ALTER TABLE `EXTRA_COLUMN_METADATA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUP`
--

DROP TABLE IF EXISTS `GROUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GROUP` (
  `GROUP_ID` int(11) NOT NULL,
  `GROUP_NAME` varchar(500) DEFAULT NULL,
  `STUDY_ID` int(11) NOT NULL,
  PRIMARY KEY (`GROUP_ID`),
  KEY `FK_GROUP_STUDY_ID` (`STUDY_ID`),
  CONSTRAINT `FK_GROUP_STUDY_ID` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUP`
--

LOCK TABLES `GROUP` WRITE;
/*!40000 ALTER TABLE `GROUP` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUP_TIMELINE`
--

DROP TABLE IF EXISTS `GROUP_TIMELINE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GROUP_TIMELINE` (
  `TIMELINE_ID` int(11) NOT NULL,
  `GROUP_ID` int(11) NOT NULL,
  PRIMARY KEY (`TIMELINE_ID`,`GROUP_ID`),
  KEY `FK_TIMELINE_GROUP_GROUP` (`GROUP_ID`),
  CONSTRAINT `FK_TIMELINE_GROUP_GROUP` FOREIGN KEY (`GROUP_ID`) REFERENCES `GROUP` (`GROUP_ID`),
  CONSTRAINT `FK_TIMELINE_GROUP_TIMELINE` FOREIGN KEY (`TIMELINE_ID`) REFERENCES `TIMELINE` (`TIMELINE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUP_TIMELINE`
--

LOCK TABLES `GROUP_TIMELINE` WRITE;
/*!40000 ALTER TABLE `GROUP_TIMELINE` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUP_TIMELINE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HOST_ASSOCIATED_PLANT`
--

DROP TABLE IF EXISTS `HOST_ASSOCIATED_PLANT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HOST_ASSOCIATED_PLANT` (
  `AIR_TEMP_REGM` varchar(200) DEFAULT NULL,
  `ANTIBIOTIC_REGM` varchar(500) DEFAULT NULL,
  `CHEM_MUTAGEN` varchar(500) DEFAULT NULL,
  `CLIMATE_ENVIRONMENT` varchar(300) DEFAULT NULL,
  `FERTILIZER_REGM` varchar(500) DEFAULT NULL,
  `FUNGICIDE_REGM` varchar(500) DEFAULT NULL,
  `GASEOUS_ENVIRONMENT` varchar(500) DEFAULT NULL,
  `GRAVITY` varchar(500) DEFAULT NULL,
  `GROWTH_HORMONE_REGM` varchar(500) DEFAULT NULL,
  `GROWTH_MED` varchar(300) DEFAULT NULL,
  `HERBICIDE_REGM` varchar(500) DEFAULT NULL,
  `HUMIDITY_REGM` varchar(500) DEFAULT NULL,
  `INFRA_SPECIFIC_NAME` varchar(200) DEFAULT NULL,
  `INFRA_SPECIFIC_RANK` varchar(200) DEFAULT NULL,
  `LIFE_STAGE` varchar(200) DEFAULT NULL,
  `MECHANICAL_DAMAGE` varchar(500) DEFAULT NULL,
  `MINERAL_NUTR_REGM` varchar(500) DEFAULT NULL,
  `NON_MINERAL_NUTR_REGM` varchar(500) DEFAULT NULL,
  `PESTICIDE_REGM` varchar(500) DEFAULT NULL,
  `PH_REGM` varchar(500) DEFAULT NULL,
  `PLANT_BODY_SITE` varchar(200) DEFAULT NULL,
  `PLANT_PRODUCT` varchar(200) DEFAULT NULL,
  `RADIATION_REGM` varchar(500) DEFAULT NULL,
  `RAINFALL_REGM` varchar(500) DEFAULT NULL,
  `SALT_REGM` varchar(500) DEFAULT NULL,
  `SEASON_ENVIRONMENT` varchar(300) DEFAULT NULL,
  `STANDING_WATER_REGM` varchar(500) DEFAULT NULL,
  `TISS_CULT_GROWTH_MED` varchar(200) DEFAULT NULL,
  `WATER_TEMP_REGM` varchar(500) DEFAULT NULL,
  `WATERING_REGM` varchar(500) DEFAULT NULL,
  `WET_MASS` double DEFAULT NULL,
  `SAMPLE_METADATA_ID` int(11) DEFAULT NULL,
  KEY `FK_HAP_TO_SAMPLE_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_HAP_TO_SAMPLE_SAMPLE_METADATA_ID` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HOST_ASSOCIATED_PLANT`
--

LOCK TABLES `HOST_ASSOCIATED_PLANT` WRITE;
/*!40000 ALTER TABLE `HOST_ASSOCIATED_PLANT` DISABLE KEYS */;
/*!40000 ALTER TABLE `HOST_ASSOCIATED_PLANT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HOST_GROUP`
--

DROP TABLE IF EXISTS `HOST_GROUP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HOST_GROUP` (
  `GROUP_ID` int(11) NOT NULL,
  `HOST_ID` int(11) NOT NULL,
  PRIMARY KEY (`GROUP_ID`,`HOST_ID`),
  KEY `FK_HOST_GROUP_HOST` (`HOST_ID`),
  CONSTRAINT `FK_HOST_GROUP_GROUP` FOREIGN KEY (`GROUP_ID`) REFERENCES `GROUP` (`GROUP_ID`),
  CONSTRAINT `FK_HOST_GROUP_HOST` FOREIGN KEY (`HOST_ID`) REFERENCES `HOST` (`HOST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HOST_GROUP`
--

LOCK TABLES `HOST_GROUP` WRITE;
/*!40000 ALTER TABLE `HOST_GROUP` DISABLE KEYS */;
/*!40000 ALTER TABLE `HOST_GROUP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HOST_RELATIONSHIP`
--

DROP TABLE IF EXISTS `HOST_RELATIONSHIP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HOST_RELATIONSHIP` (
  `HOST_ID_1` int(11) NOT NULL,
  `HOST_ID_2` int(11) NOT NULL,
  `RELATIONSHIP_TYPE_ID` int(11) NOT NULL,
  PRIMARY KEY (`HOST_ID_1`,`HOST_ID_2`),
  KEY `FK_HAV_CVV_REL_TYPE_ID` (`RELATIONSHIP_TYPE_ID`),
  CONSTRAINT `FK_HAV_CVV_REL_TYPE_ID` FOREIGN KEY (`RELATIONSHIP_TYPE_ID`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HOST_RELATIONSHIP`
--

LOCK TABLES `HOST_RELATIONSHIP` WRITE;
/*!40000 ALTER TABLE `HOST_RELATIONSHIP` DISABLE KEYS */;
/*!40000 ALTER TABLE `HOST_RELATIONSHIP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HOST_SAMPLE`
--

DROP TABLE IF EXISTS `HOST_SAMPLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HOST_SAMPLE` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `HOST_ID` int(11) NOT NULL,
  `AGE` double DEFAULT NULL,
  `AGE_UNIT` int(11) DEFAULT NULL,
  `DISEASE_STAT` varchar(2000) DEFAULT NULL,
  `DRY_MASS` double DEFAULT NULL,
  `GENOTYPE` varchar(200) DEFAULT NULL,
  `HEIGHT_OR_LENGTH` double DEFAULT NULL,
  `INFRA_SPECIFIC_NAME` varchar(200) DEFAULT NULL,
  `INFRA_SPECIFIC_RANK` varchar(100) DEFAULT NULL,
  `LIFE_STAGE` varchar(200) DEFAULT NULL,
  `PHENOTYPE` varchar(200) DEFAULT NULL,
  `TOTAL_MASS` double DEFAULT NULL,
  `HOST_COLOR` varchar(100) DEFAULT NULL,
  `HOST_SHAPE` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`,`HOST_ID`),
  KEY `IDX_HOST_SAMP_HOST_ID` (`HOST_ID`),
  KEY `IDX_HOST_SAMP_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_HOST_SAMPLE_HOST` FOREIGN KEY (`HOST_ID`) REFERENCES `HOST` (`HOST_ID`),
  CONSTRAINT `FK_HOST_SAMPLE_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HOST_SAMPLE`
--

LOCK TABLES `HOST_SAMPLE` WRITE;
/*!40000 ALTER TABLE `HOST_SAMPLE` DISABLE KEYS */;
INSERT INTO `HOST_SAMPLE` VALUES (258,8,23,NULL,'none',NULL,'freckles',NULL,NULL,NULL,NULL,'recessive',NULL,NULL,NULL),(259,8,23,NULL,'none',NULL,'freckles',NULL,NULL,NULL,NULL,'recessive',NULL,NULL,NULL),(260,8,23,NULL,'none',NULL,'freckles',NULL,NULL,NULL,NULL,'recessive',NULL,NULL,NULL);
/*!40000 ALTER TABLE `HOST_SAMPLE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HOST_TIMELINE`
--

DROP TABLE IF EXISTS `HOST_TIMELINE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HOST_TIMELINE` (
  `TIMELINE_ID` int(11) NOT NULL,
  `HOST_ID` int(11) NOT NULL,
  PRIMARY KEY (`TIMELINE_ID`,`HOST_ID`),
  KEY `FK_HOST_TIMELINE_HOST` (`HOST_ID`),
  CONSTRAINT `FK_HOST_TIMELINE_HOST` FOREIGN KEY (`HOST_ID`) REFERENCES `HOST` (`HOST_ID`),
  CONSTRAINT `FK_HOST_TIMELINE_TIMELINE` FOREIGN KEY (`TIMELINE_ID`) REFERENCES `TIMELINE` (`TIMELINE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HOST_TIMELINE`
--

LOCK TABLES `HOST_TIMELINE` WRITE;
/*!40000 ALTER TABLE `HOST_TIMELINE` DISABLE KEYS */;
/*!40000 ALTER TABLE `HOST_TIMELINE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HUMAN_ASSOCIATED`
--

DROP TABLE IF EXISTS `HUMAN_ASSOCIATED`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HUMAN_ASSOCIATED` (
  `BODY_MASS_INDEX` double DEFAULT NULL,
  `DRUG_USAGE` varchar(500) DEFAULT NULL,
  `HIV_STAT` char(1) DEFAULT NULL,
  `IHMC_ETHNICITY` varchar(200) DEFAULT NULL,
  `IHMC_OCCUPATION` int(11) DEFAULT NULL,
  `LAST_MEAL` varchar(500) DEFAULT NULL,
  `DIET_LAST_SIX_MONTH` varchar(200) DEFAULT NULL,
  `MEDIC_HIST_PERFORM` char(1) DEFAULT NULL,
  `PET_FARM_ANIMAL` varchar(300) DEFAULT NULL,
  `PULSE` double DEFAULT NULL,
  `SMOKER` char(1) DEFAULT NULL,
  `TRAVEL_OUT_SIX_MONTH` varchar(300) DEFAULT NULL,
  `TWIN_SIBLING` char(1) DEFAULT NULL,
  `WEIGHT_LOSS_3_MONTH` double DEFAULT NULL,
  `NOSE_THROAT_DISORD` varchar(500) DEFAULT NULL,
  `PULMONARY_DISORD` varchar(500) DEFAULT NULL,
  `STUDY_COMPLT_STAT` int(11) DEFAULT NULL,
  `AMNIOTIC_FLUID_COLOR` varchar(100) DEFAULT NULL,
  `GESTATION_STATE` varchar(200) DEFAULT NULL,
  `FOETAL_HEALTH_STAT` varchar(200) DEFAULT NULL,
  `MATERNAL_HEALTH_STAT` varchar(200) DEFAULT NULL,
  `BLOOD_DISORD` varchar(200) DEFAULT NULL,
  `GASTROINTEST_DISORD` varchar(200) DEFAULT NULL,
  `LIVER_DISORD` varchar(200) DEFAULT NULL,
  `SPECIAL_DIET` varchar(400) DEFAULT NULL,
  `NOSE_MOUTH_TEETH_THROAT_DISORD` varchar(400) DEFAULT NULL,
  `TIME_LAST_TOOTHBRUSH` double DEFAULT NULL,
  `DERMATOLOGY_DISORD` varchar(500) DEFAULT NULL,
  `DOMINANT_HAND` varchar(100) DEFAULT NULL,
  `TIME_SINCE_LAST_WASH` double DEFAULT NULL,
  `KIDNEY_DISORD` varchar(200) DEFAULT NULL,
  `URINE_COLLECT_METH` int(11) DEFAULT NULL,
  `UROGENIT_TRACT_DISOR` varchar(200) DEFAULT NULL,
  `BIRTH_CONTROL` varchar(100) DEFAULT NULL,
  `DOUCHE` date DEFAULT NULL,
  `GYNECOLOGIC_DISORD` varchar(200) DEFAULT NULL,
  `MENARCHE` date DEFAULT NULL,
  `HRT` date DEFAULT NULL,
  `HYSTERECTOMY` char(1) DEFAULT NULL,
  `MENOPAUSE` date DEFAULT NULL,
  `PREGNANCY` date DEFAULT NULL,
  `SEXUAL_ACT` varchar(200) DEFAULT NULL,
  `UROGENIT_DISORD` varchar(200) DEFAULT NULL,
  `SAMPLE_METADATA_ID` int(11) DEFAULT NULL,
  KEY `IDX_HA_STUDY_COMP_STATUS` (`STUDY_COMPLT_STAT`),
  KEY `IDX_HA_IHMC_OCCUPATION` (`IHMC_OCCUPATION`),
  KEY `IDX_HA_IHMC_ETHNICITY` (`IHMC_ETHNICITY`),
  KEY `IDX_HA_CVV_NOSE_THROAD` (`NOSE_THROAT_DISORD`),
  KEY `IDX_HUM_URN_URN_COL_METH` (`URINE_COLLECT_METH`),
  KEY `FK_HA_TO_SAMPLE_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_HA_CVV_STUDY_COMP` FOREIGN KEY (`STUDY_COMPLT_STAT`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`),
  CONSTRAINT `FK_HA_TO_SAMPLE_SAMPLE_METADATA_ID` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HUMAN_ASSOCIATED`
--

LOCK TABLES `HUMAN_ASSOCIATED` WRITE;
/*!40000 ALTER TABLE `HUMAN_ASSOCIATED` DISABLE KEYS */;
INSERT INTO `HUMAN_ASSOCIATED` VALUES (2.1,'no','0','22',NULL,'beans','yes','3','pigs',80,'0','no','0',4,'none','none',NULL,'clear','large','excellent','excellent','none','none','none','chocolate...and lots of it','should floss more',5,'none','right',1,'none',NULL,'none','yes...just say no!','2012-01-01','none','2012-01-01','2012-01-01','0','2012-01-01','2012-01-01','none','none',258),(2.1,'no','0','22',NULL,'beans','yes','3','pigs',80,'0','no','0',4,'none','none',NULL,'clear','large','excellent','excellent','none','none','none','chocolate...and lots of it','should floss more',5,'none','right',1,'none',NULL,'none','yes...just say no!','2012-01-01','none','2012-01-01','2012-01-01','0','2012-01-01','2012-01-01','none','none',259),(2.1,'no','0','22',NULL,'beans','yes','3','pigs',80,'0','no','0',4,'none','none',NULL,'clear','large','excellent','excellent','none','none','none','chocolate...and lots of it','should floss more',5,'none','right',1,'none',NULL,'none','yes...just say no!','2012-01-01','none','2012-01-01','2012-01-01','0','2012-01-01','2012-01-01','none','none',260);
/*!40000 ALTER TABLE `HUMAN_ASSOCIATED` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `JOB_STATUS`
--

DROP TABLE IF EXISTS `JOB_STATUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `JOB_STATUS` (
  `JOB_STATUS_ID` int(11) NOT NULL,
  `STATUS` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`JOB_STATUS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `JOB_STATUS`
--

LOCK TABLES `JOB_STATUS` WRITE;
/*!40000 ALTER TABLE `JOB_STATUS` DISABLE KEYS */;
/*!40000 ALTER TABLE `JOB_STATUS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `META_ANALYSIS`
--

DROP TABLE IF EXISTS `META_ANALYSIS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `META_ANALYSIS` (
  `META_ANALYSIS_ID` int(11) NOT NULL,
  `WEB_APP_USER_ID` int(11) NOT NULL,
  `META_ANALYSIS_NAME` varchar(500) NOT NULL,
  PRIMARY KEY (`META_ANALYSIS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `META_ANALYSIS`
--

LOCK TABLES `META_ANALYSIS` WRITE;
/*!40000 ALTER TABLE `META_ANALYSIS` DISABLE KEYS */;
/*!40000 ALTER TABLE `META_ANALYSIS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `META_ANALYSIS_FILES`
--

DROP TABLE IF EXISTS `META_ANALYSIS_FILES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `META_ANALYSIS_FILES` (
  `META_ANALYSIS_ID` int(11) NOT NULL,
  `FILE_PATH` varchar(2000) NOT NULL,
  `META_ANALYSIS_TYPE_ID` int(12) NOT NULL,
  `PROCESSING_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `FILE_TYPE` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`META_ANALYSIS_ID`,`FILE_PATH`(767)),
  CONSTRAINT `FK_IMF_TO_INV_INV_ID` FOREIGN KEY (`META_ANALYSIS_ID`) REFERENCES `META_ANALYSIS` (`META_ANALYSIS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `META_ANALYSIS_FILES`
--

LOCK TABLES `META_ANALYSIS_FILES` WRITE;
/*!40000 ALTER TABLE `META_ANALYSIS_FILES` DISABLE KEYS */;
/*!40000 ALTER TABLE `META_ANALYSIS_FILES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `META_ANALYSIS_TYPE`
--

DROP TABLE IF EXISTS `META_ANALYSIS_TYPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `META_ANALYSIS_TYPE` (
  `META_ANALYSIS_TYPE_ID` int(11) NOT NULL,
  `META_ANALYSIS_TYPE` varchar(20) NOT NULL,
  PRIMARY KEY (`META_ANALYSIS_TYPE_ID`,`META_ANALYSIS_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `META_ANALYSIS_TYPE`
--

LOCK TABLES `META_ANALYSIS_TYPE` WRITE;
/*!40000 ALTER TABLE `META_ANALYSIS_TYPE` DISABLE KEYS */;
/*!40000 ALTER TABLE `META_ANALYSIS_TYPE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `MICROBIAL_MAT_BIOFILM`
--

DROP TABLE IF EXISTS `MICROBIAL_MAT_BIOFILM`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MICROBIAL_MAT_BIOFILM` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_MICRO_MAT_BIOFILM_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MICROBIAL_MAT_BIOFILM`
--

LOCK TABLES `MICROBIAL_MAT_BIOFILM` WRITE;
/*!40000 ALTER TABLE `MICROBIAL_MAT_BIOFILM` DISABLE KEYS */;
/*!40000 ALTER TABLE `MICROBIAL_MAT_BIOFILM` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OTHER_ENVIRONMENT`
--

DROP TABLE IF EXISTS `OTHER_ENVIRONMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OTHER_ENVIRONMENT` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_OTHER_ENVIRONMENT_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OTHER_ENVIRONMENT`
--

LOCK TABLES `OTHER_ENVIRONMENT` WRITE;
/*!40000 ALTER TABLE `OTHER_ENVIRONMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OTHER_ENVIRONMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `QIIME_QUEUE`
--

DROP TABLE IF EXISTS `QIIME_QUEUE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QIIME_QUEUE` (
  `JOB_ID` int(11) NOT NULL,
  `INVESTIGATION_ID` int(11) NOT NULL,
  `SUBMISSION_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `STATUS` varchar(500) NOT NULL,
  `MAPPING_FILE` varchar(1000) NOT NULL,
  `JOB_STATUS_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`JOB_ID`),
  KEY `FK_QQ_TO_INV_INV_ID` (`INVESTIGATION_ID`),
  KEY `FK_QQ_TO_JS_JOB_STATUS_ID` (`JOB_STATUS_ID`),
  CONSTRAINT `FK_QQ_TO_INV_INV_ID` FOREIGN KEY (`INVESTIGATION_ID`) REFERENCES `META_ANALYSIS` (`META_ANALYSIS_ID`),
  CONSTRAINT `FK_QQ_TO_JS_JOB_STATUS_ID` FOREIGN KEY (`JOB_STATUS_ID`) REFERENCES `JOB_STATUS` (`JOB_STATUS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `QIIME_QUEUE`
--

LOCK TABLES `QIIME_QUEUE` WRITE;
/*!40000 ALTER TABLE `QIIME_QUEUE` DISABLE KEYS */;
/*!40000 ALTER TABLE `QIIME_QUEUE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `QIIME_QUEUE_SFF_FILES`
--

DROP TABLE IF EXISTS `QIIME_QUEUE_SFF_FILES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QIIME_QUEUE_SFF_FILES` (
  `JOB_ID` int(11) NOT NULL,
  `SFF_FILE` varchar(1000) NOT NULL,
  PRIMARY KEY (`JOB_ID`,`SFF_FILE`(767)),
  CONSTRAINT `FK_QQSF_TO_QQ_JOB_ID` FOREIGN KEY (`JOB_ID`) REFERENCES `QIIME_QUEUE` (`JOB_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `QIIME_QUEUE_SFF_FILES`
--

LOCK TABLES `QIIME_QUEUE_SFF_FILES` WRITE;
/*!40000 ALTER TABLE `QIIME_QUEUE_SFF_FILES` DISABLE KEYS */;
/*!40000 ALTER TABLE `QIIME_QUEUE_SFF_FILES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SAMPLE_EMP_SCORE`
--

DROP TABLE IF EXISTS `SAMPLE_EMP_SCORE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SAMPLE_EMP_SCORE` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `WEB_APP_USER_ID` int(11) NOT NULL,
  `EMP_SCORE` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SAMPLE_EMP_SCORE`
--

LOCK TABLES `SAMPLE_EMP_SCORE` WRITE;
/*!40000 ALTER TABLE `SAMPLE_EMP_SCORE` DISABLE KEYS */;
/*!40000 ALTER TABLE `SAMPLE_EMP_SCORE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SAMPLE_SEQUENCE_PREP`
--

DROP TABLE IF EXISTS `SAMPLE_SEQUENCE_PREP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SAMPLE_SEQUENCE_PREP` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `SEQUENCE_PREP_ID` int(11) NOT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`,`SEQUENCE_PREP_ID`),
  KEY `IDX_SSP_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  KEY `IDX_SSP_SEQ_PREP_ID` (`SEQUENCE_PREP_ID`),
  CONSTRAINT `FK_SSP_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SSP_SEQ_PREP` FOREIGN KEY (`SEQUENCE_PREP_ID`) REFERENCES `SEQUENCE_PREP` (`SEQUENCE_PREP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SAMPLE_SEQUENCE_PREP`
--

LOCK TABLES `SAMPLE_SEQUENCE_PREP` WRITE;
/*!40000 ALTER TABLE `SAMPLE_SEQUENCE_PREP` DISABLE KEYS */;
/*!40000 ALTER TABLE `SAMPLE_SEQUENCE_PREP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SAMPLE_TIMELINE`
--

DROP TABLE IF EXISTS `SAMPLE_TIMELINE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SAMPLE_TIMELINE` (
  `TIMELINE_ID` int(11) NOT NULL,
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  PRIMARY KEY (`TIMELINE_ID`,`SAMPLE_METADATA_ID`),
  KEY `FK_SAMPLE_TIMELINE_SAMPLE` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SAMPLE_TIMELINE_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SAMPLE_TIMELINE_TIMELINE` FOREIGN KEY (`TIMELINE_ID`) REFERENCES `TIMELINE` (`TIMELINE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SAMPLE_TIMELINE`
--

LOCK TABLES `SAMPLE_TIMELINE` WRITE;
/*!40000 ALTER TABLE `SAMPLE_TIMELINE` DISABLE KEYS */;
/*!40000 ALTER TABLE `SAMPLE_TIMELINE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SAMPLING_EVENT`
--

DROP TABLE IF EXISTS `SAMPLING_EVENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SAMPLING_EVENT` (
  `STUDY_ID` int(11) NOT NULL,
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `EVENT_DESCRIPTION` varchar(500) DEFAULT NULL,
  `EVENT_DATE` date DEFAULT NULL,
  PRIMARY KEY (`STUDY_ID`,`SAMPLE_METADATA_ID`),
  KEY `FK_SAMPLING_EVENT_SAMPLE` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SAMPLING_EVENT_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SAMPLING_EVENT_STUDY` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SAMPLING_EVENT`
--

LOCK TABLES `SAMPLING_EVENT` WRITE;
/*!40000 ALTER TABLE `SAMPLING_EVENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `SAMPLING_EVENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SEDIMENT`
--

DROP TABLE IF EXISTS `SEDIMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SEDIMENT` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `PARTICLE_CLASS` varchar(500) DEFAULT NULL,
  `POROSITY` double DEFAULT NULL,
  `SEDIMENT_TYPE` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SEDIMENT_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SEDIMENT`
--

LOCK TABLES `SEDIMENT` WRITE;
/*!40000 ALTER TABLE `SEDIMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `SEDIMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SOIL`
--

DROP TABLE IF EXISTS `SOIL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SOIL` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `CUR_LAND_USE` int(11) DEFAULT NULL,
  `CUR_VEGETATION` varchar(200) DEFAULT NULL,
  `CUR_VEGETATION_METH` varchar(200) DEFAULT NULL,
  `PREVIOUS_LAND_USE` varchar(500) DEFAULT NULL,
  `PREVIOUS_LAND_USE_METH` varchar(500) DEFAULT NULL,
  `CROP_ROTATION` varchar(200) DEFAULT NULL,
  `AGROCHEM_ADDITION` varchar(500) DEFAULT NULL,
  `TILLAGE` varchar(200) DEFAULT NULL,
  `FIRE` varchar(500) DEFAULT NULL,
  `FLOODING` varchar(500) DEFAULT NULL,
  `EXTREME_EVENT` varchar(500) DEFAULT NULL,
  `OTHER` varchar(1000) DEFAULT NULL,
  `HORIZON` varchar(100) DEFAULT NULL,
  `HORIZON_METH` varchar(200) DEFAULT NULL,
  `SIEVING` varchar(200) DEFAULT NULL,
  `WATER_CONTENT_SOIL` double DEFAULT NULL,
  `WATER_CONTENT_SOIL_METH` varchar(200) DEFAULT NULL,
  `SAMP_WEIGHT_DNA_EXT` double DEFAULT NULL,
  `POOL_DNA_EXTRACTS` int(11) DEFAULT NULL,
  `STORE_COND` varchar(400) DEFAULT NULL,
  `LINK_CLIMATE_INFO` varchar(500) DEFAULT NULL,
  `ANNUAL_SEASON_TEMP` double DEFAULT NULL,
  `ANNUAL_SEASON_PRECPT` double DEFAULT NULL,
  `LINK_CLASS_INFO` varchar(500) DEFAULT NULL,
  `FAO_CLASS` varchar(200) DEFAULT NULL,
  `LOCAL_CLASS` varchar(200) DEFAULT NULL,
  `LOCAL_CLASS_METH` varchar(200) DEFAULT NULL,
  `SOIL_TYPE` varchar(200) DEFAULT NULL,
  `SOIL_TYPE_METH` varchar(200) DEFAULT NULL,
  `SLOPE_GRADIENT` double DEFAULT NULL,
  `SLOPE_ASPECT` varchar(200) DEFAULT NULL,
  `PROFILE_POSITION` varchar(200) DEFAULT NULL,
  `DRAINAGE_CLASS` varchar(200) DEFAULT NULL,
  `TEXTURE` varchar(300) DEFAULT NULL,
  `TEXTURE_METH` varchar(200) DEFAULT NULL,
  `PH_METH` varchar(200) DEFAULT NULL,
  `TOT_ORG_C_METH` varchar(200) DEFAULT NULL,
  `TOT_N_METH` varchar(200) DEFAULT NULL,
  `MICROBIAL_BIOMASS` varchar(200) DEFAULT NULL,
  `MICROBIAL_BIOMASS_METH` varchar(200) DEFAULT NULL,
  `LINK_ADDIT_ANALYS` varchar(500) DEFAULT NULL,
  `EXTREME_SALINITY` double DEFAULT NULL,
  `SALINITY_METH` varchar(200) DEFAULT NULL,
  `HEAVY_METALS` varchar(200) DEFAULT NULL,
  `HEAVY_METALS_METH` varchar(200) DEFAULT NULL,
  `AL_SAT` double DEFAULT NULL,
  `AL_SAT_METH` varchar(200) DEFAULT NULL,
  `MISC_PARAM` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  KEY `IDX_SOIL_CUR_LAND_USE` (`CUR_LAND_USE`),
  CONSTRAINT `FK_SOIL_CV_CUR_LAND_USE` FOREIGN KEY (`CUR_LAND_USE`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`),
  CONSTRAINT `FK_SOIL_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SOIL`
--

LOCK TABLES `SOIL` WRITE;
/*!40000 ALTER TABLE `SOIL` DISABLE KEYS */;
/*!40000 ALTER TABLE `SOIL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SRA_SUBMISSION`
--

DROP TABLE IF EXISTS `SRA_SUBMISSION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SRA_SUBMISSION` (
  `STUDY_ID` int(11) NOT NULL,
  `ACCESSION` varchar(500) DEFAULT NULL,
  `SUBMISSION_ID` varchar(500) DEFAULT NULL,
  `SUBMISSION_COMMENT` varchar(2000) DEFAULT NULL,
  `LAB_NAME` varchar(500) DEFAULT NULL,
  `SUBMISSION_DATE` date DEFAULT NULL,
  `CONTACT` varchar(500) DEFAULT NULL,
  `FILE` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`STUDY_ID`),
  CONSTRAINT `FK_SRA_SUB_TO_STUDY` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SRA_SUBMISSION`
--

LOCK TABLES `SRA_SUBMISSION` WRITE;
/*!40000 ALTER TABLE `SRA_SUBMISSION` DISABLE KEYS */;
/*!40000 ALTER TABLE `SRA_SUBMISSION` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY`
--

DROP TABLE IF EXISTS `STUDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY` (
  `STUDY_ID` int(11) NOT NULL,
  `SUBMIT_TO_INSDC` char(1) DEFAULT NULL,
  `INVESTIGATION_TYPE` int(11) NOT NULL,
  `PROJECT_NAME` varchar(200) DEFAULT NULL,
  `EXPERIMENTAL_FACTOR` varchar(1000) DEFAULT NULL,
  `METADATA_COMPLETE` char(1) DEFAULT 'n',
  `STUDY_ALIAS` varchar(500) DEFAULT NULL,
  `STUDY_TITLE` varchar(500) DEFAULT NULL,
  `STUDY_TYPE` int(11) DEFAULT NULL,
  `STUDY_ABSTRACT` varchar(4000) DEFAULT NULL,
  `STUDY_DESCRIPTION` varchar(4000) DEFAULT NULL,
  `CENTER_NAME` varchar(500) DEFAULT NULL,
  `CENTER_PROJECT_NAME` varchar(500) DEFAULT NULL,
  `PROJECT_ID` varchar(500) DEFAULT NULL,
  `PMID` varchar(500) DEFAULT NULL,
  `MIENS_COMPLIANT` char(1) DEFAULT 'y',
  `STUDY_PUBLIC` char(1) NOT NULL DEFAULT 'n',
  `PORTAL_TYPE` varchar(100) DEFAULT 'qiime',
  `INT_SAMPLES_PROMISED` int(11) DEFAULT NULL,
  `PRINCIPAL_INVESTIGATOR` varchar(200) DEFAULT NULL,
  `INT_SAMPLES_COLLECTED` int(11) DEFAULT NULL,
  `LAB_PERSON` varchar(300) DEFAULT NULL,
  `LAB_PERSON_CONTACT` varchar(300) DEFAULT NULL,
  `EMP_PERSON` varchar(300) DEFAULT NULL,
  `FIRST_CONTACT` varchar(300) DEFAULT NULL,
  `MOST_RECENT_CONTACT` varchar(300) DEFAULT NULL,
  `SAMPLE_TYPE` varchar(500) DEFAULT NULL,
  `HAS_PHYSICAL_SPECIMEN` varchar(300) DEFAULT NULL,
  `HAS_EXTRACTED_DATA` varchar(300) DEFAULT NULL,
  `TIMESERIES` varchar(300) DEFAULT NULL,
  `SPATIAL_SERIES` varchar(300) DEFAULT NULL,
  `PRINCIPAL_INVESTIGATOR_CONTACT` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`STUDY_ID`),
  KEY `IDX_STUDY_INVEST_TYPE` (`INVESTIGATION_TYPE`),
  CONSTRAINT `FK_STUDY_CVV_INVEST_TYPE` FOREIGN KEY (`INVESTIGATION_TYPE`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY`
--

LOCK TABLES `STUDY` WRITE;
/*!40000 ALTER TABLE `STUDY` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_ACTUAL_COLUMNS`
--

DROP TABLE IF EXISTS `STUDY_ACTUAL_COLUMNS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_ACTUAL_COLUMNS` (
  `STUDY_ID` int(11) NOT NULL,
  `COLUMN_NAME` varchar(200) NOT NULL,
  `TABLE_NAME` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`STUDY_ID`,`COLUMN_NAME`),
  KEY `IDX_SAC_STUDY_ID` (`STUDY_ID`),
  KEY `IDX_SAC_COLUMN_NAME` (`COLUMN_NAME`),
  CONSTRAINT `FK_STUDY_COL_STUDY` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_ACTUAL_COLUMNS`
--

LOCK TABLES `STUDY_ACTUAL_COLUMNS` WRITE;
/*!40000 ALTER TABLE `STUDY_ACTUAL_COLUMNS` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_ACTUAL_COLUMNS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_COLUMNS`
--

DROP TABLE IF EXISTS `STUDY_COLUMNS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_COLUMNS` (
  `PACKAGE_TYPE_ID` int(11) NOT NULL,
  `COLUMN_NAME` varchar(200) NOT NULL,
  `REQUIRED` char(1) DEFAULT NULL,
  PRIMARY KEY (`PACKAGE_TYPE_ID`,`COLUMN_NAME`),
  KEY `FK_STUDY_COLUMNS_COLUMN_DICT` (`COLUMN_NAME`),
  CONSTRAINT `FK_STUDY_COLUMNS_COLUMN_DICT` FOREIGN KEY (`COLUMN_NAME`) REFERENCES `COLUMN_DICTIONARY` (`COLUMN_NAME`),
  CONSTRAINT `FK_STUDY_COL_CVV_PACK_TYPE_ID` FOREIGN KEY (`PACKAGE_TYPE_ID`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_COLUMNS`
--

LOCK TABLES `STUDY_COLUMNS` WRITE;
/*!40000 ALTER TABLE `STUDY_COLUMNS` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_COLUMNS` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_EMP_SCORE`
--

DROP TABLE IF EXISTS `STUDY_EMP_SCORE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_EMP_SCORE` (
  `STUDY_ID` int(11) NOT NULL,
  `WEB_APP_USER_ID` int(11) NOT NULL,
  `EMP_SCORE` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_EMP_SCORE`
--

LOCK TABLES `STUDY_EMP_SCORE` WRITE;
/*!40000 ALTER TABLE `STUDY_EMP_SCORE` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_EMP_SCORE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_FILES`
--

DROP TABLE IF EXISTS `STUDY_FILES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_FILES` (
  `STUDY_ID` int(11) NOT NULL,
  `FILE_PATH` varchar(1000) NOT NULL,
  `FILE_TYPE` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`STUDY_ID`,`FILE_PATH`(767)),
  KEY `IDX_STUDY_SFFS_STUDY_ID` (`STUDY_ID`),
  CONSTRAINT `FK_STUDY_SFFS_STUDY_ID` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_FILES`
--

LOCK TABLES `STUDY_FILES` WRITE;
/*!40000 ALTER TABLE `STUDY_FILES` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_FILES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_PACKAGES`
--

DROP TABLE IF EXISTS `STUDY_PACKAGES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_PACKAGES` (
  `STUDY_ID` int(11) NOT NULL,
  `ENV_PACKAGE` int(11) NOT NULL,
  PRIMARY KEY (`STUDY_ID`,`ENV_PACKAGE`),
  KEY `IDX_STUDY_PACKAGES_STUDY_ID` (`STUDY_ID`),
  KEY `IDX_STUDY_PACKAGES_ENV_PKG` (`ENV_PACKAGE`),
  CONSTRAINT `FK_STUD_PACK_CVV` FOREIGN KEY (`ENV_PACKAGE`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`),
  CONSTRAINT `FK_STUD_PACK_STUDY` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_PACKAGES`
--

LOCK TABLES `STUDY_PACKAGES` WRITE;
/*!40000 ALTER TABLE `STUDY_PACKAGES` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_PACKAGES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `STUDY_SAMPLE`
--

DROP TABLE IF EXISTS `STUDY_SAMPLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `STUDY_SAMPLE` (
  `STUDY_ID` int(11) NOT NULL,
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `SAMPLE_NAME` varchar(500) NOT NULL,
  PRIMARY KEY (`STUDY_ID`,`SAMPLE_METADATA_ID`),
  KEY `FK_SS_TO_SAMPLE_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SS_TO_SAMPLE_SAMPLE_METADATA_ID` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_SS_TO_STUDY_STUDY_ID` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `STUDY_SAMPLE`
--

LOCK TABLES `STUDY_SAMPLE` WRITE;
/*!40000 ALTER TABLE `STUDY_SAMPLE` DISABLE KEYS */;
/*!40000 ALTER TABLE `STUDY_SAMPLE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TIMELINE`
--

DROP TABLE IF EXISTS `TIMELINE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TIMELINE` (
  `TIMELINE_ID` int(11) NOT NULL,
  `STUDY_ID` int(11) NOT NULL,
  `ENTRY_DATE` date DEFAULT NULL,
  `ENTRY_TEXT` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`TIMELINE_ID`),
  KEY `IDX_TLINE_STUDY_ID` (`STUDY_ID`),
  CONSTRAINT `FK_TIMELINE_STUDY` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TIMELINE`
--

LOCK TABLES `TIMELINE` WRITE;
/*!40000 ALTER TABLE `TIMELINE` DISABLE KEYS */;
/*!40000 ALTER TABLE `TIMELINE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `USER_STUDY`
--

DROP TABLE IF EXISTS `USER_STUDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `USER_STUDY` (
  `WEB_APP_USER_ID` int(11) NOT NULL,
  `STUDY_ID` int(11) NOT NULL,
  PRIMARY KEY (`WEB_APP_USER_ID`,`STUDY_ID`),
  KEY `FK_STUDY_ID` (`STUDY_ID`),
  CONSTRAINT `FK_STUDY_ID` FOREIGN KEY (`STUDY_ID`) REFERENCES `STUDY` (`STUDY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `USER_STUDY`
--

LOCK TABLES `USER_STUDY` WRITE;
/*!40000 ALTER TABLE `USER_STUDY` DISABLE KEYS */;
/*!40000 ALTER TABLE `USER_STUDY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `VAMPS_PROJ_DS_SAMPLE_METADATA`
--

DROP TABLE IF EXISTS `VAMPS_PROJ_DS_SAMPLE_METADATA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAMPS_PROJ_DS_SAMPLE_METADATA` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VAMPS_PROJECT` varchar(45) NOT NULL,
  `VAMPS_DATASET` varchar(45) NOT NULL,
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IDX_VPDSM_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_VPDSM_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `VAMPS_PROJ_DS_SAMPLE_METADATA`
--

LOCK TABLES `VAMPS_PROJ_DS_SAMPLE_METADATA` WRITE;
/*!40000 ALTER TABLE `VAMPS_PROJ_DS_SAMPLE_METADATA` DISABLE KEYS */;
/*!40000 ALTER TABLE `VAMPS_PROJ_DS_SAMPLE_METADATA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `WASTEWATER_SLUDGE`
--

DROP TABLE IF EXISTS `WASTEWATER_SLUDGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `WASTEWATER_SLUDGE` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `BIOCHEM_OXYGEN_DEM` double DEFAULT NULL,
  `CHEM_OXYGEN_DEM` double DEFAULT NULL,
  `EFFICIENCY_PERCENT` double DEFAULT NULL,
  `EMULSIONS` varchar(200) DEFAULT NULL,
  `GASEOUS_SUBSTANCES` varchar(200) DEFAULT NULL,
  `INDUST_EFF_PERCENT` double DEFAULT NULL,
  `INORG_PARTICLES` varchar(500) DEFAULT NULL,
  `ORG_PARTICLES` varchar(500) DEFAULT NULL,
  `PRE_TREATMENT` varchar(300) DEFAULT NULL,
  `PRIMARY_TREATMENT` varchar(300) DEFAULT NULL,
  `REACTOR_TYPE` varchar(200) DEFAULT NULL,
  `SECONDARY_TREATMENT` varchar(300) DEFAULT NULL,
  `SEWAGE_TYPE` varchar(200) DEFAULT NULL,
  `SLUDGE_RETENT_TIME` double DEFAULT NULL,
  `SOLUBLE_INORG_MAT` double DEFAULT NULL,
  `SOLUBLE_ORG_MAT` double DEFAULT NULL,
  `SUSPEND_SOLIDS` varchar(400) DEFAULT NULL,
  `TERTIARY_TREATMENT` varchar(300) DEFAULT NULL,
  `TOT_PHOSPHATE` double DEFAULT NULL,
  `WASTEWATER_TYPE` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_WASTEWATER_SLUDGE_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `WASTEWATER_SLUDGE`
--

LOCK TABLES `WASTEWATER_SLUDGE` WRITE;
/*!40000 ALTER TABLE `WASTEWATER_SLUDGE` DISABLE KEYS */;
/*!40000 ALTER TABLE `WASTEWATER_SLUDGE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `WATER`
--

DROP TABLE IF EXISTS `WATER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `WATER` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `ATMOSPHERIC_DATA` varchar(500) DEFAULT NULL,
  `DISS_INORG_NITRO` double DEFAULT NULL,
  `DISS_INORG_PHOSP` double DEFAULT NULL,
  `LIGHT_INTENSITY` double DEFAULT NULL,
  `PHOTON_FLUX` double DEFAULT NULL,
  `PRIMARY_PROD` double DEFAULT NULL,
  `SOLUBLE_REACT_PHOSP` double DEFAULT NULL,
  `SUSPEND_PART_MATTER` double DEFAULT NULL,
  `TOT_DEPTH_WATER_COL` double DEFAULT NULL,
  `TOT_INORG_NITRO` double DEFAULT NULL,
  `TOT_PART_CARB` double DEFAULT NULL,
  `TOT_PHOSP` double DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_WATER_SAMPLE` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `WATER`
--

LOCK TABLES `WATER` WRITE;
/*!40000 ALTER TABLE `WATER` DISABLE KEYS */;
/*!40000 ALTER TABLE `WATER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `analysis_request`
--

DROP TABLE IF EXISTS `analysis_request`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `analysis_request` (
  `id` int(11) NOT NULL,
  `library_ids` varchar(1024) DEFAULT NULL,
  `user` varchar(45) DEFAULT NULL,
  `project_code` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `analysis_request`
--

LOCK TABLES `analysis_request` WRITE;
/*!40000 ALTER TABLE `analysis_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `analysis_request` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `host`
--

DROP TABLE IF EXISTS `host`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `host` (
  `HOST_ID` int(11) NOT NULL AUTO_INCREMENT,
  `HOST_SUBJECT_ID` varchar(200) DEFAULT NULL,
  `HOST_COMMON_NAME` varchar(200) DEFAULT NULL,
  `HOST_TAXID` int(11) DEFAULT NULL,
  PRIMARY KEY (`HOST_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `host`
--

LOCK TABLES `host` WRITE;
/*!40000 ALTER TABLE `host` DISABLE KEYS */;
INSERT INTO `host` VALUES (8,'johnh',NULL,NULL);
/*!40000 ALTER TABLE `host` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `host_assoc_vertibrate`
--

DROP TABLE IF EXISTS `host_assoc_vertibrate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `host_assoc_vertibrate` (
  `BODY_HABITAT` varchar(200) DEFAULT NULL,
  `BODY_SITE` varchar(200) DEFAULT NULL,
  `BODY_PRODUCT` varchar(200) DEFAULT NULL,
  `BLOOD_PRESS_DIAST` double DEFAULT NULL,
  `BLOOD_PRESS_SYST` double DEFAULT NULL,
  `HOST_BODY_TEMP` double DEFAULT NULL,
  `DIET` varchar(100) DEFAULT NULL,
  `FAMILY_RELATIONSHIP` varchar(200) DEFAULT NULL,
  `MEDICATIONS` varchar(500) DEFAULT NULL,
  `GRAVIDITY` char(1) DEFAULT NULL,
  `GRAVIDITY_DUE_DATE` varchar(200) DEFAULT NULL,
  `HOST_GROWTH_COND` varchar(500) DEFAULT NULL,
  `LAST_MEAL` varchar(500) DEFAULT NULL,
  `SCIENTIFIC_NAME` varchar(500) DEFAULT NULL,
  `SEX` int(11) DEFAULT NULL,
  `SUBSTRATE` varchar(200) DEFAULT NULL,
  `TIME_SINCE_LAST_MEDICATION` double DEFAULT NULL,
  `DATE_OF_BIRTH` date DEFAULT NULL,
  `SAMPLE_METADATA_ID` int(11) DEFAULT NULL,
  KEY `IDX_HAV_BODY_HABITAT` (`BODY_HABITAT`),
  KEY `IDX_HAV_BODY_PRODUCT` (`BODY_PRODUCT`),
  KEY `IDX_HAV_BODY_SITE` (`BODY_SITE`),
  KEY `IDX_HAV_SEX` (`SEX`),
  KEY `FK_HAV_TO_SAMPLE_SAMPLE_METADATA_ID` (`SAMPLE_METADATA_ID`),
  CONSTRAINT `FK_HAV_ONT_SEX` FOREIGN KEY (`SEX`) REFERENCES `CONTROLLED_VOCAB_VALUES` (`VOCAB_VALUE_ID`),
  CONSTRAINT `FK_HAV_TO_SAMPLE_SAMPLE_METADATA_ID` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `host_assoc_vertibrate`
--

LOCK TABLES `host_assoc_vertibrate` WRITE;
/*!40000 ALTER TABLE `host_assoc_vertibrate` DISABLE KEYS */;
INSERT INTO `host_assoc_vertibrate` VALUES ('habitat','chest','product',120,80,98.6,'food','good','garlic','0','2012-01-01','growth',NULL,'food',NULL,'metal',2,'2012-01-01',258),('habitat','chest','product',120,80,98.6,'food','good','garlic','0','2012-01-01','growth',NULL,'food',NULL,'metal',2,'2012-01-01',259),('habitat','chest','product',120,80,98.6,'food','good','garlic','0','2012-01-01','growth',NULL,'food',NULL,'metal',2,'2012-01-01',260);
/*!40000 ALTER TABLE `host_assoc_vertibrate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `library`
--

DROP TABLE IF EXISTS `library`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `library` (
  `id` varchar(64) NOT NULL,
  `name` varchar(250) NOT NULL,
  `about` varchar(1024) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `creation` datetime NOT NULL,
  `metadata` mediumtext,
  `lib_type` varchar(256) DEFAULT NULL,
  `lib_insert_len` int(11) DEFAULT NULL,
  `sample_id` varchar(64) NOT NULL,
  `run_key` varchar(16) DEFAULT NULL,
  `primers` mediumtext,
  `direction` varchar(16) DEFAULT NULL,
  `region` varchar(32) DEFAULT NULL,
  `domain` varchar(45) DEFAULT NULL,
  `sequence_set_ids` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `sample_id` (`sample_id`),
  CONSTRAINT `library_ibfk_1` FOREIGN KEY (`sample_id`) REFERENCES `sample` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `library`
--

LOCK TABLES `library` WRITE;
/*!40000 ALTER TABLE `library` DISABLE KEYS */;
/*!40000 ALTER TABLE `library` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `primer`
--

DROP TABLE IF EXISTS `primer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `primer` (
  `primer_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `primer` varchar(16) NOT NULL DEFAULT '' COMMENT 'name of the sequencing primer',
  `direction` enum('F','R') NOT NULL COMMENT 'direction of priming, forward or reverse',
  `sequence` varchar(64) NOT NULL DEFAULT '' COMMENT 'primer sequence -- includes regular expressions for multiple bases or fuzzy matching',
  `region` varchar(16) NOT NULL DEFAULT '' COMMENT 'region of the genome being amplified',
  `original_seq` varchar(64) NOT NULL DEFAULT '' COMMENT 'primer sequence as ordered from the primer supply company',
  `domain` enum('bacteria','archaea','eukarya','') DEFAULT NULL,
  PRIMARY KEY (`primer_id`),
  UNIQUE KEY `primer` (`primer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `primer`
--

LOCK TABLES `primer` WRITE;
/*!40000 ALTER TABLE `primer` DISABLE KEYS */;
/*!40000 ALTER TABLE `primer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `primer_suite`
--

DROP TABLE IF EXISTS `primer_suite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `primer_suite` (
  `primer_suite_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `primer_suite` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`primer_suite_id`),
  UNIQUE KEY `primer_suite` (`primer_suite`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `primer_suite`
--

LOCK TABLES `primer_suite` WRITE;
/*!40000 ALTER TABLE `primer_suite` DISABLE KEYS */;
/*!40000 ALTER TABLE `primer_suite` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `primer_vamps`
--

DROP TABLE IF EXISTS `primer_vamps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `primer_vamps` (
  `primer_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `primer` varchar(16) NOT NULL DEFAULT '' COMMENT 'name of the sequencing primer',
  `direction` enum('F','R') NOT NULL COMMENT 'direction of priming, forward or reverse',
  `sequence` varchar(64) NOT NULL DEFAULT '' COMMENT 'primer sequence -- includes regular expressions for multiple bases or fuzzy matching',
  `region` varchar(16) NOT NULL DEFAULT '' COMMENT 'region of the genome being amplified',
  `original_seq` varchar(64) NOT NULL DEFAULT '' COMMENT 'primer sequence as ordered from the primer supply company',
  `domain` enum('bacteria','archaea','eukarya','') DEFAULT NULL,
  PRIMARY KEY (`primer_id`),
  UNIQUE KEY `primer` (`primer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `primer_vamps`
--

LOCK TABLES `primer_vamps` WRITE;
/*!40000 ALTER TABLE `primer_vamps` DISABLE KEYS */;
/*!40000 ALTER TABLE `primer_vamps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project` (
  `id` varchar(64) NOT NULL,
  `name` varchar(250) NOT NULL,
  `about` varchar(1024) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `creation` datetime NOT NULL,
  `metadata` mediumtext,
  `pi` varchar(256) NOT NULL DEFAULT 'JH',
  `funding_source` varchar(1024) DEFAULT NULL,
  `description` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project`
--

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ref_primer_suite_primer`
--

DROP TABLE IF EXISTS `ref_primer_suite_primer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ref_primer_suite_primer` (
  `primer_suite_id` smallint(5) unsigned NOT NULL,
  `primer_id` smallint(5) unsigned NOT NULL,
  KEY `primer_suite_id` (`primer_suite_id`),
  KEY `primer_id` (`primer_id`),
  CONSTRAINT `ref_primer_suite_primer_ibfk_1` FOREIGN KEY (`primer_suite_id`) REFERENCES `primer_suite` (`primer_suite_id`),
  CONSTRAINT `ref_primer_suite_primer_ibfk_2` FOREIGN KEY (`primer_id`) REFERENCES `primer_vamps` (`primer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ref_primer_suite_primer`
--

LOCK TABLES `ref_primer_suite_primer` WRITE;
/*!40000 ALTER TABLE `ref_primer_suite_primer` DISABLE KEYS */;
/*!40000 ALTER TABLE `ref_primer_suite_primer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sample`
--

DROP TABLE IF EXISTS `sample`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sample` (
  `id` varchar(64) NOT NULL,
  `name` varchar(250) NOT NULL,
  `about` varchar(1024) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `creation` datetime NOT NULL,
  `metadata` mediumtext,
  `project_id` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `project_id` (`project_id`),
  CONSTRAINT `sample_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sample`
--

LOCK TABLES `sample` WRITE;
/*!40000 ALTER TABLE `sample` DISABLE KEYS */;
/*!40000 ALTER TABLE `sample` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sample_metadata`
--

DROP TABLE IF EXISTS `sample_metadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sample_metadata` (
  `SAMPLE_METADATA_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MOBEDAC_SAMPLE_ID` varchar(32) NOT NULL,
  `STUDY_ID` int(11) NOT NULL,
  `SAMPLE_NAME` varchar(300) DEFAULT NULL,
  `PUBLIC` char(1) DEFAULT NULL,
  `ASSIGNED_FROM_GEO` char(1) DEFAULT NULL,
  `ALTITUDE` float DEFAULT NULL,
  `CHEM_ADMINISTRATION` varchar(2000) DEFAULT NULL,
  `COLLECTION_DATE` varchar(200) DEFAULT NULL,
  `COUNTRY` varchar(200) DEFAULT NULL,
  `DEPTH` varchar(50) DEFAULT NULL,
  `ELEVATION` float DEFAULT NULL,
  `ENV_BIOME` varchar(200) DEFAULT NULL,
  `ENV_FEATURE` varchar(200) DEFAULT NULL,
  `ENV_MATTER` varchar(200) DEFAULT NULL,
  `ORGANISM_COUNT` double DEFAULT NULL,
  `OXY_STAT_SAMP` int(11) DEFAULT NULL,
  `PERTURBATION` varchar(1000) DEFAULT NULL,
  `PH` double DEFAULT NULL,
  `LATITUDE` float DEFAULT NULL,
  `LONGITUDE` float DEFAULT NULL,
  `SAMP_COLLECT_DEVICE` varchar(500) DEFAULT NULL,
  `SAMP_MAT_PROCESS` varchar(500) DEFAULT NULL,
  `SAMP_SALINITY` double DEFAULT NULL,
  `SAMP_SIZE` varchar(300) DEFAULT NULL,
  `SAMP_STORE_DUR` varchar(200) DEFAULT NULL,
  `SAMP_STORE_LOC` varchar(200) DEFAULT NULL,
  `SAMP_STORE_TEMP` double DEFAULT NULL,
  `TEMP` double DEFAULT NULL,
  `TITLE` varchar(500) DEFAULT NULL,
  `TAXON_ID` int(11) DEFAULT NULL,
  `COMMON_NAME` varchar(500) DEFAULT NULL,
  `ANONYMIZED_NAME` varchar(500) DEFAULT NULL,
  `DESCRIPTION` varchar(2000) DEFAULT NULL,
  `BIOLOGICAL_SPECIMEN` varchar(200) DEFAULT NULL,
  `EXTRACTED_DNA_AVAIL_NOW` char(1) DEFAULT NULL,
  `PHYSICAL_SAMP_AVAIL_NOW` char(1) DEFAULT NULL,
  `VAMPS_PROJECT` varchar(45) DEFAULT NULL,
  `VAMPS_DATASET` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sample_metadata`
--

LOCK TABLES `sample_metadata` WRITE;
/*!40000 ALTER TABLE `sample_metadata` DISABLE KEYS */;
INSERT INTO `sample_metadata` VALUES (258,'s1',1,NULL,'3','4',5,'233','7','8','9',10,'1','2','3',0,2,'2',2.4,8,9,'10','1',2.3,'3','4','5',6,7,'8',9,'10','1','2',NULL,NULL,NULL,'JJH_ICM_Av6','l1'),(259,'s1',1,NULL,'3','4',5,'233','7','8','9',10,'1','2','3',0,2,'2',2.4,8,9,'10','1',2.3,'3','4','5',6,7,'8',9,'10','1','2',NULL,NULL,NULL,'JJH_ICM_Bv6','l2'),(260,'s1',1,NULL,'3','4',5,'233','7','8','9',10,'1','2','3',0,2,'2',2.4,8,9,'10','1',2.3,'3','4','5',6,7,'8',9,'10','1','2',NULL,NULL,NULL,'JJH_ICM_Av6','l3');
/*!40000 ALTER TABLE `sample_metadata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sequence_prep`
--

DROP TABLE IF EXISTS `sequence_prep`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequence_prep` (
  `SEQUENCE_PREP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SAMPLE_METADATA_ID` int(11) NOT NULL,
  `NUCL_ACID_EXT` varchar(4000) DEFAULT NULL,
  `NUCL_ACID_AMP` varchar(4000) DEFAULT NULL,
  `LIB_SIZE` int(11) DEFAULT NULL,
  `LIB_READS_SEQD` int(11) DEFAULT NULL,
  `LIB_VECTOR` varchar(1000) DEFAULT NULL,
  `LIBR_SCREEN` varchar(1000) DEFAULT NULL,
  `TARGET_GENE` varchar(500) DEFAULT NULL,
  `TARGET_SUBFRAGMENT` varchar(500) DEFAULT NULL,
  `PCR_PRIMERS` varchar(2000) DEFAULT NULL,
  `MULTIPLEX_IDENT` varchar(500) DEFAULT NULL,
  `PCR_COND` varchar(2000) DEFAULT NULL,
  `SEQUENCING_METH` varchar(200) DEFAULT NULL,
  `SEQ_QUALITY_CHECK` int(11) DEFAULT NULL,
  `CHIMERA_CHECK` int(11) DEFAULT NULL,
  `SOP` varchar(1000) DEFAULT NULL,
  `URL` varchar(1000) DEFAULT NULL,
  `EXPERIMENT_ALIAS` varchar(500) DEFAULT NULL,
  `EXPERIMENT_CENTER` varchar(500) DEFAULT NULL,
  `EXPERIMENT_TITLE` varchar(500) DEFAULT NULL,
  `EXPERIMENT_ACCESSION` varchar(500) DEFAULT NULL,
  `STUDY_ACCESSION` varchar(500) DEFAULT NULL,
  `STUDY_REF` varchar(500) DEFAULT NULL,
  `STUDY_CENTER` varchar(500) DEFAULT NULL,
  `EXPERIMENT_DESIGN_DESCRIPTION` varchar(4000) DEFAULT NULL,
  `LIBRARY_CONSTRUCTION_PROTOCOL` varchar(4000) DEFAULT NULL,
  `SAMPLE_ACCESSION` varchar(500) DEFAULT NULL,
  `SAMPLE_ALIAS` varchar(500) DEFAULT NULL,
  `SAMPLE_CENTER` varchar(500) DEFAULT NULL,
  `POOL_MEMBER_ACCESSION` varchar(500) DEFAULT NULL,
  `POOL_MEMBER_NAME` varchar(500) DEFAULT NULL,
  `POOL_PROPORTION` varchar(500) DEFAULT NULL,
  `BARCODE_READ_GROUP_TAG` varchar(500) DEFAULT NULL,
  `BARCODE` varchar(500) DEFAULT NULL,
  `LINKER` varchar(500) DEFAULT NULL,
  `KEY_SEQ` varchar(500) DEFAULT NULL,
  `PRIMER_READ_GROUP_TAG` varchar(500) DEFAULT NULL,
  `PRIMER` varchar(500) DEFAULT NULL,
  `RUN_PREFIX` varchar(500) DEFAULT NULL,
  `REGION` varchar(500) DEFAULT NULL,
  `PLATFORM` varchar(500) DEFAULT NULL,
  `RUN_ACCESSION` varchar(500) DEFAULT NULL,
  `RUN_ALIAS` varchar(500) DEFAULT NULL,
  `RUN_CENTER` varchar(500) DEFAULT NULL,
  `RUN_DATE` varchar(500) DEFAULT NULL,
  `INSTRUMENT_NAME` varchar(500) DEFAULT NULL,
  `LIBRARY_STRATEGY` varchar(500) DEFAULT NULL,
  `LIBRARY_SOURCE` varchar(500) DEFAULT NULL,
  `LIBRARY_SELECTION` varchar(500) DEFAULT NULL,
  `ROW_INT` int(11) NOT NULL DEFAULT '-1',
  `VAMPS_PROJECT` varchar(45) NOT NULL,
  `VAMPS_DATASET` varchar(45) NOT NULL,
  PRIMARY KEY (`SEQUENCE_PREP_ID`),
  KEY `IDX_SP_SEQ_METH` (`SEQUENCING_METH`),
  KEY `IDX_SP_SEQ_QUAL_CHK` (`SEQ_QUALITY_CHECK`),
  KEY `IDX_SP_CHIMERA_CHECK` (`CHIMERA_CHECK`),
  KEY `IDX_SEQ_PREP_ROW_NUM` (`ROW_INT`),
  KEY `IDX_SEQ_PREP_RNUM_SAMPID` (`SAMPLE_METADATA_ID`,`ROW_INT`),
  CONSTRAINT `FK_SPREP_TO_SAMPLE_SAMPLE_METADATA_ID` FOREIGN KEY (`SAMPLE_METADATA_ID`) REFERENCES `SAMPLE_METADATA` (`SAMPLE_METADATA_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sequence_prep`
--

LOCK TABLES `sequence_prep` WRITE;
/*!40000 ALTER TABLE `sequence_prep` DISABLE KEYS */;
INSERT INTO `sequence_prep` VALUES (2,258,'NUCL_ACID_EXT','NUCL_ACID_AMP',2147483647,2147483647,'LIB_VECTOR','LIBR_SCREEN','TARGET_GENE','TARGET_SUBFRAGMENT','PCR_PRIMERS','MULTIPLEX_IDENT','PCR_COND','SEQUENCING_METH',333,2222,'SOP','URL','EXPERIMENT_ALIAS','EXPERIMENT_CENTER','EXPERIMENT_TITLE','EXPERIMENT_ACCESSION','STUDY_ACCESSION','STUDY_REF','STUDY_CENTER','EXPERIMENT_DESIGN_DESCRIPTION','LIBRARY_CONSTRUCTION_PROTOCOL','SAMPLE_ACCESSION','SAMPLE_ALIAS','SAMPLE_CENTER','POOL_MEMBER_ACCESSION','POOL_MEMBER_NAME','POOL_PROPORTION','BARCODE_READ_GROUP_TAG','BARCODE','LINKER','KEY_SEQ','PRIMER_READ_GROUP_TAG','PRIMER','RUN_PREFIX','v6','PLATFORM','RUN_ACCESSION','RUN_ALIAS','RUN_CENTER','RUN_DATE','INSTRUMENT_NAME','LIBRARY_STRATEGY','LIBRARY_SOURCE','LIBRARY_SELECTION',22,'JJH_ICM_Av6','l1'),(3,259,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'v6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,'JJH_ICM_Bv6','l2'),(4,260,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'v6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,-1,'JJH_ICM_Av6','l3');
/*!40000 ALTER TABLE `sequence_prep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sequenceset`
--

DROP TABLE IF EXISTS `sequenceset`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequenceset` (
  `id` varchar(64) NOT NULL,
  `name` varchar(250) NOT NULL,
  `about` varchar(1024) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `creation` datetime NOT NULL,
  `metadata` mediumtext,
  `type` varchar(256) DEFAULT NULL,
  `protein` tinyint(1) DEFAULT NULL,
  `library_id` varchar(64) NOT NULL,
  `provenance` mediumtext,
  `sequences` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `library_id` (`library_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sequenceset`
--

LOCK TABLES `sequenceset` WRITE;
/*!40000 ALTER TABLE `sequenceset` DISABLE KEYS */;
/*!40000 ALTER TABLE `sequenceset` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `submission`
--

DROP TABLE IF EXISTS `submission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `library_ids_str` varchar(1024) DEFAULT NULL,
  `analysis_params_str` varchar(1024) DEFAULT NULL,
  `user` varchar(32) DEFAULT NULL,
  `auth_key` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `submission`
--

LOCK TABLES `submission` WRITE;
/*!40000 ALTER TABLE `submission` DISABLE KEYS */;
INSERT INTO `submission` VALUES (218,'[\"l1\"]','{\"user\": \"mobedac\", \"auth\": \"asdfasdfasdf\"}','mobedac','asdfasdfasdf');
/*!40000 ALTER TABLE `submission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `submission_details`
--

DROP TABLE IF EXISTS `submission_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submission_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_id` int(11) DEFAULT NULL,
  `project_id` varchar(64) DEFAULT NULL,
  `sample_id` varchar(64) DEFAULT NULL,
  `library_id` varchar(64) DEFAULT NULL,
  `sequenceset_id` varchar(64) DEFAULT NULL,
  `vamps_project_name` varchar(64) DEFAULT NULL,
  `next_action` varchar(64) DEFAULT NULL,
  `vamps_status_record_id` varchar(45) DEFAULT NULL,
  `current_status_msg` varchar(512) DEFAULT NULL,
  `vamps_dataset_name` varchar(64) DEFAULT NULL,
  `region` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submission_id` (`submission_id`),
  CONSTRAINT `submission_details_ibfk_2` FOREIGN KEY (`submission_id`) REFERENCES `submission` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `submission_details`
--

LOCK TABLES `submission_details` WRITE;
/*!40000 ALTER TABLE `submission_details` DISABLE KEYS */;
INSERT INTO `submission_details` VALUES (322,218,'p1','s1','l1','icml1','JJH_ICM_Av6','processing_complete','232',NULL,'l1','v6');
/*!40000 ALTER TABLE `submission_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_test`
--

DROP TABLE IF EXISTS `type_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vcharcol` varchar(45) DEFAULT NULL,
  `intcol` int(11) DEFAULT NULL,
  `floatcol` float DEFAULT NULL,
  `doublecol` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_test`
--

LOCK TABLES `type_test` WRITE;
/*!40000 ALTER TABLE `type_test` DISABLE KEYS */;
INSERT INTO `type_test` VALUES (1,'33.1',46,39.5,NULL);
/*!40000 ALTER TABLE `type_test` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-05-23 14:13:46