-- integrating scores, modify schemas and extensions for postgis

CREATE SCHEMA tiger;
CREATE SCHEMA topology;

CREATE EXTENSION IF NOT EXISTS fuzzystrmatch WITH SCHEMA public;
--CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; -- don't use this anymore
--CREATE EXTENSION IF NOT EXISTS postgis_tiger_geocoder WITH SCHEMA tiger; -- don't use this anymore
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology;

set search_path to 'public';
