BEGIN;

ALTER TABLE sonex.products
    ADD COLUMN IF NOT EXISTS description text COLLATE pg_catalog."default" DEFAULT ''::text,
    ADD COLUMN IF NOT EXISTS material text COLLATE pg_catalog."default" DEFAULT ''::text,
    ADD COLUMN IF NOT EXISTS color text COLLATE pg_catalog."default" DEFAULT ''::text,
    ADD COLUMN IF NOT EXISTS series text COLLATE pg_catalog."default" DEFAULT ''::text,
    ADD COLUMN IF NOT EXISTS minimum_order_quantity integer;

DROP INDEX IF EXISTS sonex.ix_products_specifications_gin;

ALTER TABLE sonex.products
    DROP COLUMN IF EXISTS specifications;

COMMIT;
