Logiciel Pastèque/Remise à 0 des ventes
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 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;