Changeset 77e875df87c94f8cd2b8fbc32fbe360623e759b8
- Timestamp:
- 09/30/09 16:14:10 (4 years ago)
- git-parent:
- Files:
-
- sql/tables/noit.metric_numeric_rollup_12hours.sql (modified) (1 diff)
- sql/tables/noit.metric_numeric_rollup_20m.sql (modified) (1 diff)
- sql/tables/noit.metric_numeric_rollup_60m.sql (modified) (1 diff)
- sql/tables/noit.metric_numeric_rollup_6hours.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
sql/tables/noit.metric_numeric_rollup_12hours.sql
ra34bc12 r77e875d 1 -- formerly rollup_matrix_numeric_12hours 1 -- formerly rollup_matrix_numeric_12hours 2 -- 3 -- PostgreSQL database dump 4 -- 5 6 SET client_encoding = 'UTF8'; 7 SET standard_conforming_strings = off; 8 SET check_function_bodies = false; 9 SET client_min_messages = warning; 10 SET escape_string_warning = off; 11 12 SET search_path = noit, pg_catalog; 13 14 SET default_tablespace = ''; 15 16 SET default_with_oids = false; 17 18 -- 19 -- Name: metric_numeric_rollup_12hours; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 20 -- 21 22 CREATE TABLE metric_numeric_rollup_12hours ( 23 sid integer NOT NULL, 24 name text NOT NULL, 25 rollup_time timestamp with time zone NOT NULL, 26 count_rows integer[], 27 avg_value numeric[], 28 counter_dev numeric[], 29 CONSTRAINT metric_numeric_rollup_12hours_rollup_time_check CHECK (((date_part('hour'::text, timezone('UTC'::text, rollup_time)) = ANY (ARRAY[(0)::double precision, (12)::double precision])) AND (date_part('minute'::text, timezone('utc'::text, rollup_time)) = (0)::double precision))) 30 ); 31 32 33 ALTER TABLE noit.metric_numeric_rollup_12hours OWNER TO reconnoiter; 34 35 -- 36 -- Name: metric_numeric_rollup_12hours_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 37 -- 38 39 ALTER TABLE ONLY metric_numeric_rollup_12hours 40 ADD CONSTRAINT metric_numeric_rollup_12hours_pkey PRIMARY KEY (rollup_time, sid, name); 41 42 43 -- 44 -- Name: metric_numeric_rollup_12hours; Type: ACL; Schema: noit; Owner: reconnoiter 45 -- 46 47 REVOKE ALL ON TABLE metric_numeric_rollup_12hours FROM PUBLIC; 48 REVOKE ALL ON TABLE metric_numeric_rollup_12hours FROM reconnoiter; 49 GRANT ALL ON TABLE metric_numeric_rollup_12hours TO reconnoiter; 50 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_12hours TO stratcon; 51 GRANT SELECT ON TABLE metric_numeric_rollup_12hours TO prism; 52 53 54 -- 55 -- PostgreSQL database dump complete 56 -- 57 sql/tables/noit.metric_numeric_rollup_20m.sql
ra34bc12 r77e875d 1 -- formerly rollup_matrix_numberic_20m 1 -- formerly rollup_matrix_numeric_20m 2 -- 3 -- PostgreSQL database dump 4 -- 5 6 SET client_encoding = 'UTF8'; 7 SET standard_conforming_strings = off; 8 SET check_function_bodies = false; 9 SET client_min_messages = warning; 10 SET escape_string_warning = off; 11 12 SET search_path = noit, pg_catalog; 13 14 SET default_tablespace = ''; 15 16 SET default_with_oids = false; 17 18 -- 19 -- Name: metric_numeric_rollup_20m; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 20 -- 21 22 CREATE TABLE metric_numeric_rollup_20m ( 23 sid integer NOT NULL, 24 name text NOT NULL, 25 rollup_time timestamp with time zone NOT NULL, 26 count_rows integer[], 27 avg_value numeric[], 28 counter_dev numeric[] 29 ); 30 31 32 ALTER TABLE noit.metric_numeric_rollup_20m OWNER TO reconnoiter; 33 34 -- 35 -- Name: metric_numeric_rollup_20m_new_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 36 -- 37 38 ALTER TABLE ONLY metric_numeric_rollup_20m 39 ADD CONSTRAINT metric_numeric_rollup_20m_pkey PRIMARY KEY (rollup_time, sid, name); 40 41 42 -- 43 -- Name: metric_numeric_rollup_20m_rollup_time_idx; Type: INDEX; Schema: noit; Owner: reconnoiter; Tablespace: 44 -- 45 46 CREATE INDEX metric_numeric_rollup_20m_rollup_time_idx ON metric_numeric_rollup_20m USING btree (date_hour(rollup_time)); 47 48 49 -- 50 -- Name: metric_numeric_rollup_20m; Type: ACL; Schema: noit; Owner: reconnoiter 51 -- 52 53 REVOKE ALL ON TABLE metric_numeric_rollup_20m FROM PUBLIC; 54 REVOKE ALL ON TABLE metric_numeric_rollup_20m FROM reconnoiter; 55 GRANT ALL ON TABLE metric_numeric_rollup_20m TO reconnoiter; 56 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_20m TO stratcon; 57 GRANT SELECT ON TABLE metric_numeric_rollup_20m TO prism; 58 59 60 -- 61 -- PostgreSQL database dump complete 62 -- 63 sql/tables/noit.metric_numeric_rollup_60m.sql
ra34bc12 r77e875d 1 -- formerly rollup_matrix_numberic_60m 1 -- formerly rollup_matrix_numeric_60m 2 -- 3 -- PostgreSQL database dump 4 -- 5 6 SET client_encoding = 'UTF8'; 7 SET standard_conforming_strings = off; 8 SET check_function_bodies = false; 9 SET client_min_messages = warning; 10 SET escape_string_warning = off; 11 12 SET search_path = noit, pg_catalog; 13 14 SET default_tablespace = ''; 15 16 SET default_with_oids = false; 17 18 -- 19 -- Name: metric_numeric_rollup_60m; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 20 -- 21 22 CREATE TABLE metric_numeric_rollup_60m ( 23 sid integer NOT NULL, 24 name text NOT NULL, 25 rollup_time timestamp with time zone NOT NULL, 26 count_rows integer[], 27 avg_value numeric[], 28 counter_dev numeric[] 29 ); 30 31 32 ALTER TABLE noit.metric_numeric_rollup_60m OWNER TO reconnoiter; 33 34 -- 35 -- Name: metric_numeric_rollup_60m_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 36 -- 37 38 ALTER TABLE ONLY metric_numeric_rollup_60m 39 ADD CONSTRAINT metric_numeric_rollup_60m_pkey PRIMARY KEY (rollup_time, sid, name); 40 41 42 -- 43 -- Name: metric_numeric_rollup_60m; Type: ACL; Schema: noit; Owner: reconnoiter 44 -- 45 46 REVOKE ALL ON TABLE metric_numeric_rollup_60m FROM PUBLIC; 47 REVOKE ALL ON TABLE metric_numeric_rollup_60m FROM reconnoiter; 48 GRANT ALL ON TABLE metric_numeric_rollup_60m TO reconnoiter; 49 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_60m TO stratcon; 50 GRANT SELECT ON TABLE metric_numeric_rollup_60m TO prism; 51 52 53 -- 54 -- PostgreSQL database dump complete 55 -- 56 sql/tables/noit.metric_numeric_rollup_6hours.sql
ra34bc12 r77e875d 1 -- formerly rollup_matrix_numeric_6hours 1 -- formerly rollup_matrix_numeric_6hours 2 -- 3 -- PostgreSQL database dump 4 -- 5 6 SET client_encoding = 'UTF8'; 7 SET standard_conforming_strings = off; 8 SET check_function_bodies = false; 9 SET client_min_messages = warning; 10 SET escape_string_warning = off; 11 12 SET search_path = noit, pg_catalog; 13 14 SET default_tablespace = ''; 15 16 SET default_with_oids = false; 17 18 -- 19 -- Name: metric_numeric_rollup_6hours; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace: 20 -- 21 22 CREATE TABLE metric_numeric_rollup_6hours ( 23 sid integer NOT NULL, 24 name text NOT NULL, 25 rollup_time timestamp with time zone NOT NULL, 26 count_rows integer[], 27 avg_value numeric[], 28 counter_dev numeric[], 29 CONSTRAINT metric_numeric_rollup_6hours_rollup_time_check CHECK (((date_part('hour'::text, timezone('UTC'::text, rollup_time)) = ANY (ARRAY[(0)::double precision, (6)::double precision, (12)::double precision, (18)::double precision])) AND (date_part('minute'::text, timezone('utc'::text, rollup_time)) = (0)::double precision))) 30 ); 31 32 33 ALTER TABLE noit.metric_numeric_rollup_6hours OWNER TO reconnoiter; 34 35 -- 36 -- Name: metric_numeric_rollup_6hours_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace: 37 -- 38 39 ALTER TABLE ONLY metric_numeric_rollup_6hours 40 ADD CONSTRAINT metric_numeric_rollup_6hours_pkey PRIMARY KEY (rollup_time, sid, name); 41 42 -- 43 -- Name: metric_numeric_rollup_6hours; Type: ACL; Schema: noit; Owner: reconnoiter 44 -- 45 46 REVOKE ALL ON TABLE metric_numeric_rollup_6hours FROM PUBLIC; 47 REVOKE ALL ON TABLE metric_numeric_rollup_6hours FROM reconnoiter; 48 GRANT ALL ON TABLE metric_numeric_rollup_6hours TO reconnoiter; 49 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE metric_numeric_rollup_6hours TO stratcon; 50 GRANT SELECT ON TABLE metric_numeric_rollup_6hours TO prism; 51 52 53 -- 54 -- PostgreSQL database dump complete 55 -- 56