Spotter-VM/lxc-apps/sambro/install/createdb.sql

9 lines
331 B
MySQL
Raw Permalink Normal View History

CREATE ROLE sambro NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${SAMBRO_PWD}';
CREATE DATABASE sambro;
REVOKE ALL ON DATABASE sambro FROM public;
ALTER DATABASE sambro OWNER TO sambro;
\c sambro;
CREATE EXTENSION postgis;
GRANT ALL ON geometry_columns TO sambro;
GRANT ALL ON spatial_ref_sys TO sambro;