20 lines
721 B
SQL
20 lines
721 B
SQL
-- CCIP messages table
|
|
|
|
CREATE TABLE IF NOT EXISTS ccip_messages (
|
|
message_id VARCHAR(255) PRIMARY KEY,
|
|
source_chain_id INTEGER NOT NULL,
|
|
dest_chain_id INTEGER NOT NULL,
|
|
source_tx_hash VARCHAR(66),
|
|
dest_tx_hash VARCHAR(66),
|
|
status VARCHAR(20) NOT NULL CHECK (status IN ('pending', 'delivered', 'failed')),
|
|
created_at TIMESTAMP DEFAULT NOW(),
|
|
delivered_at TIMESTAMP
|
|
);
|
|
|
|
CREATE INDEX idx_ccip_source_chain ON ccip_messages(source_chain_id);
|
|
CREATE INDEX idx_ccip_dest_chain ON ccip_messages(dest_chain_id);
|
|
CREATE INDEX idx_ccip_status ON ccip_messages(status);
|
|
CREATE INDEX idx_ccip_source_tx ON ccip_messages(source_tx_hash);
|
|
CREATE INDEX idx_ccip_dest_tx ON ccip_messages(dest_tx_hash);
|
|
|