-- =====================================================================
-- NOTICE — this file was split on 2026-04-14.
-- =====================================================================
--
--   The old searchmercials_v2_phase1.sql mixed a destructive baseline
--   (DROP TABLE + CREATE TABLE for every core entity) with additive
--   incremental DDL (ALTER TABLE, new tables). Running the whole file
--   against a populated DB wiped seed data because the DROP block at
--   the top still executed before the file errored out partway through.
--
--   The content is now split into two files:
--
--     searchmercials_v2_phase1-baseline.sql
--         DESTRUCTIVE. Full teardown + recreate of the core schema.
--         For fresh databases only. Do NOT run against a populated DB.
--
--     searchmercials_v2_phase1-incremental.sql
--         Additive-only DDL. Safe to run against a populated DB
--         (CREATE TABLE IF NOT EXISTS; ALTER TABLE is one-shot — see
--         that file's header).
--
--   This stub exists so any tooling or muscle memory that still points
--   at the old filename gets a loud comment-only file instead of a
--   destructive surprise. It contains zero executable SQL by design:
--   piping it into mysql is a no-op.
--
--   Where do the older tables come from?
--     Some tables referenced in the incremental file (sm_pages,
--     sm_rfq_requests, sm_tenant_category_map, sm_listing_plans,
--     sm_listing_plan_subscriptions, sm_listing_social_links) were
--     created via ad-hoc DDL that was never captured here. If you need
--     to reproduce those on a brand-new DB, dump them off a populated
--     environment and fold them into phase1-baseline.sql.
--
-- =====================================================================
