2 files changed, 25 insertions, 0 deletions
diff --git a/migrations/20260329120607_functions.sql b/migrations/20260329120607_functions.sql
new file mode 100644
index 0000000..f662c25
--- /dev/null
+++ b/migrations/20260329120607_functions.sql
@@ -0,0 +1,7 @@
+create or replace function update_updated_at_column()
+returns trigger as $$
+begin
+    new.updated_at = now();
+    return new;
+end;
+$$ language 'plpgsql';
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();