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

5 lines
225 B
MySQL
Raw Permalink Normal View History

2017-10-13 09:33:26 +02:00
CREATE ROLE kanboard NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${KANBOARD_PWD}';
CREATE DATABASE kanboard;
REVOKE ALL ON DATABASE kanboard FROM public;
ALTER DATABASE kanboard OWNER TO kanboard;