-- MySQL dump 10.11
--
-- Host: localhost    Database: dln
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt

/*!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 `custom_items`
--

DROP TABLE IF EXISTS `custom_items`;
CREATE TABLE `custom_items` (
  `ItemID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned default NULL,
  `PageSource` varchar(45) default NULL,
  `ItemLabel` varchar(45) default NULL,
  `ItemInfo` varchar(1024) default NULL,
  PRIMARY KEY  (`ItemID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `custom_items`
--

LOCK TABLES `custom_items` WRITE;
/*!40000 ALTER TABLE `custom_items` DISABLE KEYS */;
INSERT INTO `custom_items` VALUES (1,1,'Project','Custom Item 1','This is a description for a custom item'),(2,1,'Project','Custom Item 2','Im shorter now!'),(3,1,'Project','NK Label','Happy New Year!!'),(4,2,'Project','Custom Item','Clean Up Project Custom Item Desc!'),(5,2,'Specimen','Specimen Custom','less mess'),(6,1,'Project','Button Test','Hi Im new!'),(7,1,'Specimen','Specimen Custom','My Spectacle'),(8,2,'Project','Test test','Blah Blah!');
/*!40000 ALTER TABLE `custom_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `extraction`
--

DROP TABLE IF EXISTS `extraction`;
CREATE TABLE `extraction` (
  `ExtractionID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `ProtocolID` int(10) unsigned default NULL,
  `ExtractedBy` int(10) unsigned default NULL,
  `ExtractionDate` datetime default NULL,
  `LocationFreezer` varchar(45) default NULL,
  `Comment` varchar(500) default NULL,
  `ExtractionName` varchar(45) default NULL,
  `TissueID` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ExtractionID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `extraction`
--

LOCK TABLES `extraction` WRITE;
/*!40000 ALTER TABLE `extraction` DISABLE KEYS */;
INSERT INTO `extraction` VALUES (1,2,NULL,NULL,NULL,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `extraction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `extraction_tube`
--

DROP TABLE IF EXISTS `extraction_tube`;
CREATE TABLE `extraction_tube` (
  `ExtractionTubeID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `TubeNumber` int(10) unsigned NOT NULL,
  `Volume` varchar(45) default NULL,
  `Solution` varchar(45) default NULL,
  `ExtractionID` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ExtractionTubeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `extraction_tube`
--

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

--
-- Table structure for table `pcr`
--

DROP TABLE IF EXISTS `pcr`;
CREATE TABLE `pcr` (
  `PCRID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `PCRProgramID` int(10) unsigned default NULL,
  `PCRRound` varchar(45) default NULL,
  `GeneRegion` varchar(45) default NULL,
  `GelImage` varchar(45) default NULL,
  `DatePerformed` datetime default NULL,
  `PerformedBy` int(10) unsigned default NULL,
  `Comment` varchar(500) default NULL,
  `Volume` varchar(45) default NULL,
  `ExtractionID` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`PCRID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pcr`
--

LOCK TABLES `pcr` WRITE;
/*!40000 ALTER TABLE `pcr` DISABLE KEYS */;
INSERT INTO `pcr` VALUES (1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `pcr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pcr_program`
--

DROP TABLE IF EXISTS `pcr_program`;
CREATE TABLE `pcr_program` (
  `PCRProgramID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `UserID` int(10) unsigned NOT NULL,
  `PCRProgramName` varchar(45) default NULL,
  `PCRProgramSeq` varchar(45) default NULL,
  `Gradient` varchar(45) default NULL,
  `Comment` varchar(500) default NULL,
  `Owner` int(10) unsigned NOT NULL,
  `Project` int(10) unsigned NOT NULL,
  `Global` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`PCRProgramID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pcr_program`
--

LOCK TABLES `pcr_program` WRITE;
/*!40000 ALTER TABLE `pcr_program` DISABLE KEYS */;
INSERT INTO `pcr_program` VALUES (1,2,1,'Program Alpha','Step 1 Step 2 Step 3','20','New Program',3,3,3);
/*!40000 ALTER TABLE `pcr_program` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pcr_program_project`
--

DROP TABLE IF EXISTS `pcr_program_project`;
CREATE TABLE `pcr_program_project` (
  `PCRProgramID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pcr_program_project`
--

LOCK TABLES `pcr_program_project` WRITE;
/*!40000 ALTER TABLE `pcr_program_project` DISABLE KEYS */;
INSERT INTO `pcr_program_project` VALUES (1,2);
/*!40000 ALTER TABLE `pcr_program_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pcr_tube`
--

DROP TABLE IF EXISTS `pcr_tube`;
CREATE TABLE `pcr_tube` (
  `PCRTubeID` int(10) unsigned NOT NULL auto_increment,
  `PCRID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL,
  `TubeNumber` int(10) unsigned NOT NULL,
  `ExtractionTubeID` int(10) unsigned default NULL,
  `ForwardPrimerID` int(10) unsigned default NULL,
  `ReversePrimerID` int(10) unsigned default NULL,
  `Success` varchar(45) default NULL,
  `MgConc` varchar(45) default NULL,
  `DyeUsed` varchar(45) default NULL,
  `DNAConc` varchar(45) default NULL,
  `DNAVolume` varchar(45) default NULL,
  `ThermalCycler` varchar(45) default NULL,
  `ExpectedSize` varchar(45) default NULL,
  `FragmentScore` varchar(45) default NULL,
  `PostProcess` varchar(45) default NULL,
  `TaqBrand` varchar(45) default NULL,
  `TaqVolume` varchar(45) default NULL,
  `BSA` varchar(45) default NULL,
  `AdditiveDetail` varchar(200) default NULL,
  `Comment` varchar(500) default NULL,
  PRIMARY KEY  (`PCRTubeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pcr_tube`
--

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `PermissionID` int(10) unsigned NOT NULL,
  `Permission` char(1) NOT NULL,
  `PermissionDesc` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'x','None'),(2,'r','Read Only'),(3,'w','Read/Write');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `primer`;
CREATE TABLE `primer` (
  `PrimerID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `PrimerName` varchar(45) default NULL,
  `Sequence` varchar(45) default NULL,
  `AnnealingTemp` varchar(45) default NULL,
  `StockConc` varchar(45) default NULL,
  `PrimerSheet` varchar(45) default NULL,
  `DateOrdered` datetime default NULL,
  `OrderedBy` int(10) unsigned default NULL,
  `UserID` int(10) unsigned NOT NULL,
  `Gene` varchar(45) default NULL,
  `Owner` int(10) unsigned NOT NULL,
  `Project` int(10) unsigned NOT NULL,
  `Global` int(10) unsigned NOT NULL,
  `Comment` varchar(200) default NULL,
  PRIMARY KEY  (`PrimerID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

LOCK TABLES `primer` WRITE;
/*!40000 ALTER TABLE `primer` DISABLE KEYS */;
INSERT INTO `primer` VALUES (1,2,'Primer A','AAGGTTCC','23','5%',NULL,NULL,1,1,NULL,3,3,3,'New Primer');
/*!40000 ALTER TABLE `primer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `primer_pictures`
--

DROP TABLE IF EXISTS `primer_pictures`;
CREATE TABLE `primer_pictures` (
  `PrimerID` int(10) unsigned NOT NULL,
  `PhotoName` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `primer_pictures`
--

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

--
-- Table structure for table `primer_project`
--

DROP TABLE IF EXISTS `primer_project`;
CREATE TABLE `primer_project` (
  `PrimerID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `primer_project`
--

LOCK TABLES `primer_project` WRITE;
/*!40000 ALTER TABLE `primer_project` DISABLE KEYS */;
INSERT INTO `primer_project` VALUES (1,2);
/*!40000 ALTER TABLE `primer_project` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `ProjectID` int(10) unsigned NOT NULL auto_increment,
  `ProjectName` varchar(50) NOT NULL,
  `ProjectStartDate` date default NULL,
  `ProjectEndDate` date default NULL,
  `ProjectDesc` varchar(100) default NULL,
  `ProjectOwner` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ProjectID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
INSERT INTO `project` VALUES (1,'Test OnLoad 3',NULL,NULL,'New Desc',0),(2,'Clean Up','2008-01-01','2009-06-01','with specimen',0);
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `protocol`
--

DROP TABLE IF EXISTS `protocol`;
CREATE TABLE `protocol` (
  `ProtocolID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `UserID` int(10) unsigned NOT NULL,
  `ProtocolName` varchar(45) default NULL,
  `ProtocolRecipe` varchar(45) default NULL,
  `Owner` int(10) unsigned NOT NULL,
  `Project` int(10) unsigned NOT NULL,
  `Global` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ProtocolID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `protocol`
--

LOCK TABLES `protocol` WRITE;
/*!40000 ALTER TABLE `protocol` DISABLE KEYS */;
INSERT INTO `protocol` VALUES (1,2,1,'Protocol 1','Step 1 Step 2',3,3,3);
/*!40000 ALTER TABLE `protocol` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `protocol_project`
--

DROP TABLE IF EXISTS `protocol_project`;
CREATE TABLE `protocol_project` (
  `ProtocolID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `protocol_project`
--

LOCK TABLES `protocol_project` WRITE;
/*!40000 ALTER TABLE `protocol_project` DISABLE KEYS */;
INSERT INTO `protocol_project` VALUES (1,2);
/*!40000 ALTER TABLE `protocol_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `specimen`
--

DROP TABLE IF EXISTS `specimen`;
CREATE TABLE `specimen` (
  `SpecimenID` int(10) unsigned NOT NULL auto_increment,
  `ProjectID` int(10) unsigned NOT NULL,
  `CollectorNo` varchar(45) default NULL,
  `HostID` varchar(45) default NULL,
  `DateCollected` date default NULL,
  `Locality` varchar(45) default NULL,
  `GPSCoord` varchar(45) default NULL,
  `Institution` varchar(45) default NULL,
  `HowStored` varchar(45) default NULL,
  `Comment` varchar(500) default NULL,
  `UserID` int(10) unsigned NOT NULL,
  `Owner` varchar(45) NOT NULL,
  `Project` varchar(45) NOT NULL,
  `Global` varchar(45) NOT NULL,
  `Taxonomy` varchar(100) default NULL,
  `LSID` varchar(45) default NULL,
  PRIMARY KEY  (`SpecimenID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `specimen`
--

LOCK TABLES `specimen` WRITE;
/*!40000 ALTER TABLE `specimen` DISABLE KEYS */;
INSERT INTO `specimen` VALUES (1,2,'LM-6865','1','2008-02-24','Here','','Depaul','','',1,'1','2','0','',''),(2,2,'Collector Number','Host ID','2008-02-25','Locality','GPS Coord','Institution','How Stored!','How Stored!',1,'3','2','0','Taxonomy','LS-ID');
/*!40000 ALTER TABLE `specimen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `specimen_project`
--

DROP TABLE IF EXISTS `specimen_project`;
CREATE TABLE `specimen_project` (
  `SpecimenID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `specimen_project`
--

LOCK TABLES `specimen_project` WRITE;
/*!40000 ALTER TABLE `specimen_project` DISABLE KEYS */;
INSERT INTO `specimen_project` VALUES (1,2),(2,2);
/*!40000 ALTER TABLE `specimen_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tissue`
--

DROP TABLE IF EXISTS `tissue`;
CREATE TABLE `tissue` (
  `TissueID` int(10) unsigned NOT NULL auto_increment,
  `SpecimenID` int(10) unsigned default NULL,
  `ProjectID` int(10) unsigned NOT NULL,
  `HostID` varchar(45) default NULL,
  `TissueNo` varchar(45) default NULL,
  `TissueType` varchar(45) default NULL,
  `TissueAmount` varchar(45) default NULL,
  `Institution` varchar(45) default NULL,
  `HowStored` varchar(45) default NULL,
  `Comment` varchar(500) default NULL,
  `UserID` int(10) unsigned NOT NULL,
  `Owner` int(10) unsigned NOT NULL,
  `Project` int(10) unsigned NOT NULL,
  `Global` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`TissueID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tissue`
--

LOCK TABLES `tissue` WRITE;
/*!40000 ALTER TABLE `tissue` DISABLE KEYS */;
INSERT INTO `tissue` VALUES (1,1,2,NULL,'Tissue 1','Muscle','5 grams','Field Museum','Freeze Dried','New Tissue',1,3,3,3);
/*!40000 ALTER TABLE `tissue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tissue_project`
--

DROP TABLE IF EXISTS `tissue_project`;
CREATE TABLE `tissue_project` (
  `TissueID` int(10) unsigned NOT NULL,
  `SpecimenID` int(10) unsigned NOT NULL,
  `ProjectID` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tissue_project`
--

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `UserID` int(10) unsigned NOT NULL auto_increment,
  `FName` varchar(50) NOT NULL,
  `LName` varchar(50) NOT NULL,
  `Login` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  PRIMARY KEY  (`UserID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Bryan','Beaumont','bbeaumon','welcome'),(2,'Pablo','Picasso','ppicasso','welcome'),(3,'Albert','Einstein','emc','welcome'),(4,'Rick','Ree','rree','welcome'),(5,'David','Angulo','dangulo','welcome'),(6,'Sammer','Kins','sammi','welcome'),(7,'Shannon','Hackett','shackett','welcome');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_project`
--

DROP TABLE IF EXISTS `user_project`;
CREATE TABLE `user_project` (
  `UserID` int(10) unsigned NOT NULL default '0',
  `ProjectID` int(10) unsigned NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_project`
--

LOCK TABLES `user_project` WRITE;
/*!40000 ALTER TABLE `user_project` DISABLE KEYS */;
INSERT INTO `user_project` VALUES (1,1),(3,1),(2,1),(1,2);
/*!40000 ALTER TABLE `user_project` 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 2008-04-28  2:12:17