// events_tracking
use events_tracking

db.activityApprovals.createIndex( { eventId: 1, registrationOptionId: 1, riderId: 1, activityId: 1}, { unique: true } );

db.scorecards.createIndex( { eventId: 1, registrationOptionId: 1, riderId: 1}, { unique: true } );

db.controlMarkings.createIndex( { eventId: 1, registrationOptionId: 1, controlId: 1, riderId: 1}, { unique: true } );

db.registrationOptions.createIndex({eventId: 1, registrationOptionId}, {unque: true})


// activities db
use activities

db.activities.createIndex( { externalActivityId: 1, externalSourceName: 1}, { unique: true } );

db.activities.createIndex( { riderId: 1, startTimestamp: -1}, { unique: false } );

db.riderSummary.createIndex( { riderId: 1 }, { unique: true } );

db.riderYearlySummary.createIndex( { riderId: 1, year: 1 }, { unique: true } );

db.riderMonthlySummary.createIndex( { riderId: 1, year: 1, month: 1 }, { unique: true } );


// riders db
use riders

db.stravariders.createIndex( { riderId: 1 }, { unique: true } );

db.stravariders.createIndex( { stravaAthleteId: 1 }, { unique: true } );