Logiciel Pastèque/Remise à 0 des ventes

Un livre de Wikilivres.
Sauter à la navigation Sauter à la recherche

Après un test du logiciel, on peut souhaiter remettre à 0 les ventes. L’opération se fait via une série de requêtes sur la base de données

MySQL[modifier | modifier le wikicode]

 DELETE FROM TICKETLINES;
 DELETE FROM TICKETS;
 DELETE FROM TAXLINES;
 DELETE FROM PAYMENTS;
 DELETE FROM STOCKDIARY;
 DELETE FROM STOCKCURRENT;
 DELETE FROM RESERVATION_CUSTOMERS;
 DELETE FROM RESERVATIONS;
 DELETE FROM RECEIPTS;
 DELETE FROM CLOSEDCASH;
 UPDATE PRODUCTS SET STOCKCOST=0, STOCKVOLUME=0;
 UPDATE CUSTOMERS SET CURDEBT=0, CURDATE=NULL, PREPAID=0;
 UPDATE CASHREGISTERS SET NEXTTICKETID=0 WHERE 1=1;

PostgreSQL[modifier | modifier le wikicode]