-- Add beacon opt-in preference to profiles table
-- Users must explicitly opt-in to see beacon posts in their feeds

-- Add beacon_enabled column (default FALSE = opted out)
ALTER TABLE profiles ADD COLUMN IF NOT EXISTS beacon_enabled BOOLEAN NOT NULL DEFAULT FALSE;

-- Add index for faster beacon filtering queries
CREATE INDEX IF NOT EXISTS idx_profiles_beacon_enabled ON profiles(beacon_enabled) WHERE beacon_enabled = TRUE;

-- Add comment to explain the column
COMMENT ON COLUMN profiles.beacon_enabled IS 'Whether user has opted into viewing Beacon Network posts in their feeds. Beacons are always visible on the Beacon map regardless of this setting.';