[rvg72]

[ QUOTE ]
looks pretty nice [img]/images/graemlins/smile.gif[/img]

can you post the sql used to create the db-tables (since u plan to document it anyway later)?

will be useful/interesting in ordner see how u designed it and what kind of queries one will be able to use.

[/ QUOTE ]

Sorry, can't provide this until the public beta - the fields in the tables would give away too much functionality to potential competitors at this point.

I can give you a rough idea of table structure though

PokerHands table: describes a single hand

Players table: describes a single player

PlayerHands tables: 1 row per player per hand

CompiledResults: merged stats from players. Each player will have many rows in this table - for example, a player will have merged stats with multiple rows for 2 handed, 3 handed, 4 handed etc
HandHistories: every hand history in original format and in HMSF xml format.

There are a bunch of other lookup tables and secondary tables but these are the main ones.

rvg