Mise à jour des scripts de stats de la bade bde vers la base note

[scripts-20-100.git] / bde / stats / soldes.sh

diff --git a/bde/stats/soldes.sh b/bde/stats/soldes.sh
index 37d9a71ec2c976a5abe5967cd2cd57cc9c157d35..027056c1e81977df6099e12c4015dc80a8ece6a0 100755 (executable)
--- a/bde/stats/soldes.sh
+++ b/bde/stats/soldes.sh
@@ -4,8 +4,8 @@
 
 if [[ "$1" = "--no-club" ]]
 then
-    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents WHERE NOT club ORDER BY solde DESC;"
+    psql note -c "SELECT nom, prenom, pseudo, solde FROM comptes WHERE type!='club' ORDER BY solde DESC;"
 else
-    psql bde -c "SELECT nom, prenom, pseudo, solde FROM adherents ORDER BY solde DESC;"
+    psql note -c "SELECT nom, prenom, pseudo, solde FROM comptes ORDER BY solde DESC;"
 fi