diff options
| -rwxr-xr-x | generation/query.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/generation/query.sh b/generation/query.sh index 957fb62..67accaf 100755 --- a/generation/query.sh +++ b/generation/query.sh @@ -1 +1 @@ -sqlite3 ../shop.db "SELECT id,firstname,lastname FROM users LEFT JOIN authentication ON users.id = authentication.user WHERE (disabled IS NULL or disabled != 1) and id > 0" | sed "s~|~,~g" > users.csv +sqlite3 shop.db "SELECT id,firstname,lastname FROM users LEFT JOIN authentication ON users.id = authentication.user WHERE (users.disabled IS NULL or users.disabled != 1) and id > 0" | sed "s~|~,~g" > users.csv |