Show
Ignore:
Timestamp:
09/30/09 16:41:15 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1254328875 +0000
git-parent:

[77e875df87c94f8cd2b8fbc32fbe360623e759b8]

git-author:
Robert Treat <robert@omniti.com> 1254328875 +0000
Message:

numeric metrics

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/tables/noit.metric_numeric_archive.sql

    ra34bc12 r5745519  
    1 -- formerly loading_dock_metric_numeric_archive 
     1-- formerly loading_dock_metric_numeric_archive  
     2-- 
     3-- PostgreSQL database dump 
     4-- 
     5 
     6SET client_encoding = 'UTF8'; 
     7SET standard_conforming_strings = off; 
     8SET check_function_bodies = false; 
     9SET client_min_messages = warning; 
     10SET escape_string_warning = off; 
     11 
     12SET search_path = noit, pg_catalog; 
     13 
     14SET default_tablespace = ''; 
     15 
     16SET default_with_oids = false; 
     17 
     18-- 
     19-- Name: metric_numeric_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     20-- 
     21 
     22CREATE TABLE metric_numeric_archive ( 
     23    sid integer NOT NULL, 
     24    whence timestamp with time zone NOT NULL, 
     25    name text NOT NULL, 
     26    value numeric 
     27); 
     28 
     29 
     30ALTER TABLE noit.metric_numeric_archive OWNER TO reconnoiter; 
     31 
     32-- 
     33-- Name: metric_numeric_archive_whence_key; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     34-- 
     35 
     36ALTER TABLE ONLY metric_numeric_archive 
     37    ADD CONSTRAINT metric_numeric_archive_pkey PRIMARY KEY (whence, sid, name); 
     38 
     39 
     40-- 
     41-- Name: mark_metric_numeric_rollup_buffer; Type: TRIGGER; Schema: noit; Owner: reconnoiter 
     42-- 
     43 
     44CREATE TRIGGER mark_metric_numeric_rollup_buffer 
     45    AFTER INSERT ON metric_numeric_archive 
     46    FOR EACH ROW 
     47    EXECUTE PROCEDURE mark_metric_numeric_rollup_buffer(); 
     48 
     49 
     50-- 
     51-- Name: metric_numeric_archive; Type: ACL; Schema: noit; Owner: reconnoiter 
     52-- 
     53 
     54REVOKE ALL ON TABLE metric_numeric_archive FROM PUBLIC; 
     55REVOKE ALL ON TABLE metric_numeric_archive FROM reconnoiter; 
     56GRANT ALL ON TABLE metric_numeric_archive TO reconnoiter; 
     57GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_archive TO stratcon; 
     58GRANT SELECT ON TABLE metric_numeric_archive TO prism; 
     59 
     60 
     61-- 
     62-- PostgreSQL database dump complete 
     63-- 
     64