DELETE FROM [AccountTransactions] GO DELETE FROM [CashTransactions] GO DELETE FROM [CostItems] GO DELETE FROM [Discounts] GO DELETE FROM [PaidItems] GO DELETE FROM [Payments] GO DELETE FROM [PeriodicConsumptionItems] GO DELETE FROM [PeriodicConsumptions] GO DELETE FROM [TicketItemProperties] GO DELETE FROM [TicketItems] GO DELETE FROM [Tickets] GO DELETE FROM [TransactionItems] GO DELETE FROM [Transactions] GO DELETE FROM [WorkPeriods] GO Update Numerators set Number = 0 GO Update Tables set TicketId = 0, IsTicketLocked = 0
2 answers
dtran.sql is available here without login required:
https://gist.github.com/emreeren/5806902
Either click 'Raw' and copy that SQL into your SQL manager or cick 'download gist' on the left, extract and use the .sql file
I need for version 2 this run in version3 but not in2
SambaPOS V2 dtran.sqlce file as below. From http://forum2.sambapos.org/index.php/topic,60.0.html
DELETE FROM [AccountTransactions]
GO
DELETE FROM [CashTransactions]
GO
DELETE FROM [CostItems]
GO
DELETE FROM [Discounts]
GO
DELETE FROM [PaidItems]
GO
DELETE FROM [Payments]
GO
DELETE FROM [PeriodicConsumptionItems]
GO
DELETE FROM [PeriodicConsumptions]
GO
DELETE FROM [TicketItemProperties]
GO
DELETE FROM [TicketItems]
GO
DELETE FROM [Tickets]
GO
DELETE FROM [TransactionItems]
GO
DELETE FROM [Transactions]
GO
DELETE FROM [WorkPeriods]
GO
Update Numerators set Number = 0
GO
Update Tables set TicketId = 0, IsTicketLocked = 0