Changeset 35417f1d20ade67bfbf99b03c861fe1756ee11cd

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

[4e7af0052829e39e8da8375b559e9be499b247c2]

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

layout of primary check tables

Files:

Legend:

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

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