-- Add created_at column to profiles table
-- This tracks when the user profile was created
-- The DEFAULT CURRENT_TIMESTAMP will automatically populate this for both existing and new profiles

ALTER TABLE public.profiles
ADD COLUMN created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP;

COMMENT ON COLUMN public.profiles.created_at IS 'Timestamp when the user profile was created';
