← back to Trademarks Copyright

db/brands_v2.sql

16 lines

-- Additive migration: domain status, activity clock, opportunity labels.

ALTER TABLE brand_candidates
  ADD COLUMN IF NOT EXISTS http_status        INT,
  ADD COLUMN IF NOT EXISTS domain_expires_on  DATE,
  ADD COLUMN IF NOT EXISTS domain_lifecycle   TEXT,            -- live | expiring_soon | expired | unknown
  ADD COLUMN IF NOT EXISTS last_activity_year INT,             -- most recent year detected in footer/content
  ADD COLUMN IF NOT EXISTS last_activity_signal TEXT,          -- what Qwen saw ("©2026 BrandCo", "blog post dated ...")
  ADD COLUMN IF NOT EXISTS years_since_activity INT,           -- computed
  ADD COLUMN IF NOT EXISTS abandonment_status TEXT,            -- active | stale | abandoned | unknown
  ADD COLUMN IF NOT EXISTS opportunity_label  TEXT;            -- domain_snipe | abandonment_watch | licensing_outreach | do_not_target | unclear

CREATE INDEX IF NOT EXISTS idx_brands_opportunity ON brand_candidates(opportunity_label);
CREATE INDEX IF NOT EXISTS idx_brands_lifecycle   ON brand_candidates(domain_lifecycle);
CREATE INDEX IF NOT EXISTS idx_brands_abandonment ON brand_candidates(abandonment_status);