CCS Point of Sale
You are here: start » system_database_reset
System Database Reset
1. Go to Office - Reporting - Pivot Reporting.
2. Select the 'Advanced Tab'
3. Paste this quoted information in the text box below, without the quotes.
4. Then press the 'Open From SQL Statement' button. You will receive an error, press abort. Check your menu, transaction and payroll history.
“
DELETE FROM tblProductOrders;
DELETE FROM tblProductOrderTenderType;
DELETE FROM tblProductOrderDetails;
DELETE FROM tblProductOrders1;
DELETE FROM tblProductOrderTenderType1;
DELETE FROM tblProductOrderDetails1;
DELETE FROM tblGiftCards;
DELETE FROM tblClients;
DELETE FROM tblEmployLogSchedule;
DELETE FROM tblMenuItems;
DELETE FROM tblProductPricing;
DELETE FROM tblProductPriceCategory;
DELETE FROM tblUnitType;
DELETE FROM tblXZRunReportStorage;
DELETE FROM tblErrorLog;
”
Trace: • system_database_reset