Hi Roger,
Regarding openFTS on CR. It will not do it automatically, but one good thing is that you are already half way if you use CR. The db stuff that you need to do for OpenFTS is already done by nature that your object extended content revision.
What you need is just to make the service contracts for "datasource" and "url".
Try this:
https://openacs.org/search/search?q=openfts+datasource
https://openacs.org/doc/search/guidelines.html
If you are using CR you do not need to add triggers anymore.
