[phylr] r44 commited - fixed a few errors

[codesite...@google.com]

Revision: 44
Author: dazhi.jiao
Date: Mon Jul 27 11:01:26 2009
Log: fixed a few errors
http://code.google.com/p/phylr/source/detail?r=44

Modified:
/trunk/phylr-gsoc/src/main/sql/TreeBaseBioSQLMig.sql

=======================================
--- /trunk/phylr-gsoc/src/main/sql/TreeBaseBioSQLMig.sql Mon Jul 27
09:54:16 2009
+++ /trunk/phylr-gsoc/src/main/sql/TreeBaseBioSQLMig.sql Mon Jul 27
11:01:26 2009
@@ -81,7 +81,7 @@
-- TAXON
INSERT INTO node_taxon (node_id, taxon_id)
SELECT n.node_id, t.taxon_id FROM nodes n, taxon t, taxa tx
- WHERE n.taxon_id = tx.taxon_id and tx.taxid = t.ncbi_taxon_id
+ WHERE n.taxon_id = tx.taxon_id and tx.taxid = t.ncbi_taxon_id;

-- STUDY
INSERT INTO ontology (name, definition) VALUES ('Dublin Core', 'Dublin
Core Metadata Initiative (DCMI)');
@@ -93,23 +93,23 @@

INSERT INTO tree_qualifier_value (tree_id, term_id, value)
SELECT tr.tree_id, te.term_id, s.study_id FROM trees tr, term te, study
s, ontology o
- WHERE tr.study_id = s.study_id AND te.name='identifier' AND
te.ontology_id = o.ontology_id AND o.name='Dublin Core'
+ WHERE tr.study_id = s.study_id AND te.name='identifier' AND
te.ontology_id = o.ontology_id AND o.name='Dublin Core';

INSERT INTO tree_qualifier_value (tree_id, term_id, value)
SELECT tr.tree_id, te.term_id, s.author FROM trees tr, term te, study s,
ontology o
- WHERE tr.study_id = s.study_id AND te.name='contributor' AND
te.ontology_id = o.ontology_id AND o.name='Dublin Core'
+ WHERE tr.study_id = s.study_id AND te.name='contributor' AND
te.ontology_id = o.ontology_id AND o.name='Dublin Core';

INSERT INTO tree_qualifier_value (tree_id, term_id, value)
SELECT tr.tree_id, te.term_id, s.title FROM trees tr, term te, study s,
ontology o
- WHERE tr.study_id = s.study_id AND te.name='title' AND te.ontology_id =
o.ontology_id AND o.name='Dublin Core'
+ WHERE tr.study_id = s.study_id AND te.name='title' AND te.ontology_id =
o.ontology_id AND o.name='Dublin Core';

INSERT INTO tree_qualifier_value (tree_id, term_id, value)
SELECT tr.tree_id, te.term_id, s.abstract FROM trees tr, term te, study
s, ontology o
- WHERE tr.study_id = s.study_id AND te.name='abstract' AND te.ontology_id
= o.ontology_id AND o.name='Dublin Core'
+ WHERE tr.study_id = s.study_id AND te.name='abstract' AND te.ontology_id
= o.ontology_id AND o.name='Dublin Core';

INSERT INTO tree_qualifier_value (tree_id, term_id, value)
SELECT tr.tree_id, te.term_id, s.doi FROM trees tr, term te, study s,
ontology o
- WHERE tr.study_id = s.study_id AND te.name='study.doi' AND te.ontology_id
= o.ontology_id AND o.name='TreeBase DB'
+ WHERE tr.study_id = s.study_id AND te.name='study.doi' AND te.ontology_id
= o.ontology_id AND o.name='TreeBase DB';

-- DROP TreeBase Tables
DROP TABLE edges, ncbi_names, ncbi_node_path, ncbi_nodes, node_path,
nodes, study, taxa, taxon_variants, trees;