sql open specification

[lusop]

Hi there,

Can I ask why there's not a open specification of the database schema? I really can't think about any reason and it would be really helpful for people creating their own sql reports.

Thanks

[netsrak]

You should find some parts of it in this area Custom Reports - Holdem Manager Forums

but so far we haven't published a complete database scheme.

[lusop]

Thanks for the reply. It should be useful, but you didn't answer my question.

Why there's not such a thing like a compete sql reference?

Many thanks

[fraac]

Hi. Is the SQL spec for HEM1 available yet? Would be very useful. Cheers.

[netsrak]

This is internal information which will not be published.
What you can do is enable SQL logging and see how statements work:
Close down HM and open the holdemmanager.config with notepad and change
<setting name="LogDatabaseCommands">False
To
<setting name="LogDatabaseCommands">True

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.