diff options
Diffstat (limited to 'migrations/20260329120645_transaction_schema.sql')
| -rw-r--r-- | migrations/20260329120645_transaction_schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/migrations/20260329120645_transaction_schema.sql b/migrations/20260329120645_transaction_schema.sql index 8496c80..7868591 100644 --- a/migrations/20260329120645_transaction_schema.sql +++ b/migrations/20260329120645_transaction_schema.sql @@ -1,6 +1,7 @@ -- Add migration script here -- The transaction's blueprint to be checked on each request create table transaction_schema ( + id bigserial primary key, -- The transaction type schema_type text not null, -- The schema's version (to allow for multiple revisions - maybe) @@ -9,7 +10,7 @@ create table transaction_schema ( schema jsonb not null, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), - primary key (schema_type, schema_version) + unique (schema_type, schema_version) ); create trigger update_transaction_schema_modtime |