diff options
| author | Frédéric Guillot <fred@kanboard.net> | 2018-12-19 16:01:50 -0800 |
|---|---|---|
| committer | Frédéric Guillot <fred@kanboard.net> | 2018-12-19 16:01:50 -0800 |
| commit | f070ad87d6ff33b5fb18fa13463955d93cf08a4d (patch) | |
| tree | f8a25e2ce31821e34ed89efd17db5de7701d22e3 /Makefile | |
| parent | 5238f0bc99ad693ab1af69f4eff6d08facf4cb5e (diff) | |
Update SQL dumps
Diffstat (limited to 'Makefile')
| -rw-r--r-- | Makefile | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -53,7 +53,7 @@ integration-test-sqlite: @ docker-compose -f tests/docker/compose.integration.sqlite.yaml down sql: - @ pg_dump --schema-only --no-owner --no-privileges --quote-all-identifiers -n public --file app/Schema/Sql/postgres.sql kanboard + @ pg_dump -x -O --schema-only --no-owner --no-privileges --quote-all-identifiers -n public --file app/Schema/Sql/postgres.sql kanboard @ pg_dump -d kanboard --column-inserts --data-only --table settings >> app/Schema/Sql/postgres.sql @ pg_dump -d kanboard --column-inserts --data-only --table links >> app/Schema/Sql/postgres.sql @@ -61,7 +61,7 @@ sql: @ mysqldump -uroot --quote-names --no-create-info --skip-comments --no-set-names kanboard settings >> app/Schema/Sql/mysql.sql @ mysqldump -uroot --quote-names --no-create-info --skip-comments --no-set-names kanboard links >> app/Schema/Sql/mysql.sql - @ php -r "echo 'INSERT INTO users (username, password, role) VALUES (\'admin\', \''.password_hash('admin', PASSWORD_DEFAULT).'\', \'app-admin\');';" | \ + @ php -r "echo 'INSERT INTO users (username, password, role) VALUES (\'admin\', \''.password_hash('admin', PASSWORD_DEFAULT).'\', \'app-admin\');'.PHP_EOL;" | \ tee -a app/Schema/Sql/postgres.sql app/Schema/Sql/mysql.sql >/dev/null @ let mysql_version=`echo 'select version from schema_version;' | mysql -N -uroot kanboard` ;\ |