fix(manga): restore progress-based volume recommendations

1 files changed, 4 insertions, 0 deletions

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);