[MOBY-guts] biomoby commit
Mark Wilkinson
mwilkinson at pub.open-bio.org
Thu May 8 14:48:01 UTC 2003
mwilkinson
Thu May 8 10:48:01 EDT 2003
Update of /home/repository/moby/moby-live/Database
In directory pub.open-bio.org:/tmp/cvs-serv829/Database
Modified Files:
mobynamespace.mysql mobyobject.mysql mobyservice.mysql
Log Message:
added indicies and bootstrapping services to the database
moby-live/Database mobynamespace.mysql,1.1,1.2 mobyobject.mysql,1.1,1.2 mobyservice.mysql,1.1,1.2
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobynamespace.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/mobynamespace.mysql 2003/05/07 20:52:47 1.1
+++ /home/repository/moby/moby-live/Database/mobynamespace.mysql 2003/05/08 14:48:01 1.2
@@ -1,12 +1,12 @@
--- MySQL dump 8.22
---
--- Host: localhost Database: mobynamespace
----------------------------------------------------------
--- Server version 3.23.52
-
---
--- Table structure for table 'namespace'
---
+# MySQL dump 8.14
+#
+# Host: localhost Database: mobynamespace
+#--------------------------------------------------------
+# Server version 3.23.41
+
+#
+# Table structure for table 'namespace'
+#
CREATE TABLE namespace (
namespace_id int(10) unsigned NOT NULL auto_increment,
@@ -14,18 +14,18 @@
description text NOT NULL,
authority varchar(255) NOT NULL default '',
contact_email varchar(255) NOT NULL default '',
- PRIMARY KEY (namespace_id)
+ PRIMARY KEY (namespace_id),
+ UNIQUE KEY namespace_type (namespace_type)
) TYPE=MyISAM;
---
--- Dumping data for table 'namespace'
---
+#
+# Dumping data for table 'namespace'
+#
-
---
--- Table structure for table 'namespace_term2term'
---
+#
+# Table structure for table 'namespace_term2term'
+#
CREATE TABLE namespace_term2term (
assertion_id int(10) unsigned NOT NULL auto_increment,
@@ -35,9 +35,8 @@
PRIMARY KEY (assertion_id)
) TYPE=MyISAM;
---
--- Dumping data for table 'namespace_term2term'
---
-
+#
+# Dumping data for table 'namespace_term2term'
+#
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyobject.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/mobyobject.mysql 2003/05/07 20:52:47 1.1
+++ /home/repository/moby/moby-live/Database/mobyobject.mysql 2003/05/08 14:48:01 1.2
@@ -1,12 +1,12 @@
--- MySQL dump 8.22
---
--- Host: localhost Database: mobyobject
----------------------------------------------------------
--- Server version 3.23.52
-
---
--- Table structure for table 'object'
---
+# MySQL dump 8.14
+#
+# Host: localhost Database: mobyobject
+#--------------------------------------------------------
+# Server version 3.23.41
+
+#
+# Table structure for table 'object'
+#
CREATE TABLE object (
object_id int(10) unsigned NOT NULL auto_increment,
@@ -14,19 +14,23 @@
description text NOT NULL,
authority varchar(255) NOT NULL default '',
contact_email varchar(255) NOT NULL default '',
- PRIMARY KEY (object_id)
+ PRIMARY KEY (object_id),
+ UNIQUE KEY object_type (object_type)
) TYPE=MyISAM;
---
--- Dumping data for table 'object'
---
-
-
-INSERT INTO object VALUES (47,'Object','a human-readable description of the object','URI of the registrar of this object','your at email.address');
-
---
--- Table structure for table 'object_term2term'
---
+#
+# Dumping data for table 'object'
+#
+
+INSERT INTO object VALUES (1,'Object','an object','openinformatics.com','jason at openinformatics.com');
+INSERT INTO object VALUES (2,'Integer','an int','openinformatics.com','jason at openinformatics.com');
+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');
+
+#
+# Table structure for table 'object_term2term'
+#
CREATE TABLE object_term2term (
assertion_id int(10) unsigned NOT NULL auto_increment,
@@ -37,9 +41,14 @@
PRIMARY KEY (assertion_id)
) TYPE=MyISAM;
---
--- Dumping data for table 'object_term2term'
---
-
-
+#
+# 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);
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyservice.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/mobyservice.mysql 2003/05/07 20:52:47 1.1
+++ /home/repository/moby/moby-live/Database/mobyservice.mysql 2003/05/08 14:48:01 1.2
@@ -1,12 +1,12 @@
--- MySQL dump 8.22
---
--- Host: localhost Database: mobyservice
----------------------------------------------------------
--- Server version 3.23.52
-
---
--- Table structure for table 'service'
---
+# MySQL dump 8.14
+#
+# Host: localhost Database: mobyservice
+#--------------------------------------------------------
+# Server version 3.23.41
+
+#
+# Table structure for table 'service'
+#
CREATE TABLE service (
service_id int(10) unsigned NOT NULL auto_increment,
@@ -14,18 +14,24 @@
description text NOT NULL,
authority varchar(255) NOT NULL default '',
contact_email varchar(255) NOT NULL default '',
- PRIMARY KEY (service_id)
+ PRIMARY KEY (service_id),
+ UNIQUE KEY service_type (service_type)
) TYPE=MyISAM;
---
--- Dumping data for table 'service'
---
-
-
-
---
--- Table structure for table 'service_term2term'
---
+#
+# Dumping data for table 'service'
+#
+
+INSERT INTO service VALUES (1,'Service','The base type','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');
+
+#
+# Table structure for table 'service_term2term'
+#
CREATE TABLE service_term2term (
assertion_id int(10) unsigned NOT NULL auto_increment,
@@ -35,9 +41,14 @@
PRIMARY KEY (assertion_id)
) TYPE=MyISAM;
---
--- Dumping data for table 'service_term2term'
---
-
-
+#
+# Dumping data for table 'service_term2term'
+#
+
+INSERT INTO service_term2term VALUES (1,'URN:LSID:biomoby.org:ServiceRelation:ISA',3,2);
+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);
More information about the MOBY-guts
mailing list