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

9 lines
322 B
MySQL
Raw Permalink Normal View History

2020-04-14 14:17:21 +02:00
CREATE ROLE share NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${SHARE_PWD}';
CREATE DATABASE share;
REVOKE ALL ON DATABASE share FROM public;
ALTER DATABASE share OWNER TO share;
\c share;
CREATE EXTENSION postgis;
GRANT ALL ON geometry_columns TO share;
GRANT ALL ON spatial_ref_sys TO share;