Changeset 4aae95d137f38b64f49d27c9611b1fba6242666a

Show
Ignore:
Timestamp:
07/11/08 19:40:02 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1215805202 +0000
git-parent:

[47b88b010a032a620acac2e7dff46570fe80d64a]

git-author:
Denish Patel <denish@omniti.com> 1215805202 +0000
Message:

updated Reconniter DDL dump

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    r5366a70 r4aae95d  
    1010 
    1111-- 
    12 -- Name: stratcon; Type: SCHEMA; Schema: -; Owner: omniti 
     12-- Name: stratcon; Type: SCHEMA; Schema: -; Owner: - 
    1313-- 
    1414 
     
    1616 
    1717 
    18 ALTER SCHEMA stratcon OWNER TO omniti; 
    19  
    2018SET search_path = stratcon, pg_catalog; 
    2119 
     
    2523 
    2624-- 
    27 -- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: stratcon; Tablespace:  
     25-- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    2826-- 
    2927 
     
    3634 
    3735 
    38 ALTER TABLE stratcon.current_node_config OWNER TO stratcon; 
    39  
    40 -- 
    41 -- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: stratcon; Tablespace:  
     36-- 
     37-- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    4238-- 
    4339 
     
    5046 
    5147 
    52 ALTER TABLE stratcon.current_node_config_changelog OWNER TO stratcon; 
    53  
    54 -- 
    55 -- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     48-- 
     49-- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    5650-- 
    5751 
     
    6761 
    6862 
    69 ALTER TABLE stratcon.loading_dock_check_s OWNER TO omniti; 
    70  
    71 -- 
    72 -- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     63-- 
     64-- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    7365-- 
    7466 
     
    8173 
    8274 
    83 ALTER TABLE stratcon.loading_dock_metric_numeric_s OWNER TO omniti; 
    84  
    85 -- 
    86 -- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     75-- 
     76-- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    8777-- 
    8878 
     
    9585 
    9686 
    97 ALTER TABLE stratcon.loading_dock_metric_text_s OWNER TO omniti; 
    98  
    99 -- 
    100 -- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     87-- 
     88-- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    10189-- 
    10290 
     
    10997 
    11098 
    111 ALTER TABLE stratcon.loading_dock_metric_text_s_change_log OWNER TO omniti; 
    112  
    113 -- 
    114 -- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     99-- 
     100-- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    115101-- 
    116102 
     
    125111 
    126112 
    127 ALTER TABLE stratcon.loading_dock_status_s OWNER TO omniti; 
    128  
    129 -- 
    130 -- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     113-- 
     114-- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    131115-- 
    132116 
     
    141125 
    142126 
    143 ALTER TABLE stratcon.loading_dock_status_s_change_log OWNER TO omniti; 
    144  
    145 -- 
    146 -- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     127-- 
     128-- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    147129-- 
    148130 
     
    153135 
    154136 
    155 ALTER TABLE stratcon.log_whence_s OWNER TO omniti; 
    156  
    157 -- 
    158 -- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     137-- 
     138-- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    159139-- 
    160140 
     
    165145 
    166146 
    167 ALTER TABLE stratcon.map_uuid_to_sid OWNER TO omniti; 
    168  
    169 -- 
    170 -- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     147-- 
     148-- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    171149-- 
    172150 
     
    179157 
    180158 
    181 ALTER TABLE stratcon.metric_name_summary OWNER TO omniti; 
    182  
    183 -- 
    184 -- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: postgres; Tablespace:  
     159-- 
     160-- Name: mv_loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
     161-- 
     162 
     163CREATE TABLE mv_loading_dock_check_s ( 
     164    sid integer NOT NULL, 
     165    remote_address inet, 
     166    whence timestamp with time zone NOT NULL, 
     167    id uuid NOT NULL, 
     168    target text NOT NULL, 
     169    module text NOT NULL, 
     170    name text NOT NULL 
     171); 
     172 
     173 
     174-- 
     175-- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    185176-- 
    186177 
     
    194185 
    195186 
    196 ALTER TABLE stratcon.rollup_matrix_numeric_12hours OWNER TO postgres; 
    197  
    198 -- 
    199 -- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     187-- 
     188-- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    200189-- 
    201190 
     
    209198 
    210199 
    211 ALTER TABLE stratcon.rollup_matrix_numeric_20m OWNER TO omniti; 
    212  
    213 -- 
    214 -- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     200-- 
     201-- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    215202-- 
    216203 
     
    224211 
    225212 
    226 ALTER TABLE stratcon.rollup_matrix_numeric_5m OWNER TO omniti; 
    227  
    228 -- 
    229 -- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     213-- 
     214-- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    230215-- 
    231216 
     
    239224 
    240225 
    241 ALTER TABLE stratcon.rollup_matrix_numeric_60m OWNER TO omniti; 
    242  
    243 -- 
    244 -- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     226-- 
     227-- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    245228-- 
    246229 
     
    254237 
    255238 
    256 ALTER TABLE stratcon.rollup_matrix_numeric_6hours OWNER TO omniti; 
    257  
    258 -- 
    259 -- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: omniti; Tablespace:  
     239-- 
     240-- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:  
    260241-- 
    261242 
     
    266247 
    267248 
    268 ALTER TABLE stratcon.rollup_runner OWNER TO omniti; 
    269  
    270 -- 
    271 -- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     249-- 
     250-- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
    272251-- 
    273252 
     
    318297 
    319298 
    320 ALTER FUNCTION stratcon.choose_window(in_start_time timestamp without time zone, in_end_time timestamp without time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO omniti; 
    321  
    322 -- 
    323 -- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     299-- 
     300-- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
    324301-- 
    325302 
     
    370347 
    371348 
    372 ALTER FUNCTION stratcon.choose_window(in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO omniti; 
    373  
    374 -- 
    375 -- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     349-- 
     350-- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: - 
    376351-- 
    377352 
     
    383358 
    384359 
    385 ALTER FUNCTION stratcon.date_hour(timestamp with time zone) OWNER TO omniti; 
    386  
    387 -- 
    388 -- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: omniti 
    389 -- 
    390  
    391 CREATE FUNCTION fetch_dataset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) RETURNS SETOF rollup_matrix_numeric_5m 
     360-- 
     361-- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: - 
     362-- 
     363 
     364CREATE FUNCTION fetch_dataset(in_uuid uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) RETURNS SETOF rollup_matrix_numeric_5m 
     365    AS $$ 
     366declare 
     367  v_sid int; 
     368begin 
     369  select sid into v_sid from stratcon.map_uuid_to_sid where id = in_check; 
     370  if not found then 
     371    return; 
     372  end if; 
     373 
     374  return query select * from stratcon.fetch_dataset(v_sid::integer, in_name, in_start_time, in_end_time, in_hopeful_nperiods, derive); 
     375end 
     376$$ 
     377    LANGUAGE plpgsql; 
     378 
     379 
     380-- 
     381-- Name: fetch_dataset(integer, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: - 
     382-- 
     383 
     384CREATE FUNCTION fetch_dataset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) RETURNS SETOF rollup_matrix_numeric_5m 
    392385    AS $$ 
    393386declare 
     
    404397 
    405398  -- Map out uuid to an sid. 
    406   select sid into v_sid from stratcon.map_uuid_to_sid where id = in_check; 
    407   if not found then 
    408     return; 
    409   end if; 
     399  v_sid := in_sid; 
    410400 
    411401  select * into v_target from stratcon.choose_window(in_start_time, in_end_time, in_hopeful_nperiods); 
     
    469459 
    470460 
    471 ALTER FUNCTION stratcon.fetch_dataset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) OWNER TO omniti; 
    472  
    473 -- 
    474 -- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     461-- 
     462-- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
    475463-- 
    476464 
    477465CREATE FUNCTION fetch_varset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) RETURNS SETOF loading_dock_metric_text_s_change_log 
     466    AS $$ 
     467declare 
     468  v_sid int; 
     469begin 
     470  -- Map out uuid to an sid. 
     471  select sid into v_sid from stratcon.map_uuid_to_sid where id = in_check; 
     472  if not found then 
     473    return; 
     474  end if; 
     475 
     476  return query select * from stratcon.fetch_varset(v_sid::integer, in_name, in_start_time, in_end_time, in_hopeful_nperiods); 
     477end 
     478$$ 
     479    LANGUAGE plpgsql; 
     480 
     481 
     482-- 
     483-- Name: fetch_varset(integer, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: - 
     484-- 
     485 
     486CREATE FUNCTION fetch_varset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) RETURNS SETOF loading_dock_metric_text_s_change_log 
    478487    AS $$ 
    479488declare 
     
    487496begin 
    488497  -- Map out uuid to an sid. 
    489   select sid into v_sid from stratcon.map_uuid_to_sid where id = in_check; 
    490   if not found then 
    491     return; 
    492   end if; 
     498  v_sid := in_sid; 
    493499 
    494500  select * into v_target from stratcon.choose_window(in_start_time, in_end_time, in_hopeful_nperiods); 
     
    562568 
    563569 
    564 ALTER FUNCTION stratcon.fetch_varset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) OWNER TO omniti; 
    565  
    566 -- 
    567 -- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     570-- 
     571-- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: - 
    568572-- 
    569573 
     
    596600 
    597601 
    598 ALTER FUNCTION stratcon.generate_sid_from_id(v_in_id uuid) OWNER TO omniti; 
    599  
    600 -- 
    601 -- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     602-- 
     603-- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
    602604-- 
    603605 
     
    639641 
    640642 
    641 ALTER FUNCTION stratcon.loading_dock_metric_numeric_s_whence_log() OWNER TO omniti; 
    642  
    643 -- 
    644 -- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     643-- 
     644-- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
    645645-- 
    646646 
     
    662662IF TG_OP = 'INSERT' THEN 
    663663 
    664 SELECT max(whence) FROM stratcon.loading_dock_metric_text_s WHERE whence <> NEW.whence and sid=NEW.sid and name = NEW.name  
    665         INTO v_max_whence; 
    666   
    667  IF NEW.whence < v_max_whence THEN             
    668   
    669     INSERT INTO stratcon.loading_dock_metric_text_s_change_log (sid,whence,name,value) 
    670                  VALUES (NEW.sid,NEW.whence, NEW.name, NEW.value);  
    671                   
    672        SELECT  whence,name,value FROM  stratcon.loading_dock_metric_text_s_change_log WHERE whence > NEW.whence and sid=NEW.sid and name=NEW.name order by whence  limit 1  
    673         INTO v_whence,v_sid,v_name,v_value; 
    674           IF FOUND  THEN 
    675             IF v_value IS  DISTINCT FROM NEW.value THEN 
    676                NULL; 
    677             ELSE 
    678                 DELETE from  stratcon.loading_dock_metric_text_s_change_log  WHERE whence=v_whence and sid=v_sid and name=v_name; 
    679             END IF; 
    680           END IF; 
    681         
    682           
    683        SELECT whence,sid,name,value from stratcon.loading_dock_metric_text_s where whence> NEW.whence and sid=NEW.sid and name=NEW.name and value!=NEW.value order by whence limit 1 
    684          INTO v_whence,v_sid,v_name,v_value; 
    685           IF FOUND  THEN 
    686              SELECT  whence,sid,name,value FROM  stratcon.loading_dock_metric_text_s_change_log WHERE whence =v_whence and sid=v_sid and name=v_name and value=v_value 
    687                  INTO v_old_whence,v_old_sid,v_old_name,v_old_value; 
    688               IF FOUND THEN 
    689                  NULL; 
    690               ELSE 
    691                 INSERT INTO stratcon.loading_dock_metric_text_s_change_log (sid,whence,name,value) 
    692                  VALUES (v_sid,v_whence, v_name, v_value);  
    693                END IF; 
    694         END IF; 
    695  
    696   ELSE 
    697664     SELECT value FROM  stratcon.loading_dock_metric_text_s WHERE sid = NEW.sid AND name = NEW.name  
    698665         AND WHENCE = (SELECT max(whence) FROM stratcon.loading_dock_metric_text_s_change_log  
     
    705672            VALUES (NEW.sid, NEW.whence, NEW.name, NEW.value);  
    706673    END IF; 
    707   END IF;     
    708  
    709674 
    710675SELECT sid,metric_name FROM stratcon.metric_name_summary WHERE sid=NEW.sid  and metric_name=NEW.name 
     
    725690 
    726691 
    727 ALTER FUNCTION stratcon.loading_dock_metric_text_s_change_log() OWNER TO omniti; 
    728  
    729 -- 
    730 -- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     692-- 
     693-- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: - 
    731694-- 
    732695 
     
    762725 
    763726 
    764 ALTER FUNCTION stratcon.loading_dock_status_s_change_log() OWNER TO omniti; 
    765  
    766 -- 
    767 -- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: stratcon 
     727-- 
     728-- Name: mv_loading_dock_check_s(); Type: FUNCTION; Schema: stratcon; Owner: - 
     729-- 
     730 
     731CREATE FUNCTION mv_loading_dock_check_s() RETURNS trigger 
     732    AS $$ 
     733DECLARE 
     734    v_remote_address INET; 
     735    v_target TEXT; 
     736    v_module TEXT; 
     737    v_name TEXT; 
     738BEGIN 
     739 
     740IF TG_OP = 'INSERT' THEN 
     741    SELECT remote_address,target,module,name FROM  stratcon.mv_loading_dock_check_s WHERE sid = NEW.sid AND id=NEW.id  
     742        INTO v_remote_address,v_target,v_module,v_name; 
     743 
     744    IF v_remote_address IS DISTINCT FROM NEW.remote_address OR v_target IS DISTINCT FROM NEW.target OR v_name IS DISTINCT FROM NEW.name   THEN 
     745         
     746        DELETE from stratcon.mv_loading_dock_check_s WHERE sid = NEW.sid AND id=NEW.id; 
     747         
     748        INSERT INTO stratcon.mv_loading_dock_check_s (sid,remote_address,whence,id,target,module,name) 
     749            VALUES (NEW.sid,NEW.remote_address,NEW.whence,NEW.id,NEW.target,NEW.module,NEW.name);  
     750 
     751    END IF; 
     752 
     753ELSE 
     754        RAISE EXCEPTION 'Something wrong with stratcon.mv_loading_dock_check_s'; 
     755END IF; 
     756 
     757    RETURN NULL; 
     758 
     759END 
     760$$ 
     761    LANGUAGE plpgsql; 
     762 
     763 
     764-- 
     765-- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: - 
    768766-- 
    769767 
     
    870868 
    871869 
    872 ALTER FUNCTION stratcon.remove_metric(in_uuid uuid, in_metric_name text, v_debug text, OUT v_out text) OWNER TO stratcon; 
    873  
    874 -- 
    875 -- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: postgres 
     870-- 
     871-- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: - 
    876872-- 
    877873 
     
    972968 
    973969 
    974 ALTER FUNCTION stratcon.rollup_matrix_numeric_12hours() OWNER TO postgres; 
    975  
    976 -- 
    977 -- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     970-- 
     971-- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: - 
    978972-- 
    979973 
     
    10781072 
    10791073 
    1080 ALTER FUNCTION stratcon.rollup_matrix_numeric_20m() OWNER TO omniti; 
    1081  
    1082 -- 
    1083 -- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     1074-- 
     1075-- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: - 
    10841076-- 
    10851077 
     
    11841176 
    11851177 
    1186 ALTER FUNCTION stratcon.rollup_matrix_numeric_5m() OWNER TO omniti; 
    1187  
    1188 -- 
    1189 -- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     1178-- 
     1179-- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: - 
    11901180-- 
    11911181 
     
    12841274 
    12851275 
    1286 ALTER FUNCTION stratcon.rollup_matrix_numeric_60m() OWNER TO omniti; 
    1287  
    1288 -- 
    1289 -- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: omniti 
     1276-- 
     1277-- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: - 
    12901278-- 
    12911279 
     
    13841372 
    13851373 
    1386 ALTER FUNCTION stratcon.rollup_matrix_numeric_6hours() OWNER TO omniti; 
    1387  
    1388 -- 
    1389 -- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: stratcon 
     1374-- 
     1375-- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: - 
    13901376-- 
    13911377 
     
    14031389        END IF; 
    14041390        delete from stratcon.current_node_config 
    1405               where _address = v_remote_address_in 
     1391              where remote_address = v_remote_address_in 
    14061392                and node_type = v_node_type_in; 
    14071393    END IF; 
     
    14171403 
    14181404 
    1419 ALTER FUNCTION stratcon.update_config(v_remote_address_in inet, v_node_type_in text, v_whence_in timestamp with time zone, v_config_in xml) OWNER TO stratcon; 
    1420  
    1421 -- 
    1422 -- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: stratcon 
     1405-- 
     1406-- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: - 
    14231407-- 
    14241408 
     
    14301414 
    14311415 
    1432 ALTER TABLE stratcon.seq_sid OWNER TO stratcon; 
    1433  
    1434 -- 
    1435 -- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: stratcon; Tablespace:  
     1416-- 
     1417-- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14361418-- 
    14371419 
     
    14411423 
    14421424-- 
    1443 -- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: stratcon; Tablespace:  
     1425-- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14441426-- 
    14451427 
     
    14491431 
    14501432-- 
    1451 -- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1433-- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14521434-- 
    14531435 
     
    14571439 
    14581440-- 
    1459 -- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1441-- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14601442-- 
    14611443 
     
    14631445    ADD CONSTRAINT loading_dock_metric_numeric_s_pkey PRIMARY KEY (whence, sid, name); 
    14641446 
    1465  
    1466 -- 
    1467 -- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1447ALTER TABLE loading_dock_metric_numeric_s CLUSTER ON loading_dock_metric_numeric_s_pkey; 
     1448 
     1449 
     1450-- 
     1451-- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14681452-- 
    14691453 
     
    14731457 
    14741458-- 
    1475 -- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1459-- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14761460-- 
    14771461 
     
    14811465 
    14821466-- 
    1483 -- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1467-- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14841468-- 
    14851469 
     
    14891473 
    14901474-- 
    1491 -- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1475-- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    14921476-- 
    14931477 
     
    14971481 
    14981482-- 
    1499 -- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1483-- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15001484-- 
    15011485 
     
    15051489 
    15061490-- 
    1507 -- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1491-- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15081492-- 
    15091493 
     
    15131497 
    15141498-- 
    1515 -- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1499-- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15161500-- 
    15171501 
     
    15211505 
    15221506-- 
    1523 -- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: postgres; Tablespace:  
     1507-- Name: mv_loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
     1508-- 
     1509 
     1510ALTER TABLE ONLY mv_loading_dock_check_s 
     1511    ADD CONSTRAINT mv_loading_dock_check_s_pkey PRIMARY KEY (sid); 
     1512 
     1513 
     1514-- 
     1515-- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15241516-- 
    15251517 
     
    15311523 
    15321524-- 
    1533 -- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1525-- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15341526-- 
    15351527 
     
    15411533 
    15421534-- 
    1543 -- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1535-- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15441536-- 
    15451537 
     
    15511543 
    15521544-- 
    1553 -- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1545-- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15541546-- 
    15551547 
     
    15611553 
    15621554-- 
    1563 -- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: omniti; Tablespace:  
     1555-- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:  
    15641556-- 
    15651557 
     
    15711563 
    15721564-- 
    1573 -- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: omniti; Tablespace:  
     1565-- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1566-- 
     1567 
     1568CREATE INDEX idx_mv_loading_dock_check_s_module ON mv_loading_dock_check_s USING btree (module); 
     1569 
     1570 
     1571-- 
     1572-- Name: idx_mv_loading_dock_check_s_name; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1573-- 
     1574 
     1575CREATE INDEX idx_mv_loading_dock_check_s_name ON mv_loading_dock_check_s USING btree (name); 
     1576 
     1577 
     1578-- 
     1579-- Name: idx_mv_loading_dock_check_s_target; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1580-- 
     1581 
     1582CREATE INDEX idx_mv_loading_dock_check_s_target ON mv_loading_dock_check_s USING btree (target); 
     1583 
     1584 
     1585-- 
     1586-- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
    15741587-- 
    15751588 
     
    15781591 
    15791592-- 
    1580 -- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: omniti 
     1593-- Name: unq_mv_loading_dock_check_s_id; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:  
     1594-- 
     1595 
     1596CREATE UNIQUE INDEX unq_mv_loading_dock_check_s_id ON mv_loading_dock_check_s USING btree (id); 
     1597 
     1598 
     1599-- 
     1600-- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: - 
    15811601-- 
    15821602 
     
    15881608 
    15891609-- 
    1590 -- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: omniti 
     1610-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: - 
    15911611-- 
    15921612 
     
    15981618 
    15991619-- 
    1600 -- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: omniti 
     1620-- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: - 
    16011621-- 
    16021622 
     
    16081628 
    16091629-- 
    1610 -- Name: stratcon; Type: ACL; Schema: -; Owner: omniti 
     1630-- Name: mv_loading_dock_check_s; Type: TRIGGER; Schema: stratcon; Owner: - 
     1631-- 
     1632 
     1633CREATE TRIGGER mv_loading_dock_check_s 
     1634    AFTER INSERT ON loading_dock_check_s 
     1635    FOR EACH ROW 
     1636    EXECUTE PROCEDURE mv_loading_dock_check_s(); 
     1637 
     1638 
     1639-- 
     1640-- Name: stratcon; Type: ACL; Schema: -; Owner: - 
    16111641-- 
    16121642 
     
    16181648 
    16191649-- 
    1620 -- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: omniti 
     1650-- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: - 
    16211651-- 
    16221652 
     
    16281658 
    16291659-- 
    1630 -- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: omniti 
     1660-- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: - 
    16311661-- 
    16321662 
     
    16381668 
    16391669-- 
    1640 -- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: omniti 
     1670-- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: - 
    16411671-- 
    16421672 
     
    16481678 
    16491679-- 
    1650 -- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: omniti 
     1680-- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: - 
    16511681-- 
    16521682 
     
    16581688 
    16591689-- 
    1660 -- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: omniti 
     1690-- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: - 
    16611691-- 
    16621692 
     
    16681698 
    16691699-- 
    1670 -- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: omniti 
     1700-- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: - 
    16711701-- 
    16721702 
     
    16781708 
    16791709-- 
    1680 -- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: omniti 
     1710-- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: - 
    16811711-- 
    16821712 
     
    16881718 
    16891719-- 
    1690 -- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: omniti 
     1720-- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: - 
    16911721-- 
    16921722 
     
    16981728 
    16991729-- 
    1700 -- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: omniti 
     1730-- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: - 
    17011731-- 
    17021732 
     
    17081738 
    17091739-- 
    1710 -- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: postgres 
     1740-- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: - 
    17111741-- 
    17121742 
     
    17191749 
    17201750-- 
    1721 -- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: omniti 
     1751-- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: - 
    17221752-- 
    17231753 
     
    17291759 
    17301760-- 
    1731 -- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: omniti 
     1761-- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: - 
    17321762-- 
    17331763 
     
    17391769 
    17401770-- 
    1741 -- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: omniti 
     1771-- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: - 
    17421772-- 
    17431773 
     
    17491779 
    17501780-- 
    1751 -- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: omniti 
     1781-- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: - 
    17521782-- 
    17531783 
     
    17591789 
    17601790-- 
    1761 -- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: omniti 
     1791-- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: - 
    17621792-- 
    17631793