Changeset 4bd7d843175692be84818c389d9938e7590cd487 for sql
- Timestamp:
- 10/17/09 17:51:07 (4 years ago)
- git-parent:
- Files:
-
- sql/scaffolding.sql (added)
- sql/sprocs/noit.date_hour.sql (added)
- sql/tables/noit.metric_numeric_rollup_5m.sql (modified) (3 diffs)
- sql/tables/noit.metric_tag.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
sql/tables/noit.metric_numeric_rollup_5m.sql
r4e7af00 r4bd7d84 18 18 19 19 -- 20 -- Name: metric_numeric_rollup_5m; Type: TABLE; Schema: noit; Owner: postgres; Tablespace:20 -- Name: metric_numeric_rollup_5m; Type: TABLE; Schema: noit; Owner: recnnoiter; Tablespace: 21 21 -- 22 22 … … 31 31 32 32 33 ALTER TABLE metric_numeric_rollup_5m OWNER TO postgres;33 ALTER TABLE metric_numeric_rollup_5m OWNER TO reconnoiter; 34 34 35 35 -- 36 -- Name: fmetric_numeric_rollup_5m_pkey; Type: CONSTRAINT; Schema: noit; Owner: postgres; Tablespace:36 -- Name: fmetric_numeric_rollup_5m_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 37 37 -- 38 38 … … 42 42 43 43 -- 44 -- Name: metric_numeric_rollup_5m; Type: ACL; Schema: noit; Owner: postgres44 -- Name: metric_numeric_rollup_5m; Type: ACL; Schema: noit; Owner: reconnoiter 45 45 -- 46 46 47 47 REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM PUBLIC; 48 REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM postgres; 49 GRANT ALL ON TABLE metric_numeric_rollup_5m TO postgres; 50 GRANT ALL ON TABLE metric_numeric_rollup_5m TO reconnoiter; 48 REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM reconnoiter; 51 49 GRANT SELECT ON TABLE metric_numeric_rollup_5m TO prism; 52 GRANT ALLON TABLE metric_numeric_rollup_5m TO stratcon;50 GRANT SELECT ON TABLE metric_numeric_rollup_5m TO stratcon; 53 51 54 52 sql/tables/noit.metric_tag.sql
r2b8f8c2 r4bd7d84 1 - formerly metric_tags1 -- formerly metric_tags 2 2 -- 3 3 -- PostgreSQL database dump