-- Migration: Add `size` column to ultra_descriptions
-- Purpose: Store filtered size table based on size_scale to reduce token usage
-- Date: 2026-05-05
-- Database: SQLite

-- 1. Add new column
ALTER TABLE pg__dashboard_canifa__ultra_descriptions ADD COLUMN size TEXT;

-- 2. Note: Use populate_size_column.py to fill this column
-- because SQLite lacks advanced string manipulation functions.

COMMIT;
