Delete all playernotes

[Olaf72]

Is there a way to delete all playernotes from a PT3 Database via a SQL?

[WhiteRider]

I don't think there's a simple query because the notes are linked into other tables in the database, but I'll see if I can find out for you.

[kraada]

There is:

TRUNCATE TABLE notes;

[kraada]

I realized I forgot a couple of other queries you might want to run. That query blanks out all notes, but there are still flags set for notes on individual hands and players.

To change it to false for all players run:

UPDATE player SET flg_note = FALSE;

To set it to false for all hands run:

UPDATE holdem_hand_summary SET flg_note = FALSE;

(that's for holdem cash hands, for tournament or omaha hands change the table accordingly)