BEGIN;

ALTER TABLE sonex.products
    ADD COLUMN IF NOT EXISTS website_trending boolean,
    ADD COLUMN IF NOT EXISTS website_nieuw boolean,
    ADD COLUMN IF NOT EXISTS website_acties boolean;

CREATE INDEX IF NOT EXISTS ix_products_website_trending
    ON sonex.products USING btree
    (website_trending ASC NULLS LAST)
    TABLESPACE pg_default;

CREATE INDEX IF NOT EXISTS ix_products_website_nieuw
    ON sonex.products USING btree
    (website_nieuw ASC NULLS LAST)
    TABLESPACE pg_default;

CREATE INDEX IF NOT EXISTS ix_products_website_acties
    ON sonex.products USING btree
    (website_acties ASC NULLS LAST)
    TABLESPACE pg_default;

COMMIT;
