Changeset 3e3863d0f5b6548f78558042bd6c87f71145a732

Show
Ignore:
Timestamp:
09/29/09 21:53:51 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1254261231 +0000
git-parent:

[3278b4e18773a14f0cf214226356adbc065fa9be]

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

metric name summary

Files:

Legend:

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

    ra34bc12 r3e3863d  
    11-- formerly metric_name_summary (the same!)  
     2 
     3-- 
     4-- PostgreSQL database dump 
     5-- 
     6 
     7SET client_encoding = 'UTF8'; 
     8SET standard_conforming_strings = off; 
     9SET check_function_bodies = false; 
     10SET client_min_messages = warning; 
     11SET escape_string_warning = off; 
     12 
     13SET search_path = noit, pg_catalog; 
     14 
     15SET default_tablespace = ''; 
     16 
     17SET default_with_oids = false; 
     18 
     19-- 
     20-- Name: metric_name_summary; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     21-- 
     22 
     23CREATE TABLE metric_name_summary ( 
     24    sid integer NOT NULL, 
     25    metric_name text NOT NULL, 
     26    metric_type text, 
     27    active boolean DEFAULT true, 
     28    fts_data tsvector 
     29); 
     30 
     31 
     32ALTER TABLE noit.metric_name_summary OWNER TO reconnoiter; 
     33 
     34-- 
     35-- Name: metric_name_summary_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     36-- 
     37 
     38ALTER TABLE ONLY metric_name_summary 
     39    ADD CONSTRAINT metric_name_summary_pkey UNIQUE (sid, metric_name, metric_type); 
     40 
     41 
     42-- 
     43-- Name: metric_name_summary_fts_data_idx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace:  
     44-- 
     45 
     46CREATE INDEX metric_name_summary_fts_data_idx ON metric_name_summary USING gin (ts_search_all); 
     47 
     48 
     49-- 
     50-- Name: trig_update_tsvector_from_metric_summary; Type: TRIGGER; Schema: noit; Owner: reconnoiter 
     51-- 
     52 
     53CREATE TRIGGER update_metric_name_summary 
     54    BEFORE INSERT OR UPDATE ON metric_name_summary 
     55    FOR EACH ROW 
     56    EXECUTE PROCEDURE update_mns_via_self(); 
     57 
     58 
     59-- 
     60-- Name: metric_name_summary; Type: ACL; Schema: noit; Owner: reconnoiter 
     61-- 
     62 
     63REVOKE ALL ON TABLE metric_name_summary FROM PUBLIC; 
     64REVOKE ALL ON TABLE metric_name_summary FROM reconnoiter; 
     65GRANT ALL ON TABLE metric_name_summary TO reconnoiter; 
     66GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_name_summary TO stratcon; 
     67GRANT SELECT,UPDATE ON TABLE metric_name_summary TO prism; 
     68 
     69 
     70-- 
     71-- PostgreSQL database dump complete 
     72-- 
     73