feat: create transaction schema

1 files changed, 18 insertions, 0 deletions

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();