feat(schema): cursor pagination

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