Changeset 555

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

added Series to Info table

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • trunk/dbbuilder/src/org/bridgedb/extract/Ensembl_ETL_Device_v18_local.pl

    r548 r555  
    518518my %Info = ('NAME' => ['Info'],  
    519519            'HEADER' => ['Owner VARCHAR(128) DEFAULT NULL',  
     520                         'Series VARCHAR(31) NOT NULL DEFAULT \'\'', 
    520521                         'Version INT(10) UNSIGNED NOT NULL DEFAULT \'0\'',  
    521522                         'MODSystem VARCHAR(128)  NOT NULL DEFAULT \'\'',  
     
    526527 
    527528# Populate Info Table 
    528 $Info{1} = ["\'GenMAPP\.org\'", "\'$dateArg\'", "\'$mod_system\'", "\'\|$species\|\'", "\'$dateArg\'", "\'\'", "\'$dbname\'"]; 
     529$Info{1} = ["\'BridgeDb\.org\'", "\'$species genes and proteins\'", "\'$dateArg\'", "\'$mod_system\'", "\'\|$species\|\'", "\'$dateArg\'", "\'\'", "\'$dbname\'"]; 
    529530 
    530531############################################################################ 
     
    12871288                # ENTER DISPLAY ORDER INTO INFO TABLE 
    12881289                $displayOrder = join("|", @systemTables); 
    1289                 $Info{1}[5] = "\'\|$displayOrder\|\'"; 
     1290                $Info{1}[6] = "\'\|$displayOrder\|\'"; 
    12901291 
    12911292                ## OVERWRITE SUMMARY TABLES EACH COLLECTION 
     
    13761377                # ENTER DISPLAY ORDER INTO INFO TABLE 
    13771378                $displayOrder = join("|", @systemTables); 
    1378                 $Info{1}[5] = "\'\|$displayOrder\|\'"; 
     1379                $Info{1}[6] = "\'\|$displayOrder\|\'"; 
    13791380 
    13801381                ## OVERWRITE SUMMARY TABLES EACH COLLECTION