From 7e08464b2a42048ebb5128bec5731719cf8bd1db Mon Sep 17 00:00:00 2001 From: rtkay123 Date: Sun, 29 Mar 2026 15:06:30 +0200 Subject: feat: create transaction schema --- migrations/20260329120645_transaction_schema.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 migrations/20260329120645_transaction_schema.sql (limited to 'migrations/20260329120645_transaction_schema.sql') diff --git a/migrations/20260329120645_transaction_schema.sql b/migrations/20260329120645_transaction_schema.sql new file mode 100644 index 0000000..d7b4744 --- /dev/null +++ b/migrations/20260329120645_transaction_schema.sql @@ -0,0 +1,18 @@ +-- Add migration script here +-- The transaction's blueprint to be checked on each request +create table transaction_schema ( + -- The transaction type + type text not null, + -- The schema's version (to allow for multiple revisions - maybe) + version varchar not null, + -- Actual JSON schema + json_schema jsonb not null, + created_at timestamptz not null default now(), + updated_at timestamptz not null default now(), + primary key (type, version) +); + +create trigger update_transaction_schema_modtime + before update on transaction_schema + for each row + execute function update_updated_at_column(); -- cgit v1.2.3