Removing Tourneys - Think I've done this right ??

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Removing Tourneys - Think I've done this right ??

Postby suls » Sun Jun 01, 2008 1:13 pm

Hi all

OK as I understand there is / was an issue with party sngs not importing correctly, what ever i have 9 that have imported into my new PT3 DB with the result as 9th everytime. 11th to 13th seem to have imported correctly.

Anyway so far as I can see removing them should be as simple as

Code: Select all
delete from tourney_holdem_summary where id_tourney < 9

delete from tourney_holdem_results where id_tourney < 9

delete from tourney_holdem_hand_summary where id_tourney < 9

delete from tourney_holdem_hand_player_statistics where id_tourney < 9


This appears to have worked fine in the front end, could anyone confirm I haven't missed anything I should have removed..

Many thanks suls
suls
 
Posts: 2
Joined: Wed May 21, 2008 1:34 pm

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 4 guests