--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: bigbrother; Type: SCHEMA; Schema: -; Owner: bigbrother
--

CREATE SCHEMA bigbrother;


ALTER SCHEMA bigbrother OWNER TO bigbrother;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: bigbrother
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

--
-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: pgsql
--

CREATE FUNCTION plpgsql_call_handler() RETURNS opaque
    AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler'
    LANGUAGE c;


ALTER FUNCTION public.plpgsql_call_handler() OWNER TO pgsql;

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

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM bigbrother;
GRANT ALL ON SCHEMA public TO bigbrother;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--