github.com/billybanfield/evergreen@v0.0.0-20170525200750-eeee692790f7/scripts/indexes.js (about)

     1  //======alertrecord======//
     2  db.alertrecord.ensureIndex({ "host_id" : 1 })
     3  db.alertrecord.ensureIndex({ "version_id" : 1, "type" : 1 })
     4  db.alertrecord.ensureIndex({ "type" : 1, "version_id" : 1 })
     5  
     6  //======artifact_files======//
     7  db.artifact_files.ensureIndex({ "task" : 1 })
     8  db.artifact_files.ensureIndex({ "build" : 1 })
     9  
    10  //======builds======//
    11  db.builds.ensureIndex({ "build_variant" : 1, "status" : 1, "order" : 1 })
    12  db.builds.ensureIndex({ "start_time" : 1 })
    13  db.builds.ensureIndex({ "finished" : 1 })
    14  db.builds.ensureIndex({ "gitspec" : 1 })
    15  db.builds.ensureIndex({ "version" : 1 })
    16  db.builds.ensureIndex({ "branch" : 1, "r" : 1, "order" : 1 })
    17  
    18  //======patch files====//
    19  db.patchfiles.files.ensureIndex({"filename":1})
    20  
    21  //======event_log======//
    22  db.event_log.ensureIndex({ "r_id" : 1, "data.r_type" : 1, "ts" : 1 })
    23  
    24  //======hosts======//
    25  db.hosts.ensureIndex({ "status": 1 })
    26  db.hosts.ensureIndex({ "started_by" : 1, "status" : 1 })
    27  db.hosts.ensureIndex({ "running_task" : 1, "status" : 1 })
    28  db.hosts.ensureIndex({ "host_type" : 1, "_id" : 1 })
    29  db.hosts.ensureIndex({ "branch" : 1, "create_time" : 1 })
    30  db.hosts.ensureIndex({ "version" : 1 })
    31  db.hosts.ensureIndex({ "author" : 1 })
    32  db.hosts.ensureIndex({ "distro._id" : 1, "status" : 1 })
    33  db.hosts.ensureIndex({ "status" : 1, "create_time": 1, "termination_time" : 1, "provider": 1 })
    34  db.hosts.ensureIndex({ "running_task": 1}, {sparse: true, unique: true})
    35  
    36  //======pushes======//
    37  db.pushes.ensureIndex({ "status" : 1, "location" : 1, "order" : 1 })
    38  
    39  //======patches======//
    40  db.patches.ensureIndex({ "branch" : 1, "create_time" : 1 })
    41  db.patches.ensureIndex({ "version" : 1 })
    42  db.patches.ensureIndex({ "author" : 1, "create_time" : 1 })
    43  
    44  //======project_ref======//
    45  db.project_ref.ensureIndex({ "identifier" : 1 })
    46  
    47  //======spawn_requests======//
    48  db.spawn_requests.ensureIndex({ "host" : 1 })
    49  db.spawn_requests.ensureIndex({ "user" : 1, "status" : 1 })
    50  
    51  //======task_bk======//
    52  db.task_bk.ensureIndex({ "branch" : 1, "build_variant" : 1, "name" : 1 })
    53  
    54  //======task_event_log======//
    55  db.task_event_log.ensureIndex({ "r_id" : 1, "data.r_type" : 1, "ts" : 1 })
    56  
    57  //======tasks======//
    58  db.tasks.ensureIndex({ "build_variant" : 1, "display_name" : 1, "order" : 1 })
    59  db.tasks.ensureIndex({ "gitspec" : 1, "build_variant" : 1, "display_name" : 1 })
    60  db.tasks.ensureIndex({ "status" : 1, "build_variant" : 1, "order" : 1 })
    61  db.tasks.ensureIndex({ "build_variant" : 1, "display_name" : 1, "status" : 1, "order" : 1 })
    62  db.tasks.ensureIndex({ "branch":1, "build_variant":1, "display_name":1, "status":1, "r":1, "activated":1, "order":1})
    63  db.tasks.ensureIndex({ "activated" : 1, "status" : 1 })
    64  db.tasks.ensureIndex({ "branch" : 1, "build_variant" : 1, "status" : 1, "finish_time" : 1 })
    65  db.tasks.ensureIndex({ "build_id" : 1 })
    66  db.tasks.ensureIndex({ "status" : 1, "finish_time" : 1 })
    67  db.tasks.ensureIndex({ "version" : 1, "display_name" : 1 })
    68  db.tasks.ensureIndex({ "order" : 1, "display_name" : 1 })
    69  db.tasks.ensureIndex({ "status": 1, "start_time" : 1, "finish_time" : 1})
    70  db.tasks.ensureIndex({ "branch": 1, "status": 1, "test_results.test_file" : 1, "test_results.status": 1}, {partialFilterExpression: {"branch": "mongodb-mongo-master"}})
    71  
    72  
    73  //======versions======//
    74  db.versions.ensureIndex({ "order" : 1 })
    75  db.versions.ensureIndex({ "builds" : 1 })
    76  db.versions.ensureIndex({ "identifier" : 1, "r" : 1, "order" : 1 })
    77  db.versions.ensureIndex({ "branch" : 1, "gitspec" : 1 })
    78  db.versions.ensureIndex({ "versions.build_variant_status.build_variant" : 1, "versions.build_variant_status.activated" : 1, "r": 1 })
    79  
    80  //======alerts=======//
    81  db.alerts.ensureIndex({ "queue_status" : 1 })
    82  
    83  //======test_logs=====//
    84  db.test_logs.ensureIndex({ "execution" : 1, "name" : 1, "task" : 1 })
    85  
    86  //======json======//
    87  db.json.ensureIndex({ "task_id" : 1 })
    88  db.json.ensureIndex({ "project_id" : 1, "tag" : 1 })
    89  db.json.ensureIndex({ "name" : 1, "task_id" : 1 })