Nacorid
63709524de
- schema: add IF NOT EXISTS to CREATE TABLE/INDEX for idempotent migrations
- store: regenerate with sqlc v1.31.1 (adds UserStylePost, interface{} for Embedding)
- webhook: minor formatting cleanup
14 lines
No EOL
406 B
SQL
14 lines
No EOL
406 B
SQL
-- +goose up
|
|
CREATE TABLE IF NOT EXISTS 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; |