aberdalet's picture
Feb 26, 2014
7775 views
Reputation: 2

I cant't register forum2

Tags: 

Hello, i need to register forum2 to download dtran.sql to delete all transactions and i can't

2 answers

dr-spangle's picture
dr-spangle
Feb 26, 2014
Reputation: 12

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

JohnSCS's picture
JohnSCS
Feb 27, 2014
Reputation: 271

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

 

 

 

We have already answers to
1030 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634