-- Table: public.item_preproc -- DROP TABLE public.item_preproc; CREATE TABLE public.item_preproc ( item_preprocid bigint NOT NULL, itemid bigint NOT NULL, step integer NOT NULL DEFAULT 0, type integer NOT NULL DEFAULT 0, params character varying(255) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying ) WITH ( OIDS = FALSE ) TABLESPACE pg_default; ALTER TABLE public.item_preproc OWNER to zabbix; -- Index: item_preproc_1 -- DROP INDEX public.item_preproc_1; CREATE INDEX item_preproc_1 ON public.item_preproc USING btree (itemid, step) TABLESPACE pg_default;