

-- Note: MariaDB doesn't support functional indexes on JSON columns the same way as PostgreSQL
-- JSON searching is done using JSON_CONTAINS() function which is efficient enough without index

