Compliance: unpublish 31 settlement-legal-block designs catalog-wide (BLOCK + vision-error), leave BLEED_GHOST quality verdicts

15cf1882321312bd049ae81ae83a91f6a86d5d06 · 2026-05-30 20:25:00 -0700 · Steve Abrams

Files touched

A scripts/unpublish-settlement-legal-blocks.sql

Diff

commit 15cf1882321312bd049ae81ae83a91f6a86d5d06
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sat May 30 20:25:00 2026 -0700

    Compliance: unpublish 31 settlement-legal-block designs catalog-wide (BLOCK + vision-error), leave BLEED_GHOST quality verdicts
---
 scripts/unpublish-settlement-legal-blocks.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

diff --git a/scripts/unpublish-settlement-legal-blocks.sql b/scripts/unpublish-settlement-legal-blocks.sql
new file mode 100644
index 0000000..72f8393
--- /dev/null
+++ b/scripts/unpublish-settlement-legal-blocks.sql
@@ -0,0 +1,21 @@
+-- COMPLIANCE 2026-05-30 (Steve: "audit + unpublish true BLOCKs, leave quality"):
+-- Unpublish ALL live designs whose settlement_verdict is a genuine LEGAL block —
+-- 'BLOCK' (Part A + Part B settlement violation) or 'REVIEW-VISION-ERROR%' (post-gen
+-- vision unavailable → fail-closed). LEAVES BLEED_GHOST_* (bleed/ghost-layer QUALITY
+-- verdict, not the legal gate). Touches all_designs + spoon_all_designs.
+BEGIN;
+UPDATE all_designs SET
+    is_published = FALSE,
+    web_viewer   = FALSE,
+    tags = array_remove(COALESCE(tags,ARRAY[]::text[]),'curator-force-publish'),
+    notes = COALESCE(notes,'') || ' | UNPUBLISHED settlement-legal-block 2026-05-30'
+WHERE is_published = TRUE
+  AND (settlement_verdict='BLOCK' OR settlement_verdict LIKE 'REVIEW-VISION-ERROR%');
+
+UPDATE spoon_all_designs s SET
+    is_published = FALSE,
+    tags = array_remove(COALESCE(s.tags,ARRAY[]::text[]),'curator-force-publish')
+FROM all_designs a
+WHERE s.id = a.id
+  AND (a.settlement_verdict='BLOCK' OR a.settlement_verdict LIKE 'REVIEW-VISION-ERROR%');
+COMMIT;

← f1fb003 publish first-5 settlement-clean drunk-animals (Steve 2026-0 · back to Wallco Ai · publish drunk-animals 5/28-5/30 (+54 via curator force, sett 94df68b →