SELECT
block_timestamp, msg_value:sender::string as sender, tx_id,
HEX_ENCODE(BASE64_DECODE_BINARY(msg_value:execute_msg:submit_vaa:data::string)) as vaa_data,
CASE
WHEN vaa_data ILIKE '%0000000000000000000000000000000000000000000000000000000000000004%' THEN 'Solana Asset Meta'
WHEN vaa_data ILIKE '%0def15a24423e1edd1a5ab16f557b9060303ddbab8c803d2ee48f4b78a1cfd6b%' THEN 'Solana NFT'
WHEN vaa_data ILIKE '%ec7372995d5cc8732397fb0ad35c0121e0eaa90d26f828a534cab54391b3a4f5%' THEN 'Solana Token Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000003ee18b2214aff97000d974cf647e7c347e8fa585%' THEN 'Ethereum Token Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000006ffd7ede62328b3af38fcd61461bbfc52f5651fe%' THEN 'Ethereum NFT Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000005a58505a96d1dbf8df91cb21b54419fc36e93fde%' THEN 'BSC NFT Bridge'
WHEN vaa_data ILIKE '%000000000000000000000000b6f6d86a8f9879a9c87f643768d9efc38c1da6e7%' THEN 'BSC Token Bridge'
WHEN vaa_data ILIKE '%000000000000000000000000465862772f9c2e9d71982627bcfdc721a47deb22%' THEN 'Polygon Contract Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000005a58505a96d1dbf8df91cb21b54419fc36e93fde%' THEN 'Polygon Token Bridge'
WHEN vaa_data ILIKE '%00000000000000000000000090bbd86a6fe93d3bc3ed6335935447e75fab7fcf%' THEN 'Polygon NFT Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000000e082f06ff657d94310cb8ce8b0d9a04541d8052%' THEN 'Avax 8052'
WHEN vaa_data ILIKE '%000000000000000000000000f7b6737ca9c4e08ae573f75a97b73d7a813f5de5%' THEN 'Avax 5de5'
WHEN vaa_data ILIKE '%00000000000000000000000004952d522ff217f40b5ef3cbf659eca7b952a6c1%' THEN 'Oasis a6c1'
WHEN vaa_data ILIKE '%0000000000000000000000005848c791e09901b40a9ef749f2a6735b418d7564%' THEN 'Oasis 7564'
ELSE 'Unknown Chain'
END as emitter_chain
FROM terra.msgs
WHERE 1=1
--and tx_id = '05A1DF7D5B88490E0652A47EE069092A3123FCF0B9F5EAF4D89FFF5C2C6C3ED4' -- sol test tx
--and tx_id = '21A301D0DD1E712E98309E66E928E7607EC1D861F6FD31A561BB6154AF65E49D' -- oasis test tx
and msg_value:execute_msg:submit_vaa:data is not null
--and vaa_data ILIKE '%0000000000000000000000005848c791e09901b40a9ef749f2a6735b418d7564%'
limit 2
How to update above table
Use this website to figure out who are the contract emitters and add them to the list...
