-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET lock_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; -- -- Name: delete_partitions(interval, text); Type: FUNCTION; Schema: public; Owner: zabbix -- CREATE FUNCTION delete_partitions(intervaltodelete interval, tabletype text) RETURNS text LANGUAGE plpgsql AS $_$ DECLARE result RECORD ; prefix text := 'partitions.'; table_timestamp TIMESTAMP; delete_before_date DATE; tablename text; BEGIN FOR result IN SELECT * FROM pg_tables WHERE schemaname = 'partitions' LOOP table_timestamp := TO_TIMESTAMP(substring(result.tablename FROM '[0-9_]*$'), 'YYYY_MM_DD'); delete_before_date := date_trunc('day', NOW() - intervalToDelete); tablename := result.tablename; -- Was it called properly? IF tabletype != 'month' AND tabletype != 'day' THEN RAISE EXCEPTION 'Please specify "month" or "day" instead of %', tabletype; END IF; --Check whether the table name has a day (YYYY_MM_DD) or month (YYYY_MM) format IF LENGTH(substring(result.tablename FROM '[0-9_]*$')) = 10 AND tabletype = 'month' THEN --This is a daily partition YYYY_MM_DD -- RAISE NOTICE 'Skipping table % when trying to delete "%" partitions (%)', result.tablename, tabletype, length(substring(result.tablename from '[0-9_]*$')); CONTINUE; ELSIF LENGTH(substring(result.tablename FROM '[0-9_]*$')) = 7 AND tabletype = 'day' THEN --this is a monthly partition --RAISE NOTICE 'Skipping table % when trying to delete "%" partitions (%)', result.tablename, tabletype, length(substring(result.tablename from '[0-9_]*$')); CONTINUE; ELSE --This is the correct table type. Go ahead and check if it needs to be deleted --RAISE NOTICE 'Checking table %', result.tablename; END IF; IF table_timestamp <= delete_before_date THEN RAISE NOTICE 'Deleting table %', quote_ident(tablename); EXECUTE 'DROP TABLE ' || prefix || quote_ident(tablename) || ';'; END IF; END LOOP; RETURN 'OK'; END; $_$; ALTER FUNCTION public.delete_partitions(intervaltodelete interval, tabletype text) OWNER TO zabbix; -- -- Name: group_sorter(character varying, integer); Type: FUNCTION; Schema: public; Owner: pgsql -- CREATE FUNCTION group_sorter(match_string character varying, groupid_param integer) RETURNS character varying LANGUAGE plpgsql AS $$ BEGIN insert into hosts_groups (hostid,groupid) select hostid, groupid_param from hosts where name like match_string and NOT EXISTS ( SELECT groupid FROM hosts_groups WHERE groupid=groupid_param and hosts_groups.hostid=hosts.hostid ); return 'Hosts added to group'; END; $$; ALTER FUNCTION public.group_sorter(match_string character varying, groupid_param integer) OWNER TO pgsql; -- -- Name: load_screens_all(); Type: FUNCTION; Schema: public; Owner: pgsql -- CREATE FUNCTION load_screens_all() RETURNS character varying LANGUAGE plpgsql AS $$BEGIN ALTER SEQUENCE "public"."load_screens_id_seq" RESTART 10000; ALTER SEQUENCE "public"."load_screens_items_id_seq" RESTART 100000; DELETE FROM screens_items WHERE screenitemid >= 100000; DELETE FROM screens WHERE screenid >= 10000; perform * from load_screens_ltc('ЛТЦ'); perform * from load_screens_ltc('Cisco Internet Улусные центры'); perform * from load_screens_ltc('Cisco VSAT улусные центры'); perform * from load_screens_ltc('Cisco VSAT наслеги'); perform * from load_screens_ltc('Cisco SARDA'); perform * from load_screens_mcc_pkts(); RETURN 'OK'; END $$; ALTER FUNCTION public.load_screens_all() OWNER TO pgsql; -- -- Name: load_screens_ltc(character varying); Type: FUNCTION; Schema: public; Owner: pgsql -- CREATE FUNCTION load_screens_ltc(_text_like character varying) RETURNS character varying LANGUAGE plpgsql AS $$/* ЛТЦ Cisco Internet Улусные центры Cisco VSAT улусные центры Cisco VSAT наслеги Cisco SARDA */ declare curs CURSOR FOR select groupid, "name" from groups where "name" like '%' || _text_like || '%'; _name_ltc VARCHAR(50); _groupid_ltc INT; _s_id INT; _si_id INT; _x INT; _y INT; _count INT; _x_ INT; _y_ INT; rec record; BEGIN /*ALTER SEQUENCE "public"."load_screens_id_seq" RESTART 10000; ALTER SEQUENCE "public"."load_screens_items_id_seq" RESTART 100000; DELETE FROM screens_items WHERE screenitemid >= 100000; DELETE FROM screens WHERE screenid >= 10000;*/ open curs; LOOP FETCH curs INTO _groupid_ltc, _name_ltc; EXIT WHEN NOT FOUND; select count(*) into _count from ( select gr.graphid, gr."name" from graphs gr inner join graphs_items grit on grit.graphid=gr.graphid inner join items it on it.itemid=grit.itemid inner join hosts h on h.hostid=it.hostid inner join hosts_groups hg on hg.hostid=h.hostid inner join groups grp on grp.groupid=hg.groupid where grp.groupid =_groupid_ltc and gr.flags <>2 and gr."name" like '%Pkts%' and (gr."name" like '%VSAT%' or gr."name" like '%Internet%' or gr."name" like '%RRL%') and gr."name" not like '%telnet%' group by gr.graphid, gr."name" order by gr.graphid ) a; _x := 2; if (_count IS NULL) then _count := 0; _x := 0; end if; if (_count = 0) then _x := 0; end if; _y := FLOOR(_count/2); if (MOD(_count, 2) > 0) then _y := _y + 1; end if; INSERT into screens ("screenid","name","hsize","vsize") SELECT nextval('load_screens_id_seq'::regclass), chr(1)||'>'||_name_ltc, _x, _y returning screenid into _s_id; _x_ := 0; _y_ := 0; FOR rec IN select gr.graphid from graphs gr inner join graphs_items grit on grit.graphid=gr.graphid inner join items it on it.itemid=grit.itemid inner join hosts h on h.hostid=it.hostid inner join hosts_groups hg on hg.hostid=h.hostid inner join groups grp on grp.groupid=hg.groupid where grp.groupid =_groupid_ltc and gr.flags <>2 and gr."name" like '%Pkts%' and (gr."name" like '%VSAT TERMINAL%' or gr."name" like '%Internet%' or gr."name" like '%RRL%') and gr."name" not like '%telnet%' group by gr.graphid, gr."name" order by gr.graphid LOOP INSERT into screens_items ("screenitemid","screenid","resourcetype","resourceid","width","height","x","y","colspan","rowspan","elements","valign","halign","style","url","dynamic","sort_triggers","application") select nextval('load_screens_items_id_seq'::regclass),_s_id,0,rec.graphid,500,100,_x_,_y_,1,1,0,0,0,0,'',0,0,''; if (_x_ = 1) then _x_ := 0; _y_ := _y_ + 1; else _x_ := _x_ + 1; end if; END LOOP; END LOOP; CLOSE curs; RETURN _s_id; END $$; ALTER FUNCTION public.load_screens_ltc(_text_like character varying) OWNER TO pgsql; -- -- Name: load_screens_mcc_pkts(); Type: FUNCTION; Schema: public; Owner: pgsql -- CREATE FUNCTION load_screens_mcc_pkts() RETURNS character varying LANGUAGE plpgsql AS $$/* Оборудование - MCC */ declare curs CURSOR FOR select h.hostid, h."name" from graphs gr inner join graphs_items grit on grit.graphid=gr.graphid inner join items it on it.itemid=grit.itemid inner join hosts h on h.hostid=it.hostid inner join hosts_groups hg on hg.hostid=h.hostid inner join groups grp on grp.groupid=hg.groupid where grp."name" like '%Оборудование - MCC%' and gr.flags <>2 and gr."name" like '%Pkts%' group by h.hostid, h."name" order by h.hostid; _name_ltc VARCHAR(50); _hostid_ltc INT; _s_id INT; _si_id INT; _x INT; _y INT; _count INT; _x_ INT; _y_ INT; rec record; BEGIN /*ALTER SEQUENCE "public"."load_screens_id_seq" RESTART 10000; ALTER SEQUENCE "public"."load_screens_items_id_seq" RESTART 100000; DELETE FROM screens_items WHERE screenitemid >= 100000; DELETE FROM screens WHERE screenid >= 10000;*/ open curs; LOOP FETCH curs INTO _hostid_ltc, _name_ltc; EXIT WHEN NOT FOUND; select count(*) into _count from ( select gr.graphid, gr."name" from graphs gr inner join graphs_items grit on grit.graphid=gr.graphid inner join items it on it.itemid=grit.itemid inner join hosts h on h.hostid=it.hostid inner join hosts_groups hg on hg.hostid=h.hostid inner join groups grp on grp.groupid=hg.groupid where h.hostid =_hostid_ltc and gr.flags <>2 and gr."name" like '%Pkts%' group by gr.graphid, gr."name" order by gr.graphid ) a; _x := 2; if (_count IS NULL) then _count := 0; _x := 0; end if; if (_count = 0) then _x := 0; end if; _y := FLOOR(_count/2); if (MOD(_count, 2) > 0) then _y := _y + 1; end if; INSERT into screens ("screenid","name","hsize","vsize") SELECT nextval('load_screens_id_seq'::regclass), chr(1)||'>'||_name_ltc||' - Pkts', _x, _y returning screenid into _s_id; _x_ := 0; _y_ := 0; FOR rec IN select gr.graphid, gr."name" from graphs gr inner join graphs_items grit on grit.graphid=gr.graphid inner join items it on it.itemid=grit.itemid inner join hosts h on h.hostid=it.hostid inner join hosts_groups hg on hg.hostid=h.hostid inner join groups grp on grp.groupid=hg.groupid where h.hostid =_hostid_ltc and gr.flags <>2 and gr."name" like '%Pkts%' group by gr.graphid, gr."name" order by gr.graphid LOOP INSERT into screens_items ("screenitemid","screenid","resourcetype","resourceid","width","height","x","y","colspan","rowspan","elements","valign","halign","style","url","dynamic","sort_triggers","application") select nextval('load_screens_items_id_seq'::regclass),_s_id,0,rec.graphid,500,100,_x_,_y_,1,1,0,0,0,0,'',0,0,''; if (_x_ = 1) then _x_ := 0; _y_ := _y_ + 1; else _x_ := _x_ + 1; end if; END LOOP; END LOOP; CLOSE curs; RETURN _s_id; END $$; ALTER FUNCTION public.load_screens_mcc_pkts() OWNER TO pgsql; -- -- Name: trg_partition(); Type: FUNCTION; Schema: public; Owner: zabbix -- CREATE FUNCTION trg_partition() RETURNS trigger LANGUAGE plpgsql AS $_$ DECLARE prefix text := 'partitions.'; timeformat text; selector text; _interval INTERVAL; tablename text; startdate text; enddate text; create_table_part text; create_index_part text; BEGIN selector = TG_ARGV[0]; IF selector = 'day' THEN timeformat := 'YYYY_MM_DD'; ELSIF selector = 'month' THEN timeformat := 'YYYY_MM'; END IF; _interval := '1 ' || selector; tablename := TG_TABLE_NAME || '_p' || TO_CHAR(TO_TIMESTAMP(NEW.clock), timeformat); EXECUTE 'INSERT INTO ' || prefix || quote_ident(tablename) || ' SELECT ($1).*' USING NEW; RETURN NULL; EXCEPTION WHEN undefined_table THEN startdate := EXTRACT(epoch FROM date_trunc(selector, TO_TIMESTAMP(NEW.clock))); enddate := EXTRACT(epoch FROM date_trunc(selector, TO_TIMESTAMP(NEW.clock) + _interval )); create_table_part:= 'CREATE TABLE IF NOT EXISTS '|| prefix || quote_ident(tablename) || ' (CHECK ((clock >= ' || quote_literal(startdate) || ' AND clock < ' || quote_literal(enddate) || '))) INHERITS ('|| TG_TABLE_NAME || ')'; create_index_part:= 'CREATE INDEX '|| quote_ident(tablename) || '_1 on ' || prefix || quote_ident(tablename) || '(itemid,clock)'; EXECUTE create_table_part; EXECUTE create_index_part; --insert it again EXECUTE 'INSERT INTO ' || prefix || quote_ident(tablename) || ' SELECT ($1).*' USING NEW; RETURN NULL; END; $_$; ALTER FUNCTION public.trg_partition() OWNER TO zabbix; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: hosts; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hosts ( hostid bigint NOT NULL, proxy_hostid bigint, host character varying(64) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, disable_until integer DEFAULT 0 NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, available integer DEFAULT 0 NOT NULL, errors_from integer DEFAULT 0 NOT NULL, lastaccess integer DEFAULT 0 NOT NULL, ipmi_authtype integer DEFAULT 0 NOT NULL, ipmi_privilege integer DEFAULT 2 NOT NULL, ipmi_username character varying(16) DEFAULT ''::character varying NOT NULL, ipmi_password character varying(20) DEFAULT ''::character varying NOT NULL, ipmi_disable_until integer DEFAULT 0 NOT NULL, ipmi_available integer DEFAULT 0 NOT NULL, snmp_disable_until integer DEFAULT 0 NOT NULL, snmp_available integer DEFAULT 0 NOT NULL, maintenanceid bigint, maintenance_status integer DEFAULT 0 NOT NULL, maintenance_type integer DEFAULT 0 NOT NULL, maintenance_from integer DEFAULT 0 NOT NULL, ipmi_errors_from integer DEFAULT 0 NOT NULL, snmp_errors_from integer DEFAULT 0 NOT NULL, ipmi_error character varying(128) DEFAULT ''::character varying NOT NULL, snmp_error character varying(128) DEFAULT ''::character varying NOT NULL, jmx_disable_until integer DEFAULT 0 NOT NULL, jmx_available integer DEFAULT 0 NOT NULL, jmx_errors_from integer DEFAULT 0 NOT NULL, jmx_error character varying(128) DEFAULT ''::character varying NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, flags integer DEFAULT 0 NOT NULL, templateid bigint ); ALTER TABLE public.hosts OWNER TO zabbix2; -- -- Name: hosts_templates; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hosts_templates ( hosttemplateid bigint NOT NULL, hostid bigint NOT NULL, templateid bigint NOT NULL ); ALTER TABLE public.hosts_templates OWNER TO zabbix2; -- -- Name: host_macro_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE host_macro_id_seq START WITH 213 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.host_macro_id_seq OWNER TO pgsql; -- -- Name: hostmacro; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hostmacro ( hostmacroid bigint DEFAULT nextval('host_macro_id_seq'::regclass) NOT NULL, hostid bigint NOT NULL, macro character varying(64) DEFAULT ''::character varying NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.hostmacro OWNER TO zabbix2; -- -- Name: groups; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE groups ( groupid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, internal integer DEFAULT 0 NOT NULL, flags integer DEFAULT 0 NOT NULL ); ALTER TABLE public.groups OWNER TO zabbix2; -- -- Name: host_group_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix -- CREATE SEQUENCE host_group_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.host_group_id_seq OWNER TO zabbix; -- -- Name: hosts_groups; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hosts_groups ( hostgroupid bigint DEFAULT nextval('host_group_id_seq'::regclass) NOT NULL, hostid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.hosts_groups OWNER TO zabbix2; -- -- Name: rights; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE rights ( rightid bigint NOT NULL, groupid bigint NOT NULL, permission integer DEFAULT 0 NOT NULL, id bigint NOT NULL ); ALTER TABLE public.rights OWNER TO zabbix2; -- -- Name: users; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE users ( userid bigint NOT NULL, alias character varying(100) DEFAULT ''::character varying NOT NULL, name character varying(100) DEFAULT ''::character varying NOT NULL, surname character varying(100) DEFAULT ''::character varying NOT NULL, passwd character(32) DEFAULT ''::bpchar NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL, autologin integer DEFAULT 0 NOT NULL, autologout integer DEFAULT 900 NOT NULL, lang character varying(5) DEFAULT 'en_GB'::character varying NOT NULL, refresh integer DEFAULT 30 NOT NULL, type integer DEFAULT 1 NOT NULL, theme character varying(128) DEFAULT 'default'::character varying NOT NULL, attempt_failed integer DEFAULT 0 NOT NULL, attempt_ip character varying(39) DEFAULT ''::character varying NOT NULL, attempt_clock integer DEFAULT 0 NOT NULL, rows_per_page integer DEFAULT 50 NOT NULL ); ALTER TABLE public.users OWNER TO zabbix2; -- -- Name: users_groups; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE users_groups ( id bigint NOT NULL, usrgrpid bigint NOT NULL, userid bigint NOT NULL ); ALTER TABLE public.users_groups OWNER TO zabbix2; -- -- Name: items; Type: TABLE; Schema: public; Owner: zabbix2; 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(255) 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 integer DEFAULT 0 NOT NULL, history integer DEFAULT 90 NOT NULL, trends integer DEFAULT 365 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, multiplier integer DEFAULT 0 NOT NULL, delta integer DEFAULT 0 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 '1'::character varying NOT NULL, error character varying(128) 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, delay_flex character varying(255) DEFAULT ''::character varying NOT NULL, params text DEFAULT ''::text NOT NULL, ipmi_sensor character varying(128) DEFAULT ''::character varying NOT NULL, data_type integer DEFAULT 0 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, filter character varying(255) DEFAULT ''::character varying 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(64) DEFAULT '30'::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 ); ALTER TABLE public.items OWNER TO zabbix2; -- -- Name: history_log; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_log ( id bigint NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, "timestamp" integer DEFAULT 0 NOT NULL, source character varying(64) DEFAULT ''::character varying NOT NULL, severity integer DEFAULT 0 NOT NULL, value text DEFAULT ''::text NOT NULL, logeventid integer DEFAULT 0 NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_log OWNER TO zabbix2; -- -- Name: history; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history ( itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value numeric(16,4) DEFAULT 0.0000 NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history OWNER TO zabbix2; -- -- Name: history_uint; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_uint ( itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value numeric(20,0) DEFAULT (0)::numeric NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_uint OWNER TO zabbix2; -- -- Name: trends; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE trends ( itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, num integer DEFAULT 0 NOT NULL, value_min numeric(16,4) DEFAULT 0.0000 NOT NULL, value_avg numeric(16,4) DEFAULT 0.0000 NOT NULL, value_max numeric(16,4) DEFAULT 0.0000 NOT NULL ); ALTER TABLE public.trends OWNER TO zabbix2; -- -- Name: trends_uint; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE trends_uint ( itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, num integer DEFAULT 0 NOT NULL, value_min numeric(20,0) DEFAULT (0)::numeric NOT NULL, value_avg numeric(20,0) DEFAULT (0)::numeric NOT NULL, value_max numeric(20,0) DEFAULT (0)::numeric NOT NULL ); ALTER TABLE public.trends_uint OWNER TO zabbix2; -- -- Name: _count; Type: TABLE; Schema: public; Owner: pgsql; Tablespace: -- CREATE TABLE _count ( count bigint ); ALTER TABLE public._count OWNER TO pgsql; -- -- Name: acknowledges; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE acknowledges ( acknowledgeid bigint NOT NULL, userid bigint NOT NULL, eventid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, message character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.acknowledges OWNER TO zabbix2; -- -- Name: actions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE actions ( actionid bigint NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, eventsource integer DEFAULT 0 NOT NULL, evaltype integer DEFAULT 0 NOT NULL, status integer DEFAULT 0 NOT NULL, esc_period integer DEFAULT 0 NOT NULL, def_shortdata character varying(255) DEFAULT ''::character varying NOT NULL, def_longdata text DEFAULT ''::text NOT NULL, recovery_msg integer DEFAULT 0 NOT NULL, r_shortdata character varying(255) DEFAULT ''::character varying NOT NULL, r_longdata text DEFAULT ''::text NOT NULL ); ALTER TABLE public.actions OWNER TO zabbix2; -- -- Name: alerts; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE alerts ( alertid bigint NOT NULL, actionid bigint NOT NULL, eventid bigint NOT NULL, userid bigint, clock integer DEFAULT 0 NOT NULL, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying NOT NULL, subject character varying(255) DEFAULT ''::character varying NOT NULL, message text DEFAULT ''::text NOT NULL, status integer DEFAULT 0 NOT NULL, retries integer DEFAULT 0 NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, esc_step integer DEFAULT 0 NOT NULL, alerttype integer DEFAULT 0 NOT NULL ); ALTER TABLE public.alerts OWNER TO zabbix2; -- -- Name: application_template; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE application_template ( application_templateid bigint NOT NULL, applicationid bigint NOT NULL, templateid bigint NOT NULL ); ALTER TABLE public.application_template OWNER TO zabbix2; -- -- Name: applications; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE applications ( applicationid bigint NOT NULL, hostid bigint NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.applications OWNER TO zabbix2; -- -- Name: auditlog; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE auditlog ( auditid bigint NOT NULL, userid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, action integer DEFAULT 0 NOT NULL, resourcetype integer DEFAULT 0 NOT NULL, details character varying(128) DEFAULT '0'::character varying NOT NULL, ip character varying(39) DEFAULT ''::character varying NOT NULL, resourceid bigint DEFAULT 0::bigint NOT NULL, resourcename character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.auditlog OWNER TO zabbix2; -- -- Name: auditlog_details; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE auditlog_details ( auditdetailid bigint NOT NULL, auditid bigint NOT NULL, table_name character varying(64) DEFAULT ''::character varying NOT NULL, field_name character varying(64) DEFAULT ''::character varying NOT NULL, oldvalue text DEFAULT ''::text NOT NULL, newvalue text DEFAULT ''::text NOT NULL ); ALTER TABLE public.auditlog_details OWNER TO zabbix2; -- -- Name: autoreg_host; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE autoreg_host ( autoreg_hostid bigint NOT NULL, proxy_hostid bigint, host character varying(64) DEFAULT ''::character varying NOT NULL, listen_ip character varying(39) DEFAULT ''::character varying NOT NULL, listen_port integer DEFAULT 0 NOT NULL, listen_dns character varying(64) DEFAULT ''::character varying NOT NULL, host_metadata character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.autoreg_host OWNER TO zabbix2; -- -- Name: conditions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE conditions ( conditionid bigint NOT NULL, actionid bigint NOT NULL, conditiontype integer DEFAULT 0 NOT NULL, operator integer DEFAULT 0 NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.conditions OWNER TO zabbix2; -- -- Name: config; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE config ( configid bigint NOT NULL, refresh_unsupported integer DEFAULT 0 NOT NULL, work_period character varying(100) DEFAULT '1-5,00:00-24:00'::character varying NOT NULL, alert_usrgrpid bigint, event_ack_enable integer DEFAULT 1 NOT NULL, event_expire integer DEFAULT 7 NOT NULL, event_show_max integer DEFAULT 100 NOT NULL, default_theme character varying(128) DEFAULT 'originalblue'::character varying NOT NULL, authentication_type integer DEFAULT 0 NOT NULL, ldap_host character varying(255) DEFAULT ''::character varying NOT NULL, ldap_port integer DEFAULT 389 NOT NULL, ldap_base_dn character varying(255) DEFAULT ''::character varying NOT NULL, ldap_bind_dn character varying(255) DEFAULT ''::character varying NOT NULL, ldap_bind_password character varying(128) DEFAULT ''::character varying NOT NULL, ldap_search_attribute character varying(128) DEFAULT ''::character varying NOT NULL, dropdown_first_entry integer DEFAULT 1 NOT NULL, dropdown_first_remember integer DEFAULT 1 NOT NULL, discovery_groupid bigint NOT NULL, max_in_table integer DEFAULT 50 NOT NULL, search_limit integer DEFAULT 1000 NOT NULL, severity_color_0 character varying(6) DEFAULT 'DBDBDB'::character varying NOT NULL, severity_color_1 character varying(6) DEFAULT 'D6F6FF'::character varying NOT NULL, severity_color_2 character varying(6) DEFAULT 'FFF6A5'::character varying NOT NULL, severity_color_3 character varying(6) DEFAULT 'FFB689'::character varying NOT NULL, severity_color_4 character varying(6) DEFAULT 'FF9999'::character varying NOT NULL, severity_color_5 character varying(6) DEFAULT 'FF3838'::character varying NOT NULL, severity_name_0 character varying(32) DEFAULT 'Not classified'::character varying NOT NULL, severity_name_1 character varying(32) DEFAULT 'Information'::character varying NOT NULL, severity_name_2 character varying(32) DEFAULT 'Warning'::character varying NOT NULL, severity_name_3 character varying(32) DEFAULT 'Average'::character varying NOT NULL, severity_name_4 character varying(32) DEFAULT 'High'::character varying NOT NULL, severity_name_5 character varying(32) DEFAULT 'Disaster'::character varying NOT NULL, ok_period integer DEFAULT 1800 NOT NULL, blink_period integer DEFAULT 1800 NOT NULL, problem_unack_color character varying(6) DEFAULT 'DC0000'::character varying NOT NULL, problem_ack_color character varying(6) DEFAULT 'DC0000'::character varying NOT NULL, ok_unack_color character varying(6) DEFAULT '00AA00'::character varying NOT NULL, ok_ack_color character varying(6) DEFAULT '00AA00'::character varying NOT NULL, problem_unack_style integer DEFAULT 1 NOT NULL, problem_ack_style integer DEFAULT 1 NOT NULL, ok_unack_style integer DEFAULT 1 NOT NULL, ok_ack_style integer DEFAULT 1 NOT NULL, snmptrap_logging integer DEFAULT 1 NOT NULL, server_check_interval integer DEFAULT 10 NOT NULL, hk_events_mode integer DEFAULT 1 NOT NULL, hk_events_trigger integer DEFAULT 365 NOT NULL, hk_events_internal integer DEFAULT 365 NOT NULL, hk_events_discovery integer DEFAULT 365 NOT NULL, hk_events_autoreg integer DEFAULT 365 NOT NULL, hk_services_mode integer DEFAULT 1 NOT NULL, hk_services integer DEFAULT 365 NOT NULL, hk_audit_mode integer DEFAULT 1 NOT NULL, hk_audit integer DEFAULT 365 NOT NULL, hk_sessions_mode integer DEFAULT 1 NOT NULL, hk_sessions integer DEFAULT 365 NOT NULL, hk_history_mode integer DEFAULT 1 NOT NULL, hk_history_global integer DEFAULT 0 NOT NULL, hk_history integer DEFAULT 90 NOT NULL, hk_trends_mode integer DEFAULT 1 NOT NULL, hk_trends_global integer DEFAULT 0 NOT NULL, hk_trends integer DEFAULT 365 NOT NULL ); ALTER TABLE public.config OWNER TO zabbix2; -- -- Name: dbversion; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE dbversion ( mandatory integer DEFAULT 0 NOT NULL, optional integer DEFAULT 0 NOT NULL ); ALTER TABLE public.dbversion OWNER TO zabbix2; -- -- Name: dchecks; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE dchecks ( dcheckid bigint NOT NULL, druleid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, key_ character varying(255) DEFAULT ''::character varying NOT NULL, snmp_community character varying(255) DEFAULT ''::character varying NOT NULL, ports character varying(255) DEFAULT '0'::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, uniq integer DEFAULT 0 NOT NULL, snmpv3_authprotocol integer DEFAULT 0 NOT NULL, snmpv3_privprotocol integer DEFAULT 0 NOT NULL, snmpv3_contextname character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.dchecks OWNER TO zabbix2; -- -- Name: dhosts; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE dhosts ( dhostid bigint NOT NULL, druleid bigint NOT NULL, status integer DEFAULT 0 NOT NULL, lastup integer DEFAULT 0 NOT NULL, lastdown integer DEFAULT 0 NOT NULL ); ALTER TABLE public.dhosts OWNER TO zabbix2; -- -- Name: drules; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE drules ( druleid bigint NOT NULL, proxy_hostid bigint, name character varying(255) DEFAULT ''::character varying NOT NULL, iprange character varying(255) DEFAULT ''::character varying NOT NULL, delay integer DEFAULT 3600 NOT NULL, nextcheck integer DEFAULT 0 NOT NULL, status integer DEFAULT 0 NOT NULL ); ALTER TABLE public.drules OWNER TO zabbix2; -- -- Name: dservices; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE dservices ( dserviceid bigint NOT NULL, dhostid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, key_ character varying(255) DEFAULT ''::character varying NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL, port integer DEFAULT 0 NOT NULL, status integer DEFAULT 0 NOT NULL, lastup integer DEFAULT 0 NOT NULL, lastdown integer DEFAULT 0 NOT NULL, dcheckid bigint NOT NULL, ip character varying(39) DEFAULT ''::character varying NOT NULL, dns character varying(64) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.dservices OWNER TO zabbix2; -- -- Name: escalations; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE escalations ( escalationid bigint NOT NULL, actionid bigint NOT NULL, triggerid bigint, eventid bigint, r_eventid bigint, nextcheck integer DEFAULT 0 NOT NULL, esc_step integer DEFAULT 0 NOT NULL, status integer DEFAULT 0 NOT NULL, itemid bigint ); ALTER TABLE public.escalations OWNER TO zabbix2; -- -- Name: events; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE events ( eventid bigint NOT NULL, source integer DEFAULT 0 NOT NULL, object integer DEFAULT 0 NOT NULL, objectid bigint DEFAULT 0::bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value integer DEFAULT 0 NOT NULL, acknowledged integer DEFAULT 0 NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.events OWNER TO zabbix2; -- -- Name: expressions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE expressions ( expressionid bigint NOT NULL, regexpid bigint NOT NULL, expression character varying(255) DEFAULT ''::character varying NOT NULL, expression_type integer DEFAULT 0 NOT NULL, exp_delimiter character varying(1) DEFAULT ''::character varying NOT NULL, case_sensitive integer DEFAULT 0 NOT NULL ); ALTER TABLE public.expressions OWNER TO zabbix2; -- -- Name: functions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE functions ( functionid bigint NOT NULL, itemid bigint NOT NULL, triggerid bigint NOT NULL, function character varying(12) DEFAULT ''::character varying NOT NULL, parameter character varying(255) DEFAULT '0'::character varying NOT NULL ); ALTER TABLE public.functions OWNER TO zabbix2; -- -- Name: globalmacro; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE globalmacro ( globalmacroid bigint NOT NULL, macro character varying(64) DEFAULT ''::character varying NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.globalmacro OWNER TO zabbix2; -- -- Name: globalvars; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE globalvars ( globalvarid bigint NOT NULL, snmp_lastsize integer DEFAULT 0 NOT NULL ); ALTER TABLE public.globalvars OWNER TO zabbix2; -- -- Name: graph_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE graph_discovery ( graphdiscoveryid bigint NOT NULL, graphid bigint NOT NULL, parent_graphid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.graph_discovery OWNER TO zabbix2; -- -- Name: graph_theme; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE graph_theme ( graphthemeid bigint NOT NULL, description character varying(64) DEFAULT ''::character varying NOT NULL, theme character varying(64) DEFAULT ''::character varying NOT NULL, backgroundcolor character varying(6) DEFAULT 'F0F0F0'::character varying NOT NULL, graphcolor character varying(6) DEFAULT 'FFFFFF'::character varying NOT NULL, graphbordercolor character varying(6) DEFAULT '222222'::character varying NOT NULL, gridcolor character varying(6) DEFAULT 'CCCCCC'::character varying NOT NULL, maingridcolor character varying(6) DEFAULT 'AAAAAA'::character varying NOT NULL, gridbordercolor character varying(6) DEFAULT '000000'::character varying NOT NULL, textcolor character varying(6) DEFAULT '202020'::character varying NOT NULL, highlightcolor character varying(6) DEFAULT 'AA4444'::character varying NOT NULL, leftpercentilecolor character varying(6) DEFAULT '11CC11'::character varying NOT NULL, rightpercentilecolor character varying(6) DEFAULT 'CC1111'::character varying NOT NULL, nonworktimecolor character varying(6) DEFAULT 'CCCCCC'::character varying NOT NULL, gridview integer DEFAULT 1 NOT NULL, legendview integer DEFAULT 1 NOT NULL ); ALTER TABLE public.graph_theme OWNER TO zabbix2; -- -- Name: graphs; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE graphs ( graphid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL, width integer DEFAULT 900 NOT NULL, height integer DEFAULT 200 NOT NULL, yaxismin numeric(16,4) DEFAULT 0::numeric NOT NULL, yaxismax numeric(16,4) DEFAULT 100::numeric NOT NULL, templateid bigint, show_work_period integer DEFAULT 1 NOT NULL, show_triggers integer DEFAULT 1 NOT NULL, graphtype integer DEFAULT 0 NOT NULL, show_legend integer DEFAULT 1 NOT NULL, show_3d integer DEFAULT 0 NOT NULL, percent_left numeric(16,4) DEFAULT 0::numeric NOT NULL, percent_right numeric(16,4) DEFAULT 0::numeric NOT NULL, ymin_type integer DEFAULT 0 NOT NULL, ymax_type integer DEFAULT 0 NOT NULL, ymin_itemid bigint, ymax_itemid bigint, flags integer DEFAULT 0 NOT NULL ); ALTER TABLE public.graphs OWNER TO zabbix2; -- -- Name: graphs_items; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE graphs_items ( gitemid bigint NOT NULL, graphid bigint NOT NULL, itemid bigint NOT NULL, drawtype integer DEFAULT 0 NOT NULL, sortorder integer DEFAULT 0 NOT NULL, color character varying(6) DEFAULT '009600'::character varying NOT NULL, yaxisside integer DEFAULT 0 NOT NULL, calc_fnc integer DEFAULT 2 NOT NULL, type integer DEFAULT 0 NOT NULL ); ALTER TABLE public.graphs_items OWNER TO zabbix2; -- -- Name: group_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE group_discovery ( groupid bigint NOT NULL, parent_group_prototypeid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, lastcheck integer DEFAULT 0 NOT NULL, ts_delete integer DEFAULT 0 NOT NULL ); ALTER TABLE public.group_discovery OWNER TO zabbix2; -- -- Name: group_prototype; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE group_prototype ( group_prototypeid bigint NOT NULL, hostid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, groupid bigint, templateid bigint ); ALTER TABLE public.group_prototype OWNER TO zabbix2; -- -- Name: history_str; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_str ( itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_str OWNER TO zabbix2; -- -- Name: history_str_sync; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_str_sync ( id bigint NOT NULL, nodeid integer NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_str_sync OWNER TO zabbix2; -- -- Name: history_str_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE history_str_sync_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.history_str_sync_id_seq OWNER TO zabbix2; -- -- Name: history_str_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE history_str_sync_id_seq OWNED BY history_str_sync.id; -- -- Name: history_sync; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_sync ( id bigint NOT NULL, nodeid integer NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value numeric(16,4) DEFAULT 0.0000 NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_sync OWNER TO zabbix2; -- -- Name: history_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE history_sync_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.history_sync_id_seq OWNER TO zabbix2; -- -- Name: history_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE history_sync_id_seq OWNED BY history_sync.id; -- -- Name: history_text; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_text ( id bigint NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value text DEFAULT ''::text NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_text OWNER TO zabbix2; -- -- Name: history_uint_sync; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE history_uint_sync ( id bigint NOT NULL, nodeid integer NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value numeric(20,0) DEFAULT 0::numeric NOT NULL, ns integer DEFAULT 0 NOT NULL ); ALTER TABLE public.history_uint_sync OWNER TO zabbix2; -- -- Name: history_uint_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE history_uint_sync_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.history_uint_sync_id_seq OWNER TO zabbix2; -- -- Name: history_uint_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE history_uint_sync_id_seq OWNED BY history_uint_sync.id; -- -- Name: host_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE host_discovery ( hostid bigint NOT NULL, parent_hostid bigint, parent_itemid bigint, host character varying(64) DEFAULT ''::character varying NOT NULL, lastcheck integer DEFAULT 0 NOT NULL, ts_delete integer DEFAULT 0 NOT NULL ); ALTER TABLE public.host_discovery OWNER TO zabbix2; -- -- Name: host_inventory; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE host_inventory ( hostid bigint NOT NULL, inventory_mode integer DEFAULT 0 NOT NULL, type character varying(64) DEFAULT ''::character varying NOT NULL, type_full character varying(64) DEFAULT ''::character varying NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, alias character varying(64) DEFAULT ''::character varying NOT NULL, os character varying(64) DEFAULT ''::character varying NOT NULL, os_full character varying(255) DEFAULT ''::character varying NOT NULL, os_short character varying(64) DEFAULT ''::character varying NOT NULL, serialno_a character varying(64) DEFAULT ''::character varying NOT NULL, serialno_b character varying(64) DEFAULT ''::character varying NOT NULL, tag character varying(64) DEFAULT ''::character varying NOT NULL, asset_tag character varying(64) DEFAULT ''::character varying NOT NULL, macaddress_a character varying(64) DEFAULT ''::character varying NOT NULL, macaddress_b character varying(64) DEFAULT ''::character varying NOT NULL, hardware character varying(255) DEFAULT ''::character varying NOT NULL, hardware_full text DEFAULT ''::text NOT NULL, software character varying(255) DEFAULT ''::character varying NOT NULL, software_full text DEFAULT ''::text NOT NULL, software_app_a character varying(64) DEFAULT ''::character varying NOT NULL, software_app_b character varying(64) DEFAULT ''::character varying NOT NULL, software_app_c character varying(64) DEFAULT ''::character varying NOT NULL, software_app_d character varying(64) DEFAULT ''::character varying NOT NULL, software_app_e character varying(64) DEFAULT ''::character varying NOT NULL, contact text DEFAULT ''::text NOT NULL, location text DEFAULT ''::text NOT NULL, location_lat character varying(16) DEFAULT ''::character varying NOT NULL, location_lon character varying(16) DEFAULT ''::character varying NOT NULL, notes text DEFAULT ''::text NOT NULL, chassis character varying(64) DEFAULT ''::character varying NOT NULL, model character varying(64) DEFAULT ''::character varying NOT NULL, hw_arch character varying(32) DEFAULT ''::character varying NOT NULL, vendor character varying(64) DEFAULT ''::character varying NOT NULL, contract_number character varying(64) DEFAULT ''::character varying NOT NULL, installer_name character varying(64) DEFAULT ''::character varying NOT NULL, deployment_status character varying(64) DEFAULT ''::character varying NOT NULL, url_a character varying(255) DEFAULT ''::character varying NOT NULL, url_b character varying(255) DEFAULT ''::character varying NOT NULL, url_c character varying(255) DEFAULT ''::character varying NOT NULL, host_networks text DEFAULT ''::text NOT NULL, host_netmask character varying(39) DEFAULT ''::character varying NOT NULL, host_router character varying(39) DEFAULT ''::character varying NOT NULL, oob_ip character varying(39) DEFAULT ''::character varying NOT NULL, oob_netmask character varying(39) DEFAULT ''::character varying NOT NULL, oob_router character varying(39) DEFAULT ''::character varying NOT NULL, date_hw_purchase character varying(64) DEFAULT ''::character varying NOT NULL, date_hw_install character varying(64) DEFAULT ''::character varying NOT NULL, date_hw_expiry character varying(64) DEFAULT ''::character varying NOT NULL, date_hw_decomm character varying(64) DEFAULT ''::character varying NOT NULL, site_address_a character varying(128) DEFAULT ''::character varying NOT NULL, site_address_b character varying(128) DEFAULT ''::character varying NOT NULL, site_address_c character varying(128) DEFAULT ''::character varying NOT NULL, site_city character varying(128) DEFAULT ''::character varying NOT NULL, site_state character varying(64) DEFAULT ''::character varying NOT NULL, site_country character varying(64) DEFAULT ''::character varying NOT NULL, site_zip character varying(64) DEFAULT ''::character varying NOT NULL, site_rack character varying(128) DEFAULT ''::character varying NOT NULL, site_notes text DEFAULT ''::text NOT NULL, poc_1_name character varying(128) DEFAULT ''::character varying NOT NULL, poc_1_email character varying(128) DEFAULT ''::character varying NOT NULL, poc_1_phone_a character varying(64) DEFAULT ''::character varying NOT NULL, poc_1_phone_b character varying(64) DEFAULT ''::character varying NOT NULL, poc_1_cell character varying(64) DEFAULT ''::character varying NOT NULL, poc_1_screen character varying(64) DEFAULT ''::character varying NOT NULL, poc_1_notes text DEFAULT ''::text NOT NULL, poc_2_name character varying(128) DEFAULT ''::character varying NOT NULL, poc_2_email character varying(128) DEFAULT ''::character varying NOT NULL, poc_2_phone_a character varying(64) DEFAULT ''::character varying NOT NULL, poc_2_phone_b character varying(64) DEFAULT ''::character varying NOT NULL, poc_2_cell character varying(64) DEFAULT ''::character varying NOT NULL, poc_2_screen character varying(64) DEFAULT ''::character varying NOT NULL, poc_2_notes text DEFAULT ''::text NOT NULL ); ALTER TABLE public.host_inventory OWNER TO zabbix2; -- -- Name: hosts_adsl_temp; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hosts_adsl_temp ( hostid bigint NOT NULL, proxy_hostid bigint, host character varying(64) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, disable_until integer DEFAULT 0 NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, available integer DEFAULT 0 NOT NULL, errors_from integer DEFAULT 0 NOT NULL, lastaccess integer DEFAULT 0 NOT NULL, ipmi_authtype integer DEFAULT 0 NOT NULL, ipmi_privilege integer DEFAULT 2 NOT NULL, ipmi_username character varying(16) DEFAULT ''::character varying NOT NULL, ipmi_password character varying(20) DEFAULT ''::character varying NOT NULL, ipmi_disable_until integer DEFAULT 0 NOT NULL, ipmi_available integer DEFAULT 0 NOT NULL, snmp_disable_until integer DEFAULT 0 NOT NULL, snmp_available integer DEFAULT 0 NOT NULL, maintenanceid bigint, maintenance_status integer DEFAULT 0 NOT NULL, maintenance_type integer DEFAULT 0 NOT NULL, maintenance_from integer DEFAULT 0 NOT NULL, ipmi_errors_from integer DEFAULT 0 NOT NULL, snmp_errors_from integer DEFAULT 0 NOT NULL, ipmi_error character varying(128) DEFAULT ''::character varying NOT NULL, snmp_error character varying(128) DEFAULT ''::character varying NOT NULL, jmx_disable_until integer DEFAULT 0 NOT NULL, jmx_available integer DEFAULT 0 NOT NULL, jmx_errors_from integer DEFAULT 0 NOT NULL, jmx_error character varying(128) DEFAULT ''::character varying NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, flags integer DEFAULT 0 NOT NULL, templateid bigint, t_number integer, t_type character varying, t_address text ); ALTER TABLE public.hosts_adsl_temp OWNER TO zabbix2; -- -- Name: hosts_optinet_temp; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE hosts_optinet_temp ( hostid bigint NOT NULL, proxy_hostid bigint, host character varying(64) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, disable_until integer DEFAULT 0 NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, available integer DEFAULT 0 NOT NULL, errors_from integer DEFAULT 0 NOT NULL, lastaccess integer DEFAULT 0 NOT NULL, ipmi_authtype integer DEFAULT 0 NOT NULL, ipmi_privilege integer DEFAULT 2 NOT NULL, ipmi_username character varying(16) DEFAULT ''::character varying NOT NULL, ipmi_password character varying(20) DEFAULT ''::character varying NOT NULL, ipmi_disable_until integer DEFAULT 0 NOT NULL, ipmi_available integer DEFAULT 0 NOT NULL, snmp_disable_until integer DEFAULT 0 NOT NULL, snmp_available integer DEFAULT 0 NOT NULL, maintenanceid bigint, maintenance_status integer DEFAULT 0 NOT NULL, maintenance_type integer DEFAULT 0 NOT NULL, maintenance_from integer DEFAULT 0 NOT NULL, ipmi_errors_from integer DEFAULT 0 NOT NULL, snmp_errors_from integer DEFAULT 0 NOT NULL, ipmi_error character varying(128) DEFAULT ''::character varying NOT NULL, snmp_error character varying(128) DEFAULT ''::character varying NOT NULL, jmx_disable_until integer DEFAULT 0 NOT NULL, jmx_available integer DEFAULT 0 NOT NULL, jmx_errors_from integer DEFAULT 0 NOT NULL, jmx_error character varying(128) DEFAULT ''::character varying NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, flags integer DEFAULT 0 NOT NULL, templateid bigint, t_number text, t_type character varying, t_address text ); ALTER TABLE public.hosts_optinet_temp OWNER TO zabbix2; -- -- Name: housekeeper; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE housekeeper ( housekeeperid bigint NOT NULL, tablename character varying(64) DEFAULT ''::character varying NOT NULL, field character varying(64) DEFAULT ''::character varying NOT NULL, value bigint NOT NULL ); ALTER TABLE public.housekeeper OWNER TO zabbix2; -- -- Name: httpstep; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE httpstep ( httpstepid bigint NOT NULL, httptestid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, no integer DEFAULT 0 NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL, timeout integer DEFAULT 30 NOT NULL, posts text DEFAULT ''::text NOT NULL, required character varying(255) DEFAULT ''::character varying NOT NULL, status_codes character varying(255) DEFAULT ''::character varying NOT NULL, variables text DEFAULT ''::text NOT NULL ); ALTER TABLE public.httpstep OWNER TO zabbix2; -- -- Name: httpstepitem; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE httpstepitem ( httpstepitemid bigint NOT NULL, httpstepid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT 0 NOT NULL ); ALTER TABLE public.httpstepitem OWNER TO zabbix2; -- -- Name: httptest; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE httptest ( httptestid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, applicationid bigint, nextcheck integer DEFAULT 0 NOT NULL, delay integer DEFAULT 60 NOT NULL, status integer DEFAULT 0 NOT NULL, variables text DEFAULT ''::text NOT NULL, agent character varying(255) DEFAULT ''::character varying NOT NULL, authentication integer DEFAULT 0 NOT NULL, http_user character varying(64) DEFAULT ''::character varying NOT NULL, http_password character varying(64) DEFAULT ''::character varying NOT NULL, hostid bigint NOT NULL, templateid bigint, http_proxy character varying(255) DEFAULT ''::character varying NOT NULL, retries integer DEFAULT 1 NOT NULL ); ALTER TABLE public.httptest OWNER TO zabbix2; -- -- Name: httptestitem; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE httptestitem ( httptestitemid bigint NOT NULL, httptestid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT 0 NOT NULL ); ALTER TABLE public.httptestitem OWNER TO zabbix2; -- -- Name: icon_map; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE icon_map ( iconmapid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, default_iconid bigint NOT NULL ); ALTER TABLE public.icon_map OWNER TO zabbix2; -- -- Name: icon_mapping; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE icon_mapping ( iconmappingid bigint NOT NULL, iconmapid bigint NOT NULL, iconid bigint NOT NULL, inventory_link integer DEFAULT 0 NOT NULL, expression character varying(64) DEFAULT ''::character varying NOT NULL, sortorder integer DEFAULT 0 NOT NULL ); ALTER TABLE public.icon_mapping OWNER TO zabbix2; -- -- Name: ids; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE ids ( nodeid integer NOT NULL, table_name character varying(64) DEFAULT ''::character varying NOT NULL, field_name character varying(64) DEFAULT ''::character varying NOT NULL, nextid bigint NOT NULL ); ALTER TABLE public.ids OWNER TO zabbix2; -- -- Name: images; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE images ( imageid bigint NOT NULL, imagetype integer DEFAULT 0 NOT NULL, name character varying(64) DEFAULT '0'::character varying NOT NULL, image bytea DEFAULT '\x'::bytea NOT NULL ); ALTER TABLE public.images OWNER TO zabbix2; -- -- Name: interface_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE interface_id_seq START WITH 3415 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.interface_id_seq OWNER TO pgsql; -- -- Name: interface; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE interface ( interfaceid bigint DEFAULT nextval('interface_id_seq'::regclass) NOT NULL, hostid bigint NOT NULL, main integer DEFAULT 0 NOT NULL, type integer DEFAULT 0 NOT NULL, useip integer DEFAULT 1 NOT NULL, ip character varying(64) DEFAULT '127.0.0.1'::character varying NOT NULL, dns character varying(64) DEFAULT ''::character varying NOT NULL, port character varying(64) DEFAULT '10050'::character varying NOT NULL ); ALTER TABLE public.interface OWNER TO zabbix2; -- -- Name: interface_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE interface_discovery ( interfaceid bigint NOT NULL, parent_interfaceid bigint NOT NULL ); ALTER TABLE public.interface_discovery OWNER TO zabbix2; -- -- Name: item_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE item_discovery ( itemdiscoveryid bigint NOT NULL, itemid bigint NOT NULL, parent_itemid bigint NOT NULL, key_ character varying(255) DEFAULT ''::character varying NOT NULL, lastcheck integer DEFAULT 0 NOT NULL, ts_delete integer DEFAULT 0 NOT NULL ); ALTER TABLE public.item_discovery OWNER TO zabbix2; -- -- Name: items_applications; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE items_applications ( itemappid bigint NOT NULL, applicationid bigint NOT NULL, itemid bigint NOT NULL ); ALTER TABLE public.items_applications OWNER TO zabbix2; -- -- Name: load_screens_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE load_screens_id_seq START WITH 10000 INCREMENT BY 1 MINVALUE 10000 NO MAXVALUE CACHE 1; ALTER TABLE public.load_screens_id_seq OWNER TO pgsql; -- -- Name: load_screens_items_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE load_screens_items_id_seq START WITH 100000 INCREMENT BY 1 MINVALUE 100000 NO MAXVALUE CACHE 1; ALTER TABLE public.load_screens_items_id_seq OWNER TO pgsql; -- -- Name: log_auth; Type: TABLE; Schema: public; Owner: pgsql; Tablespace: -- CREATE TABLE log_auth ( username character varying, reply character varying, authdate timestamp(6) without time zone, sender character varying, ip_sender inet ); ALTER TABLE public.log_auth OWNER TO pgsql; -- -- Name: maintenances; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE maintenances ( maintenanceid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL, maintenance_type integer DEFAULT 0 NOT NULL, description text DEFAULT ''::text NOT NULL, active_since integer DEFAULT 0 NOT NULL, active_till integer DEFAULT 0 NOT NULL ); ALTER TABLE public.maintenances OWNER TO zabbix2; -- -- Name: maintenances_groups; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE maintenances_groups ( maintenance_groupid bigint NOT NULL, maintenanceid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.maintenances_groups OWNER TO zabbix2; -- -- Name: maintenances_hosts; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE maintenances_hosts ( maintenance_hostid bigint NOT NULL, maintenanceid bigint NOT NULL, hostid bigint NOT NULL ); ALTER TABLE public.maintenances_hosts OWNER TO zabbix2; -- -- Name: maintenances_windows; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE maintenances_windows ( maintenance_timeperiodid bigint NOT NULL, maintenanceid bigint NOT NULL, timeperiodid bigint NOT NULL ); ALTER TABLE public.maintenances_windows OWNER TO zabbix2; -- -- Name: mappings; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE mappings ( mappingid bigint NOT NULL, valuemapid bigint NOT NULL, value character varying(64) DEFAULT ''::character varying NOT NULL, newvalue character varying(64) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.mappings OWNER TO zabbix2; -- -- Name: media; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE media ( mediaid bigint NOT NULL, userid bigint NOT NULL, mediatypeid bigint NOT NULL, sendto character varying(100) DEFAULT ''::character varying NOT NULL, active integer DEFAULT 0 NOT NULL, severity integer DEFAULT 63 NOT NULL, period character varying(100) DEFAULT '1-7,00:00-24:00'::character varying NOT NULL ); ALTER TABLE public.media OWNER TO zabbix2; -- -- Name: media_type; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE media_type ( mediatypeid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, description character varying(100) DEFAULT ''::character varying NOT NULL, smtp_server character varying(255) DEFAULT ''::character varying NOT NULL, smtp_helo character varying(255) DEFAULT ''::character varying NOT NULL, smtp_email character varying(255) DEFAULT ''::character varying NOT NULL, exec_path character varying(255) DEFAULT ''::character varying NOT NULL, gsm_modem character varying(255) DEFAULT ''::character varying NOT NULL, username character varying(255) DEFAULT ''::character varying NOT NULL, passwd character varying(255) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL ); ALTER TABLE public.media_type OWNER TO zabbix2; -- -- Name: node_cksum; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE node_cksum ( nodeid integer NOT NULL, tablename character varying(64) DEFAULT ''::character varying NOT NULL, recordid bigint NOT NULL, cksumtype integer DEFAULT 0 NOT NULL, cksum text DEFAULT ''::text NOT NULL, sync character(128) DEFAULT ''::bpchar NOT NULL ); ALTER TABLE public.node_cksum OWNER TO zabbix2; -- -- Name: nodes; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE nodes ( nodeid integer NOT NULL, name character varying(64) DEFAULT '0'::character varying NOT NULL, ip character varying(39) DEFAULT ''::character varying NOT NULL, port integer DEFAULT 10051 NOT NULL, nodetype integer DEFAULT 0 NOT NULL, masterid integer ); ALTER TABLE public.nodes OWNER TO zabbix2; -- -- Name: opcommand; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opcommand ( operationid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, scriptid bigint, execute_on integer DEFAULT 0 NOT NULL, port character varying(64) 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, command text DEFAULT ''::text NOT NULL ); ALTER TABLE public.opcommand OWNER TO zabbix2; -- -- Name: opcommand_grp; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opcommand_grp ( opcommand_grpid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.opcommand_grp OWNER TO zabbix2; -- -- Name: opcommand_hst; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opcommand_hst ( opcommand_hstid bigint NOT NULL, operationid bigint NOT NULL, hostid bigint ); ALTER TABLE public.opcommand_hst OWNER TO zabbix2; -- -- Name: opconditions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opconditions ( opconditionid bigint NOT NULL, operationid bigint NOT NULL, conditiontype integer DEFAULT 0 NOT NULL, operator integer DEFAULT 0 NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.opconditions OWNER TO zabbix2; -- -- Name: operations; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE operations ( operationid bigint NOT NULL, actionid bigint NOT NULL, operationtype integer DEFAULT 0 NOT NULL, esc_period integer DEFAULT 0 NOT NULL, esc_step_from integer DEFAULT 1 NOT NULL, esc_step_to integer DEFAULT 1 NOT NULL, evaltype integer DEFAULT 0 NOT NULL ); ALTER TABLE public.operations OWNER TO zabbix2; -- -- Name: opgroup; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opgroup ( opgroupid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.opgroup OWNER TO zabbix2; -- -- Name: opmessage; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opmessage ( operationid bigint NOT NULL, default_msg integer DEFAULT 0 NOT NULL, subject character varying(255) DEFAULT ''::character varying NOT NULL, message text DEFAULT ''::text NOT NULL, mediatypeid bigint ); ALTER TABLE public.opmessage OWNER TO zabbix2; -- -- Name: opmessage_grp; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opmessage_grp ( opmessage_grpid bigint NOT NULL, operationid bigint NOT NULL, usrgrpid bigint NOT NULL ); ALTER TABLE public.opmessage_grp OWNER TO zabbix2; -- -- Name: opmessage_usr; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE opmessage_usr ( opmessage_usrid bigint NOT NULL, operationid bigint NOT NULL, userid bigint NOT NULL ); ALTER TABLE public.opmessage_usr OWNER TO zabbix2; -- -- Name: optemplate; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE optemplate ( optemplateid bigint NOT NULL, operationid bigint NOT NULL, templateid bigint NOT NULL ); ALTER TABLE public.optemplate OWNER TO zabbix2; -- -- Name: profiles; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE profiles ( profileid bigint NOT NULL, userid bigint NOT NULL, idx character varying(96) DEFAULT ''::character varying NOT NULL, idx2 bigint DEFAULT 0::bigint NOT NULL, value_id bigint DEFAULT 0::bigint NOT NULL, value_int integer DEFAULT 0 NOT NULL, value_str character varying(255) DEFAULT ''::character varying NOT NULL, source character varying(96) DEFAULT ''::character varying NOT NULL, type integer DEFAULT 0 NOT NULL ); ALTER TABLE public.profiles OWNER TO zabbix2; -- -- Name: proxy_autoreg_host; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE proxy_autoreg_host ( id bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, host character varying(64) DEFAULT ''::character varying NOT NULL, listen_ip character varying(39) DEFAULT ''::character varying NOT NULL, listen_port integer DEFAULT 0 NOT NULL, listen_dns character varying(64) DEFAULT ''::character varying NOT NULL, host_metadata character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.proxy_autoreg_host OWNER TO zabbix2; -- -- Name: proxy_autoreg_host_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE proxy_autoreg_host_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.proxy_autoreg_host_id_seq OWNER TO zabbix2; -- -- Name: proxy_autoreg_host_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE proxy_autoreg_host_id_seq OWNED BY proxy_autoreg_host.id; -- -- Name: proxy_dhistory; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE proxy_dhistory ( id bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, druleid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, ip character varying(39) DEFAULT ''::character varying NOT NULL, port integer DEFAULT 0 NOT NULL, key_ character varying(255) DEFAULT ''::character varying NOT NULL, value character varying(255) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, dcheckid bigint, dns character varying(64) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.proxy_dhistory OWNER TO zabbix2; -- -- Name: proxy_dhistory_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE proxy_dhistory_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.proxy_dhistory_id_seq OWNER TO zabbix2; -- -- Name: proxy_dhistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE proxy_dhistory_id_seq OWNED BY proxy_dhistory.id; -- -- Name: proxy_history; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE proxy_history ( id bigint NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, "timestamp" integer DEFAULT 0 NOT NULL, source character varying(64) DEFAULT ''::character varying NOT NULL, severity integer DEFAULT 0 NOT NULL, value text DEFAULT ''::text NOT NULL, logeventid integer DEFAULT 0 NOT NULL, ns integer DEFAULT 0 NOT NULL, state integer DEFAULT 0 NOT NULL ); ALTER TABLE public.proxy_history OWNER TO zabbix2; -- -- Name: proxy_history_id_seq; Type: SEQUENCE; Schema: public; Owner: zabbix2 -- CREATE SEQUENCE proxy_history_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.proxy_history_id_seq OWNER TO zabbix2; -- -- Name: proxy_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: zabbix2 -- ALTER SEQUENCE proxy_history_id_seq OWNED BY proxy_history.id; -- -- Name: regexps; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE regexps ( regexpid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL, test_string text DEFAULT ''::text NOT NULL ); ALTER TABLE public.regexps OWNER TO zabbix2; -- -- Name: screens; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE screens ( screenid bigint NOT NULL, name character varying(255) NOT NULL, hsize integer DEFAULT 1 NOT NULL, vsize integer DEFAULT 1 NOT NULL, templateid bigint ); ALTER TABLE public.screens OWNER TO zabbix2; -- -- Name: screens_items; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE screens_items ( screenitemid bigint NOT NULL, screenid bigint NOT NULL, resourcetype integer DEFAULT 0 NOT NULL, resourceid bigint DEFAULT 0::bigint NOT NULL, width integer DEFAULT 320 NOT NULL, height integer DEFAULT 200 NOT NULL, x integer DEFAULT 0 NOT NULL, y integer DEFAULT 0 NOT NULL, colspan integer DEFAULT 0 NOT NULL, rowspan integer DEFAULT 0 NOT NULL, elements integer DEFAULT 25 NOT NULL, valign integer DEFAULT 0 NOT NULL, halign integer DEFAULT 0 NOT NULL, style integer DEFAULT 0 NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL, dynamic integer DEFAULT 0 NOT NULL, sort_triggers integer DEFAULT 0 NOT NULL, application character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.screens_items OWNER TO zabbix2; -- -- Name: scripts; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE scripts ( scriptid bigint NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, command character varying(255) DEFAULT ''::character varying NOT NULL, host_access integer DEFAULT 2 NOT NULL, usrgrpid bigint, groupid bigint, description text DEFAULT ''::text NOT NULL, confirmation character varying(255) DEFAULT ''::character varying NOT NULL, type integer DEFAULT 0 NOT NULL, execute_on integer DEFAULT 1 NOT NULL ); ALTER TABLE public.scripts OWNER TO zabbix2; -- -- Name: service_alarms; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE service_alarms ( servicealarmid bigint NOT NULL, serviceid bigint NOT NULL, clock integer DEFAULT 0 NOT NULL, value integer DEFAULT 0 NOT NULL ); ALTER TABLE public.service_alarms OWNER TO zabbix2; -- -- Name: services; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE services ( serviceid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, algorithm integer DEFAULT 0 NOT NULL, triggerid bigint, showsla integer DEFAULT 0 NOT NULL, goodsla numeric(16,4) DEFAULT 99.9 NOT NULL, sortorder integer DEFAULT 0 NOT NULL ); ALTER TABLE public.services OWNER TO zabbix2; -- -- Name: services_links; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE services_links ( linkid bigint NOT NULL, serviceupid bigint NOT NULL, servicedownid bigint NOT NULL, soft integer DEFAULT 0 NOT NULL ); ALTER TABLE public.services_links OWNER TO zabbix2; -- -- Name: services_times; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE services_times ( timeid bigint NOT NULL, serviceid bigint NOT NULL, type integer DEFAULT 0 NOT NULL, ts_from integer DEFAULT 0 NOT NULL, ts_to integer DEFAULT 0 NOT NULL, note character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.services_times OWNER TO zabbix2; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sessions ( sessionid character varying(32) DEFAULT ''::character varying NOT NULL, userid bigint NOT NULL, lastaccess integer DEFAULT 0 NOT NULL, status integer DEFAULT 0 NOT NULL ); ALTER TABLE public.sessions OWNER TO zabbix2; -- -- Name: slides; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE slides ( slideid bigint NOT NULL, slideshowid bigint NOT NULL, screenid bigint NOT NULL, step integer DEFAULT 0 NOT NULL, delay integer DEFAULT 0 NOT NULL ); ALTER TABLE public.slides OWNER TO zabbix2; -- -- Name: slideshows; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE slideshows ( slideshowid bigint NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, delay integer DEFAULT 0 NOT NULL ); ALTER TABLE public.slideshows OWNER TO zabbix2; -- -- Name: sysmap_element_url; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmap_element_url ( sysmapelementurlid bigint NOT NULL, selementid bigint NOT NULL, name character varying(255) NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.sysmap_element_url OWNER TO zabbix2; -- -- Name: sysmap_url; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmap_url ( sysmapurlid bigint NOT NULL, sysmapid bigint NOT NULL, name character varying(255) NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL, elementtype integer DEFAULT 0 NOT NULL ); ALTER TABLE public.sysmap_url OWNER TO zabbix2; -- -- Name: sysmaps; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmaps ( sysmapid bigint NOT NULL, name character varying(128) DEFAULT ''::character varying NOT NULL, width integer DEFAULT 600 NOT NULL, height integer DEFAULT 400 NOT NULL, backgroundid bigint, label_type integer DEFAULT 2 NOT NULL, label_location integer DEFAULT 0 NOT NULL, highlight integer DEFAULT 1 NOT NULL, expandproblem integer DEFAULT 1 NOT NULL, markelements integer DEFAULT 0 NOT NULL, show_unack integer DEFAULT 0 NOT NULL, grid_size integer DEFAULT 50 NOT NULL, grid_show integer DEFAULT 1 NOT NULL, grid_align integer DEFAULT 1 NOT NULL, label_format integer DEFAULT 0 NOT NULL, label_type_host integer DEFAULT 2 NOT NULL, label_type_hostgroup integer DEFAULT 2 NOT NULL, label_type_trigger integer DEFAULT 2 NOT NULL, label_type_map integer DEFAULT 2 NOT NULL, label_type_image integer DEFAULT 2 NOT NULL, label_string_host character varying(255) DEFAULT ''::character varying NOT NULL, label_string_hostgroup character varying(255) DEFAULT ''::character varying NOT NULL, label_string_trigger character varying(255) DEFAULT ''::character varying NOT NULL, label_string_map character varying(255) DEFAULT ''::character varying NOT NULL, label_string_image character varying(255) DEFAULT ''::character varying NOT NULL, iconmapid bigint, expand_macros integer DEFAULT 0 NOT NULL, severity_min integer DEFAULT 0 NOT NULL ); ALTER TABLE public.sysmaps OWNER TO zabbix2; -- -- Name: sysmaps_elements; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmaps_elements ( selementid bigint NOT NULL, sysmapid bigint NOT NULL, elementid bigint DEFAULT 0::bigint NOT NULL, elementtype integer DEFAULT 0 NOT NULL, iconid_off bigint, iconid_on bigint, label character varying(2048) DEFAULT ''::character varying NOT NULL, label_location integer DEFAULT (-1) NOT NULL, x integer DEFAULT 0 NOT NULL, y integer DEFAULT 0 NOT NULL, iconid_disabled bigint, iconid_maintenance bigint, elementsubtype integer DEFAULT 0 NOT NULL, areatype integer DEFAULT 0 NOT NULL, width integer DEFAULT 200 NOT NULL, height integer DEFAULT 200 NOT NULL, viewtype integer DEFAULT 0 NOT NULL, use_iconmap integer DEFAULT 1 NOT NULL ); ALTER TABLE public.sysmaps_elements OWNER TO zabbix2; -- -- Name: sysmaps_link_triggers; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmaps_link_triggers ( linktriggerid bigint NOT NULL, linkid bigint NOT NULL, triggerid bigint NOT NULL, drawtype integer DEFAULT 0 NOT NULL, color character varying(6) DEFAULT '000000'::character varying NOT NULL ); ALTER TABLE public.sysmaps_link_triggers OWNER TO zabbix2; -- -- Name: sysmaps_links; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE sysmaps_links ( linkid bigint NOT NULL, sysmapid bigint NOT NULL, selementid1 bigint NOT NULL, selementid2 bigint NOT NULL, drawtype integer DEFAULT 0 NOT NULL, color character varying(6) DEFAULT '000000'::character varying NOT NULL, label character varying(2048) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.sysmaps_links OWNER TO zabbix2; -- -- Name: timeperiods; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE timeperiods ( timeperiodid bigint NOT NULL, timeperiod_type integer DEFAULT 0 NOT NULL, every integer DEFAULT 0 NOT NULL, month integer DEFAULT 0 NOT NULL, dayofweek integer DEFAULT 0 NOT NULL, day integer DEFAULT 0 NOT NULL, start_time integer DEFAULT 0 NOT NULL, period integer DEFAULT 0 NOT NULL, start_date integer DEFAULT 0 NOT NULL ); ALTER TABLE public.timeperiods OWNER TO zabbix2; -- -- Name: trigger_depends; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE trigger_depends ( triggerdepid bigint NOT NULL, triggerid_down bigint NOT NULL, triggerid_up bigint NOT NULL ); ALTER TABLE public.trigger_depends OWNER TO zabbix2; -- -- Name: trigger_discovery; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE trigger_discovery ( triggerdiscoveryid bigint NOT NULL, triggerid bigint NOT NULL, parent_triggerid bigint NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.trigger_discovery OWNER TO zabbix2; -- -- Name: triggers; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE triggers ( triggerid bigint NOT NULL, expression character varying(2048) DEFAULT ''::character varying NOT NULL, description character varying(255) DEFAULT ''::character varying NOT NULL, url character varying(255) DEFAULT ''::character varying NOT NULL, status integer DEFAULT 0 NOT NULL, value integer DEFAULT 0 NOT NULL, priority integer DEFAULT 0 NOT NULL, lastchange integer DEFAULT 0 NOT NULL, comments text DEFAULT ''::text NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, templateid bigint, type integer DEFAULT 0 NOT NULL, state integer DEFAULT 0 NOT NULL, flags integer DEFAULT 0 NOT NULL ); ALTER TABLE public.triggers OWNER TO zabbix2; -- -- Name: user_history; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE user_history ( userhistoryid bigint NOT NULL, userid bigint NOT NULL, title1 character varying(255) DEFAULT ''::character varying NOT NULL, url1 character varying(255) DEFAULT ''::character varying NOT NULL, title2 character varying(255) DEFAULT ''::character varying NOT NULL, url2 character varying(255) DEFAULT ''::character varying NOT NULL, title3 character varying(255) DEFAULT ''::character varying NOT NULL, url3 character varying(255) DEFAULT ''::character varying NOT NULL, title4 character varying(255) DEFAULT ''::character varying NOT NULL, url4 character varying(255) DEFAULT ''::character varying NOT NULL, title5 character varying(255) DEFAULT ''::character varying NOT NULL, url5 character varying(255) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.user_history OWNER TO zabbix2; -- -- Name: users_exp; Type: TABLE; Schema: public; Owner: pgsql; Tablespace: -- CREATE TABLE users_exp ( userid bigint, alias character varying(100), name character varying(100), surname character varying(100), passwd character(32), url character varying(255), autologin integer, autologout integer, lang character varying(5), refresh integer, type integer, theme character varying(128), attempt_failed integer, attempt_ip character varying(39), attempt_clock integer, rows_per_page integer ); ALTER TABLE public.users_exp OWNER TO pgsql; -- -- Name: usrgrp; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE usrgrp ( usrgrpid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL, gui_access integer DEFAULT 0 NOT NULL, users_status integer DEFAULT 0 NOT NULL, debug_mode integer DEFAULT 0 NOT NULL ); ALTER TABLE public.usrgrp OWNER TO zabbix2; -- -- Name: valuemaps; Type: TABLE; Schema: public; Owner: zabbix2; Tablespace: -- CREATE TABLE valuemaps ( valuemapid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.valuemaps OWNER TO zabbix2; -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY history_str_sync ALTER COLUMN id SET DEFAULT nextval('history_str_sync_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY history_sync ALTER COLUMN id SET DEFAULT nextval('history_sync_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY history_uint_sync ALTER COLUMN id SET DEFAULT nextval('history_uint_sync_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY proxy_autoreg_host ALTER COLUMN id SET DEFAULT nextval('proxy_autoreg_host_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY proxy_dhistory ALTER COLUMN id SET DEFAULT nextval('proxy_dhistory_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY proxy_history ALTER COLUMN id SET DEFAULT nextval('proxy_history_id_seq'::regclass); -- -- Name: acknowledges_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY acknowledges ADD CONSTRAINT acknowledges_pkey PRIMARY KEY (acknowledgeid); -- -- Name: actions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY actions ADD CONSTRAINT actions_pkey PRIMARY KEY (actionid); -- -- Name: alerts_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY alerts ADD CONSTRAINT alerts_pkey PRIMARY KEY (alertid); -- -- Name: application_template_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY application_template ADD CONSTRAINT application_template_pkey PRIMARY KEY (application_templateid); -- -- Name: applications_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY applications ADD CONSTRAINT applications_pkey PRIMARY KEY (applicationid); -- -- Name: auditlog_details_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY auditlog_details ADD CONSTRAINT auditlog_details_pkey PRIMARY KEY (auditdetailid); -- -- Name: auditlog_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY auditlog ADD CONSTRAINT auditlog_pkey PRIMARY KEY (auditid); -- -- Name: autoreg_host_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY autoreg_host ADD CONSTRAINT autoreg_host_pkey PRIMARY KEY (autoreg_hostid); -- -- Name: conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY conditions ADD CONSTRAINT conditions_pkey PRIMARY KEY (conditionid); -- -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY config ADD CONSTRAINT config_pkey PRIMARY KEY (configid); -- -- Name: dchecks_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY dchecks ADD CONSTRAINT dchecks_pkey PRIMARY KEY (dcheckid); -- -- Name: dhosts_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY dhosts ADD CONSTRAINT dhosts_pkey PRIMARY KEY (dhostid); -- -- Name: drules_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY drules ADD CONSTRAINT drules_pkey PRIMARY KEY (druleid); -- -- Name: dservices_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY dservices ADD CONSTRAINT dservices_pkey PRIMARY KEY (dserviceid); -- -- Name: escalations_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY escalations ADD CONSTRAINT escalations_pkey PRIMARY KEY (escalationid); -- -- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY events ADD CONSTRAINT events_pkey PRIMARY KEY (eventid); -- -- Name: expressions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY expressions ADD CONSTRAINT expressions_pkey PRIMARY KEY (expressionid); -- -- Name: functions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY functions ADD CONSTRAINT functions_pkey PRIMARY KEY (functionid); -- -- Name: globalmacro_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY globalmacro ADD CONSTRAINT globalmacro_pkey PRIMARY KEY (globalmacroid); -- -- Name: globalvars_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY globalvars ADD CONSTRAINT globalvars_pkey PRIMARY KEY (globalvarid); -- -- Name: graph_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY graph_discovery ADD CONSTRAINT graph_discovery_pkey PRIMARY KEY (graphdiscoveryid); -- -- Name: graph_theme_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY graph_theme ADD CONSTRAINT graph_theme_pkey PRIMARY KEY (graphthemeid); -- -- Name: graphs_items_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY graphs_items ADD CONSTRAINT graphs_items_pkey PRIMARY KEY (gitemid); -- -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY graphs ADD CONSTRAINT graphs_pkey PRIMARY KEY (graphid); -- -- Name: group_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY group_discovery ADD CONSTRAINT group_discovery_pkey PRIMARY KEY (groupid); -- -- Name: group_prototype_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY group_prototype ADD CONSTRAINT group_prototype_pkey PRIMARY KEY (group_prototypeid); -- -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY groups ADD CONSTRAINT groups_pkey PRIMARY KEY (groupid); -- -- Name: history_log_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY history_log ADD CONSTRAINT history_log_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY history_str_sync ADD CONSTRAINT history_str_sync_pkey PRIMARY KEY (id); -- -- Name: history_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY history_sync ADD CONSTRAINT history_sync_pkey PRIMARY KEY (id); -- -- Name: history_text_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY history_text ADD CONSTRAINT history_text_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY history_uint_sync ADD CONSTRAINT history_uint_sync_pkey PRIMARY KEY (id); -- -- Name: host_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY host_discovery ADD CONSTRAINT host_discovery_pkey PRIMARY KEY (hostid); -- -- Name: host_inventory_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY host_inventory ADD CONSTRAINT host_inventory_pkey PRIMARY KEY (hostid); -- -- Name: hostmacro_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hostmacro ADD CONSTRAINT hostmacro_pkey PRIMARY KEY (hostmacroid); -- -- Name: hosts_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hosts_groups ADD CONSTRAINT hosts_groups_pkey PRIMARY KEY (hostgroupid); -- -- Name: hosts_host_key; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hosts ADD CONSTRAINT hosts_host_key UNIQUE (host); -- -- Name: hosts_name_key; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hosts ADD CONSTRAINT hosts_name_key UNIQUE (name); -- -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hosts ADD CONSTRAINT hosts_pkey PRIMARY KEY (hostid); -- -- Name: hosts_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY hosts_templates ADD CONSTRAINT hosts_templates_pkey PRIMARY KEY (hosttemplateid); -- -- Name: housekeeper_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY housekeeper ADD CONSTRAINT housekeeper_pkey PRIMARY KEY (housekeeperid); -- -- Name: httpstep_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY httpstep ADD CONSTRAINT httpstep_pkey PRIMARY KEY (httpstepid); -- -- Name: httpstepitem_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY httpstepitem ADD CONSTRAINT httpstepitem_pkey PRIMARY KEY (httpstepitemid); -- -- Name: httptest_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY httptest ADD CONSTRAINT httptest_pkey PRIMARY KEY (httptestid); -- -- Name: httptestitem_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY httptestitem ADD CONSTRAINT httptestitem_pkey PRIMARY KEY (httptestitemid); -- -- Name: icon_map_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY icon_map ADD CONSTRAINT icon_map_pkey PRIMARY KEY (iconmapid); -- -- Name: icon_mapping_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY icon_mapping ADD CONSTRAINT icon_mapping_pkey PRIMARY KEY (iconmappingid); -- -- Name: ids_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY ids ADD CONSTRAINT ids_pkey PRIMARY KEY (nodeid, table_name, field_name); -- -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY images ADD CONSTRAINT images_pkey PRIMARY KEY (imageid); -- -- Name: interface_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY interface_discovery ADD CONSTRAINT interface_discovery_pkey PRIMARY KEY (interfaceid); -- -- Name: interface_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY interface ADD CONSTRAINT interface_pkey PRIMARY KEY (interfaceid); -- -- Name: item_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY item_discovery ADD CONSTRAINT item_discovery_pkey PRIMARY KEY (itemdiscoveryid); -- -- Name: items_applications_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY items_applications ADD CONSTRAINT items_applications_pkey PRIMARY KEY (itemappid); -- -- Name: items_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY items ADD CONSTRAINT items_pkey PRIMARY KEY (itemid); -- -- Name: maintenances_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT maintenances_groups_pkey PRIMARY KEY (maintenance_groupid); -- -- Name: maintenances_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT maintenances_hosts_pkey PRIMARY KEY (maintenance_hostid); -- -- Name: maintenances_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY maintenances ADD CONSTRAINT maintenances_pkey PRIMARY KEY (maintenanceid); -- -- Name: maintenances_windows_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT maintenances_windows_pkey PRIMARY KEY (maintenance_timeperiodid); -- -- Name: mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY mappings ADD CONSTRAINT mappings_pkey PRIMARY KEY (mappingid); -- -- Name: media_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY media ADD CONSTRAINT media_pkey PRIMARY KEY (mediaid); -- -- Name: media_type_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY media_type ADD CONSTRAINT media_type_pkey PRIMARY KEY (mediatypeid); -- -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY nodes ADD CONSTRAINT nodes_pkey PRIMARY KEY (nodeid); -- -- Name: opcommand_grp_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT opcommand_grp_pkey PRIMARY KEY (opcommand_grpid); -- -- Name: opcommand_hst_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT opcommand_hst_pkey PRIMARY KEY (opcommand_hstid); -- -- Name: opcommand_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opcommand ADD CONSTRAINT opcommand_pkey PRIMARY KEY (operationid); -- -- Name: opconditions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opconditions ADD CONSTRAINT opconditions_pkey PRIMARY KEY (opconditionid); -- -- Name: operations_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY operations ADD CONSTRAINT operations_pkey PRIMARY KEY (operationid); -- -- Name: opgroup_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opgroup ADD CONSTRAINT opgroup_pkey PRIMARY KEY (opgroupid); -- -- Name: opmessage_grp_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT opmessage_grp_pkey PRIMARY KEY (opmessage_grpid); -- -- Name: opmessage_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opmessage ADD CONSTRAINT opmessage_pkey PRIMARY KEY (operationid); -- -- Name: opmessage_usr_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT opmessage_usr_pkey PRIMARY KEY (opmessage_usrid); -- -- Name: optemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY optemplate ADD CONSTRAINT optemplate_pkey PRIMARY KEY (optemplateid); -- -- Name: profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY profiles ADD CONSTRAINT profiles_pkey PRIMARY KEY (profileid); -- -- Name: proxy_autoreg_host_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY proxy_autoreg_host ADD CONSTRAINT proxy_autoreg_host_pkey PRIMARY KEY (id); -- -- Name: proxy_dhistory_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY proxy_dhistory ADD CONSTRAINT proxy_dhistory_pkey PRIMARY KEY (id); -- -- Name: proxy_history_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY proxy_history ADD CONSTRAINT proxy_history_pkey PRIMARY KEY (id); -- -- Name: regexps_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY regexps ADD CONSTRAINT regexps_pkey PRIMARY KEY (regexpid); -- -- Name: rights_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY rights ADD CONSTRAINT rights_pkey PRIMARY KEY (rightid); -- -- Name: screens_items_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY screens_items ADD CONSTRAINT screens_items_pkey PRIMARY KEY (screenitemid); -- -- Name: screens_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY screens ADD CONSTRAINT screens_pkey PRIMARY KEY (screenid); -- -- Name: scripts_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY scripts ADD CONSTRAINT scripts_pkey PRIMARY KEY (scriptid); -- -- Name: service_alarms_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY service_alarms ADD CONSTRAINT service_alarms_pkey PRIMARY KEY (servicealarmid); -- -- Name: services_links_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY services_links ADD CONSTRAINT services_links_pkey PRIMARY KEY (linkid); -- -- Name: services_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY services ADD CONSTRAINT services_pkey PRIMARY KEY (serviceid); -- -- Name: services_times_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY services_times ADD CONSTRAINT services_times_pkey PRIMARY KEY (timeid); -- -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (sessionid); -- -- Name: slides_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY slides ADD CONSTRAINT slides_pkey PRIMARY KEY (slideid); -- -- Name: slideshows_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY slideshows ADD CONSTRAINT slideshows_pkey PRIMARY KEY (slideshowid); -- -- Name: sysmap_element_url_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmap_element_url ADD CONSTRAINT sysmap_element_url_pkey PRIMARY KEY (sysmapelementurlid); -- -- Name: sysmap_url_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmap_url ADD CONSTRAINT sysmap_url_pkey PRIMARY KEY (sysmapurlid); -- -- Name: sysmaps_elements_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT sysmaps_elements_pkey PRIMARY KEY (selementid); -- -- Name: sysmaps_link_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT sysmaps_link_triggers_pkey PRIMARY KEY (linktriggerid); -- -- Name: sysmaps_links_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT sysmaps_links_pkey PRIMARY KEY (linkid); -- -- Name: sysmaps_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY sysmaps ADD CONSTRAINT sysmaps_pkey PRIMARY KEY (sysmapid); -- -- Name: timeperiods_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY timeperiods ADD CONSTRAINT timeperiods_pkey PRIMARY KEY (timeperiodid); -- -- Name: trends_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY trends ADD CONSTRAINT trends_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY trends_uint ADD CONSTRAINT trends_uint_pkey PRIMARY KEY (itemid, clock); -- -- Name: trigger_depends_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY trigger_depends ADD CONSTRAINT trigger_depends_pkey PRIMARY KEY (triggerdepid); -- -- Name: trigger_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT trigger_discovery_pkey PRIMARY KEY (triggerdiscoveryid); -- -- Name: triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY triggers ADD CONSTRAINT triggers_pkey PRIMARY KEY (triggerid); -- -- Name: user_history_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY user_history ADD CONSTRAINT user_history_pkey PRIMARY KEY (userhistoryid); -- -- Name: users_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY users_groups ADD CONSTRAINT users_groups_pkey PRIMARY KEY (id); -- -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY users ADD CONSTRAINT users_pkey PRIMARY KEY (userid); -- -- Name: usrgrp_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY usrgrp ADD CONSTRAINT usrgrp_pkey PRIMARY KEY (usrgrpid); -- -- Name: valuemaps_pkey; Type: CONSTRAINT; Schema: public; Owner: zabbix2; Tablespace: -- ALTER TABLE ONLY valuemaps ADD CONSTRAINT valuemaps_pkey PRIMARY KEY (valuemapid); -- -- Name: acknowledges_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX acknowledges_1 ON acknowledges USING btree (userid); -- -- Name: acknowledges_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX acknowledges_2 ON acknowledges USING btree (eventid); -- -- Name: acknowledges_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX acknowledges_3 ON acknowledges USING btree (clock); -- -- Name: actions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX actions_1 ON actions USING btree (eventsource, status); -- -- Name: alerts_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_1 ON alerts USING btree (actionid); -- -- Name: alerts_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_2 ON alerts USING btree (clock); -- -- Name: alerts_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_3 ON alerts USING btree (eventid); -- -- Name: alerts_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_4 ON alerts USING btree (status, retries); -- -- Name: alerts_5; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_5 ON alerts USING btree (mediatypeid); -- -- Name: alerts_6; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX alerts_6 ON alerts USING btree (userid); -- -- Name: application_template_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX application_template_1 ON application_template USING btree (applicationid, templateid); -- -- Name: application_template_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX application_template_2 ON application_template USING btree (templateid); -- -- Name: applications_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX applications_2 ON applications USING btree (hostid, name); -- -- Name: auditlog_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX auditlog_1 ON auditlog USING btree (userid, clock); -- -- Name: auditlog_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX auditlog_2 ON auditlog USING btree (clock); -- -- Name: auditlog_details_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX auditlog_details_1 ON auditlog_details USING btree (auditid); -- -- Name: autoreg_host_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX autoreg_host_1 ON autoreg_host USING btree (proxy_hostid, host); -- -- Name: conditions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX conditions_1 ON conditions USING btree (actionid); -- -- Name: config_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX config_1 ON config USING btree (alert_usrgrpid); -- -- Name: config_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX config_2 ON config USING btree (discovery_groupid); -- -- Name: dchecks_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX dchecks_1 ON dchecks USING btree (druleid); -- -- Name: dhosts_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX dhosts_1 ON dhosts USING btree (druleid); -- -- Name: drules_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX drules_1 ON drules USING btree (proxy_hostid); -- -- Name: dservices_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX dservices_1 ON dservices USING btree (dcheckid, type, key_, ip, port); -- -- Name: dservices_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX dservices_2 ON dservices USING btree (dhostid); -- -- Name: escalations_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX escalations_1 ON escalations USING btree (actionid, triggerid, itemid, escalationid); -- -- Name: events_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX events_1 ON events USING btree (source, object, objectid, clock); -- -- Name: events_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX events_2 ON events USING btree (source, object, clock); -- -- Name: expressions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX expressions_1 ON expressions USING btree (regexpid); -- -- Name: functions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX functions_1 ON functions USING btree (triggerid); -- -- Name: functions_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX functions_2 ON functions USING btree (itemid, function, parameter); -- -- Name: globalmacro_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX globalmacro_1 ON globalmacro USING btree (macro); -- -- Name: graph_discovery_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX graph_discovery_1 ON graph_discovery USING btree (graphid, parent_graphid); -- -- Name: graph_discovery_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graph_discovery_2 ON graph_discovery USING btree (parent_graphid); -- -- Name: graph_theme_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graph_theme_1 ON graph_theme USING btree (description); -- -- Name: graph_theme_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graph_theme_2 ON graph_theme USING btree (theme); -- -- Name: graphid_index; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphid_index ON graphs USING btree (graphid); ALTER TABLE graphs CLUSTER ON graphid_index; -- -- Name: graphs_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_1 ON graphs USING btree (name); -- -- Name: graphs_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_2 ON graphs USING btree (templateid); -- -- Name: graphs_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_3 ON graphs USING btree (ymin_itemid); -- -- Name: graphs_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_4 ON graphs USING btree (ymax_itemid); -- -- Name: graphs_items_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_items_1 ON graphs_items USING btree (itemid); -- -- Name: graphs_items_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_items_2 ON graphs_items USING btree (graphid); -- -- Name: graphs_items_mix_ind; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX graphs_items_mix_ind ON graphs_items USING btree (graphid, itemid); -- -- Name: group_prototype_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX group_prototype_1 ON group_prototype USING btree (hostid); -- -- Name: groups_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX groups_1 ON groups USING btree (name); -- -- Name: history_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_1 ON history USING btree (itemid, clock); -- -- Name: history_log_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_log_1 ON history_log USING btree (itemid, clock); -- -- Name: history_log_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX history_log_2 ON history_log USING btree (itemid, id); -- -- Name: history_str_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_str_1 ON history_str USING btree (itemid, clock); -- -- Name: history_str_sync_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_str_sync_1 ON history_str_sync USING btree (nodeid, id); -- -- Name: history_sync_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_sync_1 ON history_sync USING btree (nodeid, id); -- -- Name: history_text_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_text_1 ON history_text USING btree (itemid, clock); -- -- Name: history_text_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX history_text_2 ON history_text USING btree (itemid, id); -- -- Name: history_uint_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_uint_1 ON history_uint USING btree (itemid, clock); -- -- Name: history_uint_sync_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX history_uint_sync_1 ON history_uint_sync USING btree (nodeid, id); -- -- Name: hostmacro_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX hostmacro_1 ON hostmacro USING btree (hostid, macro); -- -- Name: hosts_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_1 ON hosts USING btree (host); -- -- Name: hosts_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_2 ON hosts USING btree (status); -- -- Name: hosts_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_3 ON hosts USING btree (proxy_hostid); -- -- Name: hosts_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_4 ON hosts USING btree (name); -- -- Name: hosts_5; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_5 ON hosts USING btree (maintenanceid); -- -- Name: hosts_groups_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups USING btree (hostid, groupid); -- -- Name: hosts_groups_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_groups_2 ON hosts_groups USING btree (groupid); -- -- Name: hosts_groups_hosts_ind; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_groups_hosts_ind ON hosts_groups USING btree (hostid); -- -- Name: hosts_hostid_ind; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_hostid_ind ON hosts USING btree (hostid); -- -- Name: hosts_templates_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates USING btree (hostid, templateid); -- -- Name: hosts_templates_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX hosts_templates_2 ON hosts_templates USING btree (templateid); -- -- Name: httpstep_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httpstep_1 ON httpstep USING btree (httptestid); -- -- Name: httpstepitem_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX httpstepitem_1 ON httpstepitem USING btree (httpstepid, itemid); -- -- Name: httpstepitem_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httpstepitem_2 ON httpstepitem USING btree (itemid); -- -- Name: httptest_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httptest_1 ON httptest USING btree (applicationid); -- -- Name: httptest_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX httptest_2 ON httptest USING btree (hostid, name); -- -- Name: httptest_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httptest_3 ON httptest USING btree (status); -- -- Name: httptest_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httptest_4 ON httptest USING btree (templateid); -- -- Name: httptestitem_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX httptestitem_1 ON httptestitem USING btree (httptestid, itemid); -- -- Name: httptestitem_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX httptestitem_2 ON httptestitem USING btree (itemid); -- -- Name: icon_map_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX icon_map_1 ON icon_map USING btree (name); -- -- Name: icon_map_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX icon_map_2 ON icon_map USING btree (default_iconid); -- -- Name: icon_mapping_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX icon_mapping_1 ON icon_mapping USING btree (iconmapid); -- -- Name: icon_mapping_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX icon_mapping_2 ON icon_mapping USING btree (iconid); -- -- Name: images_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX images_1 ON images USING btree (imagetype, name); -- -- Name: interface_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX interface_1 ON interface USING btree (hostid, type); -- -- Name: interface_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX interface_2 ON interface USING btree (ip, dns); -- -- Name: item_discovery_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX item_discovery_1 ON item_discovery USING btree (itemid, parent_itemid); -- -- Name: item_discovery_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX item_discovery_2 ON item_discovery USING btree (parent_itemid); -- -- Name: items_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX items_1 ON items USING btree (hostid, key_); -- -- Name: items_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX items_3 ON items USING btree (status); -- -- Name: items_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX items_4 ON items USING btree (templateid); -- -- Name: items_5; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX items_5 ON items USING btree (valuemapid); -- -- Name: items_6; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX items_6 ON items USING btree (interfaceid); -- -- Name: items_applications_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX items_applications_1 ON items_applications USING btree (applicationid, itemid); -- -- Name: items_applications_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX items_applications_2 ON items_applications USING btree (itemid); -- -- Name: log_auth_authdate_index; Type: INDEX; Schema: public; Owner: pgsql; Tablespace: -- CREATE INDEX log_auth_authdate_index ON log_auth USING btree (authdate); -- -- Name: log_auth_username_index; Type: INDEX; Schema: public; Owner: pgsql; Tablespace: -- CREATE INDEX log_auth_username_index ON log_auth USING btree (username); -- -- Name: maintenances_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX maintenances_1 ON maintenances USING btree (active_since, active_till); -- -- Name: maintenances_groups_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups USING btree (maintenanceid, groupid); -- -- Name: maintenances_groups_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX maintenances_groups_2 ON maintenances_groups USING btree (groupid); -- -- Name: maintenances_hosts_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts USING btree (maintenanceid, hostid); -- -- Name: maintenances_hosts_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX maintenances_hosts_2 ON maintenances_hosts USING btree (hostid); -- -- Name: maintenances_windows_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows USING btree (maintenanceid, timeperiodid); -- -- Name: maintenances_windows_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX maintenances_windows_2 ON maintenances_windows USING btree (timeperiodid); -- -- Name: mappings_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX mappings_1 ON mappings USING btree (valuemapid); -- -- Name: media_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX media_1 ON media USING btree (userid); -- -- Name: media_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX media_2 ON media USING btree (mediatypeid); -- -- Name: mix_ind; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX mix_ind ON rights USING btree (groupid, id); -- -- Name: node_cksum_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX node_cksum_1 ON node_cksum USING btree (nodeid, cksumtype, tablename, recordid); -- -- Name: nodes_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX nodes_1 ON nodes USING btree (masterid); -- -- Name: opcommand_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opcommand_1 ON opcommand USING btree (scriptid); -- -- Name: opcommand_grp_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opcommand_grp_1 ON opcommand_grp USING btree (operationid); -- -- Name: opcommand_grp_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opcommand_grp_2 ON opcommand_grp USING btree (groupid); -- -- Name: opcommand_hst_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opcommand_hst_1 ON opcommand_hst USING btree (operationid); -- -- Name: opcommand_hst_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opcommand_hst_2 ON opcommand_hst USING btree (hostid); -- -- Name: opconditions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opconditions_1 ON opconditions USING btree (operationid); -- -- Name: operations_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX operations_1 ON operations USING btree (actionid); -- -- Name: opgroup_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX opgroup_1 ON opgroup USING btree (operationid, groupid); -- -- Name: opgroup_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opgroup_2 ON opgroup USING btree (groupid); -- -- Name: opmessage_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opmessage_1 ON opmessage USING btree (mediatypeid); -- -- Name: opmessage_grp_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp USING btree (operationid, usrgrpid); -- -- Name: opmessage_grp_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opmessage_grp_2 ON opmessage_grp USING btree (usrgrpid); -- -- Name: opmessage_usr_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr USING btree (operationid, userid); -- -- Name: opmessage_usr_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX opmessage_usr_2 ON opmessage_usr USING btree (userid); -- -- Name: optemplate_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX optemplate_1 ON optemplate USING btree (operationid, templateid); -- -- Name: optemplate_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX optemplate_2 ON optemplate USING btree (templateid); -- -- Name: profiles_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX profiles_1 ON profiles USING btree (userid, idx, idx2); -- -- Name: profiles_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX profiles_2 ON profiles USING btree (userid, profileid); -- -- Name: proxy_autoreg_host_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host USING btree (clock); -- -- Name: proxy_dhistory_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX proxy_dhistory_1 ON proxy_dhistory USING btree (clock); -- -- Name: proxy_history_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX proxy_history_1 ON proxy_history USING btree (clock); -- -- Name: regexps_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX regexps_1 ON regexps USING btree (name); -- -- Name: rights_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX rights_1 ON rights USING btree (groupid); -- -- Name: rights_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX rights_2 ON rights USING btree (id); -- -- Name: screens_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX screens_1 ON screens USING btree (templateid); -- -- Name: screens_items_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX screens_items_1 ON screens_items USING btree (screenid); -- -- Name: scripts_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX scripts_1 ON scripts USING btree (usrgrpid); -- -- Name: scripts_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX scripts_2 ON scripts USING btree (groupid); -- -- Name: service_alarms_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX service_alarms_1 ON service_alarms USING btree (serviceid, clock); -- -- Name: service_alarms_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX service_alarms_2 ON service_alarms USING btree (clock); -- -- Name: services_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX services_1 ON services USING btree (triggerid); -- -- Name: services_links_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX services_links_1 ON services_links USING btree (servicedownid); -- -- Name: services_links_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX services_links_2 ON services_links USING btree (serviceupid, servicedownid); -- -- Name: services_times_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX services_times_1 ON services_times USING btree (serviceid, type, ts_from, ts_to); -- -- Name: sessions_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sessions_1 ON sessions USING btree (userid, status); -- -- Name: slides_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX slides_1 ON slides USING btree (slideshowid); -- -- Name: slides_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX slides_2 ON slides USING btree (screenid); -- -- Name: sysmap_element_url_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX sysmap_element_url_1 ON sysmap_element_url USING btree (selementid, name); -- -- Name: sysmap_url_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url USING btree (sysmapid, name); -- -- Name: sysmaps_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_1 ON sysmaps USING btree (name); -- -- Name: sysmaps_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_2 ON sysmaps USING btree (backgroundid); -- -- Name: sysmaps_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_3 ON sysmaps USING btree (iconmapid); -- -- Name: sysmaps_elements_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_elements_1 ON sysmaps_elements USING btree (sysmapid); -- -- Name: sysmaps_elements_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_elements_2 ON sysmaps_elements USING btree (iconid_off); -- -- Name: sysmaps_elements_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_elements_3 ON sysmaps_elements USING btree (iconid_on); -- -- Name: sysmaps_elements_4; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_elements_4 ON sysmaps_elements USING btree (iconid_disabled); -- -- Name: sysmaps_elements_5; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_elements_5 ON sysmaps_elements USING btree (iconid_maintenance); -- -- Name: sysmaps_link_triggers_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX sysmaps_link_triggers_1 ON sysmaps_link_triggers USING btree (linkid, triggerid); -- -- Name: sysmaps_link_triggers_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_link_triggers_2 ON sysmaps_link_triggers USING btree (triggerid); -- -- Name: sysmaps_links_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_links_1 ON sysmaps_links USING btree (sysmapid); -- -- Name: sysmaps_links_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_links_2 ON sysmaps_links USING btree (selementid1); -- -- Name: sysmaps_links_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX sysmaps_links_3 ON sysmaps_links USING btree (selementid2); -- -- Name: trigger_depends_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX trigger_depends_1 ON trigger_depends USING btree (triggerid_down, triggerid_up); -- -- Name: trigger_depends_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX trigger_depends_2 ON trigger_depends USING btree (triggerid_up); -- -- Name: trigger_discovery_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX trigger_discovery_1 ON trigger_discovery USING btree (triggerid, parent_triggerid); -- -- Name: trigger_discovery_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX trigger_discovery_2 ON trigger_discovery USING btree (parent_triggerid); -- -- Name: triggers_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX triggers_1 ON triggers USING btree (status); -- -- Name: triggers_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX triggers_2 ON triggers USING btree (value); -- -- Name: triggers_3; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX triggers_3 ON triggers USING btree (templateid); -- -- Name: user_history_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX user_history_1 ON user_history USING btree (userid); -- -- Name: users_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX users_1 ON users USING btree (alias); -- -- Name: users_groups_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE UNIQUE INDEX users_groups_1 ON users_groups USING btree (usrgrpid, userid); -- -- Name: users_groups_2; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX users_groups_2 ON users_groups USING btree (userid); -- -- Name: usrgrp_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX usrgrp_1 ON usrgrp USING btree (name); -- -- Name: valuemaps_1; Type: INDEX; Schema: public; Owner: zabbix2; Tablespace: -- CREATE INDEX valuemaps_1 ON valuemaps USING btree (name); -- -- Name: hosts_templates_refresh; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER hosts_templates_refresh AFTER INSERT OR DELETE OR UPDATE OF hostid ON hosts_templates FOR EACH STATEMENT EXECUTE PROCEDURE device_auth.refresh_nas_complex_view(); ALTER TABLE hosts_templates DISABLE TRIGGER hosts_templates_refresh; -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON history FOR EACH ROW EXECUTE PROCEDURE trg_partition('day'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON history_sync FOR EACH ROW EXECUTE PROCEDURE trg_partition('day'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON history_uint FOR EACH ROW EXECUTE PROCEDURE trg_partition('day'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON history_str_sync FOR EACH ROW EXECUTE PROCEDURE trg_partition('day'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON history_log FOR EACH ROW EXECUTE PROCEDURE trg_partition('day'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON trends FOR EACH ROW EXECUTE PROCEDURE trg_partition('month'); -- -- Name: partition_trg; Type: TRIGGER; Schema: public; Owner: zabbix2 -- CREATE TRIGGER partition_trg BEFORE INSERT ON trends_uint FOR EACH ROW EXECUTE PROCEDURE trg_partition('month'); -- -- Name: c_acknowledges_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_acknowledges_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_2 FOREIGN KEY (eventid) REFERENCES events(eventid) ON DELETE CASCADE; -- -- Name: c_alerts_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_1 FOREIGN KEY (actionid) REFERENCES actions(actionid) ON DELETE CASCADE; -- -- Name: c_alerts_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_2 FOREIGN KEY (eventid) REFERENCES events(eventid) ON DELETE CASCADE; -- -- Name: c_alerts_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_3 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_alerts_4; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_4 FOREIGN KEY (mediatypeid) REFERENCES media_type(mediatypeid) ON DELETE CASCADE; -- -- Name: c_application_template_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY application_template ADD CONSTRAINT c_application_template_1 FOREIGN KEY (applicationid) REFERENCES applications(applicationid) ON DELETE CASCADE; -- -- Name: c_application_template_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY application_template ADD CONSTRAINT c_application_template_2 FOREIGN KEY (templateid) REFERENCES applications(applicationid) ON DELETE CASCADE; -- -- Name: c_applications_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY applications ADD CONSTRAINT c_applications_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_auditlog_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY auditlog ADD CONSTRAINT c_auditlog_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_auditlog_details_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY auditlog_details ADD CONSTRAINT c_auditlog_details_1 FOREIGN KEY (auditid) REFERENCES auditlog(auditid) ON DELETE CASCADE; -- -- Name: c_autoreg_host_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY autoreg_host ADD CONSTRAINT c_autoreg_host_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_conditions_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY conditions ADD CONSTRAINT c_conditions_1 FOREIGN KEY (actionid) REFERENCES actions(actionid) ON DELETE CASCADE; -- -- Name: c_config_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY config ADD CONSTRAINT c_config_1 FOREIGN KEY (alert_usrgrpid) REFERENCES usrgrp(usrgrpid); -- -- Name: c_config_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY config ADD CONSTRAINT c_config_2 FOREIGN KEY (discovery_groupid) REFERENCES groups(groupid); -- -- Name: c_dchecks_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY dchecks ADD CONSTRAINT c_dchecks_1 FOREIGN KEY (druleid) REFERENCES drules(druleid) ON DELETE CASCADE; -- -- Name: c_dhosts_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY dhosts ADD CONSTRAINT c_dhosts_1 FOREIGN KEY (druleid) REFERENCES drules(druleid) ON DELETE CASCADE; -- -- Name: c_drules_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY drules ADD CONSTRAINT c_drules_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid); -- -- Name: c_dservices_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_1 FOREIGN KEY (dhostid) REFERENCES dhosts(dhostid) ON DELETE CASCADE; -- -- Name: c_dservices_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_2 FOREIGN KEY (dcheckid) REFERENCES dchecks(dcheckid) ON DELETE CASCADE; -- -- Name: c_expressions_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY expressions ADD CONSTRAINT c_expressions_1 FOREIGN KEY (regexpid) REFERENCES regexps(regexpid) ON DELETE CASCADE; -- -- Name: c_functions_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_1 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_functions_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_2 FOREIGN KEY (triggerid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_graph_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_1 FOREIGN KEY (graphid) REFERENCES graphs(graphid) ON DELETE CASCADE; -- -- Name: c_graph_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_2 FOREIGN KEY (parent_graphid) REFERENCES graphs(graphid) ON DELETE CASCADE; -- -- Name: c_graphs_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_1 FOREIGN KEY (templateid) REFERENCES graphs(graphid) ON DELETE CASCADE; -- -- Name: c_graphs_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_2 FOREIGN KEY (ymin_itemid) REFERENCES items(itemid); -- -- Name: c_graphs_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_3 FOREIGN KEY (ymax_itemid) REFERENCES items(itemid); -- -- Name: c_graphs_items_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_1 FOREIGN KEY (graphid) REFERENCES graphs(graphid) ON DELETE CASCADE; -- -- Name: c_graphs_items_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_2 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_group_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_1 FOREIGN KEY (groupid) REFERENCES groups(groupid) ON DELETE CASCADE; -- -- Name: c_group_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_2 FOREIGN KEY (parent_group_prototypeid) REFERENCES group_prototype(group_prototypeid); -- -- Name: c_group_prototype_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_group_prototype_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_2 FOREIGN KEY (groupid) REFERENCES groups(groupid); -- -- Name: c_group_prototype_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_3 FOREIGN KEY (templateid) REFERENCES group_prototype(group_prototypeid) ON DELETE CASCADE; -- -- Name: c_host_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_host_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_2 FOREIGN KEY (parent_hostid) REFERENCES hosts(hostid); -- -- Name: c_host_discovery_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_3 FOREIGN KEY (parent_itemid) REFERENCES items(itemid); -- -- Name: c_host_inventory_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY host_inventory ADD CONSTRAINT c_host_inventory_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_hostmacro_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hostmacro ADD CONSTRAINT c_hostmacro_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_hosts_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts(hostid); -- -- Name: c_hosts_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_2 FOREIGN KEY (maintenanceid) REFERENCES maintenances(maintenanceid); -- -- Name: c_hosts_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_3 FOREIGN KEY (templateid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_hosts_groups_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_hosts_groups_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_2 FOREIGN KEY (groupid) REFERENCES groups(groupid) ON DELETE CASCADE; -- -- Name: c_hosts_templates_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_hosts_templates_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_2 FOREIGN KEY (templateid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_httpstep_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httpstep ADD CONSTRAINT c_httpstep_1 FOREIGN KEY (httptestid) REFERENCES httptest(httptestid) ON DELETE CASCADE; -- -- Name: c_httpstepitem_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_1 FOREIGN KEY (httpstepid) REFERENCES httpstep(httpstepid) ON DELETE CASCADE; -- -- Name: c_httpstepitem_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_2 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_httptest_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_1 FOREIGN KEY (applicationid) REFERENCES applications(applicationid); -- -- Name: c_httptest_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_2 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_httptest_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_3 FOREIGN KEY (templateid) REFERENCES httptest(httptestid) ON DELETE CASCADE; -- -- Name: c_httptestitem_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_1 FOREIGN KEY (httptestid) REFERENCES httptest(httptestid) ON DELETE CASCADE; -- -- Name: c_httptestitem_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_2 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_icon_map_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY icon_map ADD CONSTRAINT c_icon_map_1 FOREIGN KEY (default_iconid) REFERENCES images(imageid); -- -- Name: c_icon_mapping_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_1 FOREIGN KEY (iconmapid) REFERENCES icon_map(iconmapid) ON DELETE CASCADE; -- -- Name: c_icon_mapping_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_2 FOREIGN KEY (iconid) REFERENCES images(imageid); -- -- Name: c_interface_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY interface ADD CONSTRAINT c_interface_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_interface_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_1 FOREIGN KEY (interfaceid) REFERENCES interface(interfaceid) ON DELETE CASCADE; -- -- Name: c_interface_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_2 FOREIGN KEY (parent_interfaceid) REFERENCES interface(interfaceid) ON DELETE CASCADE; -- -- Name: c_item_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_1 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_item_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_2 FOREIGN KEY (parent_itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_items_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- 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: zabbix2 -- 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: zabbix2 -- 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: zabbix2 -- ALTER TABLE ONLY items ADD CONSTRAINT c_items_4 FOREIGN KEY (interfaceid) REFERENCES interface(interfaceid); -- -- Name: c_items_applications_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY items_applications ADD CONSTRAINT c_items_applications_1 FOREIGN KEY (applicationid) REFERENCES applications(applicationid) ON DELETE CASCADE; -- -- Name: c_items_applications_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY items_applications ADD CONSTRAINT c_items_applications_2 FOREIGN KEY (itemid) REFERENCES items(itemid) ON DELETE CASCADE; -- -- Name: c_maintenances_groups_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances(maintenanceid) ON DELETE CASCADE; -- -- Name: c_maintenances_groups_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_2 FOREIGN KEY (groupid) REFERENCES groups(groupid) ON DELETE CASCADE; -- -- Name: c_maintenances_hosts_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances(maintenanceid) ON DELETE CASCADE; -- -- Name: c_maintenances_hosts_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_2 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_maintenances_windows_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances(maintenanceid) ON DELETE CASCADE; -- -- Name: c_maintenances_windows_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_2 FOREIGN KEY (timeperiodid) REFERENCES timeperiods(timeperiodid) ON DELETE CASCADE; -- -- Name: c_mappings_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY mappings ADD CONSTRAINT c_mappings_1 FOREIGN KEY (valuemapid) REFERENCES valuemaps(valuemapid) ON DELETE CASCADE; -- -- Name: c_media_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY media ADD CONSTRAINT c_media_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_media_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY media ADD CONSTRAINT c_media_2 FOREIGN KEY (mediatypeid) REFERENCES media_type(mediatypeid) ON DELETE CASCADE; -- -- Name: c_node_cksum_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY node_cksum ADD CONSTRAINT c_node_cksum_1 FOREIGN KEY (nodeid) REFERENCES nodes(nodeid) ON DELETE CASCADE; -- -- Name: c_nodes_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY nodes ADD CONSTRAINT c_nodes_1 FOREIGN KEY (masterid) REFERENCES nodes(nodeid); -- -- Name: c_opcommand_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opcommand_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_2 FOREIGN KEY (scriptid) REFERENCES scripts(scriptid); -- -- Name: c_opcommand_grp_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opcommand_grp_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_2 FOREIGN KEY (groupid) REFERENCES groups(groupid); -- -- Name: c_opcommand_hst_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opcommand_hst_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_2 FOREIGN KEY (hostid) REFERENCES hosts(hostid); -- -- Name: c_opconditions_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opconditions ADD CONSTRAINT c_opconditions_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_operations_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY operations ADD CONSTRAINT c_operations_1 FOREIGN KEY (actionid) REFERENCES actions(actionid) ON DELETE CASCADE; -- -- Name: c_opgroup_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opgroup_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_2 FOREIGN KEY (groupid) REFERENCES groups(groupid); -- -- Name: c_opmessage_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opmessage_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_2 FOREIGN KEY (mediatypeid) REFERENCES media_type(mediatypeid); -- -- Name: c_opmessage_grp_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opmessage_grp_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp(usrgrpid); -- -- Name: c_opmessage_usr_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_opmessage_usr_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_2 FOREIGN KEY (userid) REFERENCES users(userid); -- -- Name: c_optemplate_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_1 FOREIGN KEY (operationid) REFERENCES operations(operationid) ON DELETE CASCADE; -- -- Name: c_optemplate_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_2 FOREIGN KEY (templateid) REFERENCES hosts(hostid); -- -- Name: c_profiles_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY profiles ADD CONSTRAINT c_profiles_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_rights_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_1 FOREIGN KEY (groupid) REFERENCES usrgrp(usrgrpid) ON DELETE CASCADE; -- -- Name: c_rights_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_2 FOREIGN KEY (id) REFERENCES groups(groupid) ON DELETE CASCADE; -- -- Name: c_screens_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY screens ADD CONSTRAINT c_screens_1 FOREIGN KEY (templateid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_screens_items_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY screens_items ADD CONSTRAINT c_screens_items_1 FOREIGN KEY (screenid) REFERENCES screens(screenid) ON DELETE CASCADE; -- -- Name: c_scripts_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp(usrgrpid); -- -- Name: c_scripts_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_2 FOREIGN KEY (groupid) REFERENCES groups(groupid); -- -- Name: c_service_alarms_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY service_alarms ADD CONSTRAINT c_service_alarms_1 FOREIGN KEY (serviceid) REFERENCES services(serviceid) ON DELETE CASCADE; -- -- Name: c_services_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY services ADD CONSTRAINT c_services_1 FOREIGN KEY (triggerid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_services_links_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_1 FOREIGN KEY (serviceupid) REFERENCES services(serviceid) ON DELETE CASCADE; -- -- Name: c_services_links_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_2 FOREIGN KEY (servicedownid) REFERENCES services(serviceid) ON DELETE CASCADE; -- -- Name: c_services_times_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY services_times ADD CONSTRAINT c_services_times_1 FOREIGN KEY (serviceid) REFERENCES services(serviceid) ON DELETE CASCADE; -- -- Name: c_sessions_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sessions ADD CONSTRAINT c_sessions_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_slides_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY slides ADD CONSTRAINT c_slides_1 FOREIGN KEY (slideshowid) REFERENCES slideshows(slideshowid) ON DELETE CASCADE; -- -- Name: c_slides_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY slides ADD CONSTRAINT c_slides_2 FOREIGN KEY (screenid) REFERENCES screens(screenid) ON DELETE CASCADE; -- -- Name: c_sysmap_element_url_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmap_element_url ADD CONSTRAINT c_sysmap_element_url_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements(selementid) ON DELETE CASCADE; -- -- Name: c_sysmap_url_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmap_url ADD CONSTRAINT c_sysmap_url_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps(sysmapid) ON DELETE CASCADE; -- -- Name: c_sysmaps_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_1 FOREIGN KEY (backgroundid) REFERENCES images(imageid); -- -- Name: c_sysmaps_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_2 FOREIGN KEY (iconmapid) REFERENCES icon_map(iconmapid); -- -- Name: c_sysmaps_elements_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps(sysmapid) ON DELETE CASCADE; -- -- Name: c_sysmaps_elements_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_2 FOREIGN KEY (iconid_off) REFERENCES images(imageid); -- -- Name: c_sysmaps_elements_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_3 FOREIGN KEY (iconid_on) REFERENCES images(imageid); -- -- Name: c_sysmaps_elements_4; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_4 FOREIGN KEY (iconid_disabled) REFERENCES images(imageid); -- -- Name: c_sysmaps_elements_5; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_5 FOREIGN KEY (iconid_maintenance) REFERENCES images(imageid); -- -- Name: c_sysmaps_link_triggers_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_1 FOREIGN KEY (linkid) REFERENCES sysmaps_links(linkid) ON DELETE CASCADE; -- -- Name: c_sysmaps_link_triggers_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_2 FOREIGN KEY (triggerid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_sysmaps_links_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps(sysmapid) ON DELETE CASCADE; -- -- Name: c_sysmaps_links_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_2 FOREIGN KEY (selementid1) REFERENCES sysmaps_elements(selementid) ON DELETE CASCADE; -- -- Name: c_sysmaps_links_3; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_3 FOREIGN KEY (selementid2) REFERENCES sysmaps_elements(selementid) ON DELETE CASCADE; -- -- Name: c_trigger_depends_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_1 FOREIGN KEY (triggerid_down) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_trigger_depends_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_2 FOREIGN KEY (triggerid_up) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_trigger_discovery_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_1 FOREIGN KEY (triggerid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_trigger_discovery_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_2 FOREIGN KEY (parent_triggerid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_triggers_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY triggers ADD CONSTRAINT c_triggers_1 FOREIGN KEY (templateid) REFERENCES triggers(triggerid) ON DELETE CASCADE; -- -- Name: c_user_history_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY user_history ADD CONSTRAINT c_user_history_1 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: c_users_groups_1; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp(usrgrpid) ON DELETE CASCADE; -- -- Name: c_users_groups_2; Type: FK CONSTRAINT; Schema: public; Owner: zabbix2 -- ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_2 FOREIGN KEY (userid) REFERENCES users(userid) ON DELETE CASCADE; -- -- Name: public; Type: ACL; Schema: -; Owner: pgsql -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM pgsql; GRANT ALL ON SCHEMA public TO pgsql; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- Name: group_sorter(character varying, integer); Type: ACL; Schema: public; Owner: pgsql -- REVOKE ALL ON FUNCTION group_sorter(match_string character varying, groupid_param integer) FROM PUBLIC; REVOKE ALL ON FUNCTION group_sorter(match_string character varying, groupid_param integer) FROM pgsql; GRANT ALL ON FUNCTION group_sorter(match_string character varying, groupid_param integer) TO pgsql; GRANT ALL ON FUNCTION group_sorter(match_string character varying, groupid_param integer) TO PUBLIC; GRANT ALL ON FUNCTION group_sorter(match_string character varying, groupid_param integer) TO zabbix; -- -- PostgreSQL database dump complete -- -- -- PostgreSQL database dump -- SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -- -- Name: partitions; Type: SCHEMA; Schema: -; Owner: zabbix -- CREATE SCHEMA partitions; ALTER SCHEMA partitions OWNER TO zabbix; SET search_path = partitions, pg_catalog; -- -- Name: trg_partition(); Type: FUNCTION; Schema: partitions; Owner: zabbix -- CREATE FUNCTION trg_partition() RETURNS trigger LANGUAGE plpgsql AS $_$ DECLARE prefix text := 'partitions.'; timeformat text; selector text; _interval INTERVAL; tablename text; startdate text; enddate text; create_table_part text; create_index_part text; BEGIN selector = TG_ARGV[0]; IF selector = 'day' THEN timeformat := 'YYYY_MM_DD'; ELSIF selector = 'month' THEN timeformat := 'YYYY_MM'; END IF; _interval := '1 ' || selector; tablename := TG_TABLE_NAME || '_p' || TO_CHAR(TO_TIMESTAMP(NEW.clock), timeformat); EXECUTE 'INSERT INTO ' || prefix || quote_ident(tablename) || ' SELECT ($1).*' USING NEW; RETURN NULL; EXCEPTION WHEN undefined_table THEN startdate := EXTRACT(epoch FROM date_trunc(selector, TO_TIMESTAMP(NEW.clock))); enddate := EXTRACT(epoch FROM date_trunc(selector, TO_TIMESTAMP(NEW.clock) + _interval )); create_table_part:= 'CREATE TABLE IF NOT EXISTS '|| prefix || quote_ident(tablename) || ' (CHECK ((clock >= ' || quote_literal(startdate) || ' AND clock < ' || quote_literal(enddate) || '))) INHERITS ('|| TG_TABLE_NAME || ')'; create_index_part:= 'CREATE INDEX '|| quote_ident(tablename) || '_1 on ' || prefix || quote_ident(tablename) || '(itemid,clock)'; EXECUTE create_table_part; EXECUTE create_index_part; --insert it again EXECUTE 'INSERT INTO ' || prefix || quote_ident(tablename) || ' SELECT ($1).*' USING NEW; RETURN NULL; END; $_$; ALTER FUNCTION partitions.trg_partition() OWNER TO zabbix; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: history_log_p2014_01_09; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_09 ( CONSTRAINT history_log_p2014_01_09_clock_check CHECK (((clock >= 1389189600) AND (clock < 1389276000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_09 OWNER TO zabbix; -- -- Name: history_log_p2014_01_10; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_10 ( CONSTRAINT history_log_p2014_01_10_clock_check CHECK (((clock >= 1389276000) AND (clock < 1389362400))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_10 OWNER TO zabbix; -- -- Name: history_log_p2014_01_11; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_11 ( CONSTRAINT history_log_p2014_01_11_clock_check CHECK (((clock >= 1389362400) AND (clock < 1389448800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_11 OWNER TO zabbix; -- -- Name: history_log_p2014_01_13; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_13 ( CONSTRAINT history_log_p2014_01_13_clock_check CHECK (((clock >= 1389535200) AND (clock < 1389621600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_13 OWNER TO zabbix; -- -- Name: history_log_p2014_01_14; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_14 ( CONSTRAINT history_log_p2014_01_14_clock_check CHECK (((clock >= 1389621600) AND (clock < 1389708000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_14 OWNER TO zabbix; -- -- Name: history_log_p2014_01_15; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_15 ( CONSTRAINT history_log_p2014_01_15_clock_check CHECK (((clock >= 1389708000) AND (clock < 1389794400))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_15 OWNER TO zabbix; -- -- Name: history_log_p2014_01_16; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_16 ( CONSTRAINT history_log_p2014_01_16_clock_check CHECK (((clock >= 1389794400) AND (clock < 1389880800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_16 OWNER TO zabbix; -- -- Name: history_log_p2014_01_17; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_17 ( CONSTRAINT history_log_p2014_01_17_clock_check CHECK (((clock >= 1389880800) AND (clock < 1389967200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_17 OWNER TO zabbix; -- -- Name: history_log_p2014_01_21; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_21 ( CONSTRAINT history_log_p2014_01_21_clock_check CHECK (((clock >= 1390226400) AND (clock < 1390312800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_21 OWNER TO zabbix; -- -- Name: history_log_p2014_01_22; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_22 ( CONSTRAINT history_log_p2014_01_22_clock_check CHECK (((clock >= 1390312800) AND (clock < 1390399200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_22 OWNER TO zabbix; -- -- Name: history_log_p2014_01_23; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_23 ( CONSTRAINT history_log_p2014_01_23_clock_check CHECK (((clock >= 1390399200) AND (clock < 1390485600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_23 OWNER TO zabbix; -- -- Name: history_log_p2014_01_24; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_24 ( CONSTRAINT history_log_p2014_01_24_clock_check CHECK (((clock >= 1390485600) AND (clock < 1390572000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_24 OWNER TO zabbix; -- -- Name: history_log_p2014_01_27; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_27 ( CONSTRAINT history_log_p2014_01_27_clock_check CHECK (((clock >= 1390744800) AND (clock < 1390831200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_27 OWNER TO zabbix; -- -- Name: history_log_p2014_01_28; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_28 ( CONSTRAINT history_log_p2014_01_28_clock_check CHECK (((clock >= 1390831200) AND (clock < 1390917600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_28 OWNER TO zabbix; -- -- Name: history_log_p2014_01_29; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_log_p2014_01_29 ( CONSTRAINT history_log_p2014_01_29_clock_check CHECK (((clock >= 1390917600) AND (clock < 1391004000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_p2014_01_29 OWNER TO zabbix; -- -- Name: history_p2013_12_25; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_25 ( CONSTRAINT history_p2013_12_25_clock_check CHECK (((clock >= 1387893600) AND (clock < 1387980000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_25 OWNER TO zabbix; -- -- Name: history_p2013_12_26; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_26 ( CONSTRAINT history_p2013_12_26_clock_check CHECK (((clock >= 1387980000) AND (clock < 1388066400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_26 OWNER TO zabbix; -- -- Name: history_p2013_12_27; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_27 ( CONSTRAINT history_p2013_12_27_clock_check CHECK (((clock >= 1388066400) AND (clock < 1388152800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_27 OWNER TO zabbix; -- -- Name: history_p2013_12_28; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_28 ( CONSTRAINT history_p2013_12_28_clock_check CHECK (((clock >= 1388152800) AND (clock < 1388239200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_28 OWNER TO zabbix; -- -- Name: history_p2013_12_29; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_29 ( CONSTRAINT history_p2013_12_29_clock_check CHECK (((clock >= 1388239200) AND (clock < 1388325600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_29 OWNER TO zabbix; -- -- Name: history_p2013_12_30; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_30 ( CONSTRAINT history_p2013_12_30_clock_check CHECK (((clock >= 1388325600) AND (clock < 1388412000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_30 OWNER TO zabbix; -- -- Name: history_p2013_12_31; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2013_12_31 ( CONSTRAINT history_p2013_12_31_clock_check CHECK (((clock >= 1388412000) AND (clock < 1388498400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2013_12_31 OWNER TO zabbix; -- -- Name: history_p2014_01_01; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_01 ( CONSTRAINT history_p2014_01_01_clock_check CHECK (((clock >= 1388498400) AND (clock < 1388584800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_01 OWNER TO zabbix; -- -- Name: history_p2014_01_02; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_02 ( CONSTRAINT history_p2014_01_02_clock_check CHECK (((clock >= 1388584800) AND (clock < 1388671200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_02 OWNER TO zabbix; -- -- Name: history_p2014_01_03; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_03 ( CONSTRAINT history_p2014_01_03_clock_check CHECK (((clock >= 1388671200) AND (clock < 1388757600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_03 OWNER TO zabbix; -- -- Name: history_p2014_01_04; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_04 ( CONSTRAINT history_p2014_01_04_clock_check CHECK (((clock >= 1388757600) AND (clock < 1388844000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_04 OWNER TO zabbix; -- -- Name: history_p2014_01_05; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_05 ( CONSTRAINT history_p2014_01_05_clock_check CHECK (((clock >= 1388844000) AND (clock < 1388930400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_05 OWNER TO zabbix; -- -- Name: history_p2014_01_06; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_06 ( CONSTRAINT history_p2014_01_06_clock_check CHECK (((clock >= 1388930400) AND (clock < 1389016800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_06 OWNER TO zabbix; -- -- Name: history_p2014_01_07; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_07 ( CONSTRAINT history_p2014_01_07_clock_check CHECK (((clock >= 1389016800) AND (clock < 1389103200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_07 OWNER TO zabbix; -- -- Name: history_p2014_01_08; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_08 ( CONSTRAINT history_p2014_01_08_clock_check CHECK (((clock >= 1389103200) AND (clock < 1389189600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_08 OWNER TO zabbix; -- -- Name: history_p2014_01_09; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_09 ( CONSTRAINT history_p2014_01_09_clock_check CHECK (((clock >= 1389189600) AND (clock < 1389276000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_09 OWNER TO zabbix; -- -- Name: history_p2014_01_10; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_10 ( CONSTRAINT history_p2014_01_10_clock_check CHECK (((clock >= 1389276000) AND (clock < 1389362400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_10 OWNER TO zabbix; -- -- Name: history_p2014_01_11; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_11 ( CONSTRAINT history_p2014_01_11_clock_check CHECK (((clock >= 1389362400) AND (clock < 1389448800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_11 OWNER TO zabbix; -- -- Name: history_p2014_01_12; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_12 ( CONSTRAINT history_p2014_01_12_clock_check CHECK (((clock >= 1389448800) AND (clock < 1389535200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_12 OWNER TO zabbix; -- -- Name: history_p2014_01_13; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_13 ( CONSTRAINT history_p2014_01_13_clock_check CHECK (((clock >= 1389535200) AND (clock < 1389621600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_13 OWNER TO zabbix; -- -- Name: history_p2014_01_14; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_14 ( CONSTRAINT history_p2014_01_14_clock_check CHECK (((clock >= 1389621600) AND (clock < 1389708000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_14 OWNER TO zabbix; -- -- Name: history_p2014_01_15; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_15 ( CONSTRAINT history_p2014_01_15_clock_check CHECK (((clock >= 1389708000) AND (clock < 1389794400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_15 OWNER TO zabbix; -- -- Name: history_p2014_01_16; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_16 ( CONSTRAINT history_p2014_01_16_clock_check CHECK (((clock >= 1389794400) AND (clock < 1389880800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_16 OWNER TO zabbix; -- -- Name: history_p2014_01_17; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_17 ( CONSTRAINT history_p2014_01_17_clock_check CHECK (((clock >= 1389880800) AND (clock < 1389967200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_17 OWNER TO zabbix; -- -- Name: history_p2014_01_18; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_18 ( CONSTRAINT history_p2014_01_18_clock_check CHECK (((clock >= 1389967200) AND (clock < 1390053600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_18 OWNER TO zabbix; -- -- Name: history_p2014_01_19; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_19 ( CONSTRAINT history_p2014_01_19_clock_check CHECK (((clock >= 1390053600) AND (clock < 1390140000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_19 OWNER TO zabbix; -- -- Name: history_p2014_01_20; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_20 ( CONSTRAINT history_p2014_01_20_clock_check CHECK (((clock >= 1390140000) AND (clock < 1390226400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_20 OWNER TO zabbix; -- -- Name: history_p2014_01_21; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_21 ( CONSTRAINT history_p2014_01_21_clock_check CHECK (((clock >= 1390226400) AND (clock < 1390312800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_21 OWNER TO zabbix; -- -- Name: history_p2014_01_22; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_22 ( CONSTRAINT history_p2014_01_22_clock_check CHECK (((clock >= 1390312800) AND (clock < 1390399200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_22 OWNER TO zabbix; -- -- Name: history_p2014_01_23; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_23 ( CONSTRAINT history_p2014_01_23_clock_check CHECK (((clock >= 1390399200) AND (clock < 1390485600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_23 OWNER TO zabbix; -- -- Name: history_p2014_01_24; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_24 ( CONSTRAINT history_p2014_01_24_clock_check CHECK (((clock >= 1390485600) AND (clock < 1390572000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_24 OWNER TO zabbix; -- -- Name: history_p2014_01_25; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_25 ( CONSTRAINT history_p2014_01_25_clock_check CHECK (((clock >= 1390572000) AND (clock < 1390658400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_25 OWNER TO zabbix; -- -- Name: history_p2014_01_26; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_26 ( CONSTRAINT history_p2014_01_26_clock_check CHECK (((clock >= 1390658400) AND (clock < 1390744800))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_26 OWNER TO zabbix; -- -- Name: history_p2014_01_27; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_27 ( CONSTRAINT history_p2014_01_27_clock_check CHECK (((clock >= 1390744800) AND (clock < 1390831200))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_27 OWNER TO zabbix; -- -- Name: history_p2014_01_28; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_28 ( CONSTRAINT history_p2014_01_28_clock_check CHECK (((clock >= 1390831200) AND (clock < 1390917600))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_28 OWNER TO zabbix; -- -- Name: history_p2014_01_29; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_29 ( CONSTRAINT history_p2014_01_29_clock_check CHECK (((clock >= 1390917600) AND (clock < 1391004000))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_29 OWNER TO zabbix; -- -- Name: history_p2014_01_30; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_p2014_01_30 ( CONSTRAINT history_p2014_01_30_clock_check CHECK (((clock >= 1391004000) AND (clock < 1391090400))) ) INHERITS (public.history); ALTER TABLE partitions.history_p2014_01_30 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_25; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_25 ( CONSTRAINT history_uint_p2013_12_25_clock_check CHECK (((clock >= 1387893600) AND (clock < 1387980000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_25 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_26; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_26 ( CONSTRAINT history_uint_p2013_12_26_clock_check CHECK (((clock >= 1387980000) AND (clock < 1388066400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_26 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_27; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_27 ( CONSTRAINT history_uint_p2013_12_27_clock_check CHECK (((clock >= 1388066400) AND (clock < 1388152800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_27 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_28; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_28 ( CONSTRAINT history_uint_p2013_12_28_clock_check CHECK (((clock >= 1388152800) AND (clock < 1388239200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_28 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_29; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_29 ( CONSTRAINT history_uint_p2013_12_29_clock_check CHECK (((clock >= 1388239200) AND (clock < 1388325600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_29 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_30; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_30 ( CONSTRAINT history_uint_p2013_12_30_clock_check CHECK (((clock >= 1388325600) AND (clock < 1388412000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_30 OWNER TO zabbix; -- -- Name: history_uint_p2013_12_31; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2013_12_31 ( CONSTRAINT history_uint_p2013_12_31_clock_check CHECK (((clock >= 1388412000) AND (clock < 1388498400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2013_12_31 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_01; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_01 ( CONSTRAINT history_uint_p2014_01_01_clock_check CHECK (((clock >= 1388498400) AND (clock < 1388584800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_01 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_02; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_02 ( CONSTRAINT history_uint_p2014_01_02_clock_check CHECK (((clock >= 1388584800) AND (clock < 1388671200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_02 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_03; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_03 ( CONSTRAINT history_uint_p2014_01_03_clock_check CHECK (((clock >= 1388671200) AND (clock < 1388757600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_03 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_04; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_04 ( CONSTRAINT history_uint_p2014_01_04_clock_check CHECK (((clock >= 1388757600) AND (clock < 1388844000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_04 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_05; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_05 ( CONSTRAINT history_uint_p2014_01_05_clock_check CHECK (((clock >= 1388844000) AND (clock < 1388930400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_05 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_06; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_06 ( CONSTRAINT history_uint_p2014_01_06_clock_check CHECK (((clock >= 1388930400) AND (clock < 1389016800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_06 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_07; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_07 ( CONSTRAINT history_uint_p2014_01_07_clock_check CHECK (((clock >= 1389016800) AND (clock < 1389103200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_07 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_08; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_08 ( CONSTRAINT history_uint_p2014_01_08_clock_check CHECK (((clock >= 1389103200) AND (clock < 1389189600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_08 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_09; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_09 ( CONSTRAINT history_uint_p2014_01_09_clock_check CHECK (((clock >= 1389189600) AND (clock < 1389276000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_09 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_10; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_10 ( CONSTRAINT history_uint_p2014_01_10_clock_check CHECK (((clock >= 1389276000) AND (clock < 1389362400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_10 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_11; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_11 ( CONSTRAINT history_uint_p2014_01_11_clock_check CHECK (((clock >= 1389362400) AND (clock < 1389448800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_11 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_12; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_12 ( CONSTRAINT history_uint_p2014_01_12_clock_check CHECK (((clock >= 1389448800) AND (clock < 1389535200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_12 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_13; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_13 ( CONSTRAINT history_uint_p2014_01_13_clock_check CHECK (((clock >= 1389535200) AND (clock < 1389621600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_13 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_14; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_14 ( CONSTRAINT history_uint_p2014_01_14_clock_check CHECK (((clock >= 1389621600) AND (clock < 1389708000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_14 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_15; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_15 ( CONSTRAINT history_uint_p2014_01_15_clock_check CHECK (((clock >= 1389708000) AND (clock < 1389794400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_15 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_16; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_16 ( CONSTRAINT history_uint_p2014_01_16_clock_check CHECK (((clock >= 1389794400) AND (clock < 1389880800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_16 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_17; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_17 ( CONSTRAINT history_uint_p2014_01_17_clock_check CHECK (((clock >= 1389880800) AND (clock < 1389967200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_17 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_18; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_18 ( CONSTRAINT history_uint_p2014_01_18_clock_check CHECK (((clock >= 1389967200) AND (clock < 1390053600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_18 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_19; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_19 ( CONSTRAINT history_uint_p2014_01_19_clock_check CHECK (((clock >= 1390053600) AND (clock < 1390140000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_19 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_20; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_20 ( CONSTRAINT history_uint_p2014_01_20_clock_check CHECK (((clock >= 1390140000) AND (clock < 1390226400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_20 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_21; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_21 ( CONSTRAINT history_uint_p2014_01_21_clock_check CHECK (((clock >= 1390226400) AND (clock < 1390312800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_21 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_22; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_22 ( CONSTRAINT history_uint_p2014_01_22_clock_check CHECK (((clock >= 1390312800) AND (clock < 1390399200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_22 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_23; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_23 ( CONSTRAINT history_uint_p2014_01_23_clock_check CHECK (((clock >= 1390399200) AND (clock < 1390485600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_23 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_24; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_24 ( CONSTRAINT history_uint_p2014_01_24_clock_check CHECK (((clock >= 1390485600) AND (clock < 1390572000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_24 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_25; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_25 ( CONSTRAINT history_uint_p2014_01_25_clock_check CHECK (((clock >= 1390572000) AND (clock < 1390658400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_25 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_26; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_26 ( CONSTRAINT history_uint_p2014_01_26_clock_check CHECK (((clock >= 1390658400) AND (clock < 1390744800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_26 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_27; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_27 ( CONSTRAINT history_uint_p2014_01_27_clock_check CHECK (((clock >= 1390744800) AND (clock < 1390831200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_27 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_28; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_28 ( CONSTRAINT history_uint_p2014_01_28_clock_check CHECK (((clock >= 1390831200) AND (clock < 1390917600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_28 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_29; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_29 ( CONSTRAINT history_uint_p2014_01_29_clock_check CHECK (((clock >= 1390917600) AND (clock < 1391004000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_29 OWNER TO zabbix; -- -- Name: history_uint_p2014_01_30; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE history_uint_p2014_01_30 ( CONSTRAINT history_uint_p2014_01_30_clock_check CHECK (((clock >= 1391004000) AND (clock < 1391090400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_p2014_01_30 OWNER TO zabbix; -- -- Name: trends_p2013_12; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE trends_p2013_12 ( CONSTRAINT trends_p2013_12_clock_check CHECK (((clock >= 1385820000) AND (clock < 1388498400))) ) INHERITS (public.trends); ALTER TABLE partitions.trends_p2013_12 OWNER TO zabbix; -- -- Name: trends_p2014_01; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE trends_p2014_01 ( CONSTRAINT trends_p2014_01_clock_check CHECK (((clock >= 1388498400) AND (clock < 1391176800))) ) INHERITS (public.trends); ALTER TABLE partitions.trends_p2014_01 OWNER TO zabbix; -- -- Name: trends_uint_p2013_12; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE trends_uint_p2013_12 ( CONSTRAINT trends_uint_p2013_12_clock_check CHECK (((clock >= 1385820000) AND (clock < 1388498400))) ) INHERITS (public.trends_uint); ALTER TABLE partitions.trends_uint_p2013_12 OWNER TO zabbix; -- -- Name: trends_uint_p2014_01; Type: TABLE; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE TABLE trends_uint_p2014_01 ( CONSTRAINT trends_uint_p2014_01_clock_check CHECK (((clock >= 1388498400) AND (clock < 1391176800))) ) INHERITS (public.trends_uint); ALTER TABLE partitions.trends_uint_p2014_01 OWNER TO zabbix; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_09 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_10 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_11 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_13 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_14 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_15 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_16 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_17 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_21 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_22 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_23 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_24 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_27 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_28 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: timestamp; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN "timestamp" SET DEFAULT 0; -- -- Name: source; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN source SET DEFAULT ''::character varying; -- -- Name: severity; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN severity SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN value SET DEFAULT ''::text; -- -- Name: logeventid; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN logeventid SET DEFAULT 0; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_log_p2014_01_29 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_25 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_25 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_25 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_26 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_26 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_26 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_27 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_27 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_27 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_28 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_28 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_28 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_29 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_29 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_29 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_30 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_30 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_30 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_31 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_31 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2013_12_31 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_01 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_01 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_01 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_02 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_02 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_02 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_03 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_03 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_03 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_04 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_04 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_04 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_05 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_05 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_05 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_06 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_06 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_06 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_07 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_07 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_07 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_08 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_08 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_08 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_09 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_09 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_09 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_10 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_10 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_10 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_11 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_11 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_11 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_12 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_12 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_12 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_13 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_13 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_13 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_14 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_14 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_14 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_15 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_15 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_15 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_16 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_16 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_16 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_17 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_17 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_17 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_18 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_18 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_18 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_19 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_19 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_19 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_20 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_20 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_20 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_21 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_21 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_21 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_22 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_22 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_22 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_23 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_23 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_23 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_24 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_24 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_24 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_25 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_25 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_25 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_26 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_26 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_26 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_27 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_27 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_27 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_28 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_28 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_28 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_29 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_29 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_29 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_30 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_30 ALTER COLUMN value SET DEFAULT 0.0000; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_p2014_01_30 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_25 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_25 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_25 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_26 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_26 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_26 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_27 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_27 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_27 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_28 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_28 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_28 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_29 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_29 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_29 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_30 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_30 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_30 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_31 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_31 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2013_12_31 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_01 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_01 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_01 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_02 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_02 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_02 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_03 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_03 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_03 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_04 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_04 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_04 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_05 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_05 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_05 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_06 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_06 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_06 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_07 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_07 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_07 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_08 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_08 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_08 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_09 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_09 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_09 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_10 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_10 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_10 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_11 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_11 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_11 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_12 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_12 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_12 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_13 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_13 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_13 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_14 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_14 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_14 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_15 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_15 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_15 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_16 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_16 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_16 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_17 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_17 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_17 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_18 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_18 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_18 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_19 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_19 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_19 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_20 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_20 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_20 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_21 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_21 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_21 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_22 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_22 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_22 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_23 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_23 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_23 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_24 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_24 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_24 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_25 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_25 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_25 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_26 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_26 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_26 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_27 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_27 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_27 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_28 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_28 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_28 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_29 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_29 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_29 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_30 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: value; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_30 ALTER COLUMN value SET DEFAULT (0)::numeric; -- -- Name: ns; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY history_uint_p2014_01_30 ALTER COLUMN ns SET DEFAULT 0; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2013_12 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: num; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2013_12 ALTER COLUMN num SET DEFAULT 0; -- -- Name: value_min; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2013_12 ALTER COLUMN value_min SET DEFAULT 0.0000; -- -- Name: value_avg; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2013_12 ALTER COLUMN value_avg SET DEFAULT 0.0000; -- -- Name: value_max; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2013_12 ALTER COLUMN value_max SET DEFAULT 0.0000; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2014_01 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: num; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2014_01 ALTER COLUMN num SET DEFAULT 0; -- -- Name: value_min; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2014_01 ALTER COLUMN value_min SET DEFAULT 0.0000; -- -- Name: value_avg; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2014_01 ALTER COLUMN value_avg SET DEFAULT 0.0000; -- -- Name: value_max; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_p2014_01 ALTER COLUMN value_max SET DEFAULT 0.0000; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2013_12 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: num; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2013_12 ALTER COLUMN num SET DEFAULT 0; -- -- Name: value_min; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2013_12 ALTER COLUMN value_min SET DEFAULT (0)::numeric; -- -- Name: value_avg; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2013_12 ALTER COLUMN value_avg SET DEFAULT (0)::numeric; -- -- Name: value_max; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2013_12 ALTER COLUMN value_max SET DEFAULT (0)::numeric; -- -- Name: clock; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2014_01 ALTER COLUMN clock SET DEFAULT 0; -- -- Name: num; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2014_01 ALTER COLUMN num SET DEFAULT 0; -- -- Name: value_min; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2014_01 ALTER COLUMN value_min SET DEFAULT (0)::numeric; -- -- Name: value_avg; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2014_01 ALTER COLUMN value_avg SET DEFAULT (0)::numeric; -- -- Name: value_max; Type: DEFAULT; Schema: partitions; Owner: zabbix -- ALTER TABLE ONLY trends_uint_p2014_01 ALTER COLUMN value_max SET DEFAULT (0)::numeric; -- -- Name: history_log_p2014_01_09_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_09_1 ON history_log_p2014_01_09 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_10_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_10_1 ON history_log_p2014_01_10 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_11_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_11_1 ON history_log_p2014_01_11 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_13_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_13_1 ON history_log_p2014_01_13 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_14_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_14_1 ON history_log_p2014_01_14 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_15_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_15_1 ON history_log_p2014_01_15 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_16_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_16_1 ON history_log_p2014_01_16 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_17_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_17_1 ON history_log_p2014_01_17 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_21_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_21_1 ON history_log_p2014_01_21 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_22_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_22_1 ON history_log_p2014_01_22 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_23_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_23_1 ON history_log_p2014_01_23 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_24_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_24_1 ON history_log_p2014_01_24 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_27_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_27_1 ON history_log_p2014_01_27 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_28_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_28_1 ON history_log_p2014_01_28 USING btree (itemid, clock); -- -- Name: history_log_p2014_01_29_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_log_p2014_01_29_1 ON history_log_p2014_01_29 USING btree (itemid, clock); -- -- Name: history_p2013_12_25_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_25_1 ON history_p2013_12_25 USING btree (itemid, clock); -- -- Name: history_p2013_12_26_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_26_1 ON history_p2013_12_26 USING btree (itemid, clock); -- -- Name: history_p2013_12_27_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_27_1 ON history_p2013_12_27 USING btree (itemid, clock); -- -- Name: history_p2013_12_28_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_28_1 ON history_p2013_12_28 USING btree (itemid, clock); -- -- Name: history_p2013_12_29_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_29_1 ON history_p2013_12_29 USING btree (itemid, clock); -- -- Name: history_p2013_12_30_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_30_1 ON history_p2013_12_30 USING btree (itemid, clock); -- -- Name: history_p2013_12_31_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2013_12_31_1 ON history_p2013_12_31 USING btree (itemid, clock); -- -- Name: history_p2014_01_01_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_01_1 ON history_p2014_01_01 USING btree (itemid, clock); -- -- Name: history_p2014_01_02_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_02_1 ON history_p2014_01_02 USING btree (itemid, clock); -- -- Name: history_p2014_01_03_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_03_1 ON history_p2014_01_03 USING btree (itemid, clock); -- -- Name: history_p2014_01_04_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_04_1 ON history_p2014_01_04 USING btree (itemid, clock); -- -- Name: history_p2014_01_05_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_05_1 ON history_p2014_01_05 USING btree (itemid, clock); -- -- Name: history_p2014_01_06_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_06_1 ON history_p2014_01_06 USING btree (itemid, clock); -- -- Name: history_p2014_01_07_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_07_1 ON history_p2014_01_07 USING btree (itemid, clock); -- -- Name: history_p2014_01_08_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_08_1 ON history_p2014_01_08 USING btree (itemid, clock); -- -- Name: history_p2014_01_09_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_09_1 ON history_p2014_01_09 USING btree (itemid, clock); -- -- Name: history_p2014_01_10_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_10_1 ON history_p2014_01_10 USING btree (itemid, clock); -- -- Name: history_p2014_01_11_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_11_1 ON history_p2014_01_11 USING btree (itemid, clock); -- -- Name: history_p2014_01_12_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_12_1 ON history_p2014_01_12 USING btree (itemid, clock); -- -- Name: history_p2014_01_13_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_13_1 ON history_p2014_01_13 USING btree (itemid, clock); -- -- Name: history_p2014_01_14_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_14_1 ON history_p2014_01_14 USING btree (itemid, clock); -- -- Name: history_p2014_01_15_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_15_1 ON history_p2014_01_15 USING btree (itemid, clock); -- -- Name: history_p2014_01_16_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_16_1 ON history_p2014_01_16 USING btree (itemid, clock); -- -- Name: history_p2014_01_17_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_17_1 ON history_p2014_01_17 USING btree (itemid, clock); -- -- Name: history_p2014_01_18_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_18_1 ON history_p2014_01_18 USING btree (itemid, clock); -- -- Name: history_p2014_01_19_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_19_1 ON history_p2014_01_19 USING btree (itemid, clock); -- -- Name: history_p2014_01_20_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_20_1 ON history_p2014_01_20 USING btree (itemid, clock); -- -- Name: history_p2014_01_21_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_21_1 ON history_p2014_01_21 USING btree (itemid, clock); -- -- Name: history_p2014_01_22_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_22_1 ON history_p2014_01_22 USING btree (itemid, clock); -- -- Name: history_p2014_01_23_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_23_1 ON history_p2014_01_23 USING btree (itemid, clock); -- -- Name: history_p2014_01_24_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_24_1 ON history_p2014_01_24 USING btree (itemid, clock); -- -- Name: history_p2014_01_25_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_25_1 ON history_p2014_01_25 USING btree (itemid, clock); -- -- Name: history_p2014_01_26_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_26_1 ON history_p2014_01_26 USING btree (itemid, clock); -- -- Name: history_p2014_01_27_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_27_1 ON history_p2014_01_27 USING btree (itemid, clock); -- -- Name: history_p2014_01_28_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_28_1 ON history_p2014_01_28 USING btree (itemid, clock); -- -- Name: history_p2014_01_29_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_29_1 ON history_p2014_01_29 USING btree (itemid, clock); -- -- Name: history_p2014_01_30_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_p2014_01_30_1 ON history_p2014_01_30 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_25_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_25_1 ON history_uint_p2013_12_25 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_26_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_26_1 ON history_uint_p2013_12_26 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_27_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_27_1 ON history_uint_p2013_12_27 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_28_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_28_1 ON history_uint_p2013_12_28 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_29_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_29_1 ON history_uint_p2013_12_29 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_30_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_30_1 ON history_uint_p2013_12_30 USING btree (itemid, clock); -- -- Name: history_uint_p2013_12_31_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2013_12_31_1 ON history_uint_p2013_12_31 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_01_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_01_1 ON history_uint_p2014_01_01 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_02_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_02_1 ON history_uint_p2014_01_02 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_03_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_03_1 ON history_uint_p2014_01_03 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_04_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_04_1 ON history_uint_p2014_01_04 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_05_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_05_1 ON history_uint_p2014_01_05 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_06_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_06_1 ON history_uint_p2014_01_06 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_07_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_07_1 ON history_uint_p2014_01_07 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_08_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_08_1 ON history_uint_p2014_01_08 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_09_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_09_1 ON history_uint_p2014_01_09 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_10_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_10_1 ON history_uint_p2014_01_10 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_11_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_11_1 ON history_uint_p2014_01_11 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_12_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_12_1 ON history_uint_p2014_01_12 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_13_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_13_1 ON history_uint_p2014_01_13 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_14_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_14_1 ON history_uint_p2014_01_14 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_15_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_15_1 ON history_uint_p2014_01_15 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_16_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_16_1 ON history_uint_p2014_01_16 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_17_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_17_1 ON history_uint_p2014_01_17 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_18_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_18_1 ON history_uint_p2014_01_18 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_19_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_19_1 ON history_uint_p2014_01_19 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_20_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_20_1 ON history_uint_p2014_01_20 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_21_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_21_1 ON history_uint_p2014_01_21 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_22_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_22_1 ON history_uint_p2014_01_22 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_23_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_23_1 ON history_uint_p2014_01_23 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_24_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_24_1 ON history_uint_p2014_01_24 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_25_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_25_1 ON history_uint_p2014_01_25 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_26_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_26_1 ON history_uint_p2014_01_26 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_27_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_27_1 ON history_uint_p2014_01_27 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_28_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_28_1 ON history_uint_p2014_01_28 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_29_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_29_1 ON history_uint_p2014_01_29 USING btree (itemid, clock); -- -- Name: history_uint_p2014_01_30_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX history_uint_p2014_01_30_1 ON history_uint_p2014_01_30 USING btree (itemid, clock); -- -- Name: trends_p2013_12_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX trends_p2013_12_1 ON trends_p2013_12 USING btree (itemid, clock); -- -- Name: trends_p2014_01_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX trends_p2014_01_1 ON trends_p2014_01 USING btree (itemid, clock); -- -- Name: trends_uint_p2013_12_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX trends_uint_p2013_12_1 ON trends_uint_p2013_12 USING btree (itemid, clock); -- -- Name: trends_uint_p2014_01_1; Type: INDEX; Schema: partitions; Owner: zabbix; Tablespace: -- CREATE INDEX trends_uint_p2014_01_1 ON trends_uint_p2014_01 USING btree (itemid, clock); -- -- PostgreSQL database dump complete --