Integrate full text search

[fornit1917]

Create separate table for full text search (images_ft_search) with two columns:

• image_id (correspond to ID in images table, use foreign key ON DELETE CASCADE, ON UPDATE CASCADE)
• column with indexed words vectors data

Create triggers:

• if we insert data into images table - insert row into images_ft_search
• if we update title / keywords / description in images table - update data in images_ft_search table

Also, it will be useful to have stored procedures remove_ft_index and create_ft_index for removing and creating RUM index on images_ft_search data and for enabling/disabling triggers. These procedures can be used in scripts for importing large images set: before importing we disable fulltext search indexing, after importing - we enable it.

In WebApp we need to add API for fulltext search. It will receive following parameters:

• query - query string typed by user
• limit, offset - for paging

And we need return list of images (we already have special class for paging lists, and Olga has task for creating ImagesListItemDto - ask her about it).