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

[3e3863d0f5b6548f78558042bd6c87f71145a732]

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

text metric tables

Files:

Legend:

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

    ra34bc12 r88d5aaa  
    1 -- loading_dock_metric_text_archive 
     1-- formerly loading_dock_metric_text_archive  
     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_text_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     21-- 
     22 
     23CREATE TABLE metric_text_archive ( 
     24    sid integer NOT NULL, 
     25    whence timestamp with time zone NOT NULL, 
     26    name text NOT NULL, 
     27    value text 
     28); 
     29 
     30 
     31ALTER TABLE noit.metric_text_archive OWNER TO reconnoiter; 
     32 
     33-- 
     34-- Name: metric_text_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     35-- 
     36 
     37ALTER TABLE ONLY metric_text_archive 
     38    ADD CONSTRAINT metric_text_archive_pkey PRIMARY KEY (whence, sid, name); 
     39 
     40-- 
     41-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: noit; Owner: reconnoiter 
     42-- 
     43 
     44CREATE TRIGGER metric_text_archive_log_changes 
     45    AFTER INSERT ON metric_text_archive 
     46    FOR EACH ROW 
     47    EXECUTE PROCEDURE metric_text_archive_log_changes(); 
     48 
     49 
     50-- 
     51-- Name: metric_text_archive; Type: ACL; Schema: noit; Owner: reconnoiter 
     52-- 
     53 
     54REVOKE ALL ON TABLE metric_text_archive FROM PUBLIC; 
     55REVOKE ALL ON TABLE metric_text_archive FROM reconnoiter; 
     56GRANT ALL ON TABLE metric_text_archive TO reconnoiter; 
     57GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_archive TO stratcon; 
     58GRANT SELECT ON TABLE metric_text_archive TO prism; 
     59 
     60 
     61-- 
     62-- PostgreSQL database dump complete 
     63-- 
  • sql/tables/noit.metric_text_changelog.sql

    ra34bc12 r88d5aaa  
    1 -- loading_dock_metric_text_s_changelog  
     1-- loading_dock_metric_text_s_change_log 
     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_text_changelog; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     20-- 
     21 
     22CREATE TABLE metric_text_changelog ( 
     23    sid integer NOT NULL, 
     24    whence timestamp with time zone NOT NULL, 
     25    name text NOT NULL, 
     26    value text 
     27); 
     28 
     29 
     30ALTER TABLE noit.metric_text_changelog OWNER TO reconnoiter; 
     31 
     32-- 
     33-- Name: metric_text_changelog_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     34-- 
     35 
     36ALTER TABLE ONLY metric_text_changelog 
     37    ADD CONSTRAINT metric_text_changelog_pkey PRIMARY KEY (whence, sid, name); 
     38 
     39 
     40-- 
     41-- Name: xx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace:  
     42-- 
     43 
     44CREATE INDEX metric_text_changelog_sid_name_whence_idx ON metric_text_changelog USING btree (sid, name, whence); 
     45 
     46 
     47-- 
     48-- Name: metric_text_changelog; Type: ACL; Schema: noit; Owner: reconnoiter 
     49-- 
     50 
     51REVOKE ALL ON TABLE metric_text_changelog FROM PUBLIC; 
     52REVOKE ALL ON TABLE metric_text_changelog FROM reconnoiter; 
     53GRANT ALL ON TABLE metric_text_changelog TO reconnoiter; 
     54GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_changelog TO stratcon; 
     55GRANT SELECT ON TABLE metric_text_changelog TO prism; 
     56 
     57 
     58-- 
     59-- PostgreSQL database dump complete 
     60-- 
     61 
  • sql/tables/noit.metric_text_currently.sql

    ra34bc12 r88d5aaa  
    11--formerly current_metric_text  
     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_text_currently; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     20-- 
     21 
     22CREATE TABLE metric_text_currently ( 
     23    sid integer NOT NULL, 
     24    whence timestamp with time zone NOT NULL, 
     25    name text NOT NULL, 
     26    value text 
     27); 
     28 
     29 
     30ALTER TABLE noit.metric_text_currently OWNER TO reconnoiter; 
     31 
     32-- 
     33-- Name: metric_text_currently_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     34-- 
     35 
     36ALTER TABLE ONLY metric_text_currently 
     37    ADD CONSTRAINT metric_text_currently_pkey PRIMARY KEY (sid, name); 
     38 
     39 
     40-- 
     41-- Name: metric_text_currently; Type: ACL; Schema: noit; Owner: reconnoiter 
     42-- 
     43 
     44REVOKE ALL ON TABLE metric_text_currently FROM PUBLIC; 
     45REVOKE ALL ON TABLE metric_text_currently FROM reconnoiter; 
     46GRANT ALL ON TABLE metric_text_currently TO reconnoiter; 
     47GRANT SELECT ON TABLE metric_text_currently TO prism; 
     48GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_text_currently TO stratcon; 
     49 
     50 
     51-- 
     52-- PostgreSQL database dump complete 
     53-- 
     54