What about if we were to "repurpose" the 'txt' table to store the fulltext plus any metadata such as the scope (object type?) as Torben suggested, the context_id, the object_id, etc.
We would just need a new driver (service contract?) to stuff new data into the txt table and we'd need to rewrite the search pages.
I'm not an expert on drivers and service contracts, but I have used OpenFTS/tsearch since 0.32 so I would be very happy to contribute whatever I can. Perhaps I could rewrite the search pages to be tsearch2 friendly?
