Navigation

← Previous Changeset
Next Changeset →

Changeset 70d8a8f096162b8f5ef06f5668066b9e7e942814

Timestamp:

09/22/08 17:57:16 (5 years ago)

Author:

Denish Patel <denish@omniti.com>

git-committer:

Denish Patel <denish@omniti.com> 1222106236 +0000

git-parent:

[362040a384a15e91c42cc65cd4a30d2dbc5600c7]

git-author:

Denish Patel <denish@omniti.com> 1222106236 +0000

Message:

pg ddl update

Files:

sql/reconnoiter_ddl_dump.sql (modified) (70 diffs)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

sql/reconnoiter_ddl_dump.sql

r8c44e3b	r70d8a8f
10	10
11	11	--
12		-- Name: stratcon; Type: SCHEMA; Schema: -; Owner: -
	12	-- Name: stratcon; Type: SCHEMA; Schema: -; Owner: omniti
13	13	--
14	14
…	…
16	16
17	17
	18	ALTER SCHEMA stratcon OWNER TO omniti;
	19
18	20	SET search_path = stratcon, pg_catalog;
19	21
…	…
23	25
24	26	--
25		-- Name: current_metric_text; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	27	-- Name: current_metric_text; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
26	28	--
27	29
…	…
34	36
35	37
36		--
37		-- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	38	ALTER TABLE stratcon.current_metric_text OWNER TO reconnoiter;
	39
	40	--
	41	-- Name: current_node_config; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
38	42	--
39	43
…	…
46	50
47	51
48		--
49		-- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	52	ALTER TABLE stratcon.current_node_config OWNER TO reconnoiter;
	53
	54	--
	55	-- Name: current_node_config_changelog; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
50	56	--
51	57
…	…
58	64
59	65
60		--
61		-- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	66	ALTER TABLE stratcon.current_node_config_changelog OWNER TO reconnoiter;
	67
	68	--
	69	-- Name: loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
62	70	--
63	71
…	…
73	81
74	82
75		--
76		-- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	83	ALTER TABLE stratcon.loading_dock_check_s OWNER TO reconnoiter;
	84
	85	--
	86	-- Name: loading_dock_metric_numeric_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
77	87	--
78	88
…	…
85	95
86	96
87		--
88		-- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	97	ALTER TABLE stratcon.loading_dock_metric_numeric_s OWNER TO reconnoiter;
	98
	99	--
	100	-- Name: loading_dock_metric_text_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
89	101	--
90	102
…	…
97	109
98	110
99		--
100		-- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	111	ALTER TABLE stratcon.loading_dock_metric_text_s OWNER TO reconnoiter;
	112
	113	--
	114	-- Name: loading_dock_metric_text_s_change_log; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
101	115	--
102	116
…	…
109	123
110	124
111		--
112		-- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	125	ALTER TABLE stratcon.loading_dock_metric_text_s_change_log OWNER TO reconnoiter;
	126
	127	--
	128	-- Name: loading_dock_status_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
113	129	--
114	130
…	…
123	139
124	140
125		--
126		-- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	141	ALTER TABLE stratcon.loading_dock_status_s OWNER TO reconnoiter;
	142
	143	--
	144	-- Name: loading_dock_status_s_change_log; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
127	145	--
128	146
…	…
137	155
138	156
139		--
140		-- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	157	ALTER TABLE stratcon.loading_dock_status_s_change_log OWNER TO reconnoiter;
	158
	159	--
	160	-- Name: log_whence_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
141	161	--
142	162
…	…
147	167
148	168
149		--
150		-- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	169	ALTER TABLE stratcon.log_whence_s OWNER TO reconnoiter;
	170
	171	--
	172	-- Name: map_uuid_to_sid; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
151	173	--
152	174
…	…
157	179
158	180
159		--
160		-- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	181	ALTER TABLE stratcon.map_uuid_to_sid OWNER TO reconnoiter;
	182
	183	--
	184	-- Name: metric_name_summary; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
161	185	--
162	186
…	…
169	193
170	194
171		--
172		-- Name: mv_loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	195	ALTER TABLE stratcon.metric_name_summary OWNER TO reconnoiter;
	196
	197	--
	198	-- Name: mv_loading_dock_check_s; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
173	199	--
174	200
…	…
184	210
185	211
186		--
187		-- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	212	ALTER TABLE stratcon.mv_loading_dock_check_s OWNER TO reconnoiter;
	213
	214	--
	215	-- Name: rollup_matrix_numeric_12hours; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
188	216	--
189	217
…	…
197	225
198	226
199		--
200		-- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	227	ALTER TABLE stratcon.rollup_matrix_numeric_12hours OWNER TO reconnoiter;
	228
	229	--
	230	-- Name: rollup_matrix_numeric_20m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
201	231	--
202	232
…	…
210	240
211	241
212		--
213		-- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	242	ALTER TABLE stratcon.rollup_matrix_numeric_20m OWNER TO reconnoiter;
	243
	244	--
	245	-- Name: rollup_matrix_numeric_5m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
214	246	--
215	247
…	…
223	255
224	256
225		--
226		-- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	257	ALTER TABLE stratcon.rollup_matrix_numeric_5m OWNER TO reconnoiter;
	258
	259	--
	260	-- Name: rollup_matrix_numeric_60m; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
227	261	--
228	262
…	…
236	270
237	271
238		--
239		-- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	272	ALTER TABLE stratcon.rollup_matrix_numeric_60m OWNER TO reconnoiter;
	273
	274	--
	275	-- Name: rollup_matrix_numeric_6hours; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
240	276	--
241	277
…	…
249	285
250	286
251		--
252		-- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: -; Tablespace:
	287	ALTER TABLE stratcon.rollup_matrix_numeric_6hours OWNER TO reconnoiter;
	288
	289	--
	290	-- Name: rollup_runner; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:
253	291	--
254	292
…	…
259	297
260	298
261		--
262		-- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: -
	299	ALTER TABLE stratcon.rollup_runner OWNER TO reconnoiter;
	300
	301	--
	302	-- Name: choose_window(timestamp without time zone, timestamp without time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
263	303	--
264	304
…	…
309	349
310	350
311		--
312		-- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: -
	351	ALTER FUNCTION stratcon.choose_window(in_start_time timestamp without time zone, in_end_time timestamp without time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO reconnoiter;
	352
	353	--
	354	-- Name: choose_window(timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
313	355	--
314	356
…	…
359	401
360	402
361		--
362		-- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: -
	403	ALTER FUNCTION stratcon.choose_window(in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, OUT tablename text, OUT period interval, OUT nperiods integer) OWNER TO reconnoiter;
	404
	405	--
	406	-- Name: date_hour(timestamp with time zone); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
363	407	--
364	408
…	…
370	414
371	415
372		--
373		-- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: -
	416	ALTER FUNCTION stratcon.date_hour(timestamp with time zone) OWNER TO reconnoiter;
	417
	418	--
	419	-- Name: fetch_dataset(uuid, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
374	420	--
375	421
…	…
396	442
397	443
398		--
399		-- Name: fetch_dataset(integer, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: -
	444	ALTER FUNCTION stratcon.fetch_dataset(in_uuid uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) OWNER TO reconnoiter;
	445
	446	--
	447	-- Name: fetch_dataset(integer, text, timestamp with time zone, timestamp with time zone, integer, boolean); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
400	448	--
401	449
…	…
477	525
478	526
479		--
480		-- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: -
	527	ALTER FUNCTION stratcon.fetch_dataset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer, derive boolean) OWNER TO reconnoiter;
	528
	529	--
	530	-- Name: fetch_varset(uuid, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
481	531	--
482	532
…	…
498	548
499	549
500		--
501		-- Name: fetch_varset(integer, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: -
	550	ALTER FUNCTION stratcon.fetch_varset(in_check uuid, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) OWNER TO reconnoiter;
	551
	552	--
	553	-- Name: fetch_varset(integer, text, timestamp with time zone, timestamp with time zone, integer); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
502	554	--
503	555
…	…
586	638
587	639
588		--
589		-- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: -
	640	ALTER FUNCTION stratcon.fetch_varset(in_sid integer, in_name text, in_start_time timestamp with time zone, in_end_time timestamp with time zone, in_hopeful_nperiods integer) OWNER TO reconnoiter;
	641
	642	--
	643	-- Name: generate_sid_from_id(uuid); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
590	644	--
591	645
…	…
618	672
619	673
620		--
621		-- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: -
	674	ALTER FUNCTION stratcon.generate_sid_from_id(v_in_id uuid) OWNER TO reconnoiter;
	675
	676	--
	677	-- Name: loading_dock_metric_numeric_s_whence_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
622	678	--
623	679
…	…
659	715
660	716
661		--
662		-- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: -
	717	ALTER FUNCTION stratcon.loading_dock_metric_numeric_s_whence_log() OWNER TO reconnoiter;
	718
	719	--
	720	-- Name: loading_dock_metric_text_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
663	721	--
664	722
…	…
713	771
714	772
715		--
716		-- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: -
	773	ALTER FUNCTION stratcon.loading_dock_metric_text_s_change_log() OWNER TO reconnoiter;
	774
	775	--
	776	-- Name: loading_dock_status_s_change_log(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
717	777	--
718	778
…	…
748	808
749	809
750		--
751		-- Name: mv_loading_dock_check_s(); Type: FUNCTION; Schema: stratcon; Owner: -
	810	ALTER FUNCTION stratcon.loading_dock_status_s_change_log() OWNER TO reconnoiter;
	811
	812	--
	813	-- Name: mv_loading_dock_check_s(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
752	814	--
753	815
…	…
785	847
786	848
787		--
788		-- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: -
	849	ALTER FUNCTION stratcon.mv_loading_dock_check_s() OWNER TO reconnoiter;
	850
	851	--
	852	-- Name: remove_metric(uuid, text, text); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
789	853	--
790	854
…	…
891	955
892	956
893		--
894		-- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: -
	957	ALTER FUNCTION stratcon.remove_metric(in_uuid uuid, in_metric_name text, v_debug text, OUT v_out text) OWNER TO reconnoiter;
	958
	959	--
	960	-- Name: rollup_matrix_numeric_12hours(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
895	961	--
896	962
…	…
991	1057
992	1058
993		--
994		-- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: -
	1059	ALTER FUNCTION stratcon.rollup_matrix_numeric_12hours() OWNER TO reconnoiter;
	1060
	1061	--
	1062	-- Name: rollup_matrix_numeric_20m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
995	1063	--
996	1064
…	…
1095	1163
1096	1164
1097		--
1098		-- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: -
	1165	ALTER FUNCTION stratcon.rollup_matrix_numeric_20m() OWNER TO reconnoiter;
	1166
	1167	--
	1168	-- Name: rollup_matrix_numeric_5m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
1099	1169	--
1100	1170
…	…
1199	1269
1200	1270
1201		--
1202		-- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: -
	1271	ALTER FUNCTION stratcon.rollup_matrix_numeric_5m() OWNER TO reconnoiter;
	1272
	1273	--
	1274	-- Name: rollup_matrix_numeric_60m(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
1203	1275	--
1204	1276
…	…
1297	1369
1298	1370
1299		--
1300		-- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: -
	1371	ALTER FUNCTION stratcon.rollup_matrix_numeric_60m() OWNER TO reconnoiter;
	1372
	1373	--
	1374	-- Name: rollup_matrix_numeric_6hours(); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
1301	1375	--
1302	1376
…	…
1395	1469
1396	1470
1397		--
1398		-- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: -
	1471	ALTER FUNCTION stratcon.rollup_matrix_numeric_6hours() OWNER TO reconnoiter;
	1472
	1473	--
	1474	-- Name: update_config(inet, text, timestamp with time zone, xml); Type: FUNCTION; Schema: stratcon; Owner: reconnoiter
1399	1475	--
1400	1476
…	…
1426	1502
1427	1503
1428		--
1429		-- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: -
	1504	ALTER FUNCTION stratcon.update_config(v_remote_address_in inet, v_node_type_in text, v_whence_in timestamp with time zone, v_config_in xml) OWNER TO reconnoiter;
	1505
	1506	--
	1507	-- Name: seq_sid; Type: SEQUENCE; Schema: stratcon; Owner: reconnoiter
1430	1508	--
1431	1509
…	…
1437	1515
1438	1516
1439		--
1440		-- Name: current_metric_text_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1517	ALTER TABLE stratcon.seq_sid OWNER TO reconnoiter;
	1518
	1519	--
	1520	-- Name: current_metric_text_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1441	1521	--
1442	1522
…	…
1446	1526
1447	1527	--
1448		-- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1528	-- Name: current_node_config_changelog_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1449	1529	--
1450	1530
…	…
1454	1534
1455	1535	--
1456		-- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1536	-- Name: current_node_config_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1457	1537	--
1458	1538
…	…
1462	1542
1463	1543	--
1464		-- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1544	-- Name: loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1465	1545	--
1466	1546
…	…
1470	1550
1471	1551	--
1472		-- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1552	-- Name: loading_dock_metric_numeric_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1473	1553	--
1474	1554
…	…
1480	1560
1481	1561	--
1482		-- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1562	-- Name: loading_dock_metric_text_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1483	1563	--
1484	1564
…	…
1488	1568
1489	1569	--
1490		-- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1570	-- Name: loading_dock_metric_text_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1491	1571	--
1492	1572
…	…
1496	1576
1497	1577	--
1498		-- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1578	-- Name: loading_dock_status_s_change_log_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1499	1579	--
1500	1580
…	…
1504	1584
1505	1585	--
1506		-- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1586	-- Name: loading_dock_status_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1507	1587	--
1508	1588
…	…
1512	1592
1513	1593	--
1514		-- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1594	-- Name: log_whence_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1515	1595	--
1516	1596
…	…
1520	1600
1521	1601	--
1522		-- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1602	-- Name: map_uuid_to_sid_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1523	1603	--
1524	1604
…	…
1528	1608
1529	1609	--
1530		-- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1610	-- Name: metric_name_summary_pk; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1531	1611	--
1532	1612
…	…
1536	1616
1537	1617	--
1538		-- Name: mv_loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1618	-- Name: mv_loading_dock_check_s_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1539	1619	--
1540	1620
…	…
1544	1624
1545	1625	--
1546		-- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1626	-- Name: rollup_matrix_numeric_12hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1547	1627	--
1548	1628
…	…
1554	1634
1555	1635	--
1556		-- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1636	-- Name: rollup_matrix_numeric_20m_new_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1557	1637	--
1558	1638
…	…
1564	1644
1565	1645	--
1566		-- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1646	-- Name: rollup_matrix_numeric_5m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1567	1647	--
1568	1648
…	…
1574	1654
1575	1655	--
1576		-- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1656	-- Name: rollup_matrix_numeric_60m_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1577	1657	--
1578	1658
…	…
1584	1664
1585	1665	--
1586		-- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: -; Tablespace:
	1666	-- Name: rollup_matrix_numeric_6hours_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:
1587	1667	--
1588	1668
…	…
1594	1674
1595	1675	--
1596		-- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:
	1676	-- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
1597	1677	--
1598	1678
…	…
1601	1681
1602	1682	--
1603		-- Name: idx_mv_loading_dock_check_s_name; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:
	1683	-- Name: idx_mv_loading_dock_check_s_name; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
1604	1684	--
1605	1685
…	…
1608	1688
1609	1689	--
1610		-- Name: idx_mv_loading_dock_check_s_target; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:
	1690	-- Name: idx_mv_loading_dock_check_s_target; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
1611	1691	--
1612	1692
…	…
1615	1695
1616	1696	--
1617		-- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:
	1697	-- Name: idx_rollup_matrix_numeric_20m_rollup_time; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
1618	1698	--
1619	1699
…	…
1622	1702
1623	1703	--
1624		-- Name: unq_mv_loading_dock_check_s_id; Type: INDEX; Schema: stratcon; Owner: -; Tablespace:
	1704	-- Name: unq_mv_loading_dock_check_s_id; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:
1625	1705	--
1626	1706
…	…
1629	1709
1630	1710	--
1631		-- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: -
	1711	-- Name: loading_dock_metric_numeric_s_whence_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter
1632	1712	--
1633	1713
…	…
1639	1719
1640	1720	--
1641		-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: -
	1721	-- Name: loading_dock_metric_text_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter
1642	1722	--
1643	1723
…	…
1649	1729
1650	1730	--
1651		-- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: -
	1731	-- Name: loading_dock_status_s_change_log; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter
1652	1732	--
1653	1733
…	…
1659	1739
1660	1740	--
1661		-- Name: mv_loading_dock_check_s; Type: TRIGGER; Schema: stratcon; Owner: -
	1741	-- Name: mv_loading_dock_check_s; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter
1662	1742	--
1663	1743
…	…
1669	1749
1670	1750	--
1671		-- Name: stratcon; Type: ACL; Schema: -; Owner: -
	1751	-- Name: stratcon; Type: ACL; Schema: -; Owner: omniti
1672	1752	--
1673	1753
…	…
1676	1756	GRANT ALL ON SCHEMA stratcon TO omniti;
1677	1757	GRANT USAGE ON SCHEMA stratcon TO stratcon;
1678
1679
1680		--
1681		-- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: -
	1758	GRANT USAGE ON SCHEMA stratcon TO prism;
	1759
	1760
	1761	--
	1762	-- Name: current_metric_text; Type: ACL; Schema: stratcon; Owner: reconnoiter
	1763	--
	1764
	1765	REVOKE ALL ON TABLE current_metric_text FROM PUBLIC;
	1766	REVOKE ALL ON TABLE current_metric_text FROM reconnoiter;
	1767	GRANT ALL ON TABLE current_metric_text TO reconnoiter;
	1768	GRANT SELECT ON TABLE current_metric_text TO prism;
	1769	GRANT SELECT,INSERT,UPDATE ON TABLE current_metric_text TO stratcon;
	1770
	1771
	1772	--
	1773	-- Name: current_node_config; Type: ACL; Schema: stratcon; Owner: reconnoiter
	1774	--
	1775
	1776	REVOKE ALL ON TABLE current_node_config FROM PUBLIC;
	1777	REVOKE ALL ON TABLE current_node_config FROM reconnoiter;
	1778	GRANT ALL ON TABLE current_node_config TO reconnoiter;
	1779	GRANT SELECT ON TABLE current_node_config TO prism;
	1780	GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config TO stratcon;
	1781
	1782
	1783	--
	1784	-- Name: current_node_config_changelog; Type: ACL; Schema: stratcon; Owner: reconnoiter
	1785	--
	1786
	1787	REVOKE ALL ON TABLE current_node_config_changelog FROM PUBLIC;
	1788	REVOKE ALL ON TABLE current_node_config_changelog FROM reconnoiter;
	1789	GRANT ALL ON TABLE current_node_config_changelog TO reconnoiter;
	1790	GRANT SELECT ON TABLE current_node_config_changelog TO prism;
	1791	GRANT SELECT,INSERT,UPDATE ON TABLE current_node_config_changelog TO stratcon;
	1792
	1793
	1794	--
	1795	-- Name: loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
1682	1796	--
1683	1797
1684	1798	REVOKE ALL ON TABLE loading_dock_check_s FROM PUBLIC;
1685		REVOKE ALL ON TABLE loading_dock_check_s FROM omniti;
1686		GRANT ALL ON TABLE loading_dock_check_s TO omniti;
1687		GRANT SELECT,INSERT ON TABLE loading_dock_check_s TO stratcon;
1688
1689
1690		--
1691		-- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: -
	1799	REVOKE ALL ON TABLE loading_dock_check_s FROM reconnoiter;
	1800	GRANT ALL ON TABLE loading_dock_check_s TO reconnoiter;
	1801	GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_check_s TO stratcon;
	1802	GRANT SELECT ON TABLE loading_dock_check_s TO prism;
	1803
	1804
	1805	--
	1806	-- Name: loading_dock_metric_numeric_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
1692	1807	--
1693	1808
1694	1809	REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM PUBLIC;
1695		REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM omniti;
1696		GRANT ALL ON TABLE loading_dock_metric_numeric_s TO omniti;
1697		GRANT SELECT,INSERT ON TABLE loading_dock_metric_numeric_s TO stratcon;
1698
1699
1700		--
1701		-- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: -
	1810	REVOKE ALL ON TABLE loading_dock_metric_numeric_s FROM reconnoiter;
	1811	GRANT ALL ON TABLE loading_dock_metric_numeric_s TO reconnoiter;
	1812	GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_numeric_s TO stratcon;
	1813	GRANT SELECT ON TABLE loading_dock_metric_numeric_s TO prism;
	1814
	1815
	1816	--
	1817	-- Name: loading_dock_metric_text_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
1702	1818	--
1703	1819
1704	1820	REVOKE ALL ON TABLE loading_dock_metric_text_s FROM PUBLIC;
1705		REVOKE ALL ON TABLE loading_dock_metric_text_s FROM omniti;
1706		GRANT ALL ON TABLE loading_dock_metric_text_s TO omniti;
1707		GRANT SELECT,INSERT,DELETE ON TABLE loading_dock_metric_text_s TO stratcon;
1708
1709
1710		--
1711		-- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: -
	1821	REVOKE ALL ON TABLE loading_dock_metric_text_s FROM reconnoiter;
	1822	GRANT ALL ON TABLE loading_dock_metric_text_s TO reconnoiter;
	1823	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_metric_text_s TO stratcon;
	1824	GRANT SELECT ON TABLE loading_dock_metric_text_s TO prism;
	1825
	1826
	1827	--
	1828	-- Name: loading_dock_metric_text_s_change_log; Type: ACL; Schema: stratcon; Owner: reconnoiter
1712	1829	--
1713	1830
1714	1831	REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM PUBLIC;
1715		REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM omniti;
1716		GRANT ALL ON TABLE loading_dock_metric_text_s_change_log TO omniti;
1717		GRANT SELECT,INSERT ON TABLE loading_dock_metric_text_s_change_log TO stratcon;
1718
1719
1720		--
1721		-- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: -
	1832	REVOKE ALL ON TABLE loading_dock_metric_text_s_change_log FROM reconnoiter;
	1833	GRANT ALL ON TABLE loading_dock_metric_text_s_change_log TO reconnoiter;
	1834	GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_metric_text_s_change_log TO stratcon;
	1835	GRANT SELECT ON TABLE loading_dock_metric_text_s_change_log TO prism;
	1836
	1837
	1838	--
	1839	-- Name: loading_dock_status_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
1722	1840	--
1723	1841
1724	1842	REVOKE ALL ON TABLE loading_dock_status_s FROM PUBLIC;
1725		REVOKE ALL ON TABLE loading_dock_status_s FROM omniti;
1726		GRANT ALL ON TABLE loading_dock_status_s TO omniti;
1727		GRANT SELECT,INSERT ON TABLE loading_dock_status_s TO stratcon;
1728
1729
1730		--
1731		-- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: -
	1843	REVOKE ALL ON TABLE loading_dock_status_s FROM reconnoiter;
	1844	GRANT ALL ON TABLE loading_dock_status_s TO reconnoiter;
	1845	GRANT SELECT,INSERT,UPDATE ON TABLE loading_dock_status_s TO stratcon;
	1846	GRANT SELECT ON TABLE loading_dock_status_s TO prism;
	1847
	1848
	1849	--
	1850	-- Name: loading_dock_status_s_change_log; Type: ACL; Schema: stratcon; Owner: reconnoiter
1732	1851	--
1733	1852
1734	1853	REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM PUBLIC;
1735		REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM omniti;
1736		GRANT ALL ON TABLE loading_dock_status_s_change_log TO omniti;
1737		GRANT SELECT,INSERT,DELETE ON TABLE loading_dock_status_s_change_log TO stratcon;
1738
1739
1740		--
1741		-- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: -
	1854	REVOKE ALL ON TABLE loading_dock_status_s_change_log FROM reconnoiter;
	1855	GRANT ALL ON TABLE loading_dock_status_s_change_log TO reconnoiter;
	1856	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE loading_dock_status_s_change_log TO stratcon;
	1857	GRANT SELECT ON TABLE loading_dock_status_s_change_log TO prism;
	1858
	1859
	1860	--
	1861	-- Name: log_whence_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
1742	1862	--
1743	1863
1744	1864	REVOKE ALL ON TABLE log_whence_s FROM PUBLIC;
1745		REVOKE ALL ON TABLE log_whence_s FROM ~~omniti~~;
1746		GRANT ALL ON TABLE log_whence_s TO ~~omniti~~;
	1865	REVOKE ALL ON TABLE log_whence_s FROM reconnoiter;
	1866	GRANT ALL ON TABLE log_whence_s TO reconnoiter;
1747	1867	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE log_whence_s TO stratcon;
1748
1749
1750		--
1751		-- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: -
	1868	GRANT SELECT ON TABLE log_whence_s TO prism;
	1869
	1870
	1871	--
	1872	-- Name: map_uuid_to_sid; Type: ACL; Schema: stratcon; Owner: reconnoiter
1752	1873	--
1753	1874
1754	1875	REVOKE ALL ON TABLE map_uuid_to_sid FROM PUBLIC;
1755		REVOKE ALL ON TABLE map_uuid_to_sid FROM omniti;
1756		GRANT ALL ON TABLE map_uuid_to_sid TO omniti;
1757		GRANT SELECT,INSERT ON TABLE map_uuid_to_sid TO stratcon;
1758
1759
1760		--
1761		-- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: -
	1876	REVOKE ALL ON TABLE map_uuid_to_sid FROM reconnoiter;
	1877	GRANT ALL ON TABLE map_uuid_to_sid TO reconnoiter;
	1878	GRANT SELECT,INSERT,UPDATE ON TABLE map_uuid_to_sid TO stratcon;
	1879	GRANT SELECT ON TABLE map_uuid_to_sid TO prism;
	1880
	1881
	1882	--
	1883	-- Name: metric_name_summary; Type: ACL; Schema: stratcon; Owner: reconnoiter
1762	1884	--
1763	1885
1764	1886	REVOKE ALL ON TABLE metric_name_summary FROM PUBLIC;
1765		REVOKE ALL ON TABLE metric_name_summary FROM ~~omniti~~;
1766		GRANT ALL ON TABLE metric_name_summary TO ~~omniti~~;
	1887	REVOKE ALL ON TABLE metric_name_summary FROM reconnoiter;
	1888	GRANT ALL ON TABLE metric_name_summary TO reconnoiter;
1767	1889	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_name_summary TO stratcon;
1768
1769
1770		--
1771		-- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: -
	1890	GRANT SELECT ON TABLE metric_name_summary TO prism;
	1891
	1892
	1893	--
	1894	-- Name: mv_loading_dock_check_s; Type: ACL; Schema: stratcon; Owner: reconnoiter
	1895	--
	1896
	1897	REVOKE ALL ON TABLE mv_loading_dock_check_s FROM PUBLIC;
	1898	REVOKE ALL ON TABLE mv_loading_dock_check_s FROM reconnoiter;
	1899	GRANT ALL ON TABLE mv_loading_dock_check_s TO reconnoiter;
	1900	GRANT SELECT ON TABLE mv_loading_dock_check_s TO prism;
	1901	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE mv_loading_dock_check_s TO stratcon;
	1902
	1903
	1904	--
	1905	-- Name: rollup_matrix_numeric_12hours; Type: ACL; Schema: stratcon; Owner: reconnoiter
1772	1906	--
1773	1907
1774	1908	REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM PUBLIC;
1775		REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM ~~postgres~~;
1776		GRANT ALL ON TABLE rollup_matrix_numeric_12hours TO ~~postgres~~;
	1909	REVOKE ALL ON TABLE rollup_matrix_numeric_12hours FROM reconnoiter;
	1910	GRANT ALL ON TABLE rollup_matrix_numeric_12hours TO reconnoiter;
1777	1911	GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_12hours TO stratcon;
1778		GRANT SELECT~~,INSERT,DELETE ON TABLE rollup_matrix_numeric_12hours TO omniti~~;
1779
1780
1781		--
1782		-- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: -
	1912	GRANT SELECT ON TABLE rollup_matrix_numeric_12hours TO prism;
	1913
	1914
	1915	--
	1916	-- Name: rollup_matrix_numeric_20m; Type: ACL; Schema: stratcon; Owner: reconnoiter
1783	1917	--
1784	1918
1785	1919	REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM PUBLIC;
1786		REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM ~~omniti~~;
1787		GRANT ALL ON TABLE rollup_matrix_numeric_20m TO ~~omniti~~;
	1920	REVOKE ALL ON TABLE rollup_matrix_numeric_20m FROM reconnoiter;
	1921	GRANT ALL ON TABLE rollup_matrix_numeric_20m TO reconnoiter;
1788	1922	GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_20m TO stratcon;
1789
1790
1791		--
1792		-- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: -
	1923	GRANT SELECT ON TABLE rollup_matrix_numeric_20m TO prism;
	1924
	1925
	1926	--
	1927	-- Name: rollup_matrix_numeric_5m; Type: ACL; Schema: stratcon; Owner: reconnoiter
1793	1928	--
1794	1929
1795	1930	REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM PUBLIC;
1796		REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM ~~omniti~~;
1797		GRANT ALL ON TABLE rollup_matrix_numeric_5m TO ~~omniti~~;
	1931	REVOKE ALL ON TABLE rollup_matrix_numeric_5m FROM reconnoiter;
	1932	GRANT ALL ON TABLE rollup_matrix_numeric_5m TO reconnoiter;
1798	1933	GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_5m TO stratcon;
1799
1800
1801		--
1802		-- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: -
	1934	GRANT SELECT ON TABLE rollup_matrix_numeric_5m TO prism;
	1935
	1936
	1937	--
	1938	-- Name: rollup_matrix_numeric_60m; Type: ACL; Schema: stratcon; Owner: reconnoiter
1803	1939	--
1804	1940
1805	1941	REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM PUBLIC;
1806		REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM ~~omniti~~;
1807		GRANT ALL ON TABLE rollup_matrix_numeric_60m TO ~~omniti~~;
	1942	REVOKE ALL ON TABLE rollup_matrix_numeric_60m FROM reconnoiter;
	1943	GRANT ALL ON TABLE rollup_matrix_numeric_60m TO reconnoiter;
1808	1944	GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_60m TO stratcon;
1809
1810
1811		--
1812		-- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: -
	1945	GRANT SELECT ON TABLE rollup_matrix_numeric_60m TO prism;
	1946
	1947
	1948	--
	1949	-- Name: rollup_matrix_numeric_6hours; Type: ACL; Schema: stratcon; Owner: reconnoiter
1813	1950	--
1814	1951
1815	1952	REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM PUBLIC;
1816		REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM ~~omniti~~;
1817		GRANT ALL ON TABLE rollup_matrix_numeric_6hours TO ~~omniti~~;
	1953	REVOKE ALL ON TABLE rollup_matrix_numeric_6hours FROM reconnoiter;
	1954	GRANT ALL ON TABLE rollup_matrix_numeric_6hours TO reconnoiter;
1818	1955	GRANT SELECT,INSERT,DELETE ON TABLE rollup_matrix_numeric_6hours TO stratcon;
1819
1820
1821		--
1822		-- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: -
	1956	GRANT SELECT ON TABLE rollup_matrix_numeric_6hours TO prism;
	1957
	1958
	1959	--
	1960	-- Name: rollup_runner; Type: ACL; Schema: stratcon; Owner: reconnoiter
1823	1961	--
1824	1962
1825	1963	REVOKE ALL ON TABLE rollup_runner FROM PUBLIC;
1826		REVOKE ALL ON TABLE rollup_runner FROM ~~omniti~~;
1827		GRANT ALL ON TABLE rollup_runner TO ~~omniti~~;
	1964	REVOKE ALL ON TABLE rollup_runner FROM reconnoiter;
	1965	GRANT ALL ON TABLE rollup_runner TO reconnoiter;
1828	1966	GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE rollup_runner TO stratcon;
	1967	GRANT SELECT ON TABLE rollup_runner TO prism;
	1968
	1969
	1970	--
	1971	-- Name: seq_sid; Type: ACL; Schema: stratcon; Owner: reconnoiter
	1972	--
	1973
	1974	REVOKE ALL ON SEQUENCE seq_sid FROM PUBLIC;
	1975	REVOKE ALL ON SEQUENCE seq_sid FROM reconnoiter;
	1976	GRANT ALL ON SEQUENCE seq_sid TO reconnoiter;
	1977	GRANT ALL ON SEQUENCE seq_sid TO stratcon;
1829	1978
1830	1979

Navigation

Changeset 70d8a8f096162b8f5ef06f5668066b9e7e942814

Legend:

sql/reconnoiter_ddl_dump.sql

Download in other formats: