Spotter-VM/extra/graveyard/ecogis/install/createdb.sql

5 lines
213 B
MySQL
Raw Permalink Normal View History

CREATE ROLE ecogis NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${ECOGIS_PWD}';
CREATE DATABASE ecogis;
REVOKE ALL ON DATABASE ecogis FROM public;
ALTER DATABASE ecogis OWNER TO ecogis;