Hi,
I finished installing it :-)
I was doing some silly testing and training myself; making fake tickets, payments, voids etc. Now I am stack with all these data that show-up in the reports and everything. I wish to start a new (but I do not want to redo the menu). Can anyone help me clear the data.
Thanks a bunch
Sara
Clearing database (3 posts)
I have a friend for whom I am working on Floreant. She has the same issue. I have done this by hand using SQL Workbench to connect to the Derby database and running delete commands.
The problem is running them in the right order (I.E. you need to delete all items from the ticket before you can delete the ticket). I plan on writing an SQL script that does everything in the proper order, but I have not gotten around to it yet (Relatively low priority vs getting everything working =) ). I will post back here once I write the script.
The problem is running them in the right order (I.E. you need to delete all items from the ticket before you can delete the ticket). I plan on writing an SQL script that does everything in the proper order, but I have not gotten around to it yet (Relatively low priority vs getting everything working =) ). I will post back here once I write the script.
Just make sure you do a
SET FOREIGN_KEY_CHECKS=0;
and then delete all transactions,ticket,ticket_item, drawer_pull_report , etc.etc. tables.
SET FOREIGN_KEY_CHECKS=0;
and then delete all transactions,ticket,ticket_item, drawer_pull_report , etc.etc. tables.
Log in to reply this topic