13 lines
307 B
MySQL
13 lines
307 B
MySQL
|
-- +goose Up
|
||
|
|
CREATE TABLE eth.blob_hashes (
|
||
|
|
tx_hash VARCHAR(66) NOT NULL,
|
||
|
|
index INTEGER NOT NULL,
|
||
|
|
blob_hash BYTEA NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE UNIQUE INDEX blob_hashes_tx_hash_index ON eth.blob_hashes(tx_hash, index);
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
DROP INDEX eth.blob_hashes_tx_hash_index;
|
||
|
|
DROP TABLE eth.blob_hashes;
|