1 |
create user reconnoiter with createuser; |
---|
2 |
create database reconnoiter with owner = reconnoiter; |
---|
3 |
create user stratcon with unencrypted password 'stratcon'; |
---|
4 |
alter user stratcon set search_path to noit,public; |
---|
5 |
create user prism with unencrypted password 'prism'; |
---|
6 |
alter user prism set search_path to noit,public; |
---|
7 |
\c reconnoiter reconnoiter; |
---|
8 |
begin; |
---|
9 |
|
---|
10 |
create language plpgsql; |
---|
11 |
create schema noit; |
---|
12 |
create schema stratcon; |
---|
13 |
create schema prism; |
---|
14 |
grant usage on schema stratcon to stratcon; |
---|
15 |
grant usage on schema stratcon to prism; |
---|
16 |
grant usage on schema noit to stratcon; |
---|
17 |
grant usage on schema noit to prism; |
---|
18 |
grant usage on schema prism to prism; |
---|
19 |
|
---|
20 |
\i sprocs/noit.date_hour.sql |
---|
21 |
|
---|
22 |
\i tables/noit.check_status_changelog.sql |
---|
23 |
\i tables/noit.metric_numeric_rollup_config.sql |
---|
24 |
\i tables/noit.metric_numeric_rollup_12hours.sql |
---|
25 |
\i tables/noit.metric_numeric_rollup_20m.sql |
---|
26 |
\i tables/noit.metric_numeric_rollup_5m.sql |
---|
27 |
\i tables/noit.metric_numeric_rollup_60m.sql |
---|
28 |
\i tables/noit.metric_numeric_rollup_6hours.sql |
---|
29 |
\i tables/noit.metric_numeric_rollup_queue.sql |
---|
30 |
\i tables/noit.metric_text_changelog.sql |
---|
31 |
\i tables/noit.metric_text_currently.sql |
---|
32 |
\i tables/noit.tasklock.sql |
---|
33 |
\i tables/noit.tasklock_sequence.sql |
---|
34 |
\i tables/stratcon.current_node_config.sql |
---|
35 |
\i tables/stratcon.current_node_config_changelog.sql |
---|
36 |
\i tables/stratcon.storage_node.sql |
---|
37 |
\i tables/stratcon.map_uuid_to_sid.sql |
---|
38 |
\i tables/prism.graph_templates.sql |
---|
39 |
|
---|
40 |
\i sprocs/noit.check_archive_log_changes.sql |
---|
41 |
\i sprocs/noit.check_status_archive_log_changes.sql |
---|
42 |
\i sprocs/noit.mark_metric_numeric_rollup_buffer.sql |
---|
43 |
\i sprocs/noit.metric_text_archive_log_changes.sql |
---|
44 |
\i sprocs/noit.update_metric_summary_fulltext.sql |
---|
45 |
\i sprocs/noit.update_check_currently.sql |
---|
46 |
\i sprocs/noit.update_mns_via_check_currently.sql |
---|
47 |
\i sprocs/noit.update_mns_via_check_tag.sql |
---|
48 |
\i sprocs/noit.update_mns_via_metric_tag.sql |
---|
49 |
\i sprocs/noit.update_mns_via_self.sql |
---|
50 |
\i sprocs/stratcon.choose_window.sql |
---|
51 |
\i sprocs/stratcon.unroll_metric_numeric.sql |
---|
52 |
\i sprocs/stratcon.fetch_dataset.sql |
---|
53 |
\i sprocs/stratcon.fetch_varset.sql |
---|
54 |
\i sprocs/stratcon.get_storage_node_for_sid.sql |
---|
55 |
\i sprocs/stratcon.init_metric_numeric_rollup_5m.sql |
---|
56 |
\i sprocs/stratcon.map_uuid_to_sid.sql |
---|
57 |
\i sprocs/stratcon.window_robust_derive.sql |
---|
58 |
\i sprocs/stratcon.update_config.sql |
---|
59 |
\i sprocs/stratcon.rollup_metric_numeric_5m.sql |
---|
60 |
\i sprocs/stratcon.metric_name_summary_compile_fts_data.sql |
---|
61 |
|
---|
62 |
\i sprocs/prism.add_graph_tags.sql |
---|
63 |
\i sprocs/prism.add_tags.sql |
---|
64 |
\i sprocs/prism.check_name_saved_graphs.sql |
---|
65 |
\i sprocs/prism.remove_graph_tags.sql |
---|
66 |
\i sprocs/prism.remove_tags.sql |
---|
67 |
\i sprocs/prism.saved_graphs_tsvector.sql |
---|
68 |
\i sprocs/prism.trig_update_tsvector_saved_graphs.sql |
---|
69 |
|
---|
70 |
\i tables/noit.check_archive.sql |
---|
71 |
\i tables/noit.check_currently.sql |
---|
72 |
\i tables/noit.check_status_archive.sql |
---|
73 |
\i tables/noit.check_tag.sql |
---|
74 |
\i tables/noit.metric_name_summary.sql |
---|
75 |
\i tables/noit.metric_numeric_archive.sql |
---|
76 |
\i tables/noit.metric_tag.sql |
---|
77 |
\i tables/noit.metric_text_archive.sql |
---|
78 |
\i tables/prism.saved_graphs.sql |
---|
79 |
\i tables/prism.saved_graphs_dep.sql |
---|
80 |
\i tables/prism.saved_worksheets.sql |
---|
81 |
\i tables/prism.saved_worksheets_dep.sql |
---|
82 |
|
---|
83 |
commit; |
---|