[MOBY-guts] biomoby commit

[Mark Wilkinson]

mwilkinson
Wed Feb 19 23:21:55 EST 2003
Update of /home/repository/moby/moby-live/Database
In directory pub.open-bio.org:/tmp/cvs-serv18639

Modified Files:
	schema.mysql 
Log Message:
fixed problem with indexes on bootstrap SQL tables
moby-live/Database schema.mysql,1.1,1.2
===================================================================
RCS file: /home/repository/moby/moby-live/Database/schema.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- /home/repository/moby/moby-live/Database/schema.mysql	2003/02/19 20:59:55	1.1
+++ /home/repository/moby/moby-live/Database/schema.mysql	2003/02/20 04:21:54	1.2
@@ -63,8 +63,8 @@
 
 
 INSERT INTO OntologyEntry VALUES (1,'Object','markw at illuminae.com','000001',1,'Base for all Objects','n','y');
-INSERT INTO OntologyEntry VALUES (1,'Service','markw at illuminae.com','000001',2,'Base for all Services','n','y');
-INSERT INTO OntologyEntry VALUES (1,'Namespace','markw at illuminae.com','000001',3,'Base for all Namespaces','n','y');
+INSERT INTO OntologyEntry VALUES (2,'Service','markw at illuminae.com','000001',2,'Base for all Services','n','y');
+INSERT INTO OntologyEntry VALUES (3,'Namespace','markw at illuminae.com','000001',3,'Base for all Namespaces','n','y');
 
 --
 -- Table structure for table 'RelationshipType'
@@ -83,7 +83,7 @@
 
 
 INSERT INTO RelationshipType VALUES (1,'is a','the second object is an example of the first object');
-INSERT INTO RelationshipType VALUES (1,'has a','the second object contains at least one instance of the first object');
+INSERT INTO RelationshipType VALUES (2,'has a','the second object contains at least one instance of the first object');
 
 --
 -- Table structure for table 'Service'
@@ -97,6 +97,7 @@
   url varchar(128) NOT NULL default '',
   description text NOT NULL,
   registration_identifier varchar(128) NOT NULL default '',
+  category enum ('moby', 'cgi', 'soap') NOT NULL,
   PRIMARY KEY  (id)
 ) TYPE=MyISAM;