--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: items; Type: TABLE; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE TABLE items (
    itemid bigint NOT NULL,
    type integer DEFAULT 0 NOT NULL,
    snmp_community character varying(64) DEFAULT ''::character varying NOT NULL,
    snmp_oid character varying(512) DEFAULT ''::character varying NOT NULL,
    hostid bigint NOT NULL,
    name character varying(255) DEFAULT ''::character varying NOT NULL,
    key_ character varying(255) DEFAULT ''::character varying NOT NULL,
    delay character varying(1024) DEFAULT '0'::character varying NOT NULL,
    history character varying(255) DEFAULT '90d'::character varying NOT NULL,
    trends character varying(255) DEFAULT '365d'::character varying NOT NULL,
    status integer DEFAULT 0 NOT NULL,
    value_type integer DEFAULT 0 NOT NULL,
    trapper_hosts character varying(255) DEFAULT ''::character varying NOT NULL,
    units character varying(255) DEFAULT ''::character varying NOT NULL,
    snmpv3_securityname character varying(64) DEFAULT ''::character varying NOT NULL,
    snmpv3_securitylevel integer DEFAULT 0 NOT NULL,
    snmpv3_authpassphrase character varying(64) DEFAULT ''::character varying NOT NULL,
    snmpv3_privpassphrase character varying(64) DEFAULT ''::character varying NOT NULL,
    formula character varying(255) DEFAULT ''::character varying NOT NULL,
    error character varying(2048) DEFAULT ''::character varying NOT NULL,
    lastlogsize numeric(20,0) DEFAULT 0::numeric NOT NULL,
    logtimefmt character varying(64) DEFAULT ''::character varying NOT NULL,
    templateid bigint,
    valuemapid bigint,
    params text DEFAULT ''::text NOT NULL,
    ipmi_sensor character varying(128) DEFAULT ''::character varying NOT NULL,
    authtype integer DEFAULT 0 NOT NULL,
    username character varying(64) DEFAULT ''::character varying NOT NULL,
    password character varying(64) DEFAULT ''::character varying NOT NULL,
    publickey character varying(64) DEFAULT ''::character varying NOT NULL,
    privatekey character varying(64) DEFAULT ''::character varying NOT NULL,
    mtime integer DEFAULT 0 NOT NULL,
    flags integer DEFAULT 0 NOT NULL,
    interfaceid bigint,
    port character varying(64) DEFAULT ''::character varying NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    inventory_link integer DEFAULT 0 NOT NULL,
    lifetime character varying(255) DEFAULT '30d'::character varying NOT NULL,
    snmpv3_authprotocol integer DEFAULT 0 NOT NULL,
    snmpv3_privprotocol integer DEFAULT 0 NOT NULL,
    state integer DEFAULT 0 NOT NULL,
    snmpv3_contextname character varying(255) DEFAULT ''::character varying NOT NULL,
    evaltype integer DEFAULT 0 NOT NULL,
    jmx_endpoint character varying(255) DEFAULT ''::character varying NOT NULL,
    master_itemid bigint,
    timeout character varying(255) DEFAULT '3s'::character varying NOT NULL,
    url character varying(2048) DEFAULT ''::character varying NOT NULL,
    query_fields character varying(2048) DEFAULT ''::character varying NOT NULL,
    posts text DEFAULT ''::text NOT NULL,
    status_codes character varying(255) DEFAULT '200'::character varying NOT NULL,
    follow_redirects integer DEFAULT 1 NOT NULL,
    post_type integer DEFAULT 0 NOT NULL,
    http_proxy character varying(255) DEFAULT ''::character varying NOT NULL,
    headers text DEFAULT ''::text NOT NULL,
    retrieve_mode integer DEFAULT 0 NOT NULL,
    request_method integer DEFAULT 0 NOT NULL,
    output_format integer DEFAULT 0 NOT NULL,
    ssl_cert_file character varying(255) DEFAULT ''::character varying NOT NULL,
    ssl_key_file character varying(255) DEFAULT ''::character varying NOT NULL,
    ssl_key_password character varying(64) DEFAULT ''::character varying NOT NULL,
    verify_peer integer DEFAULT 0 NOT NULL,
    verify_host integer DEFAULT 0 NOT NULL,
    allow_traps integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.items OWNER TO zabbix;

--
-- Name: items_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix; Tablespace: 
--

ALTER TABLE ONLY items
    ADD CONSTRAINT items_pkey PRIMARY KEY (itemid);


--
-- Name: items_1; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE UNIQUE INDEX items_1 ON items USING btree (hostid, key_);


--
-- Name: items_3; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE INDEX items_3 ON items USING btree (status);


--
-- Name: items_4; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE INDEX items_4 ON items USING btree (templateid);


--
-- Name: items_5; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE INDEX items_5 ON items USING btree (valuemapid);


--
-- Name: items_6; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE INDEX items_6 ON items USING btree (interfaceid);


--
-- Name: items_7; Type: INDEX; Schema: public; Owner: zabbix; Tablespace: 
--

CREATE INDEX items_7 ON items USING btree (master_itemid);


--
-- Name: c_items_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix
--

ALTER TABLE ONLY items
    ADD CONSTRAINT c_items_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE;


--
-- Name: c_items_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix
--

ALTER TABLE ONLY items
    ADD CONSTRAINT c_items_2 FOREIGN KEY (templateid) REFERENCES items(itemid) ON DELETE CASCADE;


--
-- Name: c_items_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix
--

ALTER TABLE ONLY items
    ADD CONSTRAINT c_items_3 FOREIGN KEY (valuemapid) REFERENCES valuemaps(valuemapid);


--
-- Name: c_items_4; Type: FK CONSTRAINT; Schema: public; Owner: zabbix
--

ALTER TABLE ONLY items
    ADD CONSTRAINT c_items_4 FOREIGN KEY (interfaceid) REFERENCES interface(interfaceid);


--
-- Name: c_items_5; Type: FK CONSTRAINT; Schema: public; Owner: zabbix
--

ALTER TABLE ONLY items
    ADD CONSTRAINT c_items_5 FOREIGN KEY (master_itemid) REFERENCES items(itemid) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--