11 lines
363 B
SQL
11 lines
363 B
SQL
CREATE TABLE bridge_validators
|
|
(
|
|
log_id SERIAL REFERENCES logs PRIMARY KEY,
|
|
bridge_id TEXT_ID,
|
|
chain_id CHAIN_ID,
|
|
address ADDRESS,
|
|
removed_log_id INT REFERENCES logs NULL,
|
|
updated_at TS_NOW,
|
|
created_at TS_NOW
|
|
);
|
|
CREATE INDEX signed_messages_bridge_id_signer_idx ON signed_messages (bridge_id, signer); |