14 lines
No EOL
392 B
SQL
14 lines
No EOL
392 B
SQL
-- +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; |