[MOBY-guts] biomoby commit

Fri May 9 15:43:55 UTC 2003

mwilkinson
Fri May  9 11:43:55 EDT 2003
Update of /home/repository/moby/moby-live/Database
In directory pub.open-bio.org:/tmp/cvs-serv8864

Modified Files:
	mobynamespace.mysql mobyobject.mysql mobyservice.mysql 
Added Files:
	mobycentral.mysql mobyrelationship.mysql 
Log Message:
changes to the database structure
moby-live/Database mobycentral.mysql,NONE,1.1 mobyrelationship.mysql,NONE,1.1 mobynamespace.mysql,1.2,1.3 mobyobject.mysql,1.3,1.4 mobyservice.mysql,1.2,1.3
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobynamespace.mysql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3

--- /home/repository/moby/moby-live/Database/mobynamespace.mysql	2003/05/08 14:48:01	1.2
+++ /home/repository/moby/moby-live/Database/mobynamespace.mysql	2003/05/09 15:43:55	1.3
@@ -22,6 +22,11 @@
 # Dumping data for table 'namespace'
 #
 
+INSERT INTO namespace VALUES (1,'openinformatics.com/Genex/Experiment','Experiment Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
+INSERT INTO namespace VALUES (2,'openinformatics.com/Genex/PhysicalBioAssay','PhysicalBioAssay Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
+INSERT INTO namespace VALUES (3,'openinformatics.com/Genex/Protocol','Protocol Accession numbers from the Genex DB at openinformatics','openinformatics.com','jason at openinformatics.com');
+INSERT INTO namespace VALUES (5,'TestingNamespace','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO namespace VALUES (6,'TestingNamespace2','ignore this','senger.org','senger at ebi.ac.uk');
 
 #
 # Table structure for table 'namespace_term2term'

===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyobject.mysql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- /home/repository/moby/moby-live/Database/mobyobject.mysql	2003/05/08 20:20:43	1.3
+++ /home/repository/moby/moby-live/Database/mobyobject.mysql	2003/05/09 15:43:55	1.4
@@ -27,6 +27,13 @@
 INSERT INTO object VALUES (3,'String','a string','openinformatics.com','jason at openinformatics.com');
 INSERT INTO object VALUES (4,'Float','a floating point number','openinformatics.com','jason at openinformatics.com');
 INSERT INTO object VALUES (5,'DateTime','a date or time in ISO-8601 format','openinformatics.com','jason at openinformatics.com');
+INSERT INTO object VALUES (6,'MAGE/Experiment','a MAGE Experiment object','openinformatics.com','jason at openinformatics.com');
+INSERT INTO object VALUES (7,'MAGE/Protocol','a MAGE Protocol object','openinformatics.com','jason at openinformatics.com');
+INSERT INTO object VALUES (11,'TestingDataType','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO object VALUES (10,'MAGE/PhysicalBioAssay','a MAGE PhysicalBioAssay object','openinformatics.com','jason at openinformatics.com');
+INSERT INTO object VALUES (13,'TestingDataType3','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO object VALUES (14,'TestingDataType4','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO object VALUES (25,'TestingDataType2','ignore this','senger.org','senger at ebi.ac.uk');
 
 #
 # Table structure for table 'object_term2term'
@@ -38,6 +45,7 @@
   object1_id int(11) NOT NULL default '0',
   object2_id int(11) NOT NULL default '0',
   object2_articlename varchar(255) default NULL,
+  container enum('1','0') NOT NULL default '0',
   PRIMARY KEY  (assertion_id)
 ) TYPE=MyISAM;
 
@@ -45,10 +53,19 @@
 # Dumping data for table 'object_term2term'
 #
 
-INSERT INTO object_term2term VALUES (1,'URN:LSID:biomoby.org:ObjectRelation:ISA',49,47,NULL);
-INSERT INTO object_term2term VALUES (2,'URN:LSID:biomoby.org:ObjectRelation:ISA',50,49,NULL);
-INSERT INTO object_term2term VALUES (3,'URN:LSID:biomoby.org:ObjectRelation:ISA',2,1,NULL);
-INSERT INTO object_term2term VALUES (4,'URN:LSID:biomoby.org:ObjectRelation:ISA',3,1,NULL);
-INSERT INTO object_term2term VALUES (5,'URN:LSID:biomoby.org:ObjectRelation:ISA',4,1,NULL);
-INSERT INTO object_term2term VALUES (6,'URN:LSID:biomoby.org:ObjectRelation:ISA',5,3,NULL);
+INSERT INTO object_term2term VALUES (1,'URN:LSID:biomoby.org:ObjectRelation:ISA',49,47,NULL,'');
+INSERT INTO object_term2term VALUES (2,'URN:LSID:biomoby.org:ObjectRelation:ISA',50,49,NULL,'');
+INSERT INTO object_term2term VALUES (3,'URN:LSID:biomoby.org:ObjectRelation:ISA',2,1,NULL,'');
+INSERT INTO object_term2term VALUES (4,'URN:LSID:biomoby.org:ObjectRelation:ISA',3,1,NULL,'');
+INSERT INTO object_term2term VALUES (5,'URN:LSID:biomoby.org:ObjectRelation:ISA',4,1,NULL,'');
+INSERT INTO object_term2term VALUES (6,'URN:LSID:biomoby.org:ObjectRelation:ISA',5,3,NULL,'');
+INSERT INTO object_term2term VALUES (7,'URN:LSID:biomoby.org:ObjectRelation:ISA',6,3,NULL,'');
+INSERT INTO object_term2term VALUES (8,'URN:LSID:biomoby.org:ObjectRelation:ISA',7,3,NULL,'');
+INSERT INTO object_term2term VALUES (9,'URN:LSID:biomoby.org:ObjectRelation:ISA',10,3,NULL,'');
+INSERT INTO object_term2term VALUES (21,'URN:LSID:biomoby.org:ObjectRelation:ISA',25,11,NULL,'');
+INSERT INTO object_term2term VALUES (22,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,2,'money','');
+INSERT INTO object_term2term VALUES (23,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,14,'money','');
+INSERT INTO object_term2term VALUES (24,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,3,'money','');
+INSERT INTO object_term2term VALUES (25,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,13,'money','');
+INSERT INTO object_term2term VALUES (26,'URN:LSID:biomoby.org:ObjectRelation:HAS',25,4,'money','');
 

===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyservice.mysql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- /home/repository/moby/moby-live/Database/mobyservice.mysql	2003/05/08 14:48:01	1.2
+++ /home/repository/moby/moby-live/Database/mobyservice.mysql	2003/05/09 15:43:55	1.3
@@ -23,11 +23,19 @@
 #
 
 INSERT INTO service VALUES (1,'Service','The base type','auth','email');
+INSERT INTO service VALUES (12,'Retrieval/MAGE','Return a MAGE object in MAGE-ML','auth','email');
 INSERT INTO service VALUES (9,'Retrieval','The base retrieval type','auth','email');
 INSERT INTO service VALUES (5,'Resolution','resolve data','auth','email');
 INSERT INTO service VALUES (6,'Parsing','parse data','auth','email');
 INSERT INTO service VALUES (7,'Registration','register data','auth','email');
 INSERT INTO service VALUES (8,'Analysis','analyze data','auth','email');
+INSERT INTO service VALUES (13,'Retrieval/MAGE/Experiment','MAGE Experiment object','auth','email');
+INSERT INTO service VALUES (14,'Retrieval/MAGE/Protocol','MAGE Protocol object','auth','email');
+INSERT INTO service VALUES (15,'Retrieval/MAGE/PhysicalBioAssay','MAGE PhysicalBioAssay object','auth','email');
+INSERT INTO service VALUES (17,'TestingServiceType','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO service VALUES (18,'TestingServiceType2','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO service VALUES (19,'TestingServiceType3','ignore this','senger.org','senger at ebi.ac.uk');
+INSERT INTO service VALUES (21,'TestingServiceType4','ignore this','senger.org','senger at ebi.ac.uk');
 
 #
 # Table structure for table 'service_term2term'
@@ -46,9 +54,16 @@
 #
 
 INSERT INTO service_term2term VALUES (1,'URN:LSID:biomoby.org:ServiceRelation:ISA',3,2);
+INSERT INTO service_term2term VALUES (11,'URN:LSID:biomoby.org:ServiceRelation:ISA',12,9);
 INSERT INTO service_term2term VALUES (8,'URN:LSID:biomoby.org:ServiceRelation:ISA',9,1);
 INSERT INTO service_term2term VALUES (4,'URN:LSID:biomoby.org:ServiceRelation:ISA',5,1);
 INSERT INTO service_term2term VALUES (5,'URN:LSID:biomoby.org:ServiceRelation:ISA',6,1);
 INSERT INTO service_term2term VALUES (6,'URN:LSID:biomoby.org:ServiceRelation:ISA',7,1);
 INSERT INTO service_term2term VALUES (7,'URN:LSID:biomoby.org:ServiceRelation:ISA',8,1);
+INSERT INTO service_term2term VALUES (12,'URN:LSID:biomoby.org:ServiceRelation:ISA',13,12);
+INSERT INTO service_term2term VALUES (13,'URN:LSID:biomoby.org:ServiceRelation:ISA',14,12);
+INSERT INTO service_term2term VALUES (14,'URN:LSID:biomoby.org:ServiceRelation:ISA',15,12);
+INSERT INTO service_term2term VALUES (15,'URN:LSID:biomoby.org:ServiceRelation:ISA',18,17);
+INSERT INTO service_term2term VALUES (19,'URN:LSID:biomoby.org:ServiceRelation:ISA',21,19);
+INSERT INTO service_term2term VALUES (18,'URN:LSID:biomoby.org:ServiceRelation:ISA',21,18);
 


