`db/migrations/020_paper_threads_seed_expansion.sql`

66 lines
-- 020 · Expand /papers seed library (UX backlog #3, tick 5 polish)
--
-- 5 seed threads from migration 018 (Earlham, Bois, Manila Hemp, Ajiro,
-- Vassily) covered the obvious benchmarks. This adds 12 more from the
-- working-installer canon — brands and patterns that get DM'd about
-- weekly. Same pattern: short factual install-quirk intro by ops, leaves
-- room for installer contributions to deepen.
--
-- All ON CONFLICT (slug) DO NOTHING — re-runnable.
-- Reversible: DELETE FROM paper_threads WHERE seeded_by = 'nph_ops' AND
--              created_at >= '2026-05-10'  -- (or just by slug).

BEGIN;

INSERT INTO paper_threads (slug, brand, paper_name, paste_type, category, description, seeded_by) VALUES
  ('de-gournay-st-laurent', 'de Gournay', 'St Laurent', 'wheat', 'chinoiserie',
   'Hand-painted on hand-dyed silk — quieter palette than Earlham, but the cherry-blossom motif demands stricter horizontal alignment between panels. Plan layout with panel-1 dead-centre of the wall; mistakes here read as crooked tree trunks.',
   'nph_ops'),

  ('fromental-non-such', 'Fromental', 'Non Such', 'clay', 'chinoiserie',
   'Hand-painted silk with selective gold-leaf accents. Gold-leaf areas resist paste — applying a thin water-bond first on those zones prevents lift. Soak whole panel 8-10 min before hang; under-soak causes silk creep.',
   'nph_ops'),

  ('phillip-jeffries-shoji', 'Phillip Jeffries', 'Shoji', 'clay', 'grasscloth',
   'Tighter weave than Manila Hemp; less natural variation, so seam-matching is more visible. Reverse-hang every panel (not every other) to balance the directional shimmer. Phillip Jeffries trim guide tape is mandatory — freehand cuts are 60% rejected.',
   'nph_ops'),

  ('elitis-perles', 'Elitis', 'Perles', 'varies', 'specialty',
   'Glass-bead embedded vinyl on paper backing. Roll handling is critical — beads dislodge from edge if dragged. Use a foam roller in the centre, soft brush at seams. Cut with new blade per panel; blunt blades pull beads.',
   'nph_ops'),

  ('schumacher-iconic-leopard', 'Schumacher', 'Iconic Leopard', 'clay', 'specialty',
   'Repeat-pattern with critical match (rosette spots must line up exactly). Drop-match offset is 35.5cm — plan your cuts to minimise waste. Vinyl ground accepts clay paste; do NOT use strippable, it stains the spots.',
   'nph_ops'),

  ('thibaut-tulia', 'Thibaut', 'Tulia', 'strippable', 'floral',
   'Mid-tier paper, generally forgiving — but the floral repeat hides squareness issues. Always plumb-line the first drop, even if the wall looks straight. Strippable paste; vinyl paste yellows the white ground over 18 months.',
   'nph_ops'),

  ('cole-and-son-cow-parsley', 'Cole & Son', 'Cow Parsley', 'wheat', 'floral',
   'Iconic Fornasetti-adjacent silhouette pattern. Non-pasted (paste-the-wall). Watch ceiling registration — the parsley stems read disconnected if the top match isn''t exact. Trim under crown moulding, not above, to hide drift.',
   'nph_ops'),

  ('zoffany-elswick', 'Zoffany', 'Elswick', 'wheat', 'damask',
   'Damask pattern with deep ground. Soak time 5-7 min — silk-effect ground bleeds if over-soaked. Roll with felt roller, not foam; foam compresses the embossed texture.',
   'nph_ops'),

  ('zuber-eldorado', 'Zuber', 'Eldorado', 'wheat', 'mural',
   'Scenic mural panels — sold as a complete 32-panel set. Layout planning is half the install: lay all 32 on the floor first, match all seams dry, photograph the layout. Wheat paste only. Once hung, do not re-position — pulls register apart.',
   'nph_ops'),

  ('arte-katagami', 'Arte', 'Katagami', 'clay', 'specialty',
   'Embossed metallic on textured ground. Embossing crushes if rollered too firmly — pat-dry seams with damp cloth, never roller. Reverse-hang to balance the metallic sheen direction.',
   'nph_ops'),

  ('hermes-faubourg', 'Hermès', 'Faubourg', 'wheat', 'specialty',
   'Limited-edition silk. Treat every panel as one-of-one — Hermès does not reprint damaged panels for at least 18 months. Photograph each panel front + back on arrival; document any factory marks before install starts.',
   'nph_ops'),

  ('flavor-paper-pop-art', 'Flavor Paper', 'Pop Art', 'strippable', 'mural',
   'Digital-print on multiple substrates (silver mylar, peel-and-stick vinyl, traditional paper). The substrate choice changes the install entirely — confirm with the client BEFORE quoting. Mylar versions require zero static — work in cotton gloves.',
   'nph_ops')
ON CONFLICT (slug) DO NOTHING;

COMMIT;