Delete sales from Openbravo POS

openbravo_pos_sales_clearing_script.sql

delete from ticketlines;
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;

drop table ticketsnum;
CREATE TABLE ticketsnum ( ID INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (ID)) ENGINE = InnoDB;
INSERT INTO ticketsnum VALUES (DEFAULT);

drop table ticketsnum_refund;
CREATE TABLE ticketsnum_refund ( ID INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (ID)) ENGINE = InnoDB;
INSERT INTO ticketsnum_refund VALUES (DEFAULT);

drop table ticketsnum_payment;
CREATE TABLE ticketsnum_payment ( ID INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (ID)) ENGINE = InnoDB;
INSERT INTO ticketsnum_payment VALUES (DEFAULT);