solana.account_activitytable has been updated to a new version. The new version of the table contains additional information around token activity. The following columns were added to the table:
solana.account_activitytable that contains all of the information about an account’s usage in a transaction.
solana.transactionstable has now been upgraded to a new version. The new version of the table uses cleaner array structs to make it easier to extract useful information.
solana.vote_transactions, so queries using
solana.transactionswill have better performance. Unfortunately, the table change also means that some existing queries will now break and need to be changed.
WHERE ARRAY_CONTAINS(account_keys, "Vote111111111111111111111111111111111111111") = false
error_messagecolumns have been removed, and have been merged into the
errorcolumn (which is a struct). So now instead of
WHERE error_index is not null, a query should do
WHERE error is not null.
account_keysnow include the account address directly, so there is no need to use the
account_keyscolumn to look up the account addresses:
post_token_balancescolumns have changed. The token balance is now included in the field
amount. And as mentioned above, the struct in the array now has a field
account, which is the account of the token balance.
instructionscolumn has changed. As mentioned above, the struct in the array now has a field
executing_account, which is the account executing the instruction.
inner_instructionscolumn is removed, and inner instructions have been moved into the