Revision 30761818
b/snf-deploy/files/tmp/db-init.psql | ||
---|---|---|
1 |
CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; |
|
2 |
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%'; |
|
1 |
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%' CREATEDB; |
|
2 |
|
|
3 |
CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0 OWNER=%SYNNEFO_USER%; |
|
3 | 4 |
GRANT ALL PRIVILEGES ON DATABASE snf_apps TO %SYNNEFO_USER%; |
4 | 5 |
|
5 |
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; |
|
6 |
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; OWNER=%SYNNEFO_USER%;
|
|
6 | 7 |
GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO %SYNNEFO_USER%; |
Also available in: Unified diff