-- Migration: Add ashtakavarga to profiles table
-- Date: 2026-03-30
-- Description: Adds a JSONB column to store sign-based Sarvastakavarga (SAV) points.

ALTER TABLE public.profiles 
ADD COLUMN IF NOT EXISTS ashtakavarga JSONB DEFAULT '{}'::jsonb,
ADD COLUMN IF NOT EXISTS sav_chart_type TEXT DEFAULT 'D1';

COMMENT ON COLUMN public.profiles.ashtakavarga IS 'Stores sign-based SAV scores (e.g., {"ARIES": 27, "TAURUS": 29, ...})';
COMMENT ON COLUMN public.profiles.sav_chart_type IS 'The varga chart reference for the SAV data (defaults to D1)';