aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20260329120645_transaction_schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/migrations/20260329120645_transaction_schema.sql b/migrations/20260329120645_transaction_schema.sql
index d7b4744..8496c80 100644
--- a/migrations/20260329120645_transaction_schema.sql
+++ b/migrations/20260329120645_transaction_schema.sql
@@ -2,14 +2,14 @@
-- The transaction's blueprint to be checked on each request
create table transaction_schema (
-- The transaction type
- type text not null,
+ schema_type text not null,
-- The schema's version (to allow for multiple revisions - maybe)
- version varchar not null,
+ schema_version varchar not null,
-- Actual JSON schema
- json_schema jsonb not null,
+ schema jsonb not null,
created_at timestamptz not null default now(),
updated_at timestamptz not null default now(),
- primary key (type, version)
+ primary key (schema_type, schema_version)
);
create trigger update_transaction_schema_modtime