[MOBY-guts] biomoby commit
Pieter Neerincs
pieter at dev.open-bio.org
Wed Dec 5 11:49:15 UTC 2007
pieter
Wed Dec 5 06:49:14 EST 2007
Update of /home/repository/moby/moby-live/Database
In directory dev.open-bio.org:/tmp/cvs-serv21772
Modified Files:
mobycentral.mysql mobynamespace.mysql mobyobject.data
mobyobject.mysql mobyrelationship.mysql mobyservice.data
mobyservice.mysql
Log Message:
Updated MySQL scripts for creating a new Central to the current specs.
moby-live/Database mobycentral.mysql,1.6,1.7 mobynamespace.mysql,1.6,1.7 mobyobject.data,1.2,1.3 mobyobject.mysql,1.9,1.10 mobyrelationship.mysql,1.5,1.6 mobyservice.data,1.2,1.3 mobyservice.mysql,1.7,1.8
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobycentral.mysql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- /home/repository/moby/moby-live/Database/mobycentral.mysql 2007/02/06 21:11:49 1.6
+++ /home/repository/moby/moby-live/Database/mobycentral.mysql 2007/12/05 11:49:14 1.7
@@ -14,7 +14,7 @@
contact_email varchar(255) NOT NULL default '',
authority_id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (authority_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `collection_input`
@@ -25,7 +25,7 @@
article_name varchar(255) default NULL,
service_instance_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (collection_input_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `collection_output`
@@ -36,7 +36,7 @@
article_name varchar(255) default NULL,
service_instance_id int(10) unsigned NOT NULL default '0',
PRIMARY KEY (collection_output_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `secondary_input`
@@ -51,8 +51,9 @@
datatype enum('String','Integer','DateTime','Float','Boolean') default NULL,
article_name varchar(255) default NULL,
service_instance_id int(10) unsigned NOT NULL default '0',
+ description text,
PRIMARY KEY (secondary_input_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `service_instance`
@@ -72,7 +73,7 @@
lsid varchar(255) NOT NULL default '',
PRIMARY KEY (service_instance_id),
UNIQUE KEY servicename (servicename,authority_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `service_validation`
@@ -83,7 +84,7 @@
error_code int(4) NOT NULL default '0',
counter int(1) NOT NULL default '0',
PRIMARY KEY (signatureURL)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `simple_input`
@@ -97,7 +98,7 @@
service_instance_id int(10) unsigned default NULL,
collection_input_id int(10) unsigned default NULL,
PRIMARY KEY (simple_input_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `simple_output`
@@ -111,5 +112,5 @@
service_instance_id int(10) unsigned default NULL,
collection_output_id int(10) unsigned default NULL,
PRIMARY KEY (simple_output_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobynamespace.mysql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- /home/repository/moby/moby-live/Database/mobynamespace.mysql 2005/07/08 19:03:17 1.6
+++ /home/repository/moby/moby-live/Database/mobynamespace.mysql 2007/12/05 11:49:14 1.7
@@ -25,7 +25,7 @@
note mediumtext,
PRIMARY KEY (namespace_id),
UNIQUE KEY namespace_type (namespace_type)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `namespace_term2term`
@@ -37,5 +37,5 @@
namespace1_id int(11) NOT NULL default '0',
namespace2_id int(11) NOT NULL default '0',
PRIMARY KEY (assertion_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyobject.data,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- /home/repository/moby/moby-live/Database/mobyobject.data 2006/01/03 20:00:11 1.2
+++ /home/repository/moby/moby-live/Database/mobyobject.data 2007/12/05 11:49:14 1.3
@@ -17,7 +17,7 @@
contact_email varchar(255) NOT NULL default '',
PRIMARY KEY (object_id),
UNIQUE KEY object_type (object_type)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Dumping data for table `object`
@@ -41,7 +41,7 @@
object2_id int(11) NOT NULL default '0',
object2_articlename varchar(255) default NULL,
PRIMARY KEY (assertion_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Dumping data for table `object_term2term`
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyobject.mysql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- /home/repository/moby/moby-live/Database/mobyobject.mysql 2005/07/08 19:03:17 1.9
+++ /home/repository/moby/moby-live/Database/mobyobject.mysql 2007/12/05 11:49:14 1.10
@@ -17,7 +17,7 @@
contact_email varchar(255) NOT NULL default '',
PRIMARY KEY (object_id),
UNIQUE KEY object_type (object_type)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `object_term2term`
@@ -30,5 +30,5 @@
object2_id int(11) NOT NULL default '0',
object2_articlename varchar(255) default NULL,
PRIMARY KEY (assertion_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyrelationship.mysql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- /home/repository/moby/moby-live/Database/mobyrelationship.mysql 2005/07/08 19:03:17 1.5
+++ /home/repository/moby/moby-live/Database/mobyrelationship.mysql 2007/12/05 11:49:14 1.6
@@ -19,7 +19,7 @@
ontology varchar(200) NOT NULL default '',
PRIMARY KEY (relationship_id),
UNIQUE KEY LSID (relationship_lsid)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `relationship_term2term`
@@ -32,5 +32,5 @@
relationship2_id int(10) unsigned NOT NULL default '0',
object2_articlename varchar(255) default NULL,
PRIMARY KEY (assertion_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyservice.data,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- /home/repository/moby/moby-live/Database/mobyservice.data 2006/02/01 18:42:57 1.2
+++ /home/repository/moby/moby-live/Database/mobyservice.data 2007/12/05 11:49:14 1.3
@@ -1,3 +1,22 @@
+--
+-- Table structure for table `service`
+--
+
+CREATE TABLE service (
+ service_id int(10) unsigned NOT NULL auto_increment,
+ service_lsid varchar(255) NOT NULL default '',
+ service_type varchar(255) NOT NULL default '',
+ description text NOT NULL,
+ authority varchar(255) NOT NULL default '',
+ contact_email varchar(255) NOT NULL default '',
+ PRIMARY KEY (service_id),
+ UNIQUE KEY service_type (service_type)
+) ENGINE=MyISAM ;
+
+--
+-- Dumping data for table `service`
+--
+
INSERT INTO service VALUES (1,'urn:lsid:biomoby.org:servicetype:Service','Service','The base type','openinformatics.com','markw at illuminae.com');
INSERT INTO service VALUES (2,'urn:lsid:biomoby.org:servicetype:Retrieval','Retrieval','The base retrieval type','openinformatics.com','markw at illuminae.com');
INSERT INTO service VALUES (3,'urn:lsid:biomoby.org:servicetype:Resolution','Resolution','resolve data','openinformatics.com','markw at illuminae.com');
@@ -5,7 +24,21 @@
INSERT INTO service VALUES (5,'urn:lsid:biomoby.org:servicetype:Registration','Registration','register data','openinformatics.com','markw at illuminae.com');
INSERT INTO service VALUES (6,'urn:lsid:biomoby.org:servicetype:Analysis','Analysis','analyze data','openinformatics.com','markw at illuminae.com');
+--
+-- Table structure for table `service_term2term`
+--
+
+CREATE TABLE service_term2term (
+ assertion_id int(10) unsigned NOT NULL auto_increment,
+ relationship_type varchar(255) NOT NULL default '',
+ service1_id int(11) NOT NULL default '0',
+ service2_id int(11) NOT NULL default '0',
+ PRIMARY KEY (assertion_id)
+) ENGINE=MyISAM ;
+--
+-- Dumping data for table `service_term2term`
+--
INSERT INTO service_term2term VALUES (8,'urn:lsid:biomoby.org:servicerelation:isa',2,1);
INSERT INTO service_term2term VALUES (4,'urn:lsid:biomoby.org:servicerelation:isa',3,1);
===================================================================
RCS file: /home/repository/moby/moby-live/Database/mobyservice.mysql,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- /home/repository/moby/moby-live/Database/mobyservice.mysql 2005/07/08 19:03:17 1.7
+++ /home/repository/moby/moby-live/Database/mobyservice.mysql 2007/12/05 11:49:14 1.8
@@ -17,7 +17,7 @@
contact_email varchar(255) NOT NULL default '',
PRIMARY KEY (service_id),
UNIQUE KEY service_type (service_type)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
--
-- Table structure for table `service_term2term`
@@ -29,5 +29,5 @@
service1_id int(11) NOT NULL default '0',
service2_id int(11) NOT NULL default '0',
PRIMARY KEY (assertion_id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM ;
More information about the MOBY-guts
mailing list