Changeset 418

Timestamp:

06/24/10 21:00:13 (20 months ago)

Author:

AlexanderPico

Message:

added Kg and Bc to build step

Files:

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

trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioMySQL_BUILD.sql.template

@@ -92 +92 @@
 FROM genmapp_XXXXXX_CS_YYYYYY.gene
 WHERE genmapp_XXXXXX_CS_YYYYYY.gene.ID != '' 
-AND genmapp_XXXXXX_CS_YYYYYY.gene.Code IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw");
+AND genmapp_XXXXXX_CS_YYYYYY.gene.Code IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc");
 
 ## Fill 'link'
@@ -99 +99 @@
 SELECT DISTINCT *
 FROM genmapp_XXXXXX_CS_YYYYYY.link
-WHERE genmapp_XXXXXX_CS_YYYYYY.link.Code_Right IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw");
+WHERE genmapp_XXXXXX_CS_YYYYYY.link.Code_Right IN ("EnXXXXXX","Mb","L","X","Il","Ag","Q","Om","U","Rf","S","Ip","T","Pd","H","M","R","D","Z","F","W","Gg","A","Ti","Ir","N","Uc","Pl","Gm","Bg","Ec","Wg","Gw","Kg","Bc");
 
 ##Add Ensembl IDs to right side of 'link' table