scripts bde : passage à la nouvelle base de données (seulement certains)

[scripts-20-100.git] / bde / transactions.sh

diff --git a/bde/transactions.sh b/bde/transactions.sh
index f7d4b0024d3e233b93267109b81bfed89adcd1c6..f2140855795be12680b07142fe29c177d646d6e0 100755 (executable)
--- a/bde/transactions.sh
+++ b/bde/transactions.sh
@@ -4,9 +4,9 @@
 
 export LESS='-S'
 
-psql bde -c "
-   SELECT t.id,t.date,t.quantite,t.montant,t.remarque,t.valide,t.emetteur,t.destinataire,
+psql note -c "
+   SELECT t.id,t.date,t.quantite,t.montant,t.description,t.valide,t.emetteur,t.destinataire,
           adhe.pseudo AS emetteur, adhd.pseudo AS destinataire
-   FROM transactions AS t, adherents AS adhe, adherents AS adhd
-   WHERE $1 in (emetteur, destinataire) AND t.emetteur=adhe.numcbde AND t.destinataire=adhd.numcbde AND valide
+   FROM transactions AS t, comptes AS adhe, comptes AS adhd
+   WHERE $1 in (emetteur, destinataire) AND t.emetteur=adhe.idbde AND t.destinataire=adhd.idbde AND valide
    ORDER BY date DESC;"