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 = stratcon, pg_catalog; |
---|
12 |
|
---|
13 |
SET default_tablespace = ''; |
---|
14 |
|
---|
15 |
SET default_with_oids = false; |
---|
16 |
|
---|
17 |
-- |
---|
18 |
-- Name: storage_node; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace: |
---|
19 |
-- |
---|
20 |
|
---|
21 |
CREATE TABLE storage_node ( |
---|
22 |
storage_node_id serial primary key, |
---|
23 |
total_storage bigint not null, |
---|
24 |
used_storage bigint not null, |
---|
25 |
ip text not null, |
---|
26 |
fqdn text not null, |
---|
27 |
dsn text not null, |
---|
28 |
last_updated timestamp not null default now() |
---|
29 |
); |
---|
30 |
|
---|
31 |
|
---|
32 |
ALTER TABLE stratcon.storage_node OWNER TO reconnoiter; |
---|
33 |
|
---|
34 |
|
---|
35 |
-- |
---|
36 |
-- Name: storage_node; Type: ACL; Schema: stratcon; Owner: reconnoiter |
---|
37 |
-- |
---|
38 |
|
---|
39 |
REVOKE ALL ON TABLE storage_node FROM PUBLIC; |
---|
40 |
REVOKE ALL ON TABLE storage_node FROM reconnoiter; |
---|
41 |
GRANT ALL ON TABLE storage_node TO reconnoiter; |
---|
42 |
GRANT SELECT ON TABLE storage_node TO prism; |
---|
43 |
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE storage_node TO stratcon; |
---|
44 |
|
---|
45 |
|
---|
46 |
-- |
---|
47 |
-- PostgreSQL database dump complete |
---|
48 |
-- |
---|
49 |
|
---|