Changeset 378ef447b1015a081fe182f16097392fa036a9ce

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

[ff905e92ad93d8c9a71dcfc0d1825f3667a22c01]

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

check status tables

Files:

Legend:

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

    ra34bc12 r378ef44  
    11-- formerly loading_dock_status_s_changelog  
     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_changelog; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
     21-- 
     22 
     23CREATE TABLE check_status_changelog ( 
     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_changelog OWNER TO reconnoiter; 
     34 
     35-- 
     36-- Name: check_status_changelog_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
     37-- 
     38 
     39ALTER TABLE ONLY check_status_changelog 
     40    ADD CONSTRAINT check_status_changelog_pkey PRIMARY KEY (sid, whence); 
     41 
     42 
     43-- 
     44-- Name: check_status_changelog; Type: ACL; Schema: noit; Owner: reconnoiter 
     45-- 
     46 
     47REVOKE ALL ON TABLE check_status_changelog FROM PUBLIC; 
     48REVOKE ALL ON TABLE check_status_changelog FROM reconnoiter; 
     49GRANT ALL ON TABLE check_status_changelog TO reconnoiter; 
     50GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_status_changelog TO stratcon; 
     51GRANT SELECT ON TABLE check_status_changelog TO prism; 
     52 
     53 
     54-- 
     55-- PostgreSQL database dump complete 
     56-- 
     57