CCS Point of Sale

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
system_database_reset [2011/03/19 18:52]
markphillips 		system_database_reset [2018/12/23 03:25] (current)
Line 1: Line 1:
 ====== System Database Reset ====== ====== System Database Reset ======
  
- <​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, menu and inventory items, clients and time clock.</​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;​\\ 
 + 
 + 
 +"

Navigation

^From the Ground Up!| |[[Getting Started:]]| |[[Installation Guide:]]| |[[Pre Installation:]]| |[[Install CCS:]]| |[[Install New Database:]]| ^Guides| |[[Guides:]]| |[[FAQ:]]| |[[Trouble Shooting:]]| ^Credit Card Setup| |[[Data Cap Epay:]]| ^CCS Administration| |[[ Office:Office - General Management]]| ^CCS Terminal| |[[Office:Terminal]]| ^Hand Held Setup| |[[Hand Held:|Tablet]]| ^Kitchen Display| |[[KDS Software Setup:]]|