For large CMS websites it's crucial for users to be able to find relevant content using Search page. Unfortunately in current implementation the actual page text (what's inside content blocks) isn't used during search which might result from page relevance indicator drop (in search results) to not even showing needed page.
- add new "l1_PageContent" column to the "PageRevisions" table
- collect text only (remove all HTML markup) from all page content blocks (on content block add/edit/delete) - the "PageContent.l1_Content" column
- put it into newly added "PageRevisions.l1_PageContent" column
- add new setting to "Configuration > Website > Search" page to represent relevance (in search results) for "PageRevisions.l1_PageContent" of currently approved page revision
In above plan all columns that name start with "l1_" are multilingual columns and separate column is created for each language.