[Gmod-schema-cmts] schema/chado/load/etc initialize.sql,1.8,1.9

[<all...@us...>]

Update of /cvsroot/gmod/schema/chado/load/etc
In directory sc8-pr-cvs1:/tmp/cvs-serv27543/load/etc

Modified Files:
	initialize.sql 
Log Message:
DBUSER removed in favor of NULL.  it would be better to use $USER, but taht
would requirethe sql to be made to a shell script... not sure we want to do
that.


Index: initialize.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/load/etc/initialize.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** initialize.sql	4 Dec 2003 02:11:13 -0000	1.8
--- initialize.sql	4 Dec 2003 02:19:10 -0000	1.9
***************
*** 2,6 ****
  insert into organism (abbreviation, genus, species, common_name)
         values ('H.sapiens', 'Homo','sapiens','Human');
- insert into contact (name) values ('DBUSER');
  insert into contact (name) values ('Affymetrix');
  insert into contact (name,description) values ('null','null');
--- 2,5 ----
***************
*** 18,24 ****
  
  insert into pub (miniref,type_id) values ('null',(select cvterm_id from cvterm where name = 'null'));
! insert into db (name, contact_id) values ('DB:refseq',1);
! insert into db (name, contact_id) values ('DB:genbank',1);
! insert into db (name, contact_id) values ('DB:ucsc',1);
  
  insert into array (name,manufacturer_id,platformtype_id) values ('unknown',(select contact_id from contact where name = 'null'),(select cvterm_id from cvterm where name = 'null'));
--- 17,23 ----
  
  insert into pub (miniref,type_id) values ('null',(select cvterm_id from cvterm where name = 'null'));
! insert into db (name, contact_id) values ('DB:refseq' ,(select contact_id from contact where name = 'null'));
! insert into db (name, contact_id) values ('DB:genbank',(select contact_id from contact where name = 'null'));
! insert into db (name, contact_id) values ('DB:ucsc'   ,(select contact_id from contact where name = 'null'));
  
  insert into array (name,manufacturer_id,platformtype_id) values ('unknown',(select contact_id from contact where name = 'null'),(select cvterm_id from cvterm where name = 'null'));