[MOBY-guts] biomoby commit

[Mark Wilkinson]

mwilkinson
Wed May  7 19:56:49 EDT 2003
Update of /home/repository/moby/moby-live/Database
In directory pub.open-bio.org:/tmp/cvs-serv30270/Database

Modified Files:
	new_schema.sql 
Log Message:
fixing database table defs
moby-live/Database new_schema.sql,1.3,1.4
===================================================================
RCS file: /home/repository/moby/moby-live/Database/new_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- /home/repository/moby/moby-live/Database/new_schema.sql	2003/05/07 23:16:11	1.3
+++ /home/repository/moby/moby-live/Database/new_schema.sql	2003/05/07 23:56:49	1.4
@@ -21,17 +21,17 @@
 --
 
 
+INSERT INTO authority VALUES (NULL,'your.URI.here','your_name at contact.address.com',1);
 
 --
 -- Table structure for table 'collection_input'
 --
 
 CREATE TABLE collection_input (
-  collection_id int(10) unsigned NOT NULL auto_increment,
-  simple_input_id int(10) unsigned NOT NULL default '0',
+  collection_input_id int(10) unsigned NOT NULL auto_increment,
   article_name varchar(255) default NULL,
   service_instance_id int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (collection_id)
+  PRIMARY KEY  (collection_input_id)
 ) TYPE=MyISAM;
 
 --
@@ -46,7 +46,6 @@
 
 CREATE TABLE collection_output (
   collection_output_id int(10) unsigned NOT NULL auto_increment,
-  simple_output_id int(10) unsigned NOT NULL default '0',
   article_name varchar(255) default NULL,
   service_instance_id int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (collection_output_id)
@@ -59,49 +58,15 @@
 
 
 --
--- Table structure for table 'namespace_type'
---
-
-CREATE TABLE namespace_type (
-  namespace_type_id int(10) unsigned NOT NULL auto_increment,
-  rdf_definition varchar(255) NOT NULL default '',
-  name varchar(255) NOT NULL default '',
-  PRIMARY KEY  (namespace_type_id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table 'namespace_type'
---
-
-
-
---
--- Table structure for table 'object_type'
---
-
-CREATE TABLE object_type (
-  object_type_id int(10) unsigned NOT NULL auto_increment,
-  rdf_definition varchar(255) NOT NULL default '',
-  name varchar(255) NOT NULL default '',
-  PRIMARY KEY  (object_type_id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table 'object_type'
---
-
-
-
---
 -- Table structure for table 'secondary_input'
 --
 
 CREATE TABLE secondary_input (
   secondary_input_id int(10) unsigned NOT NULL auto_increment,
   default_value text,
-  maximum decimal(10,0) default NULL,
-  minimim decimal(10,0) default NULL,
-  enum text,
+  maximum_value decimal(10,0) default NULL,
+  minimum_value decimal(10,0) default NULL,
+  enum_value text,
   datatype enum('INT','FLOAT','STRING') NOT NULL default 'INT',
   article_name varchar(255) default NULL,
   service_instance_id int(10) unsigned NOT NULL default '0',
@@ -121,7 +86,7 @@
 CREATE TABLE service_instance (
   category enum('moby','cgi','soap') NOT NULL default 'moby',
   servicename varchar(255) NOT NULL default '',
-  service_type_uri varchar(255) NOT NULL,
+  service_type_uri varchar(255) NOT NULL default '',
   authority_id int(10) unsigned NOT NULL default '0',
   url varchar(255) NOT NULL default '',
   contact_email varchar(255) NOT NULL default '',
@@ -138,32 +103,16 @@
 
 
 --
--- Table structure for table 'service_type'
---
-
-CREATE TABLE service_type (
-  service_type_id int(10) unsigned NOT NULL auto_increment,
-  rdf_definition varchar(255) NOT NULL default '',
-  name varchar(255) NOT NULL default '',
-  PRIMARY KEY  (service_type_id)
-) TYPE=MyISAM;
-
---
--- Dumping data for table 'service_type'
---
-
-
-
---
 -- Table structure for table 'simple_input'
 --
 
 CREATE TABLE simple_input (
   simple_input_id int(10) unsigned NOT NULL auto_increment,
-  object_type_id int(10) unsigned NOT NULL default '0',
-  namespace_type_ids varchar(255) default NULL,
+  object_type_uri varchar(255) NOT NULL default '',
+  namespace_type_uris text,
   article_name varchar(255) default NULL,
   service_instance_id int(10) unsigned default NULL,
+  collection_input_id int(10) unsigned default NULL,
   PRIMARY KEY  (simple_input_id)
 ) TYPE=MyISAM;
 
@@ -179,10 +128,11 @@
 
 CREATE TABLE simple_output (
   simple_output_id int(10) unsigned NOT NULL auto_increment,
-  object_type_id int(10) unsigned NOT NULL default '0',
-  namespace_type_ids varchar(255) default NULL,
+  object_type_uri varchar(255) NOT NULL default '',
+  namespace_type_uris text,
   article_name varchar(255) default NULL,
   service_instance_id int(10) unsigned default NULL,
+  collection_output_id int(10) unsigned default NULL,
   PRIMARY KEY  (simple_output_id)
 ) TYPE=MyISAM;