root/sql/scaffolding.sql

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

tweak/clean up

  • Property mode set to 100644
Line 
1 create user reconnoiter;
2 create database reconnoiter with owner = reconnoiter;
3 create user stratcon with encrypted password 'stratcon';
4 alter user stratcon set search_path to noit,public;
5 create user prism with encrypted 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/stratcon.parent_empty.sql
21 \i sprocs/stratcon.archive_part_maint.sql
22
23 \i tables/noit.check_status_changelog.sql
24 \i tables/noit.metric_numeric_rollup_config.sql
25 \i tables/noit.metric_numeric_rollup_1day.sql
26 \i tables/noit.metric_numeric_rollup_20m.sql
27 \i tables/noit.metric_numeric_rollup_30m.sql
28 \i tables/noit.metric_numeric_rollup_4h.sql
29 \i tables/noit.metric_numeric_rollup_5m.sql
30 \i tables/noit.metric_numeric_rollup_60m.sql
31 \i tables/noit.metric_numeric_rollup_queue.sql
32 \i tables/noit.metric_text_changelog.sql
33 \i tables/noit.metric_text_currently.sql
34 \i tables/noit.tasklock.sql
35 \i tables/noit.tasklock_sequence.sql
36 \i tables/stratcon.current_node_config.sql
37 \i tables/stratcon.current_node_config_changelog.sql
38 \i tables/stratcon.storage_node.sql
39 \i tables/stratcon.map_uuid_to_sid.sql
40 \i tables/prism.graph_templates.sql
41
42 \i sprocs/noit.check_archive_log_changes.sql
43 \i sprocs/noit.check_status_archive_log_changes.sql
44 \i sprocs/noit.mark_metric_numeric_rollup_buffer.sql
45 \i sprocs/noit.metric_text_archive_log_changes.sql
46 \i sprocs/noit.update_metric_summary_fulltext.sql
47 \i sprocs/noit.update_check_currently.sql
48 \i sprocs/noit.update_mns_via_check_currently.sql
49 \i sprocs/noit.update_mns_via_check_tag.sql
50 \i sprocs/noit.update_mns_via_metric_tag.sql
51 \i sprocs/noit.update_mns_via_self.sql
52 \i sprocs/stratcon.window_robust_derive.sql
53 \i sprocs/stratcon.choose_window.sql
54 \i sprocs/stratcon.unroll_metric_numeric.sql
55 \i sprocs/stratcon.fetch_dataset.sql
56 \i sprocs/stratcon.fetch_varset.sql
57 \i sprocs/stratcon.get_storage_node_for_sid.sql
58 \i sprocs/stratcon.init_metric_numeric_rollup.sql
59 \i sprocs/stratcon.map_uuid_to_sid.sql
60 \i sprocs/stratcon.update_config.sql
61 \i sprocs/stratcon.rollup_metric_numeric.sql
62 \i sprocs/stratcon.metric_name_summary_compile_fts_data.sql
63 \i sprocs/stratcon.rollup_metric_numeric.sql
64
65 \i sprocs/prism.add_graph_tags.sql
66 \i sprocs/prism.add_tags.sql
67 \i sprocs/prism.check_name_saved_graphs.sql
68 \i sprocs/prism.remove_graph_tags.sql
69 \i sprocs/prism.remove_tags.sql
70 \i sprocs/prism.saved_graphs_tsvector.sql
71 \i sprocs/prism.trig_update_tsvector_saved_graphs.sql
72
73 \i tables/noit.check_archive.sql
74 \i tables/noit.check_currently.sql
75 \i tables/noit.check_status_archive.sql
76 \i tables/noit.check_tag.sql
77 \i tables/noit.metric_name_summary.sql
78 \i tables/noit.metric_numeric_archive.sql
79 \i tables/noit.metric_tag.sql
80 \i tables/noit.metric_text_archive.sql
81 \i tables/prism.saved_graphs.sql
82 \i tables/prism.saved_graphs_dep.sql
83 \i tables/prism.saved_worksheets.sql
84 \i tables/prism.saved_worksheets_dep.sql
85
86 commit;
Note: See TracBrowser for help on using the browser.