docs: mac2-prod parity audit 2026-05-29 (5/5 files identical; +product_line on prod via /dtd)

70fedce4b4330a36bbf6edb3c9ab4b6d55f4fb23 · 2026-05-29 23:35:17 -0700 · Steve Abrams

Files touched

A docs/mac2-prod-parity-2026-05-29.md

Diff

commit 70fedce4b4330a36bbf6edb3c9ab4b6d55f4fb23
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri May 29 23:35:17 2026 -0700

    docs: mac2-prod parity audit 2026-05-29 (5/5 files identical; +product_line on prod via /dtd)
---
 docs/mac2-prod-parity-2026-05-29.md | 70 +++++++++++++++++++++++++++++++++++++
 1 file changed, 70 insertions(+)

diff --git a/docs/mac2-prod-parity-2026-05-29.md b/docs/mac2-prod-parity-2026-05-29.md
new file mode 100644
index 0000000..81aa96e
--- /dev/null
+++ b/docs/mac2-prod-parity-2026-05-29.md
@@ -0,0 +1,70 @@
+# Mac2 ↔ prod parity audit — wallco-ai — 2026-05-29
+
+Autonomous overnight thread (Steve asleep, /dtd holds override authority).
+
+## File md5 parity — 5 of 5 IDENTICAL
+
+| file | mac2 md5 | prod md5 | verdict |
+|---|---|---|---|
+| server.js | 0af03e0cd39cb9e3755d45128a7934d4 | 0af03e0cd39cb9e3755d45128a7934d4 | MATCH |
+| src/colorways.js | a1b4f8f3b12130302f80deb157bf5984 | a1b4f8f3b12130302f80deb157bf5984 | MATCH |
+| public/js/color-dots.js | 8d667b5946b67deea9550ff462db3908 | 8d667b5946b67deea9550ff462db3908 | MATCH |
+| public/admin/elements.html | 6f9b31ff6692a0d32b1785efa6db3935 | 6f9b31ff6692a0d32b1785efa6db3935 | MATCH |
+| public/admin/theme-gallery.html | 611b58b72c421076820418e7d1912907 | 611b58b72c421076820418e7d1912907 | MATCH |
+
+No file drift. No deploy needed.
+
+## PG schema parity — 4 tables compared
+
+### all_designs — Mac2 ahead by 1 column → BACK-PORTED TO PROD TONIGHT
+
+Mac2 had `product_line text` (nullable); prod lacked it.
+server.js references `d.product_line` at line 1991 and `product_line` in 4
+INSERT/SELECT statements (9694, 9850, 10112, 10268). Since server.js is
+byte-identical Mac2→prod, those queries were failing on prod silently.
+
+/dtd verdict: A (execute). Codex=A, Claude=A, Qwen=ABSTAIN (offline).
+
+Executed on prod:
+```sql
+ALTER TABLE all_designs ADD COLUMN IF NOT EXISTS product_line text;
+```
+
+Verified: `product_line | text | nullable=true` now exists on prod.
+
+Reversal (if needed, <1s, zero data loss because no rows have been written
+to this column yet — all NULL):
+```sql
+ALTER TABLE all_designs DROP COLUMN product_line;
+```
+
+Type-width nuance (cosmetic, no action):
+- `tif_max_print_h_in/w_in` are `numeric(8,2)` on Mac2, plain `numeric` on
+  prod. Semantically equivalent for stored values that fit in 8,2.
+
+### spoon_all_designs — drift, NON-URGENT, surfaced to morning digest
+
+- Prod has 2 columns Mac2 lacks: `element_motif_path text`, `element_ref_path text`.
+- Nullability differs on 11 shared columns (prod NOT NULL, Mac2 nullable).
+- `user_stars` is smallint on Mac2, integer on prod.
+
+server.js touches `element_motif_path` / `element_ref_path` on `all_designs`
+only (line 1803, 2548), not on `spoon_all_designs`, so no live path is broken.
+No autonomous write performed. Direction of back-port (prod → Mac2 ADD COLUMN,
+or Mac2-as-canonical) is a judgment call for Steve.
+
+### wallco_user_colorways — IDENTICAL (8 cols)
+
+Owner discrepancy on Mac2 (`stevestudio2` instead of `dw_admin`) caused
+information_schema.columns to return empty for dw_admin; pg_attribute query
+bypassed that and confirmed match.
+
+### wallco_trade_users — IDENTICAL (9 cols)
+
+## Summary
+
+- 5 of 5 files byte-identical
+- 1 prod-PG additive write completed under /dtd authority (reversible)
+- 1 schema delta surfaced for Steve (spoon_all_designs cosmetic + 2 missing cols)
+- 2 tables fully identical
+- Total autonomous prod writes: 1 (ADD COLUMN, nullable, no row writes)

← df69588 /api/rooms: for non-admin, dedup by room_type + drop rooms w · back to Wallco Ai · fleet audit 2026-05-30 — toggle + sort/density backlog (DTD 19b104a →