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

8 lines
334 B
MySQL
Raw Permalink Normal View History

2018-04-21 22:30:25 +02:00
CREATE ROLE crisiscleanup NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${CRISISCLEANUP_PWD}';
CREATE DATABASE crisiscleanup;
REVOKE ALL ON DATABASE crisiscleanup FROM public;
ALTER DATABASE crisiscleanup OWNER TO crisiscleanup;
\c crisiscleanup
CREATE EXTENSION hstore;
CREATE EXTENSION pg_stat_statements;