5/29 publish: 164 clean drunk-animals live; unpublish 26 settlement-blocked (compliance fix)

91b2a3591a2bab2532e0c5d0d8f52bbca5aab002 · 2026-05-30 19:41:33 -0700 · Steve Abrams

Files touched

A scripts/unpublish-settlement-blocked-0529.sql

Diff

commit 91b2a3591a2bab2532e0c5d0d8f52bbca5aab002
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sat May 30 19:41:33 2026 -0700

    5/29 publish: 164 clean drunk-animals live; unpublish 26 settlement-blocked (compliance fix)
---
 scripts/unpublish-settlement-blocked-0529.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/scripts/unpublish-settlement-blocked-0529.sql b/scripts/unpublish-settlement-blocked-0529.sql
new file mode 100644
index 0000000..39bd418
--- /dev/null
+++ b/scripts/unpublish-settlement-blocked-0529.sql
@@ -0,0 +1,22 @@
+-- COMPLIANCE FIX 2026-05-30: unpublish the 26 settlement-non-OK designs that were
+-- erroneously force-published in the 5/29 batch (publish predicate missed settlement_verdict).
+-- Settlement gate is a HARD legal rule — BLOCK / REVIEW-VISION-ERROR must NOT be live.
+-- Removing blocked content is the compliance-safe direction. 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-blocked 2026-05-30'
+WHERE settlement_verdict IS NOT NULL AND settlement_verdict <> 'OK'
+  AND created_at::date='2026-05-29' AND category='drunk-animals'
+  AND is_published = TRUE;
+
+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 IS NOT NULL AND a.settlement_verdict <> 'OK'
+  AND a.created_at::date='2026-05-29' AND a.category='drunk-animals';
+COMMIT;

← 0ae7644 Fix deploy-kamatera.sh: data/elements exclude matches symlin · back to Wallco Ai · publish first-5 settlement-clean drunk-animals (Steve 2026-0 f1fb003 →