API tools faq
paste
Advertisement
RoniElBombardero

Data Dump ncisvn.nci.nih.gov by roni bombardero

RoniElBombardero
Mar 18th, 2013
415
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 72.46 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.9
  2. --
  3. -- Host: 127.0.0.1 Database: gss
  4. -- ------------------------------------------------------
  5. -- Server version 5.0.51b-community-nt
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  12. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  13. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  14. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  15.  
  16. --
  17. -- Table structure for table `data_service_group`
  18. --
  19.  
  20. DROP TABLE IF EXISTS `data_service_group`;
  21. CREATE TABLE `data_service_group` (
  22. `ID` bigint(20) NOT NULL auto_increment,
  23. `NAME` varchar(512) NOT NULL,
  24. `CAB2B_NAME` varchar(512) NOT NULL,
  25. `DATA_PRIMARY_KEY` varchar(512) NOT NULL,
  26. PRIMARY KEY (`ID`)
  27. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  28.  
  29. --
  30. -- Dumping data for table `data_service_group`
  31. --
  32.  
  33. LOCK TABLES `data_service_group` WRITE;
  34. /*!40000 ALTER TABLE `data_service_group` DISABLE KEYS */;
  35. INSERT INTO `data_service_group` VALUES (1,'microarray','Microarray Data','Experiment Public Identifier'),(2,'biospecimen','Biospecimen Data','Barcode'),(3,'imaging','Imaging Data','Image Study Instance UID'),(4,'nanoparticle','Nanoparticle data','');
  36. /*!40000 ALTER TABLE `data_service_group` ENABLE KEYS */;
  37. UNLOCK TABLES;
  38.  
  39. --
  40. -- Table structure for table `domain_class`
  41. --
  42.  
  43. DROP TABLE IF EXISTS `domain_class`;
  44. CREATE TABLE `domain_class` (
  45. `ID` bigint(20) NOT NULL,
  46. `CLASS_NAME` varchar(512) default NULL,
  47. `DESCRIPTION` varchar(2000) default NULL,
  48. `DOMAIN_PACKAGE` varchar(512) default NULL,
  49. `DOMAIN_MODEL_ID` bigint(20) NOT NULL,
  50. PRIMARY KEY (`ID`)
  51. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  52.  
  53. --
  54. -- Dumping data for table `domain_class`
  55. --
  56.  
  57. LOCK TABLES `domain_class` WRITE;
  58. /*!40000 ALTER TABLE `domain_class` DISABLE KEYS */;
  59. INSERT INTO `domain_class` VALUES (1,'DerivedDataElement',NULL,'gov.nih.nci.cadsr.domain',1),(2,'ValidValue',NULL,'gov.nih.nci.cadsr.domain',1),(3,'DefinitionClassSchemeItem',NULL,'gov.nih.nci.cadsr.domain',1),(4,'ObjectClass',NULL,'gov.nih.nci.cadsr.domain',1),(5,'ClassificationScheme',NULL,'gov.nih.nci.cadsr.domain',1),(6,'DerivationType',NULL,'gov.nih.nci.cadsr.domain',1),(7,'Module',NULL,'gov.nih.nci.cadsr.domain',1),(8,'DesignationClassSchemeItem',NULL,'gov.nih.nci.cadsr.domain',1),(9,'Registration',NULL,'gov.nih.nci.cadsr.domain',1),(10,'DataElementRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(11,'Form',NULL,'gov.nih.nci.cadsr.domain',1),(12,'Question',NULL,'gov.nih.nci.cadsr.domain',1),(13,'Designation',NULL,'gov.nih.nci.cadsr.domain',1),(14,'DataElementConcept',NULL,'gov.nih.nci.cadsr.domain',1),(15,'ClassificationSchemeRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(16,'NonenumeratedValueDomain',NULL,'gov.nih.nci.cadsr.domain',1),(17,'DataElement',NULL,'gov.nih.nci.cadsr.domain',1),(18,'ConceptDerivationRule',NULL,'gov.nih.nci.cadsr.domain',1),(19,'QuestionCondition',NULL,'gov.nih.nci.cadsr.domain',1),(20,'ClassificationSchemeItemRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(21,'ComponentLevel',NULL,'gov.nih.nci.cadsr.domain',1),(22,'FormElement',NULL,'gov.nih.nci.cadsr.domain',1),(23,'AdministeredComponentClassSchemeItem',NULL,'gov.nih.nci.cadsr.domain',1),(24,'Organization',NULL,'gov.nih.nci.cadsr.domain',1),(25,'Concept',NULL,'gov.nih.nci.cadsr.domain',1),(26,'ReferenceDocument',NULL,'gov.nih.nci.cadsr.domain',1),(27,'Person',NULL,'gov.nih.nci.cadsr.domain',1),(28,'Instruction',NULL,'gov.nih.nci.cadsr.domain',1),(29,'DataElementDerivation',NULL,'gov.nih.nci.cadsr.domain',1),(30,'AdministeredComponentContact',NULL,'gov.nih.nci.cadsr.domain',1),(31,'ValueDomainRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(32,'DataElementConceptRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(33,'QuestionRepetition',NULL,'gov.nih.nci.cadsr.domain',1),(34,'AdministeredComponent',NULL,'gov.nih.nci.cadsr.domain',1),(35,'ConditionMessage',NULL,'gov.nih.nci.cadsr.domain',1),(36,'ContactCommunication',NULL,'gov.nih.nci.cadsr.domain',1),(37,'QuestionConditionComponents',NULL,'gov.nih.nci.cadsr.domain',1),(38,'ClassSchemeClassSchemeItem',NULL,'gov.nih.nci.cadsr.domain',1),(39,'Function',NULL,'gov.nih.nci.cadsr.domain',1),(40,'ValueDomain',NULL,'gov.nih.nci.cadsr.domain',1),(41,'ComponentConcept',NULL,'gov.nih.nci.cadsr.domain',1),(42,'ValueMeaning',NULL,'gov.nih.nci.cadsr.domain',1),(43,'PermissibleValue',NULL,'gov.nih.nci.cadsr.domain',1),(44,'TriggerAction',NULL,'gov.nih.nci.cadsr.domain',1),(45,'ObjectClassRelationship',NULL,'gov.nih.nci.cadsr.domain',1),(46,'Address',NULL,'gov.nih.nci.cadsr.domain',1),(47,'Context',NULL,'gov.nih.nci.cadsr.domain',1),(48,'Definition',NULL,'gov.nih.nci.cadsr.domain',1),(49,'ClassificationSchemeItem',NULL,'gov.nih.nci.cadsr.domain',1),(50,'ValueDomainPermissibleValue',NULL,'gov.nih.nci.cadsr.domain',1),(51,'ReferenceDocumentAttachment',NULL,'gov.nih.nci.cadsr.domain',1),(52,'EnumeratedValueDomain',NULL,'gov.nih.nci.cadsr.domain',1),(53,'Representation',NULL,'gov.nih.nci.cadsr.domain',1),(54,'Property',NULL,'gov.nih.nci.cadsr.domain',1),(55,'ConceptualDomain',NULL,'gov.nih.nci.cadsr.domain',1),(56,'Protocol',NULL,'gov.nih.nci.cadsr.domain',1),(57,'UMLAttributeMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(58,'Project',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(59,'UMLGeneralizationMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(60,'UMLAssociationMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(61,'UMLPackageMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(62,'UMLClassMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(63,'SemanticMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(64,'SubProject',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(65,'TypeEnumerationMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(66,'AttributeTypeMetadata',NULL,'gov.nih.nci.cadsr.umlproject.domain',1),(67,'CRFVersion',NULL,'org.cvrg.domain',2),(68,'CRFSection',NULL,'org.cvrg.domain',2),(69,'StudyEvent',NULL,'org.cvrg.domain',2),(70,'StudyEventDefinition',NULL,'org.cvrg.domain',2),(71,'Subject',NULL,'org.cvrg.domain',2),(72,'Study',NULL,'org.cvrg.domain',2),(73,'CRFItem',NULL,'org.cvrg.domain',2),(74,'CaseReportForm',NULL,'org.cvrg.domain',2),(75,'CRFItemData',NULL,'org.cvrg.domain',2),(76,'CRFItemDataType',NULL,'org.cvrg.domain',2),(77,'Address',NULL,'edu.wustl.catissuecore.domain',3),(78,'CollectionEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(79,'SpecimenProtocol',NULL,'edu.wustl.catissuecore.domain',3),(80,'FluidSpecimenReviewEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(81,'TissueSpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(82,'ProcedureEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(83,'CellSpecimenReviewParameters',NULL,'edu.wustl.catissuecore.domain',3),(84,'NewSpecimenOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(85,'SpecimenCollectionGroup',NULL,'edu.wustl.catissuecore.domain',3),(86,'Institution',NULL,'edu.wustl.catissuecore.domain',3),(87,'OrderDetails',NULL,'edu.wustl.catissuecore.domain',3),(88,'StorageType',NULL,'edu.wustl.catissuecore.domain',3),(89,'ReviewEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(90,'ConsentTierResponse',NULL,'edu.wustl.catissuecore.domain',3),(91,'MolecularSpecimen',NULL,'edu.wustl.catissuecore.domain',3),(92,'ExternalIdentifier',NULL,'edu.wustl.catissuecore.domain',3),(93,'SpecimenOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(94,'AbstractSpecimenCollectionGroup',NULL,'edu.wustl.catissuecore.domain',3),(95,'ExistingSpecimenArrayOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(96,'OrderItem',NULL,'edu.wustl.catissuecore.domain',3),(97,'Capacity',NULL,'edu.wustl.catissuecore.domain',3),(98,'CancerResearchGroup',NULL,'edu.wustl.catissuecore.domain',3),(99,'SpunEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(100,'ParticipantMedicalIdentifier',NULL,'edu.wustl.catissuecore.domain',3),(101,'DistributionSpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(102,'TissueSpecimenReviewEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(103,'Site',NULL,'edu.wustl.catissuecore.domain',3),(104,'FluidSpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(105,'SpecimenArrayType',NULL,'edu.wustl.catissuecore.domain',3),(106,'PathologicalCaseOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(107,'SpecimenPosition',NULL,'edu.wustl.catissuecore.domain',3),(108,'AbstractSpecimen',NULL,'edu.wustl.catissuecore.domain',3),(109,'TissueSpecimen',NULL,'edu.wustl.catissuecore.domain',3),(110,'MolecularSpecimenReviewParameters',NULL,'edu.wustl.catissuecore.domain',3),(111,'Biohazard',NULL,'edu.wustl.catissuecore.domain',3),(112,'ConsentTier',NULL,'edu.wustl.catissuecore.domain',3),(113,'CheckInCheckOutEventParameter',NULL,'edu.wustl.catissuecore.domain',3),(114,'DistributionProtocol',NULL,'edu.wustl.catissuecore.domain',3),(115,'ConsentTierStatus',NULL,'edu.wustl.catissuecore.domain',3),(116,'SpecimenEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(117,'CollectionProtocolRegistration',NULL,'edu.wustl.catissuecore.domain',3),(118,'SpecimenArrayContent',NULL,'edu.wustl.catissuecore.domain',3),(119,'MolecularSpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(120,'DistributedItem',NULL,'edu.wustl.catissuecore.domain',3),(121,'CollectionProtocolEvent',NULL,'edu.wustl.catissuecore.domain',3),(122,'Specimen',NULL,'edu.wustl.catissuecore.domain',3),(123,'FluidSpecimen',NULL,'edu.wustl.catissuecore.domain',3),(124,'ExistingSpecimenOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(125,'SpecimenCharacteristics',NULL,'edu.wustl.catissuecore.domain',3),(126,'User',NULL,'edu.wustl.catissuecore.domain',3),(127,'FixedEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(128,'ReturnEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(129,'Department',NULL,'edu.wustl.catissuecore.domain',3),(130,'ReportedProblem',NULL,'edu.wustl.catissuecore.domain',3),(131,'SpecimenArray',NULL,'edu.wustl.catissuecore.domain',3),(132,'TransferEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(133,'CollectionProtocol',NULL,'edu.wustl.catissuecore.domain',3),(134,'Race',NULL,'edu.wustl.catissuecore.domain',3),(135,'DisposalEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(136,'Password',NULL,'edu.wustl.catissuecore.domain',3),(137,'CellSpecimen',NULL,'edu.wustl.catissuecore.domain',3),(138,'CellSpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(139,'Participant',NULL,'edu.wustl.catissuecore.domain',3),(140,'AbstractPosition',NULL,'edu.wustl.catissuecore.domain',3),(141,'ContainerPosition',NULL,'edu.wustl.catissuecore.domain',3),(142,'SpecimenRequirement',NULL,'edu.wustl.catissuecore.domain',3),(143,'ReceivedEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(144,'Distribution',NULL,'edu.wustl.catissuecore.domain',3),(145,'SpecimenArrayOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(146,'Container',NULL,'edu.wustl.catissuecore.domain',3),(147,'StorageContainer',NULL,'edu.wustl.catissuecore.domain',3),(148,'NewSpecimenArrayOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(149,'ThawEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(150,'DerivedSpecimenOrderItem',NULL,'edu.wustl.catissuecore.domain',3),(151,'EmbeddedEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(152,'FrozenEventParameters',NULL,'edu.wustl.catissuecore.domain',3),(153,'ContainerType',NULL,'edu.wustl.catissuecore.domain',3),(154,'XMLContent',NULL,'edu.wustl.catissuecore.domain.pathology',3),(155,'ConceptReferent',NULL,'edu.wustl.catissuecore.domain.pathology',3),(156,'SemanticType',NULL,'edu.wustl.catissuecore.domain.pathology',3),(157,'TextContent',NULL,'edu.wustl.catissuecore.domain.pathology',3),(158,'QuarantineEventParameter',NULL,'edu.wustl.catissuecore.domain.pathology',3),(159,'DeidentifiedSurgicalPathologyReport',NULL,'edu.wustl.catissuecore.domain.pathology',3),(160,'IdentifiedSurgicalPathologyReport',NULL,'edu.wustl.catissuecore.domain.pathology',3),(161,'ReportSection',NULL,'edu.wustl.catissuecore.domain.pathology',3),(162,'ConceptReferentClassification',NULL,'edu.wustl.catissuecore.domain.pathology',3),(163,'ReportContent',NULL,'edu.wustl.catissuecore.domain.pathology',3),(164,'BinaryContent',NULL,'edu.wustl.catissuecore.domain.pathology',3),(165,'SurgicalPathologyReport',NULL,'edu.wustl.catissuecore.domain.pathology',3),(166,'PathologyReportReviewParameter',NULL,'edu.wustl.catissuecore.domain.pathology',3),(167,'Concept',NULL,'edu.wustl.catissuecore.domain.pathology',3),(168,'Shipment',NULL,'edu.wustl.catissuecore.domain.shippingtracking',3),(169,'ShipmentRequest',NULL,'edu.wustl.catissuecore.domain.shippingtracking',3),(170,'BaseShipment',NULL,'edu.wustl.catissuecore.domain.shippingtracking',3),(171,'ArrayReporter','A generic object to represent features on a particular array platform for measuring specific biological signals, such as genotype for SNP array, and levels of gene transcription products for Expression and Exon arrays.','gov.nih.nci.cabio.domain',4),(172,'TermSource','A database or other repository of a controlled vocabulary.','gov.nih.nci.caarray.domain.vocabulary',4),(173,'Category','The fundamental classification to which a term belongs.','gov.nih.nci.caarray.domain.vocabulary',4),(174,'Term','A word or expression that has a precise meaning.','gov.nih.nci.caarray.domain.vocabulary',4),(175,'TranscriptArrayReporter','A generic object to represent features on a particular array platform for measuring gene transcription products, e.g. Expression and Exon arrays.','gov.nih.nci.cabio.domain',4),(176,'SNPArrayReporter','An object to represent features on SNP mapping microarrays for measuring genotypes in regard to SNPs.','gov.nih.nci.cabio.domain',4),(177,'ExonArrayReporter','An object to represent the features on Exon arrays designed to measure levels of RNAs containing the Exon.','gov.nih.nci.cabio.domain',4),(178,'ExpressionArrayReporter','An object to represent features on expression microarrays for measuring levels of transcripts of genes.','gov.nih.nci.cabio.domain',4),(179,'Publication','An artical or other reference released for distribution about or related to an experiment.','gov.nih.nci.caarray.domain.publication',4),(180,'MeasurementCharacteristic','An innate property of a biological material that can be explicitly quantified.','gov.nih.nci.caarray.domain.sample',4),(181,'AbstractBioMaterial','The base representation of the important substances in a microarray experiment such as cells, tissues, DNA, proteins, etc.','gov.nih.nci.caarray.domain.sample',4),(182,'LabeledExtract','Extracted genomic material that has been marked with a detectable compound (these are often fluorescent or reactive moieties).','gov.nih.nci.caarray.domain.sample',4),(183,'AbstractCharacteristic','The innate properties of the biological material, such as genotype, cultivar, tissue type, cell type, ploidy, etc. ','gov.nih.nci.caarray.domain.sample',4),(184,'Source','The original biological source material before any treatment events.','gov.nih.nci.caarray.domain.sample',4),(185,'Sample','An amount of tissue or cell culture that is used in the course of a microarray experiment.','gov.nih.nci.caarray.domain.sample',4),(186,'TermBasedCharacteristic','An innate property of a biological material that can be specified by an entry in an ontology.','gov.nih.nci.caarray.domain.sample',4),(187,'Extract','The genomic material (mRNA or cDNA) obtained from a biological sample.','gov.nih.nci.caarray.domain.sample',4),(188,'Project','The top-level container of a microarray experiment and its dependent files.','gov.nih.nci.caarray.domain.project',4),(189,'FactorValue','Specifies the value supplied for a dependent variable of an experiment.','gov.nih.nci.caarray.domain.project',4),(190,'ExperimentContact','A party (person or organization) that has a direct association with an experiment.','gov.nih.nci.caarray.domain.project',4),(191,'Parameter','Represents a named, replaceable value in a protocol.. Examples of parameters include: scanning wavelength, laser power, centrifuge speed, multiplicative errors, the number of input nodes to a SOM, and PCR temperatures.','gov.nih.nci.caarray.domain.protocol',4),(192,'Protocol','A parameterizable description of a method.','gov.nih.nci.caarray.domain.protocol',4),(193,'ProtocolApplication','The act of employing a protocol.','gov.nih.nci.caarray.domain.protocol',4),(194,'ParameterValue','The actual argument supplied for a replaceable parameter.','gov.nih.nci.caarray.domain.protocol',4),(195,'StringColumn','Contains textual data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(196,'QuantitationType','Identifies how to interpret a given data column of micorarray data (single datum of the matrix (e.g. raw intensity, background, error).','gov.nih.nci.caarray.domain.data',4),(197,'DoubleColumn','Contains floating point data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(198,'IntegerColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(199,'CaArrayFile','A binary or textual computer file that contains microarray data or other information of interest in a microarray experiment.','gov.nih.nci.caarray.domain.file',4),(200,'Hybridization','The act of appying a biological material to a microarray resulting in the genomic material binding to design elements on the array.','gov.nih.nci.caarray.domain.hybridization',4),(201,'Factor','A dependent variable of an experiment (e.g. time, glucose concentration, ...)','gov.nih.nci.caarray.domain.project',4),(202,'Experiment','The methodological investigation of a scientific hypothesis.','gov.nih.nci.caarray.domain.project',4),(203,'DesignElementList','Contains an ordered list of the microarray design elements (features or probes) for which data values are provided.','gov.nih.nci.caarray.domain.data',4),(204,'DataRetrievalRequest','Used by clients to specify precisely which microarray data are to be returned.','gov.nih.nci.caarray.domain.data',4),(205,'AbstractArrayData','The quantified results extracted from the design elements of one or many microarrays.','gov.nih.nci.caarray.domain.data',4),(206,'BooleanColumn','Contains boolean (true, false) data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(207,'FloatColumn','Contains floating point data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(208,'AbstractDataColumn','Contains all of the data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(209,'DerivedArrayData','The quantified results returned by normalizing or otherwise transforming raw array data signal values extracted from the design elements of one or many microarrays.','gov.nih.nci.caarray.domain.data',4),(210,'RawArrayData','The quantified results returned by extracting the signal values from the design elements from one hybridized microarray.','gov.nih.nci.caarray.domain.data',4),(211,'AbstractContact','A party (organization or person) of interest in the application.','gov.nih.nci.caarray.domain.contact',4),(212,'Address','Specifies a destination to which postal mail may be delivered.','gov.nih.nci.caarray.domain.contact',4),(213,'ArrayDataType','Defines the data format associated with a set of microarray data.','gov.nih.nci.caarray.domain.data',4),(214,'Image','A high-resolution scanned image (e.g. TIFF format) of a microarray surface after hybridization.','gov.nih.nci.caarray.domain.data',4),(215,'HybridizationData','Container for the quantified values extracted from a single hybridized mircoarray.','gov.nih.nci.caarray.domain.data',4),(216,'ShortColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(217,'LongColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',4),(218,'DataSet','A container for all of the data values extracted from a microarray data file.','gov.nih.nci.caarray.domain.data',4),(219,'LogicalProbe','A collection of reporters that together provide the quantification of a single genomic sequence.','gov.nih.nci.caarray.domain.array',4),(220,'ExpressionProbeAnnotation','Represents the biological information associated with a probe on a gene expression array designed to measure levels of RNAs for a specific gene sequence.','gov.nih.nci.caarray.domain.array',4),(221,'ProbeGroup','A logical grouping of probes with a similar function (e.g.. experimental, control, etc.)','gov.nih.nci.caarray.domain.array',4),(222,'Gene','A hereditary unit consisting of a sequence of DNA that occupies a specific location on a chromosome and determines a particular characteristic in an organism. The functional and physical unit of heredity passed from parent to offspring.','gov.nih.nci.caarray.domain.array',4),(223,'PhysicalProbe','A reporter with a specific location on a microarray that quantities the amount of a specifc genomic sequence.','gov.nih.nci.caarray.domain.array',4),(224,'ExonProbeAnnotation','Represents the biologoical information reported by a specific probe on an Exon array designed to measure levels of RNAs containing the Exon.','gov.nih.nci.caarray.domain.array',4),(225,'Organization','Entities such as companies, universities, government agencies of interest in the application.','gov.nih.nci.caarray.domain.contact',4),(226,'Person','An individual of interest within the application.','gov.nih.nci.caarray.domain.contact',4),(227,'ArrayDesignDetails','Container for the physical layout of the design (i.e. feature location and reporter associations) and higher level genomic sequences reported by the design.','gov.nih.nci.caarray.domain.array',4),(228,'ArrayDesign','Describes the shared layout of genomic reporters of a number of identical microarrays. In some cases this might be virtual and, for instance, represent the output from analysis software at the composite level without physical reporters or features.','gov.nih.nci.caarray.domain.array',4),(229,'AbstractDesignElement','An element of a microarray design that can report a quantified value.','gov.nih.nci.caarray.domain.array',4),(230,'Feature','Identifies a physical location on a microarray.','gov.nih.nci.caarray.domain.array',4),(231,'AbstractProbe','An element that represents some biological material (clone, oligo, etc.) on an array which will report on some biosequence or biosequences.','gov.nih.nci.caarray.domain.array',4),(232,'AbstractProbeAnnotation','A generic object to represent the genomic information associated with a given array reporter for measuring specific biological signals, such as genotype for SNP array, and levels of gene transcription products for Expression and Exon arrays.','gov.nih.nci.caarray.domain.array',4),(233,'Array','A collection of microscopic features/reporters, such as DNA fragments, arrayed on a solid surface.','gov.nih.nci.caarray.domain.array',4),(234,'SNPProbeAnnotation','Represents the biological information associated with a probe on a SNP array designed for measuring genotypes in regard to SNPs.','gov.nih.nci.caarray.domain.array',4),(235,'Organism','Organism that the sample or data comes from.','edu.georgetown.pir',4),(236,'AdditionalOrganismName','Other common or scientific names by which the organism known.','edu.georgetown.pir',4),(237,'AbstractCaArrayObject','An instance of a persistent object.','gov.nih.nci.caarray.domain',4),(238,'AbstractCaArrayEntity','An instance of an identifiable object with a unique Life Science Identifier.','gov.nih.nci.caarray.domain',4),(239,'ArrayGroup','Represents multiple independent microarrays attached to the same physical substrate.','gov.nih.nci.caarray.domain.array',4),(240,'ArrayReporter','A generic object to represent features on a particular array platform for measuring specific biological signals, such as genotype for SNP array, and levels of gene transcription products for Expression and Exon arrays.','gov.nih.nci.cabio.domain',5),(241,'TermSource','A database or other repository of a controlled vocabulary.','gov.nih.nci.caarray.domain.vocabulary',5),(242,'Category','The fundamental classification to which a term belongs.','gov.nih.nci.caarray.domain.vocabulary',5),(243,'Term','A word or expression that has a precise meaning.','gov.nih.nci.caarray.domain.vocabulary',5),(244,'TranscriptArrayReporter','A generic object to represent features on a particular array platform for measuring gene transcription products, e.g. Expression and Exon arrays.','gov.nih.nci.cabio.domain',5),(245,'SNPArrayReporter','An object to represent features on SNP mapping microarrays for measuring genotypes in regard to SNPs.','gov.nih.nci.cabio.domain',5),(246,'ExonArrayReporter','An object to represent the features on Exon arrays designed to measure levels of RNAs containing the Exon.','gov.nih.nci.cabio.domain',5),(247,'ExpressionArrayReporter','An object to represent features on expression microarrays for measuring levels of transcripts of genes.','gov.nih.nci.cabio.domain',5),(248,'Publication','An artical or other reference released for distribution about or related to an experiment.','gov.nih.nci.caarray.domain.publication',5),(249,'MeasurementCharacteristic','An innate property of a biological material that can be explicitly quantified.','gov.nih.nci.caarray.domain.sample',5),(250,'AbstractBioMaterial','The base representation of the important substances in a microarray experiment such as cells, tissues, DNA, proteins, etc.','gov.nih.nci.caarray.domain.sample',5),(251,'LabeledExtract','Extracted genomic material that has been marked with a detectable compound (these are often fluorescent or reactive moieties).','gov.nih.nci.caarray.domain.sample',5),(252,'AbstractCharacteristic','The innate properties of the biological material, such as genotype, cultivar, tissue type, cell type, ploidy, etc. ','gov.nih.nci.caarray.domain.sample',5),(253,'Source','The original biological source material before any treatment events.','gov.nih.nci.caarray.domain.sample',5),(254,'Sample','An amount of tissue or cell culture that is used in the course of a microarray experiment.','gov.nih.nci.caarray.domain.sample',5),(255,'TermBasedCharacteristic','An innate property of a biological material that can be specified by an entry in an ontology.','gov.nih.nci.caarray.domain.sample',5),(256,'Extract','The genomic material (mRNA or cDNA) obtained from a biological sample.','gov.nih.nci.caarray.domain.sample',5),(257,'Project','The top-level container of a microarray experiment and its dependent files.','gov.nih.nci.caarray.domain.project',5),(258,'FactorValue','Specifies the value supplied for a dependent variable of an experiment.','gov.nih.nci.caarray.domain.project',5),(259,'ExperimentContact','A party (person or organization) that has a direct association with an experiment.','gov.nih.nci.caarray.domain.project',5),(260,'Parameter','Represents a named, replaceable value in a protocol.. Examples of parameters include: scanning wavelength, laser power, centrifuge speed, multiplicative errors, the number of input nodes to a SOM, and PCR temperatures.','gov.nih.nci.caarray.domain.protocol',5),(261,'Protocol','A parameterizable description of a method.','gov.nih.nci.caarray.domain.protocol',5),(262,'ProtocolApplication','The act of employing a protocol.','gov.nih.nci.caarray.domain.protocol',5),(263,'ParameterValue','The actual argument supplied for a replaceable parameter.','gov.nih.nci.caarray.domain.protocol',5),(264,'StringColumn','Contains textual data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(265,'QuantitationType','Identifies how to interpret a given data column of micorarray data (single datum of the matrix (e.g. raw intensity, background, error).','gov.nih.nci.caarray.domain.data',5),(266,'DoubleColumn','Contains floating point data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(267,'IntegerColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(268,'CaArrayFile','A binary or textual computer file that contains microarray data or other information of interest in a microarray experiment.','gov.nih.nci.caarray.domain.file',5),(269,'Hybridization','The act of appying a biological material to a microarray resulting in the genomic material binding to design elements on the array.','gov.nih.nci.caarray.domain.hybridization',5),(270,'Factor','A dependent variable of an experiment (e.g. time, glucose concentration, ...)','gov.nih.nci.caarray.domain.project',5),(271,'Experiment','The methodological investigation of a scientific hypothesis.','gov.nih.nci.caarray.domain.project',5),(272,'DesignElementList','Contains an ordered list of the microarray design elements (features or probes) for which data values are provided.','gov.nih.nci.caarray.domain.data',5),(273,'DataRetrievalRequest','Used by clients to specify precisely which microarray data are to be returned.','gov.nih.nci.caarray.domain.data',5),(274,'AbstractArrayData','The quantified results extracted from the design elements of one or many microarrays.','gov.nih.nci.caarray.domain.data',5),(275,'BooleanColumn','Contains boolean (true, false) data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(276,'FloatColumn','Contains floating point data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(277,'AbstractDataColumn','Contains all of the data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(278,'DerivedArrayData','The quantified results returned by normalizing or otherwise transforming raw array data signal values extracted from the design elements of one or many microarrays.','gov.nih.nci.caarray.domain.data',5),(279,'RawArrayData','The quantified results returned by extracting the signal values from the design elements from one hybridized microarray.','gov.nih.nci.caarray.domain.data',5),(280,'AbstractContact','A party (organization or person) of interest in the application.','gov.nih.nci.caarray.domain.contact',5),(281,'Address','Specifies a destination to which postal mail may be delivered.','gov.nih.nci.caarray.domain.contact',5),(282,'ArrayDataType','Defines the data format associated with a set of microarray data.','gov.nih.nci.caarray.domain.data',5),(283,'Image','A high-resolution scanned image (e.g. TIFF format) of a microarray surface after hybridization.','gov.nih.nci.caarray.domain.data',5),(284,'HybridizationData','Container for the quantified values extracted from a single hybridized mircoarray.','gov.nih.nci.caarray.domain.data',5),(285,'ShortColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(286,'LongColumn','Contains integral data values of a specific quantitation type for a single microarray hybridization.','gov.nih.nci.caarray.domain.data',5),(287,'DataSet','A container for all of the data values extracted from a microarray data file.','gov.nih.nci.caarray.domain.data',5),(288,'LogicalProbe','A collection of reporters that together provide the quantification of a single genomic sequence.','gov.nih.nci.caarray.domain.array',5),(289,'ExpressionProbeAnnotation','Represents the biological information associated with a probe on a gene expression array designed to measure levels of RNAs for a specific gene sequence.','gov.nih.nci.caarray.domain.array',5),(290,'ProbeGroup','A logical grouping of probes with a similar function (e.g.. experimental, control, etc.)','gov.nih.nci.caarray.domain.array',5),(291,'Gene','A hereditary unit consisting of a sequence of DNA that occupies a specific location on a chromosome and determines a particular characteristic in an organism. The functional and physical unit of heredity passed from parent to offspring.','gov.nih.nci.caarray.domain.array',5),(292,'PhysicalProbe','A reporter with a specific location on a microarray that quantities the amount of a specifc genomic sequence.','gov.nih.nci.caarray.domain.array',5),(293,'ExonProbeAnnotation','Represents the biologoical information reported by a specific probe on an Exon array designed to measure levels of RNAs containing the Exon.','gov.nih.nci.caarray.domain.array',5),(294,'Organization','Entities such as companies, universities, government agencies of interest in the application.','gov.nih.nci.caarray.domain.contact',5),(295,'Person','An individual of interest within the application.','gov.nih.nci.caarray.domain.contact',5),(296,'ArrayDesignDetails','Container for the physical layout of the design (i.e. feature location and reporter associations) and higher level genomic sequences reported by the design.','gov.nih.nci.caarray.domain.array',5),(297,'ArrayDesign','Describes the shared layout of genomic reporters of a number of identical microarrays. In some cases this might be virtual and, for instance, represent the output from analysis software at the composite level without physical reporters or features.','gov.nih.nci.caarray.domain.array',5),(298,'AbstractDesignElement','An element of a microarray design that can report a quantified value.','gov.nih.nci.caarray.domain.array',5),(299,'Feature','Identifies a physical location on a microarray.','gov.nih.nci.caarray.domain.array',5),(300,'AbstractProbe','An element that represents some biological material (clone, oligo, etc.) on an array which will report on some biosequence or biosequences.','gov.nih.nci.caarray.domain.array',5),(301,'AbstractProbeAnnotation','A generic object to represent the genomic information associated with a given array reporter for measuring specific biological signals, such as genotype for SNP array, and levels of gene transcription products for Expression and Exon arrays.','gov.nih.nci.caarray.domain.array',5),(302,'Array','A collection of microscopic features/reporters, such as DNA fragments, arrayed on a solid surface.','gov.nih.nci.caarray.domain.array',5),(303,'SNPProbeAnnotation','Represents the biological information associated with a probe on a SNP array designed for measuring genotypes in regard to SNPs.','gov.nih.nci.caarray.domain.array',5),(304,'Organism','Organism that the sample or data comes from.','edu.georgetown.pir',5),(305,'AdditionalOrganismName','Other common or scientific names by which the organism known.','edu.georgetown.pir',5),(306,'AbstractCaArrayObject','An instance of a persistent object.','gov.nih.nci.caarray.domain',5),(307,'AbstractCaArrayEntity','An instance of an identifiable object with a unique Life Science Identifier.','gov.nih.nci.caarray.domain',5),(308,'ArrayGroup','Represents multiple independent microarrays attached to the same physical substrate.','gov.nih.nci.caarray.domain.array',5),(309,'CRFVersion',NULL,'org.cvrg.domain',6),(310,'CRFSection',NULL,'org.cvrg.domain',6),(311,'StudyEvent',NULL,'org.cvrg.domain',6),(312,'StudyEventDefinition',NULL,'org.cvrg.domain',6),(313,'Subject',NULL,'org.cvrg.domain',6),(314,'Study',NULL,'org.cvrg.domain',6),(315,'StudySubject',NULL,'org.cvrg.domain',6),(316,'CRFItem',NULL,'org.cvrg.domain',6),(317,'CaseReportForm',NULL,'org.cvrg.domain',6),(318,'CRFItemData',NULL,'org.cvrg.domain',6),(319,'CRFItemDataType',NULL,'org.cvrg.domain',6),(320,'CRFVersion',NULL,'org.cvrg.domain',7),(321,'CRFSection',NULL,'org.cvrg.domain',7),(322,'StudyEvent',NULL,'org.cvrg.domain',7),(323,'StudyEventDefinition',NULL,'org.cvrg.domain',7),(324,'Subject',NULL,'org.cvrg.domain',7),(325,'Study',NULL,'org.cvrg.domain',7),(326,'CRFItem',NULL,'org.cvrg.domain',7),(327,'CaseReportForm',NULL,'org.cvrg.domain',7),(328,'CRFItemData',NULL,'org.cvrg.domain',7),(329,'CRFItemDataType',NULL,'org.cvrg.domain',7);
  60. /*!40000 ALTER TABLE `domain_class` ENABLE KEYS */;
  61. UNLOCK TABLES;
  62.  
  63. --
  64. -- Table structure for table `domain_model`
  65. --
  66.  
  67. DROP TABLE IF EXISTS `domain_model`;
  68. CREATE TABLE `domain_model` (
  69. `ID` bigint(20) NOT NULL,
  70. `DESCRIPTION` varchar(2000) default NULL,
  71. `LONG_NAME` varchar(512) default NULL,
  72. `VERSION` varchar(255) default NULL,
  73. PRIMARY KEY (`ID`)
  74. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  75.  
  76. --
  77. -- Dumping data for table `domain_model`
  78. --
  79.  
  80. LOCK TABLES `domain_model` WRITE;
  81. /*!40000 ALTER TABLE `domain_model` DISABLE KEYS */;
  82. INSERT INTO `domain_model` VALUES (3,'caTissue Suite version 1.1','caTissue_Suite','1.1'),(4,'Version 2.0 caArray Model','caArray','2'),(5,'Version 2.1 caArray Model','caArray','2.1');
  83. /*!40000 ALTER TABLE `domain_model` ENABLE KEYS */;
  84. UNLOCK TABLES;
  85.  
  86. --
  87. -- Table structure for table `grid_service`
  88. --
  89.  
  90. DROP TABLE IF EXISTS `grid_service`;
  91. CREATE TABLE `grid_service` (
  92. `ID` bigint(20) NOT NULL,
  93. `DISCRIMINATOR` varchar(255) NOT NULL,
  94. `DESCRIPTION` varchar(2000) default NULL,
  95. `NAME` varchar(512) NOT NULL,
  96. `PUBLISH_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  97. `SIMPLE_NAME` varchar(255) default NULL,
  98. `DATA_SERVICE_GROUP_ID` bigint(20) default NULL,
  99. `URL` varchar(767) NOT NULL,
  100. `VERSION` varchar(255) default NULL,
  101. `SEARCH_DEFAULT` tinyint(1) NOT NULL default '0',
  102. `HOSTING_CENTER_ID` bigint(20) default NULL,
  103. `DOMAIN_MODEL_ID` bigint(20) default NULL,
  104. PRIMARY KEY (`ID`),
  105. UNIQUE KEY `URL` (`URL`)
  106. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  107.  
  108. --
  109. -- Dumping data for table `grid_service`
  110. --
  111.  
  112. LOCK TABLES `grid_service` WRITE;
  113. /*!40000 ALTER TABLE `grid_service` DISABLE KEYS */;
  114. INSERT INTO `grid_service` VALUES (1,'AnalyticalService',NULL,'ChromosomalSegmentOverlapAcrossSources','2009-10-17 17:55:30','ChromosomalSegmentOverlapAcrossSources',NULL,'http://linuxcomp64.wustl.edu:9880/wsrf/services/cagrid/ChromosomalSegmentOverlapAcrossSources/','1.2',0,1,NULL),(2,'DataService',NULL,'CaDSRDataService','2009-10-17 17:55:30','CaDSRDataService',NULL,'http://cadsr-dataservice-sandbox.nci.nih.gov:80/wsrf/services/cagrid/CaDSRDataService/','1.2',0,2,NULL),(3,'DataService',NULL,'HelloWorld','2009-10-17 17:55:30','HelloWorld',NULL,'https://itd107.cc.emory.edu:8443/wsrf/services/cagrid/HelloWorld/','1.2',0,NULL,NULL),(4,'AnalyticalService','The EVS grid service provides access to data semantics and controlled terminology as managed by the NCI Enterprise Vocabulary Service.','EVSGridService','2009-10-17 17:55:30','EVSGridService',NULL,'http://evs.training.cagrid.org:8080/wsrf/services/cagrid/EVSGridService/','1.0',0,4,NULL),(5,'AnalyticalService','The AuthenticationService serves as an integration point between local identity management and caGrid identity federation. This implementation exposes the NCICB\'s Common Securty Module (CSM) as an Identity Provider (IdP) that may be used in conjuction with the dorian Identity federation service.','AuthenticationService','2009-10-17 17:55:30','AuthenticationService',NULL,'https://cagrid.emory.edu:8443/wsrf/services/cagrid/AuthenticationService/','1.0',0,5,NULL),(6,'AnalyticalService','The Global Model Exchange (GME) service provides registry of XML Schemas which define the syntax of data exchanged on the grid.','GlobalModelExchange','2009-10-17 17:55:30','GlobalModelExchange',NULL,'https://globalmodelexchange.training.cagrid.org:8443/wsrf/services/cagrid/GlobalModelExchange/','1.3',0,6,NULL),(7,'DataService','caTissueSuite v1.1 Washu Test instance','Washu-CaTissueSuite','2009-10-17 17:55:30','Washu-CaTissueSuite',NULL,'https://128.252.227.122:8443/wsrf/services/cagrid/CaTissueSuite/','1.1 RC4',0,7,3),(8,'AnalyticalService',NULL,'ChromosomalSegmentOverlapAcrossSamples','2009-10-17 17:55:30','ChromosomalSegmentOverlapAcrossSamples',NULL,'http://linuxcomp64.wustl.edu:9880/wsrf/services/cagrid/ChromosomalSegmentOverlapAcrossSamples/','1.2',0,8,NULL),(9,'AnalyticalService','A grid service for the provisioning and management of grid users accounts. Dorian provides an integration point between external security domains and the grid, allowing accounts managed in external domains to be federated and managed in the grid. Dorian allows users to use their existing credentials to authenticate to the grid.','Dorian','2009-10-17 17:55:30','Dorian',NULL,'https://dorian.training.cagrid.org:8443/wsrf/services/cagrid/Dorian/','1.3',0,9,NULL),(10,'AnalyticalService','The Grid Trust Service (GTS) is a grid-wide mechanism for maintaining and provisioning a federated trust fabric consisting of trusted certificate authorities, such that grid services may make authentication decisions against the most up to date information.','GTS','2009-10-17 17:55:30','GTS',NULL,'https://mastergts.training.cagrid.org:8443/wsrf/services/cagrid/GTS/','1.3',0,10,NULL),(11,'AnalyticalService','The caGrid Federated Query Processor provides a mechanism to perform basic distributed aggregations and joins of queries over multiple data services.','FederatedQueryProcessor','2009-10-17 17:55:30','FederatedQueryProcessor',NULL,'https://fqp.training.cagrid.org:8443/wsrf/services/cagrid/FederatedQueryProcessor/','1.3',0,11,NULL),(12,'AnalyticalService','The Grid Trust Service (GTS) is a grid-wide mechanism for maintaining and provisioning a federated trust fabric consisting of trusted certificate authorities, such that grid services may make authentication decisions against the most up to date information.','GTS','2009-10-17 17:55:30','GTS',NULL,'https://slavegts.training.cagrid.org:8443/wsrf/services/cagrid/GTS/','1.3',0,12,NULL),(13,'AnalyticalService','The WorkflowFactoryService grid service, created with caGrid Introduce. This service is used to execute BPEL workflows that orchestrate caGrid Analytical and Data Services.','WorkflowFactoryService','2009-10-17 17:55:30','WorkflowFactoryService',NULL,'https://workflow-bpel.training.cagrid.org:8443/wsrf/services/cagrid/WorkflowFactoryService/','1.3',0,13,NULL),(14,'DataService',NULL,'CaArraySvc','2009-10-17 17:55:30','CaArraySvc',NULL,'http://cagrid01-dev.ahc.umn.edu:18080/wsrf/services/cagrid/CaArraySvc/','1.1',0,14,4),(15,'DataService','This is the caArray grid service.','CaArraySvc','2009-10-17 17:55:30','CaArraySvc',NULL,'http://kc-vm2.bmi.ohio-state.edu:18080/wsrf/services/cagrid/CaArraySvc/','1.1',0,15,5),(16,'AnalyticalService',NULL,'TavernaWorkflowService','2009-10-17 17:55:30','TavernaWorkflowService',NULL,'https://workflow-scufl.training.cagrid.org:8443/wsrf/services/cagrid/TavernaWorkflowService/','1.3',0,16,NULL),(17,'DataService',NULL,'OpenClinicaCRF','2009-10-17 17:55:30','OpenClinicaCRF',NULL,'https://itd107.cc.emory.edu:8443/wsrf/services/cagrid/OpenClinicaCRF/','1.2',0,NULL,NULL),(18,'AnalyticalService','The AuthenticationService serves as an integration point between local identity management and caGrid identity federation. This implementation exposes the NCICB\'s Common Securty Module (CSM) as an Identity Provider (IdP) that may be used in conjuction with the dorian Identity federation service.','AuthenticationService','2009-10-17 17:55:30','AuthenticationService',NULL,'https://129.106.149.120:8443/wsrf/services/cagrid/AuthenticationService/','1.0',0,18,NULL),(19,'AnalyticalService','The GlobalModelExchange grid service, provides a DNS-like distributed registry for XML Schemas, providing an authoritative source for the syntactic representation of all data transmitted in the grid.','GlobalModelExchange','2009-10-17 17:55:30','GlobalModelExchange',NULL,'http://gme.training.cagrid.org:8080/wsrf/services/cagrid/GlobalModelExchange/','1.0',0,19,NULL),(20,'AnalyticalService','Grid Grouper provides a group-based authorization solution for the Grid, wherein grid services and applications enforce authorization policy based on membership to groups defined and managed at the grid level.','GridGrouper','2009-10-17 17:55:30','GridGrouper',NULL,'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper/','1.3',0,20,NULL),(21,'AnalyticalService',NULL,'CredentialDelegationService','2009-10-17 17:55:30','CredentialDelegationService',NULL,'https://cds.training.cagrid.org:8443/wsrf/services/cagrid/CredentialDelegationService/','1.3',0,21,NULL),(22,'DataService',NULL,'OpenClinicaCRF','2009-10-17 17:55:30','OpenClinicaCRF',NULL,'https://itd107.cc.emory.edu:8444/wsrf/services/cagrid/OpenClinicaCRF/','1.2',0,NULL,NULL),(23,'AnalyticalService','The caGrid caDSR Grid Service provides access to information in the caDSR that is relevant to caGrid, and has capabilities to generate caGrid standard metadata instances.','CaDSRService','2009-10-17 17:55:30','CaDSRService',NULL,'http://gme.training.cagrid.org:8080/wsrf/services/cagrid/CaDSRService/','1.0',0,23,NULL),(24,'AnalyticalService','The Metadata Model Service (MMS) provides operations for generating and semantically annotating standard caGrid metadata instances using information extracted from external metadata repositories.','MetadataModelService','2009-10-17 17:55:30','MetadataModelService',NULL,'http://mms.training.cagrid.org:8080/wsrf/services/cagrid/MetadataModelService/','1.3',0,24,NULL),(5001,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://app-cabig1.karmanos.org:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5001,NULL),(5002,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.bioinformatics.northwestern.edu:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5002,NULL),(5003,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cabig1.ucsd.edu:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5003,NULL),(5004,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.coh.org:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5004,NULL),(5005,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://137.187.66.94:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5005,NULL),(5006,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://caarray.cancer.umn.edu:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5006,NULL),(5007,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://array.nci.nih.gov:80/wsrf/services/cagrid/CaArraySvc','2.1',1,5007,NULL),(5008,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://caarray.cdac.in:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5008,NULL),(5010,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://128.125.196.144:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5010,NULL),(5011,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://128.252.227.214:58443/wsrf/services/cagrid/CaTissueCore','1.2',1,5011,NULL),(5014,'DataService',NULL,'caNanoLab','2009-10-17 17:55:30','caNanoLab',4,'http://cananolab.abcc.ncifcrf.gov:80/wsrf-canano/services/cagrid/CaNanoLabService','1.4',0,5014,NULL),(5015,'DataService',NULL,'caNanoLab','2009-10-17 17:55:30','caNanoLab',4,'http://ccne2.stanford.edu:80/wsrf-canano/services/cagrid/CaNanoLabService','1.4',0,5015,NULL),(5016,'DataService',NULL,'caNanoLab','2009-10-17 17:55:30','caNanoLab',4,'http://cananolab.wustl.edu:8080/wsrf-canano/services/cagrid/CaNanoLabService','1.4',1,5016,NULL),(5017,'DataService',NULL,'caNanoLab','2009-10-17 17:55:30','caNanoLab',4,'http://cananolab.nci.nih.gov:80/wsrf-canano/services/cagrid/CaNanoLabService','1.4',0,5017,NULL),(5018,'DataService',NULL,'caNanoLab','2009-10-17 17:55:30','caNanoLab',4,'http://cananolab.bme.gatech.edu:80/wsrf-canano/services/cagrid/CaNanoLabService','1.4',0,5018,NULL),(5020,'DataService',NULL,'NCIA_Model','2009-10-17 17:55:30','NCIA',3,'http://imaging.nci.nih.gov:80/wsrf/services/cagrid/NCIACoreService','3',1,5020,NULL),(5021,'DataService',NULL,'NCIA_Model','2009-10-17 17:55:30','NCIA',3,'http://cabig.mskcc.org:21080/wsrf/services/cagrid/NCIACoreService','3',0,5021,NULL),(5029,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://162.129.1.211:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5029,NULL),(5030,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://c3pra.is.mc.uci.edu:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5030,NULL),(5031,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://192.198.54.89:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5031,NULL),(5032,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://cabig.mc.vanderbilt.edu:8443/wsrf/services/cagrid/CaTissueCore','1.2',0,5032,NULL),(5034,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://magnus.eng.uiowa.edu:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5034,NULL),(5035,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://143.111.251.125:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5035,NULL),(5040,'DataService',NULL,'NCIA_Model','2009-10-17 17:55:30','NCIA',3,'http://niams-imaging.nci.nih.gov:80/wsrf/services/cagrid/NCIACoreService','3',0,5040,NULL),(5041,'DataService',NULL,'NCIA_Model','2009-10-17 17:55:30','NCIA',3,'http://164.67.97.54:21080/wsrf/services/cagrid/NCIACoreService','3',0,5041,NULL),(5042,'DataService',NULL,'caTissue_Core_1_2','2009-10-17 17:55:30','caTissue',2,'https://206.81.165.52:47210/wsrf/services/cagrid/CaTissueCore','1.2',0,5042,NULL),(5043,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://130.91.8.171:2002/wsrf/services/cagrid/CaArraySvc','2.1',0,5043,NULL),(5044,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://caarray.wustl.edu:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5044,NULL),(5045,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://crchbioinfo.org:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5045,NULL),(5046,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cclp09.ucsf.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5046,NULL),(5047,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://scigridserver.arc.georgetown.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5047,NULL),(5048,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cabig.uabgrid.uab.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5048,NULL),(5049,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cabiggrid01.roswellpark.org:18080/wsrf/services/cagrid/CaArraySvc','2',0,5049,NULL),(5050,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://huggins.med.Virginia.EDU:18080/wsrf/services/cagrid/CaArraySvc','2',0,5050,NULL),(5051,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.cancer.iu.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5051,NULL),(5052,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.moffitt.org:8005/wsrf/services/cagrid/CaArraySvc','2',0,5052,NULL),(5053,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://caGrid1.mcc.vcu.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5053,NULL),(5054,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.jax.org:18080/wsrf/services/cagrid/CaArraySvc','2',1,5054,NULL),(5055,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://128.249.56.248:18080/wsrf/services/cagrid/CaArraySvc','2',0,5055,NULL),(5056,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cabig.arl.arizona.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5056,NULL),(5057,'DataService','caTissueSuite v1.1 Washu Test instance','caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://catissueshare.wustl.edu:28443/wsrf/services/cagrid/CaTissueSuite','1.1',1,5057,NULL),(5058,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://128.255.22.39:47210/wsrf/services/cagrid/CaTissueSuite','1.1',0,5058,NULL),(5059,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'http://catissue.uabgrid.uab.edu:18080/wsrf/services/cagrid/CaTissueSuite','1.1',0,5059,NULL),(5060,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://128.143.108.197:38082/wsrf/services/cagrid/CaTissueSuite','1.1',0,5060,NULL),(5061,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://tissueinventory.cabig.upmc.edu:8443/wsrf/services/cagrid/CaTissueSuite','1.1',0,5061,NULL),(5062,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://biospecimen.kcc.tju.edu:8443/wsrf/services/cagrid/CaTissueSuite','1.1',1,5062,NULL),(5063,'DataService',NULL,'caTissue_Suite1_1','2009-10-17 17:55:30','caTissue',2,'https://catissue.its.yale.edu:8443/wsrf/services/cagrid/CaTissueSuite','1.1',0,5063,NULL),(5065,'DataService',NULL,'caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid1.duhs.duke.edu:18080/wsrf/services/cagrid/CaArraySvc','2',0,5065,NULL),(5067,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://cagrid.jci.tju.edu:8443/wsrf/services/cagrid/CaArraySvc','2.1',0,5067,NULL),(5068,'DataService','This is the caArray grid service.','caArray','2009-10-17 17:55:30','caArray',1,'http://app-cabig2.karmanos.org:18080/wsrf/services/cagrid/CaArraySvc','2.1',0,5068,NULL);
  115. /*!40000 ALTER TABLE `grid_service` ENABLE KEYS */;
  116. UNLOCK TABLES;
  117.  
  118. --
  119. -- Table structure for table `grid_service_pocs`
  120. --
  121.  
  122. DROP TABLE IF EXISTS `grid_service_pocs`;
  123. CREATE TABLE `grid_service_pocs` (
  124. `GRID_SERVICE_ID` bigint(20) NOT NULL,
  125. `POINT_OF_CONTACT_ID` bigint(20) NOT NULL,
  126. PRIMARY KEY (`POINT_OF_CONTACT_ID`,`GRID_SERVICE_ID`)
  127. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  128.  
  129. --
  130. -- Dumping data for table `grid_service_pocs`
  131. --
  132.  
  133. LOCK TABLES `grid_service_pocs` WRITE;
  134. /*!40000 ALTER TABLE `grid_service_pocs` DISABLE KEYS */;
  135. INSERT INTO `grid_service_pocs` VALUES (5,2),(6,4),(7,6),(9,8),(10,10),(11,12),(12,14),(13,16),(16,19),(18,21),(19,23),(20,25),(21,27),(23,29),(24,31);
  136. /*!40000 ALTER TABLE `grid_service_pocs` ENABLE KEYS */;
  137. UNLOCK TABLES;
  138.  
  139. --
  140. -- Table structure for table `hosting_center`
  141. --
  142.  
  143. DROP TABLE IF EXISTS `hosting_center`;
  144. CREATE TABLE `hosting_center` (
  145. `ID` bigint(20) NOT NULL,
  146. `COUNTRY_CODE` varchar(255) default NULL,
  147. `LOCALITY` varchar(255) default NULL,
  148. `LONG_NAME` varchar(255) default NULL,
  149. `POSTAL_CODE` varchar(255) default NULL,
  150. `SHORT_NAME` varchar(255) default NULL,
  151. `STATE_PROVINCE` varchar(255) default NULL,
  152. `STREET` varchar(255) default NULL,
  153. PRIMARY KEY (`ID`)
  154. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  155.  
  156. --
  157. -- Dumping data for table `hosting_center`
  158. --
  159.  
  160. LOCK TABLES `hosting_center` WRITE;
  161. /*!40000 ALTER TABLE `hosting_center` DISABLE KEYS */;
  162. INSERT INTO `hosting_center` VALUES (1,'US','St.Louis','Washington University in St.Louis','63110','Washu','MO','660 S Euclid Avenue'),(2,'US','Rockville','Center for Biomedical Informatics and Information Technology','20852','CBIIT','MD',NULL),(4,'US','Columbus','Ohio State University','43210','OSU','OH',NULL),(5,'US','Atlanta','Emory University','30322','Emory','GA',NULL),(6,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(7,'US','St.Louis','Washington University','63110','Washu','MO','660 S Euclid Avenue'),(8,'US','St.Louis','Washington University in St.Louis','63110','Washu','MO','660 S Euclid Avenue'),(9,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(10,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(11,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(12,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(13,'USA','Columbus','Ohio State University','43210','OSU','OH',NULL),(14,'US','Minneapolis','Masonic Cancer Center, University of Minnesota','55455','MMC','MN',NULL),(15,'USA','Columbus','Ohio State University','43210','OSU','OH',NULL),(16,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(18,'US',NULL,'NCI Center for Bioinformatics','20852','NCICB','MD',NULL),(19,'US','Columbus','Ohio State University','43210','OSU','OH',NULL),(20,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(21,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave.'),(23,'US','Columbus','Ohio State University','43210','OSU','OH',NULL),(24,'US','Columbus','Ohio State University','43210','OSU','OH','460 W. 12th Ave'),(5001,NULL,NULL,'Barbara Ann Karmanos Cancer Institute',NULL,'KCI',NULL,NULL),(5002,NULL,NULL,'Robert H. Lurie Comprehensive Cancer Center',NULL,'RHLCCC',NULL,NULL),(5003,NULL,NULL,'UCSD Moores Cancer Center',NULL,'UCSDMCC',NULL,NULL),(5004,NULL,NULL,'City Of Hope',NULL,'City Of Hope',NULL,NULL),(5005,NULL,NULL,'SAIC-Frederick caBIG Lab',NULL,'SAIC-F Lab',NULL,NULL),(5006,NULL,NULL,'\"Masonic Cancer Center, University of Minnesota\"',NULL,'MCC',NULL,NULL),(5007,NULL,NULL,'National Cancer Institute Center for Bioinformatics - NCICB',NULL,'NCICB',NULL,NULL),(5008,NULL,NULL,'CENTER FOR DEVELOPMENT OF ADVANCED COMPUTING',NULL,'CDAC',NULL,NULL),(5009,NULL,NULL,'Washington University',NULL,'WashU',NULL,NULL),(5010,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5011,NULL,NULL,'Washington University in St.Louis',NULL,'Washu',NULL,NULL),(5012,NULL,NULL,'WESTAT',NULL,'WESTAT',NULL,NULL),(5013,NULL,NULL,'NCI Center for Biomedical Informatics and Information Technology ',NULL,'CBIIT',NULL,NULL),(5014,NULL,NULL,'caNanoLab-NCL',NULL,'caNanoLab-NCL',NULL,NULL),(5015,NULL,NULL,'caNanoLab-Stanford',NULL,'caNanoLab-Stanford',NULL,NULL),(5016,NULL,NULL,'caNanoLab-WUSTL',NULL,'caNanoLab-WUSTL',NULL,NULL),(5017,NULL,NULL,'caNanoLab-NCICB',NULL,'caNanoLab-NCICB',NULL,NULL),(5018,NULL,NULL,'caNanoLab-GTEM',NULL,'caNanoLab-GTEM',NULL,NULL),(5019,NULL,NULL,'NCI CBIIT',NULL,'NCI',NULL,NULL),(5020,NULL,NULL,'NCI CBIIT',NULL,'NCICB',NULL,NULL),(5021,NULL,NULL,'Memorial Sloan-Kettering Cancer Center',NULL,'MSKCC',NULL,NULL),(5022,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5023,NULL,NULL,'Protein Information Resource, Lombardi Comprehensive Cancer Center',NULL,'PIR, LCCC',NULL,NULL),(5024,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5025,NULL,NULL,'Fred Hutchinson Cancer Research Center',NULL,'FHCRC',NULL,NULL),(5026,NULL,NULL,'NCI Center for Biomedical Informatics and Information Technology',NULL,'NCICBIIT',NULL,NULL),(5027,NULL,NULL,'UAB Comprehensive Cancer Center',NULL,'UAB-CCC',NULL,NULL),(5028,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5029,NULL,NULL,'Johns Hopkins Sidney Kimmel Cancer Center',NULL,'JHU SKCCC',NULL,NULL),(5030,NULL,NULL,'UC Irvine Chao Family Comprehensive Cancer Center',NULL,'UC Irvine Chao Family Comprehensive Cancer Center',NULL,NULL),(5031,NULL,NULL,'University of Nebraska Medical Center, Eppley Cancer Center',NULL,'Eppley Cancer Center, UNMC',NULL,NULL),(5032,NULL,NULL,'Vanderbilt-Ingram Cancer Center',NULL,'VICC',NULL,NULL),(5034,NULL,NULL,'Holden Comprehensive Cancer Center',NULL,'HCCC',NULL,NULL),(5035,NULL,NULL,'MD Anderson Cancer Center',NULL,'MDACC',NULL,NULL),(5037,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5038,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5039,NULL,NULL,'Science of Networks in Communities',NULL,'SONIC',NULL,NULL),(5040,NULL,NULL,'NCI CBIIT',NULL,'NCICB',NULL,NULL),(5041,NULL,NULL,'UCLA-CTRL',NULL,'UCLA',NULL,NULL),(5042,NULL,NULL,'H.Lee. Moffitt Cancer Center',NULL,'MOFFITT',NULL,NULL),(5043,NULL,NULL,'The Wistar Institute',NULL,'Wistar',NULL,NULL),(5044,NULL,NULL,'Washington University at St. Louis',NULL,'WashU',NULL,NULL),(5045,NULL,NULL,'Cancer Research Center of Hawaii',NULL,'CRCH',NULL,NULL),(5046,NULL,NULL,'UCSF Helen Diller Family Comprehensive Cancer Center',NULL,'UCSF-HDFCCC',NULL,NULL),(5047,NULL,NULL,'Advanced Research Computing',NULL,'ARC',NULL,NULL),(5048,NULL,NULL,'UAB Comprehensive Cancer Center',NULL,'UAB-CCC',NULL,NULL),(5049,NULL,NULL,'Roswell Park Cancer Institute',NULL,'RPCI',NULL,NULL),(5050,NULL,NULL,'UVA Medical School - Public Health Sciences',NULL,'UVA-PHS',NULL,NULL),(5051,NULL,NULL,'Melvin and Bren Simon Cancer Center, Indiana University',NULL,'IU Simon Cancer Center',NULL,NULL),(5052,NULL,NULL,'H.Lee. Moffitt Cancer Center',NULL,'MOFFITT',NULL,NULL),(5053,NULL,NULL,'VCU Massey Cancer Center',NULL,'VCU',NULL,NULL),(5054,NULL,NULL,'The Jackson Laboratory',NULL,'JAX',NULL,NULL),(5055,NULL,NULL,'Dan L. Duncan Cancer Center at Baylor College of Medicine',NULL,'DLDCC',NULL,NULL),(5056,NULL,NULL,'Arizona Cancer Center - UA',NULL,'AZCC',NULL,NULL),(5057,NULL,NULL,'Washington University',NULL,'Washu',NULL,NULL),(5058,NULL,NULL,'The Holden Comprehensive Cancer Center',NULL,'HCCC',NULL,NULL),(5059,NULL,NULL,'UAB Comprehensive Cancer Center',NULL,'UAB-CCC',NULL,NULL),(5060,NULL,NULL,'UVA Cancer Center',NULL,'UVACC',NULL,NULL),(5061,NULL,NULL,'University of Pittsburgh Cancer Institute',NULL,'UPCI',NULL,NULL),(5062,NULL,NULL,'Thomas Jefferson University',NULL,'TJUH',NULL,NULL),(5063,NULL,NULL,'Yale Cancer Center',NULL,'Yale',NULL,NULL),(5065,NULL,NULL,'Duke Comprehensive Cancer Center',NULL,'DCCC',NULL,NULL),(5066,NULL,NULL,'NCICB_Stage',NULL,'NCICB_Stage',NULL,NULL),(5067,NULL,NULL,'Kimmel Cancer Center',NULL,'KCC',NULL,NULL),(5068,NULL,NULL,'Barbara Ann Karmanos Cancer Institute',NULL,'KCI',NULL,NULL);
  163. /*!40000 ALTER TABLE `hosting_center` ENABLE KEYS */;
  164. UNLOCK TABLES;
  165.  
  166. --
  167. -- Table structure for table `hosting_center_pocs`
  168. --
  169.  
  170. DROP TABLE IF EXISTS `hosting_center_pocs`;
  171. CREATE TABLE `hosting_center_pocs` (
  172. `HOSTING_CENTER_ID` bigint(20) NOT NULL,
  173. `POINT_OF_CONTACT_ID` bigint(20) NOT NULL,
  174. PRIMARY KEY (`HOSTING_CENTER_ID`,`POINT_OF_CONTACT_ID`)
  175. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  176.  
  177. --
  178. -- Dumping data for table `hosting_center_pocs`
  179. --
  180.  
  181. LOCK TABLES `hosting_center_pocs` WRITE;
  182. /*!40000 ALTER TABLE `hosting_center_pocs` DISABLE KEYS */;
  183. INSERT INTO `hosting_center_pocs` VALUES (2,1),(6,3),(7,5),(9,7),(10,9),(11,11),(12,13),(13,15),(15,17),(16,18),(18,20),(19,22),(20,24),(21,26),(23,28),(24,30);
  184. /*!40000 ALTER TABLE `hosting_center_pocs` ENABLE KEYS */;
  185. UNLOCK TABLES;
  186.  
  187. --
  188. -- Table structure for table `point_of_contact`
  189. --
  190.  
  191. DROP TABLE IF EXISTS `point_of_contact`;
  192. CREATE TABLE `point_of_contact` (
  193. `ID` bigint(20) NOT NULL,
  194. `AFFILIATION` varchar(512) default NULL,
  195. `EMAIL` varchar(512) default NULL,
  196. `NAME` varchar(512) default NULL,
  197. `ROLE` varchar(512) default NULL,
  198. PRIMARY KEY (`ID`)
  199. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  200.  
  201. --
  202. -- Dumping data for table `point_of_contact`
  203. --
  204.  
  205. LOCK TABLES `point_of_contact` WRITE;
  206. /*!40000 ALTER TABLE `point_of_contact` DISABLE KEYS */;
  207. INSERT INTO `point_of_contact` VALUES (1,'NCI-CBIIT','ncicb@pop.nci.nih.gov','App Support','Grid Administrator'),(2,'Emory','tjack04+cagrid@emory.edu',NULL,NULL),(3,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(4,'Ohio State University','knowledge@cagrid.org','Scott Oster','Architect'),(5,'Washington University','rakesh@wustl.edu','Rakesh Nagarajan','maintainer'),(6,'Washington University','rakesh@wustl.edu','Rakesh Nagarajan','maintainer'),(7,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(8,'Ohio State University','Stephen.Langella@osumc.edu','Stephen Langella','Architect'),(9,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(10,'Ohio State University','Stephen.Langella@osumc.edu','Stephen Langella','Architect'),(11,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(12,'Ohio State University','knowledge@cagrid.org','David Ervin','Developer'),(13,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(14,'Ohio State University','Stephen.Langella@osumc.edu','Stephen Langella','Architect'),(15,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','administrator'),(16,'ANL','sulakhe@mcs.anl.gov','Dinanath Sulakhe','Developer'),(17,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(18,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(19,'ANL','sulakhe@mcs.anl.gov','Dinanath Sulakhe','Developer'),(20,'NCICB','shanbhak@mail.nih.gov','Krishnakant Shanbhag','maintainer'),(21,'SemanticBits','joshua.phillips@semanticbits.com','Joshua Phillips','Developer'),(22,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(23,'OSU','hastings@bmi.osu.edu','Shannon Hastings','Developer'),(24,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(25,'Ohio State University','Stephen.Langella@osumc.edu','Stephen Langella','Architect'),(26,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(27,'Ohio State University','Stephen.Langella@osumc.edu','Stephen Langella','Architect'),(28,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(29,'OSU','oster@bmi.osu.edu','Scott Oster','Developer'),(30,'caGrid Knowledge Center','knowledge@cagrid.org','William Stephens','Administrator'),(31,'OSU','knowledge@cagrid.org','Scott Oster','Developer');
  208. /*!40000 ALTER TABLE `point_of_contact` ENABLE KEYS */;
  209. UNLOCK TABLES;
  210.  
  211. --
  212. -- Table structure for table `simple_name`
  213. --
  214.  
  215. DROP TABLE IF EXISTS `simple_name`;
  216. CREATE TABLE `simple_name` (
  217. `ID` bigint(20) NOT NULL auto_increment,
  218. `PATTERN` varchar(512) default NULL,
  219. `SIMPLE_NAME` varchar(512) default NULL,
  220. PRIMARY KEY (`ID`)
  221. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  222.  
  223. --
  224. -- Dumping data for table `simple_name`
  225. --
  226.  
  227. LOCK TABLES `simple_name` WRITE;
  228. /*!40000 ALTER TABLE `simple_name` DISABLE KEYS */;
  229. INSERT INTO `simple_name` VALUES (1,'CaDSR*','caDSR'),(2,'EVS*','Enterprise Vocabulary Service'),(3,'*CaArray*','caArray'),(4,'*CaTissue*','caTissue'),(5,'NCIA*','NCIA'),(6,'caTissue*','caTissue'),(7,'ChromosomalSegmentOverlapAcrossSources','CSOAS'),(8,'OpenClinicaCRF','OpenClinical CRF'),(9,'WorkflowFactoryService','Workflow Factory'),(10,'TavernaWorkflowService','Taverna'),(11,'AuthenticationService','Authentication'),(12,'GlobalModelExchange','GME'),(13,'GridGrouper','Grid Grouper'),(14,'CredentialDelegationService','Credential Delegation'),(15,'FederatedQueryProcessor','Federated Query Processor ');
  230. /*!40000 ALTER TABLE `simple_name` ENABLE KEYS */;
  231. UNLOCK TABLES;
  232.  
  233. --
  234. -- Table structure for table `status_change`
  235. --
  236.  
  237. DROP TABLE IF EXISTS `status_change`;
  238. CREATE TABLE `status_change` (
  239. `ID` bigint(20) NOT NULL,
  240. `CHANGE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  241. `NEW_STATUS` varchar(255) default NULL,
  242. `GRID_SERVICE_ID` bigint(20) NOT NULL,
  243. PRIMARY KEY (`ID`)
  244. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  245.  
  246. --
  247. -- Dumping data for table `status_change`
  248. --
  249.  
  250. LOCK TABLES `status_change` WRITE;
  251. /*!40000 ALTER TABLE `status_change` DISABLE KEYS */;
  252. INSERT INTO `status_change` VALUES (1,'2005-08-05 15:12:26','ACTIVE',1),(2,'2005-08-05 15:12:26','ACTIVE',2),(3,'2005-08-05 15:12:26','ACTIVE',3),(4,'2005-08-05 15:12:26','ACTIVE',4),(5,'2005-08-05 15:12:26','ACTIVE',5),(6,'2005-08-05 15:12:26','ACTIVE',6),(7,'2005-08-05 15:12:26','ACTIVE',7),(8,'2005-08-05 15:12:26','ACTIVE',8),(9,'2005-08-05 15:12:26','ACTIVE',9),(10,'2005-08-05 15:12:26','ACTIVE',10),(11,'2005-08-05 15:12:26','ACTIVE',11),(12,'2005-08-05 15:12:26','ACTIVE',12),(13,'2005-08-05 15:12:26','ACTIVE',13),(14,'2005-08-05 15:12:26','ACTIVE',14),(15,'2005-08-05 15:12:26','ACTIVE',15),(16,'2005-08-05 15:12:26','ACTIVE',16),(17,'2005-08-05 15:12:26','ACTIVE',17),(18,'2005-08-05 15:12:26','ACTIVE',18),(19,'2005-08-05 15:12:26','ACTIVE',19),(20,'2005-08-05 15:12:26','ACTIVE',20),(21,'2005-08-05 15:12:26','ACTIVE',21),(22,'2005-08-05 15:12:26','ACTIVE',22),(23,'2005-08-05 15:12:26','ACTIVE',23),(24,'2005-08-05 15:12:26','ACTIVE',24),(101,'2006-08-05 15:12:26','INACTIVE',1),(102,'2006-08-05 15:12:26','INACTIVE',2),(103,'2006-08-05 15:12:26','INACTIVE',3),(104,'2006-08-05 15:12:26','INACTIVE',4),(105,'2006-08-05 15:12:26','INACTIVE',5),(106,'2006-08-05 15:12:26','INACTIVE',6),(107,'2006-08-05 15:12:26','INACTIVE',7),(108,'2006-08-05 15:12:26','INACTIVE',8),(109,'2006-08-05 15:12:26','INACTIVE',9),(110,'2006-08-05 15:12:26','INACTIVE',10),(111,'2006-08-05 15:12:26','INACTIVE',11),(112,'2006-08-05 15:12:26','INACTIVE',12),(113,'2006-08-05 15:12:26','INACTIVE',13),(114,'2006-08-05 15:12:26','INACTIVE',14),(115,'2006-08-05 15:12:26','INACTIVE',15),(116,'2006-08-05 15:12:26','INACTIVE',16),(117,'2006-08-05 15:12:26','INACTIVE',17),(118,'2006-08-05 15:12:26','INACTIVE',18),(119,'2006-08-05 15:12:26','INACTIVE',19),(120,'2006-08-05 15:12:26','INACTIVE',20),(121,'2006-08-05 15:12:26','INACTIVE',21),(122,'2006-08-05 15:12:26','INACTIVE',22),(123,'2006-08-05 15:12:26','INACTIVE',23),(124,'2006-08-05 15:12:26','INACTIVE',24),(202,'2009-08-05 15:12:26','ACTIVE',2),(203,'2009-08-05 15:12:26','ACTIVE',3),(204,'2009-08-05 15:12:26','ACTIVE',4),(205,'2009-08-05 15:12:26','ACTIVE',5),(206,'2009-08-05 15:12:26','ACTIVE',6),(207,'2009-08-05 15:12:26','ACTIVE',7),(208,'2009-08-05 15:12:26','ACTIVE',8),(209,'2009-08-05 15:12:26','ACTIVE',9),(210,'2009-08-05 15:12:26','ACTIVE',10),(211,'2009-08-05 15:12:26','ACTIVE',11),(212,'2009-08-05 15:12:26','ACTIVE',12),(213,'2009-08-05 15:12:26','ACTIVE',13),(214,'2009-08-05 15:12:26','ACTIVE',14),(215,'2009-08-05 15:12:26','ACTIVE',15),(216,'2009-08-05 15:12:26','ACTIVE',16),(217,'2009-08-05 15:12:26','ACTIVE',17),(218,'2009-08-05 15:12:26','ACTIVE',18),(219,'2009-08-05 15:12:26','ACTIVE',19),(220,'2009-08-05 15:12:26','ACTIVE',20),(221,'2009-08-05 15:12:26','ACTIVE',21),(222,'2009-08-05 15:12:26','ACTIVE',22),(223,'2009-08-05 15:12:26','ACTIVE',23),(224,'2009-08-05 15:12:26','ACTIVE',24),(5001,'2005-08-05 15:12:26','ACTIVE',5001),(5002,'2005-08-05 15:12:26','ACTIVE',5002),(5003,'2005-08-05 15:12:26','ACTIVE',5003),(5004,'2005-08-05 15:12:26','ACTIVE',5004),(5005,'2005-08-05 15:12:26','ACTIVE',5005),(5006,'2005-08-05 15:12:26','ACTIVE',5006),(5007,'2005-08-05 15:12:26','ACTIVE',5007),(5008,'2005-08-05 15:12:26','ACTIVE',5008),(5009,'2005-08-05 15:12:26','ACTIVE',5009),(5010,'2005-08-05 15:12:26','ACTIVE',5010),(5011,'2005-08-05 15:12:26','ACTIVE',5011),(5012,'2005-08-05 15:12:26','ACTIVE',5012),(5013,'2005-08-05 15:12:26','ACTIVE',5013),(5014,'2005-08-05 15:12:26','ACTIVE',5014),(5015,'2005-08-05 15:12:26','ACTIVE',5015),(5016,'2005-08-05 15:12:26','ACTIVE',5016),(5017,'2005-08-05 15:12:26','ACTIVE',5017),(5018,'2005-08-05 15:12:26','ACTIVE',5018),(5019,'2005-08-05 15:12:26','ACTIVE',5019),(5020,'2005-08-05 15:12:26','ACTIVE',5020),(5021,'2005-08-05 15:12:26','ACTIVE',5021),(5022,'2005-08-05 15:12:26','ACTIVE',5022),(5023,'2005-08-05 15:12:26','ACTIVE',5023),(5024,'2005-08-05 15:12:26','ACTIVE',5024),(5025,'2005-08-05 15:12:26','ACTIVE',5025),(5026,'2005-08-05 15:12:26','ACTIVE',5026),(5027,'2005-08-05 15:12:26','ACTIVE',5027),(5028,'2005-08-05 15:12:26','ACTIVE',5028),(5029,'2005-08-05 15:12:26','ACTIVE',5029),(5030,'2005-08-05 15:12:26','ACTIVE',5030),(5031,'2005-08-05 15:12:26','ACTIVE',5031),(5032,'2005-08-05 15:12:26','ACTIVE',5032),(5034,'2005-08-05 15:12:26','ACTIVE',5034),(5035,'2005-08-05 15:12:26','ACTIVE',5035),(5037,'2005-08-05 15:12:26','ACTIVE',5037),(5038,'2005-08-05 15:12:26','ACTIVE',5038),(5039,'2005-08-05 15:12:26','ACTIVE',5039),(5040,'2005-08-05 15:12:26','ACTIVE',5040),(5041,'2005-08-05 15:12:26','ACTIVE',5041),(5042,'2005-08-05 15:12:26','ACTIVE',5042),(5043,'2005-08-05 15:12:26','ACTIVE',5043),(5044,'2005-08-05 15:12:26','ACTIVE',5044),(5045,'2005-08-05 15:12:26','ACTIVE',5045),(5046,'2005-08-05 15:12:26','ACTIVE',5046),(5047,'2005-08-05 15:12:26','ACTIVE',5047),(5048,'2005-08-05 15:12:26','ACTIVE',5048),(5049,'2005-08-05 15:12:26','ACTIVE',5049),(5050,'2005-08-05 15:12:26','ACTIVE',5050),(5051,'2005-08-05 15:12:26','ACTIVE',5051),(5052,'2005-08-05 15:12:26','ACTIVE',5052),(5053,'2005-08-05 15:12:26','ACTIVE',5053),(5054,'2005-08-05 15:12:26','ACTIVE',5054),(5055,'2005-08-05 15:12:26','ACTIVE',5055),(5056,'2005-08-05 15:12:26','ACTIVE',5056),(5057,'2005-08-05 15:12:26','ACTIVE',5057),(5058,'2005-08-05 15:12:26','ACTIVE',5058),(5059,'2005-08-05 15:12:26','ACTIVE',5059),(5060,'2005-08-05 15:12:26','ACTIVE',5060),(5061,'2005-08-05 15:12:26','ACTIVE',5061),(5062,'2005-08-05 15:12:26','ACTIVE',5062),(5063,'2005-08-05 15:12:26','ACTIVE',5063),(5065,'2005-08-05 15:12:26','ACTIVE',5065),(5066,'2005-08-05 15:12:26','ACTIVE',5066),(5067,'2005-08-05 15:12:26','ACTIVE',5067),(5068,'2005-08-05 15:12:26','ACTIVE',5068);
  253. /*!40000 ALTER TABLE `status_change` ENABLE KEYS */;
  254. UNLOCK TABLES;
  255.  
  256. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  257. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  258. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  259. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  260. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  261. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  262. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!