=== Running Paper Trading Tables Migration ===

Creating crypto_market_paper_balance table...
✓ Success
Creating crypto_market_paper_positions table...
✓ Success
Creating crypto_market_paper_orders table...
✓ Success

=== Verification ===
crypto_market_paper_balance: ✓ EXISTS
crypto_market_paper_positions: ✓ EXISTS
crypto_market_paper_orders: ✓ EXISTS

=== Table Structures ===

crypto_market_paper_balance:
  - id (int)
  - login (varchar(100))
  - balance_usd (decimal(20,8))
  - margin_used (decimal(20,8))
  - total_pnl (decimal(20,8))
  - total_trades (int)
  - winning_trades (int)
  - losing_trades (int)
  - reset_count (int)
  - last_reset_time (datetime)
  - created_at (datetime)
  - updated_at (datetime)

crypto_market_paper_positions:
  - id (int)
  - login (varchar(100))
  - symbol (varchar(50))
  - inst_id (varchar(50))
  - exchange (varchar(50))
  - side (enum('long','short'))
  - leverage (int)
  - quantity (decimal(30,18))
  - coin_quantity (decimal(30,18))
  - margin_used (decimal(30,18))
  - position_size_usd (decimal(30,18))
  - entry_price (decimal(30,18))
  - entry_time (datetime)
  - entry_signal (varchar(255))
  - mark_price (decimal(30,18))
  - liquidation_price (decimal(30,18))
  - unrealized_pnl (decimal(30,18))
  - realized_pnl (decimal(30,18))
  - exit_time (datetime)
  - exit_price (decimal(30,18))
  - exit_reason (varchar(50))
  - status (enum('open','closed','liquidated'))
  - close_retry_count (int)
  - close_retry_last_error (varchar(255))
  - close_retry_error_type (enum('network','position_not_found','api_error','unknown'))
  - tp_price (decimal(30,18))
  - sl_price (decimal(30,18))
  - highest_price (decimal(30,18))
  - lowest_price (decimal(30,18))
  - created_at (datetime)
  - updated_at (datetime)

crypto_market_paper_orders:
  - id (int)
  - login (varchar(100))
  - position_id (int)
  - order_type (enum('market','limit','entry','tp','sl','liquidation'))
  - symbol (varchar(50))
  - inst_id (varchar(50))
  - side (enum('buy','sell'))
  - quantity (decimal(30,18))
  - price (decimal(30,18))
  - status (enum('pending','filled','cancelled','failed'))
  - created_at (datetime)
  - executed_at (datetime)

=== Migration Complete ===