root/sql/tables/noit.check_status_archive.sql

Revision 392462ca87d64f403a0ac61c95102e6611b362f3, 1.6 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

status type check table

  • Property mode set to 100644
Line 
1 -- formerly loading_dock_status_archive 
2
3 --
4 -- PostgreSQL database dump
5 --
6
7 SET client_encoding = 'UTF8';
8 SET standard_conforming_strings = off;
9 SET check_function_bodies = false;
10 SET client_min_messages = warning;
11 SET escape_string_warning = off;
12
13 SET search_path = noit, pg_catalog;
14
15 SET default_tablespace = '';
16
17 SET default_with_oids = false;
18
19 --
20 -- Name: check_status_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:
21 --
22
23 CREATE 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
33 ALTER 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
39 ALTER 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
47 CREATE 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
57 REVOKE ALL ON TABLE check_status_archive FROM PUBLIC;
58 REVOKE ALL ON TABLE check_status_archive FROM reconnoiter;
59 GRANT ALL ON TABLE check_status_archive TO reconnoiter;
60 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_status_archive TO stratcon;
61 GRANT SELECT ON TABLE check_status_archive TO prism;
62
63
64 --
65 -- PostgreSQL database dump complete
66 --
67
Note: See TracBrowser for help on using the browser.