-- smokesignal
CREATE DATABASE smokesignal;
GRANT ALL PRIVILEGES ON DATABASE smokesignal TO postgres;

-- Connect to the smokesignal database and enable PostGIS
\c smokesignal;
CREATE EXTENSION IF NOT EXISTS postgis;
CREATE EXTENSION IF NOT EXISTS postgis_topology;