--
-- PostgreSQL database dump
--

DROP SCHEMA  IF EXISTS stats_history CASCADE;
CREATE SCHEMA stats_history;
ALTER SCHEMA stats_history OWNER TO sqoop;

--
-- Name: query; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE stats_history.query (
    query text,
    description text,
    query_id text
);

alter table stats_history.query owner to sqoop;
--
-- Name: value; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE stats_history.value (
    num text,
    date text,
    query_id text
);

alter table stats_history.value owner to sqoop;


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

--REVOKE ALL ON SCHEMA stats_history FROM PUBLIC;
--REVOKE ALL ON SCHEMA stats_history FROM sqoop;
--GRANT ALL ON SCHEMA stats_history TO sqoop;
--GRANT ALL ON SCHEMA stats_history TO PUBLIC;


--
-- PostgreSQL database dump complete
--