root/sql/scaffolding.sql

Revision b2014c0dfb34073e61a3e9f96a38d772a8f31a1c, 2.2 kB (checked in by Theo Schlossnagle <jesus@omniti.com>, 5 years ago)

fix these up to take th noit through

  • Property mode set to 100644
Line 
1 create user reconnoiter with createuser;
2 create database reconnoiter with owner = reconnoiter;
3 create user stratcon with unencrypted password 'stratcon';
4 create user prism with unencrypted password 'prism';
5 \c reconnoiter reconnoiter;
6 begin;
7
8 create language plpgsql;
9 create schema noit;
10 create schema stratcon;
11 create schema prism;
12 grant usage on schema stratcon to stratcon;
13 grant usage on schema stratcon to prism;
14 grant usage on schema noit to stratcon;
15 grant usage on schema noit to prism;
16 grant usage on schema prism to prism;
17
18 \i sprocs/noit.date_hour.sql
19
20 \i tables/noit.check_status_changelog.sql
21 \i tables/noit.metric_numeric_rollup_12hours.sql
22 \i tables/noit.metric_numeric_rollup_20m.sql
23 \i tables/noit.metric_numeric_rollup_5m.sql
24 \i tables/noit.metric_numeric_rollup_60m.sql
25 \i tables/noit.metric_numeric_rollup_6hours.sql
26 \i tables/noit.metric_numeric_rollup_queue.sql
27 \i tables/noit.metric_text_changelog.sql
28 \i tables/noit.metric_text_currently.sql
29 \i tables/noit.tasklock.sql
30 \i tables/noit.tasklock_sequence.sql
31 \i tables/stratcon.current_node_config.sql
32 \i tables/stratcon.current_node_config_changelog.sql
33 \i tables/stratcon.storage_node.sql
34 \i tables/stratcon.map_uuid_to_sid.sql
35
36 \i sprocs/noit.check_archive_log_changes.sql
37 \i sprocs/noit.check_status_archive_log_changes.sql
38 \i sprocs/noit.mark_metric_numeric_rollup_buffer.sql
39 \i sprocs/noit.metric_text_archive_log_changes.sql
40 \i sprocs/noit.update_metric_summary_fulltext.sql
41 \i sprocs/noit.update_mns_via_check_tag.sql
42 \i sprocs/noit.update_mns_via_metric_tag.sql
43 \i sprocs/noit.update_mns_via_self.sql
44 \i sprocs/stratcon.choose_window.sql
45 \i sprocs/stratcon.fetch_dataset.sql
46 \i sprocs/stratcon.fetch_varset.sql
47 \i sprocs/stratcon.get_storage_node_for_sid.sql
48 \i sprocs/stratcon.init_metric_numeric_rollup_5m.sql
49 \i sprocs/stratcon.map_uuid_to_sid.sql
50 \i sprocs/stratcon.metric_name_summary_tsvector.sql
51 \i sprocs/stratcon.window_robust_derive.sql
52 \i sprocs/stratcon.update_config.sql
53
54 \i tables/noit.check_archive.sql
55 \i tables/noit.check_currently.sql
56 \i tables/noit.check_status_archive.sql
57 \i tables/noit.check_tag.sql
58 \i tables/noit.metric_name_summary.sql
59 \i tables/noit.metric_numeric_archive.sql
60 \i tables/noit.metric_tag.sql
61 \i tables/noit.metric_text_archive.sql
62
63 commit;
Note: See TracBrowser for help on using the browser.