root/sql/tables/stratcon.storage_node.sql

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

map table plus placeholders for upcoming schema

  • Property mode set to 100644
Line 
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
Note: See TracBrowser for help on using the browser.