CCS Point of Sale
You are here: start » system_database_reset
Differences
This shows you the differences between two versions of the page.
system_database_reset [2011/03/19 19:27] markphillips |
system_database_reset [2018/12/23 03:25] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== System Database Reset ====== | ||
- | <note important>Warning this will delete all database information of transactions, clients and time cock</note> | ||
- | |||
- | 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\\ | ||
- | " |
Trace: