CCS Point of Sale
You are here: start » system_database_reset
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
system_database_reset [2011/03/19 18:51] markphillips created |
system_database_reset [2011/03/19 19:32] markphillips |
||
---|---|---|---|
Line 3: | Line 3: | ||
<note important>Warning this will delete all database information of transactions, clients and time cock</note> | <note important>Warning this will delete all database information of transactions, clients and time cock</note> | ||
- | DELETE FROM tblProductOrders | + | 1. Go to Office - Reporting - Pivot Reporting. \\ |
- | DELETE FROM tblProductOrderTenderType | + | |
- | DELETE FROM tblProductOrderDetails | + | |
- | DELETE FROM tblProductOrders1 | + | 2. Select the 'Advanced Tab'\\ |
- | DELETE FROM tblProductOrderTenderType1 | + | |
- | DELETE FROM tblProductOrderDetails1 | + | |
- | DELETE FROM tblGiftCards | + | 3. Paste this quoted information in the text box below, without the quotes. \\ |
- | DELETE FROM tblClients | + | |
- | DELETE FROM tblEmployLogSchedule | + | 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: