From daeb5311840680599a0ce6e49d181b9289010f68 Mon Sep 17 00:00:00 2001
From: rtkay123 <dev@kanjala.com>
Date: Wed, 1 Apr 2026 09:05:33 +0200
Subject: feat(schema): cursor pagination

---
 migrations/20260329120645_transaction_schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'migrations/20260329120645_transaction_schema.sql')

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
-- 
cgit v1.2.3

