diff options
-rwxr-xr-x | generation/query.sh | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/generation/query.sh b/generation/query.sh new file mode 100755 index 0000000..957fb62 --- /dev/null +++ b/generation/query.sh @@ -0,0 +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 |