• Home
• fr.maif
• izanami
• 2.5.0
• source code
• V2__create_search_indexes.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.tenants.V2__create_search_indexes.sql Maven / Gradle / Ivy

CREATE EXTENSION IF NOT EXISTS pg_trgm with schema izanami;
CREATE EXTENSION IF NOT EXISTS fuzzystrmatch with schema izanami;


CREATE INDEX trgm_idx_feature ON features USING gist (name izanami.gist_trgm_ops, description izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_projects ON projects USING gist (name izanami.gist_trgm_ops, description izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_tags ON tags USING gist (name izanami.gist_trgm_ops, description izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_apikeys ON apikeys USING gist (name izanami.gist_trgm_ops, description izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_webhooks ON webhooks USING gist (name izanami.gist_trgm_ops, description izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_globalcontexts ON global_feature_contexts USING gist (name izanami.gist_trgm_ops);
CREATE INDEX trgm_idx_featurecontexts ON feature_contexts USING gist (name izanami.gist_trgm_ops);