CCS Point of Sale
You are here: start » system_database_reset
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
system_database_reset [2011/03/19 19:27] 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> |
1. Go to Office - Reporting - Pivot Reporting. \\ | 1. Go to Office - Reporting - Pivot Reporting. \\ | ||
Line 12: | Line 12: | ||
" | " | ||
- | DELETE FROM tblProductOrders\\ | + | DELETE FROM tblProductOrders;\\ |
- | DELETE FROM tblProductOrderTenderType\\ | + | DELETE FROM tblProductOrderTenderType;\\ |
- | DELETE FROM tblProductOrderDetails\\ | + | DELETE FROM tblProductOrderDetails;\\ |
- | DELETE FROM tblProductOrders1\\ | + | DELETE FROM tblProductOrders1;\\ |
- | DELETE FROM tblProductOrderTenderType1\\ | + | DELETE FROM tblProductOrderTenderType1;\\ |
- | DELETE FROM tblProductOrderDetails1\\ | + | 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;\\ | ||
- | DELETE FROM tblGiftCards\\ | ||
- | DELETE FROM tblClients\\ | ||
- | DELETE FROM tblEmployLogSchedule\\ | ||
" | " |