| 1 | | -- formerly loading_dock_check_s |
|---|
| | 1 | -- |
|---|
| | 2 | -- PostgreSQL database dump |
|---|
| | 3 | -- |
|---|
| | 4 | |
|---|
| | 5 | SET client_encoding = 'UTF8'; |
|---|
| | 6 | SET standard_conforming_strings = off; |
|---|
| | 7 | SET check_function_bodies = false; |
|---|
| | 8 | SET client_min_messages = warning; |
|---|
| | 9 | SET escape_string_warning = off; |
|---|
| | 10 | |
|---|
| | 11 | SET search_path = noit, pg_catalog; |
|---|
| | 12 | |
|---|
| | 13 | SET default_tablespace = ''; |
|---|
| | 14 | |
|---|
| | 15 | SET default_with_oids = false; |
|---|
| | 16 | |
|---|
| | 17 | -- |
|---|
| | 18 | -- Name: check_archive; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: |
|---|
| | 19 | -- |
|---|
| | 20 | |
|---|
| | 21 | CREATE 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 | |
|---|
| | 32 | ALTER TABLE noit.check_archive OWNER TO reconnoiter; |
|---|
| | 33 | |
|---|
| | 34 | -- |
|---|
| | 35 | -- Name: check_archive_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: |
|---|
| | 36 | -- |
|---|
| | 37 | |
|---|
| | 38 | ALTER 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 | |
|---|
| | 46 | CREATE 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 | |
|---|
| | 56 | REVOKE ALL ON TABLE check_archive FROM PUBLIC; |
|---|
| | 57 | REVOKE ALL ON TABLE check_archive FROM reconnoiter; |
|---|
| | 58 | GRANT ALL ON TABLE check_archive TO reconnoiter; |
|---|
| | 59 | GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_archive TO noit; |
|---|
| | 60 | GRANT SELECT ON TABLE check_archive TO prism; |
|---|
| | 61 | |
|---|
| | 62 | |
|---|
| | 63 | -- |
|---|
| | 64 | -- PostgreSQL database dump complete |
|---|
| | 65 | -- |
|---|
| | 66 | |
|---|
