-- Run this script AFTER:
--   sonex.products.alter.websync_v2.sql
--
-- IMPORTANT:
-- CREATE INDEX CONCURRENTLY cannot run inside a transaction block.
-- Execute this file as standalone statements.

CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_products_is_trending
    ON sonex.products USING btree
    (is_trending ASC NULLS LAST)
    TABLESPACE pg_default;

CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_products_is_nieuw
    ON sonex.products USING btree
    (is_nieuw ASC NULLS LAST)
    TABLESPACE pg_default;

CREATE INDEX CONCURRENTLY IF NOT EXISTS ix_products_is_acties
    ON sonex.products USING btree
    (is_acties ASC NULLS LAST)
    TABLESPACE pg_default;
