Files
stacks-blockchain-api/migrations/1674838340313_contract_logs_block_height_index.js
2023-02-03 10:03:44 -06:00

10 lines
310 B
JavaScript

/** @param { import("node-pg-migrate").MigrationBuilder } pgm */
exports.up = pgm => {
pgm.createIndex('contract_logs', [
{ name: 'block_height', sort: 'DESC' },
{ name: 'microblock_sequence', sort: 'DESC' },
{ name: 'tx_index', sort: 'DESC' },
{ name: 'event_index', sort: 'DESC' },
]);
}