solana-empty-geyser-plugin/migration.sql

24 lines
579 B
MySQL
Raw Permalink Normal View History

2023-10-16 06:58:08 -07:00
CREATE SCHEMA banking_stage_results;
CREATE TABLE banking_stage_results.transaction_infos (
signature CHAR(88) NOT NULL,
message text,
errors text,
is_executed BOOL,
is_confirmed BOOL,
first_notification_slot BIGINT NOT NULL,
cu_requested BIGINT,
prioritization_fees BIGINT,
time_of_first_notification BIGINT,
2023-10-16 06:58:08 -07:00
);
CREATE TABLE banking_stage_results.blocks (
block_hash text not null,
notification_timestamp BIGINT,
confirmed_timestamp BIGINT,
number_of_transactions BIGINT,
number_of_transactions BIGINT,
total_cu BIGINT,
cu_by_accounts text,
)