Changeset 556

Show
Ignore:
Timestamp:
12/06/11 19:55:16 (6 months ago)
Author:
AlexanderPico
Message:

added Series to Info table

Location:
trunk/dbbuilder/src/org/bridgedb/build/scripts
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/dbbuilder/src/org/bridgedb/build/scripts/PathVisioDerby_CREATE.sql

    r112 r556  
    3535DROP TABLE info; 
    3636CREATE TABLE info ( 
     37  series VARCHAR(31) NOT NULL, 
    3738  buildDate INTEGER, 
    3839  schemaVersion INTEGER, 

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

    r547 r556  
    5555## Create 'info' 
    5656CREATE TABLE info ( 
     57        series VARCHAR(31) NOT NULL, 
    5758        buildDate INTEGER, 
    5859        schemaVersion INTEGER, 
    … …  
    7475## Fill 'info' 
    7576INSERT INTO info  
    76 SELECT genmapp_XXXXXX_CS_YYYYYY.Info.Version, '3', 'Ensembl', genmapp_XXXXXX_CS_YYYYYY.Info.Notes, genmapp_XXXXXX_CS_YYYYYY.Info.Species, 'GeneProduct'  
     77SELECT genmapp_XXXXXX_CS_YYYYYY.Info.Series, genmapp_XXXXXX_CS_YYYYYY.Info.Version, '3', 'Ensembl', genmapp_XXXXXX_CS_YYYYYY.Info.Notes, genmapp_XXXXXX_CS_YYYYYY.Info.Species, 'GeneProduct'  
    7778FROM genmapp_XXXXXX_CS_YYYYYY.Info; 
    7879