contrarian fixes: add recap_status/bio_status to canonical schema.sql (was ALTER-only drift), correct Jessica Stroup bio, add NEXT_PUBLIC_SITE_URL to deploy gate

5d109ee3fd42397d613ecaddad09126fc526104b · 2026-07-25 11:09:18 -0700 · Steve

Files touched

M db/bios.json
M db/schema.sql

Diff

commit 5d109ee3fd42397d613ecaddad09126fc526104b
Author: Steve <steve@designerwallcoverings.com>
Date:   Sat Jul 25 11:09:18 2026 -0700

    contrarian fixes: add recap_status/bio_status to canonical schema.sql (was ALTER-only drift), correct Jessica Stroup bio, add NEXT_PUBLIC_SITE_URL to deploy gate
---
 db/bios.json  | 2 +-
 db/schema.sql | 2 ++
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/db/bios.json b/db/bios.json
index e745957..dfc7f17 100644
--- a/db/bios.json
+++ b/db/bios.json
@@ -1,7 +1,7 @@
 {
   "_note": "ORIGINAL editorial bios in our own words, grounded in verifiable facts (birth year, nationality, role, one well-known credit). AI-drafted — human review before publish. No copied bio text; no photos.",
   "Shenae Grimes-Beech": { "character": "Annie Wilson", "bio": "Canadian actress (born 1989) who plays series lead Annie Wilson, the Kansas transplant at the heart of the reboot. She was already familiar to teen audiences from her years on the long-running Canadian drama Degrassi: The Next Generation." },
-  "Jessica Stroup": { "character": "Erin Silver", "bio": "American actress (born 1986) who plays Erin 'Silver' Silver across all five seasons. She went on to co-star in network dramas including The Following." },
+  "Jessica Stroup": { "character": "Erin Silver", "bio": "American actress (born 1986) who plays Erin 'Silver' Silver across all five seasons. She has since appeared in network dramas including The Following and iZombie." },
   "AnnaLynne McCord": { "character": "Naomi Clark", "bio": "American actress (born 1987) who plays the wealthy, sharp-edged Naomi Clark. Before 90210 she appeared on Nip/Tuck, and has since worked steadily across film and television." },
   "Jessica Lowndes": { "character": "Adrianna Tate-Duncan", "bio": "Canadian actress and singer-songwriter (born 1988) who plays aspiring performer Adrianna Tate-Duncan — a role that dovetailed with her own off-screen music career." },
   "Mack Wilds": { "character": "Dixon Wilson", "bio": "American actor and Grammy-nominated musician (born 1989), credited here as Tristan Wilds, who plays Dixon Wilson. He first drew notice as Michael Lee on the acclaimed HBO series The Wire." },
diff --git a/db/schema.sql b/db/schema.sql
index e9bd306..c9e8204 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -40,6 +40,7 @@ create table if not exists episodes (
   director          text,
   summary_short_original text,              -- spoiler-safe, ORIGINAL
   summary_full_original  text,              -- expanded, ORIGINAL
+  recap_status      text default 'needs-recap', -- needs-recap | ai-draft | reviewed
   spoiler_rating    int default 0,
   source_url        text,
   source_type       text,
@@ -54,6 +55,7 @@ create table if not exists cast_people (
   id                uuid primary key default uuid_generate_v4(),
   name              text not null,
   biography_original text,                  -- ORIGINAL bio
+  bio_status        text default 'needs-bio', -- needs-bio | ai-draft | reviewed
   official_site_url text,
   verified_social_links jsonb default '[]',
   headshot_asset_id uuid,                    -- FK added after assets exists

← e3f69d6 SEO layer: crawlable per-episode + per-cast detail pages w/ · back to Nineoh Guide · spoiler guard: progress-based recap hiding on web (SpoilerGu d2ccd5a →