-- +goose up
CREATE TABLE transactions (
    id BIGSERIAL PRIMARY KEY,
    x402_transaction_hash VARCHAR(255) NOT NULL UNIQUE,
    amount NUMERIC NOT NULL,
    asset VARCHAR(255) NOT NULL,
    network VARCHAR(255) NOT NULL,
    recipient VARCHAR(255) NOT NULL,
    sender VARCHAR(255) NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT now()
);

-- +goose down
DROP TABLE transactions;