aboutsummaryrefslogtreecommitdiffstats
path: root/tests/travis/prepare_pgsql.sh
diff options
context:
space:
mode:
authorKlaus Weidenbach <Klaus.Weidenbach@gmx.net>2018-01-29 21:14:03 +0100
committerKlaus Weidenbach <Klaus.Weidenbach@gmx.net>2018-01-29 22:01:40 +0100
commit210c91398da573d3c44bd1ff5bee4c65128c8686 (patch)
treeed2b3779598108f1789b3c37b4be104e79a5c472 /tests/travis/prepare_pgsql.sh
parent4bf0c9e36a4a89d6b84c6bf8a74124603add9d9e (diff)
downloadvolse-hubzilla-210c91398da573d3c44bd1ff5bee4c65128c8686.tar.gz
volse-hubzilla-210c91398da573d3c44bd1ff5bee4c65128c8686.tar.bz2
volse-hubzilla-210c91398da573d3c44bd1ff5bee4c65128c8686.zip
Make it little bit less likely to erase a real database.
Changed the default PHPUnit database environment variables to make it little bit less likely to truncate accidently a real database.
Diffstat (limited to 'tests/travis/prepare_pgsql.sh')
-rwxr-xr-xtests/travis/prepare_pgsql.sh14
1 files changed, 7 insertions, 7 deletions
diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh
index 3c38ef60c..0175b9858 100755
--- a/tests/travis/prepare_pgsql.sh
+++ b/tests/travis/prepare_pgsql.sh
@@ -33,17 +33,17 @@ psql --version
psql -U postgres -c "SELECT VERSION();"
# Create Hubzilla database
-psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;"
+psql -U postgres -c "DROP DATABASE IF EXISTS travis_hubzilla;"
psql -U postgres -v ON_ERROR_STOP=1 <<-EOSQL
- CREATE USER hubzilla WITH PASSWORD 'hubzilla';
- CREATE DATABASE hubzilla;
- ALTER DATABASE hubzilla OWNER TO hubzilla;
- GRANT ALL PRIVILEGES ON DATABASE hubzilla TO hubzilla;
+ CREATE USER travis_hz WITH PASSWORD 'hubzilla';
+ CREATE DATABASE travis_hubzilla;
+ ALTER DATABASE travis_hubzilla OWNER TO travis_hz;
+ GRANT ALL PRIVILEGES ON DATABASE travis_hubzilla TO travis_hz;
EOSQL
# Import table structure
-psql -U hubzilla -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql
+psql -U travis_hz -v ON_ERROR_STOP=1 travis_hubzilla < ./install/schema_postgres.sql
# Show databases and tables
psql -U postgres -l
-psql -U postgres -d hubzilla -c "\dt;"
+psql -U postgres -d travis_hubzilla -c "\dt;"