-- Table: public.item_discovery

-- DROP TABLE public.item_discovery;

CREATE TABLE public.item_discovery
(
    itemdiscoveryid bigint NOT NULL,
    itemid bigint NOT NULL,
    parent_itemid bigint NOT NULL,
    key_ character varying(255) COLLATE pg_catalog."default" NOT NULL DEFAULT ''::character varying,
    lastcheck integer NOT NULL DEFAULT 0,
    ts_delete integer NOT NULL DEFAULT 0
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.item_discovery
    OWNER to zabbix;

-- Index: item_discovery_2

-- DROP INDEX public.item_discovery_2;

CREATE INDEX item_discovery_2
    ON public.item_discovery USING btree
    (parent_itemid)
    TABLESPACE pg_default;