Statistics
| Branch: | Tag: | Revision:

root / snf-deploy / files / tmp / db-init.psql @ 30761818

History | View | Annotate | Download (432 Bytes)

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%;
4
GRANT ALL PRIVILEGES ON DATABASE snf_apps TO %SYNNEFO_USER%;
5

    
6
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; OWNER=%SYNNEFO_USER%;
7
GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO %SYNNEFO_USER%;