root / snf-deploy / files / tmp / db-init.psql @ 6947964f
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%; |