`migrations/002_vendor_registry.DRAFT.sql`

14 lines
-- DRAFT / GATED — vendor_registry row for Majilite.  Apply only with Steve's go.
-- Adding a Mac2-only vendor_registry row is expected to show on dw-machine-drift-canary
-- until dw-registry-sync pushes it to Kamatera. Reversible: DELETE FROM vendor_registry WHERE vendor_code='MAJ';
INSERT INTO vendor_registry
  (vendor_name, vendor_code, sku_prefix, sku_range_start, catalog_table, is_active, is_private_label,
   pricing_unit, pricing_model, sample_price, display_prices, do_not_price,
   product_type, website_url, notes, created_at, updated_at)
VALUES
  ('Majilite','MAJ','DWMJ-', 600001, 'majilite_catalog', true, false,
   'yard','sample', 4.25, true, false,
   'Wallcovering','https://www.majilite.com',
   'Nytek faux leather. Metallic Specialties I = 160 SKUs (card I of II; II adds ~160 more = 320 total). DW number block 600000 (DWMJ-600001..600160). Name-keyed (mfr_sku = Pattern Colorway). ONBOARDED AS $4.25 SAMPLES; by-the-yard retail pending Majilite cost list (rep: Kathryn Gabriel / Two Gabriels, kathryn@twogabriels.com). Orders/lead-time: Dara Pinn dpinn@majilite.com. Sold by yard, 54in wide.',
   now(), now());