From 57025734d0bcac7acab49cacb5cf5dd6af5be7d3 Mon Sep 17 00:00:00 2001
From: Fuwn <contact@fuwn.net>
Date: Fri, 27 Mar 2026 11:05:26 +0000
Subject: fix(manga): restore progress-based volume recommendations

---
 supabase/mangadex.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'supabase/mangadex.sql')

diff --git a/supabase/mangadex.sql b/supabase/mangadex.sql
index 79ea0408..658dd4aa 100644
--- a/supabase/mangadex.sql
+++ b/supabase/mangadex.sql
@@ -4,6 +4,7 @@ create table if not exists public.mangadex_manga_index (
   latest_en_chapter_text text,
   latest_en_chapter_number double precision,
   latest_en_volume_text text,
+  volume_chapter_boundaries jsonb,
   latest_en_chapter_id uuid,
   latest_chapter_updated_at timestamp with time zone,
   last_seen_at timestamp with time zone default (now() at time zone 'utc'::text) not null,
@@ -13,6 +14,9 @@ create table if not exists public.mangadex_manga_index (
   updated_at timestamp with time zone default (now() at time zone 'utc'::text) not null
 );
 
+alter table public.mangadex_manga_index
+  add column if not exists volume_chapter_boundaries jsonb;
+
 create index if not exists mangadex_manga_index_mangadex_id_idx
   on public.mangadex_manga_index (mangadex_id);
 
-- 
cgit v1.2.3

