254ce2ddc5
- Add optional salary_cap (REAL/float) column to team table - Create migration file for PostgreSQL schema change - Update Peewee model with FloatField(null=True) 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
10 lines
352 B
SQL
10 lines
352 B
SQL
-- Migration: Add salary_cap column to teams table
|
|
-- Date: 2025-12-09
|
|
-- Description: Adds optional salary_cap column to track team salary cap values
|
|
|
|
ALTER TABLE team
|
|
ADD COLUMN IF NOT EXISTS salary_cap REAL;
|
|
|
|
-- Note: REAL is PostgreSQL's single-precision floating-point type
|
|
-- Column is nullable (no NOT NULL constraint) so existing rows get NULL
|