Statistics
| Branch: | Tag: | Revision:

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

History | View | Annotate | Download (512 Bytes)

1 6947964f Christos Stavrakakis
UPDATE pg_database SET datctype='C', datcollate='C' WHERE datname='template1';
2 6947964f Christos Stavrakakis
3 30761818 Christos Stavrakakis
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%' CREATEDB;
4 30761818 Christos Stavrakakis
5 30761818 Christos Stavrakakis
CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0 OWNER=%SYNNEFO_USER%;
6 0ac84a9a Dimitris Aragiorgis
GRANT ALL PRIVILEGES ON DATABASE snf_apps TO %SYNNEFO_USER%;
7 0ac84a9a Dimitris Aragiorgis
8 30761818 Christos Stavrakakis
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; OWNER=%SYNNEFO_USER%;
9 0ac84a9a Dimitris Aragiorgis
GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO %SYNNEFO_USER%;