Changeset 1417

Show
Ignore:
Timestamp:
02/27/08 01:58:06 (5 months ago)
Author:
bchoate
Message:

Updated indexes for mt_ts_job to use concatenated keys.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/release-30/build/mt-dists/default.mk

    r1398 r1417  
    22 
    33PRODUCT_VERSION = 4.2 
    4 SCHEMA_VERSION = 4.0038 
     4SCHEMA_VERSION = 4.0039 
    55API_VERSION = 4.2 
    66 

  • branches/release-30/lib/MT/TheSchwartz/Job.pm

    r1401 r1417  
    2525    primary_key => 'jobid', 
    2626    indexes => { 
    27         funcid => 1, 
    28         coalesce => 1, 
    29         uniqkey => 1, 
    30         run_after => 1, 
    31         priority => 1, 
     27        funccoal => { 
     28            columns => [ 'funcid', 'coalesce' ], 
     29        }, 
     30        funcrun => { 
     31            columns => [ 'funcid', 'run_after' ], 
     32        }, 
     33        funcpri => { 
     34            columns => [ 'funcid', 'priority' ], 
     35        }, 
    3236        uniqfunc => { 
    3337            columns => [ 'funcid', 'uniqkey' ], 
    …… 
    3539        }, 
    3640    }, 
    37     # not captured (but indexed separately) 
    38     # INDEX (funcid, run_after), 
    39     # INDEX (funcid, coalesce) 
    4041}); 
    4142