Changeset 354 for trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioMySQL_BEEF.sql

Timestamp:

05/16/10 00:28:39 (2 years ago)

Author:

AlexanderPico

Message:

updated to work on plato

Files:

• trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioMySQL_BEEF.sql (modified) (2 diffs)

trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioMySQL_BEEF.sql

@@ -5 +5 @@
 ## Use 'Name' for GO-Slim additions
 INSERT INTO datanode
-SELECT XXXXXX_CS_YYYYYY.gene.Name, XXXXXX_CS_YYYYYY.gene.Code
-FROM XXXXXX_CS_YYYYYY.gene
-WHERE XXXXXX_CS_YYYYYY.gene.Name != ''
-AND XXXXXX_CS_YYYYYY.gene.Code IN ("Tb", "Tc", "Tm");
+SELECT genmapp_XXXXXX_CS_YYYYYY.gene.Name, genmapp_XXXXXX_CS_YYYYYY.gene.Code
+FROM genmapp_XXXXXX_CS_YYYYYY.gene
+WHERE genmapp_XXXXXX_CS_YYYYYY.gene.Name != ''
+AND genmapp_XXXXXX_CS_YYYYYY.gene.Code IN ("Tb", "Tc", "Tm");
 
 ## Beef up 'link'
@@ -14 +14 @@
 INSERT INTO link
 SELECT DISTINCT id_left, code_left, Name, code_right
-FROM XXXXXX_CS_YYYYYY.link left join XXXXXX_CS_YYYYYY.gene on XXXXXX_CS_YYYYYY.link.id_right = XXXXXX_CS_YYYYYY.gene.id
-WHERE XXXXXX_CS_YYYYYY.link.Code_Right IN ("Tb", "Tc", "Tm");
+FROM genmapp_XXXXXX_CS_YYYYYY.link left join genmapp_XXXXXX_CS_YYYYYY.gene on genmapp_XXXXXX_CS_YYYYYY.link.id_right = genmapp_XXXXXX_CS_YYYYYY.gene.id
+WHERE genmapp_XXXXXX_CS_YYYYYY.link.Code_Right IN ("Tb", "Tc", "Tm");