 
 
 --
+-- Name: websubmission_driver; Type: ACL; Schema: stage; Owner: carpool_admins
+--
+
+REVOKE ALL ON TABLE websubmission_driver FROM PUBLIC;
+REVOKE ALL ON TABLE websubmission_driver FROM carpool_admins;
+GRANT ALL ON TABLE websubmission_driver TO carpool_admins;
+GRANT SELECT,INSERT ON TABLE websubmission_driver TO carpool_web_role;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE websubmission_driver TO carpool_role;
+
+
+--
+-- Name: websubmission_driver.UUID; Type: ACL; Schema: stage; Owner: carpool_admins
+--
+
+REVOKE ALL("UUID") ON TABLE websubmission_driver FROM PUBLIC;
+REVOKE ALL("UUID") ON TABLE websubmission_driver FROM carpool_admins;
+GRANT SELECT("UUID") ON TABLE websubmission_driver TO carpool_web;
+
+
+--
 -- Name: vw_drive_offer; Type: ACL; Schema: stage; Owner: carpool_admins
 --
 


ALTER FUNCTION stage.create_riders() OWNER TO carpool_admins;

SET search_path = import, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: zip_code_database_commercial; Type: TABLE; Schema: import; Owner: eric
--

CREATE TABLE zip_code_database_commercial (
    zip text,
    type text,
    decommissioned text,
    primary_city text,
    acceptable_cities text,
    unacceptable_cities text,
    state text,
    county text,
    timezone text,
    area_codes text,
    world_region text,
    country text,
    latitude text,
    longitude text,
    precise_latitude text,
    precise_longitude text,
    latitude_min text,
    latitude_max text,
    longitude_min text,
    longitude_max text,
    area_land text,
    housing_count text,
    estimated_households_2005 text,
    estimated_households_2006 text,
    estimated_households_2007 text,
    estimated_households_2008 text,
    estimated_households_2009 text,
    estimated_households_2010 text,
    estimated_households_2011 text,
    estimated_households_2012 text,
    estimated_households_2013 text,
    estimated_households_2014 text,
    population_count text,
    estimated_population_2005 text,
    estimated_population_2006 text,
    estimated_population_2007 text,
    estimated_population_2008 text,
    estimated_population_2009 text,
    estimated_population_2010 text,
    estimated_population_2011 text,
    estimated_population_2012 text,
    estimated_population_2013 text,
    estimated_population_2014 text,
    white text,
    black_or_african_american text,
    american_indian_or_alaskan_native text,
    asian text,
    native_hawaiian_and_other_pacific_islander text,
    other_race text,
    two_or_more_races text,
    total_male_population text,
    total_female_population text,
    pop_under_10 text,
    pop_10_to_19 text,
    pop_20_to_29 text,
    pop_30_to_39 text,
    pop_40_to_49 text,
    pop_50_to_59 text,
    pop_60_to_69 text,
    pop_70_to_79 text,
    pop_80_plus text,
    percent_population_in_poverty text,
    median_earnings_past_year text,
    median_household_income text,
    median_gross_rent text,
    median_home_value text,
    percent_high_school_graduate text,
    percent_bachelors_degree text,
    percent_graduate_degree text
);


ALTER TABLE zip_code_database_commercial OWNER TO eric;

SET search_path = nov2016, pg_catalog;

--
-- Name: driver; Type: TABLE; Schema: nov2016; Owner: carpool_admins

GRANT ALL ON TABLE zip_codes TO carpool_role;


--
-- Name: zipcode_dist; Type: ACL; Schema: nov2016; Owner: carpool_admins
--

REVOKE ALL ON TABLE zipcode_dist FROM PUBLIC;
REVOKE ALL ON TABLE zipcode_dist FROM carpool_admins;
GRANT ALL ON TABLE zipcode_dist TO carpool_admins;
GRANT ALL ON TABLE zipcode_dist TO carpool_role;


SET search_path = stage, pg_catalog;

--
