-- ============================================================
-- Phase 2 addition: ZIP code lookup table
-- Powers the "vehicle location" step of the public quote form —
-- looked up server-side instead of shipping a 2.5MB JSON file to
-- every visitor's browser.
-- Run once via seed-zips.php (reads assets/data/zipcodes.csv).
-- ============================================================

CREATE TABLE IF NOT EXISTS zip_codes (
    zip         VARCHAR(10) PRIMARY KEY,
    city        VARCHAR(100) NOT NULL,
    state_name  VARCHAR(50) NOT NULL
);