18F/analytics-reporter-api

exports.up = function (knex) {
  return knex.schema.raw(
    "CREATE INDEX analytics_data_date_desc_id_asc ON analytics_data (date DESC NULLS LAST, id ASC)",
  );
};

exports.down = function (knex) {
  return knex.schema.table("analytics_data", (table) => {
    table.dropIndex("analytics_data_date_desc_id_asc");
  });
};