-- -- 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: postgres -- CREATE SCHEMA partitions; ALTER SCHEMA partitions OWNER TO postgres; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; SET search_path = public, pg_catalog; -- -- Name: create_zbx_partitions_day(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION create_zbx_partitions_day(part text) RETURNS void LANGUAGE plpgsql AS $$ DECLARE current_check TEXT; next_check TEXT; next_partition TEXT; created_partition TEXT; BEGIN SELECT EXTRACT(epoch FROM date_trunc('day',CURRENT_TIMESTAMP + INTERVAL '1 day')) INTO current_check; SELECT EXTRACT(epoch FROM date_trunc('day',CURRENT_TIMESTAMP + INTERVAL '2 day')) INTO next_check; SELECT TO_CHAR(CURRENT_TIMESTAMP + INTERVAL '1 day','_yyyymmdd') INTO next_partition; created_partition:='partitions.' || part || next_partition; EXECUTE 'create table if not exists ' || created_partition ||' (check ( clock >= ' || current_check || ' and clock < ' || next_check || '),like tpl_' || part || ' including defaults including storage including constraints including indexes) inherits(' || part || ')'; END; $$; ALTER FUNCTION public.create_zbx_partitions_day(part text) OWNER TO postgres; -- -- Name: create_zbx_partitions_month(text); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION create_zbx_partitions_month(part text) RETURNS void LANGUAGE plpgsql AS $$ DECLARE current_check TEXT; next_check TEXT; next_partition TEXT; created_partition TEXT; BEGIN SELECT EXTRACT(epoch FROM date_trunc('month',CURRENT_TIMESTAMP + INTERVAL '1 month')) INTO current_check; SELECT EXTRACT(epoch FROM date_trunc('month',CURRENT_TIMESTAMP + INTERVAL '2 month')) INTO next_check; SELECT TO_CHAR(CURRENT_TIMESTAMP + INTERVAL '1 month','_yyyymm') INTO next_partition; created_partition:='partitions.' || part || next_partition; EXECUTE 'create table if not exists ' || created_partition ||' (check ( clock >= ' || current_check || ' and clock < ' || next_check || '),like tpl_' || part || ' including defaults including storage including constraints including indexes) inherits(' || part || ')'; END; $$; ALTER FUNCTION public.create_zbx_partitions_month(part text) OWNER TO postgres; -- -- Name: dynamic_insert_trigger_day(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dynamic_insert_trigger_day() RETURNS trigger LANGUAGE plpgsql AS $_$ BEGIN EXECUTE 'INSERT INTO partitions.' || TG_TABLE_NAME || TO_CHAR(TO_TIMESTAMP(NEW.clock),'_yyyymmdd') || ' SELECT ($1).*' USING NEW; RETURN NULL; EXCEPTION WHEN undefined_table THEN EXECUTE 'INSERT INTO partitions.emergency_' || TG_TABLE_NAME || ' SELECT ($1).*' USING NEW; RETURN NULL; END; $_$; ALTER FUNCTION public.dynamic_insert_trigger_day() OWNER TO postgres; -- -- Name: dynamic_insert_trigger_month(); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION dynamic_insert_trigger_month() RETURNS trigger LANGUAGE plpgsql AS $_$ BEGIN EXECUTE 'INSERT INTO partitions.' || TG_TABLE_NAME || TO_CHAR(TO_TIMESTAMP(NEW.clock),'_yyyymm') || ' SELECT ($1).*' USING NEW; RETURN NULL; EXCEPTION WHEN undefined_table THEN EXECUTE 'INSERT INTO partitions.emergency_' || TG_TABLE_NAME || ' SELECT ($1).*' USING NEW; RETURN NULL; END; $_$; ALTER FUNCTION public.dynamic_insert_trigger_month() OWNER TO postgres; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: acknowledges; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.acknowledges OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: acknowledges_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201401 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.acknowledges) WITH (autovacuum_enabled=false); ALTER TABLE partitions.acknowledges_201401 OWNER TO postgres; -- -- Name: acknowledges_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201402 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.acknowledges) WITH (autovacuum_enabled=false); ALTER TABLE partitions.acknowledges_201402 OWNER TO postgres; -- -- Name: acknowledges_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201403 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.acknowledges) WITH (autovacuum_enabled=false); ALTER TABLE partitions.acknowledges_201403 OWNER TO postgres; -- -- Name: acknowledges_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201404 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.acknowledges) WITH (autovacuum_enabled=false); ALTER TABLE partitions.acknowledges_201404 OWNER TO postgres; -- -- Name: acknowledges_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201405 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.acknowledges); ALTER TABLE partitions.acknowledges_201405 OWNER TO postgres; -- -- Name: acknowledges_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE acknowledges_201406 ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying, CONSTRAINT acknowledges_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.acknowledges); ALTER TABLE partitions.acknowledges_201406 OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: alerts; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE public.alerts OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: alerts_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201401 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.alerts) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.alerts_201401 OWNER TO postgres; -- -- Name: alerts_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201402 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.alerts) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.alerts_201402 OWNER TO postgres; -- -- Name: alerts_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201403 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.alerts) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.alerts_201403 OWNER TO postgres; -- -- Name: alerts_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201404 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.alerts) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.alerts_201404 OWNER TO postgres; -- -- Name: alerts_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201405 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.alerts); ALTER TABLE partitions.alerts_201405 OWNER TO postgres; -- -- Name: alerts_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE alerts_201406 ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0, CONSTRAINT alerts_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.alerts); ALTER TABLE partitions.alerts_201406 OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: auditlog; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.auditlog OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: auditlog_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201401 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.auditlog) WITH (autovacuum_enabled=false); ALTER TABLE partitions.auditlog_201401 OWNER TO postgres; -- -- Name: auditlog_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201402 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.auditlog) WITH (autovacuum_enabled=false); ALTER TABLE partitions.auditlog_201402 OWNER TO postgres; -- -- Name: auditlog_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201403 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.auditlog) WITH (autovacuum_enabled=false); ALTER TABLE partitions.auditlog_201403 OWNER TO postgres; -- -- Name: auditlog_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201404 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.auditlog) WITH (autovacuum_enabled=false); ALTER TABLE partitions.auditlog_201404 OWNER TO postgres; -- -- Name: auditlog_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201405 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.auditlog); ALTER TABLE partitions.auditlog_201405 OWNER TO postgres; -- -- Name: auditlog_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE auditlog_201406 ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying, CONSTRAINT auditlog_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.auditlog); ALTER TABLE partitions.auditlog_201406 OWNER TO postgres; -- -- Name: emergency_acknowledges; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_acknowledges ( acknowledgeid bigint, userid bigint, eventid bigint, clock integer DEFAULT 0, message character varying(255) DEFAULT ''::character varying ) INHERITS (public.acknowledges) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_acknowledges OWNER TO postgres; -- -- Name: emergency_alerts; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_alerts ( alertid bigint, actionid bigint, eventid bigint, userid bigint, clock integer DEFAULT 0, mediatypeid bigint, sendto character varying(100) DEFAULT ''::character varying, subject character varying(255) DEFAULT ''::character varying, message text DEFAULT ''::text, status integer DEFAULT 0, retries integer DEFAULT 0, error character varying(128) DEFAULT ''::character varying, esc_step integer DEFAULT 0, alerttype integer DEFAULT 0 ) INHERITS (public.alerts) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.emergency_alerts OWNER TO postgres; -- -- Name: emergency_auditlog; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_auditlog ( auditid bigint, userid bigint, clock integer DEFAULT 0, action integer DEFAULT 0, resourcetype integer DEFAULT 0, details character varying(128) DEFAULT '0'::character varying, ip character varying(39) DEFAULT ''::character varying, resourceid bigint DEFAULT 0::bigint, resourcename character varying(255) DEFAULT ''::character varying ) INHERITS (public.auditlog) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_auditlog OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: events; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.events OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_events; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_events ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0 ) INHERITS (public.events) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_events OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0 ) INHERITS (public.history) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_log; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE public.history_log OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_log; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_log ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0 ) INHERITS (public.history_log) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_log OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_str; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history_str OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_str; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_str ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0 ) INHERITS (public.history_str) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_str OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_str_sync; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history_str_sync OWNER TO postgres; -- -- Name: history_str_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: history_str_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE history_str_sync_id_seq OWNED BY history_str_sync.id; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_str_sync; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_str_sync ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0 ) INHERITS (public.history_str_sync) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_str_sync OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_sync; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history_sync OWNER TO postgres; -- -- Name: history_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: history_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE history_sync_id_seq OWNED BY history_sync.id; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_sync; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_sync ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0 ) INHERITS (public.history_sync) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_sync OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_text; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE public.history_text OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_text; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_text ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0 ) INHERITS (public.history_text) WITH (autovacuum_enabled=false, toast.autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_text OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_uint; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history_uint OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_uint; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_uint ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0 ) INHERITS (public.history_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_uint OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: history_uint_sync; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.history_uint_sync OWNER TO postgres; -- -- Name: history_uint_sync_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: history_uint_sync_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE history_uint_sync_id_seq OWNED BY history_uint_sync.id; SET search_path = partitions, pg_catalog; -- -- Name: emergency_history_uint_sync; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_history_uint_sync ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0 ) INHERITS (public.history_uint_sync) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_history_uint_sync OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: service_alarms; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.service_alarms OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_service_alarms; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_service_alarms ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0 ) INHERITS (public.service_alarms) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_service_alarms OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: trends; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.trends OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_trends; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_trends ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000 ) INHERITS (public.trends) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_trends OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: trends_uint; Type: TABLE; Schema: public; Owner: postgres; 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 ) WITH (autovacuum_enabled=false); ALTER TABLE public.trends_uint OWNER TO postgres; SET search_path = partitions, pg_catalog; -- -- Name: emergency_trends_uint; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE emergency_trends_uint ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric ) INHERITS (public.trends_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.emergency_trends_uint OWNER TO postgres; -- -- Name: events_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201401 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.events) WITH (autovacuum_enabled=false); ALTER TABLE partitions.events_201401 OWNER TO postgres; -- -- Name: events_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201402 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.events) WITH (autovacuum_enabled=false); ALTER TABLE partitions.events_201402 OWNER TO postgres; -- -- Name: events_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201403 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.events) WITH (autovacuum_enabled=false); ALTER TABLE partitions.events_201403 OWNER TO postgres; -- -- Name: events_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201404 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.events) WITH (autovacuum_enabled=false); ALTER TABLE partitions.events_201404 OWNER TO postgres; -- -- Name: events_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201405 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.events); ALTER TABLE partitions.events_201405 OWNER TO postgres; -- -- Name: events_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE events_201406 ( eventid bigint, source integer DEFAULT 0, object integer DEFAULT 0, objectid bigint DEFAULT 0::bigint, clock integer DEFAULT 0, value integer DEFAULT 0, acknowledged integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT events_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.events); ALTER TABLE partitions.events_201406 OWNER TO postgres; -- -- Name: history_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140521 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140521 OWNER TO postgres; -- -- Name: history_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140522 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140522 OWNER TO postgres; -- -- Name: history_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140523 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140523 OWNER TO postgres; -- -- Name: history_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140524 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140524 OWNER TO postgres; -- -- Name: history_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140525 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140525 OWNER TO postgres; -- -- Name: history_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140526 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140526 OWNER TO postgres; -- -- Name: history_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140527 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140527 OWNER TO postgres; -- -- Name: history_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140528 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140528 OWNER TO postgres; -- -- Name: history_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140529 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140529 OWNER TO postgres; -- -- Name: history_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140530 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140530 OWNER TO postgres; -- -- Name: history_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140531 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140531 OWNER TO postgres; -- -- Name: history_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140601 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140601 OWNER TO postgres; -- -- Name: history_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140602 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140602 OWNER TO postgres; -- -- Name: history_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140603 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140603 OWNER TO postgres; -- -- Name: history_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_20140604 ( itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history); ALTER TABLE partitions.history_20140604 OWNER TO postgres; -- -- Name: history_log_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140521 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140521 OWNER TO postgres; -- -- Name: history_log_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140522 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140522 OWNER TO postgres; -- -- Name: history_log_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140523 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140523 OWNER TO postgres; -- -- Name: history_log_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140524 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140524 OWNER TO postgres; -- -- Name: history_log_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140525 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140525 OWNER TO postgres; -- -- Name: history_log_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140526 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140526 OWNER TO postgres; -- -- Name: history_log_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140527 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140527 OWNER TO postgres; -- -- Name: history_log_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140528 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140528 OWNER TO postgres; -- -- Name: history_log_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140529 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140529 OWNER TO postgres; -- -- Name: history_log_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140530 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140530 OWNER TO postgres; -- -- Name: history_log_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140531 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140531 OWNER TO postgres; -- -- Name: history_log_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140601 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140601 OWNER TO postgres; -- -- Name: history_log_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140602 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140602 OWNER TO postgres; -- -- Name: history_log_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140603 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140603 OWNER TO postgres; -- -- Name: history_log_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_log_20140604 ( id bigint, itemid bigint, clock integer DEFAULT 0, "timestamp" integer DEFAULT 0, source character varying(64) DEFAULT ''::character varying, severity integer DEFAULT 0, value text DEFAULT ''::text, logeventid integer DEFAULT 0, ns integer DEFAULT 0, CONSTRAINT history_log_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_log); ALTER TABLE partitions.history_log_20140604 OWNER TO postgres; -- -- Name: history_str_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140521 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140521 OWNER TO postgres; -- -- Name: history_str_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140522 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140522 OWNER TO postgres; -- -- Name: history_str_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140523 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140523 OWNER TO postgres; -- -- Name: history_str_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140524 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140524 OWNER TO postgres; -- -- Name: history_str_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140525 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140525 OWNER TO postgres; -- -- Name: history_str_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140526 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140526 OWNER TO postgres; -- -- Name: history_str_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140527 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140527 OWNER TO postgres; -- -- Name: history_str_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140528 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140528 OWNER TO postgres; -- -- Name: history_str_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140529 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140529 OWNER TO postgres; -- -- Name: history_str_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140530 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140530 OWNER TO postgres; -- -- Name: history_str_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140531 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140531 OWNER TO postgres; -- -- Name: history_str_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140601 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140601 OWNER TO postgres; -- -- Name: history_str_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140602 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140602 OWNER TO postgres; -- -- Name: history_str_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140603 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140603 OWNER TO postgres; -- -- Name: history_str_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_20140604 ( itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_str); ALTER TABLE partitions.history_str_20140604 OWNER TO postgres; -- -- Name: history_str_sync_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140521 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140521 OWNER TO postgres; -- -- Name: history_str_sync_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140522 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140522 OWNER TO postgres; -- -- Name: history_str_sync_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140523 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140523 OWNER TO postgres; -- -- Name: history_str_sync_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140524 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140524 OWNER TO postgres; -- -- Name: history_str_sync_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140525 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140525 OWNER TO postgres; -- -- Name: history_str_sync_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140526 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140526 OWNER TO postgres; -- -- Name: history_str_sync_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140527 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140527 OWNER TO postgres; -- -- Name: history_str_sync_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140528 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140528 OWNER TO postgres; -- -- Name: history_str_sync_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140529 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140529 OWNER TO postgres; -- -- Name: history_str_sync_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140530 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140530 OWNER TO postgres; -- -- Name: history_str_sync_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140531 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140531 OWNER TO postgres; -- -- Name: history_str_sync_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140601 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140601 OWNER TO postgres; -- -- Name: history_str_sync_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140602 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140602 OWNER TO postgres; -- -- Name: history_str_sync_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140603 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140603 OWNER TO postgres; -- -- Name: history_str_sync_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_str_sync_20140604 ( id bigint DEFAULT nextval('public.history_str_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value character varying(255) DEFAULT ''::character varying, ns integer DEFAULT 0, CONSTRAINT history_str_sync_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_str_sync); ALTER TABLE partitions.history_str_sync_20140604 OWNER TO postgres; -- -- Name: history_sync_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140521 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140521 OWNER TO postgres; -- -- Name: history_sync_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140522 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140522 OWNER TO postgres; -- -- Name: history_sync_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140523 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140523 OWNER TO postgres; -- -- Name: history_sync_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140524 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140524 OWNER TO postgres; -- -- Name: history_sync_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140525 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140525 OWNER TO postgres; -- -- Name: history_sync_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140526 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140526 OWNER TO postgres; -- -- Name: history_sync_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140527 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140527 OWNER TO postgres; -- -- Name: history_sync_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140528 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140528 OWNER TO postgres; -- -- Name: history_sync_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140529 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140529 OWNER TO postgres; -- -- Name: history_sync_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140530 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140530 OWNER TO postgres; -- -- Name: history_sync_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140531 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140531 OWNER TO postgres; -- -- Name: history_sync_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140601 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140601 OWNER TO postgres; -- -- Name: history_sync_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140602 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140602 OWNER TO postgres; -- -- Name: history_sync_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140603 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140603 OWNER TO postgres; -- -- Name: history_sync_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_sync_20140604 ( id bigint DEFAULT nextval('public.history_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(16,4) DEFAULT 0.0000, ns integer DEFAULT 0, CONSTRAINT history_sync_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_sync); ALTER TABLE partitions.history_sync_20140604 OWNER TO postgres; -- -- Name: history_text_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140521 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140521 OWNER TO postgres; -- -- Name: history_text_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140522 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140522 OWNER TO postgres; -- -- Name: history_text_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140523 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140523 OWNER TO postgres; -- -- Name: history_text_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140524 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140524 OWNER TO postgres; -- -- Name: history_text_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140525 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140525 OWNER TO postgres; -- -- Name: history_text_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140526 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140526 OWNER TO postgres; -- -- Name: history_text_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140527 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140527 OWNER TO postgres; -- -- Name: history_text_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140528 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140528 OWNER TO postgres; -- -- Name: history_text_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140529 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140529 OWNER TO postgres; -- -- Name: history_text_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140530 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140530 OWNER TO postgres; -- -- Name: history_text_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140531 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140531 OWNER TO postgres; -- -- Name: history_text_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140601 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140601 OWNER TO postgres; -- -- Name: history_text_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140602 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140602 OWNER TO postgres; -- -- Name: history_text_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140603 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140603 OWNER TO postgres; -- -- Name: history_text_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_text_20140604 ( id bigint, itemid bigint, clock integer DEFAULT 0, value text DEFAULT ''::text, ns integer DEFAULT 0, CONSTRAINT history_text_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_text); ALTER TABLE partitions.history_text_20140604 OWNER TO postgres; -- -- Name: history_uint_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140521 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140521 OWNER TO postgres; -- -- Name: history_uint_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140522 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140522 OWNER TO postgres; -- -- Name: history_uint_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140523 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140523 OWNER TO postgres; -- -- Name: history_uint_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140524 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140524 OWNER TO postgres; -- -- Name: history_uint_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140525 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140525 OWNER TO postgres; -- -- Name: history_uint_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140526 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140526 OWNER TO postgres; -- -- Name: history_uint_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140527 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140527 OWNER TO postgres; -- -- Name: history_uint_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140528 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140528 OWNER TO postgres; -- -- Name: history_uint_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140529 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140529 OWNER TO postgres; -- -- Name: history_uint_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140530 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140530 OWNER TO postgres; -- -- Name: history_uint_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140531 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140531 OWNER TO postgres; -- -- Name: history_uint_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140601 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140601 OWNER TO postgres; -- -- Name: history_uint_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140602 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140602 OWNER TO postgres; -- -- Name: history_uint_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140603 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140603 OWNER TO postgres; -- -- Name: history_uint_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_20140604 ( itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_uint); ALTER TABLE partitions.history_uint_20140604 OWNER TO postgres; -- -- Name: history_uint_sync_20140521; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140521 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140521_clock_check CHECK (((clock >= 1400616000) AND (clock < 1400702400))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140521 OWNER TO postgres; -- -- Name: history_uint_sync_20140522; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140522 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140522_clock_check CHECK (((clock >= 1400702400) AND (clock < 1400788800))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140522 OWNER TO postgres; -- -- Name: history_uint_sync_20140523; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140523 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140523_clock_check CHECK (((clock >= 1400788800) AND (clock < 1400875200))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140523 OWNER TO postgres; -- -- Name: history_uint_sync_20140524; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140524 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140524_clock_check CHECK (((clock >= 1400875200) AND (clock < 1400961600))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140524 OWNER TO postgres; -- -- Name: history_uint_sync_20140525; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140525 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140525_clock_check CHECK (((clock >= 1400961600) AND (clock < 1401048000))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140525 OWNER TO postgres; -- -- Name: history_uint_sync_20140526; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140526 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140526_clock_check CHECK (((clock >= 1401048000) AND (clock < 1401134400))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140526 OWNER TO postgres; -- -- Name: history_uint_sync_20140527; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140527 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140527_clock_check CHECK (((clock >= 1401134400) AND (clock < 1401220800))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140527 OWNER TO postgres; -- -- Name: history_uint_sync_20140528; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140528 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140528_clock_check CHECK (((clock >= 1401220800) AND (clock < 1401307200))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140528 OWNER TO postgres; -- -- Name: history_uint_sync_20140529; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140529 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140529_clock_check CHECK (((clock >= 1401307200) AND (clock < 1401393600))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140529 OWNER TO postgres; -- -- Name: history_uint_sync_20140530; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140530 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140530_clock_check CHECK (((clock >= 1401393600) AND (clock < 1401480000))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140530 OWNER TO postgres; -- -- Name: history_uint_sync_20140531; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140531 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140531_clock_check CHECK (((clock >= 1401480000) AND (clock < 1401566400))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140531 OWNER TO postgres; -- -- Name: history_uint_sync_20140601; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140601 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140601_clock_check CHECK (((clock >= 1401566400) AND (clock < 1401652800))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140601 OWNER TO postgres; -- -- Name: history_uint_sync_20140602; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140602 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140602_clock_check CHECK (((clock >= 1401652800) AND (clock < 1401739200))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140602 OWNER TO postgres; -- -- Name: history_uint_sync_20140603; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140603 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140603_clock_check CHECK (((clock >= 1401739200) AND (clock < 1401825600))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140603 OWNER TO postgres; -- -- Name: history_uint_sync_20140604; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE history_uint_sync_20140604 ( id bigint DEFAULT nextval('public.history_uint_sync_id_seq'::regclass), nodeid integer, itemid bigint, clock integer DEFAULT 0, value numeric(20,0) DEFAULT 0::numeric, ns integer DEFAULT 0, CONSTRAINT history_uint_sync_20140604_clock_check CHECK (((clock >= 1401825600) AND (clock < 1401912000))) ) INHERITS (public.history_uint_sync); ALTER TABLE partitions.history_uint_sync_20140604 OWNER TO postgres; -- -- Name: service_alarms_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201401 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.service_alarms) WITH (autovacuum_enabled=false); ALTER TABLE partitions.service_alarms_201401 OWNER TO postgres; -- -- Name: service_alarms_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201402 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.service_alarms) WITH (autovacuum_enabled=false); ALTER TABLE partitions.service_alarms_201402 OWNER TO postgres; -- -- Name: service_alarms_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201403 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.service_alarms) WITH (autovacuum_enabled=false); ALTER TABLE partitions.service_alarms_201403 OWNER TO postgres; -- -- Name: service_alarms_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201404 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.service_alarms) WITH (autovacuum_enabled=false); ALTER TABLE partitions.service_alarms_201404 OWNER TO postgres; -- -- Name: service_alarms_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201405 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.service_alarms); ALTER TABLE partitions.service_alarms_201405 OWNER TO postgres; -- -- Name: service_alarms_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE service_alarms_201406 ( servicealarmid bigint, serviceid bigint, clock integer DEFAULT 0, value integer DEFAULT 0, CONSTRAINT service_alarms_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.service_alarms); ALTER TABLE partitions.service_alarms_201406 OWNER TO postgres; -- -- Name: trends_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201401 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.trends) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_201401 OWNER TO postgres; -- -- Name: trends_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201402 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.trends) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_201402 OWNER TO postgres; -- -- Name: trends_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201403 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.trends) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_201403 OWNER TO postgres; -- -- Name: trends_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201404 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.trends) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_201404 OWNER TO postgres; -- -- Name: trends_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201405 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.trends); ALTER TABLE partitions.trends_201405 OWNER TO postgres; -- -- Name: trends_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_201406 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(16,4) DEFAULT 0.0000, value_avg numeric(16,4) DEFAULT 0.0000, value_max numeric(16,4) DEFAULT 0.0000, CONSTRAINT trends_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.trends); ALTER TABLE partitions.trends_201406 OWNER TO postgres; -- -- Name: trends_uint_201401; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201401 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201401_clock_check CHECK (((clock >= 1388520000) AND (clock < 1391198400))) ) INHERITS (public.trends_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_uint_201401 OWNER TO postgres; -- -- Name: trends_uint_201402; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201402 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201402_clock_check CHECK (((clock >= 1391198400) AND (clock < 1393617600))) ) INHERITS (public.trends_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_uint_201402 OWNER TO postgres; -- -- Name: trends_uint_201403; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201403 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201403_clock_check CHECK (((clock >= 1393617600) AND (clock < 1396296000))) ) INHERITS (public.trends_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_uint_201403 OWNER TO postgres; -- -- Name: trends_uint_201404; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201404 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201404_clock_check CHECK (((clock >= 1396296000) AND (clock < 1398888000))) ) INHERITS (public.trends_uint) WITH (autovacuum_enabled=false); ALTER TABLE partitions.trends_uint_201404 OWNER TO postgres; -- -- Name: trends_uint_201405; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201405 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201405_clock_check CHECK (((clock >= 1398888000) AND (clock < 1401566400))) ) INHERITS (public.trends_uint); ALTER TABLE partitions.trends_uint_201405 OWNER TO postgres; -- -- Name: trends_uint_201406; Type: TABLE; Schema: partitions; Owner: postgres; Tablespace: -- CREATE TABLE trends_uint_201406 ( itemid bigint, clock integer DEFAULT 0, num integer DEFAULT 0, value_min numeric(20,0) DEFAULT 0::numeric, value_avg numeric(20,0) DEFAULT 0::numeric, value_max numeric(20,0) DEFAULT 0::numeric, CONSTRAINT trends_uint_201406_clock_check CHECK (((clock >= 1401566400) AND (clock < 1404158400))) ) INHERITS (public.trends_uint); ALTER TABLE partitions.trends_uint_201406 OWNER TO postgres; SET search_path = public, pg_catalog; -- -- Name: actions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: application_template; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: applications; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: auditlog_details; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: autoreg_host; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: conditions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: config; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: dbversion; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE dbversion ( mandatory integer DEFAULT 0 NOT NULL, optional integer DEFAULT 0 NOT NULL ); ALTER TABLE public.dbversion OWNER TO postgres; -- -- Name: dchecks; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: dhosts; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: drules; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: dservices; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: escalations; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: expressions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: functions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: globalmacro; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: globalvars; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE globalvars ( globalvarid bigint NOT NULL, snmp_lastsize integer DEFAULT 0 NOT NULL ); ALTER TABLE public.globalvars OWNER TO postgres; -- -- Name: graph_discovery; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: graph_theme; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: graphs; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: graphs_items; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: group_discovery; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: group_prototype; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: groups; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: host_discovery; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: host_inventory; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: hostmacro; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE hostmacro ( hostmacroid bigint 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 postgres; -- -- Name: hosts; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: hosts_groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE hosts_groups ( hostgroupid bigint NOT NULL, hostid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.hosts_groups OWNER TO postgres; -- -- Name: hosts_templates; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE hosts_templates ( hosttemplateid bigint NOT NULL, hostid bigint NOT NULL, templateid bigint NOT NULL ); ALTER TABLE public.hosts_templates OWNER TO postgres; -- -- Name: housekeeper; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: httpstep; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: httpstepitem; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: httptest; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: httptestitem; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: icon_map; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: icon_mapping; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: ids; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: images; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: interface; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE interface ( interfaceid bigint 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 postgres; -- -- Name: interface_discovery; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE interface_discovery ( interfaceid bigint NOT NULL, parent_interfaceid bigint NOT NULL ); ALTER TABLE public.interface_discovery OWNER TO postgres; -- -- Name: item_discovery; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: items; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: items_applications; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE items_applications ( itemappid bigint NOT NULL, applicationid bigint NOT NULL, itemid bigint NOT NULL ); ALTER TABLE public.items_applications OWNER TO postgres; -- -- Name: maintenances; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: maintenances_groups; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: maintenances_hosts; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: maintenances_windows; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: mappings; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: media; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: media_type; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: node_cksum; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: nodes; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opcommand; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opcommand_grp; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opcommand_hst; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE opcommand_hst ( opcommand_hstid bigint NOT NULL, operationid bigint NOT NULL, hostid bigint ); ALTER TABLE public.opcommand_hst OWNER TO postgres; -- -- Name: opconditions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: operations; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opgroup; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE opgroup ( opgroupid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL ); ALTER TABLE public.opgroup OWNER TO postgres; -- -- Name: opmessage; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opmessage_grp; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: opmessage_usr; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: optemplate; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE optemplate ( optemplateid bigint NOT NULL, operationid bigint NOT NULL, templateid bigint NOT NULL ); ALTER TABLE public.optemplate OWNER TO postgres; -- -- Name: profiles; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: proxy_autoreg_host; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: proxy_autoreg_host_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: proxy_autoreg_host_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE proxy_autoreg_host_id_seq OWNED BY proxy_autoreg_host.id; -- -- Name: proxy_dhistory; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: proxy_dhistory_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: proxy_dhistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE proxy_dhistory_id_seq OWNED BY proxy_dhistory.id; -- -- Name: proxy_history; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: proxy_history_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- 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 postgres; -- -- Name: proxy_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE proxy_history_id_seq OWNED BY proxy_history.id; -- -- Name: regexps; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: rights; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: screens; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: screens_items; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: scripts; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: services; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: services_links; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: services_times; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: slides; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: slideshows; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmap_element_url; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmap_url; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmaps; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmaps_elements; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmaps_link_triggers; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: sysmaps_links; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: timeperiods; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: tpl_acknowledges; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_acknowledges OWNER TO postgres; -- -- Name: tpl_alerts; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_alerts OWNER TO postgres; -- -- Name: tpl_auditlog; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_auditlog OWNER TO postgres; -- -- Name: tpl_events; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_events OWNER TO postgres; -- -- Name: tpl_history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_history OWNER TO postgres; -- -- Name: tpl_history_log; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_history_log OWNER TO postgres; -- -- Name: tpl_history_str; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_history_str OWNER TO postgres; -- -- Name: tpl_history_str_sync; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_history_str_sync ( id bigint DEFAULT nextval('history_str_sync_id_seq'::regclass) 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.tpl_history_str_sync OWNER TO postgres; -- -- Name: tpl_history_sync; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_history_sync ( id bigint DEFAULT nextval('history_sync_id_seq'::regclass) 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.tpl_history_sync OWNER TO postgres; -- -- Name: tpl_history_text; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_history_text OWNER TO postgres; -- -- Name: tpl_history_uint; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_history_uint OWNER TO postgres; -- -- Name: tpl_history_uint_sync; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_history_uint_sync ( id bigint DEFAULT nextval('history_uint_sync_id_seq'::regclass) 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.tpl_history_uint_sync OWNER TO postgres; -- -- Name: tpl_service_alarms; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_service_alarms OWNER TO postgres; -- -- Name: tpl_trends; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_trends OWNER TO postgres; -- -- Name: tpl_trends_uint; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE tpl_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.tpl_trends_uint OWNER TO postgres; -- -- Name: trigger_depends; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: trigger_discovery; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: triggers; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: user_history; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: users; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: users_groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE users_groups ( id bigint NOT NULL, usrgrpid bigint NOT NULL, userid bigint NOT NULL ); ALTER TABLE public.users_groups OWNER TO postgres; -- -- Name: usrgrp; Type: TABLE; Schema: public; Owner: postgres; 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 postgres; -- -- Name: valuemaps; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE valuemaps ( valuemapid bigint NOT NULL, name character varying(64) DEFAULT ''::character varying NOT NULL ); ALTER TABLE public.valuemaps OWNER TO postgres; -- -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres -- 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: postgres -- ALTER TABLE ONLY history_sync ALTER COLUMN id SET DEFAULT nextval('history_sync_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres -- 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: postgres -- 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: postgres -- ALTER TABLE ONLY proxy_dhistory ALTER COLUMN id SET DEFAULT nextval('proxy_dhistory_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY proxy_history ALTER COLUMN id SET DEFAULT nextval('proxy_history_id_seq'::regclass); SET search_path = partitions, pg_catalog; -- -- Name: acknowledges_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201401 ADD CONSTRAINT acknowledges_201401_pkey PRIMARY KEY (acknowledgeid); -- -- Name: acknowledges_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201402 ADD CONSTRAINT acknowledges_201402_pkey PRIMARY KEY (acknowledgeid); -- -- Name: acknowledges_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201403 ADD CONSTRAINT acknowledges_201403_pkey PRIMARY KEY (acknowledgeid); -- -- Name: acknowledges_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201404 ADD CONSTRAINT acknowledges_201404_pkey PRIMARY KEY (acknowledgeid); -- -- Name: acknowledges_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201405 ADD CONSTRAINT acknowledges_201405_pkey PRIMARY KEY (acknowledgeid); -- -- Name: acknowledges_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY acknowledges_201406 ADD CONSTRAINT acknowledges_201406_pkey PRIMARY KEY (acknowledgeid); -- -- Name: alerts_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201401 ADD CONSTRAINT alerts_201401_pkey PRIMARY KEY (alertid); -- -- Name: alerts_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201402 ADD CONSTRAINT alerts_201402_pkey PRIMARY KEY (alertid); -- -- Name: alerts_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201403 ADD CONSTRAINT alerts_201403_pkey PRIMARY KEY (alertid); -- -- Name: alerts_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201404 ADD CONSTRAINT alerts_201404_pkey PRIMARY KEY (alertid); -- -- Name: alerts_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201405 ADD CONSTRAINT alerts_201405_pkey PRIMARY KEY (alertid); -- -- Name: alerts_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY alerts_201406 ADD CONSTRAINT alerts_201406_pkey PRIMARY KEY (alertid); -- -- Name: auditlog_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201401 ADD CONSTRAINT auditlog_201401_pkey PRIMARY KEY (auditid); -- -- Name: auditlog_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201402 ADD CONSTRAINT auditlog_201402_pkey PRIMARY KEY (auditid); -- -- Name: auditlog_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201403 ADD CONSTRAINT auditlog_201403_pkey PRIMARY KEY (auditid); -- -- Name: auditlog_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201404 ADD CONSTRAINT auditlog_201404_pkey PRIMARY KEY (auditid); -- -- Name: auditlog_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201405 ADD CONSTRAINT auditlog_201405_pkey PRIMARY KEY (auditid); -- -- Name: auditlog_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_201406 ADD CONSTRAINT auditlog_201406_pkey PRIMARY KEY (auditid); -- -- Name: events_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201401 ADD CONSTRAINT events_201401_pkey PRIMARY KEY (eventid); -- -- Name: events_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201402 ADD CONSTRAINT events_201402_pkey PRIMARY KEY (eventid); -- -- Name: events_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201403 ADD CONSTRAINT events_201403_pkey PRIMARY KEY (eventid); -- -- Name: events_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201404 ADD CONSTRAINT events_201404_pkey PRIMARY KEY (eventid); -- -- Name: events_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201405 ADD CONSTRAINT events_201405_pkey PRIMARY KEY (eventid); -- -- Name: events_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY events_201406 ADD CONSTRAINT events_201406_pkey PRIMARY KEY (eventid); -- -- Name: history_log_20140521_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140521 ADD CONSTRAINT history_log_20140521_pkey PRIMARY KEY (id); -- -- Name: history_log_20140522_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140522 ADD CONSTRAINT history_log_20140522_pkey PRIMARY KEY (id); -- -- Name: history_log_20140523_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140523 ADD CONSTRAINT history_log_20140523_pkey PRIMARY KEY (id); -- -- Name: history_log_20140524_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140524 ADD CONSTRAINT history_log_20140524_pkey PRIMARY KEY (id); -- -- Name: history_log_20140525_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140525 ADD CONSTRAINT history_log_20140525_pkey PRIMARY KEY (id); -- -- Name: history_log_20140526_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140526 ADD CONSTRAINT history_log_20140526_pkey PRIMARY KEY (id); -- -- Name: history_log_20140527_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140527 ADD CONSTRAINT history_log_20140527_pkey PRIMARY KEY (id); -- -- Name: history_log_20140528_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140528 ADD CONSTRAINT history_log_20140528_pkey PRIMARY KEY (id); -- -- Name: history_log_20140529_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140529 ADD CONSTRAINT history_log_20140529_pkey PRIMARY KEY (id); -- -- Name: history_log_20140530_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140530 ADD CONSTRAINT history_log_20140530_pkey PRIMARY KEY (id); -- -- Name: history_log_20140531_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140531 ADD CONSTRAINT history_log_20140531_pkey PRIMARY KEY (id); -- -- Name: history_log_20140601_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140601 ADD CONSTRAINT history_log_20140601_pkey PRIMARY KEY (id); -- -- Name: history_log_20140602_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140602 ADD CONSTRAINT history_log_20140602_pkey PRIMARY KEY (id); -- -- Name: history_log_20140603_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140603 ADD CONSTRAINT history_log_20140603_pkey PRIMARY KEY (id); -- -- Name: history_log_20140604_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_log_20140604 ADD CONSTRAINT history_log_20140604_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140521_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140521 ADD CONSTRAINT history_str_sync_20140521_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140522_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140522 ADD CONSTRAINT history_str_sync_20140522_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140523_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140523 ADD CONSTRAINT history_str_sync_20140523_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140524_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140524 ADD CONSTRAINT history_str_sync_20140524_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140525_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140525 ADD CONSTRAINT history_str_sync_20140525_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140526_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140526 ADD CONSTRAINT history_str_sync_20140526_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140527_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140527 ADD CONSTRAINT history_str_sync_20140527_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140528_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140528 ADD CONSTRAINT history_str_sync_20140528_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140529_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140529 ADD CONSTRAINT history_str_sync_20140529_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140530_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140530 ADD CONSTRAINT history_str_sync_20140530_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140531_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140531 ADD CONSTRAINT history_str_sync_20140531_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140601_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140601 ADD CONSTRAINT history_str_sync_20140601_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140602_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140602 ADD CONSTRAINT history_str_sync_20140602_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140603_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140603 ADD CONSTRAINT history_str_sync_20140603_pkey PRIMARY KEY (id); -- -- Name: history_str_sync_20140604_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_str_sync_20140604 ADD CONSTRAINT history_str_sync_20140604_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140521_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140521 ADD CONSTRAINT history_sync_20140521_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140522_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140522 ADD CONSTRAINT history_sync_20140522_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140523_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140523 ADD CONSTRAINT history_sync_20140523_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140524_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140524 ADD CONSTRAINT history_sync_20140524_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140525_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140525 ADD CONSTRAINT history_sync_20140525_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140526_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140526 ADD CONSTRAINT history_sync_20140526_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140527_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140527 ADD CONSTRAINT history_sync_20140527_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140528_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140528 ADD CONSTRAINT history_sync_20140528_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140529_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140529 ADD CONSTRAINT history_sync_20140529_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140530_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140530 ADD CONSTRAINT history_sync_20140530_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140531_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140531 ADD CONSTRAINT history_sync_20140531_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140601_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140601 ADD CONSTRAINT history_sync_20140601_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140602_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140602 ADD CONSTRAINT history_sync_20140602_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140603_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140603 ADD CONSTRAINT history_sync_20140603_pkey PRIMARY KEY (id); -- -- Name: history_sync_20140604_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_sync_20140604 ADD CONSTRAINT history_sync_20140604_pkey PRIMARY KEY (id); -- -- Name: history_text_20140521_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140521 ADD CONSTRAINT history_text_20140521_pkey PRIMARY KEY (id); -- -- Name: history_text_20140522_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140522 ADD CONSTRAINT history_text_20140522_pkey PRIMARY KEY (id); -- -- Name: history_text_20140523_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140523 ADD CONSTRAINT history_text_20140523_pkey PRIMARY KEY (id); -- -- Name: history_text_20140524_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140524 ADD CONSTRAINT history_text_20140524_pkey PRIMARY KEY (id); -- -- Name: history_text_20140525_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140525 ADD CONSTRAINT history_text_20140525_pkey PRIMARY KEY (id); -- -- Name: history_text_20140526_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140526 ADD CONSTRAINT history_text_20140526_pkey PRIMARY KEY (id); -- -- Name: history_text_20140527_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140527 ADD CONSTRAINT history_text_20140527_pkey PRIMARY KEY (id); -- -- Name: history_text_20140528_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140528 ADD CONSTRAINT history_text_20140528_pkey PRIMARY KEY (id); -- -- Name: history_text_20140529_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140529 ADD CONSTRAINT history_text_20140529_pkey PRIMARY KEY (id); -- -- Name: history_text_20140530_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140530 ADD CONSTRAINT history_text_20140530_pkey PRIMARY KEY (id); -- -- Name: history_text_20140531_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140531 ADD CONSTRAINT history_text_20140531_pkey PRIMARY KEY (id); -- -- Name: history_text_20140601_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140601 ADD CONSTRAINT history_text_20140601_pkey PRIMARY KEY (id); -- -- Name: history_text_20140602_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140602 ADD CONSTRAINT history_text_20140602_pkey PRIMARY KEY (id); -- -- Name: history_text_20140603_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140603 ADD CONSTRAINT history_text_20140603_pkey PRIMARY KEY (id); -- -- Name: history_text_20140604_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_text_20140604 ADD CONSTRAINT history_text_20140604_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140521_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140521 ADD CONSTRAINT history_uint_sync_20140521_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140522_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140522 ADD CONSTRAINT history_uint_sync_20140522_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140523_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140523 ADD CONSTRAINT history_uint_sync_20140523_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140524_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140524 ADD CONSTRAINT history_uint_sync_20140524_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140525_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140525 ADD CONSTRAINT history_uint_sync_20140525_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140526_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140526 ADD CONSTRAINT history_uint_sync_20140526_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140527_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140527 ADD CONSTRAINT history_uint_sync_20140527_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140528_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140528 ADD CONSTRAINT history_uint_sync_20140528_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140529_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140529 ADD CONSTRAINT history_uint_sync_20140529_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140530_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140530 ADD CONSTRAINT history_uint_sync_20140530_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140531_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140531 ADD CONSTRAINT history_uint_sync_20140531_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140601_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140601 ADD CONSTRAINT history_uint_sync_20140601_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140602_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140602 ADD CONSTRAINT history_uint_sync_20140602_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140603_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140603 ADD CONSTRAINT history_uint_sync_20140603_pkey PRIMARY KEY (id); -- -- Name: history_uint_sync_20140604_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY history_uint_sync_20140604 ADD CONSTRAINT history_uint_sync_20140604_pkey PRIMARY KEY (id); -- -- Name: service_alarms_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201401 ADD CONSTRAINT service_alarms_201401_pkey PRIMARY KEY (servicealarmid); -- -- Name: service_alarms_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201402 ADD CONSTRAINT service_alarms_201402_pkey PRIMARY KEY (servicealarmid); -- -- Name: service_alarms_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201403 ADD CONSTRAINT service_alarms_201403_pkey PRIMARY KEY (servicealarmid); -- -- Name: service_alarms_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201404 ADD CONSTRAINT service_alarms_201404_pkey PRIMARY KEY (servicealarmid); -- -- Name: service_alarms_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201405 ADD CONSTRAINT service_alarms_201405_pkey PRIMARY KEY (servicealarmid); -- -- Name: service_alarms_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY service_alarms_201406 ADD CONSTRAINT service_alarms_201406_pkey PRIMARY KEY (servicealarmid); -- -- Name: trends_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201401 ADD CONSTRAINT trends_201401_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201402 ADD CONSTRAINT trends_201402_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201403 ADD CONSTRAINT trends_201403_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201404 ADD CONSTRAINT trends_201404_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201405 ADD CONSTRAINT trends_201405_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_201406 ADD CONSTRAINT trends_201406_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201401_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201401 ADD CONSTRAINT trends_uint_201401_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201402_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201402 ADD CONSTRAINT trends_uint_201402_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201403_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201403 ADD CONSTRAINT trends_uint_201403_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201404_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201404 ADD CONSTRAINT trends_uint_201404_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201405_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201405 ADD CONSTRAINT trends_uint_201405_pkey PRIMARY KEY (itemid, clock); -- -- Name: trends_uint_201406_pkey; Type: CONSTRAINT; Schema: partitions; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trends_uint_201406 ADD CONSTRAINT trends_uint_201406_pkey PRIMARY KEY (itemid, clock); SET search_path = public, pg_catalog; -- -- Name: actions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY actions ADD CONSTRAINT actions_pkey PRIMARY KEY (actionid); -- -- Name: application_template_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY application_template ADD CONSTRAINT application_template_pkey PRIMARY KEY (application_templateid); -- -- Name: applications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY applications ADD CONSTRAINT applications_pkey PRIMARY KEY (applicationid); -- -- Name: auditlog_details_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY auditlog_details ADD CONSTRAINT auditlog_details_pkey PRIMARY KEY (auditdetailid); -- -- Name: autoreg_host_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY autoreg_host ADD CONSTRAINT autoreg_host_pkey PRIMARY KEY (autoreg_hostid); -- -- Name: conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY conditions ADD CONSTRAINT conditions_pkey PRIMARY KEY (conditionid); -- -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY config ADD CONSTRAINT config_pkey PRIMARY KEY (configid); -- -- Name: dchecks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY dchecks ADD CONSTRAINT dchecks_pkey PRIMARY KEY (dcheckid); -- -- Name: dhosts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY dhosts ADD CONSTRAINT dhosts_pkey PRIMARY KEY (dhostid); -- -- Name: drules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY drules ADD CONSTRAINT drules_pkey PRIMARY KEY (druleid); -- -- Name: dservices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY dservices ADD CONSTRAINT dservices_pkey PRIMARY KEY (dserviceid); -- -- Name: escalations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY escalations ADD CONSTRAINT escalations_pkey PRIMARY KEY (escalationid); -- -- Name: expressions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY expressions ADD CONSTRAINT expressions_pkey PRIMARY KEY (expressionid); -- -- Name: functions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY functions ADD CONSTRAINT functions_pkey PRIMARY KEY (functionid); -- -- Name: globalmacro_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY globalmacro ADD CONSTRAINT globalmacro_pkey PRIMARY KEY (globalmacroid); -- -- Name: globalvars_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY globalvars ADD CONSTRAINT globalvars_pkey PRIMARY KEY (globalvarid); -- -- Name: graph_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY graph_discovery ADD CONSTRAINT graph_discovery_pkey PRIMARY KEY (graphdiscoveryid); -- -- Name: graph_theme_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY graph_theme ADD CONSTRAINT graph_theme_pkey PRIMARY KEY (graphthemeid); -- -- Name: graphs_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY graphs_items ADD CONSTRAINT graphs_items_pkey PRIMARY KEY (gitemid); -- -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY graphs ADD CONSTRAINT graphs_pkey PRIMARY KEY (graphid); -- -- Name: group_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY group_discovery ADD CONSTRAINT group_discovery_pkey PRIMARY KEY (groupid); -- -- Name: group_prototype_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY group_prototype ADD CONSTRAINT group_prototype_pkey PRIMARY KEY (group_prototypeid); -- -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY groups ADD CONSTRAINT groups_pkey PRIMARY KEY (groupid); -- -- Name: host_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY host_discovery ADD CONSTRAINT host_discovery_pkey PRIMARY KEY (hostid); -- -- Name: host_inventory_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY host_inventory ADD CONSTRAINT host_inventory_pkey PRIMARY KEY (hostid); -- -- Name: hostmacro_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY hostmacro ADD CONSTRAINT hostmacro_pkey PRIMARY KEY (hostmacroid); -- -- Name: hosts_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY hosts_groups ADD CONSTRAINT hosts_groups_pkey PRIMARY KEY (hostgroupid); -- -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY hosts ADD CONSTRAINT hosts_pkey PRIMARY KEY (hostid); -- -- Name: hosts_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY hosts_templates ADD CONSTRAINT hosts_templates_pkey PRIMARY KEY (hosttemplateid); -- -- Name: housekeeper_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY housekeeper ADD CONSTRAINT housekeeper_pkey PRIMARY KEY (housekeeperid); -- -- Name: httpstep_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY httpstep ADD CONSTRAINT httpstep_pkey PRIMARY KEY (httpstepid); -- -- Name: httpstepitem_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY httpstepitem ADD CONSTRAINT httpstepitem_pkey PRIMARY KEY (httpstepitemid); -- -- Name: httptest_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY httptest ADD CONSTRAINT httptest_pkey PRIMARY KEY (httptestid); -- -- Name: httptestitem_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY httptestitem ADD CONSTRAINT httptestitem_pkey PRIMARY KEY (httptestitemid); -- -- Name: icon_map_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY icon_map ADD CONSTRAINT icon_map_pkey PRIMARY KEY (iconmapid); -- -- Name: icon_mapping_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY icon_mapping ADD CONSTRAINT icon_mapping_pkey PRIMARY KEY (iconmappingid); -- -- Name: ids_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY ids ADD CONSTRAINT ids_pkey PRIMARY KEY (nodeid, table_name, field_name); -- -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY images ADD CONSTRAINT images_pkey PRIMARY KEY (imageid); -- -- Name: interface_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY interface_discovery ADD CONSTRAINT interface_discovery_pkey PRIMARY KEY (interfaceid); -- -- Name: interface_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY interface ADD CONSTRAINT interface_pkey PRIMARY KEY (interfaceid); -- -- Name: item_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY item_discovery ADD CONSTRAINT item_discovery_pkey PRIMARY KEY (itemdiscoveryid); -- -- Name: items_applications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY items_applications ADD CONSTRAINT items_applications_pkey PRIMARY KEY (itemappid); -- -- Name: items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY items ADD CONSTRAINT items_pkey PRIMARY KEY (itemid); -- -- Name: maintenances_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT maintenances_groups_pkey PRIMARY KEY (maintenance_groupid); -- -- Name: maintenances_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT maintenances_hosts_pkey PRIMARY KEY (maintenance_hostid); -- -- Name: maintenances_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY maintenances ADD CONSTRAINT maintenances_pkey PRIMARY KEY (maintenanceid); -- -- Name: maintenances_windows_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT maintenances_windows_pkey PRIMARY KEY (maintenance_timeperiodid); -- -- Name: mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY mappings ADD CONSTRAINT mappings_pkey PRIMARY KEY (mappingid); -- -- Name: media_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY media ADD CONSTRAINT media_pkey PRIMARY KEY (mediaid); -- -- Name: media_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY media_type ADD CONSTRAINT media_type_pkey PRIMARY KEY (mediatypeid); -- -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY nodes ADD CONSTRAINT nodes_pkey PRIMARY KEY (nodeid); -- -- Name: opcommand_grp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT opcommand_grp_pkey PRIMARY KEY (opcommand_grpid); -- -- Name: opcommand_hst_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT opcommand_hst_pkey PRIMARY KEY (opcommand_hstid); -- -- Name: opcommand_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opcommand ADD CONSTRAINT opcommand_pkey PRIMARY KEY (operationid); -- -- Name: opconditions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opconditions ADD CONSTRAINT opconditions_pkey PRIMARY KEY (opconditionid); -- -- Name: operations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY operations ADD CONSTRAINT operations_pkey PRIMARY KEY (operationid); -- -- Name: opgroup_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opgroup ADD CONSTRAINT opgroup_pkey PRIMARY KEY (opgroupid); -- -- Name: opmessage_grp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT opmessage_grp_pkey PRIMARY KEY (opmessage_grpid); -- -- Name: opmessage_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opmessage ADD CONSTRAINT opmessage_pkey PRIMARY KEY (operationid); -- -- Name: opmessage_usr_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT opmessage_usr_pkey PRIMARY KEY (opmessage_usrid); -- -- Name: optemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY optemplate ADD CONSTRAINT optemplate_pkey PRIMARY KEY (optemplateid); -- -- Name: profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY profiles ADD CONSTRAINT profiles_pkey PRIMARY KEY (profileid); -- -- Name: proxy_autoreg_host_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- ALTER TABLE ONLY proxy_dhistory ADD CONSTRAINT proxy_dhistory_pkey PRIMARY KEY (id); -- -- Name: proxy_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY proxy_history ADD CONSTRAINT proxy_history_pkey PRIMARY KEY (id); -- -- Name: regexps_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY regexps ADD CONSTRAINT regexps_pkey PRIMARY KEY (regexpid); -- -- Name: rights_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY rights ADD CONSTRAINT rights_pkey PRIMARY KEY (rightid); -- -- Name: screens_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY screens_items ADD CONSTRAINT screens_items_pkey PRIMARY KEY (screenitemid); -- -- Name: screens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY screens ADD CONSTRAINT screens_pkey PRIMARY KEY (screenid); -- -- Name: scripts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY scripts ADD CONSTRAINT scripts_pkey PRIMARY KEY (scriptid); -- -- Name: services_links_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY services_links ADD CONSTRAINT services_links_pkey PRIMARY KEY (linkid); -- -- Name: services_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY services ADD CONSTRAINT services_pkey PRIMARY KEY (serviceid); -- -- Name: services_times_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY services_times ADD CONSTRAINT services_times_pkey PRIMARY KEY (timeid); -- -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (sessionid); -- -- Name: slides_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY slides ADD CONSTRAINT slides_pkey PRIMARY KEY (slideid); -- -- Name: slideshows_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY slideshows ADD CONSTRAINT slideshows_pkey PRIMARY KEY (slideshowid); -- -- Name: sysmap_element_url_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- ALTER TABLE ONLY sysmap_url ADD CONSTRAINT sysmap_url_pkey PRIMARY KEY (sysmapurlid); -- -- Name: sysmaps_elements_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT sysmaps_elements_pkey PRIMARY KEY (selementid); -- -- Name: sysmaps_link_triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT sysmaps_links_pkey PRIMARY KEY (linkid); -- -- Name: sysmaps_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY sysmaps ADD CONSTRAINT sysmaps_pkey PRIMARY KEY (sysmapid); -- -- Name: timeperiods_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY timeperiods ADD CONSTRAINT timeperiods_pkey PRIMARY KEY (timeperiodid); -- -- Name: tpl_acknowledges_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_acknowledges ADD CONSTRAINT tpl_acknowledges_pkey PRIMARY KEY (acknowledgeid); -- -- Name: tpl_alerts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_alerts ADD CONSTRAINT tpl_alerts_pkey PRIMARY KEY (alertid); -- -- Name: tpl_auditlog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_auditlog ADD CONSTRAINT tpl_auditlog_pkey PRIMARY KEY (auditid); -- -- Name: tpl_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_events ADD CONSTRAINT tpl_events_pkey PRIMARY KEY (eventid); -- -- Name: tpl_history_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_history_log ADD CONSTRAINT tpl_history_log_pkey PRIMARY KEY (id); -- -- Name: tpl_history_str_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_history_str_sync ADD CONSTRAINT tpl_history_str_sync_pkey PRIMARY KEY (id); -- -- Name: tpl_history_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_history_sync ADD CONSTRAINT tpl_history_sync_pkey PRIMARY KEY (id); -- -- Name: tpl_history_text_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_history_text ADD CONSTRAINT tpl_history_text_pkey PRIMARY KEY (id); -- -- Name: tpl_history_uint_sync_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_history_uint_sync ADD CONSTRAINT tpl_history_uint_sync_pkey PRIMARY KEY (id); -- -- Name: tpl_service_alarms_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_service_alarms ADD CONSTRAINT tpl_service_alarms_pkey PRIMARY KEY (servicealarmid); -- -- Name: tpl_trends_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_trends ADD CONSTRAINT tpl_trends_pkey PRIMARY KEY (itemid, clock); -- -- Name: tpl_trends_uint_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY tpl_trends_uint ADD CONSTRAINT tpl_trends_uint_pkey PRIMARY KEY (itemid, clock); -- -- Name: trigger_depends_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trigger_depends ADD CONSTRAINT trigger_depends_pkey PRIMARY KEY (triggerdepid); -- -- Name: trigger_discovery_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT trigger_discovery_pkey PRIMARY KEY (triggerdiscoveryid); -- -- Name: triggers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY triggers ADD CONSTRAINT triggers_pkey PRIMARY KEY (triggerid); -- -- Name: user_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY user_history ADD CONSTRAINT user_history_pkey PRIMARY KEY (userhistoryid); -- -- Name: users_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY users_groups ADD CONSTRAINT users_groups_pkey PRIMARY KEY (id); -- -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY users ADD CONSTRAINT users_pkey PRIMARY KEY (userid); -- -- Name: usrgrp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY usrgrp ADD CONSTRAINT usrgrp_pkey PRIMARY KEY (usrgrpid); -- -- Name: valuemaps_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY valuemaps ADD CONSTRAINT valuemaps_pkey PRIMARY KEY (valuemapid); SET search_path = partitions, pg_catalog; -- -- Name: acknowledges_201401_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201401_clock_idx ON acknowledges_201401 USING btree (clock); -- -- Name: acknowledges_201401_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201401_eventid_idx ON acknowledges_201401 USING btree (eventid); -- -- Name: acknowledges_201401_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201401_userid_idx ON acknowledges_201401 USING btree (userid); -- -- Name: acknowledges_201402_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201402_clock_idx ON acknowledges_201402 USING btree (clock); -- -- Name: acknowledges_201402_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201402_eventid_idx ON acknowledges_201402 USING btree (eventid); -- -- Name: acknowledges_201402_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201402_userid_idx ON acknowledges_201402 USING btree (userid); -- -- Name: acknowledges_201403_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201403_clock_idx ON acknowledges_201403 USING btree (clock); -- -- Name: acknowledges_201403_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201403_eventid_idx ON acknowledges_201403 USING btree (eventid); -- -- Name: acknowledges_201403_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201403_userid_idx ON acknowledges_201403 USING btree (userid); -- -- Name: acknowledges_201404_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201404_clock_idx ON acknowledges_201404 USING btree (clock); -- -- Name: acknowledges_201404_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201404_eventid_idx ON acknowledges_201404 USING btree (eventid); -- -- Name: acknowledges_201404_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201404_userid_idx ON acknowledges_201404 USING btree (userid); -- -- Name: acknowledges_201405_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201405_clock_idx ON acknowledges_201405 USING btree (clock); -- -- Name: acknowledges_201405_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201405_eventid_idx ON acknowledges_201405 USING btree (eventid); -- -- Name: acknowledges_201405_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201405_userid_idx ON acknowledges_201405 USING btree (userid); -- -- Name: acknowledges_201406_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201406_clock_idx ON acknowledges_201406 USING btree (clock); -- -- Name: acknowledges_201406_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201406_eventid_idx ON acknowledges_201406 USING btree (eventid); -- -- Name: acknowledges_201406_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX acknowledges_201406_userid_idx ON acknowledges_201406 USING btree (userid); -- -- Name: alerts_201401_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_actionid_idx ON alerts_201401 USING btree (actionid); -- -- Name: alerts_201401_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_clock_idx ON alerts_201401 USING btree (clock); -- -- Name: alerts_201401_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_eventid_idx ON alerts_201401 USING btree (eventid); -- -- Name: alerts_201401_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_mediatypeid_idx ON alerts_201401 USING btree (mediatypeid); -- -- Name: alerts_201401_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_status_retries_idx ON alerts_201401 USING btree (status, retries); -- -- Name: alerts_201401_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201401_userid_idx ON alerts_201401 USING btree (userid); -- -- Name: alerts_201402_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_actionid_idx ON alerts_201402 USING btree (actionid); -- -- Name: alerts_201402_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_clock_idx ON alerts_201402 USING btree (clock); -- -- Name: alerts_201402_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_eventid_idx ON alerts_201402 USING btree (eventid); -- -- Name: alerts_201402_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_mediatypeid_idx ON alerts_201402 USING btree (mediatypeid); -- -- Name: alerts_201402_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_status_retries_idx ON alerts_201402 USING btree (status, retries); -- -- Name: alerts_201402_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201402_userid_idx ON alerts_201402 USING btree (userid); -- -- Name: alerts_201403_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_actionid_idx ON alerts_201403 USING btree (actionid); -- -- Name: alerts_201403_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_clock_idx ON alerts_201403 USING btree (clock); -- -- Name: alerts_201403_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_eventid_idx ON alerts_201403 USING btree (eventid); -- -- Name: alerts_201403_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_mediatypeid_idx ON alerts_201403 USING btree (mediatypeid); -- -- Name: alerts_201403_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_status_retries_idx ON alerts_201403 USING btree (status, retries); -- -- Name: alerts_201403_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201403_userid_idx ON alerts_201403 USING btree (userid); -- -- Name: alerts_201404_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_actionid_idx ON alerts_201404 USING btree (actionid); -- -- Name: alerts_201404_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_clock_idx ON alerts_201404 USING btree (clock); -- -- Name: alerts_201404_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_eventid_idx ON alerts_201404 USING btree (eventid); -- -- Name: alerts_201404_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_mediatypeid_idx ON alerts_201404 USING btree (mediatypeid); -- -- Name: alerts_201404_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_status_retries_idx ON alerts_201404 USING btree (status, retries); -- -- Name: alerts_201404_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201404_userid_idx ON alerts_201404 USING btree (userid); -- -- Name: alerts_201405_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_actionid_idx ON alerts_201405 USING btree (actionid); -- -- Name: alerts_201405_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_clock_idx ON alerts_201405 USING btree (clock); -- -- Name: alerts_201405_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_eventid_idx ON alerts_201405 USING btree (eventid); -- -- Name: alerts_201405_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_mediatypeid_idx ON alerts_201405 USING btree (mediatypeid); -- -- Name: alerts_201405_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_status_retries_idx ON alerts_201405 USING btree (status, retries); -- -- Name: alerts_201405_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201405_userid_idx ON alerts_201405 USING btree (userid); -- -- Name: alerts_201406_actionid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_actionid_idx ON alerts_201406 USING btree (actionid); -- -- Name: alerts_201406_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_clock_idx ON alerts_201406 USING btree (clock); -- -- Name: alerts_201406_eventid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_eventid_idx ON alerts_201406 USING btree (eventid); -- -- Name: alerts_201406_mediatypeid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_mediatypeid_idx ON alerts_201406 USING btree (mediatypeid); -- -- Name: alerts_201406_status_retries_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_status_retries_idx ON alerts_201406 USING btree (status, retries); -- -- Name: alerts_201406_userid_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX alerts_201406_userid_idx ON alerts_201406 USING btree (userid); -- -- Name: auditlog_201401_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201401_clock_idx ON auditlog_201401 USING btree (clock); -- -- Name: auditlog_201401_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201401_userid_clock_idx ON auditlog_201401 USING btree (userid, clock); -- -- Name: auditlog_201402_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201402_clock_idx ON auditlog_201402 USING btree (clock); -- -- Name: auditlog_201402_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201402_userid_clock_idx ON auditlog_201402 USING btree (userid, clock); -- -- Name: auditlog_201403_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201403_clock_idx ON auditlog_201403 USING btree (clock); -- -- Name: auditlog_201403_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201403_userid_clock_idx ON auditlog_201403 USING btree (userid, clock); -- -- Name: auditlog_201404_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201404_clock_idx ON auditlog_201404 USING btree (clock); -- -- Name: auditlog_201404_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201404_userid_clock_idx ON auditlog_201404 USING btree (userid, clock); -- -- Name: auditlog_201405_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201405_clock_idx ON auditlog_201405 USING btree (clock); -- -- Name: auditlog_201405_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201405_userid_clock_idx ON auditlog_201405 USING btree (userid, clock); -- -- Name: auditlog_201406_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201406_clock_idx ON auditlog_201406 USING btree (clock); -- -- Name: auditlog_201406_userid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_201406_userid_clock_idx ON auditlog_201406 USING btree (userid, clock); -- -- Name: events_201401_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201401_source_object_clock_idx ON events_201401 USING btree (source, object, clock); -- -- Name: events_201401_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201401_source_object_objectid_clock_idx ON events_201401 USING btree (source, object, objectid, clock); -- -- Name: events_201402_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201402_source_object_clock_idx ON events_201402 USING btree (source, object, clock); -- -- Name: events_201402_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201402_source_object_objectid_clock_idx ON events_201402 USING btree (source, object, objectid, clock); -- -- Name: events_201403_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201403_source_object_clock_idx ON events_201403 USING btree (source, object, clock); -- -- Name: events_201403_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201403_source_object_objectid_clock_idx ON events_201403 USING btree (source, object, objectid, clock); -- -- Name: events_201404_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201404_source_object_clock_idx ON events_201404 USING btree (source, object, clock); -- -- Name: events_201404_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201404_source_object_objectid_clock_idx ON events_201404 USING btree (source, object, objectid, clock); -- -- Name: events_201405_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201405_source_object_clock_idx ON events_201405 USING btree (source, object, clock); -- -- Name: events_201405_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201405_source_object_objectid_clock_idx ON events_201405 USING btree (source, object, objectid, clock); -- -- Name: events_201406_source_object_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201406_source_object_clock_idx ON events_201406 USING btree (source, object, clock); -- -- Name: events_201406_source_object_objectid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX events_201406_source_object_objectid_clock_idx ON events_201406 USING btree (source, object, objectid, clock); -- -- Name: history_20140521_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140521_itemid_clock_idx ON history_20140521 USING btree (itemid, clock); -- -- Name: history_20140522_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140522_itemid_clock_idx ON history_20140522 USING btree (itemid, clock); -- -- Name: history_20140523_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140523_itemid_clock_idx ON history_20140523 USING btree (itemid, clock); -- -- Name: history_20140524_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140524_itemid_clock_idx ON history_20140524 USING btree (itemid, clock); -- -- Name: history_20140525_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140525_itemid_clock_idx ON history_20140525 USING btree (itemid, clock); -- -- Name: history_20140526_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140526_itemid_clock_idx ON history_20140526 USING btree (itemid, clock); -- -- Name: history_20140527_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140527_itemid_clock_idx ON history_20140527 USING btree (itemid, clock); -- -- Name: history_20140528_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140528_itemid_clock_idx ON history_20140528 USING btree (itemid, clock); -- -- Name: history_20140529_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140529_itemid_clock_idx ON history_20140529 USING btree (itemid, clock); -- -- Name: history_20140530_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140530_itemid_clock_idx ON history_20140530 USING btree (itemid, clock); -- -- Name: history_20140531_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140531_itemid_clock_idx ON history_20140531 USING btree (itemid, clock); -- -- Name: history_20140601_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140601_itemid_clock_idx ON history_20140601 USING btree (itemid, clock); -- -- Name: history_20140602_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140602_itemid_clock_idx ON history_20140602 USING btree (itemid, clock); -- -- Name: history_20140603_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140603_itemid_clock_idx ON history_20140603 USING btree (itemid, clock); -- -- Name: history_20140604_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_20140604_itemid_clock_idx ON history_20140604 USING btree (itemid, clock); -- -- Name: history_log_20140521_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140521_itemid_clock_idx ON history_log_20140521 USING btree (itemid, clock); -- -- Name: history_log_20140521_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140521_itemid_id_idx ON history_log_20140521 USING btree (itemid, id); -- -- Name: history_log_20140522_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140522_itemid_clock_idx ON history_log_20140522 USING btree (itemid, clock); -- -- Name: history_log_20140522_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140522_itemid_id_idx ON history_log_20140522 USING btree (itemid, id); -- -- Name: history_log_20140523_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140523_itemid_clock_idx ON history_log_20140523 USING btree (itemid, clock); -- -- Name: history_log_20140523_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140523_itemid_id_idx ON history_log_20140523 USING btree (itemid, id); -- -- Name: history_log_20140524_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140524_itemid_clock_idx ON history_log_20140524 USING btree (itemid, clock); -- -- Name: history_log_20140524_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140524_itemid_id_idx ON history_log_20140524 USING btree (itemid, id); -- -- Name: history_log_20140525_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140525_itemid_clock_idx ON history_log_20140525 USING btree (itemid, clock); -- -- Name: history_log_20140525_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140525_itemid_id_idx ON history_log_20140525 USING btree (itemid, id); -- -- Name: history_log_20140526_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140526_itemid_clock_idx ON history_log_20140526 USING btree (itemid, clock); -- -- Name: history_log_20140526_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140526_itemid_id_idx ON history_log_20140526 USING btree (itemid, id); -- -- Name: history_log_20140527_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140527_itemid_clock_idx ON history_log_20140527 USING btree (itemid, clock); -- -- Name: history_log_20140527_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140527_itemid_id_idx ON history_log_20140527 USING btree (itemid, id); -- -- Name: history_log_20140528_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140528_itemid_clock_idx ON history_log_20140528 USING btree (itemid, clock); -- -- Name: history_log_20140528_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140528_itemid_id_idx ON history_log_20140528 USING btree (itemid, id); -- -- Name: history_log_20140529_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140529_itemid_clock_idx ON history_log_20140529 USING btree (itemid, clock); -- -- Name: history_log_20140529_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140529_itemid_id_idx ON history_log_20140529 USING btree (itemid, id); -- -- Name: history_log_20140530_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140530_itemid_clock_idx ON history_log_20140530 USING btree (itemid, clock); -- -- Name: history_log_20140530_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140530_itemid_id_idx ON history_log_20140530 USING btree (itemid, id); -- -- Name: history_log_20140531_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140531_itemid_clock_idx ON history_log_20140531 USING btree (itemid, clock); -- -- Name: history_log_20140531_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140531_itemid_id_idx ON history_log_20140531 USING btree (itemid, id); -- -- Name: history_log_20140601_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140601_itemid_clock_idx ON history_log_20140601 USING btree (itemid, clock); -- -- Name: history_log_20140601_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140601_itemid_id_idx ON history_log_20140601 USING btree (itemid, id); -- -- Name: history_log_20140602_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140602_itemid_clock_idx ON history_log_20140602 USING btree (itemid, clock); -- -- Name: history_log_20140602_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140602_itemid_id_idx ON history_log_20140602 USING btree (itemid, id); -- -- Name: history_log_20140603_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140603_itemid_clock_idx ON history_log_20140603 USING btree (itemid, clock); -- -- Name: history_log_20140603_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140603_itemid_id_idx ON history_log_20140603 USING btree (itemid, id); -- -- Name: history_log_20140604_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_log_20140604_itemid_clock_idx ON history_log_20140604 USING btree (itemid, clock); -- -- Name: history_log_20140604_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_log_20140604_itemid_id_idx ON history_log_20140604 USING btree (itemid, id); -- -- Name: history_str_20140521_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140521_itemid_clock_idx ON history_str_20140521 USING btree (itemid, clock); -- -- Name: history_str_20140522_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140522_itemid_clock_idx ON history_str_20140522 USING btree (itemid, clock); -- -- Name: history_str_20140523_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140523_itemid_clock_idx ON history_str_20140523 USING btree (itemid, clock); -- -- Name: history_str_20140524_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140524_itemid_clock_idx ON history_str_20140524 USING btree (itemid, clock); -- -- Name: history_str_20140525_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140525_itemid_clock_idx ON history_str_20140525 USING btree (itemid, clock); -- -- Name: history_str_20140526_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140526_itemid_clock_idx ON history_str_20140526 USING btree (itemid, clock); -- -- Name: history_str_20140527_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140527_itemid_clock_idx ON history_str_20140527 USING btree (itemid, clock); -- -- Name: history_str_20140528_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140528_itemid_clock_idx ON history_str_20140528 USING btree (itemid, clock); -- -- Name: history_str_20140529_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140529_itemid_clock_idx ON history_str_20140529 USING btree (itemid, clock); -- -- Name: history_str_20140530_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140530_itemid_clock_idx ON history_str_20140530 USING btree (itemid, clock); -- -- Name: history_str_20140531_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140531_itemid_clock_idx ON history_str_20140531 USING btree (itemid, clock); -- -- Name: history_str_20140601_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140601_itemid_clock_idx ON history_str_20140601 USING btree (itemid, clock); -- -- Name: history_str_20140602_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140602_itemid_clock_idx ON history_str_20140602 USING btree (itemid, clock); -- -- Name: history_str_20140603_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140603_itemid_clock_idx ON history_str_20140603 USING btree (itemid, clock); -- -- Name: history_str_20140604_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_20140604_itemid_clock_idx ON history_str_20140604 USING btree (itemid, clock); -- -- Name: history_str_sync_20140521_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140521_nodeid_id_idx ON history_str_sync_20140521 USING btree (nodeid, id); -- -- Name: history_str_sync_20140522_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140522_nodeid_id_idx ON history_str_sync_20140522 USING btree (nodeid, id); -- -- Name: history_str_sync_20140523_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140523_nodeid_id_idx ON history_str_sync_20140523 USING btree (nodeid, id); -- -- Name: history_str_sync_20140524_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140524_nodeid_id_idx ON history_str_sync_20140524 USING btree (nodeid, id); -- -- Name: history_str_sync_20140525_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140525_nodeid_id_idx ON history_str_sync_20140525 USING btree (nodeid, id); -- -- Name: history_str_sync_20140526_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140526_nodeid_id_idx ON history_str_sync_20140526 USING btree (nodeid, id); -- -- Name: history_str_sync_20140527_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140527_nodeid_id_idx ON history_str_sync_20140527 USING btree (nodeid, id); -- -- Name: history_str_sync_20140528_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140528_nodeid_id_idx ON history_str_sync_20140528 USING btree (nodeid, id); -- -- Name: history_str_sync_20140529_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140529_nodeid_id_idx ON history_str_sync_20140529 USING btree (nodeid, id); -- -- Name: history_str_sync_20140530_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140530_nodeid_id_idx ON history_str_sync_20140530 USING btree (nodeid, id); -- -- Name: history_str_sync_20140531_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140531_nodeid_id_idx ON history_str_sync_20140531 USING btree (nodeid, id); -- -- Name: history_str_sync_20140601_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140601_nodeid_id_idx ON history_str_sync_20140601 USING btree (nodeid, id); -- -- Name: history_str_sync_20140602_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140602_nodeid_id_idx ON history_str_sync_20140602 USING btree (nodeid, id); -- -- Name: history_str_sync_20140603_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140603_nodeid_id_idx ON history_str_sync_20140603 USING btree (nodeid, id); -- -- Name: history_str_sync_20140604_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_str_sync_20140604_nodeid_id_idx ON history_str_sync_20140604 USING btree (nodeid, id); -- -- Name: history_sync_20140521_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140521_nodeid_id_idx ON history_sync_20140521 USING btree (nodeid, id); -- -- Name: history_sync_20140522_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140522_nodeid_id_idx ON history_sync_20140522 USING btree (nodeid, id); -- -- Name: history_sync_20140523_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140523_nodeid_id_idx ON history_sync_20140523 USING btree (nodeid, id); -- -- Name: history_sync_20140524_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140524_nodeid_id_idx ON history_sync_20140524 USING btree (nodeid, id); -- -- Name: history_sync_20140525_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140525_nodeid_id_idx ON history_sync_20140525 USING btree (nodeid, id); -- -- Name: history_sync_20140526_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140526_nodeid_id_idx ON history_sync_20140526 USING btree (nodeid, id); -- -- Name: history_sync_20140527_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140527_nodeid_id_idx ON history_sync_20140527 USING btree (nodeid, id); -- -- Name: history_sync_20140528_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140528_nodeid_id_idx ON history_sync_20140528 USING btree (nodeid, id); -- -- Name: history_sync_20140529_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140529_nodeid_id_idx ON history_sync_20140529 USING btree (nodeid, id); -- -- Name: history_sync_20140530_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140530_nodeid_id_idx ON history_sync_20140530 USING btree (nodeid, id); -- -- Name: history_sync_20140531_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140531_nodeid_id_idx ON history_sync_20140531 USING btree (nodeid, id); -- -- Name: history_sync_20140601_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140601_nodeid_id_idx ON history_sync_20140601 USING btree (nodeid, id); -- -- Name: history_sync_20140602_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140602_nodeid_id_idx ON history_sync_20140602 USING btree (nodeid, id); -- -- Name: history_sync_20140603_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140603_nodeid_id_idx ON history_sync_20140603 USING btree (nodeid, id); -- -- Name: history_sync_20140604_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_sync_20140604_nodeid_id_idx ON history_sync_20140604 USING btree (nodeid, id); -- -- Name: history_text_20140521_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140521_itemid_clock_idx ON history_text_20140521 USING btree (itemid, clock); -- -- Name: history_text_20140521_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140521_itemid_id_idx ON history_text_20140521 USING btree (itemid, id); -- -- Name: history_text_20140522_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140522_itemid_clock_idx ON history_text_20140522 USING btree (itemid, clock); -- -- Name: history_text_20140522_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140522_itemid_id_idx ON history_text_20140522 USING btree (itemid, id); -- -- Name: history_text_20140523_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140523_itemid_clock_idx ON history_text_20140523 USING btree (itemid, clock); -- -- Name: history_text_20140523_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140523_itemid_id_idx ON history_text_20140523 USING btree (itemid, id); -- -- Name: history_text_20140524_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140524_itemid_clock_idx ON history_text_20140524 USING btree (itemid, clock); -- -- Name: history_text_20140524_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140524_itemid_id_idx ON history_text_20140524 USING btree (itemid, id); -- -- Name: history_text_20140525_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140525_itemid_clock_idx ON history_text_20140525 USING btree (itemid, clock); -- -- Name: history_text_20140525_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140525_itemid_id_idx ON history_text_20140525 USING btree (itemid, id); -- -- Name: history_text_20140526_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140526_itemid_clock_idx ON history_text_20140526 USING btree (itemid, clock); -- -- Name: history_text_20140526_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140526_itemid_id_idx ON history_text_20140526 USING btree (itemid, id); -- -- Name: history_text_20140527_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140527_itemid_clock_idx ON history_text_20140527 USING btree (itemid, clock); -- -- Name: history_text_20140527_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140527_itemid_id_idx ON history_text_20140527 USING btree (itemid, id); -- -- Name: history_text_20140528_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140528_itemid_clock_idx ON history_text_20140528 USING btree (itemid, clock); -- -- Name: history_text_20140528_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140528_itemid_id_idx ON history_text_20140528 USING btree (itemid, id); -- -- Name: history_text_20140529_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140529_itemid_clock_idx ON history_text_20140529 USING btree (itemid, clock); -- -- Name: history_text_20140529_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140529_itemid_id_idx ON history_text_20140529 USING btree (itemid, id); -- -- Name: history_text_20140530_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140530_itemid_clock_idx ON history_text_20140530 USING btree (itemid, clock); -- -- Name: history_text_20140530_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140530_itemid_id_idx ON history_text_20140530 USING btree (itemid, id); -- -- Name: history_text_20140531_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140531_itemid_clock_idx ON history_text_20140531 USING btree (itemid, clock); -- -- Name: history_text_20140531_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140531_itemid_id_idx ON history_text_20140531 USING btree (itemid, id); -- -- Name: history_text_20140601_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140601_itemid_clock_idx ON history_text_20140601 USING btree (itemid, clock); -- -- Name: history_text_20140601_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140601_itemid_id_idx ON history_text_20140601 USING btree (itemid, id); -- -- Name: history_text_20140602_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140602_itemid_clock_idx ON history_text_20140602 USING btree (itemid, clock); -- -- Name: history_text_20140602_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140602_itemid_id_idx ON history_text_20140602 USING btree (itemid, id); -- -- Name: history_text_20140603_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140603_itemid_clock_idx ON history_text_20140603 USING btree (itemid, clock); -- -- Name: history_text_20140603_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140603_itemid_id_idx ON history_text_20140603 USING btree (itemid, id); -- -- Name: history_text_20140604_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_text_20140604_itemid_clock_idx ON history_text_20140604 USING btree (itemid, clock); -- -- Name: history_text_20140604_itemid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX history_text_20140604_itemid_id_idx ON history_text_20140604 USING btree (itemid, id); -- -- Name: history_uint_20140521_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140521_itemid_clock_idx ON history_uint_20140521 USING btree (itemid, clock); -- -- Name: history_uint_20140522_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140522_itemid_clock_idx ON history_uint_20140522 USING btree (itemid, clock); -- -- Name: history_uint_20140523_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140523_itemid_clock_idx ON history_uint_20140523 USING btree (itemid, clock); -- -- Name: history_uint_20140524_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140524_itemid_clock_idx ON history_uint_20140524 USING btree (itemid, clock); -- -- Name: history_uint_20140525_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140525_itemid_clock_idx ON history_uint_20140525 USING btree (itemid, clock); -- -- Name: history_uint_20140526_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140526_itemid_clock_idx ON history_uint_20140526 USING btree (itemid, clock); -- -- Name: history_uint_20140527_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140527_itemid_clock_idx ON history_uint_20140527 USING btree (itemid, clock); -- -- Name: history_uint_20140528_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140528_itemid_clock_idx ON history_uint_20140528 USING btree (itemid, clock); -- -- Name: history_uint_20140529_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140529_itemid_clock_idx ON history_uint_20140529 USING btree (itemid, clock); -- -- Name: history_uint_20140530_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140530_itemid_clock_idx ON history_uint_20140530 USING btree (itemid, clock); -- -- Name: history_uint_20140531_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140531_itemid_clock_idx ON history_uint_20140531 USING btree (itemid, clock); -- -- Name: history_uint_20140601_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140601_itemid_clock_idx ON history_uint_20140601 USING btree (itemid, clock); -- -- Name: history_uint_20140602_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140602_itemid_clock_idx ON history_uint_20140602 USING btree (itemid, clock); -- -- Name: history_uint_20140603_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140603_itemid_clock_idx ON history_uint_20140603 USING btree (itemid, clock); -- -- Name: history_uint_20140604_itemid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_20140604_itemid_clock_idx ON history_uint_20140604 USING btree (itemid, clock); -- -- Name: history_uint_sync_20140521_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140521_nodeid_id_idx ON history_uint_sync_20140521 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140522_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140522_nodeid_id_idx ON history_uint_sync_20140522 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140523_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140523_nodeid_id_idx ON history_uint_sync_20140523 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140524_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140524_nodeid_id_idx ON history_uint_sync_20140524 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140525_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140525_nodeid_id_idx ON history_uint_sync_20140525 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140526_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140526_nodeid_id_idx ON history_uint_sync_20140526 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140527_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140527_nodeid_id_idx ON history_uint_sync_20140527 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140528_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140528_nodeid_id_idx ON history_uint_sync_20140528 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140529_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140529_nodeid_id_idx ON history_uint_sync_20140529 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140530_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140530_nodeid_id_idx ON history_uint_sync_20140530 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140531_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140531_nodeid_id_idx ON history_uint_sync_20140531 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140601_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140601_nodeid_id_idx ON history_uint_sync_20140601 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140602_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140602_nodeid_id_idx ON history_uint_sync_20140602 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140603_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140603_nodeid_id_idx ON history_uint_sync_20140603 USING btree (nodeid, id); -- -- Name: history_uint_sync_20140604_nodeid_id_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX history_uint_sync_20140604_nodeid_id_idx ON history_uint_sync_20140604 USING btree (nodeid, id); -- -- Name: service_alarms_201401_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201401_clock_idx ON service_alarms_201401 USING btree (clock); -- -- Name: service_alarms_201401_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201401_serviceid_clock_idx ON service_alarms_201401 USING btree (serviceid, clock); -- -- Name: service_alarms_201402_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201402_clock_idx ON service_alarms_201402 USING btree (clock); -- -- Name: service_alarms_201402_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201402_serviceid_clock_idx ON service_alarms_201402 USING btree (serviceid, clock); -- -- Name: service_alarms_201403_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201403_clock_idx ON service_alarms_201403 USING btree (clock); -- -- Name: service_alarms_201403_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201403_serviceid_clock_idx ON service_alarms_201403 USING btree (serviceid, clock); -- -- Name: service_alarms_201404_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201404_clock_idx ON service_alarms_201404 USING btree (clock); -- -- Name: service_alarms_201404_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201404_serviceid_clock_idx ON service_alarms_201404 USING btree (serviceid, clock); -- -- Name: service_alarms_201405_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201405_clock_idx ON service_alarms_201405 USING btree (clock); -- -- Name: service_alarms_201405_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201405_serviceid_clock_idx ON service_alarms_201405 USING btree (serviceid, clock); -- -- Name: service_alarms_201406_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201406_clock_idx ON service_alarms_201406 USING btree (clock); -- -- Name: service_alarms_201406_serviceid_clock_idx; Type: INDEX; Schema: partitions; Owner: postgres; Tablespace: -- CREATE INDEX service_alarms_201406_serviceid_clock_idx ON service_alarms_201406 USING btree (serviceid, clock); SET search_path = public, pg_catalog; -- -- Name: actions_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX actions_1 ON actions USING btree (eventsource, status); -- -- Name: application_template_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX application_template_1 ON application_template USING btree (applicationid, templateid); -- -- Name: application_template_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX application_template_2 ON application_template USING btree (templateid); -- -- Name: applications_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX applications_2 ON applications USING btree (hostid, name); -- -- Name: auditlog_details_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX auditlog_details_1 ON auditlog_details USING btree (auditid); -- -- Name: autoreg_host_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX autoreg_host_1 ON autoreg_host USING btree (proxy_hostid, host); -- -- Name: conditions_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX conditions_1 ON conditions USING btree (actionid); -- -- Name: config_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX config_1 ON config USING btree (alert_usrgrpid); -- -- Name: config_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX config_2 ON config USING btree (discovery_groupid); -- -- Name: dchecks_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX dchecks_1 ON dchecks USING btree (druleid); -- -- Name: dhosts_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX dhosts_1 ON dhosts USING btree (druleid); -- -- Name: drules_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX drules_1 ON drules USING btree (proxy_hostid); -- -- Name: dservices_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX dservices_1 ON dservices USING btree (dcheckid, type, key_, ip, port); -- -- Name: dservices_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX dservices_2 ON dservices USING btree (dhostid); -- -- Name: escalations_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX escalations_1 ON escalations USING btree (actionid, triggerid, itemid, escalationid); -- -- Name: expressions_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX expressions_1 ON expressions USING btree (regexpid); -- -- Name: functions_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX functions_1 ON functions USING btree (triggerid); -- -- Name: functions_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX functions_2 ON functions USING btree (itemid, function, parameter); -- -- Name: globalmacro_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX globalmacro_1 ON globalmacro USING btree (macro); -- -- Name: graph_discovery_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX graph_discovery_1 ON graph_discovery USING btree (graphid, parent_graphid); -- -- Name: graph_discovery_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graph_discovery_2 ON graph_discovery USING btree (parent_graphid); -- -- Name: graph_theme_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graph_theme_1 ON graph_theme USING btree (description); -- -- Name: graph_theme_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graph_theme_2 ON graph_theme USING btree (theme); -- -- Name: graphs_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_1 ON graphs USING btree (name); -- -- Name: graphs_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_2 ON graphs USING btree (templateid); -- -- Name: graphs_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_3 ON graphs USING btree (ymin_itemid); -- -- Name: graphs_4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_4 ON graphs USING btree (ymax_itemid); -- -- Name: graphs_items_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_items_1 ON graphs_items USING btree (itemid); -- -- Name: graphs_items_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX graphs_items_2 ON graphs_items USING btree (graphid); -- -- Name: group_prototype_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX group_prototype_1 ON group_prototype USING btree (hostid); -- -- Name: groups_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX groups_1 ON groups USING btree (name); -- -- Name: hostmacro_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX hostmacro_1 ON hostmacro USING btree (hostid, macro); -- -- Name: hosts_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_1 ON hosts USING btree (host); -- -- Name: hosts_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_2 ON hosts USING btree (status); -- -- Name: hosts_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_3 ON hosts USING btree (proxy_hostid); -- -- Name: hosts_4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_4 ON hosts USING btree (name); -- -- Name: hosts_5; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_5 ON hosts USING btree (maintenanceid); -- -- Name: hosts_groups_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups USING btree (hostid, groupid); -- -- Name: hosts_groups_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_groups_2 ON hosts_groups USING btree (groupid); -- -- Name: hosts_templates_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates USING btree (hostid, templateid); -- -- Name: hosts_templates_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX hosts_templates_2 ON hosts_templates USING btree (templateid); -- -- Name: httpstep_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httpstep_1 ON httpstep USING btree (httptestid); -- -- Name: httpstepitem_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX httpstepitem_1 ON httpstepitem USING btree (httpstepid, itemid); -- -- Name: httpstepitem_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httpstepitem_2 ON httpstepitem USING btree (itemid); -- -- Name: httptest_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httptest_1 ON httptest USING btree (applicationid); -- -- Name: httptest_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX httptest_2 ON httptest USING btree (hostid, name); -- -- Name: httptest_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httptest_3 ON httptest USING btree (status); -- -- Name: httptest_4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httptest_4 ON httptest USING btree (templateid); -- -- Name: httptestitem_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX httptestitem_1 ON httptestitem USING btree (httptestid, itemid); -- -- Name: httptestitem_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX httptestitem_2 ON httptestitem USING btree (itemid); -- -- Name: icon_map_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX icon_map_1 ON icon_map USING btree (name); -- -- Name: icon_map_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX icon_map_2 ON icon_map USING btree (default_iconid); -- -- Name: icon_mapping_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX icon_mapping_1 ON icon_mapping USING btree (iconmapid); -- -- Name: icon_mapping_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX icon_mapping_2 ON icon_mapping USING btree (iconid); -- -- Name: images_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX images_1 ON images USING btree (imagetype, name); -- -- Name: interface_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX interface_1 ON interface USING btree (hostid, type); -- -- Name: interface_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX interface_2 ON interface USING btree (ip, dns); -- -- Name: item_discovery_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX item_discovery_1 ON item_discovery USING btree (itemid, parent_itemid); -- -- Name: item_discovery_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX item_discovery_2 ON item_discovery USING btree (parent_itemid); -- -- Name: items_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX items_1 ON items USING btree (hostid, key_); -- -- Name: items_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX items_3 ON items USING btree (status); -- -- Name: items_4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX items_4 ON items USING btree (templateid); -- -- Name: items_5; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX items_5 ON items USING btree (valuemapid); -- -- Name: items_6; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX items_6 ON items USING btree (interfaceid); -- -- Name: items_applications_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX items_applications_1 ON items_applications USING btree (applicationid, itemid); -- -- Name: items_applications_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX items_applications_2 ON items_applications USING btree (itemid); -- -- Name: maintenances_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX maintenances_1 ON maintenances USING btree (active_since, active_till); -- -- Name: maintenances_groups_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups USING btree (maintenanceid, groupid); -- -- Name: maintenances_groups_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX maintenances_groups_2 ON maintenances_groups USING btree (groupid); -- -- Name: maintenances_hosts_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts USING btree (maintenanceid, hostid); -- -- Name: maintenances_hosts_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX maintenances_hosts_2 ON maintenances_hosts USING btree (hostid); -- -- Name: maintenances_windows_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows USING btree (maintenanceid, timeperiodid); -- -- Name: maintenances_windows_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX maintenances_windows_2 ON maintenances_windows USING btree (timeperiodid); -- -- Name: mappings_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX mappings_1 ON mappings USING btree (valuemapid); -- -- Name: media_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX media_1 ON media USING btree (userid); -- -- Name: media_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX media_2 ON media USING btree (mediatypeid); -- -- Name: node_cksum_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX node_cksum_1 ON node_cksum USING btree (nodeid, cksumtype, tablename, recordid); -- -- Name: nodes_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX nodes_1 ON nodes USING btree (masterid); -- -- Name: opcommand_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opcommand_1 ON opcommand USING btree (scriptid); -- -- Name: opcommand_grp_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opcommand_grp_1 ON opcommand_grp USING btree (operationid); -- -- Name: opcommand_grp_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opcommand_grp_2 ON opcommand_grp USING btree (groupid); -- -- Name: opcommand_hst_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opcommand_hst_1 ON opcommand_hst USING btree (operationid); -- -- Name: opcommand_hst_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opcommand_hst_2 ON opcommand_hst USING btree (hostid); -- -- Name: opconditions_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opconditions_1 ON opconditions USING btree (operationid); -- -- Name: operations_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX operations_1 ON operations USING btree (actionid); -- -- Name: opgroup_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX opgroup_1 ON opgroup USING btree (operationid, groupid); -- -- Name: opgroup_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opgroup_2 ON opgroup USING btree (groupid); -- -- Name: opmessage_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opmessage_1 ON opmessage USING btree (mediatypeid); -- -- Name: opmessage_grp_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp USING btree (operationid, usrgrpid); -- -- Name: opmessage_grp_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opmessage_grp_2 ON opmessage_grp USING btree (usrgrpid); -- -- Name: opmessage_usr_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr USING btree (operationid, userid); -- -- Name: opmessage_usr_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX opmessage_usr_2 ON opmessage_usr USING btree (userid); -- -- Name: optemplate_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX optemplate_1 ON optemplate USING btree (operationid, templateid); -- -- Name: optemplate_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX optemplate_2 ON optemplate USING btree (templateid); -- -- Name: profiles_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX profiles_1 ON profiles USING btree (userid, idx, idx2); -- -- Name: profiles_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX profiles_2 ON profiles USING btree (userid, profileid); -- -- Name: proxy_autoreg_host_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host USING btree (clock); -- -- Name: proxy_dhistory_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX proxy_dhistory_1 ON proxy_dhistory USING btree (clock); -- -- Name: proxy_history_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX proxy_history_1 ON proxy_history USING btree (clock); -- -- Name: regexps_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX regexps_1 ON regexps USING btree (name); -- -- Name: rights_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX rights_1 ON rights USING btree (groupid); -- -- Name: rights_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX rights_2 ON rights USING btree (id); -- -- Name: screens_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX screens_1 ON screens USING btree (templateid); -- -- Name: screens_items_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX screens_items_1 ON screens_items USING btree (screenid); -- -- Name: scripts_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX scripts_1 ON scripts USING btree (usrgrpid); -- -- Name: scripts_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX scripts_2 ON scripts USING btree (groupid); -- -- Name: services_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX services_1 ON services USING btree (triggerid); -- -- Name: services_links_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX services_links_1 ON services_links USING btree (servicedownid); -- -- Name: services_links_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX services_links_2 ON services_links USING btree (serviceupid, servicedownid); -- -- Name: services_times_1; Type: INDEX; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- CREATE INDEX sessions_1 ON sessions USING btree (userid, status); -- -- Name: slides_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX slides_1 ON slides USING btree (slideshowid); -- -- Name: slides_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX slides_2 ON slides USING btree (screenid); -- -- Name: sysmap_element_url_1; Type: INDEX; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url USING btree (sysmapid, name); -- -- Name: sysmaps_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_1 ON sysmaps USING btree (name); -- -- Name: sysmaps_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_2 ON sysmaps USING btree (backgroundid); -- -- Name: sysmaps_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_3 ON sysmaps USING btree (iconmapid); -- -- Name: sysmaps_elements_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_elements_1 ON sysmaps_elements USING btree (sysmapid); -- -- Name: sysmaps_elements_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_elements_2 ON sysmaps_elements USING btree (iconid_off); -- -- Name: sysmaps_elements_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_elements_3 ON sysmaps_elements USING btree (iconid_on); -- -- Name: sysmaps_elements_4; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_elements_4 ON sysmaps_elements USING btree (iconid_disabled); -- -- Name: sysmaps_elements_5; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_elements_5 ON sysmaps_elements USING btree (iconid_maintenance); -- -- Name: sysmaps_link_triggers_1; Type: INDEX; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- CREATE INDEX sysmaps_link_triggers_2 ON sysmaps_link_triggers USING btree (triggerid); -- -- Name: sysmaps_links_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_links_1 ON sysmaps_links USING btree (sysmapid); -- -- Name: sysmaps_links_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_links_2 ON sysmaps_links USING btree (selementid1); -- -- Name: sysmaps_links_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sysmaps_links_3 ON sysmaps_links USING btree (selementid2); -- -- Name: tpl_acknowledges_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_acknowledges_clock_idx ON tpl_acknowledges USING btree (clock); -- -- Name: tpl_acknowledges_eventid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_acknowledges_eventid_idx ON tpl_acknowledges USING btree (eventid); -- -- Name: tpl_acknowledges_userid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_acknowledges_userid_idx ON tpl_acknowledges USING btree (userid); -- -- Name: tpl_alerts_actionid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_actionid_idx ON tpl_alerts USING btree (actionid); -- -- Name: tpl_alerts_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_clock_idx ON tpl_alerts USING btree (clock); -- -- Name: tpl_alerts_eventid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_eventid_idx ON tpl_alerts USING btree (eventid); -- -- Name: tpl_alerts_mediatypeid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_mediatypeid_idx ON tpl_alerts USING btree (mediatypeid); -- -- Name: tpl_alerts_status_retries_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_status_retries_idx ON tpl_alerts USING btree (status, retries); -- -- Name: tpl_alerts_userid_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_alerts_userid_idx ON tpl_alerts USING btree (userid); -- -- Name: tpl_auditlog_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_auditlog_clock_idx ON tpl_auditlog USING btree (clock); -- -- Name: tpl_auditlog_userid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_auditlog_userid_clock_idx ON tpl_auditlog USING btree (userid, clock); -- -- Name: tpl_events_source_object_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_events_source_object_clock_idx ON tpl_events USING btree (source, object, clock); -- -- Name: tpl_events_source_object_objectid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_events_source_object_objectid_clock_idx ON tpl_events USING btree (source, object, objectid, clock); -- -- Name: tpl_history_itemid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_itemid_clock_idx ON tpl_history USING btree (itemid, clock); -- -- Name: tpl_history_log_itemid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_log_itemid_clock_idx ON tpl_history_log USING btree (itemid, clock); -- -- Name: tpl_history_log_itemid_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX tpl_history_log_itemid_id_idx ON tpl_history_log USING btree (itemid, id); -- -- Name: tpl_history_str_itemid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_str_itemid_clock_idx ON tpl_history_str USING btree (itemid, clock); -- -- Name: tpl_history_str_sync_nodeid_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_str_sync_nodeid_id_idx ON tpl_history_str_sync USING btree (nodeid, id); -- -- Name: tpl_history_sync_nodeid_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_sync_nodeid_id_idx ON tpl_history_sync USING btree (nodeid, id); -- -- Name: tpl_history_text_itemid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_text_itemid_clock_idx ON tpl_history_text USING btree (itemid, clock); -- -- Name: tpl_history_text_itemid_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX tpl_history_text_itemid_id_idx ON tpl_history_text USING btree (itemid, id); -- -- Name: tpl_history_uint_itemid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_uint_itemid_clock_idx ON tpl_history_uint USING btree (itemid, clock); -- -- Name: tpl_history_uint_sync_nodeid_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_history_uint_sync_nodeid_id_idx ON tpl_history_uint_sync USING btree (nodeid, id); -- -- Name: tpl_service_alarms_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_service_alarms_clock_idx ON tpl_service_alarms USING btree (clock); -- -- Name: tpl_service_alarms_serviceid_clock_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX tpl_service_alarms_serviceid_clock_idx ON tpl_service_alarms USING btree (serviceid, clock); -- -- Name: trigger_depends_1; Type: INDEX; Schema: public; Owner: postgres; 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: postgres; Tablespace: -- CREATE INDEX trigger_depends_2 ON trigger_depends USING btree (triggerid_up); -- -- Name: trigger_discovery_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX trigger_discovery_1 ON trigger_discovery USING btree (triggerid, parent_triggerid); -- -- Name: trigger_discovery_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX trigger_discovery_2 ON trigger_discovery USING btree (parent_triggerid); -- -- Name: triggers_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX triggers_1 ON triggers USING btree (status); -- -- Name: triggers_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX triggers_2 ON triggers USING btree (value); -- -- Name: triggers_3; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX triggers_3 ON triggers USING btree (templateid); -- -- Name: user_history_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX user_history_1 ON user_history USING btree (userid); -- -- Name: users_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX users_1 ON users USING btree (alias); -- -- Name: users_groups_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE UNIQUE INDEX users_groups_1 ON users_groups USING btree (usrgrpid, userid); -- -- Name: users_groups_2; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX users_groups_2 ON users_groups USING btree (userid); -- -- Name: usrgrp_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX usrgrp_1 ON usrgrp USING btree (name); -- -- Name: valuemaps_1; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX valuemaps_1 ON valuemaps USING btree (name); -- -- Name: acknowledges_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER acknowledges_trigger BEFORE INSERT ON acknowledges FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: alerts_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER alerts_trigger BEFORE INSERT ON alerts FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: auditlog_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER auditlog_trigger BEFORE INSERT ON auditlog FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: events_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER events_trigger BEFORE INSERT ON events FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: history_log_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_log_trigger BEFORE INSERT ON history_log FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_str_sync_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_str_sync_trigger BEFORE INSERT ON history_str_sync FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_str_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_str_trigger BEFORE INSERT ON history_str FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_sync_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_sync_trigger BEFORE INSERT ON history_sync FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_text_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_text_trigger BEFORE INSERT ON history_text FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_trigger BEFORE INSERT ON history FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_uint_sync_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_uint_sync_trigger BEFORE INSERT ON history_uint_sync FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: history_uint_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER history_uint_trigger BEFORE INSERT ON history_uint FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_day(); -- -- Name: service_alarms_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER service_alarms_trigger BEFORE INSERT ON service_alarms FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: trends_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER trends_trigger BEFORE INSERT ON trends FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: trends_uint_trigger; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER trends_uint_trigger BEFORE INSERT ON trends_uint FOR EACH ROW EXECUTE PROCEDURE dynamic_insert_trigger_month(); -- -- Name: c_application_template_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- 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: postgres -- 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: postgres -- ALTER TABLE ONLY applications ADD CONSTRAINT c_applications_1 FOREIGN KEY (hostid) REFERENCES hosts(hostid) ON DELETE CASCADE; -- -- Name: c_autoreg_host_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_2 FOREIGN KEY (groupid) REFERENCES groups(groupid); -- -- Name: c_services_1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- 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: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --