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

[5745519bbdae8e0191e208603505894084660654]

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

status type check table

Files:

Legend:

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

    ra34bc12 r392462c  
    1 -- formerly loading_dock_status_archive 
     1-- formerly loading_dock_status_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: check_status_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     21-- 
     22 
     23CREATE TABLE check_status_archive ( 
     24    sid integer NOT NULL, 
     25    whence timestamp with time zone NOT NULL, 
     26    state character(1) NOT NULL, 
     27    availability character(1) NOT NULL, 
     28    duration integer NOT NULL, 
     29    status text 
     30); 
     31 
     32 
     33ALTER TABLE noit.check_status_archive OWNER TO reconnoiter; 
     34 
     35-- 
     36-- Name: check_status_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     37-- 
     38 
     39ALTER TABLE ONLY check_status_archive 
     40    ADD CONSTRAINT check_status_archive_pkey PRIMARY KEY (whence, sid); 
     41 
     42 
     43-- 
     44-- Name: check_status_archive_log_changes ; Type: TRIGGER; Schema: noit; Owner: reconnoiter 
     45-- 
     46 
     47CREATE TRIGGER check_status_archive_log_changes  
     48    AFTER INSERT ON check_status_archive 
     49    FOR EACH ROW 
     50    EXECUTE PROCEDURE check_status_archive_log_changes(); 
     51 
     52 
     53-- 
     54-- Name: check_status_archive; Type: ACL; Schema: noit; Owner: reconnoiter 
     55-- 
     56 
     57REVOKE ALL ON TABLE check_status_archive FROM PUBLIC; 
     58REVOKE ALL ON TABLE check_status_archive FROM reconnoiter; 
     59GRANT ALL ON TABLE check_status_archive TO reconnoiter; 
     60GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_status_archive TO stratcon; 
     61GRANT SELECT ON TABLE check_status_archive TO prism; 
     62 
     63 
     64-- 
     65-- PostgreSQL database dump complete 
     66-- 
     67