00031_create_watched_logs_table.sql

-- +goose Up
-- SQL in this section is executed when the migration is applied.
CREATE TABLE public.watched_logs
(
    id               SERIAL PRIMARY KEY,
    contract_address VARCHAR(42),
    topic_zero       VARCHAR(66)
);

-- +goose Down
-- SQL in this section is executed when the migration is rolled back.
DROP TABLE public.watched_logs;