Files
indexer/services/db/migrations/029_cchain_pk.down.sql

4 lines
228 B
SQL

create index cvm_transactions_txdata_hash ON cvm_transactions_txdata (hash);
drop index cvm_transactions_txdata_block ON cvm_transactions_txdata;
alter table cvm_transactions_txdata DROP PRIMARY KEY, ADD PRIMARY KEY(block,idx);