index_all_the_things.php

<?php


Schema::table('clicks', function (Blueprint $table) {
    $table->index('user_id');
    $table->index(['user_id', 'date_clicked']);
    $table->index(['user_id', 'date_clicked', 'ip']);
    $table->index(['user_id', 'date_clicked', 'country']);
    $table->index(['user_id', 'date_clicked', 'city']);
    $table->index(['user_id', 'date_clicked', 'browser']);
    $table->index(['user_id', 'date_clicked', 'os']);
});

Schema::table('links', function (Blueprint $table) {
    $table->index('user_id');
});

Schema::table('pixels', function (Blueprint $table) {
    $table->index('user_id');
});