-- Migration 004: Add US stock support
-- Extends asset_type ENUM to include 'stock_us' for NYSE/NASDAQ stocks

ALTER TABLE coins
  MODIFY COLUMN asset_type ENUM('crypto','stock','stock_us')
  NOT NULL DEFAULT 'crypto';